NTSB investigations, 1966, 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\") = 1966
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") = 1966 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 CHI67A0082Accident · Minor injuriesClosedBeech C-45G · Detroit, MINTSB CHI67F0401Accident · No injuriesClosedPiper PA-22 · Onsted, MINTSB CHI67F0413Accident · No injuriesClosedBeech 35 · Grand Rapids, MINTSB CHI67F0387Accident · No injuriesClosedPiper PA-24 · Ann Arbor, MINTSB CHI67F0411Accident · No injuriesClosedCessna 310D · Muskegon, MINTSB CHI67A0080Accident · No injuriesClosedBeech B95-B · Detroit, MINTSB CHI67A0079Accident · No injuriesClosedBeech D18S · Grand Rapids, MINTSB CHI67F0396Accident · No injuriesClosedBeech 35-33 · Saginaw, MINTSB CHI67F0424Accident · No injuriesClosedBeech H35 · Reed City, MINTSB CHI67F0425Accident · No injuriesClosedPiper PA-23 · Muskegon, MINTSB CHI67A0074Accident · 1 fatalClosedBensen B8-M · Dowagiac, MINTSB CHI67F0388Accident · No injuriesClosedPiper PA-28 · Plymouth, MINTSB CHI67F0386Accident · No injuriesClosedCessna 150 · Plymouth, MINTSB CHI67D0432Accident · No injuriesClosedCessna 140 · Three Rivers, MINTSB CHI67F0392Accident · Serious injuriesClosedPiper J5A · Houghton, MINTSB CHI67F0410Accident · No injuriesClosedBeech 95-C55 · Frankfort, MINTSB CHI67F0403Accident · No injuriesClosedCessna 172 · Boyne Falls, MINTSB CHI67F0368Accident · Serious injuriesClosedPiper PA-17 · Stanton, MINTSB CHI67F0365Accident · Minor injuriesClosedCessna U206 · Holly, MINTSB CHI67F0355Accident · No injuriesClosedPiper PA-22 · Adrian, MINTSB CHI67A0070Accident · 2 fatalClosedAero Comdr 680F · Bangor, MINTSB CHI67A0066Accident · 2 fatalClosedPiper PA-18 · Cassopolis, MINTSB CHI67F0382Accident · Serious injuriesClosedPiper PA-22 · Lewiston, MINTSB CHI67F0348Accident · No injuriesClosedBeech 95-A55 · Jackson, MINTSB CHI67D0390Accident · No injuriesClosedPiper PA-23 · Gladwin, MINTSB CHI67F0340Accident · No injuriesClosedAeronca 65-TAC · Plainwell, MINTSB CHI67F0332Accident · Minor injuriesClosedPietenpol Camper · Plymouth, MINTSB CHI67F0339Accident · No injuriesClosedPiper PA-28 · Battle Creek, MINTSB CHI67F0335Accident · No injuriesClosedBeech B35 · Astings, MINTSB CHI67A0062Accident · Serious injuriesClosedCessna 310 · New Boston, MINTSB CHI67F0344Accident · No injuriesClosedLear Jet 23A · Ypsilanti, MINTSB CHI67D0552Accident · No injuriesClosedBellanca 14-19 · Eaton Rapids, MINTSB CHI67F0351Accident · No injuriesClosedBellanca 14-19 · Pontiac, MINTSB CHI67A0058Accident · Minor injuriesClosedHughes 269B · Pontiac, MINTSB CHI67F0315Accident · Minor injuriesClosedFairchild 24K · Plymouth, MINTSB CHI67F0297Accident · No injuriesClosedLuscombe 8A · Gaines, MINTSB CHI67F0314Accident · No injuriesClosedPiper PA28 · Troy, MINTSB CHI67F0333Accident · No injuriesClosedHelio H-250 · Lushing, MINTSB CHI67F0305Accident · No injuriesClosedCessna 310D · Pontiac, MINTSB CHI67F0256Accident · No injuriesClosedCessna 150 · Ypsilanti, MINTSB CHI67F0290Accident · Serious injuriesClosedMeyers 200-B · East Jordan, MINTSB CHI67F0287Accident · No injuriesClosedBeech D18S · Muskegon, MINTSB CHI67A0052Accident · No injuriesClosedViscount V-745D · Muskegon, MINTSB CHI70A0049Accident · 4 fatalClosedStinson 108-1 · Hudson, MINTSB CHI67F0272Accident · No injuriesClosedWaco UPF-7 · Midland, MINTSB CHI67F0238Accident · No injuriesClosedAeronca 11AC · Greenville, MINTSB CHI67A0050Accident · 6 fatalClosedPiper PA-32 · Dowagiac, MINTSB CHI67F0263Accident · No injuriesClosedCessna 180 · La Salle, MINTSB CHI67F0375Accident · No injuriesClosedCessna 182 · Beaver Isl., MINTSB CHI67D0253Accident · No injuriesClosedPiper PA-22 · Sharon, MI