NTSB investigations, OR

695 cases where the phase of flight was Enroute.

Cases, newest first

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 c.\"eventStateOrRegion\" = 'OR' AND c.\"eventCountry\" = 'USA'
    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 DEN89FA091Accident · 1 fatalField investigationFinal reportCessna 210D · Eugene, ORThe pilot's decision to continue VFR flight into instrument meteorological conditions (IMC). Factors related to the accident were: the terrain and weather conditions at the accident site, and the pilot's lack of instrument experience.Mar 23, 1989 · N3823Y · DestroyedNTSB SEA89FA053Accident · 3 fatalField investigationFinal reportPiper PA-60-601P · Lakeview, ORFailure of the pilot to maintain control of the aircraft, which resulted in a spin and an uncontrolled descent. Factors related to the accident were: improper maintenence by the pilot, an autopilot malfunction, the adverse weather conditions, continued flight…Mar 4, 1989 · CFHGH · DestroyedNTSB SEA89LA049Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Beaver Marsh, ORAn loss of engine power due to a failed exhaust valve. Contributing to the accident was the snow covered terrain on which a precautionary landing was made.Feb 15, 1989 · N95286 · Substantial damageNTSB 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 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 DEN88FA213Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Curtin, OROn 9/20/88, the plt & his wife depd montaque, CA, on a flt to silverdale, WA, with a planned refueling stop at cottage grove, OR. When the acft did not arrive, a search was made, but to no avail. On 1/24/90, a tree planting crew found the acft, where it had…Sep 20, 1988 · N3863P · DestroyedNTSB SEA88LA182Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260 · Bend, ORAt aprx 1239 PDT, while on an IFR x-country flt at 14,000', the acft enctrd icing conds. Drg the next 1.4 hrs, the plt changed altitude in increments, climbing to 17,000', then descending to 11,000' to avoid icing. At aprx 1411 PDT, he indcd the eng had lost…Sep 19, 1988 · N8765P · DestroyedNTSB SEA88LA181Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Cottage Grove, ORWhen plt realized strong headwinds at cruise alt would preclude reaching intended destination, he attempted to divert to another alternate. Fuel exhaustion occurred before reaching arpt. During a lndg, executed in dark, acft collided with a fence.Sep 17, 1988 · N1223T · Substantial damageNTSB SEA88LA163Accident · No injuriesLimited investigationFinal reportCessna 152 · Cascade Locks, ORThe student pilot reported that during cruise while on a solo cross country training flight the engine began to surge. He called ATC and was directed to the nearest available airport. The student pilot landed long and fast and departed theend of the runway.…Aug 25, 1988 · N94649 · Substantial damageNTSB SEA88LA158Accident · No injuriesLimited investigationFinal reportCessna 185 · Hillsboro, ORThe pilot reported that the engine lost power during a fuel tank switchover. The aircraft collided with a telephone pole guy wire on the road during the forced landing. The investigation revealed a fuel leak induced when the fuel boost pump was in operation.…Aug 20, 1988 · N14407 · Substantial damageNTSB SEA88LA149Accident · No injuriesLimited investigationFinal reportCessna 152 · Yoncalla, ORStudent plt was at 8500 ft crz when pwr loss occurred. Forced lndg made in open field where acft collided with fence on lndg roll. Engine ran normally post-mishap. Fuel sample clear of water or other contaminant. Plt did not use carb heat when pwr loss…Aug 8, 1988 · N67992 · Substantial damageNTSB SEA88LA147Accident · No injuriesLimited investigationFinal reportBell 206B · Enterprise, ORWhile in cruise flt at abt 500 ft AGL, the plt stated he heard a 'ping' sound from the eng and pwr decreased to flt idle. An autorotation was attempted into a cleared upsloping area but the plt had to pull 'up' collective in order to clear a fence. A hard…Aug 6, 1988 · N300TW · Substantial damageNTSB SEA88LA126Accident · Minor injuriesLimited investigationFinal reportBeech C23 · The Dalles, ORCFI underestimated fuel consumption on multi-stop cross country and did not visually check fuel remaining prior to last departure. Fuel exhaustion occurred 18 minutes into flight. Acft flipped inverted on forced landing.Jul 13, 1988 · N18823 · Substantial damageNTSB SEA88LA117Accident · Serious injuriesLimited investigationFinal reportCessna 210G · Bend, OROn arrival in area of planned fuel stop, pax did not feel well. Plt determined that adequate fuel remained to continue to final destination. However, exhaustion occurred 8 miles short of destination. Plt diverted from initial forced lndg site (road) due…Jun 25, 1988 · N5923F · DestroyedNTSB SEA88FA084Accident · 1 fatalField investigationFinal reportMaule M5-210C · Bend, ORPlt filed VFR after advised VFR not recommended. Witness observed acft on course for dest at low alt over hiway. Witness EST ceiling at 100 feet, visibility poor in mod snow. Acft observed to execute sharp left turn amd impact rising terrain. Corrective…Apr 25, 1988 · N312X · DestroyedNTSB SEA88LA067Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Ashland, ORDuring a dark night VFR flight, the acft encountered a severe downdraft and instrument meteorological conditions. With full power the acft descended, striking trees before it struck the ground. During the pilot's preflight briefing and in-flight briefing he…Mar 27, 1988 · N2958D · DestroyedNTSB SEA88IA065Incident · No injuriesIncident investigationFinal reportBoeing 727-232 · Portland, ORCrew was unable to lower the left main lndg gear. Crew then executed an emergency landing on the right main and nose gear with minor damage to the acft. The investigation revealed that the left main gear door attach fitting had a fatigue fracture.Mar 21, 1988 · N515DA · Minor damageNTSB SEA88LA062Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Umpqua, ORWhile flying low over a river the aircraft struck unmarked telephone wires. An off-airport landing was made onto a cow pasture. During the landing the aircraft struck the ground nose first. Post acc inspection revealed telephone wire insulation wedged near…Mar 19, 1988 · N81788 · DestroyedNTSB SEA88FA054Accident · Minor injuriesField investigationFinal reportCessna T210N · Burns, ORThe aircraft engine quit during cruise flt on a bright moonlit night cross country flt at 8000 ft AGL, 28 NM west of Burns, OR. The pilot reversed course in an emergency descent and followed a straight 50 ft wide hwy toward Burns. At approx 500 ft. AGL the…Mar 2, 1988 · N5427A · DestroyedNTSB SEA88FA034Accident · 3 fatalField investigationFinal reportCessna 182J · Molalla, ORThe recently certificated, non-instrument rated, pvt plt flew into the an area of low ceilings, low vis, rain & snw w/o filing a flt plan. No record of a wx briefing was fnd. A surviving pax rprtd that drg flt, the plt flew into clds that were initially…Dec 30, 1987 · N2758F · DestroyedNTSB SEA88LA016Accident · No injuriesLimited investigationFinal reportHiller FH-1100 · Turner, ORWhile on a short cross country flight the pilot encountered a rain storm and low clouds. The pilot made a 180 degree turn and then elected to make a precautionary landing in a field. Although the pilot visually inspected the area prior to landing, he did not…Nov 12, 1987 · N35HA · Substantial damageNTSB SEA88LA014Accident · No injuriesLimited investigationFinal reportBell 47G2 · Lebanon, ORThe student was performing an autorotation at about 50' AGL and the flare was begun. The instructor pilot noticed that the helicopter was not leveling and took control of the aircraft. The helicopter settled tail low onto the soft ground striking the tail…Oct 26, 1987 · N6141 · Substantial damageNTSB SEA88LA010Accident · No injuriesLimited investigationFinal reportCessna 150-M · Myrtle Creek, ORA loss of power occurred shortly after takeoff due to fuel exhaustion. A field was chosen for the off airport landing. During the landing rollout the aircraft struck a fence and raspberry bushes, collapsing the nose gear.Oct 18, 1987 · N7695U · Substantial damageNTSB SEA87LA173Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Burns, ORA loss of power occurred during descent for landing. During forced landing the aircraft struck an irrigation ditch, collapsing the nose gear. The reason for the engine failure was a complete loss of oil coming from worn threads and a worn o ring to the oil…Aug 21, 1987 · N2007Y · Substantial damageNTSB SEA87LA148Accident · No injuriesLimited investigationFinal reportCessna 150G · Gresham, ORDuring the student pilot's long solo cross-crounty a loss of power occurred. During the forced landing the pilot overshot the intended field so he selected a nearby field. He overshot this field, flew between 2 trees at 20 feet AGL and descended to the…Jul 25, 1987 · N2415J · Substantial damageNTSB SEA87LA142Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Ashland, ORPlt was proceeding VFR, no flt plan, no record of wx brief, northbound through siskiyou pass along I-5 from calif into Oregon about 1400 PDT. Plt reported suddenly in clouds, then saw trees. Acft collided with rising terrain 1/2 mile west of point where I-5…Jul 17, 1987 · N95407 · DestroyedNTSB SEA87LA110Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Aurora, ORDuring climbout at about 500 feet AGL for a touch and go, a loss of power occurred. Forced landing was accomplished onto a rough field where the left wing struck a small tree. The aircraft spun around and the nose gear and main gear collapsed. Examination of…Jun 7, 1987 · N9232K · Substantial damageNTSB SEA87LA104Accident · No injuriesLimited investigationFinal reportCessna 172 · Prospect, ORThe acft lost pwr during cruise flt due to loss of oil pressure because of multiple oil leaks. The recommended t.b.o. is 1800 hrs and this eng had a total of 2344 hrs. A top overhaul had been accomplished 140 flt hrs prior to the acc. The acft had only been…May 29, 1987 · N4173F · Substantial damageNTSB SEA87LA085Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Ritter Butte, ORDuring a cross country flt the plt noticed that he was gradually losing his communications radio and navigational instruments. Shortly afterwards the plt noticed that the fuel gauges were quickly approaching empty. Since hostile terrain was ahead the plt…Apr 25, 1987 · N1935F · DestroyedNTSB SEA87LA069Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Medford, ORA total and sudden loss of power occurred at about 3,500 feet MSL during climb for cruise. The pilot made a 180 degree turn back to the airport. Since an undershoot was assured the pilot elected to land the aircraft on a field. During landing rollout at about…Mar 27, 1987 · N4878V · Substantial damageNTSB SEA87LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Coburg, ORThe student pilot was in the process of flying his long cross country flight in order to qualify for his private pilots certificate. Prior to reaching the home airport, the students instructor talked to him from the ground and advised the student not to land,…Mar 9, 1987 · N68747 · Substantial damageNTSB SEA87LA017Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Paisley, ORThe acft contacted power lines during a night forced landing on a highway following a loss of pwr. The power lines paralleled the road. Investigation revealed no discrepancies with the engine or fuel system. Planned fuel reserve was found in the tanks. The…Nov 4, 1986 · N8338V · Substantial damageNTSB SEA87LA016Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-400 · Oregon City, ORShortly after takeoff, an eng failure occurred. The plt elected to make a forced lndg on a freeway. During the landing, the acft collided with two vehicles. An inspection revealed an eng oil line had ruptured which led to oil exhaustion. Evidence indicated…Nov 2, 1986 · N8419P · Substantial damageNTSB SEA87LA011Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Perrydale, ORThe acft descended to terrain impact during a descent for landing. The plt stated he recalled entering a descent so he would be at 1,000 ft MSL on crosswind for landing. The plt does not recall any further details concerning the accident due to head injuries.Oct 14, 1986 · N8184F · DestroyedNTSB SEA86LYA02Accident · No injuriesFinal reportInav Moni · Riverside, ORPower plant seized in flight. Plt attempted forced landing on road, wings struck sagebrush on road shoulder. It was not determined why the engine seized in flight.Sep 23, 1986 · N39200 · Substantial damageNTSB SEA86LA247Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Tillamook, ORA precautionary landing was made on a field due to low fuel, lowering ceiling and visibility, ensuing darkness, and the pilot not knowing his exact position. Landing was made on an uphill field with a slight tail wind. The aircraft struck a swale and then…Sep 18, 1986 · N3565L · Substantial damageNTSB SEA86LA229Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Tygh Valley, ORAn uncertificated plt was flying the acft at a low altitude when the acft struck wires. Due to the damage to the acft a forced landing was made onto a bark dump where additional damage occurred to the acft.Aug 30, 1986 · N5159T · Substantial damageNTSB SEA86FA232Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · John Day, ORThe non-instrument rated pilots departed hermiston en route to burns, Oregon. Visual meteorological conditions prevailed; however, mountain tops along the route of flight were occasionally obstructed by local cloud layers. During the course of the flight the…Aug 30, 1986 · N3618R · DestroyedNTSB SEA86LA234Accident · No injuriesLimited investigationFinal reportCessna 182 · Ashwood, ORA loss of power occurred for unknown reason. During landing roll the aircraft's right main gear struck a rock causing part of the gear box to be torn from the aircraft.Aug 25, 1986 · N9051T · Substantial damageNTSB SEA86LA212Accident · Minor injuriesLimited investigationFinal reportMooney M-20-J · Aurora, ORAt about 9,000 feet MSL the pilot smelled smoke and electrical fumes. He then turned off the master switch and returned to land. He manually lowered the landing gear but it folded upon landing roll. Investigation revealed no mechanical reason for the gear to…Aug 18, 1986 · N201PJ · DestroyedNTSB SEA86LA182Accident · Serious injuriesLimited investigationFinal reportBell 47G3B1 · Albany, ORA Bell 47G3B1 crashed into the south santiam river after contacting power lines while on an instructional flight. The CFI (helicopter) plt received serious injuries and the private plt (airplane) helicopter student received minor injuries. The helicopter…Jul 29, 1986 · N9417A · Substantial damageNTSB SEA86LA156Accident · No injuriesLimited investigationFinal reportCessna 188 · Durkee, ORWhile crossing a mountain ridge at low altitude, the aircraft encountered downdrafts. The pilot was forced to land as he was unable to arrest the descent rate. The landing was accomplished onto very rough terrain.Jun 28, 1986 · N4835Q · Substantial damageNTSB SEA86LA133Accident · No injuriesLimited investigationFinal reportCessna 188B · Nyssa, ORDuring aerial application the engine ceased operating due to a broken shaft in the fuel pump. The boost pump was turned on and the engine ran momentarily. The pilot was unable to dump his 700 pounds of dry chemical and had to keep a nose down attitude in…May 24, 1986 · N53177 · DestroyedNTSB SEA86LA129Accident · No injuriesLimited investigationFinal reportCessna 310 · Skinner Ranch, ORThe pilot elected to make a precautionary landing due to a stated electrical problem. The runway was only 30 feet wide and the aircraft struck a dirt mound to the right of the center line. The aircraft's main landing gear then collasped.May 23, 1986 · N2634C · Substantial damageNTSB SEA86LA110Accident · No injuriesLimited investigationFinal reportRobinson R22-A · Portland, ORAt aprx 500 ft AGL, while on a local traffic watch, a loss of pwr occurred. A 15 kt tail wind was present. Pwr lines had to be cleared and a hard landing resulted. An examination and test run of the eng failed to disclose any failure/ malfunction which would…Apr 25, 1986 · N8536Z · Substantial damageNTSB SEA86LA109Accident · No injuriesLimited investigationFinal reportGrumman G164-A · Echo, ORA loss of power occurred shortly after takeoff on a downwind departure. A forced landing was accomplished onto a wheat field downhill. The aircraft nosed over during the landing roll. Post accident inspection of the aircraft disclosed fuel contamination.Apr 23, 1986 · N25SK · Substantial damageNTSB SEA86LA105Accident · No injuriesLimited investigationFinal reportBell 47G3B1 · Albany, ORThe plt reported that after aprx 15 minutes of flt, the eng sputtered 2 or 3 times. An autorotation was performed onto rough terrain during which the tail rotor drive shaft was damaged by the main rotor blades. Post accident inspection revealed a hole in the…Apr 15, 1986 · N9417A · Substantial damageNTSB SEA86LA087Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Warm Springs, ORA precautionary landing was made due to the pilot becoming lost, the aircraft's navigation radio not working, and low fuel. A gusting crosswind was present during landing. On rollout the aircraft's wing tip caught a fence and the aircraft nosed over.Mar 30, 1986 · N6958B · Substantial damageNTSB SEA86FA066Accident · 2 fatalField investigationFinal reportPiper PA34-200T · Antelope, ORPlt was operating VFR on top at 11000 feet, commenced descent to destination 34 miles out. Plt rpted field in sight 16 miles out, passing 6500 ft, cancelled flight plan. Acft impacted ridge at 4100 feet MSL 7 miles from destination. Dark night conds existed,…Feb 26, 1986 · N8305C · DestroyedNTSB SEA86LA060Accident · No injuriesLimited investigationFinal reportCessna 340 · Burns, ORThe aircraft encountered airframe icing on a descent for a VOR approach. 1/8 to 1/4 inch of ice was present during landing. The pilot allowed a stall to occur prior to touch down with a hard landing resulting.Feb 19, 1986 · N7774Q · Substantial damage