Skip to content

NTSB investigations: Air Tractor AT-301

291 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, newest first

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."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.\"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."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 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 FTW82DRG32Accident · Serious injuriesFinal reportAir Tractor 301 · Mcallen, TXThe pilot reported that the engine failed shortly after takeoff. The aircraft was substantially damaged when it hit a canal bank at the end of the airstrip. According to the operator, the blower section failed which resulted in the loss of power.May 14, 1982 · N8523S · Substantial damage NTSB FTW82DA101Accident · No injuriesFinal reportSnow AT-301 · Spearman, TXWhen the aircraft lost power after spraying crops the pilot executed a forced landing in a field. During the landing the aircraft nosed over. Investigation revealed that an induction hose had failed and blocked the carburetor. A service letter relating to…Mar 22, 1982 · N2326S · Substantial damage NTSB LAX82DA046Accident · No injuriesFinal reportAir Tractor 301 · Dos Palos, CADuring the takeoff roll the pilot decided that he was not going to clear an 8 foot chain-link fence at the end of the runway. He stated that he pulled the dump-gate, chopped the throttle, and put on the brake but the aircraft went into soft dirt and the right…Jan 21, 1982 · N8793S · 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 LAX81DVA02Accident · Minor injuriesClosedAir Tractor AT-301 · San Joaquin, CAOct 5, 1981 · N4341S · Substantial damage NTSB FTW81DPG70Accident · No injuriesClosedAir Tractor AT-301 · Lonoke, ARSep 30, 1981 · N8593S · Substantial damage NTSB FTW81FRG58Accident · No injuriesClosedSnow AT-301 · San Benito, TXAug 8, 1981 · N4409S · Substantial damage NTSB ATL81FKQ23Accident · No injuriesClosedAir Tractor AT-301 · Charleston, MSJul 31, 1981 · N4364S · Substantial damage NTSB FTW81DRJ27Accident · No injuriesClosedAir Tractor AT-301 · Monroe, LAJul 28, 1981 · N4407S · Substantial damage NTSB LAX81DVA53Accident · No injuriesClosedAir Tractor AT-301 · San Joaquin, CAJul 15, 1981 · N4341S · Substantial damage NTSB FTW81FRG55Accident · No injuriesClosedAir Tractor AT-301 · La Villa, TXJul 14, 1981 · N4416S · Substantial damage NTSB SEA81DYP19Accident · No injuriesClosedAir Tractor AT-301 · Prescott, WAMay 28, 1981 · N8827S · Substantial damage NTSB FTW81FRG36Accident · No injuriesClosedAir Tractor AT-301 · Pharr, TXMay 17, 1981 · N8523S · Substantial damage NTSB LAX81DUM13Accident · Minor injuriesClosedAir Tractor AT-301 · Brawley, CAMar 3, 1981 · N4399S · 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 ATL81FA099Accident · No injuriesClosedSnow AT302A · Selma, ALSep 25, 1980 · N8603S · Substantial damage NTSB LAX80FUM30Accident · Serious injuriesClosedAir Tractor AT-301 · Brawley, CASep 7, 1980 · N8629S · Destroyed NTSB LAX80FUM26Accident · 1 fatalClosedAir Tractor AT-301 · Brawley, CAAug 26, 1980 · N8544S · Destroyed NTSB MKC80FCA30Accident · No injuriesClosedAir Tractor AT-301 · Mathews, MOAug 21, 1980 · N8762S · Substantial damage NTSB ATL80FLG17Accident · No injuriesClosedAir Tractor AT-301 · Ehrhardt, SCAug 15, 1980 · N4411S · Substantial damage NTSB FTW80DPG46Accident · No injuriesClosedAir Tractor AT-301 · Palestine, ARJul 14, 1980 · N4364S · Substantial damage NTSB FTW80DRA33Accident · No injuriesClosedAir Tractor AT-301 · Alvin, TXMay 27, 1980 · N4342S · Substantial damage NTSB FTW80DRD35Accident · Minor injuriesClosedAirtractor AT301 · Eunice, LAMay 26, 1980 · N4411S · Substantial damage NTSB MKC80DCA15Accident · No injuriesClosedAir Tractor AT-301 · Lilbourn, MOMay 9, 1980 · N8689S · Destroyed NTSB FTW80FRJ13Accident · Serious injuriesClosedAir Tractor AT-301 · Monroe, LAApr 2, 1980 · N4445S · Destroyed NTSB LAX80DVM02Accident · No injuriesClosedAir Tractor AT-301 · Greenfield, CAOct 17, 1979 · N4438S · Destroyed NTSB MIA79FKQ28Accident · Minor injuriesClosedAir Tractor AT-301 · Grenada, MSSep 4, 1979 · N8595S · Substantial damage NTSB FTW79FRG51Accident · Serious injuriesClosedAir Tractor AT-301 · Taft, TXAug 11, 1979 · N4424S · Substantial damage NTSB LAX79DVA48Accident · No injuriesClosedAir Tractor AT-301 · Mendota, CAJul 16, 1979 · N8578S · Substantial damage NTSB FTW79FRG41Accident · 1 fatalClosedAir Tractor AT-301 · Elsa, TXJun 13, 1979 · N4412S · Destroyed NTSB FTW79FRA25Accident · 1 fatalClosedAir Tractor AT-301 · East Liverpool, TXMay 26, 1979 · N4335S · Destroyed NTSB SEA79DYA11Accident · Minor injuriesClosedAir Tractor AT-301 · Rigby, IDMay 7, 1979 · N4331S · Destroyed NTSB SEA78FYA21Accident · 1 fatalClosedAir Tractor AT-300 · Idaho Falls, IDAug 11, 1978 · N4331S · Substantial damage NTSB FTW78DRG62Accident · No injuriesClosedAir Tractor 301 · Rio Hondo, TXAug 1, 1978 · N4397S · Substantial damage NTSB IAD78FLT07Accident · No injuriesClosedAir Tractor AT301 · Ridgely, TNJul 18, 1978 · N4422S · Substantial damage NTSB FTW79DPM24Accident · No injuriesClosedAir Tractor 301 · Bartlesville, OKJul 2, 1978 · N4430S · Substantial damage NTSB FTW77FRG05Accident · 1 fatalClosedAir Tractor AT-301 · La Feria, TXOct 22, 1976 · N4343S · Destroyed NTSB MKC76DCQ59Accident · Serious injuriesClosedAir Tractor AT-301 · Subletta, KSJun 10, 1976 · N4349S · Substantial damage NTSB SEA68A0039Accident · Minor injuriesClosedConvair 340T · Great Falls, MTNov 1, 1967 · N73120 · Substantial damage