NTSB investigations: Pratt & Whitney R-985 series
31 cases on aircraft whose registry engine model is Pratt & Whitney R-985 series, where the first occurrence was “In flight collision with terrain/water”. 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 per year
| 1982 | 2 |
|---|---|
| 1983 | 1 |
| 1984 | 4 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1994 | 2 |
| 1995 | 1 |
| 1996 | 4 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 2 |
| 2002 | 1 |
| 2003 | 1 |
| 2006 | 2 |
| 2007 | 2 |
Where
Open the mapLatest cases
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230))
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230))
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 ANC08CA002Accident · Minor injuriesData collectionFinal reportde Havilland DHC-2 · King Salmon, AKThe pilot's inadequate compensation for gusty wind conditions during the final approach to land, which resulted in the airplane colliding with terrain. A factor contributing to the accident was the gusty wind.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.NTSB ANC06LA109Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 MK.1 · Anaktuvuk Pass, AKThe pilot's failure to abort the takeoff at his predetermined reference point, which resulted in a collision with the shore during takeoff-initial climb, and structural damage to the airplane.NTSB CHI06CA162Accident · Minor injuriesData collectionFinal reportWeatherly 201B · Bowbells, NDThe pilot's failure to maintain clearance to the rising terrain while maneuvering during the agricultural application flight. Contirbuting factors were the low altitude operation and the rising terrain.NTSB SEA03LA034Accident · No injuriesLimited investigationFinal reportBeech E18S · Burlington, WAThe pilot's failure to adequately remove ice/frost from the aircraft and to maintain airspeed during the initial climb after takeoff. An inadequate preflight was a factor.NTSB FTW02FA195Accident · 1 fatalField investigationFinal reportBeech H-18 · Tatum, NMThe failure of the pilot to maintain clearance.NTSB FTW99LA182Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Iowa, LAThe pilot's failure to maintain clearance with the crops being sprayed. A factor was the pilot's diverted attention.NTSB SEA99LA079Accident · No injuriesLimited investigationFinal reportSnow S2C · Paul, IDThe pilot's inaccurate weight and balance calculations, and his delay in jettisoning the load which resulted in his failure to clear rising terrain. Contributing to the accident was the high density altitude, and the pilot's intentional operation with known…NTSB LAX98LA207Accident · Serious injuriesLimited investigationFinal reportNaval Aircraft Factory N3N-3 · Skull Valley, AZThe pilot's failure to maintain control of the aircraft while maneuvering at a low altitude.NTSB CHI97LA211Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Springfield, ILfailure of the pilot to maintain safe altitude/clearance from the terrain. Factors relating to this accident were: the hazy weather condition, the resultant difficulty in keeping the other airplane in sight, and the pilot's diverted attention, while looking…NTSB MIA97LA198Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Bainbridge, GAthe pilot's failure to maintain proper airspeed during the initial climb after takeoff, and improper flare during an emergency (precautionary) landing, which resulted in a hard touchdown and subsequent nose over. Factors related to the accident were: the…NTSB ANC96FA101Accident · 1 fatalField investigationFinal reportde Havilland DHC-2 · Elfin Cove, AKThe pilot's decision to continue VFR flight into instrument meteorological conditions, and his failure to maintain adequate clearance from rising terrain. Factors associated with the accident were the rising terrain and clouds.NTSB IAD96LA113Accident · No injuriesLimited investigationFinal reportBoeing Stearman E75N1 · Goshen, OHthe pilot's failure to maintain adequate clearance from terrain during short final approach/landing flare. The hot temperature was a related factor.NTSB SEA96LA112Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Prescott, WAfailure of the pilot to visually clear his flight path, after allowing his attention to be diverted, and his resultant failure to maintain sufficient altitude/clearance from a hill. The hilly terrain was a related factor.NTSB SEA96LA054Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Ashland, ORthe dual student's improper touchdown, and the instructor's delayed remedial action. The crosswind was a related factor.NTSB FTW95LA253Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Bigelow, ARThe pilot's failure to maintain clearance with terrain.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 ANC94GA041Accident · Minor injuriesFinal reportGrumman G21A · Mt. Fairweather, CanadaThe pilot's improper decision in attempting to outclimb the rising terrain with the existing airplane climb performance. Factors which contributed to the accident were: the pilot's inadequate preflight of the airplane, the over maximum gross weight of the…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 FTW90DRD14Accident · 1 fatalFinal reportGrumman G-164A · Sommerset, LAThe pilot's failure to attain adequate clearance above crops at the end of the runway.NTSB ANC89LA123Accident · Serious injuriesLimited investigationFinal reportDe Havilland DHC-2 · Kodiak, AKPilot-in-command's continued VFR flight into know IFR flt conditions, resulting in a collision with rising terrain.NTSB FTW88DRA14Accident · No injuriesFinal reportGrumman G-164B · College Port, TXAcft was substantially damaged when it executed an off-arpt landing following takeoff FR0M a wet sod strip on an ag flt. The plt stated that he was taking off to the north and that during the t/o roll the wind shifted to out of the south. He further stated…NTSB DEN87MA168Accident · 10 fatalMajor investigationFinal reportBeech D18S · Lakeside, MTThe plt borrowed the acft to fly a musical group to kalispell for a pvt engagement at Lakeside, MT, which was aprx 15 mi south of the arpt. That evening, the group boarded the acft for the return flt. After takeoff, the acft was seen flying at low alt in the…NTSB DEN86LA222Accident · No injuriesLimited investigationFinal reportBoeing E75 · Tooele, UTThe plt rprtd that he encountered a downdraft while crossing a ridgeline in mountainous terrain, aprx 5 mi NE of Tooele,UT. The elev of the acdnt site was about 9,000 ft & the temp was rprtd by the plt to be 80 deg. This would have resultedin a density alt of…NTSB ANC85LA006Accident · No injuriesLimited investigationFinal reportBeech 3NM · Selawik, AKMaintaining visual separation with other acft, flying a straight-in apch instead of a conventional pattern, and concern over the landing on a short strip interfered with the plt's habit pattern. The gear was not extended and the gear-up landing resulted.NTSB DEN84LA253Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Arthur, NDAcft flown at high gross weight in high density altitude conditions. The plt said takeoff pwr was added too late to stopthe descent at the start of a spray run.NTSB MKC84FCA01Accident · Serious injuriesFinal reportGrumman-Schweizer G-164A · Neelyville, MOThe plt stated that after takeoff & two miles from the destination airport, the plt started a 180 deg turn to the rt to return to the takeoff strip. Approx halfway through the turn at 45 deg of bank, the rt wing pitched downward & he was unable to correct by…NTSB MKC84LA143Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Silver Creek, NEThe plt stated he was making an end pass while spraying a pasture & collided with a hilltop on the opposite side of a draw. This occurred while the sun was obstructing his vision.NTSB DEN83LA166Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Thompson, NDThe acft crashed during descent for the first swath run. Investigation revealed that the pilot applied back pressure to the control stick to flare from the descent. The acft did not respond and continued to descend. The impact was hard enough to tear the left…NTSB LAX83FUG02Accident · No injuriesFinal reportWaco SRE · Redlands, CADuring landing into a sun low on the horizon the acft drifted left & touched down slightly off the rwy. The left gear caught a construction hole & sheared off. The acft went out of control & struck a rock pile shearing the right gear off. The rwy recently had…NTSB DEN82DTK05Accident · No injuriesFinal reportGrumman G-164 · Murdo, SDDuring a spraying operation the landing gear collided with a dirt bank. The pilot returned to the airport and during landing the right wing contacted the runway because of a missing right landing gear. The aircraft ground looped and nosed over.