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 SEA77DYC03Accident · Serious injuriesClosedPiper PA-24 · Oregon City, OROct 31, 1976 · N5090P · Substantial damage NTSB SEA77DYC02Accident · No injuriesClosedPiper PA-32 · Condon, OROct 12, 1976 · N8631N · Substantial damage NTSB SEA77DYC01Accident · No injuriesClosedCessna 150 · Lebanon, OROct 10, 1976 · N150FW · Substantial damage NTSB SEA77FA002Accident · 1 fatalClosedGlobe GC-1B · Hood River, OROct 9, 1976 · N80915 · Destroyed NTSB SEA77DYI01Accident · No injuriesClosedCessna 120 · Crane, OROct 2, 1976 · N77407 · Substantial damage NTSB SEA76FYC71Accident · No injuriesClosedCessna 320E · Hillsboro, ORSep 30, 1976 · N3472Q · Substantial damage NTSB SEA76FYI24Accident · Minor injuriesClosedPiper J-3 · Salt Crk Falls, ORSep 19, 1976 · N8360H · Substantial damage NTSB SEA76AS076Accident · 2 fatalClosedUniversal GC-1B · Mckenzie Brdg, ORSep 8, 1976 · N80826 · Destroyed NTSB SEA76DYC68Accident · No injuriesClosedTaylorcraft BC12-D · Oregon City, ORSep 6, 1976 · N5071M · Substantial damage NTSB SEA76DYIIOAccident · No injuriesClosedCessna 150 · Roseburg, ORSep 2, 1976 · N11758 · Substantial damage NTSB SEA76DYC69Accident · No injuriesClosedChampion 7ECA · Wallowa, ORSep 2, 1976 · N11063 · Substantial damage NTSB SEA76FYC67Accident · No injuriesClosedBeech 35 · Gervais, ORAug 25, 1976 · N3203V · Substantial damage NTSB SEA76AS069Accident · 1 fatalClosedMooney M20C · Portland, ORAug 11, 1976 · N9116V · Destroyed NTSB SEA76DYC65Accident · No injuriesClosedPiper PA-24 · Madras, ORJul 19, 1976 · N7610P · Substantial damage NTSB SEA76FYC64Accident · No injuriesClosedBeech D55 · Hillsboro, ORJul 12, 1976 · N73681 · Substantial damage NTSB SEA76DYI22Accident · No injuriesClosedPiper PA-23 · Lakeview, ORJul 12, 1976 · N3154P · Substantial damage NTSB SEA76DYI20Accident · No injuriesClosedStearman PT-17 · Frenchelenn, ORJul 11, 1976 · N9182Z · Substantial damage NTSB SEA76FYC62Accident · Serious injuriesClosedCessna 172M · Albany, ORJul 5, 1976 · N1381U · Substantial damage NTSB SEA76FYC61Accident · Serious injuriesClosedFairchild 24W-46 · Oregon City, ORJul 5, 1976 · N77602 · Substantial damage NTSB SEA76FYC63Accident · Minor injuriesClosedPietenpol S.A.M. · Albany, ORJul 2, 1976 · N5748 · Substantial damage NTSB SEA76AS058Accident · 1 fatalClosedHughes 369HS · Tygh Valley, ORJun 28, 1976 · N9123F · Destroyed NTSB SEA76AS057Accident · 1 fatalClosedCessna 150L · Clatskanie, ORJun 28, 1976 · N19310 · Destroyed NTSB SEA76DYC59Accident · Serious injuriesClosedCessna 150M · Brightwood, ORJun 27, 1976 · N45611 · Destroyed NTSB SEA76FYI21Accident · No injuriesClosedAeronca 65C · Elmira, ORJun 26, 1976 · N22116 · Substantial damage NTSB SEA76FYC60Accident · No injuriesClosedCessna 150L · Oregon City, ORJun 25, 1976 · N10297 · Substantial damage NTSB SEA76AS056Accident · 4 fatalClosedCessna 170 · Medford, ORJun 20, 1976 · N3945V · Destroyed NTSB SEA76DYI19Accident · Minor injuriesClosedPiper J-3 · Central Point, ORJun 19, 1976 · N40618 · Substantial damage NTSB SEA76DYC58Accident · Serious injuriesClosedBell 47G-4A · Lostine, ORJun 15, 1976 · N7945S · Destroyed NTSB SEA76FYC57Accident · Minor injuriesClosedCessna A188A · Moiser, ORJun 14, 1976 · N9965G · Substantial damage NTSB SEA76FYC56Accident · No injuriesClosedBeers-Baird AMFS14 · Carver, ORJun 13, 1976 · N75LB · Substantial damage NTSB SEA76DYC55Accident · No injuriesClosedCessna T210L · Mcminnville, ORJun 12, 1976 · N29176 · Substantial damage NTSB SEA76AS053Accident · 1 fatalClosedCessna 182P · Klamath Falls, ORJun 4, 1976 · N7466Q · No damage NTSB SEA76DYI18Accident · No injuriesClosedPiper PA-32 · Bend, ORJun 3, 1976 · N15326 · Substantial damage NTSB SEA76FYI17Accident · Serious injuriesClosedAmer Avco AA1 · Ashland, ORMay 31, 1976 · N6156L · Destroyed NTSB SEA76FYC54Accident · Serious injuriesClosedPiper PA-25 · Rickreall, ORMay 26, 1976 · N7436Z · Substantial damage NTSB SEA76FYC53Accident · No injuriesClosedCessna 172 · Aurora, ORMay 24, 1976 · N5375R · Substantial damage NTSB SEA76FYC51Accident · No injuriesClosedPiper PA-28 · Aurora, ORMay 18, 1976 · N4292T · Substantial damage NTSB SEA76FYC49Accident · Minor injuriesClosedEnstrom F-28A · Prairie City, ORMay 17, 1976 · N530H · Substantial damage NTSB SEA76FYC52Accident · No injuriesClosedMaule M4210C · Aurora, ORMay 16, 1976 · N984OM · Substantial damage NTSB SEA76DYC47Accident · No injuriesClosedCessna 150 · Clackamas, ORMay 15, 1976 · N61263 · Substantial damage NTSB SEA76DYC46Accident · No injuriesClosedCessna 172M · Yamhill, ORMay 15, 1976 · N13252 · Substantial damage NTSB SEA76FYC45Accident · Serious injuriesClosedHiller Acft UH-12E · Tillamook, ORMay 14, 1976 · N9785C · Destroyed NTSB SEA76AS048Accident · 1 fatalClosedStinson 108-2 · Dundee, ORMay 14, 1976 · N9728K · Destroyed NTSB SEA76AS047Accident · 1 fatalClosedPiper PA-28R · Mt.Jefferson, ORMay 13, 1976 · N3956T · Destroyed NTSB SEA76AS045Accident · 1 fatalClosedCessna 210C · Florence, ORMay 7, 1976 · N9792X · Destroyed NTSB SEA76FYC50Accident · No injuriesClosedCessna 210E · Lagrande, ORMay 6, 1976 · N1813F · Substantial damage NTSB SEA76FYC48Accident · No injuriesClosedAero Comdr 600S2R · Hermiston, ORMay 6, 1976 · N4229X · Substantial damage NTSB SEA76DYC44Accident · No injuriesClosedHiller Acft UH-12E · Alsea, ORMay 4, 1976 · N6ZH · Substantial damage NTSB SEA76FYC42Accident · Serious injuriesClosedPiper PA-25 · Condon, ORMay 3, 1976 · N7664Z · Substantial damage NTSB SEA76FYC43Accident · 1 fatalClosedSnow S2A · Heppner, ORMay 1, 1976 · N9409R · Destroyed