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 DEN85IA109Incident · No injuriesIncident investigationFinal reportCessna 185F · Jackson, WYThe plt of N57PL was attempting a landing in a strong crosswind in VFR conditions. During the landing roll, the left main landing gear tire blew out causing the acft to ground loop.Apr 3, 1985 · N57PL · Minor damageNTSB ATL85LA127Accident · No injuriesLimited investigationFinal reportCessna A188B · Prentiss, MSThere was no wind as the plt took off to proceed to an ag site; however, by the time he arrived, the wind had begun to blow. Reportedly, he landed downwind on a rural road in winds that were from the southwest at 10 gusting to 15 KTS. The plt stated that he…Apr 3, 1985 · N4884Q · Substantial damageNTSB LAX85LA191Accident · No injuriesLimited investigationFinal reportCessna 414 · Eagle Mountain, CAAccording to the riverside county California sheriff's department the acft touched down left gear first and experienced a blowout or gear failure on the right gear. The acft ran off the right side of the rwy, skidded across a dirt berm partially separating…Apr 2, 1985 · XBDED · Substantial damageNTSB LAX85FVG01Accident · No injuriesFinal reportCessna 152 · Lower Lake, CAThe acft contacted trees while attempting to land at hoberg airstrip.Apr 2, 1985 · N4602L · Substantial damageNTSB LAX85FA193Accident · Minor injuriesField investigationFinal reportCessna 150M · Fullerton, CAGnd witness & the student plt rptd upon touchdown the acft began to bounce. After several bounces the plt began to go-around upon reaching midfield. After lift off the acft began to sink and collided with the arpt boundary fence. When executing the go-around…Apr 2, 1985 · N8190U · Substantial damageNTSB FTW85LA172Accident · No injuriesLimited investigationFinal reportMooney M20A · Austin, TXThe 86 hr private plt landed at a ranch and ran off the end of the rwy into rough terrain. A go around was not attempted.Apr 2, 1985 · N8121E · Substantial damageNTSB DEN85LA108Accident · No injuriesLimited investigationFinal reportMaule M-5-210C · Fort Collins, COThe plt of a Maule lost directional control during an attempted landing at a dirt strip near ft collings, CO. The wind was from the west at a full landing stall attitude when a gust of wind picked the rt wg up causing the left wing to contact the ground.…Apr 2, 1985 · N332X · Substantial damageNTSB DEN85LA107Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Kemmerer, WYOn April 2, 1985, an inexperienced pvt plt attempted to land on a runway with a 24KT crosswind at Kemmerer, WY. The favorable runway was closed due to snow accumulations. On the third attempt the acft landed hard and bounced into the air. The plt attempted to…Apr 2, 1985 · N1085H · Substantial damageNTSB MKC85LA081Accident · No injuriesLimited investigationFinal reportEhlers Starduster ESA300 · Kansas City, MOThe plt stated that during the landing roll he noticed an acft landing behind his and therefore veered his acft to the right of rwy 36 traveling about 45 mph. During the maneuver the plt felt the right gear give and the acft consequently ground looped twice…Apr 1, 1985 · N11HE · Substantial damageNTSB LAX85LVA01Accident · No injuriesFinal reportPiper PA28-236 · Porterville, CAWhile on final apch to rwy 30 at Porterville arpt, and as the acft flared for landing, the left wheel and left wing touched the rwy, and the acft bounced into the air, stalled, and crashed just left of the rwy. The plt stated, 'a gust of wind pitched the nose…Mar 31, 1985 · N43504 · Substantial damageNTSB LAX85FA188Accident · Serious injuriesField investigationFinal reportCessna 172N · Anza, CAAfter making two previous takeoffs and one landing in an overloaded airplane the pilot landed about 1000 feet down a 3200 foot runway. When the aircraft failed to decelerate quickly enough and the pilot attempted a go-around toward rising terrain. The…Mar 31, 1985 · N738UZ · Substantial damageNTSB MIA85IA137Incident · No injuriesIncident investigationFinal reportCessna 402C · Ft. Lauderdale, FLThe acft veered off the left side of rwy 9R on landing. Inspection of the acft revealed that the torque link washers on the left main landing gear had failed allowing the wheel assembly to rotate causing the loss of directional control. No record of…Mar 30, 1985 · N2719T · Minor damageNTSB DEN85LA098Accident · No injuriesLimited investigationFinal reportCessna 402C · Aspen, COThe plt was given instructions by the Aspen twr controller to land on rwy 15. He was requested to make a short final to the rwy because of approaching traffic. The pilot stated that he landed slightly left of the rwy ctr line. The acft skidded to left and the…Mar 30, 1985 · N2711X · Substantial damageNTSB ATL85LA128Accident · No injuriesLimited investigationFinal reportVarieze Duncan/Varieze · Ocracoke, NCDuring landing, the tab which connects the landing gear cross tube failed allowing the right gear to collapse. The acft has an experimental certificate. The failure appeared to be due to design limitations.Mar 30, 1985 · N9329A · Substantial damageNTSB ATL85LA126Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Blairsville, GADuring flt, the plt encountered unfavorable winds & rain, then became concerned about his fuel supply. He diverted to Blairsville & was landing when a gust of wind blew the acft side ways. The plt re-aligned the acft with the rwy, but it suddenly dropped &…Mar 30, 1985 · N3744W · Substantial damageNTSB MKC85LA079Accident · No injuriesLimited investigationFinal reportCessna 188 · Osage City, KSThe plt was practicing landing at the airport when during the landing roll on the third attempt at landing the acft swerved off the rwy. The acft ground looped after departing the rwy and sustained substantial damage. The plt rptd the brakes grabbed…Mar 29, 1985 · N9959G · Substantial damageNTSB CHI85LA150Accident · No injuriesLimited investigationFinal reportCessna 152 · Richmond, INWhile on a solo training flt the student plt allowed the acft to bounce during touchdown. The acft then became airborne & stalled while several feet above the rwy. During the ensuing hard landing the nose gear strut collapsed & the acft veered to the left…Mar 29, 1985 · N48241 · Substantial damageNTSB LAX85LVD01Accident · No injuriesFinal reportPiper PA-24-250 · Navato, CAThe acft was landed gear up. The plt stated that as he retarded the throttle to land the lndg gear warning sounded. He applied power but the acft touched down with a scraping noise. He does not remember seeing a green lite for gear dwn indication.…Mar 28, 1985 · N6012P · Substantial damageNTSB LAX85LA189Accident · No injuriesLimited investigationFinal reportCessna 172G · Show Low, AZInstructor plt stated that prior to departure for Show Low he called the fixed base operator at Show Low and learned the winds were currently from 190 to 200 degrees a 20 T0 30 knots. He and his student departed and upon arriving in the Show Low area learned…Mar 27, 1985 · N3757L · Substantial damageNTSB BFO85LA030Accident · No injuriesLimited investigationFinal reportCessna 182G · Bridgewater, VADue to excess altitude, during his 1st apch to land, the plt executed a go-around. The 2nd apch resulted in proper altitude, but high airspeed. Crosswind conditions & gusts up to 22 KTS existed at the time & touchdown occurred aprx half way down the 2755 ft…Mar 27, 1985 · N2318R · Substantial damageNTSB NYC85LA091Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Clearfield, PAThe acft veered off the rwy and collided with a drainage ditch during touchdown. The plt stated that during the apch to the arpt, the acft flew over a coal stripping mine which produced turbulence and resulted in a touchdown without proper alignment with the…Mar 26, 1985 · N55369 · Substantial damageNTSB MIA85LA133Accident · No injuriesLimited investigationFinal reportHughes 269C · Tampa, FLThe instructor plt (CFI) reported that while practicing a taxi/hover autorotation, the helicopter settled onto a soft area in the turf. He reported that the student over-controlled with right anti-torque pedal & the helicopter settled in a left skid. The CFI…Mar 26, 1985 · N58208 · Substantial damageNTSB FTW85LA179Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Eagle Lake, TXOn or about 3/25/85, the acft was landed on a short private strip. During the landing, it overran the strip, then collided with a dirt bank & a tree. The plt abandoned the acft. Neither he nor the new owner could be found. There was evidence that the acft had…Mar 25, 1985 · N23L · DestroyedNTSB CHI85LA148Accident · No injuriesLimited investigationFinal reportPiper PA-20-125 · Zionsville, INThe plt stated that she flared slightly high upon landing, causing the acft to bounce. Once the acft was on the ground again it began to drift to the left side of the rwy. To correct for this drift, the plt applied right rudder, however, she overcorrected…Mar 25, 1985 · N7629K · Substantial damageNTSB NYC85LA090Accident · No injuriesLimited investigationFinal reportCessna L-19 · Perkasie, PACessna L-19,a practice flight of takeoffs and landings for glider tow operation for philidelphia glider council encounter a wind shift on landing. The student pilot over corrected and the aircraft ground looped. The instuctor pilot at this time took control…Mar 24, 1985 · N5234G · Substantial damageNTSB LAX85LA223Accident · Serious injuriesLimited investigationFinal reportGeneral Balloon AX-6 · Panamint Valley, CAThe plt reported that he was landing on desert terrain in nearly calm air when a 'strong thermal wind pushed the balloon 90 degrees from the direction of track.' Subsequently, the balloon landed hard & was dragged about 150 ft across the desert. While…Mar 24, 1985 · N2614K · Minor damageNTSB FTW85LA161Accident · No injuriesLimited investigationFinal reportCessna 150F · Fritch, TXThe student pilot touched down short of the rwy while attempting to land downwind. He then attempted a go-around but lost control due to inadequate airspeed. The aircraft banked to the right and struck the tail section of a parked airplane and crashed.Mar 24, 1985 · N6928F · Substantial damageNTSB MKC85FA076Accident · No injuriesField investigationFinal reportSwearingen SA226TC · Hot Springs, ARThe first officer was making the landing and the acft bounced during touchdown. The captain's right hand, which had beennear the floor to the right of his seat, bumped the landing gear selector to the up position as the captain reached for the yoke. The…Mar 23, 1985 · N508SS · Substantial damageNTSB LAX85FA185Accident · Serious injuriesField investigationFinal reportSwearingen SA 226TC · Los Angeles, CAOn this leg of the flt, the 1st officer (fo) was flying the acft while the captain (capt) was monitoring & conducting ATC communications. Reportedly, the aircrew had followed the checklist during arrival; however, the acft was landed withthe gear retracted.…Mar 23, 1985 · CGYRD · Substantial damageNTSB FTW85LA162Accident · No injuriesLimited investigationFinal reportNorth American AT-6G · Frederick, OKThe passenger heard a loud mechanical noise from the tail of the aircraft during rollout from a touch-and-go landing. The pilot was unable to maintain directional control, the aircraft ground looped, the main landing gear collapsed, and the wings were…Mar 23, 1985 · N9035Z · Substantial damageNTSB NYC85LA085Accident · No injuriesLimited investigationFinal reportBoeing JB-75 · Marston Mills, MAThe acft nosed over after contacting an utility pole during an overrun landing. The acft touched down aprx 1/2 way down the rwy and the plt applied brakes, however, braking action was poor because of the wet grass rwy. The acft skidded off the end of the rwy…Mar 22, 1985 · N3993P · Substantial damageNTSB DEN85LA101Accident · No injuriesLimited investigationFinal reportPiper PA 18-150 · Grand Forks, NDOn March 21, 1985, a Piper pa 18 ground looped on landing rollout at gran Forks, ND. The instructor stated the aircraft accident occurred when he was checking out another flight instructor in the tailwheel airplane. During the landing roll out the airplane…Mar 21, 1985 · N2582S · Substantial damageNTSB DEN85FA099Accident · 2 fatalField investigationFinal reportCessna 182J · Erie, COReportedly, the plt had called the arpt office (UNICOM) & was advised that rwy 15/33 was closed. At about the time N3354F was arriving, a military helicopter landed on rwy 27. The plt asked a passenger to tell him which way the wind sock was blowing & she…Mar 21, 1985 · N3354F · DestroyedNTSB MIA85LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · Vero Beach, FLThe student pilot was practicing touch-&-go landings on rwy 11. Due to a wind shift, the active rwy was changed to rwy 4. The student stated that during his 1st pattern for a landing on rwy 4, his apch was high & fast. As the acft touched down, he lost…Mar 19, 1985 · N69109 · Substantial damageNTSB MKC85LA073Accident · No injuriesLimited investigationFinal reportCessna T210M · Joplin, MOThe acft nose gear collapsed after a hard bounced landing. The plt stated that she touched down hard on the main gear then bounced and relanded on main and nose gear. During the 2nd touchdown the nose gear collapsed. The plt and her one-year-old daughter were…Mar 18, 1985 · N732XD · Substantial damageNTSB DEN85FTI03Accident · No injuriesFinal reportHilliard B-8-M · Clinton, MTThe gyrocopter inadvertently became airborne during a high speed taxi run. The plt reported that at an alt of aprx 10-15 ft AGL he 'cut the engine speed to idle, and pulled the joystick fully back to land.' This action put the gyrocopter in a nose high…Mar 18, 1985 · N8036T · Substantial damageNTSB CHI85LA142Accident · No injuriesLimited investigationFinal reportCessna 172RG · Portland, INUpon landing the nose gear was down & locked, but both main gear collapsed. The plt was not certain if a down & locked indication was received before touchdown. During a gear retraction/extension test after the accident, the gear operated normally. Also, the…Mar 17, 1985 · N9584B · Substantial damageNTSB NYC85LA084Accident · No injuriesLimited investigationFinal reportCessna 172P · Princeton, NJThe acft experienced nose gear damage following a loss of control during touchdown. The plt stated the acft touched down on the main gear and bounced as the nose gear was being lowered. After the acft porpoised several times the plt was able to regain control…Mar 16, 1985 · N62541 · Substantial damageNTSB SEA85LA075Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Bremerton, WAThe acft bounced during landing and adequate recovery was not made. The acft came to rest inverted.Mar 15, 1985 · N5033W · Substantial damageNTSB CHI85LA136Accident · No injuriesLimited investigationFinal reportCessna 172N · Crystal Lake, ILThe plt reported that as he lowered the nosewheel to the rwy during the landing roll, the acft veered to the right. As the right main gear went off the side of the rwy, it entered soft terrain which pulled the acft further to the right. Subsequently, the nose…Mar 15, 1985 · N3421E · Substantial damageNTSB SEA85LA074Accident · No injuriesLimited investigationFinal reportGrumman 164A · Ritzville, WADuring landing the acft caught a gust of wind and drifted right of the runway. The plt attempted to correct by use of rudder and aileron, but was unsuccessful. The acft then nosed ver.Mar 14, 1985 · N8495 · Substantial damageNTSB LAX85LA172Accident · No injuriesLimited investigationFinal reportCessna 152 · Grass Valley, CAAccording to the plt she flared too late and was too close to the left side of the 50 ft wide rwy at touchdown. The acft veered left on the lndg roll and the left main gear struck a snowbank. The plt tried to steer out of the snowbank but the nose gear also…Mar 14, 1985 · N95491 · Substantial damageNTSB DEN85LA095Accident · No injuriesLimited investigationFinal reportCessna 310 · Angel Fire, NMThe acft touched down 1500 ft short of the rwy and the nose gear collapsed. The taxiways were rough and soft yellow chevrons were painted on the taxiways, at the apch end of the rwy. The plt stated that he was concentrating on the apch and did not see the…Mar 14, 1985 · N5515G · Substantial damageNTSB ATL85LA123Accident · No injuriesLimited investigationFinal reportCessna 182P · Atlanta, GAThe plt lost directional control during ldg when the acft encountered wind gusts and was blown off the rwy.Mar 14, 1985 · N76RF · Substantial damageNTSB ANC85LA057Accident · No injuriesLimited investigationFinal reportCurtiss C-46R · Nulato, AKThe acft continued off the end of the rwy and contacted a snow berm during the landing roll. The plt reported the rwy braking action as poor.Mar 14, 1985 · N7848B · Substantial damageNTSB SEA85LA078Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Fish Lake Valle, NVDuring landing roll the acft veered sharply to the left and struck an irrigation sprinkling system. The operator discovered that the valve stem to the tire had broken and the plt had landed with a flat tire.Mar 13, 1985 · N2965A · Substantial damageNTSB LAX85LA171Accident · No injuriesLimited investigationFinal reportPiper PA-44-180T · Woodland, CAThe instructor (CFI) was preparing his student for a multiengine, private plt, flt test. The purpose of the lesson was to demonstrate a precautionary landing following a simulated loss of power after takeoff. At an alt of about 100 ft AGL, the CFI retarded…Mar 13, 1985 · N8322T · Substantial damageNTSB SEA85LA073Accident · No injuriesLimited investigationFinal reportCessna 172 · Soda Springs, IDThe plt made a precautionary landing due to an iced up pitot tube. The plt landed with excess speed and was unable to stop the acft before it overran the end of the rwy. It struck a snow bank and then flipped inverted.Mar 12, 1985 · N8553X · Substantial damageNTSB MIA85LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Pahokee, FLThe plt stated that when he smelled smoke in the cabin, he landed & taxied to the ramp area, then a fire erupted. An investigation revealed the fire started where an electrical short occurred near the APU plug (in the area of the aft baggage compartment).Mar 11, 1985 · N44480 · DestroyedNTSB ATL85LA114Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Charleston, WVThe plt landed long on the rwy & at excessive speed. In an attempt to stop the acft she applied brakes & the acft flipped upside down.Mar 11, 1985 · N53726 · Substantial damage