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 ATL04LA070Accident · No injuriesLimited investigationFinal reportEurocopter France EC120B · Jonesboro, GAThe instructor's inadequate supervision, and the dual-student's improper flare which resulted in a hard landing.Jan 24, 2004 · N125MG · Substantial damageNTSB LAX04LA106Accident · 1 fatalLimited investigationFinal reportCox Thorpe T-18 · Compton, CAboth pilots' failure to see and avoid one another that resulted in the airplane's encounter with downwash induced wake vortices from the helicopter, and the airplane pilot's subsequent loss of control.Jan 23, 2004 · N64EC · Substantial damageNTSB LAX04CA105Accident · No injuriesData collectionFinal reportBeech B36TC · San Diego, CAthe pilot's misjudged speed and altitude, which led to a failure to attain the proper touchdown point and a subsequent runway overrun. Also causal was the pilot's delayed decision to perform a go-around.Jan 23, 2004 · N321JT · Substantial damageNTSB NYC04LA061Accident · No injuriesLimited investigationFinal reportCirrus Design SR-22 · College Park, MDThe loss of hydraulic fluid due to chaffing of a brake line by a strut fairing rivet, resulting in the failure of the braking system.Jan 22, 2004 · N344CD · Substantial damageNTSB DEN04FA041Accident · No injuriesField investigationFinal reportDassault DA-20 Falcon Jet · Pueblo, COthe pilot's improper in-flight planning/decision to land on the contaminated runway, the stuck thrust reverser solenoid resulting in partial deployment of the right engine thrust reverser, and the pilot's inability to maintain directional control of the…Jan 21, 2004 · N200JE · Substantial damageNTSB LAX04CA097Accident · No injuriesData collectionFinal reportEurocopter AS350 B3 · Mesa, AZthe pilot's excessive flare and mistimed collective application during a practice autorotation, which resulted in a loss of main rotor rpm and a subsequent hard landing. Also causal, was the flight instructor's delayed remedial action and inadequate…Jan 20, 2004 · N970AE · Substantial damageNTSB SEA04IA035Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8 · Seattle, WAThe flight crew's misidentification of the parallel taxiway as the active runway, resulting in the flight crew executing a landing on the taxiway. Factors include sun glare and shadows around the runway/taxiway environment, and visual illusions created by the…Jan 19, 2004 · C-GTAQ · No damageNTSB DEN04LA039Accident · No injuriesLimited investigationFinal reportCessna 182Q · St. George, UTthe pilot's improper flare which resulted in a hard landing.Jan 18, 2004 · N5202N · Substantial damageNTSB CHI04LA059Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Marine City, MIThe pilot's failure to maintain directional control of the airplane during landing. Factors associated with the accident were the icy snow covered runway, the tailwind conditions, the snowbank, and the ditch which the airplane contacted.Jan 18, 2004 · N46WD · Substantial damageNTSB CHI04IA056Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Rapid City, SDThe copilot's failure to maintain control of the airplane during the landing and the captain's delay in initiating remedial action. Factors contributing to the accident were the low ceiling and low visibility due to fog, and the aircraft's deviation from…Jan 18, 2004 · N595SW · Minor damageNTSB CHI04LA058Accident · No injuriesLimited investigationFinal reportCessna 310R · Port Huron, MIThe loss of directional control as a result of reduced braking performance due to a snow-covered runway. Also causal was the pilot's decision to land with a quartering tailwind. The snowbank was a contributing factor.Jan 17, 2004 · N6102X · Substantial damageNTSB ATL04FA069Accident · 1 fatalField investigationFinal reportCessna 182A · Traphill, NCThe loss of engine power due to carburetor ice. Contributing factors were conditions conducive for carburetor icing.Jan 17, 2004 · N4744D · DestroyedNTSB FTW04CA061Accident · No injuriesData collectionFinal reportPiper PA-32R · Poynor, TXThe pilot's failure to maintain aircraft control while on final approach. A factor was the downdraft.Jan 15, 2004 · N4136S · Substantial damageNTSB SEA04LA034Accident · No injuriesLimited investigationFinal reportCessna 185F · Deer Park, WAThe dual student pilot's failure to maintain directional control during the landing roll and the failure of the flight instructor to provide remedial action. A factor was snowbank.Jan 14, 2004 · N185WB · Substantial damageNTSB LAX04LA094Accident · No injuriesLimited investigationFinal reportCessna 305A · Casa Grande, AZThe failure of a tail wheel steering component (spring), which resulted in a loss of directional control and a ground loop during the landing roll. A contributing factor was the soft terrain adjacent to the runway.Jan 14, 2004 · N305BD · Substantial damageNTSB DEN04LA037Accident · No injuriesLimited investigationFinal reportAerotek Pitts Special S-1S · Crawford, COthe pilot's failure to maintain directional control and his failure to maintain clearance from the snow bank during the landing. A factor contributing to the accident was the snow bank.Jan 11, 2004 · N362JW · Substantial damageNTSB CHI04LA054Accident · No injuriesLimited investigationFinal reportCessna 150E · Princeton, MOThe encounter with the unknown snow drifts during landing. The factors were the snow drifts, night, and the airport's failure to issue a NOTAM on the runway conditions.Jan 11, 2004 · N3088J · Substantial damageNTSB LAX04CA091Accident · No injuriesData collectionFinal reportFleet 2 · Fresno, CAthe pilot's failure to set the throttle friction lock, which resulted in the inadvertent application of the throttle, followed by a loss of directional control.Jan 10, 2004 · N606M · Substantial damageNTSB DEN04LA042Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Glade Park, COthe pilot's inadequate in-flight planning/decision. Contributing factors include the pilot's selection of unsuitable terrain for landing and the snow covered terrain.Jan 8, 2004 · N57534 · Substantial damageNTSB MIA04CA041Accident · No injuriesData collectionFinal reportMaule M-7-235B · Fort Lauderdale, FLThe pilot's failure to maintain aircraft control. A factor in this accident was the improper use of full flaps.Jan 3, 2004 · N10430 · Substantial damageNTSB LAX04CA085Accident · No injuriesData collectionFinal reportCessna 172N · Hayfork, CAthe pilot's inadequate in-flight decision to attempt a landing on a snow covered runway without ascertaining the depth of the snow cover.Jan 3, 2004 · N390BV · Substantial damageNTSB FTW04LA056Accident · No injuriesLimited investigationFinal reportPitts S-1S · Burleson, TXThe separation of the right main gear wheel, during landing, due to the improper maintenance by unknown maintenance personnel on the right main landing gear assembly.Jan 3, 2004 · N9AQ · Substantial damageNTSB SEA04CA037Accident · No injuriesData collectionFinal reportBellanca 8KCAB · Bend, ORDirectional control not maintained during landing. Factors include an icy runway and a snow bank.Dec 30, 2003 · N727MR · Substantial damageNTSB CHI04LA049Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Wellington, KSThe pilot not maintaining directional control during the landing roll. Factors were the dry grass and the concrete box he encountered during his excursion off the runway.Dec 29, 2003 · N14763 · DestroyedNTSB DEN04LA034Accident · No injuriesLimited investigationFinal reportCessna 182 · Hudson, COthe pilot's failure to maintain directional control due to an excessive crosswind component, resulting in an uncontrolled groundloop/swerve. Contributing factors were the crosswind gust and the soft, sandy terrain.Dec 28, 2003 · N5609B · Substantial damageNTSB NYC04LA051Accident · Serious injuriesLimited investigationFinal reportSchweizer 269C-1 · Byron, NYThe pilot's improper use of the collective, and failure to maintain main rotor rpm, which resulted in low main rotor rpm and a hard landing.Dec 27, 2003 · N358SS · Substantial damageNTSB NYC04CA053Accident · No injuriesData collectionFinal reportCessna 172R · Bluffton, OHThe pilot's improper flare and inadequate recovery from a bounced landing.Dec 27, 2003 · N363SA · Substantial damageNTSB LAX04LA079Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Oxnard, CAthe failure of the pin that secured the right rudder pedal to the brake cylinder arm due to improper installation of the pin. Also causal was the manufacturer's confusing maintenance instructions regarding the installation of the right rudder pedal pin and…Dec 27, 2003 · N53879 · Substantial damageNTSB ATL04LA059Accident · No injuriesLimited investigationFinal reportSocata TB21 · Spruce Pine, NCThe pilot's inadequate flare, and his failure to maintain directional control. The pilot's improper recovery from a bounced landing, and trees are a contributing factor.Dec 27, 2003 · N1879S · Substantial damageNTSB CHI04LA051Accident · No injuriesLimited investigationFinal reportCessna 177RG · Waterloo, IAThe impact with a deer during landing roll. A contributing factor was the night lighting conditions.Dec 26, 2003 · N7575V · Substantial damageNTSB ATL04LA062Accident · No injuriesLimited investigationFinal reportCessna 172R · Atlanta, GAThe pilot's improper flare resulting in a hard landing. A factor is lack of total experience.Dec 26, 2003 · N26486 · Substantial damageNTSB ATL04IA067Incident · No injuriesIncident investigationFinal reportSabreliner NA-265-60 · Birminghham, ALThe lack of lubrication of the right main wheel bearing which resulted in the overheating.Dec 26, 2003 · N124DC · No damageNTSB MIA04LA038Accident · No injuriesLimited investigationFinal reportCessna 172RG · Key West, FLPilot's improper emergency landing gear extension procedure which resulted in the right main landing gear not locking in the down position subsequent right main landing gear collapsing on landing.Dec 25, 2003 · N4721R · Substantial damageNTSB CHI04LA047Accident · Minor injuriesLimited investigationFinal reportSikorsky S-58JT · Ypsilanti, MIThe pilot became disoriented and attempted to land the helicopter at the wrong ramp resulting in his failure to maintain obstacle clearance during the approach. The light poles were a factor to the accident.Dec 22, 2003 · N598S · DestroyedNTSB MIA04LA036Accident · No injuriesLimited investigationFinal reportCessna 310P · Crystal River, FLInadequate maintenance by company maintenance personnel, which resulted in operation of the airplane with a deflated nose landing gear strut, which resulted in the nose gear failing to lock in position, gear collapse, and damage to the airplane during landing…Dec 21, 2003 · N5811M · Substantial damageNTSB IAD04CA006Accident · No injuriesData collectionFinal reportPiper PA-30 · Louisville, KYThe pilot's improper flare, which resulted a hard landing. A factor was the glare from the setting sun.Dec 21, 2003 · N7532Y · Substantial damageNTSB CHI04LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Mountain Grove, MOImproper use of the brakes during landing by the pilot, resulting in failure of the left main landing gear tire and a loss of directional control. Contributing factors were the failure of the main landing gear, as well as the grass and the ditch adjacent to…Dec 21, 2003 · N56598 · Substantial damageNTSB FTW04LA049Accident · Serious injuriesLimited investigationFinal reportCessna 195B · Amarillo, TXThe leakage of the left brake master cylinder cap, which resulted in the loss of hydraulic fluid and the failure of the left brake.Dec 20, 2003 · N6850D · Substantial damageNTSB MIA04FA035Accident · 2 fatalField investigationFinal reportCessna U206G · Thonotosassa, FLThe pilot's failure to retract the landing gear prior to landing on the water, resulting in a loss of control, and the airplane nosing over.Dec 18, 2003 · N603DK · Substantial damageNTSB LAX04CA070Accident · No injuriesData collectionFinal reportLuscombe 8E · San Jose, CAthe pilot's failure to maintain directional control of the airplane during the landing roll.Dec 18, 2003 · N1338B · Substantial damageNTSB DCA04MA011Accident · Minor injuriesClass 1 · MajorFinal reportMcDonnell Douglas MD-10-10F · Memphis, TN1) the first officer's failure to properly apply crosswind landing techniques to align the airplane with the runway centerline and to properly arrest the airplane's descent rate (flare) before the airplane touched down; and 2) the captain's failure to…Dec 18, 2003 · N364FE · DestroyedNTSB SEA04LA028Accident · No injuriesLimited investigationFinal reportAviat A-1B · Hailey, IDThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent group loop and the collapse of the right main landing gear.Dec 17, 2003 · N290AM · Substantial damageNTSB MIA04CA034Accident · No injuriesData collectionFinal reportWaco 4MF 5 · Marathon, FLThe pilot's loss of directional control during landing rollout in a crosswind resulting in the airplane ground looping and incurring damage to the left wing.Dec 17, 2003 · N64JE · Substantial damageNTSB LAX04LA071Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Gilbert, AZthe pilot's failure to maintain control of the airplane during the landing touchdown in soft terrain. A contributing factor was the pilot's selection of unsuitable terrain for landing.Dec 17, 2003 · N5516H · Substantial damageNTSB LAX04CA072Accident · No injuriesData collectionFinal reportPiper PA-18 · Prescott, AZthe failure of the pilot to maintain directional control of the tail wheel equipped airplane during landing, which resulted in a ground loop.Dec 16, 2003 · N4380T · Substantial damageNTSB CHI04LA042Accident · No injuriesLimited investigationFinal reportBeech 99 · Mosinee, WIThe pilot's failure to maintain the proper descent rate and his inadequate flare.Dec 16, 2003 · N399CZ · Substantial damageNTSB ATL04LA068Accident · No injuriesLimited investigationFinal reportCessna 182L · Knoxville, TNThe pilot's improper flare and his inadequate compensation for wind conditions. Wind gust was a factorDec 16, 2003 · N3191R · Substantial damageNTSB ATL04IA054Incident · No injuriesIncident investigationFinal reportNew Piper PA-46-350P · St. ThomasThe pilot's inadequate inflight planning and failure to extend the landing gear, which resulted in a wheels-up landing.Dec 15, 2003 · N5345S · Minor damageNTSB NYC04LA048Accident · No injuriesLimited investigationFinal reportBeech 35 · Laconia, NHThe pilot's failure to maintain directional control after experiencing a brake failure. A factor related to the accident was the failure of the brake master cylinder.Dec 13, 2003 · N3116V · Substantial damageNTSB DEN04LA029Accident · No injuriesLimited investigationFinal reportMaule M-4-210 · Elbert, COthe pilot's failure to maintain directional control of the airplane. A contributing factor was his inexperience in aircraft type.Dec 13, 2003 · N4621T · Substantial damage