NTSB investigations: Pratt & Whitney R-985 series, AK
16 cases on aircraft whose registry engine model is Pratt & Whitney R-985 series, where the first occurrence was “Loss of control - on ground/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
| 1985 | 1 |
|---|---|
| 1986 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1990 | 2 |
| 1991 | 3 |
| 1993 | 1 |
| 1998 | 1 |
| 2000 | 2 |
| 2004 | 1 |
| 2005 | 1 |
| 2007 | 1 |
Where
Latest 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.\"eventStateOrRegion\" = 'AK' 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')
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\" = 260))
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" = 'AK' 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')
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" = 260))
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 ANC07CA053Accident · No injuriesData collectionFinal reportGrumman G21A · Dutch Harbor, AKThe pilot's inadequate compensation for wind conditions during the takeoff roll, which resulted in a loss of directional control and a nose over.NTSB ANC05LA082Accident · No injuriesLimited investigationFinal reportdeHavilland DHC-2 · King Salmon, AKThe pilot's failure to correct for torque/P-Factor during the takeoff run, and his delay in aborting the takeoff, which resulted in a loss of directional control and subsequent wing collision with the surface of the water. A factor contributing to the…NTSB ANC04LA038Accident · No injuriesLimited investigationFinal reportGrumman G21 · Unalaska, AKThe inadvertent ground loop/swerve by the second pilot during the landing roll, and the first (check) pilot's inadequate supervision of the second pilot, which resulted in a loss of control and substantial damage to the airplane. Factors associated with the…NTSB ANC00LA098Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · King Salmon, AKThe pilot's inadequate compensation for crosswind conditions.NTSB ANC00LA091Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Big Lake, AKThe pilot's inadequate compensation for the wind conditions. A factor associated with the accident was a crosswind.NTSB ANC98LA157Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Iliamna, AKThe pilot's inadequate compensation for the gusty wind conditions, and his attempted flight into adverse weather. Factors associated with the accident are high and gusty winds.NTSB ANC93IA026Incident · No injuriesIncident investigationFinal reportGrumman G-21A · Akutan, AKThe incident was caused by the pilots improper compensation for the winds. Factors were the microburst, the rough water, and the pilot's inadequate evaluation of the weather conditions.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 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 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 ANC90LA169Accident · No injuriesLimited investigationFinal reportBeech H-18S · Deering, AKThe pilot-in-command's failure to maintain directional control of the airplane on landing.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.NTSB SEA89LA124Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Kassan, AKThe excessive taxi speed used by the pilot in the existing weather conditions. Contributing to the accident was the gusty tailwind.NTSB ANC87LA120Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Chackachatna Ri, AKThe pilot stated after he touched down on the gravel bar he lost directional control of the aircraft causing the aircraft to strike a log. The airplane then went up on its nose.NTSB ANC86LA167Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Fognak Island, AKOn takeoff, the right door popped open. The pilot reached across to pull the door closed and lost directional control of the aircraft. The aircraft then struck a tree near the bank of the lake.NTSB ANC85LA104Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Ungalikthluk Rv, AKThe plt reported that when he was landing the float plane on a river, an extreme gust of wind cocked the acft causing loss of control. Subsequently, the acft struck a river bank & was damaged. The plt noticed that after the landing, the winds had changed,…