NTSB investigations: Pratt & Whitney R-985 series, 1987, TX
3 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
| 1964 | 5 |
|---|---|
| 1965 | 6 |
| 1966 | 4 |
| 1967 | 7 |
| 1968 | 4 |
| 1969 | 4 |
| 1970 | 6 |
| 1971 | 5 |
| 1972 | 4 |
| 1973 | 6 |
| 1974 | 3 |
| 1975 | 5 |
| 1976 | 6 |
| 1977 | 3 |
| 1978 | 8 |
| 1979 | 4 |
| 1980 | 5 |
| 1981 | 5 |
| 1982 | 9 |
| 1983 | 5 |
| 1984 | 4 |
| 1985 | 1 |
| 1986 | 4 |
| 1987 | 3 |
| 1988 | 1 |
| 1989 | 2 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 3 |
| 1993 | 2 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 4 |
| 1998 | 2 |
| 1999 | 1 |
| 2001 | 1 |
| 2004 | 2 |
| 2005 | 2 |
| 2006 | 1 |
| 2007 | 1 |
| 2008 | 1 |
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2019 | 1 |
Where
Latest 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\") = 1987
AND c.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
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") = 1987
AND c."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA'
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 FTW87DRA09Accident · No injuriesFinal reportWeatherly 201C · Louise, TXThe acft was loaded with aprx 1100 lbs of fertilizer & the plt attempted to takeoff from a pvt strip on a 'still & muggy' day with a temp of about 95 deg. He rprtd that during the takeoff roll, he opened the dump gate when the acft was midway down the rwy to…NTSB FTW87LA162Accident · Minor injuriesLimited investigationFinal reportGrumman G-21A · Big Spring, TXDuring flt, the plt noted that the left fuel tank was almost empty and the right tank had gained fuel. He immediately switched from the both position to the right tank and started to work the wobble pump. The fuel continued to drop in the left tank and the…NTSB FTW87DRA03Accident · No injuriesFinal reportGrumman G-164B · Egypt, TXAcft experienced a power loss drng an aerial app maneuver. During the ensuing emerg lndg, the left wing struck high weeds on the shoulder of a road, veered left into a ditch, and flipped over. Investigation revealed no. 7 cylinder had a pre-existing crack in…