NTSB investigations, 1998
16 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\") = 1998
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") = 1998 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 CHI99LA011Accident · No injuriesLimited investigationFinal reportCessna 182Q · Pound, WIthe pilot misjudged the proper touchdown point and subsequently landed short of the runway. Factors associated with the accident were the haze, sunglare, the lack of visual perception, and the uphill terrain on which the airplane touched down.NTSB NYC99LA008Accident · No injuriesLimited investigationFinal reportWSK PZL Krosno KR-03A · Hilltown, PAThe pilot's misjudgment of altitude/distance which resulted in an in-flight collision which trees.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 CHI98LA350Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Janesville, WIthe pilot's failure to land the airplane at a proper touchdown point on the runway. A factor was the excessive rate of descent which developed on final approach.NTSB SEA98LA173Accident · No injuriesLimited investigationFinal reportKoskella Long EZ · Cascade, IDThe pilot's failure to maintain airspeed on final approach. Factors include inadequate remedial action and erroneous airspeed indications.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 FTW98LA323Accident · Serious injuriesLimited investigationFinal reportSchweizer SGU 2-22E · Canon City, COThe pilot's misjudgment of distance/altitude and his premature deployment of the spoilers, resulting in a undershoot and hard landing.NTSB FTW98LA312Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Watkins, COThe pilot misjudged his altitude. Contributing to the accident were unfavorable wind and dark night conditions.NTSB LAX98LA148Accident · No injuriesLimited investigationFinal reportCessna 150G · Oroville, CAThe pilot's failure to maintain the proper glide path, and his inadequate compensation for wind conditions, which resulted in an undershoot.NTSB FTW98FA191Accident · 1 fatalField investigationFinal reportBeech F33A · Del Rio, TXthe pilot's loss of control during a go-around after impacting approach light poles on initial approach. A contributing factor was the prevailing dark night light condition.NTSB NYC98LA097Accident · Serious injuriesLimited investigationFinal reportLet L-23 Super Blanik · Pipersville, PAthe pilot's misjudgment of distance and altitude, while on an approach to an off-airport landing area, which resulted in a lack of airspeed and/or altitude to reach the intended landing area (undershoot), a stall or mush into tree(s), and collision with a…NTSB NYC98LA070Accident · No injuriesLimited investigationFinal reportCessna 320F · Lincoln, METhe pilot's failure to maintain adequate altitude which resulted in left main landing gear contacting a snowbank during the landing approach.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 SEA98LA035Accident · Minor injuriesLimited investigationFinal reportBromley Steen Skybolt · Hillsboro, ORThe pilot's failure to maintain a proper glidepath.NTSB FTW98LA095Accident · Minor injuriesLimited investigationFinal reportBeech V35 · Seguin, TXThe pilot's failure to maintain the proper descent rate.