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 CHI67D0259Accident · No injuriesClosedErcoupe 415-C · Grayslake, ILSep 16, 1966 · N93776 · Substantial damage NTSB CHI67D0241Accident · No injuriesClosedPiper PA-28 · Joliet, ILSep 15, 1966 · N6342W · Substantial damage NTSB CHI67F0289Accident · No injuriesClosedBeech B95 · Roselle, ILSep 13, 1966 · N2049C · Substantial damage NTSB CHI67F0262Accident · No injuriesClosedPiper PA-28 · Rockford, ILSep 13, 1966 · N6271W · Substantial damage NTSB CHI67D0182Accident · No injuriesClosedCessna 310J · Bloomington, ILSep 12, 1966 · N309FS · Substantial damage NTSB CHI67A0040Accident · 1 fatalClosedPiper J-3 · Columbia, ILSep 11, 1966 · N98494 · Destroyed NTSB CHI67A0039Accident · No injuriesClosedBrantly B2-B · Northbrook, ILSep 11, 1966 · N2172U · Destroyed NTSB CHI67D0312Accident · Serious injuriesClosedCessna 172 · Frankfort, ILSep 10, 1966 · N7279A · No damage NTSB CHI68D0039Accident · Minor injuriesClosedGlobe GC-1B · Polo, ILSep 9, 1966 · N78082 · Substantial damage NTSB CHI67D0206Accident · No injuriesClosedMooney M20E · Bloomington, ILSep 8, 1966 · N3485X · Substantial damage NTSB CHI67A0036Accident · 1 fatalClosedPiper PA-18A · Topeka, ILSep 8, 1966 · N3198Z · Destroyed NTSB CHI67F0234Accident · No injuriesClosedCessna 210B · Chicago, ILSep 7, 1966 · N9648X · Substantial damage NTSB CHI67D0583Accident · No injuriesClosedCessna 182 · Macomb, ILSep 4, 1966 · N8311S · Substantial damage NTSB CHI67A0031Accident · 1 fatalClosedTaylorcraft BC12D1 · Rochester, ILAug 30, 1966 · N5481M · Destroyed NTSB CHI67F0303Accident · No injuriesClosedFairchild F-24 · Warrenville, ILAug 29, 1966 · N20628 · Substantial damage NTSB CHI67F0226Accident · No injuriesClosedBeech A35 · Midlothian, ILAug 28, 1966 · N564B · Substantial damage NTSB CHI67F0218Accident · No injuriesClosedPiper PA-28 · Thomasboro, ILAug 27, 1966 · N6327W · Substantial damage NTSB CHI67D0222Accident · No injuriesClosedPiper PA-28 · Chicago, ILAug 27, 1966 · N7180W · Substantial damage NTSB CHI67D0220Accident · No injuriesClosedCessna 150 · Joliet, ILAug 27, 1966 · N6630F · Substantial damage NTSB CHI67A0028Accident · Minor injuriesClosedConvair PBY5A · Highland Pk, ILAug 27, 1966 · N331RS · Destroyed NTSB CHI67F0135Accident · Minor injuriesClosedCessna 337 · West Chicago, ILAug 25, 1966 · N2277X · Substantial damage NTSB CHI67D0589Accident · No injuriesClosedCessna 140 · Spring Bay, ILAug 24, 1966 · N1965N · Substantial damage NTSB CHI67D0229Accident · No injuriesClosedCessna 150 · Northbrook, ILAug 23, 1966 · N6130T · 2 aircraft · Substantial damage NTSB CHI67D0309Accident · No injuriesClosedStinson 108 · Stockton, ILAug 22, 1966 · N40139 · Substantial damage NTSB CHI67D0169Accident · No injuriesClosedMooney M20 · Lombard, ILAug 20, 1966 · N6528B · Substantial damage NTSB CHI67D0233Accident · No injuriesClosedMooney M20C · Chicago, ILAug 18, 1966 · N2758W · Substantial damage NTSB CHI67F0134Accident · No injuriesClosedBeech D18S · Sugar Grove, ILAug 16, 1966 · N802H · Substantial damage NTSB CHI67D0215Accident · No injuriesClosedAeronca 11AC · Loves Park, ILAug 14, 1966 · N121T · Substantial damage NTSB CHI67F0117Accident · No injuriesClosedPiper PA-24 · Northbrook, ILAug 10, 1966 · N6967P · Substantial damage NTSB CHI67A0022Accident · 2 fatalClosedBeech H35 · Chesterfield, ILAug 10, 1966 · N5488D · Destroyed NTSB CHI67D0244Accident · No injuriesClosedCessna 180 · Arlington Hts, ILAug 7, 1966 · N1787C · Substantial damage NTSB CHI67A0020Accident · Minor injuriesClosedBrantly B-2 · Jacob, ILAug 7, 1966 · N2121U · Destroyed NTSB CHI67F0111Accident · No injuriesClosedStinson 108 · Rockford, ILAug 6, 1966 · N9302K · Substantial damage NTSB CHI67D0346Accident · No injuriesClosedCessna 150 · Chicago, ILAug 6, 1966 · N3047X · Substantial damage NTSB CHI67D0260Accident · No injuriesClosedBeech 35 · Chicago, ILAug 6, 1966 · N717D · Substantial damage NTSB CHI67D0217Accident · No injuriesClosedPiper PA-24 · Elgin, ILAug 6, 1966 · N6174P · Substantial damage NTSB CHI67D0192Accident · No injuriesClosedPiper PA-24 · Elgin, ILAug 5, 1966 · N8217P · Substantial damage NTSB CHI67A0019Accident · No injuriesClosedPiper PA-23 · Chicago, ILAug 5, 1966 · N6093Y · Substantial damage NTSB CHI67F0136Accident · No injuriesClosedCessna 310G · Downers Grove, ILAug 3, 1966 · N2932R · Substantial damage NTSB CHI67F0171Accident · Minor injuriesClosedPiper J3C-65 · Yates City, ILAug 1, 1966 · N6379H · Destroyed NTSB CHI67D0216Accident · No injuriesClosedPiper PA-22 · Midlothain, ILJul 30, 1966 · N5857Z · Substantial damage NTSB CHI67D0124Accident · No injuriesClosedCessna 150 · Rockford, ILJul 30, 1966 · N8021S · Substantial damage NTSB CHI67A0017Accident · No injuriesClosedHughes 269A · Joliet, ILJul 28, 1966 · N8940F · Substantial damage NTSB CHI67D0523Accident · No injuriesClosedPiper PA-22 · Lemont, ILJul 27, 1966 · N3279B · Substantial damage NTSB CHI67F0311Accident · No injuriesClosedBeech F35 · West Chicago, ILJul 26, 1966 · N5013B · Substantial damage NTSB CHI67A0014Accident · No injuriesClosedBeech 95-C55 · West Chicago, ILJul 26, 1966 · N5903S · Substantial damage NTSB CHI67F0638Accident · Minor injuriesClosedBeech 23 · West Salem, ILJul 24, 1966 · N2364L · Substantial damage NTSB CHI67F0350Accident · Minor injuriesClosedPiper PA-28 · Matteson, ILJul 24, 1966 · N7280W · Substantial damage NTSB CHI67F0323Accident · Serious injuriesClosedCessna 150F · Chicago, ILJul 24, 1966 · N8846S · Destroyed NTSB CHI67F0322Accident · No injuriesClosedCessna 182C · Ottawa, ILJul 24, 1966 · N8573T · Destroyed