NTSB investigations, 2008, FL

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

Cases per year

20082026
NTSB investigations, 2008, 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\") = 2008
    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 ERA09CA101Accident · Minor injuriesData collectionFinal reportSteven G Goonen Searey · Polkland, FLA loss of control during the initial climb for undetermined reasons.Dec 20, 2008 · N628MS · Substantial damageNTSB ERA09FA092Accident · 1 fatalField investigationFinal reportCessna 172S · Goodland, FLThe pilot's failure to maintain aircraft control due to spatial disorientation. Contributing to the accident was the night light conditions.Dec 18, 2008 · N967SP · DestroyedNTSB ERA09FA074Accident · 2 fatalField investigationFinal reportBeech 35-B33 · Homosassa Spgs., FLThe pilot’s continued flight into known adverse weather conditions.Nov 30, 2008 · N945T · DestroyedNTSB MIA08LA162Accident · Serious injuriesLimited investigationFinal reportNorth Wing Apache CLA · Boynton Beach, FLThe failure of the pilot to maintain control of the aircraft.Aug 9, 2008 · N3880A · Substantial damageNTSB MIA08LA152Accident · 2 fatalLimited investigationFinal reportMorris George Velocity 173RG · St. Augustine, FLA loss of control in flight due to undetermined reasons.Jul 31, 2008 · N269VE · Substantial damageNTSB MIA08LA134Accident · 1 fatalLimited investigationFinal reportDouglas A. Pohl Lancair IV-P · Hollywood, FLA loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to maintain aircraft control which resulted in an aerodynamic stall.Jul 7, 2008 · N488SD · Substantial damageNTSB NYC08CA241Accident · Minor injuriesData collectionFinal reportStol UC-1 Twin Bee · Bunnell, FLThe flight instructor's inadequate recovery from a bounced landing.Jul 4, 2008 · N9509U · Substantial damageNTSB MIA08CA127Accident · Minor injuriesData collectionFinal reportLima Sky Raider I · Homestead, FLThe pilot's failure to maintain airspeed during initial climb.Jun 27, 2008 · N2642F · DestroyedNTSB NYC08LA221Accident · 2 fatalLimited investigationFinal reportPiper PA-18-150 · Lake Placid, FLThe pilot’s performance of a nonstandard abrupt maneuver at low altitude, which resulted in a loss of aircraft control.Jun 20, 2008 · N988PC · Substantial damageNTSB MIA08LA121Accident · 1 fatalLimited investigationFinal reportMckeehan James F Acroduster II SA750 · Panama City, FLThe pilot's inability to recover from an intentional aerobatic maneuver due to loss of aileron control. Contributing to the accident was the installation of an inadequate aileron secondary stop block against the main spar of both lower wings.Jun 16, 2008 · N363J · Substantial damageNTSB NYC08LA213Accident · Minor injuriesLimited investigationFinal reportMarrin Pitts S-1 · St. Petersburg, FLThe pilot's failure to maintain adequate airspeed following a partial loss of engine power, which resulted in an aerodynamic stall. Contributing to the accident was improper maintenance practices during the construction of the airplane, which resulted in…Jun 12, 2008 · N347MM · Substantial damageNTSB NYC08FA211Accident · Serious injuriesField investigationFinal reportAvid Mark IV Aerobat · Niceville, FLThe pilot's loss of control during landing for undetermined reasons.Jun 9, 2008 · N652DM · Substantial damageNTSB NYC08CA205Accident · No injuriesData collectionFinal reportLuscombe 8A · Indiantown, FLAn inadequate annual inspection that failed to detect a damaged rudder cable which resulted in the cable's subsequent failure during takeoff.Jun 3, 2008 · N37012 · Substantial damageNTSB NYC08CA194Accident · Serious injuriesData collectionFinal reportAeronca 7AC · Valkaria, FLThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall.May 25, 2008 · N1457E · Substantial damageNTSB LAX08LA130Accident · Serious injuriesLimited investigationFinal reportGreco Drifter 912 · Homestead, FLThe pilot's failure to maintain adequate airspeed during a turn to the final approach leg of the traffic pattern, resulting in an accelerated stall.May 5, 2008 · N5318F · Substantial damageNTSB MIA08LA089Accident · 1 fatalLimited investigationFinal reportDayon Lancair Legacy · Lakeland, FLThe pilot's failure to maintain aircraft control. Contributing to the accident was the pilot's distraction with the canopy during takeoff.Apr 13, 2008 · N1177M · Substantial damageNTSB NYC08CA159Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Vero Beach, FLThe student pilot's loss of directional control on landing. Contributing to the accident was the crosswind and wind gusts.Apr 7, 2008 · N9233X · Substantial damageNTSB NYC08FA148Accident · 1 fatalField investigationFinal reportPiper PA 28-161 · Venice, FLThe pilot's inflight loss of control for undetermined reasons.Mar 25, 2008 · N465TC · Substantial damageNTSB NYC08CA141Accident · No injuriesData collectionFinal reportPiper PA-25-260 · Opa Locka, FLThe entanglement of the hook rope with the rudder horn during banner pickup.Mar 17, 2008 · N169AB · Substantial damageNTSB NYC08CA136Accident · Serious injuriesData collectionFinal reportJ&J Ultralights Sea Wing · Live Oak, FLThe student pilot's failure to maintain directional control during a go-around. Contributing to the accident was his habit interference from previously flying conventional airplanes.Mar 13, 2008 · N7711Z · Substantial damageNTSB MIA08CA073Accident · No injuriesData collectionFinal reportCessna 182 · Fort Lauderdale, FLThe pilot's failure to maintain directional control during recovery from a bounced landing.Mar 6, 2008 · N213LP · Substantial damageNTSB NYC08CA098Accident · No injuriesData collectionFinal reportBeech 23 · Pineland, FLThe pilot's failure to maintain directional control of the airplane during the landing. Contributing was the gusting wind conditions.Feb 10, 2008 · N2382J · Substantial damageNTSB MIA08FA044Accident · 2 fatalField investigationFinal reportRobinson R44 · Ochopee, FLThe pilot's failure to maintain aircraft control while maneuvering. Contributing to the accident were a tailwind condition and the pilot's inadequate in-flight planning/decision.Jan 22, 2008 · N18HB · Substantial damage