NTSB investigations, OR
1,009 cases where the phase of flight was Landing.
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 = 550)
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 = 550)
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 SEA94LA216Accident · No injuriesLimited investigationFinal reportCessna 170B · Redmond, ORProper touchdown point was not attained. A factor to the accident was inadequate remedial action.NTSB SEA94LA213Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Nehalem, ORThe separation of the landing gear transmission assembly from its attach bracket rivets due to undetermined reasons. It was not possible for the landing gear to be locked down during the landing roll due to this separation.NTSB SEA94LA153Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Hillsboro, ORThe improper servicing of the skid shock struts.NTSB SEA94LA148Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26D · North Plains, ORProper touch down point was not obtained. Factors to the accident were: canopy not secured, and inadequate preflight planning/preparation.NTSB SEA94LA115Accident · No injuriesLimited investigationFinal reportCessna 172P · Hillsboro, ORPoor in-flight planning. Factors to the accident were: inadequate remedial action and uncontrolled porpoise.NTSB SEA94LA080Accident · No injuriesLimited investigationFinal reportUnrein 80-P51D · Scapp00se, ORThe inadvertent unlocking of the tailwheel lock. Factors include the manufacturer's inadequate tailwheel lock.NTSB SEA94LA050Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Burns, ORThe student pilot in command's application of excessive braking during the landing roll.NTSB SEA94LA012Accident · No injuriesLimited investigationFinal reportCessna T-337E · Yamhill, ORThe pilot failed to attain the proper touchdown point. The tailwind was a factor.NTSB SEA94LA009Accident · No injuriesLimited investigationFinal reportCessna 150E · Sandy, ORFailure of the pilot to maintain proper runway alignment during the landing. The lack of adequate runway alignment marking was a related factor.NTSB SEA94LA008Accident · No injuriesLimited investigationFinal reportCessna 172RG · Corvallis, ORThe cfi's inadequate in-flight planning, and his inadvertent gear-up landing. Factors include the cfi's diverted attention.NTSB SEA93LA199Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Yamhill, ORThe pilot's failure to maintain a proper glidepath, improper flare, and improper recovery from a forced landing.NTSB SEA93LA062Accident · Minor injuriesLimited investigationFinal reportCessna 185E · North Bend, ORThe pilot's failure to maintain directional control, and inadequate remedial action. Factors include a poor inflight decision, and gusty crosswinds.NTSB SEA93LA061Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Medford, ORMovement of the tailwheel assembly was restricted. Improper maintenance was a factor.NTSB SEA93LA058Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Bend, ORDirectional control not maintained and ground loop/swerve not corrected by the pilot in command.NTSB SEA93LA053Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T(B) · John Day, ORThe pilot's failure to maintain directional control. Factors include a snow covered runway.NTSB SEA93LA030Accident · No injuriesLimited investigationFinal reportHughes 369HS · Scotts Mills, ORThe pilot in command's misjudged descent. Factors include the pilot in command's lack of experience in this type of operation.NTSB SEA93LA013Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Troutdale, ORImproper use of flt controls by the pilot, resulting in inadvertent stall/spin.NTSB SEA92LA208Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Gates, ORThe excessive application of the brakes by the pilot in command. Factors contributing to the accident were the tailwind and the pilots visual (mis)perception of runway gradient.NTSB SEA92LA178Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Pacific City, ORThe pilot selected the wrong runway relative to the wind and then delayed in aborting the landing. The tailwind was a factor.NTSB SEA92LA175Accident · No injuriesLimited investigationFinal reportCessna 172H · Lakeview, ORThe pilot's failure to maintain directional control. Factors include soft terrain.NTSB SEA92LA123Accident · Minor injuriesLimited investigationFinal reportCessna TR182 · Baker, ORThe pilots inadequate recovery from a bounced landing. Factors include unfavorable, gusty winds.NTSB SEA92LA106Accident · No injuriesLimited investigationFinal reportCessna A185F · Spray, ORThe pilot's selection of unsuitable terrain for landing. Factors include soft and uneven terrain.NTSB SEA92LA092Accident · No injuriesLimited investigationFinal reportCessna 150F · Gold Beach, ORFailure of the pilot to maintain airspeed on final approach, resulting in aircraft stall, loss of control and impact with terrain. A factor relating to the accident was the lack of experience by the pilot.NTSB SEA92LA090Accident · No injuriesLimited investigationFinal reportCessna 172N · Parkdale, ORThe pilot's failure to use the proper touchdown point for landing. A factor relating to the accident was the soft dirt runway surface.NTSB SEA92LA088Accident · No injuriesLimited investigationFinal reportHughes 369E · Hillsboro, ORThe pilot in command's excessive application of collective.NTSB SEA92LA084Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Grants Pass, ORA failure to maintain runway alignment, and a delayed go-around. Factors include a crosswind, gusts, and a fence in the go-around path.NTSB SEA91LA257Accident · No injuriesLimited investigationFinal reportCessna 172E · Burns, ORThe pilot's delay in computing aircraft fuel consumption and his failure to land at an alternate airport along the route of flight. Factors relating to the accident were the tree by the landing area and the improper maintenance adjustment of the right magneto.NTSB SEA91LA232Accident · No injuriesLimited investigationFinal reportCessna 140 · Gates, ORThe student pilot's excessive remedial action. Factors to the accident were poor supervision by the CFI.NTSB SEA91LA234Accident · No injuriesLimited investigationFinal reportCessna 182A · Grants Pass, ORPilot's selection of unsuitable terrain for a precautionary landing. Factors related to the accident were: motion sickness of the passenger, wet grass runway, the pilot's self-induced pressure to land at the accident airport, and the ditch.NTSB SEA91LA165Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Medford, ORAn intentional porpoise. Factors include the pilot's psychological condition.NTSB SEA91LA151Accident · No injuriesLimited investigationFinal reportBeech C33A · Brookings, ORThe pilot's improper flare for touchdown, and her improper recovery from a bounced landing.NTSB SEA91LA141Accident · No injuriesLimited investigationFinal reportCessna 172-M · Salem, ORThe pilot's poor in-flight decision and his failure to select a proper touchdown point. Factors include a wet runway, soft terrain and high vegetation.NTSB SEA91LA135Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Corvallis, ORThe student pilot's overconfidence in his personal ability and inadquate remedial action. Contributing to the accident was his decision to attempt a solo autoroation.NTSB SEA91LA101Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Drewsey, ORThe pilot delayed in going-around.NTSB SEA91LA080Accident · No injuriesLimited investigationFinal reportCessna 172A · Hood River, ORAn inadequately planned approach which resulted in a hard landing. Factors to the accident were rough water landing conditions, poor supervision by the CFI, and the overload condition to the float assembly.NTSB SEA91FA057Accident · 3 fatalField investigationFinal reportCessna 182J · Glendale, ORThe pilot's failure to use all available runway for this landing, aggravated by his failure to initiate a go-around after misjudging the proper touchdown point and landing with a tailwind.NTSB SEA90LA198Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Albany, ORThe pilot's decision to land with a strong tailwind resulted in the collapse of the landing gear.NTSB SEA90LA194Accident · Minor injuriesLimited investigationFinal reportRoger A Hansen KR-2M · Shaniko, ORPilot's failure to maintain clearance from a road sign during landing ground roll. A factor in the accident was the failure of the engine exhaust system which resulted in high engine oil temperature.NTSB SEA90LA184Accident · No injuriesLimited investigationFinal reportCessna 180 · Enterprise, ORThe pilot's failure to maintain directional control of the aircraft during landing.NTSB SEA90LA185Accident · No injuriesLimited investigationFinal reportCessna 180A · Paisley, ORPilot's selection of unsuitable terrain for a landing site.NTSB SEA90FA183Accident · 1 fatalField investigationFinal reportCessna 172-P · Hood River, ORThe pilot in command's encountering spatial disorientation and his failure to maintain airspeed.NTSB SEA90LA143Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Redmond, ORThe student pilot's failure to properly recover from a bounced landing.NTSB SEA90LA151Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Klamath Falls, ORPilot's failure to maintain directional control during the landing roll, resulting in a ground loop. The pilot's lack of experience in this make/model was a related factor.NTSB SEA90LA134Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Yamhill, ORThe pilot's failure to retract the flaps during go-around.NTSB SEA90LA141Accident · No injuriesLimited investigationFinal reportCessna TU206G · Sheridan, ORInadvertent engagement of the autopilot during the flare for landing.NTSB SEA90LA109Accident · No injuriesLimited investigationFinal reportMaule M-5 · Riverside, ORThe pilot's selection of unsuitable terrain for a landing site and his inadequate compensation for the wind condition. Factors related to the accident were: the tailwind and the ditch.NTSB SEA90LA096Accident · No injuriesLimited investigationFinal reportCessna 310B · Albany, ORThe pilot's failure to extend the landing gear before landing, when he became distracted by a change in his normal routine.NTSB SEA90LA073Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Newberg, ORThe pilot did not maintain directional control duing the landing.NTSB SEA90LA063Accident · Serious injuriesLimited investigationFinal reportCessna 152II · Scio, ORAn inadequate recovery from a bounced landing and inadequate clearance to avoid colliding with trees.NTSB SEA90LA059Accident · No injuriesLimited investigationFinal reportStearman 4E · Burns, ORThe pilot's failure to maintain directional control.