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 LAX87LA256Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Huron, CAAt the end of a cross country flight,the plt applied the brakes on touch down. The acft veered to the left and the plt applied the right brake, however, the left main landing gear went off the edge of the rwy. The acft went out of control, exited the rwy and…Jul 4, 1987 · N8273P · Substantial damageNTSB ANC87LA089Accident · No injuriesLimited investigationFinal reportCessna 180 · Matanuska Glaci, AKThe pilot stated that upon touchdown on the glacier the surface was cluster snow. The aircraft rolled about 150 feet and nosed over on its back.Jul 4, 1987 · N2995T · Substantial damageNTSB SEA87LA198Accident · No injuriesLimited investigationFinal reportCessna 150A · Tacoma, WAWhile lndg, the plt decided to go around. He stated the acft floated as he applied pwr & the pwr increased to about 2400 RPM. He raised the nose slightly & retracted the electrically operated flaps from 35 to zero deg. He said he established a climb to about…Jul 3, 1987 · N9815J · Substantial damageNTSB SEA87LA134Accident · No injuriesLimited investigationFinal reportCessna 182 · Sprague River, ORA hard, flat, bounced landing occurred collapsing the nose gear and damaging the firewall.Jul 3, 1987 · N2625Q · Substantial damageNTSB SEA87LA130Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Olympia, WADuring landing roll the pilot was unable to maintain directional control. The aircraft veered to the side of the runway onto soft terrain. The aircraft then nosed over inverted. Investigation revealed that the nose gear had collapsed but the reason for the…Jul 3, 1987 · N55FS · Substantial damageNTSB FTW87LA157Accident · No injuriesLimited investigationFinal reportCessna 172L · Houston, TXWhile lndg, the student plt had flared the acft in a rgt x-wind with gusts to 13 KTS. Subsequently, the acft drifted left & the left main gear went into soft mud. The acft then veered to the left and was damaged.Jul 3, 1987 · N3980Q · Substantial damageNTSB DEN87LA174Accident · Serious injuriesLimited investigationFinal reportRaven S77A · Silverthorne, COThe commercial balloon pilot was conducting passenger flights. A landing was being made on a parking lot with ten knots of wind and gusts to twenty knots. Just at touchdown a light gust caught the balloon and dragged it one hundred feet. One passenger chose…Jul 3, 1987 · N41986 · No damageNTSB ATL87LA196Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Sebring, OHPlt and his two pax had spent most of the day at barber apt preparing for the fireman's bbq to be held later. In late afternoon, they decided to take a flt around the area. During the flt, it was decided to land at the tri-city apt. Witnesses reptd that the…Jul 3, 1987 · N7659M · Substantial damageNTSB ANC87LA092Accident · No injuriesLimited investigationFinal reportPiper J-3 · Lake Creek, AKThe pilot stated he touchdowned on a gravel bar and shortly after touchdown he lost control of the aircraft causing the aircraft to nose over on its back.Jul 2, 1987 · N3691K · Substantial damageNTSB ANC87LA088Accident · No injuriesLimited investigationFinal reportPiper PA-18-180 · Pingo Ridge, AKThe pilot stated that after touchdown he lost control of the aircraft causing the aircraft to nose over on its back.Jul 2, 1987 · N4408Z · Substantial damageNTSB LAX87LA266Accident · No injuriesLimited investigationFinal reportCessna 152 · Pacoima, CAThe student plt rprtd that he entered the traffic pattern to practice takeoffs & landings. He said that drg his 1st apch, he relaxed pressure on the left rudder pedal & the acft began to yaw. He then pulled aft on the yoke to avoid touching down sideways &…Jun 30, 1987 · N24233 · Substantial damageNTSB FTW87LA155Accident · No injuriesLimited investigationFinal reportCessna 152 · Farris, OKThe plt rprtd that drg a x-country flt, he got lost & the acft ran low on fuel. At dusk, he elected to make a precautionary landing in a open field. Drg the landing, the acft struck a tree & was damaged.Jun 30, 1987 · N49131 · Substantial damageNTSB BFO87LA044Accident · No injuriesLimited investigationFinal reportCessna 150H · Hot Springs, VAOn the second leg of a cross-country flight from annapolis, MD to albuquerque, NM, the pilot became disoriented and was unable to locate ingalls airport in Hot Springs, VA. The pilot realized he was low on fuel and decided to make a precautionary landing on a…Jun 30, 1987 · N23106 · Substantial damageNTSB MIA87LA193Accident · No injuriesLimited investigationFinal reportStinson 108-1 · West Palm Beach, FLWhile on an instructional flt during the landing roll the acft began to drift to the right. The student plt corrected the drift with left rudder, however he then added full power. The acft then ground looped to the left, during which the right main gear…Jun 29, 1987 · N8399K · Substantial damageNTSB MIA87IA192Incident · No injuriesIncident investigationFinal reportCessna 310J · Sarasota, FLDuring the landing roll the rt main landing gear collapsed after which the acft slid off the rwy, collided with a taxiway light & came to rest. Insp of the rt main landing gear revealed that the downlock spring failed which prevented the gear from fully…Jun 29, 1987 · N3120L · Minor damageNTSB LAX87LA254Accident · No injuriesLimited investigationFinal reportBeech C90 · Lakeport, CAThe pilot indicated that the left main gear collapsed during landing rollout. The pilot did not respond to the following questions, when asked during a telephone interview, 'when was the gear placed down? And what did the gear safe indicator lights indicate…Jun 29, 1987 · N2030W · Substantial damageNTSB ATL87LA192Accident · No injuriesLimited investigationFinal reportNavion H · New Ellenton, SCPreviously, the acft had been involved in a gear-up lndg & was out of svc while it was being repaired. Drg that time the annual inspn expired. A special airworthiness certificate was obtained to ferry the acft to the sizemore arpt for the annual inspn. Drg…Jun 28, 1987 · N2525T · Substantial damageNTSB SEA87LA126Accident · Minor injuriesLimited investigationFinal reportCessna 180A · Dallas, ORThe pilot inadvertently landed with a quartering gusting tailwind. On landing rollout the aircraft nosed over inverted.Jun 27, 1987 · N5270D · Substantial damageNTSB LAX87LA253Accident · No injuriesLimited investigationFinal reportBeech C23 · Brownsville, CADuring a cross country flt, the plt over flew the rwy once for a visual wind speed and direction check. During the first approach the acft was too high so the plt went around. On the second approach, during the flare, the acft stayed airborne down most of the…Jun 27, 1987 · N5161M · Substantial damageNTSB DEN87LA160Accident · No injuriesLimited investigationFinal reportCessna 182RG · Deming, NMDuring the landing flare the plt reported he flared late and the acft bounced and porpoised. The plt commented and the plt rated passenger in the right seat misinterpreted the comment as a request for assistance. With two people conflicting on the controls a…Jun 27, 1987 · N6124T · Substantial damageNTSB BFO87LA043Accident · No injuriesLimited investigationFinal reportCessna 195A · Cambridge, MDAfter purchasing the acft in atl, the plt, who held an a & p certificate, inspected and flew the acft in the local area bfr departing on a ferry flt to rockland, ME. Drg lndg at his first fuel stop, the acft swerved to the rt and the plt intentionally…Jun 27, 1987 · N9321A · Substantial damageNTSB NYC87LA189Accident · No injuriesLimited investigationFinal reportPiper PA-60 · Doylestown, PAUpon landing, the flight encountered standing water on the runway and the aircraft hydroplaned veering right of the centerline. The main landing gear collapsed causing substantial damage. The acft went off the rt side of the rwy after 2839 ft of roll and…Jun 26, 1987 · N14HR · Substantial damageNTSB FTW87LA154Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Baytown, TXDrg the lndg roll, the acft started to drift to the left, so the plt corrected with right rudder. He said he over- controlled, then applied left rudder & brake, followed by right rudder & brake. Subsequently, the situation became aggravated until both main…Jun 26, 1987 · N3564L · Substantial damageNTSB ATL87IA191Incident · No injuriesIncident investigationFinal reportSwearingen SA-226TC · Nashville, TNThere was hvy traffic at the Nashville metro arpt when air midwest flt 4530 (Swearingen SA-226TC, N256AM) arrived drg a morning flt. The flt crew made an ILS apch to rwy 31 as another acft (American flt 130) was on an apch to rwy 2L. The 2 rwys intersected nr…Jun 26, 1987 · N256AM · No damageNTSB ATL87LA190Accident · No injuriesLimited investigationFinal reportCessna A188B · Dyersburg, TNDrg a spraying opn, the plt returned to land on an asphalt hiway & reload with chemicals. As he flared to lnd, the eng accelerated to aprx '2/3 throttle' with no throttle movement. He believed the throttle was in the off psn when this occurred. A nose hi…Jun 25, 1987 · N2828J · Substantial damageNTSB ATL87LA186Accident · No injuriesLimited investigationFinal reportCessna 152 · Dothan, ALThe comm plt held a helicopter rating and was training for his private pilot single-engine-land rating. He had flown approximately 10 hours in fixed wing aircraft with 6 hours as PIC. The pilot had completed two landings and on the thirdapproach stated he was…Jun 25, 1987 · N45994 · Substantial damageNTSB NYC87LA185Accident · No injuriesLimited investigationFinal reportPiper PA-34 · Southbridge, MADuring landing roll, a failure of a tire tube caused a flat tire and control of the aircraft was lost. When the tire was dismantled, the inner tube was found to be defective at the joint seam. Total time on the acft and tire WAS407 hrs. The acft had a 100 hr…Jun 24, 1987 · N4348T · Substantial damageNTSB NYC87LA184Accident · No injuriesLimited investigationFinal reportCessna 152 · Butler, PAThe student pilot landed at Butler farm airport. The plt overshot the normal touchdown point at excessive speed. The aircraft skidded off the end of the runway and collided with a three foot deep ditch and was substantially damaged.Jun 24, 1987 · N93304 · Substantial damageNTSB ATL87LA183Accident · No injuriesLimited investigationFinal reportCessna 140 · Falmouth, KYThe pilot was on a cross-country flight and had made several refueling stops during the day. He stated that during landing he experienced a crosswind of approximately 7 to 10 knots. The aircraft bounced, rocked up on the left main landing gear, departed the…Jun 23, 1987 · N89784 · Substantial damageNTSB LAX87LA244Accident · No injuriesLimited investigationFinal reportNord 3202 · Bishop, CADuring a relocation flight of a newly purchased acft, the plt was making a cross wind landing when on touchdown the left wing raised. The plt corrected by applying left aileron, however, he also relaxed the back pressure on the control stick allowing the tail…Jun 22, 1987 · N32RM · Substantial damageNTSB ATL87LA181Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Belton, SCThe pilot reported that while on short final he experienced a downdraft which caused him to land hard. The aircraft bounced and went off the left side of the sod strip. The pilot lost control of the aircraft after it bounced. The pilot estimated that surface…Jun 22, 1987 · N8105X · Substantial damageNTSB ATL87LA180Accident · No injuriesLimited investigationFinal reportLockheed L-382-30 · Dayton, OHThe flight experienced separation of the nose landing gear during the landing roll. Investigation showed that the failure was related to the progression of a preexisting crack on the nose landing gear strut assembly. The probelms with the nose landing gear…Jun 22, 1987 · N20ST · Substantial damageNTSB SEA87LA120Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Yakima, WAWhile on landing roll in gusty crosswind conditions, the aircraft swerved off the runway and ground looped.Jun 21, 1987 · N27039 · Substantial damageNTSB FTW87LA148Accident · No injuriesLimited investigationFinal reportCessna 182 · Alice, TXThe pilot stated that during landing roll the right brake locked, the aircraft exited the runway, crossed a grassy area and collided with an airport light pole. Inspection of the brakes, rudder and nose wheel steering revealed no preimpact mechanical…Jun 21, 1987 · N5496E · Substantial damageNTSB DEN87LA155Accident · No injuriesLimited investigationFinal reportCessna 172 · Paradise, UTThe plt departed bear lake arpt, montpelier, ID, and flew to logan, UT. He departed logan and flew to his father's ranch at avon, UT, near Paradise. A 1400-FT dirt/gravel driveway leading to the ranch house was used as a rwy. The plt said he helped his father…Jun 21, 1987 · N7121A · Substantial damageNTSB NYC87LA182Accident · No injuriesLimited investigationFinal reportMaule M-4 · Wellsville, NYThe flight experienced a violent shimmy upon t/d and the acft veered to the right. The pilot made a go-around and experienced the same condition on the second t/d. on the third t/d, the pilot landed but was only able to maintain control of the acft until it…Jun 20, 1987 · N40354 · Substantial damageNTSB ATL87LA178Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Augusta, GAThe aircraft was on its first flight from the factory. The pilot was checked out in the aircraft on the day prior to theaccident flight. Witnesses reported the aircraft touched down and lifted off several times. The pilot stated the aircraft got away from him…Jun 20, 1987 · N5667F · Substantial damageNTSB MKC87LA171Accident · No injuriesLimited investigationFinal reportCessna TU206G · West Plains, MODuring ldg phase of operation, PIC was unable to stop the acft before striking a fence on the overrun. Plt stated a rain shower had just passed through which left the dirt surface slick and muddy. He stated that he was unable to obtain effective braking due…Jun 19, 1987 · N4881U · Substantial damageNTSB LAX87LA237Accident · No injuriesLimited investigationFinal reportGrumman AA-5 · Rimrock, AZThe aircraft overran the runway while on a personal VFR cross-country flight. The pilot indicated that he attempted a go-around after a poor approach and that the terrain off the end of the runway rose faster than the aircraft could climb. A witness observed…Jun 19, 1987 · N5438L · Substantial damageNTSB FTW87LA147Accident · No injuriesLimited investigationFinal reportBeech B36TC · Barnhart, TXUpon landing the pilot lost control of the aircraft due to a crosswind. The pilot attempted a go-around but contacted bushes and rough terrain causing the aircraft to nose over.Jun 19, 1987 · N69309 · Substantial damageNTSB ATL87LA176Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Marion, NCThe acft overran the rwy end while the student plt was attempting a no-flap ldg. The acft impacted a berm at the end of the rwy and subsequently came to rest in a creek. The student plt reported that the acft had initially touched down about mid-field on the…Jun 19, 1987 · N52575 · Substantial damageNTSB ANC87LA082Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Iliamna, AKThe student pilot stated that during a landing roll on the gravel bar he lost directional control of the aircraft causing the aircraft to nose over on its back.Jun 19, 1987 · N95695 · Substantial damageNTSB CHI87LA152Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Muncie, INAfter landing on rwy 32 the acft veered to the left, crossing a parallel taxiway and striking a taxiway light. The plt stated that the acft then became airborne before striking a terrain depression, at which time the nosewheel sheared off and the propeller…Jun 18, 1987 · N9174M · Substantial damageNTSB ATL87LA171Accident · No injuriesLimited investigationFinal reportLuscombe 8A · London, OHThe pilot was making a planned refueling stop at madison county airport. He stated he made a normal pattern entry, approach and landing. During the roll out the aircraft groundlooped to the right and departed the runway. Investigation revealed no preimpact…Jun 18, 1987 · N1029K · Substantial damageNTSB CHI87LA150Accident · No injuriesLimited investigationFinal reportHughes 300C · Aurora, ILWhile the student & instructor (CFI) were on an instructional flt, a decision was made to practice an autorotation & simulated tail rotor failure. Rprtdly, a smooth touchdown was made, but the helicopter began to vibrate. The CFI electedto get the helicopter…Jun 17, 1987 · N3625B · Substantial damageNTSB ANC87DAG03Accident · No injuriesFinal reportDenney FOX 1 · Palmer, AKThe pilot stated that after touchdown on the sand bar the aircraft struck an open ditch. The pilot lost directional control of the aircraft causing the plane to nose over on its back.Jun 17, 1987 · N4987 · Substantial damageNTSB NYC87LA173Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Canastota, NYA student pilot was performing tkofs and lndgs when after touchdown on the third landing, he lost directional control of the aircraft. After atmptg to salvage the lndg, the pilot initiated a go-around but the left wing stalled and the aircraft impacted on the…Jun 15, 1987 · N2477B · Substantial damageNTSB SEA87LA117Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-36 · Reno, NVWhile soaring, thunderstorms developed in the area. The pilot returned to the landing field, encountering turbulence and gusty winds. On landing roll, gusty winds caused the single-wheel glider to drift into a parked vehicle. Surface winds reported at Reno…Jun 14, 1987 · N3616F · Substantial damageNTSB SEA87LA116Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Odessa, WADuring landing roll on a dirt road, the aircraft drifted to the side, encountered the shoulder ditch and flipped over.Jun 14, 1987 · N5458W · Substantial damageNTSB MIA87LA183Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Miramar, FLThe student plt was conducting solo touch & go ldgs when directional control of the acft was lost & the acft left the rwy & collided with a rwy designator sign during the ldg phase.Jun 14, 1987 · N2537N · Substantial damage