NTSB investigations: Pratt & Whitney R-985 series, 2000
17 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\") = 2000
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") = 2000
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 SEA01LA031Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 Mk. I · Kirkland, WAA malfunction of the aircraft's fuel selector valve and subsequent fuel starvation. Factors included a short emergency landing area, a wet landing surface, and a fence.NTSB NYC01FA007Accident · 1 fatalField investigationFinal reportBeech E18S · Wash. Ct. House, OHAn undetermined event, which resulted in an off airport landing. A factor in this accident was the night light condition.NTSB LAX00LA345Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Tracy, CALoss of engine power due to failure and separation of the number one connecting rod.NTSB DEN00LA172Accident · No injuriesLimited investigationFinal reportBoeing Stearman D75N1 · Englewood, COthe flight instructor not maintaining supervision. Contributing factors were the student's hard landing due to excessive flare and subsequent inadvertent stall, and the student's failure to maintain directional control during landing roll.NTSB CHI00LA285Accident · No injuriesLimited investigationFinal reportBoeing Stearman B75N1 · Cape Girardeau, MOthe pilot's improper decision to continue the flight when the fuel sight gauge indicated empty and the exhausted fuel supply. A factor was the corn crop.NTSB FTW00LA239Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Kaplan, LAthe failure of the supercharger during takeoff. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA00LA159Accident · No injuriesLimited investigationFinal reportBoeing E75 · Mcminnville, ORThe disconnection of the left tailwheel control cable spring resulting in the positioning of the tailwheel in a right turn condition.NTSB ANC00LA098Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · King Salmon, AKThe pilot's inadequate compensation for crosswind conditions.NTSB ANC00LA091Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Big Lake, AKThe pilot's inadequate compensation for the wind conditions. A factor associated with the accident was a crosswind.NTSB CHI00LA203Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Streator, ILthe pilot's preflight planning was inadequate which resulted in taking off in the wrong direction on the runway. Factors associated with the accident were the tailwind condition and the crop that the airplane contacted.NTSB NYC00LA190Accident · No injuriesLimited investigationFinal reportSpartan 7W · Jefferson, OHThe overload failure of the left main gear strut housing.NTSB LAX00LA246Accident · No injuriesLimited investigationFinal reportGrumman G-164B · King City, CAThe loss of engine power for undetermined reasons.NTSB ANC00LA074Accident · Minor injuriesLimited investigationFinal reportCessna 206 · King Salmon, AKThe inadequate visual lookout by the pilot of the other airplane, and the inadequate radio traffic advisories by the pilots of both airplanes.NTSB SEA00LA099Accident · Serious injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Colfax, WAThe pilots failure to maintain clearance from power transmission lines.NTSB FTW00LA167Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G164B · Natchitoches, LAThe failure of the pilot to maintain directional control during the landing roll, which resulted in a ground loop. A factor was the crosswind.NTSB CHI00LA137Accident · No injuriesLimited investigationFinal reportWeatherly 201C · Ionia, KSthe partial engine failure for undetermined reasons and the unsuitable terrain for landing encountered by the pilot. A factor to the accident was the hilly terrain condition.NTSB DEN00LA072Accident · Minor injuriesLimited investigationFinal reportWeatherly 201B · Rocky Ford, COA total loss of power due to an engine rocker arm failure and soft/unsuitable terrain during the subsequent forced landing.