OpenAirDocs.org

NTSB investigations

53,703 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 DEN87LA198Accident · No injuriesLimited investigationFinal reportCessna 152 · Watkins, COThe plt was practicing touch-and-go landings on rwy 26. He estimated the wind to be 180 deg at 8 KTS. The plt said that on the third landing attempt, a 15 kt gust of wind caused the acft to drift to the right. He attempted to correct with left aileron and…Jul 25, 1987 · N52MA · Substantial damageNTSB LAX87LA278Accident · No injuriesLimited investigationFinal reportCessna 182A · Strathmore, CADuring a cross country flight, upon landing, the aircraft touched-down approx 500 ft from the approach end of the rwy. The plt lost directional control of the acft when he stated that the brakes failed to respond. The runway on which the acft landed is approx…Jul 24, 1987 · N3884D · Substantial damageNTSB FTW87FA174Accident · 1 fatalField investigationFinal reportCessna 421C · Crystal City, TXThe pilot landed downwind on his private strip. The exact amount of the tailwind could not be determined. A thunderstorm was located just to the east of the runway and could have readily given N448 a strong tailwind. The aircraft touched down 390 feet beyond…Jul 24, 1987 · N448 · DestroyedNTSB NYC87LA208Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Bedford, MADuring a practice autorotation with power recovery, the rotor RPM bled off. Directional control was lost and the helicopter turned several times before hitting the ground. The helicopter rolled to the left and came to rest on its side.Jul 22, 1987 · N8384F · Substantial damageNTSB MKC87LA146Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbia, MOThe instructor and the student were making a landing on a short grass runway. The instructor stated they landed fast and were not able to stop. He considered a go-around but decided sufficient runway did not remain to perform the go-around. The airplane…Jul 22, 1987 · N47354 · Substantial damageNTSB LAX87LA277Accident · No injuriesLimited investigationFinal reportCessna A185F · Chandler, AZThe CFI indicated that the tailwheel began to shimmy during rollout. As forward control yoke pressure was applied the shimmy went away, however, as the acft began to slow down, the tailwheel was lowered and began to shimmy again. As the acft continued to slow…Jul 22, 1987 · N252W · Substantial damageNTSB CHI87LA179Accident · No injuriesLimited investigationFinal reportCessna 152 · Detroit, MIOn touchdown the aircraft ballooned and bounced up about 5-7 feet off the runway. The aircraft then landed on the nose wheel and the prop struck the ground.Jul 22, 1987 · N757JG · Substantial damageNTSB ATL87LA221Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Edmund, SCThe CFI stated that he was having the pre solo student make a crosswind ldg after an hours practice at another apt. The student was using the slip method to correct for the crosswind. Touchdown was with a side load on the gear and the acft bounced. The CFI…Jul 22, 1987 · N45648 · Substantial damageNTSB ATL87LA220Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Columbus, OHThe plt experienced a loss of directional control on ldg as the tailwheel touched down, and he executed a go-around. On the 2nd ldg attempt, the airplane veered off the rwy, traveled across a grassy area, and impacted a parked C-172. Post-crash exam of the…Jul 21, 1987 · N443WB · Substantial damageNTSB CHI87DEP09Accident · No injuriesFinal reportAyres 600S-2D · Bancroft, WIOn landing the aircraft veered to the right. Application of left brake and rudder did not arrest the turn. The aircraft impacted a fence post rendering substantial damage to the aircraft. Subsequent investigation revealed an axle spacer on the right wheel was…Jul 20, 1987 · N4436F · Substantial damageNTSB FTW87LA172Accident · No injuriesLimited investigationFinal reportCessna 172K · Brenham, TXThe student pilot lost directional control during the landing roll. The aircraft veered off the runway and nosed over to the inverted position when the nose gear dropped into a hole hidden by tall grass.Jul 19, 1987 · N84861 · Substantial damageNTSB BFO87LA052Accident · No injuriesLimited investigationFinal reportMooney M-20C · Basye, VAWhen the pilot applied brakes during the landing roll the acft swerved left. He applied the right brake to straighten the acft and the acft swerved right. The pilot attempted to correct with left brake and the right main gear collapsed. No malfunctions were…Jul 19, 1987 · N6769U · Substantial damageNTSB ATL87LA218Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Foley, ALThe student plt failed to maintain directional control during a crosswind ldg on rwy 36. The airplane drifted to the left of the runway and subsequently impacted trees. The student plt was on his second unsupervised solo flight. He reported that he did not…Jul 19, 1987 · N4808T · Substantial damageNTSB LAX87LA274Accident · No injuriesLimited investigationFinal reportCessna 182Q · Upper Lake, CAJul 18, 1987 · N97061 · Substantial damageNTSB LAX87DVA08Accident · No injuriesFinal reportHastings Thorp T18 · Patterson, CAAt the end of a pleasure flight, the aircraft was landing with a 90 degree crosswind with a velocity of approximately 20 mph. During the landing roll, the aircraft ground looped, ran off the runway and nosed over. There were no reported mechanical failures or…Jul 18, 1987 · N50RH · Substantial damageNTSB DEN87LA187Accident · No injuriesLimited investigationFinal reportBeech 58 · Pagosa Springs, COThe plt attempted to land his acft at night at an airport with inoperative runway lights and using a ground vehicle's headlights to aid him in landing. He stated that he touched down his aircraft to the left of the center of the runway and the left landing…Jul 18, 1987 · N1879L · Substantial damageNTSB DEN87LA185Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Grandforks, NDThe commercial plt was flying cross country on a personal flight. After takeoff during gear retraction, a loud noise was heard in the cockpit. Upon reaching the first destination, the plt attempted gear down but gear did not extend. Manual extension was…Jul 17, 1987 · N7722Y · Substantial damageNTSB CHI87LA171Accident · No injuriesLimited investigationFinal reportBeech 23 · Danville, ILThe plt landed long and downwind on a sod farm strip. The acft ran off the departure end of the fld and struck trees.Jul 17, 1987 · N6562T · Substantial damageNTSB NYC87LA243Accident · No injuriesLimited investigationFinal reportBeech C24R · Danbury, CTDuring a landing at late dusk, the aircraft collided with a deer that darted onto the runway. The pilot said there was no time to take evasive action before the collision. The left wing and left gear door were damaged and the left fuel tank was ruptured.Jul 16, 1987 · N1997L · Substantial damageNTSB NYC87LA207Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Andover, NJThe pilot lost directional control during landing roll. As the aircraft drifted left of the runway, power was added for a go-around but the aircraft was left of the rwy. The left wing strut hit the wing of a Cessna 150 in an attempt to avoid colliding with…Jul 16, 1987 · N6346 · DestroyedNTSB NYC87DNC09Accident · No injuriesFinal reportDubois Beta Bird · Biddeford, METhe pilot was practicing takeoffs and landings in his homebuilt aircraft. Directional control of the aircraft was lost after it touched down during a landing. Subsequently, it swerved off the side of the runway, went in an area of tall grass & hit a ditch,…Jul 16, 1987 · N3954D · Substantial damageNTSB DEN87LA184Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Devils Lake, NDThe pvt plt, an A&P mechanic, was commuting home from the local airport in his aircraft. Upon landing, the main gear sank into soft soil and the acft nosed over.Jul 16, 1987 · N11024 · Substantial damageNTSB CHI87LA168Accident · No injuriesLimited investigationFinal reportCessna 152 · Savoy, ILA student pilot was on his initial solo flight and had been instructed to do touch and go landings. On his second landing he did not achieve a proper flare attitude, the aircraft touched down flat and fast and began to porpoise. After approximately three…Jul 16, 1987 · N4967B · Substantial damageNTSB ATL87DEI10Accident · No injuriesFinal reportCessna 152 · Kent, OHThe student plt was on his third solo flight. As he was flaring to land, the aircraft ballooned twice and he initiated a recovery by adding power. However, the airplane settled and contacted the runway with the nosewheel first, damaging an engine mount &…Jul 16, 1987 · N95469 · Substantial damageNTSB MKC87LA140Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Adams, NEAfter a normal approach and landing on a private sod strip, the pilot stated the aircraft swerved to the left of the runway to an adjoining plowed field. The aircraft struck a large hay bale followed by a large mound of dirt. Post accident investigation…Jul 15, 1987 · N8097S · Substantial damageNTSB BFO87LA047Accident · Minor injuriesLimited investigationFinal reportHiller FH-1100 · Capron, VAThe plt made a 60 mph power descent landing apch. When the helicopter descended to a height of about 10 ft AGL, the plt raised collective and applied left rudder pressure. The helicopter abruptly turned right. According to the plt, the helicopter did not…Jul 15, 1987 · N590FH · Substantial damageNTSB ATL87LA214Accident · No injuriesLimited investigationFinal reportCessna 150J · Higginsport, OHThe pilot reported that the aircraft skidded off the runway into a piece of parked farm equipment. The sod runway surface was wet. The pilot further reported that the right wing rose and the a/c veered off the runway. The pilot was unable to maintain…Jul 15, 1987 · N61107 · Substantial damageNTSB DEN87LA181Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Worland, WYThe plt said the acft bounced during landing and he lost control. The acft ran off the rwy and when the plt applied the brakes too hard, the acft nosed over.Jul 14, 1987 · N4237Z · Substantial damageNTSB CHI87LA169Accident · No injuriesLimited investigationFinal reportCessna 172 · Madison, WIThe instructor (CFI) & pvt plt (student) were on a renter's check-out flt to familiarize the student with a Cessna 172. While practicing landings, tower psnl provided a windshear alert. Drg an apch to land, the acft went into a high sink rate over the apch…Jul 14, 1987 · N2501L · Substantial damageNTSB NYC87LA203Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Mattituck, NYDrg arrival, the plt tried to contact UNICOM, but was unable. He said he circled the 2200 ft rwy, but was unable to see the windsock due to reduced visibility with haze. He elected to land on rwy 19. The acft touched down about 500' from the departure end.…Jul 13, 1987 · N36509 · Substantial damageNTSB LAX87DUG05Accident · Serious injuriesFinal reportEipper Quicksilver MX II · Corona, CAWhile attempting to land on runway 25 at the Corona airport, Corona, California, in gusting wind conditions, the aircraft stalled and collided with the terrain. The pilot said that the 'extreme gusty wind conditions' combined with a very light and stable…Jul 13, 1987 · N4628G · Substantial damageNTSB SEA87LA156Accident · No injuriesLimited investigationFinal reportBoeing IB75A · Spokane, WAThe plt rprtd that when he landed, the wind was from 190 deg at 6 gusting 12 KTS. Drg the landing roll, after slowing to an estimated 15 KTS, the acft encountered a gust of wind which caused 'the right wing to dip.' Subsequently, the acft 'rotated' about 60…Jul 12, 1987 · N400JT · Substantial damageNTSB CHI87LA166Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Chelsea, MIThe pilot and three passengers attempted a takeoff from a 1800 foot sod, upsloping runway with tall, wet grass. Density altitude was 2700 feet. As the aircraft climbed out of ground effect the pilot said the engine sounded 'funny' and aborted the takeoff. The…Jul 12, 1987 · N2904A · Substantial damageNTSB LAX87LA270Accident · No injuriesLimited investigationFinal reportCessna 172P · Grass Valley, CADuring a pleasure flight, while attempting to land at the airport, the pilot made a go around because he was too high. On the second approach, the pilot noted that he may have been a little high and fast. During the landing the aircraft bounced three times…Jul 11, 1987 · N5259K · Substantial damageNTSB ANC87LA094Accident · No injuriesLimited investigationFinal reportCessna 185 · Aleknagik, AKThe commercial pilot and his three passengers were on a fishing trip to a remote stream in southwest Alaska. The pilot attempted to land on a beach area near the stream and nosed the airplane over. The airplane was equipped with large 'tundra' tires that the…Jul 11, 1987 · N5430R · Substantial damageNTSB MKC87LA135Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Waldron, ARThe plt said he was on a x-country for his commerical cert. He checked enroute wx for the return trip and was told VMC prevailed. However he rptd that he encountered haze & clouds. He let down to VMC but after he got in the clear all he could see was…Jul 10, 1987 · N5921U · Substantial damageNTSB MKC87LA134Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Benton, ARDuring a positioning flt to pick up revenue passengers, PIC neglected to lower ldg gear for ldg. Acft was substantially damaged. PIC stated he forgot to lower gear and no warning horn had activated.Jul 10, 1987 · N4JD · Substantial damageNTSB FTW87DRA05Accident · No injuriesFinal reportCessna A188B · El Campo, TXWhile attempting to land, the aircraft's left wing contacted the edge of a corn field. The aircraft veered to the left and impacted the ground causing substantial damage.Jul 10, 1987 · N731LP · Substantial damageNTSB LAX87LA259Accident · No injuriesLimited investigationFinal reportCessna 150M · Cameron Park, CADuring a pleasure flt, the non certificated plt landed the acft short of the rwy when he mistook a road for the rwy. The plt stated that the sun was in his eyes and by the time he realized that he was not landing on the rwy the acft was too low and slow to go…Jul 9, 1987 · N3811V · Substantial damageNTSB DEN87LA176Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Bountiful, UTThe private pilot was practicing touch and go landing. The pilot reported the third landing was a wheel landing. Just after touchdown, adjacent to large petroleum tanks, the aircraft weather cocked to the right. The aircraft swerved right and departed the…Jul 9, 1987 · N8362H · DestroyedNTSB ATL87LA207Accident · Serious injuriesLimited investigationFinal reportAerostar RX-7 · Crestwood, KYThe balloon contacted power lines as it was beginning to climb after an aborted ldg attempt. Electrical arcing ignited the propane fuel supply on board. The sole-occupant student plt jumped from the burning balloon and fell approx 40 ft onto a fence. The…Jul 9, 1987 · N2897H · Substantial damageNTSB ATL87LA206Accident · No injuriesLimited investigationFinal reportCessna 172I · Goodway, ALThe plt rprtd that he lndd long on a 2500 ft grass strip which was wet due to hvy dew. Drg the apch, he had an airspeed of 75 to 80 KTS with 30 deg of flaps. Subsequently, the acft slid off the departure end & struck a pecan tree. The recommended final apch…Jul 9, 1987 · N46233 · Substantial damageNTSB SEA87LA136Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Lester, WADuring landing roll onto the closed runway the aircrafts right wingtip struck a post. The airport was notamed closed but no x's had been marked on the runway.Jul 8, 1987 · N85591 · Substantial damageNTSB LAX87LA262Accident · No injuriesLimited investigationFinal reportPiper PA-31T2 · Novato, CAAt the end of a cross country flt, the plt reported that he had extended the landing gear aprx 5 miles from the arpt and lowered partial flaps. Aprx 2 miles from the arpt the plt made shallow s turns for spacing and extended the rest of the flaps. The plt…Jul 8, 1987 · N38WA · Substantial damageNTSB LAX87IA260Incident · No injuriesIncident investigationFinal reportMBB BK117A-3 · Cupertino, CAA Mbb BK117A-3 helicopter collided with wires while on final approach to an asphalt road in close proximity to a traffic accident. Night VMC prevailed at the time. The pilot indicated that he did not see the wires and was unaware of the collision until he was…Jul 8, 1987 · N160BK · Minor damageNTSB DEN87LA183Accident · No injuriesLimited investigationFinal reportCessna T188C · Winnett, MTDuring landing on a roadway used by the crop-duster for re-loading chemicals for spraying, the left spray boom contacted vegetation and slewed the acft sideways. The right wing was bent and the propeller was damaged.Jul 8, 1987 · N2058J · Substantial damageNTSB SEA87LA133Accident · No injuriesLimited investigationFinal reportMooney M-20 · Spokane, WAAt touchdown a prop strike occurred. The pilot immediatley added full power to go around. Since the prop strike was severe full power was not available. The pilot made a shallow 180 degree turn back to the rwy and landed on the grass. During the landing…Jul 6, 1987 · N5265B · Substantial damageNTSB SEA87LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Sun Valley, IDAfter landing touchdown, plt encountered swirling winds. Acft drifted left and into airport boundary (cyclone-type) fence.Jul 5, 1987 · N3438M · Substantial damageNTSB FTW87LA159Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Dallas, TXDuring flare/touchdown on runway 15, the aircraft's right wing came up sharply, due to a gusting cross wind, causing the left wing to strike the runway. The aircraft then cartwheeled, left wing, nose, right wing, causing substantial damage. Reported winds at…Jul 5, 1987 · N56420 · Substantial damageNTSB CHI87LA161Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Duluth, MNRprtdly, the winds were prevailing from the northeast & were variable & gusty. The plt entered the traffic pattern to land on rwy 14, but aborted his 1st attempt. During the 2nd apch, he used a notch of flaps & corrected for the x-wind by slipping the acft…Jul 5, 1987 · N56808 · Substantial damage