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 UNK64X2531Accident · No injuriesClosedCessna 172 · Clinton, ILJun 28, 1964 · N8841B · Substantial damage NTSB UNK64X2530Accident · No injuriesClosedPiper J3C · Roseville, ILJun 28, 1964 · N78527 · Substantial damage NTSB UNK64X2454Accident · Serious injuriesClosedCessna 180B · Fairmont, ILJun 23, 1964 · N9101T · Destroyed NTSB UNK64X2442Accident · Minor injuriesClosedCessna 170B · Polo, ILJun 23, 1964 · N3009A · Substantial damage NTSB UNK64X2386Accident · No injuriesClosedCessna 182 · Alton, ILJun 20, 1964 · N2745G · Destroyed NTSB UNK64X2375Accident · No injuriesClosedStinson 1081 · Peoria, ILJun 19, 1964 · N8543K · Substantial damage NTSB UNK64X2358Accident · Minor injuriesClosedCessna 172 · Chicago, ILJun 18, 1964 · N7863T · Substantial damage NTSB UNK64X2290Accident · No injuriesClosedPiper J3C · Hebron, ILJun 14, 1964 · N98527 · Substantial damage NTSB UNK64X2217Accident · No injuriesClosedLuscombe 8A · Champaign, ILJun 10, 1964 · N4590 · Destroyed NTSB UNK64X2201Accident · No injuriesClosedPiper PA22 · Chicago, ILJun 9, 1964 · N653A · Substantial damage NTSB UNK64X2198Accident · No injuriesClosedMooney M20E · Richton Park, ILJun 9, 1964 · N1316W · Substantial damage NTSB UNK64X2187Accident · No injuriesClosedMooney M20E · Rockford, ILJun 8, 1964 · N6945U · Substantial damage NTSB UNK64X2166Accident · No injuriesClosedPiper J3C · Winnebago, ILJun 7, 1964 · N6820H · Substantial damage NTSB UNK64X2163Accident · No injuriesClosedLuscombe 8A · Lebanon, ILJun 7, 1964 · N1328B · Substantial damage NTSB UNK64X2142Accident · No injuriesClosedAeronca 7AC · Lombard, ILJun 6, 1964 · N82769 · Substantial damage NTSB UNK64X2109Accident · No injuriesClosedPiper J3C · Wood Dale, ILJun 4, 1964 · N6671H · Substantial damage NTSB UNK64X2091Accident · No injuriesClosedCessna 180 · Litchfield, ILJun 3, 1964 · N6520A · Destroyed NTSB UNK64X2083Accident · Minor injuriesClosedErcoupe 415C · Woodland, ILJun 3, 1964 · N37123 · Destroyed NTSB UNK64X2012Accident · No injuriesClosedBeechcraft 65 · Springfield, ILMay 29, 1964 · N445BA · Substantial damage NTSB UNK64X2000Accident · No injuriesClosedPiper PA23 · Elgin, ILMay 29, 1964 · N3227P · Substantial damage NTSB UNK64X1999Accident · Serious injuriesClosedPiper J3 · Ohio, ILMay 29, 1964 · N7341H · Destroyed NTSB UNK64X1985Accident · 2 fatalClosedBeechcraft B55 · Alpha, ILMay 28, 1964 · N1101M · Destroyed NTSB UNK64X1983Accident · No injuriesClosedBell 47G · Pana, ILMay 27, 1964 · N4734S · Substantial damage NTSB UNK64X1975Accident · No injuriesClosedRB Brooks Spec · Jerseyville, ILMay 27, 1964 · N6326D · Substantial damage NTSB UNK64X1963Accident · No injuriesClosedPiper PA24 · Roselle, ILMay 26, 1964 · N6536P · Substantial damage NTSB UNK64X1942Accident · No injuriesClosedPiper PA22 · Hindsboro, ILMay 24, 1964 · N5717Z · Substantial damage NTSB UNK64X1936Accident · No injuriesClosedCessna 172E · Wheeling, ILMay 24, 1964 · N3742S · Substantial damage NTSB UNK64X1920Accident · No injuriesClosedCessna 210 · Aurora, ILMay 23, 1964 · N9535X · Substantial damage NTSB UNK64X1839Accident · No injuriesClosedCessna 206 · Pleasant Hill, ILMay 19, 1964 · N5123U · Substantial damage NTSB UNK64X1810Accident · No injuriesClosedPiper PA22 · Lombard, ILMay 17, 1964 · N2751P · Substantial damage NTSB UNK64X1798Accident · No injuriesClosedPiper PA23 · Utica, ILMay 17, 1964 · N4603P · Substantial damage NTSB UNK64X1775Accident · 4 fatalClosedBeechcraft A35 · Lombard, ILMay 15, 1964 · N8424A · Destroyed NTSB UNK64X1772Accident · No injuriesClosedCessna 310D · Taylorville, ILMay 15, 1964 · N6743T · Substantial damage NTSB UNK64X1724Accident · No injuriesClosedPiper PA22 · Lombard, ILMay 11, 1964 · N2900P · Substantial damage NTSB UNK64X1709Accident · No injuriesClosedCessna 140 · Atwood, ILMay 10, 1964 · N76501 · Substantial damage NTSB UNK64X1707Accident · No injuriesClosedCessna 195 · Wheeling, ILMay 10, 1964 · N1540D · Substantial damage NTSB UNK64X1700Accident · No injuriesClosedPiper PA-22 · Elsah, ILMay 10, 1964 · N5102Z · Substantial damage NTSB UNK64X1699Accident · Minor injuriesClosedCessna 140 · Glenwood, ILMay 10, 1964 · N89671 · Substantial damage NTSB UNK64X1695Accident · No injuriesClosedCmnwealth 9000 · Ottawa, ILMay 10, 1964 · N18008 · Substantial damage NTSB UNK64X1687Accident · No injuriesClosedCessna 140 · Hamilton, ILMay 9, 1964 · N1621V · Substantial damage NTSB UNK64X1677Accident · No injuriesClosedCessna 182 · Northbrook, ILMay 9, 1964 · N9230X · Substantial damage NTSB UNK64X1644Accident · No injuriesClosedCessna 210 · Galesburg, ILMay 7, 1964 · N3740Y · Substantial damage NTSB UNK64X1629Accident · No injuriesClosedStinson V77 · Plainsfield, ILMay 5, 1964 · N73340 · Substantial damage NTSB UNK64X1617Accident · No injuriesClosedCessna 310C · Jacksonville, ILMay 4, 1964 · N1757H · Substantial damage NTSB UNK64X1577Accident · Minor injuriesClosedChampion 7FC · Champaign, ILMay 2, 1964 · N8568E · Substantial damage NTSB UNK64X1567Accident · No injuriesClosedMeyers MAC145 · Chicago, ILMay 2, 1964 · N34364 · Substantial damage NTSB UNK64X1429Accident · No injuriesClosedBeechcraft B35 · Wheeling, ILApr 24, 1964 · N5099C · Substantial damage NTSB UNK64X1373Accident · No injuriesClosedGlobe Swift GC1B · Hampshire, ILApr 19, 1964 · N78279 · Substantial damage NTSB UNK64X1315Accident · No injuriesClosedPiper PA22 · Sterling, ILApr 14, 1964 · N3016Z · Destroyed NTSB UNK64X1246Accident · No injuriesClosedPiper PA24 · Hinsdale, ILApr 10, 1964 · N8183P · Substantial damage