NTSB investigations, LA

5 cases where NTSB found Maintenance, general.

Cases per year

20142026
NTSB investigations, LA per year, 2014–2026: 5 cases
20141
20161
20172
20181

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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '02062000'))
  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 CEN18LA285Accident · No injuriesLimited investigationFinal reportSmith AEROSTAR601 · Baton Rouge, LAThe loss of right engine power due to fuel starvation, which resulted from corrosion debris in the fuel lines. Contributing to the accident was the mechanic’s and pilot’s inadequate maintenance of the airplane before the flight.Jul 20, 2018 · N327BK · Substantial damageNTSB CEN17LA328Accident · No injuriesLimited investigationFinal reportBeech A36 · Gonzales, LAA partial loss of engine power due to inadequate maintenance, including worn spark plugs and a leaking fuel hose fitting.Aug 17, 2017 · N48TZ · Substantial damageNTSB CEN17LA228Accident · Serious injuriesLimited investigationFinal reportThompson Angel Hawk II · Homer, LAA total loss of engine power due to the engine’s unresolved high operating temperatures, which resulted in failure of the distributor rotor and drive shaft, and the pilot’s failure to maintain airspeed during the subsequent forced landing, which resulted in…Jun 9, 2017 · N335JT · Substantial damageNTSB CEN16LA154Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT 502 · Kilbourne, LAThe failure of the operator to comply with the terminating action of the airworthiness directive, which resulted in the subsequent failure and separation of the vertical stabilizer due to fatigue.Apr 18, 2016 · N301LA · DestroyedNTSB CEN14LA449Accident · No injuriesLimited investigationFinal reportPiper PA 28-161 · New Orleans, LAThe in-flight fatigue failure of the crankshaft gear retaining bolt, which resulted in a total loss of engine power. Contributing to the accident were the pilot/owner’s failure to maintain the airplane in accordance with an airworthiness directive following a…Aug 22, 2014 · N8440N · Substantial damage