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 DEN88LA018Accident · No injuriesLimited investigationFinal reportCessna 210 · Greeley, COThe CFI was instructing the private rated plt in simulated forced landings. The plt reported that after a full stop landing, the aircraft would not turn properly to the right, and she suspected brake system failure. The CFI took control and attempted to taxi…Oct 24, 1987 · N6551X · Substantial damageNTSB ATL88LA026Accident · No injuriesLimited investigationFinal reportPitts S2A · Ramseur, NCThe pilot lost directional control while making a normal landing. The pilot did not report a mechanical problem. The ground loop cause substantial damage to the aircraft's undercarriage.Oct 24, 1987 · N44LH · Substantial damageNTSB ATL88LA022Accident · Serious injuriesLimited investigationFinal reportCessna 150C · Wartburg, TNThe aircraft touched down hard on the 1300 foot grass strip and began to porpoise. The pilot attempted to go-around but was unable to gain sufficient altitude to avoid striking a power line. The plt did not file an acc report.Oct 23, 1987 · N3585J · Substantial damageNTSB MIA88LA017Accident · No injuriesLimited investigationFinal reportMaule M-5-180C · Madison, MSThe plt stated that during the landing roll the acft began to veer off towards the left side of the rwy. Full rt rudder would not correct this. The acft then left the rwy, ground looped, & as a result the rt main gear collapsed & the tailwheel separated from…Oct 22, 1987 · N56583 · Substantial damageNTSB FTW88LA010Accident · No injuriesLimited investigationFinal reportCessna 150L · Lancaster, TXWhile rtrng fm a x-country, the student bcm disoriented & reqd assistance. Redbird twr ctlr adzd dallas-ft worth TRACON that the plt was lost & needed a beacon identification. A few min later, the acft's location was determined & the ctlr at redbird relayed a…Oct 22, 1987 · N17176 · Substantial damageNTSB DEN88LA013Accident · No injuriesLimited investigationFinal reportBeech C45G · Salt Lake City, UTWhile conducting the last landing at the completion of a revenue freight hauling flt the acft departed the side of the runway separating the left main landing gear and damaging the left wing and number one engine. The plt stated that the landing lights would…Oct 22, 1987 · N781A · Substantial damageNTSB MKC88LA014Accident · Serious injuriesLimited investigationFinal reportNational Balloon 752 · Ankeny, IADuring a promotional balloon flt, the plt stated that on an approach to lnd the basket drifted into a large hay bale. The basket tipped and the plts ankle was broken when caught between the basket and a propane tank.Oct 21, 1987 · N72711 · No damageNTSB ATL88LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Conway, SCThe student plt was performing a normal landing with a crosswind from the left. The acft was drifting to the right at touchdown and was partially off the rwy to the right. The plt attempted to use the brakes and keep the acft's ground track parallel with the…Oct 21, 1987 · N94126 · Substantial damageNTSB LAX88LA019Accident · No injuriesLimited investigationFinal reportCessna 195A · Modesto, CAThe pilot stated that during the end of the landing roll on runway 28L, the aircraft started turning to the right and he could not correct it and the aircraft ground looped. There were no mechanical problems reported prior to the accident. The pilot reported…Oct 19, 1987 · N4372N · Substantial damageNTSB NYC88LA009Accident · No injuriesLimited investigationFinal reportCessna 140 · New Milford, CTThe flight en route was uneventful; however, during the landing at New Milford, CT, the aircraft's propeller struck the surface of the runway & the plane nosed over. The plt stated that he applied the brakes too harshly.Oct 18, 1987 · N2841N · Substantial damageNTSB MKC88LA009Accident · No injuriesLimited investigationFinal reportGrumman American AA5B · Branson, MODuring a lndg on a 3600 ft strip, the acft touched down long. The acft ran off the departure end of the rwy and collided with the terrain causing substantial damage to the acft. Witnesses said they could not find any skid marks along the path taken by the…Oct 18, 1987 · N499GT · Substantial damageNTSB SEA88LA008Accident · No injuriesLimited investigationFinal reportCessna T210N · Walla Walla, WAThe pilot landed short and the aircraft's main landing gear struck the edge of a plateau at the approach end of the private strip. The aircraft swerved off the grass runway, the nose gear collapsed, and the aircraft nosed over.Oct 17, 1987 · N7231N · Substantial damageNTSB MKC88LA020Accident · No injuriesLimited investigationFinal reportCessna 177 · Warrensburg, MOPIC stated she had misjudged ldg, resulting in an uncontrolled porpoise, damaging nose wheel and stabilator. She aborted ldg attempt and returned to departure airport. Considerable difficulty controlling the acft was encountered, but with outside radio…Oct 17, 1987 · N2969X · Substantial damageNTSB ATL88LA014Accident · No injuriesLimited investigationFinal reportCessna 152 · Murfreesboro, NCThe student plt became lost on the return leg of his 1st solo cross-country flt. He elected to make a precautionary ldg in a plowed field after observing the acft fuel gauges indicating near empty. The acft nosewheel sank into soft dirt during rollout and the…Oct 17, 1987 · N757AD · Substantial damageNTSB ATL88LA013Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Hampton, GAThe CFI rptd that the student flared the airplane about 50 ft abv the rwy and stalled it; the airplane dropped to the rwy and bounced. He assumed control of the airplane from the student and attempted to prevent a crosswind from blowing the airplane to the…Oct 17, 1987 · N91461 · Substantial damageNTSB ANC88LA008Accident · No injuriesLimited investigationFinal reportCessna 207A · Sheldon Point, AKThe air taxi pilot attempted to land on a short narrow gravel air strip in crosswind conditions. He ran off the end of the runway and the airplane was substantially damaged. The wind was in excess of recommendations for the type acft. A witness reported that…Oct 17, 1987 · N1472M · Substantial damageNTSB SEA88LA007Accident · Minor injuriesLimited investigationFinal reportCessna 180K · Petersburg, AKThe plt of the floatplane rprtd that after the acft touched down drg a water lndg & was on the 'roll-out,' she pushed the carb heat in & leaned forward to raise the flaps. At about that time, the floatplane bgn to swerve. She attempted to regain control;…Oct 16, 1987 · N63071 · DestroyedNTSB BFO88DHD02Accident · No injuriesFinal reportBoeing A75N1 · Milton, DEThe pilot's improper brake application during a 'wheel' landing, which resulted in the aircraft nosing over. The slight downslope of the airstrip, a quartering tailwind, inadequate supervision on the part of the check pilot, and the pilot's lack of…Oct 16, 1987 · N53488 · Substantial damageNTSB ANC88LA009Accident · Minor injuriesLimited investigationFinal reportCessna A150K · Whittier, AKThe PIC got lost while flying above an overcast. When he finally found an opening and descended below the clouds he was low on fuel. He located some buildings on a narrow beach and attempted to land. He overshot the beach and struck stacks of building…Oct 16, 1987 · N8477M · Substantial damageNTSB CHI88FA005Accident · No injuriesField investigationFinal reportCessna TU-206G · Lansing, MIImmediately after takeoff the plt noted strong pressure on the right rudder. He trimmed out the rudder pressure and continued to fly in the local area. Approach flare and touchdown were normal. When the nose wheel contacted the runway the airplane veered…Oct 15, 1987 · N9359Z · Substantial damageNTSB ATL88LA019Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Lexington, KYDuring a dual instructional flight the student leveled the acft abv the rwy during the landing flare. The CFI told the FAA inspector that he was verbally coaching the student and did not assume the flt controls. The acft landed hard and the student applied…Oct 14, 1987 · N4639J · Substantial damageNTSB ATL88LA011Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbia, SCThe student pilot was flying solo for the first time. Two landings had been completed successfully. The pilot misjudged the final approach and touched down short of the runway. The aircraft landed hard causing the nose gear to collapse.Oct 14, 1987 · N5117B · Substantial damageNTSB DEN88LA009Accident · No injuriesLimited investigationFinal reportCessna A185F · Glasgow, MTThe plt reported that he was landing on rwy 12 with the winds, as reported by UNICOM, 100 deg at 10 KTS. He said that shortly after touchdown the acft was hit by a strong gust from the rt. The rt wing lifted, the lt wing hit the ground, and the acft nosed…Oct 12, 1987 · N2525S · Substantial damageNTSB FTW88DQG01Accident · No injuriesFinal reportBoeing A75N1 · Fort Stockton, TXThe pilot stated that during the flare for a full stall landing in the tail wheel equipped aircraft, a whirlwind was encountered. He said he applied full power & full left aileron & rudder, but could not recover. Subsequently, the aircraft struck an…Oct 11, 1987 · N54279 · Substantial damageNTSB DEN88LA007Accident · Serious injuriesLimited investigationFinal reportAerostar S-66A · Albuquerque, NMUpon landing, the balloon touched down on a gravel road and bounced over a small depression. The basket struck a small mound and threw three of the six passengers against the rail of the basket. The other passengers fell against them and the three were…Oct 11, 1987 · N64547 · No damageNTSB CHI88LA004Accident · No injuriesLimited investigationFinal reportCessna 150H · Elroy, WIUpon attempting his tenth touch and go the student pilot noticed, prior to touchdown, that the aircraft was to the right of the runway. In an attempt to realign himself with the runway the pilot stated he 'lowered' the left wing. The left wing then struck the…Oct 11, 1987 · N50124 · Substantial damageNTSB ATL88DKG05Accident · No injuriesFinal reportAmerican Falcon XP · Palmetto, GAThe pilot failed to properly flare the aircraft during a normal landing which resulted in a hard landing. The nose gear assembly failed from overload, and the pilot was not able to control the aircraft as it slid over the ground. The aircraft collided with a…Oct 11, 1987 · N377AA · Substantial damageNTSB FTW88DRG01Accident · No injuriesFinal reportNorth American P82-B · Harlingen, TXThe aircraft was engaged in a demonstration flight with the confederate air force at rio grande valley international airport. During the approach to runway 17L the pilot flared the aircraft too high resulting in a stall and an excessive rate of descent. At…Oct 10, 1987 · N12102 · Substantial damageNTSB BFO88DIG01Accident · Minor injuriesFinal reportCessna 177A · Stevensville, MDWhile practicing touch-and-go landings, the student plt made an approach at a higher than normal airspeed. Subsequently,the acft bounced three times on the runway before the plt elected to go around. The student stated that control was lost on the go-around…Oct 10, 1987 · N30590 · Substantial damageNTSB ATL88LA009Accident · No injuriesLimited investigationFinal reportCessna 150L · Cumming, GAThe student pilot was attempting to land on the 1550 foot runway. The aircraft touched down hard and bounced. The pilot pushed forward on the control column and the aircraft came down on the nose gear which collapsed.Oct 10, 1987 · N18167 · Substantial damageNTSB ANC88LA005Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Skwentna, AKThe acft collided with a tree stump during a short field landing. The plt stated that the stump was hidden by tall grass. No official information is published abt the johnson airstrip.Oct 10, 1987 · N3651N · Substantial damageNTSB MKC88LA006Accident · No injuriesLimited investigationFinal reportBoeing A-75 · Creve Coeur, MOWhile practicing stop and go ldgs, plt lost control during rollout. Acft swerved and entered an inadvertent ground loop. The right main landing gear failed and the right lower wing contacted the ground.Oct 9, 1987 · N1754M · Substantial damageNTSB LAX88LA010Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · San Jose, CAThe pilot stated that during the landing roll he was distracted and looked downward. He said that when he looked back up the ground loop had started and it was too late to correct it. He did not report any mechanical problems prior to the accident.Oct 9, 1987 · N4085E · Substantial damageNTSB DEN88LA006Accident · No injuriesLimited investigationFinal reportCessna 182P · Monument Valley, UTThe private pilot was landing on a dirt runway and at touchdown a crosswind weathervaned the aircraft to the right. The pilot added full power to try to go around but the aircraft settled back to the ground left of the runway. The aircraft came to rest 300…Oct 9, 1987 · N7746G · Substantial damageNTSB SEA88LA004Accident · No injuriesLimited investigationFinal reportCessna 180C · Juneau, AKWhile landing onto a soft, sandy beach area the aircraft nosed over inverted. The plt failed to file an accident report.Oct 8, 1987 · N9705Z · Substantial damageNTSB MKC88LA011Accident · No injuriesLimited investigationFinal reportChampion 7GCB · Warrensburg, MOThe plt indicated that on final app, when ovr the rwy threshold, he leveled the acft off at abt 10 ft and it dropped in. Subsequent inspection revealed that all four wing spars had longitudinal cracks. The plt had recently purchased the acft and had abt 14…Oct 8, 1987 · N9967Y · Substantial damageNTSB FTW88LA003Accident · No injuriesLimited investigationFinal reportGrumman GA7 · Covington, LAThe pilot touched down with excessive speed, and due to the poor mechanical condition of the aircraft's brakes, was unable to stop before over-running the departure end of the runway. The aircraft's annual inspection was two months overdue. The pilot's…Oct 8, 1987 · N718GA · Substantial damageNTSB DEN88LA005Accident · Serious injuriesLimited investigationFinal reportRockwell 690B · Albuquerque, NMAcft was landing on rwy 17 at coronado airport, 9 NM n of Albuquerque, NM intl arpt. Plt said he brought props into reverse and acft went off right side of rwy. Plt brought props out of reverse, realigned acft on rwy, and reversed props again. Acft went off…Oct 8, 1987 · N711TT · DestroyedNTSB ATL88LA005Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Collegedale, TNThe airplane touched down while the ldg gear were extending. A witness reported that the acft began the ldg flare with the gear completely retracted, and that the gear began to extend when the airplane was 3-4 ft above the rwy. The main ldg gear contacted the…Oct 8, 1987 · N5988P · Substantial damageNTSB SEA88LA001Accident · No injuriesLimited investigationFinal reportBritish Aerospace BA-3101 · Kennewick, WAWhile on a flight to pasco, WA. The pilot inadvertently landed at the Kennewick, WA. Vista airport, landed long, and overran the runway. The aircraft departed the end of the runway and impacted terrain.Oct 7, 1987 · N406UE · Substantial damageNTSB MKC88LA001Accident · No injuriesLimited investigationFinal reportBellanca 17-31ATC · Wamego, KSDuring a night ldg the plt aligned the acft with the white tops of a fence that was parallel to the runway. Not all of the rwy lights were illuminated. Both wings and the lower fuselage were substantially damaged during the lndg on the fence.Oct 6, 1987 · N8786V · Substantial damageNTSB DEN88LA003Accident · No injuriesLimited investigationFinal reportCessna 152 · Tremonton, UTThe student plt flew to the first stop on his cross country training flight. He misread the windsock and landed downwind on runway 17. After touchdown the pilot lost control of the aircraft and taxied off the left side of the runway, hit a fence and a tree…Oct 6, 1987 · N7572B · Substantial damageNTSB LAX88FA006Accident · No injuriesField investigationFinal reportBoeing 767-201 · Los Angeles, CAThe captain sensed the aircraft ballooning during the flare. He increased the pitch angle to 11.8 degrees to arrest the descent during touchdown. Flight attendants sitting in the aft cabin crew seats heard a scraping sound just prior to main landing gear…Oct 5, 1987 · N604P · Substantial damageNTSB DEN88LA004Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7-B · Rio Rancho, NMThe plt rptd that she had vented the Balloon to land. She said it takes both of her hands to open the vent and hold it open. 'When the Balloon hit the ground the burner went on by itself, wide open. The envelope was swinging from the contact of the basket…Oct 5, 1987 · N15260 · Substantial damageNTSB CHI88LA002Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Verona, WIDuring a VFR landing abort full power was applied and flaps selected to the full up position. The aircraft began to settle and a turn to the left was initiated. The left wing dropped abruptly, the nose pitched down and a left hand rotation began. This…Oct 5, 1987 · N3226T · DestroyedNTSB LAX88LA004Accident · Minor injuriesLimited investigationFinal reportRepublic RC-3 · Clearlake, CAThe aircraft nosed over when the pilot made a water landing with the wheels extended. The pilot failed to use the landing checklist.Oct 4, 1987 · N87583 · Substantial damageNTSB LAX88LA003Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Big Bear City, CAThe student pilot bounced during landing and collided with runway lights and a taxiway sign. He landed on runway 25 with winds reported 040 degrees at 8 knots. He said he could not receive wind information because he had inadvertantly turned off his radio.Oct 4, 1987 · N7368L · Substantial damageNTSB LAX88FA001Accident · 1 fatalField investigationFinal reportCessna 172RG · Calistoga, CAUpon arriving over the destination arpt the plt used an incorrect CTAF frequency to contact the arpt and he used a right hand traffic pattern approaching the 2600 foot-long rwy. Because a residential area lay west of the arpt & open fields lay to the east,…Oct 4, 1987 · N5234U · DestroyedNTSB ATL88LA003Accident · No injuriesLimited investigationFinal reportCessna 172N · Thomson, GADuring the ldg roll on rwy 28, a crosswind gust caused the airplane to become airborne again. The plt added full pwr and attempted to abort the ldg. The airplane subsequently drifted to the downwind side of the runway and impacted rising terrain. The plt…Oct 3, 1987 · N5266E · Substantial damageNTSB ATL88LA001Accident · No injuriesLimited investigationFinal reportCessna 172P · Hilton Head, SCThe student plt was performing a crosswind landing which resulted in a hard landing. The acft drifted to the side of the rwy and one wheel was off the paved surface upon the next touchdown. The student plt attempted to hold the acft straight in the direction…Oct 3, 1987 · N66090 · Destroyed