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.
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" DESCRun 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 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.NTSB 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…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…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 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 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 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 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 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 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 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 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 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 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…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 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 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 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 NYC81FNE20Accident · No injuriesClosedSchweizer 2-33 · Plymouth, CTNTSB NYC81FNE19Accident · No injuriesClosedCessna 182 · East Haddam, CTNTSB NYC81FNE02Accident · No injuriesClosedBellanca 7ECA · Winsor Locks, CTNTSB NYC81FNE01Accident · No injuriesClosedBeech C23 · Ellington, CTNTSB NYC80DA074Accident · No injuriesClosedPiper PA-23 · Hartford, CTNTSB NYC80FNE16Accident · No injuriesClosedCessna 150 · Meriden, CTNTSB NYC80FNE15Accident · No injuriesClosedMooney M20E · Danielson, CTNTSB NYC80FNE07Accident · No injuriesClosedCessna 172 · Burlington, CTNTSB NYC79FA070Accident · No injuriesClosedCessna 172L · Simsbury, CTNTSB NYC79FA059Accident · No injuriesClosedCessna 172M · Griswold, CTNTSB NYC79FNE16Accident · No injuriesClosedCessna 172 · Ellington, CTNTSB NYC79FNE13Accident · No injuriesClosedCessna 172 · E Windsor, CTNTSB NYC79FNE11Accident · No injuriesClosedPiper PA-28 · Madison, CTNTSB NYC79FNE10Accident · Minor injuriesClosedPiper PA-32 · Danielson, CTNTSB NYC79FNE06Accident · No injuriesClosedBeech B55 · Windsor Locks, CTNTSB NYC78FNE32Accident · Minor injuriesClosedPiper PA-18 · Canaan, CTNTSB NYC78FNE34Accident · Minor injuriesClosedPiper PA-16 · N.Stonington, CTNTSB NYC78FNEZBAccident · No injuriesClosedCessna 172 · Plainville, CTNTSB NYC78FNE29Accident · No injuriesClosedCessna 172 · Essex, CTNTSB NYC78FNE24Accident · No injuriesClosedCessna 150 · Woodstock, CTNTSB NYC78FNE19Accident · No injuriesClosedCessna 140 · Plainville, CTNTSB NYC78FNE18Accident · No injuriesClosedCessna 177 · Hartford, CTNTSB NYC78FNE17Accident · No injuriesClosedCessna 172M · East Windsor, CTNTSB NYC78FNE16Accident · Serious injuriesClosedPiper PA-28R · Oxford, CTNTSB NYC78FNE06Accident · No injuriesClosedPiper PA-28 · Stratford, CTNTSB NYC78FNE05Accident · No injuriesClosedPiper PA-28R · Ellington, CT