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 LAX86LA199Accident · No injuriesLimited investigationFinal reportCessna 177RG · Placerville, CAWhile enroute to san francisco, CA the engine began to overspeed & the prop gov control was not effective in arresting/controlling the overspeed condition. Shortly thereafter the engine oil pressure depleted to zero. The pilot elected to land in the ice house…NTSB FTW86LQG15Accident · No injuriesFinal reportAviation ADV. Mustang Psid · Midland, TXThe experimental acft on a test flt suffered an engine failure during the final approach to land. The plt said that he did not believe he could make the arpt so he turned right to an open field to land downwind. Investigation after the accident revealed that…NTSB CHI86LA134Accident · Serious injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Mt Clemens, MIAfter aprx 20 successful takeoffs & landings, the eng of the helicopter lost power at about 300 ft AGL, due to a #1 connecting rod failure. During an autorotation, the helicopter landed in trees & was destroyed. Although the pilot was instructing a new…NTSB NYC86FGM01Accident · No injuriesFinal reportVere Eze Long EZE · Dorrseyville, PAThe homebuilt acft collided with a ditch during a forced lndg short of the rwy after a power loss during a test flt. The plt had noted smoke in the cockpit and a loss of oil pressure. As he returned to the arpt the eng began to run rough and surge before…NTSB MKC86LA091Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Salem, IAThe pilot states that the engine quit without warning as he was spraying a wheatfield. Pilot further states that he had very little time to pick a suitable landing area. He landed in hilly terrain and slid sideways into a crest, tearing out the right main…NTSB MIA86LA123Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Ocala, FLPurpose of the flight was to calibrate the spray equipment. The plt loaded the hopper with about 70 gallons of water and initiated a takeoff. At about 100 ft AGL on initial climb the cockpit filled with smoke and the eng failed. The acft struck a tree on…NTSB MIA86LA138Accident · No injuriesLimited investigationFinal reportBell UH-1B · North Port, FLThe flt experienced an eng failure at an alt of aprx 8 ft AGL shortly after takeoff and the helicopter sustained substantial damage when a hard landing was made. Post accident inspection of the eng revealed the pwr turbine wheel experienced a loss of two…NTSB ATL86LA109Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Birmingham, ALAfter takeoff pilot noted loss of engine oil pressure. Engine siezed and pilot landed short of runway. A/c hit ILS antenna during landing roll, severed right wing. Engine oil cooler line burst due to aging. Line was fabricated in the 1st qtr 0F 1972. Oil…NTSB SEA86LA099Accident · Serious injuriesLimited investigationFinal reportMorley Avid Flyer · Spokane, WAWhile on a five-mile final, a total loss of power occurred. A loose right magneto contacting the flywheel magnet and shorting the electrical system was found. In an attempt to miss a river in the approach path to the runway, the pilot attempted a 180 degree…NTSB MKC86LA084Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Perry, IAShortly after takeoff the PIC noticed a loss of engine pwr and flames erupting from the engine cowling. The PIC executed a turn back to the arpt as thick black smoke filled the cockpit. The PIC opened the side vent window to maintain sight of the ground and…NTSB NYC86LA100Accident · No injuriesLimited investigationFinal reportAerospatiale SA316B · Pittsburgh, PAThe pilot-in-command lifted off the helipad vertically to an altitude of 30 feet at which time he experienced a power loss. He backed up the helicopter 20 feet and allowed it to yaw to the right as it descended to the helipad. He landed on the helipad hard…NTSB LAX86DVA05Accident · No injuriesFinal reportGrumman G164A · Snelling, CAThe plt stated he had just lifted off during takeoff when the eng quit. The acft then stalled, hitting a canal and shearing off the main landing gear. The plt stated that a broken fuel line is suspect due to the sudden stoppage and intense ground fire. The…NTSB MIA86LA111Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Boca Raton, FLThe flt experienced a failure of the acft's eng while flying parallel to the beach and the acft was ditched in the atlantic ocean. Inspection of the acft after recovery revealed the foam air cleaner had been drawn into the carburetor air box and was blocking…NTSB FTW86FRD11Accident · No injuriesFinal reportGrumman G-164A · Crowley, LAThe acft crashed into wires and a house during an attempted forced landing. The plt was preparing to do rice seeding when the eng began to backfire & lose power. The plt was trying to return to the ag strip when the eng quit and he was forced to land. Eng…NTSB CHI86LA114Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Plymouth, MIThe eng quit during climb out shortly after takeoff. The plt switched tanks and tried a restart with no success. The acft then experienced a nose gear collapse and nosed over during a landing roll in a field. Investigation revealed the fuel line to the…NTSB CHI86FEX06Accident · Serious injuriesFinal reportPiper PA-32-260 · Henryville, INShortly after leveling the acft off at 9000 ft MSL, the plt experienced an engine failure. During the subsequent forced landing the acft struck a tree and was further damaged during the forced landing roll. Metallurgical exam revealed the crankshaft failed…NTSB SEA86LA084Accident · No injuriesLimited investigationFinal reportBob White AJ1 · Vancouver, WAA loss of power occurred due to a failure of the fuel pump while at cruise. A forced landing was made onto a soft, farmers field where the aircraft nosed over during the landing roll.NTSB LAX86LA155Accident · No injuriesLimited investigationFinal reportBell 206B · Huntington Bch, CAA Bell 206B collided with a berm after an eng failure while departing a helipad. The plt indicated he had just departed the helipad at night and at aprx 50 ft AGL the eng failed. The acft vertical fin hit the berm causing the tail boom to bend aft of the…NTSB NYC86LA090Accident · Minor injuriesLimited investigationFinal reportBeech S35 · Laconia, NHDuring cruise flt, the acft eng failed & oil covered the windshield & side windows. Subsequently, the acft crash landed into wooded terrain while in a wings level attitude at low speed. Tests showed the eng crankshaft had failed from fatigue. The fatigue…NTSB NYC86LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Springvale, METhe Piper cherokee PA-28-140 lost power and made an off airport landing 15 minutes after takeoff. The pilot reported an oil line broke and he lost all engine oil. A mechanic reported that there was no indication in either the engine compartment or the bottom…NTSB LAX86FVG02Accident · No injuriesFinal reportSikorsky S-55 · Afton, CAThe acft was landed off the arpt in a forced landing after a pwr loss. The acft was damaged in the hard landing. Eng teardown showed the r/h magneto model S7LV-2 had stripped distributor drive gears. No other abnormalities noted. The TSO of the mag was…NTSB SEA86IA080Incident · No injuriesIncident investigationFinal reportPiper PA-46-310P · Reno, NVAt FL250 the engine ceased operating due to a failed fuel pump. A restart was successful at 10,000 feet m.s.l. with an uneventful landing. This fuel pump (a model g) had a total time of three hours. It was a replacement for a model c fuel pump which had…NTSB ATL86LA099Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Crossville, TNOn takeoff the plt saw an oil leak around the prop hub. The acft was returned to the airport and the prop governor oil tube fitting was found to be cracked. The part was replaced and the flt was continued. The part was checked during a later refueling stop…NTSB LAX86LA142Accident · No injuriesLimited investigationFinal reportHiller 12E · Poterville, CAA Hiller 12E helicopter landed hard after an eng failure. The acft was enroute to another field site at aprx 100 ft AGL and 40 KTS IAS. The eng quit abruptly and the rotor RPM decayed 100 RPM. The acft was about 2,000 pounds gwt at the time of the accident…NTSB ANC86FA035Accident · Serious injuriesField investigationFinal reportCessna A185E · Anchorage, AKAcft hit trees and power lines and crashed on city residential street following engine failure during takeoff climb. Engine driven fuel pump failed due to long term exposure to water in fuel. Over two quarts water was collected from aircraft tanks after…NTSB ATL86IA098Incident · No injuriesIncident investigationFinal reportCessna 404 · Mc Rae, GADuring cruise flight pilot heard loud bang from right engine and right propeller feathered. Aircraft was diverted and landed with no further damage and no injuries to the pilot. Subsequent teardown of engine revealed fractured connecting rod. Examination of…NTSB FTW86FRG17Accident · Minor injuriesFinal reportCessna T210 · Ozona, TXThe acft was damaged in an off-arpt lndg after the eng quit. The plt said there was plenty of fuel on board the acft which was being ferried to its owner after an eng change. The plt was unable to restart the eng which had vibrated so that the plt thought he…NTSB ATL86LA089Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Hanceville, ALWhile enroute to birmingham the pilot experienced a complete power failure when no. 2 cylinder separated from the engine assembly. The pilot attempted to make an emergency landing on interstate 65 near Hanceville, AL, and the aircraftcollided with an…NTSB ANC86IA033Incident · No injuriesIncident investigationFinal reportCessna 207 · Barrow, AKEngine failed and seized in flight. A forced landing and the snow covered tundra followed with no injuries & minor damage to the airplane. Engine teardown and exam revealed #3 cylinder wrist pin broken.NTSB LAX86FVD06Accident · Minor injuriesFinal reportCallair A-9B · Lodi, CAPilot was returning to Lodi airport after aerial application when the engine lost oil pressure. The engine seized, and a forced landing was made in a vineyard.NTSB ATL86FA084Accident · Minor injuriesField investigationFinal reportBell B-214-B-1 · Bullard, GAA helicopter involved in a logging operation was in process of lifting a log when crew reported a 'loud explosion' and a loss of power was experienced. An autorotative landing was accomplished and a small engine fire was extinguished. The 1st stage turbine…NTSB ATL86LA083Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Hickory, NCDuring cruise flt, plt felt eng vib and diverted to nearest aprt. During the descent the plt heard an explosion, saw the eng cowl pop up and oil covered the windscreen. Established in a glide the acft collided with trees then the ground. Exam of the eng…NTSB CHI86LA091Accident · No injuriesLimited investigationFinal reportCessna 210M · While Lake Twp., MIThe acft was four miles from the arpt on an ILS apch when an eng failure was experienced. The acft was damaged during the forced landing on a frozen lake. Post accident eng teardown revealed the eng failure originated from movement of the #2 main bearing.…NTSB LAX86LA128Accident · No injuriesLimited investigationFinal reportRyan ST3KR · Camarillo, CAThe owner of the acft reported that he had just purchased the aircraft and was being checked out at the time of the accident. Shortly after departing cma and upon reaching 1200 ft MSL, the engine lost power. Unable to maintain altitude the check pilot assumed…NTSB FTW86FPA17Accident · Serious injuriesFinal reportCessna 421 · Alvord, TXThe acft collided with tree tops and sheared the landing gear during a forced landing off arpt. The left eng had been feathered due to loss of oil from a ruptured oil hose between the oil pump & filter. The rt eng was not developing full power because of an…NTSB DEN86FA077Accident · 3 fatalField investigationFinal reportCessna P210N · Dulce, NMThe plt with his 4 passengers, departed durango airport on an IFR flt plan en route to wichita, Kansas. The acft had a complete loss of pwr while climbing to attitude. The subsequent forced landing on unsuitable terrain resulted in substantial damage to the…NTSB CHI86LA084Accident · No injuriesLimited investigationFinal reportCessna 207 · Milwaukee, WIAfter preheating the eng the plt took off and during climb the cabin filled with smoke and the eng stopped. A forced landing was made on a city street during which the left wing contacted a sign pole. Post accident teardown of the eng disclosed that an oil…NTSB ATL86LA071Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Columbia, SCWhile on crosswind following takeoff the engine lost total power after climbing to 500 feet AGL. The pilot initiated a turn toward a field and collided with trees on the approach end of the field. Post-crash examination of the aircraft revealed that the…NTSB ATL86LA069Accident · Serious injuriesLimited investigationFinal reportHughes 269B · Council, NCDuring a control burning operation, the plt experienced a complete eng failure. The plt entered an autorotation and collided with trees. The eng examination disclosed that the #4 connecting rod had failed. The failure was determined to have resulted from…NTSB SEA86LA045Accident · Minor injuriesLimited investigationFinal reportBellanca 1413-2 · Vancouver, WAA total loss of power occurred due to a previously burnt flex hose which blocked air from coming into the induction system. The aircraft was unable to reach the runway and struck trees before it came to rest on the roof top of a residence.NTSB LAX86FVD04Accident · 1 fatalFinal reportVangrunsven RV-3A · Fortuna, CAThe acft stalled in a turn during a forced landing after the engine lost power. Post acc investigation revealed an inoperative fuel selector valve. Witnesses said that the acft did not sound like it was developing full pwr during take off roll. Shortly after…NTSB FTW86LRA06Accident · Minor injuriesFinal reportAerospatiale AS-350D · Freeport, TXWhile on a maintenance test flt the helicopter experienced an eng failure. An autorotation was entered and a hard landing occurred which resulted in a roll over. The flt originated at oyster creek heliport and returned twice for maintenance adjustments and…NTSB LAX86LA091Accident · Minor injuriesLimited investigationFinal reportBell 206B-3 · Waimea, HIWhile on a local flt, the plt descended to aprx 500 ft AGL and flew the helicopter along a coastal area. He reported the helicopter suddenly lost power and he initiated an autorotative landing to the beach where the helicopter 'had a hard landing.' An exam…NTSB CHI86LA062Accident · No injuriesLimited investigationFinal reportNavion A · Cincinnati, OHTen minutes after takeoff the plt heard a loud bang followed by a loss of eng pwr. The right main gear separated during the forced landing in a rough field. Examination disclosed the piston had separated from the wrist pin causing the #5 cylinder to separate…NTSB MIA86IA052Incident · No injuriesIncident investigationFinal reportCessna 402C · Ft. Lauderdale, FLThe plt stated that while making touch & go landing, after his third takeoff, the rt eng lost power & the acft began to drift right, he pulled the power off & landed gear up in the grass on the right side of rwy 08. Post crash examination of the right eng…NTSB MIA86MA048Incident · No injuriesMajor investigationFinal reportBoeing 727-232 · Fort Lauderdale, FLAfter gear retraction drg takeoff, at aprx 150' AGL, the aircrew heard a loud noise & noted the #2 eng had failed. They secured the eng, dumped fuel & landed without further incident. An exam of the #2 eng revealed the combustion chamber outer case, pn…NTSB LAX86LA076Accident · No injuriesLimited investigationFinal reportMooney M20F · San Manuel, AZDuring cruise at 10,500 ft MSL on a night x-country flt, the plt said the eng ran rough with moderate vibration levels. Plt declared an emergency with abq ARTCC, who vectored the acft to an unlighted airstrip. The plt said he had difficultyin seeing the rwy…NTSB LAX86LA075Accident · No injuriesLimited investigationFinal reportPiper PA-34T-22OT · Tucson, AZDuring a trans border VFR x-country flt, the plt noticed 'oil spirting from the left engine' with smoke, & he shut it down. An emergency was declared by the Tucson ATCT, who cleared the acft to land straight in on rwy 29L. Tower personnel observed the acft…NTSB LAX86LA068Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Canoga Park, CAWhile the plt was cruisin in his own acft, an eng oil leak developed, oil pressure decreased & eng power was lost, the plt attempted to make an emergency ldg on a city street, on approach the acft collided with power lines & a fence, & the acft came to rest…NTSB FTW86FRG05Accident · No injuriesFinal reportAdams William C Quickie Q1 · Beeville, TXThe acft crashed during a forced lndg after a power loss at 200 ft AGL during takeoff. The acft crashed on the arpt in a run-up area adjacent to the rwy. The only discrepancy noted during post acc exam was a very weak spark produced by the battery coil…