NTSB investigations, 2008

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

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\") = 2008
    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 SEA08LA063Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Centerville, WAA loss of engine power due to carburetor icing conditions and the failure of the pilot to use the correct amount of carburetor heat for the existing conditions.Jan 13, 2008 · N7243V · Substantial damageNTSB CHI08LA067Accident · Serious injuriesLimited investigationFinal reportZiermann RV8 · Garrison, MNThe loss of engine power for undetermined reasons during cruise and the misjudged flare resulting in a hard landing. Contributing to the accident was the frozen lake to which the pilot performed a forced landing.Jan 12, 2008 · N617MZ · Substantial damageNTSB NYC08LA077Accident · No injuriesLimited investigationFinal reportBell 407 · DeLand, FLA total loss of engine power due to the fatigue failure of a third stage turbine wheel blade.Jan 7, 2008 · N801DS · Substantial damageNTSB MIA08LA035Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Spotsylvania, VAThe pilot's failure to follow the checklist and failure to achieve the proper touchdown point during a forced landing. Contributing to the accident was a loss of engine power due to a cracked No. 4 top sparkplug insulator, resulting in pre-ignition/detonation…Jan 5, 2008 · N758FQ · Substantial damageNTSB MIA08LA034Accident · No injuriesLimited investigationFinal reportCostruzioni Aeronautiche P2002 Sierra · Stevensville, MDA loss of engine power due to the failure of company maintenance personnel to comply with engine manufacturers requirements for carburetor adjustment during the 100-hour inspection.Jan 3, 2008 · N26WR · Substantial damage