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 MIA85LA083Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Loiza, PRThe helicopter plt had just discharged his passengers following a flt from an off-shore barge to a beach heliport. When he lifted off & started to cross over a fence, the eng lost partial power. The plt tried to avoid the obstruction, but the tail boom hit…NTSB NYC85LA053Accident · No injuriesLimited investigationFinal reportCessna C207 · North East, PAThe acft was damaged during a forced landing in a grape vineyard. The plt stated that a ttl loss of pwr occurred during an apch to erie int'l arpt while passing through 3200 ft MSL. The plt performed emergency procedures and was able to regain partial pwr…NTSB MIA85LA061Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Hollywood, FLThe eng lost pwer at aprx 400 ft AGL in a left climbing turn after takeoff from rwy 09L. The plt continued the left turn in an effort to land on rwy 18L. Easterly winds caused the acft to overshoot and land on grass on the west side of the arpt. During the…NTSB DEN85LA046Accident · No injuriesLimited investigationFinal reportCessna 401A · Raton, NMAbout 2 hrs after departure, at 13,000 ft, the right eng fuel flow went to zero. The eng continued to operate INDICATING24 inches of manifold pressure. All other instruments were normal but what looked like a brown stain developed on top of the right wing…NTSB MKC85LA033Accident · No injuriesLimited investigationFinal reportRockwell S-2R · West Helena, AROn departing West Helena arpt the plt reduced pwr to a cruise pwr setting. The engine responded to the pwr reduction but then the torque dropped to zero. The acft descended striking the ground. Inspection and testing of the engine and fuel control unit did…NTSB CHI85LA060Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Allegan, MIThe plt stated he lost power on takeoff, but elected to takeoff rather than abort. He cleared wires but decided he could not clear trees & made a forced landing in a corn field. Inspection of the acft revealed that the fuel control rod cotter pin was…NTSB ATL85LA042Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Murphy, NCThe CFI and student plt initiated a go-around from a simulated forced landing when the eng failed to respond to the application of power. In order to avoid colliding with trees the CFI turned right towards a corn field. Ground impact occurred right wing low…NTSB MKC85LA018Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Algona, IAAt about 100 ft AGL after takeoff, eng lost pwr. Plt attempted to circle to land on closest runway but eng was developing insufficient pwr to maintain altitude in turn. Acft touched down 150 ft short of threshold. Plt did not level wings prior to touchdown.…NTSB MKC85LA013Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Springfield, MOThe acft collided with trees during a forced landing, while on a dual instructional flt. The CFI said after the climb tocruise the eng began to slow dwn. The CFI took control of the acft to return to arpt of departure. He said the vibrationwas excessive as…NTSB CHI85LA040Accident · No injuriesLimited investigationFinal reportCessna 150M · Wyatt, INWhile practicing ground reference maneuvers at 800 ft AGL the engine power dropped from 2,500 to 1,500 RPM. During the forced landing rollout the nose gear collapsed when it contacted a dirt bank. Investigation revealed that the throttle control rod end bolt…NTSB FTW85LA027Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Lipan, TXAcft experienced a partial eng failure in flight. During the forced landing, the nose gear dug into terrain and the acft flipped over. Investigation revealed that the no. 3 cyl barrel was cracked about 90% around the circumference. Metallurgical examination…NTSB CHI85IA032Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10-30 · Chicago, ILShortly after takeoff, the flight crew heard a noise from the right side of the aircraft, which sounded like an engine compressor stall. The #3 engine was shut down & the crew made an uneventful landing at the departure airport. Pieces of cowling from the…NTSB FTW85LA029Accident · No injuriesLimited investigationFinal reportDouglas DC3C · El Paso, TXDue to low oil pressure and high oil temp the right eng was secured. During the precautionary landing gear extension was delayed until aprx 800 ft AGL. Since the right eng powers the only hydraulic pump a landing gear down and locked condition was not…NTSB MIA85IA014Incident · No injuriesIncident investigationFinal reportBellanca 17-31A · Palm Coast, FLThe plt stated that while in cruise flt, the acft sustained a partial loss of power & he elected to land on a road. During the landing the lt wing hit a sign. Post crash investigation revealed that the magneto coils were heating up.NTSB FTW85LA002Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Progreso, TXShortly after takeoff, plt heard explosive report from engine and experienced partial pwr loss. Plt attempted to return for landing but could not maintain sufficient altitude. Load not jettisoned. During forced landing roll out in cane field acft nosed over.…NTSB SEA84IA233Incident · No injuriesIncident investigationFinal reportBoeing 747-200B · Seattle, WADuring climbout, passing thru 4000 ft MSL, the acft experienced a failure of the #2 engine. The crew reported hearing an explosive sound followed by a drop in fuel flow with N1 speed decreasing to 30% RPM on the #2 engine. The acft returned to Seattle for an…NTSB MIA84FA265Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Bryceville, FLFlt departed in instrument meteorological conditions. After departure plt failed to maintain assigned headings several times and had to be corrected by ATC. After 15 mins of flight the plt reported he was having problems with the right engine and would like…NTSB MIA84LA262Accident · No injuriesLimited investigationFinal reportThomas Pitts Special S1-SP · Niceville, FLDue to failure of the engine throttle linkage the engine decelerated to idle power. The plt elected to perform a forced landing in a bayou.NTSB ATL84LA293Accident · No injuriesLimited investigationFinal reportGrumman AA5-B · Luka, MSDuring normal cruise flight the number one cylinder exhaust valve head separated from the valve stem causing a significant power loss. The pilot set up a landing approach to a farm field. On final approach the pilot noticed that rough and rising terrain…NTSB FTW84FU009Accident · 2 fatalFinal reportMitchell T-10R263 · Mckinney, TXAccording to a person who helped assemble the ultralight vehicle for flt, the base of the clouds were at about 200 ft AGL, when the plt took off. The helper expected the plt to return & land due to the wx; however, the vehicle crashed in a wooded area. There…NTSB MIA84LA257Accident · No injuriesLimited investigationFinal reportCessna 152 · Orlando, FLThe flt experienced eng failure and made a forced landing in a field, substantially damaging the aircraft. Post crash examination of the engine revealed the number three connecting rod separated from the crankshaft when the connecting rod bolts failed.…NTSB DEN84FU010Accident · Serious injuriesFinal reportWeedhopper B · Erie, COThe ultralight engine lost power while the plt was in a practice area. He returned to the arpt, and during the attempt to land, the acft crahsed. An instructor said the acft seemed to be flying slower than normal and the plt extended the downwind turn to base…NTSB LAX84LA476Accident · No injuriesLimited investigationFinal reportCessna 152 · Rialto, CAThe plt stated that this was the first flt after the eng had been overhauled. During the takeoff climb at an alt of 500 ft the eng lost pwr. The plt made a hard landing adjacent to the rwy. Exam of the eng after the accident revealed the exhaust rocker arm…NTSB CHI84LA387Accident · No injuriesLimited investigationFinal reportMooney M20E · Lansing, ILThe plt had just demonstrated the acft for sale and filed an IFR flt plan. Run up and pre-takeoff checks were rushed to beat void clearance time. Just before liftoff, plt noted sluggish acceleration but believed insufficient runway remained to successfully…NTSB LAX84LA470Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · San Jose, CAAt 100 to 150 ft AGL eng RPM decreased to about 1,500. A turn back to the arpt was initiated. On short final the left wingtip struck a fence causing the acft to cartwheel to a stop on arpt property. Eng exam revealed that the #2 cyl was developing no…NTSB ATL84FA277Accident · Serious injuriesField investigationFinal reportBell 222 · Knoxville, TNThe helicopter was in a hover when a rt pedal turn was initiated and a climb attempted. Plt stated, 'I was unable to climb, and the aircraft began to lose rotor RPM. I increased power to 100% mrtq. The acft was settling.' Unable to sustain flt, a landing was…NTSB BFO84IA004Incident · No injuriesIncident investigationFinal reportBeech 58 · Washington, DCThe plt made an emergency landing on rwy 18 following a loss of power in the rt eng & a subsequent in-flight fire. Investigation revealed a crack in the #1 cyl that originated at the exhaust port, downstream of the valve. The crack propagated through fatique…NTSB MKC84FCA02Accident · Serious injuriesFinal reportMooney M20E · Chesterfield, MOThe acft crashed short of the rwy after making a 180 deg turn after takeoff following a loss of power. The plt stated that after takeoff & at an indicated airspeed of 100 to 110 mph, at an altitude of 50 ft, the acft eng started to lose power. He decided to…NTSB DEN84LA270Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Grand Forks, NDDuring initial takeoff climb at an alt of aprx 100 ft AGL, engine began missing. Unable to maintain alt, forced landing was made in a plowed field during which landing gear was torn from the acft. Inspection revealed #5 cylinder head separated from the…NTSB NYC84LA292Accident · Minor injuriesLimited investigationFinal reportCessna 152II · Mercer, PADuring takeoff from ballard field the engine lost partial power. The acft struck a power line during descent, abruptly losing airspeed, and then striking the ground. Post accident investigation revealed the engine spark plug gaps were too wide.NTSB MIA84FA234Accident · Serious injuriesField investigationFinal reportPiper PA-46-310P · Vero Beach, FLOn post-production test flt, plt noted symptoms of uncommanded lean mixture and turned to return for landing. En route to airport, eng lost pwr completely. On base leg for forced landing (off airport) fire broke out in eng area and burned through hydraulic…NTSB LAX84LA445Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · San Joaquin, CAThe Air Tractor was on takeoff initial climb and was about 20 ft high when the engine began to backfire. The aircraft settled into the cotton field and rotated about 90 degrees after ground contact. The plt reported that the number one cylinder was found to…NTSB SEA84LA199Accident · No injuriesLimited investigationFinal reportRockwell Thrush SR2 · Nampa, IDThe acft began to lose power while engaged in aerial application so the plt dumped his load and headed for the airstrip. Enroute the power deteriorated so the plt elected to land. Cutting the mixture gave the engine a surge which caused an overshoot into…NTSB MKC84LA250Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Swifton, ARDuring a swath run the #9 cylinder on the radial engine separated. A forced landing was made during which the acft landed in a levee and nosed over.NTSB ATL84FA252Accident · Minor injuriesField investigationFinal reportBoeing A75N1 · Cumming, GAThe acft experienced a partial pwr loss during takeoff. The pilot released the banner the acft was towing, made a left turn into a valley and collided with a ditch during a forced landing. Investigation revealed maintenance deficiencies in both the carburetor…NTSB ATL84FA251Accident · 3 fatalField investigationFinal reportDouglas DC3C-S1C3G · Memphis, TNMoments after the DC-3 took off, the twr ctlr noted the l eng was torching & asked the flt if it was 'having a problem.'the crew replied 'affirmative,' then the ctlr clrd the flt to lnd on any rwy. The acft began turning left at the end of the rwy & contd…NTSB SEA84LA197Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Prineville, ORWhile maneuvering plt heard a loud chatter coming from the engine accompanied by a loss of power. Plt reduced remaining power and initiated a forced landing in a rough barley field. Post accident investigation revealed the crankshaft broke near the number two…NTSB ATL84IA246Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-30 · Nashville, TNDuring the climb-out, a 15% decrease in the right eng epr was noted by the flt crew. This was followed by a loud bang & failure of the #2 eng. The #2 eng was shut down & the acft was flown back to the departure arpt. An initial exam revealed that the right…NTSB CHI84LA332Accident · No injuriesLimited investigationFinal reportArnold Forest Quickie 2 · Grantsburg, WIThe acft made one forced landing after engine trouble. The plt cleaned the fuel filters and took off for a test flt. The engine failed during takeoff. Post accident inspection of the engine showed it would run but the oil pressure was very low.NTSB ATL84LA240Accident · Minor injuriesLimited investigationFinal reportEagle DW-1 · Franklin, GAFlying cross-country on a special ferry permit (the aircraft's annual inspection had expired) the pilot reports a gradual decline in power occurred until altitude could no longer be maintained. A forced landing was accomplished on apublic road, but the pilot…NTSB SEA84LA192Accident · No injuriesLimited investigationFinal reportGrumman AA-5 · Klamath Falls, ORThe pilot stated that the run-up and takeoff were normal but during the climbout the engine lost power. A small fire, confined to the engine compartment erupted. Power could not be restored and an emergency landing was accomplished in an open field.…NTSB DEN84LA245Accident · No injuriesLimited investigationFinal reportConsolidated-Vultee BT-13B · Hobbs, NMAs part of a group of a confederate air force acft the flight conducted public relations flyovers at several area arpts. Due to a low ldg gear strut N63697 did not land with the other acft after the flyovers. The plt planned to have the strut repaired upon…NTSB MKC84FA234Accident · 2 fatalField investigationFinal reportSims - Basset Varieze · Clarinda, IAWitnesses observed a ground run of aprx 2000 ft before lift-off was achieved after which the acft appeared to climb laboriously to about 100 ft AGL. Acft then executed steep, descending rt turn of about 240 degrees back toward the arpt. Acft collided with pwr…NTSB DEN84LA240Accident · No injuriesLimited investigationFinal reportCessna 310Q · Havre, MTDuring cruise flight with five adults and two infants on board, the pilot noted left engine oil pressure decreasing and a visible oil leak. Engine shutdown and propeller feather were accomplished but altitude could not be maintained. A forced landing was…NTSB MIA84LA210Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Ponce, PROn initial climb, right engine power loss occurred. Plt executed emerg procedures, attempted gradual circuit to land. Unable to maintain sufficient altitude to clear known obstructions on runway approach. Plt elected to make a gear-up landing in cane field.…NTSB DEN84LU009Accident · Minor injuriesFinal reportEipper Quicksilver MXL · Erie, COThe ultralight was proceeding in a normal takeoff when the engine lost partial power at about 100 ft AGL. The plt turnedthe vehicle to avoid trees and a river. During the hard forced landing, the vehicle was damaged and the plt hurt his leg. Post accident…NTSB LAX84LA410Accident · No injuriesLimited investigationFinal reportCessna 152 · Salida, CAFailure of the number 3 exhaust push rod caused the power loss. The CFI took control of the acft and performed a forced ldg on a private airstrip. Due to a higher than optimum approach the acft landed long, overran the end of the rwy and collided wiht trees.NTSB MKC84FA221Accident · 1 fatalField investigationFinal reportMorgan T. Melton SKY Rider · West Plains, MOThe owner/bulder stated that he & his brother had been having an eng problem which they assumed was due to a vapor lock. They had installed a metal box around the electric fuel pump to insulate it from the heat of the exhaust pipe. The brother initiated a hi…NTSB MKC84LA211Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Roe, ARAs a result of a supercharger failure, a partial power loss was experienced during a swath run. During the landing roll after a forced landing, the acft nosed over & came to rest inverted. An eng teardown revealed that both supercharger bearings had failed…NTSB LAX84LA397Accident · No injuriesLimited investigationFinal reportCessna 172 M · Woodland Hills, CAThe acft made a forced landing on city street after a partial power loss. The private plt was carrying passengers and had reportedly not briefed them on emergencies. He also did not fasten his shoulder harness because he did not know how to connect it. After…