# NTSB investigations, CT: Performance/control parameters, general

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 GAA17CA530](https://openairdocs.org/ntsb/GAA17CA530.md): Cessna 172 · Plainville, CT · Accident · Minor injuries · Data collection · Final report · Sep 11, 2017 · N54463 · Substantial damage
  > The pilot’s failure to properly execute the go-around, which resulted in the airplane failing to maintain a climb, which resulted in collision with a tree.
- [NTSB ERA16LA267](https://openairdocs.org/ntsb/ERA16LA267.md): Temple Benjamin Freedom Master FM-2 · East Haddam, CT · Accident · Serious injuries · Limited investigation · Final report · Jul 23, 2016 · N282XT · Substantial damage
  > The pilot’s loss of airplane control during the initial climb.
- [NTSB ERA13LA116](https://openairdocs.org/ntsb/ERA13LA116.md): Robinson Helicopter R22 Beta · Ellington, CT · Accident · Minor injuries · Limited investigation · Final report · Jan 17, 2013 · N26NE · Substantial damage
  > The separation of the collective push-pull tube and jackshaft assembly, which resulted in the total loss of helicopter control and collision with terrain. Contributing to the accident was the inadequate supervision of maintenance personnel by the operator…

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

This list as a web page: https://openairdocs.org/ntsb-findings/01062000/cases?state=CT

---
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.