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

11 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

19652026

NTSB investigations: Pratt & Whitney R-985 series, VA per year, 1965–2026: 11 cases
1965	1
1966	1
1969	1
1971	2
1973	1
1976	1
1980	1
1984	2
1985	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" = 'VA' 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\" = 'VA' 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" = 'VA' 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 BFO85LA040Accident · No injuriesLimited investigationFinal reportBeech E18S · Fishersville, VAWeather conditions in charlottesville, Virginia, the intended destination, resulted in a missed approach and diversion to shenandoah valley airport, where two more missed approaches were executed. On the climb out from the second missed approach, the left…Apr 25, 1985 · N67A · Substantial damage NTSB ATL85FA054Accident · Serious injuriesField investigationFinal reportBeech D18S · Norfolk, VAThe acft crashed during an ILS approach following an engine power loss while on an air taxi freight flight. The plt related that at about 550 ft on the approach to rwy 23 the left eng fuel press warning lite illuminated & the lt eng loss power. The plt opened…Dec 13, 1984 · N8517Z · Destroyed NTSB ATL85LA032Accident · No injuriesLimited investigationFinal reportBoeing 75 · Rustburgh, VAThe pilot stated that he was landing on the 1,100 foot long runway to the south with a 16 knot tailwind. The plt continued to state that while on final apch the aircraft had an excessive rate of sink. The plt added full power in an attempt to arrest the…Nov 10, 1984 · N5506A · Substantial damage NTSB ATL81FID08Accident · No injuriesClosedCessna 421 · Norfolk, VADec 22, 1980 · N3932C · 2 aircraft · Substantial damage NTSB IAD76FID26Accident · Minor injuriesClosedBoeing A75 · Cape Charles, VAMay 22, 1976 · N54565 · Substantial damage NTSB NYC73FIA11Accident · Minor injuriesClosedHoward DGA15P · Hartwood, VAFeb 4, 1973 · N79530 · Destroyed NTSB NYC72FID17Accident · Minor injuriesClosedBeech H18 · Charlottsville, VANov 29, 1971 · N717Z · Destroyed NTSB NYC72AN020Accident · No injuriesClosedBeech 3TM · Dublin, VAAug 7, 1971 · N6127 · Substantial damage NTSB DIA69I0036Incident · No injuriesClosedBeech E18S · Roanoke, VAJan 31, 1969 · N164F · Minor damage NTSB DIA67F0011Accident · No injuriesClosedBeech D18S · Ampthill, VADec 18, 1966 · N80361 · Substantial damage NTSB NYC66F0126Accident · Serious injuriesClosedBeechcraft C45H · E.Bigstone Gap, VAJun 22, 1965 · N9522Z · Substantial damage