# NTSB investigations: Cessna 172K, ME

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB ERA12LA241](https://openairdocs.org/ntsb/ERA12LA241.md): Cessna 172K · Belfast, ME · Accident · No injuries · Limited investigation · Final report · Mar 20, 2012 · N46492 · Substantial damage
  > The 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…
- [NTSB ERA11CA333](https://openairdocs.org/ntsb/ERA11CA333.md): Cessna 172K · Bar Harbor, ME · Accident · No injuries · Data collection · Final report · Apr 6, 2011 · N46643 · Substantial damage
  > The pilot's inadequate landing flare while landing with a gusting wind, which resulted in a hard landing.
- [NTSB NYC88FA218](https://openairdocs.org/ntsb/NYC88FA218.md): Cessna 172K · Island Falls, ME · Accident · 1 fatal · Field investigation · Final report · Aug 15, 1988 · N1183M · Destroyed
  > Pilot's poor in-inflight decisions and planning and failed to follow ATC directives to maintain VFR. The pilot continued VFR into IFR conditions and collided with hilly terrain.
- [NTSB NYC82DA225](https://openairdocs.org/ntsb/NYC82DA225.md): Cessna 172K · Vinalhaven, ME · Accident · No injuries · Final report · Sep 11, 1982 · N84220 · Destroyed
  > The engine lost power at 100 feet of altitude after takeoff. The pilot found by pumping the throttle, he could regain some power. The aircraft collided with trees and came to rest on the ground. The mixture control cable had separated about one inch from it…
- [NTSB NYC80FA060](https://openairdocs.org/ntsb/NYC80FA060.md): Cessna 172 · Rockland, ME · Accident · 2 fatal · Closed · Mar 16, 1980 · N707BB · Destroyed

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072430'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072430&state=ME

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.