NTSB investigations, 1972, 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\") = 1972
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") = 1972 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 CHI73FEV19Accident · Minor injuriesClosedCessna 150H · Albion, ILNTSB CHI73FEE38Accident · No injuriesClosedCessna 150J · West Chicago, ILNTSB CHI73FEE37Accident · No injuriesClosedBellanca 17-31 · Northbrook, ILNTSB CHI73AC059Accident · 2 fatalClosedBeech H18S · Bloominton, ILNTSB DCA73AZ004Accident · 10 fatalClosedConvair 880 · Chicago, ILNTSB CHI73FEV18Accident · No injuriesClosedBeech D55 · Champaign, ILNTSB CHI73FEE36Accident · No injuriesClosedCessna 500 · Chicago, ILNTSB CHI73FEE35Accident · No injuriesClosedPiper PA-28 · Northbrook, ILNTSB NYC73AN081Accident · 4 fatalClosedPiper PA-28 · Grand Tower, ILNTSB DCA73A0003Accident · 43 fatalClosedBoeing 737 · Chicago, ILNTSB CHI73FEE34Accident · No injuriesClosedPiper PA-23 · Joliet, ILNTSB CHI73FEV17Accident · No injuriesClosedPiper PA-28R · Fairfield, ILNTSB CHI73FEE32Accident · No injuriesClosedBeech 65-B80 · Rockford, ILNTSB CHI73FEV16Accident · No injuriesClosedPiper PA-24 · Burnt Prairie, ILNTSB CHI73ICO61Incident · No injuriesClosedConvair 580 · Chicago, ILNTSB CHI73DEE33Accident · No injuriesClosedPiper PA-22 · Lockport, ILNTSB CHI73FEE31Accident · Minor injuriesClosedPiper PA-28 · Northbrook, ILNTSB CHI73AC049Accident · 2 fatalClosedCessna 182E · Willisville, ILNTSB CHI73DCA02Accident · No injuriesClosedCessna 150H · Cahokia, ILNTSB CHI73DEE30Accident · No injuriesClosedCessna 172K · Moline, ILNTSB CHI73FEV15Accident · No injuriesClosedBeech 35 · Quincy, ILNTSB CHI73FEE29Accident · Minor injuriesClosedPiper PA-22 · Barrington, ILNTSB CHI73FEE28Accident · No injuriesClosedCessna 190 · Morris, ILNTSB CHI73FEE27Accident · No injuriesClosedCessna 150 · Geneva, ILNTSB CHI73FEV14Accident · No injuriesClosedPiper PA-30 · Robinson, ILNTSB CHI73AC043Accident · 6 fatalClosedAero Comdr 500-A · Pekin, ILNTSB CHI73DEE26Accident · No injuriesClosedPiper PA-28 · New Lenox, ILNTSB CHI73AC040Accident · 2 fatalClosedPiper PA-28R · Bloomington, ILNTSB CHI73ACO39Accident · 1 fatalClosedN. American SNJ-6 · Woodstock, ILNTSB CHI73ACO37Accident · No injuriesClosedBeech SNB-5 · Chicago, ILNTSB CHI73FCA01Accident · Serious injuriesClosedPiper PA-25 · Dorsey, ILNTSB CHI73A0023Accident · No injuriesClosedDouglas DC9-32 · Chicago, ILNTSB CHI73DEV12Accident · No injuriesClosedCessna 310G · Fairfield, ILNTSB CHI73FET06Accident · Minor injuriesClosedAlon A2 · Ligonier, ILNTSB CHI73FEE24Accident · Serious injuriesClosedCessna 172 · Morrison, ILNTSB CHI73DEE25Accident · No injuriesClosedRyan PT-22 · Stockton, ILNTSB CHI73AC033Accident · 4 fatalClosedCessna 337B · Chicago, ILNTSB CHI73FEV11Accident · No injuriesClosedPiper PA-24 · Jacksonville, ILNTSB CHI72FEV33Accident · Serious injuriesClosedPiper PA-22 · Warsaw, ILNTSB CHI73FEV10Accident · No injuriesClosedChampion 7ECA · Pittsfield, ILNTSB CHI73FEV09Accident · Minor injuriesClosedStinson 108-1 · Virginia, ILNTSB CHI73DEV13Accident · No injuriesClosedAero Comdr A-9B · Jacksonville, ILNTSB CHI73FEE22Accident · Minor injuriesClosedPiper PA-28 · Rockford, ILNTSB CHI73DEE21Accident · No injuriesClosedCessna 177A · Moline, ILNTSB CHI73FEE19Accident · No injuriesClosedCessna 150H · Deerfield, ILNTSB CHI73FEV08Accident · No injuriesClosedPiper PA-25 · Browns, ILNTSB CHI73DEE20Accident · Minor injuriesClosedPiper PA-28 · Park Forest, ILNTSB CHI73FEE18Accident · No injuriesClosedCessna 150G · Shannon, ILNTSB CHI73AC017Accident · No injuriesClosedFairchild FH227B · Chicago, ILNTSB CHI73FEV07Accident · Serious injuriesClosedPiper PA-25 · Brookport, IL