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 CHI65F0196Accident · No injuriesClosedBeechcraft C-35 · Belleville, ILApr 29, 1965 · N5921C · Substantial damage NTSB CHI65A0093Accident · 2 fatalClosedAero Comm 500B · Rockford, ILApr 29, 1965 · N78333 · Destroyed NTSB CHI65A0092Accident · 3 fatalClosedNavion A · Peoria, ILApr 27, 1965 · N4506K · Destroyed NTSB CHI66F0011Accident · No injuriesClosedCessna 175 · Bloomington, ILApr 23, 1965 · N6502E · Substantial damage NTSB CHI66F0014Accident · No injuriesClosedCessna 182 · Clinton, ILApr 20, 1965 · N3665U · Substantial damage NTSB CHI66D0037Accident · No injuriesClosedCessna 182 · Genoa, ILApr 18, 1965 · N6258A · Substantial damage NTSB CHI66D0022Accident · No injuriesClosedCessna 120 · Bradford, ILApr 18, 1965 · N2000V · Substantial damage NTSB CHI65F0145Accident · No injuriesClosedMooney M20 · Canton, ILApr 18, 1965 · N5533Q · Substantial damage NTSB CHI65D0155Accident · No injuriesClosedPiper PA-22 · Streator, ILApr 13, 1965 · N2941Z · Substantial damage NTSB CHI65F0153Accident · Serious injuriesClosedPiper PA28 · Columbia, ILApr 11, 1965 · N6489W · Destroyed NTSB CHI65F0193Accident · Minor injuriesClosedPiper PA-28 · Antioch, ILApr 10, 1965 · N7225W · Substantial damage NTSB MKC65F0125Accident · No injuriesClosedCessna 310F · East Alton, ILApr 1, 1965 · N6782X · Substantial damage NTSB CHI65F0135Accident · No injuriesClosedNavion NAV-4 · Wheeling, ILMar 31, 1965 · N4813K · Substantial damage NTSB CHI66F0013Accident · No injuriesClosedCessna 210 · Decatur, ILMar 28, 1965 · N9441T · Substantial damage NTSB CHI65I0084Incident · No injuriesClosedDouglas DC-8 · Chicago, ILMar 28, 1965 · N8032U · No damage NTSB CHI65F0151Accident · No injuriesClosedCessna 195 · Paxton, ILMar 26, 1965 · N3893V · Substantial damage NTSB CHI65F0134Accident · No injuriesClosedPiper PA-22 · Crystal Lake, ILMar 26, 1965 · N5092Z · Destroyed NTSB CHI65F0138Accident · No injuriesClosedPiper PA-22 · Waukegan, ILMar 22, 1965 · N5481Z · Substantial damage NTSB CHI65F0162Accident · No injuriesClosedPiper PA-23 · Wheeling, ILMar 21, 1965 · N4537P · Substantial damage NTSB CHI65D0163Accident · No injuriesClosedPiper PA-28 · Wheeling, ILMar 21, 1965 · N8005W · Substantial damage NTSB CHI65D0132Accident · No injuriesClosedChampion 7ECA · Wheeling, ILMar 21, 1965 · N11039 · Substantial damage NTSB CHI65F0091Accident · No injuriesClosedPiper PA-22 · Roselle, ILMar 19, 1965 · N4953Z · Substantial damage NTSB CHI65D0160Accident · Minor injuriesClosedCessna 172 · Chicago, ILMar 18, 1965 · N6152E · Substantial damage NTSB CHI65F0092Accident · No injuriesClosedMooney M20-D · Roselle, ILMar 16, 1965 · N6637U · Substantial damage NTSB CHI65F0113Accident · No injuriesClosedPiper PA-22 · Tinley Park, ILMar 15, 1965 · N2297A · Substantial damage NTSB CHI66D0062Accident · No injuriesClosedMeyers MAC145 · Chicago, ILMar 14, 1965 · N34364 · Substantial damage NTSB CHI65F0149Accident · No injuriesClosedPiper PA-22 · Lombard, ILMar 14, 1965 · N5328Z · Substantial damage NTSB CHI65D0146Accident · No injuriesClosedCessna 172A · Jacksonville, ILMar 13, 1965 · N7470T · Substantial damage NTSB CHI65F0139Accident · Minor injuriesClosedPiper PA-30 · Urbana, ILMar 9, 1965 · N7495Y · Substantial damage NTSB CHI65F0051Accident · No injuriesClosedCessna 182 · Chicago, ILMar 9, 1965 · N3129Y · Substantial damage NTSB CHI65F0082Accident · No injuriesClosedPiper PA-22 · Wheeling, ILMar 7, 1965 · N4969Z · Substantial damage NTSB CHI65 0077Incident · No injuriesClosedBoeing 707 331B · Hicago, ILMar 4, 1965 · N775TW · Minor damage NTSB CHI65F0053Accident · No injuriesClosedBeechcraft 23 · Waukegan, ILFeb 21, 1965 · N2330L · Substantial damage NTSB CHI65F0056Accident · No injuriesClosedStinson 108-2 · Hinsdale, ILFeb 20, 1965 · N9712K · Substantial damage NTSB UNK65X1437Accident · No injuriesClosedPiper PA-22 · Highland, ILFeb 19, 1965 · N9198D · Substantial damage NTSB CHI65A0075Accident · No injuriesClosedBrantly B2B · Cahokia, ILFeb 19, 1965 · N2271U · Substantial damage NTSB CHI65D0048Accident · No injuriesClosedCessna 140 · Sugar Grove, ILFeb 14, 1965 · N76095 · Substantial damage NTSB CHI65F0078Accident · No injuriesClosedBeechcraft D-45 · Half Day, ILFeb 6, 1965 · N6373T · Substantial damage NTSB CHI65F0039Accident · No injuriesClosedBeechraft 95-55B · Des Plaines, ILFeb 6, 1965 · N7970K · Substantial damage NTSB CHI65D0035Accident · No injuriesClosedCessna 172 · Morris, ILFeb 3, 1965 · N8784B · Substantial damage NTSB CHI65D0055Accident · No injuriesClosedBeechcraft 23 · Roselle, ILJan 31, 1965 · N2387Q · Substantial damage NTSB CHI65A0071Accident · 3 fatalClosedPiper PA28 · El Paso, ILJan 31, 1965 · N8709W · Destroyed NTSB CHI65F0029Accident · No injuriesClosedBeechraft 35 · Lockport, ILJan 27, 1965 · N409B · Substantial damage NTSB CHI65F0189Accident · No injuriesClosedPiper PA-22 · Donovan, ILJan 26, 1965 · N3307B · Substantial damage NTSB CHI65A0069Accident · Serious injuriesClosedBoeing B-720B · Chicago, ILJan 23, 1965 · N725US · No damage NTSB CHI65F0156Accident · No injuriesClosedPiper PA-22 · Danville, ILJan 21, 1965 · N8649C · Substantial damage NTSB CHI66F0015Accident · No injuriesClosedPiper PA-22 · Bloomington, ILJan 18, 1965 · N4847Z · Substantial damage NTSB CHI65F0038Accident · No injuriesClosedPiper PA-23 · Des Plaines, ILJan 14, 1965 · N3135P · Substantial damage NTSB CHI65F0083Accident · 1 fatalClosedCessna 182 · Peoria, ILJan 10, 1965 · N8476T · Destroyed NTSB CHI65F0028Accident · No injuriesClosedBeechraft M-23 · Lombard, ILJan 10, 1965 · N2307J · Substantial damage