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 DEN86FTE01Accident · Minor injuriesFinal reportSkurich FOCKE-WULF 190 · Falcon, COThe acft groundlooped to the rt during an attempted go-around after landing. The plt was landing at a arpt with watch he was unfamilar. He thought he saw wires at the approach end of the rwy so he landed long and then attempted a go-around. The acft…Oct 5, 1985 · N190FK · Substantial damageNTSB MIA86LA003Accident · No injuriesLimited investigationFinal reportCessna 414 · Sarasota, FLThe plt stated that his right main gear would not extend, so he circled the arpt for about 1/2 hour to burn off excess fuel, retracted the remaining gear & intentionally landed gear up on rwy 32. Examination of the right main landing it to extend beyond it's…Oct 4, 1985 · N24ET · Substantial damageNTSB CHI86LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Troy, MIThe plt landed on rwy 27 with winds from 185 degs at 20 KTS gusting to 30 KTS. The acft ballooned on short final. The plt added pwr but the right wing dropped and hit the rwy. The acft cartwheeled.Oct 4, 1985 · N505PC · DestroyedNTSB BFO86LA001Accident · No injuriesLimited investigationFinal reportCessna 172N · Annapolis, MDThe plt crossed mid-field, and entered a left down wind for rwy 30. He then checked wind direction, completed a base leg, and entered final apch. After reducing his airspeed, the acft 'floated' prior to touching down aprx 600 ft short of mid-fld. The plt…Oct 4, 1985 · N4691G · Substantial damageNTSB FTW86LA003Accident · No injuriesLimited investigationFinal reportCessna 182N · Odessa, TXDuring touch-&-go landing practice on her second solo training flight, the student plt made a hard landing. The nose gear strut was driven upward through the firewall and the prop was damaged. The acft bounced/porpoised three times & came to rest off the left…Oct 3, 1985 · N92755 · Substantial damageNTSB CHI86LA003Accident · No injuriesLimited investigationFinal reportCessna 172F · Canton, OHThe acft overran the rwy and collided with wires and a pole during landing. The student plt stated that he was too fast and landed long during the calm wind landing. He also stated he should have used more flaps.Oct 3, 1985 · N8347U · Substantial damageNTSB CHI86LA002Accident · No injuriesLimited investigationFinal reportCessna 172 · Crivitz, WIThe plt lost directional control of the acft during the landing roll in x-wind conditions. As the acft veered to the left side of the rwy it struck a rwy light. The arpt owner stated the acft touched down in a crabbed position and the local winds were from…Oct 2, 1985 · N52142 · Substantial damageNTSB LAX85LA404Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Huntington Bch, CAThe plt acknowledged that on short final approach to the 2330 ft-long rwy, the acft's speed was 'a little hot', & during ldg flare the acft 'floated in ground effect'. After the acft bounced 3 times the plt decided to go around & he applied full pwr. The plt…Sep 30, 1985 · N231GW · Substantial damageNTSB NYC85LA255Accident · No injuriesLimited investigationFinal reportCessna 152 · Dansville, NYCessna 152,N6135P,on flight plan batavia, new york, landed hard at Dansville county airport and collapsed the nose gear. The aircraft was destroyed by fire, the pilot and one passenger were unjured.Sep 29, 1985 · N6135P · DestroyedNTSB NYC85LA252Accident · No injuriesLimited investigationFinal reportBeech C35 · Wexford, PAAircraft was landing on private grass strip and during landing roll struck a deer with the right wing tip. The grass was wet and the pilot lost directional control. The aircraft impacted trees that bordered the airstrip and was destroyed.Sep 29, 1985 · N1886D · DestroyedNTSB CHI85LA388Accident · No injuriesLimited investigationFinal reportCessna 152 · Delta, OHThe plt was performing a soft fld landing. When the nose wheel settled onto the airstrip it dug into the soft terrain, collapsed and the acft nosed over.Sep 29, 1985 · N24278 · Substantial damageNTSB ANC85LA185Accident · No injuriesLimited investigationFinal reportCessna 180A · Glennallen, AKThe pilot stated the aircraft left wing was raised by a gust of wind. The aircraft accelerated rapidly in a si deways attitude to the right. The wind gust encountered and the fact the landing roll was almost completed CA used a situation that was beyond the…Sep 29, 1985 · N5353D · Substantial damageNTSB CHI85LA387Accident · No injuriesLimited investigationFinal reportCessna 150 · Hastings, MIThe pilot was competing in a spot landing contest. The aircraft was reportedly observed about 4 to 5 feet AGL and slow just before it contacted the grass runway. The nosegear failed, dug into the ground, resulting in a nose over.Sep 28, 1985 · N3025S · Substantial damageNTSB FTW85FA358Accident · No injuriesField investigationFinal reportCessna 177RG · Ennis, TXThe plt could not lower the landing gear through use of the normal gear extension system. He was able to partially lower it through the use of the emergency extension system. Next he made an emergency landing at the departure airport during the hours of…Sep 27, 1985 · N2637V · Substantial damageNTSB NYC85LA257Accident · No injuriesLimited investigationFinal reportCessna 172P · Canada Falls Lk, MECessna 172, a floatplane encountered a wind gust while landing on water. In an attempt to compensate for the wind. One of the wings contacted the water surface.Sep 25, 1985 · N54103 · Substantial damageNTSB MIA85LA263Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Pahokee, FLThe plt stated that he was flaring for landing when a gust of wind raised the acft causing it to crash into the rwy.Sep 24, 1985 · N63200 · Substantial damageNTSB LAX85LA401Accident · No injuriesLimited investigationFinal reportBeech P60 · San Jose, CADuring the landing roll, the acft veered off the right side of the rnwy and made contact with a taxiway marker which was then thrown against the acft, puncturing the pressure bulkhead compartment. Examination of the left brake assembly revealed evidence of…Sep 24, 1985 · N973T · Substantial damageNTSB FTW85LA357Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Ruston, LAThis 110 hour private pilot lost directional control of the aircraft while landing in a 90 degree cross wind and veered into a pickup truck spraying herbicide on the runway edge lights. Two city employees saw the aircraft coming towards them and escaped…Sep 24, 1985 · N31919 · Substantial damageNTSB NYC85LA247Accident · No injuriesLimited investigationFinal reportCessna P210N · Marlboro, NJThe plt made a VOR apch to the arpt and circled to land while simultaneously determining wind condition. It was raining at the time. A landing was made on rwy 27. On touchdown, the plt stated, his brakes were ineffective. He described the rwy as wet. Since it…Sep 23, 1985 · N210AG · Substantial damageNTSB CHI85FA385Accident · No injuriesField investigationFinal reportDassault-Breguet 10 · West Chicago, ILThe falcon 10 touched down long and fst on a wet runway, experienced hydroplanning and went off the end of the runway,struck a drainage ditch and collapsed the landing gear. The nose gear came back and bent the throttle quadrant bracket, pulled the fuel…Sep 23, 1985 · N700DK · Substantial damageNTSB ANC85LA182Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Feather River, AKWhile landing in gusty surface wind conditions the pilot lost control of he airplane and turned over.Sep 23, 1985 · N7440K · Substantial damageNTSB SEA85LA222Accident · No injuriesLimited investigationFinal reportCessna 180 · Klamath Falls, ORThe plt lost directional control of the acft following a bounced landing. The acft veered off the right side of the rwy where it contacted an area of tall grass and nosed over.Sep 22, 1985 · N8062V · Substantial damageNTSB SEA85LA219Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Ridgefield, WAThe acft stalled at an alt of aprx 15 AGL and contacted the terrain hard during a landing at a pvt airstrip. The acft does not have a stall warning system. The plt stated that he should have maintained a proper airspeed.Sep 22, 1985 · N84844 · Substantial damageNTSB ATL85FKG12Accident · No injuriesFinal reportCessna 172P · Birmingham, ALDuring arrival, the plt noted that the wind was from about 150 degs. Due to the terrain & obstructions near the northeast end of the rwy, he elected to land on rwy 4. During the landing, the acft floated before touching about 1/3 to 1/2 of the way down the…Sep 22, 1985 · N5227K · Substantial damageNTSB MKC85LA222Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Cameron, MOThe pilot stated that he was aware of the IFR conditions enroute but was not expecting them so soon. When he was within four minutes of his landing airport, the weather turned very bad but he decided to continue. Visibility was so bad that he had to turn to…Sep 21, 1985 · N46175 · Substantial damageNTSB FTW85LA355Accident · No injuriesLimited investigationFinal reportCessna 172RG · Mineral Wells, TXThe main landing gear colapsed during a touch and go landing. The landing gear warning circuit breaker had popped, and the instructor pilot received no warning that the gear was not fully extended.Sep 21, 1985 · N6290R · Substantial damageNTSB CHI85LA384Accident · No injuriesLimited investigationFinal reportCessna 150H · Racine, WIThe pilot reported a gust of wind resulted in a nose high left turn just prior to touchdown. Power was added & the left wing contacted the runway. The aircraft went off the left side of the runway and hit a ditch.Sep 21, 1985 · N50433 · Substantial damageNTSB ATL85LA281Accident · No injuriesLimited investigationFinal reportCessna A188B · Baxley, GAPlt attempted ldg in cultivated field after sowing load of rye grass seed. Grnd was soft and wheel dug in and acft nosed over. Plt was not injured.Sep 21, 1985 · N84284 · Substantial damageNTSB SEA85LA218Accident · No injuriesLimited investigationFinal reportWaco UIC · Boise, IDThe plt reported that when he landed, the acft began drifting to the left. Since there was a high speed turn-off ahead, he did not make an immediate correction for the drift. When a correction was applied, the acft did not respond & it continued into a ground…Sep 20, 1985 · N13572 · Substantial damageNTSB CHI85LA382Accident · No injuriesLimited investigationFinal reportNavion 61G · Greenwood, INThe plt landed long on the 4000 ft asphalt rwy. He stated he was applying heavy braking when his foot slipped causing him to strike and advance the throttle. The acft rolled off the end of the rwy into a corn field.Sep 20, 1985 · N2359T · Substantial damageNTSB DEN85LA244Accident · No injuriesLimited investigationFinal reportCessna 425 · Boulder, COThe plt said he made a normal ldg. During ldg roll the left brake would not respond to pedal application. The plt errored by incorrectly feathering both props. The a/c went off the eng of r/w and struck a fence. Examination of the brake system revealed a…Sep 19, 1985 · N1222B · Substantial damageNTSB BFO85LA078Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW-20 · New Castle, VAAccording to the plt, after experiencing a loss of lift, he flew over the open field, observed electrical wires, and continued to fly parallel with the wires. As he turned westward to land in the field, the plt lost sight of the power lines in the sunset.…Sep 19, 1985 · N39DG · Substantial damageNTSB ANC85LA181Accident · No injuriesLimited investigationFinal reportCessna 172 · Shirleyville, AKThe acft nosed over following a loss on control while landing on a gravel road. The plt reported that after a 100 ft landing roll, the right wing caught brush along the side of the road. The acft veered right and the right main gear contacted a log resulting…Sep 19, 1985 · N6951A · Substantial damageNTSB ATL85LKG13Accident · No injuriesFinal reportCessna 182N · Panala, ALThe acft collided with a tree during lndg which pulled it to the left off the road chosen for landing. The plt applied pwr to clear a ditch and the acft came to rest in a row of small trees. The plt had said the eng had started missing after takeoff from the…Sep 18, 1985 · N92746 · Substantial damageNTSB MIA85LA258Accident · No injuriesLimited investigationFinal reportCessna 177RG · Ormond Beach, FLThe plt stated that he forgot to extend the landing gear prior to touchdown while on a test flight after maintainence work was performed on the acft.Sep 17, 1985 · N52637 · Substantial damageNTSB DEN85LA243Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Holyoke, COThe plt landed her a/c in a right xwind and was unable to prevent the a/c from veering off the r/w. the a/c struck a wind t and came to rest in a corn field. The plt was not injured.Sep 17, 1985 · N3562G · Substantial damageNTSB CHI85LA381Accident · No injuriesLimited investigationFinal reportCessna 182Q · West Lafayette, INThe plt reported the acft bounced twice on touchdown. The final touchdown was hard and the nose wheel separated. The nose gear strut dug into sod resulting in substantial damage to the acft.Sep 17, 1985 · N97855 · Substantial damageNTSB ANC85LAA04Accident · No injuriesFinal reportPiper PA-22-160 · Fairbanks, AKThe left wing tip contacted the rwy and the left horizontal stabilizer contacted a sign following a loss on control during lanidng. The plt reported being aware of the right quartering x-wind but the acft bounced during the initial touchdown. The left wing…Sep 16, 1985 · N8525D · Substantial damageNTSB NYC85LA236Accident · No injuriesLimited investigationFinal reportBeech BE-55 · Danbury, CTThe plt stated that on touchdown the left main gear collapsed followed by the right main gear and nose gear. The acft slid aprx 600 to 700 ft before stopping. According to the plt he confirmed the gear was down and locked while on base. A gear cycle test…Sep 15, 1985 · N6429S · Substantial damageNTSB NYC85IA238Incident · No injuriesIncident investigationFinal reportBoeing 747-130 · Jamaica, NYThe acft was making a visual app to rwy 31R at Jamaica NY waen the bottom of the aft 60 ft of the fuselage made ground contact. The left outflow valve was scraped and the rear drain mast was separated. Part of the apr access door and several stringers &…Sep 15, 1985 · N780T · Minor damageNTSB MKC85LA216Accident · No injuriesLimited investigationFinal reportCessna 172M · Emporia, KSTwo plts were on board. The lt seat plt was making the landing when a gust of wind caused the acft to become misaligned with the rwy. The rt seat plt took control of the acft and attempted a go-around. The rt seat plt said he aimed for a clear spot btw trees…Sep 15, 1985 · N61624 · Substantial damageNTSB MIA85LA255Accident · No injuriesLimited investigationFinal reportCessna 172P · Wesley Chapel, FLThe rated private plt was received a check out in the acft by a CFI. The plt was having difficulty on the rwy as the winds were reported as 070 degs at 13 knts. The rwy being used was rwy 32. A 20 deg right x-wind tailwind condition existed. On the 4th touch…Sep 15, 1985 · N89989 · Substantial damageNTSB BFO85LA076Accident · No injuriesLimited investigationFinal reportCessna 401 · Cheswold, DEAfter landing on runway 27, the pilot slowed the aircraft to approximately 30 mph. The aircraft had rolled out about 1000 feet when the gear horn sounded and all three landing gear collapsed. The pilot reached for the gear switch, which was in the up…Sep 15, 1985 · N3298Q · Substantial damageNTSB SEA85LA214Accident · Minor injuriesLimited investigationFinal reportBell 206BII · Atlanta, IDA loss of pwr occurred shortly before touchdown. The left skid struck a rock during touchdown causing the acft to roll onto its right side. Twenty-five flt hrs prior to this flt an identical situation occurred and a loose air line to the fuel control was…Sep 14, 1985 · N58012 · DestroyedNTSB LAX85LA392Accident · No injuriesLimited investigationFinal reportNorth American P-51D · Reno, NVThe plt had completed a heat race as a participant in the Reno national championship air races and was landing in a gusty x-wind when the acft's left wing was lifted by the wind and the acft cartwheeled, resulting in substantial damage to the wings and to the…Sep 14, 1985 · N10607 · Substantial damageNTSB FTW85LRG02Accident · No injuriesFinal reportHomebuilt Tiger Bird · Kerrville, TXThe acft nosed over on landing following a loss of directional control. The plt reported touchdown was made on the first 100 ft of the rwy and as the acft slowed to aprx 10 mph directional control was lost. The acft traveled off the left side of the airstrip…Sep 14, 1985 · N5MF · Substantial damageNTSB CHI85LA380Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Bloomington, INThe piloted landed with an 80' left crosswind at 8 knots. During landing roll the wind picked up the left wing. The acft weathervaned into the wind & the right gear collapsed. The right wing was also damaged during the swerve.Sep 14, 1985 · N56349 · Substantial damageNTSB BFO85LA075Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Williamsburg, VAThe plt contacted the field on UNICOM frequency of 122.8 and was informed that the active rwy was 31, with wind from 040 degrees at 13 knots. The final approach was made with crab and power, but just prior to touchdown, the right wing lifted and the acft…Sep 14, 1985 · N2821Y · Substantial damageNTSB CHI85LA376Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Eden Prairie, MNThe student landed on rwy 9R with tower winds reported from 150 degrees at 15 knots. During the landing roll in the tailwheel equipped acft, control was lost and the acft tipped up on its left wing and nose.Sep 13, 1985 · N1290D · Substantial damageNTSB MKC85LA214Accident · No injuriesLimited investigationFinal reportCessna 152 · Olathe, KSThe student plt lost directional control of the acft while practicing touch & go landings. Winds in the local area were reported by fss as being from 110 degs at 12 KTS, gusting to 17 KTS. The plt lost control of the acft during a landing roll, ran off the…Sep 12, 1985 · N5269Q · Substantial damage