Final NTSB investigations, ME

6 cases where the defining event was Loss of engine power (partial).

Cases per year

20092026
Final NTSB investigations, ME per year, 2009–2026: 6 cases
20091
20101
20122
20151
20201

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 c.\"eventStateOrRegion\" = 'ME' AND c.\"eventCountry\" = 'USA'
    AND c.\"completionStatus\" = 'Completed'
    AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '342')
  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 ERA20LA277Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · St. Agatha, METhe failure of the crankshaft gear alignment dowel due to fatigue crack propagation and overstress, which resulted in a partial loss of engine power.Aug 5, 2020 · N7213W · Substantial damageNTSB ERA15LA334Accident · Serious injuriesLimited investigationFinal reportBeech B19 · Dexter, METhe flight instructor’s inadequate preflight planning, which resulted in collision with trees and terrain during takeoff.Aug 29, 2015 · N2013G · Substantial damageNTSB ERA13CA010Accident · Minor injuriesData collectionFinal reportMoulton Howard Wells ULTRA-PUP · Lyman, METhe accumulation of ice in the automotive engine’s carburetor, which resulted in a loss of engine power.Oct 6, 2012 · N3073X · Substantial damageNTSB ERA12LA241Accident · No injuriesLimited investigationFinal reportCessna 172K · Belfast, METhe flight instructor’s failure to ensure the radio was set correctly to activate the pilot-controlled lighting, which resulted in poor positioning for a proper landing and a subsequent off-runway forced landing during an attempted go-around. Contributing to…Mar 20, 2012 · N46492 · Substantial damageNTSB ERA10LA453Accident · No injuriesLimited investigationFinal reportCessna 120 · Rockland, METhe loss of engine power for undetermined reasons.Aug 29, 2010 · N2493N · DestroyedNTSB ERA09LA433Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Livermore Falls, MEA loss of engine power for undetermined reasons.Aug 1, 2009 · N49778 · Substantial damage