NTSB investigations, 2010, IN

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

Cases per year

20082026
NTSB investigations, 2010, 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\") = 2010
    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 CEN11LA069Accident · No injuriesLimited investigationFinal reportCessna 172R · Farmersburg, INA total loss of engine power for undetermined reasons.Nov 12, 2010 · N531HF · Substantial damageNTSB CEN11CA002Accident · No injuriesData collectionFinal reportGingerich Alton & Slagel Dean Christavia MK 1 · Nappanee, INThe total loss of engine power for undetermined reasons.Oct 1, 2010 · N9049S · Substantial damageNTSB CEN10LA450Accident · No injuriesLimited investigationFinal reportCessna T188C · Montezuma, INThe total loss of engine power due to an insufficient fastener preload that led to the failure of the No. 2 connecting rod assembly.Jul 29, 2010 · N2085J · Substantial damageNTSB CEN10CA441Accident · Minor injuriesData collectionFinal reportWolseley Motors SE5-A · Seymour, INA loss of engine power during initial climb due to fuel exhaustion. Contributing to the accident was the pilot's diverted attention while attempting to restart the engine.Jul 27, 2010 · N93725 · Substantial damageNTSB CEN10CA400Accident · Serious injuriesData collectionFinal reportCessna 182R · Thayer, INA total loss of engine power due to fuel exhaustion as a result of the pilot's failure to visually check the fuel supply prior to takeoff.Jul 14, 2010 · N9797H · Substantial damageNTSB CEN10CA146Accident · No injuriesData collectionFinal reportByler JDT MINI-MAX 1100R · New Paris, INA total loss of engine power in flight due to carburetor icing. Contributing to the accident was the soft field where the airplane nosed over.Mar 8, 2010 · N184PT · Substantial damage