# NTSB investigations: Cessna 177B, 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 ERA14CA364](https://openairdocs.org/ntsb/ERA14CA364.md): Cessna 177B · Falmouth, MA · Accident · No injuries · Data collection · Final report · Jul 19, 2014 · N18509 · Substantial damage
  > The pilot's misjudgment of speed and distance on final approach resulting in a touchdown near the departure end of the runway, a runway excursion, and collision with trees.
- [NTSB ERA10LA396](https://openairdocs.org/ntsb/ERA10LA396.md): Cessna 177B · Mashpee, MA · Accident · No injuries · Limited investigation · Final report · Aug 2, 2010 · N925KM · Substantial damage
  > The pilot’s delayed use of carburetor heat while flying at reduced power settings in conditions that were favorable for carburetor icing resulting in the partial loss of engine power.
- [NTSB NYC96LA117](https://openairdocs.org/ntsb/NYC96LA117.md): Cessna 177B · Chatham, MA · Accident · Minor injuries · Limited investigation · Final report · May 28, 1996 · N19708 · Substantial damage
  > failure of the oil pump, which resulted in oil starvation and subsequent failure of the number two and four cylinder connecting rods. Also causal was inadequate maintenance by noncompliance with the airworthiness directive that required replacement of the oil…
- [NTSB NYC90LA074](https://openairdocs.org/ntsb/NYC90LA074.md): Cessna 177B · Oxford, MA · Accident · No injuries · Limited investigation · Final report · Mar 3, 1990 · N34873 · Substantial damage
  > An off airport landing in unsuitable terrain following a power loss due to a delaminated ceet duct between the air intake screen and carburetor air box.
- [NTSB NYC78FNA45](https://openairdocs.org/ntsb/NYC78FNA45.md): Cessna 177B · Marth Vineyard, MA · Accident · Minor injuries · Closed · Aug 19, 1978 · N30710 · Substantial damage
- [NTSB NYC78FA081](https://openairdocs.org/ntsb/NYC78FA081.md): Cessna 177 · Chatham, MA · Accident · 1 fatal · Closed · Aug 14, 1978 · N34487 · Substantial damage
- [NTSB NYC78FNA28](https://openairdocs.org/ntsb/NYC78FNA28.md): Cessna 177B · Plymouth, MA · Accident · No injuries · Closed · Jun 4, 1978 · N19708 · 2 aircraft · Substantial damage
- [NTSB NYC73FNA20](https://openairdocs.org/ntsb/NYC73FNA20.md): Cessna 177 · Oak Bluffs, MA · Accident · No injuries · Closed · Sep 8, 1972 · N34201 · 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 ('2073708'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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