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 ATL83LA231Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Cambridge, MDThe owner/student plt & his instructor (CFI) were on a dual instructional flt & proceed to an arpt with a wet grass rwy to practice landings. The rwy was 2200 ft long & had 50 to 60 ft trees at the apch end that had been cut to aprx 25 ft AGL. The 1st apch…NTSB CHI83LA253Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Strongville, OHThe acft collided with trees at the departure end of the runway during an aborted takeoff. The instructor pilot who was doing a demonstration flt stated that 'the acft rotated to a normal climb attitude but did not climb out of ground effect. After electing…NTSB NYC83LA137Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Matamoris, PAThe acft landed downwind and overran the runway after which it collided with a fence during a precautionary landing. Thepilot had discovered a bad brake cylinder and fuel selector valve and was returning the acft to the mechanic who had performed the annual 5…NTSB CHI83LA249Accident · No injuriesLimited investigationFinal reportPiper PA28-181 · Plain City, OHThe acft collided with poles after overrunning the rwy during a landing on a training flt. The approach was made into the sun on rwy 28. The CFI said that by the time he saw the landing was long it was too late to go-around. The acft ran off the departure end…NTSB ANC83LA101Accident · No injuriesLimited investigationFinal reportCessna 182 · Bettles, AKThe acft went off the departure end of the runway during a night landing and nosed over. The pilot stated that he pulledoff power for the flare and the acft seemed to gain airspeed. He decided to go-around, added full power, but saw the end of the runway and…NTSB FTW83LA269Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · San Antonio, TXWhile on the takeoff roll, with aprx 1400 ft of rwy remaining, the plt noticed that there was no indication of airspeed. He therefore elected to abort the takeoff, the rwy was a combination of asphalt & turf. Following his decision to abort, the remaining…NTSB NYC83LA145Accident · No injuriesLimited investigationFinal reportCessna 172M · Block Island, RIThe plt reported that during a landing, the brakes failed & he was unable to stop on the rwy. The acft ran off the end & came to rest in bushes with substantial damage. According to the plt, the outboard pressure plate & lining had separated from each brake.…NTSB MIA83LA154Accident · No injuriesLimited investigationFinal reportCessna 172N · Chuluota, FLThe acft ran off the departure end of the runway into a pond during landing. The landing was on runway 29 and the wind was from 40 degrees at 14 KTS. The pilot said the wind changed after he started landing. He also stated that he landed more than half way…NTSB DEN83LA126Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · New Harmony, UTThe acft ran off the departure end of the rwy during landing after going through a fence/bushes and the acft nosed over. The pilot had made one go-around because of excessive airspeed. He said the windsock was limp as he obseved it. However,winds at cedar…NTSB SEA83LA098Accident · No injuriesLimited investigationFinal reportCessna 172-I · Wasco, ORThe acft went off the departure end of the runway during landing and groundlooped in a plowed field. The pilot landed in a 27 kt quartering tailwind. The acft rolled onto a freshly harrowed field. The nose wheel caught the dirt and veeredto the left and the…NTSB MIA83LA142Accident · No injuriesLimited investigationFinal reportCessna 172M · Arcadia, FLThe plt reported that on his approach to land, his speed was higher than normal & the acft touched down well past the normal touchdown point. He was unable to stop on the remaining rwy. The acft went off the end of the rwy & collided with a ditch. The plt…NTSB SEA83LA099Accident · No injuriesLimited investigationFinal reportCessna 172 · Tenino, WAAfter arriving, the plt made several approaches to the rwy to check the wind conditions, but noticed no wind. He reported establishing a final approach with an airspeed of 57 KTS, using full flaps. During the landing, the acft bounced, and reportedly, the plt…NTSB ATL83LA187Accident · No injuriesLimited investigationFinal reportCessna 210L · Hickory, NCThe acft ran off the end of a grass strip and nosed over. The pilot said the approach and touchdown were normal but the acft did not slow as fast as he expected. As the runway end approached the pilot used hard braking and the acft slid offthe end of the…NTSB CHI83LA217Accident · No injuriesLimited investigationFinal reportCessna 172 · Mchenry, ILThe acft went off the departure end of runway 09 during landing and nosed over. The weather as reported by the operator,was scattered clouds, more than 5 miles visibility and winds calm. Runway 09 had been in use all day. The pilot stated that his approach…NTSB FTW83LA229Accident · No injuriesLimited investigationFinal reportBeech B60 · Afton, OKAfter touchdown the plt applied brakes to slow the acft in order to turn off the mid-field exit, but the acft was going too fast for the turn. The plt stated he felt the brakes begin to be ineffective at this point. He then decided to let the acft roll to the…NTSB LAX83LA223Accident · No injuriesLimited investigationFinal reportCessna 172M · Furnace Creek, CAWhile landing on rwy 33, the plt saw soft terrain ahead as he approached the end of the rwy. He elected to turn left off the rwy to stop; however, the acft encountered soft terrain & nosed over.NTSB LAX83LA215Accident · No injuriesLimited investigationFinal reportNorth American Rockwell S2R800 · Fallon, NVThe acft overran the departure end of the rwy during takeoff. The acft had a full load of fuel and about 250 lbs. Of insecticide. The acft had attained a speed of 65 mph as the end of the rwy was approached. The pilot stated that he thought he could make the…NTSB LAX83LA214Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201T · Lone Pine, CAThe acft overran the runway and collided with a ditch during landing. The runway being used was a portion of an unused dirt road which has no service facilities or wind indicators. The pilot made two passes over the area and in his statement he said he…NTSB SEA83LA090Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Malad City, IDDuring an interview, the plt reported that he had removed ice from the acft & attempted to depart from a snow covered alfalfa field, aprx 1000 ft long. The acft did not become airborne & the plt elected to abort the takeoff. During the abort, the acft…NTSB CHI83LA188Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Platteville, WIDuring arrival, the plt entered the traffic pattern to land on rwy 27 in x-wind conditions. The rwy was 2200 ft long & was wet from light rain. After making 2 go-arounds, a landing was made on the 3rd apch. The plt reported that the braking was poor to nil.…NTSB CHI83LA179Accident · Serious injuriesLimited investigationFinal reportSchweizer SGU 2-22E · Cadiz, OHThe student pilot had spiraled down on base to final approach instead of entering a downwind leg as briefed. As the student turned on final for runway 31, he saw an aircraft that had departed runway 13 and thought a hazard existed. Witnesses reported there…NTSB MIA83LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Zellwood, FLThe acft ran off the departure end of the runway and collided with a ditch during an aborted takeoff following a touch- and-go landing. The instructor stated that the student made the landing and prepared the acft for takeoff. Power was applied and at 45 KTS…NTSB SEA83LA080Accident · No injuriesLimited investigationFinal reportCessna TU-206 · Dixie, IDThe aircraft collided with a pine tree off the departure end of the runway during landing. The airstrip being used is 1200 feet long. The purpose of using it was to give the pilot under instruction experience in bush-type airstrips. The p.u.I. Was making the…NTSB LAX83LA199Accident · No injuriesLimited investigationFinal reportBeech 35-A33 · Glendale, AZDuring a night landing, the acft was landed long, ran off the end of rwy 17 & was substantially damaged.NTSB LAX83LA187Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Fair Oaks, CAThe acft collided with terrain when it overran the runway on a pleasure flight. Night visual meteorological conditions prevailed. The pilot stated that upon arrival he was unable to see the 'wind indicator', however, when he saw an acft land to the north he…NTSB SEA83LA075Accident · No injuriesLimited investigationFinal reportCessna 172 PII · Snohomish, WAThe plt stated he misjudged the approach to land and landed on the last 1/3 of the runway. Brakes were applied during landing roll but the acft rolled off the end of the runway, struck a ditch with the nosewheel and came to rest inverted.NTSB LAX83FA173Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Compton, CAThe acft collided with a chain link fence and a brick wall during an attempted go-around after overshooting the runway during landing. The pilot was high and had about 25 percent of the runway left when he decided to go around. The landingwas attempted on…NTSB LAX83LA161Accident · Minor injuriesLimited investigationFinal reportBeech A24R · Upland, CAWhile on final apch to land, the plt saw 2 other acft taxi onto the rwy & began taking off. After the 2nd acft had pulled onto the rwy, the plt decided to go around. However as the acft on the rwy accelerated, there appeared to be sufficient room to land, so…NTSB ATL83LA138Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Stone Mountain, GAThe aircraft overran the departure end of the runway and collided with an embankment during an aborted takeoff. The student pilot did not file a flight plan or check the weather for this flight. The weather was VMC but the pilot startedthe takeoff down wind.…NTSB DEN83LA081Accident · No injuriesLimited investigationFinal reportCessna 421C · Gunnison, COThe plt began taking off on rwy 06 with a wind from 190 deg at 8 KTS. He stated that max power & RPM were obtained. He noted that he obtained 39 inches of manifold pressure & 2235 RPM at 100 KTS IAS. Reportedly, the acft rotated properly, but began to vibrate…NTSB CHI83LA145Accident · No injuriesLimited investigationFinal reportCessna 152 · Mt. Carmel, ILThe plt stated he landed downwind, the approach was high & fast & when the acft landed there was only 800 ft of rwy remaining. The plt could not stop the acft before it ran off the end of the rwy & nosed over in a plowed field. The plt is blind in one eye &…NTSB ATL83FA135Accident · Serious injuriesField investigationFinal reportPiper PA-28-161 · Chamblee, GAThe acft overran the departure end of the rwy during landing rollout on a dark night. The weather was VMC. The pilot misunderstood atlanta approach control concerning rwy lighting and picked a rwy at the uncontrolled arpt that was unlighted. It intersected a…NTSB FTW83LA147Accident · No injuriesLimited investigationFinal reportMooney M20E · La Grange, TXThe plt reported that during the apch, the acft was high & had excessive airspeed, which resulted in a long landing. After touchdown, he applied full brakes, but was unable to stop on the remaining rwy. The acft continued off the end of the rwy, went down an…NTSB ANC83FAG07Accident · No injuriesFinal reportTaylorcraft BC-12-D · Aleknagik, AKThe aircraft was ground looped to prevent an overrun and collided with a snow berm during landing. The pilot stated thathe floated half way down the runway prior to touchdown. When he tried to turn, the acft weathervaned into the wind and steered him to the…NTSB CHI83LA126Accident · No injuriesLimited investigationFinal reportVarieze Varieze · West Lafayette, INThe pilot landed fast and went off the side of the runway after about 3000 feet of roll. A collision with VASI lights stopped the Varieze. This was the pilot's first solo flight in this type aircraft. She had a very short 1/2 hour checkout by the owner of the…NTSB DEN83LA066Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Cut Bank, MTThe acft nosed over after overrunning the end of the runway during an aborted takeoff. The runway was grass and there was a 90 degree crosswind. During takeoff a downdraft put the acft back on the ground. The pilot decided to abort the takeoff and retarded…NTSB LAX83LA118Accident · No injuriesLimited investigationFinal reportCessna 182J · Peoria, AZThe acft collided with a sign and a wall during an attempted go-around after an overrun. The pilot was practicing and had made 2 short field landings on the 3rd approach he forgot to lower flaps. His approach was fast and long and he landed too FAR down the…NTSB CHI83LA117Accident · No injuriesLimited investigationFinal reportBeech 58 · Detroit, MIDuring arrival, the plt received vectors for an ILS approach. He elected to make a localizer only approach. At the outer marker, the acft was aprx 200 ft above the minimum altitude & above the approach speed. The plt reported that he reduced the airspeed…NTSB MIA83FLD02Accident · Serious injuriesFinal reportCessna 310R · Cedar Key, FLReportedly, the flt instructor (CFI) elected to demonstrate a short field landing & landed the acft with the stall warning sys on. He reported that after touchdown, he tried to slow the acft with the brakes, but it would not slow down. The CFI then elected to…NTSB FTW83LA120Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Winslow, ARDuring dual instructional flt, the student plt was practicing a short field takeoff. After lifting off into ground effect, he elected to abort the takeoff when he did not think the acft was accelerating fast enough. The instructor pilot (CFI) stated that he…NTSB MIA83FA074Accident · 2 fatalField investigationFinal reportRockwell 690A · Winter Haven, FLThe acft crashed into a ditch off the departure end of the rwy and burst into flames during takeoff. Witnesses said the acft did not sound like it was developing normal RPM for takeoff. One mechanic said the engines sounded like they were still in ground idle…NTSB CHI83LA106Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Vernon, ILThe aircraft ran off the end of a runway and collided with a ditch. The student pilot on his first solo cross country had become disoriented and landed 95 miles off course. He had been flying 2 hours and 30 minutes. He was supposed to reach enroute stop after…NTSB LAX83LA094Accident · No injuriesLimited investigationFinal reportPiper PA-32 · So. Lake Tahoe, CAThe takeoff was initiated downwind on runway 36, which was 8544 ft long and was wet. The field elevation was 6264 ft. the aircraft was observed by tower personnel to rotate about 3000 ft down the runway, then climb to about 50 ft AGL. The pilot elected to…NTSB ATL83LA100Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · St. Joseph, TNThe aircraft overran the end of the runway during a night landing in IMC weather. The runway was a private dirt strip. Flight purpose is not known but it is suspected it was a drug smuggling flight. The aircraft landed long on the 2400 foot strip and went off…NTSB MKC83LA062Accident · No injuriesLimited investigationFinal reportCessna 152 · Sedan, KSThe student pilot was on the return leg of a round robin cross country when the encountered clouds and diverted to cushing, OK. Later, when he departed from cushing, he forgot to reset his directional gyro to correspond with the magnetic compass. When his…NTSB LAX83LA086Accident · No injuriesLimited investigationFinal reportCessna 172N · Lake Wohlford, CAThe acft ran off the departure end of the runway during an aborted takeoff and nosed over. The pilot started a takeoff on a 1500 foot dry runway. After about 1000 feet of runway had been used the pilot decided to abort the takeoff. Brakes were applied and the…NTSB LAX83LA081Accident · No injuriesLimited investigationFinal reportBeech BE-60 · Watsonville, CAThe pilot overran the runway and collapsed the nose gear during a landing in instrument flight conditions. He had begun a missed approach procedure due to environmental conditions when he noticed he could still see the runway and decided he could make a…NTSB FTW83LA091Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Nacogdoches, TXDuring arrival, the acft was high on final approach. The plt elected to continue the landing with full flaps, but after touchdown, he was unable to stop on the remaining runway. After overrunning the runway, the acft nosed over in a 10 ft drainage ditch.NTSB ANC83LA031Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Wainwright, AKThe aircraft ran off the departure end of the runway during landing. A passenger stated that the aircraft touched down at about mid-field at a higher than normal airspeed and bounced once before sliding off the end of the runway. The gravel runway was covered…NTSB MKC83LA056Accident · No injuriesLimited investigationFinal reportCessna 182RG · Woodbine, IAPilot checked braking on icy sod runway before takeoff and it seemed to be all right. Upon returning to land the pilot noticed a farmer driving cattle near the landing threshold so he decided to land long instead of going around. Using half flaps he landed…