Fatal NTSB investigations: Pratt & Whitney PT6A series, Outside the U.S.
12 cases on aircraft whose registry engine model is Pratt & Whitney PT6A series. 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
| 1994 | 1 |
|---|---|
| 1996 | 1 |
| 1997 | 1 |
| 2003 | 1 |
| 2005 | 1 |
| 2007 | 2 |
| 2008 | 2 |
| 2010 | 1 |
| 2014 | 1 |
| 2022 | 1 |
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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52032', '52034'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52032', '52034'))
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 GAA22WA137Accident · 3 fatalClass 5 · ForeignBeech C90A · Temixco, MexicoNTSB DCA15RA018Accident · 2 fatalForeign investigationShort Bros Shorts SD3 60 · Sint Maartin -Juliana, NTimportNTSB ERA11WA090Accident · 2 fatalForeign investigationHawker Beechcraft TC-45J · Nassau, BahamasOn December 14, 2010, about 1442 eastern standard time, a Hawker Beechcraft TC-45J, N38L, registered to and operated by Monarch Air Group, impacted ocean waters about 7 miles southwest of Lynden Pindling International Airport (MYNN), Nassau, Bahamas. The…NTSB ERA09WA037Accident · 3 fatalForeign investigationBeech 65A90 · Timehri, GuyanaNTSB ERA09WA028Accident · 1 fatalClass 5 · ForeignHawker-Beechcraft 100 · Bauru, BrazilNTSB DEN07WA113Accident · 2 fatalForeign investigationCessna 208B · Inverin, IrelandNTSB DEN07WA060Accident · 1 fatalForeign investigationPiper PA-31T · Rieschweiler, GermanyNTSB IAD05RA102Accident · 6 fatalForeign investigationPilatus PC-6 · Brasilito, Costa RicaNTSB DCA03WA056Accident · 9 fatalForeign investigationBeech King Air B200 · Madeira Islands, PortugalNTSB MIA97GA059Accident · 1 fatalFinal reportAyres S2RHG-T65 · Guaviare, Colombiathe pilot's failure to maintain adequate altitude/clearance while maneuvering at a low altitude.NTSB MIA96WA150Accident · 3 fatalForeign investigationde Havilland DHC-6-200 · Bagua, PeruNTSB NYC95WA235Accident · 2 fatalForeign investigationDouglas DC-3C · Lobito, Central African Republic