NTSB investigations: Pratt & Whitney JFTD12A-4A
5 cases on aircraft whose registry engine model is Pratt & Whitney JFTD12A-4A. 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
| 1970 | 1 |
|---|---|
| 1999 | 1 |
| 2006 | 1 |
| 2019 | 1 |
| 2026 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('51502'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('51502'))
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 ANC26FA079Accident · 2 fatalClass 3 · FieldPreliminary reportHelicopter Transport Services CH-54A · Cove Fort, UTOn August 7, 2026, about 1044 mountain daylight time, a Helicopter Transport Services (Sikorsky) CH-54A Skycrane Helitanker, N793HT, was destroyed when it was involved in an accident near Cove Fort, Utah. The pilot and copilot were fatally injured. The…NTSB WPR19WA147Accident · Minor injuriesForeign investigationSikorsky S64 · Mount Eliza, AustraliaOn January 28, 2019, at 1956 local time, a Sikorsky S-64E, N173AC, sustained substantial damage after colliding into a pond near Mount Eliza, Australia. The pilot and two crewmembers were not injured. The investigation is under the jurisdiction of the…NTSB LAX07TA001Accident · Minor injuriesFinal reportErickson S64E · Ojai, CAThe pilot-in-command's improper remedial action, which resulted in a loss of helicopter control. Contributing factors were the retardant tank and snorkel designs.NTSB LAX00LA018Accident · 1 fatalLimited investigationFinal reportSikorsky CH-54A · Elko, NVthe flight engineer's decision to climb a step ladder that put him in close proximity to the still turning main rotor blades. The gusting wind was a factor in the accident.NTSB MIA71FKD01Accident · No injuriesClosedSikorsky S-64E · Union City, TN