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 CHI67D0634Accident · No injuriesClosedCessna 185 · Sycamore, ILApr 9, 1967 · N9852X · Substantial damage NTSB CHI67A0114Accident · No injuriesClosedNord-Avion 262-A · Chicago, ILApr 8, 1967 · N26210 · Substantial damage NTSB MKC67A0056Accident · Serious injuriesClosedDouglas DC-8 · Springfield, ILApr 4, 1967 · N8017U · No damage NTSB CHI68F0024Accident · No injuriesClosedPiper PA-24 · Northbrook, ILApr 4, 1967 · N5524P · Substantial damage NTSB CHI67F0641Accident · No injuriesClosedAero Comdr 520 · Rockford, ILApr 3, 1967 · N7834 · Substantial damage NTSB CHI67F0562Accident · No injuriesClosedCessna 310H · Streator, ILMar 30, 1967 · N1096Q · Substantial damage NTSB CHI67A0111Accident · 2 fatalClosedStinson 108-2 · Chandlerville, ILMar 30, 1967 · N9302K · Destroyed NTSB CHI67D0655Accident · No injuriesClosedCessna 170B · Rockford, ILMar 29, 1967 · N2779D · Substantial damage NTSB CHI67D0608Accident · No injuriesClosedGlobe GC-1A · Monee, ILMar 25, 1967 · N80748 · Substantial damage NTSB CHI67F0609Accident · No injuriesClosedCessna 172 · Ottawa, ILMar 24, 1967 · N6059R · Substantial damage NTSB CHI67F0010Accident · No injuriesClosedPiper PA-28 · Collinsville, ILMar 24, 1967 · N4675R · Substantial damage NTSB CHI68F0106Accident · Serious injuriesClosedBeech 95-C55 · Chicago, ILMar 22, 1967 · N7981M · Substantial damage NTSB CHI67F0559Accident · No injuriesClosedBoeing A75N1 · Bluford, ILMar 22, 1967 · N57013 · Substantial damage NTSB CHI67D0664Accident · No injuriesClosedAero Comdr 560A · Kankakee, ILMar 18, 1967 · N2761B · Substantial damage NTSB CHI67D0580Accident · No injuriesClosedPiper PA-20 · Mt Vernon, ILMar 18, 1967 · N7089K · Substantial damage NTSB CHI67D0544Accident · No injuriesClosedBellanca 14-132 · Cahokia, ILMar 18, 1967 · N86887 · Substantial damage NTSB CHI67F0606Accident · Serious injuriesClosedPiper PA-23 · Alsip, ILMar 17, 1967 · N1485P · Destroyed NTSB CHI67D0605Accident · No injuriesClosedPiper PA-28 · Wheeling, ILMar 17, 1967 · N4104J · Substantial damage NTSB CHI68D0479Accident · Minor injuriesClosedPiper PA-28 · Urbana, ILMar 16, 1967 · N6498R · Destroyed NTSB CHI67F0510Accident · No injuriesClosedBeech E18S · Chicago, ILMar 14, 1967 · N21U · Substantial damage NTSB CHI67D0584Accident · No injuriesClosedCessna 172G · Cahokia, ILMar 10, 1967 · N4699L · Substantial damage NTSB DEN67A0050Accident · Serious injuriesClosedBoeing 727 · Polo, ILMar 6, 1967 · N7412U · No damage NTSB CHI67F0522Accident · No injuriesClosedPiper PA-24 · Lombard, ILMar 4, 1967 · N6835P · Substantial damage NTSB CHI67D0574Accident · No injuriesClosedBeech J35 · Polo, ILMar 4, 1967 · N3028C · Substantial damage NTSB CHI67D0485Accident · No injuriesClosedCessna 150 · Streator, ILMar 3, 1967 · N2440J · Substantial damage NTSB CHI67D0593Accident · No injuriesClosedCessna 206 · Lockport, ILMar 1, 1967 · N2625X · Substantial damage NTSB CHI67D0560Accident · No injuriesClosedPiper PA-22 · Hinsdale, ILFeb 26, 1967 · N5864Z · Substantial damage NTSB CHI67D0512Accident · No injuriesClosedPiper PA-24 · Frankfort, ILFeb 24, 1967 · N5530P · Substantial damage NTSB CHI68F0475Accident · No injuriesClosedPiper PA-23 · Cobden, ILFeb 23, 1967 · N3080P · Substantial damage NTSB CHI67D0486Accident · No injuriesClosedCessna 150 · Midlothian, ILFeb 22, 1967 · N7967Z · Substantial damage NTSB CHI67F0490Accident · No injuriesClosedChampion 7ECA · West Chicago, ILFeb 21, 1967 · N9513S · Substantial damage NTSB CHI67F0546Accident · No injuriesClosedCessna 150F · Cahokia, ILFeb 16, 1967 · N8279S · Substantial damage NTSB CHI67F0473Accident · No injuriesClosedPiper PA-28 · Evergreen Pk, ILFeb 16, 1967 · N7731W · Substantial damage NTSB CHI67A0097Accident · 2 fatalClosedPiper PA-28 · Chicago, ILFeb 15, 1967 · N9347J · Destroyed NTSB CHI67F0479Accident · No injuriesClosedPiper PA-28 · Elgin, ILFeb 10, 1967 · N4011W · Substantial damage NTSB CHI68D0081Accident · No injuriesClosedPiper PA-28 · Moline, ILFeb 9, 1967 · N6666W · Substantial damage NTSB CHI67F0507Accident · No injuriesClosedCessna 172H · West Chicago, ILFeb 9, 1967 · N3735R · Substantial damage NTSB CHI67D0482Accident · No injuriesClosedPiper PA-22 · Lockport, ILFeb 8, 1967 · N5942Z · Substantial damage NTSB CHI67F0483Accident · Minor injuriesClosedCessna 150F · Northbrook, ILFeb 4, 1967 · N8022S · Substantial damage NTSB CHI67D0588Accident · No injuriesClosedPiper PA-22 · Bloomington, ILFeb 4, 1967 · N4695Z · Substantial damage NTSB CHI67D0586Accident · No injuriesClosedCessna 150 · Peoria, ILFeb 4, 1967 · N3829J · Substantial damage NTSB CHI67D0514Accident · No injuriesClosedCessna 172 · Chicago, ILFeb 4, 1967 · N5443R · Substantial damage NTSB CHI67I0093Incident · No injuriesClosedBoeing B-720B · Chicago, ILFeb 3, 1967 · N7548A · No damage NTSB CHI67F0465Accident · No injuriesClosedCessna 172 · Roselle, ILFeb 3, 1967 · N6000A · Substantial damage NTSB CHI67F0462Accident · No injuriesClosedBeech M35 · East Alton, ILFeb 2, 1967 · N830N · Substantial damage NTSB CHI67F0530Accident · Minor injuriesClosedPiper PA-28 · Chicago, ILJan 28, 1967 · N8887W · Substantial damage NTSB CHI67D0456Accident · No injuriesClosedBeech 35-C33 · East Moline, ILJan 28, 1967 · N5892S · Substantial damage NTSB CHI67F0585Accident · No injuriesClosedCessna 150G · Camp Grove, ILJan 23, 1967 · N3621J · Substantial damage NTSB CHI67F0587Accident · No injuriesClosedCessna 172B · Mattoon, ILJan 16, 1967 · N2984U · Substantial damage NTSB CHI67D0481Accident · No injuriesClosedCessna 185 · Polo, ILJan 14, 1967 · N9881X · Substantial damage