NTSB investigations, FL
8 cases where NTSB found Repair.
Cases per year
| 2011 | 1 |
|---|---|
| 2012 | 1 |
| 2014 | 1 |
| 2016 | 2 |
| 2017 | 1 |
| 2019 | 2 |
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\", '02062015'))
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", '02062015')) 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 ERA19LA137Accident · No injuriesClass 3 · LimitedFinal reportPilatus PC12 · Fort Lauderdale, FLImproper maintenance of the windshield, which resulted in delamination and in-flight depressurization.NTSB ERA19LA125Accident · No injuriesClass 3 · LimitedFinal reportPiper PA31 · Leesburg, FLMaintenance personnel’s improper rigging of the main landing gear actuators, which resulted in the collapse of the right main landing gear.NTSB ERA17LA130Accident · No injuriesLimited investigationFinal reportSocata TB20 · Melbourne, FLImproper installation of the circlip within the nose gear strut, which resulted in the strut overextending in the wheel well and preventing the nose landing gear from extending during landing.NTSB ERA17CA068Accident · Minor injuriesData collectionFinal reportBeech A36 · New Smyrna Beach, FLThe pilot's inappropriate response to an emergency exit window opening in flight, which resulted in a loss of control, precautionary off-airport landing, and subsequent impact with trees. Contributing to the accident was the pilot's improper repair of the…NTSB ERA16LA268Accident · No injuriesLimited investigationFinal reportFrank Ware Velocity TXL · Sebastian, FLThe total loss of engine power due to maintenance personnel’s improper setting of the aneroid adjustment.NTSB ERA14FA123Accident · 1 fatalField investigationFinal reportWilliams Christopher T Sonex · Wellington, FLThe pilot's failure to maintain adequate airspeed following a partial loss of engine power during initial climb, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the…NTSB ERA12LA219Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Homestead, FLThe inadequate servicing and maintenance of the engine and the airplane owner and maintenance personnel's disregard of the manufacturer's recommended engine overhaul schedule and service bulletins, which resulted in an in-flight internal failure and seizure…NTSB ERA11LA156Accident · No injuriesLimited investigationFinal reportCessna 172G · Clarksville, FLA loss of engine power due to fuel starvation as a result of the owner's improper maintenance of the fuel selector valve, which resulted in a lack of fuel supply from the right fuel tank.