Skip to content

NTSB investigations: Air Tractor AT-301, MS

20 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

19792026

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" = 'MS' 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\" = 'MS' 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" = 'MS' 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 MIA08CA078Accident · Minor injuriesData collectionFinal reportAir Tractor AT-301 · Columbus, MSThe failure of the pilot to maintain airspeed while maneuvering.Mar 14, 2008 · N7302C · Substantial damage NTSB MIA99LA203Accident · No injuriesLimited investigationFinal reportAir Tractor 301 · Drew, MSa loss of engine power due to the failure of cylinder No. 4 boss, which was caused by fatigue cracking, resulting in a forced landing in marshy terrain and subsequent nose over.Jul 23, 1999 · N2368R · Substantial damage NTSB MIA93LA179Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Rome, MSLoss of engine power for an undetermined reason. A factor related to the accident was: failure of the pilot to use all available runway for takeoff.Aug 20, 1993 · N3655G · Substantial damage 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.Sep 10, 1992 · N4333S · Substantial damage NTSB MIA92LA160Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Redwood, MSImproper maintenance of the airplane by an unknown person.Aug 7, 1992 · N3165A · Substantial damage 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.May 13, 1991 · N8563S · Substantial damage 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.Mar 6, 1990 · N23509 · Substantial damage 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.May 26, 1989 · N73089 · Substantial damage 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…Aug 19, 1988 · N73089 · Substantial damage 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.Aug 4, 1988 · N3659G · Substantial damage 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.Jul 18, 1988 · N23640 · Substantial damage 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…Jul 18, 1987 · N7310N · Substantial damage NTSB MIA87LA208Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT301 · Rolling Fork, MSDuring the swath run, the plt stated that the eng 'barked' once or twice just prior to impact with the trees. The acft hit the trees, rolled inverted & burst into flames. He stated that the seat belt & shoulder harness saved his life. The plt stated that he…Jul 17, 1987 · N2321V · Destroyed NTSB MIA87LA142Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Dundee, MSThe plt stated that when reversing direction after an aerial application maneuver the eng quit. He then landed the acft in a creek due to insufficient altitude to clear trees that were in the flight path. Upon touchdown the acft nosed over and came to rest…Apr 22, 1987 · N3652B · Substantial damage NTSB MIA86LA183Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Vaiden, MSThe plt stated that upon landing in a cow pasture he lost directional control of the acft. The acft collided with a vehicle located at the FAR end and off to one side of the pasture. The acft then traveled through a fence and a ditch before coming to rest…Jun 14, 1986 · N23930 · Substantial damage NTSB ATL83FKQ03Accident · No injuriesFinal reportAir Tractor AT-301 · Redwood, MSThe acft made a forced landing in a soybean field after severe vibration developed during a spraying operation. The pilot stated that the powerplant and flt controls were functioning normally at the time of the accident. An on-scene investigation revealed…Aug 25, 1983 · N8511S · Substantial damage NTSB ATL81FKQ23Accident · No injuriesClosedAir Tractor AT-301 · Charleston, MSJul 31, 1981 · N4364S · Substantial damage NTSB ATL81FLT04Accident · Minor injuriesClosedAir Tractor AT-301 · Crenshaw, MSFeb 26, 1981 · N4433S · Substantial damage NTSB ATL81FKQ02Accident · No injuriesClosedAir Tractor AT-301 · Canton, MSOct 21, 1980 · N78MH · Substantial damage NTSB MIA79FKQ28Accident · Minor injuriesClosedAir Tractor AT-301 · Grenada, MSSep 4, 1979 · N8595S · Substantial damage