NTSB investigations: Air Tractor AT-502
11 cases on aircraft the registry lists as Air Tractor AT-502, 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
| 1991 | 1 |
|---|---|
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 2 |
| 1996 | 1 |
| 1997 | 1 |
| 1999 | 1 |
| 2000 | 2 |
| 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 ('0390303')
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 ('0390303')
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 CHI08CA043Accident · Minor injuriesData collectionFinal reportAir Tractor AT-502 · Loop City, NEThe obstruction clearance not maintained by the pilot during an aerial application of a field and the subsequent hard landing onto the field. Contributing factors were the power line and rough/uneven terrain.NTSB FTW00LA259Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502 · Lariat, TXThe pilot's failure to maintain clearance with the antenna guy wire. A factor was the pilot's physical impairment from his use of diphenhydramine.NTSB FTW00LA232Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Helena, ARthe pilot's failure to maintain obstacle clearance. A contributing factor was the sun glare.NTSB SEA99LA114Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502 · Shelley, IDThe pilot-in-command's failure to maintain adequate clearance with obstacles. A contributing factor were the trees.NTSB FTW97LA134Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Paragould, ARThe pilot's failure to maintain clearance from trees resulting in jammed control surfaces. A factor was that aircraft control was not possible by the pilot.NTSB FTW97LA019Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Throckmorton, TXfailure of the pilot to maintain clearance of a transmission wire during pullup from a swath run. The proximity of the transmission wire was a related factor. The installation of wire cutter equipment on the landing gear might have prevented or reduced the…NTSB FTW94LA257Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Bosco, LAThe pilot's failure to maintain clearance with the telephone pole.NTSB FTW94LA098Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Moro, ARThe pilot's failure to maintain clearance of power lines.NTSB DEN93LA093Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Brookland, ARThe pilot's failure to maintain adequate object clearance.NTSB FTW92DRD04Accident · Minor injuriesFinal reportAir Tractor AT-502 · Mamou, LAThe pilot's failure to maintain proper clearance.NTSB MIA91LA196Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Cleveland, MSThe pilot's decision to continue the flight with reduced visual lookout due to a dirty foggy windshield.