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 CHI91LA034Accident · No injuriesLimited investigationFinal reportCessna 401 · Grand Island, NEFlight into known adverse weather conditions and flare misjudged. Factors related to the accident were: icing conditions resulting in reduced aircraft controllability and restricted visual outlook.Nov 27, 1990 · N10QP · Substantial damageNTSB LAX91LA047Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8-24 · Poway, CAThe pilot's failure to obtain a proper touchdown point. Contributing factors which related to the basket's tipping over were the pilot's misjudging the wind direction and the wind's relative high speed.Nov 26, 1990 · N7113U · Minor damageNTSB NYC91LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Taunton, MAThe pilot attempted to land in a strong cross wind, lost control of the airplane, ran off the runway and hit the VASI system.Nov 25, 1990 · N5780U · Substantial damageNTSB NYC91LA037Accident · No injuriesLimited investigationFinal reportCessna 152 · Indian Head, MDThe flight instructors decision to land with insufficient runway remaining to stop the airplane which resulted in an overrun.Nov 25, 1990 · N757MP · Substantial damageNTSB DEN91LA021Accident · No injuriesLimited investigationFinal reportGulfstream AA-5B · Erie, COImproper flare by the pilot, which resulted in a hard landing. A realted factor was: low light condition at dusk.Nov 25, 1990 · N4557E · Substantial damageNTSB FTW91LA018Accident · No injuriesLimited investigationFinal reportCessna 172L · Mount Ida, ARThe pilot in command's failure to compensate for the adverse wind conditions which resulted in a loss of control on touchdown. A factor was the gusty crosswind.Nov 24, 1990 · N4275Q · Substantial damageNTSB ATL91LA021Accident · No injuriesLimited investigationFinal reportCessna 150 · Arlington, TNThe student pilot's failure to maintain directional control during landing. A factor in this accident was gusty winds.Nov 24, 1990 · N7234S · Substantial damageNTSB SEA91LA022Accident · No injuriesLimited investigationFinal reportBeech 65-88 · Spokane, WAThe pilot's misjudgement of his touchdown due to disorientation caused by his lack of forward visibility created by an accumulation of ice on the windshield.Nov 22, 1990 · N6CH · Substantial damageNTSB NYC91LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbus, OHAircraft control was not maintained by the student pilot.Nov 21, 1990 · N6107B · Substantial damageNTSB NYC91DFA01Accident · No injuriesFinal reportLowe/Law Glasair SH-3 · Kingston, NYA hard landing that collapsed the left main gear due to overload failure of the trunion.Nov 21, 1990 · N330 · Substantial damageNTSB NYC91LA032Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G103A · Erwinna, PAThe student pilot's improper landing technique and the instructor's inadequate supervision.Nov 19, 1990 · N923BG · Substantial damageNTSB FTW91LA015Accident · No injuriesLimited investigationFinal reportCessna 195 · N. Little Rock, ARThe failure of the right brake system to release after application for unknown reasons.Nov 18, 1990 · N4320V · Substantial damageNTSB SEA91LA017Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Boise, IDThe pilot's delaying remedial action after a poor landing approach.Nov 16, 1990 · N57434 · Substantial damageNTSB NYC91LA028Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · North Hampton, MALoss of directional control after landing.Nov 15, 1990 · N6384P · Substantial damageNTSB NYC91LA027Accident · No injuriesLimited investigationFinal reportCessna 404 · Pittsburgh, PAA failure of nose landing gear retraction cylinder attach points which allowed the nose landing gear to collapse.Nov 13, 1990 · N54SA · Substantial damageNTSB CHI91LA029Accident · No injuriesLimited investigationFinal reportCessna 152 · Kokomo, INThe student pilot's improper recovery from a bounced landing, resulting inadvertent porpoising.Nov 13, 1990 · N757MT · Substantial damageNTSB ANC91LA013Accident · No injuriesLimited investigationFinal reportCessna U-206 · Montague Island, AKPilot-in-command's failure to maintain aircraft control during landing.Nov 13, 1990 · N4756U · Substantial damageNTSB LAX91LA028Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Prescott, AZThe failure of the main landing gear trunion attach fitting for undetermined reasons.Nov 12, 1990 · N39776 · Substantial damageNTSB FTW91LA014Accident · No injuriesLimited investigationFinal reportCessna 140 · Roanoake, TXThe pilot's failure to maintain directional control. A factor was his lack of flying tail wheel (conventional) gear airplanes.Nov 12, 1990 · N2021N · Substantial damageNTSB MIA91LA024Accident · No injuriesLimited investigationFinal reportCessna 152 · West Palm Beach, FLPilot-in-command's failure to land on a runway that was more aligned with the wind. Factors were: crosswind and lack of total experience.Nov 11, 1990 · N68744 · Substantial damageNTSB FTW91LA013Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Fort Worth, TXThe pilot's misjudgment of airplane attitude, airspeed and distance while on final approach. A factor was the instructor pilot's inadequate supervision.Nov 11, 1990 · N8733E · Substantial damageNTSB LAX91LA026Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Paso Robles, CAThe pilot's delay in taking appropriate remedial action. A factor in the accident was the flight's encounter with a tailwind during the termination phase of the auto rotation.Nov 10, 1990 · N26610 · Substantial damageNTSB BFO91LA011Accident · No injuriesLimited investigationFinal reportFairchild SA227-AC · Covington, KYThe pilot-in-command's failure to extend the landing gear prior to touchdown. Checkride-induced pressure was a contributing factor, and inadequate supervision by the check pilot was a factor.Nov 9, 1990 · N445AC · Substantial damageNTSB ANC91LA010Accident · No injuriesLimited investigationFinal reportCessna 182N · Chugiak, AKThe pilot failed to maintain directional control. Contributing to the accident was the gusty crosswinds and slippery runway.Nov 6, 1990 · N8943G · Substantial damageNTSB CHI91LA024Accident · No injuriesLimited investigationFinal reportCessna 180 · Northwood, NDPoor in-flight planning and decision, unsuitable terrain selected by the PIC.Nov 4, 1990 · N2987C · Substantial damageNTSB ANC91LA009Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKThe pilot-in-command's failure to maintain directional control of the airplane during the landing roll.Nov 4, 1990 · N4597B · Substantial damageNTSB LAX91LA019Accident · No injuriesLimited investigationFinal reportCessna 172M · Torrance, CAThe student pilot failed to properly flare the airplane, made an improper recovery from the subsequent bounced landing. Contributing to this accident was the student pilot's total lack of experience and his improper use of the rudder.Oct 30, 1990 · N9592V · Substantial damageNTSB ATL91LA012Accident · No injuriesLimited investigationFinal reportCessna 150M · Williamston, NCThe student pilot's failure to properly flare the airplane during the night landing attempt. The pilot's failure to maintain geographic orientation and the subsequent flight into night conditions were factors in the accident. The pilot's lack of night flying…Oct 29, 1990 · N3490V · Substantial damageNTSB SEA91LA010Accident · No injuriesLimited investigationFinal reportCessna 152 · Blackfoot, IDThe pilot did not adequately recover from a bounced landing. Factors were improper airspeed and lack of total expereince.Oct 27, 1990 · N5259B · Substantial damageNTSB NYC91LA018Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Bally, PAThe pilot's improper recovery from a bounced landing and his failiure to maintain directional control.Oct 27, 1990 · N3HA · Substantial damageNTSB MIA91LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Fort Myers, FLThe failure of the pilot to maintain directional control while landing with shifting gusty winds.Oct 25, 1990 · N98077 · Substantial damageNTSB FTW91LA009Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Eufaula, OKA restriction in the movement of the right rudder pedal. The restriction resulted from a passenger's inadvertent placement of an object on the cockpit's floor.Oct 25, 1990 · N4537J · Substantial damageNTSB ANC91LA008Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Chugiak, AKThe pilot-in-command's failure to maintain directional control on landing and the failure to select suitable terrain.Oct 25, 1990 · N1181Y · Substantial damageNTSB NYC91LA017Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Bridgeport, CTThe pilot used excessive airspeed on the approach and landed long. The airplane went off the runway and struck a fence.Oct 23, 1990 · N613PW · Substantial damageNTSB DEN91LA011Accident · No injuriesLimited investigationFinal reportCessna 172H · Buena Vista, COThe failure of the pilot to flare properly during landing. The pilot's total lack of experience is a factor.Oct 23, 1990 · N2665L · Substantial damageNTSB MIA91LA019Accident · No injuriesLimited investigationFinal reportCessna 182Q · Ormond Beach, FLFailure of the pilot to maintain proper airspeed during the approach to land.Oct 22, 1990 · N4814N · Substantial damageNTSB FTW91LA008Accident · No injuriesLimited investigationFinal reportCessna 172N · Grand Prairie, TXThe student pilot's improper flare technique and use of rudder.Oct 22, 1990 · N734KG · Substantial damageNTSB CHI91LA015Accident · No injuriesLimited investigationFinal reportCessna 152 · Hannibal, MOThe pilot's improper recovery from a bounced landing. Factors were: excessive airspeed and the pilot's lack of total experience.Oct 22, 1990 · N24359 · Substantial damageNTSB LAX91LA015Accident · No injuriesLimited investigationFinal reportCessna 172L · Placerville, CAThe failure of the pilot to maintain directional control of the aircraft during the landing roll.Oct 20, 1990 · N7815G · Substantial damageNTSB CHI91LA021Accident · No injuriesLimited investigationFinal reportCessna 170B · Maquoketa, IAThe pilot's inadequate commpensation for wind conditions.Oct 20, 1990 · N1692D · Substantial damageNTSB CHI91LA013Accident · No injuriesLimited investigationFinal reportMooney M20/231 · Stockton, MOThe pilot's failure to maintain vso (minimum controllable airspeed) in a landing configuration. An associated factor is the pilot's inadequate remedial action.Oct 19, 1990 · N1002X · Substantial damageNTSB NYC91LA012Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Wildwood, NJThe student pilot's failure to maintain control of the airplane during landing.Oct 16, 1990 · N9575L · Substantial damageNTSB DEN91LA008Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Englewood, COThe failure of the pilot to maintain directional control.Oct 16, 1990 · N5523Z · Substantial damageNTSB CHI91LA012Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Mason, MIThe pilot's failure to maintain directional control. A factor in the accident is the pilot's lack of total experience in the accident type airplane.Oct 14, 1990 · N2600A · Substantial damageNTSB CHI91LA009Accident · No injuriesLimited investigationFinal reportCessna 152 · Crookston, MNA poorly planned approach, and failure to take remedial action by the pilot.Oct 14, 1990 · N7385W · Substantial damageNTSB ATL91LA003Accident · Serious injuriesLimited investigationFinal reportGrumman AA-5A · Lexington, NCThe pilot's failure to establish an approach profile which would have allowed him to make a safe landing on the runway. The pilot misjudged his altitude and airspeed throughout the approach. A factor to the accident was the collision with the railroad berm.Oct 14, 1990 · N7103L · Substantial damageNTSB ANC91LA005Accident · No injuriesLimited investigationFinal reportPiper PA-20 · King Salmon, AKInadvertant stall during an aborted landing.Oct 12, 1990 · N7049K · Substantial damageNTSB LAX91LA006Accident · No injuriesLimited investigationFinal reportCessna 150 · Riverside, CAThe pilot misjudged the airplane's altitude and the improper bounced landing recovery procedure. Contributing to this accident was the student pilot's total lack of expereince.Oct 10, 1990 · N68350 · Substantial damageNTSB ANC91LA004Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKThe pilot's failure to maintain directional control. Contributing to the accident was the excessive taxi speed and inadequate maintenance on the brakes by the pilot.Oct 10, 1990 · N3330D · Substantial damageNTSB LAX91LA004Accident · 1 fatalLimited investigationFinal reportMooney M20K · Rio Linda, CAThe airplane's ground collision with an unauthorized person who was located on the active runway. A contributing factor was related to the nighttime (light) condition which limited the pilot's ability to see the person prior to the impact.Oct 8, 1990 · N252YD · Substantial damage