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 SEA80FYM26Accident · No injuriesClosedStinson 10A · Pacific City, ORApr 13, 1980 · N21187 · Substantial damage NTSB SEA80DYK06Accident · Minor injuriesClosedErco 415-C · Glide, ORApr 12, 1980 · N2957H · Destroyed NTSB SEA80DYK07Accident · Serious injuriesClosedCessna T210 · Bend, ORMar 29, 1980 · N761XP · Substantial damage NTSB SEA80DYM29Accident · No injuriesClosedBell 47G-3B · Albany, ORMar 28, 1980 · N2243W · Substantial damage NTSB SEA80DYM24Accident · Minor injuriesClosedGrumman G-164A · Grass Valley, ORMar 20, 1980 · N4236 · Substantial damage NTSB SEA80DYM23Accident · Serious injuriesClosedPiper PA-25 · Antelope, ORMar 18, 1980 · N7077Z · Destroyed NTSB SEA80DYM22Accident · No injuriesClosedPiper PA-18 · Maupin, ORMar 16, 1980 · N7600B · Substantial damage NTSB SEA80DYM21Accident · Minor injuriesClosedWeatherly 201C · Hood River, ORMar 10, 1980 · N9107W · Destroyed NTSB SEA80FA020Accident · 3 fatalClosedCessna 172N · Dufur, ORFeb 24, 1980 · N2340E · Destroyed NTSB SEA80FYM16Accident · Minor injuriesClosedPiper PA-24 · Newport, ORFeb 22, 1980 · N5275P · Destroyed NTSB SEA80FYM17Accident · No injuriesClosedHughes 369HS · Siletz, ORFeb 21, 1980 · N9219F · Substantial damage NTSB SEA80FYK05Accident · Serious injuriesClosedPiper PA-24 · Allegany, ORFeb 9, 1980 · N5628P · Substantial damage NTSB SEA80FA018Accident · 2 fatalClosedBell 47G3B1 · Jefferson, ORJan 30, 1980 · N73285 · Destroyed NTSB SEA80FYK04Accident · Serious injuriesClosedRand KR-2 · Brookings, ORJan 29, 1980 · N23RP · Destroyed NTSB SEA80FYM13Accident · Serious injuriesClosedMaule M-5 · Portland, ORJan 19, 1980 · N9069E · Destroyed NTSB SEA80FYM12Accident · No injuriesClosedHiller Acft UH-12E · Willamina, ORJan 17, 1980 · N545HA · Substantial damage NTSB SEA80DYM11Accident · No injuriesClosedCessna 177RG · Hood River, ORDec 25, 1979 · N2185Q · Substantial damage NTSB SEA80DYM10Accident · No injuriesClosedAerospatle SA315B · Mill City, ORDec 17, 1979 · N55963 · Substantial damage NTSB SEA80FYM09Accident · Serious injuriesClosedCessna 150G · Aloha, ORDec 10, 1979 · N4825X · Substantial damage NTSB SEA80FYM07Accident · No injuriesClosedBeech 36 · Hillsboro, ORNov 30, 1979 · N7605N · Substantial damage NTSB SEA80FA009Accident · 2 fatalClosedMooney M20C · Grass Valley, ORNov 28, 1979 · N7090V · Destroyed NTSB SEA80FYM06Accident · Minor injuriesClosedCessna 152 · Newberg, ORNov 23, 1979 · N67500 · Substantial damage NTSB SEA80FA005Accident · 3 fatalClosedCessna T310R · Salem, ORNov 12, 1979 · N1316G · Destroyed NTSB SEA80FYM04Accident · No injuriesClosedBell 206A · Amity, ORNov 7, 1979 · N6212N · Substantial damage NTSB SEA80DYM02Accident · No injuriesClosedCessna TU206F · Elgin, ORNov 1, 1979 · N196BC · Substantial damage NTSB SEA80FYM01Accident · No injuriesClosedPiper PA-38 · Troutdale, OROct 24, 1979 · N2340D · Substantial damage NTSB SEA80DYK02Accident · No injuriesClosedCessna 310 · Brookings, OROct 20, 1979 · N4591L · Substantial damage NTSB SEA80DYK01Accident · No injuriesClosedCessna TU206 · Klamath Falls, OROct 12, 1979 · N1204Q · Substantial damage NTSB SEA79FYM67Accident · No injuriesClosedAeronca 7AC · Tigard, ORSep 23, 1979 · N1787E · Substantial damage NTSB SEA79FYM68Accident · No injuriesClosedCessna 172N · Clatskanie, ORSep 22, 1979 · N7335B · Substantial damage NTSB SEA79FYK32Accident · No injuriesClosedBeech P35 · Sunriver, ORSep 21, 1979 · N1752G · Substantial damage NTSB SEA79DYM66Accident · Minor injuriesClosedCessna 182P · Condon, ORSep 14, 1979 · N4677K · Substantial damage NTSB SEA79AA058Accident · 12 fatalClosedDouglas DC-7C · Klamath Falls, ORSep 14, 1979 · N4SW · Destroyed NTSB SEA79FYK31Accident · Minor injuriesClosedM.B.B. BO-209 · Grants Pass, ORSep 12, 1979 · N209AD · Substantial damage NTSB SEA79FYK29Accident · Minor injuriesClosedCessna 150F · Cottage Grove, ORSep 9, 1979 · N8937S · Substantial damage NTSB SEA79DYK30Accident · No injuriesClosedCessna 150 · Eugene, ORSep 8, 1979 · N7091F · Substantial damage NTSB SEA79FYK28Accident · No injuriesClosedCessna 152 · Creswell, ORSep 7, 1979 · N89487 · Substantial damage NTSB SEA79FA054Accident · 3 fatalClosedMooney M20C · Newberg, ORSep 1, 1979 · N9753M · Destroyed NTSB SEA79FA053Accident · 4 fatalClosedPiper PA-28 · Paisley, ORSep 1, 1979 · N2818N · Destroyed NTSB SEA79FYK27Accident · Serious injuriesClosedCessna 177RG · Redmond, ORAug 31, 1979 · N1882Q · Destroyed NTSB SEA79DYM63Accident · No injuriesClosedGrum-Amer AA-5B · Condon, ORAug 29, 1979 · N74472 · Substantial damage NTSB SEA79FYK24Accident · No injuriesClosedCessna A185F · Eugene, ORAug 25, 1979 · N93086 · Substantial damage NTSB SEA79DYM61Accident · No injuriesClosedCessna 305A · Sandy, ORAug 22, 1979 · N5305G · Substantial damage NTSB SEA79FYA23Accident · No injuriesClosedPiper PA-25 · Adrian, ORAug 21, 1979 · N6721Z · Substantial damage NTSB SEA79DYK23Accident · No injuriesClosedGrum Amer AA-5 · Medford, ORAug 20, 1979 · N6046L · Substantial damage NTSB SEA79DYM59Accident · No injuriesClosedMaule M4220C · Bates, ORAug 19, 1979 · N40307 · Substantial damage NTSB SEA79FYM58Accident · No injuriesClosedPiper PA-18 · Heppner, ORAug 18, 1979 · N3765Z · Substantial damage NTSB SEA79FYM57Accident · Serious injuriesClosedAero Comdr S-2R · Hermiston, ORAug 16, 1979 · N4945X · Substantial damage NTSB SEA79FYK21Accident · Serious injuriesClosedMaule M5-235 · Plush, ORAug 15, 1979 · N56291 · Destroyed NTSB SEA79DYK26Accident · No injuriesClosedCessna 150 · Burns, ORAug 3, 1979 · N61030 · Substantial damage