NTSB investigations: Air Tractor AT-301, OK

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

19782026

NTSB investigations: Air Tractor AT-301, OK per year, 1978–2026: 10 cases
1978	1
1982	1
1986	2
1987	4
1989	1
2002	1

Where

Open the map

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" = 'OK' 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\" = 'OK' 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" = 'OK' 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 FTW02LA256Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Altus, OKthe pilot's failure to maintain clearance with electrical wires while maneuvering during an aerial application flight.Sep 14, 2002 · N23736 · Substantial damage 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.Apr 7, 1989 · N4369S · Substantial damage 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…Sep 13, 1987 · N3651D · Destroyed NTSB FTW87DPJ06Accident · No injuriesFinal reportAir Tractor AT301 · El Dorado, OKThe pilot stated that during takeoff from a county road, black smoke started coming out of the engine exhaust. The aircraft then collided with a tree and a post causing substantial damage. It was found that the carburetor heat system had been modified and the…Mar 22, 1987 · N3655G · Substantial damage NTSB FTW87DPJ04Accident · No injuriesFinal reportAir Tractor 301 · Oluskee, OKDuring aerial application the engine sustained a power loss due to separation of the number 9 cylinder head. During the forced landing in rough terrain the aircraft was substantially damaged.Mar 14, 1987 · N8865S · Substantial damage NTSB FTW87DPJ02Accident · Serious injuriesFinal reportAir Tractor AT-302 · Colony, OKDuring a downwind swath run the number one compressor bearing failed in the ltp 101-600-1A engine which resulted in the engine failing completely. During an attempt to turn into the wind for an emergency landing the left wing tip struck the ground and the…Feb 11, 1987 · N8864S · Substantial damage NTSB FTW87DPJ01Accident · No injuriesFinal reportSnow AT-301 · Hennessey, OKThe acft collided with a street sign during takeoff. Unablt to maintain flight, the plt landed the acft in a field collapsing the right landing gear.Nov 1, 1986 · N7309D · Substantial damage NTSB FTW86FPJ08Accident · Serious injuriesFinal reportAir Tractor AT-301 · Blackwell, OKThe acft crashed after a turn while spraying a field. The acft caught fire after the impact but the plt escaped.Jun 7, 1986 · N23539 · Destroyed NTSB FTW82DA199Accident · No injuriesFinal reportAir Tractor AT 301 · Eakly, OKThe pilot stated that as he pulled up from a swath run the engine started missing. He then elected to attempt a return to his departure airstrip. While turning toward the field the engine started making a loud noise and lost power. During the forced landing…May 29, 1982 · N3653F · Substantial damage NTSB FTW79DPM24Accident · No injuriesClosedAir Tractor 301 · Bartlesville, OKJul 2, 1978 · N4430S · Substantial damage