NTSB investigations, AK
19 cases where NTSB found Turbulence.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 3 |
| 2010 | 2 |
| 2011 | 4 |
| 2012 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2024 | 1 |
Where
Latest 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '030320'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '030320')) 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 ANC24LA093Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 180B · Anchorage, AKThe pilot’s encounter with wake turbulence, which resulted in substantial damage to the airplane.NTSB CEN22LA380Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · McCarthy, AKThe pilot’s failure to maintain control of the airplane during takeoff in turbulent weather conditions.NTSB ANC21LA043Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182K · Cordova, AKAn encounter with mountain wave turbulence and windshear that exceeded the climb capability of the airplane and resulted in impact with terrain.NTSB DCA21LA018Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 777 · Anchorage, AKThe airplane’s encounter with severe turbulence while flying over a mountain range during cruise.NTSB ANC19TA014Accident · Serious injuriesClass 3Final reportPiper PA32R · Anchorage, AKThe pilot’s failure to ensure that the passenger’s lap belt was appropriately fastened for the forecast turbulent conditions, and the passenger’s failure to tighten her lap belt appropriately, which resulted in the passenger’s serious injury during an…NTSB ANC18LA072Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Anchorage, AKThe pilot's failure to avoid wake turbulence from a crossing heavy airplane.NTSB ANC15CA051Accident · No injuriesData collectionFinal reportCessna 140 · Homer, AKThe pilot's decision to fly at a low altitude in mountainous terrain and weather conditions conducive to downdrafts.NTSB ANC14CA027Accident · No injuriesData collectionFinal reportTaylorcraft BC12 D · Wasilla, AKThe pilot's inadequate weather evaluation, which resulted in a turbulence encounter at low altitude and collision with trees. Contributing to the accident was the pilot's lack of knowledge of local wind conditions.NTSB DCA12CA033Accident · Serious injuriesData collectionFinal reportAntonov AN124 · Anchorage, AKan inadvertent encounter with Clear Air Turbulence that resulted in serious injuries to two crewmembers.NTSB ANC12FA014Accident · Minor injuriesField investigationFinal reportCessna U206G · Nanwalek, AKThe pilot’s decision to takeoff from a contaminated runway with unfavorable wind conditions, and his failure to maintain airspeed during the initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the operator’s inadequate…NTSB ANC11CA058Accident · Serious injuriesData collectionFinal reportAviat A-1B · Palmer, AKThe pilot's decision to fly at a low altitude in mountainous terrain and weather conditions conducive to downdrafts.NTSB ANC11CA036Accident · No injuriesData collectionFinal reportPiper J5A · Palmer, AKThe pilot's inadequate compensation for wind conditions.NTSB ANC11LA027Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Cold Bay, AKAn in-flight encounter with unforecast turbulence, which resulted in structural damage to the stabilator.NTSB ANC10CA096Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Chicken, AKThe pilot's decision to fly at a low altitude in terrain and weather conditions conducive to turbulence and downdrafts.NTSB DCA10CA032Accident · Serious injuriesData collectionFinal reportBoeing 747 · Anchorage, AKan inadvertent encounter with clear air turbulence.NTSB ANC10LA006Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Kenai, AKThe pilot's decision to fly at a low altitude in strong winds and turbulence, resulting in a loss of control and a collision with terrain.NTSB ANC10FA004Accident · 1 fatalField investigationFinal reportCessna A185E · Healy, AKThe pilot's decision to maneuver at a low altitude over rising terrain in conditions conducive to turbulence/downdrafts, resulting in a loss of control and impact with terrain.NTSB ANC09CA111Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Homer, AKThe pilot's excessive airspeed during approach to compensate for turbulence, resulting in a hard landing and runway overrun.NTSB ANC08LA039Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Nikolai, AKThe flight instructor's inadequate evaluation of the weather conditions. Contributing to the accident was an inadvertent stall/mush.