NTSB investigations
1,695 cases where the first occurrence was “On ground/water collision with object”.
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\" = 310) 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" = 310) 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 ATL86LA088Accident · No injuriesLimited investigationFinal reportCessna 152 · Mocksville, NCDuring landing the student pilot failed to correct for the crosswind. The aircraft drifted off the runway and collided with sock support post.NTSB FTW86LRG14Accident · No injuriesFinal reportPiper PA-18 · Uvalde, TXThe acft collided with mesquite brush during a landing on a ranch airstrip. The plt overcorrected and the acft touched down in a crab to the right. The plt applied the brakes & the acft nosed over.NTSB NYC86LA074Accident · No injuriesLimited investigationFinal reportUniversal Aircraft Industries GC-1B · Farmingdale, NYA Piper acft was standing in the runup area that is adjacent to taxiway A5. The plt of the globe acft taxied into the runup area and because the sun was in his eyes and the Piper was in his blind spot he ran into the Piper.NTSB NYC86LA070Accident · No injuriesLimited investigationFinal reportPiper PA-42-720 · Rochester, NYPiper aircraft collided with a parked Cessna aircraft while maneuvering into a parking space at Rochester-monroe airport after landing. The ramp was reported to be ice covered and sanded.NTSB ANC86LA023Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Soldotna, AKThe pilot stated that during the landing roll he lost directional control of the aircraft. The aircraft struck a row of trees of the end of the landing area.NTSB ATL86LA065Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Atlanta, GAThe pilot was unable to start the engine and elected to rotate the propeller by hand to free the congealed oil in the engine. When the propeller was rotated the engine started and the aircraft taxied into another parked aircraft. Post-accident examination of…NTSB MIA86LA061Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Vero Beach, FLThe plt stated that he was completing his run-up prior to takeoff, looked up & was only able to pull the power off before he was struck by N2361D.NTSB NYC86LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · West Dover, VTDuring the landing roll on ice covered runway the aircraft ran off the departure end of the runway and collided with a snow bank.NTSB FTW86FPA14Accident · No injuriesFinal reportPiper PA-32-300T · Saginaw, TXPilot long departed big spring, Texas with two passengers VFR to Saginaw airport, Saginaw, Texas. The pilot was flying to mwl, VOR 065 radial, descending to pattern altitude at Saginaw airport. The pilot said he had not been to that airport previously. Heavy…NTSB MKC86LA043Accident · No injuriesLimited investigationFinal reportCessna 172N · Kansas City, MOThe pilot had been at this airport 31 times since 1979. During his taxi to takeoff for a night flight, he mistook a service road for a taxiway. He taxied past one sign without seeing it but struck the second one. This is the third documented accident at this…NTSB LAX86LA103Accident · No injuriesLimited investigationFinal reportCessna T210N · Tucson, AZThe plt planned to fly nonstop fm houston, TX, to phoenix, AZ. He reported that during the trip he encountered 'fluctuating head winds' & he miscalculated the acft's endurance. Fuel exhaustion occurred 8 miles fm Tucson, AZ., & the plt made a successful…NTSB DEN86LA055Accident · No injuriesLimited investigationFinal reportCessna 172RG · Las Vegas, NMAccording to the plt, he was attempting to depart from a pvt grass strip, which is located on a plateau at an elev of aprx 6,400 MSL. The grass strip, which is aprx 3,000 ft in length, has an upslope of about 10% for the first half and a downslope at about…NTSB ANC86LA015Accident · No injuriesLimited investigationFinal reportDouglas DC-3C · Dillingham, AKNTSB DEN86LA046Accident · No injuriesLimited investigationFinal reportCessna 206 · Hardin, MTAfter ldg to the east on a snow covered dirt rwy, the pilot elected to t/o on an intersecting rwy to the south. He could not see the entire rwy surface from the position due to dwn slope from center of rwy. The acft impacted snowdrifts 40-50 mph on t/o gnd…NTSB LAX86LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · Upland, CAOn December 9, 1985 at 0730 PST a Cessna 152 registered to walter d. cable of upand, California collided with a parked truck while taxiing for takeoff on the paralellel taxiway of rwy 24 at cable airport, Upland, CA. VMC prevailed at the time. The airport was…NTSB DEN86LA047Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Aurora, COAccording to the plt, the right wing struck a fence while diverting off the taxiway centerline to make room for another oncoming acft. Contact with the fence resulted in a bent spar in the right wing.NTSB MIA86LA038Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-5 · Wimauma, FLThe plt stated that after turning on the rwy lights using the radio transmitter. They appeared to be dim, & only one side of the lights came on. He then landed south of the rwy at which time the right wing struck a fence post. The landing gear then collapsed,…NTSB CHI86FA036Accident · No injuriesField investigationFinal reportCessna 404 II · Chicago, ILThe tug driver with baggage cart failed to yield to a taxiing acft when crossing an active taxiway. It was dark nite. Acft had position/taxi lites on. Vehicle stop sign to taxi centerline is 70 ft. driver said he stopped at sign. Tug struck rt wg tip, wg…NTSB LAX86LA055Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Santa Maria, CAAfter completing a nighttime business flight, the plt landed and taxied to parking. Enroute the plt attempted to taxi between two hangars and around a wash rack. The acft collided with an unmarked curb adjacent to the wash rack and the gear collapsed bending…NTSB DEN86IA031Incident · No injuriesIncident investigationFinal reportBoeing 727-100 · Casper, WYAcft was parked at gate awaiting departure. A bus used to shuttle flt crews around the ramp arrived at flt 855 to deliver a flt attendant. The driver was backing away from acft when the left side to bus contacted rt wing tip. Damage was limited to wing tip…NTSB ATL86LA027Accident · No injuriesLimited investigationFinal reportCessna 150M · Jacksonville, NCDuring the takeoff phase of a touch & go landing the student plt lost directional control of the acft and ran off the side of the rwy. The student plt was on his third solo training flight.NTSB CHI86LA028Accident · No injuriesLimited investigationFinal reportMooney M20F · Piper City, ILThe pilot elected to land on a paved road because his rla was too wet. The aircraft landed on top of a moving automobile. The aircraft remained on top of the automobile as it ran off the side of the road.NTSB SEA86LA017Accident · Serious injuriesLimited investigationFinal reportCessna 172 · North Bend, ORThe plt reported having difficulty finding the tie down ramp area at the unfamiliar arpt in dusk light conditions. The passenger exited the acft with a flashlight to locate a tie down spot and walked into the spinning prop. The plt stated the passenger was…NTSB CHI86LA019Accident · No injuriesLimited investigationFinal reportCessna 150 · Clinton, INBoth student plts were making an apch to the same rwy at the time. The Cessna 152 touched down and was in its landing roll when the Cessna 150 landed on top with its nose wheel and prop in the 152'S rear window.NTSB NYC86IA019Incident · No injuriesIncident investigationFinal reportFokker F-28 · Flushing, NYThe F-28 acft was holding on taxiway bb. The B-767 acft was taxiing behind the F-28 on taxiway e which is perpendicular to taxiway bb. The r wing of the B-767 struck the rudder of the F-28.NTSB LAX86IA021Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · Oakland, CAOn October 24, 1985, an American airlines 727 collided with a parked united airlines 727 during a power back operation at Oakland, CA. IMC existed at the time with visibility limited to 0 ft due to fog. The aa ac sustained minor damage to its left wing and…NTSB CHI86LA008Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Lake Geneva, WIAfter touchdown & about 600 ft from the approach end of runway 23 the aircraft collided with a moped crossing the runway. The 11 yr old operator of the moped was seriously injured.NTSB CHI86LA005Accident · No injuriesLimited investigationFinal reportTodd Pitts · Hartford, WIN2032 had taken off, remained in the traffic pattern, & landed. N14JK had taken off, obtained a radio check at altitude,descended and entered the traffic pattern. Immediately afterlanding N14JK ran into N2032. N14JK reportedly made two radio calls in the…NTSB NYC85LA252Accident · No injuriesLimited investigationFinal reportBeech C35 · Wexford, PAAircraft was landing on private grass strip and during landing roll struck a deer with the right wing tip. The grass was wet and the pilot lost directional control. The aircraft impacted trees that bordered the airstrip and was destroyed.NTSB FTW85LA356Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Sanderson, TXOn landing, the plt noticed a quantity of brush on the rwy, however, he did not think it would be an obstacle to his intended takeoff and therefore did not remove it. During takeoff, the left main gear struck the brush causing the plt to lose control of the…NTSB LAX85LA401Accident · No injuriesLimited investigationFinal reportBeech P60 · San Jose, CADuring the landing roll, the acft veered off the right side of the rnwy and made contact with a taxiway marker which was then thrown against the acft, puncturing the pressure bulkhead compartment. Examination of the left brake assembly revealed evidence of…NTSB SEA85LA223Accident · No injuriesLimited investigationFinal reportCessna A185F · Eastsound, WADuring takeoff roll the acft veered right and the plt overcorrected to the left. The acft then departed the rwy to the left striking VASI lights.NTSB MIA85FA261Accident · Serious injuriesField investigationFinal reportAerofab Lake LA-4-250 · Medley, FLThe non seaplane rated plt whose airman certificate was under suspension. Attempted a downwind take-off from an intermediate point on the lake's surface. The plt stated he thought the non seaplane rated plt/pax attempted to abort the take-off by closing the…NTSB MKC85LA211Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Bridgeport, NEN2920E was taking off on a 2,800 ft long, turf rwy. There was a lt crosswind of 12 KTS and the density alt was 5,000 ft. the plt said the acft encountered a dip in the rwy and swerved to the lt momentarily. He said he regained directional control but then…NTSB BFO85IA074Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Washington, DCNorthwest flight 78 (NW78), a B-757, was parked at gate 17 facing east with mobile passenger lounge (mpl) docked at L1 door. United 52, a DC-10, taxied in easterly direction by left side of NW78, then turned right to southeasterly heading to follow lead-in…NTSB LAX85LA387Accident · No injuriesLimited investigationFinal reportCessna 170B · Buckeye, AZThe plt attempted to depart on soft silt & sand. During the takeoff roll the acft wheels sank into the soft terrain necessatating differential braking to maintain directional control. As the acft approached a ditch the plt forced the acft airborne. The acft…NTSB CHI85LA362Accident · No injuriesLimited investigationFinal reportBeech A36 · Mankato, MNThe plt of this acft attempted to start the eng twice with acft battery and a ground pwr unit without success. He then tied the tail down with a rope and had started the eng. After the eng started, the tie down rope broke and the acft taxied by itself into…NTSB MKC85LA202Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Kahoka, MOThe plt stated that as he turned final, the airspeed increased and he could not slow down so the acft touched down fast. When he attempted a last minute go-around, the acft hit a concrete filled metal pole, went off the end of the rwy, across a street and…NTSB NYC85LA228Accident · No injuriesLimited investigationFinal reportCessna 182L · Blairstown, NJDuring a normal night landing, a deer darted onto the runway and struck the tail section of the aircraft causing major structural damage. The deer was not located.NTSB ANC85LA162Accident · No injuriesLimited investigationFinal reportCessna 185 · Ancorage, AKThe aircraft nosed over during the landing roll. The pilot stated during the landing he lost directional control of the his aircraft causing the aircraft to nosed over on its back.NTSB LAX85LA363Accident · No injuriesLimited investigationFinal reportCessna 172N · Turlock, CAOn August 22, 1985, a Cessna 172N, N7338F, collided with a 3FT tall pole while taking off from Turlock, CA. VMC existed at the time. The ac was substantially damaged and the plt and his 2 pax were not injured. The plt stated that he was on the rwy when in…NTSB LAX85LA364Accident · No injuriesLimited investigationFinal reportCessna 152 · Monterey, CAFollowing an uneventful flt,the pilot taxied towards his parking area. He said as he looked to his right for a parking space the acfts left wing impacted a hanger and the acft turned left nosing into the hanger door.NTSB LAX85LA358Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Bakersfield, CAThe pilot stated that, as he was on the landing roll, two dogs chased a horse across the runway, and that he was unable to avoid striking the horse with the aircraft's left wing.NTSB NYC85FFA03Accident · Minor injuriesFinal reportCessna 172L · Parishville, NYThe pilot was attempting a landing in a Cessna 172L on a 1250 ft grass runway. He misjudged his touch down point and landed approximately 1/2 way down the runway. The aircraft was unable to stop on the remaining runway and ran off the departure end of the…NTSB DEN85LA220Accident · No injuriesLimited investigationFinal reportBeech 76 · Sula, MTPlt stated that he overflew airstrip to 'make sure it was clear.' During the landing roll, he saw shrubbery on the rwy and attempted evasive action. The acft veered left and the left main gear rolled into a drainage ditch and the left wing contacted a fence…NTSB DEN85LA213Accident · No injuriesLimited investigationFinal reportCessna 152 · Riverton, WYThe student plt attempted to land on rwy 17. The wind was reported to be from 010 degs at 13 KTS. The acft touched down halfway down the rwy. The plt attempted to go around but aborted because of the tailwind. The acft ran off the end of the rwy and collided…NTSB CHI85LA347Accident · No injuriesLimited investigationFinal reportCessna 172 · N. Philadelphia, OHThe plt landed at the wrong arpt at dusk, colliding with a ditch during rollout on the turf rwy. The destination arpt was 10 miles away on the same course with the sod rwy alignment.NTSB MKC85LA176Accident · No injuriesLimited investigationFinal reportCessna 172 · Cape Girardeau, MOWhile on a solo x-country flt, the student plt became lost/disoriended. When the acft's fuel level became low at dusk, the student elected to land on a gravel road. As the acft was on the landing roll-out, the left wing struck a brace wire for a power line…NTSB MKC85LA167Accident · No injuriesLimited investigationFinal reportCessna 152 · Queen City, MOThe plt was turning into takeoff position at the end of the rwy when the rt wheel encountered a low spot and the rt wingdipped down and hit a fence post.NTSB MIA85FA215Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · San Juan, PRThe acft was taxiing northbound on the north-south taxiway and collided with the vehicle moving westbound along the east-west access road. The access road is a designated non-movement area under the control of the puerto rico port authority. The plt stated he…