NTSB investigations: Air Tractor AT-502B
140 cases on aircraft the registry lists as Air Tractor AT-502B. 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 ('0390307'))
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 ('0390307'))
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 DFW05LA179Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502B · Hickory Ridge, ARThe pilot's failure to maintain clearance with terrain during aerial application.NTSB MIA05LA060Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Avon, MSThe pilot's failure to maintain airspeed while maneuvering at a low altitude, resulting in an inadvertent stall/mush, and impact with terrain.NTSB CHI05FA055Accident · 1 fatalField investigationFinal reportCessna T-37B · Hollister, OKThe pilots of the AT-502B and the T-37B failed to maintain adequate visual lookout and did not maintain clearance from the other aircraft. Contributing factors included the lack of a transponder and radios on the AT-502B, and the reduced visibility due to…NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB FTW03LA223Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502B · Farwell, TXThe pilot's failure to maintain airspeed while maneuvering which resulted in an inadvertent stall.NTSB 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.NTSB 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.NTSB FTW03LA141Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Pond Creek, OKThe pilot's failure to attain adequate airspeed during liftoff resulting in a stall.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 FTW03LA098Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Holly Grove, ARThe pilot's failure to abort the takeoff.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB FTW01LA141Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Marvell, ARthe improper decision of the driver of the vehicle(ATV) to enter an active airstrip.NTSB ATL01LA063Accident · 2 fatalLimited investigationFinal reportAir Tractor 502B · Anguilla, MSFailure of both pilots to maintain visual lookout, resulting in an in-flight collision. A factor was sun glare.NTSB MIA01LA150Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Fort Pierce, FLThe loss of engine power during takeoff/initial climb due to compressor turbine blade separation.NTSB MIA01LA037Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Belle Glade, FLThe pilot's failure to maintain a visual lookout during a swath run resulting in an in-flight collision with known wires along the swath run, and a loss of directional control on landing roll due to flight control damage sustained during the in-flight…NTSB FTW00LA246Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502B · Eudora, ARthe pilot's failure to maintain obstacle clearance while maneuvering.NTSB MIA00LA237Accident · No injuriesLimited investigationFinal reportAir Tractor 502B · Perthshire, MSthe pilot's failure to perform a weight and balance check that resulted in overloading of the airplane with spraying material, for the weather conditions that existed at the time of takeoff. Factors in this accident were extremely high temperatures, which…NTSB FTW00LA008Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Bay City, TXThe pilot's inadvertent stall. A factor was the pilot's encounter with the airplane's wake turbulence.NTSB MIA99LA257Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502B · Anguilla, MSThe P3 air line disconnected at the P3 air filter housing , and a 'B' nut not being safetied by maintenance personnel, which resulted in a total loss of engine power.NTSB FTW99LA249Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Seminole, TXThe pilot's failure to maintain obstacle clearance.NTSB FTW99LA221Accident · Minor injuriesLimited investigationFinal reportAir Tractor 502B · Guthrie, TXThe pilot's inadequate weather evaluation prior to takeoff. Factors associated with the accident were an inadequate wind direction indicator, a sudden windshift, and a tailwind.NTSB CHI99FA267Accident · 1 fatalField investigationFinal reportAir Tractor AT502B · Giltner, NEThe pilot's inadequate visual lookout, and his failure to maintain clearance from the guy wire. A factor was the guy wire.NTSB FTW99LA196Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Marvel, ARThe pilot's failure to attain the proper takeoff airspeed.NTSB ATL99LA009Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT502B · Bainbridge, GAThe pilot's inadequate visual lookout which resulted in a collision with an irrigation unit located in the field.NTSB FTW99LA005Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Ringling, OKThe pilot's failure to maintain obstacle clearance. A factor was the sun glare which impaired the pilot's vision.NTSB FTW98LA383Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Portales, NMThe pilot's failure to maintain adequate altitude/clearance during an aerial application. Also causal was the inadvertent ground loop/swerve during the landing.NTSB FTW98LA225Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Parkin, ARthe pilot's improper planning/decision, which resulted in his failure to maintain sufficient altitude/clearance from trees at the departure end of the airstrip. Related factors were: high density altitude and trees at the departure end of the airstrip.NTSB FTW98LA140Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Lake Village, ARThe pilot's use of unsuitable terrain for takeoff. A factor was the rough/uneven terrain.NTSB FTW98FA100Accident · 1 fatalField investigationFinal reportAir Tractor 502B · Eudora, ARThe pilot's failure to maintain adequate airspeed while attempting an aerobatic manueverNTSB FTW96LA177Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Pond Creek, OKThe pilot's improper planning/decision and failure to obtain/maintain sufficient airspeed to climb after takeoff, which resulted in a stall/mush and subsequent collision with terrain. Factors relating to the accident were: failure of the pilot to follow short…NTSB ATL95LA168Accident · No injuriesLimited investigationFinal reportAir Tractor 502B · Minter City, MSInadequate preflight planning/preparation by the pilot. Factors relating to the accident were: the excessive gross weight of the airplane and the high outside air temperature, which would have reduced the performance of the airplane.NTSB FTW94LA239Accident · No injuriesLimited investigationFinal reportAir Tractor AT-501 · Marianna, ARA premature liftoff. Factors were the tall, wet grass and a tail wind component.