NTSB investigations, 1978, IL
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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\") = 1978
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") = 1978 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 CHI79FCA02Accident · No injuriesClosedMooney M20J · Belleville, ILNTSB CHI79DEE24Accident · No injuriesClosedSchuster WAS2 · Ottawa, ILNTSB CHI79DEE22Accident · No injuriesClosedCessna 150 · Naperville, ILNTSB CHI79FEE20Accident · No injuriesClosedBeech 65 · Wheeling, ILNTSB CHI79FEE19Accident · No injuriesClosedBeech D-50 · S.Barrington, ILNTSB CHI79FA021Accident · 2 fatalClosedCessna 210L · Morton, ILNTSB CHI79DEV08Accident · No injuriesClosedBellanca 7G · Meredosia, ILNTSB CHI79DEE25Accident · No injuriesClosedPiper PA-38 · Schaumburg, ILNTSB CHI79FEE21Accident · No injuriesClosedCessna 150 · Mendota, ILNTSB CHI79FEE17Accident · 1 fatalClosedHawker TMK20 · Waukegan, ILNTSB CHI79FEE16Accident · No injuriesClosedPiper PA-30 · Kankakee, ILNTSB CHI79DEV09Accident · No injuriesClosedCessna 150 · Danville, ILNTSB CHI79DEE33Accident · No injuriesClosedPiper PA-28 · Elgin, ILNTSB CHI79DEE27Accident · Minor injuriesClosedCessna 172-K · Lansing, ILNTSB CHI79FEV07Accident · No injuriesClosedCessna U206G · Casey, ILNTSB CHI79DEV06Accident · No injuriesClosedCessna 150 · Monmouth, ILNTSB CHI79DEV05Accident · No injuriesClosedCessna 152 · Peoria, ILNTSB CHI79FEE18Accident · No injuriesClosedPiper PA-32 · West Chicago, ILNTSB CHI79FA019Accident · Minor injuriesClosedCessna 401A · Rockford, ILNTSB CHI79DEE14Accident · No injuriesClosedCessna 401A · Chicago, ILNTSB CHI79FEE15Accident · No injuriesClosedCessna 411A · West Chicago, ILNTSB CHI79FA018Accident · 3 fatalClosedBeech V35A · Wheeling, ILNTSB CHI79DEE28Accident · No injuriesClosedCessna 152 · Sugar Grove, ILNTSB CHI79DEV04Accident · No injuriesClosedCessna 310 · Peoria, ILNTSB CHI79DEE12Accident · No injuriesClosedGrumman AA-5A · Morris, ILNTSB CHI79FEE09Accident · Minor injuriesClosedCessna 140 · Waukegan, ILNTSB CHI79FEE10Accident · No injuriesClosedBeech B19 · Gurnee, ILNTSB CHI79IA015Incident · No injuriesClosedBoeing 747 · Chicago, ILNTSB CHI79FA014Accident · 4 fatalClosedCessna 210A · Chicago, ILNTSB CHI79DEE11Accident · No injuriesClosedBeech A-55 · Ottawa, ILNTSB CHI79FEV03Accident · 1 fatalClosedStarduster TOO · Nhenderson, ILNTSB CHI79FEE68Accident · No injuriesClosedPiper PA-28 · Elgin, ILNTSB CHI79FA011Accident · 1 fatalClosedPiper PA-24 · Ashton, ILNTSB CHI79FEE06Accident · No injuriesClosedHughes 269C · West Chicago, ILNTSB CHI79DEE23Accident · No injuriesClosedRaven S60A · Fox River Grve, ILNTSB CHI79DEE07Accident · No injuriesClosedBalloon WKS FF7 · Grayslake, ILNTSB CHI79FEE08Accident · No injuriesClosedCessna 182 · Hinckley, ILNTSB CHI79DEE05Accident · No injuriesClosedPiper PA-28 · West Chicago, ILNTSB CHI79FEV02Accident · No injuriesClosedCessna 152 · Jacksonville, ILNTSB CHI79FEE03Accident · No injuriesClosedBeech 58 · Moline, ILNTSB CHI79FEE04Accident · No injuriesClosedErco 415-D · Savanna, ILNTSB CHI79DEE13Accident · No injuriesClosedCessna 150 · Lanark, ILNTSB CHI79FEV01Accident · No injuriesClosedPiper PA-36 · Metropolis, ILNTSB CHI79FEE02Accident · Minor injuriesClosedBeechcraft C24R · Sugar Grove, ILNTSB CHI79FA004Accident · Serious injuriesClosedBoeing 727 · Chicago, ILNTSB CHI79FA003Accident · No injuriesClosedPiper PA-32 · Chicago, ILNTSB CHI79FEE01Accident · No injuriesClosedPiper PA-28 · Elgin, ILNTSB CHI79FCA01Accident · 2 fatalClosedReplica 1 · Pierron, ILNTSB CHI78FEE70Accident · Minor injuriesClosedBeech 95-B55 · Elgin, ILNTSB CHI78FCA04Accident · No injuriesClosedCessna 172M · Cahokia, IL