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 FTW04LA090Accident · No injuriesLimited investigationFinal reportBeech BE-200 · Springdale, ARThe failure of the right main landing gear actuator clevis bolt for undetermined reasons.Mar 5, 2004 · N30SE · Substantial damageNTSB ATL04IA085Incident · No injuriesIncident investigationFinal reportBoeing 717-200 · Atlanta, GAThe failure of the tantalum capacitor and the permanent magnet generator input transformer which resulted in total electrical system failure.Mar 5, 2004 · N978AT · No damageNTSB MIA04CA055Accident · No injuriesData collectionFinal reportAviat Pitts S2B · Parkland, FLThe pilot's inadequate preflight planning which resulted in an off-airport precautionary landing to preclude fuel exhaustion, which resulted in damage to the airplane during the landing.Mar 3, 2004 · N61PS · Substantial damageNTSB ATL04LA114Accident · Minor injuriesLimited investigationFinal reportPiper PA-46-350P · Montgomery, ALThe pilot's inadequate compensation for wind and his failure to maintain directional control during landing roll that resulted in the collapse of the nose gear. The crosswind was a contributing factor.Mar 2, 2004 · N91734 · Substantial damageNTSB LAX04LA142Accident · No injuriesLimited investigationFinal reportCessna A185F · Tucson, AZthe pilot's inadequate compensation for the quartering tailwind and failure to maintain directional control during landing rollout.Feb 29, 2004 · N338H · Substantial damageNTSB ATL04FA079Accident · 2 fatalField investigationFinal reportCessna 210 · Blountville, TNThe pilot's improper flare, and improper recovery which resulted in a bounced landing, collapse of the left main landing gear, and the pilot's failure to maintain airspeed while maneuvering resulting in a stall, uncontrolled descent, and collision with the…Feb 29, 2004 · N9660T · Substantial damageNTSB LAX04CA145Accident · No injuriesData collectionFinal reportCessna 120 · Red Bluff, CAthe pilot's inadequate compensation for the wind condition and failure to maintain directional control during the landing roll on a narrow runway. A contributing factor were the gusty tailwind conditions.Feb 28, 2004 · N3029N · Substantial damageNTSB FTW04LA086Accident · No injuriesLimited investigationFinal reportLake LA4-270T · Crowley, LAThe pilot's inadvertant water landing with the landing gear extended. Contributing factors were the sunglare and the pilot's failure to verify the position of the flaps and landing gear.Feb 28, 2004 · N193TM · Substantial damageNTSB CHI04LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Bourbon, INThe inadequate annual inspection in that the worn brake disks were not replaced which resulted in diminished braking capability during the landing roll. A factor associated with the accident was the utility pole that the airplane contacted.Feb 28, 2004 · N8438B · Substantial damageNTSB ATL04LA078Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T · Collegedale, TNThe pilot's inability to maintain directional control due to the inadequate grounding of the nose wheel steering clutches, as a result of inadequate maintenance inspection by other maintenance personnel to ensure the nose wheel steering clutches were…Feb 28, 2004 · N70FC · Substantial damageNTSB CHI04LA081Accident · No injuriesLimited investigationFinal reportAero Commander 112 · Jackson, MIThe left main tire failed which resulted in the CFI's inability to maintain directional control of the airplane during the landing. A factor associated with the accident was the snow bank which the airplane contacted.Feb 27, 2004 · N1203J · Substantial damageNTSB SEA04LA044Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Laurel, MTThe student pilot's failure to maintain aircraft control during the landing roll. Inadequate remedial action was a factor.Feb 24, 2004 · N7321K · Substantial damageNTSB NYC04CA076Accident · No injuriesData collectionFinal reportCessna 172N · Youngstown, OHAn inadvertent collision with a deer while landing.Feb 23, 2004 · N738EK · Substantial damageNTSB IAD04CA012Accident · No injuriesData collectionFinal reportCessna 182P · Titusville, PAThe pilot's failure to maintain directional control during the landing roll. A factor in the accident was the snow bank.Feb 22, 2004 · N7388N · Substantial damageNTSB CHI04LA075Accident · No injuriesLimited investigationFinal reportCessna 120 · Merrill, WIThe pilot's selection of unsuitable terrain to conduct a landing. Factors were the reported flat light conditions and the uneven terrain.Feb 21, 2004 · N73034 · Substantial damageNTSB ANC04LA029Accident · No injuriesLimited investigationFinal reportCessna 172P · Lutz, FLThe student pilot's misjudged landing flare, which resulted in a hard landing and subsequent collapse of the nose landing gear.Feb 21, 2004 · N612CB · Substantial damageNTSB ANC04LA028Accident · No injuriesLimited investigationFinal reportCessna 172P · Clewiston, FLThe student pilot's misjudged landing flare, which resulted in a hard landing, a collapse of the nose wheel landing gear, and the airplane nosing over when it encountered a ditch.Feb 19, 2004 · N124ER · Substantial damageNTSB ANC04IA025Incident · No injuriesIncident investigationFinal reportBoeing 767-300 ER · Miami, FLThe inadequate quality of material in the main landing gear bogie pivot pin, which resulted in a premature fracture of the pin.Feb 19, 2004 · PH-MCL · No damageNTSB CHI04LA073Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Memphis, MODirectional control not maintained by the flight instructor during the landing roll. The snow on the edge of the runway, and the wind gusts were factors.Feb 18, 2004 · N3419A · Substantial damageNTSB NYC04LA069Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Davis, WVThe pilot's failure to maintain directional control after encountering a snow patch on the runway. A factor related to the accident was the snowdrift.Feb 16, 2004 · N44LJ · Substantial damageNTSB NYC04CA070Accident · No injuriesData collectionFinal reportCessna 172R · Batavia, OHThe student pilot's improper flare and improper recover from a bounced landing, which resulted in a hard landing.Feb 16, 2004 · N121UC · Substantial damageNTSB LAX04CA136Accident · No injuriesData collectionFinal reportCessna 177A · Honolulu, HIthe pilot's misjudged landing flare, which resulted in a hard landing and porpoising down the runway.Feb 16, 2004 · N30599 · Substantial damageNTSB IAD04LA011Accident · No injuriesLimited investigationFinal reportCessna 210E · Pittsburgh, PAThe owner/pilot-mechanic's failure to comply with an airworthiness directive, which resulted in a fatigue fracture to the left main landing gear saddle.Feb 16, 2004 · N4974U · Substantial damageNTSB CHI04LA068Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Carroll, IAThe pilot's misjudgment of altitude and distance, and his inadequate remedial action which resulted in the failure to attain the proper touchdown point on the runway. A factor was the snow covered terrain which was encountered by the airplane.Feb 16, 2004 · N2258M · Substantial damageNTSB NYC04CA068Accident · No injuriesData collectionFinal reportCessna 172E · Batavia, NYThe pilot's failure to maintain directional control while landing. Factors were a tailwind and icy runway.Feb 15, 2004 · N369WP · Substantial damageNTSB ANC04LA023Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Naples, FLThe pilot's inadequate compensation for a crosswind condition during landing, which resulted in a loss of control and an on-ground encounter with terrain. Factors associated with the accident were a crosswind, and an inadvertent ground loop.Feb 14, 2004 · N226P · Substantial damageNTSB SEA04CA041Accident · No injuriesData collectionFinal reportPiper PA-28R-201T · Rexburg, IDThe pilot's failure to maintain runway alignment, and clearance from the snow bank. A snow bank adjacent to the runway was a factor.Feb 13, 2004 · N2216M · Substantial damageNTSB LAX04LA138Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Hollister, CAthe student pilot's failure to maintain directional control and the instructor's inadequate supervision of the flight.Feb 13, 2004 · N55073 · Substantial damageNTSB LAX04LA131Accident · No injuriesLimited investigationFinal reportCessna 185F · Mesa, AZthe pilot's inadequate compensation for the crosswind and his failure to maintain directional control, which resulted in an inadvertent ground loop. A factor in this accident was the pilot's diverted attention.Feb 13, 2004 · N4836Q · Substantial damageNTSB LAX04LA123Accident · Minor injuriesLimited investigationFinal reportBalloon Works Firefly 11 · Phoenix, AZthe failure of the deflation vent line, which resulted in the pilot not being able to control the balloon in the increased wind conditions.Feb 13, 2004 · N7244X · Substantial damageNTSB DEN04LA047Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Kremmling, COthe pilot's failure to attain landing flare and maintain adequate rotor rpm.Feb 13, 2004 · N83702 · Substantial damageNTSB CHI04LA072Accident · No injuriesLimited investigationFinal reportAmerican Champion 8GCBC · Sunburg, MNThe pilot's improper in-flight decision to land off-airport. A factor to the accident was the snow covered ditch.Feb 13, 2004 · N186AC · Substantial damageNTSB NYC04CA073Accident · No injuriesData collectionFinal reportCessna 172N · Easton, MDThe student pilot's improper flare, which resulted in a hard landing.Feb 12, 2004 · N734AT · Substantial damageNTSB LAX04CA122Accident · No injuriesData collectionFinal reportMcDonnell Douglas 369FF · Mesa, AZthe pilot's inadequate compensation for the wind gusts and subsequent failure to maintain directional control of the helicopter, which resulted in a hard landing. A contributing factor was a wind gust.Feb 12, 2004 · N630N · Substantial damageNTSB MIA04CA053Accident · No injuriesData collectionFinal reportAmerican Champion 7GCAA · Sebring, FLThe pilot's failure to maintain control during the landing rollout which resulted in the airplane ground looping and incurring damage.Feb 11, 2004 · N246SG · Substantial damageNTSB IAD04CA010Accident · No injuriesData collectionFinal reportPiper PA-20 · West Ossipee, NHThe pilot's inability to maintain runway alignment during the landing rollout. Factors included the night lighting conditions and the snow banks that prevented visual reference to the runway lights.Feb 11, 2004 · N2634A · Substantial damageNTSB SEA04LA040Accident · No injuriesLimited investigationFinal reportLancair LC42-550FG · Redmond, ORThe pilot rated passenger's failure to maintain directional control during the landing roll. Inadequate supervision by the pilot-in-command (CFI) and a taxiway sign were factors.Feb 10, 2004 · N6503C · Substantial damageNTSB NYC04CA066Accident · No injuriesData collectionFinal reportPiper PA-23-250 · Grt. Barrington, MAThe pilot's misjudgment of the airplane's distance/speed and failure to obtain the proper touchdown point, which resulted in an overrun. A factor was the cross wind.Feb 9, 2004 · N6760A · Substantial damageNTSB CHI04LA063Accident · No injuriesLimited investigationFinal reportPiper PA 28-161 · Lansing, ILThe improper flare by the pilot due to his diverted attention during landing. Factors were the pilot's failure to execute a go-around, the overload of the right main landing gear, and the snowbank.Feb 8, 2004 · N38988 · Substantial damageNTSB NYC04CA064Accident · No injuriesData collectionFinal reportCessna 172M · Cumberland, MDThe pilot's inadequate compensation for the crosswind while landing. A factor was the crosswind.Feb 7, 2004 · N61648 · Substantial damageNTSB LAX04CA134Accident · No injuriesData collectionFinal reportBellanca 7ECA · Groveland, CAthe pilot's failure to maintain a proper glide path and misjudged landing flare, which resulted in a hard landing. Also causal was the pilot's inadequate recovery from a bounced landing, resulting in a loss of directional control and collision with terrainFeb 7, 2004 · N5032G · Substantial damageNTSB LAX04CA118Accident · No injuriesData collectionFinal reportMooney M20C · Mesa, AZthe pilot's failure to maintain directional control of the airplane, which resulted in a collision with an airport sign.Feb 7, 2004 · N9675M · Substantial damageNTSB CHI04CA067Accident · No injuriesData collectionFinal reportCessna 172N · Cahokia, ILThe inadequate supervision by the certified flight instructor which lead to the student pilot's failure to maintain clearance from the snowbank during the landing. The snowbank was a factor.Feb 7, 2004 · N738EJ · Substantial damageNTSB LAX04LA119Accident · No injuriesLimited investigationFinal reportCessna 182S · Phoenix, AZthe pilot's misjudged landing flare, which led to a hard touchdown and a porpoise.Feb 6, 2004 · N2462X · Substantial damageNTSB IAD04CA009Accident · No injuriesData collectionFinal reportCessna 172R · Fredrick, MDThe student pilot's failure to maintain directional control during the landing. A factor was the snow bank.Feb 5, 2004 · N5165M · Substantial damageNTSB FTW04LA070Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Knox City, TXThe pilot's attempt to land on terrain not suitable for landing. A contributing factor was the soft terrain.Feb 2, 2004 · N8936W · Substantial damageNTSB ATL04LA072Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Indian Trail, NCThe pilot's attempted lift off without adequate airspeed resulting in a stall/mush and collision with trees while transitioning from an aborted landing to takeoff climb. A factor was the crosswind condition.Jan 30, 2004 · N1107C · Substantial damageNTSB CHI04LA062Accident · No injuriesLimited investigationFinal reportCessna 172M · Jeffersonville, INThe pilot selecting a closed runway for landing and the collapse of the nose landing gear. Factors were the pilot's failure to obtain NOTAM information and the snowbank across the closed runway.Jan 28, 2004 · N70256 · Substantial damageNTSB DEN04LA046Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Bountiful, UTthe pilot's failure to maintain aircraft control and adequate visual outlook during the landing flare. Contributing factors include the pilot's lack of recent experience, the snow bank, and the snow-covered runway.Jan 27, 2004 · N33363 · Substantial damageNTSB LAX04CA107Accident · No injuriesData collectionFinal reportPiper PA-28-180C · Minden, NVThe student pilot's failure to maintain directional control during the landing roll.Jan 26, 2004 · N7922W · Substantial damage