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 ATL86IA093Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-31 · Charleston, SCThe acft landed on rwy 15 at 2357 EST. The rwy was wet from heavy rain & thunderstorms. Braking was ineffective and the acft failed to stop. The capt steered rt into the mud to the rt side of the overrun. Post accident review of the flt data recorder showed…NTSB DCA86AA018Accident · Minor injuriesFinal reportMcDonnell Douglas DC-9-31 · Erie, PADrg arrival, the crew of us air flt 499 lndd on rwy 24, which was cvrd with snw. Rprtdly, while lndg, the acft touched dwn aprx 1800 to 2000' bynd the displaced threshold. Altho armed, the spoilers did not auto-deploy, so the capt operatedthem manually. He…NTSB LAX86LA119Accident · Minor injuriesLimited investigationFinal reportBeech E18S · Kalaupapa, HIThe acft crashed off the end of rwy 23 during an attempted go-around after touchdown. The plt stated that after the acft touched down aprx 300 ft down the 2,760 foot rwy he raised the flaps along with the nose of the acft to slow down. Brakes were applied and…NTSB LAX86LA118Accident · No injuriesLimited investigationFinal reportMitsubishi MU-300 · Carlsbad, CAThe acft ran off the end of rwy 24 at the mcclellen-palomar arpt. Light rain was reported at the time and the winds were reported to the plts as being from 340 degs at 10 KTS. The rwy is constructed of a porous friction course (pfc) material which provides…NTSB LAX86LA116Accident · No injuriesLimited investigationFinal reportCessna 182M · Healdsburg, CAOn February 8, 1986, at 1430 PST a Cessna 182, N91614, overran the landing surface and nosed over at a dirt strip. VMC prevailed at the time. The winds were generally calm with sporadic gusts from the north at approximately 10 knots. There was no indication…NTSB ATL86LA059Accident · No injuriesLimited investigationFinal reportBeech A36TC · Louisville, KYPlt attempted t.o. from slush covered rwy with about 1/2 to 3/4 inch of snow on acft. When snow did not blow off the wings, abort attempted at between 80-100 knots. Acft went off the end of the rwy and through fence before coming to a stop on the golf course…NTSB DEN86LA062Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Hope, NDThe plt stated the citabria he was piloting failed to obtain flying speed before reaching the end of the snow covered private airstrip. According to the pilot, he aborted the takeoff too late. The acft contacted a snowbank and nosed over. The plt said that…NTSB CHI86MA056Incident · No injuriesMajor investigationFinal reportMcdonnell Douglas DC-10-10 · Detroit, MIN101AA was operating as American flt 192. Flt 192 was originally cleared to land on rwy 21R; however, a preceeding acft had a landing gear problem, so flt 192 was cleared to land on rwy 21C, instead. The coplt, who was flying the acft, made a side-step…NTSB MKC86LA039Accident · No injuriesLimited investigationFinal reportCessna 182RG · Wentzville, MOThe pilot stated that he winds were calm when he made the tou long, on the runway, attempted a go around and ran off the end of the runway into a field when the airplanefailed to get airborne.NTSB LAX86LA067Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Glendale, AZAfter completing a LCL flight the plt returned to his home base arpt & proceeded to land on the 2400 ft long rwy. The plt reported that he was unable to stop at its end and collided with barricades and a fence. A witness reported that the acft skidded on the…NTSB LAX86FVD03Accident · 1 fatalFinal reportAero Commander 680T · Concord, CAOn 12/3/85 at aprx 0830, the acft was fnd lying inverted in a canal adjacent to the arpt where it had been on 24 hr standby for medical flts. Twelve days later, the plt's body was also fnd in the canal. An investigation revealed the acft had been taken…NTSB ATL86LA033Accident · No injuriesLimited investigationFinal reportAero Commander 500 · Albany, GAThe aircraft landed on the wet sod runway with a 30 to 35 knot tailwind and ran off the end of the runway and into the trees. The pilot related that the wind shifted 180 degrees upon touchdown. The pilot also stated that he touched down approximately 1000 ft…NTSB DEN86LA043Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Hayes, SDThe plt stated that during the uphill ldg on snow covered terrain, the acft crested the hill, then started downhill on the opposite side. According to the plt he was unable to stop the acft before reaching a cliff. The plt egressed the acft prior to it going…NTSB ATL86FA020Accident · Serious injuriesField investigationFinal reportHawker Siddeley DH 125-400A · Sparta, TNTen minutes prior to landing heavy rain fell on airport. Acft mad normal touchdown,spoilers & lift dump activated.PIC delayed brake application as usual and did not get thrust levers in idle. After acft passed mid-field taxiway PIC reported brakes became…NTSB NYC86LA029Accident · No injuriesLimited investigationFinal reportCessna 152 · Bloomsburg, PAThe plt landed with a 15 KTS tailwind and over a 30 ft obstacle. The acft touched down 1/2 way down the 2000 ft long rwy. Due to excessive speed the acft went into the overrun and became airborne for a short distance before touching downin a nose low altitude…NTSB MKC86LA019Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Weeping Water, NEThe pilot stated that he was going too fast when he touched down on the short runway and should have made a go around. The airplane went off the end of the runway, went down a slope and impacted a piloe of rocks.NTSB MIA86IA018Incident · No injuriesIncident investigationFinal reportGrumman American AA-5 · Live Oak, FLThe acft made a downwind landing touching down long on the rwy. The acft could not be stopped & ran off the end of the rwy. The plt stated that he misread the windsock.NTSB FTW86LA021Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Amite, LAThe plt reported a loss of brake effectiveness while landing on a dew-covered sod strip. Unable to stop, the acft slid through a fence, damaging the wings.NTSB DEN86LA012Accident · No injuriesLimited investigationFinal reportBeech D50A · T/C, NMA person identifying himself as leon taylor, notified the FAA in albuquerque, n.m., that the twin-bonanza acft he was piloting, overran the improvised airstrip where he was attemptting to land & crashed. Mr taylor was never heard from again. The n.m. state…NTSB FTW86FRD01Accident · No injuriesFinal reportNorth American AT6G · Jennings, LAThe acft contacted a ditch and nosed down during an overrun landing. The acft was in a flt of 3 AT6'S landing at the arpt for a fly-in. N104DC touched down on the 2000 ft freshly mowed grass strip aprx 500 to 600 ft from the end. The plt stated the…NTSB DCA86AA001Accident · Serious injuriesFinal reportVickers Viscount VC-810 · Bloomington, INDrg an ILS to rwy 35, the apch was normal until the acft was aprx 100' abv the decision height, except there was condensation on the windshield. Touchdown was hard. A witness said the acft lndd aprx 1/3 of the way down the 5200' rwy. After lndg, with the…NTSB NYC86LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Columbia, PAThe acft collided with 6 ft high poles during an overrun landing. The plt stated he was making a landing and noted on short final that the airspeed was excessive. The rwy was grass was freshly cut, wet and slippery. The acft landed long and ran off the end of…NTSB FTW86LA022Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Houston, TXThe student was instructed to follow through with his left hand on the controls during the takeoff. After liftoff the CFI felt that the acft was climbting too steeply. He told the student to get off the controls, thinking that he was applying too much back…NTSB SEA86LA006Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Emmett, IDWhile landing in calm wind conditions on a 2400 ft rwy, the left brake failed & the acft contd off the departure end, then hit a fence. An exam revealed the left brake pads were worn & the left actuator cylinder was losing fluid. The brake backing plate & the…NTSB BFO86LA001Accident · No injuriesLimited investigationFinal reportCessna 172N · Annapolis, MDThe plt crossed mid-field, and entered a left down wind for rwy 30. He then checked wind direction, completed a base leg, and entered final apch. After reducing his airspeed, the acft 'floated' prior to touching down aprx 600 ft short of mid-fld. The plt…NTSB CHI86LA003Accident · No injuriesLimited investigationFinal reportCessna 172F · Canton, OHThe acft overran the rwy and collided with wires and a pole during landing. The student plt stated that he was too fast and landed long during the calm wind landing. He also stated he should have used more flaps.NTSB LAX85LA404Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Huntington Bch, CAThe plt acknowledged that on short final approach to the 2330 ft-long rwy, the acft's speed was 'a little hot', & during ldg flare the acft 'floated in ground effect'. After the acft bounced 3 times the plt decided to go around & he applied full pwr. The plt…NTSB NYC85LA247Accident · No injuriesLimited investigationFinal reportCessna P210N · Marlboro, NJThe plt made a VOR apch to the arpt and circled to land while simultaneously determining wind condition. It was raining at the time. A landing was made on rwy 27. On touchdown, the plt stated, his brakes were ineffective. He described the rwy as wet. Since it…NTSB ATL85FKG12Accident · No injuriesFinal reportCessna 172P · Birmingham, ALDuring arrival, the plt noted that the wind was from about 150 degs. Due to the terrain & obstructions near the northeast end of the rwy, he elected to land on rwy 4. During the landing, the acft floated before touching about 1/3 to 1/2 of the way down the…NTSB NYC85LA246Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Bayport, NYAccording to the CFI, the student raised the nose of the acft too early during takeoff. This resulted in the acft becoming airborne prematurely. The student was unable to climb out of ground effect and the decision to abort the takeoff was made. The acft…NTSB CHI85LA382Accident · No injuriesLimited investigationFinal reportNavion 61G · Greenwood, INThe plt landed long on the 4000 ft asphalt rwy. He stated he was applying heavy braking when his foot slipped causing him to strike and advance the throttle. The acft rolled off the end of the rwy into a corn field.NTSB MKC85LA218Accident · No injuriesLimited investigationFinal reportCessna 210N · Mullen, NEThe takeoff was being made from a hay meadow that was soft due to recent rains. The property owner said the field was 1/4 mi long. The density alt was calculate to be 5600 ft. the plt said the acft did not attain takeoff speed & that it collided with a fence…NTSB SEA85LA200Accident · No injuriesLimited investigationFinal reportCessna 180A · Buxton, ORThe pilot misjudged his touchdown point on the 1,000 foot airstrip and had an excess of airspeed. And overrun occurred and the aircraft went down an embankment. At the time of touchdown, there was only about 4 KTS of headwind available.NTSB SEA85LA196Accident · No injuriesLimited investigationFinal reportCessna 150L · Bellingham, WAThe plt, who was unfamiliar with the area, was given directions & traffic pattern info to the meadows mist arpt, a a pvt/charted strip near Bellingham, WA. She came upon a similar grass strip in that area with a parked acft on it. Thinking this uncharted…NTSB DEN85LA217Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Ruidoso, NMAcft was 20 lbs over the max gross weight. Plt said he aborted the first takeoff due to a rough running eng. The plt performed a runup and attempted a second takeoff which was aborted again due to rough running eng. The acft ran off end of rwy and struck a…NTSB NYC85LA212Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Doylestown, PAAccording to the plt, on touchdown the acft braking was ineffective due to morning dew on the grass rwy. The acft slid off the end of the rwy and collided with bushes.NTSB CHI85LA341Accident · No injuriesLimited investigationFinal reportCessna 172H · Whitewater, WIAccording to the plt he planned to use max performance takeoff procedures out of the owner's manual for the takeoff. After brake release the acft began to roll down the sod rwy. Acceleration continued, but according to the plt, his airspeed increase seemed…NTSB NYC85LA202Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Wildwood, NJN21521 taxied onto runway 10 at the intersection of runway 14 after observing another aircraft taxi and take off from that point. N21521 did not attain sufficient airspeed for takeoff prior to running out of available runway. The pilot did not apply hard…NTSB CHI85LA320Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Franklin, WIThe pilot used a shortfield takeoff and the acft would not fly. The plt aborted the takeoff and landed on the end of therwy, overrunning the rwy and striking a ditch. The plt reported engine RPM normal and the acft was under max gross takeoff weight.NTSB SEA85LA175Accident · No injuriesLimited investigationFinal reportCessna 150C · Chesaw, WAThe student plt landed on an unnamed, 1200 ft landing strip in calm wind conditions. He stated that during the landing, he misjudged the distance & overran the rwy. After departing the rwy, the acft encountered terrain with a tree root system & nosed over.NTSB NYC85LA170Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Provincetown, MADuring arrival, the acft was vectored for an ILS rwy 7 apch which was made with a tail wind. On his 1st attempt, the plt made a missed apch & was vectored for another ILS. After making a 2nd apch, he landed. The plt stated that while he was landing, he…NTSB NYC85FA166Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Tioga, PAThe plt initiated a downwind landing on a grass rwy that sloped mostly uphill, but began sloping downhill at its departure end. A witness near the apch end of the 2150 ft rwy watched the acft touch down beyond its midpoint, then disappear over its crested…NTSB ATL85LA211Accident · No injuriesLimited investigationFinal reportCessna 172 M · Statesville, NCWhile en route, the plt encountered reduced visibility & had difficulty finding the airstrip. His 1st apch to land was high & he made a go-around. The plt landed on his 2nd attempt, but was unable to stop on the wet grass rwy. He delayed attempting a…NTSB NYC85LA167Accident · Minor injuriesLimited investigationFinal reportPiper PA28-151 · Chatham, MADuring the final approach to runway 24, the aircraft was too high and fast. The pilot decided to land on the runway instead of going around. According to the pilot, the aircraft landed too FAR down the runway and went over the end.NTSB NYC85LA165Accident · No injuriesLimited investigationFinal reportBeech C23 · Penn Yan, NYThe plt was familiar with the arpt, during the landing the plt observed the wind sock indicating calm winds and the acft was landed into the sun. During the landing roll, pwr was added for takeoff. When the acft was aprx 2/3 the way down the rwy, the plt…NTSB FTW85LA284Accident · No injuriesLimited investigationFinal reportGrumman AA5B · Sonora, TXWhile landing at an unfamiliar strip, the plt observed a rough surface at the apch end, and landed one halfway down the down-sloping 2300 ft rwy. He tried to go around, but could not accelerate enough, and the acft rolled thru 2 fences, trees, then stopped…NTSB FTW85LA277Accident · Minor injuriesLimited investigationFinal reportCessna R182 · Midland, TXThe plt stated that on a pass over the pvt strip the wind sock as indicating the wind out of the north. In actuality, Midland regional arpt was reporting the winds from 110 degs at 13 KTS. Touchdown was made at a higher than normal airspeed. The acft landed…NTSB FTW85LA272Accident · Minor injuriesLimited investigationFinal reportCessna T-210 · Knippa, TXThe new owner was attempting takeoff from a dirt road obstructed by a mobile irrigation system. He pulled the acft off the ground after 1700 feet of takeoff roll. Unable to maintain flying speed, he landed in a soft fld and the acft nosed over when the nose…NTSB MKC85LA148Accident · No injuriesLimited investigationFinal reportCessna 172B · Valley Center, KSThe pilot had been flying with his young son as passenger during daylight hours. He went solo to get current at night. After two full stop landings, he thought the yoke felt heavy for the trim setting he usually used but he started a takeoff anyway. Halfway…NTSB MKC85LA146Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · El Dorado, KSThe acft had just undergone annual inspection. Pilot failed to remove control lock before test flight. On takeoff roll, pilot was not able to move controls, went off end of 1800 ft runway, through a fence and impacted a dirt pile.