Skip to content

NTSB investigations, OR

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 SEA66D0144Accident · No injuriesClosedPiper PA-18 · Malin, ORSep 24, 1965 · N3568P · Substantial damage NTSB SEA66A0023Accident · No injuriesClosedHughes 269B · Enterprise, ORSep 23, 1965 · N9426F · Substantial damage NTSB SEA66F0143Accident · No injuriesClosedPiper PA-22 · Culver, ORSep 16, 1965 · N1892P · Substantial damage NTSB SEA66D0129Accident · Minor injuriesClosedCessna 172 · Condon, ORSep 15, 1965 · N8872U · Substantial damage NTSB SEA66F0133Accident · Minor injuriesClosedPiper PA-30 · Hillsboro, ORSep 14, 1965 · N246NW · Destroyed NTSB SEA66F0125Accident · No injuriesClosedPiper PA-16 · Salem, ORSep 12, 1965 · N5995H · Substantial damage NTSB SEA66F0124Accident · Serious injuriesClosedEcessna 120 · Mckenzie Brge, ORSep 5, 1965 · N3139N · Destroyed NTSB SEA66F0118Accident · No injuriesClosedCessna 182 · Baker, ORSep 4, 1965 · N5335B · Substantial damage NTSB SEA66F0120Accident · Serious injuriesClosedPiper PA-22 · Beavercreek, ORAug 31, 1965 · N4769Z · Destroyed NTSB SEA66F0121Accident · No injuriesClosedAeronca 7AC · Springfield, ORAug 29, 1965 · N1838E · Substantial damage NTSB SEA66A0018Accident · 2 fatalClosedCessna 182 · Prineville, ORAug 27, 1965 · N2905Y · Destroyed NTSB SEA66F0116Accident · No injuriesClosedCessna 180 · Prairie City, ORAug 22, 1965 · N2956C · Destroyed NTSB SEA66F0112Accident · Minor injuriesClosedPiper PA-22 · Beaver Creek, ORAug 21, 1965 · N3935P · Substantial damage NTSB SEA66A0013Accident · No injuriesClosedHiller UH12E · Crowley, ORAug 16, 1965 · N5341V · Substantial damage NTSB SEA66A0015Accident · No injuriesClosedHughes 269A · Delake, ORAug 15, 1965 · N8762F · Substantial damage NTSB SEA66D0111Accident · No injuriesClosedWaco YKS-7 · Klamath Falls, ORAug 12, 1965 · N19376 · Substantial damage NTSB SEA66A0011Accident · No injuriesClosedCurtiss C-46A · Salem, ORAug 12, 1965 · N7769B · Substantial damage NTSB SEA66D0113Accident · No injuriesClosedPiper PA-28 · Aurora, ORAug 6, 1965 · N5805W · Substantial damage NTSB SEA66F0108Accident · Minor injuriesClosedMooney M20C · Troutdale, ORAug 5, 1965 · N78942 · Substantial damage NTSB SEA66F0107Accident · No injuriesClosedBeechcraft C-45G · Cave Junctn, ORJul 26, 1965 · N248GB · Substantial damage NTSB SEA66D0106Accident · Minor injuriesClosedWaco UPF-7 · Ashland, ORJul 21, 1965 · N32023 · Destroyed NTSB SEA66F0075Accident · No injuriesClosedCessna 180 · Medford, ORJul 14, 1965 · N9352C · Substantial damage NTSB SEA66F0083Accident · No injuriesClosedCessna 150E · Halsey, ORJul 11, 1965 · N2508J · Substantial damage NTSB SEA66F0073Accident · No injuriesClosedAeronca 7ECA · Eugene, ORJul 10, 1965 · N11093 · Substantial damage NTSB SEA66F0097Accident · No injuriesClosedMooney M20A · Roseburg, ORJul 3, 1965 · N8114E · Substantial damage NTSB SEA66F0087Accident · Serious injuriesClosedPiper PA-18A · Mosier, ORJun 23, 1965 · N3792P · Destroyed NTSB SEA66F0051Accident · No injuriesClosedCessna 182 · Grants Pass, ORJun 22, 1965 · N5856B · Substantial damage NTSB SEA66F0050Accident · No injuriesClosedBoeing A75N1 · Merrill, ORJun 19, 1965 · N63702 · Destroyed NTSB SEA66F0042Accident · No injuriesClosedCessna 170B · Hood River, ORJun 19, 1965 · CF-RQU · Substantial damage NTSB SEA66F0062Accident · No injuriesClosedCallair A-6 · Lakeview, ORJun 13, 1965 · N2907G · Substantial damage NTSB SEA66F0029Accident · No injuriesClosedBeechcraft A-23 · Harrisburg, ORJun 13, 1965 · N8873M · Substantial damage NTSB SEA65F0070Accident · Serious injuriesClosedPiper PA16 · Owyheereservo, ORJun 7, 1965 · N5239H · Destroyed NTSB SEA65F0073Accident · Minor injuriesClosedStinson 108-2 · Oregon City, ORJun 4, 1965 · N893D · Destroyed NTSB SEA66F0023Accident · Serious injuriesClosedPiper PA-18A · Sisters, ORJun 1, 1965 · N8983D · Destroyed NTSB SEA66F0016Accident · Serious injuriesClosedPiper PA30 · Mckenzie Brij, ORMay 31, 1965 · N7466Y · Destroyed NTSB SEA66F0015Accident · Minor injuriesClosedPiper PA-18A · Mt Angel, ORMay 28, 1965 · N8782D · Destroyed NTSB SEA66F0011Accident · Minor injuriesClosedSchweizer 2-22E · Eugene, ORMay 28, 1965 · N8691R · Substantial damage NTSB SEA65F0055Accident · Minor injuriesClosedBoeing E-75 · Elgin, ORMay 24, 1965 · N1181N · Destroyed NTSB SEA66F0045Accident · Minor injuriesClosedPiper PA-18A · Culver, ORMay 19, 1965 · N8568D · Destroyed NTSB SEA66F0014Accident · Minor injuriesClosedTaylorcraft BC-12D · Madras, ORMay 15, 1965 · N43669 · Substantial damage NTSB SEA65D0060Accident · No injuriesClosedFairchild W62M · Adrian, ORMay 11, 1965 · N56110 · No damage NTSB SEA65F0074Accident · No injuriesClosedPiper PA-22 · Albany, ORMay 5, 1965 · N5398Z · Substantial damage NTSB SEA65F0063Accident · Minor injuriesClosedMooney M20C · Klamath Falls, ORMay 2, 1965 · N6241U · Substantial damage NTSB SEA65D0054Accident · No injuriesClosedCessna 170B · Nyssa, ORApr 26, 1965 · N2513D · Substantial damage NTSB SEA65A0058Accident · 3 fatalClosedHiller UH-12E · Hood River, ORApr 26, 1965 · N5355V · Destroyed NTSB SEA66D0005Accident · No injuriesClosedPiper PA-22 · Helix, ORApr 25, 1965 · N4533A · Substantial damage NTSB SEA65F0047Accident · No injuriesClosedPiper PA-22 · Troutdale, ORApr 25, 1965 · N9740D · Substantial damage NTSB SEA65F0044Accident · No injuriesClosedPiper PA-28 · Nyssa, ORApr 25, 1965 · N8574W · Substantial damage NTSB SEA65A0056Accident · 2 fatalClosedBeechcraft S35 · Mill City, ORApr 23, 1965 · N6825Q · Destroyed NTSB SEA65F0051Accident · Serious injuriesClosedCessna 172 · Newberg, ORApr 20, 1965 · N7140T · Destroyed