NTSB investigations, 1971, 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\") = 1971
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") = 1971 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 CHI72DEV20Accident · No injuriesClosedTaylorcraft BC12-D · Jacksonville, ILNTSB CHI72AC056Accident · 2 fatalClosedPiper PA-24 · Rockford, ILNTSB CHI72IC055Incident · 1 fatalClosedLockheed Ga 382 · Chicago, ILNTSB CHI72FEE51Accident · No injuriesClosedBeech 18 · Chicago, ILNTSB CHI72AC051Accident · 2 fatalClosedCessna 320D · Springfield, ILNTSB CHI72FEE48Accident · No injuriesClosedNavion B · Harvard, ILNTSB CHI72FEE46Accident · No injuriesClosedCessna 150L · Libertyville, ILNTSB CHI72FEE47Accident · No injuriesClosedPiper PA-12 · Elgin, ILNTSB CHI72DEV18Accident · No injuriesClosedPiper PA-16 · Lawrenceville, ILNTSB CHI72DEE45Accident · No injuriesClosedMooney M20B · Rockford, ILNTSB CHI72FEE43Accident · No injuriesClosedCessna 310H · Elgin, ILNTSB CHI72DEE39Accident · No injuriesClosedPiper PA-23 · Streator, ILNTSB CHI72DEE44Accident · No injuriesClosedPiper PA-32 · Rockford, ILNTSB CHI72FEE42Accident · No injuriesClosedBeech V35A · Kankakee, ILNTSB DCA72AZ004Accident · 16 fatalClosedBeech E18S · Peoria, ILNTSB CHI72DEE40Accident · No injuriesClosedCessna 170B · Moline, ILNTSB CHI72FEE41Accident · No injuriesClosedCessna 150 · Seneca, ILNTSB CHI72DEE38Accident · No injuriesClosedCessna 150 · Sandwich, ILNTSB CHI72DEV17Accident · No injuriesClosedPiper PA-25 · Ware, ILNTSB CHI72FEV16Accident · No injuriesClosedPiper PA-28 · Carlinville, ILNTSB CHI72FEE35Accident · No injuriesClosedPiper PA-24 · Rockford, ILNTSB CHI72FEE32Accident · No injuriesClosedBeech 95-B55 · Lockport, ILNTSB CHI72AC034Accident · No injuriesClosedDouglas DC-9 · Chicago, ILNTSB CHI72AC033Accident · Minor injuriesClosedPiper PA-28 · Urbana, ILNTSB CHI72FEE37Accident · No injuriesClosedCessna 150 · Chicago, ILNTSB CHI72FEE29Accident · No injuriesClosedKnight OW-1 · Maple Park, ILNTSB CHI72FEE30Accident · Serious injuriesClosedPiper PA-12 · Gardner, ILNTSB CHI72FCA01Accident · No injuriesClosedPiper PA-24 · E St Louis, ILNTSB CHI72FEE33Accident · No injuriesClosedMooney M20E · Caledonia, ILNTSB CHI72FEE31Accident · No injuriesClosedPiper PA-22 · Mchenry, ILNTSB CHI72AC029Accident · 4 fatalClosedCessna 177 · Hanna City, ILNTSB CHI72DEE36Accident · No injuriesClosedChampion 7EC · Lasalle, ILNTSB CHI72FEE28Accident · Serious injuriesClosedBell 47G-4A · Chicago, ILNTSB CHI72FEE26Incident · No injuriesClosedPiper PA-24 · Rock Falls, ILNTSB CHI72DEE34Accident · No injuriesClosedCessna 310B · Rockford, ILNTSB CHI72DEE27Accident · No injuriesClosedPiper PA-24 · Waukegan, ILNTSB CHI72FEE22Accident · No injuriesClosedStinson 108 · West Chicago, ILNTSB CHI72AC023Accident · Serious injuriesClosedDouglas DC-3 · Peotone, ILNTSB CHI72DEE23Accident · No injuriesClosedBeech C35 · Dekalb, ILNTSB CHI72DEE24Accident · No injuriesClosedPiper PA-28 · Clearing, ILNTSB CHI72DEE25Accident · No injuriesClosedSiai-Marche S205 · Northbrook, ILNTSB CHI72DEE21Accident · No injuriesClosedCessna 180 · Wheeling, ILNTSB CHI72FEV14Accident · No injuriesClosedPiper PA-25 · Fisher, ILNTSB CHI72FEE18Accident · Minor injuriesClosedPiper PA-28 · Grayslake, ILNTSB CHI72FEE17Accident · Minor injuriesClosedPiper PA-28 · Grayslake, ILNTSB CHI72FEE16Accident · Minor injuriesClosedErco 415-C · Plainfield, ILNTSB CHI72DEE20Accident · Minor injuriesClosedBeech V35 · Plainfield, ILNTSB CHI72DEV15Accident · No injuriesClosedPiper PA-28 · Cropsey, ILNTSB CHI72FEV13Accident · No injuriesClosedCessna 150 · Manito, ILNTSB CHI72FEE15Accident · No injuriesClosedPiper PA-28 · Grayslake, IL