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
| 1964 | 8 |
|---|---|
| 1965 | 9 |
| 1966 | 13 |
| 1967 | 7 |
| 1968 | 9 |
| 1969 | 9 |
| 1970 | 6 |
| 1971 | 11 |
| 1972 | 9 |
| 1973 | 9 |
| 1974 | 13 |
| 1975 | 10 |
| 1976 | 7 |
| 1977 | 6 |
| 1978 | 10 |
| 1979 | 7 |
| 1980 | 9 |
| 1981 | 11 |
| 1982 | 8 |
| 1983 | 7 |
| 1984 | 7 |
| 1985 | 10 |
| 1986 | 8 |
| 1987 | 11 |
| 1988 | 9 |
| 1989 | 8 |
| 1990 | 6 |
| 1991 | 6 |
| 1992 | 4 |
| 1993 | 5 |
| 1994 | 6 |
| 1995 | 4 |
| 1996 | 5 |
| 1997 | 5 |
| 1998 | 4 |
| 1999 | 6 |
| 2000 | 8 |
| 2001 | 4 |
| 2002 | 5 |
| 2003 | 12 |
| 2004 | 7 |
| 2005 | 3 |
| 2006 | 2 |
| 2007 | 4 |
| 2008 | 2 |
| 2009 | 3 |
| 2010 | 4 |
| 2011 | 2 |
| 2012 | 4 |
| 2013 | 6 |
| 2014 | 4 |
| 2015 | 2 |
| 2016 | 3 |
| 2017 | 4 |
| 2018 | 2 |
| 2019 | 3 |
| 2020 | 5 |
| 2021 | 2 |
| 2022 | 3 |
| 2023 | 7 |
| 2024 | 1 |
| 2025 | 4 |
| 2026 | 3 |
Where
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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
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.NTSB 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.NTSB 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.NTSB CHI03LA269Accident · 2 fatalLimited investigationFinal reportHolden Pulsar · Willmar, MNThe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall/spin.NTSB 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.NTSB 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.NTSB CHI03FA219Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · Jackson, MNThe pilot's intentional flight into terrain as an act of suicide.NTSB 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.NTSB 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…NTSB 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.NTSB 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…NTSB 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…