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 SEA74DYC49Accident · No injuriesClosedHiller Acft UH-12E · Independence, ORMay 1, 1974 · N5332V · Substantial damage NTSB SEA74AS039Accident · 4 fatalClosedCessna 172K · Gold Beach, ORApr 28, 1974 · N79141 · Destroyed NTSB SEA74FYC47Accident · 1 fatalClosedPiper PA-25 · Corvallis, ORApr 24, 1974 · N7276Z · Destroyed NTSB SEA74FYC44Accident · 1 fatalClosedPiper J3C-65 · Cornelius, ORApr 16, 1974 · N92304 · Substantial damage NTSB FTW74DYC52Accident · No injuriesClosedBell 47G3B1 · Lebanon, ORApr 14, 1974 · N1373X · Destroyed NTSB SEA74FYC45Accident · No injuriesClosedCessna 150 · Grand Ronde, ORApr 12, 1974 · N5809E · Substantial damage NTSB SEA74AS038Accident · 3 fatalClosedAerostar 601 · La Grande, ORApr 11, 1974 · N7474S · Destroyed NTSB SEA74DYC31Accident · No injuriesClosedCessna 182K · Hillsboro, ORApr 7, 1974 · N3004Q · Substantial damage NTSB LAX74DYI11Accident · No injuriesClosedCessna 150 · Medford, ORApr 7, 1974 · N2800S · 2 aircraft · Substantial damage NTSB SEA74DYC42Accident · No injuriesClosedCessna 150J · Molalla, ORApr 6, 1974 · N61365 · Destroyed NTSB SEA74DYI10Accident · No injuriesClosedHiller Acft UH-12E · London, ORMar 24, 1974 · N90469 · Substantial damage NTSB SEA74DYC43Accident · No injuriesClosedCessna 177 · Newport, ORMar 23, 1974 · N30922 · Substantial damage NTSB SEA74FYC40Accident · No injuriesClosedSikorsky S-55B · Corvallis, ORMar 22, 1974 · N5663 · Substantial damage NTSB SEA74FYC39Accident · No injuriesClosedHiller Acft UH-12E · Sublimity, ORMar 18, 1974 · N9749C · Destroyed NTSB SEA74FYC38Accident · Serious injuriesClosedCallair A-9B · Beaverton, ORMar 15, 1974 · N7908V · Destroyed NTSB SEA74FYC36Accident · No injuriesClosedHiller Acft UH-12E · Mt Hood, ORMar 5, 1974 · N5367V · Substantial damage NTSB SEA74DYC33Accident · No injuriesClosedAmer Avco AA-1A · Lagrande, ORFeb 28, 1974 · N9343L · Substantial damage NTSB SEA74DYA24Accident · No injuriesClosedAeronca 7DC · Ontario, ORFeb 16, 1974 · N3085E · Substantial damage NTSB SEA74DYC34Accident · Minor injuriesClosedStinson 108-1 · Wilsonville, ORJan 8, 1974 · N8651K · Substantial damage NTSB SEA74DYC32Accident · No injuriesClosedCessna 182 · Portland, ORJan 2, 1974 · N2511R · Substantial damage NTSB SEA74DYC30Accident · No injuriesClosedPiper PA-28 · Mocalla, ORDec 30, 1973 · N55620 · Substantial damage NTSB SEA74DYC29Accident · No injuriesClosedCessna 172L · La Grande, ORDec 19, 1973 · N7251Q · Substantial damage NTSB SEA74DYC31Accident · Minor injuriesClosedCallair A-5T · Siletz, ORDec 8, 1973 · N6030C · Substantial damage NTSB SEA74FYC27Accident · No injuriesClosedNavion G · Salem, ORDec 5, 1973 · N2453T · Substantial damage NTSB SEA74DYC26Accident · No injuriesClosedCessna 140 · Portland, ORDec 1, 1973 · N76006 · Substantial damage NTSB SEA74DYI09Accident · No injuriesClosedCessna 177 · North Bend, ORNov 18, 1973 · N2289Y · Substantial damage NTSB SEA74DYC24Accident · No injuriesClosedPiper PA-22 · Mosier, ORNov 17, 1973 · N5912Z · Substantial damage NTSB SEA74DYC25Accident · Serious injuriesClosedCessna 150L · Salem, ORNov 10, 1973 · N18153 · Destroyed NTSB SEA74DYC23Accident · No injuriesClosedCessna 180 · Cascade Lock, ORNov 4, 1973 · N4515B · Substantial damage NTSB SEA74FYC22Accident · No injuriesClosedPiper PA-36 · Newberg, OROct 30, 1973 · N56148 · Substantial damage NTSB SEA74FYI07Accident · Serious injuriesClosedCessna 177 · Grants Pass, OROct 28, 1973 · N34601 · Substantial damage NTSB SEA74DYC21Accident · No injuriesClosedCessna 140 · Astoria, OROct 8, 1973 · N3086N · Substantial damage NTSB SEA74DYC19Accident · Minor injuriesClosedPiper PA-28 · Colton, ORSep 30, 1973 · N2479T · Substantial damage NTSB SEA74FVC18Accident · No injuriesClosedPiper PA-28 · Salem, ORSep 26, 1973 · N5239T · Substantial damage NTSB SEA74AS016Accident · 3 fatalClosedCessna 172L · Chiloquin, ORSep 16, 1973 · N2855Q · Destroyed NTSB SEA74DYC17Accident · No injuriesClosedCessna 310H · Imnaha, ORSep 15, 1973 · N1091Q · Substantial damage NTSB SEA74DYC16Accident · Minor injuriesClosedCessna 170A · Imnaha, ORSep 15, 1973 · N9211A · Substantial damage NTSB SEA74FYC05Accident · No injuriesClosedPiper PA-28 · Yamhill, ORSep 13, 1973 · N7655J · Substantial damage NTSB SEA74FYC14Accident · No injuriesClosedBeech A23 · La Grande, ORSep 10, 1973 · N4783J · Destroyed NTSB SEA74DYC15Accident · No injuriesClosedMcculloch J-2 · Redmond, ORSep 9, 1973 · N4327G · Substantial damage NTSB SEA74AS012Accident · 3 fatalClosedPiper PA-28 · Oakridge, ORSep 3, 1973 · N4576T · Destroyed NTSB SEA74DYC13CaseClosedCessna 177 · Dallas, ORSep 1, 1973 · N34591 NTSB SEA74FYC12Accident · No injuriesClosedBeech A35 · Salem, ORAug 26, 1973 · N707B · Substantial damage NTSB SEA74AS010Accident · 1 fatalClosedCessna 150L · Pendleton, ORAug 26, 1973 · N5316Q · Destroyed NTSB SEA74AS011Accident · 2 fatalClosedPiper PA-28 · Oakridge, ORAug 21, 1973 · N6344W · Destroyed NTSB SEA74AS008Accident · 2 fatalClosedLuscombe T-8F · Cottage Grov, ORAug 21, 1973 · N2139B · Destroyed NTSB SEA74FYC06Accident · Serious injuriesClosedCessna 150L · Granite, ORAug 20, 1973 · N10865 · Substantial damage NTSB SEA74DYC11Accident · No injuriesClosedPiper PA-20 · Aurora, ORAug 18, 1973 · N1018F · Substantial damage NTSB SEA74DYC10Accident · No injuriesClosedMooney M20B · Hillsboro, ORAug 13, 1973 · N74796 · Substantial damage NTSB SEA74FYC09Accident · No injuriesClosedCessna 150 · Baker, ORAug 12, 1973 · N4827X · Substantial damage