Fatal NTSB investigations, CT

54 cases where the phase of flight was Enroute.

Cases per year

19622026
Fatal NTSB investigations, CT per year, 1962–2026: 54 cases
19621
19651
19663
19671
19691
19703
19711
19722
19731
19742
19755
19762
19772
19783
19791
19802
19831
19843
19872
19881
19911
19921
19942
19962
19982
20021
20042
20051
20111
20171
20231
20241

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 = 400)
  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 ERA25FA076Accident · 1 fatalClass 3 · FieldFinal reportCostruzioni Aeronautiche Tecnam P2008 · Greenwich, CTA total loss of engine power due to water-contaminated fuel, and the pilots’ inadequate preflight inspection. Contributing to the water contamination were the missing o-ring or packing and damage to the left fuel cap, and the undetected improperly sealed…Dec 12, 2024 · N298PM · Substantial damageNTSB ERA23LA135Accident · 1 fatalClass 2 · LimitedFinal reportBombardier BD-100-1A10 · Windsor Locks, CTThe 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…Mar 3, 2023 · N300ER · Minor damageNTSB ERA17FA327Accident · 2 fatalField investigationFinal reportMooney M20C · North Branford, CTA 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…Sep 16, 2017 · N53CP · Substantial damageNTSB ERA11FA334Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Westbrook, CTA total loss of engine power during approach due to inadequate torque on the No. 3 cylinder hold-down nuts.Jun 10, 2011 · N8233P · Substantial damageNTSB IAD05FA068Accident · 2 fatalField investigationFinal reportCessna R182 · New Fairfield, CTFailure 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.May 24, 2005 · N756PN · DestroyedNTSB NYC05FA005Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Madison, CTA loss of engine power due to separation of the propeller due to under-torqued retention bolts.Oct 11, 2004 · N233PA · Substantial damageNTSB IAD04FA025Accident · 2 fatalField investigationFinal reportRobinson R-44 · Killingly, CTThe 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…Jun 18, 2004 · N70144 · DestroyedNTSB IAD03FA024Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Woodbury, CTAn engine fire for undetermined reasons, which resulted in the pilot's loss of control, and the airplane's subsequent impact with terrain.Dec 21, 2002 · N8168G · DestroyedNTSB NYC99FA033Accident · 1 fatalField investigationFinal reportGulfstream American AA-1 · Brooklyn, CTThe student pilot's failure to maintain control of the airplane, resulting in an inadvertent stall/spin.Dec 4, 1998 · N6166L · DestroyedNTSB IAD98FA072Accident · 1 fatalField investigationFinal reportCessna 172M · Hebron, CTThe 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…Jun 22, 1998 · N12912 · DestroyedNTSB NYC96FA101Accident · 2 fatalField investigationFinal reportCessna P210N · Ridgefield, CTimproper 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…May 6, 1996 · N450T · DestroyedNTSB IAD96FA057Accident · 3 fatalField investigationFinal reportCessna 172 · Barkhamsted, CTthe 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…Apr 6, 1996 · N6234E · DestroyedNTSB NYC94FA135Accident · 2 fatalField investigationFinal reportMooney M20C · Wallingford, CTthe 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…Jul 24, 1994 · N6842N · DestroyedNTSB NYC94GA066Accident · 1 fatalFinal reportHughes 369A · Northford, CTThe 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…Mar 19, 1994 · N97LC · DestroyedNTSB NYC92FA090Accident · 1 fatalField investigationFinal reportBeech A36 · Southbury, CTThe failure of the pilot to monitor his fuel supply which resulted in a power loss due to fuel exhaustion and an inadvertent stall/spin as the pilot was maneuvering for a forced landing. Factors related to the accident was improper maintenance on the fuel…May 5, 1992 · N36MR · DestroyedNTSB NYC91FA095Accident · 2 fatalField investigationFinal reportCessna 120 · Simsbury, CTThe pilot's intentional flight into terrain. Contributing to the accident were psychological conditions.Mar 21, 1991 · N4117N · DestroyedNTSB NYC88FA229Accident · 4 fatalField investigationFinal reportPiper PA-28R-201 · Pomfret, CTThe Piper arrow PA-28R-201, had asked ATC for vectors to windam airport. After being vectored the pilot requested his distance from the airport. He was told that he was 12 miles from the airport, the pilot then decided to descend. ATC advised the pilot to…Aug 28, 1988 · N3478M · DestroyedNTSB NYC87FA250Accident · 1 fatalField investigationFinal reportPiper PA-28-236 · Gaylordsville, CTThe pilot of the Piper PA-28-236 was cruising at 6000 ft at night when he reported a failure of his vacuum pump followed by loss of his attitude indicator and directional gyro. The aircraft was observed to make a 360 degree turn on the radar scope. The air…Sep 12, 1987 · N2186B · DestroyedNTSB NYC87DNE04Accident · 1 fatalFinal reportPiper PA-28-180 · Groton, CTShortly after the aircraft departed the airport, air traffic control personnel received a distress call from the non-pilot rated passenger. She stated that the pilot (her husband) was incapacitated by an apparent heart attack and she was not qualified to fly…Jul 27, 1987 · N9558J · Substantial damageNTSB NYC85FA048Accident · 2 fatalField investigationFinal reportRobinson R-22-A · Ellington, CTThe non-inst rated plt continued flt into IMC conditions in a helicopter which was not equipped for flt on instruments. There is no record or witnesses of the plt having received a formal wx briefing but it is reported that the plt was informed of fog moving…Dec 22, 1984 · N84958 · DestroyedNTSB NYC84FA295Accident · 1 fatalField investigationFinal reportAero Commander 680V · Bridgeport, CTThe acft descended into the water six & 1/2 miles sw of Bridgeport, CT. The acft was on an ILS apch to rwy 06. The acft was in communication with NY TRACON arrvl radar and on his initial call had indicated a desire for a clearance direct tobridgeport. A brief…Sep 4, 1984 · N100CT · DestroyedNTSB DCA84AA022Accident · 1 fatalFinal reportMitsubishi MU-2B-60 · Burlington, CTThe acft was flown earlier in the day for a sales demonstration. On the return flt, when the landing gear were lowered, the plt thought he heard a noise emitting from the gear, although cockpit indications were normal. The acft landed at johnnycake arpt & was…Apr 20, 1984 · N466MA · DestroyedNTSB NYC83FA121Accident · 1 fatalField investigationFinal reportMooney M-20K · Old Lyme, CTThe acft collided with the ground in IMC after the plt reported he lost his vacuum instruments. The flt originated at mattituck, NY with a destination of lebanon, NH. After departure the plt was cleared to climb to 7000 ft. the instrumentrated pilot was on an…May 20, 1983 · N231HT · DestroyedNTSB NYC81FAMS1Accident · 4 fatalClosedPiper PA-31 · Bridgeport, CTNov 10, 1980 · N62987 · DestroyedNTSB NYC80FA068Accident · 3 fatalClosedCessna 172 · Burlington, CTAug 11, 1980 · N737AD · DestroyedNTSB NYC8OFA001Accident · 1 fatalClosedPiper PA-23 · Ashford, CTSep 30, 1979 · N1267P · DestroyedNTSB NYC79FA015Accident · 3 fatalClosedBeech C55 · Enfield, CTDec 7, 1978 · N82V · DestroyedNTSB NYC78FA063Accident · 1 fatalClosedBeech 95 · Waterford, CTJun 8, 1978 · N2714Y · Substantial damageNTSB NYC78FA027Accident · 1 fatalClosedPiper PA-32R · Danbury, CTFeb 10, 1978 · N47574 · DestroyedNTSB NYC77FA090Accident · 2 fatalClosedPiper PA-28R · Greenwich, CTAug 31, 1977 · N3960X · DestroyedNTSB NYC77FA078Accident · 2 fatalClosedBeagle B.206S · Westport, CTAug 11, 1977 · N850EX · DestroyedNTSB NYC76FNE30Accident · 1 fatalClosedSchweizer SGS126 · Watertown, CTJul 5, 1976 · N2646H · DestroyedNTSB NYC76AN073Accident · 2 fatalClosedCessna 150 · Bridgeport, CTFeb 4, 1976 · N248Q · DestroyedNTSB NYC76AN023Accident · 1 fatalClosedCessna 172M · Stamford, CTAug 17, 1975 · N22234 · DestroyedNTSB NYC75AN112Accident · 2 fatalClosedBeech A45 · Southport, CTMay 29, 1975 · N1061X · DestroyedNTSB NYC75AN095Accident · 2 fatalClosedBell 206B · Shelton, CTMar 25, 1975 · N83176 · DestroyedNTSB NYC75AN082Accident · 1 fatalClosedBell 206A · Milford, CTFeb 1, 1975 · N4726R · DestroyedNTSB NYC75AN079Accident · 1 fatalClosedPiper PA-23 · Stratford, CTJan 10, 1975 · N4322Y · Substantial damageNTSB NYC75FNE17Accident · 1 fatalClosedSchriever Trpedo · Chesire, CTOct 19, 1974 · N73697 · DestroyedNTSB NYC75AN030Accident · 3 fatalClosedAmer Avco AA-5 · Roxbury, CTSep 1, 1974 · N7114L · DestroyedNTSB NYC73AN002Accident · 3 fatalClosedPiper PA-28 · Tolland, CTJul 4, 1973 · N4470T · DestroyedNTSB NYC73AN022Accident · 1 fatalClosedRobertson 182K · Orange, CTAug 2, 1972 · N2676R · DestroyedNTSB NYC72AN128Accident · 1 fatalClosedCessna 185 · Tariffville, CTApr 13, 1972 · N5854T · DestroyedNTSB NYC72AN081Accident · 3 fatalClosedCessna 170 · Woodstock, CTDec 12, 1971 · N4016V · Substantial damageNTSB NYC71AN068Accident · 2 fatalClosedPiper PA-28 · Sharon, CTDec 6, 1970 · N8625W · DestroyedNTSB NYC71AN038Accident · 2 fatalClosedCessna 337D · Lakeville, CTSep 18, 1970 · N337NH · DestroyedNTSB NYC71AN031Accident · 2 fatalClosedNardi FN-333 · Shelton, CTAug 30, 1970 · N917NS · DestroyedNTSB NYC69A0111Accident · 9 fatalClosedPiper PA-23 · Waterford, CTJun 14, 1969 · N4101P · 2 aircraft · DestroyedNTSB NYC67A0170Accident · 1 fatalClosedPiper PA-18S · Westbrook, CTMay 28, 1967 · N3901Z · DestroyedNTSB NYC67A0092Accident · 2 fatalClosedPiper PA-18 · North Canaan, CTDec 11, 1966 · N3697Z · 2 aircraft · Destroyed