NTSB investigations, 2007
22 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\") = 2007
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") = 2007 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 LAX08CA035Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Fallbrook, CAThe pilot's misjudged distance and altitude that led to an undershoot and a failure to obtain the proper touchdown point.NTSB DEN08CA023Accident · Minor injuriesData collectionFinal reportCessna TP206A · Boulder, COThe pilot's misjudgment of altitude. Contributing factors in this accident were the pilot's intentional low airspeed, his failure to execute a go-around, and the soft terrain.NTSB SEA08FA013Accident · 1 fatalField investigationFinal reportGrumman American AA-5A · Sequim, WAThe pilot's misjudged distance and altitude that led to an undershoot; his failure to maintain directional control during the landing roll; and his failure to maintain clearance from trees during an attempted aborted landing.NTSB SEA08CA011Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Tehachapi, CAThe pilot's misjudged distance/altitude that led to an undershoot, and his failure to attain the proper touchdown point.NTSB LAX08CA006Accident · No injuriesData collectionFinal reportAviat A-1 · Arroyo Grande, CAThe pilot's misjudged altitude and distance on the approach that led to an undershoot and inadequate obstacle clearance.NTSB SEA07CA273Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Chandler, AZThe 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 the downdraft, the uneven terrain, and the flight instructor's delayed…NTSB NYC07CA222Accident · Minor injuriesData collectionFinal reportLancair IV-P · Alabaster, ALThe pilot's failure to attain the proper touchdown point.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 NYC07LA166Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-160 · Enterprise, ALThe designated examiner's improper decision to simulate an engine failure on short final approach, in conjunction with a short-field landing maneuver, and his inadequate remedial action. Contributing to the accident was the private pilot's inadvertent…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 NYC07CA141Accident · No injuriesData collectionFinal reportPiper PA31-310 · Marietta, PAThe pilot's failure to obtain the proper touchdown point, which resulted in an undershoot.NTSB SEA07CA149Accident · No injuriesData collectionFinal reportPiper PA-16 · Esparto, CAThe pilot's misjudgment of altitude resulting in an undershoot. Factors included the berm and the wind gusts.NTSB MIA07CA108Accident · Minor injuriesData collectionFinal reportJames L. Stringfellow Glastar · Williston, FLThe pilot's misjudgment of distance/altitude and his improper touchdown point which resulted in an undershoot, nose over and damage to the airplane.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 LAX07CA149Accident · Minor injuriesData collectionFinal reportBurkhart Grob G102 Club Astir Iiib · Minden, NVthe pilot's misjudgment of distance and altitude that resulted in an undershoot of the runway.NTSB NYC07CA090Accident · Serious injuriesData collectionFinal reportNavion A · Marlboro, MAThe pilot's failure to maintain a proper glidepath to the runway.NTSB ATL07CA056Accident · No injuriesData collectionFinal reportBeech B24R · Monks Corner, SCThe pilot's misjudgment of speed/distance/altitude which resulted in a undershoot of the runway.NTSB SEA07LA079Accident · Serious injuriesLimited investigationFinal reportMooney M20K · Marysville, CAThe failure of the pilot to maintain a proper glidepath while on final approach and his failure to maintain clearance, which resulted in an undershoot and subsequent collision with the runway's approach light standards. A factor was the approach light…NTSB LAX07CA104Accident · No injuriesData collectionFinal reportSchleicher ASW-27B · Williams, CAThe pilot's misjudged distance/altitude and delay in retracting the spoilers that led to an undershoot, which resulted in a collision with terrain.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 DFW07CA074Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Granbury, TXThe pilot's misjudgment of altitude and distance while landing, which resulted in an undershoot of the runway. A contributing factor was the rising terrain on approach to the runway.