NTSB investigations, CO
10 cases where the sequence of events included VFR encounter with IMC.
Cases per year
| 2008 | 3 |
|---|---|
| 2011 | 1 |
| 2012 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 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\" = 'CO' 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" = 'CO' 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 CEN23FA285Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-60-601P · Burlington, COThe pilot’s visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control in flight and subsequent impact with terrain.NTSB CEN18FA168Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Lone Tree, COThe pilot's loss of control due to spatial disorientation. Contributing to the accident was the pilot's self-induced pressure to fly the airplane at night in marginal weather conditions.NTSB CEN17FA354Accident · 4 fatalField investigationFinal reportCirrus Design SR22 · Glenwood Springs, COThe non-instrument-rated pilot's inadequate preflight weather planning, his decision to depart into forecast instrument meteorological conditions along the route of flight, and his continued visual flight into instrument meteorological conditions, which…NTSB CEN15FA400Accident · 4 fatalField investigationFinal reportCessna 310H · Silverton, COThe noninstrument-rated pilot's improper judgment and his failure to maintain situational awareness, which resulted in the flight's encounter with instrument meteorological conditions and controlled flight into terrain during cruise flight.NTSB CEN15FA051Accident · 2 fatalField investigationFinal reportMooney M20C · Pagosa Springs, COThe noninstrument-rated pilot's improper decision to fly to the destination airport and into known instrument meteorological conditions, which resulted in his controlled flight into mountainous terrain during a snow storm.NTSB CEN12FA639Accident · 2 fatalField investigationFinal reportMooney M20J · Teddys Peak, COThe pilot's decision to continue flight into deteriorating weather conditions, including fog and mountain obscuration, and his failure to maintain clearance with known rising terrain along the route of flight, which resulted in controlled flight into terrain.NTSB CEN12FA098Accident · 4 fatalField investigationFinal reportSocata TB21 · Silverton, COThe non-instrument-rated pilot’s decision to embark on a flight through forecasted instrument meteorological conditions (IMC), and his subsequent flight into IMC, which resulted in the pilot’s spatial disorientation and subsequent maneuvering of the airplane…NTSB CEN09LA056Accident · 1 fatalLimited investigationFinal reportCessna 182M · Basalt, COThe non-instrument-rated pilot's continued visual flight into instrument meteorological conditions, which resulted in his loss of control of the airplane in flight.NTSB DFW08FA212Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Yuma, COThe pilot's failure to maintain control of the airplane after an encounter with instrument meteorological conditions.NTSB DEN08FA141Accident · 4 fatalField investigationFinal reportCessna 182T · Georgia Pass, COThe pilot's failure to maintain aircraft control after inadvertantly encountering instrument meteorological conditions. Contributing to the accident were the pilot's failure to obtain a weather brief and the severe weather conditions.