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 LAX03LA094Accident · No injuriesLimited investigationFinal reportLuscombe T-8F · El Cajon, CAThe pilot's inadequate compensation for the crosswind conditions and loss of directional control during landing.Feb 24, 2003 · N1822B · Substantial damageNTSB NYC03LA054Accident · 1 fatalLimited investigationFinal reportCessna 182P · So. Charleston, WVThe pilot's failure to perform a go-around prior to touchdown. Factors in the accident were the rising terrain and tail wind.Feb 22, 2003 · N21408 · Substantial damageNTSB MIA03FA065Accident · 1 fatalField investigationFinal reportAerofab Lake 250 · Weirsdale, FLThe inadequate flare by the pilot-in-command on the calm water resulting in the in-flight collision with the water and subsequent nose over.Feb 20, 2003 · N811JG · DestroyedNTSB CHI03LA077Accident · No injuriesLimited investigationFinal reportSwearingen SA-26AT · Cahokia, ILThe pilot failed to maintain directional control of the airplane during landing. Factors associated with the accident were the snow covered runway, the crosswind, and the overload failure of the nose gear.Feb 16, 2003 · N30TF · Substantial damageNTSB LAX03LA099Accident · No injuriesLimited investigationFinal reportAerostar International S-71A · Scottsdale, AZthe pilot's inadequate in-flight decision to cross over four sets of power lines with the existence of a known low fuel state and lack of wind, and failure to maintain altitude/clearance from the power lines during the landing, which resulted in the envelope…Feb 15, 2003 · N5285M · Substantial damageNTSB DEN03LA043Accident · No injuriesLimited investigationFinal reportSocata TBM 700 · Aspen, COthe dual student's failure to maintain aircraft control and the inadequate supervision by the flight instructor. Contributing factors include the tailwind and the turbulence.Feb 15, 2003 · N700GJ · Substantial damageNTSB CHI03IA070Incident · No injuriesIncident investigationFinal reportCanadair CRJ-600 · Bloomington, ILThe pilot's improper in-flight decision to land on a runway with a tailwind component that exceeded the airplane's tailwind limitation and his failure to perform a go-around which resulted in the proper touchdown point not being attained and the airplane…Feb 15, 2003 · N653BR · Minor damageNTSB ANC03LA028Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Sitka, AKThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent ground loop, and the collapse of the right main landing gear.Feb 11, 2003 · N71X · Substantial damageNTSB NYC03LA050Accident · No injuriesLimited investigationFinal reportCessna 182R · Warwick, NYThe pilot's inadequate compensation for winds, and his failure to maintain the proper descent rate. A factor in the accident was the gusty wind conditions.Feb 9, 2003 · N3338R · Substantial damageNTSB FTW03LA095Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Lockhart, TXThe pilot's failure to compensate for the existing wind conditions. A contributing factor was the prevailing crosswind.Feb 9, 2003 · N25324 · Substantial damageNTSB SEA03LA036Accident · No injuriesLimited investigationFinal reportCessna 172N · McMinnville, ORThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control during the landing roll. Factors include gusty crosswinds and soft terrain in the area where the aircraft departed the side of the runway.Feb 8, 2003 · N734KU · Substantial damageNTSB LAX03LA086Accident · No injuriesLimited investigationFinal reportBellanca 14-19-2 · Oceano, CAthe pilot's failure to maintain directional control of the airplane.Feb 8, 2003 · N7686B · Substantial damageNTSB SEA03LA032Accident · No injuriesLimited investigationFinal reportCessna 180 B · Klamath Falls, ORFailure to adequately compensate for wind conditions while landing.Feb 2, 2003 · N59180 · Substantial damageNTSB SEA03LA035Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Prosser, WAImproper flare while landing. Factors include rough uneven terrain.Feb 1, 2003 · N75392 · Substantial damageNTSB LAX03LA080Accident · No injuriesLimited investigationFinal reportBeech S-35 · Quartzsite, AZThe driver of the vehicle did not stop prior to crossing the airstrip as directed by airstrip signage.Feb 1, 2003 · N6106V · Substantial damageNTSB ATL03LA039Accident · No injuriesLimited investigationFinal reportRobinson R22 · Fort Lauderdale, FLThe private pilots improper use of flight controls during a run on landing resulting in a roll over.Feb 1, 2003 · N528EE · Substantial damageNTSB ANC03LA025Accident · No injuriesLimited investigationFinal reportCessna 150 · Kenai, AKThe pilot's delayed application of the airplane brakes resulting in an overrun during the landing roll, and subsequent collision with a snowbank. A contributing factor in the accident was icy runway conditions.Feb 1, 2003 · N704JB · Substantial damageNTSB CHI03LA062Accident · No injuriesLimited investigationFinal reportBell 206L-1 · West Plains, MOThe excessive descent rate that required an abrupt flare, resulting in the main rotor severing the tailboom.Jan 31, 2003 · N27AE · Substantial damageNTSB SEA03LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Ellensburg, WAAircraft control was not maintained during the landing roll. A tailwind and a snow bank were factors.Jan 28, 2003 · N48769 · Substantial damageNTSB MIA03CA053Accident · No injuriesData collectionFinal reportCessna 182R · Everglades City, FLstudent pilot's improper use of the brakes at the landing touchdown which caused the left main landing gear tire to burst, resulting in the student and certified flight instructor pilots not being able to maintain control of the airplane, and the subsequent…Jan 26, 2003 · N9973H · Substantial damageNTSB DEN03LA037Accident · Minor injuriesLimited investigationFinal reportRothrock Cozy Mark IV · Erie, COThe pilot's failure to maintain aircraft control during landing. Contributing factors were the high crosswinds and the gusts.Jan 26, 2003 · N320FR · DestroyedNTSB DEN03LA036Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Elbert, COthe pilot's inability to maintain aircraft control resulting in the ground loop. Factors relating to the accident were the crosswinds and the wind gusts.Jan 25, 2003 · N9335K · Substantial damageNTSB LAX03LA085Accident · No injuriesLimited investigationFinal reportMooney M20D · Casa Grande, AZCollapse of the landing gear during landing rollout, resulting from the pilot/mechanic's incorrect landing gear locking mechanism (linkage) adjustment.Jan 24, 2003 · N6639U · Substantial damageNTSB ANC03LA024Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6-200 · Kipnuk, AKThe captain's inadequate compensation for crosswind conditions, and his failure to maintain directional control during the landing roll on an icy runway, which resulted in an excursion from the runway and collision with a snow berm. Contributing factors in…Jan 21, 2003 · N206EH · Substantial damageNTSB LAX03LA071Accident · No injuriesLimited investigationFinal reportTaylorcraft F21 · Payson, AZfailure of the pilot to maintain directional control of the airplane during landing.Jan 18, 2003 · N2005U · Substantial damageNTSB IAD03LA028Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Laconia, NHThe pilot's loss of directional control during landing, which resulted in an impact with a snowbank, and overstress fracture of the nose gear actuator and engine mount foot attachment. A factor in the accident was the icy runway conditions.Jan 18, 2003 · N9170X · Substantial damageNTSB SEA03LA027Accident · No injuriesLimited investigationFinal reportClassic Fighter Industries ME-262 Reproduction · Everett, WAFailure of the left main gear hydraulic actuator locking slide during landing. Factors include an embankment adjacent to the landing runway.Jan 17, 2003 · N262AZ · Substantial damageNTSB LAX03LA068Accident · No injuriesLimited investigationFinal reportCessna 152 · Salinas, CAThe student pilot's inadequate compensation and his failure to maintain directional control. Contributing factors were wet and dirt terrain.Jan 16, 2003 · N25562 · Substantial damageNTSB CHI03LA054Accident · No injuriesLimited investigationFinal reportCessna 150M · Charleston, MOthe inadequate flare by the pilot. Factors were the loose trim tab cable for undetermined reasons.Jan 12, 2003 · N66507 · Substantial damageNTSB MIA03CA041Accident · Serious injuriesData collectionFinal reportCessna 150K · Everglades City, FLThe instructor's failure to maintain airspeed during climb after lift off from an aborted landing, resulting in the airplane stalling, entering a spin, and crashing into water at the departure end of the runway. Contributing to the accident was the…Jan 11, 2003 · N5629G · Substantial damageNTSB ATL03LA035Accident · No injuriesLimited investigationFinal reportAviat Husky · Dayton, TNThe pilot's failure to maintain directional control during landing roll which resulted in a loss of control and collision with a ditch. A factor was separation of the spring clip from the landing gear steering system.Jan 11, 2003 · N415JB · Substantial damageNTSB LAX03LA064Accident · Minor injuriesLimited investigationFinal reportWaco SRE · Prescott, AZThe pilot's failure to maintain directional control during landing resulting in a collision with a runway sign. Factors in the accident were the tailwind and the malfunctioning brake system.Jan 10, 2003 · N1252W · Substantial damageNTSB FTW03LA207Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Roanoke, TXThe failure of the main landing gear assembly and attach points for undetermined reasons.Jan 9, 2003 · N2981R · Substantial damageNTSB FTW03LA079Accident · No injuriesLimited investigationFinal reportCessna 172S · Springdale, ARThe pilot's failure to maintain directional control while landing. A contributing factor was the prevailing crosswind.Jan 8, 2003 · N142ME · Substantial damageNTSB CHI03LA050Accident · No injuriesLimited investigationFinal reportCessna 152 · Traverse City, MIThe student pilot's improper rerecovery from a bounced landing and his improper flare. Factors were the gusting crosswinds, the misjudged flare and the collapse of the nose landing gear.Jan 8, 2003 · N757LE · Substantial damageNTSB NYC03FA035Accident · No injuriesField investigationFinal reportEmbraer ERJ-145LR · Cleveland, OHThe captain's failure to attain a proper touchdown on runway, and his subsequent failure to perform a go-around, both of which resulted in a runway overrun. Factors were the company's inadequate dispatch procedures with their failure to provide all NOTAMS for…Jan 6, 2003 · N16571 · Substantial damageNTSB FTW03LA078Accident · No injuriesLimited investigationFinal reportChampion 7FC · Springdale, ARThe pilot's failure to maintain directional control while landing. A contributing factor was the prevailing crosswind.Jan 4, 2003 · N5271V · Substantial damageNTSB NYC03LA047Accident · No injuriesLimited investigationFinal reportPiper PA-18A 150 · Blairstown, NJThe pilot's failure to maintain directional control during the landing roll.Dec 30, 2002 · N6780B · Substantial damageNTSB LAX03LA055Accident · 1 fatalLimited investigationFinal reportLipscomb Lancair 235 · Payson, AZthe pilot's failure to maintain an adequate airspeed during an aborted landing that resulted in an inadvertent stall/spin. A contributing factor in the accident was the pilot's lack of familiarity with the airplane.Dec 28, 2002 · N777KL · Substantial damageNTSB DEN03LA029Accident · No injuriesLimited investigationFinal reportBeech F33A · Durango, COthe pilot's failure to extend the landing gear. A contributing factor is the pilot's failure to follow the checklist.Dec 28, 2002 · N1592W · Substantial damageNTSB NYC03LA032Accident · No injuriesLimited investigationFinal reportCessna 172S · Akron, OHThe pilot's improper flare which resulted in a hard landing.Dec 26, 2002 · N782SP · Substantial damageNTSB CHI03LA075Accident · No injuriesLimited investigationFinal reportCessna 172S · Tea, SDThe student pilot's improper flare. The pilot's lack of experience and diverted attention were factors.Dec 24, 2002 · N692SP · Substantial damageNTSB FTW03LA074Accident · No injuriesLimited investigationFinal reportCessna 170A · West Helena, ARThe pilot's failure to maintain directional control during landing. A contributing factor was the deflated tire.Dec 22, 2002 · N1392D · Substantial damageNTSB LAX03LA053Accident · No injuriesLimited investigationFinal reportCessna 172N · Pacoima, CAthe student pilot's excessive use of the elevator control that resulted in an inadvertent lift-off and his failure to maintain/attain adequate airspeed, which resulted in a stall and hard landing.Dec 21, 2002 · N733AM · Substantial damageNTSB FTW03LA062Accident · No injuriesLimited investigationFinal reportCessna 195 · Wink, TXThe separation of the main landing gear axle bolt from the landing gear assembly.Dec 20, 2002 · N195SR · Substantial damageNTSB ANC03LA019Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T · Soldotna, AKThe flightcrew's selection of an unsuitable landing area, which resulted in a loss of directional control and an on ground encounter with terrain. A factor associated with the accident was a snow-covered, unplowed runway.Dec 19, 2002 · N55ZP · Substantial damageNTSB SEA03LA018Accident · No injuriesLimited investigationFinal reportHawker Siddeley DH-125 · Seattle, WAThe landing gear down and locked was not verified prior to landing. The checklist was not followed, and an inoperative landing gear warning horn were factors.Dec 17, 2002 · N55RF · Substantial damageNTSB MIA03CA030Accident · No injuriesData collectionFinal reportCessna A150M · Crystal River, FLThe student pilot's improper application of brakes during the landing rollout, which resulted in a loss of directional control and the airplane running off of the runway, impacting a runway light structure, and nosing over.Dec 16, 2002 · N9852J · Substantial damageNTSB LAX03LA050Accident · No injuriesLimited investigationFinal reportAnderson Rotorway Exec 162F · Phoenix, AZThe separation of the exhaust valve stem in the number 1 cylinder, which resulted in a partial loss of engine power during the landing flare and a hard landing.Dec 16, 2002 · N30545 · Substantial damageNTSB FTW03LA063Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Odessa, TXThe pilot's inadvertent failure to extended the landing gear.Dec 13, 2002 · N6068P · Substantial damage