NTSB investigations, 1964, IL
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 | 2 |
|---|---|
| 1963 | 3 |
| 1964 | 182 |
| 1965 | 166 |
| 1966 | 229 |
| 1967 | 239 |
| 1968 | 199 |
| 1969 | 168 |
| 1970 | 175 |
| 1971 | 158 |
| 1972 | 144 |
| 1973 | 146 |
| 1974 | 143 |
| 1975 | 152 |
| 1976 | 129 |
| 1977 | 139 |
| 1978 | 171 |
| 1979 | 133 |
| 1980 | 121 |
| 1981 | 121 |
| 1982 | 97 |
| 1983 | 109 |
| 1984 | 94 |
| 1985 | 74 |
| 1986 | 70 |
| 1987 | 68 |
| 1988 | 79 |
| 1989 | 72 |
| 1990 | 62 |
| 1991 | 63 |
| 1992 | 64 |
| 1993 | 64 |
| 1994 | 62 |
| 1995 | 47 |
| 1996 | 46 |
| 1997 | 46 |
| 1998 | 37 |
| 1999 | 53 |
| 2000 | 47 |
| 2001 | 51 |
| 2002 | 43 |
| 2003 | 54 |
| 2004 | 31 |
| 2005 | 33 |
| 2006 | 35 |
| 2007 | 46 |
| 2008 | 50 |
| 2009 | 31 |
| 2010 | 42 |
| 2011 | 49 |
| 2012 | 30 |
| 2013 | 29 |
| 2014 | 31 |
| 2015 | 30 |
| 2016 | 32 |
| 2017 | 27 |
| 2018 | 27 |
| 2019 | 22 |
| 2020 | 27 |
| 2021 | 18 |
| 2022 | 30 |
| 2023 | 30 |
| 2024 | 16 |
| 2025 | 37 |
| 2026 | 15 |
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\" = 'IL' 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" = 'IL' 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 UNK65X1174Accident · No injuriesClosedAeronca 7FC · Oswego, ILNTSB UNK65X1146Accident · Serious injuriesClosedLuscombe 11A · Hinsdale, ILNTSB UNK65X1131Accident · No injuriesClosedCessna 180 · Sherman, ILNTSB UNK65X1118Accident · 1 fatalClosedPiper PA-24 · Bartonville, ILNTSB UNK65X1090Accident · No injuriesClosedHoward DGA-15 · West Chicago, ILNTSB UNK65X1089Accident · No injuriesClosedBeechraft D95 · Groveland, ILNTSB UNK65X1081Accident · No injuriesClosedPiper PA30 · Chicago, ILNTSB UNK65X1068Accident · No injuriesClosedPiper PA28 · Chicago, ILNTSB UNK65X1065Accident · 2 fatalClosedCessna 140 · Oak Brook, ILNTSB CHI66D0214Accident · No injuriesClosedPiper PA-24 · Peoria, ILNTSB UNK65X0991Accident · 1 fatalClosedCessna 190 · Bradford, ILNTSB UNK65X0967Accident · No injuriesClosedPiper PA22 · Lockport, ILNTSB UNK65X0893Accident · 2 fatalClosedPiper PA-30 · Chicago, ILNTSB UNK65X0855Accident · No injuriesClosedBeechcraft 35-A33 · Fairbury, ILNTSB UNK65X0839Accident · No injuriesClosedCessna 195-A · Fairfield, ILNTSB UNK65X0799Accident · No injuriesClosedPiper PA28 · Dixon, ILNTSB UNK65X0797Accident · No injuriesClosedCessna 170B · Peoria, ILNTSB UNK65X0706Accident · Minor injuriesClosedCessna 182 · Peoria, ILNTSB UNK65X0636Accident · Serious injuriesClosedConvair CV-880 · Chicago, ILNTSB UNK65X0613Accident · Serious injuriesClosedMooney M20A · Washington, ILNTSB UNK65X0610Accident · No injuriesClosedAero Cmdr 520 · Chicago, ILNTSB UNK65X0504Accident · No injuriesClosedSikorsky S58C · Joliet, ILNTSB UNK65X0407Accident · No injuriesClosedBeechcraft 35-A33 · Marseilles, ILNTSB UNK65X0363Accident · No injuriesClosedBeechraft 95 · Savoy, ILNTSB UNK65X0350Accident · No injuriesClosedPiper PA22 · Hinsdale, ILNTSB UNK65X0337Accident · No injuriesClosedCessna 310 · Salem, ILNTSB UNK65X0325Accident · No injuriesClosedPiper PA24 · Naperville, ILNTSB UNK65X0312Accident · 3 fatalClosedMooney M20C · Antioch, ILNTSB UNK65X0286Accident · No injuriesClosedPiper PA24 · Sparta, ILNTSB UNK65X0276Accident · No injuriesClosedMooney M18C · Pekin, ILNTSB UNK65X0191Accident · No injuriesClosedPiper PA-24 · Benton, ILNTSB UNK65X0171Accident · No injuriesClosedPiper PA12 · Urbana, ILNTSB UNK65X0157Accident · No injuriesClosedPiper PA-22 · Hinsdale, ILNTSB UNK65X0135Accident · No injuriesClosedCessna 170 · Effingham, ILNTSB UNK65X0122Accident · No injuriesClosedCessna 310R · Wheeling, ILNTSB UNK65X0113Accident · No injuriesClosedMaule M4 · Chicago, ILNTSB UNK64X4173Accident · No injuriesClosedLuscombe 8F · Waukegan, ILNTSB UNK64X4148Accident · No injuriesClosedPiper PA24 · Elgin, ILNTSB UNK64X4144Accident · No injuriesClosedCessna 182 · Chicago, ILNTSB UNK64X4115Accident · No injuriesClosedBeechcraft 95 · Wheeling, ILNTSB UNK64X4092Accident · No injuriesClosedPiper PA22 · Taylorville, ILNTSB UNK64X4081Accident · Serious injuriesClosedChampion 7FC · Columbia, ILNTSB UNK64X4072Accident · No injuriesClosedNavion A · Wheeling, ILNTSB UNK64X4053Accident · No injuriesClosedBeechcraft C35 · Decatur, ILNTSB UNK64X3986Accident · Minor injuriesClosedCessna 172 · Wheeling, ILNTSB UNK64X3972Accident · No injuriesClosedPiper PA28 · Roselle, ILNTSB UNK64X3959Accident · No injuriesClosedCessna 195B · Richton Park, ILNTSB UNK64X3918Accident · No injuriesClosedCessna 140 · Chicago, ILNTSB UNK64X3835Accident · 3 fatalClosedPiper PA23 · Markham, ILNTSB UNK64X3766Accident · No injuriesClosedPiper PA24 · Hinsdale, IL