Skip to content

NTSB investigations: Air Tractor AT-301, FL

10 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

19872026

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" = 'FL' 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\" = 'FL' 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" = 'FL' 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 ERA12CA050Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · McAlpin, FLThe pilot's misjudgment of the airplane's distance from known transmission lines.Oct 24, 2011 · N3169C · Substantial damage NTSB ATL97LA127Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Clewiston, FLThe crack in the #8 cylinder head which led to the loss of power. A factor was the soft terrain.Aug 29, 1997 · N7307C · Substantial damage NTSB ATL97LA087Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301A · Labelle, FLfailure of the pilot to maintain adequate airspeed during a turn-around maneuver, which resulted in an aerodynamic stall/mush and collision with the terrain.Jun 20, 1997 · N23728 · Substantial damage NTSB MIA95LA227Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301A · Vero Beach, FLFailure of company maintenance personnel to comply with a required airworthiness directive, resulting in an in-flight fire and emergency landing. Contributing to the accident was the lack of suitable terrain for the forced landing.Sep 21, 1995 · N7304C · Destroyed 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.Jun 2, 1991 · N8841S · Substantial damage 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.Oct 2, 1989 · N8842S · Substantial damage 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.Apr 13, 1989 · N3159D · Substantial damage 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…Apr 14, 1988 · N8841S · Substantial damage 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…Jan 20, 1988 · N36534 · Substantial damage 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…Sep 11, 1987 · N23600 · Substantial damage