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 GAA19CA426Accident · Minor injuriesData collectionFinal reportNorth American T28 · Hollister, CAThe pilot's improper fuel planning, which resulted in fuel exhaustion and the subsequent total loss of engine power.NTSB CEN19WA201Accident · Serious injuriesForeign investigationPiper PA28R · Pointe-A-Pitre, GuadeloupeNTSB CEN19LA175Accident · Minor injuriesClass 3 · LimitedFinal reportFlightstar FC-II · Knoxville, TNA total loss of engine power for reasons that could not be determined based on available evidence.NTSB WPR19LA174Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 182M · Upland, CAThe total loss of engine power due to detonation within the No. 2 cylinder as a result of a lean fuel flow setting.NTSB CEN19LA163Accident · Serious injuriesClass 3 · LimitedFinal reportGriff Challenger · Switz City, INA total loss of engine power due to failure of a connecting rod bearing. Contributing to the engine failure was the lack of an engine overhaul within the prescribed interval.NTSB WPR19LA166Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 · Romona, CAA total loss of engine power due to oil starvation as a result of the failure of an oil filter adapter fiber gasket.NTSB GAA19CA336Accident · Minor injuriesData collectionFinal reportCessna 180 · Ontario, ORThe pilot's improper preflight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.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 GAA19CA344Accident · No injuriesData collectionFinal reportBell UH 1H · Bethel, AKThe pilot's improper fuel planning, which resulted in fuel exhaustion and a total loss of engine power, and his improper landing flare during a forced autorotation, which resulted in a hard landing. Contributing to the accident were the inoperative fuel…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 GAA21WA067AccidentClass 5 · ForeignCessna 172 · Keti Bandar, PakistanNTSB GAA19CA297Accident · No injuriesData collectionFinal reportQuicksilver 2S Sport · Waverly, MNThe pilot's improper preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent forced, hard landing in a field.NTSB GAA19CA295Accident · No injuriesData collectionFinal reportPipistrel Alpha Trainer · Salida, COThe pilot's failure to replace the fuel cap after fueling, which resulted in a loss of engine power due to fuel exhaustion and a subsequent forced landing to a field and subsequent collision with a fence.NTSB CEN19LA156Accident · No injuriesClass 3 · LimitedFinal reportRockwell S 2R · Oakes, NDThe failure of the helical cam gear of the engine assembly due to fatigue cracks in the gear teeth, which resulted in a total loss of engine power.NTSB CEN19LA149Accident · No injuriesClass 3 · LimitedFinal reportChistov Challenger · Raymond, MSA total loss of engine power for undetermined reasons.NTSB GAA19CA272Accident · No injuriesData collectionFinal reportPiper PA28 · Maitland, FLThe pilot's improper fuel planning, which resulted in fuel exhaustion, the total loss of engine power, and subsequent impact with a car during an emergency landing on a road.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 WPR19LA132Accident · No injuriesClass 3 · LimitedFinal reportOtterback Lightning · Woodland, WAA complete loss of engine power due to carburetor icing.NTSB WPR19LA129Accident · Serious injuriesClass 3 · LimitedFinal reportStorch FL-156C · Upland, CAThe pilot’s improper installation of the No. 3 cylinder valve cover, which resulted in an oil leak, oil starvation, and a subsequent total loss of engine power.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 GAA19CA236Accident · No injuriesData collectionFinal reportCessna 172 · Wasilla, AKThe flight instructor's failure to verify the fuel level, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent forced landing and collision with a power line pole. Contributing to the accident was the student pilot's…NTSB WPR19LA125Accident · Minor injuriesClass 3 · LimitedFinal reportStearman A75N1(PT17) · Sequim, WAThe total loss of engine power due to the fatigue failure of the crankshaft.NTSB WPR19LA122Accident · No injuriesClass 3 · LimitedFinal reportBell 206 · Oakridge, ORA total loss of engine power following the failure of a 3rd stage turbine blade due to low- and high-cycle fatigue.NTSB ENG19WA022Accident · No injuriesForeign investigationBell 222 · Addis Ababa, EthiopiaOn April 26, 2019, a Trans Nation Airways, PLC, Bell 222UT helicopter, registered in Ethiopia as ET-AVF crashed near the Addis Ababa Bole International Airport, Addis Ababa, Ethiopia after both engines, Honeywell LTS101-750 turboshafts, lost power. The…NTSB ERA19LA152Accident · No injuriesClass 3 · LimitedFinal reportBell 206 · Dublin, GAA partial loss of engine power on takeoff due to separation of the diffuser assembly as a result of incomplete braze joint surfaces on the vane airfoils.NTSB ANC19LA016Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Bethel, AKA total loss of engine power due to a fatigue failure of the crankshaft. A contributing factor was the inadequate inspection during the engine’s last overhaul.NTSB ERA19LA151Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150 · Fulton, NYA total loss of engine power due to carburetor icing. Contributing was the pilot’s failure to leave the carburetor heat on fully after his initial application of carburetor heat.NTSB ERA19LA149Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28R · Meriden, CTThe loss of engine power for undetermined reasons.NTSB ERA19LA143Accident · No injuriesClass 3 · LimitedFinal reportCessna 175 · Edgefield, SCThe total loss of engine power due to a stuck engine exhaust valve. Contributing to the loss of engine power was the pilot’s failure to properly address the recurring stuck exhaust valve issue.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 CEN19LA132Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28R · Prairieville, LAInstallation of an incorrect engine oil drain valve, which resulted in damage to the valve during landing gear retraction and subsequent engine failure due to oil starvation. Contributing to the accident was the failure of maintenance personnel to comply with…NTSB ERA19LA141Accident · Serious injuriesClass 3 · LimitedFinal reportFlight Design Ctls · Palatka, FLThe pilot’s improper management of his fuel supply, which resulted in fuel exhaustion and a total loss of engine power. Contributing to the outcome was the improper maintenance of the airplane’s ballistic recovery parachute system, which resulted in its…NTSB ERA19LA139Accident · No injuriesClass 3 · LimitedFinal reportMarlow Bearhawk · Sevierville, TNAbnormal combustion in the No. 1 cylinder for reasons that could not be determined based on the available evidence, followed by the activation of the ignition system circuit breaker, which resulted in 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 CEN19LA111Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Newton, KSThe loss of engine power after the No. 1 connecting rod end separated as a result of oil starvation, which led to the forced landing and nose-over.NTSB ERA19LA135Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA22 · Blanch, NCA total loss of engine power for undetermined reasons.NTSB CEN19WA118Accident · Serious injuriesForeign investigationRobinson R44 · Stavnes, NorwayThe government of Norway has notified the NTSB of an accident involving a Robinson R44 helicopter that occurred on March 23, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Norway's investigation under the provisions…NTSB GAA19CA181Accident · Minor injuriesData collectionFinal reportAir Creation Tanarg · Kailua-Kona, HIThe pilot's improper preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB GAA19CA173Accident · Minor injuriesData collectionFinal reportPereira Osprey · Independence, IAThe pilot's improper fuel planning, which resulted in fuel exhaustion and a total loss of engine power.NTSB ERA19LA160Accident · No injuriesLimited investigationFinal reportPiper PA28R · Easton, MDThe loss of engine power for reasons that could not be determined because postaccident engine examination and testing revealed no preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN19LA098Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA32R · Waterloo, ILThe loss of engine power due to a connecting rod failure for reasons that could not be determined due to secondary mechanical damage, which resulted in a subsequent forced landing.NTSB GAA19CA166Accident · Minor injuriesData collectionFinal reportCessna 177RG · Land O' Lakes, WIThe pilot's improper fuel planning, which resulted in fuel exhaustion and the subsequent 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 ERA19TA120Accident · Minor injuriesClass 3Final reportCirrus SR22 · Atlantic Ocean (Atlantic Ocean)A loss of oil pressure and subsequent total loss of engine power for undetermined reasons.NTSB WPR19LA092Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Melba, IDThe total loss of engine power due to a separated carburetor idle mixture adjustment screw and spring assembly for reasons that could not be determined.NTSB ERA19TA111Accident · No injuriesFinal reportPiper PA32 · West Palm Beach (Atlantic Ocean)A total loss of engine power for reasons that could not be determined based on the available evidence, which resulted in a ditched landing in the ocean.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 CEN19LA091Accident · Serious injuriesClass 3 · LimitedFinal reportVan's RV-8 · Horseshoe Bay, TXA total loss of engine power for reasons that could not be determined based on the available information.