NTSB investigations: Air Tractor AT-401
11 cases on aircraft the registry lists as Air Tractor AT-401, where the first occurrence was “Loss of engine power”. 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 |
|---|---|
| 1991 | 1 |
| 1994 | 2 |
| 1998 | 3 |
| 1999 | 1 |
| 2001 | 1 |
| 2004 | 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 ('0390204', '0390209')
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\" = 350))
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 ('0390204', '0390209')
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" = 350))
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 DFW07LA138Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Oak Grove, LAA complete loss of power due to failure of the impeller drive gear train and displacement of the blower spring drive mechanism, which resulted in seizure of the propeller shaft/crankshaft. Also causal was the failure of the phenolic separator bracket of the…NTSB FTW04LA130Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · San Angelo, TXThe loss of engine power for undetermined reasons. A contributing factor was the soft terrain encountered during the aborted takeoff.NTSB ATL01LA099Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Batesville, MSThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for an emergency landing.NTSB SEA99LA075Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Jerome, IDFuel exhaustion. Carburetor contamination and rough terrain were factors.NTSB ATL98LA117Accident · No injuriesLimited investigationFinal reportAir Tractor 401 · Holly Bluff, MSThe malfunction of the carburetor which resulted in improper fuel flow to the engine.NTSB MIA98LA181Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Rich, MSa loss of engine power for an undetermined reason, resulting in a forced landing and subsequent impact with rough terrain.NTSB CHI98LA118Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Highmore, SDthe pilot failed to abort the takeoff in a timely manner and could not stop on the runway.NTSB FTW94LA306Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Mcgehee, ARThe loss of engine power due to undetermined reasons. A factor was the unsuitable terrain.NTSB MIA94LA168Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Walls, MSThe partial loss of engine power for undetermined reasons. The sandy terrain was a factor.NTSB MIA91LA101Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-401 · Avon, MSLoss of engine power for undetermined reasons during a turn while on an aerial application flight. Contributing to the accident was failure of the left magneto due to failure of a phenolic gear which drives the rotating magnet.NTSB FTW90DPG12Accident · No injuriesFinal reportAir Tractor AT-401 · Jacksonville, ARA loss of engine power due to unknown causes. A factor was the unsuitable terrain.