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 CHI90DEV08Accident · Minor injuriesFinal reportHilvety Cwii · Moweaqua, ILThe pilot's failure to maintain flying speed and stalling the airplane while attempting to reverse course for a forced landing. Contributing to the accident was the pilot's failure to properly reinstall spark plug cables during servicing conducted prior to…NTSB ATL90LA151Accident · Minor injuriesLimited investigationFinal reportCessna 172B · Midway, TNTotal failure of the number four exhaust valve, resulting in engine power loss and the subsequent forced landing of the airplane.NTSB FTW90DPG06Accident · No injuriesFinal reportWSK PZL Mielec M18A · Hunter, ARLoss of part of the engine exhaust collector, as result of improper maintenance replacement/installation.NTSB ATL90DKJ07Accident · Serious injuriesFinal reportBell-Continental Copters 47G · Clayhatchee, ALFailure of the engine magneto(s). The lack of suitable terrain (trees) in the emergency landing area was a related factor.NTSB LAX90LA263Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Clarksburg, CAThe failure of the airplane's muffler during initial climb.NTSB LAX90LA259Accident · No injuriesLimited investigationFinal reportCessna 421C · Lancaster, CAThe accident was eroded ignition spark plug electrodes and maintenance personnel neglecting to adjust spark plug electrodes and maintenance personnel neglecting to adjust spark plug gap. The rough terrain in which the aircraft landed was a factor in the…NTSB DEN90LA164Accident · No injuriesLimited investigationFinal reportMooney M20F · Torrington, WYA partial loss of power due to a failed exhaust valve. A factor was the lack of suitable terrain for the forced landing.NTSB CHI90DEP07Accident · No injuriesFinal reportBell 47-G2 · Hatley, WIThe partial loss of power due to sticking intake valves.NTSB LAX90LA241Accident · No injuriesLimited investigationFinal reportCessna 152 · Fullerton, CAThe warped condition of the engine valves and valve seats due to excessive and repeated thermal shock cycles.NTSB ANC90LA103Accident · Minor injuriesLimited investigationFinal reportDe Havilland DHC-3 · Beaver Village, AKMechanical failure of an exhaust rocker arm.NTSB LAX90DUA01Accident · Minor injuriesFinal reportHomebuilt JP-350-1 · Torrance, CAThe aircraft collision with the ground after the pilot experienced a loss of engine thrust due to propeller overspeed condition. Contributing to the accident was the pilot's improper servicing of the propeller hub that allowed the overspeed to occur.NTSB MKC90LA139Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Swifton, ARFailure of the engine driven blower assembly. A factor was the lack of suitable terrain for the forced landing.NTSB LAX90LA231Accident · No injuriesLimited investigationFinal reportCessna 152 · Fillmore, CAThe inadvertent engagement of the starter during flight for undetermined reasons. >NTSB FTW90FA125Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Dallas, TXThe initial partial loss of engine power, followed by the total loss of engine power and the striking of a hidden set of transmission wires.NTSB CHI90LA155Accident · No injuriesLimited investigationFinal reportCessna 150 · Flint, MIA loose fuel line caused by improper installation by maintenance personnel.NTSB MKC90LA128Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Ulysses, KSFailure of the powerplant cylinder and stall/mush encountered by the pilot in command.NTSB CHI90DEP05Accident · No injuriesFinal reportCirrus Klappmeier Cirrus VF-30 · Baraboo, WIManufacturer's inadequate equipment design to prevent a fuel leak which resulted in an in-flight fire. A factor related to the accident was the lack of an unsuitable forced landing area.NTSB MKC90LA126Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Fisher, ARPartial loss of engine power for an undetermined reason.NTSB DEN90LA127Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Sisseton, SDA total loss of power due to fuel starvation. Fuel starvation was caused by a missing fuel valve support clamp and a resultant cracked fuel line. Inadequate maintenance inspections and rough, uneven terrain were contributing factors.NTSB CHI90LA136Accident · No injuriesLimited investigationFinal reportCessna 182F · Clare, MIImproper maintenance by maintenance personnel resulting in a sticking carburetor float. Inadequate planning by the pilot in command during the approach is a factor in the accident.NTSB FTW90DRA05Accident · No injuriesFinal reportGrumman 164-B · Garwood, TXThe power loss due to super charger impeller failure.NTSB DEN90FA115Accident · Serious injuriesField investigationFinal reportAerospatiale SA315B · La Sal, UTA failure of the engine speed governor unit due to improper storage and/or inspection of the speed governor unit prior to placing it in service. A factor in the accident was the pilot carrying passengers on the external load.NTSB LAX90LA175Accident · No injuriesLimited investigationFinal reportPiper PA23-160 · Flagstaff, AZThe failure of the pilot to maintain directional control and to feather the propeller. A factor was erratic power from the left engine due to the jamming of the fuel selector valve in an intermediate position.NTSB ATL90FA111Accident · 1 fatalField investigationFinal reportCessna P206 · Liberty, NCA loss of engine power due to improper repairs to, and inadequate inspection of, the induction air box. The night light condition was a contributing factor.NTSB DEN90LA106Accident · No injuriesLimited investigationFinal reportCessna 337 · Broomfield, COThe pilot's failure to properly execute a precautionary approach following an engine failure.NTSB FTW90DRD07Accident · No injuriesFinal reportGrumman G-164A · Ville Platte, LAPartial loss of engine power due to a cracked number four cylinder intake rocker box housing. The lack of a suitable forced landing site was a related factor.NTSB LAX90LA155Accident · No injuriesLimited investigationFinal reportEnstrom F28F · Corona, CAThe partial failure of the engine's right magneto, which resulted in a loss of engine power.NTSB FTW90DRD05Accident · No injuriesFinal reportSchweizer G-164B · Reeves, LALoss of engine power due to a frozen rocker arm.NTSB MKC90LA084Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Branson, MOA disconnected throttle linkage that was inadequately inspected.NTSB FTW90FA091Accident · 1 fatalField investigationFinal reportLuscombe 8-A · Baytown, TXThe pilot's inadvertent stall of the airplane while maneuvering after a partial power loss during initial climb and a partially blocked exhaust system which had been inadequately maintained.NTSB MIA90LA097Accident · No injuriesLimited investigationFinal reportCessna 150L · Vieques, PRFailure of packing around the carburetor accelerator pump, which had jammed throttle movement and would not allow an increase in engine RPM above idle.NTSB SEA90FA057Accident · 2 fatalField investigationFinal reportCessna 170 · Republic, WAImproper inspection and airworthiness certification of the aircraft on the last annual inspection by an FAA authorized repair station, the inadequate engine performance and low cylinder compression, and the pilots attempt to takeoff with known aircraft…NTSB ATL90IA087Incident · No injuriesIncident investigationFinal reportMooney M-20L · Augusta, GAThe reported performance problem during climbout was undetermined. The pilot's decision to land with the landing gear retracted contributed to the minor damage sustained.NTSB MIA90LA092Accident · Minor injuriesLimited investigationFinal reportTalmadge Scott Longez · St. Petersburg, FLThe failure of maintenance personnel to properly secure the carburetor throttle cable housing.NTSB MKC90LA067Accident · No injuriesLimited investigationFinal reportGrumman AG-CAT G-164A · Parkin, ARTotal failure of the engine's master connecting rod.NTSB MKC90LA065Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Herington, KSFailure of the #2 exhaust valve, and improper flare by the pilot during the forced landing.NTSB ATL90FA071Accident · Serious injuriesField investigationFinal reportPiper PA-28-151 · Creola, ALThe pilot's failure to assure that proper maintenance and inspection of the aircraft were completed before flight.NTSB SEA90LA044Accident · Serious injuriesLimited investigationFinal reportRansome Pitts Special S-1C · Troutdale, ORInadequate maintenance which resulted in a loss of engine power during the initial climb shortly after takeoff.NTSB FTW90LA071Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Rayne, LAFailure of the #3 exhaust valve, which necessitated a forced landing on unsuitable terrain.NTSB FTW90LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Roanoke, TXThe partial power loss due to a failed exhaust valve and the failure of the pilot to maintain adequate speed during the precautionary landing approach.NTSB NYC90LA064Accident · No injuriesLimited investigationFinal reportMooney M20-K · Gibsonia, PAThe collision with rods in the field as the pilot was attempting a forced landing after a complete engine failure.NTSB DEN90LA044Accident · No injuriesLimited investigationFinal reportCessna 182 · Frederick, COA partial engine power loss induced by stuck intake valves. Contributing to the accident was the inadequate maintenance of the airplane and the unsuitable terrain in which the forced landing was performed.NTSB MIA90LA052Accident · No injuriesLimited investigationFinal reportCessna 210M · Ocala, FLSeparation of the throttle plate, due to improper securing of the attach screws during an overhaul.NTSB LAX90LA057Accident · Minor injuriesLimited investigationFinal reportBeech 33 · Gorman, CAThe malfunctioning propeller governor, and the pilot's misjudgement of altitude and distance of the approach path during an emergency landing. Factors contributing to the accident were: the power lines across the approach path to the runway and the…NTSB ATL90FA040Accident · 1 fatalField investigationFinal reportCessna 182 · Cincinnati, OHFailure of the Cessna pilot to remain clear of the helicopter after experiencing a partial power loss.NTSB LAX90LA050Accident · No injuriesLimited investigationFinal reportHughes 369HS · Waimea, HIThe improper installation of the pc tube by company maintenance personnel, which resulted in fatigue failure of the tube due to induced bending stresses.NTSB NYC90LA035Accident · No injuriesLimited investigationFinal reportBeech B-23 · Tinton Falls, NJPrecautionary landing in unsuitable terrain following a partial power loss due to a failed exhaust valve.NTSB MIA90LA030Accident · No injuriesLimited investigationFinal reportCessna 177RG · Mims, FLA worn throttle control assembly that had failed.NTSB LAX90DVG01Accident · No injuriesFinal reportSchweizer G-164B · Grimes, CAFailure of the counter weight bracket to the propeller assembly.NTSB ANC90FA010Accident · No injuriesField investigationFinal reportCessna A185E · Anchorage, AKThe throttle control linkage became disconnected on the first flight after an annual inspection due to improper maintenance. Darkness and high vegetation were contributing factors.