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 UNK64X1209Accident · No injuriesClosedPiper PA-22 · Paris, ILApr 7, 1964 · N1901C · Substantial damage NTSB UNK64X1202Accident · No injuriesClosedPiper PA22 · Chicago, ILApr 6, 1964 · N5846Z · Substantial damage NTSB UNK64X1201Accident · No injuriesClosedLuscombe 8A · Lombard, ILApr 6, 1964 · N71955 · Destroyed NTSB UNK64X1073Accident · No injuriesClosedPiper PA22 · Elgin, ILMar 28, 1964 · N5520Z · Substantial damage NTSB UNK64X1065Accident · No injuriesClosedBeechcraft 95 · Mt Carmell, ILMar 28, 1964 · N2786Y · Substantial damage NTSB UNK64X0988Accident · Minor injuriesClosedStinson 108 · Halfday, ILMar 20, 1964 · N97579 · Destroyed NTSB UNK64X0954Accident · No injuriesClosedCessna 175A · Elgin, ILMar 16, 1964 · N7994T · Substantial damage NTSB UNK64X0953Accident · No injuriesClosedPiper PA22 · Chicago, ILMar 16, 1964 · N3664Z · Substantial damage NTSB UNK64X0951Accident · No injuriesClosedCessna 170B · Aurora, ILMar 16, 1964 · N35G · Destroyed NTSB UNK64X0944Accident · Minor injuriesClosedCessna 140 · Lincoln, ILMar 15, 1964 · N5310C · Substantial damage NTSB UNK64X0907Accident · No injuriesClosedCessna 172D · Greenwood, ILMar 14, 1964 · N2506Y · Substantial damage NTSB UNK64X0889Accident · 2 fatalClosedCessna 210D · Kankakee, ILMar 11, 1964 · N9799X · Destroyed NTSB UNK64X0884Accident · No injuriesClosedCessna 205 · Northbrook, ILMar 11, 1964 · N8245Z · Substantial damage NTSB UNK64X0882Accident · No injuriesClosedPiper PA23 · Wheeling, ILMar 11, 1964 · N4506P · Substantial damage NTSB UNK64X0841Accident · 1 fatalClosedDouglas DC-3A · Chicago, ILMar 8, 1964 · N410D · Substantial damage NTSB UNK64X0834Accident · No injuriesClosedPiper PA22 · East Moline, ILMar 7, 1964 · N8816C · Substantial damage NTSB UNK64X0752Accident · No injuriesClosedPiper PA22 · Roselle, ILFeb 29, 1964 · N5526Z · Substantial damage NTSB UNK64X0748Accident · Minor injuriesClosedCessna 150 · Mouline, ILFeb 29, 1964 · N7933E · Destroyed NTSB UNK64X0745Accident · No injuriesClosedPiper PA22 · Chicago, ILFeb 29, 1964 · N4506Z · Substantial damage NTSB UNK64X0717Accident · No injuriesClosedBeechcraft 35H · Marion, ILFeb 27, 1964 · N5421D · Substantial damage NTSB UNK64X0712Accident · No injuriesClosedPiper PA23 · Elgin, ILFeb 27, 1964 · N4784P · Substantial damage NTSB UNK64X0600Accident · No injuriesClosedPiper PA23 · Lockport, ILFeb 17, 1964 · N1329P · Substantial damage NTSB UNK64X0566Accident · 1 fatalClosedCessna 150 · Chicago, ILFeb 14, 1964 · N2030Z · Destroyed NTSB UNK64X0492Accident · No injuriesClosedCessna 310G · East Alton, ILFeb 8, 1964 · N8970Z · Substantial damage NTSB UNK64X0479Accident · No injuriesClosedCessna 120 · Metamora, ILFeb 6, 1964 · N3570V · Substantial damage NTSB UNK64X0468Accident · No injuriesClosedCessna 182 · Northbrook, ILFeb 5, 1964 · N5547B · Substantial damage NTSB UNK64X0444Accident · No injuriesClosedCessna 175 · Decatur, ILFeb 2, 1964 · N7300M · Substantial damage NTSB UNK64X0422Accident · No injuriesClosedCessna 150 · Ringwood, ILFeb 1, 1964 · N5511E · Substantial damage NTSB UNK64X0370Accident · No injuriesClosedCessna 210 · Pekin, ILJan 26, 1964 · N9556T · Substantial damage NTSB UNK64X0312Accident · No injuriesClosedCessna 140 · Huey, ILJan 21, 1964 · N76421 · Substantial damage NTSB UNK64X0310Accident · No injuriesClosedCessna 182 · Northbrook, ILJan 21, 1964 · N3180U · Substantial damage NTSB UNK64X0222Accident · No injuriesClosedCessna 170B · Gibson City, ILJan 11, 1964 · N3409C · Substantial damage NTSB UNK64X0190Accident · No injuriesClosedBeechcraft 35 · Chicago, ILJan 8, 1964 · N3365V · Substantial damage NTSB UNK64X0184Accident · No injuriesClosedNavion A · Peoria, ILJan 7, 1964 · N8801H · Substantial damage NTSB UNK64X0155Accident · No injuriesClosedPiper PA24 · Wheeling, ILJan 4, 1964 · N6526P · Substantial damage NTSB CHI63A0182Accident · Serious injuriesClosedLockheed 188 · Chicago, ILJun 8, 1963 · N6134A · No damage NTSB CHI63A0156Accident · No injuriesClosedDouglas DC-3 · Peoria, ILMar 18, 1963 · N143D · Substantial damage NTSB CHI63A0131Accident · No injuriesClosedConvair 880 · Chicago, ILJan 1, 1963 · N819TW · Substantial damage NTSB CHI62A0017Accident · No injuriesClosedDouglas DC-7B · Chicago, ILFeb 3, 1962 · N837D · Substantial damage NTSB CHI62A0009Accident · No injuriesClosedDouglas DC-7 · Chicago, ILJan 20, 1962 · N6326C · 2 aircraft · Substantial damage