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 SEA88LA022Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Las Vegas, NVDuring practice autorotation the pilot flared excessively high and the tail boom struck the ground. The pilot then lost control of the aircraft. The density alt was 2616 feet. A rt quartering tailwind was present.Nov 24, 1987 · N22730 · DestroyedNTSB NYC88LA044Accident · Minor injuriesLimited investigationFinal reportBell 206B · Beverly, MAThe helicopter was on a normal approach to Beverly airport and was cleared to cross runway 27 from the southeast. The pilot entered an autorotation but realized that the ground was under construction and was very muddy. In an attempt to shift directions at…Nov 24, 1987 · N3888Q · Substantial damageNTSB ATL88LA045Accident · No injuriesLimited investigationFinal reportCessna 150M · Waynesboro, GAThe student plt lost control of the airplane while landing, during his second supervised-solo flt. The airplane veered off of the rwy into a ditch where the nosegear collapsed and the airplane nosed over. The wind was reportedly calm.Nov 24, 1987 · N4081V · Substantial damageNTSB NYC88LA039Accident · No injuriesLimited investigationFinal reportWaco ZKC-5 · No. Canaan, CTThe aircraft touched down in a 3-point landing attitude at north Canaan, Connecticut. The left landing gear wheel rotated 90 degrees and the left gear was dragged 144 yards before the aircraft became inverted. It was revealed that the braze joint at the top…Nov 23, 1987 · N14164 · Substantial damageNTSB DEN88LA027Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Broomfield, COThe private pilot was flying to build time. After an hour of flight, the plt returned to the home airport and attempted to land. Landing gear would not extend properly and manual gear extension did not help. All gear was partially extended and would not…Nov 23, 1987 · N7291P · Substantial damageNTSB FTW88IA029Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Newark, NJImmediately after the hard landing the captain was observed by the copilot and flight engineer to be incapacitated. The copilot took control of the airplane and guided it onto a high speed taxiway. With the aid of a flight attendant and the flight engineer…Nov 22, 1987 · N121AA · No damageNTSB LAX88LA055Accident · No injuriesLimited investigationFinal reportCessna 172N · San Jose, CAAt the conclusion of a cross country instructional flight, the pilot made three approaches to land. On the first two attempts, the aircraft touched down on the nose wheel and porpoised, then the pilot initiated a go-around. On the third landing, the aircraft…Nov 21, 1987 · N9568G · Substantial damageNTSB CHI88LA030Accident · Minor injuriesLimited investigationFinal reportCessna 337 · Kankakee, ILThe pilot was attempting to land on runway 22 at an uncontrolled airport when he heard another pilot transmit he was about to depart from the same runway. According to the pilot, while he was turning on to final approach, he observed an aircraft taxiing to…Nov 21, 1987 · N6255F · Substantial damageNTSB MIA88LA043Accident · No injuriesLimited investigationFinal reportNorth American 500 · San Juan, PRWhile on a part 135 non-scheduled domestic passenger flt in VFR conditions, the plt landed the acft gear up. Operational check of the landing gear & warning horn revealed no failure or malfunction.Nov 20, 1987 · N4111P · Substantial damageNTSB FTW88LA030Accident · No injuriesLimited investigationFinal reportCessna 185 · Burnet, TXDuring landing roll, the aircraft drifted to the left of the runway centerline. Witnesses then observed the aircraft veer to the right and ground loop coming to rest off the end of the runway. Attempts to contact the student plt have not been successful.Nov 20, 1987 · N7370H · Substantial damageNTSB ANC88LA017Accident · No injuriesLimited investigationFinal reportCessna 208 · Atmautluak, AKThe pilot stated that he landed at a distance approximately one-third of the way down the 2,000 foot ice covered gravel runway. After touchdown the pilot lost directional control of the aircraft causing the aircraft to exit the departure end of the runway.…Nov 18, 1987 · N9370F · Substantial damageNTSB NYC88LA040Accident · No injuriesLimited investigationFinal reportCessna 210 · Schenectady, NYDuring landing, the left main gear collapsed. A metallurgical examination revealed that the left main gear saddle assembly was fractured into three pieces through the area near the forward edge of the landing gear strut. When examined further, the faces and…Nov 14, 1987 · N9568T · Substantial damageNTSB NYC88LA038Accident · No injuriesLimited investigationFinal reportGrumman AA-1B · Tewksbury, MAThe student pilot was attempting a landing at Tewksbury, Massachusetts when he flared above the runway, bounced several times and collapsed the nose wheel. The aircraft slid down the runway, made contact with the right side of the runway edge, spun around,…Nov 14, 1987 · N8993L · Substantial damageNTSB LAX88LA048Accident · No injuriesLimited investigationFinal reportBeech 58 · Jackson, CAThe plt rprtd that prior to reaching the destn, he received an adzy on the UNICOM freq that rwy 19 was in use & that there was a direct x-wind. Drg arrival, he tried to contact UNICOM again to get a wx update, but was unable. He elected to lnd on rwy 19.…Nov 14, 1987 · N9106Q · Substantial damageNTSB CHI88LA023Accident · No injuriesLimited investigationFinal reportCessna A150K · Elkhart, INThe plt of Cessna A150K, N8382M, was landing after the plt of another Cessna 150 had landed & had started to back-taxi up the same rwy. The plt of the other acft stated that she had announced her intentions to back taxi up the rwy & that she did not hear any…Nov 14, 1987 · N8382M · Substantial damageNTSB NYC88LA036Accident · No injuriesLimited investigationFinal reportBeech 36 · Utica, NYThe flight was enroute from bridgeport, Connecticut to old forge, new york when adverse weather conditions were encountered. A request for lower altitude to escape weather was no improvement and a request to land at oneida was made. During radar vectors…Nov 12, 1987 · N9230Q · Substantial damageNTSB MIA88LA035Accident · No injuriesLimited investigationFinal reportCessna 152 · Zephyrhills, FLAfter successful completion of 6 dual touch-and-go landings, the student plt departed to perform 3 touch-and-go landings for her first solo flight. The instructor plt stated that the apch to the first landing appeared to be low & after touchdown, the acft…Nov 12, 1987 · N6369H · Substantial damageNTSB LAX88LA041Accident · No injuriesLimited investigationFinal reportBeech C23 · Fallbrook, CAThe student pilot was on his first solo flight in the Beech C23 aircraft. On landing the pilot pulled back on the elevator control and the aircraft began to porpoise. The aircraft touched down hard and the nose gear collapsed. The aircraft slid off the side…Nov 12, 1987 · N37188 · Substantial damageNTSB FTW88LA027Accident · No injuriesLimited investigationFinal reportCessna 152 · Lawton, OKThe student pilot stated that during flare/touchdown the aircraft bounced and came down hard on the nose gear collapsing it and damaging the prop and firewall. The majority of the student pilots flt time was obtained while in the military.Nov 12, 1987 · N65584 · Substantial damageNTSB CHI88DEE01Accident · No injuriesFinal reportAlexander Volksplane VP-1 · Dekalb, ILThe plt had little experience flying tailwheel equipped acft & had only 10 hrs flt time in this make & model. During arrival, he landed on rwy 27 with a quartering left x-wind that was gusting to 20 KTS. Just before touchdown, a gust of wind caused the acft…Nov 12, 1987 · N99VP · Substantial damageNTSB MIA88LA031Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · St. Petersburg, FLThe plt, familiar with the arpt, overflew it 2 times in an attempt to activate the rwy lights using the acft's radio as well as to observe the wind sock. After observing a northerly wind & being unable to activate the lights he elected to land on rwy 36…Nov 10, 1987 · N82811 · Substantial damageNTSB CHI88LA022Accident · No injuriesLimited investigationFinal reportPiper PA-30B · Decatur, ILThe aircraft experienced a landing with the gear retracted. The pilot stated that he perceived the yellow light indication for the landing gear to mean 'down', instead of looking for a green light.Nov 10, 1987 · N7865Y · Substantial damageNTSB MKC88LA016Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Leavenworth, KSWhile practicing landings and takeoffs, the PIC inadvertently put the gear switch in the retract cycle while rolling out. The gear began its retraction cycle with the acft still on the rwy, damaging the retraction system. The plt elected to tkof, but once…Nov 8, 1987 · N7277Y · Substantial damageNTSB MIA88LA029Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Daytona Beach, FLWhile practicing short field landings, the student plt flared the acft prematurely resulting in a hard landing & substantial damage. The acft was then taxied to the ramp.Nov 8, 1987 · N269ER · Substantial damageNTSB LAX88LA037Accident · No injuriesLimited investigationFinal reportRobinson R-22 · San Luis Obispo, CAA Robinson R22 landed hard while on a VFR business flight. The pilot reported that he landed hard during a downwind approach to a landing site. He examined the helicopter and noticed the aft landing gear cross tube was bent. He felt the helicopter was…Nov 8, 1987 · N123PL · Substantial damageNTSB ATL88LA050Accident · No injuriesLimited investigationFinal reportErcoupe 415-CD · Union City, TNThe plt rprtd the acft started to veer off the rwy after a 'rough' lndg. He atmtd to steer the plane with the steering control, but it would not respond. Subsequently, the acft veered off the rwy. About 50' to the side of the rwy, the nose gear hit a hole &…Nov 8, 1987 · N3849H · Substantial damageNTSB ATL88LA029Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Sebring, OHThe airplane landed hard short of the rwy, and sustained structural damage to the ldg gear and both wings. The plt reported that he had been distracted by another airplane that entered the traffic pattern ahead of him, and had inadvertently allowed the…Nov 7, 1987 · N667FL · Substantial damageNTSB MIA88IA028Incident · No injuriesIncident investigationFinal reportBeech 99 · Gulfport, MSWhile on a part 135 scheduled domestic passenger flt during final apch, the nose landing gear failed to fully extend. The plt recycled the gear, but the gear failed to fully extend. He then attempted to lower the gear using the emergency method, again, with…Nov 6, 1987 · N6724D · Minor damageNTSB ATL88LA033Accident · No injuriesLimited investigationFinal reportCessna 172K · Cumming, GAThe student plt rptd that the airplane contacted the rwy and bounced twice during the ldg flare. Once he got the airplane on the rwy, he realized that the airspeed was 'too high' for the rwy remaining and attempted to ground loop the airplane to stop it. The…Nov 6, 1987 · N7140G · Substantial damageNTSB NYC88LA029Accident · No injuriesLimited investigationFinal reportCessna 172 · Marlboro, MAThe pilot was attempting a landing at Marlboro airport. Upon touchdown brakes were applied. According to the pilot, the aircraft was not stopping but instead was sliding down the runway. The pilot turned the nosewheel to the left to slow the aircraft but…Nov 1, 1987 · N6439D · Substantial damageNTSB NYC88LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Chatham, MAThe duration of the pleasure flight was about 25 minutes and was uneventful. The pilot made the approach and entered the traffic pattern in the standard manner and radioed UNICOM of her intentions to land. The pilot stated that she landed longer than usual…Nov 1, 1987 · N757PY · Substantial damageNTSB NYC88LA024Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Erwinna, PAThe pilot was landing the aircraft on runway 25 at vansant airport. At about 100 feet down the runway, the aircraft veered to the left, off of the runway and slid down an embankment and came to rest after colliding with a tree.Nov 1, 1987 · N4302T · Substantial damageNTSB MIA88LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Sarasota, FLDrg arrival, while being transferred from tampa apch ctl to twr ctl, the plt was clrd to lnd on rwy 14. Bfr lndg, he was adzd the wind was fm 070 deg at 15 KTS. Rwy 4 was available, but it was not suggested by the twr ctlr or reqd by the plt. The plt stated…Oct 31, 1987 · N2746Q · Substantial damageNTSB MIA88FA024Accident · 1 fatalField investigationFinal reportBeech C-55 · Brookhaven, MSThe pilot of the twin engine aircraft landed with vis 1/2 mile in fog and realized he had landed long. He executed a go-around and on the second landing forgot to lower the landing gear. The propellers stuck the runway and severely damaged one propeller. He…Oct 31, 1987 · N640B · DestroyedNTSB DEN88DTE01Accident · No injuriesFinal reportQuickie Q-200 · Watkins, COThe plt rprtd he failed to lock the aileron reflexers tight for landing. During the landing roll, the lock slipped & the tail lifted off the rwy. Subsequently, the acft veered to the right, went off the rwy & hit a mudhole, then flipped over.Oct 31, 1987 · N275CH · Substantial damageNTSB NYC88LA027Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Windham, CTThe flight departed groton, Connecticut enroute to willimantic, Connecticut in unlimited visibility. However at Windham airport, the runway was partially obscured by patchy fog according to the pilot. The pilot landed long due to carrying additional speed in…Oct 30, 1987 · N38334 · Substantial damageNTSB MIA88LA022Accident · No injuriesLimited investigationFinal reportMooney M20F · Vero Beach, FLPlt stated that while turning final approach he believes he placed the landing gear handle in the down position and observed red gear intransit lights. He was occupied by a strong wind for the landing and never checked for a gear down and safe indication. The…Oct 29, 1987 · N413HM · Substantial damageNTSB FTW88LA017Accident · No injuriesLimited investigationFinal reportCessna 172 · Midland, TXThe pilot landed long and could not stop before running off the end of the runway. The aircraft, collided with a fence and the left wing was damaged when the acft collided with a ditch.Oct 27, 1987 · N3931L · Substantial damageNTSB ANC88LA014Accident · No injuriesLimited investigationFinal reportPiper PA32 · Larsen Bay, AKThe pilot stated the wind on the surface was light and variable and while he was on final approach the airplane developed a high sink rate from which he was late effecting recovery. The airplane struck the ground short of the runway threshold.Oct 27, 1987 · N2585M · Substantial damageNTSB FTW88LA018Accident · No injuriesLimited investigationFinal reportPiper PA-60 · Ardmore, OKDuring landing, the aircraft touched down about 15 feet short of the runway causing the rt main gear to collapse. The acft slid approx 800 ft BEF0RE coming to rest on the rwy. Both gear penetrated the upper skin on the wings.Oct 26, 1987 · N742WP · Substantial damageNTSB ANC88IA013Incident · No injuriesIncident investigationFinal reportCessna 402B · Cordova, AKThe company maintenance personnel were aware of a shimmy problem but they thought is was only worn bushings. The maintenance people stated they inspected the part but found no problem. The pilot-in-command also stated he found no problem upon visually…Oct 26, 1987 · N5718M · Minor damageNTSB ANC88FA012Accident · No injuriesField investigationFinal reportCessna 185 · Anchorage, AKThe relatively inexperienced seaplane pilot-in-command made one go around when he experienced difficulty in identifying the surface of the glassy water. On the second landing attempt he flew the airplane into the water at a negative angle of attack. The…Oct 26, 1987 · N9946X · Substantial damageNTSB NYC88LA018Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Laconia, NHThe plt rprtd he was demonstrating a full touchdown autorotation in winds that were from 290 deg at 15 gusting 20 KTS. He stated the touchdown was soft with a lot of pitch pulled in; however, as he lowered the collective after touchdown, the retreating blade…Oct 25, 1987 · N51699 · Substantial damageNTSB MIA88LA039Accident · No injuriesLimited investigationFinal reportPitts S-1C · Clearwater, FLThe plt stated that on landing roll, as he added power to go around, he lost control of the aircraft, ran off the runway, flipped over and came to rest inverted. The torque of the relatively powerful engine added to the control problems in this short fuselage…Oct 25, 1987 · N14SH · Substantial damageNTSB FTW88LA016Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Brownsville, TXWhile executing a single engine ILS approach to a touch and go landing, the CFI pulled the mixture control on the right engine. Upon landing the pilot applied full power to both engines but the right engine did not respond. About 2 ft above the rwy the…Oct 25, 1987 · N7969Y · Substantial damageNTSB CHI88LA016Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Union, ILThe glider was approaching to land when, according to the pilot, he noticed the aircraft was descending 'too fast' and his airspeed was 'too slow'. The pilot then realized he wasn't going to make the runway and decided to land the glider in a nearby field.…Oct 25, 1987 · N1219S · Substantial damageNTSB ANC88LA016Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Alexander Lake, AKThe relatively inexperienced private pilot attempted to land his float equipped airplane with a tailwind and gusty winds in choppy water conditions. He lost control of the airplane and it was substantially damaged.Oct 25, 1987 · N9398K · Substantial damageNTSB LAX88LA024Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Palo Alto, CADuring a local flt while practicing touch and go landings, the plt lost control of the acft during the landing rollout. The acft groundlooped to the left, exited the rwy and nosed down.Oct 24, 1987 · N3181Z · Substantial damageNTSB LAX88LA022Accident · No injuriesLimited investigationFinal reportCessna 402B · Avalon, CAOn landing the pilot reported he heard a loud bang and the aircraft veered to the right. The pilot corrected to the leftby applying left brake. The aircraft returned to the center of the runway; however, it began to skid. The pilot realized that he was…Oct 24, 1987 · N3798C · Substantial damageNTSB FTW88LA012Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Mckinney, TXDuring flare/touchdown with full flaps the aircraft bounced. The student pilot in an attempt to go-around failed to retract the flaps. The aircraft stalled contacting some trees and subsequently the ground, damaging the left wing, right wing, and the…Oct 24, 1987 · N6530G · Substantial damage