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 SEA85FA120Accident · 3 fatalField investigationFinal reportCessna 205 · Chewelah, WAThe acft was observed flying up a canyon at low altitude while climbing at an angle equivalent to the surrounding terrain slope. Shortly thereafter the acft encountered steeply upsloping terrain and began impacting trees in a left wing high and nose up…NTSB SEA85LA112Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Tacoma, WAThe engine ceased operative while on right base for rwy 35 due to fuel exhaustion. The plt ran the left tank dry. The right tank contained full fuel. The plt had been used to flying Cessna's.NTSB SEA85FA104Accident · 2 fatalField investigationFinal reportHughes 369D · Spokane, WAThe helicopter was on a flt to a tv station to transport a tv camera man & his gear. The regular plt for this trip was unable to fly, so another was retained for the flt. This was his 1st flt to the station. Helicopter operations at the tv station were…NTSB SEA85FA103Accident · 3 fatalField investigationFinal reportPiper PA-32RT-300T · Seattle, WAAfter liftoff, the plt requested an immediate return for landing stating he, 'smelled smoke/something hot'. Downwind for the precautionary landing was flown at 200 ft AGL, a slow airspeed and close to the runway with a crosswind blowing the acft toward the…NTSB SEA85LA090Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Okanogan, WADuring an aerial application flt, the acft collided with a power line at about 30 ft AGL. The acft then rolled to the right & struck the ground. The accident occurred about 5 min after the acft had departed the spray area.NTSB SEA85FA086Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Sunnyside, WAThe acft crashed after colliding with electrical power lines near an open field. Initial impact with the power lines occurred where the wires were routed over a draw between 2 ridges. The acft came to rest inverted between the power lines & the open field.…NTSB SEA85LA089Accident · Serious injuriesLimited investigationFinal reportRaven R-7 · Mt. Vernon, WAThe plt discovered after a hard landing that his leg was broken. This was the students second solo in hot air balloons.NTSB SEA85LA087Accident · No injuriesLimited investigationFinal reportCessna 182 · Walla Walla, WADuring taxi from landing a gust of wind pushed the acft from behind onto soft ground where it nosed over.NTSB SEA85LA081Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Trinidad, WAThe pilot was operating the aircraft by flying at low altitude down the columbia river so as to avoid turbulence. During the flight a downdraft was encountered in which insufficient altitude was available to prevent the water and an unintentional ditching…NTSB SEA85LA079Accident · No injuriesLimited investigationFinal reportHughes 269C · Elma, WAJust prior to lift-off a vibration accompanied by lateral rocking occurred. Although the plt brought the power to idle. The helicopter had already started to come apart. During engine examination it was found that the ground resonance occurred due to under to…NTSB SEA85LA076Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Davenport, WAA vibration started in the engine and while the plt was monitoring the engine gauges he noted a loss of all oil pressure. A landing was made on a field and during rollout the left main gear was torn off when it struck a mound of dirt. The acft then struck…NTSB SEA85LA075Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Bremerton, WAThe acft bounced during landing and adequate recovery was not made. The acft came to rest inverted.NTSB SEA85LA074Accident · No injuriesLimited investigationFinal reportGrumman 164A · Ritzville, WADuring landing the acft caught a gust of wind and drifted right of the runway. The plt attempted to correct by use of rudder and aileron, but was unsuccessful. The acft then nosed ver.NTSB SEA85LA069Accident · No injuriesLimited investigationFinal reportCessna 177A · Stanwood, WAThe plt was attempting to land the acft downwind and uphill.a go-around was attempted and the acft struck trees at the departure end of the rwy.NTSB SEA85LA066Accident · No injuriesLimited investigationFinal reportCessna TU206F · Seattle, WAThe acft landed short of rwy 13R at Boeing fld following a loss of pwr due to fuel exhaustion. The acft was topped off for a ttl of 108 gals of fuel before this third leg of a x-country flt. The plt stated that the eng ceased operating en route, however, pwr…NTSB SEA85LA062Accident · No injuriesLimited investigationFinal reportBeech BE-77 · Pasco, WAPlt made full flap apch at idle pwr while practicing a short field landing. Plt stated apch originally was high and later became low. Plt delayed adding pwr and acft touched down 130 ft short of the rwy. Acft bounced and contacted the ground again nose wheel…NTSB SEA85LA061Accident · No injuriesLimited investigationFinal reportCessna 172 · Spanaway, WAThe plt was attempting to better align the acft for final apch when a tree was struck with the right wing. The plt stated she was distracted while making preparations to land. The landing was continued without incident.NTSB SEA85LYE01Accident · No injuriesFinal reportLuscombe 8A · Cheney, WAAcft was found abandoned after sustaining substantial damage in apparent lndg attempt in snow-covered marsh. Presumed pilot had expired student certificate and had registered acft to self under an alias. Circumstances of mishap unknown.NTSB SEA85LA055Accident · No injuriesLimited investigationFinal reportBeech 58TC · Spokane, WAThe acft touched down to the left of the runway onto snow. Visibility at the time of the accident was 1 mile with snow and a ceiling of 700 feet.NTSB SEA85LA053Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Taholah, WAThe acft had lifted off during an external load operation when the plt felt a 'vibration/shudder'. The right skid contacted the ground and the helicopter rolled over during an attempt to maneuver the helicopter away from ground personnel. Inspection revealed…NTSB SEA85FA049Accident · 3 fatalField investigationFinal reportCessna 170A · Lopez, WAShortly after departure N3845V joined up with another acft and was flying aprx 200-300 ft AGL in formation. The plt of N3845V then pulled up into what witnesses described as a wing over maneuver after which the acft descended to ground impact. One witness,…NTSB SEA85FA048Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Bickleton, WAThe pilot began flight activity at dawn on the day of the accident. Weather briefings indicated marginal conditions for an afternoon flight to another city, which was accomplished without incident. At 2027 hours, without updated weather briefing, the pilot…NTSB SEA85LA046Accident · No injuriesLimited investigationFinal reportHiller UH12DJ3 · Forks, WAThe acft made a hard landing and rolled to the left inverted after the engine quit due to fuel exhaustion. The plt stated that the fuel guage was not working and that he was using a dip stick to measure fuel at the time of the engine failure. He stated that…NTSB SEA85LA047Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Wenatchee, WAThe plt elected to make a precautionary landing onto a snow covered grain field. He stated his artifical horizon was inoperative & darkness was approaching. Also, he said he saw a needle flicker & he was not sure if it was a fuel gage or his oil pressure…NTSB SEA85LA044Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Deer Park, WAAcft touched down in the displaced threshold which was not plowed clear of snow as the remaining portion of the rwy was. Acft nosed over following touchdwon.NTSB SEA85FA043Accident · 1 fatalField investigationFinal reportPiper PA-28-140D · Kent, WAThe acft contacted trees and the terrain aprx 1/2 mile south of the arpt shortly after takeoff. Witnesses stated the eng was running rough and black smoke was trailing from the exhaust during the takeoff. Examination of the eng revealed the spark plugs were…NTSB SEA85LA039Accident · No injuriesLimited investigationFinal reportCessna 152A · Pullman, WAPlt made 10 touch and go landings and had just raised the flaps and was applying full pwr to initiate another takeoff. Noting he was rt of the centerline he applied left rudder. Acft veered sharply to the left where it slid on ice into a snowbank.NTSB SEA85LA038Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Port Townsend, WAThe plt stated that once airborne during takeoff, the left wing dropped. Plt attempted remedial action, however, the acft contacted the left side of the taxiway in a nose down, left wing low attitude.NTSB SEA85LA045Accident · No injuriesLimited investigationFinal reportCessna A152 · Deer Park, WADuring landing practice on an instructional flight at an uncontrolled arpt, acft was being taxiied back for takeoff after a full stop landing. Surface was icy and snow-covered. Student was practicing directional control exercise with rudder. Acft skidded and…NTSB SEA85FA034Accident · Serious injuriesField investigationFinal reportde Havilland DHC-3 Turbo · West Seattle, WAAcft was performing test flt maneuvers when problems with the modified fuel system occurred. Ice blocking a fuel vent line caused a partial collapse of the main (engine feed) fuel cell which produced an errouneous fuel quantity reading. In addition, the main…NTSB SEA85LA031Accident · Minor injuriesLimited investigationFinal reportHiller UH-12ET · Hoquiam, WAPlt reported that while in normal cruise flight, a total loss of power occurred. Autorotation was effected in mountainous, wooded terrain. Examination of the engine showed continuity and freedom of rotation. Examination of the fuel system disclosed no…NTSB SEA85FA030Accident · 2 fatalField investigationFinal reportCessna C-152 · Port Orchard, WALow ceilings, rain, fog were reported in area pt the time of the accident. The student pilot was on a solo x-c, flt plan was filed with help of instru. Wx VFR nr. Acft dep 1104 PST acft crashed abt 1317 no rcrd of des reached or where acft was for 2 hrs. Acft…NTSB SEA85LA029Accident · No injuriesLimited investigationFinal reportCessna 172M · Sultan, WAAn overrun occurred on the 2,000 foot airstrip due to excess approach and landing speed. A light coating of snow was present on the grass runway and the pilot neglected to raise the flaps adding to a longer landing roll and making braking less effective. A 5…NTSB SEA85FA028Accident · 1 fatalField investigationFinal reportPiper PA-44-180 · Gig Harbor, WAThe plt departed in the early morning hours from salem, OR, destined for Gig Harbor. Upon arrival in the destination area the plt was in radio contact with seattle apcon. The plt reported he was unable to aquire visual contact with the arpt. Vectors were…NTSB SEA85LA025Accident · No injuriesLimited investigationFinal reportCessna 414 · Waterville, WAUpon arrival at the dest arpt the plt elected to perform a touch & go landing in order to evaluate rwy braking action. During climb out after the touch & go at about 100 ft AGL and 100 to 105 KTS the acft yawed to the right as the nose picthed up. Despite…NTSB SEA85IA024Incident · No injuriesIncident investigationFinal reportFairchild Swearingen SA 227 · Pullman, WAThe aircraft's landing gear collapsed after the plane went off the right side of runway 23 during takeoff. Reportedly, the aircraft drifted to the right of centerline on a fairly constant arc until contacting a snow berm at a taxiway intersection. An…NTSB SEA85LA017Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Humptulips, WAWhen the hoisting cable on the helicopter failed, the hook end rebounded into the rotor system. The rotor system failed from the structural damage imposed and the acft went into an uncontroled descent impacting the ground on the left skid.NTSB SEA85LA011Accident · No injuriesLimited investigationFinal reportCessna 182F · Snoqualmie Pass, WAThe plt stated that while leveling off at 5,500 ft he trimmed the acft for cruise flt (2200 RPM/21' mp) and checked the carb heat. Aprx 5 mins later, the plt switched from the rt fuel tank to both fuel tanks. Shortly thereafter the eng lost power. Plt then…NTSB DCA85IA003Incident · No injuriesIncident investigationFinal reportBoeing VC-137B-BN · Seattle, WADuring arrival, a Boeing VC-137B-BN, USAF #58-6970, operating as air force 2 (AF-2), was cleared for a localizer back- course apch. At 1442:49, TRACON advised AF-2 of traffic at its 10 o'clock position at 2 mi, alt unkn. At 1443:11, TRACON advised AF-2 the…NTSB SEA85LA005Accident · No injuriesLimited investigationFinal reportCessna 172N · Ashford, WAThe acft ground looped during a landing in a gusty x-wind. After directional control was lost the acft veered off the rwy striking trees. No accident report form was filed by the plt.NTSB SEA84IA233Incident · No injuriesIncident investigationFinal reportBoeing 747-200B · Seattle, WADuring climbout, passing thru 4000 ft MSL, the acft experienced a failure of the #2 engine. The crew reported hearing an explosive sound followed by a drop in fuel flow with N1 speed decreasing to 30% RPM on the #2 engine. The acft returned to Seattle for an…NTSB SEA84LA236Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Darrington, WAThe acft went off the rwys end into a tree stump and brush during landing. The plt said he landed with excess speed and was unable to stop. The plt recommended that a go-around should have been performed.NTSB SEA85FA016Accident · 1 fatalField investigationFinal reportCessna 172M · Aberdeen, WAAcft wreckage indicates impact was nose down inverted. No evidence was found of acft failure/malfunction. Plt departed on night cross-country after an evening out with friends. Wreckage found two months later, no toxicological tests possible.NTSB SEA84LA229Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Kelso, WAClimbing through 4,000 ft the engine failed. Emergency procedures resulted in a momentary restoration of power prior to the forced landing. During final approach the left wing struck a tree. The right main landing gear collapsed during the landing roll.…NTSB SEA84FA223Accident · 2 fatalField investigationFinal reportCessna T210M · Skamania, WAA witness, located 3 mi se of the accident site, reported hearing the acft 'rev up to a scream followed by a crash that sounded like a miniature sonic boom.' The acft contacted the terrain in an uncontrolledd descent at an elev of 2100 ft MSL. Inspection of…NTSB SEA84LA222Accident · No injuriesLimited investigationFinal reportCessna 150 · Spanaway, WAAcft lost power during takeoff. Plt made forced landing straight ahead in open field.NTSB SEA84LA211Accident · No injuriesLimited investigationFinal reportHayes Quickie Q2 · Puyallup, WAThe plt reported that he had placed 50 lbs of sand in the acft baggage compartment to complement the acft CG. During takeoff the acft was very nose heavy. He elected to make 2 landings at tacoma where the nose dropped severely while the plt attempted to…NTSB SEA84FA209Accident · 1 fatalField investigationFinal reportBenson B8M · Newman Lake, WAWitnesses observed the aircraft go through a series of rapid pitch oscillations at about 300 ft AGL. The pitch changes increased in magnitude and severity until the main rotor blades struck the rudder stopping it's rotation and resulting in an uncontrolled…NTSB SEA84LA206Accident · No injuriesLimited investigationFinal reportDonald E. Bradshaw Starduster TOO · Whidbey Island, WAWitnesses stated the acft was engaged in aerobatics before it contacted the water and was destroyed.NTSB SEA84LA207Accident · No injuriesLimited investigationFinal reportCurtiss-Wright Travel AIR B9-4000 · Vancouver, WAThe pilot stated after the accident that he applied too much brake during the landing roll. The aircraft nosed over.