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 ATL92FA153Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Waynesboro, GAThe pilot misjudged his distance and altitude during final approach as a result of his alcoholic impairment of efficiency and judgement. A factor which contributed to the accident was the dark night.NTSB FTW92LA193Accident · No injuriesLimited investigationFinal reportCessna 172F · Lubbock, TXThe pilot under instruction misjudged his distance and altitude during a simulated forced landing, and the CFI failed to take timely action to prevent the accident as a result of his alcoholic impairment of efficiency and judgement.NTSB LAX92LA266Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Coalinga, CAThe failure of the pilot to maintain the proper glide path during the night VFR approach which resulted in a landing undershoot and a subsequent collision with the raised asphalt lip of the runway edge.NTSB DEN92LA070Accident · No injuriesLimited investigationFinal reportCessna 152 · Mckinney, TXThe student pilot misjudged his landing and landed short of the runway. A factor was: lack of total experience on the part of the student pilot.NTSB LAX92LA253Accident · No injuriesLimited investigationFinal reportPiper PA-60-700P · Coalinga, CAThe pilot's failure to attain the proper touchdown point and misjudging the aircraft's distance from the runway. Contributing to this accident was the crosswind condition and the nose and main landing gear collapsing due to overload.NTSB CHI92LA168Accident · No injuriesLimited investigationFinal reportCessna 172M · Hastings, MIThe pilot-in-command's misjudgement of the touchdown point which resulted in an undershoot and damage to the elevator. In addition, the pilot-in-command failed to properly inspect the airplane for damage prior to further flight.NTSB BFO92LA075Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Johnstown, NYThe pilot misjudged altitude and distance which resulted in a landing undershood. Contributing to the accident was night conditions.NTSB CHI92LA123Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Brookfield, WIFailure of the pilot (CFI) to attain the proper touchdown point for landing. Factors related to the accident were: the unfavorable wind condition, the excessive descent rate that developed on final approach, and the cfi's delay in taking remedial action to…NTSB CHI92LA122Accident · No injuriesLimited investigationFinal reportCessna 150F · Centralia, ILThe pilot's failure to maintain the proper altitude during the final approach to landing. A factor in the accident was the pilot's delayed remedial action.NTSB BFO92LA042Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Stevensville, MDThe certificated flight instructor's (cfi's) inadequate supervision during the simulated emergency landing. Soft terrain in the touchdown area was a related factor.NTSB SEA92LA060Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Vancouver, WAThe pilot's failure to maintain the proper rate of descent.NTSB FTW92LA086Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Harrison, ARThe pilot's failure to attain the proper touchdown point, and his failure to maintain the proper descent rate.NTSB NYC92LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Fredericksburg, VAThe failure of the pilot to maintain the proper glide path. Factors related to the accident were delayed remedial action by the pilot and night conditions.NTSB CHI92LA097Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Alpena, MIThe student pilot's failure to attain the proper touchdown point. Related factors are his misjudged approach and failure to take remedial action.NTSB ATL92LA048Accident · Serious injuriesLimited investigationFinal reportPiper PA32-300 · Hickory, NCWhile on final approach for a visual landing, the pilot reported an unspecified problem to the flight service station and elected to go around. The airplane crashed 300 feet short of the runway on the second approach. Examination of the accident site…NTSB ANC92LA033Accident · 1 fatalLimited investigationFinal reportStinson 108-2 · Cube Cove, AKThe encounter of windshear during the final approach and the pilot's improper in flight planning and decisions by electing to land downwind. Factor in this accident was the rough and uneven terrain.NTSB ANC92LA034Accident · No injuriesLimited investigationFinal reportCessna 150 · Fairbanks, AKThe pilot misjudged the altitude necessary for terrain clearance on the final approach. Factors which contributed to the accident were the snowbank and the dusk lighting conditions.NTSB SEA92LA035Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Newberg, ORA poorly planned final approach. Factors in the accident were: proper glidepath was not maintained and inadequate remedial action.NTSB MIA92LA055Accident · No injuriesLimited investigationFinal reportCessna 182Q · Eustis, FLThe pilot misjudged altitude and distance resulting in undershooting the landing. Contributing to the acident was the dark night condition.NTSB LAX92LA075Accident · No injuriesLimited investigationFinal reportPiper PA601P · San Diego, CAThe pilot's poorly planned approach and delay in accomplishing the proper remedial action while executing a night short field landing at an adequately lighted airport. Contributing to the accident was the failure of the pilot to maintain the proper glide…NTSB SEA92LA033Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Toledo, WAThe pilot's failure to maintain a proper glidepath.NTSB LAX92LA077Accident · No injuriesLimited investigationFinal reportPiper PA46-310P · Carson City, NVThe failure of the pilot to arrest an excessive sink rate resulting in not attaining the proper touch down point and landing short of the runway threshold. Contributing to the accident was an excessive runway end lip due to inadequate runway end maintenance.NTSB ANC92LA020Accident · No injuriesLimited investigationFinal reportStinson 108 · Chugiak, AKThe pilot failed to maintain proper altitude during the final approach. Contributing to the accident was the pilot's lack of total experience performing landings in reduced light conditions, the poor light condition at dusk, and the snow covered terrain.NTSB CHI92LA040Accident · No injuriesLimited investigationFinal reportMooney M20J · Morris, MNFailure to maintain proper glidepath. A factor related to the accident is the failure to perform remedial action, the dark night, and the snow shower in progress at the time.NTSB ATL92LA028Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Ramseur, NCThe pilot's improper compensation for the wind conditions. The gusty crosswind was a factor in the accident.NTSB FTW92GA036Accident · No injuriesFinal reportBeech C-12C · Belen, NMThe pilot's failure to land at the proper touchdown point.NTSB CHI92LA029Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Howell, MIProper glidepath was not maintained resulting in an undershoot. A factor related to the accident was dark night flying conditions.NTSB BFO92LA008Accident · No injuriesLimited investigationFinal reportMooney 20F · Basye, VAThe pilot misjudged the altitude and distance to the runway. Factors were the gusty weather conditions and the pilot's delay in executing a go around.NTSB ANC92FA006Accident · No injuriesField investigationFinal reportBeech BE-99 · Allakaket, AKWas the pilot-in-command misjudged the proper touchdown point on the runway. Contributing to the accident was the snow-covered terrain and a snowbank.NTSB LAX91LA408Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Fremont, CAThe pilot failed to adequately compensate for the prevailing wind conditions.NTSB CHI91LA304Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Atchison, KSDelayed remedial action by the pilot in command. Factors related to the accident are a misjudged approach by the pilot in command, and complacency on the part of the FAA inspector.NTSB LAX91LA349Accident · No injuriesLimited investigationFinal reportLet L-13 · Byron, CAThe on ground collision with a hidden ditch not visible to the pilot during the landing roll out phase of a forced landing.NTSB ANC91LA100Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Naknek, AKThe pilot misjudged the proper touchdown. Contributing to the accident was the gust of wind on final approach.NTSB SEA91LA147Accident · No injuriesLimited investigationFinal reportLet L-13 · Driggs, IDThe pilot misjudged his distance and altitude to the runway during the approach and failed to attain the proper touchdown point for landing. His lack of experience in the make and model of glider was a related factor.NTSB CHI91LA188Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-34 · Highland, ILThe pilot misjudged his touchdown point.NTSB CHI91LA172Accident · No injuriesLimited investigationFinal reportCessna 152 · Greenville, ILThe pilot in command's misjudgment of the proper touchdown point. An associated factor is the pilot-in-command not performing remedial action.NTSB ATL91IA094Incident · No injuriesIncident investigationFinal reportBoeing 727-223 · Nashville, TNThe captain's failure to maintain a proper glide path after disconnection of the autopilot during the final approach. Factors in this accident were: the captain's failure to follow company procedures for category ii approaches, the first officer's failure to…NTSB ANC91LA055Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Eek, AKWas the hard landing caused when the pilot encountered a downdraft during the final approach portion of the landing. Contributing to the accident was the downdraft and the dirt/river bank just short of the runway.NTSB CHI91LA136Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Grayslake, ILThe instructor's inadequate compensation for wind conditions. Factors were the wind gusts and the instructor's failure to maintain airspeed.NTSB FTW91LA057Accident · No injuriesLimited investigationFinal reportCessna 195B · Mc Kinney, TXThe pilot's landing short of the threshold and loss of directional control.NTSB BFO91LA022Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Mitchellville, MDPilot failure to maintain altitude clearance above an obstacle after the aircraft encountered a downdraft.NTSB FTW91LA013Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Fort Worth, TXThe pilot's misjudgment of airplane attitude, airspeed and distance while on final approach. A factor was the instructor pilot's inadequate supervision.NTSB DEN90LA194Accident · No injuriesLimited investigationFinal reportCessna 152 · Erie, COThe student pilot's misjudgement of distance and altitude, and the instructor's inadequate supervision.NTSB SEA90LA164Accident · No injuriesLimited investigationFinal reportCessna A185F · Ovando, MTThe pilot's misjudgement of altitude and distance to the runway, while on final approach, and his failure to attain the proper touchdown point for landing. The fence was a related factor.NTSB CHI90LA231Accident · No injuriesLimited investigationFinal reportHughes 369E · Grand Forks, NDThe instructor pilot's (cfi's) delay in taking remedial action after he and/or the student failed to attain the proper touchdown point for a run-on landing. Factors related to the accident were: the proximity of the barracade and the student's delay in…NTSB SEA90LA150Accident · No injuriesLimited investigationFinal reportGlasflugel H 301 Libelle · Thompson Falls, MTA disabled aircraft blocking the active runway.NTSB NYC90LA174Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Hilltown, PAThe pilot receiving training misjudged the airplane's distance from the runway and altitude above the trees. In addition, the CFI failed to provide adequate supervision.NTSB NYC90LA146Accident · No injuriesLimited investigationFinal reportde Havilland DH-82-A · Burlington, CTThe pilot's inadequate compensation for the wind condition.NTSB SEA90LA110Accident · No injuriesLimited investigationFinal reportCessna 340A · Priest River, IDThe pilot's misjudgement of distance and altitude and his failure to maintain an adequate airspeed during the landing approach.NTSB DEN90LA133Accident · No injuriesLimited investigationFinal reportPiper Aerostar 601P · Brigham City, UTThe pilot's failure to attain the proper touchdown point.