NTSB investigations, 1965, MI
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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\") = 1965
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") = 1965 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 CHI66F0486Accident · No injuriesClosedCessna 210E · Reed City, MINTSB CHI66F0483Accident · No injuriesClosedPiper PA-28 · Iron Mt, MINTSB CHI66F0477Accident · No injuriesClosedCessna 182 · Pontiac, MINTSB CHI66A0059Accident · No injuriesClosedCurtiss-Wrt C-46 · Detroit, MINTSB CHI66F0449Accident · No injuriesClosedPiper PA-24 · Fraser, MINTSB CHI66F0458Accident · No injuriesClosedLuscombe 8E · Willis, MINTSB CHI66F0454Accident · No injuriesClosedCessna 150 · Kalamazoo, MINTSB CHI66F0467Accident · No injuriesClosedBeechcraft B35 · Cadillac, MINTSB CHI66A0055Accident · No injuriesClosedPiper PA-23 · Detroit, MINTSB CHI66F0448Accident · No injuriesClosedCessna 172 · Freeland, MINTSB CHI66F0455Accident · No injuriesClosedPiper PA-23 · Ionia, MINTSB CHI66F0459Accident · No injuriesClosedCessna 310B · Ypsilanti, MINTSB CHI66F0421Accident · No injuriesClosedPiper PA-23 · Houghton Lak, MINTSB CHI66F0420Accident · No injuriesClosedBeechcraft A23 · Howell, MINTSB CHI66F0406Accident · No injuriesClosedCessna 182 · Salem, MINTSB CHI66D0394Accident · No injuriesClosedBeechcraft 23 · Deckerville, MINTSB CHI66F0401Accident · Serious injuriesClosedLuscombe 8A · Salem, MINTSB CHI66F0422Accident · No injuriesClosedPiper J-3 · Laurium, MINTSB CHI66A0045Accident · 1 fatalClosedCessna 172E · St.Joseph, MINTSB CHI66F0402Accident · No injuriesClosedPiper PA-23 · Lansing, MINTSB CHI66F0408Accident · No injuriesClosedCessna 140 · Houghton, MINTSB CHI66D0395Accident · No injuriesClosedBeechcraft D-35 · Lake Angelus, MINTSB CHI66F0419Accident · No injuriesClosedErcoupe 415C · Three Oaks, MINTSB CHI66A0042Accident · 2 fatalClosedCessna 140 · Ralph, MINTSB CHI66F0366Accident · No injuriesClosedBeechcraft B35 · Lansing, MINTSB CHI66D0412Accident · No injuriesClosedCessna 210 · Detroit, MINTSB CHI66A0041Accident · 2 fatalClosedLear Jet 23 · Jackson, MINTSB CHI66F0380Accident · No injuriesClosedPiper PA-16 · Blissfield, MINTSB CHI66F0377Accident · 1 fatalClosedPiper J3C-65 · Saline, MINTSB CHI66F0352Accident · No injuriesClosedCessna 182 · Pontiac, MINTSB CHI66F0333Accident · Minor injuriesClosedPiper PA-22 · Wixom, MINTSB CHI66A0034Accident · 2 fatalClosedNavion A · Beaver Isle, MINTSB CHI66F0344Accident · No injuriesClosedNavion A · Freeland, MINTSB CHI66F0343Accident · No injuriesClosedPiper PA-22 · Lawrence, MINTSB CHI66F0321Accident · No injuriesClosedAircoupe A-2 · Freeland, MINTSB CHI66D0365Accident · Minor injuriesClosedCessna 195 · Fraser, MINTSB CHI66A0031Accident · 3 fatalClosedCessna 172 · White Cloud, MINTSB CHI66F0339Accident · No injuriesClosedBeechcraft A23 · East Lansing, MINTSB CHI66F0329Accident · No injuriesClosedStinson 108-1 · Grand Rapids, MINTSB CHI66F0303Accident · No injuriesClosedPiper PA-28 · Muskegon, MINTSB CHI66F0328Accident · Serious injuriesClosedPiper PA-16 · White Cloud, MINTSB CHI66F0309Accident · No injuriesClosedBeechcraft D-50 · Detroit, MINTSB CHI66F0336Accident · No injuriesClosedAeronca 7AC · Grand Ledge, MINTSB CHI66F0222Accident · Minor injuriesClosedPiper PA-28 · Owosso, MINTSB CHI66F0224Accident · No injuriesClosedBeechcraft D-18S · Detroit, MINTSB CHI66F0220Accident · No injuriesClosedChampion 7FC · Flushing, MINTSB CHI66F0196Accident · No injuriesClosedBeechcraft M-23 · White Cloud, MINTSB CHI66F0311Accident · Minor injuriesClosedPiper PA-28 · Saginaw, MINTSB CHI66F0207Accident · No injuriesClosedPiper PA-22 · Flushing, MINTSB CHI66F0304Accident · Serious injuriesClosedLuscombe 8C · Vicksburg, MI