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 SEA72IS008Incident · No injuriesClosedBoeing 747 · Seattle, WASep 2, 1971 · N606US · Minor damage NTSB SEA72AS007Accident · 2 fatalClosedCessna 310 · Mazama, WAAug 24, 1971 · N770E · Destroyed NTSB SEA72DYE15Accident · Minor injuriesClosedRyan ST-3KR · Olympia, WAAug 19, 1971 · N53438 · Substantial damage NTSB SEA72DYE11Accident · No injuriesClosedCessna 150 · Bellingham, WAAug 18, 1971 · N23313 · Substantial damage NTSB SEA72DYE10Accident · No injuriesClosedCessna 150 · Edison, WAAug 16, 1971 · N150PW · Substantial damage NTSB SEA72AS006Accident · 2 fatalClosedErco 415-C · Cle Elum, WAAug 14, 1971 · N99265 · Destroyed NTSB SEA72FYG06Accident · 1 fatalClosedPiper PA-25 · Ephrata, WAAug 12, 1971 · N8732L · Destroyed NTSB SEA72FYE06Accident · No injuriesClosedCessna 172 · Renton, WAAug 5, 1971 · N2048Y · Substantial damage NTSB SEA72FYE04Accident · No injuriesClosedJeanies Teenie · Kent, WAAug 1, 1971 · N2457 · Substantial damage NTSB SEA72DYG05Accident · No injuriesClosedHughes 269C · Pullman, WAJul 30, 1971 · N9641F · Destroyed NTSB SEA72DYE05Accident · No injuriesClosedPiper PA-28 · Tacoma, WAJul 21, 1971 · N8813N · Substantial damage NTSB SEA72DYG04Accident · No injuriesClosedPiper PA-25 · Quincy, WAJul 20, 1971 · N6034Z · Destroyed NTSB SEA72FYE03Accident · 1 fatalClosedHiller 12E · Skykomish, WAJul 16, 1971 · N9749C · Destroyed NTSB SEA72DYG02Accident · No injuriesClosedCessna A188 · Brownstown, WAJul 16, 1971 · N5501S · Substantial damage NTSB SEA72DYC06Accident · No injuriesClosedCessna 206 · Orchards, WAJul 16, 1971 · N5033U · Substantial damage NTSB SEA72AS002Accident · 1 fatalClosedTaylorcraft BCS12D · Sucia Island, WAJul 16, 1971 · N96216 · Minor damage NTSB SEA72DYG03Accident · No injuriesClosedHughes 269B · Pullman, WAJul 14, 1971 · N9539F · Substantial damage NTSB SEA72FYG01Accident · 1 fatalClosedSnow S2R · Royal City, WAJul 13, 1971 · N8879Q · Destroyed NTSB SEA72FYE02Accident · Minor injuriesClosedCessna 150 · Bellevue, WAJul 3, 1971 · N3139X · Destroyed NTSB SEA72FYE01Accident · No injuriesClosedCessna 150 · Lacey, WAJul 3, 1971 · N6693G · Substantial damage NTSB SEA72AS001Accident · 2 fatalClosedTaylorcraft BC12-D · Riverside, WAJul 3, 1971 · N43846 · Destroyed NTSB SEA71DYG62Accident · No injuriesClosedCessna 182 · Colville, WAJun 27, 1971 · N3106Q · Substantial damage NTSB SEA71FYG60Accident · Minor injuriesClosedBell 47G2 · Moses Lake, WAJun 24, 1971 · N1657 · Destroyed NTSB SEA71FYE38Accident · No injuriesClosedChampion 7ECA · Auburn, WAJun 22, 1971 · N1628G · Substantial damage NTSB SEA71FYE37Accident · Minor injuriesClosedCessna 175 · Kenmore, WAJun 21, 1971 · N7271M · Substantial damage NTSB SEA71DYC45Accident · Minor injuriesClosedBeech A23-24 · Dallesport, WAJun 18, 1971 · N7985L · Substantial damage NTSB SEA71DYG59Accident · No injuriesClosedCallair A-6 · Waterville, WAJun 16, 1971 · N2934G · Substantial damage NTSB SEA71DYG58Accident · No injuriesClosedMaule M-4 · Ephrata, WAJun 14, 1971 · N9862M · Substantial damage NTSB SEA71DYE36Accident · No injuriesClosedMooney M20E · Tacoma, WAJun 13, 1971 · N9312M · Substantial damage NTSB SEA71FYE34Accident · No injuriesClosedCessna 150 · Issaquah, WAJun 9, 1971 · N3235J · Substantial damage NTSB SEA71FYC44Accident · No injuriesClosedBeech V35B · Vancouver, WAJun 9, 1971 · N3586A · Substantial damage NTSB SEA71FYE33Accident · Serious injuriesClosedBell 47G2 · Eatonville, WAJun 5, 1971 · N1968H · Substantial damage NTSB SEA71DYE35Accident · No injuriesClosedWenosa HS1 · South Prarie, WAJun 4, 1971 · N1041 · Substantial damage NTSB SEA71FYE32Accident · No injuriesClosedNavion A · Silverdale, WAMay 27, 1971 · N8592H · Substantial damage NTSB SEA71DYG57Accident · No injuriesClosedCessna 150 · Bridgeport, WAMay 25, 1971 · N3164X · Substantial damage NTSB SEA71DYG55Accident · No injuriesClosedPiper PA-25 · Lind, WAMay 22, 1971 · N4722Y · Substantial damage NTSB SEA71DYG54Accident · No injuriesClosedSnow S2C · Pasco, WAMay 21, 1971 · N8825Q · Substantial damage NTSB SEA71DYG53Accident · No injuriesClosedBoeing A75N · Waterville, WAMay 18, 1971 · N56929 · Substantial damage NTSB SEA71AS043Accident · 1 fatalClosedPiper PA-18 · Wishram, WAMay 16, 1971 · N8745Y · Minor damage NTSB SEA71DYG51Accident · No injuriesClosedChampion 7GCBC · Coulee Dam, WAMay 12, 1971 · N6327N · Substantial damage NTSB SEA71AS042Accident · 1 fatalClosedGlobe GC-1B · Monroe, WAMay 11, 1971 · N80655 · Destroyed NTSB SEA71FYG52Accident · No injuriesClosedCessna 172 · Electric Cty, WAMay 10, 1971 · N5741A · Substantial damage NTSB SEA71FYG49Accident · Minor injuriesClosedJeanies Teenie · Richland, WAMay 2, 1971 · N519N · Substantial damage NTSB SEA71FYG48Accident · No injuriesClosedSnow 600S2C · Pasco, WAApr 30, 1971 · N1853S · Substantial damage NTSB SEA71DYG47Accident · No injuriesClosedMooney M20F · Lacrosse, WAApr 28, 1971 · N6774V · Substantial damage NTSB SEA71FYE31Accident · No injuriesClosedRepublic RC-3-1 · Renton, WAApr 27, 1971 · N6278K · Substantial damage NTSB SEA71DYG50Accident · No injuriesClosedNavion B · Spokane, WAApr 26, 1971 · N5273K · Substantial damage NTSB SEA71DYE30Accident · Minor injuriesClosedCessna 172 · Darrington, WAApr 25, 1971 · N4262F · Substantial damage NTSB SEA71FWG46Accident · Minor injuriesClosedPiper PA-28 · Creston, WAApr 14, 1971 · N6931W · Substantial damage NTSB SEA71DWG44Accident · No injuriesClosedBeech 19A · Moses Lake, WAApr 12, 1971 · N6062N · Substantial damage