NTSB investigations, OR

393 cases where the phase of flight was Approach.

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 = 500)
  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 SEA93LA157Accident · No injuriesLimited investigationFinal reportCessna 150L · Ontario, ORThe pilot in command's failure to maintain proper clearance. A factor contributing to the accident was the pilot in command's delayed go around.Jul 10, 1993 · N10050 · Substantial damageNTSB SEA93LA104Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Seaside, ORThe pilot in command's delaying the go around. Factors contributing to the accident were tailwinds and the pilot in command's misjudgement of wind information.May 11, 1993 · N435BW · Substantial damageNTSB SEA93LA100Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Pendleton, ORFuel exhaustion due to the pilot's failure to refuel. Factors contributing to the accident were the pilot's becoming lost/disoriented and soft terrain.Apr 22, 1993 · N3163X · Substantial damageNTSB SEA93LA011Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Enterprise, ORPoor in-flight planning/preparation. A factor to the accident was: improper use of the mixture.Oct 24, 1992 · N16221 · Substantial damageNTSB SEA93LA004Accident · 1 fatalLimited investigationFinal reportCarlson Midget Mustang · Baker, ORAn inadvertent stall/spin by the pilot in command. A factor contributing to the accident was the pilot in command's lack of recent experience.Oct 4, 1992 · N111C · DestroyedNTSB SEA92LA080Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Sunriver, ORThe pilot did not accurately calculate fuel consumption. A factor to the accident was: fuel exhaustion.Apr 21, 1992 · N60754 · Substantial damageNTSB SEA92LA063Accident · Minor injuriesLimited investigationFinal reportBellanca 17-31A · Eugene, ORAn improper fuel boost pump selector position, and incorrect procedures. Factors include an improper fuel tank selector position, and fuel starvation.Mar 19, 1992 · N8266R · Substantial damageNTSB SEA92LA035Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Newberg, ORA poorly planned final approach. Factors in the accident were: proper glidepath was not maintained and inadequate remedial action.Jan 4, 1992 · N7491R · Substantial damageNTSB SEA91LA239Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Hillsboro, ORInadequate preflight planning, which resulted in an inadequate fuel supply and fuel exhaustion.Sep 16, 1991 · N714RK · Substantial damageNTSB SEA91LA204Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Sunriver, ORThe pilot's inadequate compensation for wind conditions, which resulted in a failure to maintain runway alignment. The gusty crosswind was a related factor.Aug 9, 1991 · N8444S · Substantial damageNTSB SEA91LA197Accident · No injuriesLimited investigationFinal reportCessna 150M · Hillsboro, ORFailure of the pilot to refuel resulting in fuel exhaustion.Jul 31, 1991 · N9190U · DestroyedNTSB SEA91LA137Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Warrenton, ORThe pilot failed to maintain proper rotor speed during a simulated autorotation.Jun 19, 1991 · N9380F · Substantial damageNTSB SEA91LA129Accident · No injuriesLimited investigationFinal reportBoeing E75 · Aurora, ORAn improperly adjusted carburetor and improper maintenance. Factors include an earthen berm which the aircraft struck during the landing roll.Jun 8, 1991 · N1067N · Substantial damageNTSB SEA90FA182Accident · 1 fatalField investigationFinal reportCessna 150M · Prospect, ORThe pilot's failure to maintain a proper altitude during his approach. The dark night condition was a contributing factor.Sep 14, 1990 · N3420V · DestroyedNTSB SEA90FA064Accident · 3 fatalField investigationFinal reportCessna 182M · North Bend, ORThe pilot did not follow the published IFR procedure.Apr 11, 1990 · N71779 · DestroyedNTSB SEA90LA054Accident · 1 fatalLimited investigationFinal reportde Havilland DH 82A · White City, ORPilot's delay in taking remedial action to prevent an undershoot. His misjudgement of distance and altitude on final approach were related factors.Mar 20, 1990 · N353FG · Substantial damageNTSB SEA89FA182Accident · Serious injuriesField investigationFinal reportPiper PA-28-151 · Bridal Veil, ORVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain adequate airspeed, which resulted in a stall. Factors related to the accident were: the adverse weather conditions, the pilot's lack of instrument experience,…Sep 30, 1989 · CGIWO · DestroyedNTSB SEA89LA178Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Portland, ORThe pilot's poor inflight planning. Contributing to the accident was the wake turbulence and remedial action not possible.Sep 26, 1989 · N3660W · Substantial damageNTSB SEA89FA154Accident · 3 fatalField investigationFinal reportBeech C90 · Gold Beach, ORThe pilot's failure to initiate a go-around after emerging from a fog bank on a short final which resulted in inadequate airspeed and a stall. Contributing to the accident was the pilot's poor judgement in attempting the VFR approach in IMC conditions.Aug 21, 1989 · N25ST · DestroyedNTSB SEA89LA094Accident · No injuriesLimited investigationFinal reportCessna 182B · Bend, ORThe pilot allowed his attention to be diverted by a crosswind and failed to maintain clearance from trees on approach.May 29, 1989 · N2770G · Substantial damageNTSB SEA89LA081Accident · No injuriesLimited investigationFinal reportCessna 150 · Yamhill, ORFailure of the pilot to maintain proper airspeed on final approach. Contributing to the accident was lack of total experience.May 6, 1989 · N6575G · Substantial damageNTSB SEA89LA070Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics LA-4 · Yamhill, ORPilot displayed poor inflight planning and preparation for the flight. The pilot did not adequately compensate for the wind conditions resulting in an intentional gear up landing.Apr 15, 1989 · N2990P · Substantial damageNTSB SEA89LA007Accident · No injuriesLimited investigationFinal reportAerospatiale SA341G · Fields, ORThe plt rprtd that as he was in a slow descending turn to the left at about 20 KTS (translational lift). The helicopter suddenly rotated to the left without warning. He estimated that this occurred at about 30 ft AGL. He applied right pedal & the rotation…Oct 4, 1988 · N401S · Substantial damageNTSB SEA88LA184Accident · No injuriesLimited investigationFinal reportPiper PA-31T-620 · Eugene, ORPlt had IFR clrnc and was on ILS approach in VMC above thin fog layer at night. Plt had visual contact with runway environment but collided with 10 foot tall ILS middle marker antenna/building 1/2 mile from runway threshold, separating left main lndg gear and…Sep 23, 1988 · N234K · Substantial damageNTSB SEA88LA093Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Prineville, ORThe pilot reduced power for landing and a high sink rate developed. The pilot attempted to increase power to correct the sink rate but got no response. Rotor rpm's were diminishing, so the plt lowered the collective to regain rpm's. the pilot elected make an…May 12, 1988 · N751AM · Substantial damageNTSB SEA88LA088Accident · No injuriesLimited investigationFinal reportCessna 172M · Hood River, ORPlt had diverted back along course to land because of observed wx ahead. On late final, a strong wind gust tipped the acft to near wings-vertical attitude. Plt managed to correct to wings level but could not control altitude loss before ground contact. Plt…May 6, 1988 · N12659 · Substantial damageNTSB SEA88LA025Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Cornelius, ORThe pilot was attempting to land in a field near a farmhouse. On final approach the pilot cleared large power lines, but had not seen small power lines ahead and below the aircraft. The aircraft struck the power lines in flight with the nose gear. The…Nov 27, 1987 · N4523Z · Substantial damageNTSB SEA87FA185Accident · 2 fatalField investigationFinal reportCessna TR182 · Tillamook, ORDrg arrival, the plt was cleared for an ndb-a apch & received approval to change to the local adzy freq. After that, there was no further radio comm with the acft. Radar data showed the acft crossed over the initial apch fix (iaf) & began a rgt outbound turn…Sep 10, 1987 · N9484R · DestroyedNTSB SEA87LA144Accident · No injuriesLimited investigationFinal reportPiper PA-11 · The Dalles, ORThe pilot was at 50 feet AGL on final approach to land at his private airstrip when he lost control. Reportedly, a gust of wind turned the aircraft 180 degrees. The aircraft descended and struck trees and the ground. Winds were reported variable at 40 to 45…Jul 22, 1987 · N5030H · Substantial damageNTSB SEA87FA112Accident · Serious injuriesField investigationFinal reportCessna 150L · The Dalles, ORThe student plt's instructor became seriously ill after the first leg of a dual, cross country flight. Another instructor/pilot examiner signed off on the student pilot's logbook to return solo to the departure airport. The instructor/pilot examiner failed to…Jun 9, 1987 · N6528G · Substantial damageNTSB SEA87LA076Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Alkali Lake, ORDuring a windy crosswind approach the pilot lost control of the aircraft. The aircraft struck the ground short of the runway breaking off the nose gear and then nosing over inverted.Apr 4, 1987 · N1770J · Substantial damageNTSB SEA87FA060Accident · 2 fatalField investigationFinal reportCessna 182 · North Bend, ORPlt was inbound to VORTAC in clouds for localizer approach to rwy 4. Wx at arpt reporting 1500 ft bkn. Plt expected to make missed approach to continue VFR to another arpt. Plt reported inbound in and out of clouds at 1300 ft. acft crashed 4 NM beyond arpt,…Feb 21, 1987 · N3266Y · DestroyedNTSB SEA87MA034Accident · 3 fatalMajor investigationFinal reportBell 206L-1 · Pendleton, ORThe helicopter departed Pendleton on an emerg med svc/med-evac (EMS) flt to transport a patient to portland. After delivering the patient, the plt took off on the rtn flt with 2 med psnl aboard. Drg arrival at 1658 PST, he requested a special VFR (svfr)…Dec 4, 1986 · N7EC · DestroyedNTSB SEA86LA236Accident · No injuriesLimited investigationFinal reportCessna 172N · Lord Flat, ORThe plt elected to go-around at about four feet AGL. Flaps were reduced from 40 degrees of flaps to 20 degrees of flaps and a gentle right turn was made due to rising terrain. The acft then settled onto the ground and crossed two ditches before coming to…Aug 29, 1986 · N737NT · Substantial damageNTSB SEA86LA206Accident · No injuriesLimited investigationFinal reportCessna 340 · Prairie City, ORThe plt was attempting to land the acft on an unlit airstrip during dusk conditions. While attempting to align the acft with the center of the 30 foot wide airstrip the plt heard the stall warning horn sounding. During an attempted go around an inadvertent…Aug 13, 1986 · N2696U · Substantial damageNTSB SEA86LA113Accident · No injuriesLimited investigationFinal reportCessna 172 · Hubbard, ORDuring practice simulated forced landing with the power reduced to idle and gusting crosswinds airspeed was lost. The aircraft entered into an approach stall striking the ground nose first and then nosing over inverted.Apr 27, 1986 · N65654 · Substantial damageNTSB SEA86IA095Incident · No injuriesIncident investigationFinal reportRaven RX-7 · Beaverton, ORThe pilot misjudged obstacle clearance during his descent for landing. The balloon's envelope was then impaled on a light pole. Flt time was not reported by the plt.Apr 7, 1986 · N27980 · Minor damageNTSB SEA86LA082Accident · Serious injuriesLimited investigationFinal reportSocata MS894A · Wasco, ORThe plt stated that he encountered a wind shear on final. At the time of the accident the wind was recorded to be from the south/southeast at two knots with peak winds at four knots. When the plt noticed that his airspeed had deteriorated to 50 mph, he went…Mar 26, 1986 · N54BF · Substantial damageNTSB SEA85LA145Accident · Serious injuriesLimited investigationFinal reportCessna 310L · Albany, ORThe plt was attempting to bracket the low bar on the 2 bar VASI to avoid landing long on the rwy. On final, the acft landing gear struck unmarked powerlines. The acft then struck the ground in a level attitude. A small fire ensued in the left tip tank. The 4…Jun 25, 1985 · N222MR · Substantial damageNTSB SEA85LA101Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Bandon, ORThe plt was ferrying the acft to Bandon to have the landing gear repaired. The flt was made with the gear secured in the down position. The acft had locking fuel caps & the plt did not visually check the fuel level before taking off; instead, he relied of the…May 3, 1985 · N5543 · Substantial damageNTSB SEA85LA088Accident · No injuriesLimited investigationFinal reportCessna 172M · Mulino, ORThe plt pushed the throttle forward to add power during final approach and the engine ceased operating. A forced landing was made onto a cabbage patch and the nose gear sheared off. The acft then nosed over. Investigation revealed the throttle cable housing…Apr 8, 1985 · N80241 · Substantial damageNTSB SEA85FA056Accident · 4 fatalField investigationFinal reportGulfstream AC-680F · Central Point, ORThe plt reported a loss of power on both engs during descent to land. Aprx 3 mins prior, twr gave plt option of 'straight-in' to rwy 14 or reg pattern to rwy 32. The plt hesitated & said 'just a minute' & twr offered wind info as '210 at 13.' Plt replied,…Feb 9, 1985 · N233W · DestroyedNTSB SEA85FA050Accident · 2 fatalField investigationFinal reportCessna 175 · White City, ORThe acft crashed after stalling during a go-around attempt. Witnesses said the acft was on final approach to the unlighted arpt with 40 degrees of flap when the go-around attempt was made. The acft rolled and turned 180 degrees before impacting the ground…Jan 27, 1985 · N7277M · DestroyedNTSB SEA84LA225Accident · No injuriesLimited investigationFinal reportCessna 150 · Bandon, ORThe plt indicated that 15 minutes had been flown on the full fuel tank prior to the accident flight. The plt departed at 1330 on a siteseeing flt around the local area. After 3.7 hrs of flight, while on final approach to rwy 34, the engine quit. The plt…Sep 10, 1984 · N111HT · Substantial damageNTSB SEA84LA212Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Medford, ORThe pilot had been advised by his CFI to avoid using this airstrip during midday due to thermal disturbances. During power-off approach, updrafts were encountered and a right turn out for go-around was initiated; however, power was not added. The aircraft…Aug 23, 1984 · N5153M · Substantial damageNTSB SEA84FYK01Accident · Serious injuriesFinal reportCessna 172N · Creswell, ORThe acft collided with wires during an attempted go-around. The plt stated that he had made one go-around and on the 2NDLANDING attempt he landed hard in gusty wind & bounced. During the 2nd go-around he collided with wires & crashed.Aug 11, 1984 · N3278E · DestroyedNTSB SEA84LA184Accident · Serious injuriesLimited investigationFinal reportHeveron Sandpiper 83B · Mcminnville, ORA student pilot lost control of an ultralight vehicle when he encountered a local gusty wind condition at 200' AGL and collided with the ground in an uncontrolled descent. The ultralight was built for registration as an experimental aircraft, but…Jul 27, 1984 · N4751N · Substantial damageNTSB SEA84LA181Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Creswell, ORThe acft was on a night VFR flt from san carlos, CA, to eugene, OR, when the plt asked apch control how for away the arpt was. ATC informed the plt that the arpt was 16 miles further. About 3 minutes later, the left fuel tank was emptied. The plt switched to…Jul 21, 1984 · N8732E · Substantial damageNTSB SEA84LA176Accident · No injuriesLimited investigationFinal reportCessna 182D · Eugene, ORThe plt estimated that the acft had about 1 hr of fuel remaining in the tanks prior to departure. However, after he had flown about 15 min, the eng lost power & would not restart. An emergency landing was made in a meadow about 2 mi from the arpt. The acft…Jul 17, 1984 · N8820X · Substantial damageNTSB SEA84LA136Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Burns, ORDuring flt over a mountainous area, the plt became lost & called a flt service station. Subsequently, he was located & given vectors to the Burns arpt. However, the eng lost power from fuel exhaustion & the plt made a forced landing about 2 from the arpt.…Jun 17, 1984 · N49853 · Substantial damage