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
2994487 2015-09-16 11:44:00 Indian School Rd / 33rd 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: 2994487
                  Microfilm: 0
           ADOTReceivedDate: 2015-09-26 00:00:00
                     Status: 200
           DataConv2008Flag: -1
               IncidentDate: 2015-09-16
           IncidentDateTime: 2015-09-16 11:44:00
               IncidentYear: 2015
              IncidentMonth: 9
          IncidentDayOfWeek: 4
               IncidentHour: 11
                OfficerNcic: 723
                  OfficerId: 4850
                 FileNumber: 201501785438
               ExtendedNcic: 723
        DamageOverLimitFlag: 1
            PhotosTakenFlag: -1
           PhotographerName: 
             PhotographerID: 0
         PhotographerAgency: 
    InvestigatedAtSceneFlag: -1
       DateTimeInvestigated: 2015-09-16 12:00:00
            CollisionManner: OTHER_97
             LightCondition: DAYLIGHT
          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: Indian School Rd
            CrossingFeature: 33rd Ave
                     Offset: 0.0583
         OffsetMeasuredFlag: 0
                 OffsetUnit: 1
                      MPNum: 0
                   MPOffset: 0
                     CityId: 214
                   CountyId: 13
                    StateId: 3
                  StateCode: AZ
                CountryCode: US
                   Latitude: 33.4949507896401
                  Longitude: -112.128942416393
          ValidLocationFlag: 1
        LocationToolVersion: OCT2013
        HESIntersectionFlag: -1
           IntersectionFlag: 1
        IntersectionRouteID: 11639
       IntersectionATISCode: 07  33RD                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: 2
         SecondaryCrashFlag: -1
*************************** 1. row ***************************
         IncidentID: 2994487
             UnitID: 5585191
         UnitNumber: 2
           PersonID: 8357188
       PersonNumber: 1
         PersonType: DRIVER
            ZipCode: 0
                Age: 37
                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
*************************** 2. row ***************************
         IncidentID: 2994487
             UnitID: 5584288
         UnitNumber: 1
           PersonID: 8357750
       PersonNumber: 1
         PersonType: PEDALCYCLIST
            ZipCode: 0
                Age: 30
                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: -1
          TestTypeA: MINUS_1
        DrugUseFlag: -1
           DrugType: MINUS_1
          TestTypeD: -1
    TransportSource: NOT_TRANSPORTED_0
      TransportedTo: ST JOSEPH'S HOSPITAL / R15
         InjuryArea: 99
         InjuryDesc: 99
         Violation1: FAILED_TO_YIELD_RIGHT_OF_WAY_103
         Violation2: NOT_APPLICABLE_0
*************************** 1. row ***************************
        IncidentID: 2994487
            UnitID: 5584288
        UnitNumber: 1
          UnitType: PEDALCYCLIST
   TravelDirection: NORTH
     RoadAlignment: STRAIGHT
         RoadGrade: LEVEL
              Lane: LANE_3
        UnitAction: GOING_STRAIGHT_AHEAD
  MostHarmfulEvent: NOT_REPORTED_255
     HitAndRunFlag: 0
    RoadCondition1: UNKNOWN_99
    RoadCondition2: NO_CONTRIBUTING_CIRCUMSTANCES
 EnvConditionDesc1: UNKNOWN
 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: -1
eDistractedDriving: UNDEFINED_MINUS_1
*************************** 2. row ***************************
        IncidentID: 2994487
            UnitID: 5585191
        UnitNumber: 2
          UnitType: DRIVER
   TravelDirection: WEST
     RoadAlignment: STRAIGHT
         RoadGrade: LEVEL
              Lane: LANE_3
        UnitAction: GOING_STRAIGHT_AHEAD
  MostHarmfulEvent: NOT_REPORTED_255
     HitAndRunFlag: 0
    RoadCondition1: NOT_APPLICABLE_MINUS_1
    RoadCondition2: NO_CONTRIBUTING_CIRCUMSTANCES
 EnvConditionDesc1: STOPPED_PARKED_VEHICLE
 EnvConditionDesc2: 
  VehicleStateCode: AZ
           RegYear: 1900
     BodyStyleDesc: PASSENGER_4DSD_SEDAN_4_DR
          MakeDesc: MAZD_MAZDA
         ColorDesc: RED_RED
           BusFlag: 0
          GVWRFlag: 0
        HazmatFlag: 0
       PostedSpeed: 40
    EstimatedSpeed: 15
      DisabledFlag: 0
        DamageArea: UNDEFINED_MINUS_1
       DefectDesc1: No Data
       DefectDesc2: 
    EventSequence1: PEDALCYCLE
    EventSequence2: BLANK_0
    EventSequence3: BLANK_0
    EventSequence4: BLANK_0
       ControlType: TRAFFIC_CONTROL_SIGNAL
 SurfaceCondition1: DRY
 DistractedDriving: -1
eDistractedDriving: UNDEFINED_MINUS_1