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 CHI85FEI01Accident · Serious injuriesFinal reportPiper PA-32R-301T · Sandusky, OHThe acft collided with trees at night during a short final approach to land and crashed to the ground in the back yard of a private residence. The plt, who was seriously injured in the accident, said he flew a normal pattern into a 15-20 kt wind when tree…NTSB ATL85LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Conway, SCThe certificated pilot, receiving instruction from a certified flight instructor, was manipulating the controls at the time of the accident. The student undershot the runway and touched down short of the paved rwy surface. The aircraft landing gear struck the…NTSB NYC85LA041Accident · No injuriesLimited investigationFinal reportMooney M20J · Marlboro, NJPlt stated that on late final, with airspeed and descent path normal, acft encountered downdraft and collided with upslope at runway threshold before corrective action could be taken. A 60 degree left crosswind of 15 KTS existed at the time.NTSB MIA85LA030Accident · No injuriesLimited investigationFinal reportLet L-13 · Homestead, FLAccording to the plt, a downdraft was encountered on base leg causing the acft to descend and decelerate. Unable to reach the rwy the glider landed in an orchard.NTSB MKC85LA019Accident · No injuriesLimited investigationFinal reportCessna R172E · Junction City, KSPilot was experiencing communications difficulties, diverted from destination to nearby uncontrolled arpt due to traffic considerations. Plt was unable to contact UNICOM and elected to circle for traffic and wind evaluation. Best runway for wind direction was…NTSB MKC85LA014Accident · No injuriesLimited investigationFinal reportCessna 150 · Oxford, IADue to a lower than optimum glide path and turbulence, the acft landed about 100 ft short of the rwy. All 3 landing gear collapsed in the unimproved terrain.NTSB MKC85LA009Accident · No injuriesLimited investigationFinal reportPiper PA32RT-300T · Columbia, MOThe plt was high on the ILS approach and flew a VFR very low circling approach after clearance to change from rwy 2 to rwy 20. The tower controller said the acft was so low that at one point he lost sight of the acft. He advised the plt that he appeared to be…NTSB FTW85LA021Accident · No injuriesLimited investigationFinal reportCessna 152 · Bogalusa, LAThe solo student plt landed 8 to 10 ft short of the rwy and rolled into the asphalt lip of the prepared surface. Touchdown occurred in an area of construction lengthening the rwy.NTSB CHI84LA409Accident · No injuriesLimited investigationFinal reportLet L-13 · Gregory, MIAccording to the CFI the glider was at about 500 ft AGL on base leg when a downdraft caused the acft to descend and touch down 50 ft short of the rwy.NTSB FTW84LA403Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Plainview, TXThe CFI stated that at the time of the accident the private plt, in preparation for his commercial certificate, was flying a power off 'spot landing' with a desired touchdown point at the second centerline stripe. In an effort to reach the landing point with…NTSB NYC84FA314Accident · 6 fatalField investigationFinal reportPiper PA-32R-300 · Linden, NJAcft collided with utility pole during a night visual lndg. The pole is located about 583' from the rwy threshold and is 58' high. The pole was unmarked. The plt made 1 previous night lndg. At the arpt and 5 total lndgs at the arpt. The investigation did not…NTSB MKC84FCD03Accident · Serious injuriesFinal reportSchweizer SGU2-22E · Ames, IAThe glider plt who had only about 1 hour flt time in this make of glider and less than a hour total glider time misjudged the wind and after drifting downwind was unable to make it back to the arpt. A forced landing was made off arpt in a farm field.NTSB CHI84LA392Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Grand Rapids, MIIn an effort to land at the threshold the acft collided with a fence and landed short of the prepared surface. Runway edge lights were operating but runway end identifier lights were not installed.NTSB ATL84LA288Accident · No injuriesLimited investigationFinal reportCessna 182 · Waynesboro, VAThe pilot stated that while on final approach the aircraft encountered a downdraft and was forced down short of the runway. Pilot suggested that he may have also encountered possible wind shear.NTSB FTW84FA382Accident · 2 fatalField investigationFinal reportCessna 172N · Quinlan, TXA witness reported that when the plt was landing, the acft descended on final apch, got too low & collided with electric power lines. The acft then nosed down & impacted the ground in a steep nose down attitude.NTSB ANC84LA152Accident · No injuriesLimited investigationFinal reportCessna 206 · Nondalton, AKThe acft landed short of the rwy. The wind was from 280 degrees at 12 KTS gusting to 25 KTS. The plt reported that he was caught in a downdraft and full power did not slow the rate of descent.NTSB MKC84LA286Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Beatrice, NEDuring the flare an uncontrolled rate of descent developed resulting in a touchdown short of the rwy threshold. The mainldg gear struck the 5 inch exposed rwy lip. Density alt was aprx 4,200 ft.NTSB ANC84LA149Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Egegik, AKThe acft landed short of the intended landing area. The landing gear caught on brush and the acft nosed over. The plt stated there were no mechanical irregularities. The intended landing area was a dried lake bed.NTSB MIA84LA237Accident · No injuriesLimited investigationFinal reportCessna 150 · Ft. Pierce, FLThe student plt on first solo flt misjudged his alt and landed the acft about 30 ft short of the rwy in the grass. This was his instructors assessment of the accident.NTSB NYC84LA283Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-E · Charlestown, RIWhile on final approach, the left main gear contacted some brush and becoming entangled in vines followed by the propeller becoming entangled. The propeller stopped and the aircraft swung around 180 degrees coming to rest about 500 ft from the grass runway.NTSB NYC84LA286Accident · No injuriesLimited investigationFinal reportCessna 172 · Islip, NYCommunications with twr indicate plt intended to touch down as close to the end of the runway as possible. Acft touched down 20 yds short of hard surface in gravel. Rwy NOTAM stated 18 in depression at threshhold edge.NTSB FTW84LA350Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Minden, LADuring a night instructional flt on landing approach, the instructor pilot reported that the student over corrected for a high approach by closing the throttle. The acft hit the ground before he could establish control of the resulting high rate of sink.NTSB ANC84LA135Accident · No injuriesLimited investigationFinal reportCessna 170B · Kenai, AKThe plt was trying to land on a gravel oil drilling pad. The acft landed short of the pad and collided with a beam. After a bounce and a yaw the acft touched down again and the rt main landing gear failed. The plt said his selection of landing area was poor.NTSB LAX84LA433Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Coulterville, CAThe plt reported that on his apch to land, the sink rate became greater than anticipated & the right main gear hit the top of a fence. Subsequently, the right main gear collapsed & the acft veered off the rwy & hit an embankment.NTSB ATL84LA254Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Nashville, TNThe pilot reportedly set up a high rate of descent on final approach so that he could land the aircraft near the approach end of the rwy to avoid excessive braking on the wet rwy. The pilot descended the aircraft below the glide slope provided by the VASI and…NTSB SEA84LA187Accident · No injuriesLimited investigationFinal reportCessna A188B · Palouse, WAPIC stated he landed in S0FT dirt short of the 1600 ft ag strip. The acft nosed over.NTSB NYC84LA249Accident · No injuriesLimited investigationFinal reportCessna C172 · Sandy Lake, PAThe acft struck a ridge at the rwys approach end and collapsed the nose gear. The acft then slid 120 ft down the center of the rwy. The plt stated he made a normal apch for a short field landing but the acft touched down 10 ft short of the rwy. There were no…NTSB NYC84LA241Accident · No injuriesLimited investigationFinal reportCessna 152 · Mountville, PAThe student plt landed in a corn field short of the rwy on his 3rd solo landing. The plt stated that he 'misjudged the end of the rwy.' He also said he should have had a 'higher approach speed.'NTSB LAX84LA386Accident · Minor injuriesLimited investigationFinal reportLet L-13 · Llano, CAAccording to the plt, the glider did not sink as fast as expected on the downwind leg, so he extended flaps to 30 to 40 deg, used spoilers & extended the downwind. On base leg he entered an area of high sink; therefore, he closed the spoilers & angled toward…NTSB SEA84LA141Accident · No injuriesLimited investigationFinal reportCessna 207 · Anacortes, WAThe plt stated he added 10 degrees of flaps on downwind and applied full flaps on final. A rapid rate of descent was experienced 200 yards from touchdown. The pilot said he added power to arrest the sink rate. The acft collided with trees on final. The pilot…NTSB DEN84LA200Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Stratford, SDAcft touched down short of apch end of rwy and collided with a fence which surrounds the private airstrip boundry. The plt stated too much alt was lost at slow speed on final.NTSB LAX84LA357Accident · No injuriesLimited investigationFinal reportBellanca 14-13 · Coalinga, CAThe plt was #2 behind another acft. He reported that he was so intent on the acft ahead (taxiing off the rwy) that he had decided to go around. He then changed his mind & decided to land instead. The acft touched down short of the rwy. He reported that during…NTSB CHI84LA240Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Indianapolis, INPlt stated airspeed appeared too fast on final so a go-around was initiated. Power was advanced and plt raised the flaps which were full down. Plt stated, when flaps came up the acft started sinking and it settled into trees off the end of rwy. Plt stated…NTSB FTW84LA267Accident · Minor injuriesLimited investigationFinal reportMitsubishi MU-2N · Sugarland, TXThe short flight from hobby to hull airport was conducted in VFR conditions. A visual approach was made to runway 17 at hull airport. The pilot reported that he was high on the approach path when he turned to the final approach heading. He reduced power to…NTSB SEA84LA124Accident · No injuriesLimited investigationFinal reportCessna 206 · Yakutat, AKThe plt elected to land on a gravel road that was surrounded by brush with a quartering headwind aprx 30 deg from his left. While on final apch, a rapid rate of descent developed. Subsequently, the left wing tip contacted a tree top & the acft yawed to the…NTSB ATL84FU004Accident · 1 fatalFinal reportUltraflight Lazair II · Blichton, GAThe ultralight was low and flat during an approach to land. The acft was aligned with a tree, and according to witnesses, there was no evasive maneuver to avoid the obstruction. The vehicle collided with the tree about 40 ft alg and fell to the ground. No…NTSB CHI84LA202Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Ortonville, MIThe acft landed hard short of the rwy, bounced, & both landing gear collapsed.NTSB CHI84LA185Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Minneapolis, MNThe plt was in the process of buying the Cessna 172. He took off on a local flt and after doing some airwork, he returned to the arpt. On final apch to rwy 27L, the acft was observed at a low alt. It continued descending and collided with microwave landing…NTSB SEA84LA104Accident · No injuriesLimited investigationFinal reportCessna 182 · Gerlach, NVThe acft went off the 1500 ft rwy during a x-wind landing and nosed over. The plt said a gust of wind 'blew the plane too FAR down the runway, applied power, lost altitude, landed off the runway and the plane flipped upside down.'NTSB DEN84LA133Accident · No injuriesLimited investigationFinal reportCessna 150M · Boulder, CODuring final approach the acft encountered a downdraft & impacted the ground about 50 ft short of the rwy. The possibility of downdrafts at the approach end of rwy 26 was well known to local plts including the instructor plt (CFI).the CFI reported the wind…NTSB FTW84LA196Accident · No injuriesLimited investigationFinal reportBeech A23-19 · Guthrie, OKWhile on final approach the acft descended below the desired glidepath. When the plt added pwr, the engine did not respond. The acft touched down hard and short of the rwy after which the left wing contacted a tree. The plt stated he did not use carb heat…NTSB SEA84LA082Accident · No injuriesLimited investigationFinal reportCessna 172N · Harrisburg, ORThe plt reported that after the sun had set, a haze formed near the ground. He used visual references to align the acft with the private rwy at dusk. As he approached, he saw what he thought was hedge on the edge of the arpt & then made a soft field landing.…NTSB FTW84LA199Accident · No injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe student was on his 3rd solo flt, practicing touch-&-go landings. According to witnesses, the acft initially touched down short of the rwy, then bounced onto the prepared surface. The acft porpoised several times. The plt made no attempt to go around.NTSB NYC84LA111Accident · No injuriesLimited investigationFinal reportCessna 340 · Norwood, MAThe plt reported that during an instrument apch, he descended to the mda with the radar altimeter set to 415 ft. the passenger in the right front seat, who was a plt, advised that he saw the apch lights & 1 or 2 seconds later, the radar altimeter sounded. The…NTSB ANC84LA046Accident · Minor injuriesLimited investigationFinal reportCessna 180H · Soldotna, AKThe plt stated that the left wing of the acft struck small spruce trees during landing. He stated that the acft touched down 'off balance and pointed at two parked planes.' He applied power flew over the parked acft but could not avoid a large tree.NTSB NYC84LA109Accident · Minor injuriesLimited investigationFinal reportBeech 77 · West Mifflin, PAThe acft landed short of the rwy and nosed over. According to the plt he felt that the acft was low on final approach and he added power. At this time the nose pitched down and the acft contacted the ground and came to rest upside down on the paved rwy.NTSB LAX84LA208Accident · No injuriesLimited investigationFinal reportAir Tractor AT-300 · Delano, CAThe plt was making a tight, 180 degree, right turn from downwind to final when he felt a buffet. He then applied power and lowered the nose. He stated he remained in the turn to avoid power lines. The power lines were located along the left side of the rwy.…NTSB LAX84LA205Accident · No injuriesLimited investigationFinal reportBeech BE-24 · La Verne, CAThe acft collided with the ground short of the rwy during an ILS approach. The plt said he took his eyes off the panel to look outside and got off the glide slope. The plt also said the weather was below approach minimums. The ILS was checked by FAA after the…NTSB NYC84LA099Accident · No injuriesLimited investigationFinal reportCessna 402B · Penn Yan, NYThe acft entered a high sink rate during the final approach and collided with the ground. The plt managed to get the acft onto the rwy but the right main landing gear collapsed during the landing roll. A culvert is located near the approach end of rwy 28.NTSB LAX84IA204Incident · No injuriesIncident investigationFinal reportCessna 402C · Kalaupapa, HIWhile on final to rwy 23, a 20 ft wave ricocheted off the rwy embankment, striking the acft's rt flap. The plt executed a go-around & landed on rwy 05 without incident. Investigation revealed that the rt flap cable had broken.