Air Tractor AT-502A
NTSB investigations · 17
Matched to the registry by N-number and event date, 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
WHERE a.aircraft_model_code IN ('0390306')
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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('0390306')
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 CEN26LA118Accident · No injuriesClass 4 · LimitedInvestigation openAir Tractor AT-502A · Sulphur, LANTSB ERA24FA274Accident · 1 fatalClass 3 · FieldPreliminary reportAir Tractor AT502 · Martin, TNOn June 25, 2024, about 0820 central daylight time, an Air Tractor, Inc. AT-502A, N325RA, was substantially damaged when it was involved in an accident near Martin, Tennessee. The commercial pilot was fatally injured. The airplane was operated as a Title…NTSB WPR24LA070Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-502A · Stratford, CAA partial loss of engine power due to the malfunction of the engine compressor bleed-off valve.NTSB CEN23LA244Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · Sturgis, SDThe pilot’s improper timing to initiate beta mode with the propeller and his failure to maintain directional during the full load landing that resulted in a runway excursion. Contributing to the accident was the pilot’s lack of recent experience with…NTSB CEN22FA347Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT502 · Ute, IAThe pilot’s inflight collision with a power line during aerial application.NTSB CEN21LA223Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT-502A · Clayton, LAThe pilot’s loss of airplane control resulting in an aerodynamic stall while executing a steep turnaround during an aerial application flight.NTSB CEN19FA140Accident · 1 fatalField investigationFinal reportAir Tractor AT502 · Eagle Lake, TXThe non-instrument-rated pilot's decision to fly into instrument meteorological conditions, which resulted in spatial disorientation, a loss of control, and a subsequent impact with terrain.NTSB GAA18CA447Accident · No injuriesData collectionFinal reportAir Tractor AT502 · Iowa, LAThe pilot's failure to maintain directional control during the landing roll.NTSB CEN09CA295Accident · Minor injuriesData collectionFinal reportAir Tractor AT502 · Lisse, TXA total loss of engine power for undetermined reasons.NTSB SEA07LA204Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502A · Chowchilla, CAThe loss of engine power as the result of the fatigue fracture and separation of two compressor turbine blades, which induced a catastrophic failure of the compressor turbine section.NTSB DEN07LA020Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502A · Deming, NMThe pilot's failure to maintain aircraft control while maneuvering resulting in an inadvertent stall and impact with terrain. A contributing factor was the low airspeed.NTSB LAX06CA142Accident · No injuriesData collectionFinal reportAir Tractor 502A · Stanfield, AZthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during the landing roll.NTSB 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.NTSB LAX00FA169Accident · 1 fatalField investigationFinal reportAir Tractor 502A · Queen Creek, AZThe fatigue failure and in-flight separation of the left wing due to the manufacturer's underestimation during the aircraft design process of the time interval from fatigue crack initiation to failure, and, the manufacturer's subsequent specification of an…NTSB FTW99LA137Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502A · Huffman, TXThe pilot's inadequate compensation for the wind conditions during landing. Factors were the wind gusts and the high vegetation beside the runway.NTSB FTW97LA225Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502A · Chesterville, TXan undetermined malfunction/failure of the propeller reversing system.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.
Back to Air Tractor AT-502A