Fatal NTSB investigations, 2002, MI

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Cases per year

19642026
Fatal NTSB investigations, 2002, MI per year, 1964–2026: 669 cases
196412
196514
196618
196717
196814
196913
197014
197119
197220
197323
197419
197517
197614
197715
197816
197919
198020
198119
198213
198314
198412
198514
198615
19878
19888
198915
199022
199115
199213
199311
19948
19959
199613
199713
199810
199911
200010
20015
200210
20038
20043
20053
200612
20073
20084
20098
20105
201110
20128
20134
20147
20152
20163
20172
201811
20196
20203
20215
20222
20233
20242
20253

Latest cases

Query with SQL
duckdb -csv -c "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.\"highestInjuryLevel\" = 'Fatal'
  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 CHI03LA037Accident · 1 fatalLimited investigationFinal reportStinson 108-1 · Frankenmuth, MIThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.Dec 12, 2002 · N8469K · DestroyedNTSB CHI03FAMS1Accident · 2 fatalMissing aircraftFinal reportCessna 175 · MIUndetermined. Missing aircraft.Nov 11, 2002 · N7091M · Substantial 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 CHI02LA244Accident · 1 fatalLimited investigationFinal reportPiper J3C-65 · Hillman, MIThe pilot's failure to maintain terrain clearance.Aug 12, 2002 · N6658H · DestroyedNTSB 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 CHI02FA228Accident · 1 fatalField investigationFinal reportAeronca 7AC · Caro, MIThe passenger became incapacitated as a result of a stroke which lead to the inadvertent interference with the flight controls.Aug 3, 2002 · N84546 · Substantial damageNTSB CHI02FA172Accident · 1 fatalField investigationFinal reportCessna 182A · Foster City, MIThe incapacitation of the pilot. A contributing factor was the pilot and medical examiner providing false information on the pilot's medical applications.Jun 17, 2002 · N5034D · DestroyedNTSB CHI02LA121Accident · 2 fatalLimited investigationFinal reportYoder GP-4 · Mount Pleasant, MIThe inadvertent stall/spin by the pilot-in-command.May 5, 2002 · N59JY · DestroyedNTSB 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 · Destroyed