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 LAX89LA056Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Twentynine Palm, CAThe pilot stated that while landing, during the flare, a gust of wind raised the left wing. The pilot corrected just prior to touchdown. When the airplane touched down it ground looped to the right. The airplane ran off the runway and collided with a berm and…Nov 22, 1988 · N8695V · Substantial damageNTSB LAX89LA055Accident · No injuriesLimited investigationFinal reportAir & Space 18A · Palo Alto, CAThe pilot stated that he lost directional control of the gyroplane during the landing roll, departed the rwy and nosed over. The gyroplane touched down normally on the main landing gear at an indicated airspeed of about 20 mph. As the gyroplane slowed…Nov 22, 1988 · N6113S · Substantial damageNTSB ATL89LA042Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Union City, TNPIC made two sdf approaches. On the first approach he had difficulty seeing the rwy lights. The acft was aligned left of rwy and a missed approach was made. On the second approach the PIC said he had difficulty picking up any rwy lights. He landed with the…Nov 20, 1988 · N27947 · Substantial damageNTSB SEA89LA022Accident · No injuriesLimited investigationFinal reportCessna 172 · Oregon City, ORThe pilot was landing his aircraft on a very wet 1,170 foot grass runway. The pilot was not able to stop the aircraft before it collided with a fence at the end of the runway. According to the manufacturers performance figures, under the given temperature and…Nov 19, 1988 · N6408G · Substantial damageNTSB LAX89LA051Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Chino, CAThe plt lost directional control of the acft during the landing roll and ground looped. The flight instructor reported that this was the first landing of the day and that they were staying in the traffic pattern to practice touch and go landings on rwy 26.…Nov 19, 1988 · N1441C · Substantial damageNTSB ATL89LA041Accident · No injuriesLimited investigationFinal reportCessna 150M · Toledo, OHThe airplane was found wrecked on an airport taxiway when airport personnel reported for duty in the morning. It had been stolen from the blue horizon flying club at the airport and, according to the hobbs meter, had been operated for about 0.4 hours since…Nov 18, 1988 · N63212 · DestroyedNTSB SEA89LA020Accident · No injuriesLimited investigationFinal reportGates Learjet 25B · Bend, ORThe pilot visually inspected the runway while making a low pass. He reported afterward that he saw no evidence of ice or snow on the runway. The copilot called UNICOM but was told, while the aircraft was on short final, that the winds were calm and the…Nov 17, 1988 · N143CK · Substantial damageNTSB MIA89IA035Incident · No injuriesIncident investigationFinal reportBoeing 707-355C · Sanford, FLThe non-type rated FAA flight test engineer executed a visual approach and was observed to be erratic and flying at v-ref when he chopped the power at 50 ft AGL and the aircraft landed hard. The instructor pilot then took control of the aircraft and executed…Nov 16, 1988 · N707MB · Minor damageNTSB FTW89LA019Accident · Minor injuriesLimited investigationFinal reportLuscombe 11A · Houston, TXNov 15, 1988 · N1639B · Substantial damageNTSB ANC89LA017Accident · No injuriesLimited investigationFinal reportCessna A185F · Kasitsna Bay, AKThe plt was landing on a beach to deliver mail. He rprtd that during touchdown, the acft skipped about 50 ft before settling to the ground, then it remained in contact with the ground & rolled straight ahead. During the landing roll, the acft nosed over. The…Nov 14, 1988 · N4759E · Substantial damageNTSB MKC89LA023Accident · No injuriesLimited investigationFinal reportStearman B75N1 · Benton, ARThe flt was uneventful until the landing at the saline county arpt, Benton, ark. The PIC stated he applied too much brake and applied it prematurely during the landing roll and the acft nosed over to the inverted posn. The resultant impact crushed the…Nov 13, 1988 · N2158P · Substantial damageNTSB MIA89IA032Incident · No injuriesIncident investigationFinal reportPiper PA-28R-200 · Melbourne, FLThe plt stated that while doing touch and go landings at Melbourne, he put the gear handle down but did not check to confirm that it was down. He continued the approach and landed gear up. Afterward, the pilot noticed that the gear pump circuit breaker had…Nov 13, 1988 · N32393 · Minor damageNTSB NYC89LA026Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Pittstown, NJUncontrolled contact with trees after the pilot lost directional control of the aircraft during an attempted landing.Nov 12, 1988 · N3208T · Substantial damageNTSB MIA89LA029Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Lajas, PRThe plt filled the fuel tanks, made three touch-&-go landings, then departed on a x-country flt. After aprx 1.5 hrs of flt, he elected to reverse course & land at an alternate arpt since he had inadequate fuel to reach his destn. Realizing the fuel supply was…Nov 11, 1988 · N4815F · Substantial damageNTSB MIA89IA028Incident · No injuriesIncident investigationFinal reportPiper PA-38-112 · Vero Beach, FLThe plt stated that on landing rollout, the acft veered off the left side of the runway and as it was slowing down, hit a depression in the ground and the left main gear collapsed. The acft then spun around and came to rest.Nov 11, 1988 · N2391G · Minor damageNTSB LAX89LA043Accident · No injuriesLimited investigationFinal reportCessna 150L · Sacramento, CAThe student plt was practicing touch-&-go landings on his 3rd instructional solo flt. Drg an apch to land, the acft was slightly to the right of the rwy. The student tried to correct the situation, then decided the acft was too close to the ground. He added…Nov 10, 1988 · N17293 · Substantial damageNTSB ANC89LA015Accident · No injuriesLimited investigationFinal reportCessna 152 · Nenana, AKThe instructor pilot was demonstrating a soft-field landing to his student pilot when he flared the airplane too high, and allowed the crosswind to carry the airplane off the left side of the runway where it hit a runway light and a snow berm, then nosed…Nov 8, 1988 · N48943 · Substantial damageNTSB SEA89LA017Accident · No injuriesLimited investigationFinal reportCessna 210K · Anacortes, WADuring a gusty crosswind landing, touchdown was accomplished about 500 feet past the runway threshold. The aircraft bounced at touchdown. The pilot stated that he thought he had a flat main tire. The pilot momentarily added power after touchdown to go-around…Nov 7, 1988 · N9495M · Substantial damageNTSB DEN89LA029Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Baker, MTThe commercial plt was landing after a pipeline patrol flight. There were no pax. The plt made a wheels landing on rwy 30 with wind reported from 270 at 28 KTS. During landing roll, a wind gust from the left side, estimated by the plt as 50 KTS, lifted the…Nov 7, 1988 · N4466Z · Substantial damageNTSB NYC89LA023Accident · No injuriesLimited investigationFinal reportCessna 172RG · Robbinsville, NJFailure of the pilot to adequately correct for the crosswind and maintain control of the aircraft during a crosswind landing.Nov 6, 1988 · N9307D · Substantial damageNTSB LAX89LA037Accident · No injuriesLimited investigationFinal reportCessna 150 · Madera, CAThe pilot stated that on the last landing, the airplane touched down hard. Subsequently, the nose gear collapsed & the airplane went off the left side of the runway. There were no reported mechanical failures or malfunctions with the airplane prior to the…Nov 5, 1988 · N3730J · Substantial damageNTSB DEN89LA027Accident · No injuriesLimited investigationFinal reportCessna 210 · Monte Vista, COThe private plt was flying 2 friends to his farm. His dirt strip runs east and west, but prevailing winds were 320 deg at 40, gusting to 50 KTS. A cross wind landing to the west had to be aborted and the plt elected to land to the north, on an access road.…Nov 4, 1988 · N6240B · Substantial damageNTSB ATL89LA029Accident · No injuriesLimited investigationFinal reportCessna 172N · Rogersville, TNThe plt reported that he was ferrying the airplane to obtain scheduled maintenance. Upon arrival over the arpt, he found that the only rwy was closed for maintenance. He then elected to land on a taxiway. He made a short-field ldg and applied the brakes…Nov 3, 1988 · N734ZM · Substantial damageNTSB LAX89LA031Accident · No injuriesLimited investigationFinal reportAeronca 7EC · Saint Helena, CAThe pilot reported that after completing a three point landing, the airplane began to oscillate. He was unable to maintain directional control. Subsequently, the airplane went off the runway and nosed over in soft dirt. No mechanical failure or malfunction of…Nov 2, 1988 · N4722E · Substantial damageNTSB CHI89LA021Accident · No injuriesLimited investigationFinal reportCessna 170A · Springfield, ILThe conventional landing gear equipped airplane was substantially damaged when it nosed down after ground looping during a landing attempt. VMC prevailed and a 90 degree right crosswind, blowing at 12 knots, was present. The pilot relates in his statement…Nov 2, 1988 · N5596C · Substantial damageNTSB ATL89IA026Incident · No injuriesIncident investigationFinal reportBeech 58 · Georgetown, SCThe plt reported that the nose gear collapsed after a 'normal' ldg. An FAA inspector who examined the rwy after the mishap reported that he found tire marks which indicated that the nose tire had contacted the rwy several times after the main tires touched…Nov 2, 1988 · N958MC · Minor damageNTSB MIA89LA021Accident · No injuriesLimited investigationFinal reportCessna 182J · Okeechobee, FLThe plt rprtd that while landing at night, the acft bounced twice. Subsequently, it went off the rwy & onto a grass area. During the occurrence, the nose gear collapsed.Oct 29, 1988 · N2911F · Substantial damageNTSB CHI89LA020Accident · Minor injuriesLimited investigationFinal reportCessna 172B · Columbus, OHStudent pilot's failure to maintain control of the airplane during landing flare.Oct 29, 1988 · N7418X · Substantial damageNTSB LAX89LA026Accident · No injuriesLimited investigationFinal reportBeech 23 · San Carlos, CADuring a telephone interview the pilot stated that he landed too FAR down runway 12. He said that when he considered going around, he was already committed to complete the landing. Winds at the time of the accident were reported to be from 360 degrees at 5…Oct 28, 1988 · N2340Z · Substantial damageNTSB MKC89LA016Accident · No injuriesLimited investigationFinal reportHiller UH-12C · Davenport, IAWhile demonstrating an autorotation touchdown, a tailboom strike was experienced. Damage was incurred to the tailboom, the tail rotor drive shaft, and one main rotor blade. The CFI said everthing felt normal during touchdown and believed the soft terrain…Oct 26, 1988 · N57FD · Substantial damageNTSB MKC89LA013Accident · No injuriesLimited investigationFinal reportCessna 150 · Liberty, MOWhile flaring for a x-wind landing, the student plt saw a large brown animal running toward the rwy. He maneuvered to avoid the animal. He stated the left main gear struck the animal, then the acft went off the rwy, bounced & nosed over.Oct 24, 1988 · N60977 · Substantial damageNTSB DEN89LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Billings, MTThe student plt was practicing takeoffs and landings, with reported winds gusting to 14 KTS. During a landing the plt misjudged the flare and attempted to go around. He said the wind raised the right wing and that he overcorrected with aileron and pulled back…Oct 24, 1988 · N757XV · Substantial damageNTSB SEA89LA014Accident · No injuriesLimited investigationFinal reportCessna 150G · Post Falls, IDThe plt rprtd that due to the airstrip conds, he was making a low, flat apch. He was using carb heat. When power application became necessary, just before landing, the eng did not respond immediately. The plt maintained a nose high attitude to avoid obstacles…Oct 23, 1988 · N3691J · Substantial damageNTSB LAX89LA024Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Phoenix, AZDuring the landing roll, the airplane began to veer to the right. The pilot applied hard left rudder for a few seconds, then the left main tire came off the rim. Subsequently, the left gear collapsed and the airplane came to rest partly off the runway.Oct 23, 1988 · N5504S · Substantial damageNTSB ANC89LA013Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Ivanof Bay, AKThe pilot was attempting to land on a 30 foot wide, 1200 foot gravel strip in gusty wind conditions. He said just prior to touchdown, the airplane encountered a strong gust of wind resulting in a hard landing short of the runway. The left main landing gear…Oct 23, 1988 · N8402S · Substantial damageNTSB ANC89LA011Accident · No injuriesLimited investigationFinal reportCessna 180 · Seldovia, AKThe private pilot was attempting to land his Cessna 180 airplane on the beach near Seldovia, AK. The main landing gear encountered a soft spot during the landing roll, and the airplane nosed over. Afterward, the pilot elected to fly the airplane to its home…Oct 22, 1988 · N820AK · Substantial damageNTSB MKC89LA009Accident · No injuriesLimited investigationFinal reportCessna 140 · Lawrence, KSThe plt elected to terminate a local flt due to windy, turbulent conditions aloft. He initiated a landing in a slight crosswind that he rprtd was gusting to 20 knots. Drg the landing, he lost control & the acft touched down hard in a nose low attitude.…Oct 21, 1988 · N4190N · Substantial damageNTSB LAX89LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Petaluma, CADuring a telephone interview, the pilot stated that she was attempting a touch and go landing when the airplane landed hard on its nosewheel. She lost directional control and the airplane collided with a hangar. There were no problems with the nosewheel…Oct 19, 1988 · N6184H · Substantial damageNTSB DEN89LA026Accident · No injuriesLimited investigationFinal reportCessna 210D · Malta, MTThe private plt, alone in the aircraft, was performing a landing on a paved road at a hunting resort. During final approach the Cessna struck power lines and damaged the nose gear. The acft touched down on the road and the nose gear collapsed. A post accident…Oct 19, 1988 · N3811Y · Substantial damageNTSB CHI89LA019Accident · No injuriesLimited investigationFinal reportCessna 182 · Pekin, ILThe pilot reported that he attempted to make a 'wheels' landing in the Cessna 182 (tricycle gear), and made a hard landing on the turf runway. The pilot aborted the landing, requested emergency equipment and circled the airport until the emergency equipment…Oct 19, 1988 · N5711B · Substantial damageNTSB LAX89LA017Accident · No injuriesLimited investigationFinal reportCessna 150F · Goodyear, AZThe plt rprtd that drg the landing roll, the acft enctrd a gust of wind & veered off the dirt strip & onto a raised berm (edge of rwy). After enctrg the soft dirt & rough terrain, the nose gear collapsed & the plane nosed over. The plt had landed with 40 deg…Oct 18, 1988 · N8194F · Substantial damageNTSB MIA89IA012Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · St. ThomasThe rt wing was dragged while ldg in a crosswind on rwy 10. The crew stated the aprch was normal & the touchdown was smooth on the rt gear with 3 degrees to 5 degrees of rt bank. The capt stated that immed after touchdown, the lt wing came up suddenly and he…Oct 17, 1988 · N706AA · Minor damageNTSB CHI89DEC01Accident · No injuriesFinal reportExperimental Barracuda · Ypsilanti, MIPilot's failure to maintain control of the aircraft during landing and inability to appropriately correct for the porpoise action of the aircraft.Oct 17, 1988 · N48DS · Substantial damageNTSB LAX89LA016Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Van Nuys, CAIn both his oral and written statements, the student pilot stated that during the landing roll he lost directional control of the airplane. The student attempted to make a go-around, but before becoming airborne the airplane veered to the left of the runway…Oct 16, 1988 · N25619 · DestroyedNTSB LAX89LA015Accident · No injuriesLimited investigationFinal reportHoward GFA-15P · Vacaville, CADuring the landing roll the pilot lost control of the airplane. The airplane ground looped and the main gear collapsed. There were no mechanical problems reported prior to the accident and the weather was not a factor.Oct 16, 1988 · N68119 · Substantial damageNTSB ANC89LA010Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Soldotna, AKDuring the landing roll the pilot lost directional control of the airplane. The airplane ground looped on the runway.Oct 16, 1988 · N1208C · Substantial damageNTSB MIA89LA010Accident · No injuriesLimited investigationFinal reportRaven S-60A · Tampa, FLDrg an apch to land, the plt saw some bushes & another balloon (which had already landed) in his intended landing area. He applied burner to soar over the obstacles, then pulled the envelope vent to quickly descend after the obstacles had been cleared. He…Oct 15, 1988 · N65523 · Substantial damageNTSB CHI89LA008Accident · Minor injuriesLimited investigationFinal reportCessna 120 · St Peter, MNThe plt had intended to make a touch-&-go landing on a grass strip, but stated that he came in 'somewhat high.' He rprtd the acft was still airborne about halfway down the rwy when he elected to go around. He attempted to add power, but the eng 'sputtered &…Oct 12, 1988 · N2081V · Substantial damageNTSB ANC89LA008Accident · No injuriesLimited investigationFinal reportde Havilland DHC-3 · Bonanza Hills, AKThe commercial pilot was attempting to land on a private gravel airstrip in rural Alaska. During the landing roll, the left main landing gear encountered snow along the runway edge and veered sharply to the left and off the runway.Oct 12, 1988 · N90574 · Substantial damageNTSB ANC89LA018Accident · No injuriesLimited investigationFinal reportCessna 182C · Akiachak, AKThe air taxi pilot landed long and was unable to stop the aircraft before it ran off the runway and came to rest in a ditch. A 30-40 kt gusty crosswind and turbulence existed at the time. The pilot stated that during the landing roll, he discovered that the…Oct 11, 1988 · N449SA · Substantial damage