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 BFO93LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Griswold, CTThe pilot's improper planning or decision, by not either using all available runway or making a go around. The wet grass condition of the airstrip was a related factor.NTSB NYC93LA006Accident · Minor injuriesLimited investigationFinal reportSmitrovich SE-5A Replica · Harwinton, CTA forced landing in unsuitable terrain, following a power loss due to fuel exhaution. Factors related to the accident were the failure of the pilot to refuel the airplane prior to departure and his improper fuel consumption calculations which led to fuel…NTSB BFO92FA141Accident · 1 fatalField investigationFinal reportChampion 7KCAB · East Haddam, CTThe pilot's decision to attempt an aerobatic maneuver without adequate altitude for recovery.NTSB BFO92LA123Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Windham, CTThe pilot's improper IFR operation. Contributing was the pilot's instrument flight inexperience.NTSB NYC92LA183Accident · Minor injuriesLimited investigationFinal reportBeech A24 · Griswold, CTThe pilot failed to maintain control of the airplane which resulted in the airplane touching down short of the intended touchdown point, and collapsing the landing gear.NTSB NYC92LA181Accident · Minor injuriesLimited investigationFinal reportBeech A24 · Simsbury, CTA power loss due to a fuel line blocked with dirt and sludge, while operating over unsuitable terrain. A factor related to the accident was the failure of the owner/pilot to detect the dirt and sludge in the fuel system prior to takeoff.NTSB NYC92LA168Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Salem, CTThe pilot's inaccurate fuel calculations and his improper decision to takeoff with a known limited fuel supply resulting in fuel exhaustion and subsequent forced landing. Factors related to the accident were the pilot's lack of total flight experience and his…NTSB NYC92LA156Accident · No injuriesLimited investigationFinal reportCessna 152 · Plainville, CTFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. The embankment beside the runway was a related factor.NTSB NYC92LA152Accident · Minor injuriesLimited investigationFinal reportCessna 210J · Groton, CTA forced landing in unsuitable terrain as a result of a complete loss of engine power for unknown reasons.NTSB BFO92LA112Accident · No injuriesLimited investigationFinal reportJames Snyder Challenger II · Burlington, CTThe loss of engine power for undetermined reasons.NTSB BFO92LA090Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Woodstock, CTThe loss of engine power due to a cracked cylinder and the inadvertent aerodynamic stall that occurred during the precuationary landing.NTSB NYC92FA123Accident · 1 fatalField investigationFinal reportMBB BK-117 · Middletown, CTA wire strike after the pilot made a decision to continue the approach into an area of hazards. Factors related to the accident were the failure of the pilot and the hospital communicator to request all available information about the landing area and…NTSB NYC92LA106Accident · Minor injuriesLimited investigationFinal reportGlasair SH-2 · Danbury, CTImproper recovery from a bounced landing by the pilot which resulted in a propeller strike which made further flight not possible.NTSB NYC92LA098Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-32 · New Milford, CTInadequate visual lookout by the pilot which resulted in the glider striking a vehicle parked next to the runway.NTSB BFO92LA080Accident · No injuriesLimited investigationFinal reportPiper PA-60-602P · Danbury, CTThe national transportation safety board determines the probable cause of the accident was the pilot misjudged distance and altitude which resulted in an overrun of the runway.NTSB NYC92FA090Accident · 1 fatalField investigationFinal reportBeech A36 · Southbury, CTThe failure of the pilot to monitor his fuel supply which resulted in a power loss due to fuel exhaustion and an inadvertent stall/spin as the pilot was maneuvering for a forced landing. Factors related to the accident was improper maintenance on the fuel…NTSB 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 NYC92LA051Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260C · Stratford, CTWater/ice in the fuel system, which resulted in fuel starvation and a loss of engine power. Factors related to the accident were: freezing temperatures and inadequate pre-flight preparation by the pilot.NTSB NYC92LA038Accident · No injuriesLimited investigationFinal reportCessna 152 · Danbury, CTThe student pilot's improper preflight and planning which resulted in fuel system exhaustion and a forced landing on unsuitable terrain. A factor related to the accident was the pilot's lack of total experience.NTSB NYC92LA020Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Groton, CTThe pilot's failure to maintain the minimum descent altitude during the approach. A factor was pilot fatigue.NTSB NYC92LA005Accident · 1 fatalLimited investigationFinal reportAerospatiale ATR-42-320 · Bridgeport, CTThe employee's failure to follow proper procedures and the diversion of her attention which resulted in her being struck by a spinning propeller.NTSB NYC91LA249Accident · No injuriesLimited investigationFinal reportDavis D1K · Chester, CTImproper maintenance on the engine which resulted in a power loss due to a stuck exhaust valve and subsequent forced landing in unsuitable terrain.NTSB NYC91FA174Accident · 3 fatalField investigationFinal reportGulfstream American AA5B · Columbia, CTThe decision of the pilot to continue flight into instrument meteorological conditions, which resulted in an in flight collision with trees. Factors related to the accident were the pilot's lack of instrument flight expereince, his overconfidence in his…NTSB NYC91FA144Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · East Haddam, CTThe non-mechanical loss of engine power due to the failure of the pilot to use the auxiliary fuel boost pump during takeoff.NTSB NYC91FA145Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Wallingford, CTThe pilot attempting a VFR flight in adverse weather conditions, at an altitude that was insufficient to clear trees along his route of flight. Factors related to the accident were the pilot's lack of instrument rating, and his overconfidence to fly in…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 NYC91FA125Accident · No injuriesField investigationFinal reportBoeing 727-100QC · Windsor Locks, CTA catastrophic and uncontained failure of the no.3 engine which resulted in a fuel fed fire.NTSB NYC91LA124Accident · No injuriesLimited investigationFinal reportIsrael Aircraft Industries 1124A · Oxford, CTThe failure of the pilot to maintain the proper landing descent rate and the resultant right main landing gear assembly collapse.NTSB NYC91LA106Accident · No injuriesLimited investigationFinal reportCessna 172P · Burlington, CTThe failure of the pilot to maintain directional control during the landing. Factors related to the accident were: improper use of the flight controls by the pilot, his lack of recent experience and total time, and the crosswind.NTSB NYC91LA101Accident · No injuriesLimited investigationFinal reportBeech 56TC · New Haven, CTFailure of the pilot to maintain directional control after the nose wheel steering system failed.NTSB NYC91FA095Accident · 2 fatalField investigationFinal reportCessna 120 · Simsbury, CTThe pilot's intentional flight into terrain. Contributing to the accident were psychological conditions.NTSB NYC91LA043Accident · Minor injuriesLimited investigationFinal reportCessna 210L · New Haven, CTThe failure of the vehicle driver to adequately monitor the radio/traffic pattern. Factors related to the accident were: darkness, the aircraft's loss of electrical power after activating the runway lights and entering the pattern, and the lack of visual…NTSB NYC91DNE01Accident · No injuriesFinal reportCraig A. Gordon Teenie TWO · Oxford, CTThe failure of the pilot to maintain airspeed which resulted in an inadvertent stall and hard landing. Factors related to the accident were: the power loss and improper maintenance on the engine.NTSB NYC91LA017Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Bridgeport, CTThe pilot used excessive airspeed on the approach and landed long. The airplane went off the runway and struck a fence.NTSB NYC91FA006Accident · 2 fatalField investigationFinal reportCessna 152 · Griswold, CTA broken ehaust valve spring that resulted in a partial loss of power. Factors related to the accident were: darkness, lack of suitable terrain, and failure of the occupants to use their shoulder harnesses.NTSB NYC90LA207Accident · No injuriesLimited investigationFinal reportCessna 172P · Plainville, CTThe pilot lost control of the airplane during a cross wind landing, subsequently running off the side of the runway and collided with the terrain.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 NYC90LA146Accident · No injuriesLimited investigationFinal reportde Havilland DH-82-A · Burlington, CTThe pilot's inadequate compensation for the wind condition.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 NYC90LA136Accident · Minor injuriesLimited investigationFinal reportClassic Waco · Plymouth, CTThe failure of the pilot to correctly recover from a bounced landing. Factors related to the accident were: improper use of the brakes by the pilot.NTSB NYC90FA130Accident · 1 fatalField investigationFinal reportConsolidated Aeronautics LA-4-200 · Danbury, CTThe inadvertent stall. A factor was the pilot's misjudgement of the landing flare.NTSB NYC90LA109Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Warehouse Point, CTThe pilot failed to maintain directional control during a landing with a gusty crosswind.NTSB NYC90LA095Accident · No injuriesLimited investigationFinal reportBeech Baron 58 · Danbury, CTPilot factor in that the pilot elected to abort the takeoff with insufficient r/w remaining to stop the aircraft on the runway and collided with a fence, car & van.NTSB NYC90LA089Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Bridgeport, CTThe pilot failed to maintain directional control during a crosswind landing.NTSB NYC90LA065Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · E. Haddam, CTThe pilot failed to adequately compensate for wind conditions.NTSB NYC90FA063Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Fairfield, CTThe intoxicated pilot's failure to attain/maintain a safe altitude to provide clearance from the tree.NTSB NYC90LA056Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Danbury, CTImproper maintenance, inadequate surveillance by the company/operator, and inadequate preflight by the pilot, which resulted in a fire during an attempted engine start. A factor related to the accident was: the unsecured fuel line.NTSB NYC90LA031Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Simsbury, CTThe pilot's misjudgement of airspeed and distance during landing resulting in an overshoot and swerve off the runway. The dusk light conditions, snow, and frozen terrain were contributing factors to the accident.NTSB NYC90FA036Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Coventry, CTThe non-instrument rated pilot initiating VFR flight into IMC on a dark night which resulted in spatial disorientation and uncontrolled flight into the ground. Contributing factor(s) was: the adverse weather existing at the time of the accident and the…