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 ATL84LA229Accident · No injuriesLimited investigationFinal reportCessna A188B · Crenshaw, MSThe pilot acknowledged that he attempted to take off on an aerial application flt with the acft loaded above its maximumcertificated gross weight. He stated that he had previously flown with chemical loads & had not encountered problems taking off. Prior to…NTSB FTW84LA311Accident · No injuriesLimited investigationFinal reportCessna 175A · Daisetta, TXThe student plt on a solo flt ran off the end of the rwy during landing. FAA said the plt had not received dual instruction recently enough to be legally qualified for this flt. A report of the accident was not filed by the student.NTSB LAX84LA391Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Vacaville, CAThe plt stated that he was high on final approach so he lowered the nose of the acft to lose altitude and in return got an increase in airspeed. He touched down 1/3 the way down the runway and the acft ballooned. He stated that he was unable to stop the acft…NTSB NYC84LA288Accident · No injuriesLimited investigationFinal reportCessna 172PII · Madison, CTPlt stated groundspeed was fast during the flare and an abrupt touchdown was made 'fairly far' down the rwy. Plt reported, 'braking had not sufficiently slowed or stopped the plane as the plane neared the end of the runway, and it veered off to the right of…NTSB LAX84FA389Accident · 4 fatalField investigationFinal reportCessna 180 · Randsburg, CAPlt attempted to land on a 1200 ft long airstrip. He landed the acft with a tailwind and touched down aprx 600 ft from the apch end of the rwy. The acft skidded off the right side of the rwy and collided with a caterpillar tractor. The four occupants were…NTSB MKC84LA208Accident · No injuriesLimited investigationFinal reportCessna 337G · Hickory Ridge, ARThe plt was on a business trip to Hickory Ridge, AR. He stated that he landed at wynne, AR, but could not rent an auto to proceed to Hickory Ridge. The FBO stated that there was a 3200 ft crop dusting strip at Hickory Ridge, so the plt elected to fly there.…NTSB DEN84LA261Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Los Alamos, NMThe attempted downwind takeoff was aborted but resulted in an overrun off the end of the rwy. According to the PIC the airspeed indicator was inoperative and the brakes were well worn prior to departure. With about 1000 ft of rwy remaining the abort was…NTSB ATL84FKG11Accident · No injuriesFinal reportCessna 421C · Kennesaw, GAThe plt reported that during the takeoff roll, at about 80 KTS, the right baggage door came open. He aborted the takeoff & the acft ran off the end of the rwy.NTSB SEA84LA188Accident · No injuriesLimited investigationFinal reportCessna 182 · Craigmont, IDAccording to the plt, during landing the brakes failed and the acft came to a stop about 10 ft beyond the end of the rwy after rolling into a shallow ditch. Maint personnel examined the right wheel brake system and found no mechanical malfunction or leakage…NTSB CHI84LA277Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Lansing, ILThe acft ran off the end of the rwy into a ditch during landing. The plt said that his landing speed was 'well above normal touchdown speed.' He had made one approach before the accident and went around because he was 'landing long.' There were no reported…NTSB MKC84LA204Accident · No injuriesLimited investigationFinal reportCessna 172M · Colt, ARThe pilot stated that he made his final approach to the rwy at 70 mph and the aircraft floated when he flared for touchdown. He continued to state that after acft touched down, insufficient runway remained to stop before overrunning the runway and impacted a…NTSB SEA84LA163Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Haines, AKThe acft overran the rwy and nosed over in the tall grass. The plt said he deliberately landed long to avoid a long taxi. There also was a light tail wind. The plt recommended using all available rwy and taking time to obtain wind info.NTSB SEA84LA155Accident · No injuriesLimited investigationFinal reportBeech M35 · Lacenter, WAThe plt was on a flt to the Lacenter arpt which had a 1700 ft rwy. During arrival, he mistook a nearby, uncharted, private strip for the Lacenter arpt. After landing on the 1300 ft private strip, the plt realized he would be unable to stop on the rwy. He…NTSB MKC84LA191Accident · No injuriesLimited investigationFinal reportCessna 182N · Beaver City, NEThe acft was landed on an uncontrolled arpt toward the nnw, & after touchdown, it did not slow down adequetely. According to the plt, he elected to ground loop the acft rather than to continue off the end of the rwy. During the attempted ground loop, the acft…NTSB MIA84LA193Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Cedar Key, FLThe plt stated he touched down about 1/3 down the 2,400 ft rwy, was unable to stop the acft & ran off the end.NTSB DEN84LA198Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Albuquerque, NMWhile en route, the acft's ELT suddenly activated. The plt made an unplanned landing at laguna, NM to correct the ELT problem, then he continued on to coronado arpt at Albuquerque, NM. He said this incident made him tense. After receiving radar vectors to the…NTSB CHI84LA267Accident · No injuriesLimited investigationFinal reportCessna 152 · Park Falls, WIThe plt reported that during his preflt run-up, everything seemed normal. Using short field takeoff procedures, he rotated at 40 KTS & reached an alt of about 10 ft AGL. However, he stated that the acft did not want to accelerate to the best angle of climb…NTSB FTW84LA289Accident · No injuriesLimited investigationFinal reportCessna A188B · Speaks, TXDuring takeoff to the south the northerly wind picked up. Acceleration was not sufficient enough to become airborne before end of airstrip. Acft overran airstrip and collided with a ditch. Density alt was 2,500 ft MSL and acft loaded with 1,200 lbs of…NTSB FTW84LA292Accident · No injuriesLimited investigationFinal reportCessna 152 · Giddings, TXThe student plt on his first solo cross-country flight became lost. The plt landed to refuel but the facility was closed. He departed to refuel elsewhere and ran one fuel tank dry enroute. Upon reaching the second arpt, the plt performed a landing on rwy 35…NTSB SEA84LA154Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Haines, AKThe acft had landed on a short airstrip with a 10 kt headwind. When a takeoff was attempted the wind had stopped, according to the plt, and the acft would not become airborne. The acft went off the departure end of the rwy into underbrush and a gulley. The…NTSB MIA84LA191Accident · No injuriesLimited investigationFinal reportCessna 172N · Miami, FLThe plt said he had 'cross channeled' his radios & was having communication problems. He decided to land at the opa-locka west arpt. The acft was landed downwind & after overrunning the end of the rwy, it collided with terrain & was damaged.NTSB LAX84LA362Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Sacramento, CAThe plt stated he landed a little long on the 2800 foot dirt road and was unable to stop. The acft traveled off the end of the road and collided with a river bank.NTSB ATL84LA206Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Summerville, SCThe acft touched down 1500 ft past the approach end of the 4000 ft wet sod rwy. 10 degrees of flaps were used. Brakes were applied but at 3000 ft down the rwy the plt realized he would be unable to stop the acft before it collided with a deep ditch at the end…NTSB NYC84LA216Accident · No injuriesLimited investigationFinal reportCessna C150 · Marlboro, NJDuring takeoff the plt said that the power was slow to build and when he tried to rotate at 55 KTS he noticed the RPM AT2300 so he aborted the takeoff. The acft went past the departure end of the rwy into a ditch before stopping.NTSB FTW84LA278Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Spiro, OKThe plt stated that while landing in an alfalfa field, he made the approach at a higher than normal speed. Subsequently, the acft overran the alfalfa field & went into a plowed field where it nosed over.NTSB CHI84LA247Accident · No injuriesLimited investigationFinal reportCessna 152 · Little Falls, MNPreviously, the acft had been landed in a 1000 ft fld when the eng quit during a simulated emergency while on a dual instructional flt. The instructor plt decided to leave the student there & fly the acft back to the arpt. He walked down the field & made an…NTSB DEN84FA184Accident · Serious injuriesField investigationFinal reportCessna 182L · Rosebud, NMThe acft ran off the gravel road used for a rwy during landing and collided with a ditch. A relative of the plt who was a witness said the acft floated 'a long time' and seemed to be flying 'too fast.' The plt also said it took longer to land than he expected…NTSB NYC84LA215Accident · No injuriesLimited investigationFinal reportCessna C172 · Patton, PAThe plt landed fast and long and before running off the end of the 1750 ft rwy he turned right toward the ramp. A gust of wind caught the acft and the acft collided with a ditch beside the ramp.NTSB LAX84LA344Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Kernville, CAPlt attempted to takeoff with acft near max gross weight. The density alt was calculated to be 5000 ft. according to the performance charts, the acft would have used aprx 5000 ft for takeoff. The departure runway was 3500 feet long. The plt attempted takeoff…NTSB ATL84LA194Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Augusta, GAThe student pilot stated that the acft touched down at about midfield at aprx 90 mph. He was unable to stop the acft & it struck a chain link fence near the end of the rwy. The student had only 2 hrs of total flt time in this make & model of acft.NTSB CHI84LA218Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Lansing, ILThe 2432 ft rwy had a 224 ft displaced threshold due to trees near the apch end. The plt stated that when he landed, the acft touched down 'somewhat down the rwy past the treshold' with 25 deg of flaps. He stated that braking had little effect because the…NTSB FTW84LA251Accident · No injuriesLimited investigationFinal reportCessna 182Q · Whitney, TXAccording to the plt, he was unable to stop the acft after landing on a 2000 ft asphalt rwy. The acft overran the end of the rwy & hit a ditch. The nose gear collapsed & the acft nosed over. The wind was reported blowing from 210 deg at 20 gusting 25 KTS.…NTSB ATL84FA185Accident · Serious injuriesField investigationFinal reportCessna 402C · Hickory, NCDuring the ILS apch to rwy 24 (6400 ft long), visual contact with the rwy was established at aprx 500 ft AGL and the acft was indicating 'one dot' high on the glide slope. Witnesses stated the acft touched down past the halfway point on the rwy with full…NTSB SEA84LA116Accident · No injuriesLimited investigationFinal reportCessna 172 · Stewart Island, WAThe plt landed to the west on a wet grass strip with 1/4 inch of standing water. He said he had no traction & the acft slid off the end between 2 trees, damaging both wings. He also said the wind was 090 deg at 5 KTS gusting 15 KTS.NTSB NYC84LA183Accident · No injuriesLimited investigationFinal reportBeech A23 · Matawan, NJLanding long at night to avoid unseen obstructions, the pilot misjudged his touchdown point and ran off the end of the rwy, colliding with brushy vegitation.NTSB MIA84LA168Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Opa Locka, FLThe plt was practicing touch-&-go landings. After touching down on the 2nd landing, he saw a patrol vehicle crossing the rwy. The plt deviated to the left to avoid the vehicle, then he elected to go around. However, he then realized that there was…NTSB FTW84LA239Accident · No injuriesLimited investigationFinal reportCessna 172 · San Antonio, TXThe acft ran off the departure end of the rwy during landing, went through a fence on into a street. Tower personnel said the acft landed faster then normal about 1/2 way down the rwy and bounced several times before going through the fence. The plt said he…NTSB FTW84LA230Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Many, LAThe acft was damaged when it failed to climb during takeoff and went past the departure end of the rwy for 1400 ft before stopping. There was a witness who observed six persons on board the 4 place acft. The plt stated that his son in the rt front seat…NTSB NYC84FNC02Accident · Serious injuriesFinal reportPiper PA-31S 2 · Rockland, MEFollowing the rwy 03 LOC apch plt decided to land straight in with a tailwind rather than circling because of low clouds surrounding the arpt. Acft touched down with aprx 2000 ft of wet rwy remaining. Acft traveled off end of rwy until it contacted an…NTSB SEA84LA112Accident · No injuriesLimited investigationFinal reportCessna 188B · Shedd, ORWhile landing on a 1600 ft ag strip, the plt realized he had too much speed. However, there were power lines at the departure end of the strip, so he elected not to attempt a go-around. He intentionally ground looped the acft to avoid a ditch & road at the…NTSB CHI84LA183Accident · No injuriesLimited investigationFinal reportCessna 182N · Minonk, ILThe acft ran off the departure end of the rwy during an aborted takeoff. After the nose gear collapsed the acft nosed over. Investigation revealed that the plt lowered 10 deg of flaps instead of the recommended 20 deg for a soft field takeoff. He used about…NTSB LAX84LA310Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Death Valley, CAAccording to the plt, the approach to rwy 33 was in a 'no-wind condition until about 30-40 ft AGL when a strong tail wind came up.' He stated that it appeared that there was sufficient rwy remaining and when he realized it was too late to stop or go around he…NTSB LAX84LA272Accident · Serious injuriesLimited investigationFinal reportDouglas DC-6A · San Manuel, AZThe acft skidded off the departure end of the rwy collapsing the landing gear in a ditch as it caught on fire. This acftwas on a ferry flt and had several mechanical problems. Among these was the prop reversers which failed on landing. The anti-ice/de-ice…NTSB FTW84LA215Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Shiro, TXThe acft collided with a fence, ditch & trees during a touch-&-go landing on a short grass strip with obstructions at both ends. This was the students 4th solo attempt and according to the owner of the aviation training center touch-&-go landings are not…NTSB ATL84LA146Accident · No injuriesLimited investigationFinal reportBeech C-24R · Bedford, VAThe straight-in approach was high over the trees on the approach end of the rwy. The plt waited until he was 1/2 way down the 3000 ft rwy to reduce eng power to idle. The acft floated before dropping to the rwy & bouncing back into the air. Power was applied…NTSB NYC84LA140Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Mayville, NYOn an apch to land, after a go-around, the acft crossed over wires & touched down on the 1st half of the rwy. The plt applied brakes on the wet grass rwy, but noted a lack of braking action. He applied power to go around, but decided the acft would not clear…NTSB FTW84LA197Accident · Serious injuriesLimited investigationFinal reportBeech 95-B55 · Granbury, TXDuring a x-country flt, the plt landed at stephenville, TX, for fuel, but was unable to purchase any. Therefore, he proceeded to Granbury, TX, for fuel before continuing to chattanooga, TN. A witness heard the acft, then observed it porpoising down the last…NTSB CHI84LA154Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Kenosha, WIThe plt stated he mistook the ATIS reported winds of 020 deg at 21 KTS as 210 deg at 20 KTS. After executing the VOR rwy 14 apch, he continued to land on rwy 14. There was standing water on the rwy. While landing with a tail wind, the acft hydroplaned & ran…NTSB MIA84LA138Accident · No injuriesLimited investigationFinal reportCessna 152 · Clewiston, FLThe instructor plt (CFI) stated that due to bad wx to the north, they elected to takeoff toward the south on rwy 14. He stated the wind was from 230 deg. The student started the takeoff with a slight x-wind. Shortly after lift-off, the CFI took the controls &…NTSB SEA84LA086Accident · No injuriesLimited investigationFinal reportCessna 182Q · Neah Bay, WAThe plt landed long on the 1200 ft rwy and after overruning the end the acft collided with a ditch. The Washington state pilot's guide denotes the airport as 'closed-for emergency use only', and 'watch for livestock'. According to witnesses there were horses…