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 DEN88LA070Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Circle, MTPlt and passenger were hunting coyotes from the air. Upon landing to pick up a coyote they had shot, the acft encountered deep snow and nosed over.Feb 14, 1988 · N55PA · Substantial damageNTSB CHI88LA062Accident · No injuriesLimited investigationFinal reportCessna 172 · Ft. Wayne, INAirplane nosed over in soft snow during a crosswind landing attempt. The PIC tried to recover from a loss of directional control by attempting to roll out on snow covered sod after hopping over a snowbank that was next to the runway landing surface.Feb 14, 1988 · N5499K · Substantial damageNTSB LAX88LA109Accident · No injuriesLimited investigationFinal reportCessna 185E · Redding, CAThe canadian plt attempted to land the conventional gear acft on runway 34 with the reported local wind from 330 deg at 16 KTS. The acft touched down about 2400 ft beyond the threshold of the 7003-foot-long rwy. After a bounced landing, directional control…Feb 13, 1988 · CFCTO · Substantial damageNTSB ANC88LA029Accident · No injuriesLimited investigationFinal reportCessna 180 · 70 Nw Anchorage, AKThe pilot stated that during the landing roll on the frozen lake he lost directional control of the aircraft due to the snow on the lake. The aircraft then nosed over on its back.Feb 13, 1988 · N674M · Substantial damageNTSB NYC88LA085Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-35 · Philadelphia, PAThe Mitsubishi MU-2B-35 landed and damage was observed on the underside of the left wing midway between the engine and tip tank and outboard to the tip tank. Further examination of the wing showed a broken lower front wing spar and a bent rear lower wing…Feb 12, 1988 · N339MA · Substantial damageNTSB NYC88LA081Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Chatham, MAAfter aborting two landings on runway 24 at Chatham, Massachusetts, the pilot was advised by radio to use runway 6. While attempting a landing on runway 6, the airplane touched down short of the runway and the landing gear was sheared off when it struck a…Feb 12, 1988 · N9281P · Substantial damageNTSB MKC88LA052Accident · No injuriesLimited investigationFinal reportCessna 172 · Kimball, NEThe pilot said that he was using outdated charts for his destination apt. He failed to notice a new runway. He also failed to notice the yellow x's, signifying closure of the old runway. It was almost parallel to the runway, within ten degrees of heading. Ldg…Feb 11, 1988 · N12600 · Substantial damageNTSB CHI88LA065Accident · No injuriesLimited investigationFinal reportCessna 172F · Brighton, MIFeb 11, 1988 · N8863U · Substantial damageNTSB CHI88IA061Incident · No injuriesIncident investigationFinal reportDouglas DC-10 · Chicago, ILJudgemental error on the part of the local controller for clearing vehicles across the active runway tiwh insufficient separation from arriving aircraft, which was further compromised by a mechanical malfunction in the equipment crossing the runway.Feb 11, 1988 · N123AA · No damageNTSB LAX88LA107Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Van Nuys, CAThe student pilot was on his second supervised solo and had executed a go-around on his first attempted touch & go maneuver. The plt reentered the traffic pattern and landed on runway 34L. The airplane exited to the left of the runway onto the grass. With the…Feb 10, 1988 · N25732 · Substantial damageNTSB FTW88FA060Accident · No injuriesField investigationFinal reportPiper PA-32RT-300T · Oklahoma City, OKThe airplane was equipped for IFR but not equipped to fly into icing cond. At 4000 feet MSL, the OAT was above freezing. At 3000 feet MSL the airplane was in clouds with OAT of 32 degrees f. the plt elected to attempt downwind ILS approach and landing. Plt…Feb 10, 1988 · N2186K · Substantial damageNTSB DEN88LA067Accident · No injuriesLimited investigationFinal reportCessna 180 · Roundup, MTThe private plt rancher was completing a work flt. During the flt, the plt made 5 off arpt landings in snow 5 to 6 inches deep. The landing on which the accident occurred was made at a local arpt on a snow covered rwy. During the landing, the acft sank into…Feb 10, 1988 · N7661A · Substantial damageNTSB DEN88LA066Accident · No injuriesLimited investigationFinal reportPiper J3C · Cody, WYDuring an attempted landing at a private airstrip which was covered by 5-6 inches of dry powdered snow, the acft touched down. It pitched forward and nosed over. After the acft came to rest, the pilot got out of the acft, examined the landing gear, and…Feb 10, 1988 · N7468 · Substantial damageNTSB MKC88LA048Accident · No injuriesLimited investigationFinal reportCessna T-188C · Goodland, KSWhile flying a certificated experimental ag acft, for purpose of compliance with FAR regulations, the employee of the federal aviation administration lost control during landing rollout. The wind conditions, relative to the runway, were about a 80 degree…Feb 9, 1988 · N4509J · Substantial damageNTSB MIA88LA102Accident · Minor injuriesLimited investigationFinal reportHess QUICKIE-2 · Orlando, FLThe plt stated that on the landing rollout, the acft began to veer left. While he was attempting correction to the right, the acft hit a bump off the runway, flipped over & came to rest inverted.Feb 9, 1988 · N3241K · Substantial damageNTSB CHI88LA059Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Wis. Rapids, WIAirplane drifted left into a snowbank while rolling out from a landing on a snow and ice covered runway. Landing winds as reported by the pilot were from 60 degrees to the right of the nose at 5 to 8 knots.Feb 9, 1988 · N3790T · Substantial damageNTSB LAX88LA106Accident · No injuriesLimited investigationFinal reportCessna TR182 · Truckee, CAFeb 7, 1988 · N5533S · Substantial damageNTSB SEA88LA044Accident · No injuriesLimited investigationFinal reportCessna 172N · Henderson, NVDuring ground landing roll on a touch and go practice session, the solo student pilot allowed the aircraft to drift off the side of the runway and overcorrected in the opposite direction. After applying full power to abort the landing, she realized the flaps…Feb 5, 1988 · N2249E · Substantial damageNTSB MIA88LA100Accident · No injuriesLimited investigationFinal reportBeech V-35 · Fernandina Bch, FLWhile on a personal flt, the acft landed gear up. The plt stated that he lowered it. He also stated that the gear warning horn was inoperative. Operational check of the landing gear revealed no discrepancies except for an improperly adjusted warning horn &…Feb 5, 1988 · N7987M · Substantial damageNTSB CHI88LA058Accident · No injuriesLimited investigationFinal reportBeech A36 · Pontiac, MIFeb 4, 1988 · N383SP · Substantial damageNTSB NYC88LA091Accident · No injuriesLimited investigationFinal reportCessna 303 · Hyannis, MAThe Cessna 303 broke out of the clouds and made a long landing on a 5567 ft runway. Tire marks showed that the aircraft touched down with less than 2000 ft of runway remaining. The landing runway was 24 and the winds were from 360 degrees at 8 KTS. The runway…Feb 3, 1988 · N5461V · Substantial damageNTSB MKC88LA051Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Texarkana, ARFollowing the completion of the ILS approach and landing on runway 22 at the Texarkana, Arkansas airport the nose gear of the aircraft collapsed during the landing roll. The aircraft collided with the runway causing substantial damage to the aircraft. The…Feb 3, 1988 · N2824M · Substantial damageNTSB DEN88FA061Accident · Minor injuriesField investigationFinal reportConvair 580 · Durango, COAfter making an IFR approach, the pilot made a go-around because he was blinded by the reflection of the landing/taxi lights against the falling snow. The pilot landed the aircraft after the second approach. The pilot said he sensed the aircraft drifting to…Feb 3, 1988 · N5808 · Substantial damageNTSB CHI88LA057Accident · No injuriesLimited investigationFinal reportCessna 421A · Wheeling, ILFeb 3, 1988 · N421Q · Substantial damageNTSB NYC88LA075Accident · No injuriesLimited investigationFinal reportCessna 402C · Provincetown, MAThe Cessna 402C was being positioned for a scheduled commuter flight with only a pilot on board. The pilot made an ILS approach to runway 7 with winds from 220 degrees at 14 knots, the runway wet and light rain falling. The aircraft slid off the end of the…Feb 2, 1988 · N29PB · Substantial damageNTSB MKC88IA046Incident · Minor injuriesIncident investigationFinal reportSaab-Fairchild SF-340A · Fayetteville, ARThe capt rprtd that drg the lndg roll, there was a loud noise from the left eng followed by hvy smoke & an eng fire warning bell. He stopped the acft on a twy & ordered an evacuation. The flt attendant had difficulty opening the floor-level emerg exit. No…Feb 2, 1988 · N322PX · Minor damageNTSB BFO88LA016Accident · No injuriesLimited investigationFinal reportDassault DA-20 · Wheeling, WVThe acft landed after an ILS apch to rwy 03. According to the plt shortly after touchdown he saw deer ahead on the rwy. Before he could take evasive action the acft struck two deer. Afterwards brake pressure was lost. The plt steered the acft onto grass off…Feb 1, 1988 · N287W · Substantial damageNTSB NYC88LA070Accident · No injuriesLimited investigationFinal reportCessna 195 · Meriden, CTAfter performing several touch and go landings, the student pilot made a landing right of the center line. The aircraft drifted to the right, struck a snowbank, sheared off the left main landing gear, then groundlooped. The aircraft came to rest on the grass…Jan 31, 1988 · N1077D · Substantial damageNTSB MIA88LA098Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Clearwater, FLPlt stated acft stalled during landing flare resulting in a hard landing. After the hard landing the acft bounced into the air and veered to the left. Before a go-around could be completed the acft collided with a dirt mound between the runway and taxiway…Jan 31, 1988 · N28571 · Substantial damageNTSB MIA88LA096Accident · No injuriesLimited investigationFinal reportCessna 150 · Titusville, FLStudent pilot lost directional control while landing with right quartering wind. The acft departed the left side of the runway and the nose gear bogged down in sand. The nose gear then failed aft and the acft came to rest on the nose and left wing tip.Jan 31, 1988 · N9260U · Substantial damageNTSB LAX88LA104Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Sonoma, CAAt the end of a local pleasure flight, during the landing roll, the pilot lost control of the aircraft and ground looped. There were no reported mechanical failures or malfunctions of the aircraft.Jan 31, 1988 · N5058K · Substantial damageNTSB DEN88LA059Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Peyton, COJan 30, 1988 · N62491 · Substantial damageNTSB LAX88IA102Incident · No injuriesIncident investigationFinal reportFairchild SA227AC · S. Lake Tahoe, CACaptain's failure to follow flight manual procedures in the operation of the anti-ice/de-ice systems.Jan 29, 1988 · N368AE · No damageNTSB MKC88LA047Accident · No injuriesLimited investigationFinal reportCessna 152 · Ottawa, KSThe student pilot was on a solo cross country flight. During the landing, the aircraft began to porpoise. The pilot performed remedial action, however, the aircraft had already sustained substantial damage.Jan 28, 1988 · N4717A · Substantial damageNTSB DEN88LA058Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Colorado Spring, COThe private plt and two passengers were conducting a personal night flight. During landing, the aircraft drifted left and the left main gear struck a snow drift. The plt elected to go around and on the second approach at touchdown, the aircraft skidded left…Jan 28, 1988 · N1246T · Substantial damageNTSB SEA88LA041Accident · Minor injuriesLimited investigationFinal reportCessna 172M · St. Anthony, IDDuring landing onto the 50 foot wide snow covered runway, directional control was lost with the aircraft drifting to the left of the runway, striking a snow berm, and then nosing over inverted.Jan 27, 1988 · N2320E · Substantial damageNTSB CHI88LA051Accident · No injuriesLimited investigationFinal reportCessna 172N · Fond Du Lac, WIJan 24, 1988 · N75716 · Substantial damageNTSB SEA88LA037Accident · No injuriesLimited investigationFinal reportCessna 172P · Vashon Island, WADuring landing roll the pilot made an intentional groundloop to avoid trees at the end of the short, wet, S0D runway. The pilot reported that the use of brakes was ineffective. He stated that he made the landing using 30 degs of flaps at an airspeed of 60…Jan 20, 1988 · N5328K · Substantial damageNTSB MKC88LA044Accident · No injuriesLimited investigationFinal reportCessna 206 · Wichita, KSDuring a night ldg with strong gusty x-winds, the PIC lost control during the roll out and careened off the runway substantialy damaging the acft. The PIC stated the windshield was partially coated with ice making forward visibility difficult.Jan 20, 1988 · N4978C · Substantial damageNTSB MIA88LA091Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-301 · Port Saint Joe, FLWhile on a business flt, unable to locate the landing site with darkness approaching & low supply of fuel, the plt performed a precautionary landing on a soft dirt road. During the landing roll the acft nosed over & came to rest. The plt did not file an acc…Jan 20, 1988 · N36534 · Substantial damageNTSB LAX88LA092Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Lakeport, CADuring ldg rollout the acft veered off the rwy, went into a ditch & collided with terrain causing substantial damage. The surface winds were estimated at only 5 KTS. The plt acknowledged that the accident might have been prevented if he had been less…Jan 20, 1988 · N9416E · Substantial damageNTSB FTW88LA075Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS-355-F1 · Grand Prairie, TXThe acdt occurred on the 2nd flt of transition trng for an experienced helicopter plt. The trng on this flt included sim tail rotor failure run-on landings. The CFI demonstrated 2 landings and the trainee took the controls for the 3rd. The landings were being…Jan 20, 1988 · N5800F · Substantial damageNTSB DEN88LA056Accident · No injuriesLimited investigationFinal reportCessna 150M · Delta, UTDuring the landing roll, the acft swerved to the right into a snowbank and nosed over. The plt said he found snow packed between the landing gear wheel and wheel pants restricting the wheel from rotating. In his recommendation for prevention, the plt stated…Jan 20, 1988 · N6372K · Substantial damageNTSB LAX88LA096Accident · No injuriesLimited investigationFinal reportCessna 402C · Prescott, AZJan 18, 1988 · N6842Q · Substantial damageNTSB FTW88LA167Accident · Serious injuriesLimited investigationFinal reportAdams A-60 · Austin, TXThe balloon was deflated by the passenger when he pulled the crown line. Contributing to this was the pilot's poor judgement in relinquishing the line to the passenger.Jan 18, 1988 · N9811N · No damageNTSB MIA88LA087Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Tampa, FLDuring the landing roll the acft veered off the rwy, travelled through a retention pond, nosed over & came to rest. According to a plt who landed shortly after the accident, he had his hands full landing on the same rwy due to a 'stiff crosswind'. The pilot…Jan 16, 1988 · N5244N · Substantial damageNTSB CHI88LA049Accident · No injuriesLimited investigationFinal reportCessna 172L · Buffalo, MNJan 16, 1988 · N7895G · Substantial damageNTSB LAX88LA086Accident · No injuriesLimited investigationFinal reportCessna 195 · Sonoma, CADuring a local pilot check flight, upon touchdown, a loud bang was heard. The acft gradually veered to the right then ground looped. A local mechanic was unable to identify a failure. The plt reported that the brakes were operating normally prior to and…Jan 14, 1988 · CGADA · Substantial damageNTSB LAX88LA084Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Blythe, CAA Cessna T210L was found abandoned with the landing gear collapsed. Skid marks were noted on the ground where the aircraft had touched down on the rough terrain. The pilot was never identified and traces of illegal contraband were found in the aircraft.Jan 13, 1988 · N2516S · Substantial damageNTSB ANC88LA024Accident · No injuriesLimited investigationFinal reportCessna 150D · Chugiak, AKThe flight instructor stated the student landed back on the runway after a practice engine failure; at that point the flight instructor realized how slick the runway was and the aircraft exited the departure end of the runway into a snow bank.Jan 13, 1988 · N4379U · Substantial damage