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 FTW93LA116Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Fort Worth, TXPartial power loss due to improper maintenance and resultant discrepancies. A factor was the lack of suitable terrain.NTSB NYC93FA066Accident · 6 fatalField investigationFinal reportPiper PA-23-250 · Elmwood Park, NJInadequate maintenance and inspection of the fuel injector system resulting in a loss of power of the left engine, and the failure of the pilot to maintain minimum control speed which resulted in a flat spin. A factor which contributed to the accident was the…NTSB SEA93LA078Accident · No injuriesLimited investigationFinal reportSchweizer G-164B-600 · Quincy, WAUnsuitable terrain encountered during a forced landing after an engine cylinder assembly had separated. Factors include a snowbank.NTSB LAX93LA150Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Gila Bend, AZThe failure of maintenance personnel to perform mandatory service bulletins during the annual inspection 20 flying hours prior to the accident which resulted in the carburetor's primary venturi becoming loose.NTSB LAX93FA141Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Big Bear City, CAA partial loss of takeoff power due to inadequate maintenance and inspection which failed to detect magneto and spark plug deficiencies. In addition, the pilot failed to abort the takeoff after two unsuccessful attempts to get airborne. Factors which…NTSB LAX93LA117Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Hughson, CAThe failure of the intake valve. The soft terrain contributed to this accident.NTSB ANC93LA029Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Port Heiden, AKThe failure of the number 3 cylinder intake valve stem. A factor in the degree of damage the aircraft sustained in the mishap was attributable to the off airport emergency landing on show covered tundra.NTSB MIA93LA054Accident · Minor injuriesLimited investigationFinal reportNorth American T-28A · Plantation, FLFailure of the master rod main bearing which resulted in loss of engine power and a subsequent forced landing.NTSB FTW93LA074Accident · No injuriesLimited investigationFinal reportCessna 172M · Baytown, TXThe loss of power due to a stuck exhaust valve in the number 3 cylinderNTSB LAX93LA076Accident · Minor injuriesLimited investigationFinal reportCurtiss JN-4D · Livermore, CAThe shearing of the number 8 cylinder rocker arm support pedestal/coolant housing retaining bolts. Contributing to the accident was a loss of engine coolant.NTSB ATL93LA033Accident · Minor injuriesLimited investigationFinal reportKaman HH43F · Columbia, SCThe deterioration of the engine fuel shutoff solenoid valve which failed in the closed position.NTSB BFO93LA010Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Willimantic, CTA cracked no. 2 engine cylinder, and the pilot's failure to attain the proper touchdown point during the forced landing, due to excessive airspeed, which resulted in an overrun of the runway. A factor related to the accident was an improper weld repair on the…NTSB LAX93LA040Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Williams, AZThe partial loss of engine power due to a stuck exhaust valve on the number two cylinder and the pilot's inability to climb the aircraft above the trees surrounding the airport. A factor in the accident was the effects of the high density altitude on the…NTSB CHI93FA028Accident · Minor injuriesField investigationFinal reportSmith, Ted Aerostar Aerostar 601 · Wahpeton, NDOther maintenance personnel's improper maintenance (installation).NTSB FTW93LA025Accident · No injuriesLimited investigationFinal reportCessna 180 · Lubbock, TXThe partial power loss due to a disconnected throttle cable. A factor was the lack of suitable terrain at the pilot's disposal.NTSB CHI93LA016Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Ludington, MIThe partial loss of engine power during the initial climb out on a night flight.NTSB CHI93DTG01Accident · No injuriesFinal reportKing BOWERS-FLYBABY · Buffalo, NDPartial loss of engine power due to improper installation of the carburetor, by the pilot/owner.NTSB LAX92LA395Accident · Minor injuriesLimited investigationFinal reportAbrams/Nuding Quickie Q2 · Minden, NVFuel starvation for undetermined reasons. A factor in the accident was the unsuitable nature of the terrain for the forced landing attempt.NTSB CHI92FA282Accident · 1 fatalField investigationFinal reportCessna 152 · Ottawa, ILPilot did not maintain a proper airspeed which led to an inadvertent stall/spin at a low altitude where the pilot could not perform a recovery.NTSB DEN92LA092Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Greeley, COTotal loss of engine power due to a deteriorated carburetor float which resulted in engine flooding. A factor was: unsuitable terrain for a forced landing.NTSB CHI92LA277Accident · No injuriesLimited investigationFinal reportCessna 172N · Geneseo, ILThe pilot's attempted operation of the airplane with a known defficiency in the equipment.NTSB ANC92LA152Accident · Serious injuriesLimited investigationFinal reportCessna 206 · Fort Yukon, AKFatigue failure of an engine cylinder precipitated by the pilot-in-command intentionally exceeding the engine performance ratings in order to sustain flight in the grossly overweight condition. A factor contributing to the accident was the high grass. A…NTSB MIA92LA169Accident · No injuriesLimited investigationFinal reportCessna 425 · Greenwood, MSFailure of the pilot-in-command to maintain his descent rate resulting in an undershoot. Contributing to the accident was the chip detector failure due to improper quality control by the manufacturer.NTSB ATL92LA166Accident · No injuriesLimited investigationFinal reportSikorsky UH-19D · St. Augustine, FLThe failure of the engine's exhaust valve rocker arm.NTSB CHI92DEM05Accident · Serious injuriesFinal reportTaylorcraft H-2 · Holland, MINot maintaining a sufficient airspeed during the reversal turn and encountering a stall/spin maneuver.NTSB FTW92IA208Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-88 · Dfw Airport, TXThe loss of engine power due to the fracture of a fan blade resulting from a manufacturing defect.NTSB CHI92DTG04Accident · No injuriesFinal reportGrumman G-164B · Grandin, NDThe cracked cylinder which resulted in a forced landing. The lack of suitable terrain on which to make an emergency landing was a factor.NTSB MIA92LA160Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Redwood, MSImproper maintenance of the airplane by an unknown person.NTSB FTW92LA207Accident · No injuriesLimited investigationFinal reportCessna 152 · Killeen, TXLoss of engine power due to a fractured number three cylinder exhaust push rod assembly.NTSB LAX92LA328Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Burbank, CAThe binding and over temperature of an exhaust valve due to the lack of compliance with factory service instructions and bulletins regarding valve sticking by other maintenance personnel.NTSB CHI92LA222Accident · No injuriesLimited investigationFinal reportHughes 269C · Aurora, ILFatigue fracture of the engine crankshaft resulting in loss of power. Factors were the pilot's excessive descent and his lack of total experience.NTSB DEN92LA073Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Ft. Collins, COImproper rate of descent and lack of flare while conducting a forced landing. Factors were: partial power loss due to stuck exhaust valves caused by engine overheat from improper leaning.NTSB SEA92LA149Accident · No injuriesLimited investigationFinal reportCessna 172L · Delta, UTThe failure of an intake valve and the poorly executed forced landing.NTSB BFO92LA090Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Woodstock, CTThe loss of engine power due to a cracked cylinder and the inadvertent aerodynamic stall that occurred during the precuationary landing.NTSB NYC92LA127Accident · Serious injuriesLimited investigationFinal reportPiper PA-60-602P · Lancaster, PAThe failure of the left engine turbochargers bearings, which resulted in a loss of power and subsequent degradation of climb performance.NTSB CHI92LA179Accident · No injuriesLimited investigationFinal reportCessna 210B · Belleville, ILThe improper fuel pump high end discharge adjustment. A related factor is improper maintenance/annual inspection.NTSB CHI92LA167Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Wyatt, MOAn improper decision during flight when the pilot in command overflew two suitable landing areas after a partial power loss in one engine. The mechanical deficiencies in the engines were factors in the engine.NTSB CHI92LA162Accident · Serious injuriesLimited investigationFinal reportCommander C3C · Grain Valley, MOThe jammed (kinked) choke plate control cable, which resulted in reduced power and collision with rising terrain.NTSB LAX92LA233Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Fallbrook, CAThe loss of engine power due to a disconnection of the turbocharger inlet duct.NTSB NYC92DHA03Accident · Serious injuriesFinal reportParrish, Paul SKY Bolt · Mehoopany, PAThe pilot inadvertently stalled and spun the airplane at too low an altitude to allow recovery. Contributing to the accident was an engine vibration caused by a broken number 3 exhaust valve. The exhaust valve caused extensive internal damage to the engine.NTSB FTW92LA134Accident · No injuriesLimited investigationFinal reportAir Tractor AT-501 · Mooreland, OKThe failure of the number 3 cylinder for undetermined reasons. A factor was the lack of suitable terrain for the ensuing forced landing.NTSB BFO92FA058Accident · 3 fatalField investigationFinal reportCessna 177 · Lusby, MDA failure of the carburetor resulting in a loss of engine power.NTSB CHI92LA146Accident · No injuriesLimited investigationFinal reportCessna 150F · Eldon, MOA binding exhaust valve resulting in a partial loss of engine power. Factors in the accident are rising terrain conditions, inadequate aircraft climb capability, and a ditch in the forced landing area.NTSB CHI92LA139Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140D · Markham, ILThe result of an inadequate annual inspection by other maintenance personnel and, as a result, a total failure of the throttle linkage. A factor was the pilot overshot his intended emergency landing area, due to excessive speed.NTSB MIA92LA111Accident · Serious injuriesLimited investigationFinal reportBell UH-1B · La Belle, FLImproper preflight by the pilot-in-command, in his failure to identify a crack in a brazed area surrounding an attach point on the air diffuser. Contributing to the accident following the loss of engine power was obstacles that were ahead of the flight path.NTSB CHI92DEM01Accident · No injuriesFinal reportRose Wesley Rotorway WR Exec · Hudsonville, MIThe failure of an intake valve spring. Factors related to the accident were the low altitude at which the autorotation was initiated and the soft terrain on which the helicopter was landed.NTSB FTW92LA116Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Welsh, LAPartial power loss due to the cracked engine cylinder. A factor was the lack of suitable terrain for the forced landing.NTSB CHI92FA127Accident · 1 fatalField investigationFinal reportCessna 172P · Kellyville, OKAn inadvertent stall and misjudgement of an emergency procedure by the pilot in trying to stretch the forced landing approach to make it to the airstrip.NTSB ATL92LA071Accident · Minor injuriesLimited investigationFinal reportMooney M20D · Cumberland Is., GAThe loss of the spark plug at a critical point in flight which resulted from the inadequate overhaul of the engine by an unknown person; and the inadvertent stall of the airplane when the pilot failed to maintain airspeed. A factor was the high obstructions…NTSB MIA92LA098Accident · No injuriesLimited investigationFinal reportMooney M20K · St. Augustine, FLThe separation of the swage between the throttle outer housing and throttle cable resulting in loss of throttle control and the engine reducing to idle power.