Skip to content

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

25 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" = 'PA' 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\" = 'PA' 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" = 'PA' 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 GAA19CA491Accident · No injuriesData collectionFinal reportConsolidated Vultee BT13 · Franklin, PAThe pilot's failure to maintain directional control during takeoff in gusting crosswind conditions, which resulted in a runway excursion and the left main landing gear collapsing.Aug 10, 2019 · N62644 · Substantial damage NTSB ERA17FA153Accident · 1 fatalField investigationFinal reportHoward DGA 15P · Monongahela, PAThe pilot's failure to maintain airplane control during an attempted go-around in gusting crosswind conditions, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall.Apr 12, 2017 · N4476N · Destroyed NTSB NYC89LA108Accident · No injuriesLimited investigationFinal reportBeech TC-45J · Johnstown, PAFailure of the pilot to maintain runway alignment. The crosswind and snow covered runway were related factors.Mar 6, 1989 · N45861 · Substantial damage NTSB NYC87LA136Accident · No injuriesLimited investigationFinal reportBeech BE-18 · York, PAWhile the aircraft was being ferried from massy, Maryland to ankeny, Iowa, a loss of oil pressure on the left engine was experienced. A precautionary landing was made in a cornfield with the landing gear in the up position when the gear failed to extend. Fire…Apr 30, 1987 · N66PA · Substantial damage NTSB NYC87LA031Accident · No injuriesLimited investigationFinal reportBeech BE18H · Pittsburgh, PAThe aircraft suffered a right landing gear leg breakage due to a fracture in the area where the fork assembly separated during landing roll.Nov 12, 1986 · N925J · Substantial damage NTSB NYC81FA031Accident · Minor injuriesClosedBeech H18 · Hazelton, PAMar 11, 1981 · N161SP · Substantial damage NTSB NYC81FA024Accident · Serious injuriesClosedBeech C-45H · Dillsburg, PAFeb 2, 1981 · N45437 · Destroyed NTSB NYC81FA010Accident · 1 fatalClosedBeech H18 · Troxelville, PANov 18, 1980 · N701CC · Destroyed NTSB NYC79FA051Accident · Minor injuriesClosedBeech C45H · Slatington, PAJun 29, 1979 · N281M · Destroyed NTSB NYC79FGM18Accident · No injuriesClosedBeech E18S · Latrobe, PAFeb 23, 1979 · N342T · Substantial damage NTSB NYC79FA021Accident · No injuriesClosedBeech H18 · Pittsburgh, PAJan 25, 1979 · N135W · Substantial damage NTSB NYC78FA028Accident · Minor injuriesClosedBeech E18S · Middletown, PAFeb 17, 1978 · N180X · Substantial damage NTSB NYC77FA082Accident · Serious injuriesClosedBeech G18S · Pittsburgh, PAAug 17, 1977 · N75FA · Substantial damage NTSB NYC76DHA42Accident · No injuriesClosedBoeing E75 · Willow Grove, PAJul 2, 1976 · N9077H · Substantial damage NTSB NYC76FHM20Accident · No injuriesClosedSikorsky S-51 · Perkasie, PAFeb 20, 1976 · N92868 · Substantial damage NTSB NYC76AN072Accident · No injuriesClosedBeech E18S · Erie, PAJan 30, 1976 · N43T · Substantial damage NTSB NYC75FGT09Accident · No injuriesClosedBeech E18S · Mcsherrytown, PAOct 27, 1974 · N3666G · Substantial damage NTSB NYC74FHA29Accident · No injuriesClosedBoeing E-75 · E Stroudsburg, PAApr 21, 1974 · N33621 · Substantial damage NTSB NYC70D0179Accident · Minor injuriesClosedBeech D18S · Karthaus, PAOct 2, 1969 · N4193 · Substantial damage NTSB NYC70A0014Accident · 3 fatalClosedBeech D18S · Jersey Shore, PAJul 27, 1969 · N319 · Destroyed NTSB NYC67F0670Accident · Minor injuriesClosedVultee BT13A · Pottstown, PAJun 1, 1967 · N69687 · Substantial damage NTSB NYC67F0355Accident · No injuriesClosedBeechcraft E18S · Reedsville, PAOct 27, 1966 · N219Y · Substantial damage NTSB NYC66F0170Accident · No injuriesClosedBeechcraft C-18S · Beaver Falls, PAAug 7, 1965 · N7377C · Substantial damage NTSB UNK64X3665Accident · No injuriesClosedBeechcraft E18 · Reading, PAAug 29, 1964 · N5632D · Substantial damage NTSB UNK64X2744Accident · No injuriesClosedBeechcraft D18 · Ambler, PAJul 10, 1964 · N711K · Substantial damage