Skip to content

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

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

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" = 'MS' 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\" = 'MS' 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" = 'MS' 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 ERA12CA079Accident · No injuriesData collectionFinal reportBeech C-45G · Lyman, MSThe collapse of the right main landing gear during landing due to an encounter with soft terrain.Nov 19, 2011 · N75Q · Substantial damage NTSB MIA97LA146Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Ackerman, MSinstallation of an incorrect fuel filter in the fuel tanker, which allowed water-contaminated fuel being dispensed into the aircraft, subsequent partial loss of engine power on initial takeoff climb, and a forced landing. The lack of suitable terrain for a…Apr 21, 1997 · N6601Q · Substantial damage NTSB MIA96LA206Accident · No injuriesLimited investigationFinal reportGrumman 164A · Marks, MSthe pilot's failure to remain clear of the known high point on runway.Aug 7, 1996 · N665U · Substantial damage NTSB MIA95LA085Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Crystal Springs, MSThe failure of the pilot in command to insure the aircraft contained adequate fuel to complete the flight.Mar 6, 1995 · N6619Q · Substantial damage NTSB MIA94LA218Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Greenwood, MSThe improper decision of the pilot to execute a precautionary landing to an unprepared field due to a supercharger shaft failure.Sep 29, 1994 · N48572 · Substantial damage NTSB MIA89IA247Incident · No injuriesIncident investigationFinal reportBeech G18S · Jackson, MSFailure of the pilot to correctly perform the emergency gear extension procedures. Contributing to the accident was the failure of the normal gear extension system.Sep 13, 1989 · N9604R · Minor damage NTSB ATL81DKQ17Accident · No injuriesClosedGrumman G-164A · West Point, MSJun 21, 1981 · N6535 · Destroyed NTSB MIA78FK030Accident · Minor injuriesClosedGrumman G-164B · Charleston, MSAug 3, 1978 · N48497 · Destroyed NTSB MIA77FKQ26Accident · No injuriesClosedGrumman G-164B · Tchula, MSAug 2, 1977 · N63D · Substantial damage NTSB MIA77FKQ15Accident · No injuriesClosedGrumman G-164B · Pugh City, MSMay 19, 1977 · N48646 · Destroyed NTSB MIA76FKQ39|MIA76FK039Accident · No injuriesClosedCessna 188 · Shelby, MSJul 20, 1976 · N21862 · 2 aircraft · Substantial damage NTSB MIA74FLT01Accident · No injuriesClosedGrumman G-164A · Ripley, MSSep 3, 1973 · N4562 · Substantial damage NTSB MIA73FKQ02Accident · No injuriesClosedGrumman G-164 · Philipp, MSAug 7, 1972 · N745Y · Substantial damage NTSB MIA72DKQ22Accident · No injuriesClosedBoeing B75N1 · Nitta Yuma, MSAug 23, 1971 · N1758M · Substantial damage NTSB MIA71FKQ36Accident · No injuriesClosedStearman A75 · Cleveland, MSMay 31, 1971 · N4878N · Substantial damage NTSB MIA70F0048Accident · Serious injuriesClosedBoeing A75N1 · West Point, MSJul 11, 1969 · N55377 · Substantial damage NTSB MIA69F0446Accident · No injuriesClosedBoeing E75N1 · Minter City, MSApr 23, 1969 · N5710N · Substantial damage NTSB MIA69F0346Accident · Minor injuriesClosedBeech G17S · Southhaven, MSFeb 3, 1969 · N4710V · Substantial damage NTSB MIA69D0013Accident · No injuriesClosedSikorsky S-51 · Gulfport, MSJul 4, 1968 · N13183 · Substantial damage NTSB MIA68F0259Accident · No injuriesClosedBoeing A75N1 · Tchula, MSOct 13, 1967 · N50149 · 2 aircraft · Substantial damage NTSB MIA68F0167Accident · No injuriesClosedBoeing A75N1 · Redwood, MSSep 4, 1967 · N60309 · Substantial damage NTSB MIA65A0126Accident · 1 fatalClosedBoeing 75N1 · Sunflower, MSJun 26, 1965 · N4936C · Substantial damage NTSB UNK65X0216Accident · No injuriesClosedBoeing A75N1 · Yazoo City, MSOct 10, 1964 · N61042 · Substantial damage NTSB UNK64X3654Accident · Serious injuriesClosedBoeing B75N1 · Nitta Yuma, MSAug 28, 1964 · N50737 · Substantial damage