NTSB investigations, 1987
348 cases where the first occurrence was “Loss of control - in flight”.
Cases per year
| 1982 | 332 |
|---|---|
| 1983 | 466 |
| 1984 | 438 |
| 1985 | 425 |
| 1986 | 370 |
| 1987 | 348 |
| 1988 | 369 |
| 1989 | 320 |
| 1990 | 359 |
| 1991 | 354 |
| 1992 | 332 |
| 1993 | 304 |
| 1994 | 323 |
| 1995 | 280 |
| 1996 | 263 |
| 1997 | 264 |
| 1998 | 281 |
| 1999 | 263 |
| 2000 | 274 |
| 2001 | 248 |
| 2002 | 245 |
| 2003 | 279 |
| 2004 | 237 |
| 2005 | 281 |
| 2006 | 249 |
| 2007 | 299 |
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\" = 250)
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" = 250) 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 DEN88LA041Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-125 · Riverton, WYThe instructor plt and student were practicing forced landings to an open field. The instructor stated that he descended to approx 50 to 75 ft AGL over the intended landing area. He initiated a go around, pulled up and banked left to go over powerlines. At an…NTSB BFO88FA011Accident · 1 fatalField investigationFinal reportChampion 7ECA · Keymar, MDWitnesses heard and observed the aircraft takeoff, bank to the left, and nose down into the adjoining dirt field with no change in engine sound. Exam of the wreckage revealed that an elevator cable had separated at a point where grounding strap was found to…NTSB LAX88DUM02Accident · 1 fatalFinal reportBede BD-5 · Chula Vista, CANTSB NYC88LA059Accident · 1 fatalLimited investigationFinal reportCessna 170A · Sandwich, MAThe Cessna 170A was on an aerial photography flt. Witnesses rprtd the acft was flying slow at about 200 ft AGL when it began to settle. The witnesses then heard an increase in eng power & saw the acft pitch up. Subsequently, it 'fell off on a wing,' crashed…NTSB LAX88LA072Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Fallbrook, CAThe plt stated that while on short final to rwy 36, approx 5 to 6 ft AGL ovr the rwy, he noticed another acft approaching fm the opposite direction. He initiated a climbing right turn and collided with a tree located abt 150 ft to the right of the rwy…NTSB MKC88FA027Accident · Serious injuriesField investigationFinal reportBritish Aerospace BAE-3101 · Joplin, MOThe capt stated that he had planned the approach at a higher-than-normal airspeed and altitude due to a reported low level windshear. At 400 feet AGL the acft entered a light downdraft but the crew corrected the descent profile with power. At 200 feet AGL the…NTSB ATL88LA061Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Richmond Hts, OHThe plt began taking off on rwy 23 with a wind from 160 deg at 13 KTS. The tower ctlr saw the acft turn sharply to the left after lift-off & subsequently impact about 250' left of the rwy. The ctlr said the plt appeared to have 'jerked' the acft off of the…NTSB ATL88FA059Accident · 2 fatalField investigationFinal reportCessna 421A · Hilton Head Isl, SCAcft depted coastal arpt at night with 400 ft partial obscuration in patchy fog. Ground witnesses who heard acft depicted a circling flt path to the right after takeoff. Eng, prop & turbo teardowns demonstrated both engs were operating at high power & no…NTSB DCA88MA008Accident · 43 fatalMajor investigationFinal reportBritish Aerospace BAE-146-200 · San Luis Obispo, CAA recently discharged usair employee boarded psa flt 1771 after having left a goodbye message with friends. He bypassed security and carried abd a borrowed 44 caliber pistol. A note written by this psgr, found in the wreckage, threatened his former supervisor…NTSB SEA88LA029Accident · Minor injuriesLimited investigationFinal reportde Havilland DHC-2 MK1 · Metlakatla, AKOn final approach for landing the aircraft encountered high gusting winds. The aircraft then stalled and entered a nose down attitude. Accordng to one passenger the pilot was holding full aft elevator during the descent. The aircraft struck the water hard,…NTSB NYC88LA052Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Pottstown, PADuring soft field takeoff, the instructor pilot who was watching from the ramp, said the the student plt seemed to have excessive angle of attack and stalled the aircraft. The aircraft crashed on airport property about 1,000 feet from the start of the takeoff…NTSB CHI88DEP02Accident · Serious injuriesFinal reportBeech V35B · Waukesha, WIShortly after liftoff in IMC, the acft descended to the ground. The plt had been cleared for a rt turn but the controller noticed the acft turning left at about 50 ft AGL. The plt later could not stop the drifting to the left. The lndg gear was raised and the…NTSB FTW88FA033Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Commerce, TXThe purpose of the flight was to satisfy an insurance requirement that the owner receive 10 hours of dual instruction in this aircraft. The dual controls had been removed and the single control was on the left side. The aircraft was observed in a clockwise…NTSB ANC88FA021Accident · 3 fatalField investigationFinal reportCessna 185 · Fairbanks, AKThe pilot and his two passengers were returning from a hunting trip when the airplane crashed 7 miles from the Fairbanks international airport. The airplane struck the ground in a vertical attitude at a high rate of speed. Evidence at the scene suggests that…NTSB LAX88LA059Accident · Serious injuriesLimited investigationFinal reportHughes 369HS · Lihue, Kauai, HIPilot failure to maintain adequate main rotor RPM.NTSB DEN88FA030Accident · 2 fatalField investigationFinal reportBeech J35 · Knolls, UTThe last comm with the flt was when the plt contacted elko radio and requested the salt lake city wx. He reported that he was at 11500 ft and VFR on top. The specialist on duty was unable to provide the wx info due to a computer sys outage but recommended…NTSB NYC88LA044Accident · Minor injuriesLimited investigationFinal reportBell 206B · Beverly, MAThe helicopter was on a normal approach to Beverly airport and was cleared to cross runway 27 from the southeast. The pilot entered an autorotation but realized that the ground was under construction and was very muddy. In an attempt to shift directions at…NTSB ATL88FA044Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Commercial Pt, OHThe acft crashed on a wheat field during a night instrument training flt. The plt had declared a vacuum system failure about 40 minutes after take-off but he declined ATC assistance for a no-gyro approach to columbus. Two minutes after the radio call radar…NTSB DCA88MA005Accident · 18 fatalMajor investigationFinal reportBeech 1900C · Homer, AKDrg arr, the acft (ryan flt 103) crashed short of rwy 3. The fuselage stayed intact drg impact, but the belly structure was compressed & vertical deceleration forces exceeded the design capability of the seats. Rescue psnl had difficulty shutting off the…NTSB LAX88FA033Accident · Serious injuriesField investigationFinal reportBell 206L-3 · Rialto, CAThe pilot lost control of the recently painted helicopter during the takeoff. The paint shop personnel had moved the helo to a airplane parking spot. The helo skids straddled the tie-down chains. Two wing tie-down chains were incorrectly attached to the right…NTSB DEN88LA026Accident · Minor injuriesLimited investigationFinal reportBell 206B III · Albuquerque, NMWhile attempting to retrieve a parachute retarded rocket that came to rest in a tree by hooking the right front skid shoe under the chute, the parachute got hung up in the tree. The helicopter lifted the rocket approx 6 ft into the air before it swung into…NTSB LAX88FA047Accident · 2 fatalField investigationFinal reportCessna 152 · Bakersfield, CAThe recently rated private pilot and his passenger were flying low and waving to people on the ground. As the aircraft neared electrical service lines across its flight path ground witnesses observed it to enter an abrupt climb, roll left and dive into the…NTSB CHI88MA026Accident · 8 fatalMajor investigationFinal reportBeech 200 · Jefferson, WIWhile cruising abv frzg lvl at 12,000', the flt was clrd to dscnd & maint 9000'. Abt 1-1/2 min ltr, the flt declared a mayday (emergency). Radio & radar ctc were lost & the acft crashed in a nr vertical dscnt. Radar data showed that after starting a dscnt,…NTSB NYC88FA041Accident · 4 fatalField investigationFinal reportMooney M20C · St. Marys, PAWhile getting fuel, the pilot of the Mooney M20C and his 3 pals were attempting to remove frost with paper towels and plastic credit cards after being told by the fuel truck driver that the arpt had no ice removal solution. A witness stated that as the…NTSB DCA88MA004Accident · 28 fatalMajor investigationFinal reportMcdonnell Douglas DC-9-14 · Denver, COThe Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-88/09. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm…NTSB NYC88FA042Accident · 2 fatalField investigationFinal reportMooney M20K · Danby, VTThe pilot was on a VFR cross country flight when the aircraft descended rapidly and collided with trees. Several witnesses reported hearing extensive engine surges. Witnesses reported seeing the acft maneuvering in a highly erratic manner, then begin a nose…NTSB NYC88LA034Accident · No injuriesLimited investigationFinal reportCessna 170B · Shirley, MADuring final approach to runway 19 at Shirley, Massachusetts the aircraft rolled inverted. Pilot was able to correct and bring the aircraft upright but did not have enough altitude to clear trees. He set the aircraft into the trees and the wing folded back.NTSB FTW88FA024Accident · Serious injuriesField investigationFinal reportCessna 140 · Bryan, TXThe student plt took off at ngt with a passenger aboard. After takeoff, he remained in a left traffic pattern & made a low apch. Witnesses rprtd the plt then entered a rgt pattern, but the acft was lower & slower than normal as it was turning on the 2nd apch…NTSB NYC88LA035Accident · No injuriesLimited investigationFinal reportCessna U206F · New Bedford, MAThe Cessna U206F was taking off from a harbor. After becoming airborne it experienced a 40 knot airspeed loss. The plt stated that he was unable to maintain altitude and was forced to land on a beach. The acft flipped ovr after a pontoon caught a rock. A…NTSB FTW88DRG03Accident · Minor injuriesFinal reportHerman Dragonfly · New Braunfels, TXThe experimental, home built, aircraft was on its maiden fliht. The pilot stated he intended to fly the pattern for a check-out of the aircraft. The pilot indicated that he hoped to gain altitude early to permit returning to the field in case of an engine…NTSB NYC88DNE01Accident · 1 fatalFinal reportLamb Commander Elite · Meriden, CTThe pilot's failure to maintain control of the homebuilt gyrocopter while preforming low level 'fast taxi' maneuvers.NTSB DEN88FA021Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Durango, COThe two pax had chartered N8266U for a sightseeing flight of the local area. The charter plt, a CFI found that one of the pax was a plt and permitted him to fly the acft. The pax expressed an interest in spotting elk and flew the acft into a canyon, below the…NTSB MIA88FA025Accident · Serious injuriesField investigationFinal reportTaylorcraft DC-65 · Davie, FLShortly after takeoff during the crosswind to downwind turn at an alt of aprx 50 ft, the acft stalled, spun to the left, & due to the low altitude the plt was unable to recover prior to impact in a left wing low nose down attitude. Postcrash examination of…NTSB LAX88FA032Accident · 2 fatalField investigationFinal reportRobinson R22A · Moraga, CAA divergence of the main rotor from its normal plane of rotation for an undetermined reason, which resulted in rotor contact with the cockpit area.NTSB DEN88LA020Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Monte Vista, COThe plt attempted to take off on a frost-covered, pvt airstrip. Witnesses observed the aircraft become airborne before it settled back down to the ground. Control of the acft was lost and the acft nosed over.NTSB NYC88DHA01Accident · 2 fatalFinal reportCouden Skybolt · Mansfield, NJWitnesses observed acft performing multiple aerobatic maneuvers. They said airplane was performing vertical maneuver or nearing top of loop when it entered an inverted flat spin. Rotation was stopped, but recovery incomplete when airplane crashed in a hay…NTSB ATL88LA027Accident · No injuriesLimited investigationFinal reportAero Commander 100 · Moultrie, GAThe plt took off to the north at the private, sod airstrip. He rptd that the acft began to 'drop' shortly after liftoff. He then attempted to arrest the descent by increasing the nose-up pitch angle, and the acft 'began to stall'. He aborted the takeoff and…NTSB ATL88FA025Accident · 1 fatalField investigationFinal reportMooney M-18C-55 · Camden, OHThe pilot took off downwind and did not use all of the available runway. With insufficient airspeed, the aircraft stalled shortly after takeoff. The pilot was unable to recover within the altitude remaining and collided with an oncoming train.NTSB NYC88LA022Accident · Serious injuriesLimited investigationFinal reportSchweizer 2-33 · Blairstown, NJAs the glider was being towed it lifted too high above the tow plane. At an altitude of about 55 to 65 feet it was disconnected. However the glider was tilting slightly to the right and as the pilot attempted to correct, it stalled and crashed.NTSB CHI88FA012Accident · 2 fatalField investigationFinal reportBellanca 8KCAB · Lawrenceville, ILWhile performing aerobatic maneuvers the aircraft entered a spin to the left and did not recover before impacting the ground. The acft entered the spin after the plt announced that this spin would be the last maneuver before landing. The spin was started at…NTSB MIA88FA023Accident · 2 fatalField investigationFinal reportCessna 150E · Aguadilla, PRWitnesses observed the acft maneuvering a low alt over ocean water near a shoreline. They saw it pull up sharply to clear a commercial boat dock, then nose over & impact the water in a nose low, rgt wing low attitude. The acft sank & came to rest in 30' of…NTSB SEA88LA014Accident · No injuriesLimited investigationFinal reportBell 47G2 · Lebanon, ORThe student was performing an autorotation at about 50' AGL and the flare was begun. The instructor pilot noticed that the helicopter was not leveling and took control of the aircraft. The helicopter settled tail low onto the soft ground striking the tail…NTSB FTW88DPJ02Accident · Serious injuriesFinal reportPiper PA-25 · Catoosa, OKThe pilot stalled the aircraft while turning downwind during a practice agricultural operation. The aircraft impacted the ground out of control. The pilot stated that he could not recall anything about the flight.NTSB NYC88LA014Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Mansfield, MAThe Schweizer SGS-2-33A was in the traffic pattern with a student pilot and flight instructor. In the right turn from base to final, the nose dropped and control was lost. The flight instructor took control of the aircraft, and regained control, however,…NTSB FTW88LA012Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Mckinney, TXDuring flare/touchdown with full flaps the aircraft bounced. The student pilot in an attempt to go-around failed to retract the flaps. The aircraft stalled contacting some trees and subsequently the ground, damaging the left wing, right wing, and the…NTSB CHI88FA008Accident · 4 fatalField investigationFinal reportCessna 310 · Brownton, MNAcft crashed in open farm field during night dark conditions witness heard loud roar of engs then a hard dull thud and then silence. Angle of impact was near vertical. Engs were buried 8FT and dist of wreckage was confined to within the dimensions of acft.…NTSB FTW88DQG02Accident · Serious injuriesFinal reportAir Tractor AT-301 · Lockney, TXAfter completing a swath run, the plt began a procedure turn to the right for another run. During the maneuver, the acft stalled & turned counterclockwise for about 180 deg before impacting the ground in a nose down, left wing low attitude.NTSB ATL88LA017Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Clarks Hill, SCThe aircraft was circling about 200 feet above the trees when the pilot began a climbing turn. As he leveled the wings the aircraft began to descend. The pilot applied full power and eased forward on the control stick lowering the aircraft nose slightly. When…NTSB ANC88FA011Accident · 3 fatalField investigationFinal reportPiper PA-18 · Homer, AKThe weather between Homer and anchorage included marginal conditions along segments of the route. The airline transport rated pilot was encouraged to take advantage of an offer to travel by automobile and still arrive in time for a commitment in anchorage. He…NTSB LAX88DXQ01Accident · Serious injuriesFinal reportPugh LONG-EZ · Newell, CABefore taking off, the plt noted that the wind sock was 'whipping & was about 3/4 full.' He said that after takeoff, he made a flyby at about 50' AGL, with an airspeed of about 150 mph. He then entered a steep climbing right turn. The plt estimated that at…