NTSB investigations, 2010, 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 per year
| 1963 | 1 |
|---|---|
| 1964 | 110 |
| 1965 | 131 |
| 1966 | 140 |
| 1967 | 159 |
| 1968 | 125 |
| 1969 | 116 |
| 1970 | 118 |
| 1971 | 86 |
| 1972 | 107 |
| 1973 | 104 |
| 1974 | 109 |
| 1975 | 129 |
| 1976 | 117 |
| 1977 | 104 |
| 1978 | 118 |
| 1979 | 118 |
| 1980 | 107 |
| 1981 | 102 |
| 1982 | 95 |
| 1983 | 101 |
| 1984 | 89 |
| 1985 | 73 |
| 1986 | 100 |
| 1987 | 79 |
| 1988 | 80 |
| 1989 | 76 |
| 1990 | 78 |
| 1991 | 94 |
| 1992 | 79 |
| 1993 | 69 |
| 1994 | 67 |
| 1995 | 73 |
| 1996 | 65 |
| 1997 | 62 |
| 1998 | 67 |
| 1999 | 68 |
| 2000 | 67 |
| 2001 | 66 |
| 2002 | 66 |
| 2003 | 74 |
| 2004 | 75 |
| 2005 | 59 |
| 2006 | 49 |
| 2007 | 53 |
| 2008 | 58 |
| 2009 | 58 |
| 2010 | 51 |
| 2011 | 58 |
| 2012 | 54 |
| 2013 | 37 |
| 2014 | 47 |
| 2015 | 36 |
| 2016 | 32 |
| 2017 | 39 |
| 2018 | 47 |
| 2019 | 37 |
| 2020 | 28 |
| 2021 | 41 |
| 2022 | 35 |
| 2023 | 36 |
| 2024 | 29 |
| 2025 | 37 |
| 2026 | 29 |
Where
Open the mapLatest cases
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 year(c.\"eventDate\") = 2010
AND 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 year(c."eventDate") = 2010 AND 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 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.NTSB WPR10CA322Accident · No injuriesData collectionFinal reportConsolidated Aeronautics Lake LA-4-200 · Sequim, WAThe pilot’s failure to maintain directional control during landing due to an encounter with sun glare.NTSB WPR10LA313Accident · Minor injuriesLimited investigationFinal reportDe Havilland DHC-1 · Port Orchard, WAA loss of engine power during initial climb due to water contamination in the fuel.NTSB WPR10CA290Accident · No injuriesData collectionFinal reportWaco UKC-S · Seattle, WAThe pilot’s inadequate compensation for the crosswind condition, resulting in a loss of directional control during the landing roll.NTSB WPR10CA283Accident · No injuriesData collectionFinal reportBell 47G-4A · Shaw Island, WAThe passenger's inadvertent movement of the mixture control during climb, resulting in a loss of engine power.NTSB WPR10FA277Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Spokane, WAA loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation and the student pilot's failure to maintain main rotor rpm.…NTSB WPR10LA272Accident · No injuriesLimited investigationFinal reportEagle Eagle DW-1 · Waterville, WAA worn wire in the magneto system, which allowed intermittent grounding and a loss of engine power.NTSB WPR10CA257Accident · No injuriesData collectionFinal reportCessna 180A · Kettle Falls, WAThe pilot's failure to maintain clearance from obstacles during the landing roll. Contributing to the accident was the reduced visibility due to precipitation.NTSB WPR10CA246Accident · No injuriesData collectionFinal reportCessna 180K · Renton, WAThe pilot's inadequate compensation for the wind conditions, resulting in the loss of directional control during the landing roll.NTSB WPR10LA235Accident · No injuriesLimited investigationFinal reportBeech 35 · South Bend, WAA loss of engine power during takeoff for undetermined reasons, which resulted in a runway overrun.NTSB WPR10LA198Accident · Minor injuriesLimited investigationFinal reportGrumman American Avn. G-1159 · Seattle, WAThe failure of the pilot to maintain adequate clearance/distance from the fuel truck during taxi.NTSB WPR10LA196Accident · No injuriesLimited investigationFinal reportCessna P210N · Leavenworth, WAThe failure of the number two cylinder exhaust and intake valves for undetermined reasons, which resulted in a loss of engine power.NTSB WPR10LA182Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Anacortes, WAThe pilot’s inadequate fuel planning, which resulted in a loss of engine power due to fuel exhaustion.NTSB WPR10FA163Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Morton, WAThe failure of maintenance personnel to properly secure a fitting cap on the throttle and metering assembly inlet after conducting a fuel system pressure check, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was…NTSB WPR10LA171Accident · No injuriesLimited investigationFinal reportCarr RV-4 · Arlington, WAThe failure of both main landing gear's drag link bolts in overstress and the subsequent collapse of the landing gear during landing rollout.NTSB WPR10LA165Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Eliza Island, WAThe total loss of engine power during cruise flight due to the failure of maintenance personnel to tighten a fitting on the propeller governor oil line, which resulted in a loss of engine oil and catastrophic engine failure.NTSB WPR10CA167Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Okanogan, WAThe pilot's failure to maintain clearance from a fence at the end of the runway.NTSB WPR10CA151Accident · No injuriesData collectionFinal reportTarantola Leonard RV-6A · Onalaska, WAThe pilot's bounced landing on a soft turf runway, resulting in a collapsed nose landing gear.NTSB WPR10LA150Accident · Serious injuriesLimited investigationFinal reportMuffett Quickslvr Sprnt II · Buena, WAA loss of engine power due to fuel exhaustion as a result of the student pilot’s inadequate fuel planning.NTSB WPR10LA139Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Colfax, WAA partial loss of engine power due to carburetor ice as a result of the pilot's failure to use carburetor heat.NTSB WPR10CA132Accident · No injuriesData collectionFinal reportLeza Lockwood Air Cam · Everett, WAThe pilot's inadvertent encounter with the rotor downwash from a hovering heavy-lift helicopter.NTSB WPR10LA122Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Pullman, WAA partial loss of engine power during takeoff due to a bird's nest being sucked into the induction air ducting.NTSB WPR10LA103Accident · 2 fatalLimited investigationFinal reportLarson RV8 · Sequim, WAThe pilot's failure to maintain adequate airspeed while maneuvering in the traffic pattern, which resulted in an aerodynamic stall.