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 NYC87LA131Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Dansville, NYAbout 5 min after taking off, the eng began running rough, then lost power & would not restart. Subsequently, the acft was damaged drg an emerg lndg in a potato field. The acft was moved before aviation inspectors arrived. No fuel was fnd in the fuel pumps,…NTSB ATL87FA212Accident · Serious injuriesField investigationFinal reportPiper PA-28 · Elberton, GAThe plt noted a progressive loss of pwr that began drg the climb to cruise. He diverted back toward the dep arpt & atmtdto restore pwr by activating the boost pump, moving the mixture to full rich, switching fuel tanks & applying carb heat. However, the eng…NTSB FTW87FA168Accident · Serious injuriesField investigationFinal reportPiper PA-28-181 · Jenks, OKAlthough it was determined that the engine failed due to fuel exhaustion, the exact sequence of events that led to this event was not determined. The pilot reported that the aircraft was out of fuel over the radio and no fuel was found in the aircraft. There…NTSB FTW87DRA07Accident · Minor injuriesFinal reportAir Tractor AT-301 · Anahuac, TXThe acft was substantially damaged when it encountered soft terrain and flipped over during a forced landing. The forced landing was executed following a complete loss of eng power during a swath run on an aerial application flight. The cause of the eng…NTSB LAX87DVG08Accident · Serious injuriesFinal reportBudde Cassutt CB-1 · Winter, CAA homebuilt cassutt racer crashed during initial takeoff climb after a loss of power. The pilot assembled the experimental racing airplane in preparation for a flight to an air race and had completed a series of starts and run-ups. 'Everything checked normal'…NTSB NYC87LA200Accident · Minor injuriesLimited investigationFinal reportChampion 7GCAA · Bargaintown, NJThe pilot reported that during climb out and level off after a banner pickup, the engine would not produce sufficient power to sustain flight. After checking the carburetor heat and mixture, he released the tow ropes and established a glide. Subsequently, the…NTSB FTW87LA163Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Tulsa, OKDrg the initial climb after takeoff, the acft's eng lost pwr. The plt landed the acft on a median in a residential & shopping area, where it nosed over. An exam & an opnl check of the eng revealed no reason for the loss of pwr.NTSB SEA87LA137Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Cashmere, WADuring aerial applications maneuver a loud whine accompanied by a loss of power occurred. During forced landing a hard landing was made collapsing the skids with the main rotor blades striking the ground. No reason for the power loss was found.NTSB NYC87DNE03Accident · No injuriesFinal reportNoble Falcon X-P · Wallingford, CTThe undetermined loss of engine power, and the pilot's poor aircraft handling during the resultant forced landing.NTSB CHI87DEC04Accident · 2 fatalFinal reportBeech S35 · Pontiac, MIAcft was making a low pass about 200 ft AGL over rwy 27L to allow ATCT personnel to inspect landing gear position after reporting landing gear difficulties. After twr personnel informed the plt that the gear appeared to be down, the plt requested to land on…NTSB ATL87LA197Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Fayetteville, NCDuring approach the pilot noticed that he was too high and fast for a normal approach. He reduced power and slowed the aircraft and increased the descent rate to attempt the landing. When he attempted to add power and arrest the increasing descent rate the…NTSB ATL87LA202Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Liberty, NCBfr departing on a ngt flt, the acft was loaded until it was at or near its max gross wt limit. The plt stated that as he was taking off on a 3000' rwy, the eng 'coughed' after the acft had accelerated to about the rotation speed & was aprx 3/4 of the way…NTSB MIA87IA195Incident · No injuriesIncident investigationFinal reportDouglas DC3A · Hilliard, FLAccording to the FAA the pilot stated that just after he rotated for takeoff the acft lost power in the left eng. He then aborted the takeoff, set the acft back on the runway & it slid off the left side into some bushes. The plts did not submit an operator…NTSB LAX87DVM04Accident · Minor injuriesFinal reportRand KR-2 · Watsonville, CAShortly after take-off on runway 19, the engine began 'sputtering' and losing power. The pilot tried adjusting mixture and throttle controls. The engine continued 'sputtering' and losing power and the pilot initiated an emergency descent. Having gained no…NTSB SEA87LA123Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Ketchikan, AKOn landing at Ketchikan airport the pilot stated he made a last minute runway change due to departing traffic. Turning base the pilot reduced power to idle. He then advanced the throttle and received no response. The pilot could not make the runway and…NTSB NYC87LA186Accident · No injuriesLimited investigationFinal reportCessna 172 · Olyhant, PAThe cross country personal transportation flight arrived in the scranton, Pennsylvania area for a planned refueling stop and encountered heavy fog conditions. Six attempts to land were made, but were aborted. An attempt to land at another airport was also…NTSB NYC87LA183Accident · No injuriesLimited investigationFinal reportCessna 150J · Olcott, NYA student pilot practicing touch and go landings experienced an engine power loss on takeoff. During an approach to an open field for an emergency landing, the engine restarted. The pilot decided to return to the arpt. Upon entering downwind, the engine quit.…NTSB CHI87LA158Accident · Minor injuriesLimited investigationFinal reportCessna 175C · Oshkosh, WIDuring cruise flight near Oshkosh the engine quit for undetermined reasons. The pilot contacted wittman field and was cleared by air traffic personnel to land on runway 27. Attempts to restart the engine were not successful and the pilot ditched the aircraft…NTSB CHI87LA155Accident · Minor injuriesLimited investigationFinal reportStinson 108-1 · Big Sandy Lake, MNThe engine stalled for undetermined reasons after the pilot made a wide circle turn. During a forced landing in a lake, the aircraft nosed over. The last annual aircraft inspection was 15 months prior to the date of the accident.NTSB ATL87LA184Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Cottonwood, ALThe plt stated that everything was normal for the acft during the preflt and runup. He had just about completed his first swath run when he reptd that the engine shook a little and started backfiring. He pulled up and started across a swamp toward a paved…NTSB NYC87LA181Accident · No injuriesLimited investigationFinal reportCessna 177RG · Batavia, NYThe flt made an emgy lndg in a corn field after experiencing a loss of eng pwr. During lndg roll the acft collided with a fence. Examination of the propeller revealed that the low pitch stop was broken and had separated from the piston causing the blades to…NTSB CHI87DEM08Accident · No injuriesFinal reportCessna 152 · Plainwell, MIThe aircraft experienced a total power failure and the pilot chose a wheat field on rising terrain for a forced landing. The field turned out to be rough and uneven. When the aircraft touched down, the nose gear failed and the aircraft nosed over. Subsequent…NTSB MKC87LA124Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Neelyville, MOThe ag pilot was making a low pass to wave his flagman out of the field. The engine response was slow and he was forced to land. To keep from hitting trees, pilot overbraked and flipped airplane forward to inverted position.NTSB NYC87LA174Accident · Minor injuriesLimited investigationFinal reportCessna 172 · West Milford, NJThe Cessna 172 is reported to have lost power after getting airborne while making a short field takeoff from a 1838 ft long runway. The student pilot told the operator he landed the aircraft on the remaining runway and ran off the departure end of the runway.…NTSB MIA87LA181Accident · Serious injuriesLimited investigationFinal reportCessna 150H · St. Cloud, FLThe plt stated that the engine ran good during the run up & on his takeoff roll the acft accelerated normally until he reached 45 knots, he looked down and noticed that the carburetor heat was on & he wasn't getting any more power. Realizing he was going to…NTSB DEN87LA150Accident · No injuriesLimited investigationFinal reportCessna A185E · Norwood, COThe plt was circling gnd psnl at 300 to 500 ft AGL, banking up to 60 deg, when the eng quit. An eng restart was successful; however, the acft was too low to recover & it collided with a fence. After hitting the fence, the acft crashed to the gnd & was…NTSB DEN87LA141Accident · No injuriesLimited investigationFinal reportCessna T210H · Salt Lake City, UTThe plt rprtd dscndg from 10,500 feet MSL for an apch to rwy 34 right at the Salt Lake City arpt. He stated he had selected landing flaps & had moved the mixture to rich & the prop to high RPM. At 8,500 MSL, 'the engine quit.' Subsequently, the plt made a…NTSB ATL87LA164Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Unity, OHThe CFI reported that he reduced pwr to near idle with the throttle, to have his student practice a simulated forced ldg. The engine subsequently lost pwr completely at about 400-500 ft AGL when he attempted to add pwr back so that the student could initiate…NTSB LAX87LA226Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Santa Barbara, CADuring an instrument landing system approach which is positioned partially over the water, the engine quit just after passing the faf. The pilot was unable to land the aircraft at the airport, instead, the aircraft was ditched in the ocean aprx 4 miles west…NTSB CHI87DEM07Accident · Minor injuriesFinal reportLake LA 4-200 · Fife Lake, MIThe plt stated that the engine started to run rough while in cruise flt. After all efforts to smooth it out failed, the plt elected to make a precautionary landing on Fife Lake. The acft landed normally followed by a loud noise and water started to enter the…NTSB LAX87DUG04Accident · Minor injuriesFinal reportGaston/Lakes Baby Lakes · Corona Airport, CAThe aircraft engine power reduced during the initial climb phase of the takeoff. The pilot attempted to return to the runway of departure. The aircraft landed hard on the airport and nosed over on its back.NTSB LAX87LA222Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Payson, AZA Bell 47G-3B-1 collided with trees and was subsequently destroyed by fire after a loss of power in a remote wilderness area. The pilot reported the engine went to idle during flight. He was unable to regain engine RPM by manipulation of the throttle. The…NTSB MKC87LA114Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Knoble, ARThe PIC had taken off for a local aerial application operation. While maneuvering to make initial application the acft started to lose power and sink during a downwind turn. PIC dumped his load but acft continued to sink until one wing struck the terrain and…NTSB NYC87LA156Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Cooperstown, NYThe pilot stated he departed farmingdale with two plus hours of fuel on board. After approximately 40-50 minutes of flight, the right low fuel pressure light and right fuel pump light flashed steady red. The pilot rechecked his calculations and determined he…NTSB LAX87LA221Accident · Minor injuriesLimited investigationFinal reportCessna 182G · Avenal, CAA Cessna 182G collided with trees during landing rollout on a dirt road. The pilot indicated during a telephone interview that the manifold pressure gradually dropped to 18 pounds. The aircraft was unable to maintain altitude and the pilot landed the aircraft…NTSB DEN87LA135Accident · No injuriesLimited investigationFinal reportCessna 152 · Ogden, UTThe student plt & CFI were practicing slow flt & stalls. Carb heat was applied before the start of each stall series. During the recovery from the last stall the student plt applied only partial pwr. The CFI applied full pwr & the eng began to run rough. The…NTSB LAX87LA214Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1 · San Ardo, CADuring a pleasure cross country flight, the engine experienced a partial loss of engine power. The plt made a forced landing where prior to touchdown the acft collided with power lines then contacted the terrain in aprx three ft of water. The acft has history…NTSB CHI87FA132Accident · 1 fatalField investigationFinal reportJauch Coot · Franklin Grove, ILThe plt deptd mendota, IL on a local test flt under a 40 hour time in service restriction in an experimental home built airplane. A witness stated that the airplane was circling over his farm and then turned south. He said the eng stalled and the airplane…NTSB ATL87LA138Accident · Minor injuriesLimited investigationFinal reportCessna 172-N · Walhalla, SCDuring a local sightseeing flight the plt trimmed the aircraft to a slow flight configuration, and circled a lake in the mountains of south carolina at an alt of approx 1,000 ft AGL. The aircraft was near max gross weight and the ground temp was 82 deg f. the…NTSB ATL87LA137Accident · Serious injuriesLimited investigationFinal reportMoss Timothy C Quicksilver MX · Monroe, NCThe student plt reported that the engine lost power while the ultralight-type acft was on final approach to a mowed field owned by him. The acft subsequently impacted a tree at the end of the field and fell to the terrain nose-down. The student pilot noted…NTSB MIA87FA157Accident · Serious injuriesField investigationFinal reportCessna 150M · San Juan, PRThe plt stated that he performed his run up check with 'normal results.' Ten degrees of flaps were set for a soft field takeoff, & during the takeoff roll, 'the aircraft ran normal.' At aprx 55 mph 'the aircraft left the ground and immediately it settled down…NTSB MKC87LA098Accident · No injuriesLimited investigationFinal reportCessna 172F · Blythville, ARThe eng started to slow down ten miles from the destination arpt and despite emergency measures, it stopped two miles out. The forced landing was in a plowed field and when the nose wheel dug in, the acft flipped forward to the inverted position. The…NTSB DEN87LA116Accident · No injuriesLimited investigationFinal reportWeatherly 620 · Greeley, COThe plt departed with full fuel in the acft to practice aerial spraying techniques. After 45 mins of practice he returned to the arpt for landing. He said that prior to entering the traffic pattern he switched from the half-full right tank to the full left…NTSB LAX87DVA07Accident · No injuriesFinal reportGrumman G-164A · Tulare, CADuring a climbing 180 degree turn to the left, the engine lost power. The pilot attempted to land in a nearby field that had just been plowed. With insufficient altitude to turn FAR enough to line the aircraft up with the rows, the pilot touched down at a '20…NTSB LAX87DVG04Accident · No injuriesFinal reportSchweizer G-164B · Pleasant Grove, CADuring an aerial application flight, the pilot reported that during a turn for the next pass over the field, the engine quit. The aircraft was turned into the wind and was landed on a rough plowed field. During the landing roll the aircraft nosed over. The…NTSB DEN87LA113Accident · No injuriesLimited investigationFinal reportBeech A24R · Beulah, WYThe acft lost power during a normal climb on a personal trip. The private plt noticed a drop in fuel flow pressure and smelled fuel. The plt then selected boost pump on but the pressure stayed low. The plt elected to make a forced landing and selected a…NTSB LAX87DVG05Accident · No injuriesFinal reportAero Commander S2R · Gridley, CAOn takeoff from a farmer's field the aircraft's engine lost power. The aircraft was unable to clear a levee, struck the levee and came to rest in a rice field. The aircraft's fuel pump was removed and tested. After one minute of operation the pump pressure…NTSB MKC87LA091Accident · Minor injuriesLimited investigationFinal reportBeech V35B · N Little Rock, ARThe acft was on a short ferry flt when the fuel pressure decreased and could not be restored. During the final apch of the forced landing on a city street, the acft struck a ground wire and fell to the street. Due to the intense fire that followed, the reason…NTSB LAX87DVA06Accident · 1 fatalFinal reportNorth American F-86F · Shafter, CAFollowing an airshow, the pilot transmitted while on final approach to the runway, that the engine had seized. The aircraft was landed with the landing gear retracted. During the flare the aircraft became uncontrollable, bounced several times on the runway,…NTSB LAX87DUG03Accident · Serious injuriesFinal reportFrimelt Werner Moni 164 · Lake Riverside, CAJust after take off of a homebuilt, experimental acft, a witness observed the acft at aprx 150 ft AGL initiate a 15 deg turn to the right. Immediately thereafter the acft pitched down slightly and began to lose altitude, then abruptly entered a spin and…