NTSB investigations, 2012, FL

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

Cases per year

20082026
NTSB investigations, 2012, 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\") = 2012
    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 ERA13FA082Accident · 1 fatalField investigationFinal reportCessna 421C · Lake Worth, FLThe pilot's failure to follow established engine-out procedures and to maintain a proper airspeed after the total loss of engine power on one of the airplane’s two engines during the initial climb. Contributing to the accident was the total loss of engine…Dec 8, 2012 · N297DB · Substantial damageNTSB ERA13LA069Accident · Serious injuriesLimited investigationFinal reportLawson J/Bowie R/Smith M CA-8 · Merritt Island, FLThe pilot's improper decision to continue a cross-country flight as a primary control (aileron) system anomaly progressively worsened. Contributing to the accident was an aileron control system anomaly, the reason for which could not be determined because the…Nov 28, 2012 · N155JD · Substantial damageNTSB ERA13LA020Accident · 2 fatalLimited investigationFinal reportAirborne Windsports PTY XT-912 · Winter Haven, FLThe pilot’s failure to maintain aircraft control during takeoff in crosswind conditions, which resulted in collision with terrain.Oct 14, 2012 · N811RW · DestroyedNTSB ERA12CA521Accident · Minor injuriesData collectionFinal reportCessna 152 · Deland, FLThe pilot’s failure to maintain airplane control on final approach in gusting wind conditions. Contributing to the accident was the pilot’s decision to operate in an environment of thunderstorms and rapidly deteriorating weather.Aug 21, 2012 · N49054 · Substantial damageNTSB ERA12FA491Accident · 1 fatalField investigationFinal reportSilvaire Luscombe 8A · St. Petersburg, FLThe flight instructor’s and the pilot’s failure to maintain airspeed after a partial loss of engine power after takeoff for reasons that could not be determined during postaccident examination, which resulted in an aerodynamic stall and loss of airplane…Aug 1, 2012 · N2761K · Substantial damageNTSB ERA12LA477Accident · No injuriesLimited investigationFinal reportHughes 269C · St. Petersburg, FLThe pilot's failure to assure that the lateral friction control was released prior to flight.Jul 24, 2012 · N9679F · Substantial damageNTSB ERA12LA440Accident · Serious injuriesLimited investigationFinal reportCessna 170 · Panama City, FLA total loss of engine power due to water contamination of the fuel, the pilot/owner's inadequate preflight inspection of his airplane, and his failure to maintain airplane control after the engine failure.Jul 11, 2012 · N2561V · Substantial damageNTSB ERA12CA419Accident · No injuriesData collectionFinal reportCessna 172S · West Palm Beach, FLThe flight instructor’s failure to maintain airplane control during the takeoff in gusting crosswind conditions. Contributing to the accident was the flight instructor’s decision to conduct takeoffs and landings in conditions exceeding the airplane’s maximum…Jun 26, 2012 · N961MC · Substantial damageNTSB ERA12FA387Accident · 1 fatalField investigationFinal reportPhillips William L Challenger · Plant City, FLThe non-certificated pilot’s loss of control during approach and landing. Contributing to the accident was the pilot’s lack of both total and recent flight experience.Jun 9, 2012 · N2571T · Substantial damageNTSB ERA12FA385Accident · 6 fatalField investigationFinal reportPilatus PC-12/47 · Lake Wales, FLThe failure of the pilot to maintain control of the airplane while climbing to cruise altitude in instrument meteorological conditions (IMC) following disconnect of the autopilot. The reason for the autopilot disconnect could not be determined during…Jun 7, 2012 · N950KA · Substantial damageNTSB ERA12FA326Accident · 1 fatalField investigationFinal reportGutierrez Pablino Hummel Bird · DeFuniak Springs, FLThe pilot's failure to maintain airplane control due to the airplane’s exceedence of its maximum gross weight and center of gravity’s most rearward limit and his lack of familiarity with the airplane make and model, which resulted in an aerodynamic stall and…May 9, 2012 · N9001N · Substantial damageNTSB ERA12CA281Accident · No injuriesData collectionFinal reportPiper J3C-65 · Plantation Key, FLThe pilot’s failure to maintain adequate control of the airplane and ensure clearance from trees.Apr 13, 2012 · N75487 · Substantial damageNTSB ERA12FA271Accident · 1 fatalField investigationFinal reportWejebe Jose CA8 -SF · Everglades City, FLThe pilot’s failure to maintain sufficient airspeed during the initial climb after takeoff, which resulted in an aerodynamic stall and loss of airplane control.Apr 6, 2012 · N548SF · Substantial damageNTSB ERA12FA265Accident · Serious injuriesField investigationFinal reportSapp Larry E Seawind 3000 · Deland, FLA total loss of engine power for reasons that could not be determined because the damage and postimpact fire precluded thorough examination of the engine and its systems.Apr 2, 2012 · N514KT · Substantial damageNTSB ERA12LA264Accident · Serious injuriesLimited investigationFinal reportPowrachute Airwolf 912ULS · Plant City, FLThe flight instructor’s failure to ensure an obstruction-free takeoff path prior to initiating the takeoff and his inadequate preflight inspection of the powered parachute’s flight controls, which resulted in a collision with trees during the takeoff.Apr 1, 2012 · N415BA · Minor damageNTSB ERA12CA254Accident · No injuriesData collectionFinal reportFantasy Air Sro Allegro 2007 · Groveland, FLThe pilot's failure to maintain directional control during a go-around maneuver in gusty crosswind conditions.Mar 25, 2012 · N2570C · Substantial damageNTSB ERA12FA193Accident · 2 fatalField investigationFinal reportCessna 172S · Key West, FLThe non-night-qualified pilot's improper decision to depart in dark night visual meteorological conditions, which resulted in his subsequent spatial disorientation, loss of control, and impact with water.Feb 24, 2012 · N53589 · Substantial damageNTSB ERA12LA171Accident · Serious injuriesLimited investigationFinal reportMoore Byron J Zealot · Minneola, FLThe pilot's failure to maintain adequate airspeed on the base leg for landing, which resulted in an aerodynamic stall and loss of airplane control.Feb 6, 2012 · N61ZT · Substantial damageNTSB ERA12FA151Accident · 1 fatalField investigationFinal reportCessna 150G · Quincy, FLThe non-instrument-rated pilot’s spatial disorientation in night instrument meteorological conditions, which resulted in his inability to maintain controlled flight. Contributing to the accident was the pilot’s improper decision to take off in deteriorating…Jan 23, 2012 · N73JK · Substantial damage