NTSB investigations: Air Tractor AT-301, MT

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

19672026

NTSB investigations: Air Tractor AT-301, MT per year, 1967–2026: 10 cases
1967	1
1982	2
1983	1
1987	1
1995	1
2000	1
2011	2
2022	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" = 'MT' 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\" = 'MT' 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" = 'MT' 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 WPR22LA293Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-301 · Circle, MTThe loss of engine power due to carburetor ice. Contributing to the accident was the pilot’s failure to use carburetor heat.Aug 7, 2022 · N36542 · Substantial damage NTSB WPR11CA286Accident · No injuriesData collectionFinal reportAir Tractor AT301 · Circle, MTThe pilot's failure to attain and maintain an adequate airspeed during initial climb.Jun 24, 2011 · N2362D · Substantial damage NTSB WPR11LA272Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Hogeland, MTCollision with the ground while maneuvering at low altitude for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Jun 21, 2011 · N3661B · Substantial damage NTSB SEA00LA148Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-301 · Brockway, MTThe pilot's failure to maintain clearance from power lines.Jul 31, 2000 · N4330S · Substantial damage NTSB SEA95LA161Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Havre, MTthe loss of power due to a failure of the cylinder head exhaust valve rocker box. The tall crop encountered during the forced landing is a factor.Jul 24, 1995 · N3660U · Substantial damage NTSB DEN87LA084Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Conrad, MTAn ag plt was returning from an aerial application. Six miles from the destination arpt the engine quit. The plt attempted to land on a road but the acft struck the edge of a pit, spun across the road and came to rest facing 180 degrees from the original…Apr 5, 1987 · N23069 · Substantial damage NTSB DEN83LA136Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Conrad, MTThe acft landed hard and collapsed the right main landing gear during a forced landing after fuel exhaustion. During a landing to reload the pilot had handled the herbicide on-loading and a ground crewman was loading the acft fuel. The supply of 80/87 octane…Jun 9, 1983 · N23069 · Substantial damage NTSB DEN82DTI13Accident · No injuriesFinal reportAir Tractor AT-301 · Ruyard, MTThe aircraft was refueled prior to takeoff. The pilot reported that the takeoff was normal until about 75 ft off the runway when the engine quit. During a forced landing, the plane touched down in a 3-point attitude, bounced, and then hit the ground in a nose…Jun 2, 1982 · N4403S · Substantial damage NTSB DEN82DTI09Accident · No injuriesFinal reportAir Tractor AT-301 · Greenough, MTDuring takeoff the aircraft struck a snow berm. The aircraft received substantial damage to both wings and prop. The aircraft had been landed on a county road about a week earlier due to deteriorating weather.Jan 3, 1982 · N23069 · Substantial damage NTSB SEA68A0039Accident · Minor injuriesClosedConvair 340T · Great Falls, MTNov 1, 1967 · N73120 · Substantial damage