NTSB investigations, 2008, CA

8 cases where the sequence of events included Loss of engine power (partial).

Cases per year

20082026
NTSB investigations, 2008, CA per year, 2008–2026: 167 cases
20088
200918
201016
201112
201212
20137
201414
201510
201610
201713
201810
20196
20208
20219
20225
20232
20243
20254

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\") = 2008
    AND c.\"eventStateOrRegion\" = 'CA' 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\" = '342' 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 WPR09LA047Accident · Serious injuriesLimited investigationFinal reportNickel RV-6 · Fresno, CAThe loss of engine power during initial climb for undetermined reasons.Nov 25, 2008 · N6TR · Substantial damageNTSB LAX08CA295Accident · Minor injuriesData collectionFinal reportMiltenberger Family Fun · Adin, CAThe loss of engine power due to carburetor icing and the pilot's failure to use carburetor heat.Sep 10, 2008 · N903PD · Substantial damageNTSB LAX08LA263Accident · Serious injuriesLimited investigationFinal reportSmith Stewart S51D · Oxnard, CAThe loss of engine power for an undetermined reason.Aug 9, 2008 · N51VS · Substantial damageNTSB LAX08LA221Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Moorpark, CAA partial loss of engine power due to the disconnection of the throttle control cable from the throttle arm due to the operator's improper maintenance. Contributing to the accident was unsuitable terrain for a forced landing.Jul 9, 2008 · N9627B · Substantial damageNTSB SEA08LA133Accident · Minor injuriesLimited investigationFinal reportThrush S-2R · Holtville, CAThe loss of oil pressure for undetermined reasons.May 11, 2008 · N8860Q · Substantial damageNTSB LAX08LA128Accident · No injuriesLimited investigationFinal reportCessna 175A · Rio Linda, CAThe partial loss of engine power due to detonation. Contributing to the accident was trees in the landing area.May 2, 2008 · N7059E · Substantial damageNTSB LAX08LA108Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Columbia, CAThe flight instructor's decision to attempt takeoff with an engine discrepancy and subsequent failure to abort takeoff when the airplane did not attain adequate airspeed during the initial climb, resulting in an aerodynamic stall. Contributing to the accident…Apr 15, 2008 · N1364Q · Substantial damageNTSB SEA08LA087Accident · No injuriesLimited investigationFinal reportMaule M-4 · Bishop, CAA loss of engine power due to foreign object ingestion in the induction system, which resulted in a stuck/jammed exhaust valve during the takeoff.Mar 7, 2008 · N51430 · Substantial damage