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 LAX87LA193Accident · No injuriesLimited investigationFinal reportCessna 180 · Fullerton, CAThe pilot reported that a gust of wind turned the aircraft left just prior to touchdown on runway 24. He was unable to maintain directional control during the landing roll and the aircraft ran off the left side of the runway. The reported surface winds were…Apr 26, 1987 · N2936C · Substantial damageNTSB FTW87LA106Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXA student pilot on a solo flight in the local area, lost control of the aircraft while practicing touch and go landings. Substantial damage occurred when the aircraft slid off the rt side of the rwy into a ditch, causing the aircraft to nose over inverted.Apr 26, 1987 · N5100Q · Substantial damageNTSB NYC87LA133Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · W.Mifflin, PAPilot made a landing on runway 10 at the allegheny county airport, however during landing roll the pilot lost directional control of the aircraft. The acft swerved right and collided with a cast iron sewer that was raised about 6' above the ground.Apr 25, 1987 · N7726W · Substantial damageNTSB MIA87LA146Accident · No injuriesLimited investigationFinal reportCessna 172P · Daytona Beach, FLThe plt stated that during the landing roll, after depressing both brakes evenly, the rt brake locked up causing the acft to leave the rwy. The arpt was Beach regional airport, Daytona Beach, Florida, the acft collided with a taxiway marker sign & came to…Apr 25, 1987 · N129ER · Substantial damageNTSB MIA87LA145Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Rolling Fork, MSWhile landing downwind, at an alt of aprx 20 feet, the helicopter began to settle with power. The pilot then attempted to stop the descent, however, because of insufficient alt & airspeed, was unable. The helicopter then landed hard, rolled over, after which,…Apr 25, 1987 · N202CH · Substantial damageNTSB ATL87LA144Accident · No injuriesLimited investigationFinal reportSpartan 7W · Sumter, SCThe plt reported that the airplane began to turn to the left after ldg when the tailwheel touched down; subsequent efforts to counteract the turn were not successful. The airplane ran off the side of the rwy and hit a depression in the terrain, collapsing the…Apr 25, 1987 · N13PH · Substantial damageNTSB CHI87LA116Accident · No injuriesLimited investigationFinal reportCessna 172XP · Superior, WIUpon landing on runway 13, pilot reports wind blowing aircraft towards the edge of runway. Aircraft went off right side, nose wheel stuck in mud and collapsed, and aircraft nosed over. Winds at duluth, MN, approx. 11 nmi northwest of accident site, were…Apr 24, 1987 · N5093V · Substantial damageNTSB ANC87LA062Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Theodore River, AKThe pilot stated that during the landing roll on the gravel bar he lost directional control of the aircraft causing the aircraft to nose over on its back.Apr 24, 1987 · N9597S · Substantial damageNTSB MKC87LA088Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Lincoln, KSThe plt was spraying 2/4/D when one spray nozzle stuck open. Rather than kill alfalfa and trees during the turnarounds, the plt elected to land on a dirt road and repair the nozzle. He misjudged the width of the road and on touchdown, the right wing touched…Apr 23, 1987 · N8802B · Substantial damageNTSB MIA87LA144Accident · No injuriesLimited investigationFinal reportCessna 152 · Arcadoa, FLDuring the landing roll the plt diverted his attention from taxiing the acft to raising the flaps and turning off the carb heat. The rt wing was then lifted by the cross wind, after which, the plt applied excessive rt rudder. The acft left the rwy, fell into…Apr 23, 1987 · N49832 · Substantial damageNTSB LAX87LA197Accident · No injuriesLimited investigationFinal reportCessna 172P · Huntingtonbeach, CAOn touchdown the plt reported that the acft bounced twice. The plt initiated a go-around by retracting the flaps and adding full power. The acft did not gain enough altitude before colliding with a quonset hut located 210 feet from the end of the runway.Apr 23, 1987 · N54978 · Substantial damageNTSB FTW87LA109Accident · No injuriesLimited investigationFinal reportCessna 172G · Houston, TXA student pilot on a solo flight in the local area, landed long and ran off the end of the runway. The pilot stated that the accident occurred due to touchdown too FAR down the runway. He further related that the presence of high tension wires influenced his…Apr 23, 1987 · N1107F · Substantial damageNTSB ATL87DKG01Accident · Serious injuriesFinal reportAir Tractor AT301 · Atmore, ALDuring landing the aircraft collided with a tractor mowing grass on the runway. The pilot stated that the sunglare on final prevented him from seeing the vehicle on the runway. The tractor's operator apparently did not hear the aircraft because he made no…Apr 22, 1987 · N4346S · Minor damageNTSB NYC87LA132Accident · No injuriesLimited investigationFinal reportDornier DO-228-201 · Manchester, NHVibration was experienced shortly after touchdown caused by the failure of the propeller blade as a result of fatigue cracking which was initiated from a linear area in a defect free portion of the camber face of the blade. Propagation was through 60% of the…Apr 21, 1987 · N232RP · Substantial damageNTSB DEN87LA109Accident · No injuriesLimited investigationFinal reportCessna 150J · Longmont, COA student plt was practicing landings on her second supervised solo training flt. On the first approach, she failed to flare properly and hit in a three point attitude. The nose gear collapsed and the propeller struck the rwy. The acft skidded about 25 feet…Apr 21, 1987 · N60282 · Substantial damageNTSB DEN87LA108Accident · No injuriesLimited investigationFinal reportCessna 182C · Conde, SDThe private plt was making a landing to a gravel road during a business flt. This same road landing area had been used frequently. The winds were estimated by the plt as 030 degrees at 17 knots, gusting to 24 knots. The approach and landing was to the west on…Apr 21, 1987 · N9069T · Substantial damageNTSB MKC87LA084Accident · No injuriesLimited investigationFinal reportThorp T-18 · Bowling Green, MOThe PIC rptdly encountered a gust of wind during the landing flare. The PIC lost control as one main landing gear impacted the ground abruptly and his head hit the side of the canopy. The acft veered off the side of the rwy into tall grass and soft terrain.…Apr 20, 1987 · N218HW · Substantial damageNTSB MKC87FA085Accident · 2 fatalField investigationFinal reportCessna 152 · Marion, IAThe CFI and stu were practicing approaches to the Marion, Iowa arpt. Several witnesses stated that the t & g lndgs were unusual which gained their attn. On the last appch the acft was observed to be slow during the unusually steep appch. Abt 15 to 20 ft AGL…Apr 20, 1987 · N67751 · Substantial damageNTSB LAX87LA210Accident · No injuriesLimited investigationFinal reportCessna 172M · Hawthorne, CADuring a solo instructional flight, the student pilot was practicing touch and go landings. He noticed as the flight progressed, that there was some gusting conditions aloft and that the wind direction was varying. On the last landing the aircraft touched…Apr 20, 1987 · N73614 · Substantial damageNTSB LAX87LA186Accident · No injuriesLimited investigationFinal reportCessna 310Q · Lower Lake, CAA Cessna 310Q overran rwy 30 and collided with terrain off the departure end. A witness stated the acft landed at aprx mid-field on the 2,485 ft by 50 ft asphalt rwy and was unable to stop. Based on the witnesses' statement aprx 1,240 ft would be available…Apr 20, 1987 · N69628 · Substantial damageNTSB LAX87LA183Accident · No injuriesLimited investigationFinal reportCessna 152 · Long Beach, CAWhile making practice landings, the student pilot failed to maintain flying speed during the final stages of his second approach. The aircraft stalled inadvertently about 15 feet above the runway and landed hard on the nose wheel.Apr 19, 1987 · N25331 · Substantial damageNTSB LAX87DVG03Accident · No injuriesFinal reportGrumman G-164B · Marysville, CAAt the end of an aerial application flt, the plt was aware of a cross wind from the right. The plt touched the acft down on the right main landing gear and held that attitude for aprx 300 ft down the rwy. When the left main gear contacted the rwy it folded…Apr 18, 1987 · N8412K · Substantial damageNTSB FTW87LA098Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Waring, TXThe newly certificated private pilot landed on runway 17 at a small privately owned airport at Waring, TX. There was a wire fence located 18 feet from the left edge of the landing runway. The pilot allowed the aircraft to drift left off the runway and collide…Apr 18, 1987 · N2140D · Substantial damageNTSB SEA87LA081Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Alderwood, WAThe student pilot took off and landed with a 15 knot tailwind. During his second attempt to land an overun occurred. The aircraft departed the runway to the left onto soft ground where it nosed over inverted. This was the student pilots second solo flight.…Apr 15, 1987 · N5437Q · Substantial damageNTSB NYC87LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · Manchester, NHThe Cessna 152 was making a touch and go on rwy 35 with the winds reported to be 170 degrees at 11 knots. The pilot lost control after touchdown and veered off the runway to the left. The aircraft struck a runway light and flipped over receiving substantial…Apr 15, 1987 · N24784 · Substantial damageNTSB DEN87LA099Accident · No injuriesLimited investigationFinal reportMaule M-5-180 · Erie, COThe private plt had completed a landing from a business flt. On landing roll a strong wind gust from the left caused the aircraft to turn left. The plt added full pwr and the acft departed the rwy to the left. The acft was turned back to the right and crossed…Apr 15, 1987 · N84KG · Substantial damageNTSB SEA87LA078Accident · No injuriesLimited investigationFinal reportCessna 185 · Burnett Inlet, AKThe plt left the landing gear in the down position after takeoff. During the water landing, with the gear in the down position, the acft nosed over.Apr 13, 1987 · N1774R · Substantial damageNTSB CHI87LA113Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Marine City, MIDuring a solo training flight, the student pilot landed too fast. The aircraft porpoised, the nose wheel collapsed and the plane nosed over.Apr 13, 1987 · N4857B · Substantial damageNTSB NYC87LA122Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Pottstown, PADuring landing approach to runway 28, ground fog was encountered and the pilot overshot his intended touchdown point. The pilot stated that he slowed the airspeed to zero mph and the acft started to shake and fall even though the motor and rotor were at 100%…Apr 12, 1987 · N85570 · Substantial damageNTSB ATL87LA113Accident · No injuriesLimited investigationFinal reportCessna 172 M · Ridgeland, SCThe plt was practicing t/o & ldgs. During the 2nd ldg, the plt reptd retarding throttle to idle and eng dying during roll-out. A restart was accomplished and another t/o comp. Again during ldg. Eng stopped during roll out. This time, the restart attempt was…Apr 12, 1987 · N9563V · DestroyedNTSB MKC87LA079Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Brewster, KSThe PIC rptd verring left and off the side of the sod strip where he was attempting a lndg. The PIC stated that the lndg gear began sinking into soft grnd off the side and the acft slowed rapidly. After slowing the nose wheel collapsed rearward flipping the…Apr 11, 1987 · N118FP · Substantial damageNTSB DEN87LA095Accident · No injuriesLimited investigationFinal reportCessna 170A · Durango, COThe plt reports that he was landing to the s with a rt quartering headwind of about 20 KTS. He said that during his rollout the wind shifted to a rt quartering tailwind with a large gust. The gust raised the tail and rt wing and the acft departed the rt side…Apr 11, 1987 · N5579C · Substantial damageNTSB FTW87FA093Accident · No injuriesField investigationFinal reportCessna 150G · Post, TXSubstantial damage occurred during an attemtped touch and go landing by a student pilot. The acft landed hard, collapsing the nose gear and empennage. After initial impact the acft became airborne for approximately 1000 ft before contacting the runway again…Apr 10, 1987 · N8550J · Substantial damageNTSB MKC87LA081Accident · No injuriesLimited investigationFinal reportCessna 152 · Kirksville, MODrg a night landing, the plt did not get the acft flared before touchdown. Subsequently, it contacted the rwy with the nose wheel. Drg the occurrence, the nose gear, prop & eng fire wall were damaged.Apr 9, 1987 · N5515Q · Substantial damageNTSB CHI87LA111Accident · No injuriesLimited investigationFinal reportCessna 150M · Pontiac, ILThe plt lost directional control, swerved off the rwy and struck an acft that was parked approx 80 ft from the rwy. There was no evidence of a system malfunction or failure. The wind as reported by the plt at the time of the accident was calm.Apr 9, 1987 · N6039K · Substantial damageNTSB BFO87LA029Accident · Minor injuriesLimited investigationFinal reportCessna 205 · Midland, VAThe plt stated that this was the first time he had ever landed on rwy 32. During the lndg apch, about 15 secs before touchdown, his eyeglasses broke and fell off his face. He reached for his spare eyeglasses that were on top of the instrument panel; however,…Apr 9, 1987 · N8381Z · Substantial damageNTSB ATL87LA107Accident · No injuriesLimited investigationFinal reportCessna 172N · Vidalia, GAThe plt reported that he apparently had his left foot too high on the left rudder pedal while making a x-wind ldg. The left wheel skidded on the touchdown and the acft ran off the left side of the rwy. The nose wheel subsequently broke off and the acft nosed…Apr 9, 1987 · N75961 · Substantial damageNTSB MKC87LA101Accident · No injuriesLimited investigationFinal reportCessna 140 · Eldon, MOAccording to the pilot, winds were light prior to the final approach, but a gust of wind picked up the right wing and the aircraft ballooned during the flare, running out of airspeed while in a full-stall/three-point attitude. Upon impact, both main gears…Apr 8, 1987 · N2559N · Substantial damageNTSB FTW87LA119Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Lake Providence, LAThe pilot, who reportedly was familiar with the 2200 x 90 foot sod strip, allowed the aircraft to drift left during the landing roll where the left main landing gear struck the end of a concrete culvert which did not extend quite to the extreme edge of the…Apr 8, 1987 · N8248D · Substantial damageNTSB MIA87IA131Incident · No injuriesIncident investigationFinal reportCessna 310Q · Ft.Lauderdale, FLDuring the landing roll the right main gear collapsed. Inspection of the acft by FAA personnel revealed that this was caused by a twisted torque tube which failed to fully extend the gear.Apr 7, 1987 · N7665Q · Minor damageNTSB LAX87LA170Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Calexico, CAAt the end of a pleasure cross country flight, the plt reported that upon landing, the acft veered to the left, the plt corrected to the right. The acft veered to the left again and the plt corrected to the right. The acft then began to turn in a clockwise…Apr 6, 1987 · N3085R · Substantial damageNTSB DEN87LA085Accident · Minor injuriesLimited investigationFinal reportAero Commander 100-180 · Cando, NDThe acft attempted landing and on short final, the plt recognized a pickup truck obstructing the rwy near midfield. A go around was attempted resulting in an inadvertant stall. The left wing dipped, struck the rwy, and skidded into the vehicle. The acft and…Apr 6, 1987 · N4069X · Substantial damageNTSB CHI87DEE07Accident · No injuriesFinal reportCessna 172 · Lansing, ILThe pilot stated that due to an RPM fluctuation he had diverted to an alternate arpt. He attempted to land on rwy 27 when the wind was from 020 degrees 14 KTS gusting 30 knots. The flap operation was also erratic according to the plt. The acft ran off the…Apr 6, 1987 · N80379 · Substantial damageNTSB DEN87LA086Accident · No injuriesLimited investigationFinal reportBoeing A75L3 · Belgrade, MTThe plt report that he was landing on a 9000 x 150 ft asphalt rwy. The wind was nearly down the rwy at 4 to 9 KTS. In a telephone interview 2 days after the accident the plt reported that he was making a 'wheels' landing. He said when the main gear was about…Apr 5, 1987 · N5084N · Substantial damageNTSB DEN87LA083Accident · No injuriesLimited investigationFinal reportCessna 180B · Boulder, COThe plt reports that he was landing with a lt x-wind at 10 to 15 KTS. He said that at or just after touchdown a gust of wind lifted the lt wing and the acft swerved to the lt off the rwy and nosed over.Apr 4, 1987 · N5207E · Substantial damageNTSB ATL87LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Lebanon, TNThe plt reported that he made a VFR pattern for landing on rwy 18 at his destination. The wind was 'hard' and 'straight down the rwy.' He reported that, 'all of a sudden it seemed as though the wind quit and the airplane started to fall.' The acft hit hard…Apr 4, 1987 · N4974J · Substantial damageNTSB MIA87LA127Accident · No injuriesLimited investigationFinal reportCessna 180H · Frostproof, FLUpon touchdown the rt landing gear tire blew due to the side load placed upon it after the acft was blown sideways by the direct crosswind. The landing gear was then sheared off, after which, the acft slid off the rwy into the grass & came to rest.Apr 3, 1987 · N9731G · Substantial damageNTSB DEN87LA080Accident · No injuriesLimited investigationFinal reportCessna 170B · Boulder, COAn 85 hour private plt was flying for proficiency in his Cessna 170. At the last landing of the flt, an apparently normal touchdown was completed. During the landing roll, the acft swerved to the left and the plt corrected to the right. The acft continued to…Apr 3, 1987 · N2323D · Substantial damageNTSB DEN87LA079Accident · No injuriesLimited investigationFinal reportNorth American Navion · Los Alamos, NMThe instructor plt was giving cross wind instruction to a pre-solo student plt. During a cross wind landing attempt, the acft touched down hard, breaking off the right main landing gear. The winds were observed at the time of touchdown to be 150 degrees at 12…Apr 3, 1987 · N91735 · Substantial damageNTSB SEA87LA072Accident · No injuriesLimited investigationFinal reportPiper PA 16 · Jean, NVThe plt was landing his acft onto runway 02 with the wind from 230 degrees at 7 knots, which would be a left quartering tailwind. During the rollout the acft veered to the right of the runway onto soft terrain striking rocks.Apr 2, 1987 · N5916H · Substantial damage