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 NYC01LA200Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · West Milford, NJThe student pilot's failure to maintain directional control while landing. Factor’s in this accident were a wind gust and the rocks located off the left side of the runway.Jul 27, 2001 · N4915L · Substantial damageNTSB CHI01LA254Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Wall, SDThe student pilot failed to maintain a proper glidepath, failed to obtain proper climb rate, and executed the go-around improperly. Additional factors included the pilot's lack of experience, the crop, and the soft, wet ground.Jul 27, 2001 · N39971 · Substantial damageNTSB SEA01LA159Accident · No injuriesLimited investigationFinal reportCessna TU-206F · Minden, NVThe pilot's inadequate recovery from a bounced landing, and his improper remedial action after it became clear that he was not successfully salvaging the landing attempt. Factors include an improperly serviced nose gear strut.Jul 26, 2001 · N2856Q · Substantial damageNTSB CHI01LA261Accident · No injuriesLimited investigationFinal reportMcIntosh Steen Skybolt · Lebanon, INThe pilot misjudged his altitude during the landing. A factor was the soybean crop which the airplane contacted.Jul 26, 2001 · N2261N · Substantial damageNTSB LAX01LA260Accident · No injuriesLimited investigationFinal reportCessna 140 · San Luis Obispo, CAThe pilot's failure to maintain directional control during landing that resulted in dragging the wing and nosing over.Jul 25, 2001 · N2903N · Substantial damageNTSB LAX01LA259Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Placerville, CAInadequate airspeed during climb out following an aborted landing that was precipitated by the pilot's misjudged speed/distance on final approach. Also, contributing to the accident was the pilot's inexperience in the type of operation, his failure to…Jul 25, 2001 · N8962V · Substantial damageNTSB IAD01LA085Accident · No injuriesLimited investigationFinal reportCessna 195 · Moultonboro, NHThe pilot's failure to maintain directional control of the airplane. A factor was the crosswind.Jul 24, 2001 · N4352V · Substantial damageNTSB NYC01LA186Accident · No injuriesLimited investigationFinal reportMooney M20J · Mitchellville, MDThe flight instructor's failure to maintain control of the airplane during an aborted landing, and her delay in remedial action. A factor related to the accident was the excessive trim setting.Jul 23, 2001 · N4223H · Substantial damageNTSB NYC01LA185Accident · No injuriesLimited investigationFinal reportCessna 172 · Dayton, OHThe pilot excessive flare, which resulted in a hard landing.Jul 23, 2001 · N52012 · Substantial damageNTSB LAX01LA258Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Tulelake, CAThe right main tire blew out resulting in a loss of directional control and a ground loop.Jul 22, 2001 · N7696L · Substantial damageNTSB LAX01LA257Accident · No injuriesLimited investigationFinal reportCessna 185F · Visalia, CAThe pilot failed to maintain clearance from crops which bordered the narrow runway.Jul 22, 2001 · N1728R · Substantial damageNTSB CHI01LA226Accident · No injuriesLimited investigationFinal reportCessna 182T · Fowlerville, MIThe student pilot's failure to maintain aircraft control during landing. Factors relating to this accident were the misjudged flare, the exceeded proper touchdown point, the delayed go-around, the student pilot's improper in-flight decisions, and the pond.Jul 22, 2001 · N3559E · Substantial damageNTSB SEA01LA142Accident · No injuriesLimited investigationFinal reportCessna 150 · Blackfoot, IDPilot's failure to maintain directional control of the airplane while landing.Jul 21, 2001 · N10RH · Substantial damageNTSB SEA01LA140Accident · No injuriesLimited investigationFinal reportBoeing E75N1 · Spokane, WAThe pilot landed with insufficient formation spacing behind the lead aircraft, resulting in an encounter with the lead aircraft's wake turbulence, and subsequently lost directional control during landing roll.Jul 21, 2001 · N65900 · Substantial damageNTSB SEA01LA139Accident · No injuriesLimited investigationFinal reportPilatus PC-6/B2-H4 · Great Falls, MTPilot's failure to maintain directional control of the aircraft while landing.Jul 21, 2001 · N2TS · Substantial damageNTSB NYC01LA182Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Mattituck, NYThe pilot's failure to attain a proper touchdown point. A factor was the tailwind.Jul 21, 2001 · N17AV · Substantial damageNTSB LAX01LA255Accident · No injuriesLimited investigationFinal reportHughes 269C · Tracy, CAThe pilot's misjudgement of the landing flare during an autorotation demonstration. Factors were shifting winds and an excessive descent rate.Jul 21, 2001 · N5015V · Substantial damageNTSB FTW01LA170Accident · No injuriesLimited investigationFinal reportCessna T210N · Amarillo, TXthe pilot's failure to verify that the landing gear was extended and locked before landing. A contributing factor was a tripped landing gear motor circuit breaker, which resulted in the failure of the main landing gear to fully extend and lock.Jul 21, 2001 · N6114A · Substantial damageNTSB ATL01LA089Accident · No injuriesLimited investigationFinal reportCessna 172R · Ormond Beach, FLThe student pilots improper flare, and improper recovery from a bounced landing. A factor was the student pilot's lack of total experience.Jul 21, 2001 · N448ER · Substantial damageNTSB NYC01LA181Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Latrobe, PAThe pilot's failure to maintain control of the airplane which resulted in the inadvertent ground loop.Jul 20, 2001 · N8212K · Substantial damageNTSB NYC01LA180Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Garrettsville, OHThe airstrip owner/pilot's failure to use all of the available runway. Factors were a tailwind condition and a contaminated runway.Jul 20, 2001 · N113JV · Substantial damageNTSB ANC01LA089Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Anchorage, AKAn inadvertent ground loop during the landing roll.Jul 20, 2001 · N5280H · Substantial damageNTSB SEA01LA137Accident · No injuriesLimited investigationFinal reportPiper PA-20-135 · Redmond, ORThe pilot's inadequate compensation for wind conditions during landing. A factor was variable winds.Jul 19, 2001 · N8901C · Substantial damageNTSB SEA01LA136Accident · No injuriesLimited investigationFinal reportCessna 180K · Quincy, WAThe pilot's failure to maintain directional control during the landing roll. Factors include an encounter with a dust devil/whirlwind.Jul 19, 2001 · N64426 · Substantial damageNTSB NYC01LA179Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas 369E · Niagara Falls, NYThe right skid getting snagged on the helicopter-dolly resulting in dynamic rollover.Jul 19, 2001 · N577DB · Substantial damageNTSB IAD01LA082Accident · No injuriesLimited investigationFinal reportCessna 152 · Millville, NJThe student pilot's failure to compensate for wind conditions and his failure to maintain directional control during landing. A factor was the crosswind.Jul 19, 2001 · N4662Q · Substantial damageNTSB DEN01LA124Accident · No injuriesLimited investigationFinal reportBeech 95-B55 (T42A) · Englewood, COthe pilot receiving instruction inadvertently retracting the landing gear during the landing roll. A contributing factor was the flight instructor's inadequate supervision of the pilot receiving instruction.Jul 17, 2001 · N886N · DestroyedNTSB CHI01FA209Accident · Minor injuriesField investigationFinal reportBeech B19 · Eden Prairie, MNThe student pilot's failure to maintain aircraft control during the landing, her failure to recover from the bounced landing, and the nose gear overload.Jul 17, 2001 · N3214L · Substantial damageNTSB LAX01LA249Accident · No injuriesLimited investigationFinal reportBurkhart Grob G 103 Twin II · Minden, NVThe student pilot's early deployment of full spoilers, resulting in an excessive sink rate and subsequent hard landing. A factor was the instructor's lack of time to take remedial action.Jul 16, 2001 · N4805R · Substantial damageNTSB FTW01LA165Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Bridgeport, TXthe non-certificated pilot's improper flare which resulted in a hard landing.Jul 16, 2001 · N8454W · Substantial damageNTSB DEN01LA122Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20C-1 · Provo, UTthe inadvertent stall by the pilot during an aborted landing. Contributing factors were an excessive flare, premature retraction of the flaps, and gusty wind conditions.Jul 16, 2001 · N981CT · Substantial damageNTSB ANC01LA085Accident · No injuriesLimited investigationFinal reportCessna 172K · Wasilla, AKThe pilot's delay in aborting the takeoff roll.Jul 15, 2001 · N78254 · Substantial damageNTSB SEA01LA132Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Friday Harbor, WAThe pilot's failure to maintain directional control during landing.Jul 14, 2001 · N8158D · Substantial damageNTSB CHI01LA210Accident · No injuriesLimited investigationFinal reportCessna 140 · Spearfish, SDThe pilot failed to maintain directional control of the airplane during the landing. Factors associated with the accident were the pilot's inadequate recovery from a bounced landing and his lack of experience in the make and model of the accident airplane.Jul 14, 2001 · N2005V · Substantial damageNTSB NYC01LA170Accident · No injuriesLimited investigationFinal reportTaylorcraft F21B · Simsbury, CT**This report was modified on 2/24/2016. Refer to the public docket for this accident for additional details.** a loose tail wheel assembly and the failure of maintenance personnel to adequately follow annual inspection procedures. A factor in the accident…Jul 12, 2001 · N4418U · Substantial damageNTSB CHI01LA207Accident · No injuriesLimited investigationFinal reportBurkhart Grob G 103 Twin II · Ionia, MIThe pilot not maintaining clearance from the tall grass during his recovery from the bounced landing. A factor was the tall grass.Jul 12, 2001 · N140BG · Substantial damageNTSB CHI01LA205Accident · No injuriesLimited investigationFinal reportCessna 172S · Lake in the Hil, ILThe student pilot misjudging the flare during that landing. Factors were the wrong runway selected by the student pilot, the tailwinds encountered during that landing and the flight instructor's inadequate supervision during that landing.Jul 11, 2001 · N795SP · Substantial damageNTSB CHI01LA208Accident · No injuriesLimited investigationFinal reportCessna 210 · Saint Charles, MOthe inadequate flare by the pilot.Jul 10, 2001 · N9657T · Substantial damageNTSB ATL01LA104Accident · No injuriesLimited investigationFinal reportPiper PA-46-500TP · Pahokee, FLThe pilot's failure to follow the checklist while making an approach for landing resulting in a wheels up landing. Contributing to the accident was the certified flight instructor inadequate supervision of the rated pilot receiving instruction.Jul 9, 2001 · N747DN · Substantial damageNTSB ATL01LA078Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-3 · Titusville, FLThe pilot's failure to maintain directional control during a bounced landing, resulting in a ground loop and subesequent collision with the runway.Jul 9, 2001 · N3239T · Substantial damageNTSB SEA01LA129Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Fragaria, WAThe pilot's failure to maintain adequate directional control. Contributing factors were the embankment and the deer.Jul 7, 2001 · N7994P · Substantial damageNTSB SEA01LA128Accident · No injuriesLimited investigationFinal reportTibert Baby Lakes · Stevensville, MTThe pilot's failure to maintain directional control of the tailwheel-equipped aircraft during the landing roll. Factors include the pilot's low total time in this make and model aircraft and his lack of recent experience in this make and model aircraft.Jul 7, 2001 · N94AT · Substantial damageNTSB LAX01LA238Accident · No injuriesLimited investigationFinal reportSparks KR-2 · San Diego, CAFailure of the pilot to maintain directional control during landing.Jul 7, 2001 · N122MS · Substantial damageNTSB ATL01LA076Accident · No injuriesLimited investigationFinal reportCessna 172P · Cedar Key, FLThe pilot's improper in-flight decision to abort the landing resulted in the collision with water. A factor was the variable wind condition.Jul 7, 2001 · N52452 · Substantial damageNTSB ANC01LA088Accident · No injuriesLimited investigationFinal reportCessna 185 · Cantwell, AKThe student pilot's failure to abort a landing resulting in an overrun. Factors in the accident were the pilot's diverted attention, and gusty wind conditions.Jul 7, 2001 · N2248T · Substantial damageNTSB SEA01LA126Accident · No injuriesLimited investigationFinal reportMaule M-5-210C · Big Creek, IDThe pilot's failure to adequately compensate for the wind conditions during the landing roll. High and gusting winds were factors.Jul 6, 2001 · N349X · Substantial damageNTSB DEN01LA121Accident · No injuriesLimited investigationFinal reportGriffith-Boyd Lancair 360 · La Junta, COa wheels-up landing due to an uncommanded gear retraction resulting from a short circuit of the landing gear electrical wiring.Jul 6, 2001 · N15EG · Substantial damageNTSB ATL01LA084Accident · No injuriesLimited investigationFinal reportFleet BI-PLANE · Homestead, FLThe pilot's improper use of flight controls during a landing on a sod airstrip that resulted in a nose over.Jul 6, 2001 · NC8627 · Substantial damageNTSB CHI01LA308Accident · No injuriesLimited investigationFinal reportCessna 182K · Mattoon, ILThe pilot improperly flared the airplane which resulted in a hard landing.Jul 5, 2001 · N2501Q · Substantial damageNTSB LAX01LA235Accident · No injuriesLimited investigationFinal reportCessna 175 · Monterey, CAThe pilot's improper recovery from a bounced landing.Jul 4, 2001 · N9287B · Substantial damage