NTSB investigations: Pratt & Whitney Canada PT6A-60A

9 cases on aircraft whose registry engine model is Pratt & Whitney Canada PT6A-60A, where the first occurrence was “In flight collision with object”. 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

19882026

NTSB investigations: Pratt & Whitney Canada PT6A-60A per year, 1988–2026: 9 cases
1988	2
1989	1
1991	2
1993	1
1995	1
2003	1
2005	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."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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220)) 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.\"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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220))
  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."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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220))
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 CHI05LA130Accident · Minor injuriesLimited investigationFinal reportPilatus PC-6 · Sturtevant, WIFailure of the jump plane pilot to maintain clearance from the parachutist descent area/drop zone until assured that all jumpers had landed, and the parachutist's failure to maintain an adequate visual lookout for the jump plane during all phases of the jump.…May 26, 2005 · N346F · Substantial damage NTSB CHI03LA171Accident · Serious injuriesLimited investigationFinal reportAyres S2R-T34 · Marked Tree, ARThe pilot's failure to maintain clearance with the wire. Contributing factors were the low altitude flight/maneuver and the static wire.Jun 19, 2003 · N4004U · Substantial damage NTSB FTW95LA347Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Lake City, ARThe pilot's failure to maintain clearance with the transmission wires.Aug 11, 1995 · N3095W · Substantial damage NTSB DEN93LA093Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Brookland, ARThe pilot's failure to maintain adequate object clearance.Jul 30, 1993 · N7319V · Substantial damage NTSB MIA91LA196Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Cleveland, MSThe pilot's decision to continue the flight with reduced visual lookout due to a dirty foggy windshield.Aug 10, 1991 · N45192 · Substantial damage NTSB FTW91DPG05Accident · 1 fatalFinal reportAyres S2R-T34 · Wheatley, ARThe failure of the flagman to follow established procedures.May 2, 1991 · N4015Z · Minor damage NTSB ATL89FA142Accident · 1 fatalField investigationFinal reportEmbraer EMB-110-P1 · Mt. Pleasant, TNPilot attempted to make a VFR landing in instrument conditions that were below minimums for the published instrument approach and collided with trees and the ground after allowing the airplane to descend below the proper altitude.May 6, 1989 · N95PB · Destroyed NTSB LAX88DVA14Accident · Minor injuriesFinal reportAyres S2R-T34 · Five Points, CAPlt was engaged in aerial application and had been overflying power lines. On last pass, plt elected to fly beneath power lines, struck bracing wire between poles with vertical fin, disabling elevator. The acft crashed nose down in a field in an uncontrolled…Sep 2, 1988 · N4009M · Substantial damage NTSB LAX88DVA10Accident · No injuriesFinal reportAyres S2R-T34 · Huron, CADuring an aerial application flight at night, the airplane's vertical stabilizer collided with a transmission wire. Subsequently, the vertical stabilizer & rudder were dislocated & directional control was lost. Realizing he had lost directional control, the…Aug 14, 1988 · N40071 · Substantial damage