OpenAirDocs.org

NTSB investigations

53,703 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 LAX06CA297Accident · No injuriesData collectionFinal reportMooney M20J · Temecula, CAThe pilot's failure to flare that resulted in a hard landing.Sep 17, 2006 · N1157N · Substantial damageNTSB SEA06CA192Accident · No injuriesData collectionFinal reportAmorde Glasair II-S RG · Rockford, IDThe pilot's failure to maintain aircraft control during landing. A contributing factor was gusty winds.Sep 16, 2006 · N183TA · Substantial damageNTSB DFW06CA215Accident · No injuriesData collectionFinal reportMaule MT-7 · Ponca, ARThe pilot's improper flare resulting in a hard landing.Sep 15, 2006 · N143RM · Substantial damageNTSB CHI06LA262Accident · No injuriesLimited investigationFinal reportCessna 310P · Kennett, MOSeparation of the left main landing gear torque link during landing resulting in a loss of control and runway excursion. Contributing factors were a failure to comply with the airframe manufacturer's service bulletin, and the pilot's inability to maintain…Sep 14, 2006 · N5858M · Substantial damageNTSB SEA06CA183Accident · No injuriesData collectionFinal reportCessna 305A · Lewistown, MTThe pilot's failure to maintain aircraft control during landing, which resulted in an inadvertent swerve and nose down. A contributing factor was the gusty wind condition.Sep 13, 2006 · N5074H · Substantial damageNTSB SEA06CA181Accident · No injuriesData collectionFinal reportCessna 172M · Moab, UTThe pilot's failure to obtain current NOTAMS which resulted in an on-ground collision with a construction berm while landing.Sep 13, 2006 · N29MX · Substantial damageNTSB DEN06CA127Accident · No injuriesData collectionFinal reportPiper PA-46T-350P · Colo. Springs, COThe pilot's failure to maintain control of the airplane, resulting in an inadvertent stall. Contributing factors in this accident were the jet blast encounter, and the pilot's failure to initiate a go-around when he felt an unsafe condition existed.Sep 13, 2006 · N71DH · Substantial damageNTSB CHI06CA265Accident · No injuriesData collectionFinal reportPiper PA-34-220T · Dayton, OHThe pilot's inadvertent wheels up landing.Sep 13, 2006 · N434TW · Substantial damageNTSB SEA06CA182Accident · No injuriesData collectionFinal reportMaule M-4-180V · Lewistown, MTThe airplane inadvertently impacted a coyote hole during the landing roll on unsuitable terrain.Sep 11, 2006 · N786ST · Substantial damageNTSB ANC06CA132Accident · No injuriesData collectionFinal reportPiper PA-12 · Noatak, AKThe pilot's selection of an unsuitable landing site, which resulted in a loss of control during the landing roll and a nose over. Factors associated with the accident were soft terrain and the pilot's failure to maintain directional control.Sep 11, 2006 · N105JH · Substantial damageNTSB NYC06LA220Accident · Serious injuriesLimited investigationFinal reportFlight Design Ctsw · Tunkhannock, PAThe pilot's improper recovery from a bounced landing.Sep 10, 2006 · N126CT · Substantial damageNTSB CHI06CA259Accident · No injuriesData collectionFinal reportLuscombe 8E · Dodgeville, WIThe pilot encountering unsuitable terrain during the precautionary landing. A factor was the ditch the pilot encountered.Sep 10, 2006 · N2020B · Substantial damageNTSB ANC06CA126Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Fairbanks, AKThe pilot's excessive braking during the landing roll, which resulted in a loss of control and a nose over.Sep 9, 2006 · N3764Z · Substantial damageNTSB SEA06CA177Accident · No injuriesData collectionFinal reportCessna 182RG · Shelton, WAThe pilot's failure to extend the landing gear prior to a practice soft-field landing, and the certified flight instructor's failure to take remedial action. Factors include the pilot's failure to use a checklist.Sep 7, 2006 · N5482T · Substantial damageNTSB DFW06LA209Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Krum, TXThe CFI's and ATP's inflight decision to land halfway down the runway and the ATP's delayed decision to abort the landing. A factor was the ATP's excessive airspeed on final.Sep 7, 2006 · N50340 · Substantial damageNTSB DCA06FA068Accident · No injuriesField investigationFinal reportBoeing B757-232 · San Juan, PRthe first officer's inadvertent application of full nose-up trim during a prolonged flare, resulting in an excessive pitch angle during landing and subsequent tailstrike. Contributing to the accident was the flight crew's failure to correct the airplane's…Sep 5, 2006 · N622DL · Substantial damageNTSB NYC06CA221Accident · No injuriesData collectionFinal reportCessna 172P · Baltimore, MDThe pilot's improper flare, which resulted in a hard landing.Sep 4, 2006 · N65659 · Substantial damageNTSB DEN07CA032Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Riverton, WYthe pilot's failure to maintain directional control during the landing roll, resulting in a ground loop.Sep 3, 2006 · N82236 · Substantial damageNTSB CHI06CA251Accident · No injuriesData collectionFinal reportLuscombe 8A · Elwell, MIThe airplane nosed over as a result of the pilot's excessive braking after he failed to attain the proper touchdown point and failed to perform a go-around.Sep 3, 2006 · N28403 · Substantial damageNTSB CHI06CA252Accident · No injuriesData collectionFinal reportLet Blanik L-13 · Hampshire, ILThe pilot's inadequate approach for landing and his failure to attain a proper descent rate.Sep 2, 2006 · N12YA · Substantial damageNTSB ANC06LA134Accident · No injuriesLimited investigationFinal reportde Havilland DHC-3 · Wainwright, AKThe pilot's failure to adequately compensate for wind conditions during the landing roll, which resulted in a loss of control, and subsequent collision with a ditch when the airplane departed the runway. A factor contributing to the accident was a crosswind.Sep 2, 2006 · N3125N · Substantial damageNTSB NYC06CA217Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · White Lake, NYThe flight instructor's failure to ensure the landing gear was retracted prior to attempting a water landing.Aug 31, 2006 · N6774B · Substantial damageNTSB MIA06IA133Incident · No injuriesIncident investigationFinal reportBoeing 737-400 · Miami, FLThe pilot's inadvertent application of the left brakes at touchdown. Contributing to the incident was insufficient information in the quick reference handbook on the loss of touchdown protection with an inoperative anti-skid system.Aug 31, 2006 · N425US · Minor damageNTSB SEA06LA172Accident · No injuriesLimited investigationFinal reportMooney M20C · Eastsound, WAThe pilot's failure to maintain airspeed during final approach resulting in an inadvertent stall and hard landing.Aug 28, 2006 · N5738Q · Substantial damageNTSB LAX06CA278Accident · No injuriesData collectionFinal reportGlaser Dirks DG 300 · Truckee, CAthe pilot's misjudged landing approach that led to a runway overshoot. A contributing factor was the pilot's hypoxic condition.Aug 28, 2006 · N302N · Substantial damageNTSB SEA06FA168Accident · Minor injuriesField investigationFinal reportAviat A-1B · Owyhee, ORThe pilot inadvertently landing with the parking brake engaged, which resulted in a nose over.Aug 27, 2006 · N94HY · Substantial damageNTSB CHI06LA255Accident · No injuriesLimited investigationFinal reportCessna A185E · Valentine, NEThe pilot's failure to maintain directional control of the airplane during the landing roll, resulting in an inadvertent ground loop by the pilot. A factor contributing to the accident was the gusting crosswind condition.Aug 26, 2006 · N4730Q · Substantial damageNTSB ANC06LA143Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Fairbanks, AKThe fracture of the aluminum alloy landing gear adapter assembly, which resulted in a loss of control during the landing roll.Aug 26, 2006 · N4466T · Substantial damageNTSB DFW06CA202Accident · No injuriesData collectionFinal reportCessna 152 · Gainesville, TXThe pilot's improper recovery from a bounced landing resulting in a porpoise.Aug 25, 2006 · N6102Q · Substantial damageNTSB ANC06LA125Accident · No injuriesLimited investigationFinal reportCessna 206 · Kodiak, AKThe pilot's selection of an unsuitable landing site, which resulted in a rock striking the horizontal stabilizer during the landing roll.Aug 25, 2006 · N800NL · Substantial damageNTSB SEA06CA170Accident · No injuriesData collectionFinal reportPiper PA-22-20-150 · Auburn, WAThe flight instructor's delayed remedial action during the landing roll in response to the student's loss of directional control, which resulted in a ground loop. A factor associated with the accident was the student's failure to maintain directional control.Aug 24, 2006 · N8042D · Substantial damageNTSB NYC06CA210Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · West Milford, NJThe pilot's inadequate compensation for the wind conditions, which resulted in a hard landing. A factor was the wind.Aug 23, 2006 · N4583T · Substantial damageNTSB LAX06CA279Accident · No injuriesData collectionFinal reportCessna T210G · So Lake Tahoe, CAthe pilot's failure to maintain an adequate airspeed and his inadequate remedial actions during a balloon in the landing flare, which resulted in a stall and hard landing.Aug 22, 2006 · N6821R · Substantial damageNTSB DFW06CA203Accident · No injuriesData collectionFinal reportPiper 601P · Lubbock, TXThe pilot's failure to extend the landing gear while on final approach.Aug 22, 2006 · N19RR · Substantial damageNTSB NYC06CA212Accident · No injuriesData collectionFinal reportPiper PA 38-112 · Chesapeake, VAThe presence of deer on the runway during the landing roll, which resulted in a collision. A factor in the accident was the dark night.Aug 21, 2006 · N6401A · Substantial damageNTSB NYC06CA206Accident · No injuriesData collectionFinal reportPiper PA-34-200T · Lincoln Park, NJThe pilot's misjudged distance/speed which resulted in an overrun. A factor in the accident was the soft terrain.Aug 20, 2006 · N19TP · Substantial damageNTSB LAX06LA269Accident · No injuriesLimited investigationFinal reportCessna TR182 · San Carlos, CAThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing roll.Aug 20, 2006 · N2526S · Substantial damageNTSB DFW06CA201Accident · No injuriesData collectionFinal reportCessna T210N · San Angelo, TXThe failure of the landing gear to extend as result of a frayed electrical wire.Aug 20, 2006 · N6602C · Substantial damageNTSB ANC06CA124Accident · No injuriesData collectionFinal reportChampion 7GCBC · Clear, AKThe pilot's failure to maintain clearance from trees during the landing flare, which resulted in an in-flight collision with the trees.Aug 20, 2006 · N1655G · Substantial damageNTSB SEA06LA163Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G-103A · North Plains, ORThe glider pilot's misjudgment of distance/speed during approach, which resulted in excessive speed at touchdown, and his failure to maintain directional control during the landing roll. A contributing factor was the glider pilot's lack of experience in the…Aug 19, 2006 · N103MG · 2 aircraft · Substantial damageNTSB ATL06CA123Accident · No injuriesData collectionFinal reportCessna 172P · Chester, SCThe CFI's failure to initiate a go-around when he noticed the flight was high and fast during the approach resulting in the flight landing long, overrunning the runway, and colliding with trees. Factors in the accident were a tail wind and a wet runway.Aug 19, 2006 · N51887 · Substantial damageNTSB MIA06CA131Accident · No injuriesData collectionFinal reportCessna 182S · Fort Myers, FLThe pilot's failure to maintain control during the landing rollout during gusting wind conditions, which resulted in the airplane veering off the runway.Aug 17, 2006 · N250CS · Substantial damageNTSB LAX06CA263Accident · No injuriesData collectionFinal reportStinson 108-2 · Grass Valley, CAfailure of the pilot to maintain directional control on the landing rollout due to inadequate compensation for a gusty crosswind condition and an attempt to turn at an excessive taxi speed.Aug 17, 2006 · N9818K · Substantial damageNTSB CHI06CA239Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Napoleon, MIThe pilot's failure to maintain a proper glidepath during the landing approach, and his excessive airspeed during the landing which resulted in the overrun. A factor was the fence that the airplane impacted.Aug 16, 2006 · N4008Q · Substantial damageNTSB MIA06CA112Accident · No injuriesData collectionFinal reportCessna 150L · Crystal River, FLThe student pilot's improper recovery from a bounced landing.Aug 14, 2006 · N7255G · Substantial damageNTSB LAX06LA260Accident · No injuriesLimited investigationFinal reportSicheneder Pitts S1S · Tracy, CAThe failure of the pilot to maintain directional control during the landing rollout.Aug 13, 2006 · N22JF · Substantial damageNTSB NYC06CA200Accident · Minor injuriesData collectionFinal reportStinson 108 · Meadville, PAThe owner's failure to install the proper tailwheel spring clips, which resulted in a loss of directional control during the landing roll. A factor was his lack of a mechanic certificate.Aug 11, 2006 · N97541 · Substantial damageNTSB CHI06CA238Accident · No injuriesData collectionFinal reportBoeing B75N1 · Minerva, OHThe pilot's failure to maintain directional control during landing which resulted in the airplane striking a dirt mound and nosing over. The dirt mound was a factor.Aug 11, 2006 · N5165N · Substantial damageNTSB CHI06CA236Accident · No injuriesData collectionFinal reportEnstrom F28C-2 · Independence, OHThe pilot's failure to maintain rotor RPM leading to his failure to maintain control of the helicopter and the hard landing.Aug 11, 2006 · N303MM · Substantial damageNTSB CHI06CA226Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Hillsdale, MIThe pilot's misjudged flare which resulted in the hard landing and his improper recovery from the bounced landing which resulted in the overload failure of the nose landing gear and subsequent nose over. The overload failure of the nose landing gear was a…Aug 10, 2006 · N109CT · Substantial damage