NTSB investigations: Pratt & Whitney R-985 series, 1982, AL
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
| 1967 | 1 |
|---|---|
| 1969 | 1 |
| 1970 | 2 |
| 1971 | 2 |
| 1976 | 2 |
| 1977 | 2 |
| 1978 | 2 |
| 1979 | 2 |
| 1980 | 2 |
| 1981 | 1 |
| 1982 | 3 |
| 1983 | 2 |
| 1985 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1992 | 2 |
| 1994 | 1 |
| 1995 | 1 |
| 1999 | 1 |
| 2007 | 1 |
| 2015 | 1 |
| 2019 | 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.\"eventStateOrRegion\" = 'AL' 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") = 1982
AND c."eventStateOrRegion" = 'AL' 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 ATL83IA034Incident · No injuriesIncident investigationFinal reportBeech G18S · Huntsville, ALThe left cargo door separated from the acft. The door was a hamilton cargo door installed under an STC which required 3 hinges on top & 3 pins on bottom with an overcenter locking mechanism on the handle for the pins. This door had 2 hinges installed. Only 2…NTSB ATL82DA276Accident · No injuriesFinal reportGrumman G-164B · Society Hill, ALAircraft lost power during takeoff and nosed over during emergency landing in a cotton field. Takeoff weight was over certificated gross limit.NTSB ATL82DA230Accident · No injuriesFinal reportGrumman G164B · Opp, ALThe pilot reported that while he was spraying, vibrations occurred in the left flying wires. He had experienced the vibrations before, but this time, they seemed worse, he elected to land in a nearby pasture to examine the aircraft. During the landing…