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 CHI81FEE09Accident · No injuriesClosedCessna 152 · Crystal Lake, ILNov 25, 1980 · N5221B · Substantial damage NTSB CHI81DEV05Accident · No injuriesClosedCessna 152 · St Francisvill, ILNov 21, 1980 · N49150 · Substantial damage NTSB CHI81FEV04Accident · No injuriesClosedPiper PA-25 · Chrisman, ILNov 15, 1980 · N8830L · Substantial damage NTSB CHI81FEE07Accident · Serious injuriesClosedCessna 182 · Grayslake, ILNov 14, 1980 · N9964B · Substantial damage NTSB CHI81FEE06Accident · Serious injuriesClosedSonerai I · Lansing, ILNov 8, 1980 · N40JP · Substantial damage NTSB CHI81FEE08Accident · No injuriesClosedAero Comdr 720 · Wheeling, ILNov 5, 1980 · N825WD · Substantial damage NTSB CHI81FEE05Accident · No injuriesClosedMooney M20E · Chicago, ILNov 2, 1980 · N79840 · Substantial damage NTSB CHI81FEE04Accident · No injuriesClosedBeech 95-B55 · Wheeling, ILOct 31, 1980 · N20525 · Substantial damage NTSB CHI81FCA04Accident · Serious injuriesClosedPiper PA-32 · St Jacob, ILOct 26, 1980 · N10DR · Destroyed NTSB CHI81IA003Incident · No injuriesClosedBeech 95-C55 · Galena, ILOct 25, 1980 · N21RW · Minor damage NTSB CHI81DA002Accident · No injuriesClosedCessna 402 · Moline, ILOct 23, 1980 · N8125F · Substantial damage NTSB CHI81FCA02Accident · 2 fatalClosedAlvarez Polli · Grantfork, ILOct 14, 1980 · N1035S · Destroyed NTSB CHI81FEV03Accident · No injuriesClosedGrady KR-2 · Jacksonville, ILOct 12, 1980 · N2312N · Substantial damage NTSB CHI81FEE03Accident · Serious injuriesClosedCessna 182P · Romeoville, ILOct 12, 1980 · N21510 · Destroyed NTSB CHI81FCA03Accident · No injuriesClosedCessna 152 · Cahokia, ILOct 11, 1980 · N68729 · Substantial damage NTSB CHI81DCA01Accident · No injuriesClosedCessna 182RG · Cahokia, ILOct 8, 1980 · N4709S · Substantial damage NTSB CHI81DEV02Accident · No injuriesClosedBeech B19 · Sidney, ILOct 4, 1980 · N5105R · Substantial damage NTSB CHI81FEE02Accident · Minor injuriesClosedCessna R182 · Chicago, ILOct 3, 1980 · N1811R · Destroyed NTSB CHI81FEE01Accident · Serious injuriesClosedPiper PA-28 · Huntley, ILOct 2, 1980 · N3071H · Substantial damage NTSB CHI81DEV01Accident · Minor injuriesClosedGrumman G-164 · Golden, ILOct 1, 1980 · N615Y · Destroyed NTSB CHI80FEE53Accident · No injuriesClosedCessna 310Q · West Chicago, ILSep 30, 1980 · N310CT · Substantial damage NTSB CHI80DEE57Accident · No injuriesClosedBLN Works FF-7 · Rock Island, ILSep 30, 1980 · N1532B · Substantial damage NTSB CHI80FEV40Accident · Serious injuriesClosedBensen B8M · St. Joseph, ILSep 28, 1980 · N30087 · Substantial damage NTSB CHI80FEV39Accident · No injuriesClosedCessna 188 · Mill Shoals, ILSep 23, 1980 · N731SV · Substantial damage NTSB CHI80FA069Accident · 1 fatalClosedCessna 150J · Akin, ILSep 22, 1980 · N60771 · Destroyed NTSB CHI80DEE56Accident · No injuriesClosedCessna 172 · Lansing, ILSep 19, 1980 · N4779E · Substantial damage NTSB CHI80DEE52Accident · No injuriesClosedCessna 152 · Lockport, ILSep 19, 1980 · N4658B · Substantial damage NTSB CHI80FEE51Accident · No injuriesClosedBeech G18S · Lansing, ILSep 17, 1980 · N9400Y · Substantial damage NTSB CHI80FA068Accident · No injuriesClosedLear Jet 23 · Waukegan, ILSep 16, 1980 · N12GP · Substantial damage NTSB CHI80FEV38Accident · Minor injuriesClosedJeanies Teenie · Shelbyville, ILSep 14, 1980 · N3774C · Substantial damage NTSB CHI80DEE55Accident · No injuriesClosedPiper PA-28 · New Lenox, ILSep 13, 1980 · N55526 · Substantial damage NTSB CHI80FEE50Accident · No injuriesClosedCessna 152 · Aurora, ILSep 9, 1980 · N67381 · Substantial damage NTSB CHI80FEV37Accident · Serious injuriesClosedPiper PA-24 · Monticello, ILSep 6, 1980 · N9214P · Substantial damage NTSB CHI80FA067Accident · 1 fatalClosedAero Comdr 680FL · Chicago, ILSep 3, 1980 · N4700E · Destroyed NTSB CHI80DEE49Accident · No injuriesClosedGrumman AA-5A · Greenwood, ILSep 3, 1980 · N9682U · Substantial damage NTSB CHI80FEE47Accident · 1 fatalClosedVari-Eze Heiman · Huntley, ILSep 1, 1980 · N5021Y · Destroyed NTSB CHI80DEE48Accident · No injuriesClosedCessna 182 · Dwight, ILAug 29, 1980 · N373LA · Substantial damage NTSB CHI80FEE45Accident · No injuriesClosedLake LA-4 · Highland Park, ILAug 25, 1980 · N6183V · Substantial damage NTSB CHI80DCA02Accident · No injuriesClosedPiper PA-28 · Columbia, ILAug 24, 1980 · N5135W · Substantial damage NTSB CHI80FEE44Accident · No injuriesClosedChampion 7GCAA · Bolingbrook, ILAug 23, 1980 · N6319N · Substantial damage NTSB CHI80DEE54Accident · Serious injuriesClosedCessna 172 · Grayslake, ILAug 20, 1980 · N5713A · Substantial damage NTSB CHI80FEV35Accident · No injuriesClosedWeatherly 201C · Colusa, ILAug 18, 1980 · N9040W · Substantial damage NTSB CHI80FEV36Accident · No injuriesClosedCessna 337G · Bloomington, ILAug 15, 1980 · N53517 · Substantial damage NTSB CHI80FEE42Accident · Serious injuriesClosedBede 4 · Dekalb, ILAug 14, 1980 · N441RH · Destroyed NTSB CHI80DEE46Accident · No injuriesClosedBeech C23 · Elgin, ILAug 14, 1980 · N6001V · Substantial damage NTSB CHI80DEE43Accident · No injuriesClosedCessna 172N · Rockford, ILAug 14, 1980 · N6205F · Destroyed NTSB CHI80FEV33Accident · No injuriesClosedCessna 172M · Litchfield, ILAug 5, 1980 · N20139 · Substantial damage NTSB CHI80FEE41Accident · 1 fatalClosedMurphy RV-3 · Streator, ILAug 5, 1980 · N66CJ · Destroyed NTSB CHI80FEV31Accident · No injuriesClosedGrumman 164B · Maroa, ILAug 4, 1980 · N48445 · Destroyed NTSB CHI80FCA01Accident · Minor injuriesClosedBell 206A · Cahokia, ILAug 3, 1980 · N7864S · Substantial damage