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 MIA88LA225Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Clewiston, FLThe plt stated the fuel gages indicated 20 gals when he took off on spraying flt. He had just completed the spray run & started to pull up from about 10 ft & 25 mph. At that time the eng quit '& sounded just like it would if it ran out of gas'. There was not…NTSB NYC88LA184Accident · No injuriesLimited investigationFinal reportMooney M20F · Princeton, NJThe Mooney M20F made a takeoff and as the pilot turned crosswind, he experienced a partial power loss. He returned for a landing and the engine smoothed out. He made extensive ground runs and could not duplicate the problem. However he did not have…NTSB MKC88LA128Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Holdrege, NEThe plt said that after completing a spraying operation and depleting his chemical load, he flew to a near-by farm field to check it over. Enroute, the engine quit, and attempts to restart it were unsuccessful. An emergency ldg was attempted in a plowed farm…NTSB DEN88LA160Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Boulder, COAccording to the plt, he was returning to Boulder after making a flt to aspen. He said he started the morning flt with 2/3 fuel load (about 40 gallons) but didn't know how much flt time he accumulated during the day. During his VFR approach to the Boulder…NTSB CHI88DEE06Accident · No injuriesFinal reportPiper PA-25 · Chebanse, ILThe acft had been refueled with pilot's stated quantity of 20 gals of fuel. After completing his spray operation and returning to base he stated 'ran out of gas'. Acft had been airborne 1 + 15 plus taxi and engine runup.NTSB NYC88LA183Accident · No injuriesLimited investigationFinal reportAeronca S11BC · Livingston Mnr, NYThe pilot had just departed from the surface of a lake, when at an altitude of 50 ft AGL and in a left turn, the engine quit. There was not enough altitude to make it back to the lake. The aircraft impacted trees and was destroyed. The pilot had experienced…NTSB DEN88LA157Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Gillette, WYNTSB CHI88DEX09Accident · Serious injuriesFinal reportSollars Rotorway Executive · Newburgh, INThe eng lost power as the homebuilt helicopter was on an apch to land at a private heliport. The student plt rprtd the helicopter was at aprx 50 ft AGL when the power loss occurred. Subsequently, during an autorotation, the helicopter touched down hard. No…NTSB ATL88DKG10Accident · No injuriesFinal reportCessna 188 · Douglas, GANTSB LAX88FA256Accident · Serious injuriesField investigationFinal reportCessna T210M · Carson, CAThe pilot failed to follow the emergency procedures as outlined in the pilot operating handbook by switching the fuel selector to the fullest tank. Contributing to this accident was fuel exhaustion of the right wing tank as a result of fuel siphoning.NTSB SEA88LA126Accident · Minor injuriesLimited investigationFinal reportBeech C23 · The Dalles, ORCFI underestimated fuel consumption on multi-stop cross country and did not visually check fuel remaining prior to last departure. Fuel exhaustion occurred 18 minutes into flight. Acft flipped inverted on forced landing.NTSB MIA88LA221Accident · No injuriesLimited investigationFinal reportHahn RV-4 · Zellwood, FLFlt experienced rough running engine and loss of power. As acft was turned toward agricultural strip for an emergency landing the engine failed completely. The plt touched down short of the runway and bogged down in tall grass and muck causing collapse of the…NTSB LAX88FA254Accident · Serious injuriesField investigationFinal reportSikorsky S-58BT · Marina Del Rey, CAMismanagement of the fuel system by the pilot which resulted in fuel starvation and a duel engine flameout. Contributing to the accident was the pilot's lack of total experience in the Sikorsky S58T.NTSB LAX88FA252Accident · 1 fatalField investigationFinal reportBeech A35 · Lompoc, CAPilot's improper use of the fuel system and his failure to maintain control of his aircraft. Contributing factors were the pilot's intentional operation of an aircraft with known deficiencies in equipment, his improper emergency procedure and his lack of…NTSB FTW88DRD15Accident · No injuriesFinal reportCessna A188B · Patterson, LAShortly after takeoff, the engine lost power & the plt dumped his load. Subsequently, the acft crash landed in a cane field. No preimpact mechanical problems could be found with the engine or fuel system. Water was found in the fuel tank outlet screen,…NTSB ATL88LA212Accident · Minor injuriesLimited investigationFinal reportCessna 310 · New Bern, NCThe plt rptd the lt engine lost pwr on 'very short final'. Shortly thereafter, he heard the stall warning. The airplane rolled and yawed left, and crashed nose-down short of the rwy. The acft was examined the next day by an FAA inspector; he rptd finding no…NTSB DEN88LA148Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Craig, COWhile on final after a 4.6 hr x-cnty flight, the pilot reported that the engine quit. The plt said that the engine probably failed due to fuel exhaustion. Personnel at the wreckage site reported no fuel was found in the fuel tanks. After the engine failed,…NTSB ATL88FA210Accident · Serious injuriesField investigationFinal reportCessna 210L · St. Marys, GANTSB MIA88LA217Accident · No injuriesLimited investigationFinal reportPiper PA-25-235C · Stringer, MSAccording to the pilot while on a ferry flight during normal cruise at an alt of aprx 2000 ft, the eng quit due to fuel exhaustion. During the forced landing the acft collided with a tree.NTSB MIA88LA215Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Vero Beach, FLThe plt stated that while inbound to Vero Beach, he ran out of fuel in the left tank. The engine quit, and he was unable to restart the engine before he crashed into a grove of trees.NTSB MIA88FA214Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Clearwater, FLThe private pilot experienced a rough running engine on takeoff roll and continued the takeoff. After liftoff the engine failed and he crashed into a residence. The engine fuel control and fuel divider block were found to have water, rust and sand in them.…NTSB NYC88LA175Accident · No injuriesLimited investigationFinal reportCessna 150M · W. Seneca, NYThe instructor pilot stated that the student pilot conducted the preflight and reported the fuel 'down a little.' The instructor did not visually verify the amount of fuel on board. Investigation revealed that the acft ran out of fuel and was forced to land…NTSB MIA88LA211Accident · No injuriesLimited investigationFinal reportCessna 152 · Marathon, FLThe student plt was on his 1st solo x-c flt. A portion of the flt included a 30 mi stretch over the Florida bay section of the gulf of Mexico. The flt carried no flotation gear. 5.2 hrs into the flt, the eng quit & a ditching was performed near a pleasure…NTSB ATL88LA208Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Thomson, GAThe plt reported that the engine lost pwr about 20 miles from the arpt where he had intended to refuel. The airplane subsequently collided with utility wires as he was attempting to land on a hwy. the plt attributed the pwr loss to fuel exhaustion. Postcrash…NTSB CHI88LA146Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Lonsdale, MNThe pilot was executing a power-off glide and when an attempt was made to recover by adding power, the engine did not respond. The pilot was then forced to make an emergency landing in a field. During the forced landing the pilot was unable to maintain…NTSB LAX88LA238Accident · Minor injuriesLimited investigationFinal reportCessna 414A · Agua Caliente, CADuring a cross country flight, the right engine began to run rough. The pilot feathered the propeller and turned to land at the airport. En route, the left engine began to run rough. Unable to land at the airport, a forced landing was made on a road, where,…NTSB DEN88LA140Accident · No injuriesLimited investigationFinal reportBeech C35 · Brighton, COShortly after takeoff and while cruise flight, the eng lost pwr. The fuel pressure gauge indicated o PSI. The plt switched on the electric fuel pump. The eng did not respond. The plt activated the auxiliary (wobble) pump and switched fuel tanks. The eng still…NTSB ATL88LA202Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Whitsett, NCThe plt reported that the engine lost power during initial climb at 150 ft AGL. He attempted to make a 180 deg turn back to the arpt; the airplane crashed at about the 180 deg point. Post-crash exam of the engine revealed no evidence of mechanical failure or…NTSB BFO88FA060Accident · No injuriesField investigationFinal reportPiper PA-32RT-300T · Cambridge, MDThe pilot had departed ocean city, MD aprx 20 minutes after takeoff when nearing the chesapeake bay at an alt of 3000 ft MSL, a total loss of engine power was experienced. The plt attempted to restart the engine to no avail and a forced landing was made in a…NTSB SEA88LA117Accident · Serious injuriesLimited investigationFinal reportCessna 210G · Bend, OROn arrival in area of planned fuel stop, pax did not feel well. Plt determined that adequate fuel remained to continue to final destination. However, exhaustion occurred 8 miles short of destination. Plt diverted from initial forced lndg site (road) due…NTSB DEN88LA135Accident · Serious injuriesLimited investigationFinal reportBell 47G · Terry, MTThe aircraft was on a ferry flight from alpine, WY. To belfield, ND. The plt departed alpine at approximately 0950 and made several enroute stops to refuel. The plt intended to land at miles city, MT to refuel but he got lost and flew to Terry, MT, located 38…NTSB CHI88LA142Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Kenosha, WIThe pilot was picking up the aircraft after being serviced when approximately 20 minutes after taking off the engine quit. The pilot was forced to make an emergency landing in a field. During the landing sequence the aircraft contacted some trees at the edge…NTSB ATL88FA200Accident · 1 fatalField investigationFinal reportGlobe GC-1B · Myrtlewood, ALNTSB LAX88LA227Accident · No injuriesLimited investigationFinal reportCessna 210M · Tres Pinos, CANTSB LAX88LA205Accident · No injuriesLimited investigationFinal reportCessna 150J · Calistoga, CANTSB SEA88FA113Accident · Minor injuriesField investigationFinal reportBeech 58P · Bellevue, WAThe plt reported that 20 gallons of fuel was added on may 18 and stated this brought the main tanks up to near full (160 gal). Between that fueling and the acc a total of 6.0 hours were recorded and an additional 80 gallons of fuel was added. Records at the…NTSB CHI88DEC03Accident · Minor injuriesFinal reportCessna 150 · Jackson, MITotal loss of engine power due to carburetor icing.NTSB BFO88LA055Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Capon Bridge, WVLoss of power because of carburetor ice which obstructed airflow to the engine. The aircraft nosed over on landing because of soft terrain and high grass. The pilot's failure to use carburetor heat is a contributing factor.NTSB FTW88FA119Accident · 4 fatalField investigationFinal reportCessna 205 · Elgin, TXThe pilot radioed that he was running out of fuel while being vectored for landing. The ceiling was about 900 feet with 5 miles visibility and the accident occurred in a level grass field. Witnesses heard the engine cutting out and a loss of control occurred…NTSB DEN88FA126Accident · Serious injuriesField investigationFinal reportCessna 404 · Denver, COThe plt was on a flt from greeley to Denver, Colorado to obtain minor maint on a cargo door. As the acft was being vectored on final apch, the plt rprtd that he believed the acft had fuel starvation. Subsequently, the acft was observedto make a complete roll…NTSB MIA88LA188Accident · Minor injuriesLimited investigationFinal reportCessna T210R · Tampa, FLThe plt stated that on final apch to Tampa international airport, he reduced power, put the gear down and, as he tried to add power, none was available. During an attempted forced landing, he hit the top of an office trailer and a guy wire before coming to…NTSB LAX88DVA06Accident · Minor injuriesFinal reportCraven Teenie TWO · Fowler, CADuring cruise flight, the pilot reported a loss of oil pressure. The engine then sputtered and quit. The pilot initiated a forced landing where the airplane collided with several wooden crates short of the intended ldg area. Inspection of the engine revealed…NTSB LAX88LA218Accident · No injuriesLimited investigationFinal reportRockwell 690C · Hayward, CAAt the end of a cross country flight, while on final approach to the runway, the right engine quit. Shortly thereafter, the left engine quit. The pilot made a forced landing in a field short of the runway where during the landing roll the airplane collided…NTSB DEN88DTE05Accident · No injuriesFinal reportPiper PA-25-235 · Limon, COThe plt reported that he was making his third swathrun when the eng quit. He attempted a forced landing but the acft nosed over. The plt said he had 15 gal of fuel on board at takeoff and had been airborne about 15 min. The FAA a/w insp who examined the…NTSB FTW88DPJ05Accident · 1 fatalFinal reportStinson 108-3 · Collinsville, OKThe pilot experienced a loss of engine power during the takeoff leg. Post accident investigation revealed that the fuel selector was in the near closed position. This position only allowed a small percentage of the fuel to flow but would allow operation in…NTSB CHI88LA125Accident · Minor injuriesLimited investigationFinal reportCessna TU206B · Ellsworth, WIDuring cruise flight the pilot experienced an engine failure which he believed to be caused by fuel exhaustion, and executed a forced landing in unsuitable terrain. Post accident inspection revealed that the left fuel tank contained 23 gallons of fuel at the…NTSB MKC88LA105Accident · No injuriesLimited investigationFinal reportBeech 35C · Manhattan, KSArriving at the original destination apt, the PIC decided on an alternate, nearby airport, due to confusion regarding runway conditions at the original destination apt. Flying to his alternate, he erroneously lined up at a military airport located about 10…NTSB MIA88FA187Accident · Serious injuriesField investigationFinal reportCessna 172N · Jacksonville, FLThe private pilot had been hired to ferry a recently purchased aircraft. He stated that the aircraft had not been flown for about 2 weeks. He had it refueled and checked the fuel tanks for water. After takeoff the engine failed at about 200 ft. he crashed…NTSB FTW88LA113Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Hinton, OKThe pilot departed bethany, Oklahoma on a local pleasure flight with the fuel tanks slightly less than 1/2 full. After about a 1.5 hour flight, he landed at the red rock airport in Hinton, Oklahoma. No service was performed on the aircraft while in Hinton and…NTSB DEN88LA117Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Ft. Collins, CO