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 UNK64X2378Accident · No injuriesClosedPiper PA24 · Aurora, ORJun 19, 1964 · N6297P · Substantial damage NTSB UNK64X2336Accident · No injuriesClosedCessna 310 · Mcnary, ORJun 17, 1964 · N3045D · Substantial damage NTSB UNK64X2312Accident · No injuriesClosedCessna 210 · Klamath Falls, ORJun 16, 1964 · N196T · Substantial damage NTSB UNK64X2311Accident · 5 fatalClosedN.American F-51D · Roseburg, ORJun 15, 1964 · N1451D · Destroyed NTSB UNK64X2172Accident · No injuriesClosedPiper PA24 · Siletz, ORJun 7, 1964 · N6173P · Substantial damage NTSB UNK64X2100Accident · No injuriesClosedPiper PA18 · Bonanza, ORJun 4, 1964 · N1019A · Substantial damage NTSB UNK64X2065Accident · No injuriesClosedBoeing PT17 · Silvers, ORJun 2, 1964 · N9182Z · Substantial damage NTSB UNK64X1995Accident · No injuriesClosedPiper J3 · Sandy, ORMay 28, 1964 · N7074H · Substantial damage NTSB UNK64X1982Accident · Minor injuriesClosedBoeing E75 · Waconda, ORMay 27, 1964 · N1064N · Substantial damage NTSB UNK64X1961Accident · Minor injuriesClosedAeronca 7AC · Burns, ORMay 26, 1964 · N82569 · Substantial damage NTSB UNK64X1958Accident · 1 fatalClosedAeronca 11AC · Madras, ORMay 26, 1964 · N9181E · Destroyed NTSB UNK64X1889Accident · 1 fatalClosedGrumman TBM-3U · Rome, ORMay 22, 1964 · N7848C · Destroyed NTSB UNK64X1865Accident · Minor injuriesClosedBell 47G-2 · Enterprise, ORMay 20, 1964 · N4021A · Substantial damage NTSB UNK64X1814Accident · Serious injuriesClosedPiper PA22 · The Dalles, ORMay 17, 1964 · N3640P · Destroyed NTSB UNK64X1688Accident · No injuriesClosedPiper PA-22 · Mulino, ORMay 9, 1964 · N8644D · Substantial damage NTSB UNK64X1633Accident · No injuriesClosedPiper PA30 · Mill City, ORMay 6, 1964 · N246NW · Substantial damage NTSB UNK64X1554Accident · No injuriesClosedCessna 170B · Prineville, ORMay 2, 1964 · N2850C · Substantial damage NTSB UNK64X1551Accident · No injuriesClosedPiper PA28 · Hillsboro, ORMay 1, 1964 · N5723W · Substantial damage NTSB UNK64X1534Accident · 1 fatalClosedPiper J-5A · Paulina, ORApr 30, 1964 · N28260 · Destroyed NTSB UNK64X1501Accident · Minor injuriesClosedPiper PA12 · Beaver Creek, ORApr 28, 1964 · N98905 · Substantial damage NTSB UNK64X1377Accident · No injuriesClosedMooney M-18 · Hood River, ORApr 19, 1964 · N393A · Substantial damage NTSB UNK64X1345Accident · No injuriesClosedPiper PA18 · Blalock, ORApr 17, 1964 · N1278A · Substantial damage NTSB UNK64X1324Accident · No injuriesClosedPiper PA22 · Crescent, ORApr 15, 1964 · N934A · Substantial damage NTSB UNK64X1302Accident · No injuriesClosedBeechcraft 35 · Beaverton, ORApr 13, 1964 · N3854N · Substantial damage NTSB UNK64X1279Accident · No injuriesClosedCessna 140A · Burns, ORApr 12, 1964 · N5309C · Substantial damage NTSB UNK64X1112Accident · Minor injuriesClosedCessna 205 · Klamath Fall, ORMar 30, 1964 · N8403Z · Substantial damage NTSB UNK64X1030Accident · No injuriesClosedLuscombe 8A · Hurora, ORMar 24, 1964 · N71110 · Substantial damage NTSB UNK64X0955Accident · Minor injuriesClosedCessna 205 · Roseburg, ORMar 16, 1964 · N8172Z · Substantial damage NTSB UNK64X0873Accident · Minor injuriesClosedPiper PA22 · Condon, ORMar 10, 1964 · N2938P · Destroyed NTSB UNK64X0852Accident · 1 fatalClosedPiper PA22 · Idanha, ORMar 8, 1964 · N5812Z · Destroyed NTSB UNK64X0847Accident · No injuriesClosedPiper PA22 · The Dallas, ORMar 8, 1964 · N6852B · Substantial damage NTSB UNK64X0789Incident · No injuriesClosedFairchild F-27 · Portland, ORMar 2, 1964 · N2704 · Minor damage NTSB UNK64X0787Accident · 1 fatalClosedMooney M20B · Cave Junction, ORMar 1, 1964 · N74743 · Destroyed NTSB UNK64X0750Accident · No injuriesClosedCessna 175 · La Pine, ORFeb 29, 1964 · N6760E · Substantial damage NTSB UNK64X0714Accident · No injuriesClosedMooney M20 · Albany, ORFeb 27, 1964 · N5294B · Substantial damage NTSB UNK64X0679Accident · No injuriesClosedPiper PA18 · Allegany, ORFeb 23, 1964 · N3875Z · Substantial damage NTSB UNK64X0623Accident · No injuriesClosedBeechcraft 35 · Pendleton, ORFeb 20, 1964 · N5241C · Substantial damage NTSB UNK64X0531Accident · No injuriesClosedPiper PA22 · Cascade Lock, ORFeb 10, 1964 · N3743A · Substantial damage NTSB UNK64X0458Accident · No injuriesClosedMaule M4 · Clackmans, ORFeb 4, 1964 · N12016 · Substantial damage NTSB UNK64X0313Accident · Minor injuriesClosedCessna 182 · John Day, ORJan 21, 1964 · N7236E · Substantial damage NTSB UNK64X0268Accident · 4 fatalClosedCessna 182 · Lakeview, ORJan 17, 1964 · N5598B · Destroyed NTSB UNK64X0246Accident · No injuriesClosedCessna 182A · Hood River, ORJan 14, 1964 · N2135G · Destroyed NTSB SEA62A0003Accident · No injuriesClosedBoeing 720 · Portland, ORFeb 1, 1962 · N7206U · Substantial damage