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 MIA07CA090Accident · No injuriesData collectionFinal reportCessna 172R · Lantana, FLThe student pilot's failure to maintain directional control of the airplane during landing roll.NTSB MIA07LA089Accident · Serious injuriesLimited investigationFinal reportHiller UH-12C · Plant City, FLThe loss of engine power due to a magneto impulse coupling failure for undetermined reasons.NTSB MIA07CA079Accident · No injuriesData collectionFinal reportRobinson R-22 Beta II · West Palm Beach, FLThe student pilot's inadvertent shutting off of the mixture control while performing the prelanding checks that resulted loss of engine power and a roll over during the subsequent forced landing.NTSB ANC07LA031Accident · No injuriesLimited investigationFinal reportCessna 172A · Sarasota, FLThe pilot's inadequate compensation for wind conditions, which resulted in a loss of control during landing, and collision with objects. Factors associated with the accident were wind gusts and a crosswind.NTSB MIA07LA085Accident · Minor injuriesLimited investigationFinal reportSmith Carter A Wheeler Exp 2000 · Stuart, FLContamination of the fuel system which resulted in a loss of engine power. Contributing to the accident was unsuitable terrain for a forced landing.NTSB MIA07FA083Accident · 3 fatalField investigationFinal reportCessna 182Q · Cudjoe Key, FLThe pilot's failure to maintain clearance from an active restricted area, which resulted in the airplane colliding with the tether of an aerostat.NTSB NYC07CA099Accident · Minor injuriesData collectionFinal reportMonocoupe 90A · Lakeland, FLThe pilot's improper flare and failure to maintain airspeed, which resulted in a stall and subsequent loss of control. A factor was the sun glare.NTSB MIA07LA081Accident · 2 fatalLimited investigationFinal reportCessna U206G · Welaka, FLThe pilot's continued visual flight into instrument meteorological conditions and his failure to maintain clearance from utility poles. Contributing to the accident were the fog and haze.NTSB MIA07CA078Accident · Serious injuriesData collectionFinal reportRobert J. Goodyear Hummel Bird · Lakeland, FLThe pilot's failure to maintain airspeed during a go-around.NTSB MIA07LA077Accident · 2 fatalLimited investigationFinal reportTerrence A. Sack Terrair Express · Lakeland, FLThe failure of the pilot to maintain airspeed while turning base to final which led to a stall. A contributing factor in the accident was the pilot's lack of recent experience.NTSB MIA07LA076Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Fort Lauderdale, FLThe inadequate design of the engine mount by the manufacturer, resulting in collapse of the nose landing gear.NTSB CHI07CA103Accident · No injuriesData collectionFinal reportCessna 172S · Naples, FLThe pilot's failure to maintain directional control of the airplane during landing. A contributing factor to the accident was the runway marker sign.NTSB MIA07LA075Accident · No injuriesLimited investigationFinal reportCharles C. Gillis Pitts S2S · Zellwood, FLThe pilot's excessive braking during the landing roll.NTSB MIA07LA074Accident · Serious injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Sarasota, FLThe total loss of engine power for undetermined reasons during initial climb after takeoff, resulting in a forced landing, and an in-flight collision with transmission wires and terrain.NTSB MIA07LA072Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1A · Lakeland, FLThe pilot's inadequate preflight. Contributing to the pilot's injuries was his failure to wear the installed shoulder harness.NTSB MIA07LA071Accident · No injuriesLimited investigationFinal reportCessna 152 · Canal Point, FLThe pilot-in-command's incorrect leaning of the fuel/air ratio resulting in the total loss of engine power during cruise flight.NTSB SEA07LA098Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Ocala, FLThe failure of the left main axle during the landing roll, which resulted in the collapse of the left main landing gear. A crosswind on the landing runway was a factor.NTSB LAX07CA124Accident · No injuriesData collectionFinal reportWaco Classic YMF-F5C · Stuart, FLThe pilot's failure to maintain directional control during takeoff.NTSB MIA07CA070Accident · Minor injuriesData collectionFinal reportCessna 206G · Fort Lauderdale, FLThe pilot's improper fuel management during the landing approach, resulting in a loss of engine power due to fuel starvation, and a forced off-airport landing.NTSB ANC07LA027Accident · Serious injuriesLimited investigationFinal reportCarris Avid Aircraft · Delray, FLThe loss of engine power during cruise flight for an undetermined reason, and the pilot's failure to maintain adequate airspeed during an emergency descent, which resulted in an inadvertent stall and in-flight collision with terrain. A factor associated with…NTSB MIA07IA080Incident · No injuriesIncident investigationFinal reportBeech E-55 · Key West, FLFailure of the nose landing gear drag brace due to overload during landing rollout for undetermined reasons. Contributing to the accident was the airplane had not been modified with an improved nose landing gear drag brace.NTSB MIA07CA069Accident · No injuriesData collectionFinal reportAeroprakt A-22 · Keenansville, FLThe pilot's failure to maintain directional control during the landing roll on a wet grass runway. A factor associated with the accident was the wet runway.NTSB ANC07LA026Accident · No injuriesLimited investigationFinal reportCessna 175 · Bunnell, FLThe loss of engine power during cruise due to the separation of an engine piston, which resulted in a forced landing in a swamp and a collision with trees.NTSB MIA07LA068Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-83 (MD-83) · Sanford, FLThe flight crew's failure to complete the checklist and adhere to airplane placards. Contributing to the accident was a separation of a B-nut on the rudder power hydraulic shut off valve for undetermined reasons.NTSB DEN07FA079Accident · 2 fatalField investigationFinal reportRobinson R44 II · Ponte Vedra Bch, FLthe mechanic's improper installation of the attachment hardware for the servo to swashplate push-pull tube joint which resulted in a disconnection, subsequent loss of control, and impact with terrain. Contributing factors were the company management's…NTSB MIA07IA067Incident · No injuriesIncident investigationFinal reportCessna 172S · Moore Haven, FLA loss of engine power due to foreign object damage to the oil pump.NTSB MIA07CA065Accident · No injuriesData collectionFinal reportCessna 172R · Orlando, FLThe student pilot's inadequate compensation for the wind conditions while landing. Factors associated with the accident are a crosswind and wind gusts.NTSB MIA07CA064Accident · No injuriesData collectionFinal reportCessna 150 · Okeechobee, FLThe pilot's failure to refuel the airplane prior to fuel exhaustion, which resulted in a loss of engine power during final approach, and a collision with a ditch.NTSB DEN07LA077Accident · No injuriesLimited investigationFinal reportPiaggio Industrie P180 · Fort Lauderdale, FLThe first officer's loss of directional control during landing causing the left main gear to collapse. Contributing factors in this accident were the flight crew's excessive use of brakes causing the left main tire to blow out, and the captain's inadequate…NTSB MIA07CA061Accident · Minor injuriesData collectionFinal reportBruce E. Hotz Wind Wagon · Leesburg, FLThe failure of the pilot to abort the takeoff after recognizing that the engine rpm was 760 less than desired after becoming airborne, and the inability of the airplane to maintain a positive rate of climb resulting in a controlled descent, and in-flight…NTSB NYC07CA082Accident · No injuriesData collectionFinal reportCessna 172P · Sanford, FLThe student pilot's failure to maintain directional control during the landing roll. Factors included a 90-degree crosswind, and the student pilot's improper in-flight decision to land on a runway with the crosswind rather than on an available runway with a…NTSB MIA07FA060Accident · 1 fatalField investigationFinal reportAero Vodochody Aero. Works L-39C · Titusville, FLThe pilot’s failure to ensure sufficient altitude while maneuvering in close proximity to the ground during an airshow, which resulted in an impact with terrain.NTSB MIA07LA059Accident · No injuriesLimited investigationFinal reportRobinson R-44-II · Miami, FLThe pilot's failure to maintain sufficient rotor rpm during an autorotative landing, which resulted in a hard landing and separation of the tailboom.NTSB MIA07LA066Accident · No injuriesLimited investigationFinal reportEADS PZL Warsza PZL-104M Wilga · Tampa, FLThe pilot's failure to maintain directional control during the landing roll which resulted in a ground loop and damage to the airplane.NTSB MIA07FA056Accident · 1 fatalField investigationFinal reportBeech 95-C55 · Port Orange, FLThe pilot's failure to maintain airspeed during initial climb resulting in inadvertent stall. Contributing to the accident was the pilot's improper positioning of the left fuel selector which resulted in fuel starvation to the left engine.NTSB MIA07LA055Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Miami, FLThe pilot-in-command's (CFI) continued operation of the airplane with known deficiencies (rough running engine). A factor in the accident was no suitable terrain for a forced landing.NTSB MIA07LA058Accident · 2 fatalLimited investigationFinal reportUnknown Kolb Mark III · Panama City, FLThe failure of the pilot to maintain airspeed resulting in an inadvertent stall, uncontrolled descent, and in-flight collision with terrain. A factor in the accident was the loss of engine power for undetermined reasons.NTSB CHI07CA077Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Melbourne, FLThe flight instructor's inadequate remedial action following a loss of control in flight. A factor to the accident is that the dual student did not maintain directional control of the helicopter while manuevering, which subsequently caused the instructor to…NTSB MIA07LA053Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Venice, FLThe failure of the student pilot to maintain airspeed during a go-around.NTSB MIA07LA054Accident · Serious injuriesLimited investigationFinal reportMark Gibson BB Trike · Sarasota, FLThe total loss of engine power for undetermined reasons. A factor in the accident was the unsuitable terrain encountered by the pilot during the forced landing.NTSB MIA07CA057Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Fort Pierce, FLThe failure of the pilot to maintain directional control of the airplane during the landing roll resulting in overload failure and subsequent collapse of the right main landing gear.NTSB MIA07IA052Incident · No injuriesIncident investigationFinal reportLiberty Aerospace XL-2 · Ormond Beach, FLThe improper manufacturing of the nose undercarriage leg by the vendor, and the inadequate surveillance of the vendor by the airplane manufacturer.NTSB MIA07CA051Accident · Minor injuriesData collectionFinal reportVan's RV7A · Green Cove, FLThe pilot's failure to maintain sufficient airspeed to avoid a stall during the final approach to land, resulting in an in-flight loss of control, a hard landing, and a nose over. Factors associated with the accident are an inadvertent stall, and the pilot's…NTSB MIA07LA050Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Fountain, FLA loss of engine power due to a cracked engine exhaust muffler. Contributing to the accident were the inadequate inspection procedures of the muffler system and the routing of the "P" leads wiring for the magnetos.NTSB LAX07CA092Accident · No injuriesData collectionFinal reportCessna 172S · Lake Wells, FLthe flight instructor's inadequate compensation for the gusty crosswind conditions.NTSB MIA07LA049Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas 369FF · Placida, FLThe in-flight separation of the tail rotor pitch change control rod and bellcrank during takeoff-initial climb.NTSB SEA07LA062Accident · No injuriesLimited investigationFinal reportCessna 172RG · Daytona Beach, FLThe fracture and failure of the right landing gear actuator, which resulted in a gear collapse during the landing roll.NTSB MIA07CA048Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Deland, FLThe pilot's failure to maintain directional control during the landing flare, resulting in an in-flight collision with soft terrain, and a collapse of the right main landing gear.NTSB MIA07IA047Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-8-71F · Miami, FLImproper torque of a landing gear lockbolt by company maintenance personnel during landing gear installation.NTSB MIA07CA046Accident · Minor injuriesData collectionFinal reportC.W Crane T2 · Bunnell, FLThe pilot's inadvertent encounter with adverse weather that resulted in a descent and an impact with terrain.