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 SEA68F0228Accident · No injuriesClosedCessna 172 · Yamhill, OROct 16, 1967 · N1621F · Substantial damage NTSB SEA68F0206Accident · No injuriesClosedCessna 172 · Newberg, OROct 11, 1967 · N3843R · Substantial damage NTSB SEA68D0202Accident · No injuriesClosedCessna 172 · Vernonia, OROct 7, 1967 · N7642X · Substantial damage NTSB SEA68D0219Accident · Minor injuriesClosedTaylorcraft BL-12 · Sandy, ORSep 26, 1967 · N34036 · Destroyed NTSB SEA68D0193Accident · No injuriesClosedTravel Air C-4000 · Camas Valley, ORSep 20, 1967 · N379M · Substantial damage NTSB SEA68D0207Accident · No injuriesClosedPiper PA-28 · Albany, ORSep 19, 1967 · N7349W · Substantial damage NTSB SEA68F0173Incident · Minor injuriesClosedBeech A23 · Woodburn, ORSep 18, 1967 · CF-VVH · Destroyed NTSB SEA68D0204Accident · No injuriesClosedCessna 150 · Independence, ORSep 17, 1967 · N3097J · Substantial damage NTSB SEA68A0027Accident · 1 fatalClosedCessna 172 · Portland, ORSep 16, 1967 · N5907A · Destroyed NTSB SEA68D0216Accident · No injuriesClosedPiper PA-24 · Bandon, ORSep 14, 1967 · N8899P · Destroyed NTSB SEA68D0192Accident · No injuriesClosedGlobe GC-1B · Warrenton, ORSep 12, 1967 · N2384B · Substantial damage NTSB SEA68D0190Accident · No injuriesClosedBeech 65 · Warrenton, ORSep 9, 1967 · N831Q · Substantial damage NTSB SEA68F0131Accident · Serious injuriesClosedChampion 7KCAB · North Bend, ORSep 6, 1967 · N2728G · Substantial damage NTSB SEA68D0161Accident · No injuriesClosedPiper PA-28 · Lapine, ORSep 4, 1967 · N7154R · Substantial damage NTSB SEA68A0024Accident · 1 fatalClosedAero Comdr 680 · Portland, ORSep 4, 1967 · N6809S · No damage NTSB SEA68F0231Accident · No injuriesClosedPiper PA-28 · Salem, ORSep 3, 1967 · N6049W · Substantial damage NTSB SEA68D0188Accident · No injuriesClosedCessna 175 · Medford, ORSep 3, 1967 · N7277M · Substantial damage NTSB SEA68D0091Accident · Minor injuriesClosedPiper PA-18 · Imnaha, ORSep 2, 1967 · N7533K · Destroyed NTSB SEA68A0022Accident · Serious injuriesClosedEnstrom F-28 · Santiam Jct, ORSep 2, 1967 · N192E · Destroyed NTSB SEA68F0200Accident · Serious injuriesClosedCessna 210 · Gold Beach, ORSep 1, 1967 · N9461T · Substantial damage NTSB SEA68D0184Accident · No injuriesClosedMooney M20C · Salem, ORSep 1, 1967 · N9336M · Substantial damage NTSB SEA68F0182Accident · No injuriesClosedBellanca 14-13 · Aurora, ORAug 28, 1967 · N74325 · Substantial damage NTSB SEA68D0179Accident · No injuriesClosedCessna 150G · Wasco, ORAug 27, 1967 · N3292J · Substantial damage NTSB SEA68F0126Accident · No injuriesClosedCessna 185 · Pendleton, ORAug 25, 1967 · N9931X · Substantial damage NTSB SEA68F0130Accident · No injuriesClosedBeech A23 · Portland, ORAug 23, 1967 · N2374W · Substantial damage NTSB SEA68D0171Accident · No injuriesClosedCessna 150G · North Bend, ORAug 23, 1967 · N4024J · Substantial damage NTSB SEA68A0019Accident · 3 fatalClosedMooney M20F · Albany, ORAug 20, 1967 · N2979L · Destroyed NTSB SEA68F0169Accident · No injuriesClosedCessna 182J · Halsey, ORAug 19, 1967 · N3084F · Substantial damage NTSB SEA68D0189Accident · Minor injuriesClosedPiper PA-22 · Aurora, ORAug 18, 1967 · N4546A · Substantial damage NTSB SEA68D0172Accident · No injuriesClosedPiper PA-24 · Klamath Fall, ORAug 17, 1967 · N6097P · Substantial damage NTSB SEA68F0170Accident · No injuriesClosedErco 415-C · Crabtree, ORAug 16, 1967 · N99785 · Substantial damage NTSB SEA68D0167Accident · Serious injuriesClosedPiper PA-22 · Creswell, ORAug 15, 1967 · N7153D · No damage NTSB SEA68F0106Accident · No injuriesClosedCessna 172 · Pendleton, ORAug 12, 1967 · N6091R · Substantial damage NTSB SEA68D0168Accident · No injuriesClosedCessna 310 · Aurora, ORAug 12, 1967 · N1110Q · Substantial damage NTSB SEA68D0195Accident · No injuriesClosedMaule M-4 · Scappoose, ORAug 8, 1967 · N4132C · Substantial damage NTSB SEA68D0102Accident · No injuriesClosedCessna 172 · Gates, ORAug 7, 1967 · N3739F · Substantial damage NTSB SEA68D0099Accident · No injuriesClosedGrumman G-21A · Sandy, ORAug 5, 1967 · N640 · Substantial damage NTSB SEA68F0205Accident · No injuriesClosedPiper PA-24 · Coos Bay, ORAug 3, 1967 · N5994P · Substantial damage NTSB SEA68A0011Accident · 4 fatalClosedPiper PA-28 · Sisters, ORAug 3, 1967 · N9154W · Destroyed NTSB SEA68F0125Accident · No injuriesClosedCessna 150F · Beaverton, ORAug 1, 1967 · N8419G · Substantial damage NTSB SEA68A0010Accident · 1 fatalClosedBell 47G3B1 · Rufus, ORJul 30, 1967 · N8518F · Destroyed NTSB SEA68F0203Accident · No injuriesClosedBeech 23 · Lakeside, ORJul 28, 1967 · N2346Q · Substantial damage NTSB SEA68F0122Accident · No injuriesClosedCessna 182K · Troutdale, ORJul 24, 1967 · N2691Q · Substantial damage NTSB SEA68D0087Accident · No injuriesClosedMooney M20E · Silverton, ORJul 24, 1967 · N5783Q · Substantial damage NTSB SEA68F0163Accident · Minor injuriesClosedMooney M20E · Beavertown, ORJul 23, 1967 · N9314M · Destroyed NTSB SEA68F0076Accident · No injuriesClosedCessna 120 · North Bend, ORJul 23, 1967 · N2642N · Destroyed NTSB SEA68F0096Accident · No injuriesClosedCessna 180 · Aurora, ORJul 21, 1967 · N2992A · Substantial damage NTSB SEA68D0094Accident · No injuriesClosedNavion B · North Bend, ORJul 18, 1967 · N5316K · Substantial damage NTSB SEA68D0095Accident · No injuriesClosedPiper J-3 · Newberg, ORJul 17, 1967 · N1075N · Substantial damage NTSB SEA68F0097Accident · No injuriesClosedBeech F35 · Beaverton, ORJul 16, 1967 · N3359C · Substantial damage