NTSB investigations, 2010, FL

48 cases where the sequence of events included Collision with terr/obj (non-CFIT).

Cases per year

20082026
NTSB investigations, 2010, FL per year, 2008–2026: 778 cases
200850
200943
201048
201150
201256
201345
201447
201546
201655
201750
201865
201939
202026
202121
202230
202323
202437
202529
202618

Latest 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\") = 2010
    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.

NTSB ERA11LA103Accident · No injuriesLimited investigationFinal reportCessna 152 · Wimauma, FLThe mechanic/pilot's failure to detect a visible exhaust gas leak and cracked cylinder head immediately prior to the accident flight, which resulted in a partial loss of engine power during initial climb. Contributing to the accident was an inadequate…Dec 31, 2010 · N28BA · Substantial damageNTSB ERA11CA096Accident · No injuriesData collectionFinal reportCessna 172S · Fort Myers, FLThe pilot's failure to maintain directional control during the takeoff roll. Contributing to the accident was the pilot’s attempt to take off with full flaps.Dec 23, 2010 · N385ME · Substantial damageNTSB ERA11CA081Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Pahokee, FLThe pilot's failure to maintain control of the helicopter during takeoff.Dec 8, 2010 · N666SL · Substantial damageNTSB ERA11CA080Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Canal Point, FLPilot fatigue due to lack of sleep resulting in incapacitation (falling asleep) and ground contact while maneuvering at a low altitude.Dec 8, 2010 · N451DB · Substantial damageNTSB ERA11LA079Accident · Minor injuriesLimited investigationFinal reportEasler Kelly Rans S6ES · St. Augustine, FLA total loss of engine power during initial climb for undetermined reasons.Dec 2, 2010 · N26PP · Substantial damageNTSB ERA11CA069Accident · No injuriesData collectionFinal reportCessna 172G · Winter Haven, FLThe pilot's inadequate preflight/inflight fuel planning resulting in fuel exhaustion and total loss of engine power.Nov 21, 2010 · N3700L · Substantial damageNTSB ERA11GA066Accident · 3 fatalFinal reportCessna M337B · Avon Park, FLThe pilot's inadvertent encounter with an unexpected intense rain shower with severe turbulence at night.Nov 18, 2010 · N1309 · Substantial damageNTSB ERA11LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Hobe Sound, FLA partial loss of engine power due to fuel contamination in the carburetor.Nov 16, 2010 · N8306B · Substantial damageNTSB ERA11CA059Accident · No injuriesData collectionFinal reportHiller-Rogerson Helicopter UH12E · Madison, FLThe pilot's encounter with a settling with power condition while he was performing slow, low-level, out-of- ground-effect flight maneuvers.Nov 15, 2010 · N4034Z · Substantial damageNTSB ERA11FA054Accident · 4 fatalField investigationFinal reportPiper PA-44-180 · West Palm Beach, FLThe failure of both the pilot and the certified flight instructor to ensure that the left fuel selector was in the on position for takeoff and their failure to follow the proper procedures when the left engine lost power shortly after takeoff, resulting in an…Nov 11, 2010 · N883FT · Substantial damageNTSB ERA11LA063Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Merritt Island, FLThe pilot's failure to maintain directional control while landing, which resulted in a main landing gear collapse and subsequent runway excursion.Nov 10, 2010 · N82934 · Substantial damageNTSB ERA11CA039Accident · No injuriesData collectionFinal reportCessna 172P · Tampa, FLThe student pilot's failure to maintain directional control during a short-field takeoff.Oct 28, 2010 · N612CB · Substantial damageNTSB ERA11CA030Accident · Minor injuriesData collectionFinal reportCirrus SR20 · Sanford, FLThe student pilot's loss of directional control during a go-around maneuver following a bounced landing.Oct 21, 2010 · N495DA · Substantial damageNTSB ERA11CA027Accident · No injuriesData collectionFinal reportPiper PA28 · Titusville, FLAn inadvertent collision with a deer during a night takeoff.Oct 19, 2010 · N9247V · Substantial damageNTSB ERA11IA026Incident · No injuriesIncident investigationFinal reportShort Bros. & Harland Shorts SC7 Skyvan · Fort Lauderdale, FLThe flightcrew’s failure to maintain directional control while initiating an engine reverse after landing.Oct 18, 2010 · N80GB · Minor damageNTSB ERA11CA029Accident · No injuriesData collectionFinal reportSqueglia R/Wheeler W Hummel Bird · Hollywood, FLThe pilot's inadequate flare, which resulted in a hard landing.Oct 18, 2010 · N824RS · Substantial damageNTSB ERA11CA020Accident · Minor injuriesData collectionFinal reportMooney M20E · New Smyrna Beach, FLThe pilot’s inadequate preflight inspection, which resulted in the loss of engine power due to water contaminated fuel.Oct 13, 2010 · N5743Q · Substantial damageNTSB ERA10LA494Accident · No injuriesLimited investigationFinal reportCessna 172D · Palm Beach, FLThe pilot's failure to use carburetor heat which led to a loss of engine power due to carburetor icing.Sep 18, 2010 · N2483Y · Substantial damageNTSB ERA10LA463Accident · Minor injuriesLimited investigationFinal reportQuicksilver MX-2 · Lake City, FLA partial loss of engine power for undetermined reasons.Sep 2, 2010 · N7108Z · Substantial damageNTSB ERA10LA457Accident · No injuriesLimited investigationFinal reportAero Commander 560E · Jacksonville, FLThe pilot's inadequate preflight inspection, which resulted in a total loss of power in both engines during climb due to fuel contamination.Aug 31, 2010 · N175SP · Substantial damageNTSB ERA10LA450Accident · No injuriesLimited investigationFinal reportAir Tractor AT402 · Pompano Beach, FLThe pilot's delayed decision to abort the takeoff, which resulted in a runway overrun and a subsequent collision with obstacles and terrain. Contributing to the accident was the airplane's high gross weight.Aug 28, 2010 · N4172U · Substantial damageNTSB ERA10CA417Accident · No injuriesData collectionFinal reportPiper PA-25-260 · St. Petersburg, FLThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.Aug 12, 2010 · N254AB · Substantial damageNTSB ERA10CA399Accident · No injuriesData collectionFinal reportSchweizer 269C · Baldwin, FLA loss of tail rotor effectiveness during a hover.Aug 4, 2010 · N6143K · Substantial damageNTSB ERA10LA391Accident · 1 fatalLimited investigationFinal reportTurck G L/Duflo J T SEA REY · Winter Haven, FLThe pilot's failure to maintain adequate airspeed on approach for landing, resulting in an inadvertent stall/spin and collision with water.Aug 2, 2010 · N914SR · Substantial damageNTSB ERA10CA368Accident · No injuriesData collectionFinal reportPiper PA-32R-300 · St. Petersburg, FLThe pilot's loss of directional control while taking off with a crosswind.Jul 15, 2010 · N38448 · Substantial damageNTSB ERA10FA342Accident · 2 fatalField investigationFinal reportNorth American AT-6 · Destin, FLThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall and spin. Contributing to the accident was the pilot's improper decision to perform the maneuvers at a low altitude and over water.Jul 2, 2010 · N92778 · Substantial damageNTSB ERA10CA333Accident · No injuriesData collectionFinal reportQuartz Mountain Aerospace 11E · Inglis, FLA loss of engine power due to fuel exhaustion as a result of the pilot's fuel mismanagement.Jun 25, 2010 · N216JD · Substantial damageNTSB ERA10LA307Accident · No injuriesLimited investigationFinal reportCessna 210L · Tampa, FLThe total loss of engine power due to inadequate torgue on the crankcase bolts. Contributing to the accident was the inadequate inspection performed 19.5 hours prior to the accident.Jun 9, 2010 · N2263S · Substantial damageNTSB ERA10CA326Accident · No injuriesData collectionFinal reportCessna 172 · New Smyrna Beach, FLThe student pilot’s improper landing flare, and the flight instructor's delayed remedial action.Jun 9, 2010 · N62568 · Substantial damageNTSB ERA10LA301Accident · No injuriesLimited investigationFinal reportHood John Sidney Tango · New Port Richey, FLThe improper inspection of the airplane ignition system during the last condition inspection by a mechanic, resulting in an ignition cable disconnecting and a partial loss of engine power.Jun 7, 2010 · N76HT · Substantial damageNTSB ERA10LA298Accident · No injuriesLimited investigationFinal reportCessna 150M · Pahokee, FLA partial loss of power during takeoff for undetermined reasons.Jun 5, 2010 · N2990V · Substantial damageNTSB ERA10LA293Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Dania Beach, FLThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.Jun 1, 2010 · N1435F · Substantial damageNTSB ERA10LA284Accident · Minor injuriesLimited investigationFinal reportCessna 337G · High Springs, FLThe pilot's failure to follow the published engine-out procedures after a total loss of power in the rear engine. Contributing to the accident was the inadequate maintenance and inspection of the engine by the pilot and maintenance personnel.May 27, 2010 · N72268 · Substantial damageNTSB ERA10LA280Accident · 1 fatalLimited investigationFinal reportGardner Douglas P VAN/RV8A · Sebring, FLThe pilot's failure to maintain control of the airplane during the landing approach.May 23, 2010 · N456DG · Substantial damageNTSB ERA10LA267Accident · Serious injuriesLimited investigationFinal reportPiper PA-46-350P · Clearwater, FLThe overweight condition of the airplane due to the pilot's inadequate preflight planning, resulting in the airplane's degraded climb performance. Contributing to the accident was the pilot's retraction of the flaps prior to reaching the manufacturer's…May 16, 2010 · XBLTH · Substantial damageNTSB ERA10CA257Accident · No injuriesData collectionFinal reportCessna 305A · Fort Pierce, FLThe pilot's failure to maintain directional control during a crosswind landing.May 6, 2010 · N5312G · Substantial damageNTSB ERA10LA235Accident · No injuriesLimited investigationFinal reportCessna 152 · Avon Park, FLThe operator's failure to correct known deficiencies with the carburetor, which resulted in a complete loss of engine power and subsequent forced landing by the pilot. Also causal was the operator's decision to rent the airplane in an unairworthy condition.Apr 18, 2010 · N5499B · Substantial damageNTSB ERA10FA232Accident · 1 fatalField investigationFinal reportMaule M5-235C · Zellwood, FLThe pilot's failure to maintain airspeed while maneuvering after takeoff, which resulted in an aerodynamic stall, loss of aircraft control, and collision with trees.Apr 18, 2010 · N9196E · Substantial damageNTSB ERA10LA233Accident · 1 fatalLimited investigationFinal reportCessna 172H · Archer, FLThe pilot's failure to maintain adequate airspeed for undetermined reasons while maneuvering in the vicinity of an airport, which resulted in an aerodynamic stall and hard landing.Apr 16, 2010 · N8112L · Substantial damageNTSB ERA10LA229Accident · No injuriesLimited investigationFinal reportDalin Ronald K T-51 Mustang · Lakeland, FLThe builder’s use of inadequate material for the exhaust manifold adapters resulting in heat damage and chafing of the crankshaft synchronizer and timing wires that rendered an inoperative ignition system and loss of engine power.Apr 14, 2010 · N551RD · Substantial damageNTSB ERA10CA225Accident · No injuriesData collectionFinal reportLuscombe 8A · Lakeland, FLThe pilot's failure to maintain directional control of the airplane during the landing roll, resulting in a ground loop.Apr 10, 2010 · N1128K · Substantial damageNTSB ERA10LA205Accident · 1 fatalLimited investigationFinal reportCupaiole RV-6A · West Palm Beach, FLThe total loss of engine power and the pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall and spin. The reason for the loss of power could not be determined.Apr 3, 2010 · N84KM · Substantial damageNTSB ERA10FA163Accident · 2 fatalField investigationFinal reportNorth American T6 · Santa Rosa Beach, FLThe pilot's failure to maintain airspeed during a low altitude,over water aerobatic maneuver, which resulted in an aggravated stall/spin. Contributing to the accident were the pilot's loss of situational awareness and his decision to perform aerobatics at a…Mar 6, 2010 · N47LF · DestroyedNTSB ERA10LA162Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200T · Vero Beach, FLThe certified flight instructor's failure to monitor the airspeed while the student performed a single-engine approach.Mar 5, 2010 · N103GK · Substantial damageNTSB ERA10LA159Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Arcadia, FLThe total loss of engine power due to a fatigue fracture of the crankshaft resulting from worn bearings.Mar 3, 2010 · N4797K · Substantial damageNTSB ERA10FA150Accident · 2 fatalField investigationFinal reportBeech C23 · Winter Haven, FLThe pilot’s improper placement of the fuel selector valve during takeoff, and his failure to maintain adequate airspeed following a total loss of engine power resulting in an inadvertent stall. Contributing to the accident was the failure of maintenance…Feb 25, 2010 · N180ED · Substantial damageNTSB ERA10LA127Accident · No injuriesLimited investigationFinal reportCessna 150G · St. Augustine, FLA loss of engine power due to fuel exhaustion caused by the failure of the right wing fuel tank sending unit gasket, which resulted in a forced landing.Feb 1, 2010 · N3995J · Substantial damageNTSB ERA10LA119Accident · 1 fatalLimited investigationFinal reportQuad City Challenger · Palmetto, FLThe non-certificated pilot's failure to maintain airspeed which resulted in an inadvertent stall and subsequent impact with the ground. Contributing to the accident was his impairment due to the prescription narcotic medication he was taking.Jan 14, 2010 · UNREG · Substantial damage