NTSB investigations, CT

185 cases where the phase of flight was Enroute.

Cases, newest first

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 = 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 BFO92LA112Accident · No injuriesLimited investigationFinal reportJames Snyder Challenger II · Burlington, CTThe loss of engine power for undetermined reasons.Jul 22, 1992 · N602CH · Substantial damageNTSB BFO92LA090Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Woodstock, CTThe loss of engine power due to a cracked cylinder and the inadvertent aerodynamic stall that occurred during the precuationary landing.Jul 7, 1992 · N68215 · Substantial damageNTSB 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 NYC92LA038Accident · No injuriesLimited investigationFinal reportCessna 152 · Danbury, CTThe student pilot's improper preflight and planning which resulted in fuel system exhaustion and a forced landing on unsuitable terrain. A factor related to the accident was the pilot's lack of total experience.Nov 28, 1991 · N25262 · Substantial damageNTSB 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 NYC90LA026Accident · No injuriesLimited investigationFinal reportBeech A24R · Bridgeport, CTThe airplane engine throttle cable failed and the engine power reduced to idle over long island sound, resulting in the ditching of the airplane.Nov 12, 1989 · N24569 · Substantial damageNTSB NYC90LA008Accident · No injuriesLimited investigationFinal reportCessna 150 · Madison, CTA loss of engine power, due to a stuck exhaust valve in the number 4 cylinder. Factors related to the accident were: the pilot's excessive airspeed on final approach, and his failure to attain the proper touchdown point during the landing.Oct 9, 1989 · N50165 · Substantial damageNTSB NYC89LA151Accident · No injuriesLimited investigationFinal reportErcoupe Ercoupe 415C · Canaan, CTAn off airport landing in unsuitable terrain due to a power loss, caused by loose parts in the fuel pump.Jun 20, 1989 · N93765 · Substantial damageNTSB NYC89LA050Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Lyme, CTImproper planning; the student pilot became lost and ran out of fuel. During the landing he misjudged distance, altitude and airspeed and overran the field colliding with trees.Dec 16, 1988 · N63136 · Substantial damageNTSB NYC89FA013Accident · Serious injuriesField investigationFinal reportBell 206L-1 · Wallingford, CTThe acft lost power and crashed in a tractor trailer parking lot, destroying the helicopter and causing serious injuries to the pilot and one passenger. The investigation revealed an improper fuel flow switch, which had no check valve protection installed on…Oct 16, 1988 · N555GC · 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 NYC88LA031Accident · No injuriesLimited investigationFinal reportCessna 172 · Stamford, CTThe instructor (CFI) reported that the aircraft had just reached the top of a climb at 2500 ft when the engine lost power. An off airport landing was made on a golf course. During the landing, the wings struck trees and the aircraft was damaged. The golf…Nov 5, 1987 · N9538L · Substantial damageNTSB 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 NYC87DNE03Accident · No injuriesFinal reportNoble Falcon X-P · Wallingford, CTThe undetermined loss of engine power, and the pilot's poor aircraft handling during the resultant forced landing.Jul 5, 1987 · N62JC · Substantial damageNTSB NYC87LA074Accident · No injuriesLimited investigationFinal reportCessna 152C · Washington, CTThe flight departed newport state airport, newport, rhode island on a student solo cross country enroute to waterbury, Connecticut. While over Washington, Connecticut, the aircraft began losing rpms and altitude. The acft was substantially damaged during the…Feb 2, 1987 · N757TZ · Substantial damageNTSB NYC86LA208Accident · Serious injuriesLimited investigationFinal reportBeech C24R · Hartford, CTThe Beech 24R pilot noticed a build-up of a substance on the windshield. He also experienced a problem controlling the propeller. He said upon landing he could not judge forward visibility and flared high (30-40 ft). The pilot reported that the aircraft…Aug 2, 1986 · N6637E · No damageNTSB NYC86LA171Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Barkhanstead, CTThe flight took off with about seven gallons of fuel with a slight tailwind. But after about 30 minutes of flight the flight encountered a headwind. The aircraft suffered fuel exhaustion and the pilot executed a precautionary landing in a field. During ground…Jun 20, 1986 · N1166B · Substantial damageNTSB NYC86LA146Accident · No injuriesLimited investigationFinal reportCessna 152 · Middletown, CTThe student pilot was on the third leg of an approved three leg cross country solo flight. He was instructed to refuel at the second stop. However, he made a decision not to refuel since the fuel tanks indicated about 1/2 full. The aircraft ran out of fuel…Jun 3, 1986 · N31SD · Substantial damageNTSB NYC86LA072Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Naugatuck, CTA student pilot preflighted Cessna 150, departed the airport and performed a few touch and go landings before leaving the area and following the merrit parkway in Connecticut. The pilot stated that the engine was not running smooth. The pilot landed at cross…Feb 4, 1986 · N6007G · Substantial damageNTSB NYC86LA051Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Bristol, CTThe acft was on a return flight back to teterboro when an eng failure occurred for unknown reasons. The plt requested vectors to the nearest arpt which was robertson but he was not able to reach it. A forced landing resulted in an open fld during which the…Dec 21, 1985 · N61260 · Substantial damageNTSB NYC85LA179Accident · No injuriesLimited investigationFinal reportCessna 152 · W.Stafford, CTThe plt stated that shortly after takeoff upon reaching an alt of 3000 ft, the eng pwr dropped to 1000 RPM with the prop windmilling. He then went through the restart procedure to no avail. The plt then performed an eng shut down and force landed the acft in…Jul 17, 1985 · N89856 · 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 NYC84FNE05Accident · Serious injuriesFinal reportMooney M20C · Danbury, CTAn eng compartment fire occurred shortly after takeoff & smoke entered the cockpit. The plt then made a forced landing in a sand pit aprx 1 mi fm the arpt. He & the pax exited the acft with serious burns. An inv revealed an exhaust pipe had failed at a…Aug 14, 1984 · N74558 · DestroyedNTSB NYC84LA242Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Thomaston, CTThe glider made an off-arpt landing after encountering unexpected strong head winds in a rapidly changing flow of marineair. The acft cleared obtacles on final but yawed and landed in a crab condition damaging the fuselage and wing tip wheel.Jul 15, 1984 · N65805 · Substantial damageNTSB 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 NYC84LA134Accident · No injuriesLimited investigationFinal reportHughes 269A · Danbury, CTWhile in flt, the helicopter yawed & the eng RPM increased. The plt retarded the throttle to idle, lowered the collective & initiate an autorotation. While attempting to reach a suitable landing area, the plt kept his speed up to avoid buildings. However,…Apr 7, 1984 · N8817F · Substantial damageNTSB NYC83LA161Accident · No injuriesLimited investigationFinal reportCessna 172P · Redding, CTThe flight originated at ramapo, NY. During a preflight check, the plt noted that the fuel gauges indicated full. When he visually checked the fuel tanks, he estimated that the fuel level in each tank was about 1 inch from being full. The fuel capacity of…Jul 1, 1983 · N62511 · Substantial damageNTSB NYC83FA122Accident · Serious injuriesField investigationFinal reportCessna 172N · N. Stonington, CTThe acft collided with a tree during a go-around at night following a downwind precautionary landing. During the flt the plt had noted the fuel gauges at low readings and said he suspected a 'fuel leak'. He made radio calls to try to go to an arpt before fuel…May 20, 1983 · N4980G · 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 NYC83FA086Accident · No injuriesField investigationFinal reportCessna 210L · Avon, CTThe acft collided with a tree and broke the nose landing gear during an emergency landing after electrical failure. After the failure, using matches and a flashlight, the plt tried to land but could not find the arpt. The weather was deteriorating so when a…Apr 8, 1983 · N59123 · Substantial damageNTSB NYC83FA052Accident · No injuriesField investigationFinal reportRobinson R22 · Milford, CTThe helicopter collided with a telephone pole during an autorotation forced landing after an engine malfunction. The aircraft was cruising at 500 feet when there was an audible decrease in main rotor and engine RPM. The rotor RPM was between 80-85 percent…Jan 8, 1983 · N9017Y · Substantial damageNTSB NYC83FNE01Accident · Serious injuriesFinal reportFairchild M-62A-3 · Durham, CTDuring a climb to a higher altitude the engine failed. The plt attempted a 180 deg turn to land at an arpt but was unable to make it to the arpt. The acft touched down approximately 15 ft before impacting a barn.Oct 31, 1982 · N3983A · Substantial damageNTSB NYC82DA138Accident · No injuriesFinal reportGrumman AA-1C · West Haven, CTThe student pilot departed bridgeport, CT at 1200 hours and arrived at nantucket, ma at 1345 hours. While en route, he made a touch-and-go at fishers island and practiced stall maneuvers. He departed nantucket at about 1430 hours without refueling.…Jul 2, 1982 · N39050 · Substantial damageNTSB NYC82DA068Accident · No injuriesFinal reportCessna 150M · Washington, CTWhile practicing power on stalls and gliding turns the pilot stated that the engine would not respond with half throttle. A forced landing was made after passing up two rough fields for a more distant one at a higher altitude. The pilot stated he should have…Apr 3, 1982 · N7652U · Substantial damageNTSB NYC81FNE31Accident · No injuriesClosedErco 415-D · Danbury, CTSep 12, 1981 · N99436 · Substantial damageNTSB NYC81FNE24Accident · Minor injuriesClosedCessna 152 · Berlin, CTAug 1, 1981 · N4931B · Substantial damageNTSB NYC81FA046Accident · No injuriesClosedErco 415-D · Terryville, CTMay 9, 1981 · C-FNWZ · DestroyedNTSB NYC81FNE13Accident · No injuriesClosedCessna 150 · Mansfield, CTMar 28, 1981 · N60118 · Substantial damageNTSB NYC81FNE05Accident · Minor injuriesClosedPiper J-3 · Coventry, CTDec 7, 1980 · N92654 · Substantial damageNTSB NYC81IA015Incident · Minor injuriesClosedNord 262A12 · Groton, CTDec 3, 1980 · N26217 · Minor damageNTSB NYC81FAMS1Accident · 4 fatalClosedPiper PA-31 · Bridgeport, CTNov 10, 1980 · N62987 · DestroyedNTSB NYC80FA068Accident · 3 fatalClosedCessna 172 · Burlington, CTAug 11, 1980 · N737AD · DestroyedNTSB NYC80FNE19Accident · Serious injuriesClosedStinson 108-1 · Windham, CTJun 26, 1980 · N1081S · Substantial damageNTSB NYC80FNE10Accident · Minor injuriesClosedCessna 150 · Waterford, CTFeb 8, 1980 · N61085 · Substantial damageNTSB NYC80FA009Accident · No injuriesClosedPiper PA-31 · Stamford, CTNov 7, 1979 · N405CA · 2 aircraft · Substantial damageNTSB NYC8OFA001Accident · 1 fatalClosedPiper PA-23 · Ashford, CTSep 30, 1979 · N1267P · DestroyedNTSB NYC79FNE18Accident · No injuriesClosedBell 47D-1 · Ridgefield, CTJun 24, 1979 · N4250A · Substantial damageNTSB NYC79FNE17Accident · Minor injuriesClosedCessna 152 · Bristol, CTJun 20, 1979 · N49009 · Substantial damage