NTSB investigations, AK
216 cases where the first occurrence was “In flight collision with object”.
Cases per year
| 1982 | 17 |
|---|---|
| 1983 | 12 |
| 1984 | 15 |
| 1985 | 14 |
| 1986 | 7 |
| 1987 | 9 |
| 1988 | 6 |
| 1989 | 10 |
| 1990 | 5 |
| 1991 | 4 |
| 1992 | 9 |
| 1993 | 9 |
| 1994 | 4 |
| 1995 | 12 |
| 1996 | 7 |
| 1997 | 5 |
| 1998 | 4 |
| 1999 | 7 |
| 2000 | 3 |
| 2001 | 7 |
| 2002 | 14 |
| 2003 | 6 |
| 2004 | 3 |
| 2005 | 7 |
| 2006 | 6 |
| 2007 | 14 |
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\" = 220)
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" = 220) 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 ANC08LA018Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Palmer, AKThe flight instructor's inadequate supervision of the student, and his delayed go-around. Contributing to the accident was dark night conditions.NTSB ANC08CA011Accident · No injuriesData collectionFinal reportRobinson R-22 · Nikolski, AKThe pilot's inadequate compensation for wind gusts while maneuvering, which resulted in the tail rotor striking an undetermined object, and an emergency descent and landing. Factors contributing to the accident were the wind gusts, and the failure of the tail…NTSB ANC07LA108Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Bethel, AKThe pilot's failure to maintain clearance from trees while landing.NTSB ANC07FA103Accident · 1 fatalField investigationFinal reportShort Bros. SC-7 · McGrath, AKA collision with trees during takeoff-initial climb for an undetermined reason.NTSB ANC07CA101Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Cooper Landing, AKThe pilot's failure to maintain altitude/clearance from objects, which resulted in an in-flight collision with trees during takeoff/initial climb. A factor contributing to the accident was the pilot's decision to takeoff into known adverse weather.NTSB ANC07LA099Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Tok, AKThe pilot's selection of an unsuitable takeoff area and failure to maintain clearance from trees during takeoff. Contributing to the accident were soft, muddy terrain conditions.NTSB ANC07LA092Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Kenai, AKThe pilot's failure to maintain adequate altitude/clearance from a parked airplane during the landing flare.NTSB ANC07FA073Accident · 4 fatalField investigationFinal reportPiper PA-46-350P · Sitka, AKThe pilot's failure to maintain altitude/distance from obstacles during an IFR circling approach, and his failure to follow the instrument approach procedure. Contributing to the accident was clouds.NTSB ANC07CA070Accident · No injuriesData collectionFinal reportBell 206B · Anchorage, AKThe pilot's failure to maintain clearance from a light pole during final approach, which resulted in the helicopter striking the pole.NTSB ANC07CA052Accident · No injuriesData collectionFinal reportCessna 175 · Stoney River, AKThe pilot's failure to maintain altitude/clearance during takeoff-initial climb, which resulted in the airplane colliding with a tree, and an uncontrolled descent.NTSB ANC07CA043Accident · No injuriesData collectionFinal reportCessna 170 · Anchorage, AKThe pilot's failure to maintain clearance from trees while landing, and his selection of an unsuitable landing site, which resulted in an in-flight collision with a tree and an on-ground encounter with brush.NTSB ANC07CA042Accident · No injuriesData collectionFinal reportPiper PA-18 · Talkeetna, AKThe pilot's delay in aborting the landing, which resulted in an in-flight collision with trees.NTSB ANC07CA039Accident · Minor injuriesData collectionFinal reportPiper PA-18 · Fairbanks, AKThe pilot's failure to maintain altitude/clearance while maneuvering, which resulted in a collision with trees. A factor contributing to the accident was dusk lighting conditions.NTSB ANC07LA022Accident · No injuriesLimited investigationFinal reportHughes 369D · Gustavus, AKThe inadequate clearance from a tranquilized moose while hovering in ground effect, and the operator's inadequate procedures for such operations, which resulted in an in-flight collision with the moose. Factors associated with the accident were the moose, a…NTSB ANC06CA124Accident · No injuriesData collectionFinal reportChampion 7GCBC · Clear, AKThe pilot's failure to maintain clearance from trees during the landing flare, which resulted in an in-flight collision with the trees.NTSB ANC06LA100Accident · Serious injuriesLimited investigationFinal reportEurocopter AS 350B2 · Skagway, AKThe pilot's failure to maintain adequate clearance from trees while hovering, which resulted in a main rotor strike with trees, an uncontrolled descent, and a collision with terrain.NTSB ANC06LA101Accident · No injuriesLimited investigationFinal reportCessna 172E · Big Lake, AKThe pilot's failure to maintain altitude/clearance from a transmission line while performing a low altitude maneuver, which resulted in an in-flight collision with the transmission line.NTSB ANC06CA051Accident · Minor injuriesData collectionFinal reportLanford Antares MA-33 · Trapper Creek, AKThe non-certificated pilot's failure to maintain altitude/clearance during final approach for landing, which resulted in the airplane striking a tree, and an in-flight collision with terrain. A factor associated with the accident was the tree.NTSB ANC06LA044Accident · No injuriesLimited investigationFinal reportAerospatiale AS-350BA · Haines, AKThe pilot's failure to maintain adequate clearance from an object while landing a helicopter at a remote site, which resulted in the main rotor blades striking a tree.NTSB ANC06LA032Accident · No injuriesLimited investigationFinal reportDouglas DC-3 · Beluga, AKThe pilot's failure to maintain altitude/clearance from trees on final approach, which resulted in an in-flight collision with trees.NTSB ANC06LA014Accident · Minor injuriesLimited investigationFinal reportTaylorcraft F-19 · Chenga Bay, AKThe pilot's failure to maintain adequate altitude/clearance during takeoff initial climb, which resulted in an in-flight collision with trees, and subsequent collision with the ground.NTSB ANC05FA116Accident · 2 fatalField investigationFinal reportCessna 180 · Fairbanks, AKThe pilot's failure to maintain sufficient altitude/clearance from objects and terrain during cruise flight, which resulted in an in-flight collision with tree-covered terrain.NTSB ANC05TA111Accident · No injuriesFinal reportMcDonnell Douglas 500D · Delta Junction, AKThe pilot's failure to maintain clearance from trees during the approach to landing, which resulted in the main rotor blades striking a tree. A factor associated with the accident was the tree.NTSB ANC05CA101Accident · No injuriesData collectionFinal reportHughes 500D · Ambler, AKThe pilot's failure to maintain clearance from an object while landing, which resulted in the main rotor blades striking a tree.NTSB ANC05CA095Accident · No injuriesData collectionFinal reportCessna 207 · Bethel, AKAn in-flight collision with a bird during cruise flight, which resulted in structural damage to the airplane's wing.NTSB ANC05CA071Accident · No injuriesData collectionFinal reportAerospatiale AS350-B2 · Valdez, AKThe pilot's failure to maintain clearance from an object while hover taxiing, which resulted in the main rotor blades striking a sign.NTSB ANC05LA021Accident · Serious injuriesLimited investigationFinal reportMaule M-7 · Chickaloon, AKThe pilot's failure to maintain altitude/clearance during cruise flight, which resulted in an in-flight collision with power lines, and an uncontrolled descent and collision with terrain. A factor associated with the accident was the power lines.NTSB ANC05LA010Accident · No injuriesLimited investigationFinal reportEurocopter France AS-350B2 · Ketchikan, AKThe pilot's failure to maintain clearance from an object while landing, which resulted in the main rotor blades striking a tree.NTSB ANC05CA005Accident · No injuriesData collectionFinal reportCessna 207 · Chefornak, AKThe in-flight collision with a bird while on final approach to land.NTSB ANC04FA063Accident · 1 fatalField investigationFinal reportBeech C-45H · Kodiak, AKThe pilot's failure to follow proper IFR procedures by not adhering to the published missed approach procedures, which resulted in an in-flight collision with tree-covered terrain. Factors contributing to the accident were a low ceiling, fog, rain, and the…NTSB ANC04LA012Accident · No injuriesLimited investigationFinal reportCessna 172 · Chugiak, AKThe pilot's selection of an unsuitable landing/takeoff area, and his failure to abort the takeoff, which resulted in an in-flight collision with a stump, and subsequent loss of control. Factors associated with the accident were snow-covered terrain and a…NTSB ANC04LA009Accident · No injuriesLimited investigationFinal reportBeech 1900C · Juneau, AKThe pilot's failure to maintain altitude/clearance from obstacles when approaching the airport, which resulted in an in-flight collision with a tree. Factors associated with the accident were the dark night, snow showers, and the pilot's failure to maintain…NTSB ANC03CA109Accident · No injuriesData collectionFinal reportMaule M-6-235 · Kenai, AKThe pilot's failure to maintain adequate altitude/clearance during an intentional go-around, which resulted in an in-flight collision with trees.NTSB ANC03CA078Accident · No injuriesData collectionFinal reportTaylorcraft F-19 · Aniak, AKThe pilot's inadvertent touchdown, and failure to maintain clearance from trees during an aborted landing, which resulted in the nose over of the airplane. A factor associated with the accident was the soft terrain.NTSB ANC03LA084Accident · Serious injuriesLimited investigationFinal reportCessna 185 · Big Lake, AKThe failure of the pilot of the seaplane and the operator of the jet ski to maintain an adequate visual lookout, which resulted in a collision during the airplane's landing flare.NTSB ANC03LA059Accident · No injuriesLimited investigationFinal reportWilliamson Glastar · Anchorage, AKThe pilot's failure to maintain directional control of the airplane during an aborted landing, which resulted in the airplane impacting trees along the side of the runway. A factor contributing to the accident was the pilot's improper recovery from a bounced…NTSB ANC03LA011Accident · No injuriesLimited investigationFinal reportDouglas DC-3 · Port Alsworth, AKThe flightcrew's failure to maintain clearance while landing, which resulted in an in-flight collision with a 25-foot high iron mast. Contributing factors were a downdraft, and a 25-foot high iron mast attached to a tractor.NTSB ANC03LA013Accident · No injuriesLimited investigationFinal reportCessna 180 · Larson Bay, AKThe pilot's failure to maintain adequate clearance while landing, which resulted in an in-flight collision with a tree.NTSB ANC02LA119Accident · No injuriesLimited investigationFinal reportCessna 185 · Mc Grath, AKThe pilot's inadequate compensation for wind conditions during takeoff, which resulted in an in-flight collision with trees. A factor associated with the accident was a variable wind condition.NTSB ANC02LA118Accident · No injuriesLimited investigationFinal reportCessna 180 · Port Heiden, AKThe pilot's inadequate compensation for wind conditions during initial climb, which resulted in an in-flight collision with trees. A factor associated with the accident was a variable wind.NTSB ANC02LA117Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Manley Hot Spgs, AKA bird strike during takeoff, which resulted in substantial damage to the right wing.NTSB ANC02LA114Accident · No injuriesLimited investigationFinal reportCessna 185 · Pilot Point, AKThe pilot's inadequate compensation for P-factor, and his failure to abort the takeoff which resulted in a collision with trees during the takeoff initial climb.NTSB ANC02TA077Accident · No injuriesFinal reportBell 212 · Wasilla, AKThe pilot's selection of an unsuitable landing site, and failure to maintain clearance with trees, which resulted in the main rotor blade striking a tree.NTSB ANC02LA079Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6 · Toksook Bay, AKA bird strike during takeoff, which resulted in damage to the right wing.NTSB ANC02LA059Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Wasilla, AKThe unqualified pilot's selection of an unsuitable landing site which resulted in an in-flight collision with a power line. Factors associated with the accident are the unqualified pilot's failure to see and avoid a power line, an unmarked power line, and…NTSB ANC02TA035Accident · No injuriesFinal reportRobinson R-44 · Cantwell, AKA failure of the pilot-in-command to maintain adequate main rotor rpm during an out-of-ground-effect hover.NTSB ANC02LA017Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Fairbanks, AKThe pilot's failure to maintain clearance from objects while maneuvering. A factor associated with the accident is an undetermined object.NTSB ANC02LA018Accident · No injuriesLimited investigationFinal reportAerospatiale AS350-B · Girdwood, AKThe pilot's failure to maintain adequate distance from a radio antenna during landing. A factor was the presence of an antenna.NTSB ANC02LA013Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Talkeetna, AKThe pilot's failure to remove sufficient ice/frost from the airplane prior to flight, and his failure to maintain adequate clearance from trees and terrain. A factor associated with the accident is the reduced climb capability of the airplane due to the…NTSB ANC02FA010Accident · 1 fatalField investigationFinal reportPiper PA-32 · Haines, AKThe pilot's continued VFR flight into instrument meteorological conditions, and subsequent collision with trees while in cruise flight. Factors in the accident were weather conditions consisting of freezing rain, mist, and low ceilings.