NTSB investigations, 1997

28 cases where the first occurrence was “Undershoot”.

Cases per year

19822026
NTSB investigations, 1997 per year, 1982–2026: 820 cases
1982102
198362
198460
198545
198635
198744
198830
198930
199022
199120
199233
199336
199443
199530
199628
199728
199816
199921
200017
20018
200214
200319
200418
200524
200613
200722

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.

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.Dec 21, 1997 · N8805P · Substantial damageNTSB 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.Dec 16, 1997 · N2932X · Substantial damageNTSB 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…Nov 22, 1997 · N8315S · Substantial damageNTSB 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.Nov 1, 1997 · N65140 · Substantial damageNTSB 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.Oct 26, 1997 · N252MY · Substantial damageNTSB 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.Oct 12, 1997 · N5762S · Substantial damageNTSB 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.Oct 12, 1997 · N7269E · Substantial damageNTSB 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.Oct 5, 1997 · N4028X · DestroyedNTSB 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.Sep 26, 1997 · N7667H · Substantial damageNTSB 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,…Sep 24, 1997 · N6756H · Substantial damageNTSB 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.Sep 22, 1997 · N7331Q · Substantial damageNTSB 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.Sep 17, 1997 · N2680Q · Substantial damageNTSB 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.Sep 12, 1997 · N2389M · Substantial damageNTSB SEA97LA211Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Mackay, IDThe pilot misjudged the distance/altitude while on final approach.Sep 9, 1997 · N91019 · Substantial damageNTSB 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.Sep 6, 1997 · N4982S · Substantial damageNTSB 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.Sep 4, 1997 · N84TX · Substantial damageNTSB 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.Aug 14, 1997 · N227R · Substantial damageNTSB 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…Aug 6, 1997 · H7468 · DestroyedNTSB 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…Jul 27, 1997 · N9396P · Substantial damageNTSB 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.Jun 27, 1997 · N3685Z · Substantial damageNTSB 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.Jun 3, 1997 · N171DB · Substantial damageNTSB 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.May 17, 1997 · N321JL · Substantial damageNTSB SEA97LA108Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · The Dalles, ORThe pilot-in-command misjudged his altitude and distance from the runway while landing.May 10, 1997 · N1707P · Substantial damageNTSB 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.May 10, 1997 · N9456Z · Substantial damageNTSB 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.May 3, 1997 · N290X · Substantial damageNTSB LAX97LA165Accident · Serious injuriesLimited investigationFinal reportLet Blanik L-13 · Hemet, CAthe pilot's failure to adjust his traffic pattern to compensate for local atmospheric conditions.Apr 19, 1997 · N90620 · Substantial damageNTSB 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.Apr 9, 1997 · N3263H · Substantial damageNTSB 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.Jan 18, 1997 · N5654N · Substantial damage