NTSB investigations, 2011, WA

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 year(c.\"eventDate\") = 2011
    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.

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.Mar 19, 2011 · N386GX · 2 aircraft · Substantial damageNTSB WPR11FA159Accident · No injuriesField investigationFinal reportFairchild SA227-AC · Seattle, WAThe pilot's failure to extend the landing gear, which resulted in a gear-up landing.Mar 11, 2011 · N671AV · Substantial damageNTSB 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.Feb 28, 2011 · N684DA · No damageNTSB WPR11CA132Accident · Minor injuriesData collectionFinal reportCessna 170A · Baker Lake, WAThe pilot's encounter with soft terrain during an attempted takeoff from a dry lake bed.Feb 11, 2011 · N9768A · Substantial damageNTSB 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.Feb 1, 2011 · N2718R · Substantial damageNTSB 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…Jan 26, 2011 · N92LW · Substantial damageNTSB 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…Jan 22, 2011 · N142HF · Substantial damageNTSB WPR11LA095Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Lopez, WAA loss of engine power during initial climb for undetermined reasons.Jan 9, 2011 · N5850D · Substantial damage