NTSB investigations: Air Tractor AT-301
33 cases on aircraft the registry lists as Air Tractor AT-301, where the first occurrence was “In flight collision with object”. 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
| 1982 | 1 |
|---|---|
| 1983 | 2 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 2 |
| 1987 | 3 |
| 1988 | 1 |
| 1989 | 1 |
| 1992 | 1 |
| 1994 | 2 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 3 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 2 |
| 2002 | 2 |
| 2003 | 3 |
| 2004 | 2 |
| 2007 | 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 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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220))
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220))
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 CHI07LA208Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Osceola, INThe pilot's failure to maintain clearance with the trees during the aerial application flight. Factors associated with the accident were the trees and the pilot's lack of experience in flying aerial application flights.NTSB CHI07CA188Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Walkerville, ILThe altitude/clearance not maintained by the pilot during the aerial application flight. The corn was a contributing factor.NTSB CHI04CA224Accident · Minor injuriesData collectionFinal reportAir Tractor AT-301 · Cambridge, KSThe pilot not jettisoning his chemical load during initial climb with the reported loss of airplane performance. Factors were the reported loss of aircraft performance and the tree.NTSB FTW04LA132Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Donna, TXThe pilot's failure to maintain clearance from the high tension power lines.NTSB FTW04LA021Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · San Angelo, TXThe pilot's improper weather evaluation and the wrong runway selection. A contributing factor was the tailwind.NTSB CHI03LA261Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-301 · Aplington, IAThe pilot not maintaining proper altitude/clearance from the wire during the aerial application flight. The factor to the accident was the power line.NTSB DEN03LA112Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Glendo, WYthe pilot's failure to maintain clearance from the trees. Factors contributing to the accident were the low altitude, the high density altitude, and the trees.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.NTSB LAX02LA203Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Westmorland, CAThe pilot's failure to maintain clearance with the power lines while maneuvering during an aerial application flight. A factor was the dark night condition.NTSB FTW01LA011Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Littlefield, TXthe pilot's failure to maintain clearance with a guy wire while maneuvering during an aerial application flight.NTSB SEA00LA148Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-301 · Brockway, MTThe pilot's failure to maintain clearance from power lines.NTSB FTW99LA140Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Brownwood, TXThe failure of the pilot-in-command to use the manufacturer's published checklist and extend the flaps prior to takeoff. A factor was the pilot's fatigued physiological condition as a result of extended flight and ground duty hours.NTSB FTW98LA304Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Plainview, TXThe pilot's failure to maintain obstacle clearance during the aerial application flight. A factor was the transmission wire.NTSB FTW97LA317Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Vernon, TXfailure of the pilot to maintain clearance from an irrigation pipe. Factors relating to the accident were: the poor light condition at dusk, the object (vertical piece of irragation pipe), loss of engine power from foreign object damage, and the lack of…NTSB FTW97LA242Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Edna, TXfailure of the pilot to maintain clearance from a guy wire, during a swath run.NTSB CHI97LA124Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Huron, SDThe pilot's failure to maintain clearance from known transmission lines.NTSB FTW96LA371Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Meadow, TXThe pilot's failure to maintain clearance from the transmission wire. A factor was the lack of suitable terrain for a forced landing.NTSB CHI95LA106Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Meade, KSthe pilot's not obtaining/maintaining clearance with the utility pole. A factor was the utility pole.NTSB FTW95LA028Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Lubbock, TXThe pilot's failure to maintain clearance with the irrigation equipment. A factor was pilot fatigue.NTSB CHI94LA241Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Eckelson, NDthe pilot's failure to maintain clearance from a transmission wire. A factor associated with the accident is the transmission wire.NTSB FTW92DQG01Accident · Minor injuriesFinal reportAir Tractor AT-301 · Lubbock, TXThe pilot's selection of a downwind runway for takeoff. A factor was the tailwind.NTSB ATL89DKG04Accident · 1 fatalFinal reportAir Tractor AT-301 · Americus, GAThe pilot's failure to properly survey the area in which he would be conducting aerial application flights and his failure to see and avoid powerlines while performing aerial application.NTSB LAX88DUM05Accident · No injuriesFinal reportAir Tractor AT-301 · Niland, CAJust after takeoff, the pilot made a right turn to locate the ground flaggers and to avoid transmission wires. The pilot, unable to locate the flaggers, initiated a climb to avoid wires and rising terrain. However, the airplane did not gain sufficient…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…NTSB FTW87DRG04Accident · Minor injuriesFinal reportAir Tractor AT301 · Santa Rosa, TXThe pilot was dusting a sugar cane field which bordered a dirt road with parallel electrical transmission lines. The pilot had been terminating his swath runs by flying underneath the electrical wires at the edge of the field. To prevent becoming a hazard to…NTSB ATL87DKG01Accident · Serious injuriesFinal reportAir Tractor AT301 · Atmore, ALDuring landing the aircraft collided with a tractor mowing grass on the runway. The pilot stated that the sunglare on final prevented him from seeing the vehicle on the runway. The tractor's operator apparently did not hear the aircraft because he made no…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.NTSB CHI86FEX07Accident · Minor injuriesFinal reportAir Tractor AT301 · Bruceville, INThe acft collided with trees during a pull-up at the end of a swath run. During the collision the rt wing tip separated from the acft and the acft rolled hitting the ground with the rt wing first which started a cartwheel. Investigation revealed that the acft…NTSB LAX85LA374Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Williams Afb, AZAfter making his first swath run,during the hours of darkness,the pilot became disorented and flew into an area with tall electrical transmission lines. He descended into trees beneath the lines in his attempt to miss them.NTSB FTW84LA274Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · San Benito, TXAt the beginning of the initial swath run the acft collided with power lines. The power lines remained attached to the acft throughout the uncontrolled descent into a cotton field.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 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 FTW82DRJ13Accident · 1 fatalFinal reportAir Tractor 301 · Clarksville, TXThe pilot stated that he briefed the two flagmen about moving to next row as soon as the aircraft was lined up on the swath run. Both flagmen moved properly until on the fatal pass one flagman did not move and the aircraft struck him. The flagman struck by…