# NTSB investigations, 2023, 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 ERA23LA341](https://openairdocs.org/ntsb/ERA23LA341.md): Piper PA28 · Preston, CT · Accident · No injuries · Class 3 · Limited · Final report · Aug 19, 2023 · N7463W · Substantial damage
  > A failure of the No. 2 connecting rod, which resulted in a total loss of engine power.
- [NTSB ERA23LA315](https://openairdocs.org/ntsb/ERA23LA315.md): Head Balloons AX8-88 · Guilford, CT · Accident · Serious injuries · Class 4 · Limited · Final report · Jul 24, 2023 · N4522E · No damage
  > The pilot’s inadequate supervision of the boarding process and the ground crewmember’s failure to immediately let go of the balloon after it began an inadvertent climb.
- [NTSB ERA23LA216](https://openairdocs.org/ntsb/ERA23LA216.md): Gilbert R. Ringer GP4 · Stratford, CT · Accident · No injuries · Class 4 · Limited · Final report · Apr 27, 2023 · C-GPEX · Substantial damage
  > A failure of the left main landing gear down locking mechanism, which resulted in a collapse of that landing gear and a subsequent runway excursion.
- [NTSB ERA23LA191](https://openairdocs.org/ntsb/ERA23LA191.md): Cessna 152 · Danbury, CT · Accident · Minor injuries · Class 3 · Limited · Final report · Apr 10, 2023 · N757YM · Substantial damage
  > The flight instructor’s inadequate preflight fuel planning and oversight of the preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA23LA135](https://openairdocs.org/ntsb/ERA23LA135.md): Bombardier BD-100-1A10 · Windsor Locks, CT · Accident · 1 fatal · Class 2 · Limited · Final report · Mar 3, 2023 · N300ER · Minor damage
  > The flight crew’s failure to remove the right side pitot probe cover before flight, their decision to depart with a No-Go advisory message following an aborted takeoff, and their selection of the incorrect non-normal checklist in flight, which resulted in an…
- [NTSB ERA23LA121](https://openairdocs.org/ntsb/ERA23LA121.md): Richard Brinkman Lancair 4P · Hartford, CT · Accident · Serious injuries · Class 3 · Limited · Final report · Jan 28, 2023 · N550LX · Substantial damage
  > The pilot’s takeoff with a significant fuel imbalance, which resulted in the airplane lacking the roll authority to overcome the left rolling tendency and subsequently impacting terrain. Contributing to the accident was the pilot’s inadequate preflight…

## 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") = 2023
  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=2023

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