NTSB investigations: Air Tractor AT-401, FL
6 cases on aircraft the registry lists as Air Tractor AT-401. 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
| 1990 | 1 |
|---|---|
| 1993 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 1999 | 1 |
| 2003 | 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.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0390204', '0390209'))
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."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0390204', '0390209'))
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 MIA03LA094Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT- 401 · Fellsmere, FLThe poor in-flight planning by the pilot-in-command for his overhsooting the pull-up following a spray pass resulting in the in-flight collision with trees then terrain. Contributing to the accident was sunglare that the pilot encountered during the spray…NTSB MIA99LA212Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Moore Haven, FLThe pilot exceeding the gross takeoff weight which reduced the climb capability and subsequent in-flight collision with terrain. Contributing to the accident was the high temperature and the pilot's failure to use aircraft performance data for the weather…NTSB MIA97LA208Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Altha, FLthe pilot's impairment of judgment and performance due to alcohol which led to his failure to maintain control of the airplane.NTSB MIA95LA180Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Clewiston, FLImproper weather evaluation by the pilot in command while attempting to takeoff with a quartering tailwind associated with a nearby thunderstorm and failure of the pilot to maintain directional control.NTSB MIA93LA104Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Fort Pierce, FLFailure of the no. 2 cylinder in fatigue for undetermined reasons, over unsuitable terrain. The lack of suitale terrain for the forced landing was a factor.NTSB MIA91LA033Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT401 · Belle Glade, FLThe pilot failed to maintain airspeed, and stalled the airplane, resulting in a uncontrolled descent, and collision with the terrain.