NTSB investigations
1,858 cases where the sequence of events included Loss of engine power (partial).
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\" = '342' 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" = '342' 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 ANC13LA059Accident · No injuriesLimited investigationFinal reportCessna 175 · Skwentna, AKThe partial loss of engine power for reasons that could not be determined because the postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation. .NTSB WPR13FA289Accident · 1 fatalField investigationFinal reportCessna P337H · San Luis Obispo, CALoss of engine power from the rear engine for reasons that could not be determined because of the postimpact thermal damage to the engine. Contributing to the accident were the pilot's decision to continue flight with a known deficiency, his failure to abort…NTSB WPR13FA284Accident · 2 fatalField investigationFinal reportBeech A45 · Boulder City, NVThe pilot/mechanic's loss of control during an emergency descent following a loss of engine power while in cruise flight. Contributing to the accident was the pilot/mechanic's incorrect assembly of the No. 6 cylinder at the last cylinder change, which…NTSB ERA13LA300Accident · Minor injuriesLimited investigationFinal reportSikorsky 269C · Lumberton, NJThe pilot's movement of the throttle to the idle detent at the beginning of a practice autorotation, which was contrary to procedures and resulted in the engine hesitating during the power recovery and a subsequent hard landing.NTSB CEN13LA359Accident · No injuriesLimited investigationFinal reportBell 206 - L4 · Lake City, ARA partial loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB WPR13LA275Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Waihee-Waiehu, HIThe loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies due to saltwater immersion.NTSB CEN13LA390Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Boise City, OKThe total loss of engine power for reasons that could not be determined because postaccident examination of the engine and fuel system revealed no anomalies.NTSB CEN13LA341Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Farnsworth, TXThe partial loss of engine power for reasons that could not be determined because the postaccident engine examination revealed no anomalies.NTSB CEN13LA325Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · New Braunfels, TXThe pilot's improper flare during an autorotation, which resulted in a hard landing, and a partial loss of engine power for reasons that could not be determined because the examination of the engine did not reveal any anomalies that would have precluded…NTSB ERA13LA269Accident · Minor injuriesLimited investigationFinal reportStinson 108 · Elkton, KYThe pilot's failure to use carburetor heat during the approach to landing, which resulted in carburetor icing and a partial loss of engine power during a subsequent initial climb.NTSB ERA13LA263Accident · 1 fatalLimited investigationFinal reportWilson William M Cricket MC12 · Doylestown, PAThe pilot's failure to abort the takeoff after detecting the airplane’s degraded performance. Contributing to the accident were the likely loss of power from the left engine for reasons that could not be determined during the postaccident examination of the…NTSB WPR13CA252Accident · Minor injuriesData collectionFinal reportCessna 172A · Eatonville, WAA partial loss of engine power due to carburetor icing and the pilot's failure to maintain adequate airspeed during a go-around, which resulted in a stall.NTSB ERA13LA254Accident · Serious injuriesLimited investigationFinal reportFleming Eldridge E Sonex · Naples, FLThe pilot’s failure to maintain airspeed during a forced landing, which resulted in an aerodynamic stall. Contributing to the accident was a partial loss of the noncertificated engine’s power for reasons that could not be determined because examination of the…NTSB ERA13LA257Accident · No injuriesLimited investigationFinal reportCessna 180J · Greenwood, MSA partial loss of engine power due to carburetor icing.NTSB CEN13LA305Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Beaumont, TXThe lack of a forward clamp on the carburetor heat box rubber boot, which allowed the boot to be ingested into the inlet of the carburetor heat box, restricting the airflow and leading to a subsequent partial loss of engine power.NTSB CEN13LA287Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Oskaloosa, IAThe loss of engine power for reasons that could not be determined because the engine examination did not reveal any malfunctions or failures that would have precluded normal operation.NTSB WPR13LA230Accident · No injuriesLimited investigationFinal reportCessna T188C · Pine Bluffs, WYThe loss of engine power during takeoff for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB ERA13LA241Accident · No injuriesLimited investigationFinal reportCessna 182E · Southwick, MAThe partial loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any malfunctions or failures that would have precluded normal operation.NTSB CEN13LA304Accident · Minor injuriesLimited investigationFinal reportAnkestar, Bradley D. RAND-ROBINSON KR2 · Hamilton, OHThe loss of engine power due to vapor lock in the fuel system. Contributing to the accident was the operation of the airplane with automotive gasoline and the installation of noninsulated fuel components near heat sources in the engine compartment.NTSB ANC13CA044Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Palmer, AKThe pilot's failure to use continuous carburetor heat while operating in conditions conducive to carburetor icing, which resulted in the development of carburetor ice and a subsequent partial loss of engine power.NTSB WPR13LA216Accident · Minor injuriesLimited investigationFinal reportRans S-17 · Fontana, CAA loss of engine power due to improper construction and inadequate maintenance of the fuel system and engine. Contributing to the accident was the airplane’s inadvertent contact with an unseen guy wire during the landing flare.NTSB WPR13LA224Accident · No injuriesLimited investigationFinal reportCessna 172M · Lakeport, CALoss of engine power during climb due to a failure of the No. 2 piston assembly; the reason for the failure could not be determined because of the extent of damage to the piston assembly.NTSB ERA13FA217Accident · Minor injuriesField investigationFinal reportCessna 172N · Dade City, FLThe in-flight loosening of the No. 3 cylinder exhaust valve rocker arm stud, which resulted in a complete loss of engine power.NTSB CEN13LA245Accident · No injuriesLimited investigationFinal reportRaytheon G36 · Hoxie, KSThe loss of engine power due to fuel starvation for reasons that could not be determined because a postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB ERA13LA214Accident · Serious injuriesLimited investigationFinal reportBeech 35-C33A · Knoxville, TNThe loss of engine power during takeoff for a reasons that could not be determined because postaccident examinations and testing revealed no anomalies that would have precluded normal operation.NTSB CEN13LA239Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Bowling Green, MOThe failure of the engine supercharger's rear bearing, which resulted in the loss of engine power.NTSB ERA13LA211Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-135 · Inlet, NYA loss of engine power for reasons that could not be determined during postaccident examination.NTSB CEN13LA232Accident · No injuriesLimited investigationFinal reportCessna 172G · Reading, MIThe partial loss of engine power due to the improper securing of the throttle linkage by maintenance personnel.NTSB ERA13WA203Accident · 2 fatalClass 5 · ForeignPiper PA-23-250 · Georgetown, GuyanaOn April 13, 2013, about 1854 coordinated universal time, a Piper PA-23-250, N27FT, was destroyed when it impacted a residence shortly after departing from Ogle International Airport (SYGO), Georgetown, Guyana. The certificated airline transport pilot and one…NTSB ERA13LA187Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLA partial loss of engine power due to the failure of the No. 3 exhaust valve. Contributing to the accident was the airplane operator’s failure to follow the engine manufacturer’s recommended engine overhaul intervals.NTSB ERA13WA304Accident · Minor injuriesForeign investigationEurocopter BO-105 · Granville, Cedros, Trinidad & TobagoOn March 26, 2013, about 1300 universal coordinated time, a Eurocopter BO-105 helicopter, Trinidad and Tobago registry 9Y-TIC, was substantially damaged during a forced landing to a forested area in Granville, Cedros, Trinidad and Tobago. The pilot sustained…NTSB ERA13LA171Accident · Serious injuriesLimited investigationFinal reportMcnulty John S Aerolite 103 · Immokalee, FLThe loss of engine power due to the seizure of the magneto piston.NTSB CEN13LA201Accident · No injuriesLimited investigationFinal reportPiper PA23-250 · Winsted, MNThe obstruction of the right engine’s induction air system by ice, which resulted in a loss of engine power.NTSB CEN13LA195Accident · No injuriesLimited investigationFinal reportNew Piper PA-46-500TP · Brenham, TXA lack of available engine power during an attempted go-around for reasons that could not be determined because the postaccident engine examinations did not reveal any anomalies consistent with an inability to produce rated power.NTSB CEN13LA193Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Seguin, TXThe partial loss of engine power for reasons that could not be undetermined because an examination of the engine did not reveal any malfunctions or failures that would preclude normal operation.NTSB CEN13FA182Accident · Minor injuriesField investigationFinal reportAero Commander 500B · Broomfield, COLoss of engine power due to fuel exhaustion. Contributing to the accident was the failure of the fuel gauge to indicate the actual amount of fuel on board the airplane and the design of the airplane's fuel system, which precluded a visual confirmation of the…NTSB ERA13LA143Accident · Minor injuriesLimited investigationFinal reportCessna T337G · Homestead, FLThe reported partial loss of engine power from the rear engine for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB ERA13FA131Accident · 1 fatalField investigationFinal reportCessna T337C · New Smyrna Beach, FLMaintenance personnel's failure to follow procedures and published directives in calibrating the continuous flow fuel system and failure to accurately diagnose debris in the throttle assembly, resulting in a loss of power in one engine. Contributing to the…NTSB CEN13LA157Accident · No injuriesLimited investigationFinal reportNorth American-Medore SNJ-4 · Garden City, TXThe loss of engine power due to fuel starvation.NTSB WPR13LA108Accident · No injuriesLimited investigationFinal reportCessna 175B · Wellsville, UTA loss of engine power during cruise flight due to carburetor ice.NTSB ENG13WA014Incident · No injuriesForeign investigationMcdonnell Douglas MD-82 · Copenhagen, Denmark, DenmarkOn January 30, 2013 an MD-82, registration number SE-DIK, sustained a serious engine failure during the takeoff roll. The engine has been removed from the airplane and will undergo a teardown examination. The Danish Accident Investigation Board is…NTSB ERA13LA121Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Yonkers, NYA partial loss of engine power for reasons that could not be determined because examination of the engine and associated components did not reveal any mechanical malfunction or failure that would have precluded normal operation.NTSB ERA13LA118Accident · Minor injuriesLimited investigationFinal reportHiller-Tri-Plex Ind.Inc. UH-12B · Okeechobee, FLThe pilot's failure to monitor carburetor temperature and use carburetor heat in conditions conducive to serious carburetor icing, which resulted in partial loss of engine power.NTSB WPR13LA101Accident · No injuriesLimited investigationFinal reportCessna 150L · Matlock, WAA partial loss of engine power after a descent to a lower altitude due to the student pilot's delayed action in applying carburetor heat while operating in conditions conducive to carburetor icing.NTSB WPR13LA099Accident · No injuriesLimited investigationFinal reportGoetz Helicycle · Mesa, AZThe pilot's failure to properly install and secure the wire connecting the electronic speed controller unit to the fuel controller actuator motor, which resulted in the wire’s disconnection in flight and the resultant partial loss of engine power.NTSB WPR13CA092Accident · No injuriesData collectionFinal reportHeinz Rans S-4 Coyote · Lake Pleasant, AZA partial loss of engine power during cruise flight for reasons that could not be determined because the airplane was not recovered.NTSB CEN13LA119Accident · No injuriesLimited investigationFinal reportBell 407 · Big Lake, TXThe loss of engine power due to the fatigue failure of the outer combustion case at the fuel nozzle port. Contributing to the accident was the operator’s failure to conduct the recommended routine inspections of the outer combustion case.NTSB ERA13FA082Accident · 1 fatalField investigationFinal reportCessna 421C · Lake Worth, FLThe pilot's failure to follow established engine-out procedures and to maintain a proper airspeed after the total loss of engine power on one of the airplane’s two engines during the initial climb. Contributing to the accident was the total loss of engine…NTSB CEN13LA095Accident · No injuriesLimited investigationFinal reportMooney M20E · Gurdon, ARThe total loss of engine power for reasons that could not be determined because no mechanical engine malfunctions were identified and because the actual fuel load and distribution at the time of the accident could not be determined.NTSB ERA13LA072Accident · Serious injuriesLimited investigationFinal reportHansen David Daniel RV-4 · Carthage, NCA partial loss of engine power for reasons that could not be determined because postaccident examinations of the engine and fuel system revealed no anomalies that would have precluded normal operation. Contributing to the severity of the accident was the…