NTSB investigations, 2017, FL
50 cases where the sequence of events included Collision with terr/obj (non-CFIT).
Cases per year
| 2008 | 50 |
|---|---|
| 2009 | 43 |
| 2010 | 48 |
| 2011 | 50 |
| 2012 | 56 |
| 2013 | 45 |
| 2014 | 47 |
| 2015 | 46 |
| 2016 | 55 |
| 2017 | 50 |
| 2018 | 65 |
| 2019 | 39 |
| 2020 | 26 |
| 2021 | 21 |
| 2022 | 30 |
| 2023 | 23 |
| 2024 | 37 |
| 2025 | 29 |
| 2026 | 18 |
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 year(c.\"eventDate\") = 2017
AND c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 year(c."eventDate") = 2017 AND c."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN18FA061Accident · 5 fatalField investigationFinal reportCessna 340 · Bartow, FLThe pilot's loss of control due to spatial disorientation during takeoff in instrument meteorological conditions.NTSB GAA18CA093Accident · No injuriesData collectionFinal reportLet L 23 Super Blanik · Clermont, FLThe student pilot’s failure to maintain directional control during the landing flare.NTSB ERA18FA056Accident · 1 fatalField investigationFinal reportBeech G35 · Cross City, FLThe pilot's improper decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in the pilot experiencing spatial disorientation and a subsequent loss of airplane control.NTSB ERA18LA050Accident · No injuriesLimited investigationFinal reportCessna 152 · Everglades City, FLThe loose nut connecting the mixture control cable to the mixture control arm, which resulted in the pilot’s inability to control the mixture and the subsequent total loss of engine power.NTSB CEN18FA050Accident · 1 fatalField investigationFinal reportSmith Aerostar 601 · Miami, FLThe pilot's loss of control while returning to the airport after takeoff for reasons that could not be determined based on the available information.NTSB WPR18FA045Accident · 3 fatalField investigationFinal reportBeech C90 · Geneva, FLThe pilot's loss of airplane control due to spatial disorientation during an instrument approach in instrument meteorological conditions, and the flight instructor's delayed remedial action. Contributing to the accident was the flight instructor's impairment…NTSB ANC18LA014Accident · No injuriesLimited investigationFinal reportCessna 172 · Miami, FLThe pilot's decision to continue the landing after a loss of visual cues during a night landing.NTSB WPR18LA040Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Odessa, FLA loss of engine power due to fuel starvation as a result of the pilot's inadequate planning and in-flight fuel management. Contributing to the accident was the pilot’s failure to follow proper procedures after the loss of engine power.NTSB ERA18FA030Accident · 1 fatalField investigationFinal reportMooney M20C · Starke, FLThe pilot's loss of control due to spatial disorientation while maneuvering in instrument meteorological conditions. Contributing was the pilot's lack of instrument currency and his self-induced pressure to complete the flight.NTSB ANC18LA010Accident · No injuriesLimited investigationFinal reportRockwell International 112A · Clearwater, FLA total loss of engine power for reasons that could not be determined based on the available information.NTSB GAA18CA053Accident · No injuriesData collectionFinal reportPiper PA 28R · Melborne, FLThe pilot’s loss of directional control during the landing roll on the wet runway.NTSB ANC18FA007Accident · 1 fatalField investigationFinal reportIcon A5 · Clearwater, FLThe pilot's improper decision to perform aggressive, low-altitude maneuvers due to his impairment from the use of multiple psychoactive substances, which resulted in a loss of control.NTSB ERA17LA340Accident · Minor injuriesLimited investigationFinal reportWaco UPF 7 · Ocklawaha, FLA failure of both magnetos due to multiple deficiencies, which resulted in a total loss of engine power.NTSB ERA17FA339Accident · 1 fatalField investigationFinal reportHickox Andy Andys Gyroplane · Umatilla, FLThe pilot's improper response to a total loss of engine power, which resulted in main rotor blade contact with the rudder and vertical stabilizer, and a subsequent uncontrolled descent. The loss of engine power was due to the separation of the electrical…NTSB ERA17LA335Accident · Minor injuriesClass 3 · LimitedFinal reportBrad J Bates Mosquito XE 285 · Odessa, FLA total loss of engine power due to cold seizure of the No.1 piston, which resulted in its failure and a subsequent emergency autorotation and impact with a house’s roof.NTSB ERA17LA332Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 · Clearwater, FLThe airplane pilot's inadequate visual lookout, which resulted in an in-flight collision with a helicopter. Contributing to the accident was the airplane pilot's failure to adequately transmit his position while operating in the airport traffic pattern.NTSB ERA17LA311Accident · No injuriesLimited investigationFinal reportPiper PA32R · Merritt Island, FLThe pilot's inadequate preflight planning and improper takeoff technique, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall.NTSB ERA17LA270Accident · Serious injuriesLimited investigationFinal reportPipistrel Doo Ajdovscina Virus SW · Immokalee, FLThe pilot's failure to attain adequate airspeed during an attempted go-around, which resulted in an aerodynamic stall.NTSB ERA17LA264Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA 4 · Orlando, FLA loss of directional control during taxi operations for reasons that could not be determined based on the available information, which resulted in the airplane rolling into a ditch.NTSB WPR17FA151Accident · 2 fatalField investigationFinal reportPiper PA 44-180 · Marineland, FLA loss of control in flight for reasons that could not be determined based on the available information, which resulted in an in-flight breakup.NTSB ERA17LA242Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Key Biscayne, FLThe nearly complete blockage of the right fuel tank strainer with organic material, which resulted in fuel starvation and the subsequent total loss of engine power. Contributing to the fuel starvation was the pilot receiving instruction’s and the flight…NTSB ERA17CA244Accident · No injuriesData collectionFinal reportMooney M20R · Venice, FLThe pilot’s failure to maintain directional control during landing in a gusting crosswind conditions.NTSB ERA17LA266Accident · No injuriesLimited investigationFinal reportPiper PA28R · Pembroke Pines, FLThe loss of engine power for reasons that could not be determined postaccident engine test-runs revealed no preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA17LA237Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Bartow, FLA total loss of engine power during initial climb for reasons that could not be determined because postaccident examination of the airplane revealed no evidence of mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA17CA236Accident · Serious injuriesData collectionFinal reportProgressive Aerodyne Searey LSA · Lake Ashby, FLThe pilot's incorrect configuration of the landing gear for a water landing in an amphibious airplane, which resulted in a nose-over.NTSB ERA17LA234Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Cape Coral, FLA total loss of engine power due to fuel contamination with water and the pilot's inadequate preflight inspection that detected, but did not fully resolve, the water contamination of the fuel system.NTSB ERA17FA231Accident · 1 fatalField investigationFinal reportCessna 152 · Homestead, FLThe pilot's loss of control due to spatial disorientation while maneuvering in night conditions over an area devoid of ground reference lights.NTSB ERA17LA220Accident · Serious injuriesLimited investigationFinal reportNunley KR2 · Baker, FLA partial loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no evidence of any preaccident mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA17LA212Accident · Minor injuriesLimited investigationFinal reportAero Commander 200D · Panama City, FLThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot's failure to use the emergency checklist to restart the engine.NTSB ERA17FA210Accident · 1 fatalField investigationFinal reportPiper PA28 · Fort Myers, FLA partial loss of engine power during initial climb for reasons that could not be determined because extensive fire damage precluded thorough examination of the engine and its associated systems.NTSB ERA17CA208Accident · No injuriesData collectionFinal reportPiper PA23 · Cedar Key, FLThe pilot's failure to stop the airplane within the available runway after conducting the approach and landing with a tailwind.NTSB ERA17LA201Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22 · Gordonville, FLThe pilot's failure to properly configure the mixture control for landing due to disorientation because he had the airport diagram upside down, which resulted in a total loss of engine power.NTSB ERA17LA202Accident · No injuriesClass 3 · LimitedFinal reportCessna 172P · Tamiami, FLA partial loss of engine power during the initial climb due to carburetor icing.NTSB GAA17CA324Accident · No injuriesData collectionFinal reportJess Just Aircraft Supers · Boca Raton, FLThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA17CA277Accident · No injuriesData collectionFinal reportCessna 172 · Boca Raton, FLThe student pilot’s failure to maintain directional control of the airplane while landing with a tailwind.NTSB ERA17TA170Accident · Serious injuriesFinal reportBell 206 · Orange Springs, FLThe pilot's failure to maintain adequate clearance between the helicopter's skid and the firefighting bucket and suspension cable, which resulted in the cable becoming entangled on the landing skid and a subsequent loss of helicopter control.NTSB ERA17LA169Accident · No injuriesLimited investigationFinal reportPiper PA32RT · Coral Springs, FLThe in-flight disconnection of the fuel injection servo throttle linkage, which resulted in a loss of engine power.NTSB ERA17FA155Accident · 4 fatalField investigationFinal reportCessna 170 · Williston, FLThe pilot's failure to maintain adequate airspeed during initial climb in gusty wind conditions, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall/spin.NTSB ERA17FA148Accident · 1 fatalField investigationFinal reportPiper PA 12 · Sanford, FLThe incorrect rigging of the elevator control cables, which resulted in a reversal of elevator control inputs applied by the pilot during the takeoff, an excessive nose-high pitch, and subsequent aerodynamic stall after takeoff. Also causal was the inadequate…NTSB ERA17FA145Accident · 1 fatalField investigationFinal reportPipistrel Virus SW · Micanopy, FLThe pilot's intentional flight into an area of known convective thunderstorm activity, which resulted in an in-flight breakup.NTSB ERA17FA143Accident · 2 fatalField investigationFinal reportCessna 170B · Edgewater, FLThe Cessna pilot's failure to maintain clearance from the Grumman during the transition to a different formation. Contributing to the accident was the stepped down configuration of the formation flight which was composed of dissimilar aircraft.NTSB GAA17CA181Accident · No injuriesData collectionFinal reportAerotek Pitts S-2A · West Palm Beach, FLThe pilot's failure to maintain directional control during the landing roll in crosswind conditions.NTSB ERA17LA121Accident · No injuriesLimited investigationFinal reportCessna 340 · Ft Lauderdale, FLFailure of the left main landing gear downlock link, which resulted in a landing gear collapse during the landing roll.NTSB GAA17CA163Accident · No injuriesData collectionFinal reportCessna 172S · St Petersburg, FLThe student pilot’s overcompensation of right rudder pedal application during the landing roll, which resulted in a loss of directional control and impact with runway signage and a fence.NTSB ERA17FA108Accident · 3 fatalField investigationFinal reportPiper PA28R · Cedar Key, FLThe non-instrument-rated pilot's improper decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control.NTSB GAA17CA138Accident · No injuriesData collectionFinal reportBeech T 34B · St. Petersburg, FLThe pilot's failure to maintain an appropriate glidepath to the runway.NTSB GAA17CA136Accident · Minor injuriesData collectionFinal reportNielsen Martin M Challenger II · Punta Gorda, FLThe pilot’s failure to maintain directional control during landing.NTSB ERA17CA101Accident · No injuriesData collectionFinal reportRobinson R22 · West Palm Beach, FLThe flight instructor’s failure to maintain helicopter control while demonstrating low rotor rpm operations from a hover.NTSB GAA17CA169Accident · No injuriesData collectionFinal reportCessna 152 · Bonifay, FLThe student pilot's failure to maintain directional control during landing in crosswind conditions.NTSB ERA17FA088Accident · 1 fatalField investigationFinal reportSharpe William L Buccaneer II B · Mayo, FLThe pilot's failure to see and avoid power lines while flying at low altitude.