NTSB investigations, 1976, 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\") = 1976
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") = 1976 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 CHI77FA019Accident · Serious injuriesClosedBeech D-18S · Cairo, ILNTSB CHI77FEE08Accident · No injuriesClosedCessna 150 · Wayne, ILNTSB CHI77FEV06Accident · 1 fatalClosedHughes 369C · Pontiac, ILNTSB CHI77FA014Accident · 3 fatalClosedCessna 172M · Vandalia, ILNTSB CHI77FEE07Accident · Minor injuriesClosedCessna 320 · Wheeling, ILNTSB CHI77DEV07Accident · No injuriesClosedCessna 172 · Benton, ILNTSB CHI77DEE06Accident · No injuriesClosedCessna 150M · Belvidere, ILNTSB CHI77DEV05Accident · No injuriesClosedCessna 150 · Decatur, ILNTSB CHI77DEV04Accident · No injuriesClosedPiper PA-28 · Keens, ILNTSB CHI77FA007Accident · 1 fatalClosedMooney M20C · Peoria, ILNTSB CHI77FA005Accident · 1 fatalClosedTaylorcraft DC0-65 · Belleville, ILNTSB CHI77FEE05Accident · No injuriesClosedCessna 150 · Oak Lawn, ILNTSB CHI77FEV03Accident · No injuriesClosedCessna 150L · Marion, ILNTSB CHI77FEE04Accident · No injuriesClosedBeech E18S · W Chicago, ILNTSB CHI77FA004Accident · 2 fatalClosedCessna 150H · Joliet, ILNTSB CHI77FEV02Accident · No injuriesClosedCessna 140 · Peoria, ILNTSB CHI77FEV01Accident · Serious injuriesClosedBrantley 305 · Galesburg, ILNTSB CHI77FA002Accident · 1 fatalClosedCessna 177B · Manteno, ILNTSB CHI77DEE02Accident · Minor injuriesClosedSchweizer SGU222 · Park Forest, ILNTSB CHI77FEE01Accident · No injuriesClosedCessna 172M · Kankakee, ILNTSB CHI77DEE03Accident · No injuriesClosedPiper PA-34 · Schaumburg, ILNTSB CHI76FEE80Accident · No injuriesClosedPiper PA-22 · Grays Lake, ILNTSB CHI76DEE81Accident · Serious injuriesClosedCessna 172 · Frankfort, ILNTSB CHI76AC093Accident · 3 fatalClosedCessna T210L · Peoria, ILNTSB CHI76FEE79Accident · No injuriesClosedN.American 100 · Downers Grove, ILNTSB CHI76DEE78Accident · No injuriesClosedCessna 140A · Kankakee, ILNTSB CHI77FEE77Accident · No injuriesClosedBrantly B2B · Waukegan, ILNTSB CHI76FEE76Accident · No injuriesClosedClark KR-1 · Lockport, ILNTSB CHI76DEV67Accident · No injuriesClosedPitts S-1S · Paris, ILNTSB CHI76DEE75Accident · Minor injuriesClosedCessna 172E · Ottawa, ILNTSB CHI76AC090Accident · 2 fatalClosedCessna 150M · Salem, ILNTSB CHI76FEV65Accident · No injuriesClosedPiper PA-22 · Leroy, ILNTSB CHI76FEV64Accident · No injuriesClosedGlobe GC-1B · Burnside, ILNTSB CHI76FEV63Accident · Minor injuriesClosedErco 415-C · Cisco, ILNTSB CHI76DEV66Accident · No injuriesClosedCessna 150 · Eldorado, ILNTSB CHI76FEV62Accident · Serious injuriesClosedVolksplane VP-1 · Metropolis, ILNTSB CHI76AC088Accident · 2 fatalClosedCessna 150L · Woodstock, ILNTSB CHI76FEE74Accident · 1 fatalClosedCessna 150M · Lockport, ILNTSB CHI76FEV61Accident · No injuriesClosedPiper PA-25 · Vandalia, ILNTSB CHI76FEV60Accident · Minor injuriesClosedCessna 150G · Pekin, ILNTSB CHI76FEE73Accident · No injuriesClosedCessna 172D · Savannah, ILNTSB CHI76FEE72Accident · No injuriesClosedCessna 150J · Hinckley, ILNTSB CHI76FEE70Accident · Minor injuriesClosedCessna 172M · Antioch, ILNTSB CHI76DEE71Accident · No injuriesClosedCessna 150 · Sugar Grove, ILNTSB CHI76FEV59Accident · No injuriesClosedEaa Biplane · Springfield, ILNTSB CHI76FEV58Accident · No injuriesClosedBeech F35 · Urbana, ILNTSB CHI76DEV57Accident · No injuriesClosedCessna 177 · Salem, ILNTSB CHI76FEV55Accident · 1 fatalClosedStitts SA3A · Jerseyville, ILNTSB CHI76FEE69Accident · No injuriesClosedSportster HA-2M · Rockford, ILNTSB CHI76FEV53Accident · No injuriesClosedCessna 172M · Jerseyville, IL