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 MIA87LA249Accident · No injuriesLimited investigationFinal reportMooney M20J · Macclenny, FLWhile en route at 8000', the eng lost power & the plt obtained vectors for an emerg landing at an arpt with a grass strip. Drg the roll-out, the left wing tip hit a hay wagon near the end of the rwy, then the acft veered & struck a hangar. An exam of the…NTSB CHI87LA211Accident · No injuriesLimited investigationFinal reportCessna 172K · Jefferson, WIThe aircraft was en route on a personal cross country flight when it experienced an engine failure and was forced to make an emergency landing in an alfalfa field. The aircraft landed long and collided with a telephone pole and fence at the end of the field.…NTSB LAX87DJA09Accident · No injuriesFinal reportEmair MA-1-B · Paauilo, HIDuring an aerial application flt, just after take off, the plt noted that the engine oil temp was high and that blue smoke was coming from the engine. Unable to land at the airport, the acft collided with the terrain short of the runway and nosed over.…NTSB MIA87LA233Accident · No injuriesLimited investigationFinal reportAyres S2R-600 · Leland, MSWhile in cruise flight en route to a field for aerial application the engine lost power when the number one cylinder cracked between the spark plug holes. While maneuvering to land at a sod airstrip altitude could not be maintained and the left spray boom…NTSB LAX87LA312Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA-5A · Tucson, AZThe plt reported that just after takeoff, the engine lost partial power & he was unable to land back at the airport. During an emergency landing, the aircraft collided with a utility line & pole. An exam of the engine revealed that a rocker arm on the #4…NTSB ATL87DEK03Accident · No injuriesFinal reportEmbree Sonerai II · Cambridge, OHWhile in the traffic pattern, the plt retarded the throttle to idle & established a glide speed. When he re-advanced the throttle, there was no response from the eng. The plt said he 'headed straight for the overrun to runway 4, but could not make it that…NTSB ATL87DLQ04Accident · No injuriesFinal reportPiper PA-28-140 · Falmouth, KYThe plt, with a pax, had been making touch and go landings at the LCL apt for about 40 min. The final t.o. was preceded by a full stop ldg. Shortly after lift off, the plt reptd that the acft lost pwr and he was unable to clear a tree at the top of a ridge…NTSB MKC87LA160Accident · No injuriesLimited investigationFinal reportNorth American Navion · Chillicothe, MOThe PIC was ferrying the navion to a distant location to undergo an annual insp. Abt 20 min into the flt, the PIC rptd experiencing eng pblms. The PIC was able to fly to a nearby arpt for a precautionary lndg. Instead of making the lndg the PIC went around to…NTSB MKC87DCA03Accident · Serious injuriesFinal reportBurkholder Q-2 · St Charles, MODrg takeoff, the eng began to run rough at an estd alt of 50 to 100 ft AGL & would not developed enough power to maint flt. Subsequently, as the plt was lndg in a soybean field, the acft flipped over & came to rest in an upright attitude. A teardown of the…NTSB DEN87LA206Accident · No injuriesLimited investigationFinal reportBell 206B · Albuquerque, NMDuring cruise flt a partial power failure occurred requiring a full emerg autorotative landing to be conducted to an uneven dirt area. Following touchdown the acft slid forward and the tail rose causing the main rotor to contact the tail boom severing the…NTSB LAX87LA275Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Milpitas, CAWhile climbing to cruise plt heard a loud knocking noise followed by 'violent vibrations' & a loss of power. Plt made a frcd lnding in a newly excavated construction site & went over an embankment. Inves revealed deformation of the #4 cylinder valve cover. #4…NTSB MKC87LA136Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Ottawa, KSDuring a night flight the aircraft's engine lost partial power. The pilot elected to make a precautionary landing in a farm field. During landing the aircraft's right wing struck a fence. An engine teardown revealed a failed exhaust valve on the number 3…NTSB FTW87DRA06Accident · No injuriesFinal reportGrumman G-164B · Beaumont, TXDrg the initial climb after takeoff, the eng began losing RPM & the plt was unable to return to the arpt. He selected a pasture area for an emerg landing, but the eng contd losing power. While landing on soft terrain with tall wet grass, the acft nosed over.…NTSB DEN87LA179Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Kalispell, MTThe pvt plt was on a x-country flight. The engine began running rough, made a 'bang' sound and lost partial power. Smoke entered the cockpit, oil pressure was lost and the plt initiated an emergency landing. The acft ldg gr struck powerlines on approach to a…NTSB DEN87LA173Accident · No injuriesLimited investigationFinal reportBeech B-60 · Kanab, UTThe commercial corporate plt had deplaned his passengers and was beginning the second leg of a corp/exec flight. During ground run the plt detected a manifold pressure loss on the left engine. The plt aborted the takeoff and applied heavy braking. The…NTSB SEA87LA125Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-300 · Bend, ORShortly after takeoff a partial loss of power occurred and the pilot was not able to maintain altitude and airspeed. The pilot was not able to retract the gear due to the low airspeed because the automatic gear extension system was not in the override…NTSB LAX87LA242Accident · No injuriesLimited investigationFinal reportCessna 310R · Kailua, HIA Cessna 310R ditched in the pacific ocean aprx 500 NM sw Hawaii after an eng failure. The plt indicated that the #2 eng failed while in cruise flt at 8,000 ft MSL. Oil was observed leaking from the eng cowling. The acft was unable to maintain alt on #1 eng.…NTSB ATL87LA177Accident · No injuriesLimited investigationFinal reportCessna 150M · Goldsboro, NCStudent plt had dep apt for purpose of practicing ldgs. At about 400 ft he noted a pwr loss and rough running eng. He reduced the throttle setting and the roughness contd. Further reductions were made to the point where flight could not be maintained. The…NTSB NYC87LA175Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Croton Fall, NYAbt 15 minutes aft tkof, the eng started to lose pwr. All efforts to restart it were unsuccessful and the acft was forced to land in a landfill. During lndg roll the acft collided with a hole and the gear sheared off. Exam of the eng revealed a burned piece…NTSB SEA87LA111Accident · Minor injuriesLimited investigationFinal reportde Havilland DHC-2 MK.1 · Sedro Woolley, WAShortly after takeoff a loss of power occurred and the aircraft struck trees in flight. Less than 1/2 fuel was available in all three fuel tanks. The fuel selector valve was tested and found that the selections plate was indexed off center for all selections…NTSB FTW87DRA03Accident · No injuriesFinal reportGrumman G-164B · Egypt, TXAcft experienced a power loss drng an aerial app maneuver. During the ensuing emerg lndg, the left wing struck high weeds on the shoulder of a road, veered left into a ditch, and flipped over. Investigation revealed no. 7 cylinder had a pre-existing crack in…NTSB MKC87LA119Accident · Serious injuriesLimited investigationFinal reportBeech B35 · Keokuk, IAThe PIC rptd a loss of manifold press during cruise flt and an inability to maintain alt. A forced lndg was made to the Keokuk arpt, but the PIC stated he was too high and fast for a lndg. The PIC made a go-around, but again approached too fast. Another…NTSB MKC87LA115Accident · No injuriesLimited investigationFinal reportAyres S2R600 · Lepanto, ARThe PIC had taken off for a LCL aerial operation. Enroute PIC had an engine failure and made a forced ldg in a muddy field. PIC applied brakes and acft nosed over. The exhaust rocker arm box on no. 3 cylinder was found to be cracked keeping exhaust valve in…NTSB LAX87LA208Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Turlock, CAApproximately 15 minutes into a pleasure flight, the engine experienced a partial loss of power. The pilot made an emergency landing at a nearby airport, where upon landing the aircraft ran off the runway and collided with a bush. Inspection of the engine…NTSB LAX87FA207Accident · Serious injuriesField investigationFinal reportCessna 182L · Santa Monica, CAThe acft lost power during initial climb and crashed on a residential street during an attempted forced landing. The throttle arm was found separated from the throttle shaft. The arm had been replaced 19 hours prior to the accident. Examination of the…NTSB MKC87LA099Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Meade, KSAfter takeoff, the engine started losing power. During the turn toward a landing area, the airplane stalled, hit the ground to the right of the runway and flipped forward to the inverted position. A partial tear down inspection revealed that the intake valve…NTSB ATL87FA123Accident · 2 fatalField investigationFinal reportSwearingen SA-226TC · Wilmington, NCThe right engine failed during takeoff immediately after rotation 3000' down the 7,002' rwy 16. The plt continued the flt and the landing gear remained extended. The unauthorized plt rated pax made xmissions to the tower. Witnesses rpted that the acft reached…NTSB DEN87FA110Accident · Serious injuriesField investigationFinal reportPiper PA-23 · Craig, COThe plt and his wife were on a cross country flt to visit relatives in north carolina. Several witnesses observed the aircraft depart Craig-moffet airport with the engine(s) running rough and using almost the entire runway to get airborne. Once airborne the…NTSB MIA87IA141Incident · No injuriesIncident investigationFinal reportBell 222U · Oxford, MSThe pilot executed a precautionary landing after hearing a loud bang and experiencing a loss of the number 1 engine. Post accident examination revealed that the power turbine wheel blades had failed, and the wheel parts logjammed and penetrated the engine…NTSB MIA87LA138Accident · Serious injuriesLimited investigationFinal reportCremer VP-1 · Tupelo, MSAcft lost engine power on short final approach. Acft stalled and touched down hard short of the runway. The acft then collided with the raised edge of the runway collapsing the main gear and then nosing over. The pilot attributed the loss of engine power to a…NTSB ATL87LA116Accident · No injuriesLimited investigationFinal reportCessna 177 · Brookville, OHThe plt reported a partial pwr loss at about 30 ft AGL during the initial takeoff climb. He elected to land straight ahead in a soft, plowed field. The acft nosed over during the landing. Post accident inspection revealed evidence of water in the fuel lines.NTSB NYC87FA121Accident · Minor injuriesField investigationFinal reportCessna 402C · Hyannis, MAShortly after the initial pwr reduction drg tkof, the plt noted a partial loss of pwr in the rgt eng. He said he 'went to full power on both engines' & noted an 'extremely high' fuel flow indcn to the rgt eng. He said, 'thinking that the engine was flooding,…NTSB DEN87LA094Accident · No injuriesLimited investigationFinal reportHughes 269C · Scoffield, UTThe plt and his brother were on a long cross country flt, through mountainous terrain. After one hour of flt and while flying at 8,000 feet the plt noticed a change in engine noise and the acft had a partial power loss. The plt elected to autorotate to a snow…NTSB CHI87DER04Accident · Minor injuriesFinal reportPiper PA-32-260 · Pine Center, MNAfter noticing a loss in oil pressure, the pilot initiated an emergency landing in a swamp. The aircraft impacted trees and received substantial damage. The pilot reported minor injuries. Subsequent investigation revealed that the oil sump contained several…NTSB DCA87MA024Accident · 5 fatalMajor investigationFinal reportLockheed L-382G · Travis Afb, CACrashed in steep left turn drg go-around after balked landing. Instructor took controls and initiated go-around after student lndd in improper attitude. Engines number 1 & 2 failed to respond when throttles advanced. Both engines decelerated. Airspeed…NTSB FTW87DPJ06Accident · No injuriesFinal reportAir Tractor AT301 · El Dorado, OKThe pilot stated that during takeoff from a county road, black smoke started coming out of the engine exhaust. The aircraft then collided with a tree and a post causing substantial damage. It was found that the carburetor heat system had been modified and the…NTSB LAX87FA151Accident · Serious injuriesField investigationFinal reportCessna T210K · Prescott, AZAfter overloading the aircraft with 5 pax and baggage, the pilot departed on a personal cross country flight to phoenix, AZ. He climbed the acft to and maintained an altitude of 14,500 feet MSL until reaching salt lake city, UT. The aircraft was then…NTSB CHI87DEC02Accident · Minor injuriesFinal reportCessna 172G · Linden, MIThe student pilot was attempting to land when he decided he was too high, and aborted the landing attempt. The engine failed to develop power despite throttle and mixture adjustments, and the pilot made a forced landing in a cornfield. Examination of the…NTSB FTW87DPJ04Accident · No injuriesFinal reportAir Tractor 301 · Oluskee, OKDuring aerial application the engine sustained a power loss due to separation of the number 9 cylinder head. During the forced landing in rough terrain the aircraft was substantially damaged.NTSB LAX87LA140Accident · No injuriesLimited investigationFinal reportHughes 269D · Palmdale, CADuring an external load operation, the engine lost power. The aircraft collided with the terrain and rolled over. Inspection of the engine revealed an overtemperature to the first and second stage turbine wheel airfoils.NTSB ATL87LA084Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Leslie, GAThe plt reported losing power shortly after takeoff; a forced ldg was subsequently made in a freshly-plowed field where the acft flipped over. Examination of the engine revealed a cracked #7 cyl head. FAA service difficulty reports (sdr's) indicated that…NTSB MIA87LA092Accident · No injuriesLimited investigationFinal reportPiper J5A · Brooksville, FLShortly after take off the eng began to lose power. Unable to maintain alt a forced landing was made in a field, during which, the acft sustained substantial damage. Inspection of the acft revealed that the loss of power was the result of an insufficient fuel…NTSB LAX87LA113Accident · No injuriesLimited investigationFinal reportCessna 152 · Tucson, AZDuring a local dual instructional flight, the pilot reported that the aircraft developed a vibration and a substantial power loss. The acft was forced to land off the arpt in the high vegetation. Examination of the aircraft revealed that the #3 cylinder was…NTSB MIA87LA072Accident · No injuriesLimited investigationFinal reportCessna 150L · Bunnell, FLThe plt stated that he was forced to land in a field due to a drop in eng RPM, & the inability to maintain alt. On touchdown, the acft collided with trees, after which the nose gear collapsed, the acft nosed over, & came to rest inverted. Investigation…NTSB CHI87FA058Accident · 1 fatalField investigationFinal reportPiper PA-31T · Merrillville, INThe acft was enroute to the chicago midway arpt. While letting down to 16000 ft the pilot reported he was shutting down the right eng. ARTCC cleared the acft to 5000 ft. ten minutes later ARTCC lost radio transponder and mode c contact. 15 minutes later the…NTSB MIA87FA046Accident · 2 fatalField investigationFinal reportHughes 369HS · Zephyrhills, FLA witness stated that she heard the eng on the helicopter quit. She looked out her window and watched the helicopter hit the ground, bounce, hit again, flip over and the tail broke off. The helicopter then burst into flames and exploded. Exam of the eng…NTSB FTW87LA028Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-180 · Montgomery, TXA private pilot check ride was interrupted by a forced landing on a golf course after having experienced severe vibrations and a loss of power. During the forced landing the acft collided with a 10 ft tall tree and nosed down to terrain impact. Investigation…NTSB MKC87LA028Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B-600 · Earle, ARThe pilot stated that the powerplant was performing normally during initial climb when, suddenly, the engine experienced a power loss after backfiring. Immediate remedial action resulted in a partial power output but not enough to sustain flight. Emergency…NTSB ATL87IA034Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-101 · Atlanta, GAAt about 4,000 ft MSL, cpt on sch dom flt reported loud pop and sub shutdown of rt eng. Smell of smoke and visual confirmation of fire in rt nacelle. Ships fire ext activated during return to dept. Arpt. Landed without further incident. Investigation revld…NTSB LAX87LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Waipahu, HIThe plt dragged both wings through a sugar cane crop during landing roll on a gravel road after a partial loss of power. The engine had 4040 total hours and had been previously overhauled 1655 hours prior. The plt indicated that the eng had a top overhaul…