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 DEN82DA048Accident · No injuriesFinal reportCessna T182RG · Laurel, MTThe aircraft landed long on a down slope runway and ran off the end collapsing the landing gear. The pilot stated that he should have used full flaps instead of the 20 degrees he used.NTSB CHI82DA100Accident · Minor injuriesFinal reportPiper PA-28-236 · Dodgeville, WIThe student pilot was at the controls during the landing approach. The approach was to an upsloping runway, but with a tailwind component. The aircraft was landed long. It continued off the end of the runway and collided with a ditch. The instructor reported…NTSB DEN82DA053Accident · No injuriesFinal reportCessna T210G · Moab, UTThe aircraft was found on an abandoned dirt runway near deadhorse point. Investigation indicated that the aircraft touched down long on runway 21 and collided with an elevated dirt road that crosses the runway. Two impact marks were found on the instrument…NTSB NYC82DA055Accident · No injuriesFinal reportPiper PA-34-200 · Atlantic City, NJThe pilot reported that he elected to fly his IFR approach to the runway with a 10 kt quartering tail wind. He reported encountering hydroplaning conditions after landing within the first quarter of the runway. By the time he considered a go-around, there was…NTSB LAX82DA105Accident · No injuriesFinal reportCessna 501 · Chino, CADuring arrival, the pilot landed from an ILS approach on a smooth, wet, asphalt runway in calm wind conditions. The runway length was 3850 ft. the pilot reported normal deceleration while using his speed brakes and maximum braking technique. He let off the…NTSB DEN82DA041Accident · No injuriesFinal reportBellanca 7GCBC · Thermopolis, WYDuring a landing in a hay meadow the pilot touched down long, due to a tailwind, and turned uphill to avoid hitting a fence and ditch. The aircraft ground looped breaking the right wheel strut.NTSB NYC82DA048Accident · No injuriesFinal reportPiper PA-28-151 · Pittstown, NJAfter arriving from alexandria, NJ with an instructor pilot, the student made two practice landing at the Pittstown airport without incident. However, on a subsequent solo flight, the student pilot landed long on the 2000 ft runway. He stated that he ran off…NTSB FTW82DA088Accident · No injuriesFinal reportRockwell S-2R · Hughes, ARThe pilot attempted a downwind takeoff from a soft ag strip with a heavy load. After realizing that he would be unable to lift-off, the pilot initiated an abort. The aircraft continued off of the end of the strip and flipped over in a muddy terrain.NTSB FTW82DA081Accident · Minor injuriesFinal reportCessna P210N · Deleon, TXThe pilot reported that he entered a left traffic pattern for landing on runway 15 at dusk. He was unable to see a 400 ft tv tower located in the vicinity of the base leg. Therefore, he kept his base leg closer in and higher than normal. He reported that…NTSB ATL82IA060Incident · No injuriesIncident investigationFinal reportBeech B90 · Atlanta, GAPilot was making an ILS approach to runway 20L with winds easterly at 12 with gusts to 20 KTS. A wind check at the outer marker disclosed winds 100 deg at 8 KTS, and tower authorized pilot to land on 20L or circle to runway 09 at his discretion. After a…NTSB FTW82FRG25Accident · No injuriesFinal reportPiper PA-23 · Del Rio, TXThe mexican air taxi flight diverted to Del Rio, Texas after encountering icing conditions, heavy rain, and hail. The plane was vectored and cleared for an ILS localizer approach to runway 13. During landing, the surface wind was from 350 degrees at 15…NTSB FTW82FA069Accident · No injuriesField investigationFinal reportCessna 150 · Fort Worth, TXThe student pilot touched down about midway down the runway with a right crosswind. Witnesses stated that during the landing roll the wind shifted from west to northwest with gusts to about 30 knots. The instructor realized the aircraft could not be stopped…NTSB FTW82DA068Accident · No injuriesFinal reportCessna 172 · Kingfisher, OKThe student pilot stated he read the wind direction as coming from the south and landed accordingly. The aircraft landed downwind, the nose wheel dug in and collapsed, and the aircraft nosed over.NTSB MKC82DA038Accident · No injuriesFinal reportGrumman AA-5A · Monona, IAThe pilot taxied to the south end of the runway to depart with three passengers. He began a soft field takeoff roll on a soft, wet runway with 10 degrees of flaps. The nose wheel was lifted off early. It was held off as the plane accelerated. The pilot…NTSB FTW82IA062Incident · No injuriesIncident investigationFinal reportBoeing B-727-200 · Harlingen, TXThe FAA control tower operator stated that the aircraft landed long and fast during a heavy thunderstorm. Investigation revealed that the aircraft touched down about midway down runway 17R which is 8300' long. Evidence also indicated that the aircraft…NTSB FTW82DA065Accident · No injuriesFinal reportCessna 150M · Lubbock, TXAfter electing to abort takeoff the pilot realized he had insufficient room to stop on the remaining runway. He reapplied power to attempt to fly over a road but reported that the engine lost power. The aircraft bounced over a road into a plowed field and…NTSB FTW82DA061Accident · No injuriesFinal reportCessna 172H · Mesquite, TXThe pilot stated that the aircraft touched down about 1/3 of the way down the runway and was rolling fast past the intersection so he elected to initiate a go-around. When at about 100 feet AGL the engine quit and an emergency landing was made in a plowed…NTSB NYC82DA035Accident · No injuriesFinal reportMooney M20J · Schroon Lake, NYDuring arrival, the pilot made two passes over the airport to insure that the runway had been plowed (snow removed). He landed on a 3164 ft runway in light and variable wind conditions. The runway was covered with ice and wet snow. The left brake was…NTSB ATL82DA056Accident · No injuriesFinal reportPiper PA-28-161 · Ridgeland, SCAfter touching down on the first 1/3RD of the 3100 foot runway the pilot stated that he lost his brakes. The aircraft went off the departure end of the runway down a 25 foot embankment and turned over. Examination of the wheel brake system including pushing…NTSB LAX82DA066Accident · No injuriesFinal reportCessna 310R · Carlsbad, CADuring the takeoff roll, the pilot noticed that the passenger door was not closed. He tried unsuccessfully to close the door, then elected to abort the takeoff. The pilot was unable to stop on the remaining runway. The aircraft continued off the end and went…NTSB LAX82FJA04Accident · Serious injuriesFinal reportPiper PA-28-140 · Kalaupapa, HIWitnesses stated that the aircraft touched down approximately halfway down runway 5 with the winds out of the west. The pilot stated that when nearing the end of the runway she put on full throttle to initiate a go around but it was too late. The aircraft…NTSB DCA82AA014Accident · Serious injuriesFinal reportMcdonnell-Douglas DC-10-10 · Philadelphia, PAThe aircrews of a united DC-10 (flt 99 heavy) and two U.S. Air DC-9'S (flt 25 and flt 199) taxied for takeoff at about the same time. Due to delays, the no. 2 engine of flt 199 was shut down in accordance with applicable fuel conservation procedures. After…NTSB SEA82DA023Accident · No injuriesFinal reportCessna 172P · Sinclair Island, WAThe airport was a privately owned strip approximately 1200 ft in length. About the last 25 percent of runway 33 was angled approximately 30 degrees to the right. Tth runway was considered unidirectional with landings normally made to the north/northwest and…NTSB ATL82DA045Accident · No injuriesFinal reportCessna 182L · Conyers, GAThe destination airport is a private strip that is oriented on a 150/330 degree heading. The northwest end is enclosed by tall trees. Accordingly, most landings are made toward the northwest regardless of wind direction. The pilot landed on runway 33 which…NTSB ATL82DA044Accident · No injuriesFinal reportCessna 172N · Cumberland Isla, GAThe 2500 ft runway had trees on 3 sides. The normal pattern for landing was from east to west and departures were normally from west to east. A long, shallow, tailwind approach was made from the east at about 65 knots. The pilot used 40 degrees of flaps and…NTSB LAX82DA054Accident · No injuriesFinal reportMooney M20C · Fowler, CAThe pilot estimated that he landed about 400 ft past the threshold on a runway that was muddy. He found the braking was insufficient and started a go-around. However, he quickly realized that he would not have flying speed before reaching the end of the…NTSB DCA82AA013Accident · 2 fatalFinal reportMcdonnell Douglas DC-10-30 · Boston, MADrg arr, plt ackd rcpt of ATIS info & fld cond rprt, both in dcg braking action "fair to poor." He was not adzd of 3 pltrprts of braking action "poor to nil" or "poor." Acft was clrd for vor/dme apch to rwy 15R. Due to psbl wnd shear, 35 deg of flaps (instead…NTSB LAX82DVG12Accident · Serious injuriesFinal reportCessna P210N · Napa, CADuring his approach for landing, the pilot became concerned about other aircraft taxiing near the runway. He reported that his landing procedure was interrupted as he was waiting for one of the planes to stop short of the runway. Also, he reported aborting…NTSB ATL82DLG09Accident · No injuriesFinal reportCessna 152 · Grantiteville, SCThe pilot was unable to find the airport at his intended destination. He saw another airport and elected to land. A no-flap approach was made to rwy 24 with a north wind. The aircraft touched down about 500 feet from the departure end and then became airborne…NTSB SEA82DA022Accident · No injuriesFinal reportCessna 140 · Pullman, WAThe pilot started to takeoff on a snow covered runway in calm wind conditions. He reported that about 3 inches of snow had fallen since the runway had been cleared. In his judgement, the aircraft did not accelerate fast enough to assure a safe takeoff, so he…NTSB NYC82DA015Accident · No injuriesFinal reportCessna 401B · East Hanover, NJDuring flight, the pilot diverted to East Hanover to avoid weather. While landing on a wet runway in light wind conditions, he was unable to stop before reaching the end. The plane continued off the runway and struck a dirt bank.