NTSB investigations: Air Tractor AT-400
7 cases on aircraft the registry lists as Air Tractor AT-400, where the first occurrence was “In flight collision with object”. 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
| 1982 | 1 |
|---|---|
| 1989 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1998 | 1 |
| 2004 | 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 ('0390202')
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\" = 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 ('0390202')
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" = 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 FTW04LA201Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-400 · Clayton, LAThe pilot's failure to maintain clearance from the high tension power lines.NTSB LAX98LA233Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400 · Tranquillity, CAThe pilot's failure to detect and avoid a set of wires during a night aerial application flight. Factors in the accident were the pilot's failure to perform an adequate preflight inspection of the field to determine obstruction locations and the dark night…NTSB ATL93LA056Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-400 · South Mills, NCThe pilot's failure to maintain adequate clearance from trees during an aerial application maneuver. Factors were the trees adjacent to the wheat field, and the soft terrain.NTSB LAX92LA227Accident · No injuriesLimited investigationFinal reportAir Tractor AT 400 · Lemoore, CAThe pilot's failure to observe the presence of an obstacle in the field. Factors which contributed to the accident were the dark nighttime light condition, and the small size and color of the obstacle which decreased the conspicuity of the object.NTSB NYC90DGM01Accident · Serious injuriesFinal reportAir Tractor AT-400 · Tyrone, PAThe pilot's failure to maintain adequate clearance from obstructions during low level aerial application operations. The pilot's inadequate visual lookout was a factor.NTSB MKC89LA123Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400 · Poplar Bluff, MOThe pilot in command misjudged the clearance of the aircraft's vertical stabilizer from the power lines.NTSB FTW82DA372Accident · No injuriesFinal reportAir Tractor AT-400 · Muleshoe, TXPilot collided with a water spraying machine while making crop spray pass. Landing gear tore off.