NTSB investigations: Pratt & Whitney R-985 series, TN
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
| 1964 | 1 |
|---|---|
| 1968 | 1 |
| 1969 | 2 |
| 1971 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1976 | 4 |
| 1979 | 1 |
| 1980 | 1 |
| 1984 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 2001 | 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 c.\"eventStateOrRegion\" = 'TN' 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 c."eventStateOrRegion" = 'TN' 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 MIA01LA105Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Dyer, TNThe improper installation of the main landing gear tire (pinched tube) by company maintenance personnel resulting in a total loss of air pressure in-flight, loss of directional control on landing roll, and subsequent nose down.NTSB ATL96LA044Accident · Minor injuriesLimited investigationFinal reportBeech C-45G · Blountville, TNthe pilot's improper use of carburetor heat which resulted in a continuing loss of engine power, and the right landing gear's failure to extend during a single engine approach. A factor was the insufficient time available to extend the landing gear via the…NTSB ATL94LA045Accident · No injuriesLimited investigationFinal reportCessna 310R · Memphis, TNThe failure of the pilot of N2069C to follow the ATC directive to give way to N3844C, and the inadequate visual lookout by the pilot of N2069C. A factor was the dark night lighting condition at the time of the accident.NTSB ATL84FLT07Accident · No injuriesFinal reportWeatherly 201C · South Fulton, TNFive miles after takeoff the acft engine began sputtering and losing power. The plt dumped his load and still could not maintain flight. The acft could not be stopped before colliding with fence and trees during a downwind landing on wet pasture grass.…NTSB ATL80DKW03Accident · No injuriesClosedGrumman G-164B · Portland, TNNTSB IAD79FLT03Accident · No injuriesClosedGrumman G-164 · Newbern, TNNTSB IAD77FA003Accident · Minor injuriesClosedBeech E18S · Blountville, TNNTSB IAD76AI096Accident · 2 fatalClosedBeech E18S · Covington, TNNTSB IAD76DLT18Accident · No injuriesClosedBoeing A75 · Somerville, TNNTSB IAD76FLT13Accident · No injuriesClosedGrumman G-164A · Covington, TNNTSB IAD7LDLT02Accident · Minor injuriesClosedGrumman G-164 · Dyersburg, TNNTSB IAD75DLT02Accident · No injuriesClosedGrumman G-164A · New Castle, TNNTSB MIA72IM027Incident · No injuriesClosedBeech C45G · Nashville, TNNTSB MIA70F0195Accident · Serious injuriesClosedBoeing E-75 · Milan, TNNTSB MIA70F0159Accident · No injuriesClosedGrumman 164A · Barretville, TNNTSB MIA68F0516Accident · No injuriesClosedBeech C-45G · Nashville, TNNTSB UNK64X2056Accident · No injuriesClosedBeechcraft D-18S · Memphis, TN