# NTSB investigations, MA: On ground/water encounter with terrain/water

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 NYC04CA114](https://openairdocs.org/ntsb/NYC04CA114.md): Cessna 305 A · Taunton, MA · Accident · Minor injuries · Data collection · Final report · Apr 30, 2004 · N2070E · Substantial damage
  > The pilots inadequate pre-flight planning which resulted in a landing on soft terrain and subsequent nose over. A factor was the soft terrain.
- [NTSB NYC01LA111](https://openairdocs.org/ntsb/NYC01LA111.md): Knab-Douglas Jurca MJ5 Sirocco · G. Barrington, MA · Accident · Minor injuries · Limited investigation · Final report · Apr 28, 2001 · N44DK · Substantial damage
  > The pilot's failure to obtain the proper touchdown point, which resulted in an overrun. A factor in this accident was the gusty wind condition.
- [NTSB IAD98LA102](https://openairdocs.org/ntsb/IAD98LA102.md): Cessna 185 · Westport, MA · Accident · No injuries · Limited investigation · Final report · Aug 25, 1998 · N114LS · Substantial damage
  > The flight instructor's failure to maintain control of the airplane and his delayed decision to go-around. Factors related to the accident were the flight instructor's improper inflight decision to land downwind and his inadequate compensation for wind.
- [NTSB NYC94LA071](https://openairdocs.org/ntsb/NYC94LA071.md): Cessna 152 · Amherst, MA · Accident · No injuries · Limited investigation · Final report · Mar 23, 1994 · N6460L · Substantial damage
  > The student pilot's inadvertently becoming lost, and the subsequent precautionary landing in a field, resulting in a collision with soft terrain and nose over.
- [NTSB NYC87FA006](https://openairdocs.org/ntsb/NYC87FA006.md): Piper PA-28-140 · Holyoke, MA · Accident · 3 fatal · Field investigation · Final report · Oct 3, 1986 · N38688 · Destroyed
  > The aircraft was attempting to make a special visual flight rules arrival when it crashed into a rock face slope 2 miles east of the airport while on a easterly heading. The accident occurred over 1 hour after sunset. The pilot did not have an instrument…
- [NTSB NYC84LA188](https://openairdocs.org/ntsb/NYC84LA188.md): Rolladen-Schneider LS-4A · Pepperell, MA · Accident · No injuries · Limited investigation · Final report · May 26, 1984 · N245JD · Substantial damage
  > The glider was attempting a tow-launch when the right wing tip struck a clump of high grass. The glider yawed right and collided with the asphalt rwy, breaking the fuselage and collapsing the landing gear. The pilot stated that the grass was too high for a…
- [NTSB NYC83LA132](https://openairdocs.org/ntsb/NYC83LA132.md): Mooney M20B · Lakeville, MA · Accident · No injuries · Limited investigation · Final report · Jun 4, 1983 · N74788 · Substantial damage
  > The acft collided with the smooth water of a reservoir while flying low during an afternoon flight. The acft crashed about 1000 ft offshore when the right wing tip collided with the surface of the water. The acft then sank in 15-20 ft ofwater. The pilot…
- [NTSB NYC83LA131](https://openairdocs.org/ntsb/NYC83LA131.md): Cessna 182B · Taunton, MA · Accident · No injuries · Limited investigation · Final report · May 21, 1983 · N2632G · Substantial damage
  > The acft collided with a small rock during taxi from landing. As the pilot taxied back to the ramp area along a dirt taxiway he observed three people standing in the way. The pilot taxied onto the grass to avoid the people and while still taxiing the acft…

## 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 320)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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