NTSB investigations: Air Tractor AT-301, 1983
8 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.
Cases per year
| 1967 | 1 |
|---|---|
| 1976 | 2 |
| 1978 | 4 |
| 1979 | 7 |
| 1980 | 11 |
| 1981 | 11 |
| 1982 | 14 |
| 1983 | 8 |
| 1984 | 6 |
| 1985 | 8 |
| 1986 | 9 |
| 1987 | 15 |
| 1988 | 10 |
| 1989 | 13 |
| 1990 | 5 |
| 1991 | 4 |
| 1992 | 10 |
| 1993 | 6 |
| 1994 | 10 |
| 1995 | 14 |
| 1996 | 6 |
| 1997 | 7 |
| 1998 | 10 |
| 1999 | 7 |
| 2000 | 7 |
| 2001 | 5 |
| 2002 | 7 |
| 2003 | 7 |
| 2004 | 6 |
| 2005 | 1 |
| 2006 | 2 |
| 2007 | 7 |
| 2008 | 8 |
| 2009 | 7 |
| 2010 | 5 |
| 2011 | 7 |
| 2012 | 3 |
| 2013 | 6 |
| 2014 | 4 |
| 2016 | 2 |
| 2018 | 3 |
| 2022 | 3 |
| 2024 | 1 |
| 2025 | 2 |
Where
Open the mapLatest cases
Query with SQL
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 year(c.\"eventDate\") = 1983
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 year(c."eventDate") = 1983
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" DESCRun 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 FTW83LA396Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Addis, LAThe acft made a forced landing in a plowed field after colliding with a low hanging transmission wire over a field beingsprayed. The plt applied full power after the collision but a damaged and locked up elevator caused excursions of climbing, stalling and…NTSB FTW83LA394Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · El Campo, TXThe acft collided with a berm dam during takeoff and cartwheeled into a rice field. The acft carried heavier fertilizer on this particular takeoff and with increasing Air temperatures, the plt knew he was not going to make it and dumped the load. The dump…NTSB ATL83FKQ03Accident · No injuriesFinal reportAir Tractor AT-301 · Redwood, MSThe acft made a forced landing in a soybean field after severe vibration developed during a spraying operation. The pilot stated that the powerplant and flt controls were functioning normally at the time of the accident. An on-scene investigation revealed…NTSB ATL83LA292Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Fairfax, SCThe acft mushed into the ground after the engine quit from negative g forces imposed by the pilot after clearing a fenceduring a swath run. After the engine lost power due to the temporary fuel starvation the pilot managed to clear some trees and mush into…NTSB LAX83LA288Accident · No injuriesLimited investigationFinal reportAir Tractor AT 301 · Yuma, AZThe plt reported that he landed on a farm road to inspect the alternator & associated wiring before starting aerial application. Following the inspection, during which nothing was found wrong, he commenced taking off. As the acft was accelerating for takeoff,…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…NTSB ATL83LA225Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Fort Valley, GAThe eng quit at 200 ft AGL as the plt was returning to a strip. A forced landing was made in a wheat field & the acft rolled through a narrow tree line. The carb float was found cracked & leaking.NTSB FTW83LA166Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Newellton, LAAprx 1 minute after takeoff the acft engine failed. During the forced landing, the acft flipped inverted damaging one wing tip and the vertical stabalizer. Post crash inspection revealed a crack in the number 7 cylinder, from spark plug to spark plug, which…