NTSB investigations, OR
130 cases where the first occurrence was “In flight collision with object”.
Cases per year
| 1982 | 12 |
|---|---|
| 1983 | 6 |
| 1984 | 4 |
| 1985 | 4 |
| 1986 | 6 |
| 1987 | 3 |
| 1988 | 5 |
| 1989 | 5 |
| 1990 | 3 |
| 1991 | 5 |
| 1992 | 8 |
| 1993 | 5 |
| 1994 | 6 |
| 1995 | 6 |
| 1996 | 8 |
| 1997 | 9 |
| 1998 | 2 |
| 1999 | 4 |
| 2000 | 7 |
| 2001 | 5 |
| 2002 | 2 |
| 2003 | 6 |
| 2004 | 3 |
| 2005 | 3 |
| 2006 | 1 |
| 2007 | 2 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220)
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.
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run 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 SEA08FA005Accident · 1 fatalField investigationFinal reportPiper PA-18 · Crowley Ranch, ORThe pilot's failure to maintain adequate clearance from a power transmission line while maneuvering. Contributing to this accident was the pilot's diverted attention, and decision to maneuver at a low altitude.NTSB LAX07CA242Accident · No injuriesData collectionFinal reportCessna 172B · Sisters, ORThe pilot's failure to maintain adequate clearance from trees.NTSB SEA06FA119Accident · 4 fatalField investigationFinal reportCessna 180 · Agness, ORThe pilot's failure to maintain obstacle clearance while maneuvering at low altitude, which resulted in an in-flight collision with a tree and subsequent collision with rocky terrain. A contributing factor was the sun glare.NTSB SEA06LA012Accident · No injuriesLimited investigationFinal reportCessna 172 · Gleneden Beach, ORThe pilot's failure to maintain clearance from objects while maneuvering over the airport environment. Dark night conditions, trees, and ground fog were factors.NTSB SEA05CA060Accident · No injuriesData collectionFinal reportBirtch Kitfox II · Dillard, ORThe pilot's failure to maintain clearance from obstacles while in cruise flight at low altitude, which resulted in an inflight collision with a power line. A factor was the pilot's decision to fly at low altitude.NTSB SEA05CA055Accident · Minor injuriesData collectionFinal reportCessna 172H · Waldport, ORThe pilot's failure to attain sufficient altitude/clearance during the takeoff initial climb, which resulted in an inflight collision with trees. A factor was the tall grass on the turf runway, which slowed the airplane's acceleration during the takeoff roll.NTSB SEA05FA007Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Grand Ronde, ORThe pilot's failure to maintain clearance from high terrain while maneuvering. A factor contributing to the accident was the high terrain.NTSB SEA04LA114Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Medford, ORThe pilot's failure to maintain clearance from a tree while maneuvering. Trees were a factor.NTSB SEA04LA082Accident · 1 fatalLimited investigationFinal reportKaman K-1200 · West Fork, ORThe pilot's failure to maintain adequate clearance with trees during logging operations. Contributing factors were the trees, mountainous (steeply sloped) terrain, and the pilot's decision to conduct operations in this terrain with a 200 foot long line.NTSB SEA04LA027Accident · 2 fatalLimited investigationFinal reportErickson SHA Glasair TD · Vansycle, ORThe pilot's failure to maintain adequate clearance with the anemometer pole/wires during low altitude flight. Contributing factors were the pole and the pilot's low altitude flight.NTSB SEA04LA013Accident · No injuriesLimited investigationFinal reportCessna 172M · Bandon, ORThe pilot's failure to maintain clearance from objects while on final approach. Dark night conditions, trees and a low glidepath were factors.NTSB SEA04FA009Accident · 1 fatalField investigationFinal reportBeech A36 · Seaside, ORThe pilot's failure to maintain clearance from objects while maneuvering. High winds, gusts and rain were factors.NTSB SEA04LA005Accident · 2 fatalLimited investigationFinal reportBell 206B · Swisshome, ORThe pilot's failure to maintain clearance from power lines while maneuvering. The power line, mountainous terrain with high obstructions (thick trees and underbrush) and the operators failure to maintain a "hazard map" as indicated in their procedures manual…NTSB SEA03CA178Accident · No injuriesData collectionFinal reportBeech C24R · Bend, ORThe first pilot's premature liftoff and his failure to abort the takeoff. Factors include a fence and a ditch bank located upwind of the runway.NTSB SEA03FA024Accident · Serious injuriesField investigationFinal reportBombardier DHC-8-401 · Medford, ORThe fracture and spalling of the inner-most pane of the aircraft's port side windshield while on a downwind for a night visual approach due to an imposed load beyond that required for windshield certification (multiple bird strikes). Factors include a dark…NTSB SEA02FA125Accident · 2 fatalField investigationFinal reportCessna 172N · Otis, ORThe pilot's failure to maintain adequate clearance with power lines while conducting low altitude flight resulting in a loss of control and subsequent collision with terrain. Contributing factors were the pilot's low altitude flight and the power lines.NTSB SEA02FA085Accident · 2 fatalField investigationFinal reportRobinson R-22 Mariner · Merlin, ORClearance from a cable running perpendicular to a river was not maintained during low level cruise flight. A cable was a factor.NTSB SEA02FA005Accident · 2 fatalField investigationFinal reportPiper PA-18 · Sandy, ORThe pilot's failure to maintain clearance from the trees while attempting to land in a field after entering an area of instrument meteorological conditions. Factors include low ceilings, rain, fog, strong winds, mountainous/hilly terrain, the pilot's…NTSB SEA01LA170Accident · 1 fatalLimited investigationFinal reportCessna 182J · Gold Beach, ORThe pilot's failure to attain proper alignment while on final approach and clearance from trees. The pilot's lack of total experience in this type of mountain flying operation was a factor.NTSB SEA01LA164Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Winston, ORThe pilot's failure to maintain clearance from a fence during the initial takeoff. A fence was a factor.NTSB SEA01LA138Accident · Serious injuriesLimited investigationFinal reportCessna 120 · Troutdale, ORthe pilot's inadvertent visual flight rules ( VFR) flight into instrument meteorological conditions (IMC) during cruise flight. Factors include his attention being diverted to the indications presented by his Global Positioning System (GPS), and low ceiling…NTSB SEA01LA101Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Sunriver, ORThe pilot's failure to maintain clearance from trees during initial climb. Trees were a factor.NTSB SEA01FA015Accident · 2 fatalField investigationFinal reportCessna 152 · Corvallis, ORThe pilot's failure to maintain clearance from the terrain. Factors include a dark night, densely forested, hilly terrain near the planned route of flight, and low ceilings in the area of the accident.NTSB SEA00LA187Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Newberg, ORThe pilot's failure to maintain a proper glide path on final approach. Factors include a vehicle on the roadway and a downdraft.NTSB SEA00LA181Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Brookings, ORThe pilot's loss of control during the landing attempt. Trees, a crosswind condition, the pilot's inadequate compensation for the wind conditions, and a delayed remedial action were factors.NTSB SEA00LA162Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Birkenfeld, ORThe pilot's delayed go-around, which resulted in the aircraft not clearing the fence posts. A contributing factor was the fence posts.NTSB SEA00LA085Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-35 · Seaside, ORThe pilot's improper decision to continue to a point where he could not be assured of reaching a safe landing-out site if he encountered an area of significant sink after departing his planned route of flight. Factors include downdrafts, terrain that…NTSB SEA00LA072Accident · No injuriesLimited investigationFinal reportCessna A185F · Wallowa, ORThe pilot's failure to maintain proper runway alignment upon encountering a wind gust, and his subsequent failure or inability to maintain clearance with a tree during a go-around attempt. Factors included a short and narrow airstrip, gusty wind conditions,…NTSB SEA00LA051Accident · 1 fatalLimited investigationFinal reportWeatherly 620B · Odell, ORThe pilot's failure to maintain sufficient altitude over, or clearance with, a tree. Factors contributing to the occurrence of the accident were the tree and sharply rising terrain. A factor contributing to the severity of the accident was a post-crash fuel…NTSB SEA00LA028Accident · Minor injuriesLimited investigationFinal reportHughes 369E · Salem, ORFailure of the pilot to maintain ground clearance, resulting in the long-line snagging and then striking the tail rotor.NTSB SEA99FA152Accident · 3 fatalField investigationFinal reportCessna T210M · Marcola, ORThe pilot's failure to maintain clearance from the terrain while descending in an area of deteriorating weather. Factors include mountainous terrain, clouds, low ceilings, the pilot's inadequate preflight weather analysis, and his improper decision to attempt…NTSB SEA99TA051Accident · Minor injuriesFinal reportI.C.A. Brasov IS-28B2 · North Plains, ORThe second pilot did not maintain clearance from power lines. The pilot-in-command did not adequately supervise the second pilot, and the second pilot's diverted attention and lack of familiarity with the geographic area were factors.NTSB SEA99FA027Accident · 4 fatalField investigationFinal reportBeech 58P · Yamhill, ORThe pilot's failure to maintain clearance from hilly terrain while maneuvering below a low ceiling. Factors include a dark night, a low ceiling, fog, and hilly terrain.NTSB SEA98LA182Accident · 1 fatalLimited investigationFinal reportCora Allegro · Cresent Lake, ORThe pilot's failure to maintain clearance from trees located off the departure end of the runway. Factors include strong, variable, gusty winds, terrain-induced turbulence, a high density altitude, and trees off the departure end of the runway.NTSB SEA98LA154Accident · 1 fatalLimited investigationFinal reportCessna 172 · Baker City, ORThe pilot's failure to maintain terrain clearance and inadequate in-flight planning/decision. Contributing to the accident was mountain obscuration.NTSB SEA98LA013Accident · No injuriesLimited investigationFinal reportBell 206B · Forest Grove, ORExcessive deceleration of the helicopter by the pilot-in-command, resulting in an in-flight main rotor blade strike on the helicopter's external load line and subsequent main rotor separation. Downhill terrain which led to a descending approach to the pickup…NTSB SEA97LA212Accident · 2 fatalLimited investigationFinal reportBellanca 7KCAB · Oakridge, ORThe first pilot's decision to perform a low altitude maneuver, and his subsequent failure to maintain altitude and clearance from trees during a low altitude maneuver.NTSB SEA97FA181Accident · 1 fatalField investigationFinal reportAvian Magnum IX · Donald, ORThe pilot's failure to maintain clearance from a tree that was located on the edge of the field in which he was attempting to land.NTSB SEA97LA161Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Bend, ORthe pilot's failure to attain a proper climb rate. High density altitude and the pilot's failure to use all of the available runway were factors.NTSB SEA97LA155Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Prineville, ORThe pilot's selection of an unsuitable landing area, his improper decision to attempt an aborted takeoff on a short airstrip surround by rising terrain and trees, and his failure to maintain clearance from the trees during the aborted takeoff attempt. Factors…NTSB SEA97LA138Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Waldport, ORthe pilot's inadequate preflight planning/preparation to ensure he could execute a safe departure in the meteorological conditions present at the time. Related factors included: the unfavorable/variable/gusty wind conditions; and a power line near the…NTSB SEA97LA072Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Glide, ORfailure of the pilot to maintain clearance from a power transmission line. Factors relating to the accident included ambient light conditions, which made the power line hard to see.NTSB SEA97LA059Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Madras, ORThe pilot's inadvertent visual flight rules (VFR) flight into instrument meteorological conditions (IMC). Factors include the pilot's improper decision to fly under a low ceiling while in mountainous/hilly terrain, and his encounter with fog and low clouds…NTSB SEA97LA047Accident · No injuriesLimited investigationFinal reportBarriger RV-6 · The Dalles, ORThe pilot's failure to maintain clearance from a powerline during an intentional low altitude maneuver.NTSB SEA96LA211Accident · No injuriesLimited investigationFinal reportCessna 172M · Pacific City, ORthe pilot's failure to see-and-avoid the transmission line. Factors relating to the accident were: the pilot's low altitude flight, and the transmission line.NTSB SEA96LA180Accident · No injuriesLimited investigationFinal reportGrumman American AA-5A · Klamath Falls, ORthe pilot's inadequate compensation for wind conditions, and his failure to maintain proper alignment with the runway during the landing/go-around. Factors relating to the accident were: strong, gusty crosswinds, and the encounter with a runway…NTSB SEA96LA167Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Cornelius, ORthe pilot's inadequate preflight planning, and his failure to see-and-avoid the obstruction (inadequate visual lookout). The transmission wire was a related factor.NTSB SEA96LA122Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B · Wilsonville, ORfailure of the pilot to maintain clearance from the static wire, which became shorted to a transmission wire and subsequently caused a fire to erupt on the balloon's envelope. Factors relating to the accident were: the obstructions (power line wires), and the…NTSB SEA96LA116Accident · No injuriesLimited investigationFinal reportCessna 172L · Sisters, ORthe pilot's inadequate compensation for wind conditions during a go-around, which resulted in his failure to maintain proper runway alignment. Factors relating to the accident were: the variable/gusty crosswind condition, and the proximity of the hanger and…NTSB SEA96LA111Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Coquille, ORthe pilot's inadequate evaluation of wind conditions, and his subsequent failure to initiate a go-around in a timely manner, which resulted in his inability to maintain clearance with trees during the go-around. Factors relating to the accident included a…