NTSB investigations
820 cases where the first occurrence was “Undershoot”.
Cases, newest first
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 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 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 LAX97LA333Accident · No injuriesLimited investigationFinal reportMikoyan MiG MIG 15UTI · Fallon, NVThe pilot misjudged his altitude and airspeed. A related factor was his diverted attention.NTSB ANC97LA006Accident · No injuriesLimited investigationFinal reportPiper PA-22/20 · Kasilof, AKthe pilot's misjudgment of distance and altitude on final approach to land, which resulted in an undershoot and collision with a dirt bank before reaching the proper touchdown point. A factor related to the accident was: the proximity of the frozen dirt bank…NTSB LAX97LA024Accident · No injuriesLimited investigationFinal reportSchweizer 2-33-A · Los Alamitos, CAThe student pilot's failure to properly handle the glider, and the instructor pilot's inadequate supervision.NTSB SEA97LA009Accident · 1 fatalLimited investigationFinal reportGlobe GC-1B · Caldwell, IDthe pilot's misjudgment of distance and altitude to the runway, while on final approach to land. The sunglare was a related factor.NTSB SEA97LA007Accident · No injuriesLimited investigationFinal reportCessna 182Q · Manzanita, ORfailure of pilot to adequately compensate for wind conditions on final approach and attain a proper touchdown point for landing. A factor relating to the accident was: the unfavorable wind condition.NTSB NYC96LA172Accident · Minor injuriesLimited investigationFinal reportPzl-Bielsko SZD-59 · Franconia, NHThe pilot's misjudged altitude and distance which resulted in the collision with trees short of the runway.NTSB ANC96LA125Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKthe pilot's misjudgment of distance and altitude to the runway during the approach, and failure to attain the proper touchdown point. A factor relating to the accident was: the ditch.NTSB CHI96LA289Accident · Minor injuriesLimited investigationFinal reportMrotek Minicab GY20 · Albion, INthe pilot's misjudgment of distance and altitude during the approach to land, and his failure to attain the proper touchdown point. Factors relating to the accident were: the uneven and uphill terrain conditions at the approach end of the airstrip.NTSB ANC96LA121Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Arctic Village, AKThe airplane's low airspeed during final approach, and the pilot's delayed remedial action in correcting the low airspeed condition.NTSB FTW96LA314Accident · No injuriesLimited investigationFinal reportBarton Sylkie 1 · Erie, COThe pilot passenger's failure to maintain clearance from the fence due to his failure to maintain a proper glide path, and the pilot-in-command's failure to take remedial action in a timely fashion.NTSB CHI96LA249Accident · No injuriesLimited investigationFinal reportCessna 172 · Emily, MNthe pilot misjudged his altitude and distance to the runway on final approach, and he failed to maintain obstacle clearance during landing. A factor relating to the accident was: the parked car.NTSB CHI96LA233Accident · No injuriesLimited investigationFinal reportCessna 172 · Freeport, ILThe pilot's misjudgment of altitude and distance on final approach, and his failure to attain the proper touchdown point for landing.NTSB MIA96LA172Accident · No injuriesLimited investigationFinal reportCharles Raymond Glasair 2SFT · Apalachicola, FLInadequate application of throttle input and up elevator input by the pilot-in-command. Contributing to the accident was the in-flight encounter with a downdraft and inadequate design of the airplane by the kit manufacturer.NTSB LAX96LA252Accident · No injuriesLimited investigationFinal reportCessna 402A · Grand Canyon, AZFailure of the pilot to properly judge his altitude during final approach resulting in an undershoot. A factor was a downdraft weather condition.NTSB SEA96LA124Accident · Serious injuriesLimited investigationFinal reportCessna 177B · Gardiner, WAthe pilot's inadequate compensation for wind conditions and failure to maintain the proper altitude/clearance from obstruction(s), while on final approach. Factors relating to the accident were: the downdraft, and the obstruction (tree).NTSB SEA96LA123Accident · No injuriesLimited investigationFinal reportCessna 182 · Roche Harbor, WAthe pilot's inadequate compensation for wind conditions and failure to attain a proper touchdown point for landing. Factors relating to the accident were: downdraft conditions and soft/uneven terrain short of the runway.NTSB SEA96LA125Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Hillsboro, ORthe pilot's inadequate compensation for wind conditions, and his failure to attain a proper touchdown point for landing. A factor relating to the accident was: upsloping terrain short of the threshold.NTSB LAX96LA224Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Santa Clarita, CAthe pilot's failure to abandon the pinnacle approach after encountering an excessive rate of descent.NTSB NYC96LA104Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Readington, NJthe pilot's inadequate evaluation of the weather, and his misjudgment of altitude and distance from the runway. Contributing factors were the pilot's lack of recent experience and the weather.NTSB SEA96LA091Accident · No injuriesLimited investigationFinal reportLimes Challenger II · Redmond, ORthe pilot's misjudgment of distance and altitude on final approach, and his failure to maintain proper clearance from an object (fence) in his approach path. The fence was a related factor.NTSB NYC96LA097Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Chester, NHThe pilot's misjudged distance and altitude during final approach.NTSB NYC96LA095Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-R200 · Forks Township, PAthe flight instructor's misjudgment of distance and altitude, and delay in performing remedial action.NTSB LAX96LA166Accident · No injuriesLimited investigationFinal reportRockwell 112TCA · Independence, CAthe pilot's inadequate compensation for the wind conditions. The wind was a factor.NTSB LAX96LA158Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Jean, NVthe pilot's poorly planned approach. The flight's encounter with a downdraft is a factor in this accident.NTSB NYC96LA081Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Matawan, NJthe pilot's misjudgment of altitude and distance during final approach.NTSB CHI96LA087Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Warren, MNthe dual student's failure to maintain a proper glidepath and inadequate supervision by the instructor.NTSB SEA96LA052Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Hubbard, ORthe pilot's misjudgment of altitude and distance on short final. A factor was the wet and soft terrain short of the runway threshold.NTSB MIA96LA073Accident · Minor injuriesLimited investigationFinal reportGilpatrick Baby Lakes · Deland, FLThe pilot's misjudgment of distance and altitude, while on final approach to land, and his failure to attain the proper touchdown point for landing. The unfavorable wind condition (crosswind) was a related factor.NTSB LAX96LA088Accident · No injuriesLimited investigationFinal reportCessna 150L · Quartzite, AZthe pilot's misjudgement of his distance and altitude relationship to the runway, which resulted in an undershoot and failure to achieve the proper touchdown point for landing.NTSB CHI96LA057Accident · No injuriesLimited investigationFinal reportBeech 58 · Minneapolis, MNthe pilot-in-command's abrupt maneuvering during the circling approach. The factors involved were the airframe ice and fog.NTSB SEA96LA030Accident · No injuriesLimited investigationFinal reportCessna 170B · John Day, ORThe pilot's failure to maintain a proper glidepath.NTSB ANC96LA018Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Nanwalek, AKThe pilot's inadequate compensation for wind conditions. A factor in the accident was the variable wind.NTSB LAX96LA069Accident · No injuriesLimited investigationFinal reportCessna 172 · Ocotillo Wells, CAthe failure of the pilot to maintain a proper glide path on final approach.NTSB BFO96LA023Accident · No injuriesLimited investigationFinal reportBeech A23-24 · New Carlisle, OHthe pilot-in-command's failure to reach the proper touchdown point. Related factors were the pilot's failure to obtain/maintain the proper glidepath during the approach, and the rough/uneven terrain encountered after the airplane touched down short of the…NTSB CHI96FA034Accident · 2 fatalField investigationFinal reportErcoupe 415-C · Stafford, KSthe pilot misjudged his distance and altitude and flew into transmission wires. A factor was the pilot's lack of recent night flying experience.NTSB DCA96MA008Accident · Minor injuriesClass 1 · MajorFinal reportMcDonnell Douglas MD-83 · East Granby, CTthe flightcrew's failure to maintain the required minimum descent altitude until the required visual references identifiable with the runway were in sight. Contributing factors were the failure of the BDL approach controller to furnish the flightcrew with a…NTSB NYC96FA024Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Ashville, NYthe pilot's misjudgment of altitude and distance to the runway during an approach to land. Factors relating to the accident were: the night and adverse weather conditions.NTSB NYC96LA020Accident · No injuriesLimited investigationFinal reportCessna 414A · Grt Barrington, MAthe pilot's inadequate compensation for wind conditions, which resulted in an undershoot of the proper touchdown point for landing. Factors relating to the accident were: the unfavorable wind conditions and the exposed runway lip.NTSB FTW96LA020Accident · No injuriesLimited investigationFinal reportCessna 182P · Kingston, OKthe pilot's inadequate compensation for the wind gusts. Factors were the gusts and the dark night conditions.NTSB CHI96LA012Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Wakeeney, KSFailure of the pilot to maintain sufficient altitude and airspeed on final approach to reach the proper touchdown point for landing. A factor relating to the accident was: the pilot's selection of the wrong runway for landing.NTSB FTW96LA016Accident · No injuriesLimited investigationFinal reportCessna 182E · Fort Collins, COa fatigue failure of the right main landing gear. Factors were the pilot's failure to attain the proper touchdown point and his inadequate compensation for the crosswind conditions.NTSB BFO96LA008Accident · No injuriesLimited investigationFinal reportGrumman American G-1159 · Cleveland, OHthe pilots' failure to attain the proper touchdown point and avoid obstacles (construction barricades) during the landing flare/touchdown. Related factors were: the sunglare, which limited in the pilots' visual lookout during the approach, and the unavailable…NTSB ANC95LA159Accident · No injuriesLimited investigationFinal reportCessna 206 · Homer, AKThe pilot's inadequate compensation for the wind conditions, which resulted in his failure to reach the proper touchdown point for landing. Factors related to the accident were: the variable wind condition, and rising terrain (no overrun) at the approach end…NTSB NYC95LA216Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Boothbay Harbor, MEthe pilot's misjudgment of distance and altitude, while on final approach to land. Factors relating to the accident were: sunglare, and the pilot's lack of visual cues (visual perception).NTSB SEA95LA187Accident · No injuriesLimited investigationFinal reportCessna 177B · Yamhill, ORThe pilot's failure to maintain a proper glidepath. A factor contributing to the accident was the sunglare.NTSB CHI95LA207Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Linton, NDThe pilot's misjudging distance and altitude. The pilot's lack of total experience in type of operation was a factor.NTSB SEA95LA131Accident · No injuriesLimited investigationFinal reportCessna 172F · Homedale, IDThe pilot misjudged distance and altitude during the approach. The downdraft was a factor.NTSB BFO95LA061Accident · Serious injuriesLimited investigationFinal reportConsolidated-Vultee BT-13B · Oxford, CTthe pilot's failure to maintain sufficient altitude/clearance from terrain. The low ceiling was a related factor in the accident.NTSB SEA95FA103Accident · 2 fatalField investigationFinal reportCessna 177RG · Kent, WAThe pilot's misjudgment of distance and altitude during the approach. Factors in the accident were the dusk light condition and the shadows.NTSB FTW95LA204Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Baytown, TXThe pilot failed to maintain the proper glidepath during landing.