NTSB investigations, 2009, WA

8 cases where the sequence of events included Nose over/nose down.

Cases per year

20082026
NTSB investigations, 2009, WA per year, 2008–2026: 101 cases
20086
20098
20108
201113
20126
20135
20146
20157
20167
20173
20186
20196
20206
20211
20221
20236
20241
20251
20264

Latest 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\") = 2009
    AND c.\"eventStateOrRegion\" = 'WA' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '096' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 WPR10CA096Accident · No injuriesData collectionFinal reportStinson SR-8B · Auburn, WAThe pilot’s failure to maintain directional control during the landing roll.Dec 23, 2009 · N17119 · Substantial damageNTSB WPR10CA073Accident · No injuriesData collectionFinal reportCessna 172M · Diamond Point, WAThe pilot's inadequate compensation for the variable and unfavorable wind conditions.Dec 6, 2009 · N20186 · Substantial damageNTSB WPR09LA423Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Ballard, WAThe pilot's precautionary water landing with partially extended landing gear. Contributing to the accident was the unidentified anomaly with the airplane's electrical system, which rendered the gear position indicator system inoperative.Aug 28, 2009 · N682RC · Substantial damageNTSB WPR09CA306Accident · No injuriesData collectionFinal reportJenkins Jack Glastar SP · Coupeville, WAThe pilot’s improper landing flare that resulted in a hard landing on soft/grassy terrain.Jun 22, 2009 · N5617 · Substantial damageNTSB WPR09CA276Accident · No injuriesData collectionFinal reportCessna A185F · Wenatchee, WAThe pilot's misjudged approach and failure to attain the proper touchdown point.Jun 2, 2009 · N1015F · Substantial damageNTSB WPR09CA260Accident · No injuriesData collectionFinal reportStinson SR-8B · Tacoma, WAThe application of unintended braking input due to the pilot's failure to keep his feet correctly positioned on the rudder pedals during the landing roll.May 24, 2009 · N17119 · Substantial damageNTSB WPR09CA252Accident · No injuriesData collectionFinal reportCessna 185E · Tacoma, WAThe pilot's failure to maintain directional control while landing with a crosswind.May 18, 2009 · N70083 · Substantial damageNTSB WPR09CA191Accident · Serious injuriesData collectionFinal reportRemos Gemini Remos · Jefferson, WAThe pilot's inadequate compensation for the gusty crosswinds conditions while approaching to land.Apr 9, 2009 · N249SW · Substantial damage