NTSB investigations: Pratt & Whitney R-985 series, 1983, FL
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
| 1964 | 4 |
|---|---|
| 1965 | 2 |
| 1966 | 1 |
| 1967 | 3 |
| 1968 | 1 |
| 1969 | 4 |
| 1970 | 2 |
| 1971 | 2 |
| 1972 | 5 |
| 1973 | 1 |
| 1974 | 5 |
| 1975 | 3 |
| 1976 | 3 |
| 1977 | 3 |
| 1978 | 3 |
| 1979 | 4 |
| 1980 | 2 |
| 1981 | 2 |
| 1982 | 1 |
| 1983 | 6 |
| 1984 | 3 |
| 1985 | 3 |
| 1987 | 1 |
| 1989 | 3 |
| 1995 | 1 |
| 1999 | 2 |
| 2002 | 3 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 2 |
| 2008 | 1 |
| 2011 | 1 |
| 2013 | 1 |
| 2018 | 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\") = 1983
AND c.\"eventStateOrRegion\" = 'FL' 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") = 1983
AND c."eventStateOrRegion" = 'FL' 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 MIA83IA236Incident · No injuriesIncident investigationFinal reportBeech E18S · Opa-Locka, FLBoth normal and emergency landing gear systems failed duringthe landing apch. The gear motor cutout switch was struck anthe emergency instruction plate in the cockpit was installed backwards. The pilot states that he had tried turning the handle in both…NTSB MIA83LA179Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Altha, FLThe plt stated that the eng began losing power during an aerial application mission. Subsequently, he landed in a muddy field & the acft nosed over. He stated that the indupartial loss of power.NTSB MIA83LA155Accident · No injuriesLimited investigationFinal reportBeech G18S · Jacksonville, FLThe plt reported that during the landing roll, while rolling on all 3 gear, the tailwheel failed & steered sideways causing the acft to veer off the rwy. An investigation revealed the tailwheel truss axle had failed. A further inspection revealed that 50% of…NTSB MIA83LA135Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Clewiston, FLThe plt had just washed the acft & went for a short local flt to dry it. He made a low pass at the arpt & the acft stalled during the pull-up.NTSB MIA83FA063Accident · No injuriesField investigationFinal reportBeech E18-S · Naples, FLThe acft departed the right side of the runway and the right gear separated from the acft. Examination of the fracture surface revealed no evidence of fatigue or other type of slow growth cracking.NTSB MIA83FA062Accident · Serious injuriesField investigationFinal reportBeech C45H · Leesburg, FLThe acft crashed into a lake during a forced landing after the engines quit. The PIC had gone for a local flt with a plt/passenger. After a few minutes of flt he announced that they did not have any fuel. The acft was on an approach to return when both…