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 SEA67A0015Accident · Serious injuriesClosedDouglas A-26B · La Grande, ORAug 18, 1966 · N7719C · Substantial damage NTSB SEA67A0014Accident · 3 fatalClosedCessna 320-1 · Fairview, ORAug 15, 1966 · N5760X · Destroyed NTSB SEA67F0146Accident · No injuriesClosedAeronca 7AC · North Bend, ORAug 14, 1966 · N82802 · Substantial damage NTSB SEA67F0147Accident · No injuriesClosedTaylorcraft BC12-D · Tigard, ORAug 13, 1966 · N5033M · Substantial damage NTSB SEA67F0105Accident · No injuriesClosedCessna 170B · Troutdale, ORAug 9, 1966 · N2575D · Substantial damage NTSB SEA67D0087Accident · No injuriesClosedPiper PA-22 · Heppner, ORAug 8, 1966 · N4512A · Substantial damage NTSB SEA67A0012Accident · No injuriesClosedPiper PA-28 · Mitchell, ORAug 7, 1966 · N7409W · Substantial damage NTSB SEA67A0010Accident · Minor injuriesClosedHughes 269B · Eaverton, ORAug 7, 1966 · N9427F · Substantial damage NTSB SEA67A0009Accident · 2 fatalClosedPiper PA-22 · Seaside, ORAug 7, 1966 · N7629D · Destroyed NTSB SEA67D0141Accident · No injuriesClosedPorterfield CP-50 · Yamhill, ORAug 6, 1966 · N21973 · Substantial damage NTSB SEA67D0091Accident · No injuriesClosedCallair A-9 · Nyssa, ORJul 31, 1966 · N9617Z · Substantial damage NTSB SEA67F0135Accident · No injuriesClosedBeech J35 · Portland, ORJul 30, 1966 · N8368D · Substantial damage NTSB SEA67F0134Accident · No injuriesClosedMaule M-4 · Oledo, ORJul 28, 1966 · N12016 · Substantial damage NTSB SEA67A0007Accident · 3 fatalClosedPiper PA-20 · Glide, ORJul 25, 1966 · N6930K · Destroyed NTSB SEA67F0131Accident · No injuriesClosedBeech C-45H · Lakeview, ORJul 24, 1966 · N9985Z · Substantial damage NTSB SEA67F0118Accident · No injuriesClosedBoeing A75 · Springfield, ORJul 24, 1966 · N56769 · Substantial damage NTSB SEA67A0005Accident · No injuriesClosedBell 47G-3B · Lakeview, ORJul 19, 1966 · N8471E · Substantial damage NTSB SEA67F0104Accident · No injuriesClosedStinson 108-3 · Portland, ORJul 13, 1966 · N6238M · Destroyed NTSB SEA67F0084Accident · No injuriesClosedCessna 150 · Cottage Grove, ORJul 4, 1966 · N6604T · Substantial damage NTSB SEA67F0083Accident · No injuriesClosedCessna 172 · Madras, ORJul 3, 1966 · N5784R · Substantial damage NTSB SEA67A0001Accident · 2 fatalClosedRyan ST-3KR · Beaverton, ORJul 3, 1966 · N50879 · Destroyed NTSB SEA67F0082Accident · No injuriesClosedPiper J3C-65 · Beavercreek, ORJun 28, 1966 · N48612 · Substantial damage NTSB SEA66A0071Accident · No injuriesClosedHughes 269A · Eugene, ORJun 28, 1966 · N8756F · Destroyed NTSB SEA67D0079Accident · No injuriesClosedErcoupe 415-CD · Madras, ORJun 26, 1966 · N3555H · Substantial damage NTSB SEA67D0073Accident · No injuriesClosedStearman A75N1 · Merrill, ORJun 15, 1966 · N58388 · Destroyed NTSB SEA66A0066Accident · No injuriesClosedHiller UH-12E · Huntington, ORJun 13, 1966 · N9785C · Substantial damage NTSB SEA67D0074Accident · No injuriesClosedCessna 182 · Frenchglen, ORJun 12, 1966 · N6462A · Substantial damage NTSB SEA66A0065Accident · 1 fatalClosedNaval Fcty N3N-3 · Rome, ORJun 12, 1966 · N45267 · Destroyed NTSB SEA67F0064Accident · No injuriesClosedStinson 108-1 · Eugene, ORJun 11, 1966 · N8510K · Substantial damage NTSB SEA67D0085Accident · No injuriesClosedPiper PA-22 · Hermiston, ORJun 5, 1966 · N3346A · Substantial damage NTSB SEA67D0017Accident · No injuriesClosedCessna 180 · Baker, ORJun 5, 1966 · N2437F · Substantial damage NTSB SEA67F0060Accident · Serious injuriesClosedChampion 7GCBC · Prineville, ORMay 29, 1966 · N9651S · Destroyed NTSB SEA67D0062Accident · No injuriesClosedCessna 172 · Gold Beach, ORMay 28, 1966 · N3942L · Substantial damage NTSB SEA67F0056Accident · No injuriesClosedCessna 150 · Portland, ORMay 26, 1966 · N3576L · Substantial damage NTSB SEA66F0275Accident · No injuriesClosedPiper PA-24 · Salem, ORMay 26, 1966 · N5482P · Substantial damage NTSB SEA66A0059Accident · 3 fatalClosedMooney M20E · Merrill, ORMay 24, 1966 · N3448X · Destroyed NTSB SEA66A0058Accident · 4 fatalClosedPiper PA-24 · Npilot Rock, ORMay 22, 1966 · N5120P · Destroyed NTSB SEA67D0061Accident · No injuriesClosedPiper PA-22 · Eugene, ORMay 20, 1966 · N5210Z · Substantial damage NTSB SEA67D0010Accident · Minor injuriesClosedPiper PA-12 · La Grande, ORMay 20, 1966 · N3744M · Destroyed NTSB SEA67D0050Accident · No injuriesClosedCessna 150 · Beaverton, ORMay 19, 1966 · N5611E · Substantial damage NTSB SEA67F0040Accident · No injuriesClosedCessna 172C · Maupin, ORMay 17, 1966 · N8467X · Substantial damage NTSB SEA67F0033Accident · No injuriesClosedBeech C35 · Corvallis, ORMay 17, 1966 · N794D · Substantial damage NTSB SEA67F0032Accident · No injuriesClosedCessna 210E · Chiloquin, ORMay 16, 1966 · N1803F · Substantial damage NTSB SEA66A0057Accident · No injuriesClosedCessna 180 · Bend, ORMay 15, 1966 · N4692A · Substantial damage NTSB SEA66D0272Accident · No injuriesClosedCessna 172 · Heppner, ORMay 12, 1966 · N8141X · Substantial damage NTSB SEA66A0054Accident · 1 fatalClosedPiper PA-16 · Sutherlin, ORMay 6, 1966 · N5744H · Destroyed NTSB SEA67F0018Accident · Serious injuriesClosedPiper PA-22 · Florence, ORMay 4, 1966 · N6133D · Destroyed NTSB SEA67D0008Accident · No injuriesClosedPiper PA-28 · Sherwood, ORApr 30, 1966 · N8644W · Substantial damage NTSB SEA67F0007Accident · No injuriesClosedCessna 140 · Medford, ORApr 27, 1966 · N2172V · Substantial damage NTSB SEA66F0273Accident · Minor injuriesClosedCessna 170A · Wallowa, ORApr 27, 1966 · N2635V · Destroyed