Fatal NTSB investigations: Pratt & Whitney R-985 series, CA
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 |
|---|---|
| 1966 | 2 |
| 1967 | 1 |
| 1973 | 3 |
| 1977 | 1 |
| 1978 | 1 |
| 1979 | 2 |
| 1981 | 2 |
| 1985 | 1 |
| 2003 | 1 |
| 2014 | 1 |
| 2024 | 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\" = 'CA' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
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" = 'CA' AND c."eventCountry" = 'USA'
AND c."highestInjuryLevel" = 'Fatal'
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 WPR24FA196Accident · 2 fatalClass 3 · FieldFinal reportLockheed 12A · Chino, CAThe pilot’s exceedance of the airplane’s critical angle of attack during the initial climb, which resulted in an aerodynamic stall at an altitude insufficient for recovery. Contributing to the accident was the pilot’s failure to ensure that the airplane was…NTSB WPR14FA182Accident · 1 fatalField investigationFinal reportBoeing E75 · Fairfield, CAThe pilot's failure to maintain clearance from the runway during a low-level aerobatic maneuver due to his impairment by an over-the-counter antihistamine. Contributing to the severity of the pilot's injuries were the pilot's lack of fire protective clothing,…NTSB LAX03FA111Accident · 3 fatalField investigationFinal reportBeech 3NM · Anza, CAthe failure of the pilot to maintain an adequate airspeed resulting in a stall and loss of control.NTSB LAX86FA014Accident · 1 fatalField investigationFinal reportBoeing A75N1 · Schellville, CAThe acft crashed while attempting a slow roll immediately after departing from rwy 34 at the sonoma valley arpt. The plt stated to witnesses that he liked to roll his acft after takeoff. Witnesses indicated the acft became airborne after a 300 to 400 ft…NTSB LAX81FA126Accident · 1 fatalClosedBeech TC-45J · San Clement Is, CANTSB LAX81FA042Accident · 2 fatalClosedBeech H18 · Newhall, CANTSB LAX80FVM06Accident · 1 fatalClosedBoeing A75N1 · Paicines, CANTSB LAX79FA084Accident · 1 fatalClosedGrumman G-21A · Avalon, CANTSB LAX78FA047Accident · 1 fatalClosedVolpar C-45H · Lake Elsinore, CANTSB LAX77FA065Accident · 2 fatalClosedBeech E18S · Catalina Is, CANTSB OAK74FVA20Accident · 1 fatalClosedVultee BT-13A · Madera, CANTSB OAK74FVA04Accident · 1 fatalClosedBoeing A75 · Hickman, CANTSB OAK73FVA57Accident · 1 fatalClosedBoeing A75 · Reedley, CANTSB LAX68A0006Accident · 2 fatalClosedPiper PA-28 · Sepulveda, CANTSB OAK67A0021Accident · 1 fatalClosedBoeing B75 · Farmersvlle, CANTSB OAK67A0015Accident · 1 fatalClosedBoeing A75N · Corcoran, CANTSB UNK64X2889Accident · 1 fatalClosedBoeing A75 · Dos Palos, CA