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 LAX87LA273Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Lake Tahoe, CAWhile taxiing to the rwy, the plt stated that the right brake failed. The acft rolled off the taxiway and collided with a transformer. Inspection of the brake revealed that the brake linings were worn and that the piston in the hydraulic cylinder had traveled…NTSB CHI87LA174Accident · No injuriesLimited investigationFinal reportCessna 172N · Troy, MIThe plt lndd at ngt & taxied the acft to a hangar area for a passenger stop. After the passenger deplaned, the plt proceeded to make a u-turn around a t-hangar & onto an automobile service road that wasn't normally used for acft. Whilethe plt was attempting…NTSB MKC87LA142Accident · No injuriesLimited investigationFinal reportCessna 172 · Kansas City, MOAfter lndg, the PIC was clrd to taxi to the g/a ramp. He was not aware of the new g/a ramp & proceeded toward the old ramp. He saw a large acft coming from the opposite drctn on the same twy, so he modified his route by selecting another way. Mistakenly, he…NTSB NYC87LA243Accident · No injuriesLimited investigationFinal reportBeech C24R · Danbury, CTDuring a landing at late dusk, the aircraft collided with a deer that darted onto the runway. The pilot said there was no time to take evasive action before the collision. The left wing and left gear door were damaged and the left fuel tank was ruptured.NTSB SEA87LA138Accident · No injuriesLimited investigationFinal reportCessna 185 · Lake Chelan, WADuring takeoff from the water the plt noticed a log protruding out of the water. The acft struck the log and the plt rotated prematurely, became airborne, and then descended striking the water hard.NTSB LAX87LA259Accident · No injuriesLimited investigationFinal reportCessna 150M · Cameron Park, CADuring a pleasure flt, the non certificated plt landed the acft short of the rwy when he mistook a road for the rwy. The plt stated that the sun was in his eyes and by the time he realized that he was not landing on the rwy the acft was too low and slow to go…NTSB SEA87LA136Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Lester, WADuring landing roll onto the closed runway the aircrafts right wingtip struck a post. The airport was notamed closed but no x's had been marked on the runway.NTSB CHI87LA159Accident · No injuriesLimited investigationFinal reportCessna 152 · Jenison, MIOn takeoff roll, while practicing touch and go landings, the training flight collided with a deer. The instructor reported that after landing, full power was applied for takeoff and during rotation, a deer ran onto the runway and collided with the left side…NTSB FTW87LA155Accident · No injuriesLimited investigationFinal reportCessna 152 · Farris, OKThe plt rprtd that drg a x-country flt, he got lost & the acft ran low on fuel. At dusk, he elected to make a precautionary landing in a open field. Drg the landing, the acft struck a tree & was damaged.NTSB LAX87LA250Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6-300 · Grand Canyon, AZWhile taxiing for takeoff, the underside of the left wing struck the boom of a backhoe parked adjacent to the aircraft ramp. The unattended backhoe was parked in a dirt area adjacent to the ramp with the boom in the extended position while the operator was on…NTSB ATL87LA185Accident · No injuriesLimited investigationFinal reportBeech 200C · Madisonville, KYThe acft struck a 2-FT hi avgas pump while the plt was taxiing around another acft that was parked. The nose gear collapsed & a small fire resulted. The plt & pax evacuated the acft. Line psnl were unable to extinguish the fire with hand-held extinguishers.…NTSB LAX87LA243Accident · No injuriesLimited investigationFinal reportBoeing 737-277 · Los Angeles, CAFailure of the qualified mechanic to insure the operation of the aircraft brakes prior to taxiing and his failure to utilize the emergency brake system to prevent the collision. Contributing to this accident was the decision of airline maintence supervisors…NTSB FTW87DRA04Accident · No injuriesFinal reportAero Commander Callair B-1A · Louise, TXAcft was departing from a 1500' private strip on an aerial application flt. Opr had reduced the fertilizer load on this flt in order to compensate for the higher ambient temps in the afternoon. On takeoff, the acft lifted off normally, but settled back onto…NTSB NYC87LA176Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Towanda, PAThe Taylorcraft, N43978, collided with the tail of Piper, N4889L while both were taxiing to rwy 22. The plt of the Taylorcraft stated that he was taxiing parallel to the rwy and the Piper came from behind and to the left to cross in front of him. The plt of…NTSB ANC87IA077Incident · Minor injuriesIncident investigationFinal reportBoeing 727-90C · Anchorage, AKThe mechanic in charge of taxiing the Boeing 727 allowed an unauthorized avionics technician to occupy the pilot seat. They inadvertently deactivated the brake pressurization system and struck a passenger jetway at the terminal gate. An ensuing fire destroyed…NTSB MKC87LA120Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Mediapolis, IAThe PIC attempted to depart downwind on a rural farm landing strip during an aerial application operation. The acft failed to attain flying speed and the acft struck a fence and ditch beyond the airport boundary.NTSB MIA87LA174Accident · No injuriesLimited investigationFinal reportCessna 172P · Tallahassee, FLWhile taxiing to take off the left wing collided with an utility pole.NTSB CHI87FA140Accident · 4 fatalField investigationFinal reportGrumman American AA-5 · Middleton, WIThe pilot had communicated with other pilots concerning the difficulties he was having with the winds. He had already attempted approaches to two other runways but had failed to complete a landing. He asked the pilot of a recent arrival for the wind…NTSB ATL87FA161Accident · No injuriesField investigationFinal reportCessna 208B · Atlanta, GAThe two acft collided on a ramp while each was taxiing to rwy 8L for t/o. both acft were authorized by ATC to taxi to the rwy; the Cessna was instructed by ATC to follow the Beech. The two acft were hdg in the same general direction on converging paths when…NTSB BFO87LA040Accident · No injuriesLimited investigationFinal reportCessna 152 · Fredericksburg, VAThe CFI stated that drg tkof, the acft accelerated slower than normal. After rolling abt 1800', the student rotated the acft to a normal climb attitude & it climbed aprx 5' to 10'. At about that time, the CFI noted that the airspeed indcn had dropped to abt…NTSB NYC87LA152Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Reading, PAAccording to the plt, the acft touched down (drg lndg) about 10 ft rgt of the rwy centerline. He stated that after the acft rolled about 50 yds, he heard a 'bump' & the acft veered rgt. However, the tower controller stated that the acft touched down in the…NTSB BFO87DIA01Accident · No injuriesFinal reportLake LA-4 · Stafford, VADuring takeoff the aircraft collided with a submerged object which penetrated the hull and dislodged the right pontoon. The aircraft sank in approximately 4 feet of water and was substantially damaged. The pilot and his two passengers were not injured. A boat…NTSB NYC87LA149Accident · No injuriesLimited investigationFinal reportCessna 172 · Atlantic City, NJAccording to a witness, the acft was hi & fast on final apch to lnd & touched down nosewheel 1st in a x-wind. Drg the lndg, the acft bounced, then drifted to the left & touched down on wet grass beside the rwy. Subsequently, the left main wheel strut hit a…NTSB FTW87LA113Accident · Minor injuriesLimited investigationFinal reportBoeing 707-323C · Oklahoma City, OKAfter engine start ground personnel experienced difficulty disconnecting the airstart unit hose. The ground signalman left the view of the crew to assist the other men in an effort to disconnect the unit from the aircraft. The pilot assuming that all was…NTSB LAX87LA185Accident · Minor injuriesLimited investigationFinal reportCessna P210N II · Tucson, AZA C-172 collided with a C-210N while txg. The C-172 was txg along a 75 ft wide parallel twy after landing. The C-210N was txg from a ramp area to his dep rwy. The C-210N route intersected the C-172 route at the parallel twy where the collision occurred. Plts…NTSB CHI87LA115Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Byron Center, MIThe plt stated that following a preflight inspection and engine run-up, he attempted a soft field takeoff on the 2070 foot turf rwy. According to the plt, he aborted the takeoff aprx 1035 feet down the rwy because he held the nose too high and he was dragging…NTSB ANC87LA060Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Yentna River, AKThe pilot stated that during the takeoff roll on the gravel bar he lost directional control of the aircraft causing the aircraft to nose over on its back.NTSB ATL87LA117Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Columbus, OHWhile taxiing for takeoff on a local flight, the aircraft collided with a parked fuel truck. The pilot said he saw the parked truck and attempted to taxi between it and some parked aircraft. The pilot said he misjudged the clearance and the left wing struck…NTSB NYC87LA117Accident · Serious injuriesLimited investigationFinal reportBeech 1900 · Boston, MADuring taxi operations in preparation for a takeoff from Boston logan airport, the Beech aircraft was struck by a ground vehicle and substantially damaged.NTSB LAX87LA171Accident · No injuriesLimited investigationFinal reportMooney M20J · Fullerton, CAWhile holding short of the runway behind a Cessna 182R, the pilot of a Mooney M20J, reached over to tighten his four year old sons seatbelt. The pilots foot came off the toe brake and the aircraft rolled forward and collided with the Cessna.NTSB MKC87LA068Accident · No injuriesLimited investigationFinal reportCessna 150F · Fremont, MOThe student pilot got off course on the first leg of his solo cross-country flight. He landed at an airport for fuel and directions, but the airport was deserted. When he departed for a nearby airport, he could not find that airport. After the student pilot…NTSB NYC87LA115Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Bedford, MADuring taxi operation in preparation for takeoff, the left main gear of the aircraft impacted an unmarked open manhole and the aircraft was substantially damaged.NTSB ATL87LA091Accident · No injuriesLimited investigationFinal reportChampion 7FC · Bellefontaine, OHThe acft was landed on rwy 04 with the wind from the east at eight KTS. The flight was the first solo in a tail wheel equipped acft for the plt. He had obtained no formal instruction in a tail wheel acft but had flown with a friend. On landing the acft…NTSB DEN87LA067Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Missoula, MTThe plt of the Piper navajo was taxiing to the active rwy for an IFR departure, directed his attention to the departure procedure chart in the cockpit, and collided with the tail of a swearingen acft holding short of the rwy awaiting takeoff clearance.NTSB NYC87IA106Incident · No injuriesIncident investigationFinal reportBoeing 727-225A · Jamaica, NYAs EA32 taxied from a stopped position on taxiway na between the outer and inner to the eastern ramp, a U.S. Postal tractor with an empty box traveling NE failed to yield to the aircraft and they collided on the service road and taxiway na.NTSB NYC87LA108Accident · No injuriesLimited investigationFinal reportBoeing 727 · Burlington, VTIn preparation for powering away from the gate, one groundman was stationed off the left nose of the acft and another was positioned by the left wing tip. The plt advanced the throttles and initiated a right turn. The throttles were brought back to idle…NTSB LAX87LA122Accident · Serious injuriesLimited investigationFinal reportBoeing PT-13D · Vacaville, CAThe aircraft were in the holding area short of runway 19 at the uncontrolled nut tree airport. The Cessna pilot taxied into position behind landing traffic and allowed his aircraft to roll slowly forward while waiting for the landing aircraft to clear the…NTSB ANC87LA039Accident · No injuriesLimited investigationFinal reportPiper PA-34 · Tyonek, AKThe on-demand air taxi flight struck a moose during the takeoff roll at a private rural airstrip. The two pilot crew and one passenger were uninjured. The leading edge of the aircraft's left wing was substantially damaged; but the pilot-in-command elected to…NTSB SEA87LA057Accident · No injuriesLimited investigationFinal reportCessna 140 · Nyssa, ORDuring takeoff roll, a domestic sheep crossed the strip in front of the aircraft. The pilot cut engine power and maneuvered to avoid, but the animal crossed back in front. Contact with the propeller caused the aircraft to flip inverted.NTSB LAX87LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Tulare, CAThe pilot attempted to land while the runway and VASI approach lights were off. The night was dark and he inadvertently landed on a roadway parallel to the runway. The aircraft collided with a fence when the road came to a dead end adjacent to the near…NTSB NYC87LA081Accident · No injuriesLimited investigationFinal reportCessna 172 · Beaver Falls, PAThe pilot attempted a turn while taxiing and added power to taxi over soft ground. The pilot did not realize the close proximity of aircraft wing tip to the hanger. The edge of the right wing caught a part of the hanger and was substantially damaged.NTSB FTW87LA065Accident · No injuriesLimited investigationFinal reportBurkhart Grob 103A · Midlothian, TXThe acft was substantially damaged when the left wing struck a 4 inch diameter post on landing. The plt stated that he decided that due to a crosswind, he would land diagonally across the north/south rwy that was mowed in the middle of a large open field…NTSB FTW87LA039Accident · No injuriesLimited investigationFinal reportCessna 172M · Lindale, TXA private pilot substantially damaged his aircraft while attempting a landing on a grass strip in Lindale, TX. The pilot overshot the airstrip, and crashed in a field off the end of the runway.NTSB ATL87LA056Accident · No injuriesLimited investigationFinal reportCessna 172G · New Philadelphi, OHThe acft right wing tip struck a hangar door while taxiing. The plt reported that he initially estimated the damage to be limited to the fiberglass wing tip fairing. He subsequently flew the aircraft back to his original departure point. Further examination…NTSB LAX87LA060Accident · No injuriesLimited investigationFinal reportMooney M20C · Michigan Bar, CADuring the flare, just prior to touchdown, a deer ran across the runway from the right and subsequently collided with the left wing of the aircraft. The pilot reported there was no time to avoid an impact.NTSB NYC87DFA03Accident · No injuriesFinal reportCessna 150M · Guilderland Cnt, NYThe student pilot, on a solo 30 NM x-country training flt, became lost while using VOR navigation. A precautionary landing was made in an industrial park. The acft collided with a stack of slate during the landing roll.NTSB DEN87LA022Accident · No injuriesLimited investigationFinal reportCessna 150 · St. George, UTDuring a touch and go landing, the acft's left landing gear tangled in loose wire. The acft swerved to the the left, struck a used tire barrier then nosed over. The landing was made on a closed rwy.NTSB ATL87IA027Incident · No injuriesIncident investigationFinal reportBritish Aerospace BA-31 · Louisville, KYWhile taxiing for takeoff, a jetstream 31 operating as a commuter carrier to dayton, Ohio, collided with the fourth baggage cart of a four car train. The visibility on the ramp was reduced due to rain and fog. The baggage cart driver stated that he was…NTSB NYC87LA037Accident · No injuriesLimited investigationFinal reportPiper J3 · Montgomery, NYWhile taxiing in the middle of the taxiway the propeller of N58380 contacted the wing of N7416T. N58380 then rotated and it's wing contacted the wing of N7416T. N7416T was stopped alongside the taxiway when the accident occurred.NTSB BFO87LA010Accident · No injuriesLimited investigationFinal reportBeech BE-55 · Beckley, WVThe plt stated that before takeoff he did not see anything on the rwy. The landing and taxi lights on the acft were on for the takeoff. During the takeoff roll when the acft was almost at takeoff speed the plt heard a loud bang followedby the acft yawing to…