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 LAX89LA036Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Camarillo, CAPilot of N8219J used poor judgement when she elected to execute the high speed taxi operation.NTSB ATL89LA029Accident · No injuriesLimited investigationFinal reportCessna 172N · Rogersville, TNThe plt reported that he was ferrying the airplane to obtain scheduled maintenance. Upon arrival over the arpt, he found that the only rwy was closed for maintenance. He then elected to land on a taxiway. He made a short-field ldg and applied the brakes…NTSB ATL89FA020Accident · No injuriesField investigationFinal reportMcdonnell Douglas DC-9-31 · Memphis, TNThe acft was being taxied to the gate when its right wingtip struck a catering truck that had been driven off of the designated driving lanes & partially onto the taxiway. The flt crew rprtd that the truck was traveling in the same direction within the…NTSB FTW89LA009Accident · No injuriesLimited investigationFinal reportCessna 152 · Muskogee, OKAcft's left wing struck a truck that was parked adjacent to the taxiway. After initial impact, the acft veered left and the nose also struck the truck. The plt stated that he was concentrating on a ramp sweeper that was moving down the taxiway in front of the…NTSB MKC89LA013Accident · No injuriesLimited investigationFinal reportCessna 150 · Liberty, MOWhile flaring for a x-wind landing, the student plt saw a large brown animal running toward the rwy. He maneuvered to avoid the animal. He stated the left main gear struck the animal, then the acft went off the rwy, bounced & nosed over.NTSB LAX89DVA02Accident · No injuriesFinal reportWSK PZL Mielec PZL-M-18 · Mendota, CAOn takeoff for an aerial application flight, the aircraft failed to clear an agricultural berm 300 ft beyond the end of the runway and nosed over. The pilot stated that the aircraft was loaded with 500 gallons of sodium chlorate and that he should have…NTSB MIA89LA010Accident · No injuriesLimited investigationFinal reportRaven S-60A · Tampa, FLDrg an apch to land, the plt saw some bushes & another balloon (which had already landed) in his intended landing area. He applied burner to soar over the obstacles, then pulled the envelope vent to quickly descend after the obstacles had been cleared. He…NTSB ATL88LA257Accident · No injuriesLimited investigationFinal reportCessna 152 · Conway, SCThe student pilot was conducting his first SOL0 flight, when he lost directional control and collided with three parked airplanes. The student said that his right foot slipped off the rudder pedal; attempts to recover failed. The pilot did not report any…NTSB MIA88LA272Accident · No injuriesLimited investigationFinal reportCessna 172F · Lake Wales, FLThe plt aborted the takeoff from the 'thick, wet' grass strip because the acft was not accelerating 'adequately.' He applied the brakes but it went off the departure end of the rwy, collided with a fence, tree, and dirt mound before coming to rest. There was…NTSB CHI88FA233Accident · No injuriesField investigationFinal reportBoeing 727-200 · Minneapolis, MNFailure of the captain to follow company pushback procedures and not getting a release before starting to taxi.NTSB DEN88LA200Accident · Minor injuriesLimited investigationFinal reportThunder and Colt AX8-90 · Las Cruces, NMThe commercial balloon plt was participating in a balloon rally. During landing, the plt noticed the balloon was drifting toward power lines. He elected to open the deflation valve at 30 ft AGL, to attempt to land short of the lines. The balloon touched down…NTSB MIA88LA264Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Orlando, FLThe plt had rented the fully fueled aircraft from an FBO at orl which has hard surfaced 4600 & 6000 ft rwys. He flew to a 130 ft MSL arpt with a 2430 ft grass rwy & picked up his wife for a xc flt. He stated that the acft performed normally during the 10 min…NTSB DEN88LA196Accident · No injuriesLimited investigationFinal reportCessna 182RG · Antelope Wells, NMThe commercial plt was flying three passengers to buy cattle. During takeoff from a 5,000 x 75 ft, wet gravel airstrip, the plt elected to use only the left side of the rwy to avoid mud. He used a soft field takeoff, with a nose high attitude, which limited…NTSB MKC88LA150Accident · No injuriesLimited investigationFinal reportAeronca 7CCM · Weiner, ARThe pilot handproped the starterless aircraft. After engine start, the pilot was unable to gain access to the cockpit, and the aircraft taxied uncontrolled into some nearby farm implements. The purpose of the flight was to ferry the acft for an annual…NTSB LAX88LA329Accident · No injuriesLimited investigationFinal reportCessna 172N · Camarillo, CAWhile taxiing for takeoff, the pilot maneuvered off the taxiway centerline to allow an oncoming Cessna 182 to pass. The Cessna 172 then collided with an airport t-hangar located near the taxiway.NTSB DEN88LA194Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Lakeside, MTThe plt and his pax departed bzn at 1500 MDT and flew to Hughes bay on flathead Lake, near Lakeside, MT, arriving at aprx 1700. The plt said he noticed a diminishing wave pattern from the southwest and a strong gust surface pattern from the east. There were…NTSB ANC88DAG07Accident · No injuriesFinal reportCessna T182RG · Kenai, AKThe pilot was taxiing the Cessna to the ramp area when the airplane wing struck a light pole near the terminal building. The pilot stated that he did not see the light pole before impact and that it blended in with the natural surroundings.NTSB MKC88LA157Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Springfield, MOWhile attempting to depart a 1600 ft sod runway, the PIC said he was unable to get airborne and elected to abort the takeoff. Unable to stop, he went through a fence, substantially damaging both wings. The plt recommended not trying to takeoff from a short…NTSB NYC88LA205Accident · Minor injuriesLimited investigationFinal reportCocks Starduster SA-300 · Stormville, NYThe pilot of a starduster SA-300 was on a local flight when he landed at an uncontrolled airport which had been notamed closed and had an x on the approach end of the runway. The pilot said a vehicle obscured the approach end during the approach and then left…NTSB ATL88IA226Incident · No injuriesIncident investigationFinal reportDouglas DC-9-51 · Atlanta, GAThe eastern DC-9 collided with the delta DC-9 during taxi. Ground personnel had cleared the eastern flight forward after the pilot had completed a powerback which left the airplane perpendicular to the delta flight. Due to the long fuselage and the relative…NTSB CHI88LA185Accident · No injuriesLimited investigationFinal reportCessna 172N · Xenia, OHNTSB CHI88FA179Accident · 1 fatalField investigationFinal reportPiper PA-30 · Oshkosh, WINTSB MKC88LA138Accident · No injuriesLimited investigationFinal reportCessna 172 · Lamar, MOThe plt of the aerial applicator acft said he was pulling out for an intersection departure on rwy 21, when the Cessna on a landing roll, struck him from the rear. The pilot said that possibly the background, haze, and airframe components made the incoming…NTSB DEN88IA167Incident · No injuriesIncident investigationFinal reportBoeing 727-100 · Denver, COWhile taxiing to the cargo ramp, the left wing collided with a lightpole as the flight crew were directed by gnd pers. One taxi director attempted to handoff the flight to another but the second misunderstood and turned away. A third person, who was not a…NTSB ANC88LA092Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Illiamna, AKDuring the takeoff roll on the beach, the aircraft struck a large rock and the pilot lost directional control of the aircraft.NTSB FTW88LA133Accident · No injuriesLimited investigationFinal reportCessna 310B · Ruston, LABoth airplanes were in the traffic pattern. The Cessna 152 made radio calls in the blind; the Cessna 310 did not. Both airplanes were on final at the same time with the 152 in the lead and the 310 lower. The 310 passed the 152 just before touchdown. The 310…NTSB MIA88LA220Accident · No injuriesLimited investigationFinal reportClassic YMF-5 · Key West, FLWhile turning the acft around at the operator's establishment after completing a sightseeing flt, the lower left wing collided with a vehicle.NTSB ANC88LA089Accident · No injuriesLimited investigationFinal reportPiper PA-22 · North Pole, AKWitnesses stated that acft #1 (N2747P,a Piper PA-22), flew a right downwind about 200 feet above the ground and then made a steep descending turn toward the runway. Acft #1 landed and struck acft #2 (N9102D, a Piper PA-18) while both were on the runway. The…NTSB CHI88FA163Accident · No injuriesField investigationFinal reportBoeing 727 · St Paul, MNAfter push back from the gate, the captain received an unrestricted taxi clearance & elected to taxi to the north side of a construction area. Subsequently, the left wing of the acft struck a parked vehicle in a nonmovement area, which resulted in substantial…NTSB MKC88LA123Accident · No injuriesLimited investigationFinal reportAeronca 7EC · St. Charles, MOThe plt said he was taxiing out for departure, when he collided with another aircraft that was taxiing in from a local flight. He said he was intending to make an intersection takeoff and failed to see the incoming aircraft in time to avoid a collision.NTSB MKC88LA125Accident · No injuriesLimited investigationFinal reportCessna 172 · Topeka, KSWhile taxiing in from a personal solo training flight, the student pilot taxied into a chain link fence while attempting to park the acft. The right wing spar sustained substantial damage.NTSB ANC88LA085Accident · 1 fatalLimited investigationFinal reportMaule M6-235 · Egegik, AKAfter touchdown on the beach, the aircraft struck a three-wheeled scooter (atv). The atv was substantially damaged and the driver of the atv, an eleven year old boy, died a few days later. The atv passenger, a eight year old girl, received minor injuries.…NTSB LAX88LA248Accident · Serious injuriesLimited investigationFinal reportCessna 177RG · Weaverville, CAAt the end of a cross country flt, the plt was landing the airplane in a 5 kt, gusting to 10 kt tailwind. The airplane did not touch down until past mid-field and the plt said the brakes were not effective until two thirds of the way down the rwy. The…NTSB ANC88LA071Accident · No injuriesLimited investigationFinal reportCessna 180H · Big River, AKWhile taxiing on the lake the aircraft's right float struck a log causing the aircraft's left wing to strike the water.NTSB SEA88LA116Accident · No injuriesLimited investigationFinal reportTeratron Tierra 2 · Kent, WAPlt was intentionally taxiing on grass between paved runway and taxiway for better tailwheel control. The acft struck an unseen obstruction in dusk conditions.NTSB CHI88LA140Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Portage, WIDuring taxi from landing the pilot failed to maintain adequate visual lookout and taxied onto a runway in front of an aircraft on its landing roll. The pilot stated that as he approached the other runway his visibility was restricted by a stand of trees, and…NTSB CHI88LA131Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Marion, INThe pilot became disoriented during flight and made an unscheduled stop in a corn field to ask for directions to his destination airport. During taxi for takeoff from the field, the pilot failed to maintain adequate visual lookout, and struck a manhole cover…NTSB SEA88LA100Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Clementsville, IDThe pilot was using a road as his base of operations for an aerial applications operation. During takeoff the aircrafts' wingtip struck a moving automobile's windshield. The plt did not file an accident report.NTSB ANC88DAG04Accident · No injuriesFinal reportPiper PA-18 · Togiak, AKDuring the takeoff from a beach, the aircraft hit a log causing substantial damage to the landing gear. The pilot stated that during the takeoff run he did not see the log. He then proceeded to an airport where during the landing roll the landing gear…NTSB SEA88LA125Accident · No injuriesLimited investigationFinal reportCessna 177B · Ocean Shores, WADuring taxi for takeoff, plt misjudged clrnc between wingtip and mowing machine.NTSB LAX88LA186Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Merced, CAWhile taxiing on a dirt road, the right wing struck a tree resulting in substantial damage. There were no mechanical failures or malfunctions reported at the time of the accident.NTSB SEA88LA092Accident · No injuriesLimited investigationFinal reportCessna 185 · Mercer Island, WAThe pilot stated that the aircraft struck a log while landing on the water. The aircraft then nosed over inverted and sank.NTSB BFO88LA044Accident · No injuriesLimited investigationFinal reportCessna 150J · Winchester, VAThe T-6 struck the C-150 from behind while both were taxiing for takeoff. The C-150 was stopped at the time. There was an annual fly-in being held at the arpt with about 300 acft in attendance. Ground personnel were directing ground traffic. The T-6 plt said…NTSB MKC88LA093Accident · No injuriesLimited investigationFinal reportBeech 95 · Shell Knob, MOThe pilot of the accident aircraft failed to maintain directional control during the landing roll. The left wing of the aircraft struck trees along the left side of the runway. Aircraft control was lost resulting in the right main landing gear collapsing.NTSB ATL88LA152Accident · No injuriesLimited investigationFinal reportCessna 172F · Walland, TNThe pilot attempted to abort a takeoff after experiencing a sudden gust of wind at liftoff. The aircraft collided with a fence and ditch which caused substantial airframe damage. The pilot reported the winds gusting to 15 knots. There was no reported aircraft…NTSB ATL88IA144Incident · No injuriesIncident investigationFinal reportCessna 152 · York, SCThe acft was to be ferried back to the home arpt after an eng overhaul. The plt rprtd it was located on rough/sod & required full power to taxi from the parking area. After the acft began moving, he attempted to make a rgt turn onto the taxiway. However, he…NTSB SEA88IA074Incident · No injuriesIncident investigationFinal reportBoeing 727-290 · Portland, ORThe Boeing 727 was pushed back fm the gate counterclockwise through an arc of 90 degrees resulting in mispositioning the acft relative to the intended taxi direction. The ground crew (tug and safety operators) attempted to resolve the out of position…NTSB BFO88LA040Accident · No injuriesLimited investigationFinal reportCessna 340 · Pineville, WVThe pilot failed to maintain clearance from obstacles while taxiing the aircraft.NTSB FTW88LA088Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Bonham, TXOne airplane was taxiing out for departure at the same time two others were coming in to land. The first airplane landed and did a 180 on the runway to taxi back to the parking area. This required the second airplane to go-around. The airplane taxiing in…NTSB MIA88FA132Accident · No injuriesField investigationFinal reportSwearingen SA-227-TT · Miami, FLThe plt stated that during his attempt to taxi around N30042, he thought he had enough clearance to get by, but misjudged the distance & the rudder of the merlin acft was struck by the DC6B'S left wing tip.