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 CHI80FEV34Accident · No injuriesClosedCessna 177 · Urbana, ILAug 1, 1980 · N2344Y · Substantial damage NTSB CHI80FEV32Accident · No injuriesClosedPiper PA-22 · Pontiac, ILJul 29, 1980 · N8714C · Substantial damage NTSB CHI80FEE37Accident · Serious injuriesClosedSkybolt BG-1 · Crystal Lake, ILJul 28, 1980 · N79BG · Minor damage NTSB CHI80DEV30Accident · No injuriesClosedBell 47D-1 · Rantoul, ILJul 28, 1980 · N8271E · Substantial damage NTSB CHI80FEV29Accident · No injuriesClosedStinson 108-3 · Chester, ILJul 27, 1980 · N4066C · Substantial damage NTSB DEN80IA050Incident · No injuriesClosedDouglas DC-10 · Chicago, ILJul 24, 1980 · N1802U · No damage NTSB CHI80FA059Accident · 2 fatalClosedCessna T310 · Cahokia, ILJul 24, 1980 · N1231G · Destroyed NTSB CHI80FEE34Accident · No injuriesClosedCessna A188B · Pecatonica, ILJul 23, 1980 · N4905R · Substantial damage NTSB CHI80FEE35Accident · No injuriesClosedVolmer VJ22 · Sublette, ILJul 22, 1980 · N6857 · Substantial damage NTSB CHI80FEE38Accident · No injuriesClosedPiper PA-23 · Waukegan, ILJul 16, 1980 · N1700U · Substantial damage NTSB CHI80FA056Accident · No injuriesClosedCessna 310R · Galesburg, ILJul 15, 1980 · N87497 · Substantial damage NTSB CHI80FEV27Accident · No injuriesClosedGrumman G-164B · Atlanta, ILJul 14, 1980 · N6654K · Substantial damage NTSB CHI80FEV26Accident · No injuriesClosedPiper PA-36 · Mc Lean, ILJul 11, 1980 · N57842 · Substantial damage NTSB CHI80FEE32Accident · No injuriesClosedCessna T210M · Huntley, ILJul 11, 1980 · N6822B · Destroyed NTSB CHI80DEE33Accident · No injuriesClosedCessna 172 · Kankakee, ILJul 11, 1980 · N75633 · Substantial damage NTSB CHI80FEV28Accident · No injuriesClosedCessna 172 · Peoria, ILJul 10, 1980 · N9356E · Substantial damage NTSB CHI80DEE36Accident · No injuriesClosedCessna 150M · Wonder Lake, ILJul 10, 1980 · N704LB · Substantial damage NTSB CHI80FEV25Accident · No injuriesClosedPiper PA-28 · Lacon, ILJul 7, 1980 · N5796W · Substantial damage NTSB CHI80DEE40Accident · No injuriesClosedCessna 150 · Lockport, ILJul 4, 1980 · N3946V · Substantial damage NTSB CHI80DEE31Accident · No injuriesClosedPiper PA28RT · West Chicago, ILJun 24, 1980 · N2904A · Substantial damage NTSB CHI80FEE39Accident · Minor injuriesClosedCessna 182F · Glenview, ILJun 23, 1980 · N3416U · Substantial damage NTSB CHI80FA049Accident · 2 fatalClosedBellanca 8KCAB · Clifton, ILJun 22, 1980 · N4PM · Destroyed NTSB CHI80DEE29Accident · No injuriesClosedCessna 172N · Belvidere, ILJun 22, 1980 · N4770J · Substantial damage NTSB CHI80FEE30Accident · No injuriesClosedSchweizer 1-35 · Hinckley, ILJun 20, 1980 · N34266 · Destroyed NTSB CHI80FEE28Accident · No injuriesClosedPiper PA-28 · West Chicago, ILJun 18, 1980 · N81351 · Substantial damage NTSB CHI80DEE27Accident · No injuriesClosedCessna 152 · Wheeling, ILJun 11, 1980 · N4609B · Substantial damage NTSB CHI80FEV24Accident · No injuriesClosedCessna 170 · Brighton, ILJun 5, 1980 · N2963D · Substantial damage NTSB CHI80DEE25Accident · Serious injuriesClosedS.Z.D. Jantar · Lemont, ILMay 31, 1980 · N62AS · Substantial damage NTSB CHI80FEE24Accident · Minor injuriesClosedMooney M20E · Waukegan, ILMay 27, 1980 · N3247F · Substantial damage NTSB CHI80FA043Accident · 3 fatalClosedMooney M20C · Byron, ILMay 24, 1980 · N9347V · Destroyed NTSB CHI80FEV23Accident · No injuriesClosedCessna 310L · Carbondale, ILMay 23, 1980 · N3250X · Substantial damage NTSB CHI80FA038Accident · No injuriesClosedCessna 402 · Savoy, ILMay 18, 1980 · N8125F · Substantial damage NTSB CHI80FEE23Accident · No injuriesClosedBoeing A75N1 · Marengo, ILMay 4, 1980 · N4997V · Substantial damage NTSB CHI80FEE21Accident · Serious injuriesClosedPiper PA-28 · Naperville, ILApr 20, 1980 · N16306 · Substantial damage NTSB CHI80FEV21Accident · No injuriesClosedCessna 150M · Danforth, ILApr 19, 1980 · N704ZJ · Substantial damage NTSB CHI80FEV22Accident · Minor injuriesClosedHughes 369HS · Grayville, ILApr 18, 1980 · N9086F · Substantial damage NTSB CHI80DEE20Accident · No injuriesClosedCessna 172 · Plato Center, ILApr 16, 1980 · N4288F · Substantial damage NTSB CHI80FA034Accident · 3 fatalClosedCessna 182 · Alhambra, ILApr 13, 1980 · N6405A · Destroyed NTSB CHI80FEE19Accident · Serious injuriesClosedAvion Stamp SV4A · Downers Grove, ILApr 5, 1980 · N12425 · Substantial damage NTSB CHI80FEV20Accident · No injuriesClosedCessna 182RG · Jerseyville, ILMar 28, 1980 · N2067S · Substantial damage NTSB CHI80DEV19Accident · No injuriesClosedBeech 19 · Savoy, ILMar 26, 1980 · N5101R · Substantial damage NTSB CHI80FA030Accident · 1 fatalClosedCessna 210D · Chicago, ILMar 21, 1980 · N210RV · Destroyed NTSB CHI80FEV18Accident · No injuriesClosedCessna 182 · Monmouth, ILMar 18, 1980 · N1272S · Substantial damage NTSB CHI80FEV17Accident · Serious injuriesClosedCessna 182M · Peoria, ILMar 14, 1980 · N71669 · Destroyed NTSB CHI80DEE26Accident · No injuriesClosedCessna 152 · Lockport, ILMar 9, 1980 · N7352W · Substantial damage NTSB CHI80DEE18Accident · No injuriesClosedLuscombe 8 · Huntley, ILMar 6, 1980 · N1330B · Substantial damage NTSB CHI80FEE17Accident · No injuriesClosedSikorsky S-58 · Chicago, ILMar 2, 1980 · N4388S · Destroyed NTSB CHI80FEE16Accident · Serious injuriesClosedBeech 95-C55 · Rock Island, ILFeb 20, 1980 · N53RC · Destroyed NTSB CHI80DEE22Accident · No injuriesClosedBeech 95-B55 · Princeton, ILFeb 20, 1980 · N53UP · Substantial damage NTSB CHI80DEV16Accident · No injuriesClosedCessna 150 · Metropolis, ILFeb 13, 1980 · N1559Q · Substantial damage