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
2986527 2015-06-08 05:04:00 US Highway 160  / 
number of bicyclists / drivers / pedestrians involved: 2 / 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: 2986527
                  Microfilm: 0
           ADOTReceivedDate: 2015-08-31 00:00:00
                     Status: 200
           DataConv2008Flag: -1
               IncidentDate: 2015-06-08
           IncidentDateTime: 2015-06-08 05:04:00
               IncidentYear: 2015
              IncidentMonth: 6
          IncidentDayOfWeek: 2
               IncidentHour: 5
                OfficerNcic: 799
                  OfficerId: 7758
                 FileNumber: 2015025624
               ExtendedNcic: 300
        DamageOverLimitFlag: 1
            PhotosTakenFlag: -1
           PhotographerName: 
             PhotographerID: 0
         PhotographerAgency: 
    InvestigatedAtSceneFlag: -1
       DateTimeInvestigated: 1900-01-01 00:00:00
            CollisionManner: OTHER_97
             LightCondition: DAWN
          FirstHarmfulEvent: PEDALCYCLE
       FirstHarmfulLocation: NOT_REPORTED_255
                 TotalUnits: 3
             TotalMotorists: 1
          TotalNonMotorists: 2
              TotalInjuries: 1
            TotalFatalities: 1
     TotalMotoristsInjuries: 0
  TotalNonMotoristsInjuries: 1
   TotalMotoristsFatalities: 0
TotalNonMotoristsFatalities: 1
             InjurySeverity: 5
       MedicalTransportFlag: 1
          FatalAccidentFlag: 1
                TowAwayFlag: 1
              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: US Highway 160 
            CrossingFeature: 
                     Offset: 0.8
         OffsetMeasuredFlag: 0
                 OffsetUnit: 1
                      MPNum: 324
                   MPOffset: 0.8
                     CityId: 999
                   CountyId: 5
                    StateId: 3
                  StateCode: AZ
                CountryCode: US
                   Latitude: 36.1336179113201
                  Longitude: -111.18061955836
          ValidLocationFlag: 1
        LocationToolVersion: OCT2013
        HESIntersectionFlag: -1
           IntersectionFlag: 1
        IntersectionRouteID: 0
       IntersectionATISCode:                                 
             TrafficWayType: TWO_WAY_NOT_DIVIDED
           IntersectionType: NOT_AT_INTERSECTION_0
           JunctionRelation: NOT_JUNCTION_RELATED_0
                    Weather: CLEAR
    PropertyDamageOwnerCode: NOT_APPLICABLE_MINUS_1
     PropertyDamageDescCode: -1
            OffsetDirection: 0
         SecondaryCrashFlag: 0
*************************** 1. row ***************************
         IncidentID: 2986527
             UnitID: 5569712
         UnitNumber: 1
           PersonID: 8336100
       PersonNumber: 1
         PersonType: DRIVER
            ZipCode: 0
                Age: 34
                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: EXCEEDED_LAWFUL_SPEED
         Violation2: SPEED_TOO_FAST_FOR_CONDITIONS
*************************** 2. row ***************************
         IncidentID: 2986527
             UnitID: 5569480
         UnitNumber: 2
           PersonID: 8336514
       PersonNumber: 1
         PersonType: PEDALCYCLIST
            ZipCode: 0
                Age: 39
                Sex: M
       SeatPosition: 255
       SafetyDevice: UNKNOWN_99
             Airbag: UNKNOWN_99
       InjuryStatus: FATAL
           Ejection: NOT_REPORTED_255
         Extraction: NOT_REPORTED_255
NonMotoristLocation: SHOULDER
     AlcoholUseFlag: -1
          BACResult: -1
          TestTypeA: MINUS_1
        DrugUseFlag: -1
           DrugType: MINUS_1
          TestTypeD: -1
    TransportSource: NOT_TRANSPORTED_0
      TransportedTo: TCRMC / SACRED MTN MEDICAL
         InjuryArea: 99
         InjuryDesc: 99
         Violation1: NO_IMPROPER_ACTION
         Violation2: NOT_APPLICABLE_0
*************************** 3. row ***************************
         IncidentID: 2986527
             UnitID: 5569736
         UnitNumber: 3
           PersonID: 8336515
       PersonNumber: 1
         PersonType: PEDALCYCLIST
            ZipCode: 0
                Age: 40
                Sex: M
       SeatPosition: 255
       SafetyDevice: UNKNOWN_99
             Airbag: UNKNOWN_99
       InjuryStatus: NON_INCAPACITATING_INJURY
           Ejection: NOT_REPORTED_255
         Extraction: NOT_REPORTED_255
NonMotoristLocation: SHOULDER
     AlcoholUseFlag: -1
          BACResult: -1
          TestTypeA: MINUS_1
        DrugUseFlag: -1
           DrugType: MINUS_1
          TestTypeD: -1
    TransportSource: NOT_TRANSPORTED_0
      TransportedTo: TCRMC / SACRED MTN MEDICAL
         InjuryArea: 99
         InjuryDesc: 99
         Violation1: NO_IMPROPER_ACTION
         Violation2: NOT_APPLICABLE_0
*************************** 1. row ***************************
        IncidentID: 2986527
            UnitID: 5569480
        UnitNumber: 2
          UnitType: PEDALCYCLIST
   TravelDirection: EAST
     RoadAlignment: STRAIGHT
         RoadGrade: LEVEL
              Lane: LANE_1
        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: NO_CONTROLS_0
 SurfaceCondition1: DRY
 DistractedDriving: 0
eDistractedDriving: NOT_DISTRACTED_0
*************************** 2. row ***************************
        IncidentID: 2986527
            UnitID: 5569712
        UnitNumber: 1
          UnitType: DRIVER
   TravelDirection: EAST
     RoadAlignment: STRAIGHT
         RoadGrade: LEVEL
              Lane: LANE_1
        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: TRUCK_1TPU_PICKUP_1_TON
          MakeDesc: FORD_FORD
         ColorDesc: WHI_WHITE
           BusFlag: 0
          GVWRFlag: 1
        HazmatFlag: 0
       PostedSpeed: 65
    EstimatedSpeed: 85
      DisabledFlag: 0
        DamageArea: UNDEFINED_MINUS_1
       DefectDesc1: NO_CONTRIBUTING_CIRCUMSTANCES
       DefectDesc2: 
    EventSequence1: PEDALCYCLE
    EventSequence2: PEDALCYCLE
    EventSequence3: BLANK_0
    EventSequence4: BLANK_0
       ControlType: NO_CONTROLS_0
 SurfaceCondition1: DRY
 DistractedDriving: 4
eDistractedDriving: OTHER_ACTIVITY_ELECTRONIC_DEVICE
*************************** 3. row ***************************
        IncidentID: 2986527
            UnitID: 5569736
        UnitNumber: 3
          UnitType: PEDALCYCLIST
   TravelDirection: EAST
     RoadAlignment: STRAIGHT
         RoadGrade: LEVEL
              Lane: LANE_1
        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: NO_CONTROLS_0
 SurfaceCondition1: DRY
 DistractedDriving: 0
eDistractedDriving: NOT_DISTRACTED_0