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 LAX87LA211Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Tucson, AZA Great Lakes 2T-1A-2 nosed over during landing. The pilot indicated that he had contacted the airport on the UNICOM frequency and was informed that the winds were favoring runway 30. On short final approach to runway 30 the pilot glanced a wind sock located…May 17, 1987 · N5762G · Substantial damageNTSB NYC87LA159Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Toms River, NJThe flight was involved in short field landing practice. On the third landing, the pilot allowed the aircraft to stall above the runway surface and then touch down hard, damaging the outboard sections of the wings.May 16, 1987 · N9443W · Substantial damageNTSB NYC87LA149Accident · No injuriesLimited investigationFinal reportCessna 172 · Atlantic City, NJAccording to a witness, the acft was hi & fast on final apch to lnd & touched down nosewheel 1st in a x-wind. Drg the lndg, the acft bounced, then drifted to the left & touched down on wet grass beside the rwy. Subsequently, the left main wheel strut hit a…May 16, 1987 · N734EM · Substantial damageNTSB NYC87LA148Accident · No injuriesLimited investigationFinal reportCessna 182 · Honeoye Falls, NYThe acft was landed on a 1695 ft turf runway with dew covered grass that was aprx 3 inches tall. After touchdown, the plt applied brakes, but the acft skidded about 1000 ft, went off the dep end of the rwy & collided with a trailer. The trailer was moved…May 16, 1987 · N6298A · Substantial damageNTSB MIA87LA159Accident · No injuriesLimited investigationFinal reportCessna 120 · Oklawaha, FLThe plt stated that a t-strm had recently passed over his home airstrip made of clay & grass & had left a puddle of standing water about 4 inches deep on a portion of the rwy. During the landing roll, just prior to the tailwheel contacting the rwy, the main…May 16, 1987 · N2106V · Substantial damageNTSB LAX87LA206Accident · Serious injuriesLimited investigationFinal reportCessna T182 · Carefree, AZAt the end of a cross-country flt, the plt was approaching the arpt for landing on rwy 6 and noticed light turbulence. On the first attempt to land the plt went around. On the second attempt the plt landed the acft. Aprx 100 ft down the rwy the acft became…May 16, 1987 · N9545H · Substantial damageNTSB ATL87LA141Accident · No injuriesLimited investigationFinal reportCessna 150 · China Grove, NCDuring a supervised solo crosscountry flight, the student pilot reported that he got lost and was unable to visually locate his check point. After attempting to contact approach control for radar fixes, the pilot elected to make a precautionary landing in a…May 16, 1987 · N704EA · Substantial damageNTSB ATL87LA139Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Raleigh, NCThe pilot failed to maintain a proper descent rate on the approach for landing. He said the right engine failed to respond when he added power to arrest the rate of descent and thereafter, he applied full power to either go-around or land further down the…May 16, 1987 · N7937Y · Substantial damageNTSB ANC87FA070Accident · No injuriesField investigationFinal reportCessna 150 · Birchwood, AKThe pilot-in-command failed to maintain directional control of the airplane during landing. It nosed over during a ground loop.May 16, 1987 · N66286 · Substantial damageNTSB CHI87LA128Accident · No injuriesLimited investigationFinal reportCessna 152 · Minneapolis, MNThe plt stated that while practicing touch-and-go landings, he extended full flaps on final apch and maintained rwy alignment. According to the plt, the acft touched down hard and began to porpoise. A police officer witnessed the acft bounce three times after…May 15, 1987 · N92140 · Substantial damageNTSB SEA87LA094Accident · No injuriesLimited investigationFinal reportCessna 182B · Orvado, NVDuring landing roll the aircraft's left main gear struck a hole on the gravel runway. The aircraft when veered to the left of the runway onto soft terrain. The nose gear broke off with the aircraft nosing over inverted.May 14, 1987 · N4848D · Substantial damageNTSB NYC87LA147Accident · No injuriesLimited investigationFinal reportCessna 152 · Edgartown, MAThe plt rprtd that after he entered the pattern to land on rwy 24, the winds rapidly shifted from a slight x-wind to more of a tail wind. Subsequently, the acft touched down long, went off the left side of the rwy, hit some bushes & nosed over. Rwy 24 was…May 14, 1987 · N24806 · Substantial damageNTSB ANC87LA069Accident · No injuriesLimited investigationFinal reportFairchild C-119L · Shageluk, AKThe airplane was destabilized by a slight vertical air movement on approach. The pilot touched the airplane down short of the runway proper, collapsing the landing gear before sliding off the strip into adjacent tundra.May 14, 1987 · N8504X · Substantial damageNTSB CHI87LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Waukesha, WIAccording to the plt, he entered downwind for rwy 18 and the apch 'seemed normal.' The plt stated that he 'slipped into wind' on final apch and extended ten degrees of flaps, but when he straightened out, the acft 'veered' to the left suddenly. According to…May 13, 1987 · N5286P · Substantial damageNTSB DEN87LA123Accident · No injuriesLimited investigationFinal reportCessna 150 · Akron, COThe student plt had just purchased N8649G and had decided to fly it. He had not been endorsed for solo flt. After a successful takeoff and a short cross-country flt, he returned to the Akron aprt for landing. During the attempted landing, control of the acft…May 12, 1987 · N8649G · Substantial damageNTSB FTW87LA124Accident · No injuriesLimited investigationFinal reportCessna T210N · Tahlequah, OKThe right brake disk separated from the hub when brakes were applied during landing rollout. The aircraft veered left off the runway and into a drainage ditch where the horizontal stabilizer contacted the ground, damaging both of its spars.May 11, 1987 · N5342A · Substantial damageNTSB ANC87LA068Accident · No injuriesLimited investigationFinal reportCessna 305 · Port Heiden, AKThe pilot attempted a landing on the beach. After the landing roll the aircraft struck a sand bar causing the aircraft to nose over on its back.May 11, 1987 · N5233G · Substantial damageNTSB SEA87LA095Accident · No injuriesLimited investigationFinal reportPiper PA-20-115 · Seattle, WADuring landing roll with a crosswind from the right a ground loop occurred. The pilot had just completed a solo cross country flight. The wind was from 210 degrees at 9 knots. The pilot was landing on runway 13L.May 10, 1987 · N7732K · Substantial damageNTSB FTW87LA117Accident · No injuriesLimited investigationFinal reportCessna 152 · Okmulgee, OKDuring a normal uneventful approach, and upon touchdown, the aircraft's nose gear collapsed for undetermined reasons. The aircraft slid to a stop causing substantial damage.May 10, 1987 · N4922P · Substantial damageNTSB SEA87LA161Accident · No injuriesLimited investigationFinal reportGrumman AA1B · Ocean Shores, WAThe plt landed his acft onto a golf course which had been the previous site for the airport. The airport had been closed since December 1985 and relocated close by. The pavement at the old airport had been replaced by sod. During landing roll, the aircraft…May 9, 1987 · N6296L · Substantial damageNTSB SEA87IA093Incident · No injuriesIncident investigationFinal reportStinson 108-1 · Idaho Falls, IDDuring a go around the pilot decided to attempt to reland the aircraft. Gusty crosswind conditions existed at the time and directional control was lost during which the aircraft entered into a ground loop maneuver and the left main landing gear strut…May 9, 1987 · N9016K · Minor damageNTSB DEN87LA122Accident · No injuriesLimited investigationFinal reportBeausoleil Acro Sport · Englewood, COThe commercial plt was flying his experimental acro sport 1 in the local area. After about an hour of acrobatic practice, he returned for landing to his home arpt. The plt accepted rwy 28 due to heavy traffic. The winds were reported as 050 degrees at 8…May 9, 1987 · N1717 · Substantial damageNTSB CHI87LA125Accident · No injuriesLimited investigationFinal reportCessna 120 · Lebanon, INWhile landing on runway 18, pilot lost directional control and veered off left side of runway into a gully. The pilot stated prior to landing he received winds reported from 220 degrees at 11 knots through ATIS.May 9, 1987 · N2224N · DestroyedNTSB FTW87LA114Accident · No injuriesLimited investigationFinal reportAyres S2R-1820 · Ville Platte, LAAfter landing on a wet grass strip the pilot realized that the aircraft was not going to stop. Obstructions off the end of the runway prevented a go-around. The aircraft collided with two trees causing substantial damage.May 7, 1987 · N4025P · Substantial damageNTSB ATL87LA133Accident · No injuriesLimited investigationFinal reportBeech E-55 · Spartanburg, SCThe plt reported that he lowered the ldg gear and observed a down-and-locked indication on the ldg gear position light on final appch. During rollout, he felt a severe vibration in the nose gear and pulled back on the yoke in an attempt to reduce it. He then…May 6, 1987 · N713DM · Substantial damageNTSB NYC87LA141Accident · No injuriesLimited investigationFinal reportCessna 172K · Palmyra, PAStudent pilot experienced up and downdrafts while on approach for landing at reigle airport. The pilot was unable to maintain directional control during roll out, ran off the left side of the runway, and across a grass field. The acft then nosed over when the…May 5, 1987 · N78506 · Substantial damageNTSB FTW87FA111Accident · No injuriesField investigationFinal reportBell 206B · Ft. Worth, TXWhile demonstrating a low level 180 degree autorotation to a rated pilot, the CFI undershot his intended touchdown point. In an attempt to reach his selected touchdown point, the pilot allowed the rotor RPM to decay and the aircraft developed a high sink…May 4, 1987 · N5754A · Substantial damageNTSB NYC87LA140Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-20 · Allaire, NJDuring landing roll, the pilot lost directional control. The aircraft veered off the runway to the left, collided with a tree and was substantially damaged.May 3, 1987 · N3618Z · Substantial damageNTSB MIA87LA156Accident · No injuriesLimited investigationFinal reportDouglas DC-6A · Ft.Lauderdale, FLThe plt stated that they had made a normal landing and on rollout experienced severe vibration from a nose wheel shimmy. The vibration resulted in substantial damage to the horizontal stabilizer spar attach points.May 3, 1987 · N43867 · Substantial damageNTSB LAX87LA201Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Chandler, AZDuring and instructional flight on short and soft field landings, the pilot reported that during the landing roll an unobserved dust devil hit the aircraft. The aircraft was raised approximately 60 ft AGL. The instructor was unable to regain control and the…May 2, 1987 · N25111 · Substantial damageNTSB DEN87LA129Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Mandan, NDThe pilot and his son were ferrying a recently purchased Boeing stearman to their home in Ohio. During landing roll, at an en route stop, a gust of wind lifted the tail section and the acft groundlooped. The left wing struck the runway and the acft was…May 2, 1987 · N75546 · Substantial damageNTSB CHI87LA121Accident · No injuriesLimited investigationFinal reportBeech 58P · Evansville, INDuring landing roll-out the left main and nose gear collapsed. The pilot stated in his report that he does not recall touching any switches on roll-out. However, upon exiting the aircraft, the pilot reported that the landing gear relay was tripped open and…May 2, 1987 · N6401H · Substantial damageNTSB FTW87LA112Accident · No injuriesLimited investigationFinal reportBoeing E75N1 · Arcola, TXDuring landing roll the aircraft swerved to the right. The pilot applied the left brake and the aircraft nosed over inverted causing substantial damage. The pilot stated that the left brake locked. The reason for the brake seizure is undetermined.May 1, 1987 · N1346M · Substantial damageNTSB CHI87DEP05Accident · Serious injuriesFinal reportJohnson Quickie 2 · Eau Claire, WIThe pilot was attempting to land the experimental aircraft when he lost control and impacted on the rwy. This was the first time the pilot had flown this aircraft. The pilot stated the aircraft 'refused to flare properly.'Apr 30, 1987 · N3262P · Substantial damageNTSB ATL87DKG03Accident · No injuriesFinal reportCessna 310D · Athens, GAThe acft was reportedly stalled about 30 ft above the rwy and a hard ldg was made. The multi-eng rated plt was practicing short-field ldgs under the instruction of a CFI in preparation for obtaining commercial certificate. The acft wings and fuselage…Apr 30, 1987 · N6752T · Substantial damageNTSB SEA87LA087Accident · No injuriesLimited investigationFinal reportCessna 310L · Chiloquin, ORThe aircraft departed the end of the runway during landing roll. The aircraft then went down an embankment and through a fence. The right main gear collapsed with the aircraft turning 90 degrees before coming to rest. A tailwind was present during landing.…Apr 29, 1987 · N808AA · Substantial damageNTSB NYC87LA134Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Ellington, CTDuring an instructional flight, the instructor pilot simulated a forced landing at about 250 feet and 60 KIAS. The student pilot at this time entered an autorotation and the helicopter started to descend. Collective was pulled but this failed to stop the…Apr 29, 1987 · N9070F · Substantial damageNTSB DEN87LA115Accident · Minor injuriesLimited investigationFinal reportBeech A23-24 · Roosevelt, UTDuring landing, as the acft neared the taxiway leading to the parking ramp, the plt applied brakes and the acft veered to the off the rwy. The plt then applied pwr in an attempt to takeoff. The acft paralleled the rwy for a short distance and after crossing a…Apr 29, 1987 · N4745J · Substantial damageNTSB ATL87LA129Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Greenville, SCThe aircraft landed with the landing gear in the up position when the pilot inadvertently failed to extend the gear. He had disarmed the landing gear warning system by pulling the system circuit breaker because it was activating at normal power settings. He…Apr 29, 1987 · N3240Y · Substantial damageNTSB MIA87LA149Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Daytona Beach, FLPilot made a hard landing at which time the left main gear collapsed. The aircraft then ground looped and ran off the runway. Post crash examination of the left main gear revealed it collapsed when a support brace rusted through from the inside of the tube.…Apr 28, 1987 · N3167E · Substantial damageNTSB FTW87LA110Accident · No injuriesLimited investigationFinal reportLaw OSPREY-2 · Minden, LAPilot stated that he flared about ten feet too high and landed hard collapsing the main gear followed by the aircraft sliding off the runway and colliding with a ditch where substantial damage occurred.Apr 28, 1987 · N55889 · Substantial damageNTSB ATL87LA128Accident · No injuriesLimited investigationFinal reportMaule MX-7-180 · Greenville, SCThe pilot was doing touch and go's to become familiar with his new aircraft. On the fifth landing the aircraft started a groundloop and he recovered by adding full power. On the next landing the aircraft again started a groundloop to the right, he added full…Apr 28, 1987 · N5670C · Substantial damageNTSB ANC87LA063Accident · No injuriesLimited investigationFinal reportCessna 185 · Kenai, AKThe pilot stated that during the landing roll he lost directional control of the aircraft causing the aircraft to nose over on its back.Apr 28, 1987 · N2223T · Substantial damageNTSB SEA87LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Blakely Island, WAThe plt landed with excess airspeed past the first third of the downhill runway. The aircraft bounced and the pilot added a little power. The aircraft then struck the runway with the nose gear. Since the plt feared going off the end of the runway into the…Apr 27, 1987 · N5185L · Substantial damageNTSB SEA87LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · Renton, WADuring touch and goes the student plt landed hard and flat. The aircraft then bounced three times and at the end of the third bounce landed on the nose gear and propeller collapsing the nose gear.Apr 27, 1987 · N6312P · Substantial damageNTSB MKC87LA097Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Marshfield, MOThe PIC made an uneventful cross country flt and touchdown to his destination arpt. During the rollout aft lndg, the PIC rptd a gust 90 degrees fm the left forced the acft to veer left and off the rwy. Tall grass was encountered aft the acft dptd the rwy…Apr 27, 1987 · N2595B · Substantial damageNTSB FTW87LA104Accident · No injuriesLimited investigationFinal reportCessna 182 · Midland, TXDuring a touch and go landing on a sod strip the nose gear collapsed. The strut assembly part number 0594300-5 failed for an undetermined reason and the aircraft nosed over to the inverted position.Apr 27, 1987 · N34S · Substantial damageNTSB ATL87LA131Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Greenville, SCThe plt reported he forgot to put the ldg gear down. He stated that he was practiciing a short field ldg with the power set at about 15 in. Hg map. He noted that the gear warning system does not function unless the power is at 12 in. Hg map or below. The plt…Apr 27, 1987 · N5824S · Substantial damageNTSB ATL87LA127Accident · No injuriesLimited investigationFinal reportCessna 172N · Union Grove, NCThe plt reported that he was attempting to make a soft-field ldg in a plowed field at a friend's farm. He had not landed there previously. After initial touchdown was made on the main ldg gear, the nosewheel dug into a rise in the terrain and the airplane…Apr 27, 1987 · N4678G · Substantial damageNTSB MIA87LA148Accident · No injuriesLimited investigationFinal reportCessna 172 · St.Petersburg, FLWhile landing, the acft floated down the rwy as the result of excessive airspeed during the apch. The plt continued to flare the acft, & as the airspeed bled off, the wings stalled, resulting in a hard landing. The acft then began to propoise, & on the third…Apr 26, 1987 · N217JA · Substantial damage