NTSB investigations, FL
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 ERA13CA130Accident · Minor injuriesData collectionFinal reportDratbe Shmiel Amir Classic Edge X · Miami, FLThe student pilot's decision to fly at low altitude surrounded by tree, wire, and water hazards, and his failure to maintain clearance from those obstacles.NTSB ERA13LA127Accident · Minor injuriesLimited investigationFinal reportHiller UH-12B · Merritt Island, FLA total loss of engine power due to fuel starvation, which resulted from an overstress failure of a fitting on the fuel supply line and led to an autorotation and hard landing.NTSB ERA13LA119Accident · Serious injuriesLimited investigationFinal reportShoemaker James B KR-2 · Palmetto, FLThe total loss of engine power for undetermined reasons, which resulted in a forced landing.NTSB ERA13LA118Accident · Minor injuriesLimited investigationFinal reportHiller-Tri-Plex Ind.Inc. UH-12B · Okeechobee, FLThe pilot's failure to monitor carburetor temperature and use carburetor heat in conditions conducive to serious carburetor icing, which resulted in partial loss of engine power.NTSB ERA13CA120Accident · No injuriesData collectionFinal reportMallory Christopher L RV-8 · Lake City, FLThe pilot’s failure to maintain directional control during the landing roll.NTSB DCA13LA039Accident · No injuriesLimited investigationFinal reportBoeing 777 - 300 · Miami, FLLV-BMT flight crew's incorrect evaluation of the clearance between the two aircraft, leading to the inadvertent collision of the left winglet with the horizontal stabilizer and elevator of F-GNZI. Contributing to the accident were the incorrect instructions…NTSB ERA13IA114Incident · No injuriesIncident investigationFinal reportCessna 560XL · Debary, FLAn accumulation of debris in the airplane’s bilge drain holes that prevented accumulated moisture from properly draining; the accumulated moisture subsequently froze around the elevator control components, which resulted in the flight control stiffness.…NTSB ERA13FA109Accident · 2 fatalField investigationFinal reportBenton Fred D Seawind 3000 · Sarasota, FLThe pilot's inability to establish a normal climb rate after takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB ERA13LA112Accident · No injuriesLimited investigationFinal reportCessna T182 · Brandon, FLFailure of the No. 2 cylinder’s rod bearing, which resulted in a total loss of engine power.NTSB ERA13FA105Accident · 3 fatalField investigationFinal reportBeech H35 · Palm Coast, FLA total loss of engine power after the failure of the No. 4 connecting rod due to oil starvation, which resulted in a subsequent forced landing. Contributing to the accident was the pilot’s failure to clearly state that the aircraft had lost all power and the…NTSB ERA13LA104Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Tampa, FLThe student pilot’s delayed throttle application during the practice autorotation and the flight instructor’s lack of immediate remedial action, which resulted in a hard landing.NTSB ERA13FA096Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Leesburg, FLThe pilot's inadequate preflight planning, which resulted in fuel exhaustion and a subsequent total loss of power in both engines during cruise flight. Contributing to the accident was the pilot’s use of prescription and illicit drugs, which likely impaired…NTSB ERA13LA099Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Boca Raton, FLThe pilot's improper landing flare after a loss of engine power shortly after takeoff, which resulted in a hard landing. The reason for the loss of engine power could not be determined based on the available information.NTSB ERA13LA094Accident · No injuriesLimited investigationFinal reportWragg George Skybolt · Sarasota, FLThe pilot's inadequate preflight planning and failure to monitor the fuel quantity during flight, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA13FA082Accident · 1 fatalField investigationFinal reportCessna 421C · Lake Worth, FLThe pilot's failure to follow established engine-out procedures and to maintain a proper airspeed after the total loss of engine power on one of the airplane’s two engines during the initial climb. Contributing to the accident was the total loss of engine…NTSB ERA13FA071Accident · 1 fatalField investigationFinal reportGreen Gary E Thorp T-18 · Pahokee, FLThe descent and overstress of the airplane during the descent, which resulted in the in-flight breakup of the airplane.NTSB ERA13CA073Accident · No injuriesData collectionFinal reportBeech B19 · Fort Lauderdale, FLThe pilot's inadequate preflight planning, which resulted in fuel exhaustion and a total loss of engine power.NTSB ERA13FA070Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta II · Apollo Beach, FLMast bumping for reasons that could not be determined because one main rotor blade was not recovered.NTSB ERA13LA069Accident · Serious injuriesLimited investigationFinal reportLawson J/Bowie R/Smith M CA-8 · Merritt Island, FLThe pilot's improper decision to continue a cross-country flight as a primary control (aileron) system anomaly progressively worsened. Contributing to the accident was an aileron control system anomaly, the reason for which could not be determined because the…NTSB ERA13LA049Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Fort Lauderdale, FLThe collapse of the right main landing gear during landing for reasons that could not be duplicated or determined during the postaccident investigation because of the initial unavailability of the airplane after the accident.NTSB ERA13LA048Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Pahokee, FLA main landing gear wheel fire for reasons that could not be determined because postaccident examinations did not reveal any anomalies that would have precluded normal operations.NTSB ERA13CA044Accident · No injuriesData collectionFinal reportCessna 172R · Miami, FLThe flight instructor's improper power management during a steep, obstacle-clearance approach, which resulted in a hard landing.NTSB ERA13LA020Accident · 2 fatalLimited investigationFinal reportAirborne Windsports PTY XT-912 · Winter Haven, FLThe pilot’s failure to maintain aircraft control during takeoff in crosswind conditions, which resulted in collision with terrain.NTSB ERA13LA043Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 42 NG · Palm Coast, FLThe pilot’s failure to maintain adequate airspeed, which resulted in a hard landing.NTSB ERA13CA016Accident · No injuriesData collectionFinal reportCessna 172P · Cedar Key, FLThe pilot's failure to attain the proper touchdown point, which resulted in a runway excursion.NTSB ERA13LA013Accident · Serious injuriesLimited investigationFinal reportBeaudry Phillip Aventura II · Minneola, FLA partial loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB ERA12FA572Accident · 1 fatalField investigationFinal reportCessna 172S · Land O'Lakes, FLThe pilot’s decision to continue the cross-country flight while fatigued, which resulted in him falling asleep during the initial descent for landing.NTSB ERA12LA571Accident · No injuriesLimited investigationFinal reportBeagle B206 Series 2 · Perry, FLThe pilot’s improper in-flight fuel management, which resulted in fuel starvation and the right engine’s complete loss of power. Contributing to the accident was the pilot’s improper configuration of the airplane following the loss of engine power.NTSB ERA12LA586Accident · No injuriesLimited investigationFinal reportStewart Mw/Stewart JD Sonerai 2L · Titusville, FLThe pilot's failure to attain the proper landing approach speed and touchdown point, which resulted in a runway excursion after touchdown and collision with a ditch.NTSB ERA12CA564Accident · Minor injuriesData collectionFinal reportLancair LC42-550FG · Okeechobee, FLThe pilot's improper landing flare, which resulted in a hard landing.NTSB ERA12IA559Incident · No injuriesIncident investigationFinal reportCessna 402B · Opa-Locka, FLThe pilot’s turning the airplane too sharply while exiting the runway, which resulted in the failure of the right main landing gear bellcrank due to an overstress fracture.NTSB ERA12CA560Accident · No injuriesData collectionFinal reportCessna 172S · Sebring, FLThe student pilot's improper flare, which resulted in a hard landing.NTSB ERA12LA537Accident · 2 fatalLimited investigationFinal reportQuad City Ultralights Challenger II · Ocala, FLThe pilot's inadvertent overstress of the airplane, which resulted in the in-flight separation of the outer section of the right wing.NTSB ERA12LA525Accident · No injuriesLimited investigationFinal reportCessna 152 · Ormond Beach, FLThe pilot's improper decision to take off again after a successful abort due to diminished airplane climb performance. Contributing to the accident was carburetor icing during the taxi, which resulted in the loss of engine performance.NTSB ERA12LA524Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Riverview, FLDamage to the propeller governor gasket during installation by unknown persons, which resulted in a total loss of engine oil in flight and a subsequent forced landing.NTSB ERA12CA529Accident · No injuriesData collectionFinal reportStinson 108-2 · Winter Haven, FLThe pilot’s failure to maintain directional control during the takeoff, which resulted in a runway excursion.NTSB ERA12LA522Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Hernando Beach, FLA partial loss of engine power due to a blockage of the No. 6 cylinder fuel injector nozzle.NTSB ERA12CA521Accident · Minor injuriesData collectionFinal reportCessna 152 · Deland, FLThe pilot’s failure to maintain airplane control on final approach in gusting wind conditions. Contributing to the accident was the pilot’s decision to operate in an environment of thunderstorms and rapidly deteriorating weather.NTSB ERA12LA494Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Titusville, FLInadequate maintenance servicing and inspection of the nose landing gear, which resulted in the failure of the nose landing gear to lock and its subsequent collapse during landing.NTSB ERA12FA491Accident · 1 fatalField investigationFinal reportSilvaire Luscombe 8A · St. Petersburg, FLThe flight instructor’s and the pilot’s failure to maintain airspeed after a partial loss of engine power after takeoff for reasons that could not be determined during postaccident examination, which resulted in an aerodynamic stall and loss of airplane…NTSB ERA12CA490Accident · No injuriesData collectionFinal reportAeronca 7AC · Winter Haven, FLThe student pilot’s failure to maintain directional control during the landing roll.NTSB ERA12LA477Accident · No injuriesLimited investigationFinal reportHughes 269C · St. Petersburg, FLThe pilot's failure to assure that the lateral friction control was released prior to flight.NTSB ERA12CA466Accident · No injuriesData collectionFinal reportCessna 172P · St. Augustine, FLUndetermined due to a lack of information about when the damage to the airplane occurred.NTSB ERA12LA452Accident · Minor injuriesLimited investigationFinal reportAeronca 7CCM · Ocklawaha, FLThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power during cruise flight due to fuel exhaustion.NTSB ERA12LA442Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Pensacola, FLA partial loss of engine power during initial climb for reasons that could not be determined because examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB ERA12LA440Accident · Serious injuriesLimited investigationFinal reportCessna 170 · Panama City, FLA total loss of engine power due to water contamination of the fuel, the pilot/owner's inadequate preflight inspection of his airplane, and his failure to maintain airplane control after the engine failure.NTSB ERA12LA429Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 · Tallahassee, FLThe pilot’s failure to maintain awareness of the helicopter’s altitude while attempting to troubleshoot the clutch actuator warning light, which resulted in an inadvertent descent and impact with water. Contributing to the accident was the pilot's possible…NTSB ERA12LA417Accident · No injuriesLimited investigationFinal reportLuters Arnis V Legend · Glenwood, FLThe total loss of engine power due to the airplane builder’s improper installation of the fuel control unit condition lever cables, which resulted in the airplane’s subsequent forced landing.NTSB ERA12CA419Accident · No injuriesData collectionFinal reportCessna 172S · West Palm Beach, FLThe flight instructor’s failure to maintain airplane control during the takeoff in gusting crosswind conditions. Contributing to the accident was the flight instructor’s decision to conduct takeoffs and landings in conditions exceeding the airplane’s maximum…NTSB ERA12CA407Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Lake Wales, FLThe flight instructor’s inadequate supervision of the student pilot’s power management, which resulted in a hard landing. Contributing to the accident was the student pilot's premature power reduction during the landing flare.