NTSB investigations: Air Tractor AT-301
16 cases on aircraft the registry lists as Air Tractor AT-301, where the first occurrence was “In flight collision with terrain/water”. 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
| 1984 | 1 |
|---|---|
| 1985 | 1 |
| 1988 | 1 |
| 1990 | 2 |
| 1992 | 3 |
| 1994 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2005 | 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\" = 230))
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" = 230))
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 DFW07LA148Accident · Serious injuriesLimited investigationFinal reportAir Tractor 301 · Lueders, TXThe pilot's failure to maintain airspeed which resulted in an inadvertent stall and subsequent impact with terrain.NTSB CHI05LA188Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Langdon, NDThe pilot's failure to maintain clearance from the terrain while attempting an abrupt turning maneuver at a low altitude.NTSB CHI02LA221Accident · Minor injuriesLimited investigationFinal reportAir Tractor 301 · Ulen, MNThe pilot not performing an aborted takeoff. A factor was the soybean crop.NTSB CHI01LA191Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Grygla, MNThe pilot not maintaining altitude/clearance from terrain on takeoff. A factor was the high density altitude.NTSB LAX98LA128Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Imperial, CAThe pilot's selection of the wrong runway, which resulted in a downwind takeoff attempt, and, his failure to obtain/maintain a proper airspeed during the takeoff sequence. The aircraft's gross weight and the prevailing density altitude were factors in the…NTSB FTW97FA229Accident · 1 fatalField investigationFinal reportAir Tractor AT-301 · Las Animas, COin-flight collision with terrain, while maneuvering, for undetermined reason(s).NTSB CHI95LA219Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Grygla, MNThe pilot's failure to maintain altitude and/or clearance at the beginning of the spray run. A factor was turbulence due to the different Air temperatures of adjoining terrain.NTSB CHI94LA193Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Levant, KSThe pilot's inadequate evaluation of weather conditions associated with known thunderstorm activity. Factors were the thunderstorm and downdrafts.NTSB LAX92LA348Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Laveen, AZThe pilot's failure to maintain altitude during the low-level aerial application procedure turn. Contributing to this accident was the night condition and the high tension wires.NTSB DEN92LA062Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Rocky Ford, COThe pilots failure to maintain altitude due to spatial disorientation. Factors were: low overcast skies and ground fog.NTSB FTW92LA118Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Almyra, ARThe pilot's improper judgement of the descent rate and his inadequate pull up at the bottom.NTSB FTW90DPG04Accident · No injuriesFinal reportAir Tractor 301A · Foreman, ARThe pilot's inadvertent stall/mush.NTSB FTW90DRG04Accident · No injuriesFinal reportAir Tractor AT-301 · Mission, TXThe pilot's failure to maintain proper clearance above the crops he was spraying. A factor was the tree induced mechanical turbulence encountered during the descending turn.NTSB MIA88LA229Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Moorhead, MSWhile on an aerial application flt during the ground roll the wind changed from a headwind to a tailwind. The plt dumped the load of chemical in an attempt to climb but the acft crashed into a fish pond.NTSB SEA85FYM01Accident · Serious injuriesFinal reportAir Tractor AT301 · Weston, ORDuring this aerial application flight the aircraft clipped a tree and then impacted with the ground. The pilot was seriously injured when the stitching on the shoulder harness failed and the pilot was thrown forward.NTSB FTW84LA324Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Abernathy, TXThe acft collided with the bank of a drainage ditch in a field during a spray operation at which time the left main gearwas knocked off the acft. A precautionary landing was made during which the acft ground looped and the right main gear collapsed.