NTSB investigations, NV
5 cases where the sequence of events included VFR encounter with IMC.
Cases per year
| 2011 | 1 |
|---|---|
| 2015 | 1 |
| 2018 | 1 |
| 2019 | 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '401' 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" = '401' 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 WPR19FA263Accident · 2 fatalField investigationFinal reportCessna 182 · Nixon, NVA loss of airplane control while maneuvering due to spatial disorientation after inadvertently entering instrument meteorological conditions (IMC). Contributing to the accident was the pilot's inexperience in IMC conditions.NTSB WPR19FA084Accident · 2 fatalClass 2 · FieldFinal reportCirrus SR22 · Ely, NVThe pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions and icing conditions which resulted in a high rate of descent and impact with terrain. Contributing to the accident was the inaccurate weather reporting…NTSB WPR18FA073Accident · 1 fatalField investigationFinal reportPiper PA 23-250 · Elko, NVThe pilot's inadequate preflight weather planning, which resulted in the flight over mountainous terrain into forecast instrument meteorological conditions, icing, and mountain wave, and resulted in an uncontrolled descent and collision with terrain.NTSB WPR15LA142Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW 27 · Reno, NVThe glider's encounter with severe turbulent atmospheric conditions after the pilot inadvertently entered clouds, which led to his inability to maintain a proper airspeed and the subsequent in-flight breakup of the glider.NTSB WPR11FA241Accident · 3 fatalField investigationFinal reportCessna R172K · Cold Springs, NVThe pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in a controlled collision with terrain.