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 ATL85LA164Accident · No injuriesLimited investigationFinal reportCessna 177B · Huntsville, ALThe acft drifted right of rwy center line during landing roll & the plt aborted the landing by applying full pwr. The acft continued off the rwy and the nose wheel dug into the soft soil resulting in the acft nosing over.May 16, 1985 · N34494 · Substantial damageNTSB FTW85FRG01Accident · No injuriesFinal reportCessna 140 · Boerne, TXThe acft cartwheeled after contacting a tree while landing. The plt reported a hard landing occurred, the acft bounced 10 to 20 ft in the air and veered left where it contacted the tree.May 15, 1985 · N2431V · Substantial damageNTSB NYC85LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Morristown, NJAccording to the student, the acft encountered a sudden wind shift from the east as he was landing. He stated that this caused the plane to tip over to the plt's right & come to rest on its top. The student also reported that the wind was from 050 deg at 7…May 14, 1985 · N6507B · Substantial damageNTSB MKC85LA101Accident · No injuriesLimited investigationFinal reportPiper PA-46 · Osage Beach, MOThe plt landed the acft mid-field on the 3205 ft rwy, the acft landing speed was higher than normal and a decision was made to continue the landing instead of going around for another attempt. The plt applied brakes & the acft skidded off the rwy. The plt…May 14, 1985 · N4362F · Substantial damageNTSB LAX85LA255Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Morgan Hill, CAOn a personal flt, the plt & pax flew to an uncharted, dirt airstrip located in a state park. The plt acknowledged that on apch the acft was high and fast. After initially touching down, the plt stated that he tried to go-around. A park ranger reported that…May 13, 1985 · N2456L · Substantial damageNTSB ANC85LA082Accident · No injuriesLimited investigationFinal reportCessna C-185 · Anchorage, AKThe pilot in command touched down on a dry runway in a crab angle and lost control of the airplane resulting in ground loop.May 13, 1985 · N5815T · Substantial damageNTSB CHI85LA194Accident · No injuriesLimited investigationFinal reportDassault-Breguet Falcon 50 · Lake Geneva, WIHigh sink rate developed on short final. Acft touched down 13 ft prior to runway before sink rate could be arrested. Landing gear collapsed after contacting edge of rwy which is 7 inches higher than surrounding terrain. Tail section of acft caught fire just…May 12, 1985 · N1181G · DestroyedNTSB ATL85LA161Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Savannah, GAThe plt ldg the acft with the ldg gear retracted. He stated that he evidently forgot to extend the gear.May 12, 1985 · N5844P · Substantial damageNTSB LAX85LA256Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Pacoima, CAPlt attempted a no-flap landing during which excessive airspeed was used. The acft drifted off the right side of the rwy during the flare and subsequently touched down in soft terrain. While braking directional control was lost and the acft collided with a…May 11, 1985 · N4378N · Substantial damageNTSB FTW85LA222Accident · No injuriesLimited investigationFinal reportBeech M-23 · Willow City, TXDuring the return leg of a x-country flt to California, the plt became lost and elected to make a precautionary landing. The acft wing contacted a sign post during the landing.May 11, 1985 · N2384Z · Substantial damageNTSB ATL85LA159Accident · No injuriesLimited investigationFinal reportCessna 150M · Andalusia, ALThe student plt reported that during a landing roll, the acft veered to the right, went off the right side of the rwy & collide with a dirt bank.May 11, 1985 · N3682V · Substantial damageNTSB ATL85LA158Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Greenville, ALThe plt stated that he made a normal apch for a full stop, 3-point landing. During the landing roll, the acft began to vibrate & shake laterally. The plt reported that the vibration was caused by a tail wheel shimmy, but at first, he did not realize what…May 11, 1985 · N477M · Substantial damageNTSB CHI85LA199Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Troy, MIThe plt stated that his intended destination was the Troy-oakland arpt where he intended to land on rwy 27. However, he inadvertently landed on rwy 27 at the big beaver arpt which was aprx 3 mi away. He was expecting to have 3800 ft of rwy, but the rwy at big…May 10, 1985 · N2099P · Substantial damageNTSB LAX85LA249Accident · No injuriesLimited investigationFinal reportHiller 12-C · Casa Grande, AZThe plt was demonstrating autorotations to a touchdown on a dirt rwy into a 5 kt headwind. On the final landing he said that the touchdown felt the same as others he had done. Speed at touchdown was 15 mph and the helicopter slid forward in a straight line…May 9, 1985 · N38767 · Substantial damageNTSB ATL85LA163Accident · No injuriesLimited investigationFinal reportCessna 182A · Dover, TNThe student plt and his pax, a private plt, flew to another arpt and made several takeoffs and landings. Then returned to the private airstrip where their flight had originated. The student plt was at the controls on this apch. After touchdown the acft became…May 9, 1985 · N3937D · Substantial damageNTSB NYC85LA119Accident · No injuriesLimited investigationFinal reportCessna 140 · Latrobe, PAThe plt reported that during a landing, the acft began to swerve to the right. At about the time he was regaining control, the left gear spring (strut), pn Q441138, failed. Subsequently, the acft went off the rwy & the left wing was damaged. An exam of the…May 8, 1985 · N4034N · Substantial damageNTSB BFO85LA045Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Elkton, VAAfter arriving at the Elkton arpt, the plt executed 2 practice emerg approaches with go-arounds, then made an approach to landing on rwy 22. According to him, 2 of 3 seconds before touchdown, the acft ballooned, then landed hard, bounced &stalled. The nose…May 8, 1985 · N16830 · Substantial damageNTSB ATL85LLT07Accident · Serious injuriesFinal reportBarnes FF-7 · Franklin, TNThe plt noticed a power line extending across the field he had selected for landing at which time air was released from the envelope for an emergency descent. As the basket touched down, the envelope drifted into the line. A passenger was seriously injuried…May 8, 1985 · N4049Y · Minor damageNTSB SEA85LA108Accident · No injuriesLimited investigationFinal reportCessna 185 · Ketchikan, AKAfter departure the plt stated he selected gear up. He stated that the gear indicator lights indicated that one gear as still in the down position. He said he recylcled the gear and then checked the gear indicator blubs. The pilot said he then hand pumped the…May 7, 1985 · N5313Y · Substantial damageNTSB NYC85LA124Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Stow, MAPiper PA28-181N82054 landed hard on runway 3 at minute man airport, Stow, mass. The student was performing touch and go landings, on one landing, the pilot stated that the aircraft bounced and then veered to the left. Rudder was applied but there was no…May 7, 1985 · N82054 · Substantial damageNTSB CHI85LA195Accident · No injuriesLimited investigationFinal reportBeech 58 · Terre Haute, INThe plt was practicing touch-&-go landings on rwy 13, then elected to make another on rwy 5. He stated that the gear was extended on downwind & a safe gear indication was received. However, the acft was landed with the gear retracted. The plt stated that…May 7, 1985 · N29CP · Substantial damageNTSB CHI85LA190Accident · No injuriesLimited investigationFinal reportPiper PA-11-494 · Alliance, OHThe acft approach was high and fast. The landing was made with 500-600 ft of runway remaining. The acft brakes were not sufficient to stop on the runway. The pilot added power and veered left off the end of the runway to avoid a heavily traveled road, the…May 7, 1985 · N4707H · Substantial damageNTSB ATL85LA154Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Williamson, GAThe student plt stated his final apch to the rwy was made off-center to account for a x-wind. The glider touched down to the left of the paved strip & began converging on a fence. The plt retracted the speed brakes & lifted off as the glider approached the…May 7, 1985 · N916G · Substantial damageNTSB FTW85LA212Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Mckinney, TXDuring landing the acft started drifting off right side of rwy. Plt stated he used left rudder and brake but was unable to control the drift. The acft stopped after the nose gear collided with a ditch and collapsed. FAA maintenance personnel instructed plt to…May 6, 1985 · N732YR · Substantial damageNTSB NYC85LA117Accident · No injuriesLimited investigationFinal reportCessna 172N · Vincentown, NJThe acft collided with tree tops during a lndg in gusty winds. The plt said a gust of wind lifted the rt wing during the flare. As the acft veered to the left the plt said he considered a go-around but there was not room enough to clear the trees. The left…May 5, 1985 · N4680G · DestroyedNTSB LAX85LA243Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Concord, CAWhile landing on rwy 19R with a wind from 250 deg at 14 KTS, the acft went off the right side of the rwy & was damaged. Personnel in the control tower said that plt appeared to lose control of the acft during the landing flare & the acft cartwheeled to the…May 5, 1985 · N500RG · Substantial damageNTSB LAX85LA242Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Springville, CAAfter overflying the uncharted, private airstrip & evaluating its size, the PIC attempted to land on the narrow rwy. Only about 900 ft of the rwy was usable. After touching down, the plt realized the acft could not be stopped on the remaining available strip,…May 5, 1985 · N5166W · Substantial damageNTSB FTW85LA213Accident · No injuriesLimited investigationFinal reportPiper PA-601 · Balmorhea, TXThe acft was involved in illegal activity when it was intentionally landed in an open pasture. During the landing, the acft veered left and struck a 30 inch high concrete culvert. The gear collapsed on contact with the culvert. Unknown personnel subsequently…May 5, 1985 · N8083J · DestroyedNTSB DEN85LA128Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-32 · Colorado Spring, COThe glider collided with a parked acft following a loss of directional control during the landing roll. The plt reported the left wing dipped during the landing roll because of the x-wind. The left wing tip wheel dug into an area of soft sand beside the rwy…May 5, 1985 · N2477W · Substantial damageNTSB DEN85LA127Accident · Serious injuriesLimited investigationFinal reportRaven S77A · Fort Collins, COThe balloon basket containing 8 pass'g & 2 crewmembers brushed alongside a fence during lndg. One pass'g who had been jostled by the landing became a victim of 1ACERATIONS & a broken arm from contact with barbed wire fence. The plt stated that the wind was…May 5, 1985 · N4199G · No damageNTSB NYC85LA116Accident · No injuriesLimited investigationFinal reportCentrair 101A · Barre, MAThe acft encountered windshear during the approach to land and landed in trees. By the time the plt realized his situation it was too late and his wing tip hit a tree top. The acft camp to rest in trees.May 4, 1985 · N4429W · Substantial damageNTSB MKC85LA097Accident · No injuriesLimited investigationFinal reportBeech 35 · Ames, IAThe plt reports that the acft had slowed to taxi speed after landing when the gear warning horn began to blow followed shortly by collapse of the landing gear. Examination of the landing gear electrical circuitry failed to reveal any deficiencies.May 4, 1985 · N3068V · Substantial damageNTSB LAX85LA245Accident · No injuriesLimited investigationFinal reportCessna 140 · Jackson, CAPrivate plt lost directional control of his tail wheel acft after landing on rwy 19, ground looped and nosed over in a ditch. Wind was from 270 degrees at 10 KTS with gusts to 15 KTS. He reported no mechanical failures or malfunctions with the acft.May 4, 1985 · N76086 · Substantial damageNTSB FTW85LA208Accident · No injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe student plt was on a local instructional flt practicing solo landings. He stated he made a hard landing and the acft bounced with the nose gear ass'y separating allowing the acft to be substantially damaged. The left wing ass'y received substantial damage.May 4, 1985 · N6593L · Substantial damageNTSB ATL85IA153Incident · No injuriesIncident investigationFinal reportPiper PA-34-200T · White Sulphur, WVDuring VFR ldg apch, pilot noted a vehicle on the left edge of the rwy. The apch was contd and as the ldg flare was started, the pilot and one of his passengers stated that the vehicle started across the rwy in front of them. The pilot pulled the yoke back to…May 4, 1985 · N2618M · Minor damageNTSB SEA85LA105Accident · No injuriesLimited investigationFinal reportCessna 180-L · Las Vegas, NVDuring landing rollout a gust of wind picked up the left wing. The acft rolled down the rny on the right main gear until it collapsed. Although the tower reported the wind as being straight down the rwy, the plt and the plt who landed immediately after the…May 3, 1985 · N4979A · Substantial damageNTSB SEA85LA102Accident · No injuriesLimited investigationFinal reportCessna 170B · Boulder City, NVDuring arrival, a person answering the UNICOM reported that rwy 3 was the active rwy & that the wind was 10 KTS. The plt made a wheel landing on rwy 3 in winds that were from 210 deg at 10 KTS. He stated that when the tailwheel came down during the landing…May 2, 1985 · N2518D · Substantial damageNTSB LAX85LA233Accident · No injuriesLimited investigationFinal reportSchweizer SGS1-36 · Hemet, CAThis was the first flight after a cockpit check-out in the Schweizer sgc 1-36. The pilot released from the tow plane when he realized that the spoilers were deployed and landed short of the runway. The pilot reported that the spoiler handle in this model…Apr 30, 1985 · N36156 · Substantial damageNTSB CHI85LA184Accident · No injuriesLimited investigationFinal reportCessna 180J · Minneapolis, MNThe plt was ferrying the acft to the anoka county arpt for radio maintenance. During the landing roll, the acft swerved off the right side of the rwy & was damaged. No preimpact part failure or malfunction was reported.Apr 30, 1985 · N46683 · Substantial damageNTSB MKC85LA094Accident · No injuriesLimited investigationFinal reportPiper PA-39 · Peculiar, MODuring the landing roll at the plt's pvt air strip with a runway consisting of wet sod, the brakes were applied to stop the acft. The braking was ineffective and the acft departed the side of the runway. After departing the runway the main gear and nose gear…Apr 29, 1985 · N8943Y · Substantial damageNTSB MKC85LA093Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Kansas City, MOPlt inadvertently entered clouds on VFR flight. Plt sighted an arpt through breaks in clouds and decided to land. The acft touched down short of a closed rwy, partially collapsing the left gear. It then bounced up onto the rwy and fully collapsed the left…Apr 29, 1985 · N300KR · Substantial damageNTSB FTW85LA205Accident · No injuriesLimited investigationFinal reportCessna A185F · Gibson, LAThe amphibian acft was substantially damaged when it collided with a tree while landing on an oil field service canal. The plt stated that he landed long and fast and as a result he was unable to negotiate the second half of an 's' turn in the canal. The left…Apr 29, 1985 · N4691E · Substantial damageNTSB FTW85FA202Accident · Minor injuriesField investigationFinal reportBoeing 737-300 · Amarillo, TXThe acft landed in a thunderstorm, winds recorded at the time of the accident exceeded the limits recommended for full reverse thrust. The acft hydroplaned, weather-cocked slightly, and slid off the downwind side of the 300 ft wide rwy. The nosewheel…Apr 29, 1985 · N300SW · Substantial damageNTSB CHI85LA183Accident · No injuriesLimited investigationFinal reportCessna 152 · Broadhead, WIThe plt stated that during arrival, he entered a traffic pattern for what he thought, according to his directional gyro, was rwy 9. Rwy 9 was 2500 ft long; however, he landed on rwy 3, which was 1520 ft long. During the landing, the plt was unable to stop on…Apr 29, 1985 · N25227 · Substantial damageNTSB CHI85LA182Accident · No injuriesLimited investigationFinal reportCessna 177RG · Jacksonville, ILAfter completing 14 landings the pilot elected to full stop. He attempted a go around after touchdown & after rolling down part of the rwy. The acft ran off the end of the rwy into a plowed field.Apr 28, 1985 · N7702V · Substantial damageNTSB ANC85LA076Accident · No injuriesLimited investigationFinal reportPiper 22/20 · Girdwood, AKThe acft was on a flt to transport 2 skiers to a glacier area, so they could ski downhill to a location to where they could be picked up. The plt landed the wheel/ski equipped acft on upsloping terrain. The visibility was good, except a whiteout phenomena was…Apr 28, 1985 · N8035D · Substantial damageNTSB LAX85LA226Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Oroville, CAAfter overflying the arpt to evaluate local conditions, the PIC elected to land on rwy 01. The wind was estimated from 330 degs at 15 KTS with gusts to 20 KTS. The PIC reported that on final apch with the acft's flaps fully extended, she observed that the…Apr 27, 1985 · N15420 · Substantial damageNTSB LAX85IA225Incident · No injuriesIncident investigationFinal reportBeech C24R · Fresno, CAWhile ldg with a left quartering tailwind the student plt bounced the acft. He failed to go around as he had been instructed to do, & after the acft bounced 2 more times its nose gear collapsed. Damage to the acft was minor.Apr 27, 1985 · N6041X · Minor damageNTSB DEN85LA121Accident · No injuriesLimited investigationFinal reportBoeing PT 17 · Aurora, COThe acft ground looped while landing at front range aprt, Aurora, CO. The plt was receiving instruction from a flight instructor for insurance purposes. Witnesses saw the acft land in a normal manner then it began to swerve back and forth across the rwy which…Apr 27, 1985 · N555JW · Substantial damageNTSB CHI85LA181Accident · No injuriesLimited investigationFinal reportCessna 172N · Perrysville, OHAcft landed with quartering tailwind. Acft touched down, ballooned and touched down again with aprx 1000 ft of rwy remaining. Unable to stop on the tall wet grass, plt initiated a groundloop to the left into a plowed field. The acft then nosed over.Apr 27, 1985 · N5102D · Substantial damage