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 CHI87LA023Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Winamac, INAfter noticing a vague shape off the right side of the aircraft, during takeoff run at night, the pilot continued down the runway until the aircraft collided with a 180 pound deer.NTSB MKC87LA021Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Chillicothe, MOThe PIC rptd that he was taxiing out fm the ramp area to the runup area of the airport to prepare for takeoff. He stated he had noticed ground equipment operating on the arpt as he taxied out. He had also stated that the windshield had become fogged during…NTSB DCA87MA010Accident · 1 fatalClass 1 · MajorFinal reportPiper PA-23-150 · Tampa, FLAt aprx 0612 EST, an eastern airline capt (owner of Piper PA-23, N2185P) departed a rwy near his home in VFR conds to commute to work at Tampa, FL. Shortly after takeoff, he contacted a fss & updated the wx info he had obtained on the previous evening. At…NTSB NYC87DFA01Accident · No injuriesFinal reportCessna 150M · Oriskany, NYThe student & instructor plt (CFI) were making a night, touch-&-go landing, when the acft struck a deer on the rwy. They were unable to see the deer in time to avoid a collision.NTSB SEA87LA013Accident · No injuriesLimited investigationFinal reportCessna 180K · Burlington, WAPlt was taking off in fog from wet grass strip. Acft swerved left, plt unable to arrest with opposite rudder and brake, collided with fence. Abort not attempted.NTSB NYC87FA020Accident · 2 fatalField investigationFinal reportCessna 182E · Fishers Island, NYA Cessna 182 taking off on rwy 25 collided with a Piper PA-28-181 which was landing on rwy 12. The collision occured in the intersection of the two runways. The two occupants of the Cessna were seriously injured and the two occupants of the Piper were fatally…NTSB BFO87DID01Accident · No injuriesFinal reportPiper PA-28RT-201 · Lynchburg, VAWhile on the takeoff roll, the acft collided with a deer. The plt rprtd that he had accelerated to 50 KTS & was about 1000 ft down the rwy when the deer ran in front of theNTSB MIA86LA257Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Cedar Key, FLDuring taxi after landing the pilot taxied on a parallel roadway that had aircraft parked on it. The left wing of the aircraft struck two parked aircraft causing minor damage to them. The taxiing aircraft sustained substantial damage.NTSB DEN86LA260Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Wright, WYAcft was taxiing for takeoff from driveway on private ranch. Plt said there was strong x-wing gusting from left to right. Plt said he was holding right rudder when wind velocity decreased. Wing tip struck post beside driveway, acft turned right, and rolled…NTSB CHI86IA231Incident · No injuriesIncident investigationFinal reportMitsubishi MU-300IA · Chicago, ILAfter landing the corporate jet was cleared to taxi to the general aviation ops to deplane pax. A food service truck crossing the taxiway failed to yield the right of way. The acft was unable to stop before the left wing struck the rear of the vehicle.NTSB FTW86LA170Accident · Minor injuriesLimited investigationFinal reportRyan PT-22 · Kerrville, TXWhile arriving for a 'fly-ing' at an uncontrolled arpt, the plt of a PT-22, N48331, turned onto final apch after the plt of a preceding acft had turned off of the rwy. At about the same time, the plt of an unregistered ultralight gyrocopter taxied onto the…NTSB CHI86LA227Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Grosse Ile, MIThe pilot stated that he had a habit of landing left of the centerline. While landing with a right crosswind, the aircraft drifted to the left and the left wing struck three construction sawhorses, placed off the left side of the runway.NTSB LAX86LA356Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Monterey, CAThe private plt landed her acft & began taxiing toward a parking area. The driver of an acft fuel service truck observed the approaching acft, & he brought his truck to a complete stop in an authorized area for truck traffic. He was clear of the taxiway. The…NTSB LAX86LA355Accident · No injuriesLimited investigationFinal reportAero Commander 112A · El Monte, CAThe pilot stated that the engine would not start so he secured the left wing and hand propped the engine. When the engine started, the aircraft began moving in a circular path to the left and collided with a parked aircraft.NTSB LAX86LA354Accident · No injuriesLimited investigationFinal reportCessna 152 · El Monte, CAThe student pilot was taxiing to the run-up area when his left wing struck the corner of a hangar. The pilot stated he was paying attention to the right wing which was close to another aircraft at the time.NTSB ANC86LA147Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Port Alsworth, AKThe pilot was unable to avoid a large floating log in his water lane path during takeoff. He struck the log, lost control of the airplane and crashed.NTSB CHI86FER18Accident · No injuriesFinal reportShanks/Becker Acro Sport · New Richmond, WIAccording to the pilot during landing rollout his left wing encountered three to four foot high grass growing up to the edge of the turf runway. The aircraft then veered off into a ditch. The runway involved is 2100 feet long and 75 feet wide.NTSB MKC86LA173Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Bertrand, NEThe pilot stated that he was on an unsupervised local solo flight when he decided to land at a private airstrip. As he had driven his automobile on this runway four days prior to the accident and had found the landing surface clear he assumed that the runway…NTSB ANC86FA126Accident · No injuriesField investigationFinal reportCessna 185 · Anchorage, AKThe plts of Cessna 185 (C-185), N1802R, & Cessna 180 (C-180), N9418C, received clearance fm ground control to taxi to rwy 32 via taxiway-n (twy-n). Both acft were tailwheel (conventional gear) equipped. As the C-185 was proceeding along twy-n, the C-180 plt…NTSB SEA86LA205Accident · No injuriesLimited investigationFinal reportMooney M20 · Quincey, WAThe pilot stated he had mad a normal landing on a paved city street in a housing dvelopment thinking that it was the Quincey municipal airport. After the pilot realized he ahd made a mistake a take off was attempted. During the take off the pilot aborted the…NTSB LAX86LA321Accident · No injuriesLimited investigationFinal reportCessna A185F · Chester, CAAfter servicing the aircraft's fuel tanks to their 80 gallon capacity the pilot, his instructor pilot, and their passenger back taxied approximately 1,300 feet from the departure end of the rwy and started their takeoff. When the aircraft failed to climb…NTSB CHI86FA199Accident · No injuriesField investigationFinal reportCessna 177 · Oshkosh, WIA spl tfc management program was in effect for an annual eaa fly-in, & a waiver to FAA handbook 7110.65D was in effect which allowed for reduced sepn btn acft opng at wittman fld. As 2 acft were lndg, the plt of the 1st acft (Cessna 177, N17204) was told to…NTSB ANC86FA118Accident · No injuriesField investigationFinal reportCessna 180 · Anchorage, AKA ground control (gnd ctl) trainee clrd Cessna 152 (C-152), N757WV, to taxi to rwy 6, then relinquished the gnd ctl psn to a full performance level (fpl) ctlr, who had just signed on duty. The fpl ctlr was aware of the lctn & taxi destn of the C-152, the fpl…NTSB FTW86FPA25Accident · No injuriesFinal reportThorpe T18 · Mckinney, TXThe acft was landed on a closed rwy where it collided with steel posts embedded in the rwy. The plt had questioned a Cessna plt who made a go-around in front of him about the status of the rwy and wad advised it was closed. The plt saw the flag & an 'x' but…NTSB FTW86LA139Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Fort Worth, TXThe pilot touched down long but with adequate runway remaining. However, he delayed brake application and as a result was still going too fast to turn off at the end of the runway. Collision with the runway end barrier occurred.NTSB DEN86LA205Accident · No injuriesLimited investigationFinal reportSchweizer G164A · Grandin, NDPlt was attempting to take off from 2600 ft x 50 ft sod strip with full fuel (36 gal) and 160 gal of M22, a fungicide. Center of rwy was soft from recent rains. Plt began takeoff roll on right side of rwy. Right wing and spray boom contacted tall grain stalks…NTSB LAX86FA293Accident · 1 fatalField investigationFinal reportBurkhart Grob A103 Twin II · Sun City, AZThe newly certificate sailplaned pilot had taken a friend for a sightseeing flight. On the return the pilot made a normal approach and landing, then veered off the left side of the runway and struck a large saguaro cactus. The cactus toppled and fell across…NTSB NYC86LA181Accident · Serious injuriesLimited investigationFinal reportCessna 172L · Westerly, RIThe plt rprtd he landed in winds which were gusting to 20 KTS. As the acft touched down, it ballooned & the plt applied some power to maintain control. As he contd the landing, the acft began to drift to the left. The plt attempted a go-around, but he was…NTSB SEA86LA170Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Royal City, WAThe plt was landing the acft on rwy 27, toward the sun. With the sun in her eyes, she did not see a 300 lb calf on the rwy. The acft struck & killed the calf & was substantially damaged.NTSB LAX86LA284Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Los Angeles, CAThe private plt had no prior experience at the Los Angeles intl. Arpt. & the plt was unknowledgeable of the existence of arpt motor vehicle traffic service roads. The plt was given an ATC clearance to taxi, & in the darkness the plt mistook a service road for…NTSB MKC86LA146Accident · No injuriesLimited investigationFinal reportCessna T303 · Lake Ozark, MOThe plt stated that the flt was uneventful until after landing when somebody instructed him, over the common traffic advisory frequency on his VHF radio, to park the acft at a new parking area, and he complied. This parking area was congested with extra acft…NTSB FTW86LA121Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Georgetown, TXThe instructor pilot was demonstrating night landings to his student pilot, when the aircraft veered to the right on touchdown. The instructor thought his student was on the right rudder, but failed to override him by applying left rudder. The next morning…NTSB FTW86LA120Accident · No injuriesLimited investigationFinal reportBeech E18S · Oklahoma City, OKA swearingen SA-226TC, N516SS, was lndd at ngt on rwy 17L. After lndg, the flt crew exited onto taxiway-E3 (TWY-E3), where they were instructed by tower to hold. A Beech E18S, N2001C, was then lndd on the same rwy (rwy 17L) & its plt also exited onto TWY-E3.…NTSB LAX86LA270Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-26C · Aguanga, CAA Schweizer sgs 1-26C glider collided with a wire fence while the plt was landing on a closed airstrip. The closed strip was marked with x's. several fences were stretched across the airstrip to control livestock. The pilot indicated that during flt, he had…NTSB CHI86FEP05Accident · No injuriesFinal reportBeech C-23 · Milwaukee, WIDuring taxi for takeoff the plt inadvertently taxied onto an access road and struck and unlit sign. The taxiway had been resurfaced and no taxi guide lines had been repainted.NTSB SEA86LA151Accident · No injuriesLimited investigationFinal reportNavion A · Boise, IDThe pilot elected to land onto a road to pick up a passenger. The pilot failed to maintain adequate clearance from a wire fence to the right of the road and caught the right wing.NTSB MKC86LA124Accident · No injuriesLimited investigationFinal reportCessna A188 · Blaine, KSThe plt stated that a calf, weighing aprx 500 lbs, ran in fnt of the acft, just as it was apchg lift-off. Subsequently, the acft went out of control & skidded, collapsing the main landing gear. Until just prior to impact, the calf was hidden from the plt's…NTSB ATL86LA154Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Warren, OHDuring a normal takeoff, the pilot decided to abort the takeoff after he determined that the aircraft was not accelerating as fast as he thought it should. After the aircraft touched down on the sod surface, the pilot proceeded toapply full braking. Since the…NTSB NYC86FA131Accident · 2 fatalField investigationFinal reportCessna 414A · Atlantic City, NJDuring tkf gnd run, at a speed of 95 KTS, the plt pulled the control wheel back to lift off. The control wheel, according to the plt, would not go back more than about 2 inches; which is less than half the normal full aft travel. The acft reached a speed of…NTSB LAX86LA224Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Tonopah, AZThe acft collided with a truck during takeoff ground run from an interstate. The plt indicated the acft had run out of fuel on the x-country flt and he had not refueled at the departure point. He landed on the interstate without incident and sent his pax for…NTSB DEN86LA136Accident · No injuriesLimited investigationFinal reportCessna 421C · Albuquerque, NMAcft was landing on rwy 17. Plt said he struck a rabbit with left main landing gear and lost all braking action on left side. Plt used right brake to decelerate but overran rwy end and struck dirt bank.NTSB NYC86LA124Accident · No injuriesLimited investigationFinal reportCessna 305A · Salem, NHThe Cessna 305, being used a tow plane for glider operations, ran through a fence at the departure end of the rwy during takeoff. The plt stated he experienced a wind shift during takeoff. He did not have a pre-decided point at which to either release the…NTSB FTW86LA080Accident · No injuriesLimited investigationFinal reportCessna 172M · Dallas, TXThe pilot collided with a fence while taxiing on an airport access road, which he had mistaken for the taxiway. Although the pilot should have exercised better judgement, it has been determined that this same type of mishap has occurred before. After a…NTSB MIA86LA122Accident · No injuriesLimited investigationFinal reportCessna 172M · Borinquen, PRThe plt stated that after completing a local flt he landed on the rwy and noticed that the taxiway lights were inoperative where he wished to taxi. When he taxied off the rwy the propeller and landing gear struck a concrete culvert that was resting next to an…NTSB LAX86LA171Accident · No injuriesLimited investigationFinal reportCessna 172D · Mojave, CAThe acft wing struck a tree during taxi on a dirt road being used for takeoff. The CFI said that he did not make a survey to identify obstructions before the taxi for takeoff. The acft had landed on the road when the CFI could not regain eng power following a…NTSB CHI86FEE01Accident · Minor injuriesFinal reportCessna 172 · Marseilles, ILThe takeoff was being made from an arpt which is on the grounds of a golf course. During takeoff the nose wheel struck the raised terrain of a golf tee located aprx 75 ft left of the rwy 18 centerline and 1000 ft from the departure end of the rwy. The plt…NTSB LAX86FVM03Accident · No injuriesFinal reportBeech 65-A80 · Cuyama, CAThe acft contacted two cows while operating along the side of a road in a remote area. Vehicle tracks were found near the wreckage, however, no persons were found at or near the wreckage. Trained drug sniffing dogs were used at the accident site and it is…NTSB ATL86FLT05Accident · No injuriesFinal reportPiper PA-14 · Memphis, TNThe acft collided with an air compressor and a hangar door during taxi after the plt hand-propped the unoccupied acft. The ptl said that the thought the 'switches were off'.he was pulling the prop to 'loosen' the oil when the eng started and the acft started…NTSB MKC86LA069Accident · No injuriesLimited investigationFinal reportCessna 172N · Warren, ARThe plt reports that a deer ran in front of the acft during the flare for a night landing. The prop hit and killed the deer and the nose gear and bottom of the eng compartment were damaged. After the collision the plt said he smelled fuel fumes and when the…NTSB MKC86LA066Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Versailles, MOThe plt reports that he was hand propping the eng. He said the eng did not start on the first attempt and he primed it a second time. On the second try the eng started and the acft got away from the plt, taxied about 75 ft and collided with trees. The plt…