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 ATL83LIJ03Accident · No injuriesFinal reportPiper PA-28-140 · Bruceton Mills, WVThe acft collided with a fence during an attempted takeoff from a short sod private strip. The privately owned grass strip is approx. 800 feet long with a 5 deg upgrade from the midway point. The pilot said he realized he could not climbfast enough so he…NTSB DEN83LA138Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Afton, WYThe pitts special and a Cessna 182 collided on an active rwy the pitts was landing and the Cessna was taxiing down the rwy for refueling. The Cessna had made a radio call leaving the hanger area but did not make one prior to actually goingonto the rwy. The…NTSB MKC83LA126Accident · No injuriesLimited investigationFinal reportCessna 182K · Plainville, KSThe acft collided with a post during a precautionary landing on a road. The plt had been flying on this flt for 2 and a half hours when he noticed the oil pressure go to zero. He landed on a highway and during the landing roll the right wing hit a signpost…NTSB MIA83LA153Accident · No injuriesLimited investigationFinal reportBeech 58 · Clearwater, FLThe acft collided with a dirt mound and taxiway during landing to the left of the rwy. The plt stated that due to poor visibility caused by haze and the setting sun that he mistook a white line of sand as the centerline of the rwy. This line was left of the…NTSB MIA83LA150Accident · No injuriesLimited investigationFinal reportCessna 207 · Sebring, FLAccording to the plt, he heard a 'thump' when he was taking off from orlando west arpt, but attributed it to the grass strip. When he landed at Sebring arpt, he heard a scraping sound as he lowered the nose & elected to go around. He decided the nosewheel was…NTSB SEA83LA125Accident · No injuriesLimited investigationFinal reportCessna 150 · Kelso, WAThe plt hand-propped the acft with a non-plt at the controls. The acft was then taxied to the fuel pumps & fueled. The acft was then hand-propped again with no chocks used. The non-plt was at the controls. The acft started to move, & the plt climbed into the…NTSB SEA83LA112Accident · No injuriesLimited investigationFinal reportCessna 180H · Blakely Island, WAA Cessna 180H, N2429F, was being landed on rwy 19 after a Cessna 172M, N80202, had just landed. The Cessna 180 plt stated that during arrival, the wind socks at the ends of the rwy were swinging in all directions & there was light to moderate turbulence.…NTSB MKC83IA115Incident · No injuriesIncident investigationFinal reportLockheed L-1011-385-1 · St. Louis, MOWhile taxiing to the gate the number 1 engine struck a baggage cart in an area normally occupied by aircraft. The pilotsundivided attention was to the signalman.NTSB DEN83IA119Incident · No injuriesIncident investigationFinal reportBoeing 727-31H · Colorado Spring, COWhile starting to taxi from the gate for departure, the acftstruck the jetway with the left wing. The captian stated that he was following the ground guide. The ground guide stated that this was the first time he had guided an acft & he had never recieved any…NTSB MKC83FA112Accident · No injuriesField investigationFinal reportBoeing 727-100 · St. Louis, MOThe acft was scheduled as Continental flt 415 & was departing from eastern airlines gate 14A. While departing from the gate, the aircrew turned left to avoid a DC-9 parked at gate 14, then turned right to a yellow taxi line. While maneuvering, the left wing…NTSB NYC83LA118Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Teterboro, NJAcft collided with taxiway sign collapsing the right landing gear.NTSB LAX83LA235Accident · No injuriesLimited investigationFinal reportPiper PA 28-236 · Emigrant Gap, CAThe acft collided with trees during takeoff. The CFI and student had made a landing on a rwy that was 2/3 covered with snow. They thought they could make a short field landing and a short field running takeoff. They nosed down in the snow during the attempted…NTSB LAX83LA233Incident · No injuriesLimited investigationFinal reportBeech 35P · San Rafael, CAThe plt reported that during his final apch to land, he observed an individual on a small lawn-type tractor, well clear on the left side of the rwy. Just after touchdown, as he was lowering the nose, he observed the tractor pass under the left wing of the…NTSB CHI83LA216Accident · No injuriesLimited investigationFinal reportCessna 150 · Janesville, WIN13364 had stopped short of the runway for a run-up check prior to takeoff. The pilot of N8576J continued his taxi while he was checking the field elevation and setting his altimeter he taxied into the empennage of N13364.NTSB LAX83LA222Accident · No injuriesLimited investigationFinal reportGrumman 164B · Lodi, CAThe aircraft was rolling for takeoff at dawn when it collided with another crop duster taxiing in the opposite directionthe aircraft taking off had rolled about 100 feet when the pilot saw a red light on the runway and aborted the takeoff and attempted to…NTSB CHI83LA199Accident · No injuriesLimited investigationFinal reportBeech B-60 · Detroit, MIThe acft collided with another parked and unoccupied acft while parking. The tail of the moving Beechcraft was damaged substantially. Damage to the parked acft was minor. The weather was VMC but a light rain was falling.NTSB MIA83LA131Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Daytona Beach, FLThe plt stated that during touch down the acft bounced & he lost control. He elected to go around to try to regain control of the acft. During the go-around the acft veered right & collided with a palm tree.NTSB SEA83LA082Accident · No injuriesLimited investigationFinal reportStinson L-5 · Haines, ORThe aircraft collided with a fence during a takeoff and nosed over. The runway was an alfalfa field approximately 1000 feet in length with high growth. The density altitude was 4000 feet. The aircraft did become airborne but settled back to the field, and…NTSB ATL83FU001Accident · No injuriesFinal reportWizard J-3 · Wetumpka, ALThe plt reported having about 0.4 hour of experience in this new ultralight vehicle. The nosewheel of the vehicle was not steerable & there were no brakes on the main gear. Therefore, the plt relied on the rudder for ground steering. At slow speed, air from…NTSB DEN83LA093Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Powers Lake, NDAccording to the plt, he was landing on a road near a friend's house when the left wing hit a steelpost and caused the acft to veer off the road and into a ditch. The acft then nosed over in the ditch.NTSB SEA83LA071Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Everett, WAThe pilot collided with a parked aircraft while taxiing for takeoff. The weather was VMC and the taxiways were clear. The pilot said the right wing of his aircraft struck the left wing of the parked aircraft and the moving aircraft swung around into the other…NTSB LAX83LA171Accident · No injuriesLimited investigationFinal reportCessna 195A · Palo Alto, CAThe aircrews of a Cessna 195A, N1537H, & a Beech V35B, N2084L, were cleared to rwy 30 from different positions on the parking area. The Cessna plt was instructed to use the 'shortest route, no delay please.' As the acft were taxied on separate routes, they…NTSB MKC83IA083Incident · No injuriesIncident investigationFinal reportBoeing 727-222 · Des Moines, IAThe right leading edge slat was damaged when the acft taxied onto a closed & thusly marked taxiway. The closed taxiway was not shown as closed on the charts and no NOTAM was issued. The sky ws obscured & visibility was 1/2 mile in fog.NTSB LAX83LA164Accident · No injuriesLimited investigationFinal reportCessna 210C · Holbrook, AZAccording to the plt, he applied power to taxi after starting the eng. He stated that after the acft began moving, he tried to apply left braking action to negotiate a left turn. However, according to him, the left brake failed to operate & the acft continued…NTSB MKC83IA200Incident · No injuriesIncident investigationFinal reportDouglas DC-3 · Springfield, MOOn taxi for takeoff the acft left propeller struck a parked unoccupied acft.NTSB LAX83IA149Incident · No injuriesIncident investigationFinal reportBoeing 747 · Los Angeles, CAN323EA was stopped 44 ft prior to the final turn off point for it's gate allowing the tail to extend 21 ft beyond the limit line. 9VSQQ was taxiing at 'pilots discretion' along the taxiway centerline when an attempt was made to pass behind N323EA at a 90 deg…NTSB FTW83LA162Accident · No injuriesLimited investigationFinal reportBeech D-18S · Dfw Airport, TXN80017 experienced engine trouble and shut down the left engine enroute from amarillo, TX. Later, because of electrical problems the pilot secured all electrical equipment except the no. 2 radio, transponder and rotating beacon after landing, the pilot taxied…NTSB NYC83FA074Accident · Minor injuriesField investigationFinal reportSwearingen SA226TC · Albany, NYThe plt reported that during arrival, he followed the ILS glide slope to touchdown about 1000 ft down the rwy. He reported the landing was smooth, and when the acft was aprx 100 ft from the intersection of rwys 1/19 and 10/28, he saw a ridge of snow and ice…NTSB CHI83LA136Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Northome, MNThe acft collided with a snowbank while landing on the airport at Northome, MN. There was no UNICOM at Northome and NOTAMS advised the runway was closed. The weather was VMC but overcast with freezing rain. The pilot reported he made a precautionary landing…NTSB MIA83LA084Accident · 1 fatalLimited investigationFinal reportPiper PA-32R · Cross City, FLThe acft collided with trees during a night landing on a lonely stretch of country road. The landing was an attempt to unload 662 pounds of marijuana in an illegal drug operation.a passenger was fatally injured and the injured pilot was found later in the…NTSB NYC83FHJ01Accident · Minor injuriesFinal reportHarrison Volmer VJ-22 Amphibian · Schinnecock Bay, NYWhile gaining speed on step to make water takeoff the hull of the aircraft collided with something not seen in the waterand began to sink. The aircraft filled with water and sank until it rested on the bottom with only the prop tip showing the weather was VFR…NTSB FTW83LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Sugarland, TXThe student plt had become lost & landed on a dirt road to ask for directions back to his home arpt. After receiving directions, he turned the acft around & started to takeoff. However, before reaching flying speed, the acft struck a partially buried pipe &…NTSB ATL83LA108Accident · No injuriesLimited investigationFinal reportCessna 172 · Marietta, GAThe aircraft collided with a parked van while taxiing from landing at mccollum airport,Marietta,GA. The acft was being demonstrated to a prospective buyer who was in the left front seat with the owner in the right seat. After a flight fromatlanta,GA they…NTSB ANC83FAG04Accident · No injuriesFinal reportCessna 140 · Iliamna, AKThe aircraft collided with some hidden obstructions during an aborted takeoff. Th pilot realized his heavily loaded aircraft was not accelerating fast enough and aborted the takeoff. After turning left to avoid some metal drums, the aircraft collided with a…NTSB FTW83AA104Accident · No injuriesFinal reportCessna 550 · Houston, TXAfter landing on rwy 31L, the aircrew of N100VV requested clearance to turn off to the right at midfield onto rwy 22. The request was approved & the aircrew was instructed to use caution for a cherokee proceeding from the opposite direction. The plt of N100VV…NTSB SEA83FA054Accident · No injuriesField investigationFinal reportPiper PA-34-200T · Seattle, WAThe aircraft collided with another parked aircraft while taxiing to takeoff. The time was dawn and the taxiway lights were on. The taxiing pilot allowed his aircraft to stray and collided with a parked PA-34. Both aircraft were damaged substantially. The…NTSB CHI83LA100Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Chicago, ILThe acft collided with a parked acft on the ramp. The student pilot started the acft on a snow covered icy ramp at nightthe parking brakes were set but when the engine started the acft taxied into another acft. After the accident the brakesof the acft were…NTSB DEN83LA051Accident · No injuriesLimited investigationFinal reportCessna 172XP · Harmony, WYThe acft collided with a fence at the departure end of a pasture field during a go-around. The pilot had decided to land in an easterly direction to avoid powerlines and did not consider direction of the wind. Full flaps did not slow the acft effectively…NTSB ANC83IA036Incident · No injuriesIncident investigationFinal reportPiper PA32-301 · Quzinkie, AKDuring landing roll the acft struck a snow berm on the runway causing the nose gear to fail.NTSB FTW83LA071Accident · No injuriesLimited investigationFinal reportCessna T337G · Pampa, TXThe plt stated he ran the battery down while trying to start the engs. After obtaining a battery charger & a long extension cord he charged the battery & was able to start the engs. While he was returning the charger to the hangar the acft rolled into a…NTSB SEA83LA031Accident · No injuriesLimited investigationFinal reportCessna 172L · Vancouver, WAAfter landing, the pilot began taxiing to the parking area. While taxiing, he came to an area where he tried to taxi between a fuel truck and a Beech baron. The pilot stated that he misjudged the distance between his right wing tip and the fuel truck and the…NTSB FTW83LA050Accident · No injuriesLimited investigationFinal reportCessna 185 · Venice, LAPilot making water takeoff pass piers collided with a tug that appeared out of a slip. Aircraft sank.NTSB NYC83LA036Accident · No injuriesLimited investigationFinal reportFokker F-27-100 · New Haven, CTAircraft collided with a power cart as taxi to takeoff began.NTSB FTW83IA044Incident · No injuriesIncident investigationFinal reportBoeing 727-223 · Little Rock, ARThe aircrew reported that they broke out of the clouds at about 744 ft AGL while on an ILS approach and that the ceiling was ragged. At about 500 ft AGL, the captain turned on the windshield wipers. The first officer was flying the aircraft from thr right…NTSB FTW83LA038Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · Sanderson, TXThe pilot became disoriented and made a precautionary landing on a highway. After verifying his location the pilot tookoff, made a sharp pullup to avoid a roadside reflector, settled back to the road surface and hit a pole. The pilot veered off the highway…NTSB CHI83LA039Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · New Hudson, MIThe pilot was giving a plane ride to his brother, his brother's grandson and the child's mother. The child's grandmother wanted to take pictures and walked into the parking area next to the taxiway. While looking through the viewfinder, her depth perception…NTSB ATL83LA026Accident · No injuriesLimited investigationFinal reportCessna 172N · Loris, SCWhile taxiing from ramp left wingtip struck a van parked in the tie-down area.NTSB MKC83LA030Accident · No injuriesLimited investigationFinal reportCessna 152 · 1nm N. Or Mcgre, NEUpon discovering his intended point of landing was closed, the pilot chose to land the aircraft on a nearby road. During his final approach the pilot saw a power line and dove under it landing short. The aircraft collided with road signs during the landing…NTSB DEN83LA015Accident · No injuriesLimited investigationFinal reportCessna T210 · Holly, COThe pilot stated that during takeoff a piece of wood was picked up by a wheel and tossed against the elevator jamming itand causing him to lose control. While out of control he thought he impacted the ground. A farmers irrigation pipe one quarter mile from…NTSB MKC83LA015Accident · No injuriesLimited investigationFinal reportCessna 172P · Kansas City, MOPilot taxiing to takeoff went on a roadway instead of a taxiway and collided with a sign post. The taxiway was marked by signs and yellow paint lines on surface where pilot became disoriented and left taxiway to follow road.