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 NYC87DFA03Accident · No injuriesFinal reportCessna 150M · Guilderland Cnt, NYThe student pilot, on a solo 30 NM x-country training flt, became lost while using VOR navigation. A precautionary landing was made in an industrial park. The acft collided with a stack of slate during the landing roll.Nov 28, 1986 · N704EK · Substantial damageNTSB FTW87FA022Accident · Minor injuriesField investigationFinal reportCessna 172C · Amarillo, TXThe certificated stu plt of the citabria was making touch and go landings at the uncontrolled arpt when the accident occurred. He took off to the south flying a left hand traffic pattern. The base to final turn was made aprx 1/4 mile from the rwy in front of…Nov 27, 1986 · N7709U · 2 aircraft · DestroyedNTSB LAX87LA050Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Half Moon Bay, CAThe airplane departed modesto airport (mod), modesto, California, on a v.f.r. pleasure flight to Half Moon Bay airport (haf), Half Moon Bay, CA. The flt to haf was uneventful. The plt negotiated a traffic pattern to runway 30. During the landing roll-out the…Nov 25, 1986 · N76EV · Substantial damageNTSB CHI87DEX02Accident · Minor injuriesFinal reportRohdecap/Thorp T-18 · Elwood, INThe plt departed anderson, Indiana to check farm fields for standing water, then elected to land at the Elwood arpt at Elwood, Indiana. The sod rwy at the arpt had an uneven gradient & was soft from recent rains. While landing on the soft,uneven rwy, the acft…Nov 22, 1986 · N2433 · Substantial damageNTSB BFO87LA012Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Easton, MDThe student plt stated that the landing approach was normal until the acft was over the rwy threshold; at a height of 35 ft, he encountered moderate to strong turbulence and afterwards the acft pitched up ten degrees and entered into a moderately steep left…Nov 22, 1986 · N7538R · Substantial damageNTSB ATL87LA025Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Brownsboro, ALThe student pilot was making her first supervised solo flight in the PA28-140 model aircraft. The student reported that wind and low airspeed prevented her from reaching the runway prior to landing touchdown.Nov 22, 1986 · N3869K · Substantial damageNTSB SEA87LA028Accident · No injuriesLimited investigationFinal reportCessna T-206 · Warren, IDThe pilot was attempting to land on a snow covered us forrest service airstrip at dawn. The aircrafts right main gear caught on uneven terrain to the side of the airstrip, veered to the right, and then nosed over inverted.Nov 20, 1986 · N756WZ · Substantial damageNTSB FTW87LA020Accident · No injuriesLimited investigationFinal reportBarnes Firefly 7 · Holden, LAA commercially rated pilot on an instructional flight was attempting a touch and go landing in the median of hiway I-12 1 mile east of Holden, LA. The pilot failed to see and avoid some power lines substantially damaging the balloon. The pilot and student…Nov 19, 1986 · N1245F · Substantial damageNTSB FTW87FA017Accident · Serious injuriesField investigationFinal reportCessna 152II · Grandview, TXA student plt, while on a solo VFR navigational training flt, became lost. After 3.5 hours of flt, the plt thinking she was almost out of fuel elected to make a downwind landing on a country road near Grandview, TX. The acft contacted trees and subsequently…Nov 18, 1986 · N68328 · DestroyedNTSB CHI87LA027Accident · No injuriesLimited investigationFinal reportCessna T210N · Kankakee, ILThe plt overran rwy 22 after landing downwind during intrument weather conditions. Fss had advised the plt of a NOTAM that rwy 4 ILS was out of service due to construction. However, another acft which landed on rwy 4 about 15 minutes prior to the accident…Nov 18, 1986 · N9843Y · Substantial damageNTSB ATL87LA022Accident · No injuriesLimited investigationFinal reportCessna 402C · Fremont, OHThe plt reported that he was about five feet above the rwy when he encountered a gust of wind. The acft rocked from side to side during the apch and touched down hard.Nov 18, 1986 · N6786P · Substantial damageNTSB LAX87LA041Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Chandler, AZAt the end of a local pleasure flight, the pilot attempted a downwind landing by following other traffic in the pattern. During touchdown, the left wing lifted. The pilot corrected by moving the control stick to the left. At that time, the aircraft became…Nov 17, 1986 · N4101E · Substantial damageNTSB CHI87LA036Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Gaylord, MIThe plt landed on a closed rwy and the acft collided with a snowbank. A NOTAM had been issued three days prior, closing the rwy, however, the plt stated that he had not checked notoms prior to departing traverse city. A plt of another acft, who reported being…Nov 16, 1986 · N2357E · Substantial damageNTSB CHI87LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Rockford, ILDuring landing roll, plt applied brakes too hard at high speed and nosed over.Nov 16, 1986 · N1457A · DestroyedNTSB BFO87IA008Incident · Minor injuriesIncident investigationFinal reportBoeing 727-231 · Norfolk, VADuring the landing roll the r main gear collapsed. A flight attendant received minor injuries during evacuation of the acft. Examination of the acft disclosed that the shock strut cylinder fractured circumferentially; about 10 inches below the top of the…Nov 16, 1986 · N64323 · Minor damageNTSB NYC87LA035Accident · No injuriesLimited investigationFinal reportCessna 185F · Ithaca, NYThe pilot of the landing Cessna 185 swerved to avoid hitting a deer that was crossing the runway at night. The left wing tip and elevator contacted the runway as the aircraft ground looped. The aircraft received substantial damage, however, it was able to…Nov 15, 1986 · N9680H · Substantial damageNTSB MKC87LA018Accident · No injuriesLimited investigationFinal reportCessna 150H · Flippin, ARWhile the student pilot was practicing touch-and-go landings, the airplane ran off the side of the runway, hit a ditch and flipped forward to the inverted position. The pilot stated he thought one of the brakes had locked. There was no signs of excessive…Nov 15, 1986 · N22037 · Substantial damageNTSB LAX87LA063Accident · No injuriesLimited investigationFinal reportCessna 310K · Phoenix, AZThe acft was landed hard while on a pleasure flt. The plt indicated that while en route to his destination it was discovered that the door was not properly shut. He diverted to Phoenix to shut the door. The acft was observed descending vertically from aprx 40…Nov 15, 1986 · N6953L · Substantial damageNTSB MIA87LA032Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Cedar Key, FLThe plt stated that he was not able to see the lighted wind sock from 1000 ft as he was unfamiliar with its location. The acft landed downwind on the rwy & was unable to stop before running off the end. A 15 to 20 kt tailwind was present at the time. The plt…Nov 14, 1986 · N20816 · Substantial damageNTSB DCA87MA012Accident · No injuriesMajor investigationFinal reportLockheed L1011 · Newark, NJOn November 13, 1986, the rear main spar of the right wing failed as delta flt 194 touched down on rwy 29 at Newark airport. The pilots stated that there was moderate turbulence on final approach and initial touchdown was on the right main gear first. The…Nov 13, 1986 · N714DA · Substantial damageNTSB CHI87LA024Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Minneapolis, MNThe pilot flew for an hour trying to get the gear extended, but was unable. After making a gear up landing, an exam revealed the centering cam on the left side of the nose gear was bent and broken. This could have caused the gear to jam and not extend.Nov 13, 1986 · N7668Y · Substantial damageNTSB NYC87LA031Accident · No injuriesLimited investigationFinal reportBeech BE18H · Pittsburgh, PAThe aircraft suffered a right landing gear leg breakage due to a fracture in the area where the fork assembly separated during landing roll.Nov 12, 1986 · N925J · Substantial damageNTSB LAX87LA037Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Buckeye, AZA Cessna T210N crashed when the pilot attempted to underfly wires during a go-around. The pilot misjudged the surface winds and made his final approach with a tail wind. When he passed the midpoint on the 2,600 ft airstrip and still was not on the ground he…Nov 11, 1986 · N1625U · Substantial damageNTSB DEN87LA019Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Goshen, UTThe plt was practicing power recovery autorotations then attempted one power off, full stop. The plt allowed the main rotor RPM to decay during approach and took no corrective action. The acft landed hard with slight forward motion and the plt applied aft…Nov 10, 1986 · N47042 · Substantial damageNTSB SEA87LA053Accident · No injuriesLimited investigationFinal reportPiper PA-46-310-P · Bremerton, WAThe nose gear did not turn the full 90 degrees prior to locking for landing. When the aircraft's nose was lowered during landing roll this caused the aircraft to veer to the side of the runway. The nose gear had become stiff due to the fact that the…Nov 9, 1986 · N4323N · Substantial damageNTSB SEA87LA022Accident · No injuriesLimited investigationFinal reportCessna 182G · Juneau, AKAccording to the plt, he 'greased' the acft on the rwy, but the cast alluminum yoke on the nose gear failed & the nosewheel left the airplane. The strut then failed & the acft was further damaged.Nov 9, 1986 · N2038R · Substantial damageNTSB CHI87DEV01Accident · No injuriesFinal reportPiper PA-34-200T · Bloomington, ILAccording to the plt, the acft bounced upon touchdown. She attempted to reflare the acft, however, it bounced again and a go-around was performed. The acft was then landed without further incident. Following the landing it was determined the acft had received…Nov 8, 1986 · N8156C · Substantial damageNTSB LAX87LA034Accident · No injuriesLimited investigationFinal reportCessna 172M · Shingle Springs, CAThe plt indicated that after landing the eng quit while turning the acft around on the rwy. He attempted to restart the eng several times but was unable. The plt then exited the acft and pushed it to the rwy shoulder. A local mechanic who was also a plt,…Nov 6, 1986 · N9674Q · DestroyedNTSB MIA87LA024Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Homestead, FLThe plt stated that he thought he had put the gear handle down but on touchdown the gear was up and the aircraft slid to a stop on the runway. Post crash examination of the landing gear system revealed that the landing gear was up when it contacted the runway…Nov 5, 1986 · N27418 · Substantial damageNTSB CHI87DEE03Accident · Serious injuriesFinal reportQuicksilver MX II · Aurora, ILThe pilot was making a precautionary landing in the ultralight, when during the landing flare he stalled the aircraft and subsequently collided with the terrain.Nov 5, 1986 · N4481P · Substantial damageNTSB MKC87LA013Accident · No injuriesLimited investigationFinal reportMooney M20D · Johnson, ARThe plt had attempted a localizer apch to fayetteville, AK, and stated that his VOR indicator would not hold course. The plt then elected to abort the apch and land at a pvt strip near the fayetteville VOR. The plt was able to land at the strip but according…Nov 4, 1986 · N5988Q · Substantial damageNTSB MIA87LA030Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8-24 · Brandon, FLA high sink rate was not arrested prior to the hard ldg. The plt stated that he briefed the pax on ldg procedures which included a tight grip in the event of an emerg ldg. The pax statements differed from those of the Balloon crew concerning the content of…Nov 4, 1986 · N37171 · No damageNTSB MKC87LA014Accident · No injuriesLimited investigationFinal reportCessna 170B · Hyannis, NEThe pilot stated that he was servicing customers while on this business trip. On his next call, the pilot further stated, he was to land in a hay field that he had previously used but, due to water in the area, he elected to land on higher grounds. Upon…Nov 3, 1986 · N8173A · Substantial damageNTSB CHI87LA034Accident · Serious injuriesLimited investigationFinal reportRaven S-66A · Baldwin, WIWhile landing, the passengers were instructed to stay to the side of the basket and hold on. However, one passenger moved toward the center of the basket and hit a video camera with her leg. During the occurrence, her leg was fractured between the knee and…Nov 2, 1986 · N4196N · No damageNTSB ATL87LA015Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Ada, OHPlt stated that elevator control was lost during the landing roll. Acft nosed over inverted and received substantial damage. Investigation revealed that the lower cable to elevator bellcrank forward turnbuckle was fractured. Bellcrank was badly corroded. Last…Nov 2, 1986 · N996D · Substantial damageNTSB NYC87LA029Accident · No injuriesLimited investigationFinal reportBeech 19 · Selkirk, NYPilot attempted a landing without left aileron control. The aircraft turned right then went into an uncontrollable slow spiral to the ground. The failed control rod end bearings showed evidence during post acc invest that they had not been lubricated for a…Nov 1, 1986 · N6552R · DestroyedNTSB ATL87LA014Accident · No injuriesLimited investigationFinal reportBoeing B-75-N1 · Columbus, OHDuring a landing attempt on asphalt surfaced runway 23, the pilot reported that the aircraft swerved to the left upon touchdown. Right alleron and rudder was applied to stop the turn. Wheel brakes were applied and the aircraft nosed over on the side of the…Nov 1, 1986 · N220SS · Substantial damageNTSB MIA87LA018Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Ft. Pierce, FLA USCG helicopter had landed on rwy 4 moments before the accident and had cleared the rwy. The helicopter had advised the acft on UNICOM frequency of his intent to land. The acft advised the helicopter that he had him in sight and would follow him in. The…Oct 31, 1986 · N8969C · Substantial damageNTSB LAX87FA028Accident · Serious injuriesField investigationFinal reportFairchild Swearingen SA-226TC · Santa Barbara, CAOn a dark night, in cavu weather, the captain directed the first officer (who was flying) to disarm the landing gear warning horn system by pulling its circuit breaker. The f/o complied & did not challenge the captain. On final approach the f/o failed to…Oct 31, 1986 · N137WW · Substantial damageNTSB CHI87LA013Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Harrisburg, ILAccording to the plt, the winds at the destination arpt were variable and gusty. During an approach to land, the acft was high. Reportedly, the wind shifted to a tail wind as the plt was landing & the acft continued off the end of the rwy & went thru a fence.Oct 31, 1986 · N3066T · Substantial damageNTSB MIA87LA017Accident · No injuriesLimited investigationFinal reportCessna 152 · Boca Raton, FLThe plt stated that he was about to conduct his first touch-&-go ldg after a local solo training flt. On the first ldg, he said he made a 'slight bounce' & he leveled the acft & set up for another flare. He said the acft touched down again on the mains but…Oct 30, 1986 · N93588 · Substantial damageNTSB MIA87LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Melbourne, FLThe plt was making her 1st solo ldg when the acft began to balloon & porpoise. The acft hit the rwy on the nose & prop then came to rest beside the rwy. A witness stated that the acft had 'got away from her'. The plt stated the accident could have been…Oct 30, 1986 · N242FT · Substantial damageNTSB FTW87LA013Accident · No injuriesLimited investigationFinal reportCessna 182J · England Afb, LAThe plt was on an apch into England Afb, LA, behind a flt of 4 jet fighters. He stated that at aprx 200 ft past the threshold, while at about 3 ft AGL & 80 mph, the acft suddenly fell & touched down on the main gear. It then porpoised btn the main & nose gear…Oct 29, 1986 · N2602F · Substantial damageNTSB MIA87LA014Accident · No injuriesLimited investigationFinal reportCessna 172P · Pompano Beach, FLThe plt stated that during touch-&-go landing practice on his final landing, he landed hard, the nose gear collapsed and the acft slid to a stop on the runway.Oct 28, 1986 · N63328 · Substantial damageNTSB FTW87LA009Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Pollok, TXThe dual student was receiving emergency landing training. Power was reduced while on approach which resulted in a loss of airspeed and a high sink rate. Corrective action was initiated too late and the aircraft touched down a few feet short. The landing gear…Oct 28, 1986 · N1325T · Substantial damageNTSB SEA87LA015Accident · Minor injuriesLimited investigationFinal reportMooney M20D · Hillsboro, ORThe pilot elected to land with a 12 to 15 knot tailwind. An excessive ground speed resulted with an overshoot. The pilot elected to go-around too late and once the go-around was attempted the aircraft struck trees at the departure end of the runway at about…Oct 27, 1986 · N6625U · DestroyedNTSB MKC87LA010Accident · No injuriesLimited investigationFinal reportCessna 185 · Oakley, KSThe plt stated his landing apch was too fast and the acft touched down long. He then applied brakes and the acft nosed down resulting in the propeller striking the rwy. The acft then proceeded to flip over onto it's back. The plt stated he should not have…Oct 27, 1986 · N5195H · Substantial damageNTSB DCA87AA006Accident · Serious injuriesFinal reportBoeing 737-222 · Charlotte, NCDrg arr, piedmont flt 467 was vectored for an ILS rwy 36R apch. At 2001 CDT (aprx 7 min bfr lndg), all arrg flts were adzd the wx was (in part): 400' ovc, vis 2 mi with lgt rain & fog, wnd fm 090 at 8 KTS. Rwy 5/32 was out-of-svc at that time. Flt 467 was…Oct 26, 1986 · N752N · DestroyedNTSB NYC87DFA01Accident · No injuriesFinal reportCessna 150M · Oriskany, NYThe student & instructor plt (CFI) were making a night, touch-&-go landing, when the acft struck a deer on the rwy. They were unable to see the deer in time to avoid a collision.Oct 25, 1986 · N3030V · Substantial damageNTSB CHI87LA014Accident · No injuriesLimited investigationFinal reportBeech V35A · La Pointe, WIThe acft struck a deer during the landing flare. The plt was able to maintain control of the acft and complete the landing even though the acft sustained substantial damage to the right wing and its associated structure.Oct 24, 1986 · N8360N · Substantial damage