NTSB investigations
4,618 cases where the first occurrence was “Loss of engine power”.
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350) 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350) 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 MIA00LA213Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Belleview, FLthe loss of engine power during takeoff/initial climb due to undetermined reasons.NTSB LAX00LA246Accident · No injuriesLimited investigationFinal reportGrumman G-164B · King City, CAThe loss of engine power for undetermined reasons.NTSB MIA00LA199Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Albany, GAThe dual student's failure to purge the fuel lines of air after a fuel tank was run dry on the previous flight and the failure of the electric fuel boost pump on or low position due to a loose wire which resulted in failure of the engine due to air in the…NTSB LAX00LA247Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Chester, CAThe loss of engine power for undetermined reasons.NTSB MIA00LA193Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-160 · Winter Haven, FLthe flight instructor's failure to follow procedures/directives and his misjudgment of distance/altitude following a loss of engine power for undetermined reasons, which resulted in the proper touchdown point not being attained, an off airport landing being…NTSB ATL00LA066Accident · No injuriesLimited investigationFinal reportCessna 172N · Atlantic Ocean (Atlantic Ocean)Loss of engine power for undetermined reasons. A factor was the pilot failed to use carburetor heat during the descent.NTSB NYC00LA176Accident · Minor injuriesLimited investigationFinal reportSchwarz Avid Amphibian · Fredericksburg, VAA failure of the propeller reduction gear assembly for undetermined reasons, which resulted in a loss of thrust.NTSB FTW00LA182Accident · No injuriesLimited investigationFinal reportCessna 152 · Mcallen, TXLoss of engine power for reasons undetermined. A factor was the lack of suitable terrain for the forced landing.NTSB CHI00LA167Accident · Serious injuriesLimited investigationFinal reportRans Employee Flying Club Rans S-12 XL · Prairie Du Sac, WIA loss of engine power due to fuel starvation as a result of an obstructed fuel nozzle.NTSB CHI00FA165Accident · 1 fatalField investigationFinal reportBellanca 7ECA · Westfield, INThe pilot's improper in-flight decison to maneuver back to the departure airport following the loss of engine power on initial climb, the pilot's loss of aircraft control and the pilot's inadequate preflight inspection of the airplane. Contributing factors to…NTSB NYC00LA157Accident · Minor injuriesLimited investigationFinal reportSiai-Marchetti SF260TP · Norfolk, VAFuel starvation of the engine, caused by the failure of the fuel transfer pump.NTSB FTW00LA176Accident · No injuriesLimited investigationFinal reportBellanca 17-31ATC · Del Rio, TXThe separation of the #3 connecting rod, piston, and cylinder. A factor was the lack of suitable terrain for the forced landing.NTSB ANC00LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Gakona, AKThe loss of engine power for an undetermined reason.NTSB SEA00LA098Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Quinault, WAFuel starvation due to the pilot's failure to position the fuel selector valve to the proper/correct position while switching fuel tanks. Factors include unreliable fuel selector valve position detents, having no suitable terrain in which to execute a forced…NTSB CHI00LA162Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Joliet, ILthe engine failure for undetermined reasons. Factors were the low altitude, remedial action not possible by the pilot, and the ditch.NTSB FTW00LA163Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Tulsa, OKthe loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB NYC00LA146Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Williamstown, NJimproper installation of a quick drain plug by the airplane owner/mechanic which resulted in a loss of engine oil and forced landing.NTSB DEN00LA091Accident · No injuriesLimited investigationFinal reportCessna 172XP · Larkspur, COA forced landing on soft unsuitable terrain. Factors were improper wiring of the electric fuel boost pump, which produce high pressure when either on position was selected causing the engine to flood during the practice engine out approach.NTSB SEA00LA087Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Middleton, IDLoss of engine power for undetermined reasons.NTSB LAX00LA199Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Biggs, CAThe broken exhaust valve rocker arm of the number 3 cylinder that resulted in a total loss of engine power during an aerial application flight.NTSB SEA00LA100Accident · No injuriesLimited investigationFinal reportCessna 172N · Atlantic Ocean (Atlantic Ocean)A loss of engine power for undetermined reasons.NTSB NYC00FA136Accident · 1 fatalField investigationFinal reportBell UH-1H · Frenchville, PAForeign object damage to the compressor and turbine sections of the engine, which resulted in a loss of power.NTSB LAX00LA197Accident · Minor injuriesLimited investigationFinal reportBeech H35 · Show Low, AZThe pilot's failure to properly position the fuel selector to a tank with fuel resulting in fuel starvation, a loss of engine power, and subsequent collision with the ground during the final landing approach.NTSB DEN00GA089Accident · 2 fatalFinal reportCessna T337C · Alamogordo, NMthe pilot's failure to maintain aircraft control, and the subsequent inadvertent stall/spin. Contributing factors were the loss of engine power on both engines for unknown reasons and the terrain induced turbulence.NTSB MIA00LA158Accident · No injuriesLimited investigationFinal reportPiper J-3 · Boca Raton, FLa loss of engine power due to undetermined reasons that resulted in a forced landing and substantial damage to the aircraft.NTSB MIA00LA156Accident · No injuriesLimited investigationFinal reportAsselyn CH701 · Wake Forrest, NCThe pilot's improper fuel management during a cross country flight resulting in a loss of engine power due to fuel exhaustion, and his failure to achieve the proper touchdown point during a forced landing. This resulted in the pilot forcing the airplane onto…NTSB MIA00LA154Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Highlands, NCTotal loss of engine power due to the obstruction (insect larva) of the left wing aft fuel system line resulting in a forced landing to non suitable terrain.NTSB MIA00LA153Accident · 2 fatalLimited investigationFinal reportMclarty Vans RV-4 · Apex, NCThe loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed resulting in an inadvertent stall and subsequent collision with terrain.NTSB NYC00LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Moneta, VALoss of power for undetermined reasons.NTSB MIA00LA152Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Fernandina Bch, FLThe loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed resulting in an inadvertent stall., in-flight collision with terrain, and subsequent nose over.NTSB ATL00LA056Accident · Serious injuriesLimited investigationFinal reportCessna 210A · Fayetteville, NCThe pilot's improper fuel management resulting in fuel starvation. A factor was improper planned approach.NTSB ANC00LA054Accident · No injuriesLimited investigationFinal reportCessna 170B · Delta Junction, AKA loss of engine power due to an undetermined reason. A factor in the accident was unsuitable terrain for a forced landing.NTSB SEA00LA084Accident · No injuriesLimited investigationFinal reportOveross Vans RV-8 · Independence, ORThe rotation of the right fuel tank elbow fitting within the tank during previous maintenance. The improper alignment resulted in the fuel pick-up tube being mis-positioned and a subsequent starvation of fuel to the engine. Contributing factors were the…NTSB CHI00LA127Accident · Minor injuriesLimited investigationFinal reportFairchild PT-26B · Winn, MIthe pilot's inadequate fuel management. Factors to the accident were fuel starvation, the low altitude at the time of the loss of engine power, remedial action not possible by the pilot, and the unsuitable terrain for landing encountered by the pilot.NTSB FTW00LA131Accident · Minor injuriesLimited investigationFinal reportBeech BE-35 · Lancaster, TXthe loss of engine power for undetermined reasons.NTSB ATL00LA045Accident · No injuriesLimited investigationFinal reportCessna 150 · Waycross, GAThe student pilot's inaccurate fuel consumption calculation that resulted in the total loss of engine power due to fuel exhaustion and the subsequent collision with a utility pole.NTSB LAX00LA166Accident · No injuriesLimited investigationFinal reportPZL-Mielec M-18A · Williams, CAA momentary interruption in engine power for undetermined reasons.NTSB LAX00LA162Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164B · Lodi, CAA loss of engine power for undetermined reasons.NTSB LAX00GA158Accident · 3 fatalFinal reportGrumman US-2C · Reno, NVthe flying pilot's failure to maintain directional control following a loss of engine power. Also causal was the failure of the flight crew to follow the published checklist and use the rudder assist system, and the decision not to abort the takeoff.NTSB IAD00FA038Accident · 1 fatalField investigationFinal reportPiper PA-12 · Norfolk, MAThe loss of power for undetermined reasons, which resulted in an inadvertent stall during at banner pick-up.NTSB NYC00LA114Accident · No injuriesLimited investigationFinal reportLoomis Sidewinder · Cincinnati, OHA partial power loss for undetermined reasons.NTSB CHI00LA112Accident · Minor injuriesLimited investigationFinal reportNorth American T-28B · Kankakee, ILthe misjudged glidepath by the pilot. Factors were the failure of the impeller seal resulting in a total loss of engine oil and subsequent engine failure, the plowed farm field, and the lack of suitable terrain for the forced landing.NTSB CHI00LA109Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Sherwood, NDcarburetor ice and the pilot's improper decisions when to use carburetor heat and to perform a soft field landing. Factors relating to this accident were the improper use of carburetor heat, the soft field landing attempt, and the snow covered field.NTSB CHI00FA110Accident · Minor injuriesField investigationFinal reportHughes 369D · Lemont, ILthe loss of engine power for undetermined reasons. A factor was the operation within the cross "hatched area" of the helicopter's height/velocity curve by the company.NTSB LAX00LA143Accident · No injuriesLimited investigationFinal reportMuxlow Pitts S-1C · Phoenix, AZA loss of engine power for undetermined reasons. Factors were the lack of suitable terrain for a forced landing and the rough/uneven terrain on which the airplane landed.NTSB FTW00LA117Accident · 2 fatalLimited investigationFinal reportJohnson Zodiac CH-601-HDS · Orange, TXthe inadvertent stall while maneuvering. A contributing factor was the loss of engine power for an undetermined reason.NTSB MIA00LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Murfreesboro, TNA loss of engine power during takeoff climb for undetermined reasons resulting in an attempted emergency landing to unsuitable terrain and collision with a tree and transmission wires.NTSB CHI00LA105Accident · Minor injuriesLimited investigationFinal reportWeinzierl Titan Tornado II · Maple Plain, MNthe obstructed fuel system filter, the inadequate silicone material the builder used, and the rough and uneven terrain. A factor was that suitable landing terrain was not available.NTSB CHI00LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Pine City, MNA loss of engine power due to the failure of the number four cylinder's exhaust valve spring and exhaust valve. Contributing to the accident were, the barbwire fence and the clump of high vegetation encountered by the airplane.NTSB FTW00LA115Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Addison, TXThe loss of engine power for reasons undetermined. A factor was the lack of suitable terrain for the forced landing.