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 ATL82DA188Accident · No injuriesFinal reportGrumman G-164A · Doddsville, MSThe pilot reported that at the end of a swath run, he noticed the smell of burned oil and saw smoke when the engine began a hard miss. He reported that these occurred when the number five cylinder failed. He made a forced landing in a flooded rice field where…NTSB ATL82DA181Accident · No injuriesFinal reportCessna 172 · Martinsburg, WVShortly after level-off to cruise, the engine began to lose power. The pilot attempted to restore the power, but the engine RPM continued to decrease. A turn was made back toward the airport. While scanning the instruments, zero oil pressure and a high oil…NTSB SEA82DA098Accident · No injuriesFinal reportPiper PA-32-300 · Glacier Bay, AKThe aircraft engine stopped during normal cruise and an emergency landing was made in a dry river bed. The landing gear collapsed from overload during the landing. Examination of the engine revealed a connecting dowel for a drive gear driven by the crankshaft…NTSB DEN82DA121Accident · No injuriesFinal reportAyres S-2C · Greeley, COAfter takeoff the plt noticed the oil temp was increasing & the eng began losing power at about 100 ft AGL. He was unable to gain any additional altitude. He continued flying for another 15 minutes when the eng failed completely. The eng teardown & inspection…NTSB ATL82DA180Accident · No injuriesFinal reportCessna 185 · Scooba, MSThe aircraft was climbing to cruise altitude of 8500 feet. The engine began to lose power, then quit entirely. The pilot called the accompaning aircraft and made an emergency landing in a plowed field. The aircraft nosed over during landing. Examination…NTSB FTW82FRD16Accident · 1 fatalFinal reportPiper PA-32-260 · Belle Chasse, LAThe acft departed southern seaplane's land rwy 20 & climbed to approximately 200-300 ft where it was observed trailing white smoke. It travelled approximately 1.6 mi from its departure point & struck a tree on the bank of the algiers outfall canal. Eng tear…NTSB FTW82DA245Accident · No injuriesFinal reportPiper PA-28-236 · Fort Worth, TXThe aircraft crashed into trees after engine failure during takeoff. A fuel line was leaking. The engine had been written up as malfunctioning and was being tested when the accident occurred.NTSB FTW82DA239Accident · No injuriesFinal reportGrumman G-164A · Jennings, LAThe pilot had just finished spraying and was on his way back to the airport when the engine failed. A field with grass was selected for an emergency landing. During the landing roll, the aircraft encountered ruts and nosed over. The operator reported that the…NTSB CHI82DA221Accident · Serious injuriesFinal reportPeter Clark Super Acro CUB · Delaware, OHAfter completing several aerobatic flights, the pilot proceeded to another airport to obtain fuel. While en route, the engine lost all power and would not restart. Subsequently, the aircraft was damaged during a forced landing in a soybean field. An…NTSB ANC82DA049Accident · No injuriesFinal reportPiper PA-32-300 · Near Ekwok, AKThe pilot made a forced landing when power would not develop more than 1500 rmp. Takeoff and climb had been normal up to 1000 feet when the engine began to lose power. Since not enough power was available to continue flight a landing was made in the tundra.…NTSB FTW82DA227Accident · No injuriesFinal reportBoeing 75A · Picher, OKThe pilot had just completed spraying a field and was climbing to return to his home airstrip when the engine failed. He landed in a nearby pasture but was unable to stop on the wet terrain before hitting a low fence. The main gear caught on the fence and the…NTSB SEA82DA087Accident · No injuriesFinal reportCessna 206 · Renton, WAAccording to the pilot, the aircraft was on its first flight after a major engine overhaul and was being flown for maintenance evaluation. About 45 minutes after takeoff, the pilot requested a descent from 7500 feet MSL. After entering an overcast, the engine…NTSB NYC82FFJ15Accident · Serious injuriesFinal reportNa 64 · Cambria, NYThe pilot reported that after he made a photo fly-by, he began to climb. At about 400 ft AGL, the engine failed and he began a forced landing. During the approach, the tail wheel caught on two electrical wires and the aircraft pancaked onto a paved road, then…NTSB NYC82FHD15Accident · Minor injuriesFinal reportGregg KR-2 · Middletown, DEThe eng failed on the downwind leg after the plt applied carb heat. The plt attempted a power-off approach to the rwy but encountered turbulence from another acft passing below him on final causing him to lose control & enter a spin. After recovery the acft…NTSB FTW82FRD15Accident · Serious injuriesFinal reportGrumman G-164A · Egan, LAAs the plt was adjusting the powerplant & prop controls the eng accelerated, & at the same time oil covered the windshield. The acft went down into a bean field & flipped over. Disassembly of the eng revealed the rear counterweight trailing pin worn &…NTSB FTW82DA212Accident · Minor injuriesFinal reportCessna 210L · Wichita Falls, TXAfter climbing to 2500 ft the engine suddenly lost power and quit. The pilot lowered the landing gear and shut down all switches but did not extend the flaps. During the ensuing emergency landing the aircraft nosed over in a wheat field. Engine examination…NTSB NYC82FFA06Accident · No injuriesFinal reportCessna A188B · White Lake, NYWhile returning from a spraying operation, the engine began running rough, and within seconds, it lost power. The pilot was unable to restart the engine, and subsequently, ditched the aircraft in a reservior. An engine teardown revealed that the crankshaft…NTSB ANC82DAG29Accident · Serious injuriesFinal reportStinson 181 · Talkeetna, AKThe pilot made a forced landing after a spark plug blew out of the engine. During the landing the aircraft collided with a tree.NTSB CHI82FEE15Accident · Minor injuriesFinal reportSwanson SSW-DTV · Marengo, ILA power loss occurred shortly after takeoff; however, the pilot was able to regain power after mixture adjustments. Upon returning to land, power was again lost partially, then completely. The pilot landed in a soft cornfield in line with the approach path.…NTSB FTW82DA201Accident · No injuriesFinal reportBell 206L-1 · High Island 389Pilot approaching landing platform heard a loud bang and autorotated to water. Aircraft rolled inverted and was damaged by waves banging it against platform. A teardown of the engine revealed that the first stage turbine wheel, pn 6895801G, had failed and…NTSB DEN82FTM12Accident · No injuriesFinal reportQuickie Rise · Ogden, UTDuring takeoff, the engine lost power as the aircraft was climbing near the departure end of the runway. The aircraft was substantially damaged during a forced landing on rolling terrain with brush. An investigation revealed there was a loose screw holding a…NTSB FTW82DA194Accident · No injuriesFinal reportPiper PA-28-236 · Clayton, NMThe pilot reported that during flight, the engine lost power. He tried to land on a nearby airport. However, unexpectedly strong winds were encountered and he made a forced landing in a pastured when he saw he could not reach the airport. During the landing,…NTSB DEN82FTK04Accident · No injuriesFinal reportCallair A-9B · Sioux Falls, SDThe eng quit & the plt landed in an adjacent field after first hitting a wooded fence. An inspectin of the bendix fuel servo unit, model PSA-10ED-1, revealed that the fuel diaphragm stem, pn 2539806, had failed.NTSB FTW82DA193Accident · No injuriesFinal reportPitts Special S-1S · Huntsville, TXThe pilot reported that during flight at 1500 ft AGL, there was a violent explosive failure of the engine and black smoke entered the cockpit. He elected to land between cars on an interstate highway. He cleared over one car, but the driver of the next car…NTSB MKC82DA087Accident · No injuriesFinal reportPiper PA-31P · Salina, KSAccording to the pilot, the left engine began running rough at about 300 ft AGL after takeoff and the roughness was accompanied by a slight left yaw. The pilot said the left engine was producing some power so he elected not to feather the propeller. The…NTSB ATL82DA138Accident · No injuriesFinal reportBellanca 17-30 · Havelock, NCAbout eight minutes after takeoff, the pilot declared an emergency and reported an engine failure. He diverted, but was unable to reach the airport. A gear-up landing was made about one mile short of the runway. An examination of the aircraft revealed that…NTSB SEA82DA072Accident · No injuriesFinal reportBell 47G-2 · Grandview, WAWhile dispensing herbicide (systox) over an apple orchard the pilot sensed that the engine was binding followed by a power loss. The pilot elected to dump the herbicide and performed a power-off autorotation landing in a grape vineyard. Investigation revealed…NTSB DEN82DA089Accident · No injuriesFinal reportEnstrom F-28C · Marmath, NDThe pilot reported that while he was in flight at about 75 to 80 ft AGL, the engine lost power. During an autorotative landing in an open pasture, a skid dug into the ground and the helicopter rolled over. A subsequent engine teardown revealed evidence that…NTSB NYC82DA095Accident · No injuriesFinal reportNorth American SNJ-5 · Toughkenamon, PAAccording to the pilot, takeoff and departure were normal, however, shortly after the first power reduction the engine lost power and windmilled to touchdown. The pilot in the rear seat took control of the aircraft and landed in a plowed field. The loss of…NTSB LAX82DA176Accident · No injuriesFinal reportPiper PA-28-201T · Van Nuys, CADuring flight at about 1500 ft, the engine suddenly lost power and the propeller stopped turning. The pilot attempted a restart, but the starter would not turn the propeller. The pilot maneuvered to make a forced landing at the Van Nuys airport. The aircraft…NTSB NYC82DA098Accident · No injuriesFinal reportAero Commander 680F · Prospectville, PAThe pilot had planned to purchase the aircraft and was ferrying it to buffalo, NY for inspection and repair. While en route, the right engine lost power. He feathered the right propeller and diverted to turner field. When he lowered the gear, he did not get a…NTSB FTW82DA180Accident · Minor injuriesFinal reportNash Cassutt Racer 111M · Sebastian, TXDuring cruise flight the engine misfired then quit and would not restart. The pilot made a forced landing in a grain field and the aircraft nosed over. No preimpact mechanical malfunction or failure was found.NTSB CHI82DA170Accident · Serious injuriesFinal reportPlaymate SA11A · Pendleton, INThe pilot was cruising at 2000 feet with one passenger when the engine quit. He made a forced landing in a soft soybean field and the aircraft nosed over during deceleration. The aircraft revealed the exhaust system baffles were collapsed. "Blow by" was…NTSB DEN82DA082Accident · No injuriesFinal reportBellanca 17-31ATC · Walsh, COThe pilot reported that during takeoff, the engine lost power at about 75 ft AGL. While making a forced landing, the aircraft struck large pipes that were laying on the ground. An investigation revealed the engine would run satisfactorly as long as the…NTSB CHI82FA157Accident · Minor injuriesField investigationFinal reportPiper PA-32-300 · Milwaukee, WIEngine failure forced pilot to land in an open plowed field. Aircraft collided with wires but a successful landing was made. Oil pump gear tooth had failed.NTSB ATL82DA127Accident · No injuriesFinal reportBeech 35-B33 · Herndon, VAFollowing an engine failure, the pilot had a limited choice of terrain for landing. He landed hard and slid into trees. A metallurgical examination revealed that the shaft on the engine oil pump drive gear, pn 538609, had failed from fatigue. Evidence of…NTSB SEA82DA065Accident · Minor injuriesFinal reportCessna 182P · Walla Walla, WAAfter arriving in the Walla Walla area the pilot executed a spiraling descent, using carburetor heat, so as to arrive at pattern altitude. When he commenced a level-off the engine would not respond. A force landing was executed into a nearby field.…NTSB SEA82FYA07Accident · Serious injuriesFinal reportHughes 369HS · Gooding, IDWhile making a turn at the end of a swath run, the pilot heard a bang and then noticed a loss of engine power. He entered an autorotative landing from a low altitude at low airspeed. Subsequently, the helicopter landed hard and rolled over on its right side.…NTSB CHI82DA150Accident · No injuriesFinal reportSikorsky S-55B · Otsego, OHThe pilot was spreading fertilizer by using external buckets. As he was unhooking a bucket, the engine lost power. He did a hovering autorotation, but the helicopter settled on a bucket, tipped over and allowed the main rotor blades to hit the ground. An…NTSB ATL82DA122Accident · No injuriesFinal reportPiper PA-25-235 · Greenwood, MSThe pilot smelled an odor similar to burning rubber followed by a loss of oil pressure. During the attempted forced landing the right wing contacted a fence causing substantial damage. Examination of the engine logbook reflected installation of new pistons,…NTSB MKC82DA068Accident · Minor injuriesFinal reportBeech M35 · Ottumwa, IADuring flight, the engine RPM exceeded its maximum limit. The pilot attempted to reduce the RPM by using the propeller control, but this had no effect. The pilot was in the process of shutting down the engine when engine oil sprayed out the cowling and onto…NTSB FTW82DA158Accident · No injuriesFinal reportPiper PA-31-350 · Midland, TXDuring a business flight the aircraft's engines quit. The pilot attempted a gear-up emergency landing in a residential area. The aircraft impacted one pickup and two cars during the landing. Investigation revealed the aircraft had been mistakenly fueled with…NTSB DEN82DA080Accident · No injuriesFinal reportPiper PA-23 · Erie, COThe aircraft lost power during takeoff climb and was landed straight ahead resulting in substantial damage. The fuel selector valve was hard to move and during tests moving it caused the engines to quit. Piper AD 80-18-10 warns that scott manufactured…NTSB NYC82FA083Accident · No injuriesField investigationFinal reportBell 206L · New York City, NYThe flt departed the 34th street heliport on a local sightseeing flt to the statue of liberty & return. As the flt crossed lower manhattan, about 1/4 mi from the east river, the plt heard the low RPM audio signal. He lowered the collective & rotor RPM…NTSB LAX82FUJ40Accident · Serious injuriesFinal reportHughes 369D · Teec Nos Pos, AZThe acft lost eng power & crashed while attempting an autorotation. Eng teardown revealed that the #2 bearing failed as a result of some of the ball retainers being broken & cracked between the ball pockets. This condition allowed the impeller assembly to…NTSB FTW82FRA18Accident · Serious injuriesFinal reportBeech A36TC · League City, TXAt about 200 ft the eng abruptly quit. The plt was unable to restart the eng by switching tanks & turning the boost pump on. The acft was landed gear up in an open field adjacent to the rwy. Just prior to the eng failure the plt noticed that the fuel pressure…NTSB SEA82DA058Accident · No injuriesFinal reportGrumman G-164A · S. Of Echo, ORDuring a spray run the pilot experienced a power loss. After pulling up to 100 feet AGL and turning 90 degrees the engine ceased to operate. The pilot completed a forced landing in a nearby soft wheat field and after rolling approximately 300 feet the…NTSB DEN82FTC03Accident · Serious injuriesFinal reportAerospatiale SA315B · Big Piney, WYThe acft was engaged in seismic activity supplying explosives by long line. The eng failed at about 400-500 ft AGL. The load was released & an open field was selected. At about 150 ft AGL the plt was unable to maintain rotor RPM & the acft impacted the ground…NTSB CHI82DA124Accident · No injuriesFinal reportCessna 172 · Salem, OHAfter returning from a local flight, the engine lost power before landing. The plane crashed about 35 ft from the approach end of runway 27. Two telephone poles were damaged. The wind was gusting to 35 knots. An examination of the engine revealed a…NTSB ATL82IA109Incident · No injuriesIncident investigationFinal reportBeech BE-99 · Asheville, NCDuring takeoff on a regularly scheduled passenger flight the aircraft sustained a total engine failure and flameout on the right engine. After securing the engine, the crew executed an uneventful single engine landing without further damage to the aircraft or…