Final NTSB investigations, TX
156 cases where the sequence of events included Loss of engine power (partial).
Cases per year
| 2008 | 7 |
|---|---|
| 2009 | 12 |
| 2010 | 9 |
| 2011 | 7 |
| 2012 | 15 |
| 2013 | 11 |
| 2014 | 11 |
| 2015 | 10 |
| 2016 | 8 |
| 2017 | 10 |
| 2018 | 9 |
| 2019 | 13 |
| 2020 | 8 |
| 2021 | 9 |
| 2022 | 5 |
| 2023 | 4 |
| 2024 | 6 |
| 2025 | 2 |
Where
Open the mapLatest 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\" = 'TX' AND c.\"eventCountry\" = 'USA'
AND c.\"completionStatus\" = 'Completed'
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.
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" = 'TX' AND c."eventCountry" = 'USA' AND c."completionStatus" = 'Completed' 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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB DCA25LA185Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · Houston, TXSerious Injury to a flight attendant sustained during an evacuation.NTSB CEN25LA107Accident · No injuriesClass 3 · LimitedFinal reportSchweizer 269C-1 · Alvord, TXA total loss of engine power for a reason that could not be determined.NTSB CEN25LA054Accident · No injuriesClass 3 · LimitedFinal reportAmerican AA-1B · Brenham, TXA partial loss of engine power due to an obstructed induction system from a mud dauber nest.NTSB CEN25LA025Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1 · Denton, TXThe partial loss of engine power during the initial climb and the pilot’s failure to maintain directional control during the forced landing with a tailwind.NTSB CEN24LA301Accident · Minor injuriesClass 3 · LimitedFinal reportTailwind W10 · West Livingston, TXA partial loss of engine power due to carburetor ice.NTSB CEN24LA236Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22T · Boerne, TXMaintenance personnel’s inadequate adjustment of fuel flow, which resulted in an excessively rich mixture, a rough-running engine, and a subsequent partial loss of engine power.NTSB CEN24LA200Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Taylor, TXA partial loss of engine power due to an incorrect carburetor air inlet hose, which led to a reduction in air flow to the engine.NTSB CEN24LA137Accident · No injuriesClass 3 · LimitedFinal reportEnstrom Helicopter 280C · Port Lavaca, TXThe pilot’s improper manual engine mixture management which resulted in a loss of power. Contributing to the accident was the mechanic’s improper setting of the idle mixture adjustment and the pilot’s decision to take off with a known mechanical deficiency.NTSB CEN24LA065Accident · Serious injuriesClass 3 · LimitedFinal reportBeech B36TC · Burnet, TXThe loss of engine power due an overly rich mixture from an improper adjustment of the fuel pump, which resulted in a forced landing and impact with a car and terrain.NTSB CEN23LA367Accident · No injuriesClass 3 · LimitedFinal reportCessna 172B · San Angelo, TXA partial loss of engine power due to loose bolts holding the carburetor throttle body to the fuel bowl.NTSB WPR23LA117Accident · No injuriesClass 3 · LimitedFinal reportStinson 108 · Lampasas, TXImproper case hardening of the crankshaft timing gear, which resulted in the fatigue failure of the gear and a total loss of engine power.NTSB CEN23LA107Accident · No injuriesClass 3 · LimitedFinal reportMooney M20 · Lakeway, TXA total loss of engine power due to detonation and preignition in the No. 6 cylinder.NTSB CEN22LA429Accident · No injuriesClass 3 · LimitedFinal reportCommander 114TC · Savoy, TXA loss of engine power for reasons that could not be determined.NTSB CEN22LA413Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32RT · Bulverde, TXThe partial loss of engine power due to excessive carbon deposits that resulted in one or more stuck exhaust valves.NTSB CEN22LA283Accident · No injuriesClass 3 · LimitedFinal reportOsprey II · Bulverde, TXA loss of engine power due to fuel starvation due to a blockage of the fuel tank outlet port.NTSB CEN22LA230Accident · No injuriesClass 3 · LimitedFinal reportCessna 172P · Ennis, TXA partial loss of engine power for reasons that were undetermined.NTSB CEN22LA106Accident · Minor injuriesClass 3 · LimitedFinal reportDehavilland Tiger Moth DH 82A · Lampasas, TXThe failure of a bolt in the engine valve system which resulted in malfunction of the engine exhaust valve system and a partial loss of engine power. The rough terrain encountered during the forced landing contributed to the outcome.NTSB CEN22LA036Accident · No injuriesClass 3 · LimitedFinal reportCessna 177 · Hudson Oaks, TXThe partial loss of engine power due to fuel exhaustion. Contributing was the pilot’s improper fuel planning.NTSB CEN22LA002Accident · Minor injuriesClass 3 · LimitedFinal reportBeech B23 · Lamesa, TXThe loss of engine power for a reason that could not be determined.NTSB CEN21LA391Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 320 · Windthorst, TXA forced landing due to a loss of engine power on the right engine for a reason that could not be determined based on the available evidence.NTSB CEN21LA375Accident · No injuriesClass 3 · LimitedFinal reportHaley Highlander · Waller, TXA loss of engine power due to fuel exhaustion.NTSB CEN21LA473Accident · Minor injuriesClass 3 · LimitedFinal reportBeech 35-A33 · Mineral Wells, TXA partial loss of engine power for reasons that could not be determined based on available evidence.NTSB CEN21LA293Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Porter, TXThe pilot’s decision to continue the takeoff with degraded engine performance, which resulted in an inability to climb and a subsequent forced landing. The reason for the engine’s degraded performance could not be determined based on available information.NTSB CEN21LA273Accident · No injuriesClass 3 · LimitedFinal reportTony Dubeansky RV10 · Fort Worth, TXA partial loss of engine power due to a separated electronic ignition system connector. Contributing to the accident was the location of the ignition boxes, which provided limited access to the connectors for visual inspection.NTSB CEN21LA176Accident · No injuriesClass 3 · LimitedFinal reportBeech B35 · Pearland, TXThe partial loss of engine power due to a crack in the No. 1 cylinder for unknown reasons.NTSB CEN21LA133Accident · No injuriesClass 3 · LimitedFinal reportAero Commander S2R · Alamo, TXThe partial loss of engine power due to water-contaminated fuel.NTSB CEN21LA078Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV4 · Sadler, TXThe partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN21LA035Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Crystal Beach, TXThe partial loss of engine power for reasons that could not be determined.NTSB CEN20LA291Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Arlington, TXThe pilot's failure to maintain directional control during a forced landing with a quartering tailwind, following a partial loss of engine power due to carburetor icing.NTSB CEN20LA262Accident · Minor injuriesClass 3 · LimitedFinal reportBeech F35 · Ravenna, TXElectrical and engine problems for reasons that could not be determined based on available evidence.NTSB CEN20LA260Accident · No injuriesClass 3 · LimitedFinal reportChampion 7EC · Port O'Conner, TXThe loss of engine power due to a stuck intake valve.NTSB CEN20LA256Accident · 1 fatalClass 3 · LimitedFinal reportCessna 320 · Round Rock, TXImproper maintenance that led to a loss of engine power due to a failed left engine magneto, the pilot’s improper application of single engine emergency procedures, and his failure to maintain control of the airplane which resulted in a collision with trees.NTSB CEN20LA170Accident · No injuriesClass 3 · LimitedFinal reportErcoupe 415 · Hallettsville, TXThe partial loss of engine power due to contaminated fuel and carburetor ice.NTSB CEN20LA159Accident · Serious injuriesClass 3 · LimitedFinal reportPilatus PC12 · Mesquite, TXThe loss of engine power due to a mis-rigged beta control cable (propeller reversing cable), which resulted in a loss of thrust inflight.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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB CEN19LA167Accident · Serious injuriesClass 3 · LimitedFinal reportErcoupe 415 · Hawkins, TXA partial loss of engine power for undetermined reasons.NTSB CEN19LA158Accident · Serious injuriesClass 3 · LimitedFinal reportBoeing B75N1 · Fredericksburg, TXThe loss of engine power for undetermined reasons.NTSB 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…NTSB 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…NTSB 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.NTSB CEN19LA002Accident · Minor injuriesLimited investigationFinal reportCirrus SR22 · Midland, TXThe loss of engine power due to excessive fuel flow.NTSB CEN18LA382Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Sugar Land, TXFatigue failure of the No. 1 cylinder intake valve, which resulted in the loss of engine power.NTSB CEN18LA385Accident · Minor injuriesLimited investigationFinal reportZenair Zenith CH 750 · Temple, TXThe accumulation of carburetor ice before takeoff, which resulted in a partial loss of engine power on initial climb and a forced landing on unsuitable terrain.