Skip to content

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

33 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

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" = 'AL' 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\" = 'AL' 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" = 'AL' 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 ERA19LA263Accident · 1 fatalClass 3 · LimitedFinal reportWeatherly 620 · Russellville, ALThe pilot's failure to see and avoid powerlines during low-altitude agricultural spraying flight operations.Sep 2, 2019 · N90104 · Destroyed NTSB ERA15LA240Accident · No injuriesClass 3 · LimitedFinal reportWeatherly 201B · Pell City, ALThe inadequate inspection of the airplane's landing gear, which resulted in a collapse of the right main landing gear due to cracking and corrosion.Jun 14, 2015 · N1272W · Substantial damage NTSB MIA07CA100Accident · Serious injuriesData collectionFinal reportHillery W. Grice Alley Cat 1 · Fairhope, ALThe failure of the pilot-in-command to maintain terrain clearance while completing a loop at an airshow, resulting in impact with the runway.May 19, 2007 · N985GC · Substantial damage NTSB ATL99LA133Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Enterprise, ALThe loss of engine power for undetermined reasons. Contributing to the severity of the accident was the in-flight collision with a tree during the forced landing.Sep 19, 1999 · N6736Q · Destroyed NTSB ATL95LA122Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Andalusia, ALThe pilot's failure to maintain airspeed in a climbing turn, that resulted in an inadvertent stall.Jun 30, 1995 · N1254W · Substantial damage NTSB ATL94LA084Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Ozark, ALA loss of engine power for undetermined reasons. A factor was the soft terrain.Apr 20, 1994 · N48717 · Substantial damage NTSB MIA92LA159Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Toney, ALThe left main landing gear attachment bolt failed for undetermined reasons resulting in the collapse of both main landing gear during the take off roll.Aug 4, 1992 · N5272 · Substantial damage NTSB ATL92LA130Accident · Minor injuriesLimited investigationFinal reportGrumman 164A · Abbeville, ALThe pilot's failure to see and avoid the top utility wire.Jun 25, 1992 · N5093 · Destroyed NTSB ATL88DKG13Accident · No injuriesFinal reportGrumman G-164A · Fadette, ALThe pilot reported a partial power loss during an aerial application flight. The aircraft landed in the crops. The pilot stated that he found the number 3 cylinder partially separated from the engine.Aug 9, 1988 · N8573H · Substantial damage NTSB ATL87LA184Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Cottonwood, ALThe plt stated that everything was normal for the acft during the preflt and runup. He had just about completed his first swath run when he reptd that the engine shook a little and started backfiring. He pulled up and started across a swamp toward a paved…Jun 21, 1987 · N7687 · Substantial damage NTSB DCA85AA026Accident · 1 fatalFinal reportBeech E18S · Birmingham, ALAt 2045 the military flt, dixie 06, contacted Birmingham apch & obtained clearance for a low apch followed by a full-stop lndg on rwy 05. At 2053, dixie 06 reported a 4 mile final for a low apch to the local controller. At 2054:19, the local controller…Jun 21, 1985 · N19T · 2 aircraft · Destroyed NTSB ATL83LA370Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Berry, ALThe acft dragged a wing during takeoff and collapsed the right main gear in the process. After liftoff the plt said the left wing dipped and contacted soybeans at the end of the rwy. He said he overcontrolled and rolled the right wing into the beans. He…Sep 14, 1983 · N48475 · Substantial damage NTSB ATL83LA101Accident · No injuriesLimited investigationFinal reportBeech H18 · Talladega, ALThe plt stated that shortly after full power application & prior to tailwheel lift-off, the 'right wing raised aprx 3 to 4 ft into the air.' The acft then began drifting left. During ensuing maneuvers, the plt alternately advanced & retarded the throttle as…Feb 11, 1983 · N1461G · Substantial damage NTSB ATL83IA034Incident · No injuriesIncident investigationFinal reportBeech G18S · Huntsville, ALThe left cargo door separated from the acft. The door was a hamilton cargo door installed under an STC which required 3 hinges on top & 3 pins on bottom with an overcenter locking mechanism on the handle for the pins. This door had 2 hinges installed. Only 2…Nov 16, 1982 · N5BA · Minor damage NTSB ATL82DA276Accident · No injuriesFinal reportGrumman G-164B · Society Hill, ALAircraft lost power during takeoff and nosed over during emergency landing in a cotton field. Takeoff weight was over certificated gross limit.Sep 16, 1982 · N48636 · Substantial damage NTSB ATL82DA230Accident · No injuriesFinal reportGrumman G164B · Opp, ALThe pilot reported that while he was spraying, vibrations occurred in the left flying wires. He had experienced the vibrations before, but this time, they seemed worse, he elected to land in a nearby pasture to examine the aircraft. During the landing…Aug 6, 1982 · N6637Q · Substantial damage NTSB ATL82FKJ05Accident · No injuriesClosedBeech 3NM · Ohatchee, ALNov 2, 1981 · N16139 · Substantial damage NTSB ATL81DKJ01Accident · No injuriesClosedBeech C18S · Theodore, ALOct 5, 1980 · N6806C · Substantial damage NTSB ATL80FA080Accident · No injuriesClosedGrumman G-164A · Samson, ALJul 30, 1980 · N8623H · Substantial damage NTSB MIA80FKJ03Accident · No injuriesClosedGrumman G-164A · Vincent, ALOct 8, 1979 · N4593 · Substantial damage NTSB MIA79FKJ65Accident · No injuriesClosedGrumman G-164 · Ashford, ALSep 1, 1979 · N617U · Substantial damage NTSB MIA78FA099Accident · No injuriesClosedBeech E18S · Birmingham, ALJun 26, 1978 · N5644D · Substantial damage NTSB MIA78FKJ28Accident · No injuriesClosedBeech H18 · Birmingham, ALMar 29, 1978 · N787Q · Substantial damage NTSB MIA77FKJ56Accident · Serious injuriesClosedBeech C18S · Irvington, ALJul 4, 1977 · N711SM · Substantial damage NTSB MIA77FKJ46Accident · No injuriesClosedBeech D18 · Sylacauga, ALJun 19, 1977 · N413TB · Minor damage NTSB MIA77DKJ05Accident · No injuriesClosedBoeing 75 · Montgomery, ALOct 13, 1976 · N75869 · Substantial damage NTSB MIA76DKJ78Accident · Serious injuriesClosedBoeing E-75 · Headland, ALJul 1, 1976 · N65949 · Substantial damage NTSB MIA72FKJ02Accident · No injuriesClosedBoeing E75N1 · Echo, ALJul 9, 1971 · N66308 · Substantial damage NTSB MIA72FKJ01Accident · No injuriesClosedGrumman G-164 · Dothan, ALJul 1, 1971 · N748Y · Substantial damage NTSB MIA71FKJ23Accident · No injuriesClosedBeech E18S · Anniston, ALOct 3, 1970 · N4012 · Substantial damage NTSB MIA70DKJ43Accident · No injuriesClosedGrumman G-164 · Mcintosh, ALJun 19, 1970 · N10263 · Substantial damage NTSB MIA70F0052Accident · No injuriesClosedBeech C-45 · Faunsdale, ALJul 12, 1969 · N9847Z · Substantial damage NTSB MIA68F0360Accident · Serious injuriesClosedBoeing E75 · Mobile, ALNov 14, 1967 · N4890N · Substantial damage