Dump the full ADOT crash record by IncidentId

using sql server: azbikelaw.entrydns.org
dump another incident

incident not found in year 2009
incident not found in year 2010
incident not found in year 2011
incident not found in year 2012
incident not found in year 2013
incident not found in year 2014
incident not found in year 2015
incident not found in year 2016
3183636 2017-01-23 10:09:00 Indian School Rd / 07  3RD                 ST      
number of bicyclists / drivers / pedestrians involved: 1 / 1 / 0
Here is Stderr output (if any):

Query Results download:

*************************** 1. row ***************************
                 sF_Bicycle: 1
              sF_Pedestrian: 0
                sF_Motorist: 1
                sF_OtherUnk: 0
              sF_Motorcycle: 0
                 IncidentID: 3183636
                  Microfilm: 0
           ADOTReceivedDate: 2017-01-27 00:00:00
                     Status: 200
           DataConv2008Flag: -1
               IncidentDate: 2017-01-23
           IncidentDateTime: 2017-01-23 10:09:00
               IncidentYear: 2017
              IncidentMonth: 1
          IncidentDayOfWeek: 2
               IncidentHour: 10
                OfficerNcic: 723
                  OfficerId: 7687
                 FileNumber: 201700132891
               ExtendedNcic: 723
        DamageOverLimitFlag: 1
            PhotosTakenFlag: -1
           PhotographerName: 
             PhotographerID: 0
         PhotographerAgency: 
    InvestigatedAtSceneFlag: -1
       DateTimeInvestigated: 2017-01-23 11:00:00
            CollisionManner: OTHER_97
             LightCondition: DAYLIGHT
          FirstHarmfulEvent: PEDALCYCLE
       FirstHarmfulLocation: NOT_REPORTED_255
                 TotalUnits: 2
             TotalMotorists: 2
          TotalNonMotorists: 1
              TotalInjuries: 0
            TotalFatalities: 1
     TotalMotoristsInjuries: 0
  TotalNonMotoristsInjuries: 0
   TotalMotoristsFatalities: 0
TotalNonMotoristsFatalities: 1
             InjurySeverity: 5
       MedicalTransportFlag: 1
          FatalAccidentFlag: 1
                TowAwayFlag: 0
              NscReportable: FATALS_INJURIES_OR_PROPERTY_DAMAGE_OVER_1000
       SchoolBusRelatedFlag: 0
        WorkZoneRelatedFlag: 0
         WorkersPresentFlag: -1
     AlcoholInvolvementFlag: Not Available
        DrugInvolvementFlag: Not Available
              HazardousFlag: 0
              HitAndRunFlag: 0
                     OnRoad: Indian School Rd
            CrossingFeature: 07  3RD                 ST      
                     Offset: -0.0068
         OffsetMeasuredFlag: 0
                 OffsetUnit: 1
                      MPNum: 0
                   MPOffset: 0
                     CityId: 214
                   CountyId: 13
                    StateId: 3
                  StateCode: AZ
                CountryCode: US
                   Latitude: 33.4947782147376
                  Longitude: -112.069542242815
          ValidLocationFlag: 1
        LocationToolVersion: OCT2016
        HESIntersectionFlag: 1
           IntersectionFlag: 1
        IntersectionRouteID: 11735
       IntersectionATISCode: 07  3RD                 ST      
             TrafficWayType: TWO_WAY_DIVIDED_UNPROTECTED_PAINTED_4_FEET_MEDIAN
           IntersectionType: FOUR_WAY_INTERSECTION
           JunctionRelation: INTERSECTION_RELATED_NON_INTERCHANGE
                    Weather: CLOUDY
    PropertyDamageOwnerCode: NOT_APPLICABLE_MINUS_1
     PropertyDamageDescCode: -1
            OffsetDirection: 0
         SecondaryCrashFlag: 0
*************************** 1. row ***************************
         IncidentID: 3183636
             UnitID: 1717590066
         UnitNumber: 1
           PersonID: 1725832064
       PersonNumber: 1
         PersonType: PEDALCYCLIST
            ZipCode: 0
                Age: 76
                Sex: M
       SeatPosition: 255
       SafetyDevice: UNKNOWN_99
             Airbag: UNKNOWN_99
       InjuryStatus: FATAL
           Ejection: NOT_REPORTED_255
         Extraction: NOT_REPORTED_255
NonMotoristLocation: MARKED_CROSSWALK_AT_INTERSECTION
     AlcoholUseFlag: 1
          BACResult: 0
          TestTypeA: BLOOD_TEST
        DrugUseFlag: 1
           DrugType: NO_DRUGS_REPORTED_NEGATIVE
          TestTypeD: 101
    TransportSource: NOT_TRANSPORTED_0
      TransportedTo: SJH / PHX RESCUE 61
         InjuryArea: 99
         InjuryDesc: 99
         Violation1: DISREGARDED_TRAFFIC_SIGNAL
         Violation2: NOT_APPLICABLE_0
