NTSB investigations, NV
9 cases where the sequence of events included Low altitude operation/event.
Cases per year
| 2009 | 1 |
|---|---|
| 2010 | 1 |
| 2013 | 2 |
| 2018 | 2 |
| 2020 | 2 |
| 2023 | 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 c.\"eventStateOrRegion\" = 'NV' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'NV' AND c."eventCountry" = 'USA' 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 WPR23LA145Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Elko, NVThe pilot’s failure to maintain sufficient altitude and airspeed in gusting tailwind conditions that resulted in an unrecoverable descent and impact with terrain.NTSB WPR21LA058Accident · Minor injuriesClass 3 · LimitedFinal reportAir Creation Tanarg · Pahrump, NVThe pilot’s failure to maintain control while maneuvering at low altitude.NTSB WPR20CA197Accident · No injuriesClass 4 · Data collectionFinal reportRobinson R44 · Pioche, NVThe pilot’s decision to fly at low level over mountainous terrain and his inability to recover when the helicopter encountered a downdraft that resulted in a collision with terrain.NTSB GAA19CA039Accident · Minor injuriesData collectionFinal reportBell OH 58A · Carson City, NVThe pilot's failure to maintain clearance from power lines while maneuvering at a low altitude in hilly terrain. Contributing to the accident was the pilot’s inability to determine the airplane’s altitude due to sun glare.NTSB GAA18CA512Accident · No injuriesClass 4 · Data collectionFinal reportBell 206 · Battle Mountain, NVThe pilot's failure to maintain the proper altitude and airspeed while flying in a canyon in gusting wind conditions.NTSB WPR13CA204Accident · No injuriesData collectionFinal reportBell 206B · Wells, NVThe pilot's failure to maintain clearance from an obstacle while maneuvering at a low altitude.NTSB WPR13GA128Accident · 1 fatalFinal reportBell 206B · Eureka, NVThe pilot’s failure to maintain clearance from a wire while maneuvering during low-altitude operations. Contributing to the accident was task- and/or work-related fatigue.NTSB WPR10CA124Accident · Serious injuriesData collectionFinal reportPiper PA-28-235 · Crystal, NVThe pilot's failure to maintain clearance from a ground vehicle during a low-altitude maneuver.NTSB WPR09CA470Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 II · Mt Charleston, NVThe pilot's failure to maintain aircraft control and terrain clearance while maneuvering at a low altitude above high terrain. Contributing to the accident was a downdraft and high density altitude.