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 CHI76DEE56Accident · No injuriesClosedCesnna 172 · Wheeling, ILApr 26, 1976 · N80879 · Substantial damage NTSB CHI76FEE55Accident · Serious injuriesClosedCessna 150J · Plainfield, ILApr 22, 1976 · N61237 · Destroyed NTSB CHI76FEE52Accident · Minor injuriesClosedAero Comdr 685 · Chicago, ILApr 18, 1976 · N57069 · Substantial damage NTSB CHI76DEE53Accident · No injuriesClosedCessna 180 · Kankakee, ILApr 16, 1976 · N2443C · Substantial damage NTSB CHI76FEE51Accident · No injuriesClosedCessna 172I · Ransom, ILApr 11, 1976 · N35571 · Substantial damage NTSB CHI76FEE50Accident · No injuriesClosedCessna 150M · Justice, ILApr 9, 1976 · N3335V · Substantial damage NTSB CHI76DEV30Accident · No injuriesClosedCessna 150L · Bloomington, ILApr 9, 1976 · N7522G · Substantial damage NTSB CHI76DEE49Accident · No injuriesClosedPiper PA-28R · Sugar Grove, ILApr 5, 1976 · N111DJ · Substantial damage NTSB CHI76AC056Accident · 1 fatalClosedPiper PA-28R · Blue Mound, ILMar 31, 1976 · N55919 · 2 aircraft · Substantial damage NTSB CHI76DEE47Accident · No injuriesClosedPiper PA-28 · Streator, ILMar 27, 1976 · N5246T · Substantial damage NTSB CHI76AC055Accident · 4 fatalClosedLockheed Ga 1329 · Chicago, ILMar 25, 1976 · N1EM · Destroyed NTSB CHI76DEE48Accident · No injuriesClosedCessna 172M · Wheeling, ILMar 24, 1976 · N9163H · Substantial damage NTSB CHI76DEE46Accident · No injuriesClosedPiper PA-34 · Wilmington, ILMar 20, 1976 · N4467T · Substantial damage NTSB CHI76FCA06Accident · No injuriesClosedHiller UH-12D · St Jacob, ILMar 15, 1976 · N62417 · Substantial damage NTSB CHI76FEE45Accident · No injuriesClosedPiper PA-32 · Chicago, ILMar 11, 1976 · N1956T · Substantial damage NTSB CHI76AC054Accident · 1 fatalClosedCessna 310Q · Mattoon, ILMar 10, 1976 · N4173Q · Destroyed NTSB CHI76FEV29Accident · Serious injuriesClosedMooney M20E · Colusa, ILMar 8, 1976 · N2608W · Substantial damage NTSB CHI76FEV28Accident · No injuriesClosedPiper PA-32 · Springfield, ILMar 6, 1976 · N15588 · Substantial damage NTSB CHI76FEE44Accident · No injuriesClosedCessna 182 · Belvidere, ILMar 5, 1976 · N1945X · Substantial damage NTSB CHI76FEV27Accident · Serious injuriesClosedCessna 310N · Woodland, ILMar 4, 1976 · N5075Q · Destroyed NTSB CHI76AC051Accident · 4 fatalClosedCessna 172M · Tinley Park, ILFeb 23, 1976 · N61740 · Destroyed NTSB CHI76FEV25Accident · No injuriesClosedPiper PA-31 · Jacksonville, ILFeb 16, 1976 · N5007 · 2 aircraft · Minor damage NTSB CHI76DEE42Accident · No injuriesClosedCessna 172 · Sugar Grove, ILFeb 5, 1976 · N9619Q · Substantial damage NTSB CHI76DEE43Accident · No injuriesClosedCessna 172M · Lasalle, ILFeb 4, 1976 · N20287 · Substantial damage NTSB CHI76AC048Accident · 1 fatalClosedMooney M20A · Vienna, ILFeb 1, 1976 · N1076B · Destroyed NTSB CHI76DEE41Accident · No injuriesClosedCessna 150 · Lockport, ILJan 30, 1976 · N8AZ · Substantial damage NTSB CHI76FEE40Accident · No injuriesClosedPiper PA-32 · Sugar Grove, ILJan 29, 1976 · N8955N · Substantial damage NTSB CHI76FEE38Accident · No injuriesClosedPiper PA-28 · Elgin, ILJan 26, 1976 · N55529 · Substantial damage NTSB CHI76DEE39Accident · No injuriesClosedCessna 150 · Lockport, ILJan 18, 1976 · N6818G · Substantial damage NTSB CHI76FEE37Accident · Serious injuriesClosedBellanca 17-30 · Chicago, ILJan 17, 1976 · N4850V · Substantial damage NTSB CHI76FEE36Accident · No injuriesClosedCessna 172L · Chicago, ILJan 7, 1976 · N7946G · Substantial damage NTSB CHI76FEV24Accident · No injuriesClosedCessna 140 · Minonk, ILJan 4, 1976 · N3618V · Substantial damage NTSB CHI76FEV23Accident · No injuriesClosedPiper PA-28R · Galesburg, ILJan 4, 1976 · N55649 · Substantial damage NTSB CHI76FEE54Accident · No injuriesClosedPiper PA-23 · Crestwood, ILJan 4, 1976 · N11TJ · Substantial damage NTSB CHI76FEV22Accident · Minor injuriesClosedPiper PA-28 · Danville, ILDec 23, 1975 · N8892J · Substantial damage NTSB CHI76FEE34Accident · No injuriesClosedSwearingen SA26AT · Kankakee, ILDec 20, 1975 · N10WE · Substantial damage NTSB CHI76FEV21Accident · No injuriesClosedCessna 182B · Minonk, ILDec 9, 1975 · N26259 · Substantial damage NTSB CHI76FEV20Accident · No injuriesClosedPiper PA-32 · Cheneyville, ILDec 9, 1975 · N56953 · Substantial damage NTSB CHI76AC038Accident · 4 fatalClosedBeech C50 · Chicago, ILDec 8, 1975 · N3500U · Destroyed NTSB CHI76DEE33Accident · No injuriesClosedBeech 23 · Dekalb, ILDec 6, 1975 · N2330L · Substantial damage NTSB CHI76FEE35Accident · No injuriesClosedPiper PA-28R · Chicago, ILNov 28, 1975 · N43688 · Substantial damage NTSB CHI76FCA05Accident · Serious injuriesClosedHiller Acft FH1100 · Belleville, ILNov 28, 1975 · N518FH · Substantial damage NTSB CHI76AC037Accident · 1 fatalClosedAero Comdr 560E · Moline, ILNov 26, 1975 · N699E · Destroyed NTSB CHI76FEE32Accident · Minor injuriesClosedBellanca 7KCAB · Ransom, ILNov 22, 1975 · N36252 · Substantial damage NTSB CHI76DEE31Accident · No injuriesClosedCessna 182 · Kankakee, ILNov 22, 1975 · N6206A · Substantial damage NTSB CHI76FEE30Accident · 1 fatalClosedVolksplane VP-1 · Galva, ILNov 16, 1975 · N9042 · Destroyed NTSB CHI76FCA04Accident · No injuriesClosedCessna 150M · Alton, ILNov 16, 1975 · N63556 · Substantial damage NTSB CHI76FEV19Accident · Serious injuriesClosedErco 415-C · Pittsfield, ILNov 8, 1975 · N2486H · Substantial damage NTSB CHI76FEE28Accident · Serious injuriesClosedPiper PA-28R · Polo, ILNov 4, 1975 · N9381N · Destroyed NTSB CHI76FEE29Accident · No injuriesClosedCessna 150M · Wilmington, ILOct 29, 1975 · N66208 · Substantial damage