# NTSB investigations, CT: Not determined, 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 ERA20LA287](https://openairdocs.org/ntsb/ERA20LA287.md): Piper PA34 · Groton, CT · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 18, 2020 · N41382 · Substantial damage
  > The reported partial loss of right engine power for reasons that could not be determined based on available evidence.
- [NTSB ERA19LA149](https://openairdocs.org/ntsb/ERA19LA149.md): Piper PA28R · Meriden, CT · Accident · Serious injuries · Class 3 · Limited · Final report · Apr 11, 2019 · N38658 · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB ERA18FA189](https://openairdocs.org/ntsb/ERA18FA189.md): Rutan Defiant · Plainville, CT · Accident · 1 fatal · Field investigation · Final report · Jul 12, 2018 · N17DR · Substantial damage
  > The pilot's loss of airplane control during climb for reasons that could not be determined based on the available information.
- [NTSB WPR18LA173](https://openairdocs.org/ntsb/WPR18LA173.md): Piper PA 28-140 · Hartford, CT · Accident · No injuries · Class 3 · Limited · Final report · Jun 16, 2018 · N1782J · Substantial damage
  > A loss of engine power for undetermined reasons because postaccident examination of the engine and fuel system did not reveal any anomalies that would have precluded normal operation, which led to the pilot’s forced landing and subsequent runway overshoot and…
- [NTSB ERA17LA276](https://openairdocs.org/ntsb/ERA17LA276.md): Bradley Roderick W Murphy Renegade · Guilford, CT · Accident · Minor injuries · Limited investigation · Final report · Aug 14, 2017 · N210SQ · Substantial damage
  > A total loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB ERA17FA011](https://openairdocs.org/ntsb/ERA17FA011.md): Piper PA 34-200 · East Hartford, CT · Accident · 1 fatal · Field investigation · Final report · Oct 11, 2016 · N15294 · Destroyed
  > The NTSB did not determine the probable cause of this event and does not plan to issue a report or open a public docket. The investigation of this event is being conducted under the jurisdiction of the Federal Bureau of Investigation.
- [NTSB ERA17LA007](https://openairdocs.org/ntsb/ERA17LA007.md): James Bruton Flying Flea · Plymouth, CT · Accident · Serious injuries · Limited investigation · Final report · Oct 6, 2016 · N83165 · Substantial damage
  > A partial loss of engine power for reasons that could not be determined based on the available information.
- [NTSB ERA15LA063](https://openairdocs.org/ntsb/ERA15LA063.md): Cessna 182 · Hartford, CT · Accident · No injuries · Limited investigation · Final report · Nov 29, 2014 · N759VG · Substantial damage
  > The partial loss of engine power during climb after takeoff for a reasons that could not be determined because postaccident engine examination revealed no evidence of mechanical malfunctions or failures.

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

This list as a web page: https://openairdocs.org/ntsb-findings/05000000/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.