NTSB investigations: Pratt & Whitney Canada PT6T-6
7 cases on aircraft whose registry engine model is Pratt & Whitney Canada PT6T-6. 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
| 1980 | 1 |
|---|---|
| 1989 | 1 |
| 1992 | 1 |
| 2002 | 1 |
| 2003 | 2 |
| 2019 | 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 ('52106'))
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 ('52106'))
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 WPR19LA255Accident · No injuriesClass 3 · LimitedFinal reportSikorsky S58 · Azusa, CAThe in-flight separation of a section of the tail rotor blade due to a fatigue crack, which resulted in the pilot’s forced autorotation into a field.NTSB CHI04LA047Accident · Minor injuriesLimited investigationFinal reportSikorsky S-58JT · Ypsilanti, MIThe pilot became disoriented and attempted to land the helicopter at the wrong ramp resulting in his failure to maintain obstacle clearance during the approach. The light poles were a factor to the accident.NTSB LAX03FA232Accident · Serious injuriesField investigationFinal reportSikorsky S-58ET · Rancho P.Verdes, CAA total loss of antitorque control, due to the fatigue-induced failure of a gear within the drive shaft's intermediate gear box (IGB). Contributing factors were the pilot's improper on-ground decision to continue flight operations following discovery of…NTSB CHI02FA189Accident · 1 fatalField investigationFinal reportSikorsky S-58ET · Brookville, INThe pilot's intentional low altitude fight and his failure to maintain clearance from power transmission lines. Factors to the accident were the power transmission lines followed by the inability to control the aircraft after the collision with power…NTSB CHI92TL#02Accident · No injuriesClass 3Final reportSikorsky S-58ET · North Platte, NENTSB LAX89FA160Accident · Minor injuriesField investigationFinal reportSikorsky S-58ET · Santa Ana, CAFailure of the landing gear resulting from excessive loading during ground operations, and fatigue cracking.NTSB LAX81FA006Accident · 3 fatalClosedSikorsky S58DT · Lovelock, NV