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 CHI84LA136Accident · No injuriesLimited investigationFinal reportCessna 402C · Kenosha, WIThe acft ran off the rwys end after the plt landed downwind to avoid flying through a 'wall of precipation'. During the rollout in slush the brakes froze. The nose gear settled in mud and collapsed.NTSB ATL84LA122Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Newberry, SCThe plt had executed a go-around from an approach to rwy 4 due to a crosswind & gusty wind conditions. While on downwindhe observed that the wind was favoring rwy 10. He overshot the approach end of rwy 10 & executed another go-around. Upon observing that he…NTSB ANC84FA043Accident · Minor injuriesField investigationFinal reportCessna 207A · Crooked Creek, AKThe plt was using soft field procedures to takeoff from a 1600 ft dirt/gravel strip. The strip was wet & soft from melting snow, it sloped downhill with a 3% slope & 15 to 20 ft trees were located at the departure end. Also, the plt reported there were 3…NTSB LAX84LA212Accident · No injuriesLimited investigationFinal reportCessna 172P · Pacoima, CADuring the overflight of the uncontrolled field, both plts noticed that the wind tee indicated rwy 12 as the landing direction. During landing, the acft floated & touched down about 2/3 down the rwy. The acft struck a fence & trees at the end of the rwy.…NTSB NYC84LA094Accident · No injuriesLimited investigationFinal reportCessna 500 · Fitchburg, MAThe plt landed on a slushy rwy. He was unable to stop on the rwy and angled off the end into marshy ground. The stoppingdistance on a dry rwy was figured at 2355 ft. on a slushy rwy the stopping distance was about 4004 ft. the landing rwy was 4500 ft long.…NTSB DCA84AA018Accident · Serious injuriesFinal reportMcdonnell Douglas DC-10-30 · Jamaica, NYDuring an ILS apch to rwy 4R with a tailwind, the acft (scandinavian flt 901) was being flown by the coplt. The acft was fast on final apch & was landed aprx 4700 ft beyond the apch end of the rwy at 36 KTS above the programmed touchdown speed. The aircrew…NTSB MKC84LA090Accident · No injuriesLimited investigationFinal reportRobert H. Low Mustang II · Des Moines, IAOne of the purposes of the flt was for the plt to experience a takeoff at max gross wt. He put a 150 lb bag of cement in the right front seat to simulate the wt of a passenger, then initiated a takeoff from a sod rwy that was soft after a recent thaw, using…NTSB MIA84LA124Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Cedar Key, FLDuring the 1st landing, the acft touched down at night, aprx half way down the rwy. The plt eleected to go around, then made a 2nd apch & landing. During the 2nd landing, the acft went off the end of the rwy & came to rest in water. The plt stated that…NTSB LAX84LA196Accident · No injuriesLimited investigationFinal reportRockwell 112A · Yucca Valley, CAUpon arrival at the uncontrolled arpt, neither the instructor (CFI) nor the student observed the arpt's wind sock. The acft was observed to touch down midway down the rwy & bounce once during the landing. As the acft neared the end of the rwy, the CFI…NTSB FTW84LA147Accident · No injuriesLimited investigationFinal reportCessna 152 · Harrah, OKThe plt landed at higher than normal speed, with initial contact about 400 ft down the runway. He stated that the acft was 'sailing' and attempts to decelerate were 'ineffective'. The nose gear collapsed when the acft hit in the middle road on the north end…NTSB LAX84LA186Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Crescent City, CAThe acft landed 1000 ft down the wet rwy and continued off tend of the rwy before hitting a 18 inch dirt bank. The landing gear collapsed. The plt reported that the braking action was 'poor'.NTSB MIA84LA153Accident · No injuriesLimited investigationFinal reportCessna 172 · Daytona Beach, FLThe plt reported that when he arrived at the arpt to land, the wind was from 330 deg gusting to about 15 to 17 KTS. On final apch to land on rwy 27L, he decided to slip the acft & use a faster than normal speed to compensate for the wind & extra weight of the…NTSB ATL84LA098Accident · No injuriesLimited investigationFinal reportCessna C-303 · Hickory, NCThe acft overran the rwy and collided with a fence during a night landing. The flt was hampered by an inoperative heaterand a dome light that could not be turned off. The rwy suggested for use was short with a decommissioned VASI system. The plt said she…NTSB ATL84LA097Accident · No injuriesLimited investigationFinal reportCessna C-172 · Carolina Beach, NCThe plt reported a normal landing roll until he reached the end of the hard-packed clay surface and rolled into sand. The acft mired in and nosed over. This was the pilot's first landing at this arpt.NTSB DCA84AA016Accident · 6 fatalFinal reportLearjet 24 · Avalon, CAThe acft departed on a sales demo flt to monterey, CA with potential buyers aboard. En route, the destination was changed to Avalon, CA. UNICOM advised the crew of the wind direction & speed on downwind. Witnesses reported the acft was slightly hi on final,…NTSB LAX84LA143Accident · Serious injuriesLimited investigationFinal reportCessna 206 · Santa Cruzi Il, CAThe acft overran the landing area and nosed over. The landing area was on grassy rolling terrain which was downhill fromthe touchdown point. Winds from stations in the area were from a westerly component and the landing was to the east.NTSB FTW84LA112Accident · No injuriesLimited investigationFinal reportBeech 65-90 · Okemah, OKThe plt landed long on a turf rwy with standing water on the approach end. The plt was unable to stop on the rwy and was also unsuccessful in groundlooping to avoid hitting trees off the end of the rwy.NTSB FTW84LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Del Rio, TXDuring landing on a 4000 ft sod ranch strip the plt ran off the rwy into a raving and collapsed the landing gear. The plt said he landed in a crab and ran off the rwy. The owner on form 6120.1 stated that it was plt error, that the plt missed the rwy and ran…NTSB CHI84LA070Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Hebron, OHThe plt reported that when he landed on an ice covered rwy, he delayed using brakes. When he did use the brakes, he was unable to decelerate sufficiently. He elected not to attempt a go-around, since there were tall trees near the end of the rwy. The acft…NTSB DEN84LA054Accident · Minor injuriesLimited investigationFinal reportBeech 65-90 · Hayden, COThe acft overran the rwy end during a night IMC landing. The plt stated 'the descent was steep' and 'I first touched down 1/2 way down the 7000-FT rwy.' He also stated that, 'I decide to plant the acft on the rwy so I could get on the reversers and get it…NTSB NYC84LA051Accident · No injuriesLimited investigationFinal reportCessna C172N · Meriden, CTThe acft collided with a dirt pile and nosed over during landing. According to the plt, he landed too FAR down the rwy, attempting an abort and the acft flipped over.NTSB LAX84LA099Accident · No injuriesLimited investigationFinal reportBeech 58TC · Santa Rosa, CAAfter making an ILS localtizer-only apch in heavy rain, the plt landed the acft long. When the acft touched down, the plt thought there was sufficient rwy remaining. However, he reported that he encountered hydroplaning conditions & was unable to stop on the…NTSB LAX84LA102Accident · No injuriesLimited investigationFinal reportBeech V35B · St. Johns, AZAbout 10 min after takeoff the pax door opened & the plt elected to make a precautionary landing at St. Johns. Unaware that the wind was calm, the plt selected rwy 20, which is 3400 ft long, rather than RWY31, which is 5300 ft long, because when he departed…NTSB DEN84FA027Accident · 4 fatalField investigationFinal reportGrumman American AA-5B · Boulder, COAccording to witnesses, the plt had made 3 attempts to land & during each attempt he overshot his approach & executed a go-around without touching down. On the fourth attempt he did touch down but appeared to be too fast & the acft skipped & bounced. After…NTSB LAX84LA067Accident · Minor injuriesLimited investigationFinal reportCessna TR182 · Glendale, AZOn short final to a 2400 ft rwy the plt's father, who was in the rt ft seat and also a rated plt, asked 'you do realize this is a short rwy?' The son, who was the PIC, answered 'yes.' The acft touched down hard abt 1/3 of the way down the rwy, bounced up and…NTSB FTW84LA055Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Kurthwood, LAThe student plt & a passenger, who was also a student plt, flew to a private sod strip near Kurthwood, LA. After flying a hi, fast, visual apch to the strip, the acft landed long & overran the landing area. It continued into a wooded area & was damaged. The…NTSB ATL84LA032Accident · No injuriesLimited investigationFinal reportPiper PA-61P · Norfolk, VAThe plt stated that during the takeoff roll the airspeed had accelerated through 128 KTS, but as the takeoff continued the airspeed dropped to 115 KTS & remained between 100-115 KTS. After rotation the acft would not climb or accelerate above 100-115 KTS. The…NTSB DCA84AA005Accident · No injuriesFinal reportDouglas DC-8-63F · Norfolk, VADuring arrival at nas Norfolk, the aircrew were vectored for a gca apch to rwy 10. They were advised that the wx was 200 ft scattered, 600 ft overcast, visibility 1 mi with rain, wind was from 360 deg at 20 KTS. Also, they were given a PIREP of 'heavy…NTSB LAX84LA024Accident · Serious injuriesLimited investigationFinal reportCessna 152II · Groveland, CAThe acft called in on radio to land on rwy 27 but landed on rwy 09. The acft landed fast, bounced, and went off the end of the rwy. The nose gear collapsed and the acft nosed over.NTSB MIA84LA014Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Clewiston, FLThe plt stated that during a x-wind landing, he was high & fast on final apch & did not utilize the full length of the rwy. After touchdown, he considered making a go-around, but was not sure whether he could clear power lines near the departure end of the…NTSB MKC84LA007Accident · No injuriesLimited investigationFinal reportCessna 172M · Blairstown, MOThe plt reported that after he started to takeoff, the acft had rolled aprx 1500 ft when he felt the airspeed was not sufficient, so he aborted. He was unable to stop on the remaining rwy. Before stopping, the acft went thru a shallow ravine. Subsequently,…NTSB LAX84LA017Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Holtville, CAThe plt attempted to take off with 300 gal of fungicide on board. He said that the recently resurfaced dirt rwy had not yet been compacted & this increased the rolling friction which did not allow the acft to accelerate properly. The plt was unable to get the…NTSB MIA84LA008Accident · No injuriesLimited investigationFinal reportCessna 175 · Ft. Mccoy, FLAbout 10 min after departing ft Mccoy, FL, the plt realized he had forgotten his flt bag, so he returned to land at the airstrip. During the landing, the acft floated, & after touching down, there was insufficient rwy remaining to safely stop or go around.…NTSB CHI84LA003Accident · No injuriesLimited investigationFinal reportPiper PA-12 · East Liverpool, OHThe plt stated that while landing on a downhill grass strip he touched down long. While attempting to apply brakes, the heel of his boot got caught under the rudder pedal & he was unable to stop the acft before it went off the end of the strip down a steep…NTSB LAX83LA457Accident · No injuriesLimited investigationFinal reportCessna 172P · Glendale, AZReportedly, the plt landed long. He then applied braking action & 1 wheel locked. At that point, the acft was still going too fast to stop on the remaining rwy & there was insufficient rwy to go around. The plt steered the acft off the end of the rwy & it…NTSB ATL83LA380Accident · No injuriesLimited investigationFinal reportCessna 172 · Mocksville, NCThe acft overran the rwy during a no-flap landing roll-out. The plt reported that he had electrical failure after takeoff and returned to land but he was unable to extend the flaps. The approach was high and fast but the plt continued and touched down long.…NTSB NYC83LA250Accident · No injuriesLimited investigationFinal reportCessna C172M · Dover, DEThe acft ran off the end of the rwy, groundlooped, and collided with a tree during an effort to avoid a blast fence. The landing, made at night with touchdown occurring too FAR down the rwy. An approach had already been abandoned due to excessive airspeed,…NTSB NYC83FA249Accident · Minor injuriesField investigationFinal reportGates Learjet 35A · Massena, NYPassengers described touchdown as fast & long with no eng noise associated with reverse thrust immediately after touchdown. The acft ran off the end of the rwy & the nose gear separated. According to the crew the plt initiated the thrust reversers after…NTSB CHI83LA432Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Carthage, ILThe acft collided with a ditch during landing. The acft bounced and floated during landing. The pilot said he thought hewas too FAR down the rwy for a go-around so he applied the brakes. The acft skidded off the rwy end into a ditch. The pilot thought a gust…NTSB LAX83LA465Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Empire, NVThe plt said that a gust of wind blew the acft half way down the rwy. The touchdown was long and the acft ran off the end of the rwy into a dirt bank and nosed over. Winds were gusting to 20 KTS.NTSB ANC83FA174Accident · No injuriesField investigationFinal reportStinson 108-1 · Anchorage, AKThe acft struck a dirt bank while landing on a sandbar on the yentna river. The plt stated he was pre-occupied at the sight of a moose near the landing area and did not excercise adequate care in selecting landing path. There was about 2000 ft of good landing…NTSB DEN83LA212Accident · No injuriesLimited investigationFinal reportBeech B90 · Burlington, CODuring arrival, the plt checked the lighted wind sock & estimated that the wind was from 020 deg at 10 KTS. He elected not to land on rwy 31 since there were obstacles near the apch end. He stated that when the acft was about to touch downon rwy 13, there was…NTSB ATL83LA359Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Fairmont, WVThe plt reported that during arrival, he flew over the field, checked the wind indicator, then elected to land on rwy 4. While in the traffic pattern, he noticed tall trees at the apch end of the rwy & that the rwy dropped off at the other end. He made his…NTSB DEN83LA209Accident · No injuriesLimited investigationFinal reportRockwell 112TC · Durango, COThe acft ran off the departure end of the rwy and collided with trees during landing. The density alt at the arpt was 8800 ft at the time of the accident. The landing rwy was 19 and the wind was 270 degrees at 3 KTS. The acft landed ABOUT2500 ft down the 5000…NTSB CHI83LA409Accident · No injuriesLimited investigationFinal reportCessna 172M · Grand Marais, MNThe plt took off from the departure point after an unexpected 1/2 hr delay. By the time he arrived at his destination, it was dark. No rwy lighting sys was installed, so someone at the arpt drove a car to rwy 27 to light up the approach end with the head…NTSB ANC83LA160Accident · No injuriesLimited investigationFinal reportCessna 180 · Nr Anchorage, AKThe plt reported that the accident occurred when he was landing on a sandbar that he had previously used 3 times, earlier the same day. Reportedly, he overran the landing area by about 50 ft & encountered an area of soft clay & mud. The right wheel sank into…NTSB CHI83LA417Accident · No injuriesLimited investigationFinal reportCessna 172H · Wolcott, INThe student pilot was practicing touch-and-go landings. He stated he landed long with the right wing scraping a shed. The acft continued off the end of the rwy and struck a tree before coming to a stop.NTSB CHI83LA405Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Halstad, MNThe acft landed long and collided with an embankment at a private farm strip. The pilot stated he landed on rwy 35 and the wind was from 170 degrees at 5-10 KTS.NTSB NYC83LA231Accident · No injuriesLimited investigationFinal reportCessna 172F · Ebensburg, PAThe plt initiated a go-around during his first landing attempt because he was too high. During the landing he landed about 300 ft down the rwy. When he applied brakes they were ineffective & insufficient rwy remained to initiate a go-around. The acft ran off…NTSB MKC83LA208Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Indianola, IAThe acft overran the rwy and collided with a dirt bank during landing. The flt was returning from a cross-country and the wife of the pilot who was a passenger in the acft said her husband froze on the controls and made no attempt to stopthe acft after…