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 CHI04CA020Accident · Minor injuriesData collectionFinal reportShapowal Rotorway Exec 90 · Cushing, MNSelection of an unsuitable landing area by the pilot due to the static wire across the approach path. Contributing factors were the pilot's disorientation, the static wire and the low light (dusk) conditions.Oct 24, 2003 · N442DS · Substantial damageNTSB LAX04CA023Accident · No injuriesData collectionFinal reportCessna 172M · Montague, CAthe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control.Oct 23, 2003 · N80543 · Substantial damageNTSB ATL04LA022Accident · No injuriesLimited investigationFinal reportDiamond DA 20-C1 · Murfreesboro, TNThe pilot's failure to attain adequate airspeed, which resulted in a stall mush and collision with a taxiway sign. A factor was the pilot's delay in aborting the landing.Oct 22, 2003 · N575MT · Substantial damageNTSB MIA04CA009Accident · No injuriesData collectionFinal reportCessna 172N · Melbourne, FLInadvertent full retraction of the flaps, while recovering from a bounced landing, resulting in an inadvertent stall, uncontrolled descent, and subsequent impact with terrain.Oct 21, 2003 · N734JT · Substantial damageNTSB NYC04LA015Accident · No injuriesLimited investigationFinal reportHarris BRC 540C · Leesburg, VAThe pilot in command's failure to maintain directional control and his inadvertent activation of the right rudder pedal.Oct 20, 2003 · N540CX · Substantial damageNTSB LAX04LA020Accident · No injuriesLimited investigationFinal reportCessna 170 · San Diego, CAthe pilot's inadequate preflight inspection which failed to determine the security of his seat, and his failure to maintain directional control.Oct 20, 2003 · N3979V · Substantial damageNTSB NYC04LA012Accident · Serious injuriesLimited investigationFinal reportPreiss Vans RV-9A · Deshler, OHThe pilot's improper bounced landing recovery. Factor were the pilot's excessive airspeed at touchdown, and his improper use of the wing flaps, by lowering them at touchdown.Oct 19, 2003 · N786HL · Substantial damageNTSB MIA04CA006Accident · No injuriesData collectionFinal reportPiper PA-32-300 · Everglades City, FLThe pilot's failure to maintain the proper glide path during the approach to land, which resulted in him undershooting the runway.Oct 19, 2003 · N198GM · Substantial damageNTSB SEA04LA007Accident · No injuriesLimited investigationFinal reportCessna 185 · Trout Lake, WAThe failure of the pilot to maintain directional control of the aircraft during the landing roll. A factor was the wet runway.Oct 18, 2003 · N1841R · Substantial damageNTSB ATL04LA020Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Beaufort, NCThe pilot's misjudgment of speed and distance, and his failure to perform a go-around which resulted in an overrun and on ground collision with terrain.Oct 18, 2003 · N2394W · Substantial damageNTSB ANC04LA004Accident · No injuriesLimited investigationFinal reportCessna 195B · North Pole, AKA fracture of the left brake master cylinder actuator rod, which resulted in failure of the left brake, a loss of directional control and an inadvertent ground loop during landing, and the separation of the left main landing gear strut due to fatigue. Factors…Oct 17, 2003 · N3050B · Substantial damageNTSB LAX04CA014Accident · Minor injuriesData collectionFinal reportMayfield RAF 2000 · Buckeye, AZthe pilot misjudged the landing flare.Oct 16, 2003 · N4132R · Substantial damageNTSB DEN04LA013Accident · No injuriesLimited investigationFinal reportCessna 210G · Meeker, COthe pilot's failure to extend the landing gear. Contributing to the accident was the pilots failure to recognize the gear warning horn during the landing flare.Oct 16, 2003 · N5915F · Substantial damageNTSB ATL04LA019Accident · No injuriesLimited investigationFinal reportSpegele Mustang II · Calhoun, GAThe pilot's improper flare which resulted in a hard landing and subsequent landing gear collapse.Oct 16, 2003 · N262CS · Substantial damageNTSB ATL04LA018Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Sanford, NCThe student pilot's failure to maintain directional control on landing roll resulting in a collision with a ditch, and subsequent nose over.Oct 16, 2003 · N64255 · Substantial damageNTSB MIA04CA003Accident · No injuriesData collectionFinal reportWilliam F. Lair RV-6A · Fort Myers, FLThe pilot in command's improper recovery from a bounced landing, which resulted in a hard landing and damage to the airplane.Oct 15, 2003 · N710WL · Substantial damageNTSB DEN04LA010Accident · No injuriesLimited investigationFinal reportMooney M20K · Grand Junction, COthe pilot's improper flare and his failure to maintain airspeed resulting in a stall and hard landing.Oct 14, 2003 · N5659L · Substantial damageNTSB CHI04LA013Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Schaumburg, ILThe commercial pilot not maintaining directional control of the helicopter and the improper flare initiated before landing.Oct 14, 2003 · N90463 · Substantial damageNTSB ATL04LA015Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Hickory, NCThe pilot's failure to maintain airspeed which resulted in a stall.Oct 13, 2003 · N732AG · Substantial damageNTSB LAX04LA103Accident · No injuriesLimited investigationFinal reportMooney 20F · Scottsdale, AZthe pilot's failure to maintain directional control of the airplane during landing.Oct 12, 2003 · N7127V · Substantial damageNTSB ATL04LA013Accident · No injuriesLimited investigationFinal reportCessna 172P · Pell City, ALThe pilot's inadequate compensation for wind and his failure to maintain directional control during landing. A factor was the crosswind.Oct 12, 2003 · N52254 · Substantial damageNTSB ANC04LA002Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Ketchikan, AKThe pilot's failure to maintain adequate airspeed after an aborted landing, which resulted in an inadvertent stall and a ground loop. A factor contributing to the accident was the loss of directional control on the ground.Oct 11, 2003 · N3573P · Substantial damageNTSB ANC04LA001Accident · No injuriesLimited investigationFinal reportCessna 180 · McCarthy, AKThe separation of the left main landing gear wheel from the gear leg, which resulted in a loss of directional control, and collapse of the right main landing gear. A factor contributing to the accident was the rough and uneven airstrip.Oct 10, 2003 · N9278C · Substantial damageNTSB NYC04CA005Accident · No injuriesData collectionFinal reportHoward DGA-15P · Leonardtown, MDThe pilot's failure to maintain directional control during an aborted landing.Oct 9, 2003 · N9271H · Substantial damageNTSB LAX04CA008Accident · No injuriesData collectionFinal reportVelocity XL · Casa Grande, AZthe pilot's misjudged landing flare and inadequate compensation for crosswind conditions, which resulted in his failure to maintain runway alignment.Oct 9, 2003 · N658SE · Substantial damageNTSB DEN04LA006Accident · Serious injuriesLimited investigationFinal reportFirefly Balloons Galaxy 11B · Albuquerque, NMthe pilot's failure to maintain aircraft control during a high-wind landing, resulting in a hard landing, the subsequent tipping of the balloon's basket, a post impact flash fire, and the ejection of two passengers. Contributing factors include the high wind…Oct 9, 2003 · N2190S · Substantial damageNTSB IAD04CA001Accident · No injuriesData collectionFinal reportCessna 172P · Sussex, NJThe flight instructor's failure to initiate a go-around. A factor was the wet runway conditions.Oct 4, 2003 · N98145 · Substantial damageNTSB ATL04LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Pell City, ALThe pilot's failure to follow VFR Approach procedures and to maintain visual lookout.Oct 4, 2003 · N70SR · 2 aircraft · Substantial damageNTSB ATL04LA004Accident · No injuriesLimited investigationFinal reportCessna 180K · Starkville, MSThe pilot's failure to compensate for a crosswind condition that resulted in the loss of directional control during a landing. A factor was the crosswind condition.Oct 4, 2003 · N77NP · Substantial damageNTSB CHI04LA004Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Waterloo, IAThe pilot's inadequate compensation for the wind conditions which resulted in his failure to maintain control of the airplane while landing. A factor associated with the accident was the strong, gusty wind condition.Oct 3, 2003 · N72701 · Substantial damageNTSB SEA04LA002Accident · No injuriesLimited investigationFinal reportCessna 172S · Seattle, WAImproper flare during the landing. Excessive airspeed and improper remedial action were factors.Oct 2, 2003 · N350ME · Substantial damageNTSB SEA04LA001Accident · Minor injuriesLimited investigationFinal reportCessna 340 · Blakely Island, WAThe pilot's inadequate compensation for downdrafts on final approach resulting in an excessive descent rate on short final. Factors include downdrafts off the approach end of the selected runway, and low clouds/fog.Oct 2, 2003 · N2695S · Substantial damageNTSB ATL04IA002Incident · No injuriesIncident investigationFinal reportNorth American T6G · Clayton, GAThe pilot's inadequate compensation for wind conditions that resulted in his failure to maintain directional control during landing roll. A factor was gusting tailwinds.Oct 2, 2003 · N2831D · Minor damageNTSB ATL04IA010Incident · No injuriesIncident investigationFinal reportBeech 58 · Columbus, MSThe pilot's failure to follow the pre-landing checklist, and his failure to extend the landing gear which resulted in a wheels up landing.Oct 1, 2003 · N7219H · Minor damageNTSB SEA03LA198Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Cle Elum, WAAn undershoot due to the pilot's failure to maintain a proper glide path on final approach to landing. A factor was the gravel.Sep 29, 2003 · N2291A · Substantial damageNTSB CHI03LA324Accident · No injuriesLimited investigationFinal reportBeech 35-33 · Evansville, INThe pilot not maintaining directional control during the landing roll. A contributing factor was the airport sign.Sep 29, 2003 · N978T · Substantial damageNTSB NYC03CA209Accident · No injuriesData collectionFinal reportWells Pitts S1S · Duncannon, PAThe pilot's failure to maintain directional control while landing. Factors were the gusting cross winds.Sep 27, 2003 · N465JW · Substantial damageNTSB LAX03CA301Accident · No injuriesData collectionFinal reportStarduster SA300 · Quincy, CAthe pilot's failure to maintain directional control of the airplane, which resulted in a ground loop.Sep 27, 2003 · N1698 · Substantial damageNTSB SEA03CA195Accident · No injuriesData collectionFinal reportCessna 180 H · Council, IDAircraft control not maintained during the landing roll. Factors include soft, water soaked terrain.Sep 26, 2003 · N9707G · Substantial damageNTSB FTW03LA231Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Houston, TXThe pilot's failure to maintain aircraft control during a landing. A contributing factor was the pilot's diverted attention while performing the after landing check.Sep 25, 2003 · N168ME · Substantial damageNTSB CHI03LA321Accident · No injuriesLimited investigationFinal reportCessna 305A · New Richmond, WIThe pilot's inadequate compensation for wind and his failure to maintain directional control. The pilot's in-flight selection of the wrong runway and excessive application of brake pressure are contributing factors.Sep 25, 2003 · N5237G · Substantial damageNTSB ANC03LA126Accident · No injuriesLimited investigationFinal reportCessna 170A · Skwentna, AKAn overload failure of the axle retaining nut/bolt assembly, which resulted in the separation of the axle/wheel assembly, and subsequent collapse of the right main landing gear strut during the landing roll.Sep 25, 2003 · N9006A · Substantial damageNTSB ANC03LA125Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · Cape Yakataga, AKThe pilot's failure to follow the prelanding checklist, which resulted in a wheels up landing when he neglected to lower the airplane's landing gear. A factor in the accident was the pilot's diverted attention associated with turbulence and a wet airstrip.Sep 25, 2003 · N27987 · Substantial damageNTSB SEA03LA194Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Bremerton, WAAircraft control was not maintained during the landing roll which resulted in the aircraft nosing over.Sep 24, 2003 · N9913C · Substantial damageNTSB DEN03LA156Accident · No injuriesLimited investigationFinal reportCessna R182 · Cedar City, UTthe nose wheel separating from the airplane during the precautionary landing. Factors contributing to the accident were the missing nose gear axle through-bolt and the missing cotter pin.Sep 24, 2003 · N6078C · Substantial damageNTSB LAX03FA298Accident · Serious injuriesField investigationFinal reportPiper PA-28R-200 · North Las Vegas, NVthe failure of the Federal Aviation Administration Air Traffic Control Tower local controller and local assist controller to effectively monitor the runway operation and ensure proper separation was maintained between aircraft on intersecting runways.Sep 23, 2003 · N8604N · 2 aircraft · Substantial damageNTSB ANC03LA124Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Tanana, AKThe pilot's failure to maintain aircraft control during the landing roll, which resulted in an overrun and nose down. Factors contributing to the accident were gusty winds, and restricted aileron control movement.Sep 23, 2003 · N1386A · Substantial damageNTSB CHI03LA316Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Versailles, MOThe pilot touched down with excessive airspeed. Factors associated with the accident were the trees, the wet runway, the wet grass that the airplane traveled onto, and the ditch which the airplane contacted.Sep 22, 2003 · N74LW · Substantial damageNTSB NYC03CA202Accident · Serious injuriesData collectionFinal reportCessna 182B · Spencerport, NYPilot's failure to perform a go-around.Sep 21, 2003 · N7225E · Substantial damageNTSB CHI03LA319Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Shoals, INThe pilot not maintaining a proper descent rate during the touchdown once visual reference was reduced by the dust in the rotor downwash. Factors were the dusty gravel landing area and the pilot's visual lookout not being possible due to the dust the rotor…Sep 21, 2003 · N74AE · Substantial damage