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 SEA65F0039Accident · No injuriesClosedPiper PA-20 · Ontario, ORApr 17, 1965 · N1561A · Substantial damage NTSB SEA65F0043Accident · Minor injuriesClosedCessna 182 · Pilot Rock, ORApr 10, 1965 · N2113G · Substantial damage NTSB SEA65F0025Accident · No injuriesClosedCessna 140 · Lebanon, ORMar 27, 1965 · N2593N · Substantial damage NTSB SEA65A0046Accident · 2 fatalClosedTaylorcraft BC12-D · Pacific City, ORMar 13, 1965 · N43141 · Destroyed NTSB SEA65F0038Accident · No injuriesClosedPiper PA-28 · Odell, ORMar 6, 1965 · N5102W · Substantial damage NTSB SEA65A0045Accident · No injuriesClosedBell 47G3 · Lagrande, ORMar 6, 1965 · N6784D · Destroyed NTSB SEA65D0026Accident · No injuriesClosedCessna 150 · Mitchel, ORMar 2, 1965 · N4320U · Substantial damage NTSB SEA65F0062Accident · No injuriesClosedCessna 150 · Mulino, ORFeb 28, 1965 · N7970E · Substantial damage NTSB SEA65F0019Accident · No injuriesClosedCessna 310B · Brownsville, ORFeb 28, 1965 · N5494A · Substantial damage NTSB SEA65A0044Accident · No injuriesClosedBell 47D1 · Roseburg, ORFeb 23, 1965 · N917B · Substantial damage NTSB SEA65F0012Accident · No injuriesClosedPiper PA-22 · Lake Oswego, ORFeb 13, 1965 · N1744A · Substantial damage NTSB SEA65F0001Accident · No injuriesClosedBeechraft M23 · Parkrose, ORFeb 3, 1965 · N2361J · Substantial damage NTSB SEA65A0041Accident · 2 fatalClosedCessna 182 · Unity, ORJan 27, 1965 · N5104D · Destroyed NTSB SEA65F0008Accident · No injuriesClosedPiper PA22 · Corvallis, ORJan 24, 1965 · N1726P · Substantial damage NTSB SEA65F0006Accident · No injuriesClosedBeechcraft D95A · Parkrose, ORJan 24, 1965 · N196Q · Substantial damage NTSB UNK65X1335Accident · No injuriesClosedCessna 172 · Troutdale, ORJan 23, 1965 · N2826U · Substantial damage NTSB SEA65F0004Accident · Minor injuriesClosedSwift GC-1B · Troutdale, ORJan 16, 1965 · N3761K · Substantial damage NTSB SEA65F0014Accident · No injuriesClosedCessna 180 · Burns, ORJan 3, 1965 · N6452X · Substantial damage NTSB UNK65X1108Accident · 3 fatalClosedPiper PA-22 · Salem, ORDec 23, 1964 · N2472A · Destroyed NTSB UNK65X1084Accident · 2 fatalClosedStinson 108 · Salem, ORDec 21, 1964 · N97562 · Destroyed NTSB UNK65X1034Accident · No injuriesClosedMooney M20A · Urg, ORDec 17, 1964 · N1095B · Substantial damage NTSB UNK65X0804Accident · No injuriesClosedAero Cmdr 680 · Portland, ORNov 23, 1964 · N6872S · Substantial damage NTSB UNK65X0484Accident · No injuriesClosedCessna 182 · Wallowa Co, OROct 30, 1964 · N3824D · Substantial damage NTSB UNK65X0359Accident · No injuriesClosedCessna 150 · Troutdale, OROct 21, 1964 · N6091T · Substantial damage NTSB UNK65X0340Accident · No injuriesClosedPiper PA23 · Rome, OROct 19, 1964 · N4942P · Substantial damage NTSB UNK65X0271Accident · No injuriesClosedCessna 182 · Minam Lodge, OROct 14, 1964 · N5818B · Substantial damage NTSB UNK65X0151Accident · Serious injuriesClosedCessna 140 · Beaverton, OROct 4, 1964 · N2291N · Substantial damage NTSB UNK65X0103Accident · No injuriesClosedStinson 1083 · Burns, OROct 1, 1964 · N6804M · Substantial damage NTSB UNK65X0100Case · No injuriesClosedBoeing B-720 · Portland, OROct 1, 1964 · N7211U NTSB UNK64X4199Accident · Serious injuriesClosedTaylorcraft BC12D · Bly, ORSep 28, 1964 · N34239 · Destroyed NTSB UNK64X4192Accident · No injuriesClosedBeechcraft 95 · Scappoose, ORSep 28, 1964 · N2736Y · Substantial damage NTSB UNK64X4157Accident · No injuriesClosedStinson 1082 · Hillsboro, ORSep 26, 1964 · N9351K · Substantial damage NTSB UNK64X3913Accident · No injuriesClosedNavion · Bend, ORSep 11, 1964 · N8838H · Substantial damage NTSB UNK64X3807Accident · 1 fatalClosedCessna 175A · Idleyld Park, ORSep 5, 1964 · N8074T · Destroyed NTSB UNK64X3583Accident · Minor injuriesClosedAeronca 7AC · Chiloquin, ORAug 25, 1964 · N2266E · Destroyed NTSB UNK64X3549Accident · 1 fatalClosedAeronca 7AC · Tillamook, ORAug 22, 1964 · N81971 · Destroyed NTSB UNK64X3474Accident · No injuriesClosedCessna 180 · Salem, ORAug 19, 1964 · N9024C · Substantial damage NTSB UNK64X3320Accident · Minor injuriesClosedPiper PA22 · Drewsey, ORAug 10, 1964 · N4871Z · Substantial damage NTSB UNK64X3249Accident · No injuriesClosedErcoupe 415C · Burns, ORAug 7, 1964 · N3179H · Substantial damage NTSB UNK64X3233Accident · No injuriesClosedPiper PA22 · Mulino, ORAug 6, 1964 · N7102D · Substantial damage NTSB UNK64X3219Accident · No injuriesClosedBell 47G3B1 · Jordan Valley, ORAug 4, 1964 · N30856 · Destroyed NTSB UNK64X3216Accident · No injuriesClosedPiper PA24 · Astoria, ORAug 4, 1964 · N5506P · Substantial damage NTSB UNK64X3102Accident · No injuriesClosedPiper PA30 · Hillsboro, ORJul 29, 1964 · N7398Y · Substantial damage NTSB UNK64X2989Accident · 2 fatalClosedPiper PA22 · Klamath Falls, ORJul 23, 1964 · N3257Z · Destroyed NTSB UNK64X2884Accident · 2 fatalClosedPiper PA-28 · Vale, ORJul 17, 1964 · N5139W · Destroyed NTSB UNK64X2728Accident · No injuriesClosedBeechcraft M23 · Troutdale, ORJul 9, 1964 · N2382Q · Substantial damage NTSB UNK64X2612Accident · Minor injuriesClosedTaylorcraft BC12D · Gaston, ORJul 3, 1964 · N96033 · Destroyed NTSB UNK64X2504Accident · Serious injuriesClosedErcoupe 415G · Mccredie Spgs, ORJun 26, 1964 · N94430 · Destroyed NTSB UNK64X2502Accident · No injuriesClosedLuscombe 8A · Lakeside, ORJun 26, 1964 · N45728 · Substantial damage NTSB UNK64X2448Accident · No injuriesClosedPiper PA22 · Bend, ORJun 23, 1964 · N3316B · Substantial damage