NTSB investigations, FL
4 cases where NTSB found Nose/tail gear attach section.
Cases per year
| 2009 | 1 |
|---|---|
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 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\", '01023221'))
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", '01023221')) 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 ERA15CA038Accident · No injuriesData collectionFinal reportCessna 172P · Miami, FLThe failure of the student pilot to achieve a proper touchdown during a touch-and-go landing resulting in a hard landing and substantial damage.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 ERA12LA296Accident · No injuriesLimited investigationFinal reportJones SA105 · New Smyrna Beach, FLThe failure of the nose landing gear wooden attachment/support structure, which resulted in collapse of the nose landing gear during taxi. Contributing to the accident was the improper design of the nose landing gear attachment structure.NTSB ERA09LA471Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Sanford, FLThe fatigue cracking at the point the nose landing gear actuator attaches to the mount resulting in separation of the actuator and partial collapse of the nose landing gear. Contributing to the accident was the lack of specific inspection guidance for…