Skip to content

NTSB investigations, OR

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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'
  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'
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 SEA69F0064Accident · No injuriesClosedPiper PA-20 · Redmond, ORJun 8, 1968 · N7725K · Substantial damage NTSB SEA69D0050Accident · No injuriesClosedCessna 150 · Springfield, ORMay 31, 1968 · N6716F · Substantial damage NTSB SEA69D0045Accident · No injuriesClosedPiper PA-18 · Carver, ORMay 27, 1968 · N5881D · Substantial damage NTSB SEA69D0058Accident · No injuriesClosedBeech 23 · Eugene, ORMay 23, 1968 · N2329L · Substantial damage NTSB SEA69D0002Accident · No injuriesClosedCessna 182 · Pendleton, ORMay 21, 1968 · N3474R · Substantial damage NTSB SEA69F0022Accident · Minor injuriesClosedPiper PA-18 · Lowell, ORMay 10, 1968 · N9073D · Substantial damage NTSB SEA69D0056Accident · No injuriesClosedBeech A23A · Grants Pass, ORMay 8, 1968 · N2355W · Substantial damage NTSB SEA69F0019Accident · Minor injuriesClosedPiper PA-28 · Paisley, ORApr 30, 1968 · N8925J · Destroyed NTSB SEA69D0020Accident · No injuriesClosedCessna 177 · Canby, ORApr 22, 1968 · N3460T · Substantial damage NTSB SEA68D0311Accident · No injuriesClosedHughes 269B · Tigard, ORApr 20, 1968 · N9477F · Substantial damage NTSB SEA69F0009Accident · Serious injuriesClosedPiper PA-22 · Springfield, ORApr 19, 1968 · N9302D · Substantial damage NTSB SEA68F0331Accident · 1 fatalClosedCessna A188 · The Dalles, ORApr 17, 1968 · N8015V · Destroyed NTSB SEA68F0299Accident · No injuriesClosedPiper PA-22 · Hood River, ORApr 17, 1968 · N610A · Substantial damage NTSB SEA69F0089Accident · Minor injuriesClosedPiper PA-30 · Silver Lake, ORApr 16, 1968 · N7234Y · Destroyed NTSB SEA68D0282Accident · No injuriesClosedPiper PA-24 · Vale, ORApr 14, 1968 · N8852P · Substantial damage NTSB SEA68F0290Accident · No injuriesClosedCessna 172 · Bend, ORApr 7, 1968 · N7831X · Substantial damage NTSB SEA68D0305Accident · No injuriesClosedPiper PA-22 · Spray, ORApr 6, 1968 · N9672D · Substantial damage NTSB SEA68A0063Accident · 3 fatalClosedMooney M20B · Bend, ORApr 4, 1968 · N74561 · Destroyed NTSB SEA68D0307Accident · No injuriesClosedCessna 182 · Baker, ORApr 3, 1968 · N2709G · Destroyed NTSB SEA68F0289Accident · Serious injuriesClosedHiller UH-12E · Newport, ORApr 2, 1968 · N9757C · Destroyed NTSB SEA69F0010Accident · No injuriesClosedStearman PT-13 · Condon, ORMar 30, 1968 · N49377 · Substantial damage NTSB SEA69D0044Accident · No injuriesClosedCessna 172 · Ashland, ORMar 29, 1968 · N1718F · Substantial damage NTSB SEA68D0279Accident · No injuriesClosedCessna 172 · Mulino, ORMar 17, 1968 · N4197L · Substantial damage NTSB SEA68D0288Accident · No injuriesClosedPiper PA-28 · Millican, ORMar 16, 1968 · N6475W · Substantial damage NTSB SEA68D0280Accident · No injuriesClosedCulver LFA · Eugene, ORMar 16, 1968 · N41722 · Substantial damage NTSB SEA68D0285Accident · No injuriesClosedCessna 150 · Florence, ORMar 14, 1968 · N7112F · Substantial damage NTSB SEA68F0278Accident · Minor injuriesClosedCessna 150 · Dillard, ORMar 11, 1968 · N3099S · Substantial damage NTSB SEA68A0058Accident · 1 fatalClosedCessna 172G · Troutdale, ORMar 11, 1968 · N3898L · Destroyed NTSB SEA68D0271Accident · No injuriesClosedCessna 140 · Beaver Creek, ORMar 3, 1968 · N76167 · Substantial damage NTSB SEA68F0266Accident · No injuriesClosedPiper PA-22 · Crescent Lk, ORFeb 29, 1968 · N7021D · Substantial damage NTSB SEA68F0267Accident · No injuriesClosedPiper PA-22 · Gleneden Bch, ORFeb 27, 1968 · N8862C · Destroyed NTSB SEA68D0276Accident · No injuriesClosedLuscombe 8E · Progress, ORFeb 26, 1968 · N1284K · Substantial damage NTSB SEA68F0261Accident · No injuriesClosedCessna 182 · Springfield, ORFeb 11, 1968 · N2993Y · Substantial damage NTSB SEA68A0051Accident · 3 fatalClosedBeech B95 · Wilsonville, ORFeb 11, 1968 · N9657R · Destroyed NTSB SEA68F0256Accident · Serious injuriesClosedAeronca 65-CA · Ashland, ORJan 27, 1968 · N39353 · Destroyed NTSB SEA68F0272Accident · Minor injuriesClosedBeech E35 · Parkdale, ORJan 24, 1968 · N3525B · Destroyed NTSB SEA68A0048Accident · 1 fatalClosedPiper PA-24 · Medical Spgs, ORJan 15, 1968 · N7435P · Destroyed NTSB SEA68F0245Accident · No injuriesClosedCessna A188 · Central Pont, ORJan 6, 1968 · N9734V · Destroyed NTSB SEA68F0233Accident · No injuriesClosedCessna 182C · Springfield, ORDec 16, 1967 · N8900T · Substantial damage NTSB SEA68F0220Accident · No injuriesClosedCessna 170B · Prineville, ORNov 14, 1967 · N2732D · Substantial damage NTSB SEA68D0229Accident · No injuriesClosedCessna 182 · Forest Grove, ORNov 8, 1967 · N5700B · Substantial damage NTSB SEA68D0214Accident · No injuriesClosedLuscombe 8E · Ridgefield, ORNov 6, 1967 · N2543K · Substantial damage NTSB SEA68F0239Accident · Minor injuriesClosedCessna 140 · Newberg, ORNov 5, 1967 · N81034N · Destroyed NTSB SEA68A0040Accident · 2 fatalClosedStinson 108-2 · Tigard, ORNov 5, 1967 · N963D · Substantial damage NTSB SEA68D0198Accident · No injuriesClosedStinson 108 · Enterprise, ORNov 4, 1967 · N97408 · Substantial damage NTSB SEA68A0041Accident · 1 fatalClosedHughes 269B · Imnaha, ORNov 2, 1967 · N9426F · Destroyed NTSB SEA68A0037Accident · 1 fatalClosedCessna 180 · Roseburg, OROct 30, 1967 · N2478C · Destroyed NTSB SEA68A0036Accident · Minor injuriesClosedCessna U206 · Glendale, OROct 21, 1967 · N3484L · Destroyed NTSB SEA68A0035Accident · 1 fatalClosedCessna 182B · Colton, OROct 21, 1967 · N7118E · Destroyed NTSB SEA68D0215Accident · No injuriesClosedPiper J3C-65 · Bonanza, OROct 19, 1967 · N6832H · Substantial damage