Skip to content

NTSB investigations, IL

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 CHI79FA079Accident · No injuriesClosedCessna 402C · Chicago, ILSep 18, 1979 · N2713R · Substantial damage NTSB CHI79FA078Accident · 2 fatalClosedCessna 172G · Brownstown, ILSep 18, 1979 · N3623L · Destroyed NTSB CHI79FA077Accident · No injuriesClosedBoeing 707 · Palatine, ILSep 18, 1979 · N7566 · Substantial damage NTSB CHI79DEV31Accident · No injuriesClosedCessna 152 · Galesburg, ILSep 13, 1979 · N68988 · Substantial damage NTSB CHI79DA074Accident · No injuriesClosedPiper PA-28R · Moline, ILSep 9, 1979 · N56373 · Substantial damage NTSB CHI79FEE76Accident · Serious injuriesClosedBrown V-EZE · Plainfield, ILSep 8, 1979 · N67BB · Destroyed NTSB CHI79FEE74Accident · Minor injuriesClosedCessna 182P · Sandwich, ILSep 2, 1979 · N6065F · Substantial damage NTSB CHI79FEV30Accident · Minor injuriesClosedCessna 182A · Hillsboro, ILSep 1, 1979 · N4890D · Substantial damage NTSB CHI79FI070Incident · No injuriesClosedDouglas DC-9 · Chicago, ILAug 30, 1979 · N772NC · Minor damage NTSB CHI79DEE77Accident · No injuriesClosedBeech C35 · Chicago, ILAug 22, 1979 · N692D · Substantial damage NTSB CHI79FEV29Accident · No injuriesClosedPiper PA-23 · Champaign, ILAug 3, 1979 · N105EB · Substantial damage NTSB CHI79FEE78Accident · Minor injuriesClosedPiper PA-32R · West Chicago, ILAug 2, 1979 · N2654Q · Substantial damage NTSB CHI79DEE75Accident · Minor injuriesClosedBoeing E-75N1 · Erie, ILJul 31, 1979 · N3975B · Destroyed NTSB CHI79FA062Accident · 1 fatalClosedCessna 150M · Peoria, ILJul 28, 1979 · N704NU · Destroyed NTSB CHI79FA061Accident · 1 fatalClosedMooney M20C · Brocton, ILJul 26, 1979 · N6217U · Destroyed NTSB CHI79FEE70Accident · No injuriesClosedScorpion TOO · Rockford, ILJul 23, 1979 · N36JB · Substantial damage NTSB CHI79DEV28Accident · No injuriesClosedBrantly B-2B · Flanagan, ILJul 23, 1979 · N2283U · Substantial damage NTSB CHI79FEV27Accident · 1 fatalClosedSmith BGL · Macomb, ILJul 22, 1979 · N69119 · Substantial damage NTSB CHI79FEE69Accident · Minor injuriesClosedBenson B-8M · Rockford, ILJul 22, 1979 · N65232 · Destroyed NTSB CHI79FEE72Accident · Minor injuriesClosedLach/Bensen B8M · Rockford, ILJul 20, 1979 · N8447 · Substantial damage NTSB CHI79FEV26Accident · No injuriesClosedCessna 172N · Jerseyville, ILJul 19, 1979 · N733LT · Substantial damage NTSB CHI79FEE67Accident · No injuriesClosedFriling Variez · Plainfield, ILJul 17, 1979 · N28JF · Substantial damage NTSB CHI79FEV25Accident · No injuriesClosedPiper PA-32 · Tremont, ILJul 14, 1979 · N3849W · Substantial damage NTSB UNK79X0112Accident · Minor injuriesClosedGrumman AA-5B · Polo, ILJul 13, 1979 · N28411 · Substantial damage NTSB CHI80FA058Accident · 1 fatalClosedBeech 35-33 · Wheeling, ILJul 12, 1979 · N306Z · Destroyed NTSB CHI79DEE80Accident · No injuriesClosedCessna 152 · Dwight, ILJul 8, 1979 · N714ZY · Destroyed NTSB CHI79FA057Accident · 3 fatalClosedPiper PA-22 · St Charles, ILJul 4, 1979 · N3027Z · Destroyed NTSB CHI79FA052Accident · 2 fatalClosedCessna 172M · Chenoa, ILJul 3, 1979 · N64168 · Destroyed NTSB CHI79FEE66Accident · Serious injuriesClosedBowers DSA1 · Princeton, ILJun 26, 1979 · N9228A · Substantial damage NTSB CHI79FEE65Accident · No injuriesClosedCessna 310G · Harvard, ILJun 24, 1979 · N949R · Substantial damage NTSB CHI79FCA04Accident · No injuriesClosedAerostar 601P · East St Louis, ILJun 22, 1979 · N9808Q · Substantial damage NTSB CHI79DEE63Accident · No injuriesClosedPiper PA-38 · Lansing, ILJun 19, 1979 · N2365N · Substantial damage NTSB CHI79FEE64Accident · No injuriesClosedPiper PA-28 · Chicago, ILJun 17, 1979 · N55486 · Destroyed NTSB CHI79DEE62Accident · No injuriesClosedCessna 172 · Putnam, ILJun 17, 1979 · N73592 · Substantial damage NTSB CHI79FEV24Accident · No injuriesClosedCessna 182H · Rushville, ILJun 15, 1979 · N8516S · Substantial damage NTSB CHI79FEE61Accident · No injuriesClosedPiper PA-38 · Grayslake, ILJun 13, 1979 · N2466T · Destroyed NTSB CHI79FEV23Accident · Serious injuriesClosedGreat Lakes 2T-1A · Taylorville, ILJun 9, 1979 · N5998L · Substantial damage NTSB CHI79FA052Accident · 2 fatalClosedBeech 99 · Chicago, ILJun 9, 1979 · N454SA · Destroyed NTSB CHI79DEE73Accident · No injuriesClosedMooney M20J · Chicago, ILJun 5, 1979 · N777LT · Substantial damage NTSB CHI79FEE58Accident · No injuriesClosedCessna 310H · West Chicago, ILJun 2, 1979 · N1121Q · Substantial damage NTSB CHI79FA050Accident · 1 fatalClosedRockwell 112A · Huntley, ILMay 27, 1979 · N1454J · Destroyed NTSB CHI79FEV22Accident · 1 fatalClosedLuscomb 8A · Garrett, ILMay 26, 1979 · N2381 · Destroyed NTSB DCA79AA017Accident · 271 fatalClosedDouglas DC-10 · Chicago, ILMay 25, 1979 · N110AA · Destroyed NTSB CHI79DEE59Accident · No injuriesClosedPiper PA-38 · Schaumburg, ILMay 25, 1979 · N2572D · Substantial damage NTSB CHI79FEE60Accident · No injuriesClosedCessna 172M · New Lenox, ILMay 20, 1979 · N6962H · 2 aircraft · Destroyed NTSB CHI79FEV21Accident · No injuriesClosedHughes 269B · Flanagan, ILMay 19, 1979 · N9323F · Substantial damage NTSB CHI79DEE57Accident · No injuriesClosedGrumman AA5 · Harvard, ILMay 19, 1979 · N5484L · Substantial damage NTSB CHI79DEV20Accident · No injuriesClosedPitts S1C · Sparland, ILMay 15, 1979 · N230K · Substantial damage NTSB CHI79DEE55Accident · Minor injuriesClosedPitts S-2A · Rockford, ILMay 12, 1979 · N7UD · Destroyed NTSB CHI79FEV19Accident · No injuriesClosedCessna 152 · Gillespie, ILMay 6, 1979 · N68341 · Substantial damage