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 FTW84LA117Accident · No injuriesLimited investigationFinal reportCessna 120 · Jayton, TXThe acft nosed over during landing. The plt said he was trying to correct a veer in the tail wheel acft and may have inadvertantly used the right brake.Jan 12, 1984 · N3014N · Substantial damageNTSB LAX84LA139Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Montague, CAThe acft veered off the rwy and nosed over during landing. The plt acknowledged that there was no wind and the acft was 'flying ok.' He said he just lost control and ground looped.Jan 11, 1984 · N35131 · Substantial damageNTSB FTW84LA112Accident · No injuriesLimited investigationFinal reportBeech 65-90 · Okemah, OKThe plt landed long on a turf rwy with standing water on the approach end. The plt was unable to stop on the rwy and was also unsuccessful in groundlooping to avoid hitting trees off the end of the rwy.Jan 10, 1984 · N85NL · Substantial damageNTSB DEN84LA072Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Angel Fire, NMAfter making a x-country flt from Oklahoma city, ok to Angel Fire, NM, the plt landed on a snow covered rwy at an elevation of 8382 ft. during the landing, the acft bounced, drifted to the left side of the rwy, then hit a 3-1/2 ft snowbank. The plt reported…Jan 10, 1984 · N93656 · Substantial damageNTSB DEN84LA068Accident · No injuriesLimited investigationFinal reportCessna 172 · Custer, SDThe acft collided with a snow berm during landing and nosed over. The plt said they were hit by a wind shear crosswind from a valley 90 degrees to the rwy.Jan 9, 1984 · N64253 · Substantial damageNTSB MKC84LA059Accident · No injuriesLimited investigationFinal reportCessna 172M · Elkader, IAThe acft nosed over during landing on a snow-covered rwy after striking a snow drift. The plt said he did not see any tracks in the snow covered rwy but since there was no NOTAM closing the arpt he went ahead with a soft field landing. He said the snow…Jan 8, 1984 · N73043 · Substantial damageNTSB SEA84IA037Incident · No injuriesIncident investigationFinal reportBoeing 727-223 · Seattle, WAThe capt stated that upon visual contact with the rwy, the acft was displaced slightly to the lt & he corrected toward centerline with rt rudder. Wing tip contact was neither heard not felt in the cockpit. There were several concurrent reports of arriving…Jan 7, 1984 · N876AA · Minor damageNTSB FTW84LA110Accident · No injuriesLimited investigationFinal reportCessna 182 · Mcallen, TXXb-cph, a foreign registered acft, was observed by the tower operator, to dive toward the rwy & pull up before starting to porpoise. The acft subsequently impacted the rwy striking the propeller & causing substantial airframe damage. Efforts to locate the plt…Jan 7, 1984 · XBCPH · Substantial damageNTSB CHI84LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Waverly, OHWhile landing on a 2000 ft rwy at Waverly, OH, the brakes were not effective, so the plt elected to go-around. During the go-around, the acft hit a fence at the end of the rwy. The plt continued flt to the ross county arpt & landed. An exam of the brakes…Jan 7, 1984 · N4953F · Substantial damageNTSB CHI84LA078Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Holland, MIThe acft contacted a snowbank during landing. After the collision the acft nosed over. The plt stated that the winds forced the acft off the centerline of the rwy into the unplowed area of snow.Jan 7, 1984 · N6372W · Substantial damageNTSB CHI84LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Holland, MIThe plt landed left of the rwy centerline with the acft 5 degrees left of the rwy heading. He did not correct to the right and the acft collided with a snowbank and nosed over.Jan 7, 1984 · N739BV · Substantial damageNTSB ATL84LA079Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Charlottesville, VAThe plt reported that he started to lose control during the landing and added power to go-around. He said he pulled backon the controls and inadvertantly raised the flaps after he was already losing altitude. After touchdown, the acft flipped over.Jan 7, 1984 · N2462J · Substantial damageNTSB FTW84LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Del Rio, TXDuring landing on a 4000 ft sod ranch strip the plt ran off the rwy into a raving and collapsed the landing gear. The plt said he landed in a crab and ran off the rwy. The owner on form 6120.1 stated that it was plt error, that the plt missed the rwy and ran…Jan 6, 1984 · N8117Z · Substantial damageNTSB DEN84LA067Accident · No injuriesLimited investigationFinal reportCessna 210 · Grand Junction, COThe plt stated he touched down too hard, bounced & that he over-corrected causing the acft to land hard again collapsingthe nose gear.Jan 6, 1984 · N9654T · Substantial damageNTSB MKC84LA057Accident · No injuriesLimited investigationFinal reportYoung-Losey Q-2 · Kansas City, MOThe acft collided with a rwy marker after bouncing during a power off landing. The acft was descended from 500 ft power off to a touchdown. The tailwheel acft bounced about 20 ft into the air. The acft went for the rwys edge and slid to a stop in the grass.Jan 4, 1984 · N82YL · Substantial damageNTSB NYC84FA064Accident · No injuriesField investigationFinal reportCanadair CL44D4 · East Boston, MAThe acft landed with the right main landing gear in the retracted position. The crew was unable to lower the right main gear by the normal or emergency methods. Inspection after the accident revealed that the main hydraulic line. Pn 44-75087-98 was broken…Jan 2, 1984 · N104BB · Substantial damageNTSB CHI84LA074Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Sauk Rapids, MNThe plt stated that while landing on a snow covered field one of the landing skis broke when it struck a dirt mound below the snow. The acft cartwheeled and flipped over.Jan 2, 1984 · N82667 · Substantial damageNTSB CHI84LA075Accident · No injuriesLimited investigationFinal reportPiper J-4E · White Bear Lake, MNThe ski-equipped acft suffered landing gear failure during a landing on a snow covered turf rwy. The landing gear separated when an attach point failed. The plt gave fatigue failure as a reason for the failure.Jan 1, 1984 · N37996 · Substantial damageNTSB DEN84LA058Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Ekalaka, MTThe plt stated that during touchdown the acft hit an area of patchy snow & the acft veered off the rwy into a snowbank.Dec 31, 1983 · N4830S · Substantial damageNTSB DEN84LA057Accident · No injuriesLimited investigationFinal reportMaule M-5-220C · Holyoke, COThe acft ran off the rwy during landing and nosed over. The plt stated that the accident occurred during a landing on rwy 17. The wind was reported as from the southwest at four KTS. The plt stated that the glide path and airspeed were good on final approach.…Dec 31, 1983 · N51637 · Substantial damageNTSB CHI84LA070Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Hebron, OHThe plt reported that when he landed on an ice covered rwy, he delayed using brakes. When he did use the brakes, he was unable to decelerate sufficiently. He elected not to attempt a go-around, since there were tall trees near the end of the rwy. The acft…Dec 31, 1983 · N4506W · Substantial damageNTSB DEN84LA056Accident · No injuriesLimited investigationFinal reportCessna 180 · Florissant, COThe acft collided with a snowbank during landing. The rwy had only been plowed to a width of about 16 ft according to the plt. This was a privately owned strip and the plt/owner said he instructed his maintenance man/ranch mgr to plow therwy to minimum width.…Dec 30, 1983 · N3389D · Substantial damageNTSB DEN84LA055Accident · No injuriesLimited investigationFinal reportCessna 152 · Hudson, COAfter returning from a maintenance test flt, the plt made a normal apch to land on a snow covered rwy. According to the plt & his passenger, the acft touched down along the right side of the rwy in snow. The plane then veered to the right & nosed over. No…Dec 30, 1983 · N49786 · Substantial damageNTSB SEA84LA029Accident · No injuriesLimited investigationFinal reportPiper PA18-A · Rome, ORThe acft nosed over in the snow during an enroute landing while on a cross country. The plt had landed at this arpt a week before. In the meanwhile there had accumulated 14 inches of snow on the rwy. During the rollout in this snow the acft suddenly stopped…Dec 29, 1983 · N1829A · Substantial damageNTSB MKC84LA048Accident · No injuriesLimited investigationFinal reportCessna 402B · Davenport, IAThe acft skidded sideways during landing on an icy rwy. The nose gear collapsed sideways when it collided with a snowbank at the rwys edge. There were no injuries.Dec 29, 1983 · N7947Q · Substantial damageNTSB LAX84LA120Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Murrieta, CAThe acft nosed over during landing rollout. The plt reported the acft speed on final was 80 mph which is faster than normal. The acft touched down about 900 ft down the 2682 ft rwy. The landing was on rwy 15 and the wind was from 045 degrees at 4 KTS. The plt…Dec 29, 1983 · N90973 · Substantial damageNTSB LAX84IA119Incident · No injuriesIncident investigationFinal reportBoeing 707-123B · Oakland, CAThe acft experienced a strong shimmy & vibration on takeoff which was attributed to deep ruts in the snow. After landingon deceleration the vibration became so severe that the plt stopped on the rwy centerline & ordered an evacuation. It was determined that…Dec 29, 1983 · N2773 · Minor damageNTSB DEN84LA054Accident · Minor injuriesLimited investigationFinal reportBeech 65-90 · Hayden, COThe acft overran the rwy end during a night IMC landing. The plt stated 'the descent was steep' and 'I first touched down 1/2 way down the 7000-FT rwy.' He also stated that, 'I decide to plant the acft on the rwy so I could get on the reversers and get it…Dec 27, 1983 · N276VM · Substantial damageNTSB SEA84LA028Accident · No injuriesLimited investigationFinal reportCessna A-185F II · Driggs, IDThe acft collided with a hidden snow berm while landing on a snow covered rwy. The new snow was 2 to 3 inches deep over a compacted snow base. The rwy was plowed to a width of 30 to 35 ft with 3 ft berms. The plt stated that he encountered a whiteout during…Dec 26, 1983 · N8344Q · Substantial damageNTSB MKC84LA045Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Iowa Falls, IAThe acft swerved and collided with a snowbank alongside the rwy during landing. The pilot stated that she hit some snow and ice on the rwy and when the acft started to slide she lost control. The acft turned left and when the left wing hit the snowbank the…Dec 26, 1983 · N9565W · Substantial damageNTSB MKC84LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Manhattan, KSThe plt stated that during her arrival at Manhattan, KS, the rwy had patches of snow & was surrounded by snow covered terrain. Just prior to landing, she became aware of a snowbank at the apch end of the rwy. She took evasive action, but the right main gear…Dec 25, 1983 · N55890 · Substantial damageNTSB FTW84FA102Accident · 1 fatalField investigationFinal reportBell 47G-2A-1 · Hughes, ARThe plt & observer were on a flt to rescue 2 duck hunters, stranded in a boat that became stuck in ice, 500 to 600 ft from shore. After removing the rgt door, they planned to pick up 1 hunter at a time on the rgt skid while the observer held onto him thru the…Dec 24, 1983 · N124CD · DestroyedNTSB DEN84LA060Accident · No injuriesLimited investigationFinal reportCessna 425 · Big Piney, WYPrior to departure the plt telephoned the FBO at Big Piney arpt. He was advised of the poor wx conditions that existed at the arpt & was also advised not to land at the arpt. The acft was later observed to land at Big Piney arpt, touch down on the snow…Dec 24, 1983 · N6884G · Substantial damageNTSB DEN84FA047Accident · No injuriesField investigationFinal reportPiper 602P · Rock Springs, WYThe acft swerved off the snow-covered rwy during landing. The snow plow equipment operator was unable to keep the rwy clear due to strong winds. Finger drifts developed soon after each plowing. Two foot snow banks existed on either side of the rwy. The snow…Dec 23, 1983 · N6894P · Substantial damageNTSB FTW84LA101Accident · No injuriesLimited investigationFinal reportAeronca 7DC · Bellville, TXThe plt stated he landed 'a little long & a little fast.' The acft then drifted off the paved rwy into grass & soft terrain. The right wheel dug into the ground & the acft nosed over onto its back at the line of rwy lights.Dec 22, 1983 · N82243 · Substantial damageNTSB LAX84LA108Accident · No injuriesLimited investigationFinal reportBell 47G · El Cajon, CADuring a demonstration to show his student how to autorotate fm a 2 ft height AGL the instructor reduced pwr and inadvertently applied fwd cyclic. The front portion of the skids hit the gd followed by the main rotor blades. Helicopter then rocked backwards,…Dec 21, 1983 · N4475 · Substantial damageNTSB DEN84FA045Accident · No injuriesField investigationFinal reportConvair 440 · Rock Springs, WYCombs airways, flt 709, collided with a snow bank during the landing roll at sweetwater county aprt. The capt reported that 'immediately after touchdown, the acft veered left, struck a snow bank, then veered to the right 180 deg coming to rest on the rwy…Dec 20, 1983 · N73162 · Substantial damageNTSB DCA84AA012Accident · 1 fatalFinal reportDouglas DC-9-31 · Sioux Falls, SDDuring landing the crew acquired visual reference with the ground & apch lights about 200 ft AGL, followed by visual sighting of the rwy. Since the ATIS reported blowing snow, the crew expected to see, & was not surprised to see, snow blowing across the rwy…Dec 20, 1983 · N994Z · Substantial damageNTSB ATL84LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Rock Hill, SCThe student plt reported he picked up a slight crosswind during his descent for landing. The acft touched down on the main landing gear wings level, started to veer left & did not respond to right rudder pressure. The plt applied max braking but the acft ran…Dec 20, 1983 · N69069 · Substantial damageNTSB ANC84FA026Accident · Serious injuriesField investigationFinal reportBoeing 747-200F · Anchorage, AKAt 2359 the local controller cleared the flt to land on rwy 6R. At 0001 the ground controller cleared a state-operated pick-up truck onto rwy 6R for a tapley run. The ground controller stated that he requested clearance from the local controller to allow the…Dec 19, 1983 · J8151 · Substantial damageNTSB DEN84LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · Broomfield, COThe acft collided with a snow bank during landing and nosed down. This was the student's first solo landing. The studentthought the landing was all right except that the acft kept going to the left in spite of right rudder. Some power was still on the acft.…Dec 18, 1983 · N93271 · Substantial damageNTSB CHI84LA061Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Hayward, WIThe acft collided with a snow bank during the landing roll and nosed over. The rwy was covered with snow and was slick. The solo student plt said he landed with more airspeed than normal and the acft started to go to the left on the rwy. The plts attempted…Dec 18, 1983 · N25687 · Substantial damageNTSB MKC84LA039Accident · No injuriesLimited investigationFinal reportCessna 150 · Clinton, MOThe plt took off from pleasant hill, MO to look for relatives who may have been survivors of an overturned boat. After searching a lake, he elected to land at Clinton, MO. The arpt at Clinton was closed for construction & the rwy was covered with snow & ice.…Dec 17, 1983 · N17297 · Substantial damageNTSB CHI84LA062Accident · No injuriesLimited investigationFinal reportCessna 152 · Peoria, ILThe student plt elected to make a touch & go landing on a rwy covered with loose snow & patches of ice. He reported that when he added power during his 1st touch & go, the acft veered to the left & subsequently collided with a snowbank.Dec 17, 1983 · N48544 · Substantial damageNTSB ATL84LA067Accident · No injuriesLimited investigationFinal reportCessna 182P-SYLANE · Damascus, GAThe plt, an auctioneer, had rented the acft to fly to a farm where he was to conduct an auction. Previously, he had inspected the intended landing area, a soy bean field, & thought it would be satisfactory for a landing. When he arrived & landed, the main…Dec 16, 1983 · N84223 · Substantial damageNTSB MIA84LA046Accident · No injuriesLimited investigationFinal reportBeech 35 · Lake City, FLThe plt landed with the nose gear partially extended. The plt reported that he heard a crack while the landing gear was retracting after takeoff. He put the gear handle back down and continued to Lake City. After flying several low passes, the control tower…Dec 15, 1983 · N444D · Substantial damageNTSB DEN84FA042Accident · Serious injuriesField investigationFinal reportMooney M20J · Bismarck, NDThe plt of N1151N reported that the departure arpt had some drifting snow which caused the r brake to freeze after takeoff. When the acft was landed, the r tire slid until it wore thru, then deflated. The plt stopped the acft on the rwy, informed tower psnl…Dec 15, 1983 · N1151N · Substantial damageNTSB CHI84IA060Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-8-61 · Chicago, ILA DC-8-61 operated by capitol air inc experienced a partial failure of the left main gear on the landing roll. The rear portion of the left main landing gear bogie & both rear tires were separated. Components of the left landing gear were submitted to…Dec 14, 1983 · N914CL · Minor damageNTSB LAX84LA426Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · San Carlos, AZDuring a night landing on a road, the acft was damaged when it hit a berm. According to customs officials. The plt had circled while ground personnel placed rows of lights adjacent to the road, then he landed. There was evidence that illegal drugs had been…Dec 13, 1983 · N3110M · Substantial damageNTSB CHI84LA059Accident · Minor injuriesLimited investigationFinal reportCessna 310 · Brainerd, MNAfter making a vor/dme apch, the plt circled to land on rwy 23 in wx conditions of light snow & fog. The terrain & rwy were covered with snow. The plt tried to contact Brainerd UNICOM to have the rwy lights turned up, but he received no response. He could…Dec 13, 1983 · N37252 · Substantial damage