NTSB investigations: Air Tractor AT-401
88 cases on aircraft the registry lists as Air Tractor AT-401. 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, newest first
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 ('0390204', '0390209'))
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 ('0390204', '0390209'))
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 SEA98LA080Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Idaho Falls, IDThe pilot's failure to maintain clearance from a power transmission line during an aerial application flight. Factors include a power line located just beyond the boundary of the field being sprayed, and the pilot's incorrect judgement of the distance between…NTSB CHI98LA118Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Highmore, SDthe pilot failed to abort the takeoff in a timely manner and could not stop on the runway.NTSB CHI98LA108Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Steele, MOthe pilot failed to maintain an adequate visual lookout. A factor was the pile of gravel in the taxiway.NTSB MIA97LA208Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Altha, FLthe pilot's impairment of judgment and performance due to alcohol which led to his failure to maintain control of the airplane.NTSB CHI97LA106Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Highmore, SDa premature lift-off of the airplane by the pilot in command.NTSB LAX97LA045Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Calexico, CAthe pilot's premature lift-off from the runway and his failure to attain adequate airspeed.NTSB FTW96LA374Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Brownfield, TXThe pilot's failure to maintain directional control during landing roll. A factor was the crosswind.NTSB FTW96LA370Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Plains, TXfailure of the pilot to maintain control of the airplane, while maneuvering after a swath run, which subsequently resulted in a collision with the terrain. A factor relating to the accident was: the adverse wind condition (gusty wind and possible windshear).NTSB FTW96LA251Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Cash, ARThe partial loss of engine power due to fuel contamination. A factor was the lack of suitable terrain available for the forced landing.NTSB FTW96FA228Accident · 1 fatalField investigationFinal reportAir Tractor AT-401 · Lake Providence, LAfailure of the pilot to maintain sufficient airspeed, while maneuvering (turning), which resulted in an inadvertent stall and collision with the terrain. The high gusty wind condition was a related factor.NTSB CHI96LA167Accident · No injuriesLimited investigationFinal reportAir Tractor AT401 · Letcher, SDthe pilot's inadequate evaluation of the severe weather condition. A factor was the weather conditions.NTSB FTW95LA358Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Taft, TXThe pilot's diverted attention, which resulted in his failure to assure that clearance was maintained from the transmission line.NTSB CHI95LA258Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Aurora, NEthe cracked engine assembly that caused the power loss during a critical phase of flight. Factors associated with this accident were the restricted airplane performance due to the power loss, the airplane's altitude was too low, and remedial action, by, the…NTSB FTW95LA301Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Cash, AREngine power loss due to partial failure of one magneto combined with total failure of the other magneto. A factor was the lack of suitable terrain for a forced landing.NTSB MIA95LA180Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Clewiston, FLImproper weather evaluation by the pilot in command while attempting to takeoff with a quartering tailwind associated with a nearby thunderstorm and failure of the pilot to maintain directional control.NTSB FTW95LA256Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Hearne, TXThe loss of engine power as result of the failure of the number two cylinder. Factors were the unsuitable terrain available for the forced landing and the pilot's restricted vision due to oil on the windshield.NTSB FTW95LA241Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Denver City, TXThe loss of engine power due to a fracture of the #3 cylinder resulting in the total failure of the cylinder. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94LA306Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Mcgehee, ARThe loss of engine power due to undetermined reasons. A factor was the unsuitable terrain.NTSB FTW94LA256Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Mcgehee, ARTotal loss of engine power as the engine seized due to a blower bearing failure. A factor was the lack of suitable terrain for the forced landing.NTSB MIA94LA168Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Walls, MSThe partial loss of engine power for undetermined reasons. The sandy terrain was a factor.NTSB FTW94LA200Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Pioneer, LAFuel exhaustion due to the pilot's failure to refuel. A factor was a lack of suitable terrain for the forced landing.NTSB DEN93LA081Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Dermott, ARPower loss due to the total failure of the engine's master rod. Factors were an improper engine overhaul and the lack of suitable terrain for a forced landing.NTSB CHI93LA170Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Oconto, NEThe pilot's inability to maintain altitude after encountering a downdraft.NTSB MIA93LA104Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Fort Pierce, FLFailure of the no. 2 cylinder in fatigue for undetermined reasons, over unsuitable terrain. The lack of suitale terrain for the forced landing was a factor.NTSB LAX92LA338Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Parker, AZThe inadequate overhaul of the propeller blade by the overhaul facility. Contributing to this accident was the rough and uneven terrain.NTSB FTW92LA131Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Taft, TXThe pilot of the other airplane delayed compensation for turbulence. A factor was the turbulence.NTSB MIA91LA219Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Sumner, MSFailure of the no. 1 cylinder assembly.NTSB LAX91LA302Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Calexico, CAThe erection of a construction sign on an active runway by county workers without notifying the airport operators, and, the inability of the pilot to detect the presence of the sign during the dark night takeoff.NTSB MIA91LA101Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-401 · Avon, MSLoss of engine power for undetermined reasons during a turn while on an aerial application flight. Contributing to the accident was failure of the left magneto due to failure of a phenolic gear which drives the rotating magnet.NTSB MIA91LA033Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT401 · Belle Glade, FLThe pilot failed to maintain airspeed, and stalled the airplane, resulting in a uncontrolled descent, and collision with the terrain.NTSB FTW90DPG12Accident · No injuriesFinal reportAir Tractor AT-401 · Jacksonville, ARA loss of engine power due to unknown causes. A factor was the unsuitable terrain.NTSB FTW90DPG11Accident · No injuriesFinal reportAir Tractor AT401 · Altheimer, ARThe pilot's failure to align the airplane with the runway during landing.NTSB LAX90DXQ03Accident · Minor injuriesFinal reportAir Tractor AT-401 · Tule Lake, CAAn engine failure due to mechanical failure of the distributor.NTSB LAX90DVA07Accident · 1 fatalFinal reportAir Tractor AT-401 · San Joaquin, CAThe failure of the no. 4 cylinder head.NTSB SEA90LA105Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Jerome, IDThe pilot did not maintain a proper altitude while maneuvering to reverse direction.NTSB MKC90LA081Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Hornersville, MOFailure of an engine cylinder.NTSB MKC89LA190Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Wabbaseka, ARImproper planning/decision by the pilot which resulted in his failure to maintain clearance from the tall vegetation (grass). The tall vegetation & high density altitude were considered to be contributing factors.NTSB MIA89FA164Accident · Serious injuriesField investigationFinal reportAir Tractor AT-401 · Clarksdale, MSThe pilot failed to maintain airspeed resulting in the airplane stalling and descending out of control.