Skip to content

NTSB investigations: Pratt & Whitney PT6A series, KS

16 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20042026

Where

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" = 'KS' 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 ('52032', '52034')) 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\" = 'KS' 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 ('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."eventStateOrRegion" = 'KS' 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 ('52032', '52034'))
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 CEN24LA193Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-502 · Covert, KSThe improper maintenance of the fuel control unit, which resulted in air leakage and a loss of control of fuel flow to the engine.May 19, 2024 · N15189 · Substantial damage NTSB CEN21LA286Accident · Minor injuriesClass 3 · LimitedFinal reportAyres S2R-T34 · Leoti, KSThe pilot’s loss of visibility in the cockpit due to foam created by the chemicals loaded in the hopper, which resulted in his inability to maintain airplane control during low-level flight and an impact with terrain. Contributing to the accident was the…Jun 21, 2021 · N4328P · Substantial damage NTSB CEN20CA221Accident · No injuriesClass 4 · Data collectionFinal reportAir Tractor AT502 · Hiawatha, KSThe pilot’s decision to attempt the takeoff with a tailwind in high density altitude conditions.Jun 8, 2020 · N5092J · Substantial damage NTSB CEN20LA122Accident · 1 fatalClass 3 · LimitedFinal reportCessna 208 · LaCrosse, KSAn infight loss of control as a result of pilot impairment, the cause of which could not be determined.Mar 17, 2020 · N274PM · Destroyed NTSB GAA19CA352Accident · No injuriesData collectionFinal reportAir Tractor AT402 · Liberal, KSThe pilot's failure to see and avoid a windmill tower while maneuvering at low altitude.Jun 17, 2019 · N5044Y · Substantial damage NTSB GAA19CA328Accident · Minor injuriesData collectionFinal reportAir Tractor AT502 · Monument, KSThe pilot's failure to maintain altitude due to distraction by ground equipment in the airplane’s path, which resulted in his failure to maintain clearance from crops during an agricultural application flight and resulted in a loss of airplane control.Jun 7, 2019 · N60642 · Substantial damage NTSB GAA16CA224Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Oberlin, KSThe pilot's failure to maintain directional control during the landing roll, which resulted in runway excursion, and a ground loop.May 8, 2016 · N6181Q · Substantial damage NTSB CEN15FA034Accident · 4 fatalField investigationFinal reportRaytheon B200 · Wichita, KSThe pilot's failure to maintain lateral control of the airplane after a reduction in left engine power and his application of inappropriate rudder input. Contributing to the accident was the pilot's failure to follow the emergency procedures for an engine…Oct 30, 2014 · N52SZ · Destroyed NTSB CEN14LA211Accident · 1 fatalLimited investigationFinal reportAir Tractor AT 502B · Garfield, KSThe pilot’s inadequate preflight planning and subsequent failure to remain clear of power lines while maneuvering low to the ground.Apr 22, 2014 · N51990 · Substantial damage NTSB CEN13FA049Accident · 1 fatalField investigationFinal reportCessna 208B · Wichita, KSThe total loss of engine power as a result of a fractured compressor turbine blade due to high-cycle fatigue.Nov 6, 2012 · N793FE · Substantial damage NTSB CEN12FA521Accident · No injuriesField investigationFinal reportAyres S2R-T34 · Lakin, KSThe pilot's failure to maintain clearance from the corn during an aerial application flight.Aug 6, 2012 · N365SM · Substantial damage NTSB CEN12LA236Accident · Serious injuriesLimited investigationFinal reportAyres S2R-T15 · Lakin, KSThe pilot did not maintain sufficient airspeed while maneuvering, which resulted in an aerodynamic stall at a low altitude.Apr 9, 2012 · N64DX · Substantial damage NTSB ENG12IA024Incident · No injuriesIncident investigationFinal reportBeech 1900D · Hays, KSA failure of the nose landing gear end cap due to fatigue. Contributing to the failure were the ineffective inspection and the unknown effect of grain direction on fatigue life.Mar 13, 2012 · N178YV · Minor damage NTSB CEN11IA106Incident · No injuriesIncident investigationFinal reportPiper PA-46-500TP · Olathe, KSThe loss of engine power for undetermined reasons.Oct 21, 2010 · N767TP · No damage NTSB DEN08LA125Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-402B · Deerfield, KSThe pilot inadvertently stalling the airplane. Contributing factors in this accident were the pilot intentionally performing low altitude maneuvers (side slips), unporting and starving the engine of fuel, and his initiating a climb at low airspeed.Jul 20, 2008 · N61318 · Destroyed NTSB CHI04LA086Accident · No injuriesLimited investigationFinal reportBeech 1900D · Manhattan, KSThe captain's improper decision due to his attempt to taxi back onto the runway after coming to a stop in the grass, and the resulting collapse of nose landing gear. Contributing factors were the inoperative nose wheel steering, the pilot's inability to…Mar 15, 2004 · N155ZV · Substantial damage