Skip to content

NTSB investigations, CT

30 cases where the first occurrence was “Loss of engine power”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

Where

Latest cases

Query with SQL

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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

duckdb -csv -c "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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350)
  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.

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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB NYC04FA056Accident · Serious injuriesField investigationFinal reportPiper PA-28-151 · Danbury, CTThe loss of engine power for undetermined reasons, and the pilot's failure to maintain adequate airspeed.Jan 7, 2004 · N1558X · Substantial damage NTSB NYC02LA122Accident · No injuriesLimited investigationFinal reportCessna 182B · Ellington, CTThe pilot's misjudged distance/altitude during an emergency landing, which resulted in an undershoot and subsequent forced landing to a cornfield. A factor was the pilot's inadequate preflight planning, which resulted in fuel starvation.Jun 24, 2002 · N2516G · Substantial damage NTSB NYC99LA156Accident · Serious injuriesLimited investigationFinal reportCessna 185E · East Haddam, CTThe loss of engine power due to water in the fuel system.Jun 23, 1999 · N3385L · Substantial damage NTSB NYC98LA044Accident · Minor injuriesLimited investigationFinal reportConsolidated-Vultee BT-13A · Oxford, CTThe loss of power for undetermined reasons.Dec 18, 1997 · N67868 · Substantial damage NTSB NYC97FA159Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Danbury, CTThe pilot's failure to takeoff with the fuel selector in the full on position, which resulted in fuel starvation. Also causal was the pilot's improper in-flight decision to attempt a 180 degree turn back to the runway, which resulted in the inadvertent…Aug 4, 1997 · N24565 · Destroyed NTSB NYC97LA033Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Ellington, CTice ingestion into the engine from the carburetor air box, which resulted in a loss of engine power and a subsequent forced landing, off airport, on unprepared terrain.Dec 22, 1996 · N55228 · Substantial damage NTSB 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 damage NTSB BFO95LA060Accident · Serious injuriesLimited investigationFinal reportBronislaus Challenger II · Burlington, CTA loss of engine power for an undetermined reason(s), the 30-hour student pilot's poor judgment in allowing himself to receive dual instruction in an airplane not equipped with dual conntols, the cfi's poor judgment in attempting to give instruction to a…Jun 10, 1995 · N8101Z · Destroyed NTSB NYC94LA143Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Bridgeport, CTThe loss of engine power for undetermined reasons.Jul 31, 1994 · N8453B · Substantial damage NTSB 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 · Destroyed NTSB NYC93LA175Accident · No injuriesLimited investigationFinal reportEnstrom F28A · Meriden, CTThe loss of engine power for undetermined reasons.Aug 27, 1993 · N269Q · Substantial damage NTSB 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 damage NTSB NYC93LA111Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Woodstock, CTA complete loss of engine power for undetermined reasons.Jun 13, 1993 · N6158B · Substantial damage NTSB NYC92LA152Accident · Minor injuriesLimited investigationFinal reportCessna 210J · Groton, CTA forced landing in unsuitable terrain as a result of a complete loss of engine power for unknown reasons.Aug 9, 1992 · N6172F · Destroyed NTSB BFO92LA112Accident · No injuriesLimited investigationFinal reportJames Snyder Challenger II · Burlington, CTThe loss of engine power for undetermined reasons.Jul 22, 1992 · N602CH · Substantial damage NTSB 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 damage NTSB NYC89LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Stratford, CTThe loss of engine power for undetermined reasons.Jan 7, 1989 · N757KR · Substantial damage NTSB 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 damage NTSB 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 damage NTSB NYC86LA191Accident · No injuriesLimited investigationFinal reportBell 47G-5A · Portland, CTWhile climbing, shortly after takeoff, the eng quit for undetermined reasons. The pilot autorotated into a sand bank where the helicopter received substantial damage.Jul 20, 1986 · N59400 · Substantial damage NTSB NYC86LA119Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Madison, CTThe acft experienced an engine failure during takeoff and the plt made a forced landing in a river. Post accident inspection did not determine cause of the power loss. It should be noted that the acft was under water for several hours prior to examination.May 6, 1986 · N2841M · Substantial damage NTSB 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 damage NTSB NYC85LA208Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28F · Groton, CTEnstrom F28F, N8623X was performing auto rotation at Groton-new london, Connecticut when a loss of power was experienced, the student pilot was at the controls and entered auto rotation with the understanding that it would terminate in a power recovery. After…Aug 12, 1985 · N8623X · Substantial damage NTSB NYC85FNE02Accident · No injuriesFinal reportEarl F. Folsom Sonerai II · Waterbury, CTThe homebuilt sonerai ii made an off airport landing 3 minutes after takeoff. The aircraft received substantial damage and the sole occupant was uninjured. Post crash examination of the aircraft showed the fuel tank was empty. However, there was fuel in the…Aug 2, 1985 · N27EF · Substantial damage NTSB 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 damage NTSB NYC85LA168Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · New Milford, CTAccording to the plt, the preflt and runup checks were normal. The plt then applied full pwr for takeoff and rotation was initiated at 60 KTS. After liftoff, the acft appeared to loose pwr and began to yaw to the left. The stall warning horn sounded and the…Jul 1, 1985 · N82631 · Substantial damage NTSB NYC84LA302Accident · No injuriesLimited investigationFinal reportCessna 305A · Madison, CTPurpose of flt was fam in this make/model for front seat plt by rear seat check-out plt. Preflight fuel quantity was checked by ref to gages only. Left tank read 1/2 full. Neither plt recalled rt tank reading. After takeoff, at about 150 ft, complete pwr loss…Sep 3, 1984 · N11SU · Substantial damage NTSB 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 damage NTSB 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 damage NTSB NYC82DA204Accident · No injuriesFinal reportCessna 195A · Wallingford, CTThe pilot reported that when he preflighted the aircraft, the fuel tanks were full. Fuel was drained from each wing and the fuselage low point with no indication of water. During takeoff, engine power was lost at an altitude of about 150 ft as the manifold…Aug 19, 1982 · N4433C · Substantial damage