Ongoing NTSB investigations, FL

8 cases where the sequence of events included Loss of control in flight.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20252026

Ongoing NTSB investigations, FL per year, 2025–2026: 8 cases
2025	3
2026	5

Where

Open the map

Latest cases

Query with SQL

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" = '240' 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

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\" = '240' 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" = '240' 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 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…Sep 3, 2026 · N305PV · Destroyed 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.…Jun 6, 2026 · N156KA · Substantial damage NTSB ERA26FA166Accident · 2 fatalClass 3 · FieldInvestigation openNorth American AT-6D · Bronson, FLApr 13, 2026 · N29678 · Destroyed NTSB ERA26LA159Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172M · Lakeland, FLOn April 05, 2026, at 0007 eastern daylight time, a Cessna 172M airplane, N61972, was substantially damaged when it was involved in an accident near Lakeland, Florida. The pilot and certified flight instructor (CFI) rated passenger were uninjured. The…Apr 5, 2026 · N61972 · Substantial damage NTSB 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…Mar 21, 2026 · N2469H · Substantial damage NTSB WPR26FA040Accident · 2 fatalClass 3 · FieldPreliminary reportBeech B100 · Coral Springs, FLOn November 10, 2025, about 1019 eastern standard time, a Beech King Air B100, N30HG, was destroyed when it was involved in an accident near Coral Springs, Florida. The pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code of…Nov 10, 2025 · N30HG · Destroyed NTSB ERA25FA173Accident · 3 fatalClass 3 · FieldPreliminary reportCessna 310R · Boca Raton, FLOn April 11, 2025, at 1023 eastern daylight time, a Cessna 310R, N8930N, was destroyed when it was involved in an accident near Boca Raton, Florida. The two pilots and the passenger were fatally injured, and one person on the ground sustained minor injuries.…Apr 11, 2025 · N8930N · Destroyed NTSB ERA25FA154Accident · 1 fatalClass 3 · FieldPreliminary reportAero SP Z O O AT-4 LSA · Zellwood, FLOn March 22, 2025, about 0925 eastern daylight time, a Aero SP Z O O AT-4 LSA, N8548U, was substantially damaged when it was involved in an accident near Zellwood, Florida. The private pilot was fatally injured. The airplane was operated as a Title 14 Code of…Mar 22, 2025 · N8548U · Substantial damage