NTSB investigations, 2005
24 cases where the first occurrence was “Undershoot”.
Cases per year
| 1982 | 102 |
|---|---|
| 1983 | 62 |
| 1984 | 60 |
| 1985 | 45 |
| 1986 | 35 |
| 1987 | 44 |
| 1988 | 30 |
| 1989 | 30 |
| 1990 | 22 |
| 1991 | 20 |
| 1992 | 33 |
| 1993 | 36 |
| 1994 | 43 |
| 1995 | 30 |
| 1996 | 28 |
| 1997 | 28 |
| 1998 | 16 |
| 1999 | 21 |
| 2000 | 17 |
| 2001 | 8 |
| 2002 | 14 |
| 2003 | 19 |
| 2004 | 18 |
| 2005 | 24 |
| 2006 | 13 |
| 2007 | 22 |
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 year(c.\"eventDate\") = 2005
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 year(c."eventDate") = 2005 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 ATL06CA013Accident · Minor injuriesData collectionFinal reportBeech BE-76 · Greer, SCThe pilot's misjudgment of altitude and distance which resulted in an undershoot of the runway, and the collision with trees.NTSB SEA06LA011Accident · No injuriesLimited investigationFinal reportCessna 402B · Sandpoint, IDThe pilot's misjudged distance/altitude, which led to him landing short of the runway and impacting the runway's elevated lip. Contributing factors were the elevated runway lip and the right main landing gear failure.NTSB ATL06LA008Accident · 1 fatalLimited investigationFinal reportElan/Glaser Dirks DG-300 · Brownsboro, ALThe pilot's misjudgment of distance/altitude on final approach which resulted in an undershoot of the runway, and an in-flight collision with a embankment. A factor was the dirt bank/rising terrain.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 CHI05CA262Accident · No injuriesData collectionFinal reportCessna 310Q · Boscobel, WIThe pilot's misjudged distance/altitude which resulted in an undershoot. A related factor was the pilot's diverted attention due to the open cabin door.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 CHI05CA241Accident · Minor injuriesData collectionFinal reportPiper PA-22-150 · Brodhead, WIThe pilot's misjudged distance/altitude which resulted in an undershoot. A related factor was the vehicle the airplane contacted.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 IAD05FA110Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Georgetown, DEThe pilot's misjudged distance/altitude while on final approach to land, which resulted in an in-flight collision with a vehicle. Factors associated with the accident are the pilot's improper use of the flaps, and the state of Delaware's insufficient…NTSB IAD05CA098Accident · No injuriesData collectionFinal reportGrumman G164A · Williamstown, NJThe pilot's misjudgment of distance/altitude, and his failure to maintain obstacle clearance.NTSB DEN05LA104Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Rocky Ford, COthe pilot's misjudged distance/altitude. A contributing factor was the inadvertent flap retraction.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 LAX05LA223Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Yuma, AZthe pilot's misjudged distance and altitude, which resulted in an undershoot and collision with a airport boundary fence short of the runway. A factor in the accident was the pilot's lack of familiarity flying the airplane at a high gross weight with a center…NTSB IAD05LA109Accident · No injuriesLimited investigationFinal reportBeech BE-35-C33A · East Hampton, NYThe pilot's failure to attain the proper touchdown point during landing, which resulted in the airplane touching down short of the landing surface.NTSB LAX05CA219Accident · Minor injuriesData collectionFinal reportCessna 180A · Big Bend, CAthe pilot misjudged his clearance altitude above the surface of the lake, resulting in a collision with water.NTSB ATL05CA099Accident · Minor injuriesData collectionFinal reportCessna 150M · Panama City, FLThe pilot's misjudgment of distance/altitude while on final approach with a tailwind, which resulted in an undershoot of the runway.NTSB NYC05CA097Accident · Minor injuriesData collectionFinal reportBurkhart Grob G103 Twin Astir · Wellington, OHThe pilot's misjudgment of distance and altitude which resulted in an undershoot of the runway.NTSB CHI05CA119Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Beloit, WIThe pilot's misjudgment of distance/altitude which resulted in an undershoot of the runway and collision with trees.NTSB ATL05LA078Accident · 1 fatalLimited investigationFinal reportEarnest Jodel D-9 · Memphis, TNThe pilot's misjudgment of distance/altitude, and his failure to maintain adequate airspeed resulting in a stall and subsequent undershoot.NTSB MIA05LA077Accident · Serious injuriesLimited investigationFinal reportLet Blanik L-13 · DeLand, FLThe failure of the pilot to maintain sufficient airspeed during landing, resulting in an inadvertent stall, undershoot and collision with the ground.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 LAX05LA089Accident · No injuriesLimited investigationFinal reportSmith Aerostar 601 · Murrieta, CAThe pilot's misjudgment of distance/altitude on final approach, which resulted in an undershoot of the runway.