NTSB investigations: Air Tractor AT-400A
15 cases on aircraft the registry lists as Air Tractor AT-400A. 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
| 1979 | 1 |
|---|---|
| 1983 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1991 | 1 |
| 1997 | 2 |
| 1998 | 1 |
| 2002 | 1 |
| 2006 | 1 |
| 2008 | 1 |
| 2013 | 1 |
| 2019 | 1 |
| 2022 | 1 |
| 2025 | 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 ('0390203'))
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 ('0390203'))
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 CEN25LA303Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-400A · Lamoni, IAThe pilot’s failure to maintain airplane control during an aborted takeoff.NTSB ERA22LA255Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-400A · Pemberton Township, NJThe pilot’s improper landing flare, which resulted in a hard, bounced landing and a subsequent loss of control.NTSB GAA19CA163Accident · No injuriesData collectionFinal reportAir Tractor AT 400A · Parma, IDThe pilot's failure to maintain directional control during landing in variable wind conditions, which resulted in the right wing impacting muddy terrain.NTSB CEN13LA239Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Bowling Green, MOThe failure of the engine supercharger's rear bearing, which resulted in the loss of engine power.NTSB CHI08CA257Accident · No injuriesData collectionFinal reportAir Tractor AT-400A · Luverne, MNThe failure of the compressor turbine blades which resulted in the loss of power. Factors associated with the accident were the low altitude and the trees.NTSB CHI06CA254Accident · No injuriesData collectionFinal reportAir Tractor AT-400A · Alliance, NEThe pilot's inadequate preflight inspection which led to the aircraft tow bar not being removed prior to flight.NTSB ATL02LA066Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-400A · Hastings, FLFatigue cracking in the most outboard splice bolt hole in the lower spar cap of the right wing. .NTSB FTW99LA031Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400A · Bunkie, LAThe total loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB FTW97LA223Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-400A · Black Oak, ARThe loss of engine power due to compressor turbine blade failure. A factor was the lack of suitable terrain for the forced landing.NTSB FTW97LA169Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400 · Fluvanna, TXThe loss of engine power due to the failure of the reduction gear box. A factor was the lack of suitable terrain for the forced landing.NTSB FTW91DRD04Accident · Serious injuriesFinal reportAir Tractor AT 301 · Lake Providence, LAA loss of engine power for undetermined reasons resulting in a forced landing and nose over on landing.NTSB FTW88DQG02Accident · Serious injuriesFinal reportAir Tractor AT-301 · Lockney, TXAfter completing a swath run, the plt began a procedure turn to the right for another run. During the maneuver, the acft stalled & turned counterclockwise for about 180 deg before impacting the ground in a nose down, left wing low attitude.NTSB FTW86FQG09Accident · No injuriesFinal reportAir Tractor AT-400A · Hereford, TXThe plt reptd that as he was returning to the arpt, the eng lost power from a 'low fuel and/or rough Air' condition. Subsequently, the acft was damaged when it was landed on uneven terrain near a creek. Less than 1 gal of fuel was remaining in the acft. The…NTSB FTW83FA270Accident · 1 fatalField investigationFinal reportAir Tractor AT-400A · Lane City, TXThe plt was leading a flt of 2 acft on an aerial application mission. The plt of the 2nd acft stated that at the end of a swath run, the lead acft pulled up to an almost vertical attitude & to an alt of between 300 & 400 ft AGL. At that time, the plane…NTSB SEA79DYA27Accident · No injuriesClosedAir Tractor AT-301 · Newdale, ID