NTSB investigations, NV
7 cases where the defining event was Collision with terr/obj (non-CFIT).
Cases per year
| 2008 | 1 |
|---|---|
| 2020 | 1 |
| 2022 | 2 |
| 2023 | 1 |
| 2025 | 2 |
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '470')
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '470') 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 WPR26LA062Accident · No injuriesClass 4 · LimitedFinal reportBell 407 · Las Vegas, NVTail rotor blade impact from an unidentified object at an undetermined time.NTSB WPR25LA276Accident · No injuriesClass 3 · LimitedPreliminary reportSchieber Cedric H CH801 · Jackpot, NVOn September 11, 2025, about 0905 Pacific daylight time, an experimental amateur-built Zenith CH801, N801CS, was substantially damaged when it was involved in an accident near Jackpot, Navada. The pilot and three passengers were not injured. The airplane was…NTSB WPR23LA362Accident · No injuriesClass 4 · LimitedFinal reportLet L-23 Super Blanik · Minden, NVThe pilot’s failure to maintain directional control during the landing roll, resulting in an impact with a taxiway sign.NTSB WPR22LA305Accident · No injuriesClass 4 · LimitedFinal reportHughes Helicopters 369E · Ely, NVThe pilot’s failure to maintain clearance from terrain while maneuvering at a low altitude.NTSB WPR22FA109Accident · 1 fatalClass 3 · FieldFinal reportDistar CZ D 13/15 SUN Dancer · Boulder City, NVThe pilot’s failure to maintain clearance from powerlines while maneuvering, which resulted in a wire strike and impact with terrain. Contributing to the accident was the pilot’s impairment from alcohol consumption and his use of diphenhydramine before the…NTSB WPR20CA260Accident · No injuriesClass 4 · Data collectionFinal reportEvektor Aerotechnik Sportstar · Las Vegas, NVThe student pilot's inadequate decision to make a premature turn onto a taxiway which resulted in a collision with a taxiway sign.NTSB SEA08CA173Accident · Minor injuriesData collectionFinal reportCosmos Phase II · Carson City, NVThe pilot's inadequate compensation for the crosswind conditions. Contributing to the accident was the crosswind.