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 CHI75FEV26Accident · No injuriesClosedCessna 172E · Decatur, ILMar 24, 1975 · N5427T · Substantial damage NTSB CHI75FEE54Accident · No injuriesClosedCessna 140 · Monee, ILMar 21, 1975 · N2036N · Substantial damage NTSB CHI75AC068Accident · 2 fatalClosedPiper PA-28 · Concord, ILMar 19, 1975 · N15004 · Destroyed NTSB CHI75FEV25Accident · No injuriesClosedPiper PA-28R · Hammond, ILMar 18, 1975 · N1349T · Substantial damage NTSB CHI75FEV24Accident · No injuriesClosedPiper PA-28 · Bloomington, ILMar 18, 1975 · N33312 · Substantial damage NTSB NYC75FEV23Accident · No injuriesClosedBell 47G-2 · Eddyville, ILMar 17, 1975 · N972B · Substantial damage NTSB CHI75AC067Accident · 1 fatalClosedPiper PA-28 · Plainfield, ILMar 17, 1975 · N5116W · Destroyed NTSB CHI75DEE51Accident · No injuriesClosedPiper PA-22 · Wayne, ILMar 16, 1975 · N3723Z · Substantial damage NTSB CHI75FEE53Accident · No injuriesClosedCessna 310K · Ottawa, ILMar 15, 1975 · N128MC · Substantial damage NTSB CHI75AC063Accident · No injuriesClosedBeech D18S · Chicago, ILMar 8, 1975 · N765D · Substantial damage NTSB NYC75FEE52Accident · 1 fatalClosedBeech E18S · Wheeling, ILMar 6, 1975 · N54N · Substantial damage NTSB CHI75FEV22Accident · No injuriesClosedCessna 310C · Peoria, ILMar 6, 1975 · N1719H · Substantial damage NTSB CHI75FEE49Accident · No injuriesClosedPiper PA-23 · Chicago, ILFeb 28, 1975 · N500MP · Substantial damage NTSB CHI75FEE48Accident · No injuriesClosedCessna 182L · Grayslake, ILFeb 27, 1975 · N3418R · Substantial damage NTSB CHI75FEE47Accident · No injuriesClosedPiper PA-23 · Elgin, ILFeb 26, 1975 · N6800Y · Substantial damage NTSB CHI75AC059Accident · 2 fatalClosedBeech G35 · Rock Falls, ILFeb 23, 1975 · N4594D · Substantial damage NTSB CHI75DEE50Accident · No injuriesClosedMooney M20C · Grant Park, ILFeb 20, 1975 · N7161U · Substantial damage NTSB CHI75DCA05Accident · No injuriesClosedAeronca 7AC · Freeburg, ILFeb 19, 1975 · N81611 · Substantial damage NTSB CHI75AC056Accident · 4 fatalClosedBeech B90 · Joliet, ILFeb 15, 1975 · N2GG · Destroyed NTSB CHI75FEE46Accident · Serious injuriesClosedCessna 337 · Chicago, ILFeb 10, 1975 · N20L · Substantial damage NTSB CHI75DEV20Accident · No injuriesClosedCessna 150 · Peoria, ILFeb 9, 1975 · N16178 · Substantial damage NTSB CHI75FEV21Accident · No injuriesClosedCessna 172F · St Joseph, ILFeb 7, 1975 · N7964U · Substantial damage NTSB CHI75DEE45Accident · No injuriesClosedGrum Amer AA-5 · Polo, ILFeb 4, 1975 · N5484L · Substantial damage NTSB CHI75FEE44Accident · No injuriesClosedCessna 177 · Marseilles, ILFeb 2, 1975 · N3111T · Substantial damage NTSB CHI75FEE43Accident · No injuriesClosedCessna 150L · Hinckley, ILJan 28, 1975 · N18552 · Substantial damage NTSB CHI75FCA04Accident · Minor injuriesClosedTemco GC-1B · Cahokia, ILJan 23, 1975 · N78326 · Substantial damage NTSB CHI75FEV19Accident · Minor injuriesClosedCessna 150L · Macomb, ILJan 20, 1975 · N11766 · Substantial damage NTSB CHI75FEE42Accident · Minor injuriesClosedPiper PA-22 · Schaumburg, ILJan 17, 1975 · N5472Z · Substantial damage NTSB CHI75FEE41Accident · No injuriesClosedCessna 172M · Blue Island, ILJan 12, 1975 · N13947 · Substantial damage NTSB CHI75AC051Accident · No injuriesClosedBeech C-45G · Chicago, ILJan 8, 1975 · N114V · Substantial damage NTSB CHI75ACA03Accident · No injuriesClosedCessna 210B · Livingston, ILJan 6, 1975 · N9614X · Substantial damage NTSB CHI75DEV18Accident · No injuriesClosedPiper PA-28 · Bloomington, ILJan 5, 1975 · N41789 · Substantial damage NTSB CHI75DEE39Accident · No injuriesClosedGlobe GC-1B · Channahon, ILJan 5, 1975 · N2442B · Substantial damage NTSB CHI75FEE38Accident · No injuriesClosedPiper PA-22 · Roselle, ILJan 4, 1975 · N5699Z · Destroyed NTSB CHI75AC048Accident · 1 fatalClosedBeech E18S · Rockford, ILJan 2, 1975 · N7581 · Destroyed NTSB CHI75FEV17Accident · No injuriesClosedCessna 182C · Olney, ILJan 1, 1975 · N8701T · Substantial damage NTSB CHI75DEE34Accident · No injuriesClosedCessna 150L · Morris, ILDec 26, 1974 · N18042 · Substantial damage NTSB CHI75FEE36Accident · No injuriesClosedTemco D16A · Hebron, ILDec 24, 1974 · N719T · Substantial damage NTSB CHI75DEE37Accident · No injuriesClosedPiper PA-23 · Monee, ILDec 23, 1974 · N2207P · Substantial damage NTSB CHI75DEE35Accident · No injuriesClosedCessna 150 · Richton Park, ILDec 23, 1974 · N7137F · Substantial damage NTSB CHI75FEV16Accident · Serious injuriesClosedLuscombe 8A · Loda, ILDec 20, 1974 · N71446 · Substantial damage NTSB CHI75FEV15Accident · Minor injuriesClosedCessna 172M · Mackinaw, ILDec 18, 1974 · N19894 · Destroyed NTSB CHI75FEE33Accident · 1 fatalClosedSmith Termit · Loves Park, ILDec 10, 1974 · N70LS · Destroyed NTSB CHI75FEE32Accident · Minor injuriesClosedPiper PA-28 · Lansing, ILDec 10, 1974 · N44112 · Substantial damage NTSB CHI75FEE40Accident · No injuriesClosedBellanca 8GCBC · Morris, ILDec 5, 1974 · N88464 · Substantial damage NTSB CHI75FEV14Accident · No injuriesClosedCessna 175 · Danville, ILNov 28, 1974 · N7603M · Destroyed NTSB CHI75DEE31Accident · No injuriesClosedPiper PA-28 · Grayslake, ILNov 25, 1974 · N55617 · Substantial damage NTSB CHI75DEV13Accident · No injuriesClosedCessna 150M · Mattoon, ILNov 20, 1974 · N66072 · Substantial damage NTSB CHI75FEE30Accident · No injuriesClosedCessna 182 · Chicago, ILNov 14, 1974 · N2124R · Substantial damage NTSB CHI75FEV12Accident · No injuriesClosedStinson 108 · Savoy, ILNov 12, 1974 · N596C · Substantial damage