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 DEN86LA220Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Center, COThe plt reported that he was landing on a 50 ft wide dirt strip and allowed the acft to drift to the left during the landing roll. The left wing collided with wheat growing along the left side of the strip and the acft swerved further to the left. During the…Aug 5, 1986 · N5324 · Substantial damageNTSB DEN86LA218Accident · No injuriesLimited investigationFinal reportCessna 172P · Albuquerque, NMAccording to the instructor (CFI), the student was making a practice landing when a sudden windshift occurred. He rprtd that when they were on the downwind for their 5th landing, the wind was from the wsw, but just before the landing, it changed to a…Aug 5, 1986 · N55297 · Substantial damageNTSB CHI86FA199Accident · No injuriesField investigationFinal reportCessna 177 · Oshkosh, WIA spl tfc management program was in effect for an annual eaa fly-in, & a waiver to FAA handbook 7110.65D was in effect which allowed for reduced sepn btn acft opng at wittman fld. As 2 acft were lndg, the plt of the 1st acft (Cessna 177, N17204) was told to…Aug 5, 1986 · N17204 · 2 aircraft · Substantial damageNTSB SEA86LA191Accident · No injuriesLimited investigationFinal reportCessna T210 · Las Vegas, NVDuring landing roll the aircraft departed the runway to the right despite the pilots attempt to correct with left rudder. The acft struck a ditch and the nose gear separated from the acft. During acft repair the mechanic found the right master cylinder was…Aug 4, 1986 · N139BB · Substantial damageNTSB NYC86LA197Accident · No injuriesLimited investigationFinal reportCessna 152 · Harrisburg, PAThe student plt was on a x-country flt. He rprtd that during the flare to land at Harrisburg, PA, the acft yawed left, then after touchdown, it veered off the left side of the rwy twd a VASI installation. He steered further left to avoid the VASI, then…Aug 4, 1986 · N93454 · Substantial damageNTSB ANC86LA121Accident · No injuriesLimited investigationFinal reportCessna U206 · Egegik, AKThe pilot stated that during the landing rollout on the gravel bar he lost control of the aircraft causing the plane to nose over on its back.Aug 4, 1986 · N9188M · Substantial damageNTSB SEA86LA189Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Rosalia, WADuring climb out the acft entered a departure stall. The acfts left wing dropped and the acft came to rest 90 degrees from its departure heading. This acft has no stall warning system.Aug 3, 1986 · N1886B · Substantial damageNTSB LAX86LA316Accident · No injuriesLimited investigationFinal reportSchweizer SGS-1-35 · Marana, AZA Schweizer sgs 1-35, landed hard after a steep final approach. The pilot indicated that he was high on final approach and initially applied 30 degrees of flaps. He was still too high and elected to use 80 degrees (full) flaps. The aircraft landed hard nose…Aug 3, 1986 · N34180 · Substantial damageNTSB CHI86LA196Accident · No injuriesLimited investigationFinal reportPiper PA-20-115 · Mosinee, WIFollowing departure from oshkosh, WI, the plt proceeded directly to central Wisconsin airport, Mosinee, WI, at aprx 2500 ft MSL. After receiving an arpt advisory from the central Wisconsin UNICOM, the plt landed on rwy 26. According to the plt, a 30-35 deg…Aug 3, 1986 · CGHGF · Substantial damageNTSB SEA86LA190Accident · No injuriesLimited investigationFinal reportCessna T210L · Elko, NVDuring landing rollout on runway 23 the aircraft deviated to the right and the pilot corrected first with rudder and then left brake. The aircraft then veered left and departed the runway. The pilot then attempted to initiate a go around and fly out of the…Aug 2, 1986 · N5118Q · Substantial damageNTSB MIA86LA225Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Crestview, FLWhile on final aprch with the ldg gear extended for ldg, the plt observed another acft ahead of him which he felt he was overtaking. He elected to execute a go-around & while on downwind leg, the plt retracted the gear absent-mindedly thinking he was…Aug 2, 1986 · N7992P · Substantial damageNTSB MIA86LA223Accident · No injuriesLimited investigationFinal reportBeech J35 · Bunnell, FLThe plt stated that he became distracted & forgot to put the landing gear down. He also stated that the landing gear warning horn was inoperative. Post crash examination revealed that the landing gear warning horn microswitch was out of adjustment.Aug 2, 1986 · N57UT · Substantial damageNTSB LAX86FVD09Accident · No injuriesFinal reportJaks Volksplane VP-2 · Ukiah, CAAt the end of a local flight, during the landing roll, the plt was distracted and allowed the acft to veer to the right side of the rwy. The plt applied the brakes when the left main landing gear collapsed.Aug 2, 1986 · N3CJ · Substantial damageNTSB CHI86FA191Accident · 2 fatalField investigationFinal reportHawker Siddeley DH-125-1A · Bedford, INThe plt canceled IFR 8 miles from the arpt to continue on a visual apch and landing. Witnesses stated a strong thunderstorm had just passed over the arpt. Wind info issued to the plt by UNICOM were west at 20 KTS. Witnesses observed the acft apch rwy 31 and…Aug 2, 1986 · N50HH · DestroyedNTSB ATL86LA215Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Cumming, GAThe plt reported that he made 3 attempts to land on a short narrow rwy in windy conditions. After the 1st attempt, he changed rwys, based on the UNICOM announcement that the wind favored rwy 3. On the last apch, the plt landed about 1/3 to 1/2 of the way down…Aug 2, 1986 · N56616 · Substantial damageNTSB LAX86LA310Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Oroville, CAA Cessna 140 nosed over in a ditch after aborting a takeoff. The plt indicated he was practicing stop and go landings. During the last landing the right brake was inadvertently applied and the acft veered to the right off the rwy. The plt initiated a…Aug 1, 1986 · N77326 · Substantial damageNTSB ATL86LA214Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Lenoir, NCThe student plt was executing full stop landings then making a take off after each landing. He was attempting his fourth landing when the acft bounced, he applied power to try to regain control of the acft. The nose gear collapsed upon touch down, the strut…Jul 31, 1986 · N8757G · Substantial damageNTSB DEN86LA217Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Monument Valley, UTThe plt was landing on a 3100 ft dirt rwy, at an arpt with mtns nearby. He said that just before landing, the acft encountered a downdraft at about 100 ft AGL & 'the bottom fell out.' Subsequently, the acft landed hard & the rgt main lndg gear failed. There…Jul 30, 1986 · N8272Y · Substantial damageNTSB CHI86LA190Accident · No injuriesLimited investigationFinal reportBeech B-19 · Manchester, MIThe pilot states, that on flare out the aircraft ballooned and then settled, sustaining a hard landing. The nose gear failed upon touchdown.Jul 30, 1986 · N6517R · Substantial damageNTSB ANC86LA117Accident · No injuriesLimited investigationFinal reportCessna 185E · Tetlin, AKAcft left rwy and crashed during attempted go-around with 10 to 25 knot crosswind. Pilot stated that engine did not develop full power. Examination and test run of engine did not reveal any mechanical failures/malfunctions.Jul 30, 1986 · N1613M · Substantial damageNTSB SEA86LA183Accident · Minor injuriesLimited investigationFinal reportCessna 182 · East Sound, WADuring landing roll at about 25 mph the pilot applied both brakes. A short time thereafter the right brake pedal went to the floor. Despite the pilot's application of hard left brake and rudder, the acft veered to the left into a drainage ditch. The nose gear…Jul 29, 1986 · N71131 · Substantial damageNTSB FTW86LA140Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Roanoke, TXThe pilot took off during darkness on an early morning flt & arrived at the destn arpt prior to sunrise. He was unable to activate the rwy lights, but since the ground features could be seen, he elected to land. During the landing, the acft touched down…Jul 29, 1986 · N5753L · DestroyedNTSB NYC86LA192Accident · No injuriesLimited investigationFinal reportMaule M-5-235 · Wolfeboro, NHWhile landing, the aircraft bounced slightly & the plt lost directional control. The aircraft veered left over the runway edge onto a soft shoulder, nosed over & was damaged.Jul 28, 1986 · N396X · Substantial damageNTSB LAX86LA306Accident · No injuriesLimited investigationFinal reportCessna 195 · Ramona, CAThe aircraft owner stated that the purpose of the flight was to obtain 5 hours of transition training in the tail dragger and accomplish a bfr. After departure the CFI had the pilot perform airwork maneuvers enroute to the Ramona area. The pilot said that a…Jul 28, 1986 · N3899V · Substantial damageNTSB MIA86LA220Accident · No injuriesLimited investigationFinal reportCessna T337H · Marathon, FLWitnesses reported the pilot arrived for the flight carrying a glass from a local bar, was uncoordinated and appeared intoxicated. After much difficulty in taxiing to the runway, he finally took off. On arrival at Marathon, FL, the pilot failed to extend the…Jul 27, 1986 · N1343L · Substantial damageNTSB FTW86FPA25Accident · No injuriesFinal reportThorpe T18 · Mckinney, TXThe acft was landed on a closed rwy where it collided with steel posts embedded in the rwy. The plt had questioned a Cessna plt who made a go-around in front of him about the status of the rwy and wad advised it was closed. The plt saw the flag & an 'x' but…Jul 27, 1986 · N7JA · Substantial damageNTSB CHI86LA188Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Winneconne, WIWhile landing, the plt failed to maintain directional control. Subsequently, the acft went off the right side of the rwyand entered a skid. The left main gear collapsed, then the nose gear collapsed.Jul 27, 1986 · N4865V · Substantial damageNTSB CHI86LA184Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Traverse City, MIWhile flaring to land, the aircraft had excessive speed and ballooned. Subsequently, it bounced twice, then began to veer to the left. The pilot performed a go-around. During the initial portion of the go-around, the left wing struck a runway edge identifier…Jul 27, 1986 · N2185B · Substantial damageNTSB FTW86LA139Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Fort Worth, TXThe pilot touched down long but with adequate runway remaining. However, he delayed brake application and as a result was still going too fast to turn off at the end of the runway. Collision with the runway end barrier occurred.Jul 26, 1986 · N5088D · Substantial damageNTSB CHI86LA182Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Dodgeville, WIAccording to the pilot, his brakes failed and he was unable to stop before going off the end of the runway and over a 30 foot embankment. During an inspection, the brakes and braking system were found to be free of any defects and in proper working order.…Jul 26, 1986 · N80510 · Substantial damageNTSB LAX86FVG06Accident · No injuriesFinal reportAmateur Built Barnett J3 · Yuba City, CAThe landing accident occurred after the pilot had made high speed taxi tests along the runway with three liftoffs. After the third liftoff, the pilot said that he found himself too high. He stated that he reduced power and pushed forward on the control stick.…Jul 25, 1986 · N504P · Substantial damageNTSB CHI86LA187Accident · No injuriesLimited investigationFinal reportPiper PA-31T1 · Charlevoix, MIAccording to the pilot,on their first approach they were unable to see the airport at 1300 feet, so they raised the gear and flaps and climbed to 1800 feet, at which time they saw the airport. The pilot decided to make a VFR landing on runway 26 and forgot…Jul 25, 1986 · N2317V · Substantial damageNTSB ATL86LA211Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Sandusky, OHThe pilot reported that he diverted and landed to reassess the weather before continuing his flight. He said the wind was from the southwest at eight KTS. Just before touchdown on runway 27, the aircraft yawed left and landed while in a crab. The airplane…Jul 25, 1986 · N9011J · Substantial damageNTSB MKC86LA161Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Lewisville, ARThe PIC made a landing to a rain soaked sod rwy when the acft's right main gear fell into a large mud hole during the landing roll and the acft flipped inverted. The subsequent flipping action substantially damaged the acft.Jul 24, 1986 · N6997K · Substantial damageNTSB DEN86LA206Accident · No injuriesLimited investigationFinal reportTroutman Quickie Q2 · Rawlins, WYThe plt, flying a homebuilt quickie Q2, attempted a ldg on rwy 22 with winds of 20K, gusting to 30K out of 250 degrees. After touchdown the acft weather vaned into the wind. The acft left the rwy, flipped over and was substantially damaged.Jul 24, 1986 · N21LT · Substantial damageNTSB ATL86LA209Accident · Minor injuriesLimited investigationFinal reportChampion 7E6A · Alliance, OHDuring the second landing attempt, the pilot lost directional control and ground looped. The aircraft was substantially damaged and the pilot received minor injuries. The pilot did not report any aircraft problems. The pilot had completed a student pilot solo…Jul 24, 1986 · N982G · Substantial damageNTSB NYC86LA195Accident · No injuriesLimited investigationFinal reportBeech A24R · Tunkhannock, PADuring a landing in calm wind conditions, the acft bounced, became airborne again & touched down further down the 2000' rwy. The plt applied brakes & 'dumped' the flaps for max braking, but to no avail. The acft slid off the grass rwy & subsequently went over…Jul 23, 1986 · N1RJ · Substantial damageNTSB NYC86LA194Accident · No injuriesLimited investigationFinal reportCessna 172 M · Olcott, NYThe pilot flying a Cessna 172M with three passengers on board made a landing on a 2500 ft grass runway. This was his first landing on a grass runway. He touched down fast and became airborne, recovered, and became airborne again. His airspeed was too slow to…Jul 23, 1986 · N9263H · Substantial damageNTSB LAX86LA300Accident · No injuriesLimited investigationFinal reportTaylorcraft 19 · San Jose, CAThe plt applied the brakes heavily during the landing roll. As the aircraft slowed to approximately 5 mph it nosed over on its back.Jul 22, 1986 · N43876 · Substantial damageNTSB CHI86LA177Accident · No injuriesLimited investigationFinal reportCessna 150 · Indianapolis, INThe student plt had been practicing touch and go landings for aprx 1 hour. On the accident landing, the acft veered to the left. The plt overcorrected and the acft began to travel off the right side of the rwy. While attempting a go-around the acft's wing…Jul 22, 1986 · N63069 · Substantial damageNTSB LAX86FA297Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Corona, CAThe pilot stated to fire personnel that as he approached touchdown, the sun got in his eyes and a cross wind pushed him off the right side of his private airstrip. The aircraft landed hard on the right wheel, veered off the right side of the runway,…Jul 21, 1986 · N83380 · DestroyedNTSB CHI86LA176Accident · No injuriesLimited investigationFinal reportCessna 150 · Allegan, MIGrass steip measures 1800 feet by 45 feet. Seven-foot tall corn stalks surround both sides of airstrip. The aircraft veered off center, to the left, during touchdown. Left wing contacted corn stalks, causing aircraft to cartwheel.Jul 21, 1986 · N6768F · Substantial damageNTSB FTW86LA136Accident · No injuriesLimited investigationFinal reportCessna 305C · Stamford, TXThe pilot was receiving instruction on touch and go landings, in a tail wheel equipped aircraft, when he lost control on touchdown and ground looped the aircraft. The instructor was late with corrective action.Jul 20, 1986 · N4493H · Substantial damageNTSB ANC86FA111Accident · No injuriesField investigationFinal reportPiper PA-18 · Anchorage, AKThe acft was not properly aligned with the rwy during landing touchdown. The acft touched down in a crab attitude. It then ground looped and came to rest on the left wing tip and nose.Jul 20, 1986 · N7156Z · Substantial damageNTSB SEA86LA175Accident · No injuriesLimited investigationFinal reportCessna 152 · Seattle, WAStudent pilot, with about 2 hours solo time, was making touch and go's. during the last landing the aircraft was observed to make several bouncing contacts with the runway before the nose gear collapsed.Jul 19, 1986 · N68723 · Substantial damageNTSB DEN86LA202Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Minot, NDAccording to the plt, the flt proceeded normally until he arrived at an airstrip sw of Minot for a landing. Several low approaches were made before he elected to land. He said that after the touchdown and during his landing roll, the acft swerved and went…Jul 19, 1986 · N2355A · Substantial damageNTSB CHI86FEP06Accident · No injuriesFinal reportPatton Pitts S-1C · Hartford, WIThe plt was on an aerobatic competition flt. He reported that after finishing a sequence of aerobatic maneuvers, he returned to the rwy to land. During the landing, the acft was high on final apch & touched down to FAR down the 2100 ft rwy. It then contd off…Jul 19, 1986 · N3507 · Substantial damageNTSB FTW86LA131Accident · No injuriesLimited investigationFinal reportBeech B-100 · Houston, TXThe pilot was unable to get a green light for the left main gear prior to landing and finally had to make an emergency landing on the nose and right main gear. The aircraft was substantially damaged when it veered off the runway on the landing roll out.…Jul 18, 1986 · N6354H · Substantial damageNTSB ATL86LA198Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Lake City, SCDuring landing roll the pilot noticed that the aircraft began to veer off the runway. He initiated a go-around in order to assess the problem. It was determined that the nose wheel had malfunctioned. During the landing roll the aircraft veered off the runway…Jul 18, 1986 · N6116N · Substantial damageNTSB MIA86LA212Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Bunnell, FLThe plt stated that on final approach he forgot to put the landing gear down. He then landed gear up, & the acft slid to a stop.Jul 17, 1986 · N257ER · Substantial damage