NTSB investigations, CT
24 cases where NTSB found Conditions/weather/phenomena.
Cases per year
| 2008 | 3 |
|---|---|
| 2011 | 2 |
| 2012 | 2 |
| 2013 | 2 |
| 2014 | 1 |
| 2015 | 2 |
| 2016 | 1 |
| 2017 | 2 |
| 2019 | 1 |
| 2020 | 2 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 1 |
| 2025 | 2 |
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0303'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0303')) 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 ERA26LA033Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Oxford, CTThe pilot’s failure to compensate for gusty crosswind conditions, which resulted in a loss of control of the airplane and subsequent collision with terrain.NTSB ERA26LA015Accident · No injuriesClass 4 · LimitedFinal reportSocata TB 10 · New Milford, CTThe pilot’s decision to depart from an unlit turf runway at night, which resulted in a loss of directional control, and subsequent runway excursion.NTSB ERA24LA378Accident · No injuriesClass 4 · LimitedFinal reportBrandt Stirling D WAIEX-B · Stratford, CTThe pilot’s failure to maintain direction control of the airplane during a takeoff in crosswind conditions.NTSB ERA23LA121Accident · Serious injuriesClass 3 · LimitedFinal reportRichard Brinkman Lancair 4P · Hartford, CTThe pilot’s takeoff with a significant fuel imbalance, which resulted in the airplane lacking the roll authority to overcome the left rolling tendency and subsequently impacting terrain. Contributing to the accident was the pilot’s inadequate preflight…NTSB ERA22LA300Accident · Minor injuriesClass 4 · LimitedFinal reportCessna A185F · Plymouth, CTThe pilot’s encounter with known and forecast adverse weather which resulted in a collision with trees during the initial climb.NTSB ERA21LA276Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer SGS 1-26E · Willimantic, CTThe failure of the student to achieve the proper touchdown point resulting in landing undershoot.NTSB ERA21LA016Accident · Minor injuriesClass 4 · LimitedFinal reportEnstrom 480 · Woodstock, CTThe pilot’s failure to maintain control of the helicopter while attempting to land on a trailer in gusting wind conditions, which resulted in a dynamic rollover.NTSB ERA20CA294Accident · No injuriesClass 4 · Data collectionFinal reportSocata TB200 · Simsbury, CTA runway excursion following an aborted takeoff in tailwind conditions.NTSB GAA20CA068Accident · No injuriesData collectionFinal reportIcon A5 · Chester, CTThe pilot's failure to maintain a proper approach angle in dark night conditions, which resulted in a collision with treetops and a subsequent hard landing.NTSB GAA17CA550Accident · No injuriesData collectionFinal reportCessna 180 · Danbury, CTThe pilot's failure to maintain directional control during the landing roll in gusting wind conditions.NTSB GAA17CA325Accident · No injuriesData collectionFinal reportCessna 182 · Ellington, CTThe pilot’s unstabilized approach and failure to go around in rainy, gusting crosswind conditions, which resulted in a runway overrun. Contributing to the accident was the pilot’s self-induced pressure to land due to the deteriorating weather conditions.NTSB GAA16CA232Accident · No injuriesData collectionFinal reportPiper PA 12 · Simsbury, CTThe pilot's failure to attain the proper touchdown point and the airplane's subsequent impact with a fence during an attempted aborted landing.NTSB ERA15LA356Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Stratford, CTThe pilot's failure to maintain directional control while landing in a crosswind.NTSB DCA15CA136Accident · Serious injuriesData collectionFinal reportBoeing 777 - 236 · Windsor Locks, CTan inadvertent encounter with convective turbulence resulting in serious injury to a flight attendant.NTSB ERA15LA063Accident · No injuriesLimited investigationFinal reportCessna 182 · Hartford, CTThe partial loss of engine power during climb after takeoff for a reasons that could not be determined because postaccident engine examination revealed no evidence of mechanical malfunctions or failures.NTSB ERA13FA358Accident · 4 fatalField investigationFinal reportRockwell International 690B · East Haven, CTThe pilot's failure to maintain airspeed while banking aggressively in and out of clouds for landing in gusty tailwind conditions, which resulted in an aerodynamic stall and uncontrolled descent.NTSB ERA13CA233Accident · Minor injuriesData collectionFinal reportHughes Charles R Zodiac 601XL · Meriden, CTThe pilot's decision to land with a tailwind and his failure to maintain aircraft control during landing.NTSB ERA13FA064Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Canton, CTThe pilot’s failure to maintain clearance from terrain while performing a night visual approach to an airport. Contributing to the accident were the dark night and the pilot's lack of recent experience flying at night.NTSB ERA12LA131Accident · No injuriesLimited investigationFinal reportHaney John F B Seastar XP · Willimantic, CTA partial loss of engine power due to carburetor icing. Contributing to the accident was the lack of an installed manufacturer-recommended carburetor heat system.NTSB ERA12CA124Accident · No injuriesData collectionFinal reportChapel Robert B Aerial · Simsbury, CTThe pilot's decision to operate the gyroplane outside his endorsement limitations and to depart with a tailwind, which resulted in a forced landing to unsuitable terrain.NTSB ERA11CA226Accident · No injuriesData collectionFinal reportCessna U206C · Bridgeport, CTThe pilot's delayed decision to perform a go-around which resulted in a hard landing.NTSB ERA09LA064Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Groton, CTThe student pilot’s failure to maintain a proper descent profile to avoid trees during the night visual approach and the flight instructor’s inadequate oversight.NTSB ERA09CA007Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Chester, CTThe pilot’s failure to obtain the proper touchdown point while landing. Contributing to the accident were the pilot’s inexperience landing at the airport, night conditions, and non-standard runway lighting.NTSB CHI08LA185Accident · No injuriesLimited investigationFinal reportTraxler John N Kitfox · Hartford, CTThe pilot's failure to compensate for crosswinds resulting in a loss of directional control while landing. Contributing to the accident was the pilot's lack of experience and training in tailwheeled airplanes.