NTSB investigations, 1981, WA

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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.

Cases, newest first

Query with SQL
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 year(c.\"eventDate\") = 1981
    AND 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.

NTSB SEA81FA041Accident · No injuriesClosedPiper PA-24 · Bellevue, WAJun 14, 1981 · N8908P · DestroyedNTSB SEA81FYP22Accident · No injuriesClosedCessna 152 · Pasco, WAJun 13, 1981 · N6259B · Substantial damageNTSB SEA81DYP21Accident · Serious injuriesClosedBell 47G3B2 · Walla Walla, WAJun 11, 1981 · N14827 · Substantial damageNTSB SEA81DYE31Accident · Minor injuriesClosedHiller UN-12D · Castle Rock, WAJun 10, 1981 · N62377 · DestroyedNTSB SEA82FYE30Accident · No injuriesClosedHelio H-391B · Bellingham, WAMay 29, 1981 · N316HW · Substantial damageNTSB SEA81DYP19Accident · No injuriesClosedAir Tractor AT-301 · Prescott, WAMay 28, 1981 · N8827S · Substantial damageNTSB SEA81FA037Accident · No injuriesClosedPiper PA-28R · Orcas, WAMay 23, 1981 · N6914C · Substantial damageNTSB SEA81FA035Accident · 2 fatalClosedBell 47G-4A · Aberdeen, WAMay 19, 1981 · N9457 · DestroyedNTSB SEA81DYP17Accident · No injuriesClosedSchleicher KA8B · Wenatchee, WAMay 17, 1981 · N4780T · Substantial damageNTSB SEA81DYP16Accident · No injuriesClosedPiper PA-25 · Quincy, WAMay 14, 1981 · N82317 · Substantial damageNTSB SEA81DYE29Accident · No injuriesClosedPiper J-3 · Bainbridge Isl, WAMay 12, 1981 · N51565 · Substantial damageNTSB SEA81DYE28Accident · No injuriesClosedBeech B23 · Ocean Shores, WAMay 12, 1981 · N7608R · Substantial damageNTSB SEA81DYE27Accident · No injuriesClosedPiper PA-18 · Tacoma, WAMay 12, 1981 · N82566 · Substantial damageNTSB SEA81DYP15Accident · Minor injuriesClosedCessna A188B · Washtucna, WAMay 11, 1981 · N91498 · DestroyedNTSB SEA81FA034Accident · 1 fatalClosedBeech 35 · Maple Valley, WAMay 8, 1981 · N3024V · DestroyedNTSB SEA81DYP14Accident · No injuriesClosedPiper PA-28 · Coulee City, WAMay 4, 1981 · N9077J · Substantial damageNTSB SEA81FA033Accident · Serious injuriesClosedStinson 108-2 · Ellensburg, WAMay 3, 1981 · N9279K · DestroyedNTSB SEA81FA032Accident · No injuriesClosedCessna 152 · Auburn, WAApr 29, 1981 · N49457 · Substantial damageNTSB SEA81FA031Accident · 2 fatalClosedPiper PA-28 · Washougal, WAApr 22, 1981 · C-GNVX · DestroyedNTSB SEA81AA030Accident · 1 fatalClosedCessna 172N · Gorst, WAApr 21, 1981 · N2411E · DestroyedNTSB SEA81FA029Accident · Serious injuriesClosedVarieze Rutan · Elma, WAApr 18, 1981 · N37LL · DestroyedNTSB SEA81FYE26Accident · No injuriesClosedLuscombe 8F · Index, WAApr 17, 1981 · N1110B · Substantial damageNTSB SEA81FYP13Accident · No injuriesClosedBoeing A75N1 · Mansfield, WAApr 15, 1981 · N58501 · Substantial damageNTSB SEA81FA028Accident · Minor injuriesClosedPiper PA-24 · Port Orchard, WAApr 15, 1981 · N5976P · Substantial damageNTSB SEA81FA027Accident · Serious injuriesClosedCessna 175 · Burton, WAApr 13, 1981 · N7686M · Substantial damageNTSB SEA81FYE23Accident · No injuriesClosedBeech 35 · Puyallup, WAApr 6, 1981 · N2737V · Substantial damageNTSB SEA81FYP12Accident · No injuriesClosedBell 47G-2 · Union Gap, WAApr 2, 1981 · N74161 · Substantial damageNTSB SEA81FA026Accident · 1 fatalClosedMuir RV-3 · Renton, WAMar 28, 1981 · N84763 · DestroyedNTSB SEA81FYE22Accident · Minor injuriesClosedCessna 150 · Port Orchard, WAMar 21, 1981 · N45552 · Substantial damageNTSB SEA81FA025Accident · 1 fatalClosedSchweizer SGS126 · Arlington, WAMar 21, 1981 · N9866E · DestroyedNTSB SEA81FYP11Accident · Minor injuriesClosedPiper PA-28 · Wenatchee, WAMar 20, 1981 · N7226F · Substantial damageNTSB SEA81FA024Accident · No injuriesClosedCessna 172M · Roche Harbor, WAMar 13, 1981 · N80849 · Substantial damageNTSB SEA81FYP10Accident · Minor injuriesClosedPiper PA-25 · Oaksdale, WAMar 11, 1981 · N7553Z · Substantial damageNTSB SEA81FA022Accident · No injuriesClosedCessna 152 · Kent, WAMar 10, 1981 · N48883 · Substantial damageNTSB SEA81FA020Accident · 2 fatalClosedCessna 182P · Everett, WAMar 3, 1981 · N21002 · DestroyedNTSB SEA81DYP09Accident · No injuriesClosedCessna 182Q · Moses Lake, WAMar 2, 1981 · N94338 · Substantial damageNTSB SEA81FYP07Accident · Serious injuriesClosedPiper PA-25 · Colville, WAFeb 28, 1981 · N4991Y · DestroyedNTSB SEA81DYE21Accident · No injuriesClosedCessna TU206 · Bellevue, WAFeb 28, 1981 · N4850F · Substantial damageNTSB SEA81FA019Accident · 1 fatalClosedPiper PA-28 · Seattle, WAFeb 25, 1981 · N2258Q · DestroyedNTSB SEA81FYE18Accident · Minor injuriesClosedCessna 172 · Seattle, WAFeb 23, 1981 · N2946E · Substantial damageNTSB SEA81FYE17Accident · Minor injuriesClosedCessna TU206G · Everett, WAFeb 16, 1981 · N7345N · DestroyedNTSB SEA81DYE14Accident · No injuriesClosedMaule M-5 · Kelso, WAFeb 8, 1981 · N5634M · Substantial damageNTSB SEA81DYE13Accident · Minor injuriesClosedCessna 172 · Bellingham, WAFeb 4, 1981 · N738HU · DestroyedNTSB SEA81FYP05Accident · Serious injuriesClosedPiper PA-25 · Mesa, WAJan 30, 1981 · N4779Y · DestroyedNTSB SEA81FA018Accident · 2 fatalClosedPiper PA-28 · Port Angles, WAJan 28, 1981 · N3062D · DestroyedNTSB SEA81FA017Accident · 2 fatalClosedCessna 150F · Puyallup, WAJan 23, 1981 · N6942F · DestroyedNTSB DCA81AA006Accident · 7 fatalClosedBeech 99A · Spokane, WAJan 20, 1981 · N390CA · DestroyedNTSB SEA81IA016Incident · No injuriesClosedBoeing 727 · Seattle, WAJan 14, 1981 · N439BN · 2 aircraft · No damageNTSB SEA81FYP06Accident · No injuriesClosedCessna 320 · Curlew, WAJan 14, 1981 · N9831L · Substantial damageNTSB SEA81FYE15Accident · No injuriesClosedPiper PA-24 · Olympia, WAJan 10, 1981 · N6651P · Substantial damage