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 NYC85LA026Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Waterford, CTN3772M (acft 'a') was on lndg roll on runway 15 when N19091 (acft 'b') initiated taxi across the runway. Acft 'a' swerved to avoid collision but inadequate clrnc was available. Right wing of acft 'a' collided with left wing of acft 'b'. Plt of acft 'b' stated…NTSB NYC85LA023Accident · No injuriesLimited investigationFinal reportBeech BE-55E · Groton, CTAs the acft broke out of the 300 overcast layer the plt saw birds flying off of the rwy threshold. Due to IFR conditions and low altitude the plt elected not to go around. The tower advised the plt of the birds on 2 mile final on the ILS apch.NTSB NYC85LA021Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Oxford, CTAfter entering the traffic pattern for the selected runway, plt was informed of surface wind conditions and elected to continue and execute a downwind landing. Upon touchdown, plt raised flaps to assist braking action. During roll-out the plt decided…NTSB NYC85LA002Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Waterbury, CTAfter liftoff, the plt initiated a turn into the crosswind to maintain runway heading. As he did so, a wind gust tipped the acft in the direction of the turn. Ground contact occurred before corrective control inputs by the plt could take effect.NTSB NYC84LA325Accident · No injuriesLimited investigationFinal reportPiper J-3 · Durham, CTThe plt attempted to land on a grass strip. The wind was reported to be from 270 degrees at 10 KTS. The plt stated that he experienced a change in wind direction and a gust. The acft then veered and collided with a stone wall.NTSB NYC84FNE06Accident · Minor injuriesFinal reportBell 206L-1 · Somers, CTPlt stated acft began to settle and roll to right from stable 3 foot hover. Application of left cyclic did not arrest roll and main rotor made ground contact. Plt had 11 hrs in this make & model.NTSB NYC84FA307Accident · 4 fatalField investigationFinal reportBell 206B · Wallingford, CTThe acft collided with wires after the plt announced by radio that he was going to make a low pass over the site of an outdoor event that he had just attended. Some witnesses saw the helicopter flying extremely low. It appeared that one of the landing skid…NTSB NYC84FA295Accident · 1 fatalField investigationFinal reportAero Commander 680V · Bridgeport, CTThe acft descended into the water six & 1/2 miles sw of Bridgeport, CT. The acft was on an ILS apch to rwy 06. The acft was in communication with NY TRACON arrvl radar and on his initial call had indicated a desire for a clearance direct tobridgeport. A brief…NTSB NYC84LA302Accident · No injuriesLimited investigationFinal reportCessna 305A · Madison, CTPurpose of flt was fam in this make/model for front seat plt by rear seat check-out plt. Preflight fuel quantity was checked by ref to gages only. Left tank read 1/2 full. Neither plt recalled rt tank reading. After takeoff, at about 150 ft, complete pwr loss…NTSB NYC84FA293Accident · No injuriesField investigationFinal reportCessna 150M · Meriden, CTA cesnna N45288 was above and slightly to the rear of Cessna N4669V when they collided on final approach over the displaced threshold to runway 36 at mmk. Both aircraft landed without further incident. There were no injuries.NTSB NYC84FNE05Accident · Serious injuriesFinal reportMooney M20C · Danbury, CTAn eng compartment fire occurred shortly after takeoff & smoke entered the cockpit. The plt then made a forced landing in a sand pit aprx 1 mi fm the arpt. He & the pax exited the acft with serious burns. An inv revealed an exhaust pipe had failed at a…NTSB NYC84LA272Accident · No injuriesLimited investigationFinal reportCessna 152II · E. Windsor, CTPlt failed to note inoperative airspeed indicator until well into takeoff run. When the defect was noted, takeoff abort procedures were performed but the acft continued beyond the airport boundary into a rough field and nosed over. Investigation revealed the…NTSB NYC84FNE04Accident · Serious injuriesFinal reportCessna 150H · Burlington, CTThe plt reported he 'picked up the acft after annual inspection', performed a preflt, made a standard run-up & took off in calm air conditions. After clmbing about 500 to 600 ft, the eng lost power & subsequently, the acft crash landed in a marsh. The plt was…NTSB NYC84LA242Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Thomaston, CTThe glider made an off-arpt landing after encountering unexpected strong head winds in a rapidly changing flow of marineair. The acft cleared obtacles on final but yawed and landed in a crab condition damaging the fuselage and wing tip wheel.NTSB NYC84LA288Accident · No injuriesLimited investigationFinal reportCessna 172PII · Madison, CTPlt stated groundspeed was fast during the flare and an abrupt touchdown was made 'fairly far' down the rwy. Plt reported, 'braking had not sufficiently slowed or stopped the plane as the plane neared the end of the runway, and it veered off to the right of…NTSB NYC84LA232Accident · No injuriesLimited investigationFinal reportRobinson R22 · Ellington, CTAfter being directed to do so by the arpt mgr the pilot was air taxiing to parking when the main rotor blades contacted one main rotor blade of a parked bell 206. The pilot related that he assumed he would clear the 206 since he was watching the airport mgr…NTSB NYC84LA231Accident · No injuriesLimited investigationFinal reportBell 206B · Somers, CTThe acft made a hard touchdown with the left side low. One side of the rotor came off and the other hit the engine according to one of the passengers aboard the acft. The plt said that the approach was normal and he brought the acft toa hover. However…NTSB DCA84AA027Accident · 3 fatalFinal reportLearjet 23A · Windsor Locks, CTAccording to witnesses, the acft made a normal apch to rwy 33 with no apparent abnormalities. However, when it was about 200 ft over the apch lights, they heard an increase in the eng thrust & the acft's descent stopped. Two plt witnesses thought the aircrew…NTSB NYC84LA198Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Ellington, CTAcft was on short final with 100 degree left x-wind 0F 10 KTS gusting to 15 KTS. When a gust occurred the left wing dragged the rwy and the acft cartwheeled.NTSB NYC84LA173Accident · No injuriesLimited investigationFinal reportBeech B19 · Danbury, CTThe plt stated while performing the last landing of the day a gust of wind blew the left wing up as the acft was being flared. The acft landed hard and bounced back into the air. A go-around was initiated but when another taxing acft was viewed in the…NTSB NYC84LA161Accident · No injuriesLimited investigationFinal reportCessna 152 · No.Stonington, CTWhile on a x-country flt, the student plt became lost & his fuel supply became low. He had difficulty contacting a ground station, but finally did so after receiving assistance from other plts. He was requested to squawk 7700 on his transponder, but the…NTSB NYC84FNE02Accident · Serious injuriesFinal reportBenson B8M · Willimantic, CTThe gyrocopter crashed after the plt lost control of the acft in a windy condition, during takeoff. A 20 degree x-wind velocity of 10 KTS gusting to 35 KTS existed at the time of the accident. The plt told his wife (who wrote the report on the 6120.1 NTSB…NTSB DCA84AA022Accident · 1 fatalFinal reportMitsubishi MU-2B-60 · Burlington, CTThe acft was flown earlier in the day for a sales demonstration. On the return flt, when the landing gear were lowered, the plt thought he heard a noise emitting from the gear, although cockpit indications were normal. The acft landed at johnnycake arpt & was…NTSB NYC84FA129Accident · 1 fatalField investigationFinal reportPiper PA-28R-201 · Burlington, CTThe acft crashed in a steep right descending turn shortly after takeoff. The student plt flying the acft had been scheduled to fly that day but the instructor canceled the flt on account of weather. The acft was seen taxiing out ABOUT1230. After takeoff the…NTSB NYC84LA134Accident · No injuriesLimited investigationFinal reportHughes 269A · Danbury, CTWhile in flt, the helicopter yawed & the eng RPM increased. The plt retarded the throttle to idle, lowered the collective & initiate an autorotation. While attempting to reach a suitable landing area, the plt kept his speed up to avoid buildings. However,…NTSB NYC84LA124Accident · No injuriesLimited investigationFinal reportBeech B19 · Simsbury, CTDuring an instructional flt, a landing was made during which control of the acft was lost and the acft collided with a snow bank hard enough to shear off one of the main landing gear. The other main gear collapsed but the nose gear did not. The instructor…NTSB NYC84FA108Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Groton, CTThe plt received 2 wx briefings prior to departing & both called for low ceilings. During arrival at the destination, the plt requested & was cleared for an ILS apch to rwy 5. While on the apch, the acft collided with a small tree & crashed. The wreckage came…NTSB NYC84LA100Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · New Haven, CTWhile taxiing in from landing and maneuvering for parking the acft contacted a light pole. The CFI was reportedly at theacft controls at the time of the collision. The right wing was damaged in the collision.NTSB NYC84IA091Incident · No injuriesIncident investigationFinal reportLockheed 382G · Groton, CTAfter landing on rwy 33, and during taxi to the ramp, the lt wing tip of the acft struck a parked DC-3.NTSB NYC84FA074Accident · 3 fatalField investigationFinal reportCessna P210N · Groton, CTThe acft was blown off course during a procedure turn for an ILS approach. The plt made a missed approach because of themisalignment and tried a non standard means of orientation for the 2nd attempt and intercepted the middle marker unexpectedly. Radar shows…NTSB NYC84FA053Accident · 2 fatalField investigationFinal reportCessna R182 · Greenwich, CTThe acft collided with trees during an ILS approach to westchester arpt in NY. The weather was IMC and an IFR flt plan was filed. The accident occurred during the 2nd attempt with the 1st ending in a missed approach. It was apparent to thecontroller that the…NTSB NYC84LA051Accident · No injuriesLimited investigationFinal reportCessna C172N · Meriden, CTThe acft collided with a dirt pile and nosed over during landing. According to the plt, he landed too FAR down the rwy, attempting an abort and the acft flipped over.NTSB NYC84LA021Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · New Milford, CTThe pilot reported that as he was starting the engine, fire broke out. He attempted to put out the fire with on-board extinguishers, but failed. The acft was destroyed by fire.NTSB NYC84LA004Accident · No injuriesLimited investigationFinal reportThorp T-18 · East Haddam, CTThe pilot stated that the first aprch was too high and he went around. On the second aprch, after flare, there was a gust of wind from the right and the acft lost lift. Power was added to reduce the sink rate, but the acft bounced and settled to the rwy. He…NTSB NYC83FNE05Accident · Serious injuriesFinal reportI.C.A. Brasov IS28B2 "LARK" · North Canaan, CTTwo witnesses observed the glider on a downwind that was, in their estimation, lower than normal. One witness reported observing the spoilers extended. The plt stated he extended the flaps on downwind, but had not used the spoilers. Duringthe turn to base…NTSB NYC83FA228Accident · Serious injuriesField investigationFinal reportBeech 58PA · Danbury, CTInbound to Danbury the plt was advised that the arpt was closed, & was given the last wx which was an hour old. The acft was observed to pass over the arpt 300-400 ft AGL & circle to land rwy 8. The acft turned base & final in a tight turn with the gear down.…NTSB NYC83FA198Accident · 3 fatalField investigationFinal reportCessna 210H · Marlborough, CTThe acft collided with trees and the ground during an approach to land on a foggy night at an arpt with no instrument approach facilities or control. The 67 year old plt had canceled his IFR flt plan at 2110 EDT. The accident occurred at 2115 EDT. The plt and…NTSB NYC83LA161Accident · No injuriesLimited investigationFinal reportCessna 172P · Redding, CTThe flight originated at ramapo, NY. During a preflight check, the plt noted that the fuel gauges indicated full. When he visually checked the fuel tanks, he estimated that the fuel level in each tank was about 1 inch from being full. The fuel capacity of…NTSB NYC83FNE03Accident · 1 fatalFinal reportBellanca 8KCAB · Madison, CTThe acft collided with the ground while performing aerobatic maneuvers during an airshow. Witnesses said it appeared that the pilot was having trouble staying in the assigned area for the maneuvers because of high winds. The winds were estimated at 20 KTS…NTSB NYC83FA141Accident · 4 fatalField investigationFinal reportBeech K35 · Ridgefield, CTShortly after takeoff, several witnesses heard unusual sounds from the acft. One stated that he heard a sputtering noise & the eng stopped, then it restarted, but was not smooth. The other 2 witnesses heard a backfiring or sputtering noise. Subsequently, the…NTSB NYC83FA122Accident · Serious injuriesField investigationFinal reportCessna 172N · N. Stonington, CTThe acft collided with a tree during a go-around at night following a downwind precautionary landing. During the flt the plt had noted the fuel gauges at low readings and said he suspected a 'fuel leak'. He made radio calls to try to go to an arpt before fuel…NTSB NYC83FA121Accident · 1 fatalField investigationFinal reportMooney M-20K · Old Lyme, CTThe acft collided with the ground in IMC after the plt reported he lost his vacuum instruments. The flt originated at mattituck, NY with a destination of lebanon, NH. After departure the plt was cleared to climb to 7000 ft. the instrumentrated pilot was on an…NTSB NYC83LA114Accident · No injuriesLimited investigationFinal reportCessna 150L · Waterford, CTThe acft experienced a power loss shortly after takeoff and collided with a tree during the forced landing. Before the flight the only fuel check described was looking at the fuel gauges which indicated one quarter to one third full. During takeoff at about…NTSB NYC83FA086Accident · No injuriesField investigationFinal reportCessna 210L · Avon, CTThe acft collided with a tree and broke the nose landing gear during an emergency landing after electrical failure. After the failure, using matches and a flashlight, the plt tried to land but could not find the arpt. The weather was deteriorating so when a…NTSB NYC83LA079Accident · No injuriesLimited investigationFinal reportCessna T210L · New Haven, CTAccording to an FAA interview, while on approach the plt did not identify the runway lights properly and landed to the left of the edge lights to runway 34. The acft landed off the runway in soft turf and the nose gear collapsed.NTSB NYC83LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Plainville, CTThe plt reported that just prior to a landing touchdown, he pushed the control yoke forward, then the acft hit the rwy and began to bounce. After the 4th bounce, the acft touched down on the rwy on the right wheel and yawed abruptly to the right. Reportedly,…NTSB NYC83FA072Accident · Minor injuriesField investigationFinal reportCessna 150J · Oxford, CTThe acft was last refueled on 11/28/82 & flown .2 hr to on arpt for an annual inspection. The annual was completed on 2/19/83. During the annual, an estimated .5 gal of fuel was drained from the acft & the eng was run about .2 hr. When the plt preflted the…NTSB NYC83LA058Accident · No injuriesLimited investigationFinal reportCessna 172P · Bridgeport, CTAfter practicing three takeoffs and landings, a fourth takeoff was aborted. The student completed a run-up, checked the controls and received clearance to takeoff. He stated that he began rolling straight down the centerline, then at about 45 KTS, the plane…NTSB NYC83LA057Accident · No injuriesLimited investigationFinal reportCessna 152 · Danbury, CTThe student plt was taking off on rwy 08 with a wind from the northeast at 11 KTS. He reported that he was aprx 100 ft into the takeoff roll when the acft swerved to the left. Subsequently, the acft collided with a snowbank on the left edge of the rwy.NTSB NYC83LA055Accident · No injuriesLimited investigationFinal reportCessna 152 · Meriden, CTAfter returning from an out-and-back x-country, the plt landed on a rwy with patches of ice. He stated that as the acft touched down, the left main wheel seemed to be frozen and skidded on a patch of ice. As the acft continued to skid, the left main wheel…