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 SEA76DYE54Accident · Minor injuriesClosedCessna 177 · Eliza Island, WAAug 21, 1976 · N29426 · Substantial damage NTSB SEA76FYE60Accident · No injuriesClosedGrum Amer AA5 · Allyn, WAAug 14, 1976 · N6958L · Substantial damage NTSB SEA76DYE53Accident · No injuriesClosedBeech 23 · Blakely Island, WAAug 11, 1976 · N2389J · Substantial damage NTSB SEA76DYC66Accident · No injuriesClosedBell 47G3B2 · Vancouver, WAAug 11, 1976 · N7092J · Destroyed NTSB SEA76AS070Accident · 4 fatalClosedCessna 172N · Enumclaw, WAAug 11, 1976 · N20083 · Destroyed NTSB SEA76DYG73Accident · Minor injuriesClosedHiller Acft UH-12E · Kennewick, WAAug 10, 1976 · N7411N · Substantial damage NTSB SEA76AS068Accident · 1 fatalClosedNavion A · Snoqulmie Pass, WAAug 4, 1976 · N313L · Destroyed NTSB SEA76DYG68Accident · No injuriesClosedAero Comdr 600S2R · Othello, WAAug 2, 1976 · N4966X · Substantial damage NTSB SEA77DYE56Accident · No injuriesClosedCessna 150 · Eastsound, WAAug 1, 1976 · N60194 · Destroyed NTSB SEA76FYE50Accident · Minor injuriesClosedCessna 150 · Bellevue, WAJul 31, 1976 · N6837G · Destroyed NTSB SEA76DYE51Accident · No injuriesClosedCessna 172L · Raymond, WAJul 30, 1976 · N19768 · Substantial damage NTSB SEA76DYE49Accident · No injuriesClosedCessna 170A · Toledo, WAJul 24, 1976 · N9702A · Substantial damage NTSB SEA76DYE57Accident · No injuriesClosedCessna 182E · Renton, WAJul 20, 1976 · N9296X · Substantial damage NTSB SEA76FYE48Accident · Minor injuriesClosedCessna 310 · Burlington, WAJul 16, 1976 · N1761H · Substantial damage NTSB SEA76DYE47Accident · No injuriesClosedBeech G35 · Pt Roberts, WAJul 15, 1976 · N4559D · Substantial damage NTSB SEA76DYG65Accident · No injuriesClosedPiper J3C · Moses Lake, WAJul 10, 1976 · N98735 · Substantial damage NTSB SEA76DYG64Accident · No injuriesClosedCessna 170 · Ritzville, WAJul 7, 1976 · N517TG · Substantial damage NTSB SEA76FYG63Accident · No injuriesClosedCessna 150 · Mead, WAJul 5, 1976 · N5962E · Substantial damage NTSB SEA76AS060Accident · 3 fatalClosedPiper PA-22 · Hoquiam, WAJul 3, 1976 · N9344D · Destroyed NTSB SEA76FYG66Accident · 1 fatalClosedRawdon T-1 · Rosalia, WAJul 2, 1976 · N6805D · Destroyed NTSB SEA76DYG60Accident · No injuriesClosedPiper PA-25 · Othello, WAJun 30, 1976 · N4716Y · Destroyed NTSB SEA76FYG61Accident · Minor injuriesClosedPiper PA-25 · Othello, WAJun 29, 1976 · N7588Z · Substantial damage NTSB SEA76FYG58Accident · Serious injuriesClosedPiper PA-28 · Lake Wenatchee, WAJun 27, 1976 · N5188L · Destroyed NTSB SEA76DYI46Accident · No injuriesClosedBell 206B · Westport, WAJun 26, 1976 · N100YB · Substantial damage NTSB SEA76DYG57Accident · Minor injuriesClosedGrumman G-164 · Sunnyside, WAJun 23, 1976 · N4368 · Destroyed NTSB SEA76FYG56Accident · Minor injuriesClosedPiper PA-16 · Colville, WAJun 19, 1976 · N5919H · Substantial damage NTSB SEA76DYE45Accident · Serious injuriesClosedAerospatle SE3133 · Clearwater, WAJun 17, 1976 · N7329 · Destroyed NTSB SEA76FYG53Accident · Minor injuriesClosedBell 47G-2 · Eltopia, WAJun 9, 1976 · N2483B · Destroyed NTSB SEA76FYG54Accident · No injuriesClosedLet-Np-K L-13 · Ephrata, WAJun 5, 1976 · N3460 · Substantial damage NTSB SEA76DYG55Accident · No injuriesClosedSchweizer SGS126 · Waterville, WAJun 5, 1976 · N7562 · Substantial damage NTSB SEA76DYE44Accident · Serious injuriesClosedWoodwind A · Lummi Island, WAJun 5, 1976 · N1429 · Destroyed NTSB SEA76AS054Accident · 3 fatalClosedCessna 172B · Curlew, WAJun 4, 1976 · N6916X · Destroyed NTSB SEA76FYE43Accident · No injuriesClosedCessna 150 · Enumclaw, WAMay 30, 1976 · N64955 · Substantial damage NTSB SEA76DYE42Accident · No injuriesClosedLuscombe 8A · Port Orchard, WAMay 23, 1976 · N71629 · Substantial damage NTSB SEA76AS050Accident · 6 fatalClosedPiper PA-32 · Snoqualamie Ps, WAMay 22, 1976 · N55033 · Destroyed NTSB SEA76DYG52Accident · No injuriesClosedCessna 206 · Spangle, WAMay 14, 1976 · N8013Z · Substantial damage NTSB SEA76DYE41Accident · Minor injuriesClosedBell 47G-3B · Forks, WAMay 12, 1976 · N3794G · Substantial damage NTSB SEA76FYG50Accident · No injuriesClosedBell 47G-3B · Spokane, WAMay 10, 1976 · N58131 · Substantial damage NTSB SEA76FYE40Accident · Serious injuriesClosedTaylorcraft L-2 · Shelton, WAMay 9, 1976 · N58604 · Destroyed NTSB SEA76FYE39Accident · Serious injuriesClosedCessna 172 · Martha Lake, WAMay 9, 1976 · N8597B · Substantial damage NTSB SEA76FYC34Accident · No injuriesClosedStinson 108-3 · Goldendale, WAMay 9, 1976 · N6699M · Substantial damage NTSB SEA76DYG51Accident · No injuriesClosedChampion 7GCBC · Dayton, WAMay 3, 1976 · N3464D · Substantial damage NTSB SEA76FYE38Accident · Minor injuriesClosedCessna 172 · Olympia, WAMay 2, 1976 · C-GHWJ · Substantial damage NTSB SEA76FYG49Accident · 1 fatalClosedGrumman G-164A · Oakesdale, WAApr 30, 1976 · N5357 · Destroyed NTSB SEA76DYE37Accident · No injuriesClosedCessna 185 · Renton, WAApr 29, 1976 · N1468F · Substantial damage NTSB SEA76DYG45Accident · No injuriesClosedBoeing E75N1 · Kennewick, WAApr 22, 1976 · N58978 · Substantial damage NTSB SEA76DYG44Accident · No injuriesClosedBell 47G-3B · Palouse, WAApr 21, 1976 · N2240W · Destroyed NTSB SEA76DYG46Accident · No injuriesClosedCallair A-9A · Wenatchee, WAApr 20, 1976 · N8259H · Substantial damage NTSB SEA76DYE36Accident · No injuriesClosedPiper PA-24 · Center Is, WAApr 16, 1976 · N7899P · Destroyed NTSB SEA76DYG41Accident · No injuriesClosedPiper PA-22 · Sunnyside, WAApr 10, 1976 · N1484C · Substantial damage