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 SEA87LA188Accident · 1 fatalLimited investigationFinal reportMercer OWL Racer 65-2 · Reno, NVDrg a practice flt in a formula one racer bfr the Reno air races, the eng lost pwr after 4 laps when the acft was at an alt of about 40' AGL. The plt maneuvered to lnd on a rwy in winds that were variable & gusty. A witness rprtd the plt made an abrupt left…NTSB MIA87LA243Accident · Minor injuriesLimited investigationFinal reportBeech V-35B · Apalachicola, FLThe plt stated that while on final apch to st. georges arpt he lost power. On an attempt to go around collided with trees, flipped over & came to rest inverted.NTSB BFO87LA064Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Clinton, MDDuring takeoff with the aircraft over the end of the runway, power loss occurred. The pilot landed straight ahead in a field and nosed over. Examination of the aircraft did not disclose any mechanical malfunctions/failures. The engine was started and operated…NTSB NYC87DHA02Accident · 2 fatalFinal reportKolb Twinstar · Hilltown, PAAfter the acft took off, witnesses heard a power change & saw what appeared to be a left turn to return to the grass strip. Subsequently, it entered a descent & crashed in a left wing down, nose low attitude. The passenger was taken to a hospital, but died…NTSB LAX87LA330Accident · No injuriesLimited investigationFinal reportBeech H35 · Avenal, CADuring a pleasure flight, the pilot noted that the oil pressure was reading low. The pilot decided to make a 180 degree turn to land at a nearby airport. En route the oil pressure continued to drop. During the first landing attempt the pilot stated the…NTSB MIA87LA241Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Ocala, FLShortly after takeoff, the eng began to lose pwr & the plt was unable to maint alt or return to the arpt. He elected to land on a road, but there was oncoming traffic, so he maneuvered to the left side. Subsequently, the left wing collided with a utility…NTSB NYC87LA246Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Harrisburg, PAThe aircraft engine lost power while descending for a landing. The plt stated that when he advanced the throttle the engine quit completely. During lndg alongside a turnpike, the nose wheel collapsed and the prop was damaged. Investigation revealed that the…NTSB MKC87LA170Accident · No injuriesLimited investigationFinal reportRyan ST3KR · Springdale, ARThe plt rprtd that shortly after takeoff, the eng lost power, recovered for a few seconds, then went to idle. Drg the few seconds that power was restored, he initiated a turn back toward the rwy. The plt said the acft started to snap roll to the left & went…NTSB LAX87DUG08Accident · Serious injuriesFinal reportBoyles Starduster II · Hemet, CAThe plt rprtd that shortly after takeoff, the eng began to 'cut out.' He moved the fuel selector to the reserve tank & activated the standby fuel pump, but was unable to restart the eng. Subsequently, the acft was damaged as the plt was making an emergency…NTSB CHI87DEX08Accident · Minor injuriesFinal reportChampion 7KCAB · Sheridan, INOn initial climbout at approximately 400' AGL the aircraft experienced a total power failure. The pilot attempted to maneuver the aircraft to return to the airport, however, the aircraft was forced to land in a farm field 1/4 mile short of the airport. The…NTSB LAX87FA318Accident · No injuriesField investigationFinal reportBell 206L-1 · Covelo, CAThe pilot performed a vertical takeoff. At aprx 30 ft AGL, while transitioning to forward flight, the engine lost power and the pilot partially lowered the collective to maintain rotor RPM. The helicopter landed hard on sloping terrain and bounced laterally…NTSB MIA87LA230Accident · No injuriesLimited investigationFinal reportGrumman American AA-5 · Vega Baja, PRThe plt stated that he had descended from 4500 ft to get out of the clouds & at 1300 ft, the eng became rough. He stated the RPM dropped from 2300 to 1000. He also stated that he did not use carb heat prior to or during the descent. The plt stated that when…NTSB MIA87LA228Accident · Minor injuriesLimited investigationFinal reportNorth American AT-6D · Panama City, FLThe plt stated that he was inbound to sandy creek airport when he heard a loud bang and lost power. On landing rollout in a field the aircraft hit some sod, flipped over & came to rest inverted. Post crash examination of the engine revealed an internal blower…NTSB CHI87LA193Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Troy, MIWhile the plt was using short field techniques for takeoff, the acft lifted off into ground effect. At about that time, the plt thought there was a partial power loss. He stated, 'after perceiving a partial power loss which was accompanied with a loss in…NTSB NYC87LA235Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Lakewood, NJWhile returning to the arpt aft flying for abt 30 mins, the eng lost pwr. The plt attempted to restart the eng by checking the fuel tank gauges, carb heat, mags, etc but with no success. During the forced lndg, the acft was stalled into trees. No fuel was…NTSB DEN87FA220Accident · Serious injuriesField investigationFinal reportFairchild PT-23 · Englewood, COThe plt & pax were flying to cheyenne, WY to put N64038 on static display. The plt stated the eng lost pwr drg climb- out at aprx 300' AGL. He was unable to restore pwr & maneuvered for an off arpt landing. A witness stated that after takeoff, N64038 lvld off…NTSB LAX87LA289Accident · No injuriesLimited investigationFinal reportCessna 170A · Independence, CADuring a cross country flight, the plt stated that en route the engine suddenly lost partial power. The plt made a 180 degree turn to try an emergency landing at a nearby airport, however, the plt realized that he would be short of the rwy. The plt landed the…NTSB FTW87DRD14Accident · No injuriesFinal reportGrumman G-164B · Oak Grove, LAAfter completing the last pass of an agricultural operation the pilot pulled up and started a turn. At this time the engine started shaking and losing power. The pilot attempted a forced landing in a soft field. The wheels bogged four or five inches into the…NTSB FTW87FA196Accident · Minor injuriesField investigationFinal reportCessna P210N · Pearland, TXDrg arrival, the plt made a nr half circle ovr the arpt & entered a dwnwnd for rwy 14R. Drg the entry, he reduced pwr & noted 2 or 3 sputters fm the eng. Just bfr turning to a base leg, he advanced the throttle for adnl power, but there wasno response fm the…NTSB NYC87FA225Accident · 1 fatalField investigationFinal reportPiper PA-60-601P · Atlantic City, NJDuring the takeoff roll witnesses observed the aircraft swerve from left to right with the engine(s) 'missing' or intermittent. The aircraft lifted off and climbed to approximately 50 feet AGL and continued across a waterway in a leftturn with the landing…NTSB FTW87DRA08Accident · No injuriesFinal reportArnold VP-2 · Baytown, TXThe newly constructed homebuilt acft experienced an eng failure during it's first takeoff. During the ensuing forced landing the acft collided with trees, substantially damaging both wings. The cause of the engine failure was not determined during the…NTSB ATL87DEK02Accident · 1 fatalFinal reportAllen Pitts Special S-1 · Lancaster, OHN52LA was being flown in a 2-acft acrobatic demonstration (demo). After takeoff, the plts bgn the demo by passing each other in a low alt knife edge maneuver over the rwy. After passing, they rolled inverted, until near the ends of the rwy, then rolled…NTSB NYC87LA219Accident · No injuriesLimited investigationFinal reportMooney M20C · Mclean, NYThe aircraft had flown for about 1-1/2 hours when the pilot began a descent from 12000 feet for an approach. However at 3500 feet, the engine suddenly went from normal cruise to idle. An emergency landing was made in a corn field and the aircraft was…NTSB DEN87LA210Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Albuquerque, NMThe private plt was returning from a business flight. The plt reported that the engine quit during the approach to landing. An emergency landing was made in an open field. The right wing hit a sign and skidded to rest across a paved road and into another open…NTSB NYC87LA222Accident · No injuriesLimited investigationFinal reportRobinson R22 · Burrville, RIAircraft lost engine power shortly after takeoff at an altitude of about 200 feet. Pilot attempted to autorotate back to the lake but during a turn to avoid collision with a boat, the helicopter crashed into the water. The reason for the engine power loss was…NTSB LAX87DUG06Accident · Minor injuriesFinal reportCurtiss JN-4 · Riverside, CADuring a business flight, the engine experienced a loss of engine power. The pilot made a forced landing in an open area where during the touchdown, the aircraft was substantially damaged. The plt stalled the acft while still several ft off the ground. The…NTSB NYC87LA221Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · N. Andover, MAThe aircraft lost power shortly after takeoff. The instructor pilot took control and due to the lack of altitude decided to land the acft straight ahead. The aircraft was landed on the grass beside the runway. Teardown of the engine revealed a stuck valve.…NTSB NYC87LA217Accident · No injuriesLimited investigationFinal reportRobinson R22 · Sterling, MABefore flying solo, the student plt & his instructor (CFI) practiced autorotations for about 1/2 hr. The CFI deplaned & the student took off on a solo flt. He flew to a reservoir area for more practice. After descending from about 1000' to 500', the eng lost…NTSB DEN87DTE02Accident · No injuriesFinal reportNord Stampe SV4C · Englewood, COThe plt reported that the eng lost power at about 100 ft AGL after takeoff and the forced landing resulted in substantial damage. Examination of the aircraft and engine after the accident did not reveal any evidence of pre-impact failure or deficiency.NTSB MKC87LA153Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Widener, ARThe ag airplane was making the final swath run over a cottonfield when the engine lost power. After touchdown in a ricefield, the airplane flipped forward to the inverted position. The reason for the power loss could not be determined.NTSB FTW87LA185Accident · No injuriesLimited investigationFinal reportCessna 150M · Sallisaw, OKThe acft impacted the terrain near the Sallisaw, Oklahoma airport. Visual meteorological conditions prevailed at the time of the accident. The pilot stated that the engine quit and he attempted a forced landing to a field. However, the pilot stated that the…NTSB MIA87LA218Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Pope, MSThe plt stated that after he made a swath run he was turning back for another run when the eng coughed & quit. He then landed in a field & on rollout he was closing in on some trees so he applied the brakes & the acft nosed over & came to rest inverted. Post…NTSB ATL87DKG05Accident · No injuriesFinal reportSchweizer G-164A · Summerdale, ALThe pilot was about to engage in an aerial application operation. During climb the engine lost power, the chemical load was dumped and the airplane was landed in an adjacent field. On rollout the airplane hit a ditch and nosed over. Examination of the engine…NTSB MIA87LA216Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · St Petersburg, FLAfter climbing abv 3000' drg an instrnl flt, the instructor (CFI) had the student lower the gear & flaps to a takeoff configuration & slow the acft below VMC (72 KTS). The CFI then shut off fuel to the left eng. The student followed the correct procedures to…NTSB FTW87LA180Accident · No injuriesLimited investigationFinal reportDouglas DC-3A · Laredo, TXThe left engine failed during initial climb immediately after liftoff. Airspeed could not be maintained with one engine out due to the fact that the aircraft was climbing slowly just above the surface and was loaded to 3,809 pounds above its maximum allowable…NTSB DEN87LA199Accident · Serious injuriesLimited investigationFinal reportBell 204B · Dubois, WYThe commercial plt was performing external sling loads in support of seismic operations. The plt reported that the engine failed during a load release and the plt executed an autorotation. This resulted in a hard landing in heavy timber on sloping terrain.…NTSB FTW87FA179Accident · 1 fatalField investigationFinal reportStinson 108-3 · Kirbyville, TXThe pilot approached the Kirbyville airport in preparation for landing, witnesses stated that smoke was observed coming from the engine area. The aircraft impacted 30 foot pine trees, & control was lost. The aircraft struck a large tree approximately 5 feet…NTSB MIA87LA215Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Atlantic Ocean (Atlantic Ocean)The flt was aprx 43 miles west-northwest of freeport, Bahamas, en route to fort lauderdale, FL when the plt observed theengine oil pressure gauge indicating zero pressure. He reversed course back to freeport, contacted miami radio and gave his location. The…NTSB LAX87DVM05Accident · Minor injuriesFinal reportScharschmidt LONG-EZ · Paso Robles, CAShortly after take-off on runway 01 the engine lost all power. Having gained 500' AGL the pilot attempted to turn 180 degrees and land on runway 19. Realizing he wouldn't make it to runway 19, the pilot decided to attempt to land in an open field to the…NTSB SEA87LA146Accident · No injuriesLimited investigationFinal reportDavis Starship Alpha · Burley, IDA loss of power occurred shortly after takeoff at about 100 feet AGL. Due to obstacles in the pilot's flight path landing had to be made in a river where the aircraft was substantially damaged. The reason for the power loss could not be determined.NTSB NYC87LA210Accident · Minor injuriesLimited investigationFinal reportBell 47G3 · Marston Mills, MAThe helicopter reached an altitude of about 50 feet when a loss of power was experienced. Immediately the pilot set up for an emergency landing and set the helicopter down. The aircraft, however, collided with the ground hard and incurred substantial damage.…NTSB NYC87LA208Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Bedford, MADuring a practice autorotation with power recovery, the rotor RPM bled off. Directional control was lost and the helicopter turned several times before hitting the ground. The helicopter rolled to the left and came to rest on its side.NTSB FTW87DRG05Accident · No injuriesFinal reportAero Commander S2R · La Joya, TXDuring an aerial application flight at a low altitude the aircraft's engine failed. A forced landing was made to a grassfield resulting in substantial damage to the aircraft. Disassembly of the engine revealed partial failure of the left magneto. The aircraft…NTSB MKC87LA143Accident · No injuriesLimited investigationFinal reportSchweizer G-164A · Lilbourn, MOWhile returning from an aerial application flight, the aircraft's engine lost power and quit. The pilot made a forced landing in a soft field and nosed over. Post accident inspection revealed a cylinder was cracked. Several hours after the accident, the…NTSB LAX87DVD03Accident · Serious injuriesFinal reportTemco TT-1 · Hayward, CAWhile on final approach after an extended descent at idle, the engine flamed out as the pilot advanced the throttle to reduce the rate of descent. During a forced landing short of the airport, the aircraft struck a light pole and telephone wires. After coming…NTSB DEN87LA191Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Portales, NMThe plt was practicing aerial application maneuvers without chemicals onboard. During a turn, the plt reported that the engine lost power. The plt leveled the wings and lowered the nose to gain airspeed. The plt selected a landing site and after touchdown,…NTSB CHI87DER10Accident · 1 fatalFinal reportAir Tractor AT-301 · Hollandale, MNAfter making a swath run the aircraft pulled up to clear power lines. Witnesses state that the engine cut out and aircraft pitched nose down and began to rotate. They state that the engine regained power just prior to impact. Subsequent investigation failed…NTSB SEA87LA140Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Deer Park, WADuring initial climb, at about 100 feet AGL, a loss of power occurred. The pilot made a shallow turn to avoid obstacles and landed in a plowed field. During landing roll the nose gear and right main gear collapsed, dragging the right wing. No reason could be…NTSB MIA87LA208Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT301 · Rolling Fork, MSDuring the swath run, the plt stated that the eng 'barked' once or twice just prior to impact with the trees. The acft hit the trees, rolled inverted & burst into flames. He stated that the seat belt & shoulder harness saved his life. The plt stated that he…NTSB CHI87LA173Accident · No injuriesLimited investigationFinal reportBeech C23 · Monticello, ILThe acft ran off end of the rwy after the eng lost power drg a practice short fld takeoff. According to the instructor (CFI), there was insufficient rwy remaining to stop the acft drg the aborted takeoff. Maintenance psnl could not duplicate the eng prblm…