NTSB investigations, CT
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
Query with SQL
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' 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' 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 NYC87LA153Accident · No injuriesLimited investigationFinal reportCessna 182 · Ellington, CTThe pilot stated that while making a standard left traffic pattern, the wind at the north end of the airport shifted from the southeast to the northwest. The acft touched down with excessive ground speed, ran off the end of the rwy and came to rest on a…NTSB NYC87LA134Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Ellington, CTDuring an instructional flight, the instructor pilot simulated a forced landing at about 250 feet and 60 KIAS. The student pilot at this time entered an autorotation and the helicopter started to descend. Collective was pulled but this failed to stop the…NTSB NYC87FA124Accident · 2 fatalField investigationFinal reportBellanca 8KCAB · New Milford, CTAfter taking off on runway 16 at the candlelight farms airport, the flight remained low over the runway while gaining airspeed. As the aircraft approached the upwind end of the runway, witnesses observed it enter a steep climb that continued to an estimated…NTSB NYC87LA102Accident · No injuriesLimited investigationFinal reportCessna 172N · Danbury, CTStudent pilot lost directonal control on landing and the aircraft veered to the left of the runway and collided with a snowbank.NTSB NYC87LA093Accident · No injuriesLimited investigationFinal reportMooney M20J · Plainville, CTDuring landing, the pilot came in high and fast, pilot stated that aircraft seemed to float down the runway and when the wheels touched down, the aircraft bounced. Bouncing for the third time, the pilot added full throttle and raised the flaps. However the…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…NTSB NYC87LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Simsbury, CTThe aircraft was landing on runway 21 at Simsbury, Connecticut when the pilot lost directional control and the left main wheel contacted the snow bank, which in turn caused the airplane to lean over to the right striking the wing on the runway surface.NTSB 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…NTSB NYC87LA042Accident · Minor injuriesLimited investigationFinal reportRaven S60A · Montville, CTWhile landing in a field. The balloon encountered strong winds and was pushed into trees and brush causing substantial damage.NTSB NYC86LA229Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · New Haven, CTDuring a simulated engine out on takeoff, the student plt leveled the acft instead of lowering the nose to maintain airspeed. The CFI took over control of the acft, however, the airspeed was too slow to arrest the rate of descent. The acft contacted the…NTSB NYC86LA223Accident · No injuriesLimited investigationFinal reportCessna 152 · Willimantic, CTThe plt made an approach to runway 36 too fast and long. Aircraft touched down hard, the plt lost control and the aircraft bounced a few times before nosing over.NTSB NYC86LA222Accident · No injuriesLimited investigationFinal reportCessna 170B · Danbury, CTThe aircraft bounced on touchdown, but then settled back to the runway with the tail swinging to the left. Hard left brake was applied but the pilot could not maintain direction control and the aircraft ran off the runway into the turf striking the left wing…NTSB NYC86FA196Accident · 1 fatalField investigationFinal reportGrumman TBM-3E · Brooklyn, CTThe acft was being flown to the owner's residence when the accident occurred. Shortly after takeoff black and white smoke was observed emitting from the eng cowling and the eng was heard sputtering. According to witnesses, the acft leveled off at an alt of…NTSB 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…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.NTSB NYC86LA190Accident · No injuriesLimited investigationFinal reportCessna 172P · Plainville, CTWhen the plt checked the airspeed indicator on takeoff, he saw no indication of speed & aborted the takeoff, but was unable to stop on the remaining rwy. The acft contd off the departure end, when down an embankment & became inverted. An exam revealed the…NTSB NYC86LA159Accident · No injuriesLimited investigationFinal reportCessna 152 · Danbury, CTThe student pilot was cleared for closed traffic touch and go landings; however, during his acceleration for takeoff, he lost directional control and the aircraft veered left off the runway. Not being able to regain control, the takeoff was aborted. The…NTSB 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…NTSB 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…NTSB NYC86LA143Accident · No injuriesLimited investigationFinal reportCessna 140 · Meriden, CTDirectional control was lost during landing roll out. The pilot attempted to correct and return the aircraft to the runway. The airplane ground looped causing substantial damage.NTSB NYC86LA142Accident · No injuriesLimited investigationFinal reportCessna 172 · Oxford, CTDuring an attempted go around, the aircraft stalled. The aircraft then veered left and collided with the ground. The aircraft came to rest about 100 feet off to the side of the runway on the grassy area.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.NTSB NYC86LA115Accident · No injuriesLimited investigationFinal reportCessna 150 · Woodstock, CTThe student pilot in a Cessna 150 was making a touch and go. He raised the flaps and then added power. He looked over to see if the flaps were retracting and when he looked straight ahead the left wheel was off the runway in soft terrain. He reduced power and…NTSB NYC86FA096Accident · 5 fatalField investigationFinal reportPiper PA-24-180 · Somers, CTThe acft, on a night flt, was seen flying about 1 mi west of ellington arpt. A witness saw the acft flying north and just above the 800 ft high terrain. The acft was in a gradual descent and it appeared that it would not clear terrain ahead. Afterwards the…NTSB NYC86LA089Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Danbury, CTPilot touched down long on 3135 foot runway, exceeding the braking action of the aircraft, ran off end of runway into a ditch causing substantial damage to the aircraft. The pilot, the sole occupant received no injuries.NTSB NYC86LA087Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Hartford, CTThe cross country solo flight was taking off on runway 02 at Hartford, Connecticut. The pilot performed a runup and was cleared for takeoff. The pilot attempted rotation at about 60 KIAS, but aircraft did not lift off. Trim tab was set at neutral on runup. As…NTSB NYC86FNE02Accident · No injuriesFinal reportFolsom Sonerai II · Middlebury, CTThe plt reported that the acft was slow to climb after takeoff and had reached an alt of only 100' AGL at the end of the 5000' lond rwy. The plt continued to state the acft was unable to clear rising terrain aprx 1/2 mile from the arpt. The acft contacted the…NTSB 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…NTSB NYC86LA066Accident · No injuriesLimited investigationFinal reportCessna 152 · Plainville, CTThe purpose of instructional flight was to practice soft field landings and takeoffs, stall series and VOR naviagtion. After airwork, the pilot flew to robertson field for short and soft field landings and takeoffs. During final soft field takeoff, 10 degrees…NTSB NYC86FA057Accident · 2 fatalField investigationFinal reportCessna 182L · So.Glastonbury, CTThe acft was on a VOR instrument apch when it collided with 250 ft high terrain approx 6 miles south of the arpt and approx 2 miles north of the vor/faf. Shortly before the accident the pilot notified ATC that he was in turbulence; then reported he was clear…NTSB NYC86LA055Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Ellington, CTWhile on apch for landing, about 50 ft from the rwy, the landing gear contacted a bridge and the acft bounced into the air. Pwr was added at this time and again the acft bounced. The acft was then landed on the rwy and it skidded to a stop. The plt stated she…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…NTSB 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…NTSB NYC85LA236Accident · No injuriesLimited investigationFinal reportBeech BE-55 · Danbury, CTThe plt stated that on touchdown the left main gear collapsed followed by the right main gear and nose gear. The acft slid aprx 600 to 700 ft before stopping. According to the plt he confirmed the gear was down and locked while on base. A gear cycle test…NTSB NYC85LA235Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Madison, CTWhile on the downwind leg for rwy 24, the instructor reduced power to idle for engine failure simulation. The student made a short approach and upon reaching 700 ft AGL the student headed directly toward the approach end of the rwy at a 30 deg angle from rwy…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…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…NTSB NYC85LA178Accident · Minor injuriesLimited investigationFinal reportCessna C172 · Ellington, CTThe acft collided with the ground during takeoff from rwy 01 at Ellington, Connecticut, and was substantially damaged but there was no fire. The pilot received minor injuries. The aircraft crashed for undetermined reasons.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…NTSB NYC85LA177Accident · No injuriesLimited investigationFinal reportSikorsky S-76A · Hartford, CTThe apch to the pvt helipad was uneventful up to the last 100 ft where the plts noticed a high sink rate. The plt increased collective to correct for the situation. At about 20 ft from touchdown point the plt noticed a decrease in RPM and realized that they…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…NTSB NYC85LA142Accident · No injuriesLimited investigationFinal reportCessna 152 · Hartford, CTThe acft nosed over following a loss of control during landing. The student plt stated the acft bounced three times on touchdown. The propeller then contacted the rwy and the acft nosed over.NTSB NYC85LA128Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Ellington, CTThe acft colldied with a stump during a landing attempt at Ellington arpt. The acft had touched dwn about 25 ft short of the rwy. The left aileron was damaged but the acft made a go-around & returned to westover air base & landed. According to the plt,…NTSB NYC85FA104Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · East Haddam, CTDuring approach to runway 14 pilot decided to go around. Aircraft turned left about 90 degrees and collided with rising terrain .2 NM east of the runway. The rising terrain parallels runway 14.NTSB NYC85LA101Accident · No injuriesLimited investigationFinal reportBeech B-35 · East Haddam, CTThe acft stalled and contacted sandy terrain aprx 50 ft from the rwy threshold. The plt reported the cabin door opened during takeoff and he circled the traffic pattern to land and close the door. He stated an airspeed of 100 KTS was observed on a 1 mile…NTSB NYC85FNE01Accident · Serious injuriesFinal reportMarr/Eckburg Long EZE · Waterbury, CTThe acft crashed into an embankment short of rwy 36 after a loss of pwr on final approach. The plt said he was operating on the rt tank when the eng quit. He immediately awitched to the left tank and activated the boost pump. The prop had stopped and the acft…NTSB NYC85IA062Incident · No injuriesIncident investigationFinal reportBeech BE-99 · Putnam, CTPlt stated that during tkf the acft started to yaw & roll in a manner consistent with wake turbulence encounter. He applied full opposite rudder & aileron. Normal directional was regained between 50-75 ft above the gnd. The acft was leveled for cruise at 5000…NTSB 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…NTSB NYC85LA036Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Meriden, CTWhile in cruise, plt heard an abnormal sound from the left side of the engine compartment and having had previous problems with the newly-installed engine, elected to make a precautionary landing at a nearby arpt to investigate. Plt stated he landed long and…NTSB NYC85LA034Accident · No injuriesLimited investigationFinal reportCessna 172P · Madison, CTPlt stated that as he lowered nose gear to runway following initial touchdown on mains, acft nose continued to drop. Control inputs were not effective. Investigation revealed the nose gear ass'y failed in overload. Based on fuel remaining on board and…