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 SEA72DYI20Accident · Minor injuriesClosedCessna 140 · Bend, ORApr 29, 1972 · N73079 · Substantial damage NTSB SEA72DYC37Accident · No injuriesClosedPiper PA-28 · Hillsboro, ORApr 26, 1972 · N1683J · Substantial damage NTSB SEA72DYA31Accident · No injuriesClosedBoeing A75 · Harper, ORApr 26, 1972 · N56236 · Substantial damage NTSB SEA72DYI21Accident · Minor injuriesClosedCessna 172K · North Bend, ORApr 25, 1972 · N84196 · Destroyed NTSB SEA72FYC34Accident · No injuriesClosedCessna 190 · Hillsboro, ORApr 22, 1972 · N4340N · Substantial damage NTSB SEA72FYC33Accident · Serious injuriesClosedBell 47G-5 · Albany, ORApr 19, 1972 · N1420 · Destroyed NTSB SEA72FYI19Accident · Serious injuriesClosedErco 415-C · Bonanza, ORApr 18, 1972 · N99237 · Substantial damage NTSB SEA72AS044Accident · 1 fatalClosedCessna 170A · Medford, ORApr 4, 1972 · N1474D · Destroyed NTSB SEA72FYC31Accident · No injuriesClosedCessna 170 · Donald, ORMar 28, 1972 · N2772D · Substantial damage NTSB SEA72AS040Accident · 4 fatalClosedPiper PA-22 · Ashland, ORMar 24, 1972 · N8917C · Destroyed NTSB SEA72DYI17Accident · No injuriesClosedHiller Acft FH1100 · Disston, ORMar 22, 1972 · N432FH · Destroyed NTSB SEA72DYC32Accident · No injuriesClosedCessna 182 · Lexington, ORMar 20, 1972 · N7236E · Substantial damage NTSB SEA72FYC30Accident · Minor injuriesClosedPiper PA-18 · North Plains, ORMar 17, 1972 · N1195A · Substantial damage NTSB SEA72AS039Accident · 1 fatalClosedPiper PA-23 · Salem, ORMar 14, 1972 · N5600Y · Destroyed NTSB SEA72FYC29Accident · No injuriesClosedAero Comdr 680-F · John Day, ORMar 10, 1972 · N6280X · Substantial damage NTSB SEA72AS038Accident · 1 fatalClosedPiper PA-23 · Brookings, ORMar 10, 1972 · N91Y · Destroyed NTSB SEA72DYA25Accident · No injuriesClosedBeech G35 · Jordan Vally, ORMar 6, 1972 · N4490D · Substantial damage NTSB SEA72DYI16Accident · Serious injuriesClosedCessna 140A · Azalea, ORMar 3, 1972 · N73076 · Substantial damage NTSB SEA72AS036Accident · 2 fatalClosedPiper PA-28R · Pendleton, ORMar 3, 1972 · N9434N · Destroyed NTSB SEA72AS035Accident · 1 fatalClosedCessna 205 · Canyonville, ORMar 3, 1972 · N8161Z · Destroyed NTSB SEA72DYI15Accident · Minor injuriesClosedAeronca L-3 · Grants Pass, ORFeb 18, 1972 · N53221 · Substantial damage NTSB SEA72DYI14Accident · No injuriesClosedPiper PA-28 · Redmond, ORFeb 15, 1972 · N6361W · Substantial damage NTSB SEA72AS030Accident · 1 fatalClosedPiper PA-28R · Corvallis, ORFeb 4, 1972 · N2824R · Destroyed NTSB SEA72DYI13Accident · No injuriesClosedStinson 108-1 · Brookings, ORFeb 2, 1972 · N97782 · Substantial damage NTSB SEA72FVC28Accident · No injuriesClosedCessna 172F · Vernonia, ORJan 31, 1972 · N8526U · Substantial damage NTSB SEA72FVC27Accident · Minor injuriesClosedBeech A23A · Portland, ORJan 28, 1972 · N3692Q · Destroyed NTSB SEA72DYI11Accident · No injuriesClosedBellanca 7GCBC · Burns, ORJan 16, 1972 · N9187L · Substantial damage NTSB SEA72DYI12Accident · Minor injuriesClosedCessna 172 · Deschutes, ORJan 10, 1972 · N78672 · Substantial damage NTSB SEA72DYI10Accident · No injuriesClosedStinson 108-1 · Klamath Flls, ORJan 2, 1972 · N8336K · Substantial damage NTSB SEA72DYA22Accident · No injuriesClosedAeronca 11AC · Brogan, ORDec 25, 1971 · N3175E · Substantial damage NTSB SEA72AS025Accident · 1 fatalClosedPiper PA-22 · Portland, ORDec 19, 1971 · N3535Z · Destroyed NTSB SEA72FYC25Accident · No injuriesClosedCessna 150 · Forest Grove, ORDec 18, 1971 · N7011S · Substantial damage NTSB SEA72AS028Accident · 3 fatalClosedCessna T337D · Vale, ORDec 13, 1971 · N86371 · Destroyed NTSB SEA72AS022Accident · 6 fatalClosedBeech C35 · Astoria, ORNov 25, 1971 · N1944D · Destroyed NTSB SEA72FYC24Accident · Minor injuriesClosedPiper PA-20 · Washougal, ORNov 20, 1971 · N7630K · Destroyed NTSB SEA72AS020Accident · 4 fatalClosedPiper PA-23 · Grants Pass, ORNov 17, 1971 · N1156P · Destroyed NTSB SEA72DYC23Accident · No injuriesClosedCessna 175 · Condon, ORNov 13, 1971 · N7095M · Substantial damage NTSB SEA72DYC22Accident · No injuriesClosedBeech A-23A · Troutdale, ORNov 13, 1971 · N3692Q · Substantial damage NTSB SEA72AS018Accident · 2 fatalClosedCessna P206 · Durkee, ORNov 1, 1971 · N2531X · Destroyed NTSB SEA72FYC21Accident · No injuriesClosedDruin Turb D-31 · Corvallis, OROct 20, 1971 · N7193 · Substantial damage NTSB SEA72AS017Accident · 2 fatalClosedMooney M20F · Azalea, OROct 11, 1971 · N6432Q · Destroyed NTSB SEA72DYC20Accident · No injuriesClosedPiper PA-22 · Oregon City, OROct 9, 1971 · N7323D · Substantial damage NTSB SEA72DYI09Accident · Minor injuriesClosedStearman PT-17 · Glide, ORSep 16, 1971 · N4769V · Destroyed NTSB SEA72AS012Accident · 4 fatalClosedMooney M20C · Lacomb, ORSep 12, 1971 · N3431X · Destroyed NTSB SEA72FYC18Accident · No injuriesClosedPiper PA-28 · Portland, ORSep 4, 1971 · N7603W · Substantial damage NTSB SEA72DYC19Accident · No injuriesClosedPiper PA-12 · Kimberley, ORAug 27, 1971 · N3480M · Substantial damage NTSB SEA72FYI08Accident · Serious injuriesClosedCessna 150G · Paisley, ORAug 26, 1971 · N3837J · Destroyed NTSB SEA72FYC17Accident · No injuriesClosedPiper PA-22 · Portland, ORAug 19, 1971 · N5037Z · Substantial damage NTSB SEA72DYI07Accident · No injuriesClosedPiper PA-24 · Bend, ORAug 19, 1971 · N6651P · Substantial damage NTSB SEA72DYC16Accident · No injuriesClosedMaule M-4 · Lagrande, ORAug 18, 1971 · N2077U · Substantial damage