Skip to content

NTSB investigations, IL

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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 c."eventStateOrRegion" = 'IL' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 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 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 CHI78FEV44Accident · No injuriesClosedPiper PA-22 · Galatia, ILSep 15, 1977 · N9623D · Substantial damage NTSB CHI77FEE50Accident · 1 fatalClosedCessna 172 · Rockford, ILSep 5, 1977 · N1975V · Destroyed NTSB CHI77FEV43Accident · Serious injuriesClosedChampion 7ECA · Manito, ILSep 3, 1977 · N9636S · Substantial damage NTSB CHI77DEE48Accident · No injuriesClosedGrumman G-164A · Sterling, ILSep 1, 1977 · N6658 · Substantial damage NTSB CHI77FEE49Accident · No injuriesClosedPiper PA-23 · Elgin, ILAug 28, 1977 · N54767 · Substantial damage NTSB CHI77FEV42Accident · No injuriesClosedBeech C-45G · Lincoln, ILAug 25, 1977 · N114V · Substantial damage NTSB CHI77FEE46Accident · Minor injuriesClosedSchweizer SGS126 · Hinckley, ILAug 22, 1977 · N2653H · Substantial damage NTSB CHI77DEE47Accident · No injuriesClosedChampion 7FC · Moline, ILAug 20, 1977 · N9040B · Substantial damage NTSB CHI77FEE45Accident · Serious injuriesClosedCessna A188B · Kankakee, ILAug 19, 1977 · N21602 · Destroyed NTSB CHI77DEE55Accident · No injuriesClosedBrantly 305 · Wheeling, ILAug 17, 1977 · N16616 · Substantial damage NTSB CHI77DEE53Accident · No injuriesClosedAeronca 7AC · Elgin, ILAug 15, 1977 · N84943 · Substantial damage NTSB CHI77FEE44Accident · Minor injuriesClosedCessna 150M · Plainfield, ILAug 14, 1977 · N66776 · Substantial damage NTSB CHI77FA065Accident · 3 fatalClosedCessna 402A · Yates City, ILAug 13, 1977 · N4554Q · Destroyed NTSB CHI77DEV41Accident · No injuriesClosedContinental 5A · Warrensburg, ILAug 10, 1977 · N9081T · Substantial damage NTSB CHI77DCA05Accident · No injuriesClosedCessna 188C · Valmeyer, ILAug 10, 1977 · N91828 · Substantial damage NTSB CHI77FEE41Accident · No injuriesClosedCessna 150C · Plato Center, ILAug 8, 1977 · N7826Z · Substantial damage NTSB CHI77FA064Accident · 4 fatalClosedPiper PA-28R · De Witt, ILAug 6, 1977 · N3009Q · Destroyed NTSB CHI77DEV40Accident · No injuriesClosedLuscombe 8A · Springfield, ILAug 6, 1977 · N2938K · Substantial damage NTSB CHI77FEE39Accident · Minor injuriesClosedHughes 269B · Chicago, ILJul 31, 1977 · N9326F · Destroyed NTSB CHI77FEE34Accident · No injuriesClosedBeech 35 · Morris, ILJul 31, 1977 · N3842N · Substantial damage NTSB CHI77DEE42Accident · No injuriesClosedPiper PA-28 · Lamoille, ILJul 30, 1977 · N8765N · Substantial damage NTSB CHI77DEV37Accident · No injuriesClosedBell 47G2 · Peoria, ILJul 27, 1977 · N5174B · Substantial damage NTSB CHI77FEE38Accident · Minor injuriesClosedBensen B8M · Rockford, ILJul 25, 1977 · N5653 · Substantial damage NTSB CHI77FEV39Accident · No injuriesClosedStits Plyboy · Beardstown, ILJul 23, 1977 · N46834 · Substantial damage NTSB CHI77FEE37Accident · Serious injuriesClosedSchweizer 1-26 · Huntley, ILJul 23, 1977 · N8615R · Substantial damage NTSB CHI77FEE36Accident · Serious injuriesClosedCessna 177 · Newark, ILJul 23, 1977 · N2203Y · Substantial damage NTSB CHI77FA060Accident · 1 fatalClosedPiper PA-23 · Plano, ILJul 21, 1977 · N5900Y · Destroyed NTSB CHI77FEV36Accident · Minor injuriesClosedCessna 182 · Urbana, ILJul 20, 1977 · N3583F · Substantial damage NTSB CHI78FEE43Accident · No injuriesClosedCessna 150 · Joliet, ILJul 19, 1977 · N6998G · Substantial damage NTSB CHI77FEE35Accident · Serious injuriesClosedGrumman AA1B · Crestwood, ILJul 19, 1977 · N9885L · Substantial damage NTSB CHI77FEE32Accident · 2 fatalClosedPiper PA-28 · Wadsworth, ILJul 18, 1977 · N6899J · Destroyed NTSB CHI77FEV35Accident · No injuriesClosedWoolums KR-2 · Jacksonville, ILJul 17, 1977 · N14527 · Substantial damage NTSB CHI77FEE33Accident · Minor injuriesClosedBoeing E75 · Lockport, ILJul 16, 1977 · N4593N · 2 aircraft · Substantial damage NTSB CHI77FEE40Accident · No injuriesClosedBrantly B2B · Ringwood, ILJul 15, 1977 · N2183U · Substantial damage NTSB CHI77FEV38Accident · No injuriesClosedCessna 182 · Watseka, ILJul 14, 1977 · N8917G · Substantial damage NTSB CHI77FA059Accident · 1 fatalClosedCessna 150M · Peoria, ILJul 14, 1977 · N8993U · Destroyed NTSB CHI77FA058Accident · 1 fatalClosedPiper PA-28 · Clayton, ILJul 10, 1977 · N32742 · Destroyed NTSB CHI77FEV34Accident · No injuriesClosedStinson V-77 · Riverton, ILJul 9, 1977 · N70057 · Substantial damage NTSB CHI77FEV33Accident · No injuriesClosedHughes 369C · Mackinaw, ILJul 8, 1977 · N9153F · Substantial damage NTSB CHI77DEE29Accident · No injuriesClosedErco 415-C · Sterling, ILJul 4, 1977 · N93861 · Substantial damage NTSB CHI77DEE27Accident · No injuriesClosedPiper PA-32R · Schaumburg, ILJul 3, 1977 · N1805H · Substantial damage NTSB CHI77FEE28Accident · Serious injuriesClosedPiper PA-24 · Joliet, ILJul 2, 1977 · N9151P · Destroyed NTSB CHI77DEV31Accident · No injuriesClosedCessna 188B · Duquoin, ILJul 2, 1977 · N9246G · Substantial damage NTSB CHI77FEV32Accident · No injuriesClosedCessna 180 · Champain, ILJul 1, 1977 · N4900A · Substantial damage NTSB CHI77FEE30Accident · No injuriesClosedHughes 269 · Woodstock, ILJun 27, 1977 · N8925F · Substantial damage NTSB CHI77FEV29Accident · No injuriesClosedGrum Amer AA-1B · Danville, ILJun 26, 1977 · N1448R · Substantial damage NTSB CHI77DEV30Accident · No injuriesClosedCessna 150 · Lacon, ILJun 26, 1977 · N5727G · Substantial damage NTSB CHI77IA051Incident · No injuriesClosedBoeing 707 · Chicago, ILJun 22, 1977 · N7590A · Minor damage NTSB CHI77FEE31Accident · No injuriesClosedPitts S1 · Lockport, ILJun 20, 1977 · N2RL · Substantial damage NTSB CHI77FCA04Accident · Serious injuriesClosedPiper PA-22 · Columbia, ILJun 18, 1977 · N7125B · Substantial damage