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 CHI86LA049Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Dodgeville, WIAfter a x-country flt and during the landing roll the acft started to drift left on the snow covered rwy. The left main gear then encountered deeper snow causing the acft to swing to the left and run into a six-ft snowbank.Dec 15, 1985 · N8458H · Substantial damageNTSB BFO86LA009Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Edgewater, MDUpon returning to lee arpt, Edgewater, MD, from a x-country flt to lancaster, PA, the student plt applied full flaps during the final apch for rwy 12. During the landing flare, the acft ballooned and the plt applied full pwr in order to execute a go-around.…Dec 15, 1985 · N427FL · Substantial damageNTSB ANC86LA016Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Wasilla, AKAircraft lost control during landing and crashed into another private aircraft. Witness reported seeing aircraft make a fast appraoch, land long, ground loop and slide side ways into parked Aeronca. Witness stated that aircraft landed with a tailwind,while…Dec 15, 1985 · N7773K · Substantial damageNTSB LAX86LA067Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Glendale, AZAfter completing a LCL flight the plt returned to his home base arpt & proceeded to land on the 2400 ft long rwy. The plt reported that he was unable to stop at its end and collided with barricades and a fence. A witness reported that the acft skidded on the…Dec 14, 1985 · N3885F · Substantial damageNTSB MKC86LA034Accident · No injuriesLimited investigationFinal reportCessna 402B · Gardner, KSLanding on an ice covered rwy, the cross-wind was stronger than rptd. The acft drifted left despite control input to correct. The nose gear collapsed before the plt could initiate a go-around. The rptd wind was 340 degrees at 8 knots. The plt stated it was…Dec 13, 1985 · N3950C · Substantial damageNTSB ATL86LLQ04Accident · No injuriesFinal reportBeech BE-60 · Lexington, KYThe left main gear and nose gear collapsed following a loss of control during touchdown. During the flare the acft banked sharply to the right and struck the rwy. The acft then bounced onto the left gear, collapsing it and the nose gear before slidding off…Dec 13, 1985 · N202TT · Substantial damageNTSB MKC86LA032Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Topeka, KSN4NP diverted from the original destination forbes field Topeka,Kansas to billard field,b NM away, due to weather. Billard ATCT advised the flight during initial contact, before N4NP reached the ILS fof, of the runway braking action. The pilot said braking…Dec 10, 1985 · N4NP · Substantial damageNTSB DEN86LA042Accident · No injuriesLimited investigationFinal reportCessna 172P · Missoula, MTThe solo student plt was attempting to land during a local flt when he lost control of the acft during the landing roll. The plt stated that the acft veered to one side of the ice covered rwy where it contacted 6 to 8 inches of snow, the acft continued…Dec 9, 1985 · N64069 · Substantial damageNTSB ATL86LA038Accident · No injuriesLimited investigationFinal reportCessna 182Q · Stone Mountain, GAAfter an IFR flight into his home area, pilot changed dest to land on his home airport. Made a VFR pattern to land on rwy 17. Plt stated that he flared too late, hit the runway, bounced real high and went around. Made a soft field ldg and when tying acft down…Dec 8, 1985 · N4707N · Substantial damageNTSB LAX86LA058Accident · No injuriesLimited investigationFinal reportCessna 210D · Flagstaff, AZThe plt noticed a weakness of the acft's left brake during taxi for takeoff but elected to make the flt. Control tower personnel at the destination arpt stated the acft landed long and attempted to turn onto the right highspeed taxiway. The plt stated that…Dec 7, 1985 · N3762Y · Substantial damageNTSB CHI86LA045Accident · No injuriesLimited investigationFinal reportCessna 150M · Carbondale, ILAccording to the student pilot flying the plane, after he touched down on his main wheels he lowered the nose and he heard a crack. The nose wheel then collapsed andthe aircraft slid to a stop. According to the operator of the aircraft no preexisting…Dec 7, 1985 · N62FS · Substantial damageNTSB ATL86LA036Accident · No injuriesLimited investigationFinal reportCessna 152 · Hickory, NCStudent pilot was returning from a solo cross country flight. In his report the student said he flew a long final with the VASI showing a proper descent angle. The acft was landed with a shallow flare touching down in a flat attitude. It bounced, bounced…Dec 6, 1985 · N44687 · Substantial damageNTSB ATL86LA035Accident · No injuriesLimited investigationFinal reportCessna 182J · Bishopville, SCDuring an attempt to make a direct crosswind landing at a private grass airstrip, the plt allowed the acft to drift off the left side of the rwy where it nosed over in a plowed fld.Dec 6, 1985 · N2650F · Substantial damageNTSB ANC86LA012Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Shageluk, AKThe acft contacted trees and descended to the terrain while on an apch to a lake. The plt reported the acft windscreen kept frosting up and he had to repeatedly wipe it clean. In the process of wiping the windscreen he approached the lake at a lower than…Dec 6, 1985 · N97MM · Substantial damageNTSB LAX86LA060Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · San Jose, CAAfter completing a personal flight the plt landed the acft. Upon touchdown on the 8899 ft-long by 150 ft-wide rwy the plt failed to maintain directional control of the acft. There was a 70 deg, 8 kt. Right x-wind. The acft overran the runway's edge, entered a…Dec 5, 1985 · N82009 · Substantial damageNTSB ANC86IA010Incident · No injuriesIncident investigationFinal reportPiper Navajo PA-31-350 · Kenai, AKThe pilot in command could not raise the landing gear properly after departure. He diverted to Kenai, Alaska, whereupon extending the gear he obtained three safe gear indications. The pilot landed the airplane and upon roll out the left main gear collapsed.…Dec 5, 1985 · N492SC · Minor damageNTSB MIA86LA038Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-5 · Wimauma, FLThe plt stated that after turning on the rwy lights using the radio transmitter. They appeared to be dim, & only one side of the lights came on. He then landed south of the rwy at which time the right wing struck a fence post. The landing gear then collapsed,…Dec 3, 1985 · N700TD · Substantial damageNTSB ANC86LA011Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Fishtrap Lake, AKPilot attempted to land his wheel equipped aircraft on frozen lake with water overflow and 12 to 18 inches snow. Acft broke through top layer of thin ice and nosed over upon touchdown.Dec 2, 1985 · N1237A · Substantial damageNTSB MIA86LA039Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Cedar Key, FLThe plt was attempting a night landing on his first night x-country & had not landed at this aprt prior to this time. He stated that during the flare, he was caught by a x-wind & blown into the trees adjacent to the rwy. Surface winds at the time of the…Dec 1, 1985 · N136AV · Substantial damageNTSB LAX86LA052Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Calexico, CAThe acft ground looped during a landing on rwy 08 at Calexico arpt. The plt reported that upon touchdown the acft began to swerve to the right. The plt applied left rudder to arrest the right swerve. The acft then began a swerve to the left and the plt was…Dec 1, 1985 · N7728K · Substantial damageNTSB DEN86LA036Accident · No injuriesLimited investigationFinal reportCessna 152 II · Greeley, COAccording to the plt, during the landing roll the acft veered to the left of the rwy and struck a snow berm. The plt stated that the accident could have been prevented if he had held the 'nose wheel off the ground' longer and not relaxed his attention.Dec 1, 1985 · N49209 · Substantial damageNTSB ATL86LA033Accident · No injuriesLimited investigationFinal reportAero Commander 500 · Albany, GAThe aircraft landed on the wet sod runway with a 30 to 35 knot tailwind and ran off the end of the runway and into the trees. The pilot related that the wind shifted 180 degrees upon touchdown. The pilot also stated that he touched down approximately 1000 ft…Dec 1, 1985 · N999B · Substantial damageNTSB DEN86LA035Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Beulah, NDDuring a landing at dusk on a snow covered rwy, the acft encountered deep snow and nosed over onto its back. The plt stated that after touchdown, he realized that there was aprx one ft of snow on the rwy and was unable to make a go-around.Nov 30, 1985 · N8143K · Substantial damageNTSB NYC86LA042Accident · No injuriesLimited investigationFinal reportIsrael Aircraft Industries WW-24 · Worcester, MAAccording to the pilot, the flight was normal, upon touchdown the reversers were deployed, pilot had information that braking action was poor and rwy was icy but had been sanded, pilot landed on the left side of the rwy centerline aircraft began to drift…Nov 27, 1985 · N4WG · Substantial damageNTSB DEN86LA043Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Hayes, SDThe plt stated that during the uphill ldg on snow covered terrain, the acft crested the hill, then started downhill on the opposite side. According to the plt he was unable to stop the acft before reaching a cliff. The plt egressed the acft prior to it going…Nov 27, 1985 · N6884B · Substantial damageNTSB NYC86LA041Accident · No injuriesLimited investigationFinal reportCessna 150G · Palmyra, NYOn landing the acft encountered wind gusts forcing the left wing upward, and hitting the right wing on the ground. The acft then spun around striking the prop and left wing on the rwy.Nov 24, 1985 · N8324J · Substantial damageNTSB ATL86FA029Accident · 3 fatalField investigationFinal reportCessna 182R · Bryson City, NCThe acft made a normal apch and had the flaps down to about 15 deg. Touch down as about one third down the rwy. There was a bounce and the right wing came up and the acft veered to the left off the rwy. Power was applied and the acft paralleled the rwy. The…Nov 19, 1985 · N9547E · DestroyedNTSB NYC86LA039Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Atlantic City, NJThe acft experienced a collapse of the nose gear during the landing roll after what the plt said was a normal landing. The right main gear was further damaged during removal of the acft from the rwy.Nov 17, 1985 · N3011P · Substantial damageNTSB CHI86LA028Accident · No injuriesLimited investigationFinal reportMooney M20F · Piper City, ILThe pilot elected to land on a paved road because his rla was too wet. The aircraft landed on top of a moving automobile. The aircraft remained on top of the automobile as it ran off the side of the road.Nov 14, 1985 · N2907L · Substantial damageNTSB SEA86LA025Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Imnaha, ORPrior to takeoff the pilot taxied through a lot of slush. A nose over occurred while attempting to land on a snow covered clearing. The nose over probably occurred due to very deep snow on the landing area and frozen brakes.Nov 12, 1985 · N3534M · Substantial damageNTSB ATL86FKG05Accident · No injuriesFinal reportSmith, Ted Aerostar Aerostar 600 · Birmingham, ALThe left main gear collapsed during a loss of control on landing. The plt reported the acft touched down prematurely during the flare and it contacted the lip of the rwy at the apch end. Directional control could not be maintained, according to the plt, and…Nov 12, 1985 · N107MW · Substantial damageNTSB ANC86LA008Accident · No injuriesLimited investigationFinal reportCessna 150 · Rainbow Lake, AKThe plt reported that after the acft touched down on a snow covered, frozen lake, he was unable to hold the nose gear up, due to the depth of the snow. When the nose came down, the nose gear buckled under & the acft nosed over.Nov 12, 1985 · N9115U · Substantial damageNTSB MIA86IA029Incident · No injuriesIncident investigationFinal reportPiper PA-44-180 · Miami, FLThe plt stated that he was on a practice instrument apch & after arriving at minimums, declared a missed apch, retracted his landing gear & flaps but decided to land and continued his apch & inadvertently landed gear up.Nov 9, 1985 · N2103K · Minor damageNTSB FTW86FPA05Accident · Minor injuriesFinal reportMooney MK20J · Gladewater, TXDuring takeoff the headset wiring became tangled in the emergency gear extension handle which had been accidently activated. Then the normal gear handle was put in the up position, the emergency gear crank rotated pulling on the headset and the emergency gear…Nov 8, 1985 · N201QW · Substantial damageNTSB MIA86LA025Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · St.Petersburg, FLThe pilot loaded the ac with 100 pounds of fuel,himself and 5 passengers and departed for a short local flight. The ac was landed 15 minutes later 382 pounds over max gross weight, and landed long on a 2800 ft runway, in a crosswind. The ac then skidded left…Nov 7, 1985 · N11RJ · Substantial damageNTSB ATL86FA020Accident · Serious injuriesField investigationFinal reportHawker Siddeley DH 125-400A · Sparta, TNTen minutes prior to landing heavy rain fell on airport. Acft mad normal touchdown,spoilers & lift dump activated.PIC delayed brake application as usual and did not get thrust levers in idle. After acft passed mid-field taxiway PIC reported brakes became…Nov 7, 1985 · N100HF · Substantial damageNTSB LAX86LA035Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Fresno, CAThe acft approached the rwy for landing without the landing gear extended. The controller instructed the plt to go around but the plt continued the apch and landed with the gear retracted. Post accident inspection of the acft disclosedthe gear selector was in…Nov 6, 1985 · N3674G · Substantial damageNTSB LAX86LA034Accident · No injuriesLimited investigationFinal reportAerotek Pitts S-2A · Chandler, AZDuring a dual instructional flight the CFI stated that he was looking for traffic while monitoring his student's performance. The CFI failed to observe that an acft was ahead of him in the traffic pattern. That acft was at a lower altitude & was on short…Nov 6, 1985 · N42XX · 2 aircraft · Substantial damageNTSB CHI86LA023Accident · No injuriesLimited investigationFinal reportCessna 152II · Duluth, MNThe student plt had been practicing touch and go landings and on his third apch the acft drifted to the right of the rwy. He added pwr and attempted to go around. He heard the stall warning horn so he lowered the nose. The acft contactedthe ground, flipped…Nov 5, 1985 · N45953 · Substantial damageNTSB LAX86LA032Accident · No injuriesLimited investigationFinal reportCessna T188C · Hilo, HIThe plt became aware of the acft's unanticipated low fuel state when the eng failed while over the pacific ocean, aprx 900 miles from his destination. He restarted the eng but estimated there was not enough fuel remaining to reach his original destination. He…Nov 4, 1985 · N9958J · DestroyedNTSB MKC86LA024Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Grandview, MOThis pilot was making a takeoff for a local flight in his Piper PA-24. He stated that he was airborne when he raised the landing gear switch but the airplane settled back to the runway. Pilot said he became airborne again but could not get a safe indication.…Nov 3, 1985 · N7067P · Substantial damageNTSB NYC86LA029Accident · No injuriesLimited investigationFinal reportCessna 152 · Bloomsburg, PAThe plt landed with a 15 KTS tailwind and over a 30 ft obstacle. The acft touched down 1/2 way down the 2000 ft long rwy. Due to excessive speed the acft went into the overrun and became airborne for a short distance before touching downin a nose low altitude…Nov 2, 1985 · N24509 · Substantial damageNTSB MIA86LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Pahokee, FLThe plt stated the acft bounced four times on landing. During the fourth bounce the acft impacted the rwy hard causing the nose tire to blow out and the nose gear to bend.Oct 31, 1985 · N15BX · Substantial damageNTSB CHI86LA021Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Bangor, MIThe acft nosed over after landing on a grass landing strip. The pilot stated the tail came up and the aircraft flipped over on its back after left brake was applied. An examination of the landing gear and brakes revealed that the right brake was released but…Oct 30, 1985 · N8807Z · Substantial damageNTSB SEA86LA019Accident · No injuriesLimited investigationFinal reportCessna C206 · Funter Bay, AKThe left main gear did not retract and during water landing caused the aircraft to nose over. The link pin rod was found to be broken and the cylinder assembly main retract link and pin down latch were found to be bent.Oct 29, 1985 · N756FX · Substantial damageNTSB MKC86IA018Incident · No injuriesIncident investigationFinal reportSAAB-Fairchild SF340A · Lincoln, NEDuring landing roll at the Lincoln airport, the outboard wheel of the left main landing gear separated from the axle. The acft was not hampered in its landing roll and taxithe landing gear assembly revealed that a retaining nut washer was not installed on…Oct 29, 1985 · N342AM · No damageNTSB NYC86LA024Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Norwood, MAThe plt stated a gust of wind was encountered when the acft was 5 ft from touchdown. The gust turned the acft 90 degs from the rwy heading. The plt applied pwr to avoid trees but was unsuccessful and a collision with the trees occurred. Winds were reportedly…Oct 27, 1985 · N2561P · DestroyedNTSB LAX86LA027Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Fullerton, CADuring an instructional flt the student plt, who had a total of 5 hrs of flt time, attempted to land with the flaps extended to the 20 deg position. The acft ballooned, & the CFI took control & elected to complete the landing. Insufficient rwy remained & the…Oct 27, 1985 · N98954 · Substantial damageNTSB CHI86LA020Accident · No injuriesLimited investigationFinal reportCessna 150L · Ashland, OHThe student pilot was on his second solo flt after he made six landings with his instructor. On the third touch and go the acft hit hard, bounced, stalled, and contacted the rwy in a nose down attitude. The student plt attempted recovery from the hard landing…Oct 26, 1985 · N7447G · Substantial damageNTSB CHI86LA019Accident · No injuriesLimited investigationFinal reportCessna 150 · Clinton, INBoth student plts were making an apch to the same rwy at the time. The Cessna 152 touched down and was in its landing roll when the Cessna 150 landed on top with its nose wheel and prop in the 152'S rear window.Oct 26, 1985 · N10769 · 2 aircraft · Substantial damage