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 SEA66D0296Accident · No injuriesClosedPiper PA-24 · Brookings, ORApr 24, 1966 · N6817P · Substantial damage NTSB SEA66D0298Accident · No injuriesClosedCessna 150E · Mulino, ORApr 22, 1966 · N3012J · Substantial damage NTSB SEA66D0266Accident · No injuriesClosedAreonca 7AC · Harrisburg, ORApr 19, 1966 · N84745 · Substantial damage NTSB SEA66A0051Accident · 3 fatalClosedHughes 269B · Beaver, ORApr 19, 1966 · N9363F · Destroyed NTSB SEA66D0264Accident · No injuriesClosedLuscombe 8A · Klamathfalls, ORApr 17, 1966 · N45421 · Substantial damage NTSB SEA66D0292Accident · No injuriesClosedCessna 140 · Paisley, ORApr 15, 1966 · N3713V · Substantial damage NTSB SEA66F0281Accident · Minor injuriesClosedPiper PA-22 · Mitchell, ORApr 11, 1966 · N2729P · Destroyed NTSB SEA66F0274Accident · No injuriesClosedCessna 150 · Albany, ORApr 9, 1966 · N6767F · Substantial damage NTSB SEA66F0297Accident · No injuriesClosedGlobe Swift GC-1B · Mulino, ORApr 6, 1966 · N3366K · Substantial damage NTSB SEA66F0260Accident · No injuriesClosedStinson 108 · Pacific City, ORMar 31, 1966 · N97805 · Substantial damage NTSB SEA66F0261Accident · Minor injuriesClosedTravelair 4000 · Albany, ORMar 30, 1966 · N4834 · Destroyed NTSB SEA66F0287Accident · Minor injuriesClosedStinson L-5 · Wasco, ORMar 29, 1966 · N54920 · Substantial damage NTSB SEA66F0289Accident · No injuriesClosedPiper J5A · Redmond, ORMar 28, 1966 · N35774 · Substantial damage NTSB SEA66F0249Accident · No injuriesClosedBeech A23 · Eugene, ORMar 27, 1966 · N3558R · Substantial damage NTSB SEA66F0267Accident · No injuriesClosedPiper PA-23 · Portland, ORMar 23, 1966 · N4628P · Substantial damage NTSB SEA67F0026Accident · No injuriesClosedCessna 337 · Hillsboro, ORMar 21, 1966 · N6241F · Substantial damage NTSB SEA66D0229Accident · No injuriesClosedCessna 310 · Troutdale, ORMar 15, 1966 · N3028D · Substantial damage NTSB SEA66F0226Accident · No injuriesClosedPiper PA-25 · Hubbard, ORMar 10, 1966 · N7436Z · Substantial damage NTSB SEA66A0044Accident · Serious injuriesClosedHiller UH-12E · Heppner, ORFeb 24, 1966 · N9741C · Destroyed NTSB SEA66F0250Accident · No injuriesClosedMooney M20C · Beaverton, ORFeb 20, 1966 · N5631Q · Substantial damage NTSB SEA66D0228Accident · No injuriesClosedCessna 175 · Grants Pass, ORFeb 20, 1966 · N7329M · Substantial damage NTSB SEA66F0225Accident · No injuriesClosedCessna 182G · Springfield, ORFeb 17, 1966 · N2139R · Substantial damage NTSB SEA66D0214Accident · No injuriesClosedPiper PA-30 · Ontario, ORFeb 17, 1966 · N7190Y · Substantial damage NTSB SEA66F0230Accident · No injuriesClosedCessna 172 · Junction City, ORFeb 13, 1966 · N8454X · Substantial damage NTSB SEA66D0227Accident · No injuriesClosedPiper PA-22 · Paulina, ORFeb 9, 1966 · N9017D · Substantial damage NTSB SEA66A0043Accident · 4 fatalClosedCessna 175 · Bonneville, ORFeb 6, 1966 · N7067M · Destroyed NTSB SEA66F0204Accident · No injuriesClosedMaule M-4 · Beaverton, ORJan 25, 1966 · N12016 · Substantial damage NTSB SEA66F0221Accident · No injuriesClosedBeechcraft B35 · Warrenton, ORJan 22, 1966 · N5032C · Substantial damage NTSB SEA66D0206Accident · No injuriesClosedCessna 150 · Scappoose, ORJan 18, 1966 · N7024X · Substantial damage NTSB SEA66A0041Accident · 3 fatalClosedCessna 172E · Pistol River, ORJan 7, 1966 · N3535S · Destroyed NTSB SEA66A0039Accident · 1 fatalClosedCessna 170B · Pendleton, ORDec 30, 1965 · N2382D · Substantial damage NTSB SEA66A0040Accident · 4 fatalClosedPiper PA-30 · Ironside, ORDec 29, 1965 · N7675Y · Destroyed NTSB SEA66F0194Accident · Minor injuriesClosedStinson 108-1 · Springfield, ORDec 28, 1965 · N8641K · Substantial damage NTSB SEA66A0038Accident · Minor injuriesClosedSikorsky S-55 · Seaside, ORDec 22, 1965 · N73893 · Destroyed NTSB SEA66D0187Accident · No injuriesClosedPiper PA-22 · Eugene, ORDec 11, 1965 · N6956D · Substantial damage NTSB SEA66F0204Accident · No injuriesClosedPiper PA-22 · Scio, ORDec 10, 1965 · N9312D · Substantial damage NTSB SEA66A0036Accident · No injuriesClosedAir & Space 18A · Oakland, ORDec 8, 1965 · N6101S · Substantial damage NTSB SEA66D0186Accident · No injuriesClosedCessna 140 · Beaverton, ORDec 4, 1965 · N3701V · Substantial damage NTSB SEA66F0167Accident · No injuriesClosedCessna 150 · Mcminnville, ORNov 19, 1965 · N3091J · Substantial damage NTSB SEA66D0177Accident · No injuriesClosedBeechcraft B35 · Warrenton, ORNov 5, 1965 · N5032C · Substantial damage NTSB SEA66F0164Accident · Minor injuriesClosedCessna 172F · Springfield, ORNov 4, 1965 · N8467U · Substantial damage NTSB SEA66F0153Accident · Serious injuriesClosedCessna 195B · Imnaha, OROct 31, 1965 · N3090B · Destroyed NTSB SEA66F0154Accident · Serious injuriesClosedCessna 172 · Hermiston, OROct 26, 1965 · N3706S · Substantial damage NTSB SEA66F0174Accident · No injuriesClosedBeechcraft E35 · Adel, OROct 24, 1965 · N7328B · Destroyed NTSB SEA66F0165Accident · No injuriesClosedCessna 140A · Mulino, OROct 23, 1965 · N9695A · Substantial damage NTSB SEA66D0146Accident · Minor injuriesClosedCessna 175A · Wheeler, OROct 11, 1965 · N6760E · Substantial damage NTSB SEA66F0173Accident · Minor injuriesClosedBeechcraft M23 · Parkrose, OROct 10, 1965 · N8787M · Substantial damage NTSB SEA66A0020Accident · 2 fatalClosedConvair PBY-6A · Klamathfalls, OROct 4, 1965 · N6455C · Destroyed NTSB SEA66D0147Accident · Minor injuriesClosedPiper PA-22 · Ione, OROct 2, 1965 · N2924Z · Substantial damage NTSB SEA66D0160Accident · No injuriesClosedCessna 170 · Monument, OROct 1, 1965 · N3903V · Substantial damage