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 FTW01LA160Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Mount Pleasant, TXthe pilot's inadvertent ground loop during the landing roll. A contributing factor was his lack of total experience in tail wheel-equipped airplanes.Jul 4, 2001 · N220H · Substantial damageNTSB DEN01LA120Accident · No injuriesLimited investigationFinal reportCessna 172Q · Englewood, COthe pilot's failure to properly recover from a bounced landing. A contributing factor were the adverse wind conditions.Jul 3, 2001 · N66076 · Substantial damageNTSB NYC01LA163Accident · No injuriesLimited investigationFinal reportCessna 172P · Stevensville, MDThe pilot's improper flare and his improper recovery from a bounced landing.Jul 2, 2001 · N54576 · Substantial damageNTSB NYC01LA161Accident · No injuriesLimited investigationFinal reportCessna 152 · Manassas, VAThe student pilot's loss of control of the airplane after bouncing the landing. A factor in the accident was her heightened anxiety over making her first solo landing.Jul 2, 2001 · N5286P · Substantial damageNTSB LAX01LA232Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Hayward, CAthe student's excessive rate of descent during a practice autorotation, and, the inadequate use of the rotorcraft flight controls by both pilots during the attempted recovery, which resulted in a hard landing. The flight instructor's inadequate supervision…Jul 2, 2001 · N4052K · Substantial damageNTSB IAD01LA074Accident · No injuriesLimited investigationFinal reportCessna 182S · Montgomery, NYThe pilot's improper flare, and improper recovery from a bounced landing.Jul 2, 2001 · N2437P · Substantial damageNTSB ANC01LA081Accident · No injuriesLimited investigationFinal reportLockheed L-382G · Lake Minchumina, AKThe flight crew's improper recovery from a bounced landing. Factors associated with the accident were the selection of an unsuitable landing area, and a rough/uneven landing surface.Jul 2, 2001 · N401LC · Substantial damageNTSB LAX01LA230Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Nixon, NVThe pilot’s failure to attain the proper touchdown point and his misjudged distance/speed during landing rollout. Factors were the tailwind condition and the downhill landing area.Jul 1, 2001 · N8638V · Substantial damageNTSB DEN01LA118Accident · No injuriesLimited investigationFinal reportBeech BE76 · Hudson, COmain landing gear collapse on touchdown for reasons undetermined.Jun 30, 2001 · N877SP · Substantial damageNTSB ATL01LA069Accident · No injuriesLimited investigationFinal reportCessna 177 · Milledgeville, GAThe student pilot's failure to maintain directional control and the subsequent collision with an object during an attempted landing. A factor was porpoise induced oscillation.Jun 29, 2001 · N3381T · Substantial damageNTSB LAX01LA225Accident · No injuriesLimited investigationFinal reportCessna U206D · Boulder City, NVthe pilot's inadequate compensation for the tailwind gust and subsequent failure to maintain directional control of the airplane while landing.Jun 28, 2001 · N72218 · Substantial damageNTSB FTW01LA157Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Uvalde, TXThe pilot's failure to verify the landing gear was down and locked, which resulted in a wheels up landing and subsequent ground fire.Jun 28, 2001 · N6474P · Substantial damageNTSB IAD01LA072Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Berlin, MDpilot's failure to maintain directional control during landing roll. A factor was the crosswind.Jun 27, 2001 · N8582V · Substantial damageNTSB DEN01LA123Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Bryce Canyon, UTthe pilot's failure to maintain directional control during landing. A contributing factor was the crosswind.Jun 27, 2001 · N872CC · Substantial damageNTSB LAX01LA223Accident · No injuriesLimited investigationFinal reportRudolph Venture · Grass Valley, CAThe pilot's failure to maintain directional control during the landing rollout.Jun 26, 2001 · N84V · Substantial damageNTSB LAX01LA219Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Paso Robles, CAthe pilot's failure to maintain rotor rpm during a practice autorotational landing, which resulted in a hard landing.Jun 25, 2001 · N8724F · Substantial damageNTSB MIA01LA173Accident · No injuriesLimited investigationFinal reportBeech 77 · Rock Hill, SCThe poor weather evaluation by the pilot for landing with a tailwind and failure of the pilot to perform a go-around after the first bounced landing.Jun 24, 2001 · N3818D · Substantial damageNTSB LAX01LA220Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth Nimbus 3/24.5 · Montague, CAA loss of control during landing flare. Contributing to the accident was the gusty wind condition.Jun 24, 2001 · N4427M · Substantial damageNTSB LAX01LA218Accident · No injuriesLimited investigationFinal reportStolp Starduster SA-300 · El Cajon, CAThe pilot's failure to maintain directional control during landing rollout.Jun 24, 2001 · N711MH · Substantial damageNTSB CHI01LA187Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Brooklyn, MIThe proper touchdown point exceeded, all of the available runway not used, and aircraft control not being maintained by the pilot during the landing. Factors to the accident were the pilot mistaking the taxiway for the runway, the pilot not performing a…Jun 24, 2001 · N8210Z · Substantial damageNTSB ANC01LA072Accident · No injuriesLimited investigationFinal reportArctic S-1B2 · Petersburg, AKThe pilot's selection of an unsuitable landing area. A factor associated with the accident was soft terrain.Jun 24, 2001 · N61AT · Substantial damageNTSB MIA01LA174Accident · No injuriesLimited investigationFinal reportSocata TB-20 · Naples, FLThe collapse of the left main landing gear for undetermined reasons resulting in the loss of directional control and subsequent on-ground collision with a ravine.Jun 23, 2001 · N1887S · Substantial damageNTSB FTW01LA154Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B-15 · Celina, TXthe unsuitable landing area selected by the pilot-in-command which resulted in a hard landing. A contributing factor was the uneven/rough terrain.Jun 23, 2001 · N72524 · No damageNTSB LAX01LA217Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Auburn, CAFailure of the student pilot to maintain a proper airspeed during landing, which lead to a hard landing and porpoise down the runway leading to the collapse of the nose landing gear.Jun 22, 2001 · N2572N · Substantial damageNTSB MIA01FA169Accident · Minor injuriesField investigationFinal reportBell 206-L4 · Daytona Beach, FLThe failure of the pilot to maintain directional control following a hard landing resulting from a failure to maintain rotor rpm.Jun 20, 2001 · N802DS · Substantial damageNTSB FTW01LA148Accident · No injuriesLimited investigationFinal reportCessna 152 · Lapace, LAthe student pilot flared the airplane high, which resulted in a hard landing.Jun 20, 2001 · N1FC · Substantial damageNTSB ANC01LA071Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Egegik, AKThe pilot's selection of unsuitable terrain for landing. Factors in the accident were a soft area of runway, and sunglare.Jun 17, 2001 · N8096V · Substantial damageNTSB SEA01LA119Accident · Minor injuriesLimited investigationFinal reportShaub EAA Biplane (P-2) · Zillah, WAThe pilot's failure to maintain directional control. A contributing factor was a tailwind.Jun 16, 2001 · N39RS · Substantial damageNTSB LAX01LA210Accident · No injuriesLimited investigationFinal reportCessna A185F · Ash Fork, AZThe pilot's misjudged touchdown location on a short runway. Contributing factors were the presence of a tailwind and the proximity of trees.Jun 16, 2001 · N4805 · Substantial damageNTSB CHI01LA175Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Morris, ILthe directional control not maintained by the pilot. The crosswind was a contributing factor.Jun 16, 2001 · N3526Z · Substantial damageNTSB CHI01LA172Accident · Serious injuriesLimited investigationFinal reportShanklin RV-6A · Poseyville, INthe premature flare by the pilot.Jun 16, 2001 · N76MS · Minor damageNTSB CHI01LA168Accident · No injuriesLimited investigationFinal reportSchleicher ASW-20 · HIghland, ILThe pilot's failure to extend the spoilers during landing approach, which resulted in a touchdown at a higher than normal airspeed. An additional cause was the intentional ground loop/swerve maneuver performed by the pilot to avoid overrunning the end of the…Jun 16, 2001 · N76SP · Substantial damageNTSB CHI01FA169Accident · Serious injuriesField investigationFinal reportCirrus Design SR22 · Springfield, MOthe lack of experience in the type of airplane and directional control not maintained by the pilot. The improper flare and parked airplane were contributing factors.Jun 16, 2001 · N739BB · Substantial damageNTSB ANC01LA101Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Homer, AKThe student pilot's inadvertent ground loop. A factor in the accident was the pilot's lack of total experience.Jun 16, 2001 · N6966D · Substantial damageNTSB ANC01LA069Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Anchorage, AKThe pilot's inadequate bounced landing recovery, and his failure to correct for torque/P-factor during an aborted landing.Jun 16, 2001 · N9704D · Substantial damageNTSB LAX01LA209Accident · No injuriesLimited investigationFinal reportCessna 170B · Payson, AZThe pilot's failure to maintain directional control and improper corrective action while landing in a quartering tailwind condition. A contributing factor was his lack of experience in the type of operation.Jun 15, 2001 · N4338B · Substantial damageNTSB IAD01LA069Accident · Serious injuriesLimited investigationFinal reportBucker Jungmann C.A.S.A. 1.131 · Plymouth, MAThe pilot's failure to maintain altitude during an approach and inadequate visual lookout, which resulted in a collision with a runway sign.Jun 15, 2001 · N131HH · Substantial damageNTSB CHI01LA176Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Green Bay, WIThe pilot not performing the pre-landing checklist, and the wheels-up landing made by the pilot.Jun 14, 2001 · N3718T · Substantial damageNTSB CHI01LA174Accident · No injuriesLimited investigationFinal reportSmith Aerostar 600 · Wonewoc, WIThe deer on the runway as the airplane was landing.Jun 14, 2001 · N7484S · Substantial damageNTSB DEN01LA116Accident · Serious injuriesLimited investigationFinal reportCameron Balloons N-210 · Rio Rancho, NMthe pilot's inadvertent weather encounter with wind shear, and the resulting inability to maintain the proper landing descent rate, which resulted in a hard landing. A factor was the high wind weather condition.Jun 13, 2001 · N7507V · No damageNTSB MIA01LA160Accident · No injuriesLimited investigationFinal reportCessna 182S · Corolla, NCThe pilots failure to maintain directional control during landing flare and touchdown resulting in the airplane touching down on the left side of the runway and the left wing contacting trees.Jun 12, 2001 · N314FR · Substantial damageNTSB FTW01LA145Accident · No injuriesLimited investigationFinal reportCessna 172S · Baton Rouge, LAthe student pilot's improper recovery from a bounced landing.Jun 12, 2001 · N749SP · Substantial damageNTSB SEA01LA117Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Billings, MTThe pilot-in-command's failure to maintain directional control of the aircraft during the landing roll. A contributing factor was the gusty crosswind conditions.Jun 11, 2001 · N83464 · Substantial damageNTSB NYC01LA142Accident · Minor injuriesLimited investigationFinal reportCessna 170A · South Charlesto, WVThe pilot's failure to maintain directional control while landing.Jun 11, 2001 · N9509A · Substantial damageNTSB CHI01LA201Accident · No injuriesLimited investigationFinal reportPiper J3-C65 · West Fargo, NDthe pilot's inadequate preflight planning and the unsuitable landing area selected by the pilot. Additional factors were the uneven terrain and the failed float assembly in overload.Jun 11, 2001 · N3253N · Substantial damageNTSB NYC01LA143Accident · No injuriesLimited investigationFinal reportYakovlev 52 · Fredericksburg, VAThe pilot's failure to obtain the proper touchdown point, which resulted in an overrun.Jun 10, 2001 · N114YK · Substantial damageNTSB MIA01LA156Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Bennettsville, SCThe pilot failure to obtain the proper touchdown point on the runway resulting in the airplane landing long, over running the runway, colliding with a telephone pole separating the right wing, and coming to rest in the parking lot of a restaurant.Jun 9, 2001 · N3066G · Substantial damageNTSB LAX01LA206Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Winnemucca, NVThe pilot's failure to obtain weather information or an in-flight advisory that would have described current wind information at the destination airport and his subsequent failure to maintain directional control during landing.Jun 9, 2001 · N7783K · Substantial damageNTSB LAX01LA203Accident · No injuriesLimited investigationFinal reportMooney M20J · Jackson, CAFailure of the pilot to maintain proper airspeed for landing and airplane control with an existing crosswind. A contributing factor was the distraction of the pilot by a yelling passenger.Jun 9, 2001 · N4235H · Substantial damageNTSB DEN01LA115Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Longmont, COthe pilot's failure to maintain directional control during landing. A contributing factor was the tailwind.Jun 9, 2001 · N1614K · Substantial damage