# NTSB investigations, FL: Unknown 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 2 · 83 cases ## Latest cases - [NTSB ANC26FA021](https://openairdocs.org/ntsb/ANC26FA021.md): Robinson Helicopter R44 · Boynton Beach, FL · Accident · 2 fatal · Class 3 · Field · Preliminary report · Mar 23, 2026 · N478AT · Destroyed > On March 23, 2026, about 1221 eastern daylight time, a Robinson R44 Raven I helicopter, N478AT, was destroyed when it was involved in an accident near Boynton Beach, Florida. The flight instructor and the pilot receiving instruction were fatally injured. The… - [NTSB ERA13FA432](https://openairdocs.org/ntsb/ERA13FA432.md): Lowerre Bruce T S 12-E · Pahokee, FL · Accident · 1 fatal · Field investigation · Final report · Sep 27, 2013 · N220BL · Substantial damage > Undetermined because the wreckage was not recovered. - [NTSB ERA12LA537](https://openairdocs.org/ntsb/ERA12LA537.md): Quad City Ultralights Challenger II · Ocala, FL · Accident · 2 fatal · Limited investigation · Final report · Aug 30, 2012 · N2481P · Substantial damage > The pilot's inadvertent overstress of the airplane, which resulted in the in-flight separation of the outer section of the right wing. - [NTSB ERA12CA466](https://openairdocs.org/ntsb/ERA12CA466.md): Cessna 172P · St. Augustine, FL · Accident · No injuries · Data collection · Final report · Jul 18, 2012 · N127EP · Substantial damage > Undetermined due to a lack of information about when the damage to the airplane occurred. - [NTSB MIA01FAMS1](https://openairdocs.org/ntsb/MIA01FAMS1.md): Cessna 150 · Missing, FL · Accident · 1 fatal · Missing aircraft · Final report · Oct 27, 2000 · N11214 · Destroyed > undetermined. - [NTSB MIA00LA012](https://openairdocs.org/ntsb/MIA00LA012.md): Beech D35 · Indiantown, FL · Accident · No injuries · Limited investigation · Final report · Oct 16, 1999 · N2109D · Substantial damage > The reported unauthorized use of the airplane by an unknown person. - [NTSB ATL99LA117](https://openairdocs.org/ntsb/ATL99LA117.md): Quicksilver GT-500 · Ormond Beach, FL · Accident · No injuries · Limited investigation · Final report · Aug 13, 1999 · N5503M · Substantial damage > The in-flight collision with an object for an undetermined reasons. A factor was the stolen/unauthorized use of the airplane. - [NTSB MIA99FA050](https://openairdocs.org/ntsb/MIA99FA050.md): Cessna 172L · Macclenny, FL · Accident · 2 fatal · Field investigation · Final report · Jun 23, 1998 · N3853Q · Destroyed > The student pilot's attempted VFR flight into instrument meteorological conditions, resulting in a subsequent in-flight collision with trees and terrain. Contributing factors were, haze/smoke, the student pilot's failure to obtain a preflight weather… - [NTSB MIA97IA206](https://openairdocs.org/ntsb/MIA97IA206.md): McDonnell Douglas DC-8-61 · Miami, FL · Incident · No injuries · Incident investigation · Final report · Jul 5, 1997 · N27UA · Minor damage > failure of the right main landing gear cylinder due to stress corrosion. - [NTSB MIA97LA202](https://openairdocs.org/ntsb/MIA97LA202.md): DFL Holdings Tango · Keystone, FL · Accident · 1 fatal · Limited investigation · Final report · Jul 1, 1997 · N772T · Destroyed > an in-flight loss of control for undetermined reasons. - [NTSB MIA97FA043](https://openairdocs.org/ntsb/MIA97FA043.md): Forney F-1 · Middleburg, FL · Accident · 1 fatal · Field investigation · Final report · Dec 22, 1996 · N7530C · Destroyed > VFR flight by the noninstrument-rated pilot into instrument meteorological conditions (IMC), which resulted in spatial disorientation and an uncontrolled descent into a wooded area. Factors relating to the accident were: failure of the pilot to obtain a… - [NTSB MIA96FA186](https://openairdocs.org/ntsb/MIA96FA186.md): Cessna 152 · New Smyrna Bch, FL · Accident · 1 fatal · Field investigation · Final report · Jul 15, 1996 · N65514 · Destroyed > the pilot's impairment of judgment and performance because of gastroenteritis and use of the prescription drug Phenergan (promethazine). - [NTSB MIA95LA166](https://openairdocs.org/ntsb/MIA95LA166.md): Piper PA-23-250 · Orlando, FL · Accident · No injuries · Limited investigation · Final report · Jun 28, 1995 · N25AT · Substantial damage > Unknown. - [NTSB MIA95FAMS1](https://openairdocs.org/ntsb/MIA95FAMS1.md): Piper PA-28-161 · Missing, FL · Accident · 1 fatal · Missing aircraft · Final report · Dec 25, 1994 · N5916V · Destroyed > Undetermined. - [NTSB MIA94LA013](https://openairdocs.org/ntsb/MIA94LA013.md): Beech A36 · Ormond Beach, FL · Accident · 3 fatal · Limited investigation · Final report · Oct 29, 1993 · N888AS · Destroyed > Poor judgement of the pilot, due to consumption of alcohol and use of drugs, and his failure (or inability) to maintain altitude (or clearance) above water at night. Darkness was a related factor. - [NTSB MIA94FA008](https://openairdocs.org/ntsb/MIA94FA008.md): Beech 60 · Miami, FL · Accident · Serious injuries · Field investigation · Final report · Oct 17, 1993 · N7131D · Substantial damage > Inadequate preflight by the pilot, and his failure to assure that proper maintenance/annual inspection was attained. Factors related to the accident were: water and other contamination in the fuel supply, lack of continuity in two ignition leads, loose left… - [NTSB MIA93FAMS2](https://openairdocs.org/ntsb/MIA93FAMS2.md): Cessna 152 · FL · Accident · 1 fatal · Missing aircraft · Final report · Sep 30, 1993 · N93261 · Destroyed > undetermined. - [NTSB MIA92LA181](https://openairdocs.org/ntsb/MIA92LA181.md): Aero Commander 100 · Panacea, FL · Accident · Minor injuries · Limited investigation · Final report · Sep 15, 1992 · N3791X · Substantial damage > Failure of the nose landing gear push/pull rod end bearing for undetermined reasons. - [NTSB MIA92LA177](https://openairdocs.org/ntsb/MIA92LA177.md): Cessna A150K · Palatka, FL · Accident · No injuries · Limited investigation · Final report · Sep 7, 1992 · N8367M · Substantial damage > The pilot in command's failure to maintain airspeed while performing a go around resulting in the aircraft stalling and descending uncontrolled to the ground. - [NTSB MIA92LA151](https://openairdocs.org/ntsb/MIA92LA151.md): Consolidated Aeronautics LA-4-200 · FL · Accident · No injuries · Limited investigation · Final report · Jul 9, 1992 · N2969P · Substantial damage > Substantial damage to the airplane during Unknown phase of flight for undetermined reasons. - [NTSB MIA92GA002](https://openairdocs.org/ntsb/MIA92GA002.md): Cessna 172K · Everglades City, FL · Accident · 2 fatal · Final report · Oct 3, 1991 · N758JN · Destroyed > The pilot-in-command's improper management of fuel. This resulted in the airplane experiencing fuel exhaustion, forced landing, and in flight collision with terrain. - [NTSB MIA91FAMS1](https://openairdocs.org/ntsb/MIA91FAMS1.md): Piper PA-24-260 · Missing, FL · Accident · 1 fatal · Missing aircraft · Final report · Apr 24, 1991 · N8938P · Destroyed > Undetermined. - [NTSB MIA91GA034](https://openairdocs.org/ntsb/MIA91GA034.md): Asta N22S · Homestead Afb, FL · Accident · No injuries · Final report · Nov 28, 1990 · N5056D · Substantial damage > The bending overstress failure of the left main landing screwjack at an undetermined time during flight for undetermined reasons. - [NTSB MIA90FA106](https://openairdocs.org/ntsb/MIA90FA106.md): Piper PA-38-112 · Marco Island, FL · Accident · 1 fatal · Field investigation · Final report · Apr 18, 1990 · N91309 · Destroyed > Fuel exhaustion due to improper planning & decision by the pilot, and an inadvertent stall/spin while maneuvering for a forced landing. - [NTSB MIA90LA061](https://openairdocs.org/ntsb/MIA90LA061.md): Cessna 152 · Missing, FL · Accident · 2 fatal · Limited investigation · Final report · Jan 24, 1990 · N4802B · Destroyed > Undetermined. - [NTSB MIA90FA060](https://openairdocs.org/ntsb/MIA90FA060.md): Piper J-3 · Clewiston, FL · Accident · 2 fatal · Field investigation · Final report · Jan 20, 1990 · N88125 · Destroyed > Failure of the pilot to secure the flight control stick (inadequate preflight) before takeoff. - [NTSB MIA90LA053](https://openairdocs.org/ntsb/MIA90LA053.md): Beech E185 · Wauchula, FL · Accident · No injuries · Limited investigation · Final report · Jan 13, 1990 · N50BP · Substantial damage > Loss of air pressure in the left main tire during flight, which resulted in a ground swerve during the landing and a nose over as the pilot was correcting with opposite brake and rudder. - [NTSB MIA89FA214](https://openairdocs.org/ntsb/MIA89FA214.md): Cessna 210L · Marco, FL · Accident · 1 fatal · Field investigation · Final report · Aug 5, 1989 · N2676S · Destroyed > Continued VFR flight by the pilot into instrument meteorological conditions (IMC), his misjudgment of altitude and his physical impairment from use of drugs. Contributing factors were: the pilot's probable spatial disorientation, and the night/weather… - [NTSB MIA88FA232](https://openairdocs.org/ntsb/MIA88FA232.md): Rockwell S2R · O'Brien, FL · Accident · 1 fatal · Field investigation · Final report · Jul 24, 1988 · N4222X · Destroyed > The purpose of the flt was to spray a soybean field about 1/2 mi n of the airstrip. There are no known witnesses to the crash, but a person in the area heard the eng 'pop', then eng sound ceased; seconds later the sound of impact was heard. The acft struck… - [NTSB ATL87FA173](https://openairdocs.org/ntsb/ATL87FA173.md): Mitsubishi MU-2B · Coral Springs, FL · Accident · 1 fatal · Field investigation · Final report · Jun 18, 1987 · N184MA · Destroyed > The pilot reported to ground personnel at fort lauderdale that he was experiencing an avionics problem and the passengerentry door was sprung the day before when it was slammed; however, the pilot elected to depart. The aircraft wreckage was located on June… - [NTSB MIA87LA161](https://openairdocs.org/ntsb/MIA87LA161.md): Piper PA-23-250 · Missing, FL · Accident · 2 fatal · Limited investigation · Final report · May 14, 1987 · N640CC · Destroyed > The acft failed to arrive at its destination on a flight from miami, FL to aruba, netherland antilles via andros is, great inagua & port au prince. According to a flt plan filed by the plt the acft carried enough fuel for 8 hours & 30 minutes of flt, along… - [NTSB MIA87LA097](https://openairdocs.org/ntsb/MIA87LA097.md): Beech B-65 · Key Largo, FL · Accident · No injuries · Limited investigation · Final report · Mar 3, 1987 · N822Q · Destroyed > The aircraft was found crashed in shallow water near Key Largo FL. Attempts to locate the pilot or current operator were fruitless. The circumstances surrounding the crash and the cause are unknown. - [NTSB MIA86FA148](https://openairdocs.org/ntsb/MIA86FA148.md): Cessna 150H · Vero Beach, FL · Accident · Serious injuries · Field investigation · Final report · May 5, 1986 · N6989S · Destroyed > The CFI & student plt were on a training flt. Witnesses heard the eng sputter, then cut out completely. One witness said he thought the plt would attempt a landing to the south, lengthwise, into a pasture bordered on all sides by trees aprx 50 ft high. The… - [NTSB MIA85LA249](https://openairdocs.org/ntsb/MIA85LA249.md): Piper PA-28-160 · Key West, FL · Accident · 2 fatal · Limited investigation · Final report · Sep 9, 1985 · N5488W · Destroyed > The acft failed to arrive at its intended destination on a flt plan from ft. lauderdale FL. To Key West FL. Navy Key West apch was providing VFR flt following, radar & radiocontact was lost with the acft 20 NE of Key West. The whereabouts of the occupants are… - [NTSB MIA85FA180](https://openairdocs.org/ntsb/MIA85FA180.md): Piper PA-34 · Loxahatchee, FL · Accident · 3 fatal · Field investigation · Final report · May 28, 1985 · N3449Q · Destroyed > The plt & passengers were seen drinking beer in a bar prior to the flt. After the acft took off, witnesses observed it flying very low near a shoreline; one of them was a police officer that identified the acft by its registration number. At aprx 1930, the… - [NTSB MIA85IA147](https://openairdocs.org/ntsb/MIA85IA147.md): Hawker Siddeley HS-125 · Ft Lauderdale, FL · Incident · No injuries · Incident investigation · Final report · Apr 12, 1985 · N888WK · Minor damage > The plt reported that on an FAA check flt, the nose gear would not extend. Subsequently, the acft received minor damage when it was landed with the nose gear retracted. An investigation revealed that a nose landing gear door rod assembly had failed from… - [NTSB MIA85FA140](https://openairdocs.org/ntsb/MIA85FA140.md): Piper PA-28-180 · Rockledge, FL · Accident · 1 fatal · Field investigation · Final report · Mar 31, 1985 · N5180S · Destroyed > On March 31, 1985 the rental acft departed merritt island flon April 1, 1985 the acft was found crashed near Rockledge FL. No evidence of pre-existing airframe or powerplant failure was found. The acft impactd the ground in a high velocity 40 degree nose down… - [NTSB MIA85LA135](https://openairdocs.org/ntsb/MIA85LA135.md): Cessna 206 · Key West, FL · Accident · No injuries · Limited investigation · Final report · Mar 27, 1985 · N4944U · Substantial damage > After the acft departed the seaplane parking area, the plt noticed that the left float was taking on water. He initiated a turn back towards the ramp area & applied full power in an attempt to reach shallower water. As he apchd the parking area & was turning… - [NTSB MIA85LA132](https://openairdocs.org/ntsb/MIA85LA132.md): Cessna 150H · Fort Pierce, FL · Accident · No injuries · Limited investigation · Final report · Mar 24, 1985 · N6587S · Substantial damage > Takeoff run was reported to be normal. After lift off the aircraft would not climb and engine RPM was noticed to be 300 RPM low. The aircraft descended and struck a pine tree at the end of the runway. The aircraft was being operated within 60 pounds of the… - [NTSB MIA85FA112](https://openairdocs.org/ntsb/MIA85FA112.md): Piper PA-23-250 · Jacksonvile, FL · Accident · 2 fatal · Field investigation · Final report · Mar 4, 1985 · N100DT · Destroyed > The single eng land, pvt plt had an instrument rating, but had no rating to fly multi-eng acft. While on an illegal flt with marijuana on board, he contacted jacksonville apch control & advised that he could not see the ground due to dense ground fog, the… - [NTSB MIA85LAMS2](https://openairdocs.org/ntsb/MIA85LAMS2.md): Cessna 337 · Atlantic Ocean, FL · Accident · 4 fatal · Final report · Jan 14, 1985 · N505CX · Destroyed > The acft was reported missing and search & rescue control center initiated a search on 1-17-85. The search was suspendedon 1-24-85. The last reported position of the acft was 66 miles northeast of jacksonville, FL. The acft is still missing & the damage index… - [NTSB MIA84FU006](https://openairdocs.org/ntsb/MIA84FU006.md): Storey SKY PUP · Indiantown, FL · Accident · 1 fatal · Final report · Jun 23, 1984 · UNREG · Destroyed > The ultralight experienced an in-flight separation of the left wing. The wing separated at the wing attachment fitting. The plt & ultralight had a parachute attached but it did not deploy. - [NTSB MIA84LA186](https://openairdocs.org/ntsb/MIA84LA186.md): Cessna A188B · Marianna, FL · Accident · No injuries · Limited investigation · Final report · Jun 18, 1984 · N5630G · Substantial damage > During a crop dusting operation, there was an apparent loss of power & oil sprayed on the windshield of the acft. The plt stated that when he applied power, there was no response. He made a forced landing on a road, but the right wing of the acft hit a tree.… - [NTSB MIA84FA188](https://openairdocs.org/ntsb/MIA84FA188.md): Cessna C-188 · Elkton, FL · Accident · 1 fatal · Field investigation · Final report · Jun 18, 1984 · N8233G · Destroyed > The aircraft departed the farm grass strip for a spray mission estimated to take about 20 minutes. When the aircraft failed to return the pilots business partner started looking for the aircraft and pilot. The aircraft was found about one and one half mile… - [NTSB MIA84LA137](https://openairdocs.org/ntsb/MIA84LA137.md): Grumman American AA-5A · Clearwater, FL · Accident · 1 fatal · Limited investigation · Final report · Apr 14, 1984 · N206JA · Destroyed > Shortly after takeoff, the acft crashed into the ocean. VMC existed at the arpt but dense low ocean fog was reported at the crash site. Some acft debris was recovered. - [NTSB MIA84LA128](https://openairdocs.org/ntsb/MIA84LA128.md): Cessna 172 · Marathon, FL · Accident · 4 fatal · Limited investigation · Final report · Apr 2, 1984 · N64110 · Destroyed > The acft was missing after departing on a flt from maraton, FL to everglades city, FL. Sar personnel found the bodies of the plt & 3 pax, but the acft was not found. It was presumed to have been destroyed during a crash in the gulf of Mexico. - [NTSB MIA84LA114](https://openairdocs.org/ntsb/MIA84LA114.md): Piper PA-28-235 · Sanibel Island, FL · Accident · 4 fatal · Limited investigation · Final report · Mar 12, 1984 · N39677 · Destroyed > The acft failed to arrive at its destination. A satellite photo of the area showed wx & cloud cover between the departure & destination arpts. Radar data showed that an acft had left key west, FL, at about 1700, went northbound at 4500 until it encounter bad… - [NTSB MIA84FA091](https://openairdocs.org/ntsb/MIA84FA091.md): Cessna 185F · Key West, FL · Accident · Serious injuries · Field investigation · Final report · Feb 22, 1984 · N4460R · Destroyed > The acft landed after a previous flt & was refueled & preflight for another mission. According to maintenance personnel, the acft floats were drained once every morning before the 1st flt of the day in accordance with the manufacturer's recommendations. The… - [NTSB MIA84LA089](https://openairdocs.org/ntsb/MIA84LA089.md): Cessna P-210N · Key West, FL · Accident · 2 fatal · Limited investigation · Final report · Feb 21, 1984 · N731NJ · Destroyed > During his wx briefing the plt was given the flight precautions & enroute forecast along his proposed route of flt. Enroute at 14,000 ft the plt advised ARTCC that the flt had encountered rime ice. The controller cleared the flt to descend to 12,000 ft & the… - [NTSB MIA84LA035](https://openairdocs.org/ntsb/MIA84LA035.md): Cessna 340A · Nr. Orangeville, FL · Accident · 1 fatal · Limited investigation · Final report · Nov 20, 1983 · N85JK · Destroyed > The acft disappeared fm radar coverage while in cruise flt at 10,000 feet MSL near Orangeville, FL. The ATC transcript revealed that the plt had been inquiring abt the weather ahead of him and was cleared to descend to 6000 in order to get below strong… Next page: https://openairdocs.org/ntsb-phases/990/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 = 990) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/990/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.