# NTSB investigations, AK: Enroute NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports. Page 1 of 34 · 1,669 cases ## Latest cases - [NTSB ANC26FA105](https://openairdocs.org/ntsb/ANC26FA105.md): Cessna A185F · Stony River, AK · Accident · 2 fatal · Class 3 · Field · Preliminary report · Sep 15, 2026 · N4358Q · Substantial damage > On September 15, 2026 about 1210 Alaska daylight time, a Cessna A185F airplane, N4358Q, was substantially damaged when it was involved in an accident near Stony River, Alaska. The pilot and passenger were fatally injured. The airplane was operated as a Title… - [NTSB ANC26LA089](https://openairdocs.org/ntsb/ANC26LA089.md): Cessna 180J · Bettles, AK · Accident · Minor injuries · Class 4 · Limited · Investigation open · Aug 19, 2026 · N9949N · Substantial damage - [NTSB ANC26LA069](https://openairdocs.org/ntsb/ANC26LA069.md): Piper PA-18-150 · Mekoryuk, AK · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 7, 2026 · N824JT · Substantial damage > On July 7, 2026 about 1430 Alaska daylight time, a Piper PA-18-150 airplane, N824JT, was substantially damaged when it was involved in an accident near Mekoryuk, Alaska. The pilot and one passenger were not injured. The airplane was operated as a Title 14… - [NTSB ANC26LA062](https://openairdocs.org/ntsb/ANC26LA062.md): Textron 208B · Wiseman, AK · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jun 22, 2026 · N94AW · Substantial damage > On June 22, 2026, about 1043 Alaska standard time, a turbine-powered Cessna 208B airplane N94AW, was substantially damaged when it was involved in an accident near Wiseman, Alaska. The nine passengers were uninjured, the pilot sustained minor injuries. The… - [NTSB ANC26FA057](https://openairdocs.org/ntsb/ANC26FA057.md): Piper PA20 · Cordova, AK · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jun 18, 2026 · N7635K · Destroyed > On June 18, 2026, at approximately 1200, an experimental Piper PA-20 airplane, N7635K, was destroyed when it was involved in an accident about 44 miles southeast of Cordova, Alaska. The pilot was fatally injured. The airplane was operated as a Title 14 Code… - [NTSB ANC26LA038](https://openairdocs.org/ntsb/ANC26LA038.md): Textron B300C · Salcha, AK · Accident · No injuries · Class 4 · Limited · Final report · May 5, 2026 · N67RF · Substantial damage > An in-flight collision with a bird during cruise flight. - [NTSB ANC26LA026](https://openairdocs.org/ntsb/ANC26LA026.md): Cessna U206F · Juneau, AK · Accident · Minor injuries · Class 4 · Limited · Final report · Apr 16, 2026 · N93021 · Substantial damage > A total loss of engine power for reasons that could not be determined because the airplane was not recovered from the ocean. - [NTSB ANC26LA006](https://openairdocs.org/ntsb/ANC26LA006.md): Piper PA-14 · Talkeetna, AK · Accident · No injuries · Class 3 · Limited · Preliminary report · Nov 8, 2025 · N5188H · Substantial damage > On November 8, 2025 about 1300 Alaska standard time, a Piper PA-14 airplane, N5188H, was substantially damaged when it was involved in an accident near Talkeetna, Alaska. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB ANC26LA001](https://openairdocs.org/ntsb/ANC26LA001.md): Cessna 172N · Petersburg, AK · Accident · No injuries · Class 3 · Limited · Preliminary report · Oct 7, 2025 · N80628 · Substantial damage > On October 7, 2025, at 1456 Alaska daylight time, a Cessna 172 airplane, N80628, was substantially damaged when it was involved in an accident near Petersburg, Alaska. The student pilot and flight instructor were not injured. The airplane was operated as a… - [NTSB ANC25LA091](https://openairdocs.org/ntsb/ANC25LA091.md): Vu Holdings LLC/DBA Vanilla UN VA 001 · Ninilchik, AK · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 20, 2025 · N246VU · Substantial damage > On August 20, 2025, at about 0632 Alaska daylight time, a Platform Aerospace VA 001 Unmanned Aerial System (UAS), N246VU, was substantially damaged when it was involved in an accident on a beachside cliff near Ninilchik, Alaska. The aircraft was unmanned. The… - [NTSB ANC25LA060](https://openairdocs.org/ntsb/ANC25LA060.md): Piper PA-22-150 · Chinitna Bay, AK · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 1, 2025 · N3609Z · Substantial damage > On June 30, 2025, about 1630 Alaska daylight time, a Piper PA 22-150 airplane, N3609Z, was substantially damaged when it was involved in an accident near Chinitna Bay, Alaska. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB ANC25FA044](https://openairdocs.org/ntsb/ANC25FA044.md): Robinson Helicopter R66 · Kaparuk, AK · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jun 4, 2025 · N962MD · Substantial damage > On June 4, 2025 about 1055 Alaska daylight time, a Robinson R66 turbine-powered helicopter, N962MD, was substantially damaged when it was involved in an accident near Kaparuk, Alaska. The pilot and passenger were fatally injured. The helicopter was operated… - [NTSB ANC25LA036](https://openairdocs.org/ntsb/ANC25LA036.md): Stinson 108 · North Pole, AK · Accident · Minor injuries · Class 4 · Limited · Final report · Apr 25, 2025 · N9308K · Substantial damage > The pilot's failure to maintain obstacle clearance which resulted in an in-flight collision with a tree. Contributing to the accident was his impairment from the effects of alcohol consumption. - [NTSB ANC25LA026](https://openairdocs.org/ntsb/ANC25LA026.md): Aeronca 7CCM · Kenai, AK · Accident · No injuries · Class 3 · Limited · Final report · Mar 20, 2025 · N2527B · Substantial damage > A total loss of engine power due to carburetor icing as a result of the pilot’s inadequate use of carburetor heat. - [NTSB ANC25LA027](https://openairdocs.org/ntsb/ANC25LA027.md): Pilatus PC-12/45 · Sleetmute, AK · Accident · No injuries · Class 3 · Limited · Preliminary report · Mar 8, 2025 · N304PT · Substantial damage > On March 7, 2025, about 1740 Alaska standard time, a Pilatus PC-12 airplane, N304PT, sustained substantial damage when it was involved in an accident near Sleetmute, Alaska. The pilot and nine passengers were not injured. The airplane was operated as a Title… - [NTSB ANC25LA022](https://openairdocs.org/ntsb/ANC25LA022.md): Piper PA-18-150 · Anchor Point, AK · Accident · Minor injuries · Class 4 · Limited · Final report · Feb 28, 2025 · N3798Z · Substantial damage > A complete loss of engine power as a result of carburetor ice due to the pilot’s failure to effectively use carburetor heat in conditions conducive to the formation of carburetor ice. - [NTSB ANC25MA018](https://openairdocs.org/ntsb/ANC25MA018.md): Textron 208B · Nome, AK · Accident · 10 fatal · Class 1 · Major · Final report · Feb 6, 2025 · N321BA · Destroyed > The National Transportation Safety Board determines that the probable cause of this accident was the pilot’s inadequate airspeed management due to workload and degraded situation awareness and his improper inputs leading up to and during the aerodynamic… - [NTSB DCA25LA061](https://openairdocs.org/ntsb/DCA25LA061.md): Lockheed 382G-44K-30 · St. Mary's, AK · Accident · No injuries · Class 3 · Limited · Final report · Dec 18, 2024 · N403LC · Substantial damage > The fatigue failure of the forward pressure bulkhead canted web that originated from stress corrosion cracking areas. Contributing to the failure were inspection procedures and intervals inadequate to identify the fatigue cracks. - [NTSB ANC24LA097](https://openairdocs.org/ntsb/ANC24LA097.md): Stinson 108-3 · Lime Village, AK · Accident · No injuries · Class 4 · Limited · Final report · Sep 14, 2024 · N691E · Substantial damage > The pilot's inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent forced landing in tree-covered terrain. - [NTSB ANC24LA093](https://openairdocs.org/ntsb/ANC24LA093.md): Cessna 180B · Anchorage, AK · Accident · Minor injuries · Class 4 · Limited · Final report · Sep 14, 2024 · N5275E · Substantial damage > The pilot’s encounter with wake turbulence, which resulted in substantial damage to the airplane. - [NTSB ANC24FA089](https://openairdocs.org/ntsb/ANC24FA089.md): Bell 206B · King Salmon, AK · Accident · 1 fatal · Class 3 · Field · Final report · Sep 7, 2024 · N306FW · Substantial damage > The 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 ANC24LA069](https://openairdocs.org/ntsb/ANC24LA069.md): Beech A35 · Gustavus, AK · Accident · 3 fatal · Class 3 · Limited · Final report · Jul 20, 2024 · N410B · Destroyed > The pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain. - [NTSB ANC24LA064](https://openairdocs.org/ntsb/ANC24LA064.md): Dehavilland DHC-2T · Petersville, AK · Accident · No injuries · Class 3 · Limited · Final report · Jul 13, 2024 · N535KT · Substantial damage > An in-flight loss of thrust due to an uncommanded feathering of the propeller for reasons that could not be determined. - [NTSB ANC24FA032](https://openairdocs.org/ntsb/ANC24FA032.md): Taylorcraft BC12-D · Nondalton, AK · Accident · 2 fatal · Class 3 · Field · Final report · May 17, 2024 · N95744 · Substantial damage > The non-certificated pilot’s continued visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into the water. - [NTSB ANC24FA029](https://openairdocs.org/ntsb/ANC24FA029.md): Douglas C54D · Fairbanks, AK · Accident · 2 fatal · Class 3 · Field · Final report · Apr 23, 2024 · N3054V · Destroyed > A loss of power of the No. 1 engine for reasons that could not be determined, and the incorrect installation of a B-nut fitting in the propeller feathering system, which allowed engine oil to spray onto the exhaust system when the propeller was feathered… - [NTSB ANC24LA014](https://openairdocs.org/ntsb/ANC24LA014.md): Benjamin Pratt Bearhawk Patrol · Galena, AK · Accident · No injuries · Class 4 · Limited · Final report · Feb 19, 2024 · N406AK · Substantial damage > A 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 ANC24LA013](https://openairdocs.org/ntsb/ANC24LA013.md): Robinson Helicopter R44 II · Glacier View, AK · Accident · No injuries · Class 3 · Limited · Final report · Feb 11, 2024 · N74868 · Substantial damage > A sudden stoppage of the tail rotor for unknown reasons, which resulted in the tortional overload failure of the tail rotor driveshaft. - [NTSB ANC24FA008](https://openairdocs.org/ntsb/ANC24FA008.md): Piper PA-18-150 · Anchor Point, AK · Accident · 2 fatal · Class 3 · Field · Final report · Dec 8, 2023 · N1880P · Destroyed > An impact to the left wing, at an undetermined time, for reasons that could not be determined, which partially separated the left wing and rendered the airplane uncontrollable. - [NTSB ANC23LA078](https://openairdocs.org/ntsb/ANC23LA078.md): Rhodes Steven D SR3500 · Nenana, AK · Accident · No injuries · Class 3 · Limited · Final report · Sep 17, 2023 · N907W · Substantial damage > A total loss of engine power due to fuel starvation. Contributing was the owner/builder’s inadequate maintenance. - [NTSB ANC23LA071](https://openairdocs.org/ntsb/ANC23LA071.md): Bell Helicopter Textron Canada 206L-4 · King Salmon, AK · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 5, 2023 · N193AL · 2 aircraft · Substantial damage > The failure of both pilots to see and avoid while en route, which resulted in a midair collision. - [NTSB ANC23LA065](https://openairdocs.org/ntsb/ANC23LA065.md): Beech B36TC · Cape Yakataga, AK · Accident · 2 fatal · Class 3 · Limited · Final report · Aug 27, 2023 · N6709Q · Destroyed > The pilot’s continued flight into moderate to severe icing conditions, including supercooled large droplets, over mountainous terrain, which resulted in a loss of control and impact with terrain. Contributing to the accident was the National Weather Service… - [NTSB ANC23LA070](https://openairdocs.org/ntsb/ANC23LA070.md): Oliver Robert K Oliver Series 6 · Big Delta, AK · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 25, 2023 · N151RF · Substantial damage > A partial loss of engine power for undetermined reasons. - [NTSB ANC23LA060](https://openairdocs.org/ntsb/ANC23LA060.md): Piper PA-12S · Igiugig, AK · Accident · No injuries · Class 3 · Limited · Final report · Aug 5, 2023 · N2262G · Substantial damage > The pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel exhaustion. - [NTSB ANC23FA056](https://openairdocs.org/ntsb/ANC23FA056.md): Bell 206-L4 · Wainwright, AK · Accident · 4 fatal · Class 3 · Field · Final report · Jul 20, 2023 · N311MH · Destroyed > The pilot's decision to fly at a low altitude over a large body of water toward featureless terrain, which resulted in a loss of visual clues and controlled flight into terrain. - [NTSB ANC23LA053](https://openairdocs.org/ntsb/ANC23LA053.md): Aeronca 7DC · Ninilchik, AK · Accident · No injuries · Class 3 · Limited · Final report · Jul 13, 2023 · N83391 · Substantial damage > A total loss of engine power due to a shift of a crankshaft main bearing, which resulted in a lack of lubrication and subsequent overheating and failure of the engine crankshaft. - [NTSB ANC23LA051](https://openairdocs.org/ntsb/ANC23LA051.md): Stinson 108 · Ninilchik, AK · Accident · No injuries · Class 3 · Limited · Final report · Jul 13, 2023 · N97719 · Substantial damage > A partial loss of engine power due to failure of the No. 1 cylinder intake valve head. - [NTSB ANC23LA013](https://openairdocs.org/ntsb/ANC23LA013.md): Taylorcraft BL-65 · Wasilla, AK · Accident · No injuries · Class 3 · Limited · Final report · Jan 14, 2023 · N29886 · Substantial damage > The pilot's failure to remove all water from the fuel tank, which resulted in fuel contamination and a subsequent partial loss of engine power. - [NTSB ANC23LA006](https://openairdocs.org/ntsb/ANC23LA006.md): Cessna 207 · Bethel, AK · Accident · No injuries · Class 3 · Limited · Final report · Nov 20, 2022 · N23CF · Substantial damage > The total loss of engine power during cruise flight due to fuel starvation and the pilot’s mismanagement of the available fuel. - [NTSB ANC23FA004](https://openairdocs.org/ntsb/ANC23FA004.md): Piper PA-18 · Chickaloon, AK · Accident · 1 fatal · Class 3 · Field · Final report · Nov 10, 2022 · N7123K · Substantial damage > The pilot's decision to fly at low altitude, which resulted in a collision with a cable. - [NTSB ANC23LA002](https://openairdocs.org/ntsb/ANC23LA002.md): Piper PA-32-260 · Cordova, AK · Accident · 1 fatal · Class 3 · Limited · Final report · Oct 16, 2022 · N3432W · Substantial damage > The pilot’s improper decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain. - [NTSB ERA22LA410](https://openairdocs.org/ntsb/ERA22LA410.md): Cessna U206 · Buckland, AK · Accident · No injuries · Class 3 · Limited · Final report · Sep 9, 2022 · N8019Z · Substantial damage > The installation of incompatible rocker arms and rocker arm bushings during an engine overhaul, which resulted in a complete loss of engine power. - [NTSB ANC22LA068](https://openairdocs.org/ntsb/ANC22LA068.md): Cessna 180 · Sutton-Alpine, AK · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 12, 2022 · N6577A · Substantial damage > A total loss of engine power due to fuel exhaustion. - [NTSB ERA22LA358](https://openairdocs.org/ntsb/ERA22LA358.md): Cessna 207 · Dillingham, AK · Accident · No injuries · Class 3 · Limited · Final report · Jul 28, 2022 · N6908M · Substantial damage > Maintenance personnel’s failure to detect and correct improper rudder control system alignment, the resulting interference with the pulley’s rotation, and the accelerated corrosion and wear of the control cable, which ultimately led to its failure in flight. - [NTSB ANC22LA064](https://openairdocs.org/ntsb/ANC22LA064.md): 5 Rivers SQ-2 · Soldotna, AK · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 27, 2022 · N58SQ · Substantial damage > A total loss of engine power due to carburetor icing, which resulted from the pilot's failure to use carburetor heat while operating in conditions conducive to the formation of carburetor ice. - [NTSB ANC22FA053](https://openairdocs.org/ntsb/ANC22FA053.md): Champion 7EC · Valdez, AK · Accident · 1 fatal · Class 3 · Field · Final report · Jul 12, 2022 · N4340C · Destroyed > The pilot’s decision to continue visual flight rules flight into instrument meteorological conditions which resulted in loss of control and collision with terrain. - [NTSB ANC22LA008](https://openairdocs.org/ntsb/ANC22LA008.md): Piper PA-18 · Palmer, AK · Accident · No injuries · Class 4 · Limited · Final report · Nov 26, 2021 · N1380A · Substantial damage > The pilot’s failure to effectively use carburetor heat in conditions conducive to the formation of carburetor ice, which resulted in a partial loss of engine power, off-airport landing, and nose over. - [NTSB ANC22LA007](https://openairdocs.org/ntsb/ANC22LA007.md): Cessna 207A · Bethel, AK · Accident · No injuries · Class 3 · Limited · Final report · Nov 21, 2021 · N9794M · Substantial damage > The improper installation of an avionics wire harness over a fuel line, which resulted in chafing of the wire harness, arcing, and a subsequent fire. - [NTSB ANC22LA002](https://openairdocs.org/ntsb/ANC22LA002.md): Cessna 180J · Chickaloon, AK · Accident · No injuries · Class 4 · Limited · Final report · Oct 13, 2021 · N9966N · 2 aircraft · Substantial damage > A mid-air collision for reasons that could not be determined based on the available evidence. - [NTSB ANC21LA094](https://openairdocs.org/ntsb/ANC21LA094.md): Dehavilland DHC-3 · Bettles, AK · Accident · No injuries · Class 3 · Limited · Final report · Aug 21, 2021 · N560TR · Substantial damage > The seizure of the engine during flight for undetermined reasons, which led to a total loss of engine power. - [NTSB ANC21LA073](https://openairdocs.org/ntsb/ANC21LA073.md): Cessna 208 · Fairbanks, AK · Accident · No injuries · Class 3 · Limited · Final report · Aug 16, 2021 · N97HA · Substantial damage > The pilot’s unexpected encounter with supercooled liquid droplets (SLD), which resulted in a loss of control due to ice accumulation. Contributing to the accident were: (1) the pilot’s failure to maintain the minimum airspeed for flight in icing conditions,… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?state=AK&page=2 ## The whole list in SQL Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS: ```sql WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')), crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')), current_codes AS ( SELECT e.case_mkey, TRY_CAST(e."tier1Number" AS INTEGER) AS code, row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e."isDefiningEvent", false) DESC, e.position) AS n FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.aircrafts_position = 1 AND e."tier1Number" GLOB '[1-9][0-9]*' AND (e."isDefiningEvent" OR e.case_mkey IN (SELECT "mKey" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE "isPre1982")) ), phases AS ( SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main FROM current_codes WHERE n = 1 UNION ALL SELECT o.case_mkey, 'older', o."phaseOfFlightCode", w.main FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o."phaseOfFlightCode" WHERE o.aircrafts_position = 1 AND o."occurrenceNumber" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes) ), case_phases AS ( SELECT p.*, c."eventDate", c."highestInjuryLevel" = 'Fatal' AS fatal, a.aircraft_model_code FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = p.case_mkey LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1 WHERE c."eventDate" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names) ) 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 case_mkey FROM case_phases WHERE main = 400) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/400/cases?state=AK --- OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.