NTSB investigations, LA

714 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\" = 'LA' 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 GAA15CA250Accident · No injuriesData collectionFinal reportGrumman American Avn. G 164A · Welsh, LAThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and a ground loop.Aug 28, 2015 · N8761H · Substantial damageNTSB GAA15CA236Accident · No injuriesData collectionFinal reportCessna 182Q · Pineville, LAThe pilot's failure to land with sufficient runway remaining to safely stop the airplane, resulting in a runway over-run and collision with terrain.Aug 24, 2015 · N759TZ · Substantial damageNTSB CEN15LA371Accident · Minor injuriesLimited investigationFinal reportCessna 172C · Venice, LAThe pilot's failure to attain a safe landing approach airspeed with a crosswind.Aug 15, 2015 · N1805Y · Substantial damageNTSB GAA15CA108Accident · No injuriesData collectionFinal reportGrumman American Avn. AA 5B · Springhill, LAUnintentional collision with a deer during landing in dusk visual conditions.Jun 5, 2015 · N74304 · Substantial damageNTSB CEN15CA246Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Winnsboro, LAThe pilot's improper approach to landing and his failure to perform a go-around, which resulted in a runway overshoot and collision with trees.May 29, 2015 · N1036S · Substantial damageNTSB CEN15LA207Accident · No injuriesLimited investigationFinal reportCessna 177B · Jennings, LAThe pilot's improper landing flare, which resulted in a hard landing, the nosewheel tire bursting, and a subsequent porpoise and nose-over.Apr 7, 2015 · N30981 · Substantial damageNTSB CEN14CA405Accident · No injuriesData collectionFinal reportAviat A-1C-180 · Oakdale, LAThe pilot's excessive braking on landing, which resulted in a loss of control.Jul 31, 2014 · N199MA · Substantial damageNTSB CEN14LA076Accident · No injuriesLimited investigationFinal reportCessna T210L · Lake Providence, LAThe pilot's mismanagement of available fuel and incorrect use of the fuel boost pump which resulted in a total loss of engine power at a low altitude.Nov 27, 2013 · N21ME · Substantial damageNTSB CEN13CA226Accident · No injuriesData collectionFinal reportEdward W Gray Lancair 360 · Alexandria, LAThe pilot's failure to attain the proper touchdown point, and his decision to continue the landing, which resulted in a runway excursion.Apr 13, 2013 · N77ZG · Substantial damageNTSB CEN13CA064Accident · Minor injuriesData collectionFinal reportLawson Ron Rans S-19 · Crowley, LAThe pilot’s improper landing flare, which resulted in the collapse of the nose landing gear and the airplane nosing over.Nov 10, 2012 · N434KL · Substantial damageNTSB CEN13LA050Accident · No injuriesLimited investigationFinal reportWaco SRE · Lafayette, LAThe pilot’s inability to maintain directional control of the airplane during the landing roll.Nov 4, 2012 · NC247E · Substantial damageNTSB CEN13FA025Accident · Serious injuriesField investigationFinal reportAgusta AW139 · Houma, LAThe helicopter’s sudden and severe vertical vibrations during landing, which resulted in a collision with terrain. The reason for the helicopter’s sudden and severe vertical vibrations could not be determined during postaccident examinations.Oct 22, 2012 · N385RH · Substantial damageNTSB CEN12LA434Accident · No injuriesLimited investigationFinal reportBeech A36 · New Orleans, LAThe pilot's failure to lower the landing gear before touchdown.Jun 27, 2012 · N136EH · Substantial damageNTSB CEN12CA272Accident · No injuriesData collectionFinal reportTucker-Hurni Starduster SA-300 · Vidalia, LAThe failure of the airplane’s right main landing gear due to a pre-existing fatigue crack and corrosion.Apr 27, 2012 · N4523 · Substantial damageNTSB CEN12FA250Accident · No injuriesField investigationFinal reportSikorsky S-76B · Gulf of Mexico, LAThe intermittent loss of engine power due to a "stuck" stepper motor in the No. 2 engine's fuel control as a result of an inadequate overhaul. Contributing to the accident was the pilot's decision to continue flying the helicopter with a known defect, his…Apr 17, 2012 · N56RD · Substantial damageNTSB CEN12CA240Accident · No injuriesData collectionFinal reportCessna 172S · Monroe, LAThe student pilot's improper landing flare, which resulted in a bounced landing and loss of directional control.Apr 10, 2012 · N5253Q · Substantial damageNTSB CEN12CA207Accident · Minor injuriesData collectionFinal reportPiper PA-22-150 · Crowley, LAThe student pilot's improper landing flare, which resulted in a nose-over.Mar 26, 2012 · N6143D · Substantial damageNTSB CEN12CA194Accident · No injuriesData collectionFinal reportCessna 177B · New Orleans, LAThe pilot’s improper flare, which resulted in a hard landing.Mar 15, 2012 · N30770 · Substantial damageNTSB CEN12CA185Accident · No injuriesData collectionFinal reportCessna 180H · Belle Chase, LAThe bent tailwheel spring that allowed the tailwheel to caster when the airplane encountered a wind gust on landing roll.Mar 11, 2012 · N3424Y · Substantial damageNTSB CEN12CA027Accident · No injuriesData collectionFinal reportMichael Cans RV-8 · Breaux Bridge, LAThe pilot's failure to maintain control of the airplane after striking an unseen sinkhole during landing.Oct 14, 2011 · N610EC · Substantial damageNTSB CEN11LA415Accident · Serious injuriesLimited investigationFinal reportBins Tom Kitfox IV · Lafayette, LAThe pilot’s loss of control during a forced landing after a loss of engine power for undetermined reasons during takeoff.Sep 24, 2011 · N211KF · Substantial damageNTSB CEN11IA615Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Baton Rouge, LAThe improperly installed upper attachment bolt in the left main landing gear uplock assembly, which led to the failure of the left main landing gear to extend before landing. Contributing to the accident was maintenance personnel's lack of training on the…Sep 1, 2011 · N875AS · Minor damageNTSB CEN11CA232Accident · No injuriesData collectionFinal reportBell 230 · Gulf of Mexico, LAThe pilot's failure to maintain adequate clearance from the safety skirting during the repositioning landing.Mar 17, 2011 · N974RH · Substantial damageNTSB CEN11CA231Accident · No injuriesData collectionFinal reportHiller UH-12D · Iowa, LAThe pilot's inadequate compensation for gusty crosswinds during takeoff, which resulted in a loss of directional control.Mar 17, 2011 · N11CU · Substantial damageNTSB CEN11CA216Accident · No injuriesData collectionFinal reportCessna A185F · Belle Chase, LAThe pilot's failure to ensure that the landing gear was retracted for the water landing.Mar 7, 2011 · N434JG · Substantial damageNTSB CEN11CA206Accident · No injuriesData collectionFinal reportWaco SRE · Vidalia, LAThe pilot’s failure to maintain directional control during landing in gusty wind conditions.Feb 26, 2011 · NC58785 · Substantial damageNTSB CEN11CA211Accident · Minor injuriesData collectionFinal reportPiper PA-34-220T · Bogalusa, LAThe pilot’s inadequate flare after encountering a gust of wind on landing.Feb 6, 2011 · N80311 · Substantial damageNTSB CEN11CA171Accident · No injuriesData collectionFinal reportCessna 172R · Shreveport, LAThe student pilot's loss of directional control during the landing.Jan 28, 2011 · N5929T · Substantial damageNTSB CEN10CA547Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Houma, LAThe pilot’s inadequate compensation for the crosswind while landing, which resulted in a loss of directional control.Sep 19, 2010 · N436ND · Substantial damageNTSB CEN10CA510Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Basile, LAThe loss of directional control during landing due to failure of the right brake for undetermined reasons.Aug 27, 2010 · N63E · Substantial damageNTSB CEN10LA427Accident · 1 fatalLimited investigationFinal reportCessna 180 · Davant, LAThe pilot’s improper application of the flight controls and throttle during landing, which resulted in a nose over and subsequent inverted immersion in the water. Contributing to the accident was the flight instructor’s delayed remedial action and inadequate…Jul 24, 2010 · N7812K · Substantial damageNTSB CEN10CA196Accident · No injuriesData collectionFinal reportCessna 150 · Waterproof, LAThe pilot's failure to maintain directional control during landing and his failure to initiate a go-around when encountering the strong gusting winds.Apr 7, 2010 · N66262 · Substantial damageNTSB CEN10CA086Accident · No injuriesData collectionFinal reportHoover Frank RV-8 · Houma, LAThe pilot's failure to maintain directional control during the landing roll.Dec 29, 2009 · N17325 · Substantial damageNTSB DFW08TA128Accident · No injuriesFinal reportBeech C90 · Baton Rouge, LAStructural failure of the right main landing gear torque knee. A contributing factor was the failure to inspect the torque knee at the designated interval.Apr 25, 2008 · N21SP · Substantial damageNTSB DFW08CA009Accident · No injuriesData collectionFinal reportAir Tractor AT-602 · Columbia, LAThe pilot's selection of an unsuitable landing area. Contributing factors were the tall vegetation on the sides of the airstrip and the short and confined landing area.Oct 11, 2007 · N8521L · Substantial damageNTSB DFW07LA107Accident · No injuriesLimited investigationFinal reportCessna 210 · Sulphur, LAThe collapsed of the right main landing gear for undetermined reasons.May 8, 2007 · N9461 · Substantial damageNTSB DFW07CA037Accident · No injuriesData collectionFinal reportHughes 269B · Houma, LAA partial loss of engine power as a result of a cracked engine cylinder and broken spark plug which resulted in a hard landing. A factor was that it was not possible to attain proper rotor RPM.Dec 11, 2006 · N9396F · 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 DFW06CA124Accident · No injuriesData collectionFinal reportRobinson R-44 · West Monroe, LAThe pilot's loss of control while taxiing.May 10, 2006 · N144DJ · DestroyedNTSB 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 DFW05CA084Accident · No injuriesData collectionFinal reportGrumman G-164A · Gilbert, LAThe pilot's failure to maintain control of the airplane during landing. A contributing factor was a deflated right main tire.Mar 10, 2005 · N5327 · Substantial damageNTSB DFW05LA080Accident · Minor injuriesLimited investigationFinal reportAero Vodochody Aero. Works L-39C · Shreveport, LAThe pilot's misjudgment of airspeed and his failure to abort the landing resulting in an overrun. A contributing factor was the wet runway.Mar 7, 2005 · N8098T · Substantial damageNTSB DFW05CA008Accident · No injuriesData collectionFinal reportPiper PA-22 · Reserve, LAThe pilot's failure to compensate for the existing wind conditions. A contributing factor was the strong crosswind.Oct 15, 2004 · N88390 · Substantial damageNTSB FTW04CA193Accident · Serious injuriesData collectionFinal reportHead Balloons AX8-88 · Baton Rouge, LAThe pilot's selection of an unsuitable area for landing. A contributing factor was the high vegetation.Aug 9, 2004 · N83063 · No damageNTSB FTW04LA135Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Many, LAThe pilot's improper touchdown which resulted in a hard landing.May 7, 2004 · N21131 · Substantial damageNTSB FTW04CA098Accident · No injuriesData collectionFinal reportStinson 108-1 · Slidell, LAthe pilot's failure to compensate for the gusty wind conditions and maintain control of the airplane while landing.Mar 27, 2004 · N8755K · Substantial damageNTSB FTW04LA099Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Mamou, LAThe pilot's delay in aborting the landing. A contributing factor included the entrance of a crawfish boat onto the airstrip.Mar 26, 2004 · N8276K · Substantial damageNTSB FTW04LA086Accident · No injuriesLimited investigationFinal reportLake LA4-270T · Crowley, LAThe pilot's inadvertant water landing with the landing gear extended. Contributing factors were the sunglare and the pilot's failure to verify the position of the flaps and landing gear.Feb 28, 2004 · N193TM · Substantial damageNTSB FTW03LA135Accident · Serious injuriesLimited investigationFinal reportAerostar RX-8 · Bossier City, LAThe failure of the passenger to follow the pilots landing instructions.Apr 19, 2003 · N7172D · No 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 damage