NTSB investigations: Pratt & Whitney Canada PT6A-60A

8 cases on aircraft whose registry engine model is Pratt & Whitney Canada PT6A-60A, where NTSB found Not determined, general. 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

20092026
NTSB investigations: Pratt & Whitney Canada PT6A-60A per year, 2009–2026: 8 cases
20092
20161
20172
20182
20191

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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52043', '51999')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE f.case_mkey = x.case_mkey AND f.aircrafts_position = x.position AND starts_with(f.\"findingCode\", '05000000')))
  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.

NTSB CEN19FA161Accident · 1 fatalClass 3 · FieldFinal reportCessna 425 · Butler, MOThe pilot’s loss of airplane control during a descent to a diversion airport with only the left engine operating. Contributing to the accident was a malfunction of the right engine throttle, the cause of which could not be determined.Jun 10, 2019 · N622MM · DestroyedNTSB ERA19LA026Accident · 5 fatalLimited investigationFinal reportPiper PA31T · Atlantic Ocean (Atlantic Ocean)An in-flight loss of control, which resulted in an impact with water, for reasons that could not be determined because the airplane was not recovered.Oct 25, 2018 · N555PM · DestroyedNTSB CEN18LA270Accident · Serious injuriesClass 3 · LimitedFinal reportAir Tractor AT 602 · Bismarck, ILA loss of control for reasons that could not be determined based on the available information.Jul 13, 2018 · N629LA · Substantial damageNTSB CEN17FA266Accident · 2 fatalField investigationFinal reportPiper PA31T · Tyler, TXThe loss of engine power and the subsequent pilot's loss of control for reasons that could not be determined because post-accident engine examination revealed no anomalies.Jul 13, 2017 · N47GW · DestroyedNTSB CEN17LA190Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT 502 · Tahoka, TXThe partial loss of engine power during takeoff for reasons that could not be determined based on the available information.May 4, 2017 · N144HF · DestroyedNTSB WPR17FA024Accident · 4 fatalField investigationFinal reportPiper PA 31T · Elko, NVA loss of engine power to the left engine for reasons that could not be determined due to the extensive fire and impact damage to the airplane.Nov 19, 2016 · N779MF · DestroyedNTSB CEN10FA063Accident · 1 fatalField investigationFinal reportPiper PA-31T2 · Harrison, MIA loss of aircraft control for undetermined reasons.Dec 4, 2009 · N85EM · DestroyedNTSB ERA09LA394Accident · 1 fatalLimited investigationFinal reportAyres S2R-T34 · Hertford, NCThe in-flight collision with terrain for undetermined reasons.Jul 10, 2009 · N357CA · Substantial damage