NTSB investigations
4,618 cases where the first occurrence was “Loss of engine power”.
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\" = 350) 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" = 350) 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 DEN87LA100Accident · Minor injuriesLimited investigationFinal reportAero Commander A-9B · Wood, SDA commercial ag plt was working a field with 2-4-D and had been spraying for 15 minutes. On a turn to reverse direction at the end of a pass, the plt started a 45 degree bank pull up and added full throttle. The engine then had a partial power loss and began…NTSB FTW87LA101Accident · Serious injuriesLimited investigationFinal reportSikorsky S-55B · De Quincy, LAThe pilot experienced an engine surge followed by a complete loss of power during a swath run of a tree spraying ag operation. The helicopter was over a densely wooded area and autorotated into trees. The owner was aware of a carburetor problem and had…NTSB SEA87LA083Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Twin Falls, IDDuring descent from cruise for landing the engine momentarily ran rough and then quit. The pilot attempted to land onto a road but struck a telephone pole in flight. The aircraft then descended onto the ground nose first. No reason for the engine failure…NTSB MIA87LA142Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Dundee, MSThe plt stated that when reversing direction after an aerial application maneuver the eng quit. He then landed the acft in a creek due to insufficient altitude to clear trees that were in the flight path. Upon touchdown the acft nosed over and came to rest…NTSB ATL87DEG04Accident · Minor injuriesFinal reportMclane Moni · Hillsboro, OHAft tkof fm the 3520 foot rwy, the plt stated that at abt midpoint with approx 1700 ft of rwy remaining, the eng sputtered and stopped. He was able to restart it again but aft several seconds it stopped again and he could not restart it. The plt then devoted…NTSB LAX87LA182Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Lincoln, CAThe aircraft collided with a ditch after a loss of pwr during t/o climb at aprx 350 to 400 ft AGL. The plt described the loss of pwr as 'like taking the throttle and pulling off in a rapid motion.' He noticed during his preflt check that the fuel in the right…NTSB LAX87LA181Accident · Minor injuriesLimited investigationFinal reportGrumman AA1C · Redlands, CADuring an instructional flight, the plt stated that the estimated fuel capacity in the acft was aprx 12 gals prior to departure. The plt took-off on the right fuel tank and flew in the local area for aprx 15 minutes then returned to the arpt for touch-and-go…NTSB CHI87DEE08Accident · 1 fatalFinal reportBede BD5 A-B · Kankakee, ILThe pilot took off on the first test flight in his homebuilt aircraft and after climbing to approximately 1000 ft. AGL, stalled the aircraft. The aircraft then subsequently entered a spin and collided with the ground. There were reports of the aircraft's…NTSB MIA87LA143Accident · No injuriesLimited investigationFinal reportCessna 177 · Pickens, MSThe plt reported that during cruise flt the eng RPM began to drop. He then applied carb heat, however, the eng then quit. A forced landing was made in a pasture. During the landing roll, the acft collided with barbed wire and a fence post. Post crash…NTSB MIA87IA134Incident · No injuriesIncident investigationFinal reportPiper PA-28RT-201 · Grant, FLThe CFI closed the throttle & announced a simulated forced ldg. Moments later, he advanced the throttle to clear the engine & found it would not respond. A forced ldg was then performed in a field without further incident. A subsequent exam of the engine,…NTSB LAX87LA175Accident · No injuriesLimited investigationFinal reportBeech C35 · Vacaville, CAThe plt stated he had flown the acft the day prior to the accident on the left fuel tank only. No fuel had been added on the day of the accident and the plt stated that the left tank was three quarters full and the right tank was full. The plt positioned the…NTSB MIA87LA136Accident · No injuriesLimited investigationFinal reportCessna 172N · Big Pine Key, FLThe plt stated that during cruise flt the eng began to run rough. He then attempted to solve the problem to no avail. Unable to maintain alt he elected to land the acft on a road. While taxiing, both wings collided with street signs. Post crash examination of…NTSB SEA87LA075Accident · No injuriesLimited investigationFinal reportVerbeek Rotorway · Redmond, WAThe plt stated that while at cruise the acft developed a vibration and noise, followed by a power los. The plt then entered into an autorotation and landed onto a rough field. The acft touched down hard and then rolled onto its side. During engine inspection…NTSB NYC87LA116Accident · No injuriesLimited investigationFinal reportErcoupe 415D · Warwick, NYThe flight was on approach for landing on runway 3 at Warwick airport when the engine started to sputter. The pilot continued to pump the throttle but overshot the runway and landed in a swamp. It was not determined what caused the loss of power to the engine.NTSB MKC87FA067Accident · Serious injuriesField investigationFinal reportBalloon Works Firefly 6 · Kansas City, MOThe pilot stated that lift-off and climbout were normal but, shortly thereafter, the fuel pilot light began to fail continuously until the burner flamed out. The passengers were briefed and the chase vehicle was contacted by cb radio before the plt climbed up…NTSB MIA87LA128Accident · No injuriesLimited investigationFinal reportPiper PA-18-125 · Ft.Lauderdale, FLThe plt reported that while towing a banner aprx 200-300 yards offshore at an alt of aprx 500 ft the eng sputtered, then quit. Attempts to restart it were unsuccessful. The banner was then released & the acft was ditched in the ocean. Post crash examination…NTSB SEA87LA073Accident · Minor injuriesLimited investigationFinal reportCessna TU206-F · Reno, NVWhile on base leg a loss of power occurred. The student pilot selected right fuel tank and applied the fuel boost pump. A restart was not successful. The instructor pilot then took the controls of the aircraft. He selected a road to land on because there was…NTSB SEA87LA074Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Forks, WADuring external load operation the aircraft's engine ceased operating. The helicopter was too close to the ground for recovery. The helicopter descended, struck the ground hard and then rolled over onto its right side. Water in the fuel was discovered after…NTSB LAX87LA161Accident · 1 fatalLimited investigationFinal reportBell 206B · Kona, HIThe pilot picked up two of the passengers at a resort hotel and then flew to kailua-Kona airport (koa). After hot refueling the helicopter with the two passengers on board, two more passengers boarded the helicopter and then the flight departed koa. When the…NTSB CHI87FA133Accident · 1 fatalField investigationFinal reportBeech V35-TC · Mount Vernon, ILThe acft was on a test flt after a top-overhaul had just been completed. Mechanics rprtd that before the flt, the eng had been properly rigged & operated normally drg run-up. Drg initial climb after takeoff, witnesses said the eng lost power. The plt…NTSB SEA87LA069Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Medford, ORA total and sudden loss of power occurred at about 3,500 feet MSL during climb for cruise. The pilot made a 180 degree turn back to the airport. Since an undershoot was assured the pilot elected to land the aircraft on a field. During landing rollout at about…NTSB LAX87DVD02Accident · 1 fatalFinal reportCulver Cadet LFA · Antioch, CADuring a local pleasure flt, witnesses observed the acft take-off into a headwind. At aprx 1000 ft AGL, the nose of the acft came up then down. The acft entered a spin and collided with the terrain. They also stated that the propeller appeared to be slowing…NTSB MIA87LA116Accident · No injuriesLimited investigationFinal reportBell 47-D1 · Homosassa, FLThe plt stated that just after takeoff, at about 50 ft, the eng lost power and he made a forced landing in a canal. No determination could be made as to the nature of the malfunction of the engine as described by the pilot.NTSB MKC87FA064Accident · No injuriesField investigationFinal reportCessna T337C · Garden City, KSBoth of the acft engs had just been overhauled. The plt decided to make a maint test flt & elected to leave the lndg gear in the down & locked psn. Takeoff & initial climb were normal until about 300 to 400 ft AGL. At that time the rear eng lost power. The…NTSB CHI87LA102Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Merrill, WIAircraft lost power on takeoff and plt made a forced landng in a rough field. The left main gear collapsed and substantial damage to the outer two feet of the right wing was sustained. Inspection of the aircraft after the accident did not disclose cause of…NTSB FTW87LA077Accident · No injuriesLimited investigationFinal reportBell 206B · Austin, TXAcft was damaged during a hard landing on a roof top heliport following a partial power loss as a result of an uncommanded engine deceleration. As the acft was 40' above and 40' out from the heliport pad, the power loss occurred and the plt stretched his…NTSB FTW87LA075Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · George West, TXAircraft collided with power lines during forced landing due to fuel exhaustion. Owner has not responded to letters. Warrant was issued for arrest of person thought to be pilot. Aircraft had traces of marijuana on board.NTSB BFO87FA027Accident · 2 fatalField investigationFinal reportRockwell 112 · Edgewood, MDOn the day of the accident and before the accident flight, the inlet fuel hose to the fuel flow divider was replaced. The hose assembly was fabricated by maint personnel. An inspection flight afterwards revealed engine roughness during fuel mixture leaning.…NTSB ATL87LA081Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Toronto, OHThe plt reported that the engine quit completely after takeoff at about 50-75 ft AGL without any warning. The plt attempted to land back on the rwy and the acft overran the rwy end. Examination of the acft after the accident revealed no malfunctions, defects,…NTSB LAX87FA135Accident · 3 fatalField investigationFinal reportGrumman American AA-5A · Tucson, AZA witness observed the airplane entering downwind with smoke trailing behind it. The pilot communicated to UNICOM that: 'the engine has quit; I have to get down'. The witness then observed the airplane making a tighter-than- normal 'base to final' turn. The…NTSB MKC87LA060Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Carlisle, ARThe PIC was climbing enroute to a field to spread fertilizer. Abt 2 minutes into the climb the acft eng quit. The forced landing substantially damaged the acft. The PIC commented in his rpt that he should have checked fuel before departure even though he had…NTSB MKC87LA053Accident · No injuriesLimited investigationFinal reportBeech C23 · Grain Valley, MOThe plt reported that the preflight eng run-up was satisfactory. Shortly after takeoff, the eng faultered briefly and the plt attempted a landing back on the rwy. Upon establishing a point to land, the eng responded and the acft overshot the intended landing…NTSB LAX87LA132Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Redlands, CADuring a pleasure cross-country flt, the plt reported that he was descending from 8500 ft MSL to 4000 ft MSL with power reduced to 2000 RPM. The plt stated that he did not use the carburetor heat while descending. When pwr was added, the eng did not respond.…NTSB MIA87FA091Accident · Serious injuriesField investigationFinal reportBeech A36TC · Orlando, FLDrg the takeoff roll, lgt colored smoke was seen trailing the the acft. The plt rprtd that at 100 to 200 ft AGL, the englost partial pwr. He said he checked all ctls & raised the lndg gear. Witnesses rprtd that at about that time, heavy smoke bgn trailing the…NTSB LAX87LA118Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · San Diego, CADuring a local pleasure flight, the pilot returned to the airport to practice touch-and-go landings. On take-off, ascending through 200 feet, the engine began to surge then quit. The pilot made a forced landing on an occupied road where the aircraft collided…NTSB LAX87DVA05Accident · No injuriesFinal reportHiller OH23D · Coalinga, CAThe plt reported that before he began the agricultural aerial application flight he noted that the fuel gauge was inoperative. The plt completed two flights, returning to the loading area after each flight. After completing the third flight and while…NTSB CHI87FA085Accident · 2 fatalField investigationFinal reportBeech E18S · Quincy, ILThe acft, at near gross weight (CG unknown), was on initial climb after takeoff. A witness reported that engines soundednormal. At about 400 ft AGL the acft was reported to pitch up about 10 degrees, then level off and enter a left turn. The acft made another…NTSB BFO87FA020Accident · Serious injuriesField investigationFinal reportPiper PA-38-112 · Mount Airy, MDThe instructor pilot simulated an engine out emergency by retarding the throttle. The student, who had not soloed, became engrossed in handling the emergency. The instructor kept his hand on the throttle throughout the practice maneuver. When he applied full…NTSB NYC87LA078Accident · No injuriesLimited investigationFinal reportCessna 150C · Downingtown, PAA precautionary landing was made in a snow covered level field due to a loss of power for unknown reasons. The aircraft was substantially damaged.NTSB FTW87LA057Accident · 2 fatalLimited investigationFinal reportBell 206L-1 · Matagorda 665The plt took off fm an off-shore oil platform with 3 pax on board. Shortly after depg, he transmitted a 'mayday,' but did not state the nature of the emerg. A pax rprtd that the eng sound changed & the plt told him to 'get the raft out.' Subsequently, the…NTSB FTW87LA058Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Kingfisher, OKThe pilot stated that he was demonstrating emergency landing procedures to the student pilot. At about 1000 AGL he instructed the student to apply full power for a go around. According to the pilot, the engine developed full power for about 30 sec. And…NTSB NYC87LA074Accident · No injuriesLimited investigationFinal reportCessna 152C · Washington, CTThe flight departed newport state airport, newport, rhode island on a student solo cross country enroute to waterbury, Connecticut. While over Washington, Connecticut, the aircraft began losing rpms and altitude. The acft was substantially damaged during the…NTSB NYC87LA072Accident · No injuriesLimited investigationFinal reportCessna 172 · Lawrence, MADuring a simulated engine out, the aircraft collided with power lines, while climbing out after descending over a possible landing area. The aircraft was able to continue flight and land at bedford, Massachusetts without further incident.NTSB MKC87IA043Incident · No injuriesIncident investigationFinal reportEmbraer EMB-120 · Springfield, MOThe PIC of this air midwest flt 4408 said that, while on initial climb, power (np) on the left engine decayed to 60% and would not recover. The engine was feathered by condition lever but the torque rose to 140% while returning for a landing, according to the…NTSB LAX87FA093Accident · 4 fatalField investigationFinal reportCessna 177RG · S Lake Tahoe, CAAfter departing at night from south lake Tahoe, CA, the plt contacted ARTCC & requested radar flt following. A short time later, he declared an emergency & said he was reversing course with a loss of eng power. Radar & radio contact with the acft were lost as…NTSB LAX87LA099Accident · No injuriesLimited investigationFinal reportHughes 369D · Lemon Cove, CAThe plt rprtd that while at 100 to 150 ft AGL on an apch to land, the eng lost pwr as though it had flamed out. He entered an autorotation, but was unable to reach the helipad. Subsequently, the helicopter landed in trees & was badly dmgd. Drg the…NTSB NYC87LA059Accident · No injuriesLimited investigationFinal reportCessna 150 · Montgomery, NYDuring an instructional flight to orange county airport, a simulated engine out was performed while on approach for landing. Directional control was lost and the flight landed west of runway 3 in snow causing substantial damage.NTSB NYC87LA055Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Yorktown Hgts, NYThe acft en route from gaithesburg, Maryland to brookhaven, new york, experienced fuel exhaustion and was forced landed in a rough meadow and was substantially damaged.NTSB NYC87LA051Accident · No injuriesLimited investigationFinal reportCessna 201A · Scotias, NYThe flight experienced an engine power loss when the throttle was reduced and the pilot turned the aircraft in an attempt to make the field, the aircraft was landed in a swampy area off the arpt when the field could not be reached. Investigation revealed no…NTSB MIA87LA050Accident · No injuriesLimited investigationFinal reportCessna 336 · Vero Beach, FLPlt stated the rear engine failed while in cruise flight and while making an emergency landing he approached the runway too fast. The aircraft touched down approximately two thirds of the way down the runway and when it could not be stopped the aircraft was…