NTSB investigations: Pratt & Whitney R-985 series, AK
7 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
| 1984 | 1 |
|---|---|
| 1989 | 1 |
| 1991 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 2006 | 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\" = 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."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" = 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 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 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 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 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 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 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.