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 CEN21LA219Accident · Serious injuriesClass 3 · LimitedFinal reportBeech B24R · New Lenox, ILThe total loss of engine power due to fuel contamination as a result of the pilot’s improper fueling of the airplane.NTSB 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 CEN21LA231Accident · No injuriesClass 3 · LimitedFinal reportCessna 150J · Madison, ARThe pilot’s improper fuel planning which led to fuel exhaustion, and a total loss of engine power.NTSB CEN21LA204Accident · 1 fatalClass 3 · LimitedFinal reportPiper J3C-65 · Slaughter, LAA total loss of engine power for reasons that could not be determined from the available evidence.NTSB 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 CEN21LA206Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Curtis, NEWater contamination of the airplane’s fuel supply which resulted in a total loss of engine power.NTSB 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 CEN21LA194Accident · No injuriesClass 3 · LimitedFinal reportCessna A185F · North Vernon, INThe pilot’s improper installation of the fuel selector handle, which resulted in a total loss of engine power due to fuel starvation.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 ANC21LA024Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18A 150 · Kasilof, AKThe pilot’s mismanagement of the available fuel, which resulted in a total loss on engine power due to fuel starvation.NTSB CEN21LA151Accident · 1 fatalClass 3 · LimitedFinal reportBeech 35 · Palestine, TXA total loss of engine power due to the flight crew incorrectly placing the fuel selector between fuel tank detents, which resulted in fuel starvation. Contributing to the accident was the lack of a placard on the fuel selector, the lack of obvious fuel tank…NTSB GAA21WA043Accident · No injuriesClass 5 · ForeignCessna 182 · Sierpe river, OSA, Puntarenas, Costa RicaNTSB WPR21LA122Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172G · Sisters, ORA total loss of engine power due to fuel starvation and the pilot’s mismanagement of the available fuel.NTSB 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.NTSB GAA21WA051Accident · No injuriesClass 5 · ForeignPiper PA-31-350 · Buitron, MexicoNTSB GAA21WA137Accident · No injuriesClass 4 · ForeignPiper PA-30 · Courcelles-sur-Viosnes, FranceNTSB CEN21LA146Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 · Grand Haven, MIThe total loss of engine power for reasons that could not be determined.NTSB WPR21LA127Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150E · Marana, AZThe total loss of engine power for reasons that could not be determined based on the available evidence.NTSB ERA21LA144Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Boynton Beach, FLA total loss of engine power for undetermined reasons.NTSB ANC21LA018Accident · Serious injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Lanai, HIA total loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN21LA145Accident · Serious injuriesClass 4 · LimitedFinal reportQuicksilver Mxii · Hattiesburg, MSThe total loss of engine power for undetermined reasons and the pilot’s failure to maintain clearance from the trees during the subsequent forced landing resulting in an impact with trees and terrain.NTSB WPR21LA119Accident · No injuriesClass 3 · LimitedFinal reportMooney M20E · Livermore, CAA total loss of engine power due to fuel starvation as a result of corrosion and rust in the fuel injection servo.NTSB GAA21WA107AccidentClass 5 · ForeignCessna 177RG · Amboise, France