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 DEN07LA078Accident · No injuriesLimited investigationFinal reportDassault Mystere Falcon 900C · Rifle, COThe pilot's improper decision to land with excessive airspeed during the approach and failure to obtain the proper touchdown point, which resulted in a runway overrun. Contributing factors were the pilot's failure execute a missed approach, to use available…Mar 24, 2007 · N129KJ · Substantial damageNTSB ATL07CA062Accident · No injuriesData collectionFinal reportPiper PA-28A-180C · Atlanta, GAThe pilot's failure to maintain directional control of the airplane while landing with a flat main tire.Mar 24, 2007 · N4988L · Substantial damageNTSB SEA07CA080Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta 2 · Taylorsville, UTThe flight instructor's failure to maintain aircraft control during the flare/touchdown while practicing an autorotation which resulted in a hard landing. A factor which contributed to the accident was the downdraft wind condition.Mar 20, 2007 · N74347 · Substantial damageNTSB DEN07LA077Accident · No injuriesLimited investigationFinal reportPiaggio Industrie P180 · Fort Lauderdale, FLThe first officer's loss of directional control during landing causing the left main gear to collapse. Contributing factors in this accident were the flight crew's excessive use of brakes causing the left main tire to blow out, and the captain's inadequate…Mar 20, 2007 · N128SL · Substantial damageNTSB ATL07CA053Accident · Minor injuriesData collectionFinal reportChampion 7ECA · Oliver Springs, TNThe pilot's failure to maintain adequate clearance, resulting in an in-flight collision with an airport sign.Mar 20, 2007 · N9596S · Substantial damageNTSB SEA07CA078Accident · No injuriesData collectionFinal reportCessna 150A · Davenport, WAThe pilot's failure to maintain directional control while landing, which resulted in a nose over. Wind gusts and the pilot's inadequate compensation for the wind condition were factors.Mar 19, 2007 · N6463T · Substantial damageNTSB NYC07CA082Accident · No injuriesData collectionFinal reportCessna 172P · Sanford, FLThe student pilot's failure to maintain directional control during the landing roll. Factors included a 90-degree crosswind, and the student pilot's improper in-flight decision to land on a runway with the crosswind rather than on an available runway with a…Mar 18, 2007 · N96319 · Substantial damageNTSB ATL07CA060Accident · No injuriesData collectionFinal reportMaule M-5 235C · Moultrie, GAThe pilot's failure to maintain directional control of the airplane during landing roll.Mar 18, 2007 · N56537 · Substantial damageNTSB DFW07FA084Accident · 1 fatalField investigationFinal reportBeech 58P · Marietta, OKThe pilot's improper landing flare. A contributing factor was the premature touchdown in an area of rising terrain.Mar 17, 2007 · N584DP · DestroyedNTSB LAX07CA112Accident · No injuriesData collectionFinal reportCaywood Long-Ez · El Cajon, CAThe pilot's failure to maintain directional control of the airplane during the landing roll.Mar 16, 2007 · N829CL · Substantial damageNTSB LAX07CA110Accident · No injuriesData collectionFinal reportCessna T210N · Barstow, CAThe pilot's failure to properly execute the manual landing gear extension procedures.Mar 16, 2007 · N628TT · Substantial damageNTSB CHI07CA088Accident · No injuriesData collectionFinal reportPiper PA-24-400 · Des Moines, IAthe nose landing gear becoming jammed in a partially extended position during flight as a result of damage to the nose landing gear by ground personnel.Mar 13, 2007 · N400VL · Substantial damageNTSB LAX07CA105Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Groveland, CAthe pilot's failure to maintain directional control.Mar 12, 2007 · N2489P · Substantial damageNTSB SEA07LA075Accident · No injuriesLimited investigationFinal reportFound Aircraft Canada FBA-2C2 · Reno, NVThe certified flight instructor's failure to maintain directional control of the airplane during landing, which resulted in a groundloop.Mar 11, 2007 · N418MS · Substantial damageNTSB NYC07CA079Accident · No injuriesData collectionFinal reportBeech C23 · Fredericksburg, VAThe pilot's misjudgment of the airplane's speed and distance during the landing approach.Mar 11, 2007 · N9150S · Substantial damageNTSB CHI07CA089Accident · No injuriesData collectionFinal reportCessna 172R · Columbus, OHThe pilot's failure to maintain directional control while landing. Contributing factors to the accident were the wind conditions and the runway sign.Mar 11, 2007 · N440ES · Substantial damageNTSB ATL07CA049Accident · No injuriesData collectionFinal reportCirrus Design SR-22 · Ocraacoke, NCThe pilot's improper use of the aileron and rudder controls and inadequate compensation for the wind conditions during a crosswind landing resulting in a loss of directional control.Mar 11, 2007 · N313L · Substantial damageNTSB ANC07CA024Accident · No injuriesData collectionFinal reportCessna 177 · Gridwood, AKThe pilot's selection of a snow-covered runway for landing, which resulted in a quick stop and damage to the airplane. A factor associated with the accident was the snow-covered runway.Mar 11, 2007 · N2911X · Substantial damageNTSB SEA07CA077Accident · No injuriesData collectionFinal reportCessna 172S · Kingman, AZThe pilot's misjudged flare, which resulted in a hard landing and a porpoise.Mar 10, 2007 · N521ER · Substantial damageNTSB DFW07CA083Accident · No injuriesData collectionFinal reportCessna 150 · Sand Springs, OKThe pilot's improper recovery from a bounced landing.Mar 10, 2007 · N11341 · Substantial damageNTSB DEN07FA068Accident · Minor injuriesField investigationFinal reportFlight Design USA CT-SW · Albuquerque, NMThe total failure of the left main landing gear strut due to overload during the landing resulting in the loss of control and subsequent nose over. A factor contributing to the accident was the chief pilot 's inability to maintain directional control of the…Mar 10, 2007 · N102RK · Substantial damageNTSB SEA07CA074Accident · Minor injuriesData collectionFinal reportCessna 172N · Phoenix, AZThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall and uncontrolled descent into terrain during landing. A contributing factor was the pilot's distracted attention due to the inaccurate flap indicator.Mar 9, 2007 · N4663D · Substantial damageNTSB NYC07CA078Accident · No injuriesData collectionFinal reportCessna 172R · Norfolk, VAThe pilot's failure to maintain directional control while landing, which resulted in a collision with a runway sign. A factor was the crosswind.Mar 9, 2007 · N441QF · Substantial damageNTSB NYC07CA074Accident · No injuriesData collectionFinal reportMooney M20R · Marshfield, MAA loss of directional control for undetermined reasons.Mar 9, 2007 · N323RW · DestroyedNTSB MIA07LA066Accident · No injuriesLimited investigationFinal reportEADS PZL Warsza PZL-104M Wilga · Tampa, FLThe pilot's failure to maintain directional control during the landing roll which resulted in a ground loop and damage to the airplane.Mar 9, 2007 · N424HD · Substantial damageNTSB CHI07CA087Accident · No injuriesData collectionFinal reportCessna 150 · LaCrosse, WIThe dual student's failure to maintain the proper glidepath and clearance from terrain and the flight instructor's delayed remedial action. A factor was the flight instructor's fatigue.Mar 9, 2007 · N7272S · Substantial damageNTSB SEA07CA072Accident · No injuriesData collectionFinal reportCessna T210M · Boulder City, NVThe pilot's failure to maintain directional control of the airplane during landing, which resulted in a runway excursion.Mar 7, 2007 · N6520B · Substantial damageNTSB SEA07CA069Accident · No injuriesData collectionFinal reportBell 206 B3 · Custer, MTThe pilot’s failure to maintain clearance between the tail rotor of his helicopter and a piece of farm equipment during the landing sequence.Mar 5, 2007 · N150SP · Substantial damageNTSB ATL07CA047Accident · No injuriesData collectionFinal reportCessna 172R · Cartersville, GAThe pilot's failure to maintain directional control during the landing roll, which resulted in a loss of control and an on-ground collision with a sign.Mar 5, 2007 · N2145T · Substantial damageNTSB DEN07CA065Accident · Minor injuriesData collectionFinal reportOgden Aubrey D BD-4 · Moriarty, NMThe pilot's failure to maintain aircraft control during the landing.Mar 4, 2007 · N93BD · Substantial damageNTSB NYC07CA070Accident · Minor injuriesData collectionFinal reportSchweizer 269-C · Columbus, PAThe pilot's improper decision to continue the landing attempt in whiteout conditions, which resulted in his disorientation, and the helicopter's subsequent dynamic rollover. Factors included the whiteout conditions, and the pilot's inadequate weather…Mar 3, 2007 · N515JM · Substantial damageNTSB LAX07CA101Accident · No injuriesData collectionFinal reportCessna 172S · Prescott, AZthe student pilot's failure to maintain directional during the landing rollout and the certified flight instructor's inadequate supervision.Mar 3, 2007 · N526ER · Substantial damageNTSB LAX07CA100Accident · Minor injuriesData collectionFinal reportHirsch Thorp T-18 · San Diego, CAThe pilot's improper bounced landing recovery and improper use of the flight controls that resulted in a porpoise and a nose over.Mar 3, 2007 · N78DH · Substantial damageNTSB LAX07CA097Accident · Minor injuriesData collectionFinal reportMonocoupe 110 · Camarillo, CAThe pilot's failure to maintain directional control during the landing rollout that resulted in a ground loop.Mar 1, 2007 · N18642 · Substantial damageNTSB SEA07LA068Accident · No injuriesLimited investigationFinal reportEurocopter France SA330J · Lakeview, ORThe dual student's failure to extend the landing gear during a simulated single-engine forced landing, and the flight instructor's failure to take remedial action to keep the aircraft from touching the runway surface without the landing gear extended.Feb 28, 2007 · N330KW · Substantial damageNTSB SEA07CA070Accident · No injuriesData collectionFinal reportWaltz Sonex Waiex · Phoenix, AZThe pilot's failure to maintain directional control during the landing roll. The fact that the pilot had only two hours total time in this make and model aircraft was a factor in the accident.Feb 26, 2007 · N600WW · Substantial damageNTSB DFW07IA077Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145LR · Dallas, TXThe pilot's failure to maintain directional control of the airplane while landing with a crosswind. A contributing factor was the prevailing crosswind.Feb 24, 2007 · N648AE · Minor damageNTSB SEA07CA065Accident · No injuriesData collectionFinal reportPiper PA-12 · Lewiston, IDthe inadvertent use of the rudder by the passenger, which resulted in an inadvertent ground loop.Feb 23, 2007 · N2343M · Substantial damageNTSB MIA07CA057Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Fort Pierce, FLThe failure of the pilot to maintain directional control of the airplane during the landing roll resulting in overload failure and subsequent collapse of the right main landing gear.Feb 23, 2007 · N2808P · Substantial damageNTSB CHI07CA081Accident · No injuriesData collectionFinal reportRotary Air Force Marketing RAF 2000 · Neenah, WIThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion. Contributing factors were a bent rudder trim tab, the narrow runway, and the uneven terrain at the edge of the runway pavement.Feb 23, 2007 · N5077F · Substantial damageNTSB MIA07IA052Incident · No injuriesIncident investigationFinal reportLiberty Aerospace XL-2 · Ormond Beach, FLThe improper manufacturing of the nose undercarriage leg by the vendor, and the inadequate surveillance of the vendor by the airplane manufacturer.Feb 21, 2007 · N550XL · Minor damageNTSB DFW07LA075Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Lubbock, TXThe pilot's improper landing flare. A contributing factor was the prevailing tailwind.Feb 21, 2007 · N7900Y · Substantial damageNTSB DFW07CA074Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Granbury, TXThe pilot's misjudgment of altitude and distance while landing, which resulted in an undershoot of the runway. A contributing factor was the rising terrain on approach to the runway.Feb 21, 2007 · N134DG · Substantial damageNTSB ANC07LA021Accident · No injuriesLimited investigationFinal reportCessna 402C · Cordova, AKThe failure of the right main landing gear linkage during the landing roll, which resulted in a loss of directional control and the collapse of the right main landing gear. A factor associated with the accident was the failure of company maintenance personnel…Feb 20, 2007 · N402ET · Substantial damageNTSB LAX07CA090Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Tucson, AZThe failure of the student pilot to maintain an adequate main rotor rpm and the instructor’s failure to maintain control of the aircraft.Feb 19, 2007 · N453SH · Substantial damageNTSB DCA07MA072Accident · No injuriesClass 1 · MajorFinal reportEmbraer ERJ-170 · Cleveland, OHthe failure of the flight crew to execute a missed approach when visual cues for the runway were not distinct and identifiable. Contributing to the accident were (1) the crew's decision to descend to the ILS decision height instead of the localizer…Feb 18, 2007 · N862RW · Substantial damageNTSB LAX07CA089Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Nampa, IDthe pilot's misjudged flare and improper use of the elevator flight control.Feb 17, 2007 · N7722D · Substantial damageNTSB LAX07CA088Accident · Minor injuriesData collectionFinal reportLuscombe 8A · Compton, CAThe pilot's failure to maintain directional control during landing rollout. A contributing factor was the passenger's interference with the pilot's manipulation of the controls.Feb 17, 2007 · N515SF · Substantial damageNTSB CHI07CA074Accident · No injuriesData collectionFinal reportCessna 172S · St. Louis, MOThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control. Factors were the gusting crosswind conditions and the snow covered ground.Feb 16, 2007 · N270JA · Substantial damageNTSB LAX07CA092Accident · No injuriesData collectionFinal reportCessna 172S · Lake Wells, FLthe flight instructor's inadequate compensation for the gusty crosswind conditions.Feb 14, 2007 · N289SP · Substantial damage