NTSB investigations, 2020
142 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 year(c.\"eventDate\") = 2020
AND 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 year(c."eventDate") = 2020 AND 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 ERA20LA316Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV6 · Melbourne, FLA total loss of engine power for reasons that could not be determined based on the available evidence.NTSB GAA20WA138Incident · No injuriesForeign investigationPiper PA28R · Slagelse, DenmarkThe government of Denmark has notified the NTSB of an accident involving a PIPER PA28R airplane that occurred on September 10, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Denmark's investigation under the…NTSB ERA20LA327Accident · No injuriesClass 3 · LimitedFinal reportMooney M20R · Weston, FLA total loss of engine power because of the overheating and failure of the connecting rod bearings due to a lack of lubrication for reasons that could not be determined.NTSB ERA20LA309Accident · 3 fatalClass 3 · LimitedFinal reportPiper PA28 · McMinnville, TNA total loss of engine power due to a fatigue failure in a cylinder, and the pilot’s subsequent failure to maintain airspeed and her exceedance of the airplane’s critical angle-of-attack while maneuvering at low altitude.NTSB CEN20LA384Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32R · Bonham, TXThe loss of engine power due to a disconnected fuel injector line that was not properly tightened during recent maintenance.NTSB CEN20LA380Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 35 · Canyon Lake, TXThe total loss of engine power for a reason that could not be determined based on available information.NTSB CEN20LA385Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28-140 · Red Oak, IAThe pilot’s improper fuel management, which resulted in fuel exhaustion and a loss of engine power.NTSB CEN20CA386Accident · Minor injuriesClass 4 · Data collectionFinal reportPiper PA-38-112 · Reserve, LAThe loss of engine power for undetermined reasons.NTSB CEN20LA377Accident · No injuriesClass 3 · LimitedFinal reportStinson 108-3 · Coleman, MIThe pilot’s improper installation of the generator drive gear, which resulted in a total loss of engine power.NTSB CEN20LA370Accident · 3 fatalClass 3 · LimitedFinal reportPiper PA24 · Bryan, TXA total loss of engine power on takeoff due to fuel starvation.NTSB WPR20LA291Accident · Minor injuriesClass 3 · LimitedFinal reportCessna TU206 · Tusayan, AZA total loss of engine power due to fuel starvation as a result of contamination in the airplane’s fuel system.NTSB ERA20LA299Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Weston, FLA total loss of engine power due to the failure of the Nos. 1 and 3 connecting rods from lack of lubrication.NTSB CEN20LA364Accident · No injuriesClass 3 · LimitedFinal reportGrumman G164 · Ogallala, NEThe total loss of engine power due to a failure of the master connecting rod.NTSB ERA20LA295Accident · No injuriesClass 3 · LimitedFinal reportAeronca 11AC · Nebo, NCA leak in the main fuel tank that resulted in a total loss of engine power due to fuel starvation.NTSB CEN20LA360Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 180 · St Louis, MOA total loss of engine power due to improper maintenance of the mixture control cable and attachment hardware, which led to a forced landing into a congested area.NTSB ERA20LA289Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Surry, METhe pilot’s failure to use carburetor heat in conditions conducive to serious carburetor icing at glide power, which resulted in a loss of engine power and a forced ditching in water.NTSB CEN20LA346Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 36 · San Benito, TXA loss of engine power for a reason that could not be determined.NTSB CEN20LA338Accident · Minor injuriesClass 3 · LimitedFinal reportCessna A185F · Sugar Land, TXA total loss of engine power after takeoff for undetermined reasons, and the pilot’s subsequent exceedance of the airplane’s critical angle of attack during landing, which resulted in an aerodynamic stall.NTSB CEN20LA342Accident · Minor injuriesClass 3 · LimitedFinal reportSiebel Auriga · Rockford, ILThe total loss of engine power for reasons that could not be determined based on available information.NTSB WPR20LA259Accident · Serious injuriesClass 3 · LimitedFinal reportRutan Vari EZE · Kelso Valley, CAThe pilot’s failure to secure the fuel cap, which resulted in a total loss of engine power due to fuel exhaustion.NTSB GAA20WA129Accident · No injuriesForeign investigationHawker SEA Fury · Button End, Harston, Cambridgeshire, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a HAWKER SEA FURY airplane that occurred on August 08, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation…NTSB CEN20LA322Accident · Serious injuriesClass 3 · LimitedFinal reportQuad City Challenger · Jonesboro, LALoss of engine power due to the use of improper fuel in the airplane by the non-certificated pilot.NTSB ERA20LA271Accident · 1 fatalClass 3 · LimitedFinal reportAmerican AA 5 · Dunnellon, FLA total loss of engine power due to fuel starvation as a result of improper installation and inspection of the airplane’s fuel system. Contributing to the accident was the pilot’s lack of certification and knowledge in aircraft maintenance.NTSB WPR20LA247Accident · Minor injuriesClass 3 · LimitedFinal reportBell OH58A · Holtville, CAThe total loss of engine power due to the decoupling of the engine's turbine and compressor sections, which resulted from improper maintenance.NTSB CEN20LA314Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28R · Houston, TXThe loss of engine power for a reason that could not be determined based on available evidence.NTSB WPR20LA239Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV7 · Henefer, UTThe total loss of engine power due to the separation of the idler gear shaft bolts as a result of improper installation, which allowed for the idler gear to become disengaged.NTSB WPR20LA234Accident · No injuriesClass 3 · LimitedFinal reportMontana Coyote · Jamul, CAA total loss of engine power due to an obstructed fuel line and fuel starvation, which resulted in a forced landing and collision with a fence. Contributing to the accident was the long duration of aircraft storage that allowed for contaminants to develop and…NTSB ENG20WA040Incident · No injuriesForeign investigationEmbraer ERJ190 · Chihuahua, MexicoNTSB CEN20LA301Accident · No injuriesClass 3 · LimitedFinal reportVans RV4 · Idabel, OKThe pilot’s improper installation of an oil line, resulting in the loss of oil and subsequent total loss of engine power.NTSB WPR20LA228Accident · No injuriesClass 3 · LimitedFinal reportMd Helicopter 600 · San Andreas, CAThe failure of the output shaft of the overrunning clutch inner race due to frictional overheating of the shaft, which resulted from the failure of the output bearing’s stainless-steel grease seal.NTSB CEN20LA288Accident · No injuriesClass 3 · LimitedFinal reportBeech 36 · Independence, MOFailure of the No. 5 piston head and ring, which resulted in a total loss of engine power and the pilot’s decision to takeoff with a known mechanical issue.NTSB WPR20LA223Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 30 · Vaughn, NMThe total loss of power in the right engine due to fuel starvation. Contributing to the accident was the pilot’s failure to follow the manufacturer-recommended procedure after the loss of power in the right engine.NTSB CEN20LA276Accident · No injuriesClass 3 · LimitedFinal reportRockwell S2R R1340 · Keokuk, IAThe improper installation of a fuel vent line during maintenance, which resulted in fuel starvation and a total loss of engine power.NTSB CEN20WA293Accident · Serious injuriesForeign investigationCessna FR172 · Galway, IrelandThe government of the Ireland has notified the NTSB of an accident involving a Cessna FR172K airplane that occurred on July 11, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's investigation under the…NTSB CEN20LA279Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT502 · Dalhart, TXThe total loss of engine power due to a failed fuel control unit bearing.NTSB GAA20WA121Accident · 1 fatalForeign investigationBeech 58 · Sao Paulo, BrazilThe government of Brazil has notified the NTSB of an accident involving a BEECH 58 airplane that occurred on July 08, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of ICAO…NTSB CEN20LA263Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA32 · Eveleth, MNThe seizure of the airplane’s engine-driven fuel pump due to internal contamination, which led to a total loss of engine power. The source of the contamination could not be determined based on available evidence.NTSB CEN20WA437Accident · No injuriesClass 4 · ForeignPiper PA28 · Pointe-à-Pitre, GuadeloupeNTSB CEN20LA287Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT 602 · Des Arc, ARA total loss of engine power for reasons that could not be determined from all available evidence.NTSB CEN20LA269Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT 602 · Weldon, ARThe total loss of engine power during cruise flight for reasons that could not be determined based on the available evidence.NTSB CEN20LA258Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Bridgeport, TXMaintenance personnel’s inadequate inspection, which resulted in a total loss of engine power due to a restricted air intake-induction system.NTSB CEN20LA252Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28R · Denver, COThe total loss of engine power during climbout due to fuel starvation. Contributing to the accident was the pilot’s inadequate fuel planning.NTSB CEN20LA245Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 182 · Winfield, TXThe total loss of engine power due to the pilot’s improper fuel management, which led to fuel starvation. Contributing to the accident was the low altitude at which the loss of engine power occurred.NTSB WPR20LA190Accident · No injuriesClass 3 · LimitedFinal reportSchweizer 269C · North Las Vegas, NVA total loss of engine power for reasons that could not be determined based on the available information.NTSB WPR20LA189Accident · Minor injuriesClass 3 · LimitedFinal reportAerospatiale SA342J · Minden, NVThe total loss of engine power due to a surge; the reason for the surge could not be determined based on available information. Contributing to the helicopter damage was the total loss of power while the pilot was transitioning through an altitude and…NTSB ERA20LA216Accident · No injuriesClass 3 · LimitedFinal reportBell 47G · Atoka, TNA total loss of engine power due to a blocked fuel line; the reason for the blockage could not be determined based on the available evidence.NTSB ANC20LA060Accident · No injuriesClass 3 · LimitedFinal reportCessna 180 · Fairbanks, AKThe pilot’s failure to utilize carburetor heat while flying in conditions conducive carburetor to icing, which resulted in a total loss of engine power.NTSB CEN20LA228Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 24 · Livingston, TXThe total loss of engine power due to the failure of the No. 3 cylinder for reasons that could not be determined based on available evidence.NTSB WPR20LA180Accident · Minor injuriesClass 3 · LimitedFinal reportBellanca 7KCAB · Renton, WAMaintenance personnel’s inadequate post-maintenance inspections that resulted in the total loss of engine power due to a blockage in the air intake.NTSB ERA20LA212Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA32RT · Selma, ALThe mechanic’s failure to clean the oil suction screen during the most recent maintenance, which resulted in oil starvation and subsequent total loss of engine power.