Skip to content

NTSB investigations, OR

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 SEA76DYC08Incident · No injuriesClosedMooney M20C · Dalles, ORJul 23, 1975 · N9753M · Minor damage NTSB SEA76DYC07Accident · No injuriesClosedSchweizer SGS233 · North Plains, ORJul 19, 1975 · N5759S · Substantial damage NTSB SEA76DYC06Accident · No injuriesClosedCessna 172 · Sandy, ORJul 19, 1975 · N4320R · Substantial damage NTSB SEA76FYI03Accident · No injuriesClosedAeronca 15AC · Lapine, ORJul 13, 1975 · N1313H · Substantial damage NTSB SEA7LFYC04Accident · No injuriesClosedBoeing E75 · Madras, ORJul 12, 1975 · N147KY · Substantial damage NTSB SEA76FYC03Accident · No injuriesClosedCessna 172 · Seaside, ORJul 11, 1975 · N61542 · Substantial damage NTSB SEA76DYI01Accident · No injuriesClosedCessna 170 · Redmond, ORJul 5, 1975 · N8282A · Destroyed NTSB SEA76FYC02Accident · No injuriesClosedCessna 180 · Molalla, ORJul 4, 1975 · N2468C · Substantial damage NTSB SEA76DYI02Accident · No injuriesClosedCessna 172 · Fields, ORJul 4, 1975 · N3880Q · Substantial damage NTSB SEA76DYC01Accident · No injuriesClosedPiper PA-25 · Baker, ORJul 3, 1975 · N6504Z · Substantial damage NTSB SEA75DYI31Accident · No injuriesClosedPiper PA-20 · Eugene, ORJun 28, 1975 · N7013K · Substantial damage NTSB SEA75DYC46Accident · No injuriesClosedBellanca 14-13 · Astoria, ORJun 27, 1975 · N86726 · Substantial damage NTSB SEA75FYI30Accident · Minor injuriesClosedCessna 180A · Sunriver, ORJun 26, 1975 · N9650B · Destroyed NTSB SEA75AYI28Accident · Serious injuriesClosedBoeing A75N1 · Malin, ORJun 22, 1975 · N53126 · 2 aircraft · No damage NTSB SEA75DYC42Accident · No injuriesClosedHiller Acft UH-12D · Manzanita, ORJun 14, 1975 · N17714 · Substantial damage NTSB SEA75DYC41Accident · No injuriesClosedBeech 35 · Wasco, ORJun 13, 1975 · N3965N · Substantial damage NTSB SEA75AS044Accident · 1 fatalClosedAmer Avco AA1-A · Portland, ORJun 13, 1975 · N9632L · Destroyed NTSB SEA75DYC40Accident · Serious injuriesClosedBell 47G-2A · Corvallis, ORMay 31, 1975 · N5161B · Destroyed NTSB SEA75FYC39Accident · No injuriesClosedPiper J3L-65 · Cornelius, ORMay 28, 1975 · N26841 · Substantial damage NTSB SEA75DYI27Accident · No injuriesClosedCessna 150 · Redmond, ORMay 28, 1975 · N10297 · Substantial damage NTSB SEA75DYI26Accident · No injuriesClosedMooney M20C · Norway, ORMay 28, 1975 · N3445X · Substantial damage NTSB SEA75DYI25Accident · Serious injuriesClosedCessna 210 · Riddle, ORMay 26, 1975 · N2308F · Destroyed NTSB SEA75DYI24Accident · No injuriesClosedCessna 170B · Medford, ORMay 26, 1975 · N2639D · Substantial damage NTSB SEA75FYC38Accident · No injuriesClosedPiper PA-24 · Enterprise, ORMay 20, 1975 · N8487P · Substantial damage NTSB SEA7KFYC37Accident · No injuriesClosedPiper PA-25 · Kent, ORMay 14, 1975 · N6638Z · Destroyed NTSB SEA75DYI23Accident · Minor injuriesClosedCessna 177 · Cottage Grove, ORMay 6, 1975 · N30039 · Substantial damage NTSB UNK75X0106Accident · No injuriesClosedCessna 150 · Chemult, ORApr 30, 1975 · N51321 · Substantial damage NTSB SEA75DYC36Accident · No injuriesClosedCessna 150K · St.Helens, ORApr 12, 1975 · N6224G · Destroyed NTSB SEA75DYI21Accident · No injuriesClosedCessna 150 · Bend, ORApr 9, 1975 · N9934G · Substantial damage NTSB SEA75DYC35Accident · No injuriesClosedCessna A188B · Albany, ORApr 9, 1975 · N9873G · Substantial damage NTSB SEA75AYC34Accident · No injuriesClosedHughes 269A · Astoria, ORApr 8, 1975 · N8775F · Substantial damage NTSB SEA75DYC30Accident · No injuriesClosedLuscombe 8A · The Dalles, ORMar 31, 1975 · N28551 · Substantial damage NTSB SEA75DYC32Accident · No injuriesClosedBell 47G3B1 · Corvallis, ORMar 20, 1975 · N1373X · Substantial damage NTSB SEA75AS034Accident · 1 fatalClosedCessna 150L · Albany, ORMar 14, 1975 · N5331Q · Substantial damage NTSB UNK75X0104Accident · No injuriesClosedCessna 411A · Salem, ORMar 7, 1975 · N210Z · Substantial damage NTSB SEA82FA102Accident · 3 fatalClosedCessna 182P · Union Creek, ORFeb 26, 1975 · N7391Q · Destroyed NTSB SEA75FYC29Accident · No injuriesClosedBeech D55 · Hermiston, ORFeb 25, 1975 · N7878R · Substantial damage NTSB SEA75AS033Accident · 3 fatalClosedCessna 182J · Albany, ORFeb 22, 1975 · N3084F · Destroyed NTSB SEA75FYC27Accident · No injuriesClosedCessna A188B · Independence, ORFeb 21, 1975 · N86448 · Substantial damage NTSB SEA75DYA20Accident · No injuriesClosedCessna 180 · Lapine, ORFeb 20, 1975 · N4969A · Substantial damage NTSB SEA75AS031Accident · 2 fatalClosedAmer Avco AA5 · Newberg, ORFeb 15, 1975 · N6063L · Destroyed NTSB SEA75AS032Accident · 3 fatalClosedPiper PA-20 · Drain, ORFeb 13, 1975 · N7691K · Destroyed NTSB SEA75DYC28Accident · No injuriesClosedCessna 182F · Hillsboro, ORFeb 6, 1975 · N3552Y · Substantial damage NTSB SEA75AS030Accident · 1 fatalClosedBellanca 7KCAB · Hillsboro, ORFeb 5, 1975 · N5250X · Destroyed NTSB SEA75DYC25Accident · No injuriesClosedCessna 180 · Wamic, ORJan 27, 1975 · N370G · Substantial damage NTSB SEA75FYC24Accident · No injuriesClosedHughes 369HS · Portland, ORJan 13, 1975 · N9207F · Substantial damage NTSB SEA75AS027Accident · 1 fatalClosedCessna 150H · Newberg, ORJan 13, 1975 · N3701J · Destroyed NTSB SEA75DYC23Accident · Minor injuriesClosedPiper PA-28 · Baker, ORJan 2, 1975 · N32763 · Substantial damage NTSB SEA75DYI19Accident · No injuriesClosedCessna 177 · Sunriver, ORJan 1, 1975 · N35092 · Substantial damage NTSB SEA75AS024Accident · 1 fatalClosedCessna 120 · Wasco, ORDec 19, 1974 · N2124V · Destroyed