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 GAA19CA445Accident · No injuriesData collectionFinal reportCessna 170 · Phoenix, AZThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and the right wing striking the ground.Jul 19, 2019 · N3276A · Substantial damageNTSB ERA19TA233Accident · No injuriesClass 3Final reportBeech 95B55 · Sanford, FLThe pilot's failure to extend the landing gear during landing.Jul 19, 2019 · N386Q · Substantial damageNTSB WPR19TA193Accident · Minor injuriesClass 3Final reportCessna 550 · Mesquite, NVThe pilot's operation of the airplane while intoxicated, which resulted in a loss of airplane control on landing.Jul 18, 2019 · N320JT · DestroyedNTSB GAA19CA433Accident · No injuriesData collectionFinal reportBrumbaugh David R DRB Raider · Laramie, WYThe pilot's improper landing flare, which resulted in a hard landing.Jul 18, 2019 · N703DB · Substantial damageNTSB GAA19CA425Accident · No injuriesData collectionFinal reportAeros Skyranger · Brownville, METhe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent loss of directional control while attempting a go-around, which resulted in a runway excursion and impact with trees.Jul 16, 2019 · N75561 · Substantial damageNTSB GAA19CA424Accident · No injuriesData collectionFinal reportCessna 172 · Grand Canyon, AZThe pilot's failure to maintain lateral control during landing in gusting wind conditions, which resulted in the left wing striking the ground.Jul 16, 2019 · N1079M · Substantial damageNTSB GAA19CA423Accident · No injuriesData collectionFinal reportCessna 182 · Salmon, IDThe pilot's delayed decision to abort the landing on a wet grass runway and the flight instructor's delayed remedial action. Contributing to the accident was the wet runway which degraded braking.Jul 16, 2019 · N4876N · Substantial damageNTSB GAA19CA487Accident · No injuriesData collectionFinal reportCessna 170 · Bison, SDThe pilot's improper landing flare, which resulted in a hard landing and subsequent ground loop.Jul 15, 2019 · N2946D · Substantial damageNTSB GAA19CA411Accident · No injuriesData collectionFinal reportPiper J3C · San Diego, CAThe pilot's failure to maintain directional control during landing, which resulted a ground loop.Jul 15, 2019 · N92628 · Substantial damageNTSB WPR19LA194Accident · Serious injuriesClass 3 · LimitedFinal reportBell 47G 3B 1 · Mosby, MTThe pilot’s failure to account for environmental conditions conducive to a loss of tail rotor effectiveness, which resulted in a loss of tail rotor effectiveness and subsequent loss of control. Contributing to the accident was the pilot’s inappropriate…Jul 13, 2019 · N3078G · Substantial damageNTSB GAA19CA408Accident · Minor injuriesData collectionFinal reportPiper PA 20 · Hamilton, MTThe pilot's loss of directional control due to his unintentional use of brakes instead of the rudder during the landing roll, which resulted in a nose-over.Jul 12, 2019 · N7409K · Substantial damageNTSB DCA19WA177Incident · No injuriesForeign investigationBoeing 737 · Kiev, UkraineThe NBAAI of Ukraine has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on July 12, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the NBAAI's investigation under the provisions of ICAO Annex 13 as…Jul 12, 2019 · EW336PA · Minor damageNTSB GAA19WA478Accident · No injuriesForeign investigationBeech C90 · Bucaramanga, ColombiaJul 11, 2019 · N989AE · Substantial damageNTSB GAA19CA406Accident · No injuriesData collectionFinal reportCessna 182 · Lincoln, MOThe pilot's exceedance of the airplane's critical angle of attack during landing, which resulted in an aerodynamic stall and a subsequent hard landing.Jul 11, 2019 · N2467G · Substantial damageNTSB GAA19CA402Accident · No injuriesData collectionFinal reportCessna 180 · Talkeetna, AKThe pilot's improper soft-field landing technique, which resulted in a nose-over.Jul 11, 2019 · N91299 · Substantial damageNTSB GAA19CA466Accident · No injuriesData collectionFinal reportDiamond DA 42 NG · Palatka, FLThe pilot receiving instruction's failure to extend the landing gear and the flight instructor's failure to verify that the landing gear was extended due to distraction, which resulted in a gear-up landing.Jul 10, 2019 · N805PA · Substantial damageNTSB GAA19CA430Accident · No injuriesData collectionFinal reportPiper PA28 · Wasilla, AKThe pilot's improper landing flare, which resulted in an aerodynamic stall and subsequent hard landing, runway excursion, and collision with a sign.Jul 10, 2019 · N4245J · Substantial damageNTSB GAA19CA398Accident · No injuriesData collectionFinal reportCessna R182 · Petersburg, VAThe pilot's failure to verify that the main landing gear were extended, which resulted in landing with partially extended landing gear. Contributing to the accident was a tripped landing gear motor circuit breaker.Jul 10, 2019 · N757PU · Substantial damageNTSB GAA19CA392Accident · No injuriesData collectionFinal reportNorth Wing Uum Scout · Westfield, INThe student pilot's improper landing flare, which resulted in a bounced landing and wing strike.Jul 8, 2019 · N419TN · Substantial damageNTSB GAA19CA396Accident · No injuriesData collectionFinal reportDonald Bernard Higgs Pietenpol · Anacortes, WAThe failure of the left main landing gear attachment point during the landing roll for reasons that could not be determined because the attachment was not examined, which resulted in a loss of directional control, collision with a drainage culvert, and a…Jul 7, 2019 · N7169K · Substantial damageNTSB ERA19TA223Accident · No injuriesClass 3Final reportCessna 180 · Okeechobee, FLThe pilot’s failure to maintain directional while landing with a quartering tailwind, which resulted in a ground loop.Jul 7, 2019 · N52031 · Substantial damageNTSB CEN19FA211Accident · 1 fatalClass 2 · FieldFinal reportGrob G103 · Brandon, MSThe pilot's inadequate clearance from a tree during an attempted off-field landing.Jul 6, 2019 · N106NS · Substantial damageNTSB GAA19CA388Accident · No injuriesData collectionFinal reportPiper PA18 · Talkeetna, AKThe pilot's improper decision to land on rough, grassy terrain, which resulted in a nose-over.Jul 5, 2019 · N5830C · Substantial damageNTSB CEN19LA207Accident · Minor injuriesClass 3 · LimitedFinal reportMd Helicopter 369 · Houston, TXThe loss of control upon landing for undetermined reasons.Jul 5, 2019 · N5277F · Substantial damageNTSB GAA19CA431Accident · No injuriesData collectionFinal reportDiamond DA40 · Tavernier, FLThe pilot's delayed decision to go around in high-temperature and high-density altitude conditions and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.Jul 4, 2019 · N420NG · Substantial damageNTSB GAA19CA394Accident · No injuriesData collectionFinal reportMerit CCX-2000 · Casper, WYThe pilot's failure to maintain directional control during landing with a tailwind, which resulted in a ground loop.Jul 4, 2019 · N941DM · Substantial damageNTSB GAA19CA390Accident · No injuriesData collectionFinal reportCessna 152 · Tracy, CAThe student pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with a vehicle.Jul 2, 2019 · N6306P · Substantial damageNTSB GAA19CA384Accident · No injuriesData collectionFinal reportAmerican AA5 · Cheyenne, WYThe pilot's failure to maintain a proper descent rate and landing flare during landing with a tailwind, which resulted in a hard landing and a subsequent loss of directional control, runway excursion, and collision with objects.Jul 2, 2019 · N387G · Substantial damageNTSB ERA19TA222Accident · No injuriesClass 3Final reportLuscombe 8 · Sevierville, TNThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and right main landing gear collapse.Jul 2, 2019 · N2352K · Substantial damageNTSB DCA19WA176Incident · No injuriesForeign investigationBoeing 737 · Mumbai, IndiaThe AAIB of India has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on July 02, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the provisions of ICAO Annex 13 as State of…Jul 2, 2019 · VT-SYK · Minor damageNTSB GAA19CA381Accident · No injuriesData collectionFinal reportCessna 175 · Coeur d'Alene, IDThe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent failure to maintain directional control during landing with a gusting crosswind, which resulted in a ground-loop.Jul 1, 2019 · N9235B · Substantial damageNTSB WPR19LA184Accident · Minor injuriesClass 3 · LimitedFinal reportCessna TR182 · Lincoln, MTA loss of control during landing, which resulted in a nose landing gear collapse and runway excursion.Jun 30, 2019 · N5JB · Substantial damageNTSB WPR19LA180Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28R · Chandler, AZThe pilot's failure to maintain directional control during landing in a gusting right quartering headwind, which resulted in a collapse of the left main landing gear.Jun 30, 2019 · N786N · Substantial damageNTSB GAA19CA434Accident · No injuriesData collectionFinal reportSKYBolt Smith Special Skybol · Stafford, VAThe pilot's failure to maintain the runway heading during an aborted go-around, which resulted in a hard landing.Jun 30, 2019 · N748JS · Substantial damageNTSB GAA19CA376Accident · No injuriesData collectionFinal reportPiper PA 12 · Yakima, WAThe separation of the left steering spring from the tailwheel assembly during landing for reasons that could not be determined, which resulted in a ground loop.Jun 30, 2019 · N4238M · Substantial damageNTSB DCA19WA180Incident · No injuriesForeign investigationBoeing 737 · Mangalore, IndiaThe AAIB of India has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on June 30, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the provisions of ICAO Annex 13 as State of…Jun 30, 2019 · VT-AYA · Minor damageNTSB GAA19CA477Accident · No injuriesData collectionFinal reportCessna 172 · Greer, SCThe pilot's improper decision to continue a steep and fast approach to landing, which resulted in a runway overrun and collision with a drainage culvert.Jun 29, 2019 · N724BC · Substantial damageNTSB GAA19CA399Accident · Serious injuriesData collectionFinal reportSchweizer SGS233 · Blairstown, NJThe student pilot's improper landing flare and the flight instructor's delayed remedial action, which resulted in a hard landing and the instructor sustaining a serious injury.Jun 29, 2019 · N2894H · No damageNTSB GAA19CA380Accident · No injuriesData collectionFinal reportHoward Steven C Super · Norwich, NYThe pilot's improper landing flare, which resulted in a hard landing.Jun 29, 2019 · N413MC · Substantial damageNTSB ERA19TA216Accident · No injuriesClass 3Final reportCessna 180 · Pickens, SCMaintenance personnel’s improper installation of the right main landing gear brake assembly, which resulted in the loss of control during landing.Jun 29, 2019 · N75077 · Substantial damageNTSB ERA19TA211Accident · No injuriesClass 3Final reportCessna 208 · Plant City, FLThe pilot's improper landing flare due to reduced visibility from a foggy windshield and his failure to use the airplane’s windshield defrost system, which resulted in a hard landing and subsequent nose landing gear collapse.Jun 29, 2019 · N80JF · Substantial damageNTSB CEN19LA198Accident · No injuriesClass 3 · LimitedFinal reportVans RV8 · Joplin, MOThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.Jun 29, 2019 · N678LL · Substantial damageNTSB GAA19CA436Accident · No injuriesData collectionFinal reportGrosch Starduster TOO · Lincoln, CAThe pilot's improper landing flare, which resulted in a hard landing, subsequent loss of directional control, runway excursion, and ground-loop.Jun 28, 2019 · N2RG · Substantial damageNTSB GAA19CA375Accident · No injuriesData collectionFinal reportCessna 172 · Phoenix, AZThe student pilot's improper landing flare and failure to maintain the runway heading, which resulted in the loss of airplane control, and the flight instructor's delayed remedial action during a go-around with a crosswind, which resulted in a bounced landing…Jun 28, 2019 · N606JA · Substantial damageNTSB GAA19CA395Accident · No injuriesData collectionFinal reportMaule M5 · Gillette, WYThe pilot's selection of unsuitable terrain for landing, which resulted in a nose-over.Jun 27, 2019 · N6127M · Substantial damageNTSB GAA19CA374Accident · Minor injuriesData collectionFinal reportVans RV 6 · Monument Valley, UTThe pilot's exceedance of the airplane's critical angle of attack during the aborted landing, which resulted in an aerodynamic stall.Jun 27, 2019 · N475AH · Substantial damageNTSB ANC19LA028Accident · No injuriesClass 3 · LimitedFinal reportDe Havilland DHC-2 · Ketchikan, AKA loss of directional control while landing, which resulted in a water loop.Jun 27, 2019 · N94DC · Substantial damageNTSB GAA19CA435Accident · No injuriesData collectionFinal reportPiper PA34 · State College, PAThe pilot's improper landing flare in gusting wind conditions, which resulted in a bounced landing and landing gear collapse.Jun 26, 2019 · N497SA · Substantial damageNTSB GAA19CA383Accident · No injuriesData collectionFinal reportPiper PA28 · Milton, FLThe flight instructor's intentional overapplication of rudder to avoid a ditch during landing with a tailwind, which resulted in a runway excursion and landing gear collapse.Jun 25, 2019 · N5697V · Substantial damageNTSB ERA19LA206Accident · No injuriesClass 3 · LimitedFinal reportBell OH58C · Gainesville, FLThe flight instructor's failure to maintain control of the helicopter during a simulated forced landing autorotation, which resulted in pylon whirl that substantially damaged the helicopter.Jun 25, 2019 · N911GV · Substantial damage