Skip to content

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

24 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

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" = 'NY' 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\" = 'NY' 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" = 'NY' 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 ERA25LA276Accident · No injuriesClass 4 · LimitedFinal reportHoward DGA-15P · Farmingdale, NYThe pilot’s failure to maintain directional control of the airplane while landing in a crosswind.Jul 22, 2025 · N67722 · Substantial damage NTSB ERA11LA290Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Albion, NYA bearing failure in the engine’s supercharger section, which resulted in a total loss of engine power during flight. Contributing to the accident was the soft soil of the forced landing site.Apr 29, 2011 · N896X · Substantial damage NTSB NYC07LA207Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Goshen, NYA loss of engine power during cruise flight for undetermined reasons.Sep 1, 2007 · N6578 · Substantial damage NTSB IAD05LA038Accident · Minor injuriesLimited investigationFinal reportGrumman G-21A · Penn Yan, NYThe flight instructor's inadequate planning/decision and his remedial action to conduct or recover from a simulated emergency procedure.Feb 15, 2005 · N327 · Destroyed NTSB NYC97LA181Accident · No injuriesLimited investigationFinal reportBoeing Stearman PT-17 · Geneseo, NYThe failure of both pilots to see and avoid the other aircraft.Sep 14, 1997 · N64604 · 2 aircraft · Substantial damage NTSB NYC86FHM02Accident · Serious injuriesFinal reportGrumman 164-A · Walden, NYThe pilot of a Grumman 164A was crop dusting when he experienced an engine failure. He decided not to dump the load due to possible later repercussions. The aircraft lacked sufficent airspeed or altitude to make a safe landing. The aircraft received…Nov 18, 1985 · N7236 · Destroyed NTSB NYC83FFJ02Accident · No injuriesFinal reportGrumman G-164A · Clarkson, NYThe pilot was diverting from the arpt of departure to an alternate arpt because of the severe weather. The turbulence encountered was so severe, according to the pilot's statement, that he lost control of the acft. Partial control was regained but too late to…Apr 30, 1983 · N5309 · Substantial damage NTSB NYC79IA039Incident · No injuriesClosedBeech BE-18 · Newburgh, NYApr 5, 1979 · N145PA · Minor damage NTSB NYC79FFJ03Accident · Minor injuriesClosedGrumman G-164B · Wolcott, NYOct 30, 1978 · N48724 · Substantial damage NTSB NYC78FHM22Accident · No injuriesClosedGrumman G-164A · Warwick, NYJul 24, 1978 · N915X · Destroyed NTSB NYC78FFJ21Accident · No injuriesClosedBeech 3NM · Syracuse, NYMay 23, 1978 · N3127B · Substantial damage NTSB NYC77DFJ35Accident · No injuriesClosedGrumman G-164A · Wolcott, NYJul 15, 1977 · N5353 · Substantial damage NTSB NYC74AN091Accident · No injuriesClosedBeech D18S · Albany, NYApr 23, 1974 · N60004 · Substantial damage NTSB NYC74AN085Incident · No injuriesClosedTradewind C45G · Jamaica, NYApr 9, 1974 · N11DA · Minor damage NTSB NYC74DFJ25Accident · Minor injuriesClosedBeech E18S · Syracuse, NYDec 22, 1973 · N249K · Substantial damage NTSB NYC71IN053Incident · Minor injuriesClosedBeech D18S · Albany, NYOct 27, 1970 · N765D · Minor damage NTSB NYC71FHJ15Accident · No injuriesClosedHoward DGA15P · East Moriches, NYOct 4, 1970 · N1149V · Substantial damage NTSB NYC70AN107Accident · Serious injuriesClosedBeech C-45 · Albany, NYApr 2, 1970 · N146L · Substantial damage NTSB NYC69A0073Accident · No injuriesClosedBeech TC-45G · Syracuse, NYJan 15, 1969 · N445DM · Substantial damage NTSB NYC68A0054Accident · No injuriesClosedBeech D18S · Jamaica, NYSep 30, 1967 · N136L · Substantial damage NTSB NYC67F0611Accident · Minor injuriesClosedBoeing B75 · Callicoon, NYApr 1, 1967 · N64590 · Substantial damage NTSB NYC67A0118Accident · No injuriesClosedBeech E18S · Jamaica, NYFeb 20, 1967 · N3612B · Substantial damage NTSB NYC66A0150Accident · No injuriesClosedBeech D185 · Horseheads, NYJun 14, 1966 · N1444E · Substantial damage NTSB NYC66F0206Accident · No injuriesClosedGrumman G164 · Elmira, NYAug 12, 1965 · N631U · Substantial damage