NTSB investigations, FL
18 cases where NTSB found Soft surface.
Cases per year
| 2009 | 2 |
|---|---|
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 5 |
| 2017 | 1 |
| 2018 | 3 |
| 2019 | 2 |
| 2020 | 1 |
| 2021 | 1 |
| 2023 | 1 |
Where
Latest cases
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'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03023020'))
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' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03023020')) 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 ERA23LA211Accident · Minor injuriesClass 4 · LimitedFinal reportAeropilot S R O Legend 600 · Vero Beach, FLThe pilot's improper recovery from a bounced landing, which resulted in a nose landing gear collapse and subsequent noseover. Contributing was the rough condition of the runway, as described by the pilot, and his decision to operate from it.NTSB ERA21FA194Accident · 3 fatalClass 3 · FieldFinal reportBeech C23 · Middleburg, FLThe pilot's decision to depart from a soft grass runway with a tailwind, which resulted in an increased takeoff distance and subsequent impact with trees during the initial climb.NTSB ERA20LA334Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · New Smyrna Beach, FLThe pilot’s decision to depart from a non-suitable surface, which resulted in a loss of directional control during takeoff roll.NTSB GAA19CA505Accident · No injuriesData collectionFinal reportPipistrel Sinus 912 · Oxford, FLThe pilot’s continued use of battery power during a nonpowered flight in a powered-glider, which depleted the battery to a level that was insufficient to power the starter during the engine restart sequence and resulted in a forced landing to a soft field and…NTSB GAA19CA362Accident · No injuriesData collectionFinal reportCessna 172 · Tampa, FLThe student pilot's failure to maintain directional control during landing, which resulted in a runway excursion and subsequent nose-over.NTSB ERA19LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Bell Glade, FLA partial loss of engine power due to the No. 1 cylinder's valve keeper becoming dislodged, which ultimately resulted in the intake valve becoming stuck in the valve guide and in the loss of compression to the cylinder.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 GAA18CA182Accident · No injuriesData collectionFinal reportHeinlein George GH125 · Valkaria, FLThe pilot’s decision to exit the paved runway into soft terrain, which resulted in a ground loop and landing gear collapse.NTSB ERA17LA122Accident · No injuriesLimited investigationFinal reportXtremeair XA42 · West Palm Beach, FLA total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no evidence of any preimpact mechanical failures or malfunctions that would have precluded normal operation.NTSB ERA17LA071Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Palm Bay, FLUnknown maintenance personnel’s improper routing of electrical wires in the engine compartment, which resulted in chafing and a subsequent in-flight fire.NTSB ERA17LA070Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Ormond Beach, FLThe pilot's impairment by alcohol before and during the flight, which led to his improper fuel management and resulted in fuel exhaustion and a subsequent loss of engine power.NTSB GAA17CA084Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · Pensacola, FLThe student pilot’s incorrect brake application during the landing roll, which resulted in a loss of directional control.NTSB ERA17LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLThe loss of torque on the No. 3 connecting rod’s nuts, which resulted in the failure of the No. 3 connecting rod’s bolts and a subsequent total loss of engine power due to the operator's maintenance personnel’s improper installation of the connecting rod nuts.NTSB GAA17CA022Accident · No injuriesData collectionFinal reportAllen Robert RV6 · Ocala, FLThe pilot's improper fuel planning, which resulted in fuel exhaustion, a total loss of engine power, and a forced landing.NTSB GAA15CA254Accident · No injuriesData collectionFinal reportPiper PA 18-150 · LaBelle, FLThe pilot's selection of unsuitable terrain for landing, which resulted in a nose over and impact with terrain.NTSB ERA14TA113Accident · No injuriesFinal reportHughes 369 · Naples, FLThe pilot's inadequate flare during the termination of a practice 180-degree autorotation and the flight instructor's delayed remedial action, which resulted in the tail rotor contacting the ground.NTSB ERA09CA548Accident · No injuriesData collectionFinal reportPiper PA-20 · Herlong, FLThe pilot’s improper visual lookout while taxing on soft terrain.NTSB ERA09CA334Accident · No injuriesData collectionFinal reportPiper J3C-65 · Alamana, FLThe pilot's selection of unsuitable terrain for landing.