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 DEN03LA127Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Ogden, UTthe failure of the landing gear retraction/extension assembly due to the improper rigging of the landing gear.Jun 28, 2003 · N8547P · Substantial damageNTSB SEA03CA119Accident · No injuriesData collectionFinal reportCessna P206 · Gooding, IDImproper flare while landing. Factors include inadequate preflight preparation and a tow bar that had not been removed prior to the flight.Jun 27, 2003 · N2825X · Substantial damageNTSB NYC03LA144Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Newcomerstown, OHThe pilot's failure to obtain the proper touchdown point and delayed go-around. Factors in this accident were the up sloping runway.Jun 27, 2003 · N9067A · Substantial damageNTSB CHI03LA290Accident · No injuriesLimited investigationFinal reportCessna 172N · Romeo, MIThe pilot not maintaining directional control during landing. A factor to the accident was the parked airplane.Jun 27, 2003 · N739NW · Substantial damageNTSB SEA03LA122Accident · No injuriesLimited investigationFinal reportCessna 185F · Lexington, ORThe pilot's failure to maintain aircraft control during the landing roll. A partially deflated tire and soft terrain were factors.Jun 26, 2003 · N6497E · Substantial damageNTSB FTW03LA177Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Bristow, OKThe pilot's premature retracting of the flaps, and his failure to maintain airspeed which resulted in an inadvertent stall.Jun 25, 2003 · N20679 · Substantial damageNTSB FTW03LA176Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Beaumont, TXThe instructor's delay in executing a go-around and his failure to maintain aircraft control due to inadequate compensation of wind gusts. A contributing factor was the gusty winds.Jun 22, 2003 · N753MF · Substantial damageNTSB FTW03LA175Accident · Serious injuriesLimited investigationFinal reportCessna 172L · San Antonio, TXThe pilot misjudged his altitude and airspeed, and his failure to perform a go-around.Jun 22, 2003 · N912KD · Substantial damageNTSB CHI03LA177Accident · No injuriesLimited investigationFinal reportWaco ARE · Battle Creek, MIThe inadequate material used in the landing gear cross supports leading to its collapse during the landing roll.Jun 22, 2003 · N20953 · Substantial damageNTSB NYC03LA143Accident · Serious injuriesLimited investigationFinal reportAerostar International RX 8 · Grove City, OHThe passengers failure to maintain her balance inside the balloon basket.Jun 21, 2003 · N71696 · No damageNTSB IAD03CA059Accident · No injuriesData collectionFinal reportPiper Saratoga II TC PA32- · Mansfield, OHThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control during the landing. A factor was the gusty wind conditions.Jun 21, 2003 · N9298D · Substantial damageNTSB CHI03LA173Accident · Serious injuriesLimited investigationFinal reportAerostar S-55A · Monroe, WIThe pilot's failure to maintain clearance from the transmission wires during landing and his decision to jump from the balloon. A factor to the accident was the power transmission lines.Jun 21, 2003 · N5253Y · No damageNTSB ATL03LA110Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Hatteras, NCThe pilot's failure to maintain directional control during the landing roll. A factor was a go-around not performed.Jun 21, 2003 · N9234Z · Substantial damageNTSB SEA03LA109Accident · No injuriesLimited investigationFinal reportMaule M-7-235C · Moses Lake, WAThe pilot's inadequate compensation for wind conditions during the landing roll. Factors include gusty crosswinds.Jun 20, 2003 · C-FCDM · Substantial damageNTSB NYC03FA132Accident · 1 fatalField investigationFinal reportAviat A-1 · Tyringham, MAThe pilot's incapacitation due to a heart attack, which resulted in a loss of aircraft control.Jun 19, 2003 · N49369 · DestroyedNTSB CHI03LA169Accident · Minor injuriesLimited investigationFinal reportCessna 182L · Atchison, KSThe pilot's inadequate inflight decision, which resulted in a landing with a tailwind and an overrun of the runway. Factors contributing to the accident were the tailwind encountered on landing rollout, the variable, gusty winds encountered while in the…Jun 19, 2003 · N42713 · Substantial damageNTSB MIA03CA125Accident · No injuriesData collectionFinal reportCessna 172S · Melbourne, FLThe pilot's improper flare and inadequate recovery from a bounced landing. Contributing factors were the pilot's failure to maintain directional control and his failure to execute a go-around.Jun 18, 2003 · N53352 · Substantial damageNTSB CHI03LA167Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Atwood, ILThe pilot's selection of an unsuitable landing area and his improper decision to continue the approach without the airport and runway clearly in-sight. Factors contributing to the accident were the pilot's disorientation, the transmission wires, and the road…Jun 18, 2003 · N94327 · Substantial damageNTSB SEA03LA113Accident · No injuriesLimited investigationFinal reportCessna 206 · Soldier Bar, IDThe overload failure of the nose landing gear assembly during the landing roll, due to an improper maintenance installation. A factor was the rough/uneven terrain condition.Jun 17, 2003 · N7372Q · Substantial damageNTSB SEA03LA108Accident · No injuriesLimited investigationFinal reportMcCarty Avid Magnum · Renton, WAThe flight instructor's unexpected encounter with control interference when the student applied brakes during the landing roll.Jun 17, 2003 · N64KM · Substantial damageNTSB NYC03LA160Accident · No injuriesLimited investigationFinal reportMooney M20E · Guilford, OHThe pilot's misjudged speed and distance while landing, and his failure to do a go-around.Jun 16, 2003 · N3220F · Substantial damageNTSB DEN03LA106Accident · No injuriesLimited investigationFinal reportCessna 180 · Ogden, UTthe pilot's inadequate compensation for wind conditions and his failure to maintain directional control.Jun 16, 2003 · N9221C · Substantial damageNTSB ATL03LA119Accident · No injuriesLimited investigationFinal reportCessna 182J · Southern Pines, NCThe pilot's improper landing flare which resulted in a hard landing.Jun 16, 2003 · N3435F · Substantial damageNTSB SEA03LA103Accident · No injuriesLimited investigationFinal reportCessna 172P · Seattle, WAThe dual student's failure to maintain aircraft control and the flight instructor's delayed remedial action. Contributing factors were the crosswind condition and the flight instructor's lack of experience.Jun 15, 2003 · N9566L · Substantial damageNTSB FTW03LA179Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Spring, TXThe failure of the pilot to maintain aircraft control due to wake turbulence.Jun 14, 2003 · N81268 · Substantial damageNTSB CHI03LA164Accident · No injuriesLimited investigationFinal reportMcCulloch J-2 · Magnolia, ARThe pilot's inadequate weight a balance calculations and inadequate preflight planning.Jun 14, 2003 · N4381G · Substantial damageNTSB CHI03LA163Accident · No injuriesLimited investigationFinal reportCessna 172N · Anoka, MNThe pilot's failure to attain the proper touchdown point, and his failure to maintain directional control. Contributing factors were the pilot's lack of experience, and the runway sign.Jun 14, 2003 · N2238E · Substantial damageNTSB LAX03TA204Accident · No injuriesFinal reportEurocopter France AS 350 B2 · Riverside, CAThe flying pilot's failure to align the helicopter during a simulated emergency landing, which resulted in a hard landing and structural damage to the helicopter. A factor associated with the accident was the check pilot's failure to initiate remedial action.Jun 13, 2003 · N6087C · Substantial damageNTSB CHI03LA162Accident · No injuriesLimited investigationFinal reportNew Standard D-25 · West Bend, WIThe pilot's excessive braking during landing roll. Contributing factors to this accident were the pilot's lack of experience in the accident airplane.Jun 13, 2003 · N930V · Substantial damageNTSB ANC03LA059Accident · No injuriesLimited investigationFinal reportWilliamson Glastar · Anchorage, AKThe pilot's failure to maintain directional control of the airplane during an aborted landing, which resulted in the airplane impacting trees along the side of the runway. A factor contributing to the accident was the pilot's improper recovery from a bounced…Jun 13, 2003 · N62849 · Substantial damageNTSB SEA03LA099Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Laurel, MTAircraft control was not maintained during the landing roll. The aircraft subsequently nosed over.Jun 12, 2003 · N5779D · Substantial damageNTSB NYC03LA128Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Crisfield, MDThe pilot's inadequate recovery from a bounced landing and his improper flare which resulted in a hard landing. Contributing factors were the windshear and the crosswind.Jun 12, 2003 · N1198Q · Substantial damageNTSB LAX03LA195Accident · No injuriesLimited investigationFinal reportBoeing Stearman E75 · Casa Grande, AZThe pilot's inadequate compensation for the wind conditions, and his failure to maintain aircraft control resulting in an inadvertent ground loop.Jun 12, 2003 · N6030V · Substantial damageNTSB LAX03CA203Accident · No injuriesData collectionFinal reportMooney M20J · Lincoln, CAThe pilot's failure to extend the landing gear prior to landing.Jun 12, 2003 · N1156N · Substantial damageNTSB FTW03LA172Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Houston, TXThe pilot's failure to maintain rotor RPM and the improper landing flare resulting in a hard landing. A contributing factor was the prevailing high winds.Jun 12, 2003 · N7198H · Substantial damageNTSB LAX03LA191Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 Beta · Phoenix, AZThe student pilot's improper use of the throttle control, the certified flight instructor (CFI) inadequate supervision, and the student's control interference, which resulted in a loss of main rotor rpm.Jun 11, 2003 · N7508D · Substantial damageNTSB ANC03LA058Accident · Minor injuriesLimited investigationFinal reportCessna 140A · Anchorage, AKThe pilot's excessive application of the brakes during the landing roll of a short field landing, which resulted in the airplane nosing over.Jun 11, 2003 · N9667A · Substantial damageNTSB NYC03LA126Accident · No injuriesLimited investigationFinal reportAmerican Champion 7EC · Louisville, KYThe pilots inadequate compensation for the crosswind conditions, and his failure to maintain directional control. A factor related to the accident was the crosswind.Jun 10, 2003 · N607EC · Substantial damageNTSB ANC03LA065Accident · No injuriesLimited investigationFinal reportCessna 402B · Telida, AKThe pilot's selection of an unsuitable landing site, which resulted in the collapse of the nose landing gear. A factor in the accident was a soft runway.Jun 9, 2003 · N710WS · Substantial damageNTSB ANC03LA056Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Teller, AKThe pilot's inadequate compensation for a crosswind and his failure to maintain directional control during the landing roll, resulting in a loss of control and nose down of the airplane. A factor in the accident was a crosswind.Jun 9, 2003 · N2475M · Substantial damageNTSB LAX03LA186Accident · No injuriesLimited investigationFinal reportCessna 172S · Prescott, AZThe student pilot's inadequate compensation for the wind conditions and failure to maintain directional control. Also causal was the flight instructor's inadequate supervision of the flight in allowing the student to perform a solo flight with a strong,…Jun 8, 2003 · N519ER · Substantial damageNTSB DEN03LA100Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G102 Standard III · Moriarty, NMthe pilot's improper flare, and his failure to recover from the subsequent bounced landing. Contributing factors include the sudden wind shift and the tail wind.Jun 8, 2003 · N850BG · Substantial damageNTSB NYC03LA125Accident · No injuriesLimited investigationFinal reportCessna 172L · Newburyport, MAThe pilot's failure to attain the proper touchdown point.Jun 7, 2003 · N7149Q · Substantial damageNTSB FTW03LA169Accident · Minor injuriesLimited investigationFinal reportKilishek RV-8 · Crawford, TXThe pilot's intentional ground looping of the airplane. A contributing factor was the pilot's improper in-flight planning resulting in an improper selection of a touchdown point.Jun 7, 2003 · N888GK · Substantial damageNTSB NYC03LA130Accident · No injuriesLimited investigationFinal reportMooney M20J · Montauk, NYThe pilot's failure to maintain directional control. A factor in this accident was the crosswind condition.Jun 6, 2003 · N1077V · Substantial damageNTSB NYC03LA123Accident · No injuriesLimited investigationFinal reportCessna R172K · Warrenton, VAThe pilot's inadequate compensation the shifting wind conditions, and his failure to maintain directional control. A factor related to the accident was the shifting wind conditions.Jun 6, 2003 · N736AT · Substantial damageNTSB CHI03LA157Accident · No injuriesLimited investigationFinal reportCessna 140A · Grinnell, IAThe pilot's inadvertent ground loop. Factors contributing to the accident were the wind gusts and crosswind conditions.Jun 5, 2003 · N5667C · Substantial damageNTSB NYC03LA118Accident · No injuriesLimited investigationFinal reportAmerican Champion 7GCAA · Frederick, MDThe certified flight instructor's improper flare and his delayed remedial action. The pilot's failure to maintain directional control is a contributing factor.Jun 3, 2003 · N77GA · Substantial damageNTSB CHI03LA147Accident · Serious injuriesLimited investigationFinal reportAerostar S-77A · Cottage Grove, MNThe inadequate touchdown by the pilot.Jun 3, 2003 · N52461 · No damageNTSB FTW03LA165Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Gainesville, TXThe pilot's failure to maintain directional control while landing. Contributing factors were the prevailing crosswind and the pilot's failure to abort landing.Jun 2, 2003 · N51611 · Substantial damage