NTSB investigations: Air Tractor AT-802
13 cases on aircraft the registry lists as Air Tractor AT-802. 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
| 2001 | 1 |
|---|---|
| 2004 | 1 |
| 2013 | 1 |
| 2016 | 2 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 3 |
| 2024 | 3 |
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 ('0390305'))
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 ('0390305'))
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 ERA24LA375Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-802 · Hickory Valley, TNA partial loss of engine power due to a leak in the fuel control unit bellows, which resulted in the fuel valve moving to minimum fuel flow.NTSB CEN24LA255Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-802 · Brad, TXThe pilot’s failure to maintain airplane control after encountering a large boat wake.NTSB WPR24FA201Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-802 · Arco, IDA midair collision between two airplanes during aerial application operations due to both pilots’ insufficient awareness of their proximity to each other and their failure to see and avoid each other. Contributing to the accident was the operator and both…NTSB CEN23LA425Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-802 · Herington, KSThe design of the spray valve control lever, which restricted the range of the left rear rudder and brake pedal and resulted in a loss of control during landing.NTSB CEN23FA353Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-802 · Gilman City, MOThe pilot's exceedance of the airplane's critical angle of attack and failure to maintain adequate airspeed during a steep turn, which resulted in an aerodynamic stall at an altitude too low for recovery.NTSB CEN23LA311Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-802 · Benson, MNThe pilot’s failure to adequately survey a field for obstructions prior to a low-level aerial application pass, which resulted in an impact with a powerline. Contributing to the accident was the degraded visibility due to the smoke in the area.NTSB ERA22FA338Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-802A · Portland, ARThe failure of both pilots to see and avoid the other airplane during aerial application and ferry operations.NTSB CEN21FA334Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-802 · Benoit, MSThe pilot’s exceedance of the airplane’s takeoff performance capabilities and his failure to abort the takeoff in a timely manner. Contributing to the accident was the pilot’s impairment due to his use of ethanol and prohibited medications.NTSB ERA16WA341Accident · No injuriesForeign investigationAir Tractor AT602 · Sao Jose do Rio Preto, BrazilOn September 21, 2016, about 1415 coordinated universal time, an Air Tractor AT-602, N1001R, was substantially damaged during a forced landing to a sugar plantation, following a total loss of engine power during descent near Sao Jose do Rio Preto, Brazil. The…NTSB ANC16LA029Accident · No injuriesLimited investigationFinal reportAir Tractor AT 802 · Fairbanks, AKThe pilot's inadequate preflight fuel planning, his reliance on the fuel flow indicator without verifying the initial fuel level input, and his improper decision to continue the flight with the low fuel light illuminated, which resulted in fuel exhaustion,…NTSB CEN13LA568Accident · No injuriesLimited investigationFinal reportAir Tractor AT 802 · Gould, ARThe failure of a bearing in the fuel control unit, which resulted in fuel starvation and a total loss of engine power.NTSB MIA04WA051Accident · No injuriesForeign investigationAir Tractor AT-802 · Los Angeles, ChileNTSB LAX01LA114Accident · No injuriesLimited investigationFinal reportAir Tractor AT-802 A · Maricopa, AZInadequate selection of landing facilities and improper placement of vehicles near the runway. An additional factor was the use of a runway which resulted in a downwind landing.