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 SEA75FYG45Accident · No injuriesClosedLake LA-4 · Spokane, WAJun 27, 1975 · N6693L · Substantial damage NTSB SEA75FYC45Accident · No injuriesClosedCessna 150 · Vancouver, WAJun 27, 1975 · N4055U · 2 aircraft · Substantial damage NTSB SEA75DYG49Accident · Minor injuriesClosedGrumman G-164 · Dayton, WAJun 20, 1975 · N10243 · Destroyed NTSB SEA75DYG42Accident · Minor injuriesClosedPiper PA-25 · Prosser, WAJun 20, 1975 · N8802L · Destroyed NTSB SEA75DYE48Accident · Minor injuriesClosedCessna 150 · Blaine, WAJun 18, 1975 · N8364J · Substantial damage NTSB SEA75AS045Accident · No injuriesClosedCessna 402A · Seattle, WAJun 15, 1975 · N4504Q · Substantial damage NTSB SEA7KDYE47Accident · Serious injuriesClosedBlanik L-13 · Issaquah, WAJun 8, 1975 · N93460 · Substantial damage NTSB SEA76DYG41Accident · No injuriesClosedLuscombe 8A · Lyons Ferry, WAJun 8, 1975 · N1089K · Substantial damage NTSB SEA7KAS043Accident · 1 fatalClosedPine Air Superv · Omak, WAMay 30, 1975 · N772MD · Destroyed NTSB SEA75DYG40Accident · No injuriesClosedChampion 7FC · Ellensburg, WAMay 30, 1975 · N9093B · Substantial damage NTSB SEA75AS042Accident · 3 fatalClosedCessna 170B · Issaquah, WAMay 29, 1975 · N3456C · Destroyed NTSB SEA75DYE45Accident · No injuriesClosedCessna 150 · Purdy, WAMay 26, 1975 · N11758 · Substantial damage NTSB SEA75FYE46Accident · Serious injuriesClosedPiper PA-18 · Moclips, WAMay 25, 1975 · N9047Y · Destroyed NTSB SEA75DYE44Accident · No injuriesClosedCessna 182C · Vashon, WAMay 23, 1975 · N9900T · Substantial damage NTSB SEA75DYE43Accident · No injuriesClosedCessna 180 · Anacortes, WAMay 23, 1975 · N5270D · Substantial damage NTSB SEA75DYG39Accident · No injuriesClosedBell 47G-2 · Mesa, WAMay 22, 1975 · N8448E · Substantial damage NTSB SEA75DYG43Accident · Minor injuriesClosedPiper PA-25 · St John, WAMay 17, 1975 · N4544Y · Substantial damage NTSB SEA75DYG37Accident · No injuriesClosedBell 47G3B1 · Palouse, WAMay 14, 1975 · N6257N · Destroyed NTSB SEA75DYG31Accident · No injuriesClosedPiper PA-28 · Yakima, WAMay 14, 1975 · N2373T · Substantial damage NTSB SEA75DYE42Accident · No injuriesClosedPiper PA-30 · Ocean Shores, WAMay 7, 1975 · CF-DUF · Substantial damage NTSB SEA75DYE41Accident · Minor injuriesClosedHiller Acft UH-12E · Concrete, WAMay 5, 1975 · N90469 · Destroyed NTSB SEA75DYG38Accident · No injuriesClosedBeech A35 · Spokane, WAMay 4, 1975 · N8689A · Substantial damage NTSB SEA75FYE40Accident · No injuriesClosedAmer Avco AA1A · Stuart Island, WAMay 1, 1975 · N9290L · Destroyed NTSB SEA75DYG36Accident · No injuriesClosedPiper PA-25 · Benge, WAApr 29, 1975 · N6157Z · Substantial damage NTSB SEA75DYG33Accident · No injuriesClosedCessna 205 · Ellensburg, WAApr 26, 1975 · N8162Z · Substantial damage NTSB SEA75FYG32Accident · No injuriesClosedSchweizer SGS233 · Colville, WAApr 19, 1975 · N5721S · Substantial damage NTSB SEA75DYG30Accident · No injuriesClosedGrumman G-164A · Pasco, WAApr 17, 1975 · N8365 · Substantial damage NTSB SEA75DYG29Accident · No injuriesClosedBoeing E75 · Dayton, WAApr 12, 1975 · N56426 · Substantial damage NTSB SEA75AS038Accident · 2 fatalClosedPiper J-3C · Ellensburg, WAApr 6, 1975 · N48312 · Destroyed NTSB SEA75AS037Accident · Minor injuriesClosedBeech 99 · Spokane, WAApr 6, 1975 · N851SA · Substantial damage NTSB SEA75FYE39Accident · Serious injuriesClosedBeech A35 · Packwood, WAApr 5, 1975 · N570B · Destroyed NTSB SEA75DYE38Accident · Minor injuriesClosedChampion 7ACA · Puyallup, WAApr 4, 1975 · N10986 · Destroyed NTSB SEA75FYC33Accident · Minor injuriesClosedHiller Acft UH-12E · Willard, WAApr 3, 1975 · N28877 · Substantial damage NTSB SEA75DYG28Accident · No injuriesClosedCessna A185F · Connell, WAApr 1, 1975 · N4661C · Substantial damage NTSB SEA75FYG26Accident · Serious injuriesClosedCessna 182 · Walla Walla, WAMar 29, 1975 · N21244 · Destroyed NTSB SEA75FYE37Accident · No injuriesClosedPine Air Superv · Oak Harbor, WAMar 29, 1975 · N772MD · Substantial damage NTSB SEA75DYG25Accident · No injuriesClosedBell 206B · Prescott, WAMar 19, 1975 · N59620 · Substantial damage NTSB SEA75DYE36Accident · No injuriesClosedCessna 182C · Vashon, WAMar 9, 1975 · N9900T · Substantial damage NTSB SEA75DYE35Accident · No injuriesClosedCessna 170B · Issaquah, WAMar 5, 1975 · N3456C · Substantial damage NTSB SEA75DYG21Accident · No injuriesClosedCessna 180 · Yakima, WAMar 4, 1975 · N9024M · Substantial damage NTSB SEA75DYG22Accident · No injuriesClosedCessna 172 · Rockford, WAMar 2, 1975 · N19982 · Substantial damage NTSB SEA75FYE34Accident · Serious injuriesClosedHelio Acft H-295 · Port Orchard, WAFeb 28, 1975 · N94747 · Substantial damage NTSB SEA75FYE33Accident · No injuriesClosedHughes 369HS · Renton, WAFeb 25, 1975 · N9046F · Substantial damage NTSB SEA75DYE32Accident · No injuriesClosedMooney M20A · Orcas Island, WAFeb 22, 1975 · N8341E · Substantial damage NTSB SEA75AYG20Accident · No injuriesClosedCessna 150 · Deer Park, WAFeb 15, 1975 · N61099 · Substantial damage NTSB SEA75FYE30Accident · No injuriesClosedMooney M20C · Alderwood Mnr, WAFeb 5, 1975 · N5932Q · Substantial damage NTSB SEA75FYG18Accident · No injuriesClosedBeech 99A · Pullman, WAFeb 4, 1975 · N20FW · Substantial damage NTSB SEA75DYG19Accident · No injuriesClosedCessna 172 · Colville, WAFeb 2, 1975 · N7230A · Substantial damage NTSB SEA75DYE31Accident · No injuriesClosedCessna 150 · Waldron Island, WAFeb 1, 1975 · N8441G · Substantial damage NTSB SEA75IS028Incident · No injuriesClosedBeech 99 · Wenatchee, WAJan 30, 1975 · N851SA · Minor damage