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 CHI98LA268Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Indianapolis, INthe delayed in-flight decision of the pilot in command to take control of the aircraft and the proper airspeed not obtained/maintained by the pilot in command which resulted in a stall. A factor to the accident was the runway light.Jul 12, 1998 · N17901 · Substantial damageNTSB IAD98LA114Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Hammonton, NJImproper maintenance, which resulted in an over-pressurized landing gear.Jul 11, 1998 · N49CC · Substantial damageNTSB CHI98LA246Accident · No injuriesLimited investigationFinal reportCessna 182L · Mackinac Island, MIThe pilot's failure to attain a stabilized approach and a touchdown point. The factors contributing to the accident were the pilot in command's improper use of flaps and his not performing a go-around. An additional factor was the pilot in command not using…Jul 10, 1998 · N42184 · Substantial damageNTSB ATL98LA096Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Vero Beach, FLThe pilot's improper flare which resulted in a hard landing.Jul 10, 1998 · N1493H · Substantial damageNTSB SEA98LA129Accident · No injuriesLimited investigationFinal reportCessna 150 · Oregon City, ORThe pilot's improper flare.Jul 7, 1998 · N6417T · Substantial damageNTSB LAX98LA231Accident · No injuriesLimited investigationFinal reportCessna 182RG · Cameron Park, CAThe pilot's decision to initiate a turn to exit the runway at an excessive rate of speed.Jul 7, 1998 · N4825R · Substantial damageNTSB NYC98LA139Accident · No injuriesLimited investigationFinal reportRoss RV6A · Hunter, NYthe pilot's inadequate compensation for wind conditions, and failure to maintain directional control of the airplane. The gusty/variable wind condition was a related factor.Jul 6, 1998 · N67KH · Substantial damageNTSB FTW98LA311Accident · No injuriesLimited investigationFinal reportCessna 172N · Yoakum, TXThe pilot's inadequate compensation for the crosswind resulting in a loss of control. A factor was the crosswind.Jul 6, 1998 · N5103D · Substantial damageNTSB FTW98LA298Accident · No injuriesLimited investigationFinal reportNorth American AT-6G · Longmont, COThe partial failure of the tail wheel steering system due to improper maintenance and the subsequent inadvertent ground loop during the landing sequence. Factors were the airport taxiway sign and the subsequent failure of the left main landing gear.Jul 5, 1998 · N8399H · Substantial damageNTSB FTW98LA341Accident · No injuriesLimited investigationFinal reportCessna T210K · Del Norte, COThe pilot's improper touchdown point for landing. Factors were the high density altitude, the downhill sloping runway, and the ditch off the end of the runway.Jul 4, 1998 · N8132G · Substantial damageNTSB CHI98LA237Accident · No injuriesLimited investigationFinal reportCessna 172M · Chesterfield, MOthe pilot's not obtaining and maintaining directional control. A factor was wet terrain (grass).Jul 4, 1998 · N2XC · Substantial damageNTSB ATL98LA093Accident · Serious injuriesLimited investigationFinal reportLane Progressive Aerodyne Searey · Windermere, FLThe inadequate design of the landing gear switch by the builder which allowed an inadvertent activation of the landing gear switch, leading to a gear extension during a water landing.Jul 4, 1998 · N26RL · Substantial damageNTSB SEA98LA117Accident · Minor injuriesLimited investigationFinal reportCessna 182N · Big Creek, IDDirectional control was not maintained. A wet runway surface was a factor.Jul 3, 1998 · N92519 · Substantial damageNTSB SEA98LA118Accident · No injuriesLimited investigationFinal reportDassault Mystere Falcon 900 · Hamilton, MTPartial failure of the anti-skid brake system due to contamination.Jul 2, 1998 · N900CS · Substantial damageNTSB FTW98LA308Accident · No injuriesLimited investigationFinal reportPiper PA-20-160 · Kemmerer, WYThe pilot's failure to maintain directional control of the airplane, resulting in a ground loop. A factor was the pilot's lack of experience in a conventional landing gear type of airplane.Jul 2, 1998 · N8933D · Substantial damageNTSB CHI98LA234Accident · No injuriesLimited investigationFinal reportAmerican AA-1TW · Point Lookout, MOthe failure of the tailwheel assembly due to corrosion. A factor associated with the accident was the overload failure of the right main landing gear.Jul 1, 1998 · N5643L · Substantial damageNTSB CHI98LA231Accident · No injuriesLimited investigationFinal reportKerr Startduster TOO · Bay City, MIthe pilot's failure to assure the tailwheel tire had adequate pressure which resulted in his inability to maintain directional control of the airplane during a landing. Factors associated with the accident were the inadequate pressure and the uneven terrain…Jul 1, 1998 · N159MK · Substantial damageNTSB ATL98LA089Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Homestead, FLThe pilot's improper flare that resulted in a hard landing and porpoise, and his improper recovery from the bounced landing.Jul 1, 1998 · N4331M · Substantial damageNTSB ANC98LA090Accident · No injuriesLimited investigationFinal reportCessna 206G · Aleknagik, AKThe pilot's failure to attain a proper touchdown point during landing. A factor associated with the accident is the presence of a variable wind condition, and the pilot's decision not to perform a go-around.Jul 1, 1998 · N456TA · Substantial damageNTSB ANC98LA089Accident · No injuriesLimited investigationFinal reportCessna 185E · Iliamna, AKThe pilot's inadequate compensation for crosswind conditions. Factors associated with the accident were a crosswind and the pilot's lack of recent experience in a tailwheel airplane.Jul 1, 1998 · N4574F · Substantial damageNTSB SEA98LA114Accident · No injuriesLimited investigationFinal reportCessna 182P · Chico Hot Spgs., MTThe pilot's inadequate remedial action while attempting to compensate for a change in crosswind velocity. Factors include a crosswind, hills near the runway, and high vegetation (weeds) near the runway.Jun 29, 1998 · N1878M · Substantial damageNTSB LAX98LA217Accident · No injuriesLimited investigationFinal reportAeronca Chief 65-CA · Phoenix, AZThe failure of the pilot to maintain directional control of the aircraft during the landing rollout.Jun 29, 1998 · N34482 · Substantial damageNTSB LAX98LA216Accident · No injuriesLimited investigationFinal reportCessna 180H · Ocotillo Wells, CAFailure of the left main landing gear due to a probable hard landing at an undetermined time.Jun 29, 1998 · N4803E · Substantial damageNTSB CHI98LA228Accident · No injuriesLimited investigationFinal reportCessna 172N · Stone Lake, WIthe lack of effective braking due to hydroplaning. Contributing factors to the accident were the trees off the end of the runway that made a go-around not possible and the ditch off the end of the runway.Jun 29, 1998 · N6596D · Substantial damageNTSB SEA98LA112Accident · No injuriesLimited investigationFinal reportAviat Husky A-1 · Triple R Ranch, MTThe pilot's misjudgment of distance and his failure to initiate a go-around. A factor was the high density altitude.Jun 28, 1998 · N7XJ · Substantial damageNTSB NYC98LA137Accident · No injuriesLimited investigationFinal reportCessna 152 · Pottstown, PAThe student pilot's excessive application of the right brake, resulting in a ground loop.Jun 28, 1998 · N25858 · Substantial damageNTSB LAX98LA215Accident · No injuriesLimited investigationFinal reportZimmerman Kitfox 4-1200 · Fountain Hills, AZThe failure of the pilot to maintain directional control during the landing roll in a crosswind.Jun 27, 1998 · N75MZ · Substantial damageNTSB CHI98LA282Accident · No injuriesLimited investigationFinal reportCessna 310R · Cahokia, ILThe collapse of the left main landing gear during landing roll for undetermined reasons.Jun 27, 1998 · N4249C · Substantial damageNTSB CHI98LA229Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Portland, NDthe pilot's not maintaining directional control. Factors were landing on a roadway and tall grass.Jun 27, 1998 · N6035V · Substantial damageNTSB ANC98LA085Accident · No injuriesLimited investigationFinal reportLockheed L-382G · Huslia, AKThe pilot's failure to maintain proper alignment of the airplane during the landing roll.Jun 26, 1998 · N402LC · Substantial damageNTSB SEA98LA110Accident · No injuriesLimited investigationFinal reportAeronca 7-AC · Thompson Falls, MTThe instructor's inadequate remedial action with the application of excessive brake pressure.Jun 25, 1998 · N82834 · Substantial damageNTSB NYC98LA134Accident · No injuriesLimited investigationFinal reportCessna 172 · Westminster, MDthe pilot's misjudgment of distance and speed during the approach/landing, and his delay in initiating a go-around. The quartering tailwind was a related factor.Jun 24, 1998 · N6640H · Substantial damageNTSB NYC98LA133Accident · No injuriesLimited investigationFinal reportCessna 170B · Oneonta, NYThe separation of the left rudder cable. A factor was chafing of the cable.Jun 24, 1998 · N3493C · DestroyedNTSB ATL98LA085Accident · No injuriesLimited investigationFinal reportStroud SKY Bolt · Mocksville, NCThe pilot's loss of directional control during landing roll when the front seat occupant inadvertently got his foot 'jammed' between the strut bungee and the rudder/brake peddle. A factor was the inadequate design of the rudder/brake peddle system.Jun 23, 1998 · N2951S · Substantial damageNTSB ANC98LA084Accident · Minor injuriesLimited investigationFinal reportBeech A-35 · Skagway, AKThe pilot's inadequate in-flight planning/decision to ensure the rudder pedals were locked in an operable position.Jun 23, 1998 · N575B · Substantial damageNTSB FTW98LA282Accident · No injuriesLimited investigationFinal reportBeech B19 · Frisco, TXThe student pilot's improper landing flare which resulted in a hard larding. Factors were the inadequate supervision of the flight by the flight instructor and the high winds.Jun 21, 1998 · N5110R · Substantial damageNTSB CHI98LA215Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Grays Lake, ILthe pilot's not performing a recovery from a bounced landing and his not maintaining directional control. A factor was soft terrain.Jun 21, 1998 · N99548 · Substantial damageNTSB CHI98LA210Accident · Minor injuriesLimited investigationFinal reportCessna 180A · Bay City, MIa fatigue failure of the left nose gear caster bolt which resulted in a separation of the nose gear during landing.Jun 21, 1998 · N9753B · Substantial damageNTSB ANC98LA080Accident · No injuriesLimited investigationFinal reportCessna 185F · Chitina, AKThe pilot's selection of unsuitable terrain for landing. Factors in the accident were uneven and soft terrain on the landing strip.Jun 21, 1998 · N80596 · Substantial damageNTSB SEA98LA107Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Murphy, IDThe pilot's decision to initiate an aborted landing at an airport where, due to the high density altitude, his aircraft was unable to outclimb the rising terrain that surrounded airport. Factors include a high density altitude and crosswinds.Jun 20, 1998 · N8030P · Substantial damageNTSB NYC98LA198Accident · No injuriesLimited investigationFinal reportCessna CE-500 · Fishers Island, NYAn intermittent short in the right wheel anti-skid system which caused a loss of braking and subsequent overrun.Jun 20, 1998 · N41SH · Substantial damageNTSB LAX98LA206Accident · No injuriesLimited investigationFinal reportCessna 182 · Markleeville, CAThe failure of the pilot to maintain control of the aircraft on the landing roll. A factor is the pilot's neglect to lower the flaps and reduce his speed prior to landing.Jun 20, 1998 · N2772F · Substantial damageNTSB FTW98LA277Accident · No injuriesLimited investigationFinal reportCessna 180 · Albuquerque, NMThe pilot's failure to maintain control of the aircraft during landing roll. A factor was crosswind.Jun 20, 1998 · N3196D · Substantial damageNTSB ANC98LA082Accident · No injuriesLimited investigationFinal reportCessna 185E · Anchorage, AKThe rotation/slippage of the right main tire on the wheel rim, resulting in shearing of the tire tube valve stem, and subsequent tire deflation. Factors in the accident were oversize, tundra tires operated on a dry, asphalt runway surface.Jun 20, 1998 · N85CF · Substantial damageNTSB MIA98LA184Accident · No injuriesLimited investigationFinal reportProgressive Aerodyne Stingray · Lake Tarpon, FLThe pilot's failure to insure that the landing gear was in the up-and-locked position prior to the water landing.Jun 19, 1998 · N6277K · Substantial damageNTSB CHI98LA254Accident · No injuriesLimited investigationFinal reportCessna 172P · Abilene, KSThe student pilot's failure to plan his approach so as to be able to stop the airplane on the runway, and the instructor pilot's delay in taking control of the airplane, so as to correct the student's mistake. A factor contributing to this accident was the…Jun 19, 1998 · N9786L · Substantial damageNTSB LAX98LA205Accident · No injuriesLimited investigationFinal reportOfford KR-2 · San Diego, CAThe pilot's failure to attain/maintain adequate airspeed during an attempted go-around.Jun 18, 1998 · N687RL · Substantial damageNTSB FTW98LA280Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Shreveport, LAThe collapsed nose gear as a result of failure of the nose gear locking mechanism.Jun 18, 1998 · N4038B · Substantial damageNTSB CHI98LA207Accident · No injuriesLimited investigationFinal reportLake LA4-200 · Peshtigo, WIthe pilot misjudged the flare and inadvertently dragged the right sponson in the water. A factor was the pilot's lack of experience in the make and model aircraft.Jun 17, 1998 · N80026 · Substantial damageNTSB CHI98LA206Accident · Minor injuriesLimited investigationFinal reportParker Rotorway 162-F · Manchester, INthe pilot misjudged the flare.Jun 17, 1998 · N311RM · Substantial damage