NTSB investigations, 1973, 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\") = 1973
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") = 1973 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 CHI74DEE41Accident · Minor injuriesClosedCessna 150 · Wheeling, ILNTSB CHI74FEE44Accident · No injuriesClosedPiper PA-24 · Princeton, ILNTSB CHI74DEE45Accident · No injuriesClosedCessna 150 · Lansing, ILNTSB CHI74FEV31Accident · No injuriesClosedCessna P206 · Chillicothe, ILNTSB CHI74DEV33Accident · No injuriesClosedPiper PA-28 · Decatur, ILNTSB CHI74AC054Accident · 4 fatalClosedBeech A23A · Cabery, ILNTSB CHI74AC053Accident · No injuriesClosedBeech E18S · Chicago, ILNTSB CHI74FEV32Accident · No injuriesClosedPiper PA-30 · Peoria, ILNTSB CHI74FEE42Accident · No injuriesClosedAmer Avco AA1 · Woodstock, ILNTSB CHI74DEE38Accident · No injuriesClosedCessna 182F · Schaumberg, ILNTSB CHI74AC052Accident · 2 fatalClosedCessna 182B · Claytonville, ILNTSB CHI74FEE37Accident · Serious injuriesClosedCessna TU206B · West Chicago, ILNTSB CHI74DEE43Accident · No injuriesClosedStinson 108 · Kewanee, ILNTSB CHI74DEE40Accident · No injuriesClosedCessna 150 · Rochelle, ILNTSB CHI74AC049Accident · No injuriesClosedBeech E18S · Geneva, ILNTSB CHI74FEV30Accident · Serious injuriesClosedCessna P206 · Macomb, ILNTSB CHI74FEE36Accident · No injuriesClosedPiper PA-28 · Chicago, ILNTSB CHI74DEE35Accident · No injuriesClosedCessna 180 · Joliet, ILNTSB CHI74FEV29Accident · No injuriesClosedCessna 150L · Laharpe, ILNTSB CHI74DEE35Accident · No injuriesClosedBeech 23-19 · Moline, ILNTSB CHI74DEV28Accident · No injuriesClosedCessna T210F · Peoria, ILNTSB CHI74FEE33Accident · No injuriesClosedCessna 210H · Rockford, ILNTSB CHI74AC041Accident · No injuriesClosedDassault Falcon · Galesburg, ILNTSB CHI74FEV26Accident · No injuriesClosedAeronca 7EC · Monticello, ILNTSB CHI74AEV27Accident · Serious injuriesClosedCessna 140 · Hull, ILNTSB CHI74AC039Accident · No injuriesClosedBeech E18E · Chicago, ILNTSB CHI74DEE32Accident · No injuriesClosedPiper PA-28 · Rockford, ILNTSB CHI74DEE31Accident · Minor injuriesClosedCessna 182N · Polo, ILNTSB CHI74DEV25Accident · No injuriesClosedPiper PA-28 · Rowe, ILNTSB CHI74FEV24Accident · No injuriesClosedCessna 182H · Rushville, ILNTSB CHI74FEE29Accident · No injuriesClosedCessna 182A · Marseilles, ILNTSB CHI74AEE30Accident · No injuriesClosedAero Comdr 720 · Rockton, ILNTSB CHI74FEE28Accident · No injuriesClosedCessna 182 · Polo, ILNTSB CHI74FEE26Accident · 1 fatalClosedCessna 320 · Northbrook, ILNTSB CHI74FEE27Accident · No injuriesClosedCessna 172K · Plainfield, ILNTSB CHI74AC031Accident · 2 fatalClosedBellanca 7GCBC · Morris, ILNTSB CHI74FEV22Accident · No injuriesClosedMitsubishi MU-2 · Springfield, ILNTSB CHI74FEE25Accident · No injuriesClosedPiper PA-28 · Eglin, ILNTSB CHI74AC029Accident · 1 fatalClosedAerostar 601 · Chicago, ILNTSB CHI74FEE24Accident · No injuriesClosedPiper PA-28 · Plainfield, ILNTSB CHI74FEE22Accident · No injuriesClosedCessna 310K · Wheeling, ILNTSB CHI74FEE23Accident · No injuriesClosedCessna 310J · West Chicago, ILNTSB CHI74FEE20Accident · Serious injuriesClosedBeech 35 · Streator, ILNTSB CHI74FEE19Accident · No injuriesClosedCessna 320E · Downers Grove, ILNTSB CHI74FEE21Accident · No injuriesClosedLuscombe 8E · Grayslake, ILNTSB CHI74AC023Accident · 3 fatalClosedBeech B23 · Carbondale, ILNTSB CHI74FEV21Accident · No injuriesClosedNavion A · Monmouth, ILNTSB NYC74AN022Accident · 1 fatalClosedCessna 172H · Wheeling, ILNTSB CHI74FCA01Accident · Minor injuriesClosedCessna T210L · Cahokia, ILNTSB CHI74FEE18Accident · Minor injuriesClosedPiper PA-22 · Glenwood, IL