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 SEA89LA009Accident · Minor injuriesLimited investigationFinal reportTaylorcraft 15A · Skykomish, WAThe plt made an apch over tall trees to land on a 2050 ft strip. The acft touched down on wet turf with about 500 ft of rwy remaining. The plt was unable to stop the acft on the remaining rwy. Subsequently, it contd off the departure end & went into a large…Oct 9, 1988 · N6651N · Substantial damageNTSB MKC89LA003Accident · No injuriesLimited investigationFinal reportCessna 172 · West Memphis, ARThe pilot said he was unable to activate the runway lights on the designated frequencies during a night personal flight. He attempted to land without the aid of the runway lights, and touched down on the FAR end of the runway subsequently running off the end…Oct 9, 1988 · N734BK · Substantial damageNTSB DEN89FA010Accident · Serious injuriesField investigationFinal reportPiper PA-24-180 · Albuquerque, NMPlt-rated pax told plt, coronado arpt 'in sight'. Plt was suspicious because loran indicated arpt was 3 mi away but trusted former instrument student's judgment & landed at closed alameda arpt instead of coronado arpt. Coronado UNICOM had told plt 'multiple…Oct 9, 1988 · N7228P · DestroyedNTSB CHI89LA006Accident · No injuriesLimited investigationFinal reportBeech 55B · Quincy, ILThe pilot in command's failure to maintain control of the aircraft and to take appropriate action to correct the porpoise.Oct 9, 1988 · N8769R · Substantial damageNTSB ATL89LA011Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Hatteras, NCThe plt reported that he initially flared too high during the landing. He recovered and the acft subsequently touched down 'firmly' on the main gear. The acft then began to veer to the rt 'as if the rt brake was locked'. The plt attempted to abort the ldg &…Oct 9, 1988 · N17223 · Substantial damageNTSB LAX89LA012Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Concord, CAThe pilot stated that during the landing roll he lost directional control of the airplane and veered left of the runway centerline. The pilot stated that the left rudder was stuck in a fully deflected position and his attempt to add right rudder was…Oct 8, 1988 · N8162T · DestroyedNTSB DEN89LA011Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Delta, UTOn a x-country flt, the plt elected to make a refueling stop at Delta, UT. He transmitted on UNICOM freq & got no reply,but noted a light wind favoring rwy 30 & rwy 34. He elected to land on rwy 30. He said that on final apch, he looked fortraffic to rwy 34,…Oct 8, 1988 · N75666 · Substantial damageNTSB ATL89LA010Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Greensboro, NCThe plt had landed at southeast Greensboro earlier. He departed on rwy 35 and remained in closed traffic for landing. The td was made in the first 100 feet of the downsloped rwy at about 70 mph. The flaps were retracted and the plt reptd that a gust of wind…Oct 8, 1988 · N29550 · Substantial damageNTSB ATL89LA008Accident · Serious injuriesLimited investigationFinal reportNorth American T-6G · West Jefferson, NCDuring a landing attempt, the pilot lost directional control and veered off the right side of runway 27. The pilot reported applying opposite braking with negative results. The airplane examination failed to disclose any system problem.Oct 8, 1988 · N7704C · Substantial damageNTSB LAX89LA011Accident · Minor injuriesLimited investigationFinal reportCessna 195B · Porterville, CADuring a dual instructional flight, the pilot lost directional control of the airplane while landing. The airplane veered left. When the pilot corrected to the right, the left main landing gear collapsed. The airplane nosed over and came to rest on the right…Oct 7, 1988 · N2141C · Substantial damageNTSB ATL89LA009Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Lexington, NCDuring final approach to rwy 26 a crosswind shifted to a tailwind. The plt rprtd a full flap/carb heat touchdown was made despite 14 knots airspeed. Insufficient rwy remained and full throttle was applied for go-around. Flaps and carb heat were not…Oct 7, 1988 · N736EK · Substantial damageNTSB ATL89LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Savannah, GAWhile landing with a left x-wind, the acft veered to the left & went off the rwy. Subsequently, the nose gear collapsed in soft terrain. The plt thought tower personnel had told him the wind was from 030 deg at 9 KTS. A check of the transcript revealed that…Oct 7, 1988 · N7769N · Substantial damageNTSB SEA89LA008Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Cashmere, WAPlt landed short of hard surface, collapsing lndg gear.Oct 6, 1988 · N75107 · Substantial damageNTSB NYC89LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · New Castle, PAThe CFI and student plt were practicing touch and go landings. The CFI said the landing was long and the aircraft was not quite aligned with the rwy. By the time the aircraft was realigned and under control the CFI thought there was insufficient rwy to stop…Oct 6, 1988 · N2542D · DestroyedNTSB MIA89LA005Accident · Minor injuriesLimited investigationFinal reportRepublic RC-3 · Miami, FLThe pilot stated that he was having problems with the elevator trim and elected to land the amphibious acft in the bay. He acknowledged and witnesses observed him lower the landing gear prior to attempting to land on the water. The aircraft flipped inverted…Oct 6, 1988 · N3263G · Substantial damageNTSB LAX89LA007Accident · No injuriesLimited investigationFinal reportHughes 269C · Fontana, CAThe pilot was demonstrating a run-on landing for his passenger when the accident occurred. The pilot reported that he allowed the tail of the helicopter to get too low and it collided with the terrain. There were no mechanical difficulties reported prior to…Oct 4, 1988 · N1090Z · Substantial damageNTSB DEN89LA006Accident · No injuriesLimited investigationFinal reportPilgrim Steen Skybolt · Rawlins, WYThe pvt plt in command and his atp-rated pax were ferrying the newly-purchased acft from FL to WA. They departed scottsbluff, NE, and were enroute to rock springs, WY, when the pax advised the plt insufficient VFR fuel reserves precluded continuing to rks.…Oct 4, 1988 · N21SP · Substantial damageNTSB DEN89LA005Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Albuquerque, NMThe commercial Balloon plt and one pax were participating in a Balloon fiesta. The acft took off from Albuquerque, on a local flight in light winds. At altitude, the Balloon encountered easterly winds that carried the Balloon southwest of Albuquerque, where a…Oct 4, 1988 · N3678E · Substantial damageNTSB DEN89LA003Accident · Minor injuriesLimited investigationFinal reportPiccard AX-6 · Albuquerque, NMThe commercial plt was competing in a balloon fiesta, with 2 pax. The plt selected a landing field with power lines and a street running east and west across it. The balloon was drifting south and the plt selected the south end of the field for landing,…Oct 3, 1988 · N99US · Substantial damageNTSB ANC89LA004Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Eureka Lodge, AKThe pilot was attempting to land at dusk on a snow covered, unlighted private airstrip. He stated that he was attempting to land as close to the landing threshold as possible to avoid a large bump in the middle of the runway. He misjudged his approach and…Oct 3, 1988 · N98109 · Substantial damageNTSB FTW89LA002Accident · No injuriesLimited investigationFinal reportCessna 172 · Houston, TXOct 2, 1988 · N89745 · Substantial damageNTSB DEN89LA002Accident · Minor injuriesLimited investigationFinal reportCessna TP206B · Durango, COThe private plt was practicing landings in his acft. During takeoff ground run, while making a touch and go landing, the plt reported experiencing vibrations from both main gear and his acft departed the 5,000 x 50 ft rwy to the left. The plane traveled 100…Oct 1, 1988 · N4732F · Substantial damageNTSB BFO88LA087Accident · No injuriesLimited investigationFinal reportBeech B23 · Roanoke, VAThe plt said the acft bounced twice during the landing. The apch speed was 75 to 80 KTS. The left main gear collapsed on the second bounce. The nose gear collapsed on the final touchdown. The acft slid off the left side of he rwy. The plt reported no…Oct 1, 1988 · N9110T · Substantial damageNTSB SEA88LA192Accident · No injuriesLimited investigationFinal reportCessna 207 · Center Island, WAThe plt was landing upslope on a one-way 1700 ft rwy in wind that was variable & changing from calm to gusts from the north. The plt rprtd a northerly gust cond occurred as he was landing. Subsequently, the acft floated beyond the desired touchdown point &…Sep 30, 1988 · N1651U · Substantial damageNTSB ATL88LA257Accident · No injuriesLimited investigationFinal reportCessna 152 · Conway, SCThe student pilot was conducting his first SOL0 flight, when he lost directional control and collided with three parked airplanes. The student said that his right foot slipped off the rudder pedal; attempts to recover failed. The pilot did not report any…Sep 30, 1988 · N95156 · Substantial damageNTSB SEA88LA193Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Renton, WAThe student pilot was returning from a long solo cross country. The runway was undergoing construction. 2,300 feet remained for landing. Landing needed to be accomplished over barriers. The student pilot had approach flaps set. The tower asked the pilot to…Sep 29, 1988 · N5896W · Substantial damageNTSB SEA88LA190Accident · No injuriesLimited investigationFinal reportCessna 185F · Hillsboro, ORDuring landing roll the aircraft veered to the right and departed the runway where a groundloop occurred. The wind was calm. No explanation for the loss of control was given by the plt.Sep 29, 1988 · N4758E · Substantial damageNTSB NYC88LA245Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Carlton Center, NYPlt stated he was landing to the west and touched down about half way down a 2,000 ft grass strip. The plt also said the grass was wet and the wheel braking was ineffective. The plt elected to keep the airplane on the ground due to obstacles at the end of the…Sep 29, 1988 · N43610 · Substantial damageNTSB MKC88LA180Accident · No injuriesLimited investigationFinal reportEllis Quickie Q2 · Winfield, KSWitnesses said that after takeoff, the plt made one low level pass, then returned for landing. The plt rprtd that he intended to make a go-around, but that he may have pushed the elevator control forward instead of the throttle. Subsequently, the acft was…Sep 29, 1988 · N39774 · Substantial damageNTSB MIA88LA275Accident · Minor injuriesLimited investigationFinal reportCessna 182N · Belleview, FLAfter clearing transmission wires at the apch end of the rwy, the plt stated the acft was low & slow. Prior to touchdown she stated the acft stalled, then landed hard. The nose wheel collapsed during the touchdown.Sep 29, 1988 · N9051G · Substantial damageNTSB ANC88LA148Accident · No injuriesLimited investigationFinal reportBell 212 · Deadhorse, AKThe pilot encountered a whiteout condition and elected to land on a frozen lake approximately 3 miles southwest of the airport. After touchdown on the ice, the helicopter broke the ice and rolled over on its back. The helicopter was destroyed by ground fire.Sep 29, 1988 · N397EH · DestroyedNTSB MKC88LA181Accident · No injuriesLimited investigationFinal reportBeech 77 · Friendship, ARThe CFI rprtd he was demonstrating an emergency landing to a pvt rated plt & confusion (about who was flying the acft) resulted in a commitment to land. The landing was made on a gravel road. During the roll-out, the acft veered into a ditch & was damaged.Sep 28, 1988 · N67572 · Substantial damageNTSB NYC88LA244Accident · No injuriesLimited investigationFinal reportCessna 177 · Machias, METhe plt was practicing night takeoffs and landings. He stated that he had successfully accomplished two full stop landings. After the third landing, he applied full power to execute a go-around. The pilot said the airplane pulled to the left so he reduced the…Sep 27, 1988 · N2839X · Substantial damageNTSB MKC88LA179Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Bertrand, NEThe plt rprtd that while practicing takeoffs & ldgs, he believed he had excessive ground speed & elected to go around. He said he waited to long to go around, so he decided to fly under power lines, located at the dep end of the strip. Shortly after lift-off,…Sep 26, 1988 · N3390M · Substantial damageNTSB FTW88DPA10Accident · No injuriesFinal reportBell 206L-1 · Fort Worth, TXThe rated helicopter pilot was undergoing recurrent training with an instructor at a training field. During a practice autorotation to a landing, the helicopter went into a high sink rate with a low main rotor RPM. The helicopter touched down hard in a tail…Sep 25, 1988 · N1069Q · Substantial damageNTSB CHI88LA245Accident · No injuriesLimited investigationFinal reportCessna 150F · Baraboo, WIWhile landing on a sod strip with an 11 knot quartering tailwind, the aircraft drifted to the left of the runway and encountered uneven terrain. The pilot reported that he failed to maintain directional control and was unable to avoid a ditch with standing…Sep 25, 1988 · N381VU · Substantial damageNTSB CHI88FA244Accident · 1 fatalField investigationFinal reportPiper PA-28 · Hutchinson, MNFailure of the student rated pilot to use proper control inputs and procedures to regain and maintain control of the airplane while executing a go-around from a bounced landing. The pilots lack of total experience is a contributing factor in the cause.Sep 25, 1988 · N6151W · DestroyedNTSB CHI88LA246Accident · No injuriesLimited investigationFinal reportCessna 150G · Butler, INDuring a solo flight, the student pilot attempted a landing on a neighbor's cow pasture. The student stated that he misjudged the approach to landing and landed long on the field. He was unable to adequately handle the aircraft and failed to get it stopped…Sep 24, 1988 · N8570J · Substantial damageNTSB SEA88LA187Accident · No injuriesLimited investigationFinal reportCessna 210L · Juneau, AKThe plt stated that on landing on the airstrip, which also serves as a roadway, he encountered a depression in the surface. The acft porpoised and departed the left side of the prepared surface. The plt added power and regained the prepared surface. He then…Sep 23, 1988 · N249CC · Substantial damageNTSB SEA88LA185Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Coeur D'Alene, IDWhen pax became ill, plt elected to land in a pasture. Gear contacted dirt mound hidden by tall grass, separating gear.Sep 23, 1988 · N3647N · Substantial damageNTSB CHI88LA243Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Benson, MNWitnesses reported that the aircraft bounced twice on the runway before the right wing tip struck the ground on the right side of the runway. The aircraft 'cartwheeled' and came to a rest on it's left side.Sep 23, 1988 · N3815Q · DestroyedNTSB CHI88LA241Accident · No injuriesLimited investigationFinal reportCessna 550 · Fremont, MIThe airplane ran off the end of the runway and struck an embankment after landing downwind from a VOR approach during heavy rain. Both pilots reported poor braking action and ineffectiveness of reverse thrust application after touchdown and during the landing…Sep 22, 1988 · N29TC · Substantial damageNTSB ANC88LA146Accident · No injuriesLimited investigationFinal reportCessna 207A · New Koliganek, AKThe pilot reported that he landed long on a rough 900' gravel strip. He was unable to stop the airplane before it went off the end of the runway and into the adjoining tundra.Sep 22, 1988 · N1763U · Substantial damageNTSB ANC88LA145Accident · No injuriesLimited investigationFinal reportCessna 185F · Chip River, AKThe air taxi pilot was attempting to land on the snow covered tundra near his passenger's fish camp. The tundra had not yet frozen sufficiently to support the weight of the airplane, and the main landing gear quickly became mired in the soft soil, causing the…Sep 21, 1988 · N61500 · Substantial damageNTSB FTW88DPA08Accident · No injuriesFinal reportNorth American TB-25N · Wichita Falls, TXDuring a period of light rain at dusk, the B-25 plt landed on a 4250 ft rwy. While landing, the acft touched down long & fast. Subsequently, it went off the departure end of the rwy & was damaged.Sep 19, 1988 · N9079Z · Substantial damageNTSB NYC88LA239Accident · No injuriesLimited investigationFinal reportCessna 152 · Mt.Holly, NJSeveral landings and takeoffs were performed. On the last landing, the aircraft touched down first on the right main gear and then the left main gear. The pilot stated that the aircraft seemed to slide or skid to the right and continued onto the grassy area…Sep 18, 1988 · N714YY · Substantial damageNTSB FTW88DPA09Accident · Minor injuriesFinal reportAeronca 11AC · Athens, TXAfter setting the aircraft down in the grass to the left of the runway, the pilot stated that a 40 mph wind gust picked the right wing up and set the aircraft on its nose. He attempted to keep the fuselage from tipping all the way over after disembarking;…Sep 18, 1988 · N86311 · Substantial damageNTSB ANC88LA144Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Porcupine Butte, AKThe plt rprtd he landed harder than he intended from about 3 to 5 ft above the ground. The right main gear collapsed & the acft veered to the right. Subsequently, the left main gear collapsed & the acft came to rest off the airstrip.Sep 17, 1988 · N56304 · Substantial damageNTSB LAX88LA318Accident · No injuriesLimited investigationFinal reportCessna T310R · La Verne, CAThe pilot stated that he was troubleshooting a problem with the airplane's fuel flow system. During the preflight run-up, he noticed that the fuel flow gauge for the right engine was reading too high. He took off to see if he could make an inflight…Sep 16, 1988 · N5126J · Substantial damageNTSB DEN88LA206Accident · No injuriesLimited investigationFinal reportCessna 172 · Greeley, COThe student plt reported that he was making touch and go landings. During landing roll the crosswind lifted the right wing and caused the acft to drift to the left. The student plt said he attempted to correct the drift, to no avail. The left main wheel…Sep 16, 1988 · N97890 · Substantial damage