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 NYC88LA201Accident · No injuriesLimited investigationFinal reportBell 206B · Plymouth, MAA loss of power to the engine because the fuel control was not properly adjusted and collision with terrain due to an unsuitable landing area.NTSB CHI88DEX07Accident · Minor injuriesFinal reportCessna 175A · Bloomington, INAircraft experienced partial loss of engine power at 150 feet AGL after takeoff. Pilot made 180 degree turn in attempt to return to airport, but experienced further power loss and elected to make emergency landing in field. Right wingtip hit tree, and…NTSB ATL88FA211Accident · Serious injuriesField investigationFinal reportCessna 175 · Ninety Six, SCThe pilot was cruising the airplane at 2,000 feet AGL when he noted a loss of oil pressure and increase in oil temperature. He also noted a loss in engine power. He elected to make a landing off airport and set up a pattern for the selected field. The…NTSB NYC88LA174Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · East Hampton, NYThe pilot reported that he had experienced a partial power loss on downwind of a VFR traffic pattern. He stated that just after entering downwind he lowered the landing gear. As the speed decreased below 132 knots he advanced the throttles. There was no…NTSB BFO88DIA01Accident · Serious injuriesFinal reportTerry Osprey II · Manassas, VAThe pilot reported that on initial climb at an alt of 300 ft AGL, engine power began to decay. A right turn was initiated to return to the runway but a further loss of power was experienced and a forced landing was attempted in a field. The acft contacted…NTSB CHI88DEX05Accident · No injuriesFinal reportBeech V35A · Seymour, INAircraft was in cruise flight at 6500 feet when engine began to run rough. Pilot navigated to nearest airport and made intentional gear-up landing with cruise power. Postcrash investigation revealed number 2 exhaust valve had failed and become wedged between…NTSB MIA88FA192Accident · Serious injuriesField investigationFinal reportBell 47G3B-1 · Benoit, MSThe plt said the engine misfired three times during takeoff and lost partial power. The helicopter settled into a rice field and the damaged spray booms became entangled. The helicopter nosed over in the high vegetation. The plt stated the engine accelerated…NTSB DEN88FA121Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Rock Springs, WYShortly after departure on the second leg of a cross country flt the plt informed the fss located on the arpt that he was returning. The fss technician on duty observed the acft turn final at an abnormally low altitude. The acft disappeared from view. The…NTSB NYC88LA152Accident · No injuriesLimited investigationFinal reportBeech H18 · Utica, NYThe flight had departed syracuse airport enroute to plattsburg, new york transporting ups packages. At about 0810 hours, a loss of power on the left engine was experienced and altitude could not be maintained. The pilot informed griffiss control that he could…NTSB FTW88DRG10Accident · Minor injuriesFinal reportPiper PA-28RT-201 · Lampasas, TXThe pilot experienced a partial loss of engine power during cruise, while on a night, VFR, cross-country flight. He attempted to spiral down to an airport for an emergency landing but reported that he became disoriented and attempted to land downwind,…NTSB BFO88FA050Accident · No injuriesField investigationFinal reportEnstrom F-28A · Middletown, DEShortly after takeoff, at an alt of aprx 400 ft, a loud bang was heard and the helicopter developed a moderate to severe vibration. The CFI took control of the helicopter and initiated an autorotation. The helicopter contacted small tree branches and landed…NTSB ATL88FA168Accident · 1 fatalField investigationFinal reportHughes 269A · Ozark, ALThree months prior to the accident a mechanic repaired the left magneto. He reinstalled it and timed it with the right magneto. Both magnetos were found to have advanced timing. Internal examination showed discrepancies which would lead to electrical…NTSB FTW88LA095Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Pipe Creek, TXShortly after takeoff, the engine started running rough. The pilot said he thought he could make the airport and turned toward it. Just short of the airport, the engine quit completely. The pilot was able to get to the airport but crossways to the runway.…NTSB ATL88LA161Accident · Serious injuriesLimited investigationFinal reportHughes 269C · Greenwood, SCThe plt reported that the engine RPM began to drop. Shortly after he took off from an open field. He opened the throttle further in an attempt to regain RPM but the engine did not respond. The helicopter subsequently crashed onto a bldg roof as the plt…NTSB NYC88FA133Accident · 1 fatalField investigationFinal reportBell 206B · Long Island Cty, NYThe Bell 206B was on a sightseeing flight around the Island of manhattan when it experienced a low rotor RPM situation. The pilot said he could not recover rotor RPM and made a forced landing in the east river. The pilot and three passengers exited the…NTSB ATL88LA159Accident · No injuriesLimited investigationFinal reportCessna 150J · Sandy Ridge, NCThe aircraft engine began to vibrate excessively and lost power. The pilot landed the aircraft in a field. The aircraft nosed over in the soft ground. Examination of the engine revealed that the number one cylinder valve spring seat lock had failed allowing…NTSB LAX88FA169Accident · Serious injuriesField investigationFinal reportPiper PA-31-350 · Hayward, CAPilot's failure to detect an uncommanded propeller feathering procedures established in the pilot's operating handbook.NTSB CHI88DEX04Accident · No injuriesFinal reportCessna 172M · Alexandria, INAircraft experienced intermittent engine operation while on final, followed by complete engine failure on landing rollout. Pilot noticed smoke entering cockpit during restart attempt. Aircraft was evacuated by pilot and three passengers. There was an engine…NTSB CHI88LA099Accident · No injuriesLimited investigationFinal reportCessna 150M · Zeigler, ILUpon completion of a practice emergency landing procedure during an instructional flight, the engine started to run rough and then quit. The instructor was able to regain partial power, and made forced landing in freshly plowed field. The aircraft nosed over…NTSB DEN88FA097Accident · 2 fatalField investigationFinal reportCessna 150 · Deer Lodge, MTNTSB MIA88LA147Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Hastings, FLWhile on an aerial application flt shortly after takeoff, the eng lost power. The plt then dumped the load of fertilizer & landed the acft in a field. After touchdown it nosed over & came to rest. Examination of the eng revealed that the no. four cylinder…NTSB SEA88LA071Accident · No injuriesLimited investigationFinal reportCessna 172XP · Walla Walla, WADuring descent for landing the pilot noted a surge coming from the engine area, accompanied by an increase in rpm's. both the oil temperature and the oil pressure gauges were reading zero. The cylinder head temperature had reached 500 degrees and smoke was…NTSB ATL88FA137Accident · 2 fatalField investigationFinal reportBeech C50 · Fayetteville, NCThe pilot reported a fuel pump problem to Fayetteville tower and requested landing. The pilot was cleared to land on runway 04. The controller noticed that the pilot had not lowered the landing gear. The pilot was questioned concerning the gear. Instead of…NTSB MKC88LA062Accident · No injuriesLimited investigationFinal reportGrumman G-164B · West Point, ARThe pilot said, shortly after takeoff, enroute to an aerial application operation, the engine began to lose pwr and began backfiring. He dumped a portion of his load, and made an emergency ldg in a soft, unplanted bean field. After rolling about 200 feet, the…NTSB MKC88LA061Accident · No injuriesLimited investigationFinal reportBeech A36 · Cherokee, IAThe plt stated, that shortly after takeoff, the engine lost substantial pwr. Afterwards there was smoke in the cockpit. The PIC reversed his course with the intent to land on the departure arpt. When he felt he had the ldg field made, he attempted to lower…NTSB MIA88LA126Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Dorado, PRWhile on a personal flt in normal cruise at an alt of 1000 ft aprx 2 miles southeast of the arpt, the eng began to misfire and the cabin filled with smoke. The plt elected to land in a clearing. The plt also stated that the eng was losing pwr and tht a/c…NTSB ANC88LA039Accident · No injuriesLimited investigationFinal reportCessna 207 · Ruby, AKThe aircraft was over the airport at 2,000 feet MSL when the engine quit. The aircraft crashed one mile north of the airport. Examination of the aircraft engine revealed a broken throttle control which would cause the engine to go to idle.NTSB NYC88DGT01Accident · 1 fatalFinal reportNorth American F-51D · State College, PAN51WE, a North American F-51D took off as the second ship of a two ship flight with N6341T, another F-51D. They were observed climbing in formation into the clouds. N6341T assumed communications and said they were a flight of 2 and ok, after ATC was unable to…NTSB CHI88DEM01Accident · Minor injuriesFinal reportNorth American T-28A · Schoolcraft, MIWhile the pilot was climbing through 7800 MSL he noticed a vapor trail coming from the right exhaust area. The pilot notified approach control that he was returning to the departure airport and they supplied radar vectors. The pilot started a descent and…NTSB NYC88LA090Accident · Minor injuriesLimited investigationFinal reportStinson 108 · Oswego, NYDuring a local pleasure flight, a decrease in engine power was experienced and a puff of smoke observed in the cockpit. The pilot applied full power in an attempt to return to the airport, but realized it was not possible. The pilot put the aircraft down in…NTSB DEN88LA069Accident · No injuriesLimited investigationFinal reportCessna 172N · Englewood, COThe private plt was practicing landings at centennial airport, denver, Colorado. Rnwy 17L, an asphalt rnwy 8,500 feet long and 101 feet wide, was in use. The plt reported that when he attempted to add power on final approach, the throttle cable would not…NTSB NYC88LA076Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Williamstown, NJThe flight departed runway 27 at cross keys airport and upon reaching 250 feet altitude, the engine lost power and began vibrating. The pilot maneuvered to return to the airport but was unable to reach it. The aircraft crashed in a yard about 1/2 mile from…NTSB NYC88LA071Accident · No injuriesLimited investigationFinal reportCessna 402B · Bangor, METhe crew rprtd that drg takeoff, a power surge occurred after the acft had climbed about 400 to 500 ft. the coplt saw what he later said was a right fuel flow fluctuation & told the plt (PIC) that the right eng was losing power. The PIC told the coplt to…NTSB FTW88DRA02Accident · No injuriesFinal reportCessna 180 · Beaumont, TXAcft experienced a power loss while in cruise flt at 500' AGL on an aerial pipeline patrol flt. An off-arpt emergency lndg was made in rough terrain and the acft was substantially damaged. Investigation revealed that the carb heat gate valve would only close…NTSB CHI88LA043Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Stanley, WINTSB FTW88LA045Accident · Minor injuriesLimited investigationFinal reportAero Commander 100-180 · Mineola Quitman, TXDuring a practice touch and go landing, the engine back fired and then surged. At about 150' AGL the engine RPM dropped about 80% and the pilot attempted to make an emergency landing in an open field. The aircraft flew over a trash dump and between two trees.…NTSB DCA88MA011Accident · 6 fatalMajor investigationFinal reportPiper PA-31-350 · Kenai, AKThe pilot had just departed the runway when he reported to the flight service station that he had engine problems. The aircraft was observed by witnesses to be about 300 ft on a descending downwind. The pilot stated that he was circling for runway one.…NTSB FTW88DRG04Accident · 1 fatalFinal reportMBB 109 · Harlingen, TXThe set of floats which allows a high fuel flow in this carburetor for high power settings used for takeoff, climb, etc., had cracked and swollen to such an extent that they were rubbing against the float chamber walls and float chamber shroud tubes. This…NTSB MIA88LA059Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Daytona Beach, FLAlthough the plt stated that he performed a preflt & eng runup prior to departure with no problem noted, shortly after takeoff, while climbing through 350 ft, the engine RPM dropped to & stayed between 1500 & 1600. The plt was unable to maintain altitude…NTSB MIA88LA046Accident · Serious injuriesLimited investigationFinal reportCessna 172P · New Port Richey, FLThe pilot experienced an engine failure due to a heavily coked #4 cylinder exhaust valve while on climb out at 500 ft AGL. He attempted a turn back to the airport and stalled in the turn and crashed.NTSB LAX88LA062Accident · No injuriesLimited investigationFinal reportBeech P35 · Maricopa, CADuring a pleasure cross country flt, a precautionary landing was made due to smoke in the cockpit and a low oil pressure indication. After landing, it was found that the oil line to the oil pressure gauge was broken. After repairs, the plt took off and 10…NTSB LAX88LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · San Clemente, CAA partial loss of eng power occurred while the student plt was on a solo x-country flt. He applied carb heat, but to no avail. The eng continued to run rough & the plt made an emergency landing on upward sloping terrain. During the landing roll, the nose gear…NTSB SEA88IA017Incident · No injuriesIncident investigationFinal reportBeech E18S · Reno, NVShortly after takeoff, and after the landing gear was raised, the pilot noticed an over-temperature of the right engine. A power reduction was made and afterwards symptoms of a compressor stall occurred. The pilot then shut down the right engine. A 180 degree…NTSB NYC88LA031Accident · No injuriesLimited investigationFinal reportCessna 172 · Stamford, CTThe instructor (CFI) reported that the aircraft had just reached the top of a climb at 2500 ft when the engine lost power. An off airport landing was made on a golf course. During the landing, the wings struck trees and the aircraft was damaged. The golf…NTSB NYC88LA017Accident · Minor injuriesLimited investigationFinal reportPiper J-4 · St. Paul, PAThe flight was enroute from mount pleasant to winchester, Virginia on a heading of 140 degrees and at 4500 feet. About 25-30 minutes into the flight, engine power loss was experienced. The pilot switched from the auxilliary to the main fuel tank and applied…NTSB FTW88DRD01Accident · No injuriesFinal reportGrumman G-164A · Port Allen, LAThe pilot experienced a partial loss of power during pull-up from a swath run. He attempted to return to the field he was working in order to make an emergency landing but was unable to due to inadequate engine power. He landed in high vegetation and flipped…NTSB CHI88IA003Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-40 · Milwaukee, WIAircraft landed without further incident after exhaust centerbody fell away from the #1 engine during initial climb. The centerbody landed on private property with no property damage. A service bulletin issued by the manufacturer to inspect the centerbody and…NTSB MIA87LA253Accident · No injuriesLimited investigationFinal reportCessna TU206F · Tavernier, FLThe acft ditched in the atlantic about 40 mi e of Tavernier, FL during an extended overwater flt to georgetown, Bahamas. The acft sank after the accident & the plt & his pax were rescued by the USCG unharmed. The fixed base operator where the acft departed,…NTSB LAX87DVA12Accident · No injuriesFinal reportGrumman G164B · Buttonwillow, CADuring an aerial application flight, after pulling out of a pass over a field the plt heard a loud bang followed by severe engine vibration. The acft lost power and the pilot made a forced landing in a plowed field. During the landing roll the acft nosed…NTSB CHI87LA217Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-300 · Hillsdale, MITkof and climb to 7000 ft were made on the left fuel tank. Shortly after lvl-off, the plt switched to the rt tank and stayed on it during the initial cruise. The plt then switched back to left tank and abt 10 min later the eng began to lose pwr. Readings were…