NTSB investigations: Air Tractor AT-802A, 2020
5 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\") = 2020
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") = 2020
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 WPR20LA315Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT-802A · Emmett, IDThe pilot’s descent below surrounding terrain and his delayed decision to initiate a climb which resulted in impact with terrain. Contributing to the accident were terrain and lighting conditions that affected the pilot’s ability to accurately assess terrain…NTSB CEN20LA357Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT802 · Dell, ARThe pilot’s failure to maintain airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall and collision with terrain.NTSB WPR20LA246Accident · 2 fatalClass 3 · LimitedFinal reportAir Tractor AT802 · Elgin, NVThe trailing pilot’s failure to maintain separation from the lead airplane during a fire retardant deployment flight, which resulted in the trailing airplane flying through a plume of retardant and the trailing pilot’s subsequent loss of visibility that led…NTSB ANC20LA069Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT802 · Birch Creek, AKA loss of control for undetermined reasons while on the surface of the water during scoop operations in support of wildland firefighting operations.NTSB ANC20CA052Accident · No injuriesClass 4 · Data collectionFinal reportAir Tractor AT802 · Unalakleet, AKThe pilot's failure to maintain terrain clearance during the departure, which resulted in a collision with terrain..