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 FTW87LA145Accident · No injuriesLimited investigationFinal reportCessna 172 · Yukon, OKOn touchdown the aircraft started to drift to the left. The pilot applied right rudder and lost directional control of the aircraft. The aircraft's right wing contacted the runway and the aircraft nosed over.Jun 14, 1987 · N13618 · Substantial damageNTSB DEN87LA151Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Los Lunas, NMThe plt reported that after touchdown, the acft swerved to the right and went into a water filled irrigation ditch. The acft nosed over and came to rest inverted. A post accident inspection revealed a deflated tail wheel which appeared to have blown out. It…Jun 14, 1987 · N8924D · Substantial damageNTSB DEN87LA149Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Driscoll, NDThe plt rprtd he lost directional control as he was lndg on a paved section of old highway to load chemicals. The acft swerved & went into a ditch. The left main gear collapsed & the acft came to rest back on the roadway, where it was destroyed by a…Jun 14, 1987 · N57773 · DestroyedNTSB SEA87LA115Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Ketchikan, AKThe plt made a hard landing while attempting to land on smooth, glassy water. The landing gear float rigging broke on impact which allowed the acft to enter the water. The acft filled with water and sank.Jun 13, 1987 · N43944 · DestroyedNTSB FTW87LA141Accident · No injuriesLimited investigationFinal reportCessna 152 · Arlington, TXThe dual student pilot, while on his second flight, suddenly applied full right rudder during flare/touchdown and froze on the controls while in this position. The aircraft veered off the right side of the runway into deep and soft mud before the CFI could…Jun 12, 1987 · N24258 · Substantial damageNTSB CHI87LA144Accident · No injuriesLimited investigationFinal reportCessna 182M · Lake Village, INThe aircraft bounced twice while landing on runway 36 and nosed over after the third bounce. Pilot reports being high on final with 20 degrees flaps so she applied full flaps and steepened glide angle. She also reports a northwest crosswind at 15 to 20 knots,…Jun 12, 1987 · N91927 · Substantial damageNTSB NYC87LA171Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Middlesex, NYThe pilot stated that a normal t/d was made at 75 mph abt 1/3RD of the way down the rwy. During rollout, the acft went through a dip and became airborne again. After touching down again, brakes were applied but the aircraft did not stop on the wet, freshly…Jun 10, 1987 · N5060P · Substantial damageNTSB MIA87LA178Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Kissimmee, FLThe plt failed to lower the landing gear prior to touchdown. Insp of the acft revealed that the landing gear warning horn & gear down & locked light were inoperative.Jun 10, 1987 · N6529P · Substantial damageNTSB MIA87LA175Accident · No injuriesLimited investigationFinal reportGreco Bruno Dolphin 1 · Miami, FLThe pilot stated that the acft stalled during the flare to touchdown, landed hard, & collapsed the rt main landing gear.Jun 10, 1987 · N51PJ · Substantial damageNTSB FTW87LA138Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Norman, OKWhile performing a touch and go landing, the aircraft landed hard causing a vibration in the engine area, and some loss of rudder control. The pilot flew by the tower and the tower indicated everything looked ok. On landing roll the nose gear failed causing…Jun 9, 1987 · N5552W · Substantial damageNTSB ATL87IA163Incident · No injuriesIncident investigationFinal reportPiper PA-34-200 · Birmingham, ALThe pilot reported that during a landing, he forgot to extend the landing gear. He was wearing a 'dave clark' headset with earplugs & did not hear the landing gear warning horn. During a subsequent check of the landing gear, it operated normally.Jun 9, 1987 · N56657 · Minor damageNTSB ANC87DAG02Accident · No injuriesFinal reportde Havilland Beaver U-6A · Sparrevohn, AKThe pilot stated that just prior to touchdown he encountered a wind shear. The acft stalled and crashed on the gravel bar.Jun 9, 1987 · N123PG · Substantial damageNTSB ATL87LA165Accident · No injuriesLimited investigationFinal reportCessna 172G · Steubenville, OHPIC rpted he flew over airport and noted wind direction as 290-300 degrees on wind indicator. He entered downwind for rwy 31 at uncontrolled field. Normal approach flown with full flaps on final with left crosswind correction. About 30-40 feet above rwy, acft…Jun 8, 1987 · N3644L · Substantial damageNTSB MKC87LA123Accident · No injuriesLimited investigationFinal reportBeech C35 · Spencer, IADuring ldg, PIC failed to maintain directional control and swerved off the rwy. Ldg gear collapsed and acft was substantially damaged. Witnesses said plt and pax were behaving irrationally prior to lvf departure apt. PIC left the scene of accident and two…Jun 7, 1987 · N1931D · Substantial damageNTSB LAX87LA232Accident · No injuriesLimited investigationFinal reportBellanca 14-13-2 · Rancho Calif, CAThe plt elected to make a precautionary landing due to deteriorating wx along his route of flt. He stated that there was a x-wind from the left when he landed on rwy 30. Drg the landing, the acft drifted off the rwy & one of the main landing gear mired in…Jun 7, 1987 · N86789 · Substantial damageNTSB LAX87LA228Accident · No injuriesLimited investigationFinal reportCessna 120 · Fresno, CAA Cessna 120 landed left of the runway on a rough dirt area and nosed over. The pilot indicated that the airport is not lighted. The runway is equipped with white reflectors and the taxiways are equipped with amber reflectors. The pilot stated he was unable…Jun 7, 1987 · N76546 · Substantial damageNTSB DEN87LA154Accident · No injuriesLimited investigationFinal reportMooney M20E · Harwood, NDThe plt was landing his Mooney M20E on a private grass airstrip. He said he lowered the manual landing gear and thought he felt the thumblock snap into place. Upon touchdown the landing gear folded up and the acft slid to a stop, resulting in substantial…Jun 7, 1987 · N6933U · Substantial damageNTSB CHI87LA141Accident · Minor injuriesLimited investigationFinal reportLuscombe 8E · Dodgeville, WIWhile landing on runway 30, the pilot reported that the wind shifted from a crosswind to a tailwind. During an attempted go-around the pilot lost directional control and struck a metal utility shed prior to impacting the ground.Jun 7, 1987 · N1402B · Substantial damageNTSB CHI87FA140Accident · 4 fatalField investigationFinal reportGrumman American AA-5 · Middleton, WIThe pilot had communicated with other pilots concerning the difficulties he was having with the winds. He had already attempted approaches to two other runways but had failed to complete a landing. He asked the pilot of a recent arrival for the wind…Jun 7, 1987 · N1358R · DestroyedNTSB BFO87DIG05Accident · No injuriesFinal reportCessna 152 · Baltimore, MDThe student pilot, who had approximately 47 hours in the aircraft and approximately 8 hours as pilot-in-command, stated that after touchdown on runway 33R the aircraft veered to the right and departed the runway and collided with a ditch. The wind was…Jun 7, 1987 · N48935 · Substantial damageNTSB ANC87LA076Accident · No injuriesLimited investigationFinal reportMaule M-6 · Kenai, AKThe pilot effected a go-around during an approach to runway 01 in gusty surface wind conditions. During the second approach he landed and lost control at or near the demonstrated crosswind component limit for this airplane. The airplane ground looped and…Jun 7, 1987 · N5645D · Substantial damageNTSB SEA87LA113Accident · No injuriesLimited investigationFinal reportCessna 172P · Snohomish, WAThe pilot initiated a landing on a 2650 ft long runway in a 11-18 knot quartering tailwind condition. He flew the final approach too fast and flared prematurely. The acft floated down the rwy, landed hard and bounced twice. The plt lost control and the acft…Jun 6, 1987 · N65994 · Substantial damageNTSB NYC87IA167Incident · No injuriesIncident investigationFinal reportNihon YS-11 · Hyannis, MAThe YS-11 was landing with a right crosswind. The pilot said he touched down on the right main landing gear first and upon touchdown, the right main landing gear collapsed. The aircraft stayed on the runway and received minor damage. The cockpit crew of 2, 2…Jun 6, 1987 · N187P · Minor damageNTSB MIA87LA172Accident · No injuriesLimited investigationFinal reportBushby Mustang II · Cocoa, FLDuring the landing roll the plt lost control of the acft. It then departed the rwy, collided with a taxiway marker sign & came to rest.Jun 6, 1987 · N84HM · Substantial damageNTSB FTW87LA140Accident · Minor injuriesLimited investigationFinal reportCessna 150G · College Station, TXThe pilot stated that upon touchdown the aircraft began to shake so violently that he could not see the panel or control the aircraft. During landing roll it veered off the left side of the runway. The nose and right main gear wheels dug into the soft ground…Jun 6, 1987 · N8612J · Substantial damageNTSB CHI87LA107Accident · No injuriesLimited investigationFinal reportCessna 172N · Marion, INThe plt stated that on final aprx he did not flare soon enough and the nosewheel 'hit the rwy hard.: he further stated that the acft 'ballooned up' and he attempted to 'flare out again without success. ' according to the plt, the acft bounced up and down an…Jun 6, 1987 · N5240E · Substantial damageNTSB NYC87LA158Accident · No injuriesLimited investigationFinal reportBeech 58TC · Oxford, CTThe flight was making an ILS approach to runway 36 in IMC. The aircraft touched down about 2,000 feet down the 5,000 foot runway and to the left of the runway centerline. The aircraft hydroplaned on standing water on the runway and skidded off the end coming…Jun 5, 1987 · N6058U · Substantial damageNTSB SEA87LA109Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Vancouver, WADuring a practice run-on landing the aircraft started to vibrate violently and an almost simultaneous fire occurred. Both pilots and an eyewitness stated that the run on landing was very smooth. Both pilots stated that something mechanical let loose during…Jun 3, 1987 · N9606F · DestroyedNTSB SEA87LA108Accident · No injuriesLimited investigationFinal reportCessna T210L · Dayton, WADuring landing the aircraft floated. The pilot elected to make a go-around but had used up more than one half the runway. Shortly after applying full power the pilot reduced power to idle for landing on a barley field at the departure end of the runway.…Jun 3, 1987 · N2222S · Substantial damageNTSB MIA87LA169Accident · No injuriesLimited investigationFinal reportCessna 421B · Miami, FLDuring the landing roll the lt main landing gear collapsed. The acft then slid to a stop. Insp of the lt landing gear revealed that the upper & lower torque links which maintains parallel alignment of the tire to the fuselage separated. This occurred as a…Jun 3, 1987 · N137JR · Substantial damageNTSB MIA87IA170Incident · No injuriesIncident investigationFinal reportPiper PA-44-180 · Jacksonville, FLDuring the landing roll the rt main landing gear collapsed. Examination of the landing gear revealed that the strut housing (trunnion) failed due to overload which was precipitated by fatigue and caused by a stress riser located on a manufacturing seam.Jun 3, 1987 · N180PA · Minor damageNTSB MIA87LA199Accident · No injuriesLimited investigationFinal reportLet L-13 · Plymouth, FLThe plt misread the altimeter by 1000 ft when the flt entered the initial point of the traffic pattern. He then began circling to dissipate alt & realized that the acft was low. He then proceeded downwind, turned base then final & landed hard buckling the…May 31, 1987 · N99946 · Substantial damageNTSB ANC87LA074Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Anchorage, AKThe pilot landed on an asphalt surfaced runway with a Cessna 185 airplane that had been modified to accept extremely large 'tundra' tires, which are intended primarily for off-airport and gravel runway landings. The pilot lost directional control during the…May 30, 1987 · N177BM · Substantial damageNTSB NYC87DGT01Accident · Minor injuriesFinal reportSchleicher ASW-20L · Mt Holley Sprgs, PAJust before touchdown, during an off-arpt landing, the plt tried to extend the flaps from a 30 deg position to full down (55 deg). He said that due to his short stature & seat position, he had difficulty positioning his left arm to do this. As he tried to…May 29, 1987 · N705X · Substantial damageNTSB CHI87LA134Accident · No injuriesLimited investigationFinal reportCessna U206C · Grand Rapids, MNThe plt rprtd that drg a water lndg, the left float dug in & caused the left wing to strike the water. Subsequently, the acft nosed over. The plt did not rprt any abnormal wind or water condition.May 29, 1987 · N3970G · Substantial damageNTSB ANC87LA073Accident · No injuriesLimited investigationFinal reportCessna 180 · Naknek, AKThe private pilot elected to land at an abandoned arpt on an unmaintained dirt taxiway adjoining the gravel rwy inorder to reduce the crosswind component. The acft hit a soft spot during the landing roll and nosed over. The U.S. Dept of commerce's Alaska…May 29, 1987 · N2940C · Substantial damageNTSB FTW87LA131Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Grand Prairie, TXDuring landing roll the right main landing gear tire failed causing a loss of directional control. The acft departed the right side of the rwy, and the right main landing gear collapsed.May 27, 1987 · N41788 · Substantial damageNTSB MIA87LA163Accident · No injuriesLimited investigationFinal reportPiper PA-28-180D · Astatula, FLThe plt became disoriented and performed a precautionary landing. During the landing roll, the pilot taxied into a ditchand the nose gear collapsed.May 26, 1987 · N6406J · Substantial damageNTSB ATL87LA150Accident · No injuriesLimited investigationFinal reportPiper PA-28-200 · Maxwell Afb, ALDuring the landing roll, the pilot lost directional control of the acft. The right main and nose gears collapsed. Inspection of the acft failed to reveal any system malfunction/failure.May 26, 1987 · N6857J · Substantial damageNTSB MKC87LA108Accident · No injuriesLimited investigationFinal reportCessna 150L · Harrison, ARThe pilot said he was landing into the wind and when he was 20 feet above the runway, the wind seemed to shift to a tail wind. The airplane stalled, hit the runway hard and bounced. The pilot said he pushed the control wheel forward and the nose wheel hit the…May 25, 1987 · N1418Q · Substantial damageNTSB SEA87LA101Accident · Minor injuriesLimited investigationFinal reportAero Commander AC-100 · Alderwood Manor, WADuring takeoff on a short 1700 foot airstrip under no wind conditions, close to gross weight, the aircraft was not able to clear trees at the departure end of the runway. The pilot recognized this and reduced power for a precautionary landing onto an adjacent…May 24, 1987 · N3768X · Substantial damageNTSB NYC87LA155Accident · No injuriesLimited investigationFinal reportNorth American SNJ-2 · Farmingdale, NYThe plt was performing touch-&-go landings. On the 3rd landing, the main gear collapsed & the acft received substantial damage. No pre-acdnt part failure or malfunction was reported.May 24, 1987 · N65370 · Substantial damageNTSB FTW87LA127Accident · No injuriesLimited investigationFinal reportCessna 140 · Waco, TXThe pilot stated that brakes were applied during the landing roll prior to the tailwheel making ground contact causing the aircraft to nose over and come to rest inverted. The aircraft was substantially damaged.May 24, 1987 · N111NZ · Substantial damageNTSB NYC87LA153Accident · No injuriesLimited investigationFinal reportCessna 182 · Ellington, CTThe pilot stated that while making a standard left traffic pattern, the wind at the north end of the airport shifted from the southeast to the northwest. The acft touched down with excessive ground speed, ran off the end of the rwy and came to rest on a…May 23, 1987 · N9192G · Substantial damageNTSB MIA87LA162Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Fernandina Bch, FLTail wheel strut was found to be over serviced causing it to be extended higher than normal. This would cause the aircraft to be harder to steer. On landing in a cross wind the pilot experienced vibration of the tail wheel followed by failure due to torsional…May 23, 1987 · N2996Q · Substantial damageNTSB FTW87DPA01Accident · Serious injuriesFinal reportNorth American SNJ-5 · Mckinney, TXThe pilot reportedly made a normal touchdown in a calm wind condition. During the landing rollout,however, he applied excessive braking. This caused the tail wheel equipped aircraft to nose over into an inverted attitude.May 23, 1987 · N777HL · Substantial damageNTSB FTW87LA122Accident · No injuriesLimited investigationFinal reportCessna 152 · Mckinney, TXThe student plt rprtd that drg a lndg, the wind shifted from a headwind to a left crosswind. Subsequently, the acft veered off the left side of the rwy & enctrd soft mud, then the nose gear collapsed & the acft nosed over.May 21, 1987 · N5215P · Substantial damageNTSB DEN87LA128Accident · No injuriesLimited investigationFinal reportCessna 172I · Taos, NMThe private plt and his CFI rated pax were practicing touch and go landings at the local arpt. During landing a wind gust pushed the acft off the runway centerline to the right. The runway shoulder was soft, a go-around attempt was unsuccessful and the acft…May 20, 1987 · N46231 · Substantial damageNTSB CHI87DET04Accident · Minor injuriesFinal reportCessna 172P · Peru, INThe pilot was attempting a cross country VFR flight and was making a second precautionary landing to avoid severe weather. On landing the pilot landed hard, collapsed the nose gear, exited the runway and nosed over in soft terrain.May 18, 1987 · N62629 · Substantial damageNTSB NYC87LA152Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Reading, PAAccording to the plt, the acft touched down (drg lndg) about 10 ft rgt of the rwy centerline. He stated that after the acft rolled about 50 yds, he heard a 'bump' & the acft veered rgt. However, the tower controller stated that the acft touched down in the…May 17, 1987 · N4387X · Substantial damage