NTSB investigations: Pratt & Whitney R-985 series
1,867 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.
Cases, newest first
Query with SQL
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.\"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."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" DESCRun 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 ATL96LA044Accident · Minor injuriesLimited investigationFinal reportBeech C-45G · Blountville, TNthe pilot's improper use of carburetor heat which resulted in a continuing loss of engine power, and the right landing gear's failure to extend during a single engine approach. A factor was the insufficient time available to extend the landing gear via the…NTSB LAX96LA101Accident · No injuriesLimited investigationFinal reportBoeing A75 · Barstow, CAa loss of engine power for an undetermined reason(s).NTSB FTW96LA057Accident · Serious injuriesLimited investigationFinal reportBeech D18S · Loveland, COThe second pilot's failure to compensate for wind conditions and his improper recovery from a bounced landing, and the pilot-in-command's inadequate supervision of the flight. Factors were the second pilot's lack of landing experience in the airplane…NTSB SEA96LA020Accident · No injuriesLimited investigationFinal reportSnow S2C · Dufer, ORA loss of engine power due to a cracked cylinder head. A factor was the evasive maneuver to avoid a ditch.NTSB BFO95LA095Accident · No injuriesLimited investigationFinal reportSnow S2A · Pasadena, MDthe pilot's inability to maintain directional control due to the failure of the right brake during the landing roll.NTSB MIA95LA215Accident · 1 fatalLimited investigationFinal reportBeech E-18S · Atlantic Ocean (Atlantic Ocean)Undetermined.NTSB SEA95LA191Accident · No injuriesLimited investigationFinal reportSchweizer G-164 · Nyssa, ORthe pilot's inadequate ground reconnaissance.NTSB FTW95LA341Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Englewood, COFailure by the pilot to maintain directional control which resulted in a ground loop. A factor was crosswind.NTSB CHI95LA272Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Wadena, MNthe pilot's inattentiveness during the reversal turn, the pilot not maintaining control of the airplane, and the stall/mush encountered by the pilot.NTSB ANC95LA132Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Iliamna, AKThe pilot's abrupt (improper) use of the throttle.NTSB FTW95LA331Accident · No injuriesLimited investigationFinal reportGrumman G-164A · St.Francisville, LAThe pilot's failure to maintain clearance with the obstruction on short final. A factor was the low visibility.NTSB LAX95LA350Accident · No injuriesLimited investigationFinal reportBoeing B75-A75N1 · Van Nuys, CAthe pilot's failure to maintain directional control during landing rollout. Factors which contributed to the loss of control were: the pilot's total lack of experience landing the conventional gear airplane in a crosswind condition, and the crosswind.NTSB CHI95LA250Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Park River, NDthe loss of power due to the primary lead in the left magneto being grounded against the case, and the improper clearance of the breaker point gaps. A factor was the lack of suitable terrain on which to perform the forced landing.NTSB SEA95LA154Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Roberts, IDA loss of engine power due to the separation of the number 3 cylinder exhaust valve rocker arm shaft from the cylinder head, which disabled movement of the exhaust valve. A factor was the lack of suitable terrain for the forced landing.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.NTSB FTW95LA253Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Bigelow, ARThe pilot's failure to maintain clearance with terrain.NTSB FTW95LA254Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Cash, ARThe loss of engine power for undetermined reasons. Factors were the low altitude at which the power loss occurred and the lack of suitable terrain for a forced landing.NTSB SEA95LA119Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Helena, MTThe loss of engine power for undetermined reasons.NTSB ANC95LA110Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · King Salmon, AKThe pilot's inadequate compensation for the wind conditions during the landing approach, and his failure to maintain altitude/clearance from trees. A factor relating to the accident was: the gusty wind condition.NTSB FTW95LA392Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Springlake, TXThe loss of engine power due to the uncontained failure of the third stage turbine wheel. A factor was the lack of suitable terrain for the forced landing.NTSB MIA95LA132Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Zellwood, FLA loss of aircraft climb capability after the banner pickup for an undetermined reason. A factor related to the accident was: soft terrain in the emergency landing area.NTSB FTW95LA197Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Abbeville, LAThe inadvertent stall.NTSB SEA95LA094Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Stayton, ORA power loss for undetermined reason(s). A factor was the soft terrain.NTSB FTW95LA154Accident · No injuriesLimited investigationFinal reportBeech G18S · Springdale, AREngine compartment fire due to undetermined reasons.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.NTSB LAX95LA127Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Gaviota, CAinadequate maintenance and service of the aircraft's carburetor heat system, and the pilot's intentional flight into adverse weather conditions. The lack of a suitable area for the emergency landing was a factor.NTSB SEA95FA043Accident · 1 fatalField investigationFinal reportBeech E18S · Butte, MTThe pilot's failure to follow the IFR procedure by not maintaining the proper altitude prior to the initial appraoch fix. Factors to the accident were dark night conditions and a low ceiling.NTSB CHI95LA075Accident · No injuriesLimited investigationFinal reportBeech C45H · New Hudson, MIThe owner/pilot's inadequate maintenance practices which resulted in a loss of engine power shortly after takeoff and the pilot's inadequate emergency procedure after the power loss occurred. Related factors are trees, diminished airspeed and abrupt touchdown.NTSB CHI95LA053Accident · 1 fatalLimited investigationFinal reportBeech E18S · Kansas City, MOFailure of the pilot to maintain adequate airspeed on final approach, which resulted in an inadvertent stall/spin. Factors related to the accident were: the adverse weather (icing) conditions, the accumulation of airframe/wing ice, the pilot's improper use of…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.NTSB CHI94LA320Accident · Serious injuriesLimited investigationFinal reportWeatherly 201C · Stephen, MNimproper rigging of the parking brake control cable resulting in inadvertent application of the left wheel brake.NTSB CHI94LA323Accident · No injuriesLimited investigationFinal reportBeech D18S · Mt Pleasant, MIthe improper fuel selector position by the pilot-in-command which resulted in fuel starvation. A factor was rough/uneven terrain.NTSB FTW94LA270Accident · 1 fatalLimited investigationFinal reportGrumman G-164B · Shreveport, LAThe pilot's incapacitation due to a heart attack.NTSB ANC94FA105Accident · 3 fatalField investigationFinal reportDe Havilland DHC-2 · Port Alsworth, AKImproper in-flight planning/decision by the pilot, and his failure to remain clear of mountainous terrain. The box/blind canyon and proximity of mountainous terrain were related factors.NTSB LAX94LA313Accident · No injuriesLimited investigationFinal reportSchweizer G-164-A · Laton, CAfailure of the No.7 cylinder for an unspecified reason.NTSB FTW94LA267Accident · No injuriesLimited investigationFinal reportWeatherly 201C · Pampa, TXThe pilot's decision to takeoff from unsuitable terrain following the forced landing. A factor was fuel starvation induced power loss resultant from the pilot's failure to select the proper fuel tank.NTSB ATL94LA153Accident · No injuriesLimited investigationFinal reportNaval Aircraft Factory N3N-3 · Beaufort, SCThe pilot's improper use of the rudder during landing.NTSB ATL94LA152Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Vanceboro, NCThe pilot's improper use of wheel brakes.NTSB ATL94LA147Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Chamblee, GAThe fatigue failure of the left main landing gear shock absorbing strut that resulted in a loss of control.NTSB SEA94LA192Accident · No injuriesLimited investigationFinal reportGrumman G-21A · Bremerton, WAThe pilot-in-command's failure to maintain directional control during landing.NTSB SEA94LA193Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Wilder, IDThe failure of the left brake master cylinder and the pilot's inadequate remedial action when the aircraft collided with an embankment during an intentional ground loop.NTSB CHI94LA235Accident · No injuriesLimited investigationFinal reportBeech 17 · Elgin, NEthe pilot's failure to maintain clearance with the road sign. Factors in the accident were the sign and the failure of the landing gear to extend into the full down and locked position.NTSB ANC94LA082Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Kenai, AKThe pilot did not use the takeoff checklist to confirm that the flaps were extended for the takeoff.NTSB ANC94LA079Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Nondalton, AKThe pilot's inadequate compensation for the wind condition. A factor in the accident was the gusty wind condition.NTSB FTW94LA209Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Parkin, ARTotal power loss for undetermined reasons. A factor was unsuitable terrain for a forced landing.NTSB SEA94LA159Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-2 · Friday Harbor, WAThe pilot's accidental extension of his hand into the arc of the turning propeller. Factors include high winds during the docking process.NTSB CHI94DTG01Accident · No injuriesFinal reportGrumman G-164-A · La Moure, NDfailure of the pilot to maintain directional control.NTSB CHI94LA162Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Alexandria, NEThe pilot's failure to maintain clearance with wires.NTSB FTW94LA142Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Lindon, COInaccurate preflight planning and preparation for the flight. A factor was soft terrain on the landing strip.NTSB LAX94LA204Accident · No injuriesLimited investigationFinal reportBeech UC-45J · Acampo, CAThe pilot's failure to use carburetor heat during the extended power-off descent. The existing carburetor icing conditions, the pilot's diverted attention, and the power lines were factors in this accident.