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 SEA68D0118Accident · No injuriesClosedCessna 150F · Sutherlin, ORJul 16, 1967 · N6533F · Substantial damage NTSB SEA69F0125Accident · 1 fatalClosedPiper J5C · Seaside, ORJul 14, 1967 · N68295 · Destroyed NTSB SEA68D0037Accident · No injuriesClosedCessna 182 · Cove, ORJul 14, 1967 · N3137S · Substantial damage NTSB SEA68D0098Accident · No injuriesClosedBeech C50 · Brookings, ORJul 10, 1967 · N3637B · Substantial damage NTSB SEA68D0043Accident · No injuriesClosedCessna 170B · Elgin, ORJul 5, 1967 · N3433C · Substantial damage NTSB SEA68D0075Accident · Minor injuriesClosedCessna 180 · Beaverton, ORJul 4, 1967 · N1633C · Substantial damage NTSB SEA68A0002Accident · 2 fatalClosedPiper J5A · Redmond, ORJul 1, 1967 · N35774 · Destroyed NTSB SEA68D0103Accident · No injuriesClosedMooney M20E · Burns, ORJun 29, 1967 · N5604Q · Substantial damage NTSB SEA68D0066Accident · No injuriesClosedCessna 182 · Salem, ORJun 24, 1967 · N2608R · Substantial damage NTSB SEA68A0074Accident · 1 fatalClosedPiper PA-16 · Wheeler, ORJun 18, 1967 · N5662H · Destroyed NTSB SEA67A0073Accident · No injuriesClosedHughes 269A · Klamath Fall, ORJun 18, 1967 · N8834F · Substantial damage NTSB SEA67D0350Accident · No injuriesClosedFairchild M62 · Rome, ORJun 15, 1967 · N56110 · Substantial damage NTSB SEA67A0070Accident · 1 fatalClosedPiper PA-18A · The Dalles, ORJun 4, 1967 · N7090D · Destroyed NTSB SEA68D0115Accident · No injuriesClosedPiper J3C-65 · Diamond, ORJun 3, 1967 · N42448 · Substantial damage NTSB SEA68D0025Accident · Minor injuriesClosedLuscombe 8A · North Bend, ORMay 30, 1967 · N45728 · Destroyed NTSB SEA68F0012Accident · Serious injuriesClosedErcoupe 415-C · Cottage Grve, ORMay 24, 1967 · N99793 · Destroyed NTSB SEA68D0052Accident · Serious injuriesClosedCessna 150 · Albany, ORMay 21, 1967 · N8727G · No damage NTSB SEA68D0039Accident · No injuriesClosedPiper PA-18 · Burns, ORMay 21, 1967 · N1086A · Substantial damage NTSB SEA68F0011Accident · No injuriesClosedCessna 150E · Medford, ORMay 20, 1967 · N2502J · Substantial damage NTSB SEA68F0016Accident · Minor injuriesClosedMooney M20C · Pacific City, ORMay 14, 1967 · N78889 · Destroyed NTSB SEA67A0062Accident · 4 fatalClosedCessna T210F · Lapine, ORMay 9, 1967 · N6164R · Destroyed NTSB SEA67D0345Accident · No injuriesClosedPiper PA-23 · Salem, ORMay 7, 1967 · N2182P · Substantial damage NTSB SEA67D0324Accident · No injuriesClosedPiper PA-14 · Milton Frewtr, ORMay 7, 1967 · N5145H · Substantial damage NTSB SEA68F0010Accident · No injuriesClosedPiper PA-16 · Sisters, ORMay 6, 1967 · N5779H · Substantial damage NTSB SEA67A0061Accident · 4 fatalClosedMooney M20C · Gleneden Bch, ORMay 6, 1967 · N9246M · Destroyed NTSB SEA67D0311Accident · No injuriesClosedPiper PA-18 · Rome, ORApr 28, 1967 · N42762 · Substantial damage NTSB SEA67F0343Accident · Serious injuriesClosedCessna 172F · Beaverton, ORApr 23, 1967 · N8196U · Substantial damage NTSB SEA67D0317Accident · No injuriesClosedErco 415-C · Corvallis, ORApr 23, 1967 · N94347 · Substantial damage NTSB SEA67F0299Accident · No injuriesClosedCessna 172G · Sutherlin, ORApr 17, 1967 · N3635L · Substantial damage NTSB SEA67A0058Accident · 3 fatalClosedPiper PA-30 · Halfway, ORApr 17, 1967 · N7458Y · Destroyed NTSB SEA68D0154Accident · No injuriesClosedPiper PA-24 · Warrenton, ORApr 16, 1967 · N6133P · Substantial damage NTSB SEA67D0294Accident · No injuriesClosedCessna 182 · Spray, ORApr 15, 1967 · N2360G · Substantial damage NTSB SEA67F0326Accident · No injuriesClosedCallair A-9 · Monmouth, ORApr 10, 1967 · N7240Y · Substantial damage NTSB SEA67F0298Accident · No injuriesClosedCessna 172G · Albany, ORApr 6, 1967 · N4681L · Substantial damage NTSB SEA67F0293Accident · Minor injuriesClosedStinson 108-1 · Boring, ORApr 2, 1967 · N8602K · Destroyed NTSB SEA67D0290Accident · No injuriesClosedCessna 120 · Roseburg, ORMar 27, 1967 · N2642N · Substantial damage NTSB SEA67D0328Accident · No injuriesClosedCessna 150 · Grass Valley, ORMar 25, 1967 · N3099J · Substantial damage NTSB SEA67F0297Accident · No injuriesClosedPiper PA-22 · Albany, ORMar 21, 1967 · N679A · Substantial damage NTSB SEA67D0289Accident · No injuriesClosedCessna 172 · Shady Grove, ORMar 20, 1967 · N8185B · Substantial damage NTSB SEA67D0288Accident · No injuriesClosedChampion 7GCBC · Prairie City, ORMar 19, 1967 · N8330V · Substantial damage NTSB SEA67A0049Accident · No injuriesClosedHughes 269A · Hillsboro, ORMar 12, 1967 · N8729F · Substantial damage NTSB SEA67D0258Accident · Minor injuriesClosedMooney M20B · North Powder, ORMar 11, 1967 · N78910 · Substantial damage NTSB SEA67A0047Accident · 4 fatalClosedFairchild F-27 · Klamath Fall, ORMar 10, 1967 · N2712 · Destroyed NTSB SEA67A0048Accident · No injuriesClosedEnstrom F-28 · Wilsonville, ORMar 9, 1967 · N192E · Substantial damage NTSB SEA68F0009Accident · No injuriesClosedPiper PA-23 · Scappoose, ORMar 7, 1967 · N3171P · Substantial damage NTSB SEA67F0261Accident · No injuriesClosedMooney M20E · Pendleton, ORMar 6, 1967 · N3359X · Substantial damage NTSB SEA67D0281Accident · Serious injuriesClosedCessna 150 · Bridal Veil, ORMar 5, 1967 · N8186S · Destroyed NTSB SEA67D0282Accident · Minor injuriesClosedCessna 150 · Chemult, ORFeb 22, 1967 · N8431G · Substantial damage NTSB SEA67D0279Accident · No injuriesClosedPiper PA-22 · Silver Lake, ORFeb 21, 1967 · N8276C · Substantial damage NTSB SEA67F0300Accident · No injuriesClosedBeech E35 · Springfield, ORFeb 20, 1967 · N3328C · Substantial damage