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 SEA75FYC26Accident · No injuriesClosedBellanca 17-30 · Portland, ORDec 8, 1974 · N4876V · Substantial damage NTSB SEA75KYI18Accident · Serious injuriesClosedPiper PA-31P · North Bend, ORDec 6, 1974 · N104RE · Substantial damage NTSB SEA75FYC13Accident · 1 fatalClosedMullan SA-11A · Mcminnville, ORDec 1, 1974 · N3304 · Destroyed NTSB SEA75FYI17Accident · No injuriesClosedCessna 150 · North Bend, ORNov 23, 1974 · N6960G · Substantial damage NTSB SEA75DYI16Accident · Minor injuriesClosedMidget MM-1 · Creswell, ORNov 20, 1974 · N3070 · Substantial damage NTSB SEA75DYC12Accident · No injuriesClosedCessna 182A · Oregon City, ORNov 15, 1974 · N4787D · Substantial damage NTSB SEA75FYI15Accident · 1 fatalClosedBensen B8ME · Eugene, OROct 26, 1974 · N3306 · Destroyed NTSB SEA75DYC20Accident · No injuriesClosedCessna 150 · St Paul, OROct 19, 1974 · N23015 · Substantial damage NTSB SEA75DYC19Accident · Minor injuriesClosedBeech E35 · Lagrande, OROct 10, 1974 · N3212C · Substantial damage NTSB SEA75DYI14Accident · Minor injuriesClosedBeech 19 · Burns, OROct 6, 1974 · N1960W · Substantial damage NTSB SEA75DYI13Accident · Minor injuriesClosedPiper PA-28 · Medford, OROct 4, 1974 · N1798T · Destroyed NTSB SEA75DYC18Accident · No injuriesClosedCessna 177 · Kent, OROct 4, 1974 · N1851Q · Substantial damage NTSB SEA75DYI12Accident · No injuriesClosedCessna 182 · Bend, ORSep 28, 1974 · N8599T · Substantial damage NTSB SEA75DYC17Accident · Minor injuriesClosedPiper PA-18A · Friend, ORSep 26, 1974 · N1456C · Substantial damage NTSB SEA75FYI10Accident · No injuriesClosedBoeing A75N1 · Wilbur, ORSep 22, 1974 · N4825V · Destroyed NTSB SEA75DYI09Accident · Minor injuriesClosedCessna 177RG · Medford, ORSep 17, 1974 · N2066Q · Substantial damage NTSB SEA75AYI11Accident · No injuriesClosedCessna 172 · Eugene, ORSep 17, 1974 · N20981 · Substantial damage NTSB SEA75DYI08Accident · Minor injuriesClosedPiper J5A · Bend, ORSep 2, 1974 · N38862 · Substantial damage NTSB SEA75AS011Accident · 2 fatalClosedPiper PA-12 · Medford, ORAug 30, 1974 · N3020M · Destroyed NTSB SEA75FYC14Accident · No injuriesClosedCessna 182H · Oregon City, ORAug 29, 1974 · N8321S · Substantial damage NTSB SEA75DYI07Accident · Minor injuriesClosedPiper PA-28 · Crescent Lk, ORAug 27, 1974 · N5571F · Substantial damage NTSB SEA75DYI06Accident · No injuriesClosedBensen B-8M · Eugene, ORAug 17, 1974 · N3306 · Substantial damage NTSB SEA75DVC15Accident · No injuriesClosedPiper PA-32 · Condon, ORAug 17, 1974 · N3623W · Substantial damage NTSB SEA75FYC10Accident · Serious injuriesClosedCessna T206 · Pendleton, ORAug 14, 1974 · N2516X · Destroyed NTSB SEA75FYI04Accident · Serious injuriesClosedBeech 36 · Klamath Fls, ORAug 12, 1974 · N7703R · Substantial damage NTSB SEA75FYC08Accident · No injuriesClosedPiper PA-28 · Aurora, ORAug 8, 1974 · N5023T · Substantial damage NTSB SEA75DYC06Accident · No injuriesClosedPiper PA-28 · Ukiah, ORAug 6, 1974 · N3088T · Substantial damage NTSB SEA75DYI05Accident · No injuriesClosedLuscombe 8A · Medford, ORAug 2, 1974 · N1151B · Substantial damage NTSB SEA75DYI03Accident · Serious injuriesClosedCessna 180H · Roseburg, ORJul 31, 1974 · N2736X · Substantial damage NTSB SEA75FYI02Accident · No injuriesClosedPiper PA-32 · Bend, ORJul 29, 1974 · N4232R · Substantial damage NTSB SEA75FYC05Accident · No injuriesClosedFly Baby 1 · Hubbard, ORJul 20, 1974 · N4604 · Substantial damage NTSB SEA75FYC04Accident · No injuriesClosedGrumman G-44 · Sandy, ORJul 16, 1974 · N708C · Substantial damage NTSB SEA75FYC03Accident · No injuriesClosedHiller Acft UH-12E · Dayton, ORJul 16, 1974 · N104HA · Substantial damage NTSB SEA75DYC02Accident · No injuriesClosedVertol 107 · Estacada, ORJul 11, 1974 · N6676D · No damage NTSB SEA75DYI01Accident · No injuriesClosedBell 47G · Midland, ORJul 7, 1974 · N957B · Destroyed NTSB SEA75DYC01Accident · No injuriesClosedAmer Avco AA1-A · Sandy, ORJul 3, 1974 · N6368L · Substantial damage NTSB SEA74FYI13Accident · Serious injuriesClosedStearman A75N1 · Klamath Flls, ORJun 28, 1974 · N53399 · Substantial damage NTSB SEA74AS051Accident · 1 fatalClosedCessna 182P · Zigzag, ORJun 25, 1974 · N21018 · Destroyed NTSB SEA74DYC62Accident · No injuriesClosedPiper PA-32 · Pacific City, ORJun 23, 1974 · N4429T · Substantial damage NTSB SEA74DYC60Accident · No injuriesClosedMooney M10 · Lebanon, ORJun 23, 1974 · N9515V · Substantial damage NTSB SEA74FYC61Accident · Serious injuriesClosedJohnson Chris · Mcminnville, ORJun 21, 1974 · N7192 · Destroyed NTSB SEA74DYI12Accident · No injuriesClosedPiper PA-28 · Sunriver, ORJun 8, 1974 · N4758T · Substantial damage NTSB SEA74DYA43Accident · No injuriesClosedCessna 188 · Nyssa, ORJun 8, 1974 · N9867U · Substantial damage NTSB SEA74FYC56Accident · 1 fatalClosedMay Flybaby 1 · Salem, ORMay 27, 1974 · N93003 · Destroyed NTSB SEA74FYC55Accident · No injuriesClosedBeech D18S · Mcminnville, ORMay 26, 1974 · N104J · Substantial damage NTSB SEA74DYC54Accident · Minor injuriesClosedBell 47G-3B · North Powder, ORMay 24, 1974 · N73940 · Substantial damage NTSB SEA74FYC53Accident · Serious injuriesClosedBellanca 17-30A · Hillsboro, ORMay 22, 1974 · N8290R · Destroyed NTSB SEA74DYC50Accident · No injuriesClosedPiper PA-28 · Mulino, ORMay 15, 1974 · N15285 · Substantial damage NTSB SEA74DYC48Accident · Minor injuriesClosedPiper PA-18 · Echo, ORMay 9, 1974 · N3965Z · Substantial damage NTSB SEA74AS042Accident · 1 fatalClosedPiper PA-30 · Deer Island, ORMay 2, 1974 · N7743Y · Destroyed