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 SEA77DYP35Accident · No injuriesClosedCessna 188 · Connell, WAAug 3, 1977 · N72414 · Substantial damage NTSB SEA77FYP34Accident · Serious injuriesClosedPiper PA-28 · Mattawa, WAAug 1, 1977 · N9507J · Substantial damage NTSB SEA77DYP26Accident · No injuriesClosedPiper PA-25 · Quincy, WAJul 28, 1977 · N8850L · Substantial damage NTSB SEA77DYP33Accident · No injuriesClosedAero Comdr 600S2R · Othello, WAJul 27, 1977 · N1500R · Substantial damage NTSB SEA77FA042Accident · 1 fatalClosedKr-2 · Arlington, WAJul 24, 1977 · N43TS · Destroyed NTSB SEA77DYK20Accident · No injuriesClosedEnstrom F28C · Medford, WAJul 22, 1977 · N51727 · Substantial damage NTSB SEA77FYE29Accident · 1 fatalClosedTaylor B8M · Shelton, WAJul 19, 1977 · N65360 · Destroyed NTSB SEA77DYE30Accident · Minor injuriesClosedWulle VP2 · Ferndale, WAJul 18, 1977 · N5596 · Destroyed NTSB SEA77FA044Accident · No injuriesClosedPiper PA-32 · Coulee City, WAJul 17, 1977 · N55653 · Substantial damage NTSB SEA77FYE27Accident · Minor injuriesClosedCessna 172 · Olga, WAJul 8, 1977 · N8441X · Substantial damage NTSB SEA77FYP32Accident · No injuriesClosedStearman A75N1 · Hunters, WAJul 1, 1977 · N68200 · Substantial damage NTSB SEA77DYE32Accident · No injuriesClosedCessna 182 · South Bend, WAJun 28, 1977 · N3553U · Substantial damage NTSB SEA77DYE26Accident · No injuriesClosedPiper PA-20 · Seattle, WAJun 24, 1977 · N6895K · Substantial damage NTSB SEA77FYE28Accident · No injuriesClosedCessna 180 · Alderwood Mnr, WAJun 23, 1977 · N7521K · Substantial damage NTSB SEA77FYE25Accident · 1 fatalClosedCessna 310Q · Arlington, WAJun 23, 1977 · N7709Q · Destroyed NTSB SEA77DYP31Accident · No injuriesClosedCessna 188A · Warden, WAJun 23, 1977 · N70296 · Substantial damage NTSB SEA77FYE24Accident · Serious injuriesClosedHiller Acft 12C · Mt Vernon, WAJun 17, 1977 · N5330V · Destroyed NTSB SEA77DYE23Accident · No injuriesClosedLuscombe 8A · Orcas Island, WAJun 12, 1977 · N72041 · Destroyed NTSB SEA77FYP30Accident · Minor injuriesClosedBurkhrt GRB G102 · Ephrata, WAJun 11, 1977 · N11U · Substantial damage NTSB SEA77FA039Accident · 4 fatalClosedPiper PA-28 · Spokane, WAJun 7, 1977 · N2161T · Destroyed NTSB SEA77FYE21Accident · No injuriesClosedAmer Avco AA-1B · Silvana, WAJun 6, 1977 · N9950L · Substantial damage NTSB SEA77FA035Accident · 2 fatalClosedTaylorcraft L-2B · Yelm, WAMay 30, 1977 · N50290 · Destroyed NTSB SEA77DYP27Accident · Minor injuriesClosedSchleicher ASW-19 · Waterville, WAMay 29, 1977 · N19FZ · Substantial damage NTSB SEA77FYP25Accident · No injuriesClosedPiper PA-24 · Spokane, WAMay 22, 1977 · N6487P · Substantial damage NTSB SEA77IA034Incident · No injuriesClosedBeech 65-80 · Tacoma, WAMay 17, 1977 · N18 · No damage NTSB SEA77FYE20Accident · No injuriesClosedCub J3-65 · Issaquah, WAMay 17, 1977 · NONE · Substantial damage NTSB SEA77FYE18Accident · Minor injuriesClosedLuscombe 8A · Alderwood Mnr, WAMay 15, 1977 · N1289K · Substantial damage NTSB SEA77FYE19Accident · No injuriesClosedBell 47D1 · Enumclaw, WAMay 14, 1977 · N17301 · Substantial damage NTSB SEA77DYM31Accident · No injuriesClosedPiper J-3 · Yacolt, WAMay 14, 1977 · N42448 · Destroyed NTSB SEA77FA030Accident · 1 fatalClosedBeech 58 · Vancouver, WAMay 2, 1977 · N83BB · Substantial damage NTSB SEA77FYP24Accident · Serious injuriesClosedEaa Biplane P · Kennewick, WAMay 1, 1977 · N168K · Substantial damage NTSB SEA77FYE17Accident · No injuriesClosedBellanca 14-13 · Maple Valley, WAMay 1, 1977 · N86726 · Substantial damage NTSB SEA77DYE22Accident · No injuriesClosedStearman A75N1 · Port Angeles, WAApr 29, 1977 · N5728N · Substantial damage NTSB SEA77FYP29Accident · No injuriesClosedBell 47G3B1 · Pomeroy, WAApr 26, 1977 · N73919 · Substantial damage NTSB SEA77FYP23Accident · No injuriesClosedCessna 185 · Waterville, WAApr 24, 1977 · N2583S · Substantial damage NTSB SEA77FYE16Accident · Serious injuriesClosedCessna 172 · Sultan, WAApr 23, 1977 · N1736F · Substantial damage NTSB SEA77FYM29Accident · Minor injuriesClosedCessna 140 · Vancouver, WAApr 21, 1977 · N89672 · Substantial damage NTSB SEA77DYM28Accident · Minor injuriesClosedAeronca 7AC · Vancouver, WAApr 11, 1977 · N82960 · Substantial damage NTSB SEA77FA027Accident · 3 fatalClosedCessna 182P · Port Orchard, WAApr 10, 1977 · N1282S · Destroyed NTSB SEA77FA025Accident · 2 fatalClosedPiper PA-28 · Sekiu, WAApr 4, 1977 · N32948 · Destroyed NTSB SEA77FA024Accident · 2 fatalClosedBell 214B-1 · Liberty, WAMar 31, 1977 · N90128 · Destroyed NTSB SEA77FA023Accident · 2 fatalClosedBeech B19 · Ephrata, WAMar 30, 1977 · N24012 · Destroyed NTSB SEA77DYP20Accident · No injuriesClosedPiper PA-20 · Moses Lake, WAMar 28, 1977 · N7481K · Substantial damage NTSB SEA77DYE15Accident · Minor injuriesClosedVolmer VT22 · Langley, WAMar 24, 1977 · N117JS · Destroyed NTSB SEA77FYE12Accident · 2 fatalClosedN.American P-51D · Olympia, WAMar 19, 1977 · N6526D · Destroyed NTSB SEA77DYE14Accident · Minor injuriesClosedPiper PA-28 · Westport, WAMar 19, 1977 · N75331 · Substantial damage NTSB SEA77DYE13Accident · Minor injuriesClosedHelton LARK95 · Federal Way, WAMar 19, 1977 · N1511H · Destroyed NTSB SEA77FYE11Accident · Serious injuriesClosedPiper PA-28 · Renton, WAMar 12, 1977 · C-GIEH · Destroyed NTSB SEA77DYE10Accident · No injuriesClosedCessna 150 · Gardiner, WAMar 6, 1977 · N5911E · Substantial damage NTSB SEA77DYPI9Accident · No injuriesClosedCessna 172 · Kennewick, WAFeb 16, 1977 · N8493U · Substantial damage