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 SEA81DYE21Accident · No injuriesClosedCessna TU206 · Bellevue, WAFeb 28, 1981 · N4850F · Substantial damage NTSB SEA81FA019Accident · 1 fatalClosedPiper PA-28 · Seattle, WAFeb 25, 1981 · N2258Q · Destroyed NTSB SEA81FYE18Accident · Minor injuriesClosedCessna 172 · Seattle, WAFeb 23, 1981 · N2946E · Substantial damage NTSB SEA81FYE17Accident · Minor injuriesClosedCessna TU206G · Everett, WAFeb 16, 1981 · N7345N · Destroyed NTSB SEA81DYE14Accident · No injuriesClosedMaule M-5 · Kelso, WAFeb 8, 1981 · N5634M · Substantial damage NTSB SEA81DYE13Accident · Minor injuriesClosedCessna 172 · Bellingham, WAFeb 4, 1981 · N738HU · Destroyed NTSB SEA81FYP05Accident · Serious injuriesClosedPiper PA-25 · Mesa, WAJan 30, 1981 · N4779Y · Destroyed NTSB SEA81FA018Accident · 2 fatalClosedPiper PA-28 · Port Angles, WAJan 28, 1981 · N3062D · Destroyed NTSB SEA81FA017Accident · 2 fatalClosedCessna 150F · Puyallup, WAJan 23, 1981 · N6942F · Destroyed NTSB DCA81AA006Accident · 7 fatalClosedBeech 99A · Spokane, WAJan 20, 1981 · N390CA · Destroyed NTSB SEA81IA016Incident · No injuriesClosedBoeing 727 · Seattle, WAJan 14, 1981 · N439BN · 2 aircraft · No damage NTSB SEA81FYP06Accident · No injuriesClosedCessna 320 · Curlew, WAJan 14, 1981 · N9831L · Substantial damage NTSB SEA81FYE15Accident · No injuriesClosedPiper PA-24 · Olympia, WAJan 10, 1981 · N6651P · Substantial damage NTSB SEA81DYE11Accident · No injuriesClosedHiller Acft UH-12E · Beaver, WAJan 7, 1981 · N28875 · Substantial damage NTSB SEA81FYE10Accident · Serious injuriesClosedRockwell 114 · Maple Valley, WAJan 4, 1981 · N4723W · Destroyed NTSB SEA81DYE09Accident · No injuriesClosedBakeng Duce · Issaquah, WADec 28, 1980 · N54BM · Substantial damage NTSB SEA81FYM12Accident · Serious injuriesClosedCessna 172N · Yacolt, WADec 25, 1980 · N738FS · Substantial damage NTSB SEA81FA012Accident · 2 fatalClosedPiper PA-34 · Stevenson, WADec 21, 1980 · N114PH · Destroyed NTSB SEA81FYM11Accident · No injuriesClosedCessna 182P · Orchards, WADec 9, 1980 · N21413 · Substantial damage NTSB SEA81FA013Accident · 1 fatalClosedCessna 210 · Royal City, WADec 3, 1980 · N6508X · Destroyed NTSB LAX81FA020Accident · 2 fatalClosedCessna 320C · Marysville, WANov 30, 1980 · N9RT · Destroyed NTSB SEA81FA009Accident · 6 fatalClosedBeech 58TC · Ellensburg, WANov 27, 1980 · N24AC · Destroyed NTSB SEA81DYP04Accident · No injuriesClosedHughes 269B · Ephrata, WANov 23, 1980 · N9477F · Substantial damage NTSB SEA81IA007Incident · No injuriesClosedCessna 310G · Walla Walla, WANov 20, 1980 · N2905R · Minor damage NTSB SEA81DYE08Accident · No injuriesClosedHiller Acft UH-12E · Forks, WANov 19, 1980 · N542HA · Substantial damage NTSB SEA81DYE06Accident · No injuriesClosedCessna 172 · Diamond Point, WANov 16, 1980 · N6477D · Substantial damage NTSB SEA81FA004Accident · 3 fatalClosedNavion A · Yakima, WANov 15, 1980 · N8553H · Destroyed NTSB SEA81DYE07Accident · No injuriesClosedCessna 185 · Port Townsend, WANov 15, 1980 · N70037 · Substantial damage NTSB SEA81DYE05Accident · No injuriesClosedCessna 180 · Forks, WANov 11, 1980 · N4724U · Substantial damage NTSB SEA81FA058Accident · 4 fatalClosedCessna 172M · Quinault, WANov 8, 1980 · N61614 · Destroyed NTSB SEA81FYE04Accident · No injuriesClosedCessna 210P · Everett, WAOct 23, 1980 · N731HV · Substantial damage NTSB SEA81DYP02Accident · No injuriesClosedPiper PA-28R · Almira, WAOct 12, 1980 · N4527J · Substantial damage NTSB SEA81FYE03Accident · No injuriesClosedCessna 185 · Seattle, WAOct 9, 1980 · N70438 · Substantial damage NTSB SEA81DYM06Accident · No injuriesClosedBell 206L-1 · Cougar, WAOct 8, 1980 · N2756N · Substantial damage NTSB SEA81FYP01Accident · Serious injuriesClosedPiper PA-22 · Waterville, WAOct 6, 1980 · N7710D · Substantial damage NTSB SEA81DYM08Accident · No injuriesClosedCessna 140 · Vancouver, WAOct 6, 1980 · N72778 · Substantial damage NTSB SEA81FYE02Accident · Serious injuriesClosedChampion 8KCAB · Lester, WAOct 5, 1980 · N33MJ · Substantial damage NTSB SEA81FYM01Accident · 1 fatalClosedWalker Mini · Trout Lake, WAOct 2, 1980 · N249KY · Destroyed NTSB SEA80FYP42Accident · No injuriesClosedBensen B-8M · Quincy, WASep 29, 1980 · NONE · Substantial damage NTSB SEA80FYP40Accident · Minor injuriesClosedGulf-Schwzr G-164B · Ritzville, WASep 22, 1980 · N8093K · Destroyed NTSB SEA80DYP41Accident · No injuriesClosedPiper PA-18 · Colfax, WASep 19, 1980 · N40523 · Substantial damage NTSB SEA80DYM62Accident · No injuriesClosedCessna 182P · Goldendale, WASep 18, 1980 · N1498M · Substantial damage NTSB SEA80FA049Accident · 4 fatalClosedCessna 177RG · Lopez, WASep 16, 1980 · N7514V · Destroyed NTSB SEA80FYP39Accident · No injuriesClosedCessna 182B · Buena, WASep 15, 1980 · N2761G · Substantial damage NTSB SEA81FYP38Accident · Serious injuriesClosedHughes 369D · Newport, WASep 12, 1980 · N1090L · Substantial damage NTSB SEA80FA045Accident · 4 fatalClosedCessna 182Q · Skykomish, WAAug 30, 1980 · N759ZZ · Destroyed NTSB SEA80FYP36Accident · No injuriesClosedPiper PA-38 · Stratford, WAAug 28, 1980 · N6320A · Substantial damage NTSB SEA80FYM57Accident · No injuriesClosedCessna 182C · Orchards, WAAug 24, 1980 · N8800T · Substantial damage NTSB SEA80FYP34Accident · No injuriesClosedBell 47G-2 · Sunnyside, WAAug 23, 1980 · N73284 · Substantial damage NTSB SEA80FYP33Accident · No injuriesClosedCessna T210N · Walla Walla, WAAug 21, 1980 · N7372C · Substantial damage