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 SEA68F0227Accident · Serious injuriesClosedCessna 180 · Orchards, WASep 17, 1967 · N1793C · Destroyed NTSB SEA68D0137Accident · Minor injuriesClosedErco 415-C · Easton, WASep 17, 1967 · N3905H · Substantial damage NTSB SEA68F0123Accident · Minor injuriesClosedBeech C35 · Cle Elum, WASep 10, 1967 · N5927C · Substantial damage NTSB SEA68A0025Accident · 2 fatalClosedCessna 180H · Ilwaco, WASep 8, 1967 · N2787X · Destroyed NTSB SEA68F0160Accident · Serious injuriesClosedCessna 172 · Skykomish, WASep 5, 1967 · N8244U · Destroyed NTSB SEA68D0176Accident · No injuriesClosedPiper PA-24 · Auburn, WASep 4, 1967 · N5727P · Destroyed NTSB SEA68D0153Accident · Minor injuriesClosedStinson 108-2 · Bellingham, WASep 4, 1967 · CF-JGU · Substantial damage NTSB SEA68A0023Accident · 1 fatalClosedLuscombe 8A · Olympia, WASep 3, 1967 · N71865 · Destroyed NTSB SEA68F0177Accident · No injuriesClosedMooney M20C · Port Angeles, WAAug 29, 1967 · N5771Q · Substantial damage NTSB SEA68F0092Accident · No injuriesClosedBeech J35 · Spokane, WAAug 29, 1967 · N3053C · Substantial damage NTSB SEA68D0128Accident · No injuriesClosedCessna 175 · Walla Walla, WAAug 28, 1967 · N6918E · Substantial damage NTSB SEA68D0105Accident · No injuriesClosedLuscombe 8A · Deer Park, WAAug 28, 1967 · N28833 · Substantial damage NTSB SEA68D0181Accident · No injuriesClosedCessna 150 · Vancouver, WAAug 27, 1967 · N7904Z · Substantial damage NTSB SEA68D0147Accident · No injuriesClosedCessna 172 · Snohomish, WAAug 27, 1967 · N5674A · Substantial damage NTSB SEA68D0150Accident · Minor injuriesClosedCessna 182 · Goldbar, WAAug 25, 1967 · N2654G · Substantial damage NTSB SEA68F0151Accident · No injuriesClosedCessna 172 · Tumwater, WAAug 19, 1967 · N7027T · Destroyed NTSB SEA68D0174Accident · No injuriesClosedWren 460 · Seattle, WAAug 18, 1967 · N2427X · Substantial damage NTSB SEA68A0018Accident · No injuriesClosedCessna 180H · Clinton, WAAug 17, 1967 · N7901V · Substantial damage NTSB SEA68D0136Accident · No injuriesClosedPiper PA-23 · Georgetown, WAAug 15, 1967 · N4893P · Substantial damage NTSB SEA68F0152Accident · No injuriesClosedBoeing 247-D · Seattle, WAAug 14, 1967 · N13347 · Substantial damage NTSB SEA68F0161Accident · Serious injuriesClosedWaco UKC · Monroe, WAAug 11, 1967 · N16967 · Substantial damage NTSB SEA68D0135Accident · No injuriesClosedCessna 150 · Everett, WAAug 11, 1967 · N6511F · Substantial damage NTSB SEA68A0014Accident · 2 fatalClosedPiper PA-11 · Dayton, WAAug 10, 1967 · N78736 · Destroyed NTSB SEA68D0077Accident · Minor injuriesClosedCessna 206 · Richland, WAAug 8, 1967 · N2176F · Substantial damage NTSB SEA68A0013Accident · No injuriesClosedBeech C35 · Seattle, WAAug 8, 1967 · N5928C · Substantial damage NTSB SEA68F0068Accident · No injuriesClosedCessna 150 · Moses Lake, WAAug 5, 1967 · N8652G · Substantial damage NTSB SEA68F0067Accident · No injuriesClosedAeronca 7EC · Albion, WAJul 31, 1967 · N9689S · Substantial damage NTSB SEA68F0080Accident · Minor injuriesClosedTaylorcraft BC12-D · Puyallup, WAJul 30, 1967 · N96298 · Substantial damage NTSB SEA68D0134Accident · Minor injuriesClosedCessna 120 · Seattle, WAJul 30, 1967 · N77344 · Destroyed NTSB SEA68D0085Accident · No injuriesClosedCessna 182 · Renton, WAJul 30, 1967 · N2723G · Substantial damage NTSB SEA68D0083Accident · No injuriesClosedCessna 172 · Vashon Is., WAJul 29, 1967 · N4618L · Substantial damage NTSB SEA68A0009Accident · No injuriesClosedBoeing B-17G · Carson, WAJul 27, 1967 · N5237V · Substantial damage NTSB SEA68D0133Accident · No injuriesClosedPiper PA-28 · Port Angeles, WAJul 26, 1967 · N7012W · Substantial damage NTSB SEA68F0055Accident · No injuriesClosedBeech A23 · Metaline Fls, WAJul 23, 1967 · N2350W · Substantial damage NTSB SEA68F0079Accident · No injuriesClosedPiper PA-28 · Kelso, WAJul 19, 1967 · N6361W · Substantial damage NTSB SEA68A0007Accident · No injuriesClosedBell 47G-2 · Palisades, WAJul 17, 1967 · N3794G · Substantial damage NTSB SEA68F0070Accident · No injuriesClosedTaylorcraft BC12-D · Bellevue, WAJul 12, 1967 · N95896 · Substantial damage NTSB SEA68F0081Accident · Minor injuriesClosedAeronca 7FC · Enumclaw, WAJul 10, 1967 · N9090B · Substantial damage NTSB SEA68D0082Accident · No injuriesClosedCessna 210 · Seattle, WAJul 10, 1967 · N9719X · Substantial damage NTSB SEA68F0088Accident · No injuriesClosedCessna 150 · Vancouver, WAJul 8, 1967 · N7904Z · Substantial damage NTSB SEA68F0071Accident · No injuriesClosedCessna 320 · Shelton, WAJul 4, 1967 · N3031T · Substantial damage NTSB SEA68D0022Accident · No injuriesClosedCessna 150 · Inchelium, WAJul 4, 1967 · N8184F · Substantial damage NTSB SEA68A0003Accident · 2 fatalClosedAeronca 7DC · Inchelium, WAJul 4, 1967 · N83685 · Substantial damage NTSB SEA68F0112Accident · No injuriesClosedVultee BT-13B · Battleground, WAJul 1, 1967 · N66921 · Substantial damage NTSB SEA68F0050Accident · No injuriesClosedMooney M20C · Tacoma, WAJun 30, 1967 · N2963L · Substantial damage NTSB SEA68D0019Accident · No injuriesClosedAero Comdr 200-B · Pullman, WAJun 24, 1967 · N7281V · Substantial damage NTSB SEA68D0015Accident · No injuriesClosedPiper PA-25 · Kennewick, WAJun 23, 1967 · N4464Y · Substantial damage NTSB SEA68F0007Accident · Serious injuriesClosedPiper PA-18 · Pomeroy, WAJun 21, 1967 · N3753Z · Destroyed NTSB SEA68D0073Accident · No injuriesClosedCessna 150 · Tacoma, WAJun 20, 1967 · N2723S · Substantial damage NTSB SEA68D0006Accident · No injuriesClosedAG Comdr B1-A · Colfax, WAJun 19, 1967 · N7287V · Substantial damage