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 MKC88DCA03Accident · Serious injuriesFinal reportLuscombe 8A · Painton, MOPilot did not maintian the proper decent rate on the final approach to the airport.NTSB MKC88LA132Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Knobel, ARProper touchdown point not attained, and aircraft control not maintained by the pilot in command.NTSB DEN88LA136Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-160 · Ogden, UTThe low time private plt and his non-pilot wife were practicing touch and go landings. The plt used the right seat and his wife used the left seat. While on final apch, the plt recognized that the airplane was too high, added full flaps and cut the power. The…NTSB LAX88LA226Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-6-100 · Tau, AntarcticaThe captain, who was flying the twin otter from the right seat, entered a right hand traffic pattern for landing. A left quartering, 15 knot headwind, was gusting across the airport. Upon turning to the final approach the captain reduced the aircraft's engine…NTSB ATL88LA194Accident · No injuriesLimited investigationFinal reportCessna 150F · Newnan, GAAfter making a local flt, the student plt returned to the arpt, but drg the landing, the acft touched down abt 60' short of the rwy. Shortly after touching down, the nose gear sheared off. The acft then traveled abt 370 ft further before coming to rest beside…NTSB LAX88LA209Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Vacaville, CAAt the end of a pleasure flt, the plt extended the downwind leg for landing, thinking that the touchdown altitude was 12 ft instead of, in actuality, 220 ft. the plt normally flew out of another airport with an alt of 12 ft. from the extended downwind, the…NTSB DCA88IA060Incident · No injuriesIncident investigationFinal reportBoeing 747-200 · Jamaica, NYNone submittedNTSB MIA88LA174Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Geneva, FLThe pilot state that he encountered turbulence over a tree line while on short final approach. The aircraft began to sink and before the sink rate could be arrested the aircraft struck a tree. The aircraft touched down short of the runway.NTSB MKC88LA090Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T1A2 · Horton, KSThe PIC was executing touch and go lndgs when he reportedly experienced a shift in wind conditions. The acft impacted the ground short of the rwy. He said that the wings suddenly lost lift resulting in a high descent rate. The PIC reported no mechanical flt…NTSB MKC88LA087Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Waldenburg, ARThe acft was being positioned for an aerial application operation. While landing, the acft struck a 1.5 ft levee at the end of the private grass strip. Subsequently, the main gear sheared off, the wings were buckled & the prop was damaged.NTSB MIA88LA135Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Captiva, FLThe pilot allowed the aircraft to descend below the normal approach angle and failed to correct the situation timely. The aircraft struck a seawall severing first the nose gear and then the main gear. The aircraft slid to a stop.NTSB LAX88LA145Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Warner Springs, CANTSB NYC88LA098Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · West Dover, VTThe PA-28 landed short of the runway and struck a snowbank receiving substantial damage. The pilot when interviewed by the FAA said the engine did not miss and wasn't cutting out and that he would have to 'take the majority of the blame'. On NTSB form 6120.1,…NTSB ATL88LA091Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Gainesville, GAThe plt rptd that he inadvertently allowed the airplane to descend below the VASI glidepath while on short-final, and that he failed to react in time to correct the situation. The airplane subsequently impacted an embankment short of the rwy threshold, in a…NTSB NYC88LA081Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Chatham, MAAfter aborting two landings on runway 24 at Chatham, Massachusetts, the pilot was advised by radio to use runway 6. While attempting a landing on runway 6, the airplane touched down short of the runway and the landing gear was sheared off when it struck a…NTSB ANC88LA028Accident · No injuriesLimited investigationFinal reportCessna 172 · Chugiak, AKThe certified flight instructor and his student were on a right downwind doing touch-and-go landings when, according to the pilot, the engine suddenly lost all power. Attempts at restarting the engine were unsuccessful, and the airplane landed short of the…NTSB CHI88LA058Accident · No injuriesLimited investigationFinal reportBeech A36 · Pontiac, MINTSB CHI88LA055Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Barron, WIThe pilot misjudged altitude and distance and touched down short of the runway and struck a snowbank. Pax stated that the pilot cut pwr about 200 ft from the runway; the aircraft began to sink fast. The pilot applied power too late to prevent the undershoot.…NTSB MKC88FA041Accident · 1 fatalField investigationFinal reportPiper PA-31T-620 · Hazelwood, MOProper glide path not maintained by p.I.c., decision height not identified by the p.I.c., missed approach not performed by the p.I.c. turning on lights in overcast.NTSB ATL88LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Greensboro, NCThe student plt rptd that he attempted to land long to avoid snow and ice on the rwy. The airplane touched down earlier than he intended however, and contacted the snow and ice. The airplane subsequently veered off of the runway, impacted a snowbank, and…NTSB MKC88LA038Accident · No injuriesLimited investigationFinal reportCessna 177 · St. Charles, MOWhile practicing touch and go ldgs, PIC noted a significant increase in sink rate. Additional power failed to arrest the descent, and the acft struck the terrain short of the rwy causing substantial damage to the acft, and no injuries to plt and pax.NTSB DEN88LA047Accident · No injuriesLimited investigationFinal reportCessna 182G · Aurora, CON3406S was landing on rwy 32, an asphalt rwy 5,000 ft long and 40 ft wide. The rwy was clear and dry, but the terrain surrounding the rwy was covered by 12 to 15 inches of snow. The wind at an arpt 5 mi sw was from 160 deg at 5 KTS. In his rpt of the acdt the…NTSB MIA88LA050Accident · No injuriesLimited investigationFinal reportCessna A185F · Naples, FLThe plt stated that the flt was low and slow on final apch. As a result the main landing gear collided with a dirt bank located short of the rwy. The gear then collapsed and the acft slid to a stop.NTSB MIA88LA048Accident · No injuriesLimited investigationFinal reportCessna 172K · Pensacola, FLThe pvt plt flying the acft for the first time from the rt seat landed it aprx 170 ft short of the runway on soft grass. The acft rolled 6-10 ft, after which the nose gear sank & the acft then nosed over & came to rest inverted.NTSB MIA88LA038Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Melbourne, FLDuring an instructional flt while practicing accuracy touch-and-go landings, the student plt flared the acft for landing at low altitude, aprx 45-60 feet from the apch end of the rwy. The acft landed hard short of the runway. As a result the landing gear…NTSB ATL88LA029Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Sebring, OHThe airplane landed hard short of the rwy, and sustained structural damage to the ldg gear and both wings. The plt reported that he had been distracted by another airplane that entered the traffic pattern ahead of him, and had inadvertently allowed the…NTSB ANC88LA014Accident · No injuriesLimited investigationFinal reportPiper PA32 · Larsen Bay, AKThe pilot stated the wind on the surface was light and variable and while he was on final approach the airplane developed a high sink rate from which he was late effecting recovery. The airplane struck the ground short of the runway threshold.NTSB FTW88LA018Accident · No injuriesLimited investigationFinal reportPiper PA-60 · Ardmore, OKDuring landing, the aircraft touched down about 15 feet short of the runway causing the rt main gear to collapse. The acft slid approx 800 ft BEF0RE coming to rest on the rwy. Both gear penetrated the upper skin on the wings.NTSB CHI88LA016Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Union, ILThe glider was approaching to land when, according to the pilot, he noticed the aircraft was descending 'too fast' and his airspeed was 'too slow'. The pilot then realized he wasn't going to make the runway and decided to land the glider in a nearby field.…NTSB NYC88LA011Accident · No injuriesLimited investigationFinal reportCessna 402B · Nantucket, MAThe plt rprtd that drg an apch to rwy 6 at dusk, a sudden sink rate developed. He applied power & brought the acft to a climb attitude; however, he felt a 'thud beneath the aircraft' & noted that the right main gear light no longer indicated down & locked.…NTSB SEA88LA008Accident · No injuriesLimited investigationFinal reportCessna T210N · Walla Walla, WAThe pilot landed short and the aircraft's main landing gear struck the edge of a plateau at the approach end of the private strip. The aircraft swerved off the grass runway, the nose gear collapsed, and the aircraft nosed over.NTSB MKC88LA008Accident · No injuriesLimited investigationFinal reportCessna 172F · Lamoni, IAThe pilot said he was too high on final and went around. He stated that, when he was on short final during the next approach, he thought he was still too high and put down full flaps. The airplane stalled and touched down short of the runway. The nosegear was…NTSB ATL88LA016Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Brookville, OHWhile on final approach the acft began to fall below the flight path the plt desired. Remedial actions were insufficient to correct the deviation. The acft impacted short of the rwy and collapsed the landing gear. Investigation revealed the use of 40 degrees…NTSB ATL88LA011Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbia, SCThe student pilot was flying solo for the first time. Two landings had been completed successfully. The pilot misjudged the final approach and touched down short of the runway. The aircraft landed hard causing the nose gear to collapse.NTSB MKC87LA180Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Osage Beach, MOWhile performing as PIC during a biennial flt review, the CFI requested that the owner perform a short fld lndg using full flaps in cross wind conditions. The acft struck the terrain 50 feet short of the rwy and bounced onto the approach end of it. The CFI…NTSB MKC87LA173Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Festus, MOThe CFI was giving inst to a pvt plt who was undergoing a biennial flt review. The pvt plt cmpltd the maneuvers and ret to the arpt. The lndg was aborted and a go-around was made. The CFI took control and executed another appch. The pvt plt was to monitor an…NTSB FTW87FA213Accident · Serious injuriesField investigationFinal reportPartenavia P68C · New Orleans, LAThe plt began an ILS rwy 18R apch at ngt to the lakefront arpt. He rprtd that after the acft broke out of the clouds at 1700', he transitioned to a visual apch. He stated that as he contd, the apch seemed normal, except the VASI lights seemed too FAR down the…NTSB CHI87LA208Accident · No injuriesLimited investigationFinal reportCessna 172PC · Jerseyville, ILThe pilot and one passenger were returning from a local flight. It had become dark during their flight and as the pilot was approaching to land on runway 36 the landing gear of the aircraft struck a drainage ditch approximately 2-3 feet short of the runway.…NTSB CHI87FA212Accident · No injuriesField investigationFinal reportCessna 177 · Genoa, ILThe plt made a straight-in apch to land at dusk on an unlighted sod rwy. He stated he lowered 10 deg of flaps aprx 2 mi fm the rwy. While on final apch, with the power set at aprx 1800 RPM, the acft began to settle. The plt said he applied full power, but it…NTSB LAX87LA315Accident · No injuriesLimited investigationFinal reportCessna 172D · Fortuna, CAThe pilot was attempting a precautionary landing because of deteriorating weather due to fog. He undershot the runway on his landing touchdown. He said he was blinded by the approach lights but elected to continue with the landing rather than attempting a…NTSB SEA87LA184Accident · No injuriesLimited investigationFinal reportBeech C-23 · Bremerton, WAOn the pilots third touch and go an undershoot occurred during landing onto runway 1. VASI lights are available for that runway. The plt was unable to explain why the undershoot occurred.NTSB LAX87LA317Accident · No injuriesLimited investigationFinal reportBeech B-60 · Bermuda Dunes, CAThe right main landing gear hit the runway lip upon touchdown on runway 11 and collapsed. At the time of the accident the runway's overrun area was under construction and there was a nine inch lip at the runway end. The pilot was aware of the construction…NTSB ANC87LA129Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Montague Island, AKThe plt was making an apch for a soft/short field landing at a strip which paralleled the ocean shoreline on Montague Island. He stated that when he came in to land, he misjudged the height & position of bushes nr the apch end of the strip. Subsequently, the…NTSB MKC87LA166Accident · No injuriesLimited investigationFinal reportBeech B23 · Creston, IAThe PIC had planned his flt with departure originating in Iowa city, Iowa. Scattered thunderstorms were fcst and the PIC delayed his departure for abt 3 hrs. Aft assessing wx fm several sources the PIC dptd for Creston, Iowa around 9 pm LCL time. The flt…NTSB ATL87LA232Accident · No injuriesLimited investigationFinal reportPiper PA-60-602P · Ravenna, OHThe plt rprtd that drg a lndg on rwy 27, the acft touched down just short of the rwy lip. He stated that the rgt main gear hit a hole in the grass about 25 ft short of the rwy, then hit the lip. Subsequently, the rgt main gear failed & the acft veered off the…NTSB LAX87LA279Accident · No injuriesLimited investigationFinal reportCessna 320B · Bermuda Dunes, CADrg a landing, the left main gear hit a raised lip at the apch end of the rwy & failed. The plt held the left wing off the rwy by using aileron until the acft slowed, then the acft drifted off the left side. The rwy lip had been created by construction on the…NTSB ATL87LA219Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-36A · Winchester, TNThe pilot stated he circled over the airport to check for traffic then made a turn to base. He was too near the runway and too high for a normal approach. The pilot used full flaps and decreased power; however, the aircraft began to descend rapidly. The…NTSB ATL87LA208Accident · No injuriesLimited investigationFinal reportSchleicher K8B · Monroe, GAThe private plt was on his first flt of the day in a glider that he had not flown recently. He reported the takeoff, tow and traffic pattern as normal. He used the spoilers sparingly until he turned final. He was most surprised, he said, when one of the…NTSB MKC87LA132Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Russellville, ARDuring the night approach, the pilot saw the reflection of orange balls on a powerline. He added power and went over the powerline, then reduced power to land and stalled the aircraft short of the runway. The nose gear broke off and the airplane slid 200…NTSB ATL87LA199Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103A · Mt. Airy, NCThe instructor stated this was the second flight of the day with the student. They had released from an air tow at 1,500 feet AGL. The instructor was demonstrating glide slope control for best final glide. When the sailplane was about 1,000 feet AGL and one…