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 SEA84FA123Accident · 1 fatalField investigationFinal reportPiper PA-34-200 · North Bend, ORThe acft was cleared for an ILS rwy 4 apch while 9 miles north of oth (North Bend) VOR. Instructions were given to cross oth VOR at or above 3700 ft MSL. 14 min later, the plt reported to North Bend fss 'my needle doesn't seem to be moving on my localizer…Jun 4, 1984 · N1067U · DestroyedNTSB SEA84LA082Accident · No injuriesLimited investigationFinal reportCessna 172N · Harrisburg, ORThe plt reported that after the sun had set, a haze formed near the ground. He used visual references to align the acft with the private rwy at dusk. As he approached, he saw what he thought was hedge on the edge of the arpt & then made a soft field landing.…Apr 14, 1984 · N734JW · Substantial damageNTSB SEA84FA058Accident · 3 fatalField investigationFinal reportPiper PA-28-J3A5D · Mountaindale, ORThe acft crashed during an instrument approach to hillsboro airport. Witnesses reported seeing the acft below a very low overcast sky condition prior to impact. Examination of the wreckage revealed that the stabilator failed in overload before the point of…Feb 20, 1984 · N83382 · DestroyedNTSB SEA84FA017Accident · 1 fatalField investigationFinal reportCessna A185F · 4nm W Of Boring, ORThe acft collided with 3 major objects, a tree, a house and a motor home during an attempted go-around. The pilot had attempted a landing on a soft short dirt road near his home. The length of the road was 462 ft. he landed 74 ft short ofmarkers at the…Nov 8, 1983 · N53079 · DestroyedNTSB SEA83LA166Accident · No injuriesLimited investigationFinal reportCessna 182E · Agness, ORThe pilot said that he overflew the rwy twice to look for cattle. On the third approach during short final cattle began crossing the rwy in use. The pilot maneuvered to use the other rwy and stalled at about 25 ft AGL. Due to the acft's low alt & high…Aug 2, 1983 · N2840Y · Substantial damageNTSB SEA83LA161Accident · No injuriesLimited investigationFinal reportCessna 182A · Sheridan, ORThe acft lost power on final approach to land and made contact with a fence short of the rwy and nosed over. During preflt the pilot had omitted checking the fuel with a fuel strainer because he did not have one. During inspection the carburetor was found to…Jul 30, 1983 · N6386B · Substantial damageNTSB SEA83FU003Accident · Serious injuriesFinal reportSunburst Ultralight · Independence, ORThe pilot stated that he was trying to teach himself to fly his ultrlight. After several takeoffs from a friends field, a rather severe crosswind started which complicated landing. After numerous passes at the small strip, the pilot said he decided to land…Jun 5, 1983 · UNREG · DestroyedNTSB SEA83LA114Accident · No injuriesLimited investigationFinal reportStinson 108 · Grants Pass, ORThe acft ran off the runway and collided with bushes during an aborted go-around. According to the pilot a crosswind caught the acft as he was landing, in spite of his attempts to keep it straight the acft started to veer to the left and he decided to…May 29, 1983 · N6202M · Substantial damageNTSB SEA83LA100Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Grass Valley, ORThe aircraft stalled while the pilot was attempting to land downwind on an uphill Grass strip. The wind was estimated at 15 gusting to 20 KTS. The pilot stated that on his approach, he was to the left of the center of the landing strip. He attempted to…May 16, 1983 · N7173K · Substantial damageNTSB SEA83LA051Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Oregon City, ORDuring arrival at dusk, the plt made an apch to rwy 9 with a headwind at 19, gusting 30 KTS. While on final apch, the acft collided with power lines near the apch end of the rwy. The plt reported that he did not see the lines until just prior to impact, then…Feb 3, 1983 · N30356 · Substantial damageNTSB SEA83LA050Accident · No injuriesLimited investigationFinal reportCessna 182N · Chiloquin, ORDuring a long straight in approach from about 3 miles out the aircraft lost power. The pilot figured he could not make the runway so he tried for a highway. In diving to avoid wires he drove the nose gear onto the ground. The nose gear was sheared off and the…Feb 2, 1983 · N92353 · Substantial damageNTSB SEA83LA036Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Newport, ORThe engine lost power when the pilot was on an extended base leg for landing. From that position, he could not glide to the runway, so he elected to land on a nearby beach. The location of people walking on the beach prevented an upwind landing, so the pilot…Jan 2, 1983 · N1296M · Substantial damageNTSB SEA83LA014Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Cascade Locks, ORPlt was making a precautionary landing after encountering fog enroute. Two approaches to rwy 24 were aborted due to gusting winds. A downwind approach was then made to rwy 06. When the acft descended below the height of surrounding trees the prevailing…Oct 31, 1982 · N6936P · Substantial damageNTSB SEA82DA161Accident · Minor injuriesFinal reportPiper PA-38-112 · Corvallis, ORThe flight instructor stated that while on a low final approach, a sudden downdraft of windshear occurred causing the aircraft to drop and the right wing to hit the top of a tree. Upon impact the aircraft spun out of control and impacted the ground.Sep 12, 1982 · N2535P · DestroyedNTSB SEA82DA159Accident · No injuriesFinal reportCessna 172 · Prineville, ORDuring the landing attempt the aircraft was blown to the right side of runway 28. The pilot was unable to correct for the wind drift and attempted to execute a go-around but the left wing tip caught in sagebrush off the left side of the runway and the…Sep 9, 1982 · N6220Z · Substantial damageNTSB SEA82FYM23Accident · No injuriesFinal reportHughes 369HS · Troutdale, ORThe flt originated at the plt's residence 20 mi south of the Troutdale arpt. The plt stated the purpose of the flt was to refuel the acft since he figured he had about 8 gals of fuel on departure. As the acft approached the ground at about 50 ft AGL the plt…Aug 21, 1982 · N56AD · Substantial damageNTSB SEA82DA143Accident · No injuriesFinal reportPiper PA-28-161 · Redmond, ORThe student pilot was on a solo cross-country flight from hillsboro, OR to yakima, WA, to Redmond, OR and then return to hillsboro. The pilot reported a number of altitude and course deviations during the first two legs of the cross-country to avoid clouds.…Aug 15, 1982 · N38918 · DestroyedNTSB SEA82FYM21Accident · No injuriesFinal reportCessna TU206G · Hood River, ORThe eng failed as the plt switched from the left to right tank while turning base. He turned on the boost pump but the eng did not start. He switched back to the left tank & turned on the high boost. The eng failed to start & the acft crashed into an apple…Jul 17, 1982 · N756XW · Substantial damageNTSB SEA82FA111Accident · 4 fatalField investigationFinal reportCessna 172F · Oxbow, ORDuring the final approach the aircraft was observed to descend to approximately 50 feet above the river and then execute a pullup and begin a left turn to either reenter a left downwind or reverse the direction of landing. The pilot lost control, the left…Jul 15, 1982 · N8230U · DestroyedNTSB SEA82DA108Accident · No injuriesFinal reportGrumman AA-5B · Corvallis, ORThe aircraft contacted the surface while the pilot was making a low pass over the private airport. Fresh cut hay was windrowed at the edge of the strip. The hay caught on the landing gear and blew up into the elevators and the aircraft was damaged when it…Jul 11, 1982 · N81382 · Substantial damageNTSB SEA82FYM16Accident · Minor injuriesFinal reportHughes 369D · Birkenfeld, ORThe pilot stated that the fuel gauge indicated 150 lbs of fuel remaining when he began the flight. Since the drop point was within 2 to 3 minutes of the departure point, he elected to proceed without refueling. While hovering and being guided into the drop…May 19, 1982 · N1096L · Substantial damageNTSB SEA82DA066Accident · No injuriesFinal reportCessna 150F · Grande Ronde, ORThe student pilot stated that on landing approach the sun was in his eyes. The landing occurred about 50 feet short of the runway threshold when the tail collided with a fence post and the nose wheel contacted a ditch.May 6, 1982 · N6701F · Substantial damageNTSB SEA82FYK07Accident · 1 fatalFinal reportCessna 172 · Lapine, ORWhen the pilot landed at lakeview,OR,he checked the weather but reported to his passenger that although the weather was bad he did not want to stay in lakeview. The aircraft departed lakeview, following a highway, when the weather conditions continued to…Jan 24, 1982 · N8172B · DestroyedNTSB SEA82DYK04Accident · No injuriesClosedCessna 185F · Burns, ORNov 15, 1981 · N4900C · Substantial damageNTSB SEA82FYM04Accident · Serious injuriesClosedPiper PA-22 · Hillsboro, ORNov 14, 1981 · N6844B · Substantial damageNTSB SEA82DYK02Accident · No injuriesClosedPiper PA-24 · Gold Beach, OROct 18, 1981 · N7686P · Substantial damageNTSB SEA81FYM45Accident · No injuriesClosedCessna 421B · Mulino, ORSep 14, 1981 · N777FD · Substantial damageNTSB SEA81DYM40Accident · No injuriesClosedCessna 182Q · Enterprise, ORAug 29, 1981 · N759PC · Substantial damageNTSB SEA81FYK17Accident · Serious injuriesClosedPiper PA-12 · Bend, ORAug 28, 1981 · N7621H · DestroyedNTSB SEA81FYK08Accident · Minor injuriesClosedPiper PA-22 · Medford, ORApr 30, 1981 · N7712D · Substantial damageNTSB SEA81FYK04Accident · Serious injuriesClosedCessna P210 · Medford, ORJan 10, 1981 · N4544K · DestroyedNTSB SEA81DYM10Accident · Serious injuriesClosedStinson L-5 · Philomath, ORDec 7, 1980 · N68842 · Substantial damageNTSB SEA81DYM02Accident · No injuriesClosedPiper PA-28 · Molalla, OROct 3, 1980 · N33638 · Substantial damageNTSB SEA80FYM54Accident · Serious injuriesClosedPiper PA-28 · Portland, ORAug 13, 1980 · N8084V · Substantial damageNTSB SEA80DYM51Accident · No injuriesClosedCessna 150L · Tigard, ORJul 27, 1980 · N11624 · Substantial damageNTSB SEA80FYK10Accident · Serious injuriesClosedPrue Super STD · Brothers, ORJun 27, 1980 · N86675 · DestroyedNTSB SEA80DYM37Accident · No injuriesClosedPiper PA-28 · Yamhill, ORMay 18, 1980 · N32526 · Substantial damageNTSB SEA80DYM36Accident · No injuriesClosedCessna 150M · Yamhill, ORMay 17, 1980 · N63448 · Substantial damageNTSB SEA80DYM31Accident · Minor injuriesClosedNaval Fcty N3N-3 · Pendleton, ORApr 28, 1980 · N45018 · Substantial damageNTSB SEA80FYM16Accident · Minor injuriesClosedPiper PA-24 · Newport, ORFeb 22, 1980 · N5275P · DestroyedNTSB SEA80FA005Accident · 3 fatalClosedCessna T310R · Salem, ORNov 12, 1979 · N1316G · DestroyedNTSB SEA79FYK32Accident · No injuriesClosedBeech P35 · Sunriver, ORSep 21, 1979 · N1752G · Substantial damageNTSB SEA79DYK30Accident · No injuriesClosedCessna 150 · Eugene, ORSep 8, 1979 · N7091F · Substantial damageNTSB SEA79DYM13Accident · No injuriesClosedPiper PA-22 · Dufur, ORJan 28, 1979 · N8276C · Substantial damageNTSB SEA79FYM11Accident · No injuriesClosedPiper PA-28 · Hillsboro, ORJan 25, 1979 · N15543 · Substantial damageNTSB SEA79FA020Accident · Serious injuriesClosedAero Comdr 680E · Dendelton, ORJan 20, 1979 · N6872S · DestroyedNTSB SEA79FYA04Accident · Serious injuriesClosedCessna 182A · Jamieson, OROct 22, 1978 · N6034B · Substantial damageNTSB SEA79FYM02Accident · No injuriesClosedGrum Amer AA5-A · Hillsboro, OROct 21, 1978 · N9721U · Substantial damageNTSB SEA78FYM53Accident · No injuriesClosedBellanca 7ECA · Hillsboro, ORSep 30, 1978 · N4183Y · Substantial damageNTSB SEA78FYM50Accident · 1 fatalClosedMini Coupe Buffum · Independence, ORAug 30, 1978 · N75MB · Destroyed