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 NYC87LA179Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Tewksbury, MAThe pilot switched the fuel selector from what he thought was the left tank to both while on final approach. He then decided to make a go-around during the flare because he felt his a/s was to fast. The engine quit at 40 ft AGL during the go-around. He was…NTSB ATL87FA168Accident · 4 fatalField investigationFinal reportCessna 205C · Bowling Green, KYShortly after takeoff from Bowling Green, the pilot reported a problem. He did not report the details of the problem, but witnesses heard the aircraft backfiring as it descended. The aircraft had taken on fuel at Bowling Green. The investigation failed to…NTSB LAX87LA236Accident · No injuriesLimited investigationFinal reportCessna T210L · Merced, CADuring a cross country flight, the engine lost power and quit aprx 4 miles from the airport. The pilot was unable to reach the runway and made a forced landing aprx 3 miles short of the runway. During the landing roll the aircraft collided with a fence and…NTSB LAX87FA234Accident · 1 fatalField investigationFinal reportCessna T210N · Huntington Bch, CADuring a pleasure flight, the pilot informed an air traffic controller that he was running out of fuel and turning to an airport. During the descent the airplane collided with a tree and terrain. There were no reported mechanical failures or malfunctions with…NTSB ANC87LA079Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Kvichak Bay, AKThe pilot stated that during the takeoff the aircraft's engine lost power; the aircraft stalled and crashed on the gravel bar. The pilot also stated he did not know how much fuel was on board the aircraft and he did not remember the last time he fueled the…NTSB MIA87LA182Accident · No injuriesLimited investigationFinal reportCessna 172G · Caribbean SeaThe plt became disoriented while flying from saint lucia to saint vincent after he incorrectly selected the wrong station when navigating using the adf. He contacted ATC who advised him to climb & was advised that the flt was aprx 20 miles west of saint…NTSB LAX87LA233Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Porterville, CAA Cessna 150H collided with terrain after a loss of power. The pilot stated his tanks were indicating 1/4 when the engine quit. He further stated that he 'misjudged landing speed and elevation' and when he turned to avoid power lines, the aircraft stalled.…NTSB FTW87FA139Accident · 2 fatalField investigationFinal reportBeech V35A · El Paso, TXAcft experienced a complete pwr loss shortly after takeoff and subsequently struck a house during the ensuing forced landing. No evidence of mechanical failure or malfunction was found during the investigation. Evidence did indicate that one tank was either…NTSB ATL87DKG04Accident · No injuriesFinal reportBell TH-13T · Melvin, ALThe plt rprtd that after lndg to reload with herbicide, he got out of the helicopter to check the fuel in the tanks. After a visual inspn, he believed he had 'an adequate amount' of fuel to fly about 1/4 mi to the area to be sprayed, apply the chemical &…NTSB DEN87LA146Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Grafton, NDThe plt was positioning the helicopter for an aerial application project. Before taking off, he checked the fuel quantity indicator & estimated there was 30 min of fuel on board. The proposed flt was estimated to take 10 min. During flt, the eng lost power &…NTSB MKC87LA122Accident · No injuriesLimited investigationFinal reportCessna 140 · Ankeny, IAWhile practicing take offs and landings, CFI and student experienced engine failure shortly after take off. An emergency landing was initiated, and during forced landing attempt the aircraft was substantially damaged. The CFI stated the engine quit due to…NTSB FTW87LA136Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Brownwood, TXThe engine failed during cruise flight due to fuel exhaustion. During the forced landing to a pasture the right horizontal stabilizer hit a tree and a limb became jammed between the stabilizer and the elevator jamming it in the full nose down position. The…NTSB LAX87LA227Accident · No injuriesLimited investigationFinal reportCessna 150L · Huelo, HIDuring a local pleasure sightseeing flight, the engine lost power and eventually quit. The plt initiated an emergency landing in a pineapple field where the acft collided with the terrain and nosed over. The acft was found to have aprx half a gallon of fuel…NTSB FTW87FA134Accident · No injuriesField investigationFinal reportRockwell Commander 112 · Ft.Worth, TXOn 6/6/87 a Rockwell commander 112, N1153J, impacted the terrain near meacham field, forth worth, Texas while on a photography flight. The pilot had been cleared to land on runway 16L when the tower changed the runway assignment to 16R. The pilot added power…NTSB ATL87LA159Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Greer, SCEngine quit during descent for landing. PIC lnded in field, left wing struck tree and was separated from acft. PIC rpted no mechanical malfunctions. On post crash exam eng ran properly and right wing fuel quantity sys was operable. No fuel stains were seen on…NTSB CHI87LA138Accident · No injuriesLimited investigationFinal reportAeronca 11CC · Inver Grove Hts, MNAfter a loss of power, aircraft stalled. Although power was regained, aircraft crashed approx. 10 feet east of a grass strip adjacent to the seaplane base. Inspection revealed no mechanical malfunction or engine problem.NTSB ATL87LA155Accident · No injuriesLimited investigationFinal reportCessna 150H · Andalusia, ALThe CFI was giving instruction to a beginning student. During preflight he noted that the lt tank fuel gauge indicated 'full' while the rt tank gauge inidated '1/2 full '. After about 40 minutes of flying the engine began to run rough, during climbout after a…NTSB MIA87LA167Accident · No injuriesLimited investigationFinal reportNorth American Navion · Defuniak Spring, FLThe plt reported that after takeoff, at aprx 500 ft, the eng lost power. He then turned on the electric fuel pump in an attempt to restore it. Unable, he then elected to land the acft, during which, it collided with trees, fell to the ground & came to rest.…NTSB CHI87DEX06Accident · Minor injuriesFinal reportCessna 172E · Huntingburg, INWhile on a x-country flt, the acft's nav equip was not working properly & the plt became lost/disoriented. He requested a df steer, but had difficulty receiving transmissions on his receiver. He subsequently received assistance & vectors toward the…NTSB MIA87LA165Accident · No injuriesLimited investigationFinal reportCessna 210L · Tallahassee, FLThe eng quit aprx 6 miles from the arpt. During the landing roll following the forced landing the nose gear collapsed & the acft collided with trees. Imspection of the acft revealed that the fuel selector was positioned to the left tank which did not contain…NTSB FTW87FA129Accident · Serious injuriesField investigationFinal reportBeech B-60 · Wall, TXAcft was destroyed during an attempted off airport emergency landing following a dual eng failure while leveling off at crz flt. Plt stated that left eng, then right eng surged and quit as he was leveling off at 9000' MSL. At the time of the eng failures the…NTSB MKC87LA110Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Carbondale, KSThe PIC was moving his acft fm one airstrip to another in the LCL area. Wind cond's fm a nearby fss, recorded winds fm the southeast at 18 KTS, gusting to 25 KTS. The PIC rptd departing the sod airstrip to the southwest, and shortly aft establishing a climb,…NTSB NYC87LA154Accident · No injuriesLimited investigationFinal reportCessna 172 · New Haven, CTDrg a night flt from new bedford to bridgeport, the plt enctrd visibility problems & believed that fuel consumption was higher than normal. He obtained radar vectors to New Haven. After seeing the arpt, he flew over to establish the runway pattern. However,…NTSB FTW87LA132Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Port Aransas, TXThe engine lost power while on the downwind leg of the traffic pattern. The pilot made a 180 degree turn and attempted to reach the runway. Touchdown occurred about 15 feet short and the landing gear impacted a sandy embankment. The aircraft then slid to a…NTSB MKC87LA109Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Louis, MOThe pilot stated that he departed St. Louis downtown-parks airport (cps) on a round-robin flight with planned stops at st. clair memorial airport (K39), Missouri, and richland municipal airport (M034), Missouri. The return flight to cps included another stop…NTSB ATL87LA145Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Ozark, ALThe inst plt indicated that during airwork procedures practice in the LCL area, the right wing seemed to be heavy. He indicated that he switched the fuel selector from both to right tank. After about 20-30 minutes, they returned to the airport and entered…NTSB ATL87LA140Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Huntersville, NCThe plt reported that he closed the throttle to simulate an engine failure after takeoff from rwy 06, at about 400-500 ft AGL. He subsequently made a 180 degree turn back toward the arpt to practice a simulated forced ldg, and the acft sink rate increased to…NTSB MKC87LA104Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Wamego, KSThe PIC had been airborne in the LCL area to let parachute jumpers jump fm his acft. To lose alt quickly the PIC performed a prolonged slip. On the final app the eng quit and alt was insufficient to reach the rwy for lndg. The off arpt lndg was unsuccessful.…NTSB CHI87LA131Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Neillsville, WIA student & instructor (CFI) were on a dual x-country flt fm elroy to Neillsville & rtrn. The flt to Neillsville was uneventfull. After the acft was on the gnd aprx 20 min, hot starting procedures were used to start the eng for the rtrn flt. Eng runup &…NTSB LAX87DVG07Accident · No injuriesFinal reportGrumman G-164A · Lambertsville, CAThe pilot stated that shortly after takeoff the engine 'cut out' several times then quit completely. The pilot made an emergency landing on a plowed field and during the landing roll the aircraft nosed over. The accident was not reported for 4 days and during…NTSB DEN87LA120Accident · No injuriesLimited investigationFinal reportBell 47G3B2A · Brigham City, UTAn ag plt was ferrying a helicopter to another job in his local area. The plt, an ATP, had estimated that the helicopter had enough fuel for the flt. The helicopter's engine quit and an autorotation was performed, resulting in a hard landing. Less than one…NTSB ANC87LA065Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · North Pole, AKThe pilot stated that shortly after lifting off the water the engine quit; the aircraft crashed on the gravel bar. The pilot also stated that he ran out of fuel. The plts flt time was not reported or available.NTSB MIA87LA151Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Titusville, FLFlt experienced complete loss of power in both engines due to fuel exhaustion. While attempting a forced landing at an airport the aircraft touched down 200 feet short of the runway and then rolled up onto the runway. The aircraft was substantially damaged in…NTSB LAX87FA198Accident · No injuriesField investigationFinal reportMooney M20K · Long Beach, CAOn 4/28/87, after a flt from Long Beach to las vegas, the plt requested the left wing tank be svcd with 15 gal of fuel; no fuel was added to the rgt tank. Two days later, the plt took off on the return flt. Drg arrival at Long Beach, he was vectored for an…NTSB NYC87LA134Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Ellington, CTDuring an instructional flight, the instructor pilot simulated a forced landing at about 250 feet and 60 KIAS. The student pilot at this time entered an autorotation and the helicopter started to descend. Collective was pulled but this failed to stop the…NTSB BFO87LA033Accident · No injuriesLimited investigationFinal reportCessna 150G · Roanoke, VAWhile enroute from gaithersburg, MD, to blacksburg, VA, the plt decided to divert to Roanoke, VA, due to thunderstorms in the area. On x-wind leg to rwy 33 at Roanoke the eng started to run rough. Aft carb heat was applied it smoothed out but quit completely…NTSB ATL87LA126Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Pinehurst, NCThe pilot called approach control and reported he was out of fuel and didn't think he was going to make the airport. He had landed at an airport enroute but had not refueled. He stated that he started descending when he got within ten miles of the airport. He…NTSB NYC87LA130Accident · Serious injuriesLimited investigationFinal reportStinson 108 · Rumford Point, MEWhile circling a pond, the plt failed to switch fuel tanks and the engine lost power. He attempted to switch from the right to the left tank but was forced to set the acft down in a nearby field. The left wing, fuselage, landing gear, prop, and engine mounts…NTSB MIA87LA147Accident · No injuriesLimited investigationFinal reportPiper J-3 · Miami, FLThe owners rprtd the acft was stolen on 4/25/87. The non-certificated plt rprtd that he had taken the acft without permission. Drg flt, the eng lost power, & subsequently, the plt made a forced lndg in the everglades about 9 mi west of the tamiami arpt. He…NTSB FTW87FA102Accident · Serious injuriesField investigationFinal reportCessna T210L · Lufkin, TXThe pilot reduced power and was descending for a VFR straight-in approach when the engine quit. The pilot had the selector on the left tank with 4 to 5 gallons of fuel remaining in this tank. During the descent the fuel tank outlet line became unported…NTSB MKC87LA086Accident · No injuriesLimited investigationFinal reportCessna 150 · West Memphis, ARThe acft was flown 1.6 hrs on a previous flt since being topped off with fuel. At the end of 2 hrs and 11 mins, during the accident flt, the eng quit. The fuel tanks were found to be empty with no broken fuel lines. During the post accident exam, it was found…NTSB BFO87FA031Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Salisbury, MDOn a flt from hilton head, SC to woodstown, NJ, the plt enctrd headwinds & diverted to Salisbury, MD, a less distant arpt. Drg arrival at 1944, he was provided wx info concerning a low ceiling & visibility. At 1955, he was instructed to hold upon reaching a…NTSB MIA87LA139Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Melbourne, FLThe student pilot experienced an engine failure in flight and landed the aircraft in a pasture. He then restarted the engine and took off, after take off the engine failed two times and he restarted it. The engine failed the third time and he could not start…NTSB CHI87DET03Accident · Serious injuriesFinal reportJagger Tierra II · Columbia City, INShortly after takeoff at about 100 feet AGL the engine lost power. The aircraft stalled and impacted the ground in a plowed area adjacent to the runway. The owner/pilot stated that an unidentified substance almost totally blocked the fuel filter closest to…NTSB CHI87DEM06Accident · Serious injuriesFinal reportNavion A · Baldwin, MIAfter beginning a level off at aprx 6000 ft, the acft engine stopped. During the forced landing the acft crashed in a heavily wooded area aprx 1/2 mile west of the arpt. An examination of the wreckage revealed that both wing tanks were empty and the…NTSB MIA87LA137Accident · No injuriesLimited investigationFinal reportCessna 152 · Gainesville, FLThe plt elected to land the acft on a taxiway after the eng quit aprx 5 miles from the arpt. During the flare, the wing stalled, followed by a hard landing on the nose gear causing it to collapse. Post crash examination of the acft revealed that the eng quit…NTSB NYC87FA126Accident · 1 fatalField investigationFinal reportBeech 58P · Pleasantville, NYThe plt rept his auto-pilot was malfunctioning on the apch and he was having aileron problems. He rept a loss of pwr, got the eng started, and then rept a double pwr loss. Prior to disappearing from radar he rept that he was starting one engine. The acft…NTSB FTW87DRD04Accident · No injuriesFinal reportGrumman G-164 · Rayne, LAThe aircraft's engine lost power and stopped while maneuvering. The aircraft impacted a dirt bank and nosed over in soft dirt/mud during the forced landing. Water was found in the fuel system and water was also found in the fuel tank of another aircraft…NTSB DEN87LA097Accident · Minor injuriesLimited investigationFinal reportMclachlan Moni · Tooele, UTThe private plt was cruising the local area near his home in his homebuilt experimental moni. The newly installed engine began to run rough. This engine is not a traditional acft engine and was a two cycle, two cylinder engine manufactured in italy, with an…NTSB LAX87LA177Accident · No injuriesLimited investigationFinal reportCessna T303 · Santa Maria, CAA Cessna T303 collided w the LOC antenna aft a total loss of pwr in both engs while on final app to rwy 30. The plt indicated that the engs failed due to fuel exhaustion. The flt made 5 stops to pick-up and drop off cargo and is normally flown daily by…