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 CHI76FEV58Accident · No injuriesClosedBeech F35 · Urbana, ILAug 7, 1976 · N3894B · Substantial damage NTSB CHI76DEV57Accident · No injuriesClosedCessna 177 · Salem, ILAug 6, 1976 · N2849X · Substantial damage NTSB CHI76FEV55Accident · 1 fatalClosedStitts SA3A · Jerseyville, ILAug 1, 1976 · N3645G · Destroyed NTSB CHI76FEE69Accident · No injuriesClosedSportster HA-2M · Rockford, ILJul 29, 1976 · N158 · Substantial damage NTSB CHI76FEV53Accident · No injuriesClosedCessna 172M · Jerseyville, ILJul 26, 1976 · N13381 · Substantial damage NTSB CHI76DEV51Accident · No injuriesClosedPiper PA-28 · Newton, ILJul 26, 1976 · N43544 · Substantial damage NTSB CHI76FEV56Accident · No injuriesClosedPiper PA-25 · Berwick, ILJul 25, 1976 · N4333Y · Substantial damage NTSB CHI76FEE67Accident · No injuriesClosedPiper PA-28 · Schaumburg, ILJul 25, 1976 · N3943K · Substantial damage NTSB CHI76DEE68Accident · No injuriesClosedPiper PA-28 · Streator, ILJul 25, 1976 · N489FL · Substantial damage NTSB CHI76FEV54Accident · Minor injuriesClosedCessna 150L · Okawville, ILJul 24, 1976 · N10774 · Substantial damage NTSB CHI76FEV52Accident · Serious injuriesClosedHughes 369HS · Woodland, ILJul 24, 1976 · N9200F · Substantial damage NTSB CHI76FEE66Accident · Minor injuriesClosedPiper PA-32 · Rockford, ILJul 23, 1976 · N4177W · Substantial damage NTSB CHI76AC080Accident · 1 fatalClosedMooney M20F · Crestwood, ILJul 21, 1976 · N3286F · Destroyed NTSB CHI76FEV50Accident · No injuriesClosedHughes 269C · Maroa, ILJul 20, 1976 · N7435F · Destroyed NTSB CHI76FEV49Accident · 1 fatalClosedPiper PA-25 · Cerro Gordo, ILJul 20, 1976 · N9811P · Destroyed NTSB CHI76DEV48Accident · No injuriesClosedCessna 172 · Buckner, ILJul 19, 1976 · N5476T · Substantial damage NTSB CHI76FC079|CHI76AC079Accident · 5 fatalClosedCessna 150M · Rockford, ILJul 17, 1976 · N66375 · 2 aircraft · Destroyed NTSB CHI76DEV47Accident · No injuriesClosedPiper PA-25 · Wyoming, ILJul 2, 1976 · N6816Z · Substantial damage NTSB CHI76AC075Accident · 4 fatalClosedPiper PA-30 · Joliet, ILJul 1, 1976 · N7332Y · Destroyed NTSB CHI76FEV46Accident · No injuriesClosedLuscombe 8A · Lincoln, ILJun 28, 1976 · N77923 · Substantial damage NTSB CHI76DEE65Accident · No injuriesClosedBeech A23-24 · Joliet, ILJun 27, 1976 · N4745J · Substantial damage NTSB CHI76DEE64Accident · No injuriesClosedSchweizer SGS135 · Hinckley, ILJun 26, 1976 · N34266 · Substantial damage NTSB CHI76AC073Accident · 1 fatalClosedBeech 95-C55 · Chicago, ILJun 24, 1976 · N2034W · Destroyed NTSB CHI76FEV45Accident · Serious injuriesClosedBell 47J-2A · Carlyle, ILJun 20, 1976 · N3537S · Destroyed NTSB CHI76FEE63Accident · Minor injuriesClosedCessna 150H · Sandwich, ILJun 20, 1976 · N755J · Substantial damage NTSB CHI76FEV44Accident · No injuriesClosedCessna 172 · Pinckneyville, ILJun 17, 1976 · N13209 · Substantial damage NTSB CHI76FEE62Accident · No injuriesClosedBeech B23 · Wheeling, ILJun 17, 1976 · N2147W · Substantial damage NTSB CHI76AC068Accident · 2 fatalClosedPiper PA-18A · Belvidere, ILJun 12, 1976 · N1587A · Destroyed NTSB CHI76AC067Accident · 1 fatalClosedCessna 150M · Peoria, ILJun 9, 1976 · N66101 · Destroyed NTSB CHI76FEV43Accident · 1 fatalClosedCessna A188B · Monmouth, ILJun 8, 1976 · N70349 · Destroyed NTSB CHI76FEV42Accident · No injuriesClosedCessna 150M · Springfield, ILJun 5, 1976 · N8993U · Substantial damage NTSB CHI76FEE61Accident · No injuriesClosedAero Comdr 500A · Dekalb, ILJun 3, 1976 · N78379 · Substantial damage NTSB CHI76AC066Accident · 3 fatalClosedCessna 172M · Shelbyville, ILMay 31, 1976 · N80946 · Destroyed NTSB CHI76AC065Accident · 7 fatalClosedBeech G-18S · West Chicago, ILMay 31, 1976 · N174YC · Destroyed NTSB CHI76FEV40Accident · 1 fatalClosedThorp T-18 · Hull, ILMay 29, 1976 · N4277 · Destroyed NTSB CHI76FEV41Accident · No injuriesClosedBoeing A75N1 · Canton, ILMay 23, 1976 · N52533 · Substantial damage NTSB CHI76DEE60Accident · No injuriesClosedCessna 172M · Chicago, ILMay 22, 1976 · N5162R · Substantial damage NTSB CHI76FEE59Accident · No injuriesClosedPiper PA-32 · Dwight, ILMay 21, 1976 · N9424K · Substantial damage NTSB CHI76FEV39Accident · No injuriesClosedCessna 150M · Springfield, ILMay 19, 1976 · N66380 · Substantial damage NTSB CHI76FEE58Accident · Serious injuriesClosedMustang I · New Lenox, ILMay 15, 1976 · N31246 · Substantial damage NTSB CHI76FEE57Accident · Serious injuriesClosedBeech B24R · Freeport, ILMay 10, 1976 · N1938L · Substantial damage NTSB CHI76FEV38Accident · No injuriesClosedPiper PA-22 · Mansfield, ILMay 9, 1976 · N2965Z · Substantial damage NTSB CHI76FEV36Accident · No injuriesClosedMaule M5210C · Waynesville, ILMay 6, 1976 · N222AR · Substantial damage NTSB CHI76AC061Accident · No injuriesClosedBoeing 747 · Chicago, ILMay 6, 1976 · N9672 · Substantial damage NTSB CHI76FEV34Accident · Serious injuriesClosedBell 47G-2 · Lawrenceville, ILMay 4, 1976 · N200J · Substantial damage NTSB CHI76FEV33Accident · No injuriesClosedCessna 172H · Jerseyville, ILMay 2, 1976 · N2588L · Substantial damage NTSB CHI76DEV35Accident · No injuriesClosedPiper PA-28 · Fairbury, ILMay 2, 1976 · N7821W · Substantial damage NTSB CHI76FEV37Accident · No injuriesClosedCessna 150D · Pickneyville, ILMay 1, 1976 · N4164U · Substantial damage NTSB CHI76FEV32Accident · No injuriesClosedHiller Acft UH-12D · Eldred, ILApr 29, 1976 · N62417 · Substantial damage NTSB CHI76DEV31Accident · No injuriesClosedPiper PA-28 · Blandinsville, ILApr 29, 1976 · N7387W · Substantial damage