NTSB investigations: Air Tractor AT-301
7 cases on aircraft the registry lists as Air Tractor AT-301, where the defining event was Low altitude operation/event. 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
| 2009 | 1 |
|---|---|
| 2010 | 1 |
| 2011 | 2 |
| 2013 | 2 |
| 2016 | 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_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '220'))
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_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '220'))
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 GAA16CA399Accident · No injuriesData collectionFinal reportAir Tractor AT 301 · Bird Island, MNThe pilot's diverted attention inside the cockpit and failure to maintain the airplane's altitude while maneuvering at a low altitude, resulting in an impact with terrain.NTSB CEN13LA375Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Colome, SDThe loss of engine power for reasons that could not be determined because a postaccident engine run revealed no anomalies that would have precluded normal operation.NTSB ERA13CA163Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Greenbrier, ALThe pilot’s failure to maintain adequate clearance from trees.NTSB ERA12CA050Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · McAlpin, FLThe pilot's misjudgment of the airplane's distance from known transmission lines.NTSB CEN11CA330Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Garwood, TXThe pilot's failure to maintain adequate clearance from transmission wires during a low-level maneuvering flight.NTSB CEN10CA185Accident · Minor injuriesData collectionFinal reportAir Tractor AT-301 · Malden, MOThe pilot's failure to maintain clearance from a tree during an aerial application flight.NTSB CEN09CA514Accident · Minor injuriesData collectionFinal reportAir Tractor AT-301 · DeWitt, ILThe pilot's failure to maintain clearance from the tree during the aerial application maneuver.