# NTSB investigations: Beech C23, 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 NYC02LA132](https://openairdocs.org/ntsb/NYC02LA132.md): Beech C23 · Newburyport, MA · Accident · No injuries · Limited investigation · Final report · Jul 6, 2002 · N823DA · Substantial damage
  > A power loss for undetermined reason(s), which resulted in a subsequent forced landing to unsuitable terrain. A factor was the unsuitable terrain.
- [NTSB NYC91LA191](https://openairdocs.org/ntsb/NYC91LA191.md): Beech C-23 · Williamstown, MA · Accident · No injuries · Limited investigation · Final report · Jul 28, 1991 · N7690R · Substantial damage
  > Engine failure as a result of improper engine overhaul performed by other maintenance personnel. A factor was the lack of suitable terrain.
- [NTSB NYC88LA012](https://openairdocs.org/ntsb/NYC88LA012.md): Cessna 172P · Bedford, MA · Accident · No injuries · Limited investigation · Final report · Oct 17, 1987 · N97313 · 2 aircraft · Substantial damage
  > A Cessna 172, N97313, and a Beech C23, N6718Z, collided in flt as the plts of both acft were arriving to land on rwy 11 at hanscom field. The Cessna plt had planned to land at beverly, MA, but diverted to hansom field due to wx. The Cessna was in a left turn…
- [NTSB NYC81FNA15](https://openairdocs.org/ntsb/NYC81FNA15.md): Beech C23 · Bedford, MA · Accident · No injuries · Closed · Apr 26, 1981 · N804Y · 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 ('1151242'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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