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 FTW87LA094Accident · Serious injuriesLimited investigationFinal reportPiper PA-25 · Jackson, LAEngine failed due to fuel exhaustion. Aircraft collided with trees short of rwy 33.NTSB SEA87LA079Accident · No injuriesLimited investigationFinal reportHughes 369HS · Yakima, WASix miles from the airport, at cruise, the engine ceased operating due to fuel exhaustion. The plt had noticed the low fuel warning light on 10 minutes prior to the engine failure but elected to continue his flight. Autorotation was made from 1,000 feet AGL…NTSB DEN87LA088Accident · No injuriesLimited investigationFinal reportCessna 152 · Milford, UTN67880 experienced VOR receiver failure during a flt from ogden, UT to st. george, UT. The plt diverted to Milford, UT and another plt checked the receiver which functioned on the ground. The flt then departed Milford en route to st. george. Shortly after…NTSB CHI87LA108Accident · No injuriesLimited investigationFinal reportCessna 150H · Tinley Park, ILApproximately 3 miles short of the destination arpt the plt stated that the engine quit. The acft was lined up with a road but due to heavy traffic the plt elected to stall the acft into nearby trees. Examination of the acft by the FAA following the accident…NTSB CHI87DER03Accident · No injuriesFinal reportHiller UH-12ET · Big Lake, MNAircraft was being maneuvered for landing on a ground support trailer when it experienced a power failure. Due to high trees autorotation was made to adjacent field. Aircraft landed on rough/uneven terrain and rolled over. Investigation revealed contaminated…NTSB ANC87MA057Accident · 2 fatalMajor investigationFinal reportCessna 402 · Anchorage, AKThe acft was on the last leg of a scheduled commuter flight, when it crashed in a heavily wooded area while making a VFR approach to merrill field, Anchorage, AK. The capt and his sole passenger were killed in the crash when the airplane struck the ground…NTSB MKC87LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Tribune, KSThe pilot stated that he was spotting stray cattle after a snow blizzard moved through the region. Two hours into the flight, the pilot further stated, he reduced engine power for approximately 10 seconds--without carburetor heat. The engine then sputtered…NTSB LAX87DVM02Accident · Serious injuriesFinal reportBowers Flybaby 1A · San Luis Obispo, CADuring a pleasure flt in an experimental acft, during the takeoff roll, the eng sputtered, however, the plt continued the flt. After takeoff at aprx 30 ft the eng sputtered again. The plt made a sharp 45 deg turn which put him on downwind, however, the acft…NTSB FTW87FA087Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Leakey, TXFlight instructor and student pilot flying Piper PA-28-140 departed uncontrolled airport after switching fuel tanks on runway. Fuel selector valve was inadvertently moved to off position by student pilot. Aircraft engine quit on initial climb at approximately…NTSB ANC87LA056Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Nikolai, AKThe student pilot stated that he was on a solo cross country flight when he reported that he was lost and low on fuel. He attempted an emergency landing but crashed 200 feet short of the runway. The flight instructor stated that the aircraft was out of fuel…NTSB LAX87LA163Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · San Luis Obispo, CAAfter take-off, the pilot was flying a downwind departure when the engine quit. The pilot was unable to return to the runway and collided with the terrain a half mile from the airport. Inspection of the engine at the time of the accident found that the main…NTSB FTW87DPJ05Accident · Serious injuriesFinal reportde Havilland DHC-1B-2S5 · Claremore, OKMud daubers plugged the fuel tank vents resulting in fuel starvation and engine failure. The acft received substantial damage during the forced lndg and the plt was seriously injured.NTSB MIA87LA119Accident · Serious injuriesLimited investigationFinal reportPiper PA-24 · Gainesville, FLThe non instument rated private pilot filed an instrument flight plan for a 5 hour flight. The flight lasted 5 hours and 26 minutes when the pilot radioed controllers that he had run out of fuel and the engine failed. The aircraft crashed at the destination…NTSB CHI87LA103Accident · No injuriesLimited investigationFinal reportCessna 172M · Shelbyville, INThe plt's original destn was lexington, KY, however between bluefield, KY and lexington, he amended his destn to indianapolis, IN. The plt stated that fuel consumption was calculated as 7.1 gph, but he did not take into consideration the Cessna 172 time/fuel…NTSB ATL87LA098Accident · No injuriesLimited investigationFinal reportMooney M20F · Winnsboro, SCThe acft hit a ditch during a forced landing after a power loss on takeoff. The acft had received annual inspection during which no contamination of the fuel system was found. The acft was parked outside, in the rain, to await the owner's pickup. The fuel…NTSB MIA87FA118Accident · 1 fatalField investigationFinal reportAero Mirage TC-2 · Williston, FLWitnesses stated that the acft made a 'fly by' at 300 ft to check and see if the gear was down. The ground personnel informed the plt that the gear appeared to be down. They stated that the acft then made a sharp left turn paralleling runway 14, they lost…NTSB ATL87LA090Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-D · Cottondale, ALThe plt performed a touch-and-go after takeoff. During the takeoff phase of the touch-and-go, the acft eng quit. The acft was force landed in tree. Post accident inspection failed to reveal any failure/malfunction.NTSB MKC87LA063Accident · No injuriesLimited investigationFinal reportGlasair SH2 · Springdale, ARImmediately after takeoff, the engine stopped and the acft collided with trees and then the terrain. Inspection revealed contamination in the fuel tank, the lines and the filter. Contamination was water, dirt, straw and gravel. The fuel being used was regular…NTSB MIA87FA114Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Miami, FLThe recently rated private pilot took three passengers for an airplane ride in his airplane that was over gross weight upon departure. During the flight he was performing low level dives at trees with rapid pull ups. During the last pull up the aircraft went…NTSB SEA87LA066Accident · No injuriesLimited investigationFinal reportCessna 172 · Lopez Island, WADuring cruise the acft engine quit due to fuel exhaustion. The pilot neglected to visually check the fuel tanks prior to departure, but rather relied on fuel gauges and his own estimation that enough fuel would be remaining to complete the flight. During…NTSB LAX87LA150Accident · No injuriesLimited investigationFinal reportCessna P210N · Elk Grove, CADuring a local flight to check repairs to the aircraft cabin pressurization, the aircraft had descended from 8500 ft MSL to 2000 ft MSL when the engine began cutting out. Unable to maintain altitude to return to the airport, the pilot landed the aircraft in a…NTSB ATL87LA086Accident · No injuriesLimited investigationFinal reportCessna 210L · Jeffersontown, KYDuring IFR flight in VFR conditions the pilot reported low fuel situation to approach control. The aircraft was in the vicinity of several lighted airports at that time. The aircraft lost power and made forced landing at night in mountainous terrain where an…NTSB MIA87LA107Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Meridian, MSThe pilot did not assure the fuel level in the aircraft fuel tanks prior to departure. During the flight the pilot canceled a planned fuel stop and continued to his destination. The engine failed due to fuel exhaustion 2 1/2 miles short of the destination and…NTSB LAX87LA145Accident · No injuriesLimited investigationFinal reportCessna U206A · Williams, AZDuring a crosswind turn, shortly after takeoff, the pilot noticed that the fuel pressure gauge was registering a loss of fuel pressure and the engine was experiencing a smooth loss of power. The pilot said that he turned on the emergency boost pump and…NTSB FTW87LA081Accident · No injuriesLimited investigationFinal reportCessna 185A · Midland, TXDuring take off, the aircrafts engine failed due to fuel exhaustion. The pilot made an emergency forced landing in a rough uneven field, causing substantial damage to the left wing spar, left main gear, and left elevator. The pilot did not hold a…NTSB MKC87LA061Accident · No injuriesLimited investigationFinal reportCessna 182J · Archie, MOThe plt stated that, after refueling with auto gas at the pvt airstrip, water was found in the fuel being drained fm the sumps. After rocking the acft several times and noting no further water accumulation in the fuel samples, the plt further stated, a…NTSB SEA87LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Coburg, ORThe student pilot was in the process of flying his long cross country flight in order to qualify for his private pilots certificate. Prior to reaching the home airport, the students instructor talked to him from the ground and advised the student not to land,…NTSB MIA87LA101Accident · No injuriesLimited investigationFinal reportBeech C24R · Milton, FLThe acft crashed in a river aprx 1 mile west of his alternate landing location after the eng quit while descending for an apch, due to fuel exhaustion.NTSB CHI87LA094Accident · No injuriesLimited investigationFinal reportAmerican AA5 · Flint, MIDuring a forced landing on an interstate highway about two miles from bishop airport, the aircraft collided with a signpost and a concrete bridge. The pilot had reported that he was out of fuel when he was about nine miles away from the airport. The pilot…NTSB CHI87LA093Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Genoa, ILThe aircraft experienced a loss of power on takeoff, for undetermined reasons, and was forced to make an emergency landing. On impact the nose gear and main landing gear sheared off.NTSB CHI87LA091Accident · Minor injuriesLimited investigationFinal reportBeech BE 36 · Alma, MIAccording to the plt, during the preflight inspection, he determined that both gas tanks were full and 'everything was in order.' After aprx one hour of local flight, the plt entered a left downwind for rwy 27 at gratiot community airport, Alma, Michigan. The…NTSB MKC87LA055Accident · No injuriesLimited investigationFinal reportCessna 150 · Newton, KSThe stu was practicing simulated engine failures at his cfi's direction. As the stu simulated corrective action in the cockpit to restore pwr, he inadvertently turned the fuel selector off, and did not tell the CFI. Normally the CFI terminated the simulated…NTSB ANC87LA044Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Nenana, AKThe pilot lost control on takeoff, stalled and crashed on a frozen lake. During the interview with the pilot, he stated that the engine quit on initial climbout; he believed he did not pre-heat the engine long enough before takeoff. At the time of the…NTSB ATL87LA078Accident · Serious injuriesLimited investigationFinal reportBeech 23 · Augusta, GAThe acft was flown from a pvt strip to a nrby arpt at statesboro, GA for refueling. After the acft was refueled, the englost pwr as the student plt was taxiing to takeoff. Water was fnd in the sumps, & rprtdly, 4 to 6 samples were required to drain water from…NTSB CHI87LA088Accident · No injuriesLimited investigationFinal reportBeech C-35 · Lake Station, INThe aircraft struck a guard rail during an emergency landing on interstate 80 after experiencing fuel exhaustion. The pilot had visually inspected his fuel supply prior to the first leg of the flight and thought there was enough fuel for the trip. Inspection…NTSB MIA87LA087Accident · No injuriesLimited investigationFinal reportCessna 172 M · San Juan, PRThe instructor plt stated that the flt was over San Juan bay aprx 2.5-3 miles from the arpt at aprx 700 feet when the eng began to run rough. The eng then quit. However it restarted momentarily. Realizing the flt would not reach the arpt the acft was then…NTSB ATL87DEG03Accident · 2 fatalFinal reportRichard A. Brown Falco F-8L · Mc Arthur, OHPIC and acft owner landed at a/p and req fuel which was not avail. Acft left to fly to another a/p. during initial climb engine quit at 300-400 feet. PIC turned back toward rwy, acft stalled, impacted ground in 90 degree left wing low attitude. Other pilots…NTSB CHI87LA082Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Oshkosh, WIAccording to the plt, at aprx 1800 feet 'the engine abruptly quit with no runon or sputter' following takeoff from rwy 18 at Oshkosh, WI. The plt stated that he banked the acft back to the airport, but the aileron controls became jammed or 'frozen'. According…NTSB MKC87LA049Accident · No injuriesLimited investigationFinal reportMooney M20E · St.Louis, MOThe PIC was clrd by twr to lnd rwy 30L. The twr advzd the PIC that his gear was not extended. The PIC rspnd with 'I know that and I have lost eng pwr too'. The acft subsequently impacted short of the rwy. FAA maint insp of the acft revealed no fuel in the…NTSB LAX87LA110Accident · 2 fatalLimited investigationFinal reportCessna 150L · Ayase, JapanDuring an instructional flight, just after take-off the instructor was heard to transmit over the radio 'request emergency landing.' At an altitude of approximately 15O feet AGL the aircraft was observed to pitch up then nosed down in a shallow left turn. The…NTSB FTW87LA060Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Waxahachie, TXThe aircraft received substantial damage during an emergency landing. According to the pilot, the engine failed because of carburetor icing. Atmospheric conditions at the time of the accident were conducive to carburetor icing. No mechanical failure or…NTSB FTW87DRD03Accident · Serious injuriesFinal reportSikorsky S-55C · Kurthwood, LAThe engine surged and subsequently lost power during low altitude cruise flight above a dense forest. The pilot autorotated into the trees and then fell through onto the ground. Post accident examination revealed water contamination in the fuel system.NTSB SEA87LA050Accident · Minor injuriesLimited investigationFinal reportBeech B23 · Alderwood Manor, WAThe pilot, after exhausting all fuel in one tank, failed to select the remaining fuel tank during his approach. His unfamiliarity with the make/model of the accident aircraft is considered a factor in his failing to locate the fuel selector and switching to…NTSB FTW87LA050Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Terrel, TXThe pilot attempted a go-around due to cross winds and experienced an engine failure due to fuel starvation when the mixture control vibrated out to the shutoff position. The pilot attempted several times to restart the engine, but was unsuccessful prior to…NTSB SEA87LA049Accident · No injuriesLimited investigationFinal reportCessna 402B · Las Vegas, NVPlt filed IFR, 2+40 ete. Due delay, plt departed VFR and opened VFR flt plan. Enroute, stong hdwinds encountered. Also, clouds required altitude and course deviations to maintain VFR. Ate was 3+33. On final, left eng lost pwr, rt eng began surging. Into 20-KT…NTSB FTW87LA049Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Medford, OKThe acft experienced a double eng failure as a result of fuel exhaustion during descent to the destination aprt. The plt attempted to divert to a nearby arpt during the descent, but both engs quit before he had the rwy assured. The subsequent attempted forced…NTSB DEN87LA047Accident · Minor injuriesLimited investigationFinal reportCessna 182L · La Junta, COThe engine quit during cruise flt at 8,500 feet MSL. During the emergency landing to unsuitable terrain, the acft nosed over. The plt had flown 5 hours on this flt. The long range fuel tanks had been installed with the filler ports inboard, limiting the total…NTSB ANC87LA027Accident · No injuriesLimited investigationFinal reportCessna 185D · North Pole, AKThe pilot stated that during the right downwind approach to the airstrip the aircraft ran out of fuel; the engine quit and then he attempted an emergency landing. The plt attempted to land on the rwy. Inspection revealed no fuel in the acft and the fuel…NTSB LAX87LA097Accident · No injuriesLimited investigationFinal reportCessna 152 · Glendora, CADuring a local pleasure flight, the engine lost power and the pilot made a forced landing on a golf course. Visual inspection of the fuel tanks revealed that both tanks were empty and no fuel drained from the sumps. No mechanical failure or malfunction with…NTSB NYC87LA067Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Boyertown, PAStudent pilot on a solo cross-country flight experienced fuel exhaustion, landed in a field and collided with a stonewall. The aircraft was substantially damaged and the pilot received minor injuries.