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 SEA76DYE35Accident · No injuriesClosedCessna 150F · Ashford, WAApr 10, 1976 · N8160F · Substantial damage NTSB SEA76AS042Accident · 7 fatalClosedCessna 207 · Friday Harbor, WAApr 8, 1976 · N1645U · Destroyed NTSB SEA76DYE34Accident · No injuriesClosedHiller Acft UH-12E · Glenoma, WAApr 7, 1976 · N9732C · Substantial damage NTSB SEA76FYE33Accident · No injuriesClosedLuscombe 8A · Maple Valley, WAApr 4, 1976 · N1202B · Substantial damage NTSB SEA76FYE31Accident · No injuriesClosedCessna 310D · Alderwood Manr, WAApr 4, 1976 · N6822T · Substantial damage NTSB SEA76DYG39Accident · No injuriesClosedPiper J3C · Tonasket, WAApr 4, 1976 · N70957 · Substantial damage NTSB SEA76DYE32Accident · No injuriesClosedCessna 180 · Forks, WAApr 3, 1976 · N9352C · Substantial damage NTSB SEA76DYE30Accident · No injuriesClosedCessna 172 · Yelm, WAApr 2, 1976 · N35364 · Substantial damage NTSB SEA761S041Incident · No injuriesClosedDouglas DC-9 · Spokane, WAApr 1, 1976 · N9333 · No damage NTSB SEA76FYG38Accident · 1 fatalClosedCallair A-9 · Tekoa, WAMar 31, 1976 · N8281H · Destroyed NTSB SEA76FYG37Accident · Serious injuriesClosedCessna 180 · Anatone, WAMar 29, 1976 · N7699A · Destroyed NTSB SEA76AS040Accident · 2 fatalClosedPiper PA-23 · Pullman, WAMar 28, 1976 · N6199Y · Destroyed NTSB SEA76FYE29Accident · No injuriesClosedCessna 180C · Graham, WAMar 21, 1976 · N9280T · Destroyed NTSB SEA76FYE28Accident · Serious injuriesClosedChampion 7KCAB · Copalis, WAMar 20, 1976 · N1843G · Substantial damage NTSB SEA76AS039Accident · 2 fatalClosedPiper PA-28R · Eldon, WAMar 17, 1976 · C-GLPD · Destroyed NTSB SEA76FYG36Accident · Minor injuriesClosedPiper PA-28 · Touchet, WAMar 16, 1976 · N33525 · Substantial damage NTSB SEA76FYC35Accident · No injuriesClosedDehavilland DH-104 · Vancouver, WAMar 7, 1976 · N4042B · Substantial damage NTSB SEA76DYG40Accident · No injuriesClosedPiper PA-34 · Clyde, WAMar 4, 1976 · N7333L · Substantial damage NTSB SEA76FYG34Accident · Serious injuriesClosedPiper PA-28 · Pasco, WAMar 2, 1976 · N6674J · Substantial damage NTSB SEA76DYE27Accident · No injuriesClosedAeronca 11AC · Waldron Island, WAMar 1, 1976 · N9448E · Substantial damage NTSB SEA76FYE26Accident · No injuriesClosedPiper PA-28 · Auburn, WAFeb 22, 1976 · N32767 · Substantial damage NTSB SEA76FYE25Accident · No injuriesClosedHughes 269B · Renton, WAFeb 18, 1976 · N11212 · Substantial damage NTSB SEA76DYG32Accident · No injuriesClosedCessna 182P · College Place, WAFeb 18, 1976 · N6002J · Substantial damage NTSB SEA76DYG31Accident · No injuriesClosedCessna 172 · Wenatchee, WAFeb 4, 1976 · N9727V · Substantial damage NTSB SEA76FYC28Accident · No injuriesClosedAmer Avco AA1-A · Goldendale, WAFeb 3, 1976 · N6385L · Destroyed NTSB SEA76FYG29Accident · Serious injuriesClosedCessna 150 · Spokane, WAJan 19, 1976 · N3423J · Substantial damage NTSB SEA76FYE24Accident · Serious injuriesClosedBede BD-5B · Arlington, WAJan 18, 1976 · N501PB · Substantial damage NTSB SEA76DYG30Accident · No injuriesClosedCessna 150L · Ellensburg, WAJan 17, 1976 · N5294Q · Substantial damage NTSB SEA76FYE23Accident · Serious injuriesClosedPiper PA-22 · Vashon, WAJan 14, 1976 · N5144Z · Destroyed NTSB SEA76AS032Accident · 4 fatalClosedPiper PA-24 · Palmer, WADec 26, 1975 · N7288P · Destroyed NTSB SEA76IS033Incident · No injuriesClosedBeech 99 · Seattle, WADec 24, 1975 · N408SA · No damage NTSB SEA76DYG26Accident · No injuriesClosedCessna 140 · Quincy, WADec 22, 1975 · N89908 · Substantial damage NTSB SEA76DYG27Accident · No injuriesClosedCessna 210 · Wilbur, WADec 18, 1975 · N9634T · Substantial damage NTSB SEA76FYE22Accident · Serious injuriesClosedCessna 172 · Lummi Island, WADec 14, 1975 · N9613Q · Substantial damage NTSB SEA76DYC25Accident · No injuriesClosedCessna 150 · Vancouver, WANov 25, 1975 · N7719E · Substantial damage NTSB SEA76DYG28Accident · No injuriesClosedCessna 182 · Curlew, WANov 22, 1975 · N3343Y · Substantial damage NTSB SEA76DYC23Accident · No injuriesClosedAmer Avco AA1-A · Goldendale, WANov 19, 1975 · N6368L · Substantial damage NTSB SEA76AS027Accident · 1 fatalClosedBeech 19A · Port Orchard, WANov 19, 1975 · N5085T · Destroyed NTSB SEA76FYE21Accident · Serious injuriesClosedPiper PA-22 · Lummi Island, WANov 18, 1975 · N8155D · Substantial damage NTSB SEA76DYG23Accident · No injuriesClosedCessna 150 · Brewster, WANov 10, 1975 · N6329S · Substantial damage NTSB SEA76AS026Accident · 1 fatalClosedPiper J3C-65 · Carbonado, WANov 9, 1975 · N6899H · Destroyed NTSB SEA76FYE21Accident · Serious injuriesClosedAmer Avco AA1-B · Oak Harbor, WANov 8, 1975 · N9687L · Substantial damage NTSB SEA76AS021Accident · Serious injuriesClosedDouglas DC-10 · Seattle, WAOct 16, 1975 · N1815U · No damage NTSB SEA76AS020Accident · 2 fatalClosedPiper PA-24 · Woodland, WAOct 14, 1975 · N6680P · Destroyed NTSB SEA7LFYE18Accident · Serious injuriesClosedLake LA-4 · Alderwood Mnr, WAOct 11, 1975 · N2011L · Destroyed NTSB SEA76AS019Accident · 1 fatalClosedPiper PA-28 · Snoqualme Pass, WAOct 11, 1975 · N5858U · Destroyed NTSB SEA76DYE19Accident · No injuriesClosedCessna 172 · Elma, WAOct 10, 1975 · N5274R · Substantial damage NTSB SEA76FYG17Accident · Serious injuriesClosedBeech 19A · Quincy, WAOct 6, 1975 · N6062N · Substantial damage NTSB SEA76DYG20Accident · No injuriesClosedCessna 172B · Deer Park, WAOct 5, 1975 · N7748X · Substantial damage NTSB SEA76FYE17Accident · 1 fatalClosedMini Cab Hawk · Maple Valley, WASep 30, 1975 · N27421 · Destroyed