# NTSB investigations, MA: Controlled flight into terr/obj (CFIT)

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 ERA21LA266](https://openairdocs.org/ntsb/ERA21LA266.md): Pilatus B4-PC11 · Sterling, MA · Accident · Minor injuries · Class 4 · Limited · Final report · May 20, 2021 · N65317 · Substantial damage
  > The pilot’s misjudged approach angle which resulted in impact with trees and terrain.
- [NTSB ERA14LA347](https://openairdocs.org/ntsb/ERA14LA347.md): Colt Balloons 160A · Clinton, MA · Accident · Serious injuries · Limited investigation · Final report · Jul 20, 2014 · N976TC · Minor damage
  > The pilot's inadequate preflight and inflight planning and improper landing site selection and approach path, which resulted in the balloon contacting powerlines during landing. Contributing to the accident was the Federal Aviation Administration's inadequate…
- [NTSB ERA14CA124](https://openairdocs.org/ntsb/ERA14CA124.md): Cessna 172S · Mansfield, MA · Accident · No injuries · Data collection · Final report · Feb 15, 2014 · N2143X · Substantial damage
  > The student pilot's failure to maintain an adequate approach glide path, which resulted in a collision with a snow bank.
- [NTSB ERA11FA480](https://openairdocs.org/ntsb/ERA11FA480.md): Piper PA-28-181 · Provincetown, MA · Accident · 1 fatal · Field investigation · Final report · Sep 1, 2011 · N6249C · Destroyed
  > The pilot’s failure to maintain adequate clearance from trees and terrain during the initial climb. Contributing was spatial disorientation due to a vestibular illusion and the pilot’s likely impairment due to alcohol consumption.
- [NTSB ERA11FA102](https://openairdocs.org/ntsb/ERA11FA102.md): Cessna 310F · Orange, MA · Accident · 1 fatal · Field investigation · Final report · Jan 1, 2011 · N6725X · Substantial damage
  > The pilot did not maintain separation from trees during landing. Contributing to the accident was the pilot’s inadequate preflight planning and lack of recent night flight experience.
- [NTSB ERA10CA337](https://openairdocs.org/ntsb/ERA10CA337.md): Piper PA-28-181 · Great Barrington, MA · Accident · Serious injuries · Data collection · Final report · Jun 28, 2010 · N30062 · Substantial damage
  > The pilot's attempted visual flight into night instrument meteorological conditions, which resulted in spatial disorientation and subsequent controlled flight into terrain.
- [NTSB ERA10CA289](https://openairdocs.org/ntsb/ERA10CA289.md): Cessna 172N · Sterling, MA · Accident · No injuries · Data collection · Final report · May 31, 2010 · N6371D · Substantial damage
  > The pilot’s decision to not continue with the go-around, which resulted in a collision with trees. Contributing to the accident was the pilot’s distraction due to the passenger’s panicked condition.

## 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '120' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/120/sequence?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.