*************************** 2. row ***************************
         IncidentID: 3183636
             UnitID: 1717512410
         UnitNumber: 2
           PersonID: 1725896763
       PersonNumber: 1
         PersonType: DRIVER
            ZipCode: 0
                Age: 50
                Sex: M
       SeatPosition: 11
       SafetyDevice: SHOULDER_AND_LAP_BELT
             Airbag: UNKNOWN_99
       InjuryStatus: NO_INJURY
           Ejection: NOT_REPORTED_255
         Extraction: NOT_REPORTED_255
NonMotoristLocation: NOT_REPORTED_255
     AlcoholUseFlag: -1
          BACResult: -1
          TestTypeA: MINUS_1
        DrugUseFlag: -1
           DrugType: MINUS_1
          TestTypeD: -1
    TransportSource: MINUS_1
      TransportedTo: No Data
         InjuryArea: -1
         InjuryDesc: -1
         Violation1: NO_IMPROPER_ACTION
         Violation2: NOT_APPLICABLE_0
*************************** 3. row ***************************
         IncidentID: 3183636
             UnitID: 1717512410
         UnitNumber: 2
           PersonID: 1725961190
       PersonNumber: 2
         PersonType: PASSENGER
            ZipCode: 0
                Age: 70
                Sex: M
       SeatPosition: 43
       SafetyDevice: SHOULDER_AND_LAP_BELT
             Airbag: UNKNOWN_99
       InjuryStatus: NO_INJURY
           Ejection: NOT_REPORTED_255
         Extraction: NOT_REPORTED_255
NonMotoristLocation: NOT_REPORTED_255
     AlcoholUseFlag: -1
          BACResult: -1
          TestTypeA: MINUS_1
        DrugUseFlag: -1
           DrugType: MINUS_1
          TestTypeD: -1
    TransportSource: MINUS_1
      TransportedTo: No Data
         InjuryArea: -1
         InjuryDesc: -1
         Violation1: NOT_APPLICABLE_MINUS_1
         Violation2: NOT_APPLICABLE_0
*************************** 1. row ***************************
        IncidentID: 3183636
            UnitID: 1717590066
        UnitNumber: 1
          UnitType: PEDALCYCLIST
   TravelDirection: SOUTH
     RoadAlignment: STRAIGHT
         RoadGrade: LEVEL
              Lane: CROSSWALK_20
        UnitAction: GOING_STRAIGHT_AHEAD
  MostHarmfulEvent: NOT_REPORTED_255
     HitAndRunFlag: 0
    RoadCondition1: NO_CONTRIBUTING_CIRCUMSTANCES
    RoadCondition2: NO_CONTRIBUTING_CIRCUMSTANCES
 EnvConditionDesc1: NO_CONTRIBUTING_CIRCUMSTANCES
 EnvConditionDesc2: 
  VehicleStateCode: --
           RegYear: 1900
     BodyStyleDesc: No Data
          MakeDesc: No Data
         ColorDesc: No Data
           BusFlag: -1
          GVWRFlag: -1
        HazmatFlag: -1
       PostedSpeed: 0
    EstimatedSpeed: 0
      DisabledFlag: -1
        DamageArea: UNDEFINED_MINUS_1
       DefectDesc1: No Data
       DefectDesc2: 
    EventSequence1: MOTOR_VEHICLE_IN_TRANSPORT
    EventSequence2: BLANK_0
    EventSequence3: BLANK_0
    EventSequence4: BLANK_0
       ControlType: TRAFFIC_CONTROL_SIGNAL
 SurfaceCondition1: DRY
 DistractedDriving: 99
eDistractedDriving: UNKNOWN_DISTRACTION_99
*************************** 2. row ***************************
        IncidentID: 3183636
            UnitID: 1717512410
        UnitNumber: 2
          UnitType: DRIVER
   TravelDirection: EAST
     RoadAlignment: STRAIGHT
         RoadGrade: LEVEL
              Lane: LANE_3
        UnitAction: GOING_STRAIGHT_AHEAD
  MostHarmfulEvent: NOT_REPORTED_255
     HitAndRunFlag: 0
    RoadCondition1: NO_CONTRIBUTING_CIRCUMSTANCES
    RoadCondition2: NO_CONTRIBUTING_CIRCUMSTANCES
 EnvConditionDesc1: NO_CONTRIBUTING_CIRCUMSTANCES
 EnvConditionDesc2: 
  VehicleStateCode: AZ
           RegYear: 1900
     BodyStyleDesc: PASSENGER_12PU_PICKUP_1_2_TON
          MakeDesc: CHEV_CHEVROLET
         ColorDesc: WHI_WHITE
           BusFlag: 0
          GVWRFlag: 0
        HazmatFlag: 0
       PostedSpeed: 35
    EstimatedSpeed: 10
      DisabledFlag: 0
        DamageArea: UNDEFINED_MINUS_1
       DefectDesc1: NO_CONTRIBUTING_CIRCUMSTANCES
       DefectDesc2: 
    EventSequence1: PEDALCYCLE
    EventSequence2: BLANK_0
    EventSequence3: BLANK_0
    EventSequence4: BLANK_0
       ControlType: TRAFFIC_CONTROL_SIGNAL
 SurfaceCondition1: DRY
 DistractedDriving: 0
eDistractedDriving: NOT_DISTRACTED_0