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 DCA84AA018Accident · Serious injuriesFinal reportMcdonnell Douglas DC-10-30 · Jamaica, NYDuring an ILS apch to rwy 4R with a tailwind, the acft (scandinavian flt 901) was being flown by the coplt. The acft was fast on final apch & was landed aprx 4700 ft beyond the apch end of the rwy at 36 KTS above the programmed touchdown speed. The aircrew…Feb 28, 1984 · LNRKB · Substantial damageNTSB CHI84FA121Accident · 1 fatalField investigationFinal reportBeech A36 · Wheeling, ILA go-around was initiated about midfield at what one witness estimated as 6 in above the rwy. The acft was between 20 and 50 ft above the trees when it rolled into a steep right angle of bank with the nose dropping simultaneously. Post crash fire destroyed…Feb 28, 1984 · N24187 · DestroyedNTSB SEA84LA062Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Pullman, WAAccording to the student plt, the winds were prevailing from the southeast at 5 to 10 KTS, but were shifting & gusting to 20 KTS. During a landing on rwy 5, the acft veered off the right side side of the rwy, then struck a ditch & nosed over.Feb 27, 1984 · N996MP · Substantial damageNTSB MKC84LA086Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Jefferson City, MOThe acft drifted left due to a crosswind during landing. The drift put the acft into snow which had been plowed along the rwy side. The collision pulled the acft off the rwy.Feb 27, 1984 · N7734C · Substantial damageNTSB LAX84LA202Accident · No injuriesLimited investigationFinal reportCessna 152 · Emigrant Gap, CAThe student & instructor plt (CFI) were on a dual x-country flt. They proceeded to fly to an unattended arpt at Emigrant Gap, CA, which was at an elevation of 5284 ft. after arriving, they circled the arpt & made a low pass over the rwy. They saw tracks on…Feb 27, 1984 · N25592 · Substantial damageNTSB LAX84LA198Accident · No injuriesLimited investigationFinal reportCessna 152 · Fair Oaks, CAThe student plt was on her second supervised solo. She reported that 'on her third landing, she misjudged the distance and undershot the runway.'Feb 27, 1984 · N24470 · Substantial damageNTSB ATL84LA110Accident · No injuriesLimited investigationFinal reportCessna 337B · Athens, TNThe acft caught fire during landing when a gasoline can overturned and was ignited by a passenger trying to right it with a burning cigar in his hand.Feb 26, 1984 · N2406S · DestroyedNTSB MKC84LA085Accident · No injuriesLimited investigationFinal reportCessna 150L · Ft Riley, KSThe student plt stated he landed hard, bounced and impacted the rwy again, collapsing the nose gear.Feb 25, 1984 · N10144 · Substantial damageNTSB MIA84LA124Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Cedar Key, FLDuring the 1st landing, the acft touched down at night, aprx half way down the rwy. The plt eleected to go around, then made a 2nd apch & landing. During the 2nd landing, the acft went off the end of the rwy & came to rest in water. The plt stated that…Feb 25, 1984 · N4869F · Substantial damageNTSB MIA84LA094Accident · Minor injuriesLimited investigationFinal reportCessna 182G · Brandon, FLThe acft had been parked for about 2 mos with a partial fuel load. Prior to departure, 40 gal of auto fuel was added & both wing tank sumps & the gascolator were drained with only a minimal amount of water found. Shortly after takeoff, the eng lost power.…Feb 25, 1984 · N7388S · Substantial damageNTSB FTW84LA148Accident · No injuriesLimited investigationFinal reportCessna 140 · Longview, TXThe plt landed in an rough surface overrun area marked by painted tires as unusable. The right main gear collapsed after touchdown and the acft slid to a stop. The plt said he did not see the tires marking the overrun until after the accident.Feb 25, 1984 · N2491N · Substantial damageNTSB DEN84FA102Accident · 1 fatalField investigationFinal reportBell 206B-III · Coalville, UTThe helicopter was equipped with 'bear paws'. Snowshoe-like devices on the skids to distribute weight on soft surfaces. The bear paws on this acft rotated freely around the skids, not tightened down as per design spec. Also, bear paws are not approved for…Feb 25, 1984 · N16803 · DestroyedNTSB LAX84LA196Accident · No injuriesLimited investigationFinal reportRockwell 112A · Yucca Valley, CAUpon arrival at the uncontrolled arpt, neither the instructor (CFI) nor the student observed the arpt's wind sock. The acft was observed to touch down midway down the rwy & bounce once during the landing. As the acft neared the end of the rwy, the CFI…Feb 24, 1984 · N1318J · Substantial damageNTSB FTW84LA147Accident · No injuriesLimited investigationFinal reportCessna 152 · Harrah, OKThe plt landed at higher than normal speed, with initial contact about 400 ft down the runway. He stated that the acft was 'sailing' and attempts to decelerate were 'ineffective'. The nose gear collapsed when the acft hit in the middle road on the north end…Feb 24, 1984 · N65575 · Substantial damageNTSB CHI84LA117Accident · Minor injuriesLimited investigationFinal reportCessna T-210N · Troy, MIThe acft landed in soft grassy terrain alongside rwy 27, when the acft nosed over the nose gear collapsed. The plt was not aligned properly because the north side of the rwy lights were not operating and were notamed as being out of service since 2/19/84.Feb 24, 1984 · N9483Y · Substantial damageNTSB SEA84LA059Accident · No injuriesLimited investigationFinal reportCessna 172RGII · Grangeville, IDThe acft ground looped during landing on an icy rwy and nosed over after leaving the rwy. The landing was made with a right quartering tailwind.Feb 22, 1984 · N6522R · Substantial damageNTSB FTW84LA149Accident · No injuriesLimited investigationFinal reportCessna 150M · Boy'S Ranch, TXThe student plt was attempting to land on a freshly graded road. Shortly after touchdown the nose wheel hit a large rock and sheared off.Feb 22, 1984 · N150N · Substantial damageNTSB DEN84LA097Accident · No injuriesLimited investigationFinal reportSwearingen SA26AT · Ruidoso, NMThe acft landed with the gear retracted. The plt reported that 'due to moderate low level turbulence, the landing gear handle did not reach the full down position.' He stated that his passenger was sick due to turbulence.Feb 22, 1984 · N17JJ · Substantial damageNTSB CHI84LA304Accident · No injuriesLimited investigationFinal reportCessna 152 · South Branch, MIThe student plt was on a solo x-country flt. He reported that when he landed, the acft bounced twice. After the 2nd bounce, the nose gear collapsed & the acft nosed over. The plt reported that the grass strip was rough & not well maintained & that the ground…Feb 22, 1984 · N757TH · Substantial damageNTSB CHI84LA115Accident · No injuriesLimited investigationFinal reportCessna 152 · Milwaukee, WIThe student plt stated that the acft bounced on the first touchdown and then contacted the rwy with the nose gear. Afterthe nose gear collapsed the acft nosed over.Feb 22, 1984 · N5355P · Substantial damageNTSB ANC84MA037Accident · No injuriesMajor investigationFinal reportEmbraer EM-110P1 · Cordova, AKDuring a landing at night, the acft touched down slightly left of the rwy centerline, which was not visible, & began veering to the left. The plt reported that the acft did not respond to rudder inputs, rudder tiller inputs or differential reverse thrust. It…Feb 22, 1984 · N103VA · Substantial damageNTSB LAX84LA190Accident · No injuriesLimited investigationFinal reportMooney M20C · Scottsdale, AZThe plt reported that he failed to extend the landing gear prior to touchdown. Subsequently, the acft was damaged during a wheels up landing.Feb 21, 1984 · N6518U · Substantial damageNTSB NYC84LA095Accident · No injuriesLimited investigationFinal reportCessna 182RG · Teterboro, NJAccording to the plt after about an hour and 10 min flight he returned for landing. During the landing roll the acft skidded off the rwy onto soft dirt damaging the propeller and right wing tip.Feb 20, 1984 · N3714C · Substantial damageNTSB NYC84LA088Accident · No injuriesLimited investigationFinal reportCessna 152 · Clarksville, MDAccording to the plt the acft ballooned during the landing flare. In an effort to recover the plt added power and pushed the nose down. The front strut hit the ground and broke, then the acft bounced and during the second landing the propeller struck the…Feb 20, 1984 · N757NS · Substantial damageNTSB MKC84LA080Accident · No injuriesLimited investigationFinal reportCessna 150M · Norton, KSThe solo student landed in a light crosswind on a rwy with patches of snow and ice. The acft slid sideways after bouncing and collided with a snowbank.Feb 20, 1984 · N714CH · Substantial damageNTSB MKC84LA079Accident · No injuriesLimited investigationFinal reportCessna 152 · Independence, MOThe acft made a steep approach with full flaps, hit hard, bounced and came down on the nose wheel. The nose wheel collapsed and the acft flipped over. The plt stated that he did not start the landing flare soon enough.Feb 20, 1984 · N25756 · Substantial damageNTSB LAX84LA186Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Crescent City, CAThe acft landed 1000 ft down the wet rwy and continued off tend of the rwy before hitting a 18 inch dirt bank. The landing gear collapsed. The plt reported that the braking action was 'poor'.Feb 20, 1984 · N4636S · Substantial damageNTSB MKC84LA093Accident · No injuriesLimited investigationFinal reportCessna 206 · Pine Bluff, ARThe acft ran off the rwy and into a ditch during landing. After the accident it was found that the nose wheel steering needed rebushing and the nosewheel damper was also in need of repair for safe operation of the acft.Feb 19, 1984 · N5026U · Substantial damageNTSB LAX84LA191Accident · No injuriesLimited investigationFinal reportCessna 180A · Truckee, CAPrior to takeoff, the plt had to push the acft out of mud where the right landing gear had sunk into the ground. He took off and flew for 1/2 an hour. The plt reported that during the landing, the right brake seemed to be frozen and the acft swerved to the…Feb 19, 1984 · N9764B · Substantial damageNTSB SEA84LA057Accident · No injuriesLimited investigationFinal reportCessna 172N · Roseburg, ORThe acft drifted left during the student pilots landing and collided with VASI lights. After the collision the acft nosed over. The CFI on the ground said the wind shifted just prior to the last landing.Feb 18, 1984 · N733VX · Substantial damageNTSB NYC84FA089Accident · No injuriesField investigationFinal reportCessna 401A · Linden, NJThe main landing gear collapsed after landing. A CFI awaiting takeoff said that the approach and touchdown were normal with the gear down. As the acft rolled the left main gear collapsed and the acft gradually left the rwy and became miredin mud. Inspection…Feb 18, 1984 · N6252Q · Substantial damageNTSB MIA84LA153Accident · No injuriesLimited investigationFinal reportCessna 172 · Daytona Beach, FLThe plt reported that when he arrived at the arpt to land, the wind was from 330 deg gusting to about 15 to 17 KTS. On final apch to land on rwy 27L, he decided to slip the acft & use a faster than normal speed to compensate for the wind & extra weight of the…Feb 18, 1984 · N738SN · Substantial damageNTSB MIA84LA087Accident · No injuriesLimited investigationFinal reportBeech B-58 · Tallahassee, FLThe acft landed with the right main gear & nose gear stuck in the retracted position, with the left main gear stuck in the extended position. Investigation revealed that the landing gear actuating rod had failed.Feb 18, 1984 · N21BR · Substantial damageNTSB MIA84LA085Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · St Augustine, FLThe acft landed with its left main gear jammed in the up position. Since the landing gear warning and indicating system indicated all normal the crew was unaware of the problem until the roll out. Investigation revealed that the left main gear actuating motor…Feb 17, 1984 · N1767W · Substantial damageNTSB DEN84LA092Accident · No injuriesLimited investigationFinal reportCessna T-210 · Duchesne, UTThe acft departed the side of the rwy during the landing roll. The plt stated that he could no determine where the center of the rwy was due to about 2 inches of fresh snow. The rt landing gear collapsed & the nose gear failed.Feb 17, 1984 · N6479N · Substantial damageNTSB ATL84LKG04Accident · Serious injuriesFinal reportCessna 177B · Kennesaw, GAThe acft bounced during landing and when it started to veer off the rwy the plt attempted a go-around. The acft collidedwith trees and came to rest in a small ditch.Feb 17, 1984 · N34627 · DestroyedNTSB ATL84LA103Accident · No injuriesLimited investigationFinal reportBeech 19A · Mayersville, MSThe plt circled the airstrip prior to landing and believed the landing area in suitable condition. During the landing right main landing gear mired in a soft spot and the landing gear collapsed.Feb 17, 1984 · N5081T · Substantial damageNTSB LAX84LA182Accident · No injuriesLimited investigationFinal reportCessna 172M · Barbers Point, HIThe acft was observed to land nose first, collapsing the nosewheel and sustaining subst damage. Investigation revealed that the acft was stalled from an altitude of 20 to 30 ft AGL.Feb 16, 1984 · N5160R · Substantial damageNTSB CHI84IA111Incident · No injuriesIncident investigationFinal reportSwearingen SA-26AT · Indianapolis, INThe plt was on a local flt to check the aileron rigging after maintenance had been performed on it. After taking off, he remained in the traffic pattern. On downwind, after extending the landing gear, he noted an unsafe right main gear indication. The plt…Feb 16, 1984 · N175P · Minor damageNTSB ATL84FKG02Accident · No injuriesFinal reportPiper PA-60 · Atlanta, GAWhile on final approach the plt noted an unsafe nose gear indication. Tower personnel were unable to determine gear position during a fly-by. During landing touchdown the nose gear collapsed. Investigation revealed the acft had a brokenbolt in the nose gear…Feb 16, 1984 · N6070D · Substantial damageNTSB MKC84LA082Accident · No injuriesLimited investigationFinal reportMooney MK20B · Pocahontas, ARThe acft landing gear retracted during landing. The plt reported that the manually activated gear handle popped out of the gear down position during the landing roll. The plt indicated that he thought the gear handle was positively in the down lock position.Feb 15, 1984 · N74515 · Substantial damageNTSB FTW84LA134Accident · No injuriesLimited investigationFinal reportCessna 152 · Stillwater, OKDuring landing the nose gear of the acft collapsed. The plt reported that the nose gear started to shimmy after landing and he pulled the stick back to raise the nose gear. When the gear contacted the rwy again it collapsed. Examination of the wreckage showed…Feb 15, 1984 · N6202M · Substantial damageNTSB ATL84LKG03Accident · No injuriesFinal reportCessna 152 · Albertville, ALThe acft ran off the left side of the rwy during landing and nosed over. The student plt said he was practicing touch and go landings solo and lost control of the acft.Feb 15, 1984 · N6418B · Substantial damageNTSB MKC84LA075Accident · No injuriesLimited investigationFinal reportCessna 172P · Springfield, MOThe student plt was on the final leg of a x-country flt. While landing with a gusty x-wind, the acft veered off the rwy, encountered soft terrain & nosed over.Feb 14, 1984 · N55277 · Substantial damageNTSB MKC84LA074Accident · Minor injuriesLimited investigationFinal reportPiper PA-20 · Boonville, MOThe acft nosed over after landing. The plt said that the arpt manager told him that 'there is a valley that funnels the wind and has blown other acft the same way'. The plt said the only way to avoid this condition is to land farther down the rwy.Feb 13, 1984 · N4944M · Substantial damageNTSB MKC84LA073Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Lawrence, KSThe dual student allowed the acft to porpoise & yaw and lost control of the acft as it veered into a ditch. The CFI on board tried to correct the situation with rudder and throttle but was unsucessful in the attempt.Feb 13, 1984 · N83032 · Substantial damageNTSB ATL84LA098Accident · No injuriesLimited investigationFinal reportCessna C-303 · Hickory, NCThe acft overran the rwy and collided with a fence during a night landing. The flt was hampered by an inoperative heaterand a dome light that could not be turned off. The rwy suggested for use was short with a decommissioned VASI system. The plt said she…Feb 13, 1984 · N9457C · Substantial damageNTSB NYC84LA070Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Mt. Pleasant, PAThe plt flew to greensburg, where he brought the helicopter to a 2 ft hover and departed with a max performance climb. He stated the helicopter began to exhibit control irregularities which he described as 'a dutch roll wobble type of shuffle.' He continued…Feb 12, 1984 · N2273U · Substantial damageNTSB LAX84LA175Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Chino, CAThe acft groundlooped and ran off the side of the rwy during landing.Feb 12, 1984 · N3151Z · Substantial damageNTSB DEN84LA096Accident · Serious injuriesLimited investigationFinal reportRaven Rally RX7 · Albuquerque, NMThe student plt aboard the balloon suffered a broken leg during a landing. She had been briefed on the proper stance forlanding and the instructor thought she was in the proper position but later found out that the students left leg was broken above the…Feb 12, 1984 · N40995 · No damage