OpenAirDocs.org

NTSB investigations

53,703 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 LAX88LA223Accident · No injuriesLimited investigationFinal reportCessna 152 · Scottsdale, AZWhile flying the third supervised solo, during the first landing, the pilot lost control of the airplane which veered off the runway. The airplane came to rest inverted. There were no reported mechanical failures or malfunctions with the airplane prior to the…Jun 14, 1988 · N49792 · Substantial damageNTSB SEA88IA108Incident · Minor injuriesIncident investigationFinal reportBoeing 727-200 · Seattle, WAAfter the main gear touched down, thrust levers were placed in the idle reverse position. Once the aircraft's nose gear contacted the runway, braking and full reverse thrust was applied. The aircraft started to drift to the left of the runway centerline. The…Jun 13, 1988 · N308AS · Minor damageNTSB MIA88LA189Accident · No injuriesLimited investigationFinal reportCessna 402B · Fort Lauderdale, FLThe right main gear collapsed on touchdown. An exam of the gear revealed that a fork bolt had been improperly adjusted. The facility that performed the last maintenance denied adjusting the bolt.Jun 13, 1988 · N7628Q · Substantial damageNTSB FTW88LA137Accident · No injuriesLimited investigationFinal reportCessna 182D · Gilmer, TXThe pilot said he made two approaches to runway 17 and two go-arounds. He said the wind then changed direction and he set-up for landing on runway 35. He said he should have gone around for the third time but instead he landed long, went through a fence and…Jun 13, 1988 · N9087X · Substantial damageNTSB SEA88LA111Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Kelso, WAThe plt stated that he selected rnwy 29 in very gusty conditions. He believed the landing was made with no problems. As the acft slowed below 45 mph it suddenly veered to the right. The plt failed to control the drift. The acft departed the runway and…Jun 12, 1988 · N1453A · Substantial damageNTSB FTW88LA121Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Mico, TXThe pilot said he was practicing water landings in the Lake. During a landing, the airplane started porpoising due to the wake of a passing boat. The airplane landed hard. The windsheild cracked and the pilot elected to take the airplane to the home airport…Jun 12, 1988 · N666BK · Substantial damageNTSB ATL88LA193Accident · No injuriesLimited investigationFinal reportCessna 195A · Port Clinton, OHDuring touchdown, the pilot noted a vibration and the airplane veered to the left. He attempted to correct by applying right brake and rudder, but the airplane continued off the left side of the runway into the grass. The right landing gear strut failed at…Jun 12, 1988 · N1527D · Substantial damageNTSB NYC88LA164Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Marlboro, NJThe pilot was making a landing to the west when he experienced a loss of directional control and groundlooped on the right side of the runway. He said the tailwheel of the acft was already on the ground when the groundloop occurred and he lost control when a…Jun 11, 1988 · N2313 · Substantial damageNTSB NYC88LA187Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Robbinsville, NJThe acft ground looped during landing roll and collided with terrain off the runway. The acft was landed on rwy 29 with the wind from 180 degrees at 15 KTS, gusting to 25 KTS. The acft turned into the wind and ran off the rwy to the south after traveling 1/3…Jun 10, 1988 · N97954 · Substantial damageNTSB LAX88LA220Accident · No injuriesLimited investigationFinal reportCessna 152 · Redding, CADuring a solo instructional flt, the pilot stated that he may have had his foot on the left rudder pedal on landing. When the airplane touched down it veered to the left off the runway and into a ditch. There were no reported mechanical failures or…Jun 10, 1988 · N25409 · Substantial damageNTSB ATL88LA192Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Mccormick, SCThe student pilot was on her second solo cross country flight. She had deptd donaldson center near greenville, SC and had flown to athens, ga where she had completed a touch and go landing. She then proceeded to Mccormick, SC and flew over the airport to…Jun 10, 1988 · N2609G · Substantial damageNTSB CHI88LA132Accident · No injuriesLimited investigationFinal reportCessna 172 · Fairmont, MNThe student pilot was attempting to land. Just prior to touchdown a gust of wind pushed the aircraft to the left of the runway. The pilot was unable to maintain control of the aircraft resulting in the aircraft encountering a stall and colliding with the…Jun 9, 1988 · N5317K · Substantial damageNTSB CHI88LA130Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Bedford, INThe pilot landed beyond his intended touchdown point on the runway due to excessive airspeed during the approach to landing and touchdown. When the aircraft ran off the departure end of the runway the pilot elected to perform an intentional ground loop/swerve…Jun 8, 1988 · N7151P · Substantial damageNTSB ATL88LA189Accident · No injuriesLimited investigationFinal reportCessna 152 · East Liverpool, OHThe student pilot reported that he flared late during ldg. The airplane ballooned and started drifting to the right. The student added pwr and left rudder in an attempt to maintain control; he 'overcompensated' with left rudder input, and lost directional…Jun 8, 1988 · N89059 · Substantial damageNTSB LAX88LA208Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Corona, CACompany maintenance personnel had replaced the nose landing gear assy and had conducted retraction tests prior to releasing the acft for flt. After takeoff the lndg gear was retracted and the flt was conducted without incident until, upon entering the traffic…Jun 7, 1988 · N2710M · Substantial damageNTSB BFO88IA057Incident · 1 fatalIncident investigationFinal reportPiper PA-31 · Morgantown, WVThe pilot died from coronary disease while practicing landings.Jun 7, 1988 · N811CM · No damageNTSB BFO88LA053Accident · No injuriesLimited investigationFinal reportCessna 172P · Gaithersburg, MDAccording to the plt, after touchdown the acft encountered a crosswind gust. The acft drifted left of the rwy where it collided with trees. The plt reported no mechanical malfunction.Jun 6, 1988 · N65720 · Substantial damageNTSB NYC88LA159Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-33 · Erwinna, PAAccident was a loss of directional control during landing which followed a hard landing. Contributing was the improper use of spoiler control by the private pilot and the failure of the flight instructor to adequately supervise the actions of the private…Jun 5, 1988 · N1240S · Substantial damageNTSB MKC88LA109Accident · No injuriesLimited investigationFinal reportCessna 182 · Dewitt, ARThe pilot was attempting to land on his personal grass strip, which had trees at both ends. The acft hit hard, bounced, then slid to a stop. The nose gear was separated.Jun 5, 1988 · N97536 · Substantial damageNTSB SEA88LA105Accident · No injuriesLimited investigationFinal reportCessna 175 · Olympia, WAAfter reducing power in order to land onto the runway a total loss of power occurred. The aircraft was landed short of the ruwnay and during landing roll a ditch was struck collapsing the right main and nose gear. Aircraft inspection revealed 2 2/3 gallons of…Jun 4, 1988 · N90134 · Substantial damageNTSB LAX88LA210Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Hemet, CADuring the landing while on a solo (instructional) night cross country flight, the airplane touched down, bounced, and veered left. During the second bounce between the runway and the taxiway, the pilot added power. The airplane continued in a straight path…Jun 4, 1988 · N6181L · Substantial damageNTSB DEN88LA124Accident · No injuriesLimited investigationFinal reportCessna A-185F · Phillipsburg, MTJun 4, 1988 · N94237 · Substantial damageNTSB DEN88LA118Accident · No injuriesLimited investigationFinal reportCessna 180 · Gettysburg, SDThe commercial plt and two passengers were flying to a fishing camp. During landing roll the plt applied brakes to turn off the runway. The nose got too FAR around and directional control was lost. The airplane ground looped to the left. The right wing, right…Jun 2, 1988 · N2123Z · Substantial damageNTSB ANC88LA066Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-3 · Eagle, AKThe pilot was attempting to land a heavily loaded De Havilland otter (DHC-3) on a gravel strip in rural Alaska. Upon touchdown, the pilot reported that the airplane veered slightly to the right. He unlocked the tail wheel centering device and attempted to…Jun 2, 1988 · N3125N · Substantial damageNTSB ANC88LA064Accident · No injuriesLimited investigationFinal reportCessna 206 · Chugiak, AKThe pilot stated that during the landing roll he lost directional control of the aircraft causing the aircraft to exit the left side of the runway into an open ditch. The aircraft traveled approximately 1000 feet of the runway.Jun 2, 1988 · N4571K · Substantial damageNTSB MIA88LA182Accident · No injuriesLimited investigationFinal reportCessna 152 · Marco Island, FLWhile on an instructional flt prior to touchdown on rwy 17, the flt was advised that the winds were from 110 degrees at 15 KTS with gusts to 20. The CFI stated that the aircraft was slow on final apch. With 20 degrees of flaps lowered, the acft was blown off…May 31, 1988 · N25516 · Substantial damageNTSB MIA88IA181Incident · No injuriesIncident investigationFinal reportCessna P210N · Daytona Beach, FLThe plt rprtd that while on final apch to land, he became distracted by conversation with the passenger & failed to lower the landing gear. Subsequently, the acft was landed with the gear retracted. After it was lifted from the rwy after the incident, the…May 30, 1988 · N6330W · Minor damageNTSB CHI88LA122Accident · No injuriesLimited investigationFinal reportCessna 152 · Romeoville, ILMay 30, 1988 · N68312 · Substantial damageNTSB SEA88LA102Accident · No injuriesLimited investigationFinal reportBeech B55 · Reno, NVThe pilot was attempting to land on runway 25 with winds from 290 degrees at 17 knots. Just prior to flare, the aircraft encountered a gust of wind. The pilot lost control of the aircraft and landed hard on the right main gear. The right strut, wheel and…May 29, 1988 · N8567M · Substantial damageNTSB NYC88LA155Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Franconia, NHThe pilot landed the aircraft long on a grass runway with a tailwind. The pilot reported that she touched down longer than anticipated, but she thought she would have had adequate stopping distance. She was unable to stop the acft on the remaining runway and…May 29, 1988 · N6115B · Substantial damageNTSB NYC88DFA01Accident · No injuriesFinal reportLloyd Feary VJ-22 · Kingston, NYThe aircraft was substantially damaged when it swerved off the side of the runway during landing roll on the first flight by the new owner. The homebuilt amphibian had been inspected by a mechanic, who signed off an annual inspection for the engine but noted…May 29, 1988 · N59262 · Substantial damageNTSB CHI88LA121Accident · No injuriesLimited investigationFinal reportCessna R172K · Aurora, ILThe pilot said that on final apch, 'a rapid descent took place.' The aircraft touched down on the rwy and bounced. The pilot said he added pwr and lowered the nose, but the nose gear and propeller hit the rwy. The acft bounced again and sustained substantial…May 29, 1988 · N736AF · Substantial damageNTSB BFO88LA052Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Milford, DEThe plt stated the landing apch was too fast and the acft bounced on touchdown. The plt stabilized the acft and attempted another touchdown, however, the acft bounced again. Having used over half the rwy by this time, the plt elected to abort the landing by…May 29, 1988 · N35253 · DestroyedNTSB LAX88LA202Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Sonoma, CAFailure to adequately supervise the flight and recover from the student pilot's bounced landing.May 28, 1988 · N4139Y · Substantial damageNTSB FTW88DRD06Accident · No injuriesFinal reportGrumman G-164A · Abbeville, LAThe ag plt had finished spreading his load of chemicals & was landing when the left brake failed to operate. He started to apply pwr for a go-around, but the eng coughed & did not respond properly. The plt then closed the throttle & appliedrgt brake to avoid…May 28, 1988 · N7203 · Substantial damageNTSB DEN88LA113Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Collins, COThe student pilot was returning from a cross country training flight. At touchdown the acft bounced and began to porpoise. The nose gear collapsed and the plane nosed down. The FBO reported calm winds and dry rnwy conditions.May 28, 1988 · N67446 · Substantial damageNTSB LAX88LA219Accident · No injuriesLimited investigationFinal reportCessna 182M · Flagstaff, AZAt the end of a local flight, the plt was landing in gusting conditions in excess of 30 knots. According to the pilot the approach was faster than normal due to a sick passenger. On touchdown the nosewheel touched first and the airplane began a porpoising…May 27, 1988 · N70618 · Substantial damageNTSB LAX88LA198Accident · No injuriesLimited investigationFinal reportEnstrom F28A · La Verne, CAThe helicopter landed hard during a practice touchdown autorotation (auto). The helo remained in closed traffic for the purpose of practicing touchdown autos to a landing area adjacent to the aprt's rwy. There was also another helo in closed traffic using the…May 27, 1988 · N4898 · Substantial damageNTSB CHI88LA118Accident · No injuriesLimited investigationFinal reportCessna 172M · Plainwell, MIDuring an unauthorized flight of unknown duration, by person(s) unknown, aircraft control was not maintained. The aircraft was observed by a witness to 'wobble' as it approached the runway. The witness then saw the aircraft 'crash' into the grass at the left…May 27, 1988 · N20389 · Substantial damageNTSB MKC88LA097Accident · No injuriesLimited investigationFinal reportCessna 310K · Kansas City, KSDuring a lndg roll subsequent to landing, the nose landing gear collapsed. A post-impact insptn of the gear indicated that a bolt (which retains the retract arm to the bellcrank) had sheared. The bolt was also discovered to have been installed in the wrong…May 24, 1988 · N7011L · Substantial damageNTSB FTW88DRA13Accident · No injuriesFinal reportHudson Mustang II · Tomball, TXThe acft was substantially damaged when control was lost during the rollout after ldng with a 12 knot left crosswind. Following the loss of control, the acft veered left of the rwy, struck a rwy lt, hit a ditch, and flipped over.May 23, 1988 · N29WH · Substantial damageNTSB BFO88LA049Accident · No injuriesLimited investigationFinal reportCessna 180 · Annapolis, MDDuring the landing rollout the aircraft drifted to the left. The left main wheel departed the pavement and encountered soft terrain. The aircraft groundlooped and nosed over. The pilot did not file an accident report.May 22, 1988 · N3173C · Substantial damageNTSB ATL88LA182Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Shellman, GAThe plt was making a personal flt to a pvt uncharted airstrip on a coastal island. Approaching his destination, the plt cancelled his VFR flt plan with fss. The plt stated that he approached the soft 2500 foot strip high and ballooned at touchdown. He landed…May 21, 1988 · N8374U · Substantial damageNTSB FTW88LA107Accident · No injuriesLimited investigationFinal reportCessna 172N · Graham, TXThe student pilot was on a solo round-robin cross country training flight. He made a hard landing on the nose wheel that resulted in a propeller ground strike and damaged engine firewall. Gusty surface winds prevailed at the time of the accident.May 19, 1988 · N4659G · Substantial damageNTSB ATL88LA177Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Lebanon, OHThe plt was making an apch for a full stop ldg with a quartering right tailwind. He stated that he had been previously told to always land on rwy 27 and takeoff from runway 09 at this apt. Witnesses indicated that the airplane touched down about half way down…May 19, 1988 · N69161 · Substantial damageNTSB FTW88LA105Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Plano, TXThe student pilot was returning from practice in the local area and was attempting a landing with a left quartering headwind, with wind gusts. After touchdown, the airplane started to float and drifted to the left, off the runway. The pilot attempted a…May 18, 1988 · N4675G · Substantial damageNTSB MIA88LA171Accident · No injuriesLimited investigationFinal reportCessna 172N · Miami, FLThe plt stated that upon touchdown, the aircraft landed hard, bounced twice and ran off the side of the runway into the grass.May 16, 1988 · N734QP · Substantial damageNTSB CHI88LA114Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Charlotte, MIDuring touchdown in a slight right crosswind, the student pilot inappropriately applied right rudder pressure. The aircraft yawed to the right and left the sod runway, veering into a plowed field. The aircraft struck a furrow and nosed over.May 16, 1988 · N8800C · Substantial damageNTSB ATL88FA173Accident · No injuriesField investigationFinal reportSwearingen SA-226-TC · Atlanta, GADuring a visual approach to runway 27L, the airplane was landed gear up. Both the capt and f/o stated that the landing gear had been lowered over the outer marker and that they had observed three green lights and that the warning horn had not sounded prior to…May 16, 1988 · N1013G · Substantial damageNTSB SEA88LA096Accident · No injuriesLimited investigationFinal reportCessna 172N · Anacortes, WAAfter overflying the intended seaplane base landing area. The pilot, who had logged only 1 hour of fixed wing time in the previous 90 days, misjudged the necessary downwind leg length and landed with insufficient surface distance available to stop the…May 15, 1988 · N4723J · Substantial damage