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 LAX00LA262Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Lake Piru, CAThe improper use of the cyclic control by the pilot under instruction, and the flight instructor's lack of remedial action.Jul 14, 2000 · N169CW · Substantial damageNTSB CHI00LA196Accident · Serious injuriesLimited investigationFinal reportAerostar S-77A · River Falls, WIthe unfavorable wind condition for landing and control of the balloon during landing not possible by the pilot.Jul 14, 2000 · N5075H · No damageNTSB LAX00TA263Accident · No injuriesFinal reportCessna 337G · Battle Mountain, NVFailure of the pilot to extend the landing gear, and his failure to follow the published before landing checklist concerning extension of the landing gear.Jul 13, 2000 · N3273D · Substantial damageNTSB CHI00LA202Accident · No injuriesLimited investigationFinal reportCessna 152 · Park River, NDdirectional control not being maintained by the pilot during landing.Jul 13, 2000 · N69066 · Substantial damageNTSB CHI00LA199Accident · No injuriesLimited investigationFinal reportCessna 140 · St. Francis, MNthe pilot selected to land in a field that was unsuitable for landing. A factor was the soft field.Jul 13, 2000 · N76427 · Substantial damageNTSB CHI00LA194Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Olivia, MNthe failure of the pilot to maintain directional control of the aircraft. A factor to the accident was the pocket gopher mound in the wheat field.Jul 13, 2000 · N8136D · Substantial damageNTSB ANC00LA086Accident · No injuriesLimited investigationFinal reportCessna 207 · Kotlik, AKThe pilot's inadequate flare during landing.Jul 12, 2000 · N1549U · Substantial damageNTSB CHI00LA190Accident · No injuriesLimited investigationFinal reportCessna 180 · Saint Cloud, MNdirectional control not being maintained by the pilot during landing rollout.Jul 9, 2000 · N4940A · Substantial damageNTSB NYC00LA188Accident · No injuriesLimited investigationFinal reportCessna 182S · White Plains, NYThe student pilot's failure to recover from a bounced landing and her failure to perform a go-around.Jul 8, 2000 · N729AD · Substantial damageNTSB IAD00LA060Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Fitchburg, MApilot's inadequate compensation for the crosswind. A factor was the crosswind.Jul 8, 2000 · N21072 · Substantial damageNTSB IAD00LA058Accident · Serious injuriesLimited investigationFinal reportCessna 206 · Annapolis, MDThe pilot's failure to attain the proper touchdown point, and his failure to perform a go-around.Jul 8, 2000 · N5316U · Substantial damageNTSB FTW00LA203Accident · No injuriesLimited investigationFinal reportAero Commander 685 · Pine Bluff, ARthe pilot's misjudged flare, which resulted in a hard landing. A contributing factor was the pilot's lack of total experience in the make and model of airplane.Jul 8, 2000 · N1203N · Substantial damageNTSB DEN00LA126Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Erie, COAircraft control was not possible by the flight instructor due to the inadequate maintenance adjustment of the tail wheel steering system by maintenance personnel. Factors were the inadequate aircraft preflight by the second pilot who was receiving a…Jul 8, 2000 · N4785F · Substantial damageNTSB LAX00LA254Accident · Minor injuriesLimited investigationFinal reportNorth American AT-6F · Grass Valley, CAfailure of the pilot to maintain directional control during the landing roll resulting in a collision with terrain.Jul 7, 2000 · N7475C · Substantial damageNTSB ANC00LA085Accident · No injuriesLimited investigationFinal reportCessna 207 · Anaktuvuk Pass, AKThe pilot's selection of an unsuitable landing area. Factors associated with the accident were a fuel drum, and a tailwind.Jul 7, 2000 · N1658U · Substantial damageNTSB SEA00LA125Accident · No injuriesLimited investigationFinal reportCessna 172I · Sandy, ORThe pilot's failure to attain the proper touchdown point for landing, and his failure to go around from the improperly executed approach. Factors included the pilot's failure to attain the proper glidepath on the approach, a short landing runway, and…Jul 6, 2000 · N35359 · Substantial damageNTSB NYC00LA193Accident · No injuriesLimited investigationFinal reportCessna U206G · North Haven, METhe pilot's failure to perform a go-around. Factors related to the accident were the pilot's lack of total flight experience in make and model, and the short landing area.Jul 6, 2000 · N756HK · Substantial damageNTSB NYC00LA190Accident · No injuriesLimited investigationFinal reportSpartan 7W · Jefferson, OHThe overload failure of the left main gear strut housing.Jul 6, 2000 · N17613 · Substantial damageNTSB NYC00LA187Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Wildwood, NJan improper flare by the pilot which induced an overload failure on the left side landing gear bolts. Factors were the corrosion on the bolts, and the failure of the operator to change the u-bolt in accordance with the manufacturer's recommendations.Jul 6, 2000 · N10989 · Substantial damageNTSB MIA00LA216Accident · No injuriesLimited investigationFinal reportAviat Husky · Dayton, TNThe pilot's failure to maintain directional control of the airplane during landing flare into a crosswind, resulting in a runway excursion off the runway edge and collision of the wingtip with the terrain.Jul 6, 2000 · N415JB · Substantial damageNTSB LAX00LA251Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Tucson, AZThe student pilot's failure to maintain directional control of the airplane during landing.Jul 6, 2000 · N2196T · Substantial damageNTSB CHI00FA184Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Quincy, ILThe pilots failure to maintain control of the aircraft and his continued flight into adverse weather. Factors were the fog, and the crops.Jul 6, 2000 · N1783P · DestroyedNTSB FTW00LA193Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Greenville, TXThe pilot's improper flare, which resulted in a hard landing.Jul 4, 2000 · N1709T · Substantial damageNTSB SEA00LA126Accident · No injuriesLimited investigationFinal reportCessna 120 · Toston, MTThe pilot's failure to maintain sufficient altitude to avoid contact with the ground. Contributing factors were the downdraft conditions and the fence post.Jul 3, 2000 · N2146N · Substantial damageNTSB SEA00LA123Accident · No injuriesLimited investigationFinal reportCessna 210E · Pocatello, IDImproper landing flare resulting in a hard landing. Factors include dark night environmental conditions and lack of recent experience for night landings.Jul 3, 2000 · N2331F · Substantial damageNTSB NYC00LA181Accident · No injuriesLimited investigationFinal reportCessna 152 · Beverly, MAThe pilot's improper flare, which resulted in a loss of control.Jul 3, 2000 · N48858 · Substantial damageNTSB IAD00LA055Accident · No injuriesLimited investigationFinal reportCessna 172H · Kutztown, PAThe pilot's improper recovery from a bounced landing, and his delay in remedial action.Jul 3, 2000 · N8805Z · Substantial damageNTSB DEN00LA121Accident · No injuriesLimited investigationFinal reportCessna 172P · Price, UTThe pilot's failure to maintain directional control of the aircraft during landing roll. Factors were strong and gusty winds.Jul 3, 2000 · N51208 · Substantial damageNTSB SEA00LA120Accident · No injuriesLimited investigationFinal reportCessna U206B · Yellow Pine, IDThe locknut was not secured and backed off the bolt. An improper maintenance installation was a factor.Jul 2, 2000 · N3488L · Substantial damageNTSB NYC00LA182Accident · No injuriesLimited investigationFinal reportCessna 180 · Jackson Center, PAA seized left brake as reported by the pilot.Jul 2, 2000 · N3131D · Substantial damageNTSB LAX00TA269Accident · No injuriesFinal reportCessna 182Q · So. Lake Tahoe, CAfailure of the pilot to maintain an adequate airspeed margin resulting in a stall and hard landing.Jul 2, 2000 · N4892N · Substantial damageNTSB CHI00LA197Accident · No injuriesLimited investigationFinal reportCessna 152 · Lincoln, NEthe misjudged flare and the inadequate recovery from the bounced landing performed by the student pilot.Jul 2, 2000 · N6432M · Substantial damageNTSB NYC00LA177Accident · No injuriesLimited investigationFinal reportCessna 152 · West Point, VAThe student pilot's failure to maintain directional control during the landing roll.Jul 1, 2000 · N68910 · Substantial damageNTSB LAX00LA249Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Pacoima, CAthe pilot's failure to recover from a bounced landing.Jul 1, 2000 · N80710 · Substantial damageNTSB LAX00LA248Accident · Serious injuriesLimited investigationFinal reportKashan Michael Berkut 540 · Jackpot, NVthe pilot's loss of control on landing after encountering a dust devil/whirlwind.Jul 1, 2000 · N600SE · Substantial damageNTSB IAD00LA061Accident · No injuriesLimited investigationFinal reportCessna 172H · Friendly, MDthe student pilot's inadequate compensation for winds that resulted in his failure to maintain runway alignment and a hard landing.Jul 1, 2000 · N1688F · Substantial damageNTSB IAD00LA056Accident · Minor injuriesLimited investigationFinal reportEnstrom F28C · Ravenna, OHthe student pilot's loss of helicopter control after suffering a stroke in flight.Jul 1, 2000 · N20PZ · Substantial damageNTSB CHI00LA219Accident · No injuriesLimited investigationFinal reportMcCann Wheeler Express/FT · Fort Wayne, INthe obstructed brake pedals and the unavailable brakes to the pilot. Factors were the parked airplane and the fence.Jul 1, 2000 · N521MC · Substantial damageNTSB MIA00LA194Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Montgomery, ALthe student pilot's failure to maintain aircraft control upon encountering variable winds during the landing flare/touchdown and his failure to recover from the resulting bounced landing which resulted in substantial damage to the aircraft.Jun 30, 2000 · N9713T · Substantial damageNTSB DEN00LA129Accident · No injuriesLimited investigationFinal reportCessna 172N · Durango, COThe pilot prematurely flaring the airplane for landing, resulting in a hard landing, followed by an inadvertent pilot-induced porpoise and loss of directional control. A factor was the fence.Jun 30, 2000 · N4642J · Substantial damageNTSB SEA00LA118Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Bend, ORImproper preflight preflight planning/preparation by the pilot-in-command. Factors included a worn tailwheel tire and the VASI lighting system.Jun 29, 2000 · N31286 · Substantial damageNTSB FTW00LA223Accident · No injuriesLimited investigationFinal reportEngineering & Research Ercoupe 415-CD · Abbeville, LAThe pilot's misjudged flare and improper recovery from a bounced landing. A factor was the crosswind condition.Jun 29, 2000 · N3177H · Substantial damageNTSB MIA00LA192Accident · No injuriesLimited investigationFinal reportEuropa Europa XS TRI-GEAR · Lakeland, FLthe flight instructor's inadequate supervision that resulted in the dual student performing an improper landing flare/touchdown which resulted in a hard landing and overload to the nose landing gear assembly.Jun 28, 2000 · N912EA · Substantial damageNTSB LAX00LA242Accident · 1 fatalLimited investigationFinal reportWorldwide Aero AEROS-40B · San Bernadino, CAThe ground crew's diverted attention toward the landing airship while trying to catch a mooring rope, which resulted in their failure to detect an immenient collision with each other.Jun 28, 2000 · N819AC · No damageNTSB ATL00LA068Accident · No injuriesLimited investigationFinal reportDouble D Enterprises Rans S-12 · Baneberry, TNThe pilot's inadequate compensation for wind conditions. Factors were the trees, and gusting winds.Jun 26, 2000 · N6279D · Substantial damageNTSB ANC00LA080Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Nikiski, AKA bear running onto the landing area during the landing flare. A factor associated with the accident was the high vegetation on the edge of the airstrip.Jun 26, 2000 · N7437 · Substantial damageNTSB SEA00LA114Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Ephrata, WAThe pilot-in-command's failure to maintain directional control during landing roll.Jun 25, 2000 · N6775B · Substantial damageNTSB NYC00LA175Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Robbinsville, NJThe pilot's inadequate compensation for wind conditions, which resulted in a loss of aircraft control. A factor was a crosswind.Jun 25, 2000 · N36355 · Substantial damageNTSB LAX00LA243Accident · No injuriesLimited investigationFinal reportCessna A185F · Marana, AZthe pilot's excessive use of wheel brakes during the landing roll resulting in the airplane's nosing over.Jun 25, 2000 · N185DE · Substantial damageNTSB FTW00LA185Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Mckinney, TXThe flight instructor's inadequate supervision of the landing resulting in the loss of directional control by the student pilot.Jun 24, 2000 · N8427K · Substantial damage