NTSB investigations: Pratt & Whitney R-2800 series, 1985
4 cases on aircraft whose registry engine model is Pratt & Whitney R-2800 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 | 4 |
|---|---|
| 1963 | 2 |
| 1964 | 6 |
| 1965 | 8 |
| 1967 | 7 |
| 1968 | 4 |
| 1969 | 3 |
| 1970 | 1 |
| 1972 | 1 |
| 1973 | 3 |
| 1974 | 3 |
| 1975 | 7 |
| 1976 | 2 |
| 1977 | 2 |
| 1978 | 1 |
| 1979 | 7 |
| 1980 | 7 |
| 1982 | 4 |
| 1983 | 4 |
| 1984 | 2 |
| 1985 | 4 |
| 1990 | 1 |
| 1993 | 3 |
| 1994 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 2 |
| 2003 | 1 |
| 2004 | 2 |
| 2005 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 2 |
| 2013 | 3 |
| 2014 | 2 |
| 2016 | 3 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 4 |
| 2022 | 1 |
| 2024 | 1 |
| 2025 | 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\") = 1985
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52026'))
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") = 1985
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52026'))
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 ANC85FA118Accident · Minor injuriesField investigationFinal reportDouglas DC-6A · Egegik, AKAirplane accelerated to v 1 and struck through on sandy beach. The nose pitched up and the pilot lost directional control. The airplane struck adjacent bank caught fire. It was totally destroyed.NTSB DCA85AA023Accident · Serious injuriesFinal reportGeneral Dynamics 240-27 · West Trenton, NJThe coplt bgn takeoff (tkof) with 2700 RPM & 52 to 53.5' of manifold pressure (mp). Wtr injection was not used altho 12 gal was available. At 150 to 250 ft AGL, the l eng lost pwr & the l prop autofeathered. The capt took control (ctl) & took action to verify…NTSB LAX85LA235Accident · No injuriesLimited investigationFinal reportLockheed PV-2 · Mesa, AZFollowing a dural engine chang, the plt test flew the acft. On initial climb, at about 500 ft AGL, both engines began backfiring violently & lost power. According to the plt, power sufficient for flt could not be obtained, & a forced ldg was made about 0.75…NTSB ANC85LA057Accident · No injuriesLimited investigationFinal reportCurtiss C-46R · Nulato, AKThe acft continued off the end of the rwy and contacted a snow berm during the landing roll. The plt reported the rwy braking action as poor.