NTSB investigations: Air Tractor AT-602, TX
6 cases on aircraft the registry lists as Air Tractor AT-602, 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
| 2015 | 2 |
|---|---|
| 2019 | 2 |
| 2020 | 1 |
| 2026 | 1 |
Where
Latest 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.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0390309')
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."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0390309')
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 CEN26LA177Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · El Campo, TXThe pilot’s failure to maintain aircraft control during takeoff resulting in a collision with a building during takeoff.NTSB CEN20CA158Accident · No injuriesData collectionFinal reportAir Tractor AT 602 · El Campo, TXThe pilot's misjudgment of a ground spray rig’s position and his incorrect belief that a runway incursion might occur, which resulted in the pilot attempting and then aborting a go-around, which resulted in a runway excursion and collision with a fence.NTSB GAA19CA535Accident · Minor injuriesData collectionFinal reportAir Tractor AT 602 · Turkey, TXThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack during a low pass, which resulted in an aerodynamic stall and impact with terrain.NTSB GAA19CA354Accident · No injuriesData collectionFinal reportAir Tractor AT 602 · La Ward, TXThe pilot's failure to maintain clearance from a wire during an aerial application flight in sun glare conditions.NTSB GAA15CA023Accident · No injuriesData collectionFinal reportAir Tractor AT 602 · Ropesville, TXThe pilot's failure to maintain directional control during landing.NTSB CEN15LA138Accident · No injuriesLimited investigationFinal reportAir Tractor AT 602 · Slaton, TXMaintenance personnel’s improper installation of the engine data monitor (EDM), which was not in accordance with the supplemental type certificate instructions and resulted in engine warning indications and the pilot’s subsequent reaction to the warning…