NTSB investigations: Air Tractor AT-301
291 cases on aircraft the registry lists as Air Tractor AT-301. 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 ('0390103', '0390105'))
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 ('0390103', '0390105'))
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 DEN93LA084Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Garner, ARTotal failure of one propeller blade. Factors were the continued operation of the engine during the forced landing, despite the pilot's efforts to shut it down, and the lack of suitable terrain for the forced landing.NTSB CHI93LA157Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT301A · Solomon, KSThe pilot's selection of unsuitable terrain on which to takeoff and his delay in aborting the takeoff.NTSB FTW93LA114Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Des Arc, ARThe pilot's loss of outside visual reference and loss of control.NTSB MIA92LA179Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Satartia, MSFailure of the brake system due to installation of a bogus part by an unknown person. Directional control by the pilot in command was not possible.NTSB CHI92DTG05Accident · Minor injuriesFinal reportAir Tractor AT-301 · Alice, NDComplete loss of engine power as a result of the partial failure of four pistons.NTSB FTW92DQG01Accident · Minor injuriesFinal reportAir Tractor AT-301 · Lubbock, TXThe pilot's selection of a downwind runway for takeoff. A factor was the tailwind.NTSB LAX92LA348Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Laveen, AZThe pilot's failure to maintain altitude during the low-level aerial application procedure turn. Contributing to this accident was the night condition and the high tension wires.NTSB MIA92LA160Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Redwood, MSImproper maintenance of the airplane by an unknown person.NTSB FTW92DPA01Accident · Serious injuriesFinal reportAir Tractor AT-301 · Dekalb, TXLoss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW92DPG09Accident · Serious injuriesFinal reportAir Tractor AT-301A · Fisher, ARA loss of engine power for undetermined reasons and the failure of the pilot to maintain airspeed above a stall.NTSB FTW92DPG05Accident · Minor injuriesFinal reportAir Tractor AT-301 · Cotton Plant, ARThe loss of engine power. A factor was the unsuitable terrain.NTSB DEN92LA062Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Rocky Ford, COThe pilots failure to maintain altitude due to spatial disorientation. Factors were: low overcast skies and ground fog.NTSB FTW92LA118Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Almyra, ARThe pilot's improper judgement of the descent rate and his inadequate pull up at the bottom.NTSB ATL91LA128Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Hawkinsville, GAA complete loss of engine power for undetermined reasons. A factor in this accident was: the rough, uneven terrain at the forced landing site.NTSB MIA91LA158Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · High Springs, FLLoss of engine power due to disintegration of the impeller caused by a worn impeller bearing.NTSB MIA91LA144Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Tutwiler, MSFatigue failure of one of the propeller blades resulting in the forced landing. Contributing to the accident was lack of suitable terrain.NTSB ATL91LA059Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Pavo, GAThe failure of the no. 2 exhaust valve and cylinder head, which resulted in a total loss of engine power. A factor in the accident was the collision with a road sign during the forced landing.NTSB FTW90DPG08Accident · Serious injuriesFinal reportAir Tractor AT-301 · Corning, ARBlockage of the carburetor Air intake by a collapsed Air induction hose due to improper maintenance by an unknown party.NTSB FTW90DPG04Accident · No injuriesFinal reportAir Tractor 301A · Foreman, ARThe pilot's inadvertent stall/mush.NTSB FTW90DRG04Accident · No injuriesFinal reportAir Tractor AT-301 · Mission, TXThe pilot's failure to maintain proper clearance above the crops he was spraying. A factor was the tree induced mechanical turbulence encountered during the descending turn.NTSB MKC90LA128Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Ulysses, KSFailure of the powerplant cylinder and stall/mush encountered by the pilot in command.NTSB MIA90LA083Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Rolling Fork, MSThe in-flight separation of the left aileron due to improper maintenance procedures and an inadequate aircraft preflight.NTSB MKC90LA030Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Ellinwood, KSThe partial failure of the engine for undetermined reasons which resulted in a forced landing. A factor related to the accident was the soft dirt.NTSB MIA90LA001Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Belle Glade, FLInadequate preflight by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. A factor related to the accident was: the terrain condition in the emergency landing area.NTSB LAX89DUG09Accident · No injuriesFinal reportAir Tractor AT-301A · Blythe, CAThe pilot's failure to verify the fuel supply prior to takeoff.NTSB LAX89DVA10Accident · No injuriesFinal reportAir Tractor AT-301 · Mendota, CAA loss of aircraft control by the pilot when he slowed the aircraft to begin a spray run. Contributing to the loss of control was the inoperative stall warning system.NTSB CHI89DEP10Accident · 1 fatalFinal reportAir Tractor AT-301 · Plainfield, WIFailure of the pilot-in-command to maintain control of the aircraft while conducting aerial application maneuvers in close proximity to the terrain.NTSB ATL89DKG04Accident · 1 fatalFinal reportAir Tractor AT-301 · Americus, GAThe pilot's failure to properly survey the area in which he would be conducting aerial application flights and his failure to see and avoid powerlines while performing aerial application.NTSB MKC89LA146Accident · No injuriesLimited investigationFinal reportAir Tractor 301 · Lonoke, ARPartial failure of the power-plant for undetermined reasons.NTSB FTW89DRG08Accident · No injuriesFinal reportAir Tractor AT-301 · Rio Hondo, TXImproper compensation for wind conditions by the pilot. Factors related to the accident were the adverse wind conditions.NTSB MIA89LA157Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Arcola, MSThe circumferential on the number 2 cylinder which resulted in a loss of engine power.NTSB SEA89LA071Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Grangeville, IDA partial power loss due to a blower failure. A factor related to the accident was the soft field condition.NTSB MKC89LA091Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Roseau, MNFuel starvation due to fuel ice.NTSB MIA89LA127Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Fort Pierce, FLFailure of the number five cylinder. Factors related to the accident were: the proximity of homes in the area, which precluded jettisoning of the chemical load, and high vegetation in the emergency landing area.NTSB FTW89DPJ03Accident · No injuriesFinal reportAir Tractor 301 · Jefferson, OKLoss of engine power, due to a cracked number 4 cylinder. A factor related to the accident was: the terrace (dirt bank) in the emergency landing area.NTSB FTW88DRD21Accident · No injuriesFinal reportAir Tractor AT301 · Ferriday, LAThe agricultural airplane was on a swath run when the engine malfunctioned. The pilot released the load of chemicals and made a forced landing in a bean field. There was very little damage to the beans but there was substantial damage to the airplane.…NTSB MIA88LA258Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301A · Shelby, MSWhile on an aerial application flt during the ground roll to takeoff, the forwardmost of two main gear clamp block bolts of the rt main landing gear failed. The gear trailed aft. The inboard main gear large bolt failed. The acft travelled off the rwy into a…NTSB MIA88LA246Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Glen Allen, MSAccording to FAA personnel while returning to land during an aerial application flt, the eng quit due to fuel exhaustion. The acft was damaged drg the forced landing.NTSB MKC88LA138Accident · No injuriesLimited investigationFinal reportCessna 172 · Lamar, MOThe plt of the aerial applicator acft said he was pulling out for an intersection departure on rwy 21, when the Cessna on a landing roll, struck him from the rear. The pilot said that possibly the background, haze, and airframe components made the incoming…NTSB LAX88DUM05Accident · No injuriesFinal reportAir Tractor AT-301 · Niland, CAJust after takeoff, the pilot made a right turn to locate the ground flaggers and to avoid transmission wires. The pilot, unable to locate the flaggers, initiated a climb to avoid wires and rising terrain. However, the airplane did not gain sufficient…NTSB MIA88LA229Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Moorhead, MSWhile on an aerial application flt during the ground roll the wind changed from a headwind to a tailwind. The plt dumped the load of chemical in an attempt to climb but the acft crashed into a fish pond.NTSB LAX88DVG07Accident · No injuriesFinal reportSnow AT-301 · Davis, CAAt the end of an aerial application flight, en route to home base, the engine quit. The pilot made an emergency landing in a field, where during the landing roll the airplane collided with a bale of hay and nosed over. Inspection of the engine revealed that…NTSB MIA88LA147Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Hastings, FLWhile on an aerial application flt shortly after takeoff, the eng lost power. The plt then dumped the load of fertilizer & landed the acft in a field. After touchdown it nosed over & came to rest. Examination of the eng revealed that the no. four cylinder…NTSB FTW88DRG05Accident · No injuriesFinal reportAir Tractor 301 · Circleville, TXThe airplane was being ferried to a new location, and an en route refueling stop was planned. A low ceiling and low visibility set in and the pilot tried to extend the flight to a different town. The fuel was exhausted 6 miles short of a town. The airplane…NTSB MIA88LA091Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-301 · Port Saint Joe, FLWhile on a business flt, unable to locate the landing site with darkness approaching & low supply of fuel, the plt performed a precautionary landing on a soft dirt road. During the landing roll the acft nosed over & came to rest. The plt did not file an acc…NTSB FTW87DPJ08Accident · 1 fatalFinal reportAir Tractor 301A · Hollis, OKDuring an aerial application cleanup run, the aircraft's wing collided with a pole and sheared off the outboard five feet. The aircraft then collided with the ground out of control. Exam of the engine and airframe did not disclose any pre-existing failures or…NTSB MIA87LA244Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Belle Glade, FLThe plt stated that he was spraying water to clean out his hopper tank. During approach to land the eng quit. Unable to reach the airstrip the plt landed on a road. On landing rollout on the road he struck a hidden 55 gallon drum with the right wing tip, spun…NTSB MKC87DPG03Accident · Serious injuriesFinal reportAir Tractor AT-301 · Tillar, ARThe pilot stated that the prop RPM became erratic. On approach, the prop ran completely out of control, causing the aircraft to nose down into a plowed field just short of the landing area. The a/c hit on the main landing gear, broke them off, then it nosed…NTSB FTW87DRG04Accident · Minor injuriesFinal reportAir Tractor AT301 · Santa Rosa, TXThe pilot was dusting a sugar cane field which bordered a dirt road with parallel electrical transmission lines. The pilot had been terminating his swath runs by flying underneath the electrical wires at the edge of the field. To prevent becoming a hazard to…NTSB MIA87LA209Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Swiftown, MSWhile spraying cotton, severe vibration was felt throughout the acft & the plt elected a forced ldg. During the flare, the throttle was advanced to raise the nose, & the plt discovered the eng had totally failed. The acft flipped inverted on touch down. An…