OpenAirDocs.org

NTSB investigations, 1985

704 cases where the phase of flight was Enroute.

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\") = 1985
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 400)
  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 DCA86AA012Accident · 7 fatalFinal reportDouglas DC-3 · Dekalb, TXAt 1708:48, while cruising at 6000', a pilot of N711Y advised ATC, 'I think I'd like to turn around, head for texarkana here, I've got a little problem.' He was provided a vector & advised of closest airports. Shortly after, he stated he would be unable to…Dec 31, 1985 · N711Y · DestroyedNTSB SEA86FA033Accident · 4 fatalField investigationFinal reportMooney M20K · Des Moines, WAThe weather briefer informed the pilot that VFR was not recommended due to current/forecast condtions. The non instrument rated pilot then filed a VFR flight plan responding that he was IFR rated and would file inflight if necessary. Witnesses reported…Dec 30, 1985 · N1152T · DestroyedNTSB DEN86FA232Accident · 2 fatalField investigationFinal reportCessna T210L · Salina, UTThe non-instrument rated plt did not obtain a wx briefing nor file a flight plan. He and his wife took off from bullfrog basin airport, glen canyon, UT, en route to heber city, UT, on 12-30-85. Acft did not arrive. Civil air patrol search was conducted from…Dec 30, 1985 · N27CF · DestroyedNTSB CHI86FEI01Accident · Minor injuriesFinal reportMonnet Moni · Perry, OHAfter initiating a 180 deg turn, the plt heard a 'thump' and noted a low vibration. The acft then pitched down abruptly and entered an inverted spin to ground contact. The plt stated an in flight structural failure of the tail section had occurred which…Dec 30, 1985 · N685TC · Substantial damageNTSB LAX86LA076Accident · No injuriesLimited investigationFinal reportMooney M20F · San Manuel, AZDuring cruise at 10,500 ft MSL on a night x-country flt, the plt said the eng ran rough with moderate vibration levels. Plt declared an emergency with abq ARTCC, who vectored the acft to an unlighted airstrip. The plt said he had difficultyin seeing the rwy…Dec 28, 1985 · N234GA · Substantial damageNTSB CHI86LA053Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Glidden, WIThe aircraft collided with powerlines while attempting a power off landing after engine stoppage. The fuel tanks were inspected and there was no fuel in the right tanks and only a small quantity in the lft tank. The engine was tested and found to function…Dec 28, 1985 · N8687S · Substantial damageNTSB MKC86LA041Accident · No injuriesLimited investigationFinal reportBeech M35 · Council Bluffs, IAThe acft made a gear-up forced lndg off the arpt after a loss of power during a business flt. The acft had only been airborne for about 15 minutes. Post accident investigation discovered that the acft fuel was contaminated with water.Dec 27, 1985 · N9730R · Substantial damageNTSB LAX86LA075Accident · No injuriesLimited investigationFinal reportPiper PA-34T-22OT · Tucson, AZDuring a trans border VFR x-country flt, the plt noticed 'oil spirting from the left engine' with smoke, & he shut it down. An emergency was declared by the Tucson ATCT, who cleared the acft to land straight in on rwy 29L. Tower personnel observed the acft…Dec 26, 1985 · XBDRL · Substantial damageNTSB FTW86LPJ04Accident · No injuriesFinal reportCessna 150F · Tulsa, OKThe acft nosed over during a forced landing following a loss of pwr. The plt stated 'quite abit' of water was drained from the fuel system during preflight. Aprx 10 to 15 minutes after takeoff the eng began to sputter and eventually quit. The nose wheel…Dec 26, 1985 · N8535G · Substantial damageNTSB FTW86FRG10Accident · Minor injuriesFinal reportMooney M20C · San Antonio, TXThe acft was destroyed during a forced landing. While en route over the San Antonio area the plt noticed a few drops of what he believed to be precipitation on the windshield. Shortly thereafter, it was determined the drops on the windshield were oil. The…Dec 26, 1985 · N7025V · DestroyedNTSB ATL86LA048Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Kings Mountain, NCThe acft had been moored on an open ramp in extremely cold tempertures. During preflight the plt found that the fuel strainer drain would not close and one wing tank drain would not open. A mechanic attempted to repair the leaking strainer but could not stop…Dec 26, 1985 · N7300A · Substantial damageNTSB DEN86FA054Accident · 1 fatalField investigationFinal reportBell 206-L3 · Monument Valley, UTThe helicopter contacted power lines and the terrain during an attempted takeoff from a hospital after a cancelled med-evac flt. The hospital is located in a box canyon surrounded by high terrain and power lines. The plt was aware of the power line that…Dec 25, 1985 · N10UB · DestroyedNTSB FTW86FRG09Accident · Serious injuriesFinal reportRobinson R22 HT · Sonora, TXThe helicopter contacted the terrain in an uncontrolled descent after colliding with power lines during a climbing turn to the west. The plt reported he could not see the power lines because of glare from the setting sun.Dec 23, 1985 · N9074U · Substantial damageNTSB DEN86LTM01Accident · Serious injuriesFinal reportCessna 172 · Brigham City, UTThe acft contacted mountainous terrain during a descent through fog. The plt stated that on the return flt from malad, ID, he began following a mountain range which he believed would take him back to ogden. However, the range guided him southwest of the…Dec 22, 1985 · N64005 · DestroyedNTSB CHI86MA052Accident · 6 fatalMajor investigationFinal reportCessna 177B · Brooklyn, MIThe pilot took off with five passengers approximately 170 pounds over maximum allowable gross weight into known moderate icing conditions. His aircraft was not equipped to fly in these conditions. Radio and radar contact were lost at approximately 3500 feet…Dec 22, 1985 · N34046 · DestroyedNTSB NYC86LA051Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Bristol, CTThe acft was on a return flight back to teterboro when an eng failure occurred for unknown reasons. The plt requested vectors to the nearest arpt which was robertson but he was not able to reach it. A forced landing resulted in an open fld during which the…Dec 21, 1985 · N61260 · Substantial damageNTSB MKC86FA037Accident · 3 fatalField investigationFinal reportBell 206L · Ainsworth, NEThis med-evac helicopter was being positioned to pick up a patient. The plt obtained a wx briefing which included a forecast for a chance of marginal VMC along the planned route, although at the time of the briefing the dest weather was VMC. The flt departed…Dec 21, 1985 · N110LG · DestroyedNTSB LAX86FA069Accident · 1 fatalField investigationFinal reportPiper PA-24-260 · Newport Beach, CAThe plt contacted coast TRACON (terminal radar control) & requested VFR traffic advisories to torrence. At aprx 0747 psthe declared an emergency, said the eng had quit & requested vectors to the john wayne/orange county arpt. The controllerprovided a hdg to…Dec 19, 1985 · N9044P · DestroyedNTSB LAX86LA068Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Canoga Park, CAWhile the plt was cruisin in his own acft, an eng oil leak developed, oil pressure decreased & eng power was lost, the plt attempted to make an emergency ldg on a city street, on approach the acft collided with power lines & a fence, & the acft came to rest…Dec 18, 1985 · N6740P · Substantial damageNTSB DEN86LA050Accident · Serious injuriesLimited investigationFinal reportBeech V-35B · Wibaux, MTThe plt stated that light snow was falling at the arpt at the time of departure. The pax stated after the accident that the plt encountered clouds at their cruise alt of about 6000 ft. he continued to state that the acft made a shallow descent at first…Dec 18, 1985 · N24198 · DestroyedNTSB NYC86LA050Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Mt. Joy, PAPiper aircraft was in cruise flight from lancaster, PA to mt joy, PA. When an oil line apparently fractured. An emergecny landing was made in a field. During landing, the nose collapsed and the aircraft was substantially damaged.Dec 15, 1985 · N7177W · Substantial damageNTSB MIA86LA043Accident · No injuriesLimited investigationFinal reportLake LA4-200 · Homestead, FLThe plt stated that while on a flight from marco island FL, to ocean reef FL, he heard a loud bang and elected to land at Homestead general arpt. Upon landing he found the left muffler had seperated from the acft, struck the propeller and was driven through…Dec 15, 1985 · N2969P · Substantial damageNTSB SEA86LA030Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B · Kimberly, IDA forced landing with a rollover onto snow occurred due to the number 3 cylinder rod failing.Dec 12, 1985 · N73208 · Substantial damageNTSB MKC86FA033Accident · Serious injuriesField investigationFinal reportPiper PA-32-300 · Omaha, NEN8895E was climbing through 2,800' MSL, 15 min after takeoff and when the pilot retarded the throttle to climb power, the eng quit. The pilot selected an open field for the forced landing but collided with trees during the approach. Examination of the eng…Dec 12, 1985 · N8895E · Substantial damageNTSB CHI86FA111Accident · No injuriesField investigationFinal reportPiper PA-46-310P · Evanston, ILThe aircraft was on climbout on an IFR flight plan in VMC conditions when the engine failed. A restart was attempted and the engine ran for a minute or less. Subsequent attempts were unsuccessful. The aircraft was over lake Michigan and had insufficient…Dec 12, 1985 · N4380A · DestroyedNTSB LAX86LA062Accident · No injuriesLimited investigationFinal reportCessna 150K · Honolulu, HIThe plt reported that 5 mins after takeoff the eng reduced to idle pwr, & attempts to restore full pwr were unsuccessful. The plt did state that brief periods of pwr obtained by using the hand primer. The acft was unable to maintain alt & was ditched about 25…Dec 11, 1985 · N6347G · Substantial damageNTSB LAX86FA063Accident · 2 fatalField investigationFinal reportCessna TR182 · Independence, CAWhile en route, the acft collided with moutainous terrain (trrn) at an aprx elev of 13,500 ft. previously, the plt had requested & was rcvg traffic advisories fm ARTCC. Bfr the acdnt, the acft's psn & alt (mode c reply) were noted by the controller (ctlr). No…Dec 10, 1985 · N737SG · DestroyedNTSB CHI86FA046Accident · 2 fatalField investigationFinal reportAerospatiale SA365N · Adrian, MIThe purpose of this flight was to pick up an injured patient and return him to a medical center. The weather was adequate for a VFR takeoff. However, enroute weather reports indicated fog and probable low ceilings. According to the single survivor of the…Dec 10, 1985 · N5800H · DestroyedNTSB LAX86FA061Accident · 3 fatalField investigationFinal reportPiper PA-28-201T · So. Lake Tahoe, CAPrior to departing on a VFR flt from south lake Tahoe, CA, to tracy, CA, the plt failed to obtain a wx briefing or file a flt plan. Wx at the arpt of departure was reported as scattered clouds at 1500 ft, broken ceiling conditions at an estimated 3000 ft,…Dec 9, 1985 · N2854R · DestroyedNTSB NYC86FA049Accident · 1 fatalField investigationFinal reportCessna 340A · Peru, MADuring IFR flight at 12000 feet both aircraft vacuum pumps failed. Aircraft descended in right turn off radar. Witnesses observed aircraft at low altitude above trees, circle, make steep left turn, climb and descend to ground.Dec 8, 1985 · N36888 · DestroyedNTSB MIA86LA040Accident · No injuriesLimited investigationFinal reportDouglas C. Campbell Varieze · Orlando, FLThe plt stated that the acft lost power, & in an attempt to return to the arpt, the acft collided with a light pole & some orange trees, coming to rest on a canal bank. Post crash examination of the eng revealed that it failed because the #4 rod ass'y…Dec 8, 1985 · N111VE · Substantial damageNTSB LAX86LA059Accident · No injuriesLimited investigationFinal reportMooney M20E · Selma, CADuring cruise on a VFR x-country flt, the plt stated that the eng became rough with moderate vibration levels. After shutting down the eng, the plt made a forced landing in a fld, collided with gnd obstructions & collapsed all 3 landing gear. Examination of…Dec 8, 1985 · N5516Q · Substantial damageNTSB FTW86LPA08Accident · No injuriesFinal reportCessna 152II · Frisco, TXThe student plt stated that he departed mckinney municipal arpt at aprx 1030 LCL en route to wichita falls, TX. He said he became disoriented while en route, but landed at wichita falls at aprx 1220 LCL. The plt did not refuel the acft. He then departed…Dec 8, 1985 · N4731H · Substantial damageNTSB ATL86FA037Accident · No injuriesField investigationFinal reportPiper PA-28-181 · Clover, SCThe aircraft experienced an engine failure during cruise flight and attempted an emergency landing in a field. During landing roll the aircraft collided with small trees on the FAR end of the field. Post-crash examination of the engine disclosed that the bolt…Dec 7, 1985 · N5388F · Substantial damageNTSB DEN86LA041Accident · No injuriesLimited investigationFinal reportCessna 177B · Billings, MTThe acft was damaged during a forced landing in a fld following a loss of pwr from fuel exhaustion. The plt stated that during the preflight he checked the fuel level by the gages and not visually. The gages indicated slightly over one-half full at that time.Dec 6, 1985 · N13717 · Substantial damageNTSB DEN86LA040Accident · No injuriesLimited investigationFinal reportHelio H-391B · Bozeman, MTAccording to personnel in the area, the plt radioed he had smoke in the cockpit and was returning to gallantin field, his departure point. Later, the plt transmitted that the eng lost total pwr and he was making a forced landing. During the investigation, it…Dec 6, 1985 · N4101D · Substantial damageNTSB CHI86FA041Accident · 1 fatalField investigationFinal reportCessna 320 · Ada, OHThe pilot overflew a planned intermediate stop before running low on fuel. He was unable to find the airport he was being vectored to & attempted to land in a plowed field during dark conditions. As the aircraft passed over powerlines the aircraft was…Dec 6, 1985 · N5755X · DestroyedNTSB LAX86LA056Accident · Minor injuriesLimited investigationFinal reportCessna P210R · Scottsdale, AZWhile descending from 9,500 to 5,000 ft MSL, the plt reported that the eng suddenly lost all power. The plt stated that he was unable to restart the eng & made an emergency landing at a nearby arpt. The plt, who had entered the downwind leg for the 8,251 foot…Dec 5, 1985 · N5298A · Substantial damageNTSB LAX86LA054Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Deer Valley, AZShortly after begining descent from 7,500 ft. m.s.l. the acft experienced a total loss of power. Prior to descent the plt richened the mixture and applied carb heat. The pilot radioed his position & situation to Deer Valley tower, Deer Valley, Arizona while…Dec 5, 1985 · N3334A · Substantial damageNTSB CHI86FA038Accident · Minor injuriesField investigationFinal reportCessna T210M · Highland, MIFifteen minutes after takeoff an eng failure occurred. The plt force landed the acft in a fld but the roughness of the landing surface resulted in the nose and right main gear collapsed. Examination disclosed the exhaust vavle had failed in the #4 cylinder.…Dec 4, 1985 · N1982M · Substantial damageNTSB NYC86LA046Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Mt. Lafayette, NHThe acft, while in cruise flt en route to lyndonville, VT, encountered a severed downdraft and the plt was unable to penetrate or climb out of the descent. The acft continued to descend until impact with a mountain occurred. The acft contacted the terrain at…Dec 3, 1985 · N5281U · Substantial damageNTSB DEN86FA033Accident · Serious injuriesField investigationFinal reportCessna 421B · Franktown, COThe acft departed nashville, TN, for a flt to aspen, CO. The plts made one refueling stop at chanute, KS. The plts were unable to land at aspen or a nearby alternate arpt (eagle, CO) and elected to return back to the denver area. The plts indicated to an…Dec 2, 1985 · N249JM · Substantial damageNTSB MIA86LA037Accident · No injuriesLimited investigationFinal reportBeech 60 · Lakeland, FLThe plt stated that he experienced a loss of power in both engines, made an emerg landing in a cow pasture, & struck a cow on landing rollout. Due to the extent of post crash fire no determination could be made as to the nature of the malfunction of the…Dec 1, 1985 · N7080D · DestroyedNTSB DEN86FA038Accident · 2 fatalField investigationFinal reportCessna C-182 · Gallup, NMThe plt departed las cruces, NM, on a VFR flt to Gallup,NM. Approx 23 miles from destination, in mountainous terrain, the non-instrument rated plt encountered unforecast snow storm conditons at night. While the plt was maneuvering toward the destination at a…Nov 29, 1985 · N52599 · DestroyedNTSB CHI86FA035Accident · 2 fatalField investigationFinal reportBeech BE 36 · Odell, ILThe plt departed on an IFR flight into known icing conditions after receiving three complete weather briefings clearly indicating the icing conditions with numerous plt reports of icing. Aprx 40 minutes after departure the plt reported he had about an inch of…Nov 29, 1985 · N3807Z · DestroyedNTSB NYC86LA043Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Bloomsburg, PAThe acft was on an IFR flt en route to allegheny county arpt at 6000 ft when an electrical failure occurred. The plt executed a precautionary landing in a muddy fld. The nose wheel caught in mud and the acft nosed over. Examination of the electrical system…Nov 28, 1985 · N7506G · Substantial damageNTSB CHI86IA034Incident · No injuriesIncident investigationFinal reportBoeing 747-251F · Glen Ellyn, ILDuring climb a bang was heard and the aircraft shuddered. The crew stated that the number three engine oil pressure and oil quantity indicated low. The fire warning light and bell activvated. The engine was shut down and the aircraft landed without further…Nov 28, 1985 · N619US · Minor damageNTSB CHI86FA033Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Duluth, MNThe pilot departed crystal lake for a flight to visit relatives for thanksgiving. He did not obtain a preflight weather briefing nor did he contact any ground facility during the flight. He was qualified to fly in VFR conditions only. The aircraft impacted…Nov 28, 1985 · N8082B · DestroyedNTSB MIA86LA036Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Dorado, PRThe plt stated that after a brief local flight he was returning to isla grande arpt when he experienced a loss of power in both engines & made a forced landing on the beach near Dorado puerto rico. Post crash examination of the wreckage revealed that the two…Nov 27, 1985 · N4444P · Substantial damageNTSB LAX86LA047Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Ukiah, CAWhile en route to sonoma county arpt, santa rosa, CA, the plt became concerned about the acft fuel state. The plt elected to divert to Ukiah arpt, Ukiah, CA, and while en route the acft experienced total pwr loss due to fuel starvation. During the forced…Nov 27, 1985 · N123 · Substantial damage