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 DEN85LTE05Accident · Minor injuriesFinal reportGordon Thorpe T-18 · Alamosa, COThe plt of the amateur built acft was on a flt to ashkosh, WI with an en route stop at pueblo, CO. Due to wx in the pueblo area, he diverted to Alamosa, CO. On his 1st apch to land on rwy 20, he made a go-around. On his 2nd apch, the acft landed long & at…Jul 26, 1985 · N633GG · Substantial damageNTSB DEN85LTE04Accident · No injuriesFinal reportWoolsey Quickie Q2 · Rawlins, WYAfter taking off, the plt noted that the acft's CG had shifted, & as fuel was consumed, the elevator down authority seem to decay. He suspected that baggage (stowed behind the plt's seat & inaccessible during flt) had shifted aft requiring greater than usual…Jul 25, 1985 · N66LW · DestroyedNTSB CHI85LA375Accident · No injuriesLimited investigationFinal reportCessna 172P II · Detroit, MIThe pilot was on a VFR VASI approach to the ATC controlled arpt 5091 ft runway. During ld round out the pilot said it feld like the acft was 'pushed' down onthe runway. The acft bounced and then ld on the nose wheel. The pilot said a helicopter was in a hover…Jul 25, 1985 · N6508K · Substantial damageNTSB CHI85LA313Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Valparaiso, INThe acft nosed over during landing. The plt said that he made a wheel lndg and after the acft slowed to 20 mph the tail lifted and the acft nosed over.Jul 25, 1985 · N2071K · Substantial damageNTSB NYC85LA192Accident · No injuriesLimited investigationFinal reportCessna P206D · Limerick, MEDuring the short field approach, as the aircraft passed over the tree line, the sink rate suddenly increased. The pilot applied power and increased the pitch but the aircraft touching down hard and bounced. A second touch down was made and as the nosewheel…Jul 23, 1985 · N8789Z · Substantial damageNTSB DEN85LA204Accident · No injuriesLimited investigationFinal reportBellanca 14-19-3 · Logan, NMThe plt lost directional control while landing on a gravel road. Subsequently, the acft was damaged when it veered to the right & went into a ditch.Jul 23, 1985 · N7685B · Substantial damageNTSB BFO85LA060Accident · No injuriesLimited investigationFinal reportCessna 152 · Charlottesville, VAThe student plt entered a left base for rwy 03, and according to a witness, made a hard landing on the main gear. After touchdown, the nose gear collapsed and the acft slid approximately 80 feet down the rwy.Jul 23, 1985 · N89432 · Substantial damageNTSB LAX85LA327Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Avalon, CAThe plt and a gnd witness reptd the acft touched down, main wheel first, in a smooth, soft manner. Upon touch down the nose gear collapsed. The acft slid for 200 ft before coming to rest. Examination of the nose gear assembly disclosed the gear actuator rod…Jul 22, 1985 · N2193Z · Substantial damageNTSB DEN85LA193Accident · No injuriesLimited investigationFinal reportCessna 182P · Missoula, MTThe pilot lost directional control during the touchdown phase of landing. The aircraft was substantially damaged when it veered off the runway and nosed over in the soft dirt.Jul 22, 1985 · N6375F · Substantial damageNTSB SEA85LA175Accident · No injuriesLimited investigationFinal reportCessna 150C · Chesaw, WAThe student plt landed on an unnamed, 1200 ft landing strip in calm wind conditions. He stated that during the landing, he misjudged the distance & overran the rwy. After departing the rwy, the acft encountered terrain with a tree root system & nosed over.Jul 21, 1985 · N1935Z · Substantial damageNTSB NYC85LA187Accident · No injuriesLimited investigationFinal reportCessna 152 · Marlboro, NJAccording to the pilot, the aircraft floated during the flare to touchdown. The pilot applied power for a go around, but the aircraft did not clear some bushes at the end of the runway. The aircraft landed straight ahead in a field and rolled about 300 feet…Jul 21, 1985 · N11BZ · DestroyedNTSB DEN85LA194Accident · No injuriesLimited investigationFinal reportCessna 170B · Kalispell, MTThe plt was returning from a local pleasure flt, it was a hot day. The plt said that he inadvertently leveled the acft aprx 10 ft high. He said the acft stalled causing a hard landing. The impact caused substantial damage to the acft.Jul 21, 1985 · N5414C · Substantial damageNTSB ATL85LA222Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-109B · Williamson, GAThe plt of the powered glider reported that during an apch to land, the acft encountered a downdraft & landed hard. The landing gear was damaged as well as the prop, eng cowling & oil cooler.Jul 21, 1985 · N5829T · Substantial damageNTSB NYC85LA190Accident · No injuriesLimited investigationFinal reportNew Standard D-25 · Rhinebeck, NYThe acft was moving at about 30 mph when the gear collapsed. According to the plt, the landing gear leg fitting failed causing the gear to collapse.Jul 20, 1985 · N176H · Substantial damageNTSB LAX85LA334Accident · No injuriesLimited investigationFinal reportMooney M20A · Compton, CAThe student plt had a total of 36 flight hrs which included 9.4 hrs in the monney acft. He had been authorized by his CFI, who flew with him the preceding day, to practice landing. On the student's first attempted ldg, he touched down hard & began porpoising.…Jul 20, 1985 · N8141E · Substantial damageNTSB FTW85LA292Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Chattanooga, OKThe plt lost directional control while landing in a crosswind and the acft ground looped after the left main landing gear contacted soft terrain alongside of the runway. The nearest official aviation weather reporting station was at lawton, OK, located 16…Jul 20, 1985 · N1642G · Substantial damageNTSB CHI85LA303Accident · No injuriesLimited investigationFinal reportBell 206BII · Farmington, MNDuring maneuvering to ld in an uncultivated fld the tail rotor struck a fence post,from a dismantled fence,that was concealed by high weeds. One tail rotor blade was separated,the pilot lost control,and on touchdown the helicopter rolled over.Jul 20, 1985 · N49737 · Substantial damageNTSB SEA85LA174Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Lebanon, ORThe plt stated he performed 4 circling approaches over a sand bar and on the 5th approcah, rotor RPM decayed. Unable to regain the RPM, a hard landing resulted during which the main rotor blades severed the tailrotor.Jul 19, 1985 · N9417A · Substantial damageNTSB SEA85LA173Accident · No injuriesLimited investigationFinal reportCessna 180G · Battle Mountain, NVWhile landing at Battle Mountain to refuel, the left main gear collapsed. The wind was reported to be from 360 deg a 18 gusting 30 KTS.Jul 19, 1985 · N5252D · Substantial damageNTSB DEN85LA191Accident · No injuriesLimited investigationFinal reportCessna 172 · Sykeston, NDThe plt said he made a normal landing on an aerial application airstrip. During the rollout the plt spotted an unmarked mail box. The plt said he swerved to avoid colliding with the mail box. The acft went off the side of the strip and into a field. The plt…Jul 19, 1985 · N739GA · Substantial damageNTSB BFO85LA059Accident · No injuriesLimited investigationFinal reportCessna 182RG · Stevensville, MDAfter landing to the left of the centerline of rwy 10, the acft veered left off the rwy and collided with a drainage ditch located approximately 10 yards from the rwy. Following contract with the ditch, at approximately 15 mph, the acft flipped over, coming…Jul 19, 1985 · N737XD · Substantial damageNTSB NYC85LA182Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Livingston, NYThe acft departed the right side of the rwy where it collided with a corn crop during a landing roll. The acft owner, a pvt plt, stated a mechanic on board was flying at the time of the accident. The mechanic stated that the owner was at the controls when the…Jul 18, 1985 · N5739H · Substantial damageNTSB NYC85LA180Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Bedminster, NJN4319F heard NG138J announce its position in the traffic pattern throughout the approach and landing. N4319F landed on runway 30 and was taxiing back to the ramp on the parallel taxiway. The occupant of N4319F observed N6139J land about midway down the runway…Jul 18, 1985 · N6139J · 2 aircraft · Substantial damageNTSB MKC85LA161Accident · No injuriesLimited investigationFinal reportCessna 180G · Harrison, ARThe plt stated that during a wheel landing, the acft bounced, but not hard. He reported that he applied sufficient power to recover & made a smooth, 3-point touchdown, then the acft began a gradual skidding turn to the right. The plt corrected with left…Jul 18, 1985 · N4734U · Substantial damageNTSB SEA85LA169Accident · No injuriesLimited investigationFinal reportCessna 185F · Boise, IDThe acft ground looped and the left main gear collapsed during a landing roll. The plt reported that the left wing came up during the landing roll which resulted in the acft veering to the right. When the wing settled, the left main gear collapsed allowing…Jul 17, 1985 · N4309R · Substantial damageNTSB NYC85LA175Accident · No injuriesLimited investigationFinal reportGrumman AA-1C · Farmingdale, NYThe plt was performing a series of touch and go landings at republic arpt when the accident occurred. During the final landing, a hard touch down was made which resulted in a porpoised landing.Jul 17, 1985 · N333FY · Substantial damageNTSB NYC85FNC05Accident · Serious injuriesFinal reportBarnes AX7 · Gorham, METhe pilot took off with three passengers in a hot air balloon. There was an unforecast wind change with an increase in velocity. This change in wind direction and velocity precluded the ability to make a landing and keep the basket upright. When the basket…Jul 17, 1985 · N15314 · No damageNTSB MKC85LA160Accident · No injuriesLimited investigationFinal reportCessna 180J · Fort Dodge, IAN180DH was landing on a 6,547 x 150 ft, dry, asphalt, runway with a lt quartering headwind at 15, with gust to 20 KTS. The plt said he made a full flap, full stall, 3PT, landing. The acft was aligned with the rwy centerline but after a short roll the acft…Jul 17, 1985 · N180DH · Substantial damageNTSB DEN85LA192Accident · No injuriesLimited investigationFinal reportCessna 170B · Missoula, MTThe pilot stated that he did not use proper technique and did not maintain directional control while landing in a brisk and direct crosswind. The airplane was substantially damaged in the hard landing that was followed by a ground loop.Jul 17, 1985 · N8252A · Substantial damageNTSB ATL85LA218Accident · No injuriesLimited investigationFinal reportCessna 177 · Stanton, KYThe pilot reported that during takeoff, he believed that the flight controls were not responding to control inputs. Moments after lift-off, he aborted the takeoff. The airplane continued off the departure end of the runway, where the nose gear and engine…Jul 17, 1985 · N3150T · Substantial damageNTSB SEA85LA172Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Moses Lake, WAA ground loop occurred during landing roll on rwy 36. The wind at touchdown was from 210 degs at 5 KTS. The twr did give the plt the current wind when the controller cleared him to land. The plt was aware that he would be landing with a left quartering tail…Jul 16, 1985 · N36137 · Substantial damageNTSB NYC85LA176Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Hookstown, PAThe instructor and student were practicing normal takeoffs and landings. According to the pilot, on the sixth landing, at the correct airspeed, the aircraft touched down on the main gear and then the noise wheel collapsed. The aircraft then nosed over.…Jul 16, 1985 · N5322Z · Substantial damageNTSB MIA85IA211Incident · No injuriesIncident investigationFinal reportCessna R182 · Jacksonville, FLThe plt stated that he made a normal touchdown & on his landing rollout the nose gear collapsed. The landing gear was cycled several times after this occurrence & no abnormality was observed. No determination could be made of the malfunction of the landing…Jul 15, 1985 · N6289T · Minor damageNTSB NYC85LA170Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Provincetown, MADuring arrival, the acft was vectored for an ILS rwy 7 apch which was made with a tail wind. On his 1st attempt, the plt made a missed apch & was vectored for another ILS. After making a 2nd apch, he landed. The plt stated that while he was landing, he…Jul 14, 1985 · N8210H · Substantial damageNTSB NYC85FA166Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Tioga, PAThe plt initiated a downwind landing on a grass rwy that sloped mostly uphill, but began sloping downhill at its departure end. A witness near the apch end of the 2150 ft rwy watched the acft touch down beyond its midpoint, then disappear over its crested…Jul 14, 1985 · N7934P · DestroyedNTSB LAX85LA317Accident · No injuriesLimited investigationFinal reportRobinson R-22A · Piru, CAThe flight instructor instructed the 25-hour student plt to perform an autorotation with a pwr recovery at 20 ft AGL. The instructor became aware too late that the student was 'dead locked' on the controls and he was unable to recover prior to touchdown. A…Jul 14, 1985 · N85594 · Substantial damageNTSB CHI85LA286Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Appleton, WIAs the plt applied brakes during a full stop landing, the right brake failed. The plt then maneuvered the acft off the paved landing surface in an attempt to get it to roll to a stop. The right landing gear strut collapsed. The acft then slid into a fence and…Jul 14, 1985 · N4137F · Substantial damageNTSB ATL85LA212Accident · No injuriesLimited investigationFinal reportCessna 182C · Lugoff, SCThe plt transported a load of skydivers to alt & was returning to the airstrip. During arrival, he decided to practice a simulated eng out landing. While on an apch with full flaps, the plt elected to slip the acft. As he was transitioning from a side slip to…Jul 14, 1985 · N8472T · Substantial damageNTSB ATL85LA211Accident · No injuriesLimited investigationFinal reportCessna 172 M · Statesville, NCWhile en route, the plt encountered reduced visibility & had difficulty finding the airstrip. His 1st apch to land was high & he made a go-around. The plt landed on his 2nd attempt, but was unable to stop on the wet grass rwy. He delayed attempting a…Jul 14, 1985 · N12334 · Substantial damageNTSB NYC85LA167Accident · Minor injuriesLimited investigationFinal reportPiper PA28-151 · Chatham, MADuring the final approach to runway 24, the aircraft was too high and fast. The pilot decided to land on the runway instead of going around. According to the pilot, the aircraft landed too FAR down the runway and went over the end.Jul 13, 1985 · N5405F · Substantial damageNTSB CHI85LA287Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Stoughton, WIUpon landing following a normal 70 knot final approach the aircraft initially touched down one-third of the way down the 2500 ft grass runway. A bounce carried the aircraft to a point halfway down the runway where the aircraft landed in a full stall. The…Jul 13, 1985 · N47677 · Substantial damageNTSB ATL85LA215Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Owensboro, KYThe plt had a single eng land rating & was preparing for a multi-eng check ride. While practicing a touch-&-go landing, the acft bounced. The plt applied power, made a go-around & landed without further incident. However, during a post-flt exam, substantial…Jul 13, 1985 · N3001S · Substantial damageNTSB ANC85LA131Accident · No injuriesLimited investigationFinal reportCessna 180 · Barrow, AKThe plt reported that when he returned to the arpt, he made a 3-point landing in gusty x-wind conditions. Reportedly, the acft then ground looped & was damaged. At 1534 adt, the wind at Barrow was from 050 deg at 13 gusting 18 KTS.Jul 13, 1985 · N9164T · Substantial damageNTSB FTW85FA283Accident · No injuriesField investigationFinal reportGates Learjet 35A · Fort Worth, TXThis acft ran off the departure end of the 4001' runway following a normal approach, touchdown and initial braking. After about 1000' of norm braking, the acft began a drift to the right which was partially overcome by full left rudder and asymmetrical…Jul 12, 1985 · N613RR · Substantial damageNTSB SEA85LA161Accident · No injuriesLimited investigationFinal reportMooney M20-F · Salem, ORThe acft was substantially damaged during an inadvertant gear-up landing. Inspection of the acft revealed the landing gear circuit breaker was popped. When functionally tested, the landing gear operated normally. The gear warning horn was found to be…Jul 11, 1985 · N6879V · Substantial damageNTSB NYC85LA165Accident · No injuriesLimited investigationFinal reportBeech C23 · Penn Yan, NYThe plt was familiar with the arpt, during the landing the plt observed the wind sock indicating calm winds and the acft was landed into the sun. During the landing roll, pwr was added for takeoff. When the acft was aprx 2/3 the way down the rwy, the plt…Jul 11, 1985 · N6704L · Substantial damageNTSB NYC85LA164Accident · No injuriesLimited investigationFinal reportCessna 182M · Block Island, RIThe plt was checked out in the C-182 on July 9, 1985 and had flown this acft for 1 hr in the previous year. During a normal power off landing with ten degrees of flaps extended, the plt added power and noticed no change in performance. The acft touched down…Jul 11, 1985 · N71359 · Substantial damageNTSB NYC85FA163Accident · No injuriesField investigationFinal reportMitsubishi MU-2B-26 · Southbridge, MADuring lndg the acft impacted hard and skidded down the rwy before it went off the left side of the rwy. The left main wheel separted and the nose gear collapsed. Both plts stated the lndg apch was normal until the acft was aprx 15 ftabove the rwy at which…Jul 11, 1985 · N727MA · DestroyedNTSB MKC85LA153Accident · No injuriesLimited investigationFinal reportCessna 172M · Olathe, KSPlt stated that she used left aileron and right rudder for x-wind correction and did not release the rudder pressure on touchdown. The acft went off side of rwy, crossed a taxiway, went down an embankment and through a fence into a plowed field where it nosed…Jul 11, 1985 · N13064 · Substantial damageNTSB FTW85LA284Accident · No injuriesLimited investigationFinal reportGrumman AA5B · Sonora, TXWhile landing at an unfamiliar strip, the plt observed a rough surface at the apch end, and landed one halfway down the down-sloping 2300 ft rwy. He tried to go around, but could not accelerate enough, and the acft rolled thru 2 fences, trees, then stopped…Jul 11, 1985 · N4520B · Substantial damage