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 MIA99LA212Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Moore Haven, FLThe pilot exceeding the gross takeoff weight which reduced the climb capability and subsequent in-flight collision with terrain. Contributing to the accident was the high temperature and the pilot's failure to use aircraft performance data for the weather…NTSB MIA99FA208Accident · 1 fatalField investigationFinal reportGulfstream American AA-1B · Hilliard, FLthe pilot's failure to obtain notams and his improper planning and decision to use a closed runway for takeoff with tall trees on the departure end, resulting in a subsequent collision with the trees.NTSB MIA99LA210Accident · No injuriesLimited investigationFinal reportWilderoder Great Lakes 2TIA · Pensacola, FLThe pilot's failure to check the brake hydraulic fluid reservoir prior to flight resulting in a low fluid level going undetected and failure of the brakes during landing rollout, which resulted in the aircraft overrunning the runway, colliding with a fence,…NTSB MIA99LA207Accident · No injuriesLimited investigationFinal reportCessna 172M · Pierson, FLthe flight instructor's (pilot in command) failure to achieve the proper touch down point, his improper decision to continue the touch and go, and failure to abort the takeoff in sufficient time, resulting in the aircraft overrunning the runway and colliding…NTSB MIA99LA201Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Ormond Beach, FLa loss of engine power due to a stuck exhaust valve which resulted in a forced landing, the subsequent impact with the ground, and nose over.NTSB MIA99LA199Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Dunedin, FLThe pilot's inadequate fuel management which led to fuel exhaustion and subsequent loss of engine power.NTSB ATL99LA109Accident · 1 fatalLimited investigationFinal reportBlackburn John D. Jr. Bushby M II · Daytona Beach, FLThe pilot's failure to securely reconnect the distributor coil wire during routine maintenance. Factors were the unsuitable terrain and trees.NTSB ATL99LA110Accident · No injuriesLimited investigationFinal reportCessna 172N · Kissimmee, FLThe pilot's improper flare and recovery from a bounced landing.NTSB ATL99LA108Accident · No injuriesLimited investigationFinal reportHiller UH12-C · Venice, FLLoss of engine power due to fuel starvation as a result of the passenger inadvertently shutting off the fuel supply.NTSB MIA99LA197Accident · No injuriesLimited investigationFinal reportLet L-23 · Jacksonville, FLthe pilot's improper in-flight decisions allowing the glider to descend to a low altitude, resulting in a forced landing off the airport and subsequent impact with a tree.NTSB MIA99LA196Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Boca Raton, FLa total loss of engine power due to a failed oil pump impeller which resulted in a forced landing and a subsequent hard landing on a golf course.NTSB MIA99LA195Accident · No injuriesLimited investigationFinal reportRyan ST3KR · Lake City, FLthe improper maintenance and inspection of the propeller system, which resulted in loose and improperly torqued bolts, causing the subsequent failure of a propeller blade.NTSB MIA99FA188Accident · 2 fatalField investigationFinal reportBeech C90 · Munson, FLThe poor in-flight weather evaluation by the pilot-in-command and his operation of the airplane at an indicated airspeed greater than the design maneuvering speed (Va) in a thunderstorm contrary to the pilot's operating handbook resulting in an in-flight…NTSB MIA99LA186Accident · Serious injuriesLimited investigationFinal reportRobert R. Callahan Exec 90 · Lutz, FLThe excessive cyclic input by the non-qualified passenger during the autorotative landing following a reported loss of engine power. A factor in the accident was the inadequate preflight of the helicopter by the unqualified pilot for his failure to detect…NTSB MIA99LA184Accident · No injuriesLimited investigationFinal reportDonald White Velocity XL/RG · Fort Pierce, FLThe owner/pilot mechanic's failure to adjust the newly installed wing fuel caps resulting in the loss of engine power while in cruise flight due to fuel starvation and the subsequent collision with transmission wires while attempting a forced landing to a…NTSB MIA99LA183Accident · Serious injuriesLimited investigationFinal reportSouth Mississippi Light Aircra Buccaneer II · Panacea, FLThe intentional continued operation of the airplane by the pilot-in-command with known deficiencies with the pitot system after takeoff, resulting in erroneous airspeed indications, and inadvertent stall by the pilot resulting in the uncontrolled descent into…NTSB MIA99LA179Accident · 1 fatalLimited investigationFinal reportPiper PA-28R-180 · Wimauma, FLa passenger deplaning the airplane while the engine was running struck the propeller.NTSB MIA99LA175Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Fort Myers, FLThe pilot's failure to verify that the retractable landing gear were down and locked for landing.NTSB MIA99LA171Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Lantana, FLThe poor in-flight planning by the pilot during the approach for a precautionary landing following a power interruption during the downwind leg, resulting in a go-around. A Contributing factor to the accident was the total loss of engine power during the…NTSB MIA99FA172Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Cape Canaveral, FLThe pilot's VFR flight into Instrument meteorological conditions and his subsequent failure to maintain control of the aircraft resulting in overload and separation of both wings. Contributing factors were the pilot's failure to obtain a preflight and…NTSB MIA99FA168Accident · No injuriesField investigationFinal reportCessna 402C · Fort Lauderdale, FLThe pilot's decision takeoff with condensation on the cockpit windows which restricted visibility, his improper use of aileron control, improper compensation for winds during takeoff, and his failure to maintain directional control during takeoff, resulting…NTSB MIA99LA167Accident · Minor injuriesLimited investigationFinal reportCessna 150M · St. Augustine, FLThe student pilot's inadequate compensation for the crosswind condition. A factor associated with the accident was the crosswind.NTSB MIA99LA185Accident · No injuriesLimited investigationFinal reportBeech E-35 · Yankeetown, FLThe failure of maintenance personnel to balance check the ruddervators after painting the airplane and unclear information contained in the compliance section of AD 94-20-04 resulting in the failure of maintenance personnel to balance check the out-of-balance…NTSB ATL99LA097Accident · No injuriesLimited investigationFinal reportCessna 172RG · Sanford, FLThe pilot's failure to maintain directional control during landing.NTSB MIA99LA160Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Orlando, FLThe pilots misjudgment of altitude during an attempted banner tow pick-up. This resulted in the banner becoming entangled around the main landing gear. The pilot made a go-around. On landing rollout the banner became entangled around a runway light, and the…NTSB MIA99FA159Accident · 1 fatalField investigationFinal reportClassic S-51D · Tamarac, FLA complete loss of engine power caused by the malfunctioning landing gear, which blocked the radiator scoop, leading to increased fuel temperature and the subsequent vapor lock condition and fuel blockage. A secondary cause was the pilot's failure to maintain…NTSB MIA99FA158Accident · 1 fatalField investigationFinal reportHughes 369E · Intercession, FLThe pilot's improper fuel management that resulted in fuel exhaustion and a total loss of engine power.NTSB ATL99LA091Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Brooksville, FLThe certified flight instructor's failure to recover from a porpoise during landing and his failure to maintain directional control.NTSB DCA99IA058Incident · No injuriesIncident investigationFinal reportAirbus Industrie 300-600 · Miami, FLUncommanded rudder movement caused by a contaminant in the engagement valve solenoid that prevented disengagement of the autopilot yaw actuator and cross-connected wiring of the autopilot yaw actuator's main valve solenoids by the operator. Factors…NTSB MIA99LA154Accident · No injuriesLimited investigationFinal reportRyan ST-A · Leesburg, FLThe pilot's failure to maintain adequate clearance from the fence.NTSB MIA99LA151Accident · No injuriesLimited investigationFinal reportBoone RV6 · Apalachicola, FLA loss of engine power for undetermined reasons.NTSB ATL99FA078Accident · Serious injuriesField investigationFinal reportCessna 172N · Winter Haven, FLThe pilot of the other aircraft's failure to maintain visual lookout. A factor was the other pilot's disregard for VFR Traffic pattern procedures.NTSB MIA99FA142Accident · 4 fatalField investigationFinal reportCessna 210L · Vero Beach, FLA loss of engine power due to a disconnected throttle/power lever, cable. Also causal was the failure of the mechanic to install a cotter pin in the throttle control cable attach hardware at the throttle control arm, and failure of the company quality control…NTSB ATL99LA076Accident · Minor injuriesLimited investigationFinal reportSchempp-Hirth MINI-NIMBUS · Groveland, FLThe pilot's inability to locate a thermal and the in-flight encounter with a down draft.NTSB MIA99FA140Accident · 1 fatalField investigationFinal reportBeech B95A · Fountain, FLThe pilot's inadequate preflight inspection of the airplane that resulted in a loss of engine power because of fuel vent blockage and his selection of unsuitable terrain for the forced landing.NTSB MIA99LA138Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Fernandina Bch, FLThe failure of the pilot to use the printed checklist which resulted in the gear-up landing. A factor associated with the accident was the intermittent failure of the gear warning horn.NTSB MIA99LA136Accident · Minor injuriesLimited investigationFinal reportCessna 402B · Fort Lauderdale, FLA loss of engine power due to fuel exhaustion and the pilot in command's failure to ensure that the aircraft had adequate fuel to complete the flight.NTSB MIA99LA135Accident · Serious injuriesLimited investigationFinal reportCessna 150M · S. Rockledge, FLA total loss of engine power while in cruise flight due to the pilot's failure to use carburetor heat during carburetor icing conditions and the subsequent emergency landing to unsuitable terrain and collision with a tree.NTSB MIA99LA145Accident · No injuriesLimited investigationFinal reportBeech E33 · Orlando, FLthe pilot's failure to maintain control of the airplane during takeoff, resulting in the airplane departing the runway, and subsequently impacting with an airport sign.NTSB MIA99LA130Accident · Minor injuriesLimited investigationFinal reportZemp Avid Catalina · Sebring, FLThe in-flight separation of one of the propeller blade's and one of the engine's exhaust pipes causing the engine to vibrate until it stopped running. A related factor was the unsuitable terrain for the forced landing.NTSB MIA99LA128Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Vero Beach, FLThe improper return to service of a propeller hub by a propeller overhaul company which according to manufacturer's procedures should have been retired due to damage to propeller blades from sudden stoppage. This resulted in undetected fatigue propagation…NTSB MIA99LA127Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Pensacola, FLThe pilot's inability to maintain directional control due to failure of the main landing gear, and partial electrical system failure for undetermined reasons.NTSB MIA99FA126Accident · Minor injuriesField investigationFinal reportBeech E-55 · Lakeland, FLFailure of the pilot of the other aircraft to maintain a visual lookout and visual separation while on approach for landing. This resulted in a midair collision with another airplane and subsequent in-flight collision with the runway.NTSB ATL99LA071Accident · Serious injuriesLimited investigationFinal reportHoskins Craig Lightning BUG · Crystal River, FLThe pilot's failure to maintain control of the airplane, which resulted in an inadvertent stall.NTSB MIA99LA124Accident · Minor injuriesLimited investigationFinal reportBean Whitman W-10 · Wimauma, FLThe pilot's failure to maintain a visual lookout during a forced landing resulting in an in-flight collision with a ditch and subsequent nose over.NTSB MIA99LA129Accident · No injuriesLimited investigationFinal reportMbb BK 117 A-3 · Sarasota, FLThe pilot-in-command's failure to maintain a visual lookout while maneuvering in a hover resulting in the tail rotor colliding with a building.NTSB MIA99LA121Accident · No injuriesLimited investigationFinal reportFrederick Sweet Rotorway Exec · Fort Myers, FLThe pilot-in-command's failure to maintain aircraft control after the ground tie chain separated during engine run and hovering operations.NTSB MIA99LA119Accident · No injuriesLimited investigationFinal reportDavid C. Bock Challenger II · Astatula, FLThe aircraft structure fluttering inflight resulting in fracture of fuselage longerons and the pilot being unable to maintain control.NTSB MIA99LA118Accident · No injuriesLimited investigationFinal reportSteve Hill Staudacher S600 · Bunnell, FLThe pilot's improper fuel consumption calculations which resulted in fuel exhaustion.NTSB ATL99LA067Accident · Minor injuriesLimited investigationFinal reportde Havilland DHC-6-200 · Lantana, FLThe pilot's failure to secure the engine oil filler cap during the preflight inspection that resulted the subsequent loss of engine power, and his in-flight decision to attempt a single engine go-around with full wing flaps extended.