NTSB investigations: Pratt & Whitney R-985 series, 2008, WA
3 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 per year
| 1964 | 1 |
|---|---|
| 1965 | 3 |
| 1966 | 2 |
| 1967 | 3 |
| 1968 | 1 |
| 1971 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1977 | 2 |
| 1978 | 1 |
| 1979 | 1 |
| 1981 | 2 |
| 1982 | 1 |
| 1983 | 2 |
| 1985 | 1 |
| 1987 | 1 |
| 1991 | 1 |
| 1994 | 2 |
| 1996 | 1 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 2 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2008 | 3 |
| 2009 | 1 |
| 2011 | 1 |
| 2015 | 1 |
| 2021 | 1 |
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 year(c.\"eventDate\") = 2008
AND c.\"eventStateOrRegion\" = 'WA' 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'))
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 year(c."eventDate") = 2008
AND c."eventStateOrRegion" = 'WA' 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'))
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 SEA08CA171Accident · No injuriesData collectionFinal reportde Havilland Beaver DHC-2 MK.1 · Kenmore, WAThe pilot's failure to maintain aircraft control while water taxiing. Contributing to the accident were the pilot's failure to compensate for the wind condition and a tailwind.NTSB SEA08CA093Accident · Minor injuriesData collectionFinal reportGrumman G-164A · Dayton, WAThe pilot's inadequate compensation for the wind conditions and failure to maintain an adequate airspeed. A contributing factor was the sudden windshift.NTSB LAX08CA082Accident · No injuriesData collectionFinal reportGrumman-Schweizer G-164B · Colfax, WAThe pilot's inadequate compensation for the wind conditions, failure to attain and maintain an adequate airspeed that resulted in a stall mush, and, the subsequent failure to maintain terrain and obstacle clearance during the takeoff initial climb.…