Fatal NTSB investigations, AL

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

Cases per year

19822026
Fatal NTSB investigations, AL per year, 1982–2026: 5 cases
19821
19841
19931
19961
20011

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\" = 'AL' 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 MIA02LA022Accident · 1 fatalLimited investigationFinal reportRobert N. Gilmore Rans S-10 · Oneonta, ALThe failure of the pilot to maintain airspeed following loss of engine power resulting in the airplane stalling and entering a spin from which it crashed. Factors in the accident was improper repair of the front cylinder intake manifold seal by the pilot…Nov 18, 2001 · N96AU · DestroyedNTSB MIA97FA031Accident · 1 fatalField investigationFinal reportPiper PA32-300D · Reform, ALa complete loss of engine power due to a total failure of both magnetos, and the failure of the pilot-in-command to insure that the airplane was airworthy. The dark night and unsuitable terrain were factors.Dec 6, 1996 · N8603N · DestroyedNTSB ATL93FA120Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Clayton, ALInadequate maintenance and inspection of the carburetor by maintenance personnel.Jul 1, 1993 · N5473S · Substantial damageNTSB ATL84FA100Accident · 1 fatalField investigationFinal reportBell 47GL · Cullman, ALThe plt had just completed an eng overhaul & was test flying the helicopter. While maneuvering at aprx 100 ft AGL, the eng lost power & the plt initiated an autorotation. During the landing, the helicopter impacted hard on rising terrain, rolled onto its side…Feb 17, 1984 · N12KH · DestroyedNTSB ATL83FKJ01Accident · 1 fatalFinal reportCessna 172N · Clanton, ALThe acft was observed in a high speed glide to touch down briefly in a pasture at the top of a knoll. It then dropped below the rise & crashed in a wooded area adjacent to the pasture. Examination of the eng showed a crack extending from the top forward…Dec 22, 1982 · N609CW · Destroyed