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 WPR16CA022Accident · No injuriesData collectionFinal reportKnox Marion L RV-6A · Lebanon, ORThe pilot's failure to maintain airplane control following an aborted landing which resulted in a collision with trees.Nov 6, 2015 · N259MK · Substantial damageNTSB ERA16LA042Accident · No injuriesLimited investigationFinal reportCessna P210 · Atlanta, GAThe pilot's delayed extension of the landing gear and his failure to ensure that the main landing gear (MLG) were down and locked before touchdown, which resulted in the collapse of both MLG. Contributing to the landing gear collapse was the mis-set landing…Nov 6, 2015 · N731LT · Substantial damageNTSB DCA16WA020Accident · No injuriesForeign investigationBoeing 737 · Lahore, PakistanThe Civil Aviation Authority (CAA) of Pakistan has notified the NTSB of an accident involving a Boeing 737-400, registration AP-BJO, which occurred on November 3, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the CAA investigation…Nov 3, 2015 · AP-BJO · Substantial damageNTSB CEN16LA029Accident · No injuriesLimited investigationFinal reportPiper PA 18-150 · Tecumseh, MIThe pilot's failure to maintain directional control during the landing and his subsequent improper decision to attempt an aborted landing after the airplane had departed the runway.Nov 3, 2015 · N9029Y · Substantial damageNTSB GAA16CA038Accident · No injuriesData collectionFinal reportAeronca 7AC · Auburn, PAThe pilot's use of excessive brake pressure during the landing roll, which resulted in a nose over.Nov 2, 2015 · N84138 · Substantial damageNTSB DCA16WA016Incident · No injuriesForeign investigationBoeing 737 · Nicosia, CyprusThe Accident Investigation Board of Turkey (AAIB) has notified the NTSB of an incident involving a Boeing 737-800, which occurred on November 2, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the…Nov 2, 2015 · TC-CPO · Minor damageNTSB GAA16CA037Accident · No injuriesData collectionFinal reportPiper PA 28-140 · Perry, NYThe student pilot's failure to maintain vigilance, which resulted in a loss of directional control during the landing roll.Oct 31, 2015 · N6665J · Substantial damageNTSB DCA16WA012Accident · No injuriesForeign investigationBoeing 737 · Johannesburg, South AfricaThe government of South Africa has notified the NTSB of an accident involving a Boeing 737-400 airplane that occurred on October 26, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of South Africa's investigation under…Oct 26, 2015 · ZS-OAA · Substantial damageNTSB WPR16LA019Accident · No injuriesLimited investigationFinal reportAmerican Eurocopter AS350B3 · Folsom, CAThe flight instructor's failure to perform simulated engine failure training in accordance with manufacturer guidance, including his improper recovery from the maneuver, which resulted in an overshoot of the intended landing zone when the engine did not…Oct 24, 2015 · N911WL · Substantial damageNTSB WPR16LA017Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Prescott, AZThe pilot's failure to maintain directional control during landing, and his inability to recover due to a malfunction of the tailwheel.Oct 24, 2015 · N25100 · Substantial damageNTSB GAA16CA028Accident · No injuriesData collectionFinal reportMaule M5 · Goodland, KSThe pilot's inadequate crosswind compensation and subsequent loss of directional control during the landing roll, resulting in a runway excursion and nose over.Oct 24, 2015 · N5638K · Substantial damageNTSB ERA16CA024Accident · Minor injuriesData collectionFinal reportMaule M5 · Warrentown, VAThe pilot's failure to maintain clearance of a cattle-guard fence on landing. Contributing to the accident was his lack of recent flying experience.Oct 24, 2015 · N406X · Substantial damageNTSB CEN16LA021Accident · No injuriesLimited investigationFinal reportPiper PA 28-235 · Winneconne, WIAn engine compartment fire during landing, which resulted in extensive fire damage, for reasons that could not be determined during examinations of the remaining wreckage.Oct 24, 2015 · N3979X · Substantial damageNTSB GAA16CA040Accident · No injuriesData collectionFinal reportCessna 182J · Skwentna, AKThe pilot's failure to maintain pitch control during landing, which resulted in a porpoise and structural damage to the airplane.Oct 23, 2015 · N3092F · Substantial damageNTSB GAA16CA030Accident · No injuriesData collectionFinal reportMcpherson John G Pietenpol Aircamper · Placerville, CAThe pilot's loss of directional control during the landing roll, which resulted in a runway excursion and an impact with terrain.Oct 23, 2015 · N169JG · Substantial damageNTSB ENG16WA016Incident · No injuriesForeign investigationBoeing 737 · Cusco, PeruThe Comisión de Investigación de Accidentes de Aviación – CIAA of Peru has notified the NTSB of an incident involving a Peruvian Airlines Boeing 737, which occurred on October 23, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the…Oct 23, 2015 · OB-2040-P · Substantial damageNTSB GAA16CA023Accident · Serious injuriesData collectionFinal reportCessna 140 · Fort Benton, MTA hard landing which resulted in a loss of directional control, main landing gear collapse, and damage to the left wing spar.Oct 20, 2015 · N76001 · Substantial damageNTSB DCA16WA007Incident · No injuriesForeign investigationBoeing 737 · Paderborn, GermanyThe German Federal Bureau of Aircraft Accidents Investigation (BFU) has notified the NTSB of an incident involving a Boeing 737-800, which occurred on October 20, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the BFU investigation…Oct 20, 2015 · TC-SEE · Minor damageNTSB GAA16CA022Accident · No injuriesData collectionFinal reportCessna 180H · Sioux Falls, SDThe pilot's decision to land with a 20 knot direct cross wind, which resulted in a loss of directional control and the right wing impacting terrain and a subsequent ground loop.Oct 19, 2015 · N9780G · Substantial damageNTSB GAA16CA024Accident · No injuriesData collectionFinal reportCessna 120 · McKinney, TXThe pilot's use of excessive brake input during the recovery from the ground loop, which resulted in a nose over.Oct 17, 2015 · N2099V · Substantial damageNTSB GAA16CA025Accident · No injuriesData collectionFinal reportDonham Timothy J RV 6A · Grenada, MSThe pilot's loss of directional control during landing, which resulted in a runway excursion.Oct 16, 2015 · N8188D · Substantial damageNTSB GAA16CA015Accident · No injuriesData collectionFinal reportMaule M 7-260C · Grace, IDThe pilot's selection of unsuitable terrain for landing, which resulted in a nose over.Oct 15, 2015 · N288BC · Substantial damageNTSB GAA16CA017Accident · No injuriesData collectionFinal reportCessna 195A · Aztec, NMThe pilot's failure to maintain directional control during landing, which resulted in runway excursion and collision with terrain.Oct 14, 2015 · N90K · Substantial damageNTSB GAA16CA018Accident · No injuriesData collectionFinal reportFurgason James E Vans RV 4 · San Marcos, TXThe pilot's loss of directional control during the landing roll in crosswind conditions, which resulted in a runway excursion and an impact with an airport sign.Oct 12, 2015 · N165DR · Substantial damageNTSB GAA16CA019Accident · No injuriesData collectionFinal reportMaule M 7-235C · Mankato, MNThe pilot's failure to maintain directional control during the go-around, which resulted in a collision with terrain.Oct 11, 2015 · N3180G · Substantial damageNTSB WPR16LA015Accident · No injuriesLimited investigationFinal reportCessna 310J · Tucson, AZThe insufficient right main landing gear (MLG) down-lock tension due to maintenance personnel's failure to perform a rigging procedure during the airplane's most recent inspection, which resulted in the right MLG collapsing during landing.Oct 10, 2015 · N3123L · Substantial damageNTSB CEN16LA030Accident · Serious injuriesLimited investigationFinal reportAerostar RX8 · Albuquerque, NMThe pilot's delay in deflating the balloon envelope completely after landing, which resulted in a loss of control due to a wind gust.Oct 10, 2015 · N5294Q · No damageNTSB GAA16CA014Accident · Serious injuriesData collectionFinal reportKubicek BB · Albuquerque, NMA hard landing which resulted in serious injury to a passenger.Oct 8, 2015 · N106KB · No damageNTSB WPR16LA004Accident · Serious injuriesLimited investigationFinal reportSilvaire Luscombe 8F · Georgetown, CAThe pilot’s improper recovery from a bounced landing, which resulted in a loss of directional control and subsequent runway excursion.Oct 7, 2015 · N9918C · Substantial damageNTSB GAA16CA008Accident · No injuriesData collectionFinal reportPiper PA · Glennallen, AKThe pilot's failure to maintain clearance from trees during the approach to land, resulting in a collision with trees.Oct 7, 2015 · N7879H · Substantial damageNTSB GAA16CA007Accident · Minor injuriesData collectionFinal reportBogle Absey C Breezy RLU-1 · Bryan, TXThe pilot's excessive descent rate, which resulted in a hard landing and substantial damage.Oct 5, 2015 · N477UC · Substantial damageNTSB GAA16CA010Accident · No injuriesData collectionFinal reportGrosch Starduster TOO SA 30 · Lincoln, CAThe pilot's failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a ground loop, left main landing gear collapse, and the left wing striking the runway.Oct 4, 2015 · N2RG · Substantial damageNTSB WPR16LA003Accident · Serious injuriesLimited investigationFinal reportCessna TU206G · Fall City, WAThe airplane’s collision with the ground short of the runway for reasons that could not be determined based on the available evidence.Oct 3, 2015 · N206HL · Substantial damageNTSB GAA16LA001Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Redding, CAThe pilot’s improper decision to land the airplane on a short runway with a tailwind and his subsequent delayed decision to abort the landing.Oct 3, 2015 · N7837X · Substantial damageNTSB GAA16CA011Accident · No injuriesData collectionFinal reportCessna 172M · McMinnville, ORThe flight instructor's failure to correct the student pilot's approach path during the final approach, which resulted in a collision with runway threshold lights. Contributing to the accident was the student pilot's failure to attain and maintain the…Oct 2, 2015 · N20488 · Substantial damageNTSB GAA16CA004Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Talkeetna, AKThe pilot's excessive brake application during landing, which resulted in a nose-over.Oct 2, 2015 · N8996Y · Substantial damageNTSB GAA15CA286Accident · No injuriesData collectionFinal reportCessna 170A · Springfield, COThe pilot's failure to maintain directional control during the landing flare, which resulted in a collision with terrain, and a nose over.Oct 1, 2015 · N9775A · Substantial damageNTSB GAA15CA291Accident · No injuriesData collectionFinal reportMaule M 7-235C · Kemmerer, WYA hard landing which resulted in a loss directional control and ground loop.Sep 30, 2015 · N4244L · Substantial damageNTSB ERA15LA380Accident · Minor injuriesLimited investigationFinal reportCessna 550 · Sarasota, FLThe pilot’s failure to attain the proper touchdown point and to adequately slow the airplane within the available runway, which resulted in a runway overrun.Sep 27, 2015 · N622PG · Substantial damageNTSB CEN15LA434Accident · Serious injuriesLimited investigationFinal reportLindstrand LBL69A · Albuquerque, NMThe pilot’s failure to maintain a proper descent rate on approach, which resulted in a hard landing and the pilot sustaining a serious injury. Contributing to the accident was the pilot’s lack of recent experience flying a standard-shaped balloon.Sep 27, 2015 · N266LB · No damageNTSB GAA15CA287Accident · No injuriesData collectionFinal reportPiper PA 24 · West Bend, WIThe pilot's failure to maintain his descent rate during the landing, which resulted in a hard landing and runway excursion.Sep 26, 2015 · N8583P · Substantial damageNTSB GAA15CA283Accident · No injuriesData collectionFinal reportStinson HW75 · Bremerton, WAThe pilot's failure to maintain directional control during the landing roll, resulting in the left main landing gear collapse and substantial damage to the left wing strut attachment points.Sep 25, 2015 · N22548 · Substantial damageNTSB GAA15CA285Accident · No injuriesData collectionFinal reportCessna T182T · Ely, NVThe pilot's failure to maintain directional control during landing in gusty crosswind conditions, which resulted in a runway excursion and a collision with an airport sign.Sep 24, 2015 · N5918D · Substantial damageNTSB GAA15CA276Accident · No injuriesData collectionFinal reportPiper PA 28 · Van Nuys, CAThe pilot's failure to compensate for turbulence during the landing flare, which resulted in a hard landing and runway excursion.Sep 24, 2015 · N8258S · Substantial damageNTSB GAA15CA275Accident · No injuriesData collectionFinal reportCessna 180 · McCall, IDThe pilot's excessive application of brake pressure during the landing roll, which resulted in a nose over. Contributing to the accident was the pilot's decision to continue the landing after noting he was high on final approach.Sep 24, 2015 · N4673A · Substantial damageNTSB GAA15CA289Accident · Minor injuriesData collectionFinal reportCessna 195 · Merritt Island, FLThe pilot's excessive braking during the landing roll, resulting in a nose over.Sep 23, 2015 · N3484V · Substantial damageNTSB GAA15CA271Accident · No injuriesData collectionFinal reportCessna 305A · Show Low, AZThe pilot's failure to maintain directional control during landing in quartering tailwind conditions, which resulted in a runway excursion and a right main landing gear collapse.Sep 23, 2015 · N5207G · Substantial damageNTSB GAA15CA280Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · West Palm Beach, FLThe flight instructor's improper use of pitch control during a demonstrated 180 degree autorotation which resulted in damage to the tail boom.Sep 22, 2015 · N44XL · Substantial damageNTSB GAA15CA279Accident · No injuriesData collectionFinal reportBrunzlick Larry R Seawind 3000 Experim · Pelican Lake, WIAbnormal runway contact which precipitated a loss of directional control and impact with water.Sep 22, 2015 · N896CB · Substantial damageNTSB WPR15LA265Accident · Serious injuriesLimited investigationFinal reportAero Commander 680 E · Boise, IDThe pilot's failure to maintain airplane control following an engine problem for reasons that could not be determined because postaccident examination of both engines and the rudder revealed no malfunctions or anomalies that would have precluded normal…Sep 21, 2015 · N222JS · Substantial damage