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 SEA76FYG16Accident · No injuriesClosedGlobe GC-1B · Kennewick, WASep 28, 1975 · N3390K · Substantial damage NTSB SEA76DYG21Accident · No injuriesClosedCessna 206 · Pasco, WASep 18, 1975 · N2102F · Substantial damage NTSB SEA76AS017Accident · 1 fatalClosedCessna 150L · Kalama, WASep 18, 1975 · N16187 · Substantial damage NTSB SEA7LDYE16Accident · No injuriesClosedHiller Acft UH-12E · Randle, WASep 15, 1975 · N102EH · Destroyed NTSB SEA76DYG14Accident · No injuriesClosedPiper PA-24 · Richland, WASep 14, 1975 · N5829P · Substantial damage NTSB SEA76DYG13Accident · No injuriesClosedPiper PA-25 · Odessa, WASep 7, 1975 · N7491Z · Substantial damage NTSB SEA76DYG15Accident · No injuriesClosedBell 47G5 · Basin City, WASep 6, 1975 · N1420 · Substantial damage NTSB SEA76DYE15Accident · No injuriesClosedAmer Avco AA1 · Hoquiam, WASep 6, 1975 · N6146L · Substantial damage NTSB SEA76DYG12Accident · No injuriesClosedCessna 188 · Monitor, WASep 5, 1975 · N9083G · Substantial damage NTSB SEA76DYE14Accident · No injuriesClosedHiller Acft UH-12E · Randle, WASep 5, 1975 · N5344V · Destroyed NTSB SEA76DYC16Accident · No injuriesClosedCessna 150 · Kelso, WASep 5, 1975 · N18661 · Substantial damage NTSB SEA76FYE13Accident · No injuriesClosedDehavilland DHC-3 · Auburn, WASep 4, 1975 · N567AA · Substantial damage NTSB SEA76DYC15Accident · No injuriesClosedCessna 150 · Battleground, WASep 3, 1975 · N51053 · Substantial damage NTSB SEA76AB016Accident · 1 fatalClosedCessna 150K · Vancouver, WASep 2, 1975 · N5716G · Destroyed NTSB SEA76AS015Accident · 1 fatalClosedCessna 210 · Bellevue, WAAug 28, 1975 · N7478E · Destroyed NTSB SEA76FYE12Accident · Serious injuriesClosedCessna 205 · Spanaway, WAAug 27, 1975 · N8298Z · Substantial damage NTSB SEA76FYC14Accident · No injuriesClosedLuscombe 8A · Vancouver, WAAug 26, 1975 · N2267K · Substantial damage NTSB SEA76DYG09Accident · No injuriesClosedCessna 150 · Ellensburg, WAAug 26, 1975 · N3270J · Substantial damage NTSB SEA76AS014Accident · 2 fatalClosedCessna 182A · Cyrstal Mtn, WAAug 25, 1975 · N4783D · Destroyed NTSB SEA76AS013Accident · 1 fatalClosedBellanca 14-13 · Snoqualmie Pss, WAAug 24, 1975 · N74265 · Destroyed NTSB SEA76AS012Accident · 2 fatalClosedCessna 182P · Brinnon, WAAug 21, 1975 · N21022 · Destroyed NTSB SEA76DYE11Accident · No injuriesClosedSchleicher ASW-15 · Packwood, WAAug 17, 1975 · N15FZ · Destroyed NTSB LAX76AL012Accident · 1 fatalClosedPiper PA-18 · Tacoma, WAAug 17, 1975 · N4270Z · Destroyed NTSB SEA76DYE09Accident · No injuriesClosedDehavilland DHC-2 · Kent, WAAug 14, 1975 · N5162G · Substantial damage NTSB SEA76DYE10Accident · No injuriesClosedHiller Acft UH-12E · Forks, WAAug 13, 1975 · N2HL · Substantial damage NTSB SEA76DYG08Accident · No injuriesClosedCessna 177 · Quincy, WAAug 11, 1975 · N177JM · Destroyed NTSB SEA76DYE07Accident · No injuriesClosedChampion 7GCAA · Vashon Island, WAAug 10, 1975 · N6326N · Substantial damage NTSB SEA76AS010Accident · 4 fatalClosedBeech G35 · Bellingham, WAAug 10, 1975 · N4500D · Destroyed NTSB SEA76DYG11Accident · No injuriesClosedCessna 175 · Nason Creek, WAAug 9, 1975 · N6555E · Substantial damage NTSB SEA76DYG07Accident · No injuriesClosedCessna 182E · Republic, WAAug 9, 1975 · N9270X · Substantial damage NTSB SEA76DYE06Accident · No injuriesClosedMooney M20 · Tulalip, WAAug 9, 1975 · N6181U · Destroyed NTSB SEA76DYE07Accident · No injuriesClosedHiller Acft FH1100 · Shelton, WAAug 8, 1975 · N5060F · Substantial damage NTSB SEA76DYE05Accident · Minor injuriesClosedAmer Avco AA1 · Everson, WAJul 31, 1975 · CF-HRF · Substantial damage NTSB SEA76AS008Accident · 2 fatalClosedPiper J-3 · Quincy, WAJul 30, 1975 · N98280 · Destroyed NTSB SEA76IS005Incident · No injuriesClosedDouglas DC-10 · Seattle, WAJul 25, 1975 · N68047 · No damage NTSB SEA76DYE03Accident · No injuriesClosedLuscombe 8F · Bremerton, WAJul 19, 1975 · N1489B · Substantial damage NTSB SEA76FYC05Accident · Minor injuriesClosedStinson 108-3 · Goldendale, WAJul 18, 1975 · N614C · Substantial damage NTSB SEA7LAS002Accident · 1 fatalClosedPiper PA-28 · Spokane, WAJul 14, 1975 · N41467 · Destroyed NTSB SEA76DYG05Accident · No injuriesClosedPiper PA-25 · Quincy, WAJul 12, 1975 · N9546P · Substantial damage NTSB SEA76AS003Accident · 2 fatalClosedCessna 172M · Stevenson, WAJul 12, 1975 · N9832V · Destroyed NTSB SEA76DYG04Accident · Minor injuriesClosedPiper PA-25 · Pasco, WAJul 11, 1975 · N6525Z · Substantial damage NTSB SEA76DYE04Accident · Minor injuriesClosedPiper PA-18 · North Bend, WAJul 11, 1975 · N1269A · Substantial damage NTSB SEA76AS004Accident · 3 fatalClosedCessna 195 · North Bend, WAJul 10, 1975 · N2179C · Destroyed NTSB SEA76DYG03Accident · No injuriesClosedEL Tomcat MK5A · Moses Lake, WAJul 9, 1975 · N863Z · Substantial damage NTSB SEA76DYG02Accident · No injuriesClosedSnow S2C · Oakesdale, WAJul 8, 1975 · N16691 · Substantial damage NTSB SEA7LFYE02Accident · Minor injuriesClosedHughes 369HS · Elma, WAJul 2, 1975 · N82AL · Substantial damage NTSB SEA7LFYE01Accident · Serious injuriesClosedCessna 210L · Seattle, WAJul 2, 1975 · N5150Q · Destroyed NTSB SEA76DYG01Accident · Minor injuriesClosedBell 47G-2 · Moses Lake, WAJul 1, 1975 · N984B · Destroyed NTSB SEA75DYG48Accident · No injuriesClosedCessna 182 · Cashmere, WAJun 30, 1975 · N6088J · Substantial damage NTSB SEA75DYC45Accident · No injuriesClosedCessna 185 · Dallesport, WAJun 29, 1975 · N9829X · Substantial damage