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 LAX83LA259Accident · No injuriesLimited investigationFinal reportCessna 421B · Buckeye, AZThe plt had made 3 night landings at the strip during the past 6 mths. The procedure that had been used for lighting thestrip was to place a vehicle at the west end with the headlights facing east down the centerline of the strip. However, on the night of the…NTSB LAX83LA224Accident · No injuriesLimited investigationFinal reportGoldwing Dragan · Gilbert, AZThe plt/owner had assembled the acft from a kit aprx 1 yr prior to the accident. He reported that the acft was not equipped with brakes. When he returned to land at the ultralight flt park, he decided to make a low, short final apch to decrease the stoppage…NTSB CHI83LA181Accident · No injuriesLimited investigationFinal reportCessna 172P · Mt. Pleasant, MIWhile on a local sight-seeing flt, the plt elected to land at mt Pleasant, MI for lunch. A low pass was made over rwy 09. The plt reported that while he was on a second approach to land, the acft encountered wind gusts and a loss of altitude. The plane's…NTSB NYC83LA099Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Erwinna, PAThe glider was on a dual instructional flight for landing practice. On the final approach to landing the glider lost lift after experiencing excessive sink and clipped the tops of trees. The glider landed short of the intended area and the wings and nose of…NTSB LAX83LA169Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Hollister, CAWhile on final apch to land at night, the right main gear of the acft struck a semi-trailer truck as the acft crossed over a highway. The centerline of the highway was located aprx 102 ft from the apch end of the rwy. The plt continued the landing & the right…NTSB CHI83LA159Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Fraser, MIThe aircraft stalled and undershot the runway landing about 100 feet short, where it collided with a ditch and nosed over. The pilot and his wife aboard the aircraft were not injured. The aircraft landed on runway 09 and the wind was from 110 degrees at 15…NTSB MIA83LA095Accident · No injuriesLimited investigationFinal reportMolino PIK 20 · Highsprings, FLThe acft crashed short of the runway during a pleasure flight. The pilot was not injured. The pilot stated that he descended below the tree line and encountered a wind shear. He traded altitude for airspeed and the acft encountered thetop wire of a fence. The…NTSB FTW83LA153Accident · Serious injuriesLimited investigationFinal reportBeech 23 · Athens, LAJust prior to the flt, a mechanic performed some minor upkeep functions on the acft & knew of no mechanical problems. He was unaware that the owner was not a rated plt. The mechanic accompanied the owner on a local flt. Subsequently, the acft crashed on the…NTSB NYC83LA073Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Quakertown, PAThe acft touched down about 1 ft short of the rwy. The left gear & wing was damaged.NTSB DEN83LA069Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Erie, COThe plt stated he encountered an unexpected downdraft or shear effect & landed approximately 102 ft short of the rwy. The acft then collided with a bar ditch located about 63 ft from the threshold folding back the main gear. The acft then slid down the…NTSB NYC83LA075Accident · No injuriesLimited investigationFinal reportBeech P35 · Beverly, MAThe approach was made at 90 mph with full flaps in winds gusting to 25K. As the plt flared for landing the right gear contacted a pot hole at the approach lip of the rwy blowing the tire causing the rear strut to push a hole into the wing skin.NTSB CHI83LA116Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Three Oaks, MIThe instructor (CFI) & his student had started flying at aprx 1900 EST. The purpose was to give the student aprx 3 hrs of night instruction. A refueling stop was made at south bend, IN. According to the student, the CFI stayed in the acft during the…NTSB MKC83FA066Accident · Serious injuriesField investigationFinal reportPiper PA-28R-200 · Wichita, KSThe acft was cleared to make the approach and to descend not below 2300 ft. the pilot descended from 3000 after he reported passing hance, the final appoach fix. He descended to 2300 ft at 500 ft a minute and leveled the acft and lowered the landing gear. The…NTSB FTW83LA118Accident · No injuriesLimited investigationFinal reportCessna 152 · Lubbock, TXDuring a touch & go landing on runway 17, the student pilot allowed the acft to touch down short. The landing gear struck a 1 ft dirt bank aprx 2 ft short of the paved runway. A NOTAM was in effect to alert plts that the first 400 ft of runway 17 & 35 was…NTSB CHI83LA110Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Cloud, MNDuring final the acft started to drift & the rate of descent increased. The plt was late in adding power & the acft touched down 75 ft short of the rwy in 20 inches of snow & nosed over.NTSB SEA83LA051Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Oregon City, ORDuring arrival at dusk, the plt made an apch to rwy 9 with a headwind at 19, gusting 30 KTS. While on final apch, the acft collided with power lines near the apch end of the rwy. The plt reported that he did not see the lines until just prior to impact, then…NTSB ATL83FKJ02Accident · Serious injuriesFinal reportLuscombe 8E · Elba, ALThe plt had received a wx briefing aprx 4 hrs before departure. He stated that on arrival, the arpt beacon light was not on & patches of ground fog were in the area. During the arrival, he approached from the south, flew north over the arpt, circled to the…NTSB LAX83LA063Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Sedona, AZWhile enroute, the plt noticed that he had lost his airspeed indication. Observing the pitot head on the wing with a flashlight, he stated that the flip-up cover was down, covering the ram tube. Unable to maintain proper airspeed, the plt inadvertently…NTSB FTW83LA068Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Portales, NMAcft collided with power lines short of the rwy. Winds were gusty 27K.NTSB MKC83LA040Accident · No injuriesLimited investigationFinal reportPiper PA-32RT · Sullivan, MOAircraft landed short of runway and collapsed right main landing gear. As aircraft slid into some brush the nose gear collapsed.NTSB ATL83LA065Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Midland, VAThe pilot and flight instructor (CFI) were on an instructional flight for a biennial flight review. The pilot reported that during the landing, the sun was in his eyes. He stated that on final approach, the aircraft encountered a downdraft and struck a…NTSB LAX83FA051Accident · Serious injuriesField investigationFinal reportCessna 172N · Casa Grande, AZThe aircraft flew into wires 34 feet above ground 800 feet from the runway at dusk. The wires were marked and both the student pilot and the instructor were aware of them. A no flap landing was being attempted. This was one of several landings made. All…NTSB ATL83FKG05Accident · No injuriesFinal reportPiper PA-28-161 · Pine Moutain, GADue to local wx conditions, the acft was receiving radar vectors to columbus, GA. Enroute to columbus, the plt elected to land at the callay gardens-harris county arpt. During final approach, he encountered a downdraft & struck several trees. He then added…NTSB CHI83LA045Accident · No injuriesLimited investigationFinal reportPitts S1S · Wonewoc, WIThe pilot stated that when he turned on final and slipped the aircraft to lose altitude. While reducing the power to idle the gear tangled in high grass (weeds), causing the aircraft to lose additional altitude. He stated the aircraft tumbled forward,…NTSB LAX83LVW01Accident · Serious injuriesFinal reportAmateur Built Quickie Q2 · Death Valley, CAThe pilot reported that when he was about 100 from the touchdown point, "the bottom fell out and we hit ground." An investigation revealed that the plane initially impacted with a 6 ft sand dune about 60 ft from the approach end of the runway. There was…NTSB NYC83LA027Accident · No injuriesLimited investigationFinal reportCessna 402 · Danielson, CTOn final the pilot realized he was late in reducing power and attempted to correct by abruptly bringing power back. A high sink rate was experienced and the pilot immediately applied full power. The aircraft impacted short of the runway.NTSB FTW83FPJ01Accident · Serious injuriesFinal reportPiper PA-28RT-201T · 3 Miles Ne Of E, OKThe aircraft struck power lines near the south end of the airport, at dusk, while on a final approach to runway 36. After striking the wires, the plane impacted the ground.NTSB ANC83FA012Accident · Serious injuriesField investigationFinal reportFairchild C-82 · Nelson Lagoon, AKThe acft landed short damaging the right boom & horizontal stabilizer. The rwy threshold is marked by light green reflective threshold markers & two red & white striped touchdown panels.NTSB SEA83LA014Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Cascade Locks, ORPlt was making a precautionary landing after encountering fog enroute. Two approaches to rwy 24 were aborted due to gusting winds. A downwind approach was then made to rwy 06. When the acft descended below the height of surrounding trees the prevailing…NTSB NYC83LA015Accident · No injuriesLimited investigationFinal reportCessna 150L · Watertown, NYThe pilot reported that he made two touch-and-go landings at the Watertown, new york intl airport. He then returned to his private airstrip in the local area. While executing a night approach to the private strip he got too low. The pilot stated that he added…NTSB LAX83FUJ02Accident · 1 fatalFinal reportHobbs B8M · Eloy, AZThe gyrocopter crashed approximately 125 ft short of & 30-45 ft to the right of the rwy threshold during proficiency flying.NTSB NYC83LA011Accident · No injuriesLimited investigationFinal reportSchweizer SGS2-33AK · Mecklenburg, NYDuring approach the pilot misjudged the wind velocity and failed to allow for strong downdrafts. The glider lost altitude 4-500 feet short of the field over a wooden area and came to rest in a nosed over position in the trees.NTSB MIA83LA007Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Bunnell, FLDuring a simulated dual engine failure the student touched down short of the runway. The right main gear struck the edge of the runway with enough force to damage the innerstrut. The instructor then took control of the aircraft, landed, and the right landing…NTSB ANC82DA101Accident · No injuriesFinal reportFairchild C-82A · Karluk, AKThe pilot reported that during arrival, the approach to landing seemed normal until just before touchdown. The aircraft touched down short of the runway threshold marks on relatively steep terrain in the safety zone. The pilot estimated that the touchdown…NTSB CHI82FA365Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Mankato, MNAt about 1530 CDT, the aircraft departed mattoon, IL on a flight to Mankato, MN. However, the pilot landed at albert lea, MN where he refueled and topped the tanks with 45.5 gal of fuel. The aircraft's usable supply was 48 gal. While refueling, he reportedly…NTSB LAX82DA352Accident · No injuriesFinal reportBellanca 14-13-2 · San Jose, CAThe acft landed short of the rwy. The plt stated he was demonstrating a 3-point landing & his attention was diverted by answering a question.NTSB ATL82DA282Accident · No injuriesFinal reportBeech C33 · Walterboro, SCPilot was not aligned with runway and was too low. When power was added and turn made to align, aircraft collided with ground short of runway. No malfunction found.NTSB FTW82DA385Accident · No injuriesFinal reportCessna 501SP · Crystal City, TXThe aircraft touched down 10 feet short of the runway. The right main gear failed when it contacted the raised lip of the runway threshold. After the gear failure, directional control was lost and the aircraft collided with fence posts. The six occupants were…NTSB ATL82DA266Accident · No injuriesFinal reportAero Commander 112 · Fayetteville, WVUpon arrival at the destination arpt, the rwy lights were off & the plt diverted to the fayette arpt. During final the acft struck a tree 200 ft from the displaced threshold of rwy 21. The tree was 13 ft above the rwy end elevation.NTSB SEA82DA156Accident · Minor injuriesFinal reportCessna 172N · Cle Elum, WAThe pilot elected to get additional cross-country and mountain flying time, so she elected to fly to Cle Elum, WA. Upon arrival, she flew over and observed the wind sock to be limp. While on approach to runway 25, she decided she was too low and executed a…NTSB NYC82DA215Accident · No injuriesFinal reportBoeing A75N1 · Bridgeport, NJReportedly, the aircraft was substantially damage when it was landed short of the runway. The right main wheel collided with a small ditch and failed. The aircraft then flipped over.NTSB FTW82DA353Accident · No injuriesFinal reportCessna 183P · Spearman, TXThe pilot reported that when he was on final approach for a night landing, the aircraft encountered a downdraft. He added power to stop the descent. However, as power was added, the nose gear struck and severed a power line and the aircraft pitched over and…NTSB ATL82DA248Accident · Minor injuriesFinal reportCessna 172M · Perry, GAThe student pilot departed Perry, GA on a solo cross-country flight to augusta and jessup, GA. He was expected to return to Perry at about 1600 EDT. The flight progressed uneventfully to jessup where it was delayed by a thunderstorm. After departing jessup,…NTSB NYC82DFJ19Accident · No injuriesFinal reportSchweizer 2-33A · Elmira, NYThe plt stated he was too high on base & started slipping to lose excessive altitude. He lost too much altitude & speed,striking the ground short of the rwy.NTSB CHI82DA328Accident · Minor injuriesFinal reportCessna 172 · Kenosha, WIN8186X crashed 300 feet short of Kenosha airport, runway 06. The pilot stated the elevator control failed to respond during the approach. However, an on-site investigation failed to reveal any mechanical failure or malfunction.NTSB CHI82FA326Accident · 1 fatalField investigationFinal reportErcoupe 415-C · Athens, MIThe acft was landing on rwy 27 which has a 350 ft displaced threshold due to 24 ft high power lines on the approach. A witness stated the plt was low & narrowly missed the wires on the first touch & go. During the second approach the plt was noticeably lower…NTSB ATL82DA246Accident · No injuriesFinal reportCessna 182P · Batesville, GAThe pilot reported that during the landing, he flared normally at what he perceived to be the runway threshold. He was surprised when he touched down hard on an upslope, about 15 feet short of the marked threshold and several feet below the runway level. The…NTSB CHI82DA317Accident · No injuriesFinal reportBeech BE-33 · New Carlisle, OHThe pilot undershot the runway during a night landing on a lighted sod runway. The aircraft collided with a dirt mound 40 yards east of the runway.NTSB MKC82DA146Accident · No injuriesFinal reportMitsubishi MU-2B-20 · Camdenton, MOThe pilot landed hard damaging the landing gear on a paved area short of the displaced threshold. Flaps were set at 20 degrees instead of 40 degrees. After initial landing, the aircraft swerved right and went off the runway.NTSB ATL82DA239Accident · No injuriesFinal reportPiper PA-38 · Huntsville, ALThe student pilot was on a flight check to obtain a private pilot certificate. The flight examiner had instructed him to stay in the pattern and demonstrate a short field approach and landing. The flight examiner stated that on final approach, the aiming…