OpenAirDocs.org

NTSB investigations

53,704 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 MKC86LA095Accident · No injuriesLimited investigationFinal reportCessna 150D · Marshfield, MOThe pilot stated that the approach speed was faster than normal due to erroneous airspeed indications. The aircraft floated upon flaring and the pilot raised the flaps. He states that the aircraft lost lift, bounced after a hard landing and subsequently…Apr 22, 1986 · N4169U · Substantial damageNTSB MIA86LA131Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Orlando, FLPlt extended landing gear while in the landing flare. The aircraft settled onto the landing gear doors as the landing gear was extending which prevented the landing gear from extending. The aircraft then settled onto its belly and skidded off the runway.Apr 22, 1986 · N6272V · Substantial damageNTSB MIA86LA127Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · San Juan, PRThe plt stated that on landing the acft started to porpoise. He lost control, the landing gear collapsed and the acft slid to a stop on the rwy.Apr 22, 1986 · N6155V · Substantial damageNTSB FTW86LA071Accident · No injuriesLimited investigationFinal reportCessna TU206G · Tomball, TXThe pilot reported that he failed to flare the aircraft when he touched down during landing at Tomball, TX. The aircraft bounced twice and the nosewheel dug into the dirt strip causing the aircraft to noseover.Apr 22, 1986 · N6272Z · Substantial damageNTSB CHI86LA125Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Noblesville, INTwo successful takeoffs and landings had previously been completed during the training flight. On the approach for the third landing, the crew received a three-green indication, but after touchdown, the nose gear folded and the aircraft settled on its nose.…Apr 22, 1986 · N39693 · Substantial damageNTSB FTW86LA069Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Keller, TXThe pilot reported colliding with a ditch along side the runway at goode airport in Keller, TX, when he failed to maintain directional control on landing. There was substantial damage to the aircraft when the impact tore off the left strut, causing the left…Apr 21, 1986 · N8376R · Substantial damageNTSB CHI86LA123Accident · No injuriesLimited investigationFinal reportCessna 182 · Augusta, WIThe pilot made his approach to runway 27 after noticing that the winds were from the north northwest. He said the made his approach at 80 KTS because of the crosswind. After touching down beyond his intended touchdown area he felt he would not clear the trees…Apr 21, 1986 · N94586 · Substantial damageNTSB NYC86LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Matawan, NJThe local sightseeing flight departed marlboro airport at about 1300 hours and returned at about 1400 hours. Entered pattern downwind and flew a normal pattern and approach. During flare, the aircraft was hit by a gust of wind. After touchdown and during…Apr 20, 1986 · N47355 · Substantial damageNTSB MIA86LA128Accident · Serious injuriesLimited investigationFinal reportAdams A55 · Alachua, FLThe plt stated the he decided to land because the wind had picked up during the flt. Upon landing the gondola tipped over resulting in himself and one passenger falling on top of the other passenger, who received a fractured leg.Apr 20, 1986 · N10600 · No damageNTSB ATL86FA116Accident · Minor injuriesField investigationFinal reportCessna 150M · Gaston, SCTwo aircraft collided and were substantially damaged during landing flare/touchdown at the uncontrolled airport. Both aircraft flew a left hand traffic pattern at a pattern altitude of 1000 ft MSL. A witness to the accident related that one aircraft flew…Apr 19, 1986 · N714PU · 2 aircraft · Substantial damageNTSB MIA86LA124Accident · No injuriesLimited investigationFinal reportCessna 172N · St. Augustine, FLThe private pilot with a total of 36.2 hours of logged flight time, stated that she landed hard on the nose wheel and the nose strut failed during a full stop landing.Apr 18, 1986 · N121SU · Substantial damageNTSB FTW86LA067Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Mt. Vernon, TXThe pilot reported landing at above normal speed, when he lost control of the aircraft at touchdown. The aircraft then veered off the runway onto wet grass. Do to the slippery conditions, the aircraft began sliding until it collided with a fence 100 feet from…Apr 17, 1986 · N2122L · Substantial damageNTSB ANC86LA046Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Big Lake, AKThe pilot stated that while doing a series of touch and go's, the aircraft veered on the runway; the pilot lost directional control of the aircraft causing the plane to nose over on its back.Apr 15, 1986 · N4482E · Substantial damageNTSB NYC86LA104Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Doylestown, PAThe pilot made a long landing and ran off the end of the runway. After departing the runway, he ran through a fence and hit a dirt embankment. The pilot said when he realized he was going off the end of the runway, he stayed on the brakes rather than add…Apr 14, 1986 · N41AR · Substantial damageNTSB ATL86LA112Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Orangeburg, SCDuring landing the student pilot lost directional control of the aircraft in a crosswind and ran off the side of the runway and into a drainage ditch.Apr 13, 1986 · N714DC · Substantial damageNTSB ANC86LA044Accident · No injuriesLimited investigationFinal reportCessna 120 · Lake George, AKThe pilot stated that during a three point landing the main landing gear broke through a thin layer of ice into approximately six inches of snow and then the aircraft went over on its back.Apr 13, 1986 · N3008N · Substantial damageNTSB SEA86LA103Accident · No injuriesLimited investigationFinal reportCessna 172 · Reno, NVThe student plt lost control of the acft during high gusty wind conditions. The acft then veered to the right of the rwy. The wind at the time of the accident was from 280 degrees at 28 knots gusting to 31 knots.Apr 12, 1986 · N5786T · Substantial damageNTSB SEA86LA102Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Harlen, ORThe acft contacted trees and descended to ground impact during an attempted go-around. The go-around was attempted after the plt over shot the farm field in which he had intended to land.Apr 12, 1986 · N88415 · DestroyedNTSB MKC86LA092Accident · No injuriesLimited investigationFinal reportCessna 172P · Omaha, NEThe plt stated he was attempting a night landing but after repeated trys he requested assistance on the radio. The plt further stated that the inoperative landing light compounded the trouble and he made a hard three point landing. Subsequent inspection of…Apr 12, 1986 · N63177 · Substantial damageNTSB LAX86LA174Accident · No injuriesLimited investigationFinal reportCessna 172N · Mesa, AZThe plt lost control of the acft during a touch and go maneuver and ran off the rwy. After touchdown the acft lifted back off the ground and drifted right. The acft then settled and touched down on the right shoulder of the rwy. The plt then noticed a…Apr 12, 1986 · N6235D · Substantial damageNTSB FTW86LQG14Accident · Minor injuriesFinal reportPiper PA-36-400 · Semonole, TXThe acft nosed over during landing. The plt stated that he landed straight in to the south in a 45 degree tailwind. The landing was made on a dirt strip after an aerial application flt.Apr 12, 1986 · N2401Z · Substantial damageNTSB DEN86LA122Accident · No injuriesLimited investigationFinal reportRJB Skybolt A-1 · Erie, COThe plt reported that the acft encountered a ridge on the rwy during the landing roll and swerved off the side. He said weather was not a factor. An FAA ops inspector examined the rwy after the acdnt and could not locate the reported ridge.Apr 12, 1986 · N42RJ · Substantial damageNTSB CHI86LA124Accident · No injuriesLimited investigationFinal reportHughes 269A · Lowell, MIThe pilot had just completed two autorotations when he landed hard on the third. The main rotor flexed down severing the tailboom and tailrotor. Although the pilot had logged over 6000 hours flight time, he had only 51 hours total rotorcraft time. He had…Apr 12, 1986 · N8059H · Substantial damageNTSB DEN86LA114Accident · Minor injuriesLimited investigationFinal reportAerotek PITTS-S-1S · Loveland, COAccording to the plt, the acft encountered a tailwind during the landing roll. The plt said the acft nosed over onto its back when he applied brakes. The plt had indicated his total flt experience in this tail wheel acft to be aprx 4 hrs.Apr 11, 1986 · N14RN · Substantial damageNTSB CHI86FEE02Accident · Serious injuriesFinal reportCessna 182Q · Lansing, ILWhile on the return flt to Lansing, IL, the plt checked the midway ATIS for info. He believed that just before landing at the Lansing muni arpt, the wind had shifted to the east. According to witnesses, the acft touched down on the last 1/3 of the 2432 ft…Apr 11, 1986 · N94531 · Substantial damageNTSB LAX86LA172Accident · No injuriesLimited investigationFinal reportCessna 182 · Jackson, CAThe acft went out of control and collided with terrain during a landing roll on rwy 19. The plt stated that a gust of wind lifted the right wing during the landing roll and the acft departed the rwy and collided with a ditch. The plt reported that the winds…Apr 10, 1986 · N9875E · Substantial damageNTSB MIA86LA116Accident · No injuriesLimited investigationFinal reportBeech BE-95 · Hollywood, FLThe acft had not been flown in over 2 yrs & the last annual inspection was performed 1-25-83. The acft had to be jump started due to a dead battery. During ldg roll-out, the gear collapsed. An exam of the bottom of the acft revealed damage consistent with the…Apr 8, 1986 · N17AT · Substantial damageNTSB LAX86LA166Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Mesa, AZThe pilot lost control of the aircraft which traveled off the runway following a nose gear collapse during landing. Examination of the aircraft revealed evidence of side loading.Apr 8, 1986 · N3872E · Substantial damageNTSB FTW86LA065Accident · No injuriesLimited investigationFinal reportTemco GC-1B · Del Rio, TXThe student pilot was being instructed in the landing of a tail dragger aircraft, when he lost control of the aircraft at touchdown. The instructor failed to take corrective action when the student pilot inadvertently applied left brake, causing the aircraft…Apr 8, 1986 · N2360B · Substantial damageNTSB DEN86LA111Accident · No injuriesLimited investigationFinal reportCessna 170B · St George, UTThe plt stated the acft encountered a crosswind and ground looped during the landing touchdown.Apr 8, 1986 · N2436D · Substantial damageNTSB CHI86FA119Accident · Minor injuriesField investigationFinal reportBoeing 737-222 · Chicago, ILThe left main landing gear collapsed moments after touchdown. Winds as reported by the twr were from 350 degs at 19 KTS gusting to 29 KTS. The captain and copilot reported the touchdown was normal. The 3 flight attendants said the aircraft landed hard and…Apr 8, 1986 · N9054U · Substantial damageNTSB BFO86LA022Accident · No injuriesLimited investigationFinal reportCessna 152II · Clinton, MDThe acft nosed over following a loss of control during touchdown. The student plt stated the acft bounced after touching down on all three landing gears. The pilot stated she may have panicked and pushed the control yoke forward. The acft touched down on the…Apr 8, 1986 · N757JZ · Substantial damageNTSB MIA86LA114Accident · No injuriesLimited investigationFinal reportCessna 177RG · Orlando, FLThe plt stated that on final apch he extended the landing gear but on touchdown the gear completely collapsed. Post crash examination of the acft revealed that the alternator belt was loose allowing the battery to drain down enough so the electric hydraulic…Apr 7, 1986 · N35911 · Substantial damageNTSB SEA86LA094Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Aberdeen, IDThe student plt was attempting to land on rwy 25 with a light x-wind form 040 degs at 5 KTS. The plt allowed the acft to drift to the left of the narrow rwy. As full pwr was added in an attempt to go-around, the acft struck the ground, veered left through a…Apr 6, 1986 · N26792 · Substantial damageNTSB MIA86LA118Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Umatilla, FLThe plt reported that he flared the acft too high while landing. The acft stalled too soon and a hard landing resulted.Apr 6, 1986 · N2662R · Substantial damageNTSB CHI86LA116Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Seneca, ILThe plt was landing on a 2300 ft rwy with a 80 degree x-wind. The acft bounced hard on touchdown and the plt attempted a go-around with 25 degrees of flaps extended. The airspeed was deteriorating so the plt elected to re-land. During the roll-out the acft…Apr 6, 1986 · N6829H · Substantial damageNTSB LAX86LA168Accident · No injuriesLimited investigationFinal reportCessna 140 · Palo Alto, CAThe purpose of the dual instructional flight was for the instructor pilot to check out a private pilot in the conventional gear Cessna 140 aircraft. After a series of uneventful full stop & touch & go landings, the student was directed to land. The CFI & a…Apr 5, 1986 · N89374 · Substantial damageNTSB CHI86LA118Accident · No injuriesLimited investigationFinal reportCessna 411 · Bloomington, INThe plt rprtd that while while on final apch to rwy 35, the acft encountered 'extreme wind-shift' & was blown about 550' rgt of course with a 30 kt loss of airspeed (fm 130 to 100 KTS). He stated the acft lost about 300', then was blown back on course with an…Apr 5, 1986 · N3213R · Substantial damageNTSB ATL86LA106Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Hamilton, OHThe plt made a low pass over the drag strip to check the wind. He climbed, made a 180 deg turn and attempted a normal landing. On roll out a wind gust was encountered which tipped the acft up on the right wheel. It veered off the hard surface into a guard…Apr 5, 1986 · N84394 · Substantial damageNTSB MKC86LA079Accident · No injuriesLimited investigationFinal reportCessna 172 · Ness City, KSThe pilot was landing to the north with a wind from the west-northwest at 15 knots, gusting to 20 knots. The pilot stated that he had full aileron into the wind and despite this action, the wing raised up by a strong gust and airplane flipped over to the…Apr 4, 1986 · N9866G · Substantial damageNTSB LAX86LA164Accident · No injuriesLimited investigationFinal reportCessna 150H · Tucson, AZThe pilot stated that after lowering the nosewheel during the landing, he heard a 'popping sound' and immediately raised the nosewheel off the runway. After the aircraft slowed and the pilot could no longer hold the nosewheel off, the aircraft veered to the…Apr 3, 1986 · N50306 · Substantial damageNTSB LAX86LA150Accident · No injuriesLimited investigationFinal reportCessna 172M · Rosamond, CAThe plt reported that he successfully touched down during conditions of a right, 90 deg. Crosswind. The plt stated that a gust was then encountered which 'weather cocked' his acft. As he attempted to realign the acft with the rwy the downwind wing contacted…Apr 3, 1986 · N666BH · Substantial damageNTSB CHI86IA115Incident · No injuriesIncident investigationFinal reportBoeing 757-251 · Minneapolis, MNN508US was operating as nwa flt 150. The captain stated after the incident that the flt was uneventful until landing. Upon landing and spoiler deployment, the acft pitched up abruptly, to an attitude of 10 degrees. The landing was completed without incident.…Apr 3, 1986 · N508US · Minor damageNTSB ATL86LA104Accident · No injuriesLimited investigationFinal reportCessna 152 · Murfreesboro, TNDuring landing roll the student pilot lost directional control of the aircraft and collided with a tree adjacent to the runway.Apr 3, 1986 · N93589 · Substantial damageNTSB LAX86LA162Accident · No injuriesLimited investigationFinal reportCessna 182J · Saint Johns, AZThe plt said his wx briefing indcd VFR conds along the route with ocnl thunderstorm (tstm) activity that might require diversion. As he was apchg the st Johns arpt, the plt saw tstms & ovrcst clds ahead & decided to land & wait for the wx to improve. The…Apr 2, 1986 · N2691F · Substantial damageNTSB SEA86LA091Accident · No injuriesLimited investigationFinal reportCessna T210C · Boise, IDWhile attempting to land on a parallel runway, the aircraft encountered wake turbulence from a landing transport aircraft. The aircraft rolled and struck the ground hard. A successful go around was then made with an uneventful landing. The pilot was aware of…Mar 31, 1986 · N3423F · Substantial damageNTSB CHI86FEC03Accident · No injuriesFinal reportCessna U-206B · Tecumseh, MIThe acft collided with terrain following a landing on rwy 18. According to the plt, a gust of wind lifted the right wing of the acft during roll out. The propeller then struck the ground and the acft rocked back onto the right wing.Mar 31, 1986 · N3855G · Substantial damageNTSB MKC86LA076Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · St.Charles, MOThe PIC was nervously concerned about an acft that was close behind him in the traffic pattern. The PIC landed fast on the rwy and the right main gear axle broke. The gear leg dug into the rwy and the acft veered off the left side into the soft terrain which…Mar 30, 1986 · N5055G · Substantial damageNTSB DEN86LA109Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12D · Santa Teresa, NMThe plt stated that he was performing touch & go landings. When the accident occurred. On the first landing a wind gust raised the right wing. The plt stated he 'tried to straighten out' the acft when it went off the right side of the rwy. The left main…Mar 30, 1986 · N43139 · Substantial damageNTSB ATL86FEI03Accident · Minor injuriesFinal reportCessna 170B · Columbia Stat., OHThe acft made a hard landing during which the left main gear was sheared off at the fuselage. Weather was not a factor. In the 90 days preceding this accident the plt had only flown 1 hour in this make & model of acft.Mar 30, 1986 · N2894C · Substantial damage