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

10 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

19672026

NTSB investigations: Pratt & Whitney R-985 series, WY per year, 1967–2026: 10 cases
1967	2
1969	3
1972	1
1973	1
1981	1
1988	1
2012	1

Where

Open the map

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" = 'WY' 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\" = 'WY' 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" = 'WY' 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 WPR12CA242Accident · No injuriesData collectionFinal reportGrumman G-164A · Riverton, WYThe pilot's loss of directional control during the landing roll and his deliberate application of excessive braking pressure, which resulted in a noseover.Jun 3, 2012 · N5291 · Substantial damage NTSB DEN88FA114Accident · 2 fatalField investigationFinal reportBeech D-17S · Wheatland, WYThe witnesses said they saw the acft fly a pattern indicative of a base to final approach to rwy 35. The airstrip has a second runway oriented east and west. The wind was blowing from the east at 20 knots. The acft wreckage was found approximately 3/4 miles…May 28, 1988 · N1038M · Destroyed NTSB DEN81FTC25Accident · Minor injuriesClosedBeech H18S · Gillette, WYSep 27, 1981 · N919X · Substantial damage NTSB DEN74FTC02Accident · No injuriesClosedBeech D18S · Encampment, WYJul 1, 1973 · N6560D · Substantial damage NTSB DEN72AD045Accident · 7 fatalClosedBeech C-18S · Mcfadden, WYApr 2, 1972 · N1322M · Destroyed NTSB DEN70F0136Accident · No injuriesClosedBeech G-18-S · Laramie, WYOct 24, 1969 · N1500Z · Substantial damage NTSB DEN70F0039Accident · Serious injuriesClosedBoeing A-75 · Buffalo, WYMay 8, 1969 · N57445 · Substantial damage NTSB DEN69D0178Accident · No injuriesClosedBeech D-17S · Cheyenne, WYFeb 13, 1969 · N1030 · Substantial damage NTSB DEN68F0022Accident · No injuriesClosedBeech D18S · Cheyenne, WYJun 28, 1967 · N631B · Substantial damage NTSB DEN68F0001Accident · No injuriesClosedBeech C-45 · Saratoga, WYMay 26, 1967 · N9846Z · Substantial damage