Fatal NTSB investigations, 1985, OR
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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
| 1964 | 13 |
|---|---|
| 1965 | 8 |
| 1966 | 15 |
| 1967 | 17 |
| 1968 | 17 |
| 1969 | 16 |
| 1970 | 11 |
| 1971 | 18 |
| 1972 | 18 |
| 1973 | 13 |
| 1974 | 11 |
| 1975 | 15 |
| 1976 | 16 |
| 1977 | 20 |
| 1978 | 23 |
| 1979 | 7 |
| 1980 | 11 |
| 1981 | 16 |
| 1982 | 14 |
| 1983 | 9 |
| 1984 | 13 |
| 1985 | 9 |
| 1986 | 9 |
| 1987 | 6 |
| 1988 | 4 |
| 1989 | 10 |
| 1990 | 12 |
| 1991 | 11 |
| 1992 | 8 |
| 1993 | 7 |
| 1994 | 11 |
| 1995 | 11 |
| 1996 | 8 |
| 1997 | 14 |
| 1998 | 5 |
| 1999 | 12 |
| 2000 | 7 |
| 2001 | 4 |
| 2002 | 6 |
| 2003 | 11 |
| 2004 | 8 |
| 2005 | 12 |
| 2006 | 9 |
| 2007 | 9 |
| 2008 | 6 |
| 2009 | 6 |
| 2010 | 7 |
| 2011 | 7 |
| 2012 | 5 |
| 2013 | 5 |
| 2014 | 2 |
| 2015 | 6 |
| 2016 | 4 |
| 2017 | 4 |
| 2018 | 2 |
| 2019 | 12 |
| 2020 | 7 |
| 2021 | 4 |
| 2022 | 3 |
| 2023 | 3 |
| 2024 | 5 |
| 2025 | 2 |
| 2026 | 6 |
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\") = 1985
AND c.\"eventStateOrRegion\" = 'OR' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
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") = 1985 AND c."eventStateOrRegion" = 'OR' AND c."eventCountry" = 'USA' AND c."highestInjuryLevel" = 'Fatal' 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 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 SEA85FYM03Accident · 2 fatalFinal reportCessna 170B · Manzanita, ORAircraft was observed to enter a low overcast shortly after take off. The aircraft then hit a mountain about 4 miles north of the departure airport.NTSB SEA85LA152Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Burns, ORDuring aerial applications the pilot cleared a rise, got a down draft, struck trees and then stalled striking the ground with little forward motion. An intense explosion and fire followed. The fire origin was in the area of the fiberglass fuel tank. An…NTSB SEA85FA124Accident · 3 fatalField investigationFinal reportCessna 177 · Selma, ORThe acft was on a cap search mission with a plt & 2 observers on board. While searching, the plt was flying relatively low & slow over wooded, mountainous terrain. A witness observed the acft enter a bowl or box canyon type area at or below his eye level. The…NTSB SEA85FA233Accident · 2 fatalField investigationFinal reportCessna 172N · Remote, ORDuring a wx briefing, the non-instrument plt was adzd that VFR flt was not recommended due to low clouds & adverse wx along the route. However, he filed a VFR flt plan & depd arcata, CA at 1240 PDT. At 1339, in the vcnty of wilderville, OR, the plt got a wx…NTSB SEA85FA084Accident · 2 fatalField investigationFinal reportBellanca 17-31A · Yamhill, ORWitnesses observed the acft apch the airstrip with excessive speed. Touchdown on the rwy was beyond the halfway point & the acft bounced back into the air. Power was applied for an apparent go-around. The acft cleared tall trees at the end of the runway, but…NTSB SEA85FA056Accident · 4 fatalField investigationFinal reportGulfstream AC-680F · Central Point, ORThe plt reported a loss of power on both engs during descent to land. Aprx 3 mins prior, twr gave plt option of 'straight-in' to rwy 14 or reg pattern to rwy 32. The plt hesitated & said 'just a minute' & twr offered wind info as '210 at 13.' Plt replied,…NTSB SEA85LA054Accident · 4 fatalLimited investigationFinal reportCessna 182-F · Ashland, ORThe plt was briefed regarding weather and expected flt conditions btw medford and redding. The briefing included a forecast for improving conditions approaching the destination as well as possible icing en route. The acft departed medford carrying aprx 970…NTSB SEA85FA050Accident · 2 fatalField investigationFinal reportCessna 175 · White City, ORThe acft crashed after stalling during a go-around attempt. Witnesses said the acft was on final approach to the unlighted arpt with 40 degrees of flap when the go-around attempt was made. The acft rolled and turned 180 degrees before impacting the ground…