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 SEA79FYM36Accident · No injuriesClosedCessna T210 · Vancouver, WAMay 22, 1979 · N6886R · Substantial damage NTSB SEA79DYE22Accident · No injuriesClosedCessna 185 · Bellevue, WAMay 17, 1979 · N4903C · Substantial damage NTSB SEA79DYP20Accident · No injuriesClosedEL Tomcat MK5A · Moses Lake, WAMay 15, 1979 · N9044T · Destroyed NTSB SEA79FYP21Accident · Serious injuriesClosedThorp T-18 · Zillah, WAMay 11, 1979 · N1947 · Destroyed NTSB SEA79DYP19Accident · No injuriesClosedBeech G-35 · Mattawa, WAMay 11, 1979 · N191B · Substantial damage NTSB SEA79FYP17Accident · Minor injuriesClosedHughes 369D · Spokane, WAMay 9, 1979 · N8601F · Substantial damage NTSB SEA79FYP18Accident · No injuriesClosedCessna 152 · Cashmere, WAMay 7, 1979 · N24887 · Substantial damage NTSB SEA79FA033Accident · 1 fatalClosedCessna 182Q · Quilcene, WAApr 30, 1979 · N759EZ · Destroyed NTSB SEA79FYP15Accident · 1 fatalClosedCallair A-9 · Dayton, WAApr 29, 1979 · N8259H · Destroyed NTSB SEA79DYE21Accident · No injuriesClosedCessna 150 · Curtiss, WAApr 29, 1979 · N19041 · Destroyed NTSB SEA79DYP14Accident · No injuriesClosedBell 47G-3B · Wenatchee, WAApr 26, 1979 · N6712D · Substantial damage NTSB SEA79DYP23Accident · No injuriesClosedPiper PA-36 · Mesa, WAApr 25, 1979 · N9901P · Substantial damage NTSB SEA79DYE40Accident · No injuriesClosedCessna 185 · Tolt Reservoir, WAApr 22, 1979 · N4924Q · Substantial damage NTSB SEA79DYE19Accident · No injuriesClosedConvair L-13 · Snohomish, WAApr 21, 1979 · N4659V · Substantial damage NTSB SEA79FYP12Accident · Minor injuriesClosedWeatherly 201B · Pomeroy, WAApr 14, 1979 · N1258W · Substantial damage NTSB SEA79DYM26Accident · Minor injuriesClosedCessna 150 · Camas, WAApr 12, 1979 · N60053 · Substantial damage NTSB SEA79AA029Accident · 1 fatalClosedHiller UH12D · Chehalis, WAApr 3, 1979 · N64867 · Minor damage NTSB SEA79DYM24Incident · No injuriesClosedPiper PA-28 · Green Mountain, WAApr 1, 1979 · N30216 · Minor damage NTSB SEA79FYM22Accident · Minor injuriesClosedPiper J3C-65 · Camas, WAMar 24, 1979 · N1326N · Substantial damage NTSB SEA79FYM21Accident · Serious injuriesClosedBeech A45 · Goldendale, WAMar 19, 1979 · N9133R · Substantial damage NTSB SEA79FA025Accident · 2 fatalClosedTaylorcraft BC-65 · Orting, WAMar 17, 1979 · N23633 · Destroyed NTSB SEA79DYE18Accident · No injuriesClosedGlobe GC-1B · Tenino, WAMar 13, 1979 · N3357K · Substantial damage NTSB SEA79FA024Accident · 1 fatalClosedCessna 195 · Vancouver, WAMar 9, 1979 · N195BC · Destroyed NTSB SEA79FYE17Accident · No injuriesClosedCessna 152 · Seattle, WAMar 8, 1979 · N24353 · 2 aircraft · Substantial damage NTSB SEA79FA023Accident · 3 fatalClosedLake 4-200 · Battle Ground, WAMar 7, 1979 · N1229L · Destroyed NTSB SEA79DYE16Accident · No injuriesClosedCessna 150 · Seattle, WAMar 3, 1979 · N8529G · Substantial damage NTSB SEA79FA022Accident · 2 fatalClosedCessna 140 · Yakima, WAMar 1, 1979 · N1701N · Destroyed NTSB SEA79DYE15Accident · 1 fatalClosedRobertson P210N · Port Townsend, WAMar 1, 1979 · N4797P · Destroyed NTSB SEA79DYE14Accident · No injuriesClosedErco 415-C · Auburn, WAFeb 18, 1979 · N3276H · Substantial damage NTSB SEA79FYM16Accident · No injuriesClosedCessna 182 · Dallesport, WAFeb 10, 1979 · N9117G · Substantial damage NTSB SEA79FA034Accident · 2 fatalClosedCessna 172 · Camas, WAFeb 9, 1979 · N12752 · Destroyed NTSB SEA79DYP11Accident · No injuriesClosedPiper PA-28 · Kennewick, WAFeb 9, 1979 · N9116K · Substantial damage NTSB SEA79FYE12Accident · No injuriesClosedCessna 182 · Parkland, WAJan 31, 1979 · N58454 · Substantial damage NTSB SEA79DYE13Accident · No injuriesClosedCessna 140 · Mt.Rainier, WAJan 29, 1979 · N4108N · Substantial damage NTSB SEA79DYP08Accident · No injuriesClosedCessna 182 · Walla Walla, WAJan 26, 1979 · N9909M · Substantial damage NTSB SEA79DYE11Accident · Minor injuriesClosedHughes 369HS · Aberdeen, WAJan 22, 1979 · N9256F · Substantial damage NTSB SEA79FA019Accident · 1 fatalClosedCessna 182P · Seattle, WAJan 17, 1979 · N8483M · Destroyed NTSB SEA79DYM10Accident · No injuriesClosedStinson 108-3 · Dallesport, WAJan 14, 1979 · N6470M · Substantial damage NTSB SEA79DYE10Accident · No injuriesClosedPiper PA-28 · Oak Harbor, WAJan 7, 1979 · N38373 · Substantial damage NTSB SEA79FYE09Accident · Serious injuriesClosedCessna 172 · Kent, WAJan 2, 1979 · N1327E · Substantial damage NTSB SEA83FA064Accident · 2 fatalClosedPiper PA-28 · North Bend, WADec 23, 1978 · N95172 · Destroyed NTSB SEA79DYE08Accident · Minor injuriesClosedAmer Avco AA1-C · Everett, WADec 6, 1978 · N9711U · Substantial damage NTSB SEA79FYE07Accident · Minor injuriesClosedCessna 150 · Issaquah, WADec 3, 1978 · N12MM · Destroyed NTSB SEA79DYP06Accident · No injuriesClosedCessna 180 · Connell, WADec 3, 1978 · N7616K · Substantial damage NTSB SEA79FYP04Accident · 1 fatalClosedCessna R172K · Dayton, WADec 1, 1978 · N736TH · Destroyed NTSB SEA79FYE06Accident · No injuriesClosedPiper PA-28 · Bremerton, WANov 24, 1978 · N8402C · Substantial damage NTSB SEA79FA013Accident · Minor injuriesClosedPiper PA-28 · Bellingham, WANov 16, 1978 · N47226 · Destroyed NTSB SEA79FYP03Accident · Serious injuriesClosedCessna 150A · Easton, WANov 15, 1978 · N7195X · Substantial damage NTSB SEA79DYE05Accident · No injuriesClosedCessna 172 · Orcas Island, WANov 13, 1978 · N734VX · Substantial damage NTSB SEA79DYE03Accident · No injuriesClosedEvans VP-1 · Yelm, WANov 12, 1978 · N6949 · Substantial damage