NTSB investigations, CT
48 cases where the first occurrence was “Loss of control - in flight”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 2 |
| 1984 | 4 |
| 1986 | 2 |
| 1987 | 3 |
| 1988 | 3 |
| 1989 | 3 |
| 1990 | 3 |
| 1991 | 2 |
| 1993 | 4 |
| 1996 | 4 |
| 1998 | 3 |
| 2001 | 4 |
| 2002 | 3 |
| 2003 | 2 |
| 2004 | 2 |
| 2005 | 1 |
| 2007 | 1 |
Where
Open the mapLatest cases
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'
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\" = 250)
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" = 250) 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 NYC07FA100Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Windham, CTThe pilot's failure to maintain control of the airplane during a go-around.NTSB NYC05FA109Accident · 4 fatalField investigationFinal reportCessna 182Q · Groton, CTThe pilot's failure to maintain aircraft control while executing an ILS (Instrument Landing System) approach to minimums.NTSB IAD04CA026Accident · Minor injuriesData collectionFinal reportLake LA-250 · Deep River, CTThe pilot's improper recovery from a bounced water landing.NTSB NYC04LA106Accident · No injuriesLimited investigationFinal reportCessna 182S · Plainville, CTThe failure of the elevator servo which resulted in restricted elevator movement and the pilot's inability to initiate a landing flare.NTSB 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.NTSB 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…NTSB 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.NTSB IAD02LA032Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5B · Harwinton, CTpilot's failure to obtain adequate airspeed during take-off, which resulted in an aerodynamic stall.NTSB NYC02FA055Accident · 2 fatalField investigationFinal reportBeech V35B · Chester, CTThe pilot's failure to maintain adequate airspeed during the turn to final, which resulted in an inadvertent stall/spin. Factors included low ceilings and night lighting conditions.NTSB 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.NTSB 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.NTSB NYC01LA198Accident · Minor injuriesLimited investigationFinal reportMoran Europa Monowheel · Oxford, CTThe pilot's failure to maintain directional control during an aborted landing.NTSB IAD01LA036Accident · No injuriesLimited investigationFinal reportLenart Rotorway Exec 162F · Wallingford, CTflight instructor's failure to follow published checklist procedures, which resulted in the forward ballast weight not being moved to the tailboom prior to departure.NTSB 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.NTSB NYC98LA144Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1A · Madison, CTWas the failure of the pilot to maintain directional control of the airplane during an aborted landing. A factor was the winds which were variable and gusty.NTSB NYC98FA095Accident · 1 fatalField investigationFinal reportMooney M20J · Bridgeport, CTThe pilot's failure to maintain control of the airplane during night instrument meteorological conditions. Contributing factors were dark night conditions, low ceilings, rain, and his decision to divert to an airport under instrument meteorological conditions…NTSB IAD96LA115Accident · Serious injuriesLimited investigationFinal reportPiper PA-46-310P · Hartford, CTthe pilot's inadequate preflight planning/preparation, and his failure to attain the proper lift-off airspeed, which resulted in a stall and collision with the terrain (river).NTSB NYC96LA122Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Danbury, CTthe safety pilot's raising of the flaps, while the airplane was at an inadequate airspeed during the aborted landing, which resulted in a stall, uncontrolled descent, and subsequent collision with parked airplanes.NTSB NYC96FA113Accident · No injuriesField investigationFinal reportBeech A36 · Meriden, CTthe pilot's improper planning/decision, his failure to use takeoff power, and his premature lift-off of the airplane, which resulted in an inadvertent stall/mush and subsequent collision with terrain. Factors relating to the accident were: the pilot allowing…NTSB 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…NTSB NYC94FA033Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · New Haven, CTThe pilot's failure to maintain control of the airplane during a night approach in adverse weather conditions. Factors which contributed to the accident were the weather conditions and dark night. In addition, the radar controller's vectoring of the pilot to…NTSB BFO94LA023Accident · 1 fatalLimited investigationFinal reportQuicksilver MX · Montville, CTThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall/spin.NTSB NYC94LA020Accident · Serious injuriesLimited investigationFinal reportCessna 182H · Griswold, CTThe pilot's inadequate compensation for wind conditions during takeoff, and the subsequent loss of control and collision with trees. A factor related to the accident were the adverse winds.NTSB NYC93LA108Accident · Serious injuriesLimited investigationFinal reportMooney M20J · New Haven, CTThe loss of airplane control as a result of the pilot encountering spatial disorientation. Factors in this accident were the low ambient light conditions and the lack of runway end identifier lightsNTSB 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,…NTSB 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.NTSB NYC90LA190Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Burlington, CTThe CFI failed to maintain a safe sink rate resulting in an undershoot of the runway.NTSB NYC90LA145Accident · No injuriesLimited investigationFinal reportCessna 177B · Danielson, CTThe failure of the pilot to maintain proper runway alignment, and his failure to obtain or maintain adequate airspeed during a go-around, which resulted in an inadvertent stall and collision with the shrubs and trees.NTSB 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.NTSB NYC90LA019Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Windham, CTThe pilot's failure to achieve proper lift-off speed.NTSB NYC89DNE03Accident · No injuriesFinal reportHancock MINI-MAX II · Chester, CTThe pilot's failure to attain adequate airspeed. A contributing factor was the pilot's lack of flight time in the airplane.NTSB 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.NTSB NYC89LA039Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Danielson, CTFailure of the pilot to recognize a stall and take corrective action prior to experiencing a loss of control.NTSB NYC88LA234Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Griswold, CTThe takeoff was made with the temp at about 90 deg f. the acft was about 60 lbs over the authorized max gross wt. Witnesses said the nose of the acft was high as it passed over trees just beyond the end of the rwy. The acft then descended with the wings…NTSB 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…NTSB NYC88DNE01Accident · 1 fatalFinal reportLamb Commander Elite · Meriden, CTThe pilot's failure to maintain control of the homebuilt gyrocopter while preforming low level 'fast taxi' maneuvers.NTSB NYC87FA160Accident · 2 fatalField investigationFinal reportRobinson R22 Mariner · So. Windsor, CTA loss of control in flight for undetermined reasons.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 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 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 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.NTSB DCA84AA027Accident · 3 fatalFinal reportLearjet 23A · Windsor Locks, CTAccording to witnesses, the acft made a normal apch to rwy 33 with no apparent abnormalities. However, when it was about 200 ft over the apch lights, they heard an increase in the eng thrust & the acft's descent stopped. Two plt witnesses thought the aircrew…NTSB NYC84LA198Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Ellington, CTAcft was on short final with 100 degree left x-wind 0F 10 KTS gusting to 15 KTS. When a gust occurred the left wing dragged the rwy and the acft cartwheeled.NTSB NYC84FNE02Accident · Serious injuriesFinal reportBenson B8M · Willimantic, CTThe gyrocopter crashed after the plt lost control of the acft in a windy condition, during takeoff. A 20 degree x-wind velocity of 10 KTS gusting to 35 KTS existed at the time of the accident. The plt told his wife (who wrote the report on the 6120.1 NTSB…NTSB NYC84FA053Accident · 2 fatalField investigationFinal reportCessna R182 · Greenwich, CTThe acft collided with trees during an ILS approach to westchester arpt in NY. The weather was IMC and an IFR flt plan was filed. The accident occurred during the 2nd attempt with the 1st ending in a missed approach. It was apparent to thecontroller that the…NTSB 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…NTSB NYC82DA220Accident · Minor injuriesFinal reportCessna 150G · East Haddam, CTThe pilot reported that just prior to flaring, the aircraft had started drifting to the left; therefore, a decision was made to abort the landing. A go-around was initiated and flap retraction was started. However, the aircraft stalled and landed in a swamp.NTSB NYC82DA163Accident · No injuriesFinal reportCessna 150H · Ansonia, CTThe pilot flew to another local airport to practice touch and go landings. During the takeoff from the 1750 foot runway the aircraft stalled into the trees. The pilot stated that the aircraft settled into the tree tops when he maneuvered to avoid power lines.