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.
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
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 ANC11CA063Accident · No injuriesData collectionFinal reportPiper PA-12 · Gulkana, AKThe pilot's inadequate recovery from a bounced landing.NTSB ANC11CA052Accident · No injuriesData collectionFinal reportCessna 182H · Soldotna, AKThe pilot's failure to maintain pitch control resulting in an aerodynamic stall.NTSB 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.NTSB 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.NTSB ANC10LA020Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 369E · Delta Junction, AKA total loss of engine power in flight for undetermined reasons.NTSB 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.NTSB 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.NTSB 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.NTSB ANC09CA093Accident · No injuriesData collectionFinal reportAeronca 15AC · Kotzebue, AKThe pilot's delay in aborting the off-airport landing resulting in a hard landing.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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,…NTSB ANC08CA081Accident · Minor injuriesData collectionFinal reportMarvin A. Smith Pietenpol Air Camper · Soldotna, AKThe student pilot's inadequate recovery from a bounced landing.NTSB ANC08CA071Accident · No injuriesData collectionFinal reportCessna 172RG · Anchorage, AKThe pilot's inadequate recovery from a bounced landing. Contributing to the accident was a crosswind.NTSB 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.NTSB ANC08CA057Accident · No injuriesData collectionFinal reportFairchild Swearingen SA 227-AC · Anchorage, AKThe flightcrew's misjudged flare while landing.