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 SEA82DA056Accident · No injuriesFinal reportPiper PA-22-108 · Snohomish, WAThe pilot stated that he kept his speed up and landed farther down the runway than usual due to other traffic. After touchdown he found that the brakes had failed so he attempted to slow down the aircraft by swerving back and forth and finally turning off on…NTSB SEA82DA133Accident · No injuriesFinal reportCessna A185F · Friday Harbor, WAThe plt reported that while he was making a water landing, everything was normal until after touchdown. As the acft decelerated "off the step," the right float rose off the water as if it road over a swell or encountered an object. When the float contacted…NTSB SEA82DA131Accident · No injuriesFinal reportCessna 172N · Roche Harbor, WAThe pilot flew to a private airstrip that was open to grazing animals. During arrival, he made a low pass to check that the runway was clear of animals and other obstructions. He then circled to land. During final approach, he noticed sheep coming onto the…NTSB SEA82FYP10Accident · Serious injuriesFinal reportPiper PA-22-150 · Tieton, WAAfter takeoff, the pilot turned to the left, but then he was unable to clear trees while climbing over rising terrain. A witness that saw the plane turn after takeoff stated that most airplanes continue climbing over a nearby lake and gain altitude before…NTSB SEA82DA130Accident · Minor injuriesFinal reportCessna 175 · Sunnyside, WAWhen the pilot arrived on a flight from Sunnyside to the clark county airport, all fuel facilities were closed. He estimated that he had enough fuel to return and took off without refueling. About 12 miles from the Sunnyside airport, fuel exhaustion occurred.…NTSB SEA82DA128Accident · Serious injuriesFinal reportAeronca 7AC · Kent, WADuring practice steep turns the aircraft encountered its wake turbulence. Manuevers to regain control were not effective. The aircraft contacted trees in a nose low attitude.NTSB SEA82AA126Accident · 6 fatalFinal reportCessna 172 · Mercer Island, WAN2428E, a C-172, had departed sea-tac arpt for a VFR flt to snohomish, WA, about 27 mi on the 355 deg radial from the sea-tac VORTAC. It proceeded nnw over the west shore of Mercer Island located approximately 10 mi north of the sea-tac arpt. N761EL, a…NTSB SEA82FYP09Accident · 3 fatalFinal reportCessna 172M · Wenatchee, WAReportedly, the pilot, a geologist, was on a flight to check rock formations. Prior to the accident, the plane was observed flying up a canyon at low altitude and airspeed. About 3/4 mile from the accident site, two witnesses on a rocky cliff at about 3500 ft…NTSB SEA82DA114Accident · No injuriesFinal reportMong Sport 1 · Battleground, WAThe pilot tookoff from a rough turf field adjacent to a school after a parade featuring his plane. The day was hot and the field was short. The pilot was unable to clear 60 foot trees and impacted the ground.NTSB SEA82DA112Accident · Serious injuriesFinal reportBell 47G-2 · Harrah, WAThe pilot reported that before taking off, the fuel quantity guages indicated there was sufficient fuel to complete one more load and still have an adequate reserve. After dispensing the load, the engine lost power while he was returning to the nurse truck.…NTSB SEA82FYP08Accident · Serious injuriesFinal reportLark IS28B2 · Springdale, WAThe pilot received an aerial tow to 5000 feet and was able to find lifting currents for approximately 1.5 hours. Unable to obtain adequate lift the pilot decided to attempt an off airport landing on a dirt road crossing a wheat field. At an altitude of…NTSB SEA82DA106Accident · Minor injuriesFinal reportBeech A23-19 · Carlton, WAThe purpose of the flight was for mineral exploration. The pilot reported that the sun was low on the horizon which resulted in long shadows being cast by the terrain. In the vicinity of hoodoo peak, the pilot determined that he had allowed the aircraft to…NTSB SEA82DA105Accident · No injuriesFinal reportCessna 182Q · Spokane, WAThe pilot reported that after checking the wind sock, an approach was made to the runway over trees. Reportedly, the first approach was uncomfortable, so a go-around was made. The pilot stated that the second approach and touchdown were normal, but there was…NTSB SEA82DA103Accident · No injuriesFinal reportCoot Amphibian · Bellingham, WAThe aircraft was being flown on a local test flight following a new engine installation. This was only the second flight for this home built aircraft. During climb-out, the engine lost power and there was insufficient altitude for a normal runway landing. The…NTSB SEA82DA100Accident · No injuriesFinal reportMaule M-5-235C · Mt. Vernon, WAThe purpose of the flight was dual training for short field obstacle landings. On the third approach, a delayed flare resulted in a hard landing and gear collapse.NTSB SEA82DA096Accident · No injuriesFinal reportBensen B-8M · Kennewick, WAThe pilot stated that he was demonstrating the gyrocopter's vertical decent capability at an eaa fly-in. He flew the aircraft into the wind at approximately 200 feet, reduced power and failed to recover from the sink rate.NTSB SEA82DA099Accident · No injuriesFinal reportCessna A188B · Othello, WAAt the completion of a spray operation, the pilot returned to the airport to land. During the landing roll realizing that no braking was available on the left wheel, the aircraft was intentionally ground looped in an effort to reduce the damage. According to…NTSB SEA82DA094Accident · No injuriesFinal reportPiper PA-28-180 · Toledo, WAThe pilot reported that before landing, he turned the fuel boost "on", applied carburetor heat, and set the power at roughly 1500 RPM. He reported that the mixture had been in the full rich position during the entire flight. He encountered a crosswind on…NTSB SEA82FA093Accident · Serious injuriesField investigationFinal reportStinson 108-3 · Lopez Island, WAThe aircraft engine stopped at 400 feet AGL during climbout. The pilot executed a turn at minimum airspeed and landed the aircraft on a golf course. The landing gear and engine mounts failed. Investigation revealed the aircraft's fuel tanks were empty.NTSB SEA82DA090Accident · Minor injuriesFinal reportHughes 269B · Mt St Helens, WAThe pilot intended to proceed to Mt St Helens to land near spirit lake. The winds in the vicinity of the desired landing point were too strong for a safe landing. Therefore, an alternate spot was selected below the ridge line and presumably sheltered from the…NTSB SEA82DA089Accident · No injuriesFinal reportPiper PA-28-180 · Roche Harbor, WAThe aircraft touched down hard on landing, bounced and directional control was lost. The aircraft then groundlooped and went through the airport fence. The pilot and his two passengers were not injured.NTSB SEA82DA087Accident · No injuriesFinal reportCessna 206 · Renton, WAAccording to the pilot, the aircraft was on its first flight after a major engine overhaul and was being flown for maintenance evaluation. About 45 minutes after takeoff, the pilot requested a descent from 7500 feet MSL. After entering an overcast, the engine…NTSB SEA82DA084Accident · No injuriesFinal reportBeech B19 · Quincy, WADuring a simulated forced landing, the student pilot initially turned the wrong direction, then turned correctly toward the runway. He was lower then normal at his initial and downwind points but after being prompted by the instructor (ip), the student angled…NTSB SEA82DA083Accident · Minor injuriesFinal reportGrumman G-164A · Dayton, WAThe pilot had just returned to the area after picking up a load of di-syston. Another ag aircraft had been spraying in an adjacent field. The pilot circled and looked for the other aircraft, but did not see it. He stated that he checked the smoke to determine…NTSB SEA82DA082Accident · No injuriesFinal reportHughes 269A · 2nm Nnm Redmond, WAThe engine lost power during the climb and the pilot executed an autorotation. Upon landing the aircraft rocked back and the main rotor severed the tail boom.NTSB SEA82DA080Accident · No injuriesFinal reportEagle DW-1 · Sprague, WAThe pilot had checked out in this make and model of aircraft on the preceeding day. On the day of the accident, he was spraying fertizer in a crosswind condition. He stated that he was on a downhill swath run in gusty conditions when he deployed the controls…NTSB SEA82DYE07Accident · 1 fatalFinal reportStarduster TOO SA300 · Sequim Bay, WAWhile flying over a lake at low altitude, the left wing of the aircraft struck wires on a moored sailboat about 50 ft above the water level. Three witnesses report that just prior to the collision, the pilot dipped or wagged his wings and waved at them. After…NTSB SEA82DA123Accident · No injuriesFinal reportCessna 150 · Chelan, WAThe pilot reported that during arrival, the wind sock provided little information since it had previously been torn by a wind storm. At wenatchee, WA, the wind was from 260 degrees at 16 gusting 22 KTS. The pilot reported that during a crosswind landing, the…NTSB SEA82DA075Accident · No injuriesFinal reportBellanca 7ECA · Roche Harbor, WAThe aircraft drifted off the runway during landing and collided with a ditch. The right main landing gear collapsed.NTSB SEA82DA074Accident · No injuriesFinal reportCessna 172G · Lester, WAThe pilot elected to takeoff from an airport that was officially closed to aircraft operations by the FAA because of winter flood damage to the runway. The aircraft cleared two large fir trees about 500 ft from the end of the runway but struck trees about 400…NTSB SEA82DA072Accident · No injuriesFinal reportBell 47G-2 · Grandview, WAWhile dispensing herbicide (systox) over an apple orchard the pilot sensed that the engine was binding followed by a power loss. The pilot elected to dump the herbicide and performed a power-off autorotation landing in a grape vineyard. Investigation revealed…NTSB SEA82FYM15Accident · 3 fatalFinal reportBeechcraft S35 · Walla Walla, WAWhile en route on a dark night, the aircraft collided with mountainous terrain in a heavily wooded, snow covered area. An investigation revealed that the plane crashed while in or near level flight at an altitude of about 4500 ft MSL. The top of the mountain…NTSB SEA82DA069Accident · No injuriesFinal reportPiper PA 28-181 · Port Angeles, WAAbout 10 minutes after takeoff, the pilot realized that he was south of course. After beginning a shallow turn back to course, he realized that he was in close proximity to mountainous terrain. He made an abrupt 40 degree left bank to get away from the…NTSB SEA82DA067Accident · No injuriesFinal reportCessna A185F · N.W. Of Copalis, WADuring the landing roll the pilot applied brakes and the tailwheel equipped aircraft nosed over. The runway surface is characterized as hard/damp sand due to its proximity to the ocean and is periodically submerged during high tide conditions.NTSB SEA82DA065Accident · Minor injuriesFinal reportCessna 182P · Walla Walla, WAAfter arriving in the Walla Walla area the pilot executed a spiraling descent, using carburetor heat, so as to arrive at pattern altitude. When he commenced a level-off the engine would not respond. A force landing was executed into a nearby field.…NTSB SEA82DA062Accident · No injuriesFinal reportCessna 172N · Lisabuella, WAThe pilot landed on a freshly mowed, grass runway. He reported that he had a left crosswind at 10 gusting 15 knots. The aircraft touched down at about 1/3 of the way down the runway. About 450 ft from the departure end, the brakes were applied. However, the…NTSB SEA82DA060Accident · No injuriesFinal reportCessna 150G · Camas, WAAfter receiving 2.9 hrs of dual instruction in this make and model of aircraft, the student proceeded on a supervised solo flight. The first approach and landing were observed by the instructor to be normal. The second approach was made with 20 degrees of…NTSB SEA82DYE06Accident · 1 fatalFinal reportBeech 23 · Greenwater, WAAt about 1620 local time on 4/24/82, the aircraft departed burley, id and proceeded on a VFR flight plan to tacoma, WA. The mountains east of seattle were obscured by an overcast ceiling beginning at 3500 ft. during a descent from 10,500 ft into the seattle…NTSB SEA82DA059Accident · Minor injuriesFinal reportWeatherly 201A · Hartline, WAWhile landing on a roadway, the right main landing gear encountered soft, loose dirt. The pilot applied left braking action to maintain directional control, and the aircraft nosed over.NTSB SEA82DA055Accident · No injuriesFinal reportHughes 500C · Darrington, WADuring an approach to a 9100 foot high snow covered landing site the wind shifted to a tailwind condition. The pilot elected to continue and attempted a skid on landing. While skidding through the snow the left skid impacted rising terrain underneath a 12…NTSB SEA82FYP07Accident · Serious injuriesFinal reportBeech 77 · Richland, WAWhile flying over a government reservation at night, the aircraft struck the side of a mountain about 1000 ft below the mountain top. A seat belt "d-ring" failed and the pilot went through the windshield when the aircraft struck a slope of about 60 degrees.…NTSB SEA82DA053Accident · No injuriesFinal reportWeatherly 201C · Espanola, WAThe pilot stated that during climb the engine power suddenly went to idle. A forced landing was made in a soft plowed field where the aircraft nosed over. No mechanical malfunctions were found during the engine examination however it was noted that conditions…NTSB SEA82FA052Accident · 1 fatalField investigationFinal reportCessna A152 · Bremerton, WAThe pilot took off downwind and against traffic in marginal weather conditions. No flight plan was filed and there was no record of a weather briefing. During departure, a near-miss occurred between N761QZ and a light twin-engine aircraft on an instrument…NTSB SEA82DA050Accident · No injuriesFinal reportBell 47G-2A · Lyle, WADuring takeoff with a load of fertilizer, insufficient power was available to maintain engine and rotor RPM and sustain flight. The pilot dumped the load, but was unable to avoid ground contact. The tail rotor struck first and separated from the aircraft. The…NTSB SEA82DA049Accident · No injuriesFinal reportPiper PA-28-181 · Spokane, WAStudent pilot/copilot reset the aircraft clock in anticipation of the time zone change that would occur in flight. This caused the pilot to think he had another hour of flight time. In addition the fuel gage was found to show fuel in the right tank when all…NTSB SEA82DA048Accident · No injuriesFinal reportPiper PA-25-235 · Basin City, WADuring a return trip to the landing area from a dusting run the engine stopped. The main landing gear caught wires during an attempted landing to a field and the aircraft turned over before colliding with the ground. The fuel tanks were found empty and the…NTSB SEA82DA045Accident · No injuriesFinal reportRockwell Intl. S-2R · Eureka, WAAfter spraying most of his load, the pilot made a dry pass and dropped a smoke flare. The flare was dropped to check the drift of the air relative to a susceptible crop east of the field being sprayed. After dropping the flare, the pilot made a 180 degree…NTSB SEA82DA044Accident · No injuriesFinal reportHiller UH-12E · Near Toutle, WAAbout 1 1/2 minutes after takeoff, the pilot heard a loud "bang" which was followed by a vertical and lateral vibration. The helicopter began to descend, pitch forward, and roll right as the vibration increased. The pilot elected to make an autorotative…NTSB SEA82DA042Accident · No injuriesFinal reportCessna 150H · Camas, WADuring the pilot's sixth touch and go landing the aircraft struck a tree on short final. The pilot maintained control of the aircraft and completed his landing.NTSB SEA82DA043Accident · Minor injuriesFinal reportCessna 150F · Hoquiam, WAThe private pilot had been making touch and go landings with a passenger on board for about one hour. He had made about 6 or 7 uneventful landings. On the last approach, the nose pitched down when the plane was about 50 ft AGL over the numbers. The empennage…