NTSB investigations
3,823 cases where the sequence of events included Loss of engine power (total).
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\" = '341' 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" = '341' 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 WPR13CA245Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Page, AZA loss of engine power during cruise flight due to fuel exhaustion. Contributing to the accident was the pilot's improper fuel planning.NTSB ERA13FA256Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Macon, GAA total loss of engine power due to oil starvation for reasons that could not be determined due to extensive postcrash fire and heat damage to the engine components.NTSB WPR13LA248Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Wheatland, WYA loss of engine power due to fuel exhaustion and the pilot's inadequate fuel planning.NTSB CEN13LA378Accident · No injuriesLimited investigationFinal reportBell 206B · St Louis, MOThe loss of engine power due to the separation of compressor blades, which resulted from fatigue cracking.NTSB WPR13LA251Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · Truckee, CAThe pilot's failure to lean the fuel mixture during takeoff in high-density altitude conditions, which resulted in a loss of engine power.NTSB ERA13WA403Accident · No injuriesForeign investigationCessna A188B · Dajabon, Dominican RepublicOn May 22, 2013, about 0745 universal coordinated time, a Cessna A188B, Dominican Republic registration HI 912, operated by Agriasa, was substantially damaged during a forced landing following loss of engine power near La Cangrejeria, Dajabon, Dominican…NTSB CEN13LA291Accident · Minor injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Englewood, COThe in-flight separation of the engine throttle lever and throttle cable due to maintenance personnel not applying sufficient torque to the self-locking nut or improperly reusing a degraded self-locking nut.NTSB ANC13LA048Accident · Minor injuriesLimited investigationFinal reportPiper PA-16 · Juneau, AKThe total loss of engine power for reasons that could not be determined due to the inability to recover the airplane.NTSB CEN13LA286Accident · No injuriesLimited investigationFinal reportCessna 182C · Fremont, MIThe pilot's improper preflight planning, which resulted in a loss of engine power due to fuel exhaustion while in the traffic pattern.NTSB CEN13LA280Accident · Minor injuriesLimited investigationFinal reportPiper PA-36-285 · Galena, KSThe loss of engine power due to improper maintenance by an unknown individual that led to the degradation and deterioration of the No. 2 piston, which was undetected because of overdue maintenance.NTSB WPR13LA222Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Honolulu, HIThe mechanic’s failure to properly inspect the helicopter following maintenance performed by an apprentice, which resulted in a total loss of engine power due to the improper rigging of the mixture control assembly.NTSB ERA13LA239Accident · No injuriesLimited investigationFinal reportCessna 182G · Clewiston, FLThe private pilot’s inadequate preflight planning and fuel management and the flight instructor’s inadequate supervision, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN13LA283Accident · No injuriesLimited investigationFinal reportAir Tractor AT-302 · Winnie, TXThe improper decision by the pilot to attempt a flight with a known fuel system-related maintenance discrepancy, which resulted in a fuel imbalance and subsequent fuel starvation during an approach to an alternate airport with a rough field. Contributing to…NTSB CEN13FA267Incident · No injuriesField investigationFinal reportBeech 58 · Mena, ARA partial loss of power on both engines during takeoff for reasons that could not be determined because examination of the airframe and a test run of both engines revealed no mechanical anomalies that would have precluded normal operation.NTSB CEN13CA250Accident · No injuriesData collectionFinal reportBeech A36 · Ingalls, INThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB WPR13LA224Accident · No injuriesLimited investigationFinal reportCessna 172M · Lakeport, CALoss of engine power during climb due to a failure of the No. 2 piston assembly; the reason for the failure could not be determined because of the extent of damage to the piston assembly.NTSB ERA13FA217Accident · Minor injuriesField investigationFinal reportCessna 172N · Dade City, FLThe in-flight loosening of the No. 3 cylinder exhaust valve rocker arm stud, which resulted in a complete loss of engine power.NTSB ERA13LA220Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Daytona Beach, FLA total loss of engine power during initial climb for reasons that could not be determined because postaccident examinations did not reveal any preimpact failures or malfunctions that would have precluded normal operation.NTSB CEN13LA245Accident · No injuriesLimited investigationFinal reportRaytheon G36 · Hoxie, KSThe loss of engine power due to fuel starvation for reasons that could not be determined because a postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN13LA233Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Paris, TXThe improper installation of the connecting rod bolts, which resulted in an engine failure.NTSB CEN13LA229Accident · Minor injuriesLimited investigationFinal reportBeech N35 · Warren, ARThe fatigue failure of the engine crankshaft due to oversized crankcase saddle bores, which resulted from maintenance personnel improperly resizing the saddle bores during engine maintenance.NTSB WPR13LA190Accident · Serious injuriesLimited investigationFinal reportBeech 35-B33 · San Manuel, AZA loss of engine power due to fuel starvation during the landing approach. Contributing to the accident was the pilot’s failure to follow the emergency checklist and switch tanks. Contributing to the severity of the pilot's injuries was the lack of a shoulder…NTSB ERA13LA204Accident · No injuriesLimited investigationFinal reportHarris Pierce Velocity XL RG · Avon Park, FLA total loss of engine power during cruise flight for reasons that could not be determined because postaccident examination and testing did not reveal any mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN13LA220Accident · Minor injuriesLimited investigationFinal reportWalker Phil RV-6A · Spearfish, SDThe coil-distributor wire loosening in flight, which rendered the ignition system inoperative and subsequently caused the loss of engine power.NTSB CEN13LA216Accident · No injuriesLimited investigationFinal reportCessna 172 · Wonewoc, WIThe restricted vented fuel cap and obstructed fuel vent lines, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA13FA184Accident · 2 fatalField investigationFinal reportLancair LC42 - 550FG · Winston-Salem, NCThe pilot's failure to detect multiple indications and cues in the cockpit of the steady loss of engine oil pressure, which resulted in a catastrophic engine failure over terrain unsuitable for landing. Also causal was the loss of internal engine lubrication…NTSB WPR13FA169Accident · 1 fatalField investigationFinal reportMooney M20A · Wikieup, AZThe manufacture and installation of a nonstandard part by unknown maintenance personnel to compensate for a bent, misaligned crankshaft propeller flange, which resulted in the improper clearance of the bearings on the crankshaft journal, a loss of oil…NTSB WPR13WA197Accident · No injuriesForeign investigationCirrus SR22 · Zhuhai Sanzao Airport, ChinaOn March 27, 2013 about 1445 Beijing time, a Cirrus SR-22, Chinese registration B-9592, experienced a loss of engine power and subsequently ditched near Zhuhai Sanzao Airport, Guangdong Province, China. The airplane was operated as an instructional flight by…NTSB WPR13LA167Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · Twin Falls, IDA total loss of engine power 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 WPR13LA161Accident · No injuriesLimited investigationFinal reportOwens Velocity 173 · Maricopa, AZA loss of engine power for reasons that could not be determined because postaccident examination of the throttle body revealed no anomalies that would have precluded normal operation.NTSB CEN13LA204Accident · No injuriesLimited investigationFinal reportBeech A36 · Cordova, ILA partial loss of engine power for reasons that could not be determined because a postaccident test run of the engine revealed no mechanical failures or malfunctions that would have precluded normal operation.NTSB CEN13CA224Accident · No injuriesData collectionFinal reportAeronca 65C · Grand Rapids, MNThe student pilot’s failure to adequately lock the primer before takeoff and the flight instructor's failure to verify that the primer was adequately locked.NTSB WPR13CA163Accident · Minor injuriesData collectionFinal reportCessna 172G · Temecula, CAThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA13LA179Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Perry, FLThe total loss of engine power for reasons that could not be determined based on the available evidence.NTSB ERA13LA174Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Panama City, FLA loss of preload to the crankshaft gear attachment bolt, resulting in rotation of the crankshaft gear and a subsequent total loss of engine power. The root cause for the loss of preload could not be determined during a postaccident examination of the…NTSB ERA13LA173Accident · Serious injuriesLimited investigationFinal reportNew Piper PA32-301FT · Stafford, VAThe pilot's improper placement of the fuel tank selector handle during approach, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN13FA196Accident · 2 fatalField investigationFinal reportHawker Beechcraft 390 · South Bend, INThe private pilot's inadequate response to the dual engine shutdown during cruise descent, including his failure to adhere to procedures, which ultimately resulted in his failure to maintain airplane control during a single-engine go-around. An additional…NTSB CEN13CA197Accident · Minor injuriesData collectionFinal reportCessna 150G · Baytown, TXThe pilot’s poor in-flight decision-making and improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB WPR13LA171Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Byron, CAA loss of engine power during initial climb for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB ERA13LA167Accident · Serious injuriesLimited investigationFinal reportAllen BD-5 · Mount Airy, NCA total loss of engine power due to the pilot's inadvertent closing of the engine choke. Contributing to the accident was the improper rigging of the engine choke cable.NTSB CEN13LA194Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Eagle Nest, NMA total loss of engine power due to a rapid throttle change during autorotation, which the flight instructor initiated in response to a low rotor rpm warning, which resulted from the separation of one of the magnets used to provide rotor rpm indications from…NTSB ANC13LA033Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Tyonek, AKA total loss of engine power of both engines for reasons that could not be determined because the engines were not made available for examination.NTSB WPR13LA147Accident · Minor injuriesLimited investigationFinal reportFranklin Glasair II · Spanish Fork, UTA loss of engine power due to fuel starvation, which likely resulted from air being introduced into the fuel system through the worn shaft of an electric fuel boost pump.NTSB ERA13LA159Accident · Minor injuriesLimited investigationFinal report781569 FX 210 · Punta Gorda, FLA total loss of engine power for reasons that could not be determined from the available evidence.NTSB ANC13LA029Accident · No injuriesLimited investigationFinal reportCessna 207 · Bethel, AKThe failure of the engine’s No. 1 piston connecting rod retaining bolts due to fatigue fracturing, which resulted in a loss of engine power during cruise flight.NTSB WPR13LA134Accident · No injuriesLimited investigationFinal reportBlumer Challenger II Spec · Peoria, AZA cracked cooling fan housing, which led to a malfunction of the ignition system and a loss of engine power during the landing approach.NTSB CEN13FA174Accident · 2 fatalField investigationFinal reportEurocopter AS 350 B2 · Oklahoma City, OKThe loss of engine power due to engine ice ingestion during initial climb after takeoff in dark night light conditions. Contributing to the accident were the lack of an installed engine air inlet cover while the helicopter was parked outside, exposed to…NTSB CEN13CA175Accident · Minor injuriesData collectionFinal reportCessna 177 · Elcho, WIThe pilot's inadequate preflight and in-flight fuel management, which led to a total loss of engine power due to fuel exhaustion.NTSB CEN13LA164Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Morris, ILThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA13LA138Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Fort Gaines, GAThe total loss of engine power due to fuel starvation as a result of debris in the fuel control unit.