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 DEN89LA133Accident · No injuriesLimited investigationFinal reportCessna 182RG · Englewood, COFailure of the pilot to follow warnings provided by a NOTAM & flags on the taxiway. Factors related to the accident were: darkness and the ditch.NTSB CHI89LA091Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Ojibwa, WIImproper planning/decision by the pilot and his delay in aborting the takeoff. Contributing factors were: the wet/upward sloping condition of the airstrip, unfavorable wind, high obstructions (tall trees/obstacles at the end of the runway), and high…NTSB SEA89LA079Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lacey, WAFailure of the pilot to maintain proper alignment during landing.NTSB ATL89LA138Accident · No injuriesLimited investigationFinal reportCessna 150 · New Bern, NCThe pilot's improper in-flight planning/decision and a delayed go-around. Turbulence, wet terrain, and a ditch were contributing factors.NTSB CHI89DEC04Accident · Minor injuriesFinal reportBridges LONG-EZ · Rochester Hills, MIThe pilot's decision to takeoff from unsuitable terrain which resulted in damage to the propeller and nose gear.NTSB MIA89LA116Accident · Minor injuriesLimited investigationFinal reportBeech B55 · Sarasota, FLUneven runway condition (sunken spot).NTSB ANC89LA064Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Beluga Mountain, AKPilot's selection of unsuitable terrain for an off-airport landing and takeoff. The uneven terrain (with a snow berm) was a related factor.NTSB ANC89LA051Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Kasigluk, AKThe pilot's inadequate visual lookout which resulted in the collision with a snowbank.NTSB ANC89LA050Accident · No injuriesLimited investigationFinal reportCessna 185 · Shell Lake, AKThe pilot's improper inflight decision in selecting unsuitable terrain on which to land. Contributing to the accident was the rough/uneven terrain and the snowbank.NTSB LAX89LA105Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Flagstaff, AZThe pilot's failure to maintain proper runway alignment while expediting to exit the runway. His lack of experience in this type of aircraft, self-induced pressure & the snow covered terrain were contributing factors.NTSB DEN89LA066Accident · No injuriesLimited investigationFinal reportCessna 172RG · Larimore, NDInadequate supervision by the flight instructor. Factors related to the accident were: failure of the student pilot to attain a proper touchdown point, his delay in configuring the aircraft & executing the go-around, icy/snowy runway conditions, and the…NTSB DEN89LA065Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Medicine Lake, MTSelection of unsuitable terrain by the pilot, resulting in a collision with snowdrifts during landing ground run.NTSB DEN89LA059Accident · No injuriesLimited investigationFinal reportBell 206B III · Park City, UTThe selection of an unsuitable landing site by the pilot, resulting in tail rotor contact with the terrain and shearing of the tail rotor driveshaft.NTSB DEN89LA055Accident · No injuriesLimited investigationFinal reportCessna 172 · Longmont, COFailure of the student pilot to maintain proper runway alignment during the landing roll. Factors related to the accident were: snow on the edges of the runway, the student's lack of total experience, and the snowbank.NTSB ANC89LA026Accident · No injuriesLimited investigationFinal reportCessna 185 · Porcupine Lodge, AKThe aircraft was taxiing for takeoff on the frozen Porcupine river in rural Alaska when the right main landing gear broke through the river ice, allowing the right wing to strike the ice. The pilot stated that he had landed on the river near the Porcupine…NTSB SEA89LA025Accident · No injuriesLimited investigationFinal reportCessna 177RG · Monroe, WAPlt was lndg on unlit strip (center reflectors) at night and allowed acft to drift left on lndg roll. Acft contacted dirt mound adjacent to runway.NTSB LAX89DVG02Accident · Minor injuriesFinal reportKnowles Thorp T-18 · Lincoln, CAThe pilot stated that he was practicing takeoffs and landings on a local flight. During one of those landings he indicated that the right wheel locked up and caused the aircraft to veer to the right. He stated that he subsequently lost control of the aircraft…NTSB ATL89LA046Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Hamilton, OHThe pilot lost directional control while practicing crosswind landings. The winds were reported at 10 with gusts to 15 knots. The pilot did not report having an airplane system problem.NTSB CHI89LA017Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Mora, MNNTSB MIA89LA014Accident · No injuriesLimited investigationFinal reportCessna 182A · La Belle, FLDuring soft field takeoff from a rough strip the acft collided with a hole causing the nose wheel to drop onto the runway hard. The nose wheel separated and the acft veered to the right and collided with a drainage ditch. .NTSB BFO89LA002Accident · No injuriesLimited investigationFinal reportPitts S-1S · Ridgeway, VAThe pilot landed to the south on the private airstrip. In an attempt to make a left 180 deg turn to back taxi on the runway and avoid acft parked along the left side of the runway, the pilot steered his airplane to the right. While turning to the right, the…NTSB CHI88LA242Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Akron, OHOn taxiing in from landing on a dark night, the pilot inadvertently taxied off the pavement onto a grassy area. When he realized that he was off the pavement he made an attempt to return to the pavement and encountered a 20' hole. The main gear sank into the…NTSB NYC88LA242Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA-5B · Roscoe, NYThe plt said the eng lost power during takeoff past mid-field and he initiated an abort. The acft was unable to stop in the remaining rwy and collided with a dirt embankment past the end of the rwy. The owner of the acft is a student plt and was the passenger…NTSB SEA88LA185Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Coeur D'Alene, IDWhen pax became ill, plt elected to land in a pasture. Gear contacted dirt mound hidden by tall grass, separating gear.NTSB ANC88LA132Accident · No injuriesLimited investigationFinal reportMaule M-5-235 · Fairbanks, AKThe commercial pilot had dropped two hunters off at their campsite, and was taxiing for takeoff on an unlighted gravel bar at dusk. He misjudged the end of the gravel bar in the fading light and taxied off a four foot embankment.NTSB FTW88DPA06Accident · No injuriesFinal reportCessna 150K · Whitney, TXThe student pilot decided to make a touch and go landing before flying to another airport. The airplane touched down more than 1000 feet down the 2000 foot runway, went off the end and 300 feet beyond the end before hitting a dirt bank and nosing over to the…NTSB CHI88DEM10Accident · No injuriesFinal reportGrumman G-164B · Schoolcraft, MIThe pilot failed to maintain directional control while maneuvering the aircraft to avoid an obstacle during the landing roll. The aircraft's right wing impacted a corn crop and the aircraft swerved/ground looped to the right and skidded to a stop, nose down.…NTSB LAX88LA286Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-135 · Parker, AZThe pilot reported that just after tkof from a river the eng was not developing sufficient power to maintain altitude. The pilot made a landing and during the landing roll collided with rough terrain. After the accident, the engine was test run and found to…NTSB LAX88DVG09Accident · No injuriesFinal reportSchweizer G-164B · Robbins, CADuring landing roll, after an aerial application flight, the sprayboom became entangled in weeds. The airplane ground looped and nosed over. There were no reported mechanical failures or malfunctions of the airplane at the time of the accident.NTSB FTW88LA140Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R · Oklahoma City, OKThe air taxi airplane, hauling cargo, was attempting a takeoff and ran off the end of the runway and ended up in a ditch. The pilot said the engine had failed. A check on the wreckage revealed the engine had the wrong type of spark plugs, one magneto was…NTSB DEN88LA154Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Cody, WYDuring landing on a ranch road while on a business flight the plt struck a pile of gravel placed on the road to facilitate road repairs. The aircraft flipped over and caused substantial damage to the vertical stabilizer, horizontal stabilizer, propeller and…NTSB SEA88LA136Accident · No injuriesLimited investigationFinal reportCessna 210 · Baker, NVThe pilot stated he landed long on unattended grass strip due to gusty wing conds. The aircraft encountered a ditch or vehicle track hidden by vegetation, shearing nose gear and collapsing left main.NTSB LAX88DVG06Accident · No injuriesFinal reportCessna 188 · Upper Lake, CAThe acdt occurred drg an aerial app flt. The pilot reported that he had flown 6 or 7 flights earlier in the day. Each flight the load was reduced due to the increasing temperature of the day. Just prior to the accident, the pilot reported that the takeoff…NTSB CHI88LA136Accident · Minor injuriesLimited investigationFinal reportde Havilland DHC2-MK I · Warroad, MNThe pilot decided to land in the lake approximately 1000 yds from the sea plane base and was attempting a step-taxi back to the base when the acft struck a sand bar. The pilot stated that he was taxiing near tall grass where he thought the water was deep…NTSB BFO88LA056Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Reedville, VAAfter back-taxiing on the pvt airstrip, the plt made a 180 deg turn to line up for takeoff. During the turn the right main gear contacted a ditch in a tall grass area off the end of the rwy. The plt applied power to prevent the acft from becoming stuck in the…NTSB ANC88LA091Accident · No injuriesLimited investigationFinal reportGrumman AA-1B · Nikolai Creek, AKA pilot reported that he was attempting to taxi off the dirt road that he had just used as a landing site in a rural area of Alaska, when the airplane's left main landing gear wheel became mired in a soft spot. The aircraft veered off the road into a ditch.NTSB ANC88LA061Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Port Heiden, AKThe pilot elected to abort the takeoff of a heavily loaded Piper from a soft strip. His decision was tardy and the airplane struck a cinder bank.NTSB ANC88LA044Accident · No injuriesLimited investigationFinal reportAeronca 7DC · Talkeetna, AKThe pilot stated that during the takeoff run on the frozen field the aircraft struck a snow berm causing the aircraft to ground loop.NTSB LAX88LA156Accident · Serious injuriesLimited investigationFinal reportEiriavion PIK 20D · Saint Helena, CAThe flight departed vacaville gliderport on an aero tow. The plt intended to fly to calistoga, CA and return. After passing st. Helena, CA, the thermal activity began to decrease. The plt executed a 180 deg turn to return to vacaville. When the flt was over…NTSB FTW88DRA08Accident · No injuriesFinal reportGrumman G-164 · Palacios, TXThe plt stated that following a normal landing, he applied too much brake, causing the wheels to lock up. This, in turn, caused dead grass and mud to accumulate in front of the wheels. The acft subsequently flipped over and slid to a stop inverted.NTSB ANC88LA035Accident · No injuriesLimited investigationFinal reportCessna 152 · Chugiak, AKThe flight instructor was giving dual instruction to a student pilot on night landings. On the sixth touch-and-go landing, the instructor turned the landing light off for a no-light landing. The student landed the aircraft to the right of centerline, and…NTSB CHI88LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Lansing, MIWhile taxiing for takeoff the aircraft experienced a nose over when it contacted a snowbank. The instructor stated that she allowed the student pilot to taxi too fast and was unable to take control of the aircraft soon enough to avoid hitting the snowbank.NTSB MKC88LA049Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Burlington, IAWhile taxiing out on a snow covered taxiway, during an air taxi operation, the aircraft struck an unmarked, unlighted, snow covered drainage hole, with the left landing gear. Substantial damage occurred to the left engine nacelle, the left wing spar, and the…NTSB SEA88LA037Accident · No injuriesLimited investigationFinal reportCessna 172P · Vashon Island, WADuring landing roll the pilot made an intentional groundloop to avoid trees at the end of the short, wet, S0D runway. The pilot reported that the use of brakes was ineffective. He stated that he made the landing using 30 degs of flaps at an airspeed of 60…NTSB DEN88LA019Accident · No injuriesLimited investigationFinal reportCessna 152 · Greeley, COThe recently certificated private plt was taxiing his acft to rwy 9 for a night takeoff. Another acft began its takeoff roll on rwy 9. As a courtesy, the taxiing plt switched off his taxi light so as not to blind the other plt. The taxiing plt used the glow…NTSB FTW88LA010Accident · No injuriesLimited investigationFinal reportCessna 150L · Lancaster, TXWhile rtrng fm a x-country, the student bcm disoriented & reqd assistance. Redbird twr ctlr adzd dallas-ft worth TRACON that the plt was lost & needed a beacon identification. A few min later, the acft's location was determined & the ctlr at redbird relayed a…NTSB MIA88LA015Accident · No injuriesLimited investigationFinal reportCessna 310P · Bay St. Louis, MSAccording to the plt, the acft was being taxied to takeoff when it struck a drainage ditch at approximately 65 mph, collapsing the landing gear, damaging both wings, both engines, props & the fuselage structure. After this accident the acft was seized by U.S.…NTSB DEN88LA007Accident · Serious injuriesLimited investigationFinal reportAerostar S-66A · Albuquerque, NMUpon landing, the balloon touched down on a gravel road and bounced over a small depression. The basket struck a small mound and threw three of the six passengers against the rail of the basket. The other passengers fell against them and the three were…NTSB MKC87LA176Accident · Minor injuriesLimited investigationFinal reportEllsworth Varieze · Lebanon, MOThe PIC was back-taxiing down rwy 18 with a planned dept to the north. The PIC stated that he applied brakes in order to modify his direction during the taxi, but the brake failed to compensate. The PIC further stated that he applied more pwr in an attempt to…NTSB ANC87LA164Accident · No injuriesLimited investigationFinal reportInterstate S-1B2 · Beluga River, AKThe pilot landed on a small lake, decided it was too small and attempted to take off. He was unable to attain lift off speed prior to striking the opposite bank with his floats and subsequently damageing the airplane.