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 FTW91DRA02Accident · Serious injuriesFinal reportW. R. Mathis Midget Mustang · Nacogdoches, TXPower loss due to engine starter failure for undetermined reasons.NTSB DEN91LA066Accident · Minor injuriesLimited investigationFinal reportCessna 421 · Englewood, COPower loss on both engines as a result of exhaust system failure.NTSB LAX91LA188Accident · Serious injuriesLimited investigationFinal reportEnstrom F28C · Palm Springs, CAInadequate inspection of the fuel system resulting in an engine power loss and inflight fire due to a loose fuel connection.NTSB NYC91DNA02Accident · Minor injuriesFinal reportBell 47-G3B1 · Harwich, MAA failure of the clutch during takeoff due to improper maintenance procedures. Factors related to the accident were insufficient altitude to establish an autorotation.NTSB CHI91DCG02Accident · Serious injuriesFinal reportHuff Pulsar · Missouri City, MOOil fouled spark plugs resulting in a partial loss of engine power. Soft terrain in the forced landing area was a factor.NTSB NYC91LA104Accident · Minor injuriesLimited investigationFinal reportPiper J-4A · Mahopac, NYThe erratic performance of the left magneto resulting in inadequate climb capabilities and in flight collision with terrain.NTSB FTW91DPG03Accident · No injuriesFinal reportGrumman G-164A · Earle, ARA power loss for undetrmined reasons. A factor was the muddy/soft terrain in which the forced landing was performed.NTSB NYC91LA094Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Milleville, NJThe total loss of engine power caused by mechanical failure, which resulted in the pilot landing the airplane on unsuitable terrain.NTSB FTW91LA056Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Floresville, TXThe failure of the engine due to a jammed valve, incorrect maintenance procedures, and the pilot's improper compensation for the existing wind conditions. A factor was the tailwind.NTSB BFO91LA033Accident · No injuriesLimited investigationFinal reportCessna 172 · Hagerstown, MDWorn camshaft lobes which resulted in the loss of engine power.NTSB DEN91LA053Accident · Serious injuriesLimited investigationFinal reportRockwell 112B · Nederland, CODeteriorated ignition harness and ignition lead arcing. Factors were the high density altitude and lack of suitable terrain for the forced landing.NTSB SEA91LA067Accident · No injuriesLimited investigationFinal reportClyde L. King Osprey II · Aurora, ORA loss of engine power due to fuel starvation because of an inadequate component and inadequate fuel system design.NTSB LAX91LA129Accident · Serious injuriesLimited investigationFinal reportCessna 421B · Tucson, AZThe fatigue failure of the right engine turbo exhaust clamp, and, the failure of the flying pilot to complete the single engine emergency procedures in a timely manner. A factor in the accident was the failure of the pilot in command to adequately supervise…NTSB BFO91LA030Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Hagerstown, MDThe failure of the throttle control cable. A factor ws the rough terrain.NTSB ANC91LA026Accident · Minor injuriesLimited investigationFinal reportMBB BO-105-CBS-4 · Valdez, AKWas the pilot-in-command's failure to properly use the approval checklist, improper procedures and directives.NTSB ATL91IA050Incident · No injuriesIncident investigationFinal reportPiper PA-60-600 · Cochran, GAFailure of the right engine shutoff valve which resulted in a complete loss of engine power. The airplane veered off the right side of the runway and the right main landing gear collapsed as a result of the pilots failure to maintain directional control…NTSB ATL91LA049Accident · No injuriesLimited investigationFinal reportBeech V35B · Advance, NCThe pilot's diverted attention and failure to maintain directional control during the takeoff. A factor was the malfunctioning magneto which resulted in the engine sputter.NTSB LAX91LA085Accident · Minor injuriesLimited investigationFinal reportPiper PA 32-300 · Anaheim, CAMaintenance personnel in that they improperly adjusted the left magneto which resulted in the complete erosion of the electrodes from six of the twelve installed spark plugs. The installation of spark plugs with colder heat ranges than specified by the…NTSB MIA91IA061Incident · No injuriesIncident investigationFinal reportCessna 210M · Lutz, FLFuel line chafing, and in-flight fire caused by shorting of the electrical system which resulted in a forced landing with the landing gear not extended.NTSB FTW91FA025Accident · 1 fatalField investigationFinal reportPiper PA28-181 · Olla, LAThe collapsed carburetor float and restricted movement of the fuel metering needle. Factors were the darknight, the unsuitable terrain, and the operator's maintenance personnel failure to inspect (repair) the engine.NTSB DEN91LA025Accident · No injuriesLimited investigationFinal reportGrumman AA1B · Roswell, NMLow cylinder compression and fouled spark plug.NTSB MIA91LA043Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Jupiter, FLPartial loss of engine power due to failure of an exhaust valve, due to a valve guide that was worn beyond specifications.NTSB LAX91FA052Accident · Minor injuriesField investigationFinal reportde Havilland DHC-6-100 · Perris Valley, CAA loss of power on the left engine due to a fatigue failure of a compressor turbine blade leading to further compressor blade damage; a worn power turbine governor throttle cam assembly which led to loss of power on the right engine; and inadequate…NTSB NYC91LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Atlantic City, NJThe failure of the pilot to abort the takeoff in sufficient time to prevent an overrun. Factors related to the accident were a partial power loss due to a faulty ignition system.NTSB LAX91LA033Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Tuba City, AZFailure of the piston rings which reduced the available engine power, and the pilot's continued operation of his airplane with a known engine deficiency during the relatively high density altitude conditions.NTSB NYC91DNE01Accident · No injuriesFinal reportCraig A. Gordon Teenie TWO · Oxford, CTThe failure of the pilot to maintain airspeed which resulted in an inadvertent stall and hard landing. Factors related to the accident were: the power loss and improper maintenance on the engine.NTSB LAX91DUJ03Accident · No injuriesFinal reportAir Tractor AT-302 · Somerton, AZThe failure of the number 3 exhaust valve which led to an engine failure and subsequent crash landing.NTSB MIA91FA020Accident · 2 fatalField investigationFinal reportAero Commander 680V · Fort Lauderdale, FLThe pilot-in-command's decision to continue takeoff with a known deficiency in the airplane - low power on both engines which resulted from open compressor surge valves. The pilot subsequently failed to maintain airspeed while maneuvering in a turn resulting…NTSB MIA91FA017Accident · 1 fatalField investigationFinal reportCessna 150G · Marathon, FLThe pilot-in-command's failure to maintain airspeed, while attempting to make a forced landing following a partial loss of engine power. Fatigue failure of the center rocker boss on the #3 cylinder was a related factor.NTSB MIA91LA010Accident · No injuriesLimited investigationFinal reportAmerican AA-5 · Cape Coral, FLA partial loss of engine power, caused by mechanical failure of the number 3 cylinder engine exhaust valve, for an undetermined reason.NTSB NYC91FA006Accident · 2 fatalField investigationFinal reportCessna 152 · Griswold, CTA broken ehaust valve spring that resulted in a partial loss of power. Factors related to the accident were: darkness, lack of suitable terrain, and failure of the occupants to use their shoulder harnesses.NTSB MIA91FA008Accident · Serious injuriesField investigationFinal reportMooney M20C · Kissimmee, FLMalfunction of both magnetos due to deterioration of the coils, failure of maintenance personnel to comply with an airworthiness directive, and failure of the pilot to maintain adequate visual lookout while on an approach for an emergency landing. Factors…NTSB FTW91FA002Accident · 1 fatalField investigationFinal reportEnstrom F28-C · Mesquite, TXInstallation error of company maintenance personnel. Factors were the unsuitable terrain, the tailwind, the inability of the pilot to maintain main rotor RPM, and the inadequate annual inspection by company maintenance personnel.NTSB NYC91LA003Accident · No injuriesLimited investigationFinal reportCessna A150M · Lincoln, RIOn ground collision with a tree while making a forced landing following loss of engine power due to a failed exhaust valve.NTSB MIA91LA006Accident · No injuriesLimited investigationFinal reportCessna 150M · Tampa, FLThe pilot's decision to fly an airplane with known deficiencies. This resulted in a partial loss of engine power, and a ground collision with a fixed object.NTSB SEA90FA197Accident · 2 fatalField investigationFinal reportPiper PA-24-260 · Bend, ORAn engine power loss due to fuel starvation as a result of a broken seal in the fuel injector servo. In addition, the pilot misjudged his approach into an open field.NTSB NYC90LA228Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Franconia, NHThe landing of the airplane in unsuitable terrain, due to the mechanical failure of the engine center muffler baffle, which blocked the exhaust flow, resulting in a loss of power.NTSB ATL90LA174Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · Palmetto, GAThe number two cylinder exhaust valve sticking in the closed position, which resulted in a partial power loss during the takeoff. A factor in the accident was the pilot's improper preflight inspection, in that he did not correctly analyze the engine problem…NTSB CHI90LA267Accident · No injuriesLimited investigationFinal reportCessna 182 · Troy, MIA loss of engine power due to failure of the rocker arm bosses on the #2 cylinder.NTSB MIA90LA182Accident · No injuriesLimited investigationFinal reportHiller OH-23C · Fort Pierce, FLLoss of engine power due to separation of the packing seal which seals the distribution zone pipe to the inlet manifold, for undetermined reasons resulting in a hard landing.NTSB FTW90FA177Accident · Serious injuriesField investigationFinal reportPiper PA-32RT-300T · Addison, TXFatigue failure of the throttle cable. Factors related to the accident were: darkness and objects (fence and utility poles) in the emergency landing area.NTSB LAX90FA311Accident · 1 fatalField investigationFinal reportCessna 411 · Fallon, NVFailure of the pilot to perform emergency procedures for loss of engine power (including his failure to feather the propeller of the affected engine). Factors related to the accident were: inadequate maintenance, contamination in the fuel system, and overheat…NTSB FTW90DPG13Accident · No injuriesFinal reportGrumman G-164A · Luxora, ARA partial power loss due to failure of the number five connecting rod. A factor was the soft terrain in which the forced landing was made.NTSB LAX90DVD03Accident · No injuriesFinal reportTexas Helicopter M47A Wasp · Stockton, CAThe pilot misjudged the altitude during the flare/touchdown phase of the autorotation. Factors relating to this accident are failure of the right magneto.NTSB ATL90LA161Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Palmetto, GAThe pilot's operation of the airplane with known mechanical deficiencies. A factor in the accident was the improperly maintained condition of the magnetos.NTSB FTW90MA161Accident · 3 fatalMajor investigationFinal reportGrumman G-159 · Houston, TXPartial failure of the left engine fuel pump, which resulted in a partial loss of power in the left engine, but not enough of a power loss to trigger and/or complete the autofeathering operation of the left propeller, thus allowing insufficient time for the…NTSB CHI90FA233Accident · No injuriesField investigationFinal reportPiper PA-23-160 · Odell, ILA loss of left engine power due to oil accumulation in the right magneto and a non-usable spark lead from the left magneto. In addition, the right engine was unable to provide adequate power to maintain altitude due to a partial blockage in the carburetor by…NTSB ATL90LA159Accident · No injuriesLimited investigationFinal reportCessna 172 · Ridge Spring, SCThe failure of the maintenance facility/owner to follow standard preventive maintenance procedures. A factor was the pilot's failure to extend the flaps during the forced landing.NTSB LAX90DVD01Accident · Serious injuriesFinal reportConvair L-13A · Hayward, CAAbsence of a oil system fitting cap.NTSB ATL90LA155Accident · No injuriesLimited investigationFinal reportCessna 172L · Greensboro, ALThe pilot's failure to maintain proper airspeed and attain the proper touchdown point during the emergency landing.