Fatal NTSB investigations: Pratt & Whitney PT6A series

9 cases on aircraft whose registry engine model is Pratt & Whitney PT6A series, 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

19962026

Fatal NTSB investigations: Pratt & Whitney PT6A series per year, 1996–2026: 9 cases
1996	1
1997	2
2001	2
2004	1
2005	1
2007	2

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."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') 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.\"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')
      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."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')
    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 ANC07FA073Accident · 4 fatalField investigationFinal reportPiper PA-46-350P · Sitka, AKThe pilot's failure to maintain altitude/distance from obstacles during an IFR circling approach, and his failure to follow the instrument approach procedure. Contributing to the accident was clouds.Aug 6, 2007 · N35CX · Destroyed NTSB CHI07LA147Accident · 1 fatalLimited investigationFinal reportThrush S2RHG-T65 · Tyndall, SDThe pilot not maintaining altitude/clearance from a powerline while maneuvering. A factor was the low visibility associated with the thunderstorm and the powerlines.May 19, 2007 · N40097 · Destroyed NTSB CHI05LA164Accident · 1 fatalLimited investigationFinal reportRockwell S-2R · Bristol, SDThe pilot's failure to maintain clearance with the static lines between the transmission towers. A factor associated with the accident were the static lines.Jul 5, 2005 · N3211R · Substantial damage NTSB FTW04LA108Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-402B · Goliad, TXThe pilot's failure to maintain clearance with power lines while maneuvering during an aerial application flight.Apr 13, 2004 · N852JH · Substantial damage NTSB MIA02FA037Accident · 2 fatalField investigationFinal reportCessna 208B · Bessemer, ALThe poor in-flight planning by the pilot-in-command for his initiation of the ILS approach to runway 05 with weather conditions below minimums for the approach contrary to the federal aviation regulations, and the failure of the pilot to maintain control of…Dec 1, 2001 · N499BA · Destroyed NTSB FTW02LA034Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-802A · Benton, LAin-flight collision with trees while on final approach to land for an undetermined reason.Nov 14, 2001 · N202AT · Destroyed NTSB FTW97FA285Accident · 1 fatalField investigationFinal reportAyres S2R-T15 · Oakridge, LAThe pilot's failure to maintain clearance for undetermined reasons.Jul 28, 1997 · N3096K · Destroyed NTSB MIA97GA059Accident · 1 fatalFinal reportAyres S2RHG-T65 · Guaviare, Colombiathe pilot's failure to maintain adequate altitude/clearance while maneuvering at a low altitude.Jan 7, 1997 · N3100U · Destroyed NTSB ATL96LA130Accident · 1 fatalLimited investigationFinal reportAir Tractor 402 · Mayersville, MSthe pilot's misjudgment of his ground speed and distance to trees during the swath run, and his delayed pull-up at the end of the swath run, which resulted in his failure to remain clear of the trees. The tail wind and location of the trees were related…Sep 21, 1996 · N1517G · Substantial damage