OpenAirDocs.org

NTSB investigations, 1987

187 cases where the phase of flight was Takeoff.

Cases per year

19622026

Where

Open the map

Latest cases

Query with SQL
duckdb -csv -c "WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
    crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
    current_codes AS (
      SELECT e.case_mkey, TRY_CAST(e.\"tier1Number\" AS INTEGER) AS code,
        row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e.\"isDefiningEvent\", false) DESC, e.position) AS n
      FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
      WHERE e.aircrafts_position = 1 AND e.\"tier1Number\" GLOB '[1-9][0-9]*'
        AND (e.\"isDefiningEvent\" OR e.case_mkey IN (SELECT \"mKey\" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE \"isPre1982\"))
    ),
    phases AS (
      SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
      FROM current_codes WHERE n = 1
      UNION ALL
      SELECT o.case_mkey, 'older', o.\"phaseOfFlightCode\", w.main
      FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o.\"phaseOfFlightCode\"
      WHERE o.aircrafts_position = 1 AND o.\"occurrenceNumber\" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
    ),
    case_phases AS (
      SELECT p.*, c.\"eventDate\", c.\"highestInjuryLevel\" = 'Fatal' AS fatal, a.aircraft_model_code
      FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = p.case_mkey
      LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
      WHERE c.\"eventDate\" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
    )
  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 case_mkey FROM case_phases WHERE main = 300)
  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.

NTSB MKC88LA035Accident · No injuriesLimited investigationFinal reportCessna 182Q · Davenport, IAThe PIC had chosen rwy 15 for the LOC app and was cleared by approach control. The PIC stated that he cancelled his IFR flt plan entering clear conditions at 3,000 ft. the PIC further stated that he planned an approach using a ltl higher spd for the gusty…Dec 31, 1987 · N96934 · Substantial damageNTSB DEN88LA040Accident · No injuriesLimited investigationFinal reportBeech A36 · Angel Fire, NMThe private plt and five pax were returning home from a skiing trip. During takeoff the acft encountered a left crosswind from 270 degrees, at an estimated 40 knots. The plt lifted off early, then the wind pulled. The acft stalled and impacted right of the…Dec 23, 1987 · N27LH · Substantial damageNTSB DEN88LA038Accident · No injuriesLimited investigationFinal reportCessna T210R · Bismarck, NDThe plt was attempting to takeoff at dusk on a gravel road. The acft veered off of road and hit a ditch.Dec 19, 1987 · N7381U · Substantial damageNTSB ANC88FA022Accident · Minor injuriesField investigationFinal reportCessna 208 · Bethel, AKThe plt had planned to back taxi for takeoff on rwy 36. The tower controller asked if a rwy 18 departure would be acceptable to accommodate an arriving acft & the plt accepted a clnc. He started his takeoff with 3900' remaining on the 6399' rwy. After initial…Dec 19, 1987 · N9438F · Substantial damageNTSB NYC88LA023Accident · No injuriesLimited investigationFinal reportGulfstream American AA-5B · Morristown, NJThe Gulfstream-american AA5B was making a takeoff with a flight instructor and student pilot on board. At 65 knots during the takeoff, a deer was struck on the runway and killed. The takeoff was aborted on the runway. The student pilot and flight instructor…Nov 30, 1987 · N4533Q · Substantial damageNTSB CHI88LA029Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Lake City, MIThe student pilot initiated a takeoff from a snow covered runway. During the initial ground run, he lost directional control. Subsequently, the aircraft ran off the side of the runway & collided with trees. The plt rprtd the wind was from the south at 8 to 10…Nov 22, 1987 · N9817W · Substantial damageNTSB LAX88DUQ02Accident · Minor injuriesFinal reportIsgrigg Elite · Tehachapi, CAThe homebuilt gyroplane became uncontrollable during take-off roll on runway 27R. The aircraft pitched up and then rolled on its left side. The national weather service reported the winds in the area at the time of the accident to be from 290 degrees at 12-15…Nov 21, 1987 · N333JE · Substantial damageNTSB 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…Nov 19, 1987 · N66WL · Substantial damageNTSB LAX88LA044Accident · No injuriesLimited investigationFinal reportBeech D18S · Mokuleia, HIThe plt rprtd that he had made a normal preflight, but after the acft had rolled about 200 to 250 ft on the takeoff roll, the nose gear collapsed. The acft came to rest with damage to the nose section, props & engs. Drg an inspn of the acft, the landing gear…Nov 15, 1987 · N802H · Substantial damageNTSB 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.Nov 14, 1987 · N47622 · Substantial damageNTSB DEN88LA022Accident · No injuriesLimited investigationFinal reportCessna 182N · Albuquerque, NMThe plt reported that she was making a touch and go. She said as she applied full power to takeoff the acft veered to the right. She was unable to realign the acft with the rwy and elected to continue the takeoff and 'pulled the acft off at a speed below…Nov 9, 1987 · N9209G · Substantial damageNTSB LAX88LA026Accident · Minor injuriesLimited investigationFinal reportCessna 182H · Willcox, AZThe plt reported that the takeoff ground roll was unusually long. After liftoff the acft stayed in ground effect until just before the end of the rwy then climbed to aprx 100 ft. the plt landed in a soft field. During the landing roll the acft nosed over.…Nov 4, 1987 · N8411S · Substantial damageNTSB 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…Nov 2, 1987 · N28483 · Substantial damageNTSB CHI88IA015Incident · No injuriesIncident investigationFinal reportBoeing 737-322 · Chicago, ILThe south rwys (32L, 9R, & 4R) were being ctld by the south LCL ctlr (slc) & the north rwys (9L & 4L) were ctld by the north LCL ctlr (nlc). At 1543:26, slc told united flt 973 (Boeing 737) to hold on 32L & expect a 3 min delay bfr tkof. Air Wisconsin flt 954…Oct 29, 1987 · N305UA · 2 aircraft · No damageNTSB DEN88LA012Accident · Minor injuriesLimited investigationFinal reportBeech C35 · Ekalaka, MTDuring the takeoff roll the pilot encountered an unexpected tailwind. The pilot reported that he tried to abort the takeoff but tall grass and the tailwind did not allow the aircraft to decelerate properly. The aircraft ran through two drainage ditches and…Oct 21, 1987 · N2028D · DestroyedNTSB ANC88LA010Accident · No injuriesLimited investigationFinal reportCessna A185 · Karluk, AKThe pilot arrived late and the tide had come in at the beach in kanatak bay. By the time he commenced his takeoff attempt, the usable area had diminished considerably. The right main gear caught in the surf and the airplane inverted in the water.Oct 21, 1987 · N61376 · Substantial damageNTSB SEA88LA006Accident · No injuriesLimited investigationFinal reportCessna 206 · Winnemucca, NVThe acft nose gear collapsed during takeoff and the acft nosed over. The plt stated to inspectors that recent maintenance had been performed on the nose gear. Shortly after the accident the acft was locked in a hangar. The plt has failed to file an accident…Oct 14, 1987 · N9040M · Substantial damageNTSB ANC88LA006Accident · Minor injuriesLimited investigationFinal reportCessna 207A · Tin City, AKThe pilot stated the wind was a direct crosswind and the velocity was 30 knots gusting to 38 knots. During the take off roll, the airplane lifted off the ground and then settled and ran off the end of the runway.Oct 14, 1987 · N91021 · Substantial damageNTSB MKC88FA003Accident · Serious injuriesField investigationFinal reportStinson 108-2 · Wakeeney, KSThe owner & his son, who were both plts, initiated a midfield takeoff from their pvt dirt airstrip which was on soft uneven terrain. The son rprtd that near the end of the strip, power was 'cut.' The acft contd about 200' beyond the dep end of the strip &…Oct 12, 1987 · N448C · Substantial damageNTSB ANC88LA007Accident · No injuriesLimited investigationFinal reportCessna 170 · King Salmon, AKThe plt rprtd there was frost on the acft & that a rope had been used to smooth it off. He then initiated a takeoff from a dry lake bed. After lift-off, the acft settled back to the ground & struck a berm at the end of the takeoff area.Oct 12, 1987 · N1311D · Substantial damageNTSB NYC88LA003Accident · No injuriesLimited investigationFinal reportCessna 172H · Oneonta, NYThe plt rprtd he started to depart from rwy 13 with the wind from the south at 15 gusting 25 KTS. He stated the acft was not climbing as expected so he elected to land on the remaining rwy. He stated the wind gusts were strong from the right rear. He said he…Oct 6, 1987 · N1677F · DestroyedNTSB ATL88IA074Incident · No injuriesIncident investigationFinal reportMooney M-20E · Columbia, SCDuring takeoff the propeller studs failed and the propeller departed the acft. FAA incident rpt stated that propeller had been overhauled and replaced 32 hours prior to the separation. Metallurgical exam of the propeller studs revealed fatigue failure of the…Oct 6, 1987 · N1936Y · Minor damageNTSB LAX88LA005Accident · Minor injuriesLimited investigationFinal reportBeech A35 · Wickenburg, AZDuring the takeoff run, the plt realized he had a flt control problem when he was unable to rotate the acft for lift- off. He stated that he contd the takeoff, attempting to overcome the problem with elevator trim. He was unable to establish a climb.…Oct 4, 1987 · N8583A · Substantial damageNTSB CHI88DEP01Accident · Minor injuriesFinal reportGrumman G-44 · Delevan, WIOn initial takeoff roll the aircraft experienced a loss of control in a strong crosswind, departed the runway to the left, struck a tree line and over turned.Oct 1, 1987 · N1173V · Substantial damageNTSB ANC88LA001Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Fairbanks, AKThe plt stated that during tkof roll he lost directional ctl of the acft which caused it to exit the rwy. It then struck a rwy light and nosed over.Oct 1, 1987 · N5373H · Substantial damageNTSB NYC87LA237Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Stow, MAThe pilot was on takeoff roll when he decided to abort. He stated that he felt the engine was not developing adequate power and the airspeed was not up to required takeoff speed. The aircraft continued off the end of the runway and inverted in swampy soil.Sep 27, 1987 · N4332N · Substantial damageNTSB CHI87LA222Accident · No injuriesLimited investigationFinal reportCessna 150H · Sparta, WIThe plt was taking off on his pvt strip in a prevailing 12 kt x-wind that was vrbl & blowing fm a 'lull' to 18 KTS. He said the strip was located near an l-shaped ridge which attenuated the general wind flow. Also, he said the 1900' sod strip sloped downhill…Sep 27, 1987 · N6469S · Substantial damageNTSB NYC87LA254Accident · Minor injuriesLimited investigationFinal reportBeech E55 · Block Island, RIJust before lift-off, after the aircraft had accellerated to about 115 mph, the door on the passenger's side came open. The pilot immediately aborted the takeoff, but was unable to stop on the remaining portion of the 2500' runway. After departing the runway,…Sep 26, 1987 · N4158A · Substantial damageNTSB DEN87LA239Accident · Minor injuriesLimited investigationFinal reportCessna 195 · Colorado Sprgs, COThe plt stated that after he lndd to pick up a pax, he engaged the control lock fm habit, but did not shut dwn the eng. He got clnc to taxi back to the rwy & takeoff, but 'forgot to release control lock.' The Cessna 195 has a combination control lock and…Sep 25, 1987 · N3006B · Substantial damageNTSB CHI87DEC05Accident · No injuriesFinal reportWilli/Bensen B-8M · Fraser, MIDeterioration of the internal surface of the fuel tank which led to blockage of the fuel flow and subsequent fuel starvation of the engine.Sep 25, 1987 · N2469 · Substantial damageNTSB FTW87LA227Accident · No injuriesLimited investigationFinal reportCessna 152 · Mckinney, TXDrg a practice touch-&-go landing, the plt raised the flaps after making a normal lndg & applied full power for a go-around. However, the acft veered off the left side of the rwy & contacted soft ground. Subsequently, the nose gear collapsed & the left wing…Sep 24, 1987 · N67439 · Substantial damageNTSB CHI87DEX09Accident · Serious injuriesFinal reportde Havilland Dragonfly DH-90 · Sellersburg, INAircraft began left drift during takeoff roll. Pilot corrected with right rudder, and aircraft veered sharply right. Aircraft did not respond to application of left rudder or increased thrust from right engine; departed runway and crashed into drainage ditch.…Sep 22, 1987 · N190DH · Substantial damageNTSB ANC87LA163Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Talkeetna, AKThe airplane was substantially damaged after it nosed over during the takeoff roll, but the pilot and his passenger were uninjured. The pilot stated that he had landed at an off-airport site to set up his moose hunting camp and that during a subsequent…Sep 22, 1987 · N90947 · Substantial damageNTSB MIA87IA256Incident · No injuriesIncident investigationFinal reportGates Learjet 36A · Tyndall Afb, FLThe captain aborted the takeoff at 124 KTS after hearing an explosive sound, feeling the aircraft swerve, and seeing debris from a main wheel rim and brake being thrown forward of the aircraft. The aircraft continued down the runway, barely controllable and…Sep 21, 1987 · N900MD · Minor damageNTSB ANC87LA166Accident · No injuriesLimited investigationFinal reportCessna 170A · Melozitna River, AKThe pilot attempted to takeoff from a River sandbar close to the water's edge. During the take off roll, one main landing gear tire entered the water and pulled the airplane into the water. The airplane subsequently nosed over and incurred substantial damage.Sep 21, 1987 · N9240A · Substantial damageNTSB ANC87LA164Accident · No injuriesLimited investigationFinal reportInterstate S-1B2 · Beluga River, AKThe pilot landed on a small lake, decided it was too small and attempted to take off. He was unable to attain lift off speed prior to striking the opposite bank with his floats and subsequently damageing the airplane.Sep 20, 1987 · N50AA · Substantial damageNTSB ANC87LA169Accident · No injuriesLimited investigationFinal reportCessna 185 · Wind River, AKThe pilot and his passenger had camped over night on a gravel bar on the Wind River. On departure the following day, the airplane failed to become airborne prior to reaching the end of the gravel bar. The airplane entered the shallow water surrounding the…Sep 16, 1987 · N1050F · Substantial damageNTSB ANC87LA147Accident · No injuriesLimited investigationFinal reportCessna 170B · Skwentna, AKThe pilot stated that during the take off roll he lost directional control of the aircraft causing the aircraft to nose over. He also indicated that the private strip was new and that the dirt rwy was wet and soft.Sep 15, 1987 · N3410D · Substantial damageNTSB 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…Sep 7, 1987 · N4944D · Minor damageNTSB ANC87LA148Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Gold King, AKThe pilot stated that during the take off roll he lost directional control of the aircraft causing the aircraft to exit the strip into a row of trees.Sep 7, 1987 · N1265A · Substantial damageNTSB ANC87LA141Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Talkeetna, AKThe pilot attempted to take off from an unimproved site while the inside of the airplane's windows were partially obscured with condensation. The airplane struck a rock with its main gear during the take off roll and became prematurely airborne. The pilot…Sep 6, 1987 · N8CK · Substantial damageNTSB ANC87FA140Accident · 1 fatalField investigationFinal reportLake LA-4-200 · Coal Lake, AKThe pilot of the airplane stated that he had step-taxied to the east end of the Lake in preparation for a takeoff to the west. During the take off run, the airplane struck the wake he had just created and became prematurely airborne. He reduced power in an…Sep 5, 1987 · N39450 · DestroyedNTSB CHI87LA207Accident · No injuriesLimited investigationFinal reportCessna 150L · Ludington, MIDrg the takeoff roll, the acft went off the left side of the rwy. The student rprtd the takeoff roll seemed normal untilrotation, but when the nose wheel lifted off the rwy, the acft began to veer to the left. He stated he was unable to correct the situation…Sep 3, 1987 · N7502G · Substantial damageNTSB ANC87LA134Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kwethluk, AKThe pilot stated that he was flying a search and rescue mission for a missing aircraft when he noticed that his airspeed indicator was not working. He landed on a lake in gusty wind conditions to correct the problem. During the ensuing takeoff attempt, a gust…Sep 2, 1987 · N7233K · Substantial damageNTSB CHI87LA206Accident · No injuriesLimited investigationFinal reportCessna 152 · Phillips, WIDuring the takeoff phase of a touch and go landing the student pilot lost directional control of the aircraft. The aircraft exited the runway to the left, struck a ditch and overturned. The student's instructor, who was a witness to the accident states that…Aug 30, 1987 · N67795 · Substantial damageNTSB SEA87LA177Accident · Serious injuriesLimited investigationFinal reportCanton Rutan Long · Port Townsend, WADuring takeoff roll the pilot noted sluggish rotation performance and retarded the throttle to abort the takeoff. When he reduced power the aircraft rotated. He reapplied full power and abrupt aft stick, to execute rapid rotation and lift off. The hand grip…Aug 26, 1987 · N252BC · Substantial damageNTSB MKC87LA168Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Holly Grove, ARThe pilot lost control on takeoff roll, ran off the side of the runway and impacted a dirt bank. The aircraft came to rest in an inverted position. Investigation revealed no preimpact mechanical malfunctions/failures.Aug 26, 1987 · N8365K · Substantial damageNTSB LAX87LA314Accident · No injuriesLimited investigationFinal reportCessna 172N · Temple Bar, AZThe stall warning horn sounded during climbout following a touch-and-go landing. Rising terrain was reported beyond the end of the runway and the pilot was unable to continue to climb while maintaining a safe airspeed. The density altitude was approximately…Aug 25, 1987 · N733TA · DestroyedNTSB BFO87LA058Accident · Minor injuriesLimited investigationFinal reportBeech D50C · Somerville, VAThe nose gear prematurely retracted and the props contacted the gravel runway during the takeoff initial climb. The plt attempted to continue the takeoff and the acft settled into trees off the departure end of the rwy. Post-accident inspection failed to…Aug 23, 1987 · N81CA · Substantial damageNTSB DEN87DTI01Accident · No injuriesFinal reportCessna A188B · Basin, WYThe plt was taking off on a private, 2300 ft, dirt, ag strip with a load of chemicals. The arpt elev was 4185 ft & the rprtd temp was 74 deg. The plt said the wind was calm when he began his takeoff roll, but about 3/4 of the way down the rwy, the acft…Aug 22, 1987 · N72414 · Substantial damage