Fatal NTSB investigations, LA

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

Cases per year

19832026
Fatal NTSB investigations, LA per year, 1983–2026: 5 cases
19831
19851
19861
19901
19991

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\" = 'LA' 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\" = 352)
  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 FTW99FA262Accident · 4 fatalField investigationFinal reportBeech A36TC · Franklinton, LAThe pilot's inadvertent stall while attempting to clear trees during a go-around. Factors were the pilot's misjudgment of the airplane's distance and speed during the precautionary landing and the partial loss of engine power due to a perforated piston.Sep 19, 1999 · N206WJ · DestroyedNTSB FTW91FA025Accident · 1 fatalField investigationFinal reportPiper PA28-181 · Olla, LAThe collapsed carburetor float and restricted movement of the fuel metering needle. Factors were the darknight, the unsuitable terrain, and the operator's maintenance personnel failure to inspect (repair) the engine.Dec 16, 1990 · N8460Q · DestroyedNTSB FTW86FA079Accident · 6 fatalField investigationFinal reportCessna 411A · Bossier City, LAThe pilot reportedly did an unusual amount of engine run-up before pulling onto the runway. He then performed another run-up before departing. This is evidence that he was aware of a problem with his aircraft. The engine(s) were popping and puffing black…May 8, 1986 · N49DD · DestroyedNTSB FTW85FA310Accident · 1 fatalField investigationFinal reportBell UH-1B · Saint James, LAAcft was at a 150' hover preparing to pick up a log when it experienced a power loss. Witnesses stated that they heard a loud 'bang' and the pilot radioed 'get out of the way'. Acft autorotated thru 60' to 80' trees with very low rotor RPM and impacted with…Aug 8, 1985 · N1385W · DestroyedNTSB FTW83FA252Accident · 1 fatalField investigationFinal reportPiper PA-60 · New Orleans, LAWitnesses reported that when the acft was stabilized on final apch, it pitched up slightly & yawed, then rolled left to an inverted attitude & crashed in a canal. Several witnesses stated that the left prop was windmilling. One stated the left prop had…May 30, 1983 · N52AC · Destroyed