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 SEA77DYM20Accident · No injuriesClosedCessna 140A · Battle Ground, WAFeb 13, 1977 · N9477A · Substantial damage NTSB SEA77FA019Accident · 1 fatalClosedPiper PA-28R · Port Orchard, WAFeb 12, 1977 · N1529X · Substantial damage NTSB SEA77FYK04Accident · Serious injuriesClosedErco 415C · Lakeview, WAFeb 7, 1977 · N2414H · Substantial damage NTSB SEA77FYE09Accident · Minor injuriesClosedAero Comdr 112A · Poulsbo, WAFeb 5, 1977 · N1354J · Destroyed NTSB SEA77FI016Incident · No injuriesClosedBoeing 727 · Seattle, WAJan 28, 1977 · N316AS · Minor damage NTSB SEA77FA015Accident · 1 fatalClosedPiper PA-32R · Olympia, WAJan 27, 1977 · N6638F · Destroyed NTSB SEA77FA014Accident · 3 fatalClosedCessna 172M · Forks, WAJan 24, 1977 · N73478 · Destroyed NTSB SEA77FA013Incident · No injuriesClosedDouglas DC-8 · Moses Lake, WAJan 24, 1977 · N787FT · Minor damage NTSB SEA77FYP17Accident · Minor injuriesClosedAeronca 11AC · Harrah, WAJan 20, 1977 · N9791E · Substantial damage NTSB SEA77FYE08Accident · Minor injuriesClosedCessna 150 · Langley, WAJan 20, 1977 · N66043 · Substantial damage NTSB SEA77FA012Accident · 3 fatalClosedBeech C35 · Mckenna, WAJan 14, 1977 · N859M · Destroyed NTSB SEA77DYE07Accident · No injuriesClosedCessna 182 · Lopez Island, WAJan 2, 1977 · N1816X · Substantial damage NTSB SEA77FA011Accident · 1 fatalClosedBeech V35B · Auburn, WADec 31, 1976 · N84BB · Destroyed NTSB SEA77DYE06Accident · No injuriesClosedPiper PA-34 · Verlot, WADec 27, 1976 · N33589 · Destroyed NTSB SEA77FYC11Accident · No injuriesClosedCessna 310B · Orchards, WADec 19, 1976 · N5455A · Substantial damage NTSB SEA77FA010Accident · Serious injuriesClosedCessna TU206C · Battle Ground, WADec 17, 1976 · N21NW · Destroyed NTSB SEA77FA009Accident · No injuriesClosedHiller Acft FH1100 · Renton, WADec 17, 1976 · N8678 · Substantial damage NTSB SEA77FYP14Accident · No injuriesClosedCessna 172K · Mead, WADec 11, 1976 · N7089G · Substantial damage NTSB SEA77FYP12Accident · No injuriesClosedAmer Avco AA-1 · Spokane, WADec 9, 1976 · N5799L · Substantial damage NTSB SEA77DYP13Accident · Minor injuriesClosedCessna 150E · Spangle, WADec 8, 1976 · N6286T · Substantial damage NTSB SEA77DYE04Accident · Minor injuriesClosedHiller Acft UH-12E · Neilton, WADec 1, 1976 · N93479 · Destroyed NTSB SEA77DYE05Accident · Minor injuriesClosedSchweizer SGS126 · Issaquah, WANov 28, 1976 · N65952 · Substantial damage NTSB SEA77DYG10Accident · No injuriesClosedWaco UPF-7 · Spokane, WANov 20, 1976 · N29926 · Substantial damage NTSB SEA77FYG11Accident · Serious injuriesClosedHiller Acft UH-12E · Ephrata, WANov 19, 1976 · N5380V · Destroyed NTSB SEA77FYG09Accident · Serious injuriesClosedNaval Fcty N3N-3 · College Place, WANov 16, 1976 · N44707 · Substantial damage NTSB SEA77FYG08Accident · No injuriesClosedMooney M20F · Palouse, WANov 11, 1976 · N9379M · Substantial damage NTSB SEA77DYE03Accident · No injuriesClosedCessna 170 · Spanaway, WANov 6, 1976 · N2620V · Substantial damage NTSB SEA77FYE01Accident · No injuriesClosedCessna 172 · Lummi Island, WANov 5, 1976 · N84647 · Substantial damage NTSB SEA77DYG06Accident · No injuriesClosedPiper PA-28 · Richland, WAOct 29, 1976 · N32735 · Substantial damage NTSB SEA77DYG07Accident · No injuriesClosedTaylorcraft BL-12 · Wilson Creek, WAOct 26, 1976 · N29875 · Substantial damage NTSB SEA77DYG02Accident · No injuriesClosedCessna 185F · Yakima, WAOct 17, 1976 · N1453F · Substantial damage NTSB SEA77DA001Accident · 1 fatalClosedAeronca 11AC · Medical Lake, WAOct 8, 1976 · N9053E · Destroyed NTSB SEA77DYE02Accident · Minor injuriesClosedHiller Acft UH-12E · Brinnon, WAOct 4, 1976 · N2HL · Substantial damage NTSB SEA77FYG05Accident · No injuriesClosedBeech C35 · Colville, WASep 28, 1976 · N8SU · Destroyed NTSB SEA77DYE64Accident · No injuriesClosedCessna 150M · Lynden, WASep 26, 1976 · C-FOOB · Substantial damage NTSB SEA76AS079Accident · 4 fatalClosedPiper PA-34 · Kent, WASep 25, 1976 · N15867 · Destroyed NTSB SEA76FYE63Accident · Serious injuriesClosedBellanca 17-31 · Bremerton, WASep 21, 1976 · N7387V · Substantial damage NTSB SEA76FYC70Accident · No injuriesClosedHiller Acft UH-12D · Carson, WASep 20, 1976 · N62245 · Substantial damage NTSB SEA76FYE61Accident · Serious injuriesClosedKasper Bekan · Issaquah, WASep 19, 1976 · N1853 · Destroyed NTSB SEA76DYE62Accident · No injuriesClosedSchweizer SGS233 · Monroe, WASep 18, 1976 · N5728S · Substantial damage NTSB SEA76FYE59Accident · Minor injuriesClosedBeech A35 · Port Townsend, WASep 15, 1976 · N670D · Substantial damage NTSB SEA76DYG74Accident · No injuriesClosedBell 47G-3B · Cashmere, WASep 15, 1976 · N6712D · Substantial damage NTSB SEA77DYG03Accident · No injuriesClosedCessna 172M · Benge, WASep 9, 1976 · N12772 · Substantial damage NTSB SEA76DYE65Accident · Serious injuriesClosedHiller Acft UH-12E · Humptulips, WASep 7, 1976 · N48001 · Substantial damage NTSB SEA76AS074Accident · 5 fatalClosedCessna TU206F · Spokane, WAAug 31, 1976 · N92JD · Destroyed NTSB SEA76DYE58Accident · No injuriesClosedCessna 175 · Oak Harbor, WAAug 30, 1976 · N7468M · Substantial damage NTSB SEA76A5071Accident · 1 fatalClosedAero Comdr 680FP · Fall City, WAAug 27, 1976 · N680FP · Destroyed NTSB SEA76DYE55Accident · No injuriesClosedBeech B35 · Olympia, WAAug 26, 1976 · N5206C · Substantial damage NTSB SEA76AS061Accident · 1 fatalClosedPiper PA-28 · No.Bonneville, WAAug 24, 1976 · N9154J · Destroyed NTSB SEA76DYG72Accident · No injuriesClosedCessna 205 · Metaline Falls, WAAug 21, 1976 · N8204Z · Substantial damage