NTSB investigations, 2002, MI

14 cases where the phase of flight was Enroute.

Cases per year

19632026
NTSB investigations, 2002, MI per year, 1963–2026: 734 cases
19631
196412
196515
196620
196719
196826
196921
197033
197124
197226
197334
197426
197517
197626
197715
197821
197923
198019
198116
198211
198311
198414
198516
198616
198712
198811
19899
199013
199110
199215
199313
19949
199513
199612
199713
19988
19997
20009
200110
200214
20039
20045
200510
20068
20073
20086
20096
20107
20112
20121
20132
20142
20154
20162
20171
20181
20196
20201
20216
20224
20233
20242
20252
20261

Latest cases

Query with SQL
duckdb -csv -c "WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
    crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
    current_codes AS (
      SELECT e.case_mkey, TRY_CAST(e.\"tier1Number\" AS INTEGER) AS code,
        row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e.\"isDefiningEvent\", false) DESC, e.position) AS n
      FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
      WHERE e.aircrafts_position = 1 AND e.\"tier1Number\" GLOB '[1-9][0-9]*'
        AND (e.\"isDefiningEvent\" OR e.case_mkey IN (SELECT \"mKey\" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE \"isPre1982\"))
    ),
    phases AS (
      SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
      FROM current_codes WHERE n = 1
      UNION ALL
      SELECT o.case_mkey, 'older', o.\"phaseOfFlightCode\", w.main
      FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o.\"phaseOfFlightCode\"
      WHERE o.aircrafts_position = 1 AND o.\"occurrenceNumber\" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
    ),
    case_phases AS (
      SELECT p.*, c.\"eventDate\", c.\"highestInjuryLevel\" = 'Fatal' AS fatal, a.aircraft_model_code
      FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = p.case_mkey
      LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
      WHERE c.\"eventDate\" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
    )
  SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
  FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
  WHERE year(c.\"eventDate\") = 2002
    AND c.\"eventStateOrRegion\" = 'MI' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 400)
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB CHI03LA043Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Carleton, MIThe #2 cylinder exhaust valve failed due to undetermined reasons. A factor associated with the accident was the soft terrain encountered during the forced landing.Dec 22, 2002 · N8555W · Substantial damageNTSB CHI03LA029Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Stalwart, MIThe pilot's improper fuel management during the flight and the pilot's improper decision not to select the outboard fuel tank when a loss of engine power was experienced, resulting in fuel starvation, a sustained loss of engine power, and subsequent forced…Nov 23, 2002 · N5985Y · Substantial damageNTSB CHI03LA006Accident · No injuriesLimited investigationFinal reportWolf Rotorway Exec-162F · Gregory, MIFailure of the secondary drive shaft, which resulted in a complete loss of power to the main rotor, and a high forward airspeed on touchdown, causing the helicopter to flip forward.Oct 7, 2002 · N1955Z · Substantial damageNTSB CHI02IA275Incident · No injuriesIncident investigationFinal reportSaab-Scania 340A · Detroit, MIA malfunctioning yaw damper.Sep 4, 2002 · N110XJ · No damageNTSB CHI02FA262Accident · 3 fatalField investigationFinal reportPiper PA-28R-180 · Newaygo, MIThe altitude/clearance disregarded by the pilot and his ostentatious display. The wire and low altitude flight were a contributing factor.Aug 28, 2002 · N4988J · DestroyedNTSB CHI02LA256Accident · Serious injuriesLimited investigationFinal reportEnstrom 280C · Coopersville, MIThe pilot's failure to maintain clearance from the transmission wires. Additional factors were the transmission wires and the sunglare.Aug 25, 2002 · N51689 · Substantial damageNTSB CHI02FA231Accident · 3 fatalField investigationFinal reportPiper PA-46-350P · Benton Harbor, MIThe pilot's failure to maintain airspeed above stall speed resulting in a stall/spin. Additional causes were the pilot not maintaining best glide airspeed and optimal glidepath following the loss of engine power. A factor to the accident was the engine…Aug 4, 2002 · N316PM · Substantial damageNTSB CHI02LA218Accident · Serious injuriesLimited investigationFinal reportCessna TR182 · Copemish, MIThe in-flight engine and cabin fire caused by a fatigue fracture of the left exhaust stack assembly. An additional cause was the part's inadequate design by the aftermarket part manufacturer. A factor to the accident was the soft field in which the emergency…Jul 27, 2002 · N756CS · DestroyedNTSB CHI02FA234Accident · No injuriesField investigationFinal reportPiper PA-28-180 · Macomb, MIThe cracked vertical stabilizer and the unapproved maintenance modification to the rudder by company maintenance personnel.Jul 20, 2002 · N16319 · Substantial damageNTSB CHI02LA187Accident · No injuriesLimited investigationFinal reportCessna 152 · Gregory, MIAn improper decision by the pilot due to a failure to land at an intermediate airport, and the unsuitable terrain for a forced landing encountered. Contributing factors were the pilot's disorientation (becoming lost), fuel exhaustion, soft terrain encountered…Jul 10, 2002 · N621AF · Substantial damageNTSB CHI02FA233Accident · No injuriesField investigationFinal reportPiper PA-28-180 · Macomb, MIThe cracked vertical stabilizer and the unapproved maintenance modification to the rudder by company maintenance personnel.Jun 9, 2002 · N56136 · Substantial damageNTSB CHI02FA088Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Niles, MIFlight into known adverse weather conditions by the pilot and the spatial disorientation of pilot. Contributing factors were the lack of certification by the pilot and the weather conditions.Mar 8, 2002 · N5246T · DestroyedNTSB CHI02FA067Accident · 1 fatalField investigationFinal reportCessna 402B · Bronson, MIThe maneuver to avoid the utility wire while maneuvering resulting in an inadvertent stall and subsequent impact with the ground. Factors were the pilot's inadvertent activation of the elevator trim, resulting in a loss of control during flight in instrument…Jan 23, 2002 · N371JD · DestroyedNTSB CHI02LA060Accident · Serious injuriesLimited investigationFinal reportCessna 414A · Sturgis, MIthe inadequate in-flight emergency planning/decision, the checklist not followed and excessive approach altitude by the pilot. Contributing factors were the loose oil return line and weather.Jan 6, 2002 · N6560C · Substantial damage