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 SEA87LA159Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Hamer, IDThe plt rprtd that he bgn taking off on a downhill strip (aprx 1/2 mi long) with a left quartering tail wind. As the takeoff roll progressed, he realized an overrun was developing, so he bgn dumping his load & attempted to lift- off. He said the acft settled…NTSB CHI87LA186Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Nobelsville, INThe 160 hr tt pilot, recently checked out in this make/model acft, was returning to home base on a x-country flt. He ld long and was unable to stop before hitting a fence off the departure end of the rnwy.NTSB SEA87LA160Accident · No injuriesLimited investigationFinal reportCessna TR182 · Eatonville, WAThe plt rprtd that drg a lndg, the apch was a little high & the acft touched down long on the turf/gravel rwy. He thought there was sufficient rwy remaining to stop & did not initiate a go-around. However, he said 'braking on dry grass & moss was not…NTSB SEA87LA155Accident · No injuriesLimited investigationFinal reportBellanca 14-19-3A · Mahoney Creek, IDDrg arrival, the plt inadvertently lndd at the mohoney Creek arpt with a 2050' strip, instead of the intended arpt (indian Creek) which had a 5000' rwy. The arpt elev was 4618'; the density alt was about 7800'. While landing, an overrun occurred & the landing…NTSB NYC87LA218Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Newport, NHOn takeoff the aircraft failed to gain sufficient airspeed to maintain flight. The takeoff was aborted after reaching 200 feet altitude and the aircraft was landed on the runway. The aircraft continued off the end of the runway and collided with a sandbank.…NTSB CHI87LA181Accident · No injuriesLimited investigationFinal reportCessna 182J · Lansing, ILWhile landing on runway 27, the pilot overshot the runway and rolled into a shallow ditch.NTSB ANC87FA110Accident · Minor injuriesField investigationFinal reportCessna 182P · Anchorage, AKThere was hvy traffic when the plt of N1946M contacted Anchorage (anc) intl twr for lndg instrns at the lake hood strip. Anc twr ctld traffic at the nrby lake hood strip & lake hood seaplane base, as well as at the anc intl arpt. The wnd at lake hood had been…NTSB NYC87DNC11Accident · No injuriesFinal reportBeech C23 · Vergennes, VTThe pilot of the Beech C23 had taken off and was returning to the airport due to deteriorating weather conditions. The pilot attempted to land on runway 20, but made a go around because of gusty winds. On the second attempt to land on the same runway, the…NTSB MKC87LA146Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbia, MOThe instructor and the student were making a landing on a short grass runway. The instructor stated they landed fast and were not able to stop. He considered a go-around but decided sufficient runway did not remain to perform the go-around. The airplane…NTSB CHI87LA171Accident · No injuriesLimited investigationFinal reportBeech 23 · Danville, ILThe plt landed long and downwind on a sod farm strip. The acft ran off the departure end of the fld and struck trees.NTSB NYC87LA203Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Mattituck, NYDrg arrival, the plt tried to contact UNICOM, but was unable. He said he circled the 2200 ft rwy, but was unable to see the windsock due to reduced visibility with haze. He elected to land on rwy 19. The acft touched down about 500' from the departure end.…NTSB FTW87DRA09Accident · No injuriesFinal reportWeatherly 201C · Louise, TXThe acft was loaded with aprx 1100 lbs of fertilizer & the plt attempted to takeoff from a pvt strip on a 'still & muggy' day with a temp of about 95 deg. He rprtd that during the takeoff roll, he opened the dump gate when the acft was midway down the rwy to…NTSB CHI87LA166Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Chelsea, MIThe pilot and three passengers attempted a takeoff from a 1800 foot sod, upsloping runway with tall, wet grass. Density altitude was 2700 feet. As the aircraft climbed out of ground effect the pilot said the engine sounded 'funny' and aborted the takeoff. The…NTSB FTW87LA166Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Midland, TXDuring takeoff roll from mid-field on the wrong runway, the pilot realized he was running out of runway. He rotated the aircraft early and climbed to approximately 10 feet AGL. The aircraft would not climb. The pilot aborted the takeoff andapplied brakes…NTSB ATL87LA206Accident · No injuriesLimited investigationFinal reportCessna 172I · Goodway, ALThe plt rprtd that he lndd long on a 2500 ft grass strip which was wet due to hvy dew. Drg the apch, he had an airspeed of 75 to 80 KTS with 30 deg of flaps. Subsequently, the acft slid off the departure end & struck a pecan tree. The recommended final apch…NTSB DEN87LA171Accident · Minor injuriesLimited investigationFinal reportSocata TB-10 · Cripple Creek, COThis acdt occurred when the plt attempted to takeoff on a 2600 ft long rwy when the density altitude was about 13,500 ft. the acft overran the rwy and collided with a highway. The plt said that the field was too high and too short and it was too hot.NTSB ATL87LA196Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Sebring, OHPlt and his two pax had spent most of the day at barber apt preparing for the fireman's bbq to be held later. In late afternoon, they decided to take a flt around the area. During the flt, it was decided to land at the tri-city apt. Witnesses reptd that the…NTSB NYC87LA190Accident · No injuriesLimited investigationFinal reportAmerican AA-1A · Kralltown, PAThe plt attempted to takeoff from a 2130 ft grass strip on a relatively hot & humid day with an air temp of 85 deg. About 2/3 of the way down the rwy, he rotated the acft to takeoff, but it would not climb sufficiently to clear a hill beyond the arpt boundry.…NTSB LAX87LA253Accident · No injuriesLimited investigationFinal reportBeech C23 · Brownsville, CADuring a cross country flt, the plt over flew the rwy once for a visual wind speed and direction check. During the first approach the acft was too high so the plt went around. On the second approach, during the flare, the acft stayed airborne down most of the…NTSB NYC87LA184Accident · No injuriesLimited investigationFinal reportCessna 152 · Butler, PAThe student pilot landed at Butler farm airport. The plt overshot the normal touchdown point at excessive speed. The aircraft skidded off the end of the runway and collided with a three foot deep ditch and was substantially damaged.NTSB MKC87LA171Accident · No injuriesLimited investigationFinal reportCessna TU206G · West Plains, MODuring ldg phase of operation, PIC was unable to stop the acft before striking a fence on the overrun. Plt stated a rain shower had just passed through which left the dirt surface slick and muddy. He stated that he was unable to obtain effective braking due…NTSB LAX87LA237Accident · No injuriesLimited investigationFinal reportGrumman AA-5 · Rimrock, AZThe aircraft overran the runway while on a personal VFR cross-country flight. The pilot indicated that he attempted a go-around after a poor approach and that the terrain off the end of the runway rose faster than the aircraft could climb. A witness observed…NTSB ATL87LA176Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Marion, NCThe acft overran the rwy end while the student plt was attempting a no-flap ldg. The acft impacted a berm at the end of the rwy and subsequently came to rest in a creek. The student plt reported that the acft had initially touched down about mid-field on the…NTSB NYC87LA169Accident · No injuriesLimited investigationFinal reportCessna 414A · Binghamton, NYDuring takeoff roll, full throttle was applied to both engines but the left engine was slow to respond. When full pwr was not reached, the flight was aborted. The acft continued to roll off the dept end of the rwy and down a ravine. The plt stated that on the…NTSB NYC87LA171Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Middlesex, NYThe pilot stated that a normal t/d was made at 75 mph abt 1/3RD of the way down the rwy. During rollout, the acft went through a dip and became airborne again. After touching down again, brakes were applied but the aircraft did not stop on the wet, freshly…NTSB NYC87LA153Accident · No injuriesLimited investigationFinal reportCessna 182 · Ellington, CTThe pilot stated that while making a standard left traffic pattern, the wind at the north end of the airport shifted from the southeast to the northwest. The acft touched down with excessive ground speed, ran off the end of the rwy and came to rest on a…NTSB NYC87LA148Accident · No injuriesLimited investigationFinal reportCessna 182 · Honeoye Falls, NYThe acft was landed on a 1695 ft turf runway with dew covered grass that was aprx 3 inches tall. After touchdown, the plt applied brakes, but the acft skidded about 1000 ft, went off the dep end of the rwy & collided with a trailer. The trailer was moved…NTSB LAX87LA203Accident · Minor injuriesLimited investigationFinal reportBeech A65 · Coalinca, CAThe pilot attempted to takeoff from the 2,820 foot runway with a makeshift flight control gust lock in place. He was unable to liftoff with the controls locked and the nose gear collapsed when the aircraft overran the runway onto the rough/uneven terrain.NTSB SEA87LA087Accident · No injuriesLimited investigationFinal reportCessna 310L · Chiloquin, ORThe aircraft departed the end of the runway during landing roll. The aircraft then went down an embankment and through a fence. The right main gear collapsed with the aircraft turning 90 degrees before coming to rest. A tailwind was present during landing.…NTSB FTW87LA103Accident · No injuriesLimited investigationFinal reportCessna 172N · Pond Creek, OKPilot failed to lower flaps for a short field takeoff. After rotation the pilot realized that the aircraft would not clear a power line off the end of the runway and aborted the takeoff. The aircraft ran off the end of the runway and contacted a fence and…NTSB FTW87LA109Accident · No injuriesLimited investigationFinal reportCessna 172G · Houston, TXA student pilot on a solo flight in the local area, landed long and ran off the end of the runway. The pilot stated that the accident occurred due to touchdown too FAR down the runway. He further related that the presence of high tension wires influenced his…NTSB LAX87LA186Accident · No injuriesLimited investigationFinal reportCessna 310Q · Lower Lake, CAA Cessna 310Q overran rwy 30 and collided with terrain off the departure end. A witness stated the acft landed at aprx mid-field on the 2,485 ft by 50 ft asphalt rwy and was unable to stop. Based on the witnesses' statement aprx 1,240 ft would be available…NTSB NYC87LA128Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Lehighton, PADuring takeoff roll, the flight encountered a wind gust and the plt aborted the takeoff at about 1500 feet from the takeoff point. The acft continued to slide off the end of the runway, down a slope and across a road impacting two trees.NTSB SEA87LA081Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Alderwood, WAThe student pilot took off and landed with a 15 knot tailwind. During his second attempt to land an overun occurred. The aircraft departed the runway to the left onto soft ground where it nosed over inverted. This was the student pilots second solo flight.…NTSB DEN87LA082Accident · Serious injuriesLimited investigationFinal reportChampion 7GCBC · Rock Rover, WYThe plt was using a pasture for takeoff. The winds were calm and the takeoff run was slightly uphill. There was a low spot in the pasture which was soft from melting snow. The acft did not reach takeoff speed before reaching the end of the pasture. During the…NTSB MKC87LA073Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Halstead, KSThe PIC rptd lndg long on a 2600 ft sod rwy. During the lndg roll, the PIC rptd encountering a tailwind. The closest fss at wichita, 20 mi fm the accident arpt, rptd no significant wind chg during this period, the PIC, knowing that he had landed long and…NTSB FTW87LA089Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Laverne, OKDuring a downwind landing, the aircraft ran off the end of the runway contacting a barbed wire fence and subsequently a muddy field, substantially damaging the aircraft by shearing the landing gear off and tearing the wings on the top and bottom surfaces.NTSB LAX87LA166Accident · No injuriesLimited investigationFinal reportCessna 310 · Agua Dulce, CAThe non-multiengine rated pilot attempted to land his multiengine airplane on a 4600 foot runway. The aircraft touched down approximately half way down the runway and slid off the departure end. The aircraft impacted trees after departing the runway.NTSB ATL87LA097Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Toccoa, GAThe pilot overshot runway 20 and skidded off the departure end which caused substantial damage to the aircraft. The pilot stated that he should have descended to the normal visual traffic pattern altitude before attempting a landing. There were no reported…NTSB MKC87LA065Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Houston, MOThe airplane was on an IFR flight plan and five miles from the airport, the airplane broke out of the clouds and proceeded VFR to the airport. It was a dark night and light rain was falling. The pilot stated he flew over the airport twice looking for a wind…NTSB NYC87LA112Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Rutland, VTDrg arrival, the plt was cleared for an lda/ndb apch to rwy 19. When she 'went visual' on the apch, a check of the VASI showed she was hi, so she slipped the acft to lose alt. The winds were rprtd as light & variable, but plt rprtd that drgthe lndg, there was…NTSB MIA87LA108Accident · No injuriesLimited investigationFinal reportLet L-13 · Brooksville, FLOn final apch, with full flaps extended, the glider began to float down the rwy. The plt then retracted them, after which, it descended, collided with a fence, & came to rest in a field.NTSB ATL87LA080Accident · No injuriesLimited investigationFinal reportCessna 172M · Lexington, NCThe plt reported that he had transitioned to a visual approach, following a simulated radar approach to the rwy using vectors and descent info supplied by an instrument-rated safety plt in the rt seat. The safety plt was the plt's former instructor. The plt…NTSB NYC87LA094Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Colebrook, NHThe plt rprtd that after arriving, the wind shifted to the NE, but he elected to land on rwy 21 'because of a frost heave.' Subsequently, he landed long to avoid the frost heave, but was unable to stop on the icy rwy. The acft contd off the departure end &…NTSB NYC87LA097Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Marlboro, NJWhile lndg on rwy 27, just bfr sunset, the acft was rprtd to be high & fast on the apch. Subsequently, it contd off the end of the rwy & collided with trees. The plt rprtd he was under stress due to recent death of his parents & the necessity to move the acft…NTSB SEA87LA058Accident · No injuriesLimited investigationFinal reportCessna 188 · Genesee, IDAfter operation in light winds, plt attempted takeoff in calm wind conditions. Gravel runway was soft from overnight rains. Acft became airborne briefly in ground effect near end of runway, settled back into muddy terrain and nosed over inverted.NTSB MKC87LA052Accident · No injuriesLimited investigationFinal reportBeech B-35 · Butler, MOThe PIC flew a traffic pattern that placed him landing long to the rwy at Butler, MO. The PIC perceived an eng failure prior to attempting a go-around and activated the fuel boost pump and advanced the throttle. The PIC rptd the eng faultered and quit. The…NTSB CHI87DEX05Accident · No injuriesFinal reportCessna 340A · Bloomington, INThe plt rprtd that drg preflt, there was snow on the acft which would move with hand brushing, so he elected not to remove it. Drg departure, as he rotated the acft to lift-off, he noted the acft did not feel right. He intentionally aborted the takeoff, but…NTSB NYC87LA053Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Goffstown, NHThe Cessna 180 made a touch and go on a 2100 ft long runway. The touchdown was described as past the first third of the runway. There were two rated pilots and a passenger in the aircraft. The co-pilot thought the aircraft would be unable to clear powerlines…NTSB ATL87LA050Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · High Point, NCThe plt landed on the wet turf/gravel rwy with a slight quartering tail wind. Rprtdly, the acft touched down about 1/3 of the way down the rwy with an airspeed of 4 to 9 KTS above the recommended speed. The plt was unable to stop on the remaining rwy &…