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 GAA20CA007Accident · No injuriesData collectionFinal reportDe Havilland Beaver DHC 2 · Kodiak, AKThe pilot's failure to maintain lateral control while landing on glassy water, which resulted in the left float touching the water, a loss of yaw control, and impact with a riverbank.NTSB GAA19CA562Accident · No injuriesData collectionFinal reportDe Havilland Beaver DHC 2 MK.1 · Kotzebue, AKThe pilot's delayed decision to abort the takeoff from water after the airplane impacted a submerged object, which resulted in insufficient airspeed for liftoff and led to the pilot steering the airplane toward a mud embankment to avoid rocks.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.NTSB CEN19FA278Accident · 1 fatalField investigationFinal reportGrumman G164 · Hays, KSThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.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.NTSB ANC19FA035Accident · 1 fatalClass 2 · FieldFinal reportDe Havilland Beaver DHC 2 · Seldovia, AKThe airplane's floats impact with an ocean wave or swell, which exceeded the design load specifications of the flying wire assemblies and resulted in a partial separation of the float assemblies.NTSB ANC19LA028Accident · No injuriesClass 3 · LimitedFinal reportDe Havilland DHC-2 · Ketchikan, AKA loss of directional control while landing, which resulted in a water loop.NTSB ANC19FA019Accident · 2 fatalClass 2 · FieldFinal reportDe Havilland DHC 2 · Metlakatla, AKThe pilot’s inadequate compensation for a quartering tailwind during a water landing, which resulted in a loss of control and subsequent nose-over. Contributing to the accident was the company’s inadequate operational control of the flight release process,…NTSB GAA19CA009Accident · No injuriesData collectionFinal reportStearman A75N1(PT17) · New Orleans, LAThe pilot’s failure to maintain directional control during a crosswind landing.NTSB GAA18CA581Accident · Minor injuriesData collectionFinal reportDe Havilland DHC 2 MK. I(L20A) · Kukaklek Lake, AKThe pilot’s failure to see and avoid a sand bar during a water takeoff, which resulted in the airplane impacting a river bank.NTSB GAA18CA565Accident · Minor injuriesData collectionFinal reportDe Havilland DHC 2 · Igiugig, AKThe pilot’s selection of an empty fuel tank for takeoff, which resulted in fuel starvation and the subsequent total loss of engine power.NTSB CEN18LA360Accident · No injuriesLimited investigationFinal reportStearman A75N1(PT17) · Kenosha, WIThe failed retaining bolt and cracked backing plate, which resulted in a shift of the brake lining to contact the brake drum and a subsequent wheel lock when the brakes were applied.NTSB CEN18LA357Accident · No injuriesLimited investigationFinal reportGrumman G164 · Opelousas, LAThe loss of two securing bolts that allowed the left magneto to move around, which disrupted the spark timing and resulted in the engine losing total power.NTSB ANC18FA063Accident · 5 fatalField investigationFinal reportDe Havilland DHC-2 · Talkeetna, AKImpact with terrain for reasons that could not be determined because the airplane was not recovered due to the inaccessible nature of the accident site.NTSB ANC18FA055Accident · 1 fatalClass 2 · FieldFinal reportDe Havilland DHC-2 · Willow, AKThe pilot's exceedance of the airplane's critical angle of attack during departure climb, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's improper decision to load the airplane beyond its allowable gross weight and center…NTSB ANC18LA047Accident · Serious injuriesLimited investigationFinal reportDehavilland DHC-2 · Dillingham, AKThe pilot's failure to maintain directional control while landing in gusting wind conditions.NTSB GAA18CA372Accident · Minor injuriesData collectionFinal reportBeech D17 · Hamilton, MTThe pilot’s failure to maintain directional control during the landing roll and his subsequent inability to recover due to his foot being stuck.NTSB CEN18LA226Accident · Serious injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G 164B · Arrey, NMThe pilot's failure to maintain clearance from a hillside during an agricultural application flight while facing the sun.NTSB CEN18FA192Accident · 1 fatalField investigationFinal reportBeech D17S · Santa Fe, NMThe pilot's failure to maintain clearance from terrain for reasons that could not be determined based on the available information.NTSB ERA18LA086Accident · Minor injuriesClass 3 · LimitedFinal reportStearman B75 · Zephryhills, FLThe pilot's inadequate preflight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power and impact with a pole during a forced landing.NTSB ANC18LA025Accident · No injuriesLimited investigationFinal reportDehavilland Beaver DHC 2 · Kodiak, AKThe pilot's failure to maintain directional control during landing for reasons that could not be determined based on the available evidence.NTSB CEN17LA301Accident · No injuriesLimited investigationFinal reportBeech D17S · Colorado Springs, COThe pilot's failure to maintain directional control during the landing roll with a quartering tailwind.NTSB GAA17CA443Accident · Minor injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G 164B · Berlin, MDThe ground crewman’s failure to visually check the runway before crossing it in a vehicle, which resulted in he and the vehicle being struck by the landing airplane.NTSB ERA17CA251Accident · No injuriesData collectionFinal reportWeatherly 620 · Pemberton Twp, NJAn in-flight collision with a bird during takeoff, which resulted in a partial loss of engine power and subsequent collision with trees and terrain.NTSB ANC17LA032Accident · Minor injuriesClass 2 · LimitedFinal reportDehavilland DHC-2 · Ketchikan, AKThe pilot's misjudgment of the takeoff distance needed to depart the lake, and his subsequent failure to maintain clearance from the water during a turn to avoid terrain, which resulted in impact with water.NTSB GAA17CA330Accident · No injuriesData collectionFinal reportBoeing B75N1 · Williamson, GAThe pilot’s aggressive and early forward stick application during the landing roll, which resulted in his failure to maintain pitch control and a subsequent nose-over.NTSB WPR17LA100Accident · No injuriesLimited investigationFinal reportGrumman G164 · Madera, CAThe pilot’s loss of directional control during takeoff with a quartering tailwind, which resulted in a runway excursion and separation of the right landing gear.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.NTSB GAA17CA225Accident · No injuriesData collectionFinal reportWeatherly 620B · Lewistown, MTThe pilot’s failure to maintain altitude during low-altitude maneuvers in flat light conditions.NTSB ANC17LA017Accident · Minor injuriesLimited investigationFinal reportBeech G18 · Metlakatla, AKAn engine power loss for reasons that could not be determined because the airplane was not recovered.NTSB CEN17LA038Accident · No injuriesLimited investigationFinal reportWeatherly 620B · Coleman, TXThe pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB GAA17CA044Accident · No injuriesData collectionFinal reportBeech D18S · Deming, NMThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion.NTSB WPR16FA169Accident · 1 fatalField investigationFinal reportBoeing A75N1(PT17) · Madras, ORThe pilot's failure to maintain clearance from the runway during a low-level aerobatic maneuver. Contributing to the accident was a high density altitude and the pilot's failure to plan/adequately compensate for high density altitude conditions.NTSB GAA16CA429Accident · No injuriesData collectionFinal reportConsolidated Vultee BT13 · Joseph, ORThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and damage to the left aileron and elevator.NTSB ANC16LA054Accident · Serious injuriesLimited investigationFinal reportDe Havilland Beaver DHC-2 · Iliamna, AKThe pilot's decision to perform the takeoff despite calculations showing that the distance available was inadequate, which resulted in impact with terrain.NTSB GAA16CA384Accident · Minor injuriesData collectionFinal reportBoeing A75 · St. James, MOThe pilot's loss of control while performing an aerobatic maneuver resulting in an inadvertent spin and collision with trees and terrain.NTSB GAA16CA249Accident · No injuriesData collectionFinal reportBoeing B75 · El Cajon, CAThe pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a runway excursion and nose over.NTSB GAA16CA200Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G 164 · Madison, KSThe pilot's incorrect brake application during the landing roll, which resulted in a nose over.NTSB GAA16CA146Accident · Minor injuriesData collectionFinal reportBeech D17 · Brighton, COThe pilot's failure to maintain the runway course during takeoff, resulting in the airplane drifting to the left and impacting a fence. A contributing factor to the accident was the pilot's diverted attention during the takeoff.NTSB ERA16CA057Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Farmington, DEBoth pilots' failure to maintain visual separation during landing at an uncontrolled airport. Contributing to the accident was the Mooney pilot's lack of prompt evasive action once the biplane had been spotted on the same runway. In addition, the biplane…NTSB GAA15CA294Accident · No injuriesData collectionFinal reportHoward DGA 15P · Englewood, COThe separation of the elevator control system linkage at a push/pull tube and cable joint, for an unknown reason, because the bolt and associated hardware securing the joint was not found for examination.NTSB ANC15CA075Accident · No injuriesData collectionFinal reportDehavilland Beaver DHC 2 MK.1 · Arctic Village, AKThe pilot's selection of an unsuitable, off-airport site, which resulted in a nose over.NTSB CEN15LA399Accident · 1 fatalLimited investigationFinal reportWeatherly 620B · Hancock, WIThe in-flight failure of the left wing lower forward attach point under normal loading conditions due to corrosion and fatigue cracking in the center section hinge brackets. Contributing to the accident was the operator's inadequate maintenance and overweight…NTSB ERA15LA314Accident · No injuriesLimited investigationFinal reportGrumman G164 · Trenton, NCThe pilot's decision to land the airplane with a tailwind and his subsequent application of excessive braking, which resulted in a nose-over.NTSB GAA15CA171Accident · No injuriesData collectionFinal reportWeatherly 620B · Hatch, NMThe pilot failed to maintain obstacle clearance, and the airplane struck a transmission line wire during aerial application operations.NTSB GAA15CA145Accident · No injuriesData collectionFinal reportBeech D17S · Idaho Falls, IDWhile taxiing as a flight of two, the pilot of the blue Beechcraft became distracted and impacted the red Beechcraft which had stopped.NTSB GAA15CA169Accident · No injuriesData collectionFinal reportWeatherly 201B · Pemberton, NJThe pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane's left main landing gear impacting an unknown object, and subsequent collapse during landing.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.NTSB CEN15LA272Accident · Serious injuriesLimited investigationFinal reportWeatherly 620A · Van Horn, TXThe loss of engine power for reasons that could not be determined based on the available information.NTSB CEN15LA271Accident · Minor injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G 164B · Foster, NEThe total loss of engine power during a low-level aerial application flight due to fuel exhaustion following the pilot’s inadequate preflight inspection that led to his assumption that sufficient fuel was on board for the flight based on his reliance on a…