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 SEA67F0267Accident · No injuriesClosedErcoupe 415-C · Eugene, ORFeb 12, 1967 · N3555H · Substantial damage NTSB SEA67D0257Accident · No injuriesClosedPiper PA-28 · Arlington, ORFeb 10, 1967 · N7960W · Substantial damage NTSB SEA67D0264Accident · Minor injuriesClosedBoeing E75 · Dufur, ORFeb 7, 1967 · N1003N · Substantial damage NTSB SEA67D0256Accident · No injuriesClosedCessna 180 · Aurora, ORJan 31, 1967 · N2992A · Substantial damage NTSB SEA67F0236Accident · Minor injuriesClosedPiper PA-28 · Mulino, ORJan 28, 1967 · N6727W · Destroyed NTSB SEA67F0235Accident · No injuriesClosedPiper PA-24 · Newberg, ORJan 21, 1967 · N8345P · Substantial damage NTSB SEA67F0234Accident · No injuriesClosedGlobe GC-1B · Portland, ORJan 15, 1967 · N3761K · Substantial damage NTSB SEA67F0253Accident · No injuriesClosedBellanca 14-19 · Albany, ORJan 8, 1967 · N1313B · Substantial damage NTSB SEA67D0252Accident · No injuriesClosedFairchild 24 · Lakeview, ORJan 2, 1967 · N47053 · Substantial damage NTSB SEA67F0232Accident · No injuriesClosedBeech A45 · Aurora, ORDec 31, 1966 · N6602C · Substantial damage NTSB SEA67F0233Accident · Minor injuriesClosedNavion B · Hillsboro, ORDec 21, 1966 · N5351K · Substantial damage NTSB SEA67A0045Accident · No injuriesClosedBell 47G3B1 · Yachats, ORDec 14, 1966 · N8554F · Substantial damage NTSB SEA67F0231Accident · No injuriesClosedCessna 182H · Harrisburg, ORDec 12, 1966 · N2449X · Substantial damage NTSB SEA68A0008Accident · 1 fatalClosedCallari S-1A · Ashland, ORDec 8, 1966 · N37368 · Destroyed NTSB SEA67F0227Accident · No injuriesClosedBeech A23 · Portland, ORNov 27, 1966 · N2374W · Substantial damage NTSB SEA67D0215Accident · Serious injuriesClosedPiper PA-22 · Gibbon, ORNov 25, 1966 · N5830D · Destroyed NTSB SEA67D0226Accident · No injuriesClosedBeech 35 · Madras, ORNov 23, 1966 · N3854N · Substantial damage NTSB SEA67F0197Accident · No injuriesClosedCessna 320E · Eugene, ORNov 6, 1966 · N3446Q · Substantial damage NTSB SEA67F0225Accident · No injuriesClosedCessna 411 · Paisley, ORNov 5, 1966 · N7366U · Substantial damage NTSB SEA67D0222Accident · No injuriesClosedPiper PA-18 · Fossil, ORNov 3, 1966 · N3957Z · Substantial damage NTSB SEA67F0216Accident · No injuriesClosedPiper PA-32 · Sisters, OROct 31, 1966 · N3560W · Substantial damage NTSB SEA67F0224Accident · No injuriesClosedCessna 182E · Springfield, OROct 27, 1966 · N9257X · Destroyed NTSB SEA67D0223Accident · No injuriesClosedBellanca 14-13 · Malin, OROct 26, 1966 · N86717 · Destroyed NTSB SEA67D0196Accident · No injuriesClosedPiper PA-22 · Mulino, OROct 22, 1966 · N623A · Substantial damage NTSB SEA67D0204Accident · No injuriesClosedBeech A23 · Klamath Fall, OROct 19, 1966 · N3590R · Destroyed NTSB SEA67A0033Accident · No injuriesClosedHughes 269B · Frenchglen, OROct 13, 1966 · N9317F · Substantial damage NTSB SEA67D0190Accident · No injuriesClosedPiper PA-22 · Idanha, OROct 2, 1966 · N4418A · Substantial damage NTSB DCA67A0003Accident · 18 fatalClosedDouglas DC-9 · Nwemme, OROct 1, 1966 · N9101 · Destroyed NTSB SEA67F0161Accident · No injuriesClosedPiper PA-24 · North Bend, ORSep 28, 1966 · N5036P · Substantial damage NTSB SEA67F0189Accident · Serious injuriesClosedCessna T-210F · Hillsboro, ORSep 21, 1966 · N6731R · Destroyed NTSB SEA67A0030Accident · Minor injuriesClosedBensen B8-M · Albany, ORSep 20, 1966 · N74115 · Destroyed NTSB SEA67F0217Accident · No injuriesClosedCessna 170A · Chiloquin, ORSep 16, 1966 · N5471C · Substantial damage NTSB SEA67A0022Accident · 4 fatalClosedBeech A35 · Mitchell, ORSep 11, 1966 · N745B · Destroyed NTSB SEA67F0184Accident · Minor injuriesClosedCessna 150 · Springfield, ORSep 5, 1966 · N3690J · Substantial damage NTSB SEA67D0181Accident · No injuriesClosedAeronca 7FC · Blachly, ORSep 4, 1966 · N7547E · Substantial damage NTSB SEA67A0020Accident · No injuriesClosedHiller UH-12E · Cottage Grve, ORSep 3, 1966 · N9732C · Substantial damage NTSB SEA67D0180Accident · No injuriesClosedCessna 182B · Troutdale, ORSep 2, 1966 · N2654G · Substantial damage NTSB SEA67F0116Accident · Serious injuriesClosedPiper PA-22 · Redmond, ORSep 1, 1966 · N6956B · Substantial damage NTSB SEA67A0019Accident · No injuriesClosedBell 47G3B1 · Medford, ORSep 1, 1966 · N73287 · Substantial damage NTSB SEA67F0187Accident · No injuriesClosedCessna 150 · Eugene, ORAug 31, 1966 · N1236Y · Substantial damage NTSB SEA67D0172Accident · No injuriesClosedBeech S35 · Salem, ORAug 30, 1966 · N2001W · Substantial damage NTSB SEA67F0115Accident · No injuriesClosedCessna 150 · Roseburg, ORAug 25, 1966 · N6533F · Substantial damage NTSB SEA67D0171Accident · No injuriesClosedBeech S35 · Eugene, ORAug 25, 1966 · N6147V · Substantial damage NTSB SEA67A0017Accident · 1 fatalClosedBeech G35 · Rogue River, ORAug 25, 1966 · N4545D · Destroyed NTSB SEA67F0214Accident · No injuriesClosedPiper PA-22 · Hillsboro, ORAug 24, 1966 · N2931P · Substantial damage NTSB SEA67F0162Accident · No injuriesClosedPiper PA-22 · Lebanon, ORAug 21, 1966 · N8991C · Substantial damage NTSB SEA67F0158Accident · No injuriesClosedCessna 310 · Hillsboro, ORAug 21, 1966 · N3028D · Substantial damage NTSB SEA67D0098Accident · No injuriesClosedCessna 180 · Pendleton, ORAug 21, 1966 · N1681C · Substantial damage NTSB SEA67F0157Accident · No injuriesClosedPiper PA-24 · Oregon City, ORAug 19, 1966 · N7798P · Substantial damage NTSB SEA67F0112Accident · No injuriesClosedCessna 182-A · Crescent Lke, ORAug 19, 1966 · N5878B · Substantial damage