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 MIA86FA034Accident · 1 fatalField investigationFinal reportMooney M20J · Sarasota, FLWitnesses reported that shortly after takeoff from a touch and go landing the aircrafts engine sputtered and quit completely. As the pilot was attempting a forced landing the aircraft struck a tree causing the pilot to lose control. The aircraft struck the…NTSB ATL86LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Huntsville, ALDuring a cross country flight, the pilot elected not to refuel at his proposed refueling point and continued to another airport. While on a visual approach to the runway, the aircraft lost power due to fuel exhaustion.NTSB CHI86FEM02Accident · Minor injuriesFinal reportPiper PA-25-235 · Holland, MIThe acft crashed during a forced lndg after a loss of power during initial climb. After the accident the plt said that he drained fuel from the main fuel strainer and found no water in the fuel prior to takeoff. The acft carburetor was disassembled after the…NTSB LAX86LA044Accident · No injuriesLimited investigationFinal reportCessna 177 · Stockton, CAAfter performing a preflight inspection of his acft, the PIC along with a CFI who was acting as his safety plt, and another passenger departed. The CFI reportedly had logged over 19,000 hours & possessed an ATP certificate. The PIC did not report having any…NTSB CHI86FA031Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Washington Twp., INThe pilot and pax were returning from a xcountry flt. While on a long final approach the acft was witnessed to stall and fall off on the left wg. The acft then descended into a wooded area causing left wg separation and then impacted a creek bank. At the time…NTSB LAX86LA040Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · San Jose, CAWhile on final apch for San Jose muni airport at the end of a cross country flt, the acft experienced total fuel exhaustion. Plt diverted a/c to ried hillview airport & established power-off glide. On final for rwy 31R, plt said he realized the a/c would not…NTSB LAX86FA039Accident · 1 fatalField investigationFinal reportCessna 182P · Cottonwood, AZWitnesses saw the plt depart with frost covering the acft & without either a runup or warmup. The witnesses reported that the plt 'scraped the frost from a small square directly in front of him on the windshield' just prior to takeoff. Temp & dew point were…NTSB SEA86LA022Accident · No injuriesLimited investigationFinal reportCessna T210N · Overton, NVSeveral diversions had been made due to encountering airframe icing. Once the pilot realized that a low fuel condition existed he asked for vectors to the nearest airport. The pilot had to make a forced landing due to fuel exhaustion 1 mile short of the…NTSB ATL86LA023Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Paducah, KYAfter being cleared for descent to 4,000 ft and to the localizer the acft lost two way communications. The plt stated that he lost his HSI and radio's. however, he was able to fly in the area around the VORTAC for almost an hour before he descended through a…NTSB ATL86LA022Accident · No injuriesLimited investigationFinal reportCessna 172F · Hazelhurst, MSDuring cruise flight the engine experienced a loss of power and the pilot applied carb heat. The engine operated normally with the carb heat on and when it was turned off the engine again ran rough. The pilot again turned on the carb heat and the engine ran…NTSB ATL86LA021Accident · No injuriesLimited investigationFinal reportCessna 150J · Cumming, GAShortly after takeoff the acft experienced a loss of pwr as related by the student plt. A forced landing was performed in a fld during which the nose wheel dug into the terrain and the acft nosed over. Examination of the wreckage failed to disclose any…NTSB MIA86LA026Accident · No injuriesLimited investigationFinal reportCessna 310G · Fort Pierce, FLThe ac departed on a ferry flight with the landing gear clamped in the down position and leaking fuel system from a previous accident. The flight was uneventful until arrival at the destin ation airport. The left engine failed on the downwind leg of the…NTSB SEA86LA021Accident · No injuriesLimited investigationFinal reportCessna 180D · Wrangell, AKA forced landing was made onto muskeg due to a total loss of power. The pilot had just completed a 180 degree turn away from a fog bank when the engine quit. The left fuel tank contained 7 1/2 gallons and the right fuel tank contained 1 1/2 quarts of fuel.…NTSB FTW86FRG06Accident · Minor injuriesFinal reportHughes 269C · Batesville, TXThe helicopter was substantially damaged during a forced landing following a loss of eng pwr. The plt was performing cattle ranching operations when the eng sputtered and quit while at a low alt. The plt was able to clear trees and high brush, however, a hard…NTSB DEN86LA018Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Ranchos De Taos, NMThe plt stated that during takeoff, after a touch and go, the eng quit due to fuel exhaustion. The acft nosed over during a forced landing in a sage brush covered fld 3/4 of a mile north of the rwy. According to the plt, he failed to switch the fuel tanks…NTSB ATL86LA017Accident · No injuriesLimited investigationFinal reportCessna 172 M · Moncks Corner, SCThe plt reported that the acft engine experienced a loss of power while being vectored for the initial ILS approach to charleston, SC (chs). Attempts by the plt to regain pwr failed and a forced landing was made in a swampy field a few miles north of chs. The…NTSB ANC86FA007Accident · 2 fatalField investigationFinal reportCessna 208 · Bethel, AKA total loss of pwr was experienced on takeoff due to the fuel selectors being in the off position. The plt attempted to restart the eng during which time the acft entered a stall and collided with the terrain. According to passengers the plt did not use a…NTSB LAX86LA030Accident · No injuriesLimited investigationFinal reportCessna 150H · San Andreas, CAThe acft nosed over during a forced landing in a fld aprx 2 miles west of calaveras county arpt. The post-accident wreckage examination disclosed no evidence of fuel in the fuel tanks. The student plt stated that he was on the final leg of a solo x-country…NTSB CHI86LA113Accident · No injuriesLimited investigationFinal reportCessna 152 · Greenville, MIThe plt experienced engine failure due to fuel starvation ten miles north of his destination. During the forced landing the prop and left wing were substantially damaged. The plt stated that when he ran out of fuel the right fuel guage read between 1/4 and…NTSB DEN86LA015Accident · No injuriesLimited investigationFinal reportCessna T210NII · Sterling, COThe plt indicated he had the arpt in site when the eng failed due to fuel exhaustion. The investigation revea led the eng tach showed a total lapsed time of 4.9 hrs flown on this one fuel load. The perfomance charts for this particular flt indicates a max flt…NTSB ATL86LA012Accident · No injuriesLimited investigationFinal reportCessna 152 · Parkersburg, WVThe acft experienced a total loss of power due to fuel exhaustion while on a baseleg for landing. The pilot elected to land in a corn field approx 1.5 miles short of the runway because he did not think he could make it to the runway. The plt was returning…NTSB MIA86LA020Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Fort Walton Bch, FLThe acft collided with power lines & crashed to the ground during a forced landing necessitated by an eng failure. The x-country flt had been in the air for 4 hrs and 35 mins. The acft's fuel capacity is 40 gals & the plt stated that fuel consumption was aprx…NTSB CHI86FA017Accident · 1 fatalField investigationFinal reportBell 47G-5 · Plainfield, WIThe acft crashed into trees and nosed into the wooded terrain after a loss of powr. The helicopter had been refueled the day before the acc. Normal fuel load was 20 gals. The plt had sprayed 20 acres & flown 9 miles to another field to spray but aborted due…NTSB NYC86LA021Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Freeport, PAThe stu plt departed with 10.5 gals of fuel for a 48 mile x-country flt. While en route the plt became lost. Aprx 10 minutes of fuel remained when the plt spotted a arpt. She attempted to land at the arpt. During the apch to the rwy she made a go around when…NTSB ANC86LAG04Accident · No injuriesFinal reportCessna 177 · Soldotna, AKThe plt stated that during the preflight inspection the right wing tank quick drain was frozen and the fuel strainer was not working correctly. After consulting with a mechanic, a takeoff was performed and the eng quit during initial climb. The acft contacted…NTSB LAX86LA018Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Turlock, CAThe acft made a forced lndg after a loss of power during a descent. The plt stated that the eng RPM decreased to 1100 with all other gauges in the green. He also said he could not get the fuel drain sumpt to drain as it was frozen shut during preflt. The plt…NTSB FTW86LA017Accident · Minor injuriesLimited investigationFinal reportCessna 310 · Tulsa, OKThe plt experienced fuel exhaustion while on final apch for landing on rwy 35L at Tulsa international arpt, OK. The acft undershot the rwy by 1/2 to 3/4 of a mile where it contacted railroad tracks.NTSB FTW86FRA01Accident · Minor injuriesFinal reportCessna 172 M · Houston, TXThe acft made a forced landing on a golf course and nosed over after the engine quit during takeoff. Post accident investigation revealed that the gascolator was full of water and the carburetor contained 25 percent water. No other discrepancies in equipment…NTSB ANC86LA004Accident · No injuriesLimited investigationFinal reportCessna 206 · Tanana, AKWhile en route, the eng lost power, so the plt made an emergency landing on a gravel bar. During the landing, the acft nosed over & came to rest in water. An exam revealed that the fuel sumps & lines were frozen & there was ice in the fuel pump.NTSB FTW86LA012Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Killeen, TXThe pilot stopped enroute to refuel. Fuel service at the airport and already closed for the night so the pilot drained about 10 gallons of fuel into his airplane from a parked Cessna airplane and departed for his destination. However, this amount of fuel was…NTSB SEA86LA008Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Panaca, NVA forced landing onto rough terrain was made due to fuel exhaustion.NTSB MIA86LA011Accident · No injuriesLimited investigationFinal reportBeech 65A-80 · Ochopee, FLWhile on a night pleasure flt, both engs surged and lost pwr and an emergency landing was made. The plt stated that he had a total of 3 hrs flt time in this type of acft. He later recanted his statement & stated that he had never flown this type acft before.…NTSB ATL86LLT01Accident · No injuriesFinal reportCessna 150 · Livingston, TNThe plt made a forced landing in rugged tree covered terrain following a loss of pwr due to fuel exhaustion while on a x-country flt. The plt decame lost near Livingston, TN, and contacted the crossville and london fss for assistance. The acft was located 5…NTSB NYC86LA004Accident · No injuriesLimited investigationFinal reportCessna 140 · Newport, NHAcft collided with trees while executing a go-around. The acft lost power, the plt lowered the nose in an attempt to restart the eng while turning right in an effort to return to the rwy. The acft stalled and collided with trees.NTSB CHI86FA006Accident · No injuriesField investigationFinal reportCessna P210N · Grayslake, ILDuring descent the engine stopped running. The aircraft was landed in a soft field & nosed over. Only 4 gallons of fuel was found in the left fuel system with no evidence of leakage. The pilot only used the left system during the 2 hour flight. Fuel tanks…NTSB SEA86LA005Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Medford, ORThe acft collided with rocky terrain during an attempted forced landing following a loss of pwr. A witness reported seeing the acft in a steep descending left turn at an alt of aprx 100 ft AGL. The descent continued until the left wing contacted the terrain.…NTSB MKC86LA004Accident · No injuriesLimited investigationFinal reportQuickie Q2 · Willard, MOClimbing to cruise the plt rptd a loss of eng pwr an turned to head back to the airport of departure, the ensuing forced landing substantially damaged the acft. Inspection into the eng failure revealed a contaminated inline fuel filter restricting fuel flow…NTSB ATL86FKG01Accident · Serious injuriesFinal reportPiper PA-32-300 · Perry, GAThe acft landed short of the rwy during a forced landing following loss of pwr during a x-country flt of 2 hrs. 3 witnesses saw the acft bring refueled but the only one who mentioned the amount of fuel added was the refueler who said he'topped off' all 4…NTSB CHI86FEM01Accident · Minor injuriesFinal reportLeone Sonerai II · Traverse City, MIThe acft contacted a tree and impacted the terrain in a nose down attitude during a forced landing following a loss of pwr which resulted from fuel exhaustion.NTSB FTW86LA002Accident · No injuriesLimited investigationFinal reportCessna 152 · Lake Charles, LAThe acft experienced eng failure as a result of fuel exhaustion and the plt made a forced landing in a lake near the departure arpt while towing a banner. FAA stated the plt did not obtain a waiver to tow the banner.NTSB LAX86LA001Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Van Nuys, CAThe plt stated that after takeoff he climbed to 1800 ft MSL (aprx 1000 ft above ground level) and entered a left turn. The eng failed in the turn an he selected a dry flood control basin on which to land. The acft's airspeed was slow on landing and the…NTSB DEN86LA001Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Cortez, COAfter 3.9 hrs flt time on a x-country flt from cheyenne, WY, to Cortez, CO, the plt experienced an eng failure due to fuel exahustion. He executed a forced landing in a mountain meadow that was not adequate in length for the landing. The acft impacted trees…NTSB MKC85LA224Accident · Minor injuriesLimited investigationFinal reportBellanca Citabria 7ECA · Council Bluffs, IAOn climbout fm the Council Bluffs airport the plt reported a loss of engine power and the engine quitting. The plt attempted an air restart but was too low to the grnd to continue. The plt weaved in and out of trees during his descent finally impacting the…NTSB FTW85LA359Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-R · Mount Vernon, TXThe pilot reported he ran out of gas maneuvering under an overcast to find a suitable landing site. He had attempted to circumnavigate a large area of severe weather but exhausted his fuel supply. He stated that the engine quit and he stalled the aircraft at…NTSB ATL85MA286Accident · 17 fatalMajor investigationFinal reportCessna 208 · Jenkinsburg, GAAs the plt & 16 jumpers deptd on a skydiving flt, the eng lost pwr at aprx 300' AGL. The acft then banked steeply left, spiraled in a steep nose dwn attitude & crashed. An exam revealed fuel in the tanks was contaminated with wtr & foreign material with the…NTSB FTW85LA361Accident · No injuriesLimited investigationFinal reportCessna 182G · Maypearl, TXPlt stated that shortly after takeoff, the engine failed completely without warning. He set up for and executed a forced landing in a field. During the flare, one wing tip struck the top of a tree and during the landing roll the acft crossed several terraces,…NTSB DEN85LA249Accident · Serious injuriesLimited investigationFinal reportCessna TU206G · Evanston, WYThe plt said the eng quit as he was turning from base leg to final apch for rwy 24 at Evanston (WY) arpt. The acft crashed as the plt maneuvered for an emerg landing. Disassembly and examination of the eng disclosed no reason on why the engine failed. The…NTSB ATL85FLQ01Accident · Minor injuriesFinal reportPiper PA-28-181 · Bowling Green, KYThe acft was substantially damaged during a forced landing in a corn field following a loss of pwr 5 miles from the destination arpt. The plt reported to Bowling Green fss that he was 'out of gas' at an alt of 3000 ft. post accident examination disclosed a…NTSB SEA85LA227Accident · No injuriesLimited investigationFinal reportBeech J35 · Ontario, ORThe plt was flying the acft at a low alt for the purpose of spotting game. The eng ceased operating shortly after switching fuel tanks. The plt stated during a telephone interview that he inadvertently switched the fuel selector to the off position. The acft…NTSB NYC85LA248Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Hamburg, NYThe plt stated that he started a maneuver at 2700 ft. the maneuver was a dive after reducing pwr followed by a climb with a left turn at the top followed by a descending left turn. The turn 'at the top' was uncoordinated and g forces occurred. Throttle…