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 ATL82DA216Accident · Minor injuriesFinal reportCessna 150G · Huntsville, ALThe pilot landed long and fast and pushed the flap lever to an up position for takeoff. The flap lever is spring loaded to the neutral position. When the flaps did not come up the pilot pushed the switch again and the flaps started up. As the runway end was…NTSB FTW82FPJ18Accident · Serious injuriesFinal reportPiper 28-181 · Oklahoma City, OKThe pilot had difficulty locating the airport at his destination. He touched down at a point more than halfway down the 3000 foot runway and realizing he would be unable to stop the aircraft, attempted a go-around. The main landing gear struck a roadside…NTSB DEN82DA145Accident · No injuriesFinal reportCessna 152 · Woods Cross, UTThe student pilot stated that during the takeoff roll, he discovered the airspeed indicator was not operating. Also, he said that he accumulated excessive ground speed and made a decision to abort the takeoff. The aircraft was damaged when the pilot was…NTSB CHI82DA274Accident · No injuriesFinal reportCessna 188B · Loami, ILThe pilot was taking off on the first flight of the day with a reported load of 1080 lbs of wheat seed. During the takeoff, there was a direct crosswind of 6 KTS and the temperature and dew point were 78 and 68 deg, respectively. After using about 3/4 of the…NTSB SEA82DA125Accident · No injuriesFinal reportPiper PA-18-150 · Kendrick, IDThe aircraft collided with a fence during roll-out after the pilot landed on a 2000 ft farm field. Powerlines were located at each end of the field and there was a slight downhill slope. The pilot reported that he touched down at about midfield while landing…NTSB MKC82DA123Accident · No injuriesFinal reportPiper PA-28-140 · Conway Springs, KSThe pilot reported that the wind was from the southwest at 3 KTS, but 16 miles away at wichita, KS, it was from 310 degrees at 9 KTS. He selected runway 17, a sod, 2140 ft, private strip. He said that during the takeoff roll, the aircraft became light on the…NTSB FTW82DA278Accident · Minor injuriesFinal reportCessna 182 · Mckinney, TXAfter a normal skydiver drop, the pilot spiraled down for a normal landing on a 2000 ft gravel runway with a powerline at the approach end. The wind was reported as variable at 5 KTS. The pilot reported that during the landing, the aircraft touched down on…NTSB SEA82DA105Accident · No injuriesFinal reportCessna 182Q · Spokane, WAThe pilot reported that after checking the wind sock, an approach was made to the runway over trees. Reportedly, the first approach was uncomfortable, so a go-around was made. The pilot stated that the second approach and touchdown were normal, but there was…NTSB ATL82DA193Accident · Minor injuriesFinal reportPiper PA-32-300 · Westminster, MDWhile on a cross-country flight, the pilot elected to make an unscheduled stop at a unfamiliar airport to check the en route weather. He circled the airport and thought the wind indicated favored runway 31, but later, he found that the wind was calm. No…NTSB NYC82DA154Accident · No injuriesFinal reportCessna 172M · Savage, PAAfter a cross country flight, the aircraft approached a 1900 foot landing strip for landing. After a fly-over to check the area, an approach to land ended in a go-around. On the second approach, the pilot was high and fast. He slipped the aircraft to lose…NTSB MKC82FCJ04Accident · 1 fatalFinal reportPiper PA-36 · North Platte, NEThe aircraft ran off the departure end of the runway during takeoff on a planned agricultural flight. After departing the runway, it continued for a distance through uncut wheat until it contacted a shallow washout and small bank, then flipped over. There…NTSB MIA82DA148Accident · No injuriesFinal reportPiper PA-28 · Chipley, FLThe pilot landed long to avoid standing water. The aircraft overran the runway and collided with trees.NTSB MKC82DA115Accident · No injuriesFinal reportBeech 58P · Fullerton, NEThe pilot pulled up to avoid a collision with a truck on final approach. He landed midfield on a 2350 foot wet grass runway and ran off the end of the runway into rough terrain.NTSB NYC82DA143Accident · No injuriesFinal reportCessna 172P · Clementon, NJDuring arrival, rain was encountered and the aircraft was landed on a wet runway. The pilot reported that his approach speed was 15 to 20 knots high. After touchdown, he encountered hydroplaning conditions and was unable to stop on the runway. After departing…NTSB FTW82DA270Accident · No injuriesFinal reportMooney M20F · Wimberley, TXThe pilot stated that during a landing, the touchdown was made near the intended point, but the aircraft did not decelerate as rapidly as expected. He also stated that heavy braking was initiated, but by then it became evident that the aircraft could not be…NTSB DEN82DA128Accident · No injuriesFinal reportPiper PA-18-150 · Aurora, COThe pilot-in-command (PIC) was refamiliarizing himself in the Piper PA-18. He was occupying the front seat while the owner was acting as second-in-command in the backseat. On the third landing, the aircraft encountered soft terrain towards the end of the…NTSB DEN82DA120Accident · No injuriesFinal reportAero Commander 100 · Firestone, COThe pilot had just purchased the aircraft and was ferrying it from California to Colorado. He stated that during the landing at Firestone, Colorado, the seat was too FAR aft and he was unable to apply the brakes. The aircraft ran off the end of the runway,…NTSB CHI82DA226Accident · No injuriesFinal reportPiper PA-38 · Lowell, MIDuring the administration of a private pilot flight test, the prospective private pilot failed to gain sufficient airspeed on takeoff to enable the aircraft to climb. Approximately 3/4THS of the way down the runway the check pilot elected to abort the takeoff…NTSB FTW82DA235Accident · No injuriesFinal reportCessna 310P · Fort Worth, TXThe aircraft was landed and the pilot realized he was not getting proper braking. He decided it was too late to go around so he elected to maneuver off the side of the runway. The aircraft went through a fence and into some trees before stopping. Witnesses…NTSB NYC82DA129Accident · No injuriesFinal reportI.C.A. Brasov IS-28B2 · Warren, VTThe pilot had little or no previous flight time in this romanian built glider. He reported departing from an airport located on the lee side of the sugarbush mountains. He stated that a strong west wind produced a turbulent rotor near the airport and the…NTSB MIA82FLD19Accident · Serious injuriesFinal reportSchweizer 2-33A · Brooksville, FLThe pilot landed fast with a slight tailwind. Braking action was poor due to the wet grass runway. The aircraft continued past the landing area into a boundary fence.NTSB NYC82DA127Accident · No injuriesFinal reportCessna 182H · Fort Fairfield, METhe pilot stated that the aircraft was slow to accelerate in loose gravel at the beginning of the takeoff roll. He reported that he rotated for takeoff before reaching his abort point about 1000 ft down the 2100 ft runway. He stated that the aircraft was not…NTSB CHI82DA210Accident · No injuriesFinal reportBeech C23 · Strongville, OHThe pilot reported that he had landed long in calm wind conditions at dusk. He stated that he could not stop, and to avoid going off the end of the runway, he tried to ground loop to the left. The aircraft entered a run-up area at the end of the runway where…NTSB MKC82DA103Accident · No injuriesFinal reportCessna 172N · Marion, IAThe pilot reported that he took off, stayed in the traffic pattern, and made a normal approach with one notch of flaps at about 75 mph. He stated that on final approach, the wind shifted from 350 to almost 180 degrees. He landed long and was unable to stop on…NTSB FTW82DA214Accident · No injuriesFinal reportCessna T188C · Transylvania, LAThe pilot landed fast on a wet grass runway. Application of brakes failed to stop the aircraft and the pilot attempted to ground loop and struck a ditch damaging the right wing.NTSB ATL82FKQ13Accident · Serious injuriesFinal reportCessna 182P · Winona, MSThe pilot stated that after a takeoff run, the controls locked and he could not pull the aircraft off of the runway. Subsequently, the plane collided with a dirt bank beyond the end of the runway, became inverted, and slid backwards. An inspection of the…NTSB LAX82DA201Accident · Serious injuriesFinal reportCessna 210A · Davis Dam, AZWhile crossing over rwy 31 threshold a pickup truck entered the rwy environment traveling in a nw direction. The plt was able to fly over the truck while simultaneously adding full power. The eng did not develop full RPM until the acft was near the end of the…NTSB CHI82FEE14Accident · No injuriesFinal reportDouglas DC-3A · Sandwich, ILAfter returning from a parachute jumping flight, the pilot elected to land on the 1800 ft grass runway. A 3000 ft asphalt runway was available, but he had been using the grass runway to avoid wear on the tires. There was a 30 ft powerline at the approach end…NTSB ATL82FID10Accident · No injuriesFinal reportPiper 24-260 · Lexington, VAThe aircraft overran a 1500 wet, sod, downhill runway and collided with a ditch off the end of the runway. The collision collapsed the landing gear, bent the prop, and buckled the fuselage. The pilot reported the wind was 180 degrees at 5 to 10 knots.NTSB NYC82DA096Accident · No injuriesFinal reportCessna 172N · Taberg, NYThe aircraft touched down about 1/3 of the way down grass runway. The pilot reported the runway surface was slippery and that he should have approached from the opposite direction where 50 foot wires were not a clearance problem.NTSB SEA82DA071Accident · No injuriesFinal reportCessna 180K · Jordan Valley, ORThe aircraft landed 1/3 of the way down the runway and continued off the end into a fence. The pilot stated that the wet sod runway surface hindered adequate braking.NTSB MKC82DA081Accident · No injuriesFinal reportCessna 182A · Minden, NEThe pilot stated that he carried extra power during the approach for aid in directional control in the 10 to 15 knot crosswind. Although the pilot applied full brakes at touchdown on the wet sod runway, the aircraft ran off the end into a ditch.NTSB ATL82DA136Accident · Minor injuriesFinal reportCessna 150 · Buford, GAThe pilot used zero flaps and about 2/3RDS of the available runway in an attempt to practice a short field takeoff. During the takeoff roll the pilot was unable to obtain takeoff speed and elected to abort but was unable to stop the aircraft before it rolled…NTSB ATL82DA135Accident · Minor injuriesFinal reportBeech C23 · Churchville, MDThe pilot stated that he lowered the nose of the aircraft during the approach to expedite his touchdown. He also stated that he did not apply brakes immediately because the aircraft was not firmly on the ground. When he realized he would be unable to stop on…NTSB ATL82DA133Accident · No injuriesFinal reportCessna 182 · Summersville, WVAccording to the pilot, he made his landing approach high and hot. He touched down long and was unable to stop on the remaining runway. While applying brakes, the aircraft veered off the side of the runway. Subsequently, the nose and right main gear failed.NTSB ATL82DA130Accident · Minor injuriesFinal reportPiper PA-28-161 · Mitchellville, MDThe pilot took off on a dark night to an airport that he had never landed at before. While en route, he became disoriented and called a flight service station for help. A military helicopter pilot rendezvoused with the lost pilot and provided vectors to the…NTSB NYC82DA090Accident · No injuriesFinal reportMooney M20G · Pittstown, NJDuring arrival, the pilot elected to land on runway 26 in calm wind conditions. During the landing, the aircraft touched down just beyond the intersection of runway 12/30. The pilot applied the brakes as she approached the grassy area, which was still wet…NTSB MIA82DA122Accident · No injuriesFinal reportPiper PA-28 · High Springs, FLThe pilot stated that the wind shifted while landing and the aircraft overran runway 18 colliding with a fence. The gainsville 1018 EDT weather observation reported the winds from 190 degrees at 18 knots.NTSB SEA82DA062Accident · No injuriesFinal reportCessna 172N · Lisabuella, WAThe pilot landed on a freshly mowed, grass runway. He reported that he had a left crosswind at 10 gusting 15 knots. The aircraft touched down at about 1/3 of the way down the runway. About 450 ft from the departure end, the brakes were applied. However, the…NTSB ATL82DA124Accident · No injuriesFinal reportCessna A150 · Leonardtown, MDThe pilot reported that his speed was fast on base leg and final approach. After touchdown he bounced back into the air and added power for a go-around, however, he failed to return the carburetor heat control to the cold position and the aircraft did not…NTSB ATL82FID07Accident · No injuriesFinal reportBeech 90 · Hot Springs, VAThe pilot stated that during an ILS approach, he delayed at the decision height for several seconds until he had a good view of the runway. The aircraft touched down 671 ft from the departure end of the runway in light and variable wind conditions. The pilot…NTSB FTW82DA149Accident · Minor injuriesFinal reportCessna 172 · Delaplane, AROn landing the pilot noticed braking action was poor due to wet grass on the strip. The nose of the aircraft struck a soft spot on the runway, sank in and sheared off the nose gear. The aircraft then nosed over. Investigation revealed the pilot/owner had…NTSB ATL82FKG12Accident · Serious injuriesFinal reportCessna 421C · Atlanta, GADuring arrival, the pilot was cleared for an ILS approach to runway 20L. The pilot stated that the approach was normal in moderate to heavy rain and he broke out at about 800 ft AGL. He crossed the end of the runway with full flaps, was high, and touched down…NTSB DEN82DA070Accident · No injuriesFinal reportBellanca 7ECA · Spearfish, SDThe student pilot departed on runway 30 to practice touch and go landings. He immediately entered the traffic pattern for runway 26. He said he made a power on, soft field landing, touching down at 65 knots IAS, and then immediately started a takeoff.…NTSB LAX82DA108Accident · Minor injuriesFinal reportGrum Amer AA-5B · Placerville, CAWhen the pilot arrived at the airport, the top surfaces of the aircraft were covered with about two inches of snow. He stated that his preflight included a complete removal of the snow. However, he also stated that during the takeoff roll, there was a layer…NTSB FTW82DA133Accident · No injuriesFinal reportCessna 205 · Albuquerque, NMThe pilot stated that the landing was normal and that he applied light braking for passenger comfort while keeping the aircraft on the runway centerline and looking for the runway end. Heavy braking was applied when the runway end lights were observed. The…NTSB ANC82DA032Accident · No injuriesFinal reportPiper PA-32 · Akiachak, AKThe pilot began taking off on a soft runway with a left quartering crosswind. He stated that he was unable to get enough speed on the soft mud for a safe takeoff. He cut the power to abort, but was unable to stop on the remaining runway. The plane continued…NTSB MIA82DA091Accident · No injuriesFinal reportPiper PA-32R · Moca, PRThe pilot landed on an unlighted grass strip at night with a load of marijuana. During the landing, the plane continued off the strip and into a sugar cane field.NTSB DEN82DA051Accident · No injuriesFinal reportCessna 182K · St. Ignatius, MTThe pilot stated that he and his passengers attempted to remove as much snow as possible from the aircraft and that he was confident that the propeller blast would blow away whatever snow remained. Although the wind at surrounding stations was generally…NTSB CHI82DA103Accident · Minor injuriesFinal reportCessna 175 · Tuscola, ILA landing was made on runway 27 just prior to sunset. The pilot reported that he realized he was not slowing fast enough, but due to the low altitude of the setting sun, he misjudged the length of the runway. He initiated a go-around, but did not obtain…