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 NYC04LA140Accident · No injuriesLimited investigationFinal reportAviat Pitts S2B · Hamilton, OHThe pilot's failure to maintain directional control after experiencing a brake system malfunction during landing. Factors related to the accident were the malfunction of a landing gear brake as reported by the pilot, and the crosswind conditions.Jun 13, 2004 · N963CB · Substantial damageNTSB DEN04CA092Accident · No injuriesData collectionFinal reportSchweizer 269C · Englewood, COthe settling with power situation encountered by the pilot. Contributing to the accident was the high density altitude.Jun 13, 2004 · N2062N · Substantial damageNTSB CHI04CA156Accident · No injuriesData collectionFinal reportYoukey Lancair 235 · Hays, KSThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control of the airplane during the landing roll. Factors associated with the accident were the gusty crosswind, the runway marker sign, and the taxiway lights…Jun 13, 2004 · N70718 · Substantial damageNTSB CHI04CA150Accident · No injuriesData collectionFinal reportMaule MX7235 · Waukesha, WIThe pilot failed to maintain directional control and his inadequate compensation for wind conditions. Factors associated with the accident were the gusty crosswind and the concrete culvert that the airplane contacted.Jun 13, 2004 · N5664R · Substantial damageNTSB ANC04LA068Accident · No injuriesLimited investigationFinal reportCessna 185 · Skwentna, AKThe pilot's inadequate compensation for wind conditions and his inadequate flare while landing, which resulted in a hard landing and collapse of the main landing gear. Factors associated with the accident were a downdraft, and rough and uneven terrain.Jun 13, 2004 · N185AV · Substantial damageNTSB ANC04LA064Accident · No injuriesLimited investigationFinal reportdeHavilland DHC-2 · Wasilla, AKThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in a collision with a log. Factors contributing to the accident were a tailwind, a lack of brake pedals at the second pilot station, and the second…Jun 13, 2004 · N105RL · Substantial damageNTSB FTW04CA161Accident · No injuriesData collectionFinal reportRuehle Glastar · Lancaster, TXThe pilot's improper flare resulting in a hard landing.Jun 12, 2004 · N106WR · Substantial damageNTSB FTW04IA160Incident · Minor injuriesIncident investigationFinal reportEmbraer EMB-135LR · Dallas, TXThe loss of pressure in Electrohydraulic Servovalve (EHSV) within the nose wheel steering manifold due to contamination in the C1 orifice of the valve, which resulted in an uncommanded turn of the nose wheel during landing rollout. A contributing factor was…Jun 11, 2004 · N843RP · Minor damageNTSB CHI04CA154Accident · Serious injuriesData collectionFinal reportMooney M20C · Golden, MOThe pilot's failure to maintain directional control and his failure to maintain clearance from the trees. The trees were a contributing factor.Jun 10, 2004 · N3911N · Substantial damageNTSB CHI04CA152Accident · No injuriesData collectionFinal reportCessna 172N · Hillsboro, NDDirectional control not obtained/maintained by the pilot during landing roll.Jun 10, 2004 · N737SV · Substantial damageNTSB NYC04CA138Accident · No injuriesData collectionFinal reportCessna 152 · Elyria, OHThe student pilot's inadequate recovery from a bounced landing.Jun 9, 2004 · N802MC · Substantial damageNTSB LAX04LA235Accident · 1 fatalLimited investigationFinal reportHarold W Bruce RV-6 · Cloverdale, CAthe pilot's inadequate in-flight planning/decision and selection of the wrong runway, and his inadequate compensation for the gusting tail wind conditions, which resulted in a stall/mush.Jun 9, 2004 · N621BP · DestroyedNTSB CHI04CA139Accident · No injuriesData collectionFinal reportCessna TR182 · Hamberg, NDThe pilot's inadequate in-flight planning/decision and his misjudgment of speed and distance.Jun 6, 2004 · N736QX · Substantial damageNTSB ANC04LA061Accident · No injuriesLimited investigationFinal reportCessna 170B · Dillingham, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the airplane nosing over during the landing flare/touchdown. A factor contributing to the accident was soft tundra terrain.Jun 6, 2004 · N2631D · Substantial damageNTSB DEN04LA084Accident · No injuriesLimited investigationFinal reportCessna 310J · Morgan, UTthe poor friction value on the runway rendering braking action inadequate. Contributing factors include the excessive approach speed, and the pilot's inability to maintain directional control of the aircraft.Jun 5, 2004 · N415SW · Substantial damageNTSB CHI04LA137Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Blissfield, MIThe pilot selected the wrong runway on which to land which resulted in exceeding the proper touchdown point during landing. Factors associated with the accident were the tailwind condition and the drainage ditch which the airplane contacted.Jun 4, 2004 · N9401B · Substantial damageNTSB FTW04LA151Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Weldon, ARThe other pilot's failure to maintain an adequate visual lookout during approach to landing, which resulted in a midair collision between the two airplanes.Jun 3, 2004 · N5002D · 2 aircraft · Minor damageNTSB DEN04CA085Accident · Serious injuriesData collectionFinal reportLet Blanik L-13 · Durango, COthe pilot's improper in-flight planning and decision and his failure to maintain adequate terrain clearance. Contributing to the accident was the lack of suitable terrain, and the low approach.Jun 3, 2004 · N99860 · Substantial damageNTSB LAX04CA236Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Dunsmuir, CAthe pilot's misjudgment of speed and distance, which resulted in an overrun of the runway. The pilot's failure to use flaps and his landing at an airport with a runway shorter than he expected is a contributing factor.Jun 2, 2004 · N39678 · Substantial damageNTSB LAX04CA222Accident · No injuriesData collectionFinal reportCessna A188A · Minden, NVthe pilot's failure to maintain directional control of the airplane during landing roll, which resulted in an inadvertent ground loop. A contributing factor was the pilot's lack of experience in the accident airplane.Jun 2, 2004 · N9961G · Substantial damageNTSB LAX04LA245Accident · No injuriesLimited investigationFinal reportCessna 170B · Auburn, CAthe pilot's failure to maintain directional control of the airplane, which resulted in an inadvertent ground loop.Jun 1, 2004 · N2915D · Substantial damageNTSB LAX04CA224Accident · No injuriesData collectionFinal reportCessna 177B · Grand Canyon, AZthe pilot's inadequate compensation for crosswind conditions, which resulted in a loss of directional control.May 31, 2004 · N7PP · Substantial damageNTSB FTW04LA146Accident · No injuriesLimited investigationFinal reportCessna 172P · Mesquite, TXThe student pilot's delayed landing flare and the improper supervision provided by the flight instructor.May 31, 2004 · N98885 · Substantial damageNTSB FTW04LA145Accident · No injuriesLimited investigationFinal reportCessna 172 · Levelland, TXThe student pilot's failure to maintain directional control and his inadequate compensation for the winds.May 31, 2004 · N61663 · Substantial damageNTSB SEA04LA096Accident · No injuriesLimited investigationFinal reportCessna 172M · Vernonia, ORThe instructor pilot's misjudgment of speed and distance and his failure to execute a go-around resulting in an overrun of the runway.May 29, 2004 · N5440H · Substantial damageNTSB NYC04CA135Accident · No injuriesData collectionFinal reportMooney M20R · Warren, VTThe pilot's improper flare, which resulted in a hard landing. A factor in this accident was the wind shear as reported by the pilot.May 29, 2004 · N53WM · Substantial damageNTSB NYC04CA134Accident · Serious injuriesData collectionFinal reportCessna 172M · Worcester, MAThe pilot's improper recovery from a bounced landing, and his inadequate compensation for wind conditions. A factor in the accident was the gusting wind.May 29, 2004 · N73704 · Substantial damageNTSB MIA04CA091Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Carthage, MSThe failure of the student pilot to maintain control of the airplane resulting in the airplane departing the runway and impacting with terrain. A factor related to this accident was the student pilot's lack of total flight experience.May 29, 2004 · N2484A · Substantial damageNTSB FTW04LA155Accident · No injuriesLimited investigationFinal reportSchreder HP-11A · Cherry Valley, ARThe pilot's improper flare which resulted in a stall and hard landing.May 29, 2004 · N678P · Substantial damageNTSB ANC04LA062Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in an inadvertent ground loop and subsequent structural damage to the airplane when it struck the runway.May 29, 2004 · N2514D · Substantial damageNTSB DCA04MA049Accident · No injuriesMajor investigationFinal reportRaytheon Corporate Jets 390 Premier I · North Las Vegas, NVThe flight's unstabilized approach and excessive speed. Contributing to the excessive touchdown speed was the presence of a tailwind at landing.May 27, 2004 · N5010X · Substantial damageNTSB FTW04CA140Accident · Minor injuriesData collectionFinal reportBeech BE-58P · Oklahoma City, OKThe pilot's failure to attain the proper touchdown point of the runway. Contributing factors were the excessive airspeed and the pilot's failure to initiate a go-around.May 26, 2004 · N72SC · Substantial damageNTSB DEN04LA081Accident · Minor injuriesLimited investigationFinal reportBellanca 7KCAB · Peyton, COthe pilot's inadequate in-flight planning and decision making and his failure to maintain aircraft control during the landing flare which resulted in impact with terrain. Contributing factors include the pilot's failure to perform a go-around and the wind…May 26, 2004 · N4173Y · Substantial damageNTSB LAX04TA264Accident · No injuriesFinal reportBell 212HP · Chester, CAthe pilot's excessive use of the cyclic and collective controls in response to the helicopter's unexpected rocking motion, which led to a main rotor contact with the upper wire cutter mounted on the cabin roof. A factor in the accident was the rough, sloping…May 25, 2004 · N362EH · Substantial damageNTSB LAX04CA220Accident · No injuriesData collectionFinal reportLet Blanik L-13 · Sparks, NVthe student pilot's misjudged altitude, distance, and speed, and failure to attain the proper touchdown point, resulting in an overshoot of the runway.May 24, 2004 · N53AS · Substantial damageNTSB FTW04CA139Accident · No injuriesData collectionFinal reportAir Tractor AT-402 · Beedeville, ARThe pilot's failure to maintain directional control of the airplane during landing roll-out. Contributing factors were the crosswind and condition of the the runway.May 24, 2004 · N45553 · Substantial damageNTSB ATL04LA122Accident · Serious injuriesLimited investigationFinal reportQuicksilver GT-500 · Cleveland, GAThe student pilot's failure to maintain directional control and his inadequate compensation for wind during takeoff. A factor was crosswind condition.May 24, 2004 · N5XY · Substantial damageNTSB LAX04CA231Accident · No injuriesData collectionFinal reportGlenn L Smith RV-8 · Boulder City, NVthe pilot's failure to maintain directional control of the airplane. Contributing to the accident was a sudden wind shift.May 23, 2004 · N767GS · Substantial damageNTSB ATL04CA121Accident · No injuriesData collectionFinal reportBeech BE-24 · Chamblee, GAThe pilot's failure to use checklist resulted in a gear-up landing.May 23, 2004 · N6005H · Substantial damageNTSB DEN04CA072Accident · Serious injuriesData collectionFinal reportLindstrand Balloons 180A · Ridgeway, COthe sudden wind gusts and the pilot's failure to maintain control of the balloon resulting in the balloon's basket impacting two vehicles and a house, and subsequently impacting the terrain. Factors relating to the accident were the two vehicles, the house,…May 22, 2004 · N60181 · Minor damageNTSB LAX04CA219Accident · No injuriesData collectionFinal reportCessna R172K · Hawthorne, CAthe pilot's misjudged flare and failure to maintain adequate airspeed, resulting in a stall and hard landing. Factors in the accident were the night conditions and the pilot's lack of familiarity in the make and model of airplane.May 21, 2004 · N758ND · Substantial damageNTSB MIA04FA086Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Venice, FLFailure of the pilot to recover from an improper landing flare resulting in his failure to maintain airspeed (Vs), an inadvertant stall, loss of control, and inflight collision with terrain during an uncontrolled descent.May 20, 2004 · N3331W · Substantial damageNTSB LAX04CA217Accident · No injuriesData collectionFinal reportPiper PA-34-200T · Livermore, CAthe pilot's failure to maintain directional control.May 20, 2004 · N5361R · Substantial damageNTSB LAX04CA214Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Chandler, AZthe pilot's improper application of brakes during the landing roll, resulting in a nose over.May 19, 2004 · N62712 · Substantial damageNTSB ATL04CA120Accident · No injuriesData collectionFinal reportStinson SR-8E · Peachtree City, GAThe pilot's failure to maintain directional control on landing roll out resulting in a loss of control and ground loop.May 18, 2004 · N16181 · Substantial damageNTSB MIA04CA085Accident · No injuriesData collectionFinal reportCessna 172N · Pembroke Pines, FLThe pilot's failure to establish a climb and his failure to maintain directional control of the airplane during an aborted landing leading to the airplane departing the runway and incurring substantial damage.May 17, 2004 · N737FE · Substantial damageNTSB SEA04LA087Accident · No injuriesLimited investigationFinal reportCessna 185A · Polson, MTThe pilot's inadequate compensation for the changing wind conditions at the time of the landing. Factors include gusty, variable, crosswinds, and a runway marker near the edge of the runway the pilot was landing on.May 16, 2004 · N1624H · Substantial damageNTSB NYC04LA130Accident · Minor injuriesLimited investigationFinal reportHigh Craft Buccaneer · Glasco, NYThe pilot's failure to maintain airspeed during landing, which resulted in an inadvertent stall and subsequent impact with the water. A factor was the pilot's lack of experience in the airplane and his diverted attention.May 16, 2004 · UNREG · Substantial damageNTSB LAX04LA211Accident · No injuriesLimited investigationFinal reportCessna T182T · Paulden, AZThe pilot's inadequate compensation for the wind conditions and failure to maintain an adequate airspeed.May 15, 2004 · N5341G · Substantial damageNTSB LAX04CA212Accident · No injuriesData collectionFinal reportBeech A60 · Gualala, CAthe pilot's inadequate in-flight planning which resulted in a downwind landing. The tailwind was a contributing factor and an overrun of the runway.May 15, 2004 · N931RP · Substantial damage