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 CHI78DEE45Accident · No injuriesClosedCessna 170B · Kewanee, ILJun 12, 1978 · N4692C · Substantial damage NTSB CHI78DEV38Accident · No injuriesClosedCessna 188 · Ashmore, ILJun 9, 1978 · N4729R · Substantial damage NTSB CHI78FEE43Accident · No injuriesClosedAerostar 601P · West Chicago, ILJun 5, 1978 · N711NW · Substantial damage NTSB CHI78FEE42Accident · Minor injuriesClosedStearman B75N1 · Oak Brook, ILJun 4, 1978 · N64993 · Substantial damage NTSB CHI78FEE46Accident · No injuriesClosedCessna 152 · Chicago, ILJun 2, 1978 · N67564 · Destroyed NTSB CHI78FEE40Accident · 1 fatalClosedGrum Amer AA1-B · Antioch, ILMay 29, 1978 · N1505R · Destroyed NTSB CHI78FEE41Accident · Minor injuriesClosedCessna 210 · Kewanee, ILMay 27, 1978 · N1797X · Substantial damage NTSB CHI78FEV36Accident · No injuriesClosedPiper PA-28 · Palestine, ILMay 26, 1978 · N3592R · Substantial damage NTSB CHI78DEV35Accident · No injuriesClosedHughes 269C · Maroa, ILMay 26, 1978 · N7473F · Substantial damage NTSB CHI78FEE38Accident · No injuriesClosedBeech G-18 · Dekalb, ILMay 23, 1978 · N8087 · Substantial damage NTSB CHI78FEE44Accident · Serious injuriesClosedTaylorcraft BC12-D · Aurora, ILMay 21, 1978 · N44349 · Substantial damage NTSB CHI78DEV32Accident · No injuriesClosedPiper PA-28 · Macomb, ILMay 20, 1978 · N9258C · Substantial damage NTSB CHI78FEE37Accident · Minor injuriesClosedCessna 337 · Dupage, ILMay 17, 1978 · N2180X · Substantial damage NTSB CHI78FEV33Accident · No injuriesClosedCessna 172A · Chrisman, ILMay 10, 1978 · N7282T · Substantial damage NTSB CHI78DEE33Accident · No injuriesClosedHughes 269C · Mendota, ILMay 6, 1978 · N7476F · Substantial damage NTSB CHI78FEE36Accident · No injuriesClosedCessna 152 · Belvidere, ILMay 2, 1978 · N757EE · Substantial damage NTSB CHI78DEE39Accident · No injuriesClosedPiper PA-28 · Mendota, ILApr 30, 1978 · N8765N · Substantial damage NTSB CHI78DEV31Accident · No injuriesClosedMustang P-51 · Gibson City, ILApr 29, 1978 · N37952 · Substantial damage NTSB CHI78FEE31Accident · No injuriesClosedAmateur SA-300 · Dekalb, ILApr 27, 1978 · N2369 · Substantial damage NTSB CHI78DEE32Accident · Minor injuriesClosedCessna 210 · Annawan, ILApr 25, 1978 · N4850U · Substantial damage NTSB CHI78FEE30Accident · No injuriesClosedN American NA265 · West Chicago, ILApr 24, 1978 · N600BP · Substantial damage NTSB CHI78FA036Accident · 2 fatalClosedBellanca 7KCAB · Rockford, ILApr 24, 1978 · N41680 · Destroyed NTSB CHI78FEE34Accident · Minor injuriesClosedPiper PA-28 · Grayslake, ILApr 22, 1978 · N8897E · Substantial damage NTSB CHI78FEV29Accident · No injuriesClosedBeech C-23 · Peoria, ILApr 16, 1978 · N24026 · Substantial damage NTSB CHI78FEV30Accident · No injuriesClosedPiper PA-32 · Urbana, ILApr 9, 1978 · N1BQ · Substantial damage NTSB CHI78FEE35Accident · Serious injuriesClosedPiper PA-22 · Marseilles, ILApr 9, 1978 · N2563A · Substantial damage NTSB CHI78DEV26Accident · Minor injuriesClosedCessna 140 · Trivoli, ILApr 9, 1978 · N4158N · Substantial damage NTSB CHI78FEV25Accident · 1 fatalClosedBell 47-G · Clinton, ILApr 7, 1978 · N3574 · Destroyed NTSB CHI78DEV28Accident · No injuriesClosedEnstrom 28A · Bloomington, ILApr 6, 1978 · N24RB · Substantial damage NTSB CHI78DEV27Accident · No injuriesClosedPiper PA-28 · Bloomington, ILApr 6, 1978 · N40299 · Substantial damage NTSB CHI78FEV23Accident · No injuriesClosedCessna 152 · Monmouth, ILMar 27, 1978 · N24242 · 2 aircraft · Substantial damage NTSB CHI78DEV24Accident · No injuriesClosedGrumman G-164 · Hudson, ILMar 27, 1978 · N4238 · Substantial damage NTSB CHI78FA031Accident · 3 fatalClosedBeech H18 · Centreville, ILMar 25, 1978 · N58JM · Destroyed NTSB CHI78FEV22Accident · 1 fatalClosedHughes 500D · Ellisville, ILMar 17, 1978 · N8393F · Substantial damage NTSB CHI79FA028Accident · 1 fatalClosedPiper PA-32R · Rock Falls, ILMar 14, 1978 · N7299C · Destroyed NTSB CHI78FA026Accident · No injuriesClosedPiper PA-23 · Chicago, ILMar 13, 1978 · N54227 · Substantial damage NTSB CHI78FA025Accident · 3 fatalClosedCessna T210M · Beecher, ILMar 12, 1978 · N761EJ · Destroyed NTSB CHI78DEE29Accident · No injuriesClosedCessna 150M · Lansing, ILMar 10, 1978 · N9215U · Substantial damage NTSB CHI78FEE27Accident · Serious injuriesClosedCessna 150 · Plainfield, ILMar 9, 1978 · N6662S · No damage NTSB CHI78DEV20Accident · No injuriesClosedCessna 150 · Carbondale, ILMar 6, 1978 · N66009 · Substantial damage NTSB CHI78DEE57Accident · No injuriesClosedPiper PA-30 · Monee, ILMar 6, 1978 · N8665Y · Substantial damage NTSB CHI78FEV19Accident · Minor injuriesClosedBeech A35 · Quincy, ILMar 5, 1978 · N8479A · Substantial damage NTSB CHI78DEV21Accident · No injuriesClosedCessna 152 · Peoria, ILMar 5, 1978 · N25038 · Substantial damage NTSB CHI78DEE28Accident · No injuriesClosedCessna 150M · West Chicago, ILMar 5, 1978 · N704LF · Substantial damage NTSB CHI78FEV18Accident · No injuriesClosedCessna 177 · Matoon, ILFeb 26, 1978 · N30105 · Substantial damage NTSB CHI78FEE25Accident · No injuriesClosedCessna 150 · Wheeling, ILFeb 26, 1978 · N19277 · Substantial damage NTSB CHI78DEE26Accident · No injuriesClosedPiper PA-28 · Rockton, ILFeb 26, 1978 · N4017F · Substantial damage NTSB CHI78DEE24Accident · No injuriesClosedCessna 150M · Lockport, ILFeb 22, 1978 · N9408U · Substantial damage NTSB CHI78DEE23Accident · No injuriesClosedCessna 150 · Wheeling, ILFeb 19, 1978 · N9474U · Substantial damage NTSB CHI78IA024Incident · No injuriesClosedSwearingen SA226 · Chicago, ILFeb 16, 1978 · N2625 · Minor damage