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 CHI87DEP08Accident · No injuriesFinal reportUnknown Avid Flyer · Cottage Grove, WIOn return from the second test flight in the experimental aircraft, the pilot failed to maintain the proper descent rate on short final. An attempt to add power to correct the situation was unsuccessful, and the aircraft touched down on a highway short of the…NTSB BFO87DIG07Accident · Minor injuriesFinal reportCessna 150/Horton Stol · Maysville, WVThe plt/owner was flying a Cessna 150 which was equipped with a horton stol kit. Drg an apch to rwy 3, he used an airspeed of 40 KTS. While apchg the rwy, the acft settled & the nose gear struck a bump on the apch edge of the rwy. The plt rprtd that the…NTSB NYC87LA177Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Quakertown, PAThe pilot came in high and fast on the approach. He reduced pwr initially to increase rate of descent. As he apched trees, he applied power to stop the descent, but collided with the tops of the trees. The acft yawed to the right about 30 degrees and touched…NTSB CHI87LA142Accident · No injuriesLimited investigationFinal reportSchleicher KA-6-CR · Staunton, ILThe plt stated that he climbed to 6000 feet MSL and proceeded on course to Staunton, Illinois. According to the plt in a telephone interview, he was approximately 800-900 feet above willhoit airport when he made a 360 degree turn to enter base. He further…NTSB NYC87LA166Accident · No injuriesLimited investigationFinal reportNorth American B-25N · Stow, MAThe acft touched down hard on the grassy area 5 to 10 ft short of the rwy. The plt stated at the time that he felt and heard the hydraulic line burst in the cabin which left the aircraft without brakes. The acft failed to stop and continued to roll off the…NTSB LAX87LA218Accident · Serious injuriesLimited investigationFinal reportCessna 150L · San Jose, CAWhile on final apch to land on rwy 31R at night, the acft flew too low, struck trees, then collided with the terrain. The plt was taken to a hospital with serious injuries & a blood sample was drawn at 0205 PDT. A check of his blood showed an alcohol level of…NTSB ANC87LA069Accident · No injuriesLimited investigationFinal reportFairchild C-119L · Shageluk, AKThe airplane was destabilized by a slight vertical air movement on approach. The pilot touched the airplane down short of the runway proper, collapsing the landing gear before sliding off the strip into adjacent tundra.NTSB BFO87LA035Accident · Serious injuriesLimited investigationFinal reportBeech A23 · Ravenswood, WVThe pilot was providing free promotional rides for a flight school. He was on the fourth flight of the day, on final approach, in a nose high attitude when the aircraft's left wing struck small trees. The aircraft impacted the ground 250FEET short of the…NTSB FTW87LA099Accident · Minor injuriesLimited investigationFinal reportAircoupe 415D · Lakeway, TXThe commercial pilot of an Aircoupe with one passenger on board attempted to execute an overhead 360 degree turn to land on runway 16 at Lakeway airport near austin, TX. The pilot did not have adequate altitude to complete the maneuver. The aircraft impacted…NTSB NYC87LA092Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Tunkhannock, PAThe plt was lndg on a grass rwy with an access road bordering the apch end. Across the road from the rwy threshold, there was a pile of snow which previously had been plowed from the rwy. In reference to lndg at ngt, the plt stated, 'coming in on final, I…NTSB MIA87LA085Accident · Serious injuriesLimited investigationFinal reportCessna 172I · Pelahatchie, MSThe plt stated that he was practicing emerg power-off landings, when, on final apch, realized he wouldn't clear the trees located west of the rwy. He then cleared them by adding power thought the acft then descended in a flare attitude until contact with the…NTSB NYC87FA085Accident · No injuriesField investigationFinal reportBeech 99 · Oneonta, NYThe flight was uneventful until its arrival at Oneonta municipal airport. The aircraft landed 10 feet short of runway 24IN one foot of snow. The left main landing gear collapsed, the propeller struck the runway and the aircraft veered off the left side of the…NTSB SEA87LA054Accident · No injuriesLimited investigationFinal reportRobinson R22 · Brinnon, WAWhen psgr became nauseous in flt, plt attempted downwind lndg onto pinnacle in rough terrain. Acft contacted slope short of intended point of lndg, main rotor flexed downward, severing tail boom.NTSB NYC87LA075Accident · No injuriesLimited investigationFinal reportCessna 172K · Butler, PAThe personal flight with four occupants on board landed about 40 feet short of the runway after completing two successful touch and go landings. Pilot stated that the wind was at 220 degrees at 10 knots.NTSB NYC87LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Shelburne, VTPilot misjudged height of snowbank at the approach end of the runway and allowed the aircraft to descend too low. The main gear collided with the snowbank causing substantial damage.NTSB ANC87FA028Accident · Serious injuriesField investigationFinal reportCessna 207 · Anchorage, AKThe aircraft crashed one mile short of the runway. The accident occurred during an ILS approach in instrument meteorological conditions. During a post accident interview with the pilot he stated that he did not recognize and react in a timely manner to the…NTSB ATL87LA025Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Brownsboro, ALThe student pilot was making her first supervised solo flight in the PA28-140 model aircraft. The student reported that wind and low airspeed prevented her from reaching the runway prior to landing touchdown.NTSB NYC87LA040Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Stormville, NYThe plt reported that during the landing apch, aprx 1/2 mile from touchdown, the acft descended below the visual glidepath. Recovery was attempted with the application of power, however, the acft mushed into a field short of the rwy. The acft rolled, struck a…NTSB LAX87LA053Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Perris, CAA Schweizer sgs 2-33 glider collided with a drainage ditch after a forced landing two miles short of the airport. The glider lost lift and was unable to return to the airport due to power lines in the flight path. The pilot made a 180 degree turn and landed…NTSB SEA87LA012Accident · Serious injuriesLimited investigationFinal reportLet L-13 · Boulder City, NVThe plt stated that a downdraft was encountered and an undershoot occurred while on base leg. A high sink rate developed and the plt did not take corrective action soon enough. The acft struck the ground, rolled a short distance through bushes, and across a…NTSB CHI87LA002Accident · No injuriesLimited investigationFinal reportLet L-13 · White Bear Lake, MNThe plt reported that he entered the traffic pattern for rwy 30 at aprx 900 ft and completed a right turn to base. The plt stated that while on base, he realized the aircraft was too high and deployed the spoilers halfway. As he turned to final, he stated…NTSB MKC87LA003Accident · No injuriesLimited investigationFinal reportCessna 150J · Peculiar, MOThe plt reported that the acft encountered a downdraft as he made his apch to land at his pvt strip. The wind was from 250 degs at 7 KTS, a headwind for the landing acft. The plt reported no mechanical control difficulty during final apch. The plt reported…NTSB MKC86LA198Accident · No injuriesLimited investigationFinal reportCessna 150G · Weeping Water, NEThe pilot stated that the grass runway threshold dropped off at the lip giving an impression of being too high on final approach. The aircraft struck the incline three feet short of the runway lip, buckling the nose gear. The aircraft slid to a stop off to…NTSB DEN86FTG02Accident · Serious injuriesFinal reportRarsch RV-4 · Erie, NDThe plt said he was making a short field apch to a private, sod, strip. He said he was in a shallow lt bank on final apch when he noticed the acft was in a slip and descending too fast to avoid a collision with trees 500 ft from the apch end of the strip. The…NTSB DEN86LA251Accident · No injuriesLimited investigationFinal reportCessna 172K · Monte Vista, COThe flt departed winslow, AZ, and was en route to erie, CO, when the accident occurred. The plt said he decided to divert to Monte Vista to 'take a break' and visit with his parents who lived nearby. The plt said the winds were light and variable with some…NTSB MKC86LA180Accident · No injuriesLimited investigationFinal reportPiper PA-28-150C · Junction City, KSThe c.f.I. Stated that this flight was to be an aircraft checkout of another instructor. After some air work they proceeded to a nearby airport to practice takeoffs and landings. While on final approach for a practice short field landing the aircraft…NTSB SEA86LA220Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Weippe, IDAn undershoot occurred during landing at an unlit airstrip at dusk. Shortly after touchdown the aircraft struck a six foot mound of dirt. The aircraft then nosed over inverted and slid 60 to 70 feet before it came to rest.NTSB CHI86LA208Accident · No injuriesLimited investigationFinal reportSchleicher ASW-20 · Ionia, MIAccording to the plt, at approximately 20 miles south of Ionia county airport, Ionia, Michigan, he used frontal zone lift to climb to 4600 MSL (3800 AGL), and he encountered no further lift. The plt stated that he anticipated an increase in wind gradient…NTSB NYC86LA207Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Tunkhannock, PAStudent pilot was attempting a landing at sky haven airport and landed short, bounced and landed in a left turn. At this point, the plt could not maintain directional control and ran off the runway, hit a barrel with the right gear and the acft nosed over.NTSB FTW86LRA12Accident · No injuriesFinal reportMolino PIK-20B · College Station, TXThe glider collided with trees during an off arpt landing due to lack of lift. The plt complained that flaps are not as efficient as spoilers for approach control. Plt used flaps and mushed into trees short of the intended landing area.NTSB DEN86LA226Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Durango, COThe plt was attempting to land his glider. He said that he was unable to reach the airport and elected to land in a nearby pasture. Prior to touchdown he discovered some cattle in the field but was unable to avoid a collision with one of the animals. The…NTSB FTW86LRG31Accident · No injuriesFinal reportRolladen-Schneider LS-6 · Uvalde, TXPilot of a Rolladen-Schneider LS-6 glider, N25SG, impacted terrain short of runway at Uvalde, TX airport. Pilot held U.S.-foreign private pilot certification based on german certification and was representing the aircraft manufacturer during glider…NTSB SEA86LA209Accident · No injuriesLimited investigationFinal reportLet L-13 · Issaquah, WAPlt undershot approach after encountering downdraft, collided with perimeter fence.NTSB LAX86LA296Accident · Serious injuriesLimited investigationFinal reportGlasflugel ST Libelle · Vacaville, CAAccording to witnesses the sailplane was too low on the landing appraoch and in an attempt to stretch the glide the pilot stalled the sailplane and entered a spin prior to contact with the ground.NTSB ANC86LA108Accident · No injuriesLimited investigationFinal reportCessna 170B · Blackburn, AKAcft undershot apch and crashed into a river while executing a low circling apch to land at a nearby gravel bar. Plt stated that he had been on duty for about 18 hrs, had flown 8.4 hrs that day hauling fish and that he was tired and 'playing around'. Acft…NTSB ATL86IA187Incident · No injuriesIncident investigationFinal reportCessna U206C · Bucyrus, OHThe plt was returning to the airport after transporting skydivers to altitude and while on final aprch he allowed the acft to stall & crash short of the rwy.NTSB SEA86LA157Accident · No injuriesLimited investigationFinal reportCessna 172 · Glenn'S Ferry, IDThe student pilot had to be vectored during a night x-country. During cruise, 35 miles from his destination, he became concerned about his low fuel state. He then diverted, with ATC assistance to an unlit airstrip for landing. The acft touched down short of…NTSB MKC86LA136Accident · No injuriesLimited investigationFinal reportFairchild SA-227 · Lincoln, NEFlare for touchdown ended short of the active rwy at Lincoln, Nebraska. The PIC rptd windshear on final but wind conditions were rptd as being 340 degrees at 15 KTS, a headwind for this landing. No mechanical control pblm was reportedly experienced during…NTSB ATL86LA175Accident · No injuriesLimited investigationFinal reportBeech C-23 · Fuquay-Varina, NCThe flt was a practical flt test for a commercial plt certificate. At aprx 3,000 ft the plt examiner initiated a simulated forced landing. The applicant spiraled to a modified downwind and base leg. The applicant said everything was fine until on final apch…NTSB CHI86LA157Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Griffith, INThe student plt & instructor (CFI) were on a dual instructional flt, practicing landings. During an apch to rwy 8, the student began to undershoot on final apch. As the helicopter was apchg a fence near the apch end of the rwy, he became alarmed & applied aft…NTSB MKC86LA128Accident · No injuriesLimited investigationFinal reportCessna 152 · Liberty, MOThe instructor stated that the student had done well during this dual session, and he felt that traffic pattern airwork would be appropriate. Traffic pattern entry and letdown were normal, but the student got too low and slow on the full flap final approach.…NTSB ANC86FA071Accident · Serious injuriesField investigationFinal reportPiper PA-18 · Girdwood, AKThe instructor pilot gave the student pilot a forced landing while on left base to runway 19. The student continued the approach at approximately 200 feet noticed the rate of descent increasing. The student applied full power but the airplane continued to…NTSB ATL86LA164Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G103 · Benton, TNThe glider landed short of the rwy. The plt had observed another acft on the rwy apch end and extended his base leg. During the turn to final, he deployed the spoilers. He reported that the acft experienced a high sink rate after the turn, and that he…NTSB MIA86LA166Accident · Minor injuriesLimited investigationFinal reportLet L-13 · Pensacola, FLThe pvt glider plt with a total of 47 hours of flt time departed his local field with one passenger. At about 2000 ft AGL he disengaged the aero tow and proceeded to glide for about one hour. The plt stated that when he started back to his local airport and…NTSB ATL86LA142Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Statesville, NCThe pilot allowed the aircraft to stall and touchdown short of the runway while competing in a power off spot landing competition. The pilot stated that the accident could have been prevented by simply adding power.NTSB MKC86FA113Accident · No injuriesField investigationFinal reportSwearingen SA226 · Hutchinson, KSThe capt rprtd that during arrival, the apch seemed normal until he flared to land on rwy 17. At that time, he heard a loud 'pop' as the landing gear contacted the rwy surface. Subsequently, the left main gear collapsed & the acft veered off the rwy. An exam…NTSB FTW86LA084Accident · Serious injuriesLimited investigationFinal reportBellanca 14-13 · Pearland, TXThe plt was practicing touch & go landings at a local arpt. While making his apch, he undershot the rwy and the acft collided with a ravine. The plt reported that the airspeed was too slow and alt was too low. He continued to state that he should have made a…NTSB FTW86LA081Accident · No injuriesLimited investigationFinal reportMooney M-10 · Abilene, TXWhile on final approach for runway 17 at elmdale airpark, Abilene, TX, the student pilot lost control of the aircraft when he flared the aircraft and it began to descend. The student attempted to pull back on the wheel, causing the aircraft to enter a stall…NTSB NYC86FA111Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Spring Valley, NYThe pax stated that he & the plt were at a bar where they had about three beers rpior to this flight. During the flight the pilot did several stalls and some aerobatic maneuvers. The pax was unnerved and told the plt that he wanted to return to the arpt.…NTSB NYC86FHA02Accident · Serious injuriesFinal reportGulfstream American AA-1 · Pottstown, PAThe acft collided with an embankment short of the intended rwy. A CFI waiting on the taxiway for clearance to takeoff stated that the acft appeared to be ok about 200 ft from the threshold of the rwy. Then it appeared to slip to the left and turn 90 degrees…