NTSB investigations, 1979, 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\") = 1979
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") = 1979 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 CHI80FA019Accident · 2 fatalClosedPiper PA-28R · Kankakee, ILNTSB CHI80FA016Accident · 2 fatalClosedCessna 172K · Edwardsville, ILNTSB CHI80DA018Accident · 2 fatalClosedBeech B58 · Taylorville, ILNTSB CHI80DEE12Accident · No injuriesClosedCessna 172N · Schaumburg, ILNTSB CHI80FEE11Accident · No injuriesClosedPiper PA-30 · Chicago, ILNTSB CHI80FEV11Accident · No injuriesClosedCessna 150H · Springfield, ILNTSB CHI80FEV10Accident · No injuriesClosedMooney M20K · Lacon, ILNTSB CHI80FEE08Accident · Minor injuriesClosedBeech 76 · West Chicago, ILNTSB CHI80DEV09Accident · No injuriesClosedBeech A23-19 · Pittsfield, ILNTSB CHI80FA009Accident · Minor injuriesClosedCessna T210L · Galesburg, ILNTSB CHI80FEV07Accident · 1 fatalClosedAmerican AA-1B · Charleston, ILNTSB CHI80FEV08Accident · No injuriesClosedPiper PA-28R · Girard, ILNTSB CHI80FEE07Accident · No injuriesClosedPiper PA-24 · Chicago, ILNTSB CHI80DEE05Accident · Minor injuriesClosedCessna 150L · Freeport, ILNTSB CHI80DEE06Accident · No injuriesClosedCessna 152 · Rock City, ILNTSB CHI80FEV06Accident · No injuriesClosedBellanca 7KCAB · Makanda, ILNTSB CHI80DEE04Accident · Minor injuriesClosedPiper PA-28 · Chicago, ILNTSB CHI80FEV05Accident · Minor injuriesClosedErco 415-C · Grafton, ILNTSB CHI80DA004Accident · 1 fatalClosedCessna A150L · Spring Valley, ILNTSB CHI80DEE03Accident · No injuriesClosedCessna 182J · Wheeling, ILNTSB CHI80FEE02Accident · No injuriesClosedCessna 172N · New Lenox, ILNTSB CHI80FEV03Accident · No injuriesClosedAeronca 7AC · Brookport, ILNTSB CHI80DEV02Accident · No injuriesClosedBeech B19 · Sidney, ILNTSB CHI80DEV01Accident · Serious injuriesClosedSchweizer SGU222 · Moweaqua, ILNTSB CHI79FA002Accident · 3 fatalClosedPiper PA-32R · Elgin, ILNTSB CHI80FEE01Accident · Serious injuriesClosedPiper PA-28 · Kankakee, ILNTSB CHI79FEV35Accident · 1 fatalClosedBellanca 8KCAB · Alma, ILNTSB CHI79FEE85Accident · No injuriesClosedBeech F35 · Utica, ILNTSB CHI79FEE86Accident · 1 fatalClosedVolksplane VP-1 · Plainfield, ILNTSB CHI79DEE84Accident · No injuriesClosedCessna 172 · Elgin, ILNTSB CHI79DEE82Accident · No injuriesClosedCessna 337 · Peru, ILNTSB CHI79DEE83Accident · No injuriesClosedBeech 35-B33 · Joliet, ILNTSB CHI79DEV34Accident · No injuriesClosedPiper PA-38 · Mt Sterling, ILNTSB CHI79DEV33Accident · No injuriesClosedBoeing A-75 · Champaign, ILNTSB CHI79DEE81Accident · No injuriesClosedBlanik L-13 · Freeport, ILNTSB CHI79DEE79Accident · No injuriesClosedBeech A36 · Schaumburg, ILNTSB CHI79DEE88Accident · No injuriesClosedPiper PA-25 · La Moille, ILNTSB CHI79FEV32Accident · No injuriesClosedPiper PA-38 · Jerseyville, ILNTSB CHI79FA079Accident · No injuriesClosedCessna 402C · Chicago, ILNTSB CHI79FA078Accident · 2 fatalClosedCessna 172G · Brownstown, ILNTSB CHI79FA077Accident · No injuriesClosedBoeing 707 · Palatine, ILNTSB CHI79DEV31Accident · No injuriesClosedCessna 152 · Galesburg, ILNTSB CHI79DA074Accident · No injuriesClosedPiper PA-28R · Moline, ILNTSB CHI79FEE76Accident · Serious injuriesClosedBrown V-EZE · Plainfield, ILNTSB CHI79FEE74Accident · Minor injuriesClosedCessna 182P · Sandwich, ILNTSB CHI79FEV30Accident · Minor injuriesClosedCessna 182A · Hillsboro, ILNTSB CHI79FI070Incident · No injuriesClosedDouglas DC-9 · Chicago, ILNTSB CHI79DEE77Accident · No injuriesClosedBeech C35 · Chicago, ILNTSB CHI79FEV29Accident · No injuriesClosedPiper PA-23 · Champaign, ILNTSB CHI79FEE78Accident · Minor injuriesClosedPiper PA-32R · West Chicago, IL