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 NYC02LA156Accident · No injuriesLimited investigationFinal reportCessna 182Q · Cincinnati, OHThe pilot's misjudgment of distance which resulted in the airplane landing short of the runway.NTSB LAX02LA244Accident · No injuriesLimited investigationFinal reportCessna 182P · Mokelumne Hill, CAThe pilot's failure to maintain the proper glidepath and failure to follow the manufacturer's recommended flap setting of 40 degrees, which resulted in an undershoot short of the runway. Factors include the runway's upslope and short length, which likely…NTSB SEA02LA141Accident · No injuriesLimited investigationFinal reportCessna 210L · Cascade, IDThe pilot's failure to maintain the proper rate of descent on short final resulting in a touchdown short of the runway threshold. Contributing factors were the variable winds and swampy terrain at the touchdown site.NTSB ANC02LA066Accident · No injuriesLimited investigationFinal reportCessna 207 · Chevak, AKThe pilot's failure to attain the proper touchdown point resulting in an undershoot, and subsequent collision with gravel terrain.NTSB ANC02LA065Accident · No injuriesLimited investigationFinal reportCessna 185 · Skwentna, AKThe pilot's failure to attain the proper touchdown point resulting in an undershoot, and an in-flight collision with a log during the landing flare. A contributing factor in the accident was a hidden obstruction.NTSB ATL02LA133Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Picayune, MSThe pilot's misjudged the touch down point on the runway and collided with the ground short of the runway.NTSB IAD02LA048Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Fairfield, PAThe pilot's failure to attain proper runway alignment. A factor in the accident was the pilot's delay in retracting the spoilers.NTSB ANC02LA019Accident · No injuriesLimited investigationFinal reportCessna 207A · Kotlik, AKThe failure of the pilot-in-command to maintain the proper glide path to the runway during the final approach for a VFR landing.NTSB FTW02LA069Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Plainview, TXthe pilot's failure to maintain the proper glidepath, which resulted in landing short of the runway.NTSB ATL02LA036Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Bellewood, MSThe pilot misjudged the proper touched down point and collided with the ground short of the runway during an attempted landing.NTSB LAX02LA024Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Copperopolis, CAThe pilot's misjudgment of speed and altitude on final approach to landing, which resulted in a low approach and impact with a fence at the runway threshold. The impact lead to a subsequent loss of control and nose over.NTSB CHI01LA317Accident · No injuriesLimited investigationFinal reportBeech 200 · Indianapolis, INThe pilot not maintaining the proper ILS glide slope during the approach and the pilot not executing a missed approach. Contributing to the accident was the rain/mist.NTSB IAD01LA043Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Painesville, OHThe pilot's failure to maintain the proper descent rate and the flight instructor's inadequate supervision.NTSB LAX01LA122Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Gila Bend, AZFailure of the CFI to properly supervise the flight and the failure of the dual studen to maintain flying airspeed. A contributing factor was the wind shear encountered.NTSB CHI01LA096Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Appleton, WIThe misjudged glidepath and the intentional engine shutdown by the pilot. Factors were the false indication of the landing gear down light and the approach light.NTSB NYC01LA078Accident · No injuriesLimited investigationFinal reportCessna 172P · Miamisburg, OHThe pilot's failure to attain the proper touchdown point. Factors included the nighttime conditions, and the pilot's improper decision to leave the runway lighting at high intensity.NTSB CHI01LA071Accident · No injuriesLimited investigationFinal reportCessna 152 · Ann Arbor, MIThe CFI's delay in iniating remedial action to arrest the sink rate which developed on final approach. Factors associated with the accident were the student pilot failed to maintain a proper glidepath on final approach and the snow bank which the airplane…NTSB ANC01LA028Accident · No injuriesLimited investigationFinal reportCessna 172 · Atmautluak, AKThe pilot's failure to maintain a proper glidepath during final approach. A factor associated with the accident was soft terrain.NTSB CHI01LA056Accident · No injuriesLimited investigationFinal reportCessna 150M · Allegan, MIThe proper glide path not maintained by the pilot. A factor to the accident was the deep snow.NTSB LAX01FA032Accident · 1 fatalField investigationFinal reportCessna 340A · Selma, CAThe pilot's improper decision to attempt a visual approach and landing in instrument meteorological conditions and his failure to follow instrument flight rules procedures.NTSB LAX01LA030Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Dayton Valley, NVThe pilot's failure to attain a proper glide path during the final approach resulting in an undershoot of the runway. Factors were the lack of runway lights and night lighting condition.NTSB DEN01LA010Accident · No injuriesLimited investigationFinal reportOtero-Pitts PT1 · Albuquerque, NMA hard landing, which exceeded the design stress limits of the aircraft. Factors were the pilot's lack of experience in aircraft make and model and improper recovery from a bounced landing.NTSB CHI01LA027Accident · Minor injuriesLimited investigationFinal reportForney F1A · Austin, MNthe proper glide path not being maintained by the pilot which resulted in the proper touchdown point not being obtained during the approach. A factor to the accident was the rising embankment.NTSB NYC00LA254Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Factoryville, PAThe pilot's failure to attain the proper touchdown point.NTSB LAX00LA291Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Avalon, CAThe pilot's inadequate compensation for the downdraft condition and subsequent failure to maintain proper glide path. A factor in the accident was the upsloping runway and nature of the terrain around the runway, which presented an optical illusion and lead…NTSB ATL00LA071Accident · Minor injuriesLimited investigationFinal reportRyskamp Sonex · Greenville, SCThe pilot's misjudgment of airspeed and altitude resulting in an undershoot.NTSB FTW00LA215Accident · Minor injuriesLimited investigationFinal reportCessna 210D · Lubbock, TXThe pilot's improper aircraft handling as a result of his alcohol impairment.NTSB CHI00LA193Accident · No injuriesLimited investigationFinal reportSchleicher K8B · Manchester, MIthe downdraft experienced during final approach and altitude/clearance from the fence post not being maintained by the pilot. A factor to the accident was the fence post.NTSB NYC00LA167Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Cheswold, DEThe instructor's delayed remedial action. Factors included the instructor's failure to take positive control of the airplane, and the student's failure to maintain adequate airspeed during the approach.NTSB IAD00LA047Accident · Serious injuriesLimited investigationFinal reportMooney M20K · Grt Barrington, MAThe pilot's failure to perform a go around and his inadequate recovery from a bounced landing. Factors in the accident were the pilot's s failure to maintain the proper glide path and to reach the proper touchdown point.NTSB MIA00LA165Accident · No injuriesLimited investigationFinal reportLet L-13 · Pensacola, FLThe student's failure to maintain the proper landing pattern altitude resulting in an undershoot during landing and collision with a fence. A factor in the accident was the pilot's failure to realize the spoilers were still deployed during the undershoot.NTSB LAX00LA201Accident · 1 fatalLimited investigationFinal reportIssoire-Aviation PIK-30 · Minden, NVThe pilot's inadequate in-flight planning/decision to attempt to make it back to the runway for landing after experiencing a loss of lift and not maintaining a proper descent rate.NTSB ANC00LA055Accident · No injuriesLimited investigationFinal reportBell 206B · Haines, AKThe pilot's failure to attain a proper touchdown point.NTSB ANC00LA038Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Fairbanks, AKThe pilot's misjudgment of distance/altitude, and subsequent undershoot during landing. Factors in the accident were light snow precipitation, flat light conditions, snow-covered terrain, and the absence of a visual approach slope indicator.NTSB LAX00LA117Accident · No injuriesLimited investigationFinal reportPiper PA-46-310 · Palo Alto, CAThe pilot's failure to obtain/maintain the proper visual glide path resulting in an undershoot and collision with the runway edge.NTSB LAX00LA065Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Fallbrook, CAthe pilot's misjudged altitude and distance during a night landing approach, which resulted in an undershoot.NTSB LAX00LA058Accident · No injuriesLimited investigationFinal reportO'Hara Bob Bakeng Duce · Carson City, NVThe pilot's misjudged distance/altitude during final approach to landing, which led to an undershoot and subsequent collision with obstacles.NTSB NYC00LA041Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Annapolis, MDThe pilot's failure to adequately adjust engine power to compensate for the winds on final approach.NTSB CHI00LA026Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Rochester, INthe pilot did not obtain the proper touchdown point. Factors included the closed runway and the culvert.NTSB CHI99LA331Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Forest Lake, MNthe pilot's misjudging the proper glidepath, and his not maintaining airspeed. Factors were the pilot's lack of recent experience, the airplane's inadvertent stall, and the fence.NTSB FTW99LA243Accident · Serious injuriesLimited investigationFinal reportLet Blanik L-13 · Jonesboro, ARThe pilot's misjudgment of distance/altitude during the final approach to landing, resulting in an undershoot, and collision with a power line pole.NTSB NYC99LA215Accident · No injuriesLimited investigationFinal reportLet L-33-SOLO · Wellington, OHThe pilot's failure to attain the proper touchdown point. A factor related to the accident was a downdraft.NTSB NYC99LA186Accident · Minor injuriesLimited investigationFinal reportPitts S-2A · Pittstown, NJThe pilot's failure to obtain the proper touchdown point.NTSB FTW99LA200Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Alvaredo, TXThe student pilot's failure to maintain a proper glidepath during his short-field approach.NTSB SEA99LA121Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Silverdale, WAThe pilot-in-command's misjudgment of distance/altitude (undershoot) on final, and his failure to maintain directional control during the aborted landing.NTSB ANC99LA092Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Juneau, AKThe pilot's failure to maintain rotor rpm, and an inadequately planned approach. A factor associated with the accident was a tailwind.NTSB MIA99LA193Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Monroe, GAthe pilot-in command's improper handling and inflight decisions resulting in an undershoot of the intended landing runway. The pilot-in-command then failed to maintain airspeed, which resulted in a stall and the right wingtip impacting the ground.NTSB CHI99LA189Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Cirrus · Hartford, WIthe reason for the occurrence was undetermined. Factors were the pilot's deploying of the drogue chute, the drogue chute malfunctioning, a dirt embankment, and encountering unsuitable terrain during landing.NTSB NYC99LA143Accident · No injuriesLimited investigationFinal reportFlaherty RV-6 · Jeannette, PAThe pilot-in-command misjudged altitude during a simulated forced landing.NTSB LAX99LA206Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · St. David, AZThe pilot's failure to maintain an adequate reference approach airspeed for the existing gusty wind conditions, and, his improper (uncoordinated) use of the pitch and power controls to arrest the resulting high sink rate.