# NTSB investigations, 2008, 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 ERA09LA064](https://openairdocs.org/ntsb/ERA09LA064.md): Cessna 172S · Groton, CT · Accident · Minor injuries · Limited investigation · Final report · Nov 19, 2008 · N2337F · Substantial damage
  > The student pilot’s failure to maintain a proper descent profile to avoid trees during the night visual approach and the flight instructor’s inadequate oversight.
- [NTSB ERA09CA048](https://openairdocs.org/ntsb/ERA09CA048.md): Cessna 172 · Groton, CT · Accident · No injuries · Data collection · Final report · Nov 11, 2008 · N91HF · Substantial damage
  > The student pilot's failure to maintain directional control during landing.
- [NTSB ERA09CA034](https://openairdocs.org/ntsb/ERA09CA034.md): Grumman American Avn. AA-5B · Bridgeport, CT · Accident · No injuries · Data collection · Final report · Nov 1, 2008 · N4540L · Substantial damage
  > The pilot's loss of directional control during landing and while suffering symptoms of vertigo.
- [NTSB ERA09CA017](https://openairdocs.org/ntsb/ERA09CA017.md): Cessna 182T · Manchester, CT · Accident · No injuries · Data collection · Final report · Oct 7, 2008 · N771CP · Substantial damage
  > The in-flight collision with a bird.
- [NTSB ERA09CA007](https://openairdocs.org/ntsb/ERA09CA007.md): Cirrus Design SR20 · Chester, CT · Accident · No injuries · Data collection · Final report · Oct 7, 2008 · N889LD · Substantial damage
  > The pilot’s failure to obtain the proper touchdown point while landing. Contributing to the accident were the pilot’s inexperience landing at the airport, night conditions, and non-standard runway lighting.
- [NTSB MIA08LA197](https://openairdocs.org/ntsb/MIA08LA197.md): Berrie Kolb Mark III · East Haddam, CT · Accident · Serious injuries · Limited investigation · Final report · Sep 20, 2008 · N350RB · Substantial damage
  > The pilot's improper preflight inspection of the airplane. Contributing to the accident was water contamination of the fuel.
- [NTSB NYC08CA295](https://openairdocs.org/ntsb/NYC08CA295.md): Cessna 182A · Danielson, CT · Accident · No injuries · Data collection · Final report · Aug 27, 2008 · N169DP · Substantial damage
  > Fuel exhaustion due to the pilot’s inadequate fuel consumption calculations.
- [NTSB CHI08LA185](https://openairdocs.org/ntsb/CHI08LA185.md): Traxler John N Kitfox · Hartford, CT · Accident · No injuries · Limited investigation · Final report · Jul 8, 2008 · N767JD · Substantial damage
  > The pilot's failure to compensate for crosswinds resulting in a loss of directional control while landing. Contributing to the accident was the pilot's lack of experience and training in tailwheeled airplanes.
- [NTSB MIA08CA093](https://openairdocs.org/ntsb/MIA08CA093.md): Piper PA-28-235 · Ellington, CT · Accident · No injuries · Data collection · Final report · Apr 19, 2008 · N9117W · Substantial damage
  > The pilot's failure to perform a go-around when the airplane floated during landing.

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

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