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 SEA84LA076Accident · No injuriesLimited investigationFinal reportLake LA-4 · Alderwood Manor, WAAccording to a witness, he observed the acft from taxi to takeoff, then from base throughout the landing. He observed the acft with the gear down on base leg & said the plt flew a low & short final apch. He stated the plt cut power short of the rwy & the acft…NTSB SEA84LA072Accident · No injuriesLimited investigationFinal reportCessna A185F · Kennewick, WAThe plt was performing touch and go landings when he lost control of the acft and groundlooped. The wind was gusting to 15 KTS.NTSB SEA84LA069Accident · No injuriesLimited investigationFinal reportPiper PA 23-1300 · Battleground, WAThe acft had been parked on the ground for 2 yrs. Prior to the flt, it had been run-up several times. There was about 20 gal of fuel in each tank. The plt checked the fuel before takeoff & some water was found. He drained the fuel until no water was found.…NTSB SEA84FA064Accident · 2 fatalField investigationFinal reportCessna U206 · Stevenson, WAThe plt initiated a flt in weather with low visibility, rain and fog. The plt had reportedly checked the weather but decided to fly anyway. About 30 minutes after takeoff while the plt was maneuvering at low alt, the acft crashed in a river. The acft sank in…NTSB SEA84LA062Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Pullman, WAAccording to the student plt, the winds were prevailing from the southeast at 5 to 10 KTS, but were shifting & gusting to 20 KTS. During a landing on rwy 5, the acft veered off the right side side of the rwy, then struck a ditch & nosed over.NTSB SEA84FA060Accident · 3 fatalField investigationFinal reportCessna 172N · Kent, WAAt about 1345 PST, the plt of a Cessna 172N, N4603F, departed crest airpark, Kent, WA, on a local pleasure flt. Aprx 5 min later, the plt & 1 passenger of a float equipped Cessna 180, N4908A, took off from lake meridian, Kent, WA, & were also on a local…NTSB SEA84LA051Accident · No injuriesLimited investigationFinal reportCessna 172 Rgii · Seattle, WADuring a takeoff after a touch and go landing the nose gear retracted at about the time of rotation. Power was reduced to idle and the acft slid to a stop. This acft is equipped with squat switches which prevent gear retraction when the weight of the acft…NTSB SEA84LA049Accident · No injuriesLimited investigationFinal reportCessna A185F · Winslow, WADuring a water landing the acft was in turbulent crosswind conditions when the left float and wing dug into the water. The acft cartwheeled and came to rest with the right wingtip touching the bottom of the bay. The plt stated it would have been more prudent…NTSB SEA84LA046Accident · No injuriesLimited investigationFinal reportLark IS28B2 · Issaquqh, WAThe CFI stated that while returnsing to the airport he encountered turbulence. When it became obvious that reaching the intended airport would be marginal another landing field was chosen. During turn to final, the left wing tip struck a power pole and the…NTSB SEA84LA040Accident · No injuriesLimited investigationFinal reportBeech A35 · Renton, WAThe acft was damaged during a forced landing after the engine quit after takeoff. The plt said he noticed the oil pressure drop to zero a few minutes after takeoff and was turning back to the arpt when the engine quit. He did not lower the landing gear since…NTSB SEA84IA042Incident · No injuriesIncident investigationFinal reportCessna CE500 · Yakima, WAThe acft made a hard landing while on a training flt. According to the instructor plt, 'during the landing flare, we were descending very gradually as the airspeed continued to dissipate.' Late in the flare the angle of attack indicator was approaching the…NTSB SEA84LA043Accident · No injuriesLimited investigationFinal reportRaven Rally RX7 · Aibirm, WAThe plt stated that the wind shifted during landing and the balloon touched down hard and lifted off again. With power lines ahead a decision was made to cross over but the balloon struck the lines. Several cables were burned through and the balloon was torn…NTSB SEA84LA039Accident · No injuriesLimited investigationFinal reportCessna 150H · Deer Park, WAThe acft was damaged during a forced landing after the engine lost power. Post accident investigation revealed no fuel aboard the acft. The flt lasted 4 hours and 15 minutes. This acft endurance is 4.4 hours.NTSB SEA84IA037Incident · No injuriesIncident investigationFinal reportBoeing 727-223 · Seattle, WAThe capt stated that upon visual contact with the rwy, the acft was displaced slightly to the lt & he corrected toward centerline with rt rudder. Wing tip contact was neither heard not felt in the cockpit. There were several concurrent reports of arriving…NTSB SEA84IA033Incident · No injuriesIncident investigationFinal reportBoeing B-727-90C · Seattle, WAThe acft struck the approach lights to rwy 16R while on an ILS approach. Analysis of the FDR readout showed an increased descent rate following visual sighting of the rwy environment.NTSB SEA84FA032Accident · 1 fatalField investigationFinal reportStinson 108-1 · Vashon, WAJust after taking off in IMC at night, the acft crashed near the departure end of rwy 36. According to a witness, the acft climbed after takeoff to about 200 ft above the trees, then entered a descent & disappeared behind a tree line. After crashing, the acft…NTSB SEA84FA031Accident · No injuriesField investigationFinal reportPiper 601P · Garfield, WAThe acft was forced to land on a road due to a fire in the left wing. During the investigation of the accident it was found that the left turbocharger had been removed and reinstalled several times. A clamp on the turbocharger exhaust wasimproperly installed…NTSB SEA84LA027Accident · No injuriesLimited investigationFinal reportCessna 150F · Prosser, WAAccording to the pilot shortly after departure the engine began running rough for the second time. The pilot elected to make a precautionary landing on a gravel road he was familiar with. During the landing flare, with a gusty crosswind, directional control…NTSB SEA84FA101Accident · 1 fatalField investigationFinal reportCessna T210M · East Sound, WAThe acft collided with steeply upsloping terrain along the NE side of orcas island. The plt had been reportedly flying throughout the puget Sound/pacific nw area for more than 10 years & was familiar with the terrain & associated wx. Several plts located in…NTSB SEA84FA023Accident · Serious injuriesField investigationFinal reportCessna 304A · Ephrata, WAThe acft collided with a hilltop during a missed approach in IMC weather. The acft was on an IFR flt plan. The plt stated visual contact was EST at about 2000 ft MSL but ground features were masked in snow. When the plt did not see the airport at the proper…NTSB SEA84LA019Accident · No injuriesLimited investigationFinal reportMorton B8M · Shelton, WAThe acrt collided with fir trees, about 18 feet tall, during an off-arpt forced landing after a power loss. The plt suspected carburetor ice. He said the engine began to run rough and RPM dropped to about 1200/1500 RPM. When he was unable to clear the trees…NTSB SEA84FA013Accident · 2 fatalField investigationFinal reportCessna C-152-II · Belfair, WAThe flight originated at aprx 2100 hrs. The pilot said his intention were to remain in the traffic pattern and practice touch and go landings. The aircraft crashed 1 mile south of the airport.NTSB SEA84FA011Accident · Serious injuriesField investigationFinal reportBoeing A75N1 · Brewster, WAThe plt was positioning the acft for swath runs when it crashed into rising terrain on the side of a hill next to a valley. The plt had planned to make swath runs over an orchard in the valley. During impact, he received serious head injuries & could not…NTSB SEA84IA008Incident · No injuriesIncident investigationFinal reportS.N.I.A.S. AS350D · Seattle, WAThe acft sustained a complete failure of the tail rotor drine shaft due to fatigue from stress corrosion precipitated byprevious damage at which time no logbook entry was recorded to indicate that the shaft had been inspected.NTSB SEA84LA003Accident · No injuriesLimited investigationFinal reportCessna T210M · Seattle, WAAfter takeoff while on a right turnout from rwy 31L, & at about 1000 ft AGL, the eng quit. The plt returned to the arpt & elected to lower the gear when he knew rwy 13L could be reached. However the left main gear failed to lock prior to touchdown & the…NTSB SEA84LA002Accident · No injuriesLimited investigationFinal reportHiller UH12-E · Tenino, WAThe plt visually checked the fuel tanks prior to takeoff & thought he had seen fuel in the tanks. The fuel gauges were inoperative & he was using timing as a method to determine the remaining fuel. Aprx 5 min after takeoff, the eng lost power as he was lining…NTSB SEA84LA004Accident · No injuriesLimited investigationFinal reportCessna 180 · Silverdale, WAThe plt stated he was demonstrating how not to ground loop an airplane. When speed was built up on the taxiway, he applied brakes & the left brake failed. The left main gear & left wing folded.NTSB SEA83LA206Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Selah, WAWhile landing on a road, during an aerial application operation, the acft nosed over. According to the plt, the brakes had not released after he had released the toe brakes. He reported that he found the parking brake midway between the on & off positions.NTSB SEA83LA205Accident · Minor injuriesLimited investigationFinal reportHughes 369B · Cougar, WAThe aircraft collided with trees and terrain during a forced landing attempt following an in-flight power loss. Subsequent engine teardown revealed failure of several components.NTSB SEA83FA204Accident · 2 fatalField investigationFinal reportLake LA-4-200 · Eastsound, WAThe acft collided with the glassy water during a low alt maneuver. The acft was observed by witnesses to descend from about 100 ft in a flat attitude,touch down,skim along the water then the nose pitched down and the acft nosed over. The occupants were…NTSB SEA83FU009Accident · Serious injuriesFinal reportCGS Hawk · Richland, WAAfter being assembled, the ultralight vehicle was taxi tested, and on 9/19/83, it was flown on its 1st flt. The next morning it was taxi tested again. At aprx 0855 PDT, the plt took off on a local flt. At aprx 0945, after making a touch-and-go landing, the…NTSB SEA83LA193Accident · Minor injuriesLimited investigationFinal reportAnderson Starduster TOO SA300 · Lynnwood, WAThe plt reported that during flt, there was a change in the engine sound which was followed by a drop in fuel pressure. The plt started to look for a place to land when a total loss of power occurred. He elected to land on a football field. However, after…NTSB SEA83FA096Accident · Serious injuriesField investigationFinal reportStinson 108-2 · Quilcene, WAThe acft collided with trees at the 2800 ft level of a mountain after the pilot encountered IMC weather. The weather wasvmc in the area but the mountain ranges had been forecast to be obscured in weather. The pilot had received a weather briefing. The acft…NTSB SEA83LA199Accident · No injuriesLimited investigationFinal reportBellanca Gcbc · Spokane, WAAccording to the operator, the plt was practicing touch & go landings. During a landing, the acft ground looped & the left horizontal stabilizer struck a VASI light. The plt reported that he had 4.2 hrs in this make & model.NTSB SEA83FA198Accident · Serious injuriesField investigationFinal reportBell 205A-1 · Elk Rock, WAThe acft was climbing thru about 800 ft AGL, when the plt noted a severe shudder & vibration. He lowered the collective, then noticed that the N2 & rotor RPM were pegged at 110%. As he reapplied the collective to stop the overspeed, he noted a loss of thrust…NTSB SEA83LA200Accident · No injuriesLimited investigationFinal reportMaule M-4 · Monroe, WAThe plt reported that he was practicing touch-and-go landings with a friend that was a certified flt instructor (CFI). After a landing, the friend indicated his desire to fly the acft. The plt offered to let his friend fly it from the left seat. The friend…NTSB SEA83LA195Accident · No injuriesLimited investigationFinal reportMooney M20-F · Seattle, WAThe plt stated he experienced a complete power loss while flying over puget sound at 700 ft. the acft sank & was not recovered.NTSB SEA83LA191Accident · No injuriesLimited investigationFinal reportGulfstream American AA-1 · Eatonville, WAThe acft collided with a tree during a go-around. The pilot was able to continue flt to another arpt and complete a landing. During the attempted landing at the accident arpt the pilot stated she 'did not touch down when I expected'. During the go-around the…NTSB SEA83LA192Accident · No injuriesLimited investigationFinal reportCessna P210N · Wenatchee, WAThe plt was practicing touch & go landings. After completing 2 touch & go's, he elected to practice a smiulated forced landing. He reported that he lowered the landing gear when the acft was on a downwind leg. However, the plt did not report whether or not…NTSB SEA83FA189Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Everett, WAThe acft collided with trees and the ground in an attempt to return to the arpt after takeoff. The acft crashed one milesouth of the arpt in IMC weather in the early hours of the morning. Witnesses said dense fog existed at the time with zero visibility. The…NTSB SEA83LA188Accident · Serious injuriesLimited investigationFinal reportGrumman G-164 · Quincy, WAThe acft collided with a car on the rwy during an aborted landing at a private airstrip. The pilot saw the auto as he turned base but believed the driver would cross and clear the rwy. Instead the driver went down the rwy in the directionof landing. When the…NTSB SEA83LA190Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Burlington, WAThe acft groundlooped after the main landing gear collapsed during landing. Investigation revealed that the main landinggear tubing failed after being weakened by corrosion inside the tube.NTSB SEA83FA186Accident · Serious injuriesField investigationFinal reportCessna 150F · Bellingham, WAThe plt & passenger departed on a local sight-seeing flt. While flying low over the narrow part of lake samish, the acftcollided with a power line, then crashed in the water. The power lines were 129 ft above the water at the lowest point.NTSB SEA83LA185Accident · Serious injuriesLimited investigationFinal reportCessna 140 · College Place, WAThe acft collided with power line poles during an emergency landing. The pilot reported a power loss during takeoff and witnesses reported that the engine was sputtering during takeoff and quit during climb out. Post accident investigation showed the acft…NTSB SEA83LA183Accident · No injuriesLimited investigationFinal reportCessna 175 · Chelan, WAThe acft stalled into an apple orchard during an attempted go-around. The plt said he was being pushed by a crosswind and during the initial flare was unable to correct so he decided to go-around. During go-around the acft was to the leftof the rwy. The plt…NTSB DCA83AA036Accident · 11 fatalFinal reportLockheed Learstar, L-18-56 · Silvana, WAThe acft was on a sport parachute flt to carry 24 parachutists to 12,500' over a drop zone (dz) for a mass jump. It was in a cargo configuration with no passenger seats, but it had 1 jump seat. There were 24 seat belts on the floor of the cargo area. Also,…NTSB SEA83LA182Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Arlington, WAThe acft nosed over while taxiing unoccupied after being hand propped for a start by the pilot. The pilot stated that hewas unable to start the acft normally so he hand propped it with no one in the cockpit. The unoccupied acft taxied from the ramp across the…NTSB SEA83LA181Accident · No injuriesLimited investigationFinal reportBeech 35 · Decatur Island, WAThe acft collided with the ground during a short field takeoff attempt. According to the pilot he was using 10 degree of flaps during a short field takeoff. The acft yawed to the left & the pilot lowered the nose to regain control. Directional control was…NTSB SEA83FA178Accident · 1 fatalField investigationFinal reportCessna 150 · Granite Falls, WAThe acft collided with the ground in a vertical nose down attitude. The engine was imbedded 4 ft into the ground. All components of the acft were accounted for in the immediate area of the impact. Witnesses observed the acft in a left turn before falling into…NTSB SEA83AA176Accident · 5 fatalFinal reportFairchild Hiller FH-1100 · Toutle, WAThe helicopter took off on a sight-seeing, passenger flt in the mount st helens area. When the flt became overdue, a search was initiated. Later, the helicopter was found where it crashed & burned in a heavily wooded area on relatively level terrain, near the…