NTSB investigations
1,681 cases where the first occurrence was “Overrun”.
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\" = 340) 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" = 340) 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 SEA88LA112Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Athol, IDPlt landed long to avoid potential conflict with truck waiting to cross rwy. The pilot stated he experienced a tailwind after touchdown. He initiated a go-around but contacted rough terrain in overrun before becoming airborne.NTSB FTW88LA137Accident · No injuriesLimited investigationFinal reportCessna 182D · Gilmer, TXThe pilot said he made two approaches to runway 17 and two go-arounds. He said the wind then changed direction and he set-up for landing on runway 35. He said he should have gone around for the third time but instead he landed long, went through a fence and…NTSB CHI88LA130Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Bedford, INThe pilot landed beyond his intended touchdown point on the runway due to excessive airspeed during the approach to landing and touchdown. When the aircraft ran off the departure end of the runway the pilot elected to perform an intentional ground loop/swerve…NTSB NYC88LA155Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Franconia, NHThe pilot landed the aircraft long on a grass runway with a tailwind. The pilot reported that she touched down longer than anticipated, but she thought she would have had adequate stopping distance. She was unable to stop the acft on the remaining runway and…NTSB ATL88LA182Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Shellman, GAThe plt was making a personal flt to a pvt uncharted airstrip on a coastal island. Approaching his destination, the plt cancelled his VFR flt plan with fss. The plt stated that he approached the soft 2500 foot strip high and ballooned at touchdown. He landed…NTSB SEA88LA096Accident · No injuriesLimited investigationFinal reportCessna 172N · Anacortes, WAAfter overflying the intended seaplane base landing area. The pilot, who had logged only 1 hour of fixed wing time in the previous 90 days, misjudged the necessary downwind leg length and landed with insufficient surface distance available to stop the…NTSB ATL88LA175Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Columbus, OHThe plt landed the airplane long at an excessive airspeed. The airplane overran the rwy end, traveled across a grassy area onto a ramp area, and collided with a parked airplane. The plt had 2 hrs of flt experience in this make and model airplane, which was…NTSB CHI88LA107Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lake Village, INThe pilot had landed long and, realizing he would not stop before running off the runway, attempted a go-around. The pilot stated he had one notch of flaps down, approximately 10 degrees, and after adding full power attempted to lift-off. The aircraft ran off…NTSB ATL88LA160Accident · No injuriesLimited investigationFinal reportCessna 172N · Gilbert, SCThe airplane overran rwy 23 during ldg and nosed over. The plt reported that he attempted to abort the ldg after initially landing long on the rwy. As the airplane began to climb however, he realized that it would not clear obstacles located past the end of…NTSB CHI88LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA28-140D · Flushing, MIWhile on final approach for landing on a short, grass strip, the pilot said she encountered sunglare which restricted her visibility such that she was unable to judge the landing. Touchdown occurred with insufficient runway remaining to stop the aircraft. The…NTSB BFO88LA038Accident · No injuriesLimited investigationFinal reportCessna 172M · Fayetteville, WVThe pilot landed long and with excessive airspeed, which resulted in an overrun of the runway. Inadequate inflight planning is a contributing factor.NTSB SEA88LA079Accident · Minor injuriesLimited investigationFinal reportMooney M20E · The Dalles, OROn arrival, plt found destination obscured by unforecast fog, held briefly, then diverted to an alternate airport. On arrival at alt in darkness, plt did not know freq (UNICOM) to activate rwy lights. Plt made low pass to acquire rwy environment as fuel state…NTSB ATL88LA132Accident · No injuriesLimited investigationFinal reportBeech M35 · Mc Cullough, ALThe plt stated that he was landing at his destination arpt when the accident occurred. The turf/grass was wet. The acft overran the end of the rwy and collided with the terrain, several trees, and bushes. There were no mechanical malfunctions reported.NTSB ATL88LA130Accident · No injuriesLimited investigationFinal reportBeech A-36 · Nashville, TNThe pilot aborted a takeoff after he felt that the aircraft was not performing properly. The pilot had four passengers on board which put the aircraft near its gross weight. The runway was 4300 feet long and the pilot needed about 1100 feet of runway for the…NTSB ATL88LA128Accident · No injuriesLimited investigationFinal reportBeech B19 · Albany, KYThe plt reported that he touched down about midfield on the 1,800 ft usable portion of the rwy. A light rain was falling at the time, and the rwy was wet. Braking action was poor, and the airplane subsequently overran the runway. The airplane traveled down an…NTSB BFO88LA030Accident · No injuriesLimited investigationFinal reportCessna 172 · New Cumberland, WVThe plt said that during the landing roll the brakes did not operate despite his continued application of pressure on the pedals. As the acft neared the rwy end he tried to swerve the acft left toward a runup pad. However, at the same time the r brake…NTSB MKC88LA063Accident · No injuriesLimited investigationFinal reportBeech C23 · Sullivan, MOWhen the PIC arrived at his destination, during a personal cross country flight, he circled the unfamiliar arpt three times, observing trees on both ends, and a crosswind of about 60 degrees to the active runway. After landing, and during the ldg roll out, he…NTSB CHI88LA070Accident · No injuriesLimited investigationFinal reportCessna 172A · Crivitz, WIThe aircraft did not accelerate as anticipated by the pilot, who was attempting to takeoff from a wet sod strip. The pilot elected to abort the takeoff, however was unable to stop on the remaining runway, exited the departure end, struck a snow bank and nosed…NTSB CHI88LA065Accident · No injuriesLimited investigationFinal reportCessna 172F · Brighton, MINTSB NYC88LA091Accident · No injuriesLimited investigationFinal reportCessna 303 · Hyannis, MAThe Cessna 303 broke out of the clouds and made a long landing on a 5567 ft runway. Tire marks showed that the aircraft touched down with less than 2000 ft of runway remaining. The landing runway was 24 and the winds were from 360 degrees at 8 KTS. The runway…NTSB NYC88LA075Accident · No injuriesLimited investigationFinal reportCessna 402C · Provincetown, MAThe Cessna 402C was being positioned for a scheduled commuter flight with only a pilot on board. The pilot made an ILS approach to runway 7 with winds from 220 degrees at 14 knots, the runway wet and light rain falling. The aircraft slid off the end of the…NTSB ANC88LA024Accident · No injuriesLimited investigationFinal reportCessna 150D · Chugiak, AKThe flight instructor stated the student landed back on the runway after a practice engine failure; at that point the flight instructor realized how slick the runway was and the aircraft exited the departure end of the runway into a snow bank.NTSB CHI88LA038Accident · No injuriesLimited investigationFinal reportCessna 210-5 · East Lansing, MIThe aircraft was landed at night on runway 9 which is 2530' in length with a 600' displaced threshold. This runway was ice covered and winds were recorded 25 minutes before the accident at a reporting facility 5 nautical miles west of the accident site as 160…NTSB ATL88LA062Accident · No injuriesLimited investigationFinal reportCessna 172P · Columbus, OHAt 1343 EST, the student plt contacted apch ctl & asked for lndg info. He was adzd to continue VFR for rwy 31. When he contacted the tower at 1347, the wind was fm 200 deg at 13 KTS. Tower psnl gave him the choice of rwy 31 or 28L; he elected to lnd on rwy…NTSB LAX88LA048Accident · No injuriesLimited investigationFinal reportBeech 58 · Jackson, CAThe plt rprtd that prior to reaching the destn, he received an adzy on the UNICOM freq that rwy 19 was in use & that there was a direct x-wind. Drg arrival, he tried to contact UNICOM again to get a wx update, but was unable. He elected to lnd on rwy 19.…NTSB MIA88LA031Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · St. Petersburg, FLThe plt, familiar with the arpt, overflew it 2 times in an attempt to activate the rwy lights using the acft's radio as well as to observe the wind sock. After observing a northerly wind & being unable to activate the lights he elected to land on rwy 36…NTSB ATL88LA033Accident · No injuriesLimited investigationFinal reportCessna 172K · Cumming, GAThe student plt rptd that the airplane contacted the rwy and bounced twice during the ldg flare. Once he got the airplane on the rwy, he realized that the airspeed was 'too high' for the rwy remaining and attempted to ground loop the airplane to stop it. The…NTSB NYC88LA027Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Windham, CTThe flight departed groton, Connecticut enroute to willimantic, Connecticut in unlimited visibility. However at Windham airport, the runway was partially obscured by patchy fog according to the pilot. The pilot landed long due to carrying additional speed in…NTSB FTW88LA017Accident · No injuriesLimited investigationFinal reportCessna 172 · Midland, TXThe pilot landed long and could not stop before running off the end of the runway. The aircraft, collided with a fence and the left wing was damaged when the acft collided with a ditch.NTSB DEN88LA012Accident · Minor injuriesLimited investigationFinal reportBeech C35 · Ekalaka, MTDuring the takeoff roll the pilot encountered an unexpected tailwind. The pilot reported that he tried to abort the takeoff but tall grass and the tailwind did not allow the aircraft to decelerate properly. The aircraft ran through two drainage ditches and…NTSB MKC88LA009Accident · No injuriesLimited investigationFinal reportGrumman American AA5B · Branson, MODuring a lndg on a 3600 ft strip, the acft touched down long. The acft ran off the departure end of the rwy and collided with the terrain causing substantial damage to the acft. Witnesses said they could not find any skid marks along the path taken by the…NTSB ANC88LA009Accident · Minor injuriesLimited investigationFinal reportCessna A150K · Whittier, AKThe PIC got lost while flying above an overcast. When he finally found an opening and descended below the clouds he was low on fuel. He located some buildings on a narrow beach and attempted to land. He overshot the beach and struck stacks of building…NTSB ANC88LA007Accident · No injuriesLimited investigationFinal reportCessna 170 · King Salmon, AKThe plt rprtd there was frost on the acft & that a rope had been used to smooth it off. He then initiated a takeoff from a dry lake bed. After lift-off, the acft settled back to the ground & struck a berm at the end of the takeoff area.NTSB FTW88LA003Accident · No injuriesLimited investigationFinal reportGrumman GA7 · Covington, LAThe pilot touched down with excessive speed, and due to the poor mechanical condition of the aircraft's brakes, was unable to stop before over-running the departure end of the runway. The aircraft's annual inspection was two months overdue. The pilot's…NTSB SEA88LA001Accident · No injuriesLimited investigationFinal reportBritish Aerospace BA-3101 · Kennewick, WAWhile on a flight to pasco, WA. The pilot inadvertently landed at the Kennewick, WA. Vista airport, landed long, and overran the runway. The aircraft departed the end of the runway and impacted terrain.NTSB DEN87LA248Accident · Serious injuriesLimited investigationFinal reportCessna 182F · Colorado City, COThe plt made several circling approaches before landing. When he did land his acft, he said that he landed fast and long. He applied the brakes but went off the end of the rwy, hit an embankment, and nosed over.NTSB MKC87LA184Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Ozark, MODuring a ldg, the acft touched down long, ran off the end of the airstrip and struck a fence and then a ditch. The rwy was 2100 feet long, downsloping, and the grass surface was wet.NTSB NYC87LA237Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Stow, MAThe pilot was on takeoff roll when he decided to abort. He stated that he felt the engine was not developing adequate power and the airspeed was not up to required takeoff speed. The aircraft continued off the end of the runway and inverted in swampy soil.NTSB CHI87LA226Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Frankfort, ILThe student plt was on a flt with 2 pax aboard. He rprtd that drg a ngt lndg, the acft bounced & ballooned. He added pwr to fly the acft back down to the rwy, but it bounced & ballooned again. By this time, the acft was about halfway down the rwy.…NTSB CHI87LA222Accident · No injuriesLimited investigationFinal reportCessna 150H · Sparta, WIThe plt was taking off on his pvt strip in a prevailing 12 kt x-wind that was vrbl & blowing fm a 'lull' to 18 KTS. He said the strip was located near an l-shaped ridge which attenuated the general wind flow. Also, he said the 1900' sod strip sloped downhill…NTSB BFO87LA069Accident · No injuriesLimited investigationFinal reportMooney M20E · Pocomoke City, MDWhile on final apch, the plt realized his touchdown point was farther down the rwy than usual, but he believed there was sufficient rwy & elected to cont the lndg. After touchdown, he applied brakes, but was unable to stop on the remaining rwy. Subsequently,…NTSB ANC87LA169Accident · No injuriesLimited investigationFinal reportCessna 185 · Wind River, AKThe pilot and his passenger had camped over night on a gravel bar on the Wind River. On departure the following day, the airplane failed to become airborne prior to reaching the end of the gravel bar. The airplane entered the shallow water surrounding the…NTSB ATL87LA251Accident · No injuriesLimited investigationFinal reportCessna 172E · Lebanon, OHA witness rprtd the acft was hi & fast on final apch. The plt stated he landed the acft long & fast & was unable to stop on the remaining rwy. Subsequently, the acft impacted a ditch beyond the dep end of the rwy & the nose gear collapsed. Before the acft…NTSB SEA87LA177Accident · Serious injuriesLimited investigationFinal reportCanton Rutan Long · Port Townsend, WADuring takeoff roll the pilot noted sluggish rotation performance and retarded the throttle to abort the takeoff. When he reduced power the aircraft rotated. He reapplied full power and abrupt aft stick, to execute rapid rotation and lift off. The hand grip…NTSB NYC87LA238Accident · Serious injuriesLimited investigationFinal reportBoeing B-17G · Beaver Falls, PADrg an apch in gusty winds, the plt noted a rgt x-wind. He stated that after touchdown, the roll-out was stabilized for a short distance, then the rgt wing began to lift. He applied full aileron & rudder to maint control, but was unable to stop on the…NTSB SEA87LA170Accident · No injuriesLimited investigationFinal reportCessna 182 · Boulder City, NVThe pilot was attempting to land the aircraft with a 15 knot tailwind gusting to 20 knots. The density altitude was over 6,000 feet and the runway was an uphill runway with rising terrain ahead. The pilot stated that he decided to go-around but that shortly…NTSB FTW87LA201Accident · No injuriesLimited investigationFinal reportCessna 185 · San Marcos, TXThe pilot stated that he landed long and downwind on his private strip. In an attempt to stop he applied heavy braking and at the end of the strip the aircraft nosed over and came to rest on a fence.NTSB NYC87LA234Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Vergennes, VTDuring a landing attempt at basin harbor airport, the pilot came in high and fast. He did not correct and failed to go around. He overran the runway and crashed into a ditch causing substantial damage to the aircraft. The plt did not file an acc report.NTSB SEA87LA164Accident · No injuriesLimited investigationFinal reportBeech A36TC · Cascade, IDThe plt elected to divert due to hvy rain at his destn. While lndg at an alternate arpt at ngt, hydroplaning occurred & braking was not effective. Drg a go-around, the acft rolled onto the overrun & lifted off, but the acft's main gear struck a rock pile on…NTSB CHI87LA202Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Delft, MNThe acft was loaded close to its gross wt limit & the plt atmtd to takeoff on a 2160 ft strip, using short field takeoff techniques. The acft became airborne for a short time, however, it began to settle. The plt elected to abort the takeoff, but was unable…