NTSB investigations, 1980, 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\") = 1980
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") = 1980 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 CHI81FEV08Accident · No injuriesClosedCessna 177RG · Meyer, ILNTSB CHI81FEV07Accident · No injuriesClosedPiper PA-22 · Germantown Hls, ILNTSB CHI81DEE13Accident · No injuriesClosedCessna 182RG · Lansing, ILNTSB CHI81FEE15Accident · No injuriesClosedCessna 170B · Roscoe, ILNTSB CHI81FEE12Accident · No injuriesClosedPiper PA-31 · Chicago, ILNTSB CHI81DEE11Accident · No injuriesClosedCessna 414 · Wheeling, ILNTSB CHI81FEE10Accident · Minor injuriesClosedBeech C24R · West Chicago, ILNTSB CHI81FA008Accident · 1 fatalClosedPiper PA-24 · Annawan, ILNTSB CHI81DEV06Accident · No injuriesClosedCessna 172 · Urbana, ILNTSB CHI81FEE09Accident · No injuriesClosedCessna 152 · Crystal Lake, ILNTSB CHI81DEV05Accident · No injuriesClosedCessna 152 · St Francisvill, ILNTSB CHI81FEV04Accident · No injuriesClosedPiper PA-25 · Chrisman, ILNTSB CHI81FEE07Accident · Serious injuriesClosedCessna 182 · Grayslake, ILNTSB CHI81FEE06Accident · Serious injuriesClosedSonerai I · Lansing, ILNTSB CHI81FEE08Accident · No injuriesClosedAero Comdr 720 · Wheeling, ILNTSB CHI81FEE05Accident · No injuriesClosedMooney M20E · Chicago, ILNTSB CHI81FEE04Accident · No injuriesClosedBeech 95-B55 · Wheeling, ILNTSB CHI81FCA04Accident · Serious injuriesClosedPiper PA-32 · St Jacob, ILNTSB CHI81IA003Incident · No injuriesClosedBeech 95-C55 · Galena, ILNTSB CHI81DA002Accident · No injuriesClosedCessna 402 · Moline, ILNTSB CHI81FCA02Accident · 2 fatalClosedAlvarez Polli · Grantfork, ILNTSB CHI81FEV03Accident · No injuriesClosedGrady KR-2 · Jacksonville, ILNTSB CHI81FEE03Accident · Serious injuriesClosedCessna 182P · Romeoville, ILNTSB CHI81FCA03Accident · No injuriesClosedCessna 152 · Cahokia, ILNTSB CHI81DCA01Accident · No injuriesClosedCessna 182RG · Cahokia, ILNTSB CHI81DEV02Accident · No injuriesClosedBeech B19 · Sidney, ILNTSB CHI81FEE02Accident · Minor injuriesClosedCessna R182 · Chicago, ILNTSB CHI81FEE01Accident · Serious injuriesClosedPiper PA-28 · Huntley, ILNTSB CHI81DEV01Accident · Minor injuriesClosedGrumman G-164 · Golden, ILNTSB CHI80FEE53Accident · No injuriesClosedCessna 310Q · West Chicago, ILNTSB CHI80DEE57Accident · No injuriesClosedBLN Works FF-7 · Rock Island, ILNTSB CHI80FEV40Accident · Serious injuriesClosedBensen B8M · St. Joseph, ILNTSB CHI80FEV39Accident · No injuriesClosedCessna 188 · Mill Shoals, ILNTSB CHI80FA069Accident · 1 fatalClosedCessna 150J · Akin, ILNTSB CHI80DEE56Accident · No injuriesClosedCessna 172 · Lansing, ILNTSB CHI80DEE52Accident · No injuriesClosedCessna 152 · Lockport, ILNTSB CHI80FEE51Accident · No injuriesClosedBeech G18S · Lansing, ILNTSB CHI80FA068Accident · No injuriesClosedLear Jet 23 · Waukegan, ILNTSB CHI80FEV38Accident · Minor injuriesClosedJeanies Teenie · Shelbyville, ILNTSB CHI80DEE55Accident · No injuriesClosedPiper PA-28 · New Lenox, ILNTSB CHI80FEE50Accident · No injuriesClosedCessna 152 · Aurora, ILNTSB CHI80FEV37Accident · Serious injuriesClosedPiper PA-24 · Monticello, ILNTSB CHI80FA067Accident · 1 fatalClosedAero Comdr 680FL · Chicago, ILNTSB CHI80DEE49Accident · No injuriesClosedGrumman AA-5A · Greenwood, ILNTSB CHI80FEE47Accident · 1 fatalClosedVari-Eze Heiman · Huntley, ILNTSB CHI80DEE48Accident · No injuriesClosedCessna 182 · Dwight, ILNTSB CHI80FEE45Accident · No injuriesClosedLake LA-4 · Highland Park, ILNTSB CHI80DCA02Accident · No injuriesClosedPiper PA-28 · Columbia, ILNTSB CHI80FEE44Accident · No injuriesClosedChampion 7GCAA · Bolingbrook, ILNTSB CHI80DEE54Accident · Serious injuriesClosedCessna 172 · Grayslake, IL