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 SEA74FYC07Accident · No injuriesClosedMooney M20H · Silverton, ORAug 4, 1973 · N6570B · Substantial damage NTSB SEA74FYA06Accident · No injuriesClosedErco 415-C · Jordan Vly, ORAug 1, 1973 · N2129H · Substantial damage NTSB SEA74FYC04Accident · No injuriesClosedPiper PA-28R · Yamhill, ORJul 29, 1973 · N3961T · Substantial damage NTSB SEA74FYI06Accident · No injuriesClosedCessna 140 · Klamath Fals, ORJul 28, 1973 · N72166 · Substantial damage NTSB SEA74AS005Accident · 2 fatalClosedCessna 177 · Prospect, ORJul 28, 1973 · N29472 · Destroyed NTSB SEA74AS004Accident · 2 fatalClosedCessna 175C · Pacific City, ORJul 24, 1973 · N8318T · Destroyed NTSB SEA74DYI03Accident · Minor injuriesClosedFlybaby · Bandon, ORJul 21, 1973 · N1432 · Substantial damage NTSB SEA74DYI02Accident · No injuriesClosedCessna 150J · Rogue River, ORJul 20, 1973 · N50566 · Substantial damage NTSB SEA74DYA04Accident · Serious injuriesClosedPiper PA-28 · Ironside, ORJul 20, 1973 · N7259W · Substantial damage NTSB SEA74FYI05Accident · Minor injuriesClosedBoeing PT-17 · Malin, ORJul 19, 1973 · N56941 · Substantial damage NTSB SEA74AS001Accident · 1 fatalClosedPiper PA-18 · Metolius, ORJul 15, 1973 · N1758P · Destroyed NTSB SEA74DYI01Accident · No injuriesClosedHiller FH1100 · Cave Jctn, ORJul 9, 1973 · N427FH · Substantial damage NTSB SEA74FYC01Accident · Serious injuriesClosedStory MK-7 · Monmouth, ORJul 1, 1973 · N1269 · Substantial damage NTSB SEA73AS040Accident · 3 fatalClosedPiper PA-28R · Eugene, ORJun 25, 1973 · N3841T · Destroyed NTSB SEA74DYC02Accident · No injuriesClosedCessna 310 · Hillsboro, ORJun 24, 1973 · N2661C · Substantial damage NTSB SEA73DYC39Accident · Minor injuriesClosedCessna 150G · Brightwood, ORJun 23, 1973 · N84685 · Destroyed NTSB SEA74DYI04Accident · No injuriesClosedPiper PA-25 · Burns, ORJun 22, 1973 · N7374Z · Substantial damage NTSB SEA73FYC38Accident · No injuriesClosedCessna 210D · Lagrande, ORJun 22, 1973 · N3823Y · Substantial damage NTSB SEA73FYC37Accident · Serious injuriesClosedBell 47G-3B · Warm Springs, ORJun 21, 1973 · N1324X · Destroyed NTSB SEA73AS037Accident · 2 fatalClosedAeronca O-58B · Riddle, ORJun 21, 1973 · N48661 · Destroyed NTSB SEA73DYC35Accident · No injuriesClosedPiper PA-28R · Elgin, ORJun 16, 1973 · N9456N · Substantial damage NTSB SEA73FYC36Accident · No injuriesClosedPiper PA-30 · Salem, ORJun 12, 1973 · N8392Y · Substantial damage NTSB SEA73DYC33Accident · No injuriesClosedCessna 182 · Sandy, ORJun 9, 1973 · N2324X · Substantial damage NTSB SEA73FYC32Accident · Minor injuriesClosedCessna 150F · Oregon City, ORJun 7, 1973 · N8814G · Substantial damage NTSB SEA73DYI16Accident · No injuriesClosedBoeing A75 · Marlin, ORJun 6, 1973 · N5522N · Substantial damage NTSB SEA73DYC34Accident · No injuriesClosedPiper PA-12 · Sandy, ORJun 6, 1973 · N7754H · Substantial damage NTSB SEA73DYI17Accident · Serious injuriesClosedJeanie Teenie · Central Pt, ORJun 3, 1973 · N1348 · Destroyed NTSB SEA73DYI15Accident · No injuriesClosedMooney M20E · Bend, ORJun 1, 1973 · N6699R · Substantial damage NTSB SEA73FYC30Accident · Serious injuriesClosedCessna 140 · Sisters, ORMay 28, 1973 · N2051N · Destroyed NTSB SEA73DYC31Accident · No injuriesClosedCessna 150 · Salem, ORMay 28, 1973 · N21986 · Substantial damage NTSB SEA73AS034Accident · 6 fatalClosedCessna T310Q · Cottage Grve, ORMay 26, 1973 · N7514Q · Destroyed NTSB SEA73DYI14Accident · No injuriesClosedBoeing E75 · Klamath Fall, ORMay 24, 1973 · N4742V · Substantial damage NTSB SEA74DYC28Accident · No injuriesClosedPiper PA-30 · Mulino, ORMay 23, 1973 · N8668Y · Substantial damage NTSB SEA73FYA26Accident · Serious injuriesClosedPiper PA-22 · Nyssa, ORMay 18, 1973 · N2316P · Substantial damage NTSB SEA73AS032Accident · 1 fatalClosedChampion 7GCB · North Plains, ORMay 16, 1973 · N9915Y · Destroyed NTSB SEA73DYC28Accident · No injuriesClosedCessna 172G · Madras, ORMay 8, 1973 · N4156L · Substantial damage NTSB SEA73DYC27Accident · No injuriesClosedPiper PA-22 · Portland, ORApr 21, 1973 · N7244D · Substantial damage NTSB SEA73DYC25Accident · No injuriesClosedStinson 108 · The Dalles, ORApr 21, 1973 · N9019K · Substantial damage NTSB SEA73FYC26Accident · Serious injuriesClosedPiper PA-22 · Oregon City, ORApr 18, 1973 · N8155D · Substantial damage NTSB SEA73FYC24Accident · No injuriesClosedKaman K-600 · Pilot Rock, ORApr 11, 1973 · N11012 · Substantial damage NTSB SEA73DYI13Accident · Minor injuriesClosedCessna 170A · Bandon, ORApr 8, 1973 · N9270A · Substantial damage NTSB SEA73DYA21Accident · No injuriesClosedLuscombe 8E · Jordan Vally, ORApr 6, 1973 · N1684K · Substantial damage NTSB SEA73DYC23Accident · No injuriesClosedCallair A-9B · Helix, ORMar 23, 1973 · N265GC · Substantial damage NTSB SEA73FYC22Accident · No injuriesClosedCessna 180 · Sheridan, ORMar 21, 1973 · N1787C · Substantial damage NTSB SEA73FYC21Accident · No injuriesClosedCallair A-9B · Helix, ORMar 8, 1973 · N7607V · Substantial damage NTSB SEA73FYI12Accident · No injuriesClosedCessna 150 · Roseburg, ORMar 6, 1973 · N6561G · Substantial damage NTSB SEA73FYC20Accident · No injuriesClosedStarduster SA-200 · Salem, ORMar 3, 1973 · N6275 · Substantial damage NTSB SEA73DYC19Accident · Serious injuriesClosedMooney M20E · Govt.Camp, ORMar 1, 1973 · N1284X · Substantial damage NTSB SEA73FYI11Accident · Serious injuriesClosedCessna 120 · Norway, ORFeb 18, 1973 · N1805V · Substantial damage NTSB SEA73AS022Accident · 1 fatalClosedCessna 150L · Estacada, ORFeb 11, 1973 · N5333Q · Destroyed