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 ANC93LA162Accident · No injuriesLimited investigationFinal reportCessna 172 · Knik Glacier, AKThe pilot's improper inflight planning/decision, and his failure to attain the proper touchdown point. Factors were the rain and the rough/uneven terrain.Aug 22, 1993 · N3817S · Substantial damageNTSB NYC93LA165Accident · No injuriesLimited investigationFinal reportCessna 172 · London, OHThe student pilot's failure to maintain directional control of the airplane after landing, and subsequent departure from the runway and collision with terrain.Aug 21, 1993 · N5653G · Substantial damageNTSB LAX93LA332Accident · No injuriesLimited investigationFinal reportCessna 152 · Glendale, AZThe student pilot's improper flare and recovery from the ensuing bounced landing.Aug 21, 1993 · N6596P · Substantial damageNTSB ANC93LA155Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Jay Creek, AKThe pilot's selection of unsuitable terrain on which to land.Aug 21, 1993 · N6066D · Substantial damageNTSB CHI93LA330Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Point Lookout, MOThe pilot's failure to attain the proper touchdown Point.Aug 19, 1993 · N80349 · Substantial damageNTSB MIA93LA177Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Punta Gorda, FLThe pilot-in-command's improper use of the flight controls (cyclic and collective pitch) during a simulated autorotation with turn, resulting in an in flight collision with terrain with the tail skid and tailrotor blades.Aug 18, 1993 · N95AF · Substantial damageNTSB NYC93FA159Accident · 2 fatalField investigationFinal reportSwearingen SA-226-TC · Hartford, CTFailure of the copilot (second-in-command) to follow the checklist, assure the gear was extended for landing and attain or maintain adequate airspeed (VMC); and failure of the pilot-in-command (PIC) to properly supervise the flight and take sufficient…Aug 17, 1993 · N220KC · DestroyedNTSB MIA93LA181Accident · No injuriesLimited investigationFinal reportGrumman AA-5 · Delray Beach, FLThe pilot-in-command's/flight instructor failure to communicate his intentions with the student pilot to effect a positive transfer of the flight controls, and improper handling of the airplane on landing roll out, resulting in an on ground collision with a…Aug 17, 1993 · N11LT · Substantial damageNTSB DEN93LA104Accident · No injuriesLimited investigationFinal reportCessna 152 · Carr, COFailure of the pilot in command to maintain directional control of the aircraft during landing roll. Factors were the pilot disregarding the tailwind, and rough and uneven terrain off the side of the runway.Aug 17, 1993 · N25379 · Substantial damageNTSB NYC93LA160Accident · No injuriesLimited investigationFinal reportAeronca 7EC · Moneta, VAThe pilot's loss of directional control after landing, resulting in a departure from the runway and a collision with trees.Aug 15, 1993 · N4306C · Substantial damageNTSB DEN93LA102Accident · No injuriesLimited investigationFinal reportCessna 140A · Lake Arthur, NMThe pilot's failure to maintain directional control of the aircraft during landing roll.Aug 15, 1993 · N1142D · Substantial damageNTSB ANC93LA154Accident · No injuriesLimited investigationFinal reportHelio H-295 · Mt. Deborah, AKFailure of the right main landing gear leg due to the improper major repair performed on the gear leg by some unknown maintenance person(s).Aug 15, 1993 · N42DC · Substantial damageNTSB ANC93LA142Accident · No injuriesLimited investigationFinal reportCessna 172 · Black Rapids, AKThe pilot's improper in-flight planning/decision, and his delay in taking remedial action. Factor was the rough, uneven terrain.Aug 13, 1993 · N65626 · Substantial damageNTSB SEA93LA176Accident · No injuriesLimited investigationFinal reportCessna 185C · Stibnite, IDLeakage of hydraulic brake fluid and improper maintenance by the pilot in command. A factor contributing to the accident was inadequate inspection by the mechanic.Aug 12, 1993 · N2690Z · Substantial damageNTSB CHI93LA321Accident · No injuriesLimited investigationFinal reportR.D. Bell/Pietenpol Aircamper · Pontiac, MIThe pilot in command not maintaining a proper descent rate during the final approach and landing flare phase of flight.Aug 12, 1993 · N194BB · Substantial damageNTSB CHI93LA320Accident · Minor injuriesLimited investigationFinal reportBell 47-G5 · Schaumburg, ILthe pilot's improper autorotation techniques.Aug 12, 1993 · N1347X · Substantial damageNTSB NYC93LA152Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Erwinna, PAThe pilot's failure to maintain aircraft control which resulted in a nose over. A rough uneven runway, and the pilot's diverted attention are contributing factors.Aug 11, 1993 · N777DD · Substantial damageNTSB FTW93LA237Accident · No injuriesLimited investigationFinal reportBeech 58 · Little Rock, ARThe inadvertent landing gear retraction by the pilot. A factor was the pilot's negative habit interference.Aug 11, 1993 · N7222V · Substantial damageNTSB SEA93LA173Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Sheridan, WYThe dual student's failure to maintain directional control. A factor contributing to the accident was the instructor's delayed remedial action.Aug 10, 1993 · N116BH · Substantial damageNTSB CHI93LA318Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Minto, NDThe pilot's failure to maintain adequate aircraft control during ground maneuvering. Inadequate visual outlook by the pilot and the pilot of the other aircraft was a contributing factor.Aug 10, 1993 · N8813B · Substantial damageNTSB LAX93LA321Accident · No injuriesLimited investigationFinal reportCessna 170B · Lakeport, CAthe pilot's inadequate compensation for the existing wind conditions and his failure to maintain directional control.Aug 9, 1993 · N2294D · Substantial damageNTSB ANC93LA141Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Bernard Glacier, AKImproper planning/decision by the pilot, concerning the landing at the remote strip, which resulted in a nose over, while using heavy brakes to stop. A factor related to the accident was: the rough/uneven condition of the landing strip.Aug 9, 1993 · N1200A · Substantial damageNTSB NYC93LA148Accident · No injuriesLimited investigationFinal reportCessna 152 · Fryeburg, METhe student pilot's improper recovery from a bounced landing resulting in the collapse of the nose gear and the subsequent nose over. A factor was an improper flare.Aug 8, 1993 · N25211 · Substantial damageNTSB CHI93DEV01Accident · 1 fatalFinal reportWalter D. Courtney Courtney TWO · Canton, ILthe pilot's failure to maintain control of the airplane during final approach to landing.Aug 8, 1993 · N78WC · Substantial damageNTSB ANC93LA139Accident · No injuriesLimited investigationFinal reportCessna 170 · Northway, AKThe pilot-in-command's inadequate compensating for the variable wind conditions.Aug 8, 1993 · N3271A · Substantial damageNTSB ANC93LA138Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKThe inadvertent raising of the flaps.Aug 8, 1993 · N3654C · Substantial damageNTSB ANC93LA137Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Northway, AKThe failure of the pilot to maintain directional control on touchdown. A factor in the accident was the gusty crosswind conditions.Aug 7, 1993 · N4485A · Substantial damageNTSB CHI93LA308Accident · No injuriesLimited investigationFinal reportBeech 19A · Ludington, MIthe pilot's misjudged landing flare.Aug 6, 1993 · N5072T · Substantial damageNTSB ANC93LA135Accident · No injuriesLimited investigationFinal reportLuscombe SL8 · Dillingham, AKThe pilot-in-command's selection of unsuitable terrain for landing. A factor was the soft terrain.Aug 6, 1993 · N2542K · Substantial damageNTSB NYC93LA144Accident · No injuriesLimited investigationFinal reportBeech A55 · Norfolk, VAThe pilot's improper compesnation for wind conditions and failure to maintain firectional control. A factor was adverse wind conditions.Aug 3, 1993 · N30JM · Substantial damageNTSB ATL93LA140Accident · No injuriesLimited investigationFinal reportCessna 172M · Manteo, NCInadequate compensation for wind conditions by the pilot. Factors related to the accident were: the adverse wind and the pilot's failure to obtain a weather briefing (inadequate weather evaluation).Aug 3, 1993 · N80797 · Substantial damageNTSB DEN93LA098Accident · No injuriesLimited investigationFinal reportBoeing 757-222 · Denver, COThe first officer's improper recovery from a bounced landing. Factors were: the first officer's delayed initiation of the flare, and the captain's improper supervision of the flight.Aug 2, 1993 · N508UA · Substantial damageNTSB ANC93LA131Accident · Minor injuriesLimited investigationFinal reportCessna 208 · Kodiak, AKThe pilot in command did not use the airplane checklist. A factor was his diverted attention to other mission related activities.Aug 2, 1993 · N9526F · Substantial damageNTSB NYC93LA143Accident · Serious injuriesLimited investigationFinal reportBalloon Works Fire FLY 7-15 · Milford, NHUnfavorable winds during landing which resulted in a hard landing and one passenger sustaining a broken angle.Aug 1, 1993 · N2574M · No damageNTSB CHI93LA301Accident · 1 fatalLimited investigationFinal reportCessna 180 · Naubinway, MIThe pilot's improper flare for landing. Factors associated with the accident are the low clouds and fog, the rough water at the landing site, and the pilot's continued flight into known adverse weather.Aug 1, 1993 · CFPTU · Substantial damageNTSB ATL93LA141Accident · No injuriesLimited investigationFinal reportCessna 150F · Wilmington, NCA hidden soft spot on the runway that resulted in a nose over of the airplane during a landing roll.Aug 1, 1993 · N6255R · Substantial damageNTSB ANC93LA133Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Soldotna, AKThe pilot's failure to attain a proper touchdown point. A factor was the pilot's improper in flight planning/decision.Aug 1, 1993 · N68578 · Substantial damageNTSB ANC93LA132Accident · No injuriesLimited investigationFinal reportCessna 180 · Sparrevohn, AKThe pilot's failure to maintain directional control of the airplane. A factor was the animal on the runway.Aug 1, 1993 · N3680C · Substantial damageNTSB ANC93LA129Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot's improper planning/decision, while on an approach to land behind another airplane.Aug 1, 1993 · N91219 · Substantial damageNTSB FTW93LA221Accident · No injuriesLimited investigationFinal reportBoeing B75-N1 · Burnet, TXInadvertent groundloop by the pilot.Jul 31, 1993 · N65355 · Substantial damageNTSB CHI93LA307Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Excelsior Spgs, MOthe private pilot's failure to maintain adequate aircraft control during landing.Jul 31, 1993 · N4411V · Substantial damageNTSB MIA93LA166Accident · No injuriesLimited investigationFinal reportCessna 414 · Lake City, FLThe failure of the pilot-in-commmand to properly flare before touchdown and the pilot's decision to land with excessive airspeed. A contributing factor was the aprehension/anxiety of the pilot during the precautionary landing.Jul 30, 1993 · N4232C · Substantial damageNTSB SEA93LA167Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Monroe, WAThe improper inflight decision by the PIC and his failure to attain proper runway alignment. Factors relating to the accident were the dark night light conditions, unavailability of runway lights, and lack of recent night flight time by the PIC.Jul 29, 1993 · N734DL · Substantial damageNTSB LAX93LA304Accident · No injuriesLimited investigationFinal reportCessna 152 · San Carlos, CAThe cfi's inadequate supervision of the flight, the improper recovery from the bounced landing by the crew, and the lack of total experience in giving dual instruction by the CFI. Factors which contributed to this accident were: the dual student's improper…Jul 28, 1993 · N69208 · Substantial damageNTSB CHI93LA293Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Oshkosh, WIThe pilot-in-command's not maintaining directional control. Factors include a crosswind, the pilot-in-command's not attaining compensation for wind conditions, and his lack of experience in this type of airplane.Jul 28, 1993 · N81598 · Substantial damageNTSB CHI93LA290Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Troy, MIIs the pilot not attaining the proper touchdown point, not flying a proper glidepath, and not performing a go around.Jul 28, 1993 · N40023 · Substantial damageNTSB ATL93FA136Accident · Serious injuriesField investigationFinal reportCessna 172M · Harvest, ALThe pilot's poorly planned approach and the failure of the pilot to execute a go-around.Jul 28, 1993 · N13738 · Substantial damageNTSB SEA93LA165Accident · No injuriesLimited investigationFinal reportRiches Avid Flyer · Tooele, UTThe failure of the PIC to maintain directional control and to correct a ground loop/swerve.Jul 27, 1993 · N160VR · Substantial damageNTSB SEA93LA164Accident · No injuriesLimited investigationFinal reportChampion 7EC · Chewelah, WAThe failure of the PIC to maintain directional control and correct for ground loop/swerve.Jul 27, 1993 · N4394C · Substantial damageNTSB DEN93LA087Accident · No injuriesLimited investigationFinal reportAero Commander 100-180 · Wray, COThe pilot's inadequate compensation for the wind conditions and improper recovery from a bounced landing. The gusty crosswind was a factor.Jul 27, 1993 · N3617X · Destroyed