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 LAX01LA102Accident · No injuriesLimited investigationFinal reportCessna 172N · San Diego, CAThe pilot's failure to maintain directional control of the airplane during landing rollout.Feb 15, 2001 · N4922D · Substantial damageNTSB LAX01LA100Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · San Jose, CAThe pilot's inadequate compensation for the existing crosswind condition and subsequent failure to maintain directional control during the landing rollout.Feb 15, 2001 · N53893 · Substantial damageNTSB CHI01LA091Accident · No injuriesLimited investigationFinal reportCessna 206H · New Richmond, WIThe pilot was unable to maintain directional control of the airplane when it contacted a patch of ice during the landing roll. Factors associated with the accident were the ice and the snow bank which the airplane contacted and the pilot inadvertantly landed…Feb 15, 2001 · N55PY · Substantial damageNTSB CHI01LA090Accident · No injuriesLimited investigationFinal reportBeech 95-55 · Scottsbluff, NEthe checklist not followed and the wheels-up landing performed by the pilot. The runway light was a contributing factor.Feb 15, 2001 · N98PA · Substantial damageNTSB MIA01LA078Accident · No injuriesLimited investigationFinal reportLearjet 35A · Punta Gorda, FLthe pilot misjudged the flare resulting in a hard landing, and impact with the runway. A factor in the accident was reduced visibility because of ground fog.Feb 14, 2001 · N394JP · Substantial damageNTSB LAX01LA097Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Petaluma, CAFailure of non-airframe and powerplant mechanic/certificated owners to properly install a new mixture cable that became entangled in the nose landing gear during its extension for landing, resulting in a loss of engine power.Feb 14, 2001 · N8286P · Substantial damageNTSB SEA01TA050Accident · No injuriesFinal reportBeech 200 · Olympia, WAThe pilot's failure to attain the proper touchdown point for landing. A factor was weather conditions below published approach minimums.Feb 13, 2001 · N222KA · Substantial damageNTSB DEN01LA052Accident · No injuriesLimited investigationFinal reportCessna 441 · Englewood, COthe pilot's failure to verify that the landing gear was down and locked before landing, which resulted in a wheels-up landing.Feb 13, 2001 · N24PT · Substantial damageNTSB ATL01LA035Accident · Minor injuriesLimited investigationFinal reportMichael E. Nourse RV-6A · Immokalee, FLThe pilot's improper flare, and his evaluation of the gusty wind conditions resulted in the collision with the terrain.Feb 12, 2001 · N6279E · Substantial damageNTSB LAX01LA096Accident · No injuriesLimited investigationFinal reportCessna 195A · Palm Springs, CAThe flight instructor's inadequate supervision of his dual student who lost directional control on landing.Feb 10, 2001 · N95U · Substantial damageNTSB CHI01FA084Accident · Minor injuriesField investigationFinal reportBeech 1900D · Chicago, ILThe flightcrew not lowering the landing gear and/or verifying the landing gear position as required by three separate checklists, which resulted in an inadvertent gear-up landing. A factor to the accident was the flightcrew not complying with the required…Feb 10, 2001 · N97UX · Substantial damageNTSB NYC01LA078Accident · No injuriesLimited investigationFinal reportCessna 172P · Miamisburg, OHThe pilot's failure to attain the proper touchdown point. Factors included the nighttime conditions, and the pilot's improper decision to leave the runway lighting at high intensity.Feb 9, 2001 · N62332 · Substantial damageNTSB MIA01FA074Accident · Minor injuriesField investigationFinal reportAmerican 8KCAB · Leesburg, FLThe failure of the pilot of N123WA and the failure of both pilots of N301NL to adequately insure visual separation between their aircraft and other aircraft in the landing pattern, resulting in a runway collision. Factors contributing to the accident were the…Feb 9, 2001 · N123WA · 2 aircraft · Substantial damageNTSB SEA01LA047Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Bozeman, MTThe pilot rated passenger's failure to maintain directional control during the landing. A factor was the snow berm which the aircraft rolled into during the landing.Feb 8, 2001 · N7940H · Substantial damageNTSB ATL01LA030Accident · No injuriesLimited investigationFinal reportLearjet 25B · Ft. Pierce, FLThe mechanic's failure to properly install and secure the left main landing gear aft trunnion pin in accordance with procedures.Feb 4, 2001 · N48WA · Substantial damageNTSB LAX01LA090Accident · Minor injuriesLimited investigationFinal reportLuscombe 8F · Tombstone, AZThe pilot's lack of directional control on the landing roll, which resulted in a ground loop and inadvertent nose over.Feb 3, 2001 · N747MP · Substantial damageNTSB CHI01LA081Accident · No injuriesLimited investigationFinal reportCessna 172RG · Troy, MIthe excessive touchdown airspeed and the directional control not maintained by the pilot. The snow bank was a contributing factor.Feb 3, 2001 · N369ER · Substantial damageNTSB CHI01LA079Accident · No injuriesLimited investigationFinal reportCessna 310R · Cahokia, ILThe collapse of the left main landing gear during landing roll for undetermined reasons.Feb 2, 2001 · N4249C · Substantial damageNTSB CHI01LA078Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Charlevoix, MIThe pilot failed to maintain directional control of the airplane due to inadequate compensation for the wind conditions. Factors associated with the accident were the gusty crosswind, the icy runway, and the snow bank.Feb 2, 2001 · N4123K · Substantial damageNTSB DEN01LA051Accident · No injuriesLimited investigationFinal reportCessna 172 · Grand Junction, COFailure by the pilot to maintain directional control of the aircraft during landing roll. A factor was lack of total pilot experience in aircraft make and model.Jan 31, 2001 · N6830A · Substantial damageNTSB ATL01LA032Accident · No injuriesLimited investigationFinal reportCessna 208 · Key West, FLThe airplanes' inadvertent collision with a swell during a water landing near a ferry boat that resulted the overload failure of the rear float/strut assembly.Jan 31, 2001 · N208KW · Substantial damageNTSB ANC01LA034Accident · No injuriesLimited investigationFinal reportDouglas DC-6B · Crooked Creek, AKThe flight crew's misjudged flare while landing. Factors associated with the accident were flat light conditions, snow-covered terrain, and an uphill runway grade.Jan 31, 2001 · N4390F · Substantial damageNTSB FTW01LA055Accident · No injuriesLimited investigationFinal reportSchmidt Questair Venture · Fort Worth, TXThe pilot's failure to maintain directional control during the landing roll. Factors were the crosswind and soft terrain condition.Jan 30, 2001 · N425V · Substantial damageNTSB DEN01LA046Accident · No injuriesLimited investigationFinal reportCessna R172E · Colorado Spring, COthe student pilot's inadequate compensation for the crosswind during landing roll. A contributing factor was the cross wind weather condition.Jan 30, 2001 · N7905N · Substantial damageNTSB SEA01LA043Accident · No injuriesLimited investigationFinal reportS.N.I.A.S SE 3130 Alouette II · Driggs, IDThe pilot's failure to maintain aircraft control for undetermined reasons.Jan 29, 2001 · N31330 · Substantial damageNTSB MIA01LA068Accident · No injuriesLimited investigationFinal reportCessna 152 · Edgewater, FLThe student pilot's failure to maintain directional control on landing rollout with a crosswind. This resulted in the airplane departing the runway, colliding with a berm/ridge, becoming airborne, and colliding with the terrain in a nose down attitude.Jan 29, 2001 · N152DF · Substantial damageNTSB LAX01LA082Accident · No injuriesLimited investigationFinal reportBeech BE-55 · San Bernardino, CAThe failure of the pilot under instruction to extend the landing gear during the landing approach. A factor was the flight instructor's inadequate supervision.Jan 27, 2001 · N1280Z · Substantial damageNTSB FTW01LA056Accident · No injuriesLimited investigationFinal reportNeely B D Kit Fox 4 · Cedar Park, TXthe pilot's excessive braking during the landing roll.Jan 27, 2001 · N704KF · Substantial damageNTSB NYC01LA069Accident · Minor injuriesLimited investigationFinal reportMooney M-20 · S. Charleston, WVThe pilot's failure to maintain runway alignment during the landing roll.Jan 26, 2001 · N9558M · Substantial damageNTSB ANC01TA032Accident · No injuriesFinal reportCessna 172 · Kipnuk, AKThe pilot's inadequate compensation for a crosswind during the landing roll. Factors in the accident were the presence of a crosswind, an icy runway and snow covered terrain, the pilot's inadequate preflight planning/preparation, and an inaccurate wind…Jan 23, 2001 · N737CU · Substantial damageNTSB NYC01IA068Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-232 · Jamaica, NYThe pilot's decision to perform an auto rollout on a snow contaminated runway, which had not been demonstrated, and which resulted in a loss of directional control, when the capability of the autoland system to maintain directional control was exceeded.…Jan 21, 2001 · N509JB · No damageNTSB SEA01LA041Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Arlington, WAThe pilot's failure to maintain directional control during landing roll.Jan 20, 2001 · N228C · Substantial damageNTSB CHI01LA071Accident · No injuriesLimited investigationFinal reportCessna 152 · Ann Arbor, MIThe CFI's delay in iniating remedial action to arrest the sink rate which developed on final approach. Factors associated with the accident were the student pilot failed to maintain a proper glidepath on final approach and the snow bank which the airplane…Jan 20, 2001 · N714UA · Substantial damageNTSB ATL01LA025Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Columbus, MSThe pilots failure to maintain directional control of the airplane ,and subsequently resulted in the collapse of the right main landing gear.Jan 20, 2001 · N7107N · Substantial damageNTSB DEN01LA043Accident · No injuriesLimited investigationFinal reportMaule M-7-235C · Durango, COfailure by the pilot to maintain directional control of the aircraft during landing roll. A factor was the pilot's lack of experience in aircraft make and model.Jan 19, 2001 · N246SV · Substantial damageNTSB DEN01LA042Accident · No injuriesLimited investigationFinal reportCessna P210N · Pagosa Springs, COfailure to maintain directional control of the aircraft after an encounter with adverse weather during landing roll. A factor was ground fog.Jan 18, 2001 · N4817K · Substantial damageNTSB ATL01LA024Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Augustine, FLThe pilots failure to maintain directional control during the landing roll, which resulted in the collision with the airport sign.Jan 18, 2001 · N704ZF · Substantial damageNTSB CHI01LA065Accident · No injuriesLimited investigationFinal reportLuscombe 8E · North Platte, NEThe inadvertent ground loop. Factors associated with the accident were the pilot selected the wrong runway on which to land, the quartering tailwind, the icy runway, and the snow bank which the airplane contacted.Jan 16, 2001 · N2953K · Substantial damageNTSB SEA01LA044Accident · No injuriesLimited investigationFinal reportBell 206B · McMinnville, ORThe pilot's failure to apply adequate power during a practice autorotation. A factor contributing to the accident was a rough/uneven area on the asphalt landing surface.Jan 15, 2001 · N58WW · Substantial damageNTSB LAX01LA077Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Atwater, CAThe student's failure to maintain directional control while landing in a crosswind, his improper compensation for wind conditions, and the flight instructor's inadequate flight supervision.Jan 14, 2001 · N3854P · Substantial damageNTSB LAX01LA076Accident · No injuriesLimited investigationFinal reportPurvis/Thorpe T-18 · Chiriaco Summit, CAThe dual student's improper recovery from a bounced landing, his failure to maintain directional control during the go-around, and the flight instructor's inadequate supervision of the go-around attempt.Jan 14, 2001 · N39JP · Substantial damageNTSB ATL01FA021Accident · Serious injuriesField investigationFinal reportLearjet LJ-60 · Troy, ALOn ground collision with deer during landing roll, and the inadvertent thrust reverser stowage caused by the damage to the landing gear squat switch by the collision, and subsequent application of forward thrust during rollout.Jan 14, 2001 · N1DC · DestroyedNTSB SEA01LA038Accident · No injuriesLimited investigationFinal reportCessna 402B · Ontario, ORPilot's failure to maintain aircraft control while landing. Factors include a snow covered runway.Jan 9, 2001 · N6384X · Substantial damageNTSB MIA01LA056Accident · Serious injuriesLimited investigationFinal reportMaule MXT-7-180A · Perry, FLThe loss of control on landing due to the student's improper recovery from a bounced landing, and the resulting nose over on the grass runway.Jan 7, 2001 · N40030 · Substantial damageNTSB IAD01LA024Accident · No injuriesLimited investigationFinal reportCessna 172P · Concord, NHThe flight instructor's improper decision to land downwind on the snow and ice covered runway with a tailwind, and his failure to perform a go-around. Factors in the accident were the tailwind and the snow and ice on the runway.Jan 7, 2001 · N54931 · Substantial damageNTSB IAD01LA023Accident · No injuriesLimited investigationFinal reportCessna 172S · Lincoln Park, NJthe pilot's failure to maintain proper runway alignment during landing. Factors in the accident were the night lighting and the snow bank.Jan 7, 2001 · N699LP · Substantial damageNTSB LAX01LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Livermore, CAThe student pilot's inadequate compensation for a tailwind during final approach and her improper recovery from a bounced landing.Jan 5, 2001 · N6165M · Substantial damageNTSB FTW01LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Bristow, OKThe pilot's inadequate compensation for the crosswind conditions, which resulted in the airplane striking a snow bank during the landing flare/touchdown. A factor was the crosswind weather condition.Jan 4, 2001 · N68472 · Substantial damageNTSB DEN01LA038Accident · No injuriesLimited investigationFinal reportAviat A-1A · Eden, UTthe pilot's failure to maintain aircraft control during a landing attempt. A contributing factor was his failure to check the snow conditions in the field before the flight.Jan 4, 2001 · N26HV · Substantial damageNTSB CHI01LA061Accident · No injuriesLimited investigationFinal reportMooney M20S · Port Huron, MIThe pilot failed to maintain directional control of the airplane and the runway selected resulted in a tailwind condition. Factors associated with the accident were the gusty crosswind and the snow bank.Jan 1, 2001 · N2184N · Substantial damage