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 SEA89LA026Accident · No injuriesLimited investigationFinal reportCessna 152 · Medford, ORThe pilot departed the airport without obtaining fuel. Approximately 15 gallons of fuel was on board which would make the fuel tanks about one-half full. At the time of the accident the aircraft had been airborne for over 2 hours and 10 minutes. Dark visual…NTSB NYC89LA050Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Lyme, CTImproper planning; the student pilot became lost and ran out of fuel. During the landing he misjudged distance, altitude and airspeed and overran the field colliding with trees.NTSB DEN89LA042Accident · No injuriesLimited investigationFinal reportCessna 152 · Greeley, COThe plt was flying a cross-country flight. She said that 3 miles from her destination, the engine quit when the plane ran out of fuel. A landing on an ice covered asphalt road was performed. During roll out, the left main gear went off the road and the left…NTSB NYC89LA049Accident · No injuriesLimited investigationFinal reportCessna 150L · Greenwich, CTTrees during an off airport landing after the aircraft expererienced a power loss fue to fuel starvation.NTSB NYC89LA047Accident · No injuriesLimited investigationFinal reportMooney M20J · New Alexandria, PALoss of control experience during landing rollout after an off airport landing was made due to a power loss caused by contaminated fuel. Water had been removed prior to departure.NTSB ATL89FA054Accident · 2 fatalField investigationFinal reportAero Commander 720 · Alcoa, TNAfter encountering icing conditions in flight and experiencing problems maintaining altitudes and headings, the pilot elected to divert from his planned destination of dayton, oh to knoxville, TN. While on final approach after descending 1300 ft below minimum…NTSB NYC89LA044Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Laconia, NHAircraft striking the road sign after the aircraft experienced a double power loss due to mismanagement of the fuel system by the pilot.NTSB LAX89LA060Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Carlsbad, CADuring the initial climb after takeoff, the engine lost power. Subsequently, the airplane collided with terrain as the plt was completing an emergency landing. An examination of the fuel tanks disclosed no evidence of fuel in the left tank. However, aprx 9…NTSB NYC89LA037Accident · No injuriesLimited investigationFinal reportCessna 172 · Block Island, RIThe pilot of the Cessna 182 was on downwind when he stated that he pulled the carburetor heat on and then pulled the power back to 1500 RPM. Within a few seconds the engine quit and the pilot informed the tower. The aircraft landed about 500 feet short of the…NTSB MKC89LA034Accident · No injuriesLimited investigationFinal reportCessna 182 · Garnett, KSHaving just made a parachutist's drop, during a sky diving operation, the private pilot spiraled down from altitude to land, but had to extend his pattern to allow a departing acft to leave. During a long final approach, the engine failed and an emergency…NTSB FTW89LA029Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Texarkana, TXNTSB FTW89LA027Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Plano, TXFuel exhaustion which resulted from the pilot's inadequate fuel consumption calculations and his failure to utilize numerous suitable sources of fuel along his route of flight.NTSB ATL89LA049Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Griffin, GAAfter a preflight and runup the pilot made a takeoff and remained in closed traffic for landing practice. On downwind, opposite the desired point of touchdown, he retarded power, applied carb heat and slowed the airplane. Turning base, the acft lost power.…NTSB NYC89LA040Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Erwinna, PAOff airport landing in unsuitable terrain due to a power loss caused by carburetor icing.NTSB CHI89LA028Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Marquette, MIAfter encountering unforecast adverse wx at his intended destn, the plt circled the area a couple of times, then diverted to Marquette, MI. However, before reaching the alternate arpt, the eng lost power due to fuel exhaustion. Subsequently, the acft collided…NTSB NYC89LA038Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Berlin, NJOff airport landing in unsuitable terrain following a power loss due to fuel exhaustion in the selected tank with useable fuel in the other tank.NTSB NYC89LA035Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Palmyra, NYOff airport landing in a canal following a power loss caused by fuel exhaustion due to miscalculated fuel burn by the pilot.NTSB MKC89LA026Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Salisbury, MOThe pilot said shortly after takeoff the engine lost power. He attempted to land on a plowed field, and after rolling about fifty yards on the rough, soft terrain, the aircraft nosed over. Post accident investigation revealed the engine lost power due to fuel…NTSB MIA89LA041Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Ocala, FLThe plt stated that while switching to the right fuel tank, the eng quit and he was unable to restart it. While attempting a forced landing in a field, the gear collapsed resulting in damage to the wings and flaps. Over 40 gallons of fuel were found in the…NTSB MIA89LA038Accident · No injuriesLimited investigationFinal reportRyan Navion B · Vero Beach, FLThe plt stated that drg flt, the eng lost power & he was unable to restart it. Drg a forced landing in a field, the acft struck three cows that were in a ravine & moved in front of the acft as it was apchg to land. A post acdnt exam of the acft revealed there…NTSB ATL89LA039Accident · No injuriesLimited investigationFinal reportCessna 172 · Pikeville, KYThe pilot had flown about 3.7 hours and was about 2 miles from his destination airport when the engine stopped and he was forced to land in a swamp. The pilot had topped off the acft so that it contained 42 gallons of fuel (38 gallons of usable fuel). The…NTSB SEA89LA019Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Idaho Falls, IDPlt reportedly stole acft and departed about midnight in snowstorm. For 3 hours he buzzed local residences vehicles until fuel exhaustion. Forced lndg made in rough field. Investigation revealed plt had long history of mental illness and had falsified medical…NTSB MIA89LA034Accident · No injuriesLimited investigationFinal reportBeech V35B · Brandon, FLThe plt rprtd that he diverted to an alternate arpt due to fog at his destn. While en route at aprx 2000 ft MSL, the eng lost power. The plt said he repositioned the fuel selector & turned on the boost pump, but his attempts to restart the eng were…NTSB DEN89LA035Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Chinook, MTThe student plt was flying cross country, solo, to take a private plt checkride. He said he became lost and flew until the fuel was exhausted. He selected a snow covered field and landed. At touchdown, the nose gear dug in and the acft nosed over.NTSB DEN89LA033Accident · Serious injuriesLimited investigationFinal reportCessna 310H · Carlsbad, NMOn an IFR business/training flt, the ATP plt made an unscheduled fuel stop. On a practice ILS apch to rwy 3, circling to land rwy 21, the acft yawed hard rt and the plt lost directional control. The plt said it sounded and felt like the rt engine had lost…NTSB DEN89LA030Accident · No injuriesLimited investigationFinal reportCessna 172 · Riverton, WYThe instructor reported closing the throttle to simulate an engine failure, during a training flight. The student added carburetor heat first, instead of establishing a proper glide. The instructor removed carburetor heat and advised the student of the…NTSB LAX89LA047Accident · No injuriesLimited investigationFinal reportBeech H35 · Corning, CAThe flt originated at hayward, CA, with a stop at san carlos, CA and Corning, CA. The plt's destination was the red bluff arpt (rbl). The plt reported that when he departed hayward both main fuel tanks were full. He flew to san carlos where he picked up three…NTSB LAX89LA046Accident · No injuriesLimited investigationFinal reportUnivair Taylorcraft BC12-D · Kawaihae, HIDuring a pleasure flight, the pilot intentionally shut down the engine and was flying the airplane similar to a sailplane. To restart the engine, he would dive the airplane to attain enough speed to windmill the prop. Just before the accident, he allowed the…NTSB MKC89LA022Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Mena, AROn left crosswind leg, during initial climb, the aircraft experienced a total loss of power. The acft had reached about 800 feet AGL and was about 1 1/2 miles from the departure end of the runway. An emergency ldg was attempted which resulted in substantial…NTSB FTW89LA018Accident · No injuriesLimited investigationFinal reportCessna 182B · El Paso, TXThe pilot said he thought he had enough fuel to keep the airplane airborne for 6 hours but the left tank ran dry in 4.0 hours and the right tank went dry at 4.1 hours. The landing was on a ranch airport but was not on a runway and the forced landing was a…NTSB FTW89LA017Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Gladewater, TXThe pilot was returning home from a personal night cross-country flight when the engine stopped producing power. The pilot attempted to glide to the home airport but was unable and had to accept a forced landing on a railroad track. During the final approach,…NTSB ATL89LA028Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Sheperdsville, KYThe pilot had flown a Cessna 172 to tampa to pick up a Cessna T210M for a flight to louisville, KY. The 210 had been previously flown to tampa from ft. myers by the owner. After a preflight in which the pilot said he visually verified that the fuel tanks were…NTSB ATL89FA025Accident · Serious injuriesField investigationFinal reportPiper PA-38-112 · Mc Donough, GAShortly after takeoff the flight experienced a complete engine failure. The pilot attempted a forced landing to an open field but crashed short. The investigation disclosed that the pilot was not certificated as an airman and he did not have the permission of…NTSB LAX89FA030Accident · 1 fatalField investigationFinal reportCessna 421A · Cabazon, CAThe pilot's poor decision and misjudgement of distance. The separation of the cylinder, failure of the propeller to feather, and impact with wires and a residence were factors in the accident.NTSB LAX89LA029Accident · No injuriesLimited investigationFinal reportBeech 35-B33 · Saint Johns, AZJust after takeoff, the pilot noted cylinder head temp and manifold pressure above red line and a loss of engine power. Mixture had been leaned for tkof. The engine quit when the plt closed the turbocharger wastegate. A forced landing was made upslope on…NTSB LAX89DUG01Accident · Serious injuriesFinal reportKlob-Gordon TWIN-STAR · Lake Elsinore, CADuring a pleasure flight, the pilot reduced the engine power to talk to the passenger. When the pilot applied power, the engine did not respond. The airplane was glided to a nearby airport; however, the airplane landed short. The pilot verbally reported there…NTSB ATL89FA019Accident · Serious injuriesField investigationFinal reportAeronca 7AC · Austell, GAPIC was obtaining bfr; stalls & flt at min control airspeed were completed. PIC began descent from 2500 MSL to his pvt strip for simulated engine out landing. In a subsequent interview PIC said carb heat was applied & removed after 30 sec. In his rpt he said…NTSB NYC89LA019Accident · Minor injuriesLimited investigationFinal reportBeech 60 · Norwood, MAThe pilot had just climbed to 2500 feet when the right engine started to sputter. When he placed the fuel selector in crossfeed, both engines quit. The pilot elected to land in a field leading to substantial damage to the nose, wings, and tail section of the…NTSB NYC89LA017Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Trumbauersville, PAAn off airport landing in which the aircraft struck trees and a swing set, following a power loss caused by the failure of the pilot to determine that the fuel selector was in the off position and to turn it on prior to the power loss.NTSB FTW89LA008Accident · Serious injuriesLimited investigationFinal reportCessna 172 · San Antonio, TXThe airplane had been flown for 2.2 hours since refueling when this pilot started his flight. This pilot flew the airplane for 2.5 hours and the engine quit. During the forced landing, the airplane impacted a power pole and power lines, and then the terrain.…NTSB CHI89LA015Accident · No injuriesLimited investigationFinal reportCessna 175A · Wyoming, MNNTSB MIA89LA013Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Tupelo, MSThe operator had applied for an on-demand/air taxi cert, but had not obtained approval. After lvl-off on a flt to carry canceled checks, the plt elected to use the remaining fuel fm the inbd tanks. He stated that soon thereafter, the left eng bgn running…NTSB DEN89DTM01Accident · 1 fatalFinal reportMickelson Mark V · Ogden, UTTotal loss of engine power for reasons undetermined which resulted in a forced landing. The pilot inadvertently stalled the aircraft during the forced landing, and that is considered a factor in the accident.NTSB NYC89LA012Accident · Serious injuriesLimited investigationFinal reportCessna P210 · Collegeville, PAThe plt rprtd that as he was arriving to land, he entered left traffic & moved the fuel selector to the fullest tank. Shortly after moving the fuel selector, the eng lost power as though it was fuel starved. He said he operated the fuel boost pump & switched…NTSB NYC89FA013Accident · Serious injuriesField investigationFinal reportBell 206L-1 · Wallingford, CTThe acft lost power and crashed in a tractor trailer parking lot, destroying the helicopter and causing serious injuries to the pilot and one passenger. The investigation revealed an improper fuel flow switch, which had no check valve protection installed on…NTSB FTW89FA007Accident · No injuriesField investigationFinal reportPiper PA-31-350 · Edinburg, TXAcft experienced a double eng failure. Plt stated that immediately after the left eng failed, in climb to cruise, the acft rolled left, the stall warning activated, and the acft entered a left spiral. The rt eng failed during the two-turn spiral. Plt's…NTSB CHI89LA010Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Fairview Hts., ILFuel exhaustion due inaccurate fuel consumption calculations.NTSB SEA89LA012Accident · Serious injuriesLimited investigationFinal reportLaycock Baby Great Lakes · Graham, WAEng lost pwr while in cruise on local flt. Plt attempted to return to field but contacted trees during emerg descent to forced lndg. Investigation revealed presence of water in fuel system. Fuel sediment bowl was automotive type with aviation drain installed.…NTSB MKC89LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Cedar Rapids, IAWhile conducting a part 135 air taxi operation, the pilot said his engine began running rough about 7 miles from his destination apt. Emergency procedures were initiated and a call to the control tower declaring an emergency was made. Unable to reach the apt,…NTSB MIA89LA011Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Tampa, FLThe plt stated the acft was topped with 30 gals of auto fuel prior to departing for the open house at mcdill afb. The flt to mcdill was normal. Before departure, about 1/2 inch of water was drained from the fuel system during preflt inspection. At about 300…