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 NYC85LA036Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Meriden, CTWhile in cruise, plt heard an abnormal sound from the left side of the engine compartment and having had previous problems with the newly-installed engine, elected to make a precautionary landing at a nearby arpt to investigate. Plt stated he landed long and…NTSB LAX85LA056Accident · Serious injuriesLimited investigationFinal reportGulfstream AA-5A · Llano, CAThe plt of the departing acft reported that he broadcast his intentions of takeoff & he made a 360 deg clearing turn to check for inbnd acft before beginning his takeoff roll on rwy 07. Prior to becoming airborne the plt observed an acft on short final apch…NTSB CHI85LA057Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Blaine, MNInvestigation revealed that the plt landed the acft on rwy 35 with winds from 130 degrees at 15 KTS gusting to 23 KTS. The acft departed the end of the 4900 ft rwy where the left fuel tank was ruptured and a fire erupted.NTSB ANC85FA023Accident · No injuriesField investigationFinal reportPiper PA-28RT-201T · Anchorage, AKThe acft crashed during the takeoff roll by running off the departure end of the rwy, gliding over a hwy & impacting trees. According to the plt, 'on takeoff, we accelerated to 90-95 KTS, but the acft did not respond to back pressure for lift off. We…NTSB ANC85LA021Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Koliganek, AKThe acft crashed when it failed to become airborne during the takeoff run. The plt & witnesses agreed that snow was not removed from the acft prior to departure.NTSB SEA85LA033Accident · No injuriesLimited investigationFinal reportCessna 175 · Indian Meadows, IDLanded long and acft slid off end of rwy on compact snow and ice contacting a snow berm near end of rwy.NTSB NYC85LA021Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Oxford, CTAfter entering the traffic pattern for the selected runway, plt was informed of surface wind conditions and elected to continue and execute a downwind landing. Upon touchdown, plt raised flaps to assist braking action. During roll-out the plt decided…NTSB CHI85LA019Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Compton, ILThe plt stated that he landed aprx 1/4 way down the wet sod rwy which is 2590 ft long. The braking action was nil. The acft ran off the end of the rwy & collided with a 3 ft embankment.NTSB FTW85LA013Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Booker, TXPlt arrived at destination at dusk. Lighted wind tetrahedron was out of service. Plt executed low pass in unsuccesful attempt to see windsock. Plt was aware of strong surface winds (about 35 KTS), presumed to be from sw, from recent frontal passage and…NTSB MIA85LA007Accident · No injuriesLimited investigationFinal reportCessna T210N · Live Oak, FLThe acft was landed long on the rwy according to the plts statement. He also said that he could not go-around because OF50 ft trees at the end of the rwy, so he elected to aim (place) the acft 'between a tree & house for safety reasons.' The accident happened…NTSB LAX85LA010Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Concord, CAThe plt stated that he did a go-around while on final approach to runway 19L because of excessive speed. The plt re-entered the traffic pattern and was cleared by the tower to lnd on rwy 19R. The plt stated that he was advised by the tower to initiate the…NTSB FTW85LA020Accident · No injuriesLimited investigationFinal reportCessna 310C · Los Fresnos, TXThe plt stated that he landed on rwy 32 after noting vertical rising smoke about 1/2 mi north of the airstrip. He stated that during landing he encountered a 20 to 25 kt tailwind from a small local squall line & was unable to stop the acft. The acft continued…NTSB ATL85LA003Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Gold Hill, NCThe plt was uable to raise UNICOM for wind advisories and was unable to find the wind sock to aid in rwy selection. He did see some smoke on the ground which indicated calm winds. During his flare the acft floated about halfway down the rwy, touched down and…NTSB CHI85LA006Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Lincoln, ILAccording to the pilot touchdown occurred on the first third of the rwy and braking seemed ineffective. He further stated that as brake pressure was increased the seat back failed. A representative of the FAA examined the seat and found no evidence of…NTSB CHI85LA008Accident · No injuriesLimited investigationFinal reportCessna 172N · Youngstown, OHAfter returning to the arpt, the plt entered the pattern for a x-wind landing. He made 3 go-arounds while attempting to land. On the 4th apch, the acft touched down, then became airborne again. The plt decided 'to much time had passed to make another…NTSB CHI85LA003Accident · Minor injuriesLimited investigationFinal reportCessna 150F · West Branch, MIThe plt reported that when he arrived at night, he was unable to activate the rwy lights, but decided to land anyway. He touched down long on the 3700 ft rwy & was unable to stop on the remaining area. The acft continued off the end & hit a ditch where the…NTSB LAX85LA001Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Redding, CARunway 15 was in use. Plt broadcast on UNICOM freq intention to land rwy 15. Plt landed on rwy 33 with a 10 kt tailwind. On landing roll, plt realized he would not be able to stop on remaining rwy & go-around was initiated. Acft did not attain flying speed…NTSB ANC84LA195Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Tikchik Lodge, AKThe plt attempted a takeoff from a 500 ft sand bar and during the takeoff roll the main landing gear struck soft spots. Realizing the acft was not going to become airborne he closed the throttle attempting to stop in the remaining distance. The acft left the…NTSB SEA84LA236Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Darrington, WAThe acft went off the rwys end into a tree stump and brush during landing. The plt said he landed with excess speed and was unable to stop. The plt recommended that a go-around should have been performed.NTSB ANC84LA174Accident · Minor injuriesLimited investigationFinal reportCessna T-207 · Daniels Creek, AKPilot stated that after landing 100 feet past the runway threshold, the aircraft appeared not to be stopping when brakes were applied. A go-around was initiated, but the aircraft failed to get airborne and ran off the departure end ofthe strip colliding with…NTSB SEA84LA227Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Kasaan Penninsu, AKPlt attempted takeoff from glassy water with a deer tied to the left float. The right float would not come up on the step to attain lift off. The pilot's decision to abort was too late to avoid a collision with rocks at the end of the lake.NTSB FTW84LA385Accident · No injuriesLimited investigationFinal reportCessna A188B · Maysville, OKWith aprx 300 ft of rwy remaining the plt rotated. The acft flew to about 15 ft before it settled back to the ground at the end of the sod strip. After rolling through 2 fences the acft collided with a dirt bank next to a ditch collapsing the main gear. The…NTSB ATL84LA283Accident · No injuriesLimited investigationFinal reportCessna 182B · Kannapolis, NCThe plt reported that because of grnd fog in wilkersboro, NC, he diverted to Kannapolis, NC. Upon arriving over enochuille airport, he observed that grnd fog was present on the lake which is located adjacent to the arpt. Due to the fog, the plt elected to…NTSB CHI84LA382Accident · No injuriesLimited investigationFinal reportGrumman AA-5 · New Carlisle, OHThe acft collided with trees after overrunning a 2000 ft wet sod airstrip. The plt reported that braking action was poorthe acft went into an evergreen tree nursery before stopping.NTSB ATL84LA279Accident · No injuriesLimited investigationFinal reportBeech 58 · Laurens, SCThe acft ran off the end of the rwy during landing. The plt reported that he started using brakes to stop the acft but it veered to the right. Examination by maintenance revealed that the left brake disc, p/n 164-06100, had failed at the mount flange.NTSB NYC84LA298Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Eagle Crest, DEAfter landing the plt used power to continue taxiing to the end of the wet grass rwy. Stopping distance was misjudged when braking began and the acft overran the rwy colliding with a small ditch. One main gear and the nose gear collapsed.NTSB MIA84LA244Accident · No injuriesLimited investigationFinal reportMooney M20J · Key Largo, FLAcft was landed downwind and touched down aprx half way down the rwy. The plt in an attempt to avoid an overrun intentionally ground looped the acft resulting in a left main gear collapse.NTSB LAX84FUJ03Accident · Serious injuriesFinal reportCessna T337E · Chandler, AZThe plt reported that on the first attempt to rotate, the stall warning horn activated. The plt noticed the rear eng in an overboost cond so he retarded the throttle completely, then advanced it to below red line. He continued the takeoff and attempted to…NTSB ANC84LA168Accident · No injuriesLimited investigationFinal reportCessna Ector 305A · Anchorage, AKLanding area selected by plt was slick due to mud from recent tidal waters. Acft slid on touchdown and plt was unable to stop. Applied full pwr in attempt to clear a gully at end of landing area. Main gear contacted FAR edge of gully and acft nosed over.NTSB SEA84LA213Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Shoshone, IDThe plt attempted takeoff from a wet alfalfa field. High vegetation and soft terrain prevented proper acceleration to lift off speed. The nosewheel struck an embankment and the aircraft nosed over.NTSB FTW84LA370Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Tahlequah, OKLaw enforcement officers responding to the acft accident found the acft inverted beyond the south end of the runway. Plt stated he and his passengers had been drinking beer and decided to go flying. Plt's statements to officers are not clear on exact events…NTSB NYC84LA296Accident · No injuriesLimited investigationFinal reportCessna 172P · Manville, NJAcft swerved on rwy before rotation and climbed aprx 10 feet before settling back on the rwy. Plt aborted the takeoff but was unable to stop before end of rwy.NTSB NYC84LA287Accident · No injuriesLimited investigationFinal reportCessna 152 · Ellicottville, NYThe plt started taking off from an unimproved, grass covered fld, but the acft would not accelerate above 50 KTS. He aborted the takeoff, but the acft continued off the end of the rwy where the nose gear was torn off & the left main gear & right wing tip were…NTSB MKC84LA257Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Flippin, ARThe acft ran off the departure end of the rwy during landing and collapsed the landing gear. The acft landed between 1/3AND 1/2 way down the rwy. The acft had been in rain showers and the rwy was wet. The plt applied brakes but braking was ineffective and the…NTSB CHI84LA351Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Acme, MIThe landing gear collapsed as a result of an intentional ground loop when the aircraft overran the runway after a bounce 450 ft beyond the approach end of the 2300' long grass strip. The pilot stated he added throttle, then landed on the remaining runway, but…NTSB NYC84LA289Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Marlboro, NJThe plt diverted to the Marlboro arpt due to thunderstorm activity in the vicinity of his destination. During an approach to land, the acft encountered turbulence & the plt was injured by a loose object in the cockpit. At about the same time, there was a…NTSB FTW84LA361Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Tyler, TXPlt landed long and fast at a small, unmarked airstrip. On lndg roll, plt realized an overrun was imminent and added power for go-around. Plt then decided insufficient clear space remained for a succesful go-around and aborted the attempt, locking the brakes…NTSB NYC84LA272Accident · No injuriesLimited investigationFinal reportCessna 152II · E. Windsor, CTPlt failed to note inoperative airspeed indicator until well into takeoff run. When the defect was noted, takeoff abort procedures were performed but the acft continued beyond the airport boundary into a rough field and nosed over. Investigation revealed the…NTSB MKC84LA248Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Branson, MOExcessive airspeed caused the acft to float about halfway down the rwy prior to touchdown. A go-aground was initiated with the addition of power but the plt then elected to attempt to stop due to low airspeed and minimal rwy remaining. The plt then applied…NTSB FTW84LA345Accident · No injuriesLimited investigationFinal reportCessna A185F · Tomball, TXBefore takeoff 2 paxs boarded so the instructor could demonstrate to the student the effect that additional weight has on acft handling on water. According to the instructor the acft would not become airborne during takeoff. The acft overran the waterway,…NTSB LAX84LA432Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Compton, CAThe student pilot attempted a second full stop landing on rwy 25R. The airport management personnel stated that the wind was favoring rwy 7. The student plt stated that the acft appeared to have a faster than normal ground speed. The acft touched down near…NTSB MIA84IA222Incident · No injuriesIncident investigationFinal reportMooney M20F · Kissimmee, FLAccording to the plt, the acft encountered a gust of wind during the landing roll & became airborne, then touched down again. Subsequently, the acft overran the end of the rwy & was damaged. The plt reported that there was a thunderstorm approaching the…NTSB SEA84LA191Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Elk City, IDThe plt stated that while landing on the uphill curved airstrip a 30 knot tailwind gust occurred. Due to obstacled and the wind, the plt disregarded an aborted landing and continued straight ahead on the runway. The acft traveled off the departure end of the…NTSB MIA84LA224Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Cedar Key, FLPlt stated touchdown was beyond runway numbers. Braking was not initiated until halfway down the 2400 ft long rwy. No deceleration apparent even with max pressure applied to pedals. Plt did not rpt attempt to pump brakes or use assymetrical braking but was…NTSB DEN84LA250Accident · No injuriesLimited investigationFinal reportCessna 414 · Albuquerque, NMPlt originally planned apch to rwy 17 but changed rwy when informed by another acft that rwy 35 was the active. Two witnesses reported winds at the time were from the east, one stating 5 to 7 mph the other stating light and variable. Plt stated apch speed of…NTSB FTW84LA336Accident · No injuriesLimited investigationFinal reportBeech B-60 · Amarillo, TXAfter landing about 1/3 of the way down the rwy brakes were applied but were ineffective. The acft overran the rwy and collided with a four-rail steel fence. Inspection of brake system revealed pucks on both brakes to be very worn. No mechanical malfunctions…NTSB FTW84LA332Accident · No injuriesLimited investigationFinal reportCessna A152 · Fort Worth, TXThe plt stated that he landed too FAR down the rwy & could not get the acft stopped prior to running off the end & colliding with a gas meter & a fence. He also stated that he should have gone around instead of continuing the landing attempt.NTSB MKC84LA237Accident · No injuriesLimited investigationFinal reportPiper PA-23-250T · Hyannis, NEThe plt had made previous arrangements to have the passenger that was to be picked up use the headlights on his car to indicate the direction of landing. Upon arrival the plt saw the headlights on the south end of the rwy pointing north. The plt subsequently…NTSB FTW84LA355Accident · No injuriesLimited investigationFinal reportCessna 150E · Cleburne, TXPlt stated that while making a crosswind landing on a 2600 foot strip she misjudged her touchdown point and ran off the end of the strip, colliding with a fence. The plt landed on heading 350 degrees and the wind was reported to be from 090 degrees at 10…NTSB NYC84LA257Accident · Serious injuriesLimited investigationFinal reportGates Learjet 25B · Waterville, MEDuring preflight preparation for departure from a short field the plt failed to remove the pitot tube covers. On takeoff roll, the stall warning light began to flicker. Plt noted airspeed was not registering but did not consider this unusual in the early part…