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 NYC87LA065Accident · No injuriesLimited investigationFinal reportBeech 95-A55 · Babylon, NYThe Beech baron had been cruising at altitude for approximately 2 hours when it started a descent with the OAT well below freezing. During the descent the pilot attempted to add power and there was no response. The pilot turned on the boost pumps to high and…NTSB CHI87DEC01Accident · Serious injuriesFinal reportCessna 150 · Troy, MIOutside air temperature was approximately 5 degress f when the aircraft on initial climb experienced a total power loss. The pilot lowered the nose and attempted to make a turn to return to the runway. The aircraft did complete approximately 180 to 190…NTSB ATL87FA064Accident · 2 fatalField investigationFinal reportCessna 310P · Memphis, TNThe plt reported an engine problem inside the outer marker to runway 31. The acft impacted the ground in a nose low attitude. The wreckage examination failed to disclose any system malfunction or failure. The acft was destroyed by impact forces, and a post…NTSB MIA87LA077Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Key West, FLThe plt failed to calculate fuel consumption for the intended route of flt prior to takeoff. Aprx 55 minutes into the flt the eng quit due to fuel exhaustion. The acft was then ditched in the gulf of Mexico.NTSB MIA87LA075Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Ft.Lauderdale, FLThe plt repositioned the fuel selector from the left tip tank to the right main tank when the flt entered the traffic pattern. The eng then quit & a forced landing was made in an open field. Upon touchdown the left & right main landing gear were pushed…NTSB MIA87FA074Accident · 2 fatalField investigationFinal reportCessna 150L · Naranjito, PRThe pilot and passenger were reported to be on a personal flight during their lunch hour. They departed from isla grande airport and proceeded to a dirt airstrip at Naranjito, PR. At Naranjito, witnesses saw the airplane go into a low pass over the dirt…NTSB FTW87FA045Accident · No injuriesField investigationFinal reportBeech 65-80 · Brownsville, TXCommercial pilot departed Brownsville, TX (bro) on special VFR flight plan. During initial climb, at approximately 300 ft AGL both engines quit due to fuel starvation. Forced landing was made to unimproved field. Aircraft sustained substantial damage. Pilot…NTSB ATL87LA061Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Albany, GAPlt deptd bowling green with a listed 5.0 hrs fuel on bd. After 3 hr 35 min he arrived over dest after exhausting fuel in the rt tank abt 30 min prior. He stated that the other tank was abt 1/2 full at the time. 15 min after rt tank exhaustion the plt req his…NTSB MIA87LA071Accident · No injuriesLimited investigationFinal reportCessna 182 · Ft.Lauderdale, FLThe acft collided with a powerline, trees & a truck after sustaining a complete power loss right after take-off. The acft was being ferried to be sold & had not flown for about two months. During the pre-flt inspection, the plt stated that he drained a…NTSB LAX87FA084Accident · 1 fatalField investigationFinal reportCessna T210M · Pacoima, CADuring initial climb after takeoff the aircraft experienced a complete loss of power. The pilot attempted to return to the airport and collided with a large warehouse. The airframe was totally consumed in the post crash fire. Examination of the engine…NTSB BFO87LA014Accident · No injuriesLimited investigationFinal reportCessna 150L · Ellicott City, MDApproximately 30 minutes after the pilot departed hayes field, columbia, Maryland, the pilot elected to return to the field. After entering downwind the engine ceased to continue producing power and the pilot was forced to make an emergency landing. During…NTSB LAX87LA079Accident · No injuriesLimited investigationFinal reportIntermountain Mfg. Callair A-9 · Fremont, CADuring a towing operation, just after lift-off the aircraft lost engine power at approximately 75 feet AGL. The glider released and landed without incident. The aircraft continued straight ahead, ran into a fence and came to rest in a plowed field. The fuel…NTSB NYC87LA057Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Marston Mills, MAThe flight was on an aerial photography mission but due to the heavy cloud cover, the aircraft returned to departure airport. The engine quit before reaching the runway and the aircraft was substantially damaged when it collided with terrain. Examination of…NTSB ATL87LA058Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Tuskegee, ALDuring a touch and go attempt, the pilot experiended an engine failure shortly after liftoff. The pilot safely landed on the runway, but did not have sufficient runway to stop the aircraft before running off the departure end of 31. The aircraft nosed over…NTSB MIA87FA069Accident · 1 fatalField investigationFinal reportCessna T210F · Tallahassee, FLPlt/owner was informed by mechanics that the acft fuel tanks had water contamination on two occurrences prior to test flights. The plt reported he ahd had water contamination and believed the fuel caps were leaking. New caps were ordered to be installed at…NTSB MKC87FA037Accident · 1 fatalField investigationFinal reportCessna T210N · Sherwood, ARThe PIC dptd morristown with 600# of cargo as part of a rnd trip to mcalester, okla. Headwinds at alt were avg 45 KTS. The PIC had asked for 60 gal before the departure but rcvd 59.1. Aft several hrs in cruise flt, the PIC notified memphis cntr ctrlr that a…NTSB LAX87LA074Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Wickenburg, AZDuring a pleasure cross-country flight, the engine quit approximately 2 miles west of the Wickenburg airport and the pilot made a forced landing off the arpt in a field. Examination of the aircraft revealed that the fuel selector was positioned to the right…NTSB FTW87LA044Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Lufkin, TXA private pilot substantially damaged his aircraft while attempting an emergency landing following a engine failure due to fuel exhaustion in the right main tank. The pilot switched to a full tank but failed to use the fuel boost pump during the attempted…NTSB DEN87LA040Accident · No injuriesLimited investigationFinal reportCessna T210N · Pueblo, COPlt and two pax departed limon, CO, at 1000 for return trip to center, CO. At 1030 plt switched to the right fuel tank, ten min later eng lost power and plt made forced landing west of Pueblo, CO. Plt claimed right fuel gauge was faulty. Plt later said he…NTSB ATL87LA055Accident · Minor injuriesLimited investigationFinal reportCessna 414 · Gallipolis, OHThe flight was established in the traffic pattern when the pilot experienced a dual engine failure. The pilot attempted to restart the engines but failed. The pilot also failed to feather the propellers which created a aerodynamic condition which allowed the…NTSB NYC87LA052Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-D · Broadalbin, NYThe pilot of a Taylorcraft BC-12D experienced a loss of power while cruising. He selected a field for a landing, however he was short and struck a tree on final. The aircraft received substantial damage and the pilot and passenger received serious injuries.…NTSB SEA87LA042Accident · No injuriesLimited investigationFinal reportCessna 150L · Lebanon, ORA power loss occurred during takeoff at about 100 feet AGL due to fuel exhaustion. A turn to the left was made so that a landing could be made on a field. During landing roll the aircraft's wing struck two trees.NTSB NYC87LA056Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Leominster, MAThe Piper PA-28-181 departed on a cross country flight with full tanks (48 gal) according to the pilot. Enroute the pilot experienced a power loss at night after flying for 3.9 hours. The pilot landed in a residential area and struck a house on landing roll.…NTSB FTW87LA038Accident · No injuriesLimited investigationFinal reportCessna 150 · Loreauville, LAA private pilot substantially damaged his aircraft while attempting a landing in a field following a engine failure due to water contamination in the fuel system.NTSB ATL87DEG02Accident · No injuriesFinal reportCessna 150H · Harrison, OHThe engine quit after takeoff at about 200 ft AGL. A ldg was made in a plowed field where the acft flipped over inverted. The CFI PIC reported that, prior to takeoff, he had calculated there was adequate fuel on board for the flt; his calculations were based…NTSB FTW87FA037Accident · 1 fatalField investigationFinal reportCessna 150L · Altus, OKThe pilot was circling about 40-50 feet above the ground at a slow rate of airspeed while searching for a lost dog. He was using 10 degrees of flaps and most probably operating at a reduced power setting. Carburetor icing conditions were present and…NTSB ATL87LA049Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Mobile, ALThe plt had suspected a hydraulic problem prior to departure when hydraulic fluid was found on the hangar floor. The acft was flown to a nearby arpt for repairs. The acft then departed and aprx 1 hr into the flt a heater problem was experienced. The plt…NTSB NYC87LA050Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Old Bridge, NJThe plt took off fm the marlboro arpt & flew to 2 other arpts before lndg at the miller arpt at burgettstown, PA, where the eng was shut down. He had difficulty in starting the eng & remained on the gnd about 1 hr. The plt told an aviation safety inspector…NTSB FTW87LA033Accident · No injuriesLimited investigationFinal reportCessna 150M · Cresson, TXAfter about 45 min of flt time, the instructor (CFI) & student plt entered the traffic pattern to practice touch-&-go landings. As they were taking off from the 1st touch-&-go, the eng lost power. Subsequently, they made a forced landing in an open area near…NTSB MIA87LA051Accident · No injuriesLimited investigationFinal reportCessna 150L · Homestead, FLThe plt experienced a slow deceleration of eng RPM followed by a total loss of power. The eng could not be restarted and a forced landing was made. Post accident exam of the eng, eng accessories, and airframe fuel system revealed no evidence to indicate…NTSB LAX87LA064Accident · No injuriesLimited investigationFinal reportCessna P210N · Chandler, AZWhile the plt was receiving vectors for arrival at Chandler, AZ, the eng lost power. Subsequently, the plt made an emergency landing about 1 mi north of the arpt. He rprtd that he had filled the fuel tanks at Chandler & had flown to durango, co on 12/5/86. On…NTSB MIA87FA048Accident · Serious injuriesField investigationFinal reportCessna 182P · St. Cloud, FLThe private pilot stated that prior to takeoff she did not check the fuel supply, and initiated an IFR flight. About 20 minutes into the flight the engine failed at 5000 ft MSL. During the subsequent forced landing attempt the aircraft struck a fence and a…NTSB MKC87FA030Accident · Serious injuriesField investigationFinal reportPiper PA-28-151 · Grain Valley, MOThe pilot stated, after takeoff the engine sputtered and began losing power during initial climb. According to the pilot, he tried to land on a highway but there were numerous vehicles in transit and he decided to attempt an off-airport landing. On initial…NTSB CHI87LA042Accident · No injuriesLimited investigationFinal reportCessna 152II · Anoka, MNThe acft was on the fifth touch & go of the student plt training flt when a loss of power occurred at 100-200 ft AGL during climbout. The CFI had to land the acft in unsuitable terrain which resulted in substantial damage to the acft. Examination of eng and…NTSB SEA87MA035Accident · 6 fatalMajor investigationFinal reportCessna TU206G · Jean, NVWhile en route at night on an IFR flt plan, the acft ran out of fuel. Subsequently, the plt was provided vectors toward a hiway for a forced lndg. However, before reaching the area of the hiway, the acft crashed on rising terrain at an elev of about 4000 ft.…NTSB NYC87LA046Accident · No injuriesLimited investigationFinal reportBeech B23 · Trenton, METhe plt rprtd that after takeoff, the acft had climbed to 600 ft & was climbing at 300 ft/min, when the eng 'started to labor,' then quit running. He used carburetor heat & 'primed through power reduction,' but the eng would not restart. During an emerg lndg…NTSB MIA87LA044Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Apollo Beach, FLWhile in cruise flt at 600 feet a sudden loss of engine power occurred. Attempts to restart the engine were unsuccessful and the aircraft was ditched. Post accident examination of the engine revealed no evidence of mechanical failure or malfunction. The icing…NTSB FTW87LA027Accident · No injuriesLimited investigationFinal reportCessna 150K · Georgetown, TXThe plt experienced a loss of pwr due to fuel exhaustion during the x-country flt. The plt elected to divert to Georgetown, TX, during the flt to refuel. The engine quit aprx 4 to 6 miles north of the aprt. The plt attempted to make the arpt with inadequate…NTSB FTW87LA026Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Durant, OKThe student plt noted a partial power loss while practicing multiple touch-and-go landings. She stated that after she had turned on a downwind, she heard 'a different sound' from the eng and it appeared to lose power. During an apch for an off arpt landing,…NTSB MKC87LA029Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Dumas, ARThe plt stated that he was operating VFR out of ft. lauderdale, Florida, when he encountered IMC weather close to valdosta, Georgia. At this point, the plt further stated, he air-filed an IFR flight plan but elected not to land and refuel. According to ATC…NTSB ATL87LA033Accident · Minor injuriesLimited investigationFinal reportMooney M20G · Painesvile, OHThe plt reported a complete engine failure while conducting a pleasure flt. Following the failure, the plt attempted to restart the engine, but failed. At this point the acft was about two miles south of casement arpt. The reported winds were gusting to 25…NTSB FTW87LA023Accident · 2 fatalLimited investigationFinal reportNorth American Navion A · Springtown, TXThe pilot told rescue personnel that he had taken off with empty tanks selected. The engine quit, and the aircraft impacted the ground before he could restart. Initial reports of serious injury only, but both occupants expired two weeks later.NTSB ATL87LA031Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Waynesboro, GAThe plt called apch control & asked for vectors to the nearest field & said he was low on fuel. Vectors were provided but the eng lost power & the acft was damaged during a landing in a wooded area. An investigation revealed the acft had been flying for aprx…NTSB LAX87MA052Accident · 4 fatalMajor investigationFinal reportBeech A36TC · Bakersfield, CAOn an instructional flt, the student plt & instructor (CFI) made an ILS low apch to rwy 30R. Drg a go-arnd (missed apch)a twr ctlr obsvd a 'light trace of smoke' emanating fm the eng exhaust. Shortly thereafter, the acft 'banked hard to the left and appeared…NTSB MKC87LA025Accident · No injuriesLimited investigationFinal reportCessna 150 · Nevada, MOThe PIC preflighted his acft prior to departure, but the preflight did not include refueling the acft which contained about 8 gallons of fuel. Normally the 8 gallons of fuel would have been sufficient to reach the destination arpt which was 21 statute miles…NTSB MKC87LA023Accident · No injuriesLimited investigationFinal reportCessna 150J · Colby, KSThe pilot stated that he departed his private airstrip, low on fuel, intending to refuel at the next stop where he was to conduct a business transaction. Unable to secure fuel there, and showing one quarter of a tank on each fuel gauge, he departed for Colby…NTSB LAX87LA049Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Fresno, CADuring a solo instructional cross-country flight the engine quit while on the base leg at the Fresno airport. The pilot did not feel that he could make the runway due to an extended downwind and low altitude. The pilot decided to try and land in a plowed…NTSB BFO87DHD02Accident · No injuriesFinal reportHughes 369D · Newark, DEThe acft was being flown on a maintenance check flt. As the plt was returning to land, the eng lost power from fuel exhaustion. During an autorotative landing, the main rotor blades & tail boom were extensively damaged. The plt rprtd the fuel quantity gage…NTSB LAX87LA047Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Merced, CADuring the return leg of a round robin cross country, the aircraft experienced a loss of power approximately 10 miles from the destination airport. About 15 minutes earlier, the pilot had deliberately run the left fuel tank dry. At that time, the right tank…NTSB CHI87LA035Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Evansville, INAccording to the plt, just after starting a descent from 300O feet, while inbound to Evansville dress regional airport(evv), the engine 'suddenly and without warning quit.' The plt stated that after deciding he could not make evv, he turned left and set up a…