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 DEN84LA206Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Wyndmere, NDSod was worn from the middle of the strip & the strip was wet. Therefore, the plt elected to use the left side of the sod strip for takeoff. During the takeoff roll, the left spray boom dragged into wheat that was growing beside the rwy & the acft veered…NTSB CHI84LA309Accident · No injuriesLimited investigationFinal reportGlasflugel Libelle · Osseo, MIThe plt stated that the thermals dissipated & he had to make an off arpt landing. The landing was made in a field of tall grass & the left wing contacted the grass first resulting in a 90 deg ground loop. The aft fuselage section separated.NTSB SEA84LA152Accident · No injuriesLimited investigationFinal reportCessna T188C · Pasco, WAWhile taxiing to takeoff, the right main gear got into soft terrain off the right edge to the rwy. This pulled the acft to the right & the right wing struck an embankment. The right main gear collapsed & the right wing was buckled.NTSB MKC84LA171Accident · No injuriesLimited investigationFinal reportCessna 150J · El Dorado, ARThe acft collided with a ditch while taxiing after landing. The plt was attempting to make a 180 degree turn on the rwy. She said she turned right to allow more room to swing left. She said that she was then unable to depress the left rudderpedal. The acft…NTSB NYC84LA199Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Rehoboth Beach, DEBased on erroneous information PIC assumed road construction was work to pave grass strip. He landed on a road being constructed in a housing expansion area. During landing roll the left main gear broke off after contacting a dirt mound.NTSB ANC84LA083Accident · No injuriesLimited investigationFinal reportCessna 185F · Anchorage, AKWhile landing his float equipped acft, the plt noticed that another acft that had landed before him had not cleared the landing area. He attempted a sharp left turn around the other acft & the acft hit a beach & flipped over.NTSB DEN84LA169Accident · No injuriesLimited investigationFinal reportCessna 182P · Junction, UTThe pilot inadvertently landed on a closed section of highway which he mistook for a dirt runway. The highway surface was narrow and contained broken chunks of asphalt. During the landing roll, the left main gear contacted a 1 ft x 1 ft rock. The acft then…NTSB SEA84LA122Accident · No injuriesLimited investigationFinal reportCessna 188B · Perrydale, ORThe plt stated that while taking off from the 1,100 ft rough strip, the acft struck a bump causing it to become airborneprematurely. The acft then settled back onto tall wheat past the end of the strip & flipped inverted.NTSB NYC84LA188Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS-4A · Pepperell, MAThe glider was attempting a tow-launch when the right wing tip struck a clump of high grass. The glider yawed right and collided with the asphalt rwy, breaking the fuselage and collapsing the landing gear. The pilot stated that the grass was too high for a…NTSB LAX84LA297Accident · No injuriesLimited investigationFinal reportLet L-13 · El Mirage, AZThe glider plt reported that after a release from the tow line, he had difficulty finding lift. He concentrated on finding lift so much that he became disoriented with respect to the rwy. When he elected to return to the arpt, he inadvertently selected a…NTSB ANC84LA062Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Ester, AKThe plt maded an off-arpt landing on a frozen river with an 'overflow.' During the rollout, the acft hit a 12 inch deep pocket of slush & nosed over.NTSB ATL84LA154Accident · No injuriesLimited investigationFinal reportCessna 182P · Louisa, VAThe plt reported that the grass & ridges on the strip held the acft's speed down more than expected during the takeoff roll, so the plt decided to abort. The plt later stated that he could have made it safely, but his 'instinct' was stronger so he decided to…NTSB FTW84LA211Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Roundup, TXThe plt stated after the accident that during the takeoff run the acft would not accelerate beyond 60 KTS. The plt aborted the takeoff and steered the acft into tall grass off the left side of the rwy in an effort to slow the acft at a faster rate. During the…NTSB ANC84LA058Accident · No injuriesLimited investigationFinal reportFairchild C-119 · Venetie, AKThe plt was attempting a takeoff on an airstrip where braking action was considered good during the normal summer season. It was about 3000 ft in elevation & was snow covered most of the year, as on the day of the accident. The strip accomodated takeoffs to…NTSB LAX84LA244Accident · No injuriesLimited investigationFinal reportCessna 320 · Long Beach, CAWhile taxing to the active rwy, the plt was aware of several holes in the taxiway. He made a turn to the left & entered a dirt area to assure that the acft would not enter the taxiway holes. However, in the dirt area, the nosewheel sunk into a water covered…NTSB CHI84LA139Accident · No injuriesLimited investigationFinal reportCessna 150M · White Cottage, OHThe student plt became lost during his first solo x-country. He stated that he noticed that the fuel tanks were near empty so he decided to make a precautionary landing. The acft landed in a rough field & struck a plowed furrow. The plt's CFI stated that…NTSB CHI84LA137Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar 600 · Detroit, MIThe taxiway collapsed under the acft as the plt prepared for takeoff. The asphalt surface gave way due to sub-surface erosion and a four ft hole resulted. The acfts left main gear was sheared off.NTSB ATL84LA127Accident · No injuriesLimited investigationFinal reportCessna 172 · Parchman, MSThe plt reported that during the visual approach to runway 27, he misaligned the acft with the unlighted runway and touched down left of the landing area. The acft collided with a ditch and nosed over.NTSB CHI84LA129Accident · No injuriesLimited investigationFinal reportCessna 150M · Hagerstown, INDuring the rollout after a normal landing the acft collided with a snowdrift on the sod rwy. The collision collapsed theacft nose gear and damaged the propeller and firewall of the acft.NTSB MKC84LA086Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Jefferson City, MOThe acft drifted left due to a crosswind during landing. The drift put the acft into snow which had been plowed along the rwy side. The collision pulled the acft off the rwy.NTSB FTW84LA149Accident · No injuriesLimited investigationFinal reportCessna 150M · Boy'S Ranch, TXThe student plt was attempting to land on a freshly graded road. Shortly after touchdown the nose wheel hit a large rock and sheared off.NTSB SEA84LA053Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Burns, OROn departure the pilot heard a thumping noise from the undercarriage and the landing gear position lights went out. He executed a visual return and approach to a precautionary landing. During the landing roll, the left main gear collapsed.NTSB NYC84LA080Accident · No injuriesLimited investigationFinal reportCessna 172RG · Marietta, PAThe acft struck a snowbank during a night landing. The CFI stated everything was normal until flareout when the acft began to settle. After striking the snowbank the acft nosed over.NTSB CHI84LA085Accident · No injuriesLimited investigationFinal reportCessna 140 · Huntley, ILThe student plt allowed the acft to drift left during takeoff in spite of verbal instructions by the CFI to correct the situation. The acft continued toward a snowbank and the CFI did not take corrective action on the controls in time to avoid a collision…NTSB SEA84LA038Accident · No injuriesLimited investigationFinal reportPiper PA28R-200 · Newport, ORThe acft collided with a ditch during landing. The construction ditch ran across the rwy. The rwy had been notamed as out of service except for the last 2000 ft. the plt stated that the 3 white barriers marking the position of the construction ditch had blown…NTSB CHI84LA074Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Sauk Rapids, MNThe plt stated that while landing on a snow covered field one of the landing skis broke when it struck a dirt mound below the snow. The acft cartwheeled and flipped over.NTSB DEN84LA056Accident · No injuriesLimited investigationFinal reportCessna 180 · Florissant, COThe acft collided with a snowbank during landing. The rwy had only been plowed to a width of about 16 ft according to the plt. This was a privately owned strip and the plt/owner said he instructed his maintenance man/ranch mgr to plow therwy to minimum width.…NTSB LAX84LA426Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · San Carlos, AZDuring a night landing on a road, the acft was damaged when it hit a berm. According to customs officials. The plt had circled while ground personnel placed rows of lights adjacent to the road, then he landed. There was evidence that illegal drugs had been…NTSB MKC84LA032Accident · No injuriesLimited investigationFinal reportCessna 152 · David City, NEThe instructor plt (CFI) & his student departed on a round robin x-country flt & had planned to make a soft field landing at David City, NE. During arrival at David City, they made a visual check of the rwy because they were unable to contact the arpt UNICOM.…NTSB DEN84LA053Accident · No injuriesLimited investigationFinal reportPiper PA-18A 150 · Herreid, SDThe acft ran into a creek bed during an off arpt landing and the landing gear collapsed. The plt was conducting an aerial hunt of coyotes. After shooting one he sought a place to land to pick up the carcass and stated that although he inspected the area from…NTSB FTW84LA072Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Cisco, TXThe plt reported that while he was taxiing, after landing, he was focusing his attention on the radio, on the right side of the instrument panel, when the acft rolled off the rwy & into a ditch. During the occurrence, the nosewheel collapsed & the right wing…NTSB ATL84LA055Accident · No injuriesLimited investigationFinal reportCessna T303 · Charlotte, NCDuring taxi for takeoff the pilot became disoriented and the acft collided with a ditch where construction of a new taxiway and old asphalt connected. The plt stated he could not determine the difference in the levels of the two surfaces. The taxiway was not…NTSB FTW84LA054Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Sunsett, TXDuring takeoff toward the sun on rwy 21 of the private strip, the plt allowed the acft to drift off the left side of the rwy. It then encountered an area of soft, sandy soil & nosed over. The plt stated that due sun glare off the windshield, he had difficulty…NTSB DEN84LA015Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Oakes, NDAfter a brief stop at oaks, ND, for fuel, the plt took off to fly about 5 mi to his private strip in an alfalfa field. During the landing roll, the gear hit a gopher mound & the acft nosed over.NTSB NYC84LA011Accident · No injuriesLimited investigationFinal reportCessna 172 · Reading, PAThe plt reported that during the flt, then he lost use of his radio & navigation equipment. Reportedly, he was forced to land about 1 mi from the Reading airport due to bad wx. The acft electrical system was checked, but no reason for the electrical failure…NTSB LAX84LA019Accident · No injuriesLimited investigationFinal reportBell 206B · Santa Ana, CAAfter returning from a flt, the helicopter was shutdown & refueled, then it was moved to a dolly. During the moving operation, the left 'shoe' slipped off the platform & the helicopter rocked back & damaged the tail rotor area.NTSB FTW84LA039Accident · No injuriesLimited investigationFinal reportCessna 172 · Rockport, TXWhile the plt was taxiing towards the rwy at dusk to depart, the right wing tip of the acft hit the windshield of a parked fuel truck.NTSB ANC84LA005Accident · Minor injuriesLimited investigationFinal reportCessna C-185E · Bethel, AKThe passenger stated that the plt was attempting to wipe condensation from the windshield when the acft ran into dry land.NTSB LAX84LA003Accident · No injuriesLimited investigationFinal reportBeech S35 · Elgin, AZWhile taking off from a dirt, ranch strip, the plt elected to use tracks that were worn in the vegetation beside the strip. He believed that these tracks had been formed by other acft & thought the takeoff would be smoother if he used them. However, the…NTSB FTW83LA442Accident · No injuriesLimited investigationFinal reportPiper PA-31T · Kerrville, TXThe acft collided with gravel on an unlighted closed rwy. The rwy was notamed as closed. The plt had been to the arpt earlier in the day and was aware of construction in progress. The plt has not filed an accident report.NTSB FTW83LA443Accident · No injuriesLimited investigationFinal reportCessna 177RGII · Houston, TXThe aircraft collided with a ditch while taxiing to the ramp following a night landing. The taxiway was unlighted & the plt stated the he 'simply turned too short onto the main taxiway.' Damage was limited to the left wing.NTSB ANC83FA178Accident · No injuriesField investigationFinal reportBellanca 7GCBC · Fairbanks, AKThe acft collided with a sand bar and nosed over while step taxiing on a river during a training flt. The CFI said he could not see clearly from the rear seat and was not aware of the sand bar until it was struck. He did not file an accident report. The…NTSB ANC83LA179Accident · No injuriesLimited investigationFinal reportCessna 180 · Talkeetna, AKThe acft collided with a sandbar and collapsed the left main landing gear during an aborted takeoff. The pilot stated that he was attempting a takeoff from a short airstrip at an elevation of 3000 ft MSL when he encountered a tailwind at rotation & the acft…NTSB FTW83LA437Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Doddridge, ARThe acft collided with a hole during landing and nosed over. The plt stated we has landed on this field before but should have surveyed it before landing.NTSB DEN83LA207Accident · No injuriesLimited investigationFinal reportCessna 210E · Powell, WYAccording to the pilot he made an approach to a dirt road beside a feed lot and overshot the intended touchdown point. He was relectant to make a go around because there was a high hill close ahead. He tried to stop the acft on the road remaining but the road…NTSB ANC83LA158Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2, MK-1 · Barrow, AKThe acft collided with a ditch during landing. The sandbar used for landing had a light covering of snow and a ditch wasobscured by the snow. During landing rollout the acft collided with the ditch and one of the main landing gear collapsed. No mechanical…NTSB FTW83LA402Accident · No injuriesLimited investigationFinal reportGrumman G-164B · North Lacassine, LAThe plt reported that during the landing, the left wing struck tall grass at the side of the strip & the acft swerved to the left. He tried to correct the situation by applying right braking action, but his braking was ineffective on wet grass. Subsequently,…NTSB CHI83LA373Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Wheeling, ILThe pilot stated that he taxied southeast on runway 12L, then turned to taxi northwest on runway 34. During the turn, the left main gear went off the runway and into a hole in the sod. The width of runway 12L is 50 ft and the width of runway 34 is 100 ft. the…NTSB LAX83LA379Accident · No injuriesLimited investigationFinal reportAlon A2 · Afton, CADuring an aerial observation mission, the passenger became ill, so the plt elected to land on a hard-packed strip across a plowed field. After landing, he walked over the area. Except for a rut at about midfield, he perceived there would be no problem in…NTSB MKC83LA182Accident · No injuriesLimited investigationFinal reportCessna 152 · Benton, KSThe acft collided with a ditch during an aborted takeoff. The pilot said the takeoff was on rwy 34 which is 2600 ft longthe density alt was 4000 ft. the acft accelerated to 60 KTS but still was not lifting off. As the acft approached the departure end of the…