# NTSB investigations, CT: Preflight or dispatch event

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 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…
- [NTSB ERA15LA053](https://openairdocs.org/ntsb/ERA15LA053.md): Beech F33A · Clinton, CT · Accident · Minor injuries · Limited investigation · Final report · Nov 15, 2014 · N4548S · Substantial damage
  > The pilot's inadequate fuel planning and improper fuel management, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot's failure to follow proper procedures in response to the loss of engine power.
- [NTSB ERA14CA430](https://openairdocs.org/ntsb/ERA14CA430.md): Cessna 172M · Watertown, CT · Accident · Minor injuries · Data collection · Final report · Sep 9, 2014 · N20469 · Substantial damage
  > The pilot's decision to takeoff from a field which resulted in a collision with trees and the ground. Contributing to the accident was the pilot's failure to correctly identify the destination airport and runway, which resulted in an off-airport landing in…
- [NTSB ERA13LA276](https://openairdocs.org/ntsb/ERA13LA276.md): Cessna 170 · Plainville, CT · Accident · No injuries · Limited investigation · Final report · Jun 9, 2013 · N2585V · Substantial damage
  > The pilot’s overflight of the landing runway during a forced landing after a loss of engine power. Contributing to the accident was the pilot’s inadequate preflight which resulted in his failure to detect water contamination of the fuel system.
- [NTSB ERA13LA117](https://openairdocs.org/ntsb/ERA13LA117.md): Cirrus Design SR20 · Danbury, CT · Accident · No injuries · Limited investigation · Final report · Jan 23, 2013 · N140PG · Substantial damage
  > The flight instructor’s inadequate preflight inspection in which he incorrectly estimated the airplane’s fuel quantity and his improper reliance on the fuel totalizer rather than the fuel quantity indicating and warning systems to determine the fuel on board,…
- [NTSB ERA12LA001](https://openairdocs.org/ntsb/ERA12LA001.md): Mooney M20K · Ridgefield, CT · Accident · Serious injuries · Limited investigation · Final report · Oct 1, 2011 · N231EB · Substantial damage
  > The pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.

## 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '030' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/030/sequence?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.
