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 SEA88LA141Accident · No injuriesLimited investigationFinal reportCessna 152 · Ft. Lewis, WAThe pilot had just received his fixed wing rating. The pilot stated that he made a hard landing. The aircraft then began to porpoise. On the third bounce the nosegear failed and the aircraft departed the runway. As the aircraft came to rest a small fire…Jul 29, 1988 · N24995 · Substantial damageNTSB CHI88LA184Accident · No injuriesLimited investigationFinal reportPiper J-3 · Waynesville, OHDuring a dual instructional flight for the purpose of practicing takeoffs and landings with a pre-solo student, the instructor pilot failed to maintain adequate aircraft control and visual lookout, and the aircraft departed the right side of the runway,…Jul 29, 1988 · N92483 · Substantial damageNTSB CHI88FA178Accident · No injuriesField investigationFinal reportSonerai IIL · Oshkosh, WIJul 28, 1988 · N398 · Substantial damageNTSB CHI88FA177Accident · No injuriesField investigationFinal reportQuickie Q-2 · Oshkosh, WIThe plt was on a flt to Oshkosh to an eaa convention. When he arrived, traffic was hvy & special traffic procedures were in effect. Info to attendees (before the convention) advertised that the north/south rwys would be used primarily for display acft & the…Jul 28, 1988 · N48BH · Substantial damageNTSB ANC88LA099Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Kustatan River, AKThe private pilot was attempting to land his Piper PA-14 airplane at a remote beach fishing site in gusty crosswind conditions. He reportedly encountered a wind gust upon touch down, lost directional control and struck an abandoned hunting shack and an…Jul 28, 1988 · N5135H · Substantial damageNTSB MKC88LA139Accident · No injuriesLimited investigationFinal reportGrumman G164-B · Gould, ARThe pilot said that while returning from an aerial application operation, he lost directional control during the ldg. He veered off the concrete runway, into the soft, tall grass border, and nosed over.Jul 27, 1988 · N54JS · Substantial damageNTSB MKC88LA138Accident · No injuriesLimited investigationFinal reportCessna 172 · Lamar, MOThe plt of the aerial applicator acft said he was pulling out for an intersection departure on rwy 21, when the Cessna on a landing roll, struck him from the rear. The pilot said that possibly the background, haze, and airframe components made the incoming…Jul 27, 1988 · N29168 · 2 aircraft · Substantial damageNTSB ANC88LA098Accident · No injuriesLimited investigationFinal reportCessna 180A · Northway, AKThe commercially certificated pilot was landing at Northway, AK., when the airplane ground-looped to the left. He reportedly had also ground-looped the same airplane when he landed at whitehorse, Canada, just prior to the landing at Northway. A post-accident…Jul 27, 1988 · N5327D · Substantial damageNTSB ANC88LA097Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe private pilot and his passenger were uninjured when their Piper PA-18 (super cub) ground-looped while landing at Anchorage international airport, Anchorage, AK. The pilot stated that the right main landing gear tire 'grabbed' when it touched the paved…Jul 27, 1988 · N8653Y · Substantial damageNTSB CHI88LA175Accident · No injuriesLimited investigationFinal reportBeech 35R · Manito, ILDrg arrival, the plt experienced an electrical prblm with the landing gear & had to use manual extension procedures. He stated that when he selected the flaps for landing, he heard the motor run, but did not visually check that the flaps were extended. Just…Jul 26, 1988 · N3016V · Substantial damageNTSB MIA88LA238Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Sanford, FLThe CFI stated they had completed 2 touch & go ldgs without incident. On the next, the acft 'suddenly yawed to the left & the side load must have weakened the gear as the gear warning horn began to sound indicating the gear was no longer down & locked'. He…Jul 25, 1988 · N2197K · Substantial damageNTSB LAX88LA291Accident · No injuriesLimited investigationFinal reportCessna T210K · Huntington Bch, CADuring the landing roll, the pilot heard a loud bang on the right side of the airplane. When the pilot applied brakes and the speed dissipated, directional control was lost. The airplane veered of the runway and collided with a runway light. During an…Jul 25, 1988 · N8273M · Substantial damageNTSB LAX88LA270Accident · No injuriesLimited investigationFinal reportCessna 152 · Bakersfield, CAThe student plt rprtd that drg a lndg on a solo instructional flt, his final apch was a little fast. Drg the lndg, the airplane began to porpoise. However, before the student regained control, the nose gear collapsed.Jul 25, 1988 · N68342 · Substantial damageNTSB DEN88LA174Accident · No injuriesLimited investigationFinal reportCessna 172M · Gillette, WYThe student plt was completing his first solo x-country flt. During touchdown, the airplane bounced and began to porpoise. On the third bounce, the nose wheel fork failed. Subsequently, the acft turned 180 deg to the left & came to rest on the left side of…Jul 25, 1988 · N5266J · Substantial damageNTSB DEN88LA166Accident · No injuriesLimited investigationFinal reportKrall Dragonfly · Mitchell, SDDrg the 1st attempt to land, the acft bounced several times, then the plt made a go-around. On the 2nd attempt, the acft bounced again & began to porpoise. A witness heard the eng RPM increase to 'what sounded like full power.' The acft lifted off, but…Jul 25, 1988 · N42JK · Substantial damageNTSB CHI88DEX10Accident · No injuriesFinal reportWilliams Waco · Madison, INThe plt made svrl hi speed taxi checks, then took off on his 1st flt in this make & model of acft. He climbed to alt to check the stall characteristics, then returned to the arpt. However, as he was landing, the acft contacted the ground near the end of the…Jul 24, 1988 · N810TW · Substantial damageNTSB MKC88LA122Accident · No injuriesLimited investigationFinal reportRockwell S2R · Brinkley, ARDuring the take-off roll for an aerial application operation, the pilot said he lost his left wheel braking capability. He continued the take-off, flew to the farm field to be treated, applied the load, then returned to a near by alternate landing strip…Jul 23, 1988 · N4080X · Substantial damageNTSB MIA88LA235Accident · No injuriesLimited investigationFinal reportCessna 172M · Plymouth, FLAfter a normal lndg, during the lndg roll at aprx 50-55 mph, the acft rolled through a 1-2' deep puddle of water. The acft slowed & at aprx 35 mph, the rt main lndg gear slowly began rotating aft. The acft came to rest supported by the rt horizontal…Jul 23, 1988 · N12840 · Substantial damageNTSB CHI88LA172Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Greenfield, INDuring a dual instructional flight for purpose of practicing landings in a conventional gear aircraft, the student pilot abruptly nosed the aircraft toward the turf runway. The instructor pilot did not take remedial action and the aircraft struck the ground,…Jul 23, 1988 · N83430 · Substantial damageNTSB ANC88LA095Accident · Serious injuriesLimited investigationFinal reportCessna 207A · Kongiganak, AKThe aircraft touched down approximately 2/3 of the way down the runway. During the ldg roll, aircraft hit a rut on the runway. The plane nosed over and came to rest on its back, off the departure end of the rwy. The FAA flt info publication states that this…Jul 23, 1988 · N1773U · Substantial damageNTSB CHI88LA173Accident · No injuriesLimited investigationFinal reportPiper J-3 · Minneapolis, MNWhile practicing a landing on a solo instructional flight, the student pilot allowed the aircraft to drift off the left side of the runway and strike the VASI lights. The student pilot had only flown 2 hours, including 10 takeoffs and landings, in the past 90…Jul 22, 1988 · N25WF · Substantial damageNTSB MIA88IA230Incident · No injuriesIncident investigationFinal reportPiper PA-34-200T · Tampa, FLShortly after depg, the plt elected to rtrn to the arpt for paperwork he had forgotten. He rprtd the apch & touchdown were normal, but drg the lndg roll, the left main gear collapsed. Subsequently, the acft veered off the rwy & hit a rwy lgt before stopping.…Jul 21, 1988 · N47506 · Minor damageNTSB FTW88LA135Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · La Grange, TXThe pilot said he flew over the airport and found the winds favored a landing on runway 18. He said he descended to the downwind leg, and when he added power, the engine would not respond. However, he said the engine continued to run. He decided to make an…Jul 20, 1988 · N8949P · Substantial damageNTSB NYC88LA172Accident · No injuriesLimited investigationFinal reportCessna 150 · Massena, NYThe student pilot on a crosscountry flight to Massena, new york stated that during the landing approach he felt that he was too low and when he tried to correct, the aircraft bounced. On the second touchdown the nose gear collapsed and the aircraft slid off…Jul 18, 1988 · N704HT · Substantial damageNTSB ANC88DAG06Accident · No injuriesFinal reportAir Command 532 Elite · Palmer, AKDuring landing approach an excessive rate of descent developed very near the runway. The gyroplane landed hard. After the hard landing the pilot reported that he pulled the control column to its aft position abruptly. The small tail wheel struck the runway…Jul 18, 1988 · N1925 · Substantial damageNTSB FTW88LA133Accident · No injuriesLimited investigationFinal reportCessna 310B · Ruston, LABoth airplanes were in the traffic pattern. The Cessna 152 made radio calls in the blind; the Cessna 310 did not. Both airplanes were on final at the same time with the 152 in the lead and the 310 lower. The 310 passed the 152 just before touchdown. The 310…Jul 17, 1988 · N295C · 2 aircraft · Minor damageNTSB MIA88LA222Accident · No injuriesLimited investigationFinal reportCessna 150G · Keystone Height, FLWhile on a personal flt during the seventh touch & go landing, the acft bounced & drifted off the left side of the rwy. The plt added power & rolled the acft into a right bank to correct this but the right wing collided with terrain. The acft then nosed over…Jul 16, 1988 · N3983J · Substantial damageNTSB LAX88LA261Accident · No injuriesLimited investigationFinal reportCessna 185E · Lone Pine, CAThe plt rpted that the engine cylinder temperature was very high as he crossed mountainous terrain. He elected to make a downwind precautionary landing to a short airstrip with a high density altitude. The acft touched down beyond the normal touchdown zone,…Jul 16, 1988 · N23FB · Substantial damageNTSB CHI88LA168Accident · No injuriesLimited investigationFinal reportEnstrom 280FX · Menominee, MIDuring a demonstration of an autorotation to a run-on landing, the helicopter skids dragged in the soft grass upon touchdown, and the helicopter veered to the left. The pilot failed to maintain aircraft control when the helicopter veered left, the right skid…Jul 16, 1988 · N280FX · Substantial damageNTSB DEN88LA159Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Gallup, NMJul 15, 1988 · N772WM · Substantial damageNTSB LAX88LA255Accident · Serious injuriesLimited investigationFinal reportGeneral Balloon AX-6 · Pilot Hill, CADuring a local sightseeing flight, just prior to touchdown, the Pilot reported that a gust of wind caught the balloon. The Pilot made a high wind landing. The balloon was dragged several feet before coming to rest. The Pilot stated that afterward the winds…Jul 14, 1988 · N2614M · No damageNTSB CHI88IA165Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD80 · Chicago, ILJul 14, 1988 · N253A · No damageNTSB CHI88LA166Accident · No injuriesLimited investigationFinal reportGulfstream Aerospace G-21-G · Elyria, OHJul 13, 1988 · N77AQ · Substantial damageNTSB MIA88LA219Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Palm City, FLThe plt stated that he landed long on a dirt and grass road. During landing roll, he applied heavy brakes to stop the acft. The acft swerved to the left. He unsuccessfully tried to regain control. The a/c went down an embankment and the left wing dug into a…Jul 12, 1988 · N8502V · Substantial damageNTSB LAX88LA253Accident · No injuriesLimited investigationFinal reportCessna T210L · Bakersfield, CADuring the landing roll, the right brake failed to hold. The airplane veered to the left, off the runway and collided with a runway light. Inspection of the brake revealed that there was no fluid in the system. No leaks were discovered during the exam of the…Jul 12, 1988 · N60856 · Substantial damageNTSB DEN88LA154Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Cody, WYDuring landing on a ranch road while on a business flight the plt struck a pile of gravel placed on the road to facilitate road repairs. The aircraft flipped over and caused substantial damage to the vertical stabilizer, horizontal stabilizer, propeller and…Jul 12, 1988 · N6083A · Substantial damageNTSB ANC88LA089Accident · No injuriesLimited investigationFinal reportPiper PA-22 · North Pole, AKWitnesses stated that acft #1 (N2747P,a Piper PA-22), flew a right downwind about 200 feet above the ground and then made a steep descending turn toward the runway. Acft #1 landed and struck acft #2 (N9102D, a Piper PA-18) while both were on the runway. The…Jul 12, 1988 · N2747P · 2 aircraft · Substantial damageNTSB CHI88LA164Accident · No injuriesLimited investigationFinal reportCessna 210M · Indianapolis, INThe pilot reported that he was on his way back from another local airport. He thought that he had lowered the gear when he had entered the traffic pattern. The aircraft landed gear up. Post-accident exam disclosed no mechanical failures or system malfunctions…Jul 10, 1988 · N210WP · Substantial damageNTSB CHI88FA162Accident · 1 fatalField investigationFinal reportCessna 172M · Holland, MIPilot's inadequate aircraft handling during the approach to landing and landing flare phase of flight. The pilot's failure to recognize and avoid a situation from which it was impossible-due to the weight of the aircraft, the amount of power available from…Jul 10, 1988 · N80943 · DestroyedNTSB BFO88LA066Accident · Serious injuriesLimited investigationFinal reportBalloon Works AX-8 · Purcellville, VAThe pilot landed the hot air Balloon at an excessive descent rate which resulted in a hard landing. Wind gust are a contributing factor.Jul 10, 1988 · N7108 · Minor damageNTSB ANC88LA088Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKAfter touchdown on the airstrip the pilot lost control of the airplane. The airplane bounced. The airplane then exited the left side of the runway into a row of trees.Jul 10, 1988 · N4346B · Substantial damageNTSB SEA88LA133Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Seattle, WAOn the first leg of the scheduled float plane flight the plt had landed on lake union to embark addl pax. As the acft decelerated 'off the step,' a power boat converged on acft path. Plt made rudder input to avoid collision and wingtip contacted water.Jul 9, 1988 · N67679 · Substantial damageNTSB FTW88IA129Incident · No injuriesIncident investigationFinal reportEmbraer EMB-110P1 · Abilene, TXThe airplane touched down on the main wheels, bounced, then touched down on the runway with all three landing gear retracted with the gear doors closed. During the investigation, no electrical, mechanical, or hydraulic malfunctions could be found. The landing…Jul 9, 1988 · N91DA · Minor damageNTSB DEN88LA155Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Aurora, COThis was the student pilot's first solo landing. She said the acft drifted to the left of the centerline during the landing roll and she attempted to correct with right rudder. However, the acft continued to the left and ran off the left side of the rwy. The…Jul 9, 1988 · N67712 · Substantial damageNTSB DEN88LA150Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Erie, COJul 9, 1988 · N135E · Substantial damageNTSB ANC88LA085Accident · 1 fatalLimited investigationFinal reportMaule M6-235 · Egegik, AKAfter touchdown on the beach, the aircraft struck a three-wheeled scooter (atv). The atv was substantially damaged and the driver of the atv, an eleven year old boy, died a few days later. The atv passenger, a eight year old girl, received minor injuries.…Jul 9, 1988 · N5647Y · Substantial damageNTSB SEA88LA124Accident · No injuriesLimited investigationFinal reportCessna 152 · Roche Harbor, WAPlt was attempting no flap landing on down-sloping narrow runway in variable and gusty wind conds. Hard landing resulted in departure from hard surface, encounter with parallel ditch and rock, and noseover.Jul 8, 1988 · N4590P · Substantial damageNTSB MKC88LA130Accident · No injuriesLimited investigationFinal reportBeech A-36 · Marion, IAWhile attempting to land after one go-around. Witnesses said the acft touched down beyond the half way point on the 2300 foot sod runway. He appeared to be high and fast according to witnesses. The pilot said he might have mistaken the threshold and landed…Jul 8, 1988 · N25496 · Substantial damageNTSB MIA88LA218Accident · No injuriesLimited investigationFinal reportCessna 150F · Plymouth, FLThe student pilot was on a solo instructional flight. The winds were reported to him as a 20-30 degree crosswind at 15 knots gusting to 20. The student pilot lost control of the acft. The right wing contacted the runway, then the acft nosed over. The pilot…Jul 8, 1988 · N8691S · Substantial damageNTSB CHI88LA161Accident · No injuriesLimited investigationFinal reportCessna 170B · Rockford, ILJul 8, 1988 · N8048A · Substantial damage