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.
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
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…NTSB 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.…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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.NTSB 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…NTSB 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…NTSB 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.…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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.NTSB 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…NTSB SEA82DYK04Accident · No injuriesClosedCessna 185F · Burns, ORNTSB SEA82FYM04Accident · Serious injuriesClosedPiper PA-22 · Hillsboro, ORNTSB SEA82DYK02Accident · No injuriesClosedPiper PA-24 · Gold Beach, ORNTSB SEA81FYM45Accident · No injuriesClosedCessna 421B · Mulino, ORNTSB SEA81DYM40Accident · No injuriesClosedCessna 182Q · Enterprise, ORNTSB SEA81FYK17Accident · Serious injuriesClosedPiper PA-12 · Bend, ORNTSB SEA81FYK08Accident · Minor injuriesClosedPiper PA-22 · Medford, ORNTSB SEA81FYK04Accident · Serious injuriesClosedCessna P210 · Medford, ORNTSB SEA81DYM10Accident · Serious injuriesClosedStinson L-5 · Philomath, ORNTSB SEA81DYM02Accident · No injuriesClosedPiper PA-28 · Molalla, ORNTSB SEA80FYM54Accident · Serious injuriesClosedPiper PA-28 · Portland, ORNTSB SEA80DYM51Accident · No injuriesClosedCessna 150L · Tigard, ORNTSB SEA80FYK10Accident · Serious injuriesClosedPrue Super STD · Brothers, ORNTSB SEA80DYM37Accident · No injuriesClosedPiper PA-28 · Yamhill, ORNTSB SEA80DYM36Accident · No injuriesClosedCessna 150M · Yamhill, ORNTSB SEA80DYM31Accident · Minor injuriesClosedNaval Fcty N3N-3 · Pendleton, ORNTSB SEA80FYM16Accident · Minor injuriesClosedPiper PA-24 · Newport, ORNTSB SEA80FA005Accident · 3 fatalClosedCessna T310R · Salem, ORNTSB SEA79FYK32Accident · No injuriesClosedBeech P35 · Sunriver, ORNTSB SEA79DYK30Accident · No injuriesClosedCessna 150 · Eugene, ORNTSB SEA79DYM13Accident · No injuriesClosedPiper PA-22 · Dufur, ORNTSB SEA79FYM11Accident · No injuriesClosedPiper PA-28 · Hillsboro, ORNTSB SEA79FA020Accident · Serious injuriesClosedAero Comdr 680E · Dendelton, ORNTSB SEA79FYA04Accident · Serious injuriesClosedCessna 182A · Jamieson, ORNTSB SEA79FYM02Accident · No injuriesClosedGrum Amer AA5-A · Hillsboro, ORNTSB SEA78FYM53Accident · No injuriesClosedBellanca 7ECA · Hillsboro, ORNTSB SEA78FYM50Accident · 1 fatalClosedMini Coupe Buffum · Independence, OR