NTSB investigations: Pratt & Whitney Canada PT6T-3
7 cases on aircraft whose registry engine model is Pratt & Whitney Canada PT6T-3. 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
| 1976 | 1 |
|---|---|
| 1991 | 1 |
| 1999 | 2 |
| 2000 | 1 |
| 2008 | 1 |
| 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 ('52102'))
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 ('52102'))
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 GAA20CA063Accident · Minor injuriesData collectionFinal reportSikorsky S 58JT · Lebanon, INThe pilot's failure to maintain proper clearance from a tractor trailer during landing.NTSB NYC08LA129Accident · Serious injuriesLimited investigationFinal reportSikorsky S-58HT · Belmont, WVThe fatigue failure of a tail rotor blade during an external load lift.NTSB DEN00LA045Accident · Serious injuriesLimited investigationFinal reportBell 212 · Mt Pleasant, UTFailure of the main rotor mast due to fatigue that resulted from inadequate quality assurance during the manufacturing process.NTSB FTW99LA162Accident · No injuriesLimited investigationFinal reportBell 412 · Eugene Is. 313The separation of a section of the tail rotor blade, and subsequent separation of the tail rotor system, as a result of fatigue cracking due to corrosion in the tail rotor blade spar.NTSB SEA99LA141Accident · No injuriesLimited investigationFinal reportBell 212 · Snoqualmie, WAClearance from an object was not maintained. A tree was a factor.NTSB FTW91FA155Accident · 1 fatalField investigationFinal reportBell 412 · Garden BanksOverheating and subsequent failure of the number one tail rotor hanger bearing for an undeterined reason, and failure of the tail rotor drive shaft.NTSB DEN77FA005Accident · Serious injuriesClosedBell B-212 · Casper, WY