# NTSB investigations, MA: Abrupt maneuver

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 IAD05LA044](https://openairdocs.org/ntsb/IAD05LA044.md): Boeing 757-232 · Boston, MA · Accident · Serious injuries · Limited investigation · Final report · Mar 6, 2005 · N6710E · No damage
  > The first officer's misjudgment of a perceived threat, which resulted in the captain's excessive braking and subsequent injury to a flight attendant. A factor was the night lighting conditions.
- [NTSB NYC87LA178](https://openairdocs.org/ntsb/NYC87LA178.md): Robinson R-22 · Sterling, MA · Accident · No injuries · Limited investigation · Final report · Jun 13, 1987 · N351 · Substantial damage
  > While practicing hovering in the designated hover area at the arpt, the stu plt accidently pulled aft cyclic while the helicopter was drifting backwards. This caused the tail structure and rotor blades to contact the ground. The main rotor blades then…
- [NTSB NYC84FA143](https://openairdocs.org/ntsb/NYC84FA143.md): Piper PA-28R-200 · Concord, MA · Accident · 1 fatal · Field investigation · Final report · Apr 19, 1984 · N4467X · Destroyed
  > The acft crashed into a house while on an ILS approach to rwy 11 at hanscom field. Shortly before the acft had reached the outer marker (and after the hand off from boston approach control to hanscom tower) an altitude alert on N4467X was received by the…

## 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" = 100)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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