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.
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
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 SEA81FA041Accident · No injuriesClosedPiper PA-24 · Bellevue, WANTSB SEA81FYP22Accident · No injuriesClosedCessna 152 · Pasco, WANTSB SEA81DYP21Accident · Serious injuriesClosedBell 47G3B2 · Walla Walla, WANTSB SEA81DYE31Accident · Minor injuriesClosedHiller UN-12D · Castle Rock, WANTSB SEA82FYE30Accident · No injuriesClosedHelio H-391B · Bellingham, WANTSB SEA81DYP19Accident · No injuriesClosedAir Tractor AT-301 · Prescott, WANTSB SEA81FA037Accident · No injuriesClosedPiper PA-28R · Orcas, WANTSB SEA81FA035Accident · 2 fatalClosedBell 47G-4A · Aberdeen, WANTSB SEA81DYP17Accident · No injuriesClosedSchleicher KA8B · Wenatchee, WANTSB SEA81DYP16Accident · No injuriesClosedPiper PA-25 · Quincy, WANTSB SEA81DYE29Accident · No injuriesClosedPiper J-3 · Bainbridge Isl, WANTSB SEA81DYE28Accident · No injuriesClosedBeech B23 · Ocean Shores, WANTSB SEA81DYE27Accident · No injuriesClosedPiper PA-18 · Tacoma, WANTSB SEA81DYP15Accident · Minor injuriesClosedCessna A188B · Washtucna, WANTSB SEA81FA034Accident · 1 fatalClosedBeech 35 · Maple Valley, WANTSB SEA81DYP14Accident · No injuriesClosedPiper PA-28 · Coulee City, WANTSB SEA81FA033Accident · Serious injuriesClosedStinson 108-2 · Ellensburg, WANTSB SEA81FA032Accident · No injuriesClosedCessna 152 · Auburn, WANTSB SEA81FA031Accident · 2 fatalClosedPiper PA-28 · Washougal, WANTSB SEA81AA030Accident · 1 fatalClosedCessna 172N · Gorst, WANTSB SEA81FA029Accident · Serious injuriesClosedVarieze Rutan · Elma, WANTSB SEA81FYE26Accident · No injuriesClosedLuscombe 8F · Index, WANTSB SEA81FYP13Accident · No injuriesClosedBoeing A75N1 · Mansfield, WANTSB SEA81FA028Accident · Minor injuriesClosedPiper PA-24 · Port Orchard, WANTSB SEA81FA027Accident · Serious injuriesClosedCessna 175 · Burton, WANTSB SEA81FYE23Accident · No injuriesClosedBeech 35 · Puyallup, WANTSB SEA81FYP12Accident · No injuriesClosedBell 47G-2 · Union Gap, WANTSB SEA81FA026Accident · 1 fatalClosedMuir RV-3 · Renton, WANTSB SEA81FYE22Accident · Minor injuriesClosedCessna 150 · Port Orchard, WANTSB SEA81FA025Accident · 1 fatalClosedSchweizer SGS126 · Arlington, WANTSB SEA81FYP11Accident · Minor injuriesClosedPiper PA-28 · Wenatchee, WANTSB SEA81FA024Accident · No injuriesClosedCessna 172M · Roche Harbor, WANTSB SEA81FYP10Accident · Minor injuriesClosedPiper PA-25 · Oaksdale, WANTSB SEA81FA022Accident · No injuriesClosedCessna 152 · Kent, WANTSB SEA81FA020Accident · 2 fatalClosedCessna 182P · Everett, WANTSB SEA81DYP09Accident · No injuriesClosedCessna 182Q · Moses Lake, WANTSB SEA81FYP07Accident · Serious injuriesClosedPiper PA-25 · Colville, WANTSB SEA81DYE21Accident · No injuriesClosedCessna TU206 · Bellevue, WANTSB SEA81FA019Accident · 1 fatalClosedPiper PA-28 · Seattle, WANTSB SEA81FYE18Accident · Minor injuriesClosedCessna 172 · Seattle, WANTSB SEA81FYE17Accident · Minor injuriesClosedCessna TU206G · Everett, WANTSB SEA81DYE14Accident · No injuriesClosedMaule M-5 · Kelso, WANTSB SEA81DYE13Accident · Minor injuriesClosedCessna 172 · Bellingham, WANTSB SEA81FYP05Accident · Serious injuriesClosedPiper PA-25 · Mesa, WANTSB SEA81FA018Accident · 2 fatalClosedPiper PA-28 · Port Angles, WANTSB SEA81FA017Accident · 2 fatalClosedCessna 150F · Puyallup, WANTSB DCA81AA006Accident · 7 fatalClosedBeech 99A · Spokane, WANTSB SEA81IA016Incident · No injuriesClosedBoeing 727 · Seattle, WANTSB SEA81FYP06Accident · No injuriesClosedCessna 320 · Curlew, WANTSB SEA81FYE15Accident · No injuriesClosedPiper PA-24 · Olympia, WA