# NTSB investigations, FL: Initial climb

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 25 · 1,238 cases

## Latest cases

- [NTSB ERA26FA326](https://openairdocs.org/ntsb/ERA26FA326.md): Maclura Evolution · Tampa, FL · Accident · 2 fatal · Class 3 · Field · Preliminary report · Sep 3, 2026 · N305PV · Destroyed
  > On September 3, 2026, about 0815 eastern daylight time, an experimental, amateur-built Evolution airplane, N305PV, was destroyed when it was involved in an accident near Tampa, Florida. The commercial pilot and passenger were fatally injured. The airplane was…
- [NTSB ERA26LA319](https://openairdocs.org/ntsb/ERA26LA319.md): Piper PA22 · Pace, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 29, 2026 · N5731D · Substantial damage
  > On August 29, 2026, about 1030 central daylight time, a Piper PA-22-150, N5731D, was substantially damaged when it was involved in an accident near Pace, Florida. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations…
- [NTSB ERA26LA258](https://openairdocs.org/ntsb/ERA26LA258.md): Portzline Joan M Flight Star II SC · Mulberry, FL · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jul 4, 2026 · N432JP · Substantial damage
  > On July 4, 2026, about 1121 eastern daylight time, an experimental amateur-built Flight Star II SC airplane, N432JP, was substantially damaged when it was involved in an accident near Mulberry, Florida. The private pilot and a passenger were seriously…
- [NTSB ERA26LA221](https://openairdocs.org/ntsb/ERA26LA221.md): Cessna 172P · Pembroke Pines, FL · Accident · Serious injuries · Class 3 · Limited · Preliminary report · May 29, 2026 · N96100 · Substantial damage
  > On May 29, 2026, at 1138 eastern daylight time, a Cessna 172P, N96100, was substantially damaged when it was involved in an accident near Pembroke Pines, Florida. The flight instructor sustained serious injuries. The student pilot sustained minor injuries.…
- [NTSB ERA26FA179](https://openairdocs.org/ntsb/ERA26FA179.md): Cessna 401B · Land O' Lakes, FL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Apr 19, 2026 · N122AT · Destroyed
  > On April 19, 2026, about 0834 eastern daylight time, a Cessna 401B, N122AT, was destroyed when it was involved in an accident near Land O’ Lakes, Florida. The commercial pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB ERA26LA149](https://openairdocs.org/ntsb/ERA26LA149.md): Piper PA-28-181 · Sanford, FL · Accident · No injuries · Class 4 · Limited · Final report · Mar 6, 2026 · N697LH · Substantial damage
  > An in-flight collision with a bird during initial climb.
- [NTSB ERA26LA091](https://openairdocs.org/ntsb/ERA26LA091.md): Piper PA-28-180 · Port St. Lucie, FL · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jan 11, 2026 · N6516J · Substantial damage
  > On January 10, 2026, about 1925 eastern standard time, a Piper PA-28-180, N6516J was substantially damaged when it was involved in an accident near Port St. Lucie, Florida. The pilot and passenger sustained serious injuries. The airplane was operated as a…
- [NTSB ERA26LA062](https://openairdocs.org/ntsb/ERA26LA062.md): Cessna 172 · Pensacola, FL · Accident · Minor injuries · Class 4 · Limited · Final report · Dec 7, 2025 · N6542H · Substantial damage
  > The pilot’s exceedance of the critical angle of attack during initial climb which resulted in an aerodynamic stall.
- [NTSB ERA26LA023](https://openairdocs.org/ntsb/ERA26LA023.md): Cessna 152 · St. Augustine, FL · Accident · Minor injuries · Class 4 · Limited · Final report · Oct 23, 2025 · N95005 · Substantial damage
  > The student pilot’s failure to properly set the elevator trim prior to takeoff, which resulted in her inability to effectively control the airplane’s pitch and a collision with trees at the end of the runway during initial climb.
- [NTSB ERA25LA369](https://openairdocs.org/ntsb/ERA25LA369.md): Gregory A Spicola AR-1 · Fort Myers, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Sep 28, 2025 · N107AR · Substantial damage
  > On September 28, 2025, about 1000 EST, a Spicola AR-1 gyroplane, N107AR, was substantially damaged when it was involved in an accident at Buckingham Field Airport (FL59), Lehigh Acres, Florida. The commercial pilot and pilot-rated passenger were not injured.…
- [NTSB ERA25LA324](https://openairdocs.org/ntsb/ERA25LA324.md): Cessna 172 · New Smyrna Beach, FL · Accident · Minor injuries · Class 4 · Limited · Final report · Aug 29, 2025 · N1607F · Substantial damage
  > Maintenance personnel’s failure to detect and address water contamination of the airplane’s fuel system, which resulted in a total loss of engine power during initial climb.
- [NTSB ERA25LA301](https://openairdocs.org/ntsb/ERA25LA301.md): Cessna 560XL · Oakland Park, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 14, 2025 · N802TD · Substantial damage
  > On August 14, 2025, about 1715 eastern daylight time, a Cessna 560XL, N802TD, was substantially damaged when it was involved in an accident near Oakland Park, Florida. The airline transport pilot and commercial pilot were not injured. The airplane was…
- [NTSB ERA25LA278](https://openairdocs.org/ntsb/ERA25LA278.md): Orlican S R O M-8 Eagle · Lake Worth Beach, FL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jul 28, 2025 · N974FL · Substantial damage
  > On July 28, 2025, about 16:24 eastern daylight time, an Orlican M-8, N974FL, was substantially damaged when it was involved in an accident near Lake Worth Beach, Florida. The flight instructor sustained minor injuries, the private pilot sustained no injuries,…
- [NTSB ERA25LA256](https://openairdocs.org/ntsb/ERA25LA256.md): Kyle Koncak Aventura II · DeLand, FL · Accident · Serious injuries · Class 4 · Limited · Final report · Jul 3, 2025 · N508K · Substantial damage
  > The uncertificated pilot’s failure to remove an improvised gust lock which resulted in a loss of aircraft control at an altitude too low to recover.
- [NTSB ERA25LA235](https://openairdocs.org/ntsb/ERA25LA235.md): Cessna R182 · Milton, FL · Accident · No injuries · Class 3 · Limited · Final report · Jun 23, 2025 · N262AL · Substantial damage
  > Separation of the throttle cable sleeve during takeoff, which resulted an uncommanded engine power reduction and the pilot’s inability to control the engine throttle, and resulted in a forced landing.
- [NTSB DCA25LA234](https://openairdocs.org/ntsb/DCA25LA234.md): Boeing 737-7H4 · Ebro, FL · Accident · Serious injuries · Class 4 · Limited · Final report · Jun 14, 2025 · N969WN · No damage
  > The airplane’s encounter with convective turbulence during climb while diverting to an alternate airport, resulting in a serious injury to a passenger who disregarded the flight crew’s illuminated seat belt sign and the cabin crew’s instruction to remain…
- [NTSB ERA25FA201](https://openairdocs.org/ntsb/ERA25FA201.md): Piper PA32RT · Yulee, FL · Accident · 1 fatal · Class 3 · Field · Final report · May 10, 2025 · N30689 · Destroyed
  > The pilot’s exceedance of the airplane’s critical angle of attack during takeoff, which resulted in a stall/spin at an altitude too low for recovery. Contributing to the accident was the opening of the nose baggage door and subsequent distraction of the pilot…
- [NTSB ERA25LA194](https://openairdocs.org/ntsb/ERA25LA194.md): Cessna 172 · Hastings, FL · Accident · Minor injuries · Class 4 · Limited · Final report · May 3, 2025 · N127EP · Substantial damage
  > The pilot’s inadequate preflight inspection, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB ERA25LA207](https://openairdocs.org/ntsb/ERA25LA207.md): Piper PA-18-150 · Winter Haven, FL · Accident · No injuries · Class 4 · Limited · Final report · Mar 29, 2025 · N38BS · Substantial damage
  > The pilot’s inadvertent movement of the fuel selector to a position that restricted fuel flow to the engine, which resulted in the loss of engine power during takeoff.
- [NTSB ERA25LA155](https://openairdocs.org/ntsb/ERA25LA155.md): Cirrus Design SF50 · Kissimmee, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Mar 24, 2025 · N56GY · Substantial damage
  > On March 24, 2025 about 0804 eastern daylight time, a Cirrus Design Corporation SF50, N56GY, was substantially damaged when it was involved in an accident at Kissimmee Gateway Airport (ISM), Orlando, Florida. The commercial pilot was not injured. The airplane…
- [NTSB ERA25LA149](https://openairdocs.org/ntsb/ERA25LA149.md): Cessna 162 · Miami, FL · Accident · No injuries · Class 4 · Limited · Final report · Mar 19, 2025 · N62PT · Substantial damage
  > The student pilot’s failure to maintain control of the airplane during a go-around, which resulted in an aerodynamic stall.
- [NTSB ERA25LA147](https://openairdocs.org/ntsb/ERA25LA147.md): Champion 7AC · Palmetto, FL · Accident · Serious injuries · Class 4 · Limited · Final report · Mar 18, 2025 · N1369E · Substantial damage
  > The flight instructor’s inability to overpower control inputs made by the student pilot during initial climb, which resulted in the airplane impacting powerlines and the ground.
- [NTSB ERA25LA141](https://openairdocs.org/ntsb/ERA25LA141.md): Piper PA-28-181 · Hollywood, FL · Accident · Minor injuries · Class 3 · Limited · Final report · Mar 12, 2025 · N3055B · Substantial damage
  > A total loss of engine power was due to a fracture of the crankshaft at the No. 3 main journal, which originated from a preexisting, thermally induced crack that had gone undetected by maintenance personnel during an inspection performed as part of the…
- [NTSB ERA25LA035](https://openairdocs.org/ntsb/ERA25LA035.md): Piper PA28 · Merritt Island, FL · Accident · No injuries · Class 3 · Limited · Final report · Oct 5, 2024 · N207AB · Substantial damage
  > A worn fuel selector valve, which resulted in a restriction of fuel flow to the engine and a total loss of engine power due to fuel starvation.
- [NTSB ERA24LA384](https://openairdocs.org/ntsb/ERA24LA384.md): Cessna 172L · DeLand, FL · Accident · No injuries · Class 4 · Limited · Final report · Sep 17, 2024 · N19703 · Substantial damage
  > The parachutist’s failure to control his canopy which resulted in a downwind landing, an overshoot of the drop zone, and collision with a departing airplane.
- [NTSB ERA24LA330](https://openairdocs.org/ntsb/ERA24LA330.md): Raytheon A36 · Naples, FL · Accident · No injuries · Class 3 · Limited · Final report · Jul 29, 2024 · N934PC · Substantial damage
  > Contamination of the airplane’s fuel system with debris, which resulted in restricted fuel flow through multiple fuel injectors and the subsequent partial loss of engine power.
- [NTSB ERA24FA300](https://openairdocs.org/ntsb/ERA24FA300.md): Piper PA-28-161 · Palm Beach Gardens, FL · Accident · 2 fatal · Class 3 · Field · Final report · Jul 10, 2024 · N81250 · Substantial damage
  > A loss of engine power for reasons that could not be determined.
- [NTSB ERA24LA279](https://openairdocs.org/ntsb/ERA24LA279.md): Alexander S Rolinski Aventura II · DeLand, FL · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 26, 2024 · N727TK · Substantial damage
  > Improper installation of the electric-driven fuel pump inlet hoses, which resulted in a hose failure and subsequent loss of engine power due to fuel starvation.
- [NTSB ERA24LA257](https://openairdocs.org/ntsb/ERA24LA257.md): Piper PA28 · Zephyrhills, FL · Accident · No injuries · Class 3 · Limited · Final report · Jun 8, 2024 · N15363 · Substantial damage
  > A partial loss of engine power during initial climb due to fuel contamination that resulted from corrosion and loose corrosion debris in the carburetor, which restricted fuel flow to the engine.
- [NTSB ERA24LA185](https://openairdocs.org/ntsb/ERA24LA185.md): Bailey-Moyes Dragonfly · Groveland, FL · Accident · 1 fatal · Class 3 · Limited · Final report · Apr 19, 2024 · UNREG · Substantial damage
  > The pilot’s improper installation and inspection of the right lower wing strut attachment bolt, which resulted in the inflight failure of the right wing.
- [NTSB ERA24FA160](https://openairdocs.org/ntsb/ERA24FA160.md): Arthur B Canning Merlin Lite · Mulberry, FL · Accident · 1 fatal · Class 3 · Field · Final report · Apr 2, 2024 · N622PC · Substantial damage
  > The pilot/builder’s modifications of the motorglider’s engine, which resulted in an excessively lean fuel air mixture, preignition, piston failure, and a subsequent total loss of engine power during the initial climb. Contributing to the outcome was the…
- [NTSB ERA24LA214](https://openairdocs.org/ntsb/ERA24LA214.md): Beech 95B55 · St. Augustine, FL · Accident · No injuries · Class 3 · Limited · Final report · Apr 1, 2024 · N7371R · Substantial damage
  > The incomplete extension of the landing gear into the down-and-locked position for reasons that could not be determined..
- [NTSB ERA24LA153](https://openairdocs.org/ntsb/ERA24LA153.md): Denzil Velarde MTO Sport · Tavernier, FL · Accident · Minor injuries · Class 3 · Limited · Final report · Mar 24, 2024 · N291AG · Substantial damage
  > The gyroplane’s encounter with a tailwind during the initial climb, which resulted in a loss of airspeed and subsequent forced landing.
- [NTSB ERA24LA135](https://openairdocs.org/ntsb/ERA24LA135.md): Cessna 172 · Homestead, FL · Accident · Minor injuries · Class 3 · Limited · Final report · Mar 9, 2024 · N5171H · Substantial damage
  > A loss of engine power due to carburetor ice as a result of the pilot’s failure to use carburetor heat in conditions conducive to the formation of carburetor ice.
- [NTSB ERA24LA070](https://openairdocs.org/ntsb/ERA24LA070.md): Beech A24 · Miami, FL · Accident · No injuries · Class 3 · Limited · Final report · Dec 18, 2023 · N52LV · Substantial damage
  > A partial loss of engine power during initial climb for undetermined reasons, resulting in a forced landing.
- [NTSB ERA24LA059](https://openairdocs.org/ntsb/ERA24LA059.md): Cessna 172 · Zephyrhills, FL · Accident · Serious injuries · Class 3 · Limited · Final report · Dec 7, 2023 · N906KS · Substantial damage
  > An aerodynamic stall from which the pilots did not recover while maneuvering in the airport traffic pattern.
- [NTSB ERA24LA033](https://openairdocs.org/ntsb/ERA24LA033.md): Cessna 172S · Orlando, FL · Accident · Minor injuries · Class 3 · Limited · Final report · Nov 10, 2023 · N91PF · Substantial damage
  > A partial loss of engine power during initial climb after takeoff for undetermined reasons.
- [NTSB ERA24LA022](https://openairdocs.org/ntsb/ERA24LA022.md): Mooney M20E · Pembroke Pines, FL · Accident · Serious injuries · Class 3 · Limited · Final report · Oct 26, 2023 · N1953Y · Substantial damage
  > The pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel contamination.
- [NTSB ERA23LA365](https://openairdocs.org/ntsb/ERA23LA365.md): Sheehan Kevin A Vans RV-8 · Umatilla, FL · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 5, 2023 · N772KS · Substantial damage
  > A total loss of engine power for reasons that could not be determined.
- [NTSB ERA23FA352](https://openairdocs.org/ntsb/ERA23FA352.md): Eurocopter EC135 · Pompano Beach, FL · Accident · 2 fatal · Class 3 · Field · Final report · Aug 28, 2023 · N109BC · Destroyed
  > An inflight fire outside of the engine firewalls, likely from overheating of the No. 1 engine for undetermined reasons, which resulted in a partial tailboom separation.
- [NTSB ERA23LA324](https://openairdocs.org/ntsb/ERA23LA324.md): Jamros Robert L JR Challenger II · Port Orange, FL · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 4, 2023 · N906WV · Substantial damage
  > The total loss of engine power due to an out-of-temperature seizure of the PTO cylinder.
- [NTSB ERA23FA323](https://openairdocs.org/ntsb/ERA23FA323.md): Cessna 172 · Pembroke Pines, FL · Accident · 2 fatal · Class 3 · Field · Final report · Aug 4, 2023 · N697FL · Substantial damage
  > The flight instructor’s exceedance of the airplane’s critical angle of attack during the initial climb, which resulted in an aerodynamic stall and subsequent rapid descent into terrain.
- [NTSB ERA23FA247](https://openairdocs.org/ntsb/ERA23FA247.md): Cessna 172 · Lake Worth, FL · Accident · 2 fatal · Class 3 · Field · Final report · May 26, 2023 · N3KV · Destroyed
  > Maintenance personnel’s failure to detect the corroded aileron cable during recent inspections, which resulted in the separation of the aileron control cable and a subsequent loss of airplane control during takeoff.
- [NTSB ERA23FA234](https://openairdocs.org/ntsb/ERA23FA234.md): Piper PA-25-235 · Hollywood, FL · Accident · 1 fatal · Class 3 · Field · Final report · May 17, 2023 · N430AB · Destroyed
  > The pilot’s exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and loss of aircraft control.
- [NTSB ERA23FA185](https://openairdocs.org/ntsb/ERA23FA185.md): Piper PA-32-260 · Sebastian, FL · Accident · 1 fatal · Class 3 · Field · Final report · Apr 7, 2023 · N44588 · Substantial damage
  > The pilot’s failure to maintain airplane control during recovery from a bounced landing, which resulted in the exceedance of the airplane’s critical angle of attack and an aerodynamic stall.
- [NTSB ERA23FA181](https://openairdocs.org/ntsb/ERA23FA181.md): Piper PA32R · Venice, FL · Accident · 4 fatal · Class 3 · Field · Final report · Apr 6, 2023 · N635BD · Destroyed
  > The pilot’s decision to initiate a visual flight rules flight into dark night conditions, which resulted in spatial disorientation during the initial climb and subsequent steep banking descent into water.
- [NTSB ERA23LA124](https://openairdocs.org/ntsb/ERA23LA124.md): Canton Paul A RV-6 · Milton, FL · Accident · Serious injuries · Class 3 · Limited · Final report · Feb 6, 2023 · N330PC · Substantial damage
  > The incorrect installation of the fuel pickups, which resulted in a total loss of engine power due to fuel starvation. Contributing was the lack of documentation of the airplane’s unusable fuel.
- [NTSB ERA23FA079](https://openairdocs.org/ntsb/ERA23FA079.md): Piper PA28 · Venice, FL · Accident · 3 fatal · Class 3 · Field · Final report · Dec 4, 2022 · N4676F · Substantial damage
  > The pilot’s spatial disorientation during takeoff in dark night visual meteorological conditions, which resulted in his failure to maintain a positive rate of climb and a subsequent descent into the water.
- [NTSB ERA23LA040](https://openairdocs.org/ntsb/ERA23LA040.md): Piper PA-32RT-300T · Lake Worth, FL · Accident · Minor injuries · Class 3 · Limited · Final report · Oct 23, 2022 · N39628 · Substantial damage
  > A loss of engine power for reasons that could not be determined.
- [NTSB ERA22LA322](https://openairdocs.org/ntsb/ERA22LA322.md): Vans RV10 · Palatka, FL · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 18, 2022 · N910BW · Substantial damage
  > Total loss of engine power due to the improper installation of an electronic ignition system connector plug.

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

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