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 BFO87LA059Accident · Serious injuriesLimited investigationFinal reportLake LA-4-200 · Grafton, WVAccording to the plt during the water landing the acft encountered the wake of a boat that had crossed the path of the acft. As a result the acft bounced about 20 ft high. The plt applied full power to recover; however, the acft impacted the water. He started…Aug 16, 1987 · N59FC · DestroyedNTSB ANC87LA123Accident · Minor injuriesLimited investigationFinal reportChampion 7HC · Seward, AKThe pilot lost directional control on landing and veered to the right side of the runway. The aircraft then struck a small mound and nosed over on its back. The pilot stated that he landed with a 7 to 10 knot tailwind.Aug 16, 1987 · N8976R · Substantial damageNTSB NYC87LA234Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Vergennes, VTDuring a landing attempt at basin harbor airport, the pilot came in high and fast. He did not correct and failed to go around. He overran the runway and crashed into a ditch causing substantial damage to the aircraft. The plt did not file an acc report.Aug 15, 1987 · N8288A · Substantial damageNTSB LAX87LA307Accident · No injuriesLimited investigationFinal reportBeech 35-33 · Page, AZAfter arriving at the arpt, the plt entered traffic to land on rwy 15 with a gusty x-wind from the right. He reported that just before touchdown, the aircraft entered a sudden left roll. Subsequently, the left wing contacted the runway and the plane nosed…Aug 15, 1987 · N608V · Substantial damageNTSB DEN87LA222Accident · No injuriesLimited investigationFinal reportNorth American AT-6C · Colorado Spring, COThe plt reports that he accepted a tailwind for his landing and ground-looped during the roll out.Aug 15, 1987 · N7058C · Substantial damageNTSB SEA87LA164Accident · No injuriesLimited investigationFinal reportBeech A36TC · Cascade, IDThe plt elected to divert due to hvy rain at his destn. While lndg at an alternate arpt at ngt, hydroplaning occurred & braking was not effective. Drg a go-around, the acft rolled onto the overrun & lifted off, but the acft's main gear struck a rock pile on…Aug 14, 1987 · N1834M · Substantial damageNTSB LAX87LA351Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Truckee, CADuring a telephone interview, the pilot stated that he 'landed hard' on runway 19. Winds were reported to be from 270 degrees at 15 knots gusting to 20 knots. There were no mechanical problems reported prior to the accident. The pilot did not report the…Aug 14, 1987 · N20904 · Substantial damageNTSB ANC87LA122Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Canning River, AKThe pilot stated that during the landing roll the pilot lost directional control of the aircraft causing the plane to nose over on its back.Aug 14, 1987 · N9355D · Substantial damageNTSB FTW87LA195Accident · No injuriesLimited investigationFinal reportBell 206L-1 · New Iberia, LACrew performing practice touchdown autorotations during a trng flt. On 4th autorotation, acft touched down with excess grnd speed and skidded for approx 75' on the wet, soft grass. When crew applied power back to flight RPM they heard a grinding sound and…Aug 12, 1987 · N2764F · Substantial damageNTSB LAX87LA302Accident · No injuriesLimited investigationFinal reportBeech C-45H · Auburn, CAThe aircraft collided with a ditch after a loss of control during landing rollout. The pilot indicated that during the landing roll the aircraft veered left. Attempted braking action was ineffective. The aircraft had a history of brake problems. The acft had…Aug 11, 1987 · N105DK · Substantial damageNTSB DEN87LA215Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Salt Lake City, UTThe pilot stated the touchdown seemed normal but the aircraft began to porpoise, the propellers struck the runway and the aircraft came to a stop. A post accident inspection revealed the nose gear steering roller had become dislodged and prevented proper…Aug 11, 1987 · N2431Q · Substantial damageNTSB FTW87LA193Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Midland, TXThe right main landing gear collapsed during the landing roll resulting in the loss of directional control. The acft sustained substantial damage to the right wing assembly and the right main landing gear assembly. The acft was being moved to Midland airpark…Aug 10, 1987 · N7150P · Substantial damageNTSB ANC87LA120Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Chackachatna Ri, AKThe pilot stated after he touched down on the gravel bar he lost directional control of the aircraft causing the aircraft to strike a log. The airplane then went up on its nose.Aug 9, 1987 · N31522 · Substantial damageNTSB DEN87LA214Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Greeley, CON8433D was being flown by the plt/owner with an instructor aboard for the purpose of up-dating the owner's flying proficiency. Several successful landings were made, then a wheel landing was initiated. After touchdown, the acft swerved to the left, departed…Aug 8, 1987 · N8433D · Substantial damageNTSB ATL87DEI11Accident · No injuriesFinal reportCessna 172P · Stow, OHThe pilot flared too high on landing and the aircraft bounced on touchdown. The pilot did not use the proper technique to recover from the bounced landing and lost control of the aircraft. The aircraft departed from the runway and struck two taxi lights and a…Aug 8, 1987 · N62953 · Substantial damageNTSB MKC87LA158Accident · No injuriesLimited investigationFinal reportBeech 58 · Arkansas City, KSDuring ldg roll, following a personal flight, the acft had a failure of the left main gear tire. The PIC said the acft began violently shaking and wobbling followed by collapse of the left main lndg gear. The acft swerved off the runway and incurred…Aug 7, 1987 · N9467Q · Substantial damageNTSB MKC87LA157Accident · No injuriesLimited investigationFinal reportBeech B19 · Little Rock, ARThe instructor said they were on an instructional flight practicing accuracy landings when they lost airspeed, added power, and ran out of stabilator. The student said the instructor was demonstrating a short field landing when they lost airspeed and hit…Aug 7, 1987 · N1954L · Substantial damageNTSB ATL87LA227Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Hopeful, GAThe plt was lndg on a unidirectional ag strip with a tail wind & a thunderstorm (tstm) nearby. He rprtd that drg the roll-out, a gust of wind from the tstm picked up the tail of the acft & flipped the plane over on its top. He estimated the wind was from the…Aug 6, 1987 · N1023K · Substantial damageNTSB SEA87LA157Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · North Plains, ORThe plt rprtd that drg a x-wind lndg, the acft touched down on the rgt main gear, then after rolling aprx 50 to 100 ft, the left main gear touched down. As the left wheel touched down, the left axle failed, pitching the acft on its nose. The acft then skidded…Aug 5, 1987 · N222WY · Substantial damageNTSB FTW87LA189Accident · Minor injuriesLimited investigationFinal reportBeech V35B · El Reno, OKAcft bounced on touchdown and began porpoising down the runway. According to the plt, following the second bounce, the rt front seat passenger applied full throttle and the acft veered left into a fence. After striking the fence the nose gear collapsed when…Aug 5, 1987 · N9048Q · Substantial damageNTSB CHI87LA186Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Nobelsville, INThe 160 hr tt pilot, recently checked out in this make/model acft, was returning to home base on a x-country flt. He ld long and was unable to stop before hitting a fence off the departure end of the rnwy.Aug 5, 1987 · N4358T · Substantial damageNTSB SEA87LA160Accident · No injuriesLimited investigationFinal reportCessna TR182 · Eatonville, WAThe plt rprtd that drg a lndg, the apch was a little high & the acft touched down long on the turf/gravel rwy. He thought there was sufficient rwy remaining to stop & did not initiate a go-around. However, he said 'braking on dry grass & moss was not…Aug 4, 1987 · N9233R · Substantial damageNTSB SEA87LA155Accident · No injuriesLimited investigationFinal reportBellanca 14-19-3A · Mahoney Creek, IDDrg arrival, the plt inadvertently lndd at the mohoney Creek arpt with a 2050' strip, instead of the intended arpt (indian Creek) which had a 5000' rwy. The arpt elev was 4618'; the density alt was about 7800'. While landing, an overrun occurred & the landing…Aug 4, 1987 · N8883R · Substantial damageNTSB NYC87LA214Accident · No injuriesLimited investigationFinal reportBeech B19 · Augusta, METhe student plt rprtd that during a practice landing, he rounded out too high. Subsequently, the acft bounced hard & the nose gear collapsed. After coming to rest, the plt exited the acft, but a fire erupted & the acft was destroyed.Aug 4, 1987 · N23838 · DestroyedNTSB NYC87LA213Accident · No injuriesLimited investigationFinal reportCessna 172P · Plainfield, CTWhile landing in crosswind conditions, the pilot failed to compensate for the conditions and lost directional control of the aircraft. The aircraft went down an embankment, collided with a fence and then flipped inverted.Aug 4, 1987 · N99171 · Substantial damageNTSB MKC87LA156Accident · No injuriesLimited investigationFinal reportCessna 150M · Atchison, KSThe solo student pilot was practicing touch and go landings. The pilot stated he had successfully performed 2 landings. On the third landing the aircraft touched down to the left of the runway's centerline, veered right and off the runway. Investigation…Aug 4, 1987 · N714MB · Substantial damageNTSB DEN87LA209Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Taos, NMThe plt attempted to land on rwy 22 with a left quartering x-wind. Drg the landing, the acft bounced twice, then veered to the right & went off the rwy. The plt applied power & initiated a go-around. The acft became airborne, but its right wing struck the…Aug 4, 1987 · N53811 · Substantial damageNTSB DEN87LA208Accident · No injuriesLimited investigationFinal reportCessna 180 · Broomfield, COPlt was conducting test flt following maint on tailwheel due to shimmy. On final landing acft control was lost at apx 20 KTS due to tailwheel jam. Acft departed side of rwy and left main gear collapsed causing substantial damage to airframe. Tailwheel jam was…Aug 4, 1987 · N9913V · Substantial damageNTSB SEA87LA153Accident · No injuriesLimited investigationFinal reportCessna 182A · Sunnyside, WAThe plt rprtd that when he was lndg on rwy 25, the sun was just above the horizon & shining directly down the rwy. He said he misjudged the distance to the ground & lndd hard on the nose gear. Subsequently, the nose gear collapsed, the acft veered off the…Jul 31, 1987 · N6133B · Substantial damageNTSB CHI87LA181Accident · No injuriesLimited investigationFinal reportCessna 182J · Lansing, ILWhile landing on runway 27, the pilot overshot the runway and rolled into a shallow ditch.Jul 31, 1987 · N3164F · Substantial damageNTSB NYC87LA270Accident · No injuriesLimited investigationFinal reportRockwell 112A · No Kingstown, RIThe aircraft bounced on landing and directional control was lost. The airplane veered to the left side of the runway and struck a pile of rubble and continued into the bay.Jul 30, 1987 · N1223J · Substantial damageNTSB FTW87LA182Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · San Benito, TXDrg the landing roll, the acft's left wing struck a tv camera man, who was standing at the left edge of the rwy, aprx 1200' from the threshold. The acft then veered off the left side of the rwy & the right main gear collapsed. Witnesses stated the camera man…Jul 30, 1987 · N23943 · Substantial damageNTSB CHI87LA190Accident · No injuriesLimited investigationFinal reportCessna 150 · Wheeling, ILThe student plt was on her fourth supervised solo making touch-&-go lndgs. Drg a lndg, the acft ballooned, then touched down hard. The nose gear collapsed, & subsequently, the acft came to rest off the left side of the rwy.Jul 30, 1987 · N9456U · Substantial damageNTSB CHI87LA180Accident · No injuriesLimited investigationFinal reportHughes 369HS · Griffith, INThe tail boom of the helicopter was severed after rotor blade contact during a hard landing. The acc occurred during an autorotation demo for the police dept with a power recovery. Application of power was late and the helicopter landed hard and bounced. The…Jul 30, 1987 · N42405 · Substantial damageNTSB LAX87DVA10Accident · No injuriesFinal reportGrumman G-164B · Taft, CADuring a repositioning flight, the plt landed the aircraft on a dirt road. During the landing roll the left wing struck an irrigation standpipe. The aircraft turned rapidly which collapsed the main landing gear. There were no mechancial failures or…Jul 29, 1987 · N6725K · Substantial damageNTSB CHI87LA178Accident · No injuriesLimited investigationFinal reportRobinson 22 · Minnetonka, MNWhile attempting to land on a flat spot on top of a hill the tail rotor hit the ground and the tail boom broke off. One witness reports that when the helicopter touched down it bounced up about 10 feet. No mechanical malfunctions were reported.Jul 29, 1987 · N8383F · Substantial damageNTSB DEN87LA212Accident · No injuriesLimited investigationFinal reportCessna 414 · Cuba, NMThe acft was dispatched to the Cuba, NM area to pick up a critically ill patient. The state police blocked off a section of highway for the acft to land on. The plt landed on the highway, but drg the landing roll, the underside of the rgt wing struck a road…Jul 28, 1987 · N1648T · Substantial damageNTSB DEN87LA200Accident · No injuriesLimited investigationFinal reportCessna 185A · Hillsboro, NDThe pvt plt was receiving dual instruction for the purpose of a checkout in the Cessna 185. The dual student landed the acft on runway 34 with a right crosswind. During the landing roll the acft began to 'weathervane' and the rt wing began to rise. Remedial…Jul 28, 1987 · N1686Z · Substantial damageNTSB DEN87LA197Accident · No injuriesLimited investigationFinal reportCessna 172RG · Aspen, COThe plt said that because of thunderstorm activity in the local area he was distracted from concentrating on his flying. During his landing approach, he failed to extend the landing gear and landed the aircraft wheels up.Jul 28, 1987 · N4709R · Substantial damageNTSB LAX87DJA07Accident · No injuriesFinal reportEmair MA-1B · Pahala, HIAt the end of an aerial application flt, the plt reported that after approaching the arpt in a light rain, he failed to keep the acft centered on the rwy. The acft exited the rwy to the left where it collided with the terrain and nosed over. There were no…Jul 27, 1987 · N9919M · Substantial damageNTSB ANC87FA110Accident · Minor injuriesField investigationFinal reportCessna 182P · Anchorage, AKThere was hvy traffic when the plt of N1946M contacted Anchorage (anc) intl twr for lndg instrns at the lake hood strip. Anc twr ctld traffic at the nrby lake hood strip & lake hood seaplane base, as well as at the anc intl arpt. The wnd at lake hood had been…Jul 27, 1987 · N1946M · Substantial damageNTSB NYC87DNC11Accident · No injuriesFinal reportBeech C23 · Vergennes, VTThe pilot of the Beech C23 had taken off and was returning to the airport due to deteriorating weather conditions. The pilot attempted to land on runway 20, but made a go around because of gusty winds. On the second attempt to land on the same runway, the…Jul 26, 1987 · N6009S · Substantial damageNTSB LAX87LA284Accident · Serious injuriesLimited investigationFinal reportRaven S77A · Tucson, AZDuring a local sightseeing balloon flight, the plt was making a landing at an open construction site. The gondola touched down then skipped three times and came to rest on the edge of a ledge aprx 10 ft in height. The balloon tipped over the edge and collided…Jul 26, 1987 · N43995 · Substantial damageNTSB FTW87LA181Accident · No injuriesLimited investigationFinal reportCessna 150L · Rockwall, TXAs the acft touched down, the rgt main wheel contacted a rut in a soft area of the rwy & the acft veered to the rgt. To avoid hitting parked acft on the west side of the rwy, the plt added full power & left rudder & aileron. He stated that as the acft left…Jul 26, 1987 · N7930G · Substantial damageNTSB FTW87DPA04Accident · No injuriesFinal reportRoe/Pietenpol Aircamper · Arlington, TXAs the plt was landing, he applied excessively hard braking & the acft nosed over. No pre-acdnt part failure or malfunction was evident.Jul 26, 1987 · N1371A · Substantial damageNTSB DEN87LA194Accident · No injuriesLimited investigationFinal reportCessna 172D · Custer, SDThe plt and his plt-rated pax were landing on rwy 7 (4700 ft x 50 ft) at Custer county arpt (5602 ft MSL), Custer, SD. The plt estimated the winds to be from 180 deg at 15 KTS. Another plt at the arpt estimated the winds to be out of the se at 20 to 25 KTS…Jul 26, 1987 · N2346U · Substantial damageNTSB ANC87LA109Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Levelock, AKAs the pilot of the Piper PA-18 airplane was completing his landing roll at the unattended airport, three children, riding an all terrain vehicle (atv), pulled onto the runway and were struck by the right side of the acft. The pilot attempted to avoid the…Jul 26, 1987 · N6978B · Substantial damageNTSB ANC87FA107Accident · No injuriesField investigationFinal reportMaule M-6 · Anchorage, AKThe pilot lost directional control while landing with a quartering tailwind from the left. The aircraft ground looped and struck a chain link fence. The pilot stated that he found the brake shaft broken at the shaft reduction retaining clip point. He…Jul 26, 1987 · N49846 · Substantial damageNTSB LAX87LA282Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Rancho Calif, CAWhile landing on runway 12, the plt lost control of the Champion 7ECA and it collided with three other aircraft. About 31 mi northwest at riverside, CA, the 1755 PDT wind was from 290 deg at 9 KTS. A witness at the airport estimated the wind was from 270 deg…Jul 25, 1987 · N5144X · DestroyedNTSB LAX87LA279Accident · No injuriesLimited investigationFinal reportCessna 320B · Bermuda Dunes, CADrg a landing, the left main gear hit a raised lip at the apch end of the rwy & failed. The plt held the left wing off the rwy by using aileron until the acft slowed, then the acft drifted off the left side. The rwy lip had been created by construction on the…Jul 25, 1987 · N44RM · Substantial damage