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 FTW02LA031Accident · Serious injuriesLimited investigationFinal reportRaytheon A36 · Crownpoint, NMThe safety pilot's failure to maintain directional control during the landing. Contributing factors were the safety pilot's lack of experience flying from the right seat and the improper retraction of the flaps during the attempted go-around.Nov 7, 2001 · N1099A · Substantial damageNTSB LAX02LA021Accident · No injuriesLimited investigationFinal reportCessna 182S · Palm Springs, CAThe failure of the pilot-in-command to maintain directional control of the airplane after encountering a dust devil during landing roll.Nov 6, 2001 · N2453A · Substantial damageNTSB CHI02LA031Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · New Ulm, MNThe student and flight instructor not using all of the available runway, the inadequate supervision by the flight instructor and the unsuccessful remedial action by the flight instructor. The student not attaining the proper touchdown point and the plowed…Nov 6, 2001 · N523PU · Substantial damageNTSB LAX02FA020Accident · 2 fatalField investigationFinal reportRobinson R-22 Beta · Escondido, CAthe pilot's failure to maintain an adequate clearance from obstacles while approaching to land at his private helipad. Factors in the accident were night conditions, inadequate illumination of the landing pad, and a likely low visibility condition due to fog.Nov 5, 2001 · N7197Y · DestroyedNTSB CHI02LA038Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Hawley, MNthe failure of the pilot to maintain directional control. A factor was the trees.Nov 5, 2001 · N256J · Substantial damageNTSB CHI02LA032Accident · No injuriesLimited investigationFinal reportPiper PA-15 · Decatur, ILThe excessive braking performed by the flight instructor.Nov 5, 2001 · N4576H · Substantial damageNTSB CHI02LA021Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Lambertville, MIThe pilot's improper flare during landing.Nov 5, 2001 · N888BD · Substantial damageNTSB IAD02LA010Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Millbrook, NYpilot's inadvertent activation of the right brake during landing roll-out , which caused the airplane to nose over. A factor was the crosswind.Nov 4, 2001 · N1147B · Substantial damageNTSB NYC02LA031Accident · No injuriesLimited investigationFinal reportMaule M7-260 · North Lima, OHThe pilot's failure to retract the landing gear, which resulted in a wheels down landing on water.Nov 3, 2001 · N5511G · Substantial damageNTSB SEA02LA010Accident · No injuriesLimited investigationFinal reportFetherolf Hatz CB-1 · Ontario, ORAn improper weld in the landing gear, resulting in separation of the right main landing gear wheel during a normal landing.Nov 2, 2001 · N26WF · Substantial damageNTSB NYC02LA023Accident · No injuriesLimited investigationFinal reportBeech 1900C · Bar Harbor, MEA deer, which had been crossing the runway as the airplane touched down. A factor was the dark night conditions.Nov 2, 2001 · N210CJ · Substantial damageNTSB CHI02LA018Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Peoria, ILThe gear collapse for undetermined reasons during the landing roll. A factor was the pilot not using a proper touchdown point by landing long.Nov 2, 2001 · N5984V · Substantial damageNTSB NYC02LA022Accident · No injuriesLimited investigationFinal reportMooney M20S · Buckhannon, WVThe CFI's improper flare, which resulted in a hard landing.Oct 31, 2001 · N1008R · Substantial damageNTSB CHI02LA017Accident · No injuriesLimited investigationFinal reportLuscombe LL-8-E · Bellaire, MIthe unsuitable terrain for landing selected by the pilot. A factor was the soft terrain.Oct 31, 2001 · N1243K · Substantial damageNTSB ATL02LA014Accident · No injuriesLimited investigationFinal reportCessna 152 · Elberton, GAThe student pilot's in-flight decision to land in a field, which resulted in an on-ground collision with a berm. Factors were the student's inadequate training and inadequate supervision by the flight instructor on the ground.Oct 31, 2001 · N93550 · Substantial damageNTSB CHI02LA016Accident · No injuriesLimited investigationFinal reportCessna T210M · Salem, ILThe ruptured hydraulic hose.Oct 30, 2001 · N761UV · Substantial damageNTSB ANC02LA004Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Port Heiden, AKThe pilot's delay in aborting the landing. Factors in the accident were snow and ice on the runway surface, and the pilot's excessive taxi speed.Oct 30, 2001 · N5573J · DestroyedNTSB LAX02LA017Accident · No injuriesLimited investigationFinal reportCessna 172M · Prescott, AZThe CFI's improper remedial action and failure to maintain directional control during landing in a strong crosswind condition.Oct 29, 2001 · N13514 · Substantial damageNTSB FTW02LA025Accident · Serious injuriesLimited investigationFinal reportCameron Balloon A-210 · Albuquerque, NMthe pilot's excessive descent rate during the landing approach, which resulted in a hard landing. Contributing factors were the high wind conditions and the lack of suitable terrain for the landing.Oct 28, 2001 · N30606 · Minor damageNTSB FTW02LA024Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Giddings, TXThe failure of the Cessna pilot to maintain directional control while landing, which resulted in a collision with the Lake.Oct 27, 2001 · N4127G · 2 aircraft · Substantial damageNTSB MIA02LA012Accident · No injuriesLimited investigationFinal reportCessna 152 · Marco Island, FLthe pilot's failure to maintain directional control during the landing roll, which resulted in the airplane departing the runway, impacting with a windsock, and nosing over in soft terrain.Oct 25, 2001 · N93455 · Substantial damageNTSB IAD02LA006Accident · No injuriesLimited investigationFinal reportPiper PA-28-200 · Farmingdale, NJthe flight instructor's delayed remedial action to correct the pilot's lack of directional control during landing. A factor was the crosswind.Oct 25, 2001 · N1585X · Substantial damageNTSB CHI02LA012Accident · No injuriesLimited investigationFinal reportBeech 200 · Osage Beach, MOThe inadequate planning/decision and the exceeded crosswind component by the pilot. The gusts were a contributing factor.Oct 25, 2001 · N200RW · Substantial damageNTSB ATL02LA005Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Lake Wales, FLThe pilot's improper decision to land on a wet sod runway which resulted in a loss of directional control during landing. Factors were the wet grass strip which allowed the airplane to hydroplane.Oct 24, 2001 · N4033W · Substantial damageNTSB LAX02LA014Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Mesa, AZThe pilot's inadequate compensation for an existing crosswind condition, and failure to maintain directional control on the landing rollout.Oct 23, 2001 · N3246G · Substantial damageNTSB NYC02LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Buckhannon, WVThe student pilot's failure to maintain directional control while landing. A factor related to the accident were the gusting wind conditions.Oct 21, 2001 · N5725W · Substantial damageNTSB NYC02LA015Accident · Serious injuriesLimited investigationFinal reportCameron Balloons A-105 · Morgantown, WVThe passengers failure to remain in the balloon basket after landing which resulted in the inadvertent lift-off of the balloon and subsequent injury to the pilot. A factor related to the accident was the pilot's failure to perform a passenger briefing prior…Oct 21, 2001 · N991FA · Minor damageNTSB LAX02LA011Accident · No injuriesLimited investigationFinal reportCessna A185E · Winnemucca, NVThe pilot's inadequate compensation for the wind conditions, failure to maintain directional control and use of excessive braking, which resulted in the airplane nosing over.Oct 21, 2001 · N7711L · Substantial damageNTSB DEN02LA003Accident · No injuriesLimited investigationFinal reportCessna 172N · Provo, UTThe pilot's improper recovery from a bounced landing. Contributing factors were the pilot's lack of total experience in aircraft, and the pilot's lack of recent experience in kind of aircraft.Oct 21, 2001 · N5552E · Substantial damageNTSB IAD02LA011Accident · No injuriesLimited investigationFinal reportCessna 182 · York, PAThe pilot in command's improper recovery from a bounced landing, which resulted in a hard landing and subsequent nose gear failure.Oct 20, 2001 · N7399S · Substantial damageNTSB ATL02LA002Accident · Minor injuriesLimited investigationFinal reportBeech 19 · St Clair Spring, ALThe pilot misjudged the touchdown point that resulted in the runway overrun.Oct 20, 2001 · N1929W · Substantial damageNTSB ATL02LA001Accident · No injuriesLimited investigationFinal reportCessna 172 · Goldsboro, NCThe student pilot's failure to maintain directional control during a touch-and-go landing.Oct 20, 2001 · N46085 · Substantial damageNTSB LAX02FA008Accident · 1 fatalField investigationFinal reportBrock Thorp T-18 · El Mirage, CAthe corrosion and fatigue failure of the tail wheel fork.Oct 19, 2001 · N42KB · Substantial damageNTSB NYC02LA013Accident · No injuriesLimited investigationFinal reportEmbraer 145LR · Roanoke, VAthe captain's failure to maintain airspeed which resulted in an inadvertent stall/mush, and hard landing. Factors were the failure of both pilots to follow company CRM and flight manual procedures, and the captains improper approach briefing.Oct 17, 2001 · N825MJ · Substantial damageNTSB NYC02LA010Accident · No injuriesLimited investigationFinal reportCessna 172L · Northampton, MAThe pilots' failure to maintain airspeed, which resulted in a loss of control and a hard landing.Oct 17, 2001 · N811P · Substantial damageNTSB CHI02LA011Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Ann Arbor, MIThe pilots failure to maintain directional control during the landing. Factors were the gusty crosswind and the terrain drop-off.Oct 17, 2001 · N29461 · Substantial damageNTSB LAX02LA005Accident · Minor injuriesLimited investigationFinal reportAero Commander 690 · Temecula, CAa misrigging of the engine controls that resulted in an asymmetric reverse thrust condition.Oct 14, 2001 · N690JM · Substantial damageNTSB FTW02LA016Accident · No injuriesLimited investigationFinal reportThunder and Colt AX8-90 · Albuquerque, NMthe pilot's failure to maintain clearance with the obstacles during landing. A contributing factor was the gusty winds.Oct 13, 2001 · N407TC · Substantial damageNTSB FTW02LA012Accident · Serious injuriesLimited investigationFinal reportAerostar RXS-8 · Albuquerque, NMthe pilot's failure to maintain clearance with a power line during landing. A contributing factor was the high wind during the landing.Oct 13, 2001 · N5260E · Substantial damageNTSB MIA02LA007Accident · No injuriesLimited investigationFinal reportCessna A150L · Buena Vista, GAThe pilot's failure to use proper bounced landing technique, resulting in a hard touchdown, propeller strike, and noseover.Oct 12, 2001 · N6020J · Substantial damageNTSB IAD02LA004Accident · No injuriesLimited investigationFinal reportCessna 172 · Perkasie, PAThe pilot's improper flare, which resulted in a hard landing. A factor was the sun glare.Oct 12, 2001 · N5385J · Substantial damageNTSB ATL02LA006Accident · No injuriesLimited investigationFinal reportBeech BE-55-T42A · Raleigh, NCThe pilot's improper flare, and improper recovery from a bounced landing.Oct 12, 2001 · N44RA · Substantial damageNTSB NYC02LA007Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Philadelphia, PAThe collapse of the right main landing gear for undetermined reasons.Oct 10, 2001 · N91284 · Substantial damageNTSB FTW02LA013Accident · Serious injuriesLimited investigationFinal reportAerostar International S81A · Albuquerque, NMthe selection of an unsuitable landing area by the pilot. A contributing factor was the high wind during the landing.Oct 10, 2001 · N52760 · Minor damageNTSB MIA02LA005Accident · No injuriesLimited investigationFinal reportCessna 152 · Greenville, NCThe improper flare by the pilot-in-command resulting in a hard landing and subsequent collapse of the nose landing gear due to overload.Oct 8, 2001 · N4768Q · Substantial damageNTSB DEN02LA001Accident · No injuriesLimited investigationFinal reportCessna 172N · Colo Springs, COthe pilot's inadequate landing flare, which resulted in a hard landing. A contributing factor was the pilot's excessive airspeed on final approach.Oct 8, 2001 · N2364E · Substantial damageNTSB FTW02LA011Accident · Serious injuriesLimited investigationFinal reportCameron 105 · Albuquerque, NMTher pilot's delay to compensate for changing weather conditions in-flight. Contributing factors were the high winds and an inaccurate weather forcast.Oct 6, 2001 · N9524U · Minor damageNTSB CHI02LA004Accident · No injuriesLimited investigationFinal reportCessna 172N · Beaver Island, MIThe pilot not maintaining directional control of the airplane during landing. The gusty crosswind and the berm were factors.Oct 6, 2001 · N73630 · Substantial damageNTSB ANC02TA001Accident · No injuriesFinal reportCessna 185F · Bethel, AKThe pilot's inadequate compensation for wind conditions. Factors associated in the accident were a crosswind, and a worn tailwheel steering horn.Oct 6, 2001 · N9344N · Substantial damageNTSB ANC02LA003Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Port Alsworth, AKThe pilot's excessive descent rate and subsequent hard landing during the landing flare/touchdown. A factor in the accident was glassy water conditions.Oct 5, 2001 · N1966U · Substantial damage