NTSB investigations, AK
15 cases where the defining event was Collision with terr/obj (non-CFIT).
Cases per year
| 2008 | 3 |
|---|---|
| 2019 | 2 |
| 2021 | 1 |
| 2022 | 2 |
| 2023 | 3 |
| 2024 | 1 |
| 2025 | 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\" = '470')
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" = '470') 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 ANC25LA106Accident · No injuriesClass 4 · LimitedFinal reportBrian Turner Northern Explorer · Delta Junction, AKThe pilot’s failure to maintain obstacle clearance during landing, which resulted in an impact with trees.NTSB ANC25LA082Accident · No injuriesClass 4 · LimitedFinal reportCessna U206F · Yakutat, AKThe pilot’s failure to maintain clearance during approach in gusting wind conditions to a remote airstrip, resulting in a collision with brush.NTSB ANC25LA036Accident · Minor injuriesClass 4 · LimitedFinal reportStinson 108 · North Pole, AKThe 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 ANC24LA086Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150H · Tok, AKThe airplane’s encounter with gusting winds resulting in a loss of altitude with performance insufficient to outclimb terrain.NTSB ANC23LA081Accident · Serious injuriesClass 4 · LimitedFinal reportPiper/Gerbi Charles R PA 18-150 · Juneau, AKThe student pilot’s failure to maintain altitude after the airplane encountered a downdraft while maneuvering over an area of hilly terrain.NTSB ANC23LA050Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1B · Matanuska Glacier, AKThe airplane’s encounter with downdrafts resulting in decreased performance insufficient to outclimb rising terrain.NTSB ANC23LA049Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18 · Beluga, AKThe pilot's selection of an unsuitable takeoff site, resulting in a collision with brush-covered terrain.NTSB ANC22LA060Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft F21 · Kenai, AKThe pilot’s failure to maintain adequate distance from a tree while landing.NTSB ANC22LA016Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Skwenta, AKThe pilot’s failure to maintain adequate clearance from a tree while landing.NTSB ANC21LA057Accident · No injuriesClass 4 · LimitedFinal reportDehavilland DHC-2-L-20 · Coffman Cove, AKThe pilot’s impact with a buoy on takeoff which resulted in a nose-over.NTSB ANC20FA007Accident · 3 fatalClass 3 · FieldFinal reportPiper PA-31-350 · Cooper Landing, AKThe pilot’s failure to maintain clearance from terrain during gusty wind and reduced visibility night conditions.NTSB ANC20LA004Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32R · Goodnews Bay, AKThe pilot’s failure to monitor the airplane instruments during a night visual flight rules departure in dark light conditions, which resulted in spatial disorientation and the airplane’s descent into water.NTSB ANC08CA112Accident · No injuriesData collectionFinal reportRobinson R44 · Iliamna, AKThe pilot's failure to see a wire cable prior to colliding with it. Factors contributing to the accident were the non-routine positioning of the wire cable, and the ground crew's failure to advise the pilot that the wire had been re-routed.NTSB ANC08FA050Accident · Serious injuriesField investigationFinal reportGrumman G-21A · Unalaska, AKThe pilot's failure to maintain clearance from a truck while landing, and the vehicle operator's decision to ignore runway warning signals. Contributing to the accident was an inoperative vehicle gate system and the failure of airport management to adequately…NTSB ANC08LA031Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Bethel, AKThe pilot's selection of unsuitable terrain for landing. Contributing to the accident were snow-covered terrain, blowing snow and flat lighting conditions.