NTSB investigations, AK
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
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' 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' 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 ANC24LA059Accident · No injuriesClass 4 · LimitedFinal reportCessna 185 · Anchorage, AKThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.NTSB ANC24LA053Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Tok, AKThe pilot’s failure to maintain directional control of the airplane during the landing roll.NTSB ANC24LA054Accident · No injuriesClass 4 · LimitedFinal reportDehavilland Beaver DHC-2 MK.1 · Aleknagik, AKThe pilot’s failure to maintain pitch control of the airplane during initial climb.NTSB ANC24FA052Accident · 2 fatalClass 3 · FieldPreliminary reportPiper PA-18-150 · Moose Pass, AKOn June 18, 2024, about 1400 Alaska daylight time, a float-equipped Piper PA-18-150 airplane, N645DT, was substantially damaged when it was involved in an accident near Moose Pass, Alaska. The instructor pilot and the pilot receiving instruction were fatally…NTSB ANC24LA050Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters CC18-180 · Bethel, AKThe pilot's failure to maintain directional control during landing which resulted in a ground loop.NTSB ANC24LA049Accident · Serious injuriesClass 3 · LimitedFinal reportDehavilland Beaver L-20A (DHC-2) · Port Alsworth, AKA partial loss of engine power for reasons that could not be determined.NTSB ANC24LA046Accident · No injuriesClass 4 · LimitedFinal reportCessna 206 · Fairbanks, AKThe pilot’s failure to maintain directional control during takeoff in gusting wind conditions.NTSB ANC24LA045Accident · No injuriesClass 3 · LimitedFinal reportCessna 206 · King Salmon, AKA partial loss of engine power due to detonation/preignition of the No. 1 cylinder for reasons that could not be determined.NTSB ANC24LA047Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-20-135 · Nenana, AKThe pilot providing instruction’s delayed remedial action, resulting in a loss of control during landing roll.NTSB ANC24LA043Accident · No injuriesClass 3 · LimitedFinal reportCessna 207A · Bethel, AKThe pilot’s improper short-field takeoff procedure, which resulted in an aerodynamic stall and subsequent hard landing.NTSB ANC24LA051Accident · No injuriesClass 4 · LimitedFinal reportMorgan Edward L Edge X 582 · Fairbanks, AKThe pilot’s selection of an unsuitable landing site, resulting in a collision with a hole during landing rollout.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 ANC24LA042Accident · No injuriesClass 3 · LimitedFinal reportCessna 170A · Willow, AKThe pilot’s failure to maintain directional control during landing roll, resulting in a ground loop and substantial damage to the airplane.NTSB ANC24LA040Accident · No injuriesClass 4 · LimitedFinal reportCessna 180H · Soldotna, AKThe pilot’s failure to recognize and avoid an obstacle on the runway environment during takeoff roll. Contributing was flat light conditions.NTSB ANC24LA044Accident · No injuriesClass 4 · LimitedFinal reportJordan Harry James Sportsman 2+2 · Fairbanks, AKThe pilot’s failure to maintain directional control during the takeoff roll.NTSB ANC24LA037Accident · No injuriesClass 4 · LimitedFinal reportDehavilland Beaver DHC-2 MK.1 · Fairbanks, AKThe pilot’s improper fuel management resulting in a loss of engine power due to fuel starvation.NTSB ANC24LA041Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Knik, AKThe pilot's excessive braking during the landing roll, resulting in a nose over.NTSB ANC24FA032Accident · 2 fatalClass 3 · FieldFinal reportTaylorcraft BC12-D · Nondalton, AKThe non-certificated pilot’s continued visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into the water.NTSB ANC24LA033Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Dry Creek, AKThe pilot receiving instruction’s excessive use of brakes during landing, and the pilot providing instruction’s inadequate supervision, resulting in a nose-over.NTSB ANC24LA031Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Anchorage, AKThe student pilot’s failure to maintain directional control during landing.NTSB ANC24FA029Accident · 2 fatalClass 3 · FieldFinal reportDouglas C54D · Fairbanks, AKA 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 ANC24LA025Accident · No injuriesClass 3 · LimitedFinal reportCessna 120 · Talkeetna, AKA degraded ignition system, which resulted in a total loss of engine power. Contributing to the accident was maintenance personnel’s inadequate inspection of the ignition system.NTSB ANC24LA101Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-105 Special · Big Lake, AKThe pilot’s failure to maintain clearance from an obstacle during takeoff.NTSB ANC24LA019Accident · No injuriesClass 4 · LimitedFinal reportMichael G Darby Dard 1 · Anchorage, AKThe pilot’s loss of directional control while landing in soft snow, resulting in a nose over.NTSB ANC24LA020Accident · Minor injuriesClass 4 · LimitedFinal reportStinson 108 · Houston, AKA total loss of engine power due to fuel starvation and the pilot's mismanagement of the available fuel.NTSB ANC24LA018Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Skwentna, AKThe pilot’s failure to maintain directional control while taxiing, which resulted in a collision with trees.NTSB ANC24LA014Accident · No injuriesClass 4 · LimitedFinal reportBenjamin Pratt Bearhawk Patrol · Galena, AKA 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 ANC24LA015Accident · No injuriesClass 4 · LimitedFinal reportCessna R172K · Trapper Creek, AKThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall; loss of airplane control; and impact with terrain.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 ANC24LA009Accident · Minor injuriesClass 4 · LimitedFinal reportAirbus Helicopters AS350B3 · Palmer, AKThe pilot's failure to maintain clearance from snow-covered terrain during the landing approach in flat light conditions.NTSB ANC24FA008Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-18-150 · Anchor Point, AKAn 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 ANC24LA007Accident · No injuriesClass 4 · LimitedFinal reportBeech 200 · New Stuyahok, AKThe pilot’s loss of directional control during landing flare resulting in substantial damage to the left wing.NTSB ANC24LA003Accident · No injuriesClass 4 · LimitedFinal reportCessna 180H · McCarthy, AKThe pilot’s loss of directional control after touchdown which resulted in substantial damage to the right wing.NTSB ANC24LA006Accident · No injuriesClass 4 · LimitedFinal reportCharles J Kase Kase KUB · Big Lake, AKThe pilot’s selection of an unsuitable landing site that was covered in deep snow.NTSB ANC24LA004Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-22 · Anchorage, AKThe loss of engine power during final approach due to fuel exhaustion, which resulted from the pilot’s inadequate preflight.NTSB ANC24LA002Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Wasilla, AKThe instructor pilot’s delayed action and over application of brakes which resulted in a nose-over.NTSB ANC24LA001Accident · No injuriesClass 4 · LimitedFinal reportNathan A Rehak CAW-12 · Beluga, AKThe pilot’s loss of control after failing to determine wind direction during landing in variable, gusting wind conditions.NTSB ANC23LA087Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Beluga, AKThe pilot’s excessive application of brakes during landing that resulted in a nose over.NTSB ANC23LA086Accident · No injuriesClass 4 · LimitedFinal reportCessna 182K · Trimble River Valley, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in the separation of the main landing gear wheel and the subsequent loss of directional control.NTSB ANC23LA084Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Bethel, AKThe pilot’s excessive use of brakes during landing roll, which resulted in a nose-over.NTSB ANC23LA080Accident · No injuriesClass 3 · LimitedFinal reportCessna A185F · Homer, AKA total loss of engine power for undetermined reasons.NTSB ANC23LA082Accident · No injuriesClass 4 · LimitedFinal reportHelio H-295 · Fairbanks, AKThe pilot’s encounter with windshear during initial climb out, which resulted in a loss of control.NTSB ANC23LA078Accident · No injuriesClass 3 · LimitedFinal reportRhodes Steven D SR3500 · Nenana, AKA total loss of engine power due to fuel starvation. Contributing was the owner/builder’s inadequate maintenance.NTSB ANC23LA085Accident · Serious injuriesClass 4 · LimitedFinal reportEurocopter AS 350 B3 · Johnson River, AKThe ground crew’s failure to remain clear of a tag line during sling load operations, resulting in his entanglement.NTSB ANC23LA083Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · McGrath, AKThe pilot’s failure to maintain directional control during after encountering a wind gust during landing that resulted in an impact with terrain.NTSB ANC23LA077Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-D · Palmer, AKThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall; loss of airplane control; and impact with terrain.NTSB ANC23FA074Accident · 1 fatalClass 2 · FieldFinal reportPiper PA-18-150 · St. Mary's, AKThe pilot’s decision to operate the airplane above its maximum certificated gross weight, and his installation of an unapproved external load that degraded takeoff performance and flight characteristics resulting in a loss of airplane control during takeoff…NTSB ANC23LA075Accident · No injuriesClass 4 · LimitedFinal reportCessna 185 · Healy, AKThe pilot’s selection of an unsuitable landing site, resulting in a nose over.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 ANC23LA073Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Beluga, AKThe pilot’s delayed go-around decision with insufficient runway remaining.