NTSB investigations
2,878 cases where the first occurrence was “Loss of engine power(total) - 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\" = 351) 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" = 351) 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 NYC85FNC04Accident · Serious injuriesFinal reportBell 206B · W. Brattleboro, VTThe acft lost pwr during normal cruise. The plt attempted to autorotate into a clearing in the trees. Post accident exam discovered an air leak in the fuel control. The pressure compressor discharge (pcd) line 'b' nut was disconnected from the fuel control.…NTSB MKC85LA115Accident · No injuriesLimited investigationFinal reportHughes 269C · West Liberty, IAOn a downwind swath run the helicopter experienced an eng failure and the plt entered an autorotation. The plt then made a hard landing which resulted in substantial damage. Inspection of the engine revealed that the nut which retains the gear to crankshaft…NTSB CHI85FET02Accident · Minor injuriesFinal reportPiper PA-28-140 · Nappanee, INThe acft nosed over during a forced landing in a field following a loss of pwr on initial climb from a touch & go landing. Post accident inspection revealed the throttle lever could rotate on the throttle shaft despite the attaching bolts being tight and…NTSB SEA85FA122Accident · 3 fatalField investigationFinal reportBeech V35 · Spokane, WAAfter what appeared to be a normal takeoff and initial climb, witnesses observed the acft level off at about 200 ft AGL and some heard sounds of power cessation. Acft was oberved to commence a left turn during which the bank increased to an excessive angle.…NTSB BFO85LA031Accident · Minor injuriesLimited investigationFinal reportCessna U206F · Piney Point, MDWhile descending in IFR conditions near the destination, the eng lost power at an alt of about 3800 to 4000 ft. the plt requested vectors toward land & the nearest arpt; however, when it broke out of the clouds at about 1000 ft AGL, the acft was still over…NTSB ATL85LA188Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Monticello, GAAbout 20 min after takeoff, while cruising at 5000 ft, the plt observed oil on the windshield & noted a decrease in oil pressure. He turned back toward the departure arpt & reduced the power in an attempt to prolong eng life. A short time later, the eng began…NTSB ANC85LA079Accident · No injuriesLimited investigationFinal reportCessna C-206 · Candle, AKThe acft made a hard landing on ice after eng failure resulted in a forced landing. The plt had shut down the eng after loss of oil pressure and a rise in oil temperature occurred. Post accident investigation showed a failure of a rod bearing.NTSB NYC85LA112Accident · No injuriesLimited investigationFinal reportCessna 172H · Middletown, PAThe acft nosed over in a plowed field during a forced landing after a pwr loss during cruise flt. After the pwr loss the plt declared an emergency and set up a slide for the nearby arpt. Strong winds interfered in the planned approach and the acft settled in…NTSB MIA85LA158Accident · No injuriesLimited investigationFinal reportCessna 172K · Sharpes, FLCarburetor had rusted parts and needed an overhaul. Pilot was demonstrating power off stall to passengers, when he tried to apply power, engine did not respond. Landed in soft terrain. Swerved to avoid ditch. Nose wheel collapsed.NTSB LAX85LA227Accident · No injuriesLimited investigationFinal reportBeech A35 · Truckee, CAThe plt performed a gear-up landing on rocky terrain after the acft windshield became covered with oil and the eng beganvibrating. Post accident investigation revealed a 6 inch crack in the crankcase near where the #4 cylinder should have been located. Half…NTSB CHI85LA178Accident · Minor injuriesLimited investigationFinal reportBeech H35 · Lima, OHThe plt was flying the acft back to the home arpt following an annual inspection when he noticed the oil pressure was falling to zero. Aprx 3 min later, the eng seized. Subsequently, an emerg gear-up landing was made in a farm field. An exam revealed the oil…NTSB SEA85LA097Accident · No injuriesLimited investigationFinal reportHiller 12E · Myrtle Point, ORDuring a CFR 137 flight a total loss of power occurred with an audible screech coming form the engine area. Autorotation was made and the acft was landed into a hevily treed area with steep terrain. During engine tear down a fractured impeller was found.…NTSB ANC85LA073Accident · No injuriesLimited investigationFinal reportCessna 206 · Seward, AKThe plt stated the acft was in cruise flt when the engine quit. The plt attempted an emergency landing on the beach but crashed in the water. The acft engine was not located for several days after the accident. According to the operator the engine failure was…NTSB ATL85LA142Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Alma, GAThe student pilot and passenger changed the engine oil just prior to attempting the takeoff. The oil was drained on the ground on the airport where the aircraft was parked. Examination of the oil, disclosed that metal shavings were present in the drained oil.…NTSB FTW85IA184Incident · No injuriesIncident investigationFinal reportde Havilland DHC-7-103 · College Station, TXFollowing a torque drop and RPM fluctuation on the #2 engine the pilots observed flames from the tailpipe. They shut the engine down and extinquished the fire. A precautionary landing was accomplished without incident. A tear down revealed a failed #4 bearing…NTSB MIA85LA145Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Wabasso, FLInstructional flight practicing steep turns. Engine lost oil through crack in propeller governor oil line and seized. Instructor took over control and landed on a road in a sand pit. Pilot was unable to steer through an 's' turn on the road and collided with…NTSB ATL85LKG04Accident · No injuriesFinal reportAero Commander S2R · Leslie, GAThe acft lost power en route to spray crops & crash landed in a wooded area. The acft had flown only 2 miles when the power loss occurred. During the post accident investigation an exam of the powerplant & systems revealed that the supercharger had a loose…NTSB FTW85FA171Accident · 1 fatalField investigationFinal reportCessna T210N · Riesel, TXThe acft eng had just been top overhauled and a stol kit was added. The mechanic reportedly told the plt to be 'easy' on the eng and fly the acft 45-60 mins near the traffic pattern so it could be checked for oil leaks. The plt reportedlyignored these…NTSB LAX85LA194Accident · Serious injuriesLimited investigationFinal reportBell 206A · San Diego, CADuring flt, the eng lost power & the plt began an autorotative landing in a parking lot. During the apch, he maneuvered to avoid a 100 ft crane. As the helicopter was approaching the intended touchdown point, a vehicle was driven into the flt path of the…NTSB FTW85LA170Accident · No injuriesLimited investigationFinal reportCessna 175 · Sonora, TXThe acft was destroyed during a forced landing in rough terrain, following an eng failure in-flt. Investigation revealedthat the no. 3 connecting rod failed due to oil starvation. The rod oil passageway was found clogged with sludge and fine metal particles,…NTSB CHI85LA144Accident · No injuriesLimited investigationFinal reportChampion 7EC · Lake Elmo, MNOn takeoff, at about 150 ft AGL, all power was lost and the pilot executed a forced landing on the airport. Post-accident inspection revealed contamination in the fuel manifold valve.NTSB SEA85LA077Accident · No injuriesLimited investigationFinal reportGrumman G-164-A · Dufur, ORA loss of power occurred during aerial application and a forced landing was made onto a field. The right main gear sank into a hole and was torn off. The acft then flipped inverted. The throttle leakage was found to be broken.NTSB MIA85IA120Incident · No injuriesIncident investigationFinal reportDouglas DC-6B · Miami, FLCrew stated that on takeoff roll the number four engine failed and an aborted takeoff was intiated. During the decelleration after the throttles were closed the number four engine seized and the number four propeller separated when the propeller shaft failed.…NTSB DEN85LA094Accident · No injuriesLimited investigationFinal reportEnstrom F-28L · Salt Lake City, UTThe acft eng lost pwr on final apch at aprx 100 ft AGL. The tail boom was severed during the autorotational landing on soft ground. Post accident exam of the eng revealed that the left magneto point gap was excessively closed. During eng test run, when the…NTSB ANC85LA053Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Mcgrath, AKThe acft contacted trees during a forced landing following an engine failure. Investigation revealed the crankshaft had failed for undetermined reasons. The enging had a total time of 1312 hrs since major overhaul.NTSB FTW85LA142Accident · No injuriesLimited investigationFinal reportBeech E18S · Pharr, TXThe plt took off at about 0600 CST on a local test flt following an eng change. He received a special VFR clearance from the control tower, but did not obtain an IFR clearance. At 0605, the wx at mcallen, TX was in part: 500 ft obscured, visibility 2 mi, wind…NTSB MIA85LA116Accident · No injuriesLimited investigationFinal reportRepublic RC-3 · Lake Placid, FLThe plt heard a loud noise & noticed that a fire had immediately started in the eng compartment. He made an emergency landing on a nearby lake; however, the amphibious acft continued burning & was destroyed. An investigation revealed that the fire had started…NTSB BFO85FA025Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Friendship, MDThe acft had departed woodbridge, VA, en route atlantic city, NJ, for the afternoon. As the acft approached the chesapeake bay in a climb the eng lost pwr. The plt was unable to restart the eng and was forced to land on pvt property. During the emergency…NTSB ATL85LA110Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Rock Hill, SCDuring a VFR flt, the plt reported a severe vibration in the airframe. Pwr was reduced in an attempt to lessen the vibration and shortly thereafter, a total loss of pwr was experienced and the plt established a glide to the nearest landing area. During the…NTSB FTW85LA147Accident · No injuriesLimited investigationFinal reportCessna 152 · Andrews, TXAcft experienced a total pwr loss while in cruise flt. During the subsequent forced landing on a dirt road, the nose gear collapsed and the acft nosed over. Examination of the eng revealed severe damage as a result of a failure of the #4 exhaust valve. Due to…NTSB LAX85LA162Accident · No injuriesLimited investigationFinal reportSevdy Pitts Special 104 · Yuma, AZWhile practicing aerobatics for an airshow, the plt entered a spin. During the spin maneuver, the eng sputtered, lost power & the prop stopped turning. The acft was not equipped with an electric starter, so the plt tried to windmill the prop by diving, but…NTSB MIA85FA102Accident · 2 fatalField investigationFinal reportGlobe Swift GC-1B · Rockledge, FLThe acft crashed into a field after experiencing a loss of pwr. Inspection revealed one of the two check valves inside the eng driven fuel pump was unsetted and wedged between the metal pump housing and the pump diaphram actuating plate. With the check valve…NTSB MIA85FA101Accident · 3 fatalField investigationFinal reportMooney M20D · Punta Gorda, FLFlt departed on runway 9 and a witness reported seeing the aircraft shortly after this with its engine losing power and the pilot attempting to return to the airport, this witness then lost sight of the aircraft. The aircraft crashed one quarter mile from the…NTSB CHI85LA115Accident · No injuriesLimited investigationFinal reportMasselink XTC · Hastings, MIThe acft lost power shortly after takeoff on its maiden flt at 600 ft AGL. The plt turned for home but was forced to land in trees short of the arpt. Inspection of the home-built acft, built by the plt, revealed that the choke cable had slipped out of…NTSB FTW85LA124Accident · No injuriesLimited investigationFinal reportCessna T-188C · De Quincy, LAThe acft made an emergency landing in trees following an eng failure at 200 ft AGL. Shortly after departure from an ag strip, the eng oil temp started rising. The plt started a turn to return to the strip. During the turn the eng seized and the plt landed in…NTSB CHI85LA103Accident · Minor injuriesLimited investigationFinal reportCessna 337G · Peoria, ILThe acft was damaged in an off arpt forced lndg after the rear eng quit at about 350 ft AGL. The plt stated that he could not feather the prop on the rear eng which had stopped. Since the acft would not climb the plt elected to land off the arpt. The post acc…NTSB LAX85FA132Accident · Minor injuriesField investigationFinal reportHiller UH12E · Five Points, CAWhile performing an ag flight the helicopter's engin suddenly lost power. At the time the aircraft was near its max allowable gross weight and it was between 3-5FT AGL. As the aircraft yawed left and descended. The pilot in command attempted to land on a…NTSB FTW85LA116Accident · No injuriesLimited investigationFinal reportBeech C-35 · Sheffield, TXThe plt stated the eng failed completely during cruise. The crankshaft was found separated during the eng teardown, with the rod and bearings also separated. Metallurgical testing revealed fractures to be from fatigue. Eng maintenance had been improperly…NTSB LAX85FA130Accident · No injuriesField investigationFinal reportPiper PA-32RT-300T · Bishop, CAThe plt rptd that shortly after leveling off at 11500 ft MSL, the engine exploded causing both windscreens to be covered with oil and fire. The fire stopped during the emergency descent. The acft landed on ry 30 at Bishop arpt, Bishop, CA without further…NTSB CHI85LA099Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Alexandria, MNThe acft on a ferry flt after an annual insp was on to climb 100 ft AGL when power began to deteriorate while manuvering to ld on an adjacent runway the acft struck a VASI installation and ground impacted no 5 lower spark plug improper installationNTSB LAX85FA122Accident · Minor injuriesField investigationFinal reportPiper PA-24-400 · Helendale, CAShortly after initiating an enroute letdown, the acft experienced a catastrophic engine failure at about 4,500 ft MSL. Plt selected a road for an attempted emergency landing, but a car turned onto the road in front of him and forced a diversion to a nearby…NTSB FTW85FA100Accident · No injuriesField investigationFinal reportBell 206L-1 · Lafayette, LAThe acft departed at 2040 CST as a flt of 2 on a ferry flt. Shortly after level-off at 700 ft and power stabilized at 72% torque the engine failed and the acft yawed left and right. An autoration was initiated into a soft plowed field with a slight…NTSB BFO85FA013Accident · Minor injuriesField investigationFinal reportAerospatiale SA 360C · Washington, DCThe flt crew rprtd the eng lost pwr when the helicopter was at aprx 100' with a fwd speed of 50 KTS. Witnesses observed faint gray/white smoke emanating from the vicinity of the tailpipe shortly after lift off which trailed & became profuseimmediately before…NTSB SEA85LA042Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Troutdale, ORShortly after takeoff plt felt a 'tick' in the engine. Plt reduced pwr and headed back to Troutdale. Engine quit over the threshold of rwy 07 as plt was making a 360 deg turn. Acft touched down short of rwy 07 contacting small bushes and trees. Inspection…NTSB MIA85FA081Accident · No injuriesField investigationFinal reportCessna 210M · Stuart, FLThe acft eng failed in flt & the plt made an emergency landing at night in an open field. The field was on sandy terrain that had been contoured to be an orange grove. While landing on the uneven soft terrain, the acft was damaged. An exam of the eng revealed…NTSB MIA85LA079Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Floridana, FLDuring cruise flight the pilot noted the engine was vibrating severely and spraying oil and then failed. Examination of the engine revealed that the #2 cylinder connecting rod had failed in overload. A small piece of gear tooth was found inside the engine the…NTSB FTW85LA095Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Houston, TXInitially, after a top overhaul, the eng would not run. The mechanic removed the carburetor & found a piece of silicon. After reinstalling the carburetor, the eng operated normally. The plt then took off on a maintenance test flt. As he began a descent back…NTSB LAX85FA101Accident · Minor injuriesField investigationFinal reportBell 206B · Trimmer, CAThe plt stated the helicopter lost pwr during cruise when he attempted to add pwr to climb. He stated that N2 decreased along with the activation of visual and audio engine out warnings. An autorotation was performed to a road, however, the helicopter slid…NTSB LAX85LA098Accident · No injuriesLimited investigationFinal reportCrowder Great Lakes · Sunland, CAWhile cruising at 2100 ft AGL, the engine began to vibrate and a ttl loss of pwr occurred. Plt made forced landing into the top of a tree. Inspection revealed that the 4 hold down bolts/studs which hold the #2 cylinder to the case had failed allowing the…NTSB DEN85LA059Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Rawlins, WYThe acft lost eng pwr and was substantially damaged during an off arpt energency landing. The purpose of the flt was to look for coyotes. The post accident eng exam revealed that 9 consecutive teeth on the left magneto drive gear were ground off. This allowed…