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 SEA65A0039Accident · No injuriesClosedHiller UH12E · Centerville, WAJan 12, 1965 · N5367V · Substantial damage NTSB UNK65X1265Accident · No injuriesClosedCessna 172 · Oses Lake, WAJan 10, 1965 · N4264F · Substantial damage NTSB UNK65X1252Accident · No injuriesClosedCessna 150 · Ellensburg, WAJan 8, 1965 · N7718E · Substantial damage NTSB UNK65X1183Accident · Serious injuriesClosedPiper PA-28 · North Bend, WADec 29, 1964 · N5812W · Substantial damage NTSB UNK65X1036Accident · No injuriesClosedPiper J3 · Birch Bay, WADec 17, 1964 · N92145 · Substantial damage NTSB UNK65X0907Accident · No injuriesClosedCessna 310 · Everett, WADec 3, 1964 · N4818B · Substantial damage NTSB UNK65X0881Accident · 4 fatalClosedBeechcraft S35 · Tacoma, WANov 29, 1964 · N5723K · Destroyed NTSB UNK65X0866Accident · Minor injuriesClosedCessna 195 · Morris Lake, WANov 28, 1964 · CF-GGM · Substantial damage NTSB UNK65X0818Accident · No injuriesClosedCessna 172 · Mesa, WANov 24, 1964 · N7362T · Destroyed NTSB UNK65X0777Accident · Minor injuriesClosedN American F51D · Enumclaw, WANov 21, 1964 · N7715C · Substantial damage NTSB UNK65X0580Accident · No injuriesClosedCessna 172 · Ellensburg, WANov 6, 1964 · N7545X · Destroyed NTSB UNK65X0474Accident · Minor injuriesClosedCessna 150 · Medical Lake, WAOct 29, 1964 · N7942E · Destroyed NTSB UNK65X0423Accident · No injuriesClosedPiper PA28 · Spokane, WAOct 25, 1964 · N6241W · Substantial damage NTSB UNK65X0398Accident · No injuriesClosedCessna 170B · Mesa, WAOct 24, 1964 · N2599D · Substantial damage NTSB UNK65X0367Accident · No injuriesClosedBeech F35 · Ocean Shores, WAOct 22, 1964 · N4218B · Substantial damage NTSB UNK65X0348Accident · No injuriesClosedPiper PA30 · Everett, WAOct 20, 1964 · N7048Y · Substantial damage NTSB UNK65X0328Accident · Minor injuriesClosedSchweizer 222E · Issaquah, WAOct 18, 1964 · N2769R · No damage NTSB UNK65X0211Accident · No injuriesClosedCessna 140A · Wheeler, WAOct 9, 1964 · N4052A · Substantial damage NTSB UNK65X0186Accident · No injuriesClosedCessna 140 · Camas, WAOct 7, 1964 · N76645 · No damage NTSB UNK65X0181Accident · No injuriesClosedPiper PA20 · Yakima, WAOct 7, 1964 · N7754K · Substantial damage NTSB UNK65X0143Accident · No injuriesClosedLuscombe 8E · Selah, WAOct 4, 1964 · N2728K · Substantial damage NTSB UNK65X0132Accident · 2 fatalClosedPiper PA-18 · Waterville, WAOct 3, 1964 · N7221K · Destroyed NTSB UNK64X4197Accident · Minor injuriesClosedPiper PA22 · Lynden, WASep 28, 1964 · N2334A · Substantial damage NTSB UNK64X4170Accident · No injuriesClosedBeechcraft D35 · Puyallup, WASep 26, 1964 · N2988B · Substantial damage NTSB UNK64X4155Accident · No injuriesClosedRyan STA · Whidbey Is, WASep 26, 1964 · N18923 · Substantial damage NTSB UNK64X4083Accident · No injuriesClosedBeechcraft C35 · Kelso, WASep 21, 1964 · N1877D · Substantial damage NTSB UNK64X4065Accident · No injuriesClosedPiper J5 · Oak Harbor, WASep 20, 1964 · N35021 · Substantial damage NTSB UNK64X4064Accident · No injuriesClosedPiper PA28 · Chehalis, WASep 20, 1964 · N8518W · Substantial damage NTSB UNK64X4005Accident · No injuriesClosedNavy N3N · Chelan Falls, WASep 16, 1964 · N44920 · Substantial damage NTSB UNK64X4002Accident · Minor injuriesClosedBeechcraft M23 · Tacoma, WASep 16, 1964 · N8706M · Destroyed NTSB SEA65A0025Accident · 2 fatalClosedBeechcraft 35 · Granite Fals, WASep 16, 1964 · N3070V · Destroyed NTSB UNK64X3940Accident · Minor injuriesClosedPiper J2 · Mt Wash, WASep 12, 1964 · N17540 · Substantial damage NTSB UNK64X3920Accident · No injuriesClosedPiper PA12 · Inchelium, WASep 11, 1964 · N2505M · Substantial damage NTSB UNK64X3897Accident · Minor injuriesClosedCessna 172 · Snohomish, WASep 10, 1964 · N8945B · Substantial damage NTSB UNK64X3791Accident · No injuriesClosedPiper PA18A · Tonasket, WASep 5, 1964 · N1870A · Substantial damage NTSB UNK64X3784Accident · No injuriesClosedCessna 120 · Vancouver, WASep 5, 1964 · N1782N · Substantial damage NTSB UNK64X3780Accident · No injuriesClosedBell 47G2 · Manson, WASep 4, 1964 · N3794G · Substantial damage NTSB UNK64X3758Accident · 1 fatalClosedBoeing A75 · Quincy, WASep 3, 1964 · N49385 · 2 aircraft · Substantial damage NTSB UNK64X3694Accident · 1 fatalClosedBeechcraft B-35 · Keyport, WAAug 30, 1964 · N5030C · Destroyed NTSB UNK64X3693Accident · No injuriesClosedHughes 269A · Redondo, WAAug 30, 1964 · N8792F · Destroyed NTSB UNK64X3679Accident · 1 fatalClosedCessna 150 · Renton, WAAug 29, 1964 · N516RA · Destroyed NTSB UNK64X3600Accident · No injuriesClosedCessna 182 · Seattle, WAAug 26, 1964 · N7122E · Substantial damage NTSB UNK64X3572Accident · No injuriesClosedCessna 140 · Tacoma, WAAug 24, 1964 · N3624V · Substantial damage NTSB UNK64X3560Accident · No injuriesClosedPiper PA24 · Stuart Is, WAAug 23, 1964 · N5293P · Substantial damage NTSB UNK64X3477Accident · No injuriesClosedCessna 172 · Kelso, WAAug 19, 1964 · N7045T · Substantial damage NTSB UNK64X3408Accident · Serious injuriesClosedCallair A6 · Sunnyside, WAAug 15, 1964 · N9997G · Destroyed NTSB UNK64X3357Accident · Minor injuriesClosedGrumman G164 · Touchet, WAAug 13, 1964 · N10269 · Substantial damage NTSB UNK64X3334Accident · No injuriesClosedBeechcraft M35 · Tekoa, WAAug 11, 1964 · N9769R · Substantial damage NTSB UNK64X3330Accident · No injuriesClosedRepublic RC3 · Seattle, WAAug 11, 1964 · N6401K · Destroyed NTSB UNK64X3325Incident · No injuriesClosedBell B-47G2 · Monitor, WAAug 11, 1964 · N2483B · No damage