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 LAX83LA418Accident · No injuriesLimited investigationFinal reportCessna 172P · Glendale, AZThe student & his instructor plt had made 2 takeoffs & landings, then the instructor deplaned & the student prepared to takeoff on a solo flt. According to the student, he made the pretakeoff checks, which included setting the trim. As the acft accelerated…NTSB CHI83LA396Accident · No injuriesLimited investigationFinal reportCessna 172 · Princeton, ILThe turf rwy was wet from recent rains. The plt stated that during takeoff, the acft had accelerated to near the rotation speed when it was slowed by a soft spot in the rwy near mid field. At the same point, an upslope portion of the rwy was encountered & the…NTSB FTW83LA397Accident · No injuriesLimited investigationFinal reportCessna 172P · Fort Worth, TXThe acft ran off the end of the rwy during landing and collided with a fence. It was reported that the solo student plt was high and fast during his approach to the 2500 ft strip for landing. The touchdown was long and led to the overrun. The wind was calm.…NTSB LAX83LA410Accident · Serious injuriesLimited investigationFinal reportMooney M20A · Gila Bend, AZThe acft overran the rwy and collided with ditch during landing. The plt reported that the acft floated after the flare for landing and even though heavy braking was used after landing the acft did not stop on the rwy. The wind was calm but the plt said he…NTSB FTW83LA408Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Winslow, ARThe plt stated that his anxiety during the approach delayed his decision to abort a long landing. After touchdown he attempted to turn at the end of the rwy but, the acft collided wth a stump and damaged the rt wing. The plts anxiety was based on another…NTSB ATL83LA336Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Ridgeland, SCThe acft overran the rwy and collided with a ditch during landing. The weather was VMC with the winds light and variablethe pilot said he found himself high as he crossed the rwy threshold. The acft reportedly floated before touchdown. The pilot used maximum…NTSB CHI83LA386Accident · No injuriesLimited investigationFinal reportCessna 182 · Joliet, ILAcft landed long & ran off the end of the rwy. The left tire blew prior to departing the rwy, & after departing the rwy the acft collided with an arpt warning sign. A 3,452 ft turf rwy, 4/22, was available.NTSB NYC83LA213Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Rangeley, METhe pilot stated that a downdraft was encountered on the approach and in adding power to counteract, the airspeed increased over the threshold as the downdraft subsided. The acft floated 1/3 down the 2700 ft rwy and the remaining 1800FT was insufficient to…NTSB FTW83LA376Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Iowa Park, TXDuring a landing, the acft floated about 1/3 to 1/2 of the way down the rwy before touching down. The plt was unable to stop on the remaining rwy & the acft continued off the end & hit a ditch. An exam of the brakes revealed two discrepancies. The temp was…NTSB NYC83LA212Accident · No injuriesLimited investigationFinal reportCessna 172P · Westville, NYDuring arrival, the plt landed in light rain on a wet sod rwy with light & variable wind conditions. He reported that he touched down on the 1st third of the rwy, but witnesses said that the acft landed past the midfield point. Subsequently, the plt was…NTSB NYC83LA205Accident · No injuriesLimited investigationFinal reportCessna 172 · Atlantic City, NJThe acft landed long and fast, ran off the end of the rwy & collided with a fence.NTSB CHI83LA368Accident · No injuriesLimited investigationFinal reportBeech A36 · Marine City, MIThe acft ran off the end of the rwy during landing. The pilot had called UNICOM for wind information but had received noanswer. The pilot decided by smoke drift to land to the north. The winds at the arpt were from th south. The pilot landed about half way…NTSB MKC83LA180Accident · No injuriesLimited investigationFinal reportCessna 182Q · Hunter, KSThe plt reported that during arrival at the private strip, his apch was a bit hi & slightly fast. While landing, the acft floated in ground effect. Subsequently, it overran the rwy & impacted a wire fence & dirt bank.NTSB CHI83LA367Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Franksville, WIThe acft was intentionally groundlooped as the acft was not stopping at the runways end. The pilot said the brakes malfunctioned. The mechanic who worked on the acft after the accident said brakes were available even though brake fluidwas low. The mechanic…NTSB CHI83LA364Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Lansing, ILThe acft had just been given an annual inspection & the plt was on the 1st flt back to the home arpt. He reported that before takeoff, he noted that the eng would not idle below 850 RPM. He elected to continue with the flt. During the takeoff roll, he pulled…NTSB ATL83LA316Accident · No injuriesLimited investigationFinal reportCessna 195A · Elberta, ALThe acft ran off the departure end of the rwy into a ditch during landing. The landing was on a private airstrip with a wet grass rwy that sloped downhill in the direction of landing for the last 1/3 of the rwy. The acft landed about a quarter of the way down…NTSB CHI83FA359Accident · 2 fatalField investigationFinal reportPiper PA-28-180D · Bay City, MIAfter an overshoot landing attempt the pilot initiated a go-around the acft overan the end of the runway, traveled for about 330 ft and colided with a auto mobile. The roof ofthe auto was sheared off causing 2 fatal and 4 serious injuries.NTSB MKC83LA178Accident · No injuriesLimited investigationFinal reportCessna 172 N · Ames, IAThe plt reported that during the landing, he came in too fast & over ran the rwy, then the acft ran into a ditch & turned over. Reportedly, he landed on the last 20% of the rwy.NTSB CHI83LA356Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Ligonier, INThe plt report that when he landed on a wet, grass rwy, the acft slid off the wet sod & hit a ditch while on the landing roll. No mechanical malfunctions were reported.NTSB NYC83LA199Accident · No injuriesLimited investigationFinal reportCessna 172 · Easton, NYThe plt reported that during landing the brakes locked & the acft then hit two bumps in the rwy & ballooned. The acft then skidded off the end of the rwy, collided with a plowed furrow & flipped inverted.NTSB CHI83LA352Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Pittsfield, ILThe student plt was on a personal flt with a passenger on board. During arrival, he landed on rwy 25 (1700 ft long) with a x-wind from 160 deg at 8 KTS. He reported that the landing was made on his 2nd attempt, but he did not get on the ground soon enough to…NTSB FTW83LA355Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Cashion, OKThe plt was told that the sod strip was 1800 ft long. His calculated takeoff distance to clear a 50 ft obstacle was 1720 ft. however, the actual length of the sod strip ws 1300 ft. during the takeoff roll, the plt realized he would not be able to clear the 30…NTSB NYC83LA197Accident · No injuriesLimited investigationFinal reportBerkshire Concept 70 · Fairfield, PADuring the apch, the plt encountered unfavorable wind conditions & the glider touched down long. In order to avoid an embankment beyond the end of the strip, the plt turned toward a parallel rwy overrun area. Subsequently, the left wing hit two 55 gal drums…NTSB CHI83LA330Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Demotte, INThe plt stated he overflew the unfamiliar arpt & landed to the south (downwind) because of power lines on the approach to the north. He was high on final due to a tree in the approach path. The acft floated during the flare. He then raisedthe nose & the right…NTSB CHI83IA327Incident · No injuriesIncident investigationFinal reportDouglas DC-8-71 · Chicago, ILOn landing roll the acft rolled forward off the departure end of the landing runway. The crew stated that maximum braking, revers, & spoilers were utilized. The runway was covered wth standing water.NTSB NYC83LA185Accident · No injuriesLimited investigationFinal reportLake LA 4-200 · Jaffrey, NHThe acft collided with brush, trees and rocks off the end of the rwy during an aborted takeoff. According to the pilot rotation was initiated once flying speed was attained but the acft failed to respond properly. The pilot elected to abort the takeoff and…NTSB CHI83LA328Accident · No injuriesLimited investigationFinal reportCessna 182Q · Turner, MIThe plt reported that during a landing, the acft touched down at about the midpoint of a 2140 ft, grass rwy. When he applied braking action, the acft skidded on the grass surface & the plt was unable to stop on the landing area. After departing the rwy, the…NTSB NYC83LA180Accident · No injuriesLimited investigationFinal reportCessna 172 · Haverhill, MAThe acft overran the departure end of the 2100 ft rwy 32 during landing. The wind was from 320 degrees at 10 KTS. The pilot stated he made one go-around because he was high. He reported that the 2nd approach was flown at 65 mph with the touchdown accomplished…NTSB DCA83AA032Accident · Minor injuriesFinal reportGrumman G-159 · Blountville, TNThe coplt stated that when he began the apch to the destination arpt, the weather condition was hazy & he delayed his descent slightly until he located the arpt. When he saw the rwy, he believed that they were a little too close, so he indicated to the…NTSB ATL83LA278Accident · No injuriesLimited investigationFinal reportCessna 182Q · Orange City, VAThe pilot reported that winds were crossing the runway at about 15 knots during the approach. The acft touched down long and he was unable to stop the acft before running off the end of the runway. The acft collided with a tree.NTSB NYC83LA178Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Canandaigua, NYThe plt initiated a takeoff on a 1900 ft grass rwy with 2 notches of flaps. He stated that after lift-off, he had climbed 50 to 75, but was unsure whether or not he could clear the tops of the trees at the end of the rwy. He elected to abort, but was unable…NTSB NYC83LA176Accident · No injuriesLimited investigationFinal reportGrumman American AA-5 · West Kingston, RIThe acft overran the rwy hit VASI lights and rolled down an embankment during landing. The pilot was under some pressureto get on the ground because of a hyperventilating passenger. The pilot reported he increased his rate of descent by lowering the acft…NTSB CHI83LA309Accident · No injuriesLimited investigationFinal reportCessna 172M · Holland, MIThe acft ran off the end of the runway and collided with trees during landing. This runway is 3075 feet long. The wind was calm and the pilot failed to use flaps. The pilot was making a simulated engine failure-power off-landing. He said when it became…NTSB FTW83LA330Accident · Serious injuriesLimited investigationFinal reportWSK PZL Mielec PZL-M-18 · Delaplaine, ARThe acft nosed over after running off the end of the rwy during takeoff. The plt had a heavy load of fertilizer and a passenger in the single seat acft. The temperature was 94 degrees and the rwy was only 1500 ft long rather than 2300 ft as reported by the…NTSB DEN83LA161Accident · No injuriesLimited investigationFinal reportBeech C-23 · Colorado Spring, COAccording to the plt the acft was cleared for a touch & go landing to rwy 17 and when directly across from the threshold of rwy 17 on the downwind leg was re-cleared for touch & go's to rwy 12. The approach to rwy 12 was steep, touchdown occurred mid-point of…NTSB ATL83LA258Accident · No injuriesLimited investigationFinal reportCessna 182L · Charlotte, NCThe acft ran off the departure end of the rwy during landing. The wind was light and variable to calm. The plt used aerodynamic braking until it was too late to go around. When he applied the brakes he found that they were spongy and ineffectual. An after…NTSB FTW83LA308Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Ruidoso, NMThe acft overran the rwy and collided with a ditch during landing. The acft had touched down about 500 yards down the rwy according to the plt. The airspeed was also high at 100 KTS IAS. Braking did not stop the acft on the 5500 ft rwy and the acft continued…NTSB ANC83LA115Accident · No injuriesLimited investigationFinal reportCessna 172P · Mckinley Park, AKThe plt stated that he was unable to locate the windsock. While on final for rwy 16 'things' did not feel right, but he continued into a long, fast tailwind landing. As he neared the end of the rwy he deliberately groundlooped the acft to avoid going over a…NTSB NYC83LA164Accident · No injuriesLimited investigationFinal reportAero Commander 500 · Towanda, PADuring arrival on a dual instructional flt, the UNICOM advised that there was an ultralight overhead & was possibly landing. As the student was landing, an additional UNICOM advisory was received concerning the ultralight acft. The instructor plt (CFI) stated…NTSB MKC83LA145Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Point Lookout, MODuring arrival, the plt contacted the arpt UNICOM & was advised that the wind was variable 190 to 210 deg at 10, gusting 15 KTS. The 1st apch was made at 95 mph with full flaps. The plt said wind shear, near the end of the rwy, was encounter, so a go-around…NTSB ANC83IA111Incident · No injuriesIncident investigationFinal reportDouglas DC-7C · King Salmon, AKAcft overran the end of the rwy when takeoff was aborted after failure to rotate. No mechanical difficulties were noted. The rwy was dry and adequate. The CG was at or near the forward limit.NTSB MKC83LA143Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Cedarcreek, MODuring arrival, the plt flew over the strip, then circled to land. As he was flaring to land, he saw 2 deer on the rwy. He initiated a go-around, but decided he was too slow & that there was not enough rwy left. He reduced the power & touched down, but was…NTSB LAX83LA326Accident · No injuriesLimited investigationFinal reportCessna 182Q · Buckeye, AZThe pilot stated that two attempts to land at turkey airstrip resulted in difficulty in achieving a proper final approach path. After some maneuvering on the 2nd approach the acft landed. One witness described the landing as hot with some floating and a late…NTSB CHI83LA285Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Lockport, ILPlt stated a company acft landed 2-5 min ahead of him on rwy 9 with light winds out of the east. Prior to pattern entry the plt noticed dark clouds to the west with rain. After landing he could not stop the acft & went off the end of the rwy. The acft…NTSB FTW83LA300Accident · No injuriesLimited investigationFinal reportCessna 421A · Forth Worth, TXThe acft ran off the departure end of the rwy and collided with a fence and septic tank complex. The plt said he attempted to use the brakes without success. The acft had an annual inspection on 5/5/83. The brakes were examined afterthe accident. The brake…NTSB MIA83LA170Accident · No injuriesLimited investigationFinal reportCessna 172K · Vieques, PRWitnesses stated seeing the acft in the latter part of the landing roll with brakes locked and tires skidding. The acft went off the overrun area into a ditch.NTSB ATL83LA242Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Denton, NCThe plt reported that during arrival, she elected to land on the sloping rwy, downhill, since there were lower apch obstacles from that direction. She reported that the acft touched down somewhat too FAR down the rwy. The brakes were applied, but they were…NTSB CHI83LA280Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Minneapolis, MNThe acft ran off the end of the rwy and collapsed the nose gear during an aborted takeoff. The acft exceeded the maximum gross weight for takeoff by 190 lbs. Decision to abort was made about 2/3 of the way down the rwy. Braking was good and deceleration…NTSB ATL83LA236Accident · No injuriesLimited investigationFinal reportCessna 172 · Gastonia, NCThe pilot was on a asr approach and sighted the runway at 1/2-mile out at an altitude of 800 feet AGL. Touchdown was made at about half way down the runway at 68 KTS with 40 degrees of flaps. Braking was less than good and the acft hit a barrier at runways…NTSB LAX83LXQ04Accident · No injuriesFinal reportCessna T337G · Susanville, CAThe acft went off the departure end of the runway during a go-around attempt and collapsed the landing gear. The pilot stated that the brakes failed during landing and he attempted a go-around. He also said he retracted all flaps and should have left one…