NTSB investigations
53,704 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.\"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."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 CHI84LA108Accident · No injuriesLimited investigationFinal reportCessna 172P · Lansing, MIThe acft veered off the rwy during landing. The plt tried to straighten the acft with rudder pressure but the acft continued off the rwy into a gully of snow.NTSB SEA84LA052Accident · No injuriesLimited investigationFinal reportCessna 152II · Minden, NVThe acft landed fast and during subsequent bouncing the nose gear broke off. This student plt had only about 3 hours of solo flt experience.NTSB LAX84LA201Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Hayward, CACompleting a night instrument private pilot biennial flight reivew, the acft was issued landing clearance for rwy 28L. On short final the pvt plt began to align the acft to land on rwy 28R which was closed for maintenance & not illuminated. The instructor plt…NTSB ATL84LA097Accident · No injuriesLimited investigationFinal reportCessna C-172 · Carolina Beach, NCThe plt reported a normal landing roll until he reached the end of the hard-packed clay surface and rolled into sand. The acft mired in and nosed over. This was the pilot's first landing at this arpt.NTSB FTW84LA132Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Heidenheimer, TXThe plt landed in the field he was spraying to tell the flagman he was quitting for the day. During landing roll the right main gear dug into the soft dirt and the acft nosed over.NTSB DEN84LA114Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Monte Vista, COThe acft landed on a snow covered private airstrip and nosed over. The plt said that the 4 inch deep snow caused the acft to go over on its top.NTSB ATL84LA094Accident · No injuriesLimited investigationFinal reportBeech F33A · Marion, SCThe plt stated he was involved in a discussion with the company president, who was on board, during the landing apch and he failed to use the checklist. The acft was landed gear up. It was later determined the gear up warning horn was inop.NTSB LAX84LA200Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Lk Havasu City, AZThe plt reported that the acft encountered a flock of 'large water birds' on short final. While abruptly maneuvering the acft to avoid the birds, the acft impacted hard on the rwy. The plt also stated that his landing was directly into the clear setting sun.NTSB MIA84LA073Accident · No injuriesLimited investigationFinal reportCessna 152 · Clearwater, FLAccording to the instructor/witness, the student plt lost control of the acft during a cross-wind landing. The acft bounced off the rwy into the dirt and flipped over.NTSB LAX84LA169Accident · No injuriesLimited investigationFinal reportShuey Glassaire · Chico, CAThe acft groundlooped during landing and ran off the rwy. The landing gear collapsed and ruptured the wing tanks. The plt stated that he thought the fuel shifted in his'homebuilt'as he tried to do a 3 point landing.NTSB NYC84LA082Accident · No injuriesLimited investigationFinal reportPiper PA-600 · Newark, NJThe acft was on landing roll when it began to veer from the rwy. The plt attempted to maintain directional control but the acft left the rwy and collided with a taxiway marker sign causing substantial damage to the acft. Shortly thereafter, the right main…NTSB MKC84LA100Accident · No injuriesLimited investigationFinal reportBeech F90 · Jonesboro, ARWhile en route to Jonesboro, the plt was informed the rwy and taxiway lights were inop. When he asked fss if the arpt was closed the reply was, 'negative, land at your own risk.' The plt lined up with what he thought was rwy 05 but in actuality it was a…NTSB SEA84LA049Accident · No injuriesLimited investigationFinal reportCessna A185F · Winslow, WADuring a water landing the acft was in turbulent crosswind conditions when the left float and wing dug into the water. The acft cartwheeled and came to rest with the right wingtip touching the bottom of the bay. The plt stated it would have been more prudent…NTSB NYC84LA083Accident · No injuriesLimited investigationFinal reportCessna 150H · Leonardtown, MDThe student plt was on his 1st supervised solo flt. During a landing, the acft encountered a x-wind & was blown off the centerline of the rwy. The student added power to go around. However, he said that he failed to lower the nose & the acft stalled. During…NTSB DEN84LA087Accident · No injuriesLimited investigationFinal reportTexas Helicopter 205 · Erie, COThe plt reported that he landed on rwy 15 with a wind from O90 deg at 20 gusting 30 KTS. After touchdown, the acft began veering to the left. The plt applied right rudder & right brake, but the left wheel dropped off the left side of the rwy & went into mud.…NTSB NYC84LA084Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Easton, PAThe student plt on his first solo flt veered off the rwy into a snowbank and nosed over. The plt said a puddle of water on the rwy contributed to the beginning of the swerve and he could not recover.NTSB FTW84LA129Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Lamkin, TXThe acft nose gear dug into the soft sod rwy and collapsed. After the nose gear collapsed the acft nosed over and slid inverted for about 100 ft. the FAA coordinator said the plt apparently forced the nose down while trying to maintain directional control.…NTSB DEN84LA082Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Albuquerque, NMThe acft swerved off the rwy and collapsed the left main landing gear during landing. The plt said he believes he misused the heel brakes during the landing roll since he was more familiar with acft with toe brakes.NTSB CHI84LA100Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Lk In The Hills, ILThe plt made a hard landing which damaged the nose gear making it impossible for the plt to avoid a collision with a snowbank during a subsequent landing.NTSB ATL84LA091Accident · No injuriesLimited investigationFinal reportCessna 404 · Covington, KYA fire ignited in the right engine on the landing roll. The fire source was near the point where the fuel supply line connects to the engine driven fuel pump. The acft was on its first revenue flight after the right engine was changed, atwhich time the…NTSB FTW84LA124Accident · No injuriesLimited investigationFinal reportCessna 152 · Stillwater, OKThe acft landed hard and bounced. The plt reacted by pushing the nose over and when the acft contacted the rwy the nose gear collapsed.NTSB DCA84AA016Accident · 6 fatalFinal reportLearjet 24 · Avalon, CAThe acft departed on a sales demo flt to monterey, CA with potential buyers aboard. En route, the destination was changed to Avalon, CA. UNICOM advised the crew of the wind direction & speed on downwind. Witnesses reported the acft was slightly hi on final,…NTSB NYC84LA080Accident · No injuriesLimited investigationFinal reportCessna 172RG · Marietta, PAThe acft struck a snowbank during a night landing. The CFI stated everything was normal until flareout when the acft began to settle. After striking the snowbank the acft nosed over.NTSB NYC84LA079Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T · Philadelphia, PAThe plt broke out of the overcast at 1000 ft lowered flaps and landed the acft with the gear retracted. The plt said he had lowered the gear. The gear warning horn reportedly did not sound.NTSB MKC84LA068Accident · No injuriesLimited investigationFinal reportCessna 152 · Augusta, KSThe acft ran off the rwy during landing and collided with a pile of debris, collapsing the landing gear.NTSB MKC84LA067Accident · No injuriesLimited investigationFinal reportCessna 170B · Jasper, ARThe plt landed the acft on private property to visit relatives. During the landing the acft groundlooped and collapsed the left main landing gear. The plt reported that the winds were from 290 degrees at 18 KTS and gusty. Rugged terrain surrounded the area of…NTSB CHI84LA106Accident · No injuriesLimited investigationFinal reportCessna 152 · Detroit Lakes, MNThe acft collided with a snow embankment 15 to 20 ft short of the rwy on final approach. The acft got low and slow on final according to the instructor and he became concerned about a hard landing. As he advanced the throttle the acft hitthe embankment. The…NTSB CHI84LA098Accident · No injuriesLimited investigationFinal reportCessna 152 · Pontiac, MIDuring a cross wind landing the acft veered left, collided with a snowbank and nosed over. The winds were gusting to 20 knots.NTSB NYC84LA075Accident · No injuriesLimited investigationFinal reportCessna 150E · Brewer, METhe acft was on a local pre-solo takeoff and landing practice flight. Several landings were made with the student pilot adjusting for wind conditions below a tree line. On the last landing the CFI reported that the acft moved quickly to theright and started…NTSB ATL84LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · Snowville, VAThe acft crash landed in a pasture during a go-around attempt after a demonstration forced landing. The go-around was delayed and the terrain rose faster than the acft ascent rate. Since there was a powerline in the way the CFI elected to land the acft.NTSB FTW84LA119Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Cedar Hill, TXPurpose of the flt was to check for oil leaks after maintenance was performed. Shortly after takeoff, at an alt of 50 to 100 ft AGL, the plt noticed a '2 per rev vibration' and decided to land in a field. When aprx 5 ft AGL the plt felt what he described as a…NTSB MKC84LA064Accident · No injuriesLimited investigationFinal reportMitsubishi MU 2B-20 · Ames, IAThe acft landed in a crosswind on a snow and ice covered rwy. During landing, directional control was lost and the acft collided with a snowbank. The plt stated he attempted to use propeller reversing for braking and the acft started to slide to the left.NTSB MIA84LA066Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Plymouth, FLThe acft was landed hard at higher than normal airspeed. The plt stated that he came in'too high and too fast'and when he landed he'broke the nose wheel'. Investigation revealed that the plt did not possess any aeronautical certificates or ratings. He had…NTSB LAX84LA159Accident · No injuriesLimited investigationFinal reportBeech D55 · Monterey, CAAccording to the plt, he extended the gear & flaps before landing, & on final apch, he rechecked that the gear was down & the green gear down & locked light was illuminated. He & both passengers reported that the acft touched down on the wheels, then it…NTSB LAX84LA154Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Healdsburg, CAThe plt reported that a gust of wind pushed up the left wing & the acft veered off the rwy. The acft then went down a shallow grade & impacted bushes. He reported the wind was from 330 deg at 10 gusting 18 KTS.NTSB CHI84LA095Accident · No injuriesLimited investigationFinal reportCessna C-172P · Macomb, ILThe acft swerved off the rwy into a ditch during a crosswind landing. The wind was from 180 degrees at 10 KTS. The plt said that he lost directional control of the acft because of the wind.NTSB MIA84LA065Accident · No injuriesLimited investigationFinal reportBeech 58 · Ft.Myers, FLThe acft was rolling on the rwy after a smooth landing when the left tire blew out and the left landing gear collapsed. The acft swerved to the left into the wind and slid off the left side of the rwy. According to the plt, the wind was from 090 deg at 18…NTSB MKC84LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Chesterfield, MOThe acft bounced during a touch and go landing. The plt was unable to control the bouncing and the acft received damage to the nose gear, propeller and wing tips.NTSB SEA84IA042Incident · No injuriesIncident investigationFinal reportCessna CE500 · Yakima, WAThe acft made a hard landing while on a training flt. According to the instructor plt, 'during the landing flare, we were descending very gradually as the airspeed continued to dissipate.' Late in the flare the angle of attack indicator was approaching the…NTSB LAX84LA143Accident · Serious injuriesLimited investigationFinal reportCessna 206 · Santa Cruzi Il, CAThe acft overran the landing area and nosed over. The landing area was on grassy rolling terrain which was downhill fromthe touchdown point. Winds from stations in the area were from a westerly component and the landing was to the east.NTSB CHI84LA089Accident · No injuriesLimited investigationFinal reportGrumman AA-1A · Hawley, MNThe acft ran into a snowbank during the landing roll and flipped over. The plt stated that the right brake pedal cylinder froze but this could not be confirmed during the investigation.NTSB ANC84LA032Accident · No injuriesLimited investigationFinal reportCessna 207A · Deering, AKWhile in the traffic pattern for a night landing, the plt noticed the village agent's truck positioned about 2/3 down the rwy facing north. The plt assumed the truck was indicating the landing direction. During the landing roll, the plt noticed the truck on…NTSB MIA84IA062Incident · No injuriesIncident investigationFinal reportBeech D18S · Jacksonville, FLThe acft landed gear up at the Jacksonville, airport. Exam of the gear ext system revealed no malfunctions or failures.NTSB SEA84LA043Accident · No injuriesLimited investigationFinal reportRaven Rally RX7 · Aibirm, WAThe plt stated that the wind shifted during landing and the balloon touched down hard and lifted off again. With power lines ahead a decision was made to cross over but the balloon struck the lines. Several cables were burned through and the balloon was torn…NTSB NYC84LA069Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Annapolis, MDThe plt landed faster than normal and lost control of the acft on the icy rwy. The plt said he over-corrected with left rudder and the acft went off the rwy and slid on a frozen field collapsing the right main gear.NTSB LAX84LA146Accident · No injuriesLimited investigationFinal reportBeech C-24-R · Fullerton, CAA rear seated passg reported that when the acft was about 50 ft AGL he heard the stall warning buzzer sound. Several seconds later acft hit the rwy in a near level attitude. The landing was described by the passgs as 'on the hard side.' Investigation revealed…NTSB LAX84LA141Accident · No injuriesLimited investigationFinal reportCessna 310 · Tucson, AZThe right main landing gear collapsed as the acft was being taxied to the ramp. The plt reported that the acft was traveling about 30 mph during entry into the taxi turn-off area at the time of the accident. Failure occurred in theright rear trunion pin.NTSB SEA84LA038Accident · No injuriesLimited investigationFinal reportPiper PA28R-200 · Newport, ORThe acft collided with a ditch during landing. The construction ditch ran across the rwy. The rwy had been notamed as out of service except for the last 2000 ft. the plt stated that the 3 white barriers marking the position of the construction ditch had blown…NTSB CHI84LA086Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Waukegan, ILThe student plt said he lost too much airspeed during a no power approach and made a hard landing. After a bounce, the acft hit on the nose gear and it collapsed. The acft skidded off the rwy into a snowbank.NTSB NYC84LA068Accident · No injuriesLimited investigationFinal reportCessna 150 · Seneca Falls, NYDuring the landing rollout the acft hit an icy patch of rwy and at the same time encountered a gusty crosswind. The acftskidded into a snowbank and nosed over.