NTSB investigations
1,408 cases where the first occurrence was “Loss of engine power(partial) - mech failure/malf”.
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\" = 352) 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" = 352) 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 MIA92FA099Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Aberdeen, MSThe pilot-in-command's decision to initiate a turn back to the airport at a low altitude following loss of engine power.NTSB FTW92LA096Accident · Minor injuriesLimited investigationFinal reportBurnett Teenie II · Edmond, OKPartial engine power loss due to cylinder failure. A factor was the lack of suitable terrain for the forced landing.NTSB LAX92LA124Accident · Minor injuriesLimited investigationFinal reportCessna 150 · San Jose, CAThat the certified flight instructor's (CFI) misjudged approach which resulted in a long landing, the cfi's in-flight decision to a go-around with partial power, and the failure of the CFI to maintain aircraft control in the initial climb segment of the…NTSB MIA92LA082Accident · No injuriesLimited investigationFinal reportBurch Rotorway Exec · Lakeland, FLThe pilot-in-command's improper application of cyclic and collective pitch control during an autorotative landing. This resulted in a hard landing, collision of the main rotor blades with the tailboom, and subsequent roll over of the helicopter. Contributing…NTSB FTW92LA056Accident · No injuriesLimited investigationFinal reportCessna 205A · Spring, TXThe partial power loss due to cylinder fatigue and resultant engine vibrations. Factors were the oil covered windshield restricting the pilot's vision and the wet terrain.NTSB LAX92FA092Accident · 2 fatalField investigationFinal reportCessna T210L · Temple Bar, AZFatigue failure of the turbocharger's turbine shaft due to inadequate maintenance, and the pilot's improper in-flight planning/decision after experiencing a turbocharger failure. A factor related to the accident was: the lack of information in the pilot…NTSB LAX92LA080Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Fresno, CAThe improper major repair of the carburetor heat control by unidentified persons that resulted the failure of the air intake distribution system and the loss of engine power.NTSB DEN92LA017Accident · Minor injuriesLimited investigationFinal reportStinson 108-1 · Longmont, COA loss of engine power due to fouled spark plugs. The inadequate maintenance of the engine was a factor in the accident.NTSB CHI92LA052Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Carlyle, ILFuel contamination and blockage of the carburetor, which restuled in fuel starvation. The high obstructions (trees) were a related factor.NTSB MIA92LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lawrenceville, GAThe separation of numbers 1,2, and 3 connecting rods for undetermined reasons resulting in loss of engine power.NTSB MIA92LA033Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1C · Lantana, FLThe improper maintenance assembly and inspection of the throttle linkage which resulted in the throttle linkage becoming disconnected in flight and subsequent loss of engine power.NTSB LAX92LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Maricopa, AZThe cfi's inadequate supervision and his delayed remedial action. A factor was carburetor icing conditions.NTSB LAX92LA020Accident · No injuriesLimited investigationFinal reportPiper PA28-161 · Chandler, AZAn engine malfunction produced by exhaust valves stuck in the open position. Contributing to the accident was an unsuitable landing area and a sign adjacent to the landing area.NTSB SEA92LA006Accident · Minor injuriesLimited investigationFinal reportCessna C-150M · Woodburn, ORA seized engine exhaust valve. Factors include rough terrain and a collapsed nose gear.NTSB CHI92LA002Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Roscoe, ILOperation of an aircraft with known deficiencies and deterioration/failure of the magneto(s). Factors related to the accident were: the lack of an annual inspection and non-compliance with an airworthiness directive (AD).NTSB NYC91LA249Accident · No injuriesLimited investigationFinal reportDavis D1K · Chester, CTImproper maintenance on the engine which resulted in a power loss due to a stuck exhaust valve and subsequent forced landing in unsuitable terrain.NTSB LAX91LA413Accident · Minor injuriesLimited investigationFinal reportGrumman G164A-450 · Queen Creek, AZFailure of the engine cylinder, producing a loss of power. Contributing to the accident was the location of an irrigation ditch next to the landing area and a dark night light condition.NTSB SEA91LA249Accident · No injuriesLimited investigationFinal reportCessna 177 · Snohomish, WAThe separation of the mixture control cable (core) resulting from separation of the adel clamp assembly and improper adjustment by maintenance personnel.NTSB NYC91FA246Accident · 2 fatalField investigationFinal reportCessna 172P · West Chicago, ILThe pilot's improper in-flight decision to return to the airport following a loss of engine power at a low altitude. The pilot failed to maintain airspeed which resulted in an inadvertent stall at an altitude insufficient for recovery. Factors contributing to…NTSB LAX91LA389Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Hesperia, CAA stuck exhaust valve due to the operator's non compliance with a manufacturers recommended service bulletin on the engine. Contributing to the accident was the lack of suitable terrain for a safe landing.NTSB SEA91LA231Accident · No injuriesLimited investigationFinal reportCessna 310F · Corvallis, ORA disconnected air induction line, and the pilot's inflight decision to execute a 180 degree turn back to the airport. His lack of experience in multi-engine aircraft, his overall lack of familiarity and lack of recent experience in the type aircraft were…NTSB ATL91LA164Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-160 · Stockbridge, GAThe pilot's failure to maintain flying speed after experiencing a partial loss of engine power. Factors in this accident were, loose carburetors, annual inspection not performed, and pilot's lack of recent experience.NTSB LAX91LA374Accident · No injuriesLimited investigationFinal reportPiper PA32R · San Diego, CAThe pilot operating the aircraft with a known engine discrepancy that would cause the engine to lose power due to restriction to the exhaust system.NTSB CHI91LA267Accident · No injuriesLimited investigationFinal reportCessna 150M · Old Monroe, MOThe separation of the throttle control cable. Contributing to the accident was the rough terrain on which a forced landing was made.NTSB DEN91LA112Accident · No injuriesLimited investigationFinal reportLars Avid Flyer · Colorado Spring, COThe pilot's delay in flaring the airplane. Factors were: (1) stuck piston rings and (2) the pilot's failure to use flaps.NTSB CHI91DER13Accident · No injuriesFinal reportBell 47G-3B-1 · Maple Grove, MNThe pilot's failure to maintain directional control of the helicopter during the forced landing. Related factors are the loss of engine power, loss of rotor RPM, the eroded compressor blades, the pilot's operation with known deficiencies in equipment and…NTSB BFO91LA074Accident · Minor injuriesLimited investigationFinal reportClifton Dixon Polliwagen · Chesterfield, VAThe partial loss of engine power caused by a misaligned rocker arm spring resulting in a reduction of exhaust valve opening.NTSB DEN91LA105Accident · Minor injuriesLimited investigationFinal reportFink, Charles H. FIN-1 · Albuquerque, NMA failure of the throttle system which prevented the pilot from achieving sufficient power to maintain flight. A factor was: the rough terrain.NTSB CHI91DEP11Accident · Serious injuriesFinal reportEnglish Pietenpol Aircamper · Brodhead, WIErosion of an exhaust valve.NTSB LAX91LA320Accident · No injuriesLimited investigationFinal reportSikorsky SK-58 · Daggett, CAThe failure of an engine connecting rod causing a reduction of engine power to the point where level flight could not be maintained. A factor in the accident was the dark night conditions which restricted the pilot's ability to select the best landing site.NTSB SEA91LA190Accident · Minor injuriesLimited investigationFinal reportFleet FL-80 · Havre, MTThe engine driven fuel injection pump metering valve shaft was loose. A factor to the accident was: inadequate annual inspection.NTSB LAX91LA323Accident · No injuriesLimited investigationFinal reportCessna C-172P · Hesperia, CAA stuck engine throttle due to improper maintenance procedures.NTSB ATL91LA125Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Myrtle Beach, SCThe failure of the number 4 cylinder exhaust valve. Factors in the accident were the lack of a suitable landing site and the water ditching.NTSB ANC91LA095Accident · No injuriesLimited investigationFinal reportCessna 150L · Fairbanks, AKThe partial loss of engine power resulting in a forced landing on unsuitable terrain and subsequent nose over during the landing roll. Contributing to the accident was the improperly performed 100 hour inspection by company maintenance personnel.NTSB ANC91LA096Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-2 · King Salmon, AKThe forced landing on the rough terrain and the engine power loss due to the failure of the engine collector intermediate bearings.NTSB LAX91FA282Accident · 6 fatalField investigationFinal reportBeech 65 · Pioneer, CAImproper emergency procedures by the pilot, when he inadvertently shut down the left engine after encountering a partial loss of power in the right engine. Factors related to the accident were: improper installation of the right engine's #6 exhaust valve seat…NTSB SEA91LA139Accident · Minor injuriesLimited investigationFinal reportCessna 180G · Challis, IDThat the pilot encountered unsuitable terrain during a forced landing after a power loss due to a fractured cylinder boss and a bent engine pushrod.NTSB FTW91LA106Accident · Minor injuriesLimited investigationFinal reportRockwell 112TC · Ovilla, TXThe mechanical failure of the turbocharger. Factors were the inadequate annual inspection and the pilot's improper flare in the forced landing.NTSB LAX91LA265Accident · Minor injuriesLimited investigationFinal reportGlasair SH-2-RG · Visalia, CATotal loss of engine power due to the failure of the number 4 engine exhaust valve.NTSB MIA91LA163Accident · No injuriesLimited investigationFinal reportAir Tractor 301 · Greenville, MSLoss of engine power due to a cracked cylinder and the pilot's inadvertent stall.NTSB LAX91LA255Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Thermal, CAThe partial failure of the engine/powerplant from a worn intake valve and the failure of company/operator management to perform an overhaul on the engine within the time frame recommended by the engine manufacturer.NTSB SEA91LA128Accident · No injuriesLimited investigationFinal reportEnstrom F280C · Baggs, WYExhaust valve failure, resulting in a partial power loss. Contributing factors were low altitude and rough/uneven terrain.NTSB NYC91IA137Incident · No injuriesIncident investigationFinal reportBoeing 727-214 · Boston, MAThe failure of the third stage turbine blade on the number two engine, due to high cycle fatigue.NTSB MIA91LA158Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · High Springs, FLLoss of engine power due to disintegration of the impeller caused by a worn impeller bearing.NTSB FTW91DPG12Accident · Minor injuriesFinal reportBell 47-G3B1 · Colt, ARLoss of engine power for an undetermined reason. A factor was the unsuitable terrain.NTSB LAX91LA229Accident · No injuriesLimited investigationFinal reportGlaser-Dirks DG-500M · Minden, NVAn engine failure produced as a result of the pilot improperly adjusting the carburetor mixture jet.NTSB CHI91LA161Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Mankato, MNPartial loss of engine power due to an unlocked engine primer. Factors related to the accident were that the pre takeoff check list was not followed by the pilot and the lack of suitable terrain for the forced landing.NTSB FTW91FA081Accident · 2 fatalField investigationFinal reportCessna 150J · Caney, OKBinding of the #2 exhaust valve (stuck valve), and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall. A factor related to the accident was: the failed exhaust manifold gasket.NTSB ATL91LA095Accident · No injuriesLimited investigationFinal reportBeech 55 · Perry, GAImproper in-flight planning/decision by the pilot in command (CFI). The improper procedure of turning the fuel selector valve to 'off' at altitude to simulate a failed engine, then delaying restarting of the engine until the aircraft was on final approach was…NTSB MIA91FA140Accident · 2 fatalField investigationFinal reportMcdonnell Douglas DC-3C · Aguadilla, PRThe pilot in command's failure to maintain airspeed (vs) after a partial loss of engine power on the left engine due to failure of the no. 8 engine assembly cylinder. This resulted in an in flight loss of control (stall), and in flight collision with terrain.