NTSB investigations, 2010, FL

10 cases where the sequence of events included Loss of control in flight.

Cases per year

20082026
NTSB investigations, 2010, FL per year, 2008–2026: 305 cases
200823
200922
201010
201122
201219
201316
201416
201521
201616
201717
201825
201911
202015
202113
202210
202313
202411
202516
20269

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\" = '240' 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 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 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 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 ERA10FA464Accident · 2 fatalField investigationFinal reportCessna 150H · DeLand, FLThe pilot's failure to maintain adequate airspeed and airplane control during the initial climb, which resulted in an aerodynamic stall, wire strike, and subsequent impact with the ground.Sep 4, 2010 · N23471 · 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 ERA10CA262Accident · Minor injuriesData collectionFinal reportHiller UH12 · Sarasota, FLThe pilot's delayed remedial action to maintain main rotor rpm, which resulted in a loss of lift and hard landing.May 9, 2010 · N116S · 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 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 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