OpenAirDocs.org

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.

NTSB ATL85LA183Accident · No injuriesLimited investigationFinal reportHughes 369HS · Aiken, SCDuring a landing, the eng lost power & the helicopter touched down hard. The plt stated that prior to the 15 min flt, the fuel gage was indicating 125 lbs of fuel & at the accident site it indicated 90 lbs of fuel. A post crash inspection of the fuel system…Jun 7, 1985 · N9146F · Substantial damageNTSB SEA85LA131Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Brentwood, CAOn the student plts seventh attempted landing, directional control was lost and a groundloop occurred. The student plt had less than two hours of total pilot in command time.Jun 6, 1985 · N6995B · Substantial damageNTSB DEN85LA149Accident · No injuriesLimited investigationFinal reportBeech V35B · Kalispell, MTN904V, a privately owned B-35, skidded off to the side of a runway during landing. The plt said that he inadvertently activated the gear up switch instead of the flap switch. The right landing gear collapsed causing the plt to lose control of acft.Jun 5, 1985 · N908V · Substantial damageNTSB CHI85LA223Accident · No injuriesLimited investigationFinal reportPiper PA-31-T · Rochester, INWhen the plt reduced power & flared, the acft touched down short of the rwy. The acft sustained substanitial damage when the landing gear struck the edge of the raised rwy surface.Jun 5, 1985 · N777YR · Substantial damageNTSB DEN85FTE02Accident · Serious injuriesFinal reportCessna 180K · Atlantic City, WYThe acft nosed over during an attempted landing on a narrow curved roadway in a mining pit. Witnesses reported the acft made a steep descent, touched down on the road and almost immediately departed the road. The acft entered an area of large boulders, nosed…Jun 4, 1985 · N66771 · Substantial damageNTSB NYC85LA144Accident · No injuriesLimited investigationFinal reportCessna 305A · Toughkenamon, PAThe acft ground looped during a landing roll on a sod rwy. The plt stated that during the landing roll, it felt as if the right main gear contacted a knoll of grass resulting in the acft ground looping to the right.Jun 2, 1985 · N5288G · Substantial damageNTSB LAX85LA266Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Hesperia, CAWhile en route, the plt noted thunderstorms & towering cumulus clouds over the tehachapi mountains & elected to divert to Hesperia. He stated that all fields within range had 'severe winds and storms closing.' He said that during the landing at Hesperia,…Jun 2, 1985 · N97935 · Substantial damageNTSB DEN85LA148Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Bountiful, UTOn June 1, 1985, an Aeronca 7AC, piloted by a private plt, ground looped while making a touch and go landing at sky park airport, Bountiful, UT. The plt stated that he lost control of the airplane. The winds were reported to be calm.Jun 2, 1985 · N8362H · Substantial damageNTSB CHI85LA224Accident · No injuriesLimited investigationFinal reportStearman E-75 · Lake Odessa, MIUpon landing the aircraft veered to the right. Power & left rudder were applied, however, the aircraft continued to the right. Power was reduced but the aircraft continued to the right. The aircraft nosed over after coming in contact with a soft, plowed…Jun 2, 1985 · N65688 · Substantial damageNTSB ANC85LA089Accident · No injuriesLimited investigationFinal reportCessna 172 · Soldotna, AKThe acft sustained substantial damage when the pilot lost control of the acft and nosed over on its back. The weather was VMC but the pilot said he encountered a gust and crosswind during landing.Jun 2, 1985 · N65928 · Substantial damageNTSB MKC85LA119Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Concordia, KSThe student plt was making a night flt. He received wind information from an arpt 48 miles from the destination but used an indication from lighted wind indicator. Plt made a go around because the ground speed was fast. During the next attempt, he landed, ran…Jun 1, 1985 · N627WB · Substantial damageNTSB FTW85LA252Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Kaplan, LAThe left brake failed during the landing roll. The acft veered to the right of the rwy and ground looped. During the groundloop, the left tire blew and the tail wheel spring bolt assembly failed. Cause of the brake failure was not determined.Jun 1, 1985 · N7371 · Substantial damageNTSB FTW85FPA03Accident · No injuriesFinal reportMooney M20 · Fort Worth, TXThe acft contacted an iron pole and a hangar following a loss of directional control during landing roll. The plt reported that after an aprx 300 ft ground roll, the acft veered left. The left wing contacted an iron pole which resulted in the acft rotating…Jun 1, 1985 · N872B · DestroyedNTSB ANC85LA088Accident · No injuriesLimited investigationFinal reportCessna A185F · Alaktak, AKThe acft collideded with a snow bank and nosed over during a landing attempt on a frozen lake. The plt stated that 'my rt ski hit a pressure ridge or broke through crust; whichever, the acft abrurtly pitched down, contacting the ice and continuing over onto…Jun 1, 1985 · N61500 · Substantial damageNTSB MIA85IA182Incident · No injuriesIncident investigationFinal reportPiper Aztec PA-23-250 · Vero Beach, FLWhile in the traffic pattern, the cfi's attention was diverted as he attempted to assist ATC with some radio frequency info. While being so distracted, he permitted the student to land the acft with the gear up.May 31, 1985 · N63845 · Minor damageNTSB LAX85LA265Accident · No injuriesLimited investigationFinal reportMooney M20J · Rialto, CAAt the conclusion of a nearly 5 hours long non stop flight from NM to CA, the pilot attempted to land at an uncontroll-ed airport. The pilot acknowledged that the aircraft's finalapproach speed was excessive, and after the aircraft toucheddown it bounced off…May 31, 1985 · N3721H · Substantial damageNTSB CHI85LA217Accident · No injuriesLimited investigationFinal reportCessna 150M · Merrill, WIThe plt was performing touch-and-go's when on the landing roll she allowed the acft to drift off the rwy into soft terrain. The acft nosed over. The plt stated that she was looking inside to raise the flaps.May 31, 1985 · N66069 · Substantial damageNTSB LAX85LA264Accident · No injuriesLimited investigationFinal reportBeech 65-A90 · San Jose, CAWhile landing the right main landing gear of the aircraft seperated when the upper torque knee link failed. After the gear separated the aircraft skidded off the right side of the runway coming to rest in a grass area. Metallurgical examination of the failed…May 30, 1985 · N22WC · Substantial damageNTSB FTW85LA239Accident · No injuriesLimited investigationFinal reportHughes 300 · Lake Worth, TXWhile undergoing helicopter transition training from the previous owner, who holds no instructor certificate, the new owner's son had been practicing pwr recovery autorotations. The eng failed to respond to application of throttle, and a full autorotative…May 30, 1985 · N9660F · Substantial damageNTSB FTW85LA236Accident · No injuriesLimited investigationFinal reportGrumman G-164A-600 · Dalhart, TXThe plt had accumulated 12 hrs experience in this model acft. He stated the acft bounced on the rough airstrip, and he applied too much brake on the next touchdown. The acft nosed over, damaging the top wing and empennage.May 30, 1985 · N36RA · Substantial damageNTSB CHI85FA218Accident · Serious injuriesField investigationFinal reportCessna 425 · Dayton, OHThe acft involved was experimentally configured with 4-bladed props and was on a test flt to determine handling characteristics following a throttle chop to idle power at 50 ft AGL. This maneuver had been accomplished twice on the test flt without incident.…May 29, 1985 · N2079A · Substantial damageNTSB MIA85LA184Accident · No injuriesLimited investigationFinal reportCessna 337G · Daytona Beach, FLThe plt stated that while practicing an actual single eng landing, he forgot to lower the landing gear. He heard the gear warning horn but said that he thought it was his radar alimeter sounding. He admitted that actual single eng landings should not be…May 28, 1985 · N53633 · Substantial damageNTSB ANC85LA087Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Chugiak, AKWhile landing with a gusty x-wind, the acft bounced, the left wing dragged the ground & the acft went off the rwy. The plt stated that due to the x-wind & his foot slipping off of the rudder pedal, he was unable to maintain directional control.May 28, 1985 · N6175M · Substantial damageNTSB ATL85LA174Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Hickory, NCDuring the landing roll, the plt lost directional control of the acft & it ground looped & ran off the rwy. The plt reported that the left tire went flat, the left gear collapsed & the left wing was damaged.May 27, 1985 · N2378M · Substantial damageNTSB NYC85LA135Accident · No injuriesLimited investigationFinal reportGulfstream 681 · Millville, NJThe plt reported that when the landing gear was lowered during the apch, the right main gear light did not illuminate, however, the 'in-transit' light went out. He also reported, the gear warning horn stopped sounding and the hydraulic pressure was normal.…May 25, 1985 · N911JM · Substantial damageNTSB CHI85LA221Accident · No injuriesLimited investigationFinal reportCessna 170B · Waseca, MNThe plt stated that on final apch the x-wind correction was good and he had a 45 deg wind from the right at aprx 15 KTS with gusts to 20 KTS. During the flare, the acft ballooned and landed in a right yaw. The plt stated that he then added pwr and left rudder…May 25, 1985 · N1676D · Substantial damageNTSB CHI85LA208Accident · No injuriesLimited investigationFinal reportCessna 150L · Necedah, WIAfter a flt with an instructor, the student took off on a solo flt. During a touch & go the student stated, '... I came in high & fast. I landed long and the aircraft bounced twice. I then panicked and pushed the control forward causing the nose to dive into…May 25, 1985 · N5481Q · Substantial damageNTSB ANC85FA086Accident · No injuriesField investigationFinal reportPiper PA-18-150 · Anchorage, AKAcft lost control during landing & groundlooped. The plt stated the heel of his shoe slipped off the brake pedal when an attempt to apply the brakes was made.May 24, 1985 · N7786D · Substantial damageNTSB DEN85LA140Accident · Minor injuriesLimited investigationFinal reportChampion 7FC · Watkins, COA witness stated the acft veered aprx 30 degs during the landing roll and was heading toward the north edge of the rwy when full pwr was added to abort the landing. The acft took off and traveled over a grass and wheat field, which borders the rwy, with the…May 23, 1985 · N781VY · DestroyedNTSB NYC85LA133Accident · No injuriesLimited investigationFinal reportCessna 172 · Erie, PAThe acft ballooned during landing and drifted to the side of the rwy where it made ground contact in a drainage area. The acft bounced and came down hard before coming to a stop. The plt said he was high on appraoch & lowered full flaps. The acft was not…May 22, 1985 · N8703B · Substantial damageNTSB FTW85LA231Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Austin, TXThe plt stated he felt the gear extend and the corresponding decrease in airspeed when the gear was lowered during the apch. He stated he thought he observed a green gear down indication and he did observe the shadow of the extended gear on the ground as the…May 22, 1985 · N6665P · Substantial damageNTSB CHI85LA205Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Valparaiso, INAcft contacted a ditch following a loss of directional control during landing roll. Plt reported, 'more experience in handling crosswinds' could have prevented the accident.May 22, 1985 · N8521N · Substantial damageNTSB MKC85LA109Accident · Minor injuriesLimited investigationFinal reportBeech 35-B33 · Calamus, IADuring arrival, the plt landed on a 1700 ft turf rwy which sloped downhill to the north & had a 30 ft power line located near the apch end. Reportedly, the acft touched down 572 ft from the departure end, then continued off the rwy & hit a dirt bank next to a…May 21, 1985 · N3EM · Substantial damageNTSB BFO85LA047Accident · No injuriesLimited investigationFinal reportCessna 152 · Gaithersburg, MDThe plt prefldd the acft iaw a checklist and did not note any abnormalities. Following a normal tkof the plt remained in the traffic pattern, experiencing no complications until touchdown. The winds recorded at bwi were out of 220 degrees at 8 knots. The plt…May 21, 1985 · N6529L · Substantial damageNTSB NYC85LA130Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Pittsburgh, PAThe personal transportation flight took off from allegheny co. ariport and made one landing back at the airport. The flight then departed the airport and made a landing on the water with the wheels down causing the aircraft to tip o ver onto its back.May 20, 1985 · N5640C · Substantial damageNTSB MKC85FCJ01Accident · Serious injuriesFinal reportRobinson R22 · Gladstone, NEThe acft made a hard off arpt landing in an unlighted farm field on a dark night. The acft'dropped in' from about 50 ft AGL in a vertical descent. After ground contact the acft rolled over to the right. No mechanical malfunctions were noted during the…May 20, 1985 · N8386B · DestroyedNTSB FTW85LA227Accident · No injuriesLimited investigationFinal reportBeech 58P · Abilene, TXThe plt stated he made a normal landing and the gear folded during the rollout. Another plt who was waiting at the end of the rwy for takeoff observed the landing and stated the landing gear was extended too late and was still in transit (not fully down) when…May 20, 1985 · N95BH · Substantial damageNTSB SEA85LA191Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Coalinga, CAThe plt mistakenly landed on a pvt airstrip and during a x-wind landing made a go around due to a gust of wind. The acft struck a dirt berm with the right wing and the right main gear.May 19, 1985 · N6927P · Substantial damageNTSB NYC85LA129Accident · No injuriesLimited investigationFinal reportCessna 180J · Hooksett, NHThe plt was ferrying the acft to a fld where floats were to be installed. While on the apch, the acft encountered a crosswind and drifted 20 ft off the intended centerline. The acft touched down and rolled about 110 ft before colliding with a small bush and…May 19, 1985 · N52197 · Substantial damageNTSB NYC85LA127Accident · No injuriesLimited investigationFinal reportCessna C152 · Newry, PAThe student pilot, sole occupant was on his first solo flight performing touch and go landings at blue knob valley airport, Newry, Pennsylvania. During a landing. The aircraft touched down left of the centerline and drifted left contacting a barrel with the…May 19, 1985 · N94221 · Substantial damageNTSB CHI85LA216Accident · No injuriesLimited investigationFinal reportPiper PA-32T-300 · Milwaukee, WIThe pilot stated that the approach was normal and flown at 90 KIAS. He flared high and the acft landed hard on the right main landing gear, due to the excessive rate of decent. The damage was limited to the right wing spar and ribs.May 19, 1985 · N39628 · Substantial damageNTSB CHI85LA203Accident · No injuriesLimited investigationFinal reportCessna 140A · Owosso, MIThe plt-in-command allowed the passenger in the right seat, a rated plt, to land the acft. This plt lost directional control during the landing roll & the acft ground looped. During the second ground loop the right main landing gear axle separated from the…May 19, 1985 · N3797V · Substantial damageNTSB FTW85LA226Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Crowell, TXThe pilot landed with a light tail wind on a 3200 ft rwy which slopes downward. The brakes faded and became ineffective due to heavy application. A go-around was attempted; however, flying speed was not obtained and the acft impacted the ground about 200 ft…May 18, 1985 · N55800 · DestroyedNTSB SEA85LA114Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Rio Vista, CAThe instructor plt (CFI) reported that during a bounced landing recovery, the student plt held the acft in a 3-point attitude above the rwy. As airspeed decayed, the (CFI) took control & added full power. However, the right wing dropped & grazed rising…May 17, 1985 · N2899Z · Substantial damageNTSB NYC85LA132Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Batavia, NYThe commercial rated-flight instructor took off genesee co. airport and flew a normal pattern for landing. Some gustiness was noted by the pilot by observing the wind sock. During landing roll out, a slight swerve to the south, aircraft landing to the west,…May 17, 1985 · N7523D · Substantial damageNTSB NYC85LA126Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Potsdam, NYThe pilot received a weather breifing and filed an IFR flight plan with massena flight service station. The flight was uneventful and the aircraft was cleared for the NDB approach at Potsdam by boston center. When the airport was in sight, the pilot cnacelled…May 17, 1985 · N3548V · Substantial damageNTSB FTW85LA228Accident · No injuriesLimited investigationFinal reportCessna 182M · Chickasha, OKThe acft bounced during landing and the student plt allowed the acft to porpoise. The nose gear, engine firewall and propeller were damaged. This was the student's first solo flt. His last 2.7 hrs of dual flt instruction consisted of 18 practice touch and go…May 17, 1985 · N71351 · Substantial damageNTSB MKC85LA102Accident · Minor injuriesLimited investigationFinal reportCessna R182 · Monticello, ARPlt selected grassy area on arpt for landing. The grassy area was more closely aligned with the surface winds than the available runways. The grassy area has a utility line across the apch end and a ditch on the departure end. The landing was long and hot and…May 16, 1985 · N737LE · Substantial damageNTSB MIA85LA175Accident · No injuriesLimited investigationFinal reportCessna 152 · Jekyll Island, GAThe student plt was on her 1st supervised solo. During a touch-&-go landing, the acft veered off the left side of the rwy & subsequently hit a culvert. The student said that after she landed, she applied too much left rudder.May 16, 1985 · N6418Q · Substantial damageNTSB FTW85LA225Accident · No injuriesLimited investigationFinal reportCessna 150M · Moran, TXThe student plt attempted to make a precautionary landing due to his immediate need to use the bathroom. There were no acft problems involved. The student used 'soft field landing' techniques and touched down on soft ground for an off arpt landing. When the…May 16, 1985 · N63613 · Substantial damage