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 WPR12CA159Accident · Minor injuriesData collectionFinal reportLuscombe 8E · Westport, WAThe pilot’s inadequate crosswind compensation, which resulted in a loss of directional control during the landing roll.Apr 7, 2012 · N1183K · Substantial damageNTSB DCA12FA058Accident · No injuriesField investigationFinal reportBombardier DHC-8-402 · Houston, TXthe nose landing gear alternate release handle was not pulled with sufficient enough force or distance to release the uplocks and allow extension of the nose landing gear. Contributing to the accident was the dissimilar pull force and pull length set on the…Apr 7, 2012 · N213WQ · Substantial damageNTSB CEN12CA233Accident · No injuriesData collectionFinal reportCessna 210H · Marienthal, KSThe pilot's inadequate compensation for the wind during landing.Apr 7, 2012 · N5981F · Substantial damageNTSB WPR12CA158Accident · No injuriesData collectionFinal reportFairchild 24 C8C · Redmond, ORThe pilot’s loss of airplane control as a result of excessive brake application. Contributing to the accident was the pilot’s lack of experience in the airplane.Apr 6, 2012 · N14722 · Substantial damageNTSB ERA12CA270Accident · No injuriesData collectionFinal reportCessna 172M · Pottstown, PAThe pilot’s inadequate recovery from a bounced landing, which resulted in a loss of control.Apr 5, 2012 · N6871H · Substantial damageNTSB CEN12LA234Accident · No injuriesLimited investigationFinal reportCessna LC41-550FG · Telluride, COThe pilot's decision to land with a direct tailwind, which resulted in a loss of directional control, and his subsequent decision to attempt a go-around so late in the landing roll, which resulted in a stall.Apr 4, 2012 · N1178L · Substantial damageNTSB CEN12LA229Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · San Marcos, TXThe pilot's failure to ensure that he was aware of the NOTAM describing the runway closure, which resulted in a landing on the closed runway and subsequent collision with a barrier. Contributing to the accident was the failure of air traffic control personnel…Apr 4, 2012 · N1162X · Substantial damageNTSB ERA12CA269Accident · No injuriesData collectionFinal reportLuscombe 8A · Pittsburgh, PAThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion.Apr 3, 2012 · N71479 · Substantial damageNTSB ERA12CA266Accident · No injuriesData collectionFinal reportPiper PA-60-602P · Philadelphia, PAThe pilot's failure to maintain directional control while landing in gusting crosswind conditions.Apr 2, 2012 · N6902L · Substantial damageNTSB WPR12CA151Accident · No injuriesData collectionFinal reportLake LA-4-200 · Lake Havasu City, AZThe pilot did not maintain directional control during a water touchdown.Apr 1, 2012 · N32LB · Substantial damageNTSB CEN12CA219Accident · No injuriesData collectionFinal reportTaylorcraft F19 · Emporia, KSThe pilot's loss of directional control while landing, which resulted in a ground loop and impact with a fence.Mar 31, 2012 · N3673T · Substantial damageNTSB WPR12CA150Accident · No injuriesData collectionFinal reportArado-Flugzeugwerke FW190 A-5 · Casa Grande, AZThe pilot did not maintain directional control of the airplane during the landing roll.Mar 30, 2012 · N190DK · Substantial damageNTSB CEN12LA214Accident · No injuriesLimited investigationFinal reportCessna 172S · Midlothian, TXThe pilot's failure to maintain directional control during the landing roll.Mar 29, 2012 · N480SP · Substantial damageNTSB CEN12LA209Accident · 1 fatalLimited investigationFinal reportWalling Vans RV-3 · Larchwood, IAThe pilot's failure to maintain directional control of the airplane after landing.Mar 28, 2012 · N34WC · Substantial damageNTSB CEN12CA215Accident · No injuriesData collectionFinal reportCessna 441 · Battle Creek, MIThe maintenance technician did not remove the tow bar prior to the flight.Mar 27, 2012 · N1212C · Substantial damageNTSB CEN12CA207Accident · Minor injuriesData collectionFinal reportPiper PA-22-150 · Crowley, LAThe student pilot's improper landing flare, which resulted in a nose-over.Mar 26, 2012 · N6143D · Substantial damageNTSB WPR12CA148Accident · No injuriesData collectionFinal reportStinson 108-1 · Coolin, IDThe pilot’s decision to land on a snow-covered runway.Mar 25, 2012 · N97032 · Substantial damageNTSB CEN12CA205Accident · Minor injuriesData collectionFinal reportFurru Donald Jeffrey Skyranger V MAX · Viola, ARThe pilot did not maintain adequate airspeed during a go-around, which resulted in an aerodynamic stall.Mar 25, 2012 · N912FL · Substantial damageNTSB ERA12LA259Accident · No injuriesLimited investigationFinal reportCessna 172P · Brooksville, FLThe pilot's improper landing flare, which resulted in a hard landing.Mar 24, 2012 · N99087 · Substantial damageNTSB CEN12LA198Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Bloomfield, INThe pilot's failure to land with sufficient runway remaining to stop, which resulted in an unsuccessful aborted landing, inadvertent stall, and collision with terrain.Mar 24, 2012 · N201QB · Substantial damageNTSB CEN12CA213Accident · No injuriesData collectionFinal reportCessna 172R · Council Bluffs, IAThe student pilot’s improper flare and inadequate recovery from a bounced landing, which resulted in a loss of directional control.Mar 24, 2012 · N368ES · Substantial damageNTSB CEN12CA206Accident · Serious injuriesData collectionFinal reportHall Jeffrey Hall RV-4 · Calhan, COThe pilot's loss of airplane control while landing with a gusting tailwind condition.Mar 24, 2012 · N605RV · Substantial damageNTSB WPR12CA145Accident · No injuriesData collectionFinal reportRockwell International 690C · Conrad, MTThe pilot did not maintain directional control of the airplane due to ice and slushy snow on the runway during the landing roll.Mar 23, 2012 · N840JC · Substantial damageNTSB ERA12CA247Accident · No injuriesData collectionFinal reportMooney M20J · Butler, PAThe pilot’s failure to extend the landing gear before landing.Mar 23, 2012 · N58135 · Substantial damageNTSB WPR12CA142Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Jean, NVThe student pilot did not maintain directional control during the landing roll.Mar 22, 2012 · N55634 · Substantial damageNTSB CEN12CA225Accident · No injuriesData collectionFinal reportBeech V35B · Malvern, ARThe pilot did not fly a stabilized approach and elected not to perform a go-around, which resulted in a runway excursion.Mar 21, 2012 · N17MJ · Substantial damageNTSB WPR12WA167Incident · No injuriesForeign investigationSaab 2000 · Copenhagen, DenmarkOn March 20, 2012, about 0610 UTC, a Saab 2000, registered in Sweden as SE-LOM, experienced an elevator flight control malfunction during landing at Copenhagen Airport (EKCH), Denmark. None of the three flight crew or 47 passengers were injured. The airplane…Mar 20, 2012 · SE-LOM · No damageNTSB ERA12CA242Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · New Smyrna, FLThe pilot's improper flare, which resulted in a hard landing. Contributing to the accident was the flight instructor's inadequate remedial action.Mar 18, 2012 · N15764 · Substantial damageNTSB CEN12LA189Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Arcola, TXThe pilot did not maintain adequate crosswind correction during the landing flare and the flight instructor's delayed remedial action.Mar 18, 2012 · N56273 · Substantial damageNTSB ERA12CA235Accident · No injuriesData collectionFinal reportPiper J3C-65 · Douglas, GAThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion. Contributing to the accident was the pilot's lack of experience in the tailwheel-equipped airplane.Mar 17, 2012 · N3225N · Substantial damageNTSB CEN12CA193Accident · No injuriesData collectionFinal reportBellanca 17-30A · Branson, MOThe pilot did not maintain directional control of the airplane while landing with a gusting crosswind.Mar 17, 2012 · N801RC · Substantial damageNTSB CEN12CA190Accident · No injuriesData collectionFinal reportCessna A185F · Fort Worth, TXThe pilot did not maintain directional control of the airplane while landing in gusty wind conditions.Mar 17, 2012 · N185GS · Substantial damageNTSB ERA12FA225Accident · 5 fatalField investigationFinal reportCessna 501 · Franklin, NCThe pilot's failure to achieve a stabilized approach, resulting in a nose-first, bounced landing. Contributing to the accident was the pilot's activation of only one thrust reverser, resulting in asymmetrical thrust.Mar 15, 2012 · N7700T · Substantial damageNTSB ERA12CA228Accident · Minor injuriesData collectionFinal reportPiper PA-28-151 · Charleston, SCThe pilot's improper landing flare, which resulted in a hard landing.Mar 15, 2012 · N832KF · Substantial damageNTSB CEN12CA194Accident · No injuriesData collectionFinal reportCessna 177B · New Orleans, LAThe pilot’s improper flare, which resulted in a hard landing.Mar 15, 2012 · N30770 · Substantial damageNTSB ERA12IA237Incident · No injuriesIncident investigationFinal reportPiper PA-32R-300 · Warrenton, VAMaintenance personnel's failure to identify stress corrosion cracking in the stabilator control cable during the most recent inspection, and the subsequent failure of the cable on the flight after the inspection.Mar 14, 2012 · N1358H · No damageNTSB WPR12LA135Accident · Minor injuriesLimited investigationFinal reportCook Smith AVN Replica SU · St. Johns, AZThe pilots’ failure to maintain directional control when the right brake locked up during the landing roll for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Mar 13, 2012 · N712AZ · Substantial damageNTSB CEN12LA187Accident · 1 fatalLimited investigationFinal reportBrice Ron Glastar Sportsman 2+ · Kimberling, MOThe pilot’s inadequate flare, which resulted in the airplane impacting into the water.Mar 13, 2012 · N627RM · Substantial damageNTSB CEN12CA185Accident · No injuriesData collectionFinal reportCessna 180H · Belle Chase, LAThe bent tailwheel spring that allowed the tailwheel to caster when the airplane encountered a wind gust on landing roll.Mar 11, 2012 · N3424Y · Substantial damageNTSB ANC12CA025Accident · No injuriesData collectionFinal reportHughes 369 · Trading Bay, AKThe pilot's selection of an unsuitable landing site in flat-light conditions, which resulted in an inadvertent dynamic rollover.Mar 11, 2012 · C-GVEB · Substantial damageNTSB WPR12CA127Accident · No injuriesData collectionFinal reportCessna 172N · Kelso, WAThe pilot did not maintain directional control during the landing flare.Mar 9, 2012 · N5290D · Substantial damageNTSB WPR12LA126Accident · No injuriesLimited investigationFinal reportQuicksilver MX Sprint II · Willits, CAThe student pilot did not maintain an adequate approach/glide path and altitude, which resulted in a runway undershoot and subsequent collision with trees. Contributing to the accident was the student pilot's lack of flight experience.Mar 8, 2012 · N702U · Substantial damageNTSB WPR12CA117Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Randle, WAThe pilot exceeded the helicopter's performance, resulting in low rotor rpm and settling.Mar 8, 2012 · N54BA · Substantial damageNTSB ERA12CA215Accident · No injuriesData collectionFinal reportCessna 140A · Mooresville, NCThe separation of the left rudder cable turnbuckle and the pilot’s subsequent loss of directional control during landing.Mar 6, 2012 · N5693C · Substantial damageNTSB ANC12IA024Incident · No injuriesIncident investigationFinal reportBombardier Learjet 35A · Anchorage, AKThe flightcrew's loss of visual reference to the runway after encountering severe in-flight icing conditions, which resulted in a loss of control while landing and exceedence of the capabilities of the airplane's windscreen anti-ice systems. Contributing to…Mar 6, 2012 · N544LM · Minor damageNTSB WPR12CA132Accident · No injuriesData collectionFinal reportCessna 170B · San Jose, CAThe pilot did not maintain directional control during the landing roll.Mar 4, 2012 · N8245A · Substantial damageNTSB ERA12CA209Accident · No injuriesData collectionFinal reportCessna 172S · Lafayette, TNThe pilot’s inadequate compensation for gusting crosswind conditions during landing, which resulted in a hard landing.Mar 4, 2012 · N53460 · Substantial damageNTSB WPR12CA121Accident · No injuriesData collectionFinal reportSiai-Marchetti SF.260TP · Corona, CAThe pilot did not maintain runway alignment during landing in a gusting crosswind.Mar 2, 2012 · N350TP · Substantial damageNTSB CEN12LA204Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Roanoke, TXThe pilot’s failure to follow the published emergency procedures to lower the landing gear following a loss of electrical power.Mar 2, 2012 · N373JT · Substantial damageNTSB WPR12CA118Accident · No injuriesData collectionFinal reportEurocopter AS 350 B3 · Poway, CAThe pilot's inadequate compensation for wind conditions during landing, which resulted in a hard landing.Feb 25, 2012 · N118MB · Substantial damage