# NTSB investigations, FL: Prior to flight

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB ERA25LA199](https://openairdocs.org/ntsb/ERA25LA199.md): Cessna 182A · Ocala, FL · Accident · Serious injuries · Class 4 · Limited · Final report · May 8, 2025 · N174A · Substantial damage
  > The pilot’s decision to depart on the flight with known electrical issues and his subsequent loss of situational awareness (geographic position), which resulted in his eventual decision to perform an off-airport landing.
- [NTSB ERA24LA250](https://openairdocs.org/ntsb/ERA24LA250.md): Piper PA28R · Vero Beach, FL · Accident · No injuries · Class 4 · Limited · Final report · Jun 7, 2024 · N287ND · Substantial damage
  > Excessive side loading of the vertical stabilizer.
- [NTSB GAA20CA025](https://openairdocs.org/ntsb/GAA20CA025.md): Cessna 172 · Key West, FL · Accident · Serious injuries · Data collection · Final report · Oct 13, 2019 · N5522S · No damage
  > The pilot’s and the passenger's improper decision to have the passenger attempt to move a wheel chock while the propeller was turning, which resulted in a serious injury.
- [NTSB ERA20TA005](https://openairdocs.org/ntsb/ERA20TA005.md): Silverlight AR-1 · Fort Meade, FL · Accident · No injuries · Class 3 · Final report · Oct 3, 2019 · N463JW · Substantial damage
  > The student pilot’s inadequate preflight inspection that failed to detect water contamination of the fuel and resulted in a total loss of engine power during cruise flight.
- [NTSB GAA16CA162](https://openairdocs.org/ntsb/GAA16CA162.md): Piper PA24 · Homestead, FL · Accident · No injuries · Data collection · Final report · Mar 26, 2016 · N55UA · Substantial damage
  > The pilots decision to hand prop the airplane's engine without securing the airplane, resulting a runaway airplane and collision with a fence.
- [NTSB GAA15CA008](https://openairdocs.org/ntsb/GAA15CA008.md): Cessna 170A · Palmetto, FL · Accident · No injuries · Data collection · Final report · Mar 12, 2015 · N170TW · Substantial damage
  > The pilot's failure to use the proper hand propping procedures, resulting in a runaway airplane.
- [NTSB ERA14CA397](https://openairdocs.org/ntsb/ERA14CA397.md): Raytheon G36 · Milton, FL · Accident · Minor injuries · Data collection · Final report · Aug 20, 2014 · N636TM · Substantial damage
  > The pilot's inadequate preflight planning, which resulted in an attempted takeoff over the airplane's maximum gross weight and beyond its aft center of gravity limit. Contributing to the accident was the pilot's lack of total flight experience in the aircraft…
- [NTSB ERA14FA343](https://openairdocs.org/ntsb/ERA14FA343.md): Piper PA-32R-301T · North Captiva Island, FL · Accident · 1 fatal · Field investigation · Final report · Jul 16, 2014 · N297AS · Substantial damage
  > The pilot’s failure to secure the cargo in the cargo compartment, which resulted in a weight shift that led to the center of gravity exceeding its aft limit during a go-around attempt and a subsequent aerodynamic stall. Also causal to the accident were the…
- [NTSB DCA13LA039](https://openairdocs.org/ntsb/DCA13LA039.md): Boeing 777 - 300 · Miami, FL · Accident · No injuries · Limited investigation · Final report · Jan 17, 2013 · F-GZNI · 2 aircraft · Substantial damage
  > LV-BMT flight crew's incorrect evaluation of the clearance between the two aircraft, leading to the inadvertent collision of the left winglet with the horizontal stabilizer and elevator of F-GNZI. Contributing to the accident were the incorrect instructions…

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
  crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
  current_codes AS (
    SELECT e.case_mkey, TRY_CAST(e."tier1Number" AS INTEGER) AS code,
      row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e."isDefiningEvent", false) DESC, e.position) AS n
    FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
    WHERE e.aircrafts_position = 1 AND e."tier1Number" GLOB '[1-9][0-9]*'
      AND (e."isDefiningEvent" OR e.case_mkey IN (SELECT "mKey" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE "isPre1982"))
  ),
  phases AS (
    SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
    FROM current_codes WHERE n = 1
    UNION ALL
    SELECT o.case_mkey, 'older', o."phaseOfFlightCode", w.main
    FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o."phaseOfFlightCode"
    WHERE o.aircrafts_position = 1 AND o."occurrenceNumber" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
  ),
  case_phases AS (
    SELECT p.*, c."eventDate", c."highestInjuryLevel" = 'Fatal' AS fatal, a.aircraft_model_code
    FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = p.case_mkey
    LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
    WHERE c."eventDate" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
  )
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 case_mkey FROM case_phases WHERE main = 100)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/100/cases?state=FL

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.