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 GAA18CA304Accident · No injuriesData collectionFinal reportBeech 58 · Gainesville, GAThe pilot’s failure to maintain a proper landing flare in gusting crosswind conditions.May 6, 2018 · N406PA · Substantial damageNTSB GAA18CA260Accident · No injuriesData collectionFinal reportCessna 182 · Clarksville, TNThe pilot’s decision to land with a tailwind in variable crosswind and downdraft and updraft conditions on a wet runway, which resulted in a runway overrun.May 6, 2018 · N5419E · Substantial damageNTSB GAA18CA284Accident · No injuriesData collectionFinal reportYakovlev YAK 52 · Bayou La Batre, ALThe pilot’s improper planning for landing on a wet grass airstrip, which resulted in a runway overrun.May 5, 2018 · N81FS · Substantial damageNTSB GAA18CA277Accident · No injuriesData collectionFinal reportCessna 162 · Waterloo, INThe pilot’s improper landing flare during a soft-field landing and his use of an improper soft-field landing procedure, which resulted in a bounced landing.May 5, 2018 · N263VX · Substantial damageNTSB GAA18CA268Accident · No injuriesData collectionFinal reportPiper PA 15 · Fulton, NYThe pilot’s failure to maintain directional control during landing.May 5, 2018 · N4534H · Substantial damageNTSB GAA18CA267Accident · No injuriesData collectionFinal reportCessna 172 · Fulton, NYThe student pilot’s improper landing flare, which resulted in a hard, bounced landing.May 5, 2018 · N7762X · Substantial damageNTSB GAA18CA259Accident · Minor injuriesData collectionFinal reportCreech Jerry Creech Jerry CH 701 · Lusby, MDThe pilot’s improper landing flare, which resulted in a hard, bounced landing and runway excursion.May 5, 2018 · N701XS · Substantial damageNTSB GAA18CA256Accident · No injuriesData collectionFinal reportCessna A185 · Chandler, AZThe pilot’s failure to maintain directional control during landing in gusting tailwind conditions.May 5, 2018 · N76SC · Substantial damageNTSB GAA18CA255Accident · No injuriesData collectionFinal reportPphu Ekolot KR-030 Topaz · Dekalb, ILThe pilot’s improper landing flare during gusting wind conditions, and the flight instructor’s delayed remedial action.May 5, 2018 · N468KM · Substantial damageNTSB GAA18CA254Accident · No injuriesData collectionFinal reportBeech 58 · Sisters, ORThe pilot’s failure to maintain sufficient altitude during approach in gusting crosswind conditions, which resulted in an attempted rejected landing and a runway undershoot.May 5, 2018 · N222BD · Substantial damageNTSB GAA18CA258Accident · No injuriesData collectionFinal reportBerger Bernard M Pulsar Series III · Palmyra, PAThe pilot’s failure to maintain an appropriate approach speed, which resulted in a bounced landing and a runway overrun.May 3, 2018 · N914BB · Substantial damageNTSB WPR18LA133Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Borrego Springs, CAThe loss of the helicopter’s drive system for reasons that could not be determined from the available evidence, which led to an autorotation that resulted in a hard landing and rollover on uneven sandy terrain.Apr 30, 2018 · N423ML · Substantial damageNTSB GAA18CA294Accident · No injuriesData collectionFinal reportCessna 172 · Palo Alto, CAThe pilot’s improper landing flare, which resulted in a hard landing.Apr 30, 2018 · N254EK · Substantial damageNTSB GAA18CA252Accident · No injuriesData collectionFinal reportBeech 95B55 · Little Rock, ARThe pilot’s improper landing flare.Apr 30, 2018 · N550K · Substantial damageNTSB DCA18WA160Incident · No injuriesForeign investigationBoeing 737 · Gorontalo, IndonesiaThe National Transportation Safety Committee of Indonesia has notified the NTSB of an incident involving a Boeing 737, which occurred on April 29, 2018. The NTSB has appointed a U.S. Accredited Representative to assist in the investigation under the…Apr 29, 2018 · PK-LOO · Minor damageNTSB GAA18CA241Accident · No injuriesData collectionFinal reportAeronca 65 LB · Carrington, NDThe pilot’s failure to maintain directional control and his subsequent excessive brake application during landing, which resulted in a nose-over.Apr 28, 2018 · N34459 · Substantial damageNTSB GAA18CA238Accident · No injuriesData collectionFinal reportStinson 108 · Spokane, WAThe pilot’s failure to maintain directional control during landing.Apr 28, 2018 · N35VM · Substantial damageNTSB CEN18WA155Incident · No injuriesForeign investigationDassault-Breguet Falcon 900 · Bremgarten, GermanyOn April 28, 2018, 2015, about 1505 universal time (UTC), a United States registered Dassault-Breguet Falcon-900, N670JD, was involved in an incident in Bremgarten, Germany. The pilot, copilot, and 2 passengers were not injured. The investigation is under the…Apr 28, 2018 · N670JD · No damageNTSB GAA18CA239Accident · No injuriesData collectionFinal reportBeech 76 · Vacaville, CAThe pilot under instruction’s failure to extend the landing gear and the flight instructor’s inadequate supervision and failure to ensure that the landing gear was extended.Apr 27, 2018 · N54V · Substantial damageNTSB WPR18LA129Accident · No injuriesClass 3 · LimitedFinal reportGulfstream AM Corp Comm Div 695A · Bishop, CAThe failure of the left main landing gear upper arm forging due to fatigue cracking and subsequent overstress, which resulted in the collapse of the landing gear during the landing roll.Apr 26, 2018 · N79PH · Substantial damageNTSB ERA18LA136Accident · No injuriesLimited investigationFinal reportCessna 402 · Barre Plains, MAThe pilot's improper decision to land with a tailwind, which resulted in a touchdown with insufficient runway remaining to stop the airplane.Apr 26, 2018 · N87266 · Substantial damageNTSB ANC18LA033Accident · Serious injuriesLimited investigationFinal reportNorth Wing Uum Sport X2-N · Pahrump, NVThe pilot's improper landing flare, which resulted in a fractured engine mount sway bar and subsequent difficulty controlling the airplane, and his inadvertent application of throttle pedal during landing, which resulted in a loss of control.Apr 25, 2018 · N366DN · Substantial damageNTSB GAA18CA240Accident · No injuriesData collectionFinal reportBrown Joseph Sportsman GS-2 · Kalispell, MTThe pilot’s selection of an unsuitable snow-covered airstrip for landing, which resulted in a nose-over.Apr 24, 2018 · N454HP · Substantial damageNTSB GAA18CA589Accident · No injuriesData collectionFinal reportPiper PA28R · Camarillo, CAThe flight instructor's improper landing flare, which resulted in a hard landing.Apr 23, 2018 · N9368N · Substantial damageNTSB GAA18CA231Accident · No injuriesData collectionFinal reportCessna 162 · York, PAThe pilot’s improper landing flare, which resulted in a hard, bounced landing and a nose landing gear collapse.Apr 22, 2018 · N6020Y · Substantial damageNTSB GAA18CA227Accident · No injuriesData collectionFinal reportIrvin Stephen D Rutan Long E Z · Tucson, AZThe pilot’s excessive ground speed and loss of directional control while exiting the taxiway.Apr 22, 2018 · N8714S · Substantial damageNTSB GAA18CA223Accident · No injuriesData collectionFinal reportKen Olson Scamp · Raymond, WAThe pilot's failure to maintain a proper landing flare, which resulted in an aerodynamic stall, bounced landing, and subsequent secondary stall during a go-around attempt.Apr 22, 2018 · N964TA · Substantial damageNTSB CEN18WA161Accident · No injuriesForeign investigationCessna 172 · Hagfors, SwedenOn April 22, 2018, at 1240 coordinated universal time, a Cessna F172E single-engine airplane, Swedish registration SE-EHI, serial number F172-0039, encountered soft terrain and nosed over upon landing at Hagfors Airport (ESOH), near Hagfors, Sweden. The…Apr 22, 2018 · SE-EHI · Substantial damageNTSB GAA18CA411Accident · No injuriesData collectionFinal reportEipper Quicksilver · Marietta, SCThe pilot's improper landing flare, which resulted in a loss of directional control.Apr 21, 2018 · N126AS · Substantial damageNTSB GAA18CA225Accident · No injuriesData collectionFinal reportRepublic RC 3 · Pelion, SCThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.Apr 21, 2018 · N9042N · Substantial damageNTSB GAA18CA232Accident · No injuriesData collectionFinal reportCessna 172 · San Jose, CAThe student pilot’s failure to maintain the runway heading during the approach to land, and the flight instructor’s delayed remedial action.Apr 20, 2018 · N23AT · Substantial damageNTSB DCA18FA144Accident · No injuriesField investigationFinal reportMcdonnell Douglas DC 9 83(MD-83) · Alexandria, LAthe failure of the right main landing gear under normal loads due to fatigue cracking in an area subject to an FAA Airworthiness Directive that was not adequately inspected.Apr 20, 2018 · N807WA · Substantial damageNTSB GAA18CA251Accident · No injuriesData collectionFinal reportBeech 95 B55 · Suffolk, VAThe pilot’s failure to properly secure the portable GPS and antenna cable, which resulted in the inadvertent landing gear retraction during landing.Apr 17, 2018 · N4464S · Substantial damageNTSB GAA18CA228Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P92 Eaglet · Ashland, VAThe student pilot’s improper landing flare and the flight instructor’s delayed remedial action, which resulted in a hard landing.Apr 17, 2018 · N404TA · Substantial damageNTSB GAA18CA219Accident · No injuriesData collectionFinal reportStone James R Daytona Cubs Replica · Orlando, FLThe pilot’s failure to maintain lateral control during landing in crosswind conditions.Apr 17, 2018 · N3102Z · Substantial damageNTSB GAA18CA224Accident · No injuriesData collectionFinal reportMooney M20R · San Antonio, TXThe pilot’s landing long in tailwind conditions with insufficient runway remaining to stop the airplane.Apr 16, 2018 · N6868 · Substantial damageNTSB GAA18CA218Accident · No injuriesData collectionFinal reportPiper PA 28-161 · Pensacola, FLThe pilot’s loss of directional control and long landing in gusting wind conditions due to his shoe getting stuck on the brakes.Apr 15, 2018 · N8115Y · Substantial damageNTSB GAA18CA226Accident · No injuriesData collectionFinal reportTextron G58 · Easton, MDThe pilot’s improper landing flare, which resulted in a hard landing.Apr 13, 2018 · N67WM · Substantial damageNTSB GAA18CA211Accident · No injuriesData collectionFinal reportCessna A185 · Sterling, AKThe pilot’s failure to maintain clearance from trees during the approach to land due to the sun glare.Apr 12, 2018 · N8702Z · Substantial damageNTSB GAA18CA210Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Franklin, CAThe pilot receiving instruction’s abrupt cyclic control input during the touch-down autorotation.Apr 11, 2018 · N622MP · Substantial damageNTSB ERA18WA132Accident · No injuriesForeign investigationBell 206 · Vereda Plateado, ColombiaThe government of Colombia has notified the NTSB of an accident involving a BELL 206 helicopter that occurred on April 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the provisions…Apr 11, 2018 · HK-4776 · Substantial damageNTSB GAA18CA207Accident · No injuriesData collectionFinal reportPiper PA34 · San Diego, CAThe pilot receiving instruction and flight instructor’s failure to properly configure the landing gear before landing, which resulted in landing with the landing gear retracted.Apr 10, 2018 · N4567T · Substantial damageNTSB GAA18CA206Accident · No injuriesData collectionFinal reportBice David E Bearhawk · Edgewood, NMThe pilot’s failure to maintain directional control of the airplane during landing.Apr 10, 2018 · N1685 · Substantial damageNTSB GAA18CA209Accident · No injuriesData collectionFinal reportCessna Ector 305A · South Lake Tahoe, CAThe pilot receiving instruction’s failure to maintain directional control during the landing roll.Apr 9, 2018 · N1832 · Substantial damageNTSB GAA18CA212Accident · No injuriesData collectionFinal reportSasser Allen L Searey · Welaka, FLThe pilot’s incorrect pitch input during a water landing, which resulted in a nose-over. Contributing to the accident were the pilot’s inadequate training and experience in the make and model airplane.Apr 6, 2018 · N124AL · Substantial damageNTSB GAA18CA203Accident · No injuriesData collectionFinal reportCarr B L RV 4 · Caldwell, IDThe failure of the weld on the airplane’s left main landing gear axle support strut during landing, which resulted in a loss of directional control.Apr 6, 2018 · N66PB · Substantial damageNTSB GAA18CA205Accident · No injuriesData collectionFinal reportLuscombe 8 · Vernon, TXThe pilot’s failure to maintain directional control during landingApr 5, 2018 · N71617 · Substantial damageNTSB GAA18CA201Accident · Minor injuriesData collectionFinal reportCessna 172 · Livermore, CAThe student pilot’s failure to maintain runway centerline and flight instructor’s delayed remedial action during landing.Apr 5, 2018 · N1438U · Substantial damageNTSB CEN18WA184Accident · No injuriesForeign investigationCessna 525 · Santiago, SpainOn April 5, 2018, about 1810 universal coordinated time (UTC), a Cessna 525C, Spanish registration EC-MOQ, was involved in an accident at the Santiago Airport (A Coruha, Spain). The left main landing gear collapsed while exiting the runway after landing. Two…Apr 5, 2018 · EC-MOQ · Substantial damageNTSB WPR18WA117Incident · No injuriesForeign investigationBeech 58 · East London, South AfricaOn April 3, 2018, at 0612 coordinated universal time, a Beechcraft 58 Baron airplane, registration ZS-JYD, sustained minor damage after the nose gear collapsed during landing at East London (FAEL), Eastern Cape, South Africa. The pilot, sole occupant, was not…Apr 3, 2018 · ZS-JYD · Minor damage