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 NYC90LA026Accident · No injuriesLimited investigationFinal reportBeech A24R · Bridgeport, CTThe airplane engine throttle cable failed and the engine power reduced to idle over long island sound, resulting in the ditching of the airplane.NTSB NYC90LA019Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Windham, CTThe pilot's failure to achieve proper lift-off speed.NTSB NYC90FA011Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Glastonbury, CTThe pilot-in-command's failure to maintain adequate altitude control during maneuvering flight. Contributing to the accident was the failure of the airplane's electrical system and the pilot's operation at night, without emergency lighting (flashlight).NTSB NYC90LA008Accident · No injuriesLimited investigationFinal reportCessna 150 · Madison, CTA loss of engine power, due to a stuck exhaust valve in the number 4 cylinder. Factors related to the accident were: the pilot's excessive airspeed on final approach, and his failure to attain the proper touchdown point during the landing.NTSB NYC90LA005Accident · No injuriesLimited investigationFinal reportCessna 170B · Burlington, CTThe aircraft colliding with a steel drum placed on the runway by unknown person(s) to mark a pothole area.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 NYC89LA197Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-32 · Plymouth, CTImproper compensation for wind conditions by the pilot. A factor related to the accidetn was: the downdraft.NTSB NYC89LA192Accident · No injuriesLimited investigationFinal reportCessna R172K · Griswold, CTImproper flare by the pilot, and his failure to attain adequated airspeed for an aborted landing (go-around), which resulted in a loss of aircraft control.NTSB NYC89LA169Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Danbury, CTThe pilot's misjudgement of (excessive) airspeed, his failure to attain the proper touchdown point, and failure to make a go-around, while there was sufficient runway remaining. The fence was a related factor.NTSB NYC89LA174Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Stonington, CTThe pilot's inadvertent flight into instrument meteorological conditions (IMC) and his loss of aircraft control due to spatial disorientation. Factors related to the accident were: the environmental conditions (dark night & fog) and the pilot's lack of…NTSB NYC89LA151Accident · No injuriesLimited investigationFinal reportErcoupe Ercoupe 415C · Canaan, CTAn off airport landing in unsuitable terrain due to a power loss, caused by loose parts in the fuel pump.NTSB NYC89LA133Accident · No injuriesLimited investigationFinal reportNaval Aircraft Factory N3N · Canaan, CTA loss of power due to contamination of the fuel system.NTSB NYC89LA132Accident · No injuriesLimited investigationFinal reportCessna 150 · Woodstock, CTInadequate compensation for wind conditions by the pilot which resulted in not maintaining proper alignment with the runway. The crosswind and soft/wet terrain were contributing factors.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 NYC89LA069Accident · Minor injuriesLimited investigationFinal reportBeech S-35 · Bridgeport, CTThe improper fuel selector position and loss of power to the engine due to fuel exhaustion.NTSB NYC89LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Stratford, CTThe loss of engine power for undetermined reasons.NTSB NYC89FA059Accident · 1 fatalField investigationFinal reportBeech A36 · Bridgeport, CTTwice prior to being established on final the pilot was asked if he was getting proper indications for the approach to land. Contact was subsequently lost while the pilot was attempting to make an ILS approach to runway 06 at Bridgeport. The aircraft was…NTSB NYC89LA050Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Lyme, CTImproper planning; the student pilot became lost and ran out of fuel. During the landing he misjudged distance, altitude and airspeed and overran the field colliding with trees.NTSB NYC89LA049Accident · No injuriesLimited investigationFinal reportCessna 150L · Greenwich, CTTrees during an off airport landing after the aircraft expererienced a power loss fue to fuel starvation.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 NYC89LA034Accident · Serious injuriesLimited investigationFinal reportCessna 340 · Oxford, CTCollision with trees and terrain due to the pilot exceeding approach minimum altitude during an ILS approach.NTSB NYC89FA013Accident · Serious injuriesField investigationFinal reportBell 206L-1 · Wallingford, CTThe acft lost power and crashed in a tractor trailer parking lot, destroying the helicopter and causing serious injuries to the pilot and one passenger. The investigation revealed an improper fuel flow switch, which had no check valve protection installed on…NTSB NYC88LA240Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Burlington, CTThe plt was attempting to land at the mountain arpt. Patwas indicated the winds were from the north at 15 KTS. Gusts were not reported. The plt made her apch at 70 mph IAS and with 20 deg of flaps deployed. As she flared the acft, she encountered a gust of…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 NYC88LA232Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Windham, CTThe student pilot said she heard a popping sound during the takeoff roll and almost instantaneously the door came open. She tried to close the door and when that failed she attempted to abort. She retarded the throttle and attempted braking but it was not…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 NYC88LA182Accident · Minor injuriesLimited investigationFinal reportLake LA-4-200 · Candlewood Lake, CTThe LA-4-200 made a takeoff under reported conditions of gusty wind and waves of 1 to 2 feet. The maximum demonstrated wave height for the aircraft is 1 foot. The pilot reported he aborted the takeoff due to a person on a jet ski in his way and as he tried to…NTSB NYC88LA151Accident · 1 fatalLimited investigationFinal reportBeech 23 · Meriden, CTThe Beech 23 lost power during a go-around. During an off-airport landing, the acft struck a house. The private pilot died the following day of injuries and the flight instructor was seriously injured. There was no evidence of a large fuel spill and only…NTSB NYC88LA130Accident · No injuriesLimited investigationFinal reportBeech 35 · New Haven, CTDuring engine start the throttle jammed in the full forward position and could not be pulled back to the idle position to retard the power. The aircraft started rolling and collided with an unoccupied parked aircraft. Examination of the throttle control…NTSB NYC88LA126Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Windham, CTThe pilot took off and flew a short pattern around the airport. The pilot stated that on descent from 1200 feet strong winds started pushing the aircraft and he was losing control. The aircraft bounced and he decided to go around. However, on climb out the…NTSB NYC88FA093Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Stratford, CTThe pilot and pilot-rated pax received vectors for multiple ILS approaches in deteriorating conditions. On the first attempt the aircraft passed over witnesses but was off course and not in a position to land. The second attempt was aborted before reaching…NTSB NYC88LA082Accident · No injuriesLimited investigationFinal reportGulfstream AA-5B · Bridgeport, CTDuring a touch and go landing, the aircraft touched down on the main gear just past the numbers. Full right aileron and left rudder was used for directional control. During rollout, the right wing came up and the left wing made contact with the runway…NTSB NYC88LA070Accident · No injuriesLimited investigationFinal reportCessna 195 · Meriden, CTAfter performing several touch and go landings, the student pilot made a landing right of the center line. The aircraft drifted to the right, struck a snowbank, sheared off the left main landing gear, then groundlooped. The aircraft came to rest on the grass…NTSB NYC88LA039Accident · No injuriesLimited investigationFinal reportWaco ZKC-5 · No. Canaan, CTThe aircraft touched down in a 3-point landing attitude at north Canaan, Connecticut. The left landing gear wheel rotated 90 degrees and the left gear was dragged 144 yards before the aircraft became inverted. It was revealed that the braze joint at the top…NTSB NYC88LA031Accident · No injuriesLimited investigationFinal reportCessna 172 · Stamford, CTThe instructor (CFI) reported that the aircraft had just reached the top of a climb at 2500 ft when the engine lost power. An off airport landing was made on a golf course. During the landing, the wings struck trees and the aircraft was damaged. The golf…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 NYC88LA027Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Windham, CTThe flight departed groton, Connecticut enroute to willimantic, Connecticut in unlimited visibility. However at Windham airport, the runway was partially obscured by patchy fog according to the pilot. The pilot landed long due to carrying additional speed in…NTSB NYC88LA009Accident · No injuriesLimited investigationFinal reportCessna 140 · New Milford, CTThe flight en route was uneventful; however, during the landing at New Milford, CT, the aircraft's propeller struck the surface of the runway & the plane nosed over. The plt stated that he applied the brakes too harshly.NTSB NYC87LA266Accident · No injuriesLimited investigationFinal reportCessna 152 · Bridgeport, CTThe plt of Cessna 152, N93193, taxied for takeoff with the intentions of using rwy 24. At about the same time, a navy H-53 (Sikorsky) helicopter entered a pattern to land on rwy 24. With the heavy helicopter apchg to land, the Cessna plt accepted an offer to…NTSB NYC87FA252Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · East Granby, CTThe pilot departed simsbury airport on a x-country flight and crashed 4.5 miles to the north in bradley intl airport traffic area. Witnesses in the crash site area saw an aircraft flying in and out of clouds prior to hearing the crash.NTSB NYC87FA250Accident · 1 fatalField investigationFinal reportPiper PA-28-236 · Gaylordsville, CTThe pilot of the Piper PA-28-236 was cruising at 6000 ft at night when he reported a failure of his vacuum pump followed by loss of his attitude indicator and directional gyro. The aircraft was observed to make a 360 degree turn on the radar scope. The air…NTSB NYC87DNE05Accident · Minor injuriesFinal reportHall B-80M · Waterford, CTThe gyrocopter was observed to touch down and become airborne again. After becoming airborne it was observed to pitch down, with the main rotor blades striking the ground in front of the aircraft. The pilot said his right contact lens wasbothering him and he…NTSB NYC87LA213Accident · No injuriesLimited investigationFinal reportCessna 172P · Plainfield, CTWhile landing in crosswind conditions, the pilot failed to compensate for the conditions and lost directional control of the aircraft. The aircraft went down an embankment, collided with a fence and then flipped inverted.NTSB NYC87LA228Accident · No injuriesLimited investigationFinal reportCessna 172 · Groton, CTThe aircraft was taxiing to the ramp after landing. While the pilot was maneuvering the aircraft into a parking space, the aircraft was positioned in such a way that the sun had blinded him temporarily. As the pilot turned the aircraft the left wing contacted…NTSB NYC87DNE04Accident · 1 fatalFinal reportPiper PA-28-180 · Groton, CTShortly after the aircraft departed the airport, air traffic control personnel received a distress call from the non-pilot rated passenger. She stated that the pilot (her husband) was incapacitated by an apparent heart attack and she was not qualified to fly…NTSB NYC87LA243Accident · No injuriesLimited investigationFinal reportBeech C24R · Danbury, CTDuring a landing at late dusk, the aircraft collided with a deer that darted onto the runway. The pilot said there was no time to take evasive action before the collision. The left wing and left gear door were damaged and the left fuel tank was ruptured.NTSB NYC87DNE03Accident · No injuriesFinal reportNoble Falcon X-P · Wallingford, CTThe undetermined loss of engine power, and the pilot's poor aircraft handling during the resultant forced landing.NTSB NYC87LA158Accident · No injuriesLimited investigationFinal reportBeech 58TC · Oxford, CTThe flight was making an ILS approach to runway 36 in IMC. The aircraft touched down about 2,000 feet down the 5,000 foot runway and to the left of the runway centerline. The aircraft hydroplaned on standing water on the runway and skidded off the end coming…NTSB NYC87FA160Accident · 2 fatalField investigationFinal reportRobinson R22 Mariner · So. Windsor, CTA loss of control in flight for undetermined reasons.NTSB NYC87LA154Accident · No injuriesLimited investigationFinal reportCessna 172 · New Haven, CTDrg a night flt from new bedford to bridgeport, the plt enctrd visibility problems & believed that fuel consumption was higher than normal. He obtained radar vectors to New Haven. After seeing the arpt, he flew over to establish the runway pattern. However,…