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 MKC84FU003Accident · Serious injuriesFinal reportAmerican Aerolights Eagle XL · Millard, NEThe plt of the ultralight vehicle was flying as #2 in a flt of 2. The plt of the lead acft stated that they observed rain showers south of Millard & elected to return to the arpt ahead of the precipitation. After arriving, they landed on a 40 ft wide taxiway…May 5, 1984 · UNREG · Substantial damageNTSB FTW84LA229Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Seymour, TXThe 27 hour student plt aborted his landing when the acft began to balloon. The plt retracted the flaps and the acft settled hard onto the rwy and bounced back into the air. The plt reacted by pulling back on the yoke and inadvertently applied left aileron…May 5, 1984 · N5457Q · DestroyedNTSB CHI84LA321Accident · No injuriesLimited investigationFinal reportCessna 177 · Hobart, INThe plt figured he was high and hot during landing so he said he just pushed the nose over and forced the acft onto the rwy. The acft hit hard on the nose gear and bounced. After recovery the plt found the nose gear tire flat and taxiied off the rwy into the…May 5, 1984 · N2959X · Substantial damageNTSB ATL84LA162Accident · No injuriesLimited investigationFinal reportCessna 152 · Greensboro, NCThe student reported that he flared too high & the acft bounced about 4 times after which it left the rwy. The nose gear collapsed as it contacted mud beside the rwy.May 5, 1984 · N757AS · Substantial damageNTSB ATL84LA161Accident · No injuriesLimited investigationFinal reportWaco RNF · Thomaston, GADuring the landing roll the acft drifted to the side of the sod strip where a wheel encountered a surface deviation. The acft turned & nosed over.May 5, 1984 · N11256 · Substantial damageNTSB SEA84LA099Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Sherwood, ORDuring landing the acft swerved off the rwy. The plt stated that the recommended procedure at this arpt is to land uphill. Investigation revealed that the landing was made with a 9 kt quartering tailwind.May 2, 1984 · N222WY · Substantial damageNTSB NYC84LA156Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Vultee L-13A · Dummerston, VTDuring arrival, the plt landed to the south on a turf rwy. He stated that after a normal apch & touchdown, the acft encountered a gust of wind, presumably from the northwest & the acft nosed over. Also, in an accident report, he reported the wind was from the…May 2, 1984 · N90426 · Substantial damageNTSB CHI84LA173Accident · No injuriesLimited investigationFinal reportBeech A36 · Minneapolis, MNThe acft touched down hard during the landing. The nose gear collapsed and the acft slid to a stop. The plt said he was not able to arrest the sink rate of the acft with power during the landing flare.May 2, 1984 · N3735Y · Substantial damageNTSB LAX84LA276Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26D · Vacaville, CAThe student, glider plt stated that he encountered a loss of lift while on the downwind side of a hill. Subsequently, he selected a field for an off-arpt landing. On final apch, the plt noticed a fence in the middle of the field & was unable to avoid it. He…Apr 30, 1984 · N7562 · Substantial damageNTSB LAX84LA310Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Death Valley, CAAccording to the plt, the approach to rwy 33 was in a 'no-wind condition until about 30-40 ft AGL when a strong tail wind came up.' He stated that it appeared that there was sufficient rwy remaining and when he realized it was too late to stop or go around he…Apr 29, 1984 · N80762 · Substantial damageNTSB LAX84LA274Accident · No injuriesLimited investigationFinal reportHall-Cavalier SA-102.5 · Palo Alto, CADuring a landing, the acft bounced & porpoised several times and the nose gear failed. Subsequently, the acft skidded to a stop on the rwy & a fire erupted in the eng compartment. The occupant exited the plane, but moments later, it was consumed by the fire.Apr 29, 1984 · N491HC · DestroyedNTSB NYC84LA150Accident · No injuriesLimited investigationFinal reportCessna 152 · Laconia, NHThe acft ballooned during landing and came down hard on the nose gear which collapsed. The plt said a gust of wind had made the acft ascend about 20-50 ft after which it fell to the rwy. He reported the prevailing wind was variable from 270 to 290 deg a 12…Apr 28, 1984 · N5171B · Substantial damageNTSB MKC84LA130Accident · No injuriesLimited investigationFinal reportCessna 152 · N.Carlisle, ARThe acft nosed over after swerving off the rwy into soft sod during landing. The student plt was on his 2nd solo flt andpracticing touch and go landings. This was the plts 1st landing at carlisle arpt where the wind was of more velocity and greater angle than…Apr 28, 1984 · N4823L · Substantial damageNTSB LAX84LA272Accident · Serious injuriesLimited investigationFinal reportDouglas DC-6A · San Manuel, AZThe acft skidded off the departure end of the rwy collapsing the landing gear in a ditch as it caught on fire. This acftwas on a ferry flt and had several mechanical problems. Among these was the prop reversers which failed on landing. The anti-ice/de-ice…Apr 28, 1984 · N92860 · DestroyedNTSB LAX84LA271Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Vacaville, CAThe flight was conducted for a sales demonstration. Both occupants were pilots. Two landings were performed by the acft owner. The third landing was performed by the prospective buyer and during touchdown the acft bounced. The owner applied power to recover.…Apr 28, 1984 · N40329 · Substantial damageNTSB CHI84LA170Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Shelbyville, ILAfter a normal 3-point, full stall landing, the tailwheel equipped acft rolled a short distance, then veered to the left. The plt stated that he applied right rudder & both brakes, but the acft continued to the left. He reported that as the plane went off the…Apr 28, 1984 · N1955B · Substantial damageNTSB NYC84LA153Accident · Minor injuriesLimited investigationFinal reportBeech B24R · Clinton, MDThe main rwy at the arpt was closed due to resurfacing. The plt was attempting a landing on rwy 31 knowing it would be a deliberate downwind landing. According to the operator of the arpt, plts were discouraged from using rwy 13 because the traffic directly…Apr 27, 1984 · N6605R · DestroyedNTSB NYC84FA149Accident · 1 fatalField investigationFinal reportCessna 170B · Turner, MEWitnesses observed the acft approach, flaps down, for lndg. A flare was made near the approach end of the runway, then the acft ballooned to about 20 ft AGL and once more descended to the runway surface. On touchdown, the right wing tip appeared to contact…Apr 26, 1984 · N3112A · DestroyedNTSB MIA84LA152Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Valdosta, GAThe instructor plt (CFI) stated that he was giving a private plt a biennial flt review & that the private plt was the plt-in-command (PIC). While in the traffic pattern for their 2nd landing, they heard another acft entering the pattern, but they were not…Apr 26, 1984 · N7059P · Substantial damageNTSB CHI84LA162Accident · Minor injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Palmyra, WIThe pilot lost control of the acft on the landing flare & collided with a tree. The acft was blown to the left of the rwy & before he could execute a go-around the propeller struck some high brush alongside the rwy. The plt pulled power off, landed in rough…Apr 26, 1984 · N47583 · Substantial damageNTSB SEA84LA095Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Davenport, WADuring the landing roll the brakes were applied with no effect. The acft went off the end of the rwy into a ditch and nosed over. Examination of the acft showed the brake system low on fluid and the master cylinder diaphragm ruptured.Apr 25, 1984 · N6002D · Substantial damageNTSB MIA84LA151Accident · No injuriesLimited investigationFinal reportCessna 172M · Ocala, FLDuring a landing, the plt lost directional control & the acft veered off the left side of the rwy. The nose gear struck a concrete drainage conduit & was substantially damaged. The plt reported the wind was from 090 deg at 8 KTS.Apr 25, 1984 · N4657Q · Substantial damageNTSB CHI84LA171Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Marion, INThe student plt reported that during a landing, he reduced the power too soon & flared the acft too high, then the acft bounced about 8 to 10 ft in the air. The hard landing resulted in spar damage to the right wing.Apr 25, 1984 · N3874W · Substantial damageNTSB CHI84LA159Accident · No injuriesLimited investigationFinal reportCessna 152 · Stow, OHThe student plt was landing on rwy 1 with a gusty x-wind condition. On final apch, he crabbed to compensate for the x-wind. He stated that at about 10 ft AGL, the acft encountered a gust of wind & stalled onto the rwy. It then bounced, touched down nosewheel…Apr 25, 1984 · N94213 · Substantial damageNTSB ATL84LA152Accident · No injuriesLimited investigationFinal reportBeech E55 · Charleston, SCAfter the landing the acft landing gear retracted during a period of maximum braking to avoid an arresting cable. During the examination of the landing gear door damage it was determined that the landing gear was retracted during the landing roll.Apr 25, 1984 · N85052 · Substantial damageNTSB SEA84LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Boulder City, NVThe acft nosed over after a loss of control following a bounced landing.Apr 24, 1984 · N95434 · Substantial damageNTSB MIA84LA173Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Venice, FLThe acft was ditched in the gulf of Mexico after being followed by U.S. Customs. The plt was picked up, but would not state his departure point or destination, nor did he submit a plt/operational acft accident report as requested by the NTSB.Apr 24, 1984 · N1931H · DestroyedNTSB FTW84LA210Accident · No injuriesLimited investigationFinal reportBellanca 17-31ATC · Rocksprings, TXThe plt stated that the cabin door opened in-flight. While making a landing at Rocksprings in order to shut the door, the plt failed to use the checklist and landed the acft with the gear up. The acft was equipped with an auto gear extender, but because of…Apr 24, 1984 · N39815 · Substantial damageNTSB LAX84LA268Accident · No injuriesLimited investigationFinal reportCessna 182L · San Carlos, CAThe plt made four unsuccessful landing attempts followed each time by a go-around. The first attempt the acft bounced onlanding. The second attempt the acft bounced several times. The third attempt the plt stated that the wind pushed the acft from over the…Apr 23, 1984 · N3162R · Substantial damageNTSB LAX84LA266Accident · No injuriesLimited investigationFinal reportCessna 185 · Nogales, AZThe acft landed hard bounced and swerved on and off the rwy. When the acft stopped the left main gear had collapsed. Theplt reported that the wind blew him but the manager of the arpt said the plt flared too high.Apr 23, 1984 · N9953N · Substantial damageNTSB DEN84LA136Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7B · Fargo, NDDuring a Balloon landing which the plt described as normal, a pax banged her knee & broke her knee cap.Apr 23, 1984 · N3604U · No damageNTSB LAX84LA264Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Palo Alto, CAThe student plt made a hard bouncing landing which broke the nose gear. The FAA inspector said neither the flying club nor the student's instructor had authorized the flt. The student said he received a slight concussion & could not recall the accident.Apr 22, 1984 · N48201 · Substantial damageNTSB NYC84LA144Accident · No injuriesLimited investigationFinal reportCessna 152 · Pittsburgh, PAThe acft ballooned during the flare for landing & ended up in a nose down condition. The plt said he decided to stall the acft only a few ft off the ground as he estimated 2/3 of the rwy remained & a go-around was not necessary. The acft came to a stop on its…Apr 21, 1984 · N89880 · Substantial damageNTSB MKC84LA127Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Bloomfield, IAAccording to FAA records, the student plt recieved a wx briefing at 1000 CST. At that time, the latest wx observation at ottumua, IA, (closest wx station to broomfield, IA) showed the wind was from 110 degs at 11 KTS. About 25 mins after the briefing, the…Apr 20, 1984 · N6715W · Substantial damageNTSB ATL84LA146Accident · No injuriesLimited investigationFinal reportBeech C-24R · Bedford, VAThe straight-in approach was high over the trees on the approach end of the rwy. The plt waited until he was 1/2 way down the 3000 ft rwy to reduce eng power to idle. The acft floated before dropping to the rwy & bouncing back into the air. Power was applied…Apr 20, 1984 · N1827Z · Substantial damageNTSB SEA84LA092Accident · No injuriesLimited investigationFinal reportCessna 180H · Seattle, WAThe acft nosed over during the landing roll. The plt reported he used excessive braking.Apr 19, 1984 · N91381 · Substantial damageNTSB LAX84LA263Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Arbuckle, CAThe ldg was made on an ag airstrip with a right quartering tailwind. Upon touchdown, the plt 'felt what appeared to be either a dragging left brake and/or the rough surface' of the landing strip. The landing was aborted. On the next landing, the acft nosed…Apr 19, 1984 · N6651Q · Substantial damageNTSB DEN84LA131Accident · No injuriesLimited investigationFinal reportCessna 140 · Miller, SDThe acft ground-looped during the plt's first solo landing & the right main landing gear sheared off. The CFI said the student had made between 30 to 40 landings prior to the solo flt.Apr 19, 1984 · N89740 · Substantial damageNTSB ATL84LA145Accident · No injuriesLimited investigationFinal reportGrumman G164A · Huger, SCThe aerial application acft was using a gravel surfaced dirt road as a temporary landing strip. During the landing roll the acft drifted to the left & hit a soft spot, a tree, & nosed over in a ditch.Apr 19, 1984 · N7856 · Substantial damageNTSB MKC84LA126Accident · No injuriesLimited investigationFinal reportPiper PA28-180 · Holdrege, NEThe student plt was on a solo x-country flt. His 1st en route stop was at Holdrege, NE. He aborted his 1st attempt to land & made a 2nd apch. In the meantime, the plt of another acft landed & experenced turbulent winds. When the student landed (after the 2nd…Apr 18, 1984 · N1961T · Substantial damageNTSB LAX84LA260Accident · Minor injuriesLimited investigationFinal reportHughes 269 · Mesa, AZThe acft landed hard during an autorotation demonstration by a CFI. During landing the rotor blades severed the tail andthe acft went into ground resonance. The CFI said he thought the acft lost transitional lift. He recommended not practicing autorotations…Apr 17, 1984 · N8773F · Substantial damageNTSB FTW84LA202Accident · No injuriesLimited investigationFinal reportCessna 500 · Oklahoma City, OKDuring a proficiency flt check, the aircrew was making a N0-flap landing. After completing the landing checklist down to the landing gear, power was reduced causing the landing gear audible warning to sound. The horn silence switch was depressed & the apch…Apr 17, 1984 · N92FA · Substantial damageNTSB DEN84LA130Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Ruidoso, NMThe plt stated that a combination of high ground speed, turbulence and a downdraft caused the aircraft the rwy. The plt said he thought it better to land as he did than to attempt a go-around because of high terrain to the north.Apr 17, 1984 · N6174H · Substantial damageNTSB MKC84LA124Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Little Rock, ARThe acft swerved during landing in a x-wind and the right main gear collapsed. The plt said he slipped the acft to lose altitude to land and did not get a 'feel' for the wind direction as a result.Apr 16, 1984 · N3300A · Substantial damageNTSB SEA84LA085Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5B · Driggs, IDDuring a landing, the plt encountered a porpoise which increased in severity. He added full power, raised the nose & initiated a go-around, during which, the stall warning horn sounded. The plt reported that he left the carburetor heat on & left the flaps in…Apr 15, 1984 · N28291 · DestroyedNTSB NYC84LA140Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Mayville, NYOn an apch to land, after a go-around, the acft crossed over wires & touched down on the 1st half of the rwy. The plt applied brakes on the wet grass rwy, but noted a lack of braking action. He applied power to go around, but decided the acft would not clear…Apr 15, 1984 · N3977Q · Substantial damageNTSB FTW84LA197Accident · Serious injuriesLimited investigationFinal reportBeech 95-B55 · Granbury, TXDuring a x-country flt, the plt landed at stephenville, TX, for fuel, but was unable to purchase any. Therefore, he proceeded to Granbury, TX, for fuel before continuing to chattanooga, TN. A witness heard the acft, then observed it porpoising down the last…Apr 15, 1984 · N3050 · Substantial damageNTSB DEN84LA129Accident · No injuriesLimited investigationFinal reportCessna 140 · Aurora, COAccording to the plt, the acft suddenly ground looped during the landing & departed the rwy. An investigation revealed that the left gear leg had collapsed at some time during the accident sequence. The left gear leg pin, which was found sheared, had a dark…Apr 15, 1984 · N89984 · Substantial damageNTSB CHI84LA154Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Kenosha, WIThe plt stated he mistook the ATIS reported winds of 020 deg at 21 KTS as 210 deg at 20 KTS. After executing the VOR rwy 14 apch, he continued to land on rwy 14. There was standing water on the rwy. While landing with a tail wind, the acft hydroplaned & ran…Apr 15, 1984 · N8667P · Substantial damageNTSB SEA84LA089Accident · No injuriesLimited investigationFinal reportFornaire F-1 · Everett, WAThe acft made a hard landing and bounced. The plt said he thinks he hit a downdraft. The acft went off the rwy into the grass and damaged the nose gear and the fuselage.Apr 14, 1984 · N7535C · Substantial damage