OpenAirDocs.org

NTSB investigations, 1988

656 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\") = 1988
    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 LAX89FA076Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Wrightwood, CAAccording to the passenger, during a cross country flight the airplane encountered instrument meteorological conditions. The pilot flew the airplane toward a mountain range and entered a valley with rising terrain. Still in IMC, just prior to the accident,…Dec 31, 1988 · N5369L · Substantial damageNTSB NYC89IA063Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10 · Atlantic Ocean (Atlantic Ocean)American flt 1180 (McDonnell-douglas DC-10) was northbound ovr the Atlantic Ocean at flt lvl 350 as a british royal air force vickers VC10 was cruising east at the same alt (non-standard alt for the VC10'S drctn of flt). They were in a non-radar airspace…Dec 30, 1988 · N153AA · 2 aircraft · No damageNTSB ATL89LA064Accident · No injuriesLimited investigationFinal reportMooney M20F · Perdido, ALWhile descending to 6000 feet the pilot experienced a complete loss of engine oil supply. The windscreen was covered with oil and the pilot had to use the side window to gain forward visibility. After completing the emergency landing check the engine seized.…Dec 30, 1988 · N6969V · Substantial damageNTSB DEN89LA050Accident · No injuriesLimited investigationFinal reportCessna 152 II · Gilcrest, COThe plt, with his wife as a pax, departed greeley, CO, on a cross-country flt to clayton, NM. After landing, the pilot had his aircraft refueled. It took 23.5 gallons of fuel to fill the fuel tanks. The plt then took off, flew 46 miles southeast, then turned…Dec 29, 1988 · N46974 · Substantial damageNTSB MIA89LA059Accident · No injuriesLimited investigationFinal reportCessna 177A · West Palm Beach, FLThe private pilot contacted lakeland tower in flt about 2115 and was told that no fuel was available. He elected to continue flt. The pilot experienced an engine failure due to fuel exhaustion after 4 hours and 12 minutes of flight. He then executed a forced…Dec 28, 1988 · N30564 · Substantial damageNTSB FTW89LA033Accident · Serious injuriesLimited investigationFinal reportCessna TU206D · Alamo, TXAirplane's collision with trees and terrain during an attempted forced landing at night following an engine faiure. The engine failure was caused by fuel starvation as a result of a faulty fuel system which the operator had failed to correct.Dec 28, 1988 · N72249 · DestroyedNTSB SEA89LA030Accident · 1 fatalLimited investigationFinal reportCessna 205 · Cottage Grove, ORThe student pilot took off on a solo flight from an uncontrolled airport at Cottage Grove in marginal weather conditions. Shortly after takeoff, he transmitted to eugene tower (which was approximately 15 miles north) that he had encountered 'white-out'…Dec 27, 1988 · N8403Z · DestroyedNTSB CHI89LA037Accident · No injuriesLimited investigationFinal reportCessna P210R · Grovertown, INDec 27, 1988 · N5457A · Substantial damageNTSB DCA89IA016Incident · Minor injuriesIncident investigationFinal reportBoeing 727-25 · Morgantown, WVFuselage skin 'flapped' open between body stations 1090 and 1110 and peeled downward from stringer #4 left to stringer #5 left. A scratch or scribe mark was co-located with the longitudinal crack along stringer #4. The area of damage was located on the aft…Dec 26, 1988 · N8148N · Minor damageNTSB ATL89DKJ01Accident · Serious injuriesFinal reportSloan RV-4 · Russellville, ALWhile cruising at 2500 feet with ram air gate open, engine began to run rough. The plt closed the ram air gate and applied carb heat but the engine continued to run rough and then stopped. The pilot attempted to land in an open field, clearing several large…Dec 26, 1988 · N77SA · Substantial damageNTSB LAX89FA074Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Yucca, AZPilot's failure to maintain directional control. Contributing factors included the pilot's improper in-flight decision which was related to his overconfidence in his personal ability, spatial disorientation upon encountering inclement weather during the…Dec 25, 1988 · N9276M · DestroyedNTSB NYC89LA057Accident · Minor injuriesLimited investigationFinal reportPiper PA-44-180T · Princeton, NJThe acft experienced a loss of power of both engines and crashed into trees near Princeton airport, Princeton, NJ. The pilot flew 4.5 hrs and after a missed approach one engine quit. While attempting to make Princeton airport the other engine quit. According…Dec 24, 1988 · N91PA · DestroyedNTSB LAX89FA069Accident · 2 fatalField investigationFinal reportCessna T210L · Norco, CAAccident was that the pilot became disoriented and was unable to arrest the ensuing descending spiraling turn.Dec 24, 1988 · N94210 · DestroyedNTSB DEN89IA047Incident · No injuriesIncident investigationFinal reportCessna 210L · Roswell, NMPlt preflighted acft and noted indication of 9 qts of oil in crankcase. Flt departed Roswell (row) in night VMC en route to abq. Plt had just leveled off at 6500 ft MSL when he noticed oil pressure gauge fluctuating. Oil pressure then began dropping and plt…Dec 24, 1988 · N59217 · Minor damageNTSB LAX89LA068Accident · Serious injuriesLimited investigationFinal reportBoeing 747SP-21 · Midway Islands (Pacific Ocean)Aircraft's encounter with unforecast severve clear turbulence.Dec 23, 1988 · N146UA · No damageNTSB LAX89LA067Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Victorville, CADuring cruise flight, the engine lost power. The pilot initiated a forced landing on an interstate. During the descent, the airplane collided with transmission wires and subsequently came to rest on interstate 15. During an inspection of the wreckage, it was…Dec 23, 1988 · N4297X · Substantial damageNTSB ATL89FA058Accident · 2 fatalField investigationFinal reportCessna 414 · Bloomville, OHDec 23, 1988 · N84UM · DestroyedNTSB CHI89DET02Accident · No injuriesFinal reportCessna 150H · Benton Harbor, MIA misjudged approach during the execution of an emergency landing resulting in an encounter with unsuitable terrain. Contributing factors are inaccurate fuel consumption calculations and fuel starvation due to contamination.Dec 22, 1988 · N50331 · Substantial damageNTSB MIA89FA054Accident · 2 fatalField investigationFinal reportCessna 310L · Cedar Key, FLThe evidence indicated that personnel failed to tighten a fuel line at the fuel pressure switch on left engine resulting in fuel line leaking into the engine compartment in flight. An inflight fire burned through a fuel crossfeed fuel line which could not be…Dec 21, 1988 · N2251F · DestroyedNTSB LAX89LA073Accident · 1 fatalLimited investigationFinal reportBell 206L-1 · Oakland, CAPilots intentional flight into known adverse weather condititions from which he inadvertently descended into the water at a high rate of speed. Contributing to the accident was the pilot's failure to obtain a weather briefing; lack of recent instrument flying…Dec 21, 1988 · N1072S · DestroyedNTSB ATL89LA056Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Athens, GAWhile cruising at 6,000', the plt felt an intense vibration fm the eng. Power was reduced & a descent was begun toward a nearby arpt. Before reaching the arpt, the eng lost power & an emergency wheels-up landing was made in an open field. An exam of the eng…Dec 20, 1988 · N17696 · Substantial damageNTSB MKC89LA041Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Linwood, KSPoor in-flight planning and decision, inadequate visual lookout, and clearance not attained by the pilot in command.Dec 18, 1988 · N5012J · Substantial damageNTSB NYC89LA051Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Stacyville, METhe student pilot became lost during a cross country flt. The flight was continued until the acft ran out of fuel. The aircraft collided with trees during an emergency landing and nosed over. The plt told the state police at the acc site that the acft had run…Dec 17, 1988 · N6558P · DestroyedNTSB MKC89LA039Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Rolla, MOWhile returning from a personal cross country flight, the newly certificated private pilot said that the winds picked up and he was blown 30 miles east of his intended course. In addition, he was running one hour over the time allotted for the trip. He landed…Dec 17, 1988 · N704LB · Substantial damageNTSB CHI89DEE01Accident · No injuriesFinal reportCessna 210L · Bannock Burn, ILFuel starvation caused by ice blocked fuel lines.Dec 17, 1988 · N5225K · Substantial damageNTSB SEA89LA026Accident · No injuriesLimited investigationFinal reportCessna 152 · Medford, ORThe pilot departed the airport without obtaining fuel. Approximately 15 gallons of fuel was on board which would make the fuel tanks about one-half full. At the time of the accident the aircraft had been airborne for over 2 hours and 10 minutes. Dark visual…Dec 16, 1988 · N67638 · Substantial damageNTSB NYC89LA050Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Lyme, CTImproper planning; the student pilot became lost and ran out of fuel. During the landing he misjudged distance, altitude and airspeed and overran the field colliding with trees.Dec 16, 1988 · N63136 · Substantial damageNTSB DEN89FA041Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Arvada, WYThe pilot entered clouds and shortly thereafter, crashed near the city of Arvada, WY. The flight consisted of two aircraft, flying together in loose formation, at night, under a layer of clouds. The plt of the lead acft estimated that about 2 min elapsed when…Dec 15, 1988 · N3110Q · DestroyedNTSB ATL89LA055Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Athens, GADuring descent toward his intended destination, the pilot noted a floating ammeter needle and shortly thereafter he noted his oil pressure was zero. The engine seized and he selected a straight stretch of paved road for his forced landing. In the final stages…Dec 12, 1988 · N14695 · Substantial damageNTSB NYC89LA047Accident · No injuriesLimited investigationFinal reportMooney M20J · New Alexandria, PALoss of control experience during landing rollout after an off airport landing was made due to a power loss caused by contaminated fuel. Water had been removed prior to departure.Dec 11, 1988 · N3820H · Substantial damageNTSB LAX89IA062Incident · Minor injuriesIncident investigationFinal reportCessna 152 · Haleiwa, HIThe aircraft experienced a partial loss of power and collided with the terrain while completing an emergency landing in a sugar cane field. During this particular maneuver the CFI indicated that he was reasonably sure he cleared the engine at least once a few…Dec 11, 1988 · N94825 · Minor damageNTSB CHI89LA031Accident · No injuriesLimited investigationFinal reportCessna 150 · Varna, ILThe student pilot was cruising at 2000' MSL on a solo flight, when the engine lost power. Emergency procedures were initiated and a forced landing was made in an open field. During the landing roll, the aircraft struck a dirt bank and was damaged. A…Dec 11, 1988 · N704KV · Substantial damageNTSB MKC89LA037Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Jacksonville, ARDuring a local familarization and acceptance flight for the new acft owner, smoke entered the cockpit and oil pressure was lost. A precautionary emergency ldg was attempted on a soft, muddy, plowed farm field, resulting in substantial damage to the acft.…Dec 10, 1988 · N8356P · Substantial damageNTSB NYC89LA044Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Laconia, NHAircraft striking the road sign after the aircraft experienced a double power loss due to mismanagement of the fuel system by the pilot.Dec 7, 1988 · N16502 · Substantial damageNTSB MKC89LA031Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Martelle, IAAnticipating a fuel shortage on a personal cross country flight, the plt requested the nearest airport from approach control. The nearest apt was within five miles of his destination apt so continued on course. About 15 miles from his destination, and having…Dec 7, 1988 · N198V · Substantial damageNTSB MIA89FA048Accident · Serious injuriesField investigationFinal reportCessna 150J · Gainesville, FLPlt obtained weather briefing prior to departure at which time he was told the possibility of IFR conditions on arrival at destination existed due to fog. Plt failed to obtain en route weather briefing. Near his destination, the plt encountered IFR…Dec 7, 1988 · N60029 · DestroyedNTSB LAX89LA061Accident · Minor injuriesLimited investigationFinal reportBeech K35 · Arbuckle, CADuring cruise flight, the pilot noted oil on the windshield. The pilot diverted to a nearby airport. Enroute the windshield became covered with oil. The pilot opted to make an emergency landing on a road. Due to power lines, he diverted to an open field. Just…Dec 7, 1988 · N9569R · Substantial damageNTSB FTW89LA031Accident · Minor injuriesLimited investigationFinal reportMBB BO-105 · South Marsh 113Failure and separation of one of the tail rotor blades for undetermined reasons. Thr resulting imbalance and vibration caused the separation of the 90 degree gearbox and a portion of the vertical pylon which necessitated the emergency autorotation to the…Dec 5, 1988 · N2785B · Substantial damageNTSB ATL89LA053Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Vidalia, GAAircraft experienced loss of power and returned to airport. Departed second time and experienced rough running engine. Aircraft attempted emergency landing and overturned in field. Examination of the engine revealed piston failure in #4 cylinder. Post acc…Dec 5, 1988 · N9107M · Substantial damageNTSB NYC89LA042Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Chambersburg, PAThe pilot of the Piper PA-28 was at cruise altitude and getting advisories from ATC. ATC gave him a SIGMET for turbulence when he noted his fuel was getting low. He decided to land at a nearby airport and was told by ATC that the airport he wanted was at his…Dec 4, 1988 · N2179Y · DestroyedNTSB FTW89LA029Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Texarkana, TXDec 3, 1988 · N22229 · Substantial damageNTSB CHI89DEX02Accident · No injuriesFinal reportCessna 172 · Greencastle, INInflight collision with a large bird.Dec 3, 1988 · N5728A · Substantial damageNTSB CHI89DEV04Accident · 1 fatalFinal reportTesori Regionne 2002 · Urbana, ILThe plt transmitted on an advisory frequency 'clear the area I have engine trouble'. While turning from downwind to the base leg of his emergency approach to the airport, witnesses observed the airplane in a steep right bank when it suddenly banked left and…Dec 3, 1988 · CGFSY · Substantial damageNTSB NYC89DNE01Accident · 1 fatalFinal reportBell 47D1 · Russell, MAA pilot induced low rotor RPM condition, followed by blade flapping as the main rotor blade contacted the tail of the helicopter.Dec 2, 1988 · N163B · DestroyedNTSB LAX89DUQ02Accident · No injuriesFinal reportChamberlain Long EZ · Camarillo, CADuring a local test flight, the pilot had reduced power to decrease altitude for approach to the airport. When power was applied, the engine did not respond. The pilot made an off-runway landing. Inspection of the airplane revealed that the spring on the…Dec 2, 1988 · N84BJ · DestroyedNTSB ATL89FA047Accident · 3 fatalField investigationFinal reportBeech P35 · Bakersville, NCDuring the VFR business flight radar data indicated the acft descended from 9,500 to approx. 5,500' MSL where it collided with a mountain. Clouds were present in the area. There were no witnesses to the accident. The wreckage was located by ELT signal. The…Nov 30, 1988 · N9584Y · DestroyedNTSB MIA89LA046Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Atlantic Ocean (Atlantic Ocean)The student pilot contacted ifss at miami, FL and filed an intl flight plan to the Bahamas. He did not request a weather briefing and none was given. The pilot later contacted controllers and stated that he was in instrument meteorological conditions and…Nov 28, 1988 · N7926N · DestroyedNTSB MIA89LA045Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Crestview, FLWhile in cruise flt near an arpt, the prop separated. Plt was given vectors to arpt & entered pattern for lndg. Downwind leg was extended due to strong tailwind. Strong headwind on final caused acft to land short. During landing roll acft collided with two…Nov 28, 1988 · N8226P · Substantial damageNTSB DEN89FA038Accident · 1 fatalField investigationFinal reportCessna 150L · Fairplay, CONov 28, 1988 · N1464Q · DestroyedNTSB MIA89FA044Accident · 4 fatalField investigationFinal reportPiper PA-28-161 · Molino, FLBefore takeoff, the plt was adzd of an apchg cold front in the Florida panhandle as well as a forecast of hvy thunder- storm activity in the area of pensacola. En route, he was provided VFR flt following from pensacola apch ctl while cruising at 6500 ft.…Nov 27, 1988 · N8033Y · Destroyed