NTSB investigations, AK
76 cases where the sequence of events included Attempted remediation/recovery.
Cases per year
| 2009 | 1 |
|---|---|
| 2010 | 3 |
| 2011 | 1 |
| 2012 | 1 |
| 2014 | 2 |
| 2015 | 3 |
| 2016 | 7 |
| 2017 | 13 |
| 2018 | 11 |
| 2019 | 9 |
| 2020 | 7 |
| 2021 | 6 |
| 2022 | 3 |
| 2023 | 4 |
| 2024 | 4 |
| 2025 | 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\" = 'AK' 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\" = '060' 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" = 'AK' 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" = '060' 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 ANC25LA071Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Willow, AKThe flight instructor’s delayed remedial action/lack of supervision. Contributing to the accident was the pilot receiving instructions failure to maintain directional control during the landing roll in gusting wind conditions, which resulted in a ground loop.NTSB ANC24LA088Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Coal Creek, AKThe pilot's failure to maintain directional control during the landing roll with a quartering tailwind.NTSB ANC24LA075Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Fairbanks, AKThe pilot's failure to maintain directional control while landing at a short remote airstrip.NTSB ANC24LA072Accident · No injuriesClass 4 · LimitedFinal reportPiper PA18 · Goose Bay, AKThe pilot's failure to maintain directional control during the landing roll.NTSB ANC24LA014Accident · No injuriesClass 4 · LimitedFinal reportBenjamin Pratt Bearhawk Patrol · Galena, AKA loss of engine power as a result of carburetor ice. Contributing to the outcome was the pilot’s failure to effectively use carburetor heat in conditions conducive to the formation of carburetor ice.NTSB ANC23LA072Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Palmer, AKThe pilot’s failure to maintain directional control during the landing rollout.NTSB ANC23LA057Accident · No injuriesClass 4 · LimitedFinal reportDehavilland DHC-2 MK. I(L20A) · Point Baker, AKThe pilot’s failure to maintain directional control during takeoff with a quartering tailwind.NTSB ANC23LA039Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Fairbanks, AKThe pilot’s failure to maintain directional control during landing with a quartering tailwind, which resulted in a water loop and impact with terrain.NTSB ANC23LA021Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-260 · Tok, AKThe pilot's failure to maintain a proper approach glide path, which resulted in a hard landing, short of his anticipated touchdown point.NTSB ANC23LA016Accident · No injuriesClass 4 · LimitedFinal reportChampion 7GCBC · Anchorage, AKThe pilot's loss of directional control during takeoff.NTSB ANC23LA014Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Anchorage, AKThe pilot’s failure to maintain directional control of the airplane during landing.NTSB WPR22LA326Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Egegik, AKThe pilot's failure to maintain directional control during takeoff from a lake.NTSB ANC22LA006Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters CC-18-180 · Yukon Charlie River, AKThe pilot’s selection of an unsuitable landing site, which resulted in a nose-over.NTSB ANC21LA092Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Homer, AKThe pilot’s failure to maintain directional control while landing in crosswind conditions.NTSB ANC21LA088Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Talkeetna, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in a loss of directional control and nose over.NTSB ANC21LA085Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Tyonek, AKThe pilot’s selection of inappropriate terrain and decision to land with a tailwind, which resulted in a loss of directional control, an attempted go-around, and subsequent impact with terrain.NTSB ANC21FA028Accident · Minor injuriesClass 3 · FieldFinal reportPiper PA-18A · Anchorage, AKA total loss of engine power for reasons that could not be determined based on the available evidence.NTSB ANC21LA022Accident · No injuriesClass 3 · LimitedFinal reportCessna A185F · Skwentna, AKInstallation of improper hardware on the ski check cable. Contributing to the accident was the inadequate inspection of the ski yokes, which resulted in the subsequent failure of the right main landing gear ski yoke and collapse of the right main landing gear…NTSB ANC20CA088Accident · No injuriesClass 4 · Data collectionFinal reportCessna 180 · Kotzebue, AKThe pilot's failure to maintain an airspeed conducive to flight during takeoff.NTSB ANC20CA071Accident · No injuriesClass 4 · Data collectionFinal reportCessna A185 · Palmer, AKThe pilot's loss of control during landing, which resulted in a ground loop and left main landing gear collapse.NTSB ANC20LA064Accident · No injuriesClass 3 · LimitedFinal reportPiper PA22 · Soldotna, AKThe delamination of the fabric material from the fuselage above the windscreen due to failed adhesive, which resulted in disrupted airflow and a subsequent hard landing.NTSB ANC20CA057Accident · No injuriesClass 4 · Data collectionFinal reportChampion 7GCBC · Palmer, AKThe pilot's loss of directional control during landing, which resulted in a runway excursion.NTSB ANC20CA042Accident · No injuriesData collectionFinal reportPiper PA18 · Homer, AKThe pilot's overapplication of the brakes during landing and the subsequent loss of directional control and nose-over.NTSB ANC20CA039Accident · No injuriesData collectionFinal reportWag-Aero Sportsman 2+2 · Wasilla, AKThe pilot's loss of directional control during takeoff from an icy ski strip in gusting wind conditions, which resulted in the left wing impacting a tree.NTSB ANC20CA030Accident · No injuriesData collectionFinal reportPiper PA18 · Big Lake, AKThe pilot's failure to use carburetor heat in conditions conducive to carburetor icing, which resulted in a partial loss of engine power, a precautionary landing, and impact with snow.NTSB ANC20CA037Accident · No injuriesData collectionFinal reportCessna 207 · Kwigillingok, AKThe pilot's improper decision to depart from an ice-covered runway with a strong crosswind, which resulted in a loss of directional control, runway excursion, and impact with a ditch.NTSB ANC20LA002Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Palmer, AKThe pilot's delayed application of carburetor heat in weather conditions conducive to carburetor icing, which resulted in a partial loss of engine power, a precautionary landing, and impact with terrain.NTSB GAA19CA521Accident · No injuriesData collectionFinal reportPiper PA18 · Beluga, AKThe pilot's failure to maintain an adequate climb rate during takeoff in gusting wind conditions, which resulted in an uncontrolled descent.NTSB ANC19CA057Accident · Minor injuriesData collectionFinal reportPiper PA22 · Arctic Village, AKThe pilot's failure to maintain adequate airspeed while maneuvering to avoid mountainous terrain, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall.NTSB GAA19CA515Accident · No injuriesData collectionFinal reportPiper PA18 · Kenai, AKThe pilot's improper landing flare, which resulted in a hard landing and the subsequent loss of directional control and impact with a tree.NTSB GAA19CA507Accident · No injuriesData collectionFinal reportMaule M5 · Anchorage, AKThe pilot's excessive braking during landing on a dry lakebed, which resulted in a nose-over.NTSB GAA19CA364Accident · No injuriesData collectionFinal reportCessna 170 · Hewitt Lake, AKThe pilot's failure to maintain directional control during takeoff from a soft, grass airstrip, which resulted in impact with brush.NTSB ANC19LA015Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Talkeetna, AKA loss of pitch control for an undetermined reason, which resulted in a collision with terrain during an emergency landing.NTSB GAA19CA114Accident · No injuriesData collectionFinal reportPiper PA22 · Anchorage, AKThe student pilot's overcorrection with rudder during the landing and her subsequent failure to maintain directional control, which resulted in a runway excursion, impact with a snowbank, and a nose-over.NTSB ANC19CA003Accident · No injuriesData collectionFinal reportCessna 207 · Anchorage, AKThe pilot's inadequate in-flight fuel management, which resulted in fuel starvation and the subsequent loss of engine power, and her subsequent failure to maintain clearance from trees during the approach to land at a nearby airstrip.NTSB ANC19CA002Accident · No injuriesData collectionFinal reportBeech 1900 · Gambell, AKThe pilot’s unstabilized approach and improper landing flare, which resulted in a hard landing.NTSB CEN18FA391Accident · 3 fatalField investigationFinal reportAirbus Helicopters AS350 · Gustavus, AKThe pilot's failure to maintain main rotor speed after setting the engine fuel control to idle, which resulted in a loss of helicopter control and impact with water.NTSB GAA18CA565Accident · Minor injuriesData collectionFinal reportDe Havilland DHC 2 · Igiugig, AKThe pilot’s selection of an empty fuel tank for takeoff, which resulted in fuel starvation and the subsequent total loss of engine power.NTSB GAA18CA370Accident · No injuriesData collectionFinal reportCessna 170 · Anchorage, AKThe pilot’s failure to maintain directional control during landing.NTSB GAA18CA367Accident · No injuriesData collectionFinal reportPiper PA 18 · Wasilla, AKThe pilot’s failure to maintain directional control during landing in gusting tailwind conditions.NTSB GAA18CA351Accident · No injuriesData collectionFinal reportCessna 185 · Big Lake, AKThe pilot’s inability to maintain directional control during the landing roll due to a flat tire.NTSB GAA18CA320Accident · No injuriesData collectionFinal reportPiper PA 12 · Nulato, AKThe pilot’s improper landing flare, which resulted in a hard landing on upsloping terrain, and his subsequent failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during an attempted go-around, which resulted in…NTSB GAA18CA196Accident · No injuriesData collectionFinal reportCub Crafters CC19 · Seldovia, AKThe pilot’s failure to maintain directional control during landing. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB ANC18LA030Accident · No injuriesLimited investigationFinal reportChampion 7GC · Anchorage, AKThe pilot's failure to maintain directional control during landing with a crosswind, which resulted in a loss of control and failure of the main landing gear. Contributing to the accident was the pilot's self-induced pressure to land.NTSB GAA18CA147Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Talkeetna, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in a dynamic rollover.NTSB GAA17CA527Accident · No injuriesData collectionFinal reportPiper PA 12 · Kotzebue, AKThe pilot’s failure to maintain directional control while landing on an unimproved airstrip in gusting wind conditions.NTSB ANC17LA046Accident · No injuriesLimited investigationFinal reportThrush S2R · Talkeetna, AKThe pilot's improper landing in the tailwheel-equipped airplane, which allowed an excessive load on the tailwheel and resulted in the subsequent component fracture, loss of control, runway excursion, and impact with terrain.NTSB GAA17CA440Accident · No injuriesData collectionFinal reportMitchell Derryle V Rans S 7 Courier · Cordova, AKThe pilot’s improper decision to take off from a lake in gusting wind conditions, which resulted in a loss of airplane control.NTSB GAA17CA387Accident · No injuriesData collectionFinal reportPiper PA 12 · Chickaloon, AKThe pilot’s improper landing flare on a turf runway, which necessitated a go-around during which he failed to establish a climb.NTSB ANC17CA044Accident · No injuriesData collectionFinal reportBrantly B2 · St. Michael, AKThe pilot’s inadequate supervision of the refueling process, which resulted in a loss of engine power due to water contamination in the helicopter’s fuel system from the fuel drum and subsequent impact with terrain.