Skip to content

NTSB investigations, CT

26 cases where the first occurrence was “Hard landing”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

Where

Latest cases

Query with SQL

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' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 200) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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'
    AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 200)
  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'
  AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 200)
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 NYC07CA235Accident · No injuriesData collectionFinal reportCessna 172 · Meriden, CTThe student pilot's inadequate recovery from a bounced landing.Sep 21, 2007 · N7837G · Substantial damage 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.Jul 8, 2007 · N759BY · Substantial damage 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.Dec 11, 2006 · N44635 · Substantial damage NTSB IAD05CA054Accident · No injuriesData collectionFinal reportClark/Loken Christen Eagle II · South Woodstock, CTThe pilot's improper flare, which resulted in a hard landing.Apr 10, 2005 · N130MC · Substantial damage NTSB NYC04CA145Accident · No injuriesData collectionFinal reportCessna 172R · Hartford, CTThe student pilot's improper flare and inadequate compensation for wind conditions. A factor was the gusty winds.Jun 21, 2004 · N356ES · Substantial damage NTSB NYC04CA104Accident · No injuriesData collectionFinal reportCessna 172N · Bridgeport, CTThe pilot's inadequate compensation for wind conditions and his failure to maintain aircraft control which resulted in a hard landing. A factor was the gusty winds.Apr 10, 2004 · N6583D · Substantial damage NTSB NYC02LA045Accident · No injuriesLimited investigationFinal reportCessna 182 · Danbury, CTThe student pilot's improper flare and recovery from a bounced landing.Dec 31, 2001 · N42766 · Substantial damage NTSB IAD98LA112Accident · No injuriesLimited investigationFinal reportCessna 152 · Oxford, CTThe pilot's improper flare and inadequate recovery from a bounced landing. A factor was the pilot's lack of experience.Sep 26, 1998 · N89644 · Substantial damage NTSB IAD98LA111Accident · No injuriesLimited investigationFinal reportCessna 152 · Danbury, CTThe pilot's improper flare and improper recovery from a bounced landing.Sep 25, 1998 · N94784 · Substantial damage NTSB NYC96LA133Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bridgeport, CTthe student pilot's improper flare and improper recovery from a bounced landing, which resulted in a hard landing.Jun 29, 1996 · N8119H · Substantial damage NTSB NYC96LA033Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Meriden, CTThe pilot's improper flare and improper recovery from a bounced landing. The unfavorable wind condition was a related factor.Dec 3, 1995 · N2226Z · Substantial damage NTSB NYC94LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Ellington, CTThe student pilot's improper recovery from a bounced landing which resulted in a loss of directional control. A factor was the student pilot's imroper landing flare, which resulted in a hard landing.May 3, 1994 · N5369H · Substantial damage NTSB BFO94LA065Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Willimantic, CTThe instructor's inadequate supervision and the student's improper landing flare.Apr 4, 1994 · N30DW · Substantial damage NTSB NYC93LA053Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Oxford, CTThe pilot's improper level off which resulted in a hard landing. Contributing were wind gusts and the pilot's inadequate compensation for wind conditions.Dec 20, 1992 · N5135L · Substantial damage 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.Jun 10, 1992 · N155JL · Substantial damage 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.May 1, 1991 · N445BL · Substantial damage 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.Jun 15, 1990 · N76KK · Substantial damage 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.Aug 5, 1989 · N758QB · Substantial damage NTSB NYC86LA222Accident · No injuriesLimited investigationFinal reportCessna 170B · Danbury, CTThe aircraft bounced on touchdown, but then settled back to the runway with the tail swinging to the left. Hard left brake was applied but the pilot could not maintain direction control and the aircraft ran off the runway into the turf striking the left wing…Aug 30, 1986 · N2292D · Substantial damage NTSB NYC85LA142Accident · No injuriesLimited investigationFinal reportCessna 152 · Hartford, CTThe acft nosed over following a loss of control during landing. The student plt stated the acft bounced three times on touchdown. The propeller then contacted the rwy and the acft nosed over.Jun 30, 1985 · N48251 · Substantial damage NTSB NYC85LA034Accident · No injuriesLimited investigationFinal reportCessna 172P · Madison, CTPlt stated that as he lowered nose gear to runway following initial touchdown on mains, acft nose continued to drop. Control inputs were not effective. Investigation revealed the nose gear ass'y failed in overload. Based on fuel remaining on board and…Nov 25, 1984 · N89929 · Substantial damage 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…Jul 4, 1984 · N5003X · Substantial damage 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…May 15, 1984 · N6539R · Substantial damage 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…Oct 9, 1983 · N4860S · Substantial damage 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,…Mar 16, 1983 · N6298M · Substantial damage 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…May 27, 1982 · N757HG · Substantial damage