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 ERA12LA453Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · North Myrtle Beach, SCThe pilot's inadequate use of carburetor heat during cruise flight, which resulted in a partial loss of engine power and subsequent forced landing.NTSB WPR12LA321Accident · No injuriesLimited investigationFinal reportLoflin RV-7A · Novato, CAThe partial loss of engine power for reasons that could not be determined because postaccident examination revealed no mechanical malfunctions or failures that would have precluded normal operation. Contributing to the accident was the pilot’s failure to…NTSB CEN12WA681Accident · No injuriesForeign investigationMcdonnell Douglas 500 · Kastire, LatviaOn July 12, 2012, about 0945 local time, a McDonnell Douglas MD-500 helicopter, registration OH-HJR, sustained substantial damage when it impacted terrain near Kastire, Latvia. The pilot was not injured. This investigation is under the jurisdiction of the…NTSB ERA12LA442Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Pensacola, FLA partial loss of engine power during initial climb for reasons that could not be determined because examination of the engine did not reveal any anomalies that would have precluded normal operation.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 ERA12LA400Accident · No injuriesLimited investigationFinal reportBarney Oldfield Baby Lakes · Anderson, SCA total loss of engine power as a result of an inadequate amount of lubricating oil in the engine. Contributing to the accident was the pilot's improper preflight inspection.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 CEN12LA352Accident · No injuriesLimited investigationFinal reportGrumman G164 · Higginson, ARThe partial loss of engine power for reasons that could not be determined due to impact and fire damage.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 ERA12CA371Accident · No injuriesData collectionFinal reportAero Works Aero Lite 103 · Lincolnton, NCThe loss of engine power due to fuel flow interruption, which resulted from a stuck carburetor bowl needle.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 CEN12LA308Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Frankenmuth, MIA partial loss of engine power for undetermined reasons and the pilot’s failure to maintain airspeed, which resulted in an aerodynamic stall.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 ERA12LA343Accident · No injuriesLimited investigationFinal reportCessna 195A · Tipton, PAA fatigue failure of a copper oil line, which resulted in a partial loss of engine power due to oil starvation.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 ERA12LA336Accident · Minor injuriesLimited investigationFinal reportBeech A36TC · Erwin, NCThe partial loss of engine power shortly after takeoff due to fatigue-fractured exhaust valve springs. Contributing to the accident was the mechanic’s decision to install exhaust valve springs with an unknown service history in the engine’s No. 4 cylinder.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 CEN12LA253Accident · Serious injuriesLimited investigationFinal reportBumford-Royer Christen Eagle II · Pearland, TXA loose B nut on the fuel inlet line due to maintenance personnel’s application of insufficient torque on the nut at an unknown time, which resulted in a fuel leak and a subsequent total loss of engine power during initial climb.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 ERA12LA295Accident · Minor injuriesLimited investigationFinal reportRaytheon A36 · Yorktown, NYThe pilot's improper placement of the fuel selector, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the pilot's failure to perform the published emergency procedure by the checklist.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 CEN12LA242Accident · Minor injuriesLimited investigationFinal reportBell 407 · Aberdeen, SDThe fatigue failure of two turbine engine blades due to vibration.NTSB CEN12LA230Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Isabel, SDThe partial loss of engine power due to carburetor ice.