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 CHI87DET02Accident · No injuriesFinal reportCessna 170B · Angola, INPilot performed full stall landing in moderate right crosswind. Attempts to control weathercocking with full left rudder and aileron were ineffective. Left brake was ineffective. Aircraft received substantial damage in resultant ground loop.Mar 10, 1987 · N3135A · Substantial damageNTSB NYC87LA103Accident · No injuriesLimited investigationFinal reportCessna 150M · Poestenkill, NYThe aircraft came in high and fast, bounced on the centerline and veered left of the centerline on the second bounce. Pilot attempted to correct with right rudder and aileron but the aircraft continued to roll off of the runway and into snow where it nosed…Mar 8, 1987 · N714CD · Substantial damageNTSB ATL87LA080Accident · No injuriesLimited investigationFinal reportCessna 172M · Lexington, NCThe plt reported that he had transitioned to a visual approach, following a simulated radar approach to the rwy using vectors and descent info supplied by an instrument-rated safety plt in the rt seat. The safety plt was the plt's former instructor. The plt…Mar 7, 1987 · N61639 · Substantial damageNTSB NYC87LA107Accident · No injuriesLimited investigationFinal reportCessna 152 · Robbinsville, NJWhen the student plt was lndg after a LCL flt, the acft touched down nose wheel 1st, then ballooned & lndd hard. Drg the occurrence, the nose gear collapsed & the acft slid along the rwy for about 100 yds bfr coming to rest. After the acdnt, the student said…Mar 6, 1987 · N94902 · Substantial damageNTSB MKC87LA056Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Kimball, NEThe PIC rptd landing rwy 10 with a wnd fm 080 at 7 KTS. The acft began veering left and ran through a snow bank which bordered the rwy. The left main landing gear collapsed and the acft spun around 180 deg stopping tail first. Insp of the landing gear noted…Mar 6, 1987 · N5553P · Substantial damageNTSB MIA87LA099Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Tallahassee, FLControl of the acft was lost due to a strong wind gust created by the tree line next to the rwy & the acft crashed next to the rwy. A plt who had landed just prior to that time stated that he had sustained a momentary lost of acft control during the flare due…Mar 6, 1987 · N39588 · Substantial damageNTSB NYC87LA102Accident · No injuriesLimited investigationFinal reportCessna 172N · Danbury, CTStudent pilot lost directonal control on landing and the aircraft veered to the left of the runway and collided with a snowbank.Mar 5, 1987 · N5277E · Substantial damageNTSB BFO87FA026Accident · 4 fatalField investigationFinal reportCessna 210M · Charleston, WVThe aircraft bounced after landing touchdown. Witnesses observed the aircraft assume a nose high attitude and heard some power applied to the engine as the aircraft veered to the right. It was not determined whether the pilot was attempting to abort the…Mar 5, 1987 · N1230M · DestroyedNTSB MIA87FA098Accident · No injuriesField investigationFinal reportPiper PA-34-200 · Miami, FLThe plt stated that he was on final approach & cleared to land long, when a 737 was cleared for an immediate takeoff and he was told to make s turns or whatever necessary. He slowed to land and when he was approximately 10 to 20 ft. in the air he encountered…Mar 4, 1987 · N41531 · Substantial damageNTSB LAX87LA130Accident · No injuriesLimited investigationFinal reportGrumman AA-1B · Prescott, AZDuring a local solo instructional flight, the pilot reported that on landing, the aircraft touched-down on the nosewheel first and bounced. The aircraft swerved to the right and the pilot added power to initiate a go-around, however, the aircraft did not…Mar 2, 1987 · N1474R · Substantial damageNTSB BFO87LA025Accident · No injuriesLimited investigationFinal reportCessna 172N · Charlottesville, VAAfter climbing to cruise altitude and noting that the winds were stronger than expected, the pilot elected to divert to Charlottesville. Upon entering the traffic pattern, the pilot noted that he would be landing with a crosswind from the right. The aircraft…Mar 2, 1987 · N734ZD · Substantial damageNTSB ATL87LA078Accident · Serious injuriesLimited investigationFinal reportBeech 23 · Augusta, GAThe acft was flown from a pvt strip to a nrby arpt at statesboro, GA for refueling. After the acft was refueled, the englost pwr as the student plt was taxiing to takeoff. Water was fnd in the sumps, & rprtdly, 4 to 6 samples were required to drain water from…Mar 2, 1987 · N2355Z · Substantial damageNTSB ATL87LA077Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Dothan, ALThe plt reported that the acft nosed over when he applied the brakes during ldg roll-out. He estimated his groundspeed to be about 15-20 mph at the time.Mar 1, 1987 · N9257E · Substantial damageNTSB MIA87LA096Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · St.Augustine, FLThe private pilot stated that while attempting a landing the conventional gear aircraft bounced. He initiated a go around and when he added power the aircraft swerved left, ground looped and flipped over. The pilot stated that when he added power he relaxed…Feb 28, 1987 · N3707F · Substantial damageNTSB LAX87LA154Accident · No injuriesLimited investigationFinal reportCessna 190 · Chino, CAPrior to takeoff the pilot observed an asymmetrical deflection of the rudder/brake pedals. Upon landing he executed a right turn to depart the runway. The pilot stated that he was unable to stop the right turn and the aircraft ground looped damaging the left…Feb 28, 1987 · N4498C · Substantial damageNTSB LAX87LA131Accident · No injuriesLimited investigationFinal reportCessna 180 · Oatman, AZAt the end of a cross-country flight, the pilot reported that while on final approach, the aircraft encountered moderate turbulence. The pilot set up for a full stall to land in a three point attitude. During the flare, a gust of wind from the right rear blew…Feb 28, 1987 · N4786B · Substantial damageNTSB ANC87LA041Accident · No injuriesLimited investigationFinal reportCessna 180B · Palmer, AKThe pilot lost directional control while landing his tail wheel airplane in a crosswind. The pilot stated that a gust of wind lifted the right wing and he was unable to prevent the left wing from contacting the runway. The airplane eventually came to rest on…Feb 28, 1987 · N9141T · Substantial damageNTSB NYC87LA100Accident · No injuriesLimited investigationFinal reportCessna 172 · Cross Keys, NJThe plt rprtd that drg the lndg roll, he glanced down at the airspeed indcr, & at the same time, must have relaxed control of the acft. At about that time, the acft drifted to the left side of the rwy, the left main gear struck a snowbank & the acft nosed…Feb 27, 1987 · N9821J · Substantial damageNTSB LAX87LA129Accident · No injuriesLimited investigationFinal reportCessna 182Q · Springerville, AZA Cessna 182 collided with a snow bank after veering off runway 3. The pilot indicated that after touchdown the aircraft began to drift right and he was unable to correct it by applying left pedal. The aircraft suddenly veered left and the pilot applied right…Feb 27, 1987 · N735PQ · Substantial damageNTSB LAX87LA127Accident · Minor injuriesLimited investigationFinal reportChampion 7KCAB · Roosevelt, AZAt the end of a pleasure cross-country flight, the pilot reported that during the landing roll, the passenger was moving around in the back seat and accidentally pressed on the right brake. Before the pilot could get the aircraft under control, the aircraft…Feb 27, 1987 · N7572F · Substantial damageNTSB MIA87LA094Accident · No injuriesLimited investigationFinal reportCessna A185E · Melbourne, FLThe student plt inadvertently lowered the landing gear on the downwind leg in preparation for a water landing. The flt then turned base to final, &, upon touchdown, the acft nosed over & came to rest inverted in the lake. Investigation revealed that the…Feb 26, 1987 · N2287T · Substantial damageNTSB DEN87IA059Incident · No injuriesIncident investigationFinal reportBoeing 737-2A6 · Durango, COAmerica west airlines flt 166, a Boeing 737, departed phoenix, AZ, en route to Durango, CO. During the ILS apch to Durango's rwy 02 in IMC, the captain used a 10-15 degree crab angle to maintain the localizer course. Upon touchdown aprx 1000-1300 ft from rwy…Feb 26, 1987 · N145AW · No damageNTSB CHI87FA087Accident · No injuriesField investigationFinal reportRockwell NA265-65 · East Alton, ILAfter landing pilot lost directional control of the aircraft during rollout. Aircraft struck taxiway edge and taxiway marker sign causing substantial damage to aircraft. Post accident testing of the anti-skid system did not reveal any functional defects.Feb 26, 1987 · N465LC · Substantial damageNTSB MIA87LA093Accident · No injuriesLimited investigationFinal reportCessna 152 · Tallahassee, FLThe student plt failed to flare the aircraft, landed hard, bounced 2-3 times, then landed on the nose gear causing it to collapse.Feb 25, 1987 · N89126 · Substantial damageNTSB ATL87LA076Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Hampton, GAThe plt reported that a gusting x-wind existed during the approach to land. When he reduced pwr for touchdown, the acft pitched nose down, began a rapid sink and landed hard. The plt noted that he had the yoke full back but was unable to arrest the sink rate.…Feb 23, 1987 · N7681W · Substantial damageNTSB NYC87LA094Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Colebrook, NHThe plt rprtd that after arriving, the wind shifted to the NE, but he elected to land on rwy 21 'because of a frost heave.' Subsequently, he landed long to avoid the frost heave, but was unable to stop on the icy rwy. The acft contd off the departure end &…Feb 22, 1987 · N3967R · Substantial damageNTSB NYC87LA096Accident · No injuriesLimited investigationFinal reportCessna 172 · Poughkeepsie, NYDuring landing roll out, the pilot lost directional control as the aircraft veered to the right side of the runway and collided with a snowbank.Feb 21, 1987 · N7509G · Substantial damageNTSB LAX87LA124Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Petaluma, CAAt the end of a pleasure cross-country flt, the plt reported he was downwind to rwy 29 and noted the wind was light from 110 degs. On final apch the plt was following another acft and noted that the acft had a slight crab to the right. The plt observed that…Feb 21, 1987 · N56887 · Substantial damageNTSB BFO87FA024Accident · No injuriesField investigationFinal reportCessna R-182 · Martinsburg, WVThe plt stated that he forgot to make a final before lndg check because he was concentrating on traffic and the short lndg he had been requested to make. Twr personnel violated USAF procedures when they requested that the acft hold short of the east-west rwy…Feb 21, 1987 · N756KZ · Substantial damageNTSB ATL87LA075Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Hixson, TNDuring ldg roll on solo instructional flt, stu plt stated that he applied hand brakes and acft swerved to the left. Skid marks found at the site led from near the rwy centerline to a parked C-172 struck during the sequence. Subsequent inspection of the brake…Feb 21, 1987 · N6767W · Substantial damageNTSB ANC87LA038Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Anchorage, AKThe student pilot was practicing touch and go landings on a runway partially covered with snow and ice when he lost control of the aircraft and struck a runway perimeter snow berm. And nosed over.Feb 21, 1987 · N5135H · Substantial damageNTSB NYC87LA097Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Marlboro, NJWhile lndg on rwy 27, just bfr sunset, the acft was rprtd to be high & fast on the apch. Subsequently, it contd off the end of the rwy & collided with trees. The plt rprtd he was under stress due to recent death of his parents & the necessity to move the acft…Feb 20, 1987 · N8656P · Substantial damageNTSB MIA87LA089Accident · No injuriesLimited investigationFinal reportHughes 269A · Jacksonville, FLThe instructor plt was demonstrating a hovering autorotation landing with forward movement, when, after the throttle was closed, the helicopter hung in the air. Forward cyclic was then applied when he realized that the rotor RPM began to deteriorate. The…Feb 20, 1987 · N90270 · Substantial damageNTSB LAX87LA123Accident · No injuriesLimited investigationFinal reportCessna 182G · Vallecito, CAA Cessna 182G collided with the rwy surface after the nose gear collapsed at a private airstrip. The pilot indicated that the nose gear turned 90 degrees during the landing roll then collapsed. Pilot examined the nose gear after the accident and discovered…Feb 20, 1987 · N3683U · Substantial damageNTSB DEN87FA057Accident · Serious injuriesField investigationFinal reportCessna T210N · West Fargo, NDThe acft was observed flying low and slow on final approach to West Fargo arpt. The acft continued flt to the ground, hit hard, bounced and then flew close to the ground in a large sweeping arc until the left wing tip touched the ground. The acft subsequently…Feb 20, 1987 · N9499Y · Substantial damageNTSB ANC87LA037Accident · No injuriesLimited investigationFinal reportCessna A152 · Chugiak, AKThe student pilot was practicing touch and go landings on a snow covered runway when the pilot lost control of the aircraft, struck a runway perimeter snow berm and nosed over.Feb 20, 1987 · N761UC · Substantial damageNTSB FTW87LA067Accident · No injuriesLimited investigationFinal reportCessna 152 · Plano, TXAccording to the pilot, the aircraft was substantially damaged when he lost control of the aircraft on touch down.Feb 19, 1987 · N49054 · Substantial damageNTSB MKC87LA052Accident · No injuriesLimited investigationFinal reportBeech B-35 · Butler, MOThe PIC flew a traffic pattern that placed him landing long to the rwy at Butler, MO. The PIC perceived an eng failure prior to attempting a go-around and activated the fuel boost pump and advanced the throttle. The PIC rptd the eng faultered and quit. The…Feb 18, 1987 · N8827M · Substantial damageNTSB NYC87LA091Accident · No injuriesLimited investigationFinal reportCessna 172-M · Endicott, NYThe Cessna 172 was making a landing on runway 21 when it veered off the runway to the right and struck a snow bank. The aircraft received substantial damage and the sole occupant, the pilot, was uninjured. The winds were reported to be from 330' at less than…Feb 17, 1987 · N80583 · Substantial damageNTSB NYC87LA089Accident · No injuriesLimited investigationFinal reportCessna 152 · Albion, NYThe student pilot in a Cessna 152 was making a supervised solo and had completed 4 full stop landing without problem when on the fifth landing, the pilot lost control on the ground and hit a snow bank, flipping over. The pilot reported turbulent wind just as…Feb 17, 1987 · N757DD · Substantial damageNTSB LAX87LA133Accident · No injuriesLimited investigationFinal reportCessna 310G · Sedona, AZThe acft landed hard on rwy 3 while on a night VFR pleasure flight. The plt indicated that it was a dark night and he elected to fly the nda-a iap to insure terrain clearance while looking for the rwy. While on final apch he activated the mirl on the traffic…Feb 17, 1987 · N161A · Substantial damageNTSB MIA87LA085Accident · Serious injuriesLimited investigationFinal reportCessna 172I · Pelahatchie, MSThe plt stated that he was practicing emerg power-off landings, when, on final apch, realized he wouldn't clear the trees located west of the rwy. He then cleared them by adding power thought the acft then descended in a flare attitude until contact with the…Feb 14, 1987 · N8474L · Substantial damageNTSB CHI87LA084Accident · No injuriesLimited investigationFinal reportCessna 172 · Charlevoix, MIUpon landing the nose wheel buckled after striking a snowbank and the aircraft flipped over. Pilot reported there was a problem with the nose wheel although inspection of the nose wheel after the accident did not reveal any malfunction.Feb 14, 1987 · N8896B · Substantial damageNTSB ATL87LA072Accident · No injuriesLimited investigationFinal reportCessna 182R · Mobile, ALThe student plt was making a second attempt to land after a hard ldg, bounce, and subsequent go-around. On the first attempt, the acft touched down hard on all three wheels and swerved to the rt. The student plt reportedly pulled the nose up and the acft…Feb 13, 1987 · N5448N · Substantial damageNTSB MIA87LA083Accident · No injuriesLimited investigationFinal reportCessna 152 · Melbourne, FLThe acft ballooned during the student plt's first touch & go landing. She then lowered the nose of the acft, after which, it began to porpoise. The acft then touched down, bounced, stalled, & landed hard collapsing the landing gear.Feb 12, 1987 · N4613P · Substantial damageNTSB NYC87LA084Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Oxford, MAThe plt rprtd that drg a lndg, the acft enctrd a gust of wind & veered into a ground loop before he could correct the situation. The acft then hit a snowbank at the side of the rwy & was damaged. The plt rprtd the wind was from 300 deg at 12 gusting 15 KTS.Feb 11, 1987 · N7182B · Substantial damageNTSB NYC87FA085Accident · No injuriesField investigationFinal reportBeech 99 · Oneonta, NYThe flight was uneventful until its arrival at Oneonta municipal airport. The aircraft landed 10 feet short of runway 24IN one foot of snow. The left main landing gear collapsed, the propeller struck the runway and the aircraft veered off the left side of the…Feb 11, 1987 · N699CA · Substantial damageNTSB DEN87LA054Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Colo. Springs, COThe Balloon attempted a normal landing. The instructor plt diverted his attention while the student plt allowed the envelope to cool excessively. This gave a high rate of descent and the Balloon made a hard landing.Feb 11, 1987 · N40458 · No damageNTSB BFO87LA021Accident · No injuriesLimited investigationFinal reportCessna 310Q · Moundsville, WVOn touchdown the pilot realized that he was long but decided it was too late to go-around. He intentionally ground looped the aircraft to the right. Both ends of the runway drop off into a valley.Feb 11, 1987 · N918MC · Substantial damageNTSB LAX87LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Tulare, CAThe pilot attempted to land while the runway and VASI approach lights were off. The night was dark and he inadvertently landed on a roadway parallel to the runway. The aircraft collided with a fence when the road came to a dead end adjacent to the near…Feb 10, 1987 · N7498J · Substantial damage