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 SEA05FA025Accident · 2 fatalField investigationFinal reportCessna 208B · Bellevue, IDThe pilot's failure to maintain aircraft control while on approach for landing in icing conditions. Inadequate airspeed was a factor.Dec 6, 2004 · N25SA · DestroyedNTSB SEA05LA010Accident · No injuriesLimited investigationFinal reportBeech 99A · Billings, MTthe pilot's failure to follow the instrument approach procedure, which resulted in a premature descent below the decision height and subsequent collision with a building.Oct 18, 2004 · N955AA · Substantial damageNTSB CHI04LA298Accident · No injuriesLimited investigationFinal reportCessna 208B · Decatur, ILThe pilot's inadequate preflight preparation, and his subsequent selection of a runway for takeoff that was listed as out of service, resulting in a collision with barricades and uneven terrain during takeoff.Sep 29, 2004 · N276PM · Substantial damageNTSB CHI04LA278Accident · Serious injuriesLimited investigationFinal reportCessna 208B · Gwinner, NDThe pilot's failure to maintain altitude during the circling maneuver. Contributing factors were the pilot's improper decision to execute the approach when weather conditions were below minimums and the low light (dark night) conditions.Sep 24, 2004 · N7392B · Substantial damageNTSB ATL04CA185Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Belle Glade, FLThe pilot's inadequate preflight inspection and a loss of engine power due to water contamination of the fuel.Sep 15, 2004 · N90375 · Substantial damageNTSB ATL04CA189Accident · No injuriesData collectionFinal reportBeech D18S · Tullahoma, TNRight tire burst during an attempted takeoff that resulted in loss of directional control and the on ground collision with the ground.Sep 6, 2004 · N432U · Substantial damageNTSB CHI04LA213Accident · No injuriesLimited investigationFinal reportCessna 208B · Big Rapids, MIThe pilot's failure to verify that the cargo door was latched properly prior to flight and the subsequent in-flight opening of the door. A contributing factor was the box which departed the cargo compartment and struck the horizontal stabilizer.Aug 4, 2004 · N1037N · Substantial damageNTSB LAX04LA275Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Mendota, CAThe pilot's inadequate preflight/pretakeoff procedure by not lowering the wing flaps, which resulted in an inadvertent stall as the pilot attempted to climb out of ground effect to clear a corn crop at the end of the runway. A factor in the accident was the…Jul 23, 2004 · N5010E · Substantial damageNTSB CHI04IA178Incident · No injuriesIncident investigationFinal reportBeech 1900D · Milwaukee, WIThe fatigue fracture of the left main landing gear during landing roll.Jul 6, 2004 · N87SK · Minor damageNTSB ATL04CA146Accident · Minor injuriesData collectionFinal reportAir Tractor AT-402A · Hillsboro, ALThe pilot's inadequate visual lookout and failure to maintain adequate obstacle clearance, which resulted in collision with transmission wires.Jul 3, 2004 · N9089L · Substantial damageNTSB CHI04LA167Accident · No injuriesLimited investigationFinal reportBeech 200 · Green Bay, WIThe loss of engine power after takeoff for an undetermined reason.Jun 30, 2004 · N432FA · Substantial damageNTSB FTW04LA166Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Crowley, LAThe loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.Jun 23, 2004 · N60713 · Substantial damageNTSB FTW04LA156Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Joiner, ARThe pilot's failure to maintain clearance and altitude from terrain while maneuvering during an aerial application.Jun 8, 2004 · N9151C · DestroyedNTSB FTW04LA151Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Weldon, ARThe other pilot's failure to maintain an adequate visual lookout during approach to landing, which resulted in a midair collision between the two airplanes.Jun 3, 2004 · N5002D · 2 aircraft · Minor damageNTSB FTW04CA141Accident · No injuriesData collectionFinal reportAir Tractor AT-502 · Tarzan, TXThe pilot's failure to maintain proper airspeed suitable for flight. Contributing factors were the high density altitude and tail wind condition.May 26, 2004 · N61407 · Substantial damageNTSB FTW04CA139Accident · No injuriesData collectionFinal reportAir Tractor AT-402 · Beedeville, ARThe pilot's failure to maintain directional control of the airplane during landing roll-out. Contributing factors were the crosswind and condition of the the runway.May 24, 2004 · N45553 · Substantial damageNTSB FTW04LA130Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · San Angelo, TXThe loss of engine power for undetermined reasons. A contributing factor was the soft terrain encountered during the aborted takeoff.May 19, 2004 · N4508Y · DestroyedNTSB ANC04LA054Accident · No injuriesLimited investigationFinal reportCessna 208B · Egegik, AKThe captain's improper evaluation of the weather conditions and improper decision to taxi the airplane in high gusting wind conditions which resulted in the airplane's right wing striking the ground. A contributing factor was the high gusting wind.May 16, 2004 · N9820F · Substantial damageNTSB ATL04IA098Incident · No injuriesIncident investigationFinal reportCessna 208B · Tunica, MSThe pilot's improper use of the emergency power lever which resulted in excessive operating temperatures. A factor was the improper adjustment of the emergency power lever dead band.Apr 27, 2004 · N738FX · Minor damageNTSB FTW04CA112Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · San Angelo, TXThe pilot's improper preflight performance planning, and his failure to establish a climb. Factors were the high density altitude and crosswind.Apr 21, 2004 · N5196J · DestroyedNTSB 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 damageNTSB 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 damageNTSB ANC04LA032Accident · No injuriesLimited investigationFinal reportCessna 208B · Toksook Bay, AKThe pilot's inadequate planning and decision to initiate a takeoff into a crosswind that exceeded the airplane's demonstrated crosswind component, which resulted in a loss of directional control during the takeoff roll, and subsequent collision with terrain…Feb 10, 2004 · N1276P · Substantial damageNTSB ATL04IA073Incident · No injuriesIncident investigationFinal reportCessna 208B · Auburn, ALThe fatigue fracture of the wire rope portion on the rudder control cable assembly due to improper installation and inadequate procedures by the aircraft manufacturer.Feb 3, 2004 · N125AR · No damageNTSB MIA04WA051Accident · No injuriesForeign investigationAir Tractor AT-802 · Los Angeles, ChileJan 27, 2004 · N1531S · Substantial damageNTSB NYC04LA050Accident · No injuriesLimited investigationFinal reportCessna 208B · Covington, KYThe pilot's inadequate pre-flight inspection, which resulted in a decrease in airplane performance due to ice, and a subsequent hard landing.Dec 20, 2003 · N9469B · Substantial damageNTSB CHI04FA043Accident · 2 fatalField investigationFinal reportPiper PA46-500TP · Daytona Beach, FLThe unqualified pilot's continued flight into known instrument meteorological conditions which resulted in spatial disorientation and subsequent loss of aircraft control. Factors were the pilot's lack of instrument flight experience and the low ceiling.Dec 17, 2003 · N155BM · DestroyedNTSB NYC04LA044Accident · No injuriesLimited investigationFinal reportSocata TBM 700 · Reading, PAThe pilot's improper decision to not apply de-icing fluid to the wings prior to takeoff, which resulted in snow/ice contamination on the of the wings, a stall mush, and a forced landing in an open field.Dec 6, 2003 · N700QD · Substantial damageNTSB LAX04LA043Accident · No injuriesLimited investigationFinal reportCessna 208B · Phoenix, AZthe pilot's improper decision to taxi behind another airplane conducting an engine run-up, which resulted in a jet blast encounter.Nov 13, 2003 · N717BT · Substantial damageNTSB DEN04IA024Incident · No injuriesIncident investigationFinal reportBeech 1900D · Denver, COthe ground personnel’s failure to maintain aircraft clearance, resulting in the collision. Contributing factors include ground communications not coordinated by the ground personnel, the flight crew's inadequate visual outlook and the parked airplane.Nov 10, 2003 · N254GL · Minor damageNTSB NYC04IA023Incident · No injuriesIncident investigationFinal reportCessna 208B · Bangor, METhe pilot's inability to see through the windshield, which was obscured due to icing conditions. This resulted in the pilot's inadequate flare, and a subsequent hard landing. A factor contributing to the accident was the wing icing.Nov 5, 2003 · N805TH · Minor damageNTSB ATL03LA144Accident · Minor injuriesLimited investigationFinal reportBeech A90 · Summerville, SCThe pilot's inadequate preflight planning which resulted in fuel exhaustion and subsequent loss of engine power.Sep 22, 2003 · N34HA · Substantial damageNTSB MIA03LA183Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Fort Pierce, FLFailure of one blade in the engine compressor turbine disk due to fatigue which was caused by loss of gap between the blade platforms as a result of corrosion due to a foreign element (phosphate). This resulted in loss of engine power during takeoff and…Sep 18, 2003 · N1528T · DestroyedNTSB FTW03LA223Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502B · Farwell, TXThe pilot's failure to maintain airspeed while maneuvering which resulted in an inadvertent stall.Sep 12, 2003 · N61353 · DestroyedNTSB DCA03WA056Accident · 9 fatalForeign investigationBeech King Air B200 · Madeira Islands, PortugalSep 12, 2003 · N600BV · DestroyedNTSB NYC03MA183Accident · 2 fatalMajor investigationFinal reportBeech 1900D · Yarmouth, MAThe improper replacement of the forward elevator trim cable, and subsequent inadequate functional check of the maintenance performed, which resulted in a reversal of the elevator trim system and a loss of control in-flight. Factors were the flightcrew's…Aug 26, 2003 · N240CJ · DestroyedNTSB CHI03LA289Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Westside, IAThe pilot's inadequate preflight planning/preparation which led to fuel exhaustion and subsequent loss of engine power. Contributing factors were the unsuitable terrain encountered, and the terrace/embankment.Aug 22, 2003 · N5007G · Substantial damageNTSB CHI03LA276Accident · No injuriesLimited investigationFinal reportBeech 1900D · Muskegon, MIThe airplane colliding with a deer during the landing roll.Aug 20, 2003 · N79SK · Substantial damageNTSB CHI03LA273Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T660 · Blytheville, ARThe pilot's inadequate visual lookout and altitude/clearance not being maintained from the transmission wires. A factor to the accident was the transmission wires.Aug 19, 2003 · N4114A · DestroyedNTSB ANC03FA096Accident · 2 fatalField investigationFinal reportReims 406 · Barrow, AKAn in-flight collision with ocean waters while maneuvering for an undetermined reason.Aug 17, 2003 · N6591L · Substantial damageNTSB CHI03LA270Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Hudson, ILThe pilot failed to abort the takeoff. A factor was the soybean crop.Aug 15, 2003 · N9187Z · Substantial damageNTSB ANC03LA071Accident · Serious injuriesLimited investigationFinal reportCessna 208B · Kotzebue, AKThe airplane encountered unforecast turbulence, which resulted in serious injury to the pilot.Jul 9, 2003 · N410GV · No damageNTSB CHI03IA153Incident · No injuriesIncident investigationFinal reportBeech 1900D · Milwaukee, WIFailure of the aileron sprocket assembly at the sprocket-to-shaft braze joint. Contributing factors were the improper braze procedure used by the part manufacturer at the time of fabrication which resulted in an inferior quality joint and the inadequate…Jun 7, 2003 · N901SK · Minor damageNTSB LAX03LA180Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502A · Raywood, TXthe pilot's encounter with a stall/mush condition in the takeoff initial climb due to his inadequate preflight/pretakeoff procedures and failure to set the wing flaps to the proper takeoff configuration before beginning the takeoff ground roll.Jun 3, 2003 · N948BB · DestroyedNTSB FTW03LA158Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Edna, TXThe pilot's failure to maintain clearance with the transmission wires while maneuvering during an aerial application flight. A contributing factor was the haze restricting the visibility.May 19, 2003 · N9086M · DestroyedNTSB NYC03LA107Accident · Minor injuriesLimited investigationFinal reportCessna 208B · New Russia, OHThe pilot's failure to verify the position of the fuel selectors prior to takeoff, which resulted in a power loss due to fuel starvation. A factor was the failure of the fuel selector warning horn.May 15, 2003 · N208AD · Substantial damageNTSB CHI03LA118Accident · 2 fatalLimited investigationFinal reportAir Tractor AT-503A · Pontiac, ILThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall/spin. A factor associated with the accident was the low altitude maneuver.May 5, 2003 · N503D · Substantial damageNTSB FTW03LA141Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Pond Creek, OKThe pilot's failure to attain adequate airspeed during liftoff resulting in a stall.Apr 28, 2003 · N60819 · DestroyedNTSB ATL03FA082Accident · 1 fatalField investigationFinal reportSocata TBM 700B · Mobile, ALThe improper installation of the power control linkage on the engine fuel control unit by maintenance personnel which resulted in a loss of power lever control, and the pilot's failure to follow emergency procedures and his intentional engine shutdown which…Apr 25, 2003 · N705QD · Substantial damageNTSB DEN03LA077Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Sedan, NMthe nonmechanical partial loss of engine power due to water contamination of the fuel. Contributing factors include the lack of suitable terrain for a forced landing (due to his low altitude), and the irrigation system (object) that was impacted.Apr 24, 2003 · N318BR · Substantial damage