NTSB investigations
5,891 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.
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\" = 353) 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" = 353) 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 ANC86LA079Accident · No injuriesLimited investigationFinal reportCessna 185F · Naknek, AKAirplane ran out of fuel on one tank. Altitude was too low to restart on other tank prior to ground impact.NTSB DEN86LA159Accident · No injuriesLimited investigationFinal reportCessna 150L · Bountiful, UTThe plt said he had been airborne for about 1.25 hrs when the eng began to cut out. Emerg procedures did not remedy the situation and an off arpt forced landing was necessary. The plt said he did not look in the fuel tanks prior to takeoff but relied on the…NTSB FTW86FRG26Accident · 1 fatalFinal reportBenson B-8M · New Braunfels, TXThe acft crashed out of control after the eng stopped during a landing approach, the acft had almost completed the 1st pattern around the field when the eng stopped. Investigation revealed a 1/4 inch nylon rope wrapped and tied around the rotor blade about 30…NTSB SEA86FA139Accident · Serious injuriesField investigationFinal reportHiller UH12B · Rathdrum, IDThe plt reported noticing the fuel gage was nearing empty shortly before the eng quit. The acft crashed during an attempted forced landing on a road. The plt stated he was flying the acft to his residence where it was based. Investigation revealed little fuel…NTSB LAX86FA243Accident · Serious injuriesField investigationFinal reportBell 206B · Hanalei, HIThe helicopter had just departed runway 05. Ground witnesses and several occupants in the helicopter reported that when it was about 150 ft AGL it sustained a total engine power loss. The pilot immediately entered into an abrupt right turn autorotation. The…NTSB ATL86LA159Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Fayetteville, GAThe plt reported that while on downwind the engine started to run rough. The plt applied carburetor heat and the engine quit. A turn toward a landing area was made; however, the acft collided with trees. Weather conditions at the time were favorable for…NTSB MIA86LA173Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Ormond Beach, FLThe plt stated that the acft engine lost oil pressure. He then dropped the banner, & ditched the acft in the ocean. Post crash examination revealed that the loss of oil pressure was due to oil starvation. No evidence of oil seepage was noted on or near the…NTSB LAX86LA253Accident · Minor injuriesLimited investigationFinal reportHall Christen Eagle II · Long Beach, CAWhile practicing touch & go takeoffs and landings on runway 25R at Long Beach international arpt, Long Beach, CA, the acft experienced a total engine power loss. The PIC was flying from the rear seat and reptd the acft altitude was insufficient to return to…NTSB ATL86LA157Accident · No injuriesLimited investigationFinal reportMooney M20E · Pell City, ALThe eng lost pwr and a forced landing was made aprx 5 miles south of the destination arpt. The plt reported that, prior to departure he visually examined the fuel tanks and estimated having aprx 9 gals total fuel onboard. He estimated that only 5 gals would…NTSB NYC86LA147Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Lenox Township, PAThe Cessna 152 experienced a power loss while being flown by a student pilot. During the forced landing the aircraft struck a utility pole and received substantial damage. The pilot was uninjured. Examination of the aircraft by the FAA showed the fuel tanks…NTSB NYC86LA146Accident · No injuriesLimited investigationFinal reportCessna 152 · Middletown, CTThe student pilot was on the third leg of an approved three leg cross country solo flight. He was instructed to refuel at the second stop. However, he made a decision not to refuel since the fuel tanks indicated about 1/2 full. The aircraft ran out of fuel…NTSB DEN86LA148Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Frederick, COAccording to the plt, he had descended from 8,200 ft AGL to 700 ft AGL in preparation for landing. The plt stated that when he started to add power, he noticed the engine had quit and a forced landing was made. During the investigation, the plt did not…NTSB LAX86LA236Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Long Beach, CAThe airplane crashed on final approach to runway 16L at Long Beach airport (lgb), Long Beach, California. The pilot reported that both engines sustained a total loss of power. The airplane's altitude was insufficient to land on the airport. The left fuel tank…NTSB CHI86LA147Accident · No injuriesLimited investigationFinal reportCessna 195 · Port Huron, MIThe flight was to be a currency flight for the plt who indicated the acft had sat unused for over 8 months. After 10-15 minutes of flight the engine stopped. A hard landing was made on lake st. clair and the acft was substantially damaged. When interviewed…NTSB ATL86LA146Accident · Minor injuriesLimited investigationFinal reportHughes 300/269B · Marshville, NCDuring an instructional flight, a power recovery was attempted at the completion of a practice autorotation. Power was applied and the engine lost power. The autorotation was completed to the preselected practice field and the helicopter rolled over after a…NTSB BFO86FA027Accident · 3 fatalField investigationFinal reportBellanca 17-30A · Riverdale, MDAircraft's engine sputtered and quit while the aircraft was climbing through 400 feet after departure. In an attempt to turn back to the runway the pilot stalled the aircraft and it descended out of control crashing into trees and the ground. Post crash…NTSB ATL86LA145Accident · Minor injuriesLimited investigationFinal reportLangeford Midget Mustang MM-1 · Fayetteville, GAThe plt had flown the acft for about 20 minutes in the local area after which he returned to the airfield and made an apch. He initiated a go-around and reached about 400 ft AGL when the eng quit. He made a forced landing in a field and the acft nosed over.…NTSB ANC86LA061Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Valdez, AKExamination of the aircraft fuel system revealed that water was found in the fuel lines.NTSB ATL86LA140Accident · No injuriesLimited investigationFinal reportCessna 150E · Gulfshore, ALThe pilot related that the aircraft ran out of fuel and he attempted a forced landing in a field 3 miles from his airport of intended landing. The fuel cells were not visually inspected to determine the fuel quantity, however, the pilot stated that the fuel…NTSB DEN86FA141Accident · Serious injuriesField investigationFinal reportCessna 150-H · Glen Canyon, UTWhile in a descent 20 miles before reaching the destination, the acft engine quit due to fuel exhaustion. The plt initiated an emergency forced landing to a dry stream bed in rough desert terrain. After touchdown, the acft impacted an embankment and flipped…NTSB DEN86LA139Accident · Minor injuriesLimited investigationFinal reportPitts S-1S · Denver, COThe plt report that he entered normal traffic for landing at front range airport. There were 3 or 4 acft preceding him so he extended his traffic pattern. After turning onto final approach about 1 mile from end of rwy, the plt said the eng quit abruptly. The…NTSB LAX86FA223Accident · 2 fatalField investigationFinal reportGeneral Balloon AX-6 · Temecula, CAThe balloon was going to participate in a 'hare and hound' event and had departed a festival staging area on a positioning flight. Prior to departing the area the balloon had flown for about 45 minutes. While enroute to the positioning area the balloon had…NTSB LAX86FA220Accident · 3 fatalField investigationFinal reportPiper PA-28-160 · Chino, CAAt the end of a 5.3 hr flt, the plt entered the traffic pattern & was hi on base & final apch. He elected to go around, but the eng lost power due to fuel exhaustion at about 200' AGL, just past the dep end of the rwy. The plt attempted to return to the rwy.…NTSB DEN86LA138Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Pierre, SDPlt said that while in cruise flt eng loss power. Plt made forced landing on road and lost directional control. Acft struck ditch, fence, then overturned. Acft last refueled two days before and was flown for one hour. Plt did not service acft prior to…NTSB ATL86LA135Accident · No injuriesLimited investigationFinal reportCessna T210N · Dothan, ALWhile on final approach for landing the aircraft lost total power and the pilot attempted a forced landing on a road. The aircraft landed across the road and ran into an open field. The pilot stated that the aircraft ran out of fuel.NTSB ATL86FA132Accident · 1 fatalField investigationFinal reportCessna 172D · Athens, GADuring the return from a local sightseeing flight, the pilot reported over the UNICOM that they were making an emergency approach and were out of fuel. An interview with one of the non-pilot passengers revealed that prior to the flight they discussed…NTSB MIA86LA160Accident · Minor injuriesLimited investigationFinal reportVarga 2150A · Kiln, MSThe plt stated that while on local flight he ran out of fuel & upon landing in a field, the acft struck a tree, severing the wings.NTSB FTW86LA087Accident · No injuriesLimited investigationFinal reportBoeing PT-13/E-75 · Dallas, TXThe plt had just departed the arpt, started to turn crosswind at 500 ft and began climbing, when the eng started sputtering and lost pwr. He did not have enough alt to return to the arpt and had to ditch the acft 200 yds off the north end of the rwy. No…NTSB ATL86LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Natural Bridge, ALThe student plt reported making an error during preflt planning for the solo x-country flt. The student's instructor didnot detect the error. The student plt flew an incorrect hdg, became lost and ran out of fuel. A forced ldg was made in a field.NTSB MIA86LA155Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Brooksville, FLThe plt stated that the acft lost power on initial climb while practicing touch & go landings. The acft crashed .2 miles from the end of the rwy due to the fuel selector being positioned to the right tank, which did not contain enough fuel to return to the…NTSB NYC86LA121Accident · Minor injuriesLimited investigationFinal reportCessna T337HPII · Newburg, PAThe Cessna 337P experienced fuel exhaustion and attempted a landing on a road. During the landing the aircraft struck telephone poles and received substantial damage. The pilot did not receive any injuries in the accident which occurred in visual…NTSB LAX86FVG04Accident · No injuriesFinal reportGrumman G-164 · Butte City, CAThe acft made a forced landing off arpt after a power loss during takeoff. The operator stated that water was found in the fuel system.NTSB MIA86FA148Accident · Serious injuriesField investigationFinal reportCessna 150H · Vero Beach, FLThe CFI & student plt were on a training flt. Witnesses heard the eng sputter, then cut out completely. One witness said he thought the plt would attempt a landing to the south, lengthwise, into a pasture bordered on all sides by trees aprx 50 ft high. The…NTSB ANC86LA054Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Atmautluak, AKThe air taxi pilot planned six hours of night flying with a five minute fuel reserve at his destination. When he saw that he would be unable to reach the destination, he diverted toward atmautlauk. However, the acft ran out of fuel as the plt was maneuvering…NTSB MIA86FA146Accident · 1 fatalField investigationFinal reportCessna 150F · Pembroke Pines, FLA witness stated that he was standing in his front yard when he heard an acft eng sputter & then completely quit. He looked up & saw the lights of the acft disappear behind trees, & moments later, he heard the acft crash. A post crash exam of the acft…NTSB LAX86LA209Accident · No injuriesLimited investigationFinal reportMooney M20C · La Verne, CAA total loss of eng power was experienced while on base leg for landing at brakett field. The acft was landed short of the rwy and a fence was contacted. Post accident inspection revealed the acft's fuel supply had been exhausted.NTSB ATL86LA121Accident · No injuriesLimited investigationFinal reportAyres S-2D-600 · Walterboro, SCThe acft was returning to arpt for fuel then was to resume fighting a forest fire by water dispersal. The acft experienced total fuel exhaustion on short final and force landed 500 ft from rwy.NTSB DEN86LA124Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Britton, SDThe acft was observed to climb to apprx 100 ft AGL, then turn & make a forced landing. The plt stated the eng had lost total pwr. The owner of the aircraft said that examination of the eng after the acft did not reveal evidence to explain the reported loss of…NTSB CHI86LA135Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Indianapolis, INThe acft had sat idle for four days in heavy rains prior to this flt. A loss of power was experienced during takeoff. The plt attempted a 180 deg turn back to the arpt during which the acft stalled and descended to ground impact. Aprx 2.5 ounces of water were…NTSB DEN86LA121Accident · No injuriesLimited investigationFinal reportPiper PA-25-260C · Lamar, CODuring the initial telephone interview, the plt stated the eng quit due to fuel exhaustion while returning from an ag spraying flt. However, in the plt accident report, the plt states that he could not rule out mechanical problems.NTSB LAX86LA201Accident · No injuriesLimited investigationFinal reportCessna 150M · Torrey Pines, CAThe student plt was on the final leg of a x-country flt when the eng quit. A forced landing was attempted on a beach during which the acft nosed over. The plt stated that he purchased 5.9 gallons of fuel at one of his points of landing. He did not report how…NTSB MIA86LA136Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Lauderdale, FLWhile towing a banner near the beach the aircraft's engine failed. The aircraft was ditched in the atlantic ocean and the pilot swam to shore. The pilot stated he became distracted watching the boats and failed to switch fuel tanks causing the right fuel tank…NTSB LAX86LA192Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Coolidge, AZThe plt shut down the acft eng when it surged during an encounter with turbulence. The plt initiated a precautionary downwind landing on a nearby airstrip and the acft overran the rwy and collided with a fence.NTSB LAX86LA191Accident · No injuriesLimited investigationFinal reportCessna 150J · Flagstaff, AZThe pilot was flying a round-robin flight from cottonwood, AZ to page, AZ, and return. The pilot had landed at page, AZ. While on the return leg of the flight the pilot noted his fuel gauges were 'low' and diverted to Flagstaff, AZ. When the acft was…NTSB ANC86LA048Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Soldotna, AKThe pilot stated that the aircraft is not equipped with a header tank on the fuel system. The engine was starved of fuel when in a shallow dive.NTSB SEA86LA109Accident · No injuriesLimited investigationFinal reportGrumman G164-A · Echo, ORA loss of power occurred shortly after takeoff on a downwind departure. A forced landing was accomplished onto a wheat field downhill. The aircraft nosed over during the landing roll. Post accident inspection of the aircraft disclosed fuel contamination.NTSB CHI86FEP04Accident · No injuriesFinal reportDay Skybolt DB · Wisconsin Rapid, WIThe plt thought he had sufficient fuel for a 'short trip around the pattern.' However, shortly after taking off from rwy 29, the eng began to lose power. The plt attempted to land on rwy 2, but all power was lost & he was unable to reach the rwy. He landed…NTSB MKC86LA093Accident · No injuriesLimited investigationFinal reportBeech M-35 · Marshall, MOThe pilot stated that all the tanks were full when he departed springdale, Arkansas and he flew en route for one hour on the left tank and thirty minutes on the auxiliary tank. The aircraft performed routinely en route and during letdown to the Marshall…NTSB MIA86LA125Accident · Minor injuriesLimited investigationFinal reportBeech B95A · St. Augustine, FLThe pilot in command did not assure that the fuel selector for the left engine was selected and in the detent prior to takeoff. On the initial climb the fuel selector moved slightly and the left engine failed due to fuel starvation. The pilot then did not…NTSB MIA86FA126Accident · Serious injuriesField investigationFinal reportBlythe Quickie · Eustis, FLThe student pilot departed on a student cross-country flight with 2 gallons of fuel in the tank of the homebuilt quickie. About 30 to 45 minutes later the engine failed at 1800 ft MSL. The student attempted to stretch the glide to a road and struck trees and…