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 CHI80FEV14Accident · No injuriesClosedPiper PA-28R · Sherman, ILFeb 12, 1980 · N4620J · Substantial damage NTSB CHI80DEE15Accident · No injuriesClosedCessna 150 · Mt.Morris, ILFeb 8, 1980 · N8964U · Substantial damage NTSB CHI80DEV15Accident · No injuriesClosedCessna 340 · Bloomington, ILFeb 5, 1980 · N340FS · Substantial damage NTSB CHI80FA025Accident · 2 fatalClosedPiper PA-22 · Princeton, ILFeb 2, 1980 · N3747A · Destroyed NTSB CHI80AA024Accident · 2 fatalClosedFalcon 10 · Chicago, ILJan 30, 1980 · N253K · Destroyed NTSB CHI80AA022Accident · Minor injuriesClosedDouglas DC-8 · Chicago, ILJan 23, 1980 · N783FT · Substantial damage NTSB CHI80DEV13Accident · No injuriesClosedForney F-1A · Sheldon, ILJan 22, 1980 · N30546 · Substantial damage NTSB CHI80FA021Accident · 2 fatalClosedCessna 310Q · Winthrop Hbr, ILJan 16, 1980 · N40AK · Destroyed NTSB CHI80FEE10Accident · Minor injuriesClosedPiper PA-34 · Streator, ILJan 14, 1980 · N3964X · Substantial damage NTSB CHI80FEV12Accident · No injuriesClosedPiper PA-28R · Sullivan, ILJan 12, 1980 · N7646J · Substantial damage NTSB CHI80FEE14Accident · No injuriesClosedPiper PA-34 · Elgin, ILJan 3, 1980 · N30100 · Substantial damage NTSB CHI80FEE13Accident · Minor injuriesClosedCessna 210 · Monee, ILJan 2, 1980 · N8319Z · Substantial damage NTSB CHI80FA019Accident · 2 fatalClosedPiper PA-28R · Kankakee, ILDec 28, 1979 · N7644J · Destroyed NTSB CHI80FA016Accident · 2 fatalClosedCessna 172K · Edwardsville, ILDec 21, 1979 · N736UL · Destroyed NTSB CHI80DA018Accident · 2 fatalClosedBeech B58 · Taylorville, ILDec 21, 1979 · N2058X · Destroyed NTSB CHI80DEE12Accident · No injuriesClosedCessna 172N · Schaumburg, ILDec 14, 1979 · N4870D · Substantial damage NTSB CHI80FEE11Accident · No injuriesClosedPiper PA-30 · Chicago, ILDec 6, 1979 · N7119Y · Substantial damage NTSB CHI80FEV11Accident · No injuriesClosedCessna 150H · Springfield, ILDec 3, 1979 · N22931 · Substantial damage NTSB CHI80FEV10Accident · No injuriesClosedMooney M20K · Lacon, ILNov 25, 1979 · N231FD · Substantial damage NTSB CHI80FEE08Accident · Minor injuriesClosedBeech 76 · West Chicago, ILNov 25, 1979 · N6038Y · Substantial damage NTSB CHI80DEV09Accident · No injuriesClosedBeech A23-19 · Pittsfield, ILNov 25, 1979 · N3618Q · Substantial damage NTSB CHI80FA009Accident · Minor injuriesClosedCessna T210L · Galesburg, ILNov 23, 1979 · N22434 · Substantial damage NTSB CHI80FEV07Accident · 1 fatalClosedAmerican AA-1B · Charleston, ILNov 22, 1979 · N6245L · Destroyed NTSB CHI80FEV08Accident · No injuriesClosedPiper PA-28R · Girard, ILNov 19, 1979 · N853 · Substantial damage NTSB CHI80FEE07Accident · No injuriesClosedPiper PA-24 · Chicago, ILNov 16, 1979 · N7058P · Substantial damage NTSB CHI80DEE05Accident · Minor injuriesClosedCessna 150L · Freeport, ILNov 12, 1979 · N10056 · Substantial damage NTSB CHI80DEE06Accident · No injuriesClosedCessna 152 · Rock City, ILOct 30, 1979 · N67392 · Substantial damage NTSB CHI80FEV06Accident · No injuriesClosedBellanca 7KCAB · Makanda, ILOct 24, 1979 · N4210Y · Substantial damage NTSB CHI80DEE04Accident · Minor injuriesClosedPiper PA-28 · Chicago, ILOct 21, 1979 · N1741T · Substantial damage NTSB CHI80FEV05Accident · Minor injuriesClosedErco 415-C · Grafton, ILOct 19, 1979 · N2676H · Substantial damage NTSB CHI80DA004Accident · 1 fatalClosedCessna A150L · Spring Valley, ILOct 15, 1979 · N5936J · Destroyed NTSB CHI80DEE03Accident · No injuriesClosedCessna 182J · Wheeling, ILOct 13, 1979 · N3596F · Substantial damage NTSB CHI80FEE02Accident · No injuriesClosedCessna 172N · New Lenox, ILOct 12, 1979 · N733QH · Substantial damage NTSB CHI80FEV03Accident · No injuriesClosedAeronca 7AC · Brookport, ILOct 11, 1979 · N3504E · Substantial damage NTSB CHI80DEV02Accident · No injuriesClosedBeech B19 · Sidney, ILOct 10, 1979 · N5104R · Substantial damage NTSB CHI80DEV01Accident · Serious injuriesClosedSchweizer SGU222 · Moweaqua, ILOct 7, 1979 · N9917J · Substantial damage NTSB CHI79FA002Accident · 3 fatalClosedPiper PA-32R · Elgin, ILOct 5, 1979 · N61424 · Destroyed NTSB CHI80FEE01Accident · Serious injuriesClosedPiper PA-28 · Kankakee, ILOct 4, 1979 · N54386 · Destroyed NTSB CHI79FEV35Accident · 1 fatalClosedBellanca 8KCAB · Alma, ILSep 30, 1979 · N499AC · Substantial damage NTSB CHI79FEE85Accident · No injuriesClosedBeech F35 · Utica, ILSep 30, 1979 · N3386C · Substantial damage NTSB CHI79FEE86Accident · 1 fatalClosedVolksplane VP-1 · Plainfield, ILSep 29, 1979 · N655 · Substantial damage NTSB CHI79DEE84Accident · No injuriesClosedCessna 172 · Elgin, ILSep 28, 1979 · N9347E · Substantial damage NTSB CHI79DEE82Accident · No injuriesClosedCessna 337 · Peru, ILSep 27, 1979 · N110RL · Substantial damage NTSB CHI79DEE83Accident · No injuriesClosedBeech 35-B33 · Joliet, ILSep 25, 1979 · N8621M · Substantial damage NTSB CHI79DEV34Accident · No injuriesClosedPiper PA-38 · Mt Sterling, ILSep 23, 1979 · N4306E · Substantial damage NTSB CHI79DEV33Accident · No injuriesClosedBoeing A-75 · Champaign, ILSep 23, 1979 · N49999 · Substantial damage NTSB CHI79DEE81Accident · No injuriesClosedBlanik L-13 · Freeport, ILSep 22, 1979 · N99943 · Substantial damage NTSB CHI79DEE79Accident · No injuriesClosedBeech A36 · Schaumburg, ILSep 21, 1979 · N9451Q · Substantial damage NTSB CHI79DEE88Accident · No injuriesClosedPiper PA-25 · La Moille, ILSep 20, 1979 · N8816L · Substantial damage NTSB CHI79FEV32Accident · No injuriesClosedPiper PA-38 · Jerseyville, ILSep 18, 1979 · N2388T · Substantial damage