Fatal NTSB investigations, 2020
11 cases where the sequence of events included Low altitude operation/event.
Cases per year
| 2008 | 23 |
|---|---|
| 2009 | 18 |
| 2010 | 15 |
| 2011 | 17 |
| 2012 | 19 |
| 2013 | 16 |
| 2014 | 13 |
| 2015 | 15 |
| 2016 | 15 |
| 2017 | 23 |
| 2018 | 15 |
| 2019 | 19 |
| 2020 | 11 |
| 2021 | 12 |
| 2022 | 10 |
| 2023 | 15 |
| 2024 | 9 |
| 2025 | 8 |
| 2026 | 5 |
Where
Latest 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '220' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '220' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run 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 CEN21LA084Accident · 2 fatalClass 3 · LimitedFinal reportRobinson R44 · Colorado City, TXThe pilot’s loss of control and exceedance of performance and/or structural limitations during low-altitude operations, which resulted in an inflight breakup.. Contributing to the accident was the pilot’s impairment from the effects of tetrahydrocannabinol.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 ERA20LA330Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA25 · Floral City, FLThe pilot’s failure to see and avoid a tree while flying towards the rising sun during an aerial application flight, which resulted in a collision with the tree and a subsequent loss of airplane control.NTSB CEN20LA272Accident · 1 fatalClass 3 · LimitedFinal reportGolden Circle Air T-Bird · Grosse Ile, MIThe noncertificated pilot’s failure to maintain clearance from trees while maneuvering at low altitude in gusting wind conditions. Contributing to the accident was the pilot’s lack of flight experience.NTSB ERA20LA220Accident · 1 fatalClass 3 · LimitedFinal reportRobinson R66 · Pikeville, NCThe pilot’s failure to see and avoid a small diameter wire during low altitude agricultural spraying operations. Contributing to the accident was the pilot’s insufficient property survey.NTSB ERA20LA217Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT502 · Atmore, ALThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall, spin, and loss of control.NTSB WPR20LA170Accident · 1 fatalClass 3 · LimitedFinal reportKitfox Kitfox · Lander, WYThe inexperienced pilot’s exceedance of the airplane’s critical angle-of-attack during a turn at high density altitude, which resulted in an accelerated stall and impact with water. Contributing to the accident was the pilot’s poor judgment to continue the…NTSB WPR20LA163Accident · 3 fatalClass 3 · LimitedFinal reportBell 206 · Fairfield, CAThe pilot’s failure to maintain adequate clearance from powerlines while conducting external load operations, which resulted in the main rotor contacting a wire and a subsequent collision with terrain.NTSB CEN20LA143Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT 502 · Pecan Gap, TXThe pilot did not maintain adequate clearance from tree, which resulted in a collision with a tree and subsequent impact with terrain.NTSB CEN20FA110Accident · 3 fatalClass 3 · FieldFinal reportCessna 172 · Lincoln, ILThe pilot's exceedance of the airplane's critical angle of attack during an aerial survey, which resulted in an aerodynamic stall at an altitude too low to recover.NTSB WPR20WA076Accident · 3 fatalClass 5 · ForeignLockheed C130 · Cooma, Australia