# NTSB investigations: Cessna 170B, 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 NYC88LA034](https://openairdocs.org/ntsb/NYC88LA034.md): Cessna 170B · Shirley, MA · Accident · No injuries · Limited investigation · Final report · Nov 8, 1987 · N8128A · Substantial damage
  > During final approach to runway 19 at Shirley, Massachusetts the aircraft rolled inverted. Pilot was able to correct and bring the aircraft upright but did not have enough altitude to clear trees. He set the aircraft into the trees and the wing folded back.
- [NTSB NYC82FNA06](https://openairdocs.org/ntsb/NYC82FNA06.md): Cessna 170B · Stow, MA · Accident · No injuries · Closed · Nov 22, 1981 · N2543C · Substantial damage
- [NTSB NYC75DNA17](https://openairdocs.org/ntsb/NYC75DNA17.md): Cessna 170B · Plymouth, MA · Accident · Minor injuries · Closed · Sep 19, 1974 · N2478D · Destroyed
- [NTSB NYC71FNA47](https://openairdocs.org/ntsb/NYC71FNA47.md): Cessna 170B · Taunton, MA · Accident · No injuries · Closed · Apr 17, 1971 · N2501D · Substantial damage
- [NTSB NYC70DFD01](https://openairdocs.org/ntsb/NYC70DFD01.md): Cessna 170B · Tewksbury, MA · Accident · No injuries · Closed · Jan 3, 1970 · N8202A · Substantial damage
- [NTSB NYC68F0476](https://openairdocs.org/ntsb/NYC68F0476.md): Cessna 170B · Hinsdale, MA · Accident · No injuries · Closed · May 5, 1968 · N2208D · Substantial damage
- [NTSB NYC68D0259](https://openairdocs.org/ntsb/NYC68D0259.md): Cessna 170B · Chatham, MA · Accident · No injuries · Closed · Jun 28, 1967 · N433W · Substantial damage
- [NTSB NYC67D0154](https://openairdocs.org/ntsb/NYC67D0154.md): Cessna 170B · Plymouth, MA · Accident · No injuries · Closed · Aug 20, 1966 · N3123A · Substantial damage
- [NTSB NYC66F0222](https://openairdocs.org/ntsb/NYC66F0222.md): Cessna 170B · Norwood, MA · Accident · No injuries · Closed · Sep 4, 1965 · N2438D · 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."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 ('2072306', '2072307'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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