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 CHI74FEV09Accident · No injuriesClosedCessna 310 · Flora, ILAug 5, 1973 · N1212T · Substantial damage NTSB CHI74FEE06Accident · No injuriesClosedCessna 337 · Rockford, ILAug 5, 1973 · N2528S · Substantial damage NTSB CHI74AEE05Accident · Serious injuriesClosedPiper J-2 · Streamwood, ILAug 5, 1973 · N17854 · Destroyed NTSB CHI74FEV08Accident · No injuriesClosedBrantly B-2B · Eldred, ILAug 4, 1973 · N1122K · Substantial damage NTSB CHI74DEV07Accident · No injuriesClosedCessna 150 · Peoria, ILJul 31, 1973 · N61198 · Substantial damage NTSB CHI74AC011Accident · 2 fatalClosedCessna 172L · Seneca, ILJul 31, 1973 · N7863G · Destroyed NTSB CHI74DEV05Accident · No injuriesClosedBoeing PT-17 · Topeka, ILJul 28, 1973 · N50054 · Substantial damage NTSB CHI74AC009Accident · 1 fatalClosedPiper PA-23 · Chicago, ILJul 27, 1973 · N1483P · Destroyed NTSB CHI74FEV06Accident · No injuriesClosedCessna 150H · Paris, ILJul 25, 1973 · N6478S · Substantial damage NTSB CHI74FEV04Accident · No injuriesClosedPiper PA-28 · Tremont, ILJul 25, 1973 · N55184 · Substantial damage NTSB CHI74FEE04Accident · No injuriesClosedPiper PA-28 · Lansing, ILJul 21, 1973 · N7261F · Substantial damage NTSB CHI74FEV03Accident · No injuriesClosedGrumman G-164A · Shirley, ILJul 18, 1973 · N649U · Substantial damage NTSB CHI74FEE03Accident · No injuriesClosedAeronca 11AC · Naperville, ILJul 18, 1973 · N85917 · Substantial damage NTSB CHI74DEE07Accident · No injuriesClosedCessna 206 · Chicago, ILJul 13, 1973 · N5244U · Substantial damage NTSB CHI74AC006Accident · 1 fatalClosedBell 47G-5A · Peoria, ILJul 13, 1973 · N7984J · Destroyed NTSB CHI74AC005Accident · No injuriesClosedPiper PA-28 · Elgin, ILJul 12, 1973 · N1226T · Substantial damage NTSB CHI74DEE01Accident · No injuriesClosedCessna 172L · Chicago, ILJul 7, 1973 · N4382Q · Substantial damage NTSB CHI74AEV01Accident · No injuriesClosedCessna 140 · Metamora, ILJul 7, 1973 · N2123N · Substantial damage NTSB CHI74FEV02Accident · No injuriesClosedCessna A188A · Bunker Hill, ILJul 6, 1973 · N5623J · Substantial damage NTSB CHI74FEE02Accident · Minor injuriesClosedStinson 108 · Wheeling, ILJul 5, 1973 · N9177K · Substantial damage NTSB CHI73FEV31Accident · No injuriesClosedPiper PA-23 · Springfield, ILJun 27, 1973 · N4506P · Substantial damage NTSB CHI73FEV30Accident · Minor injuriesClosedHoward DGA15P · Pekin, ILJun 23, 1973 · N5707N · Substantial damage NTSB CHI73FEE66Accident · Serious injuriesClosedAeronca 7AC · Streator, ILJun 17, 1973 · N85569 · Destroyed NTSB CHI73FEE68Accident · Minor injuriesClosedCessna 182 · Plainfield, ILJun 16, 1973 · N6258A · Substantial damage NTSB CHI73FEE67Accident · Serious injuriesClosedSchweizer SGU222 · Huntly, ILJun 16, 1973 · N91836 · No damage NTSB CHI73IC098Incident · No injuriesClosedDouglas DC-8 · Chicago, ILJun 15, 1973 · N6161A · Minor damage NTSB CHI73FEV29Accident · 1 fatalClosedStits SA-3A · Macomb, ILJun 10, 1973 · N74872 · Destroyed NTSB CHI73DEE65Accident · No injuriesClosedCessna 150 · Joliet, ILJun 9, 1973 · N6798G · Substantial damage NTSB CHI73FEE64Accident · No injuriesClosedBellanca 7ECA · Lockport, ILJun 8, 1973 · N90977 · Substantial damage NTSB CHI73AC094Accident · No injuriesClosedBeech E18S · Chicago, ILJun 7, 1973 · N250RP · Substantial damage NTSB CHI73FEE62Accident · Minor injuriesClosedPiper PA-28 · Naperville, ILJun 3, 1973 · N8014N · Substantial damage NTSB CHI73FEE61Accident · Minor injuriesClosedCessna 182 · Rochelle, ILJun 2, 1973 · N5718B · Substantial damage NTSB CHI73FEE60Accident · No injuriesClosedPiper PA-31 · Chicago, ILMay 28, 1973 · N50RS · Substantial damage NTSB CHI73DEE63Accident · Minor injuriesClosedCessna 150L · Frankfort, ILMay 25, 1973 · N18534 · Substantial damage NTSB CHI73FEE58Accident · No injuriesClosedCessna 421 · Crystal Lake, ILMay 21, 1973 · N354WP · Substantial damage NTSB CHI73FEE59Accident · No injuriesClosedLuscombe 8A · Aurora, ILMay 20, 1973 · N2239K · Substantial damage NTSB CHI73AC090Accident · 2 fatalClosedCessna 150F · Hillsboro, ILMay 19, 1973 · N7756F · Destroyed NTSB CHI73FCA05Accident · Minor injuriesClosedCessna 150 · Cahokia, ILMay 18, 1973 · N6272S · Substantial damage NTSB CHI73DEV28Accident · No injuriesClosedPiper PA-22 · Galesburg, ILMay 16, 1973 · N3152Z · Substantial damage NTSB CHI73FEE57Accident · No injuriesClosedBeech 35 · Frankln Grove, ILMay 5, 1973 · N3891N · Substantial damage NTSB CHI73FEE56Accident · No injuriesClosedPiper PA-24 · Joliet, ILMay 5, 1973 · N7132P · Substantial damage NTSB CHI73FEE55Accident · No injuriesClosedPiper PA-23 · Elgin, ILMay 2, 1973 · N6903Y · Substantial damage NTSB CHI73FEE54Accident · No injuriesClosedBellanca 17-30A · Polo, ILMay 1, 1973 · N39816 · Substantial damage NTSB CHI73DEV27Accident · No injuriesClosedCessna 172I · Danville, ILApr 30, 1973 · N46006 · Substantial damage NTSB CHI73FEV26Accident · Minor injuriesClosedPiper PA-28 · Springfield, ILApr 29, 1973 · N8719N · Substantial damage NTSB CHI73DEV25Accident · No injuriesClosedCessna 150 · Peoria, ILApr 22, 1973 · N60778 · Substantial damage NTSB CHI73AC084Accident · 2 fatalClosedPiper PA-28 · Aledo, ILApr 22, 1973 · N7727N · Destroyed NTSB CHI73FEE53Accident · No injuriesClosedCessna 310L · Rockford, ILApr 17, 1973 · N10DB · Substantial damage NTSB CHI73DEE51Accident · No injuriesClosedBeech 35-B33 · Plainfield, ILApr 11, 1973 · N9554Y · Substantial damage NTSB CHI73FEE50Accident · Serious injuriesClosedVolksplane 473 · Naperville, ILApr 8, 1973 · N6552 · Substantial damage