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 FTW88DPJ01Accident · Serious injuriesFinal reportWard Cassutt 3M · Yukon, OKDuring initial climb the engine failed and the pilot was unable to get a restart. The pilot, who was also the builder of the aircraft, was aware that in certain attitudes the engine would fail due to fuel starvation and that by changing the aircraft attitude…NTSB NYC88LA002Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Newport, VTShortly after takeoff, the eng lost power as the acft was climbing thru about 75' AGL. Subsequently, the acft was damaged during an emerg landing. An exam revealed the acft had a very loosely fitting fuel cap & water was found in the fuel lines & sumps. The…NTSB ATL88LA004Accident · No injuriesLimited investigationFinal reportCessna 150L · Cordesville, SCThe airplane nosed over during a forced ldg on soft terrain, after experiencing a loss of engine power during descent from cruise. The plt reported that the acft ran out of fuel. He had made an unplanned stop earlier to take on additional fuel, after…NTSB MIA88LA004Accident · No injuriesLimited investigationFinal reportCessna 180 · Church Hill, MSWhile in cruise flight at 1,000 ft, the eng lost power. The plt performed a forced landing in a soft field and during the landing roll, the acft hit a dirt bank, nosed over, and came to rest inverted. Post crash examination of the fuel system revealed that…NTSB ATL88LA002Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Grand Bay, ALThe engine lost pwr shortly after t/o. the engine regained pwr as the plt was about to make a forced ldg in a field. He aborted the ldg attempt and attempted to make it back to the airstrip. The engine subsequently lost pwr again. The plt stretched his glide…NTSB ANC88LA003Accident · No injuriesLimited investigationFinal reportCessna 172 · 45 Nw Anchorage, AKThe pilot stated that he believed he ran out of fuel during the IFR flight.NTSB MKC87LA182Accident · No injuriesLimited investigationFinal reportCessna 150K · Dubuque, IANearing completion of a personal xc flt, acft experienced a total loss of power. An emergency ldg was made approximately 3 miles short of destination apt. Acft struck terrain and nosed over. Post flt investigation revealed usable fuel supply exhausted.NTSB ANC87LA170Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Anchorage, AKThe pilot stated that she departed the airport with only one quarter tank of fuel; on final approach to the runway the engine quit. The owner stated there was less than ten (10) gallons on board the aircraft prior to take off.NTSB MKC87LA181Accident · No injuriesLimited investigationFinal reportCessna 152 · El Dorado, KSAfter departing midfield and attaining approximately 100 feet of altitude, plt experienced a complete power failure. Plt attempted to reland on intersecting runway by executing an approximate 270 degree turn. Acft struck the terrain before completing the…NTSB MIA87LA262Accident · Minor injuriesLimited investigationFinal reportBoeing E75 · Ocala, FLThe plt stated that the eng lost power & he was at low alt looking for an emerg ldg field when the wing hit a tree. The pax stated they were doing aerobatics at low alt & the eng quit. She stated that she was not wearing the required parachute & had asked the…NTSB DEN87LA246Accident · No injuriesLimited investigationFinal reportCessna 150K · Aurora, COThe student plt was flying a long cross country instructional flight. The pilot stated he became disoriented at the first check point and followed highways for the remainder of the four hour flight. The engine quit and the pilot landed in a weed filled field.…NTSB SEA87LA196Accident · No injuriesLimited investigationFinal reportCessna 150F · Mount Vernon, WAThe aircraft's engine ceased operating due to fuel exhaustion about five miles short of the destination airport. A field was selected for the landing site. During the landing roll, the aircraft nosed over on freshly plowed terrain.NTSB LAX87LA347Accident · No injuriesLimited investigationFinal reportCessna 182D · San Ramon, CAAfter telling the lineman at calexico, CA to fill the tanks, the plt walked away from the acft to clear customs. When he returned, he loaded his passengers into the acft and departed the arpt. After flying 3 and 1/2 hours the engine stopped and the acft was…NTSB DEN87LA244Accident · No injuriesLimited investigationFinal reportCessna 140 · San Ysidro, NMThe plt and pax were on a LCL sightseeing flt. The plt stated that he had been flying low and slow at a nose high attitude. The engine began to overheat and did not cool off and the pilot executed a precautionary landing on a dirt road. The acft ballooned and…NTSB CHI87LA221Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Troy, MIDrg the initial climb after takeoff, the eng lost power. Subsequently, the acft was dmgd drg a forced lndg west of the arpt. Drg an exam of the acft, 20 to 25 gal of avgas was fnd in the left fuel tank; however, the rgt tank had only residual fuel remaining.…NTSB ATL87LA266Accident · No injuriesLimited investigationFinal reportCessna 172H · Chuckey, TNThe plt estimated there was 9 gal of fuel on board when he took off. Aprx 20 min later, he was making a low pass over a private strip when the eng lost power. He stated that he repositioned the fuel selector to the other tank, but was unable to restart the…NTSB MIA87LA252Accident · No injuriesLimited investigationFinal reportCessna 150M · Belle Glade, FLThe student plt stated he was en route along the hillsborough canal when he enctrd a rain shower & retarded the power to 2000 RPM to dscnd. He stated that carb ice formed & the eng lost power. He made a forced landing on a dike. However, as the acft was…NTSB SEA87LA191Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Las Vegas, NVThe aircraft was on descent for landing at 6500 feet MSL about 5 miles from the airport when a total loss of power occurred due to fuel exhaustion. At 5000 feet AGL the pilot lowered the landing gear and at about 2000 feet AGL landing flaps were added. The…NTSB DEN87LA242Accident · No injuriesLimited investigationFinal reportMooney M20K · Aspen, COWhile on a cross country pleasure flt the acft engine failed apx four miles short of the dest aprt. A forced landing was made in a field.NTSB BFO87LA066Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Roanoke, VARoanoke tower cleared the aircraft for landing and the pilot pulled the power to idle. The pilot did not realize the engine had quit until he applied power on short final and the engine did not respond. The aircraft struck short of runway 33. The pilot stated…NTSB MIA87LA251Accident · No injuriesLimited investigationFinal reportCessna 152 · Plant City, FLThe student plt stated the acft was cruising at 3000 ft, when the eng lost pwr. She selected a fld & made an emerg lndg. Drg the lndg roll, the acft went thru a barbed wire fence, hit a ditch, nosed over & came to rest inverted. The acft had flown a total of…NTSB FTW87LA221Accident · 1 fatalLimited investigationFinal reportCessna 340A · Lubbock, TXThe pilot did not declare an emergency or mention to the tower controller that his fuel was low. He was first told to enter right traffic for runway 17R but was subsequently told to enter right traffic for runway 26. (This was to allow a dea aircraft, at its…NTSB FTW87DPJ07Accident · No injuriesFinal reportMooney M20F · Jenks, OKEngine failed during initial climb. Aircraft collided with airport perimeter fence and slid across road during landing attempt. Water was found in the fuel distributor system following the accident.NTSB ATL87LA260Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Louisville, KYThe plt made two attempts to land and during his 2nd go around the eng cut out. The plt stated that he switched from left tank to rt tank but was unable to start the eng prior to making a forced landing which resulted in a collision with a house and tree. The…NTSB NYC87LA255Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Emmaus, PADrg flt, the eng lost power over a residential area & the plt selected a small fenced-in opening for an emergency lndg. He said he crashed nosewheel 1st, then skidded into a cyclone fence. After the acdnt, the fuel selector was fnd positioned to the rgt tank…NTSB ANC87LA160Accident · No injuriesLimited investigationFinal reportCessna 185 · Mt. Watana, AKAfter liftoff from a lake the airplane's engine stopped producing power and the airplane began settling toward the remaining lake. The engine surged and the airplane crashed on the tundra, 200 yards from the lake's edge. The pilot stated that he drained the…NTSB ANC87LA159Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Skwentna, AKThe engine stopped producing power but continued to windmill. The pilot was able to glide to a gravel bar and intentionally groundlooped to avoid hitting obstructions. The pilot stated he believed the aircraft ran out of fuel.NTSB ATL87LA258Accident · Minor injuriesLimited investigationFinal reportBeech A23-24 · Fremont, OHThe eng lost pwr shortly after tkof. A forced lndg was made in a field where the acft impacted a ditch. Post-crash exam of the acft engine revealed water and solid contamination in the fuel injector servo. The plt had recently purchased the acft. The acft…NTSB NYC87FA249Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Riverhead, NYThe Piper PA-28-180 experienced a power loss due to fuel exhaustion while flying over the long island sound. The pilot was unable to reach shore prior to ditching. The ditching was successful and both occupants exited the aircraft without injuries. After…NTSB FTW87LA212Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Roby, TXAfter aprx 3.3 hrs of flt, the eng lost power from fuel exhaustion. The plt rprtd that when he made a forced landing in a field, the nose tire dug in the ground & the acft nosed over. Also, he stated that he did not top off the fuel tanks before departing on…NTSB DEN87FA231Accident · Serious injuriesField investigationFinal reportCessna 310J · Delta, UTPlt stated after the acc that he was not familiar with the fuel system on the Cessna 310. The main fuel tanks are on the wing tips and the aux tanks are in the wings. The plt thought the opposite. The plt departed and was burning fuel from the main tanks when…NTSB FTW87LA211Accident · Minor injuriesLimited investigationFinal reportCessna 152 · College Station, TXThe plt was on a x-country flt from addison to College Station, TX, but diverted to livingston, TX, due to 'time constraint.' The arpt at livingston was unattended. At aprx 1615 CDT, he took off & contd to College Station. However, during the flt, he became…NTSB ANC87LA144Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Tanana, AKThe pilot stated that he just lifted off the lake when the engine quit. The aircraft stalled and crashed into the lake. The pilot stated that he just ran out of fuel.NTSB SEA87LA182Accident · No injuriesLimited investigationFinal reportCessna 180H · Salmon, IDWhile on approach for landing a total loss of power occurred for undetermined reasons.NTSB LAX87LA322Accident · No injuriesLimited investigationFinal reportGovernment Aircraft Fact Nomad 24A · Lanai, HIWhen the flt was aprx 15 mi west of Lanai on a cargo flt from honolulu to hilo, HI, the plt observed the fuel gauges oscillating erratically toward the low side. He diverted toward Lanai to refuel. However, when the flt was abt 9 mi westof Lanai, the left eng…NTSB CHI87FA198Accident · 2 fatalField investigationFinal reportBeech B35 · Martinsville, INShortly after takeoff an engine failure occurred. The aircraft stalled and spun to the ground when the pilot tried to return to the airport. The fuel selector was positioned on the almost empty auxiliary tank (meant for use in level flight only).NTSB ATL87LA246Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Greenville, KYThe flt was being conducted as part of a 'clown act' at an air show. The eng lost pwr shortly after takeoff as the plt was performing pitching maneuvers. He unsuccessfully attempted to regain pwr by 'pumping' the throttle. The airplane subsequently impacted…NTSB SEA87FA178Accident · 1 fatalField investigationFinal reportPiper PA-20 · Chelan, WAThe pilot was observed making a engine out landing at his private grass/dirt strip. The dirt strip is located on a plateau with the runway starting at the edge of the plateau. The aircraft impacted in a steep nose down attitude below the runway level on a…NTSB MKC87LA167Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hot Springs, ARThe pilot fueled the aircraft with 20 gallons of 100LL for his flight to Hot Springs, AR. Forty miles from Hot Springs the left fuel tank indicated empty and the pilot switched to the right tank. Approximately 10 miles from Hot Springs, the engine quit and…NTSB MIA87FA234Accident · Serious injuriesField investigationFinal reportPiper PA-38-112 · Vero Beach, FLThe student plt was on an aprx 380 mi solo x-country flt fm Vero Beach (vrb) to naples (apf), brooksville (bkv) & back to vrb. He thought he had plenty of fuel for the flt & elected to dep w/o taking a credit card (for fuel). When he lndd at apf & bkv, he did…NTSB MIA87LA232Accident · No injuriesLimited investigationFinal reportCessna 152 · Sarasota, FLThe student plt had completed about 3.4 hrs of a solo cross-country training flt and was about 6 miles se of the airport, when the aircraft sustained a loss of power. A forced landing was performed in a celery field. Investigation revealed no usable fuel in…NTSB ANC87LA127Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Merrill Pass, AKThe aircraft engine failed in cruise flight. During the landing roll the airplane struck a ditch and nosed over. Examination of the aircraft and the statements from the pilot, revealed the aircraft ran out of fuel during the return trip to the airport.NTSB ATL87LA239Accident · No injuriesLimited investigationFinal reportCessna 152 · Lewisburg, KYStudent PIC flew solo x-country. About 30 minutes after dpting enroute stop engine quit. He rptd checking fuel prior to departure. Flt school policy was to refuel at enroute stop which was not done. Acft was landed in a field and hit a fence during landing…NTSB MIA87LA227Accident · No injuriesLimited investigationFinal reportCessna 182P · Highland Beach, FLThe plt stated that they were at 1000 ft aprx 2 miles off shore en route to palm Beach international when the engine lost power & they ditched the acft in the ocean about 40 ft off the Beach. The salvage personnel stated that the left wing contained aprx 10…NTSB FTW87LA202Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Bridgeport, TXThe engine quit during cruise flight at 5500 feet MSL but restarted when the pilot switched fuel tanks. He then headed for the nearest airport which was at Bridgeport, TX. While on final approach for landing the engine stopped again and would not restart. A…NTSB ATL87FA234Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Aurora, NCThe pilot ditched the aircraft after running out of fuel while en route to bayboro,NC. The flight had departed earlier in the day and had flown to melfa,VA. The pilot did not fuel the aircraft before starting the flight and over flew several possible…NTSB BFO87LA055Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Danville, VAThe accident occurred during an instructional x-country flt from chesapeake, VA. To south boston, VA. To ashland, VA. With a return to chesapeake. Prior to departure, the student plt performed the acft preflt and informed the CFI that the acft was topped off.…NTSB LAX87LA301Accident · No injuriesLimited investigationFinal reportCessna 152 · Madera, CAAfter the aircraft was flown for 3 hours and 30 minutes the engine failed. The aircraft entered a forced landing approach to an open field. The aircraft landed hard and nosed over onto its back. Ground witnesses who were on scene shortly after the accident…NTSB ATL87LA233Accident · No injuriesLimited investigationFinal reportCessna 150H · Lumberton, NCThe eng lost power and the plt attempted an off arpt landing. The acft nosed over during the landing roll. Records indicated that the acft had been refueled two days prior to the accident. Since that time it had been flown three and one tenth hours prior to…NTSB ATL87LA231Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Knoxville, TNThe plt rprtd that drg takeoff, the acft clbd normally for about 100 to 150 ft, then the eng lost pwr w/o warning. He switched fuel tanks & tried to restart the eng, but was unable. The acft was lndd & sank in a river, short of an open fld. When the acft was…