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 FTW94FA295Accident · 2 fatalField investigationFinal reportCessna 175 · Oklahoma City, OKImproper maintenance of the engine by unknown person(s), the installation of unapproved parts, and subsequent bearing seizure. The lack of suitable terrain in the forced landing area was a related factor.NTSB CHI94LA315Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Hanston, KSThe failure of the number two connecting rod. Factors in the accident were the fouled windshield utility wires, the road sign, and the telephone pole.NTSB SEA94LA235Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Coolin, IDThe failure of the engine manufacturer to properly remanufacture and adequately inspect the no. 1 rocker arm prior to its installation on the engine. This resulted in fatigue cracking of the rocker arm and a subsequent loss of engine power.NTSB NYC94LA170Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Houlton, MEInadequate maintenance inspection which failed to detect internal corrosion of the magneto, resulting in ignition arcing and the loss of engine power.NTSB CHI94LA314Accident · No injuriesLimited investigationFinal reportCessna 188B · Oakdale, ILmisalignment of the number one connecting rod during major overhaul. Factors were the subsequent scoring and fatigue failure of the crankshaft.NTSB FTW94LA281Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18A Dromader · Wheatley, ARTotal loss of engine power due to a cracked cylinder. A factor was the lack of suitable terrain for the forced landing.NTSB CHI94LA302Accident · Minor injuriesLimited investigationFinal reportFrith Challenger II · Fairfield, IAthe total failure and separation of the propeller system drive belt. Obstacles (powerlines and pole) were a factor in the accident.NTSB ATL94LA165Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Spruce Pine, NCA seized cylinder exhaust valve because of deposits on the valve and an oversized valve stem. The lack of suitable terrain for a forced landing was a factor.NTSB BFO94LA143Accident · No injuriesLimited investigationFinal reportCessna 172M · Vestal, NYLoss of engine power during an aborted landing due to the throttle cable separating from the carburetor.NTSB ATL94LA159Accident · Minor injuriesLimited investigationFinal reportPiper PA-25 · Columbia, NCThe failure of the aircraft carburetor that resulted in a total loss of engine power.NTSB ATL94LA161Accident · No injuriesLimited investigationFinal reportCessna 207 · Nags Head, NCThe failure of the mixture control cable which resulted in a loss of engine power.NTSB LAX94LA327Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Firebaugh, CAthe loss of engine power due to the failure of the number 2 cylinder head. A factor was the dark night conditions which inhibited the pilot's ability to visually detect ground obstructions in the landing area.NTSB BFO94FA140Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Roanoke, VAThe disconnection of the throttle cable from the throttle arm on the fuel injector servo.NTSB ATL94LA158Accident · No injuriesLimited investigationFinal reportCessna 172XP · Clarksburg, TNThe failure of the alternator drive coupling, and debris from the failed coupling that lodged in the engine oil pump, resulting in a sheared oil pump drive shaft. The engine subsequently failed because of oil starvation.NTSB FTW94FA273Accident · 3 fatalField investigationFinal reportCessna 310 · Pryor, OKFailure of the pilot to maintain minimum control airspeed (VMC), which resulted in a loss of aircraft control. Factors related to the accident were: an oil leak from a fatigue crack in the engine crankcase, and inadequate maintenance.NTSB CHI94LA286Accident · No injuriesLimited investigationFinal reportSnow S2C · Leslie, MOthe separation of the cylinder and subsequent oil leak. A factor to the accident was the pilot's restricted visual outlook.NTSB ANC94FA106Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Kenai, AKInadequate engine maintenance and/or inspection, and fatigue cracking of the engine case, which resulted in eventual damage to the #3 cylinder studs/engine through-bolts, subsequent separation of the #3 cylinder and piston, and an in-flight fire.NTSB SEA94LA209Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Redmond, WAFailure of an exhaust valve. A factor to the accident was: wet grass.NTSB MIA94LA194Accident · Minor injuriesLimited investigationFinal reportAerosport Quail · Waynesboro, MSAn engine failure due to improper maintenance [overhaul] of the engine crankshaft.NTSB ATL94LA154Accident · Minor injuriesLimited investigationFinal reportAyres S2R · Vienna, GAThe loss of engine power because of a fractured cylinder.NTSB MIA94LA193Accident · Serious injuriesLimited investigationFinal reportGrumman AA-5 · Ormond Beach, FLThe improper maintenance work done on the carburetor by a local mechanic that resulted in loss of engine power over unsuitable terrain. A contributing factor was the dirt and moisture that contaminated the carburetor.NTSB FTW94LA266Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Matagorda, TXA power loss due to cracked engine cylinder. A factor was the lack of suitable terrain for the forced landing.NTSB BFO94LA128Accident · Serious injuriesLimited investigationFinal reportHankins/Dickerson Clipped Wings II · Laurel, MDThe failure of the engine ignition system capacitor discharge unit which caused loss of total engine power.NTSB LAX94FA308Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · San Luis Obispo, CAthe failure of the No. 4 cylinder connecting rod for undetermined reasons. The dark night lighting conditions, which hampered the ability of the pilots to detect the power lines, was a factor in this accident.NTSB LAX94FA309Accident · 3 fatalField investigationFinal reportAero Commander 112 · Mohave Valley, AZFailure of the certified flight instructor to properly judge the flare to avert a hard landing, and the failure of other maintenance personnel to properly repair the engine case halves during engine overhaul. A factor in the accident was the uneven relief of…NTSB BFO94LA127Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Edgewater, MDThe pilot's inadequate preflight inspection which failed to detect water contaminated fuel which resulted in fuel starvation.NTSB FTW94LA261Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Dallas, TXThe loss of engine power due to failure of the starter gear and shaft assembly needle bearing. Factors were the dark night conditions and the lack of suitable terrain for a forced landing.NTSB ANC94LA097Accident · No injuriesLimited investigationFinal reportCessna 206 · Mosquito Flats, AKThe missing number 6 cylinder piston pin cap and the subsequent failure of the number 6 cylinder connecting rod cap. Also, the lack of suitable landing area for the forced landing.NTSB FTW94LA256Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Mcgehee, ARTotal loss of engine power as the engine seized due to a blower bearing failure. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94LA253Accident · No injuriesLimited investigationFinal reportHughes 269A · Leander, LAInadequate maintenance and a fatigue failure of a #1 cylinder connecting rod bolt. A factor was the lack of suitable terrain available to the pilot for a forced landing.NTSB CHI94LA256Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-200 · Fort Wayne, INthe loss of engine power due to the failure of the number one cylinder.NTSB ANC94LA095Accident · No injuriesLimited investigationFinal reportStarman Teirra II · North Pole, AKThe seizure of the no. 2 cylinder as a result of an inadequate cooling system for the high ambient temperature.NTSB SEA94LA196Accident · No injuriesLimited investigationFinal reportCessna T210M · Rathdrum, IDThe fatigue failure of the crankshaft and a slipped bearing.NTSB MIA94FA181Accident · Serious injuriesField investigationFinal reportBellanca 14-9 · Lakeland, FLThe improper modification of the engine driven fuel pump mechanical arm by an unknown person, restricting the fuel systems ability to supply fuel to the engine at full power.NTSB SEA94LA179Accident · Serious injuriesLimited investigationFinal reportKaman HH43F · John Day, ORFailure of a turbine compressor wheel. The lack of suitable terrain for an autorotation/forced landing was a factor.NTSB NYC94LA131Accident · No injuriesLimited investigationFinal reportDonovan DER Kricket 17K-1 · Brockport, NYThe loss of engine power as a result of a sticking valve in the carburetor due to dirt contamination.NTSB NYC94LA129Accident · Minor injuriesLimited investigationFinal reportPitts S-1S · Stevensville, MDInadequate maintenance by which undertorquing of the accessory gear retaining bolt resulted in fatigue failure of the bolt and the subsequent loss of engine power.NTSB FTW94MA235Accident · 3 fatalMajor investigationFinal reportAerospatiale AS350D · Hanalei, HIFailure of the engine-driven fuel pump, which resulted in the loss of power, and the lack of aircraft flotation equipment. Factors related to the accident were: flight over water adjacent to terrain that afforded no suitable forced landing site, and the lack…NTSB FTW94LA230Accident · Serious injuriesLimited investigationFinal reportNorth American Navion 4 · Dupont, LAThe loss of engine power due to inadequate maintenance adjustment of accessory drive starter gear screws which disengaged in flight. Factors were the lack of suitable terrain for the forced landing and non compliance with the applicable service letter.NTSB CHI94DCQ02Accident · Minor injuriesFinal reportWSK PZL Mielec M-18 Dromader · Colby, KSfuel starvation resulting from the fuel shutoff valve closing as a result of improper adjustment.NTSB LAX94LA279Accident · Minor injuriesLimited investigationFinal reportFrank M. Kopecky Quickie · Camarillo, CAthe failure or malfunction of the engine ignition system.NTSB ANC94LA078Accident · Serious injuriesLimited investigationFinal reportCessna T207 · Kenai, AKThe failure of the engine crankshaft. Factors in the accident were the pilot's inadequate compensation for the wind conditions and not attaining the proper touchdown point at the suitable landing strip.NTSB ATL94LA128Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Smithville, GAThe failure of # 2 cylinder head.NTSB FTW94FA212Accident · Serious injuriesField investigationFinal reportPiper PA-46-350P · Akron, COThe loss of engine power due to oil exhaustion which resulted from a failed oil scraper ring. A factor was unsuitable terrain for a forced landing.NTSB FTW94LA210Accident · No injuriesLimited investigationFinal reportHiller UH-12L4 · West Helena, ARA total loss of power due to a leak in the main fuel line which occurred as a result of an electrical short which burned a hole in the fuel line. Factors were a failure by the pilot to perform recommended maintenance and the lack of suitable terrain for a…NTSB CHI94DTK02Accident · No injuriesFinal reportAyres S2R · Letcher, SDthe loss of engine power due to the failure of the engine driven fuel pump and shaft.NTSB BFO94LA110Accident · Minor injuriesLimited investigationFinal reportRyan Navion B · Amherst, OHInadequate maintenance by an unqualified person which resulted in the loss of engine ignition due to worn ignition wires.NTSB SEA94FA154Accident · 1 fatalField investigationFinal reportCessna 172 · Port Angeles, WALack of oil and connecting rod failure. A factor to the accident was rough/uneven terrain.NTSB NYC94LA101Accident · Minor injuriesLimited investigationFinal reportJones Thorp T-18 · East Quogue, NYInadequate maintenance which resulted in oil-fouled spark plugs and the loss of engine power.NTSB FTW94LA205Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Brinkley, ARA supercharger impeller bearing failure. A factor was the lack of suitable terrain for the forced landing.