NTSB investigations, CT

394 cases where the phase of flight was Landing.

Cases, newest first

Query with SQL
duckdb -csv -c "WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
    crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
    current_codes AS (
      SELECT e.case_mkey, TRY_CAST(e.\"tier1Number\" AS INTEGER) AS code,
        row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e.\"isDefiningEvent\", false) DESC, e.position) AS n
      FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
      WHERE e.aircrafts_position = 1 AND e.\"tier1Number\" GLOB '[1-9][0-9]*'
        AND (e.\"isDefiningEvent\" OR e.case_mkey IN (SELECT \"mKey\" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE \"isPre1982\"))
    ),
    phases AS (
      SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
      FROM current_codes WHERE n = 1
      UNION ALL
      SELECT o.case_mkey, 'older', o.\"phaseOfFlightCode\", w.main
      FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o.\"phaseOfFlightCode\"
      WHERE o.aircrafts_position = 1 AND o.\"occurrenceNumber\" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
    ),
    case_phases AS (
      SELECT p.*, c.\"eventDate\", c.\"highestInjuryLevel\" = 'Fatal' AS fatal, a.aircraft_model_code
      FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = p.case_mkey
      LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
      WHERE c.\"eventDate\" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
    )
  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 case_mkey FROM case_phases WHERE main = 550)
  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.

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 damageNTSB NYC85LA036Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Meriden, CTWhile in cruise, plt heard an abnormal sound from the left side of the engine compartment and having had previous problems with the newly-installed engine, elected to make a precautionary landing at a nearby arpt to investigate. Plt stated he landed long and…Dec 2, 1984 · N7453P · Substantial damageNTSB 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 damageNTSB 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…Nov 10, 1984 · N3772M · 2 aircraft · Substantial damageNTSB 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…Nov 4, 1984 · N38996 · Substantial damageNTSB 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.Sep 19, 1984 · N7456H · Substantial damageNTSB 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…Jul 12, 1984 · N54465 · Substantial damageNTSB 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 damageNTSB 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.Jun 4, 1984 · N5043F · Substantial damageNTSB 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 damageNTSB 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…Apr 1, 1984 · N18871 · Substantial damageNTSB 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.Dec 10, 1983 · N104CT · Substantial damageNTSB 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 damageNTSB 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.Mar 20, 1983 · N121RJ · Substantial damageNTSB 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 damageNTSB 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…Jan 21, 1983 · N67897 · Substantial damageNTSB 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.Nov 10, 1982 · N24293 · Substantial damageNTSB 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…Nov 3, 1982 · N7423R · Substantial damageNTSB 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.Jul 29, 1982 · N4547K · Substantial damageNTSB 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.Jun 18, 1982 · N3622Q · Substantial damageNTSB 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…May 27, 1982 · N9072Q · Substantial damageNTSB 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 damageNTSB 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…Jan 27, 1982 · N4918H · Substantial damageNTSB NYC82FNE02Accident · Serious injuriesClosedSchweizer 2-33 · Plymouth, CTNov 14, 1981 · N2040T · Substantial damageNTSB NYC81FNE20Accident · No injuriesClosedSchweizer 2-33 · Plymouth, CTMay 17, 1981 · N7789S · Substantial damageNTSB NYC81FNE19Accident · No injuriesClosedCessna 182 · East Haddam, CTMay 8, 1981 · N1966X · Substantial damageNTSB NYC81FNE02Accident · No injuriesClosedBellanca 7ECA · Winsor Locks, CTNov 2, 1980 · N2684G · Substantial damageNTSB NYC81FNE01Accident · No injuriesClosedBeech C23 · Ellington, CTOct 22, 1980 · N67168 · Substantial damageNTSB NYC80DA074Accident · No injuriesClosedPiper PA-23 · Hartford, CTAug 20, 1980 · N62656 · Substantial damageNTSB NYC80FNE16Accident · No injuriesClosedCessna 150 · Meriden, CTMay 23, 1980 · N6204T · Substantial damageNTSB NYC80FNE15Accident · No injuriesClosedMooney M20E · Danielson, CTMay 5, 1980 · N7198V · Substantial damageNTSB NYC80FNE07Accident · No injuriesClosedCessna 172 · Burlington, CTDec 29, 1979 · N2416L · Substantial damageNTSB NYC79FA070Accident · No injuriesClosedCessna 172L · Simsbury, CTJul 30, 1979 · N4324Q · 2 aircraft · Substantial damageNTSB NYC79FA059Accident · No injuriesClosedCessna 172M · Griswold, CTJul 14, 1979 · N73297 · Substantial damageNTSB NYC79FNE16Accident · No injuriesClosedCessna 172 · Ellington, CTJun 6, 1979 · N13435 · Substantial damageNTSB NYC79FNE13Accident · No injuriesClosedCessna 172 · E Windsor, CTMar 25, 1979 · N5617A · Substantial damageNTSB NYC79FNE11Accident · No injuriesClosedPiper PA-28 · Madison, CTMar 9, 1979 · N4765F · Substantial damageNTSB NYC79FNE10Accident · Minor injuriesClosedPiper PA-32 · Danielson, CTMar 9, 1979 · N3096T · Substantial damageNTSB NYC79FNE06Accident · No injuriesClosedBeech B55 · Windsor Locks, CTJan 31, 1979 · N1861L · Substantial damageNTSB NYC78FNE32Accident · Minor injuriesClosedPiper PA-18 · Canaan, CTSep 9, 1978 · N5980D · Substantial damageNTSB NYC78FNE34Accident · Minor injuriesClosedPiper PA-16 · N.Stonington, CTSep 2, 1978 · N5791H · Substantial damageNTSB NYC78FNEZBAccident · No injuriesClosedCessna 172 · Plainville, CTJul 29, 1978 · N5497V · Substantial damageNTSB NYC78FNE29Accident · No injuriesClosedCessna 172 · Essex, CTJul 29, 1978 · N1641V · Substantial damageNTSB NYC78FNE24Accident · No injuriesClosedCessna 150 · Woodstock, CTJul 1, 1978 · N4583U · Substantial damageNTSB NYC78FNE19Accident · No injuriesClosedCessna 140 · Plainville, CTApr 29, 1978 · N9949 · Substantial damageNTSB NYC78FNE18Accident · No injuriesClosedCessna 177 · Hartford, CTApr 12, 1978 · N42118 · Substantial damageNTSB NYC78FNE17Accident · No injuriesClosedCessna 172M · East Windsor, CTApr 1, 1978 · N12219 · Substantial damageNTSB NYC78FNE16Accident · Serious injuriesClosedPiper PA-28R · Oxford, CTMar 31, 1978 · N47568 · DestroyedNTSB NYC78FNE06Accident · No injuriesClosedPiper PA-28 · Stratford, CTJan 29, 1978 · N7906W · Substantial damageNTSB NYC78FNE05Accident · No injuriesClosedPiper PA-28R · Ellington, CTJan 22, 1978 · N7445J · Substantial damage