NTSB investigations, 2009, WA

10 cases where the sequence of events included Loss of engine power (total).

Cases per year

20082026
NTSB investigations, 2009, WA per year, 2008–2026: 100 cases
200812
200910
201012
20115
20128
20144
20157
20162
20175
20185
20196
20203
20215
20222
20232
20243
20256
20263

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\" = '341' 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 WPR09LA364Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Washougal, WAA loss of engine power during initial climb due to a stuck exhaust valve.Jul 24, 2009 · N22278 · Substantial damageNTSB WPR09LA362Accident · 1 fatalLimited investigationFinal reportMooney M20C · Elma, WAA total loss of engine power during cruise flight due to the fatigue failure of the number 4 cylinder connecting rod.Jul 22, 2009 · N6422U · DestroyedNTSB WPR09CA349Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Snohomish, WAA complete loss of engine power due to the failure of the airplane's engine-driven fuel pump.Jul 15, 2009 · N827EV · Substantial damageNTSB WPR09CA342Accident · No injuriesData collectionFinal reportMid-South Custom Craft SH-2R · Sequim, WAThe total loss of engine power due to fuel starvation as a result of the pilot's failure to reposition the fuel selector to the main tank. Contributing to the accident was the pilot's failure to properly complete the pre-takeoff checklist.Jul 12, 2009 · N370LR · Substantial damageNTSB WPR09CA329Accident · No injuriesData collectionFinal reportNalis Glastar · Arlington, WAA total loss of engine power due to fuel starvation as a result of the pilot's failure to select the fullest tank prior to takeoff.Jul 5, 2009 · N432P · Substantial damageNTSB WPR09CA262Accident · No injuriesData collectionFinal reportCessna 210 · Seattle, WAA total loss of engine power due to fuel starvation as a result of the pilot's failure to activate the fuel boost pump when attempting an engine restart. Contributing to the accident was the pilot's failure to use a checklist.May 25, 2009 · N210AK · Substantial damageNTSB WPR09LA227Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Colfax, WAA total loss of engine power due to excessive wear in several carburetor components that led to a malfunction of the carburetor.May 4, 2009 · N6628Q · Substantial damageNTSB WPR09LA223Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Puyallup, WAA loss of engine power due to fuel starvation as a result of the pilot’s failure to verify the fuel levels in the tanks, and, his failure to select the proper fuel tank.May 1, 2009 · N382CH · Substantial damageNTSB WPR09LA197Accident · No injuriesLimited investigationFinal reportRaytheon A36 · Lopez Island, WAA loss of engine power during cruise flight due to oil starvation. The oil starvation event was due to the failure of maintenance personnel to tighten the aft mounting nuts for the newly installed propeller governor and the pilot’s failure to secure the oil…Apr 16, 2009 · N464TJ · Substantial damageNTSB WPR09CA113Accident · Minor injuriesData collectionFinal reportCessna 172D · Bow, WAA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight inspection and failure to verify the fuel quantity on board.Feb 9, 2009 · N2404Y · Substantial damage