Fatal NTSB investigations
463 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.\"highestInjuryLevel\" = 'Fatal'
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 c."highestInjuryLevel" = 'Fatal' 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 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.NTSB ERA20LA177Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA34 · Pembroke Pines, FLA total loss of power in the right engine for reasons that could not be determined based on available information. Contributing to the accident was the flight instructor’s decision to turn 180° before securing the right engine, which resulted in a loss of…NTSB WPR20LA123Accident · 1 fatalClass 3 · LimitedFinal reportCessna TU206 · Auburn, CAThe total loss of engine power after takeoff due to water contamination of the fuel.NTSB GAA20WA143Accident · 1 fatalClass 5 · ForeignPiper PA28 · Paquera, Province of Puntarenas, Costa RicaNTSB ERA20FA124Accident · 1 fatalClass 3 · FieldFinal reportCessna 177RG · Sterling, MAA total loss of engine power during takeoff due to fuel exhaustion. Contributing to the accident was the pilot’s inadequate preflight inspection.NTSB CEN20WA441Accident · 2 fatalClass 5 · ForeignRyan Aeronautical ST3KR · Les Chariots, FranceNTSB CEN20FA096Accident · 1 fatalClass 3 · FieldFinal reportBeech A36 · Rogers, MNInadequate maintenance that resulted in improper torque to the engine-driven fuel pump inlet fitting, which led to a loss of engine power and forced landing into unsuitable terrain.NTSB WPR20FA077Accident · 2 fatalClass 3 · FieldFinal reportStinson V77 · Auburn, CAA total loss of engine power due to a combination of mechanical engine anomalies. Contributing to the accident was inadequate maintenance that failed to identify the engine anomalies.NTSB WPR20FA057Accident · 1 fatalClass 3 · FieldFinal reportThunder Mustang TM-1 · Santa Clarita, CAEngine detonation that resulted in material deformation of the crankcase and led to engine failure and restricted cockpit visibility.NTSB CEN20FA035Accident · 2 fatalClass 3 · FieldFinal reportBell 407 · Gulf of Mexico (Gulf of Mexico)A total loss of engine power due to the failure of the engine’s Nos. 3 and 4 bearings and the power turbine pinion gear, and subsequent loss of main rotor rpm, which resulted in a loss of control and impact with the water.NTSB ERA20FA026Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32R · Paducah, KYThe pilot’s failure to fully seat the fuel selector in the proper tank position during the descent for landing, which resulted in fuel starvation and a total loss of engine power.NTSB WPR20FA005Accident · 1 fatalClass 3 · FieldFinal reportBede BD5 · Camarillo, CAThe No. 4 connecting rod’s bearing shift and separation of the No. 4 connecting rod, which resulted in a total loss of engine power and subsequent forced landing.NTSB WPR19FA251Accident · 2 fatalClass 3 · FieldFinal reportPiper PA18 · Hood River, ORThe total loss of engine power shortly after takeoff as a result of the private pilot’s failure to ensure the fuel selector was in the appropriate position and the certified flight instructor’s exceedance of the airplane’s critical angle of attack at the time…NTSB CEN19FA279Accident · 2 fatalClass 3 · FieldFinal reportAero Commander 200 · Howell, MIThe improper installation of the engine’s metal intake screen, which allowed the filter element to become displaced and subsequently lodge in the intake, blocking intake air and causing the total loss of engine power, at low altitude and low airspeed…NTSB CEN19FA276Accident · 1 fatalClass 2 · FieldFinal reportShirley Carl Sportcopter Vortex · Viroqua, WIThe noncertificated pilot's loss of control of the gyrocopter after a total loss of engine power due to seizure of the crankshaft bearings. Contributing to the accident were the insufficient maintenance of the engine and the pilot's lack of gyrocopter flight…NTSB ERA19LA247Accident · 1 fatalClass 3 · LimitedFinal reportFantasy Air Allegro · Boone, NCThe reported total loss of engine power for reasons that could not be determined based on the available evidence.NTSB WPR19FA215Accident · 1 fatalClass 3 · FieldFinal reportNorth American T28A · Ontario, ORA total loss of engine power due to the improperly adjusted carburetor idle valve.NTSB CEN19FA210Accident · 1 fatalClass 2 · FieldFinal reportBeech A36 · Chebanse, ILA total loss of engine power due to fuel starvation.NTSB ERA19FA189Accident · 2 fatalClass 3 · FieldFinal reportBeech A36 · Southold, NYA total loss of engine power due to a main bearing shift and the pilot’s subsequent failure to maintain a proper glide path to the selected forced landing site. Contributing to the accident was the pilot’s decision to operate the airplane with known…NTSB CEN19FA160Accident · 3 fatalClass 3 · FieldFinal reportRobinson R44 · Cass, ARA loss of engine power for reasons that could not be determined based on the available information.NTSB CEN19FA143Accident · 1 fatalField investigationFinal reportBeech 60 · Loveland, COA loss of control due to an inflight right engine fire due to the loose fuel hose between the engine-driven fuel pump and the flow transducer.NTSB CEN19FA165Accident · 2 fatalField investigationFinal reportBeech V35 · Frankfort, MIA loss of engine power for reasons that could not be determined based on the available information.NTSB GAA19WA274Accident · 1 fatalForeign investigationCessna T210 · Atizapán de Zaragoza, Mexico (jjc airport), MexicoThe government of Mexico has notified the NTSB of an accident involving a CESSNA T210 airplane that occurred on May 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB WPR19FA126Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Mill Creek, CAA total loss of engine power due to oil starvation as a result of the failure of a gasket on the oil filter adapter and the pilot’s inability to clear power lines during the emergency landing.NTSB ERA19FA142Accident · 1 fatalField investigationFinal reportRobinson R44 II · Tampa, FLContamination of and an inadequate bond between the two layers of fabric comprising the helicopter engine's air induction inlet duct, which resulted a partial collapse of the duct, obstruction of the airflow into the engine, and a total loss of engine power.NTSB CEN19FA109Accident · 1 fatalClass 3 · FieldFinal reportAerospatiale AS350 · Montgomery, TXMaintenance personnel's failure to properly re-install and secure a fuel line, which resulted in a total loss of engine power.NTSB WPR19FA091Accident · 1 fatalClass 2 · FieldFinal reportBell UH1B · Forks, WAA total loss of engine power due to the failure of the gas generator sealing disk as a result of the operator’s exceedance of the sealing disk life limits at too low an altitude for the pilot to accomplish a successful autorotation which resulted in the…NTSB ERA19WA128Accident · 2 fatalForeign investigationCessna T182 · Jacareacanga County, BrazilThe government of Brazil has notified the NTSB of an accident involving a Cessna T182 airplane that occurred on February 23, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB ERA19WA127Accident · 1 fatalForeign investigationCessna 210 · Belém City, State of Pará, BrazilThe government of Brazil has notified the NTSB of an accident involving a Cessna 210 airplane that occurred on February 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB CEN19LA055Accident · 1 fatalClass 3 · LimitedFinal reportBeech 36 · Fredericksburg, TXThe loss of engine power due to fatigue failure of the crankshaft.NTSB ERA19WA088Accident · 1 fatalForeign investigationRobinson R44 · Ubatuba, BrazilThe government of Brazil has notified the NTSB of an accident involving a Robinson R44 II that occurred on January 1, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of ICAO…NTSB CEN19WA040Accident · 4 fatalForeign investigationCessna U206 · Culiacan, Sinaloa, MexicoNTSB CEN19WA041Accident · 2 fatalForeign investigationCessna T206H · Tampico, MexicoOn November 12, 2018, about 2016 UTC, a Mexican registered Cessna T206H airplane, XB-ILM, sustained substantial damage during a forced landing to a highway due to a loss of engine power near Tampico, Tamaulipas, Mexico. The pilot and passenger were not…NTSB CEN19FA009Accident · 1 fatalClass 2 · FieldFinal reportRobinson R22 · Fulton, MOA total loss of engine power due to carburetor icing, the pilot's delayed application of carburetor heat, and the pilot's delay in entering an autorotation following the loss of engine power, which resulted in a main rotor stall due to low rotor rpm and an…NTSB CEN18FA384Accident · 2 fatalField investigationFinal reportCessna 150 · Festus, MOA total loss of engine power due to fuel exhaustion and the pilot's subsequent exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's decision to initiate and continue the…NTSB WPR18FA266Accident · 1 fatalClass 2 · FieldFinal reportBeech 33 · Cottonwood, AZThe pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA18FA244Accident · 2 fatalField investigationFinal reportCessna 335 · Lake Worth, FLThe pilot's loss of control during approach for landing following a total loss of left engine power for undetermined reasons.NTSB ERA18FA231Accident · 4 fatalField investigationFinal reportCessna 182 · Swainsboro, GAThe total loss of engine power for reasons that could not be determined based on available information.NTSB ERA18FA230Accident · 1 fatalField investigationFinal reportAeronca 7AC · Hanson, MAA loss of engine power due to carburetor icing, the pilot's decision to turn back to the runway shortly after takeoff, and his failure to maintain airspeed during the turn, which resulted in an exceedance of the airplane's critical angle of attack, and…NTSB CEN18FA336Accident · 1 fatalField investigationFinal reportCessna 172 · Rhome, TXThe pilot's inadequate maintenance of the airplane, which resulted in a total loss of engine power due to fuel starvation when organic debris restricted available fuel to the carburetor, and the pilot's impairment due to the ingestion of alcohol, which…NTSB WPR18FA219Accident · 1 fatalField investigationFinal reportBeech A36TC · Sylmar, CAThe pilot's failure to maintain airplane control following a total loss of engine power for reasons that could not be determined based on the available information.NTSB ERA18WA219Accident · 3 fatalForeign investigationCessna 210 · Sao Felix do Xingu, BrazilThe government of Brazil has notified the NTSB of an accident involving a Cessna 210 airplane that occurred on July 27, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…NTSB CEN18FA277Accident · 1 fatalClass 2 · FieldFinal reportCessna 152 · Fort Rice, NDThe pilot's failure to use carburetor heat in conditions that were conducive to serious carburetor icing, which resulted in a loss of engine power, an exceedance of the airplane's critical angle of attack, and an aerodynamic stall. Contributing to the…NTSB ERA18LA183Accident · 1 fatalLimited investigationFinal reportBell 206 · Rio Grande, PRA total loss of engine power due to oil exhaustion, which resulted in an uncontrolled descent and hard landing.NTSB CEN18FA235Accident · 2 fatalField investigationFinal reportErcoupe 415 D · Monmouth, ILA loss of engine power for reasons that could not be determined based on the available information.NTSB CEN18WA214Accident · 1 fatalForeign investigationBell 47 · Ciudad Valles, MexicoOn May 25, 2018, at 0030 hours universal coordinated time, a Scotts Bell 47 helicopter, Mexican registration XB-OSS, impacted terrain following a loss of engine power during an aerial application flight in San Luis Potosi, Mexico. The pilot was fatally…NTSB ERA18FA138Accident · 1 fatalField investigationFinal reportPiper PA32 · West Milford, NJAn in-flight fire and total loss of engine power after takeoff due to a loose fuel line. Contributing to the accident was the installation of an unapproved fuel line by unknown personnel.NTSB CEN18LA150Accident · 2 fatalLimited investigationFinal reportWolfe Kitfox V · Kalkaska, MIThe pilot's failure to maintain airplane control that resulted in a stall/spin following climb from the departure airport.NTSB ERA18WA274Accident · 2 fatalForeign investigationPiper PA28 · Nafpaktos, GreeceThe government of Greece has notified the NTSB of an accident involving a PIPER PA28 airplane that occurred on April 21, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Greece's investigation under the provisions of…NTSB CEN18FA139Accident · 1 fatalField investigationFinal reportWittman W10 · San Antonio, TXAn in-flight fire and subsequent total loss of engine power for reasons that could not be determined due to extensive impact and fire damage, followed by a loss of airplane control.