# NTSB investigations, LA: Takeoff

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

Page 1 of 6 · 267 cases

## Latest cases

- [NTSB CEN26LA315](https://openairdocs.org/ntsb/CEN26LA315.md): Progressive Aerodyne Searey · DeQuincy, LA · Accident · No injuries · Class 4 · Limited · Final report · Sep 10, 2026 · N80515 · Substantial damage
  > The pilot’s failure to maintain directional control during takeoff after encountering a wind gust. Contributing to the accident was nearby convective activity.
- [NTSB ERA26FA291](https://openairdocs.org/ntsb/ERA26FA291.md): Beech H35 · Bogalusa, LA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Aug 6, 2026 · N5409D · Substantial damage
  > On August 6, 2026, about 1030 central daylight time, a Beech H35, N5409D, was destroyed when it was involved in an accident near Bogalusa, Louisiana. The private pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB CEN25LA233](https://openairdocs.org/ntsb/CEN25LA233.md): ICP Savannah S · Slaughter, LA · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 1, 2025 · N5000S · Substantial damage
  > On June 30, 2025, about 1932 central daylight time an I.C.P. Srl Savannah S light sport airplane, N5000S was substantially damaged when it was involved in an accident near Slaughter, LA. The pilot and passenger were not injured. The flight was operated under…
- [NTSB CEN25LA169](https://openairdocs.org/ntsb/CEN25LA169.md): Cessna 182P · Kentwood, LA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · May 3, 2025 · N9415M · Substantial damage
  > On May 3, 2025, about 1530 central daylight time, a Cessna 182P, N9415M, was substantially damaged when it was involved in an accident near Kentwood, Louisiana. The pilot sustained serious injuries, and the passenger sustained minor injuries. The airplane was…
- [NTSB CEN24LA194](https://openairdocs.org/ntsb/CEN24LA194.md): Lanni Charles T Skyranger II · Breaux Bridge, LA · Accident · Serious injuries · Class 4 · Limited · Final report · May 11, 2024 · N122LF · Substantial damage
  > The pilot’s decision to depart with the airplane over maximum gross weight, which reduced the climb performance and resulted in a collision with a tree.
- [NTSB CEN24LA172](https://openairdocs.org/ntsb/CEN24LA172.md): Bell 206B · Baton Rouge, LA · Accident · No injuries · Class 4 · Limited · Final report · Mar 26, 2024 · N67183 · Substantial damage
  > The pilot’s loss of control during takeoff that resulted in a hard landing.
- [NTSB DCA24LA330](https://openairdocs.org/ntsb/DCA24LA330.md): Boeing 737-8 · Kenner, LA · Incident · Class 2 · Limited · Final report · Dec 20, 2023 · N8830Q · Minor damage
  > A partial loss of engine power due to bird ingestion in the No. 1 (left) engine, which resulted in the activation of the load reduction device to prevent vibration. The load reduction device activation resulted in smoke and fumes entering the cockpit.
- [NTSB CEN24FA010](https://openairdocs.org/ntsb/CEN24FA010.md): Cessna 414 · Patterson, LA · Accident · 2 fatal · Class 3 · Field · Final report · Oct 12, 2023 · N880A · Destroyed
  > The pilot’s failure to properly set the elevator trim before takeoff, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall during takeoff.
- [NTSB CEN23FA071](https://openairdocs.org/ntsb/CEN23FA071.md): Bell 407 · Galliano, LA · Accident · 4 fatal · Class 3 · Field · Final report · Dec 29, 2022 · N595RL · Substantial damage
  > The pilot’s failure to ensure the helicopter was clear of obstacles before takeoff from the helideck, which resulted in the helicopter’s right landing skid pivoting about a helideck perimeter light during takeoff and a dynamic rollover. Additionally, the…
- [NTSB CEN22LA139](https://openairdocs.org/ntsb/CEN22LA139.md): Aeronca 7CCM · Winnsboro, LA · Accident · Serious injuries · Class 4 · Limited · Final report · Mar 4, 2022 · N555EK · Substantial damage
  > The pilot’s loss of airplane control during takeoff and subsequent impact with trees and terrain. Contributing to the accident was the pilot’s lack of experience in the accident airplane.
- [NTSB CEN21LA357](https://openairdocs.org/ntsb/CEN21LA357.md): Air Tractor AT-602 · Mer Rouge, LA · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 4, 2021 · N455LA · Substantial damage
  > The total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot and ground personnel’s miscalculation of available fuel.
- [NTSB CEN21LA284](https://openairdocs.org/ntsb/CEN21LA284.md): Robinson Helicopter R44 II · Reserve, LA · Accident · No injuries · Class 3 · Limited · Final report · Jun 10, 2021 · N202SM · Substantial damage
  > A total loss of engine power for undetermined reasons.
- [NTSB CEN21LA072](https://openairdocs.org/ntsb/CEN21LA072.md): Grumman G164 · Elton, LA · Accident · No injuries · Class 3 · Limited · Final report · Dec 1, 2020 · N48594 · Substantial damage
  > The loss of engine power, which resulted in a forced landing on unsuitable terrain. The reason for the loss of engine power could not be determined based on available evidence.
- [NTSB CEN20CA411](https://openairdocs.org/ntsb/CEN20CA411.md): Cessna R182 · Marksville, LA · Accident · Minor injuries · Class 4 · Data collection · Final report · Sep 17, 2020 · N6208T · Substantial damage
  > The pilot’s inadequate preflight inspection, during which he failed to ensure the landing gear handle in the “down” position which resulted in the landing gear retracting during takeoff, a loss of directional control, and a runway excursion.
- [NTSB CEN20LA199](https://openairdocs.org/ntsb/CEN20LA199.md): Piper PA28 · Pineville, LA · Accident · 2 fatal · Class 3 · Limited · Final report · May 31, 2020 · N6461J · Substantial damage
  > The airplane’s inability to gain sufficient airspeed after takeoff due to it being at or over its maximum gross weight, which resulted in a loss of control. Contributing to the accident was the pilot’s decision to operate the airplane at or over its maximum…
- [NTSB CEN20CA190](https://openairdocs.org/ntsb/CEN20CA190.md): Air Tractor AT502 · Bunkie, LA · Accident · Minor injuries · Class 4 · Data collection · Final report · May 23, 2020 · N571LA · Substantial damage
  > The pilot's failure to maintain directional control during takeoff.
- [NTSB CEN20CA153](https://openairdocs.org/ntsb/CEN20CA153.md): Air Tractor AT 602 · Mamou, LA · Accident · No injuries · Data collection · Final report · Apr 21, 2020 · N653LA · Substantial damage
  > The airplane's encounter with a sunken area during takeoff from a turf runway, which resulted in the airplane becoming prematurely airborne and impacting a tree and then terrain.
- [NTSB GAA19CA010](https://openairdocs.org/ntsb/GAA19CA010.md): Air Tractor AT 402 · Crowley, LA · Accident · No injuries · Data collection · Final report · Oct 8, 2018 · N1500E · Substantial damage
  > The pilot's selection of unsuitable terrain for takeoff, which resulted in a collision with vegetation and a subsequent loss of directional control.
- [NTSB CEN18LA285](https://openairdocs.org/ntsb/CEN18LA285.md): Smith AEROSTAR601 · Baton Rouge, LA · Accident · No injuries · Limited investigation · Final report · Jul 20, 2018 · N327BK · Substantial damage
  > The loss of right engine power due to fuel starvation, which resulted from corrosion debris in the fuel lines. Contributing to the accident was the mechanic’s and pilot’s inadequate maintenance of the airplane before the flight.
- [NTSB GAA18CA335](https://openairdocs.org/ntsb/GAA18CA335.md): Beech A36 · Gilliam, LA · Accident · No injuries · Data collection · Final report · Jun 6, 2018 · N710JT · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack during a soft-field takeoff, which resulted in an aerodynamic stall.
- [NTSB CEN17LA229](https://openairdocs.org/ntsb/CEN17LA229.md): Hughes 269C · Tallulah, LA · Accident · No injuries · Limited investigation · Final report · Jun 10, 2017 · N7482F · Substantial damage
  > The pilot's failure to reset the cyclic trim before takeoff, which resulted in ground resonance.
- [NTSB CEN17LA001](https://openairdocs.org/ntsb/CEN17LA001.md): Drake Kitfox Speedster · Jennings, LA · Accident · Serious injuries · Limited investigation · Final report · Oct 1, 2016 · N157D · Substantial damage
  > The pilot’s failure to maintain adequate airspeed during takeoff, which resulted in an exceedance of the airplane’s critical angle of attack and subsequent aerodynamic stall.
- [NTSB CEN16LA250](https://openairdocs.org/ntsb/CEN16LA250.md): Bellanca 7ECA · Oak Ridge, LA · Accident · No injuries · Limited investigation · Final report · Jul 4, 2016 · N87083 · Substantial damage
  > The pilot's failure to maintain airplane control during the aborted takeoff, which resulted in it becoming airborne momentarily and then over running the runway.
- [NTSB GAA16CA131](https://openairdocs.org/ntsb/GAA16CA131.md): Foxworthy Roy Christen Eagle · Bell City, LA · Accident · No injuries · Data collection · Final report · Feb 14, 2016 · N960RF · Substantial damage
  > The pilot's failure to maintain directional control during takeoff in gusty wind conditions, which resulted in a runway excursion and a nose over.
- [NTSB GAA15CA278](https://openairdocs.org/ntsb/GAA15CA278.md): Cessna 182A · Ama, LA · Accident · No injuries · Data collection · Final report · Sep 25, 2015 · N6361B · Substantial damage
  > The pilot's decision to takeoff on a partially obstructed runway, which resulted in a collision with trees.
- [NTSB CEN15LA301](https://openairdocs.org/ntsb/CEN15LA301.md): Piper PA 28-140 · Oakdale, LA · Accident · Serious injuries · Limited investigation · Final report · Jul 8, 2015 · N3949K · Substantial damage
  > The pilot's inadequate preflight planning resulting in the airplane not having adequate performance to climb and clear the trees off the end of the dirt runway.
- [NTSB CEN15FA278](https://openairdocs.org/ntsb/CEN15FA278.md): Cessna 172 · Shreveport, LA · Accident · 1 fatal · Field investigation · Final report · Jun 19, 2015 · N5743A · Substantial damage
  > The pilot's loss of airplane control during initial climb after takeoff for reasons that could not be determined because an examination of the airframe and engine did not reveal any preimpact anomalies.
- [NTSB CEN14CA528](https://openairdocs.org/ntsb/CEN14CA528.md): Cessna 182G · Port Eads, LA · Accident · Minor injuries · Data collection · Final report · Sep 28, 2014 · N2011R · Substantial damage
  > The pilot's improper decision to depart from a runway not suitable for takeoff, which resulted in a loss of aircraft control.
- [NTSB CEN14LA450](https://openairdocs.org/ntsb/CEN14LA450.md): Air Tractor AT-401 · Natchez, LA · Accident · No injuries · Limited investigation · Final report · Aug 24, 2014 · N91968 · Destroyed
  > The loss of power due to the failure of the No. 2 exhaust valve and rocker boss during takeoff.
- [NTSB CEN14LA251](https://openairdocs.org/ntsb/CEN14LA251.md): Smythe Donald F Kitfox Classic IV · Slaughter, LA · Accident · Serious injuries · Limited investigation · Final report · May 24, 2014 · N998DS · Substantial damage
  > The pilot’s inadequate preflight planning, which resulted in his attempt to takeoff in conditions under which the airplane was unable to attain a positive rate of climb and resulted in its failure to clear trees.
- [NTSB CEN14CA082](https://openairdocs.org/ntsb/CEN14CA082.md): Sikorsky S 76B · Port Fourchon, LA · Accident · No injuries · Data collection · Final report · Dec 5, 2013 · N707MY · Substantial damage
  > The pilot's loss of control of the helicopter when it entered a settling with power condition during sudden gusty wind conditions on takeoff resulting in the helicopter subsequently impacting terrain.
- [NTSB CEN12LA500](https://openairdocs.org/ntsb/CEN12LA500.md): Air Tractor AT-502B · Newellton, LA · Accident · No injuries · Limited investigation · Final report · Aug 1, 2012 · N5128U · Substantial damage
  > The pilot's inadequate takeoff planning and his use of an improper flap setting, which resulted in a runway excursion and collision with terrain during takeoff.
- [NTSB CEN11CA336](https://openairdocs.org/ntsb/CEN11CA336.md): Reed Roderick KB3 Gyroplane · Scott, LA · Accident · Serious injuries · Data collection · Final report · May 14, 2011 · UNREG · Substantial damage
  > The pilot's poor decision to takeoff with a tailwind which resulted in a runway excursion.
- [NTSB CEN11FA115](https://openairdocs.org/ntsb/CEN11FA115.md): Cessna 182C · Crowley, LA · Accident · 3 fatal · Field investigation · Final report · Dec 18, 2010 · N8556T · Substantial damage
  > A loss of engine power due to the magneto failure for undetermined reasons.
- [NTSB CEN10IA438](https://openairdocs.org/ntsb/CEN10IA438.md): Bell 206 · Gulf of Mexico, LA · Incident · No injuries · Incident investigation · Final report · Jul 26, 2010 · N317RL · Minor damage
  > The loss of main rotor rpm during takeoff for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies.
- [NTSB CEN10CA417](https://openairdocs.org/ntsb/CEN10CA417.md): Robinson Helicopter R44 II · Shreveport, LA · Accident · No injuries · Data collection · Final report · Jul 19, 2010 · N721BB · Substantial damage
  > The student pilot's failure to maintain control of the helicopter during takeoff, resulting in a loss of tail rotor effectiveness and a subsequent hard landing.
- [NTSB CEN09LA538](https://openairdocs.org/ntsb/CEN09LA538.md): Brown Joseph B JR RV-6 · Ama, LA · Accident · 2 fatal · Limited investigation · Final report · Aug 23, 2009 · N352JB · Substantial damage
  > The pilot’s failure to maintain directional control during takeoff.
- [NTSB CEN09LA299](https://openairdocs.org/ntsb/CEN09LA299.md): Northwing Apache Sport · Franklinton, LA · Accident · Serious injuries · Limited investigation · Final report · May 13, 2009 · N61740 · Substantial damage
  > The pilot's failure to maintain airspeed which resulted in a stall. Contributing to the accident was the pilot's lack of flight experience in the weight-shift trike.
- [NTSB DEN08CA099](https://openairdocs.org/ntsb/DEN08CA099.md): Piper Seneca · Plaquemine, LA · Accident · No injuries · Data collection · Final report · May 31, 2008 · N864CA · Substantial damage
  > The certified flight instructor's poor decision to simulate a loss of engine on takeoff with a wet runway and the pilot's failure to maintain directional control. Contributing to the accident was the dew covered runway surface and the ditch.
- [NTSB DFW08CA075](https://openairdocs.org/ntsb/DFW08CA075.md): Robinson R-22 · Meraux, LA · Accident · No injuries · Data collection · Final report · Mar 4, 2008 · N120KC · Substantial damage
  > The pilot's failure to ensure calculate weight and balance prior to flight. A contributing factor was the prevailing gusty winds.
- [NTSB DFW07LA120](https://openairdocs.org/ntsb/DFW07LA120.md): Cessna U206G · Leeville, LA · Accident · 1 fatal · Limited investigation · Final report · May 24, 2007 · N45WT · Substantial damage
  > The failure of the operator of the powerboat to maintain separation from the departing floatplane.
- [NTSB DFW06CA066](https://openairdocs.org/ntsb/DFW06CA066.md): Robinson R44 · Rayville, LA · Accident · No injuries · Data collection · Final report · Feb 4, 2006 · N744MD · Substantial damage
  > The pilot's failure to maintain rotor RPM, which resulted in a hard landing.
- [NTSB DFW06CA016](https://openairdocs.org/ntsb/DFW06CA016.md): Cessna 210L · Baker, LA · Accident · No injuries · Data collection · Final report · Oct 26, 2005 · N59051 · Substantial damage
  > The pilot's failure to maintain clearance during takeoff roll.
- [NTSB DFW05CA216](https://openairdocs.org/ntsb/DFW05CA216.md): Cessna A188B · Winnsboro, LA · Accident · No injuries · Data collection · Final report · Aug 15, 2005 · N4952Q · Substantial damage
  > The pilot's failure to maintain directional control during the take-off roll.
- [NTSB DFW05CA191](https://openairdocs.org/ntsb/DFW05CA191.md): Air Tractor AT-502B · Gassoway, LA · Accident · No injuries · Data collection · Final report · Jul 23, 2005 · N50075 · Substantial damage
  > The pilot's premature lift-off which resulted in an inadequate climb for terrain clearance. Also causal was the pilot's failure to abort the takeoff. A contributing factor was the high density altitude.
- [NTSB DFW05LA074](https://openairdocs.org/ntsb/DFW05LA074.md): Bell 206L-3 · Cameron, LA · Accident · No injuries · Limited investigation · Final report · Feb 18, 2005 · N512RA · Substantial damage
  > Fuel starvation due to a blocked and collapsed fuel nozzle screen, resulting from a contaminated fuel source/facility. Factors were the inadequate maintenance/inspection of fuel sources, and the lack of suitable terrain (high sea state) for the forced landing…
- [NTSB CHI03FA259](https://openairdocs.org/ntsb/CHI03FA259.md): Bell 206L-3 · E.I. 276, LA · Accident · 3 fatal · Field investigation · Final report · Aug 13, 2003 · N41128 · Substantial damage
  > The inadequate compensation for crosswind conditions and the directional control not obtained/maintained by the pilot during takeoff. Contributing factors were the crosswind and the planned approach to position the helicopter with a crosswind in order to…
- [NTSB FTW03LA166](https://openairdocs.org/ntsb/FTW03LA166.md): Bell 47G-2 · Franklinton, LA · Accident · Minor injuries · Limited investigation · Final report · Jun 4, 2003 · N90485 · Substantial damage
  > The pilot's encounter with dynamic rollover due to his failure to properly remove the tie-down strap on the right skid prior to takeoff. Factors were the pilot's inadequate preflight preparation and failure to abort takeoff.
- [NTSB FTW03LA136](https://openairdocs.org/ntsb/FTW03LA136.md): Air Tractor AT-301 · Batchelor, LA · Accident · No injuries · Limited investigation · Final report · Apr 18, 2003 · N36531 · Substantial damage
  > The pilot's failure to abort the takeoff with adequate runway available. A contributing factor was the high density altitude.
- [NTSB FTW02LA231](https://openairdocs.org/ntsb/FTW02LA231.md): Page Rans S-7 · Welsh, LA · Accident · Minor injuries · Limited investigation · Final report · Aug 6, 2002 · N497RP · Substantial damage
  > the pilot's failure to maintain the minimum required airspeed for flight, which resulted in an inadvertent stall.

Next page: https://openairdocs.org/ntsb-phases/300/cases.md?state=LA&page=2

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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 = 300)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/300/cases?state=LA

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.