NTSB investigations: Air Tractor AT-301
18 cases on aircraft the registry lists as Air Tractor AT-301, where the first occurrence was “Airframe/component/system failure/malfunction”. 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
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1986 | 2 |
| 1987 | 3 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1996 | 1 |
| 1999 | 3 |
| 2001 | 1 |
| 2002 | 1 |
| 2007 | 1 |
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\" = 130))
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" = 130))
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 CHI07LA173Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Fergus Falls, MNThe propeller blade failure during climb due to a fatigue crack. The oil leak that obstructed the pilot's vision was a factor in the accident.NTSB LAX02LA257Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Dos Palos, CAthe failure of the propeller blade due to fatigue. Factors in the accident were the inadequate maintenance-repair of the blade, and, inadequate pilot preflight inspections.NTSB CHI01LA252Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Edmore, NDThe incorrect installation of the wheel assembly bolts by maintenance personnel resulting in the stripped bolt threads and ultimate failure of the wheel, and directional control not possible by the pilot. A factor was the ditchNTSB FTW00LA012Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Olton, TXThe inflight separation of the propeller blade due to damage from a wire strike. A factor was the lack of suitable terrain for the forced landing.NTSB FTW99LA204Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Victoria, TXThe separation of the engine cowling due to a fractured support bracket, which resulted in the cowling striking and bending four engine push rods causing a loss of engine power. A factor was the lack of suitable terrain for the forced landing.NTSB FTW99LA107Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Garwood, TXThe pilot's inability to maintain directional control of the airplane as result of the failure of the right brake system due to the stripped threads on the eye bolt connecting the brake pedal to the brake master cylinder.NTSB CHI96LA217Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Ness City, KSthe failure of a counterweight bolt in the propeller for reasons undetermined. Factors were the wet landing area and the encounter with unsuitable terrain during the forced landing.NTSB DEN93LA084Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Garner, ARTotal failure of one propeller blade. Factors were the continued operation of the engine during the forced landing, despite the pilot's efforts to shut it down, and the lack of suitable terrain for the forced landing.NTSB MIA92LA179Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Satartia, MSFailure of the brake system due to installation of a bogus part by an unknown person. Directional control by the pilot in command was not possible.NTSB MIA91LA144Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Tutwiler, MSFatigue failure of one of the propeller blades resulting in the forced landing. Contributing to the accident was lack of suitable terrain.NTSB MIA90LA083Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Rolling Fork, MSThe in-flight separation of the left aileron due to improper maintenance procedures and an inadequate aircraft preflight.NTSB MKC87DPG03Accident · Serious injuriesFinal reportAir Tractor AT-301 · Tillar, ARThe pilot stated that the prop RPM became erratic. On approach, the prop ran completely out of control, causing the aircraft to nose down into a plowed field just short of the landing area. The a/c hit on the main landing gear, broke them off, then it nosed…NTSB MIA87LA209Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Swiftown, MSWhile spraying cotton, severe vibration was felt throughout the acft & the plt elected a forced ldg. During the flare, the throttle was advanced to raise the nose, & the plt discovered the eng had totally failed. The acft flipped inverted on touch down. An…NTSB MKC87LA137Accident · No injuriesLimited investigationFinal reportAir Tractor AT301A · Baderville, MODuring an aerial application operation, the pilot experienced a violent engine vibration. He reduced power and attempted an emergency ldg. Acft nosed over on landing. The pilot exited aircraft through side window. Acft caught fire and was destroyed.…NTSB FTW86FRG20Accident · No injuriesFinal reportAir Tractor AT301 · Taylor, TXCommercial pilot of an Air Tractor AT301 enroute to base of operations at Taylor, TX executed a forced landing after experiencing severe vibration in the aircraft. Landing was made to a soft field. The aircraft nosed over during landing roll and was…NTSB SEA86LA081Accident · No injuriesLimited investigationFinal reportAir Tractor 301 · Prescott, WAThe brake locking system engaged in flight causing the right brake to lock. The aircraft nosed over on landing where a small fire erupted from fuel spillage onto the hot engine.NTSB FTW85LA039Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Mission, TXAfter a loss of oil pressure the acft was landed downwind. During the precautionary landing across plowed furrows, the rt wing caught in the sugar cane crop and the acft turned to the rt, collapsing the left landing gear and damaging the left wing. The plts…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…