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 IAD02LA078Accident · Minor injuriesLimited investigationFinal reportPiper PA 24-250 · Port Clinton, OHThe pilot's improper flare, and his failure to maintain adequate airspeed which resulted in an inadvertent stall.Jul 20, 2002 · N5227P · Substantial damageNTSB NYC02LA143Accident · No injuriesLimited investigationFinal reportBeech 58 · Provincetown, MAThe pilot's failure to initiate a timely go-around, which resulted in his landing the airplane long and fast. Factors included low ceilings and the airplane's initial misalignment with the runway.Jul 19, 2002 · N9280Q · Substantial damageNTSB FTW02LA212Accident · No injuriesLimited investigationFinal reportCessna 190 · Albuquerque, NMThe pilot's failure to maintain aircraft control. A contributing factor was the crosswind.Jul 19, 2002 · N9854A · Substantial damageNTSB DEN02LA077Accident · No injuriesLimited investigationFinal reportCessna 150L · Hurricane, UTpilot's failure to maintain directional control during landing roll, resulting in an inadvertent ground loop.Jul 19, 2002 · N6383H · Substantial damageNTSB CHI02CA202Accident · Minor injuriesData collectionFinal reportEckstein RV-6A · Mattawan, MIFailure by the pilot in command to attain a proper touchdown point considering the available runway length. The rough, uneven runway surface and the soft area at the far end of the runway were contributing factors.Jul 19, 2002 · N747BS · Substantial damageNTSB NYC02LA141Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Dayton, OHThe inadequate visual lookout by the pilot of the Kitfox. Factors related to the accident were the non-radio equipped Waco, and the hazy visual conditions.Jul 17, 2002 · N29988 · 2 aircraft · Substantial damageNTSB CHI02LA204Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Farmington, MOThe locked brake and the aircraft control not being possible due to the locked brake.Jul 17, 2002 · N840B · Substantial damageNTSB LAX02LA233Accident · No injuriesLimited investigationFinal reportBeech S35 · St. Johns, AZThe pilot's failure to maintain airplane control following an encounter with a wind gust.Jul 16, 2002 · N864T · Substantial damageNTSB LAX02LA229Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Grass Valley, CAThe failure of the right main landing gear wheel, which resulted in the pilot's inability to maintain directional control during landing rollout. A factor in the accident was the failure of maintenance personnel to inspect the wheel in accordance with…Jul 16, 2002 · N761HP · Substantial damageNTSB ANC02TA077Accident · No injuriesFinal reportBell 212 · Wasilla, AKThe pilot's selection of an unsuitable landing site, and failure to maintain clearance with trees, which resulted in the main rotor blade striking a tree.Jul 16, 2002 · N5017H · Substantial damageNTSB SEA02LA129Accident · No injuriesLimited investigationFinal reportRockwell International 690A · Crescent Lake, ORThe pilot's failure to maintain proper rate of descent resulting in a hard landing and subsequent nose gear separation. Contributing factors were the turbulent crosswind conditions the pilot encountered just before touchdown.Jul 15, 2002 · N690RE · Substantial damageNTSB NYC02LA145Accident · No injuriesLimited investigationFinal reportCessna 172N · Middletown, RIThe pilot's improper flare. A factor was the shifting wind.Jul 14, 2002 · N733NQ · Substantial damageNTSB ATL02LA142Accident · No injuriesLimited investigationFinal reportBeech BE-76 · Atlanta, GAThe pilot's improper flare which resulted in a hard landing.Jul 14, 2002 · N6630D · Substantial damageNTSB LAX02LA224Accident · No injuriesLimited investigationFinal reportMcConnell Lancair 320 · Sedona, AZthe pilot's inadequate compensation for a right, quartering tailwind during landing resulting in a loss of aircraft control and dragging a wing during the landing flare.Jul 13, 2002 · N320DM · Substantial damageNTSB FTW02CA207Accident · No injuriesData collectionFinal reportGulfstream American AA-5B · Spicewood, TXthe pilot's failure to maintain directional control during landing roll.Jul 13, 2002 · N358RW · Substantial damageNTSB ATL02LA141Accident · No injuriesLimited investigationFinal reportHughes HU-269-A · Hamilton, ALThe pilot's improper use of flight controls that resulted in an improper flare and a hard landing during a practice autorotation. A factor was the loss of rotor rpm.Jul 12, 2002 · N911LH · Substantial damageNTSB ATL02LA140Accident · No injuriesLimited investigationFinal reportCessna 172P · Merritt Island, FLThe pilot's improper recovery after a bounced landing and improper landing flare which resulted in the airplane colliding with the runway.Jul 12, 2002 · N54119 · Substantial damageNTSB ANC02LA076Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Juneau, AKThe pilot's improper flare resulting in a hard landing. Factors contributing to the accident were the quartering tailwind, and the inadvertent water loop.Jul 12, 2002 · N93AK · Substantial damageNTSB NYC02LA134Accident · No injuriesLimited investigationFinal reportCessna 172 · West Milford, NJThe flight instructor's improper recovery from a bounced landing.Jul 11, 2002 · N1502E · Substantial damageNTSB CHI02LA188Accident · Minor injuriesLimited investigationFinal reportCessna 310R · Jackson, MIThe pilot's improper management of the fuel system, including his failure to reposition the fuel selectors to the main fuel tanks prior to landing, as directed in the pilot operating handbook. Additional causes to the accident were the pilot not maintaining…Jul 11, 2002 · N5061J · Substantial damageNTSB SEA02LA127Accident · No injuriesLimited investigationFinal reportBredl Fokker DR1 · Troutdale, ORThe collapse, for undetermined reasons, of the left main landing gear spoked-wheel structure.Jul 10, 2002 · N43SB · Substantial damageNTSB LAX02LA222Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Mesa, AZthe pilot's inadequate compensation for the crosswind conditions, and failure to maintain an appropriate airspeed for the gusts, which resulted in a hard landing.Jul 10, 2002 · N812D · Substantial damageNTSB CHI02CA250Accident · No injuriesData collectionFinal reportPiper PA-J3-C65 · Sparta, ILThe CFI's failure to maintain directional control during landing roll and the unsuccessful attempt at a go around. A factor was the ditch.Jul 9, 2002 · N7744B · Substantial damageNTSB LAX02LA219Accident · Minor injuriesLimited investigationFinal reportMaule M-5-235C · Show Low, AZthe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control.Jul 8, 2002 · N9139E · Substantial damageNTSB FTW02LA203Accident · 1 fatalLimited investigationFinal reportCessna 172B · Denton, TXThe pilot's misjudgment of distance and altitude. Contributing factors were the pilot's diverted attention and the runway localizer antenna.Jul 8, 2002 · N7550X · Substantial damageNTSB MIA02LA130Accident · No injuriesLimited investigationFinal reportBeech B50 · Clanton, ALThe pilot's failure to maintain directional control of the airplane during an aborted landing that resulted in a ground swerve and the airplane exiting the runway and collided with a fence, incurring damage.Jul 7, 2002 · N550G · Substantial damageNTSB LAX02LA217Accident · No injuriesLimited investigationFinal reportAerospatiale AS350 BA · Honolulu, HIthe pilot's failure to maintain adequate tail rotor clearance from the sloping terrain in unfavorable wind conditions.Jul 7, 2002 · N141MK · Substantial damageNTSB IAD02LA069Accident · No injuriesLimited investigationFinal reportCessna 182T · Plainville, CTThe pilot's improper recovery from a bounced landing.Jul 7, 2002 · N3541A · Substantial damageNTSB CHI02CA184Accident · No injuriesData collectionFinal reportPiper PA-34 · Lowell, MIThe probable cause of this accident was a failure to properly compensate for the current wind conditions. Excessive use of brakes was a contributing factor.Jul 7, 2002 · N52WP · Substantial damageNTSB ANC02LA073Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Karluk, AKThe pilot's inadvertent water landing on amphibious floats with the wheels extended, which resulted in the airplane nosing over. A factor associated with the accident was the pilot's diverted attention during departure.Jul 7, 2002 · N35606 · Substantial damageNTSB MIA02LA129Accident · Minor injuriesLimited investigationFinal reportTaylorcraft F21B · Somerville, TNThe pilot's improper landing flare resulting in a hard landing and damage to the airplane.Jul 6, 2002 · N4418F · Substantial damageNTSB SEA02LA122Accident · No injuriesLimited investigationFinal reportHead Balloons AX8-88 · Victor, IDThe pilot's failure to maintain altitude/clearance from the power lines during the landing resulting in the balloon's impacting the wires. Contributing factors were the power lines and strong winds existent at the time.Jul 5, 2002 · N4522E · Substantial damageNTSB NYC02LA137Accident · No injuriesLimited investigationFinal reportCessna 177 · Millville, NJThe pilot's improper bounced landing recovery. A factor was the dark night conditions.Jul 5, 2002 · N29321 · Substantial damageNTSB SEA02LA120Accident · No injuriesLimited investigationFinal reportWelborn Pulsar XP · Prineville, ORThe disconnection of the throttle cable on landing resulting in the aircraft's engine going to full throttle and the pilot's subsequent failure to maintain directional control after securing the engine during the landing event.Jul 4, 2002 · N777XP · Substantial damageNTSB MIA02LA128Accident · No injuriesLimited investigationFinal reportCessna 340A · Bunnell, FLAn improper maintenance inspection of the landing gear system by other maintenance personnel that resulted in a worn/loose over center spring for the right main landing gear being kept in service which caused the right main landing gear not to go over center…Jul 4, 2002 · N15FH · Substantial damageNTSB IAD02LA070Accident · No injuriesLimited investigationFinal reportMooney M20J · Ocean City, NJThe pilot's improper recovery from a bounced landing, and his inadequate compensation for wind. A factor was a wind gust.Jul 4, 2002 · N58166 · Substantial damageNTSB IAD02LA067Accident · No injuriesLimited investigationFinal reportCessna 172 · Fulton, NYThe pilot's improper flare, which resulted in a misaligned, hard landing.Jul 4, 2002 · N6338F · Substantial damageNTSB IAD02LA066Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Providence, RIThe student pilot's failure to maintain directional control during the landing.Jul 4, 2002 · N8081G · Substantial damageNTSB CHI02CA182Accident · No injuriesData collectionFinal reportBeech A-23-23 · Monroe, MIThe pilot misjudging the flare, and his loss of directional control during landing. The soft terrain was a factor.Jul 4, 2002 · N3545R · Substantial damageNTSB SEA02LA118Accident · No injuriesLimited investigationFinal reportCessna 182 E · Sweetgrass, MTThe pilot's failure to adequately compensate for wind conditions after encountering a crosswind gust during the landing roll. Factors include gusty crosswinds, and a fence in the vicinity of the runway.Jul 2, 2002 · N3387Y · Substantial damageNTSB ATL02LA157Accident · No injuriesLimited investigationFinal reportCessna 182M · Brunswick, GAThe pilot's failure to maintain directional control during landing roll, which resulted in an on-ground collision with a runway sign. A factor was the pilot's inadvertent application of the right brake.Jul 2, 2002 · N71785 · Substantial damageNTSB NYC02LA128Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Moneta, VAThe loss of a clip and subsequent loss of the spring on the right side of the tail wheel assembly, for undetermined reasons, which led to a loss of directional control. A factor was the berm.Jul 1, 2002 · N5921H · Substantial damageNTSB NYC02LA127Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · McConnelsville, OHThe pilot's failure to maintain aircraft control while landing. A factor was the pilot's lack of experience.Jun 30, 2002 · N35545 · Substantial damageNTSB DEN02LA072Accident · No injuriesLimited investigationFinal reportMooney M20C · Watkins, COthe pilot's failure to use the pre-landing checklist, resulting in an inadvertent wheels up landing.Jun 30, 2002 · N6283U · Substantial damageNTSB CHI02CA196Accident · No injuriesData collectionFinal reportGrenier Acro Sport · Jacksonville, ILThe probable cause of this accident is a failure of the left main landing gear attachment bolt and the subsequent collapse of the left main landing gear. Repeated hard landings was a factor and a lack of recent experience were contributing factors.Jun 30, 2002 · N1419 · Substantial damageNTSB ANC02LA066Accident · No injuriesLimited investigationFinal reportCessna 207 · Chevak, AKThe pilot's failure to attain the proper touchdown point resulting in an undershoot, and subsequent collision with gravel terrain.Jun 30, 2002 · N7384U · Substantial damageNTSB ANC02LA065Accident · No injuriesLimited investigationFinal reportCessna 185 · Skwentna, AKThe pilot's failure to attain the proper touchdown point resulting in an undershoot, and an in-flight collision with a log during the landing flare. A contributing factor in the accident was a hidden obstruction.Jun 30, 2002 · N1078F · Substantial damageNTSB SEA02LA114Accident · Minor injuriesLimited investigationFinal reportHunter Comp Air 6 · McCall, IDThe pilot's inadequate compensation for wind conditions. Contributing factors were a 30 degree crosswind and the pilot's lack of experience in the newly acquired make/model aircraft.Jun 28, 2002 · N6008N · Substantial damageNTSB MIA02LA145Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Dyer, TNThe failure of the pilot to maintain wingtip clearance with corn crops at the edge of the road resulting in the collision with the crops.Jun 28, 2002 · N73088 · Substantial damageNTSB ATL02IA138Incident · No injuriesIncident investigationFinal reportBeech 58 · Nashville, TNCollapse of the main landing gear for undetermined reasons.Jun 28, 2002 · N9098Q · Minor damage