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 LAX92LA259Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Robbins, CAThe failure of the pilot to maintain an adequate wing tip clearance between the aircraft and a dirt bank paralleling the airstrip.NTSB ATL92LA127Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Dunn, NCThe pilot's inadequare visual lookout to see and avoid the 8 foot high pole adjacent to the landing strip.NTSB FTW92DPG02Accident · Minor injuriesFinal reportGrumman G-164-B · Mcdougal, ARThe pilots failure to properly plan his take off. A factor was his lack of familiarity with the chemical dispensing equipment.NTSB NYC92LA102Accident · No injuriesLimited investigationFinal reportGrumman 164A · Bridgeton, NJThe pilot's improper application of takeoff power which resulted in a lengthened takeoff roll, and his subsequent steep turn to avoid an obstacle causing the airplane to stall at a low altitude.NTSB FTW92LA137Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Kinder, LAThe failure of the left brake which led to a loss of directional control. A factor was the rough terrain immediately adjacent to the runway.NTSB DEN92LA049Accident · Minor injuriesLimited investigationFinal reportNaval Aircraft Factory N3N-3 · Montrose, COFailure of the pilot in command to maintain control of the aircraft during landing roll. A factor was: the aircraft struck a ditch which ran parallel to the runway.NTSB LAX92MA184Accident · 9 fatalClass 1 · MajorFinal reportBeech E18S · Mount Haleakala, HIThe captain's decision to continue visual flight into instrument meteorological conditions that obscured rising mountainous terrain and his failure to properly use available navigational information to remain clear of the island of maui. Contributing to the…NTSB LAX92LA177Accident · No injuriesLimited investigationFinal reportBeech E18S · Eloy, AZFailure of the pilot-in-command to maintain directional control and to properly compensate for the unfavorable wind conditions encountered during the takeoff ground run. Contributing to the accident was the unforecasted dust devil weather phenomena.NTSB FTW92LA103Accident · No injuriesLimited investigationFinal reportSnow S2C · Roby, TXThe pilot's inadvertent stall of the airplane while maneuvering and subsequent loss of control.NTSB FTW92LA101Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Weatherford, OKFuel starvation due to a mechanical failure of the fuel selector. A factor was the lack of suitable terrain.NTSB FTW92LA093Accident · Serious injuriesLimited investigationFinal reportBoeing A-75N1 · Edna, TXThe pilot's failure to maintain control of the airplane and the subsequent stall. A factor was the pilot's diversion of attention.NTSB LAX92LA116Accident · No injuriesLimited investigationFinal reportBeech D-18H · Lanai, HIFailure of the pilot to compensate for an encounter with a windshear phenomena. Contributing to the accident was the lack of a low level windshear warning system or a system for the collection and dissemination of weather advisories.NTSB LAX92LA042Accident · No injuriesLimited investigationFinal reportBeech D18S · Hilo, HIThe aircraft's lack of single engine performance to maintain altitude after the engine lost power. Factors related to the accident were: displacement/mechanical interference within the accessory drive gear system of the left engine, failure of the left engine…NTSB LAX92LA028Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Pauma, CAFuel starvation due to a restricted fuel tank vent line. Contributing to the accident was inadequate maintenance.NTSB FTW92LA003Accident · No injuriesLimited investigationFinal reportBeech C-45H · Edinburg, TXPower loss due to a loss of oil pressure for undetermined reasons. A factor was the lack of suitable terrain for forced landing.NTSB LAX91LA413Accident · Minor injuriesLimited investigationFinal reportGrumman G164A-450 · Queen Creek, AZFailure of the engine cylinder, producing a loss of power. Contributing to the accident was the location of an irrigation ditch next to the landing area and a dark night light condition.NTSB ANC91LA153Accident · Minor injuriesLimited investigationFinal reportDe Havilland DHC-2 MKI · Holitna River, AKThe airplane's float hit a submerged log during landing on the River, which resulted in the pilot losing control of the airplane and crashing into the water.NTSB ANC91LA133Accident · No injuriesLimited investigationFinal reportBeech B-18H · White Mountain, AKThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB CHI91DEP12Accident · No injuriesFinal reportSchweizer G-164-A · Elkhorn, WIThe pilot in command's failure to maintain adequate altitude.NTSB CHI91DTG08Accident · No injuriesFinal reportGrumman G164B · Minto, NDInadequate aircraft servicing, inadequate aircraft preflight, fuel contamination, and unsuitable soft terrain in which to effect an emergency landing.NTSB ANC91LA125Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-2 · Ugashik, AKWas the pilot-in-command's failure to maintain directional control of the airplane during the takeoff run. Contributing to the accident was the rough water.NTSB ANC91IA102Incident · No injuriesIncident investigationFinal reportDe Havilland DHC2 MK1 · Iliamna, AKThe pilot-in-command's attempted flight into known adverse weather conditions. Contributing to the accident was the high and gusty winds in the accident area.NTSB ATL91LA132Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Social Circle, GAThe airplane collided with the steel pole which supports the windsock while the pilot maneuvered to avoid a collision with a deer on the runway.NTSB LAX91LA299Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Crows Landing, CAThe pilot Landing his airplane erroneously on the wrong Landing surface. Factors in this accident were: sunglare and its interference with the pilot's vision and the soft terrain.NTSB LAX91LA283Accident · No injuriesLimited investigationFinal reportBoeing E75 · San Luis Obispo, CAThat the pilot failed to properly compensate of the existing quartering tailwind, improperly using the flight controls and brakes.NTSB CHI91DCJ03Accident · No injuriesFinal reportGrumman G-164-A · Edgar, NEThe pilot's inadequate aircraft preflight inspection.NTSB CHI91DTG03Accident · No injuriesFinal reportSchweizer G164 · Gwinner, NDInadvertent closing of the mixture by the pilot. Factors related to the accident are inadequate control shape, or size, and inattentiveness of the pilot.NTSB DEN91LA086Accident · No injuriesLimited investigationFinal reportNaval Aircraft Factory N3N-3 · Deming, NMThe pilot's failure to maintain directional control. Factors were: a crosswind condition and a soft shoulder alongside the runway.NTSB LAX91LA228Accident · No injuriesLimited investigationFinal reportBeech C-45H · Lake Elsinore, CAFuel starvation due to an improper modification of the fuel system and the pilot's failure to ensure that the aircraft was airworthy prior to flight.NTSB FTW91DPG10Accident · No injuriesFinal reportWeatherly 201B · Mc Crory, ARLoss of the outboard portion of the propeller blade. A factor was the lack of suitable terrain for the forced landing.NTSB DEN91LA073Accident · No injuriesLimited investigationFinal reportBeech D18-S · Englewood, COThe loss of directional control by the pilot. Factors were: the cross, failure of the pilot to lock the tail wheel, and the pilot's disregard of crosswind limitations.NTSB LAX91LA214Accident · Minor injuriesLimited investigationFinal reportGrumman G164B · Yuba City, CAFatigue in the propeller blade which led to its ultimate failure. Factors relating to this accident were the soft terrain conditions on which the airplane landed and a berm across the airplane's ground path.NTSB MIA91WA134Incident · No injuriesForeign investigationBeech TC-45J · Nassau, BahamasNTSB LAX91LA186Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Madera, CAFailure of the pilot to maintain adequate clearance from the guy wire.NTSB SEA91LA086Accident · No injuriesLimited investigationFinal reportGrumman G-21A · Spokane, WAThe pilot-in-command did not maintain directional control of the airplane. Factors were: the pic's inadequate compensate for the wind, his limited flight expereince in this type of airplane, and the check airman's poor supervision.NTSB FTW91DPG03Accident · No injuriesFinal reportGrumman G-164A · Earle, ARA power loss for undetrmined reasons. A factor was the muddy/soft terrain in which the forced landing was performed.NTSB ANC91LA032Accident · Serious injuriesLimited investigationFinal reportDe Havilland DHC-2 · Finger Lake, AKThe pilot's failure to maintain directional control of the airplane during the landing roll. A factor was the rough and uneven terrain.NTSB LAX91LA088Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Merced, CAA disoriented and intoxicated automobile driver entering the runway in front of the departing aircraft.NTSB CHI91LA004Accident · No injuriesLimited investigationFinal reportBeech E-18 · Minneapolis, MNFailure of the pilot-in-command to maintain directional control of the aircraft during landing roll.NTSB ATL90LA181Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Minturn, SCA previously fractured main wheel which had resulted from a hard landing. A factor in the accident was inadequate inspection by the operator.NTSB SEA90LA196Accident · Minor injuriesLimited investigationFinal reportBeech C-45H · Twin Falls, IDThe pilot's inability to maintain directional control during a takeoff in strong crosswind conditions.NTSB DEN90LA186Accident · Minor injuriesLimited investigationFinal reportBeech D17S · Englewood, COImproper planning/decision by the pilot and inadequate visual lookout by the vehicle driver, which resulted in their failure to assure clearance between the vehicle and aircraft. Factors related to the accident were: sunglare and the pilot's restricted view…NTSB ATL90LA171Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Americus, GAA low cycle fatigue failure of the left main landing gear spring.NTSB ANC90LA169Accident · No injuriesLimited investigationFinal reportBeech H-18S · Deering, AKThe pilot-in-command's failure to maintain directional control of the airplane on landing.NTSB CHI90LA256Accident · Serious injuriesLimited investigationFinal reportBoeing B75N1 · Marseilles, ILThe pilot-in-command's failure to maintain adequate visual outlook to avoid collision with a wire while conducting intentional low level flight.NTSB ANC90LA162Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-2 · Alagnak River, AKThe pilot-in-command's inadequate preflight planning/preparation, his selection of unsuitable terrain, and his delay in aborting the takeoff.NTSB CHI90LA223Accident · No injuriesLimited investigationFinal reportStearman E-75 · Mt. Grove, MOThe pilot's inadequate maintenance and servicing of the aircraft. A factor was water contamination in fuel tank.NTSB CHI90LA206Accident · No injuriesLimited investigationFinal reportBeech D17S · Oelwein, IAInadequate visual outlook by the pilot in command.NTSB FTW90DRD14Accident · 1 fatalFinal reportGrumman G-164A · Sommerset, LAThe pilot's failure to attain adequate clearance above crops at the end of the runway.NTSB ANC90LA102Accident · Minor injuriesLimited investigationFinal reportGrumman G21 · King Salmon, AKThe pilot failed to adequately compensate for the prevailing wind conditions and his failure to maintain directional control. A contributing factor was the strong crosswind component.