NTSB investigations, AK
19 cases where the sequence of events included Landing area overshoot.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 2 |
| 2012 | 1 |
| 2014 | 4 |
| 2016 | 1 |
| 2020 | 2 |
| 2021 | 1 |
| 2022 | 4 |
| 2024 | 1 |
| 2026 | 1 |
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '380' 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" = '380' 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 ANC26LA081Accident · Minor injuriesClass 4 · LimitedInvestigation openCessna A185F · Hope, AKNTSB ANC24LA061Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Koliganek, AKThe pilot's improper landing flare and an improper recovery from a bounced landing, resulting in a loss of directional control, and a subsequent nose over.NTSB ANC23LA014Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Anchorage, AKThe pilot’s failure to maintain directional control of the airplane during landing.NTSB ANC22LA075Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 180H · McCarty, AKThe pilot’s failure to initiate a go around maneuver when the airplane past the intended touch down point.NTSB ANC22LA071Accident · No injuriesClass 4 · LimitedFinal reportStinson 10A · Port Alsworth, AKThe pilot's delayed decision to execute a go-around maneuver while landing with a tailwind into a short strip, which resulted in a runway overrun and subsequent loss of control.NTSB ANC22LA029Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Beluga, AKThe pilot’s excessive touchdown speed, which resulted in a long landing and impact with terrain.NTSB ANC21LA088Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Talkeetna, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in a loss of directional control and nose over.NTSB ANC20CA090Accident · No injuriesClass 4 · Data collectionFinal reportCessna 182 · Palmer, AKThe pilot’s excessive airspeed during landing and improper application of the brakes, which resulted in a runway overrun.NTSB ANC20CA075Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA18 · Chisana, AKThe pilot's overapplication of brakes during landing in gusting tailwind conditions, which resulted in a nose-over.NTSB GAA16CA516Accident · No injuriesData collectionFinal reportPiper PA 18 · Kotzebue, AKThe pilot’s selection of unsuitable terrain for an off-airport precautionary landing, which resulted in a nose-over.NTSB ANC14CA064Accident · No injuriesData collectionFinal reportCessna 182A · Gustavus, AKThe pilot's unstable landing approach which resulted in a long landing, and subsequent collision with terrain.NTSB ANC14CA057Accident · No injuriesData collectionFinal reportDehavilland Beaver DHC 2 · Illiamna, AKThe pilot's inadequate landing technique that resulted in a landing area overrun. Contributing was the glassy water conditions.NTSB ANC14CA045Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Nenana, AKThe pilot's excessive braking following his overshoot of the intended touchdown point on a short airstrip, which resulted in nose-over of the airplane. A contributing factor was the pilot's mental distraction during the landing.NTSB ANC14LA038Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Talkeetna, AKMaintenance personnel’s failure to perform required fuel system tests to ensure that the airplane met its original type certification basis after modifying the fuel system and the Federal Aviation Administration’s improper approval of the fuel tank…NTSB ANC12CA019Accident · No injuriesData collectionFinal reportCessna 207A · Nikiski, AKThe pilot's improper identification of the runway surface. Contributing to the accident was the snow covering the runway lights.NTSB ANC09CA085Accident · No injuriesData collectionFinal reportCessna 140 · Fairbanks, AKThe pilot's failure to achieve a proper touchdown point, resulting in an overrun and a nose over.NTSB ANC09CA049Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Nome, AKThe pilot's selection of an unsuitable landing/takeoff area.NTSB ANC09CA016Accident · No injuriesData collectionFinal reportCessna 172S · Girdwood, AKThe flight instructor's lack of action to correct a high and fast landing approach which resulted in a long landing, and subsequent collision with a snow berm at the end of the runway. Contributing to the accident was the student pilot's improper approach.NTSB ANC08CA114Accident · Minor injuriesData collectionFinal reportCessna 207 · Fairbanks, AKThe pilot's delay in aborting the landing. A factor contributing to the accident was a variable wind.