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 ATL89LA100Accident · No injuriesLimited investigationFinal reportHughes 269C · Bexley, OHThe inadequate maintenance inspection of the engine following evidence of previous damage which led to the failure of the no. 1 cylinder exhaust valve.NTSB MKC89LA072Accident · No injuriesLimited investigationFinal reportCessna 310 · Cedar Rapids, IAThe proper touchdown point was not attained by the pilot and the crankshaft failure on one engine. Contributing to the accident were the weather conditions and the approach lights which were contacted.NTSB MKC89LA062Accident · No injuriesLimited investigationFinal reportCessna 152 · Kansas City, MOImproper use of the carburetor heat control by pilot in command.NTSB FTW89IA053Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-32 · Houston, TXThe turbine guide vane failure.NTSB SEA89LA049Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Beaver Marsh, ORAn loss of engine power due to a failed exhaust valve. Contributing to the accident was the snow covered terrain on which a precautionary landing was made.NTSB ANC89FA042Accident · Serious injuriesField investigationFinal reportCessna 207 · Nome, AKThe partial loss of power resulting from fuel interruption due to a blockage in the engine fuel pump low pressure check valve.NTSB SEA89LA045Accident · Serious injuriesLimited investigationFinal reportPiper PA-31 · Sparks, NVThe pilot's misjudgement of the forced landing profile. Contributing to the accident was the failure of the right turbocharger and the pilot's improper handling of the landing gear system.NTSB ATL89LA079Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Williamsburg, OHA defective gasket in the fuel strainer which caused a restriction in fuel flow during climbout.NTSB ATL89FA078Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Bagley, ALInadequate maintenance by other maintenance personnel which allowed a foreign object to remain in the engine and damage/short the spark plugs in the #2 and #3 cylinders. Trees in the emergency landing area contributed to the accident. If shoulder harnesses…NTSB SEA89LA034Accident · No injuriesLimited investigationFinal reportCessna 210 · Carson City, NVSeparation of the throttle cable due to wear as power was applied for a landing go-around. Contributing to the accident was rough terrain at the touchdown point of the forced landing.NTSB MKC89IA048Incident · No injuriesIncident investigationFinal reportGulfstream Commander 690A · St. Paul, MNThe PIC had prefltd his commander turboprop and prepared for takeoff fm the St. Paul arpt. During the takeoff roll just as the acft was rotated to takeoff attitude, the rt eng failed. The PIC eased the acft back to the rwy, reduced pwr and came to a stop on…NTSB CHI89FA036Accident · 4 fatalField investigationFinal reportBeech B23 · Jeffersonville, INPilot-in-command's poor inflight decision in attempting to return to the airport after a partial engine failure, and his encountering a stall/spin at low altitude from which he was unable to recover.NTSB DEN89IA047Incident · No injuriesIncident investigationFinal reportCessna 210L · Roswell, NMPlt preflighted acft and noted indication of 9 qts of oil in crankcase. Flt departed Roswell (row) in night VMC en route to abq. Plt had just leveled off at 6500 ft MSL when he noticed oil pressure gauge fluctuating. Oil pressure then began dropping and plt…NTSB MKC89LA045Accident · No injuriesLimited investigationFinal reportCessna 175 · Lawrence, KSThe plt said that shortly after takeoff, the engine began to misfire and lose power. He elected to abort the takeoff, but was unable to stop on the remaining portion of the runway. He ran off the end, into a farm field, where the acft nosed down and was…NTSB MIA89FA054Accident · 2 fatalField investigationFinal reportCessna 310L · Cedar Key, FLThe evidence indicated that personnel failed to tighten a fuel line at the fuel pressure switch on left engine resulting in fuel line leaking into the engine compartment in flight. An inflight fire burned through a fuel crossfeed fuel line which could not be…NTSB LAX89LA063Accident · No injuriesLimited investigationFinal reportHughes 369E · Hanalei, HIDuring a local sightseeing flight, the pilot reported that he heard a muffled bang and simultaneously the engine out warning lights and audio alarm activated. The pilot initiated a forced landing on the beach which resulted in the helicopter nosing over. An…NTSB LAX89LA061Accident · Minor injuriesLimited investigationFinal reportBeech K35 · Arbuckle, CADuring cruise flight, the pilot noted oil on the windshield. The pilot diverted to a nearby airport. Enroute the windshield became covered with oil. The pilot opted to make an emergency landing on a road. Due to power lines, he diverted to an open field. Just…NTSB LAX89DUQ02Accident · No injuriesFinal reportChamberlain Long EZ · Camarillo, CADuring a local test flight, the pilot had reduced power to decrease altitude for approach to the airport. When power was applied, the engine did not respond. The pilot made an off-runway landing. Inspection of the airplane revealed that the spring on the…NTSB CHI89LA025Accident · No injuriesLimited investigationFinal reportCessna 172P · Samaria, MINTSB NYC89LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Pawling, NYOff airport landing in unsuitalbe terrain following a power loss caused by loss of lubrication due to spalling on the camshaft and corresponding tappet body faces.NTSB NYC89FA029Accident · 3 fatalField investigationFinal reportRyan Navion A · Franklin, PADue to improper grade of fuel in the airplane and bent and binding exhaust valves, the airplane engine had a partial loss of power during the takeoff ground run. The pilot did not abort the takeoff and the airplane stalled and collided with trees when the…NTSB ATL89LA031Accident · No injuriesLimited investigationFinal reportCessna 310J · Carrollton, OHThe pilot had landed at Carrollton, OH for refuelling and breakfast. After refuelling he taxied out for departure from runway 25 for a flight back to his home base. The runup was reportedly normal. After application of maximum power, he started his takeoff…NTSB LAX89LA040Accident · No injuriesLimited investigationFinal reportMooney M20J · San Diego, CADuring the initial climb after takeoff, the engine lost partial power. A turn was made to land on rwy 10R, but the pilot was unable to reach the landing area. Subsequently, he made a wheels-up landing short of the runway. An inspectionof the engine revealed…NTSB SEA89FA015Accident · 2 fatalField investigationFinal reportBeech 65 · Elko, NVApprox 10 min after t/o, the pilot stated he was returning to land due to a problem. On final the acft rolled inverted and descended nose down into a residence. Engine exam revealed a failed supercharger intermediate drive shaft gear resulting in loss of…NTSB ATL89LA021Accident · No injuriesLimited investigationFinal reportCessna 172M · Hilton Head Is., SCThe plt reported that the airplane lost power shortly after takeoff. A forced ldg was subsequently made in a swamp near the arpt. The airplane nosed over during rollout. Post-crash exam of the airplane revealed that the throttle cable outer casing had become…NTSB MKC89DPG01Accident · 1 fatalFinal reportCulver LFA · Dumas, ARA witness stated that the airplane backfired while in a turn at low altitude. He heard it backfire twice more and noticed engine running at idle just before it crashed. When runup, the engine would attain 1900 RPM, then backfire and the RPM would drop to 600…NTSB SEA88LA191Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Troutdale, ORThe plt rprtd that soon after takeoff, he realized there was insufficient power. Subsequently, the acft mushed into trees & a raspberry field & was damaged. An exam of the eng revealed a piece of the carburetor heat muff had broken off & was ingested into the…NTSB DEN88LA210Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Kerrville, TXThe commercial plt was 6 miles from his ranch and noted smoke in the cockpit, accompanied by a rough running engine. He turned back to the ranch for a forced landing. He overflew the landing area, decided he was too high for landing and turned for another…NTSB CHI88DEG01Accident · No injuriesFinal reportPiper PA-22-160 · Jackson, OHWhile in cruise flight, the eng began running rough & would not produce enough power to maintain level flt. The plt selected a pasture for an emergency landing. Just before landing, the acft struck & severed a transmission line. It then brushed a treetop &…NTSB ANC88LA138Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Mcgrath, AKWhile cruising, the pilot-in-command experienced a rough engine and finally an unexplained power reduction to idle. He was unable to glide the float equipped airplane to a body of water and executed a forced landing on the tundra where the airplane sustained…NTSB ATL88LA252Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Covington, TNThe plt reported that the engine suddenly began to run rough and backfire during a pipeline patrol flight at 300 ft AGL. The roughness worsened and the plt made a forced ldg on a dirt road. During rollout, one of the wings caught vegetation bordering the road…NTSB ATL88LA251Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Gray, GAInstructor said that after completing a stall series the engine began to backfire continously & power was lost so that he could not maintain altitude. An off airport landing was made and a fence was hit during the landing roll. Eng had been overhauled &…NTSB MKC88FA171Accident · Serious injuriesField investigationFinal reportPiper J3C-65 · Goodman, MOEngine ignition and lubrication problems which resulted in the pilot's election to execute a precautionary landing. A contributing factor was the pilot's inability to see and avoid power lines in his approach path due to bright sunshine.NTSB LAX88LA316Accident · No injuriesLimited investigationFinal reportCessna 182M · Crescent City, CAFailure of the number 2 piston due to preexisting fatigue cracks in the piston.NTSB LAX88DVA13Accident · No injuriesFinal reportAyres 600-S2D · Los Banos, CAPlt was engaged in aerial application when no 9 cyl head cracked. Plt returned for precautionary lndg. On approach, oil obscured windshield. Plt missed landing area; landed in cultivated field beside landing area. Acft nosed over.NTSB ATL88DKG15Accident · Minor injuriesFinal reportRockwell S2R · Pelham, GAThe crop duster had completed the third swath run of the morning when the engine began to lose power. The plt released the contents of the hopper and made a forced landing in a soybean field. During the landing roll, the airplane nosed over and a ground fire…NTSB MKC88LA161Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Gillett, ARWhile en route to engage in an aerial application operation, the plt said the engine began to misfire and cut out. Unable to correct the malfunction, the plt dumped his chemical load and began returning to the departure airstrip. En route, he felt he would…NTSB MKC88FA154Accident · Serious injuriesField investigationFinal reportBoeing 737-222 · Little Rock, ARThe sked air carrier flt was aborted after the capt heard a noise and felt a vibration emanating from the left side of the acft, which at the time, was perceived as a 'blown' tire. The acft was subsequently stopped on the active rwy, and an order fm the…NTSB ATL88DKG13Accident · No injuriesFinal reportGrumman G-164A · Fadette, ALThe pilot reported a partial power loss during an aerial application flight. The aircraft landed in the crops. The pilot stated that he found the number 3 cylinder partially separated from the engine.NTSB SEA88LA148Accident · No injuriesLimited investigationFinal reportWeatherly 620 · Wilbur, WAThe pilot reported that an engine power loss occurred during an aerial application maneuver. The pilot made a forced landing in rough terrain. Examination of the engine revealed deteriorated seals in the engine driven fuel pump. Exam of the electric fuel pump…NTSB MKC88DCD02Accident · Serious injuriesFinal reportPrairie Flyers Tierra II · Prairie City, IAThe pilot was attempting to land in a hayfield and decided to abort the landing due to rough condition of field. As he pushed the throttle forward, the engine faltered and the plane touched down. The aborted landing was continued due to speed and…NTSB CHI88DET04Accident · No injuriesFinal reportCessna A188B · Preu, INAerial applicator experienced total failure of throttle cable during application swath run. Aircraft received substantial damage when pilot executed forced landing in adjacent crop field. Aircraft and engine had received annual inspection 125 hours prior to…NTSB SEA88LA147Accident · No injuriesLimited investigationFinal reportBell 206B · Enterprise, ORWhile in cruise flt at abt 500 ft AGL, the plt stated he heard a 'ping' sound from the eng and pwr decreased to flt idle. An autorotation was attempted into a cleared upsloping area but the plt had to pull 'up' collective in order to clear a fence. A hard…NTSB MKC88LA144Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Cherry Valley, ARThe plt said that shortly after takeoff, he had a partial power loss. He dumped his chemical load and attempted to return for landing. While turning the engine suffered a complete loss of power. He attempted to land, but on the roll out, acft nosed over in…NTSB CHI88DEV03Accident · No injuriesFinal reportHughes 369HS · Ashland, ILAs the helicopter was taking off, there was a loss of rotor RPM which was accompanied by a loss of fuel flow to the eng. The plt aborted the takeoff, but during touchdown, the main rotor blades flexed downward & severed the . Tail boom. An inspn of the eng…NTSB LAX88DUJ06Accident · No injuriesFinal reportGrumman G-164B · Chandler, AZDuring an aerial application flight, the engine experienced a loss of power. A forced landing was made in an open field and during the landing roll the airplane nosed over. Inspection of the engine revealed that the number five cylinder dome separated from…NTSB LAX88LA266Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Springerville, AZShortly after takeoff, the engine experienced a loss of power. The pilot made a forced landing where during the landing roll, the airplane collided with the terrain. During the engine inspection, it was found that the left magneto fired only one sparkplug.…NTSB LAX88LA259Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Corona, CADuring takeoff the engine failed to develop full power & the acft collided with trees located approx 500 ft beyond the runway. Exam of the engine revealed the mixture control arm at its fuel pump housing attachment point had restricted movement & was…NTSB NYC88FA181Accident · 1 fatalField investigationFinal reportCessna 421 · Taunton, MABfr rchg his destn, the plt adzd apch ctl that his rgt eng was 'blowing some smoke' & losing oil pressure. Vectors were provided for a visual apch, but there were low clouds in the area & vis was restricted due to haze. After reaching the vcnty of the arpt,…NTSB ATL88LA216Accident · Serious injuriesLimited investigationFinal reportCessna 172L · Michie, TNWitness reported that the airplane engine was running rough during takeoff; the airplane subsequently disappeared from sight in a nose-down attitude. The plt later reported that he could not remember the events that led up to the power loss. Post-crash exam…