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 FTW92LA159Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Danbury, TXThe failure of the landing gear skid due to internal corrosion. A factor was the soft ground.Jun 14, 1992 · N6746D · Substantial damageNTSB FTW92DRD02Accident · No injuriesFinal reportGuzzino, P.A. Rotorway Exec · Iowa, LAThe non helicopter rated pilot's failure to maintain directional control during an attempted precautionary landing. A factor was the pilots total lack of experience in helicopters.Jun 14, 1992 · UNREG · Substantial damageNTSB CHI92LA172Accident · No injuriesLimited investigationFinal reportCessna 172 · Wheeling, ILThe pilot's improper approach to landing. Related factors are the thunderstorm and the excessive airspeed.Jun 14, 1992 · N62538 · Substantial damageNTSB ATL92LA125Accident · No injuriesLimited investigationFinal reportCessna 172 · Auburn, ALThe pilot's improper landing flare, and his improper recovery from a bounced landing.Jun 14, 1992 · N97883 · Substantial damageNTSB NYC92LA125Accident · Minor injuriesLimited investigationFinal reportBeech 33A · Farmingdale, NJThe pilot's improper recovery from a bounced landing which resulted in collapsing of the nose gear. A factor in the accident was gusting cross winds.Jun 13, 1992 · N17818 · Substantial damageNTSB NYC92LA112Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Indian Head, MDThe pilot improperly compensated for the wind conditions and lost control of the airplane after touchdown which resulted in the airplane departing the runway. An additional cause of the accident was, the delayed remedial action on the part of the flight…Jun 13, 1992 · N7958Y · Substantial damageNTSB NYC92LA110Accident · No injuriesLimited investigationFinal reportJames J. Dean Pitts Special S1C · Newburyport, MAThe pilot misjudging his clearance to brush and small trees during landing rollout.Jun 13, 1992 · N3117 · Substantial damageNTSB FTW92GA160Accident · No injuriesFinal reportMcdonnell Douglas 369E · Yukon, OKThe dual student's failure to maintain adequate main rotor RPM and failure to level the helicopter at touchdown. Factors were the manufacturer's training pilot's inadequate supervision and the dual student performing the maneuver.Jun 13, 1992 · N684F · Substantial damageNTSB DEN92LA058Accident · No injuriesLimited investigationFinal reportCessna 185 · Durango, COImproper use of brakes. Factors were: poorly planned approach and excessive landing speed.Jun 13, 1992 · N9823X · Substantial damageNTSB CHI92LA177Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Breezy Point, MNThe partial failure of the tail wheel assembly due to a fatigue fracture of an internal spring.Jun 13, 1992 · N9534D · Substantial damageNTSB CHI92LA176Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Indian River, MIAn on ground collision with a deer during a landing ground roll.Jun 13, 1992 · N8303Q · Substantial damageNTSB CHI92LA173Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Ladysmith, WIFailure of the pilot to attain a proper touchdown point and the attempted abort of the precautionary landing attempt.Jun 13, 1992 · N52142 · DestroyedNTSB ATL92LA123Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Winnsboro, SCThe pilot's improper level off and his improper recovery from a bounced landing.Jun 13, 1992 · N2106E · Substantial damageNTSB CHI92LA171Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Liberty, MOThe pilot-in-commands failure to maintain aircraft control. Related factors are the pilot's lack of total experience and improper recovery from a bounced landing.Jun 12, 1992 · N5533A · Substantial damageNTSB NYC92LA106Accident · Minor injuriesLimited investigationFinal reportGlasair SH-2 · Danbury, CTImproper recovery from a bounced landing by the pilot which resulted in a propeller strike which made further flight not possible.Jun 10, 1992 · N155JL · Substantial damageNTSB CHI92LA168Accident · No injuriesLimited investigationFinal reportCessna 172M · Hastings, MIThe pilot-in-command's misjudgement of the touchdown point which resulted in an undershoot and damage to the elevator. In addition, the pilot-in-command failed to properly inspect the airplane for damage prior to further flight.Jun 10, 1992 · N80490 · Substantial damageNTSB CHI92LA166Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Charles, MOThe flight instructor's delay in initiating a go-around and improper recovery from the student's bounced landing. Factor(s) which contributed to the accident was the student pilot overshooting the approach.Jun 10, 1992 · N152AJ · DestroyedNTSB ANC92LA088Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Elephant Lake, AKThe dual student's inadequate compensation for wind conditions and the instructor's inadequate supervision. A factor was the tailwind.Jun 10, 1992 · N101TH · Substantial damageNTSB SEA92LA123Accident · Minor injuriesLimited investigationFinal reportCessna TR182 · Baker, ORThe pilots inadequate recovery from a bounced landing. Factors include unfavorable, gusty winds.Jun 9, 1992 · N6138S · Substantial damageNTSB SEA92LA122Accident · No injuriesLimited investigationFinal reportNorth American Navion · Spokane, WAThe partial failure of the nose gear trunnion. Factors include the pilot's decision to land with the gear in the up position.Jun 9, 1992 · N91132 · Substantial damageNTSB NYC92LA105Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Buffalo, NYThe pilot's failure to maintain airspeed during a go around, which resulted in an inadvertent stall and in flight collision with terrain. Contributing to the accident was the pilot delayed the go around and lack of recent flight expereince.Jun 9, 1992 · N9263H · Substantial damageNTSB NYC92LA104Accident · No injuriesLimited investigationFinal reportCessna 172N · Dexter, MEA failure of the top torque link bolt on the nose landing gear which resulted in a landing with a flat strut and misaligned wheel.Jun 9, 1992 · N19801 · Substantial damageNTSB MIA92LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Opa Locka, FLThe pilot's inadequate compensation for wind condition and failure to maintain runway alignment during the landing roll. A contributing factor was a shifting crosswind.Jun 8, 1992 · N9307P · Substantial damageNTSB FTW92LA154Accident · No injuriesLimited investigationFinal reportBeech 76 · Sherman, TXThe instructor pilot's delayed remedial action, improper configuration, and inadvertent stall.Jun 8, 1992 · N6003V · Substantial damageNTSB LAX92LA238Accident · No injuriesLimited investigationFinal reportCessna 177A · Mariposa, CAThe pilot's poorly planned approach for landing, his failure to initiate a go-around, his failure to obtain the proper touchdown point, his misjudgment of the touchdown flare, and his improper recovery from a bounced landing. A factor in this accident was the…Jun 7, 1992 · N3144T · Substantial damageNTSB FTW92LA153Accident · No injuriesLimited investigationFinal reportPokorney Smith Mini DSA-1 · Groom, TXThe pilot's selection of the unsuitable landing area. Factors were the weather condition and the road sign.Jun 7, 1992 · N2MP · Substantial damageNTSB ATL92LA119Accident · No injuriesLimited investigationFinal reportChampion 8KCAB · Wallace, NCThe failure of the pilot to maintain directional control during the crosswind landing. A factor was the crosswind condition.Jun 7, 1992 · N7921S · Substantial damageNTSB NYC92LA095Accident · Minor injuriesLimited investigationFinal reportBeech N35 · Delaware, OHA loss of control in flight due to wake tubulence from a preceding helicopter. A factor related to the accident was the failure of the pilot to recoginize the hazards of his close proximity behind the landing helicopter.Jun 3, 1992 · N1252Z · Substantial damageNTSB NYC92LA097Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Hazard, KYThe internal failure of the brake's master cylinder. Factors contributing to this accident were; the pilot's improperly planned approach and failure to touch down at the proper point.Jun 2, 1992 · CGDNH · Substantial damageNTSB LAX92LA226Accident · No injuriesLimited investigationFinal reportCessna 152 · Delano, CAThe failure of the student pilot to adequately compensate for gusting cross wind conditions and his failure to maintain directional control during the landing roll.Jun 1, 1992 · N68342 · Substantial damageNTSB ANC92LA084Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Alexander Creek, AKThe pilot's failure to maintain directional control during landing flare/touchdown. A factor relating to the accident was the crosswind weather condition.Jun 1, 1992 · N7475K · Substantial damageNTSB ATL92LA114Accident · No injuriesLimited investigationFinal reportHopkins, R. And M. Protech PT-2 · Landrum, SCThe failure of the pilot to maintain aircraft control during the landing attempt. Factors were the inadequate climb capability of the aircraft and the pilot's lack of familiarity with the aircraft.May 31, 1992 · N523MH · Substantial damageNTSB SEA92LA220Accident · No injuriesLimited investigationFinal reportBellanca 7ACA · Rosalia, WAFailure of the tailwheel spring bracket. A factor to the accident was: directional control was not maintained.May 30, 1992 · N9159L · Substantial damageNTSB SEA92LA111Accident · No injuriesLimited investigationFinal reportCessna 152 · Mt. Pleasant, UTThe pilot in command's failure to maintain directional control. Factors contributing to the accident were: weather (gusts) and terrain (berm).May 30, 1992 · N108ES · Substantial damageNTSB BFO92LA080Accident · No injuriesLimited investigationFinal reportPiper PA-60-602P · Danbury, CTThe national transportation safety board determines the probable cause of the accident was the pilot misjudged distance and altitude which resulted in an overrun of the runway.May 29, 1992 · N94RC · Substantial damageNTSB LAX92LA221Accident · No injuriesLimited investigationFinal reportCessna 182E · Lone Pine, CAThe pilot's encounter with a sudden and strong quartering tailwind after landing on a short dirt runway, and the failure of the pilot to select the other airport runway, which was longer and more aligned with the wind, for the approach and landing.May 27, 1992 · N9340X · Substantial damageNTSB BFO92LA078Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Middlesex, NYThe nose over of the aircraft during landing. A factor contributing to the accident was rough terrain.May 27, 1992 · N8569U · Substantial damageNTSB LAX92LA223Accident · No injuriesLimited investigationFinal reportAerospatiale TB-20 · Groveland, CAThe pilot's inadvertent placement of the landing gear selector in the up position during the initial portion of the landing rollout.May 25, 1992 · N2824F · Substantial damageNTSB CHI92DEV02Accident · Minor injuriesFinal reportSchweitzer Mustang II · Decatur, ILThe pilot's delay in initiating a go-around.May 25, 1992 · N91ES · Substantial damageNTSB BFO92LA077Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Westhampton Bch, NYThe pilot's inadequate landing flare which resulted in a hard landing. Contributing was the pilot's failure to maintain directional control and inadequate supervision.May 25, 1992 · N15109 · Substantial damageNTSB LAX92LA215Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Live Oak, CAThe pilot's failure to maintain directional control and improper use of the brakes.May 24, 1992 · N8412K · Substantial damageNTSB BFO92LA082Accident · Serious injuriesLimited investigationFinal reportAerostar AX-9 - S-66A · Southhampton, NJThe pilot used an excessive descent rate during landing. Contributing to the accident was an unfavorable wind condition.May 24, 1992 · N3604Y · No damageNTSB SEA92LA107Accident · Serious injuriesLimited investigationFinal reportDonald E. Crocker RV-6 · Vancouver, WAAn improper recovery from a bounced landing which resulted in an aerodynamics stall.May 23, 1992 · N116DC · Substantial damageNTSB SEA92LA106Accident · No injuriesLimited investigationFinal reportCessna A185F · Spray, ORThe pilot's selection of unsuitable terrain for landing. Factors include soft and uneven terrain.May 23, 1992 · N61167 · Substantial damageNTSB CHI92LA157Accident · No injuriesLimited investigationFinal reportCessna 150 · South Bend, INImproper aircraft control by the pilot.May 22, 1992 · N6349G · Substantial damageNTSB CHI92LA156Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Greenwood, ILExcessive application of the brakes during landing roll.May 21, 1992 · N6989K · Substantial damageNTSB BFO92LA071Accident · Minor injuriesLimited investigationFinal reportCessna U206E · Turner, METhe pilot's inadequate flare which resulted in a hard landing. Contributing to the accident was the soft terrain.May 21, 1992 · N9446G · Substantial damageNTSB ANC92LA086Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Mcgrath, AKThe pilot's failure to maintain directional control, and his inadequate remedial action.May 21, 1992 · N6840B · Substantial damageNTSB FTW92LA136Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Port Sulphur, LAThe pilot planned the approach with a tailwind and did not attain the proper touchdown point. Factors were the tailwind and the delayed aborted landing.May 20, 1992 · N735SW · Substantial damageNTSB CHI92LA159Accident · No injuriesLimited investigationFinal reportBeech 77 · Moline, ILThe student pilot's failure to maintain directional control.May 20, 1992 · N18244 · Substantial damage