NTSB investigations: Air Tractor AT-301
11 cases on aircraft the registry lists as Air Tractor AT-301, where NTSB found Not determined, general. 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
| 2008 | 1 |
|---|---|
| 2010 | 1 |
| 2011 | 3 |
| 2013 | 2 |
| 2014 | 1 |
| 2018 | 2 |
| 2022 | 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_findings.parquet' f WHERE f.case_mkey = x.case_mkey AND f.aircrafts_position = x.position AND starts_with(f.\"findingCode\", '05000000')))
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_findings.parquet' f WHERE f.case_mkey = x.case_mkey AND f.aircrafts_position = x.position AND starts_with(f."findingCode", '05000000')))
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 CEN22LA354Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-301 · Lamoni, IAA loss of airplane performance for reasons that could not be determined.NTSB CEN18LA356Accident · No injuriesLimited investigationFinal reportAir Tractor AT 301 · Partridge, KSThe total loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN18LA288Accident · No injuriesLimited investigationFinal reportAir Tractor AT 301 · Milford, IAThe pilot's loss of airplane control during takeoff for reasons that could not be determined because no anomalies consistent with a flight control system malfunction were observed.NTSB CEN14LA229Accident · No injuriesLimited investigationFinal reportAir Tractor AT 301 · Hessmer, LAA partial loss of engine power for reasons that could not be determined because a full examination of the engine could not be performed.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 CEN13LA341Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Farnsworth, TXThe partial loss of engine power for reasons that could not be determined because the postaccident engine examination revealed no anomalies.NTSB CEN11LA598Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Edgeley, NDThe loss of engine power for reasons that could not be determined because postaccident examination of the airplane and engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN11FA562Accident · No injuriesField investigationFinal reportAir Tractor AT-301 · Nekoosa, WIA total loss of engine power during initial climb for undetermined reasons.NTSB WPR11LA272Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Hogeland, MTCollision with the ground while maneuvering at low altitude for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB CEN10CA582Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Atkins, ARA partial loss of engine power during low-altitude flight for undetermined reasons.NTSB DFW08CA216Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Wisner, LAThe loss of engine power for undetermined reasons.