# NTSB investigations: Mcpherson EVANS VP-1

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 NYC85FNA02](https://openairdocs.org/ntsb/NYC85FNA02.md): Mcpherson Evans VP-1 · Boxborough, MA · Accident · Serious injuries · Final report · Jun 11, 1985 · N106JM · Substantial damage
  > The pilot experienced an engine failure and allowed the airspeed to decrease until the aircraft stalled and spun to the ground. The cause of the engine failure was not determined. The pilot received serious injuries and the homebuilt aircraft received…
- [NTSB NYC77FNA01](https://openairdocs.org/ntsb/NYC77FNA01.md): Evans VP1 · Stow, MA · Accident · No injuries · Closed · Oct 11, 1976 · N106JM · Substantial damage

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

This list as a web page: https://openairdocs.org/ntsb?model=0563518

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