NTSB investigations, 2011, FL
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
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\") = 2011
AND c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
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") = 2011 AND c."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA' 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 ERA11LA429Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Pahokee, FLThe flight instructor's misjudgment of the airplane's position and airspeed relative to the runway while returning to the airport after a partial loss of engine power. Contributing to the accident was the separation of the engine's No. 3 cylinder exhaust…NTSB ERA11FA414Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Palm Bay, FLThe pilot’s failure to maintain adequate airspeed while maneuvering for a forced landing, resulting in an inadvertent aerodynamic stall. Contributing to the accident were the pilot’s failure to secure the oil gauge rod and cap assembly before flight and his…NTSB ERA11CA402Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Crystal River, FLThe pilot's failure to attain the proper touchdown point, and his improper decision to perform a go-around with a tailwind and insufficient runway remaining.NTSB ERA11LA397Accident · No injuriesLimited investigationFinal reportGates Lear Jet 35 · Opa-Locka, FLThe flightcrew’s inadvertent encounter with windshear during landing, which resulted in a loss of control.NTSB ERA11LA393Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Ormond Beach, FLThe loss of engine power due to fuel starvation, which resulted from the flight instructor's inadequate in-flight fuel management.NTSB ERA11LA392Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · West Palm Beach, FLSeparation of the auxiliary fuel tank cap, which entered the tail rotor system. Contributing to the accident was the lack of a fuel tank cap restraint.NTSB ERA11CA396Accident · No injuriesData collectionFinal reportPiper PA-30 · Plant City, FLThe failure of a screw in the nose landing gear aligner assembly for undetermined reasons, which prevented the landing gear from fully extending.NTSB ERA11CA382Accident · No injuriesData collectionFinal reportBeech A36 · Wauchula, FLThe pilot's failure to extend the landing gear during the approach.NTSB ERA11LA400Accident · No injuriesLimited investigationFinal reportFessenden Alfred Expermental RV-4 · Fort Drum, FLA total loss of engine power for undetermined reasons.NTSB ERA11CA387Accident · No injuriesData collectionFinal reportCessna 150C · Weirsdale, FLThe pilot's failure to maintain adequate clearance from the stopped trailer while taxiing.NTSB ERA11LA361Accident · No injuriesLimited investigationFinal reportBeech A60 · Pompano Beach, FLThe pilots of both airplanes did not maintain adequate visual lookout during taxi, which resulted in an on-ground collision.NTSB ERA11CA363Accident · Minor injuriesData collectionFinal reportCessna 150L · Winter Haven, FLThe certified flight instructor's failure to maintain control during the attempted go-around, which resulted in an aerodynamic stall.NTSB ERA11FA354Accident · 2 fatalField investigationFinal reportBeech C24R · Valparaiso, FLThe pilots’ failure to maintain airspeed, which resulted in an inadvertent, low altitude aerodynamic stall.NTSB ERA11CA367Accident · Serious injuriesData collectionFinal reportMcdonnell Douglas MD88 · Miami, FLThe in-flight encounter with convective turbulence, resulting in an injury to a cabin attendant.NTSB ERA11CA347Accident · No injuriesData collectionFinal reportCessna 172N · Belle Glades, FLThe pilot’s failure to maintain airplane control during the landing approach.NTSB ERA11CA338Accident · No injuriesData collectionFinal reportCessna 172R · Naples, FLThe pilot’s improper flare and recovery from a bounced landing.NTSB ERA11FA332Accident · 2 fatalField investigationFinal reportCessna 152 · Vero Beach, FLThe pilot’s failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall and subsequent spin.NTSB ERA11CA329Accident · No injuriesData collectionFinal reportRemos Remos G-3/600 · Apoka, FLThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and collision with a hangar.NTSB ERA11LA325Accident · Minor injuriesLimited investigationFinal reportClamar Floats CA-4 · Merritt Island, FLThe loss of engine power during takeoff for reasons that could not be determined because a postaccident examination could not be performed before the airplane was disassembled.NTSB ERA11TA318Accident · Minor injuriesFinal reportBell OH-58A · Ft. Pierce, FLThe pilot's failure to recognize and avoid a loss of tail rotor effectiveness, which resulted in a loss of control and hard landing.NTSB ERA11TA317Accident · Minor injuriesFinal reportBell OH-58C · Panama City, FLThe drooping electrical conduit, which snagged the vertical fin and resulted in the pilot's inability to control the helicopter. Contributing to the accident was the operator's decision to have the pilot fly the helicopter out of the hangar.NTSB ERA11CA322Accident · No injuriesData collectionFinal reportCessna 140A · Quincy, FLThe private pilot's inability to maintain directional control of the airplane during the takeoff roll.NTSB ERA11FA287Accident · 1 fatalField investigationFinal reportCzech Sport Piper Sport · Spring Hill, FLThe pilot's inadvertent application of control inputs that resulted in rapid, right-rolling, negative g-forces during night cruise flight and his subsequent ejection from the airplane. Contributing to the accident was the pilot's decision to fly at night in…NTSB ERA11LA282Accident · No injuriesLimited investigationFinal reportPfouts Alfred L Senior Aero SPT D260 · Palm Coast, FLA total loss of engine power for undetermined reasons.NTSB ERA11CA286Accident · No injuriesData collectionFinal reportCessna 172R · Hollywood, FLThe student pilot's failure to maintain directional control of the airplane during a touch-and-go landing.NTSB ERA11CA284Accident · No injuriesData collectionFinal reportCessna 172P · Stuart, FLThe student pilot's improper landing flare, which resulted in a hard landing.NTSB ERA11CA283Accident · No injuriesData collectionFinal reportCessna 172P · Fort Pierce, FLThe student pilot's improper flare, which resulted in a hard landing.NTSB ERA11FA274Accident · 1 fatalField investigationFinal reportBeech E18S · Miami Gardens, FLThe pilot’s improper response to a loss of power in the No. 2 engine and his failure to ensure that the airplane was airworthy. Contributing to the accident was the inadequate engine maintenance by the operator's maintenance personnel.NTSB ERA11LA263Accident · 1 fatalLimited investigationFinal reportSolo Wings Windlass Aquilla · Starke, FLThe pilot's loss of airplane control while taxiing, which resulted in the weight-shift-controlled airplane becoming inadvertently airborne and subsequently impacting the ground. Contributing to the accident was the pilot's lack of experience in the make and…NTSB ERA11CA259Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Lake Wales, FLThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA11CA255Accident · No injuriesData collectionFinal reportBeech F33A · Ocala, FLThe pilot's improper flare which resulted in a hard landing. Contributing to the accident was the pilot's distracted attention due to the electrical system failure.NTSB ERA11CA254Accident · No injuriesData collectionFinal reportFlight Design Ctls · Jacksonville, FLThe student pilot's improper flare, which resulted in a hard landing.NTSB ERA11CA244Accident · No injuriesData collectionFinal reportCessna 172S · Saint Petersburg, FLThe failure of the student pilot to maintain directional control during a touch-and-go landing.NTSB ERA11CA241Accident · No injuriesData collectionFinal reportCessna 172 · Ft Pierce, FLThe student pilot's inadequate flare which resulted in a hard landing.NTSB ERA11LA231Accident · No injuriesLimited investigationFinal reportCessna 172RG · Okeechobee, FLThe failure of the main landing gear to lock in the extended position for undetermined reasons and both pilots’ failure to ensure that the landing gear was down and locked prior to landing.NTSB ERA11LA221Accident · No injuriesLimited investigationFinal reportCessna 310F · Sanford, FLThe failure of the nose landing gear due to inadequate servicing of the nose gear strut reservoir.NTSB ERA11LA228Accident · Minor injuriesLimited investigationFinal reportHrosik Gene Aventura II · Crescent City, FLThe pilot's failure to maintain adequate airspeed during climb after takeoff, resulting in an aerodynamic stall.NTSB OPS11IA428Incident · No injuriesIncident investigationFinal reportCirrus Design SR22 · Orlando, FLThe air traffic controllers’ application of inappropriate separation between the B737 and the Cirrus and their inappropriate use of airborne civilian aircraft for observation of other airborne aircraft. Contributing to the incident was the crew of the B737's…NTSB ERA11FA214Accident · 1 fatalField investigationFinal reportAerostar S A YAK-52 · Palm Coast, FLThe pilot’s failure to recover from the nose-low descent during an aerobatic maneuver.NTSB ERA11CA212Accident · No injuriesData collectionFinal reportMooney M20J · St. Petersburg, FLThe pilot’s failure to maintain directional control during a crosswind landing.NTSB ERA11LA200Accident · No injuriesLimited investigationFinal reportPiper PA-18A 150 · Hollywood, FLA total loss of engine power for undetermined reasons.NTSB ERA11CA195Accident · Serious injuriesData collectionFinal reportBrown Narcisse A Christen Eagle II · Gainesville, FLThe pilot's failure to maintain airspeed while turning from base leg to final approach, which resulted in an aerodynamic stall and collision with the ground.NTSB ERA11LA190Accident · No injuriesLimited investigationFinal reportCessna 182P · Alachua, FLA loss of engine power due to the failure of the camshaft gear teeth and crankshaft gear teeth for undetermined reasons.NTSB ERA11CA192Accident · No injuriesData collectionFinal reportPiper PA28 · Vero Beach, FLThe student pilot's failure to maintain directional control during the landing rollout.NTSB ERA11CA186Accident · Minor injuriesData collectionFinal reportCessna 182P · Kissimmee, FLThe pilot's failure to maintain directional control during the landing flare.NTSB ERA11CA180Accident · Serious injuriesData collectionFinal reportRobinson Helicopter R44 II · Weston, FLThe pilot's failure to maintain adequate altitude and physical alertness which resulted in an in-flight collision with the water. Contributing to the accident was the pilot's fatigue.NTSB ERA11CA166Accident · Minor injuriesData collectionFinal reportEnstrom F-28C · Fort Pierce, FLThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA11LA156Accident · No injuriesLimited investigationFinal reportCessna 172G · Clarksville, FLA loss of engine power due to fuel starvation as a result of the owner's improper maintenance of the fuel selector valve, which resulted in a lack of fuel supply from the right fuel tank.NTSB ERA11FA146Accident · 2 fatalField investigationFinal reportCessna 172S · New Smyrna Beach, FLThe flight instructor's failure to recognize or implement adequate remedial action to counter the effects of spatial disorientation. Contributing to the accident was the spatial disorientation experienced by one or both pilots.NTSB ERA11CA147Accident · No injuriesData collectionFinal reportCessna 172S · Daytona Beach, FLThe pilot's inadequate flare that resulted in a hard landing.