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 ANC86LA144Accident · No injuriesLimited investigationFinal reportChampion 8GCBC · Big Delta, AKThe plt attempted to land on a gravel bar during a hunting flt. He failed to see a wash/ditch on the bar and the right main gear collapsed upon contacting it. The acft then rolled inverted.NTSB FTW86LA150Accident · Minor injuriesLimited investigationFinal reportCessna U206F · Matagorda Is., TXThe pilot was making a beach landing when the nose wheel struck an object in the sand, causing the nose wheel to collapse and the aircraft to nose over into an inverted position.NTSB DEN86LA220Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Center, COThe plt reported that he was landing on a 50 ft wide dirt strip and allowed the acft to drift to the left during the landing roll. The left wing collided with wheat growing along the left side of the strip and the acft swerved further to the left. During the…NTSB FTW86LA140Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Roanoke, TXThe pilot took off during darkness on an early morning flt & arrived at the destn arpt prior to sunrise. He was unable to activate the rwy lights, but since the ground features could be seen, he elected to land. During the landing, the acft touched down…NTSB FTW86LA129Accident · No injuriesLimited investigationFinal reportCessna 182C · Decker'S Island, TXDuring a beach take-off run of approximately 200 feet, the aircraft nose wheel sunk into the soft sand. The pilot tried to add power and pull the column back, however the aircraft nosed over into an inverted position.NTSB DEN86LA185Accident · Minor injuriesLimited investigationFinal reportCessna 182P · New Castle, COPlt attempted to abort landing while on short final with 40 degrees of flaps. Plt decided that he would not clear trees at the FAR end of meadow so he executed a precautionary landing during which the acft struck a ditch and nosed over. The density altitude…NTSB CHI86LA167Accident · Minor injuriesLimited investigationFinal reportCessna A152 · Middleton, WIThe student pilot stated that he was practicing soft field takeoffs on a grass strip. He aborted his first attempt to make an intersection takeoff. On his second try, he thought he could get airborne, but did not. The aircraft struck an embankment near the…NTSB ATL86LA192Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Van Wert, OHThe plt reported that his airspeed was too high on ldg and that the acft brakes failed to function when he tried to stop the acft. The plt turned the acft off the rwy into a soft grassy area as the acft neared the rwy end. Another plt who witnessed the…NTSB ATL86LA185Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Columbus, GAThe flight departed venice, FL enroute to cleveland, TN. The plt related that he elected to make an unscheduled landing at the Columbus airport, Columbus, GA due to thunderstorm activity in the area. The aircraft reportedly encountered wind shear, landed…NTSB MKC86LA127Accident · No injuriesLimited investigationFinal reportCessna 172F · Jefferson City, MOThe runway was under construction with a new section being added to the old runway. This construction was covered in a published NOTAM. The pilot had been making touch and go landings and was making a full stop landing when he landed on the new portion of the…NTSB ANC86LA067Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Deshka River, AKThe pilot stated while landing at an unimproved airstrip the aircraft's left main landing gear struck a bush causing the aircraft to ground loop.NTSB ATL86LA134Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Enterprise, ALDuring the touchdown landing phase on runway 23, the aircraft veered off the left side and crashed following an attempted go-around. The pilot applied full power, but was unable to clear a tree line off the departure end. As the pilot elected to abort, the…NTSB MKC86LA105Accident · No injuriesLimited investigationFinal reportBeech A36 · Mountain Home, ARThe PIC rptd gear failure and gear warning horn about 5 to 10 seconds into the landing roll. The PIC rptd 3 in the green before touchdown to the rwy. Subsequent inspection of the landing gear showed no mechanical or other deficiency. Inadvertent movement of…NTSB ATL86LA124Accident · No injuriesLimited investigationFinal reportCessna 182A · Kenansville, NCDuring a landing attempt, the pilot failed to maintain directional control with a 15 knot right crosswind. The pilot stated that he applied rudder and braking, the aircraft drifted of the left side of the runway and collided with a ditch. The pilot did not…NTSB ANC86LA053Accident · No injuriesLimited investigationFinal reportCessna 185 · Bethel, AKThe pilot stated that he was taxiing for takeoff on the frozen river when the left main gear broke through the ice. The aircraft's left wing and left gear were damaged.NTSB LAX86LA194Accident · No injuriesLimited investigationFinal reportCessna 150H · Davis, CAThe acft landed on a privately own ranch dirt airstrip. The plt reported the landing was normal, but during the landing roll the acft nosewheel struck a small ditch causing it to nose over onto its back. The pilot did not report any preimpact acft…NTSB CHI86FER05Accident · Serious injuriesFinal reportCessna A188B · Greenbush, MNThe plt reported that the acft contacted a soft spot, caused by recent rains, in the sod runway during takeoff. The acft decelerated, however, the plt attempted to continue the takeoff as not enough runway remained to abort. The acft did not obtain sufficient…NTSB CHI86IA115Incident · No injuriesIncident investigationFinal reportBoeing 757-251 · Minneapolis, MNN508US was operating as nwa flt 150. The captain stated after the incident that the flt was uneventful until landing. Upon landing and spoiler deployment, the acft pitched up abruptly, to an attitude of 10 degrees. The landing was completed without incident.…NTSB FTW86LA052Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Houston, TXA flight instructor was showing his student how to takeoff from a crass strip when he noticed another aircraft taking off on an intersecting runway. He elected to abort the takeoff, and the aircraft collided with a ditch, damaging the main gear, left wing and…NTSB FTW86LA042Accident · No injuriesLimited investigationFinal reportCessna 172N · Marietta, OKDuring takeoff roll, at about 45 knots ground speed, the left main landing gear contacted a water eroded spot on the runway. The aircraft bounced and/or was pulled off the ground without sufficient speed to maintain flight. The aircraft settled and struck a…NTSB MIA86FA095Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Florida City, FLThe acft touched down on the top of a flood control dike approx 12 ft wide. The acft continued for about 1336 ft before the left wheel slid off the dike where the dike makes a slight curve to the right. The left gear was torn from the acft as it left the…NTSB MIA86LA092Accident · No injuriesLimited investigationFinal reportCessna 210J · Jacksonville, FLThe plt stated that while taxiing to the ramp, after landing, he taxied through construction barricades & ran off the taxiway. While attempting to get back on the taxiway, the nose gear got caught in a hole & collapsed.NTSB DEN86FA080Accident · No injuriesField investigationFinal reportBoeing 737-300 · Denver, COF/o was on the 3rd initial operating experience flt with a check airman. Capt and f/o had discussed rapid rate of rotation on previous flts and again on accident flt. The f/o performed the takeoff from Denver and exceeded rotation rate of 3 degrees per sec.…NTSB MKC86LA047Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Lawrence, KSThe plt stated he mistook an ice and snow covered area for a taxiway and turned off past the actual taxiway. The acft struck a snowbank which collapsed the nosegear. The blue taxiway light was out. This light marks the edge of taxiway. The taxiway was free of…NTSB MKC86LA040Accident · No injuriesLimited investigationFinal reportBeech C23 · Dubuque, IAThe aircraft landed on runway 13 because the n-s runway was covered with ice. The wind was from 220 degrees at 16, gusts to 24 knots. The aircraft bounced twice during the landing and drifted left. The aircraft encountered snow along the left side of the…NTSB DEN86LA051Accident · No injuriesLimited investigationFinal reportCessna 172N · Longmont, COAccording to the student plt he made a normal apch to landing. The runway had not been cleared of snow to its full width. The acft's left wheel touched the snow pulling the acft off the rwy and the acft flipped over.NTSB ATL86LA042Accident · No injuriesLimited investigationFinal reportCessna 150L · Manning, SCDuring takeoff ground run on the wet grass runway the aircraft hit a soft spot in the runway and nosed over to an inverted attitude. Both the private pilot and passenger escaped without injury.NTSB DEN86LA027Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Ft. Collins, COThe acft collided with large chunks of snow on the rwy during takeoff roll. The plt stated that during the roll about mid-way down the rwy he spotted the snow and decided to abort but was unable to avoid the snow. The left gear contacted the snow and the acft…NTSB LAX86LA019Accident · No injuriesLimited investigationFinal reportBeech 24R · San Diego, CAThe acft collided with a ditch during taxi to takeoff. The plt was taxiing into the sun and went into the ditch when the taxiway turned to the rt. The plt said he was blinded by the rising sun.NTSB SEA86LA010Accident · No injuriesLimited investigationFinal reportCessna 182P · Bly, ORThe airstrip was only 20 feet wide. The aircraft was landed slightly to the right of the center. The aircraft's right main gear went into the gravel and the aircraft veered right. The nose gear then struck rocks and collapsed. The aircraft then nosed over.NTSB MKC86LA009Accident · No injuriesLimited investigationFinal reportCessna 140A · Pacific, MOThe airplane had rolled for 100 feet when the left wheel hit a mound of dirt left by a pocked gopher. The wheelpant bracket contacted the tire and acted as a brake. Airplane nosed forward to the inverted position.NTSB SEA86LA003Accident · No injuriesLimited investigationFinal reportCessna 150 · Burton Lake, ORThe acft failed to become airborne on the soft, short, rough cinder covered airstrip probably due to a combination of density altitude and poor plt technique. The acft struck a berm at the end of the runway where it nosed over. The plt was also departing…NTSB ANC86LAG01Accident · No injuriesFinal reportCessna 140 · Beluga, AKThe student plt attempted takeoff from am unimproved, overgrown river bed. He stated he paced off the distance availablefor takeoff and it was too short, however, he decided to takeoff anyway. The acft impacted alders and a stream bank just as it was lifting…NTSB CHI85FA385Accident · No injuriesField investigationFinal reportDassault-Breguet 10 · West Chicago, ILThe falcon 10 touched down long and fst on a wet runway, experienced hydroplanning and went off the end of the runway,struck a drainage ditch and collapsed the landing gear. The nose gear came back and bent the throttle quadrant bracket, pulled the fuel…NTSB ATL85LA271Accident · No injuriesLimited investigationFinal reportCessna 305A · Star, NCDuring landing roll the aircraft ground looped and the rightlanding gear separated from the aircraft. The pilot stated that the right brake locked causing the aircraft to veer to the right. No evidence of brake malfunction was found.NTSB ATL85LA270Accident · No injuriesLimited investigationFinal reportSwearingen SA-26AT · Columbia, SCThe pilot stated that during landing roll, after slowing the aircraft to approx 40 KTS the aircraft swerved off of the runway following activation of the nose wheel steering. The pilot related that the nose wheel steering system malfunctioned on two previous…NTSB ATL85LA264Accident · No injuriesLimited investigationFinal reportPiper PA-18 105 · Hendersonville, NCDuring the takeoff phase of a touch & go landing, the CFR and private pilot lost directional control and ran off the side of the runway.NTSB ANC85LA166Accident · No injuriesLimited investigationFinal reportMaule M-5 · Cape Yakataga, AKThe plt reported that he started to depart from a gravel strip, then elected to abort the takeoff. While rolling on the ground, the acft hit a 'wash-out' which bent a structural tube on the landing gear assembly.NTSB MKC85LA197Accident · No injuriesLimited investigationFinal reportCessna 310 · Cotton Plant, ARDuring the landing roll at an airstrip, the plt allowed the acft to drift. The drift continued until the acft struck a ditch bordering the rwy. The ensuing impact with the ditch substantially damaged the acft. The pilot stated the wind conditions were light &…NTSB DEN85LTG07Accident · No injuriesFinal reportAeronca 058B · Mott, NDWhile departing a stubble field, the aircraft's tire ran into a soft spot in the ground and the aircraft turned and struck the shoulder of a road. The right gear broke and the right wing tip struck the ground, the right strut broke, the tail wheel and rudder…NTSB FTW85LA327Accident · No injuriesLimited investigationFinal reportCessna 150M · Lubbock, TXThe plt was advised that he was cleared for an intersection takeoff on rwy 17R. After his run up, the plt attempted a night takeoff to the north on an unlighted taxiway that ran parallel to the active runway. Controllers advised the pilot to abort, which he…NTSB LAX85LA357Accident · No injuriesLimited investigationFinal reportCessna 172P · Glendale, AZThe acft ran off the rwy and into a ditch after a landing at Glendale, AZ. The rwy is 2400 ft long and 50 ft wide. The plt stated he landed about 40% down the rwy, bounced three times, steered off the rwy and hit a shallow ditch. The plt reported no…NTSB ATL85LA240Accident · No injuriesLimited investigationFinal reportCessna 152 · Lexington, NCStudent pilot was on solo flight. He stated that another acft called on final as he was on runway for takeoff . Unsure of action to take since taxiway behind him was blocked, he rushed takeoff. A soft field takeoff was attempted. Nose was raised, tail dragged…NTSB ANC85LA148Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Montague Island, AKThe plt stated that during the takeoff roll, the acft was kept close to the waterline to stay on the hard sand. After rolling aprx 700 ft, the tail wheel was raised. At about that time, the left gear sank in soft sand & pulled the acft to the left.…NTSB ANC85LA147Accident · No injuriesLimited investigationFinal reportCessna 172 · Chickaloon Flat, AKThe plt made an off-arpt landing on an area of clay silt with sparse grass. After slowing the acft to about 20 to 25 mph, the nosewheel went into a shallow gully of soft clay. The acft then stopped abruptly & nosed over.NTSB DEN85LTG05Accident · No injuriesFinal reportGrumman G164A · Colfax, NDThe plt noticed the spray pump was stuck in the off position shortly after takeoff for the aerial application flt. The decision was made to land on a private strip and during landing on the soft fld, the acft contacted high vegetation and nosed down.NTSB MIA85LA221Accident · No injuriesLimited investigationFinal reportCessna 182P · Davisville, FLThe pilot stated that on landing roll out at the agricultural airstrip, the aircraft struck a ditch causing the nose gear to collapse.NTSB BFO85LA059Accident · No injuriesLimited investigationFinal reportCessna 182RG · Stevensville, MDAfter landing to the left of the centerline of rwy 10, the acft veered left off the rwy and collided with a drainage ditch located approximately 10 yards from the rwy. Following contract with the ditch, at approximately 15 mph, the acft flipped over, coming…NTSB SEA85LA189Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Scappoose, ORDuring taxi from landing while in a turn, th epilot inadvert ently selected gear up. He owns a similar airplane and had borrowed this aircraft. His aircraft gear and flap contr ols are in the opposite position of this aircraft's. he intended to raise the…NTSB NYC85LA164Accident · No injuriesLimited investigationFinal reportCessna 182M · Block Island, RIThe plt was checked out in the C-182 on July 9, 1985 and had flown this acft for 1 hr in the previous year. During a normal power off landing with ten degrees of flaps extended, the plt added power and noticed no change in performance. The acft touched down…