NTSB investigations, 2013, FL
8 cases where the sequence of events included Landing gear collapse.
Cases per year
| 2008 | 6 |
|---|---|
| 2009 | 6 |
| 2010 | 6 |
| 2011 | 5 |
| 2012 | 7 |
| 2013 | 8 |
| 2014 | 6 |
| 2015 | 8 |
| 2016 | 8 |
| 2017 | 7 |
| 2018 | 11 |
| 2019 | 10 |
| 2020 | 8 |
| 2021 | 9 |
| 2022 | 2 |
| 2023 | 7 |
| 2024 | 8 |
| 2025 | 8 |
| 2026 | 5 |
Where
Open the mapLatest 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 year(c.\"eventDate\") = 2013
AND c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '094' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 year(c."eventDate") = 2013 AND c."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '094' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 ERA14CA023Accident · No injuriesData collectionFinal reportCessna 182Q · Wauchula, FLThe pilot's improper landing flare which resulted in a hard landing.NTSB ERA14IA019Incident · No injuriesIncident investigationFinal reportPiper PA 46 350P · Tallahassee, FLThe failure of the nose landing gear (NLG) actuator attachment bolt due to fatigue for reasons that could not be determined during postincident examination, which resulted in the NLG collapsing during landing.NTSB ERA13LA398Accident · No injuriesLimited investigationFinal reportCessna 210J · Fort Myers, FLThe failure of the landing gear hydraulic power pack system to provide sufficient pressure to lock the main landing gear in the down position. Contributing to the accident was the improper maintenance and inspection of the landing gear system, the pilot’s…NTSB ERA13CA399Accident · No injuriesData collectionFinal reportBreezer 912ULS2 · Lakeland, FLThe student pilot’s improper recovery from a bounced landing, which resulted in the collapse of the nose landing gear.NTSB ERA13CA395Accident · No injuriesData collectionFinal reportCessna 172S · Fort Lauderdale, FLThe student pilot’s failure to apply power to go-around following a bounced landing resulting in abnormal runway contact and collapse of the nose landing gear.NTSB ERA13LA239Accident · No injuriesLimited investigationFinal reportCessna 182G · Clewiston, FLThe private pilot’s inadequate preflight planning and fuel management and the flight instructor’s inadequate supervision, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA13LA220Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Daytona Beach, FLA total loss of engine power during initial climb for reasons that could not be determined because postaccident examinations did not reveal any preimpact failures or malfunctions that would have precluded normal operation.NTSB ERA13LA188Accident · No injuriesLimited investigationFinal reportCessna 402C · Fort Lauderdale, FLThe disconnection of the nose landing gear actuator, which resulted in the subsequent collapse of the nose landing gear. Contributing to the accident was the repair station’s inadequate maintenance, postmaintenance inspection process, and oversight of the…