NTSB investigations: Air Tractor AT-502B, KS
7 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 per year
| 2014 | 1 |
|---|---|
| 2015 | 1 |
| 2016 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 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.\"eventStateOrRegion\" = 'KS' 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 ('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."eventStateOrRegion" = 'KS' 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 ('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 CEN25LA314Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Goodland, KSThe pilot’s failure to maintain aircraft control during the landing and go-around with variable wind direction and speed.NTSB CEN21LA362Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Topeka, KSThe pilot’s decision to continue low-level aerial application flight maneuvers after the low fuel warning light illuminated, which resulted in a partial loss of engine power due to fuel exhaustion.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 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 GAA16CA224Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Oberlin, KSThe pilot's failure to maintain directional control during the landing roll, which resulted in runway excursion, and a ground loop.NTSB CEN15LA226Accident · No injuriesLimited investigationFinal reportAir Tractor AT 502B · Dighton, KSThe pilot's failure to follow the Preflight checklist and his inadequate preflight inspection, during which he failed to detect the water contamination of the fuel, which resulted in a partial loss of engine power during initial climb.NTSB CEN14LA211Accident · 1 fatalLimited investigationFinal reportAir Tractor AT 502B · Garfield, KSThe pilot’s inadequate preflight planning and subsequent failure to remain clear of power lines while maneuvering low to the ground.