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 CHI76DEV03Accident · No injuriesClosedPiper PA-25 · Sheldon, ILJul 20, 1975 · N7753Z · Substantial damage NTSB CHI76DEE07Accident · No injuriesClosedPitts S-1S · Gilberts, ILJul 20, 1975 · N76NZ · Substantial damage NTSB CHI75DEE06Accident · No injuriesClosedMonnett 2 · Elgin, ILJul 19, 1975 · N11ME · Substantial damage NTSB CHI76IC005Incident · No injuriesClosedBoeing 747 · Chicago, ILJul 17, 1975 · N4717U · Minor damage NTSB CHI76FEE05Accident · No injuriesClosedBeech B35 · Hinsdale, ILJul 15, 1975 · N8824A · Substantial damage NTSB CHI76FEE02Accident · Serious injuriesClosedCessna 172F · Kankakee, ILJul 15, 1975 · N8220U · Substantial damage NTSB CHI76DEE04Accident · No injuriesClosedCessna 150L · Ottawa, ILJul 13, 1975 · N16178 · Substantial damage NTSB CHI76FEE09Accident · No injuriesClosedPiper PA-34 · Hinckley, ILJul 12, 1975 · N41494 · Substantial damage NTSB CHI76FEV02Accident · No injuriesClosedBell 47G · Forsyth, ILJul 11, 1975 · N7924S · Substantial damage NTSB CHI76FEV01Accident · No injuriesClosedCessna 172G · Bloomington, ILJul 7, 1975 · N5726R · Substantial damage NTSB CHI76FEE01Accident · No injuriesClosedBeech A23 · Wheeling, ILJul 7, 1975 · N7876M · Substantial damage NTSB CHI76DEE03Accident · No injuriesClosedCessna 175 · Stockton, ILJul 1, 1975 · N9490B · Substantial damage NTSB CHI75FEV41Accident · No injuriesClosedCessna 182 · Gibson City, ILJun 30, 1975 · N42714 · Substantial damage NTSB CHI75FEV40Accident · Minor injuriesClosedMooney M20C · Lewiston, ILJun 30, 1975 · N6540U · Substantial damage NTSB CHI75DEE71Accident · Minor injuriesClosedGrum Amer AA1-A · Geneseo, ILJun 28, 1975 · N9377L · Substantial damage NTSB CHI75FEV39Accident · No injuriesClosedCessna 150 · Carbondale, ILJun 27, 1975 · N8490G · Substantial damage NTSB CHI75FEE70Accident · No injuriesClosedBeech B95 · Crystal Lake, ILJun 21, 1975 · N171W · Substantial damage NTSB CHI75FEE69Accident · No injuriesClosedPiper PA-28 · Belvidere, ILJun 21, 1975 · N6398R · 2 aircraft · Minor damage NTSB CHI75FEE68Accident · No injuriesClosedPiper PA-34 · Union Hill, ILJun 21, 1975 · N33742 · Substantial damage NTSB CHI75FEV38Accident · No injuriesClosedCessna 182 · Peoria, ILJun 19, 1975 · N3090F · Substantial damage NTSB CHI75DEV37Accident · No injuriesClosedJeanies Teenie · Lincoln, ILJun 8, 1975 · N28RT · Substantial damage NTSB CHI75DEV36Accident · No injuriesClosedBell 47D-1 · Carmi, ILJun 6, 1975 · N74121 · Destroyed NTSB CHI75DEE67Accident · Minor injuriesClosedPiper PA-22 · Oswego, ILJun 5, 1975 · N3036Z · Substantial damage NTSB CHI75FEV34Accident · No injuriesClosedCessna 172L · Mt Sterling, ILJun 3, 1975 · N4229Q · Substantial damage NTSB CHI75DEV35Accident · Minor injuriesClosedCessna 175 · Loraine, ILJun 1, 1975 · N9368B · Substantial damage NTSB CHI75DEV33Accident · No injuriesClosedPiper PA-28 · Loda, ILMay 31, 1975 · N7535R · Substantial damage NTSB CHI75AC092Accident · 4 fatalClosedPiper PA-30 · Marion, ILMay 31, 1975 · N7833Y · Destroyed NTSB CHI75FEV32Accident · Serious injuriesClosedBeech A23 · Shelbyville, ILMay 30, 1975 · N3511R · Destroyed NTSB CHI75DEE64Accident · Serious injuriesClosedTaylorcraft BC12-D · Chicago Hts, ILMay 26, 1975 · N95278 · Substantial damage NTSB CHI75DEE63Accident · No injuriesClosedCessna 182 · Kewanee, ILMay 26, 1975 · N8473S · Substantial damage NTSB CHI75FEE62Accident · No injuriesClosedPiper PA-24 · Dixon, ILMay 25, 1975 · N8526P · Substantial damage NTSB CHI75FEE61Accident · No injuriesClosedCessna 185 · Minooka, ILMay 24, 1975 · N7SR · Substantial damage NTSB CHI75AC091Accident · 5 fatalClosedCessna 177B · Carpentersvile, ILMay 24, 1975 · N30836 · Destroyed NTSB CHI75FEE66Accident · Serious injuriesClosedPiper PA-28 · Kankakee, ILMay 23, 1975 · N4836T · Substantial damage NTSB CHI75FEE65Accident · Minor injuriesClosedBrantly B2B · Wheeling, ILMay 20, 1975 · N2264U · Substantial damage NTSB CHI75AC090Accident · 1 fatalClosedDehavilland OH104 · Chicago, ILMay 20, 1975 · N1536V · Destroyed NTSB CHI75AC084Accident · 2 fatalClosedPiper PA-28 · Peoria, ILMay 8, 1975 · N43427 · Destroyed NTSB CHI75DEE60Accident · No injuriesClosedGrum Amer AA1-B · Rockford, ILMay 3, 1975 · N9885L · Substantial damage NTSB CHI75FEES9|CHI75FEE59Accident · No injuriesClosedBeech A36 · Rockford, ILMay 1, 1975 · N3116W · 2 aircraft · Substantial damage NTSB CHI75FEE56Accident · No injuriesClosedSikorsky S-55B · Chicago, ILApr 27, 1975 · N90407 · Destroyed NTSB CHI75DEE57Accident · No injuriesClosedPiper J3C-65 · Bradford, ILApr 26, 1975 · N6264H · Substantial damage NTSB CHI75FEV31Accident · 1 fatalClosedBell 47D1 · Shawneetown, ILApr 21, 1975 · N7734 · Destroyed NTSB CHI75DCA06Accident · No injuriesClosedHiller Acft UH12D · Lebanon, ILApr 15, 1975 · N62417 · Substantial damage NTSB CHI75AC078Accident · 2 fatalClosedPiper PA-28 · Trimble, ILApr 14, 1975 · N95243 · Destroyed NTSB CHI75FEV30Accident · No injuriesClosedCessna 150H · Pittsfield, ILApr 12, 1975 · N23303 · Substantial damage NTSB CHI75AC077Accident · 2 fatalClosedFunk B85C · Monee, ILApr 12, 1975 · N81195 · Destroyed NTSB CHI75FEV29Accident · No injuriesClosedBeech B19 · Savoy, ILApr 5, 1975 · N5105R · Substantial damage NTSB CHI75DEE55Accident · No injuriesClosedPiper PA-28 · Mt Carroll, ILApr 5, 1975 · N7255W · Substantial damage NTSB CHI75FEV28Accident · No injuriesClosedPiper PA-25 · Blue Mound, ILApr 1, 1975 · N8842L · Substantial damage NTSB CHI75FEV27Accident · Serious injuriesClosedCessna 188 · Johnson City, ILMar 31, 1975 · N9936G · Substantial damage