# NTSB investigations, OH: Enroute

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 15 · 724 cases

## Latest cases

- [NTSB ERA27LA022](https://openairdocs.org/ntsb/ERA27LA022.md): Douglas A Kupersmith Zenith CH650B · Canton, OH · Accident · No injuries · Class 3 · Limited · Preliminary report · Oct 25, 2026 · N255DK · Substantial damage
  > On October 24, 2026, about 2033 eastern daylight time, an experimental amateur-built Zenith CH650B airplane, N255DK, was substantially damaged when it was involved in an accident near Canton, Ohio. The flight instructor and student pilot were not injured. The…
- [NTSB ERA26LA311](https://openairdocs.org/ntsb/ERA26LA311.md): HPH Glasflugel 304CZ · Xenia, OH · Accident · No injuries · Class 4 · Limited · Final report · Aug 21, 2026 · N304BS · Substantial damage
  > The glider’s encounter with atmospheric conditions where lift was not sufficient to maintain flight.
- [NTSB ERA26LA358](https://openairdocs.org/ntsb/ERA26LA358.md): Piper PA24 · Union City, OH · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 10, 2026 · N6985P · Substantial damage
  > On August 10, 2026, about 1800eastern daylight time, a Piper PA-24-250, N6985P, was substantially damaged when it was involved in an accident near Union City, Ohio. The flight instructor and the private pilot were not injured. The airplane was operated as a…
- [NTSB ERA26LA224](https://openairdocs.org/ntsb/ERA26LA224.md): Boeing E75 · Dresden, OH · Accident · Serious injuries · Class 3 · Limited · Preliminary report · May 29, 2026 · N181RF · Substantial damage
  > On May 29, 2026, about 1153 eastern daylight time, a Boeing E75, N181RF, was substantially damaged when it was involved in an accident near Dresden, Ohio. The pilot and passenger were seriously injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB ERA26LA197](https://openairdocs.org/ntsb/ERA26LA197.md): Cessna 182 · Lancaster, OH · Accident · Minor injuries · Class 3 · Limited · Preliminary report · May 4, 2026 · N9069X · Substantial damage
  > On May 3, 2026, about 2241 eastern daylight time, a Cessna 182D, N9069X, was substantially damaged when it was involved in an accident near Lancaster, Ohio. The pilot and one passenger sustained minor injuries. The airplane was operated as a Title 14 Code of…
- [NTSB OPS26LA001](https://openairdocs.org/ntsb/OPS26LA001.md): Eurocopter Deutschland MBB-BK 117 C-2 · Cleveland, OH · Incident · Class 4 · Limited · Investigation open · Oct 29, 2025 · N262MH · 2 aircraft · No damage
- [NTSB ERA25FA195](https://openairdocs.org/ntsb/ERA25FA195.md): FFF Express 2000 FT · Polk, OH · Accident · 1 fatal · Class 3 · Field · Preliminary report · May 5, 2025 · N519EA · Substantial damage
  > On May 5, 2025, about 1940 eastern daylight time, an experimental, amateur-built FFF LLC Express 2000 FT airplane, N519EA, was substantially damaged when it was involved in an accident near Polk, Ohio. The pilot was fatally injured. The airplane was operated…
- [NTSB ERA25LA111](https://openairdocs.org/ntsb/ERA25LA111.md): Cirrus Design SR22 · New Lexington, OH · Accident · Serious injuries · Class 4 · Limited · Final report · Feb 5, 2025 · N406SR · Substantial damage
  > The pilot’s flight into previously forecasted freezing rain, which resulted in ice accretion, reduced forward visibility, and a subsequent landing undershoot.
- [NTSB DCA25LA045](https://openairdocs.org/ntsb/DCA25LA045.md): Embraer S A ERJ 170-200 LR · Warnock, OH · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Nov 20, 2024 · N85352 · No damage
  > On November 20, 2024, about 1846 eastern standard time (2346 UTC), a Mesa Airlines, Inc., Embraer SA ERJ 170-200 LR, N85352, dba as United Express flight 6149, encountered “moderate to severe” turbulence during descent to its destination, Cleveland Hopkins…
- [NTSB ERA25LA027](https://openairdocs.org/ntsb/ERA25LA027.md): Bell Helicopter Textron 206L-1 · Canal Winchester, OH · Accident · No injuries · Class 4 · Limited · Final report · Oct 27, 2024 · N54AE · Substantial damage
  > An in-flight collision with a bird while in cruise flight.
- [NTSB ERA24FA026](https://openairdocs.org/ntsb/ERA24FA026.md): Piper PA-32-300 · Marion, OH · Accident · 2 fatal · Class 3 · Field · Final report · Oct 31, 2023 · N44601 · Destroyed
  > A descent and impact with terrain for undetermined reasons.
- [NTSB ERA24LA014](https://openairdocs.org/ntsb/ERA24LA014.md): Piper PA-24-250 · Ottawa, OH · Accident · Minor injuries · Class 3 · Limited · Final report · Oct 22, 2023 · N6757P · Substantial damage
  > A total loss of engine power due to the formation of carburetor ice..
- [NTSB ERA23LA362](https://openairdocs.org/ntsb/ERA23LA362.md): Piper PA32 · Cincinnati, OH · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 2, 2023 · N6868D · Substantial damage
  > A loss of engine power for reasons that could not be determined.
- [NTSB ERA23LA306](https://openairdocs.org/ntsb/ERA23LA306.md): Piper PA-32RT-300 · Mount Gilead, OH · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 21, 2023 · N9519C · Substantial damage
  > The pilot’s improper fuel management by not switching fuel tanks in flight, resulting in fuel starvation to the engine and a total loss of engine power.
- [NTSB ERA23LA208](https://openairdocs.org/ntsb/ERA23LA208.md): Vans RV6 · Eaton, OH · Accident · Serious injuries · Class 3 · Limited · Final report · Apr 26, 2023 · N327WC · Substantial damage
  > The pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA23LA041](https://openairdocs.org/ntsb/ERA23LA041.md): Rhinehart Stolp Sdtr TOO SA300 · Lordstown, OH · Accident · Serious injuries · Class 3 · Limited · Final report · Oct 23, 2022 · N160JR · 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. Contributing to the accident was the improper installation of the elevator trim tab control, which created control feedback…
- [NTSB ERA23LA018](https://openairdocs.org/ntsb/ERA23LA018.md): Cessna 310 · Middlefield, OH · Accident · No injuries · Class 4 · Limited · Final report · Oct 13, 2022 · N62368 · Substantial damage
  > The pilot’s inadequate fuel planning and inflight fuel management which resulted in exhaustion of his fuel supply and a forced landing.
- [NTSB ERA22LA392](https://openairdocs.org/ntsb/ERA22LA392.md): Cessna 172N · Gates Mills, OH · Accident · Serious injuries · Class 4 · Limited · Final report · Aug 30, 2022 · N204BE · Substantial damage
  > The instructor pilot’s decision to perform an inflight magneto check with no suitable area to land. Contributing to the accident was the pilot's failure to correctly perform a magneto check that resulted in a total loss of engine power.
- [NTSB DCA22LA188](https://openairdocs.org/ntsb/DCA22LA188.md): Boeing 737-824 · Pharisburg, OH · Accident · Serious injuries · Class 4 · Limited · Final report · Aug 19, 2022 · N73270 · No damage
  > The airplane’s inadvertent encounter with convective turbulence.
- [NTSB ERA22LA298](https://openairdocs.org/ntsb/ERA22LA298.md): Cessna 172 · Akron, OH · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 4, 2022 · N12115 · Substantial damage
  > The pilots’ improper preflight fuel planning and in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN22LA038](https://openairdocs.org/ntsb/CEN22LA038.md): Piper PA-22-160 · West Union, OH · Accident · No injuries · Class 3 · Limited · Final report · Nov 15, 2021 · N3463Z · Substantial damage
  > A malfunction of the flight controls for reasons that could not be determined based on available information.
- [NTSB ENG22LA004](https://openairdocs.org/ntsb/ENG22LA004.md): Beech F33 · Bellefontaine, OH · Occurrence · No injuries · Class 3 · Limited · Final report · Nov 12, 2021 · N9035Q · Minor damage
  > The internal failure of the autopilot pitch servo actuator that caused the autopilot to command a nose down movement of the pitch trim.
- [NTSB CEN21LA472](https://openairdocs.org/ntsb/CEN21LA472.md): Cessna T210N · East Sparta, OH · Accident · No injuries · Class 3 · Limited · Final report · Sep 28, 2021 · N1925U · Substantial damage
  > A total loss of engine power due to a fatigue failure of the No. 2 cylinder exhaust valve.
- [NTSB CEN21FA376](https://openairdocs.org/ntsb/CEN21FA376.md): Socata TBM 700 · Urbana, OH · Accident · 1 fatal · Class 3 · Field · Final report · Aug 20, 2021 · N700DT · Destroyed
  > The pilot’s failure to arrest the airplane’s left roll and rapid descent for reasons that could not be determined based on the available evidence.
- [NTSB CEN21LA379](https://openairdocs.org/ntsb/CEN21LA379.md): Diamond Aircraft Industries DA-42 · Bellefontaine, OH · Accident · No injuries · Class 3 · Limited · Final report · Aug 17, 2021 · N215BN · Substantial damage
  > The improper position of the right engine’s fuel feed pump bolt, which led to a total loss of power on the right engine, and the left engine's partial loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB CEN21FA238](https://openairdocs.org/ntsb/CEN21FA238.md): Lancair Evolution · McDermott, OH · Accident · 2 fatal · Class 3 · Field · Final report · May 28, 2021 · N515DL · Destroyed
  > The pilot’s failure to recognize and avoid airframe icing conditions, which resulted in a loss of airplane performance and a subsequent loss of control and in-flight break-up.
- [NTSB CEN21LA034](https://openairdocs.org/ntsb/CEN21LA034.md): Cessna 182 · Lebanon, OH · Accident · No injuries · Class 3 · Limited · Final report · Oct 28, 2020 · N3537C · Substantial damage
  > Improper maintenance that resulted in a blocked crankcase breather port and a subsequent total loss of engine power.
- [NTSB CEN21LA020](https://openairdocs.org/ntsb/CEN21LA020.md): Piper PA-28 · Beloit, OH · Accident · No injuries · Class 4 · Limited · Final report · Oct 16, 2020 · N15608 · Substantial damage
  > The pilot’s inadequate preflight inspection and inflight planning that resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN20LA422](https://openairdocs.org/ntsb/CEN20LA422.md): Aeronca 7AC · St. Clairsville, OH · Accident · No injuries · Class 4 · Limited · Final report · Sep 23, 2020 · N81624 · Substantial damage
  > The pilots improper fuel planning that resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN20LA290](https://openairdocs.org/ntsb/CEN20LA290.md): Piper PA22 · Loveland, OH · Accident · No injuries · Class 3 · Limited · Final report · Jul 18, 2020 · N4816A · Substantial damage
  > The loss of engine power due to fuel starvation
- [NTSB CEN20LA197](https://openairdocs.org/ntsb/CEN20LA197.md): Beech 35-A33 · Cambridge, OH · Accident · 1 fatal · Class 3 · Limited · Final report · May 27, 2020 · N123JB · Substantial damage
  > A fuel injection system leak at or near the No. 3 cylinder that resulted in a partial loss of engine power during cruise flight.
- [NTSB CEN20LA148](https://openairdocs.org/ntsb/CEN20LA148.md): Beech 36 · Cincinnati, OH · Accident · No injuries · Class 3 · Limited · Final report · Apr 16, 2020 · N66FN · Substantial damage
  > A loose fuel inlet fitting on the fuel pump due to improper maintenance, which resulted in a total loss of engine power.
- [NTSB GAA20CA017](https://openairdocs.org/ntsb/GAA20CA017.md): Piper PA28 · Dayton, OH · Accident · No injuries · Data collection · Final report · Oct 10, 2019 · N8078X · Substantial damage
  > The pilot's improper fuel management, which resulted in fuel starvation, a total loss of engine power, and an off-airport landing, during which the airplane struck a vehicle.
- [NTSB CEN19LA303](https://openairdocs.org/ntsb/CEN19LA303.md): Phantom Aeronautics X-1 · Van Wert, OH · Accident · No injuries · Class 3 · Limited · Final report · Sep 4, 2019 · N111JC · Substantial damage
  > A loss of engine power due to the separation of the carburetor from the intake socket resulting from the improper installation of the intake silencer.
- [NTSB CEN19FA177](https://openairdocs.org/ntsb/CEN19FA177.md): Beech A36 · Elida, OH · Accident · 2 fatal · Field investigation · Final report · Jun 20, 2019 · N6150X · Destroyed
  > The noninstrument-rated pilot's decision to continue visual flight rules flight into an area of instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing was the pilot not obtaining a weather…
- [NTSB ERA19FA181](https://openairdocs.org/ntsb/ERA19FA181.md): Piper PA28R · Auburn Township, OH · Accident · 1 fatal · Class 3 · Field · Final report · May 28, 2019 · N3933T · Destroyed
  > The pilot's loss of control due to spatial disorientation in dark night conditions. Contributing to the accident was his inadequate weather planning, lack of experience flying at night and the deteriorating weather conditions.
- [NTSB CEN19FA144](https://openairdocs.org/ntsb/CEN19FA144.md): Vans RV6 · Chillicothe, OH · Accident · 1 fatal · Class 2 · Field · Final report · May 18, 2019 · N596JB · Destroyed
  > The pilot's failure to maintain control of the airplane following an intermittent loss of engine power during cruise flight that resulted in him impacting trees. The reason for the loss of engine power could not be determined based on the available…
- [NTSB CEN19FA100](https://openairdocs.org/ntsb/CEN19FA100.md): Cessna 421 · Plain City, OH · Accident · 1 fatal · Class 2 · Field · Final report · Mar 17, 2019 · N424TW · Destroyed
  > A loss of airspeed indication due to icing of the airplane's pitot probe, and the pilot's loss of control while maneuvering.
- [NTSB ERA19FA124](https://openairdocs.org/ntsb/ERA19FA124.md): Piper PA31 · Madeira, OH · Accident · 1 fatal · Field investigation · Final report · Mar 12, 2019 · N400JM · Substantial damage
  > Fuel starvation to the left engine and the resulting loss of engine power to that engine, and a loss of airplane control due to the pilot's failure to maintain the minimum controllable airspeed.
- [NTSB CEN19FA072](https://openairdocs.org/ntsb/CEN19FA072.md): Bell 407 · Zaleski, OH · Accident · 3 fatal · Class 1 · Field · Final report · Jan 29, 2019 · N191SF · Destroyed
  > The NTSB determines that the probable cause of this accident was Survival Flight's inadequate management of safety, which normalized pilots' and operations control specialists' noncompliance with risk analysis procedures and resulted in the initiation of the…
- [NTSB CEN19LA047](https://openairdocs.org/ntsb/CEN19LA047.md): Rans S12 · McClure, OH · Accident · No injuries · Limited investigation · Final report · Dec 16, 2018 · N3165V · Substantial damage
  > The cold seizure of the cylinder/piston due to the pilot’s failure to adequately warm the engine before takeoff, which resulted in a loss of engine power during a departure climb.
- [NTSB CEN18LA370](https://openairdocs.org/ntsb/CEN18LA370.md): Cubcrafters CC11-160 · Lancaster, OH · Accident · No injuries · Limited investigation · Final report · Aug 31, 2018 · N71BN · Substantial damage
  > The delayed application of carburetor heat by the pilot which led to accumulation of carburetor ice, eventual loss of engine power, and the subsequent forced landing in high vegetation.
- [NTSB CEN18LA351](https://openairdocs.org/ntsb/CEN18LA351.md): Cessna P210 · Delaware, OH · Accident · No injuries · Limited investigation · Final report · Aug 26, 2018 · N4842K · Substantial damage
  > The pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s distraction of the formation flight.
- [NTSB CEN18LA284](https://openairdocs.org/ntsb/CEN18LA284.md): Toomey Quickie · Zanesville, OH · Accident · No injuries · Limited investigation · Final report · Jul 19, 2018 · N23JH · Substantial damage
  > The failure of the exhaust manifold and a loose mixture screw, which resulted in a partial loss of engine power.
- [NTSB CEN18LA275](https://openairdocs.org/ntsb/CEN18LA275.md): Whittman Tailwind · Orient, OH · Accident · No injuries · Limited investigation · Final report · Jul 12, 2018 · N619NT · Substantial damage
  > The pilot’s and the flight instructor's incorrect use of the modified mixture control, which resulted in a loss of engine power due to fuel starvation and a forced landing. Also causal was the inadequate systems knowledge of the experimental, amateur-built…
- [NTSB CEN18FA143](https://openairdocs.org/ntsb/CEN18FA143.md): Beech G33 · Warsaw, OH · Accident · 2 fatal · Field investigation · Final report · Apr 16, 2018 · N9345Q · Substantial damage
  > The pilot's decision to continue flight in known icing conditions, which resulted in structural icing, degraded airplane performance, and a subsequent loss of control. Contributing to the accident was the pilot's failure to obtain an official weather briefing…
- [NTSB CEN17LA358](https://openairdocs.org/ntsb/CEN17LA358.md): Cessna 177B · London, OH · Accident · No injuries · Limited investigation · Final report · Sep 17, 2017 · N35170 · Substantial damage
  > The flight instructor's inadequate in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN17LA295](https://openairdocs.org/ntsb/CEN17LA295.md): Steele Acro Sport II · Loudonville, OH · Accident · Minor injuries · Limited investigation · Final report · Jul 30, 2017 · N896JC · Substantial damage
  > A partial loss of engine power due to carburetor icing.
- [NTSB CEN17FA207](https://openairdocs.org/ntsb/CEN17FA207.md): Varga 2150A · Bowling Green, OH · Accident · 1 fatal · Field investigation · Final report · Jun 1, 2017 · N4635V · Substantial damage
  > The pilot's loss of control due to impairment from carbon monoxide poisoning. Contributing to the accident was the corrosion of the heat exchanger and the failure of maintenance personnel to adequately inspect and repair or replace the exchanger during the…
- [NTSB CEN17LA081](https://openairdocs.org/ntsb/CEN17LA081.md): Bellanca 17 30 · Kidron, OH · Accident · No injuries · Limited investigation · Final report · Jan 21, 2017 · N39819 · Substantial damage
  > Maintenance personnel’s failure to properly secure the vacuum pump, which resulted in a loss of engine oil and the subsequent total loss of engine power due to oil starvation.

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

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

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