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 MIA06CA134Accident · Minor injuriesData collectionFinal reportCessna 172N · Pensacola, FLThe student pilot's failure to raise the wing flaps for a go-around resulting in the airplane not climbing and an in-flight collision with trees.NTSB DEN06MA119Accident · 1 fatalMajor investigationFinal reportMitsubishi MU-2B-35 · Argyle, FLthe pilot's inadvertent flight into thunderstorm activity that resulted in the loss of control, design limits of the airplane being exceeded and subsequent in-flight breakup. A contributing factor was the failure of air traffic control to use available radar…NTSB MIA06IA133Incident · No injuriesIncident investigationFinal reportBoeing 737-400 · Miami, FLThe pilot's inadvertent application of the left brakes at touchdown. Contributing to the incident was insufficient information in the quick reference handbook on the loss of touchdown protection with an inoperative anti-skid system.NTSB NYC06MA208Accident · 2 fatalMajor investigationFinal reportMitsubishi MU-2B-40 · Bunnell, FLThe pilot's inadvertent encounter with thunderstorms.NTSB MIA06CA131Accident · No injuriesData collectionFinal reportCessna 182S · Fort Myers, FLThe pilot's failure to maintain control during the landing rollout during gusting wind conditions, which resulted in the airplane veering off the runway.NTSB MIA06CA112Accident · No injuriesData collectionFinal reportCessna 150L · Crystal River, FLThe student pilot's improper recovery from a bounced landing.NTSB MIA06LA127Accident · No injuriesLimited investigationFinal reportAmerican Champion 7EC · Palmetto, FLThe pilot's failure to maintain airspeed while maneuvering which resulted in a stall.NTSB ANC06CA114Accident · No injuriesData collectionFinal reportCessna 172 · Palatka, FLThe student's failure to maintain adequate airspeed to preclude a stall while maneuvering over the runway, and the instructor's inadequate supervision of the student pilot, which resulted in a collision with the runway. A factor in the accident was an…NTSB ANC06LA113Accident · Serious injuriesLimited investigationFinal reportSeales Protech PT-2B · Crestview, FLThe pilot's failure to correct for torque/p-factor during takeoff initial climb, which resulted in a loss of control and a collision with trees and a power line. Factors contributing to the accident were the pilot's lack of familiarity with the airplane, and…NTSB ANC06CA122Accident · No injuriesData collectionFinal reportBell 206B · Orlando, FLThe pilot's failure to refuel the helicopter prior to the accident flight, which resulted in a loss of engine power during cruise flight, and a hard landing.NTSB ANC06LA102Accident · Serious injuriesLimited investigationFinal reportLiberty XL2 · Ormond Beach, FLThe pilot's improper recovery from a bounced landing, and failure to maintain minimum airspeed during the subsequent aborted landing, which resulted in an inadvertent stall and impact with terrain. A factor associated with the accident was the inadvertent…NTSB ANC06LA099Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Palatka, FLThe pilot's failure to maintain adequate airspeed to preclude a stall during the landing flare/touchdown, which resulted in a hard landing, a collapsed nose gear assembly, and a nose over. A factor associated with the accident was an inadvertent stall.NTSB ANC06LA098Accident · No injuriesLimited investigationFinal reportCessna 402B · Ft. Lauderdale, FLThe pilot's continued flight into adverse weather, and his failure to maintain directional control of the airplane during the landing roll, which resulted in a collision with an airport runway sign, and subsequent collapse of the nose gear. A factor…NTSB MIA06LA130Accident · No injuriesLimited investigationFinal reportCessna 550 · Marathon, FLThe separation for undetermined reasons of the stud (P/N 6541204-5) which secures the main landing gear actuator assembly side brace to the main landing gear outer cylinder, allowing partial collapse of the right main landing gear while taxiing after landing.NTSB ANC06LA092Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200 · Deland, FLThe flight instructor's inadequate supervision of the dual student during final approach to land, and his delayed remedial action following a partial loss of engine power on one of the two engines. Factors associated with the accident are the dual student's…NTSB MIA06LA123Accident · Minor injuriesLimited investigationFinal reportBell 206B · Pompano Beach, FLThe pilot's improper landing flare during a precautionary landing. A factor in the accident was the unusual noise as a result of an improper repaired air conditioner compressor system.NTSB MIA06LA122Accident · 1 fatalLimited investigationFinal reportCessna 320E · Wimauma, FLPilot's inadequate preflight planning and exceeding the weight and balance limitations of the airplane.NTSB MIA06LA121Accident · No injuriesLimited investigationFinal reportCessna T210 · Crestview, FLSpinning of the crankshaft No. 2 main bearing for undetermined reasons resulting in damage to the aft cheek of the No. 2 main bearing journal and fatigue failure of the crankshaft.NTSB ANC06CA091Accident · No injuriesData collectionFinal reportDahlstrom - Piel Emeraude CP-30 · Venice, FLThe pilot's inadequate compensation for crosswind conditions, which resulted in a loss of control during the landing roll. Factors associated with the accident were a crosswind, and an inadvertent swerve.NTSB ANC06CA090Accident · Minor injuriesData collectionFinal reportSchweizer 300C · Titusville, FLThe failure of the certificated flight instructor (CFI) to maintain control of the helicopter, which resulted in an in-flight collision with terrain. A factor associated with the accident was the dual student's improper use of the cyclic trim.NTSB ANC06CA082Accident · No injuriesData collectionFinal reportAmerican Legend AL-3 · St. Augustine, FLThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in a nose over when the airplane departed the runway.NTSB ANC06LA081Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Orlando, FLThe pilot's failure to maintain control of the airplane during the landing roll, which resulted in a on-ground encounter with the runway, and subsequent nose over. A factor contributing to the accident was an inadvertent ground loop.NTSB MIA06FA120Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-60 · Fort Pierce, FLthe pilot’s loss of aircraft control during the initial climb which was precipitated by the sudden loss of thrust and increase in drag from the right engine, and the pilot’s failure to adhere to the published emergency procedures regarding the position of the…NTSB MIA06CA119Accident · Serious injuriesData collectionFinal reportPiper PA-25-235 · Opa-Locka, FLThe failure of the pilot-in-command to maintain airspeed resulting in an inadvertent stall, uncontrolled descent, and in-flight collision with terrain.NTSB ANC06LA079Accident · Minor injuriesLimited investigationFinal reportRockwell 112TCA · Sarasota, FLThe pilot's inadequate preflight inspection of the fuel system, which resulted in a partial loss of engine power during cruise flight, and a subsequent ditching. Factors contributing to the accident were a low fuel level at departure, and fuel contamination.NTSB MIA06LA118Accident · 2 fatalLimited investigationFinal reportErcoupe 415C · Panacea, FLA loss of engine power for undetermined reasons, which resulted in the airplane descending and impacting trees during the approach. A possible contributing factor was the pilot's pre-existing cardiovascular condition.NTSB ANC06LA073Accident · Minor injuriesLimited investigationFinal reportMBB BK 117A-3 · Ponce de Leon, FLThe pilot's failure to maintain clearance from objects while hovering in ground effect, which resulted in an in-flight collision with a tree. Factors associated with the accident were loose, sand-covered terrain, and the operator's failure to ensure that the…NTSB MIA06FA117Accident · 1 fatalField investigationFinal reportBeech 65-A90-1 · Tampa, FLThe poor in-flight planning decision by the captain for his failure to establish the airplane on a stabilized approach for a forced landing, resulting in the airplane landing on a taxiway near the departure end of the runway. Contributing to the accident were…NTSB MIA06LA126Accident · No injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Navarre, FLThe inadequate manufacturing of the plates of the tail rotor tension-torsion bar assembly resulting in fatigue failure.NTSB ANC06LA069Accident · Minor injuriesLimited investigationFinal reportCessna 421B · Jacksonville, FLAn undetermined event during takeoff/initial climb, which resulted in an emergency landing after takeoff and substantial damage to the airplane.NTSB MIA06CA113Accident · No injuriesData collectionFinal reportCessna 172R · Kissimmee, FLThe pilot's improper flare.NTSB MIA06LA116Accident · No injuriesLimited investigationFinal reportTecnam P92 Super Echo · Sebring, FLThe loss of engine power for undetermined reasons resulting in a forced landing and collision with a fence.NTSB MIA06IA110Incident · No injuriesIncident investigationFinal reportCessna 172S · St. Augustine, FLThe loss of engine power due to separation of the crankshaft as a result of lack of adequate oil lubrication to the #2 main bearing. The lack of oil lubrication was most likely the result of improper assembly (fitting) of the bearing shells to the crankshaft.NTSB ANC06CA061Accident · No injuriesData collectionFinal reportPiper J-3 · Hollywood, FLThe flight instructor's inadequate supervision of the instructional flight during the landing roll in crosswind conditions, which resulted in a collision with a runway sign. Factors contributing to the accident were a crosswind, and the student pilot's…NTSB ANC06LA058Accident · No injuriesLimited investigationFinal reportBoeing A75-L3 · Lake Wales, FLThe pilot's failure to maintain proper runway alignment during the takeoff roll, which resulted in a collision with trees during a precautionary landing when the airplane touched down to the right of the runway edge. A factor contributing to the accident was…NTSB ANC06CA057Accident · No injuriesData collectionFinal reportRobinson R-44 · Indiantown, FLA hard landing and subsequent nose down when the helicopter pilot misjudged the landing flare during a touchdown autorotation.NTSB MIA06LA109Accident · Serious injuriesLimited investigationFinal reportMooney M20G · Lantana, FLThe pilot's inadequate preflight inspection, which resulted in a loss of engine power during initial climb due to water contamination in the fuel. Contributing factors were the deteriorated fuel cap o-ring and the pilot's failure to maintain adequate airspeed.NTSB ANC06CA055Accident · No injuriesData collectionFinal reportRockwell International S-2R · Perry, FLThe pilot's failure to refuel the airplane before fuel exhaustion, which resulted in a loss of engine power while maneuvering, and a subsequent forced landing and collision with trees.NTSB MIA06CA111Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Ormond Beach, FLA loss of engine power due to the student pilot's improper positioning of the fuel selector during takeoff. A contributing factor was the pilot's failure to abort the takeoff.NTSB MIA06LA108Accident · No injuriesLimited investigationFinal reportCessna 414A · Pompano Beach, FLThe pilot's inadequate preflight/planning due to his failure to assure an adequate supply of fuel was available for the flight, resulting in the loss of engine power in both engines due to fuel exhaustion.NTSB MIA06LA107Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Leesburg, FLThe loss of engine power for undetermined reasons.NTSB MIA06LA105Accident · Serious injuriesLimited investigationFinal reportCessna 421B · Marathon, FLThe pilot's failure to extend the landing gear prior to landing, which resulted in the propellers striking the runway, an aborted landing, and an in-flight collision with terrain.NTSB MIA06LA104Accident · Minor injuriesLimited investigationFinal reportChristopher Norris Glasair III · Daytona Beach, FLThe failure of the pilot to maintain airspeed while turning towards the runway after experiencing a partial loss of engine power, resulting in an uncontrolled descent, and in-flight collision with the runway. A factor in the accident was the failure of…NTSB MIA06CA101Accident · No injuriesData collectionFinal reportCessna 172N · Miami, FLThe improper flare by the pilot resulting in a hard landing and substantial damage to the airplane.NTSB MIA06CA100Accident · No injuriesData collectionFinal reportCessna 170B · Fort Pierce, FLThe failure of the pilot-in-command to maintain directional control during the landing roll.NTSB MIA06CA099Accident · No injuriesData collectionFinal reportHoward DGA-15P · Merritt Island, FLThe failure of the pilot to comply with the before landing checklist for his failure to lock the tailwheel.NTSB MIA06FA098Accident · 2 fatalField investigationFinal reportBeech A24R · Okeechobee, FLThe pilot's failure to maintain aircraft control as a result of spatial disorientation and an in-flight break up. Contributing to the accident were the dark night and thunderstorms.NTSB MIA06CA097Accident · Minor injuriesData collectionFinal reportLake LA-4-200 · Lake Wales, FLThe pilot's failure to abort the takeoff resulting in an overrun of the runway and encounter with terrain.NTSB MIA06CA096Accident · Minor injuriesData collectionFinal reportEurocopter Deutschland EC135T2 · Bonifay, FLThe pilot's failure to maintain main rotor rpm and proper descent rate resulting in a hard landing. A related factor in this accident was inadvertent encounter with clouds.NTSB MIA06CA095Accident · Minor injuriesData collectionFinal reportMarland E Davis RV-6A · Live Oak, FLFailure of the pilot to maintain directional control of the airplane during landing resulting in a nose over.