# NTSB investigations, CT: Enroute

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.

Page 1 of 4 · 185 cases

## Latest cases

- [NTSB ERA26LA289](https://openairdocs.org/ntsb/ERA26LA289.md): Beech A36 · Weston, CT · Accident · No injuries · Class 4 · Limited · Final report · Jul 30, 2026 · N9144Q · Substantial damage
  > The in-flight opening of the engine cowling, which resulted in engine baffling separating from the airplane and impacting the right elevator.
- [NTSB ERA25LA215](https://openairdocs.org/ntsb/ERA25LA215.md): Piper PA32-300 · Branford, CT · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 1, 2025 · N2242Z · Substantial damage
  > Maintenance personnel's improper installation and inspection of the crankshaft gear bolt during major overhaul, which resulted in the crankshaft gear disengaging from the accessory gears which led to a total loss of engine power.
- [NTSB ERA25FA076](https://openairdocs.org/ntsb/ERA25FA076.md): Costruzioni Aeronautiche Tecnam P2008 · Greenwich, CT · Accident · 1 fatal · Class 3 · Field · Preliminary report · Dec 12, 2024 · N298PM · Substantial damage
  > On December 12, 2024, about 1846 eastern standard time, a Costruzioni Aeronautiche Tecnam P2008, N298PM, was substantially damaged when it was involved in an accident near Greenwich, Connecticut. The commercial pilot was fatally injured, and the private pilot…
- [NTSB ERA24LA241](https://openairdocs.org/ntsb/ERA24LA241.md): Cessna 172 · Terryville, CT · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 3, 2024 · N78445 · Substantial damage
  > A total loss of engine power for undetermined reasons.
- [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 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 ERA22LA264](https://openairdocs.org/ntsb/ERA22LA264.md): Cessna 208 · Ellington, CT · Accident · No injuries · Class 4 · Limited · Final report · Jun 4, 2022 · N90JF · Substantial damage
  > The pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion, an emergency landing, and runway excursion.
- [NTSB ERA17FA327](https://openairdocs.org/ntsb/ERA17FA327.md): Mooney M20C · North Branford, CT · Accident · 2 fatal · Field investigation · Final report · Sep 16, 2017 · N53CP · Substantial damage
  > A total loss of engine power due to fuel starvation as the result of foreign object debris in the fuel selector valve. Contributing to the accident was the pilot's selection of a low cruising altitude, which reduced the available time to troubleshoot the loss…
- [NTSB ERA17LA275](https://openairdocs.org/ntsb/ERA17LA275.md): Piper J3C · Salisbury, CT · Accident · Minor injuries · Limited investigation · Final report · Aug 13, 2017 · N98550 · Substantial damage
  > An improper replacement of the crankshaft by maintenance personnel, which resulted in a failure of the crankshaft gear and total loss of engine power.
- [NTSB DCA15CA136](https://openairdocs.org/ntsb/DCA15CA136.md): Boeing 777 - 236 · Windsor Locks, CT · Accident · Serious injuries · Data collection · Final report · May 27, 2015 · G-VIIY · No damage
  > an inadvertent encounter with convective turbulence resulting in serious injury to a flight attendant.
- [NTSB ERA15LA063](https://openairdocs.org/ntsb/ERA15LA063.md): Cessna 182 · Hartford, CT · Accident · No injuries · Limited investigation · Final report · Nov 29, 2014 · N759VG · Substantial damage
  > The partial loss of engine power during climb after takeoff for a reasons that could not be determined because postaccident engine examination revealed no evidence of mechanical malfunctions or failures.
- [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 ERA13LA408](https://openairdocs.org/ntsb/ERA13LA408.md): Piper PA-24-250 · Woodstock, CT · Accident · Minor injuries · Limited investigation · Final report · Sep 8, 2013 · N7333P · Substantial damage
  > The pilot’s improper preflight inspection, which resulted in fuel exhaustion and a total loss of engine power.
- [NTSB ERA11IA521](https://openairdocs.org/ntsb/ERA11IA521.md): Beech V35 · New Haven, CT · Incident · No injuries · Incident investigation · Final report · Sep 18, 2011 · N275BM · Minor damage
  > The in-flight fatigue failure of the engine’s crankshaft, which resulted in the separation of the forward portion of the crankshaft and the propeller.
- [NTSB ERA11FA334](https://openairdocs.org/ntsb/ERA11FA334.md): Piper PA-24-250 · Westbrook, CT · Accident · 1 fatal · Field investigation · Final report · Jun 10, 2011 · N8233P · Substantial damage
  > A total loss of engine power during approach due to inadequate torque on the No. 3 cylinder hold-down nuts.
- [NTSB ERA11IA320](https://openairdocs.org/ntsb/ERA11IA320.md): Robinson Helicopter R22 Mariner · Redding, CT · Incident · No injuries · Incident investigation · Final report · May 29, 2011 · N8313E · No damage
  > The pilot's inadequate helicopter preflight inspection and the mechanic’s inadequate annual inspection, both of which failed to detect a worn bolt in the tail rotor teeter hinge prior to its fracture due to fatigue.
- [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 NYC06LA219](https://openairdocs.org/ntsb/NYC06LA219.md): Beech F33A · South Windsor, CT · Accident · Minor injuries · Limited investigation · Final report · Sep 7, 2006 · N3708B · Substantial damage
  > A loosening of the fuel injector lines from the fuel manifold valve, which resulted in a partial loss of engine power.
- [NTSB NYC06CA056](https://openairdocs.org/ntsb/NYC06CA056.md): Piper PA-28-140 · East Killingly, CT · Accident · Serious injuries · Data collection · Final report · Jan 21, 2006 · N32729 · Substantial damage
  > The flight instructor's delayed decision to discontinue the simulated forced landing, which resulted in a collision with trees.
- [NTSB NYC05LA139](https://openairdocs.org/ntsb/NYC05LA139.md): Terrio Pober Jr Ace · Oxford, CT · Accident · No injuries · Limited investigation · Final report · Aug 27, 2005 · N37KT · Substantial damage
  > A fractured oil pressure line, which resulted in the fracture of the number 3 cylinder connecting rod bearing, and subsequent loss of engine power.
- [NTSB IAD05FA068](https://openairdocs.org/ntsb/IAD05FA068.md): Cessna R182 · New Fairfield, CT · Accident · 2 fatal · Field investigation · Final report · May 24, 2005 · N756PN · Destroyed
  > Failure of the aluminum-clad, number two connecting rod bearings, which resulted in a total loss of engine power. A factor was the relatively short forced landing area.
- [NTSB NYC05LA074](https://openairdocs.org/ntsb/NYC05LA074.md): Beech A36TC · Southbury, CT · Accident · Minor injuries · Limited investigation · Final report · Apr 20, 2005 · N3810X · Substantial damage
  > The failure of the counter weight aft snap ring to hold the associated plate and pin in place, which resulted in a total loss of engine power.
- [NTSB NYC05FA005](https://openairdocs.org/ntsb/NYC05FA005.md): Piper PA-28-161 · Madison, CT · Accident · 2 fatal · Field investigation · Final report · Oct 11, 2004 · N233PA · Substantial damage
  > A loss of engine power due to separation of the propeller due to under-torqued retention bolts.
- [NTSB IAD04FA025](https://openairdocs.org/ntsb/IAD04FA025.md): Robinson R-44 · Killingly, CT · Accident · 2 fatal · Field investigation · Final report · Jun 18, 2004 · N70144 · Destroyed
  > The pilot in command's intentional flight into instrument meteorological flight conditions, and his failure to maintain obstacle clearance which resulted in a controlled descent into trees. Factors included the pilot's inadequate weather evaluation, low cloud…
- [NTSB NYC04LA106](https://openairdocs.org/ntsb/NYC04LA106.md): Cessna 182S · Plainville, CT · Accident · No injuries · Limited investigation · Final report · Apr 9, 2004 · N518CR · Substantial damage
  > The failure of the elevator servo which resulted in restricted elevator movement and the pilot's inability to initiate a landing flare.
- [NTSB NYC03LA106](https://openairdocs.org/ntsb/NYC03LA106.md): Schweizer 269C · New Canaan, CT · Accident · Minor injuries · Limited investigation · Final report · May 15, 2003 · N109JS · Substantial damage
  > The inadequate annual inspection performed by maintenance facility personnel, which resulted in a failure of a fuel system bellcrank. Factors were the subsequent inadequate inspections by other maintenance personnel and the pilot.
- [NTSB IAD03FA024](https://openairdocs.org/ntsb/IAD03FA024.md): Piper PA-32R-301T · Woodbury, CT · Accident · 2 fatal · Field investigation · Final report · Dec 21, 2002 · N8168G · Destroyed
  > An engine fire for undetermined reasons, which resulted in the pilot's loss of control, and the airplane's subsequent impact with terrain.
- [NTSB NYC02LA169](https://openairdocs.org/ntsb/NYC02LA169.md): Bellanca 8GCBC · Guilford, CT · Accident · No injuries · Limited investigation · Final report · Aug 17, 2002 · N86714 · Substantial damage
  > Fatigue cracking of the number 3 cylinder head. A factor was the presence of protruding material on the cylinder barrel.
- [NTSB NYC02LA122](https://openairdocs.org/ntsb/NYC02LA122.md): Cessna 182B · Ellington, CT · Accident · No injuries · Limited investigation · Final report · Jun 24, 2002 · N2516G · Substantial damage
  > The pilot's misjudged distance/altitude during an emergency landing, which resulted in an undershoot and subsequent forced landing to a cornfield. A factor was the pilot's inadequate preflight planning, which resulted in fuel starvation.
- [NTSB NYC01LA194](https://openairdocs.org/ntsb/NYC01LA194.md): Piper PA-28-180 · New Milford, CT · Accident · Minor injuries · Limited investigation · Final report · Jul 31, 2001 · N55205 · Substantial damage
  > Separation of the number two connecting rod for reasons undetermined.
- [NTSB IAD01LA068](https://openairdocs.org/ntsb/IAD01LA068.md): Grumman American AA-5A · Danbury, CT · Accident · Minor injuries · Limited investigation · Final report · Jun 9, 2001 · N27221 · Substantial damage
  > the pilot's misjudged altitude and excessive airspeed resulting in a collision with a pole. A factor was the cracked exhaust stack, which resulted in a partial loss of engine power.
- [NTSB NYC01LA052](https://openairdocs.org/ntsb/NYC01LA052.md): Mooney M20J · Danbury, CT · Accident · Minor injuries · Limited investigation · Final report · Dec 5, 2000 · N4101H · Substantial damage
  > Water/ice in the fuel system and the pilot's inadequate preflight inspection.
- [NTSB IAD01LA016](https://openairdocs.org/ntsb/IAD01LA016.md): Bellanca BL-17-30A · Union, CT · Accident · Serious injuries · Limited investigation · Final report · Nov 24, 2000 · N280H · Substantial damage
  > pilot's mismanagement of the available fuel supply, which resulted in a loss of engine power due to fuel starvation.
- [NTSB NYC00IA131](https://openairdocs.org/ntsb/NYC00IA131.md): Beech BE-58 · Windsor Locks, CT · Incident · No injuries · Incident investigation · Final report · May 9, 2000 · N9044V · Minor damage
  > Inadequate screw length information provided by the manufacturer, which allowed an inadvertent installation of a holding screw that was too long, and the subsequent fracture of the switch/circuit breaker. Factors included a short circuit of the beacon motor,…
- [NTSB NYC00LA054](https://openairdocs.org/ntsb/NYC00LA054.md): Mooney 20J · New Milford, CT · Accident · No injuries · Limited investigation · Final report · Dec 17, 1999 · N43TP · Substantial damage
  > Failure of 3 of the 4 connecting rods for an undetermined reason.
- [NTSB NYC99LA112](https://openairdocs.org/ntsb/NYC99LA112.md): Abrams Titan Tornado · Monroe, CT · Accident · Serious injuries · Limited investigation · Final report · May 16, 1999 · N194PA · Substantial damage
  > The failure of the magneto (mag) cylinder bearing resulting in a total loss of power and subsequent forced landing.
- [NTSB NYC99LA102](https://openairdocs.org/ntsb/NYC99LA102.md): Glaser-Dirks DG-400 · New Milford, CT · Accident · Minor injuries · Limited investigation · Final report · May 1, 1999 · N400FJ · Destroyed
  > The manufacturer's use of inadequate adhesive material which resulted in the de-bonding and subsequent failure of the wing spar pin-lock assembly.
- [NTSB NYC99LA065](https://openairdocs.org/ntsb/NYC99LA065.md): Stinson 108-3 · Bristol, CT · Accident · No injuries · Limited investigation · Final report · Feb 21, 1999 · N6191M · Substantial damage
  > The partial loss of power due to the failure of a fatigued connecting rod bolt.
- [NTSB NYC99FA033](https://openairdocs.org/ntsb/NYC99FA033.md): Gulfstream American AA-1 · Brooklyn, CT · Accident · 1 fatal · Field investigation · Final report · Dec 4, 1998 · N6166L · Destroyed
  > The student pilot's failure to maintain control of the airplane, resulting in an inadvertent stall/spin.
- [NTSB IAD98FA072](https://openairdocs.org/ntsb/IAD98FA072.md): Cessna 172M · Hebron, CT · Accident · 1 fatal · Field investigation · Final report · Jun 22, 1998 · N12912 · Destroyed
  > The pilot's failure to obtain a weather briefing which resulted in inadvertent flight into instrument meteorological conditions, and his failure to maintain control of the airplane due to spatial disorientation. Factors in this accident were low ceilings and…
- [NTSB IAD98LA050](https://openairdocs.org/ntsb/IAD98LA050.md): McClead Varieze · Middlebury, CT · Accident · Minor injuries · Limited investigation · Final report · Apr 29, 1998 · N728RJ · Destroyed
  > the pilot's inadequate preflight when he did not secure the right wing fuel tank cap which led to fuel exhaustion.
- [NTSB NYC97LA032](https://openairdocs.org/ntsb/NYC97LA032.md): Cessna 172RG · Stamford, CT · Accident · Minor injuries · Limited investigation · Final report · Dec 21, 1996 · N4829V · Destroyed
  > inadequate preflight by the pilot, which resulted in fuel exhaustion, due to an inadequate fuel supply of fuel. Darkness and trees in the emergency landing area were related factors.
- [NTSB NYC96FA101](https://openairdocs.org/ntsb/NYC96FA101.md): Cessna P210N · Ridgefield, CT · Accident · 2 fatal · Field investigation · Final report · May 6, 1996 · N450T · Destroyed
  > improper planning/decision by the pilot, which led to flight into icing conditions; and his failure to use all anti-ice and deicing equipment, as specified by the airplane operator's manual for inadvertent flight into icing conditions. This resulted in loss…
- [NTSB IAD96FA057](https://openairdocs.org/ntsb/IAD96FA057.md): Cessna 172 · Barkhamsted, CT · Accident · 3 fatal · Field investigation · Final report · Apr 6, 1996 · N6234E · Destroyed
  > the CFI pilot/passenger's poor judgment which led to spatial disorientation and subsequent loss of control of the airplane. Factors involved in this accident were the night marginal visual flight conditions and continuing flight with a known nonfunctioning…
- [NTSB NYC94FA135](https://openairdocs.org/ntsb/NYC94FA135.md): Mooney M20C · Wallingford, CT · Accident · 2 fatal · Field investigation · Final report · Jul 24, 1994 · N6842N · Destroyed
  > the pilot's decision to exhaust the fuel supply in the selected tank in-flight, and his failure to maintain the minimum stall speed during engine out conditions. This resulted in a complete loss of engine power and the inadvertent stall and impact with the…
- [NTSB NYC94GA066](https://openairdocs.org/ntsb/NYC94GA066.md): Hughes 369A · Northford, CT · Accident · 1 fatal · Final report · Mar 19, 1994 · N97LC · Destroyed
  > The loss of engine power for undetermined reasons, and the pilot's failure to maintain rotor RPM during the forced landing autorotation, resulting in a loss of aircraft control and collision with trees. Also causal to the accident was the pilot's lack of…
- [NTSB BFO93LA067](https://openairdocs.org/ntsb/BFO93LA067.md): Piper PA-28RT-201 · Willimantic, CT · Accident · No injuries · Limited investigation · Final report · May 2, 1993 · N81529 · Substantial damage
  > Failure of the pilot to follow emergency procedures to ensure that the gear was locked. A factor related to the accident was the total electrical failure and the construction site located beside the runway.
- [NTSB NYC93LA006](https://openairdocs.org/ntsb/NYC93LA006.md): Smitrovich SE-5A Replica · Harwinton, CT · Accident · Minor injuries · Limited investigation · Final report · Oct 4, 1992 · N1869S · Substantial damage
  > A forced landing in unsuitable terrain, following a power loss due to fuel exhaution. Factors related to the accident were the failure of the pilot to refuel the airplane prior to departure and his improper fuel consumption calculations which led to fuel…
- [NTSB NYC92LA168](https://openairdocs.org/ntsb/NYC92LA168.md): Piper PA-38-112 · Salem, CT · Accident · Minor injuries · Limited investigation · Final report · Aug 19, 1992 · N2519B · Substantial damage
  > The pilot's inaccurate fuel calculations and his improper decision to takeoff with a known limited fuel supply resulting in fuel exhaustion and subsequent forced landing. Factors related to the accident were the pilot's lack of total flight experience and his…
- [NTSB NYC92LA152](https://openairdocs.org/ntsb/NYC92LA152.md): Cessna 210J · Groton, CT · Accident · Minor injuries · Limited investigation · Final report · Aug 9, 1992 · N6172F · Destroyed
  > A forced landing in unsuitable terrain as a result of a complete loss of engine power for unknown reasons.

Next page: https://openairdocs.org/ntsb-phases/400/cases.md?state=CT&page=2

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
  crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
  current_codes AS (
    SELECT e.case_mkey, TRY_CAST(e."tier1Number" AS INTEGER) AS code,
      row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e."isDefiningEvent", false) DESC, e.position) AS n
    FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
    WHERE e.aircrafts_position = 1 AND e."tier1Number" GLOB '[1-9][0-9]*'
      AND (e."isDefiningEvent" OR e.case_mkey IN (SELECT "mKey" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE "isPre1982"))
  ),
  phases AS (
    SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
    FROM current_codes WHERE n = 1
    UNION ALL
    SELECT o.case_mkey, 'older', o."phaseOfFlightCode", w.main
    FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o."phaseOfFlightCode"
    WHERE o.aircrafts_position = 1 AND o."occurrenceNumber" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
  ),
  case_phases AS (
    SELECT p.*, c."eventDate", c."highestInjuryLevel" = 'Fatal' AS fatal, a.aircraft_model_code
    FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = p.case_mkey
    LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
    WHERE c."eventDate" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
  )
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 case_mkey FROM case_phases WHERE main = 400)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/400/cases?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.