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 SEA86LA180Accident · Minor injuriesLimited investigationFinal reportCessna 140A · Colville, WAWhile making a power off approach to simulate a forced landing an over shoot was assured. The plt added pwr and the engine ceased operating. In order to avoid trees at the end of the runway the pilot made a 90 degree turn to land in a plowed field. The acft…NTSB SEA86LA209Accident · No injuriesLimited investigationFinal reportLet L-13 · Issaquah, WAPlt undershot approach after encountering downdraft, collided with perimeter fence.NTSB SEA86LA176Accident · 1 fatalLimited investigationFinal reportBell 47G-3B1 · Burbank, WAThe helicopter had landed for reloading and was stationary with rotors idling. A ground loader person approached the helicopter over a small sandy knoll and was struck by the main rotor, sustaining fatal injury.NTSB SEA86LA177Accident · Minor injuriesLimited investigationFinal reportBell 47G3B2 · Nahcotta, WAWhile spraying oyster beds the pilot inadvertently flew the helicopter into the ground.NTSB SEA86LA175Accident · No injuriesLimited investigationFinal reportCessna 152 · Seattle, WAStudent pilot, with about 2 hours solo time, was making touch and go's. during the last landing the aircraft was observed to make several bouncing contacts with the runway before the nose gear collapsed.NTSB SEA86LA169Accident · No injuriesLimited investigationFinal reportCessna 170B · Roche Harbor, WAThe plt lost directional control of the aircraft during landing rollout with a crosswind. The aircraft drifted to the left of the runway at which time the plt applied full aft elevator, full right rudder and full right aileron. The plt reported the acft made…NTSB SEA86LA168Accident · No injuriesLimited investigationFinal reportBell 47G2A · Chehalis, WADuring an aerial applications maneuver, a complete loss of power occurred. The power loss was caused by failure of the connecting rod bolt. The acft was too low for autorotation and the aircraft struck the ground tail low. The main rotor blade then struck the…NTSB SEA86LA166Accident · No injuriesLimited investigationFinal reportRockwell S2R · Royal City, WAShortly after takeoff at an alt of aprx 110 ft AGL, a loss of pwr occurred due to the #2 cylinder failing. The acft nosed over during the subsequent forced landing in a wheat field. The plt then extinguished a small exhaust fire.NTSB SEA86FA165Accident · 2 fatalField investigationFinal reportThorp T-18 · Richland, WAAt time of mishap, acft presumed to be in rt-hand approach to land in 20-KT, 40 degree rt crosswind. Witnesses first observed acft descending vertically, out of control, in an area consistent with the 90 degree approach position. Evidence indicates acft…NTSB SEA86LA170Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Royal City, WAThe plt was landing the acft on rwy 27, toward the sun. With the sun in her eyes, she did not see a 300 lb calf on the rwy. The acft struck & killed the calf & was substantially damaged.NTSB SEA86LA161Accident · No injuriesLimited investigationFinal reportCessna T-188-C · Othello, WAAn engine failure for unknown reasons occurred during an aerial application maneuver. A forced landing was accomplished onto very rough, rocky terrain where the aircraft was destroyed during the landing sequence.NTSB SEA86LA153Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Pullman, WAAfter takeoff during a 180 degree turn the aircraft developed a rapid rate of sink which the pilot was unable to arrest. While attempting to dump 140 pounds of water, the aircraft struck power lines and then struck the ground inverted. The aircraft was then…NTSB SEA86LA150Accident · No injuriesLimited investigationFinal reportPiper J3C · Kent, WAA forced landing was made after a total loss of power. Landing was accomplished onto very rough rising terrain. During landing roll the left main gear collapsed. Investigation revealed a broken crankshaft. A top overhaul had been done less than 30 hours prior…NTSB SEA86LA149Accident · No injuriesLimited investigationFinal reportMellema Bede 4 · Kent, WAThe engine ceased operating 10 feet a.g.l. during takeoff while on a biennial flight review. A landing straight ahead was made onto the runway, but in order to avoid an overrun an intentional ground loop was made. On engine examination a large bug was found…NTSB SEA86LA143Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Zillah, WAEn route to the local spray area a total loss of power occurred along with a loss of oil pressure. The acft was aprx 200 ft AGL over a pear orchard. The plt was attempting to autorotate onto a nearby road but the left skid caught the roof top of a metal shed.…NTSB SEA86FA144Accident · 2 fatalField investigationFinal reportSanders Starduster TWO · Mead, WAA witness reported seeing the aircraft perform a series of loop maneuvers. At the top of the last loop, the acft rolled upright then rolled into a near vertical right spin which continued to ground impact. The pilot had no history ofspin recovery practice in…NTSB SEA86LA147Accident · No injuriesLimited investigationFinal reportAvian Skyhawk · Yakima, WAA forced landing was made due to fuel starvation. During the forced landing the balloon struck power lines, severing the basket from the envelope. Sparks from the wire strike caused a small brush fire. Post accident exam revealed the plt inadvertently…NTSB SEA86FA137Accident · 1 fatalField investigationFinal reportBell UH-1L · Wenatchee, WAN4964N, a Bell UH-1L, was being operated in logging ops by an experienced, military trained plt who possessed 6000 hrs of flt experience in model. While lifting a sling load gnd crew rptd smoke from the tail rotor area. Plt released sling load & acknowledged…NTSB SEA86LA131Accident · Minor injuriesLimited investigationFinal reportArbaugh Evans Evans VP-1 · Kelso, WAA forced landing was made due to a loss of power at about 150 AGL during initial climb. The acft was landed on railroad tracks where it was destroyed by impact. The reason for the power loss has not been determined.NTSB SEA86LA130Accident · No injuriesLimited investigationFinal reportCessna 152 · Raymond, WAThe pilot chose to land at an alternate airport to await improving weather. During a gusty crosswind, loss of directional control occurred during landing flare. The aircraft departed the runway to the left and nosed over inverted.NTSB SEA86FA121Accident · 2 fatalField investigationFinal reportCessna 152 · Mead, WABoth acft were operating in VFR conditions modified by slight haze, high overcast and low sun angle near airport. N6161M was performing lazy eight maneuvers in a normal practice area two miles east of airport; N8267Q was in clockwise orbital descent for…NTSB SEA86LA128Accident · No injuriesLimited investigationFinal reportAyres S-2R · Odessa, WAA rough running engine accompanied by smoke rising from the left side of the engine occurred shortly after takeoff. The landing gear then collapsed during the subsequent forced landing and the acft was destroyed by fire. The number one cylinder was found to…NTSB SEA86LA123Accident · Minor injuriesLimited investigationFinal reportBeech A23-24 · Sunnyside, WAAfter completing several touch and goes, the pilot lost control of the aircraft on landing rollout due to a light gusting crosswind. The pilot was unable to avoid departing the runway to the left striking a four foot embankment collapsing the nose gear.NTSB SEA86LA119Accident · No injuriesLimited investigationFinal reportCessna 172 · Yakima, WADuring rollout on the third touch & go landing the student had control of the acft. While preparing for a downwind takeoff the acft drifted across the rwy and into a grass area. The instructor was unable to regain directional control. The acft contacted a…NTSB SEA86LA112Accident · No injuriesLimited investigationFinal reportCessna 172 · Ellensburg, WAThe student plt was attempting to land in high gusting x-winds. The wind was from about 290 degs at 30 KTS gusting to 35 KTS, the rwy heading is about 340 degs. The plt allowed the airspeed to decay to 40 KTS just prior to the flare and a hard flat landing…NTSB SEA86LA108Accident · Minor injuriesLimited investigationFinal reportPiper PA-36 · Mattawa, WAShortly after takeoff a loss of pwr occurred accompanied by an eng vibration. A forced landing was made onto a highway where a x-wind existed. Directional control was lost and the acft veered into a ditch and struck a fence before coming to a stop. No reason…NTSB SEA86LA099Accident · Serious injuriesLimited investigationFinal reportMorley Avid Flyer · Spokane, WAWhile on a five-mile final, a total loss of power occurred. A loose right magneto contacting the flywheel magnet and shorting the electrical system was found. In an attempt to miss a river in the approach path to the runway, the pilot attempted a 180 degree…NTSB SEA86FA096Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · East Wenatchee, WAThe plt departed arpt in bottom of columbia river gorge on night VFR flt to spokane, WA. Five to six min after departure acft impacted terrain on lip of canyon wall. Plts reported moderate to severe turbulence near the bluff line before and after crash. The…NTSB SEA86FA092Accident · 4 fatalField investigationFinal reportCessna 172P · Seattle, WAN99034 departed kenmore air harbor on a short local solo flight. Witnesses reported observing the aircraft takeoff and initiate a climb to the south. N65783 was returning from a recurrency check flight and was approaching from a southerly direction in a climb…NTSB SEA86LA088Accident · Minor injuriesLimited investigationFinal reportBeech E-35 · Couger, WAWhile at cruise, the pilot intentionally ran one fuel tank dry. When the pilot attempted a restart by use of the wobble pump, the aircraft's engine would not start. The pilot made a forced landing into trees for lack of a more suitable landing site. The…NTSB SEA86LA089Accident · No injuriesLimited investigationFinal reportHiller 12E · Walla Walla, WAA catastrophic failure of the planetary gear of the transmission occurred about 51 flight hours after overhaul. During forced landing a hard landing occurred severing the tail boom. A fire then erupted.NTSB SEA86LA085Accident · No injuriesLimited investigationFinal reportCessna 188-A · Warden, WAWhile at cruise, the pilot was distracted and had his head turned when he inadvertently flew into the ground.NTSB SEA86LA084Accident · No injuriesLimited investigationFinal reportBob White AJ1 · Vancouver, WAA loss of power occurred due to a failure of the fuel pump while at cruise. A forced landing was made onto a soft, farmers field where the aircraft nosed over during the landing roll.NTSB SEA86LA081Accident · No injuriesLimited investigationFinal reportAir Tractor 301 · Prescott, WAThe brake locking system engaged in flight causing the right brake to lock. The aircraft nosed over on landing where a small fire erupted from fuel spillage onto the hot engine.NTSB SEA86LA078Accident · Minor injuriesLimited investigationFinal reportMaule M-4-180C · Orchards, WAThe pilot inadvertently placed the fuel selector to a non-tank position. During initial climb at about 400 m.s.l. a total loss of power occurred. During forced landing the aircraft struck telephone lines, a patio roof, and a parked unoccupied pickup truck.NTSB SEA86LA076Accident · No injuriesLimited investigationFinal reportBeech 18 · Seattle, WAThe pilot lost control of the aircraft on takeoff and a subsequent groundloop occurred. Although the pilot has a DC-3 type rating, he had only 20 hours in this aircraft.NTSB SEA86FA075Accident · Serious injuriesField investigationFinal reportStinson 108-2 · La Conner, WAPlt was on approach for water landing in a canal used during previous summer for floatplane ops at dusk. Plt was looking for a specific boat moored in canal as landing mark, extended approach path beyond normal touchdown point. Acft struck telephone cable…NTSB SEA86LA077Accident · No injuriesLimited investigationFinal reportAeronca 7AC · East Sound, WAUpon rollout, a loss of directional control occurred during a wind gust. The pilot elected to go-around. Shortly after lift off, the main gear of the aircraft struck VASI lights. The aircraft then struck the ground.NTSB SEA86FA071Accident · 1 fatalField investigationFinal reportCessna 182P · Tenino, WAThe non-instrument rated pilot departed for his destination without filing a flight plan nor obtaining a weather briefing. The flight was conducted in dark night and instrument meteorological conditions. Low ceilings prevailed in the vicinity of the accident.…NTSB SEA86LA069Accident · No injuriesLimited investigationFinal reportCessna 172 · Concrete, WAThe pilot was flying only 50 feet AGL when the aircraft struck power lines. A successful landing was then accomplished at an airport.NTSB SEA86LA063Accident · No injuriesLimited investigationFinal reportNavion A · White Salmon, WADuring IFR cruise, a loss of power occurred. The pilot complied with emergency procedures for power loss but when he reached down to switch the fuel tank selector he lost control of the aircraft and entered into a nose down unusual attitude, descending at the…NTSB SEA86LA062Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Odessa, WADuring an external load operation to remove groundwire off crossarms, the cable splice jammed in the pulley frame. The helicopters forward motion stopped and it then struck the ground. The pilot said the cargo hook release didn't work but no failures were…NTSB SEA86LA061Accident · Serious injuriesLimited investigationFinal reportPiper PA-15 · Mount St.Helens, WAThe pilot was attempting to fly inside a volcanic crater around the lava dome above 6000 feet m.s.l.. The aircraft has a 75 horsepower engine. High winds entering the crater from the northeast flowing across the lava dome created a downdraft that the aircraft…NTSB SEA86LA057Accident · No injuriesLimited investigationFinal reportCessna 172 · Renton, WAThe pilot failed to maintain directional control during takeoff. Although a crosswind from the left was present the pilot lost control for unknown reasons to the left, crossing the taxiway and then striking a parked vehicle and building. No mechanical reason…NTSB SEA86FA056Accident · 3 fatalField investigationFinal reportMcDonnell Douglas 369D · Cougar, WAThe helicopter departed the landing area after a night photography session across the valley floor from the Mt. St. Helens volcano. Prior to departure the plt reported the weather was closing in and getting 'nasty'. Wx conditions as reported prior to…NTSB SEA86FA054Accident · Serious injuriesField investigationFinal reportCessna 172N · Renton, WAThe recently certificated private pilot was engaged in practice touch and go landings. Sometime after the second approach the throttle control rod became disconnected from the throttle cable and the pilot was unable to retard the throttle from a full power…NTSB SEA86IA058Incident · No injuriesIncident investigationFinal reportCessna T210 · Roche Harbor, WAOn initial climb after takeoff, electrical fire broke out in back of pilot's yoke. Pilot managed to extinguish five- inch flames by hand, climbed to 2000 feet and evaluated situation. Noting no further problems, flight was continued to destination. Enroute,…NTSB SEA86FA052Accident · 1 fatalField investigationFinal reportCessna 195 · Black Diamond, WARadar track shows C195 plt was descending into congested airspace at about 192 mph, above max structural cruise speed of 178 mph, less than 1 min from traffic pattern entry. Radar data and witness confirm a second acft in proximity, engaged in aerobatics.…NTSB SEA86LA048Accident · No injuriesLimited investigationFinal reportCessna 206 · Wenatchee, WAThe pilot diverted from his intended destination of pangborn field to a local private airstrip due to local fog. 8' of crusted snow was present on the runway and the aircraft nosed over on landing roll.NTSB SEA86LA045Accident · Minor injuriesLimited investigationFinal reportBellanca 1413-2 · Vancouver, WAA total loss of power occurred due to a previously burnt flex hose which blocked air from coming into the induction system. The aircraft was unable to reach the runway and struck trees before it came to rest on the roof top of a residence.