NTSB investigations, 1997
28 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
Latest 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\") = 1997
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") = 1997 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 LAX98LA062Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Healdsburg, CAthe pilot's misjudged distance and altitude relationship to the runway during a short field approach, which resulted in an undershoot and a hard landing.NTSB NYC98LA046Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Philadelphia, PAThe pilot's failure to maintain proper distance and altitude during approach which resulted in an undershoot and collision with a fence.NTSB CHI98LA043Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Janesville, WIthe dual student's failure to obtain the proper touchdown point, and the instructor's failure to provide adequate supervision of the flight. Factors associated with the accident were: inadequate altitude, the student's diverted attention, the snowbank, and…NTSB MIA98LA023Accident · No injuriesLimited investigationFinal reportLet L-13 · Elkin, NCThe instructor's pilot's misjudgment of altitude and distance, and his inadequate compensation for the wind conditions. Unfavorable winds and a fence were contributing factors.NTSB NYC98LA021Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Ocean City, NJThe pilot's failure to maintain sufficient altitude. Factors in the accident were the rain and fog.NTSB CHI98LA013Accident · Minor injuriesLimited investigationFinal reportSchweizer FGS-233 · Ionia, MIthe pilot misjudged the landing approach which resulted in his failure to attain a proper touchdown point. A factor was the trees.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 CHI98FA010Accident · 3 fatalField investigationFinal reportAero Commander 100-180 · Auburn, NEthe pilot misjudged distance/altitude to the runway, while on final approach to land, allowing the airplane to get too low and collide with a truck. A related factor was: the proximity of the truck (and highway) to the runway.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 SEA97FA215Accident · 3 fatalField investigationFinal reportCessna 172M · Bremerton, WAThe pilot's misjudgment of distance and altitude from the runway, and his subsequent failure to maintain clearance from the terrain. Factors contributing to the accident were dark night conditions, the pilot's improper decision to conduct the flight at night,…NTSB CHI97LA307Accident · No injuriesLimited investigationFinal reportCessna 182 · Dassel, MNthe pilot's failure to attain the proper touchdown point on the airstrip. Factors associated with the accident were the high vegetation which skewed the pilot's visual perception of threshold, and the embankment which the airplane contacted.NTSB CHI97LA294Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Fargo, NDthe pilot's misjudgment of altitude and distance to the runway, while on final approach to land, and failure to attain the proper touchdown point on the runway during the landing. The exposed runway lip was a related factor.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 SEA97LA211Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Mackay, IDThe pilot misjudged the distance/altitude while on final approach.NTSB NYC97LA179Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · West Chester, PAthe pilot's misjudgment of altitude and distance to the runway, which resulted in an undershoot and failure to reach the proper touchdown point. Rising terrain at the approach end of the runway was a related factor.NTSB LAX97LA310Accident · No injuriesLimited investigationFinal reportBingelis Falco F.8L · Watsonville, CAthe pilot's misjudgment of distance and speed on final approach, leading to a landing undershoot.NTSB NYC97LA165Accident · No injuriesLimited investigationFinal reportDassault DA-20 · Lexington, KYThe pilot misjudged distance and altitude to the runway after transition from an instrument approach to a visual approach. Factors related to the accident were the rain, and uphill runway conditions at a dark night.NTSB DCA97MA058Accident · 228 fatalClass 1 · MajorFinal reportBoeing 747-300 · Nimitz Hillthe captain's failure to adequately brief and execute the nonprecision approach and the first officer's and flight engineer's failure to effectively monitor and cross-check the captain's execution of the approach. Contributing to these failures were the…NTSB MIA97LA218Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Burnsville, NCThe failure of the pilot to use the checklist to confirm that the main cabin door was closed and locked before takeoff. Also, failure of the pilot to attain the proper touchdown point during the precautionary landing. Contributing to the accident was the self…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 CHI97LA154Accident · No injuriesLimited investigationFinal reportCessna 340A · Fort Wayne, INthe pilot did not comply with the decision height and his attention was diverted from his cockpit scan. The factors involved were the weather conditions were at landing minimums and a flight to his destination alternate was not performed.NTSB IAD97LA078Accident · No injuriesLimited investigationFinal reportMooney M20M · Madisonville, KYFailure of the pilot to maintain adequate airspeed, and inadequate supervision of the CFI, which resulted in a stall and subsequent hard landing.NTSB SEA97LA108Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · The Dalles, ORThe pilot-in-command misjudged his altitude and distance from the runway while landing.NTSB NYC97LA088Accident · No injuriesLimited investigationFinal reportNorth American B-25J · Midland, VAThe pilot's misjudgment of distance and altitude during the final approach. A factor in the accident was the exposed runway lip/edge.NTSB CHI97LA120Accident · No injuriesLimited investigationFinal reportMaule M-5 · West Fargo, NDthe pilot's inadequate compensation for wind conditions, and his failure to attain a proper touchdown point. Factors relating to the accident were: the unfavorable wind conditions, and the terrain condition where the airplane touched down.NTSB LAX97LA165Accident · Serious injuriesLimited investigationFinal reportLet Blanik L-13 · Hemet, CAthe pilot's failure to adjust his traffic pattern to compensate for local atmospheric conditions.NTSB MIA97LA132Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Bushnell, FLThe pilot's failure to maintain a visual lookout and altitu de while on final approach to landing resulting in an in-flight collision with a fence and subsequent collision with terrain.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.