# NTSB investigations, CT: Standing

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 ERA23LA315](https://openairdocs.org/ntsb/ERA23LA315.md): Head Balloons AX8-88 · Guilford, CT · Accident · Serious injuries · Class 4 · Limited · Final report · Jul 24, 2023 · N4522E · No damage
  > The pilot’s inadequate supervision of the boarding process and the ground crewmember’s failure to immediately let go of the balloon after it began an inadvertent climb.
- [NTSB GAA19CA091](https://openairdocs.org/ntsb/GAA19CA091.md): Zlin Z143 · Chester, CT · Accident · No injuries · Data collection · Final report · Dec 10, 2018 · N143GW · Substantial damage
  > The pilot's loss of airplane control during the engine start.
- [NTSB ERA14CA314](https://openairdocs.org/ntsb/ERA14CA314.md): Cessna 172L · Danbury, CT · Accident · No injuries · Data collection · Final report · Jun 28, 2014 · N7867G · Substantial damage
  > The pilot's use of a person unfamiliar with aviation and his failure to properly secure the airplane during hand starting of the engine.
- [NTSB NYC93LA060](https://openairdocs.org/ntsb/NYC93LA060.md): Piper PA-28-161 · Danbury, CT · Accident · No injuries · Limited investigation · Final report · Feb 3, 1993 · N233PA · Substantial damage
  > The pilot's improper emergency procedures for an engine fire during starting which resulted in the substantial damage. Factors related to the accident were the pilot's improper starting procedure and his lack of total experience.
- [NTSB NYC92LA005](https://openairdocs.org/ntsb/NYC92LA005.md): Aerospatiale ATR-42-320 · Bridgeport, CT · Accident · 1 fatal · Limited investigation · Final report · Oct 12, 1991 · N25811 · Minor damage
  > The employee's failure to follow proper procedures and the diversion of her attention which resulted in her being struck by a spinning propeller.
- [NTSB NYC90LA056](https://openairdocs.org/ntsb/NYC90LA056.md): Cessna 172 · Danbury, CT · Accident · Serious injuries · Limited investigation · Final report · Jan 16, 1990 · N9093H · Destroyed
  > Improper maintenance, inadequate surveillance by the company/operator, and inadequate preflight by the pilot, which resulted in a fire during an attempted engine start. A factor related to the accident was: the unsecured fuel line.
- [NTSB NYC88LA130](https://openairdocs.org/ntsb/NYC88LA130.md): Beech 35 · New Haven, CT · Accident · No injuries · Limited investigation · Final report · Apr 25, 1988 · N4528V · Substantial damage
  > During engine start the throttle jammed in the full forward position and could not be pulled back to the idle position to retard the power. The aircraft started rolling and collided with an unoccupied parked aircraft. Examination of the throttle control…
- [NTSB NYC87LA266](https://openairdocs.org/ntsb/NYC87LA266.md): Cessna 152 · Bridgeport, CT · Accident · No injuries · Limited investigation · Final report · Sep 29, 1987 · N93193 · Substantial damage
  > The plt of Cessna 152, N93193, taxied for takeoff with the intentions of using rwy 24. At about the same time, a navy H-53 (Sikorsky) helicopter entered a pattern to land on rwy 24. With the heavy helicopter apchg to land, the Cessna plt accepted an offer to…
- [NTSB NYC84LA021](https://openairdocs.org/ntsb/NYC84LA021.md): Piper PA-28-181 · New Milford, CT · Accident · No injuries · Limited investigation · Final report · Nov 4, 1983 · N2222R · Destroyed
  > The pilot reported that as he was starting the engine, fire broke out. He attempted to put out the fire with on-board extinguishers, but failed. The acft was destroyed by fire.
- [NTSB NYC74FNE20](https://openairdocs.org/ntsb/NYC74FNE20.md): Enstrom F-28A · East Putman, CT · Accident · No injuries · Closed · Apr 21, 1974 · N4895 · Destroyed
- [NTSB NYC70AN096](https://openairdocs.org/ntsb/NYC70AN096.md): Dehavilland DHC-6 · Windsor Lock, CT · Accident · No injuries · Closed · Mar 6, 1970 · N121PM · Substantial damage
- [NTSB NYC66F0501](https://openairdocs.org/ntsb/NYC66F0501.md): Beechcraft S35 · Windsor Locks, CT · Accident · No injuries · Closed · Feb 26, 1966 · N2021W · Substantial damage

## 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 = 150)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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