Skip to content

NTSB investigations: Pratt & Whitney R-985 series, NM

23 cases on aircraft whose registry engine model is Pratt & Whitney R-985 series. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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."eventStateOrRegion" = 'NM' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52008')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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.\"eventStateOrRegion\" = 'NM' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52008'))
  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."eventStateOrRegion" = 'NM' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52008'))
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 CEN18LA226Accident · Serious injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G 164B · Arrey, NMThe pilot's failure to maintain clearance from a hillside during an agricultural application flight while facing the sun.Jun 15, 2018 · N6672Q · Substantial damage NTSB CEN18FA192Accident · 1 fatalField investigationFinal reportBeech D17S · Santa Fe, NMThe pilot's failure to maintain clearance from terrain for reasons that could not be determined based on the available information.May 25, 2018 · N79091 · Substantial damage NTSB GAA17CA044Accident · No injuriesData collectionFinal reportBeech D18S · Deming, NMThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion.Oct 23, 2016 · N644B · Substantial damage NTSB GAA15CA171Accident · No injuriesData collectionFinal reportWeatherly 620B · Hatch, NMThe pilot failed to maintain obstacle clearance, and the airplane struck a transmission line wire during aerial application operations.Jul 9, 2015 · N2034P · Substantial damage NTSB DEN08LA064Accident · No injuriesLimited investigationFinal reportSpartan 7W · Santa Fe, NMFatigue failure of the right main landing gear, rendering directional control impossible and causing an overload failure of the left main landing gear.Mar 12, 2008 · N17662 · Substantial damage NTSB DEN06CA047Accident · Minor injuriesData collectionFinal reportBoeing D75N1 · Santa Teresa, NMthe pilot's failure to maintain directional control during the landing. Contributing factors include the high airspeed, the improper recovery from a bounced landing, the crosswind, and the soft dirt.Mar 8, 2006 · N59496 · Substantial damage NTSB FTW02FA195Accident · 1 fatalField investigationFinal reportBeech H-18 · Tatum, NMThe failure of the pilot to maintain clearance.Jul 1, 2002 · N835K · Destroyed NTSB FTW97LA167Accident · Serious injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Hatch, NMThe pilot's failure to maintain clearance from the wires. A factor was the sunglare.Apr 28, 1997 · N7696 · Substantial damage NTSB FTW96LA211Accident · No injuriesLimited investigationFinal reportBoeing E75 · Taos, NMthe pilot's failure to maintain directional control. A factor was the dust devil.May 11, 1996 · N4787V · Substantial damage NTSB DEN91LA086Accident · No injuriesLimited investigationFinal reportNaval Aircraft Factory N3N-3 · Deming, NMThe pilot's failure to maintain directional control. Factors were: a crosswind condition and a soft shoulder alongside the runway.Jun 14, 1991 · N44970 · Substantial damage NTSB DEN85LA173Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Deming, NMThe plt told FAA he was spraying a cotton field and was turning around from a swath run when the propeller feathered. The plt told NTSB that the acft 'pitched upward and lost power.' Acft type certificate shows that a hamilton standard propeller m/n…Jun 22, 1985 · N5337 · Substantial damage NTSB DEN84LA245Accident · No injuriesLimited investigationFinal reportConsolidated-Vultee BT-13B · Hobbs, NMAs part of a group of a confederate air force acft the flight conducted public relations flyovers at several area arpts. Due to a low ldg gear strut N63697 did not land with the other acft after the flyovers. The plt planned to have the strut repaired upon…Jul 28, 1984 · N63697 · Substantial damage NTSB FTW83LA002Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Albuquerque, NMUpon completion of an airshow the plt returned to coronado arpt. Upon touchdown the acft tried to nose over & a go-around was made. After two touch & go's the plt isolated the problem to a locked right brake so he attempted to remedy the problem by cutting…Oct 3, 1982 · N30136 · Substantial damage NTSB FTW82DA250Accident · No injuriesFinal reportBeech D18S · Belen, NMThe pilot stated that during flight, the left engine began leaking oil and the cockpit filled with smoke. He shut down the left engine, but stated that the propeller would not completely feather due to the loss of oil. While approaching to land at a nearby…Jun 26, 1982 · N3962 · Substantial damage NTSB DEN76DQD33Accident · No injuriesClosedBoeing E75N1 · Animas, NMAug 22, 1976 · N58712 · Substantial damage NTSB DEN76FQA30Accident · No injuriesClosedBeech TC-45G · El Vado, NMJan 10, 1976 · N9907Z · Destroyed NTSB DEN72FQA41Accident · No injuriesClosedHoward DGA-15 · Albuquerque, NMMay 27, 1972 · N450Y · Substantial damage NTSB DEN72DQA23Accident · No injuriesClosedBeech D18S · Conchas Dam, NMOct 28, 1971 · N104J · Substantial damage NTSB DEN70FQA27Accident · No injuriesClosedBeech D18S · Albuquerque, NMJun 27, 1970 · N445EA · Substantial damage NTSB DEN68F0189Accident · No injuriesClosedBeech D18S · Albuquerque, NMDec 29, 1967 · N260R · Substantial damage NTSB DEN68A0007Accident · No injuriesClosedBeech D18S · Tucumcari, NMJul 22, 1967 · N103G · Substantial damage NTSB DEN65A0074Accident · No injuriesClosedBoeing A-75 · 2os Kenna, NMMay 17, 1965 · N58758 · No damage NTSB UNK64X0261Accident · No injuriesClosedBeechcraft D18S · Albuquerque, NMJan 16, 1964 · N224A · Substantial damage