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 SEA70DVQ08Accident · No injuriesClosedCessna 172 · Creswell, ORMay 23, 1970 · N7358A · Substantial damage NTSB SEA70DVQ06Accident · Minor injuriesClosedAeronca 7BCM · Ashland, ORMay 17, 1970 · N8362H · Destroyed NTSB SEA70AS043Accident · 7 fatalClosedBeech E18S · Joseph, ORMay 15, 1970 · N3621B · Destroyed NTSB SEA70AS042Accident · 1 fatalClosedMooney M10 · Wolf Creek, ORMay 11, 1970 · N9505V · Destroyed NTSB SEA70DVQ05Accident · No injuriesClosedBellanca 17-30 · Burns, ORMay 9, 1970 · N7329V · Destroyed NTSB SEA70FVQ04Accident · Minor injuriesClosedPiper PA-25 · Harrisburg, ORMay 7, 1970 · N7635Z · Destroyed NTSB SEA70DWA13Accident · No injuriesClosedPiper PA-28 · Alford, ORMay 5, 1970 · N9841W · Substantial damage NTSB SEA70FVQ03Accident · Serious injuriesClosedNavion A · Klamath Flls, ORMay 3, 1970 · N4408K · Substantial damage NTSB SEA70DWA14Accident · No injuriesClosedBell 47G3B1 · Cove, ORMay 3, 1970 · N73940 · Substantial damage NTSB SEA70DWA12Accident · Minor injuriesClosedPiper PA-22 · Monmouth, ORApr 11, 1970 · N1739P · Destroyed NTSB SEA70DVQ02Accident · No injuriesClosedHiller Acft UH-12E · Greenleaf, ORApr 4, 1970 · N5381V · Destroyed NTSB SEA70DWA11Accident · No injuriesClosedCessna 180 · Tangent, ORMar 30, 1970 · N2347C · Substantial damage NTSB SEA70DXM08Accident · No injuriesClosedCessna 150H · Lagrande, ORMar 15, 1970 · N22209 · Substantial damage NTSB SEA70DWA09Accident · No injuriesClosedCessna 320 · Creswell, ORMar 13, 1970 · N5777X · Substantial damage NTSB SEA70DWG04Accident · No injuriesClosedLuscombe 8F · Umapine, ORMar 9, 1970 · N1870B · Substantial damage NTSB SEA70DWA08Accident · No injuriesClosedCessna 150 · Newport, ORMar 9, 1970 · N60337 · Substantial damage NTSB SEA70DWA06Accident · No injuriesClosedHiller Acft FH1100 · Beaverton, ORMar 9, 1970 · N750FH · Substantial damage NTSB SEA70DWA07Accident · No injuriesClosedCessna 182 · Corvallis, ORMar 7, 1970 · N8837T · Substantial damage NTSB SEA70FVQ01Accident · No injuriesClosedLuscombe 11A · Bend, ORFeb 22, 1970 · N1615B · Substantial damage NTSB SEA70DWA05Accident · No injuriesClosedCessna 150 · Cottage Grve, ORFeb 22, 1970 · N3139J · Substantial damage NTSB SEA70DWA04Accident · No injuriesClosedCessna 182 · Hillsboro, ORFeb 8, 1970 · N3414R · Substantial damage NTSB SEA70DWA03Accident · Minor injuriesClosedPiper PA-28 · Redmond, ORFeb 7, 1970 · N4901L · Destroyed NTSB SEA70AS031Accident · Minor injuriesClosedCessna U206 · Cove, ORFeb 4, 1970 · N29142 · Substantial damage NTSB SEA70FWA02Accident · No injuriesClosedCessna 150F · Donald, ORFeb 1, 1970 · N8135S · Substantial damage NTSB SEA70D0151Accident · No injuriesClosedPiper PA-24 · Mulino, ORDec 31, 1969 · N6373P · Substantial damage NTSB SEA70D0127Accident · Minor injuriesClosedPiper PA-18 · Jordan Vally, ORDec 24, 1969 · N1858P · Substantial damage NTSB SEA70D0149Accident · No injuriesClosedCessna 150 · Cottage Grve, ORDec 22, 1969 · N6708S · Substantial damage NTSB SEA70D0145Accident · No injuriesClosedPiper PA-24 · Enterprise, ORDec 14, 1969 · N7760P · Substantial damage NTSB SEA70D0144Accident · No injuriesClosedAero Comdr 520 · Salem, ORDec 13, 1969 · N2622B · Substantial damage NTSB SEA70F0152Accident · No injuriesClosedCessna 175 · Malin, ORDec 1, 1969 · N7940T · Substantial damage NTSB SEA70A0023Accident · 5 fatalClosedCessna 310B · Miltn-Frewtr, ORDec 1, 1969 · N401T · Destroyed NTSB SEA70D0146Accident · No injuriesClosedCessna 182 · Prairie City, ORNov 26, 1969 · N7257E · Substantial damage NTSB SEA70A0020Accident · 2 fatalClosedPiper PA-22 · Scappoose, ORNov 14, 1969 · N1460A · Destroyed NTSB SEA70F0143Accident · Minor injuriesClosedCessna P206 · Independence, ORNov 10, 1969 · N2535X · Substantial damage NTSB SEA70D0142Accident · No injuriesClosedErcoupe 415C · Hillsboro, ORNov 7, 1969 · N2243H · Substantial damage NTSB SEA70F0140Accident · Serious injuriesClosedPiper PA-18 · Princeton, OROct 20, 1969 · N4372Z · Destroyed NTSB SEA70F0139Accident · Serious injuriesClosedCessna 150 · Millican, OROct 18, 1969 · N7163X · Destroyed NTSB SEA70A0016Accident · 3 fatalClosedPiper PA-24 · Newberg, OROct 17, 1969 · N7315P · Substantial damage NTSB SEA70D0148Accident · No injuriesClosedStinson SR-7C · Troutdale, OROct 12, 1969 · N16106 · Substantial damage NTSB SEA75AS015Accident · 1 fatalClosedBeech A35-33 · Oakridge, OROct 9, 1969 · N916B · Destroyed NTSB SEA70D0134Accident · No injuriesClosedHelio Acft H-391B · Reedsport, OROct 7, 1969 · N6025 · Substantial damage NTSB SEA70D0132Accident · No injuriesClosedCessna 195A · Vernonia, OROct 4, 1969 · N1042D · Destroyed NTSB SEA70F0131Accident · No injuriesClosedMooney M20E · Albany, ORSep 24, 1969 · N3232F · Substantial damage NTSB SEA70D0130Accident · No injuriesClosedCessna 170B · Agnes, ORSep 13, 1969 · N4359B · Substantial damage NTSB SEA70D0147Accident · No injuriesClosedBergfalke II-55 · Aurora, ORSep 7, 1969 · N5924 · Substantial damage NTSB SEA70D0125Accident · No injuriesClosedKaman Acft K-600 · Wolf Creek, ORSep 5, 1969 · N2855J · Destroyed NTSB SEA70F0074Accident · Serious injuriesClosedPiper PA-23 · Haines, ORSep 3, 1969 · N6076Y · Destroyed NTSB SEA70D0123Accident · No injuriesClosedCessna 140 · Roseburg, ORSep 2, 1969 · N76445 · Substantial damage NTSB SEA70F0093Accident · No injuriesClosedBeech A55 · Eugene, ORAug 25, 1969 · N9505Y · Substantial damage NTSB SEA70F0090Accident · Serious injuriesClosedPiper PA-22 · Halsey, ORAug 21, 1969 · N4782Z · Substantial damage