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 FTW93LA028Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Vernon, TXThe student pilot's failure to maintain directional control of the airplane. A factor was the stall/mush.Nov 2, 1992 · N8199S · Substantial damageNTSB NYC93LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Woodstown, PAThe pilot's improperly planned approach and delayed decision to initiate a go-around, which resulted in a touchdown too FAR down the runway and the subsequent collision with a ditch. A factor related to the accident was the pilot's lack of recent flight…Nov 1, 1992 · N33146 · Substantial damageNTSB NYC93LA032Accident · Minor injuriesLimited investigationFinal reportLet LF-13 · Readington, NJThe pilot's poorly planned approach for landing which resulted in an off airport landing in unsuitable terrain.Nov 1, 1992 · N13WG · Substantial damageNTSB LAX93LA022Accident · Minor injuriesLimited investigationFinal reportThunder and Colt AX7-77 · Sierra Vista, AZThe flight's encounter with unforecast unfavorable winds.Oct 31, 1992 · N666TE · DestroyedNTSB SEA93LA013Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Troutdale, ORImproper use of flt controls by the pilot, resulting in inadvertent stall/spin.Oct 30, 1992 · N66135 · DestroyedNTSB CHI93LA023Accident · No injuriesLimited investigationFinal reportCessna 140 · Waverly, IAThe pilot's excessive application of brakes during landing roll.Oct 27, 1992 · N4213N · Substantial damageNTSB CHI93LA022Accident · No injuriesLimited investigationFinal reportCessna 172N · Ankeny, IAThe pilot's improper recovery for a bounced landing.Oct 27, 1992 · N75823 · Substantial damageNTSB NYC93LA030Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Monroeville, PAThe pilot's improper compensation for adverse wind conditions during landing, resulting in a loss of directional control and subsequent departure from the runway and collision with trees. Factor related to the accident was: the unfavorable winds.Oct 25, 1992 · N2503L · Substantial damageNTSB CHI93LA020Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Carroll, IAThe pilot's failure to maintain aircraft directional control while landing in crosswind conditions.Oct 25, 1992 · N9507S · Substantial damageNTSB ATL93LA015Accident · No injuriesLimited investigationFinal reportCessna 152 · Knoxville, TNThe pilots poor inflight decision to attempt to land the aircraft in an unsuitable area.Oct 25, 1992 · N49164 · Substantial damageNTSB LAX93LA018Accident · No injuriesLimited investigationFinal reportCessna 305A · Prescott, AZThe pilot not maintaining directional control during landing roll resulting in a ground loop swerve.Oct 24, 1992 · N1832 · Substantial damageNTSB ANC93LA009Accident · No injuriesLimited investigationFinal reportCessna 206 · Slate Creek, AKThe icy condition of the runway and the discontinued snow removal.Oct 23, 1992 · N9138M · Substantial damageNTSB FTW93LA021Accident · No injuriesLimited investigationFinal reportCessna 177B · Las Cruces, NMThe pilot's delayed landing flare and the improper bounced landing recovery. A factor was the dark night.Oct 22, 1992 · N13710 · Substantial damageNTSB CHI93LA021Accident · No injuriesLimited investigationFinal reportCessna C177B · Noblesville, INThe pilot's improper recovery from a bounced landing.Oct 22, 1992 · N35230 · Substantial damageNTSB CHI93LA014Accident · Minor injuriesLimited investigationFinal reportPiper PA-20 · Weeping Water, NEThe pilot's failure to maintain directional control.Oct 22, 1992 · N5592H · Substantial damageNTSB CHI93LA013Accident · No injuriesLimited investigationFinal reportSchweizer H-300 · Grand Forks, NDThe pilot's failure to maintain control of the helicopter during a night landing.Oct 22, 1992 · N3625Z · Substantial damageNTSB NYC93LA021Accident · No injuriesLimited investigationFinal reportCessna 210L · Cincinnati, OHThe failure of the pilot to maintain directional control during landing which resulted in the airplane striking a drainage ditch. Factors related to the accident were the crosswind and the drainage ditch.Oct 19, 1992 · N2141S · Substantial damageNTSB NYC93LA024Accident · No injuriesLimited investigationFinal reportCessna 150L · Linden, NJThe automobile driver's failure to see and avoid aircraft traffic while crossing an active runway.Oct 18, 1992 · N17023 · Substantial damageNTSB NYC93LA022Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Princeton, NJThe pilot failed to maintain control of the airplane, resulting in the airplane departing the runway, impacting with a wall and subsequently caught fire. A contributing factor was the pilot improperly compensated for a crosswind.Oct 18, 1992 · N19402 · Substantial damageNTSB DEN93LA019Accident · No injuriesLimited investigationFinal reportCessna 172 · Colorado Spring, COProper descent rate was not maintained by the pilot in command which resulted in a hard landing.Oct 18, 1992 · N1450U · Substantial damageNTSB DEN93LA006Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Grand Junction, COFatigue failure of the nose landing gear upper drag strut bracket due to fatigue cracking.Oct 18, 1992 · N14695 · Substantial damageNTSB NYC93LA033Accident · No injuriesLimited investigationFinal reportCessna 172N II · Waverly, OHAn unavoidable collision with a deer.Oct 17, 1992 · N75571 · Substantial damageNTSB MIA93LA007Accident · No injuriesLimited investigationFinal reportCessna 152 · Hollywood, FLThe pilot in command's improper flare which resulted in the aircraft ballooning during landing, followed by his improper recovery from the ballooned landing which resulted in the aircraft touching down hard on the nose landing gear causing it to collapse.Oct 17, 1992 · N6560H · Substantial damageNTSB ATL93LA011Accident · No injuriesLimited investigationFinal reportCessna 172RG · Clarksville, TNThe fracture of the section gear in the main landing gear retraction and extension mechanism.Oct 15, 1992 · N9797B · Substantial damageNTSB NYC93FA015Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Elkton, VAThe pilot's delay in aborting the landing which resulted in insufficient runway remaining to allow the airplane to reach sufficient altitude to clear the obstacles at the end of the runwayOct 12, 1992 · N5152L · DestroyedNTSB LAX93FA007Accident · 1 fatalField investigationFinal reportCessna 172M · Fairfield, CAThe pilot's delay in initiating a go-around during a night landing. Factors related to the accident were: the pilot misjudging distance and speed resulting a overshooting the touchdown, the night light condition, his lack of night flying experience in a…Oct 11, 1992 · N80780 · DestroyedNTSB FTW93LA011Accident · No injuriesLimited investigationFinal reportCessna L-19A · Brookshire, TXThe pilot's improper compensation for the cross wind. A factor was the crosswind.Oct 11, 1992 · N5563 · Substantial damageNTSB CHI93LA008Accident · No injuriesLimited investigationFinal reportCessna 150M · Romeo, MIInadequate compensation for wind conditions by the pilot in command and failure to attain directional control of the airplane during landing flare and touchdown.Oct 11, 1992 · N66355 · Substantial damageNTSB NYC93LA014Accident · No injuriesLimited investigationFinal reportPiper PA28-161 · St. Clairsville, OHThe pilot's improper in-flight planning and decision to land on a short grass runway with a tail wind. A factor in this accident was the pilots failure to obtain and evaluate a weather briefing prior to the flight.Oct 10, 1992 · N8333T · Substantial damageNTSB LAX93LA008Accident · No injuriesLimited investigationFinal reportCessna R172K · Picacho, AZThe pilot's encounter with the unforecasted cyclonic wind.Oct 10, 1992 · N736WZ · Substantial damageNTSB NYC93LA009Accident · No injuriesLimited investigationFinal reportAeronca 11-AC · Columbus, OHThe pilot failed to maintain control of the airplane, resulting the airplane departing the runway and impacted with the VASI lights.Oct 8, 1992 · N9486E · Substantial damageNTSB CHI93LA007Accident · No injuriesLimited investigationFinal reportHoward DGA-15P · Wichita, KSInadequate preflight planning/preparation by the pilot, the pilot's over confidence in his personal ability, and airplane performance data not followed by the pilot.Oct 8, 1992 · N67433 · Substantial damageNTSB CHI93LA006Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Madison, WIWas the pilot's inadequate compensation for wind conditions which resulted in an improper flare. A factor related was the gusty wind condition.Oct 8, 1992 · N228R · Substantial damageNTSB ATL93LA005Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Apex, NCThe pilot's improper in-flight planning and his inadequate compensation for wind conditions, which resulted in the overrun of the runway. Factors were the tail wind conditions, and the downhill, grass runway.Oct 7, 1992 · N4874D · Substantial damageNTSB DEN93LA002Accident · No injuriesLimited investigationFinal reportCessna 172N · Englewood, COFailure of the pilot in command to maintain directional control during landing roll. A factor was excessive airspeed during landing.Oct 5, 1992 · N5884E · Substantial damageNTSB CHI93LA002Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · West Branch, MIThe pilot's failure to maintain aircraft control during the landing roll.Oct 4, 1992 · N9807D · Substantial damageNTSB ATL93LA003Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Clanton, ALThe pilot's inadequate compensation for wind conditions, which resulted in a loss of aircraft control during landing. Factors were the turbulence and gusty wind conditions present at the time of the accident.Oct 4, 1992 · N4667K · Substantial damageNTSB ANC93LA003Accident · No injuriesLimited investigationFinal reportCessna 152 · Skwentna, AKThe student pilots failure to maintain directional control during a go around. Factors relating to the accident were the soft runway conditions and the inadequacy of training in the maneuver attempted by the student.Oct 4, 1992 · N95031 · Substantial damageNTSB NYC93LA004Accident · 1 fatalLimited investigationFinal reportLake LA-250 · Franklin, NHThe pilot's misjudged touchdown on the water which resulted in a porpoised landing. Also causal to the accident was his improper recovery from the porpoise, resulting in a loss of airplane control and collision with the water. Factors related to the accident…Oct 3, 1992 · N8549Z · Substantial damageNTSB FTW93LA003Accident · 1 fatalLimited investigationFinal reportCessna Ector 305A · Houston, TXThe pilot of the other aircraft's inadvertent ground loop. Factors were the left quartering tailwind and this pilot's inability to see the other airplane during the landing roll.Oct 3, 1992 · N910E · 2 aircraft · DestroyedNTSB CHI93LA003Accident · No injuriesLimited investigationFinal reportCessna 172P · Kokomo, INThe pilot's delayed remedial action.Oct 3, 1992 · N51829 · Substantial damageNTSB ANC93LA002Accident · No injuriesLimited investigationFinal reportCessna A185E · Admiralty Isl, AKThe pilot's selection of unsuitable terrain. A factor related to the accident was: the soft sand.Oct 3, 1992 · N4755Q · Substantial damageNTSB LAX93LA002Accident · No injuriesLimited investigationFinal reportCessna 172P · Reno, NVThe student pilot's improper remedial action and improper use of the rudder. Contributing to this accident was the student pilot's improper flare and lack of total experience.Oct 2, 1992 · N5394K · Substantial damageNTSB LAX93LA001Accident · No injuriesLimited investigationFinal reportCessna 170B · Prescott, AZFailure of the pilot to maintain directional control and improper use of the flight controls and brakes.Oct 2, 1992 · N2515D · Substantial damageNTSB CHI92LA294Accident · No injuriesLimited investigationFinal reportSocata TB-9 · Grand Forks, NDThe pilot's premature flare.Sep 29, 1992 · N150ND · Substantial damageNTSB DEN92LA094Accident · No injuriesLimited investigationFinal reportCessna 172N · Fort Collins, COThe pilot's failure to maintain directional control of the airplane. A factor was: crosswind.Sep 27, 1992 · N5222D · Substantial damageNTSB CHI92LA296Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Plattsmouth, NEThe pilot-in-command's failure to adequately compensate for wind conditions, and his not maintaining directional control.Sep 27, 1992 · N1270C · Substantial damageNTSB CHI92LA293Accident · Serious injuriesLimited investigationFinal reportCameron O-77 · North Omaha, NEThe pilot's abrupt touchdown during a balloon landing. A related factor is the unsuitable terrain selected.Sep 27, 1992 · N9539G · No damageNTSB CHI92LA292Accident · No injuriesLimited investigationFinal reportCessna 152 · Cape Girardeau, MOThe pilot's failure to recover from the bounced landing.Sep 27, 1992 · N69225 · Substantial damageNTSB BFO92LA154Accident · No injuriesLimited investigationFinal reportCessna 305A · Waynesville, OHThe chaffing of a landing gear brake line which caused the loss of hydraulic fluid and subsequent loss of braking action.Sep 27, 1992 · N5074Y · Substantial damage