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 MIA94LA082Accident · No injuriesLimited investigationFinal reportCessna 190 · Fort Lauderdale, FLLocking of the right main landing gear brake for undetermined reasons.Mar 4, 1994 · N190RC · Substantial damageNTSB LAX94LA154Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Prescott, AZThe student pilot's delayed flare and failure to maintain directional control of the aircraft, and the flight instructor's inadequate supervision of the flight.Mar 4, 1994 · N487ER · Substantial damageNTSB LAX94LA151Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Concord, CAThe pilot's failure to maintain directional control during a touch-and-go landing. A factor in the accident was the pilot's limited expereince in tailwheel aircraft.Mar 4, 1994 · N5038M · Substantial damageNTSB LAX94LA150Accident · No injuriesLimited investigationFinal reportRobinson R22B · Long Beach, CAthe student pilot's improper use of the collective and tail rotor controls, and the flight instructor's inadequate supervision of the flight.Mar 4, 1994 · N2327C · Substantial damageNTSB SEA94LA070Accident · No injuriesLimited investigationFinal reportCessna 172 · Casper, WYThe pilot's failure to maintain proper alignment with the runway. The crosswind was of factor.Mar 2, 1994 · N733WS · Substantial damageNTSB LAX94LA146Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Merced, CAthe pilot's misjudgement of the descent rate and his delayed throttle application.Mar 2, 1994 · N9593F · Substantial damageNTSB SEA94LA068Accident · No injuriesLimited investigationFinal reportCessna 172 · Gillette, WYWas the pilot's inadequate remedial action. Factors include an inadvertent porpoise, and a lack of total experience.Feb 27, 1994 · N21840 · Substantial damageNTSB LAX94LA140Accident · No injuriesLimited investigationFinal reportCessna 150 · Chandler, AZThe pilot's intentional swerve to avoid a large bird that flew toward the airplane during the landing roll.Feb 27, 1994 · N10669 · Substantial damageNTSB LAX94LA139Accident · No injuriesLimited investigationFinal reportBell 206B · Agua Dulce, CAThe cfi's selection of unsuitable terrain to demonstrate a simulated autorotation. The soft terrain was a factor in this accident.Feb 27, 1994 · N50PE · Substantial damageNTSB CHI94LA099Accident · No injuriesLimited investigationFinal reportCessna 172RG · Frankfort, MIThe failure of the pilot-in-command to maintain directional control. The snow covered runway was a factor.Feb 27, 1994 · N4871V · Substantial damageNTSB ANC94LA035Accident · No injuriesLimited investigationFinal reportCessna 402 · Kivalina, AKThe pilot's inadequate compensation for the wind conditions by landing on the left side of the runway. Factors were: inadequate snow removal and the snow covered runway.Feb 27, 1994 · N681RC · Substantial damageNTSB FTW94LA087Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Almyra, ARThe partial failure of the brake master cylinder assembly for undetermined reasons. A factor was the soft terrain adjacent to the runway.Feb 26, 1994 · N730Y · Substantial damageNTSB CHI94LA094Accident · No injuriesLimited investigationFinal reportCessna 172 · Concordia, KSthe flight instructor's inadequate remedial action when the student pilot failed to maintain adequate directional control of the airplane during the landing roll. A related factor is the drifted snow.Feb 26, 1994 · N7924G · Substantial damageNTSB LAX94LA137Accident · Minor injuriesLimited investigationFinal reportWaco YMF-5 · Carlsbad, CAThe pilot's failure to follow the correct procedures when he released the parking brake. The inadvertently engaged parking brake and the outdated flight manual were factors in this accident.Feb 24, 1994 · N50YM · Substantial damageNTSB BFO94LA050Accident · No injuriesLimited investigationFinal reportBeech 400 · Cleveland, OHThe pilots failure to use the proper radio frequency to activate the airport runway lights, and the pilot's improper decision to continue his approach and land without the runway lights being on.Feb 24, 1994 · N8279G · Substantial damageNTSB FTW94LA085Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Eagle Lake, TXThe pilot's failure to maintain directional control of the airplane during the landing roll.Feb 23, 1994 · N48819 · DestroyedNTSB BFO94LA047Accident · No injuriesLimited investigationFinal reportCessna 172M · Slatington, PAThe pilot's inadequate compensation for wind conditions and failure to maintain alignment with the runway. The crosswind was a factor.Feb 22, 1994 · N5272R · Substantial damageNTSB LAX94LA131Accident · No injuriesLimited investigationFinal reportPiper J5A-L4F · Kernville, CAthe pilot's improper use of the flight controls resulting in his failure to maintain directional control. The existing crosswind is a factor in this accident.Feb 21, 1994 · N33029 · Substantial damageNTSB LAX94LA129Accident · Serious injuriesLimited investigationFinal reportPiper PA-31-350 · Phoenix, AZThe loose main fuel line 'b' nut due to the improper installation of the right engine by company maintenance personnel.Feb 21, 1994 · N4109D · Minor damageNTSB BFO94LA045Accident · Minor injuriesLimited investigationFinal reportPiper PA-31T · Norwood, MAThe pilot's failure to attain alignment with the centerline of the runway, and his failure to execute a missed approach. Factors which contributed to the accident were: the dark night, the pilot's improper decision to initiate the approach in below-minimum…Feb 21, 1994 · N777JM · Substantial damageNTSB LAX94LA127Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Las Vegas, NVThe cfi's improper remedial action by failing to go-around instead of landing, the cfi's excessive touchdown speed, and his failure to obtain the proper touchdown point. The dual student's initial excessive airspeed and the ditch were factors in this accident.Feb 19, 1994 · N303AT · Substantial damageNTSB CHI94LA092Accident · No injuriesLimited investigationFinal reportCessna 170B · Waupaca, WIThe failure of the pilot to maintain directional control. A factor related to the accident was the gusty crosswind.Feb 19, 1994 · N4685C · Substantial damageNTSB MIA94LA076Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Gulf Of MexicoThe pilot's physiological condition (failure to remain awake) resulting in extended flight over water followed by fuel exhaustion, total loss of engine power, and ditching before returning to land.Feb 17, 1994 · N1247T · DestroyedNTSB MIA94LA074Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Culebra, PRThe failure of the pilot-in-command(CFI) to initiate a go-around after encountering severe turbulence during landing flare and his decision to raise the flaps and reduce engine power to idle after directional control was lost resulting in the aircraft…Feb 16, 1994 · N79401 · Substantial damageNTSB LAX94LA126Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Barstow, CAthe pilot's misjudgment of the landing flare altitude during a night autorotation while preoccupied with maintaining proper main rotor rpm. A factor in the accident was the pilot's visual perception which was affected by the outside ambient lighting…Feb 15, 1994 · N1077N · DestroyedNTSB CHI94LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Sandwich, ILthe private pilot's failure to maintain directional control of the airplane while landing on a snow and ice covered runway. Factors are the snow on the runway and the snowbank.Feb 14, 1994 · N76SA · Substantial damageNTSB CHI94LA087Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Grand Forks, NDthe improper maintenance installation (cotter pin) by other maintenance personnel. Factors were main landing gear scissors not safetied properly and extension of landing gear not possible by pilot-in-command (CFI).Feb 13, 1994 · N190ND · Substantial damageNTSB LAX94LA123Accident · Minor injuriesLimited investigationFinal reportCessna 172K · New Cuyama, CAthe pilot's inadequate compensation for the existing wind conditions and his failure to maintain directional control of the aircraft.Feb 12, 1994 · N7333G · Substantial damageNTSB LAX94LA120Accident · No injuriesLimited investigationFinal reportCessna A185F · Valley Springs, CAthe pilot's failure to ensure that the landing gear was in the correct configuration for a water landing.Feb 10, 1994 · N4833C · Substantial damageNTSB CHI94IA081Incident · No injuriesIncident investigationFinal reportBoeing 737-130 · Chicago, ILAn inadequate procedure for handling of wheel chocks by company maintenance and operations personnel. Factors associated with this accident were an inadequate inspection of the airplane by company maintenance personnel, and an inadequate pre-flight inspection…Feb 10, 1994 · N408PE · Minor damageNTSB ANC94LA033Accident · No injuriesLimited investigationFinal reportCessna 180A · Anchorage, AKThe failure of the pilot-in-command to maintain directional control of the airplane during the landing rollout. Contributing to the accident was the pilot's lack of recent experience in the airplane.Feb 10, 1994 · N288LS · Substantial damageNTSB SEA94LA058Accident · No injuriesLimited investigationFinal reportCessna 402C · Billings, MTThe nose gear actuator froze. A factor to the accident was temperature extremes.Feb 7, 1994 · N2718Y · Substantial damageNTSB LAX94LA135Accident · No injuriesLimited investigationFinal reportCessna 340A · Dunsmuir, CAThe mechanics improper maintenance of the airplane's left brake system by failing to service its hydraulic reservoir. The lack of hydraulic fluid in the left brake reservoir which precipitated the left brake failure is a factor in this accident.Feb 7, 1994 · N1362C · Substantial damageNTSB CHI94LA083Accident · No injuriesLimited investigationFinal reportCessna 152 · Sebewaing, MIwas the pilot-in-command's failure to maintain directional control. Factors were the icy runway and a snowbank.Feb 7, 1994 · N94269 · Substantial damageNTSB CHI94LA077Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Wichita, KSThe pilot's failure to attain the proper touchdown point and delay in aborting the landing. The pilot's inadequate training was a factor.Feb 6, 1994 · N8119W · Substantial damageNTSB LAX94LA113Accident · No injuriesLimited investigationFinal reportCessna 175 · Oakdale, CAthe pilot's failure to maintain an adequate visual lookout, and his failure to adequately communicate his postion and intentions on the Common Traffic Advisory Frequency. A factor in the accident was the pilot's misidentification of the Cessna aircraft he was…Feb 5, 1994 · N7597M · 2 aircraft · Substantial damageNTSB CHI94LA078Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Delavan, WIthe pilot-in-command's not maintaining directional control and his inadequate compensation for wind conditions. Factors were icy runway and crosswind.Feb 5, 1994 · N38203 · Substantial damageNTSB FTW94LA078Accident · No injuriesLimited investigationFinal reportCessna 182P · Meeker, COFailure by the pilot to maintain directional control of the aircraft during landing roll.Feb 1, 1994 · N111RR · Substantial damageNTSB LAX94LA110Accident · No injuriesLimited investigationFinal reportCessna 140 · Palo Alto, CAThe cfi's inproper supervision of the flight, the dual student's improper recovery from a bounced landing, and the dual student's improper use of the brakes. The cfi's lack of total instructional experience is a factor in this accident.Jan 31, 1994 · N2396V · Substantial damageNTSB LAX94LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Lovelock, NVThat the pilot's failure to maintain adequate airspeed while on final approach which resulted in an inadvertent stall during the flare.Jan 29, 1994 · N8760W · Substantial damageNTSB BFO94LA036Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Newburyport, MAThe pilot not maintaining clearance from the snowbank during final approach. A factor in this accident was the proximity of the snowbank to the active runway.Jan 29, 1994 · N2496X · Substantial damageNTSB LAX94LA107Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-301 · Truckee, CAThe pilot's failure to maintain directional control, delay in his remedial action, and failure to raise the flaps. The snow covered runway was a factor in this accident.Jan 28, 1994 · N82009 · Substantial damageNTSB ATL94LA044Accident · No injuriesLimited investigationFinal reportCessna 310A · Dyersburg, TNThe failure of the pilot to attain a proper touchdown point, which resulted in a long landing and an overrun of the runway. Factors were the weather conditions (sky obscuration, low ceiling, fog and drizzle) at the time of the accident, and the wet runway…Jan 26, 1994 · N5333A · Substantial damageNTSB BFO94LA030Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Bennington, VTThe pilot's selection of unsuitable terrain for landing.Jan 23, 1994 · N8211V · Substantial damageNTSB SEA94LA056Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Sidney, MTThe pilot's inadequate compensation for the crosswind resulting in loss of directional control.Jan 22, 1994 · N95900 · Substantial damageNTSB BFO94LA029Accident · No injuriesLimited investigationFinal reportCessna 152 · Plymouth, MAthe pilot's failure to maintain directional control during the flare/touchdown.Jan 22, 1994 · N94963 · Substantial damageNTSB BFO94LA028Accident · No injuriesLimited investigationFinal reportMitsubishi MU-3 · Teterboro, NJThe pilot selected unsuitable terrain for landing. The runway conditions were factors.Jan 20, 1994 · N306P · Substantial damageNTSB SEA94LA050Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Burns, ORThe student pilot in command's application of excessive braking during the landing roll.Jan 17, 1994 · N95169 · Substantial damageNTSB LAX94LA097Accident · No injuriesLimited investigationFinal reportClunis Long EZ · Camarillo, CAthe pilot's improper use of the brake system which resulted in a failure of the right brake due to excessive heat glazing.Jan 17, 1994 · N345KJ · Substantial damageNTSB ATL94LA040Accident · No injuriesLimited investigationFinal reportCessna 152 · Pelion, SCInadequate supervision by the instructor and inadequate compensation for wind conditions by the student pilot. The unfavorable wind condition for supervised solo landing training was a factor.Jan 16, 1994 · N69046 · Substantial damage