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 MIA93LA040Accident · Serious injuriesLimited investigationFinal reportCuevas, Orlando S. Quicksilver MXL 2 · Guayama, PRThe pilot in command's failure to maintain directional control while making a go around following a bounced landing resulting in a collision with trees.Dec 19, 1992 · N4305C · Substantial damageNTSB NYC93LA049Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Elmira, NYAn unstable touchdown which resulted in a rollover, inadequate supervision by the PIC, and failure of the PIC to take control of the helicopter in a timely manner. A factor related to the accident was the left seat pilot's lack of recent experience in…Dec 18, 1992 · N6129Q · Substantial damageNTSB MIA93LA034Accident · No injuriesLimited investigationFinal reportBeech A36 · Miami, FLThe pilot in command's inadvertent activation of the landing gear switch while attempting to raise wing flaps during landing rollout, resulting in collapse of the landing gear. Contributing to the accident was the pilot in command's diverted attention to the…Dec 18, 1992 · N9066S · Substantial damageNTSB ATL93LA036Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Greensboro, NCThe improper flare by the pilot which resulted in a hard landing and ground loop of the aircraft. A factor in the accident was the crosswind at the time of the landing.Dec 18, 1992 · N8714D · Substantial damageNTSB ATL93LA038Accident · No injuriesLimited investigationFinal reportCessna 152 · Atlanta, GAThe student pilot's failure to maintain directional control of the airplane.Dec 17, 1992 · N65479 · Substantial damageNTSB LAX93LA067Accident · Minor injuriesLimited investigationFinal reportBeech 23-C23 · Oceanside, CAThe pilot's failure to attain the proper touchdown point and to initiate a timely go around when the landing over shoot became apparent.Dec 16, 1992 · N5163M · Substantial damageNTSB SEA93LA037Accident · No injuriesLimited investigationFinal reportMaule M5-180C · Garden Valley, IDInadequate preflight planning and preparation. Factors include the snow covered runway.Dec 13, 1992 · N5652W · Substantial damageNTSB NYC93LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Quaker Street, NYThe failure of the pilot to determine runway conditions prior to landing which resulted in the airplane being damaged upon touchdown on the snow covered runway.Dec 13, 1992 · N46725 · Substantial damageNTSB CHI93LA051Accident · No injuriesLimited investigationFinal reportCessna 172 · La Porte City, IAThe pilot's failure to properly align the airplane with the runway.Dec 12, 1992 · N54959 · Substantial damageNTSB NYC93LA042Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Cheriton, VAThe pilot's improperly planned approach, resulting in a touchdown too FAR down the runway, with excessive airspeed, and the subsequent encounter with soft terrain and nose over.Dec 10, 1992 · N9102W · Substantial damageNTSB FTW93LA049Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Little Rock, ARThe collapsing of the main landing gear as result of a worn gear locking mechanism. A factor was the crosswind.Dec 10, 1992 · N6682V · Substantial damageNTSB NYC93LA038Accident · 1 fatalLimited investigationFinal reportHelio H-700 · Shelton, CTThe pilot's failure to check the position of the landing gear before attempting a water landing.Dec 6, 1992 · N50DV · Substantial damageNTSB NYC93LA037Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Williamson, NYThe pilot failed to provide adequate compensation for the wind conditions. A factor in this accident was the high gusting winds.Dec 6, 1992 · N4946Z · DestroyedNTSB LAX93LA064Accident · No injuriesLimited investigationFinal reportPiper PA-32-301T · Auburn, CAFailure of the pilot to maintain direction control during the landing touchdown. Contributing to the accident inadequate maintenance of the runway safety area by airport personnel.Dec 5, 1992 · N8339X · Substantial damageNTSB CHI93LA048Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Shell Knob, MOThe pilot's misjudging of the landing flare.Dec 5, 1992 · N4152W · DestroyedNTSB LAX93LA061Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Novato, CAFailed to maintain directional control and an inadequate visual lookout. Contributing to this accident were the inoperative runway lights.Dec 4, 1992 · N4338N · Substantial damageNTSB MIA93LA024Accident · No injuriesLimited investigationFinal reportCessna 182B · Aberdeen, NCThe improper in flight decision of the pilot in command to attempt a long landing, downwind on a short wet sod runway. Contributing to the accident was the failure of the pilot in command to execute a go around when observing the wind and landing conditions.Dec 1, 1992 · N2649G · Substantial damageNTSB CHI93LA044Accident · No injuriesLimited investigationFinal reportCessna 150M · Newton, KSThe pilot's improper use of rudder control and subsequent failure to maintain directional control.Dec 1, 1992 · N63294 · Substantial damageNTSB BFO93LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Caldwell, NJInadequate supervision by the instructor, and his delay in initiating a go around.Nov 29, 1992 · N15262 · DestroyedNTSB FTW93LA046Accident · No injuriesLimited investigationFinal reportCessna 152 · New Orleans, LAHard landing due to the pilot's inadequate flare. A factor was the blocked rudder.Nov 28, 1992 · N4948P · Substantial damageNTSB FTW93LA044Accident · Minor injuriesLimited investigationFinal reportPiper PA-12-108 · Vilonia, ARThe pilot's failure to execute a go-around.Nov 28, 1992 · N4405M · DestroyedNTSB SEA93LA030Accident · No injuriesLimited investigationFinal reportHughes 369HS · Scotts Mills, ORThe pilot in command's misjudged descent. Factors include the pilot in command's lack of experience in this type of operation.Nov 27, 1992 · N9228F · Substantial damageNTSB CHI93LA040Accident · No injuriesLimited investigationFinal reportCessna 401B · Rice Lake, WIImproper rigging of the right main landing gear retract bellcrank by other maintenance personnel.Nov 27, 1992 · N7989Q · Substantial damageNTSB BFO93LA011Accident · No injuriesLimited investigationFinal reportCessna 150A · West Milford, NJThe pilot misjudged his altitude and distance and overshot the runway during landing. Contributing to the accident was the pilot's unfamiliarity with this airport.Nov 24, 1992 · N7247X · Substantial damageNTSB MIA93LA023Accident · No injuriesLimited investigationFinal reportCessna 182 · Macon, GAThe pilot in command's failure to stabilize his approach to landing, resulting in the aircraft making a hard landing halfway down the runway.Nov 23, 1992 · N42016 · Substantial damageNTSB BFO93LA012Accident · No injuriesLimited investigationFinal reportLearjet 25B · Cleveland, OHThe pilot misjudged distance and altitude which resulted in a landing touchdown with insufficient runway length remaining and a subsequent landing overrun. Contributing was the pilot's failure to initiate a go around, a tailwind, and a downsloping runway.Nov 22, 1992 · N893WA · Substantial damageNTSB SEA93LA027Accident · No injuriesLimited investigationFinal reportSwearingen SA-226TC · Billings, MTFailure of a gear door roller, which necessitated a gear up landing. Factors include inadequate lubrication.Nov 21, 1992 · N139PA · Substantial damageNTSB LAX93LA049Accident · No injuriesLimited investigationFinal reportMooney M20J · Santa Ana, CAThe pilot's improper landing flare, his improper bounced landing recovery technique, and his inadvertent entry into a stall mush condition.Nov 21, 1992 · N4766H · Substantial damageNTSB MIA93LA020Accident · No injuriesLimited investigationFinal reportCessna 152 · Tallahassee, FLThe pilot in command's improper flare on landing which resulted in an in flight loss of control and collision with terrain.Nov 19, 1992 · N95825 · Substantial damageNTSB FTW93LA040Accident · No injuriesLimited investigationFinal reportBeech B100 · Uvalde, TXThe pilots failure to go around. A factor was his resultant long landing and delayed flare.Nov 19, 1992 · N3GS · Substantial damageNTSB MIA93LA019Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Key Largo, FLThe pilot in command's failure to obtain the proper touchdown point on landing. Contributing to the accident was the pilot in command's improper preflight planning preparation and selection of the wrong runway relative to the wind.Nov 18, 1992 · N5190V · Substantial damageNTSB LAX93LA060Accident · No injuriesLimited investigationFinal reportCessna 180 · Clarksburg, CAThe pilot's improper use of the ailerons.Nov 18, 1992 · N9284C · Substantial damageNTSB BFO93LA013Accident · No injuriesLimited investigationFinal reportCessna 152 · Danville, KYThe student pilot's inadequate flare. A factor was the gusty wind.Nov 18, 1992 · N4840H · Substantial damageNTSB DEN93LA010Accident · No injuriesLimited investigationFinal reportCessna 310Q · Englewood, COUndetermined.Nov 16, 1992 · N999HD · Substantial damageNTSB MIA93LA017Accident · Serious injuriesLimited investigationFinal reportCessna 180K · Wiggins, MSThe pilot in command's failure to maintain directional control on landing roll out, resulting in an on ground loss of control (ground loop) and subsequent nose over.Nov 15, 1992 · N2873K · Substantial damageNTSB BFO93LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Griswold, CTThe pilot's improper planning or decision, by not either using all available runway or making a go around. The wet grass condition of the airstrip was a related factor.Nov 15, 1992 · N4492T · Substantial damageNTSB MIA93LA018Accident · No injuriesLimited investigationFinal reportCessna 172L · Okeechobee, FLThe pilot-in-command's improper flare.Nov 14, 1992 · N9854G · Substantial damageNTSB LAX93LA039Accident · No injuriesLimited investigationFinal reportGlaser-Dirks DG400 · Calistoga, CAThe failure of the brakes due to a separation of the brake cable for undetermined reasons. A factor in the accident was the tailwind condition during the landing rollout.Nov 14, 1992 · N360GG · Substantial damageNTSB CHI93LA032Accident · No injuriesLimited investigationFinal reportCessna 170B · Kankakee, ILThe pilot-in-command not obtaining directional control prior to landing touch down in a crosswind condition.Nov 14, 1992 · N2836C · Substantial damageNTSB SEA93LA022Accident · No injuriesLimited investigationFinal reportCessna 210N · Spokane, WAThe pilot's premature retraction of the gear. Factors include a wet and icy runway.Nov 11, 1992 · N6562Y · Substantial damageNTSB SEA93LA021Accident · No injuriesLimited investigationFinal reportCessna 172M · Olympia, WAThe pilot's poor inflight decision, and excessive airspeed on final. Factors include a wet turf runway, and trees adjacent to the runway.Nov 11, 1992 · N13400 · Substantial damageNTSB LAX93LA035Accident · No injuriesLimited investigationFinal reportCessna 182P · Hawthorne, CAThe pilot's improper use of the brakes. Contributing to this accident was the worn brake pedals.Nov 9, 1992 · N7379S · Substantial damageNTSB LAX93LA034Accident · No injuriesLimited investigationFinal reportCessna 195 · El Cajon, CAThe pilot's improper use of the brakes.Nov 8, 1992 · N3899V · Substantial damageNTSB LAX93FA033Accident · No injuriesField investigationFinal reportSabreliner N-265-60 · Phoenix, AZThe delay of the PIC to apply normal braking and his failure to execute the appropriate emergency procedures. Contributing to this accident was an undetermined antiskid malfunction; the copilot's inexperience in the aircraft; and inadequate crew coordination.Nov 8, 1992 · N169RF · DestroyedNTSB DEN93LA056Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Albuquerque, NMThe pilot's failure to maintain aircraft control and the instructor's inadequate supervision.Nov 8, 1992 · N4069Z · Substantial damageNTSB CHI93LA026Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Cloud, MNThe pilot's failure to maintain directional control.Nov 7, 1992 · N24975 · Substantial damageNTSB ATL93FA021Accident · No injuriesField investigationFinal reportHawker Siddeley DH.125-400A · Nashville, TNThe company mechanic's improper preflight of the aircraft, resulting in a foreign object (flashlight) being left in the nose gear well.Nov 7, 1992 · N125HG · Substantial damageNTSB MIA93IA013Incident · No injuriesIncident investigationFinal reportFairchild F-27 · Titusville, FLThe failure of contract maintenance personnel to comply with written maintenance instructions, resulting in the failure of the nose gear on landing roll.Nov 4, 1992 · N101FG · Minor damageNTSB ANC93LA011Accident · No injuriesLimited investigationFinal reportCessna 150G · Delta Junction, AKThe pilot in command's (CFI) in flight planning/decision to attempt a down wind forced landing in high surface wind conditions and the pilot's improper use of carburetor heat.Nov 3, 1992 · N3144X · Substantial damageNTSB FTW93LA029Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Mcgregor, TXInadvertent stall by the pilot in command. Factors were the pilot's selection of the wrong runway, and the wind conditions.Nov 2, 1992 · N91930 · Substantial damage