NTSB investigations: Pratt & Whitney Canada PT6A-60A, Outside the U.S.
9 cases on aircraft whose registry engine model is Pratt & Whitney Canada PT6A-60A. 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
| 1992 | 1 |
|---|---|
| 1996 | 1 |
| 1998 | 1 |
| 2005 | 1 |
| 2008 | 1 |
| 2022 | 1 |
| 2023 | 1 |
| 2026 | 2 |
Latest 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.\"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 ('52043', '51999'))
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."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 ('52043', '51999'))
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 GAA26WA188Incident · No injuriesClass 5 · ForeignHawker Beechcraft B300 · Augsburg, GermanyNTSB DCA26WA113Accident · 2 fatalClass 5 · ForeignEmbraer EMB-110P1 · Les Cayes, HaitiNTSB GAA23WA061AccidentClass 5 · ForeignAir Tractor AT-502 · Puerto Barrios, GuatemalaNTSB GAA22WA320Accident · No injuriesClass 5 · ForeignBeech C90 · Bucaramanga, ColombiaNTSB CEN09RA052Accident · 1 fatalForeign investigationBeech 200 · Punta Chivato, MexicoOn November 3, 2008 at approximately 1800 pacific standard time (PST) a twin-engine turbo prop, Beechcraft BE200, N200JL, was destroyed when it impacted terrain shortly after takeoff from Punta Chivato Airstrip, located near Punto Chivato, Baja California…NTSB WAS05WA014Accident · No injuriesForeign investigationCessna 208 · Matemo Island, MozambiqueNTSB ATL98RA099Accident · 2 fatalForeign investigationAyres S2R-T34 · San Jose Del, ColombiaNTSB MIA96WA110Accident · Minor injuriesForeign investigationde Havilland DH6 · Virgin Gorda, British Virgin IslandsNTSB LAX93WA028Accident · 1 fatalForeign investigationde Havilland DHC-6-200 · Kenya