OpenAirDocs.org

NTSB investigations: Pratt & Whitney R-985 series

59 cases on aircraft whose registry engine model is Pratt & Whitney R-985 series, where the first occurrence was “Loss of engine power”. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52008')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350))
  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.

NTSB FTW83LA234Accident · No injuriesLimited investigationFinal reportBeech TC-45G · Abilene, TXAbout 30 mi east of Abilene there was a partial loss of power on the left eng. The plt feathered the prop & made an emergency approach into Abilene. Unable to hold initial approach altitude, the plt restarted the left eng, but could obtain only partial power.…May 14, 1983 · N63310 · Substantial damageNTSB ANC82DA100Accident · No injuriesFinal reportBeech C45H · Near Deering, AKThe aircraft slid wheels up into a lake during a one-engine forced landing. The aircraft sank and was not recovered but all the occupants were able to reach shore uninjured. The pilot said the left engine lost power during cruise and he elected to shut it…Sep 27, 1982 · N3120GNTSB ATL82DA276Accident · No injuriesFinal reportGrumman G-164B · Society Hill, ALAircraft lost power during takeoff and nosed over during emergency landing in a cotton field. Takeoff weight was over certificated gross limit.Sep 16, 1982 · N48636 · Substantial damageNTSB MIA82DA176Accident · No injuriesFinal reportBoeing A75N1 · Madison, FLWhile returning to the airport, the engine lost power. The pilot landed long in a pasture to avoid cows, and then was unable to stop before hitting a fence. The pilot reported that the mixture linkage became disconnected. After the accident, the linkage was…Aug 31, 1982 · N59998 · Substantial damageNTSB FTW82DA334Accident · No injuriesFinal reportGrumman G164A · Marianna, ARThe pilot stated that shortly after lift off the engine backfired and lost power. He reported that the engine did not completely quit and there was no visible smoke, flame or oil coming from the engine. Due to his low altitude and heavy load the pilot elected…Aug 17, 1982 · N5364 · Substantial damageNTSB ATL82DA221Accident · No injuriesFinal reportGrumman G-164 · Donalsonville, GAWhile en route back to the airport, the engine lost power and the pilot landed in a rain soaked, soybean field. During the landing roll, the wheels bogged down in soft earth and the plane nosed over. According to the pilot, there was 10 to 12 gallons of fuel…Jul 29, 1982 · N10286 · Substantial damageNTSB SEA82DA053Accident · No injuriesFinal reportWeatherly 201C · Espanola, WAThe pilot stated that during climb the engine power suddenly went to idle. A forced landing was made in a soft plowed field where the aircraft nosed over. No mechanical malfunctions were found during the engine examination however it was noted that conditions…Apr 17, 1982 · N9231W · Substantial damageNTSB FTW82DA093Accident · 1 fatalFinal reportBeech C-45H · Mcallen, TXAbout 18 minutes after takeoff, the pilot radioed that the no. 2 engine had lost power and that he was returning to land at Mcallen, TX. While approaching to land, the aircraft crashed in an open field about 400 yards short of the runway and 115 feet right of…Mar 15, 1982 · N9846Z · DestroyedNTSB ANC82DA020Accident · No injuriesFinal reportGrumman G-21A · N Cape Yakataga, AKAircraft departed merrill field at 1110 with 220 gallons of fuel. Two hours later both engines quit while flying at an altitude of 6500 feet approximately 10 miles offshore. The crew was unable to restart the engines and the aircraft was ditched into 12 to 15…Feb 20, 1982 · N2845D · Substantial damage