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 DEN86FTM02Accident · Serious injuriesFinal reportDenney Aerocraft Kitfox · Ogden, UTShortly after takeoff, the acft had a partial power loss. The left wing then dipped sharply & the acft entered a steep nose low descent & crashed on the nw corner of the arpt. An investigation revealed a noise suppressor was installed on one of 2 spark plug…NTSB FTW86FA079Accident · 6 fatalField investigationFinal reportCessna 411A · Bossier City, LAThe pilot reportedly did an unusual amount of engine run-up before pulling onto the runway. He then performed another run-up before departing. This is evidence that he was aware of a problem with his aircraft. The engine(s) were popping and puffing black…NTSB MIA86LA133Accident · No injuriesLimited investigationFinal reportBell 206-L-3 · Miami Shores, FLThe plt stated that he experienced generator failure upon departure from key west & elected to continue his flt to opa-locka, FL, making two stops enroute. He noted that his battery was dead after passing ocean reef, landed at watson island & then took off…NTSB ATL86LA118Accident · No injuriesLimited investigationFinal reportTaylorcraft BLT-65 · Mount Airy, NCThe pilot stated that the engine lost power to idle RPM followed by a forced landing in trees. Examination of the aircraft determined that a snap ring which held the throttle cable housing in place in the instrument panel came loose. Without the snap ring the…NTSB MIA86LA129Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Melbourne, FLThe plt stated that they were doing touch & go landings & on liftoff, the eng sputtered & lost power. She then took over the controls from the student & attempted to land on another rwy & landed hard. Post crash examination of the eng revealed that the eng…NTSB FTW86FRG18Accident · Serious injuriesFinal reportBaby Bird Q2-200 · Gerogetown, TXThe acft landed short of the rwy after losing partial pwr while maneuvering around the arpt. The plt had radioed that the eng was developing about 2000 RPM. The plt had reported throttle problems on previous flt. Due to impact damage it was not possible to…NTSB SEA86LA105Accident · No injuriesLimited investigationFinal reportBell 47G3B1 · Albany, ORThe plt reported that after aprx 15 minutes of flt, the eng sputtered 2 or 3 times. An autorotation was performed onto rough terrain during which the tail rotor drive shaft was damaged by the main rotor blades. Post accident inspection revealed a hole in the…NTSB MKC86LA086Accident · No injuriesLimited investigationFinal reportGrumman G164B · Advance, MOThe airplane was being operated as an agricultural aircraft when the engine started backfiring and then quit. During the forced landing in a plowed field, the airplane flipped forward to the inverted position. Investigation revealed the teeth on the left…NTSB MIA86FA119Accident · 2 fatalField investigationFinal reportBeagle B206-2 · Pedro, FLImmediately after take-off, the left eng seized & the prop stopped due to a connecting rod failure. Witnesses reported that about 200 ft above the ground, the acft rolled to the left and collided with a powerline before crashing to the ground in a near…NTSB MKC86LA078Accident · No injuriesLimited investigationFinal reportCessna 172 · Ava, MOThe plt reports that the eng began to run rough and lose RPM while the acft was cruising at 2500 ft. he said he attempted emerg proc but the loss of RPM continued and he decided on an off-arpt landing. During the apch to the landing area the eng RPM dropped…NTSB MIA86LA108Accident · Serious injuriesLimited investigationFinal reportEasley Pitts S2-E · Homestead, FLWhile climbing through 600 feet after departure, the flight experienced loss of engine power. While returning to the airport altitude could not be maintained and the aircraft crashed short of the runway. Post crash inspection revealed the number 4 cylinder…NTSB MIA86FA103Accident · Serious injuriesField investigationFinal reportPiper PA-23-250 · Osteen, FLBefore the flt, the plt & pax were observed drinking alcoholic beverages on the way to the arpt. After much difficulty taxiing to the rwy, the flt was cleared for takeoff after entering the active rwy without clearance. After taking off, the acft was seen…NTSB DEN86LA102Accident · No injuriesLimited investigationFinal reportDouglas C-47 · Steins, NMWhile en route, the left eng of the C-47 lost partial pwr as a result of a cracked cylinder. The crew stated the left eng was shut down and additional pwr was applied to the right eng to compensate for the increasing rate of descent. The crew stated a short…NTSB ANC86LA034Accident · No injuriesLimited investigationFinal reportBell 206B3 · Livengood, AKHelicopter experienced power loss while flying low level pipeline patrol, resulting in a hard landing and substantial damage to the acft. The governing pressure (pg) air line fitting was found loose on the power turbine fuel governor.NTSB CHI86FA079Accident · 2 fatalField investigationFinal reportCessna 421C · Birmingham, MIAt rotation the right eng failed. The acft entered a skidding turn to the rt and continued to climb to about 100 ft AGL. During the turn 110 deg from t.o. heading acft rolled inverted and descended into a car port. Extensive post impact fire destroyed acft,…NTSB CHI86FA077Accident · 2 fatalField investigationFinal reportMooney M20C · Loogootee, INPlt experienced loss of pwr during cruise flt at 6,000 feet. ATC vectored acft toward daviess county arpt, approximately 10 miles away. Plt reported acft on fire. Witnesses saw N9307V in a left bank turn then 'nose dive into ground.' Post crash exam of engine…NTSB MIA86LA060Accident · No injuriesLimited investigationFinal reportBeech B24R · Fernandina Bch, FLThe plt stated that just after he rotated, he experienced a loss of power, extended his landed gear & landed hard causing a collapse of the landing gear. Post crash examination of the eng revealed that the right magneto was improperly timed & the left magneto…NTSB CHI86LA066Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Pelican Rapids, MNThe exhaust valve rocker arm #1 cylinder failed in flight. The student pilot descended and landed in a wooded area. After over flying a frozen lake occupied by fishermen. The rocker arm exhibited evidence of fatigue.NTSB LAX86LA088Accident · Minor injuriesLimited investigationFinal reportCessna 172N · San Jose, CAThe acft contacted trees and a building during a forced landing following a power loss while on final apch to land. Post accident inspection revealed a failure of the throttle cable housing at the swaged ball joint near the carburetor. This failure allowed…NTSB MIA86LA054Accident · No injuriesLimited investigationFinal reportCessna 150L · Boca Raton, FLThe plt stated that while enroute to ft. lauderdale executive arpt his eng began to run rough. He made a forced landing in a field & on landing rollout, the nose gear collapsed. Post crash examination of the eng revealed that the #1 intake valve was stuck in…NTSB ATL86IA051Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-300 B4-203 · Atlanta, GADuring takeoff initial climb the aircraft experienced an uncontained failure of the no 1 engine. The pilot returned to the airport and landed without further incident. Post incident examination disclosed four broken turbine mid frame strut studs. The fracture…NTSB MIA86FA033Accident · 1 fatalField investigationFinal reportNorth American T-28A · Lantana, FLThe pilot/mechanic had recently re-installed a rebuilt engine in the aircraft and performed a very short run-up prior to takeoff. Witnesses stated the aircraft engine made popping noises and was belching black smoke during the takeoff roll. The aircraft…NTSB DEN86LA019Accident · No injuriesLimited investigationFinal reportBeech F33A · Santa Teresa, NMThe plt reported the cylinder head temp began 'falling back out of green' shortly after takeoff. The plt reversed direction & landed at the arpt, but failed to extend the gear, substantially damaging the acft. The investigation of theeng revealed the exhaust…NTSB FTW86FA004Accident · 2 fatalField investigationFinal reportBeech H18 · Oklahoma City, OKAtr plt departing arpt under VMC experienced failure of the right eng shortly after lift-off. The acft yawed right followed by a steep right roll, contacting power lines with the right wing and subsequently impacted the ground. A post-crash fire destoyed the…NTSB LAX86LA028Accident · No injuriesLimited investigationFinal reportS. Piccolotto/Dave Morss Cassutt SH-1 · San Carlos, CAThe acft experienced a loss of power shortly after departing ry 30, San Carlos airport, San Carlos, CA. The plt reptd that after experiencing the loss of power, he pumped the throttle. This action caused the engine to regain some power but not enough to…NTSB MKC86LA015Accident · Minor injuriesLimited investigationFinal reportMooney MK21 · Warren, ARAt cruise level flt the plt rptd a malfunctioning engine. The plt was cleared to descend to an airport in the vicinity. The precautionary landing was initiated due to an oil pressure decline. Approaching for the landing the plt rptd the engine completely quit…NTSB MKC86FA017Accident · Serious injuriesField investigationFinal reportSilvaggio Cassutt 111M · Plattsburg, MOThe acft was level, in cruise when the plt noticed high eng temperatures. He stated that he started a shallow climb and headed for the nearest arpt. En route to nearest arpt, smoke came into the cockpit and the plt heard a loud noise that was accompanied by…NTSB FTW86MA018Accident · 2 fatalMajor investigationFinal reportBell 222UT · East CameronThree pax rprtd that just prior to reaching the helipad, the helicopter's forward movement stopped and the helicopter wobbled or yawed from side to side. The pax's rprted that the pilot appeared to be trying to gain altitude and go forward when they heard a…NTSB FTW86LRG01Accident · No injuriesFinal reportBell 206B · Port O'Conner, TXThe acft rolled over after a forced lndg due to loss of power. The eng lost about 60 percent of its power during cruise at about 250 ft AGL. Post acc inspection showed that fuel line p/n 685481 b-nut had backed off the fuel control end of line 250C20 ipc. The…NTSB ATL86FKG03Accident · No injuriesFinal reportCessna 182P · Hawkinsville, GAThe acft caught fire during a forced lndg after losing eng power during cruise. The plt approached a hi-way for landing and smoke filled the cockpit. During rollout fire came thru the firewall and the plt evacuated the moving acft. The unoccupied acft…NTSB NYC86LA008Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Norwood, MAAccording to the pilot, during the takeoff climb the aircraft did not develop sufficient power to maintain altitude. The pilot turned the aircraft to the right in an attempt to return to the airport. During the approach to the airport, the aircraft collided…NTSB ATL86LA005Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Chapman, ALDuring an attempted takeoff from a field adjacent to a grove of trees the aircraft was unable to climb over the trees and crashed into them. The engine was test run and although it ran rough during initial start up it later operated normally and the reason…NTSB MIA86LA004Accident · No injuriesLimited investigationFinal reportBell 206L · Islamorada, FLAircraft was ditched in the atlantic ocean after loss of engine power. Post crash inspection of the engine after recovery from the ocean revealed thje pc or compressor pressure air line had failed at a 'b' nut at the compressor schroll. With this line failed…NTSB LAX85LA398Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Huntington Bch, CAThe plt stated that he aborted his first takeoff because of reduced acceleration. He taxied back, via a parallel taxiwayand made run-on type takeoff. He said that as the acft climbed to an alt of aprx 50 to 60 ft above the rwy he heard a thud and the airspeed…NTSB ATL85LA279Accident · No injuriesLimited investigationFinal reportCessna 177RG · Neola, WVWhile leveling at cruise altitude the engine lost power and the pilot attempted a forced landing in a field. During landing roll the aircraft collided with small trees at the end of the field. Post-crash examination of the engine disclosed a 3 inch crack in…NTSB SEA85LA214Accident · Minor injuriesLimited investigationFinal reportBell 206BII · Atlanta, IDA loss of pwr occurred shortly before touchdown. The left skid struck a rock during touchdown causing the acft to roll onto its right side. Twenty-five flt hrs prior to this flt an identical situation occurred and a loose air line to the fuel control was…NTSB CHI85FET03Accident · 1 fatalFinal reportVanbenthuysen John Bede BD-5B · Elkhart, INThe acft rolled inverted & collided with the ground after an overtemperature reading, an RPM loss and loss of airspeed were recognized by the plt during the recording of the takeoff. The plt had a portable recorder on board and was using it during the…NTSB CHI85LA373Accident · No injuriesLimited investigationFinal reportSchweizer G-164A · Irwin, OHAt an alt of aprx 20 ft AGL after takeoff, the #1 cylinder failed. A straight ahead landing was made in a corn field during which the acft was destroyed. The eng had under gone a major overhaul 197 hrs prior to this accident.NTSB NYC85LA259Accident · No injuriesLimited investigationFinal reportVolksplane VP-1 · Sharpsville, PAThe plt experienced a loss of eng RPM during cruise flt. He applied carb heat and lowered the nose of the acft in an attempt to regain eng RPM however, the eng continued to loose speed. The eng was below 2000 RPM and dropping when the plt elected to make a…NTSB MKC85LA210Accident · No injuriesLimited investigationFinal reportCessna 150K · Bee Branch, ARThe airplane was on a local flight when the engine failed. During the forced landing, the airplane ran through a fence row of trees. Inspection revelaed that the rocker arm bosses on the number one cylinder had failed. Cylinder had been installed 50 hours…NTSB MKC85LA209Accident · No injuriesLimited investigationFinal reportCessna 150L · Morrilton, ARThe airplane was on a night flight when the engine failed. During the forced landing, the airplane struck and remained attached to high voltage powerlines. Inspection of the engine revealed number three cylinder cracked and the top compression ring on number…NTSB DCA85AA036Accident · 31 fatalFinal reportDouglas DC-9-14 · Milwaukee, WIThe Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-87/01. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm Drg…NTSB MIA85LA244Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Everglades City, FLThe plt stated that while returning to venice from marathon,the acft started to lose power. He switched tanks but the problem continued. He notified fort myers apch he was having problems and when the power deteriorated to 1600 RPM, he elected to ditch the…NTSB DEN85LA235Accident · No injuriesLimited investigationFinal reportCessna 182N · Moab, UTThe plt stated after the accident that he experienced a loss of power while cruising at 8500 MSL. He was unable to restore power and executed an emergency landing in an open area covered by sage brush. During the landing roll, the acftnosed over. Examination…NTSB CHI85LA365Accident · No injuriesLimited investigationFinal reportCessna 177 · Glandorf, OHThe plt reported that during cruise flt the prop pitch began to vary, oil pressure dropped to zero and the eng began to overheat. A forced landing ensued during which the acft contacted a ditch. Post accident examination of the eng disclosed the #3 cylinder…NTSB CHI85LA360Accident · No injuriesLimited investigationFinal reportSchweizer G164A "450" · Constantine, MIThe acft nosed over during a forced landing in a corn fld. The plt stated that at 30 ft AGL during his second swath run the eng backfired and lost pwr. He attempted to dump the load however, the acft continued to loose alt and the forced landing resulted.…NTSB LAX85LVA04Accident · Minor injuriesFinal reportBell 204-B · East Clovis, CAThe acft was being flown for a maintenance ck. While climbing at about 50 ft AGL a bang was heard and eng RPM decreased. Plt initiated autorotation and attempted a flare at about 20 ft AGL. The tail rotor hit and the acft became airborne after hitting on the…NTSB BFO85FID04Accident · Minor injuriesFinal reportCessna A188B · Farmville, VAThe pilot stated that while making his third swath run over a field, the engine started to run rough. He stopped spraying and attempted to gain altitude, but the roughness increased. Shortly thereafter, the manifold pressure dropped and he was unable to keep…NTSB FTW85LPJ03Accident · No injuriesFinal reportJames/Viking Dragonfly · Okmulgee, OKThe acft bounced 3 times during a landing after the engine failed to preduce full power for takeoff. After the 3rd bounce the rt canard broke off at the fuselage. The plt stated that the fuel filter was found to be blocked by some type of residue.NTSB NYC85LA211Accident · No injuriesLimited investigationFinal reportErcoupe Ercoupe 415-C · Del Mar, NYThe plt was reposition the acft at the request of the new owner who was not a rated plt. While climbing thru 2000 ft AGL the plt reported hearing the engine growl and felt a loss of power. During a precautionary descent the engine seized and the plt made a…