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 SEA81DYM02Accident · No injuriesClosedPiper PA-28 · Molalla, OROct 3, 1980 · N33638 · Substantial damage NTSB SEA80FYM63Accident · No injuriesClosedCessna 182A · Harrisburg, ORSep 28, 1980 · N6163B · Substantial damage NTSB SEA80FYK18Accident · Serious injuriesClosedBell 47J-2A · Brookings, ORSep 9, 1980 · N2ZH · Destroyed NTSB SEA80FA046Accident · 1 fatalClosedCessna 172N · Pendleton, ORSep 7, 1980 · N3444E · Destroyed NTSB SEA80FYM60Accident · 1 fatalClosedBLN Works FF-6B · Shedd, ORSep 6, 1980 · N27057 · Destroyed NTSB SEA80DYM58Accident · No injuriesClosedCessna 172 · Molalla, ORSep 4, 1980 · N4923D · Substantial damage NTSB SEA80DYK17Accident · Minor injuriesClosedCessna 150 · Redmond, ORSep 4, 1980 · N1280Q · Substantial damage NTSB SEA81FYM61Accident · No injuriesClosedGrum Amer AA-5A · Newburg, ORSep 2, 1980 · N26777 · Substantial damage NTSB SEA81FYM07Accident · No injuriesClosedHughes 269C · Pilot Rock, ORAug 31, 1980 · N9643F · Substantial damage NTSB SEA80FYK15Accident · No injuriesClosedPiper PA-28R · Sixes, ORAug 25, 1980 · N444JT · Substantial damage NTSB SEA80DYK14Accident · No injuriesClosedCessna 210 · French Glen, ORAug 22, 1980 · N8250M · Substantial damage NTSB SEA80DYM55Accident · No injuriesClosedHiller Acft UH-12E · Tillamook, ORAug 19, 1980 · N59366 · Substantial damage NTSB SEA80DYM53Accident · No injuriesClosedAero Comdr 100 · Prineville, ORAug 17, 1980 · N2924T · Substantial damage NTSB SEA80DYK16Accident · No injuriesClosedCessna 188 · Medford, ORAug 15, 1980 · N4736Q · Substantial damage NTSB SEA80FYM54Accident · Serious injuriesClosedPiper PA-28 · Portland, ORAug 13, 1980 · N8084V · Substantial damage NTSB SEA80FYK13Accident · Minor injuriesClosedCessna 421 · Redmond, ORAug 11, 1980 · N3150K · Substantial damage NTSB SEA80FA040Accident · 4 fatalClosedAerofab LA-4-2 · Cascade Locks, ORAug 9, 1980 · N65640 · Destroyed NTSB SEA80FYK12Accident · Serious injuriesClosedCessna 182A · Roseburg, ORAug 5, 1980 · N3903D · Substantial damage NTSB SEA80FYK11Accident · No injuriesClosedCessna 140 · Creswell, ORAug 3, 1980 · N3691V · Substantial damage NTSB SEA80DYM51Accident · No injuriesClosedCessna 150L · Tigard, ORJul 27, 1980 · N11624 · Substantial damage NTSB SEA80DYM56Accident · No injuriesClosedCessna 210B · Lagrande, ORJul 26, 1980 · N9552X · Substantial damage NTSB SEA80FYM50Accident · Minor injuriesClosedPiper PA-22 · Dallas, ORJul 17, 1980 · N8841C · Substantial damage NTSB SEA80DYM47Accident · Serious injuriesClosedCessna 152 · Milton-Freewtr, ORJul 13, 1980 · N68450 · Substantial damage NTSB SEA80DYM46Accident · No injuriesClosedPiper PA-28 · Brooks, ORJul 13, 1980 · N2159C · Substantial damage NTSB SEA80DYM49Accident · No injuriesClosedHenkes RV-3 · Canby, ORJul 12, 1980 · N20RV · Substantial damage NTSB SEA80DYK09Accident · No injuriesClosedMaule M-5 · Klamath Falls, ORJul 8, 1980 · N369DG · Substantial damage NTSB SEA80FYM44Accident · No injuriesClosedPiper J3C-85 · Hood River, ORJul 7, 1980 · N7116H · Substantial damage NTSB SEA80DYM45Accident · No injuriesClosedPiper PA-18 · Hermiston, ORJul 7, 1980 · N9432P · Substantial damage NTSB SEA80DYM43Accident · No injuriesClosedPiper PA-36 · The Dalles, ORJul 7, 1980 · N9973P · Substantial damage NTSB SEA80FYK10Accident · Serious injuriesClosedPrue Super STD · Brothers, ORJun 27, 1980 · N86675 · Destroyed NTSB SEA80FA036Accident · 4 fatalClosedPiper PA32RT · Granite, ORJun 26, 1980 · N39691 · Destroyed NTSB SEA80DYM48Accident · No injuriesClosedCessna 150J · Long Creek, ORJun 22, 1980 · N61365 · Substantial damage NTSB SEA80FYM41Accident · No injuriesClosedHiller Acft UH-12E · Gales Creek, ORJun 20, 1980 · N48220 · Substantial damage NTSB SEA80DYM42Accident · No injuriesClosedCessna 182 · Madras, ORJun 15, 1980 · N70641 · Substantial damage NTSB SEA80FA032Accident · 1 fatalClosedPiper PA-28 · Woodburn, ORJun 14, 1980 · N5887V · Destroyed NTSB SEA80FA044Accident · 2 fatalClosedPiper PA-28 · Portland, ORJun 12, 1980 · N2333U · Destroyed NTSB SEA80FYM40Accident · Minor injuriesClosedHiller Acft FH1100 · Albany, ORJun 4, 1980 · N92484 · Substantial damage NTSB SEA80FA031Accident · 1 fatalClosedCessna 210L · Harrisburg, ORJun 4, 1980 · N732DX · Destroyed NTSB SEA80DYM38Accident · No injuriesClosedCessna 150 · Sevenson, ORMay 19, 1980 · N55041 · Substantial damage NTSB SEA80DYM37Accident · No injuriesClosedPiper PA-28 · Yamhill, ORMay 18, 1980 · N32526 · Substantial damage NTSB SEA80DYM36Accident · No injuriesClosedCessna 150M · Yamhill, ORMay 17, 1980 · N63448 · Substantial damage NTSB SEA80DYM35Accident · No injuriesClosedStinson 108-3 · Dayton, ORMay 17, 1980 · N20Q · Substantial damage NTSB SEA80FYM33Accident · No injuriesClosedCessna A188A · Gresham, ORMay 11, 1980 · N9990G · Substantial damage NTSB SEA80DYM27Accident · No injuriesClosedBellanca 7GCAA · Aurora, ORMay 3, 1980 · N53827 · Substantial damage NTSB SEA80DYK08Accident · Minor injuriesClosedBell 214B-1 · Bend, ORMay 1, 1980 · N224RM · Substantial damage NTSB SEA80DYM31Accident · Minor injuriesClosedNaval Fcty N3N-3 · Pendleton, ORApr 28, 1980 · N45018 · Substantial damage NTSB SEA80FYM30Accident · No injuriesClosedHiller Acft UH-12D · Scappoose, ORApr 23, 1980 · N5589Q · Substantial damage NTSB SEA80DYM28Accident · No injuriesClosedErco 415-C · Toledo, ORApr 22, 1980 · N2306H · Substantial damage NTSB SEA80DYM32Accident · No injuriesClosedPiper PA-24 · Cascade Locks, ORApr 20, 1980 · CF-BUN · Substantial damage NTSB SEA80DYA12Accident · No injuriesClosedCessna 182F · Jordan Valley, ORApr 19, 1980 · N9CR · Substantial damage