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 SEA82DA035Accident · No injuriesFinal reportCessna 182P · Creswell, ORDuring preflight the pilot found water in the fuel system. After fuel drainings and sample checks were completed the pilot started the engine and initiated taxi for takeoff. During taxi and engine runup the engine stopped several times. After repeated fuel…NTSB ATL82FA065Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Taylorville, NCThe aircraft departed akron, NY at 1154 EST on a flight to charlotte,NC. Toward late afternoon, as the sun began to set, one of the passengers (the pilot's daughter), informed the pilot that the aircraft was getting low on fuel. He diverted toward an airport,…NTSB NYC82DFJ11Accident · No injuriesFinal reportHughes 500 · Little Valley, NYAbout 10 minutes after takeoff in heavy, wet, blowing snow, the engine lost power. At that time, the helicopter was at about 100 ft AGL. At the first indication of a power loss, the pilot initiated and completed an autorotative landing in an open field.…NTSB ATL82DA063Accident · Minor injuriesFinal reportSmith Mini · Brownsboro, ALThe pilot took off with a malfunctioning fuel quantity guage. Before takeoff, he visually checked the fuel and estimated that the tank was about 1/2 full. After returning from a local flight, the engine lost power during a turn to final approach for landing.…NTSB FTW82DA079Accident · No injuriesFinal reportCessna U206 · Noack, TXThe pilot stated that he was on a one hour flight for aerial survey to giddings, Texas and return. The right fuel tank ran dry and he switched to the left tank which indicated nearly 1/4 full. Approximately 20 minutes later, the engine stopped operating. A…NTSB LAX82FUJ29Accident · Minor injuriesFinal reportCessna 182C · Eloy, AZThe aircraft crashed near the end of a runway on a dark night. The pilot stated to the police that he had run out of fuel. The police found weapons, drugs, and liquor in the pilot's possession. An estimated 3 gallons of fuel was found in each tank. According…NTSB LAX82FA085Accident · 1 fatalField investigationFinal reportBeech BE-95-C55 · Huron, CAFollowing a business trip the pilot deplaned two passengers at a private airport and proceeded to takeoff to the north. Witnesses judged the takeoff run to be short followed by a steep bank and climb to the right. A maximum estimatedaltitude of 250 feet AGL…NTSB LAX82FUJ31Accident · Serious injuriesFinal reportRockwell Commander 114 · San Simon, AZAfter refueling at abilene the aircraft departed around noon on the second leg of a flight to repossess the aircraft. The pilot stated that he ran the engine at full rich with the fuel flow meter reading 18 gph. Using this figure the aircraft should have run…NTSB LAX82FA080Accident · Minor injuriesField investigationFinal reportCessna 172N · Catalina Island, CAWhile circling around Catalina Island turning in an out of canyons at 1700 feet MSL the engine lost power. At los angeles international airport, 38 miles to the nnw, the temperature was 65 degrees and the dew point was 45 degrees. All attemps to restart the…NTSB CHI82DA063Accident · Serious injuriesFinal reportBellanca 8KCAB · Franklin, WIAfter a 1.8 hour flight, the fixed base operator serviced the aircraft with 15 gallons of fuel. The pilot stated that he drained the sumps as part of his preflight. The pretakeoff checks and takeoff roll were normal. At about 75 to 100 feet AGL, the engine…NTSB LAX82FA077Accident · No injuriesField investigationFinal reportBell 47G2 · Brawley, CAThe pilot visually checked the gas tank before takeoff and estimated there was about 1/4 tank of fuel. He then started the engine and hovered over to the water tanker and loaded 60 gallons of water in the spray tank in order to calibrate the number of gallons…NTSB FTW82DA060Accident · No injuriesFinal reportBellanca 7ECA · Henderson, TXAfter reducing power to idle, gliding for some distance, and then applying carburetor heat he realized that additional power would be needed to reach the runway. Power was added with no results and the aircraft was set down in a rough field approximately 1/4…NTSB MKC82DA033Accident · No injuriesFinal reportPiper PA-28-151 · Des Moines, IAThe aircraft had not been refueled after a previous flight of about one hour. The pilot visually checked the fuel and estimated 41 gallons remaining. He believed that he had about 5.2 hours of fuel. During an IFR flight, he diverted for an enroute fuel stop…NTSB FTW82DA059Accident · No injuriesFinal reportCessna 310D · Farmerville, LABefore this flight, the aircraft had not been flown for a period of time. The pilot was the owner of a maintenance facility and was preparing to perform an annual inspection of the aircraft. He elected to fly it around the airport to warm up the engines…NTSB CHI82FA048Accident · 1 fatalField investigationFinal reportPiper PA-23 · Corydon, INPrior to this flight, the aircraft had not been flown for an extended period. On the day of the accident, it had been sold. The aircraft did not have a current annual inspection and had several maintenance discrepancies. These included problems that prevented…NTSB MKC82DA030Accident · No injuriesFinal reportCessna 152 · Chesterfield, MODuring takeoff from a touch and go landing, the engine lost power at about 300 ft AGL. The student pilot was unable to restart the engine. The aircraft was damaged during a forced landing off of the runway. No pre-impact engine malfunctions or failures were…NTSB MIA82FA045Accident · 2 fatalField investigationFinal reportCessna 421 · Miami, FLThe flight departed the tamiami airport, Miami, Florida at approximately 2100 EST on February 9, 1982. There was no flight plan filed and the purpose, destination, and locations of possible enroute stops were not determined. The next reported communication…NTSB NYC82DA032Accident · No injuriesFinal reportCessna 172K · Plymouth, MAAfter entering the traffic pattern, the pilot completed his prelanding checklist while opposite of the numbers on downwind. After turning to final approach, there was a loss of engine power. He stated that he reached down and switched the fuel selector…NTSB MIA82FLD16Accident · Serious injuriesFinal reportCessna 310 · Lake Wales, FLThe flt encountered bad wx over the Lake Wales arpt. The plt put the gear down & was maneuvering for an approach. The pax stated that acft then crashed. The fuel tanks had approximately one pint of fuel remaining.NTSB CHI82DA040Accident · No injuriesFinal reportCessna 152 · Canton, MIThe student pilot was on the second leg of his cross-country flight when the engine lost power. He landed in a snow covered, plowed field. After about 60 feet of ground roll, the plane nosed over. The student stated that the engine started running rough until…NTSB LAX82DA064Accident · No injuriesFinal reportCessna 152 · Corona, CAFollowing a preflight inspection of the aircraft by the student pilot, the aircraft departed the Corona municipal airport on a dual training flight. Upon reaching an altitude of approximately 300 feet, the engine quit. The instructor landed the aircraft…NTSB MIA82DA050Accident · 2 fatalFinal reportPiper PA-28 · 120 Nm Sse Of M, FLAt about 1216 the pilot of a Cessna 402, N69400, heard N1306H announce on the radio that he was 100 miles south of bimini and had 15 minutes of fuel remaining. The captain of American airlines flight 603 heard the pilot state that he was going in and he…NTSB ATL82DA046Accident · Serious injuriesFinal reportCessna T210L · Luverne, ALThe engine abruptly quit during takeoff after the pilot reduced power and started a crosswind turn. The nose gear collapsed rearward during landing roll in a soft terraced pasture and the aircraft flipped to an inverted position. Two ounces of water were…NTSB SEA82DA025Accident · No injuriesFinal reportCessna 150J · Nr. Colbert, WADuring flight, the instructor asked the student to perfrom a power-off approach-to-landing stall. The student began the maneuver at about 4600 ft with the carburetor heat on. During recovery, he abruptly advanced the throttle and the engine began to lose…NTSB FTW82FRA15Accident · Serious injuriesFinal reportAerospatiale SA-360C · Hitchcock, TXDuring a return flight from an offshore platform, the pilot encountered strong headwinds and elected to land at lake jackson, Texas for fuel. He lacked a proper mode of payment; therefore, he was unable to purchase fuel. He departed for galveston, Texas with…NTSB LAX82DA057Accident · No injuriesFinal reportCessna 177B · Elko, NVThe owner of the aircraft stated that he had "topped the tanks" after the previous flight. The pilot of this flight said that he did not visually check the fuel before takeoff. During flight, the right fuel gauge continued to indicate full. About 15 miles…NTSB MKC82DA022Accident · No injuriesFinal reportCessna 172H · Wentzville, MODuring a cross-country flight, the pilot switched the fuel selector from both tanks to the right tank to balance the fuel. After the tanks were balanced, he failed to switch the selector back to both. During a night, final approach at his destination, the…NTSB ATL82DA043Accident · No injuriesFinal reportPiper PA-32-260 · Louisville, KYAt 600FT AGL while on a 3 mile straight in visual approach,the engine quit. The pilot stated he had insufficient time to attempt a restart and commenced a 180 degree turn toward a golf course. Upon landing the aircraft struck a tree. Investigation revealed no…NTSB ANC82FA017Accident · Minor injuriesField investigationFinal reportCessna 152II · Anchorage, AKWhile descending to about 3000 ft the student pilot stated that the engine started sputtering. Since the fuel gages read empty he attempted a landing at sky harbor/o'malley airstrip but came in high on the initial approach. As he maneuvered for another…NTSB ATL82DA040Accident · No injuriesFinal reportCessna 177 · Athens, GADuring an enroute refueling stop on 1/21 the pilot noticed fuel leaking around the left tank cap. After arriving at sanford the acft was refueled with appx 50 gals & a local flight of about 12 min was flown. The acft has a usable fuel capacity of 59 gals. The…NTSB FTW82DA047Accident · No injuriesFinal reportGrumman G-164A · Hobbs, NMThe aircraft engine failed seconds after takeoff on the first flight of the day. The pilot had insufficient altitude and speed to dump his load of dry fertilizer. The plane stalled and touched down hard in a three-point attitude and bounced. The plane then…NTSB SEA82DA020Accident · No injuriesFinal reportSikorsky S-58J · Near Kingston, IDThe aircraft was engaged in logging operations. While in a hover to pick up a second load of logs, the engine lost power. An autorotation was made into a creek bed. An inspection revealed that snow and water from the cabin interior had penetrated the cabin…NTSB ATL82IA041Incident · No injuriesIncident investigationFinal reportDassault/Sud Falcon 20 · Louisville, KYDuring a cruise descent from FL 330 in clear air (RAT-22 deg c) a double engine flameout occurred. Pwr had been adjusted to 86 pct with engine anti-ice on prior to the descent. When the throttles were advanced at FL 220, there was no engine response.…NTSB MIA82FA035Accident · 1 fatalField investigationFinal reportCessna 210 · Orlando, FLThe passenger stated that the aircraft departed with both fuel tanks indicating about 1/4 full. At 2113 the pilot reported to herndon tower that he had an engine failure. Accord to the surviving passenger, the only thing he saw the pilot do after the engine…NTSB FTW82DA042Accident · No injuriesFinal reportCessna 150H · Shreveport, LAThe pilot departed stillwater, ok at 0950 CST on a flight to mcalister, OK. While airborne, he amended his destination to Shreveport, LA with an estimated arrival time of 1251 CST. On his flight plan, he estimated 3 hours of fuel on board. At 1253 CST, the…NTSB ATL82DA036Accident · No injuriesFinal reportBell 206B · Centerville, ALThe mishap occurred during a practice hover with a 100 ft cable in preparation for an external load operation. While hovering about 100 ft AGL, the fuel boost pump light illuminated and the boost pump pressure dropped to zero. A descent was started; however,…NTSB MIA82DA033Accident · No injuriesFinal reportGrumman AA5B · Monticello, FLAfter being denied a special VFR clearance to land at tampa-st. petersburg the pilot elected to cancel his flight plan to tallahassee and fly to new orleans. About 5 1/2 hours into the flight he decided to divert to gulfport, ms and tuned in the gulfport VOR…NTSB DEN82FTE15Accident · No injuriesFinal reportCessna 182A · Steamboat Sprin, COAfter the pilot entered the traffic pattern for landing, he extended his downwind leg to accomodate the departure of another aircraft. The pilot reported that he pushed the throttle forward as he turned base, but the engine failed to respond. During a forced…NTSB FTW82DA037Accident · Serious injuriesFinal reportPiper PA-24-250 · Lonoke, ARThe pilot stated that the engine failed at 2000 ft as he was descending for an approach. He switched the fuel selector from the right tank to the left tank, turned on the boost pump, and pumped the throttle but the engine failed to start. The aircraft landed…NTSB FTW82DA035Accident · Minor injuriesFinal reportPiper PA-28R-200 · Estancia, NMThe pilot stated he experienced an engine stoppage in flight and attempted to land on a dirt road. Both fuel tanks were found empty and a total of 3 to 4 ounces of fuel was drained from the aircraft fuel system.NTSB MIA82DA030Accident · Minor injuriesFinal reportCessna 210L · Cocoa, FLUpon arriving in the vicinity of the destination airport the pilot started to reduce power in preparation for the descent when he observed that the engine experienced a power loss. All attempts made to restore power on the engine were to no avail and the…