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 SEA78DYP33Accident · No injuriesClosedBell 47G-2 · Benton City, WAJun 7, 1978 · N31552 · Destroyed NTSB SEA78DYP29Accident · No injuriesClosedGrum Amer AA5-A · Prosser, WAJun 3, 1978 · N26410 · Substantial damage NTSB SEA78FYE25Accident · No injuriesClosedPiper PA-28R · Anderson Is, WAJun 2, 1978 · N322HC · Substantial damage NTSB SEA78DYP30Accident · No injuriesClosedCessna 180 · Kahlotus, WAMay 30, 1978 · N7616K · Substantial damage NTSB SEA78DYE24Accident · No injuriesClosedCessna 185F · Arlington, WAMay 27, 1978 · N93272 · Substantial damage NTSB SEA78FA033Accident · 1 fatalClosedHughes 269A · Vancouver, WAMay 25, 1978 · N8850F · Destroyed NTSB SEA78FA034Accident · 2 fatalClosedPiper PA-28 · Bremerton, WAMay 21, 1978 · N1914T · Destroyed NTSB SEA78DYP27Accident · No injuriesClosedCessna 170 · Deer Park, WAMay 20, 1978 · N5569C · Substantial damage NTSB SEA78FA032Accident · 1 fatalClosedBeech K35 · Wenatchee, WAMay 16, 1978 · N3064C · Destroyed NTSB SEA78FA030Accident · No injuriesClosedBeech B90 · Olympia, WAMay 9, 1978 · N19Y · Minor damage NTSB SEA78DYE23Accident · Minor injuriesClosedZimmerman Akro · Redmond, WAMay 8, 1978 · N11GZ · Substantial damage NTSB SEA78FA028Accident · 1 fatalClosedCessna 210G · Tumwater, WAMay 7, 1978 · N5892F · Destroyed NTSB SEA78FA027Accident · 2 fatalClosedBeech 35C33 · Vancouver, WAMay 5, 1978 · N7948M · Destroyed NTSB SEA78DYE22Accident · No injuriesClosedCessna 185F · Arlington, WAMay 3, 1978 · N93272 · Substantial damage NTSB SEA78FYE21Accident · Minor injuriesClosedCessna 172 · Port Townsend, WAApr 30, 1978 · N7222G · Substantial damage NTSB SEA78DYP24Accident · Serious injuriesClosedCam Balloon V-56 · Walla Walla, WAApr 29, 1978 · N134CB · No damage NTSB SEA78FYE20Accident · 1 fatalClosedBensen G-1D · Tacoma, WAApr 28, 1978 · N777GD · Destroyed NTSB SEA78DYE18Accident · No injuriesClosedStinson 108-1 · Bremerton, WAApr 23, 1978 · N8136K · Substantial damage NTSB SEA78FYE19Accident · Minor injuriesClosedCessna 182 · Spanaway, WAApr 20, 1978 · N4660K · Substantial damage NTSB SEA78DYP28Accident · Minor injuriesClosedBoeing A75N1 · Mansfield, WAApr 20, 1978 · N49385 · Substantial damage NTSB SEA78FYP23Accident · 1 fatalClosedCallair A-9 · Springdale, WAApr 15, 1978 · N3601G · Destroyed NTSB SEA78DYP22Accident · No injuriesClosedPiper PA-25 · George, WAApr 14, 1978 · N8805L · Destroyed NTSB SEA78FYP21Accident · Minor injuriesClosedErco 415-C · Newport, WAApr 9, 1978 · N2548H · Substantial damage NTSB SEA78FA026Accident · 2 fatalClosedCessna 152 · Chehalis, WAApr 8, 1978 · N7147Z · Destroyed NTSB SEA78DYM23Accident · No injuriesClosedBell 47G-2 · Goldendale, WAApr 7, 1978 · N41721 · Substantial damage NTSB SEA78DYE17Accident · No injuriesClosedHughes 269B · Puyallup, WAMar 30, 1978 · N9516F · Substantial damage NTSB SEA78DYP26Accident · No injuriesClosedPiper PA-25 · Espanola, WAMar 29, 1978 · N8502L · Substantial damage NTSB SEA78DYP20Accident · No injuriesClosedCessna 140 · La Crosse, WAMar 29, 1978 · N89636 · Substantial damage NTSB SEA78DYP25Accident · No injuriesClosedCessna 188 · Fairfield, WAMar 27, 1978 · N8070V · Substantial damage NTSB SEA78FYE16Accident · No injuriesClosedHiller Acft UH-12E · Forks, WAMar 20, 1978 · N5359V · Substantial damage NTSB SEA78DYP19Accident · No injuriesClosedWeatherly 201B · Pomeroy, WAMar 20, 1978 · N1258W · Substantial damage NTSB SEA78DYP17Accident · No injuriesClosedBellanca 1731TC · Kennewick, WAMar 19, 1978 · N3EC · Substantial damage NTSB SEA78FA022Accident · 3 fatalClosedCessna 172 · Lynden, WAMar 16, 1978 · C-GHUS · 2 aircraft · Destroyed NTSB SEA78FYP15Accident · No injuriesClosedCessna A188 · Moxee, WAMar 15, 1978 · N5501S · Destroyed NTSB SEA78FYE15Accident · Minor injuriesClosedCessna 150 · Camano Island, WAMar 12, 1978 · N7495G · Substantial damage NTSB SEA78FYE14Accident · Minor injuriesClosedTorro 771 · Enumclaw, WAMar 12, 1978 · N27LM · Substantial damage NTSB SEA78FYE12Accident · 1 fatalClosedBerg Sprite SW1 · Lakewood, WAMar 12, 1978 · N9756 · Destroyed NTSB SEA78FA021Accident · 1 fatalClosedPiper PA-28 · Springdale, WAMar 11, 1978 · N32085 · Destroyed NTSB SEA78FYE13Accident · Minor injuriesClosedMooney M20C · Olympia, WAMar 10, 1978 · N6761N · Substantial damage NTSB SEA78DYP18Accident · No injuriesClosedPiper PA-30 · Tekoa, WAMar 10, 1978 · N7672Y · Substantial damage NTSB SEA78FYE11Accident · No injuriesClosedHiller Acft UH-12E · Montesano, WAMar 6, 1978 · N100LM · Substantial damage NTSB SEA78DYP13Accident · Minor injuriesClosedPiper PA-28 · Quincy, WAMar 2, 1978 · N8374W · Substantial damage NTSB SEA78FYP12Accident · Serious injuriesClosedCessna 150L · Electric City, WAFeb 27, 1978 · N6615G · Destroyed NTSB SEA78FYP14Accident · 1 fatalClosedCessna 185 · Naches, WAFeb 25, 1978 · C-GFYS · Destroyed NTSB SEA78FA020Accident · 7 fatalClosedPiper PA-32R · Oak Harbor, WAFeb 22, 1978 · N6992J · Destroyed NTSB SEA78DYE08Accident · Minor injuriesClosedCessna 170 · Bellingham, WAFeb 11, 1978 · N5794C · Substantial damage NTSB SEA78FYE10Accident · No injuriesClosedHughes 269B · Taholah, WAFeb 10, 1978 · N9117F · Destroyed NTSB DCA78AA007Accident · 17 fatalClosedBeech 99 · Richland, WAFeb 10, 1978 · N199EA · Destroyed NTSB SEA78DYE08Accident · No injuriesClosedHiller Acft UH-12D · Quillayute, WAFeb 8, 1978 · N87977 · Destroyed NTSB SEA78FYE06Accident · No injuriesClosedS.N.I.A.S. SA3180 · Clearwater, WAFeb 6, 1978 · N8453 · Substantial damage