Skip to content

NTSB investigations: Air Tractor AT-301, AR

22 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19802026

Where

Latest cases

Query with SQL

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" = 'AR' 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 ('0390103', '0390105')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 'AR' 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 ('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."eventStateOrRegion" = 'AR' 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 ('0390103', '0390105'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 CEN10CA582Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Atkins, ARA partial loss of engine power during low-altitude flight for undetermined reasons.Sep 17, 2010 · N2309F · Substantial damage NTSB CEN09LA239Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Corning, ARA loss of engine power due to the failure of the number one engine cylinder for undetermined reasons.Apr 7, 2009 · N36597 · Substantial damage NTSB FTW04LA150Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Cotton Plant, ARThe loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.Jun 4, 2004 · N3166U · Substantial damage NTSB FTW00LA130Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Gould, ARThe stall/mush encountered by the pilot. A factor was the crosswind.Apr 21, 2000 · N8699S · Substantial damage NTSB FTW96LA258Accident · Serious injuriesLimited investigationFinal reportAir Tractor 301A · Hunter, ARThe loss of engine power for undetermined reasons.Jun 18, 1996 · N7319C · Destroyed NTSB FTW96LA219Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Griffithville, ARloss of engine oil (leak) for an undetermined reason, which resulted in oil starvation and a loss of engine power; and failure of the pilot to maintain airspeed during the emergency descent/landing phase, which resulted in an inadvertent stall and subsequent…May 18, 1996 · N4424S · Destroyed NTSB FTW95LA213Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Caldwell, ARThe loss of power due to a crack in the #4 cylinder. Factors were the lack of suitable terrain for the forced landing and proper touchdown point not possible.May 19, 1995 · N3655Z · Substantial damage NTSB FTW94FA258Accident · 1 fatalField investigationFinal reportAir Tractor AT-301 · Hunter, ARInadvertent stall due to pilot's failure to maintain airspeed. A factor was the pilot's over confidence in his personal ability.Aug 1, 1994 · N23358 · Substantial damage 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.Jul 22, 1993 · N3650U · Substantial damage NTSB FTW93LA114Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Des Arc, ARThe pilot's loss of outside visual reference and loss of control.Mar 30, 1993 · N4437S · Destroyed 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.Jul 15, 1992 · N3652B · Substantial damage NTSB FTW92DPG05Accident · Minor injuriesFinal reportAir Tractor AT-301 · Cotton Plant, ARThe loss of engine power. A factor was the unsuitable terrain.Jul 7, 1992 · N3650N · Substantial damage 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.Apr 22, 1992 · N4430S · Substantial damage 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.Aug 14, 1990 · N4433S · Substantial damage NTSB FTW90DPG04Accident · No injuriesFinal reportAir Tractor 301A · Foreman, ARThe pilot's inadvertent stall/mush.Jul 30, 1990 · N31631 · Destroyed NTSB MKC89LA146Accident · No injuriesLimited investigationFinal reportAir Tractor 301 · Lonoke, ARPartial failure of the power-plant for undetermined reasons.Jun 28, 1989 · N3653M · Substantial damage 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…Aug 27, 1987 · N3159X · Substantial damage NTSB MKC86LA138Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Lake City, ARThe acft dptd the rwy normally to fertilize a nearby fld. The PIC stated that the acft lost pwr shortly into the climb and he had to make a forced lndg off airport. The PIC was unable to dump the load of fertilizer aboard before impact in a rice field. The…Jul 2, 1986 · N78MH · Substantial damage NTSB MKC85LA125Accident · No injuriesLimited investigationFinal reportSnow AT301 · Marianna, ARAfter departing the ag strip the plt rptd a vibrating engine which shook violently until finally quitting. The plt responded with an emergency landing attempt to a plowed bean field. The acft impacted the soft terrain at a high rate of speed where the acft…Jun 8, 1985 · N5078S · Substantial damage NTSB FTW82DA336Accident · No injuriesFinal reportSnow AT-301A · Leachville, ARThe pilot stated that while he was in the procedure turnaround for the third swath run. He lost elevator control. The aircraft impacted the ground and cartwheeled. Investigation revealed that the bolt connecting the elevator horn assembly and the elevator…Aug 17, 1982 · N2321V · Destroyed NTSB FTW81DPG70Accident · No injuriesClosedAir Tractor AT-301 · Lonoke, ARSep 30, 1981 · N8593S · Substantial damage NTSB FTW80DPG46Accident · No injuriesClosedAir Tractor AT-301 · Palestine, ARJul 14, 1980 · N4364S · Substantial damage