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 NYC83FA052Accident · No injuriesField investigationFinal reportRobinson R22 · Milford, CTThe helicopter collided with a telephone pole during an autorotation forced landing after an engine malfunction. The aircraft was cruising at 500 feet when there was an audible decrease in main rotor and engine RPM. The rotor RPM was between 80-85 percent…NTSB NYC83LA036Accident · No injuriesLimited investigationFinal reportFokker F-27-100 · New Haven, CTAircraft collided with a power cart as taxi to takeoff began.NTSB NYC83LA027Accident · No injuriesLimited investigationFinal reportCessna 402 · Danielson, CTOn final the pilot realized he was late in reducing power and attempted to correct by abruptly bringing power back. A high sink rate was experienced and the pilot immediately applied full power. The aircraft impacted short of the runway.NTSB NYC83LA026Accident · No injuriesLimited investigationFinal reportCessna C152 · Ellington, CTDuring landing, the aircraft hit hard on all three landing gear and bounced about 3 or 4 feet, landing on the nose gear. The left wing, prop, nose gear and cowling were damaged.NTSB NYC83LA019Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Willimatic, CTOn the second approach to the airport, after executing a go-around on the first, the pilot encountered ground fog. In zero visibility, at 3-5 feet above the ground, the pilot elected to execute a "controlled crash" rather than attempt a transition to…NTSB NYC83FNE01Accident · Serious injuriesFinal reportFairchild M-62A-3 · Durham, CTDuring a climb to a higher altitude the engine failed. The plt attempted a 180 deg turn to land at an arpt but was unable to make it to the arpt. The acft touched down approximately 15 ft before impacting a barn.NTSB NYC82DA220Accident · Minor injuriesFinal reportCessna 150G · East Haddam, CTThe pilot reported that just prior to flaring, the aircraft had started drifting to the left; therefore, a decision was made to abort the landing. A go-around was initiated and flap retraction was started. However, the aircraft stalled and landed in a swamp.NTSB NYC82DA204Accident · No injuriesFinal reportCessna 195A · Wallingford, CTThe pilot reported that when he preflighted the aircraft, the fuel tanks were full. Fuel was drained from each wing and the fuselage low point with no indication of water. During takeoff, engine power was lost at an altitude of about 150 ft as the manifold…NTSB NYC82FA188Accident · 1 fatalField investigationFinal reportCessna 310R · Danbury, CTApproaching the destination arpt, the plt was advised to plan a VOR rwy 24 approach & that he would be turned just inside the faf. At 0055, newark a/c identified the acft 3 mi north of the arpt still at 2,000 ft & asked the plt if he was able to execute the…NTSB NYC83LA017Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Burlington, CTThe pilot began taking off on runway 19 with a right crosswind. Reportedly, a strong gust of wind was encountered and the aircraft veered off the left side of the runway. It headed toward the opening of a culvert that went under the runway. To avoid the…NTSB NYC82DA171Accident · No injuriesFinal reportGrumman AA-5B · Madison, CTThe pilot stated that he experienced a sudden wind shift when over the runway threshold. The aircraft was landed to the right of the runway after an attempted go-around was aborted because of trees and buildings at the departure end/left side of the runway.NTSB NYC82DA163Accident · No injuriesFinal reportCessna 150H · Ansonia, CTThe pilot flew to another local airport to practice touch and go landings. During the takeoff from the 1750 foot runway the aircraft stalled into the trees. The pilot stated that the aircraft settled into the tree tops when he maneuvered to avoid power lines.NTSB NYC82DA138Accident · No injuriesFinal reportGrumman AA-1C · West Haven, CTThe student pilot departed bridgeport, CT at 1200 hours and arrived at nantucket, ma at 1345 hours. While en route, he made a touch-and-go at fishers island and practiced stall maneuvers. He departed nantucket at about 1430 hours without refueling.…NTSB NYC82DA126Accident · No injuriesFinal reportBeech A23-19 · Plainville, CTThe pilot lost directional control on the second landing roll and swerved off runway onto a railroad track.NTSB NYC82DA109Accident · No injuriesFinal reportRobinson R-22 · Danbury, CTDuring a practice autorotation, just prior to flare, a loud noise was heard and the pilot stated that the aircraft veered to the right. A partial flare was made and after making contact with the ground the helicoper bounced back into the air. The rotor blades…NTSB NYC82DA108Accident · No injuriesFinal reportCessna 152 · Burlington, CTThe student pilot was on her second supervised solo flight. While landing, she flared high and subsequently landed hard, collapsing the nose gear. The pilot reported that she did not have a good mental attitude since her children had been involved in a car…NTSB NYC82DA106Accident · No injuriesFinal reportSchleicher ASW-15 · Plymouth, CTThe pilot stated that he thought he heard the rudder pedals click into their detented/locked position when they were adjusted before takeoff. However, while being towed for takeoff, the rudder pedals slipped forward about 1 to 2 inches. The pilot reached down…NTSB NYC82DA081Accident · No injuriesFinal reportMooney M20J · Madison, CTThe pilot reported that during takeoff, the engine lost power at about 30 ft AGL. He switched tanks and checked that the boost pump was on, but the engine did not restart. The plane was landed in a marsh where it flipped over during touchdown. An inspection…NTSB NYC82DA068Accident · No injuriesFinal reportCessna 150M · Washington, CTWhile practicing power on stalls and gliding turns the pilot stated that the engine would not respond with half throttle. A forced landing was made after passing up two rough fields for a more distant one at a higher altitude. The pilot stated he should have…NTSB NYC82FA050Accident · 1 fatalField investigationFinal reportCessna T337C · Bloomfield, CTAt 0630 & 0800 the plt received wx briefing for an IFR flt to bridgeport, CT & was advised of flt precautions for icing, low ceilings & visibilities. The flt departed at 0907. At 1118 the plt diverted to windsor locks for landing at bradley intl arpt because…NTSB NYC82FNE03Accident · Serious injuriesFinal reportPiper PA-28-140 · Ellington, CTThe aircraft was allowed to warm up for 5 to 10 minutes at end of the runway before takeoff. The instructor pilot (ip) reported that the before takeoff run-up was made by using the checklist and all engine instruments were in-the-green. He reported that…NTSB NYC82AA028Accident · Serious injuriesFinal reportBeech 99 · Groton, CTAfter crossing the mondi intersection inbound for an ILS rwy 5 apch, the captain felt that a proper descent was not possible due to a strong tailwind & their present altitude. They turned & proceeded outbound to loose altitude. The crewthen established…NTSB NYC82DA027Accident · No injuriesFinal reportCessna 152 · Ansonia, CTAfter departure from bridgeport on a local instructional flight, it was decided that a landing would be made at the Ansonia airport. The instructor reported that there was no NOTAM concerning hazardous runway conditions at Ansonia. During landing, the…NTSB NYC82FNE02Accident · Serious injuriesClosedSchweizer 2-33 · Plymouth, CTNTSB NYC81FNE31Accident · No injuriesClosedErco 415-D · Danbury, CTNTSB NYC81FA079Accident · 2 fatalClosedRobinson R-22 · Granby, CTNTSB NYC81FNE27Accident · No injuriesClosedSchweizer 1-23H · Plymouth, CTNTSB NYC81FNE26Accident · No injuriesClosedPiper PA-24 · E.Hartford, CTNTSB NYC81FNE24Accident · Minor injuriesClosedCessna 152 · Berlin, CTNTSB NYC81FA062Accident · 2 fatalClosedAerostar 601P · Oxford, CTNTSB NYC81FA060Accident · 1 fatalClosedChance Vogt F4U-4 · Stratford, CTNTSB NYC81FNE20Accident · No injuriesClosedSchweizer 2-33 · Plymouth, CTNTSB NYC81FA046Accident · No injuriesClosedErco 415-D · Terryville, CTNTSB NYC81FNE19Accident · No injuriesClosedCessna 182 · East Haddam, CTNTSB NYC81FNE14Accident · No injuriesClosedCessna 152 · Canaan, CTNTSB NYC81FNE13Accident · No injuriesClosedCessna 150 · Mansfield, CTNTSB NYC81FNE08Accident · Serious injuriesClosedCessna 182 · Ellington, CTNTSB NYC81FNE06Accident · Serious injuriesClosedPiper PA-28 · Chester, CTNTSB NYC81FNE05Accident · Minor injuriesClosedPiper J-3 · Coventry, CTNTSB NYC81IA015Incident · Minor injuriesClosedNord 262A12 · Groton, CTNTSB NYC81FAMS1Accident · 4 fatalClosedPiper PA-31 · Bridgeport, CTNTSB NYC81FNE02Accident · No injuriesClosedBellanca 7ECA · Winsor Locks, CTNTSB NYC81FNE01Accident · No injuriesClosedBeech C23 · Ellington, CTNTSB NYC80DA074Accident · No injuriesClosedPiper PA-23 · Hartford, CTNTSB NYC80FA068Accident · 3 fatalClosedCessna 172 · Burlington, CTNTSB NYC80DA067Accident · Minor injuriesClosedHiller Acft UH-12C · Meriden, CTNTSB NYC80FNE23Accident · Serious injuriesClosedCessna 152 · Berlin, CTNTSB NYC80FNE21Accident · No injuriesClosedCessna 150G · Franklin, CTNTSB NYC80FNE20Accident · No injuriesClosedPiper J3C-65 · Windham, CTNTSB NYC80FNE19Accident · Serious injuriesClosedStinson 108-1 · Windham, CT