NTSB investigations, AK
346 cases where the first occurrence was “In flight collision with terrain/water”.
Cases per year
| 1982 | 22 |
|---|---|
| 1983 | 18 |
| 1984 | 18 |
| 1985 | 23 |
| 1986 | 13 |
| 1987 | 10 |
| 1988 | 16 |
| 1989 | 16 |
| 1990 | 12 |
| 1991 | 6 |
| 1992 | 22 |
| 1993 | 30 |
| 1994 | 13 |
| 1995 | 22 |
| 1996 | 12 |
| 1997 | 8 |
| 1998 | 14 |
| 1999 | 14 |
| 2000 | 10 |
| 2001 | 12 |
| 2002 | 5 |
| 2003 | 9 |
| 2004 | 5 |
| 2005 | 5 |
| 2006 | 7 |
| 2007 | 4 |
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230)
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230) 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 ANC08CA002Accident · Minor injuriesData collectionFinal reportde Havilland DHC-2 · King Salmon, AKThe pilot's inadequate compensation for gusty wind conditions during the final approach to land, which resulted in the airplane colliding with terrain. A factor contributing to the accident was the gusty wind.NTSB ANC07LA062Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Skwentna, AKThe pilot's failure to maintain clearance from a glacier, which resulted in a tail rotor strike during landing, and damage to the helicopter during an emergency descent/landing on rough/uneven terrain. Factors contributing to the accident were variable and…NTSB ANC07CA061Accident · Minor injuriesData collectionFinal reportCessna 185F · Port Alsworth, AKThe pilot's flight into adverse weather conditions, which resulted in an in-flight collision with terrain while maneuvering. A factor contributing to the accident was interference by the pilot-rated passenger.NTSB ANC07LA036Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Girdwood, AKThe pilot's failure to maintain sufficient altitude/clearance from terrain while maneuvering, which resulted in an in-flight collision with a glacier. Factors contributing to the accident were snow-covered terrain, and flat light conditions.NTSB ANC06CA127Accident · No injuriesData collectionFinal reportCessna 172 · Healy, AKThe pilot's failure to maintain adequate altitude/clearance while maneuvering, which resulted in an in-flight collision with terrain. Factors associated with the accident were rising terrain, and the pilot's low altitude flight.NTSB ANC06CA110Accident · Minor injuriesData collectionFinal reportPiper PA-12 · Coldfoot, AKThe pilot's selection of an unsuitable landing area, which resulted in an in-flight collision with terrain during an aborted landing. Factors associated with the accident were wind gusts, and rough and uneven terrain.NTSB ANC06LA109Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 MK.1 · Anaktuvuk Pass, AKThe pilot's failure to abort the takeoff at his predetermined reference point, which resulted in a collision with the shore during takeoff-initial climb, and structural damage to the airplane.NTSB ANC06LA103Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-3 · Juneau, AKThe pilot's failure to maintain altitude/clearance during approach, which resulted in the airplane impacting the surface of the water. Factors associated with the accident were the flat-light and glassy water conditions, which affected the pilot's ability to…NTSB ANC06LA059Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-2 · Kodiak, AKThe pilot's inadequate evaluation of the weather conditions, and his selection of unsuitable terrain (rough water) for takeoff, which resulted in a collision with ocean swells during takeoff initial climb, and a hard emergency landing and a roll over. Factors…NTSB ANC06TA047Accident · No injuriesFinal reportAmerican Eurocopter AS350 B3 · Nikiski, AKThe pilot's failure to maintain adequate altitude/clearance from terrain during an aborted takeoff in whiteout conditions, which resulted in an in-flight collision with terrain. A factor associated with the accident was whiteout conditions.NTSB ANC06FA018Accident · 1 fatalField investigationFinal reportAero Vodochody L-39MS · Ketchikan, AKThe pilot's failure to follow published instrument landing procedures and his descent below approach minimums during an IFR circle to land approach, which resulted in the airplane striking the ocean and a loss of engine power. Factors contributing to the…NTSB ANC06LA007Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Unalakleet, AKThe pilot's failure to maintain altitude/clearance from terrain while performing a low altitude maneuver.NTSB ANC05CA138Accident · No injuriesData collectionFinal reportCessna 180 · Aniak, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a collision with brush during the landing flare. A factor contributing to the accident was high vegetation.NTSB ANC05FA121Accident · 2 fatalField investigationFinal reportBeech V35B · Denali Park, AKThe pilot's failure to maintain altitude/clearance from mountainous terrain while climbing, and his improper in-flight decision making by electing to fly at a low altitude toward rising terrain. A factor associated with the accident was mountainous terrain.NTSB ANC05FA090Accident · 3 fatalField investigationFinal reportCessna T207 · Nanwalek, AKThe pilot's continued VFR flight into instrument meteorological conditions, which resulted in an in-flight collision with an island cliff during cruise flight. A factor contributing to the accident was fog in the area of the accident.NTSB ANC05LA035Accident · Minor injuriesLimited investigationFinal reportBellanca 8GCBC · Koyukuk, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in an in flight collision with the snow during takeoff initial climb. A factor contributing to the accident was soft snow conditions.NTSB ANC04LA112Accident · No injuriesLimited investigationFinal reportCessna 170 · Teller, AKThe pilot's selection of unsuitable terrain for takeoff, and his inadequate evaluation of the wind conditions, which resulted in a collision with an embankment during takeoff-initial climb. Factors contributing to the accident was the presence of a sand…NTSB ANC04CA089Accident · No injuriesData collectionFinal reportAeronca 15AC · Big lake, AKThe pilot's inadequate evaluation of the weather conditions and subsequent collision with high vegetation during the initial climb after takeoff, which resulted in a collision with the ground. Factors contributing to the accident were the presence of a…NTSB ANC04FA070Accident · 1 fatalField investigationFinal reportBeech 36 · Talkeetna, AKThe pilot's failure to maintain clearance from terrain during cruise flight, which resulted in an in-flight collision with terrain.NTSB ANC04LA071Accident · No injuriesLimited investigationFinal reportChristen Industries Husky A-1 · Bethel, AKThe pilot's failure to attain the proper touchdown point, which resulted in an in-flight collision with terrain during the ensuing aborted landing. A factor associated with the accident is the pilot's misjudgment of the airplane's speed and distance.NTSB ANC04LA035Accident · No injuriesLimited investigationFinal reportCessna 180H · Talkeetna, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in a collision with a snow drift during takeoff/initial climb. Factors contributing to the accident were the snow-covered and uneven terrain.NTSB ANC03LA113Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Chalkyitsik, AKThe pilot's inadequate compensation for wind conditions, and his failure to maintain adequate airspeed during takeoff, which resulted in an in-flight collision with brush, and subsequent stall of the airplane. Factors associated with the accident were a…NTSB ANC03FA096Accident · 2 fatalField investigationFinal reportReims 406 · Barrow, AKAn in-flight collision with ocean waters while maneuvering for an undetermined reason.NTSB ANC03CA114Accident · No injuriesData collectionFinal reportCessna 206 · Ketchikan, AKThe pilot's selection of an unsuitable takeoff area, which resulted in an in-flight collision with ocean waves. A factor associated with the accident was large waves/swells.NTSB ANC03CA089Accident · No injuriesData collectionFinal reportCessna 185 · Iliamna, AKThe pilot's failure to maintain clearance during takeoff, which resulted in an in-flight collision with terrain.NTSB ANC03LA067Accident · 3 fatalLimited investigationFinal reportCessna 180 · Anchor Point, AKAn in-flight collision with water for an undetermined reason.NTSB ANC03LA049Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Aniak, AKThe pilot's failure to maintain clearance from terrain while maneuvering, which resulted in the airplane colliding with terrain. A factor contributing to the accident was the pilot's diverted attention.NTSB ANC03LA044Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Kotzebue, AKThe pilot's failure to maintain adequate altitude/clearance, which resulted in an in-flight collision with terrain during cruise flight. Factors associated with the accident were flat light conditions, and snow-covered terrain.NTSB ANC03LA031Accident · No injuriesLimited investigationFinal reportCessna 185 · Galena, AKThe failure of the airplane to climb after takeoff which resulted in an in-flight collision with terrain during an aborted landing attempt.NTSB ANC03LA026Accident · No injuriesLimited investigationFinal reportHughes 369E · Paxson, AKThe pilot's failure to maintain altitude/clearance from terrain. A factor contributing to the accident was the pilot's attention being diverted inside the cockpit to look at the global positioning system.NTSB ANC03LA022Accident · 1 fatalLimited investigationFinal reportCessna 180 · Petersburg, AKAn in flight collision with ocean water for an undetermined reason.NTSB ANC03LA007Accident · Serious injuriesLimited investigationFinal reportCessna 207 · Marshall, AKThe pilot's failure to maintain clearance from terrain, which resulted in an in-flight collision with a ridgeline. Factors contributing to the accident were the high terrain, the pilot's inadequate preflight planning, and the dark night light conditions.NTSB ANC02LA084Accident · No injuriesLimited investigationFinal reportCessna 206 · Old Harbor, AKThe pilot's failure to maintain altitude/clearance from terrain during initial climb, which resulted in an in-flight collision with water. A factor associated with the accident was the pilot's diverted attention.NTSB ANC02LA078Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Nome, AKThe pilot's failure to maintain adequate altitude and clearance in hilly terrain. A factor contributing to the accident was the performance of a low altitude flight maneuver.NTSB ANC02FA075Accident · 4 fatalField investigationFinal reportde Havilland DHC-2 · Port Alsworth, AKThe pilot's failure to maintain clearance from terrain while maneuvering inside a box/blind canyon, resulting in an in-flight collision with terrain. A factor contributing to the accident was the box/blind canyon.NTSB ANC02LA004Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Port Heiden, AKThe pilot's delay in aborting the landing. Factors in the accident were snow and ice on the runway surface, and the pilot's excessive taxi speed.NTSB SEA02FA008Accident · 3 fatalField investigationFinal reportBell 206L · Anchorage, AKThe pilot's failure to maintain clearance from the surface of an open body of water while intentionally attempting to maintain a very low altitude while in cruise flight. Factors include falling snow, low ceilings, whiteout/greyout conditions, and flat/glassy…NTSB ANC02LA002Accident · Minor injuriesLimited investigationFinal reportEmbraer 120ER · Bethel, AKThe captain's continued descent below the minimum descent altitude which resulted in impact with terrain during an instrument landing approach. Factors contributing to the accident were the flightcrew's failure to reset the altimeters to the correct altimeter…NTSB ANC01LA147Accident · No injuriesLimited investigationFinal reportCessna 206 · Galena, AKThe pilot's inadequate preflight planning and preparation for takeoff from an off-airport, short field site. Factors associated with the accident are a variable wind, and the pilot's inadequate weather evaluation.NTSB ANC01LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Port Heiden, AKThe pilot's inadequate evaluation of the wind conditions. A factor in the accident was the presence of a tailwind.NTSB ANC01LA131Accident · No injuriesLimited investigationFinal reportMaule M-7-235B · Koliganek, AKThe pilot's delay in aborting the takeoff. A factor in the accident was the pilot's diverted attention during the takeoff.NTSB ANC01LA125Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Sparrevohn, AKThe pilot's selection of unsuitable terrain for landing. Factors in the accident were rough/uneven terrain, and an overload failure of the main landing gear landing strut.NTSB ANC01LA070Accident · No injuriesLimited investigationFinal reportCessna 207A · Deadhorse, AKThe pilot's failure to maintain altitude/clearance while maneuvering. Factors associated with the accident were flat light conditions, and snow-covered terrain.NTSB ANC01LA056Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Emmonak, AKThe pilot's inadvertent stall while maneuvering. A factor associated with the accident was soft, snow-covered terrain.NTSB ANC01LA046Accident · Serious injuriesLimited investigationFinal reportCessna 207 · Nightmute, AKThe pilot's continued VFR flight into instrument meteorological conditions, and his failure to maintain adequate distance/altitude from terrain, resulting in a collision with terrain while maneuvering. Factors in the accident were flat light conditions,…NTSB ANC01TA035Accident · No injuriesFinal reportRobinson R-44 · Chickaloon, AKThe pilot's collision with terrain due to his inadequate planning of the approach, and his failure to maintain the helicopter's main rotor RPM during a go-around. Factors in the accident were a tailwind, flat lighting conditions, and snow-covered terrain.NTSB ANC01FA033Accident · 2 fatalField investigationFinal reportDouglas DC-3 · Unalaska, AKThe airplane flightcrew's failure to maintain adequate distance/altitude from mountainous terrain during a departure climb to cruise flight, and the captain's impairment from drugs. Factors in the accident were dark night conditions, and the first officer's…NTSB ANC00LA134Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Slana, AKThe pilot's inadvertent touch down. A factor associated with the accident was deep snow on the airstrip.NTSB ANC00FA128Accident · 1 fatalField investigationFinal reportCessna 207 · Aniak, AKThe pilot's decision to initiate visual flight into dark night instrument meteorological conditions. Factors associated with the accident are a low ceiling, a dark night, the pilot's failure to follow regulatory procedures and directives, and his self-induced…NTSB ANC00LA104Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Chenega Bay, AKThe pilot's failure to maintain an adequate lookout. Factors involved in this accident were sunglare, and a tall bush next to the airstrip.