NTSB investigations, AK
35 cases where the defining event was Sys/Comp malf/fail (non-power).
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 3 |
| 2010 | 1 |
| 2011 | 4 |
| 2012 | 1 |
| 2013 | 4 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 2 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 2 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 3 |
| 2025 | 3 |
| 2026 | 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '330')
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" = '330') 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 ANC26LA022Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Skwentna, AKThe pilot’s loss of directional control during landing roll due to contact with wind hardened snow berm and subsequent failure of main landing gear.NTSB ANC25LA076Accident · No injuriesClass 4 · LimitedFinal reportCessna 180H · Gulkana, AKThe failure of the left rudder assembly which resulted in a runway excursion and ground loop.NTSB ANC25LA059Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Denali Park, AKThe failure of the left main landing gear spring due to a fatigue fracture during landing on uneven terrain.NTSB ANC25LA030Accident · No injuriesClass 3 · LimitedFinal reportCessna A185F · Skwentna, AKMaintenance personnel’s reuse of worn hardware during the installation of the landing gear assembly and the hardware’s failure and subsequent separation of the gear leg from the landing gear box assembly during taxi.NTSB ANC25LA009Accident · No injuriesClass 3 · LimitedFinal reportCessna 180 · Egegik, AKA failure of the right main landing gear leg for reasons that could not be determined.NTSB ANC24LA048Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-2 · Bethel, AKThe uncertificated pilot’s decision to fly an unairworthy airplane and his failure to maintain directional control during landing, which resulted in a landing gear collapse. Contributing was the failure of the right main landing gear oleo strut.NTSB ANC24LA013Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Glacier View, AKA sudden stoppage of the tail rotor for unknown reasons, which resulted in the tortional overload failure of the tail rotor driveshaft.NTSB ANC23LA052Accident · No injuriesClass 4 · LimitedFinal reportDehavilland DHC-2 · McCarthy, AKA failure of the right brake caliper bolts during landing, which resulted in a runway excursion and subsequent impact with terrain.NTSB ANC22LA080Accident · 1 fatalClass 3 · LimitedFinal reportCessna 180A · Skwentna, AKThe failure of the landing gear float due to inadequate maintenance of the floats and corrosion.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 ANC20LA098Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · King Salmon, AKThe fatigue fracture failure of the left main landing gear U-bolt during landing, which resulted in the collapse and separation of the left main landing gear spring.NTSB ANC20LA013Accident · No injuriesClass 3 · LimitedFinal reportPiper PA31 · Fairbanks, AKThe improper installation of a hydraulic line at the right main landing gear (MLG) unlock actuator, which resulted in a total loss of system hydraulic pressure and failure of the landing gear to extend. Contributing to the accident was the failure of the…NTSB ANC19LA049Accident · No injuriesClass 3 · LimitedFinal reportCessna A185 · Talkeetna, AKA fracture of the right outboard landing gear bracket for undetermined reasons.NTSB ANC18LA048Accident · No injuriesLimited investigationFinal reportCessna 180 · Fairbanks, AKThe failure of the brake line tube due to an improper flare.NTSB DCA18CA056Accident · No injuriesData collectionFinal reportMcdonnell Douglas DC 9 33F · Bethel, AKfailure of a cargo tie-down fastener, resulting in unsecured cargo striking the pressure bulkhead.NTSB ANC17LA005Accident · No injuriesLimited investigationFinal reportCessna A185 · Ninilchik, AKA loss of brake system fluid due to leaks in the o-rings, which resulted in asymmetrical braking and a subsequent loss of directional control during the landing roll.NTSB ANC16LA068Accident · Serious injuriesLimited investigationFinal reportJeffery D Tuttle BDK Carbon Concepts · Wasilla, AKThe structural failure of both wings’ leading-edge slats, which resulted in a loss of airplane control.NTSB ANC15LA023Accident · No injuriesLimited investigationFinal reportCessna 185 · Nome, AKThe failure of the left main landing gear leg for reasons that could not be determined based on the available evidence.NTSB ANC14CA077Accident · No injuriesData collectionFinal reportCessna 185 · Gakona, AKThe pilot's inability to maintain directional control after the airplane's main landing gear tire deflated during takeoff.NTSB ANC13CA075Accident · No injuriesData collectionFinal reportCessna 185D · North Pole, AKThe malfunction of the right main wheel brake during taxi due to a faulty O-ring in the right brake pedal master cylinder.NTSB ANC13CA046Accident · No injuriesData collectionFinal reportCessna U206G · Nenana, AKIce accretion in the right main landing gear wheel brake during departure, which prevented the right main landing gear from rotating on landing and resulted in a runway excursion and subsequent impact with a snow bank.NTSB ANC13LA032Accident · No injuriesLimited investigationFinal reportCessna A185F · Talkeetna, AKThe overstress fracture and failure of the right wheel/ski arm while taxiing in snow and water-overflow terrain conditions, which resulted in a noseover.NTSB ANC13CA020Accident · No injuriesData collectionFinal reportCessna A185E · Skwentna, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a main landing gear collapse.NTSB ANC12IA085Incident · No injuriesIncident investigationFinal reportBellanca 8KCAB · Homer, AKThe failure of the left main landing gear leg due to fatigue. Contributing to the incident was maintenance personnel's failure to completely remove all corrosion before repainting the gear leg.NTSB ANC12CA010Accident · No injuriesData collectionFinal reportCessna A185F · Talkeetna, AKA broken wheel/ski clevis pin, which allowed the ski to pivot upward and strike the right wing lift strut.NTSB ANC12TA008Accident · No injuriesFinal reportBellanca 8GCBC · Delta Junction, AKIce accretion in the main landing gear wheel brakes, which prevented the main landing gear wheels from rotating on landing, which resulted in the airplane nosing over.NTSB ANC11CA095Accident · No injuriesData collectionFinal reportCessna 170A · Anchorage, AKThe fracture of a hydraulic brake line fitting due to incorrect installation of the brake line by the pilot/owner, which resulted in a loss of brake pressure and subsequent loss of directional control during the landing roll.NTSB ANC11CA072Accident · No injuriesData collectionFinal reportAeronca 7AC · McCarthy, AKThe separation of the right main landing gear oleo strut assembly, resulting in the collapse of the main landing gear during the landing roll.NTSB ANC10LA101Accident · No injuriesLimited investigationFinal reportCessna 150F · North Pole, AKThe overstress separation of the left nose wheel steering linkage rod end during the takeoff roll, which resulted in a loss of control.NTSB ANC09LA100Accident · No injuriesLimited investigationFinal reportGrumman G-44A · Anchorage, AKA fatigue fracture of an unapproved hydraulic brake line fitting, which resulted in a loss of control during the landing roll. Contributing to the accident was the installation of an unapproved part by an unknown maintenance personnel.NTSB ANC09LA088Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe pilot’s decision to make an abrupt and steep low altitude turn just after takeoff, while attempting to return to his departure airport, resulting in an aerodynamic stall and loss of aircraft control. Contributing to the accident was the pilot’s failure to…NTSB ANC09GA040Accident · No injuriesFinal reportRobinson Helicopter R44 · Iliamna, AKThe main rotor transmission mount design, which resulted in an in-flight vibration/oscillation, and damage to the helicopter during an emergency descent and hard landing. Contributing to the accident was the lack of information from the manufacturer regarding…NTSB ANC08CA065Accident · No injuriesData collectionFinal reportde Havilland DHC-3 · Talkeetna, AKThe pilot's selection of an unsuitable landing site, which resulted in an overload failure of the tail ski assembly during the landing roll.NTSB ANC08LA055Accident · No injuriesLimited investigationFinal reportCessna 180 · Kodiak, AKA loss of control during the landing roll due to a failure or malfunction of the brake system, resulting in a loss of control, and structural damage to the airplane.NTSB ANC08MA038Accident · 6 fatalMajor investigationFinal reportPiper PA-31-350 · Kodiak, AKThe failure of company maintenance personnel to ensure that the airplane's nose baggage door latching mechanism was properly configured and maintained, resulting in an inadvertent opening of the nose baggage door in flight. Contributing to the accident were…