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 SEA82DA141Accident · No injuriesFinal reportPiper PA-28-161 · Olympia, WAThis was the student pilot's first night flight. The instructor pilot reported that on the second landing, the aircraft struck an elevated set of approach lights, short of the runway.NTSB CHI82DA306Accident · No injuriesFinal reportCessna 172 · Strongville, OHDuring a touch-and-go landing, the nose gear collided with wires about 1/4 mile short of the runway and the aircraft nosed over into trees. No malfunctions in the equipment were reported. The pilot reported that prior to impact, he was aware of the wires and…NTSB CHI82DA305Accident · No injuriesFinal reportBeech E-33 · Frankfort, ILThe accident occured when the pilot was on his final approach to land. The pilot inadvertently touched down 100 feet short of the runway threshold and during the subsequent landing roll the aircraft struck an embankment.NTSB NYC82DA185Accident · No injuriesFinal reportGrumman AA-5A · Wiscasset, METhe student pilot was making an approach and was low and slow. By the time the instructor took over the aircraft the recovery was slow and the aircraft touched down in rough terrain 500 feet short of the runway. The nose gear snapped offduring landing.NTSB SEA82DA131Accident · No injuriesFinal reportCessna 172N · Roche Harbor, WAThe pilot flew to a private airstrip that was open to grazing animals. During arrival, he made a low pass to check that the runway was clear of animals and other obstructions. He then circled to land. During final approach, he noticed sheep coming onto the…NTSB CHI82DA269Accident · No injuriesFinal reportCessna 172N · Isle, MNThe pilot was on a cross-country flight and began an approach to a private airstrip. He reported that the weather conditions were good with light turbulence. About 100 ft from the threshold, the aircraft began to settle and the pilot added power. However, the…NTSB LAX82DA268Accident · No injuriesFinal reportCessna 150L · Chowchilla, CADuring practice flight the aircraft was landed short of runway and bounced several times. Damage was discovered on a subsequent flight.NTSB DEN82DA135Accident · No injuriesFinal reportBeech A23 · Oakes, NDDuring a night landing, the aircraft touched down about 220 ft short of the approach end of the runway. Reportedly, the wheels struck a "washout" and the plane was substantially damaged.NTSB MKC82DA121Accident · No injuriesFinal reportPiper PA-28-180 · Lawrence, KSThe pilot entered the traffic pattern for landing on runway 19. He stated he was not aware of construction on the runwayuntil the aircraft's nose was lowered during the landing roll. By then, the aircraft's speed was too slow to go-around. He turned off the…NTSB DEN82DA134Accident · No injuriesFinal reportPiper PA-28RT-201 · Englewood, COWhile practicing power off approaches the pilot undershot the runway and landed short. Power was added but not soon enough to prevent an accident. The aircraft contacted the ground, turned 90 degrees, slid 50 yards and stopped.NTSB LAX82DA254Accident · No injuriesFinal reportBlanik L-13 · Murrieta, CAPilot landed short of runway in a glider and impacted the ground at high speed with high sink rate. He had released early from an aerotow and descended at high airspeed with dive brakes open which accelerated his rate of sink. He was not injured in the…NTSB CHI82DA244Accident · No injuriesFinal reportFairchild 24R-46A · Franklin, WIThe pilot took off and remained in the traffic pattern to land on runway 27. He estimated that the wind was from 300 degrees at 10 knots. He reported that on final approach, he got too low; then about 200 ft short of the runway, his head wind was blocked by…NTSB MKC82DA119Accident · No injuriesFinal reportGulfstream AA-5B · Mankato, KSDuring a flight from des moines, Iowa to lamar, Colorado, the pilot elected to land at Mankato, Kansas for fuel. Reportedly, the pilot landed on runway 17 with the wind from 190 at 18 gusting 24 knots. The pilot stated that he established a steep, no flap,…NTSB NYC82DA145Accident · No injuriesFinal reportPiper PA-23-250 · Ludlow, VTThe pilot stated that during the landing, he encountered wind shear and the aircraft touched down about two feet short of the runway. He reported a 30 degree slope at the lip of the runway. All of the landing gear failed. The aircraft slid off the runway and…NTSB NYC82DA135Accident · No injuriesFinal reportPiper PA-28-140 · Ambler, PAThe student pilot stated that during the landing approach, she experienced windshear resulting in the aircraft landing short of the intended touchdown point. The nose gear and the left main gear were sheared off after the aircraft collided with a dirt…NTSB MKC82DA111Accident · No injuriesFinal reportGrumman AA1C · St. Louis, MODuring a dual training flight the aircraft was allowed to descend into a corn crop short of the runway. The aircraft continued to the runway but landed hard and collapsed the landing gear.NTSB DEN82DA122Accident · No injuriesFinal reportCessna 340 · Las Animas, COThe aircraft collided with a four foot high irrigation ditch 50 feet from the approach end of runway 8 during short final. The pilot stated that he had planned the touch down point close to the end of the runway because the runway was only 3800 feet long.…NTSB FTW82DA290Accident · Minor injuriesFinal reportRyan Aeronautics ST3KR (PT 21) · Friendswood, TXThe student pilot took off with a passenger to practice landings. On the second landing, the aircraft collided with a ditch short of the runway and flipped inverted.NTSB SEA82DA107Accident · No injuriesFinal reportCessna U206 · Dry Bay, AKThe pilot reported that he arrived in marginal VFR weather conditions with rain and variable winds gusting to 12 knots. He stated that the windsock favored a landing to the east, downhill, to a wet grass runway. He reported that during a short field approach,…NTSB LAX82DA221Accident · Minor injuriesFinal reportWeatherly 201B · Greenfield, CAThe pilot took off with 1150 lbs of sulfur dust and a full load of fuel. When he arrived at the field to be dusted, he was unable to dispense his load due to the presence of laborers in an adjacent field. When the pilot returned to the airport with his load,…NTSB CHI82FA209Accident · No injuriesField investigationFinal reportCessna 421 · Racine, WIThe plt stated he experienced moderate to severe turbulence enroute. A coupled ILS approach was flown without problems, but the plt stated he had to work hard. The flt broke out at about 1,000 ft MSL & at this time he acquired visual contact with the rwy. He…NTSB FTW82DA218Accident · No injuriesFinal reportBeech 35 · Terrell, TXWhile en route, the cabin door of the aircraft popped open, approximately 10 miles from the destination. The pilot reported that he was distracted by the open door and lost airspeed while on final approach. The aircraft touched down hard just short of the…NTSB ATL82DA156Accident · No injuriesFinal reportPiper PA-23-250 · Auburn, ALWhile on a downwind for a landing in multi-engine training, the nose gear would not extend. All efforts to extend the nose gear, including a bounced landing, were unsuccessful. The aircrew intended to land on the main gear and then hold the nose off until the…NTSB FTW82DA200Accident · No injuriesFinal reportCessna 177 · Dallas, TXThe pilot stated that the aircraft made initial contact in the sod area at the northwest end of runway 12. The 1982 Texas aeronautical commission airport directory diagram of the airport shows this area to be an overrun area.NTSB ANC82DA043Accident · No injuriesFinal reportArctic S1B2 · Near Big Lake, AKThe purpose of the flight was to provide dual instruction to a rated single-engine-land pilot in basic float plane training. After practicing a number of landings, the instructor (ip) simulated an engine-out by reducing the power to 1000-1200 RPM. At this…NTSB ANC82DA042Accident · No injuriesFinal reportCessna U206 · Ouzinkie, AKDuring arrival, the pilot made his landing approach over the village so as to land the float plane on the bay and into a 30 knot head wind. While on final approach, the aircraft's rate of descent increased. The pilot added full power and started to raise the…NTSB ATL82DA134Accident · No injuriesFinal reportCessna 150M · Hagerstown, MOOn final approach the student pilot felt the aircraft sink and realized she was not going to make the runway. Simultaneously power was applied and the nose of the aircraft was pulled up in an attempt to reach the runway. The aircraft stalled and nosed over…NTSB MKC82DA074Accident · No injuriesFinal reportBellanca 8KCAB · Hayitt, MOThe pilot stated that he came in slightly low on final to avoid crossing a road that ran through the center of the airstrip. The wheat field at the south end of the strip blended in with the colors and texture of the runway. The landing gear caught the tall…NTSB ATL82DA128Accident · No injuriesFinal reportCessna A150L · Greensboro, NCWhile landing the pilot reported his misjudgement caused him to undershoot and touchdown short of the runway. The pilot stated he touched down hard on the left main gear and suggested that the nose gear failed to the right, possibly prior to contact with a…NTSB SEA82DA066Accident · No injuriesFinal reportCessna 150F · Grande Ronde, ORThe student pilot stated that on landing approach the sun was in his eyes. The landing occurred about 50 feet short of the runway threshold when the tail collided with a fence post and the nose wheel contacted a ditch.NTSB LAX82DA158Accident · No injuriesFinal reportPiper PA-28-161 · North Las Vegas, NVDuring an instructional flight the instructor was demonstrating a short field landing using the minimum length of the runway. On final the aircraft hit a dirt bank separating the right main landing gear. The instructor stated there were no markings on the…NTSB CHI82DA139Accident · No injuriesFinal reportCessna 150M · Cortland, OHThe pilot stated that he was on final approach with flaps at 40 degrees and with an airspeed of 60 mph. The tail of the aircraft collided with a high tension wire forcing the nose down into a rail airport fence. The weather information for denman field was…NTSB CHI82DA131Accident · No injuriesFinal reportHartman KR-II · Columbus, OHOn final approach the aircraft settled and collided with trees that were located approximately 75 ft from the approach end of the runway. The pilot stated that he allowed his airspeed to become too slow and that he applied power but the right wing caught a…NTSB ATL82FKG11Accident · 2 fatalFinal reportCessna 210 · Lexington, GAIn the early morning hours on 4/23/82, the aircraft departed covington, GA and proceeded on an undetermined route. At about 2300 PST that night, residents near the accident site heard the sounds of a crash. The wreckage was found the next morning about 1000…NTSB ATL82DA108Accident · No injuriesFinal reportBeech C23-180 · Greensboro, NCThe pilot stated that he experienced a failure of the right brake system preventing him from maintaining directional control during ground roll after landing on runway 09. The mechanic who removed the aircraft from the accident scene reported that tire tracks…NTSB MKC82DA066Accident · No injuriesFinal reportBeech B-19 · West Union, IAThe pilot was flying his newly purchased aircraft from cedar rapids, Iowa to West Union, Iowa. He had purchased the aircraft on the previous day and had received a checkout from the seller. The pilot reported that when he was on final approach, the aircraft…NTSB DEN82DA064Accident · No injuriesFinal reportSchweizer SGS-2-33A · Colorado Spring, COThe student pilot reported that he came over the airport at about 1200 ft AGL to enter a downwind for landing. He stated that he encountered a moderate to strong sink and strong southerly winds. He estimated that the wind velocity was 45 to 50 mph at 1000 ft…NTSB CHI82DA120Accident · No injuriesFinal reportPiper PA-34 · Gaylord, MIDuring a night visual approach the aircraft landed about 90 ft short of the runway. The aircraft slid across the ground onto the runway pavement and swerved to the right striking a runway light and ending up on a snowbank.NTSB NYC82DA071Accident · No injuriesFinal reportPiper PA-28-181 · Allentown, PADuring final approach the landing gear collided with a snowbank and the aircraft skidded on its nose and main landing gear, coming to rest approximately 30-50 yards from the approach end of the runway.NTSB FTW82DA116Accident · Minor injuriesFinal reportRyan Navion A · Center, TXThe aircraft landed short of the runway, hit an embankment and collapsed the landing gear. The pilot believes wind shear and turbulence were a factor in the downdraft off the end of the runway.NTSB SEA82DA042Accident · No injuriesFinal reportCessna 150H · Camas, WADuring the pilot's sixth touch and go landing the aircraft struck a tree on short final. The pilot maintained control of the aircraft and completed his landing.NTSB ANC82DA029Accident · No injuriesFinal reportCurtiss-Wright C-46A · Wulik River Str, AKDuring arrival, the pilot noted that there was a cargo plane being unloaded at the end of a 4100 ft, snow covered runway. He elected to land from the opposite end within the first 4000 ft. the wind was calm. During the landing flare, the right main gear…NTSB LAX82FUQ12Accident · 1 fatalFinal reportCessna 150M · Oxnard, CAThe student pilot departed hawthorne, CA at approximately 1000 PST on a solo cross-country flight to porterville, CA and return. During the flight the pilot became lost and landed at visalia, CA. While there he obtained fuel and directions to porterville and…NTSB LAX82DA115Accident · No injuriesFinal reportCessna 152 · Winslow, AZThe pilot stated that he did a touch and go on runway 29, then pulled the power off at approximately 300 ft AGL over the intersection of runways 29 and 22. He reported that from there, he attempted to land on runway 22 with no power, failed to maintain…NTSB ATL82DA082Accident · Minor injuriesFinal reportCessna 177 · Jefferson, GADuring arrival, the wind shifted favoring runway 27. The pilot reported that he started his final approach at 80 mph and then slowed to 60 mph as he approached the threshold. Just as the aircraft crossed over a treeline, the aircraft suddenly dropped and hit…NTSB ATL82FLJ06Accident · 2 fatalFinal reportBede BD-4 · Knightdale, NCTwo witnesses observed the aircraft on a low final approach for runway 19. They reported that the aircraft then turned to an easterly heading. One witness reported that the left turn appeared to be coordinated. The other witness heard the pilot add power…NTSB NYC82FNC05Accident · Serious injuriesFinal reportCessna 210 · Carrabassett, MEDuring a straight-in approach to runway 35, the aircraft touched down short of the threshold. It decelerated rapidly in deep packed snow, slid over a snow bank, and came to rest on the paved runway. The nosewheel collapsed and the pilot suffered serious head…NTSB DEN82DA042Accident · No injuriesFinal reportBeech A36TC · Boulder, COThe pilot reported that during a normal approach, he encountered a severe downdraft in winds gusting about 40 to 60 knots. He started to abort the landing by raising the gear and applying full power. The pilot stated that he turned right to avoid a hill, but…NTSB CHI82DA081Accident · No injuriesFinal reportPiper PA-23 250 · Grand Marais, MNAfter clearing trees located approximately 1000 feet from the end of the runway the pilot reduced power and added flaps in an attempt to land close to the approach end. The aircraft struck a snowbank on short final for the snow covered runway 27.NTSB NYC82DA044Accident · No injuriesFinal reportCessna 182RG · Smithfield, RIAccording to the pilot, while on final approach to runway 33, a severe downdraft was experienced and he was unable to recover. He landed short of the runway on firm grass, bounced and came to rest a short distance from the downwind end of the runway.…