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 FTW86LPJ11Accident · Minor injuriesFinal reportHomebuilt SA-100 · Oklahoma City, OKThe acft nosed over during a forced landing after a power loss. The plt stated after the accident that the engine lost power during a roll maneuver. The engine ran for a short time at aprx 1800 RPM and then stopped completely. The plt landed in a cultivated…NTSB SEA86LA210Accident · Minor injuriesLimited investigationFinal reportWise OR-71-B · Richland, WAWhile on a qualifying lap for an air race the number one piston failed. A forced landing was then made onto a field.NTSB MIA86LA235Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Ft.Lauderdale, FLFlt experienced loss of power in the left engine shortly after takeoff due to corrosion blocking the main jet in the fuel control unit. The pilot feathered the engine and returned for a landing. While on short final he remembered he would have to manually…NTSB FTW86LA148Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Altus, OKThe engine failed at 10,500 feet MSL and the pilot was vectored to a small private sod strip. However, this strip had been closed and plowed up for about a year and was not listed on the current aeronautical charts. The pilot was then revectored to another…NTSB LAX86FVM06Accident · No injuriesFinal reportHiller UH21E · Salinas, CAThe plt experienced a 'ratcheting' to the right and a decrease in rotor RPM during cruise flt at 75-100 ft AGL. The plt made an autorotation but could not cushion the landing due to the low alt and lack of rotor RPM. The helicopter impacted hard and…NTSB MIA86LA230Accident · No injuriesLimited investigationFinal reportMooney M20E · Arcadia, FLDuring cruise, the plt attempted to switch fuel tanks and the fuel selector valve became stuck in the 'off' position. A successful gear-up forced ldg was made in a field. An exam of the valve confirmed that it was stuck due to corrosion and rust, the…NTSB NYC86FA196Accident · 1 fatalField investigationFinal reportGrumman TBM-3E · Brooklyn, CTThe acft was being flown to the owner's residence when the accident occurred. Shortly after takeoff black and white smoke was observed emitting from the eng cowling and the eng was heard sputtering. According to witnesses, the acft leveled off at an alt of…NTSB FTW86LA141Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Bartlesville, OKThe plt took off on a test flt after an annual inspn of the acft & a top overhaul of the eng had been completed. While climbing thru about 1200 to 1300 ft AGL, the eng started running rough, then quit. The plt attempted to return to the arpt, but was unable.…NTSB MIA86LA221Accident · Minor injuriesLimited investigationFinal reportCessna 210B · Hopewell, FLFlight experienced complete engine failure when crankshaft failed due to fatigue cracking of the crankshaft cheek between the number 1 and 2 rodbearing journal. During the subsequent forced landing the aircraft collided with trees due to the pilot not wanting…NTSB CHI86FEP07Accident · No injuriesFinal reportWheeler Gold Wing · Sturdevant, WIThis aircraft force landed shortly after takeoff and was substantially damaged when the wing struck the shoulder of a ditch during the landing. An examination of the engine after the accident revealed that the fuel pump was improperly installed (not in…NTSB MKC86LA162Accident · No injuriesLimited investigationFinal reportAero Commander S-2R · Dumas, ARThe pilot stated that after takeoff, during initial climb, he heard grinding metal and smelled hot metal before the engine slowed down and seized. After crash landing in a corn field, the pilot further stated, he noticed smoke coming from the engine…NTSB SEA86LA184Accident · No injuriesLimited investigationFinal reportCessna T-210 · Battle Mountain, NVAfter a loss of power and a propeller overspeed, a forced landing was made. The pilot diverted from two chosen landing sites due to power lines crossing them. A road was chosen and during landing rollout the aircraft's wing tip clipped the top of a fence. The…NTSB MIA86MA217Accident · 1 fatalMajor investigationFinal reportDouglas DC-3 · Isla Verde, PRShortly after takeoff, the acft's climb performance bgn to deteriorate & the r eng started to overheat. Subsequently, the r eng was feathered & the crew attempted to return to the arpt. The radio transmitter bcm unintelligible, so the tower psnl cleared the…NTSB ATL86FA203Accident · Minor injuriesField investigationFinal reportBell 222UT · Chapel Hill, NCDrg an emerg med svc (EMS)/med evac flt, an uncontained pwr turbine burst of the #1 eng occurred. Debris fm the #1 eng disabled the #2 eng & severed the tail rotor drive shaft. The #2 eng fire lgt illuminated & the plt discharged the #2 eng fire extinguisher.…NTSB ATL86LA199Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Orange Beach, ALDuring a banner towing flight along a Beach, the aircraft lost power and the pilot attempted a landing on the Beach of a small island. During landing roll the aircraft rolled into the water and flipped inverted. The operator of the aircraft reported that the…NTSB MKC86LA150Accident · No injuriesLimited investigationFinal reportStainbrook Avid Flyer · Salina, KSThe PIC had been practicing touch and go landings at a private air strip. At 50 feet AGL the PIC stated the engine quit and he descended into the ground off the rwy. Post accident inspection of the eng revealed that the propeller reduction gearing had broken…NTSB SEA86LA168Accident · No injuriesLimited investigationFinal reportBell 47G2A · Chehalis, WADuring an aerial applications maneuver, a complete loss of power occurred. The power loss was caused by failure of the connecting rod bolt. The acft was too low for autorotation and the aircraft struck the ground tail low. The main rotor blade then struck the…NTSB SEA86LA166Accident · No injuriesLimited investigationFinal reportRockwell S2R · Royal City, WAShortly after takeoff at an alt of aprx 110 ft AGL, a loss of pwr occurred due to the #2 cylinder failing. The acft nosed over during the subsequent forced landing in a wheat field. The plt then extinguished a small exhaust fire.NTSB ANC86LA103Accident · No injuriesLimited investigationFinal reportCessna 170B · Tekanika River, AKThe acft nosed over during the forced landing which followed a total loss of pwr. The plt reported he noted a decrease in oil pressure during cruise flt just prior to the pwr loss. Examination of the acft eng revealed that the #6 cylinder push rod had failed.NTSB NYC86FA176Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Seven Valleys, PAAircraft departed york airport and crashed 5 min later. The engine sump oil quick drain had disconnected and was not found. Engine oil was exhausted and the engine seized. A tree and utility pole were found damaged. The ramp and runway at york airport did not…NTSB FTW86FRD17Accident · Minor injuriesFinal reportGrumman G-164 · Rayville, LAThe acft crashed during takeoff after losing pwr during a turn at 150 ft AGL. The plt said that the acft stalled and hit in a cotton field about 1/4 mile from the arpt. The plt also said oil hit the windshield about 3 seconds before pwr failure. The acft was…NTSB BFO86FID09Accident · No injuriesFinal reportPiper PA-28R-200 · Montpelier Sta., VAThe acft collided with 2 fences during an off arpt forced landing after a pwr loss. Post acc eng inspection showed internal failure of the eng. #2 connecting rod bolt failed in fatigue through 40 percent of the diameter. The remainder failed in tension. The…NTSB MKC86LA135Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Mammoth Spring, ARThe pilot stated that the aircraft had plenty of oil prior to departure and that the flight was proceeding normally when, suddenly, the oil pressure dropped to zero. While subsequently heading for a nearby airport, the engine lost power and seized, forcing an…NTSB MIA86FLT01Accident · Serious injuriesFinal reportAmateur Built Eenie TWO · Waynesboro, MSThe acft nosed over during a forced landing after a power loss. According to witnesses the acft made a climbing turn after takeoff followed by a low pass near the witnesses. The acft then disappeared behind some trees and when it reappeared the engine was not…NTSB SEA86LA150Accident · No injuriesLimited investigationFinal reportPiper J3C · Kent, WAA forced landing was made after a total loss of power. Landing was accomplished onto very rough rising terrain. During landing roll the left main gear collapsed. Investigation revealed a broken crankshaft. A top overhaul had been done less than 30 hours prior…NTSB MIA86LA189Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Punta Gorda, FLThe plt stated that after a 20 minute flight on a long final approach the engine sputtered & quit. A forced landing was made in a residential area and the acft went through a ditch severing the landing gear. Post crash examination of the carburetor revealed…NTSB NYC86LA154Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Wayne, NJThe aircraft developed engine problems while on approach to the airport at caldwell, new jersey and collided with trees during the forced landing. Upon examination of the aircraft, debris was found in the vent line from the fuel vent tube to the left fuel…NTSB MIA86LA187Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Plant City, FLWhile on a dual student plt flt, about 10 minutes after takeoff, the eng began severely vibrating. The instructor plt took control of the acft, reduced power and established a glide to a local arpt. The engine then suddenly failed completely. The instructor…NTSB ANC86LA089Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Egegik, AKThe airplane experienced a power failure and nosed over in one foot of water while making an emergency landing on a beach.NTSB DEN86FTK03Accident · 1 fatalFinal reportPiper PA-25 · Badger, SDThe acft nosed over during a forced landing after takeoff. The acft was landed straight ahead and rolled out into a standing pool of water 8-10 inches deep where it flipped over crushing the canopy and trapping the plts body. During post acc invest sediment…NTSB FTW86LA119Accident · Serious injuriesLimited investigationFinal reportAerospatiale AS35OD · Theriot, LAThe pilot experienced a sudden yaw in the helicopter at cruise flight. The ng started winding down confirming an engine failure. The pilot had to extend an autorotation over a tree line, which caused the RPM to decrease, and made a hard landing in an adjacent…NTSB FTW86FPA24Accident · 1 fatalFinal reportRepliea 78 Ral Fokker DV III · Slidell, TXThe shutoff mechanism and handle separated from the fuel shutoff valve body and fell to the floor. This stopped the fuel flow to the engine, resulting in a total loss of engine power in the uncetificated home built aircraft. It was not determined why the…NTSB SEA86LA143Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Zillah, WAEn route to the local spray area a total loss of power occurred along with a loss of oil pressure. The acft was aprx 200 ft AGL over a pear orchard. The plt was attempting to autorotate onto a nearby road but the left skid caught the roof top of a metal shed.…NTSB MIA86LA179Accident · No injuriesLimited investigationFinal reportPiper PA-24-400 · St.Augustine, FLA forced ldg was made after the eng failed while cruising at 8000 ft. an exam of the eng revealed that the top of the crankcase was cracked & a hole was in the top of the case at the no. 2 cylinder. The bottom of the cap of the no. 2 connecting rod had broken…NTSB MIA86LA174Accident · No injuriesLimited investigationFinal reportRandy Tredo Mustang II · Ocala, FLThe plt stated that just after takeoff he lost all engine power and upon landing in an open field the gear collapsed. Examination of the eng revealed that the butterfly valve in the carburetor heat box broke off and slid back into the carburetor opening and…NTSB BFO86LA034Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Concord, VAThe acft experienced a total loss of pwr during cruise. A forced ldg was made on a hwy and the acft struck a road sign. Post-crash examination of the acft engine revealed an inoperative engine fuel pump.NTSB MKC86LA126Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Hickory Ridge, ARThe plt stated that the takeoff was normal up to the initial climb when, at this point oil began streaking from the engine and it lost power. According to the plt, he immediately tried to dump the fertilizer and look for a place to land but, due to the…NTSB ANC86IA066Incident · No injuriesIncident investigationFinal reportCessna 207 · Manokotak, AKDuring cruise flight the engine began to run rough. The pilot attempted switching fuel tanks but the engine continued to run rough. The engine ceased operation and did not windmill during the emergency descent. An examination of the engine later revealed that…NTSB BFO86FA032Accident · Serious injuriesField investigationFinal reportBeech J-35 · Myersville, MDWhile in cruise flight at 3500 feet the pilot stated he experienced a rapid loss of power. Unable to restart the engine, he was forced to land in a pasture which was divided by barbed wire fences. The aircraft collided with a fence and came to rest inverted.…NTSB ATL86LA158Accident · No injuriesLimited investigationFinal reportCessna T188 · Tyler, ALDuring a takeoff from a field strip the plt experienced a complete eng failure. The plt made a forced landing in a pecan orchard which resulted in airframe damage. Powerplant exam disclosed that the eng drive fuel pump had failed.NTSB MKC86LA121Accident · No injuriesLimited investigationFinal reportAero Commander S-2R · Pocahontas, ARThe pilot stated that this was his third flight of the morning with a full load of fertilizer. Reportedly, he was in the process of aerial application, when the engine quit. He made a forced landing on a short field road. He further stated that the ground…NTSB NYC86FA138Accident · 4 fatalField investigationFinal reportCessna 172M · Cairo, NYWitnesses saw black smoke trailing the acft shortly after it became airborne about 50 ft above the rwy. Shortly afterward, a loss of power loss occurred. The acft descended and collided with the ground in a nose low attitude. The rwy is 2,700 ft long and…NTSB SEA86LA133Accident · No injuriesLimited investigationFinal reportCessna 188B · Nyssa, ORDuring aerial application the engine ceased operating due to a broken shaft in the fuel pump. The boost pump was turned on and the engine ran momentarily. The pilot was unable to dump his 700 pounds of dry chemical and had to keep a nose down attitude in…NTSB MKC86FPG04Accident · Serious injuriesFinal reportHomebuilt Jodel F-9 · N. Little Rock, ARThe acft stalled and impacted the terrain in a nose low attitude during an attempted forced landing following an eng failure. Post accident inspection revealed the magneto drive coupling had failed. There was evidence present which indicated wear on the…NTSB NYC86LA126Accident · No injuriesLimited investigationFinal reportCessna P206A · Wellsboro, PAThe acft was cruising at 5,500 ft when the plt experienced a total loss of power. He tried to make it to the Wellsboro arpt, however, he was unable to and landed the acft in a field. The acft ran through a fence and was substantially damaged. When the engine…NTSB NYC86LA122Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Otselic, NYThe Cessna 182P was cruising at 2500 ft when it experienced an engine failure. The pilot made a landing in a plowed field across the furrows. The nose wheel broke off on landing and the aircraft flipped over. The pilot received minor injuries while the…NTSB ATL86FEK01Accident · No injuriesFinal reportCessna 182D · Mt. Gilead, OHThe acft collided with the ground in a plowed field during a forced landing after a power loss. Post acc inspection of the eng revealed 3 pieces of felt like seal material lodged in the carburetor venturi. This felt was identical to the missing seal from the…NTSB LAX86FA207Accident · Serious injuriesField investigationFinal reportCessna P210N · Long Beach, CAWhile enroute from cincinnati, oh (luk), to torrance, CA, the airplane experienced a total engine power loss about 10 miles south of Long Beach airport (lgb), Long Beach, CA. The pilot attempted to land at lgb but the acft alt was insufficient. The acft…NTSB ATL86LA122Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Clyde, OHThe acft was approaching a grass airstrip when the eng quit.a landing short of the rwy in a wheat field resulted in a collapsed nose gear. Exam of the acft revealed a birds nest inside the eng cowling, a dead magneto, reversed 'p' leads, and one shorted…NTSB CHI86FEX08Accident · Minor injuriesFinal reportConner KR-2 · Hagerstown, INDrg takeoff, the eng sputtered & quit at about 350' AGL. The plt rprtd that he turned on the electrical fuel pump, but did not get the eng started. Subsequently, the acft hit a tree & crashed inverted on the ground. An investigation revealed the push rod for…