Fatal NTSB investigations, 2014
13 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\") = 2014
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") = 2014 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 CEN15LA026Accident · 1 fatalLimited investigationFinal reportStephenson Stol CH 701 · Mount Vernon, INThe pilot’s impairment due to the ingestion of alcohol and sedating medications, which led to her improper decision to conduct low-level flight, affected her ability to safety operate the airplane, and resulted in her failure to maintain clearance from power…NTSB WPR15GA005Accident · 1 fatalFinal reportMarsh S 2F3AT · El Portal, CAThe pilot's failure to maintain clearance from trees while maneuvering at a low altitude.NTSB CEN15LA004Accident · 2 fatalLimited investigationFinal reportCelier Xenon R · Loma, COThe pilot’s failure to maintain clearance from a static wire and his decision to maneuver the gyroplane at low altitude.NTSB CEN14LA487Accident · 1 fatalLimited investigationFinal reportRobinson Helicopter R44 II · Macedonia, IAThe pilot’s inadequate visual lookout, which resulted in a collision with a static line.NTSB CEN14LA423Accident · 1 fatalLimited investigationFinal reportBell 47G 5 · Mansfield, ILThe pilot's failure to maintain clearance from power lines during low-altitude flight in gusting wind conditions following his use of a sedating medication.NTSB CEN14FA414Accident · 2 fatalField investigationFinal reportPiper PA 28R-201 · Steamboat Springs, COThe pilot’s inability to maintain a climb while attempting to cross over a mountain pass in high-density altitude conditions that degraded the airplane’s climb performance. Contributing to the accident was the pilot’s decision to attempt the flight in…NTSB WPR14FA239Accident · 2 fatalField investigationFinal reportAmerican AA-1A · El Mirage, CAThe pilot's loss of airplane control while intentionally maneuvering close to the ground, which resulted in the airplane exceeding its critical angle of attack in a steep bank and entering an accelerated stall.NTSB WPR14LA230Accident · 1 fatalLimited investigationFinal reportCessna 172M · Laytonville, CAThe pilot’s impairment due to alcohol ingestion, which resulted in his failure to maintain clearance from trees during a low-altitude flyby.NTSB CEN14WA254Accident · 1 fatalForeign investigationAir Tractor AT802 · Seron, SpainOn May 26, 2014, about 1400 UTC, an Air Tractor AT-802 airplane, EC-LCA, (s/n 802-0326), impacted terrain during a firefighting operation near Seron, Spain. A post-impact fire occurred and the airplane was subsequently destroyed. The pilot sustained fatal…NTSB WPR14FA203Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Santa Paula, CAThe pilot's failure to maintain clearance from power lines while flying at a low altitude.NTSB WPR14FA182Accident · 1 fatalField investigationFinal reportBoeing E75 · Fairfield, CAThe pilot's failure to maintain clearance from the runway during a low-level aerobatic maneuver due to his impairment by an over-the-counter antihistamine. Contributing to the severity of the pilot's injuries were the pilot's lack of fire protective clothing,…NTSB CEN14LA211Accident · 1 fatalLimited investigationFinal reportAir Tractor AT 502B · Garfield, KSThe pilot’s inadequate preflight planning and subsequent failure to remain clear of power lines while maneuvering low to the ground.NTSB CEN14FA122Accident · 3 fatalField investigationFinal reportBell 206L 3 · Silt, COThe pilot’s inadequate preflight planning for a low-level aerial surveillance flight of power transmission lines, which led to his being unaware of the crossing power line while flying toward the sun and his subsequent failure to maintain sufficient clearance…