Fatal NTSB investigations, IL

5 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.

Cases per year

19852026
Fatal NTSB investigations, IL per year, 1985–2026: 5 cases
19851
19861
19881
19921
19971

Latest cases

Query with SQL
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'
    AND c.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 351)
  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.

NTSB CHI98FA028Accident · 6 fatalField investigationFinal reportBeech BE 58 · New Berlin, ILA loss of engine power due to separation of the left engine's number 2 connecting rod as a result of fatigue failure. Also causal was the pilot's failure to maintain adequate airspeed which resulted in a stall/spin. Contributing to the accident was the…Oct 30, 1997 · N472TL · DestroyedNTSB DCA92MA048Accident · 12 fatalMajor investigationFinal reportBeech C-45H · Hinckley, ILInadequate maintenance and inspection by the operator which resulted in an engine power loss during the critical takeoff phase of flight. In addition, the pilot did not, or was unable to, attain a full-feather position on the left engine propeller, which…Sep 7, 1992 · N3657G · DestroyedNTSB CHI88FA214Accident · 3 fatalField investigationFinal reportHughes 269B · Hampton, ILAug 21, 1988 · N9499F · DestroyedNTSB CHI86FA233Accident · 1 fatalField investigationFinal reportBeech E18S · Chicago, ILThe acft had departed on rnwy 13. He was then directed to climb to 6000 ft. thirty seconds later he advised he had eng trouble and was returning to the arpt. Shortly thereafter he advised he could not maintain alt. The acft, one mile se of the arpt, struck…Sep 29, 1986 · N101VE · DestroyedNTSB CHI85FA370Accident · 1 fatalField investigationFinal reportGlobe GC-1B · Romeoville, ILThe pilot was reportly departing on a xcountry flt. During climbout, in the traffic pattern, upon reaching base leg area the acft was observed to turn back towards the arpt descend and strike the ground. Witnesses reported no sound of engine was heard. The…Sep 7, 1985 · N11HN · Destroyed