NTSB investigations, AK
92 cases where the first occurrence was “Undershoot”.
Cases per year
| 1982 | 6 |
|---|---|
| 1983 | 2 |
| 1984 | 5 |
| 1985 | 6 |
| 1986 | 2 |
| 1987 | 4 |
| 1988 | 3 |
| 1989 | 2 |
| 1990 | 1 |
| 1991 | 4 |
| 1992 | 6 |
| 1993 | 4 |
| 1994 | 3 |
| 1995 | 3 |
| 1996 | 3 |
| 1997 | 5 |
| 1998 | 4 |
| 1999 | 2 |
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 3 |
| 2003 | 4 |
| 2004 | 2 |
| 2005 | 7 |
| 2006 | 3 |
| 2007 | 5 |
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\" = 390)
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" = 390) 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 ANC07CA076Accident · No injuriesData collectionFinal reportMaule M-5-235 · Talkeetna, AKThe flight instructor's inadequate supervision of the student while landing, which resulted in an undershoot and an in-flight collision with an object. Factors contributing to the accident are the dual student's misjudged altitude/distance and delayed…NTSB ANC07FA054Accident · 2 fatalField investigationFinal reportCessna 177RG · Wasilla, AKThe flight instructor's failure to adequately supervise the private pilot (dual student), and his delayed go-around during approach to land. Contributing to the accident was the dual student's misjudged distance/altitude.NTSB ANC07LA046Accident · No injuriesLimited investigationFinal reportSchleicher ASK-21 · Clear, AKThe dual student's misjudged distance/altitude during the final approach to land, and the flight instructor's inadequate supervision of the student, which resulted in an undershoot, and substantial damage.NTSB ANC07LA040Accident · No injuriesLimited investigationFinal reportDouglas DC-4 · McGrath, AKAn undershoot and collision with the runway when the pilot misjudged the distance/altitude during the landing flare/touchdown.NTSB ANC07CA023Accident · No injuriesData collectionFinal reportCessna 172 · Chugiak, AKThe instructor pilot's inadequate supervision of the student while landing, which resulted in an undershoot, and subsequent in-flight collision with snow-covered terrain.NTSB ANC06CA135Accident · No injuriesData collectionFinal reportCessna 150 · Anchorage, AKThe pilot's misjudged distance/altitude during final approach, which resulted in an undershoot and subsequent in-flight collision with terrain. A factor associated with the accident was a landing gear collapse.NTSB ANC06LA094Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Willow, AKThe pilot's misjudged distance/altitude during landing, which resulted in an undershoot and an in-flight collision with trees.NTSB ANC06CA052Accident · No injuriesData collectionFinal reportPiper PA-18 · Iliamna, AKThe pilot's misjudged distance and altitude, which resulted in an undershoot during final approach to a beach, and subsequent in-flight collision with water and a nose over.NTSB ANC05CA148Accident · No injuriesData collectionFinal reportAeronca 7AC · Coldfoot, AKThe pilot's misjudgment of distance/altitude during the landing flare/touchdown, which resulted in an undershoot and subsequent nosing down of the airplane when the main landing gear tires contacted shallow water prior to the intended landing site.NTSB ANC05LA125Accident · Minor injuriesLimited investigationFinal reportCessna U206E · Skwentna, AKThe pilot's misjudged distance/altitude on final approach, which resulted in a noseover following an undershoot and in-flight collision with rough/uneven terrain. A factor associated with the accident was the rough/uneven terrain.NTSB ANC05CA124Accident · No injuriesData collectionFinal reportTaylorcraft F19 · Chickaloon, AKThe pilot's misjudged distance and altitude on final approach to land, which resulted in an undershoot and structural damage to the airplane. A factor associated with the accident was a downdraft.NTSB ANC05CA115Accident · No injuriesData collectionFinal reportPiper PA-18 · Port Heiden, AKThe pilot's misjudged distance/altitude during final approach, which resulted in an undershoot and an in-flight collision with terrain.NTSB ANC05TA106Accident · No injuriesFinal reportCessna 185 · Delta Junction, AKThe pilot's misjudged distance/altitude during the landing touchdown and subsequent undershoot, and his failure to maintain directional control of the airplane during the landing roll, which resulted in an on-ground encounter with high vegetation.NTSB ANC05CA096Accident · No injuriesData collectionFinal reportPiper PA-18-160 · Hope, AKThe pilot's misjudged distance and altitude during an approach to land at an off-airport landing site, which resulted in an undershoot, and subsequent in-flight collision with trees and tundra-covered terrain. A factor in the accident was trees.NTSB ANC05LA045Accident · No injuriesLimited investigationFinal reportHelio H-295 · Fairbanks, AKThe pilot's delay in performing a go-around, and his failure to maintain obstacle clearance.NTSB ANC04LA091Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKThe pilot's misjudged distance/altitude during the final approach phase of landing, which resulted in an undershoot and subsequent collision with terrain.NTSB ANC04LA051Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kasilof, AKThe pilot's inadequate compensation for wind conditions while landing, which resulted in an undershoot and an in-flight collision with terrain. Factors associated with the accident were a downdraft, and an embankment.NTSB ANC04LA013Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Anchorage, AKThe pilot's misjudged altitude during final approach, which resulted in an undershot landing, and subsequent nose over.NTSB ANC03LA116Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Skwentna, AKThe pilot's misjudgment of the distance/altitude to the touchdown point during landing, which resulted in an undershoot and collision with a river bank. A factor contributing to the accident was the presence of a river bank that formed the beginning of the…NTSB ANC03LA068Accident · No injuriesLimited investigationFinal reportCessna 170B · Palmer, AKThe pilot's misjudged distance and altitude during an approach to land at an off-airport landing site, which resulted in an undershoot, and subsequent in-flight collision with terrain.NTSB ANC03LA062Accident · Minor injuriesLimited investigationFinal reportSwearingen SA-226T · Goodnews, AKThe flight crew's inadequate evaluation of the weather conditions, which resulted in their inadequate compensation for the wind conditions, and subsequent undershoot. A contributing factor in the accident was a downdraft.NTSB ANC02LA066Accident · No injuriesLimited investigationFinal reportCessna 207 · Chevak, AKThe pilot's failure to attain the proper touchdown point resulting in an undershoot, and subsequent collision with gravel terrain.NTSB ANC02LA065Accident · No injuriesLimited investigationFinal reportCessna 185 · Skwentna, AKThe pilot's failure to attain the proper touchdown point resulting in an undershoot, and an in-flight collision with a log during the landing flare. A contributing factor in the accident was a hidden obstruction.NTSB ANC02LA019Accident · No injuriesLimited investigationFinal reportCessna 207A · Kotlik, AKThe failure of the pilot-in-command to maintain the proper glide path to the runway during the final approach for a VFR landing.NTSB ANC01LA028Accident · No injuriesLimited investigationFinal reportCessna 172 · Atmautluak, AKThe pilot's failure to maintain a proper glidepath during final approach. A factor associated with the accident was soft terrain.NTSB ANC00LA055Accident · No injuriesLimited investigationFinal reportBell 206B · Haines, AKThe pilot's failure to attain a proper touchdown point.NTSB ANC00LA038Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Fairbanks, AKThe pilot's misjudgment of distance/altitude, and subsequent undershoot during landing. Factors in the accident were light snow precipitation, flat light conditions, snow-covered terrain, and the absence of a visual approach slope indicator.NTSB ANC99LA092Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Juneau, AKThe pilot's failure to maintain rotor rpm, and an inadequately planned approach. A factor associated with the accident was a tailwind.NTSB ANC99LA044Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Fairbanks, AKThe pilot's failure to attain the proper touchdown point on the runway. Factors in the accident were snow showers and snow-covered terrain.NTSB ANC98LA154Accident · No injuriesLimited investigationFinal reportCessna 182D · Fort Yukon, AKA failure of the pilot to maintain the proper glidepath to the landing touch down spot.NTSB ANC98LA115Accident · No injuriesLimited investigationFinal reportCessna 182 · Fairbanks, AKThe pilot's failure to attain the proper touchdown point. A factor associated with this accident was the high brush at the approach end of the landing area.NTSB ANC98LA025Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Kongiganak, AKThe pilot misjudged distance/altitude and airspeed, and his delay initiating a go-around. Related factors were the downdraft and snowbank.NTSB ANC98LA021Accident · No injuriesLimited investigationFinal reportCessna 180H · Anchorage, AKThe pilot's failure to attain the proper touchdown point on the runway. Factors in the accident were: snow covered terrain at the approach end of the runway and flat light conditions.NTSB ANC98LA002Accident · No injuriesLimited investigationFinal reportCessna 182B · Palmer, AKThe pilot misjudging the touchdown point, which resulted in landing short of the sand bar and the airplane nosing over.NTSB ANC97LA156Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Gustavus, AKThe pilot's failure to attain the proper touchdown point. Factors associated with the accident are the pilot's improper glidepath, and the rough and uneven terrain.NTSB ANC97LA147Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe pilot's misjudgment of the touchdown point, which led to undershoot and the airplane nosing over.NTSB ANC97TA095Accident · No injuriesFinal reportPiper PA-18-180 · Tok, AKThe second pilot/dual student's failure to maintain a proper glidepath, and the pilot-in-command/flight instructor's inadequate supervision. A factor associated with the accident was a downdraft.NTSB ANC97LA023Accident · No injuriesLimited investigationFinal reportMaule M-5 · Chugiak, AKThe pilot's failure to attain the proper touchdown point during landing. The snow-covered runway was a factor.NTSB ANC97LA006Accident · No injuriesLimited investigationFinal reportPiper PA-22/20 · Kasilof, AKthe pilot's misjudgment of distance and altitude on final approach to land, which resulted in an undershoot and collision with a dirt bank before reaching the proper touchdown point. A factor related to the accident was: the proximity of the frozen dirt bank…NTSB ANC96LA125Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKthe pilot's misjudgment of distance and altitude to the runway during the approach, and failure to attain the proper touchdown point. A factor relating to the accident was: the ditch.NTSB ANC96LA121Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Arctic Village, AKThe airplane's low airspeed during final approach, and the pilot's delayed remedial action in correcting the low airspeed condition.NTSB ANC96LA018Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Nanwalek, AKThe pilot's inadequate compensation for wind conditions. A factor in the accident was the variable wind.NTSB ANC95LA159Accident · No injuriesLimited investigationFinal reportCessna 206 · Homer, AKThe pilot's inadequate compensation for the wind conditions, which resulted in his failure to reach the proper touchdown point for landing. Factors related to the accident were: the variable wind condition, and rising terrain (no overrun) at the approach end…NTSB ANC95LA038Accident · No injuriesLimited investigationFinal reportCessna 152 · Anchorage, AKA failure of the instructor pilot to adequately supervise the student pilot's landing approach. The student pilot's failure to maintain a proper altitude and distance to the runway touch-down point, and a snow berm at the approach end of the runway were…NTSB FTW94LA310Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Nikiski, AKThe pilot's improper descent rate. A factor was the check pilot's inadequate supervision.NTSB ANC94LA084Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Talkeetna, AKThe pilot misjudged clearance from a bush.NTSB ANC94LA072Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Sheldon Point, AKThe pilot's failure to attain a proper touchdown Point. Factor was the inadequate runway marking.NTSB ANC94LA023Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Northway, AKThe pilot-in-command did not maintain the proper glidepath.NTSB ANC93LA138Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKThe inadvertent raising of the flaps.NTSB ANC93LA133Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Soldotna, AKThe pilot's failure to attain a proper touchdown point. A factor was the pilot's improper in flight planning/decision.