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 SEA74AS035Accident · 2 fatalClosedAmer Avco AA1-B · Enumclaw, WAMar 3, 1974 · N6213L · Destroyed NTSB SEA74AS034Accident · 3 fatalClosedCessna 172A · Waterville, WAMar 1, 1974 · N7820T · Destroyed NTSB SEA74DYE38Accident · No injuriesClosedCessna 172 · Bellingham, WAFeb 24, 1974 · N4112L · Substantial damage NTSB SEA74DYC25Accident · No injuriesClosedBell 47G-2 · Spokane, WAFeb 24, 1974 · N59H · Substantial damage NTSB SEA74DYG26Accident · No injuriesClosedCessna 182 · Yakima, WAFeb 23, 1974 · N2821R · Substantial damage NTSB SEA74AS033Accident · 2 fatalClosedBeech N35 · Skamania, WAFeb 22, 1974 · N566T · Destroyed NTSB SEA74DYG24Accident · Minor injuriesClosedMaule M-4 · St.John, WAFeb 21, 1974 · N40352 · Substantial damage NTSB SEA74FYG23Accident · Serious injuriesClosedPiper PA-23 · Ritzville, WAFeb 9, 1974 · N6012Y · Destroyed NTSB SEA74DYE37Accident · No injuriesClosedPiper PA-12 · Blakely Isle, WAFeb 8, 1974 · N4043H · Substantial damage NTSB SEA74DYE36Accident · Minor injuriesClosedCessna 150 · Kelso, WAJan 25, 1974 · N5861G · Destroyed NTSB SEA74AS031Accident · 2 fatalClosedCessna 172L · Goldendale, WAJan 25, 1974 · N7888G · Destroyed NTSB SEA74AS030Accident · 1 fatalClosedBell 47G-4A · Wapato, WAJan 20, 1974 · N1396X · Destroyed NTSB SEA74DYE34Accident · No injuriesClosedCessna 172 · Holly, WAJan 13, 1974 · N7234G · Substantial damage NTSB SEA74FYC35Accident · No injuriesClosedPiper PA-28 · Vancouver, WAJan 11, 1974 · N8081W · No damage NTSB SEA74AS029Accident · No injuriesClosedPiper PA-32 · Bremerton, WAJan 6, 1974 · N4162W · Substantial damage NTSB SEA74DVE35Accident · Minor injuriesClosedCessna 172 · Bellingham, WAJan 2, 1974 · N1300T · Substantial damage NTSB SEA74DYE33Accident · No injuriesClosedLuscombe 8E · Bellevue, WAJan 1, 1974 · N2951K · Substantial damage NTSB SEA74DYG22Accident · No injuriesClosedPiper PA-28 · Richland, WADec 31, 1973 · N2350T · Substantial damage NTSB SEA74AS028Accident · 2 fatalClosedCessna 182P · Kelso, WADec 30, 1973 · N58661 · Destroyed NTSB SEA74DYE32Accident · No injuriesClosedHiller UH-12E · Queets, WADec 28, 1973 · N28875 · Destroyed NTSB SEA74AS027Accident · 1 fatalClosedPiper PA-31 · Walla Walla, WADec 27, 1973 · N66798 · Destroyed NTSB SEA74AS026Accident · No injuriesClosedCessna 182 · Anacortes, WADec 21, 1973 · N1814X · Destroyed NTSB SEA74FYE31Accident · Serious injuriesClosedCessna 337A · Maynard, WADec 11, 1973 · N5313S · Destroyed NTSB SEA74DYE30Accident · No injuriesClosedCessna 182 · Tacoma, WADec 11, 1973 · N5501B · Substantial damage NTSB SEA74IS025Incident · No injuriesClosedBoeing 720A · Moses Lake, WADec 5, 1973 · N7225U · Minor damage NTSB SEA74DYE29Accident · No injuriesClosedCessna 180H · Tillacum, WADec 1, 1973 · N8237V · Substantial damage NTSB SEA74AYE28Accident · Serious injuriesClosedBeech A23-19 · Everett, WANov 30, 1973 · N8735M · Substantial damage NTSB SEA74AS024Accident · 2 fatalClosedCessna 210 · Quilcene, WANov 19, 1973 · N9550T · Destroyed NTSB SEA74DYE27Accident · No injuriesClosedCessna 172 · Morton, WANov 3, 1973 · N2132Y · Substantial damage NTSB SEA74AS023Accident · 2 fatalClosedPiper PA-28 · Wenatchee, WANov 3, 1973 · N5806U · Destroyed NTSB SEA74DYE26Accident · No injuriesClosedHiller Acft FH1100 · Centralia, WANov 1, 1973 · N750NH · Substantial damage NTSB SEA74DYE25Accident · No injuriesClosedBell 47G-3B · Forks, WANov 1, 1973 · N73918 · Substantial damage NTSB SEA74DYG18Accident · No injuriesClosedCessna 180H · Othello, WAOct 20, 1973 · N9020M · Substantial damage NTSB SEA74FYE23Accident · No injuriesClosedSikorsky S-58E · Alpental, WAOct 19, 1973 · N4382S · Substantial damage NTSB SEA74IS020Incident · Minor injuriesClosedDouglas DC-8 · Spokane, WAOct 18, 1973 · N4903C · Substantial damage NTSB SEA74DYE22Accident · No injuriesClosedPiper PA-24 · Renton, WAOct 18, 1973 · N9026P · Substantial damage NTSB SEA74DYE21Accident · Minor injuriesClosedPiper PA-28 · Bellevue, WAOct 18, 1973 · N15627 · Destroyed NTSB SEA74DYE24Accident · No injuriesClosedLuscombe 8A · Auburn, WAOct 17, 1973 · N28461 · Substantial damage NTSB SEA74DYG19Accident · No injuriesClosedCessna 182H · Wenatchee, WAOct 16, 1973 · N2473X · Substantial damage NTSB SEA74AS019Accident · 1 fatalClosedPiper PA-28R · Tenino, WAOct 13, 1973 · N9456N · Destroyed NTSB SEA74DYE20Accident · No injuriesClosedBell 47F-2 · Forks, WAOct 8, 1973 · N5161B · Substantial damage NTSB SEA74DYG20Accident · No injuriesClosedMooney M20E · Prosser, WAOct 6, 1973 · N1335W · Substantial damage NTSB SEA74AYC20Accident · Serious injuriesClosedSorrell SNS-6 · Dallesport, WAOct 4, 1973 · N66S · Substantial damage NTSB SEA74DYE19Accident · No injuriesClosedHughes 269A · Forks, WASep 23, 1973 · N8763F · Substantial damage NTSB SEA74DYE18Accident · No injuriesClosedPiper PA-18 · Arlington, WASep 23, 1973 · N7474D · Substantial damage NTSB SEA74AS017Accident · 2 fatalClosedPiper PA-20 · Oakesdale, WASep 18, 1973 · N7666K · Destroyed NTSB SEA74FYE15Accident · Serious injuriesClosedCessna 150L · Federal Way, WASep 16, 1973 · N6519G · Substantial damage NTSB SEA74DYE17Accident · No injuriesClosedHughes 269C · Eagle Lake, WASep 16, 1973 · N8955F · Substantial damage NTSB SEA74FYG17Accident · No injuriesClosedPitts S-1C · Spokane, WASep 9, 1973 · N5S · Substantial damage NTSB SEA74DYE12Accident · No injuriesClosedHughes 269A · Eatonville, WASep 7, 1973 · N8813 · Substantial damage