Fatal NTSB investigations, 2003, MN

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, 2003, MN per year, 1964–2026: 391 cases
19648
19659
196613
19677
19689
19699
19706
197111
19729
19739
197413
197510
19767
19776
197810
19797
19809
198111
19828
19837
19847
198510
19868
198711
19889
19898
19906
19916
19924
19935
19946
19954
19965
19975
19984
19996
20008
20014
20025
200312
20047
20053
20062
20074
20082
20093
20104
20112
20124
20136
20144
20152
20163
20174
20182
20193
20205
20212
20223
20237
20241
20254
20263

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\") = 2003
    AND c.\"eventStateOrRegion\" = 'MN' 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 CHI04LA007Accident · 1 fatalLimited investigationFinal reportAviat Pitts S-2B · Cromwell, MNThe altitude/clearance not maintained by the pilot while performing aerobatic maneuvers. Contributing factors were the planning/decision to perform an aerobatic maneuver at a low altitude.Oct 10, 2003 · N68PS · DestroyedNTSB CHI03FA296Accident · 2 fatalField investigationFinal reportBeech 58P · Grand Marais, MNThe continued descent below minimum descent altitude and the altitude/clearance not maintained by the pilot during approach to the airport. The low ceiling was a contributing factor.Aug 28, 2003 · N285V · DestroyedNTSB CHI03FA284Accident · 3 fatalField investigationFinal reportCessna 172S · Lake Elmo, MNBoth pilots failed to maintain adequate visual lookout and did not maintain clearance from the other aircraft.Aug 22, 2003 · N53033 · 2 aircraft · DestroyedNTSB CHI03LA269Accident · 2 fatalLimited investigationFinal reportHolden Pulsar · Willmar, MNThe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall/spin.Aug 16, 2003 · N78DT · DestroyedNTSB CHI03FA246Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Clarkfield, MNThe pilot not maintaining altitude/clearance from terrain and his continued VFR flight into IMC during cruise flight. A factor was the low ceilings.Aug 5, 2003 · N4577T · DestroyedNTSB CHI03LA242Accident · 1 fatalLimited investigationFinal reportTeratorn · Elbow Lake, MNThe pilot's intentional flight into known fog and failure to maintain aircraft control during cruise flight. A factor was the fog, and the low altitude flight.Aug 2, 2003 · UNREG · DestroyedNTSB CHI03FA219Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · Jackson, MNThe pilot's intentional flight into terrain as an act of suicide.Jul 21, 2003 · N33774 · DestroyedNTSB CHI03LA216Accident · 1 fatalLimited investigationFinal reportCessna 172H · Isle, MNThe pilot's failure to maintain adequate airspeed which resulted in a stall. The trees, high density altitude, and the soft field were additional factors.Jul 18, 2003 · N1606F · DestroyedNTSB CHI03LA213Accident · 1 fatalLimited investigationFinal reportAllenberg Swick BC 12-D · Winsted, MNThe inadequate aircraft preflight by both pilots of the closed main fuel valve which led to fuel starvation of the engine. Additional causes were the lack of recent experience in the accident airplane and the inadvertent stall by both pilots after a loss of…Jul 16, 2003 · N7895A · DestroyedNTSB CHI03LA117Accident · 1 fatalLimited investigationFinal reportSmith Rans S-7 · Baudette, MNThe pilot's failure to maintain adequate airspeed which resulted in a stall. A contributing factor was the low altitude maneuver by the student pilot.Apr 26, 2003 · N272T · DestroyedNTSB CHI03FA086Accident · 3 fatalField investigationFinal reportCessna 172N · Foley, MNThe pilot's continued visual flight into instrument meteorological conditions which led to spatial disorientation and subsequent impact with the ground. Contributing factors was the pilot's lack of instrument rating, the pilot's disregard of the preflight…Mar 16, 2003 · N5315D · DestroyedNTSB CHI03FA057Accident · 2 fatalField investigationFinal reportCirrus Design SR-22 · Hill City, MNSpatial disorientation experienced by the pilot, due to a lack of visual references, and a failure to maintain altitude. Contributing factors were the pilot's improper decision to attempt flight into marginal VFR conditions, his inadvertent flight into…Jan 18, 2003 · N9523P · Destroyed