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 ERA19TA277Accident · Serious injuriesClass 3Final reportVans RV 6 · Lakeland, FLThe pilot’s inability to maintain control due to passenger interference.Sep 23, 2019 · N12033 · Substantial damageNTSB GAA19WA561Accident · 1 fatalForeign investigationMooney M20K · Orio al Serio, ItalyThe government of Italy has notified the NTSB of an accident involving a MOONEY M20K airplane that occurred on September 21, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the provisions…Sep 21, 2019 · D-EISE · DestroyedNTSB GAA19CA559Accident · No injuriesData collectionFinal reportPiper PA60 · Sedona, AZThe pilot's exceedance of the airplane's critical angle of attack during landing in gusting crosswind conditions, which resulted in an aerodynamic stall.Sep 20, 2019 · N700NJ · Substantial damageNTSB GAA19CA566Accident · No injuriesData collectionFinal reportCessna 152 · Denton, TXThe student pilot's improper landing flare, which resulted in a hard, bounced landing and a nose landing gear collapse.Sep 18, 2019 · N93069 · Substantial damageNTSB GAA19CA584Accident · No injuriesData collectionFinal reportPiper PA18 · New Meadows, IDThe pilot receiving instruction's failure to maintain directional control during takeoff with a gusting, right quartering headwind, which resulted in a noseover.Sep 17, 2019 · N6741L · Substantial damageNTSB GAA19CA556Accident · No injuriesData collectionFinal reportCessna 152 · Naples, FLThe student pilot's improper landing flare, which resulted in a porpoised landing and a nose landing gear collapse.Sep 17, 2019 · N472TC · Substantial damageNTSB GAA19CA552Accident · No injuriesData collectionFinal reportMaule M 6-235 · Palmer, AKThe pilot's selection of unsuitable terrain for landing and his failure to maintain directional control during the landing, which resulted in the airplane hitting a rut, bouncing, and then nosing over.Sep 17, 2019 · N88DK · Substantial damageNTSB GAA19CA554Accident · No injuriesData collectionFinal reportPiper PA32R · Owasso, OKThe pilot's improper altitude and airspeed control during landing, which resulted in the airplane landing long and a subsequent runway overrun and impact with a drainage culvert.Sep 16, 2019 · N6887J · Substantial damageNTSB GAA19CA545Accident · No injuriesData collectionFinal reportCessna P206 · Caldwell, IDThe pilot's improper approach, which resulted in a long landing, a runway overrun, and collision with a drainage culvert.Sep 13, 2019 · N4746F · Substantial damageNTSB ERA19CA291Accident · No injuriesData collectionFinal reportBeech 55 · Sebring, FLThe passenger’s inadvertent retraction of the landing gear during the landing roll without being instructed to do so by the pilot.Sep 13, 2019 · N854T · Substantial damageNTSB WPR19WA275Incident · No injuriesForeign investigationCessna 525 · Nanded, IndiaSep 12, 2019 · VT-BRT · Minor damageNTSB WPR19LA257Accident · Serious injuriesClass 3 · LimitedFinal reportKubicek BB60 · Goodsprings, NVThe pilot's failure to maintain the proper descent rate during the approach to landing, which resulted in a hard landing and serious injuries to the pilot and two passengers.Sep 12, 2019 · N505CZ · Substantial damageNTSB GAA19CA544Accident · No injuriesData collectionFinal reportCessna 172F · Hemet, CAThe flight instructor's improper decision to perform a precautionary landing on unsuitable terrain, which resulted in a noseover.Sep 12, 2019 · N5229F · Substantial damageNTSB GAA19CA543Accident · No injuriesData collectionFinal reportCessna 150 · Memphis, TNThe student pilot's improper landing flare and the flight instructor's delayed remedial action during landing, which resulted in a loss of airplane control and impact with terrain.Sep 12, 2019 · N21979 · Substantial damageNTSB GAA19CA596Accident · No injuriesData collectionFinal reportPitts S1 · Reno, NVThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and a ground loop.Sep 11, 2019 · N515JD · Substantial damageNTSB GAA19CA581Accident · No injuriesData collectionFinal reportCessna 152 · Hollywood, FLThe student pilot's improper landing flare, which resulted in a hard landing and a collapsed nose landing gear.Sep 11, 2019 · N904WA · Substantial damageNTSB ERA19LA268Accident · Minor injuriesClass 3 · LimitedFinal reportBeech K35 · St. Augustine, FLAn unintended brake application of the right main landing gear brake system during the landing rollout due to excessive play between the brake caliper anchor bolts and their bushings.Sep 11, 2019 · N5300E · Substantial damageNTSB CEN19LA315Accident · No injuriesClass 3 · LimitedFinal reportPiper PA34 · Kingman, KSThe malfunction of the landing gear extension system for reasons that could not be determined with the available evidence.Sep 11, 2019 · N328RG · Substantial damageNTSB CEN19TA310Accident · No injuriesClass 3Final reportChampion 7KCAB · Winnsboro, LAThe pilot's failure to maintain directional control during a crosswind landing, which resulted in an impact with a tree.Sep 7, 2019 · N4136Y · Substantial damageNTSB GAA19CA531Accident · No injuriesData collectionFinal reportRobinson R44 · Nuiqsut, AKThe pilot's improper decision to land downwind from unsecured debris, which resulted in the helicopter’s main rotor disk ingesting foreign objects.Sep 6, 2019 · N447PA · Substantial damageNTSB CEN19LA322Accident · No injuriesClass 3 · LimitedFinal reportCessna 195A · Pocahontas, IAOverload failure of the left main landing gear during landing, which resulted in a loss of directional control.Sep 6, 2019 · N9895A · Substantial damageNTSB GAA19CA538Accident · No injuriesData collectionFinal reportPiper PA18 · Palmer, AKThe pilot's failure to maintain a proper descent rate, which resulted in a hard landing.Sep 5, 2019 · N19GB · Substantial damageNTSB GAA19CA526Accident · No injuriesData collectionFinal reportPietenpol Pietenpol Aircamper · Glendo, WYThe pilot's overapplication of brakes during the landing roll, which resulted in a noseover.Sep 5, 2019 · N14961 · Substantial damageNTSB GAA19CA525Accident · Minor injuriesData collectionFinal reportCessna 182 · Charleston, WVThe pilot's improper approach path at night and his misjudgment of the landing point, which resulted in landing short of the runway and impact with the runway's engineered materials arrestor system.Sep 5, 2019 · N2408Q · Substantial damageNTSB ANC19LA053Accident · No injuriesClass 3 · LimitedFinal reportPiper PA18 · Chugiak, AKOne of the pilot’s inadvertent application of the airplane's brakes, which resulted in a nose over.Sep 5, 2019 · N5057Y · Substantial damageNTSB GAA19CA548Accident · No injuriesData collectionFinal reportCessna 180 · Lancaster, TXThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.Sep 4, 2019 · N9250T · Substantial damageNTSB GAA19CA523Accident · No injuriesData collectionFinal reportCessna A185 · San Carlos, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.Sep 3, 2019 · N34GE · Substantial damageNTSB ANC19LA051Accident · No injuriesClass 3 · LimitedFinal reportLake LA-4-200 · Girdwood, AKThe pilot's loss of directional control while landing, which resulted in a runway excursion and collision with terrain.Sep 3, 2019 · N6672L · Substantial damageNTSB GAA19CA520Accident · No injuriesData collectionFinal reportPiper PA32RT · Mackinac Island, MIThe pilot's failure to maintain directional control during landing with a crosswind, which resulted in a runway excursion and impact with a runway light.Sep 2, 2019 · N31934 · Substantial damageNTSB CEN19TA327Accident · No injuriesClass 3Final reportPiper PA60 · Tulsa, OKThe pilot's improper landing flare, which resulted in an aerodynamic stall and hard landing.Sep 2, 2019 · N1R · Substantial damageNTSB CEN19LA302Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · La Grange, TXThe pilot's improper flare, which resulted in a hard landing.Sep 2, 2019 · N212BS · Substantial damageNTSB GAA19CA530Accident · No injuriesData collectionFinal reportPiper PA 18 · Chickaloon, AKThe pilot's selection of unsuitable terrain for landing and the pilot's improper pitch control during the landing roll which resulted in a nose over.Sep 1, 2019 · N72842 · Substantial damageNTSB GAA19CA524Accident · No injuriesData collectionFinal reportPiper PA 28-180 · Manchester, NHThe student pilot's failure to maintain directional control during landing with a crosswind, which resulted in a runway excursion and impact with approach lights.Sep 1, 2019 · N7777W · Substantial damageNTSB GAA19CA527Accident · No injuriesData collectionFinal reportDiamond DA20 · Convington, TNThe student pilot's improper pitch attitude during the takeoff climb, and the flight instructor's delayed remedial action which resulted in an aerodynamic stall and ground impact.Aug 31, 2019 · N98BZ · Substantial damageNTSB WPR19TA248Accident · Minor injuriesClass 3Final reportHall Kitfox · Nampa, IDThe owner's improper installation of the tailwheel, which resulted in the pilot's inability to maintain directional control during landing as a result of severe tailwheel vibrations.Aug 30, 2019 · N87TJ · Substantial damageNTSB GAA19CA568Accident · No injuriesData collectionFinal reportLuscombe 8 · Prescott, AZThe pilot's loss of directional control and subsequent overapplication of rudder pedal, which resulted in a runway excursion and the right wing striking the ground.Aug 30, 2019 · N25100 · Substantial damageNTSB GAA19CA537Accident · No injuriesData collectionFinal reportCzech Sport Sportcruiser · Murrieta, CAThe student pilot's improper landing flare, which resulted in a bounced landing, and his subsequent loss of directional control and a hard landing.Aug 30, 2019 · N117BF · Substantial damageNTSB CEN19LA292Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Denver, COA total loss of electrical power for reasons that could not be determined, and the student pilot’s subsequent runway overrun during a no-flap landing.Aug 29, 2019 · N53432 · Substantial damageNTSB ANC19LA047Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-22-150 · Talkeetna, AKA failure of the aft left weld-on fuselage landing gear fitting due to a poor weld joint.Aug 29, 2019 · N7236D · Substantial damageNTSB GAA19CA518Accident · No injuriesData collectionFinal reportPiper PA32RT · Ashland, ORThe pilot's improper landing flare, which resulted in a bounced, hard landing and propeller strike, and his subsequent loss of directional control.Aug 28, 2019 · N2228B · Substantial damageNTSB GAA19CA519Accident · No injuriesData collectionFinal reportBell 206 · San Diego, CAThe pilot's failure to maintain yaw and pitch control while repositioning the helicopter, which resulted in dynamic rollover.Aug 27, 2019 · N218GH · Substantial damageNTSB GAA19CA515Accident · No injuriesData collectionFinal reportPiper PA18 · Kenai, AKThe pilot's improper landing flare, which resulted in a hard landing and the subsequent loss of directional control and impact with a tree.Aug 27, 2019 · N7184B · Substantial damageNTSB WPR19FA241Accident · 1 fatalClass 3 · FieldFinal reportGlaser Dirks DG 300 Elan · Wilkeson, WAThe pilot’s delayed decision to land following a loss of thermal lift, which resulted in collision with trees during the landing approach.Aug 25, 2019 · N300GG · Substantial damageNTSB CEN19TA330Accident · No injuriesClass 3Final reportCirrus SR22 · Glenwood Springs, COThe pilot’s failure to maintain control of the airplane while landing with a tail wind, which resulted in an aerodynamic stall and a subsequent hard landing..Aug 25, 2019 · N983WP · Substantial damageNTSB WPR19LA239Accident · No injuriesClass 3 · LimitedFinal reportPiper PA24 · Wendover, UTFailure of the landing gear solenoid, which resulted in failure of the landing gear position switch, and the pilot's subsequent inability to extend the gear using the manual emergency extension system for undetermined reasons.Aug 24, 2019 · N6696P · Substantial damageNTSB GAA19CA510Accident · No injuriesData collectionFinal reportAmerican Legend AL3C · Waco, TXThe student pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and noseover.Aug 24, 2019 · N173JE · Substantial damageNTSB CEN19TA328Accident · Serious injuriesClass 3Final reportLindstrand 105A · Lawton, OKA hard landing, which resulted the basket tipping over and a passenger sustaining a serious injury.Aug 23, 2019 · N7172D · No damageNTSB GAA19CA508Accident · No injuriesData collectionFinal reportPiper PA28 · Hemet, CAThe student pilot's failure to maintain directional control while attempting to go around, which resulted in a runway excursion and impact with a ditch.Aug 22, 2019 · N16435 · Substantial damageNTSB GAA19CA507Accident · No injuriesData collectionFinal reportMaule M5 · Anchorage, AKThe pilot's excessive braking during landing on a dry lakebed, which resulted in a nose-over.Aug 22, 2019 · N9096E · Substantial damageNTSB GAA19CA505Accident · No injuriesData collectionFinal reportPipistrel Sinus 912 · Oxford, FLThe pilot’s continued use of battery power during a nonpowered flight in a powered-glider, which depleted the battery to a level that was insufficient to power the starter during the engine restart sequence and resulted in a forced landing to a soft field and…Aug 22, 2019 · N331AV · Substantial damage