Skip to content

NTSB investigations, 1981, OR

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 year(c."eventDate") = 1981 AND 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 year(c.\"eventDate\") = 1981
    AND 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 year(c."eventDate") = 1981
  AND 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 SEA81FYM26Accident · No injuriesClosedCessna P206 · Oregon City, ORJun 1, 1981 · N2526X · Substantial damage NTSB SEA81FYM25Accident · No injuriesClosedHiller Acft UH-12E · Milton-Freewtr, ORMay 29, 1981 · N99575 · Substantial damage NTSB SEA81FA036Accident · 1 fatalClosedBell 206B · Govt Camp, ORMay 22, 1981 · N58004 · Substantial damage NTSB SEA81DYM28Accident · No injuriesClosedCessna 182P · Cascade Locks, ORMay 21, 1981 · N52490 · Substantial damage NTSB SEA81FYM24Accident · No injuriesClosedMaule M4220C · North Plains, ORMay 10, 1981 · N2071U · Substantial damage NTSB SEA81FYK08Accident · Minor injuriesClosedPiper PA-22 · Medford, ORApr 30, 1981 · N7712D · Substantial damage NTSB SEA81DYM23Accident · No injuriesClosedCessna 140 · Pendleton, ORApr 30, 1981 · N2143V · Substantial damage NTSB SEA81FYK07Accident · Serious injuriesClosedHiller Acft UH-12E · Umpqua, ORMar 18, 1981 · N90467 · Substantial damage NTSB SEA81FYM81Accident · Minor injuriesClosedBeech B24R · Salem, ORMar 16, 1981 · N9369S · Substantial damage NTSB SEA81FA023Accident · 1 fatalClosedPiper PA28RT · Astoria, ORMar 14, 1981 · N2853T · Destroyed NTSB SEA81FYM21Accident · Serious injuriesClosedCallair A-9 · Pendleton, ORMar 7, 1981 · N7203V · Destroyed NTSB SEA81FA021Accident · 2 fatalClosedBeech A36 · Eugene, ORMar 4, 1981 · N17504 · Destroyed NTSB SEA81FYK06Accident · Minor injuriesClosedMooney M20C · Roseburg, ORMar 1, 1981 · N5994Q · Destroyed NTSB SEA81DYM20Accident · No injuriesClosedBeech C23 · Portland, ORFeb 10, 1981 · N5217M · Substantial damage NTSB SEA83FYM03Accident · 1 fatalClosedPiper PA-24 · Scappoose, ORFeb 9, 1981 · N8604P · Destroyed NTSB SEA81FYM18Accident · Serious injuriesClosedTeenie II · Madras, ORFeb 8, 1981 · N6045 · Substantial damage NTSB SEA81FYM19Accident · Minor injuriesClosedMooney M20 · Salem, ORFeb 7, 1981 · N5257B · Substantial damage NTSB SEA81FYM17Accident · No injuriesClosedPiper PA-38 · Yamhill, ORFeb 6, 1981 · N2515B · Substantial damage NTSB SEA81DYK05Accident · No injuriesClosedAeronca 7AC · Creswell, ORFeb 1, 1981 · N1528E · Substantial damage NTSB SEA81DYM16Accident · No injuriesClosedCessna 120 · Philomath, ORJan 25, 1981 · N77434 · Substantial damage NTSB SEA81FYK04Accident · Serious injuriesClosedCessna P210 · Medford, ORJan 10, 1981 · N4544K · Destroyed NTSB SEA81DYM13Accident · No injuriesClosedBellanca 7ECA · Molalla, ORJan 10, 1981 · N8668 · Substantial damage NTSB SEA81FA015Accident · 3 fatalClosedAero Comdr 690B · Burns, ORJan 7, 1981 · N81521 · Destroyed NTSB SEA81DYM15Accident · No injuriesClosedBell 206A · Mill City, ORJan 7, 1981 · N90099 · Substantial damage NTSB SEA81DYM14Accident · No injuriesClosedBeech A23-19 · Tillamook, ORJan 2, 1981 · N4778J · Substantial damage