NTSB investigations
2,826 cases where the defining event was 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '341') 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '341') 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 CEN21LA251Accident · Minor injuriesClass 4 · LimitedFinal reportKevin Lippert Zenith CH 750 · Montrose, COThe loss of engine power due to fuel vapor lock.NTSB GAA21WA136Accident · Minor injuriesClass 5 · ForeignAir Tractor AT301 · Cienaga - Magdalena, ColombiaNTSB CEN21LA249Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Justin, TXThe loss of engine power for undetermined reasons based upon the available information.NTSB WPR21LA224Accident · No injuriesClass 3 · LimitedFinal reportCessna 172G · Washington, CAA total loss of engine power during an enroute climb due to a stuck exhaust valve and multiple failed piston compression rings.NTSB WPR21LA213Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-22-150 · Cashmere, WAA total loss of engine power shortly after takeoff for reasons that could not be determined based on the available information.NTSB CEN21LA243Accident · Serious injuriesClass 3 · LimitedFinal reportPhillips Ralph W Vans RV8 · San Angelo, TXThe loss of engine power due to fuel starvation. Contributing to the accident was the installation of a reduced flow fitting in the fuel line to the carburetor by maintenance personnel.NTSB ERA21FA229Accident · 1 fatalClass 3 · FieldFinal reportMunson Roger J RV-8 · Van Cleve, KYA loss of engine power due to loss of engine oil pressure.NTSB GAA21WA126Accident · No injuriesClass 5 · ForeignPiper PA38 · Ganderkesee, GermanyNTSB ERA21LA222Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20K · Dawson, GAMaintenance personnel’s failure to properly secure the No. 4 connecting rod bolt nut with a cotter pin, resulting in a total loss of engine power.NTSB GAA21WA183Accident · Minor injuriesClass 5 · ForeignCessna 210 · Island of Utila, HondurasNTSB GAA21WA123Accident · No injuriesClass 5 · ForeignPiper PA25 · Leme, BrazilNTSB GAA21WA118Accident · No injuriesClass 4 · ForeignWeatherly 620B · Guaviyu, UruguayNTSB WPR21LA194Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 210 · Lake Arrowhead, CAA total loss of engine power due to a malfunction of the fuel flow manifold valve.NTSB GAA21WA125Accident · Serious injuriesClass 5 · ForeignCessna 182 · Pocone, BrazilNTSB GAA21WA121Accident · Serious injuriesClass 5 · ForeignPiper PA38 · Bad Sobernheim, GermanyNTSB CEN21LA221Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Pinckneyville, ILThe total loss of engine power due to oil starvation. The reason for the oil starvation could not be determined based on available evidence.NTSB GAA21WA140Accident · No injuriesClass 5 · ForeignCessna 310 · Ribeirão Preto, BrazilNTSB ANC21LA040Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-105 Special · Gakona, AKThe pilot’s decision to initiate a flight with a failed mixture control cable which resulted in a total loss of engine power.NTSB GAA21WA110AccidentClass 5 · ForeignCessna 172 · Kempten, GermanyNTSB GAA21WA113Accident · No injuriesClass 5 · ForeignCessna F177RG · Pucallpa, Ucayali, PeruNTSB GAA21WA213Accident · No injuriesClass 5 · ForeignPiper PA38 · El Carmen, Jujuy Province, ArgentinaNTSB ERA21LA201Accident · 1 fatalClass 3 · LimitedFinal reportBeech A36 · Lakeland, FLThe total loss of engine power for reasons that could not be determined based on the available evidence.NTSB GAA21WA102Incident · No injuriesClass 5 · ForeignCessna 150 · Fernandópolis - SP, BrazilNTSB GAA21WA094Accident · Serious injuriesClass 5 · ForeignCessna 182 · Chiguao, VenezuelaNTSB WPR21LA173Accident · Minor injuriesClass 3 · LimitedFinal reportFlight Design Ctsw · Santa Fe, NMA leak in the oil line that supplied the engine with oil, which resulted in oil exhaustion and the total loss of engine power. Contributing to the accident was the routing of the oil line to close to the exhaust manifold.NTSB ERA21LA190Accident · No injuriesClass 3 · LimitedFinal reportCessna 182M · Eufaula, ALA total loss of engine power for reasons that could not be determined based on the available information.NTSB GAA21WA080Accident · No injuriesClass 5 · ForeignDiamond A20-C1 · Tarragona, SpainNTSB CEN21LA193Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28R · McKinney, TXA total loss of engine power for reasons that could not be determined based on the available information.NTSB ERA21LA187Accident · No injuriesClass 3 · LimitedFinal reportCessna 172S · Venice, FLA total loss of engine power for reasons that could not be determined based on the available information.NTSB ERA21LA188Accident · No injuriesClass 3 · LimitedFinal reportCessna A188 · Dover, NCA total loss of engine power due to a shift of a crankshaft main bearing, which resulted in a lack of lubrication and subsequent overheating and failure of the engine crankshaft. Contributing to the accident was the hard touchdown during the forced landing.NTSB GAA21WA077Accident · No injuriesClass 5 · ForeignAir Tractor AT301 · Vereda La Pedrera, ColombiaNTSB WPR21LA156Accident · No injuriesClass 3 · LimitedFinal reportCessna 182H · Blakely Island, WAA total loss of engine power during climb for reasons that could not be determined which resulted in a forced water landing.NTSB GAA21WA072Accident · No injuriesClass 3 · ForeignBell 206 · Region de Los Lagos, ChileNTSB ERA21LA174Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36 · Arcadia, FLA total loss of engine power for underdetermined reasons.NTSB GAA21WA091AccidentClass 4 · ForeignAir Tractor AT401 · Planura, BrazilNTSB GAA21WA084AccidentClass 5 · ForeignRotorway Executive 162F · Stansted, United KingdomNTSB ERA21LA166Accident · Serious injuriesClass 3 · LimitedFinal reportJabiru USA Sport J250-SP · Fort Pierce, FLA total loss of engine power for reasons that could not be determined based on available information.NTSB ANC21FA028Accident · Minor injuriesClass 3 · FieldFinal reportPiper PA-18A · Anchorage, AKA total loss of engine power for reasons that could not be determined based on the available evidence.NTSB WPR21LA145Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Marana, AZA total loss of engine power resulting from a catastrophic engine failure caused by a shift of the No. 2 main bearing and bearing seal, which resulted in oil starvation to the crankshaft; the reason for the bearing and bearing seal shift could not be…NTSB CEN21LA168Accident · No injuriesClass 3 · LimitedFinal reportPiper J3C-65 · Justin, TXThe total loss of engine power due to carburetor icing.NTSB WPR21LA140Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172S · Everett, WAA total loss of engine power during climb, for reasons that could not be determined based on available evidence.NTSB GAA21WA055Accident · No injuriesClass 5 · ForeignCessna 172 · Toledo, SpainNTSB GAA21WA096AccidentClass 4 · ForeignCessna 172 · Bordeaux, FranceNTSB GAA21WA052AccidentClass 5 · ForeignCessna 188 · La Cruz, MexicoNTSB GAA21WA058AccidentClass 5 · ForeignCessna 152 · Lalpur Tanore, BangladeshNTSB GAA21WA071AccidentClass 5 · ForeignRobinson R44 · Pretoria, South AfricaNTSB ERA21FA154Accident · 3 fatalClass 3 · FieldFinal reportBeech B36 · Pembroke Pines, FLThe pilot’s likely activation of the auxiliary fuel pump to “high” for undetermined reasons during takeoff, which resulted in total loss of engine power due to an excessively rich fuel-to-air mixture. Also causal was the pilot’s exceedance of the airplane’s…NTSB GAA21WA047Accident · Minor injuriesClass 5 · ForeignRobinson Helicopter R44 II · Rosh Pinna, IsraelNTSB GAA21WA043Accident · No injuriesClass 5 · ForeignCessna 182 · Sierpe river, OSA, Puntarenas, Costa RicaNTSB WPR21LA121Accident · No injuriesClass 3 · LimitedFinal reportCessna 150J · Lodi, CAA total loss of engine power during cruise flight due to a fatigue crack in the No. 3 cylinder connecting rod shaft resulting from either preignition or detonation, which resulted in a forced landing and impact with terrain.