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.

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…Jul 28, 2011 · N1443U · Substantial damageNTSB 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…Jul 23, 2011 · N122HB · Substantial damageNTSB 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.Jul 15, 2011 · N18PE · Substantial damageNTSB 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.Jul 12, 2011 · N110UN · Substantial damageNTSB 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.Jul 10, 2011 · N9202C · Substantial damageNTSB 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.Jul 10, 2011 · N10786 · Substantial damageNTSB 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.Jul 10, 2011 · N325EE · Substantial damageNTSB ERA11CA382Accident · No injuriesData collectionFinal reportBeech A36 · Wauchula, FLThe pilot's failure to extend the landing gear during the approach.Jul 5, 2011 · N8036V · Substantial damageNTSB ERA11LA400Accident · No injuriesLimited investigationFinal reportFessenden Alfred Expermental RV-4 · Fort Drum, FLA total loss of engine power for undetermined reasons.Jul 4, 2011 · N3226N · Substantial damageNTSB ERA11CA387Accident · No injuriesData collectionFinal reportCessna 150C · Weirsdale, FLThe pilot's failure to maintain adequate clearance from the stopped trailer while taxiing.Jul 2, 2011 · N1953Z · Substantial damageNTSB 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.Jun 26, 2011 · N38N · 2 aircraft · Minor damageNTSB 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.Jun 26, 2011 · N18735 · Substantial damageNTSB ERA11FA354Accident · 2 fatalField investigationFinal reportBeech C24R · Valparaiso, FLThe pilots’ failure to maintain airspeed, which resulted in an inadvertent, low altitude aerodynamic stall.Jun 23, 2011 · N38029 · Substantial damageNTSB ERA11CA367Accident · Serious injuriesData collectionFinal reportMcdonnell Douglas MD88 · Miami, FLThe in-flight encounter with convective turbulence, resulting in an injury to a cabin attendant.Jun 22, 2011 · N884DA · No damageNTSB ERA11CA347Accident · No injuriesData collectionFinal reportCessna 172N · Belle Glades, FLThe pilot’s failure to maintain airplane control during the landing approach.Jun 15, 2011 · N4954G · Substantial damageNTSB ERA11CA338Accident · No injuriesData collectionFinal reportCessna 172R · Naples, FLThe pilot’s improper flare and recovery from a bounced landing.Jun 10, 2011 · N2458G · Substantial damageNTSB 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.Jun 9, 2011 · N48869 · Substantial damageNTSB 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.Jun 5, 2011 · N13GX · Substantial damageNTSB 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.Jun 3, 2011 · N434JC · Substantial damageNTSB 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.May 29, 2011 · N911SL · Substantial damageNTSB 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.May 27, 2011 · N82772 · Substantial damageNTSB ERA11CA322Accident · No injuriesData collectionFinal reportCessna 140A · Quincy, FLThe private pilot's inability to maintain directional control of the airplane during the takeoff roll.May 26, 2011 · N1137D · Substantial damageNTSB 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…May 7, 2011 · N420PS · Substantial damageNTSB ERA11LA282Accident · No injuriesLimited investigationFinal reportPfouts Alfred L Senior Aero SPT D260 · Palm Coast, FLA total loss of engine power for undetermined reasons.May 4, 2011 · N705AP · Substantial damageNTSB 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.May 4, 2011 · N2434T · Substantial damageNTSB ERA11CA284Accident · No injuriesData collectionFinal reportCessna 172P · Stuart, FLThe student pilot's improper landing flare, which resulted in a hard landing.May 3, 2011 · N88EP · Substantial damageNTSB ERA11CA283Accident · No injuriesData collectionFinal reportCessna 172P · Fort Pierce, FLThe student pilot's improper flare, which resulted in a hard landing.May 3, 2011 · N5460K · Substantial damageNTSB 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.May 2, 2011 · N18R · Substantial damageNTSB 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…Apr 23, 2011 · N94370 · Substantial damageNTSB ERA11CA259Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Lake Wales, FLThe pilot’s failure to maintain directional control during the landing roll.Apr 23, 2011 · N57WV · Substantial damageNTSB 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.Apr 21, 2011 · N334J · Substantial damageNTSB ERA11CA254Accident · No injuriesData collectionFinal reportFlight Design Ctls · Jacksonville, FLThe student pilot's improper flare, which resulted in a hard landing.Apr 14, 2011 · N178CT · Substantial damageNTSB ERA11CA244Accident · No injuriesData collectionFinal reportCessna 172S · Saint Petersburg, FLThe failure of the student pilot to maintain directional control during a touch-and-go landing.Apr 13, 2011 · N2468Z · Substantial damageNTSB ERA11CA241Accident · No injuriesData collectionFinal reportCessna 172 · Ft Pierce, FLThe student pilot's inadequate flare which resulted in a hard landing.Apr 12, 2011 · N702GR · Substantial damageNTSB 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.Apr 6, 2011 · N5284V · Substantial damageNTSB ERA11LA221Accident · No injuriesLimited investigationFinal reportCessna 310F · Sanford, FLThe failure of the nose landing gear due to inadequate servicing of the nose gear strut reservoir.Apr 1, 2011 · N6781X · Substantial damageNTSB 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.Mar 29, 2011 · N5842 · Substantial damageNTSB 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…Mar 27, 2011 · N1487C · 2 aircraft · No damageNTSB 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.Mar 26, 2011 · N808TD · Substantial damageNTSB ERA11CA212Accident · No injuriesData collectionFinal reportMooney M20J · St. Petersburg, FLThe pilot’s failure to maintain directional control during a crosswind landing.Mar 25, 2011 · N201ZZ · Substantial damageNTSB ERA11LA200Accident · No injuriesLimited investigationFinal reportPiper PA-18A 150 · Hollywood, FLA total loss of engine power for undetermined reasons.Mar 19, 2011 · N9692D · Substantial damageNTSB 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.Mar 19, 2011 · N109BX · Substantial damageNTSB 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.Mar 15, 2011 · N430ML · Substantial damageNTSB ERA11CA192Accident · No injuriesData collectionFinal reportPiper PA28 · Vero Beach, FLThe student pilot's failure to maintain directional control during the landing rollout.Mar 15, 2011 · N9212E · Substantial damageNTSB ERA11CA186Accident · Minor injuriesData collectionFinal reportCessna 182P · Kissimmee, FLThe pilot's failure to maintain directional control during the landing flare.Mar 11, 2011 · N8033M · Substantial damageNTSB 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.Mar 5, 2011 · N4168W · Substantial damageNTSB 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.Feb 26, 2011 · N5689B · Substantial damageNTSB 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.Feb 23, 2011 · N3740L · Substantial damageNTSB 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.Feb 16, 2011 · N6345L · Substantial damageNTSB ERA11CA147Accident · No injuriesData collectionFinal reportCessna 172S · Daytona Beach, FLThe pilot's inadequate flare that resulted in a hard landing.Feb 15, 2011 · N378FA · Substantial damage