NTSB investigations, FL

8 cases where NTSB found Aircraft.

Cases per year

20082026
NTSB investigations, FL per year, 2008–2026: 8 cases
20081
20152
20161
20181
20192
20231

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\", '03022040'))
  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.

NTSB ERA23LA116Accident · No injuriesClass 4 · LimitedFinal reportMesafox Kitfox · Orlando, FLAn inadvertent encounter with the jet blast of another airplane while taxiing, which resulted in substantial damage to the airplane’s left wing.Jan 19, 2023 · N915KF · Substantial damageNTSB GAA19CA498Accident · No injuriesData collectionFinal reportCessna 172 · Daytona Beach, FLThe pilot entering the taxiway's failure to see and avoid the airplane established on the taxiwayAug 18, 2019 · N408ER · 2 aircraft · Substantial damageNTSB GAA19CA190Accident · No injuriesData collectionFinal reportCessna 172 · Hollywood, FLThe other pilot's failure to maintain adequate clearance from the stopped airplane while attempting to taxi around it.Mar 21, 2019 · N20521 · 2 aircraft · Minor damageNTSB GAA19CA071Accident · No injuriesData collectionFinal reportPiper PA28 · Miami, FLThe other pilot's improper decision to taxi past another airplane occupying a taxiway and her subsequent failure to maintain clearance from the airplane.Nov 20, 2018 · N607FT · 2 aircraft · Substantial damageNTSB GAA17CA097Accident · No injuriesData collectionFinal reportCessna 195 · Jacksonville, FLThe other pilot’s failure to see and avoid the stationary airplane during taxi.Dec 11, 2016 · N195PC · 2 aircraft · Substantial damageNTSB GAA15CA064Accident · No injuriesData collectionFinal reportCessna 172S · Daytona Beach, FLThe landing airplane pilot's failure to maintain directional control during landing, which resulted in a runway excursion and ground collision with a taxiing airplane.May 7, 2015 · N5144H · 2 aircraft · Substantial damageNTSB GAA15CA008Accident · No injuriesData collectionFinal reportCessna 170A · Palmetto, FLThe pilot's failure to use the proper hand propping procedures, resulting in a runaway airplane.Mar 12, 2015 · N170TW · Substantial damageNTSB MIA08CA074Accident · No injuriesData collectionFinal reportCessna 525B · Stuart, FLThe flight crew's failure to reset the brakes circuit breaker resulting in a loss of brakes during taxi and an on ground collision with an unoccupied parked airplane.Mar 8, 2008 · N400GG · Substantial damage