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 CHI02LA154Accident · No injuriesLimited investigationFinal reportMooney M20J · Minneapolis, MNThe pilot's failure to maintain control of the aircraft during an aborted landing.Jun 6, 2002 · N201Y · Substantial damageNTSB CHI02LA153Accident · No injuriesLimited investigationFinal reportCessna 150C · Minneapolis, MNThe pilot's improper flare resulting in the hard landing.Jun 6, 2002 · N7821Z · DestroyedNTSB CHI02FA148Accident · No injuriesField investigationFinal reportDouglas DC-9-31 · Minneapolis, MNThe failure of the right main landing gear due to fatigue.Jun 4, 2002 · N8986E · Substantial damageNTSB ATL02LA132Accident · No injuriesLimited investigationFinal reportCessna 182 · Saint Pauls, NCThe pilots improper flare, during an attempted landing.Jun 4, 2002 · N2044X · Substantial damageNTSB ATL02LA117Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Thomaston, GAFailure of the pilot-in-command to maintain directional control on landing, resulting in an inadvertent ground loop.Jun 3, 2002 · N8680D · Substantial damageNTSB ATL02FA113Accident · No injuriesField investigationFinal reportBombardier CL600-2B19 · Atlanta, GAFailure of the left main landing gear fitting due to a fatigue crack that emanated from multiple origins at the external surface of the wall at the shock strut radius run out area for undetermined reasons.Jun 3, 2002 · N849AS · Substantial damageNTSB SEA02LA094Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Payette, IDThe pilot's failure to adequately compensate for the wind conditions during landing resulting in a ground loop/swerve. Wind gusts were a contributing factor.Jun 2, 2002 · N9967Q · Substantial damageNTSB NYC02LA111Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Toughkenamon, PAThe pilot's failure to maintain directional control while landing, a factor was the gusting wind conditions.Jun 2, 2002 · N60812 · Substantial damageNTSB NYC02LA108Accident · No injuriesLimited investigationFinal reportCessna 182B · Littlestown, PAThe pilot's improper flair, which resulted in a hard landing. A factor in this accident was the crosswind condition.Jun 2, 2002 · N2555G · Substantial damageNTSB FTW02LA171Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Dalhart, TXThe pilot's failure to maintain aircraft control. Contributing factors were the shifting gusty winds and the ditch.Jun 2, 2002 · N4261Q · Substantial damageNTSB CHI02LA147Accident · No injuriesLimited investigationFinal reportWaco ASO · Goodland, KSFailure of the tailwheel assembly after touchdown that resulted in loss of airplane directional control, which the pilot could not correct. A contributing factor was the improper assembly of the tailwheel.Jun 2, 2002 · NC662Y · Substantial damageNTSB NYC02LA107Accident · No injuriesLimited investigationFinal reportKarl & Dot Comp Air 7SL · Cross Keys, NJFatigue fracture of the tail wheel spring, which resulted in a loss of control and impact with a ditch.Jun 1, 2002 · N753KD · Substantial damageNTSB IAD02LA055Accident · No injuriesLimited investigationFinal reportCessna 182Q · Rutland, VTThe pilot's failure to attain the proper touchdown point. A factor was the crosswindJun 1, 2002 · N97996 · Substantial damageNTSB CHI02TA149Accident · No injuriesFinal reportCessna A185F · Necedah, WIDirectional control of the airplane not maintained by the pilot. The gusting winds was a contributing factor.Jun 1, 2002 · N185NR · Substantial damageNTSB FTW02LA169Accident · No injuriesLimited investigationFinal reportGolias RV6 · Leander, TXthe pilot's failure to maintain directional control while landing. Contributing factor is the pilot's improper recovery from a bounced landing.May 31, 2002 · N16PG · Substantial damageNTSB NYC02LA105Accident · No injuriesLimited investigationFinal reportBell 206 · Columbus, OHThe flight instructor's delay in applying remedial action. A factor in the accident was the pilot allowing the rotor rpm to become too low during the deceleration and touchdown phase of the autorotation.May 30, 2002 · N820H · Substantial damageNTSB FTW02LA166Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Nageezi, NMthe pilot's failure to select a suitable landing site, which resulted in a collision with a fence.May 30, 2002 · N9051D · Substantial damageNTSB ATL02IA112Incident · Minor injuriesIncident investigationFinal reportCessna 210L · Sarasota, FLThe pilot's failure to follow the before landing checklist and confirm that the landing gear was extended.May 30, 2002 · N7PJ · Minor damageNTSB SEA02LA086Accident · No injuriesLimited investigationFinal reportGrumman American AA-5A · Vancouver, WAThe pilot's delayed remedial action during the landing sequence. Factors include a wet runway surface.May 28, 2002 · N26221 · Substantial damageNTSB CHI02LA144Accident · No injuriesLimited investigationFinal reportMitsubishi MU2B-20 · Belleville, MIThe pilot's failure to verify the extension of the landing gear prior to landing, and his failure to perform the emergency landing gear extension procedure. The popped circuit breaker was a factor.May 28, 2002 · N54CK · Substantial damageNTSB SEA02LA088Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Lewiston, IDThe pilot's failure to maintain directional control during the landing resulting in the aircraft departing the runway environment and the wing impacting the ground. Contributing factors were the dustdevil/whirlwind which the aircraft encountered and the ditch.May 27, 2002 · N9845Q · Substantial damageNTSB SEA02LA089Accident · No injuriesLimited investigationFinal reportArtic S-1B2 · Tumtum, WAThe pilot's improper flare.May 26, 2002 · N69AG · Substantial damageNTSB LAX02LA175Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Willits, CAthe pilot's inadequate compensation for wind conditions and his failure to maintain directional control. Factors in the accident were the pilot's failure to raise the flaps and the wind shear conditions.May 26, 2002 · N28145 · Substantial damageNTSB IAD02LA054Accident · Minor injuriesLimited investigationFinal reportMiller Barnet J4B-2 · Manville, NJThe pilot's improper flare prior to touchdown. A factor was the pilot's lack of experience in aircraft type, make, and model.May 26, 2002 · N8121M · Substantial damageNTSB FTW02LA167Accident · No injuriesLimited investigationFinal reportAero Commander 500-S · La Porte, TXThe failure of a hydraulic line, which resulted in the loss of the brakes.May 25, 2002 · N98TT · Substantial damageNTSB FTW02LA164Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Jonesville, LAthe pilot's failure to attain the proper touchdown point, which resulted in a runway overrun and an on ground encounter with terrain.May 24, 2002 · N8302Y · Substantial damageNTSB LAX02LA171Accident · No injuriesLimited investigationFinal reportCessna 206 · Mohave Valley, AZthe pilot's failure to maintain directional control.May 22, 2002 · N5050U · Substantial damageNTSB DEN02LA045Accident · No injuriesLimited investigationFinal reportCessna 172K · Cedar City, UTthe pilot's inadvertent stall/mush during the landing flare/touchdown. A contributing factor was the gusty crosswind weather conditions.May 22, 2002 · N78760 · Substantial damageNTSB ANC02LA037Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Soldotna, AKThe pilot's inadequate compensation for a crosswind during the landing roll. A factor was the presence of a crosswind.May 21, 2002 · N2514M · Substantial damageNTSB LAX02LA167Accident · No injuriesLimited investigationFinal reportCessna 172S · Scottsdale, AZthe student pilot's improper recovery from a bounced landing and failure to maintain directional control on the landing roll, which resulted in a collision with a runway sign.May 20, 2002 · N3547H · Substantial damageNTSB LAX02LA168Accident · No injuriesLimited investigationFinal reportCessna 170B · Show Low, AZThe pilot's improper recovery from a bounced landing resulted in a loss of aircraft control. A factor was a sudden wind shift on final approach.May 19, 2002 · N4338B · Substantial damageNTSB FTW02LA156Accident · No injuriesLimited investigationFinal reportLake LA4-200 · Frankston, TXthe pilot's failure to adequately compensate for wind conditions while landing on the water which resulted in a water loop/swerve. A contributing factor was a wind gust.May 19, 2002 · N1298L · Substantial damageNTSB FTW02LA165Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Palestine, TXThe failure of the nose gear actuator aft attach point from the tube cluster on the engine mount assembly. A contributing factor was the owner's non-compliance with the service bulletin for inspection/replacement of the engine mount.May 18, 2002 · N529TX · Substantial damageNTSB LAX02LA165Accident · No injuriesLimited investigationFinal reportCessna 182Q · San Diego, CAThe pilot's failure to apply continuous brake pressure. Sun glare is a contributing factor.May 17, 2002 · N9031U · Substantial damageNTSB ANC02TA036Accident · No injuriesFinal reportPiper PA-18 · Holy Cross, AKThe pilot's selection of unsuitable terrain for landing. A factor in the accident was the presence of high vegetation (willows) along the right side of the landing area.May 16, 2002 · N82735 · Substantial damageNTSB ANC02LA034Accident · No injuriesLimited investigationFinal reportCessna 170B · North Pole, AKThe separation of the right main landing gear from the airplane during landing. A factor associated with the accident is the unapproved hardware used to attach the main landing gear.May 16, 2002 · N4669C · Substantial damageNTSB ATL02LA098Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Tuscaloosa, ALThe pilots loss of directional control during landing roll, and subsequent inadvertent ground loop.May 13, 2002 · N2243M · Substantial damageNTSB ANC02LA033Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Yakutat, AKThe collapse of the left main landing gear during the landing roll due to a fractured main gear leg strut.May 13, 2002 · N3JK · Substantial damageNTSB SEA02LA081Accident · Minor injuriesLimited investigationFinal reportCook Coot A · Harrison, IDThe pilot's failure to detect an unsafe boat wake during the landing process, and his inadvertent initiation of a porpoise after coming in contact with the boat wake just after touchdown on a body of water. Factors include a large wake wave/swell created by…May 12, 2002 · N12QQ · Substantial damageNTSB SEA02LA080Accident · No injuriesLimited investigationFinal reportAeronca 7-EC · Flying M Ranch, ORThe pilot's failure to maintain directional control while applying the brakes during the landing roll. Factors include a tailwind and trees at the far end of the airstrip.May 12, 2002 · N4712E · Substantial damageNTSB SEA02LA079Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · South Prairie, WAThe pilot's improper touchdown point. Factors include a wet landing surface.May 11, 2002 · N321D · Substantial damageNTSB LAX02LA159Accident · No injuriesLimited investigationFinal reportCessna 170B · San Diego, CAThe failure of the dual student to maintain directional control of the airplane and the instructor's delayed the remedial action, which resulted in a ground loop. A factor in the accident was the gusting crosswind conditions.May 11, 2002 · N3462C · Substantial damageNTSB LAX02LA158Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Reno, NVFailure of the pilot to maintain directional control. A factor was the hump in the runway.May 11, 2002 · N3772A · Substantial damageNTSB LAX02LA156Accident · No injuriesLimited investigationFinal reportHam Pitts S-1C · Borrego Springs, CAThe failure of the pilot to maintain control of the airplane during landing rollout resulting in a ground loop/swerve and a nose over. The soft terrain was a factor.May 11, 2002 · N1PH · Substantial damageNTSB FTW02LA146Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7B-15 · Port Allen, LAThe pilot's decision to land in the sugar cane field, which resulted in the pilot's unintentional exit from the basket. A contributing factor was the high vegetation in the field.May 11, 2002 · N25360 · No damageNTSB ATL02LA096Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Livingston, TNThe pilot failure to maintain flying speed, followed by a subsequent stall.May 11, 2002 · N8608B · Substantial damageNTSB IAD02LA050Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Norwood, MAThe student pilot's failure to maintain directional control during an aborted landing.May 10, 2002 · N172EF · Substantial damageNTSB CHI02LA126Accident · No injuriesLimited investigationFinal reportPiper PA 28-181 · Sandwich, ILThe driver of the automobile improperly drove his automobile on the active runway and did not maintain visual lookout for landing aircraft.May 10, 2002 · N276U · Substantial damageNTSB FTW02LA149Accident · No injuriesLimited investigationFinal reportCessna 152 · Houston, TXthe student pilot's improper recovery from a bounced landing, which resulted in a nose over.May 9, 2002 · N48819 · Substantial damageNTSB CHI02LA130Accident · No injuriesLimited investigationFinal reportCessna 180 · Hyannis, NEThe pilot did not maintain directional control and executed improper use of the brakes. A factor associated with the accident was the soft terrain.May 9, 2002 · N9135C · Substantial damage