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 SEA87LA175Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Tukwila, WAWhile attempting to land in a field and at about 3 feet AGL, the pilot attempted to secure the right cabin door. Due to the distraction the pilot allowed the rear skids to contact the ground and a hard landing resulted.NTSB SEA87LA172Accident · Serious injuriesLimited investigationFinal reportBell 47G2 · Grandview, WAAfter the completion of spray operations the pilot was attempting to place the helicopter onto a trailer. The pilot misjudged his position, over-corrected, and then lost control of the helicopter, striking the ground.NTSB SEA87LA171Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Kelso, WAThe plt stated that during touchdown a hard bounced landing occurred. He then elected to execute a go-around and inadvertantly entered into a departure stall. The acft struck the ground in a right wing down, nose low attitude.NTSB SEA87LA168Accident · No injuriesLimited investigationFinal reportBeech G35 · Kent, WAShortly after rotation a propeller blade separated from the aircraft with the remaining propeller hub assembly and the other blade also falling from the aircraft. The pilot was able to land the aircraft straight ahead on the remaining runway. The hub was…NTSB SEA87FA166Accident · 1 fatalField investigationFinal reportCessna 172RG · Kettle Falls, WAWhile on a local personal flight, plt entered a canyon into rising terrain, colliding first with a tree and then ground near crest. Investigation revealed that acft probably had performance to clear crest had tree not been struck. Circumstances indicate plt…NTSB SEA87FA165Accident · 1 fatalField investigationFinal reportFleet 16B · Bellevue, WAThe pilot executed an emergency landing on a golf course after a power loss which he attributed to carburetor ice. Subsequent to the landing the aircraft was fueled with 10 gallons of automotive gasoline. The fuel was checked for water at the strainer drain…NTSB SEA87LA160Accident · No injuriesLimited investigationFinal reportCessna TR182 · Eatonville, WAThe plt rprtd that drg a lndg, the apch was a little high & the acft touched down long on the turf/gravel rwy. He thought there was sufficient rwy remaining to stop & did not initiate a go-around. However, he said 'braking on dry grass & moss was not…NTSB SEA87LA153Accident · No injuriesLimited investigationFinal reportCessna 182A · Sunnyside, WAThe plt rprtd that when he was lndg on rwy 25, the sun was just above the horizon & shining directly down the rwy. He said he misjudged the distance to the ground & lndd hard on the nose gear. Subsequently, the nose gear collapsed, the acft veered off the…NTSB SEA87LA151Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Plymouth, WADrg a swath run, a total loss of power occurred when the eng's #9 cylinder failed. The plt made a forced lndg in a soft potato field, but the acft nosed over after it slowed to about 20 KTS.NTSB SEA87LA147Accident · No injuriesLimited investigationFinal reportCessna T210K · Bellevue, WAAfter tkof, the plt leveled at about 1500' & adjusted the pwr to a low cruise setting. A short time later, the eng bgn missing & subsequently lost all pwr. The plt followed the emerg procedures, but was unable to restart the eng. He manuevered the acft to…NTSB SEA87LA140Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Deer Park, WADuring initial climb, at about 100 feet AGL, a loss of power occurred. The pilot made a shallow turn to avoid obstacles and landed in a plowed field. During landing roll the nose gear and right main gear collapsed, dragging the right wing. No reason could be…NTSB SEA87LA156Accident · No injuriesLimited investigationFinal reportBoeing IB75A · Spokane, WAThe plt rprtd that when he landed, the wind was from 190 deg at 6 gusting 12 KTS. Drg the landing roll, after slowing to an estimated 15 KTS, the acft encountered a gust of wind which caused 'the right wing to dip.' Subsequently, the acft 'rotated' about 60…NTSB SEA87LA138Accident · No injuriesLimited investigationFinal reportCessna 185 · Lake Chelan, WADuring takeoff from the water the plt noticed a log protruding out of the water. The acft struck the log and the plt rotated prematurely, became airborne, and then descended striking the water hard.NTSB SEA87LA136Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Lester, WADuring landing roll onto the closed runway the aircrafts right wingtip struck a post. The airport was notamed closed but no x's had been marked on the runway.NTSB SEA87LA137Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Cashmere, WADuring aerial applications maneuver a loud whine accompanied by a loss of power occurred. During forced landing a hard landing was made collapsing the skids with the main rotor blades striking the ground. No reason for the power loss was found.NTSB SEA87LA133Accident · No injuriesLimited investigationFinal reportMooney M-20 · Spokane, WAAt touchdown a prop strike occurred. The pilot immediatley added full power to go around. Since the prop strike was severe full power was not available. The pilot made a shallow 180 degree turn back to the rwy and landed on the grass. During the landing…NTSB SEA87FA129Accident · 2 fatalField investigationFinal reportCessna 150G · Vashon, WAAircraft departed on a routine instructional flight. Radar track indicated aircraft engaging in maneuvers typical of instructional high work (stalls/turn/slow flight) followed by left orbit about grass airstrip used only for practice emergency landing…NTSB SEA87LA198Accident · No injuriesLimited investigationFinal reportCessna 150A · Tacoma, WAWhile lndg, the plt decided to go around. He stated the acft floated as he applied pwr & the pwr increased to about 2400 RPM. He raised the nose slightly & retracted the electrically operated flaps from 35 to zero deg. He said he established a climb to about…NTSB SEA87LA130Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Olympia, WADuring landing roll the pilot was unable to maintain directional control. The aircraft veered to the side of the runway onto soft terrain. The aircraft then nosed over inverted. Investigation revealed that the nose gear had collapsed but the reason for the…NTSB SEA87FA124Accident · 2 fatalField investigationFinal reportBeech 77 · Spokane, WAOn takeoff the aircraft climbed to 50-75 ft AGL, descended in a landing attitude, touched down on the runway near the departure end and took off again. When approaching high obstructions off the end of the runway, the aircraft entered a steep climb, rolled…NTSB SEA87LA120Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Yakima, WAWhile on landing roll in gusty crosswind conditions, the aircraft swerved off the runway and ground looped.NTSB SEA87IA119Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-101 · Seattle, WAThe crew of the scheduled airline passenger flight experienced an explosion and fire in the right engine at approx 800 ft AGL during initial climb after takeoff. The pilot shut the engine down, activated two fire bottles, which extinguished the fire and…NTSB SEA87LA116Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Odessa, WADuring landing roll on a dirt road, the aircraft drifted to the side, encountered the shoulder ditch and flipped over.NTSB SEA87LA111Accident · Minor injuriesLimited investigationFinal reportde Havilland DHC-2 MK.1 · Sedro Woolley, WAShortly after takeoff a loss of power occurred and the aircraft struck trees in flight. Less than 1/2 fuel was available in all three fuel tanks. The fuel selector valve was tested and found that the selections plate was indexed off center for all selections…NTSB SEA87LA113Accident · No injuriesLimited investigationFinal reportCessna 172P · Snohomish, WAThe pilot initiated a landing on a 2650 ft long runway in a 11-18 knot quartering tailwind condition. He flew the final approach too fast and flared prematurely. The acft floated down the rwy, landed hard and bounced twice. The plt lost control and the acft…NTSB SEA87LA109Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Vancouver, WADuring a practice run-on landing the aircraft started to vibrate violently and an almost simultaneous fire occurred. Both pilots and an eyewitness stated that the run on landing was very smooth. Both pilots stated that something mechanical let loose during…NTSB SEA87LA108Accident · No injuriesLimited investigationFinal reportCessna T210L · Dayton, WADuring landing the aircraft floated. The pilot elected to make a go-around but had used up more than one half the runway. Shortly after applying full power the pilot reduced power to idle for landing on a barley field at the departure end of the runway.…NTSB SEA87LA107Accident · No injuriesLimited investigationFinal reportAerodynamics . Hawk Mkii · Ellensburg, WADespite warnings from the flight service station about turbulence, high winds aloft, severe low level wind shear, and low ceilings along the pilots intended route of flight, the pilot elected to depart the airport for his destination. Standing lenticular…NTSB SEA87LA103Accident · No injuriesLimited investigationFinal reportAyres S2R · Walla Walla, WADuring takeoff run the right main gear collapsed. The right wing dropped and the aircraft spun to the right. The plt discovered that the right main gear failed at the weld. The pilot, who is also an a & p mechanic, stated that this was an original weld from…NTSB SEA87FA106Accident · 1 fatalField investigationFinal reportHiller UH-12E · Shelton, WAThe pilot was properly certificated for the flight; however, due to operator insurance restrictions, all prior commercial flights had required the owner/operator to accompany this pilot, therefore this was the pilot's first commercial flight as sole pilot.…NTSB SEA87LA101Accident · Minor injuriesLimited investigationFinal reportAero Commander AC-100 · Alderwood Manor, WADuring takeoff on a short 1700 foot airstrip under no wind conditions, close to gross weight, the aircraft was not able to clear trees at the departure end of the runway. The pilot recognized this and reduced power for a precautionary landing onto an adjacent…NTSB SEA87FA100Accident · 3 fatalField investigationFinal reportCessna 172 · Ritzville, WAOccupants of both acft were family members traveling in company for holiday. Takeoff was about one min apart with N44726 in trail. Due higher norm crz performance, N44726 overtook N5711A. Plt of N44726 reduced speed and established position about 1/2 mile to…NTSB SEA87LA099Accident · No injuriesLimited investigationFinal reportMeyer 77-1 · Bellingham, WAA gusting 90 degree crosswind was present during the takeoff. A gust raised the aircrafts left wing and the pilot over-corrected with left aileron and left rudder. The aircraft then stalled, impacting the runway in a left wing down, nose low attitude. This…NTSB SEA87LA095Accident · No injuriesLimited investigationFinal reportPiper PA-20-115 · Seattle, WADuring landing roll with a crosswind from the right a ground loop occurred. The pilot had just completed a solo cross country flight. The wind was from 210 degrees at 9 knots. The pilot was landing on runway 13L.NTSB SEA87LA161Accident · No injuriesLimited investigationFinal reportGrumman AA1B · Ocean Shores, WAThe plt landed his acft onto a golf course which had been the previous site for the airport. The airport had been closed since December 1985 and relocated close by. The pavement at the old airport had been replaced by sod. During landing roll, the aircraft…NTSB SEA87LA090Accident · Minor injuriesLimited investigationFinal reportRutan VARI-EZE · Renton, WAWhile being hand propped the aircraft began to move. The pilot then attempted to climb inside the aircraft but the canopy had closed. The pilot held onto the aircraft and was dragged across the end of the runway. The aircraft struck a parked, unoccupied…NTSB SEA87LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Blakely Island, WAThe plt landed with excess airspeed past the first third of the downhill runway. The aircraft bounced and the pilot added a little power. The aircraft then struck the runway with the nose gear. Since the plt feared going off the end of the runway into the…NTSB SEA87LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · Renton, WADuring touch and goes the student plt landed hard and flat. The aircraft then bounced three times and at the end of the third bounce landed on the nose gear and propeller collapsing the nose gear.NTSB SEA87LA082Accident · Minor injuriesLimited investigationFinal reportBell 206-BIII · Kent, WADuring takeoff to a hover the helicopter rolled to the left. The student pilot over corrected. The helicopters right skid contacted the ground with the student pilot making a rapid increase in collective rate causing the helicopter to roll to the right onto…NTSB SEA87LA081Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Alderwood, WAThe student pilot took off and landed with a 15 knot tailwind. During his second attempt to land an overun occurred. The aircraft departed the runway to the left onto soft ground where it nosed over inverted. This was the student pilots second solo flight.…NTSB SEA87LA079Accident · No injuriesLimited investigationFinal reportHughes 369HS · Yakima, WASix miles from the airport, at cruise, the engine ceased operating due to fuel exhaustion. The plt had noticed the low fuel warning light on 10 minutes prior to the engine failure but elected to continue his flight. Autorotation was made from 1,000 feet AGL…NTSB SEA87LA075Accident · No injuriesLimited investigationFinal reportVerbeek Rotorway · Redmond, WAThe plt stated that while at cruise the acft developed a vibration and noise, followed by a power los. The plt then entered into an autorotation and landed onto a rough field. The acft touched down hard and then rolled onto its side. During engine inspection…NTSB SEA87LA074Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Forks, WADuring external load operation the aircraft's engine ceased operating. The helicopter was too close to the ground for recovery. The helicopter descended, struck the ground hard and then rolled over onto its right side. Water in the fuel was discovered after…NTSB SEA87LA071Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Issaquah, WADuring a local training flight a downdraft was encountered. At about two miles from the airport the acft was at about 200 feet MSL. The instructor plt decided to land the acft on a field. On short final the acft struck a barbed wire fence prior to touchdown.NTSB SEA87LA066Accident · No injuriesLimited investigationFinal reportCessna 172 · Lopez Island, WADuring cruise the acft engine quit due to fuel exhaustion. The pilot neglected to visually check the fuel tanks prior to departure, but rather relied on fuel gauges and his own estimation that enough fuel would be remaining to complete the flight. During…NTSB SEA87FA064Accident · No injuriesField investigationFinal reportCessna 402A · Walla Walla, WADuring lndg roll the rt main lndg gear of the Cessna 402A collapsed. Visual inspection of the bell crank assembly revealed fracture surfaces similar to those of instantaneous overload.NTSB SEA87LA059Accident · No injuriesLimited investigationFinal reportBell 206B-III · Dayton, WAPlt lifted off with fertilizer bucket on 3-FT external hook. As fwd motion commenced, acft settled slightly, dragging bucket on ground and tipping it over. Plt attempted to recover by backing up, but skid caught on bucket, causing loss of control.NTSB SEA87LA054Accident · No injuriesLimited investigationFinal reportRobinson R22 · Brinnon, WAWhen psgr became nauseous in flt, plt attempted downwind lndg onto pinnacle in rough terrain. Acft contacted slope short of intended point of lndg, main rotor flexed downward, severing tail boom.NTSB SEA87LA050Accident · Minor injuriesLimited investigationFinal reportBeech B23 · Alderwood Manor, WAThe pilot, after exhausting all fuel in one tank, failed to select the remaining fuel tank during his approach. His unfamiliarity with the make/model of the accident aircraft is considered a factor in his failing to locate the fuel selector and switching to…NTSB SEA87FA051Accident · 2 fatalField investigationFinal reportCessna 150J · Vancouver, WAAircraft was returning from stage 3 instructional flight during which instructor normally allowed student to fly. Evidence indicates aircraft passed in vicinity of heavy bird activity and student executed nose down bird avoidance maneuver. Instructor, for…