NTSB investigations
1,858 cases where the sequence of events included Loss of engine power (partial).
Cases, newest first
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.\"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."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 CEN16LA015Accident · No injuriesLimited investigationFinal reportBobby Martin Autogyro MTO Sport · Wallisville, TXFracture of the pusher propeller blade due to impact damage from an unknown object while in flight, which resulted in a severe vibration and a loss of thrust.NTSB CEN16LA032Accident · No injuriesLimited investigationFinal reportCessna 177RG · Red Oak, IAThe improper torque of the engine’s No. 3 cylinder intake pipe bolts, which resulted in the separation of the pipe and a partial loss of engine power.NTSB ENG16IA001Incident · No injuriesIncident investigationFinal reportBoeing 747 · Russian airspace, JapanThe PW4056 engine experienced an in-flight loss of power because of damage to the low-pressure turbine (LPT) because of the inadequate overhaul inspection and repair instructions that existed at the time of the LPT module's last overhaul. A vane hook in the…NTSB CEN15LA431Accident · Serious injuriesLimited investigationFinal reportEdward M Van Morlan Rans S-12 · Gardner, KSThe pilot's inadequate airspeed control and the airplane’s exceedance of its critical angle-of-attack during the forced landing, which resulted in an aerodynamic stall. Contributing to the accident was the loss of engine power due to fuel starvation caused by…NTSB ERA15LA373Accident · Minor injuriesLimited investigationFinal reportVanek Jim Sport Copter Vortex · Lake Wales, FLA loss of engine power due to a lean fuel/air mixture as a result of a disconnected fuel primer line.NTSB WPR15LA266Accident · Serious injuriesLimited investigationFinal reportPiper PA 28 · Elko, NVThe pilot's failure to sufficiently lean the engine’s fuel-to-air mixture for the given density altitude, which resulted in reduced engine power output and the airplane’s inability to climb.NTSB WPR15LA262Accident · No injuriesLimited investigationFinal reportGraves Bryon S Vans RV-7A · Byron, CAImproper overhaul of the right magneto, which eliminated system redundancy, and resulted in a loss of engine power when the left magneto failed during aerobatic flight maneuvers.NTSB CEN15LA418Accident · Minor injuriesLimited investigationFinal reportCessna 421B · Platteville, WIThe partial loss of right engine power for undetermined reasons with insufficient runway remaining for the aborted takeoff.NTSB ERA15LA368Accident · No injuriesLimited investigationFinal reportCessna 150M · Mount Airy, MDThe in-flight fatigue failure of the No. 4 cylinder barrel, which resulted in a total loss of engine power.NTSB WPR15LA261Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Forest Grove, ORA partial loss of engine power during cruise flight for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN15LA414Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Nutwood, ILA partial loss of engine power due to the undetected loosening of the four carburetor bolts that connect the throttle body to the bowl assembly.NTSB CEN15LA439Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Alice, TXA loss of engine power during a practice power recovery autorotation for reasons that could not be determined based on the available information.NTSB ERA15LA354Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Moneta, VAThe pilot's premature retraction of the wing flaps and his subsequent failure to maintain pitch control during an attempted go-around, which resulted in the airplane exceeding its critical angle-of-attack and an aerodynamic stall. Contributing to the accident…NTSB ANC15LA070Accident · No injuriesLimited investigationFinal reportHelio H 295 · Delta Junction, AKA partial loss of engine power during takeoff for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB ERA15FA353Accident · 1 fatalField investigationFinal reportAero Vodochody L39 · Oneida, TNThe pilot's failure to maintain airplane control following a partial loss of engine power during initial climb. The reason for the partial loss of engine power could not be determined due to extensive postimpact damage.NTSB CEN15LA407Accident · Serious injuriesLimited investigationFinal reportAlon A2 · Laramie, WYThe pilot’s failure to use carburetor heat in cruise flight while operating in an area conducive to serious carburetor icing, which resulted in a loss of engine power and an off-airport landing. Contributing to the accident was the pilot's decision to…NTSB CEN15LA413Accident · Minor injuriesLimited investigationFinal reportVenus CP328 Super Emeraude · Port Wing, WIThe pilot’s undershooting the landing area and the subsequent impact with a hay bale. Also causal to the accident was the operation of the airplane in conditions conducive to carburetor icing, which reduced the engine power during the landing.NTSB CEN15LA404Accident · 1 fatalLimited investigationFinal reportCessna TR182 · Midland, TXThe partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB WPR15FA256Accident · 2 fatalField investigationFinal reportPiper PA28 · Santee, CAThe pilots' failure to maintain airplane control following a partial loss of engine power after takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the partial loss of engine power due to a failure of the right magneto.NTSB WPR15LA254Accident · Minor injuriesLimited investigationFinal reportRaudenbush Ernie Lancair Super ES · Winkelman, AZA partial loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no anomalies.NTSB ERA15LA332Accident · Serious injuriesLimited investigationFinal reportLancair IV · Fort Lauderdale, FLThe mechanic's improper installation of the turbocharger assembly, which resulted in oil starvation and a subsequent total loss of the engine power.NTSB ERA15LA334Accident · Serious injuriesLimited investigationFinal reportBeech B19 · Dexter, METhe flight instructor’s inadequate preflight planning, which resulted in collision with trees and terrain during takeoff.NTSB WPR15LA251Accident · No injuriesLimited investigationFinal reportDova DV-1 · San Carlos, CAA partial loss of engine power due to fuel vapor lock. Contributing to the accident was the absence of a fuel return line.NTSB CEN15LA387Accident · Serious injuriesLimited investigationFinal reportRobinson R44 II · Cheyenne, WYThe pilot's improper preflight performance planning, which resulted in a hard landing due to low rotor rpm while operating near maximum gross weight in high density altitude conditions.NTSB CEN15LA389Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT 502B · Monroe, NELoss of propeller thrust for reasons that could not be determined, since examination of the airplane's engine, propeller, and associated accessories revealed no anomalies.NTSB CEN15LA382Accident · Serious injuriesLimited investigationFinal reportPiper PA 22-160 · Tyler, MNThe student pilot's failure to adequately ensure the carburetor was clear of ice before takeoff, which resulted in a partial loss of engine power during takeoff due to carburetor icing.NTSB CEN15LA383Accident · No injuriesLimited investigationFinal reportPiper PA 25-235 · Harvey, NDThe partial loss of engine power due to a failed magneto and two cylinders with low compression. Contributing to the accident was the pilot/owner’s decision to operate the airplane with an ongoing engine issue.NTSB WPR15LA248Accident · Minor injuriesLimited investigationFinal reportSikorsky S 61A · Ironside, ORA loss of power to the No. 2 engine due to the failure of the accessory gearbox drivetrain. Also causal was the pilot’s inability to release the external longline due to the use of a safety wire across the coupling of the quick-disconnect mechanism, which…NTSB ERA15LA318Accident · No injuriesLimited investigationFinal reportCessna 172K · Chiefland, FLThe partial loss of engine power during cruise flight for reasons that could not be determined because a postaccident airframe and engine examination and engine test run revealed no evidence of mechanical malfunctions or failures.NTSB ERA15LA311Accident · Serious injuriesLimited investigationFinal reportThomas A Siminski Zenith CH 750 · Allentown, PAA partial loss of engine power due to the No. 1 spark plug being liberated from the cylinder head due to the stripped threads in the cylinder head. Contributing to the accident was the pilot’s decision to attempt to return to the airport while at a low…NTSB ERA15FA308Accident · 2 fatalField investigationFinal reportBeech N35 · Weirsdale, FLA partial loss of engine power during takeoff. The reason for the partial loss of power could not be determined due to the extensive fire and impact damage to the engine.NTSB CEN15LA377Accident · No injuriesLimited investigationFinal reportGrumman G 164B · Sac City, IAThe loss of engine power for reasons that could not be determined based on the available information.NTSB ERA15LA306Accident · Serious injuriesLimited investigationFinal reportWright Daniel J Volksplane VP-1 · Brooksville, FLThe pilot's failure to abort the takeoff after determining that the engine was not producing adequate power. Contributing to the accident was the engine's inability to produce adequate power for reasons that could not be determined due to extensive postimpact…NTSB ERA15LA300Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Hot Springs, VAA partial loss of engine power during initial climb due to the failure of a magneto. Contributing to the accident was the pilot's decision to operate the airplane without a current annual inspection.NTSB WPR15LA235Accident · Minor injuriesLimited investigationFinal reportCleveland Allan B Nieuport 11# · Bellingham, WAA partial loss of engine power for reasons that could not be determined because postaccident examination revealed no mechanical malfunctions or anomalies that would have precluded normal operation.NTSB WPR15FA236Accident · 2 fatalField investigationFinal reportCessna 182F · Montecito, CAOil starvation that led to the failure of the No. 5 connecting rod and a subsequent loss of engine power.NTSB WPR15LA230Accident · No injuriesLimited investigationFinal reportGrumman G164 - B · Princeton, CAThe loss of engine power during an agricultural application flight due to a cylinder failure.NTSB ERA15LA293Accident · Serious injuriesLimited investigationFinal reportBeech C90B · Georgetown, KYUndetermined based on the available evidence.NTSB ERA15CA295Accident · No injuriesData collectionFinal reportStol JA30 Superstol · West Union, SCA loss of engine power while maneuvering due to water contamination in the fuel.NTSB ERA15LA291Accident · No injuriesLimited investigationFinal reportSontonastaso Mosquito · Winchendon, MAA partial loss of engine power due to a faulty electrical wiring crimp in the engine’s ignition system.NTSB CEN15LA326Accident · No injuriesLimited investigationFinal reportEagle Eagle DW 1 · Hector, MNThe intermittent partial loss of engine power, which resulted in a lower-than-expected approach glidepath and impact with terrain short of the runway. The reason for the intermittent partial loss of engine power could not be determined because postaccident…NTSB WPR15LA223Accident · No injuriesLimited investigationFinal reportStinson 108 - 3 · North Las Vegas, NVThe partial loss of engine power due to a degraded cylinder exhaust valve seal, which resulted in low cylinder compression.NTSB ERA15LA286Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Poughkeepsie, NYA leaking fuel discharge fitting, which resulted in a partial loss of engine power and an off-airport, gear-up landing.NTSB CEN15LA318Accident · 1 fatalLimited investigationFinal reportPiper PA38 - 112 · Millbury, OHA loss of engine power due to three of the engine valve adjustment mechanisms backing out, which resulted from improper maintenance.NTSB WPR15LA217Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-181 · Las Vegas, NVThe engine's inability to produce full-rated power due to wear on internal engine components, which resulted in a loss of altitude and subsequent landing on uneven terrain. Contributing to the accident was the airplane owner's failure to maintain the engine…NTSB ERA15LA276Accident · No injuriesLimited investigationFinal reportGrumman American Avn. AA1B · Lititz, PAA partial loss of engine power for reasons that could not be determined because postaccident examination of the engine found no mechanical malfunctions or failures that would have precluded normal operation.NTSB GAA15CA143Accident · No injuriesData collectionFinal reportAventura II · Fenton, MIThe failure of the student pilot to ensure that the experimental seaplane was airworthy prior to take off.NTSB CEN15LA298Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22 · Houston, TXMaintenance personnel's improper installation of the propeller governor, which resulted in damage to the governor drive gear and its subsequent failure and a subsequent loss of engine power.NTSB ANC15LA044Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Wasilla, AKThe partial loss of engine power after takeoff for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN15LA294Accident · No injuriesLimited investigationFinal reportBoeing A75N1 (PT17) · Louisburg, KSA partial loss of engine power for reasons that could not be determined during postaccident examinations.