NTSB investigations, 2003, OR
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases per year
| 1962 | 1 |
|---|---|
| 1964 | 74 |
| 1965 | 88 |
| 1966 | 121 |
| 1967 | 121 |
| 1968 | 84 |
| 1969 | 80 |
| 1970 | 68 |
| 1971 | 77 |
| 1972 | 75 |
| 1973 | 84 |
| 1974 | 71 |
| 1975 | 77 |
| 1976 | 81 |
| 1977 | 95 |
| 1978 | 88 |
| 1979 | 90 |
| 1980 | 76 |
| 1981 | 75 |
| 1982 | 82 |
| 1983 | 65 |
| 1984 | 70 |
| 1985 | 56 |
| 1986 | 51 |
| 1987 | 40 |
| 1988 | 41 |
| 1989 | 45 |
| 1990 | 49 |
| 1991 | 51 |
| 1992 | 48 |
| 1993 | 39 |
| 1994 | 46 |
| 1995 | 56 |
| 1996 | 60 |
| 1997 | 56 |
| 1998 | 40 |
| 1999 | 43 |
| 2000 | 56 |
| 2001 | 47 |
| 2002 | 39 |
| 2003 | 48 |
| 2004 | 40 |
| 2005 | 54 |
| 2006 | 38 |
| 2007 | 47 |
| 2008 | 40 |
| 2009 | 31 |
| 2010 | 40 |
| 2011 | 31 |
| 2012 | 35 |
| 2013 | 31 |
| 2014 | 18 |
| 2015 | 29 |
| 2016 | 23 |
| 2017 | 27 |
| 2018 | 31 |
| 2019 | 42 |
| 2020 | 23 |
| 2021 | 36 |
| 2022 | 24 |
| 2023 | 23 |
| 2024 | 30 |
| 2025 | 20 |
| 2026 | 23 |
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 year(c.\"eventDate\") = 2003
AND c.\"eventStateOrRegion\" = 'OR' AND c.\"eventCountry\" = 'USA'
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 year(c."eventDate") = 2003 AND c."eventStateOrRegion" = 'OR' AND c."eventCountry" = 'USA' 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 SEA04CA037Accident · No injuriesData collectionFinal reportBellanca 8KCAB · Bend, ORDirectional control not maintained during landing. Factors include an icy runway and a snow bank.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 SEA04LA026Accident · 1 fatalLimited investigationFinal reportUpright RV-7A · McMinnville, ORThe pilot's failure to maintain aircraft control. Cloudy weather, continued flight into adverse weather, inadequate preflight planning and mountainous terrain were factors.NTSB SEA04LA024Accident · 1 fatalLimited investigationFinal reportShear Titan Tornado · Brooks, ORThe failure of the pilot to maintain aircraft control while maneuvering due to a hypoglycemic condition.NTSB SEA04FA022Accident · 4 fatalField investigationFinal reportBeech S35 · Warren, ORThe vacuum pump failure and the pilot's failure to maintain control of the airplane. Factors contributing to the accident included the instrument meteorological weather conditions and the pilot's improper recovery from the descent.NTSB SEA04LA018Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-2 · Monmouth, ORFatigue failure of a tail rotor blade during hover operations.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 SEA04LA012Accident · No injuriesLimited investigationFinal reportGarnett-Robert Barnett J4B · Prineville, ORThe pilot's failure to maintain airspeed which resulted in an inadvertent stall during the initial takeoff climb. A factor was the lack of pilot certification.NTSB SEA04LA011Accident · No injuriesLimited investigationFinal reportHughes 269C · Hillsboro, ORThe pilot's selection of unsuitable terrain for a practice auto rotation landing. A contributing factor was the soft terrain.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 SEA04LA014Accident · Serious injuriesLimited investigationFinal reportTracy Kolb Mark III · Prineville, ORThe pilot in command's failure to maintain aircraft control during an aborted takeoff. Factors include the pilot's lack of experience in this type of aircraft (pusher).NTSB SEA04FA006Accident · 2 fatalField investigationFinal reportCessna 340A · Scappoose, ORThe pilot's failure to maintain airspeed while maneuvering. An inadvertent stall, the pilot's failure to follow engine operation procedures and engine detonation 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 SEA03LA193Accident · No injuriesLimited investigationFinal reportCessna A150K · Medford, ORThe student pilot's failure to maintain directional control of the aircraft during the landing roll.NTSB SEA03LA189Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Diamond, ORLoss of engine power for undetermined reasons during hover.NTSB SEA03LA182Accident · Minor injuriesLimited investigationFinal reportPitts S-2A · Hillsboro, ORThe pilot's failure to maintain the proper distance and altitude while on final approach which led to touching down short of the runway. The pilot's restricted visual lookout was a factor.NTSB SEA03LA180Accident · No injuriesLimited investigationFinal reportLancair LC41 · Bend, ORThe inadequate design of the drogue chute mechanical jettison system, which resulted in its failure to separate from the aircraft during in-flight spin recovery tests, and the incorrectly wired drogue chute cable cutter activation unit, which resulted in the…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 SEA03LA176Accident · Minor injuriesLimited investigationFinal reportMooney M20D · Hood River, ORA power loss due to a mis-seated intake valve on the #1 cylinder resulting in leakage during the compression stroke and low compression. Contributing factors were the rising terrain and trees.NTSB SEA03LA160Accident · Minor injuriesLimited investigationFinal reportHughes 269C-1 · Scappoose, ORThe helicopter encountering a ground resonance condition following a failure to maintain hovering flight. Contributing factors to the accident included the pilot's failure to maintain rotor RPM and the high pressure state of the landing gear shock absorbing…NTSB SEA03LA157Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-24E · Hood River, ORThe pilot's failure to refuel prior to the flight, resulting in fuel exhaustion during the initial climb, followed by the pilot's failure to maintain airspeed. An inadvertent stall was a factor.NTSB SEA03LA152Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Hermiston, ORThe pilot's inadequate in-flight decision by failing to refuel, resulting in fuel exhaustion and the loss of power. Rocky terrain was a factor.NTSB SEA03LA145Accident · No injuriesLimited investigationFinal reportAndelin S1E · Troutdale, ORThe pilot's inability to maintain directional control due to an obstruction of the left brake line by foreign material resulting in asymmetrical braking.NTSB SEA03CA138Accident · No injuriesData collectionFinal reportBeech F90 · Sunriver, ORThe pilot's misjudgment of distance while landing, which resulted in a runway overrun. Factors include rough uneven terrain and a tailwind.NTSB SEA03LA133Accident · No injuriesLimited investigationFinal reportCessna 402 B · Lakeview, ORFailure of the landing gear shaft roll pin resulting in a main gear collapse during the taxi phase of operation.NTSB SEA03LA126Accident · No injuriesLimited investigationFinal reportDruckman 102 · Alsea, ORThe pilot's failure to maintain directional control during the take-off roll, when his foot became lodged between the rudder pedal and the heel brake. An additional factor is a fence near the area where he was taking off from.NTSB SEA03LA125Accident · No injuriesLimited investigationFinal reportSikorsky UH-19D · La Grande, ORThe cross threading and separation of the clutch assembly while maneuvering which resulted in a loss of engine power followed by a hard landing. An inadequate maintenance overhaul was a factor.NTSB SEA03LA122Accident · No injuriesLimited investigationFinal reportCessna 185F · Lexington, ORThe pilot's failure to maintain aircraft control during the landing roll. A partially deflated tire and soft terrain were factors.NTSB SEA03LA118Accident · 1 fatalLimited investigationFinal reportHerrin Hornet · Newberg, ORAircraft control not maintained while maneuvering for landing.NTSB SEA03LA115Accident · No injuriesLimited investigationFinal reportCessna 182C · Bandon, ORLoss of engine power during descent for undetermined reasons.NTSB SEA03FA110Accident · 1 fatalField investigationFinal reportHarshbarger W/Reed RV-8 · Grants Pass, ORCorrosion and contamination within the fuel servo unit and the pilot's delayed turn back to the runway. Contributing factors were trees and the pilot's impairment due to prescription medication.NTSB SEA03LA090Accident · No injuriesLimited investigationFinal reportBeech 95 C-55 · Canby, ORThe pilot's inadequate preflight planning resulting in fuel starvation and subsequent loss of power after takeoff. High vegetation was a factor.NTSB SEA03LA088Accident · No injuriesLimited investigationFinal reportAeronca 7EC · Oregon City, ORThe student pilot's failure to maintain aircraft control during the landing roll. A tailwind and gusting conditions were factors.NTSB SEA03LA082Accident · Minor injuriesLimited investigationFinal reportCessna 182J · Salem, ORLoss of power in cruise flight due to a catastrophic engine failure for undetermined reasons.NTSB SEA03LA069Accident · Minor injuriesLimited investigationFinal reportCessna 175B · Bonanza, ORSeparation of the connecting rod cap. Annual maintenance inspections which were disregarded by the owner/pilot was a factor.NTSB SEA03LA064Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Coos Bay, ORThe pilot's improper remedial action during takeoff and his failure to maintain airspeed. Contributing factors included the binding of the left brake and the trees.NTSB SEA03LA063Accident · No injuriesLimited investigationFinal reportHerb Six Northstar · Medford, ORThe compressive buckling and collapse of the right main landing gear.NTSB SEA03LA062Accident · No injuriesLimited investigationFinal reportCurtiss-Wright Travel Air C-4000 · Florence, ORPilot's failure to maintain directional control during the landing roll. Factors include rough terrain.NTSB SEA03FA059Accident · 2 fatalField investigationFinal reportCessna T207 A · Merlin, ORThe pilot's failure to maintain clearance from mountainous terrain while in cruise flight. Factors include low ceilings and mountainous terrain.NTSB SEA03LA055Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Lexington, ORThe pilot's inadequate compensation for the cosswind conditions during the landing roll which resulted in a loss of control. A contributing factor was the crosswind condition.NTSB SEA03LA053Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Troutdale, ORAircraft control was not maintained during the landing roll. An improper flare which resulted in a bounced landing was a factor.NTSB SEA03LA043Accident · No injuriesLimited investigationFinal reportCessna 208B · Creswell, ORWater contamination in the fuel system which resulted in a loss of engine power during the initial climb after takeoff, and the pilot's inadequate pre-flight inspection. Trees were a factor.NTSB SEA03LA044Accident · No injuriesLimited investigationFinal reportCessna 180 A · Malin, ORAircraft control not maintained during landing. Soft terrain was a factor.NTSB SEA03LA039Accident · No injuriesLimited investigationFinal reportKesterson Nieuport 11 · Independence, ORAircraft control not maintained during takeoff. Factors include soft/muddy terrain.NTSB SEA03LA036Accident · No injuriesLimited investigationFinal reportCessna 172N · McMinnville, ORThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control during the landing roll. Factors include gusty crosswinds and soft terrain in the area where the aircraft departed the side of the runway.NTSB SEA03FA038Accident · No injuriesField investigationFinal reportBeech A23 · Fort Klamath, ORThe separation of the rod end cap from the connecting rod for an undetermined reason during the descent for landing. The ditch was a factor.NTSB SEA03LA032Accident · No injuriesLimited investigationFinal reportCessna 180 B · Klamath Falls, ORFailure to adequately compensate for wind conditions while landing.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…