# NTSB investigations, 2018, 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 GAA18CA538](https://openairdocs.org/ntsb/GAA18CA538.md): Avid Avid Magnum · Carrabassett Valley, ME · Accident · No injuries · Data collection · Final report · Sep 6, 2018 · N2137G · Substantial damage
  > The pilot’s improper decision to initiate the flight in marginal visual flight rules over mountainous terrain, which resulted in an inadvertent encounter with instrument meteorological and downdraft conditions and the subsequent controlled flight into trees…
- [NTSB ERA18LA228](https://openairdocs.org/ntsb/ERA18LA228.md): Cessna T206 · Pittsfield, ME · Accident · Serious injuries · Limited investigation · Final report · Aug 23, 2018 · N35442 · Substantial damage
  > Wear of the No. 4 cylinder exhaust camshaft lobe and roller tappet, which resulted in the failure of the tappet and the subsequent total loss of engine power.
- [NTSB ERA18FA206](https://openairdocs.org/ntsb/ERA18FA206.md): Piper PA60 · Greenville, ME · Accident · 3 fatal · Field investigation · Final report · Jul 30, 2018 · C-GRRS · Destroyed
  > The pilot's exceedance of the airplane's critical angle of attack while maneuvering to land, which resulted in an aerodynamic stall.
- [NTSB ERA18LA190](https://openairdocs.org/ntsb/ERA18LA190.md): Glasair SH2 · Passadumkeag, ME · Accident · No injuries · Class 3 · Limited · Final report · Jul 11, 2018 · N352GL · Substantial damage
  > A total loss of engine power due to a fatigue fracture of the crankshaft.

## 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 year(c."eventDate") = 2018
  AND c."eventStateOrRegion" = 'ME' AND c."eventCountry" = 'USA'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

---
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.
