# NTSB investigations, MA: Adequacy of policy/proc

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 ERA14MA271](https://openairdocs.org/ntsb/ERA14MA271.md): Gulfstream Aerospace G IV · Bedford, MA · Accident · 7 fatal · Class 1 · Major · Final report · Jun 1, 2014 · N121JM · Destroyed
  > The flight crewmembers' failure to perform the flight control check before takeoff, their attempt to take off with the gust lock system engaged, and their delayed execution of a rejected takeoff after they became aware that the controls were locked.…
- [NTSB ERA10FA283](https://openairdocs.org/ntsb/ERA10FA283.md): Schweizer 269C-1 · Boxborough, MA · Accident · 1 fatal · Field investigation · Final report · May 26, 2010 · N73SJ · Substantial damage
  > The FAA inspector's rapid reduction of power which resulted in a loss of engine power and his decision to initiate a turn during the autorotation without sufficient altitude to clear obstacles. Contributing to the accident was the FAA’s lack of comprehensive…
- [NTSB ERA09LA358](https://openairdocs.org/ntsb/ERA09LA358.md): Piper PA-28-161 · Plymouth, MA · Accident · Minor injuries · Limited investigation · Final report · Jun 20, 2009 · N29496 · Substantial damage
  > The CFI's inadequate preflight planning and delay to abort the takeoff from the soft takeoff area.

## 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '04021015'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/04021015/cases?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, except the copies of manufacturers’ service documents, which belong to their rights holders.
