Skip to content

NTSB investigations, WA

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" = 'WA' 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\" = 'WA' 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" = 'WA' 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 SEA67D0174Accident · No injuriesClosedPiper PA-24 · Touchet, WANov 6, 1966 · N5070P · Substantial damage NTSB SEA67F0179Accident · No injuriesClosedBeech G35 · Spokane, WANov 5, 1966 · N4501D · Substantial damage NTSB SEA67D0183Accident · No injuriesClosedPiper PA-16 · College Plce, WAOct 27, 1966 · N5944H · Substantial damage NTSB SEA67D0173Accident · No injuriesClosedMooney M21 · Walla Walla, WAOct 27, 1966 · N6852U · Substantial damage NTSB SEA66D0166Accident · No injuriesClosedPiper PA-25 · Pasco, WAOct 22, 1966 · N6049Z · Substantial damage NTSB SEA67D0211Accident · No injuriesClosedCessna 310J · Everett, WAOct 13, 1966 · N3116L · Destroyed NTSB SEA67A0031Accident · No injuriesClosedBell 47G · Tonasket, WAOct 12, 1966 · N979B · Substantial damage NTSB SEA67D0145Accident · No injuriesClosedPiper PA-18 · Coulee City, WAOct 11, 1966 · N1883P · Substantial damage NTSB SEA67A0032Accident · No injuriesClosedBell 47D1 · Llensburg, WAOct 11, 1966 · N162B · Substantial damage NTSB SEA67D0210Accident · No injuriesClosedCessna 172 · Seattle, WAOct 9, 1966 · N8533B · Substantial damage NTSB SEA67D0209Accident · No injuriesClosedCessna 150 · Bellvue, WAOct 8, 1966 · N4146U · Substantial damage NTSB SEA67D0176Accident · No injuriesClosedPiper PA-32 · College Pl., WAOct 8, 1966 · N3497W · Substantial damage NTSB SEA67A0036Accident · No injuriesClosedBell 47G3B1 · Cle Elum, WAOct 8, 1966 · N8518F · Substantial damage NTSB SEA67D0208Accident · No injuriesClosedPiper PA-24 · Friday Harb., WAOct 2, 1966 · N8974P · Substantial damage NTSB LAX67A0035Accident · 4 fatalClosedBeech A35 · Seattle, WAOct 2, 1966 · N728B · Destroyed NTSB SEA67D0140Accident · No injuriesClosedCessna 182 · Moses Lake, WASep 20, 1966 · N2934F · Substantial damage NTSB SEA67D0160Accident · No injuriesClosedPiper PA-14 · Starbuck, WASep 19, 1966 · N5145H · Substantial damage NTSB SEA67D0149Accident · No injuriesClosedCessna 172 · Puyallup, WASep 19, 1966 · N5757R · Substantial damage NTSB SEA67D0155Accident · No injuriesClosedCessna 172 · Snohomish, WASep 13, 1966 · N5789R · Substantial damage NTSB SEA67D0113Accident · No injuriesClosedCessna 180 · Ellensburg, WASep 13, 1966 · N8214V · Substantial damage NTSB SEA67D0136Accident · No injuriesClosedPiper PA-25 · Quincy, WASep 12, 1966 · N6034Z · Substantial damage NTSB SEA67D0151Accident · No injuriesClosedCessna 175 · Bellevue, WASep 7, 1966 · N7272M · Substantial damage NTSB SEA67A0021Accident · 2 fatalClosedGlobe GC-1B · Woodinville, WASep 7, 1966 · N80785 · Destroyed NTSB SEA67F0109Accident · Minor injuriesClosedCessna 140 · Walla Walla, WASep 4, 1966 · N2222N · Substantial damage NTSB UNK66X0169AccidentClosedBeech G35 · Seattle, WASep 1, 1966 · N45590 · Substantial damage NTSB SEA67D0150Accident · No injuriesClosedAeronca 7AC · Auburn, WASep 1, 1966 · N2004E · Substantial damage NTSB SEA67F0106Accident · No injuriesClosedMooney M20B · Richland, WAAug 28, 1966 · N74545 · Substantial damage NTSB SEA67A0018Accident · No injuriesClosedBensen B8M · Richland, WAAug 27, 1966 · N68682 · Substantial damage NTSB SEA67F0163Accident · No injuriesClosedGlobe GC-1B · Vancouver, WAAug 21, 1966 · N80649 · Substantial damage NTSB SEA67D0153Accident · No injuriesClosedBeech J35 · Fri. Harbor, WAAug 21, 1966 · N3053C · Substantial damage NTSB SEA67D0103Accident · No injuriesClosedMooney M-18 · Easton, WAAug 21, 1966 · N4180 · Substantial damage NTSB SEA67A0016Accident · 2 fatalClosedFairchild M-62C · Bellingham, WAAug 21, 1966 · N58737 · Substantial damage NTSB SEA67F0099Accident · No injuriesClosedBoeing A75N1 · Sunnyside, WAAug 16, 1966 · N1153N · Substantial damage NTSB SEA67A0013Accident · 2 fatalClosedNavion A · Enumclaw, WAAug 14, 1966 · CF-GIZ · Destroyed NTSB SEA67D0124Accident · No injuriesClosedCessna 182 · Tacoma, WAAug 12, 1966 · N2371R · Substantial damage NTSB SEA67F0114Accident · Minor injuriesClosedNaval Fcty N3N-3 · Wapato, WAAug 9, 1966 · N45178 · Destroyed NTSB SEA67F0156Accident · Serious injuriesClosedInterstate S-1A · Pt.Townsend, WAAug 7, 1966 · N37236 · Destroyed NTSB SEA67D0152Accident · No injuriesClosedBeech S-35 · Hehalis, WAAug 7, 1966 · N216Q · Substantial damage NTSB SEA67A0011Accident · Minor injuriesClosedBell 47J-2A · Darrington, WAAug 7, 1966 · N251PH · Destroyed NTSB SEA67F0095Accident · No injuriesClosedPiper PA-12 · Cle Elum, WAAug 6, 1966 · N98903 · Substantial damage NTSB SEA67D0097Accident · No injuriesClosedPiper PA-22 · Mead, WAAug 2, 1966 · N1315C · Substantial damage NTSB SEA67D0154Accident · No injuriesClosedStinson 108 · Orcas Island, WAJul 31, 1966 · N8200K · Substantial damage NTSB SEA67D0127Accident · No injuriesClosedWaco UKC · Puyallup, WAJul 30, 1966 · N16967 · Substantial damage NTSB SEA67A0008Accident · No injuriesClosedCessna 182A · Sekiu, WAJul 29, 1966 · N5906B · Substantial damage NTSB SEA67D0093Accident · No injuriesClosedBeech 35 · Royal City, WAJul 28, 1966 · N5001C · Substantial damage NTSB SEA67F0125Accident · No injuriesClosedLuscombe 11A · Bellevue, WAJul 24, 1966 · N1648B · Substantial damage NTSB SEA67D0206Accident · No injuriesClosedCessna 182 · Georgetown, WAJul 22, 1966 · N182Y · Substantial damage NTSB SEA67D0065Accident · No injuriesClosedBoeing A75 · Brownstown, WAJul 20, 1966 · N49285 · Substantial damage NTSB SEA67D0122Accident · No injuriesClosedCessna 195 · Snohomish, WAJul 18, 1966 · N3482V · Substantial damage NTSB SEA67D0123Accident · No injuriesClosedCessna 182 · Whidbey Isle, WAJul 17, 1966 · N5111D · Substantial damage