NTSB investigations, 1987
79 cases where the first occurrence was “On ground/water collision with object”.
Cases per year
| 1982 | 106 |
|---|---|
| 1983 | 103 |
| 1984 | 95 |
| 1985 | 80 |
| 1986 | 69 |
| 1987 | 79 |
| 1988 | 70 |
| 1989 | 67 |
| 1990 | 64 |
| 1991 | 67 |
| 1992 | 65 |
| 1993 | 55 |
| 1994 | 64 |
| 1995 | 57 |
| 1996 | 51 |
| 1997 | 51 |
| 1998 | 77 |
| 1999 | 66 |
| 2000 | 57 |
| 2001 | 60 |
| 2002 | 63 |
| 2003 | 52 |
| 2004 | 46 |
| 2005 | 50 |
| 2006 | 52 |
| 2007 | 29 |
Where
Open the mapLatest cases
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 year(c.\"eventDate\") = 1987
AND 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 year(c."eventDate") = 1987 AND 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 DEN88LA045Accident · No injuriesLimited investigationFinal reportRaven Rally RX7 · Dona Ana, NMThe commerical plt was conducting a sightseeing flight in his balloon. After a one and one half hour flight, he landed beside a paved road. The envelope collapsed over a power line. The ground crewman somehow contacted the balloon and was electrically…NTSB MIA88IA072Incident · No injuriesIncident investigationFinal reportBoeing 727-231 · Miami, FLPlt was instructed to turn the tail to the right as viewed by the signal man during power back. As power back started the tail was turned to the left as viewed by the signal man. The signal man corrected this turn but the acft was now making a much larger arc…NTSB DEN88IA043Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-80 · Denver, CODuring landing roll the acft struck a taxiway marker. Visibility was reported by RVR to be 2200. Actual visibility was near zero due to blowing snow. Plt stated he did not lose cntrl but finite cntrl not possible due to lack of visibility and cross winds of…NTSB MIA88LA075Accident · No injuriesLimited investigationFinal reportBoeing 727-200 · San Juan, PRN705AA was number two in position for takeoff behind N893AA. N705AA received takeoff clearance first and as it began to taxi to the runway it's left wing tip struck and passed under the right wing tip of N893AA.NTSB NYC88LA060Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Flushing, NYAs the plts were taxiing at dusk to takeoff, the acft was struck by a food svc van at a vehicle svc road. The acdnt occurred as rain was falling & the ramp area was wet with standing water. The van driver said he had just maneuvered his vehicle to the left to…NTSB NYC88LA063Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Plymouth, MAThe aircraft was taxiing from a shop on the airport to runway 24 for a south end departure. The pilot stated that the left wing of the aircraft made contact with the parked truck causing substantial damage.NTSB LAX88LA074Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Los Angeles, CAWhile taxiing after landing, N911E was instructed to taxi to a position and hold, en route to that position, the acft collided with N75397 that was also holding in the same position. The plt of N911E stated that he did not see the acft due to moisture that…NTSB LAX88LA073Accident · No injuriesLimited investigationFinal reportCessna 195A · Burbank, CAWhile holding short of the active rwy, the number one acft,N4309Y, was having radio problems. The tower began to clear other acft for takeoff. Two acft were able to get around the number one acft and takeoff. The third acft cleared to taxi into position did…NTSB MKC88FA028Accident · No injuriesField investigationFinal reportAero Commander 680FL · Kansas City, MOAt 2108:57 ea flt 275(EA275) a Boeing 727, was cleared to takeoff on runway 19 and at 2110:24 N6509V, an Aero Commander,was cleared to taxi into position and hold. N6509V entered runway 19 near mid-field at taxiway A-3 without advising the tower of his intent…NTSB SEA88LA030Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Aurora, ORA single engine aircraft was taxiing from the south end of the ramp area to the runway. A twin engine aircraft entered the taxiway in front of the single engine aircraft from the right of the taxiway. The single engine aircraft struck the twin engine aircraft…NTSB NYC88LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28-150 · Middletown, PAAfter landing the pilot was cleared to taxi to the parking area at stanbaugh's general aviation. During a maneuver between a de-icer truck and a parked airplane, the pilot allowed the aircraft to become too close to the truck and caught the wing tip on the…NTSB SEA88LA027Accident · No injuriesLimited investigationFinal reportCessna 172M · Tacoma, WAThe Cessna was at the runup area for runway 35 preparing to do his runup. Three pitts aircraft were taxiing abreast of each other, when one of the pitts's propeller struck the right wingtip of the Cessna causing substantial damage to the Cessna and minor…NTSB CHI88LA025Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Manitowoc, WIThe pilot and his two pax were on takeoff roll at the local, uncontrolled arpt. The pilot stated that just prior to rotation a deer ran onto the runway and the right wing struck the deer. The pilot aborted the takeoff without incident.NTSB ATL88IA036Incident · No injuriesIncident investigationFinal reportLockheed L-188C · Atlanta, GAAfter two aborted takeoffs for a RPM fluctation problem at takeoff pwr, the crew retd to the cargo ramp. They parked the acft, with engines running, adjacent to the gnd pwr cart used for starting the engines. The pwr cart had been left unattended with the…NTSB CHI88LA021Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Detroit, MIThe plt of north American P-51D, N6341T, was southbound on twy alpha as the plt of Piper PA-28 cherokee, N8253E, taxied from the run-up area to the hold line for rwy 33, which was near the intxn of twys alpha & india. The plt of the tail- wheel equipped P-51…NTSB CHI88LA013Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Leavenworth, INAccording to the pilot, the aircraft was taking off from a 'bumpy' grass private strip. The pilot stated he discussed aborted takeoff procedures with the pilot rated passenger who was sitting in the right seat and stated if the aircraft did not reach takeoff…NTSB CHI88LA006Accident · No injuriesLimited investigationFinal reportCessna 150J · Springfield, ILWhile taxiing back to the parking ramp, after a short instructional flight, the student and flight instructor were looking ahead into the parking area for a vacant parking place. While they were searching for a place to park, the right wing of the aircraft…NTSB LAX87LA348Accident · No injuriesLimited investigationFinal reportCessna 175 · Camp Verde, AZWhen both passengers became air sick the pilot decided to land on a dirt road. Upon touchdown, the pilot heard a loud pop and assumed that a tire had blown. Because of this, he used the brakes sparingly and could not stop the aircraft in time to avoid trees.…NTSB MIA87LA247Accident · No injuriesLimited investigationFinal reportBeech 200 · Tampa, FLThe plt stated that as he was taxiing to the ramp, his attention was momentarily diverted away from the clearance between the left side of the wing tip & the building's steel support when the trailing edge of the aileron contacted the support.NTSB ATL87LA254Accident · No injuriesLimited investigationFinal reportAerostar 600 · Columbus, OHThe scheduled domestic all cargo flt was taxiing from the ramp to the rwy behind another company acft when the plt suddenly realized that the lead acft was not moving. The plts attempts to stop the acft were not successful. The stopped acft was substantially…NTSB ATL87FA250Accident · Minor injuriesField investigationFinal reportBritish Aerospace 3101 · Atlanta, GAThe airplane was struck by an eastbound, airline employee bus while taxiing south on the ramp to the assigned gate. The bus impacted the acft rt wing tip. A pax in the bus reported that she warned the bus driver to watch out for the airplane prior to the…NTSB SEA87LA183Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Star, IDThe aircraft was to the left of the centerline during takeoff run on the 60 foot wide airstrip. A cross wind was present from the right. The aircraft's left wing struck a person standing close to the runway edge. The pilot stated that he had his eyes on his…NTSB DEN87LA236Accident · No injuriesLimited investigationFinal reportLet L-13 · Buena Vista, COThe plt was ferrying the glider to Buena Vista, Colorado & had previously obtained permission to land on a closed rwy. After being towed to the Buena Vista area, he released the glider from the tow plane & flew in the local area for about 40 min. He then…NTSB DEN87LA232Accident · No injuriesLimited investigationFinal reportNational Balloon 858 · Colorado Spring, COThe commercial balloon plt was competing in a balloon race. While landing, with the basket on the ground, the balloon drifted into power lines. A large hole was burned in the envelope, and the basket was damaged. The plt and two passengers jumped from the…NTSB NYC87MA236Accident · No injuriesMajor investigationFinal reportMcdonnell Douglas DC-8-63 · Newburgh, NYThe wx was deteriorating as airborne express flt 124 & rosenbalm flt 074 were on successive arrivals for an ILS rwy 9 apch. Flt 124 was clrd for the apch & lndd. After lndg, the LCL ctlr (l/c) instructed flt 124 to back taxi on the rwy & rprt when clr of the…NTSB LAX87LA308Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Ehrenberg, AZWhile on a x-country flt, the student plt elected to land on a road aprx 12 mi short of his destn to 'check on a job.' He said he was familiar with the road & decided to make a straight-in apch w/o first flying over it to look for obstructions. After making…NTSB NYC87LA229Accident · No injuriesLimited investigationFinal reportLake LA-4 · Lake George, NYWhile taking off from a Lake, the amphibious aircraft struck an object. The plane settled back into the water breaking the windshield on the passenger's side. The cockpit began filling with water and the acft sank in about 45 feet of water.NTSB NYC87LA231Accident · No injuriesLimited investigationFinal reportCessna 172 · Islip, NYAfter landing on an instructional flight, Cessna 172, N9425D, experienced brake failure due to a broken hydraulic fluid line. N9425D rolled into another Cessna. Both aircraft received sustantial damage.NTSB NYC87LA228Accident · No injuriesLimited investigationFinal reportCessna 172 · Groton, CTThe aircraft was taxiing to the ramp after landing. While the pilot was maneuvering the aircraft into a parking space, the aircraft was positioned in such a way that the sun had blinded him temporarily. As the pilot turned the aircraft the left wing contacted…NTSB FTW87LA182Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · San Benito, TXDrg the landing roll, the acft's left wing struck a tv camera man, who was standing at the left edge of the rwy, aprx 1200' from the threshold. The acft then veered off the left side of the rwy & the right main gear collapsed. Witnesses stated the camera man…NTSB LAX87DVA10Accident · No injuriesFinal reportGrumman G-164B · Taft, CADuring a repositioning flight, the plt landed the aircraft on a dirt road. During the landing roll the left wing struck an irrigation standpipe. The aircraft turned rapidly which collapsed the main landing gear. There were no mechancial failures or…NTSB DEN87LA212Accident · No injuriesLimited investigationFinal reportCessna 414 · Cuba, NMThe acft was dispatched to the Cuba, NM area to pick up a critically ill patient. The state police blocked off a section of highway for the acft to land on. The plt landed on the highway, but drg the landing roll, the underside of the rgt wing struck a road…NTSB LAX87LA284Accident · Serious injuriesLimited investigationFinal reportRaven S77A · Tucson, AZDuring a local sightseeing balloon flight, the plt was making a landing at an open construction site. The gondola touched down then skipped three times and came to rest on the edge of a ledge aprx 10 ft in height. The balloon tipped over the edge and collided…NTSB ANC87LA109Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Levelock, AKAs the pilot of the Piper PA-18 airplane was completing his landing roll at the unattended airport, three children, riding an all terrain vehicle (atv), pulled onto the runway and were struck by the right side of the acft. The pilot attempted to avoid the…NTSB MIA87LA214Accident · No injuriesLimited investigationFinal reportBoeing 747-287B · Miami, FLDuring lndg the entire length of the rwy was used due to an inop no 2 eng reverser. Only brakes were used to slow down the acft and taxi to the gate. The plt stated that he had arrived at the gate, set the parking brake, and was notified that the wheel chocks…NTSB LAX87LA283Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Galt, CADuring the takeoff ground roll on a 2000 ft private runway, at the point to rotate, the plt applied back pressure, however, the aircraft did not respond. Aprx three quarters of the way down the rwy the plt realized that the acft was not lifting off and he…NTSB ANC87LA104Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Charley River, AKThe pilot stated that during the takeoff roll he struck a hidden tree stump; he lost directional control of the aircraft causing the plane to nose over.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…