Ongoing NTSB investigations, FL
13 cases where the sequence of events included Collision with terr/obj (non-CFIT).
Cases per year
| 2024 | 2 |
|---|---|
| 2025 | 3 |
| 2026 | 8 |
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 c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
AND c.\"completionStatus\" = 'Ongoing'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '470' 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 c."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA' AND c."completionStatus" = 'Ongoing' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '470' 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 ERA27LA003Accident · No injuriesClass 4 · LimitedInvestigation openHawker Siddeley HS.125 Series 700A · Fort Lauderdale, FLNTSB ERA26FA326Accident · 2 fatalClass 3 · FieldPreliminary reportMaclura Evolution · Tampa, FLOn September 3, 2026, about 0815 eastern daylight time, an experimental, amateur-built Evolution airplane, N305PV, was destroyed when it was involved in an accident near Tampa, Florida. The commercial pilot and passenger were fatally injured. The airplane was…NTSB ERA26FA230Accident · Serious injuriesClass 3 · FieldPreliminary reportCessna 150 · Kissimmee, FLOn June 6, 2026, about 1458 eastern daylight time, a Cessna 150L, N156KA, was substantially damaged when it was involved in an accident near Kissimmee Gateway Airport (ISM), Kissimmee, Florida. The commercial pilot and student pilot were seriously injured.…NTSB ERA26LA186Accident · No injuriesClass 4 · LimitedInvestigation openCessna 172M · Crystal River, FLNTSB ERA26FA179Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 401B · Land O' Lakes, FLOn April 19, 2026, about 0834 eastern daylight time, a Cessna 401B, N122AT, was destroyed when it was involved in an accident near Land O’ Lakes, Florida. The commercial pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB ERA26FA166Accident · 2 fatalClass 3 · FieldInvestigation openNorth American AT-6D · Bronson, FLNTSB ERA26LA153Accident · Minor injuriesClass 3 · LimitedPreliminary reportTextron T206H · Fort Myers, FLOn March 21, 2026, about 0905 eastern daylight time, a Cessna T206H, N2469H, was substantially damaged when it was involved in an accident near Fort Myers, Florida. The pilot and four passengers sustained minor injuries. The airplane was operated as a Title…NTSB ERA26FA110Accident · Serious injuriesClass 3 · FieldPreliminary reportPipistrel Taurus 503 · Boynton Beach, FLOn February 9, 2026, about 1514 eastern standard time, a Pipistrel Taurus 503 motorglider, N414HG, was substantially damaged when it was involved in an accident at Willis Gliderport (FA44), Boynton Beach, Florida. The pilot was seriously injured. The…NTSB ERA26LA046Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 172 · Palm Bay, FLOn November 17, 2025, about 1900 eastern standard time, a Cessna 172N, N6124D, was substantially damaged when it was involved in an accident near Palm Bay, Florida. The private pilot sustained minor injuries. The airplane was operated as a Title 14 Code of…NTSB ERA25LA167Accident · Serious injuriesClass 3 · LimitedPreliminary reportHiller UH12E · Rockledge, FLOn April 6, 2025, about 1020 eastern daylight time, a Hiller UH-12E, N48263, was substantially damaged when it was involved in an accident near Rockledge, Florida. The private pilot and passenger sustained serious injuries. The helicopter was operated as a…NTSB ERA25LA088Accident · No injuriesClass 3 · LimitedPreliminary reportBeech A36 · Naples, FLOn January 1, 2025, at 0120 eastern standard time, a Beech A36, N8163F, was substantially damaged when it was involved in an accident at Naples Municipal Airport (APF), Naples, Florida. The private pilot and three passengers were not injured. The flight was…NTSB ERA25FA066Accident · 1 fatalClass 3 · FieldPreliminary reportSchleicher ASW24 · Vero Beach, FLOn December 6, 2024, about 1240 eastern standard time, a Schleicher ASW 24 glider, N244RW, was substantially damaged when it was involved in an accident near Vero Beach, Florida. The pilot was fatally injured. The glider was owned by a local soaring club and…NTSB ERA25FA001Accident · 1 fatalClass 3 · FieldPreliminary reportBeech 95 · Crystal River, FLOn October 1, 2024, about 1540 eastern daylight time, a Beech 95-B55, N5868S, was destroyed when it collided with terrain near Crystal River, Florida. The private pilot was fatally injured. The personal flight was conducted under the provisions of Title 14…