NTSB investigations, 2008, IN

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

Cases per year

20082026
NTSB investigations, 2008, IN per year, 2008–2026: 50 cases
20084
20092
20106
20113
20122
20133
20142
20152
20162
20173
20187
20194
20213
20221
20256

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\" = 'IN' 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 CHI08IA294Incident · No injuriesIncident investigationFinal reportIndus T-211 Thorpedo · La Porte, INA loss of engine power due to fuel exhaustion as a result of siphoning from the fuel filler neck and cap. Contributing to the incident were the fuel over-servicing which resulted in the siphoning condition, and the ASTM standards which allowed for the fuel…Sep 18, 2008 · N107JF · Minor damageNTSB CHI08CA217Accident · No injuriesData collectionFinal reportGrumman G-164A · Veedersburg, INThe oil filler cap not reinstalled by the pilot prior to the aerial application flight and the total loss of engine oil during an aerial application. Additional causes were the low altitude of the operation and the unsuitable terrain encountered by the pilot…Jul 28, 2008 · N9892 · Substantial damageNTSB CHI08CA210Accident · No injuriesData collectionFinal reportBell 47G-3B-2 · Lafetyette, INThe loss of engine power during an aerial application flight due to a fatigue fracture of the carburetor heat control valve spring and the inadequate maintenance inspection by the pilot/mechanic. An additional cause was the low altitude of the operation.Jul 24, 2008 · N4029G · Substantial damageNTSB CHI08LA144Accident · No injuriesLimited investigationFinal reportCessna 208B · Greensburg, INThe total loss of engine power during the en route climb due to a compressor turbine failure as a result of blade creep. Also causal was the inadequate maintenance performed by the airplane's owner.Jun 1, 2008 · N102VE · Substantial damage