OpenAirDocs.org

NTSB investigations, CT

48 cases where the phase of flight was Maneuvering.

Cases per year

19652026

Where

Open the map

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.\"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 ERA17LA276Accident · Minor injuriesLimited investigationFinal reportBradley Roderick W Murphy Renegade · Guilford, CTA total loss of engine power for reasons that could not be determined based on the available evidence.Aug 14, 2017 · N210SQ · Substantial damageNTSB ERA17LA007Accident · Serious injuriesLimited investigationFinal reportJames Bruton Flying Flea · Plymouth, CTA partial loss of engine power for reasons that could not be determined based on the available information.Oct 6, 2016 · N83165 · Substantial damageNTSB NYC04LA052Accident · Serious injuriesLimited investigationFinal reportMorgan S-17 · Woodstock, CTThe uncertificated pilot's decision to perform a low altitude maneuver at an inadequate altitude, which resulted in an in-flight collision with trees.Dec 28, 2003 · NONE · Substantial damageNTSB 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 NYC02LA154Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Danbury, CTThe student pilot's failure to maintain airspeed and the flight instructor's delayed remedial action, which resulted in an inadvertent stall during a simulated forced landing. A factor was the rising terrain.Aug 5, 2002 · N89044 · Substantial damageNTSB NYC02TA029Accident · Minor injuriesFinal reportKaman K-1200 · Bloomfield, CTThe pilot's failure to maintain aircraft control while hovering. A factor related to the accident was the pilots lack of experience in type of aircraft.Nov 14, 2001 · N361KA · Substantial damageNTSB 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 IAD01LA106Accident · Serious injuriesLimited investigationFinal reportDigimas Starduster Too · Watertown, CTthe student pilot's inattention while maneuvering at low altitude, which resulted in collision with trees. A factor in the accident was the student pilot's intentional low-altitude maneuvering.Sep 23, 2001 · N49894 · Substantial damageNTSB 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 NYC99LA229Accident · No injuriesLimited investigationFinal reportCessna 305A · Warehouse Point, CTThe pilot's misjudgment of the clearance between the airplane and the banner loop during banner pickup.Sep 18, 1999 · N86WM · Substantial damageNTSB 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 NYC98LA192Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Watertown, CTWas the pilot's misjudged altitude of the airplane prior to performing a stall, and which resulted in the main landing gear contacting a rock wall.Sep 26, 1998 · N72929 · DestroyedNTSB IAD97LA106Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Willimantic, CTThe student pilot misunderstood the flight instructor's instructions and reduced the engine power to idle, and the Certificated Flight Instructor's delayed remedial action.Aug 6, 1997 · N717GT · Substantial damageNTSB NYC95LA135Accident · No injuriesLimited investigationFinal reportCessna 172M · Bridgewater, CTthe loss of engine power for undetermined reasons resulting in a forced landing, and a subsequent collision with trees.Jun 28, 1995 · N9176H · Substantial damageNTSB NYC93LA175Accident · No injuriesLimited investigationFinal reportEnstrom F28A · Meriden, CTThe loss of engine power for undetermined reasons.Aug 27, 1993 · N269Q · Substantial damageNTSB NYC93LA147Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Stonington, CTThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall/spin, and the pilot's improper use of the carburetor heat which resulted in the accretion of carburetor ice. A factor was carburetor icing conditions.Aug 11, 1993 · N98382 · Substantial damageNTSB 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 NYC91LA130Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Ellington, CTThe failure of the pilot to maintain directional control, and his inadequate compensation for winds, while maneuvering close to the ground. A factor relating to the accident was the adverse wind conditions.May 12, 1991 · N496TP · Substantial damageNTSB 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 NYC89LA049Accident · No injuriesLimited investigationFinal reportCessna 150L · Greenwich, CTTrees during an off airport landing after the aircraft expererienced a power loss fue to fuel starvation.Dec 12, 1988 · N6538G · 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 NYC87DNE01Accident · Serious injuriesFinal reportKosch Whitehead #21 · Stratford, CTThe experimental aircraft was making taxi tests on an abandoned taxiway when it became airborne. A photographer rushed out from a marked safety area directly in the flight path of the aircraft and was struck by the aircraft receiving a broken arm. The…Dec 29, 1986 · N1901G · Minor damageNTSB 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 NYC84FNE06Accident · Minor injuriesFinal reportBell 206L-1 · Somers, CTPlt stated acft began to settle and roll to right from stable 3 foot hover. Application of left cyclic did not arrest roll and main rotor made ground contact. Plt had 11 hrs in this make & model.Sep 17, 1984 · N2088V · Substantial damageNTSB 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 NYC80FNE23Accident · Serious injuriesClosedCessna 152 · Berlin, CTJul 19, 1980 · N24976 · DestroyedNTSB NYC80FNE11Accident · No injuriesClosedRobinson R-22 · Rocky Hill, CTMar 17, 1980 · N9017Z · Substantial damageNTSB NYC79FA104Accident · 1 fatalClosedCessna 172D · Greenwich, CTSep 20, 1979 · N2331U · DestroyedNTSB NYC76AN110Accident · 1 fatalClosedPiper PA-22 · Harwinton, CTJul 9, 1976 · N9981D · DestroyedNTSB NYC76FNE01Accident · Minor injuriesClosedPiper J-3 · Canaan, CTJul 12, 1975 · N24881 · Substantial damageNTSB NYC74FNE21Accident · Serious injuriesClosedCessna 150L · Ashford, CTApr 26, 1974 · N5358Q · DestroyedNTSB NYC74AN052Accident · 2 fatalClosedBeech G35 · Chaplin, CTDec 8, 1973 · N118B · DestroyedNTSB NYC72FNE13Accident · Minor injuriesClosedPiper J3C-65 · Durham, CTSep 29, 1971 · N88179 · Substantial damageNTSB NYC71FNE37Accident · 1 fatalClosedB.Jungmistr BU-133 · Plainville, CTJun 6, 1971 · N4767 · DestroyedNTSB NYC70DFM16Accident · No injuriesClosedBell 47G2 · Danbury, CTJun 8, 1970 · N5193B · Substantial damageNTSB 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 · DestroyedNTSB NYC65A0097Accident · Minor injuriesClosedSikorsky S61N · Stratford, CTJan 21, 1965 · N92866 · Substantial damage