Skip to content

NTSB investigations: Pratt & Whitney PT6A series, TX

69 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, newest first

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" = 'TX' 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\" = 'TX' 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" = 'TX' 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 FTW00LA257Accident · No injuriesLimited investigationFinal reportAir Tractor 402B · Segraves, TXThe pilot's failure to maintain clearance with the irrigation system. A factor was the whirlwind weather condition.Sep 6, 2000 · N6174H · Substantial damage NTSB FTW00LA195Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T34 · Anahuac, TXThe pilot's failure to maintain clearance with the power line. A factor was the lack of suitable terrain for the forced landing.Jul 5, 2000 · N2252N · Destroyed NTSB FTW99LA249Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Seminole, TXThe pilot's failure to maintain obstacle clearance.Sep 6, 1999 · N5005G · Substantial damage NTSB FTW99LA226Accident · No injuriesLimited investigationFinal reportAir Tractor AT-402 · Snyder, TXThe loss of engine power due to fuel starvation as result of a leak in the engine fuel control. A factor was the lack of suitable terrain for the forced landing.Aug 17, 1999 · N4523L · Substantial damage NTSB FTW98LA035Accident · No injuriesLimited investigationFinal reportPilatus PC-6 · Lexington, TXthe pilot's selection of an unsuitable landing area. A factor relating to the accident was: the uneven terrain (with swales) at the edge of the landing area.Oct 28, 1997 · N19TX · Substantial damage NTSB FTW97LA331Accident · No injuriesLimited investigationFinal reportAir Tractor AT-802A · Pineland, TXfailure of the right main wheel brake, during the landing roll. A factor relating to the accident was: the pilot's failure (or inability) to maintain directional control of the airplane, after loss of right braking action.Aug 27, 1997 · N9197F · Substantial damage NTSB FTW97LA225Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502A · Chesterville, TXan undetermined malfunction/failure of the propeller reversing system.Jun 13, 1997 · N248LF · Substantial damage NTSB FTW97LA074Accident · No injuriesLimited investigationFinal reportBeech C90A · Rio Grande City, TXThe pilot's failure to maintain clearance with the tower. Factors were the low ceilings and the pilot's diverted attention to his navigation.Jan 2, 1997 · N1552D · Substantial damage NTSB FTW96FA399Accident · 1 fatalField investigationFinal reportAyres S2R-T45 · Granger, TXthe pilot's inadvertent flight into adverse weather conditions, and subsequent loss of aircraft control due to spatial disorientation. Factors relating to the accident were darkness, the prevailing fog and low ceilings, the inadequate flight instruments…Sep 23, 1996 · N3107B · Destroyed NTSB FTW95FA399Accident · 1 fatalField investigationFinal reportAir Tractor AT-502A · Coleman, TXthe pilot's continued flight into adverse weather resulting in spatial disorientation and loss of control. A factor was the pilot's improper weather evaluation and the weather.Sep 21, 1995 · N91969 · Destroyed NTSB FTW95LA211Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Lissie, TXThe partial loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.May 20, 1995 · N4554R · Substantial damage NTSB FTW94LA119Accident · Serious injuriesLimited investigationFinal reportCessna 208 · Whitewright, TXThe inadvertent stall when too many parachutist hung on the outside of the aircraft.Apr 3, 1994 · N9421F · Minor damage NTSB FTW94LA003Accident · No injuriesLimited investigationFinal reportCessna 208B · Dfw Airport, TXThe pilot's disregard for the issued safety advisory.Oct 2, 1993 · N9762B · Substantial damage NTSB FTW92LA131Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Taft, TXThe pilot of the other airplane delayed compensation for turbulence. A factor was the turbulence.May 13, 1992 · N1518V · 2 aircraft · Substantial damage NTSB FTW91DRG04Accident · Serious injuriesFinal reportAir Tractor AT-402 · Taft, TXThe pilot's failure to maintain proper terrain clearance.Jul 21, 1991 · N4523L · Minor damage NTSB FTW83FA270Accident · 1 fatalField investigationFinal reportAir Tractor AT-400A · Lane City, TXThe plt was leading a flt of 2 acft on an aerial application mission. The plt of the 2nd acft stated that at the end of a swath run, the lead acft pulled up to an almost vertical attitude & to an alt of between 300 & 400 ft AGL. At that time, the plane…Jun 9, 1983 · N31619 · Destroyed NTSB FTW82DA372Accident · No injuriesFinal reportAir Tractor AT-400 · Muleshoe, TXPilot collided with a water spraying machine while making crop spray pass. Landing gear tore off.Sep 9, 1982 · N2369N · Substantial damage NTSB FTW82DA301Accident · No injuriesFinal reportBeech B99A · Abilene, TXThe pilot was in the left seat and was getting a check ride from the chief pilot who was in the right seat. After making a series of touch-and-go landings, the aircraft pulled slightly to the left during a takeoff. A full pattern was then flown to runway 17R…Jul 28, 1982 · N326CA · Substantial damage NTSB FTW80FPD28Accident · No injuriesClosedAero-Comdr S-2R · Grandbury, TXMay 6, 1980 · N5600X · Substantial damage