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 DEN85LQA03Accident · No injuriesFinal reportPiper PA-18A · Tucumcari, NMOn July 4, 1985, at 1400 MDT, a Piper PA-18, N1754A, registered to ted w. stallings, departed the designated taxiway and collided with a culvert at Tucumcari municipal airport, Tucumcari, new Mexico. The aircraft was being taxied for thepurpose of a local…NTSB FTW85LA280Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Fort Worth, TXPlt was taxiing to parking ramp/hangar after landing and following lineman's signals. He turned off the angling taxiway too soon and the nose and right main gears fell into a hole/low area off the edge of the taxiway. The propeller and right wing struck the…NTSB ATL85LA192Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Ashford, ALThe plt was returning to the private ag strip after completing a spray run. During the landing the pilot found that the left brake was inop. In order to prevent running off end of the 1500 ft rwy, the plt elected to ground loop the aircraft. During the…NTSB DEN85LA174Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Glen Canyon, UTThe plt became lost/disoriented near the end of a x-country flt from west jordan to blanding, Utah. When fuel quantity became low, the plt decided to make a precautionary landing on a dirt road. During the landing falre, a x-wind gust drifted the acft to the…NTSB ATL85LA194Accident · No injuriesLimited investigationFinal reportCessna 152 · Lexington, NCDuring landing on a private turf airstrip, the nose wheel struck a 'pot' hole. The nose wheel separated from the acft and the acft skidded to a stop resulting in substantial damage.NTSB ANC85FA100Accident · Minor injuriesField investigationFinal reportCessna 180H · Theordore River, AKThe plt landed the float plane on the Theordore River which had a maximum width of about 90 ft & had few straight runs of more than 400 ft. the River had many sharp turns, some in excess of 150 degs, & its depth was as low as 18 inches at low tide. The plt…NTSB ATL85LA186Accident · No injuriesLimited investigationFinal reportCessna 152 · Abbeville, SCWhile practicing touch & go landings the student plt lost directional control of the acft & ran off the side of the rwy. The acft flipped to an inverted attitude when the nose wheel dug into the soft soil. The student was on his second solo flight.NTSB CHI85LA225Accident · No injuriesLimited investigationFinal reportCessna 175B · Lancaster, OHThe plt was unaware that the taxiway did not continue to the approach end of rwy 28. He failed to see the turn in the taxiway and the acft continued off the end of the taxiway where it contacted a ditch. The taxiway was not lit (nor was it required to be). It…NTSB NYC85LA144Accident · No injuriesLimited investigationFinal reportCessna 305A · Toughkenamon, PAThe acft ground looped during a landing roll on a sod rwy. The plt stated that during the landing roll, it felt as if the right main gear contacted a knoll of grass resulting in the acft ground looping to the right.NTSB CHI85FA210Accident · Minor injuriesField investigationFinal reportHughes 300 · Joliet, ILThe helicopter experienced extreme vertical vibrations while landing from a hover. Inadvertent ground contact during uncontrolled oscillations resulted in destruction of the helicopter.NTSB ATL85LA172Accident · No injuriesLimited investigationFinal reportGalloway B-8M · Milledgeville, GAThe plt stated that the gyroplane was blow off the side of the rwy by a gust of wind during the takeoff portion of a touch and go landing. The acft traveled into a grass area and nosed over. The student plt did not have a solo endorsement and had only two…NTSB SEA85LA191Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Coalinga, CAThe plt mistakenly landed on a pvt airstrip and during a x-wind landing made a go around due to a gust of wind. The acft struck a dirt berm with the right wing and the right main gear.NTSB NYC85LA129Accident · No injuriesLimited investigationFinal reportCessna 180J · Hooksett, NHThe plt was ferrying the acft to a fld where floats were to be installed. While on the apch, the acft encountered a crosswind and drifted 20 ft off the intended centerline. The acft touched down and rolled about 110 ft before colliding with a small bush and…NTSB FTW85LA225Accident · No injuriesLimited investigationFinal reportCessna 150M · Moran, TXThe student plt attempted to make a precautionary landing due to his immediate need to use the bathroom. There were no acft problems involved. The student used 'soft field landing' techniques and touched down on soft ground for an off arpt landing. When the…NTSB ATL85LA164Accident · No injuriesLimited investigationFinal reportCessna 177B · Huntsville, ALThe acft drifted right of rwy center line during landing roll & the plt aborted the landing by applying full pwr. The acft continued off the rwy and the nose wheel dug into the soft soil resulting in the acft nosing over.NTSB ANC85LA077Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Bethel, AKThe pilot reported that during the takeoff roll the aircraft could not obtain airspeed and the aircraft lost directional control striking a snow bank at the departure end of the runway.NTSB CHI85LA182Accident · No injuriesLimited investigationFinal reportCessna 177RG · Jacksonville, ILAfter completing 14 landings the pilot elected to full stop. He attempted a go around after touchdown & after rolling down part of the rwy. The acft ran off the end of the rwy into a plowed field.NTSB MKC85LA085Accident · No injuriesLimited investigationFinal reportCessna 177B · Alliance, NEAcft collided with ditch at end of strip while aborting takeoff. Takeoff was being made from a 2200 ft long dirt farm strip. The strip had a slight upslope and the density altitude was 6,800 ft. wing flaps were found in retracted position after the accident.NTSB ATL85LA139Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Elizabethton, TNPilot lost directional control during landing and skidded of the left side of runway. Pilot reported windshift.NTSB LAX85LA209Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 Twin Astir · Hemet, CAThe plt attempted to land the glider near the rwy threshold in order to be ready for an immediate relaunch. He reported that he was aware of vegetation, located along the edge of the rwy, but said that he misjudged its height. The right wing contacted the…NTSB LAX85LA172Accident · No injuriesLimited investigationFinal reportCessna 152 · Grass Valley, CAAccording to the plt she flared too late and was too close to the left side of the 50 ft wide rwy at touchdown. The acft veered left on the lndg roll and the left main gear struck a snowbank. The plt tried to steer out of the snowbank but the nose gear also…NTSB MKC85LA067Accident · No injuriesLimited investigationFinal reportCessna 150 · Keokuk, IAWhile taxiing for t/o on a sod rwy, gusting winds flipped the C-150 over after it became bogged down in the soft terrain. The plt was aware of the gusting wind conditions but was not expecting to get the a/c stuck, even though the pilot was aware it had…NTSB ATL85LA107Accident · No injuriesLimited investigationFinal reportCessna 172E · Campbellsville, KYThe acft was positioned with its tail into the wind & it was blown over. The wind was from 240 deg at 18 KTS with gusts to 28 KTS.NTSB BFO85LA018Accident · No injuriesLimited investigationFinal reportCessna 152 · Manassas, VAThe student plt reported that after the acft touched down on a touch-&-go landing, he observed about 1000 birds at the departure end of the rwy. He elected to turn off at the 1st available taxiway. However, his speed was too fast to negotiate the turn & the…NTSB ATL85LA098Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Pontotoc, MSThe pilot ran off the end of the 1500 ft wet & soggy sod rwy during takeoff ground run. The plt stated that he did not realize that he was not going to liftoff , until the acft was too FAR down the rwy to stop on the remaining rwy surface.NTSB LAX85LA140Accident · No injuriesLimited investigationFinal reportCessna 177RG · Ukiah, CAOn a dark night, the plt failed to observe that the taxiway (on which he was taxiing) made a 90 deg turn to connect with the beginning of the rwy. Where the taxiway turned, the acft continued straight ahead & went into a 3 ft deep ditch. There were no taxiway…NTSB SEA85LA055Accident · No injuriesLimited investigationFinal reportBeech 58TC · Spokane, WAThe acft touched down to the left of the runway onto snow. Visibility at the time of the accident was 1 mile with snow and a ceiling of 700 feet.NTSB ATL85LA084Accident · No injuriesLimited investigationFinal reportBeech BE-35 · Andrews Murphy, NCThe nose gear collapsed when the acft contacted a snow bank during takeoff.NTSB ANC85LA044Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Mcgrath, AKAcft is equipped with main gear skis and a tailwheel. Plt stated elevator & rudder controls stuck during the landing roll on snow covered terrain. Inspection reveladed the tail section of the acft collapsed after contacting the head of a small tree. The…NTSB MKC85LA046Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Des Moines, IAPlt was informed of holes along the right side of the rwy so he intentionally touched own on the left side of the rwy. The left main gear contacted a snowbank which paralled the rwy and the acft nosed into the snowbank.NTSB ANC85LA038Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Shaktoolik, AKThe ski equipped acft contacted a snow drift during takeoff ground run. Acft veered and contacted a fishing rack.NTSB NYC85LA037Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · New Castle, PAOn takeoff roll, the student pilot allowed the acft to drift left off of the runway. Acft collided with a dirt embankment and flipped inverted.NTSB SEA85IA024Incident · No injuriesIncident investigationFinal reportFairchild Swearingen SA 227 · Pullman, WAThe aircraft's landing gear collapsed after the plane went off the right side of runway 23 during takeoff. Reportedly, the aircraft drifted to the right of centerline on a fairly constant arc until contacting a snow berm at a taxiway intersection. An…NTSB LAX85LA039Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Sanger, CAUpon touchdown, the left main landing gear contacted a pothole in the rwy aprx 175 ft from the threshold. Skid marks from the left main tire were seen on the rwy beginning at that point along with metal scrappings from the gear. Shortly thereafter, skid marks…NTSB CHI85LA030Accident · No injuriesLimited investigationFinal reportMoore Quicksilver MX II · Aurora, ILPlt landed in open field to tighten his scarf, which had become loose and posed a possible hazard. A second ultralight landed to see of the plt had problems, then departed toward the east, successfuly negotiating a 10 kt x-wind. Plt elected to takeoff in same…NTSB ATL85LA018Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Tunica, MSThe pilot attempted takeoff from an agricultural site which had soft spots from wet conditions. Directional control was lost when one main wheel encountered a soft spot. The aircraft veered into a plowed field and flipped inverted.NTSB LAX84LA500Accident · No injuriesLimited investigationFinal reportPiper PA-60 · San Diego, CAThe takeoff rwy had arresting gear installed 1,900 ft from the threshold. In an effort to avoid rolling over the arresting gear cable during the takeoff roll the plt elected to utilize the overrun area for the initiation of the roll. As the acft taxied from…NTSB CHI84LA407Accident · No injuriesLimited investigationFinal reportCessna 150M · Clio, MIThe airport consists of three sod strips none of which contains rwy lights. The CFI and student departed the arpt for a local night flight. The CFI stated that upon returning to the arpt he called the arpt office on the UNICOM freq and requested the night…NTSB MIA84LA260Accident · No injuriesLimited investigationFinal reportCessna C-152 · Little S.Simons, GAThe acft struck a washed-out area during a beach landing at night and was destroyed when it flipped over into the ocean. Investigation revealed that the plt was bringing a mechanic/plt to this part of the beach in an effort to repair another acft that had…NTSB DEN84FA294Accident · 1 fatalField investigationFinal reportCessna A185F · Fort Peck, MTPlt attempted to takeoff from a calm part of reservoir. The wave heights were estimated to be 4 to 6 feet. The arft struck several waves during the takeoff run. The rt wing tip dragged in the water causing the acft to nose over. The acft came to rest…NTSB MIA84LA255Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Rockledge, FLThe acft collided with a mound of dirt while executing a go-around at a private airstrip. The plt stated he selected rwy 27 based on winds reported at another airport and when the acft touched down about mid-point of the strip, 'I retracted flaps and applied…NTSB ANC84LA170Accident · No injuriesLimited investigationFinal reportCessna A185F-II · Iliamna, AKThe float plane plt began taking off from a small lake in calm wind & glassy water conditions. Realizing the situation was marginal, he reduced power to abort (before lifting off) & began a step turn to the left. The plt reported that the radius of the turn…NTSB NYC84LA284Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Fishers Island, NYThe certified flt instructor (CFI) stated that he was teaching his student autorotation's to touchdown. He continued to state that his student applied too much left pedal just prior to touchdown. This caused the helicopter to yaw to the left. The CFI stated…NTSB MKC84LA253Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Plains, KSThe acft collided with a tall crop during an attempted takeoff from a dirt road. The acft had failed to become airborne on another road after about 2600 ft of run and the attempt was aborted. This takeoff run was about 2800 ft according to the plt. The plt…NTSB ANC84LA129Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Hope, AKThe acft collided with a ditch alongside a short strip used by hunters and fishermen. During interviews with the plt it was revealed that the acft was overloaded and out of CG. During the takeoff the plt decided to abort after passing his decision point but…NTSB FTW84LA334Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Woodworth, LAThe plt approached an unfamiliar area at less than 500 ft AGL and landed on an abandoned drag race strip about 3 miles from the dest airp. Directional control was lost very shortly after touchdown when the acft collided with dirt piles on the surface of the…NTSB ATL84LA239Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · So.Charleston, WVThe plt stated that after touching down, he was unable to stop the acft before running off the end of the paved rwy. He elected to go around, but finally decided to make a full stop. A witness reported that the acft bounced 3 times during the level-off before…NTSB NYC84LA256Accident · Minor injuriesLimited investigationFinal reportPiper PA-28RT-201 · Smyrna, DEAcft contacted a ditch and nosed over during a precautionary landing after plt noticed engine was running rough. Cause of engine roughness could not be determined through inspection of the engine.NTSB DEN84LA230Accident · No injuriesLimited investigationFinal reportSikorsky S-55B · Richey, MTThe pilot stated that he landed in a pasture where he intended to refuel. During the landing roll, one of the wheels dropped into a hole, causing the main rotor blade to flex downward and severe the tailboom.NTSB LAX84LA427Accident · No injuriesLimited investigationFinal reportCessna TU206C · Catalina, AZThe acft ran into ruts washed out by recent rains on a private arpt. The plt reported that he circled the arpt to look for hazards. He concluded that it was ok to land. After the accident he said that he should have called the arpt operator prior to flying…