NTSB investigations: Air Tractor AT-802A, 2023
2 cases on aircraft the registry lists as Air Tractor AT-802A. 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
| 1997 | 1 |
|---|---|
| 1999 | 1 |
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 2 |
| 2003 | 1 |
| 2006 | 3 |
| 2007 | 2 |
| 2008 | 2 |
| 2009 | 2 |
| 2010 | 2 |
| 2011 | 4 |
| 2012 | 2 |
| 2013 | 2 |
| 2014 | 4 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 8 |
| 2018 | 4 |
| 2019 | 2 |
| 2020 | 5 |
| 2021 | 4 |
| 2022 | 3 |
| 2023 | 2 |
| 2024 | 7 |
| 2025 | 2 |
| 2026 | 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 year(c.\"eventDate\") = 2023
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0390308'))
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") = 2023
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0390308'))
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 CEN23LA334Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT802 · Aberdeen, SDThe pilot's failure to maintain directional control while taxiing with a quartering tailwind, which resulted in a ground loop.NTSB ERA23LA272Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT802 · Wellington, FLWear of the fuel control unit drive shaft and the corresponding fuel pump drive gear, which resulted in the disengagement of the fuel control unit from the fuel pump, a decrease in fuel flow, and a loss of engine power.