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 ATL89LA093Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Liberty, NCThe pilot's inadvertent landing at the wrong airport, contributing to the accident was the failure of the airport personnel to notify the FAA of the existance of the airport so it could be properly designated on aviation charts.NTSB ATL89LA092Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Waynesville, OHThe pilot delayed his landing/touchdown, misjudged the distance of the remaining runway and did not go around. The slick/thawing runway conditions and the fences were contributing factors.NTSB NYC89FA085Accident · Serious injuriesField investigationFinal reportDassault/Sud FAN JET Falcon D · Binghamton, NYImproper planning/decision by the pilot(s). Factors related to the accident were: icy runway conditions and failure of the drag chute to properly open after it was deployed.NTSB CHI89LA051Accident · No injuriesLimited investigationFinal reportCessna 182A · Baldwin, WIFailure of the pilot to go around when he landed long with too much speed for the conditions. Factors related to the accident were: the pilot's excessive airspeed, his failure to attain the proper touchdown point, the crosswind, snowy/icy runway conditions,…NTSB ATL89LA077Accident · No injuriesLimited investigationFinal reportBeech 58 · Walnut Cove, NCThe pilot made the landing approach too high and too fast for the available runway, and failed to abort the landing. The fence was a related factor.NTSB MIA89LA068Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Terra Ceia, FLThe improper in-flight planning/decision by the student pilot. Factors related to the accident were: tailwind conditions during the landing and the proximity of the ditch to the selected landing area.NTSB FTW89IA038Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas DC9-30 · Baton Rouge, LAThe proper touchdown point was not attained by the flight crew. (Copilot was flying and the PIC was supervising).NTSB LAX89LA075Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Avalon, CAThe pilot lost control of the airplane during landing roll at catalina airport. The airplane departed the end of runway 22, went down a steep slope and collided with the ground. The pilot reported that his first approach had been too high, so he made a…NTSB NYC89LA046Accident · No injuriesLimited investigationFinal reportBeech 24R · Oxford, MAFailure of the pilot to stop the aircraft on the available runway due to a long landing.NTSB SEA89LA022Accident · No injuriesLimited investigationFinal reportCessna 172 · Oregon City, ORThe pilot was landing his aircraft on a very wet 1,170 foot grass runway. The pilot was not able to stop the aircraft before it collided with a fence at the end of the runway. According to the manufacturers performance figures, under the given temperature and…NTSB SEA89LA020Accident · No injuriesLimited investigationFinal reportGates Learjet 25B · Bend, ORThe pilot visually inspected the runway while making a low pass. He reported afterward that he saw no evidence of ice or snow on the runway. The copilot called UNICOM but was told, while the aircraft was on short final, that the winds were calm and the…NTSB LAX89LA026Accident · No injuriesLimited investigationFinal reportBeech 23 · San Carlos, CADuring a telephone interview the pilot stated that he landed too FAR down runway 12. He said that when he considered going around, he was already committed to complete the landing. Winds at the time of the accident were reported to be from 360 degrees at 5…NTSB SEA89LA009Accident · Minor injuriesLimited investigationFinal reportTaylorcraft 15A · Skykomish, WAThe plt made an apch over tall trees to land on a 2050 ft strip. The acft touched down on wet turf with about 500 ft of rwy remaining. The plt was unable to stop the acft on the remaining rwy. Subsequently, it contd off the departure end & went into a large…NTSB MKC89LA003Accident · No injuriesLimited investigationFinal reportCessna 172 · West Memphis, ARThe pilot said he was unable to activate the runway lights on the designated frequencies during a night personal flight. He attempted to land without the aid of the runway lights, and touched down on the FAR end of the runway subsequently running off the end…NTSB ATL89LA009Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Lexington, NCDuring final approach to rwy 26 a crosswind shifted to a tailwind. The plt rprtd a full flap/carb heat touchdown was made despite 14 knots airspeed. Insufficient rwy remained and full throttle was applied for go-around. Flaps and carb heat were not…NTSB SEA88LA192Accident · No injuriesLimited investigationFinal reportCessna 207 · Center Island, WAThe plt was landing upslope on a one-way 1700 ft rwy in wind that was variable & changing from calm to gusts from the north. The plt rprtd a northerly gust cond occurred as he was landing. Subsequently, the acft floated beyond the desired touchdown point &…NTSB NYC88LA245Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Carlton Center, NYPlt stated he was landing to the west and touched down about half way down a 2,000 ft grass strip. The plt also said the grass was wet and the wheel braking was ineffective. The plt elected to keep the airplane on the ground due to obstacles at the end of the…NTSB BFO88LA086Accident · No injuriesLimited investigationFinal reportCessna 172M · Keysville, VAAircraft overran the runway after the pilot aborted the takeoff because the aircraft did not accelerate to takeoff speed. A contributing cause is inadequate prelight planning. A contributing factor is upsloping high grass covered terrain and failure to use…NTSB CHI88LA246Accident · No injuriesLimited investigationFinal reportCessna 150G · Butler, INDuring a solo flight, the student pilot attempted a landing on a neighbor's cow pasture. The student stated that he misjudged the approach to landing and landed long on the field. He was unable to adequately handle the aircraft and failed to get it stopped…NTSB ANC88LA146Accident · No injuriesLimited investigationFinal reportCessna 207A · New Koliganek, AKThe pilot reported that he landed long on a rough 900' gravel strip. He was unable to stop the airplane before it went off the end of the runway and into the adjoining tundra.NTSB DEN88LA208Accident · No injuriesLimited investigationFinal reportCessna 421B · Winner, SDThe private plt and 4 pax were attempting takeoff on rwy 13, a 3,900 x 30 ft asphalt rwy. The plt said the acft accelerated to 100 knots but he could not raise the nose for lift off. The plt said he aborted the takeoff and intentionally ground looped to the…NTSB FTW88DPA08Accident · No injuriesFinal reportNorth American TB-25N · Wichita Falls, TXDuring a period of light rain at dusk, the B-25 plt landed on a 4250 ft rwy. While landing, the acft touched down long & fast. Subsequently, it went off the departure end of the rwy & was damaged.NTSB ATL88LA247Accident · No injuriesLimited investigationFinal reportPiper PA-60-602P · Hopkinsville, KYThe airplane overran rwy 26 during ldg, following an sdf appch. The plt reported that he broke out of the wx about 1 mile from the rwy, with 2 to 3 miles visibility. He subsequently landed 'long' on the wet rwy with a tailwind, and found that braking was not…NTSB NYC88DNA02Accident · Serious injuriesFinal reportDillinger Long E-Z · Lawrence, MAThe plt depd provincetown on a rtrn flt to his home arpt at aprx 0230 EDT & arrived at his destn about 1 hr later. He rprtd he was unable to activate the plt-ctld rwy lights. He checked the lighted wind sock & decided the night was bright & clear enough to…NTSB ANC88LA137Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Ruth Lake, AKThe air taxi pilot was attempting to land his float-equipped airplane on a remote mountain lake in gusty wind conditions. He stated that he touched down with a tailwind component of approximately 5 knots, but that the tailwind increased rapidly during a gust,…NTSB ANC88LA139Accident · No injuriesLimited investigationFinal reportCessna 180B · Fairbanks, AKThe plt rprtd that drg an aborted takeoff, the acft overran the departure end of the rwy & the left main gear failed. He said he misjudged the performance of the acft, & when he aborted, there was insufficient rwy remaining to stop. Also, he believed the hi…NTSB ANC88LA136Accident · No injuriesLimited investigationFinal reportCessna 207 · Bethel, AKThe pilot was an aircraft mechanic for the operator of the airplane, and was enroute to another airport to repair a company airplane. The pilot stated that he did not do a complete job of preflighting the airplane, and attempted to takeoff with the control…NTSB SEA88LA170Accident · No injuriesLimited investigationFinal reportGrumman AA-5 · Toledo, WAThe pilot aborted the first takeoff due to the engine not developing full power. After another run up, the pilot elected to make another takeoff. The pilot aborted midfield, by retarding the power and applying heavy braking, due to the aircraft not developing…NTSB MIA88LA271Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Lake Wales, FLThe plt stated he approached the 2,450 ft grass airstrip from the NE & circled north of it to observe the windsock. The wind appeared to be from the east. The pilot entered the pattern to land on rwy 36. While flaring to land the acft floated down the rwy &…NTSB CHI88LA227Accident · No injuriesLimited investigationFinal reportCessna 172G · Sparta, MIDuring a takeoff attempt from his private strip the pilot elected to abort the takeoff. There was a slight quartering tailwind for the takeoff attempt. Due to the 'dense', damp grass, which was about 4 inches tall according to the pilot, braking effectiveness…NTSB CHI88LA224Accident · Serious injuriesLimited investigationFinal reportCessna 182RG · Dodgeville, WIWhile attempting to land on a runway with wind gusts and a quartering tailwind, the pilot failed to adequately judge and compensate for the wind conditions. The aircraft landed long, and the pilot was unable to bring the aircraft to a stop before the end of…NTSB BFO88LA079Accident · No injuriesLimited investigationFinal reportCessna 180 · Harding, WVThe pilot departed morgantown, WV, en route to a private airstrip, durrett air ranch, near Harding, WV to attend a Cessna 180 fly-in. He stated he circled the airstrip to determine the wind and rwy conditions. He also called UNICOM for active rwy info but did…NTSB NYC88LA223Accident · No injuriesLimited investigationFinal reportCessna 172P · Freeport, PAThe plt said that he had landed on the 2268 ft long, sod strip on several previous occasions. He said there was a right crosswind at about 6 KTS. The acft was too high and go-arounds were made following the first two approaches. On the third approach, the…NTSB CHI88LA216Accident · No injuriesLimited investigationFinal reportCessna 172M · Kelley'S Island, OHShortly after crossing the runway threshold on final approach, the pilot experienced a wind shift and elected to attempt a go-around. The pilot discontinued the attempted go-around when he judged that he would be unable to clear trees located at the departure…NTSB ATL88DKG16Accident · No injuriesFinal reportCessna 188 · Hazel Green, ALThe plt rprtd he had flown off the strip all day & the temp had risen to 101 deg. As he was on his last takeoff, he realized the chemical load was too great for the conditions. He said he dumped part of the load, but the acft settled back to the ground.…NTSB LAX88LA284Accident · No injuriesLimited investigationFinal reportCessna 150M · Gila Bend, AZAt the end of a cross country flight, the pilot overflew the runway looking for the wind sock. Unable to locate the sock, the pilot made an approach for landing. The pilot did not realize until too late that he was landing the airplane with a 10 knot…NTSB FTW88DPJ09Accident · No injuriesFinal reportCessna 152 · Skiatook, OKThe student pilot landed her aircraft on the last half of the runway. She added power and retracted the flaps when she decided to abort the landing and go around. She subsequently decided to abort the go around and pulled off the power. There was insufficient…NTSB MIA88IA240Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-88 · Pensacola, FLThe captain stated that he crossed the final approach fix at 3000 feet, continued the approach, touched down at 140 knots at the end of the touchdown zone, but could not stop the acft and ran off the end of runway 16. According to tower personnel and…NTSB FTW88LA135Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · La Grange, TXThe pilot said he flew over the airport and found the winds favored a landing on runway 18. He said he descended to the downwind leg, and when he added power, the engine would not respond. However, he said the engine continued to run. He decided to make an…NTSB LAX88LA261Accident · No injuriesLimited investigationFinal reportCessna 185E · Lone Pine, CAThe plt rpted that the engine cylinder temperature was very high as he crossed mountainous terrain. He elected to make a downwind precautionary landing to a short airstrip with a high density altitude. The acft touched down beyond the normal touchdown zone,…NTSB DEN88LA150Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Erie, CONTSB MKC88LA130Accident · No injuriesLimited investigationFinal reportBeech A-36 · Marion, IAWhile attempting to land after one go-around. Witnesses said the acft touched down beyond the half way point on the 2300 foot sod runway. He appeared to be high and fast according to witnesses. The pilot said he might have mistaken the threshold and landed…NTSB CHI88LA148Accident · Minor injuriesLimited investigationFinal reportCessna 182M · Menomonee Falls, WINTSB NYC88LA173Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Akron, NYThe pilot's inadequate preflight resulted in a delayed aborted take-off. After an inadvertent retraction of the landing gear the aircraft skidded off the end of the runway into rough terrain.NTSB MKC88LA118Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Olathe, KSAfter a long cross country flight, the pilot said he encountered heavy rain and thunderstorms near his destination. He reported that he was able to continue the flight under VFR, but when landing on the wet runway braking was ineffective. The airplane…NTSB ANC88LA082Accident · No injuriesLimited investigationFinal reportCessna 172 · Healy, AKThe commercial pilot/flight instructor was attempting to land at a private turf airstrip when she reportedly encountered the outflow from a thunderstorm located about one mile away. She elected to continue with the landing and touched down with a greater than…NTSB ANC88LA078Accident · No injuriesLimited investigationFinal reportCessna 185F · Barter Island, AKThe 5100 hour commercial pilot had landed at a remote lake on an air taxi flight to pick up three passengers. On the ensuing takeoff attempt, he elected to abort the takeoff due to what he felt was an insufficent amount of lake remaining for a successful…NTSB MIA88LA205Accident · No injuriesLimited investigationFinal reportCessna 182R · Tampa, FLThe plt rprtd that drg the takeoff roll, he 'rotated aircraft at 65 kts' but it would not become airborne. He then aborted the takeoff, but was unable to stop on the remaining rwy. After departing the rwy, the acft hit a ditch & nosed over. An exam of the flt…NTSB ATL88LA196Accident · Minor injuriesLimited investigationFinal reportCessna 175C · Boston, GAThe pilot was attempting to land following a reduction in power when he overshot the runway. The pilot said the engine did not quit and was still producing thrust. The aircraft was destroyed by fire after it came to rest. The plt landed downhill and downwind.NTSB CHI88LA135Accident · No injuriesLimited investigationFinal reportCessna 152 · Urbana, ILWhile landing at the completion of his first solo cross country instructional flight, the student pilot landed long and was unable to stop before the end of the runway. The student pilot stated that he selected the sod runway instead of the 2,550' x 29'…