NTSB investigations: Pratt & Whitney R-985 series, IN
13 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 |
|---|---|
| 1965 | 1 |
| 1971 | 1 |
| 1977 | 2 |
| 1978 | 2 |
| 1980 | 1 |
| 1981 | 1 |
| 1983 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1993 | 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\" = 'IN' 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" = 'IN' 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 CHI93LA373Accident · No injuriesLimited investigationFinal reportBeech 18-C45G · Jeffersonville, INthe mechanical binding of the landing gear extension mechanism.NTSB CHI89DEX06Accident · No injuriesFinal reportGrumman G-164A · Sullivan, INA failure of the supercharger oil seal which resulted in a partial loss of engine power during takeoff and the uncontrolled touchdown during the forced landing. Factors related to the accident were: partial failure of the supercharger and spark plub fowling.NTSB CHI87DEX07Accident · Serious injuriesFinal reportBoeing E75 · Mccordsville, INDuring initial climb the engine sustained a total power failure and the pilot attempted to return to the airport. The aircraft impacted in a soybean field approximately 200 feet short of the runway in a 20 degree nose down attitude. Investigation revealed the…NTSB CHI83LA093Accident · No injuriesLimited investigationFinal reportBeech D18S · Plymouth, INPilot landed the aircraft with the landing gear up. He said he put the gear selector down but after landing the lever was up. He also mistook gear up warning horn for a stall warning. No malfunctions were reported.NTSB CHI81DEV35Accident · Minor injuriesClosedGrumman G-164A · Dana, INNTSB CHI80FET24Accident · No injuriesClosedGrumman G-164 · Howe, INNTSB CHI79FEX09Accident · No injuriesClosedBeechcraft E18S · Indianapolis, INNTSB CHI78FEX34Accident · No injuriesClosedGrumman G-164B · Kokomo, INNTSB CHI77DEX40Accident · No injuriesClosedStearman PT-17 · Converse, INNTSB CHI77DET19Accident · No injuriesClosedGrumman G-164A · Hebron, INNTSB CHI72FEA01Accident · No injuriesClosedBoeing A75N1 · Greensburg, INNTSB CHI66F0308Accident · No injuriesClosedBeechcraft C-18S · Jamestown, INNTSB UNK64X3867Accident · No injuriesClosedBeechcraft C18 · Brownsburg, IN