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 SEA68F0072Accident · No injuriesClosedPiper J-3 · Bellevue, WAJun 17, 1967 · N7291H · Substantial damage NTSB SEA68F0044Accident · No injuriesClosedCessna 180 · Orchards, WAJun 15, 1967 · N2468C · Substantial damage NTSB SEA68F0020Accident · No injuriesClosedCessna 310 · Wenatchee, WAJun 14, 1967 · N2970G · Substantial damage NTSB SEA68D0014Accident · No injuriesClosedPiper PA-28 · Mesa, WAJun 13, 1967 · N9507J · Substantial damage NTSB SEA68D0004Accident · No injuriesClosedPiper PA-25 · Pasco, WAJun 13, 1967 · N6375Z · Substantial damage NTSB SEA68D0013Accident · Minor injuriesClosedPiper PA-25 · Royal City, WAJun 12, 1967 · N4566Y · Substantial damage NTSB SEA68D0057Accident · No injuriesClosedTaylorcraft BC-12 · Kelso, WAJun 11, 1967 · N96896 · Substantial damage NTSB SEA68F0008Accident · No injuriesClosedPiper PA-20A · Newport, WAJun 9, 1967 · N2338A · Substantial damage NTSB SEA68D0056Accident · No injuriesClosedCessna 150 · Renton, WAJun 9, 1967 · N8799S · Substantial damage NTSB SEA67D0359Accident · No injuriesClosedPiper PA-25 · Quincy, WAJun 9, 1967 · N6354Z · Substantial damage NTSB SEA67F0360Accident · No injuriesClosedCessna 182 · Mead, WAJun 8, 1967 · N3288U · Substantial damage NTSB SEA67F0357Accident · No injuriesClosedPiper PA-25 · Spokane, WAJun 5, 1967 · N7597Z · Substantial damage NTSB SEA68D0003Accident · No injuriesClosedErco 415-C · Walla Walla, WAJun 2, 1967 · N99899 · Substantial damage NTSB SEA67A0071Accident · No injuriesClosedBell 47G-2 · Kennewick, WAJun 1, 1967 · N6145C · Substantial damage NTSB SEA67D0346Accident · No injuriesClosedStinson 10A · Inehelium, WAMay 31, 1967 · N36765 · Substantial damage NTSB SEA68F0032Accident · No injuriesClosedBeech 95-C55 · Anacortes, WAMay 29, 1967 · N145TB · Substantial damage NTSB SEA67A0069Accident · No injuriesClosedBell 47G-2 · Yakima, WAMay 29, 1967 · N7891B · Substantial damage NTSB SEA67D0354Accident · No injuriesClosedPiper PA-25 · Thornton, WAMay 21, 1967 · N6106Z · Destroyed NTSB SEA67F0339Accident · No injuriesClosedCessna 182 · Spokane, WAMay 20, 1967 · N6193B · Substantial damage NTSB SEA67F0335Accident · No injuriesClosedPiper PA-18 · Quincy, WAMay 19, 1967 · N3783Z · Substantial damage NTSB SEA67D0330Accident · No injuriesClosedPiper PA-25 · Palouse, WAMay 19, 1967 · N6807Z · Substantial damage NTSB SEA67F0313Accident · No injuriesClosedCessna 180 · Spokane, WAMay 18, 1967 · N8640X · Substantial damage NTSB SEA67D0347Accident · Minor injuriesClosedCallair A-6 · Outlook, WAMay 18, 1967 · N2918G · Destroyed NTSB SEA67D0344Accident · No injuriesClosedCessna 182 · Othello, WAMay 18, 1967 · N3359F · Substantial damage NTSB SEA67D0331Accident · No injuriesClosedPiper PA-23 · Kennewick, WAMay 18, 1967 · N5834Y · Substantial damage NTSB SEA68D0031Accident · No injuriesClosedCessna 182 · Kent, WAMay 15, 1967 · N3115S · Substantial damage NTSB SEA67F0333Accident · Minor injuriesClosedCallair A-9B · Lind, WAMay 14, 1967 · N7258V · Substantial damage NTSB SEA67F0332Accident · No injuriesClosedCallair A-9B · Lind, WAMay 13, 1967 · N265GC · Substantial damage NTSB SEA68F0030Accident · Minor injuriesClosedPiper PA-28 · Nortgat Mall, WAMay 12, 1967 · N4102J · Substantial damage NTSB SEA67D0321Accident · No injuriesClosedCessna 205 · Othello, WAMay 10, 1967 · N8457Z · Substantial damage NTSB SEA67A0063Accident · 1 fatalClosedCessna 150 · Bremerton, WAMay 8, 1967 · N7077F · Destroyed NTSB SEA67D0304Accident · Minor injuriesClosedCessna 172 · Zillah, WAMay 4, 1967 · N6019R · Substantial damage NTSB SEA68F0029Accident · No injuriesClosedLake LA-4 · Renton, WAApr 28, 1967 · N2012L · Substantial damage NTSB SEA67F0342Accident · Minor injuriesClosedBoeing A75N1 · Lind, WAApr 28, 1967 · N58700 · Substantial damage NTSB SEA67D0355Accident · Serious injuriesClosedCessna 150 · Port Angeles, WAApr 27, 1967 · N7724F · Destroyed NTSB SEA68F0049Accident · Serious injuriesClosedPiper PA-23 · Hoquiam, WAApr 25, 1967 · N2205P · Substantial damage NTSB SEA67D0314Accident · No injuriesClosedCessna 150 · Sultan, WAApr 23, 1967 · N3547L · Substantial damage NTSB SEA67A0059Accident · 1 fatalClosedCessna 150 · Vancouver, WAApr 19, 1967 · N7971Z · Destroyed NTSB SEA67F0327Accident · Minor injuriesClosedCessna 172E · Vancouver, WAApr 17, 1967 · N7705U · Substantial damage NTSB SEA68F0028Accident · No injuriesClosedAeronca 7AC · Snohomish, WAApr 15, 1967 · N84842 · Substantial damage NTSB SEA67F0292Accident · No injuriesClosedCessna 182 · Inchelium, WAApr 15, 1967 · N2748F · Substantial damage NTSB SEA67D0303Accident · No injuriesClosedBriegleb BG-12B · Issaqua, WAApr 15, 1967 · N12940 · Substantial damage NTSB SEA67F0305Accident · No injuriesClosedChampion 7ECA · Mose Lake, WAApr 10, 1967 · N5135T · Substantial damage NTSB SEA67F0329Accident · No injuriesClosedMaule M-4 · Vancouver, WAApr 9, 1967 · N4132C · Substantial damage NTSB SEA67D0315Accident · Minor injuriesClosedGlobe GC-1B · Alderwood Mr, WAApr 8, 1967 · N80659 · Substantial damage NTSB SEA68F0027Accident · Serious injuriesClosedPiper PA-28 · Port Orchard, WAApr 5, 1967 · N4392J · Substantial damage NTSB SEA67F0274Accident · No injuriesClosedBeech B50 · Wenatchee, WAApr 3, 1967 · N104W · Substantial damage NTSB SEA67A0057Accident · No injuriesClosedBell 47G-2 · Seattle, WAApr 3, 1967 · N8448E · Substantial damage NTSB SEA67D0301Accident · No injuriesClosedPiper PA-23 · Alderwood Mr, WAApr 2, 1967 · N1203P · Substantial damage NTSB SEA67A0055Accident · 1 fatalClosedBellanca 14-13 · Vashon, WAApr 2, 1967 · N86747 · Destroyed