NTSB investigations, FL
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 ENG08IA011Incident · Minor injuriesIncident investigationFinal reportBoeing B757-200 · West Palm Beach, FLthe arcing of the windshield heat system at the upper, aft (J1) and upper, forward (J4) terminal locations on the first officer's windshield, which caused the inner pane of glass to fracture.NTSB NYC08CA094Accident · Minor injuriesData collectionFinal reportPiper J3-C65 · Hollywood, FLThe pilot's failure to maintain directional control while landing. Contributing was the gusty crosswind condition.NTSB MIA08LA048Accident · Serious injuriesLimited investigationFinal reportGrumman G-21A · Marathon, FLThe pilot’s failure to maintain control of the airplane during a water landing.NTSB 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.NTSB MIA08LA043Accident · No injuriesLimited investigationFinal reportCessna U206F · Kissimmee, FLThe probable cause of this accident is undetermined.NTSB MIA08FA038Accident · 3 fatalField investigationFinal reportCessna 172L · Clearwater, FLThe pilot's failure to maintain airspeed while maneuvering for approach to land. Contributing to the accident was the pilot's operation of the airplane above the design gross weight.NTSB NYC08CA080Accident · No injuriesData collectionFinal reportCessna C-152 · Labelle, FLThe pilot's improper decision to takeoff from an inadequate field after a forced landing.NTSB NYC08CA079Accident · No injuriesData collectionFinal reportCessna 150G · Sarasota, FLThe pilot's improper preflight and in-flight planning which resulted in a loss of engine power due to fuel exhaustion.NTSB NYC08LA078Accident · Serious injuriesLimited investigationFinal reportRobinson R22 Beta · North Palm Bch, FLA loss of engine power due to carburetor icing. Contributing to the accident was unsuitable terrain for a forced landing.NTSB NYC08LA077Accident · No injuriesLimited investigationFinal reportBell 407 · DeLand, FLA total loss of engine power due to the fatigue failure of a third stage turbine wheel blade.NTSB MIA08LA036Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Miami, FLA loss of engine power due to inadequate maintenance inspection resulting in a worn throttle housing going undetected and failing.NTSB NYC08CA084Accident · No injuriesData collectionFinal reportPiper PA-32R-300 · Brooksville, FLA deer darting into the path of the airplane during the landing roll.NTSB MIA08LA032Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Sarasota, FLA loss of engine power due to contamination in the fuel filter.NTSB NYC08IA069Incident · No injuriesIncident investigationFinal reportPiper PA-32R · Destin, FLAn in-flight fire due to a fractured fuel injector line as a result of an unauthorized repair to the line.NTSB MIA08CA040Accident · No injuriesData collectionFinal reportAgusta A109 · ST. Augustine, FLThe pilot's failure to maintain a visual lookout while taxiing.NTSB MIA08CA031Accident · No injuriesData collectionFinal reportCessna 310P · Dunnellon, FLThe improper installation of the right main landing gear scissors by company maintenance personnel, resulting in the collapse of the right main landing gear during takeoff.NTSB NYC08CA063Accident · No injuriesData collectionFinal reportMaule M-7-235 · Key Largo, FLThe pilot's loss of control during the landing. Contributing was the wind gust.NTSB MIA08LA029Accident · Minor injuriesLimited investigationFinal reportPiper PA32-260 · Marathon, FLA loss of engine power for undetermined reasons.NTSB NYC08LA060Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Plant City, FLA loss of rotor drive due to excessive slack and breakage of the drive belts. Contributing to the accident was the pilot departing in the helicopter after the rotor engagement time during engine start exceeded the time outlined in the pilot's operating…NTSB NYC08FA054Accident · 2 fatalField investigationFinal reportPiper PA-30 · Parkland, FLBoth pilots' failure to see and avoid the other airplane. Contributing to the accident were the erroneous readouts from the Cessna's altitude encoder.NTSB NYC08CA055Accident · Minor injuriesData collectionFinal reportPiper PA-22-150 · Tallahassee, FLThe pilot's misjudged clearance over obstacles during final approach.NTSB MIA08CA025Accident · No injuriesData collectionFinal reportMessing Roy Sonex · New Smyrna Beac, FLThe pilot's failure to maintain altitude/clearance while on final approach for landing.NTSB NYC08LA052Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Gainesville, FLThe pilot's failure to follow the published emergency procedure. Contributing to the accident was a malfunction of the clutch assembly.NTSB MIA08LA023Accident · Serious injuriesLimited investigationFinal reportPorter Glen Aventura II · Rockledge, FLThe failure of the pilot to maintain airspeed during climbout, resulting in an aerodynamic stall and uncontrolled descent. Contributing to the severity of the pilot's injuries was the inadequate manufacture of the shoulder harness restraint cables.NTSB ANC08LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLThe loss of engine power during takeoff initial climb for an undetermined reason.NTSB MIA08FA021Accident · 1 fatalField investigationFinal reportMooney M20J · Fort Myers, FLThe reason for this occurrence was not determined.NTSB MIA08CA022Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Orlando, FLThe student pilot's failure to maintain directional control during landing.NTSB NYC08LA044Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Miami, FLA total loss of engine power during initial climb for undetermined reasons.NTSB NYC08CA047Accident · No injuriesData collectionFinal reportCessna 152 · Venice, FLThe student pilot's improper recovery from a bounced landing.NTSB MIA08CA019Accident · Minor injuriesData collectionFinal reportLake LA-4-200 · Jacksonville, FLThe pilot's failure to maintain altitude while maneuvering over water. Contributing to the accident was glassy water conditions.NTSB NYC08CA036Accident · Minor injuriesData collectionFinal reportCessna 120 · Ocala, FLThe pilot's failure to maintain proper runway alignment during landing.NTSB NYC08CA035Accident · Minor injuriesData collectionFinal reportCessna 180 · Orlando, FLThe pilot's loss of control on the water after landing, which resulted in the bow of the right float submerging , and a nose-over event.NTSB NYC08LA029Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Hollywood, FLThe pilot's failure to maintain adequate airspeed, resulting in an aerodynamic stall. Contributing to the accident were an inoperative stall warning system and an erroneous airspeed indicator.NTSB NYC08CA030Accident · Minor injuriesData collectionFinal reportSea & Air Sales Searey · Sanford, FLThe pilot's failure to raise the landing gear prior to a water landing. Contributing was the pilot's diverted attention.NTSB MIA08LA014Accident · No injuriesLimited investigationFinal reportCessna C208B · Opa Locka, FLFailure of the local controller to coordinate with the ground controller and the failure of the pilots to see and avoid each other.NTSB DFW08CA024Accident · Minor injuriesData collectionFinal reportPipistrel Sinus 912 · Holt, FLThe pilot's failure to maintain clearance from terrain. A contributing factor was the gusting crosswind.NTSB MIA08FA010Accident · 1 fatalField investigationFinal reportMooney M20K · Panama City, FLThe pilot's inadequate preflight inspection which resulted in a loss of engine power during cruise flight due to fuel contamination. A factor was the pilot's impairment due to recent cocaine use.NTSB NYC08FA020Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Boynton Beach, FLA total loss of engine power due to fuel starvation as a result of the pilots' improper in-flight fuel management.NTSB NYC08LA021Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Pensacola, FLThe fatigue fracture of the tail wheel spring during takeoff.NTSB NYC08LA019Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Stuart, FLA partial loss of engine power during cruise flight due to a partially blocked fuel line.NTSB MIA08LA007Accident · No injuriesLimited investigationFinal reportCatchot Angus Kitfox IV · Crescent City, FLThe loss of engine power for undetermine reasons.NTSB MIA08LA006Accident · Minor injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Fort Myers, FLA partial loss of engine power during approach for undetermined reasons.NTSB NYC07LA241Accident · Serious injuriesLimited investigationFinal reportEverson Sidewinder · Pensacola, FLThe pilot's failure to attain the proper touchdown point while landing.NTSB MIA07LA158Accident · No injuriesLimited investigationFinal reportFly BY Sea Comp AIR 1 · Rockledge, FLLoss of engine power for undetermined reasons.NTSB MIA07LA157Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Wimauma, FLThe failure of the pilot to maintain airspeed while maneuvering for a precautionary landing following a reported loss of engine power for undetermined reasons.NTSB NYC07LA233Accident · 1 fatalLimited investigationFinal reportTemco GC-1B · New Smyrna Bch, FLA loss of engine power due to fuel starvation, which was the result of a blocked fuel tank vent.NTSB NYC07FA234Accident · Serious injuriesField investigationFinal reportBeech H-18 · Ft. Lauderdale, FLA total loss of engine power due to fuel starvation as a result of the pilot's failure to place the fuel selector for the right engine in the proper position. Contributing to the accident was the improper loading of the cargo.NTSB NYC07CA238Accident · No injuriesData collectionFinal reportCessna 190 · Yulee, FLThe pilot's failure to maintain directional control while landing. A factor in this accident was the crosswind condition.NTSB MIA07LA152Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Milton, FLThe failure of the pilot to attain the proper touchdown point during the precautionary landing resulting in the on-ground collision with fence posts.NTSB NYC07CA224Accident · Minor injuriesData collectionFinal reportPiper PA-28R-200 · Tampa, FLThe pilot's misjudged altitude/distance, which resulted in a hard landing, prior to the runway.