NTSB investigations, CT

167 cases where the phase of flight was Approach.

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 = 500)
  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 BFO92LA123Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Windham, CTThe pilot's improper IFR operation. Contributing was the pilot's instrument flight inexperience.Sep 5, 1992 · N3751R · DestroyedNTSB NYC92FA123Accident · 1 fatalField investigationFinal reportMBB BK-117 · Middletown, CTA wire strike after the pilot made a decision to continue the approach into an area of hazards. Factors related to the accident were the failure of the pilot and the hospital communicator to request all available information about the landing area and…Jun 21, 1992 · N117HH · DestroyedNTSB NYC92LA020Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Groton, CTThe pilot's failure to maintain the minimum descent altitude during the approach. A factor was pilot fatigue.Oct 27, 1991 · N14256 · Substantial damageNTSB NYC91FA006Accident · 2 fatalField investigationFinal reportCessna 152 · Griswold, CTA broken ehaust valve spring that resulted in a partial loss of power. Factors related to the accident were: darkness, lack of suitable terrain, and failure of the occupants to use their shoulder harnesses.Oct 8, 1990 · N4708M · DestroyedNTSB NYC90LA190Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Burlington, CTThe CFI failed to maintain a safe sink rate resulting in an undershoot of the runway.Aug 12, 1990 · N24698 · DestroyedNTSB NYC90LA146Accident · No injuriesLimited investigationFinal reportde Havilland DH-82-A · Burlington, CTThe pilot's inadequate compensation for the wind condition.Jul 4, 1990 · N82DH · Substantial damageNTSB 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.Aug 19, 1989 · N414LF · Substantial damageNTSB 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…Dec 24, 1988 · N262C · DestroyedNTSB NYC89LA034Accident · Serious injuriesLimited investigationFinal reportCessna 340 · Oxford, CTCollision with trees and terrain due to the pilot exceeding approach minimum altitude during an ILS approach.Nov 20, 1988 · N468CM · DestroyedNTSB 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…Sep 24, 1988 · N3099X · Substantial damageNTSB 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…May 29, 1988 · N6042X · Substantial damageNTSB 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…Feb 20, 1988 · N2469M · DestroyedNTSB 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,…May 24, 1987 · N65482 · Substantial damageNTSB NYC87LA093Accident · No injuriesLimited investigationFinal reportMooney M20J · Plainville, CTDuring landing, the pilot came in high and fast, pilot stated that aircraft seemed to float down the runway and when the wheels touched down, the aircraft bounced. Bouncing for the third time, the pilot added full throttle and raised the flaps. However the…Feb 22, 1987 · N222NS · Substantial damageNTSB NYC86LA142Accident · No injuriesLimited investigationFinal reportCessna 172 · Oxford, CTDuring an attempted go around, the aircraft stalled. The aircraft then veered left and collided with the ground. The aircraft came to rest about 100 feet off to the side of the runway on the grassy area.Jun 3, 1986 · N7475G · Substantial damageNTSB NYC86FA096Accident · 5 fatalField investigationFinal reportPiper PA-24-180 · Somers, CTThe acft, on a night flt, was seen flying about 1 mi west of ellington arpt. A witness saw the acft flying north and just above the 800 ft high terrain. The acft was in a gradual descent and it appeared that it would not clear terrain ahead. Afterwards the…Mar 31, 1986 · N6599P · DestroyedNTSB NYC86FA057Accident · 2 fatalField investigationFinal reportCessna 182L · So.Glastonbury, CTThe acft was on a VOR instrument apch when it collided with 250 ft high terrain approx 6 miles south of the arpt and approx 2 miles north of the vor/faf. Shortly before the accident the pilot notified ATC that he was in turbulence; then reported he was clear…Jan 3, 1986 · N3349R · DestroyedNTSB NYC86LA055Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Ellington, CTWhile on apch for landing, about 50 ft from the rwy, the landing gear contacted a bridge and the acft bounced into the air. Pwr was added at this time and again the acft bounced. The acft was then landed on the rwy and it skidded to a stop. The plt stated she…Dec 28, 1985 · N7571P · Substantial damageNTSB NYC85LA235Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Madison, CTWhile on the downwind leg for rwy 24, the instructor reduced power to idle for engine failure simulation. The student made a short approach and upon reaching 700 ft AGL the student headed directly toward the approach end of the rwy at a 30 deg angle from rwy…Sep 15, 1985 · N2387P · Substantial damageNTSB NYC85LA177Accident · No injuriesLimited investigationFinal reportSikorsky S-76A · Hartford, CTThe apch to the pvt helipad was uneventful up to the last 100 ft where the plts noticed a high sink rate. The plt increased collective to correct for the situation. At about 20 ft from touchdown point the plt noticed a decrease in RPM and realized that they…Jul 14, 1985 · N3124L · Substantial damageNTSB NYC85LA128Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Ellington, CTThe acft colldied with a stump during a landing attempt at Ellington arpt. The acft had touched dwn about 25 ft short of the rwy. The left aileron was damaged but the acft made a go-around & returned to westover air base & landed. According to the plt,…May 19, 1985 · N300UM · Substantial damageNTSB NYC85FA104Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · East Haddam, CTDuring approach to runway 14 pilot decided to go around. Aircraft turned left about 90 degrees and collided with rising terrain .2 NM east of the runway. The rising terrain parallels runway 14.Apr 10, 1985 · N55408 · DestroyedNTSB NYC85FNE01Accident · Serious injuriesFinal reportMarr/Eckburg Long EZE · Waterbury, CTThe acft crashed into an embankment short of rwy 36 after a loss of pwr on final approach. The plt said he was operating on the rt tank when the eng quit. He immediately awitched to the left tank and activated the boost pump. The prop had stopped and the acft…Mar 19, 1985 · N49EZ · Substantial damageNTSB 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.Nov 5, 1984 · N62561 · Substantial damageNTSB 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.Aug 26, 1984 · N45288 · 2 aircraft · Minor damageNTSB 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…Jun 5, 1984 · N101PP · DestroyedNTSB 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…May 7, 1984 · N25369 · Substantial damageNTSB 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…Mar 14, 1984 · N5022S · DestroyedNTSB 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…Jan 25, 1984 · N900FE · DestroyedNTSB 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…Dec 13, 1983 · N2254T · DestroyedNTSB 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…Sep 24, 1983 · N87RW · Substantial damageNTSB 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.…Aug 28, 1983 · N158JB · DestroyedNTSB 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…Aug 1, 1983 · N1968X · DestroyedNTSB 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…Feb 26, 1983 · N60619 · Substantial damageNTSB 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.Nov 10, 1982 · N4032Q · Substantial damageNTSB 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.Sep 9, 1982 · N3601J · Substantial damageNTSB 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…Aug 9, 1982 · N98841 · DestroyedNTSB 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…Mar 11, 1982 · N7721X · DestroyedNTSB 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…Feb 1, 1982 · N451C · DestroyedNTSB NYC81FNE27Accident · No injuriesClosedSchweizer 1-23H · Plymouth, CTAug 23, 1981 · N8632R · Substantial damageNTSB NYC81FNE26Accident · No injuriesClosedPiper PA-24 · E.Hartford, CTAug 13, 1981 · N6939P · Substantial damageNTSB NYC81FNE06Accident · Serious injuriesClosedPiper PA-28 · Chester, CTDec 12, 1980 · N6348R · Substantial damageNTSB NYC80FA034Accident · No injuriesClosedBeech 95-C55 · Hartford, CTApr 10, 1980 · N466AS · Substantial damageNTSB NYC80FNE08Accident · No injuriesClosedMooney M20E · Williamantic, CTJan 5, 1980 · N9265V · Substantial damageNTSB NYC80FA016Accident · 2 fatalClosedPiper PA-28 · Broad Brook, CTDec 28, 1979 · N16436 · DestroyedNTSB NYC80FNE05Accident · Minor injuriesClosedSchweizer SGS233 · Terryville, CTNov 24, 1979 · N2930H · Substantial damageNTSB NYC80FA002Accident · 2 fatalClosedCessna 310R · Bethlehem, CTOct 3, 1979 · N87369 · DestroyedNTSB NYC79FNE19Accident · No injuriesClosedLuscombe 8E · Plainville, CTAug 17, 1979 · N2476K · Substantial damageNTSB NYC79FA071Accident · 3 fatalClosedPiper PA-30 · Groton, CTJul 31, 1979 · N8602Y · Substantial damageNTSB NYC79FNE02Accident · Minor injuriesClosedBeech V35A · Chester, CTDec 8, 1978 · N7125N · Destroyed