NTSB investigations: Pratt & Whitney R-2800 series, 1982
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\") = 1982
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") = 1982
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 ANC82DA101Accident · No injuriesFinal reportFairchild C-82A · Karluk, AKThe pilot reported that during arrival, the approach to landing seemed normal until just before touchdown. The aircraft touched down short of the runway threshold marks on relatively steep terrain in the safety zone. The pilot estimated that the touchdown…NTSB NYC82DA114Accident · No injuriesFinal reportDouglas RB-26C · Dubois, PAThe aircraft was being ferried to its home base in Montana. During a landing to refuel, the left main gear collapsed after the aircraft had rolled about 2500 ft and had slowed to about 30 to 40 KTS. An inspection revealed that the left main gear beam mounting…NTSB CHI82DA191Accident · No injuriesFinal reportConvair 240 · Detroit, MIThe captain stated that during an ILS approach, he saw the approach lights about 3 miles from the touchdown point. Reportedly, the plane was on the glide slope and localizer as he continued on final approach. After passing minumums, the aircraft went into a…NTSB FTW82DA130Accident · No injuriesFinal reportGoodyear FGID(F4U) · Forney, TXFollowing the last aerobatic manuever, a loop, and while in straight and level flight, the low oil pressure light illuminated. The oil pressure decreased to zero and shortly thereafter propeller control was lost. Due to a rough running engine an emergency…