NTSB investigations: Air Tractor AT-502, FL
7 cases on aircraft the registry lists as Air Tractor AT-502. 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
| 1995 | 1 |
|---|---|
| 1998 | 3 |
| 2003 | 2 |
| 2005 | 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\" = 'FL' 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 ('0390303'))
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" = 'FL' 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 ('0390303'))
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 MIA05LA127Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Fort Pierce, FLThe failure of the pilot to abort the takeoff after a reported loss of engine power during the takeoff roll, resulting in the in-flight collision with a fence and trees. A factor in the accident was the failure of the pilot to lower the flaps to 10 degrees as…NTSB MIA03LA183Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Fort Pierce, FLFailure of one blade in the engine compressor turbine disk due to fatigue which was caused by loss of gap between the blade platforms as a result of corrosion due to a foreign element (phosphate). This resulted in loss of engine power during takeoff and…NTSB MIA03LA088Accident · 1 fatalLimited investigationFinal reportAir Tractor 502B · Belle Glade, FLThe failure of both pilots to use on-board communication radios to advise takeoff and landing intentions, the reduction of visibility of the pilot-in-command of N6037H due to sun glare during takeoff, and the poor in-flight planning by the pilot-in-command of…NTSB MIA98LA202Accident · No injuriesLimited investigationFinal reportAir Tractor 502 · Clewiston, FLThe pilot's failure to attain adequate airspeed. A tailwind was a contributing factor.NTSB MIA98LA188Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Okeechobee, FLthe pilot's improper planning/decision, by failing to ensure the aircraft contained adequate fuel to complete the flight, which led to fuel exhaustion, loss of engine power, and a forced landing. Obstructions (trees and guardrail) in the emergency landing…NTSB MIA98LA175Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Clewiston, FLThe pilot's inadequate visual lookout while taxiing for takeoff.NTSB MIA95LA229Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502 · Lorida, FLMismanagement of the fuel by the pilot resulting in the total loss of engine power due to fuel exhaustion, and the pilot's poor decision to fly over water en route to the refueling airport.