NTSB investigations: Air Tractor AT-502B

140 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, 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 ('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.

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.Oct 27, 2016 · N8525G · Substantial damageNTSB 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.Oct 18, 2016 · N4218E · Substantial damageNTSB 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.Aug 8, 2016 · N634LA · Substantial damageNTSB 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…Jul 23, 2016 · N502WC · 2 aircraft · Substantial damageNTSB 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.Jun 1, 2016 · N5091N · Substantial damageNTSB 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.May 8, 2016 · N6181Q · Substantial damageNTSB CEN15LA389Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT 502B · Monroe, NELoss of propeller thrust for reasons that could not be determined, since examination of the airplane's engine, propeller, and associated accessories revealed no anomalies.Aug 27, 2015 · N61267 · Substantial damageNTSB CEN15LA335Accident · No injuriesLimited investigationFinal reportAir Tractor AT 502B · Virden, ILThe pilot’s failure to establish a proper airspeed during takeoff with the airplane near its maximum gross weight and with a quartering tailwind.Aug 1, 2015 · N502LH · Substantial damageNTSB GAA15CA152Accident · No injuriesData collectionFinal reportAir Tractor AT 502B · Edna, TXThe pilot's failure to maintain directional control during the takeoff roll, resulting in a runway excursion, and collision with a fence.Jun 24, 2015 · N6107W · Substantial damageNTSB 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.May 31, 2015 · N120TF · Substantial damageNTSB 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.May 10, 2015 · N879JA · Substantial damageNTSB 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.May 5, 2015 · N4221G · DestroyedNTSB WPR15LA048Accident · 1 fatalLimited investigationFinal reportAir Tractor AT 502B · Somerton, AZA loss of airplane control for reasons that could not be determined based on available evidence.Nov 30, 2014 · N946TR · DestroyedNTSB CEN14CA464Accident · No injuriesData collectionFinal reportAir Tractor AT 502B · Colusa, ILThe pilot did not maintain control of the airplane during takeoff from a grass strip. Contributing was the airplane being loaded beyond its capability for the runway.Aug 27, 2014 · N369AB · Substantial damageNTSB CEN14CA429Accident · No injuriesData collectionFinal reportAir Tractor AT 502B · Minden, NEThe pilot's inadequate survey of the aerial application field which resulted in a collision with a windmill.Jul 29, 2014 · N502NR · Substantial damageNTSB 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.Jun 23, 2014 · N61150 · Substantial damageNTSB 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.Jun 13, 2014 · N502JS · Substantial damageNTSB 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.Apr 22, 2014 · N51990 · Substantial damageNTSB CEN13LA473Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Nauvoo, ILA fatigue failure of an engine compressor turbine blade, which resulted in extensive secondary engine damage and a complete loss of engine power.Jul 15, 2013 · N6113C · Substantial damageNTSB CEN13LA402Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Tillar, ARThe loss of engine throttle control during takeoff due to an unsecured cockpit throttle control pin, which resulted in a runway overrun.Jul 3, 2013 · N5182C · Substantial damageNTSB CEN13LA371Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Campbell, NEThe pilot's decision to continue with the takeoff roll despite the airplane's difficulty becoming airborne The high-density altitude likely contributed to the airplane's reduced performance.Jun 23, 2013 · N6017E · Substantial damageNTSB ERA13CA033Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Newton, GAThe pilot’s failure to maintain clearance from power lines while maneuvering, which resulted in a hard forced landing.Oct 20, 2012 · N502PB · Substantial damageNTSB CEN13CA019Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Portales, NMThe pilot’s failure to maintain clearance from power lines during an aerial application flight.Oct 17, 2012 · N598LA · Substantial damageNTSB CEN12CA568Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Bogata, TXThe pilot’s inadequate preflight planning, which resulted in the airplane’s loading beyond its maximum gross weight.Aug 17, 2012 · N6047G · Substantial damageNTSB CEN12LA500Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Newellton, LAThe pilot's inadequate takeoff planning and his use of an improper flap setting, which resulted in a runway excursion and collision with terrain during takeoff.Aug 1, 2012 · N5128U · Substantial damageNTSB CEN12LA459Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502B · Wisner, LAThe pilot’s inadequate takeoff planning that did not consider the reduced acceleration due to a rough, turf runway and his use of an improper flap setting, which resulted in a collision with terrain during takeoff.Jul 18, 2012 · N205SK · Substantial damageNTSB CEN12CA301Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · El Campo, TXThe pilot's decision to rotate early, the airplane’s subsequent inability to climb, and the pilot’s delayed decision to abort the takeoff.May 7, 2012 · N5016P · Substantial damageNTSB ERA12CA216Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Hollandale, MSThe pilot's failure to maintain directional control while taxiing in gusty wind conditions.Mar 7, 2012 · N9148C · Substantial damageNTSB ERA12CA003Accident · Serious injuriesData collectionFinal reportAir Tractor AT-502B · Fort Pierce, FLThe pilot's delayed decision to abort the takeoff.Oct 4, 2011 · N90805 · Substantial damageNTSB CEN11WA382Accident · 1 fatalForeign investigationAir Tractor AT-502B · La Fora, Tiquisate, GuatemalaJun 11, 2011 · N502BB · Substantial damageNTSB WPR11CA252Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Odessa, WAThe pilot's failure to maintain clearance from the other aircraft.Jun 7, 2011 · N6072X · 2 aircraft · Minor damageNTSB CEN11LA296Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-802A · New Madrid, MOThe failure of both pilots to see and avoid the other airplane, which resulted in a midair collision.Apr 19, 2011 · N802KC · 2 aircraft · Substantial damageNTSB CEN10CA445Accident · Minor injuriesData collectionFinal reportAir Tractor AT-502B · Zwingle, IAThe pilot's failure to maintain clearance from wires during the agricultural flight.Jul 28, 2010 · N6030U · Substantial damageNTSB CEN10LA298Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Pollard, ARA loss of engine power for undetermined reasons.Jun 4, 2010 · N6083G · Substantial damageNTSB CEN09CA533Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Whittemore, IAThe pilot's lack of preflight planning and remedial action with resulted in the airplane's inability to climb out of ground effect.Aug 17, 2009 · N5003C · Substantial damageNTSB ERA09LA431Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT502 · Minter City, MSThe pilot’s failure to maintain airspeed while maneuvering at a low altitude, resulting in an aerodynamic stall.Jul 31, 2009 · N60237 · Substantial damageNTSB CEN09CA428Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Reydell, ARThe pilot's inability to maintain control of the airplane when it unexpectedly encountered a whirlwind shortly after takeoff.Jul 10, 2009 · N60023 · Substantial damageNTSB 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.Mar 6, 2009 · N648LA · Substantial damageNTSB NYC08CA279Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Tunica, MSThe pilot's failure to maintain clearance from the power lines during low-altitude maneuvers.Aug 13, 2008 · N61267 · Substantial damageNTSB DFW08LA167Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Bethany, MOThe pilot's decision to take off with a known deficiency.Jun 24, 2008 · N5005G · Substantial damageNTSB DFW08LA143Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502B · Wheatley, ARThe pilot's failure to maintain airspeed, resulting in an inadvertent low-altitude aerodynamic stall.May 15, 2008 · N6112D · Substantial damageNTSB SEA07CA244Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Salome, AZThe pilot's inadequate compensation for the tailwind condition and failure to maintain directional control during the takeoff roll/run, which resulted in a ground loop.Aug 30, 2007 · N8521Z · Substantial damageNTSB 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.Aug 29, 2007 · N6003G · Substantial damageNTSB CHI07CA268Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Cooksville, ILThe partial loss of engine power during the takeoff roll for undetermined reasons and the pilot's unsuccessful compensation for the tailwind conditions. Factors contributing to the accident were the tailwind and the corn crop.Aug 12, 2007 · N61352 · Substantial damageNTSB CHI07LA246Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Hampton, IAThe pilot's failure to maintain directional control during landing. Contributing to the accident was a ditch.Aug 1, 2007 · N50877 · Substantial damageNTSB DFW07CA123Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Banquete, TXThe pilot's failure to maintain clearance from the power transmission line(s). A contributing factor was the low altitude selected by the pilot.May 29, 2007 · N502DB · Substantial damageNTSB ATL07CA051Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Collinwood, TNThe pilots improper inflight planning which resulted in a loss of engine power due to fuel exhaustion.Mar 15, 2007 · N90319 · Substantial damageNTSB DFW06CA182Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Marvell, ARThe pilot's failure to maintain clearance with terrain during takeoff.Jul 12, 2006 · N90614 · Substantial damageNTSB DFW06CA031Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Osceola, ARThe pilot's failure to maintain control of the airplane while on final approach. A contributing factor was the gusty winds.Nov 10, 2005 · N5075P · Substantial damageNTSB DFW05CA191Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Gassoway, LAThe pilot's premature lift-off which resulted in an inadequate climb for terrain clearance. Also causal was the pilot's failure to abort the takeoff. A contributing factor was the high density altitude.Jul 23, 2005 · N50075 · Substantial damage