# NTSB investigations, IN: Maneuvering

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 5 · 226 cases

## Latest cases

- [NTSB CEN26LA106](https://openairdocs.org/ntsb/CEN26LA106.md): Cessna 172 · Lafayette, IN · Accident · No injuries · Class 4 · Limited · Final report · Jan 28, 2026 · N51204 · Substantial damage
  > The flight instructor's inadequate supervision of the student during a stall recovery that developed into unusual attitude and exceedance of the airplane’s never exceed airspeed which resulted in structural damage to the airplane.
- [NTSB CEN25LA323](https://openairdocs.org/ntsb/CEN25LA323.md): Grumman American Avn. G-164B · Fowler, IN · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 15, 2025 · N7015N · Substantial damage
  > On August 15, 2025, about 1910 eastern daylight time, a Grumman American Avn. Corp. G-164-B airplane, N7015N, was substantially damaged when it was involved in an accident near Fowler, Indiana. The pilot was not injured. The airplane was operated under Title…
- [NTSB CEN24FA278](https://openairdocs.org/ntsb/CEN24FA278.md): Air Tractor AT-602 · Oxford, IN · Accident · 1 fatal · Class 3 · Field · Final report · Jul 22, 2024 · N602WR · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack and failure to maintain adequate airspeed while maneuvering during an agricultural flight, which resulted in an aerodynamic stall and a loss of control at too low of an altitude to recover.…
- [NTSB CEN24LA209](https://openairdocs.org/ntsb/CEN24LA209.md): Arbc Inc DBA Lindstrand 90A · Hebron, IN · Accident · Serious injuries · Class 4 · Limited · Final report · Jun 2, 2024 · N8005H · Substantial damage
  > The pilot’s failure to maintain clearance from powerlines while landing in a field.
- [NTSB CEN23LA247](https://openairdocs.org/ntsb/CEN23LA247.md): Robinson Helicopter R22 Beta · Cedar Lake, IN · Accident · No injuries · Class 3 · Limited · Final report · Jun 19, 2023 · N4076H · Substantial damage
  > The failure of the flight instructor to attain/maintain aircraft control while maneuvering, which resulted in an uncontrolled descent and impact with the lake.
- [NTSB CEN23LA093](https://openairdocs.org/ntsb/CEN23LA093.md): Cirrus Design SR20 · Indianapolis, IN · Accident · 1 fatal · Class 4 · Limited · Final report · Jan 24, 2023 · N99EC · Destroyed
  > The pilot’s intentional flight into terrain as an act of suicide.
- [NTSB CEN21LA356](https://openairdocs.org/ntsb/CEN21LA356.md): Bell 206 · Corydon, IN · Accident · Serious injuries · Class 4 · Limited · Final report · Aug 4, 2021 · N59552 · Substantial damage
  > The pilot’s failure to see and avoid power lines.
- [NTSB CEN21LA318](https://openairdocs.org/ntsb/CEN21LA318.md): Air Tractor AT-602 · Nappanee, IN · Accident · No injuries · Class 4 · Limited · Final report · Jul 6, 2021 · N602RE · Substantial damage
  > The pilot’s failure to maintain clearance from the tower during low-level agricultural operations.
- [NTSB CEN21FA252](https://openairdocs.org/ntsb/CEN21FA252.md): Diamond Aircraft Ind DA 40 NG · Darlington, IN · Accident · 2 fatal · Class 3 · Field · Final report · Jun 6, 2021 · N853L · Destroyed
  > A loss of control while practicing an aerodynamic stall, which resulted in a spin and impact with terrain.
- [NTSB CEN21LA124](https://openairdocs.org/ntsb/CEN21LA124.md): Hiller UH12C · Lafayette, IN · Accident · No injuries · Class 4 · Limited · Final report · Jan 12, 2021 · N552DR · Substantial damage
  > The pilot’s failure to maintain control of the helicopter shortly after liftoff into a hover, which resulted in a dynamic rollover when the left landing skid contacted the ground.
- [NTSB CEN21LA008](https://openairdocs.org/ntsb/CEN21LA008.md): Stephens William E Quicksilver MXL-2 Sport · Mount Vernon, IN · Accident · 2 fatal · Class 3 · Limited · Final report · Oct 6, 2020 · N2942A · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack during an aerobatic maneuver, which resulted in an aerodynamic stall and spin and loss of control. Contributing to the accident was the pilot’s decision to perform aerobatic maneuvers in an…
- [NTSB CEN20LA407](https://openairdocs.org/ntsb/CEN20LA407.md): Quicksilver MX II · Marengo, IN · Accident · Serious injuries · Class 3 · Limited · Final report · Sep 21, 2020 · UNREG · Substantial damage
  > A loss of engine power due to carburetor icing. Contributing to the accident was the pilot’s decision to operate the airplane in conditions conducive to carburetor icing without a carburetor heating system, contrary to the engine manufacturer’s guidance.
- [NTSB CEN20CA310](https://openairdocs.org/ntsb/CEN20CA310.md): Champion 7GCBC · Angola, IN · Accident · Minor injuries · Class 4 · Data collection · Final report · Jul 25, 2020 · N86614 · Substantial damage
  > The pilot's failure to maintain control of the airplane during a low-level pass, resulting in the airplane exceeding its critical angle of attack that caused an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the pilot's…
- [NTSB CEN20LA214](https://openairdocs.org/ntsb/CEN20LA214.md): Cessna 172 · New Washington, IN · Accident · 1 fatal · Class 3 · Limited · Final report · Jun 6, 2020 · N13520 · Destroyed
  > A high velocity descent and impact with terrain for undetermined reasons.
- [NTSB CEN20CA180](https://openairdocs.org/ntsb/CEN20CA180.md): Rotorway Exec · Rochester, IN · Accident · Minor injuries · Class 4 · Data collection · Final report · May 16, 2020 · N311RM · Substantial damage
  > The pilot's failure to maintain control of the helicopter during lift off. Contributing to the accident was the pilot's lack of recent experience flying a helicopter.
- [NTSB GAA20CA063](https://openairdocs.org/ntsb/GAA20CA063.md): Sikorsky S 58JT · Lebanon, IN · Accident · Minor injuries · Data collection · Final report · Nov 10, 2019 · N827MW · Substantial damage
  > The pilot's failure to maintain proper clearance from a tractor trailer during landing.
- [NTSB CEN20FA002](https://openairdocs.org/ntsb/CEN20FA002.md): Piper Aerostar 602P · Kokomo, IN · Accident · 1 fatal · Class 3 · Field · Final report · Oct 5, 2019 · N326CW · Destroyed
  > The pilot's exceedance of the airplane’s critical angle of attack following a dual engine power loss caused by the line service technician fueling the airplane with the wrong fuel, which resulted in an aerodynamic stall and subsequent loss of control.…
- [NTSB CEN19LA309](https://openairdocs.org/ntsb/CEN19LA309.md): Bell 206 · Walkerton, IN · Accident · No injuries · Class 3 · Limited · Final report · Sep 9, 2019 · N19TV · Substantial damage
  > The partial loss of engine power due to fuel contamination.
- [NTSB CEN19LA225](https://openairdocs.org/ntsb/CEN19LA225.md): Cessna T188 · Knox, IN · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 14, 2019 · N2863J · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall and loss of airplane control.
- [NTSB CEN19FA195](https://openairdocs.org/ntsb/CEN19FA195.md): Rans S12 · Orleans, IN · Accident · 1 fatal · Class 2 · Field · Final report · Jul 1, 2019 · N1094K · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack while maneuvering toward the runway, which resulted in an aerodynamic stall and a loss of control.
- [NTSB CEN18LA269](https://openairdocs.org/ntsb/CEN18LA269.md): Bell 47J · Franklin, IN · Accident · Serious injuries · Limited investigation · Final report · Jul 15, 2018 · N8568F · Destroyed
  > A total loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB CEN18FA258](https://openairdocs.org/ntsb/CEN18FA258.md): Bell 47G · Arlington, IN · Accident · 1 fatal · Field investigation · Final report · Jul 6, 2018 · N96195 · Substantial damage
  > The inflight separation of the upper transmission due to the thread failure of transmission housing attachment bolts, which were installed on the helicopter with thread damage from a prior installation.
- [NTSB CEN18FA088](https://openairdocs.org/ntsb/CEN18FA088.md): Cessna 172F · Williamsport, IN · Accident · 1 fatal · Field investigation · Final report · Jan 27, 2018 · N8559U · Destroyed
  > The pilot's mismanagement of fuel, which resulted in fuel exhaustion and descent and collision with trees.
- [NTSB CEN17LA375](https://openairdocs.org/ntsb/CEN17LA375.md): Hiller UH 12A · Griffith, IN · Accident · No injuries · Limited investigation · Final report · Sep 11, 2017 · N2686 · Substantial damage
  > The loss of tail rotor thrust due to a failed tail rotor driveshaft, which resulted in a loss of tail rotor control and a hard landing.
- [NTSB CEN17LA267](https://openairdocs.org/ntsb/CEN17LA267.md): Robinson Helicopter R44 · Ireland, IN · Accident · Serious injuries · Limited investigation · Final report · Jul 8, 2017 · N7224U · Destroyed
  > The pilot's failure to apply the proper procedures to recover from a loss of tail rotor effectiveness, which resulted in a loss of control during an aerial application turn.
- [NTSB GAA17CA401](https://openairdocs.org/ntsb/GAA17CA401.md): Robinson Helicopter R44 · Paoli, IN · Accident · No injuries · Data collection · Final report · Jul 7, 2017 · N3203D · Substantial damage
  > The pilot's decision to maneuver an overgross weight helicopter at a low altitude and airspeed with a gusting tailwind, which resulted in a high descent rate and collision with terrain. Contributing to the accident was the pilot's self-induced pressure to…
- [NTSB CEN17FA127](https://openairdocs.org/ntsb/CEN17FA127.md): Mcdonnell Douglas Heli 369FF · Chalmers, IN · Accident · 1 fatal · Field investigation · Final report · Mar 14, 2017 · N530KD · Destroyed
  > The pilot's failure to ensure that the needle did not entangle with the tower's vertical lattice as he moved the helicopter rearward, which resulted in the helicopter becoming tethered to the tower and a subsequent loss of control.
- [NTSB CEN15CA293](https://openairdocs.org/ntsb/CEN15CA293.md): Cessna A188B · Crawfordsville, IN · Accident · Serious injuries · Data collection · Final report · Jul 5, 2015 · N625EH · Substantial damage
  > The pilot's failure to maintain clearance from the powerline during an aerial application operations.
- [NTSB CEN15FA194](https://openairdocs.org/ntsb/CEN15FA194.md): S C Aerostar S A YAK 52TW · Advance, IN · Accident · 1 fatal · Field investigation · Final report · Apr 3, 2015 · N555GD · Destroyed
  > The pilot’s loss of airplane control while maneuvering for reasons that could not be determined because an examination of the airframe and engine did not reveal any preimpact abnormalities.
- [NTSB CEN15LA106](https://openairdocs.org/ntsb/CEN15LA106.md): Diamond Aircraft Ind DA 20 C1 · Shipshewana, IN · Accident · No injuries · Limited investigation · Final report · Jan 19, 2015 · N979DC · Substantial damage
  > The total loss of engine power due to impact ice obstructing the primary air induction system, which resulted from the student pilot’s failure to operate the alternate air control. Contributing to the accident was the student pilot’s lack of knowledge about…
- [NTSB CEN15LA098](https://openairdocs.org/ntsb/CEN15LA098.md): Raytheon A36 · Parker City, IN · Accident · Serious injuries · Limited investigation · Final report · Jan 4, 2015 · N349EA · Substantial damage
  > The pilot’s loss of airplane control while troubleshooting an engine issue in instrument meteorological conditions, which resulted in impact with trees and terrain.
- [NTSB CEN15LA026](https://openairdocs.org/ntsb/CEN15LA026.md): Stephenson Stol CH 701 · Mount Vernon, IN · Accident · 1 fatal · Limited investigation · Final report · Oct 24, 2014 · N34WS · Substantial damage
  > The pilot’s impairment due to the ingestion of alcohol and sedating medications, which led to her improper decision to conduct low-level flight, affected her ability to safety operate the airplane, and resulted in her failure to maintain clearance from power…
- [NTSB CEN14LA243](https://openairdocs.org/ntsb/CEN14LA243.md): Hoffius Stowe Challenger II · Attica, IN · Accident · 1 fatal · Limited investigation · Final report · May 10, 2014 · N824SH · Substantial damage
  > The pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack while maneuvering at low altitude, which led to an aerodynamic stall and loss of control. Contributing to the accident was the installation of an…
- [NTSB CEN14LA161](https://openairdocs.org/ntsb/CEN14LA161.md): Cessna 150M · Greenwood, IN · Accident · Serious injuries · Limited investigation · Final report · Mar 18, 2014 · N9432U · Substantial damage
  > The flight instructor's failure to ensure that carburetor heat was used while performing maneuvers at reduced power settings in conditions conducive to the formation of carburetor ice, which resulted in a partial loss of engine power due to carburetor ice.…
- [NTSB CEN13LA424](https://openairdocs.org/ntsb/CEN13LA424.md): Air Tractor AT-802A · Huntingburg, IN · Accident · Serious injuries · Limited investigation · Final report · Jul 19, 2013 · N86BM · Destroyed
  > The pilot's failure to maintain clearance from a power line during an aerial application maneuver. Contributing to the accident was the pilot's failure to identify potential obstructions in the area before beginning low-altitude maneuvers.
- [NTSB CEN13FA085](https://openairdocs.org/ntsb/CEN13FA085.md): Piper PA 46-350P · Greensburg, IN · Accident · 4 fatal · Field investigation · Final report · Dec 2, 2012 · N92315 · Destroyed
  > The pilot's failure to maintain airplane control while maneuvering in night instrument meteorological conditions due to spatial disorientation.
- [NTSB CEN12CA484](https://openairdocs.org/ntsb/CEN12CA484.md): Bell 47G-2A · Austin, IN · Accident · Serious injuries · Data collection · Final report · Jul 27, 2012 · N652HA · Substantial damage
  > The pilot did not maintain clearance from terrain during a low-level aerial application flight and lost control of the helicopter.
- [NTSB CEN12CA360](https://openairdocs.org/ntsb/CEN12CA360.md): Birchler Boyd Eagle 540 · Kokomo, IN · Accident · No injuries · Data collection · Final report · Jun 9, 2012 · N34BJ · Substantial damage
  > The pilot's failure to maintain adequate clearance from the trees during a low-level aerobatic maneuver.
- [NTSB CEN12CA347](https://openairdocs.org/ntsb/CEN12CA347.md): Cameron Balloons Z-90 · Sellersburg, IN · Accident · Serious injuries · Data collection · Final report · Jun 7, 2012 · N401DJ · Minor damage
  > The balloon pilot’s failure to maintain clearance from power lines.
- [NTSB CEN12LA282](https://openairdocs.org/ntsb/CEN12LA282.md): Bell 206B-III · Flora, IN · Accident · No injuries · Limited investigation · Final report · May 9, 2012 · N1069Z · Substantial damage
  > The pilot allowed the helicopter to settle with power.
- [NTSB CEN12FA143](https://openairdocs.org/ntsb/CEN12FA143.md): Cessna 177A · North Vernon, IN · Accident · 2 fatal · Field investigation · Final report · Jan 22, 2012 · N3435T · Substantial damage
  > The non-instrument-rated pilot's decision to fly into known instrument meteorological conditions, which resulted in the pilot's spatial disorientation and loss of airplane control.
- [NTSB CEN11FA645](https://openairdocs.org/ntsb/CEN11FA645.md): Remos Aircraft Gmbh Flugzeugba GX · Noblesville, IN · Accident · 2 fatal · Field investigation · Final report · Sep 15, 2011 · N107GX · Substantial damage
  > The pilot’s failure to maintain adequate airspeed while maneuvering at a low altitude. Contributing was the pilot's decision to maneuver at an altitude below that required for congested areas, which did not afford an adequate margin for stall recovery.
- [NTSB CEN11LA512](https://openairdocs.org/ntsb/CEN11LA512.md): WSK PZL Mielec M-18A · Anderson, IN · Accident · No injuries · Limited investigation · Final report · Jul 25, 2011 · N92640 · Substantial damage
  > The fatigue failure of the propeller governor speeder spring, which resulted in the pilot’s inability to control engine output power.
- [NTSB CEN11CA495](https://openairdocs.org/ntsb/CEN11CA495.md): Cessna A188B · Greenstown, IN · Accident · No injuries · Data collection · Final report · Jul 19, 2011 · N4725R · Substantial damage
  > The pilot's failure to maintain adequate clearance from vegetation that caused increased drag during a low-level maneuvering flight.
- [NTSB CEN11LA315](https://openairdocs.org/ntsb/CEN11LA315.md): Hughes 269B · Edgerton, IN · Accident · No injuries · Limited investigation · Final report · Apr 29, 2011 · N9561F · Substantial damage
  > A loss of clearance between the tail rotor drive shaft and the tailboom bulkhead for undetermined reasons, which resulted in the overstress failure of the drive shaft.
- [NTSB CEN11LA194](https://openairdocs.org/ntsb/CEN11LA194.md): Taylorcraft DCO-65 · Americus, IN · Accident · 1 fatal · Limited investigation · Final report · Feb 15, 2011 · N46089 · Substantial damage
  > The pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall.
- [NTSB CEN11LA069](https://openairdocs.org/ntsb/CEN11LA069.md): Cessna 172R · Farmersburg, IN · Accident · No injuries · Limited investigation · Final report · Nov 12, 2010 · N531HF · Substantial damage
  > A total loss of engine power for undetermined reasons.
- [NTSB CEN10LA442](https://openairdocs.org/ntsb/CEN10LA442.md): Lunceford Sparrowhawk II · Tell City, IN · Accident · 1 fatal · Limited investigation · Final report · Jul 27, 2010 · N91814 · Substantial damage
  > The pilot's loss of control of the gyroplane for undetermined reasons.
- [NTSB CEN10CA406](https://openairdocs.org/ntsb/CEN10CA406.md): WSK PZL Mielec M-18A · Muncie, IN · Accident · No injuries · Data collection · Final report · Jul 10, 2010 · N92640 · Substantial damage
  > The pilot's failure to see and avoid the power line during an aerial application flight.
- [NTSB CEN10LA216](https://openairdocs.org/ntsb/CEN10LA216.md): Piper PA-24-250 · Madison, IN · Accident · 1 fatal · Limited investigation · Final report · Apr 19, 2010 · N5425P · Destroyed
  > The pilot’s failure to maintain control of the airplane. Contributing to the accident was the pilot’s decision to conduct the flight with known physiological impairment and his use of unapproved sedating medication, both of which likely impaired his ability…

Next page: https://openairdocs.org/ntsb-phases/450/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 = 450)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/450/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.