Skip to content

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

29 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" = 'OK' 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\" = 'OK' 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" = 'OK' 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 CEN15LA204Accident · Minor injuriesLimited investigationFinal reportGrumman G 164A · Maysville, OKThe loss of engine power for reasons that could not be determined because a postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.Apr 15, 2015 · N7951 · Substantial damage NTSB CEN14LA319Accident · Minor injuriesLimited investigationFinal reportGrumman G 164 · Anadarko, OKThe total loss of engine power while climbing after takeoff for reasons that could not be determined based on the available information.Jun 20, 2014 · N455Y · Substantial damage NTSB CEN13LA322Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Covington, OKThe airplane’s failure to climb after takeoff for reasons that could not be determined because postaccident examinations of the engine and airframe did not reveal any anomalies that would have precluded normal operation.Jun 6, 2013 · N6754Q · Substantial damage NTSB DFW08CA159Accident · No injuriesData collectionFinal reportBeech E-18 · Guymon, OKThe pilot's failure to maintain directional control during landing roll out. Contributing to the accident was the crosswind.Jun 1, 2008 · N241X · Substantial damage NTSB DFW07CA131Accident · No injuriesData collectionFinal reportGrumman G-164A · Okarche, OKThe pilot's failure to maintain clearance from an unmarked light fixture.Jun 9, 2007 · N48613 · Substantial damage NTSB FTW92LA101Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Weatherford, OKFuel starvation due to a mechanical failure of the fuel selector. A factor was the lack of suitable terrain.Mar 30, 1992 · N1268W · Substantial damage NTSB FTW87DPJ03Accident · Minor injuriesFinal reportBoeing B75N1 · Fairmont, OKDuring the pull up at end of swath run pilot misjudged power line clearance. Top line caught on aircraft and caused uncontrolled descent to ground.Mar 8, 1987 · N5102N · Substantial damage NTSB FTW86FA004Accident · 2 fatalField investigationFinal reportBeech H18 · Oklahoma City, OKAtr plt departing arpt under VMC experienced failure of the right eng shortly after lift-off. The acft yawed right followed by a steep right roll, contacting power lines with the right wing and subsequently impacted the ground. A post-crash fire destoyed the…Nov 5, 1985 · N1461G · Destroyed NTSB FTW85FPJ01Accident · Serious injuriesFinal reportGrumman AG CAT G-164 · Norman, OKThe acft collided with a high static wire on an electric transmission line before colliding out of control with the ground. The plt stated after the accident that he forgot about the static line and flew into it during a maneuver for aerial spraying.Apr 1, 1985 · N5338 · Destroyed NTSB FTW81FPJ16Accident · No injuriesClosedGrumman G-164B · Billings, OKApr 9, 1981 · N48478 · Destroyed NTSB FTW81DPJ14Accident · No injuriesClosedBoeing A75 · Covington, OKApr 8, 1981 · N50149 · Destroyed NTSB FTW77DPJ30Accident · No injuriesClosedGrumman G-164B · Carnegie, OKJul 15, 1977 · N6616Q · Destroyed NTSB FTW76DPJ26Accident · Minor injuriesClosedBoeing A75N1 · Eldorado, OKFeb 25, 1976 · N67238 · Destroyed NTSB FTW76FPM10Accident · Minor injuriesClosedBoeing A75N1 · Blanco, OKNov 9, 1975 · N62146 · Substantial damage NTSB FTW75DPJ06Accident · Minor injuriesClosedGrumman G-164 · Pauls Valley, OKAug 15, 1975 · N957X · Substantial damage NTSB FTW74FPM14Accident · No injuriesClosedBoeing A75 · Tulsa, OKDec 14, 1973 · N61492 · Substantial damage NTSB FTW74DPM08Accident · No injuriesClosedBoeing A75 · Coleman, OKSep 23, 1973 · N4564N · Substantial damage NTSB FTW73FPJ15Accident · No injuriesClosedBoeing B75N1 · El Reno, OKApr 20, 1973 · N5080N · Substantial damage NTSB FTW73DPJ10Accident · No injuriesClosedBoeing E75 · Hollis, OKMar 6, 1973 · N5191N · Substantial damage NTSB FTW71DPJ31Accident · No injuriesClosedBoeing A75 · Chickasha, OKMar 15, 1971 · N50536 · Substantial damage NTSB FTW71AF042Accident · No injuriesClosedBeech E18S · Muskogee, OKJan 20, 1971 · N225H · Substantial damage NTSB FTW70DPM11Accident · No injuriesClosedBoeing A75N1 · Vera, OKMay 24, 1970 · N62146 · Substantial damage NTSB FTW70FPM08Accident · Minor injuriesClosedBoeing E75N1 · Wetumka, OKMay 17, 1970 · N5223N · Destroyed NTSB FTW70D0145Accident · No injuriesClosedBoeing E75N1 · Hollis, OKAug 7, 1969 · N5191N · Substantial damage NTSB FTW69A0081Accident · No injuriesClosedBeech G18S · Tulsa, OKMay 5, 1969 · N697Q · Substantial damage NTSB FTW68A0089Accident · No injuriesClosedBeech D18S · Altus, OKApr 14, 1968 · N212Z · Substantial damage NTSB FTW67D0442Accident · No injuriesClosedBeech C-45H · Tulsa, OKFeb 5, 1967 · N3657G · Substantial damage NTSB FTW67A0058Accident · No injuriesClosedLockheed 12A · Oklahoma Cty, OKDec 1, 1966 · N16085 · Substantial damage NTSB UNK64X0201Accident · No injuriesClosedBeechcraft C18S · Okla City, OKJan 9, 1964 · N11198 · Substantial damage