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 SEA78FYM41Accident · Serious injuriesClosedPiper PA-22 · Grand Ronde, ORJun 29, 1978 · N5941D · Substantial damage NTSB SEA78DYM37Accident · No injuriesClosedCessna 188A · Enterprise, ORJun 28, 1978 · N5633J · Substantial damage NTSB SEA78FA039Accident · 4 fatalClosedPiper PA-28R · Baker, ORJun 24, 1978 · N40048 · Destroyed NTSB SEA78FA038Accident · 1 fatalClosedNavion A · Ashland, ORJun 23, 1978 · N91504 · Destroyed NTSB SEA78FYM40Accident · Serious injuriesClosedPiper PA-36 · Carlton, ORJun 21, 1978 · N41324 · Destroyed NTSB SEA78FYM38Accident · No injuriesClosedPiper PA-22 · Newberg, ORJun 17, 1978 · N3651P · Substantial damage NTSB SEA78FYM39Accident · 1 fatalClosedBoeing E75N1 · John Day, ORJun 16, 1978 · N4769V · Destroyed NTSB SEA78FYK17Accident · No injuriesClosedSnow 600S2D · Malin, ORJun 2, 1978 · N1726S · Substantial damage NTSB SEA78DYK18Accident · Minor injuriesClosedCessna 150 · Millican, ORJun 2, 1978 · N11737 · Substantial damage NTSB SEA78DYK15Accident · No injuriesClosedTemco D-16 · Redmond, ORMay 26, 1978 · N91623 · Substantial damage NTSB SEA78DYM35Accident · No injuriesClosedCessna 210 · Waldport, ORMay 23, 1978 · N29176 · Substantial damage NTSB SEA78DYM34Accident · No injuriesClosedPiper PA-30B · Madras, ORMay 20, 1978 · N7068Y · Substantial damage NTSB SEA78FYM36Accident · Minor injuriesClosedBeech A24R · Salem, ORMay 19, 1978 · N112FC · Substantial damage NTSB SEA78FYM33Accident · Serious injuriesClosedBell 206B · Tillamook, ORMay 15, 1978 · N4ZH · Destroyed NTSB SEA78FYM32Accident · No injuriesClosedS.N.I.A.S. SA316B · Portland, ORMay 11, 1978 · N5954 · Substantial damage NTSB SEA78DYM30Accident · No injuriesClosedCessna 182 · Enterprise, ORMay 8, 1978 · N71354 · Substantial damage NTSB SEA78DYM29Accident · No injuriesClosedBeech 35 · Gresham, ORMay 7, 1978 · N3927N · Substantial damage NTSB SEA78FYM31Accident · Minor injuriesClosedAeronca 7AC · Estacada, ORMay 6, 1978 · N3479E · Substantial damage NTSB SEA78FYA06Accident · Minor injuriesClosedCessna 172 · Ontario, ORMay 2, 1978 · N73347 · Substantial damage NTSB SEA78FYM28Accident · Serious injuriesClosedBeech F33A · La Grande, ORApr 26, 1978 · N4515A · Destroyed NTSB SEA78FYM27Accident · No injuriesClosedAmer Avco AA-1 · Oregon City, ORApr 23, 1978 · N6130L · Substantial damage NTSB SEA78DYK14Accident · No injuriesClosedCessna 172 · Medford, ORApr 16, 1978 · N2434Y · Substantial damage NTSB SEA78FYM25Accident · No injuriesClosedBell 47G · Kings Valley, ORApr 15, 1978 · N2919W · Substantial damage NTSB SEA78FA025Accident · 1 fatalClosedCessna 150L · Junction City, ORApr 11, 1978 · N10627 · Destroyed NTSB SEA78FYM24Accident · Minor injuriesClosedCessna 180 · Estacada, ORApr 8, 1978 · N4623B · Substantial damage NTSB SEA78FA023Accident · 4 fatalClosedPiper PA-28 · Milton Frwtr, ORMar 18, 1978 · N1844T · Destroyed NTSB SEA78FYK12Accident · Minor injuriesClosedConrad Daphne · Roseburg, ORMar 17, 1978 · N29613 · Substantial damage NTSB SEA78DYM22Accident · No injuriesClosedCessna 305A · Troutdale, ORMar 17, 1978 · N5236G · Substantial damage NTSB SEA78DYM21Accident · No injuriesClosedHughes 269C · The Dalles, ORMar 17, 1978 · N7471F · Destroyed NTSB SEA78DYK13Accident · No injuriesClosedCessna 172 · Malin, ORMar 15, 1978 · N7510T · Substantial damage NTSB SEA78FYM19Accident · No injuriesClosedHiller Acft UH-12E · Tillamook, ORMar 13, 1978 · N5ZH · Substantial damage NTSB SEA78DYM20Accident · No injuriesClosedCessna 150G · Aurora, ORMar 13, 1978 · N6699G · Substantial damage NTSB SEA78DYK11Accident · No injuriesClosedBell 47G3B1 · Myrtle Creek, ORMar 6, 1978 · N73984 · Substantial damage NTSB SEA78DYM18Accident · Minor injuriesClosedCessna 172 · Brooks, ORMar 5, 1978 · N5704A · Substantial damage NTSB SEA78FYK09Accident · Minor injuriesClosedCessna 210 · Sunriver, ORFeb 11, 1978 · N94162 · Substantial damage NTSB SEA78DYK10Accident · No injuriesClosedAlon A-2 · Christmas Vly, ORFeb 11, 1978 · N6523Q · Substantial damage NTSB SEA78FYK08Accident · Serious injuriesClosedPiper PA-18 · Ashland, ORFeb 7, 1978 · N83272 · Destroyed NTSB SEA78FA019Accident · 4 fatalClosedBeech 35 · Cascade Locks, ORFeb 7, 1978 · N3087V · Destroyed NTSB SEA78FYM16Accident · No injuriesClosedHiller UH-12E · Cannon Beach, ORJan 20, 1978 · N62346 · Substantial damage NTSB SEA78FYK07Accident · 1 fatalClosedPiper PA-25 · Christmas Vly, ORJan 20, 1978 · N6559L · Destroyed NTSB SEA78FYK06Accident · 1 fatalClosedHiller UH-12E · Reedsport, ORJan 20, 1978 · N65149 · Minor damage NTSB SEA78FYM15Accident · No injuriesClosedSmitts 77 · Elgin, ORJan 17, 1978 · N99453 · Substantial damage NTSB SEA78FA018Accident · 6 fatalClosedPiper PA-23 · Medford, ORJan 15, 1978 · N5675Y · Destroyed NTSB SEA78FYM14Accident · Serious injuriesClosedBell 47G3B2 · Milton-Freewtr, ORJan 4, 1978 · N2906W · Substantial damage NTSB SEA78DYM13Accident · No injuriesClosedPiper PA-28R · Aurora, ORDec 26, 1977 · N4936J · 2 aircraft · Minor damage NTSB SEA78DYK05Accident · No injuriesClosedPiper PA-28 · Agness, ORDec 23, 1977 · N56759 · Substantial damage NTSB SEA78FA014Accident · 7 fatalClosedAero Cmdr 520 · Cheshire, ORDec 22, 1977 · C-GHUN · Destroyed NTSB SEA78DYK04Accident · Minor injuriesClosedHiller Acft FH1100 · Walton, ORDec 22, 1977 · N92484 · Destroyed NTSB SEA78FYM12Accident · Minor injuriesClosedBeech A23 · Newberg, ORDec 21, 1977 · N14311 · Substantial damage NTSB SEA78DYM11Accident · No injuriesClosedCessna 152 · Dayton, ORDec 18, 1977 · N757JM · Substantial damage