OpenAirDocs.org

NTSB investigations, 1987

699 cases where the phase of flight was Landing.

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 = 550)
  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 NYC88LA061Accident · No injuriesLimited investigationFinal reportCessna 172 · Concord, NHThe aircraft was landing at Concord municipal airport, and during landing roll, the aircraft veered to the left leaving the runway surface and nosed over in the field between the taxiway and runway 35.Dec 31, 1987 · N5383R · Substantial damageNTSB CHI88LA038Accident · No injuriesLimited investigationFinal reportCessna 210-5 · East Lansing, MIThe aircraft was landed at night on runway 9 which is 2530' in length with a 600' displaced threshold. This runway was ice covered and winds were recorded 25 minutes before the accident at a reporting facility 5 nautical miles west of the accident site as 160…Dec 31, 1987 · N1802Z · Substantial damageNTSB DEN88FA044Accident · Serious injuriesField investigationFinal reportSwearingen SA-26AT · Telluride, CODuring a visual apch, the plt said he encountered 2000 fpm downdrafts. The plt stated he added power and executed a normal apch at 120 KTS, compensating for downdrafts/crosswinds. After touchdown, the plt said he did not get a beta light on the right eng. He…Dec 30, 1987 · N4468M · Substantial damageNTSB SEA88LA033Accident · 1 fatalLimited investigationFinal reportCessna 182C · Las Vegas, NVThe aircraft bounced on landing touchdown, swerved off the side of the runway and impacted a concrete culvert in a drainage ditch. Witnesses observed the acft bounce and stated that no application of power for recovery was heard nor any apparent attempt to…Dec 29, 1987 · N8819T · DestroyedNTSB LAX88LA081Accident · No injuriesLimited investigationFinal reportCessna 172M · Banning, CADuring a pleasure flight while on final approach, aprx 10 ft above the rwy, the acft suddenly dropped and bounced on the rwy. After a nearby rain storm passed over the area, the acft was flown to the home base. Several days later, the operator discovered…Dec 29, 1987 · N12943 · Substantial damageNTSB FTW88LA043Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Woodworth, LAThe plt stated that during landing roll the aircraft veered left due to a strong wind gust. The aircraft fell into a ravine, coming to rest 180 degrees from the runway heading, damaging both wing spars at the fuselage attach points and collapsing the nose…Dec 29, 1987 · N5719G · Substantial damageNTSB MIA88NA070Accident · Minor injuriesFinal reportMcDonnell Douglas DC-9-31 · Pensacola, FLDec 28, 1987 · N8948E · Substantial damageNTSB 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…Dec 27, 1987 · N72830 · Minor damageNTSB MKC88LA034Accident · No injuriesLimited investigationFinal reportLuscombe 8-A · Chillicothe, MODuring a ldg attempt, acft touched down and swerved abruptly. Loss of control was experienced by PIC, and acft made a 180 degree turn on the runway. PIC stated the brakes may have been frozen, as he had taxied thru standing water during departure.Dec 26, 1987 · N71288 · Substantial damageNTSB CHI88LA036Accident · No injuriesLimited investigationFinal reportCessna 150M · Redwood Falls, MNWind was 210 degrees at 13 knots when the student pilot attempted a landing on snow compacted runway 12. The student stated that a gust of wind pushed the aircraft sideways and it struck a snowbank when it exited the runway to the left.Dec 26, 1987 · N704XX · Substantial damageNTSB CHI88LA034Accident · No injuriesLimited investigationFinal reportCessna 172K · Staunton, ILDuring the flare for landing the aircraft drifted to the right and the right wingtip contacted the rudders of two aircraft parked with their tails 21' and 23' from the centerline of the runway. The wingspan of the accident aircraft is 35'9'. Had the pilot…Dec 22, 1987 · N78705 · Substantial damageNTSB MKC88LA031Accident · No injuriesLimited investigationFinal reportSonerai 2L · St. Louis, MOWhile practicing take offs and ldgs, PIC lost directional control during rollout. He added power and struck a snowbank just after becoming airborne during running takeoff.Dec 21, 1987 · N502WM · Substantial damageNTSB FTW88FA039Accident · 15 fatalField investigationFinal reportAerospatiale SA-330J · Eugene IslandThe helicopter, with 2 plts & 13 passengers, was on an IFR flt to a psn in the gulf of Mexico. From that psn, they proceeded under VFR to an off-shore oil drilling rig (EI-190). As the helicopter was arriving from the se, there was a strong wind from the NE.…Dec 21, 1987 · N3596N · DestroyedNTSB DEN88LA039Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Las Cruces, NMWhile practicing crosswind landings the instructor stated that the student touched down normally with aprx 5 knot crosswind. Upon touch down, the right main landing gear separated from the acft causing substantial damage. There were no injuries and no fire.…Dec 19, 1987 · N23497 · Substantial damageNTSB MIA88LA066Accident · No injuriesLimited investigationFinal reportCessna A188B · South Bay, FLThe plt attempted a landing on a narrow runway, on an embankment. The airplane swerved to the left, into a crosswind, and left the rwy. The right main ldg gear collided with a boulder; the airplane nosed over and came to rest in the water.Dec 18, 1987 · N731LS · Substantial damageNTSB MIA88LA064Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Marathon, FLWhile on a personal flt after the plt lowered the landing gear for landing, the left main landing gear did not extend. The plt continued the apch, & after touchdown, the acft veered off the rwy, collided with trees, then came to rest. According to FAA…Dec 15, 1987 · N707CC · Substantial damageNTSB ATL88LA064Accident · No injuriesLimited investigationFinal reportCessna 150G · Grantham, NCThe airplane touched down initially on the nose wheel, and the nose landing gear collapsed. The airplane subsequently nosed over. The student plt reportedly had about 2 hrs total PIC (solo) flt time.Dec 13, 1987 · N6258S · Substantial damageNTSB MIA88LA061Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Fellsmere, FLWhile on a business flt over the company's property the plt elected to land the acft on a 40 foot wide dirt road. After touchdown the acft drifted off the left side of the road, due in part, to a crosswind. The left wing collided with a tree.Dec 12, 1987 · N80BJ · Substantial damageNTSB ATL88LA063Accident · No injuriesLimited investigationFinal reportCessna 150K · Portland, TNThe student plt rptd that the airplane veered off the rt side of the rwy into a ditch while ldg in x-wind conditions. The student plt estimated that the wind velocity was 10 KTS with gusts to 20 KTS. The student rptdly had about 32 hrs total flt experience,…Dec 12, 1987 · N5995G · Substantial damageNTSB ATL88LA062Accident · No injuriesLimited investigationFinal reportCessna 172P · Columbus, OHAt 1343 EST, the student plt contacted apch ctl & asked for lndg info. He was adzd to continue VFR for rwy 31. When he contacted the tower at 1347, the wind was fm 200 deg at 13 KTS. Tower psnl gave him the choice of rwy 31 or 28L; he elected to lnd on rwy…Dec 11, 1987 · N52701 · Substantial damageNTSB SEA88LA082Accident · No injuriesLimited investigationFinal reportCessna TU206G · Silverdale, WAWhile on the lndg roll with a qtrg hdwnd, the acft enctrd a gust which pushed it to the left. The plt said he applied full rgt aileron, but it had no effect. As the acft was 'being blown' toward trees, the plt applied full rgt brake. He said the left wing tip…Dec 10, 1987 · N4953Z · Substantial damageNTSB MIA88FA058Accident · No injuriesField investigationFinal reportEmbraer EMB 120 · Columbus, MSThe acft landed gear up while on a training flight, the crew stated that they had completed 2 hours of training when the first officer requested a single engine no flap approach demonstration. Both pilots stated that during this demonstration they neglected…Dec 10, 1987 · N232AS · Substantial damageNTSB ATL88LA058Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Marlboro, OHThe student plt rptd that he flew a flat final apch to remain clear of trees. The airspeed began to drop, and the airplane subsequently landed hard after clearing the trees.Dec 10, 1987 · N87102 · Substantial damageNTSB NYC88LA055Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-20 · White Plains, NYThe cross country business flight was uneventful from concord, new hampshire to White Plains, new york under clear sky. During final approach, the pilot extended the gear but did not notice that the circuit breaker had opened and the gear was not lowered. The…Dec 7, 1987 · N866Q · Substantial damageNTSB CHI88LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Lincoln, ILThe plt returned to the arpt after dark & noted there was an excessive x-wind for the active rwy. He elected to land on the unlighted grass rwy (rwy 14) which was aligned more favorably with the wind. He thought that on final apch, he had aligned the acft…Dec 6, 1987 · N757KW · Substantial damageNTSB ANC88DAG01Accident · No injuriesFinal reportCessna 207A · Atmautluak, AKThe aircraft was on final approach when a vehicle appeared to be on the runway coming at the aircraft. The pilot pulled the aircraft up over the snow machine but settled back to the ground alongside the runway.Dec 6, 1987 · N73503 · Substantial damageNTSB MIA88LA054Accident · No injuriesLimited investigationFinal reportCessna 310F · Opa Locka, FLThe plt stated that he had made three touch & go landings & on the fourth landing, while on rollout, the left main gear collapsed & the acft slid to a stop on the runway. Post crash examination of the landing gear revealed that the left main gear downlock rod…Dec 5, 1987 · N317L · Substantial damageNTSB MIA88LA053Accident · No injuriesLimited investigationFinal reportBeech C-45H · Miami, FLWhile practicing short field landings the plt flared the acft for landing after which it stalled, descended right wing low, then crashed onto the rwy. The acft then touched down on the nose landing gear causing it to collapse, & slid off the rwy.Dec 4, 1987 · N4209V · Substantial damageNTSB MIA88IA052Incident · No injuriesIncident investigationFinal reportBeech 58 · Vicksburg, MSWhile on a part 135 on-demand domestic passenger flt, the acft landed gear up. The plt stated that he forgot to lower the landing gear. There was no mechanical failure or malfunction.Dec 3, 1987 · N3012W · Minor damageNTSB ATL88LA051Accident · No injuriesLimited investigationFinal reportCessna 172F · Eden, NCThe student plt attempted to land in a farm pasture adjacent to his brother's farm. The airplane ldg gear 'dug in' on ldg, and the airplane nosed over. The student plt described the terrain as 'wet & soggy'. The student did not have an instructor's…Dec 2, 1987 · N8674U · Substantial damageNTSB MIA88LA048Accident · No injuriesLimited investigationFinal reportCessna 172K · Pensacola, FLThe pvt plt flying the acft for the first time from the rt seat landed it aprx 170 ft short of the runway on soft grass. The acft rolled 6-10 ft, after which the nose gear sank & the acft then nosed over & came to rest inverted.Nov 29, 1987 · N84613 · Substantial damageNTSB MIA88LA047Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Quincy, FLThe plt stated that he performed a prelanding check on final apch but failed to lower the landing gear. He continued the apch, & just prior to touchdown, was advised that the gear was not down. The apch to landing was continued & the acft slid to a stop. He…Nov 29, 1987 · N9492T · Substantial damageNTSB DEN88LA032Accident · No injuriesLimited investigationFinal reportCessna 180 · Telluride, CODuring a downwind landing, the plt experienced difficulty in controlling his acft. Approximately 2,500 feet from the west end of the rwy the acft ground looped into some rocks and was substantially damaged. The plt stated that he was landing downwind and…Nov 28, 1987 · N6547A · Substantial damageNTSB MIA88LA045Accident · No injuriesLimited investigationFinal reportMooney M-22 · Fort Pierce, FLPlt stated that on landing roll at approximately 30 to 35 knots the nose landing gear began to shimmy and turn to the left. Full right brake and rudder could not correct the left turning tendency of the aircraft. The aircraft ran off the left side of the…Nov 26, 1987 · N7739M · Substantial damageNTSB LAX88LA056Accident · No injuriesLimited investigationFinal reportCessna 172N · Sacramento, CAA Cessna 172N veered off runway 30. The pilot reported that a gust of wind lifted the left wing resulting in the right wing scraping the runway surface. The airplane subsequently ground looped to the right and departed the runway. The winds were reported to…Nov 25, 1987 · N75825 · Substantial damageNTSB SEA88LA022Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Las Vegas, NVDuring practice autorotation the pilot flared excessively high and the tail boom struck the ground. The pilot then lost control of the aircraft. The density alt was 2616 feet. A rt quartering tailwind was present.Nov 24, 1987 · N22730 · DestroyedNTSB 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…Nov 24, 1987 · N3888Q · Substantial damageNTSB ATL88LA045Accident · No injuriesLimited investigationFinal reportCessna 150M · Waynesboro, GAThe student plt lost control of the airplane while landing, during his second supervised-solo flt. The airplane veered off of the rwy into a ditch where the nosegear collapsed and the airplane nosed over. The wind was reportedly calm.Nov 24, 1987 · N4081V · Substantial damageNTSB NYC88LA039Accident · No injuriesLimited investigationFinal reportWaco ZKC-5 · No. Canaan, CTThe aircraft touched down in a 3-point landing attitude at north Canaan, Connecticut. The left landing gear wheel rotated 90 degrees and the left gear was dragged 144 yards before the aircraft became inverted. It was revealed that the braze joint at the top…Nov 23, 1987 · N14164 · Substantial damageNTSB DEN88LA027Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Broomfield, COThe private pilot was flying to build time. After an hour of flight, the plt returned to the home airport and attempted to land. Landing gear would not extend properly and manual gear extension did not help. All gear was partially extended and would not…Nov 23, 1987 · N7291P · Substantial damageNTSB FTW88IA029Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Newark, NJImmediately after the hard landing the captain was observed by the copilot and flight engineer to be incapacitated. The copilot took control of the airplane and guided it onto a high speed taxiway. With the aid of a flight attendant and the flight engineer…Nov 22, 1987 · N121AA · No damageNTSB LAX88LA055Accident · No injuriesLimited investigationFinal reportCessna 172N · San Jose, CAAt the conclusion of a cross country instructional flight, the pilot made three approaches to land. On the first two attempts, the aircraft touched down on the nose wheel and porpoised, then the pilot initiated a go-around. On the third landing, the aircraft…Nov 21, 1987 · N9568G · Substantial damageNTSB CHI88LA030Accident · Minor injuriesLimited investigationFinal reportCessna 337 · Kankakee, ILThe pilot was attempting to land on runway 22 at an uncontrolled airport when he heard another pilot transmit he was about to depart from the same runway. According to the pilot, while he was turning on to final approach, he observed an aircraft taxiing to…Nov 21, 1987 · N6255F · Substantial damageNTSB MIA88LA043Accident · No injuriesLimited investigationFinal reportNorth American 500 · San Juan, PRWhile on a part 135 non-scheduled domestic passenger flt in VFR conditions, the plt landed the acft gear up. Operational check of the landing gear & warning horn revealed no failure or malfunction.Nov 20, 1987 · N4111P · Substantial damageNTSB FTW88LA030Accident · No injuriesLimited investigationFinal reportCessna 185 · Burnet, TXDuring landing roll, the aircraft drifted to the left of the runway centerline. Witnesses then observed the aircraft veer to the right and ground loop coming to rest off the end of the runway. Attempts to contact the student plt have not been successful.Nov 20, 1987 · N7370H · Substantial damageNTSB ANC88LA017Accident · No injuriesLimited investigationFinal reportCessna 208 · Atmautluak, AKThe pilot stated that he landed at a distance approximately one-third of the way down the 2,000 foot ice covered gravel runway. After touchdown the pilot lost directional control of the aircraft causing the aircraft to exit the departure end of the runway.…Nov 18, 1987 · N9370F · Substantial damageNTSB NYC88LA040Accident · No injuriesLimited investigationFinal reportCessna 210 · Schenectady, NYDuring landing, the left main gear collapsed. A metallurgical examination revealed that the left main gear saddle assembly was fractured into three pieces through the area near the forward edge of the landing gear strut. When examined further, the faces and…Nov 14, 1987 · N9568T · Substantial damageNTSB NYC88LA038Accident · No injuriesLimited investigationFinal reportGrumman AA-1B · Tewksbury, MAThe student pilot was attempting a landing at Tewksbury, Massachusetts when he flared above the runway, bounced several times and collapsed the nose wheel. The aircraft slid down the runway, made contact with the right side of the runway edge, spun around,…Nov 14, 1987 · N8993L · Substantial damageNTSB LAX88LA048Accident · No injuriesLimited investigationFinal reportBeech 58 · Jackson, CAThe plt rprtd that prior to reaching the destn, he received an adzy on the UNICOM freq that rwy 19 was in use & that there was a direct x-wind. Drg arrival, he tried to contact UNICOM again to get a wx update, but was unable. He elected to lnd on rwy 19.…Nov 14, 1987 · N9106Q · Substantial damageNTSB CHI88LA023Accident · No injuriesLimited investigationFinal reportCessna A150K · Elkhart, INThe plt of Cessna A150K, N8382M, was landing after the plt of another Cessna 150 had landed & had started to back-taxi up the same rwy. The plt of the other acft stated that she had announced her intentions to back taxi up the rwy & that she did not hear any…Nov 14, 1987 · N8382M · Substantial damage