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 ANC92LA151Accident · No injuriesLimited investigationFinal reportCessna 185E · Yakutat, AKThe pilot in command not maintaining directional control of the airplane.Aug 30, 1992 · N3347L · Substantial damageNTSB SEA92LA199Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Bucoda, WAThe failure of the pilot to maintain proper alignment while landing on water, resulting in a swerve during deceleration.Aug 29, 1992 · N8011Y · Substantial damageNTSB MIA92LA168Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Oak Hill, FLFailure of the pilot-in-command to level off during the simulated forced landing.Aug 29, 1992 · N8410R · Substantial damageNTSB LAX92LA371Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Casa Grande, AZThe pilots inadequate compensation for the existing wind conditions. The gusty nature of the cross wind condiitons encountered was a factor.Aug 29, 1992 · N8647W · Substantial damageNTSB LAX92LA370Accident · No injuriesLimited investigationFinal reportCessna 150G · Woodland, CAThe failure of the pilot to maintain directional control of the aircraft during the landing roll. Factors in the accident were the students lack of total experience and the soft nature of the recently plowed field the aircraft encountered.Aug 29, 1992 · N2421J · Substantial damageNTSB CHI92LA261Accident · No injuriesLimited investigationFinal reportCessna 172N · Fort Wayne, INThe pilot's failure to maintain directional control during the landing roll.Aug 29, 1992 · N100SU · Substantial damageNTSB ATL92LA168Accident · No injuriesLimited investigationFinal reportBeech C23 · Pageland, SCThe pilot's improper touchdown, resulting in an overload failure of the nose gear attachment support tubes. Factors were the lack of total experience of the pilot and the ditch adjacent to the runway.Aug 28, 1992 · N63892 · Substantial damageNTSB LAX92LA364Accident · No injuriesLimited investigationFinal reportCessna 140 · Reedley, CAThe failure of the pilot to maintain directional control of the aircraft during the landing roll and his excessive use of the brakes.Aug 26, 1992 · N72172 · Substantial damageNTSB CHI92LA256Accident · No injuriesLimited investigationFinal reportCessna A185F · St. Cloud, MNFailure of the pilot-in-command to abort takeoff before overrunning the lake edge.Aug 26, 1992 · N185RF · Substantial damageNTSB ANC92LA146Accident · No injuriesLimited investigationFinal reportCessna 206 · Fairbanks, AKProper touchdown point was not attained by the pilot. Factors related to the accident were: the tailwind and the improper approach procedure used by the pilot, an inadequate background check of pilot in hiring by company/mgmt, inadequate training and check of…Aug 26, 1992 · N711FY · Substantial damageNTSB SEA92LA190Accident · Serious injuriesLimited investigationFinal reportWSK PZL Mielec M-18A Dromader · Mattawa, WAThe inadvertent locking of the acft brakes while landing by the PIC, resulting in an acft nose over on the gravel strip.Aug 25, 1992 · N2252Z · Substantial damageNTSB ATL92LA164Accident · Minor injuriesLimited investigationFinal reportClassic Waco YMF-5 · Surfside Beach, SCThe failure of the main landing gear as a result of inadequate manufacturing.Aug 25, 1992 · N527MN · Substantial damageNTSB SEA92LA186Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Morgan, UTPoor inflight planning/decision by the pilot in command. Factors contributing to the accident were: the gravel/dirt bank, night environmental conditions, and runway lighting unavailable.Aug 24, 1992 · N2169A · Substantial damageNTSB NYC92LA176Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Coatesville, PAThe pilot's decision to continue the approach and eventual touching down off the runway which resulted in a loss of control of the airplane and collapsing the landing gear. A factor in this accident was the pilot's loss of visual perception and fog.Aug 24, 1992 · N37DD · Substantial damageNTSB LAX92LA363Accident · No injuriesLimited investigationFinal reportNorth American NA-64 · Bakersfield, CALeakage of brake fluid from an unknown source onto the brake lining and drum.Aug 23, 1992 · N3201U · Substantial damageNTSB NYC92LA172Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · West Mifflin, PAThe pilot inadvertently ground looped the airplane which resulted in the main landing gear collapsing. A factor in this accident was the pilot's limited flight time in this make and model airplane.Aug 22, 1992 · N50264 · Substantial damageNTSB LAX92LA359Accident · Minor injuriesLimited investigationFinal reportTBM TBM 700 · So. Lake Tahoe, CAThe failure of both pilots to adequately anticipate and compensate for the variable cross wind condition, and, the pilot in command's inadequate supervision of the flight. A factor in the accident was the left seat pilot's limited total experience and…Aug 22, 1992 · N339W · DestroyedNTSB DEN92LA086Accident · No injuriesLimited investigationFinal reportCessna 182Q · Crested Butte, COThe pilot's selection of the wrong runway for landing, and the use of a flap setting less than a landing flap configuration.Aug 22, 1992 · N735JN · Substantial damageNTSB SEA92LA185Accident · No injuriesLimited investigationFinal reportSchaknowski Dyke Delta JD-2 · Billings, MTFatigue of the left main landing gear axle.Aug 21, 1992 · N78BS · Substantial damageNTSB CHI92LA251Accident · No injuriesLimited investigationFinal reportCessna 182P · Ephraim, WIThe pilot selected the wrong runway for landing.Aug 21, 1992 · N1368S · Substantial damageNTSB NYC92LA171Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Bedford, MAThe pilot's loss of airplane control during the flare, resulting in porpoising and subsequent hard landing.Aug 20, 1992 · N8371H · Substantial damageNTSB LAX92LA362Accident · No injuriesLimited investigationFinal reportEnstrom F28C · Irwindale, CAThe pilot's misjudgment of the landing flare during a practice autorotation.Aug 20, 1992 · N595H · Substantial damageNTSB ATL92LA163Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Oviedo, FLThe failure of the dual student to properly flare the aircraft during the landing attempt, and the flight instructor's failure to perform remedial action to prevent the hard landing.Aug 20, 1992 · N2662R · Substantial damageNTSB NYC92LA170Accident · No injuriesLimited investigationFinal reportGerald Barker Quicky 2 · Altoona, PAAn onground collision with a VASI light box after the tailwheel strut broke upon touchdown and the pilot lost directional control.Aug 19, 1992 · N244GB · Substantial damageNTSB LAX92LA358Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Laveen, AZThe failure of the pilot to maintain directional control of the aircraft during the landing roll.Aug 19, 1992 · N5363 · Substantial damageNTSB CHI92LA246Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Chillicothe, MOThe pilot's improper use of the airplanes brakes.Aug 18, 1992 · N72379 · Substantial damageNTSB ATL92LA161Accident · No injuriesLimited investigationFinal reportCessna 172N · New Bern, NCThe student pilot's failure to maintain directional control on the landing roll. Factors were the pilot's lack of total experience and the crosswind conditions at the airport.Aug 18, 1992 · N5415J · Substantial damageNTSB SEA92LA187Accident · No injuriesLimited investigationFinal reportCessna 182F · Alderwood Manor, WAThe pilot selected the wrong runway for wind conditions.Aug 17, 1992 · N3551Y · Substantial damageNTSB LAX92LA353Accident · No injuriesLimited investigationFinal reportFleet II · Long Beach, CAThe pilot's improper compensation for the wind condition, and improper use of the flight controls. Contributing to this accident was the crosswind condition and the collapsing of the main landing gear due to overload.Aug 17, 1992 · NC413K · Substantial damageNTSB CHI92LA244Accident · No injuriesLimited investigationFinal reportBeech 19A · Park Rapids, MNA hard landing due to excessive descent rate.Aug 16, 1992 · N6055N · Substantial damageNTSB ANC92LA149Accident · No injuriesLimited investigationFinal reportCessna 182P · Montague Island, AKThe pilot in command did not properly align the airplane with the airstrip landing zone. A factor which contributed to the accident were the trees.Aug 16, 1992 · N7388Q · Substantial damageNTSB NYC92LA165Accident · No injuriesLimited investigationFinal reportSchweizer 269C · London, OHThe failure of the pilot to properly judge his altitude during a practice autorotation, which resulted in a tail rotor ground strike and roll over upon touchdown.Aug 15, 1992 · N63SS · Substantial damageNTSB ANC92LA132Accident · 1 fatalLimited investigationFinal reportPiper PA-18 · Iliamna, AKThe pilot failed to maintain airspeed and stalled the airplane. Contributing to the accident was the unfavorable wind condition.Aug 14, 1992 · N3906Z · DestroyedNTSB SEA92LA179Accident · No injuriesLimited investigationFinal reportCessna A185F · Ennis, MTDirectional control was not maintained. Factors to the accident were: a loose gravel airstrip, wind gusts and inadequate remedial action.Aug 13, 1992 · N1207Q · Substantial damageNTSB NYC92LA158Accident · No injuriesLimited investigationFinal reportStinson ST-75 · Sussex, NJThe pilot failed to maintain control of the airplane during the landing roll, and inadvertently swerved and ground looped into two parked airplanes. A factor in this accident was the pilot's lack of expereince in this make and model airplane.Aug 13, 1992 · N8495K · Substantial damageNTSB CHI92LA253Accident · No injuriesLimited investigationFinal reportLake LA-4 · Pontiac, MIThe instructor pilot's directing a turn to change heading in the flare.Aug 13, 1992 · N8WW · Substantial damageNTSB CHI92LA240Accident · No injuriesLimited investigationFinal reportPiper PA-31T1 · Osage Beach, MOFailure to attain the proper touchdown point.Aug 13, 1992 · N701PT · Substantial damageNTSB SEA92LA178Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Pacific City, ORThe pilot selected the wrong runway relative to the wind and then delayed in aborting the landing. The tailwind was a factor.Aug 12, 1992 · N2328Q · Substantial damageNTSB ATL92LA158Accident · No injuriesLimited investigationFinal reportCessna 182Q · Ft. Payne, ALThe pilot's improper procedure, in that he failed to raise the flaps following the short field landing, as prescribed in the pilot's information manual, which resulted in a loss of directional control. Factors were the tall grass adjacent to the runway, the…Aug 12, 1992 · N4852N · Substantial damageNTSB ANC92LA128Accident · Minor injuriesLimited investigationFinal reportDe Havilland DHC-2 · Crescent Lake, AKThe pilot's misjudging his altitude on final approach. Contributing to the accident was the glassy water condition.Aug 12, 1992 · N8190Y · Substantial damageNTSB SEA92LA176Accident · No injuriesLimited investigationFinal reportCessna 180K · Wibaux, MTA poorly planned approach.Aug 10, 1992 · N63242 · Substantial damageNTSB MIA92LA163Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Brooksville, FLThe pilot-in-command's failure to maintain alignment with the runway during landing. This resulted in an in-flight collision with a runway marker, collapse of the right main landing gear, and subsequent collision with terrain.Aug 10, 1992 · N119Q · Substantial damageNTSB FTW92DPG12Accident · No injuriesFinal reportGrumman G-164A · Mc Crory, ARThe pilots failure to maintain directional control.Aug 10, 1992 · N6636Q · Substantial damageNTSB CHI92LA239Accident · No injuriesLimited investigationFinal reportCessna 182BTW · Plymouth, MIAn inadvertent ground loop.Aug 10, 1992 · N2387G · Substantial damageNTSB SEA92LA175Accident · No injuriesLimited investigationFinal reportCessna 172H · Lakeview, ORThe pilot's failure to maintain directional control. Factors include soft terrain.Aug 9, 1992 · N8100L · Substantial damageNTSB NYC92LA155Accident · No injuriesLimited investigationFinal reportBroussard MH-1521M · Elyria, OHThe pilot's improper flare resulting in a hard bounced landing and subsequent blown tire and loss of airplane control.Aug 9, 1992 · N239HL · Substantial damageNTSB LAX92LA344Accident · No injuriesLimited investigationFinal reportCessna 320A · Novato, CAThe locked left brake assembly due to the missing brake retaining clips.Aug 9, 1992 · N3014R · Substantial damageNTSB LAX92LA341Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Sedona, AZThe failure of the fixed base operator to properly conduct an annual inspection and inadequate compliance with the airworthiness directive. Contributing to this accident was the total failure of the main landing gear trunion due to fatigue.Aug 9, 1992 · N6649V · Substantial damageNTSB CHI92DER03Accident · No injuriesFinal reportSchneider/Brashear Sorrell SNS-7 · Alexandria, MNThe pilot's failure to maintain directional control during the landing roll.Aug 9, 1992 · N226HB · Substantial damageNTSB NYC92LA148Accident · Minor injuriesLimited investigationFinal reportBeech 24R · Eliot, METhe pilot allowed the airspeed to get excessive, resulting in the airplane touching down too long and too fast.Aug 8, 1992 · N3824Q · Substantial damage