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 NYC08CA193Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Vero Beach, FLThe student pilot's failure to maintain directional control during takeoff. Contributing to the accident was a crosswind.NTSB MIA08CA111Accident · No injuriesData collectionFinal reportCessna 172S · Kissimmee, FLThe pilot's improper landing flare.NTSB ENG08IA027Incident · No injuriesIncident investigationFinal reportBoeing MD-11F · Miami, FLThe insufficient predicted fatigue life of the P/N KBE6-59 adjustable-length 3/8-inch rod end, and the inadequate fatigue margin at the transcowl CDU clevis assembly bracket attachment rivets for the one actuator out condition, which resulted in the failure…NTSB NYC08TA183Accident · Minor injuriesFinal reportRobinson R44 II · Lake Wales, FLThe pilot's improper recovery from a practice autorotation.NTSB NYC08CA187Accident · No injuriesData collectionFinal reportCessna 172SP · Homestead, FLThe student pilot's improper flare. Contributing to the accident was the flight instructor's inadequate remedial action.NTSB NYC08CA177Accident · No injuriesData collectionFinal reportBeech 65-A90 · Titusville, FLThe pilot's improper flare which resulted in a hard landing.NTSB 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.NTSB NYC08LA164Accident · No injuriesLimited investigationFinal reportBeech G35 · New Smyrna Beach, FLThe pilot's inadvertent encounter with turbulence that was not forcast.NTSB MIA08CA092Accident · No injuriesData collectionFinal reportCessna 172S · Daytona Beach, FLThe student pilot's improper recovery from a bounced landing.NTSB LAX08CA120Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Plant City, FLThe pilot's excessive taxi speed, which led to a loss of control.NTSB ANC08CA054Accident · No injuriesData collectionFinal reportCessna 172 · Tyndall AFB, FLThe pilot's misjudged flare and subsequent hard landing, and her inadequate recovery from a bounced landing.NTSB NYC08CA161Accident · Minor injuriesData collectionFinal reportCessna 152K · Okeechobee, FLThe loss of engine power during cruise flight due to fuel contamination, and the pilot's inadequate preflight inspection.NTSB 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.NTSB NYC08CA166Accident · No injuriesData collectionFinal reportWim J Huisman Velocity 173 Fixed · Ocala, FLThe pilot's failure to maintain directional control during the landing. Contributing to the accident was the wind gusts.NTSB MIA08CA088Accident · Serious injuriesData collectionFinal reportWilliam E. Furr SeaRey · Winter Springs, FLThe pilot's inadequate preflight inspection of the airplane.NTSB CHI08LA104Accident · No injuriesLimited investigationFinal reportVic Tatelman Baby Belle · Lakeland, FLThe failure of the tailrotor driveshaft hanger bearing and jamming of the tailrotor.NTSB NYC08FA158Accident · 1 fatalField investigationFinal reportChech Aircraft Works Spol Sro CH 601 XL RTF · Polk City, FLThe in-flight failure of the left wing for undetermined reasons.NTSB 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.NTSB NYC08CA156Accident · Serious injuriesData collectionFinal reportBoeing 737-823 · Miami, FLAn unexpected encounter with turbulence, during the initial descent for landing.NTSB MIA08CA085Accident · No injuriesData collectionFinal reportThomas J. Dorsey Searey · Mount Dora, FLThe pilot's failure to verify the position of the landing gear prior to making a water landing.NTSB MIA08LA083Accident · No injuriesLimited investigationFinal reportDouglas D. Turner Vans RV8 · DeLand, FLThe loss of engine power for undetermined reasons. Contributing to the accident was the unsuitable terrain for a forced landing.NTSB NYC08FA148Accident · 1 fatalField investigationFinal reportPiper PA 28-161 · Venice, FLThe pilot's inflight loss of control for undetermined reasons.NTSB NYC08CA190Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Inverness, FLThe student pilot's improper landing flare and the flight examiner's inadequate remedial action.NTSB NYC08CA147Accident · No injuriesData collectionFinal reportRans S12XL · Wauchula, FLThe malfunction of the fuel line, which resulted in a loss of engine power due to fuel starvation.NTSB NYC08CA141Accident · No injuriesData collectionFinal reportPiper PA-25-260 · Opa Locka, FLThe entanglement of the hook rope with the rudder horn during banner pickup.NTSB MIA08FA080Accident · 2 fatalField investigationFinal reportCessna 182B · Wildwood, FLThe noninstrument rated pilot's failure to maintain terrain clearance at night in marginal visual flight conditions. Contributing to the accident was the dark night, and low cloud ceilings.NTSB MIA08LA079Accident · No injuriesLimited investigationFinal reportCessna 402B · Fort Lauderdale, FLThe improper adjustment of the right main landing gear down lock by maintenance personnel resulting in the gear collapse during the landing roll..NTSB NYC08FA133Accident · 4 fatalField investigationFinal reportCessna 172 · Indiantown, FLThe pilot's failure to maintain an adequate airspeed while maneuvering at low altitude. Contributing to the accident was the overweight condition of the airplane and the inoperative stall warning horn.NTSB 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.NTSB MIA08CA074Accident · No injuriesData collectionFinal reportCessna 525B · Stuart, FLThe flight crew's failure to reset the brakes circuit breaker resulting in a loss of brakes during taxi and an on ground collision with an unoccupied parked airplane.NTSB MIA08CA073Accident · No injuriesData collectionFinal reportCessna 182 · Fort Lauderdale, FLThe pilot's failure to maintain directional control during recovery from a bounced landing.NTSB MIA08CA077Accident · No injuriesData collectionFinal reportPiper PA24-260 · West Palm Beach, FLThe pilot's failure to follow the checklist resulting in a gear up landing.NTSB NYC08CA126Accident · No injuriesData collectionFinal reportMorrison Vans RV-8 · Port Orange, FLThe airplane's inadvertent encounter with a crosswind gust during the landing roll, which resulted in the pilot's loss of directional control.NTSB NYC08LA116Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20 · Key West, FLA loss of engine power for undetermined reasons.NTSB MIA08FA070Accident · 3 fatalField investigationFinal reportUlrich Christen Velocity XL RG · Titusville, FLThe pilot of the Velocity’s failure to see and avoid the flight of four RV-8s that had landed and were in the process of clearing the runway.NTSB MIA08CA069Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Vero Beach, FLThe student pilot's failure to maintain directional control of the airplane during an aborted takeoff.NTSB NYC08CA113Accident · Serious injuriesData collectionFinal reportCessna 177B · Quincy, FLThe pilot's inadequate in-flight decision by failing to refuel, resulting in fuel exhaustion and the loss of engine power.NTSB MIA08LA066Accident · No injuriesLimited investigationFinal reportCessna 210L · Tampa, FLThe malfunction of the right main landing gear down-and-locked switch.NTSB NYC08CA128Accident · No injuriesData collectionFinal reportPiper PA 32-300 · Apopka, FLThe pilot's failure to maintain clearance/altitude while on the final leg of the approach.NTSB MIA08CA067Accident · Minor injuriesData collectionFinal reportWaco CTO · Venice, FLThe pilot's improper use of brakes during the landing roll.NTSB NYC08LA106Accident · No injuriesLimited investigationFinal reportRaytheon A36 · Pahokee, FLThe pilot's decision to depart with a known deficiency with the engine, which resulted in a loss of engine power. Contributing to the accident was the loss of engine power due to the failure of the engine-driven fuel pump.NTSB MIA08CA061Accident · Minor injuriesData collectionFinal reportStephen F. Graves SG-3 · Fort Pierce, FLThe failure of the student to maintain directional control during a cross wind takeoff. A factor in the accident was inadequate supervision by the CFI.NTSB MIA08CA056Accident · No injuriesData collectionFinal reportCessna 172S · Orlando, FLThe student pilot's inadequate recovery from a bounced landing.NTSB NYC08CA103Accident · No injuriesData collectionFinal reportCessna 172P · Gainesville, FLThe pilot's improper flare.NTSB 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.NTSB MIA08CA054Accident · Serious injuriesData collectionFinal reportCessna 177RG · Tallahassee, FLPilot's inaccurate fuel management resulting in fuel exhaustion.NTSB NYC08CA095Accident · No injuriesData collectionFinal reportSonex Waiex · New Smyrna Bch., FLThe pilot's failure to maintain directional control during the takeoff. Contributing was the crosswind.NTSB OPS08IA006Incident · No injuriesIncident investigationFinal reportPiper PA-28-161 · St. Augustine, FLThe pilot's failure to adhere to the controller's takeoff instruction. Contributing to the incident was the controller's failure to properly monitor the flight, and the controller's decision to perform lesser duty priorities during the takeoff roll.NTSB NYC08CA092Accident · Minor injuriesData collectionFinal reportKral Series 5 Kitfox · Fruitland Park, FLThe pilot's failure to maintain adequate clearance from obstructions during the landing approach. Contributing to the accident was the reduced visibility due to sunglare and haze.NTSB NYC08LA091Accident · Minor injuriesLimited investigationFinal reportNorth American Rockwell NA-265-80 · Ft. Lauderdale, FLThe depletion of pressure in the normal hydraulic system for an undetermined reason, and the pilots' failure to properly operate the emergency braking system. Contributing to the accident was an inoperative hydraulic system aural warning.