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 CHI66D0771Accident · No injuriesClosedCessna 150 · East St.Louis, ILMay 8, 1966 · N8391G · Substantial damage NTSB CHI66F0719Accident · No injuriesClosedCessna 150F · Rockford, ILMay 7, 1966 · N8331G · Substantial damage NTSB CHI66F0726Accident · No injuriesClosedPiper PA-23 · West Chicago, ILMay 5, 1966 · N1247P · Substantial damage NTSB CHI66D0700Accident · No injuriesClosedPiper PA-22 · Galva, ILMay 5, 1966 · N3317A · Substantial damage NTSB CHI67D0321Accident · No injuriesClosedBeech K35 · Momence, ILMay 3, 1966 · N9527R · Substantial damage NTSB CHI67D0054Accident · No injuriesClosedPiper PA-20 · Joliet, ILMay 2, 1966 · N7430K · Substantial damage NTSB CHI67D0002Accident · No injuriesClosedLuscombe 8F · Ringwood, ILMay 1, 1966 · N2000B · Substantial damage NTSB CHI66F0708Accident · No injuriesClosedCessna 150 · Rockford, ILMay 1, 1966 · N6630F · Substantial damage NTSB CHI66F0712Accident · No injuriesClosedPiper PA-23 · Quincy, ILApr 28, 1966 · N503GD · Substantial damage NTSB CHI66F0692Accident · No injuriesClosedBeech 23 · Hoffman Estes, ILApr 28, 1966 · N2317L · Substantial damage NTSB CHI67F0450Accident · No injuriesClosedPiper PA-30 · Albion, ILApr 26, 1966 · N7966Y · Substantial damage NTSB CHI67F0004Accident · Serious injuriesClosedCessna 150 · Streator, ILApr 26, 1966 · N3574J · Destroyed NTSB CHI66D0677Accident · No injuriesClosedPiper PA-12 · Minooka, ILApr 16, 1966 · N7769H · Substantial damage NTSB CHI66D0669Accident · No injuriesClosedCessna T-50 · E St Louis, ILApr 13, 1966 · N30L · Substantial damage NTSB CHI66D0721Accident · No injuriesClosedChampion 7ECA · Naperville, ILApr 9, 1966 · N9513S · Substantial damage NTSB CHI66A0085Accident · 2 fatalClosedLuscombe 8C · East St Louis, ILApr 9, 1966 · N45848 · Destroyed NTSB CHI67D0326Accident · No injuriesClosedPiper PA-28 · Casey, ILApr 8, 1966 · N4660R · Substantial damage NTSB CHI66F0668Accident · No injuriesClosedCessna 150 · Springfield, ILApr 8, 1966 · N5849E · Substantial damage NTSB CHI66D0691Accident · No injuriesClosedPiper PA-22 · Herscher, ILApr 8, 1966 · N5485Z · Substantial damage NTSB CHI66F0687Accident · No injuriesClosedCessna 210 · Onee, ILApr 7, 1966 · N3935Y · Substantial damage NTSB CHI66D0772Accident · No injuriesClosedPiper PA-23 · Chicago, ILApr 6, 1966 · N1100J · Substantial damage NTSB CHI66D0635Accident · No injuriesClosedPiper PA-28 · Grayslake, ILApr 5, 1966 · N6652W · Substantial damage NTSB CHI66F0730Accident · No injuriesClosedCessna 140 · Springfield, ILApr 3, 1966 · N77365 · Substantial damage NTSB CHI66F0717Accident · Minor injuriesClosedStinson V77 · Naperville, ILApr 2, 1966 · N79129 · Substantial damage NTSB CHI66D0709Accident · Minor injuriesClosedTaylorcraft BL-65 · Ludlow, ILMar 31, 1966 · N2224P · Substantial damage NTSB CHI66F0703Accident · No injuriesClosedCessna 210 · Byron, ILMar 29, 1966 · N7475E · Substantial damage NTSB CHI66A0079Accident · 1 fatalClosedCessna 310C · Chicago, ILMar 29, 1966 · N1878H · Substantial damage NTSB CHI66F0667Accident · No injuriesClosedChampion 7FC · Champaign, ILMar 25, 1966 · N7690E · Substantial damage NTSB CHI66F0650Accident · No injuriesClosedBeech E18S · Quincy, ILMar 25, 1966 · N2427 · Substantial damage NTSB CHI66A0078Accident · 3 fatalClosedNavion L-17B · Aroma Park, ILMar 24, 1966 · N6076V · Destroyed NTSB CHI67F0320Accident · No injuriesClosedCessna 210 · Paxton, ILMar 23, 1966 · N9432T · Substantial damage NTSB CHI67F0113Accident · No injuriesClosedN.American F-51D · Wheeling, ILMar 20, 1966 · N2112 · 2 aircraft · Substantial damage NTSB CHI66D0683Accident · No injuriesClosedCessna 172 · Chicago, ILMar 20, 1966 · N2052Y · Substantial damage NTSB CHI66D0676Accident · No injuriesClosedBeech A35 · Crystal Lake, ILMar 20, 1966 · N515B · Substantial damage NTSB CHI66A0077Accident · 1 fatalClosedAeronca CF · Jonesboro, ILMar 19, 1966 · N22391 · Destroyed NTSB CHI67F0008Accident · Minor injuriesClosedLear 23 · Chicago, ILMar 18, 1966 · N316M · Substantial damage NTSB CHI66D0690Accident · No injuriesClosedBeech E35 · Chicago, ILMar 18, 1966 · N3259C · Substantial damage NTSB CHI66F0693Accident · No injuriesClosedPiper PA-28 · West Chicago, ILMar 17, 1966 · N6244W · Substantial damage NTSB CHI66F0684Accident · No injuriesClosedErco 415-C · Danville, ILMar 17, 1966 · N93682 · Substantial damage NTSB CHI66D0659Accident · No injuriesClosedBeech G18S · Chicago, ILMar 17, 1966 · N56K · Substantial damage NTSB CHI66F0674Accident · No injuriesClosedBeech G35 · West Chicago, ILMar 13, 1966 · N4411D · Substantial damage NTSB CHI66F0630Accident · No injuriesClosedAlon A-2 · Waukegan, ILMar 11, 1966 · N6357V · Substantial damage NTSB CHI66F0627Accident · No injuriesClosedBeech B-95 · Barrington, ILMar 10, 1966 · N1117K · Destroyed NTSB CHI66F0698Accident · No injuriesClosedChampion 7FC · Savoy, ILMar 9, 1966 · N7693E · Substantial damage NTSB CHI66F0678Accident · No injuriesClosedPiper PA-16 · Barstow, ILMar 8, 1966 · N5184H · Substantial damage NTSB CHI66F0675Accident · No injuriesClosedCessna 150 · Northbrook, ILMar 7, 1966 · N2570J · Substantial damage NTSB CHI66F0621Accident · No injuriesClosedCessna 172E · E Alton, ILMar 4, 1966 · N3501S · Substantial damage NTSB CHI66A0074Accident · Serious injuriesClosedDouglas DC-9 · Chicago, ILMar 4, 1966 · N3307L · No damage NTSB CHI66F0599Accident · No injuriesClosedPiper J-3 · Grays Lake, ILMar 2, 1966 · N6471A · Substantial damage NTSB CHI66D0688Accident · No injuriesClosedPiper PA-23 · Chicago, ILMar 1, 1966 · N1304P · Substantial damage