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 SEA80FA041Accident · No injuriesClosedCessna R172K · Renton, WAAug 11, 1980 · N736UN · Substantial damage NTSB SEA80FYE50Accident · Minor injuriesClosedCessna 182A · Issaquah, WAAug 9, 1980 · N3890D · Substantial damage NTSB SEA80DYE53Accident · No injuriesClosedCessna 177B · Olympia, WAAug 6, 1980 · N13310 · Substantial damage NTSB SEA80DYE49Accident · No injuriesClosedAeronca 7AC · Kent, WAAug 3, 1980 · N3011E · Substantial damage NTSB SEA80DYE48Accident · No injuriesClosedBeech C24R · Roche Harbor, WAJul 31, 1980 · N23843 · Substantial damage NTSB SEA80DYE45Accident · No injuriesClosedPiper PA-28 · Forks, WAJul 30, 1980 · N38376 · Substantial damage NTSB SEA80DYE47Accident · 2 fatalClosedCoot B · Kelso, WAJul 26, 1980 · N7141 · Destroyed NTSB SEA80FYE42Accident · Serious injuriesClosedBeech A36TC · Seattle, WAJul 21, 1980 · N66811 · Destroyed NTSB SEA80FYP29Accident · No injuriesClosedCessna TU206F · Sunnyside, WAJul 20, 1980 · N7470Q · Substantial damage NTSB SEA80FYE43Accident · Minor injuriesClosedPiper PA-28 · Gardner, WAJul 20, 1980 · N3576B · Destroyed NTSB SEA80FYP28Accident · Minor injuriesClosedTexas Hel OH-13H · Moses Lake, WAJul 19, 1980 · N51855 · Substantial damage NTSB SEA80DYE44Accident · No injuriesClosedBeech A23 · Morton, WAJul 18, 1980 · N1466L · Destroyed NTSB SEA80FA037Accident · 2 fatalClosedCessna 170A · Clinton, WAJul 17, 1980 · N1713D · 2 aircraft · Destroyed NTSB SEA80FYP27Accident · Serious injuriesClosedCessna 177RG · Ione, WAJul 16, 1980 · N1891Q · Substantial damage NTSB SEA80DYP30Accident · No injuriesClosedCessna 152 · Spokane, WAJul 6, 1980 · N89310 · Substantial damage NTSB SEA80FYP26Accident · Minor injuriesClosedBell 47G-4 · Mattawa, WAJul 5, 1980 · N6786D · Substantial damage NTSB SEA80DYE40Accident · No injuriesClosedCessna 150 · Seattle, WAJul 5, 1980 · N19527 · Destroyed NTSB SEA80FYE39Accident · 1 fatalClosedVarieze 1 · Arlington, WAJul 1, 1980 · N752EZ · Destroyed NTSB SEA80DYE38Accident · Minor injuriesClosedPiper PA-22 · Silverdale, WAJun 30, 1980 · N4558A · Substantial damage NTSB SEA80DYE37Accident · Minor injuriesClosedCessna 182 · Marblemount, WAJun 28, 1980 · N3901D · Destroyed NTSB SEA80FYE36Accident · Minor injuriesClosedCessna 195 · Yelm, WAJun 19, 1980 · N4388N · Substantial damage NTSB SEA80DYP24Accident · No injuriesClosedPiper PA-12 · Pasco, WAJun 19, 1980 · N3309M · Substantial damage NTSB SEA80DYE41Accident · No injuriesClosedSchweizer SGS126 · Issaquah, WAJun 19, 1980 · N65952 · Substantial damage NTSB SEA80FA034Accident · 2 fatalClosedCessna 150K · Olympia, WAJun 18, 1980 · N6145G · Destroyed NTSB SEA80FYP23Accident · Minor injuriesClosedCessna 150 · Wenatchee, WAJun 11, 1980 · N5469Q · Substantial damage NTSB SEA80FA033Accident · 3 fatalClosedCessna 177 · Mineral, WAJun 11, 1980 · N2235Y · Destroyed NTSB SEA80DYE35Accident · No injuriesClosedPiper PA-38 · Auburn, WAJun 11, 1980 · N9274T · Substantial damage NTSB SEA80FYP22Accident · No injuriesClosedMaule M-5 · Winona, WAJun 9, 1980 · N62030 · Substantial damage NTSB SEA80DYE34Accident · No injuriesClosedPiper PA-25 · Sequim, WAJun 4, 1980 · N7763Z · Substantial damage NTSB SEA80FYM39Accident · Serious injuriesClosedCessna 180K · Vancouver, WAMay 28, 1980 · N180GD · Substantial damage NTSB SEA80FA030Accident · No injuriesClosedBell 206B · Winslow, WAMay 26, 1980 · N5016Q · 2 aircraft · Substantial damage NTSB SEA80FA029Accident · 1 fatalClosedGrumman G-164B · Cle Elum, WAMay 18, 1980 · N48432 · Destroyed NTSB SEA80DYP21Accident · Minor injuriesClosedCessna 152 · Buena, WAMay 17, 1980 · N757SC · Substantial damage NTSB SEA80DYE32Accident · Serious injuriesClosedHiller Acft UH-12E · Forks, WAMay 15, 1980 · N5359V · Destroyed NTSB SEA80FYM34Accident · No injuriesClosedCessna T210L · Vancouver, WAMay 9, 1980 · N93368 · Substantial damage NTSB SEA80FYP20Accident · 1 fatalClosedPage RV-3 · Prosser, WAApr 26, 1980 · N8385 · Substantial damage NTSB SEA80DYE33Accident · No injuriesClosedGR Lakes 2T-1A2 · Enumclaw, WAApr 26, 1980 · N6271L · Substantial damage NTSB SEA80FYP19Accident · No injuriesClosedBeech 23 · Quincy, WAApr 18, 1980 · N2307Z · Substantial damage NTSB SEA80FYE31Accident · No injuriesClosedRepublic RC-3 · Port Angeles, WAApr 18, 1980 · N6470K · Substantial damage NTSB SEA80DYP18Accident · No injuriesClosedPiper PA-18 · Pullman, WAApr 13, 1980 · N7149K · Substantial damage NTSB SEA80DYE29Accident · No injuriesClosedCessna 172 · Bellingham, WAApr 13, 1980 · N3413E · Substantial damage NTSB SEA80DYE28Accident · Minor injuriesClosedCessna 172 · Concrete, WAApr 12, 1980 · N79242 · Destroyed NTSB SEA80FYP15Accident · No injuriesClosedPiper PA-28 · Spokane, WAApr 7, 1980 · N212P · Substantial damage NTSB SEA80DYE27Accident · Serious injuriesClosedCessna 182P · Castle Rock, WAApr 3, 1980 · N1340S · Destroyed NTSB SEA80FYP17Accident · No injuriesClosedCessna 150G · Grandview, WAApr 1, 1980 · N2681J · Substantial damage NTSB SEA80FA023Accident · 1 fatalClosedCessna 150L · Rosalia, WAApr 1, 1980 · N11217 · Destroyed NTSB SEA80FA022Accident · 3 fatalClosedCessna 172N · Trout Lake, WAApr 1, 1980 · N5169E · Destroyed NTSB SEA80DYE26Accident · No injuriesClosedCessna 177 · Lester, WAMar 30, 1980 · N3283T · Destroyed NTSB SEA80FYE25Accident · No injuriesClosedCessna 175 · Bellevue, WAMar 29, 1980 · N9467B · Substantial damage NTSB SEA80FYE24Accident · No injuriesClosedPiper PA-11 · Carbonado, WAMar 20, 1980 · N9013K · Substantial damage