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 LAX85LA295Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Angwin, CADuring a VFR cross country flt, wx conditions along the route induced the plt to divert to the Angwin arpt. After an overflt to obtain wind information from the wind sock, the plt said he entered the pattern and completed a normal approach and touchdown.…Jun 22, 1985 · N3800F · Substantial damageNTSB LAX85LA292Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Glendale, AZWhen the plt realized he was low during final apch to a landing, he erroneously decided not to use full flaps instead of adding power, vref was high and the landing was 3/4 of the way down the 2400 ft rwy. Believing he had sufficient room to takeoff again,…Jun 22, 1985 · N52789 · Substantial damageNTSB CHI85LA245Accident · No injuriesLimited investigationFinal reportCessna 150L · Griffith, INOn the student's third approach, he was observed to flare the acft too high. The acft drifted off to the side of the rwy and nosed down until it collided with the ground.Jun 22, 1985 · N10239 · Substantial damageNTSB ANC85LA104Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Ungalikthluk Rv, AKThe plt reported that when he was landing the float plane on a river, an extreme gust of wind cocked the acft causing loss of control. Subsequently, the acft struck a river bank & was damaged. The plt noticed that after the landing, the winds had changed,…Jun 22, 1985 · N10395 · Substantial damageNTSB MKC85LA136Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Belgrade, NEFlight instructor giving private pilot a bfr. Bfr was nearly completed when ip gave pilot a simulated forced landing over his own farm strip. Pilot was making an excellent approach until the landing gear hit the barbed wire hidden in the high grass.Jun 21, 1985 · N8336W · Substantial damageNTSB ATL85LA194Accident · No injuriesLimited investigationFinal reportCessna 152 · Lexington, NCDuring landing on a private turf airstrip, the nose wheel struck a 'pot' hole. The nose wheel separated from the acft and the acft skidded to a stop resulting in substantial damage.Jun 21, 1985 · N49214 · Substantial damageNTSB ANC85LA103Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Dillingham, AKThe aircraft swervd on the runway and ground looped, the pilot stated he lost control of the acft due to the wind condition.Jun 21, 1985 · N45PC · Substantial damageNTSB NYC85LA066Accident · Minor injuriesLimited investigationFinal reportCessna 182RG · Norfolk, MAThe acft was unintentionally landed with the gear retracted. A CFI and a pvt plt were on board at the time of the accident. The pvt plt in the left seat was flying the acft and on the third landing failed to extend the gear. The CFI in the right seat was…Jun 20, 1985 · N2306C · Substantial damageNTSB CHI85LA241Accident · No injuriesLimited investigationFinal reportCessna 172M · Mosinee, WIThe plt stated that he failed to flare properly following a 'fast and flat' final approach. The acft landed on its nosewheel resulting in substantial damage to the acft.Jun 20, 1985 · N12997 · Substantial damageNTSB ANC85LA098Accident · No injuriesLimited investigationFinal reportCessna 180 · Northway, AKDuring arrival, the plt landed the tail wheel equipped acft on rwy 22 with a x-wind from 290 deg at 8 KTS. After touchdown, the acft entered a ground loop & was damaged. A check of the plt's blood showed an alcohol level of 0.249%.Jun 20, 1985 · N5159E · Substantial damageNTSB ANC85FA102Accident · Minor injuriesField investigationFinal reportGrumman G-44 · Dillingham, AKThe amphibious acft crashed as the plt was landing on glassy water at the inlet of nerka lake. Subsequently, it sank & came to rest inverted in clear water on the bottom of wood river with the gear retracted & the flaps extended. Moderate rain was falling…Jun 20, 1985 · N176MS · Substantial damageNTSB MIA85IA197Incident · No injuriesIncident investigationFinal reportPiper PA-28R-200 · Ft. Pierce, FLThe landing check list was not properly followed and both pilots neglected to extend the landing gear in preparation for landingJun 19, 1985 · N5033T · Minor damageNTSB ANC85LA097Accident · No injuriesLimited investigationFinal reportCessna 170B · Fairbanks, AKPlt lost control on landing and ground looped. Wx and field conditions not a factor.Jun 19, 1985 · N4570C · Substantial damageNTSB MIA85IA195Incident · No injuriesIncident investigationFinal reportPiper PA-38-112 · Miami, FLThe acft wing dropped to the rwy after lndg. The CFI said that the lndg was smooth with the student plt at the controls. When the wing started dropping the CFI said he took the controls but could not keep the wing up. Post acc invest showed that the left main…Jun 18, 1985 · N25701 · Minor damageNTSB DEN85LA168Accident · No injuriesLimited investigationFinal reportHughes 269C · Grand Forks, NDOn June 18, 1985, a student plt and his instructor were on alocal tng flt. Prior to completing the mission, the instructor had his student execute a 180 degree autorotation. During the maneuver, the main rotor RPM was allowed to decay into the critical range…Jun 18, 1985 · N5203V · DestroyedNTSB CHI85LA236Accident · No injuriesLimited investigationFinal reportCessna 172 · Jenison, MIThe plt leveled the wings during the landing flare in a x-wind but failed to remove rudder input. The acft drifted to the right of the rwy and touched down in a grass area where it contacted a gully and nosed over.Jun 18, 1985 · N5267R · Substantial damageNTSB SEA85LA141Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · North Plains, ORAn overrun occurred due to excess speed and touching down 1/4 of the way down the 2100 foot glider strip. The aircraft rolled onto two foot high alfalfa where it then nosed over. The pilot previously landed gliders on the gliderport but never an engine…Jun 16, 1985 · N44SJ · Substantial damageNTSB NYC85LA149Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Champlain, NYDuring the landing in a pasture with tall grass, the main wheels contacted the grass, the acft slowed rapidly and nosed over.Jun 16, 1985 · N5621Z · Substantial damageNTSB NYC85LA148Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Peru, NYThe acft nosed over while landing on a private sod airstrip. The plt reported touchdown was made on an unmowed portion of the airstrip. The acft slowed quickly and nosed over just prior to coming to a stop.Jun 16, 1985 · N44250 · Substantial damageNTSB LAX85LA277Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Healdsburg, CAThe plt stated his apch was normal but when reaching the rwy threshold, the descent seemed to stop. There was a reportedheadwind of 30 KTS. He then applied full flaps. Seconds lat er lift was lost and the plt applied full pwr for a go around. The acft touched…Jun 16, 1985 · N6721H · Substantial damageNTSB CHI85LA243Accident · No injuriesLimited investigationFinal reportCessna 172 M · Decatur, INThe pilot landing rnwy 36 winds were 210 degrees, 12 knots gusts 18 knots stalled out high onthe wet on the wet sod runway the nose wheel dug in and then broke off the acft then nosed over inverted.Jun 16, 1985 · N8954V · Substantial damageNTSB ANC85LA094Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKThe acft dragged the left wing tip during lndg in a x-wind. The plt stated that he knew the wind was gusty before his takeoff but he felt certain that he could handle it. He stated after the accident that during the landing he had the acft in a crabbed…Jun 16, 1985 · N9282T · Substantial damageNTSB SEA85LA139Accident · No injuriesLimited investigationFinal reportMaule M-5-180C · Ontario, ORThe plt reported that when he landed, the wind was gusting to 25 KTS. He stated that when the acft touched down, it encountered a whirlwind that lifted the tail. Subsequently, the acft nosed over & was damaged. According to the 1700 PDT wx observation at…Jun 15, 1985 · N5652W · Substantial damageNTSB NYC85LA150Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Red Hook, NYThe acft contacted trees following a loss of directional control during a landing roll on rwy 19.Jun 15, 1985 · N55490 · Substantial damageNTSB MKC85LA132Accident · No injuriesLimited investigationFinal reportBeech C23 · Pratt, KSStudent pilot was on his second cross-country flight to this airport. He stated that after touchdown, he reached to raise the flaps and the airplane started to drift. He overcorrected and went off left side of the runway and nosed over when he went through a…Jun 15, 1985 · N6723C · Substantial damageNTSB DEN85LA156Accident · No injuriesLimited investigationFinal reportCessna 170B · Englewood, COOn June 15, 1985, a Cessna 170B ground looped during a touch and go landing at contennial arpt, Englewood, CO. The plt said a gust of wing caught him by surprise. The acft departed the runway and flipped over on its back. The plt was not injured.Jun 15, 1985 · N3475D · Substantial damageNTSB ATL85LA186Accident · No injuriesLimited investigationFinal reportCessna 152 · Abbeville, SCWhile practicing touch & go landings the student plt lost directional control of the acft & ran off the side of the rwy. The acft flipped to an inverted attitude when the nose wheel dug into the soft soil. The student was on his second solo flight.Jun 15, 1985 · N47071 · Substantial damageNTSB CHI85LA240Accident · Serious injuriesLimited investigationFinal reportHaney Polliwagon · Lambertville, MIThe plt was unable to flare the acft with full up elevator and the nose gear contacted the rwy during landing. The acft bounced and contacted the rwy again resulting in a gear collapse. The plt stated that the elevator did not provide the same amount of up…Jun 14, 1985 · N8FT · Substantial damageNTSB ATL85LA190Accident · No injuriesLimited investigationFinal reportBeech C-23 · Wilmington, NCThe student plt was making a landing at the second arpt of a x-country flt when a controller in the tower observed the acft bounce and spotted the nose gear lying on the rwy. An ELT signal was also received at that time. The student plt made a go-around and…Jun 14, 1985 · N6020U · Substantial damageNTSB ANC85LA095Accident · No injuriesLimited investigationFinal reportCessna 185 · Kantishna, AKThe plt was on a flt from fairbanks to Kantishna, AK; however, the rwy at Kantishna was muddy, so he elected to return to fairbanks. While returning, he elected to land at an abandoned mine strip for a comfort stop. During the landing, a hydraulic line to the…Jun 14, 1985 · N75LE · Substantial damageNTSB SEA85LA136Accident · Minor injuriesLimited investigationFinal reportCessna R-172-K · Las Vegas, NVDuring landing rollout on runway 19R directional control was lost with the aircraft verring to the right of the runway. Correction was made to the left, but the aircraft veered off the runway to the left. The wind was from 160 at 9. The density altitude was…Jun 13, 1985 · N736TX · Substantial damageNTSB FTW85FA254Accident · No injuriesField investigationFinal reportRobinson R-22 · Dallas, TXThe student plt allowed the main rotor blades to drop to a slow speed well below the green arc. The student plt and the instructor plt attempted to do a power recovery from the aborted autorotation maneuver but the eng could not accelerate the main rotor…Jun 13, 1985 · N9075Y · DestroyedNTSB DEN85LA164Accident · Serious injuriesLimited investigationFinal reportCessna T210J · Moab, UTThe plt & a passenger made a low level pass over the Colorado river to drop a package to friends, who were rafting on the river. The river was in a canyon with walls aprx 500 to 700 ft high. The plt said the eng lost power when the acft was in the canyon, so…Jun 13, 1985 · N2282R · DestroyedNTSB DEN85LA162Accident · No injuriesLimited investigationFinal reportPiper PA-28-180N · Delta, UTThe acft was flown by a student plt and his instructor on a local tng flt. During landing the sutdent plt did not flair the acft in time, hit hard and bounced. The instructor took control, made a soft landing followed by the main landing gear collapsing. The…Jun 13, 1985 · N4760L · Substantial damageNTSB NYC85LA146Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Old Town, MEDuring a pwr off landing, the instructor noticed that the airspeed was low. The instructor applied full pwr; however, the acft stalled and the plt was unable to recover the acft prior to coming in contact with the water.Jun 12, 1985 · N82126 · Substantial damageNTSB LAX85LA271Accident · No injuriesLimited investigationFinal reportCessna 172RG · Upland, CAThe plt stated that on the flt prior to the accident he felt a slight pull to the right as he applied brakes. On the next flt he touched down normally, lowered the nose and lightly applied brakes. The pull to the right was more severe this time. He applied…Jun 12, 1985 · N6225R · Substantial damageNTSB MKC85LA128Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Swifton, ARThe ag pilot was landing the airplane too fast and when he couldn't stop on the wet grass, he attempted a go-around. By the time the engine accelerated, there was not enough airspeed or runway and the airplane went through a fence and stopped against a…Jun 11, 1985 · N8836H · Substantial damageNTSB LAX85FA269Accident · Minor injuriesField investigationFinal reportAero Commander 1121 · Van Nuys, CAThe plt, executing and ILS apch, observed a primary hydraulic pressure drop and declared his intent to land without the use of flaps, speed brakes, reversers or nose wheel steering. The acft ran off the end of the rwy during landing, traveled aprx 1300 ft and…Jun 11, 1985 · N69GT · Substantial damageNTSB SEA85LA133Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Las Vegas, NVDuring a local instructional flight a bounced landing was made. The acft bounced nose high to about 20 ft AGL. The acft then veered left of the rwy after full power had been added and flaps reduced from 40 degrees to 25 degrees for an attempted go-around at…Jun 10, 1985 · N6456A · DestroyedNTSB SEA85LA129Accident · No injuriesLimited investigationFinal reportRobinson R22 · Port Orchard, WAThe instructor plt (CFI) with only 358 hrs total flt time was demonstrating an autorotation with a power recovery. During the recovery, the CFI failed to fully regain RPM & the helicopter settled to the surface. With a low rotor RPM, there was a loss of tail…Jun 9, 1985 · N8490D · Substantial damageNTSB ATL85LA195Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Wingate, NCThe plt & passenger consumed several beers shortly before boarding the helicopter for a flt in the local area. The flt lasted aprx 15 min. The passenger reported that during a landing, the skid on the right side contacted the ground causing the helicopter to…Jun 9, 1985 · N9588F · Substantial damageNTSB ANC85LA091Accident · No injuriesLimited investigationFinal reportCessna 180 · Kenai Lake, AKThe plt stated that the float struck the water during landing resulting in the acft nosing over and sinking in 25 ft of water.Jun 9, 1985 · N180SL · Substantial damageNTSB ANC85FA090Accident · No injuriesField investigationFinal reportAeronca 7AC · Anchorage, AKThe acft collided with a parked helicopter during landing. The acft had left the rwy at midfield & collided with the parked acft. The plt stated that he lost directional control after lndg. A rwy light on the left side of the rwy aprx 900 ft from the approach…Jun 9, 1985 · N83995 · Substantial damageNTSB MKC85LA127Accident · No injuriesLimited investigationFinal reportCessna 172 · Curtis, NEThe plt stated he misread the windsock and made a downwind landing resulted. The acft overran the end of the grass rwy and nosed over when the nose gear contacted a plowed fld. The arpt operator reported the winds were from 180 degs at 18 KTS when the landing…Jun 8, 1985 · N2267E · Substantial damageNTSB MIA85LA185Accident · No injuriesLimited investigationFinal reportHughes 269C · St.Petersburg, FLThe helicopter was landing after a training flight with an instructor pilot and a non-rated-non-certificated student pilot on board. As the helicopter touched down a severe resonant vibration started. The instructor stated that he attempted to lift off the…Jun 8, 1985 · N8657F · Substantial damageNTSB DEN85LA158Accident · No injuriesLimited investigationFinal reportMooney M20K · Lafayette, COOn June 8, 1985, a Mooney M20K, impacted the ground off the rwy while landing at alexander dawson arpt, Lafayette, o. the plt said he was attempting to make a short field apchto the plt, the apch was high and fast. The acft landed, porpoised, and departed the…Jun 8, 1985 · N5764N · Substantial damageNTSB DEN85LA157Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Albuquerque, NMThe plt reported that during a normal landing, the right main gear folded back, followed by collapse of the left main gear. An exam revealed evidence of fatigue failure of a clevis bolt in the threaded area.Jun 8, 1985 · N2669K · Substantial damageNTSB CHI85LA230Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Blair, WIThe plt attempted to land the acft in a farm field but was unable to stop before reaching the end of the field. The acft ran through a fence & a ditch before coming to rest. The plt stated that he overshot the rwy, landed long, & was unable to stop the acft…Jun 8, 1985 · N55956 · Substantial damageNTSB MKC85LA122Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Des Moines, IADuring a full stop landing the plt applied brakes to arrest the landing roll and upon application of the brakes, the acft veered slowly to the left without slowing down. The check plt applied his brakes to assist the plt, but without any effect. The acft…Jun 7, 1985 · N3502M · Substantial damageNTSB FTW85FA247Accident · 2 fatalField investigationFinal reportPiper PA-28RT-201T · Pineville, LAThe aircraft landed long and fast on the relatively short, sloping runway. After bouncing four times, the pilot rapidly added throttle on the turbocharger-equipped aircraft and attempted to climb. Witnesses observed smoke from the exhaust, and described high…Jun 7, 1985 · N4507V · Destroyed