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 SEA79DYM55Accident · Minor injuriesClosedHiller Acft UH-12E · Warm Spgs Res, ORJul 28, 1979 · N6ZH · Destroyed NTSB SEA80FYM54Accident · Minor injuriesClosedHughes 369D · Bay City, ORJul 25, 1979 · N58184 · Substantial damage NTSB SEA79DYK20Accident · No injuriesClosedPiper PA-28 · White City, ORJul 25, 1979 · N6844W · Substantial damage NTSB SEA79DYM53Accident · No injuriesClosedCessna 150 · Pilot Rock, ORJul 24, 1979 · N51192 · Substantial damage NTSB SEA79FYA20Accident · No injuriesClosedCessna 188 · Nyssa, ORJul 22, 1979 · N9499R · Destroyed NTSB SEA79FYM52Accident · Serious injuriesClosedCessna 150 · Sisters, ORJul 21, 1979 · N51321 · Substantial damage NTSB SEA79FYM51Accident · Minor injuriesClosedBell 47G · Embler, ORJul 18, 1979 · N6356X · Substantial damage NTSB SEA79DYK19Accident · No injuriesClosedCessna 305A · Creswell, ORJul 18, 1979 · N5311G · Substantial damage NTSB SEA79DYM50Accident · No injuriesClosedBeech A36 · Troutdale, ORJul 13, 1979 · N24158 · Substantial damage NTSB SEA79FYM48Accident · No injuriesClosedGrumman G-164A · Hermiston, ORJul 11, 1979 · N5340 · Substantial damage NTSB SEA79FYM47Accident · Minor injuriesClosedPiper J-3 · Clatskanie, ORJul 8, 1979 · N38790 · Substantial damage NTSB SEA79FYM45Accident · No injuriesClosedPiper PA-24 · Salem, ORJul 1, 1979 · N6651P · Substantial damage NTSB SEA79DYM44Accident · Minor injuriesClosedCessna 185 · Madras, ORJun 24, 1979 · N4710Q · Substantial damage NTSB SEA79DYM42Accident · Minor injuriesClosedCessna 172 · Baker, ORJun 19, 1979 · N733QW · Substantial damage NTSB SEA79DYK17Accident · No injuriesClosedStinson 108-3 · Malin, ORJun 19, 1979 · N6813M · Substantial damage NTSB SEA79FYM41Accident · No injuriesClosedCessna 182 · Wilsonville, ORJun 18, 1979 · N4952D · Substantial damage NTSB SEA79DUK03Accident · No injuriesClosedPiper PA-28 · Riley, ORJun 16, 1979 · N1716J · Substantial damage NTSB SEA79DYK18Accident · Minor injuriesClosedBeech D-17S · Sisters, ORJun 15, 1979 · N1030 · Substantial damage NTSB SEA79DYM40Accident · No injuriesClosedBellanca 8GCBC · The Dalles, ORJun 14, 1979 · N4143Y · Substantial damage NTSB SEA79DYM38Accident · Minor injuriesClosedSnow S2D · Echo, ORJun 7, 1979 · N1717S · Destroyed NTSB SEA79DYA17Accident · No injuriesClosedCessna 188B · Ontario, ORJun 5, 1979 · N53177 · Substantial damage NTSB SEA79FYK16Accident · No injuriesClosedBeech A36 · Sunriver, ORJun 3, 1979 · N40JH · Substantial damage NTSB SEA79FYK14Accident · No injuriesClosedPiper PA-28R · Crescent Lake, ORJun 3, 1979 · N6998N · Substantial damage NTSB SEA79FYK15Accident · Serious injuriesClosedPiper PA-25 · Burns, ORJun 1, 1979 · N4753Y · Substantial damage NTSB SEA79DYM64Accident · No injuriesClosedCessna 337A · Estacada, ORJun 1, 1979 · N6351F · Substantial damage NTSB SEA79DYM37Accident · No injuriesClosedAero Comdr S2R · Helix, ORMay 25, 1979 · N4999X · Substantial damage NTSB SEA79DYK13Accident · Minor injuriesClosedStinson 108-3 · Ashland, ORMay 25, 1979 · N6740M · Substantial damage NTSB SEA79DXK12Accident · No injuriesClosedAmer Avco AA1-B · Chiloquin, ORMay 20, 1979 · N9876L · Substantial damage NTSB SEA79DYM35Accident · Minor injuriesClosedBell 206B · Island City, ORMay 18, 1979 · N59520 · Destroyed NTSB SEA79FYM34Accident · No injuriesClosedCoot A · Elmira, ORMay 12, 1979 · N12MP · Substantial damage NTSB SEA79DYM33Accident · No injuriesClosedCessna 188B · Fox, ORMay 12, 1979 · N9451G · Substantial damage NTSB SEA79FYM32Accident · No injuriesClosedHiller Acft UH-12E · Independence, ORMay 11, 1979 · N161HA · Substantial damage NTSB SEA79FYM31Accident · Serious injuriesClosedBaird/Beers AMFS14 · Mcminnville, ORMay 8, 1979 · N75LB · Destroyed NTSB SEA79FYK09Accident · Minor injuriesClosedPiper PA-28R · Grants Pass, ORMay 8, 1979 · N9433N · Destroyed NTSB SEA79FYK10Accident · Minor injuriesClosedPiper PA-24 · Klamath Falls, ORMay 6, 1979 · N5846P · Substantial damage NTSB SEA79FA032Accident · 1 fatalClosedCessna 150 · John Day, ORMay 1, 1979 · N7753F · Destroyed NTSB SEA79FYM30Accident · Serious injuriesClosedPiper PA-28 · Sandy, ORApr 28, 1979 · N7142W · Destroyed NTSB SEA79FYM29Accident · Minor injuriesClosedCessna 152 · Independence, ORApr 26, 1979 · N25790 · Substantial damage NTSB SEA79FYM28Accident · No injuriesClosedCessna 206G · The Dalles, ORApr 22, 1979 · N756SR · Substantial damage NTSB SEA79FYK08Accident · No injuriesClosedCessna 172N · Bend, ORApr 17, 1979 · N1365E · Substantial damage NTSB SEA79DYM27Accident · No injuriesClosedMaule M235C · Lord Flat, ORApr 13, 1979 · N9196E · Substantial damage NTSB SEA79FYM25Accident · Serious injuriesClosedCessna 172N · Pendleton, ORApr 2, 1979 · N737CD · Substantial damage NTSB SEA79FA028Accident · 2 fatalClosedPiper PA-28 · Brothers, ORMar 26, 1979 · N1649H · Destroyed NTSB SEA79DYM23Accident · No injuriesClosedHiller Acft UH-12E · Friend, ORMar 24, 1979 · N175HA · Substantial damage NTSB SEA79FYM19Accident · No injuriesClosedCessna T210N · John Day, ORMar 15, 1979 · N7426N · Substantial damage NTSB SEA79DYM20Accident · No injuriesClosedCessna 172 · Independence, ORMar 13, 1979 · N738AJ · Substantial damage NTSB SEA79FYK07Accident · No injuriesClosedTurbulent RWS-1 · Cresswell, ORMar 6, 1979 · N340S · Substantial damage NTSB SEA79DYM18Accident · Minor injuriesClosedErco 415-C · Santiam Jnctn, ORMar 4, 1979 · N93749 · Substantial damage NTSB SEA79DYK06Accident · Serious injuriesClosedCessna 177RG · La Pine, ORFeb 27, 1979 · N2042Q · Substantial damage NTSB SEA79FYK05Accident · No injuriesClosedHiller Acft UH-12E · Springfield, ORFeb 23, 1979 · N545HA · Substantial damage