Skip to content

NTSB investigations, OR

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 SEA77DYK16Accident · No injuriesClosedBoeing PT-17 · Lakeview, ORJun 10, 1977 · N62394 · Destroyed NTSB SEA77FYK14Accident · No injuriesClosedCessna 172M · Days Creek, ORJun 8, 1977 · N4418Q · Substantial damage NTSB SEA77FA040Accident · 2 fatalClosedCessna 172 · Azalea, ORJun 8, 1977 · N73382 · Destroyed NTSB SEA77FYM37Accident · Serious injuriesClosedTailwind W8 · Albany, ORJun 5, 1977 · N9EG · Destroyed NTSB SEA77DYM38Accident · No injuriesClosedStinson 108 · Long Creek, ORJun 4, 1977 · N9043K · Substantial damage NTSB SEA77FA037Accident · 4 fatalClosedCessna T210G · Elgin, ORJun 1, 1977 · N6888R · Destroyed NTSB SEA77DYM36Accident · No injuriesClosedChampion 7GC · Grande Ronde, ORMay 30, 1977 · N8933R · Substantial damage NTSB SEA77DYK11Accident · No injuriesClosedTaylorcraft F19 · Chiloquin, ORMay 30, 1977 · N3586T · Substantial damage NTSB SEA77DYK10Accident · No injuriesClosedAeronca 7AC · Gold Beach, ORMay 30, 1977 · N83341 · Substantial damage NTSB SEA77FYK13Accident · No injuriesClosedLuscombe 8A · Creswell, ORMay 29, 1977 · N71725 · Substantial damage NTSB SEA77DYM34Accident · Serious injuriesClosedHiller Acft UH-12C · Albany, ORMay 28, 1977 · N8108H · Destroyed NTSB SEA77DYM33Accident · 1 fatalClosedPiper PA-22S · Madras, ORMay 28, 1977 · N2563P · No damage NTSB SEA77DYM35Accident · No injuriesClosedCessna 152 · Pendleton, ORMay 27, 1977 · N714UJ · Substantial damage NTSB UNK77X0105Accident · 1 fatalClosedBellanca 17-30A · Brightwood, ORMay 23, 1977 · N8866V · Destroyed NTSB SEA77FYK09Accident · No injuriesClosedCessna 182 · Sisters, ORMay 21, 1977 · N3118U · Substantial damage NTSB SEA77FYM32Accident · 1 fatalClosedCessna 150M · Independence, ORMay 20, 1977 · N704BK · Destroyed NTSB SEA77FYK08Accident · No injuriesClosedCessna 172 · Crescent Lake, ORMay 20, 1977 · N733XZ · Substantial damage NTSB SEA77FYK07Accident · Serious injuriesClosedAerostar 601P · Redmond, ORMay 17, 1977 · N90362 · Substantial damage NTSB SEA77FA032Accident · 4 fatalClosedPiper PA-23 · Ashland, ORMay 16, 1977 · N2175P · Destroyed NTSB SEA77FYK06Accident · No injuriesClosedCessna 182 · Burns, ORMay 14, 1977 · N3885D · 2 aircraft · Substantial damage NTSB SEA77FA029Accident · 2 fatalClosedCessna 172N · Newberg, ORMay 1, 1977 · N733VP · Destroyed NTSB SEA77DYK12Accident · No injuriesClosedBoeing D75N1 · Malin, ORMay 1, 1977 · N53179 · Substantial damage NTSB SEA77DYM30Accident · No injuriesClosedCallair A9 · Pilot Rock, ORApr 21, 1977 · N8267H · Substantial damage NTSB SEA77DYM27Accident · No injuriesClosedCessna 188B · Albany, ORApr 11, 1977 · N4918R · Substantial damage NTSB SEA77FYM25Accident · 1 fatalClosedMooney M20E · Toledo, ORApr 4, 1977 · N2659W · Destroyed NTSB SEA77DYM26Accident · Serious injuriesClosedTaylorcraft BC12-D · Lebanon, ORApr 3, 1977 · N43144 · Destroyed NTSB SEA77FYM24Accident · Serious injuriesClosedEnstrom 280C · Beaverton, ORMar 29, 1977 · N110VE · Destroyed NTSB SEA77DYM23Accident · Minor injuriesClosedEnstrom 28OC · N.Santiam Pass, ORMar 23, 1977 · N33RH · Substantial damage NTSB SEA77DYM22Accident · No injuriesClosedHarmon Stits · Oregon City, ORMar 21, 1977 · N219H · Substantial damage NTSB SEA77FYM21Accident · Minor injuriesClosedAeronca O-58B · Hillsboro, ORMar 19, 1977 · N48648 · Substantial damage NTSB SEA77DYK05Accident · No injuriesClosedPiper PA-22 · Denmark, ORMar 4, 1977 · N4739Z · Substantial damage NTSB SEA77FA020Accident · 2 fatalClosedPiper PA-24 · Eugene, ORMar 2, 1977 · N8216P · Destroyed NTSB SEA77DYM19Accident · No injuriesClosedCessna 188 · Hood River, ORFeb 15, 1977 · N9451G · Substantial damage NTSB SEA77FA017Accident · 1 fatalClosedPiper PA-23 · Moro, ORFeb 2, 1977 · N484G · Destroyed NTSB SEA77DYM18Accident · No injuriesClosedHiller Acft UH12D · Pendleton, ORJan 27, 1977 · N14490 · Substantial damage NTSB SEA77DYM17Accident · No injuriesClosedBeech 60 · Independence, ORJan 22, 1977 · N7320D · Substantial damage NTSB SEA77DYM16Accident · No injuriesClosedPiper PA-36 · Forest Grove, ORJan 20, 1977 · N9925P · Substantial damage NTSB SEA77DYM14Accident · No injuriesClosedCessna 182 · Waldport, ORJan 9, 1977 · N8720X · Substantial damage NTSB SEA77FYM13Accident · No injuriesClosedPiper PA-24 · Yamhill, ORJan 8, 1977 · N7364H · Substantial damage NTSB SEA77FYC12Accident · No injuriesClosedCessna TU206D · Farmington, ORDec 30, 1976 · N72160 · Substantial damage NTSB SEA77FYI03Accident · Minor injuriesClosedGrum Amer AA1-B · Medford, ORNov 30, 1976 · N9699L · Substantial damage NTSB SEA77DYI02Accident · Minor injuriesClosedAeronca 7AC · Bandon, ORNov 26, 1976 · N82041 · Substantial damage NTSB SEA77FA007Accident · 4 fatalClosedPiper PA-28R · Kimberly, ORNov 25, 1976 · N15634 · Destroyed NTSB SEA77DYC08Accident · No injuriesClosedLuscombe 8A · Mitchell, ORNov 25, 1976 · CF-VEX · Substantial damage NTSB SEA77FYC07Accident · No injuriesClosedCessna 150 · Sheridan, ORNov 18, 1976 · N3998U · Substantial damage NTSB SEA77DYC06Accident · No injuriesClosedCessna 172F · Baker, ORNov 14, 1976 · N8787U · Substantial damage NTSB SEA77FA005Accident · 2 fatalClosedCessna 172 · Pendleton, ORNov 9, 1976 · N5789A · Destroyed NTSB SEA77DYC09Accident · Minor injuriesClosedCessna 150 · Cornelius, ORNov 7, 1976 · N60855 · Substantial damage NTSB SEA77FYC05Accident · Minor injuriesClosedPiper PA-28 · Mulino, ORNov 6, 1976 · N95310 · Substantial damage NTSB SEA77FYC04Accident · No injuriesClosedFunk B85C · Portland, ORNov 4, 1976 · N77705 · Substantial damage