# NTSB investigations, FL: 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 19 · 949 cases

## Latest cases

- [NTSB ERA27FA010](https://openairdocs.org/ntsb/ERA27FA010.md): Bell 407 · Myakka City, FL · Accident · 1 fatal · Class 3 · Field · Investigation open · Oct 16, 2026 · N618TS
- [NTSB ERA26LA313](https://openairdocs.org/ntsb/ERA26LA313.md): Robinson Helicopter R22 Beta · Milton, FL · Accident · Minor injuries · Class 4 · Limited · Final report · Aug 24, 2026 · N979SH · Substantial damage
  > The flight instructor’s failure to maintain control of the helicopter during a low hover over a grass area, which resulted in left skid contact with the ground and a dynamic rollover to the left.
- [NTSB ANC26LA088](https://openairdocs.org/ntsb/ANC26LA088.md): Cessna 172L · Micanopy, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 18, 2026 · N3866Q · Substantial damage
  > On August 18, 2026 at 1100 eastern daylight time, a Cessna 172L, N3866Q, was substantially damaged when it was involved in an accident near Micanopy, Florida. The flight instructor and student pilot were uninjured. The airplane was operated as a Title 14 Code…
- [NTSB ERA26LA304](https://openairdocs.org/ntsb/ERA26LA304.md): Robinson Helicopter R22 Beta · Miramar, FL · Accident · No injuries · Class 4 · Limited · Final report · Aug 15, 2026 · N8316N · Substantial damage
  > The flight instructor’s failure to maintain control of the helicopter during a hover, which resulted in the left skid contacting ground and a subsequent dynamic rollover.
- [NTSB ERA26LA284](https://openairdocs.org/ntsb/ERA26LA284.md): Piper PA28 · Palmetto, FL · Accident · No injuries · Class 4 · Limited · Final report · Jul 24, 2026 · N44704 · Substantial damage
  > The flight instructor’s failure to maintain clearance from obstacles during low altitude maneuvering, which resulted in a collision with a fence.
- [NTSB ANC26LA051](https://openairdocs.org/ntsb/ANC26LA051.md): Robinson R44 · Pembroke Pines, FL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jun 13, 2026 · N336SG · Substantial damage
  > On June 13, 2026, about 1318 eastern daylight time, a Robinson R44 Raven I helicopter, N336SG, was substantially damaged when it was involved in an accident at the North Perry Airport (HWO), Hollywood, Florida. The pilot and three passengers sustained minor…
- [NTSB ERA26FA166](https://openairdocs.org/ntsb/ERA26FA166.md): North American AT-6D · Bronson, FL · Accident · 2 fatal · Class 3 · Field · Investigation open · Apr 13, 2026 · N29678 · Destroyed
- [NTSB ERA26LA046](https://openairdocs.org/ntsb/ERA26LA046.md): Cessna 172 · Palm Bay, FL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Nov 18, 2025 · N6124D · Substantial damage
  > On November 17, 2025, about 1900 eastern standard time, a Cessna 172N, N6124D, was substantially damaged when it was involved in an accident near Palm Bay, Florida. The private pilot sustained minor injuries. The airplane was operated as a Title 14 Code of…
- [NTSB ERA26FA034](https://openairdocs.org/ntsb/ERA26FA034.md): Extra Flugzeugproduktions EA 300/SC · Keystone Heights, FL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Nov 8, 2025 · N330SL · Destroyed
  > On November 8, 2025, at 1038 eastern standard time, an Extra 330/SC, N330SL, was destroyed when it was involved in an accident near Keystone Heights, Florida. The private pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB ERA26LA007](https://openairdocs.org/ntsb/ERA26LA007.md): Cessna 172 · Miami, FL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Oct 7, 2025 · N433PT · Substantial damage
  > On October 07, 2025, at 1440 eastern daylight time, a Cessna 172M, N433PT, was substantially damaged when it was involved in an accident near Miami, Florida. The private pilot and the flight instructor were uninjured. The airplane was operated as a Title 14…
- [NTSB ERA25LA288](https://openairdocs.org/ntsb/ERA25LA288.md): Cessna 172N · Pembroke Pines, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 5, 2025 · N1213F · Substantial damage
  > On August 05, 2025, about 0820 eastern daylight time, a Cessna 172N, N1213F, was substantially damaged when it was involved in an accident near Pembroke Pines, Florida. The flight instructor and student pilot were not injured. The airplane was operated as a…
- [NTSB ERA25LA229](https://openairdocs.org/ntsb/ERA25LA229.md): Robinson Helicopter R66 · Valparaiso, FL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jun 12, 2025 · N633AF · Substantial damage
  > On June 12, 2025, about 1850 eastern daylight time, a Robinson Helicopter R66, N633AF, was substantially damaged when it was involved in an accident near Valparaiso, Florida. The pilot and passenger sustained minor injuries, and a second passenger was not…
- [NTSB ERA25LA217](https://openairdocs.org/ntsb/ERA25LA217.md): Piper PA-23 · Palm Bay, FL · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 4, 2025 · N2109P · Substantial damage
  > A loss of engine power to both of the airplane’s engines due to fuel exhaustion and fuel starvation.
- [NTSB ERA25LA181](https://openairdocs.org/ntsb/ERA25LA181.md): Schleicher ASW-19 · Zephyrhills, FL · Accident · Serious injuries · Class 4 · Limited · Final report · Apr 2, 2025 · N37PL · Substantial damage
  > The pilot’s inadequate inflight planning and an encounter with atmospheric conditions where the lift was not sufficient to maintain flight, resulting in an off-airport landing and collision with a fence.
- [NTSB DCA25LA065](https://openairdocs.org/ntsb/DCA25LA065.md): Uvify IFO · Orlando, FL · Accident · Serious injuries · Class 3 · Limited · Final report · Dec 21, 2024 · UNREG · Substantial damage
  > The remote pilot-in-command’s (RPIC’s) failure to locate the drone show center position over the physical location of the sUA, which resulted in multiple sUA colliding during the initial lift and subsequent loss of control. Contributing to the accident was…
- [NTSB ERA25FA069](https://openairdocs.org/ntsb/ERA25FA069.md): Vans RV-12IS · Homosassa, FL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Dec 7, 2024 · N702DP · Substantial damage
  > On December 6, 2024, about 2004 eastern standard time, an experimental amateur-built Vans Aircraft Inc RV-12IS, N702DP, was substantially damaged when it was involved in an accident near Homosassa, Florida. The private pilot was fatally injured. The flight…
- [NTSB ERA24LA295](https://openairdocs.org/ntsb/ERA24LA295.md): Piper PA-28-181 · Clearwater, FL · Accident · No injuries · Class 4 · Limited · Final report · Jul 6, 2024 · N471A · Substantial damage
  > An in-flight collision with a bird while flying in the airport traffic pattern.
- [NTSB ERA24LA287](https://openairdocs.org/ntsb/ERA24LA287.md): Airbus Helicopters AS350 · Sanford, FL · Accident · No injuries · Class 4 · Limited · Final report · Jun 27, 2024 · N174SC · Substantial damage
  > The helicopter pilot’s improper maneuvering at low altitude in gusty wind conditions, which resulted in the helicopter entering a vortex ring state, and hard landing during a subsequent autorotation.
- [NTSB ERA24LA271](https://openairdocs.org/ntsb/ERA24LA271.md): Cessna 172 · Hernando, FL · Accident · No injuries · Class 3 · Limited · Final report · Jun 21, 2024 · N734XT · Substantial damage
  > The improper installation of a cylinder rocker stud by maintenance personnel, which resulted in a partial loss of engine power and subsequent forced landing.
- [NTSB ERA24LA228](https://openairdocs.org/ntsb/ERA24LA228.md): Schleicher ASH 31 MI · Winter Haven, FL · Accident · Serious injuries · Class 3 · Limited · Final report · May 25, 2024 · N20SW · Substantial damage
  > The pilot’s failure to ensure that a suitable landing area was available in case the restart of the motor glider’s engine was unsuccessful. Contributing, was insufficient battery charge to extend the motor glider’s pylon assembly.
- [NTSB ERA24LA205](https://openairdocs.org/ntsb/ERA24LA205.md): Airbus Helicopters AS350B3 · Plant City, FL · Accident · No injuries · Class 3 · Limited · Final report · May 1, 2024 · N413JM · Substantial damage
  > The pilot’s inadequate yaw control of the helicopter while maneuvering at a low altitude and airspeed, which resulted in a hard landing.
- [NTSB ERA24LA216](https://openairdocs.org/ntsb/ERA24LA216.md): Apellix B1 Washing Drone · Orlando, FL · Accident · Serious injuries · Class 3 · Limited · Final report · Feb 20, 2024 · FA33N7WLTR · Substantial damage
  > A failure of the sUAS’s magnetometer while operating in close proximity to commercial air conditioning equipment, which resulted in the sUAS’s erratic maneuvering. Contributing to the accident was the RPIC’s failure to input the appropriate command to disarm…
- [NTSB ERA23LA350](https://openairdocs.org/ntsb/ERA23LA350.md): Robinson Helicopter R44 · Immokalee, FL · Accident · Serious injuries · Class 4 · Limited · Final report · Aug 26, 2023 · N4147Q · Substantial damage
  > The flight instructor’s inadequate supervision of the student pilot during hover flight, which resulted in main rotor blade contact with the ground after the student pilot applied a sudden control input.
- [NTSB ERA23FA340](https://openairdocs.org/ntsb/ERA23FA340.md): Piper PA-28-161 · Fort Pierce, FL · Accident · 1 fatal · Class 3 · Field · Final report · Aug 17, 2023 · N9855S · Destroyed
  > The left seat instructor’s intentional maneuvering of the airplane in an aerobatic steep turn for which it was not approved, which resulted in an exceedance of the structural limitations of the airplane and an inflight breakup.
- [NTSB ERA23LA283](https://openairdocs.org/ntsb/ERA23LA283.md): Airborne Edge-X · Coral Gables, FL · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 4, 2023 · N147JL · Substantial damage
  > A partial loss of engine power for reasons that could not be determined.
- [NTSB ERA23LA272](https://openairdocs.org/ntsb/ERA23LA272.md): Air Tractor AT802 · Wellington, FL · Accident · No injuries · Class 3 · Limited · Final report · Jun 20, 2023 · N3069S · Substantial damage
  > Wear of the fuel control unit drive shaft and the corresponding fuel pump drive gear, which resulted in the disengagement of the fuel control unit from the fuel pump, a decrease in fuel flow, and a loss of engine power.
- [NTSB ERA23LA245](https://openairdocs.org/ntsb/ERA23LA245.md): Piper PA-25-260 · Hollywood, FL · Accident · Serious injuries · Class 3 · Limited · Final report · May 25, 2023 · N454AB · Substantial damage
  > The pilot’s improper banner pickup approach, which resulted in the banner tow hook contacting the airplane, and the subsequent overload separation of the right rudder control horn, resulting in a loss of airplane control.
- [NTSB ERA23FA239](https://openairdocs.org/ntsb/ERA23FA239.md): Commander 114TC · Palm City, FL · Accident · 1 fatal · Class 3 · Field · Final report · May 21, 2023 · N6042E · Destroyed
  > A loss of engine power for undetermined reasons, and the pilot’s subsequent loss of control, which resulted in impact with terrain.
- [NTSB ERA23LA141](https://openairdocs.org/ntsb/ERA23LA141.md): Cessna 172M · Miami, FL · Accident · No injuries · Class 3 · Limited · Final report · Mar 7, 2023 · N64535 · Substantial damage
  > A total loss of engine power due to a lack of oil lubrication.
- [NTSB ERA23FA138](https://openairdocs.org/ntsb/ERA23FA138.md): Diamond Aircraft Ind DA 40 · West Palm Beach, FL · Accident · 2 fatal · Class 3 · Field · Final report · Mar 6, 2023 · N804ER · Substantial damage
  > The pilots’ exceedance of the airplane’s critical angle of attack following a go-around/low pass over the runway, which resulted in a loss of control and impact with terrain.
- [NTSB ERA23LA073](https://openairdocs.org/ntsb/ERA23LA073.md): Childs Michael A Rotorway Exec 162-F · Titusville, FL · Accident · No injuries · Class 3 · Limited · Final report · Nov 27, 2022 · N8006A · Substantial damage
  > A failure of the No. 4 exhaust valve spring retainer, which resulted in a partial loss of engine power.
- [NTSB ERA23LA066](https://openairdocs.org/ntsb/ERA23LA066.md): Piper PA-18-150 · St. Augustine, FL · Accident · No injuries · Class 3 · Limited · Final report · Nov 14, 2022 · N9858P · Substantial damage
  > The pilot’s failure to appropriately use carburetor heat, which resulted in a total loss of engine power due to carburetor icing.
- [NTSB ERA22FA422](https://openairdocs.org/ntsb/ERA22FA422.md): Wren Ronnie D Titan II · Citra, FL · Accident · 2 fatal · Class 3 · Field · Final report · Sep 17, 2022 · N709RD · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack and failure to maintain airspeed while recovering from an aerobatic maneuver, which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the pilot’s use of…
- [NTSB ERA22FA384](https://openairdocs.org/ntsb/ERA22FA384.md): MXR Technologies MX2 · Osteen, FL · Accident · 2 fatal · Class 3 · Field · Final report · Aug 24, 2022 · N263MX · Substantial damage
  > The pilot’s loss of airplane control while performing aerobatic maneuvers, which resulted in the airplane entering an inverted flat spin that continued until the airplane impacted terrain.
- [NTSB ERA22LA381](https://openairdocs.org/ntsb/ERA22LA381.md): Cessna 182 · Orlando, FL · Accident · No injuries · Class 4 · Limited · Final report · Aug 19, 2022 · N6241A · Substantial damage
  > The pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA22FA344](https://openairdocs.org/ntsb/ERA22FA344.md): Harvey J Brock Tango 2 · Melrose, FL · Accident · 2 fatal · Class 3 · Field · Final report · Jul 30, 2022 · N8680G · Substantial damage
  > A loss of control for undetermined reasons.
- [NTSB ERA22LA340](https://openairdocs.org/ntsb/ERA22LA340.md): Robinson Helicopter R22 Mariner · Hollywood, FL · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 27, 2022 · N42WC · Substantial damage
  > Inadequate maintenance of the helicopter’s tail rotor blades, which resulted in a failure of the tail rotor drive system, and an inflight loss of yaw control from which the flight instructor was unable to recover.
- [NTSB ERA22LA209](https://openairdocs.org/ntsb/ERA22LA209.md): Garlick Helicopters OH-58A+ · Oakland, FL · Accident · Minor injuries · Class 4 · Limited · Final report · Apr 26, 2022 · N281SP · Substantial damage
  > The pilot’s decision to continue the low-altitude aerial application flight over water conditions that degraded his depth perception, which resulted in an inadvertent collision with the water.
- [NTSB ERA22LA206](https://openairdocs.org/ntsb/ERA22LA206.md): Bell 206 · Lake Apopka, FL · Accident · Minor injuries · Class 4 · Limited · Final report · Apr 26, 2022 · N206BX · Substantial damage
  > A collision with water following a loss of visual reference to the water surface due to sun glare.
- [NTSB ERA22LA192](https://openairdocs.org/ntsb/ERA22LA192.md): Bell Helicopter Textron 206B · Cedar Key, FL · Accident · No injuries · Class 4 · Limited · Final report · Apr 18, 2022 · N919AC · Substantial damage
  > The pilot’s improper fuel planning during agricultural spraying operations, which resulted in fuel starvation, a loss of engine power, and a hard landing following an autorotation.
- [NTSB ERA22LA180](https://openairdocs.org/ntsb/ERA22LA180.md): Hughes 269A · Fort White, FL · Accident · Minor injuries · Class 4 · Limited · Final report · Apr 2, 2022 · N7057L · Substantial damage
  > The non-instrument-rated pilot’s decision to fly a visual flight rules only helicopter in instrument meteorological conditions, which resulted in a collision with trees and terrain.
- [NTSB ERA22FA160](https://openairdocs.org/ntsb/ERA22FA160.md): MD Helicopters 369 · Loxahatchee, FL · Accident · 2 fatal · Class 3 · Field · Final report · Mar 18, 2022 · N650AG · Substantial damage
  > The pilot’s failure to maintain clearance from power lines while maneuvering at low altitude.
- [NTSB ERA22LA151](https://openairdocs.org/ntsb/ERA22LA151.md): Cirrus SR22 · The Hammocks, FL · Accident · No injuries · Class 4 · Limited · Final report · Mar 1, 2022 · N21EU · Substantial damage
  > The pilot's failure to maintain an appropriate altitude above obstacles, which resulted controlled flight into a powerline.
- [NTSB ERA22LA131](https://openairdocs.org/ntsb/ERA22LA131.md): Robinson Helicopter R44 · Miami Beach, FL · Accident · Serious injuries · Class 3 · Limited · Final report · Feb 19, 2022 · N544SB · Substantial damage
  > A loss of engine power due to a stuck valve, which resulted in an autorotation and a hard landing in water.
- [NTSB ERA22LA090](https://openairdocs.org/ntsb/ERA22LA090.md): Aerofab Lake LA-4-250 · Auburndale, FL · Accident · 2 fatal · Class 3 · Limited · Final report · Dec 17, 2021 · N1402C · Destroyed
  > A bird strike, which resulted in a loss of control while flying at low altitude over a lake.
- [NTSB ERA22LA080](https://openairdocs.org/ntsb/ERA22LA080.md): Piper PA-12 · Labelle, FL · Accident · Serious injuries · Class 4 · Limited · Final report · Nov 30, 2021 · N3098M · Substantial damage
  > The pilot’s improper fuel system modification, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB ERA22FA056](https://openairdocs.org/ntsb/ERA22FA056.md): Zenith CH601 · Oak Hill, FL · Accident · 1 fatal · Class 3 · Field · Final report · Nov 10, 2021 · N22XF · Destroyed
  > A loss of airplane control while maneuvering at low altitude.
- [NTSB ERA22FA051](https://openairdocs.org/ntsb/ERA22FA051.md): Issitt Greg Sonex · Malone, FL · Accident · 1 fatal · Class 3 · Field · Final report · Nov 8, 2021 · N432SX · Substantial damage
  > An in-flight collision with a tree for reasons that could not be determined.
- [NTSB ERA21FA318](https://openairdocs.org/ntsb/ERA21FA318.md): Pitts 12 · Ocklawaha, FL · Accident · 2 fatal · Class 3 · Field · Final report · Aug 9, 2021 · N112JH · Substantial damage
  > The pilot’s failure to maintain airplane control while performing aerobatic maneuvers, which resulted in an inverted flat spin from which he was unable to recover.
- [NTSB ERA21FA258](https://openairdocs.org/ntsb/ERA21FA258.md): Cessna 150 · Yulee, FL · Accident · 2 fatal · Class 3 · Field · Final report · Jun 18, 2021 · N1300Q · Destroyed
  > The flight instructor’s decision to conduct slow flight training at an altitude below the flight school’s minimum recovery altitude and his delayed remedial action when an aerodynamic stall occurred.

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

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