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 MKC85LA049Accident · No injuriesLimited investigationFinal reportCessna 150A · Independence, MOPlt made two go-arounds because the acft was blown to the left of the rwy. Acft touched on third attempt, veered to the left and contacted a snowbank.Jan 13, 1985 · N7025X · Substantial damageNTSB LAX85LA110Accident · Minor injuriesLimited investigationFinal reportWaco YKC · Placerville, CAAcft was lined up on rwy but plt misjudged height and acft stalled aprx 3 ft above the ground. Acft bounced and upon contacting the ground veered right. Plt over compensated and acft ground looped traveling off left side of rwy into a road. The pond is aprx…Jan 13, 1985 · N14000 · Substantial damageNTSB LAX85LA108Accident · No injuriesLimited investigationFinal reportCessna T210L · San Jose, CADuring first leg of the flight, plt discovered that landing gear would not extend. Pressurizing 'down side' with emergency hand pump allowed normal operation of the landing gear. On return flt to San Jose, plt tried to extend the gear but system would not…Jan 12, 1985 · N4691Q · Substantial damageNTSB CHI85LA085Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Wheeling, ILThe low time pilot with six POB was ld at dark night light saw showers and icy patches on runway during rollout the acft entered a skid with nose cocked to the left the left main gear failed outboard and the acft exited the left side of the rwy the left wing…Jan 10, 1985 · N83187 · Substantial damageNTSB BFO85FA012Accident · Minor injuriesField investigationFinal reportRockwell Sabreliner/NA265-40 · Glen Burnie, MDWhile on short final the acft was obsvd to nose down into the displaced threshold of rwy 33L. The coplt stated that he sensed that he was getting slow and went to add pwr with his left hand. He was sitting for the first time in the left seat and although he…Jan 9, 1985 · N1863T · Substantial damageNTSB MKC85LA046Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Des Moines, IAPlt was informed of holes along the right side of the rwy so he intentionally touched own on the left side of the rwy. The left main gear contacted a snowbank which paralled the rwy and the acft nosed into the snowbank.Jan 8, 1985 · N68318 · Substantial damageNTSB MKC85LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Olathe, KSPilot said acft swerved to right during landing roll. Acft ran off right side of rwy into snow covered area resulting indamage to wing & gear. No evidence of aircraft malfunction was found after the accident.Jan 6, 1985 · N84499 · Substantial damageNTSB MIA85LA075Accident · No injuriesLimited investigationFinal reportCessna 152 · Wesley Chapel, FLThe student plt flying N94560 was making her 1st solo touch and go landing when control of the acft was lost. Upon touchdown, N94560 veered left, departed the rwy and collided with N3854D which was being taxied on the grass aprx 20 ft from the rwy.Jan 6, 1985 · N94560 · 2 aircraft · Substantial damageNTSB FTW85LA093Accident · No injuriesLimited investigationFinal reportCessna 310 · Corpus Christi, TXPlt rptd loss of pwr on left eng during flare; directional control was lost & acft went off side of the rwy. Left gear collapsed and acft rcvd substantial damage. Engines were run after acct. Reason for rptd loss of pwr undet. Acfts radio inop. Plts seat back…Jan 6, 1985 · N5301A · Substantial damageNTSB MIA85LA072Accident · Serious injuriesLimited investigationFinal reportRaven S-60A · Pompano Beach, FLThe balloon envelope struck a palm tree and a building while landing. The basket turned over when it contacted the ground. A passenger was injured when another passenger fell on her as the basket turned over.Jan 5, 1985 · N4270A · Minor damageNTSB FTW85LA092Accident · No injuriesLimited investigationFinal reportGates Learjet 25B · Oklahoma City, OKThe plt-in-command (PIC) reported that after touchdown, the spoilers & brakes were applied, but no braking action was felt although peddle pressure was evident. He stated that by the time it was clear that the brakes were ineffective,insufficient rwy remained…Jan 5, 1985 · N55PT · Substantial damageNTSB LAX85LA096Accident · No injuriesLimited investigationFinal reportCessna 172RG · Camarillo, CAThe plt reported that upon landing a strong gust of wind caused the acft to deviate to the left. Application of the appropriate flight controls did not arrest the deviation. Brakes were applied but not in time to prevent the acft from exiting the rwy. The…Jan 4, 1985 · N5194U · Substantial damageNTSB ANC85LA032Accident · No injuriesLimited investigationFinal reportCessna 207A · Nuiqsut, AKAfter a night landing by the copilot, and after the first bounce, the pilot in command took control of the aircraft after it developed a high sink rate. The pilot then ground looped the aircraft.Jan 4, 1985 · N9237M · Substantial damageNTSB CHI85LA083Accident · No injuriesLimited investigationFinal reportCessna 172M · Mt Sterling, ILThe plt landed long at his home arpt using no flaps with a prevailing tailwind. The 2600 ft turf strip was frozen. During braking the acft skidded off the rwy and struck a snow berm before rolling inverted.Jan 2, 1985 · N9484H · Substantial damageNTSB DEN85LA054Accident · No injuriesLimited investigationFinal reportCessna 180 · Marion, MTThe acft nosed over onto its back after the plt landed in snow 6 to 8 inches in depth.Jan 1, 1985 · N966K · Substantial damageNTSB MIA85LA068Accident · Serious injuriesLimited investigationFinal reportSchweizer 2-33A · Orlando, FLThe acft was flared for landing about 1/2 way down the rwy at excessive airspeed. The plt stated that as the acft touched down, it bounced into the air and impacted trees at 10-15 ft AGL. The spoilers were found in a retracted position after the accident.…Dec 29, 1984 · N1229S · Substantial damageNTSB DEN85LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Fargo, NDAccording to the solo student plt, the landing was made in a snow filled ditch aprx 5 ft right of the rwy. The nose gear collapsed and the acft nosed over. The plt and his CFI stated that rwy markings were inadequate.Dec 29, 1984 · N48738 · Substantial damageNTSB LAX85FA091Accident · 1 fatalField investigationFinal reportBell 47G3B · San Diego, CAThe helicopter landed on the morred tuna boat. After toudhdown the helicopter appeared to be repositioning itself when the main rotor blades contacted the boom portion of a crane which was being utilized to load bags of salt aboard the boat.Dec 28, 1984 · N474MP · Substantial damageNTSB NYC85LA050Accident · No injuriesLimited investigationFinal reportBeech P35 · Morrisville, VTPlt noted accumulation of rime ice in flt. On NDB approach, VFR conditions reached about 7 miles from runway, IFR flt plan cancelled and straight-in visual approach performed. Crossing threshold at about 2O ft AGL, plt reduced throttle and acft immediately…Dec 27, 1984 · N1DL · Substantial damageNTSB MIA85FA067Accident · Serious injuriesField investigationFinal reportLounsbery Taylor/COOT-A · Punta Gorda, FLThe acft was landed hard, according to witnesses, after completion of the first takeoff and flt around the traffic pattern. The plt shut off the eng, exited the acft & inspected for damage. He then restarted the eng and took off again. The plt stated after…Dec 27, 1984 · N24GL · DestroyedNTSB CHI85LA080Accident · No injuriesLimited investigationFinal reportPiper Aerostar 600 · Kalamazoo, MIThe plt reported upon touchdown, the acft contacted a patch of ice causing it to slide sideways resulting in a left main gear collapse. ATC twr witnesses stated the acft appeared fast on final and a hard landing was made.Dec 27, 1984 · N8060J · Substantial damageNTSB NYC85LA049Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Marlboro, NJThe acft landed hard on runway 27 at Marlboro airport while on a solo flight. The aircraft was substantially damaged andthe student pilot received minor injuries. The pilot had a total of 47 flight hours all of which were in the same make and model aircraft.…Dec 26, 1984 · N3968K · Substantial damageNTSB FTW85LA085Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · San Antonio, TXThe plt attempted to extend the landing gear but failed to complete the landing checklist by insuring that the gear were down and locked. The acft landed gear up causing a small post crash fire. The plt had been requested to keep his speed up during the apch.…Dec 24, 1984 · N4826J · Substantial damageNTSB CHI85LA082Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Flint, MIDuring a flt in IFR conditions the acft encountered icing. The ice was still on the wings and tail when the acft prepared to land. Extra airspeed was carried on final approach. The acft ballooned as it flared for touchdown. It then stalled and made a hard…Dec 24, 1984 · N300EP · Substantial damageNTSB MIA85LA062Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Naples, FLAfter making a three point landing on the paved runway the pilot lost control of the acft, it veered left and ran off the rwy. The acft then struck a mound of sandy soil and nosed over.Dec 23, 1984 · N14JV · Substantial damageNTSB LAX85LA095Accident · No injuriesLimited investigationFinal reportPitts Special SST · Palo Alto, CADuring 3 previous touch & go landings the plt noticed a slight tendency for the acft to turn rt during the landing roll roll. He decided to make a full stop landing. During the landing the plt allowed the acft roll onto the runway shoulder. He said he was…Dec 23, 1984 · N272H · Substantial damageNTSB BFO85LA010Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Newburg, MDDuring ldg roll the PIC felt a vibration as the tailwheel contacted the rwy. In an effort to minimize the vibration the plt lifted the tailwheel off the rwy. The acft began to ground loop to the right toward a pole. Heavy application of the wheel brakes…Dec 23, 1984 · N836B · Substantial damageNTSB LAX85LA079Accident · No injuriesLimited investigationFinal reportBell 47G · Chatsworth, CAThe plt was practicing off airport touch & go's. on the second lndg the left skid contacted a hidden dirt embankment andthe acft rolled over. A post impact fire consumed the aircraft. Both certificated commercial plts aboard the helicopter escaped unharmed.…Dec 22, 1984 · N182JR · DestroyedNTSB NYC85LA046Accident · No injuriesLimited investigationFinal reportCessna 140 · Burlington, VTThe acft skidded & veered left during the landing roll, & subsequently, it nosed over on the rwy.Dec 21, 1984 · N77110 · Substantial damageNTSB CHI85IA073Incident · No injuriesIncident investigationFinal reportBeech 58P · Akron, OHDuring arrival at medina, OH, the plt discovered that the NDB was inop, so he diverted to the Akron fulton arpt. He was vectored for a localizer apch to rwy 25. During the apch, he descended to the min descent alt (mda) of 512 ft AGL. When he had the arpt in…Dec 21, 1984 · N25RL · Minor damageNTSB LAX85LA061Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Garberville, CAThe plt reported that on his first attempt to land he was 'too high' so he made a go-around. On the second apch to the 3050 ft rwy, he was flying at 110 mph. He landed long, applied brakes & skidded off the dept end of the rwy. The lt tire blew-out,…Dec 20, 1984 · N8780Y · Substantial damageNTSB NYC85LA045Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Stow, MAPlt stated that after a normal crosswind touchdown, the tail section did not drop as expected, but rose and veered left. Acft swerved and flipped inverted.Dec 18, 1984 · N14315 · Substantial damageNTSB ATL85LA059Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA341G · Cornelius, NCWith the executive vice president of the company acting as PIC and the company plt acting as co-plt, the acft approcahed the operator's slightly elevated helipad. According to pax statements, the acft landed hard, bounced into the air and began spinning…Dec 18, 1984 · N49534 · Substantial damageNTSB CHI85LA071Accident · No injuriesLimited investigationFinal reportCessna 182K · Lincoln, ILThe plt lost directional control during the landing roll. The acft veered to the right, rolled through 60 ft of sod, struck a dead furrow & nosed up. Winds were from 230 degrees at 13 KTS. The plt stated he should have used more rudder for cross wind…Dec 17, 1984 · N2776Q · Substantial damageNTSB LAX85LA077Accident · No injuriesLimited investigationFinal reportCessna 177RG · Santa Maria, CAAfter touchdown on a touch-and-go lndg, acft veered left and left wing came up, raising left wheel off ground. Plt corrected with aileron and added power for go-around but acft was off runway and traversing soft terrain; lift-off speed was not attained and…Dec 15, 1984 · N34992 · Substantial damageNTSB DEN85LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Nucla, COAccording to the plt, after landing on centerline brakes were applied and ice on the rwy caused the acft to veer left. An abort was initiated but realizing that the acft was going off the side of the rwy the plt secured the eng. The nose gear collapsed as the…Dec 15, 1984 · N2193Y · Substantial damageNTSB MKC85LA055Accident · No injuriesLimited investigationFinal reportBeech 300 · Hutchinson, KSOn late final, the plt under instruction reduced pwr sharply to correct a slightly high approach, advancing the propeller controls to full increase. The combination of power reduction and increased profile drag on the propellers was excessive for the desired…Dec 14, 1984 · N6823M · Substantial damageNTSB DEN85LA042Accident · No injuriesLimited investigationFinal reportHughes 369D · Springville, UTThe acft was being positioned at a remote site for a passenger pick-up. During the maneuvering to get into a good spot for landing the plt lost visual reference because of blowing snow. The plt said he felt the right skid hit the ground and lowered collective…Dec 13, 1984 · N58220 · Substantial damageNTSB SEA85LA029Accident · No injuriesLimited investigationFinal reportCessna 172M · Sultan, WAAn overrun occurred on the 2,000 foot airstrip due to excess approach and landing speed. A light coating of snow was present on the grass runway and the pilot neglected to raise the flaps adding to a longer landing roll and making braking less effective. A 5…Dec 10, 1984 · N4436R · Substantial damageNTSB NYC85LA040Accident · No injuriesLimited investigationFinal reportBeech 58TC · Norwood, MATouchdown made 1/3 the way down the wet rwy. Brakes were ineffective on wet pavement. Plt raised flaps and reapplied brakes with no positive result. Acft continued onto 60 ft overrun area where some braking action was effective however, acft continued down an…Dec 10, 1984 · N2164L · Substantial damageNTSB MIA85LA055Accident · No injuriesLimited investigationFinal reportCessna 150F · Fort Myers, FLThe plt was practicing touch and go landings. On the accident landing the acft drifted to the rt of the rwy and touched down with a side angle. The plt said the acft ballooned and he applied power to go around but thought he did not have the proper control so…Dec 9, 1984 · N8600S · Substantial damageNTSB LAX85LA064Accident · No injuriesLimited investigationFinal reportBeech B-60 · Van Nuys, CADuring landing roll out the plt observed the acft's nose gear begin to collapse. Although on approach the plt had placed the ldg gear selector in the down position & had observed the illumination of the green gear down lights, the plt responded to the…Dec 9, 1984 · N6023S · Substantial damageNTSB CHI85LA065Accident · No injuriesLimited investigationFinal reportCessna 150C · Hampshire, ILTouchdown occurred nearly half-way down airstrip, which was wet with melting frost. Plt did not attempt a go-around, but relied on braking action for safe completion of landing roll. Braking action was nil. Acft overran through a barbed-wire fence and into a…Dec 9, 1984 · N7954Z · Substantial damageNTSB ATL85LA051Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Fremont, NCThe student plt reported that he landed hard & bounced twice before settling to the rwy. He applied full braking & the acft skidded off the end of the rwy.Dec 9, 1984 · N74636 · Substantial damageNTSB MKC85FA032Accident · No injuriesField investigationFinal reportSwearingen SA226TC · Harrison, ARThe acft was being operated as skyways flt 488. The first officer was flying the acft. The acft touched down on the rwy aprx 1584 feet from the approach end and after a short roll, the landing gear warning horn sounded and the left wing settled to the ground.…Dec 7, 1984 · N511SS · Substantial damageNTSB NYC85LA038Accident · No injuriesLimited investigationFinal reportGulfstream 690B · Millinocket, MEPlt stated that after touchdown, acft began a left drift. As plt applied corrective input, he noted the left wheel was in a snow windrow, so additional input was made to break wheel free of window. Left wheel crossed windrow as acft swerved right but plt was…Dec 6, 1984 · N699GN · Substantial damageNTSB LAX85LA060Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Chino, CAWhen the plt received ldg instructions the wind was reported as being calm. During ldg flare on rwy 26, at 2 ft AGL, a gust was encountered. The gust was from the acft's 7 o'clock position & the plt was unable to maintain control of the acft. He stated that…Dec 6, 1984 · N426C · Substantial damageNTSB FTW85LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKAfter touchdown flaps were raised and power added to takeoff during the touch-&-go landing. The solo student pilot was unable to maintain birectional control of the acft and it went off the left side of the asphalt rwy. The acft nosed overafter colliding with…Dec 6, 1984 · N25890 · Substantial damageNTSB FTW85LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Houston, TXShortly after touchdown on a full stop landing directional control was lost and the acft went off the left side of the 5,000 x 100 ft rwy. The aircraft collided with and came to rest in a ditch on the north side of the runway. Winds were northeasterly at 10…Dec 3, 1984 · N6114Q · Substantial damageNTSB NYC85LA036Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Meriden, CTWhile in cruise, plt heard an abnormal sound from the left side of the engine compartment and having had previous problems with the newly-installed engine, elected to make a precautionary landing at a nearby arpt to investigate. Plt stated he landed long and…Dec 2, 1984 · N7453P · Substantial damage