# NTSB investigations, FL: Approach

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

Page 1 of 24 · 1,192 cases

## Latest cases

- [NTSB ERA26LA300](https://openairdocs.org/ntsb/ERA26LA300.md): Waco Classic 2T-1A-2 · Clermont, FL · Accident · Serious injuries · Class 4 · Limited · Final report · Aug 14, 2026 · N621GL · Destroyed
  > The pilot’s failure to maintain clearance from trees during the landing approach.
- [NTSB ERA26LA171](https://openairdocs.org/ntsb/ERA26LA171.md): Cessna 150 · Naples, FL · Accident · No injuries · Class 4 · Limited · Final report · Apr 12, 2026 · N6586S · Substantial damage
  > The pilot’s inadequate fuel planning, which resulted in fuel exhaustion and a total loss of engine power.
- [NTSB ERA26LA136](https://openairdocs.org/ntsb/ERA26LA136.md): Cessna 551 · Opa-locka, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Mar 4, 2026 · N228MH · Substantial damage
  > On March 4, 2026, about 1648 eastern standard time, a Cessna 551, N228MH, was substantially damaged when it was involved in an accident near Opa-locka, Florida. The two pilots and three passengers were not injured. The airplane was operated as a Title 14 Code…
- [NTSB ERA26LA135](https://openairdocs.org/ntsb/ERA26LA135.md): Cessna 152 · Thonotosassa, FL · Accident · No injuries · Class 4 · Limited · Final report · Mar 3, 2026 · N588BR · 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 ERA26LA113](https://openairdocs.org/ntsb/ERA26LA113.md): Cessna 320C · Bartow, FL · Accident · No injuries · Class 4 · Limited · Final report · Feb 9, 2026 · N3034T · Substantial damage
  > Maintenance personnel’s failure to perform an adequate inspection of the airplane’s landing gear, which resulted in a collapse of the left main landing gear during landing.
- [NTSB ERA26FA110](https://openairdocs.org/ntsb/ERA26FA110.md): Pipistrel Taurus 503 · Boynton Beach, FL · Accident · Serious injuries · Class 3 · Field · Preliminary report · Feb 9, 2026 · N414HG · Substantial damage
  > On February 9, 2026, about 1514 eastern standard time, a Pipistrel Taurus 503 motorglider, N414HG, was substantially damaged when it was involved in an accident at Willis Gliderport (FA44), Boynton Beach, Florida. The pilot was seriously injured. The…
- [NTSB ERA26LA108](https://openairdocs.org/ntsb/ERA26LA108.md): Stinson 108-3 · Palmetto, FL · Accident · No injuries · Class 4 · Limited · Final report · Feb 6, 2026 · N528C · Substantial damage
  > The pilot's inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA26LA082](https://openairdocs.org/ntsb/ERA26LA082.md): Piper PA44 · Pembroke Pines, FL · Accident · No injuries · Class 4 · Limited · Final report · Dec 21, 2025 · N156WM · Substantial damage
  > An in-flight collision with a bird while on approach to the destination airport.
- [NTSB ERA26LA065](https://openairdocs.org/ntsb/ERA26LA065.md): Beech 95-C55 · Cocoa, FL · Accident · Minor injuries · Class 4 · Limited · Final report · Dec 8, 2025 · N95KC · Substantial damage
  > The flight crew’s failure to adequately manage the available fuel onboard the airplane, which resulted in a total loss of power due to fuel starvation.
- [NTSB ERA26LA044](https://openairdocs.org/ntsb/ERA26LA044.md): Cirrus Design SR22 · Eastpoint, FL · Accident · No injuries · Class 4 · Limited · Final report · Nov 17, 2025 · N508WH · Substantial damage
  > The pilot’s loss of airplane control during a go-around, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s improper recovery from an aerodynamic stall.
- [NTSB DCA26FA019](https://openairdocs.org/ntsb/DCA26FA019.md): Air Vev AIR ZERO2 · Indiantown, FL · Accident · No injuries · Class 4 · Field · Final report · Oct 23, 2025 · N514AX · Destroyed
  > A cascading shutoff of multiple aft motors due to a sudden increase in motor loads during maneuvering, resulting in a loss of control.
- [NTSB ERA26LA014](https://openairdocs.org/ntsb/ERA26LA014.md): Cessna 172 · North Lauderdale, FL · Accident · No injuries · Class 4 · Limited · Final report · Oct 13, 2025 · N1206U · Substantial damage
  > A total loss of engine power due to a fuel delivery system leak, which allowed air to enter the fuel system. The source of the leak could not be determined based on the available evidence.
- [NTSB ERA25LA345](https://openairdocs.org/ntsb/ERA25LA345.md): Cessna 172 · Williston, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Sep 13, 2025 · N345QA · Substantial damage
  > On September 13, 2025, about 0733 eastern daylight time, a Cessna 172G, N345QA, was substantially damaged when it was involved in an accident near Williston, Florida. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB ERA25LA266](https://openairdocs.org/ntsb/ERA25LA266.md): Cessna T337G · Pembroke Pines, FL · Accident · Minor injuries · Class 4 · Limited · Final report · Jul 14, 2025 · N289 · Substantial damage
  > The pilot’s inadequate preflight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power to one of the airplane’s two engines. Contributing to the outcome was the pilot’s loading of the airplane beyond its maximum gross…
- [NTSB ERA25LA264](https://openairdocs.org/ntsb/ERA25LA264.md): Cessna 150 · St. Augustine, FL · Accident · No injuries · Class 4 · Limited · Final report · Jul 11, 2025 · N8503G · Substantial damage
  > The pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB DCA25LA238](https://openairdocs.org/ntsb/DCA25LA238.md): Boeing 737-924ER · Fort Myers, FL · Accident · Serious injuries · Class 4 · Limited · Final report · Jun 16, 2025 · N28478 · No damage
  > The airplane’s inadvertent encounter with convective turbulence during descent, which resulted in serious injuries to two flight attendants.
- [NTSB ERA25LA273](https://openairdocs.org/ntsb/ERA25LA273.md): Mooney M20R · New Port Richey, FL · Accident · No injuries · Class 3 · Limited · Final report · Jun 9, 2025 · N9166Z · Substantial damage
  > The pilot's mismanagement of the available fuel, which resulted in fuel starvation and a total loss of engine power.
- [NTSB ERA25LA216](https://openairdocs.org/ntsb/ERA25LA216.md): Cessna 172F · Vero Beach, FL · Accident · Minor injuries · Class 4 · Limited · Final report · Jun 2, 2025 · N5200F · Substantial damage
  > A total loss of engine power for reasons that could not be determined.
- [NTSB ERA25LA380](https://openairdocs.org/ntsb/ERA25LA380.md): Bell Helicopter UH-1D · DeLand, FL · Accident · No injuries · Class 4 · Limited · Final report · Feb 26, 2025 · N849DB · Substantial damage
  > The pilot’s loss of helicopter control during landing approach in strong wind conditions, which resulted in tail rotor contact with the ground during landing.
- [NTSB ERA25LA096](https://openairdocs.org/ntsb/ERA25LA096.md): Piper PA-44-180 · Pompano Beach, FL · Accident · No injuries · Class 4 · Limited · Final report · Jan 10, 2025 · N555HF · Substantial damage
  > The separation of the securing hardware for the right main landing gear upper and lower torque links for undetermined reasons, which prevented extension of the right main landing gear.
- [NTSB ERA25LA072](https://openairdocs.org/ntsb/ERA25LA072.md): Piper PA28 · Pahokee, FL · Accident · No injuries · Class 3 · Limited · Final report · Dec 9, 2024 · N90874 · 2 aircraft · Substantial damage
  > The pilots' failure to see and avoid the other airplane, which resulted in a midair collision during short final approach.
- [NTSB ERA25FA066](https://openairdocs.org/ntsb/ERA25FA066.md): Schleicher ASW24 · Vero Beach, FL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Dec 6, 2024 · N244RW · Substantial damage
  > On December 6, 2024, about 1240 eastern standard time, a Schleicher ASW 24 glider, N244RW, was substantially damaged when it was involved in an accident near Vero Beach, Florida. The pilot was fatally injured. The glider was owned by a local soaring club and…
- [NTSB OPS25LA008](https://openairdocs.org/ntsb/OPS25LA008.md): Boeing 737-832 · Miami, FL · Incident · Class 4 · Limited · Investigation open · Oct 30, 2024 · N385DN · 2 aircraft · No damage
- [NTSB ERA25FA020](https://openairdocs.org/ntsb/ERA25FA020.md): Geisz Gilbert A Lancair 360 · Cross City, FL · Accident · 2 fatal · Class 3 · Field · Final report · Oct 20, 2024 · N510G · Substantial damage
  > The pilot’s exceedance of the critical angle of attack, which resulted in an aerodynamic stall at an altitude too low to recover. Contributing to the accident was the total electrical failure, which likely resulted in a loss of airspeed indication.
- [NTSB ERA25LA003](https://openairdocs.org/ntsb/ERA25LA003.md): Piper PA28 · Tampa Bay, FL · Accident · No injuries · Class 3 · Limited · Final report · Oct 3, 2024 · N8575F · Substantial damage
  > A total loss of engine power in flight due to fuel starvation. Contributing to the accident was the inadequate preflight fuel planning by the student pilot and flight instructor, and the improper inflight fuel management by the student pilot.
- [NTSB ERA24LA341](https://openairdocs.org/ntsb/ERA24LA341.md): Beech 23 · Jacksonville, FL · Accident · No injuries · Class 3 · Limited · Final report · Aug 7, 2024 · N2376L · Substantial damage
  > The pilot’s improper inflight fuel management, which resulted in a total loss of engine power due to fuel starvation while on final approach to land, and the subsequent hard landing, which resulted in separation of the airplane’s landing gear.
- [NTSB ERA24LA263](https://openairdocs.org/ntsb/ERA24LA263.md): Rotorway Exec · Alva, FL · Accident · No injuries · Class 3 · Limited · Final report · Jun 14, 2024 · N99TE · Substantial damage
  > A loss of tail rotor control as a result of unsecured tail rotor drive belt tensioner bolts.
- [NTSB ERA24LA256](https://openairdocs.org/ntsb/ERA24LA256.md): Zenith 701 · Ocala, FL · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 8, 2024 · N643E · Substantial damage
  > The pilot’s failure to maintain aircraft control and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and spin during an attempted go-around.
- [NTSB DCA24LA195](https://openairdocs.org/ntsb/DCA24LA195.md): Airbus A330 · Orlando, FL · Incident · Minor injuries · Class 4 · Limited · Investigation open · May 18, 2024 · EI-GCF
- [NTSB ERA24LA208](https://openairdocs.org/ntsb/ERA24LA208.md): Admore International Jets Aircam · DeLand, FL · Accident · Serious injuries · Class 3 · Limited · Final report · May 2, 2024 · N848HP · Substantial damage
  > The uncommanded movement of the left propeller into reverse during approach for undetermined reasons, resulting in an in-flight loss of control of the airplane at low altitude during approach.
- [NTSB ERA24LA198](https://openairdocs.org/ntsb/ERA24LA198.md): Cessna 172 · Palatka, FL · Accident · No injuries · Class 3 · Limited · Final report · Apr 29, 2024 · N99442 · Substantial damage
  > The failure of the nose oil seal to remain secure in the engine crankcase, which resulted in a loss of engine oil and partial loss of engine power.
- [NTSB ERA24FA157](https://openairdocs.org/ntsb/ERA24FA157.md): Piper PA-44-180 · Fort Pierce North, FL · Accident · 1 fatal · Class 3 · Field · Final report · Mar 30, 2024 · N595ND · Substantial damage
  > The flight instructor’s failure to maintain control of the multiengine airplane after a partial loss of engine power on one engine during a go-around, which resulted in an aerodynamic stall. Contributing to the accident was the mechanic’s failure to check the…
- [NTSB ERA24FA154](https://openairdocs.org/ntsb/ERA24FA154.md): Mooney M20K · St. Augustine, FL · Accident · 2 fatal · Class 3 · Field · Final report · Mar 25, 2024 · N4387W · Substantial damage
  > The pilot’s failure to maintain adequate airspeed of the airplane while in the traffic pattern, which resulted in an aerodynamic stall/spin. Contributing was the pilot’s distraction due to the in-flight opening of the main cabin door, which resulted from the…
- [NTSB ERA24LA126](https://openairdocs.org/ntsb/ERA24LA126.md): Cirrus Design SR20 · Key Largo, FL · Accident · Serious injuries · Class 3 · Limited · Final report · Mar 1, 2024 · N1108T · Substantial damage
  > The pilot’s improper go-around technique, which resulted in an aerodynamic stall at an altitude too low for recovery.
- [NTSB ERA24FA110](https://openairdocs.org/ntsb/ERA24FA110.md): Bombardier CL-600-2B16 · Naples, FL · Accident · 2 fatal · Class 3 · Field · Final report · Feb 9, 2024 · N823KD · Destroyed
  > Corrosion of both engines’ variable geometry (VG) system components, which led to their operation in an off-schedule position and resulted in near-simultaneous sub-idle rotating compressor stalls on approach, subsequent loss of thrust in both engines, and an…
- [NTSB ERA24FA104](https://openairdocs.org/ntsb/ERA24FA104.md): Beech V35 · Clearwater, FL · Accident · 3 fatal · Class 3 · Field · Final report · Feb 2, 2024 · N6659L · Destroyed
  > An in-flight engine compartment fire due to a partially loose flexible fuel hose b-nut at the fuel metering unit. Contributing to the severity of the accident was the pilot’s inability to visually identify the destination airport at night, which prolonged the…
- [NTSB ERA24LA079](https://openairdocs.org/ntsb/ERA24LA079.md): Robinson Helicopter R44 · Daytona Beach, FL · Accident · No injuries · Class 4 · Limited · Final report · Dec 30, 2023 · N828AK · 2 aircraft · Substantial damage
  > The UAS operator’s failure to operate within the limitations of the COA that he was using to operate inside class C airspace, which resulted in a collision between the UAS and the helicopter.
- [NTSB ERA24LA068](https://openairdocs.org/ntsb/ERA24LA068.md): Cirrus Design SR20 · Pahokee, FL · Accident · Minor injuries · Class 4 · Limited · Final report · Dec 18, 2023 · N875SB · Substantial damage
  > The flight instructor’s failure to maintain control of the airplane after encountering a wind gust during landing.
- [NTSB ENG23LA033](https://openairdocs.org/ntsb/ENG23LA033.md): Airbus A320 · Jacksonville, FL · Incident · No injuries · Class 3 · Limited · Final report · Aug 3, 2023 · N649JB · No damage
  > The loss of both Integrated Drive Generators (IDG) due to worn fixed cylinder block bores, which caused the IDGs to be tripped offline and caused the airplane to enter an emergency electrical configuration.
- [NTSB ERA23LA206](https://openairdocs.org/ntsb/ERA23LA206.md): Thatcher CX4 · West Palm Beach, FL · Accident · Serious injuries · Class 3 · Limited · Final report · Apr 24, 2023 · N7555X · Substantial damage
  > The loss of engine power due to fuel exhaustion.
- [NTSB ERA23LA197](https://openairdocs.org/ntsb/ERA23LA197.md): Cessna 177RG · Crestview, FL · Accident · Serious injuries · Class 3 · Limited · Final report · Apr 14, 2023 · N7542V · Substantial damage
  > The total loss of engine power due to the loosening and separation of the No. 1 connecting rod cap nuts in flight, resulting in catastrophic internal engine damage. Contributing to the accident was the pilot/owner’s failure to comply with the engine…
- [NTSB ERA23LA187](https://openairdocs.org/ntsb/ERA23LA187.md): Lewis/Urmston RV 4 200 · Cedar Key, FL · Accident · Serious injuries · Class 4 · Limited · Final report · Apr 7, 2023 · N8DU · Substantial damage
  > The pilot’s inadequate compensation for gusting wind conditions while landing, which resulted in a loss of directional control.
- [NTSB ERA23FA142](https://openairdocs.org/ntsb/ERA23FA142.md): Piper J3C · Winter Haven, FL · Accident · 4 fatal · Class 3 · Field · Final report · Mar 7, 2023 · N10510 · 2 aircraft · Substantial damage
  > The failure of both flight crews to see and avoid each other while operating in the airport environment.
- [NTSB DCA23LA179](https://openairdocs.org/ntsb/DCA23LA179.md): Boeing 737-823 · Sarasota, FL · Incident · No injuries · Class 3 · Limited · Final report · Feb 17, 2023 · N976NN · 2 aircraft · No damage
  > The local controller’s failure to prioritize and properly monitor the runway and airport environment along with his erroneous assumption that ROU 1633 would depart from runway 14 before AAL2172 arrived to land on the same runway, which resulted in a loss of…
- [NTSB ERA23LA167](https://openairdocs.org/ntsb/ERA23LA167.md): Champion 7FC · Winter Haven, FL · Accident · No injuries · Class 4 · Limited · Final report · Oct 24, 2022 · N6ND · Substantial damage
  > The pilot’s failure to properly secure the rear seat headset, resulting in an obstruction of the airplane’s rudder controls.
- [NTSB ERA23FA023](https://openairdocs.org/ntsb/ERA23FA023.md): Peryera Adventura II · Miramar, FL · Accident · 2 fatal · Class 3 · Field · Final report · Oct 17, 2022 · N32856 · Substantial damage
  > The pilot’s failure to remove the ECU select switch per the manufacturer’s service bulletin, which resulted in a loss of engine power.
- [NTSB ERA23LA011](https://openairdocs.org/ntsb/ERA23LA011.md): Bell Textron Canada 505 · Fort Myers, FL · Accident · Serious injuries · Class 3 · Limited · Final report · Oct 8, 2022 · N5DF · Substantial damage
  > The pilot’s execution of a landing approach with a right, quartering tailwind, low forward airspeed, and high power demand that, when combined, resulted in a loss of tail rotor effectiveness and helicopter control.
- [NTSB ERA22LA404](https://openairdocs.org/ntsb/ERA22LA404.md): Cirrus Design SF50 · Saint Cloud, FL · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 9, 2022 · N77VJ · Substantial damage
  > The pilot’s continuation of the instrument approach into known extreme precipitation and turbulence associated with a thunderstorm, resulting in excessive altitude deviations that required him to activate the Cirrus Airframe Parachute System.
- [NTSB ERA22LA394](https://openairdocs.org/ntsb/ERA22LA394.md): Sutphin John E Rans S-12 · Hilliard, FL · Accident · Minor injuries · Class 4 · Limited · Final report · Aug 31, 2022 · N8028W · Substantial damage
  > The pilot’s failure to maintain an adequate airspeed, which resulted in an aerodynamic stall.
- [NTSB ERA22LA332](https://openairdocs.org/ntsb/ERA22LA332.md): Whitten Robinson Aventura II · Meritt Island, FL · Accident · Serious injuries · Class 4 · Limited · Final report · Jul 23, 2022 · N709CW · Substantial damage
  > The pilot’s failure to maintain control of the airplane during final approach to land, which resulted in an exceedance of the airplane’s critical angle of attack, aerodynamic stall, and collision with a fence and terrain.

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

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