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 CHI86LA178Accident · No injuriesLimited investigationFinal reportCessna 172N · West Branch, MIThe student pilot's CFI had advised him to refuel at an en route arpt on the x-county solo flt because there was no fuel avail at departure arpt. The student did not dip thetanks but stated 'based on my calculations of fuel burn there should have been enough…NTSB MKC86LA152Accident · No injuriesLimited investigationFinal reportCessna 188 · Jonesboro, ARThe acft was engaged in spraying a rice field when, according to the plt, a total loss of power occurred. The acft was subsequently damaged during a forced landing in an open field. Due to the lack of fuel which he observed after the accident, the acft owner…NTSB MIA86LA215Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Dania, FLWhile flying along the beach the pilot noticed that the engine steadily lost power. The pilot then ditched the aircraft. Examination of the aircraft wreckage after recovery revealed that the fuel line from the fuel servo unit to the fuel divider block was…NTSB MKC86LA153Accident · Minor injuriesLimited investigationFinal reportStevenson Glasair · Oakley, KSThe PIC stated that he had not visually checked the acft's 4 gallon header tank prior to attempting takeoff. During the takeoff the eng would not produce full power. The takeoff was aborted and the PIC inspected the eng for a mechanical pblm. After the…NTSB MIA86LA214Accident · No injuriesLimited investigationFinal reportCessna 172P · Whiting, FLThe private pilot of a rented Cessna 172P experienced an engine failure after flying 4.7 hours on a cross country flight. During the landing roll the nose gear failed in rough terrain. No fuel was found in the aircraft fuel tanks or lines during recovery and…NTSB CHI86FER14Accident · No injuriesFinal reportBell-Campbell CHG-2 · Brooklyn Park, MNAccording to the pilot after making three quarter-mile passes over the field the engine quit and he was forced to make an emergency landing in a field. The pilot stated, prior to takeoff the helicopter had been refueled by a ground crew member. According to…NTSB SEA86LA171Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Ketchikan, AKThe plt was attempting to land when the engine ceased operating as the throttle was advanced. Subsequently, the acft struck an embankment short of the runway. The plt had selected the right fuel tank, although the normal procedures in the operating manual…NTSB LAX86LA292Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Hyampom, CAThe aircraft's engine quit when the flight was 25 miles short of its intended destination and an emergency landing was attempted in a river. The pilot stated that according to his calculations, the aircraft should have had a no reserve endurance of 6 hours…NTSB ATL86FEK03Accident · No injuriesFinal reportHiller UH-12E · Pataskala, OHThe acft autorotated to a forced landing after the eng quit at 600 ft AGL. The landing was made in a corn field. The plt told a FAA inspector at the scene that he had 8 gals of fuel remaining. When the fuel tank was drained it contained aprx 6 oz total. The…NTSB CHI86LA169Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Benson, MNThe pilot reported that he ran the right fuel tank dry before switching to the left tank in cruise flight. On final approach for a landing the engine began to falter and quit running shortly thereafter. The aircraft was landed short of the runway gear up in…NTSB ATL86LA204Accident · No injuriesLimited investigationFinal reportCessna C-152 · Conway, SCThe acft was based at an uncontrolled airstrip without fuel facilities. Prior to take-off, the plt refueled the acft from a 5 gal can and draining the fuel sumps. During an approach to land at Conway, SC, the acft lost power and a forced landing was made on a…NTSB ATL86FEG02Accident · Serious injuriesFinal reportSmith Miniplane · Miamisburg, OHThe acft crashed into a tree and the ground during a forced landing after a pwr loss from fuel exhaustion. The plt said that he had 10 gals of fuel at takeoff and after 20 mintues of flt the gauge indicated 5 gals. During the attempt to return to the arpt the…NTSB LAX86LA287Accident · No injuriesLimited investigationFinal reportCessna 150M · Sunnymead, CAThe newly certificated flight instructor departed on a local dual instructional flight with a first hour primary student. The CFI said that 'due to numerous distractions' he 'forgot to check the fuel level and departed on the flight without an adequate fuel…NTSB ATL86LA195Accident · No injuriesLimited investigationFinal reportCessna 150L · Shelbyville, KYThe plt rented the acft without verifying the actual fuel onboard. He then flew to his pvt strip, 26 NM away, and gave 'several' pax hops. About 5 mins after takeoff for the flt to return the acft to the owner's field, the engine started running rough and…NTSB NYC86FHM01Accident · No injuriesFinal reportPiper PA-25-235 · Goshen, NYA loss of engine power was experienced during takeoff. The plt was unable to maintain altitude and a forced landing was made in an open field. The nose gear dug into soft terrain and the acft nosed over. Post accident inspection of the acft revealed water in…NTSB ANC86LA104Accident · No injuriesLimited investigationFinal reportCessna 170 · Fairbanks, AKThe plt reported experiencing a total loss of pwr during cruise flt. He stated he switched fuel tanks and was temporarily able to regain pwr before experiencing a second total loss. Substantial damage resulted during the forced landing. During post accident…NTSB MKC86LA145Accident · No injuriesLimited investigationFinal reportCessna 182A · Davis City, IAStatements from FAA flight service station personnel indicate that the pilot received a weather briefing prior to departure but that a flight plan was not filed for the 600 mile trip. Records show that the flt lasted 05:28 hours before the engine sputtered…NTSB FTW86LA124Accident · Minor injuriesLimited investigationFinal reportCessna P-210N · Zachery, LAThe plt experienced a total loss of power due to fuel exhaustion during cruise flight. Approach control vectored him to a closer airport but the aircraft was beyond gliding distance and it collided with a house which was under construction. Inspection of the…NTSB FTW86LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Porum, OKThe student pilot became disoriented during a cross-country flight. He was unable to find an airport and had to land in a field due to fuel exhaustion. During the attempted landing he had to maneuver to avoid a herd of cows and collided with a concrete fence…NTSB CHI86LA164Accident · No injuriesLimited investigationFinal reportCessna 150F · Selfridge Ang, MIThe plt became lost at night over a large body of water and requested assistance. When identified by ATC, the acft did not have enough fuel remaining to reach an arpt. The acft suffered fuel exhaustion on final apch and was landed on a golf course 2000 ft…NTSB CHI86FEX10Accident · Minor injuriesFinal reportBell 206L-II · Kokomo, INThe helicopter experienced a loss of power during cruise, for undetermined reasons, and was forced to make an emergency landing. Prior to touchdown the helicopter experienced a loss of directional control, due to a failed hydraulic pump, and collided with the…NTSB ATL86LA189Accident · No injuriesLimited investigationFinal reportCessna 172 · Kirkland, OHPilot had flown from wisconson to cape cod on Wednesday and was returning to Wisconsin on Sunday. He had departed provincetown on Sunday morning and stopped at hyannis due to weather. He then flew on to saratoga springs, NY with a stop at westover, arriving…NTSB MIA86LA201Accident · Minor injuriesLimited investigationFinal reportBeech 36 · Marco Island, FLDuring landing apch, the plt stated that he switched from the left fuel tank to the right tank & shortly thereafter, the eng failed. He was unable to restart the eng and a forced ldg was made. An exam of the left tank revealed it to be empty while the right…NTSB CHI86FER12Accident · Minor injuriesFinal reportPiper PA-25-235 · New Richland, MNThe aircraft performed a forced landing which resulted in substantial damage. Water was found in the fuel system. Water was also found in the underground fuel supply used to refuel the crop duster.NTSB ANC86LA102Accident · No injuriesLimited investigationFinal reportCessna 152 · Nenana, AKThe student plt stated that he ran out of fuel on a solo x-country flt after becoming disoriented. A forced landing was made during which the acft nosed over.NTSB SEA86FA155Accident · 2 fatalField investigationFinal reportAeronca 7AC · Mulino, ORThe pvt plt had been giving rides around the local area for about an hour. He had just dropped off one passenger and picked up another. The acft taxied from the ramp to the rwy 30 and made a normal takeoff. During crosswind turn the engine started to miss and…NTSB CHI86LA166Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Fraser, MIAircraft nosed over during an attempted downwind dead stick landing on an airport after running out of fuel. The aircraft landed at midfield and was unable to stop before running off of the end of the runway.NTSB ATL86LA193Accident · No injuriesLimited investigationFinal reportCessna 177A · Huntsville, ALThe acft had set on the ramp with little fuel in it for aprx one week. Just before the accident flt, the pilot took fuel samples, but found no water. He then taxied to the fuel pumps and added aprx 20 gal of fuel in each tank. Another fuel sample was not…NTSB ANC86LA100Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Sparrovahn, AKThe plt reported a total loss of pwr occurred while maneuvering over an area to observe the terrain. A forced landing was made on a gravel bar during which the acft nosed over. In his recommendation on how the accident could have been prevented, the plt…NTSB DEN86LA182Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Williston, NDDuring the telephone interview, the plt stated the eng of his crop duster quit due to fuel exhaustion and a forced landing was made.NTSB NYC86LA165Accident · No injuriesLimited investigationFinal reportCessna 150E · Hammondsport, NYWhile on final apch over high terrain east of the arpt, the plt inadvertently pulled the mixture control when he intended to apply carburetor heat. The eng stopped running & the plt was unable to obtain a restart before the acft collided with trees. The acft…NTSB NYC86LA160Accident · No injuriesLimited investigationFinal reportHiller 12C · Lehighton, PAThe pilot of the Hiller 12C reported an overheated engine followed by an engine failure. During the forced landing the main rotor flexed and cut the tail boom off the the aircraft. The aircraft was examined. 10 oz. Of a liquid was found in the fuel system. 7…NTSB DEN86LA179Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Lupton, COThe plt took off on a local flt with approximately 1/4 tank of fuel (6 gal). He flew the acft until the engine quit from fuel exhaustion at 1.2 hours flt time. The acft impacted in an open feild, nosed over, and came to rest in an inverted position. The plt…NTSB ATL86LA183Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Memphis, TNWhile returning from an instrument training flight, the aircraft lost total power and the CFI attempted an emergency landing on a road. During the attempted landing the aircraft collided with a road sign and was substantially damaged. The pilot related that…NTSB MKC86LA133Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Wathena, KSThe plt stated that according to the acft manual, he had enough fuel to fly to his destination in the usa. As such, he felt that no refueling was necessary when he landed at his designated airport-of-entry to clear customs. The acft ran out of fuel two miles…NTSB ATL86FA182Accident · Minor injuriesField investigationFinal reportCessna P210N · Lawrenceville, GAThe acft was damaged during a forced lndg on a hiway after the engine quit. The flt was nearing its destination on a VFR x-country when the engine lost power. The acft fuel tank selector was on the rt tank for 2 hrs before and during the emergency. After the…NTSB BFO86FIA01Accident · Minor injuriesFinal reportGrumman AA1B · Brandywine, MDPrior to reaching the lom during an ILS rwy 01L apch, a loss of pwr was experienced. The plt applied carb heat and pwr was momentarily restored. A total pwr loss was then experienced and the plt executed a forced landing in a field during which the acft nosed…NTSB LAX86LA266Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Planada, CAThe plt reported the eng coughed during cruise flt at an alt of 2000 ft AGL. He applied carburetor heat and the eng coughed again and lost power. The plt made a forced landing in a plowed field. The landing gear dug into the terrain and the acft nosed over.…NTSB DEN86LA173Accident · No injuriesLimited investigationFinal reportBeech K35 · Kim, COThe plt reports that he was cruising at 9,500 ft MSL when he encountered low broken clouds. He decided to descend below the clouds to assure remaining VFR. The plt said he retarded the throttle and descended to 7,000 ft MSL (1,000 ft AGL). When the throttle…NTSB DEN86LA171Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Cope, COThe plt reports that the eng quit during a pull-up at the end of a swath run. A forced landing in a field straight ahead was attempted but the field had been cultivated recently and was soft. After a short ground roll the gear dug in and the acft nosed over.…NTSB ANC86FA085Accident · No injuriesField investigationFinal reportPiper L-4H · Anchorage, AKThe pilot/mechanic stated the engine oil pressure gauge began flickering, so he elected to land and during the descent the engine failed. He landed downwind in 20 knot winds and during the landing roll, across tundra/mud the airplane's wheels struck a large…NTSB NYC86LA171Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Barkhanstead, CTThe flight took off with about seven gallons of fuel with a slight tailwind. But after about 30 minutes of flight the flight encountered a headwind. The aircraft suffered fuel exhaustion and the pilot executed a precautionary landing in a field. During ground…NTSB DEN86LA167Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · South Heart, NDAccording to the plt, during a swath run (agricultural spraying), the eng quit & a forced landing was accomplished. During the interview, the plt stated the eng quit due to fuel exhaustion.NTSB MKC86LA129Accident · No injuriesLimited investigationFinal reportCessna 152II · Jonesboro, ARThe pilot stated that he was level at 3,000 feet, and had the airport in sight when he experienced a fluctuation in engine RPM. The pilot further stated that he continued the flight but that the engine quit when the aircraft was over the airport. The p.I.c.…NTSB MIA86FA185Accident · 1 fatalField investigationFinal reportAyres S2R-1820 · Dundee, MSThe ag acft was flying low over a water covered muddy rice field when the eng stopped running. The plt then jettisoned the load of fertilizer & entered a steep right turn. Subsequently, the aircraft struck the ground on the right wing & nose, then…NTSB FTW86LA114Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Weatherford, TXThe plt experienced a power loss at approximately 200 feet during the takeoff climb portion of the flight. On descent the aircraft collided with a tree before coming to rest in a field. During pre-flight the pilot noted the fuel tanks were half full and there…NTSB BFO86FA037Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Edgewater, MDWitnesses indicated that the engine sounded normal during takeoff run but started to lose power shortly after liftoff. The aircraft departed on runway 30 at lee airport, annapolis, MD. The runway is 2400 feet long and beards creek is located about 200 feet…NTSB LAX86LA254Accident · No injuriesLimited investigationFinal reportNorth American Navion A · San Jose, CAThe acft's engine failed aprx 10 minutes after takeoff. The acft collided with a utility pole during the forced landing that followed. Post accident inpsection of the acft revealed the fuel selector was positioned on the aux tank. The main fuel tanks were…NTSB ATL86LA173Accident · No injuriesLimited investigationFinal reportPitts S-15 · Raleigh, NCDuring normal cruise VFR flight at 1,500 ft AGL, the pilot reported hearing an erratic hissing sound and the acft began losing fuel pressure. The aircraft lost power and a forced landing was made into a field. The right main landing gear dropped into a hole…NTSB ATL86LA171Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · Apex, NCThis was the first flight for the passenger. After about one and one-half hours en route the weather ahead deteriorated and the pilot turned to return to the departure point. Weather prevented a landing there so he turned to another airport. It too was in an…