NTSB investigations, 2001, 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\") = 2001
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.
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") = 2001 AND 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 ATL01LA084Accident · No injuriesLimited investigationFinal reportFleet BI-PLANE · Homestead, FLThe pilot's improper use of flight controls during a landing on a sod airstrip that resulted in a nose over.NTSB ATL01LA074Accident · No injuriesLimited investigationFinal reportCessna 208B · Ft. Lauderdale, FLThe undetermined malfunction of the propeller system.NTSB ATL01LA072Accident · No injuriesLimited investigationFinal reportRyan Navion B · Palm Beach, FLLoss of engine power for undetermined reasons.NTSB ATL01LA073Accident · No injuriesLimited investigationFinal reportChristen Industries Eagle II · Belleview, FLThe pilot of the Christian Ealge II, N321JK, failure to maintain visual look out, prior to takeoff.NTSB ATL01LA071Accident · Serious injuriesLimited investigationFinal reportLake LA-4 · Mulberry, FLThe loss of engine power for undetermined reasons. A factor was rough and uneven terrain.NTSB MIA01LA178Accident · Serious injuriesLimited investigationFinal reportCessna 188B · Leesburg, FLThe pilot's failure to maintain a visual lookout while deploying the grappling hook in preparation for a banner pick up resulting in the cable wrapping around the stabilizer, subsequent loss of control during the banner drop (due to the cable moving forward…NTSB MIA01LA176Accident · No injuriesLimited investigationFinal reportCessna 152 · Tampa, FLThe pilot's failure to maintain a visual look out while taxing an airplane for parking resulting in an on ground collision with a fixed object (Hangar/Building.)NTSB MIA01LA174Accident · No injuriesLimited investigationFinal reportSocata TB-20 · Naples, FLThe collapse of the left main landing gear for undetermined reasons resulting in the loss of directional control and subsequent on-ground collision with a ravine.NTSB MIA01LA170Accident · 2 fatalLimited investigationFinal reportUnknown DragonFly B · LaBelle, FLThe inadvertent stall/spin by the pilot resulting in an uncontrolled descent and impact with the ground.NTSB MIA01FA169Accident · Minor injuriesField investigationFinal reportBell 206-L4 · Daytona Beach, FLThe failure of the pilot to maintain directional control following a hard landing resulting from a failure to maintain rotor rpm.NTSB MIA01LA167Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · Oak Hill, FLA partial loss of engine power while at a low altitude cruise due to fuel contamination, and the subsequent emergency descent and landing to a rural road resulting in collision with tree and mailbox post.NTSB MIA01LA236Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Venice, FLan on ground fire that started in the engine due to an excessive fuel flow causing the engine to flood. A factor in this accident was the pilot-in-command did not follow all the emergency procedures for an engine fire during start.NTSB MIA01LA168Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Key West, FLThe improper installation of the cylinders by other maintenance personnel for failure to assure that the cylinders were properly torqued resulting in fatigue crack in the crankshaft, and crankshaft failure. A finding in the investigation was fretting of both…NTSB MIA01FA162Accident · 1 fatalField investigationFinal reportBeech C90 · Fort Lauderdale, FLthe pilot's failure to properly plan fuel consumption and to perform an en route refueling, resulting in a total loss of engine power due to fuel exhaustion while on downwind leg for landing at eventual destination, causing an emergency descent and collision…NTSB MIA01LA158Accident · No injuriesLimited investigationFinal reportCessna 172M · Miami, FLThe pilot's failure to maintain airspeed during a go-around resulting in the airplane stalling, descending uncontrolled, impacting the runway, and sliding off the runway and nosing over.NTSB MIA01LA150Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Fort Pierce, FLThe loss of engine power during takeoff/initial climb due to compressor turbine blade separation.NTSB MIA01IA144Incident · No injuriesIncident investigationFinal reportGrumman G-73 · Fort Lauderdale, FLThe improper review of component records by company maintenance personnel of returned landing gear components from a laboratory for magnaflux and x-ray. This resulted in unserviceable components being tagged as serviceable, installation of unserviceable parts…NTSB ATL01LA058Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Brooksville, FLThe fatigue failure of the left main landing gear strut that resulted in collapse of the landing gear.NTSB ATL01LA053Accident · Minor injuriesLimited investigationFinal reportCessna P337H · Fort Lauderdale, FLThe pilot's failure to pre-flight adequate fuel for the flight.NTSB ATL01LA054Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Zephyrhills, FLThe pilots failure to adequately preflight plan fuel for the flight that resulted in fuel exhaustion and the subsequent loss of engine power.NTSB MIA01LA139Accident · No injuriesLimited investigationFinal reportCessna 172F · Fort Pierce, FLa loss of engine power due to fuel exhaustion which resulted in a forced landing, and subsequent impact with a sign and a ditch.NTSB ATL01LA050Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Lake Wales, FLThe pilot's improper use of flight controls during a bounced landing, and subsequent collision with the ground. A factor of the collision is the rough and uneven terrain.NTSB MIA01LA137Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Venice, FLThe failure of the pilot to attain the proper touchdown point resulting in a long landing and subsequent collapse of the right main landing gear. Also, failure of the pilot to perform a go-around following a long landing.NTSB MIA01LA130Accident · No injuriesLimited investigationFinal reportCessna 210N · Gainesville, FLThe pilot's delay in securing all non-essential electrical equipment in-flight resulting in battery depletion before complete gear extension was accomplished using the normal system and subsequent collapse of the main landing gear. A contributing factor in…NTSB MIA01FA126Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Fort Lauderdale, FLThe pilot's exceeding the forward center of gravity (CG) ) limits at the time of engine start, the inability of the pilot to control the airplane due to the exceeded CG limits, the failure of the pilot to abort the takeoff with sufficient runway remaining,…NTSB MIA01LA124Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Destin, FLfailure of the flight instructor to maintain directional control of the aircraft during the landing rollout while landing with a crosswind in gusty conditions, which resulted in a ground swerve, and the aircraft exiting the runway and incurring substantial…NTSB ATL01LA049Accident · Serious injuriesLimited investigationFinal reportBoeing 737-200 · Jacksonville, FLThe flight dispatcher failure to provide the flight crew with current in-flight turbulence information that resulted in the in-flight encounter with turbulence during climb. A factor was the pilots failure to obtain adequate weather information.NTSB MIA01LA122Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Dade City, FLthe pilot's inadequate recovery from a bounced landing, and loss of directional control which resulted in an in-flight collision with a fence during the go-around, resulting in a subsequent forced landing in a pasture.NTSB MIA01TA121Accident · Minor injuriesFinal reportBell OH-58C · Panama City, FLThe poor in-flight planning by the pilot for failure to maintain adequate airspeed while maneuvering to begin spray operations resulting in the loss of tail rotor effectiveness, subsequent in flight loss of control, and in flight collision with terrain.NTSB MIA01LA120Accident · 1 fatalLimited investigationFinal reportHenry Pelican · Lakeland, FLThe pilot's delay in aborting the takeoff in a downwind condition resulting in an overrun and subsequent collision with a ditch. Contributing to the accident was the pilot's failure to conduct performance planning for the flight.NTSB MIA01LA118Accident · No injuriesLimited investigationFinal reportCessna 172R · Ormond Beach, FLthe flight instructor's inadequate supervision and the dual student's improper use of brakes which resulted in the loss of directional control and collision with a wind sock. Contributing to the accident was the flight instructor's failure to follow…NTSB MIA01FA117Accident · 2 fatalField investigationFinal reportPiper PA-46-500TP · Vero Beach, FLThe pilot's excessive bank angle and his failure to maintain airspeed while returning to the airport after takeoff due to an unspecified problem resulting in the airplane stalling and colliding with trees during the resultant uncontrolled descent.NTSB MIA01LA114Accident · Serious injuriesLimited investigationFinal reportArnet Pereyra Aventura II · Rockledge, FLthe pilot's failure to maintain airspeed during takeoff/initial climb, which resulted in an inadvertent stall, an uncontrolled descent, and collision with the ground. Contributing to the accident was the pilot's distraction with the landing gear system.NTSB MIA01LA112Accident · No injuriesLimited investigationFinal reportCessna 182Q · Lakeland, FLThe pilot's failure to flare on landing resulting in a hard landing.NTSB MIA01LA109Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Osteen, FLThe pilot in command, flight instructor's delayed feathering of the right propeller after engine failure resulting in the airplane being unable to maintain altitude with the remaining engine and damage to the airplane during a forced landing in a field.NTSB ATL01LA047Accident · No injuriesLimited investigationFinal reportBell OH-58A · Lakeland, FLThe pilots failure to properly use the helicopter checklistNTSB MIA01FA108Accident · 1 fatalField investigationFinal reportPiper PA-60-601P · Marco Island, FLThe failure of the pilot to maintain control of the aircraft during a rejected landing and the collision with the terrain and mangrove trees. A finding in the investigation was the presence of quinine in the blood and urine during postmortem toxicological…NTSB ATL01LA044Accident · Minor injuriesLimited investigationFinal reportPiper PA-24 · Cross City, FLThe fracture of the crankshaft assembly that resulted in a total loss of engine power.NTSB ATL01LA042Accident · Serious injuriesLimited investigationFinal reportPiper PA-18A-150 · Niceville, FLA loss of engine power for undetermined reasons.NTSB DCA01MA031Accident · No injuriesMajor investigationFinal reportEmbraer EMB-120 · West Palm Beach, FLthe failure of the flight crew to maintain airspeed during an encounter with severe icing conditions, which resulted in an inadvertent stall, loss of control, and structural damage to the airplane.NTSB MIA01LA101Accident · No injuriesLimited investigationFinal reportRobinson R22 · Okeechobee, FLan in-flight collision with the ground during a simulated engine failure, and autorotation, which resulted in the tailboom separating. A contributing factor in this accident was the pilot allowed the rotor rpm to decay which resulted in inadequate rotor rpm…NTSB MIA01FA102Accident · Serious injuriesField investigationFinal reportPiper PA-34-200 · Palm Coast, FLthe second pilot's failure to maintain Vmc during a single engine approach resulting in a loss of control in flight and subsequent collision with objects and terrain during an uncontrolled descent. Contributing to the accident was the PIC turning the right…NTSB ATL01LA039Accident · No injuriesLimited investigationFinal reportCessna 182B · Boynton Beach, FLThe failure of a propeller actuator pin that resulted in an engine vibration and the loss of thrust. The airplane nosed over during the emergency landing roll. A factor was rough/uneven terrain.NTSB MIA01LA097Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Orlando, FLa fire due to a broken and separated turbocharger exhaust which allowed hot exhaust to ignite the engine shroud.NTSB ATL01LA038Accident · No injuriesLimited investigationFinal reportBeech 55 · Lake Wales, FLThe pilot's failure to follow the descent and before landing checklist that resulted in fuel starvation to both engines and the subsequent loss of engine power.NTSB MIA01LA094Accident · No injuriesLimited investigationFinal reportCessna 172L · Fort Lauderdale, FLThe total failure of the yoke weld assembly due to corrosion resulting in the inability of the flight crew to maintain elevator control of the airplane. Additionally, inadequate annual inspection of the airplane by other maintenance personnel for failure to…NTSB MIA01LA090Accident · No injuriesLimited investigationFinal reportCessna 182Q · Melbourne, FLThe failure of the pilot-in-command to maintain directional control of the airplane during the landing roll of the touch-and-go landing resulting in the on ground collision with a ditch and subsequent separation of the nose gear wheel and fork assembly and…NTSB MIA01IA091Incident · No injuriesIncident investigationFinal reportCessna 402C · Fort Lauderdale, FLIncomplete compliance with a non-mandatory Cessna Service Information Letter by an unknown person resulting in pulling through of the attach bolt of the upper and lower link assemblies and subsequent rotation of the right wheel assembly. Additionally,…NTSB MIA01LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · Naples, FLThe student's failure to maintain control of the aircraft during landing due to his improper landing flare height and improper recovery from a bounced landing, resulting in a nose landing gear collapse, and excursion off the runway.NTSB MIA01LA083Accident · No injuriesLimited investigationFinal reportPiper J5A · Hollywood, FLthe pilot's improper inflight planning/decision and inadequate fuel consumption calculations that resulted in fuel exhaustion and substantial damage to the aircraft as a result of a hard landing during the emergency descent/landing.