OpenAirDocs.org

NTSB investigations, 1985

41 cases where the phase of flight was Unknown.

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 = 990)
  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 LAX86FUJ02Accident · 2 fatalFinal reportCessna 182G · Gila Bend, AZOn December 4, 1985, at 1928 MST, a Cessna 182, N3205S, collided with a power utility pole near paloma, AZ. Visual meteorological conditions prevailed at the time and no flight plan was filed. The aircraft was destroyed and the two people on board the…Dec 5, 1985 · N3205S · DestroyedNTSB LAX86FVD03Accident · 1 fatalFinal reportAero Commander 680T · Concord, CAOn 12/3/85 at aprx 0830, the acft was fnd lying inverted in a canal adjacent to the arpt where it had been on 24 hr standby for medical flts. Twelve days later, the plt's body was also fnd in the canal. An investigation revealed the acft had been taken…Dec 3, 1985 · N17690 · DestroyedNTSB ATL86FMG04Accident · No injuriesFinal reportCessna 177RG · Kenansville, NCThe acft contacted two piles of dirt during a gear-up landing. The plt took off with intensions of practicing touch and go landings. On the second apch, the plt was unable to fully extend the landing gear. The plt had one passenger check the hydraulic fluid…Nov 11, 1985 · N2012Q · Substantial damageNTSB CHI86LA022Accident · Serious injuriesLimited investigationFinal reportCessna 182N · Kenosha, WIAccording to the pilot the flight from toledo to the kenoshaarea was uneventful. During the VOR approach to rwy 14 (approx 2 miles from the end of the runway) the aircraft impacted the ground and was destroyed. The pilot stated that the last thing he rembered…Nov 2, 1985 · N92302 · DestroyedNTSB FTW86FPJ02Accident · Serious injuriesFinal reportCessna 152 · Tahlequah, OKThe acft contacted static cables and descended to ground contact during an aerial search for a person. The plt had turned the acft into the sun when it contacted one of two static cables on a power transmission array aprx 159 ft AGL. The towers to which the…Nov 1, 1985 · N4969H · Substantial damageNTSB MIA86LA024Accident · 1 fatalLimited investigationFinal reportPiper PA-34-200T · Gulf Of MexicoAircraft disappeared from radar while operating in an area of level 3, 4, and 5 thunderstorms associated with tropical storm juan. A search by the u. s. coast guard resulted in no aircraft wreckage being found. The aircraft is missing and the pilot is…Oct 31, 1985 · N24MS · DestroyedNTSB NYC86FA002Accident · 3 fatalField investigationFinal reportCessna C-377A · Breakabeen, NYThe plt was advised by several sources that bad wx was located along the intended route of flt. The plt stated that he intended to fly over the bad wx since wx at the destination was good. A mayday call from 24J was broadcasted over the emer. Freq. Witnesses…Oct 5, 1985 · N6524J · DestroyedNTSB LAX86LA008Accident · 2 fatalLimited investigationFinal reportPiper PA-23-250 · Santa Barbara, CAOn oct. 3, 1985, pipter PA-23-250 crashed into the pacific ocean while on an air sampling flt near Santa Barbara, CA. The ac was destroyed and the two plts were fatally injured. The flt was to be flown along a predermined route utilizing loran navaids. The ac…Oct 4, 1985 · N6726Y · No damageNTSB FTW85LAMS2Accident · 1 fatalFinal reportSwearingen SA-226T · MissingA distress message was received from the pilot stating he was 100 miles south of grand isle, LA, and had lost an eng andwas unable to maintain altitude. A second message was received shortly afterwards stating that the aircraft was at 1500 feet and the pilot…Sep 17, 1985 · N3RB · DestroyedNTSB NYC85FAMS1Accident · 2 fatalMissing aircraftFinal reportCessna 172N · Block Island, RIThe acft departed long Island on a VFR flt plan for Block Island. The plt did not close the flt plan after arrival at Block Island and departed Block Island without refiling a flt plan. The flt departed Block Island at night to the east over the ocean and has…Sep 14, 1985 · N1423E · DestroyedNTSB NYC85FA241Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Hamburg, NJThe acft contacted trees during an uncontrolled descent aprx 17 minutes after takeoff. One witness reported hearing the eng running at a high RPM. The acft wreckage was not discovered until 9-18-85. The airspeed indicator found at the accident site indicated…Sep 14, 1985 · N7188R · DestroyedNTSB MIA85LA249Accident · 2 fatalLimited investigationFinal reportPiper PA-28-160 · Key West, FLThe acft failed to arrive at its intended destination on a flt plan from ft. lauderdale FL. To Key West FL. Navy Key West apch was providing VFR flt following, radar & radiocontact was lost with the acft 20 NE of Key West. The whereabouts of the occupants are…Sep 9, 1985 · N5488W · DestroyedNTSB ANC85LA171Accident · 1 fatalLimited investigationFinal reportCessna 182B · English Bay, AKA witness stated that he saw the acft crash in the cook inlet while it was in a steep descent. Neither the acft nor the plt were recovered; however, some small objects from the acft were retrieved. The plt was presumed to have been fatally injured.Sep 5, 1985 · N2500G · DestroyedNTSB ANC85LA188Accident · 2 fatalLimited investigationFinal reportMaule M-5-235C · Mccarthy, AKThe pilot departed a sand bar near the bernard glacier on 8/8/85, and never returned to pick up the passenger he had dropped off earlier. On 8/12/91 the wreckage was found by hunters at 61-11N 141-42W at the 1,000-FT level in mountainous terrain. The wreckage…Aug 8, 1985 · N9046E · DestroyedNTSB CHI85FAMS3Accident · 1 fatalMissing aircraftFinal reportCessna 172The aircraft was seen to depart racine, WI on August 3, for ft meyers, FL, but never arrived at its destination. On the fourth day of the search a ramp check at albany-dougherty county airport, Georgia indicated that the aircraft was refueled there at approx…Aug 3, 1985 · N5913A · DestroyedNTSB CHI85FAMS2Accident · 2 fatalMissing aircraftFinal reportCessna 170B · Chicago(L.Mich), ILAt an unknown time during the night of July 25/26 the acft crashed into lake Michigan. Exact wx conditions are unknown. The passenger was recovered from the lake the next morning, along with the two crushed front seats and two buckled interior side panels.…Jul 25, 1985 · N3160B · DestroyedNTSB MIA85LA209Accident · 4 fatalLimited investigationFinal reportPiper PA-32R-301 · Bahamas, BahamasThe acft failed to arrive at it's intended destination on a flt from nassau, Bahamas to opa locka arpt, miami, FL. The acft was reported missing by the miami fss. The U.S. Coast guard initiated a search on 07-12-85 at about 1831 EDT & search was suspended on…Jul 12, 1985 · N8341L · DestroyedNTSB SEA85FA156Accident · 1 fatalField investigationFinal reportKibler-Bede BD-5B · Oak Harbor, WAPrior to the acdnt, witnesses aprx 9 mi sw of the crash site saw an acft (matching the description of N5KB) flying at about 100 to 200 ft over the water on a NE heading. It then pulled up in a steep climbing turn toward the shoreline. No known witnesses saw…Jun 29, 1985 · N5KB · DestroyedNTSB CHI85FA259Accident · 2 fatalField investigationFinal reportTaylorcraft BC12-D1 · Mundelein, ILThe acft contacted terrain in a near vertical attitude aprx 1/4 mile east of the plt's private airstrip. There were no witnesses to the accident, however, the acft was observed flying at low altitudes prior to the accident. An autopsy report on the passenger…Jun 28, 1985 · N44340 · DestroyedNTSB LAX85FA293Accident · 1 fatalField investigationFinal reportRolladen-Schneider LS3-A · Callahan, CAThe plt was participating in a x-country soaring competition. He released from the tow at 5,000 ft above sea level. About one hour later he imformed his crew by radio that he had covered 80 percent of the first leg and that he was 'doing fine.' The flt did…Jun 24, 1985 · N31JN · DestroyedNTSB SEA85FA142Accident · 3 fatalField investigationFinal reportMaule M-6-235 · Gibbonsville, IDThe plt and two passengers departed on a 2 hr flt for the purpose of conducting aerial observation of mine sites. The acft was operating in mountainous terrain during hot temp conditions resulting in a high density alt. There were no witnesses to the…Jun 18, 1985 · N121A · DestroyedNTSB LAX85LA273Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Waipahu, HIAprx 1/2 hr into this dual instructional flt the acft struck unmarked high voltage pwr cables, entered an uncontrolled descent and struck the ground. One of the purposes of the flt was to practice emergency apch procedures. Both the instructor and the student…Jun 13, 1985 · N6573S · Substantial damageNTSB CHI85FAMS1Accident · 1 fatalMissing aircraftFinal reportBeech E18S · Cleveland, OHThe flight departed & proceeded en route without incident. Radar & radio contact was maintained until the flt proceeded over lake erie. The flt did not arrive at it's destination. The acft is presumed to have crashed in lake erie. One identifiable 3 ft x 4 ft…Jun 6, 1985 · CFFLC · DestroyedNTSB MIA85FA180Accident · 3 fatalField investigationFinal reportPiper PA-34 · Loxahatchee, FLThe plt & passengers were seen drinking beer in a bar prior to the flt. After the acft took off, witnesses observed it flying very low near a shoreline; one of them was a police officer that identified the acft by its registration number. At aprx 1930, the…May 28, 1985 · N3449Q · DestroyedNTSB SEA85FA110Accident · 1 fatalField investigationFinal reportCessna 402 · Pocatello, IDShortly after departure & level off, the plt reported an eng malfunction & initiated a return to the arpt. About 2 min later, he reported an eng fire & declared an emergency. Aprx 1 min thereafter, the rgt wing separated from the acft & the plane crashed. An…May 16, 1985 · N402CS · DestroyedNTSB MIA85LA176Accident · 1 fatalLimited investigationFinal reportCessna 210K · Missing AcftThe Acft departed miami, FL, at about 0700 EDT on a flt to port-au-prince, haiti. It did not arrive at its destination or return to miami. The Acft was not found & was presumed to have been destroyed. Also, the plt was not found & was presumed to have been…May 8, 1985 · N9465M · DestroyedNTSB FTW85FA209Accident · 2 fatalField investigationFinal reportLuscombe 8E · Verden, OKAt about 1700 CDT on 5/5/85, the acft was observed taking off at chickasha, OK. At sometime after 1700, an acft matching its description was observed flying low over a lake. A witness in that area observed it pulled up in a steep climb over the dam, until it…May 5, 1985 · N2497K · DestroyedNTSB MIA85FA153Accident · 3 fatalField investigationFinal reportSikorsky S-58ET · Gulf Of MexicoThe helicopter disappeared while on an overwater flt from key west, FL to ft peirce, FL. One occupant & the wreckage of the helicopter were subsequently recovered from the Gulf Of Mexico. The plt & the other occupant were not located & were presumed dead.…Apr 20, 1985 · N65526 · DestroyedNTSB MIA85IA147Incident · No injuriesIncident investigationFinal reportHawker Siddeley HS-125 · Ft Lauderdale, FLThe plt reported that on an FAA check flt, the nose gear would not extend. Subsequently, the acft received minor damage when it was landed with the nose gear retracted. An investigation revealed that a nose landing gear door rod assembly had failed from…Apr 12, 1985 · N888WK · Minor damageNTSB SEA85FA086Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Sunnyside, WAThe acft crashed after colliding with electrical power lines near an open field. Initial impact with the power lines occurred where the wires were routed over a draw between 2 ridges. The acft came to rest inverted between the power lines & the open field.…Apr 7, 1985 · N4379Z · DestroyedNTSB CHI85FA156Accident · 3 fatalField investigationFinal reportCessna 172N · White Cloud, MIAt about 0250 EST, control tower psnl at the grand rapids arpt heard a 'mayday' call from N23TC, but when they tried to communicate with the acft, there was no response. The call was repeated svrl times. A check at the local arpt revealed there was an acft…Apr 5, 1985 · N23TC · DestroyedNTSB LAX85FA192Accident · 2 fatalField investigationFinal reportCessna 150L · Corona, CAThe student & instructor plt (CFI) were on a local instructional flt. The student had flown a total of only 3 hrs prior to this flt. Just before the accident, the acft was observed spinning toward the ground in a near vertical descent. It impacted in an…Apr 2, 1985 · N1588Q · DestroyedNTSB MIA85FA140Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Rockledge, FLOn March 31, 1985 the rental acft departed merritt island flon April 1, 1985 the acft was found crashed near Rockledge FL. No evidence of pre-existing airframe or powerplant failure was found. The acft impactd the ground in a high velocity 40 degree nose down…Mar 31, 1985 · N5180S · DestroyedNTSB MIA85LA135Accident · No injuriesLimited investigationFinal reportCessna 206 · Key West, FLAfter the acft departed the seaplane parking area, the plt noticed that the left float was taking on water. He initiated a turn back towards the ramp area & applied full power in an attempt to reach shallower water. As he apchd the parking area & was turning…Mar 27, 1985 · N4944U · Substantial damageNTSB MIA85LA132Accident · No injuriesLimited investigationFinal reportCessna 150H · Fort Pierce, FLTakeoff run was reported to be normal. After lift off the aircraft would not climb and engine RPM was noticed to be 300 RPM low. The aircraft descended and struck a pine tree at the end of the runway. The aircraft was being operated within 60 pounds of the…Mar 24, 1985 · N6587S · Substantial damageNTSB MIA85FA112Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Jacksonvile, FLThe single eng land, pvt plt had an instrument rating, but had no rating to fly multi-eng acft. While on an illegal flt with marijuana on board, he contacted jacksonville apch control & advised that he could not see the ground due to dense ground fog, the…Mar 4, 1985 · N100DT · DestroyedNTSB ATL85LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Reidsville, GAThe acft was found burning in the woods by the foresty service. No persons or baggage were found. The date, time & cause of the accident is unknown. Suspected drug related activity. According to FAA records, the acft was not officially registered. It had been…Feb 28, 1985 · N4565P · DestroyedNTSB LAX85FA150Accident · 1 fatalField investigationFinal reportJim Mckinstry Arestia Ganador · Marana, AZThe aircraft was observed to land fast from a low approach with its canopy open. The aircraft then veered right, and went over on its back at the edge of the runway where it burned. One counterweight had separated from the propeller hub assembly and was not…Feb 22, 1985 · N2JM · DestroyedNTSB FTW85FA112Accident · 2 fatalField investigationFinal reportCessna 402B · Altus, OKDuring an eng start, prior to the flt, the l eng backfired 2 or 3 times. A witness described the 1st backfired as 'the loudest I have ever heard.' When the acft took off, two persons living near the departure end of the rwy noted that the acft (believed to be…Feb 6, 1985 · N5780M · DestroyedNTSB LAX85FA131Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Woodside, CAThe plt departed san carlos for a 12 NM x-country to half moon bay, CA, with a return leg to san carlos. It is not know whether or not the flt arrived at half moon bay. The acft crashed in remote mountainous terrain aprx 4 NM west of the Woodside VOR which is…Feb 1, 1985 · N8345Y · DestroyedNTSB MIA85LAMS2Accident · 4 fatalFinal reportCessna 337 · Atlantic Ocean, FLThe acft was reported missing and search & rescue control center initiated a search on 1-17-85. The search was suspendedon 1-24-85. The last reported position of the acft was 66 miles northeast of jacksonville, FL. The acft is still missing & the damage index…Jan 14, 1985 · N505CX · Destroyed