NTSB investigations: Air Tractor AT-502
17 cases on aircraft the registry lists as Air Tractor AT-502, where the sequence of events included Collision with terr/obj (non-CFIT). 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 per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2011 | 2 |
| 2012 | 2 |
| 2014 | 1 |
| 2016 | 4 |
| 2019 | 3 |
| 2022 | 2 |
| 2024 | 1 |
Where
Open the mapLatest cases
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
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 CEN24LA193Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-502 · Covert, KSThe improper maintenance of the fuel control unit, which resulted in air leakage and a loss of control of fuel flow to the engine.NTSB ERA22FA350Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-502 · Cheneyville, LAThe pilot’s loss of control after exceeding the airplane’s critical angle of attack for reasons that could not be determined.NTSB CEN22LA352Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · Washington, LAThe pilot’s failure to maintain clearance from a wire during an aerial application of a field.NTSB CEN20LA013Accident · Serious injuriesClass 3 · LimitedFinal reportAir Tractor AT 502 · Lamesa, TXThe pilot's improper decision to maneuver at a low altitude and in close proximity to a wind turbine undergoing maintenance, which resulted in a collision with a tagline rope being held by a worker on the ground and serious injury to the worker.NTSB GAA19CA453Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Stanton, TXThe pilot's failure to maintain clearance from wires during an agricultural application flight.NTSB CEN19FA117Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT 502 · Harlingen, TXThe pilot’s failure to maintain clearance from power transmission lines during low altitude flight operations. Contributing to the accident was the pilot’s impairment due to a sedating medication.NTSB GAA16CA321Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Delhi, LAThe pilot's inability to maintain directional control during the landing roll as a result of a piece of concrete from the runway impacting the right main landing gear brake during the landing roll, resulting in a right brake failure and a ground loop.NTSB CEN16LA208Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Ropesville, TXThe pilot's failure to maintain airspeed and his exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall while maneuvering.NTSB CEN16LA181Accident · 1 fatalLimited investigationFinal reportAir Tractor AT 502 · West, TXThe pilot’s failure to see and avoid cellular tower guy wires. Contributing to the accident was the pilot’s decision to operate at low altitude.NTSB CEN16LA154Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT 502 · Kilbourne, LAThe failure of the operator to comply with the terminating action of the airworthiness directive, which resulted in the subsequent failure and separation of the vertical stabilizer due to fatigue.NTSB CEN14LA349Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Carthage, ILThe airplane’s inability to climb out of ground effect, which resulted from the pilot using a lower power setting than needed for takeoff due to the mechanic’s installation of the wrong engine torque gauge.NTSB CEN12CA546Accident · Minor injuriesData collectionFinal reportAir Tractor AT-502 · Hanley Falls, MNThe pilot’s failure to maintain clearance from a guy wire during an agricultural application pass.NTSB CEN12CA375Accident · No injuriesData collectionFinal reportAir Tractor AT-502 · Ipswich, SDThe pilot's failure to abort the takeoff, which resulted in a runway excursion.NTSB CEN11LA499Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Fergus Falls, MNThe total loss of engine power for reasons that could not be determined because the airplane came to rest inverted in water.NTSB WPR11LA288Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Lewistown, MTThe fatigue fracture and separation of the fuel bypass line, which resulted in a total loss of engine power.NTSB CEN09CA540Accident · Minor injuriesData collectionFinal reportAir Tractor AT-502 · East Grand Forks, MNThe pilot's failure to maintain clearance with the crops while maneuvering at low altitude.NTSB MIA08CA170Accident · Minor injuriesData collectionFinal reportAir Tractor AT-502 · Satartia, MSThe pilot's inadequate visual lookout resulting in the in-flight collision with a 40-foot-tall antenna.