NTSB investigations: Air Tractor AT-502B, CA
8 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
| 2004 | 1 |
|---|---|
| 2007 | 1 |
| 2014 | 2 |
| 2016 | 2 |
| 2023 | 1 |
| 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.\"eventStateOrRegion\" = 'CA' 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" = 'CA' 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 WPR25LA011Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT502 · Corcoran, CAA total loss of engine power due to the pilot's improper manipulation of the condition lever during flight, which resulted in fuel starvation and a forced landing.NTSB WPR23LA217Accident · Minor injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Bakersfield, CAThe pilot’s improper use of flaps during the takeoff sequence which resulted in a runway overrun and collision with trees.NTSB WPR16FA148Accident · 1 fatalField investigationFinal reportAir Tractor AT 502B · Zamora, CAThe failure of both pilots to maintain an adequate visual lookout, which resulted in a midair collision. Also causal was the other pilot's use of two sedating antihistamines and two impairing medication and the effect of sun glare on his visual lookout, which…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 WPR14LA267Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT 502B · Sacramento, CAThe total loss of engine power for reasons that could not be determined because the airplane was not available for postaccident examination.NTSB WPR14LA245Accident · No injuriesLimited investigationFinal reportAir Tractor AT 502B · Princeton, CAThe partial loss of engine power during takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB SEA07LA242Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Blythe, CAThe pilot's failure to maintain adequate airspeed which resulted in a stall. A contributing factor was the high density altitude.NTSB LAX04LA275Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Mendota, CAThe pilot's inadequate preflight/pretakeoff procedure by not lowering the wing flaps, which resulted in an inadvertent stall as the pilot attempted to climb out of ground effect to clear a corn crop at the end of the runway. A factor in the accident was the…