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 SEA71DWG40Accident · No injuriesClosedCessna 337 · Joseph, ORJan 31, 1971 · N86240 · Substantial damage NTSB SEA71FVQ18Accident · Serious injuriesClosedStinson 108-1 · Lorane, ORJan 28, 1971 · N8373K · Destroyed NTSB SEA71DWA27Accident · No injuriesClosedCessna 150 · Albany, ORJan 26, 1971 · N3625J · Substantial damage NTSB SEA71AS036Accident · 1 fatalClosedStinson 108-3 · Azalea, ORJan 23, 1971 · N6065M · Destroyed NTSB SEA71AS035Accident · 3 fatalClosedPiper PA-28 · Oakridge, ORJan 22, 1971 · N8373R · Destroyed NTSB SEA71FWA26Accident · Minor injuriesClosedCessna 172 · Oregon City, ORJan 1, 1971 · N8479U · Destroyed NTSB SEA71DVQ16Accident · No injuriesClosedBell 47G-2 · Sixes, ORDec 21, 1970 · N73284 · Substantial damage NTSB SEA71AS030Accident · 2 fatalClosedMooney M20E · Amity, ORDec 20, 1970 · N1983Y · Destroyed NTSB SEA71FWA25Accident · No injuriesClosedCessna 180 · Donald, ORDec 12, 1970 · N2392C · Substantial damage NTSB SEA71FWA24Accident · Serious injuriesClosedPiper PA-22 · Haines, ORNov 28, 1970 · N9184D · Substantial damage NTSB SEA71FVQ15Accident · Serious injuriesClosedPiper PA-28R · Bend, ORNov 22, 1970 · N3729T · Destroyed NTSB SEA71DWA23Accident · Serious injuriesClosedGlobe GC-1B · Pendleton, ORNov 14, 1970 · N2317B · Destroyed NTSB SEA71AS021Accident · 1 fatalClosedPiper PA-28R · Portland, OROct 9, 1970 · N5004S · Destroyed NTSB SEA71DWA21Accident · Minor injuriesClosedHughes 269B · Meacham, OROct 4, 1970 · N9354F · Destroyed NTSB SEA71DVQ08Accident · No injuriesClosedCessna 310J · Merrill, OROct 4, 1970 · N3009L · Substantial damage NTSB SEA71DVQ12Accident · No injuriesClosedCessna 172 · Lakeview, OROct 2, 1970 · N1823Y · Substantial damage NTSB SEA71DWA19Accident · No injuriesClosedErco 415-C · Wallowa, ORSep 27, 1970 · N99196 · Substantial damage NTSB SEA71AS014Accident · 3 fatalClosedBeech A23A · Medford, ORSep 13, 1970 · N2355W · Destroyed NTSB SEA71DWA16Accident · No injuriesClosedCessna 210 · Portland, ORSep 6, 1970 · N2301F · Substantial damage NTSB SEA71DVQ11Accident · Serious injuriesClosedCessna 172H · Ashland, ORSep 5, 1970 · N3783R · Destroyed NTSB SEA71DWA18Accident · Minor injuriesClosedCessna 150 · Gaston, ORAug 31, 1970 · N60306 · Substantial damage NTSB SEA71DVQ10Accident · No injuriesClosedPiper PA-32 · Alvord Ranch, ORAug 31, 1970 · N3221W · Substantial damage NTSB SEA71DVQ09Accident · No injuriesClosedPiper PA-20 · Klamath Flls, ORAug 31, 1970 · N7640K · Substantial damage NTSB SEA71AS011Accident · 1 fatalClosedCessna 172 · Agness, ORAug 26, 1970 · N79511 · Destroyed NTSB SEA71FWA14Accident · No injuriesClosedHelio Acft H-391B · Newberg, ORAug 21, 1970 · N17081 · Substantial damage NTSB SEA71FWA12Accident · 1 fatalClosedBoeing A75 · Hood River, ORAug 21, 1970 · N56628 · Destroyed NTSB SEA71FWA11Accident · Minor injuriesClosedMooney M20A · Grande Ronde, ORAug 14, 1970 · N8386E · Substantial damage NTSB SEA71FWA09Accident · No injuriesClosedBell 47G-4A · Estacada, ORAug 10, 1970 · N7939S · Substantial damage NTSB SEA71FVQ05Accident · No injuriesClosedPiper PA-22 · Junction Cty, ORAug 8, 1970 · N5210Z · Substantial damage NTSB SEA71DVQ06Accident · No injuriesClosedCessna 150 · Christmas V, ORAug 8, 1970 · N4024J · Substantial damage NTSB SEA71DWA10Accident · No injuriesClosedPiper PA-24 · Waldport, ORAug 7, 1970 · N5718P · Substantial damage NTSB SEA71DWD08Accident · No injuriesClosedSchweizer SGS233 · North Plains, ORAug 2, 1970 · N7761S · Substantial damage NTSB SEA71AS007Accident · 2 fatalClosedPiper PA-18 · Mitchell, ORAug 2, 1970 · N7663D · Destroyed NTSB SEA71FVQ04Accident · No injuriesClosedStinson 108-1 · Springfield, ORAug 1, 1970 · N97934 · Substantial damage NTSB SEA71AS005Accident · 2 fatalClosedCessna 150 · Gold Beach, ORJul 31, 1970 · N5878G · Destroyed NTSB SEA71DVQ03Accident · No injuriesClosedConvair PB4Y-2 · Diamond Lake, ORJul 27, 1970 · N3191G · Substantial damage NTSB SEA71FVQ01Accident · Minor injuriesClosedCessna 170 · Redmond, ORJul 17, 1970 · N9571A · Destroyed NTSB SEA71AS002Accident · No injuriesClosedCessna 182A · Glendale, ORJul 14, 1970 · N2018G · Substantial damage NTSB SEA71DXM04Accident · No injuriesClosedCessna 182E · Vale, ORJul 12, 1970 · N9359X · Substantial damage NTSB SEA71DWA05Accident · No injuriesClosedHiller Acft UH-12A · Maupin, ORJul 11, 1970 · N8180H · Substantial damage NTSB SEA71DWA03Accident · No injuriesClosedPiper PA-24 · Cove, ORJul 5, 1970 · N6256P · Substantial damage NTSB SEA71FWA01Accident · Serious injuriesClosedAeronca 7GCB · Hillsboro, ORJul 4, 1970 · N9915Y · Destroyed NTSB SEA71DWA02Accident · Minor injuriesClosedPiper PA-28 · Halfway, ORJul 2, 1970 · N7049R · Substantial damage NTSB SEA70FWA16Accident · No injuriesClosedHughes 269A · St Johns, ORJun 20, 1970 · N8737F · Substantial damage NTSB SEA70FXM19Accident · Serious injuriesClosedPiper PA-25 · Ontario, ORJun 17, 1970 · N7749Z · Destroyed NTSB SEA70AS047Accident · 3 fatalClosedMeyers OTW · Scappoose, ORJun 14, 1970 · N34324 · 2 aircraft · Destroyed NTSB SEA70AS046Accident · 2 fatalClosedCessna 150J · Lacomb, ORJun 8, 1970 · N51325 · Destroyed NTSB OAK70DVG26Accident · No injuriesClosedBoeing A75-N1 · Merrill, ORJun 4, 1970 · N65680 · Destroyed NTSB SEA70FWA15Accident · Minor injuriesClosedHiller Acft UH-12E · Bridgeport, ORJun 2, 1970 · N5387V · Destroyed NTSB SEA70DVQ09Accident · No injuriesClosedPiper PA-32 · Mckenzie Br., ORMay 25, 1970 · N4171R · Substantial damage