NTSB investigations: Pratt & Whitney PT6A series

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

Cases, newest first

Query with SQL
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 ('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.

NTSB FTW03LA133Accident · No injuriesLimited investigationFinal reportAir Tractor AT-402B · Taft, TXThe partial loss of engine power resulting from a leaking fuel transfer tube following inadequate maintenance by unknown personnel. A contributing factor was the furrowed terrain encountered during the forced landing.Apr 17, 2003 · N6078W · Substantial damageNTSB LAX03LA122Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Avondale, AZThe pilot failed to maintain adequate visual lookout and did not maintain clearance from power lines. The backhoe's location, which caused the pilot to alter his planned flight path, was a factor.Apr 1, 2003 · N30913 · Substantial damageNTSB IAD03FA035Accident · 3 fatalField investigationFinal reportSocata TBM 700 · Leesburg, VAThe pilot's failure to fly a stabilized, published instrument approach procedure, and his failure to maintain adequate airspeed which led to an aerodynamic stall.Mar 1, 2003 · N700PP · Substantial damageNTSB FTW03LA098Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Holly Grove, ARThe pilot's failure to abort the takeoff.Feb 18, 2003 · N61802 · Substantial damageNTSB ENG03RA010Accident · Minor injuriesForeign investigationCessna 208 · Caqueta Province, ColombiaFeb 13, 2003 · N1116G · DestroyedNTSB ANC03LA030Accident · No injuriesLimited investigationFinal reportCessna 208B · Russian Mission, AKThe failure of the pilot to use a tail stand while loading passengers, which resulted in the airplane's tail impacting the ground.Jan 30, 2003 · N1276P · Substantial damageNTSB DEN03MA035Accident · 5 fatalMajor investigationFinal reportPiper PA-31T · Denver, COBoth pilots' inadequate visual lookout. A contributing factor was the Cheyenne pilot operating the airplane with a known transponder deficiency.Jan 25, 2003 · N360LL · 2 aircraft · DestroyedNTSB FTW03FA089Accident · Serious injuriesField investigationFinal reportCessna 208B · San Angelo, TXThe flight crew's failure to cycle the deice boots prior to conducting a simulated forced landing and their failure to maintain adequate airspeed during the maneuver, which resulted in an inadvertent stall and subsequent loss of control. A contributing factor…Jan 24, 2003 · N944FE · DestroyedNTSB DCA03MA022Accident · 21 fatalClass 1 · MajorFinal reportBeech 1900D · Charlotte, NCthe airplane's loss of pitch control during take-off. The loss of pitch control resulted from the incorrect rigging of the elevator system compounded by the airplane's aft center of gravity, which was substaintially aft of the certified aft limit.…Jan 8, 2003 · N233YV · DestroyedNTSB MIA03FA034Accident · 1 fatalField investigationFinal reportCessna 208B · Manteo, NCThe pilot's continued descent below the minimum descent altitude, for undetermined reasons, while performing a NDB approach, resulting in the airplane crashing into water 1.5 miles from the airport. A factor in the accident was a cloud ceiling below the…Dec 25, 2002 · N1122Y · Substantial damageNTSB CHI03FA041Accident · 1 fatalField investigationFinal reportCessna 208B · Rockford, ILThe pilot's failure to maintain control of the airplane during the ILS approach. Factors associated with the accident were the low ceilings, high winds, crosswind, and wind shear conditions that existed.Dec 18, 2002 · N277PM · DestroyedNTSB MIA03LA033Accident · No injuriesLimited investigationFinal reportBeech 200 · Jacksonville, FLFailure of the main landing gear locking mechanism for undetermined reasons, which resulted in the main landing gear collapsing, and damage to the airplane during landing.Dec 14, 2002 · N623VP · Substantial damageNTSB FTW03FA059Accident · 3 fatalField investigationFinal reportBeech 1900C · Eagleton, ARIn-flight collision with terrain due to the pilot's failure to maintain clearance and altitude above rapidly rising terrain while on a VFR approach. Contributing factors were the obscuration of the terrain due to clouds.Dec 9, 2002 · N127YV · DestroyedNTSB DEN03FA012Accident · 4 fatalField investigationFinal reportCessna 208B · Parks, AZthe pilot's improper in flight planning/decision making, his flight into known icing conditions, and his failure to maintain adequate airspeed which resulted in the inadvertent stall/spin and impact with terrain. Factors contributing to the accident were the…Nov 8, 2002 · N514DB · DestroyedNTSB ATL03FA008Accident · 1 fatalField investigationFinal reportCessna 208B · Spanish Fort, ALthe pilot's spatial disorientation, which resulted in loss of airplane control. Contributing to the accident was the night instrument meteorological conditions with variable cloud layers.Oct 24, 2002 · N76U · DestroyedNTSB NYC03FA008Accident · Minor injuriesField investigationFinal reportPilatus PC-12/45 · Trenton, NJA power loss, due to failure of the No. 1 bearing, which was a result of previous electrical discharge damage (EDD). Factors were the low ceiling and a wet runway.Oct 16, 2002 · N96WF · Substantial damageNTSB NYC02LA199Accident · Serious injuriesLimited investigationFinal reportCessna 208B · Pawtucket, RIThe parachutist's failure to obtain the proper touchdown point, which resulted in contact with the operating propeller of a parked airplane.Sep 29, 2002 · N9347B · No damageNTSB DEN02FA105Accident · No injuriesField investigationFinal reportPiper PA-24-260 · Rock Springs, WYthe flight crew of the Beech and the pilot of the Piper's failure to attain proper clearance from the other during their respective landings. Factors contributing to the accident were the crew's and the pilot of the other airplane's inadequate visual lookout…Sep 15, 2002 · N8822P · 2 aircraft · Substantial damageNTSB CHI02LA259Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-402A · Cherokee, IAThe pilot failed to maintain clearance with the power lines resulting in the rudder separation and the subsequent loss of aircraft control. A factor associated with the accident was the power line that was contacted.Aug 25, 2002 · N9032K · Substantial damageNTSB SEA02LA161Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Rigby, IDThe failure of one or more compressor turbine blades resulting in a shutdown of the engine during initial climb resulting in a forced landing. Contributing factors were the eroded condition of the compressor turbine guide vane nozzles and the ditch which the…Aug 20, 2002 · N6146G · Substantial damageNTSB DEN02TA092Accident · Minor injuriesFinal reportAir Tractor AT-802A · Broomfield, COthe airplane's left main landing gear tire separated from its wheel during takeoff roll for an undetermined reason. Contributing factors were the pilot's inability to maintain aircraft control during takeoff roll and the subsequent impact with the Visual…Aug 14, 2002 · N91092 · Substantial damageNTSB LAX02LA240Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · San Manuel, AZthe pilot's failure to maintain adequate airspeed while maneuvering in a box canyon, which resulted in a stall/mush. A factor in the accident was downdraft conditions that led to an uncontrolled decent.Jul 27, 2002 · N293JK · Substantial damageNTSB ANC02LA079Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6 · Toksook Bay, AKA bird strike during takeoff, which resulted in damage to the right wing.Jul 13, 2002 · N885EA · Substantial damageNTSB MIA02LA119Accident · No injuriesLimited investigationFinal reportCessna 208B · Isla De Vieques, PRthe failure of both pilots to see and avoid, also causal was the failure of the pilot of the Britten-Norman Islander (N663VL) to yield right of way to an aircraft in the traffic pattern.Jun 20, 2002 · N786DM · 2 aircraft · Substantial damageNTSB ANC02LA053Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6-300 · Ketchikan, AKThe failure of a ground handler to follow company proceedure/directives, and his premature release of a mooring line. Factors associated with the accident were the congested operations area, and the operator's failure to provide adequate safe zones for the…Jun 20, 2002 · N353PM · 2 aircraft · Substantial damageNTSB FTW02LA158Accident · No injuriesLimited investigationFinal reportAir Tractor 402 · Hughes, ARthe pilot's failure to maintain directional control during the landing roll. Contributing factors were the malfunction of the tail wheel locking mechanism and the high vegetation along the sides of the airstrip.May 20, 2002 · N91660 · Substantial damageNTSB MIA02WA096Accident · No injuriesForeign investigationSocata TBM 700 · Moulins, FranceMay 13, 2002 · N700AR · Substantial damageNTSB LAX02LA147Accident · No injuriesLimited investigationFinal reportAir Tractor AT-802A · Kingman, AZThe failure of the pilot to maintain directional control during landing.May 2, 2002 · N90802 · Substantial damageNTSB FTW02LA120Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Lamesa, TXThe loss of engine power due to contamination of the fuel system. A contributing factor was the lack of suitable terrain for the forced landing.Apr 15, 2002 · N91905 · Substantial damageNTSB FTW02LA116Accident · No injuriesLimited investigationFinal reportAir Tractor 502B · Palestine, ARthe pilot's failure to maintain clearance with the power line while maneuvering during an aerial application flight.Apr 10, 2002 · N9074H · Substantial damageNTSB CHI02FA093Accident · 1 fatalField investigationFinal reportCessna 208B · Alma, WIThe pilot not removing the ice contamination from the airplane prior to departure and the pilot intentionally flying into known severe icing conditions, resulting in the aircraft not being able to maintain altitude/clearance from the terrain. Factors to the…Mar 15, 2002 · N228PA · Substantial damageNTSB LAX02FA108Accident · Serious injuriesField investigationFinal reportBeech E90 · Reno, NVThe pilot's inadequate approach airspeed for the existing adverse meteorological conditions followed by his delayed remedial action to avert stalling and subsequent loss of airplane control. Contributing factors were the pilot's reduced visibility due to the…Mar 14, 2002 · N948CC · DestroyedNTSB NYC02LA069Accident · No injuriesLimited investigationFinal reportPiper P46T · Philadelphia, PAThe pilot's improper recovery from a bounced landing. A factor was the pilot's failure to flare during initial touchdown.Mar 8, 2002 · N117NU · Substantial damageNTSB ANC02FA020Accident · No injuriesField investigationFinal reportCessna 208B · Barrow, AKThe pilot's continued flight into adverse weather conditions, and an inadvertent stall. Factors associated with the accident are fog, obscuration, and icing conditions.Mar 6, 2002 · N208TF · Substantial damageNTSB ATL02LA060Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Schlater, MSan unknown person at an unknown time exceeded the engine temperature limitations that resulted in the failure of compressor turbine and the subsequent loss of engine power during takeoff.Mar 5, 2002 · N9185F · Substantial damageNTSB FTW02LA086Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502B · Extension, LAThe pilot's failure to maintain aircraft control. A factor was the pilot's impairment due to drugs.Feb 28, 2002 · N6073U · Substantial damageNTSB ANC02LA016Accident · No injuriesLimited investigationFinal reportCessna 208B · Tununak, AKThe pilot's selection of unsuitable terrain for landing. Factors associated with the accident are snow drifts across the runway, and excessive braking during the rearward roll.Feb 24, 2002 · N454SF · Substantial damageNTSB 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 · DestroyedNTSB LAX02LA034Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401B · Las Vegas, NVthe failure of the AT-401 pilot to maintain clearance with the AT-402 airplane during landing. Contributing factors were the unreliable communication radio in the AT-401, the AT-401 pilot's continued flight with known communication radio problems, and the…Nov 30, 2001 · N9186J · 2 aircraft · No damageNTSB 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 · DestroyedNTSB FTW02LA010Accident · No injuriesLimited investigationFinal reportAir Tractor 402 · Angie, LAthe loss of engine power during takeoff for undetermined reasons.Oct 1, 2001 · N402RW · Substantial damageNTSB CHI01LA326Accident · No injuriesLimited investigationFinal reportCessna 208 · Aurora, MNThe pilot not maintaining the proper descent rate during the landing. Factors were the flap's popped circuit breaker, the pilot not verifying the flap's position, the glassy water, and the dock.Sep 27, 2001 · N12712 · Substantial damageNTSB MIA01LA205Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-402A · Whitakers, NCthe pilot's failure to maintain an adequate visual lookout and the proper clearance from obstacles while conducting aerial applications, which resulted in an inflight collision with a power utility pole.Jul 31, 2001 · N9072T · DestroyedNTSB SEA01LA139Accident · No injuriesLimited investigationFinal reportPilatus PC-6/B2-H4 · Great Falls, MTPilot's failure to maintain directional control of the aircraft while landing.Jul 21, 2001 · N2TS · Substantial damageNTSB ATL01LA104Accident · No injuriesLimited investigationFinal reportPiper PA-46-500TP · Pahokee, FLThe pilot's failure to follow the checklist while making an approach for landing resulting in a wheels up landing. Contributing to the accident was the certified flight instructor inadequate supervision of the rated pilot receiving instruction.Jul 9, 2001 · N747DN · Substantial damageNTSB ATL01LA074Accident · No injuriesLimited investigationFinal reportCessna 208B · Ft. Lauderdale, FLThe undetermined malfunction of the propeller system.Jul 6, 2001 · N812MA · DestroyedNTSB CHI01LA183Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-402 · Catron, MOthe failure of the pilot to maintain clearance from the electrical wires.Jun 22, 2001 · N91966 · Substantial damageNTSB FTW01LA147Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Newport, ARthe loss of control during takeoff initial climb as a result of encountering wake turbulence due to the pilot's failure to recognize the hazard and delay the takeoff.Jun 19, 2001 · N6082B · Substantial damageNTSB CHI01LA167Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-6 Twin Otter · Ottawa, ILthe failure of the passenger to maintain clearance from the windmilling propeller after exiting the airplane.Jun 16, 2001 · N30EA · Minor damageNTSB FTW01LA141Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Marvell, ARthe improper decision of the driver of the vehicle(ATV) to enter an active airstrip.Jun 12, 2001 · N6181Q · Substantial damage