NTSB investigations, 2017
29 cases where the sequence of events included VFR encounter with IMC.
Cases per year
| 2008 | 28 |
|---|---|
| 2009 | 31 |
| 2010 | 33 |
| 2011 | 31 |
| 2012 | 23 |
| 2013 | 23 |
| 2014 | 22 |
| 2015 | 24 |
| 2016 | 18 |
| 2017 | 29 |
| 2018 | 15 |
| 2019 | 24 |
| 2020 | 13 |
| 2021 | 20 |
| 2022 | 16 |
| 2023 | 17 |
| 2024 | 18 |
| 2025 | 7 |
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 year(c.\"eventDate\") = 2017
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 year(c."eventDate") = 2017 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 WPR18FA053Accident · 1 fatalField investigationFinal reportBrowning Gregory S Zodiac 601XL · Thompson's Station, TNThe sport pilot's decision to depart in and continue flight in instrument meteorological conditions, which resulted in controlled flight into terrain.NTSB ERA18FA056Accident · 1 fatalField investigationFinal reportBeech G35 · Cross City, FLThe pilot's improper decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in the pilot experiencing spatial disorientation and a subsequent loss of airplane control.NTSB CEN18FA054Accident · 2 fatalField investigationFinal reportPiper PA28 · Reeds Spring, MOThe noninstrument-rated pilot's inadequate pre-flight planning and in-flight decision-making, which resulted in flight into known instrument meteorological conditions and the subsequent collision with terrain.NTSB CEN18FA037Accident · 1 fatalField investigationFinal reportCessna 172G · Pittsford, VTThe pilot's decision to continue visual flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation.NTSB ERA18FA022Accident · 4 fatalField investigationFinal reportPiper PA32 · Fountain Run, KYThe noninstrument-rated pilot's intentional visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing to the accident was the pilot's self-induced pressure to complete…NTSB ANC18FA003Accident · 1 fatalField investigationFinal reportCessna 210 · Russian Mission, AKThe pilot's decision to continue visual flight into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of control.NTSB WPR18FA001Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Klamath Falls, ORThe noninstrument rated pilot's decision to depart on a cross-country flight with en route weather conditions forecasted to be less than visual meteorological conditions and then to continue flight into instrument meteorological conditions, which resulted in…NTSB GAA17CA559Accident · No injuriesData collectionFinal reportCessna 182 · San Diego, CAThe airplane’s inadvertent entry into instrument meteorological, dark night conditions and the pilot’s failure to maintain an adequate approach for landing.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 ANC17FA049Accident · 1 fatalField investigationFinal reportPiper PA-18AS · Tyonek, AKThe noninstrument-rated pilot's decision to initiate a visual flight rules flight into dark night, marginal visual flight rules to instrument flight rules conditions, which resulted in a loss of control due to spatial disorientation.NTSB ERA17FA279Accident · 1 fatalField investigationFinal reportAir Tractor AT502 · Philipp, MSThe pilot's improper decision to attempt a visual flight rules flight in instrument meteorological conditions, below a low overcast ceiling, which resulted in controlled flight into terrain.NTSB CEN17FA288Accident · 2 fatalField investigationFinal reportZenith CH701SP · Laddonia, MOThe pilot's decision to take off at night and continue visual flight into instrument meteorological conditions. which resulted in the pilot becoming spatially disoriented and losing control of the airplane. Contributing to the accident were the pilot's…NTSB ANC17FA039Accident · 1 fatalClass 2 · FieldFinal reportCessna U206 · Port Alsworth, AKThe pilot's decision to continue visual flight into an area of instrument meteorological conditions, which resulted in a loss of visual reference and subsequent controlled flight into terrain. Contributing to the accident was (1) the inadequate preflight…NTSB ERA17FA241Accident · 1 fatalField investigationFinal reportExtra Flugzeugbau EA 300/L · Winchester, NHThe noninstrument-rated pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and collision with terrain. Contributing to the accident was the pilot's self-induced pressure to complete…NTSB GAA17CA388Accident · No injuriesData collectionFinal reportCessna 207 · Hope, AKThe pilot’s inadvertent flight into instrument meteorological conditions and subsequent controlled flight into terrain.NTSB CEN17LA244Accident · 1 fatalLimited investigationFinal reportAir Tractor AT 602 · Stirum, NDThe pilot's decision to attempt flight with low-level fog in the area, which resulted in an encounter with instrument meteorological conditions and impact with terrain.NTSB WPR17LA124Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Carpinteria, CAThe noninstrument-rated pilot's improper decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain.NTSB WPR17FA125Accident · 1 fatalField investigationFinal reportBeech 95 C55 · Mountain Ranch, CAThe pilot's continued visual flight rules flight into instrument meteorological conditions and mountain obscuration that resulted in controlled flight into trees and terrain.NTSB ANC17LA025Accident · Minor injuriesClass 3 · LimitedFinal reportAirbus AS350 · Juneau, AKThe pilot's decision to depart into an area of degraded visual meteorological and flat light conditions, which resulted in a loss of visual references and subsequent controlled flight into terrain.NTSB ERA17FA180Accident · 2 fatalField investigationFinal reportBeech A36TC · Hopkinsville, KYThe noninstrument-rated pilot's intentional visual flight rules flight into instrument meteorological conditions, which resulted in a loss of airplane control due to spatial disorientation. Contributing to the accident were the pilot's overreliance on his…NTSB ANC17FA021Accident · 1 fatalField investigationFinal reportCessna 208B · Chignik Lake, AKThe pilot's continued visual flight rules flight into an area of mountainous terrain and instrument meteorological conditions, which resulted in controlled flight into terrain (CFIT). Contributing to the accident was the company's failure to provide the pilot…NTSB WPR17FA105Accident · 2 fatalField investigationFinal reportSocata TB 20 Trinidad · Sierraville, CAThe pilot's decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into mountainous terrain.NTSB GAA17CA215Accident · Minor injuriesData collectionFinal reportCessna 182 · Blue Earth, MNThe pilot's decision to continue the night, visual flight into instrument meteorological conditions, which resulted in controlled flight into terrain while on final approach. Contributing to the accident was the pilot's improper use of an electronic flight…NTSB ANC17FA018Accident · 1 fatalField investigationFinal reportCessna R172K · Nome, AKThe pilot's improper decision to conduct multiple visual approaches to the destination airport despite the night instrument meteorological conditions; the airplane's low fuel state at that time, which resulted in a total loss of engine power due to fuel…NTSB WPR17FA065Accident · 3 fatalField investigationFinal reportCessna 172 · Panguitch, UTThe pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the accident were the pilot's inadequate preflight weather planning and his poor decision-making.NTSB ERA17LA113Accident · Serious injuriesLimited investigationFinal reportCirrus SR20 · Daytona Beach, FLThe pilot's inadvertent encounter with instrument meteorological conditions (fog) during initial climb, which resulted in a loss of control due to spatial disorientation.NTSB CEN17FA103Accident · 2 fatalField investigationFinal reportBell Helicopter Textron Canada 429 · Shreveport, LAThe pilot's inadvertent encounter with instrument meteorological conditions resulting in spatial disorientation, loss of control, and subsequent impact with terrain.NTSB WPR17FA055Accident · 1 fatalField investigationFinal reportMooney M20J · Lake Hughes, CAThe pilot's controlled flight into mountainous terrain while attempting to operate under visual flight rules in instrument meteorological conditions (IMC).NTSB WPR17FA045Accident · 4 fatalField investigationFinal reportCessna T210K · Payson, AZThe non-instrument-rated pilot's improper decisions to begin and to continue a flight under visual flight rules into instrument meteorological conditions, which resulted in controlled flight into terrain.