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 CHI85LA016Accident · Serious injuriesLimited investigationFinal reportCessna 340 · Blue Earth, MNDuring arrival, the plt was cleared for a vor/dme apch to rwy 31. As he continued, he intercepted a 12 mi arc. He stated that when he applied power to level off at 2800 ft MSL & no power was available. He moved the mixtures to full rich, positioned the fuel…NTSB ATL85LA012Accident · No injuriesLimited investigationFinal reportCessna 150 · Wirtz, VAAfter a 1 hr 45 min flt, plt decided to initiate another flt. Fuel quantity gages indicated 1/4 full. Eng lost pwr on initial climb. Forced landing executed in open field, wind struck fence post. Post-mishap inspection revealed fuel exhaustion.NTSB ATL85LA010Accident · No injuriesLimited investigationFinal reportRobinson R22 · Hueytown, ALThe acft crashed into a river while on final approach to land. The plt reported that he allowed engine RPM to drop and at the same time applied collective pitch. The acft struck the water in a steep descent. There was no report of any failures or malfunctions.NTSB ATL85LA009Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Brookhaven, MSA total power loss occurred due to fuel exhaustion. During a forced landing, the plt stalled the acft while clearing over power lines, then the acft collided with trees as it descended out of control. A successful test run of the eng was performed.…NTSB ANC85LA003Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Big Susitna Rvr, AKEngine failure occurred shortly after takeoff due to water contamination in the fuel system. The pilot stated that a more thorough pre-flight inspection should have been accomplished. The acft collided with the terrain during the uncontrolled descent.NTSB LAX85LA007Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Essex, CAThe plt reported that he visually checked the quantity of fuel in the acft's fuel tanks prior to departure & that he apparently overestimated the amount in the tanks. Following the accident the plt reported that he opened the fuel caps to both tanks & they…NTSB LAX85LA005Accident · Minor injuriesLimited investigationFinal reportBeech H35 · Corning, CAPlt stated he departed sacramento earlier in the day with the tip tanks empty and the main and aux fuel tanks full (aprx 57 gallons usable fuel). He stated he used the left main fuel tank for 35 minutes and then switched to the right main tank for remaining…NTSB LAX85LA004Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Lamont, CAThe plt stated that he had flown earlier on the day of the accident for aprx 30 mins. He stated that he intended to refuel before his next flight, but because the fuel hose would not reach the aircraft, the acft was not refueled. Thepilot did not visually…NTSB ATL85LA002Accident · No injuriesLimited investigationFinal reportCessna 150L · So.Charleston, WVShortly after takeoff while on the base leg at 900 ft AGL, the engine quit. Plt stated attempts to restart the engine failed. During the forced landing apch the acft collided with trees and a high tension wire. The acft spun around 180 deg and came to rest on…NTSB ATL85LA001Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Milledgeville, GAThe plt departed for the intended destination, but was unable to find the arpt due to fog. After landing at another nearby arpt, he found no av-gas available. He then elected to return to his original destination, but experienced a total power loss due to…NTSB NYC84FNC10Accident · Serious injuriesFinal reportBell 47G-3B1 · Lincoln, NHThe acft was being used in a passenger sightseeing operation when shortly after takeoff the eng ceased to operate & the acft crashed into trees. Both passengers aboard the helicopter observed that the fuel gage indicated empty prior to the eng stopage. Exam…NTSB FTW84LA413Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Rosenburg, TXThe acft was subst damaged during a forced landing following a total loss of power. Investigation revealed the acft was on the return leg of a x-country when the student plt became lost & while searching for an arpt ran out of fuel.NTSB FTW84LA411Accident · No injuriesLimited investigationFinal reportCessna 152 · Houston, TXStudent plt departed on supervised solo cross-country flt to specific destination and return. Instead, plt landed at unimproved field without required prior operator approval and embarked his wife as a passenger for a local flight. On return from local flt, a…NTSB DEN84LA304Accident · No injuriesLimited investigationFinal reportBeech C24R · Bismarck, NDPlt calculated the flt to be 4 hours 33 minutes long and there were 5.2 hrs of fuel on board. Plt stated, en route he was requested to climb from 6,000 ft to 8,000 ft then to 9,000 which was performed at 'full power, fuel full burn.' Stronger headwinds were…NTSB SEA84LA200Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Boulder City, NVPlt executed a forced landing in a field following a loss of power during initial takeoff climb. Post accidnet investigation revealed a large quantity of water in the fuel system. The acft had been parked at an arpt with 1/2 full fuel tanks. The tie down area…NTSB DEN84LA301Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Kiowa, COWhile practicing a simulated engine failure the student plt inavertantly shut off the fuel. During the actual forced landing in a rough field, the acft contacted a yucca plant and a gear collapse resulted. The CFI later reported the spring loaded safty stop…NTSB DEN84LA299Accident · No injuriesLimited investigationFinal reportCessna T207A · Mexican Hat, UTPlt stated after accident that while on final approach with eng pwr reduced for landing, the acft began to descend below the desired glidepath. When the throttle was advanced there was no added thrust. An in-flight restart was unsuccesful. The acft landed…NTSB ATL84FLT15Accident · No injuriesFinal reportPiper PA-28-181 · Jackson, TNDuring a go-around, the engine lost all power. The pilot was able to land on the rwy. The acft went off the end of the rwy, went through a ditch, struck a fence and came to rest on an adjacent road. Examination disclosed no fuel in the left tank. The right…NTSB ATL84MA296Accident · Serious injuriesMajor investigationFinal reportPiper PA-31T3 · Atlanta, GAThe normal fuel load for the flt was 1500 lbs, but with a forecast tail wind & an estimated flt time for only 1+10, the crew accepted the lower indctd (950 lb) fuel load. The flt was uneventful until an indctn of 250 lbs per side, then the fuel 'seemed to…NTSB CHI84LA401Accident · No injuriesLimited investigationFinal reportBell 47G-3B1 · Miss.Pal.St.Pk, ILThe helicopter experienced a total loss of power aprx 2 minutes after takeoff. The plt performed an autorotation into trees as no suitable landing area was available. The 2 passengers on board stated the plt did not visually check the fuel quantity before…NTSB FTW84LA406Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Sand Springs, OKAcft was on final apch to land on return leg of x-country when eng began running rough and subsequently quit. Acft contacted trees short of the rwy. Plt stated a ttl of 5 gallons of fuel were drained from both fuel tanks collectively after the accident.…NTSB LAX84LA489Accident · Minor injuriesLimited investigationFinal reportCessna 182D · Lincoln, CAAfter a descent from 11,000 ft, the eng lost power at 3500 ft & would not restart. At that time, the plt noted that the fuel gages indicated the right tank was about 1/4 full & the left tank was empty. He landed in a rice field at night where the nose gear…NTSB FTW84LA407Accident · Minor injuriesLimited investigationFinal reportBeech 95-C55 · Dallas, TXThe acft received subst damage during an emerg landing after loss of power in both left & right engines. The plt landed the acft in a river bed with the gear retracted during the hours of darkness. The acft was serviced with 10 gals of 100LL prior to…NTSB MIA84FA256Accident · No injuriesField investigationFinal reportDouglas DC3 · Boca Raton, FLFour hours and forty mins after takeoff aprx 6 miles from the dest aprt, both engs stopped running. Attempts to restart the engs were unsuccessful. Thinking they were out of fuel, the crew accomplished a forced landing in a wildlife refuge in 10 ft tall…NTSB NYC84FGM07Accident · Serious injuriesFinal reportPiper PA-28-140 · South Fork, PAUpon departure the plt estimated 25 gal of fuel. The total power loss occurred 1 hr and 55 min later. After the forced ldg on unimproved terrain no evidence of fuel remained in the fuel system. There was no indication of any full spill from the ruptured left…NTSB DEN84LA291Accident · No injuriesLimited investigationFinal reportCessna 172P · Longmont, COThe plt was making a low pass over a strip he wanted certified. During an attempted go-around the eng would not respond so the plt landed. The acft ran off the end of the wet sod airstrip and nosed over. The plt said after the accident that the carburetor…NTSB ATL84LA287Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbus, GAThe plt departed deland, FL, for Columbus, GA, with an intended fuel stop at americus, GA. While en route from deland to americus the ceiling became lower than forecast and the plt made the decision to fly at 8500 ft MSL staying above the cloud layer. With…NTSB SEA84LA221Accident · No injuriesLimited investigationFinal reportCessna T206 · Austin, NVPersonnel employed by the operator stated that the pilot flew the acft for 1.8 hours the night before the accident. Without refueling, the plt flew for 3.6 hours when the engine failed due to fuel exhaustion. During the forced landing roll the acft traveled…NTSB NYC84FA313Accident · Serious injuriesField investigationFinal reportPiper PA-34-200T · Buffalo, NYThe acft crashed on main street, Buffalo, NY, while executing a forced landing during an air taxi cargo operation. Investigation revealed that based on fuel consumption calculations the plt had not allowed for all contingencies during his orginal flt planning…NTSB CHI84LA391Accident · Minor injuriesLimited investigationFinal reportCessna 182J · Medina, OHAcft had been fueled for aprx 4 hrs endurance. Two hrs into flt on IFR flt plan, plt descended to 3000 ft with intermittent visual ground contact. Shortly thereafter, with the acft about 10 mins from destination, the engine began to sputter. Plt stated he…NTSB LAX84LA479Accident · No injuriesLimited investigationFinal reportCessna 150M · Baker, CAThe acft was damaged in a forced landing after the engine quit. The acft made a stop during its x-country and fuel was added which did not fill the tanks. During the next days flt the plt noticed the fule gages indicated almost empty and headed for the arpt…NTSB FTW84FA393Accident · Serious injuriesField investigationFinal reportBell 206B II · Dallas, TXAcft made forced autorotative landing off arpt in a residential area which was congested. Acft developed a high sink rate in the autorotation and landed hard. The forced landing was due to fuel exhaustion. 45 gallons of fuel were added to the acft at 1226 CST…NTSB MKC84LA277Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Vilonia, ARThe acft was forced to land after takeoff when the engine lost power. The plt said he had refueled from the automotive pump at his grocery store. The plt suspected water contaminaion in the fuel.NTSB FTW84LA392Accident · No injuriesLimited investigationFinal reportCessna 140 · Liverpool, TXAt aprx 900 ft AGL the eng lost power and the plt executed a forced landing in the unimproved terrain. At touchdown the acft struck trees and a dirt enbankment nosing over inverted. Investigation revealed water in the gascolator as well as the left fuel tank.…NTSB FTW84LA388Accident · No injuriesLimited investigationFinal reportCessna T210M · Austin, TXDuring arrival, the plt reduced power on base leg for for a landing. When he realized his airspeed was dissipating faster than normal, he advanced the throttle, but the eng did not respond. The plt then switched fuel tanks, turned on the boost pump & applied…NTSB SEA84LA225Accident · No injuriesLimited investigationFinal reportCessna 150 · Bandon, ORThe plt indicated that 15 minutes had been flown on the full fuel tank prior to the accident flight. The plt departed at 1330 on a siteseeing flt around the local area. After 3.7 hrs of flight, while on final approach to rwy 34, the engine quit. The plt…NTSB FTW84LA384Accident · No injuriesLimited investigationFinal reportCessna 175 · Corsicana, TXThe plt stated the acft lost eng power & he attempted an emerg landing in a field. During the landing roll the acft collided with a wire fence due to darkness. The exact amount of fuel remaining in the acft was not determined during removal of the acft from…NTSB ATL84FA282Accident · Serious injuriesField investigationFinal reportPiper PA-31-325 · Lynchburg, VAShortly after takeoff the plt reported to the tower that the left eng had failed. The prop was feathered and a left turn to downwind initiated. In the turn the right eng failed and the acft flew into trees in a residential area about 1 mile from the arpt. No…NTSB MIA84FA251Accident · 1 fatalField investigationFinal reportCessna 402C · Naples, FLShortly after takeoff, both engs lost power & a wheels up landing was made in an open field. The acft was destroyed by impact & fire. An investigation revealed that the acft had been refuel with jet-a fuel rather than 100 low lead avgas. The lineman had…NTSB LAX84LA474Accident · No injuriesLimited investigationFinal reportGrumman 164A · Goodyear, AZPlt reported pwr loss occurred during night aerial application. Acft nosed over during forced landing in crop field. Investigation failed to reveal any evidence of a mechanical failure/malfunction. Engine was test run to extent permitted by damage and no…NTSB NYC84LA301Accident · No injuriesLimited investigationFinal reportCessna 152II · Washington, PAFuel exhaustion occurred 3.3 hrs into flt. Plt stated tanks appeared to be full on preflight but acft records showed 0.6 hrs flown on previous flight and acft not subsequently refueled. Aprx 1.5 gals found in tanks on post-mishap inspection.NTSB CHI84LA377Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Olney, ILThe a/c was flown in an airshow by the owner. After he landed the acft was shut down and refueled. The refueling and the preflight were done rapidly to allow the owners son, a student plt, to leave the airport ahead of the crowd. About 3 minutes after takeoff…NTSB CHI84LA380Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Pontiac, MIDuring a takeoff climb at 400 ft AGL the eng lost pwr. The plt stated that he failed to switch fuel tanks. The right fuel tank was found empty.NTSB MKC84LU008Accident · Serious injuriesFinal reportEipper Quicksilver MX · North Platte, NEThe ultralight operator said he turned off the selector valve after a previous landing. During a later takeoff, he failed to use a checklist and did not reset the selector. The engine quit at about 30 ft AGL. Ground witnesses heard theengine sputter and…NTSB MKC84LA267Accident · No injuriesLimited investigationFinal reportCessna 150L · Marshall, MOThe acft engine lost power while descending after 1 hr of flt. During the ensueing forced lndg the plt said he changed his selection of landing site because of an auto on the selected site (a highway). The acft was landed beside the road &a collision with a…NTSB MIA84LA245Accident · Serious injuriesLimited investigationFinal reportChampion 7FC · Fort Drum, FLThe acft collided with a power line and the ground after a loss of power during takeoff. The plt was not certificated. The passenger said that the plt attributed the power loss to water in the fuel. The acft was being operated on automobile fuel. Attempts to…NTSB LAX84LA477Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Byron, CADuring takeoff, the eng lost power as the acft was climbing between 400 & 600 ft. subsequently, the right gear collapsed when the acft was landed on rolling terrain. The plt estimated there was about 2 gal of fuel on board.NTSB FTW84LA377Accident · No injuriesLimited investigationFinal reportCessna 177B · Texas City, TXAccording to the plt, during the pre-flt inspection the fuel tanks were checked by dipping his fingers into the tanks to determine how much fuel remained. Neither tank was full but the plt estimated that sufficient fuel remained for the flt. Above the fuel…NTSB ATL84FLT13Accident · Serious injuriesFinal reportPiper PA-22 · Nashville, TNThe engine quit on final apch to the arpt as a result of fuel starvation. Sixteen gallons of fuel remained in the right fuel tank, but the left tank was selected. No fuel was found in the left tank. The acft collided with powerlines during the forced landing…NTSB ANC84LA150Accident · No injuriesLimited investigationFinal reportMaule M-6 · Kiana, AKThe acft made a forced landing in the kobuk sand dunes after the engine quit during cruise flt. The plt reported that the engine quit, sputtered once, picked up RPM and then quit completely. The prop windmilled until ground contact. In attempting to restart,…