NTSB investigations: Pratt & Whitney R-985 series, 2014
6 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\") = 2014
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") = 2014
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 WPR14CA365Accident · Minor injuriesData collectionFinal reportEaland Charles Lionheart · Santa Maria, CAThe pilot's inadequate landing flare and subsequent loss of directional control during the landing roll.NTSB WPR14CA293Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G 164B · Marysville, CAThe pilot's failure to adequately monitor the environmental conditions to assure the aircraft performance would afford an uneventful takeoff with the loading conditions. Contributing to the accident were the pilot's inability to jettison the load due to the…NTSB CEN14LA319Accident · Minor injuriesLimited investigationFinal reportGrumman G 164 · Anadarko, OKThe total loss of engine power while climbing after takeoff for reasons that could not be determined based on the available information.NTSB ERA14LA321Accident · Minor injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G 164B · Farmington, DEThe pilot's inadequate preflight planning for a takeoff in high-density altitude conditions and his decision to reduce power during the initial climb, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.NTSB WPR14FA182Accident · 1 fatalField investigationFinal reportBoeing E75 · Fairfield, CAThe pilot's failure to maintain clearance from the runway during a low-level aerobatic maneuver due to his impairment by an over-the-counter antihistamine. Contributing to the severity of the pilot's injuries were the pilot's lack of fire protective clothing,…NTSB WPR14LA130Accident · No injuriesLimited investigationFinal reportGrumman G164 - A · Caruthers, CAAn undetected fatigue crack in the landing gear leg, which initiated at an electrical arc-induced damage site of undetermined origin and resulted in landing gear failure. Contributing to the severity of damage to the airplane was the close proximity of an…