NTSB investigations, 2002
14 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\") = 2002
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") = 2002 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 ATL02LA177Accident · No injuriesLimited investigationFinal reportSchempp-Hirth KA8B · Tullahoma, TNThe student pilot misjudged the airspeed and altitude during a visual approach to land that resulted in the in-flight collision with the trees.NTSB CHI02CA287Accident · No injuriesData collectionFinal reportCessna 150G · Dodge Center, MNThe pilot's misjudgment of distance resulting in an undershoot of the runway.NTSB FTW02LA246Accident · No injuriesLimited investigationFinal reportCessna 182-Q · New Roads, LAThe pilot's failure to maintain airspeed which resulted in a stall.NTSB NYC02LA170Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · New Bedford, MAThe pilots failure to obtain the proper touchdown point, and the CFI's delay in remedial action.NTSB NYC02LA156Accident · No injuriesLimited investigationFinal reportCessna 182Q · Cincinnati, OHThe pilot's misjudgment of distance which resulted in the airplane landing short of the runway.NTSB LAX02LA244Accident · No injuriesLimited investigationFinal reportCessna 182P · Mokelumne Hill, CAThe pilot's failure to maintain the proper glidepath and failure to follow the manufacturer's recommended flap setting of 40 degrees, which resulted in an undershoot short of the runway. Factors include the runway's upslope and short length, which likely…NTSB SEA02LA141Accident · No injuriesLimited investigationFinal reportCessna 210L · Cascade, IDThe pilot's failure to maintain the proper rate of descent on short final resulting in a touchdown short of the runway threshold. Contributing factors were the variable winds and swampy terrain at the touchdown site.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 ATL02LA133Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Picayune, MSThe pilot's misjudged the touch down point on the runway and collided with the ground short of the runway.NTSB IAD02LA048Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Fairfield, PAThe pilot's failure to attain proper runway alignment. A factor in the accident was the pilot's delay in retracting the spoilers.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 FTW02LA069Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Plainview, TXthe pilot's failure to maintain the proper glidepath, which resulted in landing short of the runway.NTSB ATL02LA036Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Bellewood, MSThe pilot misjudged the proper touched down point and collided with the ground short of the runway during an attempted landing.