NTSB investigations, CT
55 cases where NTSB found Use of equip/info.
Cases per year
| 2008 | 4 |
|---|---|
| 2010 | 1 |
| 2013 | 3 |
| 2014 | 1 |
| 2015 | 6 |
| 2016 | 6 |
| 2017 | 9 |
| 2018 | 5 |
| 2019 | 4 |
| 2020 | 3 |
| 2021 | 4 |
| 2022 | 2 |
| 2023 | 1 |
| 2024 | 3 |
| 2025 | 2 |
| 2026 | 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '020630'))
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", '020630')) 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 ERA26LA229Accident · No injuriesClass 4 · LimitedFinal reportHawker Beechcraft G36 · Danbury, CTThe pilot’s decision to abort the takeoff with insufficient runway remaining, which resulted in a runway excursion.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 ERA25LA381Accident · No injuriesClass 4 · LimitedFinal reportPitts S-1T · Danbury, CTThe pilot’s failure to maintain directional control during the landing rollout, which resulted in a ground loop.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 ERA24LA168Accident · No injuriesClass 4 · LimitedFinal reportCessna 208 · Ellington, CTThe pilot’s failure to maintain a proper glidepath to the runway, which resulted in a runway undershoot and collision with terrain.NTSB ERA24LA089Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-200 · Groton, CTThe pilot receiving instruction’s failure to extend the landing gear prior to landing. Also contributing, was the flight instructor’s failure to monitor the airplane’s configuration while on approach to land.NTSB ERA23LA135Accident · 1 fatalClass 2 · LimitedFinal reportBombardier BD-100-1A10 · Windsor Locks, CTThe flight crew’s failure to remove the right side pitot probe cover before flight, their decision to depart with a No-Go advisory message following an aborted takeoff, and their selection of the incorrect non-normal checklist in flight, which resulted in an…NTSB ERA22LA336Accident · Minor injuriesClass 4 · LimitedFinal reportBellanca 7KCAB · East Haddam, CTThe pilot's failure to maintain directional control during the landing.NTSB ERA22LA152Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 7GCBC · Plainville, CTThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA22LA016Accident · Serious injuriesClass 3 · LimitedFinal reportKitfox IV · North Canaan, CTThe pilot's mismanagement of the airplane's altitude, airspeed, and course during a forced landing following a partial loss of engine power, which resulted in collision with trees and terrain. Contributing was the pilot’s inadvertent omission of stowing the…NTSB ERA21FA346Accident · 4 fatalClass 2 · FieldFinal reportCessna 560 · Farmington, CTThe pilot-in-command’s failure to release the parking brake before attempting to initiate the takeoff, which produced an unexpected retarding force and airplane-nose-down pitching moment that prevented the airplane from becoming airborne within the takeoff…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 ERA21LA249Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Groton, CTThe pilot’s failure to maintain directional control of the airplane during landing, resulting in a runway excursion and collision with an airport sign.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 ERA20LA337Accident · No injuriesClass 4 · LimitedFinal reportLancair 235 · Chester, CTThe pilot's unstable approach, which resulted in a hard landing, and the separation of the left main landing gear.NTSB ERA20CA190Accident · No injuriesClass 4 · Data collectionFinal reportCessna 305 · Oxford, CTThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground-loop.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 GAA19CA379Accident · No injuriesData collectionFinal reportCirrus SR22 · Grotten, CTThe pilot's improper landing flare and failure to maintain pitch control, which resulted in a porpoised landing.NTSB GAA19CA422Accident · No injuriesData collectionFinal reportDaryl Baker Bush Sport · Willimantic, CTThe pilot's failure to maintain directional control during taxi operations, which resulted in a collision with a fuel pump enclosure.NTSB GAA19CA287Accident · No injuriesData collectionFinal reportJihlavan Airplanes Sro KP5 · East Haddam, CTThe pilot's failure to maintain the proper airspeed and his exceedance of the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall.NTSB GAA19CA091Accident · No injuriesData collectionFinal reportZlin Z143 · Chester, CTThe pilot's loss of airplane control during the engine start.NTSB ERA19LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA28 · Simsbury, CTMaintenance personnel's inadequate inspection of the wheel brake system during the airplane's most recent 100-hour inspection, which resulted in a loss of hydraulic fluid and the pilot's inability to control the airplane during the landing.NTSB GAA18CA529Accident · No injuriesData collectionFinal reportPiper PA46 · Hartford, CTThe pilot’s unstabilized approach and hard landing, which resulted in a nose landing gear collapse.NTSB ERA18FA189Accident · 1 fatalField investigationFinal reportRutan Defiant · Plainville, CTThe pilot's loss of airplane control during climb for reasons that could not be determined based on the available information.NTSB GAA18CA374Accident · No injuriesData collectionFinal reportBeech V35B · Chester, CTThe pilot’s failure to maintain clearance from a hangar during taxi.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 GAA17CA530Accident · Minor injuriesData collectionFinal reportCessna 172 · Plainville, CTThe pilot’s failure to properly execute the go-around, which resulted in the airplane failing to maintain a climb, which resulted in collision with a tree.NTSB ERA17FA272Accident · 1 fatalField investigationFinal reportCessna 172 · New Milford, CTThe flight instructor's failure to ensure that the wing flaps were properly configured for takeoff, which resulted in an aerodynamic stall and loss of control during the initial climb.NTSB ERA17LA261Accident · 1 fatalLimited investigationFinal reportCessna 172 · Danbury, CTThe pilot's exceedance of the airplane's critical angle of attack during initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's decision to operate the airplane above its maximum gross weight, which likely reduced…NTSB GAA17CA345Accident · No injuriesData collectionFinal reportPiper PA28 · Hartford, CTThe pilot’s improper landing flare, which resulted in a bounced landing.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 ERA17FA167Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Wallingford, CTThe pilot's unstablilized approach and improper landing flare, which resulted in a bounced landing, and his subsequent failure to maintain control during a go-around. Contributing to the accident was the pilot's lack of experience in the accident airplane…NTSB ERA17FA156Accident · 2 fatalField investigationFinal reportLuscombe 8 · East Windsor, CTThe flying pilot's excessive maneuvering of the airplane at a slow airspeed, which resulted in exceedance of the critical angle of attack and an aerodynamic stall. Contributing to the accident was the pilots' operation of the airplane over its maximum…NTSB ERA17FA112Accident · 1 fatalField investigationFinal reportPiper PA38 · East Haven, CTThe failure of the fuel selector valve in a position that restricted fuel flow to the engine, resulting in a total loss of engine power during initial climb due to fuel starvation. Also causal was the operator's failure to effectively detect and resolve the…NTSB GAA17CA099Accident · Minor injuriesData collectionFinal reportPiper PA38 · Hartford, CTThe student pilot’s improper landing flare, which resulted in a bounced hard landing.NTSB GAA16CA514Accident · No injuriesData collectionFinal reportCessna 205 · Ellington, CTThe pilot's exceedance of the airplane's critical angle-of-attack during the initial climb after an attempted go-around, which resulted in an aerodynamic stall.NTSB ERA16CA308Accident · No injuriesData collectionFinal reportBeech C23 · Simsbury, CTThe student pilot’s failure to attain the proper touchdown point, which resulted in a runway overrun.NTSB ERA16LA267Accident · Serious injuriesLimited investigationFinal reportTemple Benjamin Freedom Master FM-2 · East Haddam, CTThe pilot’s loss of airplane control during the initial climb.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 ERA16LA122Accident · No injuriesLimited investigationFinal reportCessna 152 · Chester, CTThe pilot’s failure to maintain directional control of the airplane during the landing, which resulted in a runway excursion.NTSB ERA15LA365Accident · Minor injuriesLimited investigationFinal reportClark 1000 · Warehouse Point, CTThe pilot’s failure to maintain adequate airspeed during the initial climb after takeoff, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's decision to…NTSB ERA15LA356Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Stratford, CTThe pilot's failure to maintain directional control while landing in a crosswind.NTSB GAA15CA246Accident · No injuriesData collectionFinal reportCessna 170A · New Milford, CTThe pilot's loss of directional control during the landing roll which resulted in a runway excursion and impact with terrain.NTSB ERA15LA322Accident · Minor injuriesLimited investigationFinal reportEclipse EA500 · Danbury, CTThe pilot's failure to attain the proper touchdown point and exceedance of the target touchdown speed, which resulted in a runway overrun.NTSB GAA15CA228Accident · No injuriesData collectionFinal reportCessna 337F · Danbury, CTThe pilot's failure to maintain pitch control during the landing, resulting in a hard landing, nose gear collapse, runway excursion, and collision with terrain.NTSB GAA15CA218Accident · No injuriesData collectionFinal reportCessna 170A · East Haddam, CTThe pilot's failure to maintain directional control during the landing roll, and excessive use of brakes, which resulted in a runway excursion and nose over.NTSB ERA14CA314Accident · No injuriesData collectionFinal reportCessna 172L · Danbury, CTThe pilot's use of a person unfamiliar with aviation and his failure to properly secure the airplane during hand starting of the engine.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 ERA13LA343Accident · No injuriesLimited investigationFinal reportCessna 175 · Willimantic, CTThe pilot’s failure to maintain directional control during the landing roll, which resulted in a ground loop.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.