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 ERA12CA436Accident · No injuriesData collectionFinal reportPiper PA-28-236 · Chester, CTThe pilot’s failure to execute a go-around following an approach that was high and fast, which resulted in a runway overrun.NTSB ERA12LA282Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Farmington, CTThe pilot's inadequate compensation for wind during a high-power, low-speed downwind turn, which resulted in a loss of control due to loss of tail rotor effectiveness and settling with power. Contributing to the accident was the pilot’s decision to land…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 ERA12FA030Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Danbury, CTThe pilot did not maintain clearance from a lighted tower during final approach in night visual conditions.NTSB ERA12LA001Accident · Serious injuriesLimited investigationFinal reportMooney M20K · Ridgefield, CTThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA11IA521Incident · No injuriesIncident investigationFinal reportBeech V35 · New Haven, CTThe in-flight fatigue failure of the engine’s crankshaft, which resulted in the separation of the forward portion of the crankshaft and the propeller.NTSB ERA11CA365Accident · Serious injuriesData collectionFinal reportPiper PA-32-300 · Bridgeport, CTThe pilot's failure to maintain clearance from a blast fence on final approach to land.NTSB ERA11FA334Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Westbrook, CTA total loss of engine power during approach due to inadequate torque on the No. 3 cylinder hold-down nuts.NTSB ERA11IA320Incident · No injuriesIncident investigationFinal reportRobinson Helicopter R22 Mariner · Redding, CTThe pilot's inadequate helicopter preflight inspection and the mechanic’s inadequate annual inspection, both of which failed to detect a worn bolt in the tail rotor teeter hinge prior to its fracture due to fatigue.NTSB ERA11LA264Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Meriden, CTMaintenance personnel's inadequate inspection of the main landing gear, which resulted in a failure of the right main landing gear’s inboard torque link lug due to a fatigue fracture. Contributing to the accident was owner's lack of compliance with a factory…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 ERA11CA187Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Oxford, CTThe student pilot's inadequate landing flare and the certified flight instructor's inadequate remedial action, resulting in a hard landing.NTSB ERA11CA138Accident · No injuriesData collectionFinal reportCessna 172 · Meriden, CTThe student pilot's loss of directional control during the landing rollout, resulting in a runway excursion.NTSB ERA11CA017Accident · No injuriesData collectionFinal reportCessna 120 · Falls Village, CTThe pilot’s failure to abort the takeoff, which resulted in an in-flight collision with terrain.NTSB ERA10CA440Accident · No injuriesData collectionFinal reportBeech P35 · Hartford, CTThe pilot's inadequate compensation for the crosswind, resulting in a loss of directional control during landing.NTSB ERA10CA278Accident · No injuriesData collectionFinal reportCessna 172S · East Haddam, CTThe pilot's delayed decision to attempt a go-around, and his subsequent failure to maintain directional control while landing.NTSB ERA10LA113Accident · 1 fatalLimited investigationFinal reportFoster John Glasair III · Oxford, CTThe pilot's failure to maintain a proper approach path during visual conditions at dusk, which resulted in an in-flight collision with power lines.NTSB ERA09LA531Accident · Minor injuriesLimited investigationFinal reportDaniel L Patrick Kolb Mark · Mystic, CTThe pilot's failure to maintain airspeed during final approach, resulting in an inadvertent stall. Contributing to the accident was the pilot's lack of total flight experience.NTSB ERA09LA339Accident · No injuriesLimited investigationFinal reportPilatus PC-12/47 · Bridgeport, CTThe flight crew's misjudgment of speed and distance, which resulted in an overrun of the wet runway.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 ERA09CA048Accident · No injuriesData collectionFinal reportCessna 172 · Groton, CTThe student pilot's failure to maintain directional control during landing.NTSB ERA09CA034Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-5B · Bridgeport, CTThe pilot's loss of directional control during landing and while suffering symptoms of vertigo.NTSB ERA09CA017Accident · No injuriesData collectionFinal reportCessna 182T · Manchester, CTThe in-flight collision with a bird.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 MIA08LA197Accident · Serious injuriesLimited investigationFinal reportBerrie Kolb Mark III · East Haddam, CTThe pilot's improper preflight inspection of the airplane. Contributing to the accident was water contamination of the fuel.NTSB NYC08CA295Accident · No injuriesData collectionFinal reportCessna 182A · Danielson, CTFuel exhaustion due to the pilot’s inadequate fuel consumption calculations.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.NTSB MIA08CA093Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Ellington, CTThe pilot's failure to perform a go-around when the airplane floated during landing.NTSB NYC08LA004Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Hartford, CTThe pilot's failure to maintain adequate clearance from a parked airplane while taxiing. Contributing to the accident was the proximity of the parked airplanes to the taxiway and the failure of the marshaller to provide adequate guidance.NTSB NYC07CA235Accident · No injuriesData collectionFinal reportCessna 172 · Meriden, CTThe student pilot's inadequate recovery from a bounced landing.NTSB NYC07CA240Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Bridgeport, CTThe pilot's failure to maintain directional control of the airplane during the landing. Contributing was the crosswind weather condition.NTSB NYC07CA161Accident · No injuriesData collectionFinal reportCessna 182Q · New Haven, CTThe pilot's improper flare which resulted in a hard landing. A factor to the accident was the wind gusts.NTSB ATL07CA091Accident · No injuriesData collectionFinal reportBeech C-23 · Plainville, CTThe pilot's improper use of rudder and brakes on landing roll out resulting in a loss of directional control, and collapse of the main landing gear.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 NYC07CA057Accident · No injuriesData collectionFinal reportFoley James Searey · Danbury, CTCollapse of the left main landing gear due to previous damage. A factor in the accident was the inadequate annual condition inspection.NTSB NYC07CA045Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Danbury, CTThe student pilot's inadequate recovery from a bounced landing, which resulted in a hard landing.NTSB NYC06LA219Accident · Minor injuriesLimited investigationFinal reportBeech F33A · South Windsor, CTA loosening of the fuel injector lines from the fuel manifold valve, which resulted in a partial loss of engine power.NTSB NYC06TA161Accident · No injuriesFinal reportBeech C90 · Windsor Locks, CTThe non-flying pilot's improper procedure, which resulted in his inadvertent retraction of the landing gear while the airplane was on the ground.NTSB NYC06FA137Accident · 2 fatalField investigationFinal reportGates Learjet 35A · Groton, CTThe crew's failure to properly monitor the airplane's altitude, which resulted in the captain's inadvertent descent of the airplane into water. Contributing to the accident were the foggy weather conditions, and the captain's decision to descend below the…NTSB NYC06CA108Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Chester, CTThe pilot's delayed decision to abort the takeoff, which resulted in an overrun. A factor in the accident was the pilot's inadequate preflight planning.NTSB NYC06CA057Accident · No injuriesData collectionFinal reportPiper PA-28-161 · New Haven, CTThe student pilot's improper flare and inadequate recovery from a bounced landing, which resulted in a loss of aircraft control during landing and subsequent impact with a ditch.NTSB NYC06CA056Accident · Serious injuriesData collectionFinal reportPiper PA-28-140 · East Killingly, CTThe flight instructor's delayed decision to discontinue the simulated forced landing, which resulted in a collision with trees.NTSB NYC06LA045Accident · Serious injuriesLimited investigationFinal reportBeech 23 · Chaplin, CTA complete loss of engine power due to carburetor ice. A contributing factor was the lack of suitable terrain for the emergency landing.NTSB NYC05LA139Accident · No injuriesLimited investigationFinal reportTerrio Pober Jr Ace · Oxford, CTA fractured oil pressure line, which resulted in the fracture of the number 3 cylinder connecting rod bearing, and subsequent loss of engine power.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 NYC05CA101Accident · No injuriesData collectionFinal reportValentin Taifun 17E · Waterbury, CTThe pilots inadvertent encounter with a downdraft, which resulted in the airplane impacting trees.NTSB NYC05CA090Accident · No injuriesData collectionFinal reportCessna 150G · Willimantic, CTThe student pilot's improper recovery from a bounced landing and his failure to maintain directional control while landing.NTSB IAD05FA068Accident · 2 fatalField investigationFinal reportCessna R182 · New Fairfield, CTFailure of the aluminum-clad, number two connecting rod bearings, which resulted in a total loss of engine power. A factor was the relatively short forced landing area.NTSB NYC05LA074Accident · Minor injuriesLimited investigationFinal reportBeech A36TC · Southbury, CTThe failure of the counter weight aft snap ring to hold the associated plate and pin in place, which resulted in a total loss of engine power.