NTSB investigations: Pratt & Whitney R-985 series, CA
5 cases on aircraft whose registry engine model is Pratt & Whitney R-985 series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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
| 1985 | 1 |
|---|---|
| 1987 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1997 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52008')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 353))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52008')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 353))
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 LAX98LA015Accident · Minor injuriesLimited investigationFinal reportBeech D17S · Chino, CAfuel starvation resulting from the pilot's inadequate in-flight planning and improper fuel management. Contributing factors were the nighttime conditions and the rough/uneven terrain.NTSB LAX93LA158Accident · Serious injuriesLimited investigationFinal reportBoeing A75L3 · Carlsbad, CAThe pilot's inadequate preflight preparation in that he failed to refuel the aircraft prior to departure.NTSB LAX92LA028Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Pauma, CAFuel starvation due to a restricted fuel tank vent line. Contributing to the accident was inadequate maintenance.NTSB LAX87LA265Accident · No injuriesLimited investigationFinal reportBeech D18S · Riverside, CAThe acft had not been flown for svrl years & was on a flt to ferry it to another location. While cruising at 7500', the plt decided to start using aux fuel. Shortly after moving the fuel selectors to the aux psn, both engs lost power & would not restart. The…NTSB LAX85LA113Accident · Minor injuriesLimited investigationFinal reportFairchild M-62C · Ballico, CAAt the conclusion of a local aerial application flt, acft experienced a loss of power and collided with trees during the subsequent forced landing. Examinaton of the aircraft revealed a broken fuel feed line aft of the wobble pump and no fuel in the lines or…