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 ANC05CA122Accident · No injuriesData collectionFinal reportPiper PA-12 · Arctic Village, AKThe pilot's inadequate evaluation of the weather conditions, which resulted in an overrun and subsequent nose over during the landing roll. A factor contributing to the accident was a tailwind.Aug 9, 2005 · N78481 · Substantial damageNTSB LAX05FA262Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Big Bear City, CAThe pilot's failure to maintain aircraft control and adequate airspeed while executing an evasive maneuver during an aborted landing, which resulted in a cross-controlled accelerated stall and impact with terrain. Contributing to the accident was the probable…Aug 8, 2005 · N8540W · DestroyedNTSB LAX05CA263Accident · No injuriesData collectionFinal reportHughes 369D · North Las Vegas, NVthe pilot's improper use of the cyclic flight control and the flight instructor's inadequate supervision of the flight.Aug 8, 2005 · N58431 · Substantial damageNTSB ANC05CA119Accident · Minor injuriesData collectionFinal reportCessna 182 · Nabesna, AKThe pilot's selection of an unsuitable area for landing, which resulted in an on ground encounter with brush, and subsequent loss of control during an aborted landing. Factors associated with the accident were high vegetation, and a jammed elevator control.Aug 8, 2005 · N6480A · Substantial damageNTSB SEA05CA166Accident · No injuriesData collectionFinal reportLuscombe 8A · Otis Orchards, WAThe pilot's loss of directional control as a result of excessive braking while landing, which resulted in the nose over.Aug 7, 2005 · N2094K · Substantial damageNTSB DEN05CA122Accident · No injuriesData collectionFinal reportStinson L-5G · Gallup, NMan on-ground loss of control due to the flight controls becoming jammed because the pilot failed to properly secure his flight bag.Aug 7, 2005 · N2584B · Substantial damageNTSB CHI05CA215Accident · No injuriesData collectionFinal reportRosner Acro Sport II · Princeton, MNThe airplane nosed over during landing as a result of the pilot's failure to maintain control of the airplane when he applied excessive braking.Aug 7, 2005 · N89CJ · Substantial damageNTSB MIA05LA145Accident · Serious injuriesLimited investigationFinal reportFox Alfred C. Kitfox IV 1200 · Immokalee, FLThe pilot's failure to detect standing water on the grass strip resulting in a nose over during the landing roll.Aug 6, 2005 · N86FX · Substantial damageNTSB IAD05CA120Accident · No injuriesData collectionFinal reportCessna 172S · White Plains, NYThe pilot's improper recovery from a bounced landing.Aug 6, 2005 · N297ME · Substantial damageNTSB DEN05CA120Accident · No injuriesData collectionFinal reportCessna 172RG · Fort Collins, COthe pilot's failure to maintain directional control. Contributing factors were the crosswind, the pilot's failure to compensate for the wind conditions --- allowing the airplane to touch down without being properly aligned with the runway --- and the flight…Aug 6, 2005 · N5136R · Substantial damageNTSB CHI05CA232Accident · No injuriesData collectionFinal reportLet Blanik L-13 · Blair, NEThe low airspeed by the pilot and the inadequate supervision by the certified flight instructor.Aug 6, 2005 · N9295Z · Substantial damageNTSB ATL05CA141Accident · Serious injuriesData collectionFinal reportTherrien Roger Vortex · Lawrenceburg, TNThe pilot's improper landing flair, which resulted in a hard landing.Aug 6, 2005 · N42923 · Substantial damageNTSB IAD05CA117Accident · Minor injuriesData collectionFinal reportCessna C-172G · Eustis, METhe pilot's failure to maintain clearance from a bush during the aborted landing.Aug 5, 2005 · N5924R · Substantial damageNTSB CHI05LA218Accident · Serious injuriesLimited investigationFinal reportEnstrom 480 · Goshen, INGround resonance experienced by the pilots.Aug 5, 2005 · N480FX · Substantial damageNTSB CHI05CA219Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Watertown, WIThe flightcrew's failure to maintain directional control during landing rollout.Aug 5, 2005 · N515KG · Substantial damageNTSB ANC05LA117Accident · No injuriesLimited investigationFinal reportAviat A-1 · Anchorage, AKThe flight instructor's inadequate supervision of the dual student, and his failure to maintain control of the airplane. A factor associated with the accident was the dual student's excessive application of the brakes.Aug 5, 2005 · N8XJ · Substantial damageNTSB LAX05CA260Accident · No injuriesData collectionFinal reportMaule M-4-220C · Tucson, AZthe pilot's failure to maintain directional control.Aug 4, 2005 · N2020U · Substantial damageNTSB SEA05CA157Accident · No injuriesData collectionFinal reportGrumman G-164B · Paul, IDThe failure of the pilot to maintain direction control during the landing roll, which resulted in a nose over. Contributing factors included the weeds and the wet, soft terrain..Aug 3, 2005 · N8386K · Substantial damageNTSB MIA05CA142Accident · No injuriesData collectionFinal reportCessna 172R · Daytona Beach, FLThe student pilot's improper flare and recovery from a bounced landing.Aug 2, 2005 · N864CP · Substantial damageNTSB LAX05LA254Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Tucson, AZThe pilot's inadvertent retraction of the landing gear during the landing rollout.Aug 2, 2005 · N5888J · Substantial damageNTSB LAX05CA256Accident · No injuriesData collectionFinal reportLuscombe 8A · Benson, AZthe non-certificated pilot's failure to maintain directional control during the landing roll.Aug 2, 2005 · N71780 · Substantial damageNTSB DFW05CA203Accident · No injuriesData collectionFinal reportCessna 172M · El Dorado, ARThe student pilot's improper landing flare resulting in a hard landing and his improper recovery procedures for a bounced landing.Aug 2, 2005 · N80735 · Substantial damageNTSB CHI05CA208Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Willard, MOThe airplane overran the runway and hit a utility pole due to the pilot's delayed decision making and his failure to execute a go-around. Contributing factors included the exessive airspeed during the final approach, the high density altitude, the…Aug 1, 2005 · N6846J · Substantial damageNTSB ANC05CA114Accident · No injuriesData collectionFinal reportCessna 170B · Fairbanks, AKThe pilot's inadequate compensation for the gusty wind conditions, which resulted is a loss of directional control during landing. A factor associated with the accident was the gusty wind condition.Aug 1, 2005 · N6946C · Substantial damageNTSB LAX05LA251Accident · No injuriesLimited investigationFinal reportCessna 210A · San Diego, CAThe pilot's failure to ensure that the landing gear was fully extended prior to landing. A contributing factor was the pilot's diverted attention.Jul 31, 2005 · N9468X · Substantial damageNTSB DFW05CA196Accident · No injuriesData collectionFinal reportCessna 120 · New Roads, LAThe pilot's failure to maintain control during the landing roll.Jul 31, 2005 · N1703N · Substantial damageNTSB SEA05CA156Accident · No injuriesData collectionFinal reportPiper PA-20-115 · Weiser, IDThe pilot's failure to maintain directional control during the landing roll, and his application of excessive braking as the aircraft started to depart the side of the runway.Jul 30, 2005 · N7004K · Substantial damageNTSB LAX05LA247Accident · Minor injuriesLimited investigationFinal reportBeech B23 · Fallbrook, CAThe pilot's failure to maintain directional control during the landing rollout.Jul 29, 2005 · N6121N · Substantial damageNTSB SEA05CA154Accident · Minor injuriesData collectionFinal reportGrumman American AA1B · Camas, WAThe student pilot's failure to maintain aircraft control during landing roll. A contributing factor was the gusty cross-wind weather condition.Jul 28, 2005 · N9861L · Substantial damageNTSB IAD05CA106Accident · No injuriesData collectionFinal reportGrumman American AA-5B · Stow, MAAn inadvertent collision with a deer during the landing roll. A factor was the night lighting conditions.Jul 28, 2005 · N28860 · Substantial damageNTSB CHI05CA255Accident · No injuriesData collectionFinal reportLet L 33 Solo · Stanton, MNThe pilot's failure to maintain a proper descent rate during landing due to the wind gusts. The wind gusts were a factor.Jul 28, 2005 · N93205 · Substantial damageNTSB ANC05TA111Accident · No injuriesFinal reportMcDonnell Douglas 500D · Delta Junction, AKThe pilot's failure to maintain clearance from trees during the approach to landing, which resulted in the main rotor blades striking a tree. A factor associated with the accident was the tree.Jul 28, 2005 · C-GBUY · Substantial damageNTSB ANC05CA109Accident · No injuriesData collectionFinal reportMaule MX7-180 · Yakutat, AKThe pilot's selection of unsuitable terrain for landing, and his failure to maintain directional control of the airplane during the landing roll, which resulted in a nose-over. A factor contributing to the accident was soft terrain.Jul 27, 2005 · N185DB · Substantial damageNTSB LAX05LA245Accident · Minor injuriesLimited investigationFinal reportBellanca 8GCBC · Oroville, CAa binding and/or activation of the brakes that lead to an inadvertent nose over. The underlying root cause of the brake binding/activation could not be determined.Jul 26, 2005 · N87008 · Substantial damageNTSB LAX05CA246Accident · Minor injuriesData collectionFinal reportStinson 108 · Hesperia, CAthe pilot's failure to maintain directional control during landing rollout.Jul 26, 2005 · N97492 · Substantial damageNTSB CHI05CA201Accident · No injuriesData collectionFinal reportCessna 188 · Mexico, MOThe pilot's failure to maintain directional control. Factors were the grass terrain adjacent to the runway and the collapse of the main landing gear.Jul 26, 2005 · N731SV · Substantial damageNTSB ATL05CA136Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Rogersville, TNThe flight instructor's failure to maintain directional control which resulted in a on ground collision with terrain.Jul 26, 2005 · N84FS · Substantial damageNTSB NYC05CA124Accident · No injuriesData collectionFinal reportWaco AQC-6 · Leonardtown, MDThe pilot's inadequate compensation for wind and his failure to maintain aircraft control while landing, which resulted in a nose over. A factor in this accident was the crosswind condition.Jul 24, 2005 · N16227 · Substantial damageNTSB CHI05CA196Accident · No injuriesData collectionFinal reportSimmons GP-4 · Oshkosh, WIThe pilot's failure to maintain airspeed sufficient enough to compensate for the gusty crosswind condition and prevent a stall during the landing flare. A factor associated with the accident was the gusting crosswind condition.Jul 24, 2005 · N619BS · Substantial damageNTSB ANC05LA104Accident · No injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKThe pilot's failure to compensate for wind conditions and his failure to maintain directional control of the airplane during the landing roll, which resulted in an excursion off the side of the runway and a nose over.Jul 24, 2005 · N332DG · Substantial damageNTSB SEA05CA150Accident · No injuriesData collectionFinal reportAmerican Champion 7ECA · Hailey, IDThe pilot's inadequate recovery from a bounced landing and his failure to maintain directional control during the landing roll. Factors include a crosswind, and soft terrain just off the side of the runway surface.Jul 23, 2005 · N16JE · Substantial damageNTSB NYC05CA122Accident · No injuriesData collectionFinal reportGulfstream American AA-5A · Schroon Lake, NYThe pilot's misjudgment of speed/distance which resulted in an overrun.Jul 21, 2005 · N26784 · Substantial damageNTSB ANC05CA103Accident · No injuriesData collectionFinal reportCessna 172 · Kenai, AKThe pilot's selection of an unsuitable landing area, which resulted in a nose over. A factor associated with the accident was swampy terrain.Jul 21, 2005 · N7886G · Substantial damageNTSB LAX05CA275Accident · No injuriesData collectionFinal reportCessna 172S · Edwards AFB, CAthe pilot's misjudged flare and inadequate recovery technique from the subsequent bounces.Jul 20, 2005 · N106ED · Substantial damageNTSB LAX05CA240Accident · No injuriesData collectionFinal reportCessna 172N · North Las Vegas, NVthe student pilot's failure to maintain directional control.Jul 20, 2005 · N4961D · Substantial damageNTSB IAD05LA111Accident · No injuriesLimited investigationFinal reportCessna 182T · Chatham, MAthe pilot's improper recovery from a bounced landing.Jul 20, 2005 · N1328N · Substantial damageNTSB IAD05CA104Accident · No injuriesData collectionFinal reportCessna 172S · Charlottesville, VAThe student pilot's improper flare which resulted in a hard landing.Jul 19, 2005 · N3537B · Substantial damageNTSB LAX05CA238Accident · No injuriesData collectionFinal reportCessna 152 · Rio Vista, CAthe student pilot's inadequate recovery from a bounced landing and his failure to maintain directional control of the airplane during landing rollout. A contributing factor was the student's failure to divert to an airport with less severe crosswind…Jul 18, 2005 · N68475 · Substantial damageNTSB ATL05CA134Accident · No injuriesData collectionFinal reportAircraft Mfg & Dev. CH2000 · Winston-Salem, NCThe student pilot's misjudged flare and his improper recovery from a bounced landing resulting in a stall and hard landing.Jul 18, 2005 · N240AM · Substantial damageNTSB ATL05CA133Accident · No injuriesData collectionFinal reportPiper PA-34-200 · Atlanta, GAThe pilot's improper use of normal braking and the failure to maintain directional control during landing. Also causal was the instructor's inadequate supervision of the flight which resulted in a collision with the ground.Jul 18, 2005 · N143PF · Substantial damage