NTSB investigations, 2025, FL
8 cases where the sequence of events included Nose over/nose down.
Cases per year
| 2008 | 9 |
|---|---|
| 2009 | 4 |
| 2010 | 7 |
| 2011 | 4 |
| 2012 | 6 |
| 2013 | 7 |
| 2014 | 9 |
| 2015 | 6 |
| 2016 | 11 |
| 2017 | 10 |
| 2018 | 9 |
| 2019 | 7 |
| 2020 | 5 |
| 2021 | 5 |
| 2022 | 8 |
| 2023 | 4 |
| 2024 | 3 |
| 2025 | 8 |
| 2026 | 5 |
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 year(c.\"eventDate\") = 2025
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\" = '096' 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") = 2025 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" = '096' 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 ERA25LA345Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172 · Williston, FLOn September 13, 2025, about 0733 eastern daylight time, a Cessna 172G, N345QA, was substantially damaged when it was involved in an accident near Williston, Florida. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB ERA25LA335Accident · No injuriesClass 4 · LimitedFinal reportLafferty Jack SEA REY · Bell, FLThe pilot’s failure to raise the landing gear before landing on the water.NTSB ERA25LA297Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-12 · Ponce Inlet, FLOn August 11, 2024, about 1359 easter daylight time, a Piper PA-12, N2504M, was substantially damaged when it was involved in an accident near Ponce Inlet, Florida. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB ERA25LA180Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8F · Punta Gorda, FLThe pilot’s failure to maintain direction control of the airplane during the landing roll.NTSB ERA25LA159Accident · No injuriesClass 3 · LimitedFinal reportSilvaire Luscombe 8A · New Port Richey, FLMaintenance personnel’s inadequate inspection of the exhaust system, which allowed exhaust gases to enter the induction system from cracks in the exhaust manifold, resulting in a total loss of engine power and a subsequent forced landing.NTSB ERA25LA124Accident · Minor injuriesClass 4 · LimitedFinal reportDecker Daniel B Searey · Tavares, FLThe pilot’s improper flare during a bounced water landing, which resulted in a nose-down and submersion of the airplane’s open cockpit in the water.NTSB ERA25LA109Accident · Serious injuriesClass 4 · LimitedFinal reportNear William J RV-7A · Weirsdale, FLThe pilot’s improper landing flare, which resulted in a hard, bounced landing and subsequent nose over.NTSB ERA25LA098Accident · Minor injuriesClass 3 · LimitedFinal reportMontaer Ltda MC01 · Miramar, FLThe pilot’s delay in recognizing and acting upon the airplane’s reduced takeoff performance.