NTSB investigations, AK
23 cases where the defining event was VFR encounter with IMC.
Cases per year
| 2008 | 1 |
|---|---|
| 2010 | 2 |
| 2011 | 3 |
| 2012 | 1 |
| 2013 | 2 |
| 2015 | 1 |
| 2016 | 3 |
| 2017 | 4 |
| 2018 | 1 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 3 |
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\" = 'AK' 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\" = '401')
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" = 'AK' 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" = '401') 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 ANC24FA089Accident · 1 fatalClass 3 · FieldFinal reportBell 206B · King Salmon, AKThe pilot’s decision to initiate the visual flight into instrument meteorological conditions, which resulted in his spatial disorientation, failure to maintain helicopter control and subsequent impact with water.NTSB ANC24LA069Accident · 3 fatalClass 3 · LimitedFinal reportBeech A35 · Gustavus, AKThe pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain.NTSB ANC24FA032Accident · 2 fatalClass 3 · FieldFinal reportTaylorcraft BC12-D · Nondalton, AKThe non-certificated pilot’s continued visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into the water.NTSB ANC23LA032Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Skwentna, AKThe pilot's failure to maintain adequate altitude/clearance from terrain while maneuvering in adverse weather conditions, which resulted in a dynamic rollover.NTSB ANC23LA002Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA-32-260 · Cordova, AKThe pilot’s improper decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain.NTSB ANC18LA031Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Atqasuk, AKThe pilot's decision to continue a visual flight rules flight into an area of instrument meteorological conditions and his subsequent failure to level the airplane after the autopilot disconnected, which resulted in a collision with terrain.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 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 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 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 ANC17MA001Accident · 3 fatalClass 1 · MajorFinal reportCessna 208B · Togiak, AKThe flight crew's decision to continue the visual flight rules flight into deteriorating visibility and their failure to perform an immediate escape maneuver after entry into instrument meteorological conditions, which resulted in controlled flight into…NTSB ANC16LA060Accident · Serious injuriesLimited investigationFinal reportPiper PA 18-150 · Salcha, AKThe pilot's decision to continue visual flight into instrument meteorological conditions, which resulted in an in-flight collision with terrain.NTSB ANC16FA023Accident · 1 fatalField investigationFinal reportAirbus AS350 · Skagway, AKThe pilot's decision to continue visual flight into an area of instrument meteorological conditions, which resulted in the pilot experiencing a loss of visual reference and subsequent controlled flight into terrain. Contributing to the accident were the…NTSB GAA16LA031Accident · No injuriesLimited investigationFinal reportAirbus AS350 · Deadhorse, AKThe noninstrument-rated pilot's continued visual flight into adverse weather conditions, which resulted in spatial disorientation, and his subsequent failure to maintain terrain clearance while attempting to land in flat light and whiteout conditions.NTSB ANC14LA007Accident · No injuriesLimited investigationFinal reportBeech 1900C · Deadhorse, AKThe captain’s decision to initiate a visual flight rules approach and attempted landing into an area of instrument meteorological conditions, which resulted in the airplane touching down short of the runway. Contributing to the accident was the operator’s…NTSB ANC13LA100Accident · Serious injuriesLimited investigationFinal reportCessna U206F · Kotzebue, AKThe pilot’s improper decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain.NTSB ANC12FA066Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Fairbanks, AKThe noninstrument-rated pilot's decision to continue visual flight into instrument meteorological conditions likely leading to spatial disorientation, which resulted in a loss of airplane control and in-flight structural failure.NTSB ANC12CA016Accident · Minor injuriesData collectionFinal reportCessna 207A · Kwigillingok, AKThe pilot’s decision to continue visual flight into instrument meteorological conditions with moderate icing, which resulted in structural icing and an aerodynamic stall.NTSB ANC12FA009Accident · 1 fatalField investigationFinal reportCessna 207 · Chuathbaluk, AKThe pilot’s loss of situational awareness after an inadvertent encounter with instrument meteorological conditions, which resulted in an in-flight collision with tree-covered terrain.NTSB ANC11FA077Accident · 2 fatalField investigationFinal reportCessna 207 · McGrath, AKThe pilot's decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in an in-flight collision with mountainous terrain.NTSB ANC10FA069Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · McGrath, AKThe pilot’s continued visual flight into instrument meteorological conditions and the airplane’s subsequent aerodynamic stall, which resulted in an in-flight collision with mountainous terrain.NTSB ANC10CA027Accident · No injuriesData collectionFinal reportCessna 182B · Port Alsworth, AKThe pilot's decision to enter adverse weather conditions, resulting in a loss of visibility and collision with terrain during a turn to reverse direction.NTSB ANC08FA133Accident · 2 fatalField investigationFinal reportCessna 182 · Juneau, AKThe pilot's decision to continue visual flight into an area of instrument meteorological conditions, which resulted in the pilot experiencing a loss of visual reference and subsequent controlled flight into terrain. Contributing to the accident was the…