# NTSB investigations, CT: Miscellaneous/other

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 NYC99LA229](https://openairdocs.org/ntsb/NYC99LA229.md): Cessna 305A · Warehouse Point, CT · Accident · No injuries · Limited investigation · Final report · Sep 18, 1999 · N86WM · Substantial damage
  > The pilot's misjudgment of the clearance between the airplane and the banner loop during banner pickup.
- [NTSB NYC87DNE04](https://openairdocs.org/ntsb/NYC87DNE04.md): Piper PA-28-180 · Groton, CT · Accident · 1 fatal · Final report · Jul 27, 1987 · N9558J · Substantial damage
  > Shortly after the aircraft departed the airport, air traffic control personnel received a distress call from the non-pilot rated passenger. She stated that the pilot (her husband) was incapacitated by an apparent heart attack and she was not qualified to fly…
- [NTSB NYC85LA101](https://openairdocs.org/ntsb/NYC85LA101.md): Beech B-35 · East Haddam, CT · Accident · No injuries · Limited investigation · Final report · Apr 5, 1985 · N3082V · Substantial damage
  > The acft stalled and contacted sandy terrain aprx 50 ft from the rwy threshold. The plt reported the cabin door opened during takeoff and he circled the traffic pattern to land and close the door. He stated an airspeed of 100 KTS was observed on a 1 mile…
- [NTSB NYC82DA109](https://openairdocs.org/ntsb/NYC82DA109.md): Robinson R-22 · Danbury, CT · Accident · No injuries · Final report · May 27, 1982 · N9072Q · Substantial damage
  > During a practice autorotation, just prior to flare, a loud noise was heard and the pilot stated that the aircraft veered to the right. A partial flare was made and after making contact with the ground the helicoper bounced back into the air. The rotor blades…
- [NTSB NYC82DA106](https://openairdocs.org/ntsb/NYC82DA106.md): Schleicher ASW-15 · Plymouth, CT · Accident · No injuries · Final report · May 26, 1982 · N77BZ · Substantial damage
  > The pilot stated that he thought he heard the rudder pedals click into their detented/locked position when they were adjusted before takeoff. However, while being towed for takeoff, the rudder pedals slipped forward about 1 to 2 inches. The pilot reached down…

## 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 430)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?occurrence=430&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.