NTSB investigations
1,048 cases where the first occurrence was “On ground/water encounter with terrain/water”.
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\" = 320) 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" = 320) 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 NYC83LA202Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Westerly, RIAfter landing, the plt proceeded to taxi to the ramp area. While maneuvering within the ramp area, the plt taxied the acft into a construction zone. Reportedly, the right main wheel dropped into a rough area & resulted in substantial damage to the right wing…NTSB CHI83LA363Accident · No injuriesLimited investigationFinal reportCessna 172 · Grandview, INThe acft collided with an unseen rut in an off arpt landing on an unprepared grass field. The nose gear collapsed and the acft nosed over. The weather was VMC and no flt plan was filed. The pilot made a low pass over this field and saw no obstacles so he…NTSB ANC83LA140Accident · No injuriesLimited investigationFinal reportCessna 336 · Kenai, AKAccording to the pilot winds were gusty during landing. Upon landing the right wing collided with some trees and pulled the acft to the right into the trees. The acft turned on its back just prior to stopping.NTSB MKC83FA171Accident · Serious injuriesField investigationFinal reportAeronca 11CC · Orange City, IAThe aircraft had completed a landing in a field and the pilot was attempting a takeoff from the stopping point. The aircraft did not become airborne and ran for aprx 100 feet across a boggy swamp and impacted a four foot high dirt bank.NTSB LAX83LA363Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Clifton, AZThe acft collided with soft terrain and nosed over during an attempted takeoff. Custom officials said the acft was being tracked on radar. The plt of the accident acft saw the customs acft after he landed and attempted to takeoff, lost control and nosed over…NTSB FTW83LA347Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Plains, TXDuring arrival, the plt determined that rwy 26 was the only open rwy. He made a short field apch. However before landing, he did not realize there was a mound of dirt across the rwy where it intersected with rwy 17/35, which was closed. While on the landing…NTSB ANC83LA129Accident · Serious injuriesLimited investigationFinal reportCessna C-180D · Barrow, AKThe pilot stated that he was taxiing downriver, downwind in order to get around two bends in the river to a straight section where a takeoff could be made. The left float of the aircraft struck a sandbar, causing the aircraft to roll end over end.NTSB CHI83LA314Accident · No injuriesLimited investigationFinal reportFlug-Und Fahrzeugwerke Diamant · Frankfort, MIThe plt reported that during a winch tow takeoff the right wing caught in tall grass & soft sand, & the glider ground-looped.NTSB ATL83FA267Accident · Minor injuriesField investigationFinal reportCessna 172M · Sylvester, GAThe pilot had accomplished two takeoffs and two full stop landings. The pilot stated that on the third takeoff RPM was lost about the time for liftoff. He elected to abort the takeoff about halfway down the runway. When he pulled the power/throttle back to…NTSB ATL83LA319Accident · No injuriesLimited investigationFinal reportBeech 55 · Cornelia, GAThe acft collided with a grass-covered curbing at the edge of a taxiway as the pilot attempted to clear the rwy. At thisarpt the rwy is also used as a taxiway. While using the rwy to taxi for takeoff a radio call was heard reporting a landing acft so the…NTSB LAX83LA347Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26B · Phelan, CAWhile on a local flt, thermal activity decreased, so the glider plt headed back to the arpt. On the way back, he encounted an area of sinking air & lost 1500 to 2000 ft of alt. He elected to land on a road. During the roll-out, the left wing hit a dirt…NTSB NYC83LA163Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Argyle, NYThe plt attempted to start the eng by hand propping for aprx 20 min. The eng finally started & continued to rev up. During this time, the passenger was in the rear seat. As the plt was returning to the cockpit, the acft began to roll forward. The plt was…NTSB NYC83LA133Accident · No injuriesLimited investigationFinal reportDG 400 · Morrisville, VTThe motorized glider was taxiing when the left wing tip caught in high grass and the acft veered to the left and penetrated a barbed wire fence.NTSB NYC83LA132Accident · No injuriesLimited investigationFinal reportMooney M20B · Lakeville, MAThe acft collided with the smooth water of a reservoir while flying low during an afternoon flight. The acft crashed about 1000 ft offshore when the right wing tip collided with the surface of the water. The acft then sank in 15-20 ft ofwater. The pilot…NTSB ATL83LA206Accident · No injuriesLimited investigationFinal reportSchweizer 1-26B · Senoia, GAAprx 2 hrs after takeoff, the glider plt ran out of lifting action & selected a hay field for a landing place. From the air, the field appeared to be a suitable landing area. However, after touchdown, the right wing encountered a clump of higher hay (aprx 3…NTSB FTW83LA255Accident · No injuriesLimited investigationFinal reportGlasflugel H-301 · Los Lunas, NMThe glider ground looped off the rwy after the wingtip contacted tall grass. The acft had gone to the right early in thetow but the plt thought the tow would straighten him out even after the wing dropped to the ground. When the right wing contacted tall…NTSB NYC83LA131Accident · No injuriesLimited investigationFinal reportCessna 182B · Taunton, MAThe acft collided with a small rock during taxi from landing. As the pilot taxied back to the ramp area along a dirt taxiway he observed three people standing in the way. The pilot taxied onto the grass to avoid the people and while still taxiing the acft…NTSB CHI83FA220Accident · Serious injuriesField investigationFinal reportSchaffer-Provencher UW · Stockbridge, MIThe balloon landed downslope at about 7 KTS in a rip/drag landing without ground assistance. One of the two passengers was on the downslope side of the basket facing the direction of landing. She lost her grip on the top rail of the basketduring touchdown and…NTSB FTW83LA220Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Bastrop, LAAfter arriving, the plt made a pass over the turf strip to inspect it before landing. He elected to land; however, during the landing roll-out, he saw a ditch running laterally across the strip, but by then, he was unable to avoid it. Subequently, the acft…NTSB CHI83LA207Accident · No injuriesLimited investigationFinal reportCessna 152 · Smithfield, OHThe plt had been practicing touch-and-go landings. On about the 6th or 7th touch-and-go, he applied power to takeoff when a group of deer crossed the rwy. He steered to the left to avoid the animals, went off the rwy, hit a large mound of dirt, then the acft…NTSB FTW83LA190Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Breaux Bridge, LAAccording to the pilot he was attempting to takeoff at night from an unlit turf strip. Just before the attempted takeoff, two sets of vehicle headlights were directed down both sides of the rnwy to help the pilot in the takeoff. On both sides of the rnwy,…NTSB LAX83LA172Accident · Minor injuriesLimited investigationFinal reportGrumman American G164-B · Near Madera, CAThe acft hit a chuck hole in high grass during takeoff roll from a field for an aerial application mission. The left landing gear separated from the acft. The weather was VMC and no flight plan was filed. The pilot sustained minor injuries. The flight was…NTSB DEN83LA085Accident · No injuriesLimited investigationFinal reportCessna R172K · Aurora, COThe aircraft collided with a snowbank during landing. The pilot stated that he had contacted flt service and asked aboutthe runway conditions. Nothing was reported and no NOTAMS were posted. Upon arrival the pilot tried to contact UNICOM atcolumbine. Someone…NTSB SEA83LA066Accident · No injuriesLimited investigationFinal reportCessna 172N · Telma, WAThe aircraft collided with deep unplowed snow on the runway during takeoff and nosed over. The pilot stated that he had landed on frozen snow but when he returned to takeoff the snow was soft. He had a 1200 ft long portion of the runway cleared but it was…NTSB ANC83LA054Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Port Heiden, AKThe acft taxied into a pile of ice after landing. According to an Alaska state trooper that assisted in the investigation, the pilot turned 45 degrees to the right and departed the runway 150 feet short of the taxiway. The sun was bright, and according to the…NTSB ATL83LA123Accident · No injuriesLimited investigationFinal reportScheibe Flugzeugbau L SPATZ-55 · Woodbine, MDThe aircraft collided with a snowbank during landing roll. The turf landing site was clear but snow had been piled two to four feet deep alongside the strip during the clearing process. As the aircraft neared the end of the strip during landing the pilot…NTSB NYC83LA067Accident · No injuriesLimited investigationFinal reportMooney M20E · Butler, PAAfter landing on rwy 25 the plt exited onto a taxiway near midfield to wait for another acft departing rwy 7. The wind was calm & the plt elected to depart rwy 7 as did the other acft. The gear was prematurely retracted during the takeoff roll.NTSB CHI83LA118Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Harrisville, MIThe plt reported that during a touch-and-go landing on a snow covered rwy, the acft hit a chunk of frozen snow. Reportedly, he had departed from the same rwy & had been making touch-and-go landing, but did not see the obstruction.NTSB DCA83AA013Accident · 1 fatalFinal reportConvair 580-11-A · Brainerd, MNDuring arrival, the acft was landed about 1725 ft beyond the rwy threshold. The touchdown was made with the right wing down & the right main gear about 37 ft from the right edge of the rwy. After touchdown, the acft continued to the right & the right…NTSB FTW83LA083Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Bandera, TXThe pilot stated that after a normal landing, he taxied to the end of the runway in order to allow another aircraft to land. He than taxied about 70 ft off the runway into a grass turnaround/taxi area where the aircraft hit an 18 inch deep hole with the left…NTSB ANC83LA038Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Nunapitchuk, AKThe aircraft was taking off from a frozen seaplane landing area when it struck several snow banks and crashed. The pilot stated that he had selected an area of ice, about 1100 ft long, and began taking off in an 8 kt crosswind with 6 passengers on board.…NTSB ANC83LA028Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D1 · Drift River, AKThe pilot reported that while he was landing on crusty snow, the left ski broke through the crust and hit a log that was buried beneath the snow. Subsequently, the left gear failed and the plane nosed over.NTSB FTW83LA058Accident · No injuriesLimited investigationFinal reportCessna 172 · Katy, TXDuring landing the nose wheel contacted a 12 inch rice field type mud dam & the acft flipped over.NTSB MKC83LA037Accident · No injuriesLimited investigationFinal reportCessna 195B · Lewellen, NEPilot collided with a dirt mound during takeoff from a field and groundlooped the aircraft. Landing gear collapsed.NTSB ATL83LA051Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Atkinson, NCThe pilot decided to land on a private strip due to strong gusty winds and thunderstorms. The pilot landed without incident and began to back taxi on the runway when the left main landing gear went into a mud hole off the side of the runway. The aircraft…NTSB ANC83LA016Accident · No injuriesLimited investigationFinal reportCessna 180 · Naknek, AKDuring a power-on taxi turn the pilot reported he was about to strike a 6-FT embankment. The pilot added full power and flaps and the aircraft left the water, flew over an embankment, but the skis caught bushes on top of the bank. The landing gear was…NTSB ANC83LA018Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Near Seward, AKWhile attempting a landing on a beach Near Seward, Alaska, the aircraft's right main and nose landing gear were sheared off after the plane contacted rocks in the sand.NTSB LAX83LA027Accident · No injuriesLimited investigationFinal reportCessna 172 · Antioch, CAThe pilot stated that he came in high and fast, with only 20 degrees of flaps on his second landing attempt. Because of hilly terrain, the pilot elected to land long rather than execute a go-around. The aircraft overran the runway, rolled into a ditch and…NTSB CHI83LA028Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Columbus, OHThe pilot taxiied onto 8 foot culvert after landing. Pilot complained of taxiway markings and lighting. He also said he never saw the culvert.NTSB CHI83LA002Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Romeoville, ILThe pilot flew over the airport at night, saw the runway lights and entered the traffic pattern for landing. On final approach, he saw a rotating beacon and thought an aircraft was holding short of the runway. As he continued on final, he saw that the beacon…NTSB FTW82DA398Accident · No injuriesFinal reportPiper PA-28-140 · Kansas, OKAircraft collided with a hole in a pasture after a precautionary landing due to low fuel state brought on by head winds.NTSB ANC82DA097Accident · No injuriesFinal reportCessna 185 · Near Barrow, AKThe pilot flew to a fishing camp Near Barrow, AK. During the landing roll, the aircraft struck a wet snow drift (about 2FT. Deep) and flipped over.NTSB SEA82DA160Accident · No injuriesFinal reportCessna 152 · Bonners Ferry, IDAfter refueling, the pilot attempted to takeoff from a field. The first takeoff attempt was aborted. During the second takeoff roll the aircraft nose gear struck a ditch, causing the aircraft to nose over.NTSB DEN82DA188Accident · Serious injuriesFinal reportPiper PA-24-180 · Pueblo, COThe aircraft landed at rueblo, CO for fuel on a return flight to Texas. After landing, the pilot asked a female attendant if there were any liquor stores open. The pilot returned to the airport about 1/2 hour later and observed the pilot carrying a brown…NTSB ANC82FAA14Accident · No injuriesFinal reportCessna 402 · Fairbanks, AKThe plt reported that during taxi there was a light trace of dew on the windshield. The passenger stated that during the initial application of takeoff power the windshield became fogged & completely obscured forward visibility. The plt's attention was also…NTSB ANC82DAA17Accident · No injuriesFinal reportPiper PA-18 · 20 Ese North Po, AKAfter previously landing at an off-airport hunting site, the plt & pax started cutting the brush to clear a suitable area for takeoff. Due to the approaching night, the plt considered the area to be suitable. Drg takeoff the left wingtip struck some brush.NTSB MKC82DA156Accident · No injuriesFinal reportSkybolt · Sidney, NEWhile en route, the pilot used his 1981 issue of the aopa airport directory to select a runway for landing at Sidney, NE. The directory showed that there was a 3800 ft sod runway (08/26) and a 6600 ft concrete runway (12/30). The pilot elected to land on the…NTSB FTW82DA354Accident · No injuriesFinal reportGrumman G-164A · Columbia, LADuring takeoff, the left wing of the aircraft contacted the cotton that was growing on the left side of the runway. The pilot reported that he could not lift the wing out of the cotton. When he reduced the power, the aircraft turned left and slid sideways.…NTSB ANC82DAA11Accident · No injuriesFinal reportCessna 180 · Caribou Strip, AKThe pilot reported that he landed in calm wind conditions on a gravel runway that was 1800 ft long. He stated that the landing strip curved to the left, and after touchdown, he was unable to follow the strip to the left. The aircraft went off the right side…NTSB MKC82DA154Accident · No injuriesFinal reportPiper PA-25-235 · Fisk, MOThe pilot was taking off from a small ag strip when his left wing went into milo growing beside the strip. Subsequently, the aircraft spun around and flipped over. This was the pilot's tenth takeoff on that day. He reported that the wind was from the…