# NTSB investigations, FL: 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 44 · 2,182 cases

## Latest cases

- [NTSB DCA27LA014](https://openairdocs.org/ntsb/DCA27LA014.md): Boeing 777 · Orlando, FL · Occurrence · No injuries · Class 4 · Limited · Investigation open · Oct 12, 2026 · G-VIIT · No damage
- [NTSB ERA26LA331](https://openairdocs.org/ntsb/ERA26LA331.md): Bell 47G-4A · Alcoma, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Sep 6, 2026 · N797WS · Substantial damage
  > On September 5, 2026, at 1422 eastern daylight time, a Bell 47G-4A, N797WS, was substantially damaged when it was involved in an accident near Alcoma, Florida. The pilot was not injured. The helicopter was operated as a Title 14 Code of Federal Regulations…
- [NTSB ERA26LA316](https://openairdocs.org/ntsb/ERA26LA316.md): Piper PA-18A 150 · New Smyrna Beach, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 27, 2026 · N2368P · Substantial damage
  > On August 27, 2026, about 1051 eastern daylight time, a Piper PA-18A 150, N2368P, was substantially damaged when it was involved in an accident near New Smyrna Beach, Florida. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB ANC26LA084](https://openairdocs.org/ntsb/ANC26LA084.md): Robinson Helicopter R44 II · Anthony, FL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Aug 13, 2026 · N861MP · Substantial damage
  > On August 12, 2026, at approximately 2305 eastern daylight time, a Robinson R44 Raven II helicopter, N861MP, was substantially damaged when it was involved in an accident near Anthony, Florida. The pilot and passenger sustained minor injuries. The helicopter…
- [NTSB DCA26LA286](https://openairdocs.org/ntsb/DCA26LA286.md): Embraer S A ERJ 170-200 LL · Sanford, FL · Accident · Serious injuries · Class 4 · Limited · Final report · Jul 16, 2026 · N271SY · No damage
  > An encounter with convectively induced turbulence during cruise flight in an area of forecast thunderstorm activity.
- [NTSB ANC26LA070](https://openairdocs.org/ntsb/ANC26LA070.md): Mooney M20M · Tallahassee, FL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jul 8, 2026 · N488AT · Substantial damage
  > On July 8, 2026, at 1148 eastern daylight time, a Mooney M20 airplane was substantially damaged when it was involved in an accident near Tallahassee, Florida. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of Federal…
- [NTSB ERA26FA239](https://openairdocs.org/ntsb/ERA26FA239.md): Blessing RV-3A · Lakeland, FL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jun 15, 2026 · N696DB · Substantial damage
  > On June 15, 2026, about 1955 eastern daylight time, an experimental amateur-built Van’s RV-3A, N696DB, was destroyed when it was involved in an accident near Lakeland, Florida. The pilot received fatal injuries. The airplane was operated as a Title 14 Code of…
- [NTSB ERA26LA215](https://openairdocs.org/ntsb/ERA26LA215.md): Textron 172S · Jupiter Farms, FL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · May 22, 2026 · N294PL · Substantial damage
  > On May 22, 2026, about 1518 eastern daylight time, a Textron Aviation 172S, N294PL, was substantially damaged when it was involved in an accident near Jupiter Farms, Florida. The flight instructor and student pilot were not injured. The airplane was operated…
- [NTSB ERA26LA180](https://openairdocs.org/ntsb/ERA26LA180.md): Piper PA-28-181 · Indiantown, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Apr 19, 2026 · N643FT · Substantial damage
  > On April 18, 2026, about 2115 eastern daylight time, a Piper PA-28-181, N643FT, was substantially damaged when it was involved in an accident near Indiantown, Florida. The private pilot was not injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB ERA26FA177](https://openairdocs.org/ntsb/ERA26FA177.md): Rajchl Vladimir Airplane Swing 06 · O'Brien, FL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Apr 16, 2026 · N613SA · Substantial damage
  > On April 16, 2026, about 1030 eastern standard time, a Rajchl Vladimir Airplane Swing 06, N613SA, was substantially damaged when it was involved in an accident near O’Brien, Florida. The private pilot was fatally injured. The airplane was operated as a Title…
- [NTSB ERA26LA167](https://openairdocs.org/ntsb/ERA26LA167.md): Cessna 172S · Marathon, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Apr 11, 2026 · N529ND · 2 aircraft · Substantial damage
  > On April 11, 2026, about 1330 eastern daylight time, a Cessna 172S airplane, N529ND sustained substantial damage and a Raytheon Aircraft Company B200 (King Air) airplane, N699BW sustained minor damage when they collided in flight near Marathon, Florida. The 2…
- [NTSB ERA26LA168](https://openairdocs.org/ntsb/ERA26LA168.md): Piper J3C-65 · Crestview, FL · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Apr 10, 2026 · N92480 · Substantial damage
  > On April 10, 2026, about 1700 eastern daylight time, a Piper J3C-65, N92480 was substantially damaged when it was involved in an accident near Baker, Florida. The pilot sustained minor injuries, and the passenger was seriously injured. The airplane was…
- [NTSB OPS26LA036](https://openairdocs.org/ntsb/OPS26LA036.md): Boeing 737-7CT · Orlando, FL · Incident · Class 4 · Limited · Investigation open · Apr 8, 2026 · N566WN · 3 aircraft · No damage
- [NTSB ERA26LA161](https://openairdocs.org/ntsb/ERA26LA161.md): Piper PA28R · Fellsmere, FL · Accident · No injuries · Class 4 · Limited · Final report · Apr 1, 2026 · N8583N · Substantial damage
  > An in-flight collision with a bird while descending to land at an airport.
- [NTSB ERA26LA158](https://openairdocs.org/ntsb/ERA26LA158.md): Cirrus Design SR22 · Daytona Beach, FL · Accident · Minor injuries · Class 4 · Limited · Final report · Mar 27, 2026 · N41CA · Substantial damage
  > An in-flight collision with a bird while enroute.
- [NTSB ERA26LA142](https://openairdocs.org/ntsb/ERA26LA142.md): Piper PA-28-181 · Chuluota, FL · Accident · No injuries · Class 4 · Limited · Final report · Mar 6, 2026 · N658FT · Substantial damage
  > An in-flight collision with a bird while enroute.
- [NTSB ERA26LA130](https://openairdocs.org/ntsb/ERA26LA130.md): Textron 680A · Miami, FL · Accident · No injuries · Class 4 · Limited · Final report · Feb 27, 2026 · N519QS · Substantial damage
  > The flight crew’s failure to maintain adequate clearance from the blast fence during taxi to the runway for departure, and their inadequate inspection of the airplane after it contacted the blast fence.
- [NTSB ERA26LA118](https://openairdocs.org/ntsb/ERA26LA118.md): Tecnam P2006T · Homestead, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Feb 19, 2026 · N964GV · Substantial damage
  > On February 19, 2026, about 0930 eastern standard time, a Tecnam P2006T, N964GV, was substantially damaged when it was involved in an accident near Miami, Florida. The flight instructor and student pilot were not injured. The flight was conducted under Title…
- [NTSB ERA26LA063](https://openairdocs.org/ntsb/ERA26LA063.md): Cessna 172 · DeLand, FL · Accident · Serious injuries · Class 4 · Limited · Final report · Dec 8, 2025 · N64859 · Substantial damage
  > The flight instructor’s inadequate fuel quantity inspection, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA26LA056](https://openairdocs.org/ntsb/ERA26LA056.md): Piper PA-24-180 · South Brooksville, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Nov 24, 2025 · N8328P · Substantial damage
  > On November 24, 2025, about 1427 eastern standard time, a Piper PA-24-180, N8328P, was substantially damaged during a forced landing near South Brooksville, Florida. The pilot and two passengers were not injured. The airplane was operated as a Title 14 Code…
- [NTSB WPR26FA040](https://openairdocs.org/ntsb/WPR26FA040.md): Beech B100 · Coral Springs, FL · Accident · 2 fatal · Class 3 · Field · Preliminary report · Nov 10, 2025 · N30HG · Destroyed
  > On November 10, 2025, about 1019 eastern standard time, a Beech King Air B100, N30HG, was destroyed when it was involved in an accident near Coral Springs, Florida. The pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code of…
- [NTSB ERA25LA368](https://openairdocs.org/ntsb/ERA25LA368.md): Elmore Travis C Searey · Rotonda West, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Sep 28, 2025 · N2090S · Substantial damage
  > On September 28, 2025, at 1126 eastern daylight time, an experimental, amateur-built Searey, N2090S, was substantially damaged when it was involved in an accident near Stump Pass, Florida. The private pilot sustained minor injuries. The airplane was operated…
- [NTSB ERA25LA377](https://openairdocs.org/ntsb/ERA25LA377.md): Piper PA28R · Okeechobee, FL · Accident · No injuries · Class 4 · Limited · Final report · Sep 27, 2025 · N8586A · Substantial damage
  > Collision with a bird during cruise flight.
- [NTSB ERA25LA350](https://openairdocs.org/ntsb/ERA25LA350.md): Piper PA-28-181 · Astatula, FL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Sep 17, 2025 · N580JA · Substantial damage
  > On September 17, 2025 at 1000 eastern daylight time, a Piper PA-28-181 100i, N580JA, was substantially damaged when it was involved in an accident near Astatula, Florida. The student pilot sustained minor injuries. The airplane was operated as a 14 Code of…
- [NTSB DCA25LA323](https://openairdocs.org/ntsb/DCA25LA323.md): Boeing 737-7H4 · Port Orange, FL · Accident · Serious injuries · Class 4 · Limited · Final report · Sep 12, 2025 · N919WN · No damage
  > An encounter with convective turbulence during descent, which resulted in serious injuries to a flight attendant.
- [NTSB ERA25LA327](https://openairdocs.org/ntsb/ERA25LA327.md): Mark Strout Zenair Zodiac 601HDS · Connerton, FL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Sep 1, 2025 · N680LM · Substantial damage
  > On September 01, 2025 about 1605 eastern standard time, an experimental amateur-built Zenith Zodiac 601 HDS, N680LM, was substantially damaged when it was involved in an accident near Connerton, Florida. The pilot and the passenger received minor injuries.…
- [NTSB DCA25LA312](https://openairdocs.org/ntsb/DCA25LA312.md): Mcdonnell Douglas MD 83 · Miami, FL · Accident · Serious injuries · Class 4 · Limited · Final report · Aug 23, 2025 · N805WA · No damage
  > An encounter with convective turbulence during descent that resulted in a serious injury to a flight attendant.
- [NTSB ERA25LA297](https://openairdocs.org/ntsb/ERA25LA297.md): Piper PA-12 · Ponce Inlet, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 11, 2025 · N2504M · Substantial damage
  > On August 11, 2024, about 1359 easter daylight time, a Piper PA-12, N2504M, was substantially damaged when it was involved in an accident near Ponce Inlet, Florida. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations…
- [NTSB ERA25LA281](https://openairdocs.org/ntsb/ERA25LA281.md): Cessna 172S · Kissimmee, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 30, 2025 · N121CW · Substantial damage
  > On July 30, 2025, at 11:28 eastern daylight time, a Cessna 172S, N121CW, was substantially damaged when it was involved in an accident near Kissimmee, Florida. The private pilot and flight instructor were uninjured. The airplane was operated as a Title 14…
- [NTSB ERA25LA382](https://openairdocs.org/ntsb/ERA25LA382.md): Icon A5 · Destin, FL · Accident · No injuries · Class 4 · Limited · Final report · Jul 26, 2025 · N594BA · Substantial damage
  > The pilot’s inadequate fuel planning, and improper in-flight decision making which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA25LA261](https://openairdocs.org/ntsb/ERA25LA261.md): Cessna 172H · Century, FL · Accident · No injuries · Class 3 · Limited · Final report · Jul 9, 2025 · N3254C · Substantial damage
  > A total loss of engine power for reasons that could not be determined based on available information.
- [NTSB DCA25LA240](https://openairdocs.org/ntsb/DCA25LA240.md): Airbus Industrie A321-211 · Miami, FL · Accident · Serious injuries · Class 4 · Limited · Final report · Jun 22, 2025 · N189UW · No damage
  > The unexpected encounter with a rapidly developing convective cell during climb resulting in convectively induced turbulence on a dark moon-less evening.
- [NTSB ERA25LA200](https://openairdocs.org/ntsb/ERA25LA200.md): Cessna 172 · Florida City, FL · Accident · Minor injuries · Class 3 · Limited · Final report · May 8, 2025 · N5405T · Substantial damage
  > The commercial pilot’s improper fuel management, which resulted in a loss of total engine power due to fuel starvation.
- [NTSB ERA25LA167](https://openairdocs.org/ntsb/ERA25LA167.md): Hiller UH12E · Rockledge, FL · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Apr 6, 2025 · N48263 · Substantial damage
  > On April 6, 2025, about 1020 eastern daylight time, a Hiller UH-12E, N48263, was substantially damaged when it was involved in an accident near Rockledge, Florida. The private pilot and passenger sustained serious injuries. The helicopter was operated as a…
- [NTSB ERA25LA159](https://openairdocs.org/ntsb/ERA25LA159.md): Silvaire Luscombe 8A · New Port Richey, FL · Accident · No injuries · Class 3 · Limited · Final report · Mar 27, 2025 · N28790 · Substantial damage
  > Maintenance personnel’s inadequate inspection of the exhaust system, which allowed exhaust gases to enter the induction system from cracks in the exhaust manifold, resulting in a total loss of engine power and a subsequent forced landing.
- [NTSB ERA25LA142](https://openairdocs.org/ntsb/ERA25LA142.md): Cessna TU206G · Wedgefield, FL · Accident · No injuries · Class 3 · Limited · Final report · Mar 12, 2025 · N27GP · Substantial damage
  > A total loss of engine power as a result of an excessively rich fuel-to-air ratio due to the pilot’s failure to properly lean the engine’s fuel air mixture and the inadvertent activation of the auxiliary fuel pump.
- [NTSB ERA25FA119](https://openairdocs.org/ntsb/ERA25FA119.md): Cessna 208 · Pierson, FL · Accident · 1 fatal · Class 3 · Field · Final report · Feb 14, 2025 · N40EA · Substantial damage
  > The non-instrument-rated pilot’s continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of control.
- [NTSB ERA25LA107](https://openairdocs.org/ntsb/ERA25LA107.md): Aviat Pitts S-2B · Fellsmere, FL · Accident · Class 3 · Limited · Preliminary report · Jan 30, 2025 · N8ZT
  > On January 30, 2025, at 1034 eastern standard time, an Aviat Inc Pitts S-2B, N8ZT, was substantially damaged when it was involved in an accident near Fellsmere, Florida. The private pilot was seriously injured. The airplane was operated as a Title 14 Code of…
- [NTSB ERA25LA084](https://openairdocs.org/ntsb/ERA25LA084.md): Beech BE-76 · Melbourne, FL · Accident · Serious injuries · Class 4 · Limited · Final report · Dec 26, 2024 · N76NN · Substantial damage
  > The pilot’s inadequate preflight fuel planning which resulted in a total loss of engine power due to fuel exhaustion and subsequent forced landing.
- [NTSB ERA25LA079](https://openairdocs.org/ntsb/ERA25LA079.md): Air Tractor AT504 · Big Cypress, FL · Accident · No injuries · Class 3 · Limited · Final report · Dec 18, 2024 · N8516V · Substantial damage
  > The pilot’s decision to depart with cargo outside of the designated baggage compartment, which resulted in the cargo interfering with the rudder control system.
- [NTSB ERA25LA056](https://openairdocs.org/ntsb/ERA25LA056.md): Finn Lassen RV-4 · O'Brien, FL · Accident · No injuries · Class 4 · Limited · Final report · Nov 9, 2024 · N214FL · Substantial damage
  > A total loss of engine power and navigational equipment as a result of a faulty battery.
- [NTSB ERA25LA026](https://openairdocs.org/ntsb/ERA25LA026.md): Cirrus Design SR20 · Sebring, FL · Accident · No injuries · Class 4 · Limited · Final report · Oct 24, 2024 · N50068 · Substantial damage
  > A birdstrike during descent to the destination airport.
- [NTSB ERA25LA006](https://openairdocs.org/ntsb/ERA25LA006.md): Piper PA24 · Moore Haven, FL · Accident · No injuries · Class 4 · Limited · Final report · Oct 3, 2024 · N12RD · Substantial damage
  > The pilot’s failure to initiate the cross country flight with an adequate fuel supply, resulting in a loss of engine power and forced landing due to fuel exhaustion.
- [NTSB ERA25FA001](https://openairdocs.org/ntsb/ERA25FA001.md): Beech 95 · Crystal River, FL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Oct 1, 2024 · N5868S · Destroyed
  > On October 1, 2024, about 1540 eastern daylight time, a Beech 95-B55, N5868S, was destroyed when it collided with terrain near Crystal River, Florida. The private pilot was fatally injured. The personal flight was conducted under the provisions of Title 14…
- [NTSB ERA24FA395](https://openairdocs.org/ntsb/ERA24FA395.md): Evolution Revo · Zephyrhills, FL · Accident · 2 fatal · Class 3 · Field · Final report · Sep 25, 2024 · N889HT · Destroyed
  > The flight instructor’s failure to ensure the haul back cable was securely connected to the “J” hook prior to departing on the accident flight, which resulted in the cable becoming disconnected and the wings folding up during flight.
- [NTSB ERA24LA328](https://openairdocs.org/ntsb/ERA24LA328.md): Piper J3C-65 · Groveland, FL · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 27, 2024 · N77522 · Substantial damage
  > The pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB ERA24LA315](https://openairdocs.org/ntsb/ERA24LA315.md): Cessna 182 · Zephyrhills, FL · Accident · No injuries · Class 3 · Limited · Final report · Jul 18, 2024 · N8523T · Substantial damage
  > The loss of engine power due to the formation of carburetor ice as a result of the pilot’s delayed application of carburetor heat.
- [NTSB ERA24LA235](https://openairdocs.org/ntsb/ERA24LA235.md): Temco/Lazier TT-1 · Laurel Hill, FL · Accident · No injuries · Class 3 · Limited · Final report · Jun 1, 2024 · N4486L · Substantial damage
  > The pilot’s delay in turning on the fuel tip tank transfer pumps after departure, resulting in fuel starvation to the engine, engine flameout, and a subsequent forced landing.
- [NTSB ERA24LA227](https://openairdocs.org/ntsb/ERA24LA227.md): Brallier Scott Glasair I · Gulf of Mexico, FL · Accident · 1 fatal · Class 3 · Limited · Final report · May 26, 2024 · N446KW · Destroyed
  > The non-instrument-rated pilot’s loss of airplane control due to spatial disorientation while flying over water in dark night conditions. Contributing to the accident was the pilot’s decision to conduct the overwater flight in conditions conducive to the…
- [NTSB ERA24LA211](https://openairdocs.org/ntsb/ERA24LA211.md): Piper PA32 · Apopka, FL · Accident · No injuries · Class 3 · Limited · Final report · May 8, 2024 · N908DK · Substantial damage
  > A partial loss of engine power due to sticking exhaust valves. Contributing to the accident was maintenance personnel’s failure to use available engine data while troubleshooting a known engine issue and maintenance personnel’s failure to comply with…

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

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