NTSB investigations, 1976, MI
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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\") = 1976
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") = 1976 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 CHI77FEC08Accident · No injuriesClosedCessna 150 · Pontiac, MINTSB CHI77FEC07Accident · No injuriesClosedCessna 172 · Detroit, MINTSB CHI77FA020Accident · 2 fatalClosedCessna 411 · Mccomb Twp, MINTSB CHI77FA016Accident · 1 fatalClosedErco 415-C · Palo, MINTSB CHI77FEM13Accident · No injuriesClosedCessna 421B · Bellaire, MINTSB CHI77FEM12Accident · Serious injuriesClosedCessna 310 · Saginaw, MINTSB CHI77FEC05Accident · Minor injuriesClosedLuscombe 8F · Manchester, MINTSB CHI77FA008Accident · 2 fatalClosedCessna 310P · Muskegon, MINTSB CHI77DEC06Accident · No injuriesClosedPiper PA-28 · Hadley, MINTSB CHI77DEC04Accident · No injuriesClosedPiper PA-28 · Utica, MINTSB CHI77FEM10Accident · 1 fatalClosedScorpion 2 · Alston, MINTSB CHI77FA006Accident · 2 fatalClosedPiper PA-31 · Spring Lake, MINTSB CHI77FEM09Accident · No injuriesClosedPiper PA-28R · Harbor Springs, MINTSB CHI77FEC03Accident · No injuriesClosedCessna 205 · Utica, MINTSB CHI77FEM08Accident · No injuriesClosedCessna 150L · Sparta, MINTSB CHI77FEC02Accident · No injuriesClosedBellanca 17-30 · Flint, MINTSB CHI77FEC01Accident · No injuriesClosedHughes 369HS · Pickney, MINTSB CHI77FEM11Accident · No injuriesClosedSwearingen SA26T · Clare, MINTSB CHI77DEC09Incident · No injuriesClosedCessna 172 · Detroit, MINTSB CHI77FEM06Accident · No injuriesClosedCessna 150 · Lansing, MINTSB CHI77FEM04Accident · Serious injuriesClosedNavion A · St. James, MINTSB CHI77FEM01Accident · No injuriesClosedJeanies Teenie · Frankfort, MINTSB UNK77X0100Accident · Minor injuriesClosedPiper PA-22 · Coral, MINTSB CHI77FEM05Accident · No injuriesClosedBeech B23 · Ironwood, MINTSB CHI77FEM03Accident · No injuriesClosedCessna 172 · Watersmeet, MINTSB CHI77AC095Accident · 2 fatalClosedBeech 95 · L'Anse, MINTSB CHI76FEC66Accident · No injuriesClosedPiper PA-28 · New Hudson, MINTSB CHI76FEM61Accident · No injuriesClosedCessna 172M · Gobles, MINTSB CHI76FEC65Accident · Minor injuriesClosedCessna 150H · Willis, MINTSB CHI76DEM60Accident · No injuriesClosedWeilbuilt WB-4 · Thomas City, MINTSB CHI76FEC64Accident · No injuriesClosedStinson 108-3 · Deckerville, MINTSB CHI76AC091Accident · 6 fatalClosedBeech D55 · Coldwater, MINTSB CHI76FEC62Accident · No injuriesClosedPiper PA-28 · Ann Arbor, MINTSB CHI76FEM63Accident · No injuriesClosedBeech D-17S · Mt Pleasant, MINTSB CHI76FEC63Accident · No injuriesClosedPiper PA-32 · Romeo, MINTSB CHI76FEC61Accident · Minor injuriesClosedAeronca 7AC · Owosso, MINTSB CHI76FET51Accident · Minor injuriesClosedPiper J3C-65 · Dowagiac, MINTSB CHI76FEM59Accident · Minor injuriesClosedPiper PA-22 · Delton, MINTSB CHI76FEC60Accident · No injuriesClosedBeech V35B · Troy, MINTSB CHI76DEM64Accident · No injuriesClosedOsprey I · Vicksburg, MINTSB CHI76FEM58Accident · No injuriesClosedStinson 108-3 · Cedar Springs, MINTSB CHI76DEM57Accident · No injuriesClosedSchemp SH1 · Lansing, MINTSB CHI76DBM56Accident · No injuriesClosedCessna 150 · Chesaning, MINTSB CHI76FEM62Accident · Minor injuriesClosedPiper PA-28 · Gaylord, MINTSB CHI76FEC59Accident · No injuriesClosedCessna 172M · Pontiac, MINTSB CHI76FEC57Accident · No injuriesClosedCessna 172 · Flint, MINTSB CHI76FEC58Accident · No injuriesClosedCessna 180 · Salem, MINTSB CHI76AC087Accident · No injuriesClosedSwearingen SA226 · Detroit, MINTSB CHI76DEC56Accident · No injuriesClosedPiper PA-28 · Mason, MINTSB CHI76FEM55Accident · No injuriesClosedAero Comdr 500 · Hastings, MI