# NTSB investigations, ME: Dragged wing,rotor,pod,float or tail/skid

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 ANC08LA007](https://openairdocs.org/ntsb/ANC08LA007.md): Cessna 172M · Rangeley, ME · Accident · No injuries · Limited investigation · Final report · Oct 18, 2007 · N92737 · Substantial damage
  > The pilot's failure to maintain aircraft control during the landing flare/touchdown. A factor contributing to the accident was the pilot's diverted attention.
- [NTSB NYC91LA243](https://openairdocs.org/ntsb/NYC91LA243.md): Lake LA-4 · Wilton, ME · Accident · No injuries · Limited investigation · Final report · Sep 21, 1991 · N1012L · Substantial damage
  > The pilot's improper recovery from a bounced landing on rough water which resulted in the right wing tip contacting the water causing the airplane to nose over and sink. Factors related to the accident were, the pilot's low time and experience in this type…
- [NTSB NYC91LA184](https://openairdocs.org/ntsb/NYC91LA184.md): Piper PA-11 · Eagle Lake, ME · Accident · Minor injuries · Limited investigation · Final report · Jul 20, 1991 · N4504M · Substantial damage
  > The pilot's misjudgment of his altitude during a landing on glassy water, which resulted in a loss of airplane control.
- [NTSB NYC87IA014](https://openairdocs.org/ntsb/NYC87IA014.md): Boeing 727-200 · Portland, ME · Incident · No injuries · Incident investigation · Final report · Oct 15, 1986 · N517PE · Minor damage
  > The cp was flying the aircraft from the left seat while being observed by the PIC. The PIC was monitoring the approach, which was being made in IMC conditions and noted the aircraft drifting to the left, the cp started to make correction to the right at which…
- [NTSB NYC84FA149](https://openairdocs.org/ntsb/NYC84FA149.md): Cessna 170B · Turner, ME · Accident · 1 fatal · Field investigation · Final report · Apr 26, 1984 · N3112A · Destroyed
  > Witnesses observed the acft approach, flaps down, for lndg. A flare was made near the approach end of the runway, then the acft ballooned to about 20 ft AGL and once more descended to the runway surface. On touchdown, the right wing tip appeared to contact…

## 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 160)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?occurrence=160&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.
