# NTSB investigations, FL: Takeoff NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports. Page 1 of 15 · 716 cases ## Latest cases - [NTSB ERA27LA019](https://openairdocs.org/ntsb/ERA27LA019.md): Cessna A185F · Tavares, FL · Accident · No injuries · Class 3 · Limited · Investigation open · Oct 19, 2026 · N900JB - [NTSB ERA26LA342](https://openairdocs.org/ntsb/ERA26LA342.md): Cessna 172N · Panama City, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Sep 7, 2026 · N734NM · Substantial damage > On September 7, 2026, about 1059 central daylight time, a Cessna 172N airplane, N734NM, was substantially damaged when it was involved in an accident near Panama City, Florida. The student pilot and flight instructor were not injured. The airplane was… - [NTSB CEN26FA310](https://openairdocs.org/ntsb/CEN26FA310.md): Mooney M20F · Titusville, FL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Sep 7, 2026 · N9546M · Substantial damage > On September 7, 2026, about 1015 eastern daylight time, a Mooney M20F airplane, N9546M, was destroyed when it was involved in an accident near Titusville, Florida. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB ERA26LA244](https://openairdocs.org/ntsb/ERA26LA244.md): Cessna 182S · Naples, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 20, 2026 · N7270H · Substantial damage > On June 20, 2026 at 1030 eastern daylight time, a Cessna 182S, N7270H, was substantially damaged when it was involved in an accident near Naples, Florida. The pilot and three passengers were uninjured. The airplane was operated as a Title 14 Code of Federal… - [NTSB ANC26LA053](https://openairdocs.org/ntsb/ANC26LA053.md): Piper PA-28-235 · Key West, FL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jun 14, 2026 · N15564 · Substantial damage > On June 14, 2026, at 1035 eastern standard time, a Piper PA-28-235 airplane, N15564, was substantially damaged when it was involved in an accident near Key West, Florida. The pilot was not injured and the passenger sustained minor injuries. The airplane was… - [NTSB ERA26FA230](https://openairdocs.org/ntsb/ERA26FA230.md): Cessna 150 · Kissimmee, FL · Accident · Serious injuries · Class 3 · Field · Preliminary report · Jun 6, 2026 · N156KA · Substantial damage > On June 6, 2026, about 1458 eastern daylight time, a Cessna 150L, N156KA, was substantially damaged when it was involved in an accident near Kissimmee Gateway Airport (ISM), Kissimmee, Florida. The commercial pilot and student pilot were seriously injured.… - [NTSB ERA26LA226](https://openairdocs.org/ntsb/ERA26LA226.md): Piper PA44 · Opa-locka, FL · Accident · No injuries · Class 4 · Limited · Investigation open · Jun 2, 2026 · N156WM · Substantial damage - [NTSB ERA26LA186](https://openairdocs.org/ntsb/ERA26LA186.md): Cessna 172M · Crystal River, FL · Accident · No injuries · Class 4 · Limited · Investigation open · Apr 22, 2026 · N868SA · Substantial damage - [NTSB ERA26LA172](https://openairdocs.org/ntsb/ERA26LA172.md): Dehavilland DHC-3 · Dry Tortugas, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Apr 11, 2026 · N708KA · Substantial damage > On April 11, 2026, about 0845 eastern daylight time, an amphibious DeHavilland DHC-3, N708KA, was substantially damaged when it was involved in an accident near Dry Tortugas, Florida. The pilot was not injured. The airplane was operated as a Title 14 Code of… - [NTSB ERA26LA159](https://openairdocs.org/ntsb/ERA26LA159.md): Cessna 172M · Lakeland, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Apr 5, 2026 · N61972 · Substantial damage > On April 05, 2026, at 0007 eastern daylight time, a Cessna 172M airplane, N61972, was substantially damaged when it was involved in an accident near Lakeland, Florida. The pilot and certified flight instructor (CFI) rated passenger were uninjured. The… - [NTSB ERA26LA153](https://openairdocs.org/ntsb/ERA26LA153.md): Textron T206H · Fort Myers, FL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Mar 21, 2026 · N2469H · Substantial damage > On March 21, 2026, about 0905 eastern daylight time, a Cessna T206H, N2469H, was substantially damaged when it was involved in an accident near Fort Myers, Florida. The pilot and four passengers sustained minor injuries. The airplane was operated as a Title… - [NTSB ERA26LA131](https://openairdocs.org/ntsb/ERA26LA131.md): Cessna 150L · Okeechobee, FL · Accident · No injuries · Class 4 · Limited · Final report · Mar 1, 2026 · N10310 · Substantial damage > The pilot’s failure to maintain airplane control during takeoff, which resulted in a runway excursion and collision with terrain. - [NTSB ERA26LA119](https://openairdocs.org/ntsb/ERA26LA119.md): Tabor W Coates AR-1 · Kissimmee, FL · Accident · No injuries · Class 4 · Limited · Final report · Feb 17, 2026 · N220SM · Substantial damage > The pilot’s failure to obtain the proper rotor rpm during the takeoff roll which resulted in a loss of control. - [NTSB ERA26LA116](https://openairdocs.org/ntsb/ERA26LA116.md): Cessna 182G · Quail Heights, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Feb 16, 2026 · N515CL · Substantial damage > On February 16, 2026, at 1020 eastern standard time a Cessna 182G, N515CL, was substantially damaged when it was involved in an accident near Quail Heights, Florida. The pilot and two passengers were not injured. The airplane was operated as a Title 14 Code… - [NTSB ERA26LA080](https://openairdocs.org/ntsb/ERA26LA080.md): Varga 2150A · Frostproof, FL · Accident · No injuries · Class 4 · Limited · Final report · Dec 28, 2025 · N5062V · Substantial damage > The pilot’s failure to maintain control of the airplane during takeoff, resulting in a runway excursion and collision with terrain. - [NTSB ERA26LA058](https://openairdocs.org/ntsb/ERA26LA058.md): Huebbe Tom MAX TH · Inverness Highlands South, FL · Accident · No injuries · Class 4 · Limited · Final report · Nov 26, 2025 · N48TH · Substantial damage > The pilot’s failure to maintain directional control on takeoff. Contributing to the accident was the aircraft design that did not incorporate differential braking. - [NTSB ERA25LA302](https://openairdocs.org/ntsb/ERA25LA302.md): Cessna 172 · Titusville, FL · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Aug 15, 2025 · N7205Q · Substantial damage > On August 15, 2025, about 1415 eastern daylight time, a Cessna 172, N7205Q, was substantially damaged when it was involved in an accident near Titusville, Florida. The pilot was seriously injured and the flight instructor received minor injuries. The airplane… - [NTSB ERA25LA300](https://openairdocs.org/ntsb/ERA25LA300.md): Piper PA-12 · Inverness, FL · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Aug 14, 2025 · N4014M · Substantial damage > On August 14, 2025, about 1915 easter daylight time, a Piper-PA12, N4014M, was substantially damaged when it was involved in an accident near Pembroke Pines, Florida. The private pilot sustained serious injuries, and the passenger received a minor injury. The… - [NTSB ERA25LA250](https://openairdocs.org/ntsb/ERA25LA250.md): Beech 95-B55 (T42A) · Eustis, FL · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 29, 2025 · N9420Y · Substantial damage > The pilot’s inadequate preflight fuel planning and his failure to maintain directional control of the airplane after a total loss of right engine power during takeoff due to fuel starvation. - [NTSB ERA25LA184](https://openairdocs.org/ntsb/ERA25LA184.md): Grumman American Avn. AA-5B · Zolfo Springs, FL · Accident · No injuries · Class 4 · Limited · Final report · Apr 23, 2025 · N28311 · Destroyed > The pilot’s failure to maintain control of the airplane during the takeoff. Contributing was the flight instructor’s lack of remedial action. - [NTSB ERA25FA173](https://openairdocs.org/ntsb/ERA25FA173.md): Cessna 310R · Boca Raton, FL · Accident · 3 fatal · Class 3 · Field · Preliminary report · Apr 11, 2025 · N8930N · Destroyed > On April 11, 2025, at 1023 eastern daylight time, a Cessna 310R, N8930N, was destroyed when it was involved in an accident near Boca Raton, Florida. The two pilots and the passenger were fatally injured, and one person on the ground sustained minor injuries.… - [NTSB ERA25LA160](https://openairdocs.org/ntsb/ERA25LA160.md): Rotorway Exec · Chuluota, FL · Accident · No injuries · Class 4 · Limited · Final report · Mar 28, 2025 · N8318A · Substantial damage > The pilot’s failure to maintain lateral control of the helicopter during takeoff, which resulted in a dynamic rollover. - [NTSB ERA25FA154](https://openairdocs.org/ntsb/ERA25FA154.md): Aero SP Z O O AT-4 LSA · Zellwood, FL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Mar 22, 2025 · N8548U · Substantial damage > On March 22, 2025, about 0925 eastern daylight time, a Aero SP Z O O AT-4 LSA, N8548U, was substantially damaged when it was involved in an accident near Zellwood, Florida. The private pilot was fatally injured. The airplane was operated as a Title 14 Code of… - [NTSB DCA25LA163](https://openairdocs.org/ntsb/DCA25LA163.md): Boeing 737-8H4 · Orlando, FL · Incident · No injuries · Class 4 · Limited · Final report · Mar 20, 2025 · N8315C · No damage > The captain’s failure to recognize that the airplane’s location did not agree with the assigned departure runway as required per the Southwest Airlines Airplane Operating Manual, and the captain’s plan continuation error when he missed several cues that would… - [NTSB ERA25LA132](https://openairdocs.org/ntsb/ERA25LA132.md): Textron 172 · New Smyrna Beach, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Mar 1, 2025 · N923EP · Substantial damage > On March 1, 2025, about 1138 eastern standard time, a Cessna 172S, N923EP, was substantially damaged when it was involved in an accident near New Smyrna Beach, Florida. The flight instructor and student pilot were not injured. The airplane was operated as a… - [NTSB ERA25LA102](https://openairdocs.org/ntsb/ERA25LA102.md): Daniel A Robinson High 6 Berkut 540 · Orlando, FL · Accident · No injuries · Class 4 · Limited · Final report · Jan 20, 2025 · N976DR · Substantial damage > The pilot’s failure to verify the canopy latches were in the locked position prior to takeoff. - [NTSB ERA25LA098](https://openairdocs.org/ntsb/ERA25LA098.md): Montaer Ltda Montaer MC01 · Miramar, FL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jan 19, 2025 · N916VS · Substantial damage > On January 19, 2025, about 1410 eastern standard time, a Montaer MC-01, N916VS, was substantially damaged when it was involved in an accident near Miramar, Florida. The private pilot sustained minor injuries. The airplane was operated as a Title 14 Code of… - [NTSB ERA25LA088](https://openairdocs.org/ntsb/ERA25LA088.md): Beech A36 · Naples, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Jan 1, 2025 · N8163F · Substantial damage > On January 1, 2025, at 0120 eastern standard time, a Beech A36, N8163F, was substantially damaged when it was involved in an accident at Naples Municipal Airport (APF), Naples, Florida. The private pilot and three passengers were not injured. The flight was… - [NTSB ERA25LA089](https://openairdocs.org/ntsb/ERA25LA089.md): Buckeye Dream Machine · Myakka City, FL · Accident · Serious injuries · Class 4 · Limited · Final report · Dec 21, 2024 · UNREG · No damage > The non-certificated pilot’s improper decision to operate the powered parachute in close proximity to a fence, which resulted in a collision with the fence during takeoff. Also causal was the pilot’s decision to operate the powered parachute without having… - [NTSB ERA24LA363](https://openairdocs.org/ntsb/ERA24LA363.md): Aeronca 65-TAC · Clearwater, FL · Accident · Minor injuries · Class 4 · Limited · Final report · Aug 26, 2024 · N39565 · Substantial damage > The pilot’s failure to maintain directional control during the takeoff roll. Contributing to the outcome, was the pilot’s inability to control the engine following the loss of directional control due to the separation of a knob from the engine’s throttle… - [NTSB ERA24LA243](https://openairdocs.org/ntsb/ERA24LA243.md): Eide Turner T-40A · Middleburg, FL · Accident · Minor injuries · Class 4 · Limited · Final report · Jun 2, 2024 · N4DE · Substantial damage > The pilot’s loss of control during climb out, which resulted in a collision with a tree. - [NTSB ERA24LA233](https://openairdocs.org/ntsb/ERA24LA233.md): Piper PA32RT · Palmetto, FL · Accident · No injuries · Class 4 · Limited · Final report · May 30, 2024 · N313RB · Substantial damage > The pilot’s improper decision to re-attempt a takeoff with little runway remaining, after rejecting a takeoff in gusting wind conditions, which resulted in a runway overrun at a higher speed and collision with terrain. - [NTSB ERA24LA197](https://openairdocs.org/ntsb/ERA24LA197.md): Beech F35 · McAlpin, FL · Accident · No injuries · Class 4 · Limited · Final report · Apr 27, 2024 · N3880B · Destroyed > The pilot’s inadequate preflight planning and failure to abort the takeoff at the predetermined decision point. - [NTSB ERA24LA161](https://openairdocs.org/ntsb/ERA24LA161.md): Navion Navion B · Sanford, FL · Accident · No injuries · Class 3 · Limited · Final report · Mar 29, 2024 · N5429K · Substantial damage > A sudden loss of all engine power during takeoff for undetermined reasons. - [NTSB ERA24LA098](https://openairdocs.org/ntsb/ERA24LA098.md): Burkhart Grob Flugzeugbau G103 Twin Astir · Zephyrhills, FL · Accident · Serious injuries · Class 4 · Limited · Final report · Jan 25, 2024 · N1202Z · Substantial damage > The glider pilot’s failure to release from the towline after the tow plane experienced a loss of engine power. - [NTSB ERA24LA011](https://openairdocs.org/ntsb/ERA24LA011.md): Tecnam P2010 · Ocala, FL · Accident · Serious injuries · Class 3 · Limited · Final report · Oct 17, 2023 · N118T · Substantial damage > A total loss of engine power for reasons that could not be determined. Contributing to the accident was the flight instructor’s failure to maintain adequate airspeed and exceedance of the airplane’s critical angle of attack during the forced landing, which… - [NTSB ERA24LA009](https://openairdocs.org/ntsb/ERA24LA009.md): Monocoupe 90AL-115 · Myakka City, FL · Accident · Minor injuries · Class 4 · Limited · Final report · Oct 14, 2023 · N87621 · Substantial damage > The pilot’s failure to maintain adequate clearance from a fence during takeoff. - [NTSB ERA23LA379](https://openairdocs.org/ntsb/ERA23LA379.md): Dorr Dan W Sequoia F.8L Falco · Sanford, FL · Accident · Minor injuries · Class 4 · Limited · Final report · Sep 26, 2023 · N708WC · Substantial damage > The pilot’s failure to maintain airplane control after an engine access cover opened during the initial climb. - [NTSB ERA23FA321](https://openairdocs.org/ntsb/ERA23FA321.md): Kolb Firestar · McAlpin, FL · Accident · 1 fatal · Class 3 · Field · Final report · Aug 3, 2023 · Unreg · Substantial damage > A collision with trees during takeoff for reasons that could not be determined based on available information. - [NTSB ERA23LA290](https://openairdocs.org/ntsb/ERA23LA290.md): Piper PA-28-235 · Clearwater, FL · Accident · No injuries · Class 4 · Limited · Final report · Jul 5, 2023 · N8579W · Substantial damage > The pilot’s improper preflight inspection which resulted in a loss of engine power due to fuel contamination (water). - [NTSB ERA23LA284](https://openairdocs.org/ntsb/ERA23LA284.md): Schweizer 269C · Macclenny, FL · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 1, 2023 · N9WZ · Substantial damage > The improper maintenance of the landing gear dampers and main rotor elastomeric dampers, resulting in ground resonance during an unsuccessful takeoff attempt with the helicopter near its maximum gross weight for the density altitude. - [NTSB ERA23LA267](https://openairdocs.org/ntsb/ERA23LA267.md): Fly Gyros M24 Orion · Venice, FL · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 10, 2023 · N49PF · Substantial damage > The pilot’s failure to maintain directional control on takeoff for unknown reasons; whether the pilot’s acute stroke contributed to, or resulted from, the accident could not be determined. - [NTSB ERA23LA222](https://openairdocs.org/ntsb/ERA23LA222.md): Cessna 150M · Hernando, FL · Accident · Serious injuries · Class 4 · Limited · Final report · May 8, 2023 · N150VL · Substantial damage > The pilot’s failure to maintain adequate clearance from obstacles during takeoff at night. - [NTSB ERA23LA217](https://openairdocs.org/ntsb/ERA23LA217.md): Piper PA28R · Defuniak Springs, FL · Accident · No injuries · Class 4 · Limited · Final report · May 4, 2023 · N3796T · Substantial damage > The pilot's failure to maintain directional control while taking off in a crosswind, which resulted in a runway excursion and impact with a berm. Contributing was the automated weather briefing which failed to include accurate wind information. - [NTSB ERA23LA161](https://openairdocs.org/ntsb/ERA23LA161.md): Piper PA-46-350P · St. Augustine, FL · Accident · Serious injuries · Class 3 · Limited · Final report · Mar 23, 2023 · N280KC · Destroyed > The pilot's inadequate preflight planning, which resulted in a takeoff above the airplane’s maximum gross weight, a CG forward of the limit, and a tailwind component that prevented the airplane from climbing above trees. - [NTSB ERA23LA123](https://openairdocs.org/ntsb/ERA23LA123.md): Piper PA46 · Port Orange, FL · Accident · Serious injuries · Class 4 · Limited · Final report · Feb 2, 2023 · N864JB · Substantial damage > The pilot’s failure to maintain aircraft control during a takeoff attempt, which resulted in an aerodynamic stall, runway excursion, and collision with trees. - [NTSB ERA23LA153](https://openairdocs.org/ntsb/ERA23LA153.md): Green Richard H VAN'S RV7A · Williston, FL · Accident · No injuries · Class 4 · Limited · Final report · Jan 31, 2023 · N4811E · Substantial damage > The hard landing and subsequent nose over during the forced landing. Contributing to the accident were the improperly secured canopy, and the distraction it created. - [NTSB ERA23FA060](https://openairdocs.org/ntsb/ERA23FA060.md): Detrick Donald G Detrick DA-2 · Oak Hill, FL · Accident · 1 fatal · Class 3 · Field · Final report · Nov 15, 2022 · N4307Q · Substantial damage > The student pilot’s failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and collision with a tree. - [NTSB ERA23LA020](https://openairdocs.org/ntsb/ERA23LA020.md): Aero Commander 100 · New Smyrna Beach, FL · Accident · No injuries · Class 4 · Limited · Final report · Oct 13, 2022 · N3885X · Substantial damage > The pilot’s exceedance of the critical angle of attack during takeoff and corresponding stall/mush. Contributing to the accident were the pilot’s operation of the airplane above the maximum specified gross weight. - [NTSB ERA22LA378](https://openairdocs.org/ntsb/ERA22LA378.md): Piper PA-28-140 · Marathon, FL · Accident · No injuries · Class 3 · Limited · Final report · Aug 19, 2022 · N587FL · Substantial damage > A total loss of power for undetermined reasons. Next page: https://openairdocs.org/ntsb-phases/300/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 = 300) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/300/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.