NTSB investigations, FL
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 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 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 ERA12LA405Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLThe pilots’ operation of the airplane with an insufficient supply of engine oil, resulting in engine seizure and total loss of engine power.NTSB 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.NTSB 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…NTSB ERA12LA379Accident · Minor injuriesLimited investigationFinal reportBell 427 · Indiantown, FLThe inflight collision with birds, resulting in damage to the rotor head assembly and a subsequent forced landing and rollover.NTSB ERA12CA375Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Titusville, FLThe flight instructor’s inadequate supervision and delayed remedial action during a simulated engine-out procedure, which resulted in a hard landing.NTSB ERA12LA366Accident · No injuriesLimited investigationFinal reportBell 206B · Longboat Key, FLUnknown personnel's failure to comply with the engine manufacturer's engine fuel pump replacement guidance, which resulted in a total loss of engine power due to the engine fuel pump failure.NTSB ERA12CA370Accident · No injuriesData collectionFinal reportSmith Allen Storch · Titusville, FLThe pilot’s failure to maintain directional control during landing.NTSB ERA12CA361Accident · No injuriesData collectionFinal reportLydon Patrick F Searey · Sanford, FLThe pilot's failure to ensure that the landing gear was retracted for the water landing.NTSB ERA12LA356Accident · No injuriesLimited investigationFinal reportCanadair CL-600-2B16 · Hallandale, FLThe failure of the co-pilot to properly close and latch the passenger door before departure, and the flight crew's failure to ensure that the door was secure by using the door warning system. Contributing to the accident was the flight crew's inadequate use…NTSB ERA12LA355Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Melbourne, FLThe failure of the pilot of another airplane to set the parking brake and to maintain a proper visual lookout, which resulted in an on-ground collision.NTSB ERA12FA345Accident · 1 fatalField investigationFinal reportShepard Jimmy D JR Pitts S1D · Port Richey, FLThe pilot's decision to conduct aerobatic flight at a low altitude, which resulted in a collision with the water.NTSB ERA12LA346Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 · Destin, FLThe partial loss of engine power due to a stuck (open) exhaust valve in the No. 5 cylinder. Contributing to the accident was the operator’s failure to follow the engine manufacturer’s directives concerning cooling of the engine after flight.NTSB ERA12CA348Accident · Minor injuriesData collectionFinal reportMooney M20C · Pembroke Pines, FLThe pilot's improper fuel management, which resulted in a total loss of engine power during approach due to fuel exhaustion.NTSB ERA12CA334Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Weirsdale, FLThe pilot's failure to maintain directional control while landing in a gusty variable crosswind.NTSB ERA12CA330Accident · No injuriesData collectionFinal reportCessna 172R · Immokalee, FLThe student pilot’s failure to maintain directional control during a touch-and-go landing.NTSB DCA12FA069Accident · Serious injuriesField investigationFinal reportAirbus A319-112 · Fort Lauderdale, FLan inadvertent encounter with convectively induced turbulence developing upwards into the flight path, which was not detected on weather radar as configured by the crew. Contributing to the delay in emergency medical personnel notification was the incomplete…NTSB 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…NTSB ERA12LA340Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Williston, FLLoss of engine power for reasons that could not be determined during postaccident examination and testing, which included a successful postaccident engine run.NTSB ERA12CA351Accident · No injuriesData collectionFinal reportCubCrafters CC11-160 · Umatilla, FLThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion.NTSB ERA12LA312Accident · Minor injuriesLimited investigationFinal reportShoup Ronald R RV-6A · Milton, FLA loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB ERA12LA314Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lake Wales, FLThe student pilot’s decision to depart from an intersection with insufficient runway remaining for takeoff, which resulted in a rejected takeoff and subsequent runway excursion.NTSB ERA12LA307Accident · No injuriesLimited investigationFinal reportRice Leo B Kitfox Series 5 · Port Canaveral, FLImpingement of the elevator control by foreign objects (clamp, glove) left in the flight control path by the pilot/owner or maintenance personnel.NTSB ERA12LA306Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Fowler's Bluff, FLThe pilot's inadequate in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA12CA328Accident · Serious injuriesData collectionFinal reportUltramagic N425 · Clermont, FLThe balloon passenger's failure to maintain her grip during landing, which resulted in a fall and injury to another passenger.NTSB 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.NTSB ERA12CA278Accident · Minor injuriesData collectionFinal reportPiper PA-18A · West Palm Beach, FLThe inadequate assembly of the brakes, which caused them to lock during the landing roll when the airplane transitioned from asphalt to turf, resulting in the airplane nosing over.NTSB ERA12LA274Accident · No injuriesLimited investigationFinal reportCessna 172S · Daytona Beach, FLA total loss of engine power due to a catastrophic engine failure, the origin of which could not be determined during postaccident examination.NTSB 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.NTSB ERA12LA296Accident · No injuriesLimited investigationFinal reportJones SA105 · New Smyrna Beach, FLThe failure of the nose landing gear wooden attachment/support structure, which resulted in collapse of the nose landing gear during taxi. Contributing to the accident was the improper design of the nose landing gear attachment structure.NTSB 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.NTSB 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.NTSB ERA12LA261Accident · No injuriesLimited investigationFinal reportCessna 210-5 · Lake Wales, FLThe pilot's inadequate preflight preparation and fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB 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.NTSB ERA12LA259Accident · No injuriesLimited investigationFinal reportCessna 172P · Brooksville, FLThe pilot's improper landing flare, which resulted in a hard landing.NTSB ERA12LA252Accident · No injuriesLimited investigationFinal reportNew Kolb Mark III Classic · Deland, FLThe pilot's lack of preflight planning for potential carburetor icing conditions, and the subsequent flight in those conditions in an airplane not equipped with carburetor heat.NTSB ERA12TA251Accident · Minor injuriesFinal reportBell 407 · Delray Beach, FLThe pilot’s improper response to a simulated engine failure and the instructor’s delayed and improper remedial action.NTSB ERA12LA250Accident · Serious injuriesLimited investigationFinal reportPiper PA46 · Wellington, FLThe pilot's failure to maintain directional control of the airplane during the takeoff roll, which resulted in a collision with a tree.NTSB ERA12CA245Accident · No injuriesData collectionFinal reportAeronca 7AC · Clearwater, FLThe pilot's failure to maintain airplane control during takeoff and the flight instructor's inadequate supervision, which resulted in a runway excursion.NTSB ERA12CA244Accident · No injuriesData collectionFinal reportMooney M20M · Clearwater, FLThe pilot’s failure to extend the landing gear before landing due to his distraction regarding another airplane in the traffic pattern.NTSB ERA12CA242Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · New Smyrna, FLThe pilot's improper flare, which resulted in a hard landing. Contributing to the accident was the flight instructor's inadequate remedial action.NTSB ERA12LA234Accident · No injuriesLimited investigationFinal reportCessna 172K · Pensacola, FLA total loss of engine power due to the improper installation of the crankshaft gear bolt or lockplate by maintenance personnel. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB ERA12LA229Accident · No injuriesLimited investigationFinal reportFlight Design Ctsw · Venice, FLA total loss of engine power due to a loss of fuel pressure. The cause for the loss of fuel pressure could not be determined during postaccident testing.NTSB ERA12LA227Accident · 2 fatalLimited investigationFinal reportEmeraude CP-301-A · Niceville, FLThe pilots’ inadequate use of carburetor heat, which resulted in carburetor icing and a subsequent loss of engine power.NTSB ERA12CA236Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 42 · New Smyrna, FLAn inadvertent encounter with a bird during cruise flight.NTSB ERA12LA219Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Homestead, FLThe inadequate servicing and maintenance of the engine and the airplane owner and maintenance personnel's disregard of the manufacturer's recommended engine overhaul schedule and service bulletins, which resulted in an in-flight internal failure and seizure…NTSB ERA12LA210Accident · Minor injuriesLimited investigationFinal reportBell 206B · Titusville, FLThe flight instructor's attempted takeoff in gusting wind conditions while the student pilot was adjusting her anti-torque pedals, which resulted in a dynamic rollover event.NTSB ERA12CA198Accident · No injuriesData collectionFinal reportLester Robert E KR-2 · Boca Raton, FLThe failure of the airplane’s engine air inlet system resulting in a total loss of engine power.NTSB ERA12FA196Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Melbourne, FLThe pilot's abrupt maneuver in response to a perceived traffic conflict, which resulted in an accelerated stall and a loss of airplane control at low altitude. Contributing to the accident was the air traffic controller's incomplete instructions, which…NTSB 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.NTSB ERA12IA187Incident · No injuriesIncident investigationFinal reportCessna 402B · Fort Lauderdale, FLThe overload fracture of the right main landing gear bellcrank and a securing bolt, which resulted in the collapse of the right main landing gear.