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 NYC99LA180Accident · No injuriesLimited investigationFinal reportCessna 172 · Mattituck, NYThe pilot's failure to maintain control of the airplane, and the flight instructor's inadequate supervision of the solo flight.Jul 8, 1999 · N7164Q · Substantial damageNTSB NYC99LA168Accident · No injuriesLimited investigationFinal reportCessna 152 · Stow, OHWas the failure of the flight instructor to recognize the high sink rate and apply corrective action in a timely manner.Jul 7, 1999 · N95435 · Substantial damageNTSB DEN99LA116Accident · Serious injuriesLimited investigationFinal reportCessna 182B · Watkins, COThe pilot's failure to maintain directional control of the aircraft during landing roll. A related factor was the gusty quartering tailwind.Jul 7, 1999 · N7289E · Substantial damageNTSB CHI99LA218Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Rogers City, MIThe pilot's inadequate compensation for the crosswind.Jul 7, 1999 · N9964D · Substantial damageNTSB SEA99LA110Accident · Minor injuriesLimited investigationFinal reportParks RV-6 · Hunters, WAThe pilot's failure to maintain adequate airspeed during an attempted go-around.Jul 6, 1999 · N80274 · Substantial damageNTSB ANC99LA085Accident · No injuriesLimited investigationFinal reportCessna 177RG · Fairbanks, AKThe pilot's failure to extend the airplane landing gear. A factor in the accident was an interference with the pilot's habit pattern.Jul 6, 1999 · N45367 · Substantial damageNTSB NYC99LA166Accident · No injuriesLimited investigationFinal reportCessna 140 · Beckley, WVThe pilot's loss of aircraft control during the landing roll, which resulted in an inadvertent ground loop.Jul 5, 1999 · N72992 · Substantial damageNTSB NYC99LA158Accident · No injuriesLimited investigationFinal reportBoeing Stearman E75 · Marston Mills, MAThe inadvertent control interference of the airplane's brakes by the passenger. A factor related to the accident was the pilot in commands insufficient passenger briefing.Jul 5, 1999 · N1658M · Substantial damageNTSB CHI99LA217Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Dongola, ILthe failure of the pilot to maintain a proper glidepath on the landing approach, and the failure of the pilot to select a proper touchdown point. Factors to the accident were the lack of runway lights, the dusk light condition, and the ditch.Jul 4, 1999 · N1996T · Substantial damageNTSB ANC99LA089Accident · No injuriesLimited investigationFinal reportCessna 140 · Sitka, AKThe pilot's inadequate compensation for crosswind conditions. Factors in the accident were a crosswind, and the pilot's lack of total experience in the type of airplane.Jul 4, 1999 · N3579V · Substantial damageNTSB ANC99LA086Accident · No injuriesLimited investigationFinal reportCessna 150F · Fairbanks, AKThe pilot's inadequate compensation for a crosswind. Factors in the accident were a crosswind, and an inadvertent ground loop.Jul 4, 1999 · N7911F · Substantial damageNTSB DEN99LA112Accident · No injuriesLimited investigationFinal reportMooney M20C · Big Piney, WYThe pilot's failure to maintain directional control of the aircraft during landing touchdown. A related factor was the gusty crosswind.Jul 3, 1999 · N6253U · Substantial damageNTSB CHI99LA206Accident · No injuriesLimited investigationFinal reportBeech 58 · Wheeling, ILthe landing gear extension not performed by the pilot. A contributing factor was the checklist not followed by the pilot.Jul 2, 1999 · N3240R · Substantial damageNTSB SEA99LA103Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Billings, MTThe separation of the left main landing gear shock strut for undetermined reasons.Jul 1, 1999 · N3513A · Substantial damageNTSB FTW99TA183Accident · Minor injuriesFinal reportMcDonnell Douglas 500-E · Oklahoma City, OKDuring a practice autorotation, the pilot flared the helicopter too low, which resulted in the tailboom contacting the ground. A factor was the dark night light conditions.Jul 1, 1999 · N686F · Substantial damageNTSB DEN99LA111Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Boulder, COThe pilot's failure to maintain control of the aircraft during landing roll.Jul 1, 1999 · N4785F · Substantial damageNTSB CHI99LA203Accident · No injuriesLimited investigationFinal reportCessna 172R · Kokomo, INthe student pilot's failure to maintain directional control during landing. Factors to the accident were the pilot's lack of experience and the VOR station.Jun 30, 1999 · N2632Y · Substantial damageNTSB NYC99LA162Accident · No injuriesLimited investigationFinal reportCessna 182 · Forest, VAThe pilot's misjudgment of distance/speed, also causal was his failure to execute a go-around. Contributing factors were the night conditions and the tailwind.Jun 29, 1999 · N5481B · Substantial damageNTSB LAX99LA232Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Wailua, HIThe failure of the pilot to adequately compensate for the existing gusty wind conditions and his improper recovery from a bounced landing.Jun 28, 1999 · N17902 · Substantial damageNTSB CHI99LA201Accident · No injuriesLimited investigationFinal reportCessna 172G · Union, INThe pilot's failure to maintain clearance with the sign. Factors associated with the accident were the low ceilings and the sign which was contacted.Jun 28, 1999 · N5869R · Substantial damageNTSB SEA99LA097Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Winthrop, WAThe pilot/passenger's failure to maintain directional control. A contributing factor was the fence.Jun 26, 1999 · N5059Z · Substantial damageNTSB LAX99LA239Accident · No injuriesLimited investigationFinal reportCessna 150K · Hesperia, CAThe pilot's misjudged landing flare point and failure to maintain an adequate airspeed margin, resulting in a stall and hard landing.Jun 26, 1999 · N6171G · Substantial damageNTSB CHI99LA199Accident · No injuriesLimited investigationFinal reportBoeing Stearman B75N1 · Kalamazoo, MIThe pilot's failure to maintain directional control of the airplane during landing. A factor was the variable wind condition.Jun 26, 1999 · N2PP · Substantial damageNTSB NYC99LA159Accident · Minor injuriesLimited investigationFinal reportDuci Lancair 235 · Hamilton, OHThe pilot's failure to maintain control of the airplane. Factors included the pilot's inexperience in the airplane and his failure to compensate for the crosswind condition.Jun 25, 1999 · N789TD · Substantial damageNTSB LAX99LA227Accident · No injuriesLimited investigationFinal reportCessna 120 · Chino, CAA preexisting fatigue fracture of the right axle.Jun 25, 1999 · N2651N · Substantial damageNTSB FTW99LA175Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Cabot, ARThe flight instructor's failure to attain the proper touchdown point during the landing.Jun 25, 1999 · N6617Y · Substantial damageNTSB DEN99LA108Accident · No injuriesLimited investigationFinal reportBeech B90 · Creede, COOverload failure of the right main landing gear scissors torque link precipitated by preexisting fatigue fractures. A factor was wind shear.Jun 25, 1999 · N221NC · Substantial damageNTSB CHI99LA195Accident · No injuriesLimited investigationFinal reportCessna 150G · Fort Scott, KSThe pilot's failure to maintain directional control during the landing roll. A factor to the accident was the soft terrain condition.Jun 25, 1999 · N2263J · Substantial damageNTSB SEA99LA092Accident · No injuriesLimited investigationFinal reportHughes 369D · Shelton, WAThe pilot's failure to maintain rotor RPM during an autorotation.Jun 22, 1999 · N1089Y · Substantial damageNTSB DEN99LA115Accident · No injuriesLimited investigationFinal reportCessna 170 · Durango, COThe pilot's failure to maintain directional control of the aircraft during landing roll. A factor was the high density altitude and the high vegetation (sagebrush).Jun 22, 1999 · N4163V · Substantial damageNTSB ANC99LA088Accident · No injuriesLimited investigationFinal reportCessna 140 · North Pole, AKThe pilot misjudged his altitude and airspeed, and his failure to maintain directional control of the airplane. Factors in the accident were a wet grass runway, and the pilot's excessive application of the brakes.Jun 22, 1999 · N4205N · Substantial damageNTSB SEA99LA094Accident · No injuriesLimited investigationFinal reportCessna 182 · Redmond, ORThe pilot's improper flare.Jun 21, 1999 · N91816 · Substantial damageNTSB NYC99LA152Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Fayetteville, WVThe pilot's failure to maintain directional control during the aborted landing. A factor in this accident was the crosswind condition.Jun 20, 1999 · N20952 · Substantial damageNTSB SEA99LA091Accident · No injuriesLimited investigationFinal reportCessna 180G · Kalispell, MTAn encounter with a crosswind gust, which was not possible to compensate for.Jun 19, 1999 · N4707U · Substantial damageNTSB SEA99LA090Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Zillah, WAThe pilot's selection of unsuitable terrain for landing adjacent to the runway. Factors include sun glare encountered at the time of the landing attempt.Jun 19, 1999 · N9887W · Substantial damageNTSB DEN99LA106Accident · No injuriesLimited investigationFinal reportCessna 172N · Platteville, COThe pilot misjudging the flare altitude, resulting in a hard landing, and his subsequent loss of aircraft control. A factor was overload forces collapsing the nose landing gear assembly.Jun 18, 1999 · N5266J · Substantial damageNTSB SEA99LA088Accident · No injuriesLimited investigationFinal reportRyan Navion B · Klamath Falls, ORThe pilot's failure to reinstall the engine oil filler cap during preflight, resulting in engine oil loss and the necessity for an immediate landing.Jun 17, 1999 · N870DR · Substantial damageNTSB SEA99LA087Accident · No injuriesLimited investigationFinal reportLet L-13 · Belgrade, MTThe pilot in command's failure to maintain clearance from a parked airplane during his attempt to avoid a person on the runway.Jun 17, 1999 · N70741 · Substantial damageNTSB LAX99LA241Accident · No injuriesLimited investigationFinal reportRockwell 690B · Monterey, CAThe failure of maintenance personnel to properly adjust the drag brace preload during recent landing gear maintenance, which resulted in the overload failure and separation of the hydraulic cylinder attach boss.Jun 17, 1999 · N480K · Substantial damageNTSB LAX99LA224Accident · No injuriesLimited investigationFinal reportCessna 180K · Santa Monica, CAThe pilot's misjudged landing flare which resulted in a hard landing and the subsequent porpoising of the airplane; and his failure to maintain directional control that resulted in a ground loop and substantial damage to the airplane.Jun 17, 1999 · N181RC · Substantial damageNTSB CHI99LA188Accident · No injuriesLimited investigationFinal reportCessna 172N · Cloquet, MNa fire which initiated from an undetermined origin.Jun 17, 1999 · N9419E · DestroyedNTSB CHI99LA187Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5KB · Iowa City, IAthe pilot stalled the airplane. Factors included the instructor pilot's inadequate preflight briefing and improper in flight decision.Jun 17, 1999 · N4531R · Substantial damageNTSB NYC99LA148Accident · No injuriesLimited investigationFinal reportAdams Rotorway EXEC-90 · Evington, VAThe pilot's selection of unsuitable terrain for a run on landing. A factor was the dirt bank.Jun 13, 1999 · N8235W · Substantial damageNTSB MIA99LA182Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Seymour, TNThe failure of the pilot to perform a go-around earlier resulting in a long landing, insufficient runway remaining to stop, and subsequent in flight collision with a marked power line during an aborted landing.Jun 13, 1999 · N5494K · Substantial damageNTSB FTW99LA169Accident · No injuriesLimited investigationFinal reportCessna 414 · Springdale, ARThe failure of the right main landing gear torque tube support bracket/pivot bearing which resulted in the failure of the landing gear locking mechanism.Jun 13, 1999 · N475JN · Substantial damageNTSB FTW99LA163Accident · Minor injuriesLimited investigationFinal reportCanadian Car & Foundry Harvard MK IV · Mckinney, TXThe pilot's failure to maintain directional control on landing. Contributing factors were the elevator control restriction, the pilot's inadequate preflight, the ditch, and gusty conditions.Jun 13, 1999 · N59TS · Substantial damageNTSB NYC99LA142Accident · No injuriesLimited investigationFinal reportMorrow RV-6 · Bradford, PAThe pilot's improper flare which resulted in a hard landing, and subsequent collapse of the nose gear.Jun 12, 1999 · N173AB · Substantial damageNTSB NYC99LA137Accident · No injuriesLimited investigationFinal reportCessna 172 · Ravenna, OHThe pilot-in-command's failure to maintain aircraft control during landing.Jun 11, 1999 · N62953 · Substantial damageNTSB MIA99LA175Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Fort Myers, FLThe pilot's failure to verify that the retractable landing gear were down and locked for landing.Jun 11, 1999 · N5238P · Substantial damageNTSB DEN99LA103Accident · No injuriesLimited investigationFinal reportCessna 172N · Grand Junction, COA hard landing when the pilot failed to sufficiently flare the aircraft for touch down. Factors were high-density altitude, and the pilot's lack of total flight experience.Jun 11, 1999 · N359DS · Substantial damage