NTSB investigations, AK

68 cases where the sequence of events included Hard landing.

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'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '092' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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.

NTSB ANC11CA063Accident · No injuriesData collectionFinal reportPiper PA-12 · Gulkana, AKThe pilot's inadequate recovery from a bounced landing.Jul 10, 2011 · N2318M · Substantial damageNTSB ANC11CA052Accident · No injuriesData collectionFinal reportCessna 182H · Soldotna, AKThe pilot's failure to maintain pitch control resulting in an aerodynamic stall.Jun 20, 2011 · N331AA · Substantial damageNTSB ANC10CA086Accident · No injuriesData collectionFinal reportRoberts Alan W Kitfox II · Fairbanks, AKThe pilot's failure to maintain proper aircraft control during landing and the subsequent go-around, resulting in a hard landing, and a collision with a signpost.Sep 11, 2010 · N598AL · Substantial damageNTSB ANC10LA032Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · King Cove, AKThe pilot's failure to maintain an appropriate descent rate during gusty winds while landing, resulting in a hard landing and damage to the airplane.Apr 26, 2010 · N8305H · Substantial damageNTSB ANC10LA020Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 369E · Delta Junction, AKA total loss of engine power in flight for undetermined reasons.Mar 6, 2010 · N26TC · Substantial damageNTSB ANC10CA010Accident · No injuriesData collectionFinal reportStinson 108-1 · Selawik, AKThe pilot's failure to maintain a proper descent rate during landing, resulting in a hard landing.Dec 18, 2009 · N136SP · Substantial damageNTSB ANC10CA002Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Nondalton, AKThe pilot's decision to attempt a landing in weather conducive to strong downdrafts, resulting in a loss of control.Oct 10, 2009 · N27231 · Substantial damageNTSB ANC09LA110Accident · No injuriesLimited investigationFinal reportHughes 369A (OH-6A) · Palmer, AKA partial loss of engine power after take off for an undetermined reason, which resulted in a hard landing.Sep 29, 2009 · N501SU · Substantial damageNTSB ANC09CA093Accident · No injuriesData collectionFinal reportAeronca 15AC · Kotzebue, AKThe pilot's delay in aborting the off-airport landing resulting in a hard landing.Sep 7, 2009 · N1187H · Substantial damageNTSB ANC09CA067Accident · No injuriesData collectionFinal reportCessna A185F · Skwentna, AKThe pilot's failure to recognize his proximity to the glassy water landing surface while flying in smoke haze, and his failure to maintain a proper descent rate during the landing approach.Jul 6, 2009 · N4448R · Substantial damageNTSB ANC09CA111Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Homer, AKThe pilot's excessive airspeed during approach to compensate for turbulence, resulting in a hard landing and runway overrun.Jul 3, 2009 · N4299Z · Substantial damageNTSB ANC09GA040Accident · No injuriesFinal reportRobinson Helicopter R44 · Iliamna, AKThe main rotor transmission mount design, which resulted in an in-flight vibration/oscillation, and damage to the helicopter during an emergency descent and hard landing. Contributing to the accident was the lack of information from the manufacturer regarding…May 12, 2009 · N7196H · Substantial damageNTSB ANC08CA103Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Northway, AKThe pilot's inadequate evaluation of weather conditions while landing, which resulted in a hard landing. A factor contributing to the accident was a tailwind.Aug 9, 2008 · N2975Q · Substantial damageNTSB ANC08LA083Accident · No injuriesLimited investigationFinal reportBell UH-1B · Iliamna, AKThe failure of company maintenance personnel to ensure the helicopter was properly maintained, resulting in a severe in-flight vibration due to collective bounce. Contributing to the accident was loose and worn bearings on the helicopter's stabilizer bar,…Jun 30, 2008 · N64RA · Substantial damageNTSB ANC08CA081Accident · Minor injuriesData collectionFinal reportMarvin A. Smith Pietenpol Air Camper · Soldotna, AKThe student pilot's inadequate recovery from a bounced landing.Jun 27, 2008 · N165MS · Substantial damageNTSB ANC08CA071Accident · No injuriesData collectionFinal reportCessna 172RG · Anchorage, AKThe pilot's inadequate recovery from a bounced landing. Contributing to the accident was a crosswind.Jun 5, 2008 · N9752B · Substantial damageNTSB ANC08CA066Accident · No injuriesData collectionFinal reportde Havilland DHC-2 · Talkeetna, AKThe pilot's inadvertent activation of the main landing gear brakes during the recovery from a bounced landing.May 11, 2008 · N323KT · Substantial damageNTSB ANC08CA057Accident · No injuriesData collectionFinal reportFairchild Swearingen SA 227-AC · Anchorage, AKThe flightcrew's misjudged flare while landing.Apr 4, 2008 · N650PA · Substantial damage