Fatal NTSB investigations, 2012, 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
| 1964 | 12 |
|---|---|
| 1965 | 14 |
| 1966 | 18 |
| 1967 | 17 |
| 1968 | 14 |
| 1969 | 13 |
| 1970 | 14 |
| 1971 | 19 |
| 1972 | 20 |
| 1973 | 23 |
| 1974 | 19 |
| 1975 | 17 |
| 1976 | 14 |
| 1977 | 15 |
| 1978 | 16 |
| 1979 | 19 |
| 1980 | 20 |
| 1981 | 19 |
| 1982 | 13 |
| 1983 | 14 |
| 1984 | 12 |
| 1985 | 14 |
| 1986 | 15 |
| 1987 | 8 |
| 1988 | 8 |
| 1989 | 15 |
| 1990 | 22 |
| 1991 | 15 |
| 1992 | 13 |
| 1993 | 11 |
| 1994 | 8 |
| 1995 | 9 |
| 1996 | 13 |
| 1997 | 13 |
| 1998 | 10 |
| 1999 | 11 |
| 2000 | 10 |
| 2001 | 5 |
| 2002 | 10 |
| 2003 | 8 |
| 2004 | 3 |
| 2005 | 3 |
| 2006 | 12 |
| 2007 | 3 |
| 2008 | 4 |
| 2009 | 8 |
| 2010 | 5 |
| 2011 | 10 |
| 2012 | 8 |
| 2013 | 4 |
| 2014 | 7 |
| 2015 | 2 |
| 2016 | 3 |
| 2017 | 2 |
| 2018 | 11 |
| 2019 | 6 |
| 2020 | 3 |
| 2021 | 5 |
| 2022 | 2 |
| 2023 | 3 |
| 2024 | 2 |
| 2025 | 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\") = 2012
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.
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") = 2012 AND c."eventStateOrRegion" = 'MI' 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 CEN13LA086Accident · 1 fatalLimited investigationFinal reportBell 47G-2 · Walkerville, MIThe pilot's failure to maintain altitude while maneuvering, which resulted in a collision with trees. Contributing to the accident was the pilot's decision to fly at a low altitude, which did not provide enough margin to recover from the descent.NTSB CEN13FA069Accident · 1 fatalField investigationFinal reportCessna 310B · Mancelona, MIThe pilot's failure to maintain control of the airplane after a loss of right engine power for reasons that could not be determined because postaccident examination revealed no preimpact malfunction or anomaly that would have precluded normal operation.NTSB CEN13FA067Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Hillsdale, MIThe pilot's failure to maintain clearance from terrain during a straight-in night visual flight rules approach to land in hazy weather conditions. Contributing to the accident were the pilot's lack of recent night flying experience, the nonfunctional…NTSB CEN12FA601Accident · 1 fatalField investigationFinal reportAeronca 7AC · Brighton, MIThe pilot’s failure to maintain airspeed following a partial loss of engine power for reasons that could not be determined during postaccident examination, which resulted in an aerodynamic stall and loss of airplane control. Contributing to the severity of…NTSB CEN12LA578Accident · 2 fatalLimited investigationFinal reportDestiny XLT · Hart, MIThe partial deflation of the powered parachute canopy when the pilot flew the aircraft into an area with gusty wind conditions. Contributing to the accident were the modifications that changed the flying characteristics of the parachute.NTSB CEN12LA330Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-27 · Ionia, MIThe pilot's failure to maintain a proper airspeed in gusting wind conditions, which resulted in an inadvertent stall while maneuvering at an altitude that did not provide a margin for recovery.NTSB CEN12LA324Accident · 1 fatalLimited investigationFinal reportNorth American T-6G · Perry, MIThe pilot’s failure to maintain control while maneuvering at low altitude after takeoff, resulting in a collision with a barn.NTSB CEN12LA149Accident · 1 fatalLimited investigationFinal reportPipistrel Virus 912 · Ray, MIA loss of engine power due to fuel starvation for reasons that could not be determined because the postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.