NTSB investigations: Pratt & Whitney R-985 series, NV
11 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 |
|---|---|
| 1970 | 1 |
| 1972 | 2 |
| 1974 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1992 | 1 |
| 1999 | 1 |
| 2010 | 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\" = 'NV' 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" = 'NV' 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 WPR10CA254Accident · No injuriesData collectionFinal reportBoeing B75 · Yerington, NVThe pilot's inadequate compensation for the crosswind condition, resulting in the loss of directional control during the landing roll.NTSB LAX99LA070Accident · No injuriesLimited investigationFinal reportAvions Max Holste MH 1521 Broussard · Minden, NVThe pilot's failure to maintain proper runway alignment during a rejected takeoff. A factor in the accident was the undetermined pitch control/trim system problem, which led to the pilot's rejected takeoff decision and may have distracted him during attempts…NTSB LAX92LA391Accident · No injuriesLimited investigationFinal reportBeech D17S · Reno, NVThe pilots failure to maintain directional control during landing rollout. Contributing to the accident was a variable tailwind condition and the soft, rough nature of the terrain.NTSB OAK79DXQ17Accident · No injuriesClosedStearman 75 · Deeth, NVNTSB OAK78FVW18Accident · No injuriesClosedBeech C45H · Las Vegas, NVNTSB OAK77FVW29Accident · No injuriesClosedBeech D18 · Las Vegas, NVNTSB OAK74FVW13Accident · No injuriesClosedBeech G18S · Boulder City, NVNTSB OAK73FXQ05Accident · Serious injuriesClosedBoeing B75N1 · Yerington, NVNTSB OAK72FXQ27Accident · No injuriesClosedSpartan 7W · Reno, NVNTSB OAK71DVW14Accident · No injuriesClosedSpartan 7W · Pahrump, NVNTSB UNK64X0480Accident · No injuriesClosedBeechcraft C45H · Las Vegas, NV