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 SEA86LA051Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Sandy, ORA total loss of power occurred due to a complete loss of oil. During engine teardown it was found that the oil filter adapter had slipped past the threads in the oil pump housing. The aircraft had the oil filter adapter replaced as well as the o ring on…Feb 1, 1986 · N2085R · Substantial damageNTSB SEA86LA036Accident · No injuriesLimited investigationFinal reportCessna 140 · Ione, ORThe pilot attempted to fly his newly purchased aircraft a distance of 3 miles from one local airstrip to another for the purpose of hangaring it. A ceiling of 500 feet overcast with 5 miles visibility fog and freezing rain were present. The windscreen iced up…Jan 5, 1986 · N1920V · Substantial damageNTSB SEA86LA026Accident · No injuriesLimited investigationFinal reportHughes 269C · Brooks, ORA total loss of power occurred due to the number 4 cylinder failing. A tail boom strike occurred during a hard landing in a parking lot, severing the tail boom.Nov 24, 1985 · N58181 · Substantial damageNTSB SEA86LA012Accident · No injuriesLimited investigationFinal reportCessna 152 · Ontario, ORA forced landing occurred due to a total loss of power. Landing was accomplished onto a freshly plowed potato field where substantial damage occurred. No reason for the loss of power could be determined.Oct 12, 1985 · N24977 · Substantial damageNTSB SEA86LA005Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Medford, ORThe acft collided with rocky terrain during an attempted forced landing following a loss of pwr. A witness reported seeing the acft in a steep descending left turn at an alt of aprx 100 ft AGL. The descent continued until the left wing contacted the terrain.…Oct 6, 1985 · N7798X · DestroyedNTSB SEA85LA227Accident · No injuriesLimited investigationFinal reportBeech J35 · Ontario, ORThe plt was flying the acft at a low alt for the purpose of spotting game. The eng ceased operating shortly after switching fuel tanks. The plt stated during a telephone interview that he inadvertently switched the fuel selector to the off position. The acft…Sep 26, 1985 · N8245D · Substantial damageNTSB SEA85LA215Accident · No injuriesLimited investigationFinal reportVarga 2150A · Vale, ORThe acft nosed down after the nose gear collapsed during a forced landing on a dirt road following a loss of pwr. The plt reported that aprx 1 hr into the x-country flt he noted the fuel gages indicated 1/2 full on each tank. A state trooper reported he…Sep 16, 1985 · N8291J · Substantial damageNTSB SEA85LA216Accident · No injuriesLimited investigationFinal reportCessna 152 · Independence, ORThe plt descended to a low alt over a river to look for birds. While over the river the plt spotted pwr lines at an alt of aprx 75 ft AGL. An attempt was made to fly under the lines, but the tail contacted the wires severing aprx 6 inches off the top portion…Aug 18, 1985 · N49282 · Substantial damageNTSB SEA85FYM03Accident · 2 fatalFinal reportCessna 170B · Manzanita, ORAircraft was observed to enter a low overcast shortly after take off. The aircraft then hit a mountain about 4 miles north of the departure airport.Jul 29, 1985 · N8011A · Substantial damageNTSB SEA85LA123Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Wamic, ORA forced landing was made following a loss of pwr. The acft contacted two fences, a ditch then nosed over during the forced landing. Post accident inspection revealed no fuel in the carburetor float chamber or in the accelerator pump chambers.May 27, 1985 · N5914G · Substantial damageNTSB SEA85FA233Accident · 2 fatalField investigationFinal reportCessna 172N · Remote, ORDuring a wx briefing, the non-instrument plt was adzd that VFR flt was not recommended due to low clouds & adverse wx along the route. However, he filed a VFR flt plan & depd arcata, CA at 1240 PDT. At 1339, in the vcnty of wilderville, OR, the plt got a wx…May 23, 1985 · N4871G · DestroyedNTSB SEA85LA097Accident · No injuriesLimited investigationFinal reportHiller 12E · Myrtle Point, ORDuring a CFR 137 flight a total loss of power occurred with an audible screech coming form the engine area. Autorotation was made and the acft was landed into a hevily treed area with steep terrain. During engine tear down a fractured impeller was found.…Apr 26, 1985 · N99GM · Substantial damageNTSB SEA85LA094Accident · No injuriesLimited investigationFinal reportHelio H-295 · John Day, ORReportedly, the acft encountered airframe icing conditions during flt, & subsequently, mushed into trees on wooded terrain. Elevation of the crash site was about 4500 ft. about 95 mi west at redmond, OR, the wx was in part: 800 ft overcast, 3 mi visibility,…Apr 21, 1985 · N94747 · Substantial damageNTSB SEA85LA054Accident · 4 fatalLimited investigationFinal reportCessna 182-F · Ashland, ORThe plt was briefed regarding weather and expected flt conditions btw medford and redding. The briefing included a forecast for improving conditions approaching the destination as well as possible icing en route. The acft departed medford carrying aprx 970…Feb 5, 1985 · N3559Y · DestroyedNTSB SEA85LA013Accident · No injuriesLimited investigationFinal reportPiper PA38 · Williams, ORPlt was flying 150 to 200 ft AGL at 80 to 85 mph. Upon pwr application to return to alt, plt stated, carburetor heat conrol was not returned to the 'off' position. Plt stated acft did not want to climb so pwr was removed and an attempt to fly under…Oct 22, 1984 · N9513T · Substantial damageNTSB SEA85FA012Accident · 4 fatalField investigationFinal reportCessna 182B · Tiller, ORThe acft collided with rising terrain about 1800 ft below the crest of a ridge while on a personal flt in wx which had multiple cloud layers obsuring the mountains. A cap acft on a search mission in the same area at the aprx time reported multiple cloud…Oct 15, 1984 · N2612G · DestroyedNTSB SEA85LA009Accident · No injuriesLimited investigationFinal reportCessna 150L · Lapine, ORPlt recieved inflt wx brief. Present location and next reporting station were VFR, no known adverse wx between. En route, plt encountered IMC. Fuel comsumed in maneuvering to aviod wx precluded return to known VFR airfield. Plt elected to make a precautionary…Oct 14, 1984 · N11849 · Substantial damageNTSB SEA84FA215Accident · 6 fatalField investigationFinal reportPiper PA-28-180 · The Dalles, ORN6499J departed The Dalles municipal arpt shortly after 0930 PDT on a flt to vancouver, WA. N4622T departed chenoweth airfield ( aprx 4 NM west of The Dalles) at about 0930 PDT on a flt to The Dalles municipal arpt. A witness who observed both acft before the…Sep 1, 1984 · N6499J · 2 aircraft · DestroyedNTSB SEA84FA201Accident · 3 fatalField investigationFinal reportCessna 182E · Prineville, ORThe acft hit a tree during a forced landing approach to a large open field after an engine failure. Post accident investigatiion revealed that a rod cap bolt had failed which started the internal destruction of the engine. This bolt was installed as a new…Aug 18, 1984 · N3159Y · DestroyedNTSB SEA84LA194Accident · No injuriesLimited investigationFinal reportBeech C-23 · Adel, ORPlt made forced landing in sagebrush covered hilly terrain following a ttl loss of pwr resulting from fuel exhaustion.Aug 10, 1984 · N6183X · Substantial damageNTSB SEA84IA168Incident · No injuriesIncident investigationFinal reportBoeing B-737-222 · Portland, ORAfter takeoff, the acft was climbing thru about 4000 ft when the APU fire warning light illuminated. The flt crew discharged the fire extinguishing units & requested an emergency landing. A teardown of the APU revealed evidence that a hard object was injested…Jul 9, 1984 · N9015U · No damageNTSB SEA84LA166Accident · Serious injuriesLimited investigationFinal reportMooney M-20C · Chiloquin, ORThe acft stalled and crashed during a forced landing after the engine quit. The acft had only been airborne for about 5 minutes. The plt told FAA inspectors he was going to get fuel. He stated that the left tank had less than 1/4 tank and 'a small ammount' in…Jul 7, 1984 · N6931N · Substantial damageNTSB SEA84FA135Accident · 2 fatalField investigationFinal reportGrumman American AA-5 · Hammond, ORThe acft was seen first to make a turn to the north followed by a turn to the south. It then went into a nose down attitude and descended until it disappeared from view. The acft collided with the terrain. An investigation revealed no apparent malfunction…Jun 16, 1984 · N5465L · DestroyedNTSB SEA84LA121Accident · No injuriesLimited investigationFinal reportNavion A · Noti, ORAt about 4,000 ft MSL, the eng began to run rough. The plt made a 180 deg turn to return to his departure arpt. The eng then quit. He turned the fuel boost pump on, applied carburetor heat, leaned the mixture & checked the mags. The eng started & ran for…May 27, 1984 · N4327K · Substantial damageNTSB SEA84FA111Accident · 4 fatalField investigationFinal reportStinson 108-3 · Portland, ORThe plt was briefed on the weather along his intended route of flt & VFR flt was not recommended. The acft departed vancouver, WA, and flew to tigard, OR. It was observed to depart tigard at about 1810 PDT. Numerous witnesses reported that at about 1815, they…May 20, 1984 · N20Q · DestroyedNTSB SEA84FA088Accident · 2 fatalField investigationFinal reportCessna 150L · Diamond Lake, ORThe acft was on a flt from sacramento, CA to vancouver, british columbia, via red bluff, klammath falls, eugene, portland & seattle. During a wx briefing at 0545 PST, the non-instrument rated plt was advised that VFR flt was not recommended. However, he filed…Apr 16, 1984 · CGHLW · DestroyedNTSB SEA84FA078Accident · 2 fatalField investigationFinal reportBeech N35 · Baker, ORThe plt encountered airframe icing while en route during a x-country flt. He had filed an instrument flt plan to boise, ID, but en route, he changed destinations twice, 1st to ontario, OR, then later to Baker, ID. At 1820 PDT, he reported icing & turbulence…Apr 6, 1984 · N1270Z · DestroyedNTSB SEA84LA075Accident · No injuriesLimited investigationFinal reportCessna T210N · Seaside, ORThe acft nosed over during a forced landing in a soft field after a loss of power. The plt said that while the acft was descending thru about 6000 ft MSL, he ran the left fuel tank dry before switching tanks. His attempt to restart the engine, using the right…Mar 30, 1984 · N7972N · Substantial damageNTSB SEA84FA068Accident · 6 fatalField investigationFinal reportPiper PA-28RT-201 · Hood River, ORAfter crossing the dalles at 12,500 ft MSL, the plt reported to ARTCC he was entering solid clouds. He subsequently reported level at 3,000 ft MSL followed by 'if ah we can't stay VFR we'll go ahead and climb up to about five and file IFR.' The acft was…Mar 12, 1984 · N8301T · DestroyedNTSB SEA84LA054Accident · No injuriesLimited investigationFinal reportAerospatiale AS-341G · Alma, ORThe plt stated he lost partial power on a x-country flt, during cruise, and initiated an autorotation. At about 200 to 300 ft AGL he reduced the throttle to idle. During flare the rotor RPM decayed and the acft landed hard and rolled over. The pilot stated…Feb 17, 1984 · N633B · Substantial damageNTSB SEA84LA047Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Imnaha, ORThe acft nosed over during a forced landing on a snow covered field. The plt reported that the acft began to lose power at about 6500 ft MSL. An inspection of the eng did not reveal any mechanical malfunction or discrepancy.Jan 27, 1984 · N7771K · Substantial damageNTSB SEA84LA044Accident · No injuriesLimited investigationFinal reportCessna T21OL · Bend, ORThe plt reported that he departed boulder city, NV with 92 gal of fuel on board. About 4 hrs & 10 min later, he was forced to land when the eng lost power from fuel exhaustion. According to him, the fuel gages had been indicating normal with an indication of…Jan 25, 1984 · N2223S · Substantial damageNTSB SEA84FU001Accident · Serious injuriesFinal reportEipper Quicksilver MX · Junction City, ORAccording to the plt, he was operating the ultralight between 50 & 200 ft AGL, when he experienced throttle control difficulties. He reported that while correcting the problem, his attention to the surrounding environment was reduced. When he returned his…Jan 4, 1984 · UNREG · Substantial damageNTSB SEA83FYM07Accident · Serious injuriesFinal reportMaule M-5-235C · Silverton, ORThe acft landing gear collapsed during a forced landing after an engine failure. The acft had climbed to 1000 ft AGL after takeoff when the pilot switched the fuel selector to the right fuel tank. Immediately the engine quit and switching back to the left…Jun 27, 1983 · N6205M · Substantial damageNTSB SEA83LA130Accident · Serious injuriesLimited investigationFinal reportCessna 337B · Dayton, ORThe pilot stated he was demonstrating a 'steep letdown' to his passenger from about 3200 MSL. The descent was with full flaps, landing gear extended and power off on both engines. At about 1200 MSL the pilot leveled off and added power and had none on the…Jun 20, 1983 · N5479S · Substantial damageNTSB SEA83LA128Accident · No injuriesLimited investigationFinal reportCessna 152 · Cascade Locks, ORThe acft collided with a guard rail after making a forced landing on a highway during a student solo cross-country flight. The flight had originated at vancouver WA, and the student pilot had been instructed to refuel at pendleton, OR.a landing was made at…Jun 16, 1983 · N757WT · Substantial damageNTSB SEA83FYM06Accident · Serious injuriesFinal reportCessna T210L · Hermiston, ORThe acft stalled into the ground in a semi-controlled crash forced landing after the engine quit due to fuel exhaustion.a post accident examination revealed only one ounce of fuel aboard the acft. The acft release form from Boeing aircraft to the pilot for…Jun 8, 1983 · N393AC · Substantial damageNTSB SEA83FA118Accident · 4 fatalField investigationFinal reportPiper PA28RT-201T · Gov'T Camp, ORWx conditions along the flt route indicated ceilings of 25,000 ft & unrestricted visibility except for the area south & west of mount hood. Mount hood, elevation 11,239 ft MSL, on the sw side of government Camp & clear lake (accident site),was covered by…Jun 8, 1983 · N8402P · DestroyedNTSB SEA83LA136Accident · No injuriesLimited investigationFinal reportSnow S2C · Hepner, ORThe acft slid sideways on a sloping field during a forced landing and damaged a wing. The pilot said he had sprayed two fields and was enroute to spray another when a complete loss of power occurred. The pilot stated that he found no usablefuel in either fuel…Jun 3, 1983 · N1665S · Substantial damageNTSB SEA83LA107Accident · No injuriesLimited investigationFinal reportBeech V35-TC · Wendling, ORThe acft collided with trees and dense brush during an off airport forced landing in IMC weather. According to the pilothe was about 10 minutes into a cross country flight at 4000 feet MSL when fuel pressure dropped and he lost engine power. The pilot…May 25, 1983 · N7980M · DestroyedNTSB SEA83LA097Accident · No injuriesLimited investigationFinal reportPiper PA-25-235B · La Grande, ORThe acft stalled about 30 feet AGL during a forced landing after the engine quit from fuel exhaustion. The pilot took the acft for a ferry flight without refueling. It had been flown about 1 hour & 15 minutes. It holds about 36 gallons and burns about 14…May 14, 1983 · N7757Z · DestroyedNTSB SEA83LA081Accident · No injuriesLimited investigationFinal reportSmith Miniplane · Near Rainier, ORAprx 20 min after takeoff, the engine lost power. Several restarts were initiated; however, the engine would not continue running. During an emergency landing on sandy terrain, the nose gear dug in & the acft nosed over the plt described the loss of power as…Apr 15, 1983 · N94R · Substantial damageNTSB SEA83LA079Accident · No injuriesLimited investigationFinal reportErco 415C · Boring, ORThe aircraft collided with a fence and collapsed the nose gear during a forced landing after the engine lost power in cruise flight. The pilot had departed Oregon city earlier to fly to evergreen airport to fuel the aircraft and then to return to Oregon city.…Apr 4, 1983 · N87110 · Substantial damageNTSB SEA83FYM04Accident · No injuriesFinal reportMooney M20K · Dufur, ORThe aircraft collided with an irrigation pipe line and fence during rollout of a forced landing after engine failure. The engine stopped while the aircraft was cruising en route. The pilot remained in radio contact throughout the emergency and landed in a…Jan 24, 1983 · N97429 · Substantial damageNTSB SEA83FA037Accident · 1 fatalField investigationFinal reportCessna T210N · Portland, ORThe acft collided with the side of a hill during a descent. The pilot had canceled his IFR clearance and radar services were terminated and a frequency change was approved. Shortly thereafter the acft was observed flying beneath the clouds toward the hill…Jan 6, 1983 · N5370Y · DestroyedNTSB SEA83FYM02Accident · 2 fatalFinal reportEnstrom 280C · North Plains, ORAt about 0530 PST, the pilot departed from his home at ridge field, WA on a flight to hillsboro, OR. According to the pilot's instructor, the normal route used for this trip would been to proceed on a southerly heading to cornelius pass, go through the pass,…Dec 17, 1982 · N5686Z · DestroyedNTSB SEA83LA032Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Chemult, ORThe flt encountered heavy snow enroute & the eng quit. During the autorotation the plt maneuvered to avoid hitting a railroad signal trestle but struck several railroad signal cables & crashed. The acft was not equipped with a particle separator, nor was the…Dec 15, 1982 · N90876 · Substantial damageNTSB SEA83LA023Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Cascade Locks, ORWhile cruising at 10000 feet MSL, in IMC conditions, the pilot reported that power had been lost. During descent to 2000 feet the engine restarted and failed several times but eventually maintained idle throughout the remainder of the descent. Portland…Nov 20, 1982 · N8185P · Substantial damageNTSB SEA83FYK01Accident · Serious injuriesFinal reportPiper PA-32-300 · 27ne Rogue Rive, ORAt 9,500 ft the eng failed. The acft impacted a large tree while maneuvering to land on a rural road in heavily forested mountains. Eng examination revealed that the top of the case had a large hole on the rear portion. Pushrod housings were missing from #5 &…Nov 10, 1982 · N656ZM · DestroyedNTSB SEA83FYM01Accident · 1 fatalFinal reportBellanca 7GCBC · 1/4nm S. Of Peo, ORThe pilot and passenger were on a pleasure flight over the willamette river. The passenger stated that after following the river the aircraft began to climb and turn east. There was a sudden jolt and the plane began to spin and impacted the water.Oct 10, 1982 · N57457 · Substantial damage