# NTSB investigations, 2018, CT

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 GAA19CA091](https://openairdocs.org/ntsb/GAA19CA091.md): Zlin Z143 · Chester, CT · Accident · No injuries · Data collection · Final report · Dec 10, 2018 · N143GW · Substantial damage
  > The pilot's loss of airplane control during the engine start.
- [NTSB ERA19LA030](https://openairdocs.org/ntsb/ERA19LA030.md): Piper PA28 · Simsbury, CT · Accident · Minor injuries · Limited investigation · Final report · Oct 28, 2018 · N8132X · Substantial damage
  > Maintenance personnel's inadequate inspection of the wheel brake system during the airplane's most recent 100-hour inspection, which resulted in a loss of hydraulic fluid and the pilot's inability to control the airplane during the landing.
- [NTSB GAA18CA529](https://openairdocs.org/ntsb/GAA18CA529.md): Piper PA46 · Hartford, CT · Accident · No injuries · Data collection · Final report · Aug 28, 2018 · N178DB · Substantial damage
  > The pilot’s unstabilized approach and hard landing, which resulted in a nose landing gear collapse.
- [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 GAA18CA374](https://openairdocs.org/ntsb/GAA18CA374.md): Beech V35B · Chester, CT · Accident · No injuries · Data collection · Final report · Jun 21, 2018 · N6KG · Substantial damage
  > The pilot’s failure to maintain clearance from a hangar during taxi.
- [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 GAA18CA345](https://openairdocs.org/ntsb/GAA18CA345.md): Cessna 172 · Danbury, CT · Accident · No injuries · Data collection · Final report · Jun 9, 2018 · N383ME · Substantial damage
  > A collision with a bird during initial climb.
- [NTSB ERA18LA071](https://openairdocs.org/ntsb/ERA18LA071.md): Piper PA28 · Meriden, CT · Accident · Serious injuries · Limited investigation · Final report · Jan 27, 2018 · N9673W · Substantial damage
  > The pilot's inadequate preflight fuel planning and his improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.

## 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 year(c."eventDate") = 2018
  AND c."eventStateOrRegion" = 'CT' AND c."eventCountry" = 'USA'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?state=CT&year=2018

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