NTSB investigations, AL

748 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.\"eventStateOrRegion\" = 'AL' AND c.\"eventCountry\" = 'USA'
    AND 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 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 ATL86LA268Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Roanoke, ALReportedly, during the landing roll, the acft went off the right side of the rwy and continued across a shallow ditch and down an embankment. The plt stated that the acft did not RESP0ND to control and brake inputs to correct the swerve in calm winds. The FAA…Jun 5, 1986 · N8838K · Substantial damageNTSB ATL86LA134Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Enterprise, ALDuring the touchdown landing phase on runway 23, the aircraft veered off the left side and crashed following an attempted go-around. The pilot applied full power, but was unable to clear a tree line off the departure end. As the pilot elected to abort, the…May 17, 1986 · N25737 · 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 ATL86FKG02Accident · No injuriesFinal reportCessna 152 · Pell City, ALThe acft nosed over following a loss of control during a x-wind landing. The student plt stated he crabbed the acft intothe wind to compensate for the x-wind during the apch. The acft touched down still in the crabbed position and traveled off the right side…Oct 6, 1985 · N49446 · Substantial damageNTSB ATL85FKG12Accident · No injuriesFinal reportCessna 172P · Birmingham, ALDuring arrival, the plt noted that the wind was from about 150 degs. Due to the terrain & obstructions near the northeast end of the rwy, he elected to land on rwy 4. During the landing, the acft floated before touching about 1/3 to 1/2 of the way down the…Sep 22, 1985 · N5227K · Substantial damageNTSB ATL85LKG13Accident · No injuriesFinal reportCessna 182N · Panala, ALThe acft collided with a tree during lndg which pulled it to the left off the road chosen for landing. The plt applied pwr to clear a ditch and the acft came to rest in a row of small trees. The plt had said the eng had started missing after takeoff from the…Sep 18, 1985 · N92746 · Substantial damageNTSB ATL85LA265Accident · No injuriesLimited investigationFinal reportBellanca Champion 7GCAA · Alabaster, ALThe plt lost directional control of the acft during a landing. The acft nosed over coming to rest inverted. The plt related that a gust of wind caused the loss of control.Sep 1, 1985 · N7559F · Substantial damageNTSB ATL85LA192Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Ashford, ALThe plt was returning to the private ag strip after completing a spray run. During the landing the pilot found that the left brake was inop. In order to prevent running off end of the 1500 ft rwy, the plt elected to ground loop the aircraft. During the…Jun 27, 1985 · N609U · Substantial damageNTSB ATL85LA164Accident · No injuriesLimited investigationFinal reportCessna 177B · Huntsville, ALThe acft drifted right of rwy center line during landing roll & the plt aborted the landing by applying full pwr. The acft continued off the rwy and the nose wheel dug into the soft soil resulting in the acft nosing over.May 16, 1985 · N34494 · Substantial damageNTSB ATL85LA159Accident · No injuriesLimited investigationFinal reportCessna 150M · Andalusia, ALThe student plt reported that during a landing roll, the acft veered to the right, went off the right side of the rwy & collide with a dirt bank.May 11, 1985 · N3682V · Substantial damageNTSB ATL85LA158Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Greenville, ALThe plt stated that he made a normal apch for a full stop, 3-point landing. During the landing roll, the acft began to vibrate & shake laterally. The plt reported that the vibration was caused by a tail wheel shimmy, but at first, he did not realize what…May 11, 1985 · N477M · Substantial damageNTSB ATL85LA131Accident · No injuriesLimited investigationFinal reportMooney M20E · Gunthersville, ALThe plt reported that he failed to extend the landing gear in the traffic pattern. Subsequently, the acft was damaged during a gear up landing.Apr 10, 1985 · N7153U · Substantial damageNTSB ATL85LA022Accident · No injuriesLimited investigationFinal reportBeech 95 · Birmingham, ALPlt reported apch was high and fast but when the nose gear touched down during the normal landing, the nose gear tire blew. A witness stated the acft porpoised several times and then impacted on the nose gear resulting in the blown out tire.Oct 26, 1984 · N2773Y · Substantial damageNTSB ATL84LA272Accident · No injuriesLimited investigationFinal reportCessna 152 · Fair Hope, ALThe plt excessively flared the acft on landing at which time the acft ballooned. Recovery from the balloon was made but upon touchdown, the acft was not aligned with the rwy. The acft traveled off the left side of the rwy and contacted several small trees.Aug 25, 1984 · N25945 · Substantial damageNTSB ATL84LA237Accident · No injuriesLimited investigationFinal reportCessna 152 · Enterprise, ALThe student plt flared at about 40 ft AGL with pwr off. The CFI who was watching said he did not hear any sounds of pwr being applied until the acft was bouncing and then only heard partial power. This was the students 1st solo landing. Theinstructor said he…Jul 28, 1984 · N5377B · Substantial damageNTSB ATL84LA196Accident · No injuriesLimited investigationFinal reportMooney M20E · Seale, ALThe plt approached downwind at 80 mph with full flaps. At touchdown the acft bounced and floated about 600 ft before a 2nd touchdown. When the acft could not be stopped on the short grass rwy, it was groundlooped to stay on the arpt. During the groundloop the…Jun 9, 1984 · N3494X · Substantial damageNTSB ATL84LA178Accident · No injuriesLimited investigationFinal reportCessna 152 · Lacey Springs, ALWhen the plt was arriving at the uncontrolled arpt, no UNICOM was available, since the office was closed. The plt elected to land on rwy 24 after seeing another acft depart. The 1st apch was aborted due to gusty winds. After the 2nd apch, the acft touched…May 20, 1984 · N6231B · Substantial damageNTSB ATL84LKG03Accident · No injuriesFinal reportCessna 152 · Albertville, ALThe acft ran off the left side of the rwy during landing and nosed over. The student plt said he was practicing touch and go landings solo and lost control of the acft.Feb 15, 1984 · N6418B · Substantial damageNTSB ATL84LA034Accident · No injuriesLimited investigationFinal reportCessna 150A · Dauphin Island, ALThe acfts nose gear collapsed during landing. The student plt was on a solo training mission to practice landings. The plt said he made a normal landing and as the nose gear was lowered he added slight right rudder to hold a roll parallel to the rwy…Oct 29, 1983 · N6673T · Substantial damageNTSB ATL84LA030Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Montgomery, ALAccording to the plt he had an unsafe gear indication while in the traffic pattern. He alerted the tower to the problem and made a low pass over the runway. He was informed by tower personnel that the gear looked down and normal. During the landing the plt…Oct 15, 1983 · N7013P · Substantial damageNTSB ATL84LA011Accident · No injuriesLimited investigationFinal reportBeech 58 · Montgomery, ALDuring an apch to land, the plt lowered the gear handle, but observed that the nose gear light did not come on & the right main gear light was flickering. Consequently, he recycled the gear operation. After that, he reportedly saw all 3 indicating down &…Oct 5, 1983 · N218RC · Substantial damageNTSB ATL84LA004Accident · No injuriesLimited investigationFinal reportMaule M-6-235 · Elberta, ALThe plt took off with a passenger, who was also a plt, but was not performing as such on this flt. After returning to the arpt, the plt landed on the north-south rwy. He stated that during the landing roll, he encountered a x-wind that caused the acft to…Oct 2, 1983 · N5646D · Substantial damageNTSB ATL84LA008Accident · No injuriesLimited investigationFinal reportCessna 152II · Hamilton, ALThe acft made a hard landing during a x-country flt. The acft was seen to make a slow approach and stall prior to touchdown. The acft landed hard and bounced after which the nose gear was damaged. The student plt had not landed at this arpt before.Oct 1, 1983 · N5523B · Substantial damageNTSB ATL83LA385Accident · No injuriesLimited investigationFinal reportBeech 58 · Birmingham, ALThe acft swerved off the rwy after the left tire deflated during heavy braking & the left landing gear collapsed during the swerve. The pilot stated the acft was rolling too fast after landing to make the first turn off. The pilot then applied heavy braking…Sep 30, 1983 · N31CE · Substantial damageNTSB ATL83LA375Accident · No injuriesLimited investigationFinal reportBeech 77 · Montgomery, ALThe student plt flew to Montgomery, AL, intending to make a touch-and-go landing, and then return to birmingham, AL. After arriving, he made an apch to rwy 09 with a wind from 360 deg at 10 gusting 14 KTS. While on the landing roll, the acft began to veer to…Sep 22, 1983 · N6715V · Substantial damageNTSB ATL83LA316Accident · No injuriesLimited investigationFinal reportCessna 195A · Elberta, ALThe acft ran off the departure end of the rwy into a ditch during landing. The landing was on a private airstrip with a wet grass rwy that sloped downhill in the direction of landing for the last 1/3 of the rwy. The acft landed about a quarter of the way down…Aug 6, 1983 · N9GH · Substantial damageNTSB ATL83IA208Incident · No injuriesIncident investigationFinal reportPiper PA-34-200T · Muscle Shoals, ALThe right main landing gear strut failed on landing roll. The cause for the failure was not determined, the owner would not make the strut available for testing.May 26, 1983 · N6935C · Minor damageNTSB ATL83LA166Accident · No injuriesLimited investigationFinal reportBeech C-23 · Birmingham, ALThe acft nose gear collapsed during landing on a student solo flt. The student and CFI flew a dual flt first and some airwork and 3 landings were accomplished. The 1st landing after the CFI got out of the acft was nose first with a bounceand a go-around. This…Apr 21, 1983 · N6022Y · DestroyedNTSB ATL83LA114Accident · No injuriesLimited investigationFinal reportCessna 172K · Scottsboro, ALThe acft was damaged in a hard landing. The plt did not believe the acft was substantially damaged and has disagreed with filing an accident report. Examination of the acft by a mechinic showed a partially collapsed nose gear buckled firewall and deformed…Feb 21, 1983 · N758NT · Substantial damageNTSB ATL83FA073Accident · No injuriesField investigationFinal reportCessna 421B · Fort Payne, ALDuring landing the right main landing gear scissors bolt & bushing pulled through the scissors mount hole allowing the landing gear to rotate 90 deg. An incorrect washer (standard 5/16 in) had been installed in the scissors assembly duringrecent maintenance.…Dec 23, 1982 · N3380Q · Substantial damageNTSB ATL83LA030Accident · No injuriesLimited investigationFinal reportMooney M20F · Talladega, ALPilot forgot to extend landing gear.Nov 13, 1982 · N6861V · Substantial damageNTSB ATL82DA271Accident · No injuriesFinal reportGrumman AA-5B · Moulton, ALAccording to the pilot, after touchdown he applied brakes and the right brake seemed to lock intermittently during the roll out. Black marks on the landing surface reveal the aircraft departed the right side and impacted an embankment and steel post. This was…Sep 13, 1982 · N4514B · Substantial damageNTSB ATL82DA235Accident · No injuriesFinal reportBeech 58 · Birmingham, ALThe pilot stated that after a normal touchdown and a landing roll of 300-500 feet the gear retracted/collapsed. Subsequently, the entire landing gear system was ground checked and normal function of the system was found. The aircraft flaps were found in the…Aug 12, 1982 · N7239R · Substantial damageNTSB ATL82DA230Accident · No injuriesFinal reportGrumman G164B · Opp, ALThe pilot reported that while he was spraying, vibrations occurred in the left flying wires. He had experienced the vibrations before, but this time, they seemed worse, he elected to land in a nearby pasture to examine the aircraft. During the landing…Aug 6, 1982 · N6637Q · Substantial damageNTSB ATL82DA157Accident · No injuriesFinal reportCessna 150F · Monroeville, ALAfter making a normal landing touchdown, the nosewheel was held off until it lowered naturally. The pilot stated that when the nosewheel touched down, it seemed that the wheel would not turn. At about that time, the nose gear collapsed and the propeller,…Jun 6, 1982 · N8780S · Substantial damageNTSB ATL82DA151Accident · No injuriesFinal reportPiper PA-34-200T · Stevenson, ALMain gear retracted during landing roll. A faulty relay was found in the retracting system. Piper part number 484373.Jun 1, 1982 · N28945 · Substantial damageNTSB ATL82DA113Accident · No injuriesFinal reportPiper PA-38-112 · Montgomery, ALThe student pilot was on his second supervised solo flight. After a 30 minute local flight, he returned to the airport to practice full-flap, touch and go landings on runway 9. The wind was from 100 degrees at 11 knots. During his first landing, the student…Apr 23, 1982 · N2368B · Substantial damageNTSB ATL82DA099Accident · No injuriesFinal reportPiper PA-28-140 · Huntsville, ALShortly after a normal touchdown the aircraft yawed and veered to the left. The pilot elected to go-around and added full power. The aircraft departed the left side of the runway and collided with a barbed wire fence. The aircraft settled into a plowed field…Apr 10, 1982 · N1499H · Substantial damageNTSB ATL82IA076Incident · No injuriesIncident investigationFinal reportCessna 172F · Mobile, ALUpon arrival at the aircraft, the pilot noted that the nose gear strut was under inflated. The pilot, who is training to be an A&P mechanic, diagnosed the problem as an oil leak. However, to avoid aborting the flight, he inflated the strut with air only and…Mar 20, 1982 · N8423U · Minor damageNTSB MIA08CA076Accident · 1 fatalData collectionFinal reportBeech C24R · Mobile, ALUndetermined.Mar 16, 1982 · N18878 · Substantial damageNTSB ATL82DKJ09Accident · No injuriesFinal reportCessna 310L · Auburn, ALThe pilot tookoff from north huntsville on a runway that was wet from melted snow. After takeoff, the gear would not retract, so he returned and landed. A mechanic found ice on the anti-retraction switch on the left main gear. A ground heater was used to melt…Jan 11, 1982 · N424VW · Substantial damageNTSB ATL82DKJ10Accident · No injuriesFinal reportBeech V35B · Tuskegee, ALDuring landing, the pilot put the landing gear and flap handles in the down positions. He heard noises that sounded like both had extended and assumed everything was in place. The pilot was unaware that the landing gear was not down until after touchdown. An…Jan 1, 1982 · N4275S · Substantial damageNTSB ATL82DKJ01Accident · No injuriesClosedPiper PA-28 · Dothan, ALOct 7, 1981 · N22199 · Substantial damageNTSB ATL82DKJ02Accident · No injuriesClosedPiper PA-28 · Hurtsboro, ALOct 4, 1981 · N47321 · Substantial damageNTSB ATL81FKJ36Accident · Minor injuriesClosedAir & Space 18A · Huntsville, ALSep 13, 1981 · N6154S · Substantial damageNTSB ATL81DKJ33Accident · Minor injuriesClosedPiper PA-28 · Brundidge, ALAug 26, 1981 · N2155F · Substantial damageNTSB ATL81DKJ29Accident · No injuriesClosedCessna 172N · Daviston, ALAug 10, 1981 · N5697E · Substantial damageNTSB ATL81DKJ28Accident · No injuriesClosedPiper PA-32 · Butler, ALAug 8, 1981 · N8165H · Substantial damageNTSB ATL81DKJ26Accident · No injuriesClosedPiper PA-28 · Bessemer, ALJul 25, 1981 · N5119G · Destroyed