NTSB investigations: Pratt & Whitney Canada PT6A-65AG, 2017
4 cases on aircraft whose registry engine model is Pratt & Whitney Canada PT6A-65AG. 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
| 1995 | 1 |
|---|---|
| 2004 | 1 |
| 2007 | 1 |
| 2008 | 1 |
| 2011 | 4 |
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 4 |
| 2016 | 2 |
| 2017 | 4 |
| 2018 | 3 |
| 2019 | 3 |
| 2020 | 2 |
| 2021 | 6 |
| 2022 | 3 |
| 2023 | 2 |
| 2024 | 8 |
| 2025 | 3 |
| 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 year(c.\"eventDate\") = 2017
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52109'))
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 year(c."eventDate") = 2017
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52109'))
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 GAA17CA454Accident · Serious injuriesData collectionFinal reportAir Tractor AT 802 · Trumann, ARThe pilot’s improper decision to continue flight in deteriorating weather conditions, which resulted in collision with the ground.NTSB GAA17CA323Accident · No injuriesData collectionFinal reportAir Tractor AT 802 · Prosser, WAThe pilot’s abrupt maneuver to avoid hay bales during the takeoff roll, which resulted in a loss of directional control.NTSB CEN17FA170Accident · 1 fatalField investigationFinal reportAir Tractor AT 602 · Hollis, OKAn impact with terrain during final approach for reasons that could not be determined because no evidence of an in-flight failure or malfunction was observed.NTSB GAA17CA117Accident · No injuriesData collectionFinal reportAir Tractor AT 802 · Vernon, UTThe pilot’s failure to maintain clearance from mountainous terrain.