NTSB investigations, 1964, MI
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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
| 1962 | 1 |
|---|---|
| 1963 | 1 |
| 1964 | 145 |
| 1965 | 153 |
| 1966 | 169 |
| 1967 | 193 |
| 1968 | 174 |
| 1969 | 182 |
| 1970 | 176 |
| 1971 | 159 |
| 1972 | 150 |
| 1973 | 149 |
| 1974 | 141 |
| 1975 | 115 |
| 1976 | 131 |
| 1977 | 106 |
| 1978 | 121 |
| 1979 | 118 |
| 1980 | 98 |
| 1981 | 116 |
| 1982 | 87 |
| 1983 | 101 |
| 1984 | 91 |
| 1985 | 82 |
| 1986 | 86 |
| 1987 | 57 |
| 1988 | 63 |
| 1989 | 69 |
| 1990 | 86 |
| 1991 | 65 |
| 1992 | 66 |
| 1993 | 60 |
| 1994 | 52 |
| 1995 | 56 |
| 1996 | 58 |
| 1997 | 52 |
| 1998 | 51 |
| 1999 | 50 |
| 2000 | 46 |
| 2001 | 62 |
| 2002 | 44 |
| 2003 | 50 |
| 2004 | 39 |
| 2005 | 43 |
| 2006 | 48 |
| 2007 | 36 |
| 2008 | 32 |
| 2009 | 35 |
| 2010 | 30 |
| 2011 | 34 |
| 2012 | 38 |
| 2013 | 29 |
| 2014 | 31 |
| 2015 | 26 |
| 2016 | 24 |
| 2017 | 22 |
| 2018 | 28 |
| 2019 | 23 |
| 2020 | 22 |
| 2021 | 29 |
| 2022 | 17 |
| 2023 | 21 |
| 2024 | 21 |
| 2025 | 26 |
| 2026 | 19 |
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\") = 1964
AND c.\"eventStateOrRegion\" = 'MI' AND c.\"eventCountry\" = 'USA'
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") = 1964 AND c."eventStateOrRegion" = 'MI' AND c."eventCountry" = 'USA' 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 UNK65X1189Accident · 4 fatalClosedCurtis-Writ C-46A · Detroit, MINTSB UNK65X1169Accident · No injuriesClosedBeechraft P35 · Allegan, MINTSB UNK65X1155Accident · Minor injuriesClosedBeechraft 35 · Waterford, MINTSB UNK65X1150Accident · 4 fatalClosedBellanca 14-13 · Detroit, MINTSB UNK65X1145Accident · Serious injuriesClosedLuscombe 8A · Grand Haven, MINTSB UNK65X1051Accident · No injuriesClosedBeechraft C45H · Harbor Sprgs, MINTSB UNK65X1040Accident · No injuriesClosedTaylorcraft BC12D · Charlotte, MINTSB UNK65X1037Accident · No injuriesClosedBeechraft D18S · Muskegon, MINTSB UNK65X0953Accident · No injuriesClosedCessna 150 · Ypsilanti, MINTSB UNK65X0891Accident · No injuriesClosedErcoupe 415C · Big Rapids, MINTSB UNK65X0873Accident · No injuriesClosedBeechcraft 35-B33 · Pontiac, MINTSB UNK65X0838Accident · No injuriesClosedPiper J3 · Clinton, MINTSB UNK65X0832Accident · No injuriesClosedPiper PA24 · Hillsdale, MINTSB UNK65X0791Accident · No injuriesClosedPiper PA22 · Allegan, MINTSB UNK65X0768Accident · No injuriesClosedCurtiss C-46A · Inkster, MINTSB UNK65X0762Accident · No injuriesClosedCessna 172 · Cedar Lake, MINTSB UNK65X0757Accident · No injuriesClosedArgosy AW-650 · Gwinn, MINTSB UNK65X0747Accident · No injuriesClosedCessna 150 · Detroit, MINTSB UNK65X0727Accident · 4 fatalClosedPiper PA22 · Beaverton, MINTSB UNK65X0714Accident · No injuriesClosedAeronca 11AC · Ontanagon, MINTSB UNK65X0679Accident · No injuriesClosedCanadair CL-44 · Detroit, MINTSB UNK65X0676Accident · No injuriesClosedCessna 172E · Detroit, MINTSB UNK65X0674Accident · Minor injuriesClosedStinson 108-1 · Greenville, MINTSB UNK65X0568Accident · No injuriesClosedStinson 10 · Troy, MINTSB UNK65X0520Accident · Serious injuriesClosedChampion 7AC · Schoolcraft, MINTSB UNK65X0512Accident · No injuriesClosedMooney M20C · Lansing, MINTSB UNK65X0505Accident · Serious injuriesClosedPiper PA22 · Plymouth, MINTSB UNK65X0453Accident · No injuriesClosedMooney M2OC · Bay City, MINTSB UNK65X0446Accident · No injuriesClosedPiper PA24 · Detroit, MINTSB UNK65X0416Accident · No injuriesClosedBeechraft D18S · Ypsilanti, MINTSB UNK65X0410Accident · No injuriesClosedBeechcraft G35 · Ann Arbor, MINTSB UNK65X0402Accident · No injuriesClosedCessna 175 · East Tawas, MINTSB UNK65X0382Accident · Serious injuriesClosedBell 47G2A · Battle Creek, MINTSB UNK65X0329Accident · No injuriesClosedCessna 140 · Houghton, MINTSB UNK65X0301Accident · Serious injuriesClosedMooney M20C · Birmingham, MINTSB UNK65X0273Accident · No injuriesClosedGrumman G164 · Milan, MINTSB UNK65X0229Accident · No injuriesClosedMaule M4 · Plymouth, MINTSB UNK65X0175Accident · No injuriesClosedPiper PA22 · Plymouth, MINTSB UNK64X4159Accident · Minor injuriesClosedNavion · Tawas City, MINTSB UNK64X4037Accident · No injuriesClosedBeechcraft B95 · Sault St Marie, MINTSB UNK64X3965Accident · No injuriesClosedMooney M20E · Reed City, MINTSB UNK64X3957Accident · 3 fatalClosedMooney M20 · Waterford, MINTSB UNK64X3900Accident · No injuriesClosedCessna 172 · Detroit, MINTSB UNK64X3797Accident · Minor injuriesClosedPiper PA22 · Saline, MINTSB UNK64X3659Accident · No injuriesClosedCessna 140 · Birmingham, MINTSB UNK64X3627Accident · No injuriesClosedCessna 172 · Birmingham, MINTSB UNK64X3613Accident · No injuriesClosedArgosy AW-650 · Oscoda, MINTSB UNK64X3610Accident · No injuriesClosedNavion B · Grand Haven, MINTSB UNK64X3604Accident · No injuriesClosedPiper PA12 · Marenisco, MINTSB UNK64X3575Accident · No injuriesClosedPiper PA12 · Plymouth, MI