NTSB investigations: Air Tractor AT-502B
19 cases on aircraft the registry lists as Air Tractor AT-502B, where NTSB found Altitude. 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 |
| 2015 | 2 |
| 2016 | 4 |
| 2017 | 4 |
| 2019 | 2 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 1 |
| 2025 | 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 ('0390307')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE f.case_mkey = x.case_mkey AND f.aircrafts_position = x.position AND starts_with(f.\"findingCode\", '01062012')))
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE f.case_mkey = x.case_mkey AND f.aircrafts_position = x.position AND starts_with(f."findingCode", '01062012')))
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 CEN25LA274Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT502 · Hastings, NEThe pilot’s failure to maintain clearance from powerlines while maneuvering at low altitude.NTSB CEN24FA021Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-502B · Vidalia, LAThe pilot’s failure to maintain clearance from power lines during an aerial application flight. Contributing to the accident was the pilot’s cell phone use and the position of the sun, which reduced the pilot’s ability to perceive the location of the power…NTSB ERA22LA302Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-502B · Center Cross, VAA loss of engine power for reasons that could not be determined.NTSB CEN21LA283Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Edwardsburg, MIThe pilot’s failure to identify rising terrain and to maintain terrain clearance from trees during an aerial application pass that resulted in an in-flight collision with trees and terrain.NTSB CEN20CA221Accident · No injuriesClass 4 · Data collectionFinal reportAir Tractor AT502 · Hiawatha, KSThe pilot’s decision to attempt the takeoff with a tailwind in high density altitude conditions.NTSB GAA19CA502Accident · No injuriesData collectionFinal reportAir Tractor AT502 · Onida, SDThe pilot's failure to maintain clearance from power wires during agricultural application operations.NTSB GAA19CA328Accident · Minor injuriesData collectionFinal reportAir Tractor AT502 · Monument, KSThe pilot's failure to maintain altitude due to distraction by ground equipment in the airplane’s path, which resulted in his failure to maintain clearance from crops during an agricultural application flight and resulted in a loss of airplane control.NTSB ERA17FA279Accident · 1 fatalField investigationFinal reportAir Tractor AT502 · Philipp, MSThe pilot's improper decision to attempt a visual flight rules flight in instrument meteorological conditions, below a low overcast ceiling, which resulted in controlled flight into terrain.NTSB CEN17CA294Accident · Minor injuriesData collectionFinal reportAir Tractor AT 502B · Harrold, SDThe pilot’s improper attempt at a low-pass maneuver, which resulted in a collision with a tractor.NTSB GAA17CA385Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Edna, TXThe pilot’s failure to see and avoid a tower during an agricultural application flight.NTSB GAA17CA360Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Portales, NMThe pilot's decision to fly the airplane under transmission lines while maneuvering at low altitude in high-density altitude conditions, which resulted in subsequent collision with terrain.NTSB CEN17LA027Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT 502B · Hereford, TXThe pilot's failure to maintain clearance from a cotton crop while maneuvering during agricultural application operations, which resulted in a loss of airplane control.NTSB GAA17CA030Accident · Minor injuriesData collectionFinal reportAir Tractor AT 502 · Paragould, ARThe pilot's failure to avoid electrical wires during low-altitude maneuvering, which resulted in a wire strike.NTSB CEN16LA312Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502B · Hickory Ridge, ARThe pilot's failure to maintain clearance from a transmission line while maneuvering at low altitude.NTSB GAA16CA303Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Nicolaus, CAThe pilot's insufficient clearance from a power line during aerial application operations, which resulted in a power line strike, a forced landing on unsuitable terrain, loss of directional control, and collision with terrain.NTSB GAA15LA101Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT 502B · Archer City, TXThe pilot’s failure to maintain adequate clearance from power transmission lines during an aerial application flight.NTSB CEN15LA222Accident · 1 fatalLimited investigationFinal reportAir Tractor AT 502B · Basile, LAThe pilot’ failure to maintain adequate clearance from trees while maneuvering during an aerial application flight.NTSB CEN09CA194Accident · Minor injuriesData collectionFinal reportAir Tractor AT-502B · Harrold, SDThe pilot's failure to maintain clearance from the power lines during his turn to reverse course due to weather. Contributing to the accident was the reduced visibility at the time of the accident.NTSB NYC08CA279Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Tunica, MSThe pilot's failure to maintain clearance from the power lines during low-altitude maneuvers.