NTSB investigations, 2019, TX

13 cases where the sequence of events included Loss of engine power (partial).

Cases per year

20082026
NTSB investigations, 2019, TX per year, 2008–2026: 168 cases
20087
200912
20109
20117
201215
201311
201411
201510
20168
201710
20189
201913
20208
20219
20225
20234
20246
20258
20266

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 year(c.\"eventDate\") = 2019
    AND c.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '342' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 CEN20LA051Accident · No injuriesClass 3 · LimitedFinal reportEnstrom F28 · Danbury, TXThe failure of the engine's No.3 intake valve resulting is a loss of engine power and a rollover following the autorotation to soft ground.Dec 31, 2019 · N57SJ · Substantial damageNTSB ERA20LA054Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson R44 · San Antonio, TXMaintenance personnel’s failure to complete all necessary steps of a service bulletin and subsequent failure to identify the loose lower actuator bearing support bracket during inspections, which resulted in the misalignment of the clutch actuator, resulted…Dec 14, 2019 · N440AH · Substantial damageNTSB CEN20FA023Accident · 3 fatalClass 3 · FieldFinal reportPiper PA24 · San Antonio, TXThe loss of engine power for reason that could not be determined. Contributing to the accident was the pilot’s failure to maintain aircraft control while maneuvering to landing which resulted in an inadvertent stall/spin with insufficient altitude to recover.Dec 2, 2019 · N6678P · Substantial damageNTSB CEN20LA005Accident · No injuriesLimited investigationFinal reportZenair Zenith CH 701 · Garden Ridge, TXThe partial loss of engine power for reasons that could not be determined based on the available evidence.Oct 5, 2019 · N701BJ · Substantial damageNTSB CEN19LA326Accident · No injuriesClass 3 · LimitedFinal reportVans Vans RV-10 · Lancaster, TXA partial loss of engine power due to a faulty magneto/ignition system, which resulting in a forced landing.Sep 21, 2019 · N569JC · Substantial damageNTSB CEN19FA325Accident · 2 fatalClass 3 · FieldFinal reportCessna A185 · Conroe, TXA partial loss of engine power due to fuel contamination with water, and the pilot’s failure to maintain control of the airplane during an attempted return to the airport shortly after takeoff, which resulted in an aerodynamic stall.Sep 21, 2019 · C-GOZJ · DestroyedNTSB CEN19LA299Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Conroe, TXA partial loss of engine power for reasons that could not be determined based on the available evidence.Aug 31, 2019 · N55633 · Substantial damageNTSB CEN19LA275Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Rio Grande City, TXThe loss of engine power following an increase in oil temperature for undetermined reasons during cruise flight, which resulted in a forced landing on unsuitable terrain.Aug 15, 2019 · N150CR · Substantial damageNTSB CEN19LA167Accident · Serious injuriesClass 3 · LimitedFinal reportErcoupe 415 · Hawkins, TXA partial loss of engine power for undetermined reasons.Jun 13, 2019 · N87294 · Substantial damageNTSB CEN19LA158Accident · Serious injuriesClass 3 · LimitedFinal reportBoeing B75N1 · Fredericksburg, TXThe loss of engine power for undetermined reasons.May 29, 2019 · N60955 · Substantial damageNTSB CEN19LA129Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 23 · Sulphur Spring, TXThe pilot’s inadequate preflight inspection, during which he failed to detect the water contamination in the left fuel, which resulted in a partial loss of power in the left engine. Contributing to the accident was the total loss of power in the right engine…Apr 27, 2019 · N233P · Substantial damageNTSB CEN19FA099Accident · 1 fatalClass 2 · FieldFinal reportCessna 172 · Lakeway, TXA partial loss of engine power for reasons that could not be determined, and the flight instructor's exceedance of the airplane's critical angle of attack while maneuvering for a forced landing, which resulted in an aerodynamic stall and subsequent loss of…Mar 14, 2019 · N8620B · Substantial damageNTSB CEN19LA076Accident · Minor injuriesLimited investigationFinal reportPiper PA32RT · Pflugerville, TXThe pilot's fuel mismanagement and his improper use and placement of the fuel selector, contrary to operating procedures, which resulted in a partial loss of engine power due to fuel starvation.Jan 27, 2019 · N39650 · Substantial damage