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 SEA74DYE11Accident · No injuriesClosedCessna 140A · Tacoma, WASep 7, 1973 · N5396C · Substantial damage NTSB SEA74FYG14Accident · Minor injuriesClosedCessna 150F · La Crosse, WASep 4, 1973 · N8678S · Destroyed NTSB SEA74DYE10Accident · No injuriesClosedHughes 269B · Puyallup, WASep 4, 1973 · N9432F · Substantial damage NTSB SEA74DYE09Accident · No injuriesClosedBell 205-A1 · Lester, WASep 2, 1973 · N1440W · Destroyed NTSB SEA74FYG16Accident · No injuriesClosedPiper PA-28 · Colville, WAAug 31, 1973 · N4557J · Substantial damage NTSB SEA74AS013Accident · 2 fatalClosedCessna 172 · Packwood, WAAug 30, 1973 · N3843Q · Destroyed NTSB SEA74FYG13Accident · Serious injuriesClosedHughes 369HS · Packwood, WAAug 26, 1973 · N9043F · Destroyed NTSB SEA74AS009Accident · 4 fatalClosedPiper PA-28 · Eatonville, WAAug 23, 1973 · N15587 · Destroyed NTSB SEA74DYE14Accident · No injuriesClosedCessna 150 · Federal Way, WAAug 21, 1973 · N7296S · Substantial damage NTSB SEA74DVG12Accident · No injuriesClosedCessna 210C · Spokane, WAAug 16, 1973 · N3968Y · Substantial damage NTSB SEA74FYG08Accident · Serious injuriesClosedBell 47J-2A · Inchelium, WAAug 8, 1973 · N8439E · Destroyed NTSB SEA74FYC08Accident · Minor injuriesClosedCessna 150 · Vancouver, WAAug 7, 1973 · N7962F · Substantial damage NTSB SEA74DYG10Accident · No injuriesClosedBell 47G3B2 · Tonasket, WAAug 3, 1973 · N78255 · Substantial damage NTSB SEA74FYE08Accident · Minor injuriesClosedCessna 172 · Kent, WAAug 2, 1973 · N7241Q · Substantial damage NTSB SEA74DYG05Accident · No injuriesClosedCessna 150 · Pullman, WAJul 27, 1973 · N16058 · Substantial damage NTSB SEA74DYG06Accident · No injuriesClosedSchemp SHK-1 · Ephrata, WAJul 22, 1973 · N1582 · Substantial damage NTSB SEA74DYC03Accident · Minor injuriesClosedChampion 7SC · Moro, WAJul 20, 1973 · CF-VFY · Substantial damage NTSB SEA74DYG04Accident · No injuriesClosedPiper PA-28R · Chelan, WAJul 18, 1973 · N55699 · Substantial damage NTSB SEA74AS003Accident · 2 fatalClosedCessna 175 · Neah Bay, WAJul 18, 1973 · N7310M · Destroyed NTSB SEA74FYG01Accident · Minor injuriesClosedGrumman G164 · Sunnyside, WAJul 17, 1973 · N4368 · Substantial damage NTSB SEA74FYE07Accident · Minor injuriesClosedKaman H-43A · Sultan, WAJul 16, 1973 · N2855J · Destroyed NTSB SEA73FYG03Accident · Serious injuriesClosedPiper PA-25 · Pasco, WAJul 14, 1973 · N7478Z · Destroyed NTSB SEA74FYE03Accident · No injuriesClosedPiper PA-24 · Renton, WAJul 13, 1973 · N5976P · Substantial damage NTSB SEA74DYE05Accident · No injuriesClosedCessna 180D · Port Townsnd, WAJul 7, 1973 · N6014B · Substantial damage NTSB SEA74DYE03Accident · No injuriesClosedHughes 269A · Renton, WAJul 7, 1973 · N2SW · Destroyed NTSB SEA74AYE04Accident · No injuriesClosedBell 47D · Anacortes, WAJul 7, 1973 · N964B · Substantial damage NTSB SEA74FYE02Accident · No injuriesClosedChampion 7EC · Tacoma, WAJul 4, 1973 · N7439B · Substantial damage NTSB SEA74DYE01Accident · No injuriesClosedPiper PA-28 · Bellevue, WAJul 1, 1973 · N56984 · Substantial damage NTSB SEA74DYE16Accident · No injuriesClosedCessna 150 · Aldrwood Mnr, WAJun 30, 1973 · N8606J · Minor damage NTSB SEA73DVE41Accident · No injuriesClosedPiper PA-28 · Port Townsnd, WAJun 30, 1973 · N55435 · Substantial damage NTSB SEA74FYG02Accident · Minor injuriesClosedPiper PA-25 · Pasco, WAJun 27, 1973 · N7000Z · Destroyed NTSB SEA73IS038Incident · No injuriesClosedDouglas DC-9 · Spokane, WAJun 22, 1973 · N9338 · Minor damage NTSB SEA73FYE40Accident · No injuriesClosedSikorsky S-61L · Marblemount, WAJun 19, 1973 · N302Y · Substantial damage NTSB SEA73FYE39Accident · Serious injuriesClosedBeech B95 · Eatonville, WAJun 17, 1973 · N9650R · Destroyed NTSB SEA73DYE38Accident · Minor injuriesClosedAeronca 7AC · Maple Valley, WAJun 17, 1973 · N2492E · Substantial damage NTSB SEA73FYE37Accident · 1 fatalClosedCouger 1 · Bremerton, WAJun 8, 1973 · N2513 · Substantial damage NTSB SEA73AS035Accident · 1 fatalClosedCessna 182K · Snohomish, WAMay 29, 1973 · N2846R · Substantial damage NTSB SEA73DYG34Accident · No injuriesClosedGlasflugel H301B · Ephrata, WAMay 27, 1973 · N245F · Substantial damage NTSB SEA73DYC29Accident · No injuriesClosedCessna 172H · Battleground, WAMay 27, 1973 · N8044L · Substantial damage NTSB SEA73FYG36Accident · Serious injuriesClosedBell Tomcat · Harrington, WAMay 26, 1973 · N73865 · Substantial damage NTSB SEA73DYG33Accident · No injuriesClosedPiper PA-22 · Mazama, WAMay 26, 1973 · N2304A · Substantial damage NTSB SEA73DYE36Accident · No injuriesClosedCessna 170B · Auburn, WAMay 26, 1973 · N4590C · Substantial damage NTSB SEA73DYE35Accident · No injuriesClosedCessna 172S · La Conner, WAMay 19, 1973 · N3897Q · Substantial damage NTSB SEA73DYE34Accident · No injuriesClosedTaylorcraft BC12-D · Bellevue, WAMay 17, 1973 · N95514 · Substantial damage NTSB SEA73FYG31Accident · Minor injuriesClosedDehavilland DH104 · Moses Lake, WAMay 15, 1973 · N4041B · Destroyed NTSB SEA73DYG35Accident · No injuriesClosedBoeing PT-17 · Odessa, WAMay 15, 1973 · N67237 · Substantial damage NTSB SEA73DYG30Accident · No injuriesClosedPiper PA-24 · Othello, WAMay 12, 1973 · N8756P · Substantial damage NTSB SEA73DYE33Accident · No injuriesClosedPiper PA-28 · Hoquiam, WAMay 12, 1973 · N4271T · Substantial damage NTSB SEA73IS031Incident · No injuriesClosedCessna 310C · Yakima, WAMay 2, 1973 · N2970G · Minor damage NTSB SEA73AS030Accident · 1 fatalClosedBeech S35 · Thorp, WAMay 1, 1973 · N2005W · Destroyed