NTSB investigations, WA
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 WPR11CA247Accident · No injuriesData collectionFinal reportSieber Paul P Nieuport 11 · Bellingham, WAThe pilot's failure to maintain directional control during landing rollout.NTSB WPR11CA235Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Yakima, WAThe pilot’s failure to maintain directional control upon landing.NTSB WPR11LA234Accident · Minor injuriesLimited investigationFinal reportHoskins Zenith · Puyallup, WAThe pilot’s failure to maintain adequate airspeed during landing, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s lack of experience in the accident airplane.NTSB WPR11CA229Accident · No injuriesData collectionFinal reportRockwell International S-2R · Kahlotus, WAThe pilot's failure to maintain directional control during takeoff.NTSB WPR11LA223Accident · 1 fatalLimited investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Arlington, WAThe pilot’s failure to maintain control during the takeoff climb, which resulted in a stall at low altitude and collision with terrain. Contributing to the accident was the pilot’s impaired performance from over-the-counter medications.NTSB WPR11LA210Accident · No injuriesLimited investigationFinal reportCessna 150H · College Place, WAThe pilot’s delayed use of carburetor heat while operating the airplane in atmospheric conditions conducive to carburetor icing, which resulted in a total loss of engine power due to carburetor icing during final approach.NTSB WPR11LA209Accident · No injuriesLimited investigationFinal reportCessna 182B · Colville, WAThe partial loss of engine power during takeoff for reasons that could not be determined because postaccident examination revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR11CA196Accident · No injuriesData collectionFinal reportCessna T188C · Palouse, WAThe pilot's inadequate evaluation of the wind conditions at takeoff and failure to maintain an adequate airspeed, which resulted in a stall and collision with terrain during the initial climb.NTSB WPR11CA194Accident · No injuriesData collectionFinal reportCessna 172R · Othello, WAThe pilot's failure to maintain directional during the landing roll.NTSB WPR11CA191Accident · No injuriesData collectionFinal reportCessna 172N · Snohomish, WAThe pilot's failure to maintain clearance from a hangar while taxiing.NTSB WPR11LA181Accident · Serious injuriesLimited investigationFinal reportCessna A188 · Palouse, WAThe pilot did not maintain adequate clearance from obstacles during a low-level aerial application maneuver.NTSB WPR11CA177Accident · No injuriesData collectionFinal reportCessna 172 · Republic, WAThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR11LA172Accident · No injuriesLimited investigationFinal reportBeech G35 · Whidbey Island, WAThe pilot's failure to prioritize flying over navigation due to his diverted attention, which allowed the airplane to near a restricted area, which, in turn, led the pilot to enter a rapid avoidance maneuver and subsequently lose airplane control.…NTSB WPR11LA168Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Puyallup, WAThe pilots’ activation of the fuel boost pump while preparing to land, which was contrary to checklist procedures and resulted in a loss of engine power.NTSB WPR11CA171Accident · No injuriesData collectionFinal reportRemos GX · Arlington, WAThe LSA pilots' failure to stop and to ensure that the taxiway was clear of conflicting traffic before entering.NTSB WPR11FA159Accident · No injuriesField investigationFinal reportFairchild SA227-AC · Seattle, WAThe pilot's failure to extend the landing gear, which resulted in a gear-up landing.NTSB WPR11LA149Accident · Serious injuriesLimited investigationFinal reportBoeing 757-232 · Naches, WAThe airplane's encounter with moderate turbulence at a higher altitude than the flight crew expected, resulting in an injury to a cabin crewmember.NTSB WPR11CA132Accident · Minor injuriesData collectionFinal reportCessna 170A · Baker Lake, WAThe pilot's encounter with soft terrain during an attempted takeoff from a dry lake bed.NTSB WPR11CA118Accident · Serious injuriesData collectionFinal reportCessna 182 · Eastsound, WAThe pilot’s failure to properly secure the airplane prior to rotating the propeller by hand, resulting in inadvertent movement of the airplane and collision with a building.NTSB WPR11CA110Accident · No injuriesData collectionFinal reportWalker Louie H Super 18 Cuby · Toutle, WAThe pilot's excessive braking during the landing roll, which resulted in the airplane nosing over onto its back. Contributing to the accident was the pilot's decision to land on a sandbar that he had not adequately inspected and his improper airspeed while on…NTSB WPR11FA103Accident · 1 fatalField investigationFinal reportCessna T206H · Stanwood, WAThe pilot did not confirm retraction of the landing gear before landing on water as a result of distraction. Contributing to the accident was the pilot coping with the death of a close family member in the days before the accident, which resulted in a…NTSB WPR11LA095Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Lopez, WAA loss of engine power during initial climb for undetermined reasons.NTSB WPR11LA076Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-65 · College Place, WAThe pilot's failure to abort the landing when he lost sight of the runway due to sun glare, and his inadequate compensation for the crosswind.NTSB WPR11CA072Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Pullman, WAThe pilot's delayed application of carburetor heat while maneuvering, which resulted in a partial loss of engine power.NTSB WPR11CA065Accident · No injuriesData collectionFinal reportAviat A-1B · North Bend, WAThe pilot's failure to predetermine the depth of the snow on the runway.NTSB WPR11FA061Accident · 1 fatalField investigationFinal reportAmerican Champion 8GCBC · Bremerton, WAThe pilot did not maintain clearance from terrain for undetermined reasons. Contributing to the accident were the pilot’s use of oxycodone and his severe coronary artery disease.NTSB WPR11CA037Accident · No injuriesData collectionFinal reportCessna 172S · Port Townsend, WAThe pilot's improper flare/touchdown while landing, resulting in a loss of directional control and a runway excursion.NTSB WPR11CA040Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Carnation, WAThe pilot's failure to attain the proper touchdown point during a practice off-airport landing.NTSB WPR11FA029Accident · 3 fatalField investigationFinal reportCessna 340A · Morton, WAThe pilot’s failure to arrest the excessive rate of turn into the failed engine, which resulted in a loss of control and subsequent impact with terrain. Contributing to the accident was a partial loss of engine power for reasons that could not be determined…NTSB WPR11CA022Accident · Minor injuriesData collectionFinal reportRotherwick Glasair III · Colville, WAThe pilot's misjudged approach and failure to attain the proper touchdown point, which resulted in a runway overrun.NTSB WPR11CA018Accident · Minor injuriesData collectionFinal reportDeitz Avid Flyer MK4 · Colville, WAThe pilot's failure to compensate for a wind gust and maintain runway alignment during final approach to land, which resulted in an in-flight collision with a tree.NTSB WPR11LA015Accident · Serious injuriesLimited investigationFinal reportMischke BD-5B · Burlington, WAThe failure of the sprag clutch during takeoff, resulting in a loss of engine thrust.NTSB WPR11CA007Accident · No injuriesData collectionFinal reportPiper PA-12 · Valley, WAThe pilot's excessive brake application during the landing roll after overshooting the intended touchdown point, resulting in a nose over.NTSB WPR10LA479Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Spokane, WAThe failure of a manufacturing splice of the right main landing gear tire’s inner tube, which resulted in a deflated tire and a consequent loss of directional control on landing.NTSB WPR10CA461Accident · No injuriesData collectionFinal reportDehavilland Beaver DHC-2 MK.1 · Renton, WAThe pilot's failure to maintain directional control of the float-equipped airplane during an aborted water takeoff, resulting in a dragged wing.NTSB WPR10LA432Accident · Minor injuriesLimited investigationFinal reportStinson JR. S · Lake Stevens, WAA total loss of engine power during cruise flight, which resulted from a magneto switch failure.NTSB WPR10CA434Accident · Minor injuriesData collectionFinal reportPiper PA-15 · Duvall, WAAn in-flight collision with a bird while maneuvering.NTSB WPR10LA427Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Sequim, WAThe pilot’s failure to maintain the proper approach path and his delayed corrective actions, which resulted in an undershoot. Contributing to the accident was the pilot's distraction from other aircraft in the area.NTSB WPR10LA412Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Manson, WAA loss of engine power due to fuel exhaustion, and the pilot’s failure to ensure that a sufficient quantity of fuel was on board to complete the flight.NTSB WPR10CA414Accident · Minor injuriesData collectionFinal reportPiper PA-18 · Buena, WAThe pilot’s excessive brake application, resulting in a nose over.NTSB WPR10LA411Accident · Serious injuriesLimited investigationFinal reportErcoupe 415 · Leavenworth, WAThe pilot's failure to adequately evaluate the airport and its environment in relation to the aircraft’s performance, which resulted in the airplane's failure to attain sufficient altitude to clear trees during the initial climb.NTSB WPR10FA384Accident · Minor injuriesField investigationFinal reportCessna 172 · Roche Harbor, WAThe pilot’s failure to attain an adequate climb airspeed due to his use of flaps for takeoff, and his selection of a runway, which resulted in an uphill, and possibly downwind, takeoff and subsequent collision with a known obstacle. Contributing to the…NTSB WPR10FA373Accident · 1 fatalField investigationFinal reportMarshall CH601 HDS · Kapowsin, WAThe pilot’s failure to maintain adequate airspeed which resulted in a stall and loss of control during the initial climb.NTSB WPR10LA370Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Walla Walla, WAThe pilot's partial incapacitation during cruise flight and his subsequent inadequate fuel management, which resulted in fuel starvation.NTSB WPR10LA374Accident · Minor injuriesLimited investigationFinal reportLancair 320 · Spokane, WALoss of airplane control due to the asymmetric flap condition.NTSB WPR10CA367Accident · No injuriesData collectionFinal reportCessna 152 · Ephrata, WAThe pilot's failure to maintain clearance from a fire hydrant while taxiing to the runway.NTSB WPR10LA365Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Prescott, WAThe airplane’s inability to maintain a positive rate of climb after takeoff for undetermined reasons. Contributing to the accident was the pilot’s delayed reaction to initiate an emergency release of the spray mixture.NTSB WPR10LA336Accident · Minor injuriesLimited investigationFinal reportJohnson Helicycle · Arlington, WAAn undetermined airframe vibration which led to precautionary autorotation and hard landing.NTSB WPR10FA326Accident · 1 fatalField investigationFinal reportCessna 150 · Keller, WAThe student pilot’s failure to maintain clearance from obstacles during the initial climb.NTSB WPR10CA332Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Garfield, WAA loss of engine power due to fuel exhaustion.