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 SEA69D0060Accident · No injuriesClosedPiper PA-25 · Moses Lake, WAJul 19, 1968 · N6654Z · Destroyed NTSB SEA69D0037Accident · No injuriesClosedPiper PA-25 · Othello, WAJul 17, 1968 · N7561Z · Substantial damage NTSB SEA69D0033Accident · No injuriesClosedPiper PA-28 · Sekiu, WAJul 15, 1968 · N8819W · Substantial damage NTSB SEA68D0046Accident · Minor injuriesClosedCherokee II · Oroville, WAJul 15, 1968 · N7839C · Substantial damage NTSB SEA69D0036Accident · No injuriesClosedPiper PA-22 · Starbuck, WAJul 13, 1968 · N7222C · Substantial damage NTSB SEA69F0055Accident · Minor injuriesClosedPiper PA-22 · Vancouver, WAJul 9, 1968 · N9165D · Destroyed NTSB SEA69D0031Accident · No injuriesClosedCessna 172 · Ashford, WAJul 9, 1968 · N7392T · Substantial damage NTSB SEA69A0003Accident · 4 fatalClosedCessna 172H · Stehekin, WAJul 9, 1968 · N2854L · Destroyed NTSB SEA69D0069Accident · No injuriesClosedCessna 172 · Orchards, WAJul 8, 1968 · N1846Y · Substantial damage NTSB SEA69A0001Accident · 1 fatalClosedBeech 95-B55 · Eastsound, WAJul 4, 1968 · N6014F · Destroyed NTSB SEA69F0023Accident · Minor injuriesClosedCessna 188 · Dayton, WAJul 1, 1968 · N9775V · Substantial damage NTSB SEA69F0040Accident · Serious injuriesClosedPiper PA-28 · Friday Harbr, WAJun 23, 1968 · N6308R · Destroyed NTSB SEA69F0032Accident · No injuriesClosedSchweizer 2-22 · Issaquah, WAJun 23, 1968 · N2769R · Substantial damage NTSB SEA69D0021Accident · Minor injuriesClosedPiper J-3 · Kennewick, WAJun 23, 1968 · N87723 · Substantial damage NTSB SEA69D0012Accident · No injuriesClosedCessna 182 · Tacoma, WAJun 23, 1968 · N8491T · Substantial damage NTSB SEA69F0081CaseClosedPiper PA-28 · Westport, WAJun 18, 1968 · N8518W NTSB SEA69D0090Accident · No injuriesClosedBeech 35 · Neah Bay, WAJun 17, 1968 · N3940N · Substantial damage NTSB SEA69D0011Accident · No injuriesClosedBell 47G-2 · Grandview, WAJun 14, 1968 · N366D · Substantial damage NTSB SEA68D0326Accident · No injuriesClosedStinson 108-3 · Omak, WAJun 9, 1968 · N6822M · Substantial damage NTSB SEA69D0016Accident · No injuriesClosedBeech A23 · Vashon Is., WAJun 8, 1968 · N3507R · Substantial damage NTSB SEA69D0005Accident · No injuriesClosedCessna 195A · Omak, WAJun 7, 1968 · N1560D · Substantial damage NTSB SEA69D0004Accident · No injuriesClosedCessna 180 · Pasco, WAJun 6, 1968 · N6540A · Substantial damage NTSB SEA69D0014Accident · Minor injuriesClosedBell 47G-2 · Mineral, WAJun 5, 1968 · N2803B · Substantial damage NTSB SEA69D0013Accident · No injuriesClosedCessna 172 · Neah Bay, WAMay 31, 1968 · N3764F · Substantial damage NTSB SEA69F0001Accident · No injuriesClosedCessna 150 · Kent, WAMay 30, 1968 · N6260R · Substantial damage NTSB SEA68F0317Accident · No injuriesClosedCessna 310K · Spokane, WAMay 27, 1968 · N6922L · Substantial damage NTSB SEA68A0069Accident · 4 fatalClosedCessna 177 · Lester, WAMay 25, 1968 · N2966X · Destroyed NTSB SEA69F0030Accident · No injuriesClosedCessna 172 · Renton, WAMay 24, 1968 · N6374E · Substantial damage NTSB SEA68D0325Accident · No injuriesClosedAeronca 7AC · Edmonds, WAMay 18, 1968 · N83800 · Substantial damage NTSB SEA68F0324Accident · No injuriesClosedPiper PA-28 · Bellevue, WAMay 16, 1968 · N1861J · Substantial damage NTSB SEA68D0304Accident · No injuriesClosedCessna 172 · Ocean Shores, WAMay 15, 1968 · N8070X · Substantial damage NTSB SEA68D0320Accident · No injuriesClosedChampion 7GCAA · Spokane, WAMay 11, 1968 · N2568F · Substantial damage NTSB SEA68D0318Accident · No injuriesClosedAeronca 7AC · Deer Park, WAMay 11, 1968 · N2273E · Substantial damage NTSB SEA68D0316Accident · No injuriesClosedCessna 188 · Lancaster, WAMay 11, 1968 · N5507S · Substantial damage NTSB SEA68D0297Accident · No injuriesClosedBell 47G-2 · Mansfield, WAMay 10, 1968 · N6717D · Substantial damage NTSB SEA68D0323Accident · Minor injuriesClosedCessna 150 · Kent, WAMay 9, 1968 · N2299J · Substantial damage NTSB SEA68A0065Accident · 2 fatalClosedErco 415-D · Lynnwood, WAMay 4, 1968 · N3909H · Destroyed NTSB SEA68A0064Accident · 4 fatalClosedPiper PA-22 · Brush Prarie, WAApr 28, 1968 · N1738P · Destroyed NTSB SEA68D0294Accident · No injuriesClosedPiper PA-25 · Palouse, WAApr 27, 1968 · N6807Z · Substantial damage NTSB SEA68D0303Accident · No injuriesClosedBolkow 208 · Darrington, WAApr 26, 1968 · N909VW · Substantial damage NTSB SEA68D0296Accident · No injuriesClosedBell 47G-2 · Bridgeport, WAApr 24, 1968 · N6717D · Substantial damage NTSB SEA69F0015Accident · No injuriesClosedPiper L-4 · Shelton, WAApr 21, 1968 · N6445C · Substantial damage NTSB SEA68F0322Accident · Serious injuriesClosedCessna 140 · Auburn, WAApr 14, 1968 · N73027 · Destroyed NTSB SEA68D0287Accident · No injuriesClosedBeech B23 · Everett, WAApr 8, 1968 · N4710J · Substantial damage NTSB SEA68D0295Accident · No injuriesClosedCessna 172 · Ellensburg, WAApr 6, 1968 · N3743S · Substantial damage NTSB SEA68F0270Accident · Minor injuriesClosedPiper PA-25 · Colfax, WAApr 3, 1968 · N7118Z · Substantial damage NTSB SEA68A0062Accident · Serious injuriesClosedBoeing 727 · Yakima, WAApr 2, 1968 · N7407U · No damage NTSB SEA68F0286Accident · No injuriesClosedTaylorcraft BCS12D · Redmond, WAMar 31, 1968 · N95796 · Substantial damage NTSB SEA68D0281Accident · No injuriesClosedHughes 269A · Yakima, WAMar 31, 1968 · N8888F · Substantial damage NTSB SEA68D0277Accident · No injuriesClosedFairchild 24W · Ocean Shores, WAMar 30, 1968 · N1276N · Substantial damage