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 CHI97LA008Accident · No injuriesLimited investigationFinal reportHughes 369E · Hesston, KSthe pilot selected unsuitable terrain for landing. The factors involved were: an inoperative landing light, dusk light conditions, and the terrain condition.Oct 15, 1996 · N504AP · Substantial damageNTSB CHI97LA015Accident · No injuriesLimited investigationFinal reportCessna 180 · New Richmond, WIthe dual student's failure to recover from the bounced landing and the instructor pilot's failure to correct the situation in time.Oct 14, 1996 · N1535C · Substantial damageNTSB IAD97LA007Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Harlan, KYthe pilot's misjudged distance and speed, and his faiure to attain the proper touchdown point during the landing, which resulted in overrun of the runway and an encounter with terrain.Oct 13, 1996 · N950Z · Substantial damageNTSB SEA97LA014Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Albany, ORfailure of the SA-750 pilot to see-and-avoid the Cessna 172, which had landed ahead of him on the same runway. The inherent visual restrictions of the SA-750 (a tandem two-place biplane) was a related factor.Oct 12, 1996 · N9579H · 2 aircraft · Substantial damageNTSB FTW97LA017Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Boulder, COthe pilot's failure to maintain directional control and his improper use of rudder. A factor was the pilot's lack of total experience in the make and model of airplane.Oct 12, 1996 · N9967Q · Substantial damageNTSB FTW97LA015Accident · No injuriesLimited investigationFinal reportBeech BE-55B · Bellville, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall. Factors were the dark night conditions and the pilot's failure to lower the flaps.Oct 11, 1996 · N179DP · Substantial damageNTSB ATL97LA001Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Morris, ALThe pilot selected the wrong runway relative to the wind, and misjudged the proper touchdowm point on the runway. The tailwind was a factor.Oct 10, 1996 · N10ZP · Substantial damageNTSB FTW97LA023Accident · Serious injuriesLimited investigationFinal reportAerostar RX 8 · Albuquerque, NMA sudden increase in wind velocity.Oct 8, 1996 · N3581D · No damageNTSB LAX97LA005Accident · No injuriesLimited investigationFinal reportNorth American F-86 · Salinas, CAan internal failure of a hydraulic pump, which resulted in contamination in the hydraulic system and subsequent loss of the braking system. Factors related to the accident included the proximity of a fence and rough/uneven terrain adjacent to the runway.Oct 6, 1996 · N186SE · Substantial damageNTSB NYC97LA002Accident · No injuriesLimited investigationFinal reportCessna 172H · Chatham, MAthe pilot's improper flare, which resulted in a hard landing. A factor relating to the accident was: the pilot's lack of experience in the make and model of airplane.Oct 5, 1996 · N3707R · Substantial damageNTSB FTW97LA005Accident · No injuriesLimited investigationFinal reportCessna 152 · Colorado Spgs, COthe student pilot attempting to exit the runway onto a taxiway at excessive speed. A factor was the pilot's failure to land the aircraft in the proper touchdown zone.Oct 4, 1996 · N25772 · Substantial damageNTSB CHI97LA001Accident · No injuriesLimited investigationFinal reportCessna 140A · Allegan, MIthe pilot's failure to maintain directional control during landing.Oct 3, 1996 · N5393C · Substantial damageNTSB LAX96LA346Accident · No injuriesLimited investigationFinal reportBell 206B · Fillmore, CAthe flight instructor's inadequate supervision and delay in taking remedial action to stop the aircraft's lateral movement, which resulted in a dynamic rollover after touchdown.Sep 30, 1996 · N59576 · Substantial damageNTSB FTW96LA405Accident · No injuriesLimited investigationFinal reportIsrael Aircraft Industries 1125 Westwind Astra · Aspen, COfailure of the right brake antiskid, due to corrosion of a canon plug; and failure of the flight crew to revert to the normal brake system.Sep 30, 1996 · N419MK · Substantial damageNTSB CHI96LA356Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Chesterfield, MOimproper flare by the dual student during the landing, and delayed remedial action by the flight instructor (CFI).Sep 30, 1996 · N6008H · Substantial damageNTSB NYC96LA190Accident · No injuriesLimited investigationFinal reportBins Kitfox IV · Pittsfield, MAthe pilot's inadequate compensation for wind conditions, which resulted in a loss of directional control, the airplane veering off the runway, and a subsequent nose over. The adverse wind condition and uneven terrain were related factors.Sep 28, 1996 · N211KF · Substantial damageNTSB ANC96LA165Accident · No injuriesLimited investigationFinal reportCessna 185 · Nome, AKfailure of the pilot to maintain proper alignment of the selected landing area. Subsequent encounter with rocks was a related factor.Sep 28, 1996 · N222WH · Substantial damageNTSB LAX96FA344Accident · Serious injuriesField investigationFinal reportThunder and Colt Colt 240A · Phoenix, AZThe pilot's impairment of judgment and performance due to drugs which led to his misjudgment of his descent rate during landing. Contributing factors were: his failure to activate the deflation device (rip line) and turn off the pilot lights, improper use of…Sep 27, 1996 · N434TC · Minor damageNTSB FTW96LA401Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Falcon, COFailure by the pilot to select suitable terrain for landing. Factors were inadequate preflight planning and preparation for the flight by the pilot by failing to check NOTAMS and failing to use communication aids available to him.Sep 25, 1996 · N41369 · Substantial damageNTSB FTW96TA398Accident · Minor injuriesFinal reportHughes 269C · Houston, TXcompany maintenance personnel not complying with maintenance procedures and directives to inspect the helicopter's skids, which allowed the right skid to wear beyond the manufacturer's tolerances.Sep 24, 1996 · N7492F · Substantial damageNTSB CHI96LA347Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Fargo, NDthe pilot's failure to maintain directional control of the airplane during the landing. A factor was the crosswind.Sep 24, 1996 · N68ME · Substantial damageNTSB SEA96LA218Accident · No injuriesLimited investigationFinal reportCessna 170 · Enterprise, ORthe pilot's misjudgment of speed and distance during the approach/landing, his failure to attain a proper touchdown point during the landing, and his failure to go around (while there was sufficient runway remaining). The short runway was a related factor.Sep 22, 1996 · N2496D · Substantial damageNTSB SEA96LA217Accident · No injuriesLimited investigationFinal reportCessna 182P · Driggs, IDthe pilot's inadequate compensation for wind conditions and failure to maintain directional control of the airplane, which resulted in an inadvertent ground swerve. Factors relating to the accident were: the gusty wind and soft terrain beside the runway.Sep 22, 1996 · N9017M · Substantial damageNTSB IAD96LA152Accident · No injuriesLimited investigationFinal reportCessna 182B · Hanover, PAthe pilot's improper planning/decision and failure to maintain clearance from obstacles during the landing roll. Related factors were: darkness, the lack of usable runway lights, and the road grading equipment parked 50 feet from the edge of the grass runway.Sep 22, 1996 · N2731G · Substantial damageNTSB CHI96LA355Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Jordan, MNthe pilot's failure to maintain directional control during the landing roll.Sep 21, 1996 · N2505P · Substantial damageNTSB ANC96LA167Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Noatak, AKThe pilot's selection of unsuitable terrain for landing.Sep 21, 1996 · N9366D · Substantial damageNTSB CHI96LA341Accident · No injuriesLimited investigationFinal reportCessna 152 · Lakeville, MNthe student pilot misjudged the landing flare which resulted in the hard landing.Sep 17, 1996 · N757PC · Substantial damageNTSB ANC96LA160Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Kotzebue, AKThe pilot's selection of an unsuitable landing area. A factor in the accident was the soft terrain.Sep 17, 1996 · N3086Z · Substantial damageNTSB NYC96LA185Accident · No injuriesLimited investigationFinal reportCessna 182 · Stow, MAthe pilot's misjudgment of speed and distance during the landing, and his failure to go around while there was sufficient runway remaining, which resulted in a runway overrun and an encounter with a soft terrain at the edge of a pond. Wet grass on the runway…Sep 16, 1996 · N737MD · Substantial damageNTSB IAD96LA146Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Westminster, MDthe pilot's misjudgement of his speed and distance, his failure to attain the proper touchdown point during the landing, and his delay in executing a go-around (aborted landing), which resulted in an overrun.Sep 15, 1996 · N9074W · Substantial damageNTSB CHI96LA339Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Highland, ILfailure of the Piper PA-25 tow pilot to see-and-avoid the Blanik L-23 glider. A factor relating to the accident was: neither aircraft was equipped with a communication radio.Sep 14, 1996 · N7753Z · 2 aircraft · Minor damageNTSB LAX96LA336Accident · No injuriesLimited investigationFinal reportPitts S-1S · Reno, NVThe pilot of N230MP inadequate visual lookout while landing on a runway occupied by another known aircraft. A factor in the accident was the procedure to allow simultaneous landings by aircraft on the same runway.Sep 13, 1996 · N230MP · 2 aircraft · Substantial damageNTSB LAX96LA333Accident · No injuriesLimited investigationFinal reportCessna 170B · Concord, CAThe pilot's failure to maintain directional control. The 40-degree crosswind component was a factor in this accident.Sep 13, 1996 · N2916D · Substantial damageNTSB ANC96LA166Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Chitina, AKThe pilot's selection of an unsuitable landing site. A factor associated with the accident is the rough and uneven landing site.Sep 13, 1996 · N7895H · Substantial damageNTSB FTW96LA387Accident · No injuriesLimited investigationFinal reportCessna 182Q · Fayetteville, ARThe pilot's failure to obtain the proper touchdown point on the runway. Factors were gust and the slick, mowed grass runway.Sep 12, 1996 · N97685 · Substantial damageNTSB ATL96LA126Accident · No injuriesLimited investigationFinal reportCessna 177 · Lyon, MSthe student pilot's failure to maintain directional control of the airplane during a touch-and-go landing, which resulted in a ground swerve. The gusty crosswind condition was a related factor.Sep 12, 1996 · N29464 · Substantial damageNTSB FTW96LA380Accident · Serious injuriesLimited investigationFinal reportBell UH-1H · Leadville, COThe pilot's improper inflight planning/decision in that he used an inadequate airspeed or an inadequate altitude, or both, for the intentional autorotation.Sep 10, 1996 · N23Y · Substantial damageNTSB ANC96LA156Accident · No injuriesLimited investigationFinal reportCessna 182 · Fairbanks, AKThe pilot's inadequate compensation for gusty wind conditions during the landing roll. A factor associated with the accident is the gusty wind conditions.Sep 10, 1996 · N6022B · Substantial damageNTSB ANC96LA147Accident · No injuriesLimited investigationFinal reportRans 7 · Anchorage, AKthe pilot's improper recovery from a bounced landing and failure to maintain control of the aircraft. A factor relatated to the accident was: the pilot's improper decision to continue the flight after he identified he was having difficulty landing the…Sep 9, 1996 · N4012H · Substantial damageNTSB CHI96LA329Accident · No injuriesLimited investigationFinal reportCessna 172 · Wellston, MIThe pilot failed to maintain control of the aircraft. Factors were the rough road, the tree, and the tire.Sep 8, 1996 · N7016T · Substantial damageNTSB ANC96LA152Accident · No injuriesLimited investigationFinal reportCessna 206F · Talkeetna, AKThe disconnection of the nosegear scissors assembly due to the loss of a retainer bolt.Sep 8, 1996 · N9515G · Substantial damageNTSB ANC96LA150Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKthe pilot's improper braking action, which resulted in an inadvertent ground swerve and subsequent damage to the airplane. His excessive airspeed during landing was a related factor.Sep 8, 1996 · N9116D · Substantial damageNTSB LAX96LA328Accident · No injuriesLimited investigationFinal reportCessna 425 · Auburn, CAfailure of the right brake system (master cylinder O-ring seal). Factors relating to the accident were: the narrow runway, and the presence of a ditch adjacent to the runway.Sep 5, 1996 · N425WB · Substantial damageNTSB FTW96LA376Accident · No injuriesLimited investigationFinal reportCessna 150M · Boulder, COan improper flare by the student pilot, and his improper recovery from a bounced landing. A factor relating to the accident was: the student pilot's lack of experience in the type (model) of aircraft.Sep 5, 1996 · N704QR · Substantial damageNTSB SEA96LA210Accident · No injuriesLimited investigationFinal reportCessna 120 · Nampa, IDthe solo student pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in a ground loop/swerve.Sep 4, 1996 · N2595N · Substantial damageNTSB MIA96LA222Accident · No injuriesLimited investigationFinal reportCessna 152 · Stuart, FLThe student pilot's improper recovery from a bounced landing, resulting in a loss of directional control, collapse of the nose gear, and subsequent nose down on the runway.Sep 3, 1996 · N93102 · Substantial damageNTSB ANC96LA136Accident · No injuriesLimited investigationFinal reportMaule M-4 · Skwentna, AKThe pilot's selection of an unsuitable landing site. A factor associated with the accident was the rough and uneven terrain.Sep 3, 1996 · N4726T · Substantial damageNTSB LAX96LA327Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Kernville, CAbrake failure due to a stripped brake fitting that allowed the brake fluid to leak out of the system. The failure of maintenance personnel to detect and repair the faulty brake line during the last 100-hour inspection, and the pilot's failure to perform a…Sep 2, 1996 · N5480F · Substantial damageNTSB IAD96LA143Accident · No injuriesLimited investigationFinal reportCessna T210N · Wadsworth, OHthe pilot's misjudgment of distance and speed, and his failure to attain a proper touchdown point, during the landing. Factors related to the accident were: dusk light conditions, and a tailwind.Sep 2, 1996 · N6614Y · Substantial damageNTSB CHI96LA326Accident · No injuriesLimited investigationFinal reportCessna 172 · Chicago, ILthe pilot's improper flare and improper recovery from a bounced landing. A factor relating to the accident was: the pilot's lack of experience (or lack of training) in recovery from bounced landings.Sep 2, 1996 · N65785 · Substantial damage