# NTSB investigations: Continental C145 series, 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 ERA25LA312](https://openairdocs.org/ntsb/ERA25LA312.md): Cessna 170 · Fitchburg, MA · Accident · No injuries · Class 4 · Limited · Final report · Aug 23, 2025 · N2589V · Substantial damage
  > The pilot’s failure to maintain directional control during the landing roll with a quartering tailwind.
- [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 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 NYC67D0154](https://openairdocs.org/ntsb/NYC67D0154.md): Cessna 170B · Plymouth, MA · Accident · No injuries · Closed · Aug 20, 1966 · N3123A · Substantial damage
- [NTSB NYC66D0631](https://openairdocs.org/ntsb/NYC66D0631.md): Globe GC-1B · Orange, MA · Accident · No injuries · Closed · Apr 17, 1966 · N3785K · Substantial damage
- [NTSB NYC65F0069](https://openairdocs.org/ntsb/NYC65F0069.md): Cessna 172 · Haverhill, MA · Accident · No injuries · Closed · Feb 28, 1965 · N7111A · 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.engine_model_code IN ('17012'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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