NTSB investigations, FL
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 ERA18TA222Accident · Serious injuriesFinal reportGlobe GC1B · Wellington, FLThe partial loss of engine power during the initial climb due to a sticking intake valve on the No. 3 cylinder.NTSB ERA18LA227Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Mayport, FLThe failure of a fuel line due to improper installation of a fuel flow sensor, which resulted in fuel starvation and a subsequent total loss of engine power.NTSB ERA18LA220Accident · No injuriesLimited investigationFinal reportCzech Sport Piper Sport · Stuart, FLInadequate maintenance inspection of the airplane's nose landing gear, which resulted in a nose landing gear collapse during landing due to cracking and corrosion.NTSB ERA18LA214Accident · No injuriesClass 3 · LimitedFinal reportPipistrel Sinus 912 · West Palm Beach, FLThe fatigue failure of the exhaust system manifold, which resulted in a ground fire after landing.NTSB GAA18CA479Accident · No injuriesData collectionFinal reportPiper PA28 · Merritt Island, FLThe pilot's exceedance of the airplane's critical angle of attack while maneuvering to avoid a bird during the landing flare, which resulted in an aerodynamic stall.NTSB GAA18CA478Accident · No injuriesData collectionFinal reportCessna 172 · Crystal River, FLThe pilot’s improper landing flare, which resulted in a hard landing.NTSB GAA18CA450Accident · Minor injuriesData collectionFinal reportRobinson R44 · Lantana, FLThe student pilot’s improper pitch control during landing, which resulted in a dynamic rollover.NTSB ERA18FA200Accident · 2 fatalField investigationFinal reportPiper PA24 · Palatka, FLThe pilot's exceedance of the airplane's critical angle of attack during the initial climb after takeoff, which resulted in an aerodynamic stall and a loss of control.NTSB ERA18TA203Accident · No injuriesFinal reportBeech C90 · Lecanto, FLThe pilot's failure to turn on the fuel transfer pumps in accordance with the published checklists, which resulted in a dual loss of engine power due to fuel starvation.NTSB ERA18LA201Accident · No injuriesClass 3 · LimitedFinal reportAero Commander 560 · Crestview, FLA collapse of the right main landing gear for reasons that could not be determined based on the available information.NTSB GAA18CA445Accident · No injuriesData collectionFinal reportCirrus SR20 · Sanford, FLThe flight instructor's failure to maintain an appropriate approach speed in crosswind conditions, which resulted in the airplane landing long on the wet runway and his subsequent loss of directional control when he attempted to exit the runway at high speed…NTSB DCA18CA316Accident · Serious injuriesClass 4 · Data collectionFinal reportAirbus A319 · West Palm Beach, FLAn inadvertent encounter with convective turbulence.NTSB ERA18FA194Accident · 4 fatalField investigationFinal reportPiper PA34 · Miami, FLThe failure of both pilots in both airplanes to see and avoid the other airplane as they converged nearly head-on at the same altitude.NTSB GAA18CA427Accident · Minor injuriesData collectionFinal reportCessna 152 · Hollywood, FLThe student pilot’s inadvertent encounter with thunderstorm conditions and her failure to maintain a proper landing flare in a crosswind, which resulted in a bounced landing.NTSB GAA18CA406Accident · No injuriesData collectionFinal reportBeech 76 · Fort Lauderdale, FLThe pilot receiving instruction's failure to maintain a proper approach path and her delayed go-around during a simulated emergency landing, which resulted in landing short of the runway. Contributing to the accident was the flight instructor's failure to…NTSB ERA18LA184Accident · 1 fatalLimited investigationFinal reportSwearingen SX300 · Daytona Beach, FLThe pilot's failure to maintain adequate airspeed during landing, which led to the airplane exceeding its critical angle-of-attack, experiencing an aerodynamic stall and hard landing, which resulted in a landing gear collapse, loss of directional control, and…NTSB GAA18CA388Accident · Minor injuriesData collectionFinal reportCessna A185 · Miami, FLThe pilot’s failure to retract the wheels of the amphibious airplane on takeoff, which resulted in a nose-over when the airplane landed on water with the wheels extended. Contributing to the accident was the pilot’s failure to use appropriate checklists.NTSB GAA18CA419Accident · No injuriesData collectionFinal reportCessna 152 · Panama City, FLThe pilot’s improper preflight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.NTSB WPR18LA179Accident · No injuriesLimited investigationFinal reportCessna 340A · Orlando, FLThe pilot's delayed decision to discontinue the takeoff when confronted with abnormal acceleration and airspeed indication; the reason for the abnormal acceleration could not be determined based on the available information.NTSB WPR18LA183Accident · No injuriesLimited investigationFinal reportCessna 182 · Jacksonville, FLA total loss of engine power for reasons that could not be determined due to insufficient evidence.NTSB GAA18CA364Accident · No injuriesData collectionFinal reportCessna 182T · Sebring, FLThe pilot’s failure to maintain directional control during landing with a crosswind.NTSB ERA18LA171Accident · No injuriesLimited investigationFinal reportPiper PA 30 · Vero Beach, FLThe collapse of all three landing gear for reasons that could not be determined because postaccident examination of the landing gear system revealed no evidence of any mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR18LA209Accident · No injuriesClass 3 · LimitedFinal reportCessna 402 · Fort Lauderdale, FLThe failure of the left starter relay, which resulted in a loss of electrical power during the flight and the failure of the T-handle from the cable led to a forced landing with the landing gear retracted.NTSB ERA18LA178Accident · Minor injuriesLimited investigationFinal reportPiper PA 34-200 · Umatilla, FLMaintenance personnel ‘s failure to complete and verify the proper installation of the main landing gear (MLG) torque links’ attachment hardware, which resulted in the right MLG torque link disconnecting and the pilot’s subsequent inability to maintain…NTSB WPR18LA166Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 421C · Plant City, FLThe pilot's delayed decision to abort the takeoff, which resulted in a runway overrun. Contributing to the accident was an engine anomaly for reasons that could not be determined based on the available information, and the pilot's failure to activate the…NTSB GAA18CA344Accident · No injuriesData collectionFinal reportBeech A36 · Arcadia, FLThe pilot’s loss of directional control during landing due to a flat tire.NTSB ERA18LA164Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA 44 · Daytona Beach, FLThe pilots’ improper in-flight weather evaluation and decision to continue the approach, which resulted in an encounter with a thunderstorm, a loss of airplane control, and collision with terrain. Contributing to the accident was the flight instructor’s…NTSB ERA18LA162Accident · No injuriesLimited investigationFinal reportBryan C L/Labrash R D Searey · Englewood, FLThe partial loss of engine power due to carburetor icing.NTSB GAA18CA348Accident · No injuriesData collectionFinal reportCessna 172 · Orlando, FLThe pilot’s improper landing flare, which resulted in a bounced, hard landing.NTSB GAA18CA308Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Cedar Key, FLThe airplane’s collision with multiple birds during initial climb, which damaged the propeller and resulted in a subsequent aerodynamic stall because the airspeed could not be maintained.NTSB GAA18CA343Accident · Serious injuriesData collectionFinal reportAmerican AA · Port Orange, FLThe pilot’s inadequate preflight inspection of the fuel, which resulted in fuel exhaustion and a subsequent total loss of engine power.NTSB ERA18FA152Accident · 1 fatalField investigationFinal reportCessna 140 · Daytona Beach, FLThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel starvation during the initial climb, and his failure to maintain adequate airspeed while turning back to the runway, which resulted in an exceedance of the…NTSB GAA18CA299Accident · No injuriesData collectionFinal reportCessna 172 · Defuniak Springs, FLThe student pilot’s failure to maintain directional control during the aborted landing.NTSB GAA18CA292Accident · No injuriesData collectionFinal reportPiper PA28 · Merritt Island, FLThe student pilot’s improper landing flare in tailwind conditions, which resulted in a hard landing.NTSB GAA18CA261Accident · Minor injuriesData collectionFinal reportZenair CH 2000 · Naples, FLThe student pilot’s improper landing flare, which resulted in a bounced landing.NTSB ERA18TA144Accident · Serious injuriesFinal reportChristopher Lord ELA 07 Scorpion · Sebring, FLThe pilot's failure to slow the gyroplane and maintain control while exiting the runway.NTSB ERA18LA145Accident · No injuriesLimited investigationFinal reportPiper PA28 · Vero Beach, FLWater contamination of the fuel supply, which resulted in a total loss of engine power.NTSB WPR18LA135Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 152 · Tamiami, FLThe non-instrument-rated pilot’s loss of control during an encounter with instrument meteorological conditions at night. Contributing to the accident was the pilot's decision to depart on the flight without obtaining approval to fly at night in accordance…NTSB ERA18LA140Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Panama City, FLThe pilot's failure to properly remove and secure the tie-down ropes during the preflight inspection, which resulted in the ropes becoming entangled in the rotor head swashplate and pitch control rods during flight and the subsequent loss of pitch control.NTSB WPR18LA132Accident · Minor injuriesLimited investigationFinal reportCosmos Phase III · Fernandina Beach, FLThe student pilot's failure to maintain aircraft control and the flight instructor’s failure to adequately monitor the student pilot before aircraft control was lost at a low altitude.NTSB GAA18CA243Accident · No injuriesData collectionFinal reportCessna 310 · Gainesville, FLThe pilot’s failure to maintain an adequate approach path at night, which resulted in a tree strike.NTSB WPR18LA124Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 34-220T · Clewiston, FLThe pilot's failure to maintain directional control during takeoff following an overboost of the right engine during takeoff.NTSB GAA18CA219Accident · No injuriesData collectionFinal reportStone James R Daytona Cubs Replica · Orlando, FLThe pilot’s failure to maintain lateral control during landing in crosswind conditions.NTSB GAA18CA218Accident · No injuriesData collectionFinal reportPiper PA 28-161 · Pensacola, FLThe pilot’s loss of directional control and long landing in gusting wind conditions due to his shoe getting stuck on the brakes.NTSB ERA18FA128Accident · 1 fatalField investigationFinal reportS.Z.D. SZD 48 Jantar STD 2 · LaBelle, FLThe pilot's failure to maintain control of the glider for reasons that could not be determined based on the available evidence.NTSB DCA18WA140Incident · No injuriesForeign investigationAirbus A320 · Orlando, FLThe Transportation Safety Board (TSB) of Canada has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on April 14, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the TSB's investigation under the…NTSB GAA18CA212Accident · No injuriesData collectionFinal reportSasser Allen L Searey · Welaka, FLThe pilot’s incorrect pitch input during a water landing, which resulted in a nose-over. Contributing to the accident were the pilot’s inadequate training and experience in the make and model airplane.NTSB ERA18FA120Accident · 2 fatalClass 3 · FieldFinal reportPiper PA28R · Daytona Beach, FLExtensive fatigue cracking in the left-wing main spar lower cap and doublers, which resulted in the in-flight separation of the left wing. The fatigue cracks initiated and grew to a critical size due to flight and ground loads associated with flight-training…NTSB ERA18LA117Accident · No injuriesClass 3 · LimitedFinal reportStanley Lancair · Sebring, FLThe failure of ground personnel to obtain permission from airport management to conduct engine test runs; adequately monitor the area behind the B737 for traffic; and install barricades to prevent access behind the running airplane, which resulted in the…NTSB ERA18LA116Accident · Minor injuriesClass 3 · LimitedFinal reportLindstrand Balloons 105A · Wesley Chapel, FLThe pilot's failure to maintain adequate clearance from powerlines during landing approach, which resulted in an inflight collision with the powerlines.