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 BFO87FA065Accident · No injuriesField investigationFinal reportBeech 58 · Baltimore, MDDuel alternator failure occurred abt 13 min aft dept. The acft returned and lndd uneventfully. However, while taxiing back to the maint hgr the plt failed to follow the marked taxiway and collided with a ditch. Construction was taking place on the arpt and…NTSB ANC87LA141Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Talkeetna, AKThe pilot attempted to take off from an unimproved site while the inside of the airplane's windows were partially obscured with condensation. The airplane struck a rock with its main gear during the take off roll and became prematurely airborne. The pilot…NTSB DEN87LA228Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Grassy Butte, NDN2413C, a Cessna 180, was landing in teddy roosevelt national park where the plt and his passengers intended to hunt deer. A flat, Grassy area on a ridge was selected for landing. The area was checked and marked off by friends of the plt before the landing…NTSB ANC87FA118Accident · No injuriesField investigationFinal reportDe Havilland DHC-2 MK-1 · Elmendorf Afb, AKThe instructor (CFI) elected to demonstrate a no-flap takeoff with calm/glassy water conds. After the float plane had accelerated to about 55 to 60 KTS without becoming airborne, he elected to abort the takeoff. He stated that he attempted a left turn & the…NTSB ATL87DEK01Accident · No injuriesFinal reportSmith, Ted Aerostar Aerostar 600 · Columbus, OHThe pilot taxied off an unlighted taxiway into a large drainage ditch while taxiing to a parking ramp. The pilot thought he was on the taxiway but the right landing gear was on a portion of the drainage ditch retaining wall. The rt landing gear collapsed. The…NTSB MKC87LA135Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Waldron, ARThe plt said he was on a x-country for his commerical cert. He checked enroute wx for the return trip and was told VMC prevailed. However he rptd that he encountered haze & clouds. He let down to VMC but after he got in the clear all he could see was…NTSB DEN87LA183Accident · No injuriesLimited investigationFinal reportCessna T188C · Winnett, MTDuring landing on a roadway used by the crop-duster for re-loading chemicals for spraying, the left spray boom contacted vegetation and slewed the acft sideways. The right wing was bent and the propeller was damaged.NTSB BFO87LA045Accident · No injuriesLimited investigationFinal reportBeech A23-19 · Cambridge, MDWhen the aircraft failed to start the pilot set the throttle, insured the aircraft was tied down and attempted to start the aircraft by hand propping. The aircraft started immediately, broke both tie-down ropes, traveled across the field into a ditch and…NTSB FTW87LA158Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Galveston, TXThe plt had lndd on an abandoned airstrip & was attempting to takeoff again. He stated that due to birds on the rwy, he deviated to the left to avoid a bird strike. Subsequently, the landing gear collided with a chunk of raised concrete which was hidden by…NTSB ANC87LA083Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Alexander River, AKThe pilot stated that during the takeoff run the left float contacted a hidden sand bar. The aircraft then nosed over on its back.NTSB CHI87IA163Incident · No injuriesIncident investigationFinal reportBoeing 757-251 · Detroit, MIA northwest airlines Boeing 757, operating as flight 336, scraped the tail cone area of the fuselage on the runway when the pilot failed to maintain sufficient ground clearance during rotation and takeoff from Detroit, Michigan. The Boeing 757 flight…NTSB ANC87LA081Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Theodore River, AKThe plt stated that during the takeoff roll the acft's left main gear struck a culvert in the road. The acft became airborne prior to reaching rotation speed. The plt reduced power to abort the takeoff. The nose wheel struck a stump on the road and the acft…NTSB ANC87DAG03Accident · No injuriesFinal reportDenney FOX 1 · Palmer, AKThe pilot stated that after touchdown on the sand bar the aircraft struck an open ditch. The pilot lost directional control of the aircraft causing the plane to nose over on its back.NTSB SEA87LA116Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Odessa, WADuring landing roll on a dirt road, the aircraft drifted to the side, encountered the shoulder ditch and flipped over.NTSB ANC87LA078Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · King Salmon, AKThe pilot stated that he started his takeoff run in the middle of the lake. The aircraft overran the lake and ended up on the tundra approximately 75 yards from the lake shore.NTSB LAX87LA228Accident · No injuriesLimited investigationFinal reportCessna 120 · Fresno, CAA Cessna 120 landed left of the runway on a rough dirt area and nosed over. The pilot indicated that the airport is not lighted. The runway is equipped with white reflectors and the taxiways are equipped with amber reflectors. The pilot stated he was unable…NTSB MKC87LA118Accident · No injuriesLimited investigationFinal reportCessna 188C · Dalton, NEThe PIC attempted to depart a rural farm ldg strip during an aerial application operation. The acft left spray boom struck tall standing wheat prior to lift off speed causing loss of control and subsequent ground loop and nose over.NTSB MIA87LA163Accident · No injuriesLimited investigationFinal reportPiper PA-28-180D · Astatula, FLThe plt became disoriented and performed a precautionary landing. During the landing roll, the pilot taxied into a ditchand the nose gear collapsed.NTSB SEA87LA097Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Yakutat, AKWhile taxiing, after landing on a murky river, the pilot did not see a sand bar. The aircraft struck the sand bar and the aircraft then nosed over inverted. The plt did not file an acc rpt and held a canadian pilot certificate.NTSB MKC87LA111Accident · No injuriesLimited investigationFinal reportCessna 150H · Miami, MOThe pilot had completed the landing at a private airport and was taxiing at the edge of the gravel runway. He hit a clump of grass and dirt and partially collapsed the nose gear.NTSB ANC87LA068Accident · No injuriesLimited investigationFinal reportCessna 305 · Port Heiden, AKThe pilot attempted a landing on the beach. After the landing roll the aircraft struck a sand bar causing the aircraft to nose over on its back.NTSB SEA87LA161Accident · No injuriesLimited investigationFinal reportGrumman AA1B · Ocean Shores, WAThe plt landed his acft onto a golf course which had been the previous site for the airport. The airport had been closed since December 1985 and relocated close by. The pavement at the old airport had been replaced by sod. During landing roll, the aircraft…NTSB NYC87LA141Accident · No injuriesLimited investigationFinal reportCessna 172K · Palmyra, PAStudent pilot experienced up and downdrafts while on approach for landing at reigle airport. The pilot was unable to maintain directional control during roll out, ran off the left side of the runway, and across a grass field. The acft then nosed over when the…NTSB SEA87LA078Accident · No injuriesLimited investigationFinal reportCessna 185 · Burnett Inlet, AKThe plt left the landing gear in the down position after takeoff. During the water landing, with the gear in the down position, the acft nosed over.NTSB ATL87LA112Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Ravenna, OHThe student plt was making a touch and go ldg on rwy 27. After touchdown, he retracted the flaps and applied full power to takeoff again. The acft began to veer left after power was applied. The CFI reported that she told the student to apply right rudder as…NTSB CHI87DEE07Accident · No injuriesFinal reportCessna 172 · Lansing, ILThe pilot stated that due to an RPM fluctuation he had diverted to an alternate arpt. He attempted to land on rwy 27 when the wind was from 020 degrees 14 KTS gusting 30 knots. The flap operation was also erratic according to the plt. The acft ran off the…NTSB ATL87LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Lebanon, TNThe plt reported that he made a VFR pattern for landing on rwy 18 at his destination. The wind was 'hard' and 'straight down the rwy.' He reported that, 'all of a sudden it seemed as though the wind quit and the airplane started to fall.' The acft hit hard…NTSB FTW87LA084Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Many, LAAcft received substantial damage when it ran off the end of a 3,300' pvt airstrip into a lake during an attempted go around. The winds were calm. The plt reported that he landed long and fast over trees at the threshold and delayed initiating a go around…NTSB ATL87LA099Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Shelbyville, TNThe acft was being operated from a dirt road that was reportedly only slightly wider than the acft. The plt reported that he had just completed a spraying operation and was about to put out some fertilizer. He stated that he installed the spreader, but left…NTSB ANC87LA054Accident · No injuriesLimited investigationFinal reportCessna 170B · Dillingham, AKAs the plt was taking off from a frozen lake with a ski equipped acft, it collided with a snowbank & was damaged. The plt rprtd that he had just landed a few minutes earlier & that the wind was blowing differently when he took off again. After the acdnt,…NTSB NYC87LA100Accident · No injuriesLimited investigationFinal reportCessna 172 · Cross Keys, NJThe plt rprtd that drg the lndg roll, he glanced down at the airspeed indcr, & at the same time, must have relaxed control of the acft. At about that time, the acft drifted to the left side of the rwy, the left main gear struck a snowbank & the acft nosed…NTSB CHI87LA084Accident · No injuriesLimited investigationFinal reportCessna 172 · Charlevoix, MIUpon landing the nose wheel buckled after striking a snowbank and the aircraft flipped over. Pilot reported there was a problem with the nose wheel although inspection of the nose wheel after the accident did not reveal any malfunction.NTSB NYC87LA070Accident · No injuriesLimited investigationFinal reportCessna 172N · Duanesburg, NYOn lndg the acft ran into a snowbank causing minor dmg to the acft. Aft determining it airworthy the plt elected to depart and ran into another snowbank on the takeoff. He stated that the accd occurred because of poor judgement to attempt a takeoff from an…NTSB CHI87LA077Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Bridgman, MIPlt was attempting to takeoff from a soft field. The gear caught a rise in the field and acft settled back to the soft ground tearing off the nose wheel and damaging both wings.NTSB FTW87LA062Accident · No injuriesLimited investigationFinal reportCessna 210 · Bonham, TXAccording to the pilot, the aircraft made a normal landing, but was substantially damaged when the aircraft contacted a ditch cut across the airstrip, causing the aircraft to nose over inverted.NTSB NYC87LA071Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Rockaway, NJStudent pilot experienced a rough running engine during cruise flight and decided to make a precautionary landing on a frozen reservior. During landing roll out, the aircraft hit a slushy spot on the ice and nosed over causing substantial damage.NTSB CHI87LA071Accident · No injuriesLimited investigationFinal reportCessna 152II · West Middleton, INDuring the landing roll the left main gear struck a snowbank. The nose wheel then got caught in snow and the acft tipped up on the prop and left wing.NTSB CHI87LA066Accident · No injuriesLimited investigationFinal reportCessna 152 · Lincoln, ILAccording to the plt, after landing on rwy 03 at logan county airport, the acft encountered ice on the rwy and the left main gear struck snow that had drifted onto the rwy. The plt stated that the acft then collided with a snowbank and flipped over. The acft…NTSB SEA87LA044Accident · No injuriesLimited investigationFinal reportde Havilland Beaver DHC-2 · Shoal Cove, AKThe DHC-2 air taxi acft had landed at Shoal Cove, AK and was step taxiing to th float plane dock. During the taxi the acfts left wing contacted a wire cable attached to an 'a' frame across the path of the acft. The cable had been put up the day before and was…NTSB MIA87FA066Accident · No injuriesField investigationFinal reportCessna 310-D · Lantana, FLThe pilot flying in marginal weather requested radar assistance in landing at his destination. He was given a radar vector to a position on downwind and saw an uncontrolled airport under him. He landed on a closed runway that was marked closed due to…NTSB DEN87LA030Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Opheim, MTThe plt elected to take off downhill because he said the hill was too steep to try a takeoff uphill even into the wind. He said that just prior to lift off, he hit a snowbank which slowed the acft down. Deeper snow was then contacted and the acft flipped over.NTSB DEN87LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Englewood, CODuring landing, directional control was not maintained. The acft veered left, the landing gear entered a snowbank, and the acft nosed over.NTSB CHI87LA036Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Gaylord, MIThe plt landed on a closed rwy and the acft collided with a snowbank. A NOTAM had been issued three days prior, closing the rwy, however, the plt stated that he had not checked notoms prior to departing traverse city. A plt of another acft, who reported being…NTSB CHI87LA025Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Detroit, MIUpon landing at Detroit metropolitan airport, the pilot stated that he was instructed by the tower to make a right turn on runway 3C or taxiway j, and taxi to butler aviation. The pilot then turned onto what he thought was taxiway j, but was actually a paved…NTSB MKC87LA014Accident · No injuriesLimited investigationFinal reportCessna 170B · Hyannis, NEThe pilot stated that he was servicing customers while on this business trip. On his next call, the pilot further stated, he was to land in a hay field that he had previously used but, due to water in the area, he elected to land on higher grounds. Upon…NTSB NYC87FA006Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Holyoke, MAThe aircraft was attempting to make a special visual flight rules arrival when it crashed into a rock face slope 2 miles east of the airport while on a easterly heading. The accident occurred over 1 hour after sunset. The pilot did not have an instrument…NTSB MKC86LA194Accident · No injuriesLimited investigationFinal reportCessna 172M · Arkansas City, KSThe plt was landing on his private sod strip which had tall grass along the edges. During the landing roll, he attempted to pick up some papers that had fallen on the cockpit floor. When he looked back up, the acft had drifted to the left. The left wing…NTSB DEN86LA255Accident · No injuriesLimited investigationFinal reportBeech B58 · Fargo, NDThe pilot stated that during the landing roll he inadertently retracted the landing gear along with the flaps.NTSB LAX86LA352Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Likely, CAThe airplane departed san jose airport (sjc), san jose, CA on a business flight in an area near Likely, CA. The pilot intentionally landed on an open dirt area to obtain a soil sample. During the landing roll-out the airplane's left main gear separated after…NTSB ATL86LA244Accident · No injuriesLimited investigationFinal reportCessna A188B · Screven, GAThe plt was making a landing on an unpaved road near the aerial application site. He reported that the spray boom contacted peanut vines causing the acft to ground loop. The plt stated that he 'might have had a small bank to the right' at the time. The wind…