Skip to content

NTSB investigations: Air Tractor AT-602, AR

20 cases on aircraft the registry lists as Air Tractor AT-602. 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

20042026

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 ('0390309')) 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 ('0390309'))
  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 ('0390309'))
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 CEN22LA287Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Newport, ARThe pilot’s failure to maintain clearance from obstructed terrain during takeoff.Jun 20, 2022 · N42022 · Substantial damage NTSB CEN22LA228Accident · Minor injuriesClass 3 · LimitedFinal reportAir Tractor AT-602 · Allport, ARA partial loss of engine power due to fuel contamination from foreign object debris. Contributing to the accident was the operator’s failure to follow the manufacturer’s required airframe fuel filter inspection interval.Jun 1, 2022 · N5007R · Substantial damage NTSB CEN21LA240Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT602 · Trumann, ARThe pilot’s failure to review the weather conditions before the flight, which resulted in a loss of directional control during takeoff due to a sudden change in wind direction and speed associated with an approaching thunderstorm.May 27, 2021 · N602NY · Substantial damage NTSB CEN21LA161Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-602 · Dumas, ARThe failure of both pilots to see and avoid the other airplane.Mar 15, 2021 · N119KP · 2 aircraft · Substantial damage NTSB CEN20LA287Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT 602 · Des Arc, ARA total loss of engine power for reasons that could not be determined from all available evidence.Jul 3, 2020 · N8506E · Substantial damage NTSB CEN20LA269Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT 602 · Weldon, ARThe total loss of engine power during cruise flight for reasons that could not be determined based on the available evidence.Jul 3, 2020 · N602NY · Substantial damage NTSB CEN20LA109Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT 602 · Dumas, ARThe pilot’s failure to maintain clearance from a power line pole during a low-level aerial application flight, which resulted in impact with the bracket and a subsequent forced landing.Feb 25, 2020 · N5197Y · Substantial damage NTSB CEN18FA263Accident · 1 fatalField investigationFinal reportAir Tractor AT-602 · Wheatley, ARThe pilot's failure to maintain clearance from terrain for reasons that could not be determined based on the available evidence.Jul 11, 2018 · N8508P · Destroyed NTSB CEN17FA259Accident · 1 fatalField investigationFinal reportAir Tractor AT 602 · Cash, ARThe pilot's incapacitation due to a cardiac event, which resulted in a loss of airplane control.Jul 8, 2017 · N4257R · Destroyed NTSB CEN15LA384Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT 602 · Pine Bluff, ARThe pilot’s failure to maintain clearance from terrain during an aerial application flight.Aug 26, 2015 · N3026R · Substantial damage NTSB CEN15FA331Accident · 1 fatalField investigationFinal reportAir Tractor AT 602 · Wilmot, ARThe pilot's inability to maintain control of the airplane as a result of incapacitation by drug effects or an acute cardiac event.Aug 1, 2015 · N6007N · Substantial damage NTSB CEN12LA310Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Humnoke, ARThe pilot’s failure to attain the proper touchdown point, which resulted in a landing undershoot.May 19, 2012 · N85239 · Substantial damage NTSB CEN11CA098Accident · No injuriesData collectionFinal reportAir Tractor AT-602 · Gregory, ARThe pilot’s inadequate preflight inspection and failure to detect water contaminated fuel, which resulted in a loss of engine power during takeoff.Dec 2, 2010 · N9145H · Substantial damage NTSB CEN10CA391Accident · No injuriesData collectionFinal reportAir Tractor AT602 · Lake Village, ARThe pilot's failure to maintain clearance from the wires during the aerial application pass.Jul 11, 2010 · N42590 · Substantial damage NTSB CEN10LA353Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-602 · Penrose, ARThe loss of partial engine power due to a fatigue crack in the engine's fuel control bellows.Jun 14, 2010 · N4257R · Substantial damage NTSB CEN10FA310Accident · 1 fatalField investigationFinal reportAir Tractor AT602 · Knobel, ARThe pilot did not maintain control of the airplane while maneuvering at low altitude.Jun 7, 2010 · N4184P · Substantial damage NTSB CEN09LA401Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Knobel, ARThe failure of the P-3 tube resulting in the loss of engine power.Jun 30, 2009 · N5192T · Substantial damage NTSB DFW08CA104Accident · Serious injuriesData collectionFinal reportAir Tractor AT-602 · Paragould, ARThe pilot's failure to maintain clearance from electrical wires while maneuvering. Contributing to the accident were binding of the elevator control, inadvertent stall and trees.Apr 20, 2008 · N8517M · Substantial damage NTSB DFW08CA084Accident · No injuriesData collectionFinal reportAir Tractor AT602 · Back Gate, ARThe pilot's failure to maintain directional control of the aircraft. A contributing factor was the wet, grass runway.Mar 13, 2008 · N602KP · Substantial damage NTSB FTW04LA136Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Brookland, ARThe pilot's failure to maintain clearance with the power lines while maneuvering.May 21, 2004 · N5013C · Substantial damage