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 LAX87LA114Accident · No injuriesLimited investigationFinal reportCessna 152 · El Monte, CADuring a local instructional flight, the pilot reported that while on the base leg to runway 19 the aircraft was a bit high but was corrected while on final approach. Upon landing the aircraft touched-down in a three point attitude and ballooned up. On the…Feb 10, 1987 · N25884 · Substantial damageNTSB SEA87LA055Accident · No injuriesLimited investigationFinal reportCessna 150E · Joseph, ORPlt was on first flight of season. After two hours flying, landing was attempted on dry hard-surface runway in slight tailwind. During roll-out, left drift developed. Use of right brake caused tail of acft to lift. Plt applied both brakes and acft nosed over…Feb 8, 1987 · N3079J · Substantial damageNTSB SEA87LA054Accident · No injuriesLimited investigationFinal reportRobinson R22 · Brinnon, WAWhen psgr became nauseous in flt, plt attempted downwind lndg onto pinnacle in rough terrain. Acft contacted slope short of intended point of lndg, main rotor flexed downward, severing tail boom.Feb 8, 1987 · N9076Y · Substantial damageNTSB FTW87LA063Accident · No injuriesLimited investigationFinal reportCessna 172N · Bay City, TXAccording to the pilot, during flare/touchdown the aircraft was substantially damaged when he lost control of the aircraft due to a cross wind.Feb 8, 1987 · N6129D · Substantial damageNTSB NYC87LA083Accident · No injuriesLimited investigationFinal reportCessna 172 · Caldwell, NJThe student plt was on his 1st supervised solo flt. He stated that drg a touch-&-go lndg, he cleaned up the acft & applied power, but as the speed increased, the nosewheel began to shimmy & the acft veered to the left. The student said he shut-off the power &…Feb 7, 1987 · N4792D · Substantial damageNTSB NYC87LA080Accident · No injuriesLimited investigationFinal reportCessna 172 · Livingston, NYDuring landing roll, the aircraft encountered patchy ice on the runway surface causing the aircraft to skid out of control and impact a snowbank.Feb 7, 1987 · N62429 · Substantial damageNTSB NYC87LA079Accident · No injuriesLimited investigationFinal reportGrumman American AA-5A · Beverly, MAStudent pilot became lost and disoriented during enroute flight to the manchester area and landed at Beverly airport instead. During landing roll, the aircraft drifted to the left of the runway and collided with a snowbank, breaking off the nose gear and…Feb 7, 1987 · N472EH · Substantial damageNTSB MIA87LA082Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Venice, FLFull flap x-wind take off & landings were being conducted on rwy 13 with the winds at 210 to 220 degs at 10 KTS, or a right x-wind component of 80 to 90 degs. The student plt permitted the acft to get too slow while about 10 ft above the ground. A high sink…Feb 7, 1987 · N6237M · Substantial damageNTSB FTW87LA056Accident · No injuriesLimited investigationFinal reportCessna T210L · Borger, TXAccording to the pilot, during flare/touchdown the aircraft was substantially damaged when the right brake jammed causing the aircraft to veer off the rt side of the runway and into a gulley. However witnesses stated that the aircraft came in fast and landed…Feb 7, 1987 · N6969R · Substantial damageNTSB DEN87LA051Accident · No injuriesLimited investigationFinal reportCessna 172 M · Air Force Acade, COWhile making a landing, the acft landed hard and began to porpoise. After the third bounce, the nose gear collapsed.Feb 7, 1987 · N9582V · Substantial damageNTSB CHI87LA079Accident · No injuriesLimited investigationFinal reportCessna 150K · Clear Lake, MNThe plt stated that near the touchdown point a gust 'jarred' the acft and the throttle in the forward position. According to the plt, the acft 'took a steep left' and he leveled the wings, however there was not time to avoid trees which were about 100-150…Feb 7, 1987 · N5884G · Substantial damageNTSB BFO87LA019Accident · No injuriesLimited investigationFinal reportCessna 152II · Clinton, MDThe plt stated he made a normal approach and touchdown. On roll-out, after the flaps were retracted, a pulling was noted to the left. The acft swerved off the left side of the rwy, collided with a snowbank, and flipped over. A witness located in the run-up…Feb 7, 1987 · N94197 · Substantial damageNTSB NYC87LA082Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Marlboro, MAThe pilot allowed the aircraft to stall and touch down hard causing substantial damage. The pilot was unfamiliar with the short field at this airport.Feb 6, 1987 · N1486X · Substantial damageNTSB ATL87LA070Accident · No injuriesLimited investigationFinal reportSwearingen SA-226TC · Florence, SCDuring the final leg of a domestic scheduled commuter airline flight the aircraft landed with the landing gear in the retracted position. The captain could not recall placing the gear selector handle in the down position and the co-pilot could not remember…Feb 6, 1987 · N1013G · Substantial damageNTSB NYC87LA077Accident · No injuriesLimited investigationFinal reportStinson 108 · Wildwood, NJThe plt rprtd that prior to takeoff, he taxied thru svrl puddles of water from melting snow. The temp at that time was rprtd as 25 deg. He rprtd that when he landed at Wildwood, the wind was from 290 deg at 15 gusting 20 KTS & the temp was 30 deg. He said…Feb 5, 1987 · N97202 · Substantial damageNTSB CHI87LA074Accident · No injuriesLimited investigationFinal reportCessna 172P · Huntington, INWhile executing a touch & go landing, the plt reports that during the takeoff phase she was slightly left and tried to correct to the right when the left wheel caught in snow and the acft pulled off the rwy to the left. The acft flipped over and came to rest…Feb 4, 1987 · N62503 · Substantial damageNTSB ANC87FA031Accident · No injuriesField investigationFinal reportChampion 7EC · Anchorage, AKThe pilot-in-command accomplished unauthorized repairs to his airplane after an incident four days earlier. He repaired the right main landing gear by using a common door hinge to attach it to the fuselage. Upon landing, the door hinge failed and control of…Feb 4, 1987 · N7539B · Substantial damageNTSB FTW87LA062Accident · No injuriesLimited investigationFinal reportCessna 210 · Bonham, TXAccording to the pilot, the aircraft made a normal landing, but was substantially damaged when the aircraft contacted a ditch cut across the airstrip, causing the aircraft to nose over inverted.Feb 3, 1987 · N61BC · Substantial damageNTSB FTW87LA053Accident · No injuriesLimited investigationFinal reportBellanca Scout · Boyd, TXA private pilot landed on his private strip made of soft sandy soil, the aircraft ground looped breaking the left main gear 'u' bolt and center bolt. The aircraft's left wing contacted the ground causing substantial damage when the aircraft rolled over on its…Feb 3, 1987 · N7670S · Substantial damageNTSB MKC87LA045Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Flippin, ARThe pilot stated that immediately upon touchdown, the nose slowly descended to the runway. The airplane slid for 450 feet before it stopped. A support bracket and an angle was found broken. It has not been determined if the parts were broken before or after…Feb 2, 1987 · N22470 · Substantial damageNTSB BFO87LA018Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200R · West Point, VAAfter making a low pass over the uncontrolled airport the CFI decided to let the student pilot make a touch and go landing on runway 27 at West Point municipal airport. West Point, Virginia. The maneuver was successfully completed and the aircraft came around…Feb 2, 1987 · N33399 · Substantial damageNTSB NYC87LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Shelburne, VTPilot misjudged height of snowbank at the approach end of the runway and allowed the aircraft to descend too low. The main gear collided with the snowbank causing substantial damage.Feb 1, 1987 · N8820W · Substantial damageNTSB NYC87LA071Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Rockaway, NJStudent pilot experienced a rough running engine during cruise flight and decided to make a precautionary landing on a frozen reservior. During landing roll out, the aircraft hit a slushy spot on the ice and nosed over causing substantial damage.Feb 1, 1987 · N7653S · Substantial damageNTSB LAX87LA107Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Riverside, CAA Luscombe 8A ground looped on landing roll. The pilot indicated that during the landing roll after his third landing he heard a 'pop' sound. The aircraft veered right, collapsing the left main landing gear and damaging the left wing. After the accident the…Feb 1, 1987 · N1130B · Substantial damageNTSB FTW87LA065Accident · No injuriesLimited investigationFinal reportBurkhart Grob 103A · Midlothian, TXThe acft was substantially damaged when the left wing struck a 4 inch diameter post on landing. The plt stated that he decided that due to a crosswind, he would land diagonally across the north/south rwy that was mowed in the middle of a large open field…Feb 1, 1987 · N228BG · Substantial damageNTSB BFO87LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Woodbridge, VAThe student was attempting the last of 3 full stop landings. The landing was made at minimum airspeed. The acft touched down left of the rwy centerline where afterwards the l main gear hit a snowbank alongside the rwy. A loss of directional control occurred…Feb 1, 1987 · N6558L · Substantial damageNTSB ATL87LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Fuquay Varina, NCThe student plt reported that the lt main wheel rolled off the rwy into mud during ldg rollout. This pulled the acft off the rwy and down an embankment into a ditch. The nose gear subsequently sank into the mud and the acft nosed down. The acft came to rest…Feb 1, 1987 · N64823 · Substantial damageNTSB ANC87LA029Accident · No injuriesLimited investigationFinal reportCessna 172 · Beluga, AKThe pilot stated that during the landing roll on a snow covered road the pilot lost control of the aircraft causing the aircraft to nose over on its back.Feb 1, 1987 · N79416 · Substantial damageNTSB MIA87IA081Incident · No injuriesIncident investigationFinal reportEnstrom F28C · Boca Raton, FLThe helicopter spun uncontrollably on the ground after the right anti-torque pedal cable was severed while landing. Examination of the helicopter revealed that the teter stop failed to limit the travel of the tail rotor spindle assy thereby reducing the…Jan 31, 1987 · N8627H · Minor damageNTSB ANC87FA030Accident · No injuriesField investigationFinal reportCessna C-180-H · Delta Junction, AKThe pilot attempted a glacier landing in daylight conditions and was unable to maintain surface reference. He flew onto the ice and lost control in varying surface winds.Jan 31, 1987 · N7990V · Substantial damageNTSB NYC87LA066Accident · No injuriesLimited investigationFinal reportCessna 152 · Taunton, MAA student pilot allowed the aircraft to drift to the left side of the runway during landing roll. The left main gear caught a snowbank, causing the airplane to pivot counterclockwise into the snow and was substantially damaged.Jan 29, 1987 · N49769 · Substantial damageNTSB BFO87LA017Accident · No injuriesLimited investigationFinal reportCessna T210N · West Point, VAThe plt stated that the left main gear collided with a snowbank when the acft touched down on the rwy about 100 ft from the apch end and 10 ft left of the rwy centerline. Afterwards the left main gear folded into the wheel well.Jan 29, 1987 · N244MB · Substantial damageNTSB LAX87LA100Accident · No injuriesLimited investigationFinal reportCessna 152 · Mesa, AZDuring a local solo instructional flight, the pilot was practicing pattern work. On final approach the pilot reported that no correction for a cross wind was required. During the flare the pilot stated the aircraft drifted to the left. Upon touch down on the…Jan 28, 1987 · N95529 · Substantial damageNTSB NYC87LA068Accident · No injuriesLimited investigationFinal reportCessna 152 · Princeton, NJThe student pilot leveled off at a higher than normal altitude during landing. He attempted to slow the descent rate by adding power. The aircraft drifted to the left and the pilot contemplated aborting the landing. Before he could initiate adding power,…Jan 25, 1987 · N4837P · Substantial damageNTSB CHI87LA071Accident · No injuriesLimited investigationFinal reportCessna 152II · West Middleton, INDuring the landing roll the left main gear struck a snowbank. The nose wheel then got caught in snow and the acft tipped up on the prop and left wing.Jan 25, 1987 · N6179Q · Substantial damageNTSB CHI87LA065Accident · No injuriesLimited investigationFinal reportCessna 152 · Lansing, ILDuring second touch & go landing, plt encountered a crosswind. While attempting a go-around, after bouncing three times,the acft drifted to the left. The acft collided with a snowbank and nosed over.Jan 25, 1987 · N4805B · Substantial damageNTSB ATL87LA065Accident · No injuriesLimited investigationFinal reportCessna 150M · Delaware, OHThe student plt reported that he lost control of the acft while landing on rwy 28 in croswind conditions, after a solo x-c flt. The acft landed hard, veered off the rwy, and nosed over. According to the plt, the wind was from 360 at 10 KTS, gusting to 20 KTS.…Jan 25, 1987 · N7992U · Substantial damageNTSB NYC87LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Simsbury, CTThe aircraft was landing on runway 21 at Simsbury, Connecticut when the pilot lost directional control and the left main wheel contacted the snow bank, which in turn caused the airplane to lean over to the right striking the wing on the runway surface.Jan 23, 1987 · N48918 · Substantial damageNTSB MKC87IA043Incident · No injuriesIncident investigationFinal reportEmbraer EMB-120 · Springfield, MOThe PIC of this air midwest flt 4408 said that, while on initial climb, power (np) on the left engine decayed to 60% and would not recover. The engine was feathered by condition lever but the torque rose to 140% while returning for a landing, according to the…Jan 23, 1987 · N120AM · Minor damageNTSB CHI87LA066Accident · No injuriesLimited investigationFinal reportCessna 152 · Lincoln, ILAccording to the plt, after landing on rwy 03 at logan county airport, the acft encountered ice on the rwy and the left main gear struck snow that had drifted onto the rwy. The plt stated that the acft then collided with a snowbank and flipped over. The acft…Jan 23, 1987 · N48241 · Substantial damageNTSB ANC87FA025Accident · No injuriesField investigationFinal reportCessna 152 · Anchorage, AKThe pilot stated that on the third touch and go he raised the flaps and applied power for takeoff when the aircraft started to skid to the left. He cut power, then lost directional control of the airplane causing the aircraft to strike the snow bank.Jan 23, 1987 · N25063 · Substantial damageNTSB MKC87LA042Accident · No injuriesLimited investigationFinal reportCessna 152 · Coffeyville, KSThe student pilot flew from tulsa, ok to Coffeyville, KS to take his private pilot flight test. Student did not check weather or NOTAMS and relied on information from the flight instructor and was not aware of the NOTAM that there was a 50-foot wide strip…Jan 22, 1987 · N4924H · Substantial damageNTSB NYC87LA062Accident · No injuriesLimited investigationFinal reportCessna 152 · Orange, MAPilot was landing after a cross country solo flight. The aircraft hit a patch of ice and the pilot lost directional control causing the aircraft to collide nose first with a snow bank. The aircraft then swung the right wing around into the snow, causing…Jan 21, 1987 · N5171B · Substantial damageNTSB FTW87LA046Accident · No injuriesLimited investigationFinal reportCessna 172N · Fort Worth, TXThe nose gear strut depressed more than normal following what the student plt thought was a normal touchdown and the acft veered off the rwy. As control was lost, the nose gear tire blew and the acft subsequently struck a VASI light collapsing the nose gear.…Jan 21, 1987 · N4901G · Substantial damageNTSB BFO87LA016Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Pungo, VAThe student made 3 full stop landings alone before the instructor boarded the acft. Another full stop landing was made and during the landing roll the instr noticed that the last half of the grass rwy was wetter than the first half. The instr elected to…Jan 21, 1987 · N7720D · Substantial damageNTSB MKC87LA041Accident · Minor injuriesLimited investigationFinal reportBeech BE-77 · Arkadelphia, ARThe student pilot was landing at the home airport after her solo cross-country flight when the airplane went off the left side of the runway. It rolled across a grassy area and then went into a large water/mudhole. The nose gear collapsed when it impacted the…Jan 20, 1987 · N6636H · Substantial damageNTSB CHI87LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Evansville, INNose gear collapsed after student pilot failed to recover from a bounced landing. The student plt was on the second landing (touch and go) of a supervised solo flight. He stated that he thought that the accident could have been avoided if he had been given…Jan 20, 1987 · N93078 · Substantial damageNTSB LAX87LA092Accident · No injuriesLimited investigationFinal reportCessna 172M · Oakdale, CADuring a solo instructional flight the student pilot was practicing touch and go landings. Upon take-off on runway 28, the wind was light from 100 degrees. On the first landing the wind had changed to a right cross wind from the north. The pilot compensated…Jan 19, 1987 · N12551 · Substantial damageNTSB ANC87LA024Accident · No injuriesLimited investigationFinal reportCessna 172 · Chena Hot Sprgs, AKThe pilot stated that after touchdown on the snow covered airstrip he lost directional control of the aircraft causing the plane to groundloop.Jan 19, 1987 · N97811 · Substantial damageNTSB LAX87LA089Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Paradise, CAWhile practicing touch and goes, the pilot stated that on his last approach a considerable amount of crabbing to the right was required on final approach to runway 35. Upon touchdown the right wing lifted, the pilot turned the control wheel to the right and…Jan 18, 1987 · N40349 · Substantial damage