# NTSB investigations, IN: Initial climb

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 8 · 370 cases

## Latest cases

- [NTSB CEN25LA382](https://openairdocs.org/ntsb/CEN25LA382.md): Beech C23 · South Bend, IN · Accident · No injuries · Class 4 · Limited · Final report · Sep 10, 2025 · N997V · Substantial damage
  > The pilot’s failure to maintain control of the airplane during a go around which resulted in an aerodynamic stall. Contributing to the accident was the loss of directional control during the landing roll.
- [NTSB CEN25FA296](https://openairdocs.org/ntsb/CEN25FA296.md): Helms Richard Lancair IVP · Greenwood, IN · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 30, 2025 · N49BX · Destroyed
  > On July 30, 2025, at 1046 eastern daylight time, a Lancair IVP airplane, N49BX, was destroyed when it was involved in an accident near Greenwood, Indiana. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part…
- [NTSB CEN24FA045](https://openairdocs.org/ntsb/CEN24FA045.md): Cirrus Design SR22T · Fairland, IN · Accident · 2 fatal · Class 3 · Field · Final report · Nov 22, 2023 · N17DT · Destroyed
  > Both pilots’ failure to maintain adequate airspeed during departure from the airport, which led to the airplane exceeding its critical angle of attack, entering an aerodynamic stall, and impacting terrain.
- [NTSB CEN23LA384](https://openairdocs.org/ntsb/CEN23LA384.md): Piper PA-44-180 · West Lafayette, IN · Accident · No injuries · Class 4 · Limited · Final report · Aug 26, 2023 · N767PA · Substantial damage
  > An in-flight collision with a bird during initial climb.
- [NTSB CEN23LA381](https://openairdocs.org/ntsb/CEN23LA381.md): George Stone KIT FOX Model 3 · Scottsburg, IN · Accident · Serious injuries · Class 4 · Limited · Final report · Aug 1, 2023 · N815US · Substantial damage
  > The student pilot’s failure to maintain airplane control after takeoff that resulted in an impact with terrain.
- [NTSB CEN23LA119](https://openairdocs.org/ntsb/CEN23LA119.md): Piper PA-28-140 · Martinsville, IN · Accident · No injuries · Class 4 · Limited · Final report · Feb 23, 2023 · N1700T · Substantial damage
  > The pilot’s inadequate weather evaluation and failure to abort the takeoff that resulted in an impact with terrain.
- [NTSB CEN23FA045](https://openairdocs.org/ntsb/CEN23FA045.md): Cirrus Design SF50 · Mount Comfort, IN · Accident · No injuries · Class 3 · Field · Final report · Nov 25, 2022 · N15VJ · Substantial damage
  > The uncommanded activation of the CAPS autopilot mode due to corrosion of the system’s electrical components. Contributing to the accident was the pilot’s failure to identify the CAPS autopilot mode and promptly follow the procedures in the airplane flight…
- [NTSB CEN22LA349](https://openairdocs.org/ntsb/CEN22LA349.md): Schweizer G-164B · Knox, IN · Accident · No injuries · Class 3 · Limited · Final report · Jul 26, 2022 · N629EH · Substantial damage
  > A partial loss of engine power for undetermined reasons.
- [NTSB CEN21LA400](https://openairdocs.org/ntsb/CEN21LA400.md): Luscombe 8A · Fort Wayne, IN · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 4, 2021 · N2071K · Substantial damage
  > The total loss of engine power after takeoff due to the formation of carburetor ice while on the ground and the pilot’s failure to apply carburetor heat immediately before takeoff.
- [NTSB CEN21LA200](https://openairdocs.org/ntsb/CEN21LA200.md): Aeropro CZ S R O A240 · Richmond, IN · Accident · 1 fatal · Class 3 · Limited · Final report · Apr 25, 2021 · N417R · Destroyed
  > The noninstrument-rated pilot’s intentional flight into instrument meteorological conditions, which resulted in spatial disorientation and loss of airplane control.
- [NTSB CEN21LA194](https://openairdocs.org/ntsb/CEN21LA194.md): Cessna A185F · North Vernon, IN · Accident · No injuries · Class 3 · Limited · Final report · Apr 17, 2021 · N19D · Substantial damage
  > The pilot’s improper installation of the fuel selector handle, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB CEN20LA304](https://openairdocs.org/ntsb/CEN20LA304.md): Brantly B2B · Monrovia, IN · Accident · 1 fatal · Class 3 · Limited · Final report · Jul 24, 2020 · N383ES · Destroyed
  > The pilot’s loss of control after takeoff for reasons that could not be determined based on the available information.
- [NTSB CEN19FA148](https://openairdocs.org/ntsb/CEN19FA148.md): Cessna S550 · Greenfield, IN · Accident · 2 fatal · Class 2 · Field · Final report · May 22, 2019 · N311G · Destroyed
  > The pilot's failure to fully advance the power levers during the takeoff and initial climb, which led to his failure to maintain sufficient airspeed and resulted in the exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall.
- [NTSB CEN19FA135](https://openairdocs.org/ntsb/CEN19FA135.md): Piper PA34 · Anderson, IN · Accident · Serious injuries · Class 2 · Field · Final report · May 5, 2019 · N999CR · Substantial damage
  > The loss of left engine power due to an incorrectly adjusted fuel servo and the airplane's nose up trim which resulted in the airplane steep climb, loss of airspeed, and aerodynamic stall and subsequent impact with terrain.
- [NTSB CEN19FA044](https://openairdocs.org/ntsb/CEN19FA044.md): Piper PA24 · Valparaiso, IN · Accident · 1 fatal · Field investigation · Final report · Dec 13, 2018 · N6785P · Destroyed
  > The pilot's failure to maintain adequate airspeed during the initial climb after takeoff, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall and spin.
- [NTSB CEN19FA036](https://openairdocs.org/ntsb/CEN19FA036.md): Cessna 525 · Memphis, IN · Accident · 3 fatal · Class 3 · Field · Final report · Nov 30, 2018 · N525EG · Destroyed
  > The pilot’s inability to regain airplane control after a left roll that began for reasons that could not be determined based on the available evidence.
- [NTSB CEN19FA035](https://openairdocs.org/ntsb/CEN19FA035.md): Piper PA 30 · Marion, IN · Accident · 1 fatal · Field investigation · Final report · Nov 29, 2018 · N7751Y · Destroyed
  > The pilot's exceedance of the airplane's critical angle of attack following a loss of the left engine power shortly after takeoff, which resulted in an aerodynamic stall at an altitude too low for recovery. Contributing to the accident was the loss of left…
- [NTSB CEN17FA334](https://openairdocs.org/ntsb/CEN17FA334.md): Vans RV-12 · Fishers, IN · Accident · 1 fatal · Field investigation · Final report · Aug 31, 2017 · N212ZF · Destroyed
  > The pilot's failure to latch the canopy before takeoff, and his failure to maintain pitch control following the in-flight opening of the canopy during the initial climb resulting in a subsequent impact with terrain and ground fire.
- [NTSB CEN17LA318](https://openairdocs.org/ntsb/CEN17LA318.md): Knapp Easy Raider · Rochester, IN · Accident · Minor injuries · Limited investigation · Final report · Aug 14, 2017 · N6862K · Substantial damage
  > A partial 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.
- [NTSB CEN16LA300](https://openairdocs.org/ntsb/CEN16LA300.md): Wings AN Things Avid Flyer · Bluffton, IN · Accident · Serious injuries · Limited investigation · Final report · Aug 3, 2016 · N430WT · Substantial damage
  > The loss of roll control during climb for reasons that could not be determined because postaccident examination of the airframe revealed no evidence of mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB CEN16FA220](https://openairdocs.org/ntsb/CEN16FA220.md): Piper PA-38-112 · Madison, IN · Accident · 1 fatal · Field investigation · Final report · Jun 16, 2016 · N2412D · Substantial damage
  > The pilot’s failure to maintain a proper climb rate after takeoff and the subsequent collision with transmission line structures.
- [NTSB CEN16FA216](https://openairdocs.org/ntsb/CEN16FA216.md): Cessna 150F · Rockville, IN · Accident · 2 fatal · Field investigation · Final report · Jun 13, 2016 · N102DK · Destroyed
  > The pilot's use of an improper soft-field takeoff procedure, which resulted in the airplane having insufficient airspeed to climb out of ground effect and its subsequent impact with trees near the departure end of the runway.
- [NTSB GAA16LA329](https://openairdocs.org/ntsb/GAA16LA329.md): Mini Max 1200 · Batesville, IN · Accident · Serious injuries · Limited investigation · Final report · Jun 8, 2016 · UNREG · Substantial damage
  > The pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's decision to depart without obtaining flight training in the…
- [NTSB CEN15LA451](https://openairdocs.org/ntsb/CEN15LA451.md): Cessna 150L · Carthage, IN · Accident · No injuries · Limited investigation · Final report · Jun 20, 2015 · N17292 · Substantial damage
  > The partial loss of engine power due to carburetor icing.
- [NTSB CEN13LA455](https://openairdocs.org/ntsb/CEN13LA455.md): Piper PA-28-140 · Lafayette, IN · Accident · Serious injuries · Limited investigation · Final report · Jul 28, 2013 · N286P · Substantial damage
  > The pilot’s failure to maintain adequate airspeed in gusting wind conditions during the initial climb after takeoff, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.
- [NTSB CEN13CA033](https://openairdocs.org/ntsb/CEN13CA033.md): Porter James Grant Superior CUB · Beechgrove, IN · Accident · Serious injuries · Data collection · Final report · Oct 27, 2012 · N97RP · Substantial damage
  > The pilot’s failure to maintain clearance from trees during takeoff from a short field.
- [NTSB CEN12LA651](https://openairdocs.org/ntsb/CEN12LA651.md): Piper PA-28-140 · Boonville, IN · Accident · No injuries · Limited investigation · Final report · Sep 10, 2012 · N5538F · Substantial damage
  > A total loss of engine power during initial climb due to fuel starvation for reasons that could not be determined because postaccident examination could not verify whether the fuel selector was properly positioned before takeoff.
- [NTSB CEN12LA407](https://openairdocs.org/ntsb/CEN12LA407.md): Fields Mike Hawk SSC · Evansville, IN · Accident · Serious injuries · Limited investigation · Final report · Jun 29, 2012 · N163F · Substantial damage
  > The operation of an airplane by a non-certificated pilot, and the pilot's loss of control during takeoff, which resulted in an inadvertent stall and spin.
- [NTSB CEN12LA404](https://openairdocs.org/ntsb/CEN12LA404.md): Destiny 2000 · Shelbyville, IN · Accident · Serious injuries · Limited investigation · Final report · Jun 24, 2012 · UNREG · Substantial damage
  > The operation of the aircraft by a non-certificated pilot and his failure to plan for the high density altitude and to maintain control of the aircraft.
- [NTSB CEN11CA002](https://openairdocs.org/ntsb/CEN11CA002.md): Gingerich Alton & Slagel Dean Christavia MK 1 · Nappanee, IN · Accident · No injuries · Data collection · Final report · Oct 1, 2010 · N9049S · Substantial damage
  > The total loss of engine power for undetermined reasons.
- [NTSB CEN10CA441](https://openairdocs.org/ntsb/CEN10CA441.md): Wolseley Motors SE5-A · Seymour, IN · Accident · Minor injuries · Data collection · Final report · Jul 27, 2010 · N93725 · Substantial damage
  > A loss of engine power during initial climb due to fuel exhaustion. Contributing to the accident was the pilot's diverted attention while attempting to restart the engine.
- [NTSB CEN09CA498](https://openairdocs.org/ntsb/CEN09CA498.md): Rans Employee Flying Club Rans S-6S · Montezuma, IN · Accident · Minor injuries · Data collection · Final report · Jul 31, 2009 · N91226 · Substantial damage
  > The pilot's failure to maintain aircraft control after takeoff resulting in an impact with a power line and the ground.
- [NTSB CEN09CA371](https://openairdocs.org/ntsb/CEN09CA371.md): Buckeye Dream Mach · Marian, IN · Accident · Serious injuries · Data collection · Final report · Jun 23, 2009 · N2526J · Substantial damage
  > The pilot's failure to maintain clearance with the utility pole and power lines.
- [NTSB CEN09CA418](https://openairdocs.org/ntsb/CEN09CA418.md): Cessna 550 · Sellersburg, IN · Accident · No injuries · Data collection · Final report · Jun 5, 2009 · N73HH · Substantial damage
  > An in-flight collision with a large bird during the airplane's initial climb.
- [NTSB CEN09LA196](https://openairdocs.org/ntsb/CEN09LA196.md): Fritz RV3-A · Greencastle, IN · Accident · 1 fatal · Limited investigation · Final report · Mar 7, 2009 · N933WF · Substantial damage
  > A partial loss of engine power for undetermined reasons and the pilot's failure to maintain aircraft control during the emergency descent.
- [NTSB CHI08LA052](https://openairdocs.org/ntsb/CHI08LA052.md): Levick RAF-2000-GTX-SE · Salem, IN · Accident · Serious injuries · Limited investigation · Final report · Dec 14, 2007 · N24DN · Destroyed
  > The pilot's failure to maintain control of the gyroplane during climbout after takeoff.
- [NTSB CHI07LA287](https://openairdocs.org/ntsb/CHI07LA287.md): Mooney M20K · Fort Wayne, IN · Accident · No injuries · Limited investigation · Final report · Aug 31, 2007 · N231BQ · Substantial damage
  > A total loss of engine power due to the fatigue failure of one of the number two cylinder connecting rod bolts.
- [NTSB CHI07CA262](https://openairdocs.org/ntsb/CHI07CA262.md): Beech BE-77 · Bloomington, IN · Accident · No injuries · Data collection · Final report · Aug 8, 2007 · N1837Y · Substantial damage
  > The loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight.
- [NTSB CHI07CA152](https://openairdocs.org/ntsb/CHI07CA152.md): Cessna 421C · Kokomo, IN · Accident · No injuries · Data collection · Final report · May 22, 2007 · N85SC · Substantial damage
  > The pilot not obtaining proper alignment with the runway during the emergency landing after takeoff, which imparted an excessive side load on the landing gear. Factors contributing to the accident were the unstabilized approach and engine shutdown due to the…
- [NTSB CHI07CA139](https://openairdocs.org/ntsb/CHI07CA139.md): Cessna 150 · English, IN · Accident · No injuries · Data collection · Final report · May 15, 2007 · N7772E · Substantial damage
  > The pilot's inadequate preflight planning due to his decision to takeoff downwind, and his subsequent failure to maintain adequate clearance from the power line. Contributing factors to the accident were the power line and the trees.
- [NTSB CHI05FA081](https://openairdocs.org/ntsb/CHI05FA081.md): Piper PA-28R-200 · West Lafayette, IN · Accident · 2 fatal · Field investigation · Final report · Mar 26, 2005 · N999SK · Destroyed
  > The pilot's inadvertent flight into instrument conditions and his not maintaining control of the complex airplane during initial climb. Factors in the accident were the low ceiling, the early dawn condition, and the pilots intentional unauthorized use of the…
- [NTSB CHI04CA229](https://openairdocs.org/ntsb/CHI04CA229.md): Bell 47G2 · Muncie, IN · Accident · No injuries · Data collection · Final report · Aug 14, 2004 · N96MB · Destroyed
  > The engine failure for an undetermined reason, and the pilot's inability to properly level-off for landing due to the low rotor speed, which resulted in the hard landing. The low altitude where the engine failure occurred was a factor.
- [NTSB CHI04LA103](https://openairdocs.org/ntsb/CHI04LA103.md): Cessna 150M · Marion, IN · Accident · Minor injuries · Limited investigation · Final report · Apr 9, 2004 · N6160K · Substantial damage
  > The pilot's inadequate preflight planning/decision to ensure adequate takeoff performance by the improper use of flaps and failure to establish the aircraft was within weight and balance limitations.
- [NTSB CHI04LA032](https://openairdocs.org/ntsb/CHI04LA032.md): Hughes TH-55A · West Lafayette, IN · Accident · Serious injuries · Limited investigation · Final report · Nov 18, 2003 · N9240D · Substantial damage
  > The fractured cluster fitting resulting in a loss of directional control during initial climb and the improper repair of cluster fitting by unknown personnel. The night conditions were a contributing factor.
- [NTSB CHI04LA006](https://openairdocs.org/ntsb/CHI04LA006.md): Piper J-3 · Florence, IN · Accident · No injuries · Limited investigation · Final report · Oct 8, 2003 · N71027 · Substantial damage
  > The pilot prematurely lifted off during the takeoff with inadequate airspeed which resulted in the airplane stalling. Factors associated with the accident were there unsuitable/rough terrain that the pilot used for takeoff.
- [NTSB CHI03LA268](https://openairdocs.org/ntsb/CHI03LA268.md): Piper J3C-65 · Tocsin, IN · Accident · No injuries · Limited investigation · Final report · Aug 19, 2003 · N37923 · Destroyed
  > The pilot attempting the low altitude turn and his failure to maintain clearance from the corn crop. A factor to the accident was the corn crop.
- [NTSB CHI03LA020](https://openairdocs.org/ntsb/CHI03LA020.md): Cessna 182N · Wheatfield, IN · Accident · Minor injuries · Limited investigation · Final report · Nov 9, 2002 · N253R · Substantial damage
  > The pilot not maintaining aircraft control and the pilot's inadequate compensation for the gusting wind condition. Factors to the accident were the gusting wind condition and the inadvertent stall at a low altitude.
- [NTSB CHI02LA190](https://openairdocs.org/ntsb/CHI02LA190.md): Cessna 150F · Ft. Wayne, IN · Accident · No injuries · Limited investigation · Final report · Jul 10, 2002 · N8798S · Substantial damage
  > The corroded throttle cable resulting in a loss of engine power. Factors were the inadequate annual inspection, the unsuitable terrain encountered during the forced landing, the ditch, and the fence.
- [NTSB CHI02LA109](https://openairdocs.org/ntsb/CHI02LA109.md): Piper PA-32RT-300T · Valparaiso, IN · Accident · Serious injuries · Limited investigation · Final report · Apr 19, 2002 · N3034A · Substantial damage
  > The pilot not maintaining aircraft control while encountering windshear during initial climbout, resulting in a stall at a low altitude.
- [NTSB CHI01LA328](https://openairdocs.org/ntsb/CHI01LA328.md): Cessna 150H · Lebanon, IN · Accident · Minor injuries · Limited investigation · Final report · Sep 23, 2001 · N6609S · Substantial damage
  > The unsuitable terrain for landing encountered by the pilot. Factors were the carburetor icing conditions, the carburetor ice, and the bean crop.

Next page: https://openairdocs.org/ntsb-phases/350/cases.md?state=IN&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" = 'IN' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 350)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

---
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.
