NTSB investigations
2,878 cases where the first occurrence was “Loss of engine power(total) - 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\" = 351) 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" = 351) 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 ATL95LA119Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Summerville, SCThe disconnected carburetor mixture control linkage that resulted in a loss of engine power, and the subsequent collision with trees.NTSB MIA95FA154Accident · 2 fatalField investigationFinal reportBeech 58 · Orlando, FLThe failure of the pilot-in-command to insure the landing gear was retracted following loss of power in one engine resulting in the aircraft being unable to climb and clear trees in the aircraft's flight path.NTSB FTW95LA257Accident · 1 fatalLimited investigationFinal reportRocky Mountain Buccaneer 11 B2B · Longmont, COThe pilot's failure to maintain flying speed, resulting in an inadvertent stall while attempting to make a forced landing. Factors were the pilot's lack of total experience in airplane make/model, improper maintenance of the airplane, and operation of the…NTSB CHI95LA196Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Columbia, MOA loose (or missing) nut and clip for the bottom magneto stud, due to inadequate maintenance, and fatigue failure of the magneto housing flange, which restulted in an oil leak, engine compartment fire, and a forced landing. A factor relating to the accident…NTSB FTW95LA256Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Hearne, TXThe loss of engine power as result of the failure of the number two cylinder. Factors were the unsuitable terrain available for the forced landing and the pilot's restricted vision due to oil on the windshield.NTSB CHI95LA187Accident · No injuriesLimited investigationFinal reportBell 47J2A · Elkhorn, WIloss of power as a result of an intake valve failure due to improper maintenance performed during the major engine overhaul, and pilot misjudgment of the flare during autorotation.NTSB FTW95LA241Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Denver City, TXThe loss of engine power due to a fracture of the #3 cylinder resulting in the total failure of the cylinder. A factor was the lack of suitable terrain for the forced landing.NTSB LAX95LA207Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Fall River Mill, CAFatigue failure of the No. 2 lower connecting rod bolt as a result of improper torque during the last engine overhaul.NTSB CHI95LA198Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Hoxie, KSthe loss of engine power due to the loose nut on the adjustment screw and the jammed exhaust valve on the number three cylinder. A factor in the accident was the ditch.NTSB FTW95LA392Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Springlake, TXThe loss of engine power due to the uncontained failure of the third stage turbine wheel. A factor was the lack of suitable terrain for the forced landing.NTSB FTW95LA237Accident · Minor injuriesLimited investigationFinal reportStokes Smith DSA-1 · Brookshire, TXOwner/builder's inadequate maintenance resulting in a loss of engine power due to corroded magneto coils. A factor was the lack of suitable terrain for the forced landing.NTSB ATL95LA107Accident · No injuriesLimited investigationFinal reportBoeing D75N1 · Fayetteville, GAA malfunction of the carburetor needle valve which resulted in fuel starvation to the engine.NTSB LAX95LA202Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Mission Viejo, CAthe loss of engine power due to the failure of company maintenance personnel to correctly connect the throttle arm and throttle linkage during engine installation.NTSB NYC95LA130Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Ashland, VAa loss of engine power due to a subsurface fatigue crack in the crankshaft which led to failure of the crankshaft.NTSB LAX95LA195Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Robbins, CAa loss of engine power due to a separation of the number 6 cylinder, and the nose over during the subsequent forced landing.NTSB ANC95LA058Accident · No injuriesLimited investigationFinal reportCessna 206 · Bethel, AKA failure of the #2 main engine bearing and subsequent fatigue failure of the engine crankshaft. A factor relating to the accident was: the lack of suitable terrain for an emergency landing.NTSB NYC95LA115Accident · 1 fatalLimited investigationFinal reportPitcher W-8 · Mineral, VAan electrical system problem that resulted in a blown (failed) fuze and an inoperative electric fuel pump, which in turn resulted in fuel starvation and loss of engine power; and failure of the pilot to maintain adequate airspeed which resulted in an…NTSB FTW95LA213Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Caldwell, ARThe loss of power due to a crack in the #4 cylinder. Factors were the lack of suitable terrain for the forced landing and proper touchdown point not possible.NTSB NYC95LA110Accident · 1 fatalLimited investigationFinal reportHighcraft Buccaneer II · Millstone Twsp, NJThe loss of engine power due to the seizure of the number one cylinder pistion and the pilot's failure to maintain adequate airspeed which resulted in a stall.NTSB FTW95LA203Accident · No injuriesLimited investigationFinal reportCessna 150H · Rockport, TXThe loss of engine power due to a stuck exhaust valve. The lack of suitable terrain for the forced landing was a factor.NTSB BFO95LA053Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Dubois, PAThe failure of valve springs in the number two engine cylinder which resulted in a total loss of engine power during initial climb. The unsuitable terrain encountered during the subsequent forced landing was a factor.NTSB ANC95LA053Accident · No injuriesLimited investigationFinal reportCessna 170B · Chickaloon, AKThe fracture of the crankshaft resulting in separation of the propeller and propeller flange in-flight. A factor associated with the accident was the lack of suitable terrain for an emergency landing.NTSB LAX95LA180Accident · Serious injuriesLimited investigationFinal reportDavenport LONG-EZ · Los Angeles, CAfuel starvation due to a modification of the fuel system that rendered it incapable of maintaining adequate fuel pressure. The builder/pilot's lack of understanding of the fuel system was a factor in this accident.NTSB ATL95LA094Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-160 · Dayton, TNInstallation of an improper crankshaft oil seal which eventually separated from its seat resulting in excessive oil loss, and the pilot's improper inflight planning in that he did not allow sufficient time to lower the landing gear.NTSB MIA95LA127Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · N. Miami Beach, FLInadequate annual inspection by maintenance personnel for failure to identify a hardened oil hose from the oil pump to the oil cooler inlet inside a protective fire sleeve. Additionally, unsuitable terrain encountered during the forced landing contributed to…NTSB NYC95LA099Accident · No injuriesLimited investigationFinal reportEurocopter AS350D · Sea Bright, NJFailure of the position 19 engine bearing, which resulted in shifting of the accessory gear drive, disengagement of the fuel pump, fuel starvation, and loss of engine power.NTSB LAX95LA178Accident · No injuriesLimited investigationFinal reportGodkey Kitfox IV · Phoenix, AZthe failure of the ignition system due to a deffective diode.NTSB LAX95LA175Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Parker, AZthe failure and separation of the No. 2 cylinder exhaust valve. Darkness was a factor in the accident.NTSB CHI95LA139Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Kirksville, MOthe loss of engine power due to failure of the engine's hydraulic tappet body heads. Related factors in the accident were the restricted visual lookout, and the unsuitable terrain encountered during the forced landing.NTSB FTW95LA185Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Morse, LAPower loss due to a cracked intake valve pipe assembly. A factor was the lack of suitable terrain for the forced landing.NTSB CHI95LA137Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Dodge City, KSfatigue and subsequent catastrophic failure of the connecting rod originating from the decarburized area on the shank of the rod. Factors were the low cloud weather condition and the ditch.NTSB SEA95LA084Accident · No injuriesLimited investigationFinal reportBaxter-Wilson CW CHAMP-3 · Forks, WALoss of engine power for undetermined reasons and the lack of suitable terrain for a forced landing.NTSB MIA95FA114Accident · 2 fatalField investigationFinal reportNorth American AT-6D · Sebastian, FLThe failure of the pilot-in-command to maintain airspeed while maneuvering for a forced landing following loss of engine power.NTSB FTW95LA179Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · San Antonio, TXThe loss of engine power due to fuel exhaustion as result of a fuel line connector leak. A factor was the lack of suitable terrain for the forced landing.NTSB FTW95LA174Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Estancia, NMThe loss of engine power due to exhaust valve separation resulting from inadequate maintenance. A factor was the dark night and the lack of suitable terrain for the forced landing.NTSB MIA95LA108Accident · No injuriesLimited investigationFinal reportCessna 172M · Panacea, FLThe pilot's failure to attain the proper touchdown point during a forced landing to a runway. This resulted in the airplane rolling off the departure end of the runway, and subsequent on ground collision with a fence and a telephone booth. Contributing to the…NTSB MIA95LA104Accident · Minor injuriesLimited investigationFinal reportHaseloh, D. W. RAF 2000 GTX SE · Lakeland, FLTotal loss of engine power due to vibration failure of a 14-gauge electrical wire which is connected to the negative terminal of the ignition coil. Contributing to the accident was the inadequate design of the ignition system by design personnel, and…NTSB CHI95LA117Accident · No injuriesLimited investigationFinal reportLewis KR-2 · Ogallala, NEthe owner/builder's improper maintenance (installation). Factors were the carburetor reversed and the mixture control cable not secured.NTSB BFO95LA043Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180D · Jeannette, PAthe failure of the magneto pinion gear failure, which resulted in a total loss of engine power during initial climbout over usuitable terrain.NTSB FTW95LA153Accident · No injuriesLimited investigationFinal reportMooney M20J · Tijeras, NMFuel starvation due to foreign material partially blocking the fuel screen, and the pilot's failure to switch fuel tanks. A factor was the lack of suitable terrain for the forced landing.NTSB LAX95LA150Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · El Cajon, CAa loss of engine power due to an in-flight separation of the fuel system gascolator glass bowl resulting in a premature fuel exhaustion. The rough/uneven terrain is a factor in this accident.NTSB CHI95LA111Accident · Minor injuriesLimited investigationFinal reportBaker Long EZE · Salina, KSfailure of the engine driven fuel pump. Factors associated with the accident were fuel starvation, insufficient altitude and soft terrain.NTSB LAX95FA145Accident · Minor injuriesField investigationFinal reportLuscombe 8E · Compton, CAThe pilot's poor preflight inspection, the mechanic's poor annual inspection, and the leaking fuel caps which allowed water to contaminate the fuel.NTSB CHI95LA104Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Ann Arbor, MIthe failure of the mechanic to close the drain valve after changing oil, resulting in complete loss of engine oil. A factor was the soft terrain, which resulted in the nose wheel digging in and the airplane nosing over.NTSB NYC95LA075Accident · No injuriesLimited investigationFinal reportCumberland-Pitts Special S1C · New Windsor, MDthe failure of the fuel pump diagram which resulted in fuel starvation and a subsequent forced landing.NTSB ATL95LA061Accident · Serious injuriesLimited investigationFinal reportCessna 177B · Collegedale, TNThe mechanic's failure to follow approved engine overhaul procedures which resulted in the separation of the oil return line, and the complete loss of engine power.NTSB FTW95LA141Accident · No injuriesLimited investigationFinal reportBurken Ultimate · New Braunfels, TXThe loss of engine power due to fuel starvation due to a fuel leak resulting from a loose fuel line fitting. A factor was the lack of suitable terrain for the forced landing.NTSB LAX95LA127Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Gaviota, CAinadequate maintenance and service of the aircraft's carburetor heat system, and the pilot's intentional flight into adverse weather conditions. The lack of a suitable area for the emergency landing was a factor.NTSB LAX95LA126Accident · No injuriesLimited investigationFinal reportSchweizer G-164A · Robbins, CAA failure of the engine master rod. A factor in the accident was the soft, wet condition of the field available for the forced landing.NTSB LAX95LA125Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Pacoima, CAthe failure of the engine overhaul shop to install the correct gasket stack on the propeller governor pad as required by the engine manufacturer.