# NTSB investigations: Piper PA-32-260, 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 NYC08CA192](https://openairdocs.org/ntsb/NYC08CA192.md): Piper PA-32-260 · Millinocket, ME · Accident · Minor injuries · Data collection · Final report · May 24, 2008 · N4823S · Substantial damage
  > The pilot’s failure to properly monitor fuel consumption during the flight.
- [NTSB NYC84FNC07](https://openairdocs.org/ntsb/NYC84FNC07.md): Piper PA-32-260 · Brunswick, ME · Accident · Minor injuries · Final report · Aug 2, 1984 · N3474W · Substantial damage
  > The acft eng failed without warning at an alt of 2500 ft MSL. During the forced landing at nas Brunswick, the plt executed normal emergency procedures but was not successful in air-starting the acft. He stated that after having the 'abandoned field made' he…

## 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 ('7103206'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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