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, newest first
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'
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' 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 SEA85LA060Accident · Minor injuriesLimited investigationFinal reportBell 214B1 · Lowell, ORThe acft collided with hilly terrain during an emergency autorotation landing attempt following a reported eng overspeed. The crew reported there was an indication of eng overspeed which they could not control. Post acc examinationrevealed no evidence of…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 SEA85LA052Incident · No injuriesLimited investigationFinal reportCessna 337B · Ontario, ORPilots sister approched the rt side of the acft to speak to him. When leaving the side of the acft she walked into the front turning prop. Plt stated she had been around the acft numerous times and was aware of the engine configuration.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…NTSB SEA85LA042Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Troutdale, ORShortly after takeoff plt felt a 'tick' in the engine. Plt reduced pwr and headed back to Troutdale. Engine quit over the threshold of rwy 07 as plt was making a 360 deg turn. Acft touched down short of rwy 07 contacting small bushes and trees. Inspection…