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 CHI79DEE56Accident · No injuriesClosedCessna P206 · Park Forrest, ILMay 6, 1979 · N4746F · Substantial damage NTSB CHI79FEE50Accident · Minor injuriesClosedCessna 172N · Lansing, ILApr 28, 1979 · N733YX · Substantial damage NTSB CHI79FEE51Accident · Minor injuriesClosedBeech 65-A90 · Chicago, ILApr 27, 1979 · N5JR · Substantial damage NTSB CHI79FEE53Accident · No injuriesClosedPiper PA-28 · Cherry, ILApr 25, 1979 · N5KS · Substantial damage NTSB CHI79FEV18Accident · Minor injuriesClosedCessna A188B · Effingham, ILApr 20, 1979 · N8904G · Substantial damage NTSB CHI79FEV17Accident · No injuriesClosedGrumman G-164B · Sandoval, ILApr 18, 1979 · N6703K · Substantial damage NTSB CHI79FEE49Accident · No injuriesClosedBeech E-35 · Deer Grove, ILApr 17, 1979 · N3293C · Substantial damage NTSB CHI79DEE45Accident · No injuriesClosedPiper PA-38 · Lockport, ILApr 17, 1979 · N9764T · Substantial damage NTSB CHI79FEY16Accident · No injuriesClosedCessna A188-B · Thompsonville, ILApr 16, 1979 · N4847R · Substantial damage NTSB CHI79DEE52Accident · No injuriesClosedBeech BE-19A · Schaumburg, ILApr 15, 1979 · N6934Q · Substantial damage NTSB CHI79DEE47Accident · No injuriesClosedCessna 182 · Naperville, ILApr 13, 1979 · N21569 · Substantial damage NTSB CHI79FEE46Accident · No injuriesClosedBeech 58 · Lansing, ILApr 12, 1979 · N30LB · Substantial damage NTSB CHI79IA042Incident · Minor injuriesClosedBoeing 707 · Chicago, ILApr 10, 1979 · N8413 · No damage NTSB CHI79AA041Accident · 6 fatalClosedBeech 58TC · St.Anne, ILApr 7, 1979 · N17994 · Destroyed NTSB CHI79FEE43Accident · Minor injuriesClosedBeech E18S · Chicago, ILApr 3, 1979 · N1234G · Destroyed NTSB CHI79DA039Accident · 1 fatalClosedHughes 369D · Pekin, ILApr 2, 1979 · N8629F · Substantial damage NTSB CHI79FEE44Accident · No injuriesClosedCessna 210L · Lansing, ILApr 1, 1979 · N210DK · Substantial damage NTSB CHI79FA038Accident · 1 fatalClosedBeech 65-80 · Wheeling, ILMar 29, 1979 · N723Q · Destroyed NTSB CHI79FA036Accident · 6 fatalClosedPiper PA-32 · Dekalb, ILMar 19, 1979 · N4047R · Destroyed NTSB CHI79DEE87Accident · No injuriesClosedPiper PA-28 · Chicago, ILMar 19, 1979 · N573PA · Substantial damage NTSB CHI79DEE54Accident · No injuriesClosedAero Comdr 112A · Monee, ILMar 18, 1979 · N112BA · Substantial damage NTSB CHI79FEE42Accident · Minor injuriesClosedCessna A150M · Lemont, ILMar 17, 1979 · N8054V · Destroyed NTSB CHI79FA035Accident · 2 fatalClosedPiper PA-28 · Park Forrest, ILMar 17, 1979 · N9458W · Destroyed NTSB CHI79FEE38Accident · No injuriesClosedCessna 210 · Crestwood, ILMar 13, 1979 · N9617T · Substantial damage NTSB CHI79FEV14Accident · No injuriesClosedCessna 150 · Lincoln, ILMar 12, 1979 · N19358 · Substantial damage NTSB CHI79DEE48Accident · No injuriesClosedCessna 182RG · Crystal Lake, ILMar 11, 1979 · N3648C · Substantial damage NTSB CHI79FEV13Accident · No injuriesClosedSonerai I · Paris, ILMar 6, 1979 · N36NA · Substantial damage NTSB CHI79FA030Accident · 4 fatalClosedCessna 310B · Galesburg, ILMar 2, 1979 · N5384A · Destroyed NTSB CHI79FEE40Accident · No injuriesClosedSwearingen SA26T · West Chicago, ILFeb 24, 1979 · N211CC · Substantial damage NTSB CHI79DEE39Accident · No injuriesClosedCessna 150 · Wheeling, ILFeb 19, 1979 · N11413 · Substantial damage NTSB CHI79FEV11Accident · No injuriesClosedCessna 150 · Champaign, ILFeb 17, 1979 · N66092 · Substantial damage NTSB CHI79DEV12Accident · No injuriesClosedCessna 172 · Rantoul, ILFeb 17, 1979 · N5254F · Substantial damage NTSB DCA79AA009Accident · No injuriesClosedBoeing 747 · Chicago, ILFeb 15, 1979 · N804FT · 2 aircraft · Substantial damage NTSB CHI79FCA03Accident · Minor injuriesClosedCessna 172N · East Alton, ILFeb 14, 1979 · N737UL · Substantial damage NTSB CHI79DEE41Accident · No injuriesClosedGrumman AA1C · Plainfield, ILFeb 10, 1979 · N9520U · Substantial damage NTSB CHI79DEE37Accident · No injuriesClosedCessna 172 · Schaumburg, ILFeb 10, 1979 · N738ZZ · Substantial damage NTSB CHI79DEE36Accident · No injuriesClosedCessna 172 · Sublette, ILFeb 10, 1979 · N13722 · Substantial damage NTSB CHI79FEE34Accident · No injuriesClosedPiper PA-24 · Shorewood, ILFeb 2, 1979 · N11BR · Substantial damage NTSB CHI79FEV10Accident · No injuriesClosedBeech E18-S · Springfield, ILJan 27, 1979 · N521GP · Substantial damage NTSB CHI79FEE32Accident · Minor injuriesClosedBeech B-18 · Chicago, ILJan 24, 1979 · N215W · Substantial damage NTSB CHI79DEE35Accident · No injuriesClosedCessna 150 · Spring Valley, ILJan 22, 1979 · N3089S · Substantial damage NTSB CHI79FEE30Accident · No injuriesClosedCessna 402 · West Chicago, ILJan 19, 1979 · N4191C · Substantial damage NTSB CHI79DEE29Accident · No injuriesClosedCessna 310 · Waukegan, ILJan 19, 1979 · N1745G · Substantial damage NTSB CHI79FEE31Accident · Minor injuriesClosedCessna 152 · Geneva, ILJan 11, 1979 · N69258 · Substantial damage NTSB CHI79DEE26Accident · No injuriesClosedPiper PA-38 · Frankfort, ILJan 7, 1979 · N4445E · Substantial damage NTSB CHI79FCA02Accident · No injuriesClosedMooney M20J · Belleville, ILDec 28, 1978 · N201RY · Substantial damage NTSB CHI79DEE24Accident · No injuriesClosedSchuster WAS2 · Ottawa, ILDec 28, 1978 · N9120 · Substantial damage NTSB CHI79DEE22Accident · No injuriesClosedCessna 150 · Naperville, ILDec 26, 1978 · N1294Q · Substantial damage NTSB CHI79FEE20Accident · No injuriesClosedBeech 65 · Wheeling, ILDec 22, 1978 · N836Q · Substantial damage NTSB CHI79FEE19Accident · No injuriesClosedBeech D-50 · S.Barrington, ILDec 22, 1978 · N150V · Substantial damage