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 CEN19FA210Accident · 1 fatalClass 2 · FieldFinal reportBeech A36 · Chebanse, ILA total loss of engine power due to fuel starvation.NTSB WPR19LA185Accident · No injuriesClass 3 · LimitedFinal reportCessna TU206 · Waikoloa Village, HIThe total loss of engine power due to the failure of the No. 4 connecting rod crankshaft end and cap.NTSB WPR19LA187Accident · No injuriesClass 3 · LimitedFinal reportBeech C23 · Ludlow, CAMaintenance personnel’s failure to properly tighten an oil line fitting, which resulted in a total loss of engine power.NTSB GAA19CA382Accident · No injuriesData collectionFinal reportPiper PA24 · Brunswick, GAThe pilot's failure to properly lean the fuel mixture in flight, which resulted in fuel exhaustion, a subsequent total loss of engine power, and a forced landing with the landing gear retracted.NTSB CEN19LA202Accident · No injuriesClass 3 · LimitedFinal reportAeronca L16A · Zelienople, PAA total loss of engine power due to obstruction of the carburetor air intake by a piece of the air filter gasket that had become detached.NTSB CEN19LA199Accident · Serious injuriesClass 3 · LimitedFinal reportZenair CH750 Stol · Paducah, KYA stuck exhaust valve that resulted in a loss of engine power and a forced landing to rough terrain.NTSB WPR19LA179Accident · Minor injuriesClass 3 · LimitedFinal reportStinson 108 · Caldwell, IDA total loss of engine power during approach due to a failed piston. The reason for the piston failure could not be determined based on the available information.NTSB ERA19LA219Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV 4 · Williamson, GAThe pilot's inadvertent misplacement of the fuel selector, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN19LA213Accident · No injuriesClass 3 · LimitedFinal reportErcoupe 415 · Smithfield, RIThe pilot’s failure to use carburetor heat on approach in weather conditions conducive to carburetor icing, which resulted in a forced landing to a pond.NTSB CEN19LA204Accident · No injuriesClass 3 · LimitedFinal reportWaco YMF-5C · Bar Harbor, MEA total loss of engine power due to a cylinder failure for undetermined reasons.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 CEN19LA159Accident · No injuriesClass 3 · LimitedFinal reportLancair LC41 · Cleburne, TXA total loss of engine power due to oil starvation as the result of the oil pressure switch failure due to a manufacturing defect.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 CEN19LA147Accident · Minor injuriesClass 3 · LimitedFinal reportCessna P210 · Yankeetown, FLA loss of engine power for reasons that could not be determined based on the available evidence.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 ERA19LA177Accident · No injuriesClass 3 · LimitedFinal reportZenith CH750 · Savannah, TNThe total loss of engine power due to a loss of all electrical power. Contributing to the accident was the inaccessible placement of the alternator circuit breaker and the construction of the airplane without a backup electrical source.NTSB WPR19LA165Accident · Minor injuriesClass 3 · LimitedFinal reportCessna T210 · Medford, ORA total loss of engine power due to fuel starvation.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 ERA19IA178Incident · No injuriesClass 3 · IncidentFinal reportCessna 550 · Savannah, GAThe lineman's inadvertent introduction of diesel exhaust fluid (DEF) to the fuel truck fuel system icing inhibitor reservoir, which resulted in fuel contamination and a total loss of engine power. Contributing to the accident was the fixed-base operator's…NTSB WPR19LA137Accident · No injuriesClass 3 · LimitedFinal reportGrumman G164 · Sutter, CAA loss of engine power due to the in-flight separation of the fuel control unit interconnect rod for reasons that could not be determined due to lack of available evidence.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 CEN19LA129Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 23 · Sulphur Spring, TXThe pilot’s inadequate preflight inspection, during which he failed to detect the water contamination in the left fuel, which resulted in a partial loss of power in the left engine. Contributing to the accident was the total loss of power in the right engine…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 WPR19LA120Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 18 225 DD · McCall, IDA total loss of engine power for reasons that could not be determined based on the available information.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 WPR19LA108Accident · Serious injuriesClass 3 · LimitedFinal reportEuropa XS · Winters, CAThe pilot's failure to properly install a wrist pin circlip, which resulted in internal damage to the No. 5 cylinder and a subsequent total loss of engine power.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.