Fatal NTSB investigations, 1981, IL
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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
| 1964 | 13 |
|---|---|
| 1965 | 11 |
| 1966 | 21 |
| 1967 | 12 |
| 1968 | 15 |
| 1969 | 10 |
| 1970 | 12 |
| 1971 | 14 |
| 1972 | 19 |
| 1973 | 20 |
| 1974 | 16 |
| 1975 | 26 |
| 1976 | 27 |
| 1977 | 20 |
| 1978 | 19 |
| 1979 | 25 |
| 1980 | 14 |
| 1981 | 21 |
| 1982 | 8 |
| 1983 | 16 |
| 1984 | 7 |
| 1985 | 12 |
| 1986 | 12 |
| 1987 | 15 |
| 1988 | 11 |
| 1989 | 12 |
| 1990 | 10 |
| 1991 | 7 |
| 1992 | 11 |
| 1993 | 8 |
| 1994 | 10 |
| 1995 | 9 |
| 1996 | 14 |
| 1997 | 9 |
| 1998 | 7 |
| 1999 | 7 |
| 2000 | 6 |
| 2001 | 9 |
| 2002 | 4 |
| 2003 | 7 |
| 2004 | 5 |
| 2005 | 4 |
| 2006 | 6 |
| 2007 | 8 |
| 2008 | 3 |
| 2009 | 5 |
| 2010 | 8 |
| 2011 | 7 |
| 2012 | 6 |
| 2013 | 2 |
| 2014 | 6 |
| 2015 | 5 |
| 2016 | 7 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 9 |
| 2022 | 4 |
| 2023 | 2 |
| 2024 | 1 |
| 2025 | 6 |
| 2026 | 4 |
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\") = 1981
AND c.\"eventStateOrRegion\" = 'IL' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
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") = 1981 AND c."eventStateOrRegion" = 'IL' AND c."eventCountry" = 'USA' AND c."highestInjuryLevel" = 'Fatal' 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 CHI82FEE03Accident · 1 fatalClosedSonerai II · Romeoville, ILNTSB CHI82FA003Accident · 4 fatalClosedCessna 310I · Hainesville, ILNTSB CHI82FA002Accident · 1 fatalClosedBeech B95A · Bedford Park, ILNTSB CHI81FA096Accident · 1 fatalClosedCessna 175 · Fenton, ILNTSB CHI81FA089Accident · 5 fatalClosedBalloon WKS 8-24 · Barrington, ILNTSB CHI81FA086Accident · 3 fatalClosedPiper PA-28 · Altamont, ILNTSB CHI81FA085Accident · 2 fatalClosedPiper PA-28R · Chicago, ILNTSB CHI81FA082Accident · 2 fatalClosedBellanca 7ECA · Delevan, ILNTSB CHI81FEV27Accident · 1 fatalClosedCessna T188C · Ridgway, ILNTSB CHI81FEE46Accident · 1 fatalClosedBensen B8MG · Ridott, ILNTSB CHI81FA078Accident · 2 fatalClosedCessna 340A · St Charles, ILNTSB CHI81FEV24Accident · 1 fatalClosedPiper PA-25 · Olney, ILNTSB CHI81FEV21Accident · 1 fatalClosedTexas Hel OH-13H · Danville, ILNTSB CHI81FA063Accident · 1 fatalClosedBeech F33A · Spring Valley, ILNTSB CHI81FA060Accident · 1 fatalClosedBellanca 17-31A · Grundy County, ILNTSB CHI81FEE33Accident · 1 fatalClosedSonerai 1 · Cortland, ILNTSB CHI81FA055Accident · 1 fatalClosedMooney M20K · Campbell Hill, ILNTSB CHI81FA047Accident · 1 fatalClosedNavion A · Platteville, ILNTSB CHI81FA045Accident · 3 fatalClosedCessna 172N · Atlas, ILNTSB CHI81FA033Accident · 1 fatalClosedCessna 172M · Quincy, ILNTSB CHI81FA022Accident · 1 fatalClosedCessna 150M · Timewell, IL