NTSB investigations, FL
49 cases where the defining event was Miscellaneous/other.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 3 |
| 2010 | 1 |
| 2011 | 7 |
| 2012 | 4 |
| 2013 | 4 |
| 2014 | 3 |
| 2015 | 4 |
| 2016 | 6 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 5 |
| 2020 | 3 |
| 2021 | 1 |
| 2023 | 1 |
| 2024 | 3 |
| 2026 | 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '900')
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '900') 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 ERA26LA284Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Palmetto, FLThe flight instructor’s failure to maintain clearance from obstacles during low altitude maneuvering, which resulted in a collision with a fence.NTSB DCA25LA065Accident · Serious injuriesClass 3 · LimitedFinal reportUvify IFO · Orlando, FLThe remote pilot-in-command’s (RPIC’s) failure to locate the drone show center position over the physical location of the sUA, which resulted in multiple sUA colliding during the initial lift and subsequent loss of control. Contributing to the accident was…NTSB ERA24FA395Accident · 2 fatalClass 3 · FieldFinal reportEvolution Revo · Zephyrhills, FLThe flight instructor’s failure to ensure the haul back cable was securely connected to the “J” hook prior to departing on the accident flight, which resulted in the cable becoming disconnected and the wings folding up during flight.NTSB ERA24LA153Accident · Minor injuriesClass 3 · LimitedFinal reportDenzil Velarde MTO Sport · Tavernier, FLThe gyroplane’s encounter with a tailwind during the initial climb, which resulted in a loss of airspeed and subsequent forced landing.NTSB ERA23LA153Accident · No injuriesClass 4 · LimitedFinal reportGreen Richard H VAN'S RV7A · Williston, FLThe 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 ERA21LA302Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Brooksville, FLThe pilot's failure to maintain an appropriate distance between the airplane and hangar, which resulted in substantial damage to the right wing.NTSB ERA20LA310Accident · No injuriesClass 3 · LimitedFinal reportRobinson R22 · Fort Myers, FLForeign object damage of the turning tailrotor by a soft-bodied object, which resulted in the sudden stoppage of the tailrotor and the catastrophic failure of the tailrotor assembly and its mount structure.NTSB ERA20CA303Accident · No injuriesClass 4 · Data collectionFinal reportZenith CH601 · Punta Gorda, FLAn inadvertent opening of the airplane’s canopy on takeoff, which resulted in a loss of control and runway excursion.NTSB ERA20LA219Accident · No injuriesClass 3 · LimitedFinal reportCessna 152 · McAlpin, FLThe pilot’s failure to abort the takeoff after recognizing poor airplane acceleration, the reason for which could not be determined based on available evidence. Contributing to the accident was the pilot’s likely inadvertent initiation of the takeoff with the…NTSB GAA20CA044Accident · No injuriesData collectionFinal reportRichard B Carpenter AR-1 · Brooksville, FLThe pilot's failure to attain the proper rotor speed before takeoff, which resulted in the rotor blade striking the rudder. Contributing to the accident was the pilot's failure to abort the takeoff in a timely manner.NTSB ERA19LA282Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 337 · St. Augustine, FLThe failure of the pilot and examiner to recognize that the rear engine was not developing power, which resulted in an attempted partial-power takeoff and the airplane’s subsequent descent and impact with terrain.NTSB GAA19CA585Accident · No injuriesData collectionFinal reportBeech 23 · Keystone Heights, FLThe pilot's failure to maintain clearance from a construction sign during taxi operations.NTSB ERA19LA206Accident · No injuriesClass 3 · LimitedFinal reportBell OH58C · Gainesville, FLThe flight instructor's failure to maintain control of the helicopter during a simulated forced landing autorotation, which resulted in pylon whirl that substantially damaged the helicopter.NTSB ERA19TA133Accident · No injuriesClass 3Final reportCessna 650 · Sanford, FLThe pilot's failure to keep the airplane on the taxiway while taxiing at night. Contributing to the accident was a miscommunication between the flight crewmembers about the position of the airplane.NTSB ERA19CA002Accident · Serious injuriesData collectionFinal reportChampion 7FC · Myakka City, FLThe pilot's failure to maintain clearance from an obstacle during takeoff.NTSB ERA17LA163Accident · No injuriesLimited investigationFinal reportRobinson R44 · Orlando, FLA partial failure of the helicopter's engine tachometer due to the separation of one of the magnet assemblies and engine roughness, which precipitated the pilot’s initiation of an off-airport autorotation, during which he applied improper aft cyclic flight…NTSB ERA17LA018Accident · 1 fatalLimited investigationFinal reportCessna 208 · Dunnellon, FLThe jumpmaster's failure to guard the reserve parachute ripcord, which caused an inadvertent deployment of his reserve parachute.NTSB GAA16CA526Accident · No injuriesData collectionFinal reportSix Chuter Legend XL · Arcadia, FLThe pilot’s decision to take off in high-density altitude conditions, which resulted in the powered parachute being unable to maintain a sufficient climb rate and its subsequent impact with power lines.NTSB GAA16CA510Accident · No injuriesData collectionFinal reportGreat Lakes 2T1A · Port St. Lucie, FLThe pilot's failure to avoid the drainage pipe during the landing roll on a private grass airstrip. Contributing to the accident was the pilot's reduced forward view from the rear seat.NTSB ERA16LA213Accident · No injuriesLimited investigationFinal reportCessna 310 · Apopka, FLThe intermittent failure of the left brake master cylinder, which resulted in asymmetric braking and the subsequent loss of directional control during the landing roll.NTSB ERA16LA113Accident · No injuriesLimited investigationFinal reportLiberty Aerospace Liberty XL · Orlando, FLA failure of the right brake for reasons that could not be determined based on the available information. Contributing to the accident was the pilot's decision to continue the flight after experiencing a braking anomaly due to his perceived need for an…NTSB GAA16LA135Accident · No injuriesLimited investigationFinal reportPinkston Randy T RV-7 · Tavernier, FLThe pilot's misidentification of a parallel roadway for the runway and the airplane's subsequent collision with numerous objects during landing.NTSB ERA16FA043Accident · 2 fatalField investigationFinal reportBeech A36TC · Orlando, FLThe pilot's failure to maintain adequate airspeed while turning to join the final approach leg of the airport traffic pattern with full airplane-nose-up trim, which resulted in the airplane exceeding its critical angle of attack and experiencing an…NTSB ERA15LA337Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 369E · New Smyrna Beach, FLThe pilot’s inadequate visual lookout and failure to maintain clearance from trees while maneuvering at low altitude.NTSB ERA15LA140Accident · Serious injuriesLimited investigationFinal reportBombardier Canadair CL600-2A12 · Marco Island, FLThe failure of a spring inside the No. 2 brake’s upper brake control valve and the fracture of the coupling subassembly of the No. 1 wheel speed sensor during landing, which resulted in the loss of braking action, and the pilot-in-command’s (PIC) deactivation…NTSB ERA15FA129Accident · 4 fatalField investigationFinal reportBeech 1900 · Miami, FLThe left engine propeller's uncommanded travel to the feathered position during takeoff for reasons that could not be determined due to impact damage. Contributing to the accident was the flight crew's failure to establish a coordinated climb once the left…NTSB ERA14CA331Accident · No injuriesData collectionFinal reportCessna 172M · Miami, FLThe pilot's failure to ensure the security of the seat prior to flight, which resulted in a loss of control and subsequent hard landing.NTSB ERA14CA143Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Orlando, FLThe pilot's inadequate preflight inspection in which he failed to remove the tail rotor covers, which resulted in the failure of the tail rotor drive shaft during engine start.NTSB ERA14TA113Accident · No injuriesFinal reportHughes 369 · Naples, FLThe pilot's inadequate flare during the termination of a practice 180-degree autorotation and the flight instructor's delayed remedial action, which resulted in the tail rotor contacting the ground.NTSB ERA13LA381Accident · No injuriesLimited investigationFinal reportCessna 172N · Miami, FLThe pilot’s incapacitation due to a seizure during taxi.NTSB ERA13CA278Accident · No injuriesData collectionFinal reportPiper PA-46-500TP · West Palm Beach, FLThe pilot’s diversion of attention while taxiing the airplane, which resulted in his failure to maintain directional control and collision with a ditch.NTSB ERA13LA198Accident · No injuriesLimited investigationFinal reportFranke Russell J Searey · Polk City, FLAn inadvertent encounter with the water wake from a larger amphibious airplane before takeoff and the pilot's subsequent inadequate preflight inspection of the airplane during which he failed to note damage caused by the wake encounter.NTSB ERA13CA137Accident · Minor injuriesData collectionFinal reportCessna 172N · Okeechobee, FLThe pilot’s failure to maintain directional control during takeoff.NTSB ERA12LA429Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 · Tallahassee, FLThe pilot’s failure to maintain awareness of the helicopter’s altitude while attempting to troubleshoot the clutch actuator warning light, which resulted in an inadvertent descent and impact with water. Contributing to the accident was the pilot's possible…NTSB ERA12LA314Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lake Wales, FLThe student pilot’s decision to depart from an intersection with insufficient runway remaining for takeoff, which resulted in a rejected takeoff and subsequent runway excursion.NTSB ERA12CA244Accident · No injuriesData collectionFinal reportMooney M20M · Clearwater, FLThe pilot’s failure to extend the landing gear before landing due to his distraction regarding another airplane in the traffic pattern.NTSB ERA12CA137Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · St Petersburg, FLThe flight instructor's delayed remedial action during the pilot-receiving-instruction's practice autorotation that developed a high rate of descent. Contributing to the accident was the pilot-receiving-instruction's improper control inputs during the…NTSB ERA12CA082Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Brooksville, FLThe pilot's incorrect identification of the runway, which resulted in an off-airport landing and subsequent collision with objects.NTSB ERA12LA077Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Mulberry, FLThe pilot’s failure to abort the takeoff after recognizing the airplane’s poor performance during the takeoff roll. Contributing to the passenger’s injuries was the pilot’s failure to provide a briefing on the use of the lapbelt, which delayed the passenger’s…NTSB ERA12CA291Accident · Serious injuriesData collectionFinal reportNorth American SNJ-6 · Kissimmee, FLThe passenger’s fall from the airplane during a normal egress.NTSB OPS12IA041Incident · No injuriesIncident investigationFinal reportCessna 172S · Daytona Beach, FLThe departing pilot's incorrect runway selection and non-compliance with an air traffic control clearance. Contributing to the incident was the air traffic controller's inadequate monitoring of the departing aircraft to ensure that the pilot complied with the…NTSB ERA11CA448Accident · No injuriesData collectionFinal reportRobinson R22 · Titusville, FLThe private pilot's incorrect manipulation of the engine mixture control which resulted in an inadvertent engine shutdown.NTSB ERA11CA446Accident · No injuriesData collectionFinal reportCessna 172S · St. Augustine, FLThe student pilot's loss of directional control while attempting to close the airplane's door during takeoff roll.NTSB ERA11CA180Accident · Serious injuriesData collectionFinal reportRobinson Helicopter R44 II · Weston, FLThe pilot's failure to maintain adequate altitude and physical alertness which resulted in an in-flight collision with the water. Contributing to the accident was the pilot's fatigue.NTSB ERA10LA172Accident · No injuriesLimited investigationFinal reportHughes 369 · Naples, FLThe pilot's excessive aft cyclic imput during the flare following an practice autorotation, which resulted in main rotor blade contact with the tail boom.NTSB ERA09CA548Accident · No injuriesData collectionFinal reportPiper PA-20 · Herlong, FLThe pilot’s improper visual lookout while taxing on soft terrain.NTSB ERA09IA240Incident · 1 fatalIncident investigationFinal reportBeech B200 · Fort Myers, FLThe pilot’s abnormal heart rhythm resulting in incapacitation.NTSB ERA09FA133Accident · No injuriesField investigationFinal reportPiper PA-46-500TP · Milton, FLThe pilot's intentional inflight abandonment of the airplane.NTSB OPS08IA006Incident · No injuriesIncident investigationFinal reportPiper PA-28-161 · St. Augustine, FLThe pilot's failure to adhere to the controller's takeoff instruction. Contributing to the incident was the controller's failure to properly monitor the flight, and the controller's decision to perform lesser duty priorities during the takeoff roll.