NTSB investigations, 1987
44 cases where the first occurrence was “Undershoot”.
Cases per year
| 1982 | 102 |
|---|---|
| 1983 | 62 |
| 1984 | 60 |
| 1985 | 45 |
| 1986 | 35 |
| 1987 | 44 |
| 1988 | 30 |
| 1989 | 30 |
| 1990 | 22 |
| 1991 | 20 |
| 1992 | 33 |
| 1993 | 36 |
| 1994 | 43 |
| 1995 | 30 |
| 1996 | 28 |
| 1997 | 28 |
| 1998 | 16 |
| 1999 | 21 |
| 2000 | 17 |
| 2001 | 8 |
| 2002 | 14 |
| 2003 | 19 |
| 2004 | 18 |
| 2005 | 24 |
| 2006 | 13 |
| 2007 | 22 |
Where
Open the mapLatest cases
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 year(c.\"eventDate\") = 1987
AND 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 year(c."eventDate") = 1987 AND 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 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…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…