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 SEA78DYP11Accident · No injuriesClosedStinson 108 · Mead, WAFeb 6, 1978 · N97675 · Substantial damage NTSB SEA78DYE07Accident · No injuriesClosedHughes 269B · Graham, WAFeb 5, 1978 · N9442F · Substantial damage NTSB SEA78DYP10Accident · No injuriesClosedCessna 180 · Pasco, WAJan 28, 1978 · N2418C · Substantial damage NTSB SEA78FYP08Accident · 1 fatalClosedCessna 182Q · Colfax, WAJan 25, 1978 · N735ML · Destroyed NTSB SEA78DYM17Accident · No injuriesClosedPiper PA-22 · Wallowa, WAJan 22, 1978 · N7244D · Substantial damage NTSB SEA78DYP07Accident · No injuriesClosedCessna 152 · Mead, WAJan 19, 1978 · N25029 · Substantial damage NTSB SEA78FYP09Accident · Serious injuriesClosedTaylorcraft BC12D · Othello, WAJan 14, 1978 · N43271 · Substantial damage NTSB SEA78FYE05Accident · Minor injuriesClosedBell 205A-1 · Castle Rock, WAJan 13, 1978 · N67HJ · Destroyed NTSB SEA78FA016Accident · 1 fatalClosedPiper PA-34 · Wenatchee, WADec 30, 1977 · N7089C · Destroyed NTSB SEA78FA013Accident · 1 fatalClosedCessna 152 · Quincy, WADec 16, 1977 · N757TC · Destroyed NTSB SEA78DYP06Accident · No injuriesClosedCessna 172 · Pasco, WADec 15, 1977 · N9021H · Substantial damage NTSB SEA78FYE04Accident · No injuriesClosedCessna 185F · Seattle, WADec 6, 1977 · N1022F · Substantial damage NTSB SEA78FYP05Accident · 1 fatalClosedBeech A35 · W.Richland, WADec 4, 1977 · N8687A · Substantial damage NTSB SEA78FA018Accident · 1 fatalClosedCessna 320E · Steptoe, WADec 1, 1977 · N3431Q · Destroyed NTSB SEA78FYE03Accident · No injuriesClosedPiper PA-18 · Bellevue, WANov 26, 1977 · N2LB · Substantial damage NTSB SEA78IA009Incident · No injuriesClosedBoeing 727 · Seattle, WANov 17, 1977 · N316AS · Minor damage NTSB SEA78FYM10Accident · Serious injuriesClosedCessna T337B · Vancouver, WANov 14, 1977 · N2351S · Destroyed NTSB SEA78FA008Accident · 4 fatalClosedCessna 172M · Newport, WANov 13, 1977 · C-GSKO · Destroyed NTSB SEA78FYE02Accident · Minor injuriesClosedHughes 369C · Morton, WANov 10, 1977 · N9174F · Destroyed NTSB SEA78FYE01Accident · Serious injuriesClosedAerosport Quail · Spanaway, WANov 3, 1977 · N9229Z · Substantial damage NTSB SEA78DYP04Accident · No injuriesClosedCessna 172D · Sunnyside, WANov 1, 1977 · N2388U · Substantial damage NTSB SEA77FA004Accident · 4 fatalClosedN.American Navion · Yakima, WAOct 23, 1977 · N91580 · Destroyed NTSB SEA78DYP03Accident · No injuriesClosedHughes 369D · Spokane, WAOct 12, 1977 · N8601F · Substantial damage NTSB SEA78DYP02Accident · No injuriesClosedCons-Vultee L-13 · Wenatchee, WAOct 11, 1977 · N4659V · Substantial damage NTSB SEA78FA003Accident · 3 fatalClosedPiper PA-31P · Vancouver, WAOct 8, 1977 · N117HC · Destroyed NTSB SEA78FA001Accident · 7 fatalClosedDehavilland DHC-2 · Stevens Pass, WAOct 1, 1977 · N64391 · Destroyed NTSB SEA78DYP01Accident · No injuriesClosedCessna 206 · Priest Rpd Dam, WAOct 1, 1977 · N72160 · Substantial damage NTSB SEA77FA055Accident · 2 fatalClosedPiper PA-28 · Reardan, WASep 30, 1977 · N8342W · Destroyed NTSB SEA77FYE36Accident · Serious injuriesClosedCessna 180 · Auburn, WASep 24, 1977 · N4581B · Substantial damage NTSB SEA77FYP45Accident · Minor injuriesClosedPiper PA-25 · Pasco, WASep 21, 1977 · N4566Y · Destroyed NTSB SEA77FA053Accident · 1 fatalClosedCessna 150L · Clarkston, WASep 17, 1977 · N6578G · Destroyed NTSB SEA77DYP47Accident · Minor injuriesClosedAero Comdr S2R · Touchet, WASep 17, 1977 · N5045X · Destroyed NTSB SEA77FA052Accident · 3 fatalClosedCessna 172K · Skykomish, WASep 16, 1977 · N78597 · Destroyed NTSB SEA77FA051Accident · 2 fatalClosedCessna 182L · Bellevue, WASep 9, 1977 · N3466R · Destroyed NTSB SEA77DYP46Accident · No injuriesClosedCessna 182 · Walla Walla, WASep 8, 1977 · N5141D · Substantial damage NTSB SEA77FYP43Accident · Serious injuriesClosedPiper PA-28R · Cle Elum, WASep 5, 1977 · N5303T · Substantial damage NTSB SEA77FA050Accident · 1 fatalClosedGrum Amer AA1C · Othello, WASep 4, 1977 · N9558U · Destroyed NTSB SEA77DYP42Accident · No injuriesClosedCessna 170B · Connell, WAAug 29, 1977 · N2731D · Substantial damage NTSB SEA77FYE34Accident · Serious injuriesClosedAnderson Kgfshr · Lakewood Ctr, WAAug 28, 1977 · N8DE · Substantial damage NTSB SEA77DYE35Accident · No injuriesClosedCessna 172 · Ilwaco, WAAug 27, 1977 · N6931X · Substantial damage NTSB SEA77DYP41Accident · No injuriesClosedCessna 150M · Moses Lake, WAAug 26, 1977 · N66063 · Substantial damage NTSB SEA77FYM59Accident · 1 fatalClosedPitts MR1 · Vancouver, WAAug 21, 1977 · N30059 · Destroyed NTSB SEA77FA049Accident · 4 fatalClosedCessna 185 · Hansville, WAAug 21, 1977 · N1738R · Destroyed NTSB SEA77DYE33Accident · Serious injuriesClosedLambert 201 · Silverdale, WAAug 21, 1977 · CF-AAT · Substantial damage NTSB SEA77DYM58Accident · Minor injuriesClosedCessna 172K · Orchard, WAAug 19, 1977 · N79931 · Substantial damage NTSB SEA77DYP40Accident · No injuriesClosedGrumman G-164B · Quincy, WAAug 15, 1977 · N48423 · Substantial damage NTSB SEA77FYP38Accident · Serious injuriesClosedBushby Midg Mustng · Plain, WAAug 13, 1977 · N73T · Substantial damage NTSB SEA77FYP39Accident · Serious injuriesClosedNaval Fcty N3N-3 · Prescott, WAAug 11, 1977 · N45261 · Destroyed NTSB SEA77DYP36Accident · No injuriesClosedCessna 150H · Nespelem, WAAug 6, 1977 · N8863R · Substantial damage NTSB SEA77DYE31Accident · No injuriesClosedPiper PA-28 · Bellevue, WAAug 5, 1977 · N9155W · Substantial damage