OpenAirDocs.org

NTSB investigations, LA

315 cases where the phase of flight was Approach.

Cases per year

19622026

Where

Open the map

Latest cases

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 = 500)
  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 CEN26FA051Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 172N · New Orleans, LAOn November 24, 2025, at 1824 central standard time, a Cessna 172N airplane, N80FP, was destroyed when it was involved in an accident near New Orleans, Louisiana. The flight instructor and pilot receiving instruction were fatally injured. The flight was…Nov 25, 2025 · N80FP · DestroyedNTSB CEN25FA144Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 210L · Raceland, LAOn April 2, 2025, at 2030 central daylight time, a Cessna 210L airplane, N1574P, was destroyed when it was involved in an accident near Raceland, Louisiana. The pilot and flight instructor were fatally injured. The airplane was operated as a Title 14 Code of…Apr 3, 2025 · N1574P · DestroyedNTSB CEN25FA014Accident · 1 fatalClass 3 · FieldPreliminary reportRans S12 · Church Point, LAOn October 15, 2024, at 1514 central daylight time, a Rans S12S, N912RS, was involved in an accident near Church Point, Louisiana. The airline transport pilot sustained fatal injuries. The airplane was destroyed. The airplane was operated under Title 14 Code…Oct 15, 2024 · N912RS · DestroyedNTSB CEN23FA283Accident · 2 fatalClass 3 · FieldFinal reportBeech A36 · Rayville, LAThe pilot’s visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control during the approach to the destination airport and subsequent impact with terrain.Jul 7, 2023 · N15RP · DestroyedNTSB CEN23LA087Accident · No injuriesClass 3 · LimitedFinal reportWorld WA-3 · Shreveport, LAThe loss of engine power due to carburetor icing.Jan 20, 2023 · N71SN · Substantial damageNTSB CEN23LA028Accident · Serious injuriesClass 3 · LimitedFinal reportBeech E-90 · Slidell, LAThe pilot’s failure to maintain airplane control during an attempted go-around in low visibility conditions.Nov 7, 2022 · N809DM · DestroyedNTSB CEN22LA391Accident · No injuriesClass 3 · LimitedFinal reportBeech F33A · Baton Rouge, LAThe sudden and total loss of fuel flow to the engine for undetermined reasons.Aug 18, 2022 · N17747 · Substantial damageNTSB CEN22LA162Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-220T · Slidell, LAThe flight instructor’s failure to adequately correct for a loss of directional control during a simulated single engine approach.Mar 29, 2022 · N4299C · Substantial damageNTSB CEN22LA037Accident · No injuriesClass 3 · LimitedFinal reportBeech K35 · Hammond, LAA complete loss of engine power due to oil starvation as a result of the oil filter safety wire fracturing and the oil filter becoming loose in flight for a reason that could not be determined given the evidence available during the investigation.Oct 28, 2021 · N899RW · Substantial damageNTSB CEN22LA009Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Gonzales, LAThe student pilot’s failure to compensate for an unanticipated right yaw, which resulted in a loss of tail rotor effectiveness and helicopter control.Oct 6, 2021 · N373SP · Substantial damageNTSB CEN21LA399Accident · Serious injuriesClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P92 Echo Classic · Cotton Port, LAThe pilot exceeding the airplane’s critical angle of attack, resulting in an aerodynamic stall and subsequent loss of control during go-around after a bounced landing.Sep 2, 2021 · N303TA · Substantial damageNTSB CEN21LA253Accident · No injuriesClass 4 · LimitedFinal reportSchweizer TH55A/269A · Monroe, LAThe pilot’s failure to maintain yaw control during landing which resulted in a loss of tail rotor effectiveness.Jun 3, 2021 · N41G · Substantial damageNTSB CEN21LA045Accident · No injuriesClass 3 · LimitedFinal reportJust SuperSTOL · Edgard, LAThe loss of engine power for reasons that could not be determined with the available information.Nov 5, 2020 · N339PW · Substantial damageNTSB CEN20LA131Accident · Serious injuriesClass 3 · LimitedFinal reportBower Challenger II · Lettsworth, LAThe owner/pilot's inability to maintain control of the airplane due to his lack of training and experience, resulting in a collision with a tree.Mar 22, 2020 · N6138Z · Substantial damageNTSB CEN20FA075Accident · 3 fatalClass 3 · FieldFinal reportCessna 182 · Chatham, LAThe pilot’s encounter with icing in-flight, which resulted in a loss of control and impact with terrain.Feb 6, 2020 · N60381 · DestroyedNTSB CEN20LA046Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Shreveport, LAThe loss of engine power for undetermined reasons.Nov 24, 2019 · N22931 · Substantial damageNTSB CEN19FA270Accident · 2 fatalClass 3 · FieldFinal reportPitts S2 · New Orleans, LAA loss of control for undetermined reasons.Aug 16, 2019 · N600DF · DestroyedNTSB GAA19CA115Accident · No injuriesData collectionFinal reportNavion Navion · Patterson, LAThe pilot's failure to maintain clearance from power lines while making an evasive maneuver to avoid birds.Jan 20, 2019 · N384TL · Substantial damageNTSB CEN18LA257Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · Springhill, LAThe pilot’s exceedance of the airplane's critical angle of attack during an improper go-around procedure which resulted in an aerodynamic stall.Jul 3, 2018 · N689KC · Substantial damageNTSB GAA18CA244Accident · No injuriesData collectionFinal reportLuscombe 8 · Eunice, LAThe pilot’s failure to maintain clearance from a tree while on approach to land.Apr 28, 2018 · N71261 · Substantial damageNTSB OPS17IA021IncidentClass 3 · IncidentFinal reportCessna 172S · New Orleans, LAThe air traffic controller not following Federal Aviation Administration directives to establish sequencing and spacing between aircraft operating to the same runway.May 9, 2017 · N520ER · 2 aircraft · No damageNTSB CEN17LA157Accident · No injuriesLimited investigationFinal reportCessna 210 · Minden, LAThe pilot's inadequate fuel planning and in-flight fuel monitoring, which resulted in a total loss of engine power due to fuel exhaustion.Apr 15, 2017 · N7358E · Substantial damageNTSB CEN17LA092Accident · Minor injuriesLimited investigationFinal reportZenith CH750 Stol · Jennings, LAA failure of the right fuel tank to supply fuel to the engine for reasons that could not be determined, which resulted in a total loss of engine power due to fuel starvation.Jan 30, 2017 · N1972C · Substantial damageNTSB GAA17CA103Accident · Minor injuriesData collectionFinal reportPiper PA28 · Shreveport, LAThe pilot’s inadequate compensation for crosswind conditions during the go-around, which resulted in a loss of airplane control.Dec 22, 2016 · N9541W · Substantial damageNTSB CEN16LA338Accident · 2 fatalLimited investigationFinal reportCessna 172 · New Orleans, LAThe pilot's improper decision to continue a descent during a night visual approach a for landing which resulted in controlled flight into terrain. Contributing to the accident was the reduced visibility and pilot's disregard of the PAPI indications that the…Aug 28, 2016 · N984RA · Substantial damageNTSB CEN16FA158Accident · 2 fatalField investigationFinal reportBeech 65 A90 1 · Slidell, LAThe unstable approach in black-hole conditions, resulting in the airplane overshooting the runway extended centerline and descending well below a safe glidepath for the runway. Contributing to the accident was the lack of monitoring by the copilot allowing…Apr 20, 2016 · N7MC · DestroyedNTSB CEN16LA143Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Alexandria, LAThe partial loss of engine power for reasons that could not be determined based on the available information.Mar 23, 2016 · N927DS · Substantial damageNTSB CEN16LA064Accident · Minor injuriesLimited investigationFinal reportCessna 305A · Sulphur, LAThe loss of engine power due to water and contaminants in the carburetor, which resulted in a forced landing to a wet field.Nov 24, 2015 · N5312G · Substantial damageNTSB CEN15IA085Incident · No injuriesIncident investigationFinal reportDassault/Sud FAN JET Falcon · Shreveport, LAA short in the trim system’s wires and connector, which resulted in the elevator trim being in a full nose-down position.Dec 12, 2014 · N827AA · No damageNTSB CEN14LA449Accident · No injuriesLimited investigationFinal reportPiper PA 28-161 · New Orleans, LAThe in-flight fatigue failure of the crankshaft gear retaining bolt, which resulted in a total loss of engine power. Contributing to the accident were the pilot/owner’s failure to maintain the airplane in accordance with an airworthiness directive following a…Aug 22, 2014 · N8440N · Substantial damageNTSB CEN14LA273Accident · Serious injuriesLimited investigationFinal reportBeech H35 · Monroe, LAThe loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.Jun 3, 2014 · N653T · Substantial damageNTSB CEN14CA189Accident · Minor injuriesData collectionFinal reportBelisle Thomas J RV7A · New Iberia, LAThe pilot's loss of control due to a temporary incapacitation.Apr 5, 2014 · N119TB · Substantial damageNTSB CEN13FA143Accident · 4 fatalField investigationFinal reportRaytheon A36 · Richwood, LAThe pilot's failure to maintain control of the airplane during a missed approach in instrument meteorological conditions.Jan 24, 2013 · N980SS · DestroyedNTSB CEN13LA063Accident · 1 fatalLimited investigationFinal reportRedd Tom Quicksilver GT 400 · Oak Grove, LAThe total loss of engine power, the specific cause of which could not be identified during the postaccident examination, and the airplane’s subsequent impact with trees.Nov 19, 2012 · N4031Q · Substantial damageNTSB CEN12FA611Accident · 1 fatalField investigationFinal reportFairley Gooch Lancair IV · Winnsboro, LAThe pilot’s failure to maintain control of the airplane after a loss of engine power during a go-around. Contributing to the accident was the difficult-to-operate fuel selector valve and the pilot’s continued operation of the airplane with a known mechanical…Sep 6, 2012 · N1126V · Substantial damageNTSB CEN12CA526Accident · Minor injuriesData collectionFinal reportCessna 172R · Leesville, LAThe student pilot's failure to properly re-configure the airplane for a go-around, which resulted in a runway excursion when he decided to land on the remaining runway.Aug 3, 2012 · N989BT · Substantial damageNTSB CEN12LA417Accident · Serious injuriesLimited investigationFinal reportBadeaux Challenger II · New Iberia, LAThe operation of an airplane by a noncertificated pilot and his failure to maintain clearance with the power lines during the landing approach.Jun 29, 2012 · N16665 · Substantial damageNTSB CEN12LA015Accident · No injuriesLimited investigationFinal reportCessna 150L · Vidalia, LAA total loss of engine power likely due to carburetor ice.Oct 7, 2011 · N642EZ · Substantial damageNTSB CEN11CA580Accident · No injuriesData collectionFinal reportCessna 172N · Winnsboro, LAThe pilot's failure to maintain aircraft control during takeoff with a gusting crosswind.Aug 18, 2011 · N3209E · Substantial damageNTSB CEN11IA156Incident · No injuriesIncident investigationFinal reportSikorsky 92 · Galliano, LAThe misalignment of the retaining washer during routine maintenance, resulting in the subsequent separation of the washer and nut.Jan 19, 2011 · N920AL · Minor damageNTSB CEN10IA397Incident · No injuriesIncident investigationFinal reportBell 206 · Gulf of Mexico, LAImproper reassembly of the collective flight controls by maintenance personnel. Contributing to the incident were inadequate postmaintenance examinations by maintenance personnel and inadequate preflight inspections by two pilots.Jul 12, 2010 · N523RL · Minor damageNTSB CEN09LA255Accident · 1 fatalLimited investigationFinal reportWhitehead Titan · Slaughter, LAThe pilot's incorrect use of pitch control, resulting in induced pitch oscillations and loss of aircraft control. Contributing to the accident were the pilot's total lack of experience in aircraft make/model, and his lack of recency of experience.Apr 20, 2009 · N226BW · DestroyedNTSB CEN09CA151Accident · No injuriesData collectionFinal reportSchweizer G-164B · Ferriday, LAThe pilot's loss of control following an impact with birds.Feb 1, 2009 · N3628T · Substantial damageNTSB CEN09LA039Accident · Minor injuriesLimited investigationFinal reportChamberlin Victor Wayne Minimax · Winnsboro, LAThe pilot’s failure to maintain clearance from static wires while maneuvering to avoid another airplane.Oct 27, 2008 · N8637L · Substantial damageNTSB DFW08LA089Accident · No injuriesLimited investigationFinal reportPiper PA24-260 · Abbeville, LAThe failure of both pilots to see and avoid the other approaching airplane. A contributing factor was the close proximity between the two private airstrips.Mar 28, 2008 · N9097P · 2 aircraft · Substantial damageNTSB DFW08FA053Accident · 1 fatalField investigationFinal reportBell 206L1 · Venice, LAThe pilot’s decision to continue to the destination landing platform in weather conditions below the company’s weather minimums and his failure to maintain aircraft control during the approach. Contributing to the passenger fatality and the severity of the…Dec 29, 2007 · N211EL · DestroyedNTSB DFW07LA022Accident · No injuriesLimited investigationFinal reportCessna 152 · Monroe, LAThe failure of the second pilot to maintain separation from the preceding traffic established on final approach. A contributing factor was the failure by ATC personnel to visually identify and separate airplanes in the traffic pattern.Nov 7, 2006 · N94684 · 2 aircraft · Substantial damageNTSB DFW06CA190Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Woodworth, LAThe pilot's failure to maintain clearance from a tree. Contributing factors were the sudden wind shift and the gusty wind conditions.Jul 22, 2006 · N9952W · Substantial damageNTSB DFW06LA097Accident · Serious injuriesLimited investigationFinal reportRocket Flyers Turbine Legend · Hammond, LAThe reported loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Apr 7, 2006 · N724TL · Substantial damageNTSB DFW06CA089Accident · No injuriesData collectionFinal reportAero Commander AC50 · Shreveport, LAThe pilot's failure to execute a missed approach after losing visual contact with the runway, which resulted in a collision with approach lights. Factors were the dark night conditions and the fog.Mar 21, 2006 · N662MW · Substantial damage