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 LAX92LA339Accident · No injuriesLimited investigationFinal reportBeech D17S · Bishop, CAThe pilot's failure to maintain directional control; improper use of the rudder and excessive braking. Contributing to this accident was the pilot's lack of experience in the accident airplane make and model.Aug 8, 1992 · N92SL · Substantial damageNTSB CHI92LA235Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · St. Paul, MNThe pilot's inattentiveness and improper use of the airplanes brakes. A factor which contributed to this accident was the incorrect brake system installed on the airplane.Aug 8, 1992 · N55982 · Substantial damageNTSB ANC92LA129Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Fairbanks, AKThe pilot's improper inflight planning/decision, and his failure to perform a go around. Contributing to the accident was the rough/uneven terrain.Aug 8, 1992 · N86926 · Substantial damageNTSB ANC92LA122Accident · Minor injuriesLimited investigationFinal reportCessna 207A · St. Michael, AKThe pilot attempted VFR flight into IMC weather conditions. Contributing to the accident were the mountainous/hilly terrain, and the low ceiling weather condition.Aug 8, 1992 · N9970M · Substantial damageNTSB NYC92LA144Accident · Minor injuriesLimited investigationFinal reportJohn Mitchell Myers Special · Franklin, PAThe pilot inadvertently porpoised the airplane during the landing and improper recovery from a bounced landing. A factor in this accident was the pilot's lack of experience in this type of aircraft.Aug 7, 1992 · N163JM · DestroyedNTSB NYC92LA146Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Farmington, MDThe pilot's improper level off which resulted in a hard landing. Contributing was an inadeuate recovery from a bounced landing, and the pilot's lack of total flight experience.Aug 6, 1992 · N5633E · Substantial damageNTSB FTW92LA203Accident · No injuriesLimited investigationFinal reportCessna 310I · Bridgeport, TXStudent pilot's failure to maintain directional control and improper supervision by the instructor pilot.Aug 6, 1992 · N158F · Substantial damageNTSB ANC92LA135Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Wasilla, AKThe pilot failed to maintain directional control of the airplane during the landing roll. Contributing factors were the unfavorable wind, the trees, and the fence.Aug 6, 1992 · N7146K · Substantial damageNTSB NYC92LA143Accident · No injuriesLimited investigationFinal reportPitts S-1S · Galion, OHThe pilot's failure to maintain directional control after landing and the subsequent loss of airplane control.Aug 5, 1992 · N88UM · Substantial damageNTSB SEA92LA174Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Paul, IDThe pilot's selection of unsuitable terrain. The soft terrain was a factor.Aug 4, 1992 · N4653 · Substantial damageNTSB LAX92LA334Accident · No injuriesLimited investigationFinal reportMooney M20-M · Sedona, AZThe pilot's improper recovery from a bounced landing and delayed go-around decision. Contributing to the accident was a failure of the pilot to attain the touch-down during a down wind landing.Aug 4, 1992 · N9124L · Substantial damageNTSB CHI92LA221Accident · Minor injuriesLimited investigationFinal reportStitts SA-11A · Oshkosh, WIThe pilot's failure to maintain control of the homebuilt airplane during the landing. A related factor was the pilot's improper planned approach.Aug 2, 1992 · N6515 · Substantial damageNTSB ATL92LA150Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Ocracoke, NCThe student pilot's failure to maintain directional control during the landing roll. Factors were the pilot's lack of recent total experience, and the crosswind conditions, and the dirt bank adjacent to the runway.Aug 2, 1992 · N3732K · Substantial damageNTSB ATL92IA151Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-11 · Los Angeles, CAThe pilot in command's improper use of the aircraft flight controls (elevator) during the landing, which resulted in the aircraft tail contacting the runway surface.Aug 2, 1992 · N803DE · Minor damageNTSB SEA92LA171Accident · No injuriesLimited investigationFinal reportBoeing B-75 · Three Forks, MTThe pilot's failure to maintain directional control. Factors include a crosswind gust.Aug 1, 1992 · N5176N · Substantial damageNTSB NYC92LA140Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · East Liverpool, OHA collision with trees after the pilot failed to maintain directional control during an aborted landing.Aug 1, 1992 · N53852 · Substantial damageNTSB DEN92LA079Accident · No injuriesLimited investigationFinal reportRobert D. Waldron Kitfox III · Fort Collins, COLoss of control which resulted in dragging a wing tip during flare for landing which ended with a ground loop. A factor was: a tail wind.Aug 1, 1992 · N1060U · Substantial damageNTSB ATL92LA149Accident · No injuriesLimited investigationFinal reportCessna 182A · Aiken, SCThe pilot's diverted attention which resulted in the improper use of the elevator and inadvertent porpoise.Aug 1, 1992 · N5532B · Substantial damageNTSB SEA92LA172Accident · Minor injuriesLimited investigationFinal reportSchweizer SGU 2-22CK · Ephrata, WAThe pilot misjudged the landing flare. Factors include a lack of total pilot expereince.Jul 31, 1992 · N3907A · Substantial damageNTSB LAX92LA326Accident · No injuriesLimited investigationFinal reportHughes 369D · Honolulu, HIThe student's improper use of the flight controls during an attempted recovery from an over rotation during the flare, and, the flight instructor's inadequate supervision of the flight.Jul 31, 1992 · N64MK · Substantial damageNTSB FTW92LA195Accident · No injuriesLimited investigationFinal reportBeech 19A · Mounds, OKThe student pilot's failure to execute a go around when he realized he was going to land long.Jul 30, 1992 · N7642R · Substantial damageNTSB CHI92FA219Accident · 1 fatalField investigationFinal reportTeal TSC-1A2 · Oshkosh, WIThe pilot-in-command's not following procedures/directives.Jul 30, 1992 · N76TJ · Substantial damageNTSB SEA92LA177Accident · No injuriesLimited investigationFinal reportCessna 182Q · Afton, WYThe premature landing flare by the pilot.Jul 29, 1992 · N4906N · Substantial damageNTSB MIA92LA157Accident · No injuriesLimited investigationFinal reportCessna 172P · Valkaria, FLExcessive airspeed on final approach by the pilot in command resulting in failure to attain the proper touchdown point and running off the runway colliding with a tree.Jul 29, 1992 · N89900 · Substantial damageNTSB LAX92LA320Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Las Vegas, NVThe loss of directional control due to the students excessive use of the rudder controls, and, the instructors inadequate supervision of the flight.Jul 28, 1992 · N88212 · Substantial damageNTSB LAX92LA318Accident · No injuriesLimited investigationFinal reportChapuis Spezio Sport · Wells, NVThe pilot's inadequate compensation for the existing wind conditions and his subsequent failure to maintain directional control of the aircraft. A factor in the accident was the variable and gusty nature of the wind conditions at the airport.Jul 28, 1992 · N7715 · Substantial damageNTSB LAX92LA317Accident · No injuriesLimited investigationFinal reportMaule MX-7-180 · Lovelock, NVThe failure of the pilot to maintain directional control of the aircraft. A factor in the accident was the presence of dust devils in the vicinity of the airport.Jul 28, 1992 · N6138Y · Substantial damageNTSB FTW92LA192Accident · No injuriesLimited investigationFinal reportCessna 172 · Vernon, TXAircraft control not maintained by pilot. A factor was unfavorable wind.Jul 28, 1992 · N5063A · Substantial damageNTSB BFO92LA118Accident · Minor injuriesLimited investigationFinal reportWaco AVN-8 · Hamilton, OHThe pilot misjudged distance and altitude which resulted in a landing overrun.Jul 28, 1992 · N19361 · Substantial damageNTSB SEA92LA165Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Spokane, WAThe premature landing flare by the recently certificated private pilot, and her failure to properly recover from the bounced landing. A factor relating to the accident was the gusty wind conditions.Jul 26, 1992 · N139CA · Substantial damageNTSB SEA92LA163Accident · No injuriesLimited investigationFinal reportGrumman American AA-5A · Battleground, WAThe pilot in command's delayed decision to execute a go around. Factors contributing the accident were: a tailwind, trees, and the improper use of the carburetor heat and flaps by the pilot in command.Jul 26, 1992 · N26671 · DestroyedNTSB FTW92FA189Accident · 1 fatalField investigationFinal reportBell 206B3 · Block 651aThe pilot's failure to maintain the proper glidepath during the approach which led to an excessive nose high attitude during the landing flare.Jul 26, 1992 · N2072B · DestroyedNTSB CHI92LA212Accident · No injuriesLimited investigationFinal reportCessna 172H · Chenoa, ILInadequate preflight planning and preparation on the part of the pilot. Factors associated with this accident were a lack of recent experience in the type of operation the pilot was undertaking, a proper climb rate not obtained by the pilot and remedial…Jul 26, 1992 · N8262L · Substantial damageNTSB BFO92LA116Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Spencerport, NYThe pilot's inadequate flare which resulted in a hard landing.Jul 26, 1992 · N4389X · Substantial damageNTSB LAX92LA315Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Carlsbad, CAThe student pilot's failure to maintain adequate rotor RPM during a simulated engine failure, and the flight instructor's inadequate supervision of the flight.Jul 25, 1992 · N2335Q · Substantial damageNTSB BFO92LA117Accident · No injuriesLimited investigationFinal reportRobinson R22A · Sanford, METhe pilot's selection of unsuitable terrain to execute a landing.Jul 25, 1992 · N8557Y · Substantial damageNTSB ATL92LA144Accident · No injuriesLimited investigationFinal reportMooney M20G · Hendersonville, NCThe pilot's delay in executing a recovery from the bounced landing and his inadvertent stall during the initial climb after and landing was aborted. Factors were the excessive landing speed and the high density altitude.Jul 24, 1992 · N6785N · Substantial damageNTSB ANC92LA111Accident · No injuriesLimited investigationFinal reportCessna 180 · Wrangell, AKAn inoperative tailwheel.Jul 24, 1992 · N9398C · Substantial damageNTSB ATL92LA142Accident · No injuriesLimited investigationFinal reportCessna A185F · Maxton, NCThe pilot's inadequate compensation for wind condition and the pilot-in-command's inadequate supervision of the pilot in training.Jul 21, 1992 · N1823R · Substantial damageNTSB BFO92LA103Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Pikesville, KYThe pilot's failure to maintain directional control during the landing, which resulted in an inadvertent ground swerve. Factors related to the accident were: the pilot's improper flare. And objects near the runway.Jul 19, 1992 · N75255 · Substantial damageNTSB LAX92LA304Accident · No injuriesLimited investigationFinal reportCessna 182Q · Montague, CAThe pilot failure to maintain directional control.Jul 18, 1992 · N97799 · Substantial damageNTSB LAX92LA302Accident · Serious injuriesLimited investigationFinal reportCessna 180H · Ukiah, CAThe pilot's failure to maintain directional control of the aircraft during the aborted landing and initial climb-out. The pilot's improper landing flare, the inadvertent porpoise, and his improper recovery from a bounced landing were factors in the accident.Jul 18, 1992 · N2499F · Substantial damageNTSB LAX92LA300Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Five Points, CAThe failure of airport personnel to perform the necessary runway maintenance. Contributing to this accident was the dark night and high vegetation.Jul 16, 1992 · N3105V · Substantial damageNTSB FTW92LA186Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Gould, ARThe aircraft crosswind landing capability was exceeded. A factor was the the gusting crosswind.Jul 16, 1992 · N949LR · Substantial damageNTSB FTW92LA179Accident · No injuriesLimited investigationFinal reportCessna 177 · Nacogdoches, TXThe pilot's failure to maintain directional control. Factors were the inadvertent porpoise of the airplane and the pilot's lack of total experience in the type airplane.Jul 13, 1992 · N3425T · Substantial damageNTSB BFO92LA097Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Bedford, PAThe pilot failed to maintain adequate airspeed which resulted in a stall.Jul 13, 1992 · N61941 · DestroyedNTSB CHI92LA205Accident · No injuriesLimited investigationFinal reportCessna 180H · Blaine, MNThe pilot's inadvertent activation of wheel brakes.Jul 12, 1992 · N7955V · Substantial damageNTSB ANC92LA107Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Watana Lodge, AKThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was the pilot's failure to attain the proper touch down point, and the loose object (large rock) on the landing strip.Jul 12, 1992 · N1387C · Substantial damageNTSB SEA92LA153Accident · No injuriesLimited investigationFinal reportCessna 172 · Auburn, WAThe improper recovery from a bounced landing and the improper use of brakes by the CFI. A factor relating to the accident was the failure of the dual student to touchdown properly.Jul 11, 1992 · N8348B · Substantial damageNTSB LAX92LA296Accident · Minor injuriesLimited investigationFinal reportGrumman AA5 · Soledad, CAThe loss of engine power for undetermined reasons and the lack of suitable terrain for a forced landing.Jul 11, 1992 · N28410 · Substantial damage