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
2984323 2015-08-20 21:46:00 Olive Ave / 91st Ave
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: 2984323
                  Microfilm: 0
           ADOTReceivedDate: 2015-08-24 00:00:00
                     Status: 200
           DataConv2008Flag: -1
               IncidentDate: 2015-08-20
           IncidentDateTime: 2015-08-20 21:46:00
               IncidentYear: 2015
              IncidentMonth: 8
          IncidentDayOfWeek: 5
               IncidentHour: 21
                OfficerNcic: 721
                  OfficerId: 9666
                 FileNumber: 201500058547
               ExtendedNcic: 721
        DamageOverLimitFlag: 1
            PhotosTakenFlag: -1
           PhotographerName: 
             PhotographerID: 0
         PhotographerAgency: 
    InvestigatedAtSceneFlag: -1
       DateTimeInvestigated: 2015-08-20 21:00:00
            CollisionManner: OTHER_97
             LightCondition: DARK_LIGHTED
          FirstHarmfulEvent: PEDALCYCLE
       FirstHarmfulLocation: NOT_REPORTED_255
                 TotalUnits: 2
             TotalMotorists: 1
          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: Olive Ave
            CrossingFeature: 91st Ave
                     Offset: 0.0114
         OffsetMeasuredFlag: 0
                 OffsetUnit: 1
                      MPNum: 0
                   MPOffset: 0
                     CityId: 211
                   CountyId: 13
                    StateId: 3
                  StateCode: AZ
                CountryCode: US
                   Latitude: 33.5662763406022
                  Longitude: -112.254898974769
          ValidLocationFlag: 1
        LocationToolVersion: OCT2013
        HESIntersectionFlag: 1
           IntersectionFlag: 1
        IntersectionRouteID: 12235
       IntersectionATISCode: 07  91ST                AVE     
             TrafficWayType: TWO_WAY_DIVIDED_POSITIVE_MEDIAN_BARRIER
           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: 2984323
             UnitID: 5565138
         UnitNumber: 2
           PersonID: 8329245
       PersonNumber: 1
         PersonType: DRIVER
            ZipCode: 0
                Age: 80
                Sex: M
       SeatPosition: 11
       SafetyDevice: SHOULDER_AND_LAP_BELT
             Airbag: UNKNOWN_99
       InjuryStatus: NO_INJURY
           Ejection: NOT_EJECTED
         Extraction: NOT_APPLICABLE_0
NonMotoristLocation: NOT_REPORTED_255
     AlcoholUseFlag: 1
          BACResult: 0.043
          TestTypeA: PRELIMINARY_BREATH_TEST
        DrugUseFlag: 0
           DrugType: MINUS_1
          TestTypeD: -1
    TransportSource: MINUS_1
      TransportedTo: No Data
         InjuryArea: -1
         InjuryDesc: -1
         Violation1: NO_IMPROPER_ACTION
         Violation2: NOT_APPLICABLE_0
*************************** 2. row ***************************
         IncidentID: 2984323
             UnitID: 5565062
         UnitNumber: 1
           PersonID: 8329971
       PersonNumber: 1
         PersonType: PEDALCYCLIST
            ZipCode: 0
                Age: 63
                Sex: M
       SeatPosition: 255
       SafetyDevice: NONE_USED
             Airbag: UNKNOWN_99
       InjuryStatus: FATAL
           Ejection: NOT_REPORTED_255
         Extraction: NOT_REPORTED_255
NonMotoristLocation: IN_ROADWAY_NOT_IN_A_CROSSWALK_OR_INTERSECTION
     AlcoholUseFlag: 1
          BACResult: 0
          TestTypeA: BLOOD_TEST
        DrugUseFlag: 1
           DrugType: AMPHETAMINE
          TestTypeD: 101
    TransportSource: NOT_TRANSPORTED_0
      TransportedTo: WEST VALLEY HOSPITAL / AMBULANCE
         InjuryArea: 99
         InjuryDesc: 99
         Violation1: DISREGARDED_TRAFFIC_SIGNAL
         Violation2: FAILED_TO_YIELD_RIGHT_OF_WAY_103
*************************** 1. row ***************************
        IncidentID: 2984323
            UnitID: 5565062
        UnitNumber: 1
          UnitType: PEDALCYCLIST
   TravelDirection: EAST
     RoadAlignment: STRAIGHT
         RoadGrade: LEVEL
              Lane: LANE_3
        UnitAction: OTHER_97
  MostHarmfulEvent: NOT_REPORTED_255
     HitAndRunFlag: 0
    RoadCondition1: OTHER_97
    RoadCondition2: NO_CONTRIBUTING_CIRCUMSTANCES
 EnvConditionDesc1: OTHER
 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: 2984323
            UnitID: 5565138
        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: FORD_FORD
         ColorDesc: SIL_SILVER
           BusFlag: 0
          GVWRFlag: 0
        HazmatFlag: 0
       PostedSpeed: 40
    EstimatedSpeed: 30
      DisabledFlag: 0
        DamageArea: UNDEFINED_MINUS_1
       DefectDesc1: NO_CONTRIBUTING_CIRCUMSTANCES
       DefectDesc2: 
    EventSequence1: PEDALCYCLE
    EventSequence2: BLANK_0
    EventSequence3: BLANK_0
    EventSequence4: BLANK_0
       ControlType: NO_CONTROLS_0
 SurfaceCondition1: DRY
 DistractedDriving: 99
eDistractedDriving: UNKNOWN_DISTRACTION_99