NTSB investigations
4,618 cases where the first occurrence was “Loss of engine power”.
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\" = 350) 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" = 350) 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 LAX89LA135Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200 · Lake Elsinore, CACFI displayed poor judgement in his demonstration of single engine operation of a twin engine acft. His lack of supervision of an improper, deteriorating situation assured an unsuccessful conclusion.NTSB DEN89LA088Accident · Minor injuriesLimited investigationFinal reportMiller S.A.L. 2/3 Mustang · Erie, COLoss of engine power for an unknown reason. Soft uneven terrain was a contributing factor.NTSB LAX89DVA05Accident · Serious injuriesFinal reportGrumman G-164B · Westley, CAA loss of engine power for undetermined reasons. A factor related to the accident was the proximity of obstructions.NTSB LAX89LA126Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Rio Vista, CAThe improper planning and execution of an emergency (simulated) maneuver by the pilot.NTSB MKC89LA076Accident · No injuriesLimited investigationFinal reportCessna 150 · Monroe City, MOFuel contamination and the pilot's failure to comply with a maintenance AD. Contributing to the accident was the pilot's operation of the airplane with a known deficiency.NTSB CHI89DEC03Accident · Minor injuriesFinal reportPiper PA-28 · Birmingham, MIAn undetermined fuel system blockage. Contributing to the accident was the lack of a suitable forced landing area.NTSB BFO89FA022Accident · 5 fatalField investigationFinal reportBeech A60 · Manassas, VAA loss of aircraft control due to the pilot's failure to maintain minimum engine control speed after a partial loss of power of the left engine for undetermined reasons. The pilot's inexperience in type of aircraft and an over maximum gross weight aircraft…NTSB NYC89FAMS3Accident · 1 fatalMissing aircraftFinal reportCessna P210N · Atlantic Ocean (Atlantic Ocean)A power loss for undetermined reasons resulting in a ditching in the north Atlantic Ocean. High seas may have prevented the pilot from getting into his survival suit.NTSB NYC89FAMS2Accident · 1 fatalMissing aircraftFinal reportPiper PA-32-300 · Missing (Atlantic Ocean)Loss of engine power for an unknown reason.NTSB MIA89FA096Accident · Minor injuriesField investigationFinal reportDouglas DC-3 · Isla Verde, PRThe failure of the flight crew to feather the left propeller and trim the aircraft after the left engine stopped producing power for undetermined reasons.NTSB NYC89FA092Accident · Minor injuriesField investigationFinal reportCessna S550 · Poughkeepsie, NYThe pilot's improper use of the powerplant controls, which resulted in actuation (tripping) of the reverse load limiters on the thrust reversers and subsequent reduction of available power in both engines. Factors related to the accident were: the pilot's…NTSB DEN89LA080Accident · Minor injuriesLimited investigationFinal reportEller BD-5B · Colorado Spring, COThe improper installation of fuel lines which were pinched off causing fuel starvation when the gear was retracted. A factor in the accident were the terrain features including loose gravel short of the runway.NTSB SEA89FA050Accident · Minor injuriesField investigationFinal reportMooney M20K · Incline Village, NVThe pilot's improper use of the fuel system when troubleshooting surging fuel pressure. A contributing factor was snow conditions which impaired the pilot's ability to make a proper forced landing.NTSB MIA89LA084Accident · No injuriesLimited investigationFinal reportCessna 172M · San Juan, PRThe failure of the pilot to properly use carburetor heat in conditions conducive to the formation of carburetor ice.NTSB DEN89LA075Accident · No injuriesLimited investigationFinal reportCessna 152 · Gill, COImproper use of the powerplant controls by the CFI during descent through low temperature air.NTSB MIA89LA079Accident · No injuriesLimited investigationFinal reportStolp-Adams SA100 · Indian Rocks, FLThe pilot's attempt to perform aerobatic maneuvers in an aircraft that was not equipped with fuel and oil systems that would continue to operate in inverted positions. This action resulted in a loss of power and the pilot having to ditch the aircraft.NTSB MIA89LA077Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Bunnell, FLThe failure of the instructor to maintain the proper airspeed during a simulated engine failure on initial climb. The instructor, after taking control of the aircraft, also failed to properly flare the aircraft resulting in a hard landing during which the…NTSB SEA89LA044Accident · No injuriesLimited investigationFinal reportCessna 182 · N. Bonneville, WASome form of carburetor malfunction or failure which resulted in a loss of engine power. Contributing to the accident was the planned forced landing approach by the plt which resulted in the airplane landing short of the desired landing site.NTSB LAX89LA101Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Novato, CAFire in the engine compartment area for undetermined reasons.NTSB BFO89LA017Accident · Serious injuriesLimited investigationFinal reportCessna 172F · Bruceton Mills, WVThe power loss occurred because of carburetor ice which obstructed airflow to the induction system. Contributing to the accident was the carburetor icing conditions, the highway and the ditch which was contacted.NTSB DEN89LA062Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Broomfield, COFuel starvation due to improper fuel tank selectior operation by the pilot. A factor related to the accident was: unprepared (rough/uneven) terrain short of the runway.NTSB ANC89LA035Accident · No injuriesLimited investigationFinal reportCessna 150 · Big Lake, AKThe student pilot's failure to follow procedures during the simulated forced landing. Contributing to the accident were the extreme temperatures.NTSB MKC89LA051Accident · No injuriesLimited investigationFinal reportCessna 150 · Clarion, IAFailure of the pilot to properly use the carburetor heat during icing conditions resulting in carburetor ice formation and subsequent loss of engine power.NTSB BFO89LA015Accident · No injuriesLimited investigationFinal reportCessna 150 · Winchester, VAPartial loss of engine power for an unknown reason. Soft terrain was a contributing factor.NTSB NYC89LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Stratford, CTThe loss of engine power for undetermined reasons.NTSB NYC89LA058Accident · Serious injuriesLimited investigationFinal reportPiper PA-60 · Somerville, NJImproper inflight decisions while approaching the airport on final approach with defective magnetos. The right fuel selector was placed in the closed position, the pilot attempted a go around, raised the landing gear and flaps, failed to maintain VMC, and…NTSB FTW89DRA01Accident · Minor injuriesFinal reportHughes 369D · Kountze, TXFalse indications of the fuel quantity system, which led the pilot to believe ha had more fuel than he did.NTSB CHI89LA031Accident · No injuriesLimited investigationFinal reportCessna 150 · Varna, ILThe student pilot was cruising at 2000' MSL on a solo flight, when the engine lost power. Emergency procedures were initiated and a forced landing was made in an open field. During the landing roll, the aircraft struck a dirt bank and was damaged. A…NTSB NYC89LA042Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Chambersburg, PAThe pilot of the Piper PA-28 was at cruise altitude and getting advisories from ATC. ATC gave him a SIGMET for turbulence when he noted his fuel was getting low. He decided to land at a nearby airport and was told by ATC that the airport he wanted was at his…NTSB CHI89DEV04Accident · 1 fatalFinal reportTesori Regionne 2002 · Urbana, ILThe plt transmitted on an advisory frequency 'clear the area I have engine trouble'. While turning from downwind to the base leg of his emergency approach to the airport, witnesses observed the airplane in a steep right bank when it suddenly banked left and…NTSB NYC89LA041Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Sharon, MAEngine power loss while landing due to fuel exhaustion.NTSB MKC89LA029Accident · No injuriesLimited investigationFinal reportAerospatiale TB-21 · Clinton, IAThe plt rprtd that while cruising at 10,000' & monitoring the eng instruments in a normal manner, power was suddenly lost as if by fuel starvation. He stated that emerg procedures were performed, but he was unable to restart the eng in spite of fuel in both…NTSB MIA89LA037Accident · No injuriesLimited investigationFinal reportCessna 150J · San Juan, PRThe acft departed, entered left downwind leg for touch-and-go landings. When at midfield downwind, the instructor plt stated the eng quit & he was unable to restart it. The acft continued downwind momentarily then the instructor plt turned the acft to land at…NTSB LAX89LA044Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Inyokern, CAThe pilot stated that, 'I landed in an open unpopulated area for the mechanic ... To make adjustments on the main blade (we were tracking and balancing the blades). I never shut the engine down. I disengaged the clutch. After the adjustment was made, I…NTSB CHI89LA024Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Indianapolis, INThe plt rprtd that immediately after rotation & drg the initial climb, the rgt eng began to backfire & run rough. When the eng contd to run rough in spite of attempts to smooth it out, the plt elected to abort the takeoff. At that time, the acft was at about…NTSB LAX89LA049Accident · No injuriesLimited investigationFinal reportCessna 337E · Kahului, HIThe plt rprtd that after about 10 hrs on an overwater ferry flt, he noticed high oil temp & low oil pressure indcns fromthe rear eng. Eventually the rear eng began running rough, so he shut it down, feathered its prop and 'increased power on the front…NTSB BFO89FA009Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Towson, MDAbout 6 min after takeoff, after leveling at 3500 ft, the plt rprtd he was having a probelm that he was unable to figure out. A few minutes later, he repeated the same problem & elected to divert to a nearby arpt. Witnesses rprtd the acft reversed course svrl…NTSB NYC89LA025Accident · Minor injuriesLimited investigationFinal reportBell 47G · Champion, NYThe pilot was unable to sustain flight due to a severe downdraft accompanied by a power loss at a low altitude.NTSB CHI89LA022Accident · No injuriesLimited investigationFinal reportCessna 150J · Carson City, MINTSB MKC89LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Leon, IAWhile cruising about 3000 feet AGL during a personal flight, the engine had a complete power failure. A successful emergency ldg was made on a farm hay field with no damage incurred. Shortly after the ldg, smoke was observed coming from the engine…NTSB FTW89FA015Accident · 2 fatalField investigationFinal reportCessna A150K · Flint, TXThe airplane was observed flying on an easterly heading at low altitude, with the propeller stopped. One of the witnesses said the airplane was gliding toward him and when close he started running away. He said the airplane abruptly turned left and went…NTSB ATL89FA222Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Alexander City, ALOn 10/31/88, the plt obtained wx info & filed an IFR flt plan fm vero beach, FL, to huntsville, AL. At aprx 1513 EST, hectcd ATC & rprtd climbing thru 1500' for 3000'. About 2.4 hrs later, he rprtd a loss of eng pwr. Vectors were provided toward an arpt, but…NTSB MKC89FA017Accident · Serious injuriesField investigationFinal reportCessna T210M · Clarksville, ARThe pilot took off on a 4500 ft runway, raised the landing gear, and turned south at approximately the 2500 ft point. Aircraft lost engine power. Pilot attempted to return to departure runway. Aircraft impacted prior to reaching the runway. Examination of the…NTSB MIA89LA036Accident · No injuriesLimited investigationFinal reportPiper J3C · Homestead, FLThe plt rprtd that while climbing at night after takeoff, the eng sputtered. He suspected possible water in the fuel & landed across rows in a field. Drg the landing, the gear failed & the acft came to rest on its belly with a bent prop, torn fabric & dmgd…NTSB NYC89LA016Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Easton, PALanding short of the runway due to a power loss of unknown reason(s).NTSB LAX89DUQ01Accident · 1 fatalFinal reportLewis Moni · Lancaster, CADuring a local flight, shortly after takeoff, the pilot reported engine trouble. The pilot was cleared to land at his discretion. The glider was observed to make a steep left descending turn subsequently colliding with the terrain. This was an experimental…NTSB CHI89LA003Accident · No injuriesLimited investigationFinal reportChampion 7EC · Bainbridge, OHNTSB FTW88DRD21Accident · No injuriesFinal reportAir Tractor AT301 · Ferriday, LAThe agricultural airplane was on a swath run when the engine malfunctioned. The pilot released the load of chemicals and made a forced landing in a bean field. There was very little damage to the beans but there was substantial damage to the airplane.…NTSB MIA88FA269Accident · 1 fatalField investigationFinal reportCessna 305A · Tampa, FLPlt experienced complete loss of engine power while climbing through 200 ft. the aircraft stalled and mushed, descending out of control and crashing to the ground. The engine was operated to full power after the accident. The cause of the loss of engine power…NTSB SEA88LA179Accident · No injuriesLimited investigationFinal reportCessna 152 · Cottage Grove, ORA loss of power occurred after takeoff from runway 33, during turn from upwind to crosswind, while doing touch and go landings. After checking the fuel selector and applying carburetor heat, the instructor pilot made a right turn back to the runway. The wind…