NTSB investigations
3,825 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 CEN21LA138Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182F · Millville, IAThe inadequate maintenance/inspection of the airplane, which resulted in a total loss of engine power due to oil starvation.NTSB GAA21WA030Accident · No injuriesClass 5 · ForeignCessna 172 · Bloemfontein, South AfricaNTSB GAA21WA032Accident · Minor injuriesClass 5 · ForeignPiper PA28 · Formiga, BrazilNTSB GAA21WA025Accident · Minor injuriesClass 5 · ForeignPiper PA-28-140 · North Cat Cay, BahamasNTSB ERA21FA133Accident · 2 fatalClass 3 · FieldFinal reportPiper PA32RT · Vinemont, ALA loss of engine power for reasons that could not be determined.NTSB WPR21FA114Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32-260 · Los Angeles, CAThe total loss of engine power due to the failure of the No. 6 exhaust valve for reasons that could not be determined based on available evidence.NTSB ERA21FA130Accident · 4 fatalClass 3 · FieldFinal reportBell 206 · St Thomas, CBA total loss of engine power due to fatigue failure of two of the stage 3 compressor blades. Contributing to the failure of the compressor blades was the failure of maintenance personnel to inspect the compressor at the recommended interval for operation in…NTSB GAA21WA022Accident · Minor injuriesClass 5 · ForeignBeech A36 · Novo Progresso, BrazilNTSB GAA21WA024Accident · No injuriesClass 5 · ForeignPiper PA36 · ConceiçãO De Alagoas, BrazilNTSB GAA21WA034Incident · No injuriesClass 5 · ForeignCessna 182 · La Morita, MexicoNTSB WPR21LA104Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Riverside, CAFuel starvation due to the pilot’s inadequate weather and fuel planning, which resulted in a total loss of engine power.NTSB GAA21WA014Accident · No injuriesClass 5 · ForeignCessna 188 · Viamao, BrazilNTSB DCA21WA077Incident · No injuriesClass 5 · ForeignBoeing 747 · Karachi, PakistanNTSB CEN21LA117Accident · Serious injuriesClass 3 · LimitedFinal reportZenair Zodiac 601HDS · Waller, TXThe total loss of engine power due to a disconnected fuel line, which resulted in fuel starvation.NTSB ERA21LA123Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-301 · Homestead, FLA total loss of power for reasons that could not be determined, as the airplane was not recovered from the water following the ditching.NTSB ERA21LA104Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · St. Petersburg, FLA total loss of engine power as a result of the loose fuel line B-nut connected to the engine driven fuel pump.NTSB WPR21LA086Accident · No injuriesClass 3 · LimitedFinal reportHughes 269C · Spanish Fork, UTThe loss of engine power during a practice autorotation for an undetermined reason.NTSB ERA21LA107Accident · No injuriesClass 3 · LimitedFinal reportExtra Flugzeugbau EA 300/L · Pell City, ALThe pilot's mismanagement of the fuel supply, which resulted in fuel starvation. Contributing to the accident was the pilot’s failure to follow the manufacturer’s engine restart procedures after a total loss of engine power and his incomplete preflight…NTSB WPR21WA090Accident · Serious injuriesClass 5 · ForeignCessna 210 · Chibuya, ZimbabweNTSB CEN21LA109Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Albany, TXThe pilot’s inadequate pretakeoff checks which resulted in the magneto switch (key) remaining in the OFF position during the takeoff sequence and initial climb and the right magneto grounding intermittently.NTSB CEN21LA103Accident · No injuriesClass 3 · LimitedFinal reportCessna 172H · Cypress, TXA total loss of engine power due to fuel exhaustion.NTSB WPR21LA075Accident · Minor injuriesClass 3 · LimitedFinal reportBeech 35 · Santa Ynez, CAThe pilot’s mismanagement of fuel, which resulted in fuel starvation and a total loss of engine power.NTSB ERA21LA091Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Pleasant Valley, NYA total loss of engine power due to failure of the magnetos, which were not overhauled in accordance with the manufacturer’s time specifications.NTSB CEN21LA100Accident · Serious injuriesClass 3 · LimitedFinal reportWalton Daniel J Sonex · Pecatonica, ILA total loss of engine power for reasons that could not be determined based on the available information, and the pilot’s exceedance of the airplane’s critical angle of attack following the loss of engine power, which resulted in an aerodynamic stall/spin and…NTSB WPR21LA072Accident · No injuriesClass 3 · LimitedFinal reportNavion Navion A · Livermore, CAThe improper installation of the gascolator fuel inlet line and hose clamp connection, which resulted in the total loss of engine power.NTSB ERA21LA087Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA46 · Naples, FLThe inadvertent activation of the unguarded ferry tank fuel selector valve, which resulted in fuel starvation and a total loss of engine power.NTSB CEN21LA092Accident · 1 fatalClass 3 · LimitedFinal reportSonex Tailwheel · Burleson, TXA total loss of engine power due to engine seizure. Contributing to the accident was the pilot decision not to orbit the airport, as originally planned.NTSB ERA21LA081Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · Tampa, FLA total loss of engine power due to the student pilot inadvertently moving the fuel selector to the OFF position.NTSB CEN21LA088Accident · 2 fatalClass 3 · LimitedFinal reportRans S12XL · Port Isabel, TXAn exceedance of the airplane’s critical angle of attack and aerodynamic stall following a loss of engine power during an unknown phase of flight, which resulted in an impact with terrain.NTSB CEN21WA094AccidentClass 5 · ForeignAficionado MINI-MAX Eros · Urbanización Bassetes, SpainNTSB CEN21LA082Accident · No injuriesClass 3 · LimitedFinal reportPiper PA12 · Spearfish, SDA total loss of engine power during initial climb for undetermined reasons.NTSB CEN21LA073Accident · No injuriesClass 3 · LimitedFinal reportBellanca 17-30A · Arden Hills, MNIncorrect connecting rod installation, which resulted in the failure of the nos. 5 and 6 connecting rods and subsequent total loss of engine power.NTSB WPR21LA059Accident · No injuriesClass 3 · LimitedFinal reportCessna TU206 · Twentynine Palms, CAThe pilot’s decision to takeoff with a known mechanical engine anomaly, and the failure of the No. 2-cylinder exhaust valve, which resulted in a total loss of engine power during the initial climb and subsequent impact with terrain.NTSB WPR21FA048Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Los Angeles, CAMaintenance personnel’s failure to properly secure the throttle control hardware during recent maintenance, which resulted in its disconnection and a subsequent loss of engine power on approach for landing.NTSB WPR21FA045Accident · 2 fatalClass 3 · FieldFinal reportCessna 177 · Langley, WAThe flight instructor’s failure to maintain airspeed, which resulted in an aerodynamic stall and subsequent loss of control while attempting to conduct an emergency landing. Contributing to the accident was a total loss of engine power as a result of…NTSB WPR21WA066Accident · Serious injuriesClass 5 · ForeignBell 407 · Kala, TanzaniaNTSB CEN21LA049Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32 · Circleville, OHThe total loss of engine power due to an accessory drive gear that backed out impeding the other gears.NTSB CEN21LA048Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Greenville, MIThe loss of engine power due to fuel starvation during a low approach over the airport, which resulted in a forced landing and impact with terrain.NTSB WPR21LA049Accident · No injuriesClass 3 · LimitedFinal reportRonald A Gawer RV-12 · Byron, CAThe total loss of engine power due to a fatigue fracture of the crankshaft.NTSB CEN21LA045Accident · No injuriesClass 3 · LimitedFinal reportJust SuperSTOL · Edgard, LAThe loss of engine power for reasons that could not be determined with the available information.NTSB CEN21LA034Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Lebanon, OHImproper maintenance that resulted in a blocked crankcase breather port and a subsequent total loss of engine power.NTSB ERA21FA029Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Dunnellon, FLA total loss of engine power due to fuel exhaustion. Contributing was the pilot’s exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall/spin and loss of control.NTSB CEN21LA057Accident · Minor injuriesClass 3 · LimitedFinal reportCirrus SR22 · Tishomingo, OKThe pilot’s improper adjustment of the engine mixture control, which resulted in a total loss of engine power. Contributing to the accident was a disconnected oil temperature connector, which was likely damaged during maintenance before the accident flight…NTSB WPR21LA022Accident · No injuriesClass 4 · LimitedFinal reportPiper J3-C65 · El Cajon, CAThe pilot's inadequate preflight inspection and fuel planning which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN21LA031Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Buda, TXAn improperly torqued oil line fitting during an engine overhaul, which resulted in oil exhaustion and a total loss of engine power.NTSB CEN21FA024Accident · 1 fatalClass 3 · FieldFinal reportGlasair III · Ford Heights, ILThe loss of engine power for reasons that could not be determined based on the available evidence.NTSB ERA21LA023Accident · No injuriesClass 3 · LimitedFinal reportBell 206 · Zephyrhills, FLImproper torquing of the “B” nut at the fuel control unit, which led to a total loss of engine power and subsequent autorotation that resulted in substantial damage.NTSB GAA21WA001Accident · 3 fatalClass 3 · ForeignPiper PA28RT · Ubate-Cundinamarca, ColombiaNTSB CEN21WA059Accident · No injuriesClass 4 · ForeignPiper PA46 · Villingen-Schwenningen, GermanyNTSB CEN21WA011Accident · No injuriesClass 5 · ForeignCirrus SR22 · Langdorp, Belgium