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 SEA80DYE22Accident · Minor injuriesClosedAerospatle SA315B · Joyce, WAMar 17, 1980 · N47270 · Destroyed NTSB SEA80FYP14Accident · Serious injuriesClosedCessna A188B · Sprague, WAMar 14, 1980 · N70252 · Destroyed NTSB SEA80FYM20Accident · No injuriesClosedPiper PA-24 · Vancouver, WAMar 6, 1980 · N8943P · Substantial damage NTSB SEA80DYE21Accident · Minor injuriesClosedCessna 150 · Toledo, WAMar 2, 1980 · N5742G · Destroyed NTSB SEA80FYE19Accident · Serious injuriesClosedRepublic RC-3 · Mckenna, WAFeb 28, 1980 · N87576 · Substantial damage NTSB SEA80DYE20Accident · No injuriesClosedCessna 210 · Friday Harbor, WAFeb 28, 1980 · N9402M · Substantial damage NTSB SEA80FYE18Accident · Serious injuriesClosedAerospatle 318C · Aberdeen, WAFeb 27, 1980 · N5593N · Substantial damage NTSB SEA80DYE23Accident · No injuriesClosedBeech 35 · Eastsound, WAFeb 23, 1980 · N3038V · Substantial damage NTSB SEA80DYE15Accident · Minor injuriesClosedHiller Acft UH-12E · Arlington, WAFeb 17, 1980 · N90494 · Substantial damage NTSB SEA80DYE14Accident · No injuriesClosedHughes 369 · Redmond, WAFeb 16, 1980 · N9205F · Substantial damage NTSB SEA80FA019Accident · 5 fatalClosedRockwell 700 · Mukilteo, WAFeb 15, 1980 · N9908S · Destroyed NTSB SEA80DYE13Accident · Minor injuriesClosedS.N.I.A.S. 318C · Forks, WAFeb 15, 1980 · N54591 · Destroyed NTSB SEA80DYE16Accident · No injuriesClosedCessna 172 · Spanaway, WAFeb 10, 1980 · N64266 · Substantial damage NTSB SEA80DYE12Accident · Minor injuriesClosedPiper PA-28 · Yelm, WAFeb 7, 1980 · N47576 · Destroyed NTSB SEA80DYP13Accident · No injuriesClosedPiper PA-22 · Colville, WAFeb 4, 1980 · N4823Z · Substantial damage NTSB SEA80FYP10Accident · No injuriesClosedCessna 182P · Richland, WAJan 29, 1980 · N1668M · Substantial damage NTSB SEA80DYP08Accident · Minor injuriesClosedCessna 182RG · Moses Lake, WAJan 26, 1980 · N2244T · Substantial damage NTSB SEA80DYE11Accident · No injuriesClosedCessna 305A · Auburn, WAJan 26, 1980 · N5263G · Substantial damage NTSB SEA80DYP11Accident · No injuriesClosedBeech C90 · Ellensburg, WAJan 25, 1980 · N444PS · Substantial damage NTSB SEA80FA017Accident · 1 fatalClosedAeronca 7AC · Stevenson, WAJan 23, 1980 · N83586 · Destroyed NTSB SEA80FYP09Accident · No injuriesClosedSnow 600S2C · Washtucna, WAJan 18, 1980 · N1626S · Substantial damage NTSB SEA80DYP07Accident · No injuriesClosedCessna 340 · Yakima, WAJan 11, 1980 · N5165J · Substantial damage NTSB SEA80FYE10Accident · Minor injuriesClosedHughes 369D · Mt.Vernon, WADec 22, 1979 · N8303F · Substantial damage NTSB SEA80FA047Accident · 4 fatalClosedPiper PA-24 · White Pass, WADec 11, 1979 · N6171P · Destroyed NTSB SEA80FA013Accident · 1 fatalClosedCessna T210M · Pasco, WADec 8, 1979 · N732QJ · Destroyed NTSB SEA80FYE09Accident · Serious injuriesClosedCessna 152 · Freeland, WADec 1, 1979 · N48129 · Substantial damage NTSB SEA80FYP05Accident · Minor injuriesClosedCessna 150E · Moses Lake, WANov 26, 1979 · N4098U · Substantial damage NTSB SEA80FA008Accident · 2 fatalClosedNavion A · Kent, WANov 23, 1979 · N4804K · Destroyed NTSB SEA80FA007Accident · 2 fatalClosedCessna T210M · Yakima, WANov 21, 1979 · N321TT · Substantial damage NTSB SEA80IA006Incident · No injuriesClosedBeech 99 · Yakima, WANov 14, 1979 · N8012R · Minor damage NTSB SEA80DYE08Accident · Serious injuriesClosedPiper PA-18 · Lynnwood, WANov 13, 1979 · N4122E · Substantial damage NTSB SEA80DYP03Accident · No injuriesClosedBellanca 7KCAB · College Place, WANov 11, 1979 · N2680Z · Substantial damage NTSB SEA80FYE07Accident · Minor injuriesClosedMaule M-5 · Maple Valley, WANov 9, 1979 · N376X · Destroyed NTSB SEA80DYE06Accident · No injuriesClosedAero Comdr 112A · Vashon Island, WANov 7, 1979 · N1478J · Substantial damage NTSB SEA80DYE05Accident · No injuriesClosedHiller Acft UH-12E · Neah Bay, WAOct 31, 1979 · N87977 · Substantial damage NTSB SEA80DYE03Accident · No injuriesClosedHiller Acft UH-12D · Amanda Park, WAOct 29, 1979 · N62377 · Substantial damage NTSB SEA80DYE02Accident · No injuriesClosedPiper PA-28R · Roche Harbor, WAOct 28, 1979 · N816J · Substantial damage NTSB SEA80DYE04Accident · No injuriesClosedMooney M20C · Everett, WAOct 27, 1979 · N6961U · Substantial damage NTSB SEA80FA004Accident · 2 fatalClosedCessna 177RG · Ephrata, WAOct 18, 1979 · N34948 · Destroyed NTSB SEA80DYP02Accident · No injuriesClosedCessna 150 · Ritzville, WAOct 8, 1979 · N6649T · Substantial damage NTSB SEA80FA001Accident · 1 fatalClosedCessna 150F · Arlington, WAOct 7, 1979 · N3033X · Destroyed NTSB SEA80DYE01Accident · No injuriesClosedCessna 170B · Copalis Beach, WAOct 6, 1979 · N3160A · Substantial damage NTSB SEA79FYM70Accident · No injuriesClosedCessna 150 · Vancouver, WASep 30, 1979 · N60420 · Substantial damage NTSB SEA79DYP43Accident · No injuriesClosedCessna 150L · Yakima, WASep 30, 1979 · N11633 · Substantial damage NTSB SEA79FYM69Accident · Serious injuriesClosedMoots BD-4 · Battle Ground, WASep 27, 1979 · N17127 · Substantial damage NTSB SEA79DYE49Accident · No injuriesClosedCessna R172K · Bellingham, WASep 22, 1979 · N6417K · Substantial damage NTSB SEA79FYP42Accident · No injuriesClosedCessna P337 · Spokane, WASep 21, 1979 · N5JU · Substantial damage NTSB SEA79DYE44Accident · No injuriesClosedCessna 172 · Spanaway, WASep 18, 1979 · N73524 · Substantial damage NTSB SEA79DYM65Accident · No injuriesClosedEnstrom 280C · Vancouver, WASep 17, 1979 · N222NT · Substantial damage NTSB SEA79DYE46Accident · No injuriesClosedCessna 152 · Rochester, WASep 16, 1979 · N68267 · Substantial damage