NTSB investigations, FL
33 cases where the first occurrence was “On ground/water encounter with terrain/water”.
Cases per year
| 1982 | 2 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 2 |
| 1987 | 2 |
| 1988 | 1 |
| 1989 | 2 |
| 1990 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 1998 | 3 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 3 |
| 2004 | 2 |
| 2005 | 4 |
| 2007 | 1 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 320)
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 320) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB MIA07CA134Accident · Minor injuriesData collectionFinal reportCessna 152 · Labelle, FLThe student pilot's attempted precautionary landing on unsuitable terrain which resulted in damage to the airplane during the landing.NTSB MIA05LA145Accident · Serious injuriesLimited investigationFinal reportFox Alfred C. Kitfox IV 1200 · Immokalee, FLThe pilot's failure to detect standing water on the grass strip resulting in a nose over during the landing roll.NTSB MIA05CA094Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Lakeland, FLThe pilot's improper recovery from a bounced landing, and his failure to maintain directional control during landing resulting in the airplane departing the runway and colliding with a ditch.NTSB MIA05CA082Accident · No injuriesData collectionFinal reportPiper PA-23-250 · West Palm Beach, FLThe failure of the pilot to maintain proper alignment with the runway, his failure to perform a go around after recognizing the aircraft was not properly aligned for landing, and his intentionally landing on a taxiway which resulted in a landing overrun and…NTSB ANC05CA040Accident · No injuriesData collectionFinal reportAir Tractor AT-602 · Panama City, FLThe pilot's failure to remove frost from the airplane which resulted in an inadvertent stall/mush during the takeoff/initial climb, and an in-flight collision with trees. Contributing to the accident were the rough and uneven airstrip, and degraded aircraft…NTSB MIA05CA022Accident · No injuriesData collectionFinal reportChampion 7GCBC · Pierson, FLThe inadequate visual lookout by the pilot-in-command resulting in the airplane encountering uneven terrain, propeller contact to the ground, and subsequent nose over.NTSB MIA04CA055Accident · No injuriesData collectionFinal reportAviat Pitts S2B · Parkland, FLThe pilot's inadequate preflight planning which resulted in an off-airport precautionary landing to preclude fuel exhaustion, which resulted in damage to the airplane during the landing.NTSB MIA03LA015Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Orlando, FLThe poor in-flight planning by the pilot-in-command for his failing to request a runway more aligned with the wind and his failure to maintain directional control after landing resulting in collapse of the nose landing gear and the airplane nosing over.NTSB ATL02LA068Accident · No injuriesLimited investigationFinal reportCessna 152 · Melbourne, FLThe students pilot's failure to perform a go-around after a bounced landing condition that resulted in the on-ground collision with a ditch.NTSB ATL02LA038Accident · Minor injuriesLimited investigationFinal reportH.S. Mosley Cuby Sport · Panama City, FLThe pilot's inadequate preflight and inflight decisions that resulted the execution of and off-airport landing to rough and uneven terrain where the airplane nosed over during the landing. The pilot did not apply normal breaking during the landing roll.NTSB ATL01LA078Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-3 · Titusville, FLThe pilot's failure to maintain directional control during a bounced landing, resulting in a ground loop and subesequent collision with the runway.NTSB ATL01LA076Accident · No injuriesLimited investigationFinal reportCessna 172P · Cedar Key, FLThe pilot's improper in-flight decision to abort the landing resulted in the collision with water. A factor was the variable wind condition.NTSB MIA00LA075Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Ocean Reef Club, FLThe failure of the pilot to maintain directional control of the airplane while taxiing after landing resulting in the on-ground collision with high vegetation.NTSB ATL98LA097Accident · Minor injuriesLimited investigationFinal reportBenson B-8M · Placida, FLExcessive taxi speed. A related factor was the wind gusts.NTSB MIA98LA175Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Clewiston, FLThe pilot's inadequate visual lookout while taxiing for takeoff.NTSB MIA98LA169Accident · No injuriesLimited investigationFinal reportMohr Skybolt · Lakeland, FLthe failure of the pilot to maintain directional control of the airplane, after landing, resulting in the airplane departing the left side of the runway and subsequent impact with the ground.NTSB ATL98LA010Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Punta Gorda, FLThe flight instructor's improper short field takeoff procedure and his decision to abort the takeoff after rotation.NTSB MIA96LA055Accident · No injuriesLimited investigationFinal reportPiper PA-46 · Fort Myers, FLThe failure of the pilot-in-command to maintain directional control. Contributing to the accident was the inadequate amount of rudder input to compensate for engine torque during takeoff.NTSB MIA94LA104Accident · No injuriesLimited investigationFinal reportCessna 172N · Stuart, FLPoor in-flight planning/decision by the pilot-in-command. Contributing to the accident was wind information disregarded by the pilot-in-command.NTSB ATL94IA001Incident · No injuriesIncident investigationFinal reportBoeing 757-232 · Fort Lauderdale, FLFailure of the captain to use the proper rotation and lift-off speeds, which resulted in over rotation of the aircraft during takeoff and a subsequent tail scrape.NTSB MIA92LA083Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Kissimmee, FLThe pilot-in-command's failure to attain the proper touchdown point due to landing before the displaced threshold on the rwy.NTSB MIA90LA174Accident · No injuriesLimited investigationFinal reportPitts S1-S · Palm City, FLFailure of the pilot in command to initiate a go around in a timely manner, and the airplane landing gear dug into the soft sod and nosed over.NTSB MIA89FA237Accident · 1 fatalField investigationFinal reportEagle DW-1-220 · Oklawaha, FLThe loss of control on the ground during the landing roll for undetermined reasons.NTSB MIA89LA116Accident · Minor injuriesLimited investigationFinal reportBeech B55 · Sarasota, FLUneven runway condition (sunken spot).NTSB MIA89LA014Accident · No injuriesLimited investigationFinal reportCessna 182A · La Belle, FLDuring soft field takeoff from a rough strip the acft collided with a hole causing the nose wheel to drop onto the runway hard. The nose wheel separated and the acft veered to the right and collided with a drainage ditch. .NTSB MIA87LA163Accident · No injuriesLimited investigationFinal reportPiper PA-28-180D · Astatula, FLThe plt became disoriented and performed a precautionary landing. During the landing roll, the pilot taxied into a ditchand the nose gear collapsed.NTSB MIA87FA066Accident · No injuriesField investigationFinal reportCessna 310-D · Lantana, FLThe pilot flying in marginal weather requested radar assistance in landing at his destination. He was given a radar vector to a position on downwind and saw an uncontrolled airport under him. He landed on a closed runway that was marked closed due to…NTSB MIA86FA095Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Florida City, FLThe acft touched down on the top of a flood control dike approx 12 ft wide. The acft continued for about 1336 ft before the left wheel slid off the dike where the dike makes a slight curve to the right. The left gear was torn from the acft as it left the…NTSB MIA86LA092Accident · No injuriesLimited investigationFinal reportCessna 210J · Jacksonville, FLThe plt stated that while taxiing to the ramp, after landing, he taxied through construction barricades & ran off the taxiway. While attempting to get back on the taxiway, the nose gear got caught in a hole & collapsed.NTSB MIA85LA221Accident · No injuriesLimited investigationFinal reportCessna 182P · Davisville, FLThe pilot stated that on landing roll out at the agricultural airstrip, the aircraft struck a ditch causing the nose gear to collapse.NTSB MIA84LA255Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Rockledge, FLThe acft collided with a mound of dirt while executing a go-around at a private airstrip. The plt stated he selected rwy 27 based on winds reported at another airport and when the acft touched down about mid-point of the strip, 'I retracted flaps and applied…NTSB MIA82DA056Accident · No injuriesFinal reportCessna 210A · Florida City, FLThe aircraft was found inverted in 5 feet of water. Only one seat was installed and an auxiliary fuel pump was inside the aircraft. It appeared that the aircraft landed on the adjacent canal bank and then purposely run into the water. Police suspect a drug…NTSB MIA82DA055Accident · No injuriesFinal reportCessna P206B · Pembroke Pines, FLThe wreckage was found abandoned off the side of a narrow road on 2/19/82. Only the pilot's seat was installed. Traces of narcotics were found on board. The aircraft's registered owner as shown in the FAA records contained a fictitious address. The injury…