# NTSB investigations, KY: Approach

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 · 201 cases

## Latest cases

- [NTSB ERA25LA277](https://openairdocs.org/ntsb/ERA25LA277.md): Mangels Leighton LANCAIR360 · Hardinsburg, KY · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jul 24, 2025 · N50LM · Substantial damage
  > On July 24, 2025, about 1000 central daylight time, an experimental amateur-built Lancair 360, N50LM, was substantially damaged when it was involved in an accident near Hardinsburg, Kentucky. The pilot and the passenger sustained minor injuries. The airplane…
- [NTSB ERA25LA023](https://openairdocs.org/ntsb/ERA25LA023.md): Buckeye Dream Machine · Nicholasville, KY · Accident · 2 fatal · Class 3 · Limited · Final report · Oct 27, 2024 · N75331 · Substantial damage
  > The pilot’s loss of control in flight, which resulted in a collision with terrain.
- [NTSB ERA25LA012](https://openairdocs.org/ntsb/ERA25LA012.md): Piper PA28 · Louisville, KY · Accident · Serious injuries · Class 3 · Limited · Final report · Oct 11, 2024 · N5006W · Substantial damage
  > A total loss of engine power for undetermined reasons.
- [NTSB ERA23FA048](https://openairdocs.org/ntsb/ERA23FA048.md): Beech A36 · Harlan, KY · Accident · 1 fatal · Class 3 · Field · Final report · Nov 3, 2022 · N84R · Destroyed
  > The pilot’s visual flight rules flight into instrument meteorological conditions during an approach to land at an airport in mountainous terrain, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s hazardous…
- [NTSB ERA22FA354](https://openairdocs.org/ntsb/ERA22FA354.md): Piper J3C-65 · Cynthiana, KY · Accident · 1 fatal · Class 3 · Field · Final report · Aug 3, 2022 · N88550 · 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 while maneuvering to land with approaching convective activity.
- [NTSB ERA21LA338](https://openairdocs.org/ntsb/ERA21LA338.md): Schmitt Just Acft Highlander · Crittenden, KY · Accident · No injuries · Class 3 · Limited · Final report · Aug 24, 2021 · N101KL · Substantial damage
  > The pilot’s inadequate fuel planning, which resulted in fuel starvation and a total loss of engine power.
- [NTSB ERA21LA050](https://openairdocs.org/ntsb/ERA21LA050.md): Cessna 172 · Cynthiana, KY · Accident · Minor injuries · Class 4 · Limited · Final report · Nov 19, 2020 · N6203F · Substantial damage
  > The pilot’s failure to maintain proper glide path during a visual approach that was conducted at night, resulting in a collision with trees and terrain.
- [NTSB ERA20LA069](https://openairdocs.org/ntsb/ERA20LA069.md): Glassair I · Mount Sterling, KY · Accident · Serious injuries · Class 3 · Limited · Final report · Jan 6, 2020 · N118CV · Substantial damage
  > The pilot’s mismanagement of the fuel selector, which resulted in fuel starvation and a total loss of engine power.
- [NTSB ERA20FA026](https://openairdocs.org/ntsb/ERA20FA026.md): Piper PA32R · Paducah, KY · Accident · 1 fatal · Class 3 · Field · Final report · Nov 1, 2019 · N181AG · Destroyed
  > The pilot’s failure to fully seat the fuel selector in the proper tank position during the descent for landing, which resulted in fuel starvation and a total loss of engine power.
- [NTSB CEN19LA184](https://openairdocs.org/ntsb/CEN19LA184.md): Piper J3C · Vine Grove, KY · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 23, 2019 · N70803 · Substantial damage
  > The pilot’s failure to maintain a proper visual lookout during the approach, which resulted in inadequate clearance from a tree.
- [NTSB ERA19FA155](https://openairdocs.org/ntsb/ERA19FA155.md): Bellanca 1730 · Henderson, KY · Accident · 2 fatal · Class 2 · Field · Final report · Apr 23, 2019 · N9693E · Substantial damage
  > The student pilot's failure to maintain proper airspeed, which resulted in the exceedance of the airplane's critical angle of attack at a low altitude, in the airport traffic pattern, following a total loss of engine power due to fuel exhaustion. Contributing…
- [NTSB ERA19TA105](https://openairdocs.org/ntsb/ERA19TA105.md): Beech 76 · Frankfort, KY · Accident · Minor injuries · Final report · Feb 21, 2019 · N7KY · Substantial damage
  > The pilot's failure to maintain airplane control during a simulated single-engine go-around, which resulted in a collision with terrain.
- [NTSB ERA19LA083](https://openairdocs.org/ntsb/ERA19LA083.md): Beech 35 · Lexington, KY · Accident · No injuries · Class 3 · Limited · Final report · Jan 26, 2019 · N6136V · Substantial damage
  > The pilot's improper slip maneuver on final approach, which resulted in a total loss of engine power.
- [NTSB ERA18FA005](https://openairdocs.org/ntsb/ERA18FA005.md): Bryant C Crosby BC Ultra PUP · Bardstown, KY · Accident · 1 fatal · Field investigation · Final report · Oct 5, 2017 · N484HC · Substantial damage
  > The pilot's improper decision to initiate a flight in an airplane he had never flown and with no currency in any airplane nor a medical certificate, which resulted in his loss of airplane control. Contributing to the accident was the pilot's psychiatric…
- [NTSB ERA16LA281](https://openairdocs.org/ntsb/ERA16LA281.md): Vans RV4 · Shelbyville, KY · Accident · Serious injuries · Limited investigation · Final report · Aug 7, 2016 · N924WZ · Substantial damage
  > The partial loss of engine power due to carburetor icing. Contributing to the accident was the pilot’s failure to effectively use carburetor heat.
- [NTSB ERA16LA274](https://openairdocs.org/ntsb/ERA16LA274.md): Alisport Silent 2 Targa · London, KY · Accident · Minor injuries · Limited investigation · Final report · Jul 24, 2016 · N602SL · Substantial damage
  > The pilot's failure to properly secure the right side of the canopy before takeoff, and an in-flight collision with trees while maneuvering with an open canopy. Contributing to the pilot's failure to properly secure the canopy was the lack of a visual…
- [NTSB ERA16FA248](https://openairdocs.org/ntsb/ERA16FA248.md): Bell Helicopter Textron Canada 407 · Hickory, KY · Accident · 1 fatal · Field investigation · Final report · Jul 11, 2016 · N427TV · Substantial damage
  > Company maintenance personnel's inappropriate removal without replacement of the safety wires on the collective lever pin screws during a recent maintenance inspection, which resulted in the screws backing out and led to a loss of collective control in flight.
- [NTSB ERA15LA341](https://openairdocs.org/ntsb/ERA15LA341.md): Piper PA 28RT-201 · Russell Springs, KY · Accident · Minor injuries · Class 2 · Limited · Final report · Sep 4, 2015 · N8162S · Substantial damage
  > Maintenance personnel’s inadequate fuel injection servo maintenance due to an out-of-date AD list, which resulted in the fuel injection servo plug backing out of the threaded plug hole on the regulator cover of the fuel injection servo and subsequent total…
- [NTSB ERA15CA272](https://openairdocs.org/ntsb/ERA15CA272.md): Smith Steen Skybolt · Junction City, KY · Accident · Minor injuries · Data collection · Final report · Jul 18, 2015 · N31CS · Substantial damage
  > The pilot's inaccurate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA14CA407](https://openairdocs.org/ntsb/ERA14CA407.md): Piper PA-28-140 · Taylorsville, KY · Accident · No injuries · Data collection · Final report · Aug 23, 2014 · N41224 · Substantial damage
  > The pilot's decision to land on a wet runway and delayed go-around attempt, which resulted in a collision with terrain.
- [NTSB ERA14LA218](https://openairdocs.org/ntsb/ERA14LA218.md): Beech V35B · Middlesboro, KY · Accident · Serious injuries · Limited investigation · Final report · May 2, 2014 · N702JS · Substantial damage
  > The pilot's failure to maintain airplane control during the landing approach due to his diverted attention to the partially opened main cabin door and the unsecured dog. Contributing to the accident was the pilot's failure to securely latch the main cabin…
- [NTSB ERA13LA390](https://openairdocs.org/ntsb/ERA13LA390.md): Continental Copters 47G · Sandy Hook, KY · Accident · No injuries · Limited investigation · Final report · Aug 31, 2013 · N6356X · Substantial damage
  > The in-flight disengagement of the tail rotor extension shaft from the tail rotor gearbox, resulting in a loss of tail rotor control.
- [NTSB ERA13FA273](https://openairdocs.org/ntsb/ERA13FA273.md): Bell Helicopter Textron 206L-1 · Manchester, KY · Accident · 3 fatal · Field investigation · Final report · Jun 7, 2013 · N114AE · Destroyed
  > The pilot’s loss of helicopter control due to spatial disorientation when he inadvertently encountered night, instrument meteorological conditions, which resulted in the in-flight separation of the main rotor and tailboom.
- [NTSB ERA13LA058](https://openairdocs.org/ntsb/ERA13LA058.md): Cessna 172RG · Lexington, KY · Accident · No injuries · Limited investigation · Final report · Nov 15, 2012 · N9985B · Substantial damage
  > The rupture of the landing gear’s hydraulic pressure hose, which resulted in the depletion of all of the hydraulic fluid, and the inability of the landing gear to raise or lower. Contributing to the accident was the installation of an unapproved hydraulic…
- [NTSB ERA12LA575](https://openairdocs.org/ntsb/ERA12LA575.md): Cessna 182Q · Fort Thomas, KY · Accident · Minor injuries · Limited investigation · Final report · Sep 23, 2012 · N735FJ · Substantial damage
  > The pilot’s failure to periodically add engine power during an extended descent in carburetor icing conditions, which resulted in insufficient carburetor heat, the gradual build-up of carburetor ice, and the subsequent loss of engine power.
- [NTSB ERA11FA218](https://openairdocs.org/ntsb/ERA11FA218.md): Cessna 310R · Pikeville, KY · Accident · 2 fatal · Field investigation · Final report · Mar 30, 2011 · N1914G · Substantial damage
  > The pilot's flight below the published minimum descent altitude in instrument meteorological conditions, which resulted in a collision with trees and the ground. Contributing to the accident was the pilot's use of nighttime cold medication at doses above…
- [NTSB ERA11CA007](https://openairdocs.org/ntsb/ERA11CA007.md): Aeronca 11AC · Taylorsville, KY · Accident · Minor injuries · Data collection · Final report · Oct 4, 2010 · N85888 · Substantial damage
  > The pilot’s failure to maintain clearance from an unmarked power line during the final approach to land.
- [NTSB ERA10CA214](https://openairdocs.org/ntsb/ERA10CA214.md): Piper PA28 · Louisville, KY · Accident · Serious injuries · Data collection · Final report · Apr 7, 2010 · N4247T · Substantial damage
  > A loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel management.
- [NTSB ERA10FA148](https://openairdocs.org/ntsb/ERA10FA148.md): Piper PA-28-180 · Springfield, KY · Accident · 1 fatal · Field investigation · Final report · Feb 23, 2010 · N7778W · Substantial damage
  > The pilot's inadequate preflight planning, which resulted in a total loss of engine power due to fuel exhaustion, and the pilot's impairment due to alcohol. Contributing to the accident was the Federal Aviation Administration's failure to adequately oversee…
- [NTSB ERA10IA095](https://openairdocs.org/ntsb/ERA10IA095.md): Beech 58 · Lexington, KY · Incident · No injuries · Incident investigation · Final report · Dec 10, 2009 · N391MC · Minor damage
  > The overstress failure of the nose landing gear aft drag brace.
- [NTSB ERA10LA005](https://openairdocs.org/ntsb/ERA10LA005.md): Cessna 210 · Louisville, KY · Accident · No injuries · Limited investigation · Final report · Oct 4, 2009 · N9443T · Substantial damage
  > A malfunction of the landing gear extension system due to a fractured hydraulic line. Contributing to the accident was the inadequate inspection and maintenance of the hydraulic line.
- [NTSB ERA09FA093](https://openairdocs.org/ntsb/ERA09FA093.md): Beech 36 · Louisville, KY · Accident · 1 fatal · Field investigation · Final report · Dec 18, 2008 · N7472N · Substantial damage
  > The pilot’s continued operation of the aircraft with known deficiencies. Contributing to this accident was the improper sealing of the engine case during overhaul.
- [NTSB MIA08FA027](https://openairdocs.org/ntsb/MIA08FA027.md): Cessna T210N · Bloomfield, KY · Accident · 2 fatal · Field investigation · Final report · Dec 8, 2007 · N5431C · Substantial damage
  > the pilot exceeded the design stress limits of the airplane, which resulted in the in-flight break up. Contributing to the accident was the pilot's loss of control in-flight due to spatial disorientation.
- [NTSB NYC08FA046](https://openairdocs.org/ntsb/NYC08FA046.md): Cessna 310R · Owensboro, KY · Accident · 1 fatal · Field investigation · Final report · Nov 26, 2007 · N3364G · Substantial damage
  > A loss of control during approach for undetermined reasons.
- [NTSB NYC07CA034](https://openairdocs.org/ntsb/NYC07CA034.md): Taylorcraft BC12-D · Benton, KY · Accident · Serious injuries · Data collection · Final report · Nov 21, 2006 · N148HW · Substantial damage
  > The pilot's improper decision to fly between the trees during his approach to the runway.
- [NTSB NYC06FA209](https://openairdocs.org/ntsb/NYC06FA209.md): Cessna 401A · Whick, KY · Accident · 7 fatal · Field investigation · Final report · Aug 28, 2006 · N408JC · Destroyed
  > The non-instrument-rated pilot's continued flight into instrument meteorological conditions, and his subsequent failure to maintain airspeed which resulted in an inadvertent stall. Contributing was the instrument meteorological conditions.
- [NTSB CHI06FA141](https://openairdocs.org/ntsb/CHI06FA141.md): Cessna 210N · Ft. Thomas, KY · Accident · 1 fatal · Field investigation · Final report · May 30, 2006 · N5212U · Substantial damage
  > The pilot failed to maintain altitude/clearance with trees while attempting to return to the airport.
- [NTSB NYC06IA036](https://openairdocs.org/ntsb/NYC06IA036.md): Mooney M20F · Cadiz, KY · Incident · No injuries · Incident investigation · Final report · Nov 24, 2005 · N52DB · Minor damage
  > Fuel starvation, which resulted in a loss of engine power.
- [NTSB NYC06FA004](https://openairdocs.org/ntsb/NYC06FA004.md): Beech A36 · Pikeville, KY · Accident · 3 fatal · Field investigation · Final report · Oct 7, 2005 · N97CM · Destroyed
  > The pilot's failure to follow the published instrument approach which resulted in controlled flight into terrain. A factor was the low ceiling.
- [NTSB NYC05LA017](https://openairdocs.org/ntsb/NYC05LA017.md): Labhart Kolb Twinstar Mk III · London, KY · Accident · 1 fatal · Limited investigation · Final report · Nov 14, 2004 · N83NK · Substantial damage
  > The pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel contamination. A factor was the lack of an installed fuel strainer.
- [NTSB DCA04MA068](https://openairdocs.org/ntsb/DCA04MA068.md): Convair Div. of Gen. Dynamics CV-340 (580) · Florence, KY · Accident · 1 fatal · Class 1 · Major · Final report · Aug 13, 2004 · N586P · Destroyed
  > fuel starvation resulting from the captain's decision not to follow approved fuel crossfeed procedures. Contributing to the accident were the captain's inadequate preflight planning, his subsequent distraction during the flight, and his lateinitiation of the…
- [NTSB NYC04CA049](https://openairdocs.org/ntsb/NYC04CA049.md): Bell B407 · Morehead, KY · Accident · No injuries · Data collection · Final report · Dec 21, 2003 · N508MT · Substantial damage
  > The ground personnel's failure to identify the hazardous condition. Factors were blowing snow and night conditions.
- [NTSB NYC03LA165](https://openairdocs.org/ntsb/NYC03LA165.md): Beltram Glasair-TD · London, KY · Accident · No injuries · Limited investigation · Final report · Jul 25, 2003 · N22VB · Substantial damage
  > The pilot's failure to follow published procedures, which resulted in fuel starvation during approach.
- [NTSB IAD03FA032](https://openairdocs.org/ntsb/IAD03FA032.md): Cessna 421 · Ferguson, KY · Accident · 3 fatal · Field investigation · Final report · Feb 17, 2003 · N421TJ · Destroyed
  > The pilot's failure to follow the instrument approach procedure, which resulted in an early descent into trees and terrain. Factors included the low ceiling and the night lighting conditions.
- [NTSB NYC03LA051](https://openairdocs.org/ntsb/NYC03LA051.md): Piper PA-31-350 · Taylor Mill, KY · Accident · Minor injuries · Limited investigation · Final report · Feb 16, 2003 · N130CM · Substantial damage
  > The pilot's inaccurate in-flight planning and fuel consumption calculations, and his improper decision not to land and refuel.
- [NTSB IAD03LA015](https://openairdocs.org/ntsb/IAD03LA015.md): Bell 206L1 · Albany, KY · Accident · No injuries · Limited investigation · Final report · Nov 8, 2002 · N108AE · Substantial damage
  > The pilot's inadequate in-flight planning, which resulted in an angle of approach in relative wind conditions conducive to a loss of helicopter tail rotor effectiveness. A factor was the obstacles surrounding the landing field.
- [NTSB IAD03FA005](https://openairdocs.org/ntsb/IAD03FA005.md): Cessna 172N · Mount Sterling, KY · Accident · 2 fatal · Field investigation · Final report · Oct 15, 2002 · N6413J · Destroyed
  > The failure of the pilot to follow the published instrument approach procedure, which resulted in an early descent into an antenna tower. A factor was the low ceiling.
- [NTSB NYC02LA071](https://openairdocs.org/ntsb/NYC02LA071.md): Cirrus Design SR-20 · Lexington, KY · Accident · Minor injuries · Limited investigation · Final report · Mar 16, 2002 · N244CD · Substantial damage
  > The pilot's failure to maintain aircraft control. Factors in this accident were the undetermined failure of the turn coordinator, as reported by the pilot, and the instrument meteorological conditions.
- [NTSB NYC01IA072](https://openairdocs.org/ntsb/NYC01IA072.md): Bombardier CL-600-2B19 · Covington, KY · Incident · No injuries · Incident investigation · Final report · Jan 3, 2001 · N933CA · Minor damage
  > Missing exhaust nozzle bolts for undetermined reasons. A factor was inadequate maintenance inspection of the affected area.
- [NTSB NYC00FA067](https://openairdocs.org/ntsb/NYC00FA067.md): Beech C-90 · Somerset, KY · Accident · 4 fatal · Field investigation · Final report · Jan 18, 2000 · N74CC · Destroyed
  > the failure of the pilot to follow his approach clearance, and subsequent descent into unprotected airspace which resulted in a collision with the guy wire. Factors were the failure of the air traffic controller to verify the approach he cleared the pilot to…

Next page: https://openairdocs.org/ntsb-phases/500/cases.md?state=KY&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" = 'KY' 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
```

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

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