NTSB investigations: Pratt & Whitney R-985 series, FL
4 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
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1987 | 1 |
| 2007 | 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\" = 'FL' 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" = 'FL' 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 NYC07FA234Accident · Serious injuriesField investigationFinal reportBeech H-18 · Ft. Lauderdale, FLA total loss of engine power due to fuel starvation as a result of the pilot's failure to place the fuel selector for the right engine in the proper position. Contributing to the accident was the improper loading of the cargo.NTSB MIA87LA262Accident · Minor injuriesLimited investigationFinal reportBoeing E75 · Ocala, FLThe plt stated that the eng lost power & he was at low alt looking for an emerg ldg field when the wing hit a tree. The pax stated they were doing aerobatics at low alt & the eng quit. She stated that she was not wearing the required parachute & had asked the…NTSB MIA84LA158Accident · No injuriesLimited investigationFinal reportBoeing A75L300 · Daytona Beach, FLThe acft lost power while the plt was towing a banner over water. He was unable to restart the eng & subsequesntly ditched the acft in the ocean near Daytona Beach, FL. The plt elected to keep the banner attached to the acft to keep the plane from flipping…NTSB MIA83FA062Accident · Serious injuriesField investigationFinal reportBeech C45H · Leesburg, FLThe acft crashed into a lake during a forced landing after the engines quit. The PIC had gone for a local flt with a plt/passenger. After a few minutes of flt he announced that they did not have any fuel. The acft was on an approach to return when both…