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 SEA76DYI16Accident · No injuriesClosedPiper PA-22 · Burns, ORApr 25, 1976 · N5928Z · Substantial damage NTSB SEA76AS044Accident · 2 fatalClosedCessna 177B · Roseburg, ORApr 21, 1976 · N10081 · Destroyed NTSB SEA76DYC40Accident · Minor injuriesClosedCessna 182B · Yamhill, ORApr 14, 1976 · N2495G · Destroyed NTSB SEA76DYC41Accident · No injuriesClosedPiper PA-18 · Portland, ORApr 13, 1976 · N7600B · Substantial damage NTSB SEA76A5043Accident · 1 fatalClosedCessna 172 · Sweet Home, ORApr 10, 1976 · N7075T · Destroyed NTSB SEA76DYC39Accident · No injuriesClosedGrumman G-164 · Condon, ORApr 6, 1976 · N4236 · Substantial damage NTSB SEA76FYC38Accident · Minor injuriesClosedHiller Acft UH-12E · Corvallis, ORApr 4, 1976 · N5ZH · Substantial damage NTSB SEA76FYC37Accident · Serious injuriesClosedCallair A-9B · Pendelton, ORApr 4, 1976 · N7676V · Substantial damage NTSB SEA76FYC36Accident · No injuriesClosedPiper PA-24 · Estacada, ORApr 3, 1976 · N7586P · Substantial damage NTSB SEA76DYI15Accident · No injuriesClosedCessna 172 · Klamath Falls, ORMar 26, 1976 · N3820Q · Substantial damage NTSB SEA76DYI14Accident · No injuriesClosedPiper PA-28 · La Pine, ORMar 26, 1976 · N15285 · Substantial damage NTSB SEA76AS037Accident · 1 fatalClosedCessna 337C · Government Cmp, ORMar 20, 1976 · N1234U · Destroyed NTSB SEA76DYC30Accident · No injuriesClosedCessna 182 · Hood River, ORFeb 24, 1976 · N3030F · Substantial damage NTSB SEA76FYC33Accident · No injuriesClosedPiper PA-22 · Hillsboro, ORFeb 21, 1976 · N4516A · Substantial damage NTSB SEA76DYC32Accident · No injuriesClosedBell 206B · Lagrande, ORFeb 21, 1976 · N96117 · Substantial damage NTSB SEA76FYC31Accident · Serious injuriesClosedCessna 150L · Sandy, ORFeb 18, 1976 · N19426 · Substantial damage NTSB SEA76DYC29Accident · Serious injuriesClosedCessna 150H · Pacific City, ORFeb 7, 1976 · N22906 · Substantial damage NTSB SEA76DYA16Accident · No injuriesClosedCessna 172 · Ontario, ORJan 27, 1976 · N1581V · Substantial damage NTSB SEA76FYC27Accident · No injuriesClosedLuscombe 8A · Albany, ORJan 20, 1976 · N1933B · Substantial damage NTSB SEA76DYI13Accident · No injuriesClosedPiper J-3 · Medford, ORJan 1, 1976 · N6584H · Substantial damage NTSB SEA76AS031Accident · 3 fatalClosedCessna R172 · Klamath Falls, ORDec 21, 1975 · N12987 · Destroyed NTSB SEA76FYC26Accident · Minor injuriesClosedHiller Acft UH-12D · Nehalem, ORDec 11, 1975 · N17714 · Destroyed NTSB SEA76FYI12Accident · No injuriesClosedBeech G35 · Bend, ORDec 5, 1975 · N4419D · Destroyed NTSB SEA76AS029Accident · 1 fatalClosedMooney M20C · Mount Hood, ORDec 1, 1975 · N9746M · Destroyed NTSB SEA76DYI11Accident · No injuriesClosedRyan Navion A · Klamath Falls, ORNov 29, 1975 · N91543 · Substantial damage NTSB SEA76AS028Accident · 2 fatalClosedPiper PA-24 · Myrtle Creek, ORNov 29, 1975 · N9451P · Destroyed NTSB SEA76DYC24Accident · No injuriesClosedMaule M4220C · Enterprise, OROct 28, 1975 · N40643 · Substantial damage NTSB SEA76AS023Accident · 2 fatalClosedCessna 150J · Grants Pass, OROct 28, 1975 · N50490 · Destroyed NTSB SEA76DYI10Accident · No injuriesClosedCessna 320F · Riley Junction, OROct 17, 1975 · N6163Q · Substantial damage NTSB SEA7LFYC22Accident · Minor injuriesClosedCessna 170B · Cascade Locks, ORSep 27, 1975 · N2772D · Substantial damage NTSB SEA76DYC21Accident · No injuriesClosedPiper PA-28 · Albany, ORSep 21, 1975 · N41505 · Substantial damage NTSB SEA76FYC20Accident · No injuriesClosedHiller Acft UH-12B · Brownsville, ORSep 20, 1975 · N8108H · Substantial damage NTSB SEA76DYI09Accident · Serious injuriesClosedBell 47J-2A · Roseburg, ORSep 20, 1975 · N2ZH · Substantial damage NTSB SEA76FYC19Accident · No injuriesClosedCessna 150F · Portland, ORSep 11, 1975 · N8352G · Substantial damage NTSB SEA76FYC18Accident · No injuriesClosedCessna 175 · Tillamook, ORSep 8, 1975 · N8097T · Substantial damage NTSB SEA76FYC17Accident · Serious injuriesClosedGrum Amer AA5 · Hillsboro, ORSep 7, 1975 · N9266L · Substantial damage NTSB SEA76FYI07Accident · No injuriesClosedAero Comdr A-9B · Roseburg, ORSep 3, 1975 · N7681V · Destroyed NTSB SEA76DYI06Accident · No injuriesClosedPiper PA-32 · Redmond, ORSep 1, 1975 · N4092R · Substantial damage NTSB SEA76DYC14Accident · No injuriesClosedPiper PA-32 · Enterprise, ORSep 1, 1975 · N3507W · Substantial damage NTSB SEA76DYC12Accident · No injuriesClosedChampion 7GCB · Antelope, ORAug 23, 1975 · N9958Y · Substantial damage NTSB SEA76FYC11Accident · 1 fatalClosedCallair A-9B · Pendleton, ORAug 15, 1975 · N7245V · Destroyed NTSB SEA76DYC10Accident · No injuriesClosedCessna A188B · Jefferson, ORAug 12, 1975 · N9873G · Destroyed NTSB SEA76FYC09Accident · No injuriesClosedPiper PA-28 · Mulino, ORAug 11, 1975 · N9577J · Substantial damage NTSB SEA76DYI05Accident · Minor injuriesClosedCessna 182 · Bonanza, ORAug 8, 1975 · N2541R · Destroyed NTSB SEA7KAS006Accident · 2 fatalClosedCessna 195A · Lincoln City, ORJul 28, 1975 · N1529D · Destroyed NTSB SEA76DYI04Accident · No injuriesClosedPiper PA-32 · Sunriver, ORJul 27, 1975 · N3560W · Substantial damage NTSB SEA76AS007Accident · 1 fatalClosedPiper PA-28 · Sheridan, ORJul 27, 1975 · N9183J · Destroyed NTSB SEA76DYI08Accident · No injuriesClosedBoeing E75 · Klamath Falls, ORJul 23, 1975 · N4769V · Substantial damage NTSB SEA76DYC08Incident · No injuriesClosedMooney M20C · Dalles, ORJul 23, 1975 · N9753M · Minor damage NTSB SEA76DYC07Accident · No injuriesClosedSchweizer SGS233 · North Plains, ORJul 19, 1975 · N5759S · Substantial damage