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 ANC06CA110Accident · Minor injuriesData collectionFinal reportPiper PA-12 · Coldfoot, AKThe pilot's selection of an unsuitable landing area, which resulted in an in-flight collision with terrain during an aborted landing. Factors associated with the accident were wind gusts, and rough and uneven terrain.Aug 10, 2006 · N7663H · Substantial damageNTSB NYC06CA199Accident · No injuriesData collectionFinal reportStampe SV-4C · Taneytown, MDThe collapse of the right main landing gear for an undetermined reason.Aug 9, 2006 · N81RG · Substantial damageNTSB ANC06CA117Accident · No injuriesData collectionFinal reportPiper PA-14 · Talkeetna, AKThe pilot's failure to compensate for wind conditions during the landing roll, which resulted in a loss of control and subsequent collision with a ditch. Factors contributing to the accident were a crosswind, and an inadvertent ground loop.Aug 8, 2006 · N5114H · Substantial damageNTSB SEA06CA171Accident · No injuriesData collectionFinal reportPiper PA-23-250 · Greenacres, WAThe pilot's selection of an unsuitable landing runway which resulted in a runway overrun and collision with a fence. A contributing factor was the wet runway condition.Aug 7, 2006 · N6549A · Substantial damageNTSB CHI06CA261Accident · No injuriesData collectionFinal reportBeech B19 · Eden Prarie, MNThe pilot not maintaining directional control of the airplane during the landing. A factor was the ditch.Aug 7, 2006 · N214RS · Substantial damageNTSB CHI06CA228Accident · No injuriesData collectionFinal reportPiper PA-18 · Waukesha, WIThe pilot's inadequate compensation for the crosswind and failure to maintain directional control which resulted in a groundloop. Factors included the closed runway and the crosswind condition.Aug 7, 2006 · N2396J · Substantial damageNTSB DFW06CA196Accident · No injuriesData collectionFinal reportPearson Superfly · Denton, TXThe loss of control as result of the pilot's selection of an unsuitable landing area. A contributing factor was the muddy terrain.Aug 6, 2006 · N975JP · Substantial damageNTSB CHI06CA217Accident · No injuriesData collectionFinal reportVeltman CH701 · Owosso, MIThe pilot's inadequate preflight planning and inadequate compensation for the tailwind condition. Factors included the tailwind and the power lines.Aug 6, 2006 · N702BW · Substantial damageNTSB DEN06CA110Accident · No injuriesData collectionFinal reportCessna 182E · Roset, WYan inadvertent pilot-induced porpoise and his improper remedial action. A contributing factor was the wind gust.Aug 4, 2006 · N3344Y · Substantial damageNTSB SEA06CA155Accident · No injuriesData collectionFinal reportCessna 180H · Belgrade, MTThe pilot's failure to maintain directional control while landing.Aug 3, 2006 · N7955V · Substantial damageNTSB ATL06CA117Accident · No injuriesData collectionFinal reportCessna 172S · Thomson, GAThe student pilot's failure to maintain directional control during the landing roll resulting in an on-ground collision with an embankment.Aug 3, 2006 · N124CK · Substantial damageNTSB ATL06CA116Accident · No injuriesData collectionFinal reportCessna 172M · Augusta, GAThe pilot's improper flare on landing with excessive altitude resulting in a hard landing.Aug 3, 2006 · N20965 · Substantial damageNTSB SEA06CA156Accident · No injuriesData collectionFinal reportCessna 180 · Elk City, IDThe pilot's failure to maintain directional control, which resulted in a ground loop during the landing roll.Aug 2, 2006 · N3239D · Substantial damageNTSB NYC06TA190Accident · Minor injuriesFinal reportMD Helicopter 500N · Louisville, KYThe pilot's failure to maintain control of the helicopter and the flight instructor's inadequate supervision, which resulted in a hard landing and subsequent rollover.Aug 2, 2006 · N520AP · Substantial damageNTSB CHI06CA221Accident · No injuriesData collectionFinal reportAir Tractor AT-400 · Springfield, MNThe pilot's inability to maintain directional control of the airplane as a result of the partial failure of the tail wheel assembly. A factor associated with the accident was the crop that the airplane contacted.Jul 31, 2006 · N23720 · Substantial damageNTSB ANC06LA102Accident · Serious injuriesLimited investigationFinal reportLiberty XL2 · Ormond Beach, FLThe pilot's improper recovery from a bounced landing, and failure to maintain minimum airspeed during the subsequent aborted landing, which resulted in an inadvertent stall and impact with terrain. A factor associated with the accident was the inadvertent…Jul 31, 2006 · N520XL · Substantial damageNTSB SEA06CA150Accident · No injuriesData collectionFinal reportCessna 180J · Hailey, IDThe pilot's failure to adequately compensate for wind conditions.Jul 30, 2006 · N42401 · Substantial damageNTSB CHI06CA209Accident · No injuriesData collectionFinal reportCessna 180M · Chisholm, MNThe pilot's inadequate compensation for the wind condition. A factor associated with the accident was the gusty wind condition.Jul 30, 2006 · N3336T · Substantial damageNTSB NYC06CA189Accident · No injuriesData collectionFinal reportCessna 172P · Poughkeepsie, NYThe student pilot's improper flare and failure to recover from a bounced landing, which resulted in a hard landing.Jul 29, 2006 · N97650 · Substantial damageNTSB LAX06CA268Accident · No injuriesData collectionFinal reportCessna 414A · Ontario, CAthe pilot's inadvertent retraction of the landing gear during the landing roll.Jul 29, 2006 · N805PR · Substantial damageNTSB DFW06CA194Accident · Serious injuriesData collectionFinal reportCurtiss-Wright Travel Air 4000 · Jackson, MSThe pilot's failure to maintain airspeed on final approach resulting in an inadvertent stall and a subsequent loss of control.Jul 29, 2006 · N6106 · Substantial damageNTSB SEA06TA152Accident · No injuriesFinal reportCessna TU206G · Lowman, IDThe pilot's loss of aircraft control due to a downdraft on short final followed by an uncontrolled descent to a hard landing.Jul 28, 2006 · N5421X · Substantial damageNTSB DCA06FA058Accident · No injuriesField investigationFinal reportBoeing MD-10-10F · Memphis, TNthe failure of the left main landing gear due to fatigue cracking in the air filler valve hole on the aft side of the landing gear. The fatigue cracking occurred due to the presence of stray nickel plating in the air filler valve hole. Contributing to this…Jul 28, 2006 · N391FE · Substantial damageNTSB ANC06CA106Accident · No injuriesData collectionFinal reportTaylorcraft F19 · Hoonah, AKThe pilot's delayed go-around during an aborted landing, which resulted in an in-flight loss of control and impact with terrain. A factor associated with the accident was high vegetation.Jul 28, 2006 · N8216E · Substantial damageNTSB SEA06CA149Accident · No injuriesData collectionFinal reportMaule M-7-235C · Auburn, WAThe loss of directional control [not possible] during landing roll as a result of the disconnected tail wheel steering assembly [for undetermined reasons], which led to an inadvertent ground loop during the landing roll.Jul 26, 2006 · N15SN · Substantial damageNTSB DEN06CA104Accident · Serious injuriesData collectionFinal reportTop Dog 582 · Pleasanat View, COthe pilot's improper flare resulting in a hard landing.Jul 26, 2006 · UNREG · Substantial damageNTSB ANC06LA099Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Palatka, FLThe pilot's failure to maintain adequate airspeed to preclude a stall during the landing flare/touchdown, which resulted in a hard landing, a collapsed nose gear assembly, and a nose over. A factor associated with the accident was an inadvertent stall.Jul 25, 2006 · N8896G · Substantial damageNTSB ANC06CA097Accident · No injuriesData collectionFinal reportCessna 180 · Anchor Point, AKThe pilot's inadequate compensation for wind conditions, which resulted in a collision with high brush during the landing flare. A factor contributing to the accident was wind gusts.Jul 24, 2006 · N9588B · Substantial damageNTSB LAX06FA243Accident · 2 fatalField investigationFinal reportRaytheon G36 · Bullhead City, AZThe pilot's misjudged distance and speed that led to a long landing, and his inadequate recovery from a bounced landing, all due to the effects of impairment from alcohol consumption, which resulted in an in-flight collision with terrain during an aborted…Jul 23, 2006 · N241JL · Substantial damageNTSB CHI06CA214Accident · No injuriesData collectionFinal reportRobinson R-44 · Wadsworth, ILThe pilot inadvertently pulled back on the cyclic when birds flew into the windscreen. A factor associated with the accident were the birds.Jul 23, 2006 · N454WT · Substantial damageNTSB CHI06CA199Accident · Minor injuriesData collectionFinal reportPorter Mustang II · Ainsworth, NEThe delay in initiating the aborted landing which resulted in inadequate altitude to clear high vegetation off the end of the runway. Factors associated with the accident were the gusty crosswind, inadequate compensation for the wind conditions, and the high…Jul 23, 2006 · N96AP · Substantial damageNTSB ANC06LA098Accident · No injuriesLimited investigationFinal reportCessna 402B · Ft. Lauderdale, FLThe pilot's continued flight into adverse weather, and his failure to maintain directional control of the airplane during the landing roll, which resulted in a collision with an airport runway sign, and subsequent collapse of the nose gear. A factor…Jul 23, 2006 · N991PH · Substantial damageNTSB ATL06CA109Accident · No injuriesData collectionFinal reportCessna 182L · Eatonton, GAThe CFI's failure to initiate a go-around when he noticed the flight was high during approach resulting in the flight landing long, overrunning the runway , and colliding with trees. Factors in the accident were a wet runway and a tailwind for landing.Jul 22, 2006 · N3415R · Substantial damageNTSB CHI06LA208Accident · Serious injuriesLimited investigationFinal reportAerostar International RX 8 · Claremont, MNThe procedure not followed by the passenger during landing and the inadequate supervision of the passenger by the pilot during landing. A contributing factors were the barbed wire fence.Jul 21, 2006 · N3639Q · No damageNTSB LAX06LA240Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Show Low, AZthe pilot's failure to maintain directional control during landing.Jul 20, 2006 · N6516E · Substantial damageNTSB LAX06CA241Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Greenfield, CAthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control of the airplane during landing.Jul 20, 2006 · N53SE · Substantial damageNTSB ANC06LA094Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Willow, AKThe pilot's misjudged distance/altitude during landing, which resulted in an undershoot and an in-flight collision with trees.Jul 20, 2006 · N2438K · Substantial damageNTSB LAX06CA239Accident · No injuriesData collectionFinal reportCessna 177RG · Camarillo, CAthe pilot's failure to extended the landing gear and verify the proper landing gear configuration prior to landing, resulting in a gear-up landing.Jul 19, 2006 · N34480 · Substantial damageNTSB LAX06CA237Accident · No injuriesData collectionFinal reportBeech A36 · Bakersfield, CAthe pilot's improper flare, which resulted in a hard landing.Jul 19, 2006 · N4785M · Substantial damageNTSB CHI06FA193Accident · 2 fatalField investigationFinal reportCessna 560 · Cresco, IAThe flight crew's inadequate aeronautical decision-making and poor crew resource management (CRM), including the inadequate use of the on-board sources (such as the flight management system and navigation charts), to get critical information about Ellen…Jul 19, 2006 · N636SE · Substantial damageNTSB DFW06FA186Accident · 3 fatalField investigationFinal reportBeech BE58P · Jeanerette, LAThe pilot's continued flight into adverse weather condition and his delayed attempt to abort the landing. A contributing factor was the prevailing thunderstorm.Jul 18, 2006 · N158LW · DestroyedNTSB CHI06CA203Accident · No injuriesData collectionFinal reportCessna 182 · Napoleon, MIThe pilot failed to perform a go-around which resulted in landing long on the airstrip. Factors associated with the accident were the tailwind, the pilot's selection of runway direction, the fence posts, the fence, and the trees which were contacted.Jul 18, 2006 · N6155B · Substantial damageNTSB ATL06IA108Incident · No injuriesIncident investigationFinal reportDassault Mystere Falcon 900 · Greenville, SCThe malfunction of the anti-skid system SPAD controller during the landing roll, which resulted in failure of the anti-skid braking system, and a runway overrun.Jul 17, 2006 · N699BG · No damageNTSB DEN06CA101Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Olathe, KSthe pilot's failure to extend the landing gear prior to landing.Jul 16, 2006 · N6955P · DestroyedNTSB ATL06CA107Accident · No injuriesData collectionFinal reportCessna 182Q · Lafayette, GAThe pilot's improper flare which resulted in a hard landing.Jul 16, 2006 · N97351 · Substantial damageNTSB SEA06CA144Accident · No injuriesData collectionFinal reportPiper PA-11 · Turner, MTThe passenger's inadvertent activation of the airplane's brakes during the landing roll, resulting in the pilot's loss of control and subsequent nose over. A factor was the pilot's inadequate preflight planning/preparation by not briefing the passenger about…Jul 15, 2006 · N4706H · Substantial damageNTSB LAX06LA231Accident · Minor injuriesLimited investigationFinal reportBeech C35 · Beckwourth, CAthe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing roll.Jul 15, 2006 · N715D · DestroyedNTSB ANC06CA091Accident · No injuriesData collectionFinal reportDahlstrom - Piel Emeraude CP-30 · Venice, FLThe pilot's inadequate compensation for crosswind conditions, which resulted in a loss of control during the landing roll. Factors associated with the accident were a crosswind, and an inadvertent swerve.Jul 15, 2006 · N667N · Substantial damageNTSB ATL06CA105Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Griffin, GAThe pilot's failure to maintain direction control of the airplane during the landing roll.Jul 14, 2006 · N546CA · Substantial damageNTSB CHI06CA189Accident · No injuriesData collectionFinal reportCessna 172R · Waterford, MIThe directional control not obtained/maintained, the inadequate compensation for wind conditions, and the go-around not performed during landing by the pilot. An additional cause was the lack of experience by the pilot. A contributing factor was the crosswind.Jul 13, 2006 · N918TA · Substantial damage