NTSB investigations, 1966, 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\") = 1966
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") = 1966 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 CHI67D0508Accident · No injuriesClosedCessna 150 · Lombard, ILNTSB CHI67F0422Accident · No injuriesClosedBeech 35 · Roselle, ILNTSB CHI67F0431Accident · No injuriesClosedCessna 150D · Deerfield, ILNTSB CHI67A0077Accident · Serious injuriesClosedPiper PA-30B · Bloomington, ILNTSB CHI67A0076Accident · 2 fatalClosedErco 415C · Pekin, ILNTSB CHI67A0075Accident · No injuriesClosedPiper PA-24 · Quincy, ILNTSB CHI67F0402Accident · No injuriesClosedCessna 175 · St.Charles, ILNTSB CHI67D0412Accident · No injuriesClosedCessna 172G · Mt.Carroll, ILNTSB CHI67A0071Accident · No injuriesClosedViscount V-700 · Chicago, ILNTSB CHI67F0426Accident · No injuriesClosedPiper PA-28 · Geneva, ILNTSB CHI67F0372Accident · Serious injuriesClosedBeech G35 · Warrenville, ILNTSB CHI67D0361Accident · No injuriesClosedCessna 172 · Waukegan, ILNTSB CHI67D0418Accident · Minor injuriesClosedCessna 172 · Kasbeer, ILNTSB CHI67A0068Accident · 1 fatalClosedBeech M35 · Rollg Meadows, ILNTSB CHI67F0374Accident · Serious injuriesClosedCessna 180 · Half Day, ILNTSB CHI67F0359Accident · No injuriesClosedPiper PA-22 · Seymour, ILNTSB CHI67A0065Accident · Minor injuriesClosedLockheed L-18 · Chicago, ILNTSB CHI67D0363Accident · No injuriesClosedCessna 210 · Wheeling, ILNTSB CHI67A0063Accident · Minor injuriesClosedFairchild F-27 · Chicago, ILNTSB CHI67F0328Accident · No injuriesClosedBeech 23 · Lacon, ILNTSB CHI67D0488Accident · No injuriesClosedCessna 170B · Sandwich, ILNTSB CHI67A0061Accident · No injuriesClosedN.American NA-265 · Chicago, ILNTSB CHI67F0376Accident · No injuriesClosedCessna 210 · Northbrook, ILNTSB CHI67F0353Accident · Minor injuriesClosedCessna 120 · Oswego, ILNTSB CHI67D0370Accident · No injuriesClosedPiper PA-23 · Sparta, ILNTSB CHI67F0030Accident · No injuriesClosedPiper PA30 · Decatur, ILNTSB CHI67D0636Accident · No injuriesClosedCessna 172 · Pittsfield, ILNTSB CHI67F0377Accident · No injuriesClosedPiper PA-28 · Elgin, ILNTSB CHI67D0362Accident · No injuriesClosedCessna 120 · Wheeling, ILNTSB CHI67F0269Accident · No injuriesClosedPiper PA-28 · Sycamore, ILNTSB CHI67F0310Accident · No injuriesClosedBeech D50A · Waukegan, ILNTSB CHI67F0258Accident · No injuriesClosedTaylorcraft BC12-D · Lombard, ILNTSB CHI67D0298Accident · No injuriesClosedCessna 150G · Rockford, ILNTSB CHI67D0270Accident · No injuriesClosedPiper PA-24 · Northbrook, ILNTSB CHI67A0048Accident · 1 fatalClosedChampion 7GCAA · Olney, ILNTSB CHI67F0331Accident · No injuriesClosedGlobe GC-1B · Wheeling, ILNTSB CHI67F0282Accident · No injuriesClosedBellanca 14-19 · Belleville, ILNTSB CHI67F0334Accident · No injuriesClosedCessna 150 · Northbrook, ILNTSB CHI67D0646Accident · No injuriesClosedPiper PA-30 · Benton, ILNTSB CHI67A0043Accident · 1 fatalClosedCessna 172 · Sailor Sprngs, ILNTSB CHI67D0371Accident · No injuriesClosedCessna 182 · Macomb, ILNTSB CHI67A0011Accident · 1 fatalClosedBeech F35 · Orland Park, ILNTSB CHI67D0259Accident · No injuriesClosedErcoupe 415-C · Grayslake, ILNTSB CHI67D0241Accident · No injuriesClosedPiper PA-28 · Joliet, ILNTSB CHI67F0289Accident · No injuriesClosedBeech B95 · Roselle, ILNTSB CHI67F0262Accident · No injuriesClosedPiper PA-28 · Rockford, ILNTSB CHI67D0182Accident · No injuriesClosedCessna 310J · Bloomington, ILNTSB CHI67A0040Accident · 1 fatalClosedPiper J-3 · Columbia, ILNTSB CHI67A0039Accident · No injuriesClosedBrantly B2-B · Northbrook, ILNTSB CHI67D0312Accident · Serious injuriesClosedCessna 172 · Frankfort, IL