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 CHI01LA132Accident · Minor injuriesLimited investigationFinal reportMaule M-7-235B · Lake City, MIthe improper installation of the left landing gear hydraulic line which allowed it to separate and port the hydraulic fluid. This resulted in the landing gear extending during a water landing.May 5, 2001 · N744LS · Substantial damageNTSB LAX01LA164Accident · No injuriesLimited investigationFinal reportCessna T210N · Truckee, CAThe pilot's failure to maintain the proper descent and his failure to maintain directioinal control during landing.May 4, 2001 · N6425N · Substantial damageNTSB IAD01LA054Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Factoryville, PAThe pilot's failure to reach the proper touchdown point, and his subsequent failure to abort the landing.May 4, 2001 · N434DJ · Substantial damageNTSB ATL01LA051Accident · No injuriesLimited investigationFinal reportCessna 182Q · Ball Ground, GAThe student pilot's failure to maintain directional control during landing roll. A factor is the ditch.May 3, 2001 · N735LX · Substantial damageNTSB ATL01LA050Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Lake Wales, FLThe pilot's improper use of flight controls during a bounced landing, and subsequent collision with the ground. A factor of the collision is the rough and uneven terrain.May 2, 2001 · N1491S · Substantial damageNTSB SEA01TA083Accident · No injuriesFinal reportde Havilland DHC-6-300 · Star, IDFatigue failure of the nose wheel steering cable during the landing roll. Rough/uneven terrain was a factor.May 1, 2001 · N49SJ · Substantial damageNTSB LAX01FA160Accident · 1 fatalField investigationFinal reportBellanca 14-19 · Casa Grande, AZA fuel leak on the cabin and engine sides of the firewall with a probable origin at the firewall pass-through fitting for the fuel pressure gage line. The fire likely began on the engine side of the firewall near the bottom with the explosive ignition of the…May 1, 2001 · N521A · DestroyedNTSB NYC01LA113Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Hodgenville, KYThe pilot's failure to maintain runway alignment during landing. A factor in the accident was the pilot's lack of experience in conducting soft field landings.Apr 29, 2001 · N106ME · Substantial damageNTSB IAD01TA051Accident · Minor injuriesFinal reportHughes 369D · Taylorsville, KYthe flight instructor's inadequate aircraft control during a practice autorotation which resulted in a hard landing.Apr 29, 2001 · N50AP · Substantial damageNTSB FTW01LA123Accident · No injuriesLimited investigationFinal reportCessna 172P · Pleasanton, TXthe student pilot's failure to maintain directional control during the landing flare/touchdown. Contributory factors were the gusty wind and the student pilot's lack of total flight experience.Apr 29, 2001 · N64776 · Substantial damageNTSB NYC01LA111Accident · Minor injuriesLimited investigationFinal reportKnab-Douglas Jurca MJ5 Sirocco · G. Barrington, MAThe pilot's failure to obtain the proper touchdown point, which resulted in an overrun. A factor in this accident was the gusty wind condition.Apr 28, 2001 · N44DK · Substantial damageNTSB IAD01LA052Accident · No injuriesLimited investigationFinal reportPiper J3-C65 · Annapolis, MDpilot's failure to maintain directional control during landing. A factor was the crosswind.Apr 28, 2001 · N26096 · Substantial damageNTSB FTW01FA107Accident · No injuriesField investigationFinal reportPiper PA46-500TP · Rockwall, TXthe loss of directional control during landing roll as a result of insufficient nose gear steering authority.Apr 28, 2001 · N61PK · Substantial damageNTSB MIA01LA137Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Venice, FLThe failure of the pilot to attain the proper touchdown point resulting in a long landing and subsequent collapse of the right main landing gear. Also, failure of the pilot to perform a go-around following a long landing.Apr 27, 2001 · N876BB · Substantial damageNTSB SEA01LA079Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Summer Lake, ORthe pilot's decision to land on a dry lake bed without first taking action to determine the firmness of the surface. Factors include soft terrain at the location the pilot chose to land.Apr 26, 2001 · N126DP · Substantial damageNTSB MIA01IA129Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-8-71F · Nashville, TNThe failure of company maintenance personnel to install the correct hydraulic landing gear extension component, and the failure of company maintenance inspection personnel to comply with proper post maintenance test procedures, resulting in the impossibility…Apr 26, 2001 · N8076U · Minor damageNTSB FTW01LA106Accident · No injuriesLimited investigationFinal reportCessna 172G · N. Little Rock, ARthe pilot's delayed go-around on landing.Apr 26, 2001 · N3860L · Substantial damageNTSB DEN01LA089Accident · No injuriesLimited investigationFinal reportCessna 140A · Greeley, COtotal failure of the right main landing gear spring due to fatigue.Apr 25, 2001 · N666TC · Substantial damageNTSB NYC01LA110Accident · No injuriesLimited investigationFinal reportCessna 172K · Honesdale, PAThe pilot's loss of directional control during the landing roll. A factor was gusting winds.Apr 22, 2001 · N79210 · Substantial damageNTSB LAX01LA155Accident · No injuriesLimited investigationFinal reportCessna 180K · Glendale, AZThe pilot's loss of directional control during the landing roll resulting in a ground loop/swerve and collision with a runway marker sign.Apr 22, 2001 · N66033 · Substantial damageNTSB ANC01LA051Accident · No injuriesLimited investigationFinal reportCessna 150 · Cantwell, AKThe pilot's selection of unsuitable terrain for landing and subsequent nose over during the landing flare. Factors in the accident were soft, snow-covered terrain on the runway.Apr 22, 2001 · N8401J · Substantial damageNTSB ANC01TA049Accident · No injuriesFinal reportPiper PA-18 · King Salmon, AKThe pilot's inadequate compensation for wind conditions, and inadequate weather evaluation resulting in a loss of directional control during the landing roll. Factors in the accident were the presence of a quartering tailwind, and an inadvertent ground loop.Apr 21, 2001 · N745 · Substantial damageNTSB NYC01LA105Accident · No injuriesLimited investigationFinal reportCessna 337F · Quinton, VAThe pilot's improper recovery from a bounced landing. Factors in the accident were the crosswind, and the pilot's lack of experience in make and model.Apr 20, 2001 · N20AK · Substantial damageNTSB CHI01LA121Accident · No injuriesLimited investigationFinal reportCessna 182L · Stromsburg, NEthe inadequate in-flight planning/decision and the flight to a destination alternate not performed by the pilot. Contributing factors were the crosswind and gusts.Apr 20, 2001 · N6412K · Substantial damageNTSB LAX01LA150Accident · No injuriesLimited investigationFinal reportCessna 172P · Torrance, CAThe failure of the pilot-in-command to execute a proper landing flare, which resulted in an improper touchdown attitude and a subsequent loss of directional control. A factor in the accident was the difference between landing characteristics of the Katana and…Apr 19, 2001 · N97984 · Substantial damageNTSB NYC01LA106Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Swanton, OHthe failure of the pilot to verify the landing gear was extended prior to landing, due to diverted attention.Apr 18, 2001 · N2429B · Substantial damageNTSB LAX01LA151Accident · No injuriesLimited investigationFinal reportCessna 152 · Chandler, AZThe pilot's premature flare, which resulted in an inadvertent stall and a bounced landing. A factor was the improper recovery from a bounced landing.Apr 18, 2001 · N5377M · Substantial damageNTSB IAD01LA045Accident · No injuriesLimited investigationFinal reportCessna 182N · Cedarville, NJThe pilot's failure to maintain directional control during the landing flare. A factor was the wind gusts.Apr 18, 2001 · N9174G · Substantial damageNTSB MIA01LA124Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Destin, FLfailure of the flight instructor to maintain directional control of the aircraft during the landing rollout while landing with a crosswind in gusty conditions, which resulted in a ground swerve, and the aircraft exiting the runway and incurring substantial…Apr 17, 2001 · N1364N · Substantial damageNTSB DEN01LA087Accident · No injuriesLimited investigationFinal reportMooney M20K · Bountiful, UTthe failure of the airplane's electrical system for an undetermined reason, which resulted in the collapse of the left main gear on landing.Apr 17, 2001 · N921Z · Substantial damageNTSB CHI01LA118Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Saint Cloud, MNThe inadvertent wheels-up landing by the pilot. A factor was the pilots failure to follow the before landing checklist.Apr 17, 2001 · N7576J · Substantial damageNTSB MIA01LA123Accident · No injuriesLimited investigationFinal reportCessna A185F · Fayetteville, NCThe pilot's failure to maintain directional control of the airplane after encounter wind gusts during landing roll resulting in the airplane ground looping to the left and the right wing, right horizontal stabilizer, and right elevator contacting the runway…Apr 16, 2001 · N252W · Substantial damageNTSB ANC01LA082Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Talkeetna, AKThe instructor pilot's lack of adequate supervision of the training flight, and subsequent loss of directional control during the landing roll out. Factors on the accident were the lack of brake pedals installed on the right pilot position of the airplane,…Apr 16, 2001 · N43143 · Substantial damageNTSB SEA01LA071Accident · No injuriesLimited investigationFinal reportCessna 172 RG · Gig Harbor, WAThe pilot's failure to extend the airplane's landing gear while landing.Apr 14, 2001 · N9551B · Substantial damageNTSB NYC01LA101Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Kent, OHThe flight instructor's inadequate supervision during the landing. Factors were the improper use of the flight controls by the pilot/owner, the crosswind, and the muddy terrain.Apr 14, 2001 · N6359Y · Substantial damageNTSB MIA01LA122Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Dade City, FLthe pilot's inadequate recovery from a bounced landing, and loss of directional control which resulted in an in-flight collision with a fence during the go-around, resulting in a subsequent forced landing in a pasture.Apr 14, 2001 · N81189 · Substantial damageNTSB LAX01LA146Accident · No injuriesLimited investigationFinal reportArthur Lee Beer ALB Special · Santa Rosa, CAThe failure of the pilot to maintain directional control during landing roll.Apr 14, 2001 · N117V · Substantial damageNTSB IAD01LA043Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Painesville, OHThe pilot's failure to maintain the proper descent rate and the flight instructor's inadequate supervision.Apr 14, 2001 · N8081Q · Substantial damageNTSB NYC01LA097Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Hagerstown, MDThe pilot's failure to maintain runway alignment during the landing phase. A factor in the accident was a sudden change in wind direction and speed.Apr 13, 2001 · N55134 · Substantial damageNTSB DEN01LA086Accident · Minor injuriesLimited investigationFinal reportBellanca 1731A · Hobbs, NMthe pilot's failure to maintain directional control during flare/landing.Apr 13, 2001 · N93737 · Substantial damageNTSB MIA01LA118Accident · No injuriesLimited investigationFinal reportCessna 172R · Ormond Beach, FLthe flight instructor's inadequate supervision and the dual student's improper use of brakes which resulted in the loss of directional control and collision with a wind sock. Contributing to the accident was the flight instructor's failure to follow…Apr 9, 2001 · N436ER · Substantial damageNTSB LAX01LA148Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Chino, CAThe pilot's failure to extend the landing gear. A factor was the pilot's failure to use the landing checklist.Apr 9, 2001 · N6240P · Substantial damageNTSB IAD01LA042Accident · No injuriesLimited investigationFinal reportCessna 172R · Lawrence, MAThe pilot's improper flare.Apr 9, 2001 · N2462T · Substantial damageNTSB MIA01LA116Accident · No injuriesLimited investigationFinal reportCessna 170B · Penrose, NCfailure of the pilot to maintain directional control of the aircraft during the landing rollout while landing in a crosswind which resulted in a ground swerve and substantial damage to the aircraft.Apr 8, 2001 · N2488D · Substantial damageNTSB IAD01LA041Accident · Minor injuriesLimited investigationFinal reportBell BH-206-B · Ringgold, VApilot's failure to properly control the helicopter during a slope landing, which resulted in a dynamic rollover.Apr 8, 2001 · N17HA · Substantial damageNTSB MIA01LA112Accident · No injuriesLimited investigationFinal reportCessna 182Q · Lakeland, FLThe pilot's failure to flare on landing resulting in a hard landing.Apr 6, 2001 · N74SM · Substantial damageNTSB NYC01LA093Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Falmouth, MAThe pilot's failure to maintain directional control while landing. Factors were the pilot's inadequate weather evaluation and a tailwind.Apr 5, 2001 · N980C · Substantial damageNTSB IAD01LA040Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Williamsport, PAThe pilot's premature raising of flaps resulting in his failure to establish a climb and his failure to maintain directional control.Apr 5, 2001 · N65630 · Substantial damageNTSB LAX01LA137Accident · No injuriesLimited investigationFinal reportCessna 172S · Long Beach, CAThe student pilot's inadequate compensation for the exisiting crosswind and his improper landing flare that resulted in a hard landing, and loss of directional control during the landing roll.Apr 3, 2001 · N669SP · Substantial damageNTSB LAX01LA135Accident · No injuriesLimited investigationFinal reportCessna 172M · N. Las Vegas, NVThe pilot's inadequate compensation for the existing crosswind condition, and his failure to maintain runway alignment.Apr 1, 2001 · N9572H · Substantial damage