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 SEA88LA098Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Ritzville, WAWhile on an aerial applications flight, the pilot was climbing to clear power lines when a whirlwind was encountered. The aircraft struck a power pole and descended onto the ground.NTSB SEA88LA096Accident · No injuriesLimited investigationFinal reportCessna 172N · Anacortes, WAAfter overflying the intended seaplane base landing area. The pilot, who had logged only 1 hour of fixed wing time in the previous 90 days, misjudged the necessary downwind leg length and landed with insufficient surface distance available to stop the…NTSB SEA88LA125Accident · No injuriesLimited investigationFinal reportCessna 177B · Ocean Shores, WADuring taxi for takeoff, plt misjudged clrnc between wingtip and mowing machine.NTSB SEA88FA095Accident · 1 fatalField investigationFinal reportCessna 172L · Ocean Shores, WAThe student pilot departed on his fifth solo flight from the airport where he had been accustomed to originating his instructional flights. After several touch and go landings he proceeded to a nearby airport and conducted at least one more touch and go.…NTSB SEA88LA092Accident · No injuriesLimited investigationFinal reportCessna 185 · Mercer Island, WAThe pilot stated that the aircraft struck a log while landing on the water. The aircraft then nosed over inverted and sank.NTSB SEA88LA090Accident · No injuriesLimited investigationFinal reportAyres S2R Thrush · Lind, WADuring an aerial application maneuver, a total loss of power occurred due to the number nine cylinder failing. A restart was attempted, but was unsuccessful. The pilot made a forced landing onto a very soft sandy field, where the aircraft nosed over inverted…NTSB SEA88LA089Accident · No injuriesLimited investigationFinal reportCessna 172 · Kennewick, WADuring landing roll the aircraft's nose gear began to shudder, with the nose gear turning 90 degrees to the left. The aircraft then nosed down onto the nose and right wing. Visual examination of the aircraft's shimmy dampener arm assembly revealed a previous…NTSB SEA88LA085Accident · No injuriesLimited investigationFinal reportBeech 35 · Pasco, WADuring lndg roll, NLG and rmlg collapsed. During tow in from rwy, lndg gear cb was noted to be tripped. Cause of cb activation unk.NTSB SEA88FA078Accident · 3 fatalField investigationFinal reportPiper PA-32RT-300T · Port Angeles, WADrg arr, the flt was handed off to whidbey island apch ctl at whidbey island (nuw) naval air stn (nas). Nuw was 35 mi NE of the destn (fairchild intl arpt/clm), at Port Angeles, which had no operg ctl twr. The plt was given the nuw wx, which was 400 scat,…NTSB DCA88MA052Accident · Serious injuriesMajor investigationFinal reportde Havilland DHC-8 · Seattle, WAShortly after tkof from Seattle-tacoma intl airport, the crew noted a rt eng power loss and decided to return for a precautionary lndg. After lowering the lndg gear, a massive fire was discovered in the rt eng nacelle. After lndg, directional control and all…NTSB SEA88LA077Accident · No injuriesLimited investigationFinal reportBeech K-35 · Pullman, WAWhile on final for the runway the pilot advanced the throttle and the engine lost power. The aircraft was landed short of the runway onto a field, where the nose gear collapsed during the landing roll. Mechanics who examined the aircraft after the accident…NTSB SEA88LA072Accident · 1 fatalLimited investigationFinal reportSteen Skybolt GT-2 · Saint John, WAAfter tkof witnesses said the acft did a maneuver at 50-60 ft AGL that involved a steep (90 degree) banked turn to a snap roll. The biwing acft was capable of aerobatic flt and the plt had discussed aerobatic roll maneuvers on tkof with the acft co-owner. The…NTSB SEA88LA071Accident · No injuriesLimited investigationFinal reportCessna 172XP · Walla Walla, WADuring descent for landing the pilot noted a surge coming from the engine area, accompanied by an increase in rpm's. both the oil temperature and the oil pressure gauges were reading zero. The cylinder head temperature had reached 500 degrees and smoke was…NTSB SEA88LA068Accident · Serious injuriesLimited investigationFinal reportBellanca 7KCAB · Palmer, WAWhile on a VFR cross country flight the pilot encountered instrument meteorological conditions along his route. The aircraft was not instrument equipped, even though the pilot is instrument rated. The pilot had to make two precautionary landings prior to the…NTSB SEA88LA070Accident · No injuriesLimited investigationFinal reportCessna 305-A · Arlington, WAShortly after takeoff, at about 200 feet AGL, a total loss of power occurred. A forced landing was made onto a turf field next to the runway. During landing the aircraft nosed over inverted. The pilot stated to FAA inspectors that the aircraft had set outside…NTSB SEA88LA063Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Cashmere, WAThe acft touched down near midfield while landing on an 1800 ft long downsloping runway. When the pilot rapidly applied throttle for go-around, the engine faltered. He applied hard braking to stop on the runway and the aircraft nosed over.NTSB SEA88LA058Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Gold Bar, WAThe instructor pilot and his dual student flew into a canyon area. The aircraft was allowed to fly too close to rising terrain which the aircraft was unable to outclimb. During a turn to reverse direction the aircraft collided with terrain. The CFI stated…NTSB SEA88LA057Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Elma, WADuring landing roll the pilot applied toe brakes. The right brake pedal went to the floor. The aircraft then veered to the left of the centerline despite the pilots attempt to groundloop the aircraft. The aircraft then rolled over an embankment, collapsing…NTSB SEA88LA053Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Othello, WAThe student pilot encountered gusting winds and lost control of the aircraft during landing roll. The aircraft veered to the right of the runway and struck a parked unoccupied aircraft.NTSB SEA88LA052Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Yakima, WAThe pilot had just purchased the aircraft and was practicing takeoffs and landings. On the first landing attempt, during the ground roll after touchdwn, the pilot lost directional control and the aircraft ground looped.NTSB SEA88LA047Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Stevens Pass, WAPlanned flt was VFR transit of cascade mountains in daylight. Plt filed VFR flt plan; wx brief indicated VFR. Unforeseen delays resulted in arrival at planned mountain Pass over one hour late and wx no longer VMC. Plt could see alternate Pass to north…NTSB SEA88LA048Accident · No injuriesLimited investigationFinal reportCessna 172P · Friday Harbor, WAPlt was following taxi line and failed to note parked acft left wing intruding into taxi lane. Contact between left wing tips resulted.NTSB SEA88LA040Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Kennewick, WAAt about 75 feet AGL a total loss of power occurred. The plt landed on the remaining runway but overran the rwy, coming to rest 200 ft beyond the end. During the overrun, the nose gear struck a rock and the acft nosed over. The aircraft's fuel tanks contained…NTSB SEA88LA037Accident · No injuriesLimited investigationFinal reportCessna 172P · Vashon Island, WADuring landing roll the pilot made an intentional groundloop to avoid trees at the end of the short, wet, S0D runway. The pilot reported that the use of brakes was ineffective. He stated that he made the landing using 30 degs of flaps at an airspeed of 60…NTSB SEA88LA038Accident · No injuriesLimited investigationFinal reportCessna 150M · Port Angeles, WADuring cruise the pilot noticed a gradual loss of RPM. Carburetor heat was applied but the pilot stated that he noted no improvement in the engine power. The power loss continued to deteriorate so a landing was made onto a rough field where the nose gear…NTSB SEA88LA035Accident · No injuriesLimited investigationFinal reportCessna 172 · Everett, WAThe student pilot had landed with full flaps prior to the application of full power for takeoff. The aircraft veered to the left side of the runway into mud and nosed over inverted. The aircraft's flap indicator had been placarded inoperative by the operator.NTSB SEA88FA032Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Eastsound, WAThe plt depd south from an unattended island arpt at sea level & flew into marginal VFR conds with moderate snowfall. Acquaintances at the arpt rprtd the plt expressed an urgent need to return to snohomish, WA, despite the wx conds. When the acft did not…NTSB SEA88LA082Accident · No injuriesLimited investigationFinal reportCessna TU206G · Silverdale, WAWhile on the lndg roll with a qtrg hdwnd, the acft enctrd a gust which pushed it to the left. The plt said he applied full rgt aileron, but it had no effect. As the acft was 'being blown' toward trees, the plt applied full rgt brake. He said the left wing tip…NTSB SEA88LA027Accident · No injuriesLimited investigationFinal reportCessna 172M · Tacoma, WAThe Cessna was at the runup area for runway 35 preparing to do his runup. Three pitts aircraft were taxiing abreast of each other, when one of the pitts's propeller struck the right wingtip of the Cessna causing substantial damage to the Cessna and minor…NTSB SEA88FA021Accident · 1 fatalField investigationFinal reportCessna 210E · Port Townsend, WAThe aircraft flew into the side of maynard mountain, the point of a coastal land mass, while on a night VFR flight in IMC wx conditions. Radar data showed the aircraft on a straight course at cruise airspeed.NTSB SEA88LA020Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Sequim, WADuring dark night visual meteorological conditions, the aircraft struck trees while in cruise flt at about 2,000 feet MSL. Although the pilot had requested VFR traffic advisories, he did not solicit the use of the low altitude alert system. This system was…NTSB SEA88IA019Incident · No injuriesIncident investigationFinal reportBeech 99-A · Port Angeles, WABoth generator lights came on along with the left and right fuel pressure lights. The aircraft was being flown back to the airport for a precautionary landing, when the annunciator panel lights began to flicker. When landing flaps were selected they did not…NTSB SEA88MA015Accident · 4 fatalMajor investigationFinal reportCessna 310N · Bellingham, WAThe acft was chartered to take university (wwu) psnl to an alumni dinner. While rtrng at ngt, the plt made a localizer only, ILS rwy 16 apch in marginal VFR conds. Drg the apch, radar svc was terminated & the plt was told to ctc bellinghamradio, but he did…NTSB SEA88LA013Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Snoqualamie Pss, WAThe pilot was advised that with his proposed route of flight VFR was not recommended due to low clouds and marginal visibility. The pilot elected to fly through the area at night and encountered low clouds and marginal visibility. While attempting to climb…NTSB SEA88FA012Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Colville, WAAlthough the recently certificated private pilot was not checked out by the fixed base operator for night flight and had been warned to return before sunset, he departed the airport during dark night conditions. Witnesses reported observing the aircraft climb…NTSB SEA88LA008Accident · No injuriesLimited investigationFinal reportCessna T210N · Walla Walla, WAThe pilot landed short and the aircraft's main landing gear struck the edge of a plateau at the approach end of the private strip. The aircraft swerved off the grass runway, the nose gear collapsed, and the aircraft nosed over.NTSB SEA88LA005Accident · No injuriesLimited investigationFinal reportCessna 340A · Tacoma, WAAs the plt was taxiing to the active rwy, the acft's right brake became inop due to a loss of hydraulic fluid. Subsequently, the acft went off the side of the taxiway, contd over an embankment & was damaged. The loss of hydraulic fluid was due to a leak in…NTSB SEA88LA002Accident · No injuriesLimited investigationFinal reportKlien Avid Flyer · Edwall, WAWhile on a VFR final apch for lndg, the plt was watching for pwr lines which had to be cleared & diverted his attention from his airspeed. After clearing the pwr lines, the acft stalled & crashed on a roadway. The acft was not equipped with a stall warning…NTSB SEA88LA001Accident · No injuriesLimited investigationFinal reportBritish Aerospace BA-3101 · Kennewick, WAWhile on a flight to pasco, WA. The pilot inadvertently landed at the Kennewick, WA. Vista airport, landed long, and overran the runway. The aircraft departed the end of the runway and impacted terrain.NTSB SEA87LA196Accident · No injuriesLimited investigationFinal reportCessna 150F · Mount Vernon, WAThe aircraft's engine ceased operating due to fuel exhaustion about five miles short of the destination airport. A field was selected for the landing site. During the landing roll, the aircraft nosed over on freshly plowed terrain.NTSB SEA87FA194Accident · Minor injuriesField investigationFinal reportHughes 369D · Seattle, WAThe plt rprtd that while he was in cruise flight at about 1000', the eng lost power. He initiated an autorotation to an athletic field in a city park. Drg his apch, he changed his planned touchdown point svrl times due to personnel on the field. He said that…NTSB SEA87LA195Accident · No injuriesLimited investigationFinal reportBeech 23 · Basin City, WAThe pilot was making a low pass over the ground for a possible off airport landing next to his farm. During the low approach, he noticed power lines ahead and pushed forward on the controls to clear under them. However, there was a wrecked vehicle below the…NTSB SEA87LA189Accident · No injuriesLimited investigationFinal reportCessna 182Q · Cathlamet, WAThe pilot was making soft field takeoffs with no flaps. He lost control of the aircraft at about 10 feet AGL, the aircraft's right wing struck the ground and the aircraft came to a stop.NTSB SEA87LA186Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Quincy, WADuring an aerial application maneuver the pilot flew into two 23,000 volt powerlines. The helicopter's rotor blades struck the powerlines, the aircraft turned to the right and descended to the ground.NTSB SEA87LA181Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Burbank, WAWhile on a local pleasure flight the pilot made a 30 degree, banked turn at reduced power. The aircraft entered a stall and descended to the ground. The aircraft has no stall warning system.NTSB SEA87LA179Accident · Minor injuriesLimited investigationFinal reportCessna 180H · Shelton, WADuring initial climbout the pilot stated that a loss of power occurred. However, no reason for loss of power could be found. An eye witness to the accident stated that he heard power throughout the takeoff to the moment of impact. The propeller showed heavy…NTSB SEA87FA178Accident · 1 fatalField investigationFinal reportPiper PA-20 · Chelan, WAThe pilot was observed making a engine out landing at his private grass/dirt strip. The dirt strip is located on a plateau with the runway starting at the edge of the plateau. The aircraft impacted in a steep nose down attitude below the runway level on a…NTSB SEA87LA184Accident · No injuriesLimited investigationFinal reportBeech C-23 · Bremerton, WAOn the pilots third touch and go an undershoot occurred during landing onto runway 1. VASI lights are available for that runway. The plt was unable to explain why the undershoot occurred.NTSB SEA87LA177Accident · Serious injuriesLimited investigationFinal reportCanton Rutan Long · Port Townsend, WADuring takeoff roll the pilot noted sluggish rotation performance and retarded the throttle to abort the takeoff. When he reduced power the aircraft rotated. He reapplied full power and abrupt aft stick, to execute rapid rotation and lift off. The hand grip…NTSB SEA87LA176Accident · No injuriesLimited investigationFinal reportCessna 150 · Oak Harbor, WAThe plt had not slept the night of the flt. He was wearing contact lens and had closed his eyes several times during the flt to alleviate stinging. While on short final approach to land the plt closed his eyes and fell asleep. When he awoke he was left of the…