# Major NTSB investigations, 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 ERA20MA001](https://openairdocs.org/ntsb/ERA20MA001.md): Boeing B17 · Windsor Locks, CT · Accident · 7 fatal · Class 2 · Major · Final report · Oct 2, 2019 · N93012 · Destroyed
  > The pilot’s failure to properly manage the airplane’s configuration and airspeed after he shut down the No. 4 engine following its partial loss of power during the initial climb. Contributing to the accident was the pilot/maintenance director’s inadequate…
- [NTSB DCA96MA008](https://openairdocs.org/ntsb/DCA96MA008.md): McDonnell Douglas MD-83 · East Granby, CT · Accident · Minor injuries · Class 1 · Major · Final report · Nov 12, 1995 · N566AA · Substantial damage
  > the flightcrew's failure to maintain the required minimum descent altitude until the required visual references identifiable with the runway were in sight. Contributing factors were the failure of the BDL approach controller to furnish the flightcrew with a…
- [NTSB DCA94MA053](https://openairdocs.org/ntsb/DCA94MA053.md): Piper PA31 · Stratford, CT · Accident · 8 fatal · Class 1 · Major · Final report · Apr 28, 1994 · N990RA · Destroyed
  > The failure of the captain to use the available ILS glideslope, his failure to execute a go-around when conditions were not suitable for landing, and his failure to land the airplane at a point sufficient to allow for a safe stopping distance; the fatalities…
- [NTSB DCA84AA027](https://openairdocs.org/ntsb/DCA84AA027.md): Learjet 23A · Windsor Locks, CT · Accident · 3 fatal · Final report · Jun 5, 1984 · N101PP · Destroyed
  > According to witnesses, the acft made a normal apch to rwy 33 with no apparent abnormalities. However, when it was about 200 ft over the apch lights, they heard an increase in the eng thrust & the acft's descent stopped. Two plt witnesses thought the aircrew…
- [NTSB NYC70AN086](https://openairdocs.org/ntsb/NYC70AN086.md): Dehavilland DHC-6 · Waterford, CT · Accident · 5 fatal · Closed · Feb 10, 1970 · N124PM · Substantial damage

## 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.board_report_url IS NOT NULL OR c."investigationClass" = 'Class 1' OR c."caseType" = 'Major - Launch')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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