NTSB investigations: Pratt & Whitney Canada PT6A-60A, CO

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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19782026

NTSB investigations: Pratt & Whitney Canada PT6A-60A, CO per year, 1978–2026: 9 cases
1978	1
1986	1
1989	1
1999	1
2001	1
2003	1
2005	1
2009	1
2010	1

Where

Open the map

Latest cases

Query with SQL

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."eventStateOrRegion" = 'CO' AND 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

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.\"eventStateOrRegion\" = 'CO' AND 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."eventStateOrRegion" = 'CO' AND 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

Run 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 CEN10CA540Accident · No injuriesData collectionFinal reportBeech E-90 · Colorado Springs, COThe pilot’s failure to ensure that the airplane’s parking brake was properly set before diverting his attention to other tasks.Sep 5, 2010 · N16LH · Substantial damage NTSB CEN09LA173Accident · No injuriesLimited investigationFinal reportPiper PA-31T · Pueblo, COThe pilot's improper flare and recovery from a bounced landing.Feb 23, 2009 · N171AF · Substantial damage NTSB DEN05FA126Accident · 4 fatalField investigationFinal reportCessna 425 · Lone Tree, COThe pilot's failure to properly execute the published instrument approach procedure, which resulted in controlled flight into terrain.Aug 14, 2005 · N425SG · Destroyed NTSB DEN03LA095Accident · No injuriesLimited investigationFinal reportCessna 425 · Pueblo, COthe pilot's inadvertent flight into adverse weather conditions. Contributing factors include the encounter with severe turbulence and hail.May 31, 2003 · N425SG · Substantial damage NTSB DEN01IA108Incident · No injuriesIncident investigationFinal reportBeech 200 · Greeley, COjamming of the nose landing gear actuator due to improper painting procedures by other maintenance personnel which resulted in a wheels up landing.May 8, 2001 · N725MC · Minor damage NTSB DEN99LA108Accident · No injuriesLimited investigationFinal reportBeech B90 · Creede, COOverload failure of the right main landing gear scissors torque link precipitated by preexisting fatigue fractures. A factor was wind shear.Jun 25, 1999 · N221NC · Substantial damage NTSB DEN89LA058Accident · No injuriesLimited investigationFinal reportPiper PA-31T · Craig, COUnsuitable terrain (runway condition) selected by the pilot. Factors related to the accident were: the adverse weather conditions, inadequate removal of snow from the runway by airport personnel, uneven snow covered runway, lack of visual perception by the…Jan 6, 1989 · N82290 · Substantial damage NTSB DEN86MA061Accident · 5 fatalMajor investigationFinal reportCessna 425 · Granby, CODrg arrival, the plt advised ARTCC that the destination arpt appeared to be covered with fog. She then canceled her IFR flt plan. According to ground witnesses, the acft made several passes over the arpt. Witnesses also rprtd that the horizontal visibility…Jan 11, 1986 · N425SC · Destroyed NTSB DEN78FA046Accident · 4 fatalClosedPiper PA-31T · Lamar, COJun 5, 1978 · N176CC · Destroyed