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 ATL85LA199Accident · No injuriesLimited investigationFinal reportBeech 55 · Savannah, GABefore taking off, the plt checked the trim & the auto-plt. During the takeoff run, he noted that the 'aircraft felt heavy on rotation/takeoff aborted.' The acft continued off the end of the rwy, hit a mound of dirt & was damaged. A post-accident exam…NTSB LAX85LA292Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Glendale, AZWhen the plt realized he was low during final apch to a landing, he erroneously decided not to use full flaps instead of adding power, vref was high and the landing was 3/4 of the way down the 2400 ft rwy. Believing he had sufficient room to takeoff again,…NTSB SEA85LA141Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · North Plains, ORAn overrun occurred due to excess speed and touching down 1/4 of the way down the 2100 foot glider strip. The aircraft rolled onto two foot high alfalfa where it then nosed over. The pilot previously landed gliders on the gliderport but never an engine…NTSB ANC85FA093Accident · Serious injuriesField investigationFinal reportCessna 207 · Eek, AKThe pilot-in-command stated that during the takeoff roll he was moving the flap control lever up and down to effect a lift off. The airplane never left the runway and ran off the end of the ten foot embankment, traveled 140 feet before striking a bank and…NTSB MKC85LA128Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Swifton, ARThe ag pilot was landing the airplane too fast and when he couldn't stop on the wet grass, he attempted a go-around. By the time the engine accelerated, there was not enough airspeed or runway and the airplane went through a fence and stopped against a…NTSB LAX85FA269Accident · Minor injuriesField investigationFinal reportAero Commander 1121 · Van Nuys, CAThe plt, executing and ILS apch, observed a primary hydraulic pressure drop and declared his intent to land without the use of flaps, speed brakes, reversers or nose wheel steering. The acft ran off the end of the rwy during landing, traveled aprx 1300 ft and…NTSB LAX85LA268Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Oracle, AZDuring a LCL pleasure flt the plt stated that the acft's eng began running rough so he made a precationary ldg on a dirt road which was at an elevation of 4,000 ft MSL. After inspecting the acft & finding it to be in proper working order the plt decided to…NTSB MKC85LA127Accident · No injuriesLimited investigationFinal reportCessna 172 · Curtis, NEThe plt stated he misread the windsock and made a downwind landing resulted. The acft overran the end of the grass rwy and nosed over when the nose gear contacted a plowed fld. The arpt operator reported the winds were from 180 degs at 18 KTS when the landing…NTSB DEN85LA158Accident · No injuriesLimited investigationFinal reportMooney M20K · Lafayette, COOn June 8, 1985, a Mooney M20K, impacted the ground off the rwy while landing at alexander dawson arpt, Lafayette, o. the plt said he was attempting to make a short field apchto the plt, the apch was high and fast. The acft landed, porpoised, and departed the…NTSB MKC85LA119Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Concordia, KSThe student plt was making a night flt. He received wind information from an arpt 48 miles from the destination but used an indication from lighted wind indicator. Plt made a go around because the ground speed was fast. During the next attempt, he landed, ran…NTSB LAX85LA261Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Glendale, AZThe plt attempted to takeoff fm a 2400-FT-long rwy, he reported that because the acft's airspeed indicator did not appear to properly represent the airspeed, he aborted the takeoff. This occurred after accelerating down the rwy for an estimated 1800 ft. the…NTSB NYC85LA134Accident · No injuriesLimited investigationFinal reportGlobe GC1B · Whitpain, PAThe acft overran the end of the rwy and contacted rough terrain during takeoff. The plt stated the acft lifted off aprx 1/2 the way down the rwy but it did not have enough airspeed to accelerate and climb. The plt attempted to abort the takeoff however, the…NTSB MKC85LA109Accident · Minor injuriesLimited investigationFinal reportBeech 35-B33 · Calamus, IADuring arrival, the plt landed on a 1700 ft turf rwy which sloped downhill to the north & had a 30 ft power line located near the apch end. Reportedly, the acft touched down 572 ft from the departure end, then continued off the rwy & hit a dirt bank next to a…NTSB MKC85LA102Accident · Minor injuriesLimited investigationFinal reportCessna R182 · Monticello, ARPlt selected grassy area on arpt for landing. The grassy area was more closely aligned with the surface winds than the available runways. The grassy area has a utility line across the apch end and a ditch on the departure end. The landing was long and hot and…NTSB MKC85LA101Accident · No injuriesLimited investigationFinal reportPiper PA-46 · Osage Beach, MOThe plt landed the acft mid-field on the 3205 ft rwy, the acft landing speed was higher than normal and a decision was made to continue the landing instead of going around for another attempt. The plt applied brakes & the acft skidded off the rwy. The plt…NTSB LAX85LA255Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Morgan Hill, CAOn a personal flt, the plt & pax flew to an uncharted, dirt airstrip located in a state park. The plt acknowledged that on apch the acft was high and fast. After initially touching down, the plt stated that he tried to go-around. A park ranger reported that…NTSB CHI85LA199Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Troy, MIThe plt stated that his intended destination was the Troy-oakland arpt where he intended to land on rwy 27. However, he inadvertently landed on rwy 27 at the big beaver arpt which was aprx 3 mi away. He was expecting to have 3800 ft of rwy, but the rwy at big…NTSB CHI85LA190Accident · No injuriesLimited investigationFinal reportPiper PA-11-494 · Alliance, OHThe acft approach was high and fast. The landing was made with 500-600 ft of runway remaining. The acft brakes were not sufficient to stop on the runway. The pilot added power and veered left off the end of the runway to avoid a heavily traveled road, the…NTSB LAX85LA247Accident · No injuriesLimited investigationFinal reportCessna 182P · Oasis, CATo accomodate his pax's request to be transported close to his destination, the plt landed the acft on a 350 foot-long dirt road. The pax disembarked & the plt attempted to take off on the same road. The acft became airborne in grnd effect, climbed aprx 5 ft…NTSB CHI85LA183Accident · No injuriesLimited investigationFinal reportCessna 152 · Broadhead, WIThe plt stated that during arrival, he entered a traffic pattern for what he thought, according to his directional gyro, was rwy 9. Rwy 9 was 2500 ft long; however, he landed on rwy 3, which was 1520 ft long. During the landing, the plt was unable to stop on…NTSB MIA85LA154Accident · No injuriesLimited investigationFinal reportCessna 172N · Fort Myers, FLPlt stated that on takeoff ground run from a turf runway he felt severe vibration in the nose gear and lifted it off the ground. As he did he thought he felt a loss of engine power an aborted the takeoff. Before the aircraft could be stopped it overran the…NTSB SEA85LA093Accident · No injuriesLimited investigationFinal reportLake Buccaneer · Dexter, ORThe acft bounced during touchdown several times while attending to land on the water. The acft was too close to a dam to make a go-around. The acft then struck the dam head on.NTSB ATL85FLT05Accident · Minor injuriesFinal reportPiper PA-28-180 · Arlington, TNThe acft overran the rwy during landing and contacted a ditch. A left quartering tailwind was present at the time of the landing.NTSB NYC85LA108Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Clarion, PAThe purpose of the flight was to position the aircraft at pittsburgh, PA. During the takeoff roll at buffalo, two to three short power surges in the no. 1 engine were experienced but the pilot decided not to abort and continued to destination. The aircraft…NTSB ATL85LA129Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Concord, NCThe plt reported that the pvt arpt at the destination had a unidirectional strip with hi obstructions on both ends. Obstacles, rwy slope & noise abatement considerations required that rwy 4 be used for landings. At 1351 EST, the wind at charlotte, NC was from…NTSB FTW85LA173Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Justin, TXMisinterpreting the windsock, the pilot landed downwind on a short gravel strip and collided with a tree at the end.NTSB FTW85LA172Accident · No injuriesLimited investigationFinal reportMooney M20A · Austin, TXThe 86 hr private plt landed at a ranch and ran off the end of the rwy into rough terrain. A go around was not attempted.NTSB BFO85LA030Accident · No injuriesLimited investigationFinal reportCessna 182G · Bridgewater, VADue to excess altitude, during his 1st apch to land, the plt executed a go-around. The 2nd apch resulted in proper altitude, but high airspeed. Crosswind conditions & gusts up to 22 KTS existed at the time & touchdown occurred aprx half way down the 2755 ft…NTSB FTW85LA179Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Eagle Lake, TXOn or about 3/25/85, the acft was landed on a short private strip. During the landing, it overran the strip, then collided with a dirt bank & a tree. The plt abandoned the acft. Neither he nor the new owner could be found. There was evidence that the acft had…NTSB NYC85LA085Accident · No injuriesLimited investigationFinal reportBoeing JB-75 · Marston Mills, MAThe acft nosed over after contacting an utility pole during an overrun landing. The acft touched down aprx 1/2 way down the rwy and the plt applied brakes, however, braking action was poor because of the wet grass rwy. The acft skidded off the end of the rwy…NTSB DEN85FA099Accident · 2 fatalField investigationFinal reportCessna 182J · Erie, COReportedly, the plt had called the arpt office (UNICOM) & was advised that rwy 15/33 was closed. At about the time N3354F was arriving, a military helicopter landed on rwy 27. The plt asked a passenger to tell him which way the wind sock was blowing & she…NTSB ANC85LA057Accident · No injuriesLimited investigationFinal reportCurtiss C-46R · Nulato, AKThe acft continued off the end of the rwy and contacted a snow berm during the landing roll. The plt reported the rwy braking action as poor.NTSB SEA85LA073Accident · No injuriesLimited investigationFinal reportCessna 172 · Soda Springs, IDThe plt made a precautionary landing due to an iced up pitot tube. The plt landed with excess speed and was unable to stop the acft before it overran the end of the rwy. It struck a snow bank and then flipped inverted.NTSB ATL85LA114Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Charleston, WVThe plt landed long on the rwy & at excessive speed. In an attempt to stop the acft she applied brakes & the acft flipped upside down.NTSB SEA85LA069Accident · No injuriesLimited investigationFinal reportCessna 177A · Stanwood, WAThe plt was attempting to land the acft downwind and uphill.a go-around was attempted and the acft struck trees at the departure end of the rwy.NTSB SEA85LA063Accident · No injuriesLimited investigationFinal reportTaylorcraft F19 · Gaston, ORThe plt was attempting a precautionary landing onto a 1000 foot private grass airstrip due to a noise outside the acft which was heard inflt. The plt was landing to the east with a right quartering tailwind of 5 to 10 knots. An overrun occurred and the plt…NTSB LAX85FA142Accident · Minor injuriesField investigationFinal reportCessna T210L · Fullerton, CAThe plt & gnd witnesses rptd the acft touched down at or beyond midfield at an exesseive speed. The acft continued the landing roll, exited the rwy & entered soft dirt area west of the departure end of the rwy. Upon entering the dirt area the nose gear sunk…NTSB ATL85LA095Accident · No injuriesLimited investigationFinal reportBeech 58 · Natchez, MSPlt descended below mda to 720 ft MSL until observing the rwy during a LOC 17 apch at night. An arpt attendant said plt did not call UNICOM for wind info. Plt acknowledged touchdown at midfield with a 30 kt tailwind on the 5000 ft rwy. The plt said braking…NTSB MIA85LA091Accident · No injuriesLimited investigationFinal reportSchweizer G-164A · Panama City, FLPlt was landing on a city street so the acft could be put on display. When the acft overran the end of the street the plt locked the brakes to avoid contacting buildings and vehicles and the acft nosed over.NTSB FTW85LA114Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Hobart, OKAt 1515 CST, the plt contacted a fss & was advised that a front would be moving thru the destination (Hobart) area at about 2200. When he departed stillwater at 1840, the wind was from the south. At 2004, the plt contacted altus afb & was advised that the…NTSB LAX85LA125Accident · No injuriesLimited investigationFinal reportCessna 150L · Hollister, CAThe acft attempted to takeoff from a taxiway. The takeoff was aborted. But the acft continued off the end of the taxiway. Plt's medical certificate had expired, and he did not file an accident report.NTSB LAX85LA121Accident · No injuriesLimited investigationFinal reportCessna 152 · Eureka, CAWhile on a local solo instructional flt, the student plt made 3 attempts to land at the arpt. On the 3rd apch, the acft touched down about halfway down the rwy 'a little fast.' The plt added power to abort the landing & make a go-around. He then changed his…NTSB NYC85LA056Accident · No injuriesLimited investigationFinal reportGates Learjet 25D · Johnstown, PAThe acft overran the end of rwy 33 during an aborted takeoff. During the takeoff ground run the acft inadvertently became airborne at an airspeed bwt 80-150 KTS and ascended to an alt of aprx 30 ft AGL. The plt corrected for left yaw which was present and…NTSB FTW85LA092Accident · No injuriesLimited investigationFinal reportGates Learjet 25B · Oklahoma City, OKThe plt-in-command (PIC) reported that after touchdown, the spoilers & brakes were applied, but no braking action was felt although peddle pressure was evident. He stated that by the time it was clear that the brakes were ineffective,insufficient rwy remained…NTSB MIA85LA068Accident · Serious injuriesLimited investigationFinal reportSchweizer 2-33A · Orlando, FLThe acft was flared for landing about 1/2 way down the rwy at excessive airspeed. The plt stated that as the acft touched down, it bounced into the air and impacted trees at 10-15 ft AGL. The spoilers were found in a retracted position after the accident.…NTSB CHI85IA073Incident · No injuriesIncident investigationFinal reportBeech 58P · Akron, OHDuring arrival at medina, OH, the plt discovered that the NDB was inop, so he diverted to the Akron fulton arpt. He was vectored for a localizer apch to rwy 25. During the apch, he descended to the min descent alt (mda) of 512 ft AGL. When he had the arpt in…NTSB LAX85LA061Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Garberville, CAThe plt reported that on his first attempt to land he was 'too high' so he made a go-around. On the second apch to the 3050 ft rwy, he was flying at 110 mph. He landed long, applied brakes & skidded off the dept end of the rwy. The lt tire blew-out,…NTSB SEA85LA029Accident · No injuriesLimited investigationFinal reportCessna 172M · Sultan, WAAn overrun occurred on the 2,000 foot airstrip due to excess approach and landing speed. A light coating of snow was present on the grass runway and the pilot neglected to raise the flaps adding to a longer landing roll and making braking less effective. A 5…NTSB NYC85LA040Accident · No injuriesLimited investigationFinal reportBeech 58TC · Norwood, MATouchdown made 1/3 the way down the wet rwy. Brakes were ineffective on wet pavement. Plt raised flaps and reapplied brakes with no positive result. Acft continued onto 60 ft overrun area where some braking action was effective however, acft continued down an…NTSB CHI85LA065Accident · No injuriesLimited investigationFinal reportCessna 150C · Hampshire, ILTouchdown occurred nearly half-way down airstrip, which was wet with melting frost. Plt did not attempt a go-around, but relied on braking action for safe completion of landing roll. Braking action was nil. Acft overran through a barbed-wire fence and into a…