Skip to content

NTSB investigations, OR

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 SEA78DYK03Accident · Serious injuriesClosedHiller Acft UH12E · Port Orford, ORDec 7, 1977 · N116HA · Destroyed NTSB SEA78DYK02Accident · No injuriesClosedCessna T210 · Redmond, ORNov 23, 1977 · N94001 · Substantial damage NTSB SEA78FYM09Accident · No injuriesClosedCessna 210E · Boardman, ORNov 11, 1977 · N4956U · Substantial damage NTSB SEA78FYM08Accident · Serious injuriesClosedCessna 172M · Forest Grove, ORNov 11, 1977 · N64084 · Destroyed NTSB SEA78FYM07Accident · Minor injuriesClosedHiller Acft UH-12E · Amity, ORNov 7, 1977 · N6ZH · Destroyed NTSB SEA78FA007Accident · 1 fatalClosedPiper PA-28 · Gales Creek, ORNov 4, 1977 · N2710Q · Destroyed NTSB SEA78FYM06Accident · Serious injuriesClosedHiller Acft UH-12E · Depoe Bay, ORNov 3, 1977 · N9786C · Substantial damage NTSB SEA78FA005Accident · 2 fatalClosedPiper PA-32 · Troutdale, OROct 26, 1977 · N1230W · Destroyed NTSB SEA78DYM05Accident · No injuriesClosedCessna TU206 · Gates, OROct 22, 1977 · N5458Q · Substantial damage NTSB SEA78DYK01Accident · No injuriesClosedPiper PA-32R · Klamath Falls, OROct 22, 1977 · N812PC · Substantial damage NTSB SEA78FYM04Accident · Minor injuriesClosedErco 415-C · Scappoose, OROct 5, 1977 · N2645H · Substantial damage NTSB SEA78FYM03Accident · No injuriesClosedEnstrom 280C · Aloha, OROct 5, 1977 · N111EE · Substantial damage NTSB SEA78FA006Accident · 2 fatalClosedCessna 182J · Umpqua, OROct 5, 1977 · N3383F · Destroyed NTSB SEA78FYM02Accident · Minor injuriesClosedBell 47G3B1 · Alsea, OROct 2, 1977 · N1199W · Substantial damage NTSB SEA77FA056Accident · 1 fatalClosedCessna 206 · Cove, ORSep 28, 1977 · N35904 · Destroyed NTSB SEA77DYK24Accident · Minor injuriesClosedCessna 150 · Ashland, ORSep 23, 1977 · N2646J · Substantial damage NTSB SEA77FA054Accident · 1 fatalClosedCessna 180 · Ashland, ORSep 21, 1977 · N9999N · Destroyed NTSB SEA77DYK23Accident · No injuriesClosedBeech C45H · Medford, ORSep 11, 1977 · N600UW · Substantial damage NTSB SEA77DYM62Accident · Minor injuriesClosedPiper PA-22 · The Dalles, ORSep 6, 1977 · N4841A · Substantial damage NTSB SEA77DYK22Accident · No injuriesClosedCessna 150L · Tenmile, ORAug 31, 1977 · N17067 · Substantial damage NTSB SEA77DYM61Accident · No injuriesClosedBellanca 8GCBC · Baker, ORAug 27, 1977 · N86714 · Substantial damage NTSB SEA77FA048Accident · 3 fatalClosedCessna 195A · Elgin, ORAug 18, 1977 · N4304V · Destroyed NTSB SEA77DYM57Accident · No injuriesClosedBeech C-18S · Sheridan, ORAug 14, 1977 · N4758N · Substantial damage NTSB SEA77DYK21Accident · No injuriesClosedPiper PA-28 · Riley, ORAug 13, 1977 · N7078W · Substantial damage NTSB SEA77FA047Accident · 1 fatalClosedAerostar 601P · Burns, ORAug 12, 1977 · N9578Q · Destroyed NTSB SEA77DA046Accident · Minor injuriesClosedCessna 210L · Klamath Falls, ORAug 3, 1977 · N92PF · Substantial damage NTSB SEA77DYM60Accident · No injuriesClosedBeech B35 · Dallas, ORJul 31, 1977 · N5066C · Substantial damage NTSB SEA77DYM55Accident · Minor injuriesClosedLuscombe 8A · The Dalles, ORJul 30, 1977 · N2712K · Destroyed NTSB SEA77DYM54Accident · No injuriesClosedCessna 320E · Yamhill, ORJul 30, 1977 · N3492Q · Substantial damage NTSB SEA77DYM56Accident · No injuriesClosedCessna 182 · John Day, ORJul 28, 1977 · N6176B · Substantial damage NTSB SEA77DYM50Accident · No injuriesClosedCessna 140 · Rufus, ORJul 28, 1977 · N89388 · Destroyed NTSB SEA77FYM49Accident · No injuriesClosedPiper PA-24 · Silverton, ORJul 25, 1977 · N5457P · Substantial damage NTSB SEA77FYM53Accident · No injuriesClosedSchweizer 2-33A · North Plains, ORJul 23, 1977 · N5759S · Substantial damage NTSB SEA77DYM48Accident · No injuriesClosedBuffum Mini Coupe · Willsonville, ORJul 23, 1977 · N75MB · Substantial damage NTSB SEA77DYM52Accident · No injuriesClosedHiller Acft UH-12C · Albany, ORJul 22, 1977 · N10321 · Substantial damage NTSB SEA77DYK19Accident · No injuriesClosedBlanik L-13 · Sisters, ORJul 22, 1977 · N90846 · Substantial damage NTSB SEA77DYM47Accident · No injuriesClosedPiper PA-28 · Wakonda Beach, ORJul 21, 1977 · N33346 · Substantial damage NTSB SEA77FYA31Accident · Serious injuriesClosedCallair A9B · Adrian, ORJul 19, 1977 · N7764V · Destroyed NTSB SEA77DYM45Accident · No injuriesClosedCessna 172 · Madras, ORJul 12, 1977 · N6414E · Substantial damage NTSB SEA77DYM51Accident · No injuriesClosedCessna 150 · Dallas, ORJul 11, 1977 · N22499 · Substantial damage NTSB SEA77DYA29Accident · No injuriesClosedCessna 188A · Ontario, ORJul 11, 1977 · N8088V · Destroyed NTSB SEA77DYK18Accident · Minor injuriesClosedM-Saulnier MS893E · Fields, ORJul 9, 1977 · N101GT · Substantial damage NTSB SEA77DYM46Accident · No injuriesClosedPiper PA-18 · Hermiston, ORJul 7, 1977 · N40523 · Substantial damage NTSB SEA77DYK17Accident · No injuriesClosedRyan ST-3KR · Ashland, ORJul 4, 1977 · N2860D · Substantial damage NTSB SEA77FYM44Accident · 1 fatalClosedBellanca 8KCAB · Ukiah, ORJul 2, 1977 · N78ML · Destroyed NTSB SEA77DYM43Accident · Minor injuriesClosedCessna 150 · Troutdale, ORJun 24, 1977 · N45580 · Substantial damage NTSB SEA77DYK15Accident · Minor injuriesClosedGrumman G-164A · Klamath Falls, ORJun 16, 1977 · N6662Q · Destroyed NTSB SEA77FYM40Accident · Serious injuriesClosedGrumman F6F-3 · Canby, ORJun 12, 1977 · N4965V · Substantial damage NTSB SEA77FYM39Accident · No injuriesClosedPiper PA-28 · Hillsboro, ORJun 11, 1977 · N123NW · Substantial damage NTSB SEA77FYM41Accident · 1 fatalClosedPitts S1 · Forrest Grove, ORJun 10, 1977 · N8444 · Destroyed