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 FTW03LA010Accident · No injuriesLimited investigationFinal reportBeech K35 · Flippin, ARThe pilot's selection of an unsuitable landing area. A contributing factor was the pilot's disorientation.Oct 14, 2002 · N9508R · Substantial damageNTSB DEN03LA007Accident · No injuriesLimited investigationFinal reportMooney M20J · Englewood, COthe complete collapse of the landing gear, during landing roll, for undetermined reasons.Oct 14, 2002 · N8084D · Substantial damageNTSB SEA03LA004Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Helena, MTThe student pilot's failure to maintain clearance from a tower during an aborted landing. Factors include landing with a tailwind and a tower.Oct 13, 2002 · N8752 · Substantial damageNTSB LAX03LA006Accident · No injuriesLimited investigationFinal reportCessna 310L · North Las Vegas, NVThe pilot's failure to use the landing checklist due to his diverted attention, which resulted in a wheels-up landing.Oct 13, 2002 · N2209F · Substantial damageNTSB SEA03LA003Accident · No injuriesLimited investigationFinal reportMooney M20K · Rexburg, IDThe pilot's failure to perform a go-around once it became evident that his remedial action was not adequate to overcome the porpoise/pilot-induced oscillation that occurred during the landing flare. Factors include the pilot's inadvertent repeated…Oct 12, 2002 · N231EH · Substantial damageNTSB NYC03LA006Accident · No injuriesLimited investigationFinal reportBeech 58 · Allentown, PAThe pilot's inadvertent retraction of the landing gear on the ground.Oct 12, 2002 · N8199R · Substantial damageNTSB ANC03LA002Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Wasilla, AKThe instructor's inadequate supervision of the pilot-rated dual student, and the dual student's excessive use of brakes during the landing roll, which resulted in the nose over of the airplane.Oct 11, 2002 · N7027D · Substantial damageNTSB MIA03LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Cullman, ALthe pilot-in-command's (CFI) delayed remedial action, and improper recovery from a bounced landing, resulting in a hard landing, and impact with a parked airplane.Oct 9, 2002 · N22DB · Substantial damageNTSB DEN03LA005Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Watkins, COthe pilot's inability [not possible] to control the airplane during landing roll due to the failure of the left brake, and the subsequent inadvertent ground loop.Oct 9, 2002 · N7672K · Substantial damageNTSB NYC03FA002Accident · Serious injuriesField investigationFinal reportCessna 525A · Dexter, MEwas the pilot's improper decision to land with excessive speed, and his delayed decision to perform an aborted landing, both of which resulted in a runway overrun. A factor was the tail wind.Oct 7, 2002 · N57EJ · Substantial damageNTSB FTW03LA007Accident · No injuriesLimited investigationFinal reportMooney M20K · Port Sulphur, LAthe pilot's failure to maintain directional control while landing, which resulted in an in-flight collision with trees during an attempted go-around. A factor was the wet runway condition.Oct 6, 2002 · N231QL · Substantial damageNTSB SEA03LA001Accident · No injuriesLimited investigationFinal reportCurtiss-Wright Travel Air 4000 · Tillamook, ORThe fracture of the weld joining the left main wheel strut to the left/right main wheel axel resulting in separation of the strut from the axle during an unknown phase of operation which ultimately lead to the left gear collapse and subsequent nose-over on…Oct 5, 2002 · N4949 · Substantial damageNTSB CHI03CA004Accident · No injuriesData collectionFinal reportCessna 182E · Oslo, MNFailure of the pilot-in-command to maintain directional control during the landing roll. Contributing factors were the wind gust and the soft terrain adjacent to the runway.Oct 5, 2002 · N3345Y · Substantial damageNTSB DEN03LA001Accident · Serious injuriesLimited investigationFinal reportLet Blanik L-13 · Morgan, UTthe pilot's inadequate inflight planning and decision which resulted in an unsuitable off-field landing site. A contributing factor was downdraft weather conditions.Oct 3, 2002 · N99805 · DestroyedNTSB FTW03LA002Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Norman, OKThe pilot's failure to maintain directional control. A factor was the inadequate flare.Oct 2, 2002 · N9623C · Substantial damageNTSB FTW03LA001Accident · Minor injuriesLimited investigationFinal reportMaule M-7-235C · San Antonio, TXThe pilot's failure to compensate for the existing winds conditions. A contributing factor was the prevailing tailwind.Oct 1, 2002 · N4269B · DestroyedNTSB CHI03LA001Accident · No injuriesLimited investigationFinal reportMooney M20J · Chicago, ILThe pilot's inadequate compensation for wind, and his failure to maintain directional control.Oct 1, 2002 · N22RJ · Substantial damageNTSB MIA02LA172Accident · No injuriesLimited investigationFinal reportRonald Levee Kitfox IV · De Land, FLThe failure of the pilot to maintain directional control of the airplane during the flare/touchdown resulting in substantial damage. A factor in the accident was the poor in-flight planning decision by the pilot for his continuing the approach in close…Sep 29, 2002 · N1441Z · Substantial damageNTSB FTW02LA268Accident · Minor injuriesLimited investigationFinal reportRobinson R44 · Del Rio, TXThe pilot's failure to maintain control of the helicopter. A contributing factor was the reported gusting wind conditions.Sep 29, 2002 · N952LC · Substantial damageNTSB SEA02LA186Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Spokane, WAThe flight instructor's delay of the remedial action necessary to correct for the student pilot's error during the landing flare. Factors include the student pilot's misjudgment of the aircraft's height above the runway when he initiated the flare.Sep 28, 2002 · N132ND · Substantial damageNTSB SEA02LA183Accident · Minor injuriesLimited investigationFinal reportPiper/Cub Crafters PA-18 · Gannett, IDThe pilot's excessive braking during the landing rollout.Sep 28, 2002 · N380CC · Substantial damageNTSB LAX02LA301Accident · No injuriesLimited investigationFinal reportCessna 182G · Paradise, CAthe pilot's improper flare resulting in a hard landing.Sep 28, 2002 · N2443R · Substantial damageNTSB FTW02LA269Accident · No injuriesLimited investigationFinal reportCessna 421B · Mineral Wells, TXThe pilot's failure to maintain a proper descent rate which resulted hard landing and a subsequent failure of the main landing gear.Sep 28, 2002 · N7926R · Substantial damageNTSB ATL02LA177Accident · No injuriesLimited investigationFinal reportSchempp-Hirth KA8B · Tullahoma, TNThe student pilot misjudged the airspeed and altitude during a visual approach to land that resulted in the in-flight collision with the trees.Sep 28, 2002 · N8747 · Substantial damageNTSB SEA02LA182Accident · No injuriesLimited investigationFinal reportCessna 172RG · Billings, MTThe failure of the landing gear actuator during landing as a result of fatigue.Sep 26, 2002 · N6525R · Substantial damageNTSB SEA02LA181Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Shaw Island, WAThe pilot's failure to adequately compensate for ambient wind conditions. Factors include the pilot's misjudgment of distance/altitude, gusting crosswinds, and trees growing near the edge of the airstrip.Sep 26, 2002 · N736PJ · Substantial damageNTSB NYC02LA194Accident · Minor injuriesLimited investigationFinal reportBellanca 7KCAB · Erwinna, PAThe pilot's failure to maintain directional control during an aborted landing. A factor was a crosswind.Sep 24, 2002 · N4210Y · Substantial damageNTSB CHI02LA293Accident · No injuriesLimited investigationFinal reportHughes 269A · Council Bluffs, IAThe premature fracture of the cyclic/mixture bracket resulting in the inability to conduct a landing flare.Sep 24, 2002 · N1040S · Substantial damageNTSB SEA02LA178Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Anacortes, WANormal braking application was excessive during the landing roll resulting in the aircraft nosing over.Sep 23, 2002 · N9641 · Substantial damageNTSB SEA02LA179Accident · No injuriesLimited investigationFinal reportCessna R172K · Salmon, IDFailure to maintain airspeed while on approach which resulted in an aerodynamic stall and hard landing.Sep 21, 2002 · N1071V · Substantial damageNTSB SEA02LA177Accident · No injuriesLimited investigationFinal reportCessna 182L · McCall, IDThe pilot's failure to maintain adequate airspeed and an acceptable rate of descent while on short final for landing, and his failure to maintain directional control after the resultant hard landing. Factors include a ditch near the temporary runway (taxiway)…Sep 21, 2002 · N42862 · DestroyedNTSB MIA02CA177Accident · No injuriesData collectionFinal reportAviat A-1 · Cherry Point, NCthe pilot misjudged the landing flare, resulting in a hard landing, an inadvertent ground loop, and the subsequent impact with the runway.Sep 21, 2002 · N6QR · Substantial damageNTSB IAD02LA096Accident · No injuriesLimited investigationFinal reportCessna 172N · Bumpass, VAThe pilot's failure to maintain directional control during the landing. A factor was the narrow runway width.Sep 21, 2002 · N737TG · Substantial damageNTSB CHI02LA291Accident · No injuriesLimited investigationFinal reportCessna 172S · Boyne Falls, MIThe pilot's improper flare during landing.Sep 21, 2002 · N784SA · Substantial damageNTSB CHI02CA287Accident · No injuriesData collectionFinal reportCessna 150G · Dodge Center, MNThe pilot's misjudgment of distance resulting in an undershoot of the runway.Sep 18, 2002 · N2870S · Substantial damageNTSB LAX02LA289Accident · No injuriesLimited investigationFinal reportCessna 152 · El Cajon, CAThe pilot's misjudged landing flare, which resulted in a hard landing.Sep 17, 2002 · N5100B · Substantial damageNTSB ANC02LA122Accident · No injuriesLimited investigationFinal reportCessna 206 · Circle, AKA partial separation of the nose wheel flange from the hub that resulted in a nose over during the landing roll.Sep 17, 2002 · N8515Q · Substantial damageNTSB NYC02LA191Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Frederick, MDThe student pilot's failure to maintain adequate rotor rpm, and the flight instructor's delayed remedial action. A factor was the manufacturer's inadequate written guidance regarding simulated engine failures during takeoff.Sep 16, 2002 · N2549R · Substantial damageNTSB LAX02LA286Accident · No injuriesLimited investigationFinal reportCessna 182A · San Diego, CAthe pilot's failure to maintain adequate clearance to avoid jet exhaust due to his improperly planned approach and inadequate in-flight decision to perform a long landing rollout, which placed the airplane in proximity to an area of observed high velocity jet…Sep 16, 2002 · N3951D · Substantial damageNTSB CHI02LA280Accident · No injuriesLimited investigationFinal reportCessna 172P · Sturtevant, WIThe proper touchdown point not attained and the approach speed not obtained/maintained by the pilot.Sep 16, 2002 · N54091 · Substantial damageNTSB SEA02LA176Accident · No injuriesLimited investigationFinal reportEells Air Command 503 · Prineville, ORThe student pilot's failure to maintain airspeed resulting in a hard landing.Sep 15, 2002 · N25069 · Substantial damageNTSB NYC02LA190Accident · No injuriesLimited investigationFinal reportCessna 421 · Ithaca, NYThe pilot's failure to maintain directional control during the landing roll. A factor in the accident was the wet runway.Sep 15, 2002 · N23RL · Substantial damageNTSB MIA02LA168Accident · No injuriesLimited investigationFinal reportCessna 310L · Atlanta, GAThe pilot's misjudgment of speed/altitude and her failure to perform a go-around.Sep 15, 2002 · N73NR · Substantial damageNTSB DEN02FA105Accident · No injuriesField investigationFinal reportPiper PA-24-260 · Rock Springs, WYthe flight crew of the Beech and the pilot of the Piper's failure to attain proper clearance from the other during their respective landings. Factors contributing to the accident were the crew's and the pilot of the other airplane's inadequate visual lookout…Sep 15, 2002 · N8822P · 2 aircraft · Substantial damageNTSB DEN02LA108Accident · No injuriesLimited investigationFinal reportStinson L-5E · Spanish Fork, UTthe pilot's inadequate use of rudder and failure to maintain direcctional control following a bounced landing. A contributing factor was the pilot's improper recovery from the bounced landing.Sep 14, 2002 · N8369H · Substantial damageNTSB LAX02LA284Accident · No injuriesLimited investigationFinal reportSiemens Rotorway Exec 162 F · Overgaard, AZThe pilot's failure to check the wind direction prior to practicing autorotations, and his misjudged flare maneuver. The tailwind was a factor.Sep 13, 2002 · N104BJ · Substantial damageNTSB NYC02LA187Accident · No injuriesLimited investigationFinal reportBoeing 757-251 · Baltimore, MDThe captain's failure to follow existing company procedures for stabilized approach, and use of speed brakes.Sep 10, 2002 · N534US · Substantial damageNTSB CHI02LA278Accident · Minor injuriesLimited investigationFinal reportFrank RV-8A · Brodhead, WIThe failure of the nose landing gear strut for undetermined reasons.Sep 10, 2002 · N54LF · Substantial damageNTSB SEA02LA188Accident · No injuriesLimited investigationFinal reportAviat A-1B · Arco, IDThe pilot's inadequate compensation for wind conditions, resulting in an inadvertent ground loop. Factors include wind gusts during the period of time at which the landing took place.Sep 8, 2002 · N290AM · Substantial damageNTSB NYC02LA189Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Titusville, PAThe student pilot's failure to maintain directional control during the landing roll.Sep 8, 2002 · N6947W · Substantial damage