NTSB investigations, FL
158 cases where the first occurrence was “In flight collision with terrain/water”.
Cases per year
| 1982 | 15 |
|---|---|
| 1983 | 13 |
| 1984 | 14 |
| 1985 | 10 |
| 1986 | 19 |
| 1987 | 2 |
| 1988 | 9 |
| 1989 | 6 |
| 1990 | 1 |
| 1991 | 4 |
| 1992 | 3 |
| 1993 | 10 |
| 1994 | 5 |
| 1995 | 2 |
| 1996 | 8 |
| 1997 | 3 |
| 1998 | 3 |
| 1999 | 6 |
| 2000 | 5 |
| 2001 | 2 |
| 2002 | 4 |
| 2003 | 2 |
| 2004 | 2 |
| 2005 | 4 |
| 2007 | 6 |
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\" = 230)
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" = 230) 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 MIA08CA019Accident · Minor injuriesData collectionFinal reportLake LA-4-200 · Jacksonville, FLThe pilot's failure to maintain altitude while maneuvering over water. Contributing to the accident was glassy water conditions.NTSB MIA07FA147Accident · 2 fatalField investigationFinal reportBell 206B · Nokomis, FLThe pilot's failure to maintain clearance from the water.NTSB ATL07LA119Accident · 1 fatalLimited investigationFinal reportCessna P206 · Center Hill, FLThe pilot committed suicide. Contributing to the event was the pilot's impairment due to alcohol.NTSB MIA07FA060Accident · 1 fatalField investigationFinal reportAero Vodochody Aero. Works L-39C · Titusville, FLThe pilot’s failure to ensure sufficient altitude while maneuvering in close proximity to the ground during an airshow, which resulted in an impact with terrain.NTSB MIA07CA048Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Deland, FLThe pilot's failure to maintain directional control during the landing flare, resulting in an in-flight collision with soft terrain, and a collapse of the right main landing gear.NTSB MIA07CA046Accident · Minor injuriesData collectionFinal reportC.W Crane T2 · Bunnell, FLThe pilot's inadvertent encounter with adverse weather that resulted in a descent and an impact with terrain.NTSB MIA06LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Opa-Locka, FLThe failure of the pilot-in-command/CFI to maintain control of the airplane and his inattentiveness to the altitude while troubleshooting the landing gear system resulting in the in-flight collision with terrain.NTSB MIA06LA006Accident · 1 fatalLimited investigationFinal reportSteven W. Jones KR2 · Venice, FLThe in-flight collision with the water for undetermined reasons.NTSB MIA05FA055Accident · 1 fatalField investigationFinal reportBell 206B · Bonifay, FLThe pilot's failure to maintain a climb after takeoff and his continued descent which resulted in an in-flight collision with the ground. A factor in the accident was the dark night.NTSB MIA05FA044Accident · 1 fatalField investigationFinal reportCessna 210N · Weston, FLThe pilot's failure to maintain his assigned altitude, and allowed the airplane to descend for undetermined reasons resulting in an in-flight collision with terrain. Factors in the accident were clouds, rain, and the dark night.NTSB MIA05LA033Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-D · Cocoa Beach, FLThe pilot's failure to maintain altitude resulting in flight collision with ground and subsequent collision with fence.NTSB MIA04CA048Accident · No injuriesData collectionFinal reportRobinson R44 · Vero Beach, FLThe failure of the pilot to maintain clearance with bushed resulting in in-flight contact and susequent dynamic roll-over.NTSB MIA03LA114Accident · No injuriesLimited investigationFinal reportCessna 172E · Hastings, FLThe failure of the pilot to maintain control of the airplane resulting in in-flight collision with terrain.NTSB MIA03FA065Accident · 1 fatalField investigationFinal reportAerofab Lake 250 · Weirsdale, FLThe inadequate flare by the pilot-in-command on the calm water resulting in the in-flight collision with the water and subsequent nose over.NTSB MIA02LA090Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Myakka City, FLthe pilot's failure to maintain altitude while maneuvering during an aerial application, subsequently resulting in impact with the terrain.NTSB ATL02LA085Accident · Minor injuriesLimited investigationFinal reportPitts S1C · Gainesville, FLThe pilot's failure to maintain clearance from the ground during an attempted go-around.NTSB ATL02LA053Accident · No injuriesLimited investigationFinal reportCessna 150M · Ormond Beach, FLThe student pilot's improper flare and failure to recover from a bounced landing resulting in the subsequent collapse of the nose gear during the landing flare touchdown. A factor contributing to the accident was the student pilot's lack of total experience.NTSB ATL02LA047Accident · No injuriesLimited investigationFinal reportPiper PA -18 · Winter Haven, FLThe pilot's improper flare during an attempted landing on water. A factor was glassy water.NTSB MIA01LA112Accident · No injuriesLimited investigationFinal reportCessna 182Q · Lakeland, FLThe pilot's failure to flare on landing resulting in a hard landing.NTSB MIA01LA101Accident · No injuriesLimited investigationFinal reportRobinson R22 · Okeechobee, FLan in-flight collision with the ground during a simulated engine failure, and autorotation, which resulted in the tailboom separating. A contributing factor in this accident was the pilot allowed the rotor rpm to decay which resulted in inadequate rotor rpm…NTSB ATL00LA058Accident · Minor injuriesLimited investigationFinal reportBell 407 · Lake Placid, FLThe pilot's failure to establish/maintain a safe rate of descent during approach to landing. Contributing factors were the pilot's incorrect altimeter (Kollsman) setting, smoke, and dark night conditions.NTSB MIA00GA184Accident · 1 fatalFinal reportBell UH-1H · Fort Myers, FLthe pilot's failure to maintain control of the helicopter for undetermined reasons. Factors in this accident were self-induced pressure and fatigue due to lack of sleep and rest.NTSB MIA00FA118Accident · 1 fatalField investigationFinal reportPiper PA-24-260 · Panama City, FLThe pilot experiencing spatial disorientation while reversing course during a dark night while over water which resul;ted in an in-flight collision with water. A factor was the dark night lighting conditions.NTSB MIA00LA097Accident · No injuriesLimited investigationFinal reportHughes TH-55 · Odessa, FLThe pilot's improper use of flight controls (cyclic and col lective) during a autorotation resulting in a hard landing and subsequent roll over.NTSB MIA00LA093Accident · No injuriesLimited investigationFinal reportSchweizer SGS2-33A · Miami, FLthe pilot planned the approach too low, which resulted in inadequate altitude to clear powerlines, and the subsequent in-flight collision with the ground.NTSB ATL00LA003Accident · Minor injuriesLimited investigationFinal reportRobinson R-22-MARINER · West Boca Raton, FLThe flight instructor's delayed response in taking remedial action during a practice autorotation. Factors were his inadequate planned approach and his improper use of powerplant controls.NTSB MIA99LA212Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Moore Haven, FLThe pilot exceeding the gross takeoff weight which reduced the climb capability and subsequent in-flight collision with terrain. Contributing to the accident was the high temperature and the pilot's failure to use aircraft performance data for the weather…NTSB MIA99LA116Accident · Serious injuriesLimited investigationFinal reportMaule M-7-235B · Boca Grande, FLThe pilots failure to maintain a visual lookout on landing resulting in an in-flight collision with a wave.NTSB MIA99FA075Accident · 1 fatalField investigationFinal reportCessna 210J · Naples, FLIn-flight collision with water while on base turn to final at night for undetermined reasons.NTSB MIA99LA070Accident · Serious injuriesLimited investigationFinal reportRobinson R22 · Pompano Beach, FLThe CFI's decision not to follow procedures and directives (initiate a go-around/power recovery) during a simulated 180 autorotation resulting in a hard landing and in flight collision with terrain.NTSB MIA99GA064Accident · Serious injuriesFinal reportCessna U206G · Homestead, FLThe intentional low altitude flight/maneuver by the pilot-in-command and his disregard of the altitude clearance with terrain resulting in the inflight collision with water during the dark night. Contributing to the accident was the lack of U.S. Customs…NTSB MIA99FA043Accident · 3 fatalField investigationFinal reportCessna 402B · Pahokee, FLThe pilot's failure to maintain adequate altitude during the approach.NTSB MIA98FA239Accident · 1 fatalField investigationFinal reportPiper PA-44-180 · Daytona Beach, FLThe pilot's use of the aircraft to commit suicide.NTSB ATL98LA122Accident · No injuriesLimited investigationFinal reportCessna 172B · New Port Richey, FLThe pilots disregard of the performance capabilities of the airplane, his failure to attain and maintain flying speed, and his exceeding of the airplane's maximum weight.NTSB MIA98LA022Accident · No injuriesLimited investigationFinal reportCessna 172 · Crystal River, FLThe certified flight instructors improper supervision of the rated pilot during a crosswind landing resulting in an in-flight collision with the left wing of the airplane and the runway, subsequent loss of directional control on landing rollout, and collision…NTSB ATL97LA144Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Belleview, FLthe pilot's improper in-flight planning/decision, and his delay in initiating a go-around, which resulted in a hard touchdown, loss of directional control, and collision with objects (fence and trees).NTSB ATL97LA071Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Jacksonville, FLThe pilot's failure to maintain terrain clearance while on a low pass, leading to propeller damage. A factor was birds in the area.NTSB MIA97FA047Accident · 2 fatalField investigationFinal reportChampion 7GCBC · Fort Lauderdale, FLIntentional aerobatics at too low an altitude that did not allow for recovery from an intentional maneuver. Contributing to the accident was the operation of the airplane at an overgross weight condition.NTSB ATL97FA014Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Avon Park, FLThe pilot's improper use of the elevator trim, which resulted in runway contact by the propeller during the takeoff roll and subsequent loss of aircraft control.NTSB MIA96LA228Accident · Minor injuriesLimited investigationFinal reportCanadair T-33 · Punta Gorda, FLfailure of the pilot to extend the wing flaps for takeoff, and his failure to attain sufficient airspeed for flight with the flaps retracted, which resulted in a stall/mush after lift-off.NTSB ATL96FA074Accident · 2 fatalField investigationFinal reportCessna P210N · Marathon, FLfailure of the pilot to maintain sufficient altitude during an over-water approach at night. Factors relating to the accident were darkness and pilot fatigue.NTSB MIA96FA089Accident · 2 fatalField investigationFinal reportCessna 172D · Hawthorne, FLthe pilot's failure to maintain the proper glidepath during an instrument approach.NTSB MIA96LA086Accident · 1 fatalLimited investigationFinal reportNorth American SNJ-5 · West Palm Beach, FLFailure of the pilot to maintain adequate altitude/clearance above the water, while performing a low level maneuver (wing over). The pilot's ostentatious display of aerobatic flight was a related factor.NTSB MIA96LA085Accident · Minor injuriesLimited investigationFinal reportPiper PA-30-160 · St. Petersburg, FLthe pilot's failure to maintain the glide slope and becoming distracted by a passenger.NTSB MIA96LA074Accident · 1 fatalLimited investigationFinal reportYakovlev YAK-52 · Boynton Beach, FLPilot impairment of judgment and performance due to alcohol, his resultant improper planning/decision, and his failure to maintain sufficient altitude above the terrain while performing an aerobatic maneuver. Factors relating to the accident were: the pilot's…NTSB MIA95LA201Accident · No injuriesLimited investigationFinal reportCessna 150L · Opa Locka, FLThe pilot-in-command's improper use of flaps during an attempted go-around.NTSB MIA95LA054Accident · Minor injuriesLimited investigationFinal reportBell 47G · Bunnell, FLThe pilot's failure to maintain altitude while descending over a lake, resulting in an in-flight collision with water.NTSB MIA95LA044Accident · No injuriesLimited investigationFinal reportBell 206B · Miami, FLInadequate supervision by the pilot-in-command (CFI) for failure to note reduction in clearance between the tail rotor and an embankment.NTSB MIA94LA165Accident · Serious injuriesLimited investigationFinal reportHughes 369HS · Sarasota, FLAltitude misjudged by the pilot.NTSB MIA94LA120Accident · No injuriesLimited investigationFinal reportPitts S1-C · Lakeland, FLThe pilot-in-command's failure to maintain proper runway alignment during a crosswind landing.