NTSB investigations: Air Tractor AT-401, 1995
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
| 1989 | 2 |
|---|---|
| 1990 | 7 |
| 1991 | 3 |
| 1992 | 2 |
| 1993 | 3 |
| 1994 | 4 |
| 1995 | 6 |
| 1996 | 6 |
| 1997 | 2 |
| 1998 | 8 |
| 1999 | 5 |
| 2000 | 4 |
| 2001 | 6 |
| 2002 | 1 |
| 2003 | 3 |
| 2004 | 2 |
| 2005 | 2 |
| 2006 | 2 |
| 2007 | 2 |
| 2008 | 3 |
| 2010 | 2 |
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 2 |
| 2014 | 2 |
| 2015 | 2 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 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 year(c.\"eventDate\") = 1995
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 year(c."eventDate") = 1995
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 FTW95LA358Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Taft, TXThe pilot's diverted attention, which resulted in his failure to assure that clearance was maintained from the transmission line.NTSB CHI95LA258Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Aurora, NEthe cracked engine assembly that caused the power loss during a critical phase of flight. Factors associated with this accident were the restricted airplane performance due to the power loss, the airplane's altitude was too low, and remedial action, by, the…NTSB FTW95LA301Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Cash, AREngine power loss due to partial failure of one magneto combined with total failure of the other magneto. A factor was the lack of suitable terrain for a forced landing.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 FTW95LA256Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Hearne, TXThe loss of engine power as result of the failure of the number two cylinder. Factors were the unsuitable terrain available for the forced landing and the pilot's restricted vision due to oil on the windshield.NTSB FTW95LA241Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Denver City, TXThe loss of engine power due to a fracture of the #3 cylinder resulting in the total failure of the cylinder. A factor was the lack of suitable terrain for the forced landing.