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 CHI78DEE67Accident · No injuriesClosedCessna 150 · Wheeling, ILSep 16, 1978 · N9437U · Substantial damage NTSB CHI78FEV53Accident · No injuriesClosedCessna 180A · Sparta, ILSep 15, 1978 · N9560B · Substantial damage NTSB CHI78FA067Accident · No injuriesClosedBeech 18T · Chicago, ILSep 13, 1978 · N12VT · Substantial damage NTSB CHI78FA064Accident · 6 fatalClosedPiper PA-31 · Savoy, ILSep 9, 1978 · N26AN · Destroyed NTSB CHI78DEE69Accident · No injuriesClosedCessna 172 · Princeton, ILSep 4, 1978 · N1417U · Substantial damage NTSB CHI78FEV52Accident · No injuriesClosedBeech 23 · Minonk, ILSep 1, 1978 · N2301J · Substantial damage NTSB CHI78DEE71Accident · No injuriesClosedThorp T-18 · Schaumburg, ILSep 1, 1978 · N711RF · Substantial damage NTSB CHI78IA061Incident · No injuriesClosedLockheed L-1011 · Chicago, ILAug 31, 1978 · N701DA · No damage NTSB CHI78FEE64Accident · No injuriesClosedPiper PA-23 · Frankfort, ILAug 29, 1978 · N303EB · Substantial damage NTSB CHI78FEV51Accident · No injuriesClosedGrumman G-164 · Greenfield, ILAug 24, 1978 · N723Y · Substantial damage NTSB CHI78FEE65Accident · Minor injuriesClosedPiper PA-28 · New Lenox, ILAug 24, 1978 · N41503 · Destroyed NTSB CHI78DEE63Accident · No injuriesClosedPiper PA-32R · Princeton, ILAug 22, 1978 · N101DR · Substantial damage NTSB CHI78FEV49Accident · No injuriesClosedBell OH-13H · Wellington, ILAug 17, 1978 · N9008T · Substantial damage NTSB CHI78FEV50Accident · No injuriesClosedHughes 269C · Chestnut, ILAug 16, 1978 · N7437F · Substantial damage NTSB CHI79FEE59Accident · Minor injuriesClosedGreat Lakes 2T-1A2 · West Chicago, ILAug 13, 1978 · N3725F · Substantial damage NTSB CHI78IA057Incident · No injuriesClosedDouglas DC-9 · Springfield, ILAug 12, 1978 · N1273L · No damage NTSB CHI79FEE62Accident · No injuriesClosedCessna 172 · Dwight, ILAug 9, 1978 · N9200H · Substantial damage NTSB CHI78FEV47Accident · No injuriesClosedGreat Lakes 2T1A2 · Peoria, ILAug 9, 1978 · N3807F · Substantial damage NTSB CHI78FEV34Accident · 1 fatalClosedVari-Viggen · Urbana, ILAug 8, 1978 · N29HR · Destroyed NTSB CHI78FA055Accident · Minor injuriesClosedBeech D18S · Chicago, ILAug 8, 1978 · N79R · Destroyed NTSB CHI78FA054Accident · Serious injuriesClosedDouglas DC-10 · Chicago, ILAug 8, 1978 · N102AA · No damage NTSB CHI78IA056Incident · Serious injuriesClosedBoeing 707 · Chicago, ILAug 6, 1978 · N746TW · No damage NTSB CHI78FEV48Accident · Minor injuriesClosedCessna U206F · Yates City, ILAug 6, 1978 · N50625 · Substantial damage NTSB CHI78FA052Accident · 2 fatalClosedPiper PA-22 · East Moline, ILAug 6, 1978 · N3217B · 2 aircraft · Destroyed NTSB CHI78FEE60Accident · No injuriesClosedCessna 320C · West Chicago, ILJul 31, 1978 · N3021T · Substantial damage NTSB CHI78FEE47Accident · Minor injuriesClosedBeech 35-B33 · Rockford, ILJul 28, 1978 · N9798Y · Substantial damage NTSB CHI78DEV45Accident · No injuriesClosedPiper PA-25 · Laprairie, ILJul 27, 1978 · N9747P · Destroyed NTSB CHI78FEV46Accident · No injuriesClosedCessna 172 · Springfield, ILJul 26, 1978 · N15FP · Substantial damage NTSB CHI78FEE58Accident · No injuriesClosedPiper PA-30 · Wheeling, ILJul 26, 1978 · N8788Y · Substantial damage NTSB CHI78DEE66Accident · No injuriesClosedCessna 150 · Aperville, ILJul 18, 1978 · N3026S · Substantial damage NTSB CHI78FEV43Accident · No injuriesClosedCessna 310P · Peoria, ILJul 14, 1978 · N310AM · Substantial damage NTSB CHI78FEE56Accident · No injuriesClosedBeech 65-90 · Chicago, ILJul 12, 1978 · N742UT · Substantial damage NTSB CHI78FEV42Accident · No injuriesClosedHughes 269A · Williamsfield, ILJul 10, 1978 · N8774F · Substantial damage NTSB CHI78FEE51Accident · No injuriesClosedSchweizer SGU222 · Park Forest, ILJul 9, 1978 · N9848E · Substantial damage NTSB CHI78FEV44Accident · No injuriesClosedCessna 150 · Peoria, ILJul 8, 1978 · N45530 · Substantial damage NTSB CHI78FEE53Accident · Serious injuriesClosedBrantly B2B · Huntley, ILJul 8, 1978 · N2100U · Destroyed NTSB CHI78FEE50Accident · No injuriesClosedPiper PA-28 · Kankakee, ILJul 4, 1978 · N6116H · Substantial damage NTSB CHI78FEE49Accident · Serious injuriesClosedGrum Amer AA1-A · Hillsdale, ILJul 4, 1978 · N9397L · Destroyed NTSB CHI78FEE52Accident · No injuriesClosedBeech B19 · Moline, ILJul 1, 1978 · N6507R · Substantial damage NTSB CHI78FEE61Accident · No injuriesClosedMurphy RV3 · Streator, ILJun 29, 1978 · N66CJ · Substantial damage NTSB CHI78FEV41Accident · No injuriesClosedPiper PA-20 · Galesburg, ILJun 28, 1978 · N7323K · Substantial damage NTSB CHI78FEE54Accident · No injuriesClosedCessna 152 · Wheeling, ILJun 28, 1978 · N714ZD · Substantial damage NTSB CHI78FCA01Accident · Minor injuriesClosedNavion NAV-4 · Bethalto, ILJun 25, 1978 · N4992K · Substantial damage NTSB CHI78FA045Accident · 3 fatalClosedPiper PA-23 · Belleville, ILJun 25, 1978 · N3284P · Destroyed NTSB CHI78DEE55Accident · Serious injuriesClosedSemco AX7 · Mchenry, ILJun 24, 1978 · N35996 · Substantial damage NTSB CHI78FEV40Accident · No injuriesClosedCessna A188B · Ramsey, ILJun 23, 1978 · N731CF · Substantial damage NTSB CHI78DEE48Accident · No injuriesClosedCessna 150 · Plato Center, ILJun 21, 1978 · N11554 · Substantial damage NTSB CHI78DEV39Accident · No injuriesClosedPiper PA-28 · Mclean, ILJun 19, 1978 · N2488M · Substantial damage NTSB CHI78FCA02Accident · Serious injuriesClosedPiper PA-16 · Columbia, ILJun 18, 1978 · N5907H · Substantial damage NTSB CHI78FEV37Accident · No injuriesClosedPiper PA-28 · Bloomington, ILJun 13, 1978 · N2257Q · Substantial damage