NTSB investigations: Air Tractor AT-502
97 cases on aircraft the registry lists as Air Tractor AT-502. 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.aircraft_model_code IN ('0390303'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0390303'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 CHI05CA245Accident · No injuriesData collectionFinal reportAir Tractor AT-502 · Hector, MNThe pilot's failure to achieve adequate airspeed on takeoff which resulted in the airplane entering a stall/mush when it flew out of ground effect while crossing a large drainage ditch on takeoff.NTSB MIA05LA127Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Fort Pierce, FLThe failure of the pilot to abort the takeoff after a reported loss of engine power during the takeoff roll, resulting in the in-flight collision with a fence and trees. A factor in the accident was the failure of the pilot to lower the flaps to 10 degrees as…NTSB 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.NTSB 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…NTSB CHI03LA270Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Hudson, ILThe pilot failed to abort the takeoff. A factor was the soybean crop.NTSB 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.NTSB MIA03LA088Accident · 1 fatalLimited investigationFinal reportAir Tractor 502B · Belle Glade, FLThe failure of both pilots to use on-board communication radios to advise takeoff and landing intentions, the reduction of visibility of the pilot-in-command of N6037H due to sun glare during takeoff, and the poor in-flight planning by the pilot-in-command of…NTSB FTW03LA050Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Weiner, ARThe loss of engine power due to a compressor stall for undetermined reasons. A contributing factor was the soft terrain.NTSB 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.NTSB 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.NTSB 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.NTSB FTW00LA259Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502 · Lariat, TXThe pilot's failure to maintain clearance with the antenna guy wire. A factor was the pilot's physical impairment from his use of diphenhydramine.NTSB FTW00LA233Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Deerpark, LAthe failure of both pilots to maintain a visual outlook during landing approach. A contributing factor was both pilot's failure to follow recommended traffic patterns.NTSB FTW00LA232Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Helena, ARthe pilot's failure to maintain obstacle clearance. A contributing factor was the sun glare.NTSB CHI00LA177Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Portland, NDthe pilot intentionally operated the airplane with known damage on the left wing which resulted in the pilot's inability to maintain control of the airplane during takeoff.NTSB SEA99LA114Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502 · Shelley, IDThe pilot-in-command's failure to maintain adequate clearance with obstacles. A contributing factor were the trees.NTSB FTW99LA152Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Cherry Valley, ARThe pilot's inadvertent stall due to his evasive maneuver to avoid colliding with a truck on the runway. A factor was the runway incursion by the truck.NTSB MIA98LA202Accident · No injuriesLimited investigationFinal reportAir Tractor 502 · Clewiston, FLThe pilot's failure to attain adequate airspeed. A tailwind was a contributing factor.NTSB CHI98LA243Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Minto, NDthe pilot's selection of unsuitable terrain for takeoff. Factors were wet and soft runway conditions, and a ditch and the end of the overrun area.NTSB MIA98LA188Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Okeechobee, FLthe pilot's improper planning/decision, by failing to ensure the aircraft contained adequate fuel to complete the flight, which led to fuel exhaustion, loss of engine power, and a forced landing. Obstructions (trees and guardrail) in the emergency landing…NTSB MIA98LA178Accident · No injuriesLimited investigationFinal reportAir Tractor 502 · Clarksdale, MSThe pilot's failure to extend the flaps for takeoff. A factor was his diverted attention to the loading of the airplane.NTSB MIA98LA175Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Clewiston, FLThe pilot's inadequate visual lookout while taxiing for takeoff.NTSB FTW98FA151Accident · 1 fatalField investigationFinal reportAir Tractor AT-502 · Mcgehee, ARThe pilot's inadvertent flight into adverse weather conditions resulting in the loss of control due to spatial disorientation. Factors were the fog and low ceiling, and the inadequate flight instruments available to the pilot.NTSB MIA97LA195Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Tunica, MSThe pilots poor preflight planning preparation for attempting to takeoff with a tailwind and with the hopper loaded 3/4 full during a 93degree F., day at a density altitude of 2,400 feet.NTSB FTW97LA140Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Watson, ARThe pilot's failure to attain lift off speed and the ground loop/swerve encountered. Factors were the gravel and soft terrain at the end of the runway.NTSB FTW97LA134Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Paragould, ARThe pilot's failure to maintain clearance from trees resulting in jammed control surfaces. A factor was that aircraft control was not possible by the pilot.NTSB FTW97LA019Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Throckmorton, TXfailure of the pilot to maintain clearance of a transmission wire during pullup from a swath run. The proximity of the transmission wire was a related factor. The installation of wire cutter equipment on the landing gear might have prevented or reduced the…NTSB FTW97LA012Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Idalou, TXthe pilot's improper planning/decision, which resulted in an overrun during takeoff and an encounter with cotton (crop) and rough/uneven terrain. Factors relating to the accident were: the excessive loading of the airplane for the existing conditions, the…NTSB FTW96LA148Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Texarkana, ARa loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB MIA95LA229Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502 · Lorida, FLMismanagement of the fuel by the pilot resulting in the total loss of engine power due to fuel exhaustion, and the pilot's poor decision to fly over water en route to the refueling airport.NTSB SEA95LA158Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Idaho Falls, IDThe pilot's inadequate airspeed at liftoff. Contributing to the accident were high density altitude, tailwind conditions, the pilot's selection of an excessive takeoff flap setting, and a windshear encounter.NTSB FTW95LA284Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Elaine, ARThe pilot did not maintain a positive rate of climb.NTSB MIA95LA173Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Belzoni, MSInadequate compensation for wind conditions by the pilot. The gusty crosswind was a factor.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.NTSB FTW95LA207Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502 · Mcgehee, ARThe ground service person's lack of attention and failure to remain clear of the turning propeller.NTSB FTW95LA014Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Lamesa, TXThe loss of directional control on the ground and the pilot's inadvertent ground loop. A factor was the failure by the pilot of the conflicting traffic on the runway to maintain proper traffic separation.NTSB FTW94LA257Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Bosco, LAThe pilot's failure to maintain clearance with the telephone pole.NTSB FTW94FA121Accident · 1 fatalField investigationFinal reportAir Tractor AT-502 · Hughes, ARWas the pilot's failure to maintain terrain clearance for undetermined reason.NTSB FTW94LA098Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Moro, ARThe pilot's failure to maintain clearance of power lines.NTSB DEN93LA093Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Brookland, ARThe pilot's failure to maintain adequate object clearance.NTSB FTW93FA197Accident · 1 fatalField investigationFinal reportAir Tractor AT-502 · Petronila, TXFailure of the pilot to maintain sufficient airspeed, while maneuvering, which resulted in an inadvertent stall. A factor related to the accident was: his lack of altitude for recovery from the stall.NTSB FTW92DRD04Accident · Minor injuriesFinal reportAir Tractor AT-502 · Mamou, LAThe pilot's failure to maintain proper clearance.NTSB DEN91LA114Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Clovis, NMFailure of the pilot to maintain clearance from rising/uneven terrain. Factors related to the accident were: the light conditions at dusk, and the lack of visual cues for the pilot.NTSB MIA91LA196Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Cleveland, MSThe pilot's decision to continue the flight with reduced visual lookout due to a dirty foggy windshield.NTSB MKC90LA023Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Heafer, ARThe intentional swerve by the pilot during the takeoff roll. Contributing to the accident was the rough and soft terrain conditions.NTSB FTW89DRA04Accident · No injuriesFinal reportAir Tractor AT-502 · Ganado, TXLoss of directional control for an unknown reason.NTSB FTW88DPA03Accident · No injuriesFinal reportAir Tractor AT-502 · Olney, TXThe pilot was familiarizing himself with this type of aircraft and was making a full flap landing. He allowed the aircraft to drift left during the landing roll in a slight crosswind. He then attempted to abort the landing roll with the application of takeoff…