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 SEA70D0087Accident · No injuriesClosedErco 415C · Canby, ORAug 17, 1969 · N3286H · Substantial damage NTSB SEA70A0010Accident · 1 fatalClosedCessna 140 · Newport, ORAug 14, 1969 · N2225N · Destroyed NTSB SEA70F0052Accident · No injuriesClosedPiper PA-22 · Halfway, ORAug 13, 1969 · N5709D · Substantial damage NTSB SEA70A0009Accident · 1 fatalClosedChampion 7KCAB · Scappoose, ORAug 10, 1969 · N1607G · Destroyed NTSB SEA70F0121Accident · No injuriesClosedPiper PA-28R · Lake O Woods, ORAug 9, 1969 · N7526J · Substantial damage NTSB SEA70D0063Accident · No injuriesClosedPiper PA-28 · Brookings, ORAug 9, 1969 · N9446J · Substantial damage NTSB SEA70A0007Accident · 2 fatalClosedBeech D50E · Sandy, ORAug 2, 1969 · N992T · Destroyed NTSB SEA70D0041Accident · No injuriesClosedWaco UMF · Adrian, ORJul 30, 1969 · N14085 · Destroyed NTSB SEA70D0073Accident · No injuriesClosedPiper PA-30 · Portland, ORJul 28, 1969 · N8125Y · Substantial damage NTSB SEA70D0065Accident · No injuriesClosedTravel Air E4000 · Nyssa, ORJul 28, 1969 · N477N · Substantial damage NTSB SEA70A0005Accident · 1 fatalClosedPiper PA-28 · Astoria, ORJul 27, 1969 · N9751W · Destroyed NTSB SEA70D0051Accident · No injuriesClosedPiper J3C-65 · Eugene, ORJul 25, 1969 · N8358H · Substantial damage NTSB SEA70F0046Accident · Serious injuriesClosedBell 47G3B2 · Albany, ORJul 19, 1969 · N4758R · Destroyed NTSB SEA70D0061Accident · No injuriesClosedCessna 180 · Donald, ORJul 18, 1969 · N2992A · Substantial damage NTSB SEA70F0055Accident · Minor injuriesClosedPiper PA-18 · White City, ORJul 17, 1969 · N7394D · Destroyed NTSB OAK70A0004Accident · 1 fatalClosedCessna 182 · Pendleton, ORJul 17, 1969 · N2193G · Destroyed NTSB SEA70D0060Accident · No injuriesClosedPiper PA-28 · Eugene, ORJul 12, 1969 · N6412W · Substantial damage NTSB SEA70F0118Accident · Minor injuriesClosedPiper PA-28R · Condon, ORJul 5, 1969 · N3940T · Substantial damage NTSB SEA70D0015Accident · No injuriesClosedBell 47G-2 · Ontario, ORJul 4, 1969 · N9963Z · Substantial damage NTSB OAK70A0001Accident · 2 fatalClosedCessna 177 · Astoria, ORJul 4, 1969 · N3372T · Destroyed NTSB SEA70D0006Accident · Minor injuriesClosedPiper PA-25 · Vale, ORJun 14, 1969 · N6512Z · Substantial damage NTSB SEA69A0060Accident · 3 fatalClosedCessna 337C · North Bend, ORJun 5, 1969 · N2665S · Destroyed NTSB SEA70D0009Accident · No injuriesClosedChampion 7EC · Eagle Point, ORJun 2, 1969 · N7547E · Substantial damage NTSB SEA69A0058Accident · 3 fatalClosedPiper PA-28 · Mcknzie Brdg, ORMay 30, 1969 · N7133R · Destroyed NTSB SEA70F0011Accident · No injuriesClosedCessna 150F · Scappoose, ORMay 26, 1969 · N8624G · Substantial damage NTSB SEA70F0032Accident · No injuriesClosedPiper PA-18 · Esticada, ORMay 23, 1969 · N4270Z · Substantial damage NTSB SEA70D0044Accident · Minor injuriesClosedAeronca 15AC · Burns, ORMay 23, 1969 · N1326H · Substantial damage NTSB SEA70D0010Accident · No injuriesClosedCessna 180H · Days Creek, ORMay 18, 1969 · N3480Y · Substantial damage NTSB SEA69A0055Accident · 2 fatalClosedPiper PA-16 · La Grande, ORMay 16, 1969 · N6853K · Destroyed NTSB SEA69A0054Accident · No injuriesClosedCessna 182B · Salem, ORMay 12, 1969 · N2380G · 2 aircraft · Substantial damage NTSB SEA69F0244Accident · No injuriesClosedGrumman TBM-3E · Ironside, ORMay 8, 1969 · N9564Z · Substantial damage NTSB SEA70F0002Accident · Serious injuriesClosedCessna 172 · Gaston, ORMay 7, 1969 · N9739T · Substantial damage NTSB SEA70D0028Accident · No injuriesClosedBeech B23 · Nehalem, ORMay 7, 1969 · N2361J · Substantial damage NTSB SEA70F0014Accident · Minor injuriesClosedBell 47G-2 · Springfield, ORMay 4, 1969 · N7891B · Substantial damage NTSB SEA69A0053Accident · 2 fatalClosedPiper PA-24 · Baker, ORMay 1, 1969 · N5831P · Destroyed NTSB SEA70A0003Accident · 1 fatalClosedBeech K35 · Brothers, ORApr 23, 1969 · N9556R · Destroyed NTSB SEA70D0001Accident · No injuriesClosedCessna 150 · Albany, ORApr 20, 1969 · N4046J · Substantial damage NTSB SEA69D0229Accident · Serious injuriesClosedCallair A-9B · Pendleton, ORApr 12, 1969 · N7286V · Destroyed NTSB SEA69F0257Accident · Minor injuriesClosedBeech D17S · Aurora, ORApr 7, 1969 · N1192V · Substantial damage NTSB SEA69D0223Accident · No injuriesClosedStinson L-5 · Heppner, ORApr 5, 1969 · N1785 · Substantial damage NTSB SEA69D0256Accident · No injuriesClosedBoeing A75N1 · Wasco, ORApr 3, 1969 · N62934 · Substantial damage NTSB SEA69F0247Accident · No injuriesClosedBoeing A75N1 · Condon, ORApr 1, 1969 · N53098 · No damage NTSB SEA69D0242Accident · No injuriesClosedCessna 337 · Monument, ORMar 30, 1969 · N6241F · Substantial damage NTSB SEA69F0233Accident · Minor injuriesClosedMooney M20A · Albany, ORMar 28, 1969 · CF-LYN · Substantial damage NTSB SEA69F0206Accident · No injuriesClosedBoeing E75 · Medford, ORFeb 28, 1969 · N4812V · Substantial damage NTSB SEA69F0214Accident · Minor injuriesClosedCessna 150H · Medford, ORFeb 27, 1969 · N22088 · Destroyed NTSB SEA69D0201Accident · No injuriesClosedHiller UH-12E · Medford, ORFeb 22, 1969 · N9732C · Substantial damage NTSB SEA69F0197Accident · No injuriesClosedCessna 120 · Beaverton, ORFeb 21, 1969 · N2551N · Destroyed NTSB SEA69F0199Accident · Minor injuriesClosedCessna 150F · Goshen, ORFeb 13, 1969 · N8920S · Destroyed NTSB SEA69F0184Accident · No injuriesClosedLear Jet 25 · Portland, ORJan 29, 1969 · N853GA · Substantial damage