NTSB investigations: Air Tractor AT-502, 1998
6 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
| 1988 | 1 |
|---|---|
| 1989 | 2 |
| 1991 | 2 |
| 1992 | 1 |
| 1993 | 2 |
| 1994 | 4 |
| 1995 | 6 |
| 1996 | 3 |
| 1997 | 3 |
| 1998 | 6 |
| 1999 | 2 |
| 2000 | 4 |
| 2002 | 4 |
| 2003 | 4 |
| 2004 | 1 |
| 2005 | 2 |
| 2006 | 2 |
| 2007 | 3 |
| 2008 | 3 |
| 2009 | 3 |
| 2011 | 3 |
| 2012 | 3 |
| 2013 | 3 |
| 2014 | 2 |
| 2015 | 1 |
| 2016 | 4 |
| 2017 | 2 |
| 2018 | 2 |
| 2019 | 4 |
| 2020 | 1 |
| 2021 | 2 |
| 2022 | 4 |
| 2023 | 3 |
| 2024 | 1 |
| 2025 | 4 |
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 year(c.\"eventDate\") = 1998
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 year(c."eventDate") = 1998
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 MIA98LA202Accident · No injuriesLimited investigationFinal reportAir Tractor 502 · Clewiston, FLThe pilot's failure to attain adequate airspeed. A tailwind was a contributing factor.NTSB CHI98LA243Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Minto, NDthe pilot's selection of unsuitable terrain for takeoff. Factors were wet and soft runway conditions, and a ditch and the end of the overrun area.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 MIA98LA178Accident · No injuriesLimited investigationFinal reportAir Tractor 502 · Clarksdale, MSThe pilot's failure to extend the flaps for takeoff. A factor was his diverted attention to the loading of the airplane.NTSB MIA98LA175Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Clewiston, FLThe pilot's inadequate visual lookout while taxiing for takeoff.NTSB FTW98FA151Accident · 1 fatalField investigationFinal reportAir Tractor AT-502 · Mcgehee, ARThe pilot's inadvertent flight into adverse weather conditions resulting in the loss of control due to spatial disorientation. Factors were the fog and low ceiling, and the inadequate flight instruments available to the pilot.