NTSB investigations
1,419 cases where the defining event was 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '342') 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" = '342') 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 CEN12LA458Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Egeland, NDThe partial loss of engine power for reasons that could not be determined during postaccident examinations.NTSB ANC12LA068Accident · No injuriesLimited investigationFinal reportShorey Timothy A Preceptor Stol King · North Pole, AKA total loss of engine power due to a binding drive belt while in the airport traffic pattern.NTSB ANC12CA072Accident · No injuriesData collectionFinal reportPiper PA-12 · Quinhagak, 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 ERA12LA428Accident · No injuriesLimited investigationFinal reportCessna R172K · Greene, NYAn undetected fatigue crack on the outer surface of the No. 3 cylinder barrel that could only have been detected visually and not by a differential compression test , resulting in separation of the head from the barrel and a subsequent partial loss of engine…NTSB ERA12FA423Accident · 1 fatalField investigationFinal reportPiper PA-31P · Dalton, GAThe pilot’s failure to maintain airplane control following loss of power in the right engine for reasons that could not be determined because of fire and impact damage. Contributing to the accident was the pilot’s delayed feathering of the right propeller…NTSB ERA12LA425Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lakewood, NJThe loss of engine power during climb for reasons that could not be determined during postaccident examination of the engine and engine systems or during postaccident operational testing of the engine.NTSB WPR12LA275Accident · No injuriesLimited investigationFinal reportDehavilland Tiger Moth DH 82A · Fontana, CAPartial loss of engine power during cruise flight due to a failed engine cylinder rocker assembly clamping bolt. Contributing to the accident was the failure of unknown maintenance personnel to perform a modification to the assembly that would have prevented…NTSB CEN12LA388Accident · No injuriesLimited investigationFinal reportCessna A150K · Mamou, LAThe pilot's inadequate preflight inspection, which resulted in a partial loss of engine power due to fuel contamination.NTSB WPR12LA267Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Scottsdale, AZThe flight instructor’s failure to maintain adequate rotor rpm during a practice autorotation, which resulted in a loss of helicopter control and subsequent hard landing.NTSB CEN12LA384Accident · Minor injuriesLimited investigationFinal reportPeterson-Feder-Splinter Starduster TOO · Lake Dallas, TXA partial loss of engine power on takeoff due to a stuck intake valve on the No. 2 cylinder.NTSB ANC12LA051Accident · No injuriesLimited investigationFinal reportDehavilland DHC-2 · Talkeetna, AKThe loss of engine power after departure due to the separation of an engine cylinder.NTSB WPR12LA263Accident · No injuriesLimited investigationFinal reportCessna A185F · Winnett, MTA momentary loss of engine power, which led to an emergency descent at night during which the airplane collided with a wire. The reason for the loss of engine power could not be determined because postaccident examination and operation did not reveal any…NTSB CEN12LA368Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Hooker, OKThe pilot’s loss of airplane control after a partial loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine revealed no evidence of mechanical malfunctions or failures, which resulted in an…NTSB CEN12LA371Accident · No injuriesLimited investigationFinal reportAmen Star Lite · San Antonio, TXThe separation of the fuel tank sealant coating, which traveled into the fuel pump, blocked the fuel flow, and resulted in fuel starvation to the engine.NTSB WPR12LA264Accident · No injuriesLimited investigationFinal reportLuscombe 8 · Twentynine Palms, CAA loss of engine power during initial climb for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB ERA12LA365Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Dansville, NYA partial loss of engine power 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 CEN12LA332Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Greenfield, INA partial loss of engine power for undetermined reasons during takeoff.NTSB WPR12LA228Accident · No injuriesLimited investigationFinal reportCessna 150L · Tulare, CAA partial loss of engine power, which was likely the result of carburetor icing.NTSB CEN12LA357Accident · No injuriesLimited investigationFinal reportRockwell International S-2R · Howard, SDA fractured fabricated aluminum oil line, which resulted in oil exhaustion followed by a forced landing.NTSB WPR12FA222Accident · Minor injuriesField investigationFinal reportCessna P210N · Glendale, CAThe partial loss of engine power during descent 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 ERA12LA349Accident · Minor injuriesLimited investigationFinal reportBelcher, Gerald C BEL Aire 2000 · Tyre, NYA partial loss of engine power for reasons that could not be determined during the postaccident investigation.NTSB ERA12LA346Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 · Destin, FLThe partial loss of engine power due to a stuck (open) exhaust valve in the No. 5 cylinder. Contributing to the accident was the operator’s failure to follow the engine manufacturer’s directives concerning cooling of the engine after flight.NTSB CEN12LA306Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Marion, ARThe partial loss of engine power for reasons that could not be determined because examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN12LA299Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Shawnee, OKThe improper installation of the mixture cable by maintenance personnel, which allowed the mixture cable to entangle with the landing gear during gear extension and led to the subsequent loss of engine power.NTSB ERA12LA332Accident · Serious injuriesLimited investigationFinal reportStinson SR-7B · West Ossipee, NHThe pilot's inadequate application of carburetor heat which resulted in the formation of carburetor ice and a partial loss of engine power.NTSB WPR12LA201Accident · Minor injuriesLimited investigationFinal reportBeech 3NM · Pope Valley, CAA loss of power in one engine during takeoff, which resulted in a forced landing in a vineyard. The reason for the loss of engine power could not be determined from the available evidence.NTSB ERA12LA340Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Williston, FLLoss of engine power for reasons that could not be determined during postaccident examination and testing, which included a successful postaccident engine run.NTSB WPR12LA195Accident · Serious injuriesLimited investigationFinal reportRobinson R22 · Kailua-Kona, HIA loss of engine power while maneuvering 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 ERA12LA312Accident · Minor injuriesLimited investigationFinal reportShoup Ronald R RV-6A · Milton, FLA loss of engine power 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 ERA12LA318Accident · Minor injuriesLimited investigationFinal reportTemco GC-1B · Dayton, TNA partial loss of engine power during low-altitude maneuvers for reasons that could not be determined because the engine examination did not reveal any mechanical malfunctions or failures that would have precluded normal operation; however the carburetor was…NTSB CEN12LA261Accident · No injuriesLimited investigationFinal reportBeech A36 · Albuquerque, NMThe partial loss of engine power due to an intake valve that was stuck in the open position.NTSB WPR12LA181Accident · No injuriesLimited investigationFinal reportCub Crafters CC11-100 · Monmouth, ORA partial loss of engine power during takeoff for undetermined reasons.NTSB CEN12LA255Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Wildorado, TXThe loss of engine power for undetermined reasons.NTSB CEN12LA252Accident · Minor injuriesLimited investigationFinal reportBeech P35 · Englewood, COThe pilot’s failure to abort the takeoff after the airplane failed to gain adequate airspeed.NTSB WPR12LA176Accident · Serious injuriesLimited investigationFinal reportSkykits USA Savannah ADV · Ookala, HIA loss of engine power during cruise for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the pilot’s failure to avoid an…NTSB CEN12FA250Accident · No injuriesField investigationFinal reportSikorsky S-76B · Gulf of Mexico, LAThe intermittent loss of engine power due to a "stuck" stepper motor in the No. 2 engine's fuel control as a result of an inadequate overhaul. Contributing to the accident was the pilot's decision to continue flying the helicopter with a known defect, his…NTSB CEN12LA230Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Isabel, SDThe partial loss of engine power due to carburetor ice.NTSB ERA12LA267Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Eastover, SCInadequate or loss of through bolt preload tension, which resulted in fretting between the engine halves, the subsequent failure of one cylinder through bolt, the loosening of additional cylinder retaining studs, and the fracture of the crankcase.…NTSB WPR12LA141Accident · No injuriesLimited investigationFinal reportGrimm RV-9A · Santa Maria, CAA partial loss of engine power during cruise flight for reasons that could not be determined because postaccident examination and testing did not reveal any anomalies that would have precluded normal operation.NTSB ERA12LA241Accident · No injuriesLimited investigationFinal reportCessna 172K · Belfast, METhe flight instructor’s failure to ensure the radio was set correctly to activate the pilot-controlled lighting, which resulted in poor positioning for a proper landing and a subsequent off-runway forced landing during an attempted go-around. Contributing to…NTSB ERA12LA233Accident · Serious injuriesLimited investigationFinal reportBoehlke Kevin P 2/3 Scale Jenny · Hannacroix, NYThe non-certificated pilot's improper high-speed taxi test, which resulted in a loss of control and the pilot's subsequent decision to take off to avoid trees. Also causal, was an in-flight magneto failure, which resulted in a partial loss of engine power.…NTSB ERA12LA226Accident · Serious injuriesLimited investigationFinal reportMichael S/Michael K Safari · Middle Valley, TNA partial loss of engine power for reasons that could not be determined due to the postaccident condition of the airframe and engine.NTSB WPR12LA125Accident · No injuriesLimited investigationFinal reportAerospatiale AS 355F1 · Makakilo City, HIA partial loss of engine power while maneuvering over rough/uneven terrain that was precipitated by the failure of a 3rd stage turbine blade as a result of high-cycle fatigue.NTSB ERA12LA191Accident · No injuriesLimited investigationFinal reportCessna 172N · Flat Rock, VAThe partial loss of engine power due to the failure of the exhaust valve spring seat for reasons that could not be determined.NTSB WPR12LA099Accident · No injuriesLimited investigationFinal reportCessna 172M · Cusick, WAA total loss of engine power during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB DCA12WA063Incident · No injuriesForeign investigationMcdonnell Douglas MD80 - 80 · Copenhagen, DenmarkThe Danish Accident Investigation Board (AIB) has notified the NTSB of an incident involving a McDonnell Douglas MD-82 that occurred on February 5, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the AIB investigation under the…NTSB WPR12LA092Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201T · Kalispell, MTThe partial loss of engine power due to magneto malfunction. Contributing to the accident was the lack of adherence to the manufacturer’s recommended magneto overhaul schedule.NTSB CEN12LA192Accident · Minor injuriesLimited investigationFinal reportAero Commander 100 · Seguin, TXA loss of engine power for undetermined reasons.NTSB WPR12LA081Accident · Minor injuriesLimited investigationFinal reportMas Events Nemesis · Camarillo, CAA partial loss of engine power during cruise flight due to incorrectly installed airframe components, which came into contact with a high pressure fuel line and resulted in its failure. Contributing to the accident was an undetermined failure of the primary…NTSB CEN13WA102Incident · No injuriesForeign investigationRobinson Helicopter R44 · Oosterschelde, NetherlandsOn January 21, 2012, at 1430 universal coordinated time, a Robinson Helicopter Company model R44, Dutch registration PH-WMW, made an uneventful forced landing after experiencing a partial loss of engine power near Oosterschelde, The Netherlands. The pilot and…