NTSB investigations: Pratt & Whitney R-985 series, 2012
12 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
| 1962 | 2 |
|---|---|
| 1963 | 1 |
| 1964 | 61 |
| 1965 | 68 |
| 1966 | 58 |
| 1967 | 75 |
| 1968 | 54 |
| 1969 | 71 |
| 1970 | 58 |
| 1971 | 50 |
| 1972 | 52 |
| 1973 | 68 |
| 1974 | 70 |
| 1975 | 54 |
| 1976 | 70 |
| 1977 | 58 |
| 1978 | 62 |
| 1979 | 48 |
| 1980 | 41 |
| 1981 | 49 |
| 1982 | 43 |
| 1983 | 40 |
| 1984 | 35 |
| 1985 | 26 |
| 1986 | 20 |
| 1987 | 26 |
| 1988 | 18 |
| 1989 | 26 |
| 1990 | 25 |
| 1991 | 26 |
| 1992 | 30 |
| 1993 | 26 |
| 1994 | 28 |
| 1995 | 26 |
| 1996 | 24 |
| 1997 | 24 |
| 1998 | 14 |
| 1999 | 23 |
| 2000 | 17 |
| 2001 | 13 |
| 2002 | 15 |
| 2003 | 15 |
| 2004 | 16 |
| 2005 | 21 |
| 2006 | 13 |
| 2007 | 16 |
| 2008 | 19 |
| 2009 | 13 |
| 2010 | 16 |
| 2011 | 14 |
| 2012 | 12 |
| 2013 | 9 |
| 2014 | 6 |
| 2015 | 13 |
| 2016 | 9 |
| 2017 | 9 |
| 2018 | 13 |
| 2019 | 9 |
| 2020 | 3 |
| 2021 | 8 |
| 2022 | 5 |
| 2023 | 10 |
| 2024 | 12 |
| 2025 | 7 |
| 2026 | 4 |
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\") = 2012
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") = 2012
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 ANC13CA018Accident · No injuriesData collectionFinal reportDehavilland DHC-2 MK. I(L20A) · Skwentna, AKThe pilot's loss of control while landing in gusting wind conditions.NTSB WPR13CA031Accident · No injuriesData collectionFinal reportBeech D17S · Van Nuys, CAThe pilot of another airplane did not maintain a proper visual lookout during taxi, which resulted in an on-ground collision.NTSB ANC12CA092Accident · Minor injuriesData collectionFinal reportDehavilland Beaver U-6 · Kenai, AKThe pilot’s failure to maintain adequate ground clearance during his landing approach, which resulted in a collision with terrain.NTSB CEN12FA534Accident · 1 fatalField investigationFinal reportBeech G18 - S · Taylorville, ILThe pilot's failure to maintain adequate airspeed and use the appropriate flaps setting during sport-parachuting operations, which resulted in an aerodynamic stall/spin and a subsequent loss of control. Contributing to the accident was the pilot’s failure to…NTSB CEN12LA514Accident · Minor injuriesLimited investigationFinal reportWeatherly 620B · Holcomb, KSThe pilot's failure to use carburetor heat while operating in conditions conducive to carburetor icing, which resulted in a partial loss of engine power shortly after takeoff.NTSB CEN12LA458Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Egeland, NDThe partial loss of engine power for reasons that could not be determined during postaccident examinations.NTSB ANC12CA060Accident · No injuriesData collectionFinal reportDehavilland Beaver DHC-2 · Ketchikan, AKThe pilot’s failure to maintain directional control during a step turn on floats.NTSB ANC12LA051Accident · No injuriesLimited investigationFinal reportDehavilland DHC-2 · Talkeetna, AKThe loss of engine power after departure due to the separation of an engine cylinder.NTSB WPR12CA242Accident · No injuriesData collectionFinal reportGrumman G-164A · Riverton, WYThe pilot's loss of directional control during the landing roll and his deliberate application of excessive braking pressure, which resulted in a noseover.NTSB ANC12CA041Accident · No injuriesData collectionFinal reportDehavilland DHC-2 MK. I(L20A) · Talkeetna, AKThe pilot inadvertently landed with the parking brake set.NTSB WPR12LA201Accident · Minor injuriesLimited investigationFinal reportBeech 3NM · Pope Valley, CAA loss of power in one engine during takeoff, which resulted in a forced landing in a vineyard. The reason for the loss of engine power could not be determined from the available evidence.NTSB ANC12LA026Accident · Serious injuriesLimited investigationFinal reportDehavilland Beaver DHC-2 · Ketchikan, AKThe pilot's decision to depart in marginal visual meteorological conditions, and his continued visual flight into instrument meteorological conditions.