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 ATL05CA132Accident · No injuriesData collectionFinal reportCessna 172P · Savannah, GAThe pilot's failure to maintain directional control on landing roll out resulting in a ground loop, and on ground collision of the right wing with the ground.Jul 18, 2005 · N5299K · Substantial damageNTSB IAD05LA099Accident · Minor injuriesLimited investigationFinal reportCessna 525 · Old Bridge, NJThe pilot's improper preflight planning, his failure to consult performance data, and his failure to obtain the proper touchdown point, which resulted in a runway overrun. Contributing factors to the accident were the excessive airspeed, overweight condition,…Jul 17, 2005 · N13FH · Substantial damageNTSB DEN05LA112Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Grand Junction, COthe pilot's failure to maintain aircraft control during aborted landing and failure to maintain airspeed, which resulted in an inadvertent stall. A contributing factor was the encounter with wind shear during final approach and landing.Jul 17, 2005 · N735AC · DestroyedNTSB ATL05CA166Accident · No injuriesData collectionFinal reportBeech 35 · Carthage, NCThe pilot's excessive braking resulting in a loss of control and subsequent impact with gully. A related factor was the tailwind.Jul 17, 2005 · N49KB · Substantial damageNTSB SEA05LA144Accident · No injuriesLimited investigationFinal reportCessna 180 · Prospect, ORThe pilot's inadequate in-flight decision to perform a wheel landing with a 5 to 10 knot tail wind, and his subsequent loss of aircraft directional control during the landing roll. A tailwind and soft terrain were factors.Jul 16, 2005 · N2944C · Substantial damageNTSB LAX05LA237Accident · No injuriesLimited investigationFinal reportCessna A188B · Bishop, CAthe failure of the tailwheel mount during the landing roll, which resulted in a ground loop.Jul 16, 2005 · N731GE · Substantial damageNTSB LAX05LA236Accident · No injuriesLimited investigationFinal reportSergent Great Lakes 2T1A · Phoenix, AZthe pilot's failure to maintain directional control on landing roll, which resulted in a ground loop and nose over of the airplane.Jul 16, 2005 · N24LR · Substantial damageNTSB CHI05CA187Accident · No injuriesData collectionFinal reportMcDaniels Kitfox Classic IV · Bagley, MNThe pilot's inadvertent lift-off and failure to maintain adequate airspeed while recovering from a loss of directional control during landing. Contributing factors to the accident were the pilot's inadequate wind compensation and failure to maintain aircraft…Jul 16, 2005 · N6261M · Substantial damageNTSB DEN05LA111Accident · Serious injuriesLimited investigationFinal reportGates Learjet 35A · Eagle, COthe pilot's improper flare resulting in the hard landing and the fractured nose gear attachment, and the subsequent loss of control. Factors contributing to the accident were the high airspeed on approach, the pilot's improper in-flight planning/decision, and…Jul 15, 2005 · N620JM · Substantial damageNTSB ATL05CA131Accident · No injuriesData collectionFinal reportCessna 525A · Newnan, GAThe pilot's delay in aborting the landing and his failure to maintain obstacle clearance. Contributing factors were hydroplaning condition, and the localizer antenna.Jul 15, 2005 · N3ST · Substantial damageNTSB ANC05CA102Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Karluk, AKA collision with a deer on the runway during the landing roll, which resulted in substantial damage to the tail of the airplane.Jul 15, 2005 · N8152Z · Substantial damageNTSB SEA05CA142Accident · No injuriesData collectionFinal reportBeech H-35 · Oregon City, ORThe unattended animal on the runway during the landing, which caused the pilot to pull up and land a second time, resulting in an overrun. A factor contributing to the accident was the inability to abort the landing due to obstacles at the end of the runway.Jul 14, 2005 · N5576D · Substantial damageNTSB LAX05CA235Accident · No injuriesData collectionFinal reportCessna T210M · TwentyninePalms, CAthe pilot's failure to verify the current local wind condition that resulted in his selection of the wrong runway and an inadvertent downwind landing, a runway overrun and a ground collision with objects. A factor in the accident was the short runway and its…Jul 14, 2005 · N210NS · Substantial damageNTSB LAX05CA233Accident · Minor injuriesData collectionFinal reportCessna 170B · Prescott, AZthe pilot's misjudged flare, and excessive use of the elevator control, which resulted in a failure to maintain adequate airspeed and a stall/mush.Jul 14, 2005 · N2958D · Substantial damageNTSB DFW05LA180Accident · No injuriesLimited investigationFinal reportBell 430 · Gulf of MexicoThe helicopter's tail rotor blade's contact with an unknown object during landing.Jul 11, 2005 · N430CV · Substantial damageNTSB DEN05LA108Accident · No injuriesLimited investigationFinal reportGrob G103 · Moriarty, NMthe glider pilot's intentional tow release at too low an altitude when he erroneously perceived the tow plane was about to crash. A contributing factor was the unsuitable terrain on which to make a landing.Jul 9, 2005 · N916G · Substantial damageNTSB DEN05CA107Accident · No injuriesData collectionFinal reportTaylorcraft BC12-65 · Roosevelt, UTthe pilot's failure to maintain control of the aircraft during landing. A factor contributing to the accident was the crosswind.Jul 9, 2005 · N36044 · Substantial damageNTSB ANC05CA099Accident · No injuriesData collectionFinal reportCessna 172 · Akiachak, AKThe pilot's delay in aborting the landing, which resulted in the airplane running off the end of the runway and nosing over. A factor associated with the accident was the rough/uneven terrain off the end of the runway.Jul 9, 2005 · N73788 · Substantial damageNTSB SEA05LA141Accident · No injuriesLimited investigationFinal reportCessna 206E · Stuart Island, WAThe pilot's excessive airspeed on final for the current runway surface conditions, and the intentional obstruction avoidance maneuver he executed when it became clear the aircraft was about to go off the end of the runway. Factors include the pilot's improper…Jul 8, 2005 · N9428G · Substantial damageNTSB ANC05CA101Accident · No injuriesData collectionFinal reportHughes 500D · Ambler, AKThe pilot's failure to maintain clearance from an object while landing, which resulted in the main rotor blades striking a tree.Jul 8, 2005 · C-GLHQ · Substantial damageNTSB NYC05LA116Accident · No injuriesLimited investigationFinal reportCessna 421B · Medina, OHAn overload failure of the left main landing gear attachment assembly.Jul 7, 2005 · N318RF · Substantial damageNTSB ATL05CA125Accident · No injuriesData collectionFinal reportCessna 172P · Monroeville, ALThe student pilot's failure to maintain directional control and the subsequent collision with the ground during landing.Jul 7, 2005 · N98530 · Substantial damageNTSB ANC05LA097Accident · No injuriesLimited investigationFinal reportHelio H-250 · Anchorage, AKA fracture failure of the main landing gear leg during the landing roll, which resulted in the collapse of the main landing gear.Jul 7, 2005 · N333TB · Substantial damageNTSB DFW05FA178Accident · 1 fatalField investigationFinal reportPiper PA-34-220T · Norman, OKThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin. A contributing factor was the pilot's attempted aborted landing following a hard landing and propeller strike.Jul 6, 2005 · N902J · DestroyedNTSB ANC05TA106Accident · No injuriesFinal reportCessna 185 · Delta Junction, AKThe pilot's misjudged distance/altitude during the landing touchdown and subsequent undershoot, and his failure to maintain directional control of the airplane during the landing roll, which resulted in an on-ground encounter with high vegetation.Jul 6, 2005 · N8360Q · Substantial damageNTSB MIA05IA132Incident · No injuriesIncident investigationFinal reportPiper PA-34-220T · Titusville, FLThe pilot's continued operation of the airplane with known intermittent deficiencies of the electric pitch trim switch, resulting in a mis-trim condition of the airplane (nose-up), and subsequent hard landing on the nose landing gear causing it to collapse. A…Jul 5, 2005 · N700VR · Minor damageNTSB CHI05CA168Accident · No injuriesData collectionFinal reportPiper PA-32-300 · Minneapolis, MNThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control. Factors associated with the accident were the crosswind and the taxiway sign.Jul 4, 2005 · CGGJB · Substantial damageNTSB CHI05CA165Accident · No injuriesData collectionFinal reportPiper PA-22-180 · Valparaiso, INThe pilot improperly flared the airplane which resulted in a hard landing and the subsequent main gear collapse.Jul 4, 2005 · N5807Z · Substantial damageNTSB ANC05CA091Accident · No injuriesData collectionFinal reportPiper PA-20 · Nome, AKThe pilot's inadequate compensation for wind conditions during the landing roll, which resulted in the collapse of the main landing gear, and a nose over. A factor associated with the accident was a crosswind.Jul 4, 2005 · N7440K · Substantial damageNTSB SEA05LA137Accident · No injuriesLimited investigationFinal reportScheibe SF-28A Tandem-Falke · North Plains, ORThe pilot's failure to maintain airspeed during landing. Inadequate emergency procedures training and high vegetation were factors.Jul 3, 2005 · N12HS · Substantial damageNTSB NYC05CA120Accident · No injuriesData collectionFinal reportPiper PA-34-200T · Allentown, PAThe pilot's improper flare, which resulted in a hard landing.Jul 2, 2005 · N78SF · Substantial damageNTSB MIA05CA128Accident · No injuriesData collectionFinal reportCessna 152 · St. Augustine, FLThe failure of the student pilot to maintain directional control during the landing roll resulting in the on-ground encounter with wet grass and subsequent nose over.Jul 2, 2005 · N89073 · Substantial damageNTSB IAD05LA109Accident · No injuriesLimited investigationFinal reportBeech BE-35-C33A · East Hampton, NYThe pilot's failure to attain the proper touchdown point during landing, which resulted in the airplane touching down short of the landing surface.Jul 2, 2005 · N3YP · Substantial damageNTSB IAD05LA093Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Columbus, OHThe flight instructor's failure to maintain directional control during the landing rollout. A factor was the night lighting conditions.Jul 2, 2005 · N2842D · Substantial damageNTSB CHI05CA169Accident · Minor injuriesData collectionFinal reportKelley Volmer Amphibian B · Nauvoo, ILThe pilot's failure to maintain appropriate airspeed during landing, which resulted in a stall/mush condition and hard landing.Jul 2, 2005 · N47111 · Substantial damageNTSB CHI05CA167Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Palmyra, WILoss of directional control by the dual student and delayed remedial action by the flight instructor resulting in the airplane nosing over.Jul 2, 2005 · N95145 · Substantial damageNTSB ATL05CA124Accident · No injuriesData collectionFinal reportCessna 182P · Lanett, ALThe pilot's misjudgment of speed and distance, and his failure to do a go around. A factor was the wet runway.Jul 2, 2005 · N9133M · Substantial damageNTSB DFW05CA174Accident · No injuriesData collectionFinal reportLearjet 25 · Amarillo, TXThe pilot's failure to maintain directional control during the landing roll. A contributing factor was the prevailing crosswind.Jul 1, 2005 · N345MC · Substantial damageNTSB DEN05LA109Accident · No injuriesLimited investigationFinal reportPiper PA46-500TP · Canon City, COthe pilot's failure to maintain directional control during the landing roll. Contributing factors include the crosswind and windshear conditions.Jul 1, 2005 · N804JH · Substantial damageNTSB ATL05CA123Accident · No injuriesData collectionFinal reportBellanca 7KCAB · Shorter, ALThe pilot's failure to maintain directional control, which resulted in the collapse of the left main landing gear.Jul 1, 2005 · N1029E · Substantial damageNTSB DFW05CA205Accident · No injuriesData collectionFinal reportBeech 35 · Boerne, TXThe airplane's collision with a deer during touchdown. A contributing factor was the prevailing dark night condition.Jun 30, 2005 · N8753A · Substantial damageNTSB LAX05LA220Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Prescott, AZthe pilot's failure to maintain directional control during the landing rollout.Jun 29, 2005 · N8000K · Substantial damageNTSB SEA05CA135Accident · No injuriesData collectionFinal reportCessna 170B · Laurel, MTThe flight instructor's failure to maintain directional control during the landing roll, which resulted in an inadvertent ground loop. A contributing factor was the flight instructor's diverted attention to talking with the student.Jun 28, 2005 · N2619D · Substantial damageNTSB CHI05CA157Accident · Minor injuriesData collectionFinal reportCessna 195 · Peru, ILThe pilot not maintaining directional control during the landing and the ground loop he encountered.Jun 28, 2005 · N355ST · Substantial damageNTSB NYC05CA108Accident · No injuriesData collectionFinal reportMooney M-20J · Toughkenamon, PAThe pilot's failure to maintain directional control during an aborted landing, which resulted in an in-flight collision with trees. A factor was the crosswind.Jun 26, 2005 · N4750H · Substantial damageNTSB NYC05CA107Accident · No injuriesData collectionFinal reportCessna 172L · Tangier, VAThe pilot's failure to maintain directional control during landing.Jun 26, 2005 · N19681 · Substantial damageNTSB IAD05LA087Accident · No injuriesLimited investigationFinal reportCessna 172M · Marysville, OHThe pilot's failure to maintain directional control during landing.Jun 26, 2005 · N80802 · Substantial damageNTSB DEN05CA097Accident · No injuriesData collectionFinal reportRobinson R44 II · Indianola, UTThe pilot's failure to maintain adequate rotor rpm which resulted in a loss of control and a hard landing.Jun 26, 2005 · N373DM · Substantial damageNTSB DEN05CA095Accident · No injuriesData collectionFinal reportVans RV-6A · Trinidad, COthe pilot's inadequate compensation for wind and his inadequate recovery from a bounced landing.Jun 26, 2005 · N8097F · Substantial damageNTSB DEN05CA094Accident · No injuriesData collectionFinal reportSchweizer 269C · Broomfield, COthe pilot's failure to maintain adequate rotor rpm which resulted in a loss of control and an uncontrolled descent.Jun 26, 2005 · N308BP · Substantial damage