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.
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 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 SEA82DA040Accident · No injuriesFinal reportLuscombe 8E · Blaine, WAUpon arrival the pilot observed the wind to be 90 degrees to the runway with an estimated velocity of 5 to 7 knots. A low pass was completed followed by a landing on runway 32. During the rollout the aircraft drifted right, the landing gear encountered…NTSB SEA82DA037Accident · Minor injuriesFinal reportPiper PA-18-135 · Richland, WAThe pilot was practicing short field landings. On this approach, he added power to arrest a high sink rate, but felt that the engine did not respond adequately. A hard landing occurred. The engine was examined, and during a test run, it operated…NTSB SEA82DA034Accident · No injuriesFinal reportRockwell Intl 114 · Everett, WAShortly after touchdown on runway 29, the aircraft veered to the right, became airborne, and then veered sharply to the left. The passenger stated that after the initial touchdown and right drift, the pilot added power, pulled the nose up to a high attitude,…NTSB SEA82DA031Accident · No injuriesFinal reportCessna 172N · Redmond, WAThe student and instructor were practicing water landings on lake sammamish near Redmond, WA. The winds were initially calm. On the second landing, it was noted that the wind began to pick up. Reportedly, wind shear was encountered during final approach for…NTSB SEA82DA027Accident · No injuriesFinal reportPiper PA-28-180 · Prosser, WAAfter returning from a local flight, the student pilot landed on runway 25. The wind was from 090 degrees at 5 knots. The landing was without difficulty until the nosewheel touched down, then the aircraft veered left. The pilot reported that he corrected with…NTSB SEA82DA025Accident · No injuriesFinal reportCessna 150J · Nr. Colbert, WADuring flight, the instructor asked the student to perfrom a power-off approach-to-landing stall. The student began the maneuver at about 4600 ft with the carburetor heat on. During recovery, he abruptly advanced the throttle and the engine began to lose…NTSB SEA82DA024Accident · No injuriesFinal reportCessna U206G · Moses Lake, WAThe pilot stated that he encountered a freak gust of wind during the landing. The plane touched down on the right side of the runway in an area of soft terrain. The aircraft veered farther to the right and continued into an earthen drainage ditch. The ditch…NTSB SEA82DA023Accident · No injuriesFinal reportCessna 172P · Sinclair Island, WAThe airport was a privately owned strip approximately 1200 ft in length. About the last 25 percent of runway 33 was angled approximately 30 degrees to the right. Tth runway was considered unidirectional with landings normally made to the north/northwest and…NTSB SEA82FYM08Accident · Serious injuriesFinal reportBeech C23 · Orchards, WADuring a descent with the carburetor heat on, the pilot added power 2 times to verify the engine performance. No difficulty was noted. However, when the throttle was advanced to level off at 1800 ft MSL, the engine sputtered and lost power. The pilot was…NTSB SEA82DA018Accident · No injuriesFinal reportCessna 140 · Spokane, WAAfter an annual inspection, the pilot made a thorough ground check and taxied out for a test flight. During takeoff, the engine lost power at about 50 ft AGL. The pilot landed on the runway overrun in about 9 inches of crusted snow and the plane nosed over.…NTSB SEA82DA017Accident · No injuriesFinal reportPiper PA-31-350 · Spokane, WAAfter arriving in the Spokane area, a full ILS was commenced. It was terminated about 200 ft above the decision height with a missed approach. The aircraft was vectored for a second ILS. During the last 400 ft of this approach, about 3/4 to one inch of mixed…NTSB SEA82DA016Accident · No injuriesFinal reportCessna TU206G · Pullman, WAThe aircraft had a rudder/directional control problem that had been occurring intermittently. When it occurred during the previous flight, the pilot had to use full right rudder to keep the ball centered. Before landing on that flight, he made a low pass near…NTSB SEA82DA022Accident · No injuriesFinal reportCessna 140 · Pullman, WAThe pilot started to takeoff on a snow covered runway in calm wind conditions. He reported that about 3 inches of snow had fallen since the runway had been cleared. In his judgement, the aircraft did not accelerate fast enough to assure a safe takeoff, so he…NTSB SEA82FA014Accident · 1 fatalClosedCessna 402C · Pullman, WANTSB LAX82FA030Accident · 2 fatalClosedCessna 150 · Kelso, WANTSB SEA82IA009Incident · No injuriesClosedCessna 207 · Belfair, WANTSB SEA82DYP06Accident · No injuriesClosedCessna 172G · Mattawa, WANTSB SEA82IA008Incident · No injuriesClosedPiper PA-31 · Seattle, WANTSB SEA82FA007Accident · 4 fatalClosedPiper PA-28 · Longview, WANTSB SEA82DYE03Accident · No injuriesClosedLuscombe 8A · Friday Harbor, WANTSB SEA82FA011Accident · 2 fatalClosedCessna 150G · Renton, WANTSB SEA82IA004Incident · No injuriesClosedBeech 200 · Seattle, WANTSB SEA82DYE01Accident · No injuriesClosedEnstrom 280C · Burke Island, WANTSB SEA82FYP03Accident · No injuriesClosedRobinson R22 · Rosalia, WANTSB SEA82DYP04Accident · Minor injuriesClosedPiper PA-28 · George, WANTSB SEA82DYE02Accident · No injuriesClosedCessna 182 · Everett, WANTSB SEA82FA001Accident · 1 fatalClosedChampion 7GCAA · Goldendale, WANTSB SEA82DYP01Accident · Minor injuriesClosedBellanca 7ECA · Wapato, WANTSB SEA81FYP39Accident · No injuriesClosedPiper PA-28R · Republic, WANTSB SEA81FA057Accident · 3 fatalClosedCessna 210A · Woodland, WANTSB SEA81DYP42Accident · No injuriesClosedBoeing A75N1 · Orondo, WANTSB SEA81DYP40Accident · No injuriesClosedEagle DW-1 · Chelan, WANTSB SEA81FA055Accident · 4 fatalClosedCessna 320D · Republic, WANTSB SEA81DYE37Accident · No injuriesClosedCessna 172 · Bremerton, WANTSB SEA81DYP38Accident · No injuriesClosedCessna 150 · Sunnyside, WANTSB SEA81DYM41Accident · No injuriesClosedBeech B23 · Orchards, WANTSB SEA81FA054Accident · 3 fatalClosedBeech C24R · Snoqualmie Ps, WANTSB SEA81DYP37Accident · No injuriesClosedHughes 369D · Leavenworth, WANTSB SEA81DYE38Accident · No injuriesClosedCessna 172A · Port Townsend, WANTSB SEA81DYP36Accident · Serious injuriesClosedCessna P210N · College Place, WANTSB SEA81FYP35Accident · No injuriesClosedNavion · Spangle, WANTSB SEA81FYP34Accident · No injuriesClosedBoeing E75 · Omak, WANTSB SEA81DYP33Accident · No injuriesClosedCessna 150L · Waitsburg, WANTSB LAX81FA116Accident · 1 fatalClosedGrum Amer AA-5B · Vancouver, WANTSB SEA81DA052Accident · No injuriesClosedPiper PA-34 · Wenatchee, WANTSB SEA81FA051Accident · 2 fatalClosedRyan Acft ST-3KR · Shelton, WANTSB SEA81FA050Accident · 2 fatalClosedSikorsky S-58B · Bellevue, WANTSB SEA81FYM34Accident · Minor injuriesClosedCessna 170B · Vancouver, WANTSB SEA81FYP31Accident · No injuriesClosedBoeing A75N1 · Wenatchee, WANTSB SEA81FA049Accident · 2 fatalClosedCessna 182A · Kingston, WA