# NTSB investigations: Cessna 170A, MA

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 NYC99FA060](https://openairdocs.org/ntsb/NYC99FA060.md): Cessna 170A · Leominster, MA · Accident · 1 fatal · Field investigation · Final report · Feb 11, 1999 · N1460D · Substantial damage
  > The pilot's failure to maintain the proper altitude during the approach.
- [NTSB NYC88LA059](https://openairdocs.org/ntsb/NYC88LA059.md): Cessna 170A · Sandwich, MA · Accident · 1 fatal · Limited investigation · Final report · Dec 22, 1987 · N5571C · Destroyed
  > The Cessna 170A was on an aerial photography flt. Witnesses rprtd the acft was flying slow at about 200 ft AGL when it began to settle. The witnesses then heard an increase in eng power & saw the acft pitch up. Subsequently, it 'fell off on a wing,' crashed…
- [NTSB NYC87LA057](https://openairdocs.org/ntsb/NYC87LA057.md): Cessna 170A · Marston Mills, MA · Accident · Minor injuries · Limited investigation · Final report · Jan 9, 1987 · N5571C · Substantial damage
  > The flight was on an aerial photography mission but due to the heavy cloud cover, the aircraft returned to departure airport. The engine quit before reaching the runway and the aircraft was substantially damaged when it collided with terrain. Examination of…
- [NTSB NYC83LA136](https://openairdocs.org/ntsb/NYC83LA136.md): Cessna 170A · Chatham, MA · Accident · No injuries · Limited investigation · Final report · Jun 2, 1983 · N5545C · Substantial damage
  > The acft veered onto the grass and nosed over during landing. The pilot said a gust of wind caught the tail of the acft and turned it 45 degrees to the left and when brakes were applied as a corrective action the acft nosed over. The landing was on runway 6…

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

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

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