OpenAirDocs.org

NTSB investigations

53,703 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 NYC88LA127Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Slatington, PAThe pilot landed at Slatington, Pennsylvania during strong wind conditions. When the pilot applied brakes, a sudden gust of wind lifted the left wing and pushed the aircraft off the right side of the runway down an embankment, and into a tree stump.Apr 17, 1988 · N4893L · DestroyedNTSB ATL88LA148Accident · No injuriesLimited investigationFinal reportCessna 182Q · Lowell, OHThe plt rptd that he landed in a 12-14 kt, 90 degree x-wind. The initial portion of the ldg rollout was shielded from the wind by a row of trees bordering part of the upwind side of the rwy. Upon reaching a clearing in the trees, the airplane was exposed to…Apr 17, 1988 · N759BJ · Substantial damageNTSB ANC88LA043Accident · No injuriesLimited investigationFinal reportCessna 185 · Fairbanks, AKThe pilot stated that he made a hard landing and at that time he lost directional control of the aircraft. The plt stated that the acft bounced and when he tried to correct the bounce the acft yawed left. The rt main gear collapsed and the acft groundlooped.Apr 17, 1988 · N5060R · Substantial damageNTSB SEA88LA079Accident · Minor injuriesLimited investigationFinal reportMooney M20E · The Dalles, OROn arrival, plt found destination obscured by unforecast fog, held briefly, then diverted to an alternate airport. On arrival at alt in darkness, plt did not know freq (UNICOM) to activate rwy lights. Plt made low pass to acquire rwy environment as fuel state…Apr 16, 1988 · N7158V · Substantial damageNTSB NYC88LA126Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Windham, CTThe pilot took off and flew a short pattern around the airport. The pilot stated that on descent from 1200 feet strong winds started pushing the aircraft and he was losing control. The aircraft bounced and he decided to go around. However, on climb out the…Apr 16, 1988 · N7504G · DestroyedNTSB MKC88LA078Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Red Cloud, NEAfter a first time familiarization flt, the pilot returned to the base field for ldg. During the landing attempt, the aircraft bounced, and on recovery, the pilot pitched the nose up too high. The aircraft stalled and then struck the runway damaging the…Apr 16, 1988 · N7071Z · Substantial damageNTSB MIA88LA153Accident · No injuriesLimited investigationFinal reportCessna 152 · Olive Branch, MSThe plt stated that as he was rolling out on the runway, the right wing lifted, and in an attempt to correct the situation, the acft went off the right side of the runway, flipped over and came to rest inverted.Apr 16, 1988 · N4830B · Substantial damageNTSB CHI88LA100Accident · No injuriesLimited investigationFinal reportCessna 182D · Mt. Vernon, ILAfter electing to go-around on his first approach, the student pilot ballooned the aircraft as he passed over the runway on the second approach. Remedial action was attempted, but the pilot overcontrolled and the aircraft struck the runway slightly nosewheel…Apr 16, 1988 · N8891X · Substantial damageNTSB MIA88IA150Incident · No injuriesIncident investigationFinal reportBeech 58 · Jacksonville, FLThe plt stated that while on landing rollout, the gear collapsed & the acft slid to a stop on the runway. Post crash examination of the landing gear revealed evidence that would suggest that the gear was up and locked at the time the acft landed.Apr 15, 1988 · N796Q · Minor damageNTSB MKC88LA076Accident · No injuriesLimited investigationFinal reportCessna 182E · Clarksville, ARWhile attempting to land at night on a radio activated runway lighted airport, PIC was unable to activate the system. After several attempts to activate the runway lights, he elected to land on the unlighted runway. He aligned about 20 yards right of…Apr 14, 1988 · N9373X · Substantial damageNTSB LAX88LA160Accident · No injuriesLimited investigationFinal reportBell 47D1 · Taft, CAApr 13, 1988 · N917B · Substantial damageNTSB ATL88LA141Accident · No injuriesLimited investigationFinal reportCessna 170A · Athens, GAThe plt of a Cessna 170A had departed albany, GA VFR with no flt plan for Athens, GA. A Cessna R172K from the Athens airport was engaged in local flying. The 172 retd from doing airwork and was making a full stop ldg. During his landing roll the plt reptd…Apr 13, 1988 · N1213D · 2 aircraft · Substantial damageNTSB NYC88LA123Accident · No injuriesLimited investigationFinal reportCessna 185 · Hopedale, MAThe pilot said he flared too high and landed hard. The pilot stated that the prop contacted the ground, the right landing gear broke, and the rt wing contacted the ground and was bent rearward during the hard landing. The plt did not file an acc report.Apr 11, 1988 · N4695E · Substantial damageNTSB LAX88LA156Accident · Serious injuriesLimited investigationFinal reportEiriavion PIK 20D · Saint Helena, CAThe flight departed vacaville gliderport on an aero tow. The plt intended to fly to calistoga, CA and return. After passing st. Helena, CA, the thermal activity began to decrease. The plt executed a 180 deg turn to return to vacaville. When the flt was over…Apr 11, 1988 · N1NZ · Minor damageNTSB MIA88FA142Accident · Serious injuriesField investigationFinal reportCessna 172N · Vero Beach, FLThe acft was observed to touch down on rwy 36 with full flaps on the grass strip bordered on both sides by citrus groves, surface winds in the area were 120 degs at 11 KTS. The acft was observed to drift to the left off the rwy toward the grove. The plt…Apr 10, 1988 · N6283F · DestroyedNTSB MIA88LA145Accident · No injuriesLimited investigationFinal reportCessna 140A · Lakeland, FLWhile on a personal flt during the landing roll after the plt applied the brakes, the acft nosed over & came to rest inverted. He stated that the left brake locked up & after the acft was removed from the rwy, he disassembled each brake assy in an effort to…Apr 9, 1988 · N84SC · Substantial damageNTSB CHI88IA096Incident · No injuriesIncident investigationFinal reportSwearingen SA-227AC · Fort Wayne, INInadequate design of the strut for the intended service conditions in commuter air carrier operations.Apr 8, 1988 · N448CA · Minor damageNTSB MKC88LA074Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Springfield, MOWhile attempting to land on a narrow runway, with approaching thunderstorms within 4 miles of the airport, directional control was lost by the plt during the rollout. Plt stated a sudden change in surface wind direction made it impossible for him to maintain…Apr 5, 1988 · N62551 · Substantial damageNTSB ATL88LA132Accident · No injuriesLimited investigationFinal reportBeech M35 · Mc Cullough, ALThe plt stated that he was landing at his destination arpt when the accident occurred. The turf/grass was wet. The acft overran the end of the rwy and collided with the terrain, several trees, and bushes. There were no mechanical malfunctions reported.Apr 4, 1988 · N2255K · Substantial damageNTSB MIA88LA140Accident · No injuriesLimited investigationFinal reportStart & Flug H101 Salto · Winter Haven, FLThe flt entered the downwind leg for landing when the plt observed a glider parked 600 ft from the planned touchdown point. He elected to land to the left of the glider & after turning base then final, observed individuals pushing it towards the planned…Apr 3, 1988 · N999WC · Substantial damageNTSB FTW88DRG08Accident · No injuriesFinal reportBoeing Stearman E-75 · Fisher, TXAfter touchdown, the pilot stated that he lost directional control and the right main gear ran off the right side of the runway. During attempted recovery, the airplane rolled off the left side of the runway, collided with a drainage ditch and nosed over to…Apr 3, 1988 · N75031 · Substantial damageNTSB BFO88LA033Accident · No injuriesLimited investigationFinal reportCessna 150M · Chesterfield, VAThe student pilot lost directional control of the acft during landing roll. The acft traveled off the left side of the rwy and contacted a ditch. The landing was being made on rwy 15. Winds were from 190 degrees at 7 knots.Apr 3, 1988 · N63632 · Substantial damageNTSB NYC88LA124Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Warwick, NYDuring takeoff and landing practice, the aircraft veered left off of the runway despite reported full right rudder application by the pilot. The aircraft continued to roll across the grass and came to rest after colliding with a construction ditch.Apr 2, 1988 · N9326K · Substantial damageNTSB FTW88DRA08Accident · No injuriesFinal reportGrumman G-164 · Palacios, TXThe plt stated that following a normal landing, he applied too much brake, causing the wheels to lock up. This, in turn, caused dead grass and mud to accumulate in front of the wheels. The acft subsequently flipped over and slid to a stop inverted.Apr 2, 1988 · N8150K · Substantial damageNTSB FTW88DPA03Accident · No injuriesFinal reportAir Tractor AT-502 · Olney, TXThe pilot was familiarizing himself with this type of aircraft and was making a full flap landing. He allowed the aircraft to drift left during the landing roll in a slight crosswind. He then attempted to abort the landing roll with the application of takeoff…Apr 2, 1988 · N7315N · Substantial damageNTSB ATL88LA129Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Stockbridge, GAThe airplane landed with the left wheel locked, and subsequently nosed over during the ldg roll. Post-crash exam revealed that the left wheel could not be rotated in the fwd direction by hand, and that it could be rotated aft by hand only with considerable…Apr 2, 1988 · N9871C · Substantial damageNTSB ATL88LA128Accident · No injuriesLimited investigationFinal reportBeech B19 · Albany, KYThe plt reported that he touched down about midfield on the 1,800 ft usable portion of the rwy. A light rain was falling at the time, and the rwy was wet. Braking action was poor, and the airplane subsequently overran the runway. The airplane traveled down an…Apr 1, 1988 · N6994R · Substantial damageNTSB ATL88LA126Accident · No injuriesLimited investigationFinal reportCessna 152 · Charleston, SCThe student plt rptd that the airplane was low on final appch, and that he applied pwr to maintain altitude. After crossing the rwy threshold, he reduced the pwr to idle & lowered the nose to maintain airspeed. He initiated a flare prior to touchdown, but the…Apr 1, 1988 · N68726 · Substantial damageNTSB MIA88LA143Accident · No injuriesLimited investigationFinal reportCessna 152 · San Juan, PRThe student plt completed 5 touch & go's with his instructor before dropping her off for first supervised solo flight. On the first touch & go landing , the acft bounced after touchdown on the main landing gear. The student plt added power, lowered the nose…Mar 31, 1988 · N89224 · Substantial damageNTSB MIA88LA135Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Captiva, FLThe pilot allowed the aircraft to descend below the normal approach angle and failed to correct the situation timely. The aircraft struck a seawall severing first the nose gear and then the main gear. The aircraft slid to a stop.Mar 30, 1988 · N8076D · Substantial damageNTSB NYC88LA116Accident · No injuriesLimited investigationFinal reportBell 206L · Allentown, PADuring an FAA flight check an autorotational descent was made with a planned power recovery, the helicopter fell through the maneuver and collided with the ground. The main rotor blades flexed downward, striking the horizontal fin winglets and the tail boom.Mar 29, 1988 · N114FH · Substantial damageNTSB LAX88LA143Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Payson, AZThe pilot reported that during the landing roll a dust devil (whirlwind) pushed the aircraft off the runway, colliding with the terrain resulting in substantial damage. The pilot reported that the wind velocity was 25 knots gusting to 30 as a quartering…Mar 29, 1988 · N8524D · Substantial damageNTSB BFO88FID02Accident · No injuriesFinal reportRotorway RW-145 · Ridgeway, VAThe student pilot was attempting to land from a 2 foot hover when the accident occurred. He reported that he overcontrolled the helicopter and a dynamic rollover resulted. A witness reported the helicopter was traveling downwind when it began to turn to the…Mar 29, 1988 · N107LH · DestroyedNTSB ANC88LA080Accident · No injuriesLimited investigationFinal reportChampion 7EC · Anchorage, AKThe private pilot lost directional control of the airplane during the landing roll. The aircraft groundlooped to the left, striking a fence. The pilot reported that he came in high and hurried his approach to fit in with the flow of air traffic at the…Mar 28, 1988 · N9061B · Substantial damageNTSB LAX88LA145Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Warner Springs, CAMar 27, 1988 · N2655H · Substantial damageNTSB LAX88LA139Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Lompoc, CADuring the landing roll with a crosswind of 15-20 knots, the pilot lost control of the aircraft, collided with the terrain and, approximately 200 yards off the runway, the aircraft nosed over.Mar 27, 1988 · N1374B · Substantial damageNTSB LAX88LA138Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Columbia, CAAt the end of a cross country flt, on touchdown, the acft began to bounce. The pilot was unable to stop the acft before it ran off the end of the rwy, where it came to rest after the left main gear collapsed. A witness said that the acft landed half way down…Mar 27, 1988 · N47766 · Substantial damageNTSB CHI88LA084Accident · No injuriesLimited investigationFinal reportCessna 152 · Salem, ILWhile attempting to land with a quartering tailwind, the student experienced a loss of directional control and elected to G0-around. On climbout he was unable to maintain the proper rate of climb, and once out of ground effect the aircraft started to descend.…Mar 26, 1988 · N96010 · Substantial damageNTSB CHI88LA083Accident · No injuriesLimited investigationFinal reportCessna 172N · Madison, WIThe pilot was landing on the 40 foot wide rnwy in a 10-12 knot x-wind. He stated he had little rnwy reference in the dark night due to a very faded rnwy centerline. The acft ran off the hard surface into the mud, ran into a depression in the soil and nosed…Mar 26, 1988 · N73954 · Substantial damageNTSB CHI88LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Mendota, ILDuring the landing roll, in gusty, crosswind conditions the upwind wing of the aircraft lifted and the aircraft experienced a noseover.Mar 26, 1988 · N35407 · Substantial damageNTSB BFO88LA032Accident · No injuriesLimited investigationFinal reportDreyer-Starduster SA-300 · Richlands, VAAfter touchdown, during the landing roll, the acft veered sharply to the left. The plt attempted to correct this action by applying right rudder and the acft veered 45 degrees to the right. The acft traveled off the right side of the rwy and came to rest on…Mar 26, 1988 · N3LD · Substantial damageNTSB NYC88LA105Accident · Minor injuriesLimited investigationFinal reportBell 206B · Agawam, MAThe pilot was on approach to landing from the south at about 2,000 yards from his pad. Speed was about 65 knots and was about 500 feet from the ground when the pilot said he had a flashback and doesn't remember what happened, the helicopter rolled over while…Mar 24, 1988 · N352BT · DestroyedNTSB BFO88LA030Accident · No injuriesLimited investigationFinal reportCessna 172 · New Cumberland, WVThe plt said that during the landing roll the brakes did not operate despite his continued application of pressure on the pedals. As the acft neared the rwy end he tried to swerve the acft left toward a runup pad. However, at the same time the r brake…Mar 24, 1988 · N1807Y · Substantial damageNTSB ANC88LA040Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Anchorage, AKAfter touchdown on a frozen lake, the aircraft rolled approximately 100 feet and at that point the pilot lost directional control and the aircraft nosed over on its back.Mar 23, 1988 · N3100Z · Substantial damageNTSB DEN88LA085Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Greeley, COThe CFI rated plt and his CFI rated passenger were practicing touch and go landings. The plt reported that the winds were light and variable. The plt reported that the tail wheel chattered during the last touchdown, and the aircraft swerved to the left. The…Mar 22, 1988 · N8929 · Substantial damageNTSB BFO88LA029Accident · No injuriesLimited investigationFinal reportCessna 150G · Ridgeway, VADuring touchdown the acft bounced and the student plt applied power to level-off and reflare. The left wing then rose and the right wing contacted the rwy. The acft bounced back and the left wing contacted the rwy. The nose gear collapsed and the acft came to…Mar 22, 1988 · N6360S · Substantial damageNTSB BFO88LA028Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Chatham, VAThe student plt was practicing touch and go landings when the accident occurred. He stated the acft was a little high and fast on final apch. On touchdown the acft veered left and traveled off the rwy. The left wing contacted a tree and the acft spun around…Mar 22, 1988 · N6587W · Substantial damageNTSB BFO88LA027Accident · No injuriesLimited investigationFinal reportCessna 150L · Fairmont, WVAccording to the student plt, the acft crabbed to the left just prior to touchdown. Upon touchdown, the acft veered left and traveled off the rwy into muddy grass. Despite the plt's use of brakes and right rudder the acft continued down an embankment where it…Mar 21, 1988 · N6763G · Substantial damageNTSB SEA88LA064Accident · Serious injuriesLimited investigationFinal reportMarlow Hilyard Executive · Elko, NVThe pilot made a landing on sloping terrain. The gyrocopter rolled to the left with the main rotor striking sage brush. The engine was twisted from its mounts rupturing a fuel line. A fire resulted consuming the gyrocopter. The pilot did not hold a pilot or…Mar 20, 1988 · N5045J · DestroyedNTSB NYC88LA110Accident · No injuriesLimited investigationFinal reportCessna 182RG · Princeton, NJDuring landing at Princeton, new jersey, the flight encountered turbulence in the last 500 feet before reaching the runway. The pilot initiated a go around and came in with 10 degree flaps. Aircraft touched down and rolled a few feet then lifted off again…Mar 20, 1988 · N738QK · Substantial damage