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 SEA75AS029Accident · 1 fatalClosedCessna 150H · Auburn, WAJan 30, 1975 · N23419 · Destroyed NTSB SEA75DYG16Accident · No injuriesClosedPiper PA-18 · Coulee City, WAJan 20, 1975 · N3297B · Substantial damage NTSB SEA75DYG15Accident · No injuriesClosedCessna 120 · Moses Lake, WAJan 20, 1975 · N2980N · Substantial damage NTSB SEA75DYE28Accident · No injuriesClosedBeech E33A · Tacoma, WAJan 19, 1975 · N6231V · Substantial damage NTSB SEA75FYE27Accident · No injuriesClosedCessna 150 · Seattle, WAJan 18, 1975 · N6286G · Substantial damage NTSB SEA75AS026Accident · 3 fatalClosedCessna TU206D · Palmer, WAJan 5, 1975 · N71972 · Destroyed NTSB SEA75DYE26Accident · No injuriesClosedCessna 310 · Bellingham, WAJan 3, 1975 · N911AL · Substantial damage NTSB SEA75DYE29Accident · No injuriesClosedCessna 170B · Lynden, WAJan 1, 1975 · N8301A · Substantial damage NTSB SEA75AS028Accident · 4 fatalClosedBrittnorman BN-2A · Riverton Hts, WADec 26, 1974 · N66HA · Destroyed NTSB SEA75FYC22Accident · No injuriesClosedCessna 182M · Vancouver, WADec 16, 1974 · N91916 · Substantial damage NTSB SEA75DYE25Accident · No injuriesClosedCessna 170B · Sinclair Isl, WANov 30, 1974 · N1877C · Substantial damage NTSB SEA75AS023Accident · 4 fatalClosedCessna 150L · Mt Vernon, WANov 29, 1974 · N11383 · 2 aircraft · Destroyed NTSB SEA75DYC21Accident · No injuriesClosedAmer Avco AA5 · Vancouver, WANov 9, 1974 · N6027L · Substantial damage NTSB SEA75FYE24Accident · 1 fatalClosedBell 205-A1 · Marblemount, WANov 4, 1974 · N59436 · Destroyed NTSB SEA75AS022Accident · 1 fatalClosedBell 47G-2 · Kingston, WANov 4, 1974 · N5160B · Destroyed NTSB SEA75FYG11Accident · No injuriesClosedCessna 172 · Richland, WANov 2, 1974 · N7143T · Substantial damage NTSB SEA75DYG13Accident · No injuriesClosedPiper PA-31 · Moses Lake, WANov 2, 1974 · N7700L · Substantial damage NTSB SEA75FYE23Accident · No injuriesClosedCessna 172 · Seattle, WAOct 31, 1974 · N3763L · Substantial damage NTSB SEA75AS019Accident · 2 fatalClosedCessna 182E · Prosser, WAOct 28, 1974 · N9224X · Destroyed NTSB SEA75AS018Accident · 1 fatalClosedWren 182 · Aberdeen, WAOct 27, 1974 · N2427X · Destroyed NTSB SEA75DYE22Accident · No injuriesClosedCessna 172 · Lummi Island, WAOct 26, 1974 · N3942L · Substantial damage NTSB SEA75IS017Incident · 1 fatalClosedDouglas DC-8 · Seattle, WAOct 21, 1974 · OYKTE · No damage NTSB SEA75OYE21Accident · No injuriesClosedCessna 177 · Alderwd Manr, WAOct 18, 1974 · N34555 · Substantial damage NTSB SEA75AS014Accident · 1 fatalClosedCessna 310B · Kent, WAOct 1, 1974 · N5414A · Destroyed NTSB SEA75FYE19Accident · Serious injuriesClosedCessna 150 · Snohomish, WASep 28, 1974 · N4481U · Substantial damage NTSB SEA75DYE18Accident · No injuriesClosedFairchild 24 · Oak Harbor, WASep 22, 1974 · N81204 · Substantial damage NTSB SEA75FVE17Accident · No injuriesClosedPiper PA-28 · Stuart Islnd, WASep 12, 1974 · N98113 · Substantial damage NTSB SEA75DYG12Accident · No injuriesClosedBell 47G-2 · Ruff, WASep 11, 1974 · N3794G · Substantial damage NTSB SEA75AS013Accident · 1 fatalClosedChampion 7ECA · Seattle, WASep 9, 1974 · N5235X · No damage NTSB SEA75DYE15Accident · No injuriesClosedChampion 7ECA · Center Islnd, WAAug 28, 1974 · N2582F · Substantial damage NTSB SEA75FYG10Accident · Serious injuriesClosedBell 47G-2 · Quincy, WAAug 27, 1974 · N6717D · Destroyed NTSB SEA75DYG09Accident · No injuriesClosedPiper PA-23 · Richland, WAAug 25, 1974 · N3173P · Substantial damage NTSB SEA75DYE14Accident · No injuriesClosedBoeing E75N1 · Toledo, WAAug 25, 1974 · N5051V · Substantial damage NTSB SEA75DYE13Accident · Serious injuriesClosedCessna 150 · Lynden, WAAug 24, 1974 · N8671S · Destroyed NTSB SEA75AS010Accident · Serious injuriesClosedCessna 150 · Vancouver, WAAug 24, 1974 · N1445Q · 2 aircraft · Destroyed NTSB SEA75DYG08Accident · No injuriesClosedPiper PA-28R · Othello, WAAug 19, 1974 · N3079R · Substantial damage NTSB SEA75FYC11Accident · Serious injuriesClosedRyan ST3KR · Goldendale, WAAug 18, 1974 · N58651 · Destroyed NTSB SEA75DYE16Accident · No injuriesClosedMooney M20A · Shelton, WAAug 18, 1974 · N8390E · Substantial damage NTSB SEA75AS009Accident · 2 fatalClosedPiper PA-22 · Kent, WAAug 17, 1974 · N6199D · Destroyed NTSB SEA75DYG07Accident · No injuriesClosedBell 47G-2 · Royal City, WAAug 14, 1974 · N6717D · Substantial damage NTSB SEA75DYC09Accident · Serious injuriesClosedBell 205A-1 · Cook, WAAug 14, 1974 · N4763R · Substantial damage NTSB SEA75DYE09Accident · Minor injuriesClosedBeech M35 · Westport, WAAug 13, 1974 · N9535R · Substantial damage NTSB SEA75DYE10Accident · Serious injuriesClosedCessna 150 · Fort Lewis, WAAug 12, 1974 · N11632 · No damage NTSB SEA75FYE11Accident · Serious injuriesClosedBell 47G-2A · Mercer Isl, WAAug 11, 1974 · N88AR · Destroyed NTSB SEA75AS008Accident · 1 fatalClosedPiper PA-32 · Toledo, WAAug 10, 1974 · N4126W · Destroyed NTSB SEA75DYE08Accident · Minor injuriesClosedErco 415-C · Port Townsnd, WAAug 6, 1974 · N3013H · Destroyed NTSB SEA75DYE07Accident · Serious injuriesClosedPiper PA-28 · Eatonville, WAAug 5, 1974 · N2171R · Substantial damage NTSB SEA75AS007Accident · 1 fatalClosedNavion B · Stevenson, WAAug 1, 1974 · N5149K · Substantial damage NTSB SEA75FYE05Accident · Minor injuriesClosedCessna 140A · Stanwood, WAJul 20, 1974 · N9448A · Destroyed NTSB SEA75DYG04Accident · No injuriesClosedCessna 150 · Selah, WAJul 20, 1974 · N6822F · Destroyed