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 SEA94LA224Accident · No injuriesLimited investigationFinal reportCessna 206 · Bliss, IDThe pilot's failure to maintain directional control. Factors include sunglare from the setting sun, and the soft terrain along the side the runway.Aug 27, 1994 · N859A · Substantial damageNTSB BFO94LA156Accident · No injuriesLimited investigationFinal reportCessna 195B · Ossipee, NHSeparation of the left main landing gear due to fatigue failure.Aug 27, 1994 · N9885A · Substantial damageNTSB BFO94LA153Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Wolfeboro, NHThe pilot's failure to maintain directional control during landing which resulted in inflight collission with trees.Aug 27, 1994 · N8541Y · Substantial damageNTSB ATL94LA167Accident · No injuriesLimited investigationFinal reportCessna 152 · W. Columbia, SCThe student pilot's failure to properly flare the aircraft, resulting in a hard landing.Aug 27, 1994 · N94194 · Substantial damageNTSB MIA94LA201Accident · No injuriesLimited investigationFinal reportMankovich Parakeet · Fernandina Bch, FLThe improper flare by the pilot-in-command resulting in the hard landing, and the pilot's failure to perform a recovery from the bounced landing. Contributing to the accident was the pilot's lack of total time in this type airplane.Aug 26, 1994 · N163MS · Substantial damageNTSB BFO94LA150Accident · No injuriesLimited investigationFinal reportBeech 36 · Georgetown, DEThe issuance of a NOTAM with inadequate information. Factors related to the accident were: the pilot's failure to attain the proper touchdown point, and the lack of visual cues concerning the construction barrier.Aug 26, 1994 · N15512 · Substantial damageNTSB LAX94LA339Accident · No injuriesLimited investigationFinal reportCessna 172 · Lakeport, CAThe pilot's inadequate compensation for the existing cross wind conditions, and failure to maintain directional control of the airplane during landing rollout.Aug 25, 1994 · N9447E · Substantial damageNTSB BFO94LA148Accident · No injuriesLimited investigationFinal reportPiper PA -28-181 · Skowhegan, METhe pilot's failure to do a go around which resulted in an inflight collision with trees during a delayed aborted landing to avoid a runway overrun.Aug 25, 1994 · N11HK · Substantial damageNTSB SEA94LA220Accident · No injuriesLimited investigationFinal reportBeech 23 · Everett, WAThe student pilot's failure to maintain directional control, and his inadequate remedial action. Factors include a fence in the vicinity of the runway.Aug 24, 1994 · N2371Z · Substantial damageNTSB SEA94LA219Accident · No injuriesLimited investigationFinal reportCessna 150E · Mcminnville, ORThe student pilot's failure to maintain directional control, and his inadequate remedial action. Factors include soft terrain in the vicinity of the runway.Aug 24, 1994 · N4016U · Substantial damageNTSB CHI94LA296Accident · No injuriesLimited investigationFinal reportCessna 172 · Anoka, MNthe pilots decision to attempt a landing ahead of the approaching thunderstorm, and his failure to maintain directional control. A factor was the gusting crosswind ahead of the storm.Aug 24, 1994 · N75534 · Substantial damageNTSB LAX94LA337Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8-24 · Sedona, AZa tip over of the balloon and basket during a high wind landing due to the pilot's inability to compensate for the increased wind speed conditions during the final stages of the flight and landing.Aug 23, 1994 · N90299 · No damageNTSB BFO94LA143Accident · No injuriesLimited investigationFinal reportCessna 172M · Vestal, NYLoss of engine power during an aborted landing due to the throttle cable separating from the carburetor.Aug 23, 1994 · N61774 · Substantial damageNTSB LAX94LA334Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Mesa, AZThe student pilot's failure to maintain directional control by his improper use of the flight controls. Factors related to this accident were the pilot's lack of total experience and the crosswind.Aug 22, 1994 · N172ST · Substantial damageNTSB BFO94LA142Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Leesburg, OHThe pilot misjudged his altitude and airspeed during landing resulting in an overrun and collision with a fence. A related factor was the wet runway.Aug 21, 1994 · N92483 · Substantial damageNTSB LAX94LA330Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Page, AZThe pilot's failure to follow procedures to assure that the landing gear was extended. His diverted attention due to the previous two go-arounds is a factor in this accident.Aug 20, 1994 · N88FC · DestroyedNTSB LAX94LA329Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Oakdale, CA1) The flight instructor's failure to attain a proper touchdown point on the runway, 2) his failure to initiate a timely go around, and 3) his inadequate supervision of the flight.Aug 20, 1994 · N2436N · Substantial damageNTSB ANC94LA123Accident · No injuriesLimited investigationFinal reportHelio H295 · Artic Village, AKThe pilot selected unsuitable terrain for landing. A factor was the hidden obstruction (hole).Aug 20, 1994 · N6DB · Substantial damageNTSB ANC94LA122Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Chickaloon, AKThe pilot's inadequate in-flight planning and a failure to maintain directional control of the airplane. Factors were the rising, rough/uneven terrain and the tailwind.Aug 20, 1994 · N2389M · Substantial damageNTSB ANC94LA112Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Koliganek, AKThe pilot's inadequate in-flight planning and failure to attain a touchdown point in the landing area. An obstacle (tree) in the landing area was a factor in the accident.Aug 20, 1994 · N94FB · Substantial damageNTSB MIA94LA198Accident · No injuriesLimited investigationFinal reportCessna 152 · Arcadia, FLThe pilot's inadequate compensation for wind conditions. The gusty, crosswind was a factor.Aug 19, 1994 · N757WM · Substantial damageNTSB LAX94LA328Accident · No injuriesLimited investigationFinal reportCessna 180 · Sedona, AZthe pilot's inadvertant application of wheel brakes during a critical phase of landing rollout.Aug 19, 1994 · N9944N · Substantial damageNTSB CHI94MA290Accident · No injuriesMajor investigationFinal reportMcDonnell Douglas MD-11F · Chicago, ILThe first officer's improper flare and improper use of flight controls during the landing flare/touchdown.Aug 19, 1994 · IDUPO · Substantial damageNTSB ANC94LA139Accident · No injuriesLimited investigationFinal reportCessna 182B · Ketchikan, AKThe failure of the pilot to maintain directional control of the airplane during a hard landing. The pilot's improper recovery from a bounced landing and a downdraft were factors in the accident.Aug 19, 1994 · N2791G · Substantial damageNTSB SEA94LA215Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Hailey, IDThe pilot's inadequate compensation for wind conditions. A factor to the accident was a tailwind.Aug 18, 1994 · N7789P · Substantial damageNTSB CHI94LA287Accident · No injuriesLimited investigationFinal reportHughes 369HS · Custer, SDthe pilot's selection of unsuitable terrain on which to perform an autorotation. A factor in this accident was the hidden obstruction.Aug 18, 1994 · N74AW · Substantial damageNTSB BFO94LA139Accident · No injuriesLimited investigationFinal reportCessna 182L · Hopkinsville, KYThe pilot's failure to maintain proper alignment and adequate obstacle clearance.Aug 18, 1994 · N3376R · Substantial damageNTSB SEA94LA216Accident · No injuriesLimited investigationFinal reportCessna 170B · Redmond, ORProper touchdown point was not attained. A factor to the accident was inadequate remedial action.Aug 17, 1994 · N8339A · Substantial damageNTSB LAX94LA322Accident · 1 fatalLimited investigationFinal reportBell 47-G3B · Truk Island, MicronesiaThe pilot misjudged the clearance between the helicopter's rotor blades and the coconut trees.Aug 16, 1994 · N65678 · Substantial damageNTSB SEA94LA213Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Nehalem, ORThe separation of the landing gear transmission assembly from its attach bracket rivets due to undetermined reasons. It was not possible for the landing gear to be locked down during the landing roll due to this separation.Aug 14, 1994 · N5063P · Substantial damageNTSB SEA94LA211Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Dayton, WYThe pilot's failure to maintain directional control.Aug 14, 1994 · N3736V · Substantial damageNTSB LAX94LA321Accident · No injuriesLimited investigationFinal reportCessna 172P · Scottsdale, AZthe pilot's misjudging the flare altitude and failing to maintain adequate airspeed resulting in an inadvertent stall and hard landing. The pilot's lack of total time in the airplane is a factor in this accident.Aug 14, 1994 · N98909 · Substantial damageNTSB CHI94LA285Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Hettinger, NDthe pilot's improper use of the wheel brakes.Aug 14, 1994 · N2501K · Substantial damageNTSB CHI94LA281Accident · No injuriesLimited investigationFinal reportBeech B-35 · Boyceville, WIThe pilot-in-command's inadequate compensation for the existing wind conditions during the landing flare/touchdown. A factor was the gusty wind conditions.Aug 14, 1994 · N5095C · Substantial damageNTSB CHI94LA280Accident · Minor injuriesLimited investigationFinal reportSchleicher ASW-20 · Ionia, MIno thermal lift available, and the lack of suitable terrain for landing. A factor related to the accident was the high wind condition.Aug 14, 1994 · N6514M · Substantial damageNTSB CHI94LA279Accident · No injuriesLimited investigationFinal reportHughes TH-55A · Houghton, MIfailure of the pilot to maintain control of the aircraft.Aug 14, 1994 · N20SD · Substantial damageNTSB CHI94LA293Accident · No injuriesLimited investigationFinal reportSnow 600B · Grundy Center, IAthe pilot's selection of unsuitable terrain for takeoff and his delay in aborting the takeoff. Factors in the accident were condition of the runway, the road, and the ditch.Aug 13, 1994 · N39762 · Substantial damageNTSB ANC94LA107Accident · No injuriesLimited investigationFinal reportHelio H-700 · Tok, AKThe partial failure of the airplane's normal brake system.Aug 13, 1994 · N4059H · Substantial damageNTSB LAX94LA319Accident · No injuriesLimited investigationFinal reportPerth Amboy Bird BK · El Cajon, CAThe pilot's inadequate compensation for the wind conditions and his failure to maintain directional control of the aircraft. The unfavorable wind was a factor.Aug 12, 1994 · NC731Y · Substantial damageNTSB CHI94LA278Accident · No injuriesLimited investigationFinal reportCessna 120 · Manitowoc, WIthe private pilot's improper use of brakes during the landing roll. A related factor is his lack of total experience.Aug 12, 1994 · N1987V · Substantial damageNTSB LAX94LA314Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Fresno, CAthe pilot's failure to maintain directional control of the aircraft resulting in a ground loop/swerve and a subsequent overload failure of the right main landing gear.Aug 11, 1994 · N4374X · Substantial damageNTSB BFO94LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Waynesboro, VAThe pilot's misjudgement of speed and distance which resulted in a landing overrun. A contributing factor is the pilot's delay in intiating a go-around.Aug 11, 1994 · N8505E · Substantial damageNTSB LAX94LA311Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA316B · Stateline, NVthe failure of the pilot to maintain the proper rate of descent during the vertical descent into the landing zone, which resulted in a hard landing. Factors in the accident were high density altitude and dark night light conditions.Aug 10, 1994 · N981CF · Substantial damageNTSB BFO94LA131Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Wolfeboro, NHThe pilot's inadequate inflight decision, which resulted in a downwnind landing and overrun of the runway.Aug 10, 1994 · N3372M · Substantial damageNTSB ATL94LA153Accident · No injuriesLimited investigationFinal reportNaval Aircraft Factory N3N-3 · Beaufort, SCThe pilot's improper use of the rudder during landing.Aug 10, 1994 · N44970 · Substantial damageNTSB ATL94LA152Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Vanceboro, NCThe pilot's improper use of wheel brakes.Aug 10, 1994 · N8896H · Substantial damageNTSB ANC94LA102Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Bethel, AKThe pilot misjudged the strength of the tailwind and did not perform a go-around in a timely fashion so as to avoid landing the airplane halfway down the strip. Factors in the accident were the wet landing strip and the tailwind.Aug 9, 1994 · N756NG · Substantial damageNTSB NYC94LA159Accident · No injuriesLimited investigationFinal reportCessna 172P · Pottsville, PAThe pilot's failure to attain adequate airpseed, which resulted in a stall/mush and collision with a tree.Aug 8, 1994 · N52211 · Substantial damageNTSB LAX94LA310Accident · No injuriesLimited investigationFinal reportCessna 172M · Carson City, NVthe pilot's decision to attempt a landing in crosswind conditions which exceeded the capability of the aircraft.Aug 8, 1994 · N4390R · Substantial damageNTSB ANC94LA114Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Deadhorse, AKThe separation of the landing gear tube at the spindle due to corrosion. An inadequate annual inspection was a factor in the accident.Aug 8, 1994 · N4450A · Substantial damage