Fatal NTSB investigations, OR
38 cases where the first occurrence was “In flight collision with terrain/water”.
Cases per year
| 1983 | 3 |
|---|---|
| 1984 | 2 |
| 1985 | 1 |
| 1986 | 1 |
| 1989 | 1 |
| 1991 | 4 |
| 1992 | 2 |
| 1993 | 2 |
| 1994 | 2 |
| 1995 | 3 |
| 1996 | 1 |
| 1997 | 1 |
| 1999 | 6 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2005 | 3 |
| 2006 | 1 |
| 2007 | 2 |
Where
Latest 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.\"highestInjuryLevel\" = 'Fatal'
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\" = 230)
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."highestInjuryLevel" = 'Fatal' 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" = 230) 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 SEA07FA246Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Alsea, ORTerrain clearance was not maintained while maneuvering. A low altitude during the maneuver and hilly terrain were factors.NTSB LAX07LA113Accident · 2 fatalLimited investigationFinal reportPiper PA-28-151 · Lincoln City, ORIn-flight collision with water for undetermined reasons.NTSB SEA07LA025Accident · 2 fatalLimited investigationFinal reportHolloway RV6A · North Bend, ORThe pilot's failure to maintain clearance from the water while performing low altitude maneuvering flight resulting in an in flight collision with the water.NTSB SEA05LA128Accident · 1 fatalLimited investigationFinal reportEllsberg One Design · Madras, ORThe pilot's failure to maintain altitude/clearance from terrain while performing aerobatics which resulted in a collision with the ground.NTSB SEA05LA052Accident · 2 fatalLimited investigationFinal reportAvery Glasair · Brookings, ORIn flight collision with water while maneuvering for undetermined reasons.NTSB SEA05FA038Accident · 3 fatalField investigationFinal reportCirrus SR22 · Hood River, ORThe pilot's failure to maintain terrain clearance. Contributing factors were the mountainous terrain, the low ceiling weather conditions, and dark night light conditions.NTSB SEA02FA185Accident · 2 fatalField investigationFinal reportCessna 172S · Medford, ORTerrain clearance was not maintained during cruise flight. Dark night and mountainous terrain were factors.NTSB SEA01FA167Accident · 3 fatalField investigationFinal reportBeech 58 · Ashland, ORThe pilot's failure to maintain clearance from the terrain after inadvertently entering an area of instrument meteorological conditions (IMC) during a visual flight rules (VFR) flight. Factors include mountainous/hilly terrain and low ceilings in the area…NTSB SEA00FA127Accident · 1 fatalField investigationFinal reportCessna 175 · Molalla, ORFailure to maintain clearance from mountainous/hilly terrain.NTSB SEA00FA033Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Hermiston, ORThe pilot's failure to maintain clearance with terrain. Factors include a dark night, low ceilings and mist.NTSB SEA00FA030Accident · 1 fatalField investigationFinal reportCessna 140A · Harper, ORThe pilot-in-command's failure to maintain terrain clearance. Factors include meteorological conditions obscuring the pilot's visibility and incapacitation due to illegal substances.NTSB SEA00LA017Accident · 1 fatalLimited investigationFinal reportCessna A185F · Astoria, ORThe pilot's failure to maintain airspeed after a delayed go-around. Factors include incapacitation due to the use of unapproved drugs.NTSB SEA99FA168Accident · 1 fatalField investigationFinal reportSchweizer 269C · Westport, ORThe pilot's failure to maintain clearance from terrain. Factors include low clouds and visibility and near-night light conditions.NTSB SEA99FA041Accident · 2 fatalField investigationFinal reportCessna 421B · North Bend, ORA delayed aborted takeoff for an undetermined reason.NTSB SEA99FA028Accident · 2 fatalField investigationFinal reportPacific Aviation Composites LC 40-550FG · Portland, ORAircraft control was not maintained and the pilot's lack of total experience in type operation. Weather conditions reported ceilings below approach/landing minimums and a dark night condition were factors.NTSB SEA98LA007Accident · 2 fatalLimited investigationFinal reportCessna 185A · Damascus, ORfailure of the pilot to maintain sufficient altitude/clearance from terrain. Factors relating to the accident included: darkness, and hilly/mountainous terrain.NTSB SEA97FA027Accident · 1 fatalField investigationFinal reportCessna P210N · Boring, ORThe pilot's attempt to conduct visual flight into instrument meteorological conditions. A factor contributing to the accident was the presence of thick fog.NTSB SEA95LA224Accident · 1 fatalLimited investigationFinal reportMacphee Vans RV-6 · Jacksonville, ORthe pilot-in-command's failure to maintain altitude and/or clearance from surrounding terrain after a low pass. The mountainous terrain was a factor.NTSB SEA95LA223Accident · 2 fatalLimited investigationFinal reportEurocopter AS350BA · Crater Lake, ORFailure of the pilot to maintain sufficient altitude/clearance above water, while performing low altitude flight. Factors relating to the accident were: the glassy water condition, and lack of visual cues concerning perception of altitude.NTSB SEA95FA064Accident · 1 fatalField investigationFinal reportMcDonnell Douglas 369E · Lakecreek, ORThe pilot's failure to maintain adequate clearance from the surrounding terrain. A factor was the transmission lines.NTSB SEA94FA247Accident · 1 fatalField investigationFinal reportCessna 150J · Roseburg, ORthe pilot's failure to maintain clearance from the terrain.NTSB SEA94FA194Accident · 2 fatalField investigationFinal reportHughes 369HS · Seaside, ORInflight collision with terrain for undetermined reasons.NTSB SEA94LA246Accident · 2 fatalLimited investigationFinal reportFlake Talon XP · Estacada, ORFailure of the pilot to maintain sufficient altitude and/or clearance from mountainous terrain. Factors relating to the accident were: the terrain condition and flight into an area with adverse weather and unfavorable winds.NTSB SEA93FA084Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Estacada, ORFailure of the pilot to maintain proper clearance (and/or altitude) from moutainous terrain. Factors related to the accident were: darkness, clouds, low ceilings, and the high (mountainous) terrain in the area of the accident site.NTSB SEA92FA100Accident · 2 fatalField investigationFinal reportAerospatiale SA-341G · Yamhill, ORThe pilot misjudged a maneuver performed at inadequate altitude.NTSB SEA92LA074Accident · 1 fatalLimited investigationFinal reportMoore Sonerai 1 · Harrisburg, ORThe pilot's failure to maintain an altitude sufficient to avoid colliding with terrain while performing acrobatic maneuvers as a result of his alcoholic impairment of efficiency and judgement. Factors contributing to the accident were: the pilots disregard of…NTSB SEA91FA223Accident · 3 fatalField investigationFinal reportAerospatiale 350 B1 · Walton, ORThe pilot's failure to maintain clearance from terrain.NTSB SEA91FA203Accident · 1 fatalField investigationFinal reportChristen Industries Pitts S-2B · Scappoose, ORThe pilot's misjudgment of altitude, while performing an aerobatic maneuver, and his failure to maintain ground clearance.NTSB SEA91FA095Accident · 1 fatalField investigationFinal reportCessna 150H · Sumpter, ORThe pilot's improper inflight planning and decisions and the pilot's VFR flight into IMC conditions.NTSB SEA91FA262Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Dayville, ORThe pilot's poor in flight decision. Factors include mountainous/hilly terrain.NTSB SEA89FA180Accident · 2 fatalField investigationFinal reportCessna 177RG · Nyssa, ORFailure of the pilot to attain sufficient altitude before flying over mountainous/hilly terrain. Factors related to the accident were: dark night, rising/mountainous terrain, and probable impairment from a prescription drug.NTSB SEA86FA066Accident · 2 fatalField investigationFinal reportPiper PA34-200T · Antelope, ORPlt was operating VFR on top at 11000 feet, commenced descent to destination 34 miles out. Plt rpted field in sight 16 miles out, passing 6500 ft, cancelled flight plan. Acft impacted ridge at 4100 feet MSL 7 miles from destination. Dark night conds existed,…NTSB SEA85LA231Accident · 1 fatalLimited investigationFinal reportMitchell U2 · Prineville, ORPlt was on second flt in newly completed, registered ultralight. Craft had not been issued a certificate of airworthiness. After takeoff, acft was observed to circle airport, then descend out of sight behind trees. Investigation showed steeep, nosedown…NTSB SEA84FA135Accident · 2 fatalField investigationFinal reportGrumman American AA-5 · Hammond, ORThe acft was seen first to make a turn to the north followed by a turn to the south. It then went into a nose down attitude and descended until it disappeared from view. The acft collided with the terrain. An investigation revealed no apparent malfunction…NTSB SEA84FA113Accident · 1 fatalField investigationFinal reportCessna 150F · Gleneden Beach, ORTwo witnesses observed the student plt in the acft at about 1500 PDT. They reported that they were waiting for the wx to clear & that they tried to get the student to spend the night instead of leaving, but they were unsuccessful. Subsequently, the acft…NTSB SEA83FYK04Accident · 1 fatalFinal reportHomebuilt Christen Eagle II · Bend, ORUpon completion of his routine during an airshow, the plt stated to the show announcer that he would do a low pass down the rwy followed by a vertical climb to a hammerhead stall & then into a lomcevak aerobatic maneuver. This maneuver is aclimbing outside…NTSB SEA83FA044Accident · 1 fatalField investigationFinal reportCessna P210N · Burns, ORThe plt was on a bank-check courier flt from troutdale to portland, with en route stops at Burns & redmond, OR. Routinely, the acft would depart troutdale between 0900 & 0930 & arrive at Burns at 1130 to 1200 local time. After a ground time of aprx 8 hrs, it…NTSB SEA83FA037Accident · 1 fatalField investigationFinal reportCessna T210N · Portland, ORThe acft collided with the side of a hill during a descent. The pilot had canceled his IFR clearance and radar services were terminated and a frequency change was approved. Shortly thereafter the acft was observed flying beneath the clouds toward the hill…