NTSB investigations, 1988
30 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
Latest 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\") = 1988
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") = 1988 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 ATL89LA043Accident · No injuriesLimited investigationFinal reportCessna 182 · Thomaston, GAThe pilot and three passengers were on a night flight in an aircraft that was equipped to carry skydivers. During the approach to land, the landing light failed. While attempting to get the light to operate, the pilot allowed an undershoot to develop.…NTSB MIA89LA026Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Clearwater, FLAs the student plt was making a simulated single eng apch, the instructor's attention was momentarily diverted inside the cockpit. When the instructor looked outside again, the acft was low & slow on a short final apch. The CFI applied power to arrest the…NTSB SEA89LA008Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Cashmere, WAPlt landed short of hard surface, collapsing lndg gear.NTSB ANC89LA004Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Eureka Lodge, AKThe pilot was attempting to land at dusk on a snow covered, unlighted private airstrip. He stated that he was attempting to land as close to the landing threshold as possible to avoid a large bump in the middle of the runway. He misjudged his approach and…NTSB FTW88LA166Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Fort Worth, TXThe pvt plt (PIC) was flying with an instructor (CFI), who had an expired medical certificate. The CFI stated he was flying as a safety plt only. The PIC extended his downwind leg & subsequently was low & slow on a long final apch. He raised the nose of the…NTSB NYC88DGM02Accident · Serious injuriesFinal reportBarker Quickie Q2 · Martinsburg, PAThe pilot reported he was practicing takeoffs and landings, and that he was 'determined to hold the approach speed to 80 and rate of descent to 500 feet per minute . . .' The approach was flown at dusk as light was beginning to fail. The pilot stated, 'I…NTSB ANC88LA142Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Figure 8 Lake, AKThe pilot-in-command was landing in one foot tall grass near a duck hunting shack and struck a log. He landed the airplane after striking the log and during the landing roll, the main landing gear collapsed. The plt stated that he overflew the lndg area and…NTSB FTW88DRG09Accident · Serious injuriesFinal reportSchempp-Hirth Standard Cirrus · Briggs, TXPilot's failure to maintin sufficient airspeed as he maneuvered to re-align the glider during final approach for landing. This resulted in 45-60 degree bank angle at very low altitudes, which culminated in the less of control and collision with the fence.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…