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 CHI82FA223Accident · No injuriesField investigationFinal reportCessna 337B · Greenville, ILDuring the initial climb after a touch & go, the rear eng stopped at about 100 to 200 ft AGL. The plt switched the fuel selector to right aux tank but was unable to restart the rear eng. At about 300 to 400 ft AGL the front eng stopped. The plt switched the…NTSB MIA82DA135Accident · Minor injuriesFinal reportCessna 182P · Chuluota, FLThe pilot reported a normal preflight check was made which included draining fuel from the fuel tank sumps and the strainer. He reported that about one inch of water (in a fuel sampler cup) was drained from the left wing. No water was noted in the right wing…NTSB FTW82DA230Accident · No injuriesFinal reportRockwell S2R · Bishop, TXReportedly, the pilot realized he was low on fuel, but thought he had enough to finish spraying the field and return to the landing area. As he pulled up from the last pass, he noticed that one fuel gauge was on empty and the other was indicating about 1/8…NTSB MKC82DA104Accident · No injuriesFinal reportCessna 152 · 10 Sw Falls Cit, NEThe pilot stated that he took off to take photographs in nemaha county, KS. While enroute, he shot 6 rolls of film and then continued toward falls city, NE. He reported that about 7 miles from the airport, he ran out of fuel and landed in a wheat field. After…NTSB ATL82DA166Accident · Minor injuriesFinal reportPiper 22-160 · Lynchburg, VAThe pilot took off from newport news, VA on a VFR flight to south boston, VA. Later at dusk, he contacted the roanoke fss and asked for an "accurate fix" of his position. At that time, the pilot indicated that he was low on fuel. Fss personnel reported that…NTSB ATL82DA165Accident · Minor injuriesFinal reportBeech A36 · Myrtle Beach, SCAs the pilot approached his destination, he descended from 9000 ft MSL and leveled at 1600 ft MSL. At about the time he leveled, the engine quit abruptly. He stated that he switched the fuel selector to the right tank and tried to start the engine, but was…NTSB LAX82DA220Accident · No injuriesFinal reportCessna 172 · Lancaster, CADuring flight, the pilot landed at an airport to refuel. However, the fuel trucks were locked up and no one was at the UNICOM office, even though, the airport directory indicated the field was attended and fuel should have been available. The pilot…NTSB FTW82DA225Accident · Minor injuriesFinal reportCessna 175 · Fort Worth, TXDuring a go-around the aircraft's engine quit. The pilot attempted an off-airport emergency landing; however, collided with bushes and nosed over. Investigation revealed there was a minimum amount of fuel onboard.NTSB MKC82DA100Accident · No injuriesFinal reportCessna 182B · Milford, IAThe pilot reported that he was low on fuel and was flying over the airstrip before landing to drop a banner that he was towing. Shortly after the banner was released, the aircraft encountered turbulence causing the aircraft to go into a steep bank. At about…NTSB SEA82DA085Accident · No injuriesFinal reportBell 206B · Swan Valley, IDThe aircraft crashed during an external load operation at an elevation of about 6700 ft MSL in mountainous terrain. The pilot reported that the fuel gauge indicated 8 gallons remaining when he last checked it before the accident. Reportedly, he checked his…NTSB NYC82DA122Accident · No injuriesFinal reportCessna 172 · Monongahela, PAThe pilot was on a flight from rostraver, PA to deerfield, oh and return. Before taking off from rostraver, he estimated there was 25 gal of fuel on board. At deerfield, he estimated there was 15 gallons remaining (12 gal usable). But that he would need only…NTSB FTW82DA221Accident · No injuriesFinal reportCessna 206-5 · Somerville, TXDuring a cross country flight the pilot switched fuel tanks and the engine quit. The pilot switched back to original setting but could not restart the engine. During the forced landing the aircraft collided with a steel fence. Maintenance personnel stated the…NTSB DEN82DA101Accident · No injuriesFinal reportCessna 188B · Central, UTPilot ran out of fuel and made a forced landing during which a wing collided with a fence.NTSB NYC82DA120Accident · No injuriesFinal reportCessna 185E · Round Lake, NYThe pilot stated that during his preflight, he drained the main sediment bowl for 5 seconds, then repeated draining it for another 5 seconds. He reported that he performed an engine run-up, switched all tanks on, and initiated a takeoff. Reportedly, the…NTSB ATL82FKG14Accident · Minor injuriesFinal reportFokker DR-1 · Hampton, GAThe pilot was also the owner of the fixed tri-wing, amateur-built aircraft. After returning from a local flight, he entered the traffic pattern. He flew a large pattern to maintain spacing behind a Cessna 150. After making a low approach, he positioned…NTSB SEA82FYM18Accident · 2 fatalFinal reportMccall KR-2 · Union, ORReportedly, the aircraft departed la grande, OR with 12 gallons of fuel on board and was flown to baker, OR. Later, the pilot departed baker on a return flight to la grande without refueling. Subsequently, the plane was reported as missing. The next day it…NTSB LAX82FVD17Accident · 1 fatalFinal reportSavage Skybolt · Livermore, CAAfter the eng quit witnesses observed the acft nose over to about a 30-45 deg nose down attitude. No usable fuel was found in the acft. The acft has a section of clear plastic tubing on the outside of the fuel tank that is used as the fuel gauge. It would be…NTSB MIA82DA131Accident · No injuriesFinal reportCessna 182K · Arecibo, PRThe pilot stated that he had 8 gallons of fuel on board before takeoff. At 0700, he departed on a flight from san juan to aguadilla, PR with an intermediate stop at Arecibo, PR for refueling. At about 0725, the aircraft ran out of fuel, about 3 miles from…NTSB DEN82DTI13Accident · No injuriesFinal reportAir Tractor AT-301 · Ruyard, MTThe aircraft was refueled prior to takeoff. The pilot reported that the takeoff was normal until about 75 ft off the runway when the engine quit. During a forced landing, the plane touched down in a 3-point attitude, bounced, and then hit the ground in a nose…NTSB MKC82DA094Accident · No injuriesFinal reportContinental Mk5a Bell 47 · Neligh, NEThe pilot departed the airport helipad with 12 gallons of fuel. After landing in the loading area, he left the engine and spray pumps running to mix the solution in his spray tanks. After spraying the field, he ran out of fuel about one mile from his planned…NTSB CHI82DA196Accident · No injuriesFinal reportBell 47D1 · Le Sueur, MNDuring a spraying operation, the aircraft was being refueled from a 200 gal fuel tank, mounted on the rear of a truck. The truck was parked on a slight slope with the outlet for the servicing hose at the lower end. After the helicopter was serviced with 14…NTSB ATL82FA145Accident · Serious injuriesField investigationFinal reportCessna U206G · Norfolk, VAThe eng quit during final approach. The acft had a history of problems with water in fuel system leading to engine problems. On 2/8/82 significant quantities of water was found in the fuel system. Post crash examination revealed water in the fuel system.…NTSB ATL82DA146Accident · No injuriesFinal reportPiper PA-38 · Pell City, ALThe aircraft was being used to return with another pilot after the other pilot had ferried his aircraft from bessember, AL to knoxville,TN. The pilot estimated that he had sufficient fuel to return, and since the FBO was busy, he elected to depart without…NTSB ATL82FIG07Accident · 1 fatalFinal reportGrumman G-164A · Frederick, MDThe pilot reported that 1 to 2 ounces of water was drained from the low point fuel sump, but no water was detected from the other sumps. He stated that he drained the sump until no water was detected. During the flight, the engine surged twice, then lost…NTSB CHI82DA187Accident · No injuriesFinal reportCessna 182 · Cedarville, OHThe pilot stated that the engine failed while enroute and an emergency landing was made in a corn field. He also reported that the loss of power was due to carburetor icing. The aircraft was substantially damaged and there were no injuries.NTSB FTW82FPG13Accident · 1 fatalFinal reportLuscombe 8A · Parkin, ARThe pilot departed presidents isle, TN with about 1/4 tank of fuel (3.5 gal) and proceeded en route with a planned stop at wynne, AR for fuel. Prior to reaching wynne, heavy rain was encountered and a landing was made at a private airport near Parkin, AR. The…NTSB MIA82DA121Accident · No injuriesFinal reportPiper PA-22-108 · Tampa, FLWhile circling over the area where the pilot resided, a complete loss of power occurred. During the emergency landing the pilot stalled the aircraft while attempting to avoid a collision with an autombile. Both the aircraft and the automobile were…NTSB LAX82DA189Accident · Minor injuriesFinal reportPiper PA-44-180 · Chandler, AZThe pilot departed Chandler, AZ with the fuel gauges indicating 40 plus gallons in each tank. After a 1.2 hr flight to lake havasu city, AZ, the gauges indicated 20 plus gallons in each tank. During the return trip to Chandler at night, both engines lost…NTSB ANC82DAA03Accident · No injuriesFinal reportBrantly B-2B · Fairbanks, AKShortly after takeoff, a partial power loss occurred over a wooded area and the pilot initiated an autorotative landing. During the landing, the main rotor and tail rotor blades hit trees, then the right skid set down on a small tree and the helicopter rolled…NTSB FTW82DA190Accident · No injuriesFinal reportBellanca 7GCBC · Mt. Pleasant, TXAfter takeoff from runway 17, the pilot departed the traffic pattern and was about 1.5 miles north of the airport when the engine coughed. He immediately turned back toward the airport, but shortly thereafter, the engine lost all power. He decided to land on…NTSB LAX82DA190Accident · Minor injuriesFinal reportCessna 172XP · Hilo, HIThe pilot stated that he requested 30 gallons of fuel for an estimated flight time of 3.5 hours. During the flight the engine ran rough and the right tank went to empty. The pilot then switched tanks and about 2 minutes later the pilot stated that the left…NTSB SEA82FYM16Accident · Minor injuriesFinal reportHughes 369D · Birkenfeld, ORThe pilot stated that the fuel gauge indicated 150 lbs of fuel remaining when he began the flight. Since the drop point was within 2 to 3 minutes of the departure point, he elected to proceed without refueling. While hovering and being guided into the drop…NTSB MKC82DA083Accident · Minor injuriesFinal reportCessna 150 · Chadron, NEAfter flying 1.2 hours with an instructor pilot the student pilot was released for solo flight. The student then flew for .7 hours before running out of fuel. The aircraft nosed over after touching down in a pasture. The instructor pilot stated that the fuel…NTSB LAX82FUA15Accident · Minor injuriesFinal reportCessna 150 · Torrance, CAThe purpose of the flight was to provide instrument training to a non-instrument rated pilot. The aircrew estimated that there was 10 gallons of fuel on board when they took off. About 1 hr later, the engine lost power as the aircrew were entering the traffic…NTSB CHI82DA173Accident · No injuriesFinal reportCessna 210 · Loganville, WIDuring landing approach the engine lost power and the pilot attempted to land in an open field. The aircraft failed to clear a terrace and the nose gear separated from the airplane. The pilot stated, "while concentrating on the various aspects of operation in…NTSB MKC82DA089Accident · No injuriesFinal reportPiper PA-38-112 · Scottsbluff, NEThe pilot stated that during an approach for a touch and go landing, at an altitude of about 50 feet above the runway the aircraft began to drop. He applied throttle and the engine hesitated, failing to accelerate until just before impact with the runway. The…NTSB FTW82FRG31Accident · Serious injuriesFinal reportPiper PA-30 · San Antonio, TXDue to unfavorable weather conditions enroute to austin, TX the pilot diverted to San Antonio, TX. The engines lost power as the aircraft approached the destination airport. The pilot was unable to restart the engines or glide to the airport and the pilot…NTSB CHI82DA171Accident · Minor injuriesFinal reportBell 47G-5 · Sublette, ILPrior to this flight, the helicopter had been flown about 1 hr from roselle to Sublette, IL, then it was flown another 1/2 hr to survey the area to be sprayed. About 10 minutes after departing to spray, the engine lost power. The pilot started an autorotative…NTSB NYC82FHD19Accident · No injuriesFinal reportLuscombe 8A · Bargaintown, NJAt about 50 ft AGL after takeoff the eng lost power & the acft settled into trees. The plt stated the eng quit due to carburetor ice. The eng was tested & operated normally.NTSB NYC82FHD12Accident · No injuriesFinal reportCessna 188A · Winslow, NJThe acft ran out of fuel while returning to the arpt. The acft landed into a plowed field & then on into an orchard.NTSB LAX82DA175Accident · No injuriesFinal reportCessna 177B · 6 Nm S. Of Lake, CAThe pilot stated that when he performed his preflight of the aircraft the visual check of the fuel tanks indicated fuel to the bottom of the tabs. Twenty two minutes after takeoff the engine quit. He executed a landing and the aircraft collided with a ditch…NTSB MKC82DA078Accident · Serious injuriesFinal reportCessna T210N · Near O'Neill, NEThe aircraft landed successfully at centerville, IA on its first leg of the flight. The aircraft was not refueled and the pilot estimated 4 hrs fuel on board for a 2 hr and 40 minute flight. The flight made 4 missed approaches before proceeding to an…NTSB MKC82FA075Accident · Serious injuriesField investigationFinal reportBeech A36 · Smithville, MOThe plt reported a loss of power & unable to reach the arpt. The acft collided with trees during the forced landing & then landed hard, gear up, in a farmyard. Examination revealed that the left fuel tank was empty. The right fuel tank was full & the fuel…NTSB FTW82DA170Accident · No injuriesFinal reportCessna 152 · Coahama, TXThe pilot was on a cross country flight for his commercial pilot's license. He became lost, landed in a plowed open field and the aircraft nosed over. There was no evidence of propeller rotation or fuel at the scene of the accident.NTSB ANC82DAG23Accident · No injuriesFinal reportBellanca 7ECA · Culkana, AKDuring the flight the pilot descended to about 500 feet AGL. Carburetor heat was not applied. When the throttle was advanced the engine RPM did not respond. Attempts to restore power were unsucessful and the aircraft came to rest inverted after colliding with…NTSB NYC82FNC09Accident · No injuriesFinal reportCessna U206 · Millinocket, MEBefore departing smith pond, Maine, the pilot checked the fuel and estimated he had between 30 and 40 gallons on board. He flew to waterville, then to katachdine lake, and was on the next leg of the flight when the engine lost power. He switched tanks and the…NTSB FTW82DPG10Accident · Serious injuriesFinal reportCessna 188B · Glenwood, ARThe pilot became disoriented while on a ferry flight. He spotted a water tower in the town of Glenwood, AR and determined that he was about 35 miles southeast of his destination. He reported that the fuel gauge indicated between 1/4 and 1/2 full after he…NTSB FTW82DA164Accident · No injuriesFinal reportGrumman G-164B · Houston, TXAfter takeoff the engine lost power and the aircraft was landed in a plowed field. During the landing roll the aircraft nosed over. An engine teardown revealed water and contamination of the fuel system.NTSB FTW82DA161Accident · Minor injuriesFinal reportBoeing E75 · Sterling City, TXThe pilot stated that he was flying the aircraft from devine, TX to Montana for the owner. He received about a half-hour of dual instruction in the aircraft and then departed. Several en route stops were made. The pilot stated that he checked the fuel…NTSB MKC82DA067Accident · No injuriesFinal reportCessna 150 · Nevada, IAAfter returning from a cross-country flight, the pilot made one go-around when he thought he was too fast. Just beyond the end of the runway at about 200 ft AGL, the engine stopped running due to fuel exhaustion. The pilot attempted to turn and land on the…