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 SEA79FYE04Accident · Minor injuriesClosedPiper PA-28 · Bellevue, WANov 10, 1978 · N4036Q · Substantial damage NTSB SEA79FA009Accident · 3 fatalClosedCessna P210 · Toutle, WANov 2, 1978 · N3686P · Destroyed NTSB SEA79FYE02Accident · Minor injuriesClosedCessna 150 · Port Townsend, WAOct 23, 1978 · N21913 · Substantial damage NTSB SEA79FA006Accident · 4 fatalClosedGrum Amer AA-5B · Roche Harbor, WAOct 21, 1978 · N28924 · Destroyed NTSB SEA79FA005Accident · 5 fatalClosedRolladn SCH LS-1-F · Ephrata, WAOct 21, 1978 · N61MP · 2 aircraft · Destroyed NTSB SEA79FA001Accident · 2 fatalClosedCessna 150H · Omak, WAOct 6, 1978 · N22421 · Destroyed NTSB SEA78DYE40Accident · No injuriesClosedCessna 172M · Eatonville, WASep 29, 1978 · N70405 · Substantial damage NTSB SEA78DYE39Accident · Minor injuriesClosedCessna 172 · Seattle, WASep 29, 1978 · N75561 · Substantial damage NTSB SEA78DYE38Accident · Minor injuriesClosedGR Lakes 2T-1A2 · Everett, WASep 26, 1978 · N3580L · Substantial damage NTSB SEA78DYE37Accident · Minor injuriesClosedHiller Acft UH-12E · Amanda Park, WASep 25, 1978 · N94519 · Destroyed NTSB SEA78FYE36Accident · No injuriesClosedStinson 108-3 · Neah Bay, WASep 18, 1978 · N4100C · Destroyed NTSB SEA78DYP51Accident · Minor injuriesClosedBellanca 7GCBC · Palouse, WASep 15, 1978 · N68508 · Destroyed NTSB SEA78DYP52Accident · No injuriesClosedHiller Acft UH-12E · Moses Lake, WASep 9, 1978 · N48121 · Substantial damage NTSB SEA78FA061Accident · 2 fatalClosedPiper J3 · Lynden, WASep 4, 1978 · N6391H · Destroyed NTSB SEA78DYP53Accident · No injuriesClosedCessna 172 · Ephrata, WASep 2, 1978 · N7409X · Substantial damage NTSB SEA78FYP50Accident · Minor injuriesClosedCessna T210M · Spokane, WASep 1, 1978 · N761CM · Substantial damage NTSB SEA78FYM49Accident · Serious injuriesClosedLake LA-4 · Goldendale, WAAug 27, 1978 · N1061L · Destroyed NTSB SEA78FA059Accident · Minor injuriesClosedBeech B99 · Pullman, WAAug 24, 1978 · N8012R · Substantial damage NTSB SEA78FYE34Accident · Minor injuriesClosedCessna 210 · Bainbridge Isl, WAAug 18, 1978 · N3810P · Destroyed NTSB SEA78DYE33Accident · Minor injuriesClosedPiper PA-28 · Bellevue, WAAug 14, 1978 · N8845N · Substantial damage NTSB SEA78DYE35Accident · No injuriesClosedLet-Np-K L-13 · Issaquah, WAAug 13, 1978 · N9244Z · Substantial damage NTSB SEA78FA053Accident · 1 fatalClosedStinson 108E · Enumclaw, WAAug 10, 1978 · N4122C · Destroyed NTSB SEA78FYP48Accident · No injuriesClosedWeatherly 201C · Wilbur, WAAug 9, 1978 · N9197W · Destroyed NTSB SEA78FA052Accident · No injuriesClosedBell 47G3B1 · Snoqualmie Fls, WAAug 7, 1978 · N1182W · Destroyed NTSB SEA78DYP46Accident · No injuriesClosedCessna 188 · Connell, WAAug 7, 1978 · N91498 · Substantial damage NTSB SEA78FA051Accident · 1 fatalClosedCessna 337F · Ocean Shores, WAAug 3, 1978 · N1843M · Substantial damage NTSB SEA78FA050Accident · 1 fatalClosedCessna 150F · Lynden, WAJul 30, 1978 · N6735F · Destroyed NTSB SEA78DYP43Accident · No injuriesClosedGrumman G-164B · Ellensburg, WAJul 29, 1978 · N48432 · Substantial damage NTSB UNK78X0129Accident · 1 fatalClosedEnstrom 280C · Lester, WAJul 28, 1978 · N530H · Destroyed NTSB SEA78DYP42Accident · No injuriesClosedCessna 172 · Chewelah, WAJul 28, 1978 · N84679 · Substantial damage NTSB SEA78DYE31Accident · No injuriesClosedNa Rockwell 112TCA · Aberdeen, WAJul 26, 1978 · N112R · Destroyed NTSB SEA78DYE32Accident · No injuriesClosedCessna 185 · Oak Harbor, WAJul 23, 1978 · N94237 · Substantial damage NTSB SEA78FYP41Accident · No injuriesClosedCessna 170B · Spokane, WAJul 22, 1978 · N1695D · Substantial damage NTSB SEA78DYP44Accident · No injuriesClosedHiller Acft UH-12E · Mesa, WAJul 21, 1978 · N99575 · Substantial damage NTSB SEA78DYE29Accident · Minor injuriesClosedHughes 269B · Snoqualamie, WAJul 15, 1978 · N9449F · Substantial damage NTSB SEA78FA045Accident · 1 fatalClosedHiller FH1100 · Clearlake, WAJul 14, 1978 · N99024 · Destroyed NTSB SEA78FA044Accident · 1 fatalClosedBeech B24R · Vashon, WAJul 11, 1978 · N6591R · Destroyed NTSB SEA78FA043Accident · Minor injuriesClosedCessna 207 · Olga, WAJul 11, 1978 · N91041 · Destroyed NTSB SEA78DYP39Accident · No injuriesClosedPiper PA-18 · Withrow, WAJul 11, 1978 · N7369D · Substantial damage NTSB SEA78DYM43Accident · No injuriesClosedCessna 150 · Vancouver, WAJul 9, 1978 · N9256U · Substantial damage NTSB SEA78FYE28Accident · No injuriesClosedPiper PA-28 · Guemes Island, WAJul 6, 1978 · N8803N · Substantial damage NTSB SEA78DYE27Accident · No injuriesClosedPietenpol Bowers · Tacoma, WAJun 28, 1978 · N688Y · Substantial damage NTSB SEA78DYP34Accident · No injuriesClosedPiper PA-28 · Methow, WAJun 25, 1978 · N5987F · Substantial damage NTSB SEA78DYP35Accident · No injuriesClosedBell 47G · Anatone, WAJun 23, 1978 · N6356X · Substantial damage NTSB SEA78DYP36Accident · No injuriesClosedCessna 172 · Cheney, WAJun 17, 1978 · N79026 · Substantial damage NTSB SEA78DYP37Accident · No injuriesClosedBeech 95-B55 · Walla Walla, WAJun 16, 1978 · N9357Q · Substantial damage NTSB SEA78DYE26Accident · Minor injuriesClosedHiller Acft UH12EJ · Forks, WAJun 13, 1978 · N110EH · Destroyed NTSB SEA78FYP31Accident · 1 fatalClosedBriegleb BF12BD · Ephrata, WAJun 11, 1978 · N5010 · Destroyed NTSB SEA78FYP32Accident · Minor injuriesClosedPiper J3C-65 · Moses Lake, WAJun 10, 1978 · N98735 · Substantial damage NTSB SEA78DA037Accident · 4 fatalClosedGrum Amer AA-5A · Kettle Falls, WAJun 10, 1978 · C-GMWC · Destroyed