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 BFO88LA083Accident · No injuriesLimited investigationFinal reportCessna 310R · Washington, DCDuring the landing roll the left main landing gear collapsed. The acft continued to roll and came to a stop on taxiway 'k'. Inspection revealed that the push-pull rod assembly, p/n 0840125-15, failed allowing the gear to collapse. The purpose of the rod is to…Sep 15, 1988 · N87297 · Substantial damageNTSB ATL88LA247Accident · No injuriesLimited investigationFinal reportPiper PA-60-602P · Hopkinsville, KYThe airplane overran rwy 26 during ldg, following an sdf appch. The plt reported that he broke out of the wx about 1 mile from the rwy, with 2 to 3 miles visibility. He subsequently landed 'long' on the wet rwy with a tailwind, and found that braking was not…Sep 14, 1988 · N64718 · Substantial damageNTSB NYC88DNA02Accident · Serious injuriesFinal reportDillinger Long E-Z · Lawrence, MAThe plt depd provincetown on a rtrn flt to his home arpt at aprx 0230 EDT & arrived at his destn about 1 hr later. He rprtd he was unable to activate the plt-ctld rwy lights. He checked the lighted wind sock & decided the night was bright & clear enough to…Sep 12, 1988 · N84WD · Substantial damageNTSB DEN88MA203Accident · Minor injuriesMajor investigationFinal reportMcdonnell Douglas DC-10-10 · Denver, COAs the capt was deploying reversers drg lndg, #2 & #3 reversers unlocked & deployed (green lgt cond), but #1 reverser was binding & only moved to the unlocked psn (amber lgt cond). Capt was not warned of this cond, though 2nd officer should have monitored…Sep 12, 1988 · N1830U · Substantial damageNTSB ANC88LA137Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Ruth Lake, AKThe air taxi pilot was attempting to land his float-equipped airplane on a remote mountain lake in gusty wind conditions. He stated that he touched down with a tailwind component of approximately 5 knots, but that the tailwind increased rapidly during a gust,…Sep 12, 1988 · N67207 · Substantial damageNTSB ANC88LA133Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Fairbanks, AKThe private pilot stated that he was attempting to land on a gravel bar when the airplane encountered a soft spot and nosed over. He said that a contributing factor in the accident was that he had applied his brakes too strongly early in the landing roll, and…Sep 12, 1988 · N3148M · Substantial damageNTSB ANC88LA134Accident · Serious injuriesLimited investigationFinal reportCessna 188B · Skwentna, AKThe airline transport rated pilot was flying a load of gasoline in a crop duster type airplane to a residence in rural Alaska. The landing site was a river sand bar located near the residence. The pilot stated, and witnesses concur, that the airplane's main…Sep 11, 1988 · N9037R · Substantial damageNTSB LAX88LA315Accident · No injuriesLimited investigationFinal reportBillings/Humbyrd Thorp T-18 · Corona, CAJust prior to touchdown a thorp T-18 and a Piper collided in flight. The Piper struck the thorp from above at aprx 10 ft AGL over the threshold. The thorp landed without further incident. The Piper completed a normal landing until the propeller contacted the…Sep 10, 1988 · N45BH · 2 aircraft · Minor damageNTSB SEA88LA175Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Seattle, WAPlt landed with 80 deg right cross wind of 8 KTS, groundlooped to right. The plt said that ATIS info gave the wind as 220 degrees at 8 KTS; however his EST from windsock observation included gusts of 15 KTS. The observing station reported no gusts on the date…Sep 9, 1988 · N2526A · Substantial damageNTSB MKC88LA169Accident · No injuriesLimited investigationFinal reportCessna 195 · Keokuk, IAThe new owner of the acft asked the former owner to ride with him in the right seat while doing some touch and go landings. After the first circuit the former owner said he felt the pilot needed additional training before attempting to fly the acft as PIC.…Sep 8, 1988 · N3040B · Substantial damageNTSB CHI88LA230Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Cambridge, OHThe pilot was on a solo flight for the purpose of practicing takeoffs and landings. The aircraft departed the right side of the runway and struck a culvert. The flight was the pilot's second supervised solo.Sep 7, 1988 · N7118F · Substantial damageNTSB SEA88LA173Accident · No injuriesLimited investigationFinal reportMaule M5-235C · Priest River, IDOn approach for lndg on rwy 27, the plt noted that the windsock was indicating strong, shifting winds. The acft settled in the flare, despite added power, resulting in hard landing.Sep 6, 1988 · N56312 · Substantial damageNTSB MKC88LA168Accident · No injuriesLimited investigationFinal reportCessna 152 · Burlington, IAArriving at the destination apt, on a solo cross country flt, the plt said UNICOM advised a landing on rwy 18. The local fss reported the winds to be out of the northwest favoring runway 36. The plt elected to land on rnwy 18 based on the UNICOM advisory, and…Sep 6, 1988 · N5458P · Substantial damageNTSB ATL88LA249Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Saluda, SCThe instructor pilot reported that they were conducting autorotation training. During an autorotation the crew delayed initiating the power recovery. The helicopters struck the ground causing substantial damage. The pilots did not report experiencing a system…Sep 5, 1988 · N8823F · Substantial damageNTSB ATL88LA246Accident · No injuriesLimited investigationFinal reportCessna 182K · Hendersonville, NCThe pilot was nearing touchdown on a normal landing when the left side of the windscreen was struck by a bird. The startled pilot was distracted long enough for the aircraft to bounce on the runway. Elevator control was lost after the first bounce. A nose low…Sep 5, 1988 · N2636R · Substantial damageNTSB ANC88LA125Accident · No injuriesLimited investigationFinal reportCessna 180K · Chickaloonflats, AKOn touchdown off shore on the mud flats, the pilot lost complete control of the airplane. The airplane then nosed over on its back.Sep 5, 1988 · N2989K · Substantial damageNTSB MIA88LA271Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Lake Wales, FLThe plt stated he approached the 2,450 ft grass airstrip from the NE & circled north of it to observe the windsock. The wind appeared to be from the east. The pilot entered the pattern to land on rwy 36. While flaring to land the acft floated down the rwy &…Sep 4, 1988 · N722TC · Substantial damageNTSB DEN88LA200Accident · Minor injuriesLimited investigationFinal reportThunder and Colt AX8-90 · Las Cruces, NMThe commercial balloon plt was participating in a balloon rally. During landing, the plt noticed the balloon was drifting toward power lines. He elected to open the deflation valve at 30 ft AGL, to attempt to land short of the lines. The balloon touched down…Sep 4, 1988 · N90EH · Substantial damageNTSB LAX88FA306Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Temecula, CAFailure of the pilot to properly initiate a go-around during an aborted landing. The loss of directional control during the landing, failure to return to the runway for the aborted takeoff, and not establishing the proper rate of climb due to high density…Sep 2, 1988 · N4328Y · DestroyedNTSB FTW88LA159Accident · No injuriesLimited investigationFinal reportCessna 180H · Welsh, LAThe pilot was landing the tailwheel type airplane on runway 6 while the winds were from 270 degrees at 15 knots, gusting to 25 knots. After touchdown, it ballooned several feet, touched on the left wheel, then the left wing tip and flipped forward to the…Sep 1, 1988 · N9730G · Substantial damageNTSB FTW88DRG12Accident · No injuriesFinal reportCessna 182R · Spicewood, TXThe plt said the windsock indicated the wind was from the northeast; however, witnesses said the winds were from the south & the acft landed downwind. The plt said he went around after the 1st apch, & on the next pattern, he made a lowerfinal apch. He said…Sep 1, 1988 · N3163E · DestroyedNTSB CHI88LA228Accident · Minor injuriesLimited investigationFinal reportLake LA-4-200 · Fox Lake, ILThe plt had just completed a course at the Lake acft factory school, but had not yet obtained a seaplane rating. After he flew home, he landed on local lakes. He reported that drg a landing on calm water, he expected to hear a 'slush sound' as the hull…Sep 1, 1988 · N8012A · DestroyedNTSB LAX88LA301Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Goodyear, AZThe student pilot was on her second supervised solo flight. She had completed one touch and go landing and was attempting a second when the accident occurred. The pilot failed to flare the airplane at the proper time and the airplane collided with the terrain…Aug 29, 1988 · N46972 · Substantial damageNTSB DEN88LA192Accident · No injuriesLimited investigationFinal reportCessna 206 · Saint George, UTDrg the landing roll, the nose gear collapsed, then the acft veered off the rwy, enctrd soft dirt/gravel terrain & nosed over. A post-acdnt inspn revealed that two attaching bolts on the left side of the nose gear yoke had failed & that the TW0 bolts on the…Aug 29, 1988 · N5028U · Substantial damageNTSB ANC88LA118Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe plt was practicing touch-&-go landings. On the first landing, the acft bounced & a successful go-around was made. During the second landing, the plt lost directional control of the acft & it went off the left side of the rwy & was damaged.Aug 29, 1988 · N8266A · Substantial damageNTSB CHI88LA224Accident · Serious injuriesLimited investigationFinal reportCessna 182RG · Dodgeville, WIWhile attempting to land on a runway with wind gusts and a quartering tailwind, the pilot failed to adequately judge and compensate for the wind conditions. The aircraft landed long, and the pilot was unable to bring the aircraft to a stop before the end of…Aug 28, 1988 · N728JS · Substantial damageNTSB BFO88LA078Accident · No injuriesLimited investigationFinal reportCessna 152 · Easton, MDThe student pilot reported that he allowed the airspeed to deteriorate on final apch. The acft touched down nosewheel first and began to porpoise on the runway. The acft porpoised 3 or 4 times before the propeller and right wing contacted the runway.Aug 28, 1988 · N49572 · Substantial damageNTSB BFO88LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Oakland, MDAccording to the pilot the landing approach for runway 22 was made over power lines. He stated that during the approach the stall warning horn activated and he increased power to maintain 60 mph with 20 degs of flaps. Once estimating that his intended point…Aug 28, 1988 · N4156F · Substantial damageNTSB ANC88LA119Accident · No injuriesLimited investigationFinal reportCessna 185F · Joseph Village, AKThe pilot-in-command stated the airplane struck a depression in the runway upon landing at Joseph, Alaska. Examination of the left main gear showed that a bracket, part number 0713495-61 failed due to overload, and allowed the landing gear to separate from…Aug 28, 1988 · N4838C · Substantial damageNTSB SEA88LA164Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Nehalem, ORAfter executing one go-around due to overshoot, plt landed long on second approach. Plt attempted to brake to stop, then rejected landing, applied power and became airborne prematurely. Loss of control and collision with terrain followed.Aug 27, 1988 · N5813X · Substantial damageNTSB NYC88LA230Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Manville, NJAfter completing six landings with an instructor the student plt was released by the instructor for his first solo flt to be conducted as a series of closed pattern touch-and-go landings. On his first solo landing the student plt landed nose wheel first with…Aug 27, 1988 · N2445N · DestroyedNTSB FTW88LA154Accident · No injuriesLimited investigationFinal reportAlon A2 · Guthrie, OKThe private pilot was trying to sell his airplane and allowed the student pilot to fly it from the left seat. The student pilot landed on the runway but lost control, departed the side of the runway, then hit a VASI light. The airplane stopped when it hit a…Aug 27, 1988 · N6588Q · Substantial damageNTSB DEN88LA201Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Fort Morgan, COThe plt reported that at the time of takeoff, the winds were 'light to moderate from 015 deg at 5 KTS or less.' Shortly after takeoff, the winds increased to 10-15 KTS and the plt decided to land on 'grassy, relatively smooth terrain.' The plt said he…Aug 27, 1988 · N779TV · No damageNTSB BFO88LA079Accident · No injuriesLimited investigationFinal reportCessna 180 · Harding, WVThe pilot departed morgantown, WV, en route to a private airstrip, durrett air ranch, near Harding, WV to attend a Cessna 180 fly-in. He stated he circled the airstrip to determine the wind and rwy conditions. He also called UNICOM for active rwy info but did…Aug 27, 1988 · N2922A · Substantial damageNTSB MKC88LA163Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Freeburg, MOWhile attempting to land on a farm pasture that the plt had previously walked over to check, the aircraft nose wheel collapsed, followed by a nose over. The aircraft landed nose low with no flaps and dug into the grass runway.Aug 26, 1988 · N3171Z · Substantial damageNTSB DEN88LA194Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Lakeside, MTThe plt and his pax departed bzn at 1500 MDT and flew to Hughes bay on flathead Lake, near Lakeside, MT, arriving at aprx 1700. The plt said he noticed a diminishing wave pattern from the southwest and a strong gust surface pattern from the east. There were…Aug 26, 1988 · N1299L · Substantial damageNTSB FTW88DPA06Accident · No injuriesFinal reportCessna 150K · Whitney, TXThe student pilot decided to make a touch and go landing before flying to another airport. The airplane touched down more than 1000 feet down the 2000 foot runway, went off the end and 300 feet beyond the end before hitting a dirt bank and nosing over to the…Aug 25, 1988 · N2550Q · Substantial damageNTSB DEN88LA189Accident · Minor injuriesLimited investigationFinal reportCessna 195 · Rawlins, WYAug 25, 1988 · N3455V · Substantial damageNTSB ATL88LA243Accident · No injuriesLimited investigationFinal reportSchempp-Hirth 2 · Whitwell, TNThe pilot was completing a 130 mile cross country flight. Just prior to touchdown, the left wing collided with a water sprinkler pipe along the edge of the runway. The pilot lost directional control. The grass was taller along the runway edge. The pilot did…Aug 25, 1988 · N795 · Substantial damageNTSB ATL88LA237Accident · No injuriesLimited investigationFinal reportMaule MX-7-180 · Eufaula, ALThe plt reported that he landed on a grass strip adjacent to the paved rwy, to 'save the (airplane) tires' from excessive wear. He stated that the airplane groundlooped during the rollout when it encountered a hole in the turf. A mechanic who examined the…Aug 24, 1988 · N56606 · Substantial damageNTSB SEA88LA162Accident · No injuriesLimited investigationFinal reportCessna 152 · Seattle, WAStudent pilot executed improper flare resulting in hard landing. This was a solo flt. The student said he was high on final but thought it was okay. When he flared to land the acft dropped to the rwy and bounced. The student said he added power and raised the…Aug 23, 1988 · N6419M · Substantial damageNTSB NYC88LA227Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-1-26E · Elmira, NYThe plt reported to the local police that he was having trouble getting lift and was attempting an off airport landing when the acft stalled at low alt and crashed. The pilot did not file an accident report.Aug 21, 1988 · N3613B · Substantial damageNTSB NYC88LA226Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Pittstown, NJThe CFI was demonstrating a departure autorotation to a prospective student. A high rate of descent with low airspeed and low rotor RPM developed and the CFI attempted a power recovery with no results. The acft touched down hard, the skids collapsed and the…Aug 21, 1988 · N7028V · Substantial damageNTSB NYC88LA225Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Readington, NJWhile attempting a go-around from a rejected landing in x-wind conditions the plt who had no landings in the last 90 days failed to initiate the go-around with sufficient time/distance to clear trees off the end of the rnwy. The acft struck the trees and was…Aug 21, 1988 · N9072P · DestroyedNTSB NYC88LA223Accident · No injuriesLimited investigationFinal reportCessna 172P · Freeport, PAThe plt said that he had landed on the 2268 ft long, sod strip on several previous occasions. He said there was a right crosswind at about 6 KTS. The acft was too high and go-arounds were made following the first two approaches. On the third approach, the…Aug 21, 1988 · N172RQ · Substantial damageNTSB LAX88LA292Accident · Serious injuriesLimited investigationFinal reportSiai-Marchetti S.205/22R · Bullhead City, AZAt the end of a cross country flight, the pilot had to abort the landing the first time due to heavy rain showers and turbulence. The pilot returned for landing and during the landing roll on the wet runway, the pilot lost control of the airplane. The…Aug 21, 1988 · N955W · Substantial damageNTSB CHI88LA216Accident · No injuriesLimited investigationFinal reportCessna 172M · Kelley'S Island, OHShortly after crossing the runway threshold on final approach, the pilot experienced a wind shift and elected to attempt a go-around. The pilot discontinued the attempted go-around when he judged that he would be unable to clear trees located at the departure…Aug 21, 1988 · N62920 · Substantial damageNTSB BFO88LA074Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Gaithersburg, MDThe pilot reported that the local winds were varying from 340 degrees to 360 degrees at 12 knots gusting to 20 knots. The pilot stated that he lost directional control due to gusty winds while on landing roll. The aircraft contacted a VASI light and then a…Aug 21, 1988 · N86346 · Substantial damageNTSB SEA88LA159Accident · No injuriesLimited investigationFinal reportCessna 150D · Athol, IDAcft had been modified to conventional lndg gear. On landing roll, variable and gusty surface winds were encountered. Plt lost control of acft, which nosed over.Aug 20, 1988 · N4393U · Substantial damageNTSB SEA88LA157Accident · No injuriesLimited investigationFinal reportCessna 172N · Tyge Valley, ORThe pilot reported that late in the apch, the acft developed a high sink rate. However, he used elevator only to correct the sink rate. The aircraft impacted the runway and bounced. On the third bounce, the nose gear failed and the aircraft nosed over. The…Aug 20, 1988 · N737RB · Substantial damage