NTSB investigations, 2023, FL

8 cases where the sequence of events included Off-field or emergency landing.

Cases per year

20082026
NTSB investigations, 2023, FL per year, 2008–2026: 335 cases
200812
200928
201019
201122
201225
201322
201422
201521
201621
201717
201818
201919
20208
202116
202216
20238
202420
202518
20263

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\") = 2023
    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\" = '440' 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.

NTSB ERA24LA043Accident · Minor injuriesClass 3 · LimitedFinal reportLancair IV · Perry, FLA rapid throttle advancement after a period of idling, which resulted in a flooded engine and total loss of engine power.Nov 17, 2023 · N37MB · Substantial damageNTSB ERA24LA033Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172S · Orlando, FLA partial loss of engine power during initial climb after takeoff for undetermined reasons.Nov 10, 2023 · N91PF · Substantial damageNTSB ERA24LA022Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20E · Pembroke Pines, FLThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel contamination.Oct 26, 2023 · N1953Y · Substantial damageNTSB ERA23LA388Accident · No injuriesClass 3 · LimitedFinal reportRemos GX · Fort Pierce, FLThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power during cruise flight due to fuel exhaustion.Sep 6, 2023 · N81GX · Substantial damageNTSB ERA23LA337Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA32 · Haines City, FLA total loss of engine power due to fuel starvation for reasons that could not be determined.Aug 12, 2023 · N898CP · Substantial damageNTSB ERA23LA324Accident · Serious injuriesClass 3 · LimitedFinal reportJamros Robert L JR Challenger II · Port Orange, FLThe total loss of engine power due to an out-of-temperature seizure of the PTO cylinder.Aug 4, 2023 · N906WV · Substantial damageNTSB ERA23LA197Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 177RG · Crestview, FLThe total loss of engine power due to the loosening and separation of the No. 1 connecting rod cap nuts in flight, resulting in catastrophic internal engine damage. Contributing to the accident was the pilot/owner’s failure to comply with the engine…Apr 14, 2023 · N7542V · Substantial damageNTSB ERA23LA151Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 35-B33 · Scottsmoor, FLThe pilot’s inadequate preflight fuel planning, which resulted in fuel exhaustion.Mar 14, 2023 · N5714K · Substantial damage