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 NYC98LA162Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · West Liberty, KYThe pilot's inadequate planning for a downslope landing. A factor was the pilot's lack of training for downslope landing situations.Aug 5, 1998 · N3023M · Substantial damageNTSB FTW98LA374Accident · No injuriesLimited investigationFinal reportBeech B36TC · Pinedale, WYThe pilot not following his Pilot Operating checklist procedures. A factor was the aborted landing which interfered with the pilot's normal traffic pattern habit.Aug 5, 1998 · N4BA · Substantial damageNTSB LAX98LA257Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Van Nuys, CAThe pilot's inadequate compensation for the existing crosswind condition and failure to maintain directional control that subsequently lead to a ground loop/swerve.Aug 4, 1998 · N8335V · Substantial damageNTSB LAX98LA259Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Willits, CAThe pilot's selection of an inadequate landing area and failure to maintain clearance from obstacles during the landing roll.Aug 3, 1998 · N5705B · Substantial damageNTSB FTW98LA346Accident · No injuriesLimited investigationFinal reportCessna 152 · Norman, OKThe student pilot's delayed landing flare resulting in a hard landing and his improper recovery procedures for a bounced landing.Aug 3, 1998 · N93116 · Substantial damageNTSB SEA98TA156Accident · Minor injuriesFinal reportSchweizer SGS 2-33 · Ephrata, WAThe student pilot-in-command's failure to maintain control of the aircraft during the landing. Contributing factors were panic and inadequate initial training.Aug 2, 1998 · N5720S · Substantial damageNTSB CHI98LA295Accident · Minor injuriesLimited investigationFinal reportNorth American SNJ-6B · Quincy, ILthe right main landing gear collapsed for undetermined reasons.Aug 2, 1998 · N7983C · Substantial damageNTSB NYC98LA158Accident · Minor injuriesLimited investigationFinal reportCessna 175 · East Canton, OHThe pilot's failure to maintain direction control of the airplane.Aug 1, 1998 · N6716E · Substantial damageNTSB CHI98LA290Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Mentha, MIthe pilot's improper inflight decision to land the airplane on the gravel covered road with an uneven surface that had corn growing next to its edge. A factor in this accident was the pilot selecting an unsuitable landing area.Jul 31, 1998 · N3659T · Substantial damageNTSB ANC98LA114Accident · No injuriesLimited investigationFinal reportDouglas DC-3C · Anchorage, AKThe pilot's failure to maintain directional control during landing, and the resulting overload fracture of the tailwheel fork assembly.Jul 31, 1998 · N305SF · Substantial damageNTSB LAX98LA249Accident · No injuriesLimited investigationFinal reportBell 222B · Tranquility, CAThe pilot's delayed initiation of a go-around when the severity of the dust condition first became apparent. Contributing factors were dark night conditions and the obscuration from the dust.Jul 30, 1998 · N911RA · DestroyedNTSB FTW98LA337Accident · No injuriesLimited investigationFinal reportRockwell S2R · Brownfield, TXThe pilot's failure to maintain control of the aircraft during the landing roll. A factor was the pilot's lack of experience in the aircraft.Jul 27, 1998 · N8522V · Substantial damageNTSB SEA98LA151Accident · No injuriesLimited investigationFinal reportCurtiss-Wright 12W · Woodland, WAThe pilot in command misjudged clearance from high vegetation when he landed. Factors include inadequate mowing of high vegetation by airport personnel, providing insufficient clearance for the wingspan of landing airplanesJul 26, 1998 · N11715 · Substantial damageNTSB NYC98LA153Accident · Serious injuriesLimited investigationFinal reportCessna 337G · Jeanette, PAThe pilot's delay in applying the brakes during the landing rollout.Jul 26, 1998 · N72326 · Substantial damageNTSB LAX98LA248Accident · No injuriesLimited investigationFinal reportBeech C23 · Avalon, CAThe failure of the pilot to maintain an adequate airspeed during the landing, which resulted in a stall/mush and hard landing.Jul 26, 1998 · N18961 · DestroyedNTSB SEA98LA149Accident · Minor injuriesLimited investigationFinal reportCessna 195B · Ashland, ORThe pilot's improper landing flare, which resulted in a hard landing.Jul 25, 1998 · N2125C · Substantial damageNTSB MIA98LA207Accident · No injuriesLimited investigationFinal reportMooney M-20J · Alexander City, ALThe pilot's failure to maintain directional control of the airplane during landing rollout and attempted go-around, resulting in departure from the runway and collision with adjacent brush and trees.Jul 25, 1998 · N91381 · Substantial damageNTSB FTW98LA332Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Rock Springs, WYThe pilot's failure to maintain directional control, and an inadvertent ground loop/swerve.Jul 25, 1998 · N1202C · Substantial damageNTSB FTW98LA330Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Lubbock, TXThe pilot's failure to perform an adequate flare, and his improper touchdown technique. Factors were the pilot's improper evaluation of the weather conditions, and the high density altitude and crosswind weather condition.Jul 25, 1998 · N789HP · Substantial damageNTSB LAX98LA242Accident · No injuriesLimited investigationFinal reportEnstrom F28A · Pleasanton, CAThe flight instructor's delayed remedial action and the student pilot's failure to maintain rotor RPM. A factor was the downhill terrain.Jul 24, 1998 · N288Q · Substantial damageNTSB FTW98LA318Accident · No injuriesLimited investigationFinal reportCessna 172H · Commerce, TXThe pilot's inadequate compensation for the crosswind resulting in a loss of control. A factor was the crosswind.Jul 24, 1998 · N3743R · Substantial damageNTSB CHI98LA284Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Salina, KSthe pilot failed to flare the airplane properly and the airplane landed hard.Jul 24, 1998 · N177ND · Substantial damageNTSB NYC98LA150Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Nantucket, MAThe student pilot's failure to perform a go-around. A factor in the accident was the tailwind.Jul 23, 1998 · N7406J · Substantial damageNTSB MIA98LA208Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Carthage, NCThe failure of the pilot to maintain directional control of the airport resulting in the collapse of the nose and left main landing gears.Jul 23, 1998 · N4212J · Substantial damageNTSB CHI98LA272Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Falls City, NEthe main landing gear leg fracturing and separating from the portion mounted to the fuselage for undetermined reasons.Jul 23, 1998 · N76601 · Substantial damageNTSB ANC98LA111Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Tyonek, AKThe pilot's failure to maintain directional control while landing. A factor associated with the accident were willow trees near the airstrip.Jul 23, 1998 · N96346 · Substantial damageNTSB MIA98LA204Accident · No injuriesLimited investigationFinal reportCessna 182P · Concord, NCthe failure of the pilot to maintain directional control and his failure to maintain wingtip clearance with trees that border the right side of the runway.Jul 22, 1998 · N7619N · Substantial damageNTSB ANC98LA115Accident · No injuriesLimited investigationFinal reportCessna 182 · Fairbanks, AKThe pilot's failure to attain the proper touchdown point. A factor associated with this accident was the high brush at the approach end of the landing area.Jul 21, 1998 · N92197 · Substantial damageNTSB NYC98LA148Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Whitefield, NHThe instructor pilot's failure to maintain control of the aircraft during landing roll. Contributing factors were the instructor pilot's improper in-flight decision, tailwind and gusty conditions, and wet (standing water) runway conditions.Jul 20, 1998 · N8182A · Substantial damageNTSB FTW98LA324Accident · No injuriesLimited investigationFinal reportCessna A188B · Erie, COThe pilot's failure to maintain directional control of the airplane. A factor was a crosswind gust.Jul 20, 1998 · N21827 · Substantial damageNTSB SEA98LA144Accident · No injuriesLimited investigationFinal reportCessna 172P · Seattle, WAThe student pilot's failure to maintain directional control of the aircraft. Related factors were the student pilot's lack of total experience, and airport signs in the accident area.Jul 19, 1998 · N53630 · Substantial damageNTSB NYC98LA147Accident · No injuriesLimited investigationFinal reportCessna 140 · Gansevoort, NYThe pilot's decision to continue the landing attempt too far down the runway.Jul 19, 1998 · N1689V · Substantial damageNTSB IAD98LA093Accident · No injuriesLimited investigationFinal reportCessna 182 · Edgartown, MAwas the pilot's improper flare prior to touchdown.Jul 19, 1998 · N2608Q · Substantial damageNTSB SEA98LA143Accident · Minor injuriesLimited investigationFinal reportMcCarty Avid Magnum · Kalispell, MTThe pilot's inadequate compensation for the wind conditions. A factor was gusty wind conditions.Jul 18, 1998 · N64KM · Substantial damageNTSB SEA98IA141Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-8-63F · Seattle, WAThe flight crew's failure to perform a missed approach upon failing to attain and/or maintain proper course/runway alignment and glidepath on final approach, resulting in a high-sink-rate landing and subsequent separation of a main landing gear wheel from the…Jul 18, 1998 · N921R · Minor damageNTSB NYC98LA144Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1A · Madison, CTWas the failure of the pilot to maintain directional control of the airplane during an aborted landing. A factor was the winds which were variable and gusty.Jul 18, 1998 · N9418L · DestroyedNTSB IAD98LA081Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Dover, DEThe pilot's failure to attain the proper touchdown point.Jul 18, 1998 · N5907R · Substantial damageNTSB CHI98LA310Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Leland, ILControl interference between the pilot-in-command and the student. An excessive descent rate and inadequate flare by the student during landing are contributing factors. The inadequate supervision by the pilot-in-command is an additional factor.Jul 17, 1998 · N75HM · Substantial damageNTSB CHI98LA261Accident · No injuriesLimited investigationFinal reportCessna 182A · Springbrook, WIThe pilot's improper attitude and excessive sink rate during landing. The terrain condition was a contributing factor in the accident.Jul 17, 1998 · N2139G · Substantial damageNTSB ATL98LA098Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Niceville, FLProper touchdown point not attained. Factors were a tailwind and wet grass.Jul 17, 1998 · N704YG · Substantial damageNTSB FTW98LA314Accident · No injuriesLimited investigationFinal reportCessna 172N · Broomfield, COThe pilot's improper landing flare which resulted in a hard landing.Jul 16, 1998 · N172AT · Substantial damageNTSB CHI98LA256Accident · No injuriesLimited investigationFinal reportCessna 177 · Cassville, WIan undetermined event which resulted in engine failure on landing roll out during attempted restart fuel ignited and an undetermined event in the airplane's fuel system which resulted in a fire.Jul 16, 1998 · N3461T · DestroyedNTSB SEA98LA139Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M18B · Hingham, MTRestricted aileron travel for undetermined reasons.Jul 15, 1998 · N4326M · Substantial damageNTSB SEA98LA137Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Pacific City, ORThe pilot's improper compensation for wind conditions (landing with a tail wind.) Related factors were tail wind conditions, a short runway, and diminished brake system effectiveness.Jul 15, 1998 · N9199D · Substantial damageNTSB CHI98LA252Accident · Serious injuriesLimited investigationFinal reportPiper PA28-151 · Anthon, IAThe pilot-in-command's improper preflight planning, preparation and fuel management resulting in an unscheduled landing and impact with a pole.Jul 15, 1998 · N1473X · Substantial damageNTSB CHI98LA249Accident · No injuriesLimited investigationFinal reportCessna 190 · Pontiac, MIimproper procedures used during the replacement of the landing gear which resulted in pitting and corrosion of the gear spring.Jul 14, 1998 · N56W · Substantial damageNTSB ANC98LA097Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Nenana, AKThe failure of the FAA Flight Service Station specialist to issue an active Notice to Airmen that noted a hazardous condition on the runway. Factors associated with the accident are the rough and uneven runway, and inadequate runway maintenance by airport…Jul 14, 1998 · N8698N · Substantial damageNTSB SEA98LA136Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Great Falls, MTThe pilot-in-command's improper remedial action and overload of the nose landing gear. Contributing factors were gusty winds and a pilot-induced oscillation (porpoise).Jul 13, 1998 · CGDBT · Substantial damageNTSB SEA98LA134Accident · Minor injuriesLimited investigationFinal reportNelson Cygnet SF-2A · Newberg, ORThe pilot-in-command's failure to maintain directional control. Factors contributing were the pilot-in-command's lack of experience in make of aircraft (i.e., use of toe brakes) and the fence post.Jul 13, 1998 · N191LM · Substantial damageNTSB FTW98LA297Accident · No injuriesLimited investigationFinal reportPeebles/Lancair 360 LC-20 · Price, UTThe pilot's excessive descent rate on final approach and his delayed use of power to arrest the excessive descent rate.Jul 12, 1998 · N360P · Substantial damage