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 CHI95LA081Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · St. Louis, MOA loss of engine power due to an excessive fuel mixture caused by undetermined reasons.NTSB ANC95LA029Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Akiak, AKThe partial loss of engine power due to an erratic spark plug.NTSB MIA95LA051Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lakeland, FLFatigue failure of the engine no.1 valve spring that jammed the intake valve open resulting in partial loss of engine power.NTSB LAX95LA064Accident · No injuriesLimited investigationFinal reportRockwell S2R Thrush Cmdr · Yuma, AZa forced landing due to an engine failure of the no.1 cylinder.NTSB CHI95LA058Accident · No injuriesLimited investigationFinal reportMooney M20K · Minneapolis, MNthe pilot's misjudging of distance and airspeed during the approach to landing which resulted in an overrun. Factors associated with the accident were the separation of the exhaust pipe and the pilot's not understanding communications from the air traffic…NTSB MIA95LA049Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tavares, FLThe failure of the no.3 connecting rod resulting in a loss of engine power. The lack of suitable terrain for a forced landing was a factor.NTSB MIA95LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · La Belle, FLPartial loss of engine power due to total failure of the no. 3 cylinder exhaust valve for undetermined reasons. Also, unsuitable terrain encountered during the forced landing.NTSB ATL95LA030Accident · No injuriesLimited investigationFinal reportCessna 150G · Rhine, GAThe failure of the number two cylinder rocker shaft bosses, which resulted in a loss of engine power, and an eventual emergency landing.NTSB MIA95LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Fajardo, PRThe malfunction of a magneto resulting in a partial loss of power over unsuitable terrain.NTSB LAX95LA022Accident · No injuriesLimited investigationFinal reportForney F-1 · Searchlight, NVthe pilot's failure to maintain directional control by improperly compensating for the existing wind conditions. The leaking cylinder, the prevailing crosswind, the soft terrain, and the dirt bank were factors in this accidentNTSB LAX95LA008Accident · Serious injuriesLimited investigationFinal reportRey Avid Flyer · Bakersfield, CAthe inadequate maintenance on the engine's liquid cooling system fittings and lines.NTSB CHI95LA008Accident · Minor injuriesLimited investigationFinal reportCessna T210R · Lakota, NDPartial loss of engine power due to preignition and/or detonation, which resulted in failure of the number 4 cylinder. The unfavorable tailwind for landing was a related factor.NTSB BFO95LA003Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Ebensburg, PAThe loss of partial engine power due to the failure of the right magneto's nylon gear on the rotating magnet and the low compression in the number three cylinder.NTSB FTW95FA003Accident · 2 fatalField investigationFinal reportCessna T210M · Richmond, UTThe loss of engine oil pressure due to an oil leak from a loose oil line fitting. Factors were the obscuration, and the unsuitable terrain at the pilot's disposal.NTSB MIA94LA218Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Greenwood, MSThe improper decision of the pilot to execute a precautionary landing to an unprepared field due to a supercharger shaft failure.NTSB SEA94LA242Accident · Minor injuriesLimited investigationFinal reportCessna P206D · Lopez, WAA worn throttle control lever.NTSB CHI94LA332Accident · No injuriesLimited investigationFinal reportCessna 170 · St. Anne, ILEngine failure due to an inadequately reconditioned cylinder.NTSB FTW94LA289Accident · Minor injuriesLimited investigationFinal reportCessna 182L · Ardmore, OKThe partial loss of power due to a cylinder head separation. Factors were the lack of suitable terrain for the forced landing and the low ceiling.NTSB ANC94LA129Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Tok, AKThe worn cam shaft lobe and worn valve lifter.NTSB FTW94FA282Accident · Minor injuriesField investigationFinal reportCessna 402 · Harlingen, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall. Factors were a partial loss of power on all engines due to worn and fouled spark plugs and inadequate maintenance by company maintenance personnel, aircraft weight beyond limitations,…NTSB BFO94LA155Accident · No injuriesLimited investigationFinal reportHughes 369D · Butler, PAThe malfunction of the emergency fuel vent and the exhaustion of the fuel supply which resulted in the loss of engine power.NTSB BFO94LA145Accident · No injuriesLimited investigationFinal reportMooney M-20B · Marion, OHInadequate maintenance which resulted in the throttle cable becoming disconnected from the carburetor.NTSB LAX94LA313Accident · No injuriesLimited investigationFinal reportSchweizer G-164-A · Laton, CAfailure of the No.7 cylinder for an unspecified reason.NTSB LAX94FA317Accident · No injuriesField investigationFinal reportAerospatiale AS350-D · Kukuihaele, HIa fatigue crack in the 'T' fitting on the power turbine governor pneumatic accumulator. A factor was the rough, rock-covered landing area.NTSB ATL94LA150Accident · No injuriesLimited investigationFinal reportCessna 150J · Waxhaw, NCA loss of engine power due to a stuck, and worn, exhaust valve, and the inadequate inspection of the engine by other maintenance personnel. A factor was the trees at the forced landing area.NTSB MIA94LA188Accident · Minor injuriesLimited investigationFinal reportPiper J5C · Yazoo City, MSPartial blockage of the carburetor by a wasp nest, which was not visible during preflight, and which resulted in the loss of power.NTSB LAX94LA298Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1B · Corona, CAAn undetermined partial loss of engine power.NTSB CHI94LA243Accident · Serious injuriesLimited investigationFinal reportInman Acro Sport 1 · Albert Lea, MNthe pilot's failure to make a precautionary landing on the remaining runway. Factors in the accident were the blocked fuel injector and inadvertent stall.NTSB CHI94LA242Accident · No injuriesLimited investigationFinal reportGrumman FM-2 · Woodburn, INthe total failure of the throttle linkage arm.NTSB FTW94LA238Accident · Serious injuriesLimited investigationFinal reportRockwell S-2R · Winchester, ARThe loss of power due to the number one cylinder head cracking. A factor was the lack of suitable terrain for the forced landing.NTSB MIA94LA177Accident · No injuriesLimited investigationFinal reportCessna 172M · Tampa, FLThe pilot-in-command's improper approach during a forced landing following partial loss of engine power. The loss of engine power was a factor.NTSB ATL94LA133Accident · Minor injuriesLimited investigationFinal reportPilatus PC-6/B1-H2 · Raeford, NCThe improper inspection of the aircraft by company maintenance personnel, which resulted in an unsafetied and disconnected fuel control arm.NTSB CHI94DCJ02Accident · Minor injuriesFinal reportMueller Q2 · Utica, NEThe failure of the carburetor float valve. A related factor is the high vegetation at the landing site.NTSB LAX94LA260Accident · No injuriesLimited investigationFinal reportMooney M20J · Big Bear, CAa loss of engine power from a malfunctioning magneto due to a loose oil seal in an overhauled magneto.NTSB FTW94GA204Accident · Minor injuriesFinal reportHughes 269C · London, TXThe partial power loss due to a sticking valve. Factors were the remaining worn lobes on the camshaft and the lack of suitable terrain onto which a successful forced landing could be executed.NTSB MIA94LA159Accident · 1 fatalLimited investigationFinal reportHruby Cayuse · Bay St. Louis, MSThe pilot-in-command's attempt to continue the takeoff when the engine was not producing full power and his attempt to reverse course to return to the airport without sufficient altitude to complete the turn.NTSB SEA94LA138Accident · No injuriesLimited investigationFinal reportSiai-Marchetti SF.260B · Prospect, ORThe fracture of a connecting rod. Factors include no suitable forced landing site, and a fence and irrigation system in the field where the forced landing took place.NTSB SEA94LA143Accident · No injuriesLimited investigationFinal reportWray KR-2 · Puyallup, WAAn improperly functioning fuel boost pump.NTSB LAX94LA225Accident · Serious injuriesLimited investigationFinal reportStaudacher 300S · Chandler, AZThe operation of the engine at an RPM setting that exceeded the original design specifications and resulted in the failure of the no. 5 connecting rod bearing.NTSB SEA94LA120Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Rio Linda, CAThe pilot's improper mixture leaning procedure. Factor(s) were: the disconnected ignition lead, dark night conditions, unsuitable terrain and the fence.NTSB NYC94FA082Accident · 2 fatalField investigationFinal reportMooney M20K · Swanton, OHFailure of an engine cylinder which resulted in the loss of engine power and the pilot's failure to establish the proper descent path to an airport that was within the glide distance of the airplane. A factor was the overgross weight condition of the airplane.NTSB CHI94LA156Accident · No injuriesLimited investigationFinal reportCessna 150F · Chippewa Falls, WIthe loss of engine power due to a binding carburetor heat door.NTSB FTW94LA145Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · El Campo, TXThe partial loss of engine power due to one magneto being weak and the other magneto arcing inside its case. A factor was the lack of suitable terrain for the forced landing.NTSB LAX94FA211Accident · 1 fatalField investigationFinal reportAero Commander 100 · Ocotillo Wells, CAthe failure of the pilot to maintain flying speed after experiencing a partial power failure while maneuvering. A factor in the accident was the failure of the pilot to drain accumulated water from the aircraft fuel system during the preflight inspection.NTSB MIA94LA127Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Bushnell, FLThe pilot-in-command's improper landing flare during a forced landing, resulting in a hard landing and separation of the right main landing gear. Contributing to the accident was a partial loss of engine power due to a loose exhaust valve seat on the No. 3…NTSB LAX94LA189Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hesperia, CALoss of engine power due to an air leak at the gascolator gasket, which was improperly installed during maintenance. Darkness was a related factor.NTSB NYC94LA074Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · White Plains, NYThe partial loss of engine power as the result of a disconnected throttle cable, and the subsequent forced landing and ditching in water to avoid collision with trees.NTSB FTW94LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · San Angelo, TXThe partial loss of engine power. A factor was the lack of suitable terrain.NTSB ANC94IA049Incident · Minor injuriesIncident investigationFinal reportCessna 207 · Anchorage, AKThe partial failure of the no. 4 piston from over temperature (detonation).NTSB MIA94LA103Accident · No injuriesLimited investigationFinal reportCessna 172RG · Boca Raton, FLThe failure of the aircraft operator to comply with engine manufacturers service bulletins which resulted in improper inspection of exhaust valves and subsequent sticking of the no. 4 exhaust valve.