OpenAirDocs.org

NTSB investigations

53,702 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 GAA18CA489Accident · No injuriesData collectionFinal reportMaule MX7 · Valdez, AKThe pilot's failure to maintain the proper airspeed during landing, which resulted in a bounced landing and subsequent nose-over.Aug 10, 2018 · N7ZV · Substantial damageNTSB GAA18CA487Accident · No injuriesData collectionFinal reportCessna U206 · Waynesville, OHThe pilot's inability to stop the airplane on the wet runway after an aborted go-around, which resulted in a runway overrun and impact with terrain.Aug 10, 2018 · N29204 · Substantial damageNTSB GAA18CA515Accident · No injuriesData collectionFinal reportDell Lawrence Kitfox · Hunter, NYThe pilot’s inadequate in-flight fuel management, which necessitated an off-airport precautionary landing, and his failure to maintain airplane control during the landing roll on rough terrain.Aug 9, 2018 · N26LD · Substantial damageNTSB GAA18CA480Accident · No injuriesData collectionFinal reportPiper PA18 · Raton, NMThe pilot's loss of directional control during the landing roll.Aug 9, 2018 · N104CC · Substantial damageNTSB GAA18CA479Accident · No injuriesData collectionFinal reportPiper PA28 · Merritt Island, FLThe pilot's exceedance of the airplane's critical angle of attack while maneuvering to avoid a bird during the landing flare, which resulted in an aerodynamic stall.Aug 9, 2018 · N487JK · Substantial damageNTSB GAA18CA478Accident · No injuriesData collectionFinal reportCessna 172 · Crystal River, FLThe pilot’s improper landing flare, which resulted in a hard landing.Aug 6, 2018 · N9608H · Substantial damageNTSB ERA18WA275Incident · No injuriesClass 4 · ForeignPiper PA42 · Contamana, PeruAug 6, 2018 · OB-1714 · Minor damageNTSB CEN18LA316Accident · Serious injuriesLimited investigationFinal reportChampion 7GCBC · Wiley, COThe pilot's failure to maintain proper clearance from the sprinkler guy-wire, which resulted in the airplane’s collision with the wire during a visual approach to landing.Aug 5, 2018 · N90990 · Substantial damageNTSB GAA18CA485Accident · No injuriesData collectionFinal reportCessna 172 · Sallisaw, OKThe student pilot's loss of directional control during the landing roll.Aug 4, 2018 · N707TM · Substantial damageNTSB GAA18CA473Accident · Serious injuriesData collectionFinal reportVans RV6 · Greeley, COThe pilot’s exceedance of the airplane’s critical angle of attack during approach, which resulted in an aerodynamic stall.Aug 4, 2018 · N56LK · Substantial damageNTSB GAA18CA472Accident · Minor injuriesData collectionFinal reportCessna 140 · Mount Holly, NJThe pilot's improper landing flare, which resulted in the airplane ballooning upon landing, and his subsequent loss of directional control and excessive brake application.Aug 4, 2018 · N1160D · Substantial damageNTSB GAA18CA467Accident · No injuriesData collectionFinal reportBeech 58 · Greenville, SCThe pilot failure to attain the proper touchdown point on a wet runway, which resulted in insufficient runway remaining to safely stop the airplane.Aug 3, 2018 · N59PR · Substantial damageNTSB CEN18LA309Accident · 1 fatalLimited investigationFinal reportCameron A 250 · Hartsel, COThe passengers’ fall from the basket after landing when the basket tipped over.Aug 3, 2018 · N2025J · No damageNTSB CEN18LA307Accident · No injuriesLimited investigationFinal reportGerald Dan Coppock Bade-E · Escanaba, MIThe loss of control during the landing rollout for reasons that could not be determined based on the available evidence, which resulted in a ground loop and runway excursion.Aug 2, 2018 · N142NV · Substantial damageNTSB WPR18LA216Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Big Creek, IDThe pilot's failure to maintain directional control during the landing roll.Aug 1, 2018 · N57477 · Substantial damageNTSB DCA18WA258Incident · No injuriesForeign investigationBoeing 737 · Pardubice, CzechiaThe government of Czech Republic has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on August 01, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Czech Republic's investigation under…Aug 1, 2018 · N624XA · No damageNTSB CEN18WA372Accident · No injuriesForeign investigationRobinson R22 · Naunton Beauchamp, Worcestershire, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a ROBINSON R22 helicopter that occurred on August 01, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation…Aug 1, 2018 · G-OODX · Substantial damageNTSB GAA18CA459Accident · No injuriesData collectionFinal reportHerzog CCX-2000 · Bend, ORThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and the subsequent collapse of the left main landing gear when he attempted to steer the airplane back onto the runway.Jul 31, 2018 · N116PM · Substantial damageNTSB DCA18CA266Accident · No injuriesClass 4 · Data collectionFinal reportBoeing 757 · Philadelphia, PAThe captain's improper control of the airplane during the landing flare.Jul 31, 2018 · N192AN · Substantial damageNTSB GAA18CA476Accident · No injuriesData collectionFinal reportAir Tractor AT502 · Louise, MSThe pilot's improper landing flare, which resulted in a hard, bounced landing and a subsequent loss of directional control.Jul 30, 2018 · N205SK · Substantial damageNTSB GAA18CA458Accident · No injuriesData collectionFinal reportAllen W Inks Virus SW · Clayton, GAThe pilot’s failure to maintain a proper descent rate, which resulted in a hard, bounced landing and runway overrun.Jul 30, 2018 · N608US · Substantial damageNTSB GAA18CA456Accident · No injuriesData collectionFinal reportLuscombe 8 · Pottsville, PAThe pilot’s failure to maintain directional control during landing.Jul 30, 2018 · N2022K · Substantial damageNTSB GAA18CA530Accident · No injuriesData collectionFinal reportPiper PA 12 · Edgewood, NMThe pilot’s failure to maintain directional control during the landing roll.Jul 29, 2018 · N4159M · Substantial damageNTSB GAA18CA462Accident · No injuriesData collectionFinal reportPiper PA24 · Evanston, WYThe pilot's failure to extend the landing gear during landing. Contributing to the accident were the pilot's distraction and his failure to complete the appropriate checklist before landing.Jul 29, 2018 · N7893P · Substantial damageNTSB CEN18LA298Accident · Minor injuriesLimited investigationFinal reportExtra EA300 · North Fox Island, MIThe Extra pilot’s failure to see and avoid the Cessna, which resulted in an in-flight collision. Contributing to the accident was the failure of the Extra pilot to tune his radio to the correct frequency, which resulted in no common traffic advisories being…Jul 29, 2018 · N32WR · 2 aircraft · Substantial damageNTSB GAA18CA452Accident · No injuriesData collectionFinal reportCessna 172 · Wadsworth, OHThe pilot’s failure to maintain directional control during landing.Jul 28, 2018 · N4855G · Substantial damageNTSB GAA18CA451Accident · No injuriesData collectionFinal reportVans RV 6 · Pickens, SCThe pilot's improper landing flare, which resulted in a bounced landing.Jul 28, 2018 · N24CM · Substantial damageNTSB GAA18WA590Accident · No injuriesForeign investigationAero Commander 500 · Canefield Airoprt, DominicaThe government of Dominica has notified the NTSB of an accident involving a AERO COMMANDER 500 airplane that occurred on July 27, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Dominica's investigation under the…Jul 27, 2018 · N590DR · Substantial damageNTSB GAA18CA461Accident · No injuriesData collectionFinal reportCessna 152 · Oak Harbor, WAThe student pilot's improper landing flare, which resulted in a hard, bounced landing.Jul 27, 2018 · N152LT · Substantial damageNTSB GAA18CA450Accident · Minor injuriesData collectionFinal reportRobinson R44 · Lantana, FLThe student pilot’s improper pitch control during landing, which resulted in a dynamic rollover.Jul 27, 2018 · N479AT · Substantial damageNTSB DCA18CA252Accident · No injuriesClass 4 · Data collectionFinal reportBoeing 767 · Portsmouth, NHan improper landing flare technique and the lack of the appropriate bounced landing recovery procedure.Jul 27, 2018 · N641GT · Substantial damageNTSB GAA18CA464Accident · No injuriesData collectionFinal reportCessna 172 · Spring, TXThe student pilot’s improper landing flare in a crosswind, which resulted in a hard landing.Jul 26, 2018 · N865CP · Substantial damageNTSB GAA18CA455Accident · No injuriesData collectionFinal reportCessna 140 · Healdsburg, CAThe pilot's improper brake application during the landing roll, which resulted in a nose-over.Jul 26, 2018 · N1902V · Substantial damageNTSB GAA18CA448Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Lawrenceville, VAThe pilot’s failure to maintain directional control during the landing roll with a tailwind.Jul 26, 2018 · N1489B · Substantial damageNTSB GAA18CA447Accident · No injuriesData collectionFinal reportAir Tractor AT502 · Iowa, LAThe pilot's failure to maintain directional control during the landing roll.Jul 26, 2018 · N254LA · Substantial damageNTSB ERA18LA201Accident · No injuriesClass 3 · LimitedFinal reportAero Commander 560 · Crestview, FLA collapse of the right main landing gear for reasons that could not be determined based on the available information.Jul 26, 2018 · N2705B · Substantial damageNTSB CEN18TA296Accident · No injuriesFinal reportFisher Dakato Hawk · Oshkosh, WIThe failure of the left main landing gear for reasons that could not be determined, which resulted in a loss of directional control during the ground roll.Jul 26, 2018 · N677TS · Substantial damageNTSB WPR18LA203Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA32 · Avalon, CAThe pilot's delayed decision to conduct a go-around following an unstable landing approach and long landing.Jul 25, 2018 · N4747H · Substantial damageNTSB WPR18LA206Accident · Minor injuriesClass 3 · LimitedFinal reportBell UH 1H · Oakdale, CAThe pilot's loss of control during a precautionary landing following an abnormal noise in-flight, the source of which could not be determined.Jul 24, 2018 · N107CH · Substantial damageNTSB GAA18CA436Accident · Serious injuriesData collectionFinal reportAirborne Windsports PTY Edge XT-912-L · Albuquerque, NMThe pilot’s failure to maintain directional control during landing.Jul 24, 2018 · N824PB · Substantial damageNTSB CEN18LA295Accident · Serious injuriesLimited investigationFinal reportVans RV7A · Princeton, MNA flat nosewheel tire, which resulted in the pilot’s inability to maintain directional control on landing.Jul 24, 2018 · N20342 · Substantial damageNTSB DCA18WA297Incident · No injuriesForeign investigationAirbus A330 · Mexico City, MexicoThe government of Mexico has notified the NTSB of an incident involving a AIRBUS A330 airplane that occurred on July 23, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…Jul 23, 2018 · XA-MRC · Minor damageNTSB GAA18CA443Accident · No injuriesData collectionFinal reportJust JA30 Superstol · Chelan Falls, WAThe pilot's improper approach over a river, which resulted in a collision with a dock.Jul 22, 2018 · N825PW · Substantial damageNTSB GAA18CA438Accident · No injuriesData collectionFinal reportMooney M20E · Great Falls, MTThe flight instructor’s incorrect use of the landing gear system and his and the pilot’s failure to ensure that the landing gear was extended, which resulted in a gear-up landing. Contributing to the accident was the flight instructor’s unfamiliarity with the…Jul 22, 2018 · N7845V · Substantial damageNTSB GAA18CA433Accident · No injuriesData collectionFinal reportCessna 172 · Colorado Springs, COThe student pilot’s failure to maintain directional control during landing in gusting crosswind conditions.Jul 22, 2018 · N99243 · Substantial damageNTSB GAA18CA444Accident · No injuriesData collectionFinal reportCessna 195 · Hood River, ORThe pilot’s failure to maintain directional control during landing.Jul 21, 2018 · N195N · Substantial damageNTSB GAA18CA446Accident · No injuriesData collectionFinal reportCessna 310 · Malden, MOThe pilot’s improper landing flare in gusting wind conditions, which resulted in a hard landing.Jul 20, 2018 · N46CH · Substantial damageNTSB GAA18CA439Accident · No injuriesData collectionFinal reportWayne D. Teel Waiex · Kinsey, KSThe pilot's failure to maintain directional control during the landing roll in gusting crosswind conditions.Jul 20, 2018 · N49YX · Substantial damageNTSB CEN18LA286Accident · Serious injuriesLimited investigationFinal reportVans RV6 · Coldwater, KSThe pilot's loss of control while landing a tailwheel-equipped airplane in gusting wind conditions.Jul 20, 2018 · N306FR · Substantial damageNTSB GAA18CA561Accident · No injuriesData collectionFinal reportApollo Fox · Chateaugay, NYThe pilot’s failure to maintain clearance from trees during a go-around.Jul 19, 2018 · N791YE · Substantial damage