Skip to content

NTSB investigations, IL

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 CHI79FA021Accident · 2 fatalClosedCessna 210L · Morton, ILDec 19, 1978 · N4638Q · Destroyed NTSB CHI79DEV08Accident · No injuriesClosedBellanca 7G · Meredosia, ILDec 19, 1978 · N53815 · Substantial damage NTSB CHI79DEE25Accident · No injuriesClosedPiper PA-38 · Schaumburg, ILDec 19, 1978 · N2560A · Substantial damage NTSB CHI79FEE21Accident · No injuriesClosedCessna 150 · Mendota, ILDec 17, 1978 · N23JR · Substantial damage NTSB CHI79FEE17Accident · 1 fatalClosedHawker TMK20 · Waukegan, ILDec 16, 1978 · N20SF · Destroyed NTSB CHI79FEE16Accident · No injuriesClosedPiper PA-30 · Kankakee, ILDec 16, 1978 · N8143Y · Substantial damage NTSB CHI79DEV09Accident · No injuriesClosedCessna 150 · Danville, ILDec 16, 1978 · N10739 · Substantial damage NTSB CHI79DEE33Accident · No injuriesClosedPiper PA-28 · Elgin, ILDec 15, 1978 · N44105 · Substantial damage NTSB CHI79DEE27Accident · Minor injuriesClosedCessna 172-K · Lansing, ILDec 12, 1978 · N79035 · Substantial damage NTSB CHI79FEV07Accident · No injuriesClosedCessna U206G · Casey, ILDec 9, 1978 · N9544M · Substantial damage NTSB CHI79DEV06Accident · No injuriesClosedCessna 150 · Monmouth, ILDec 9, 1978 · N704PT · Substantial damage NTSB CHI79DEV05Accident · No injuriesClosedCessna 152 · Peoria, ILDec 9, 1978 · N24792 · Substantial damage NTSB CHI79FEE18Accident · No injuriesClosedPiper PA-32 · West Chicago, ILDec 7, 1978 · N4175R · Substantial damage NTSB CHI79FA019Accident · Minor injuriesClosedCessna 401A · Rockford, ILDec 7, 1978 · N6247Q · Substantial damage NTSB CHI79DEE14Accident · No injuriesClosedCessna 401A · Chicago, ILDec 6, 1978 · N622DG · Substantial damage NTSB CHI79FEE15Accident · No injuriesClosedCessna 411A · West Chicago, ILDec 4, 1978 · N3262R · Substantial damage NTSB CHI79FA018Accident · 3 fatalClosedBeech V35A · Wheeling, ILDec 3, 1978 · N6DF · Destroyed NTSB CHI79DEE28Accident · No injuriesClosedCessna 152 · Sugar Grove, ILDec 2, 1978 · N68750 · Substantial damage NTSB CHI79DEV04Accident · No injuriesClosedCessna 310 · Peoria, ILNov 20, 1978 · N7872Q · Substantial damage NTSB CHI79DEE12Accident · No injuriesClosedGrumman AA-5A · Morris, ILNov 15, 1978 · N9748U · Substantial damage NTSB CHI79FEE09Accident · Minor injuriesClosedCessna 140 · Waukegan, ILNov 11, 1978 · N701F · Substantial damage NTSB CHI79FEE10Accident · No injuriesClosedBeech B19 · Gurnee, ILNov 9, 1978 · N1922W · Substantial damage NTSB CHI79IA015Incident · No injuriesClosedBoeing 747 · Chicago, ILNov 7, 1978 · N4710U · 2 aircraft · Minor damage NTSB CHI79FA014Accident · 4 fatalClosedCessna 210A · Chicago, ILNov 5, 1978 · N695HP · Destroyed NTSB CHI79DEE11Accident · No injuriesClosedBeech A-55 · Ottawa, ILNov 5, 1978 · N323E · Substantial damage NTSB CHI79FEV03Accident · 1 fatalClosedStarduster TOO · Nhenderson, ILNov 4, 1978 · N762RD · Destroyed NTSB CHI79FEE68Accident · No injuriesClosedPiper PA-28 · Elgin, ILOct 25, 1978 · N5163L · Substantial damage NTSB CHI79FA011Accident · 1 fatalClosedPiper PA-24 · Ashton, ILOct 25, 1978 · N8666P · Substantial damage NTSB CHI79FEE06Accident · No injuriesClosedHughes 269C · West Chicago, ILOct 24, 1978 · N7415F · Substantial damage NTSB CHI79DEE23Accident · No injuriesClosedRaven S60A · Fox River Grve, ILOct 24, 1978 · N1918R · Substantial damage NTSB CHI79DEE07Accident · No injuriesClosedBalloon WKS FF7 · Grayslake, ILOct 24, 1978 · N2313H · Substantial damage NTSB CHI79FEE08Accident · No injuriesClosedCessna 182 · Hinckley, ILOct 21, 1978 · N6258A · Substantial damage NTSB CHI79DEE05Accident · No injuriesClosedPiper PA-28 · West Chicago, ILOct 19, 1978 · N5749F · Substantial damage NTSB CHI79FEV02Accident · No injuriesClosedCessna 152 · Jacksonville, ILOct 18, 1978 · N757UJ · Substantial damage NTSB CHI79FEE03Accident · No injuriesClosedBeech 58 · Moline, ILOct 18, 1978 · N9367Q · Substantial damage NTSB CHI79FEE04Accident · No injuriesClosedErco 415-D · Savanna, ILOct 15, 1978 · N99698 · Substantial damage NTSB CHI79DEE13Accident · No injuriesClosedCessna 150 · Lanark, ILOct 10, 1978 · N5896G · Substantial damage NTSB CHI79FEV01Accident · No injuriesClosedPiper PA-36 · Metropolis, ILOct 9, 1978 · N57760 · Substantial damage NTSB CHI79FEE02Accident · Minor injuriesClosedBeechcraft C24R · Sugar Grove, ILOct 4, 1978 · N24023 · Substantial damage NTSB CHI79FA004Accident · Serious injuriesClosedBoeing 727 · Chicago, ILOct 4, 1978 · N1979 · Substantial damage NTSB CHI79FA003Accident · No injuriesClosedPiper PA-32 · Chicago, ILOct 4, 1978 · N5909V · Substantial damage NTSB CHI79FEE01Accident · No injuriesClosedPiper PA-28 · Elgin, ILOct 3, 1978 · N44553 · Substantial damage NTSB CHI79FCA01Accident · 2 fatalClosedReplica 1 · Pierron, ILOct 1, 1978 · N1912G · Destroyed NTSB CHI78FEE70Accident · Minor injuriesClosedBeech 95-B55 · Elgin, ILSep 30, 1978 · N2AC · Destroyed NTSB CHI78FCA04Accident · No injuriesClosedCessna 172M · Cahokia, ILSep 26, 1978 · N20471 · Substantial damage NTSB CHI79FA008Accident · Minor injuriesClosedPiper PA-32 · Lansing, ILSep 25, 1978 · N44295 · Substantial damage NTSB CHI78FCA03Accident · No injuriesClosedCessna 150M · Cahokia, ILSep 22, 1978 · N714LV · Substantial damage NTSB CHI79FEE72Accident · Minor injuriesClosedEnstrom F-28A · North Chicago, ILSep 20, 1978 · N612B · Substantial damage NTSB CHI78FEE68Accident · Minor injuriesClosedBeech V35B · Dekalb, ILSep 19, 1978 · N23583 · Substantial damage NTSB CHI78FA068Accident · No injuriesClosedPiper PA-28 · Chicago, ILSep 19, 1978 · N4529Q · Substantial damage