NTSB investigations, 1965, 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\") = 1965
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") = 1965 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 CHI66F0509Accident · No injuriesClosedMooney M20B · Springfield, ILNTSB CHI66F0552Accident · No injuriesClosedCessna 150 · West Chicago, ILNTSB CHI66D0499Accident · No injuriesClosedCessna 150 · Farmington, ILNTSB CHI66F0511Accident · No injuriesClosedCessna 172G · Streator, ILNTSB CHI66D0503Accident · No injuriesClosedCessna 150 · East Alton, ILNTSB CHI66F0533Accident · No injuriesClosedBeechcraft K35 · Chicago, ILNTSB CHI66F0485Accident · Serious injuriesClosedPiper PA28 · Urbana, ILNTSB CHI66D0553Accident · No injuriesClosedMooney M20 · Polo, ILNTSB CHI66F0528Accident · Minor injuriesClosedCessna 172 · Granite City, ILNTSB CHI66D0618Accident · No injuriesClosedCessna 182 · Meyer, ILNTSB CHI66F0482Accident · No injuriesClosedPiper PA-28 · Lombard, ILNTSB CHI66F0531Accident · Serious injuriesClosedBeechcraft 23 · Wheeling, ILNTSB CHI66F0479Accident · No injuriesClosedPiper PA-22 · Granite City, ILNTSB CHI66F0462Accident · No injuriesClosedCessna 310 · Chicago, ILNTSB CHI66F0506Accident · No injuriesClosedCessna 172 · Moline, ILNTSB CHI66D0440Accident · No injuriesClosedLuscombe 8E · Collinsville, ILNTSB CHI66I0052Incident · No injuriesClosedDouglas DC-8 · Chicago, ILNTSB CHI66F0478Accident · No injuriesClosedPiper PA-23 · East St Louis, ILNTSB CHI66A0051Accident · 4 fatalClosedCessna 172F · Chicago Hgts, ILNTSB CHI66F0463Accident · No injuriesClosedCessna 310J · Northbrook, ILNTSB CHI66A0050Accident · No injuriesClosedCessna 310D · Peoria, ILNTSB CHI66D0464Accident · No injuriesClosedBeechcraft 95-55 · Des Plaines, ILNTSB CHI66D0417Accident · No injuriesClosedPiper J-3 · Half Day, ILNTSB CHI66F0470Accident · No injuriesClosedMooney M20E · Sullivan, ILNTSB CHI66D0409Accident · No injuriesClosedBeechcraft 35-C33 · Wheeling, ILNTSB CHI66F0398Accident · No injuriesClosedPiper PA-22 · Shelbyville, ILNTSB CHI66F0437Accident · No injuriesClosedCessna 182A · Effingham, ILNTSB CHI66A0040Accident · No injuriesClosedBell 47H1 · Niles, ILNTSB CHI66F0349Accident · No injuriesClosedCessna 150F · Scott Afb, ILNTSB CHI66D0390Accident · No injuriesClosedPiper PA-28 · Lombard, ILNTSB CHI66F0360Accident · Serious injuriesClosedCessna 172F · Chicago, ILNTSB CHI66D0643Accident · No injuriesClosedCessna 180 · Aurora, ILNTSB CHI66F0382Accident · 1 fatalClosedPiper PA-22 · Coffeen, ILNTSB CHI66F0359Accident · No injuriesClosedFairchild 24G · Joliet, ILNTSB CHI66D0323Accident · No injuriesClosedMooney M20D · Downers Grove, ILNTSB CHI66F0324Accident · No injuriesClosedCessna 320C · Chicago, ILNTSB CHI66A0029Accident · No injuriesClosedAir & Space 18A · Vandalia, ILNTSB CHI66F0327Accident · No injuriesClosedNavion G · Peoria, ILNTSB CHI66F0310Accident · Minor injuriesClosedTaylorcraft BC-12D · Stauton, ILNTSB CHI66D0357Accident · No injuriesClosedCessna 180 · Pontiac, ILNTSB CHI66D0317Accident · No injuriesClosedCessna 182E · Chicago, ILNTSB CHI66F0217Accident · No injuriesClosedPiper PA-22 · Lacon, ILNTSB CHI66F0219Accident · No injuriesClosedCessna 120 · Sparta, ILNTSB CHI66F0306Accident · Serious injuriesClosedCessna 195A · Frankfort, ILNTSB CHI66F0226Accident · No injuriesClosedPiper PA-24 · Joliet, ILNTSB CHI66D0199Accident · No injuriesClosedCessna 172 · Rockford, ILNTSB CHI66F0386Accident · No injuriesClosedCessna 170B · Half Day, ILNTSB CHI66F0314Accident · No injuriesClosedCessna 150 · Northbrook, ILNTSB CHI66D0334Accident · No injuriesClosedCessna 172 · Jerseyville, ILNTSB CHI66F0307Accident · No injuriesClosedPiper PA-22 · Lombard, IL