Fatal NTSB investigations, CT

25 cases where the phase of flight was Maneuvering.

Cases per year

19662026
Fatal NTSB investigations, CT per year, 1966–2026: 25 cases
19661
19671
19701
19711
19731
19761
19791
19811
19831
19841
19851
19871
19893
19902
19913
19921
19991
20012
20031

Latest cases

Query with SQL
duckdb -csv -c "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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 450)
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB NYC03FA173Accident · 2 fatalField investigationFinal reportLearjet 35A · Groton, CTThe first officer's inadvertent retraction of the flaps during the low altitude maneuvering, which resulted in the inadvertent stall and subsequent in-flight collision with a residential home. Factors in the accident were the captain's decision to perform a…Aug 4, 2003 · N135PT · DestroyedNTSB NYC02FA009Accident · 1 fatalField investigationFinal reportCessna 152 · Middlefield, CTThe pilot's failure to maintain sufficient altitude while maneuvering, which resulted in a collision with terrain. Factors in the accident were the dark night, rising terrain, and clouds.Oct 14, 2001 · N94567 · DestroyedNTSB NYC01LA224Accident · 1 fatalLimited investigationFinal reportYakovlev YAK-52 · Washington, CTThe pilot's failure to maintain aircraft control. Factors in the accident were the dark night, reduced visibility, and the pilot's decision to conduct VFR operations at night in adverse weather conditions.Sep 11, 2001 · N1189N · DestroyedNTSB NYC99FA097Accident · 1 fatalField investigationFinal reportIves Sonerai II-L · Eastford, CTInadequate welding of the airplane's spar-box by the owner/builder, which resulted in a total spar-box failure in-flight. A factor in the accident was the pilot's decision to perform aerobatics.Apr 25, 1999 · N56RA · DestroyedNTSB BFO92FA141Accident · 1 fatalField investigationFinal reportChampion 7KCAB · East Haddam, CTThe pilot's decision to attempt an aerobatic maneuver without adequate altitude for recovery.Sep 14, 1992 · N561EK · DestroyedNTSB NYC92FA052Accident · 2 fatalField investigationFinal reportAeronca 7AC · Salisbury, CTThe pilot's failure to maintain airspeed while performing low altitude aerobatic maneuvers, resulting in a stall with insufficient altitude to recover. Factors related to the accident were the pilot's overconfidence in his ability to perform these maneuvers,…Dec 28, 1991 · N3103E · DestroyedNTSB NYC91FA174Accident · 3 fatalField investigationFinal reportGulfstream American AA5B · Columbia, CTThe decision of the pilot to continue flight into instrument meteorological conditions, which resulted in an in flight collision with trees. Factors related to the accident were the pilot's lack of instrument flight expereince, his overconfidence in his…Jul 8, 1991 · N43ER · DestroyedNTSB NYC91FA145Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Wallingford, CTThe pilot attempting a VFR flight in adverse weather conditions, at an altitude that was insufficient to clear trees along his route of flight. Factors related to the accident were the pilot's lack of instrument rating, and his overconfidence to fly in…May 31, 1991 · N36069 · DestroyedNTSB NYC90LA143Accident · 1 fatalLimited investigationFinal reportBoeing A75L3 · Groton, CTAn impact with the ground following an improperly executed roll with insufficient altitude for recovery. Factors related to the accident were improper use of the flight controls by the pilot.Jun 30, 1990 · N1205V · Substantial damageNTSB NYC90FA063Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Fairfield, CTThe intoxicated pilot's failure to attain/maintain a safe altitude to provide clearance from the tree.Feb 1, 1990 · N83253 · DestroyedNTSB NYC90FA036Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Coventry, CTThe non-instrument rated pilot initiating VFR flight into IMC on a dark night which resulted in spatial disorientation and uncontrolled flight into the ground. Contributing factor(s) was: the adverse weather existing at the time of the accident and the…Nov 28, 1989 · N3309W · DestroyedNTSB NYC90FA011Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Glastonbury, CTThe pilot-in-command's failure to maintain adequate altitude control during maneuvering flight. Contributing to the accident was the failure of the airplane's electrical system and the pilot's operation at night, without emergency lighting (flashlight).Oct 11, 1989 · N4106W · Substantial damageNTSB NYC89DNE02Accident · 1 fatalFinal reportSmith Mini DSA-1 · Sterling, CTThe pilot's failure to maintain control of the experimental aircraft while performing aerobatic maneuvers, and the aircraft's resultant uncontrolled descent into the ground.May 12, 1989 · N21H · Substantial damageNTSB NYC87FA252Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · East Granby, CTThe pilot departed simsbury airport on a x-country flight and crashed 4.5 miles to the north in bradley intl airport traffic area. Witnesses in the crash site area saw an aircraft flying in and out of clouds prior to hearing the crash.Sep 12, 1987 · N670FL · DestroyedNTSB NYC86FA037Accident · 2 fatalField investigationFinal reportBell 206B · Cheshire, CTThe helicopter was flying at or near the base of the overcast when it contacted a tree and descended to ground impact. Witnesses reported hearing the eng operating during the accident sequence and the area was covered with heavy fog. No mechanical malfunction…Nov 20, 1985 · N5828J · DestroyedNTSB NYC84FA307Accident · 4 fatalField investigationFinal reportBell 206B · Wallingford, CTThe acft collided with wires after the plt announced by radio that he was going to make a low pass over the site of an outdoor event that he had just attended. Some witnesses saw the helicopter flying extremely low. It appeared that one of the landing skid…Sep 8, 1984 · N4FL · DestroyedNTSB NYC83FNE03Accident · 1 fatalFinal reportBellanca 8KCAB · Madison, CTThe acft collided with the ground while performing aerobatic maneuvers during an airshow. Witnesses said it appeared that the pilot was having trouble staying in the assigned area for the maneuvers because of high winds. The winds were estimated at 20 KTS…Jun 25, 1983 · N2979T · DestroyedNTSB NYC81FA079Accident · 2 fatalClosedRobinson R-22 · Granby, CTAug 31, 1981 · N9056D · DestroyedNTSB NYC79FA104Accident · 1 fatalClosedCessna 172D · Greenwich, CTSep 20, 1979 · N2331U · DestroyedNTSB NYC76AN110Accident · 1 fatalClosedPiper PA-22 · Harwinton, CTJul 9, 1976 · N9981D · DestroyedNTSB NYC74AN052Accident · 2 fatalClosedBeech G35 · Chaplin, CTDec 8, 1973 · N118B · DestroyedNTSB NYC71FNE37Accident · 1 fatalClosedB.Jungmistr BU-133 · Plainville, CTJun 6, 1971 · N4767 · DestroyedNTSB NYC70AN100Accident · 2 fatalClosedCessna 172A · N.Branford, CTMar 15, 1970 · N7796T · DestroyedNTSB NYC68A0023Accident · 4 fatalClosedCessna 182K · Trumbull, CTAug 4, 1967 · N3025Q · DestroyedNTSB NYC67A0078Accident · 1 fatalClosedCessna 172G · Greenwich, CTNov 10, 1966 · N4194L · Destroyed