NTSB investigations: Air Tractor AT-400A, TX
4 cases on aircraft the registry lists as Air Tractor AT-400A. 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
| 1983 | 1 |
|---|---|
| 1986 | 1 |
| 1987 | 1 |
| 1997 | 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\" = 'TX' 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 ('0390203'))
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" = 'TX' 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 ('0390203'))
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 FTW97LA169Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400 · Fluvanna, TXThe loss of engine power due to the failure of the reduction gear box. A factor was the lack of suitable terrain for the forced landing.NTSB FTW88DQG02Accident · Serious injuriesFinal reportAir Tractor AT-301 · Lockney, TXAfter completing a swath run, the plt began a procedure turn to the right for another run. During the maneuver, the acft stalled & turned counterclockwise for about 180 deg before impacting the ground in a nose down, left wing low attitude.NTSB FTW86FQG09Accident · No injuriesFinal reportAir Tractor AT-400A · Hereford, TXThe plt reptd that as he was returning to the arpt, the eng lost power from a 'low fuel and/or rough Air' condition. Subsequently, the acft was damaged when it was landed on uneven terrain near a creek. Less than 1 gal of fuel was remaining in the acft. The…NTSB FTW83FA270Accident · 1 fatalField investigationFinal reportAir Tractor AT-400A · Lane City, TXThe plt was leading a flt of 2 acft on an aerial application mission. The plt of the 2nd acft stated that at the end of a swath run, the lead acft pulled up to an almost vertical attitude & to an alt of between 300 & 400 ft AGL. At that time, the plane…