NTSB investigations, AL

748 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.\"eventStateOrRegion\" = 'AL' AND c.\"eventCountry\" = 'USA'
    AND 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 ERA15LA240Accident · No injuriesClass 3 · LimitedFinal reportWeatherly 201B · Pell City, ALThe inadequate inspection of the airplane's landing gear, which resulted in a collapse of the right main landing gear due to cracking and corrosion.Jun 14, 2015 · N1272W · Substantial damageNTSB ERA15CA035Accident · Serious injuriesData collectionFinal reportHead AX8 88B · Montevallo, ALThe pilot's decision to conduct a landing to a confined area in high wind conditions, which resulted in a hard landing and subsequent injury to a passenger.Oct 25, 2014 · N20671 · No damageNTSB ERA14CA431Accident · No injuriesData collectionFinal reportPiper PA-18A-150 · Gunthersville, ALThe pilot's failure to retract the landing gear wheels prior to a water landing, resulting in a nose over upon touchdown.Sep 6, 2014 · N7089B · Substantial damageNTSB ERA14CA376Accident · Minor injuriesData collectionFinal reportPiper PA 34-220T · Gulf Shores, ALThe pilot's improper flare, which resulted in a bounced landing and subsequent loss of aircraft control.Aug 6, 2014 · N212RW · Substantial damageNTSB ERA14LA324Accident · No injuriesLimited investigationFinal reportBeech 95 55 · Gulf Shores, ALThe pilot’s improper landing flare, which resulted in a hard landing.Jun 26, 2014 · N9411Y · Substantial damageNTSB ERA14CA177Accident · No injuriesData collectionFinal reportAviat A 1B · Dadeville, ALThe pilot's failure to obtain the proper touchdown point while landing on a lake with a tailwind.Mar 27, 2014 · N59AW · Substantial damageNTSB ERA14CA134Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · Gulf Shores, ALThe student pilot's incorrect rudder input, which resulted in a ground loop and collision with a runway sign.Feb 25, 2014 · N156WB · Substantial damageNTSB ERA13LA308Accident · Serious injuriesLimited investigationFinal reportHiller UH-12A · Florence, ALThe student pilot’s failure to maintain control of the helicopter while landing, which resulted in a tail rotor ground strike and collision with terrain.Jun 29, 2013 · N6331D · Substantial damageNTSB ERA13LA041Accident · No injuriesLimited investigationFinal reportGrumman American Avn. AA-5A · Fairhope, ALThe Grumman pilot’s loss of directional control during landing for undetermined reasons because postaccident examination of the airplane did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the Piper pilot…Oct 26, 2012 · N26380 · 2 aircraft · Substantial damageNTSB ERA13CA028Accident · No injuriesData collectionFinal reportCessna 172RG · Mobile, ALThe pilot’s failure to perform the before landing checklist and extend the landing gear before touchdown. Contributing to the accident was the designated pilot examiner’s inadequate remedial action.Oct 11, 2012 · N4939V · Substantial damageNTSB ERA12LA505Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Bay Minette, ALThe separation of the tailwheel linkage for reasons that could not be determined because the linkage was not located, which resulted in a loss of directional control during landing.Aug 13, 2012 · N9216D · Substantial damageNTSB ERA12LA441Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Auburn, ALThe airplane owner’s failure to have maintenance personnel comply with an aircraft manufacturer's service bulletin to require engine mount inspections for fatigue cracks, which resulted in an undetected fatigue crack, the engine mount failing, and the nose…Jul 6, 2012 · N4133G · Substantial damageNTSB ERA12CA437Accident · No injuriesData collectionFinal reportCessna TR182 · Meridianville, ALThe pilot's inadequate landing flare, which resulted in a hard, bounced landing.Jun 22, 2012 · N5527S · Substantial damageNTSB ERA12CA390Accident · No injuriesData collectionFinal reportCessna 150H · Alabaster, ALThe pilot's failure to maintain directional control while landing in gusting wind conditions.Jun 9, 2012 · N6963S · Substantial damageNTSB ERA12CA381Accident · No injuriesData collectionFinal reportBoeing A75N1 · Foley, ALThe pilot's failure to maintain airplane control during landing.May 26, 2012 · N60198 · Substantial damageNTSB ERA12CA339Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Gulf Shores, ALThe pilot's inadvertent application of the wheel brakes immediately after landing, which resulted in the airplane nosing over.May 16, 2012 · N86917 · Substantial damageNTSB ERA12CA185Accident · No injuriesData collectionFinal reportCessna 172S · Eufaula, ALAn inadvertent collision with a deer during a night landing.Feb 14, 2012 · N6194V · Substantial damageNTSB ERA11CA477Accident · No injuriesData collectionFinal reportPitts Special · Bessemer, ALThe pilot's failure to maintain directional control during the landing roll.Aug 20, 2011 · N2997G · Substantial damageNTSB ERA11CA127Accident · No injuriesData collectionFinal reportPiper PA28 · Monroeville, ALThe pilot's failure to maintain directional control during the landing rollout.Jan 26, 2011 · N9742J · Substantial damageNTSB CEN11IA111Incident · No injuriesIncident investigationFinal reportCessna 560XL · Birmingham, ALThe manufacturer's inadequate initial design and inadequate subsequent modifications of the tailcone, which allowed moisture to collect and freeze around rudder cables during operations in subfreezing temperatures, resulting in a loss of rudder authority…Dec 13, 2010 · N498AB · No damageNTSB ERA10LA110Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Auburn, ALThe pilot's loss of directional control after landing, which resulted in a runway excursion.Jan 6, 2010 · N8448Y · Substantial damageNTSB ERA10CA093Accident · No injuriesData collectionFinal reportRockwell International 114 · Birmingham, ALA total loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate preflight fuel planning.Dec 9, 2009 · N5872N · Substantial damageNTSB ERA09CA535Accident · No injuriesData collectionFinal reportC A Tecnam P2002 Sier · Enterprise, ALThe student pilot's failure to maintain control during the landing roll.Sep 23, 2009 · N246TS · Substantial damageNTSB ERA09CA475Accident · Serious injuriesData collectionFinal reportPiper PA-22 · Tuskegee, ALThe pilot’s failure to maintain directional control during the aborted landing.Aug 23, 2009 · N1415A · Substantial damageNTSB ERA09CA443Accident · No injuriesData collectionFinal reportCessna 172S · Alabaster, ALThe student pilot's failure to maintain directional control during landing.Aug 4, 2009 · N2110Q · Substantial damageNTSB ERA09CA242Accident · No injuriesData collectionFinal reportNorth American SNJ · Bessemer, ALThe pilot's failure to maintain aircraft control while landing with a crosswind.Apr 14, 2009 · N269WB · Substantial damageNTSB ERA09CA136Accident · No injuriesData collectionFinal reportMaule MX-7-180C · Akron, ALThe pilot's failure to maintain directional control during landing. Contributing to the accident was the crosswind.Jan 18, 2009 · N1052U · Substantial damageNTSB ERA09CA058Accident · No injuriesData collectionFinal reportCessna 172 · Gulf Shores, ALThe pilot's improper flare during landing.Nov 10, 2008 · N172PA · Substantial damageNTSB ERA09CA023Accident · No injuriesData collectionFinal reportPiper PA-20 · Albertville, ALThe pilot’s failure to maintain control of the airplane during the landing roll.Oct 19, 2008 · N7324K · Substantial damageNTSB ERA09CA016Accident · No injuriesData collectionFinal reportCessna 182T · Gulf Shores, ALThe pilot's improper recovery from a bounced landing.Oct 6, 2008 · N22AS · Substantial damageNTSB MIA08CA165Accident · No injuriesData collectionFinal reportCessna 172S · Monroeville, ALThe pilot's inadequate compensation for winds during landing. Contributing to the accident was a wind gust.Aug 9, 2008 · N1600U · Substantial damageNTSB MIA08LA138Accident · 2 fatalLimited investigationFinal reportColyaer SL Freedom S100 · Limestone, ALThe pilot's loss of aircraft control for undetermined reasons while making a water landing.Jul 9, 2008 · N4450E · Substantial damageNTSB NYC08CA195Accident · Minor injuriesData collectionFinal reportSchweizer 269C · Mt. Olive, ALThe flight instructor's inadequate remedial action following an encounter with ground resonance.May 27, 2008 · N368HF · Substantial damageNTSB MIA08CA095Accident · No injuriesData collectionFinal reportChampion 7KCAB · Alexander City, ALThe separation of the right tail wheel spring on landing roll out for undetermined reasons, resulting in a loss of directional control and collision with a ditch.Apr 23, 2008 · N1682G · Substantial damageNTSB MIA08CA057Accident · No injuriesData collectionFinal reportCessna 172N · Centre, ALThe pilot's improper landing flare, resulting in a hard landing.Mar 3, 2008 · N203GT · Substantial damageNTSB MIA08CA039Accident · No injuriesData collectionFinal reportPiper PA-32-300 · Lapine, ALThe pilot's failure to attain the proper touchdown point.Jan 12, 2008 · N84JC · Substantial damageNTSB MIA08CA030Accident · No injuriesData collectionFinal reportCessna 172N · Talladega, ALThe pilot's failure to maintain directional control of the airplane.Dec 18, 2007 · N2180E · Substantial damageNTSB NYC08CA073Accident · No injuriesData collectionFinal reportPiper PA-31T · Muscle Shoals, ALThe pilot's failure to lower the landing gear.Dec 13, 2007 · N112ED · Substantial damageNTSB NYC08LA018Accident · No injuriesLimited investigationFinal reportBlair Skybolt · Guntersville, ALSeparation of the right tailwheel control link spring from the right control arm of the tailwheel, which resulted in a loss of control during landing.Oct 20, 2007 · N1UU · Substantial damageNTSB ATL07CA126Accident · No injuriesData collectionFinal reportRans RV-9A · Harvest, ALThe pilot's improper landing flare and touchdown.Sep 12, 2007 · N269RV · Substantial damageNTSB NYC07CA222Accident · Minor injuriesData collectionFinal reportLancair IV-P · Alabaster, ALThe pilot's failure to attain the proper touchdown point.Sep 11, 2007 · N335DF · Substantial damageNTSB DFW07CA136Accident · No injuriesData collectionFinal reportSandall Evan R RV8 · Wilsonville, ALThe pilot's failure to maintain directional control while landing.Jun 16, 2007 · N222ES · Substantial damageNTSB MIA07LA102Accident · 1 fatalLimited investigationFinal reportBell 47G · Hayden, ALThe student pilot's failure to maintain aircraft control during hover, following a bounced landing.May 27, 2007 · N7763 · Substantial damageNTSB NYC07CA113Accident · No injuriesData collectionFinal reportMooney M-18L · Bessemer, ALThe pilot's failure to maintain control which resulted in a hard landing and subsequent gear collapse during the landing roll. A factor in the accident was wind gusts.May 6, 2007 · N119C · Substantial damageNTSB ATL07CA080Accident · No injuriesData collectionFinal reportRans RV-4 · Selma, ALThe pilot's failure to maintain directional control during landing roll.Apr 22, 2007 · N186AS · Substantial damageNTSB ATL07LA004Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Alabaster, ALThe jammed landing gear hydraulic motor shuttle valve.Oct 7, 2006 · N70SR · Substantial damageNTSB ATL06CA104Accident · No injuriesData collectionFinal reportCessna 182H · Birmingham, ALThe pilot's failure to maintain airspeed during final approach resulting in a stall/mush and a hard landing.Jul 8, 2006 · N3479S · Substantial damageNTSB ATL06CA032Accident · Minor injuriesData collectionFinal reportCessna T210L · Auburn, ALThe pilot's failure to attain the proper touchdown point during landing which resulted in an overrun and subsequent on ground collision with a fence.Jan 2, 2006 · N246PL · Substantial damageNTSB MIA06CA043Accident · No injuriesData collectionFinal reportAviat A-1B · Alexander City, ALThe failure of the pilot-in-command to maintain the proper rate of descent during approach for landing to the glassy water resulting in a hard landing and separation of the floats.Dec 30, 2005 · N841CF · Substantial damageNTSB ATL06CA025Accident · No injuriesData collectionFinal reportCessna 172S · Mobile, ALThe pilot's improper landing flare, which resulted in a hard landing.Dec 13, 2005 · N348SP · Substantial damage