NTSB investigations, 2003, FL

8 cases where the first occurrence was “In flight encounter with weather”.

Cases per year

19822026
NTSB investigations, 2003, FL per year, 1982–2026: 180 cases
19826
19839
19848
19857
19864
19879
19888
19897
19906
199114
199213
19936
19945
19959
19963
19979
19986
19995
20003
20013
20028
20038
20047
20059
20066
20072

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\") = 2003
    AND c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 240)
  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 CHI04FA043Accident · 2 fatalField investigationFinal reportPiper PA46-500TP · Daytona Beach, FLThe unqualified pilot's continued flight into known instrument meteorological conditions which resulted in spatial disorientation and subsequent loss of aircraft control. Factors were the pilot's lack of instrument flight experience and the low ceiling.Dec 17, 2003 · N155BM · DestroyedNTSB ATL04LA055Accident · Minor injuriesLimited investigationFinal reportMBB BK117A3 · Okeechobee, FLThe pilot continued visual flight into instrument meteorological conditions and experienced spatial disorientation, loss of aircraft control, and in-flight collision with trees and terrain. Factors in the accident were the pilot's failure to follow company…Dec 17, 2003 · N911WJ · Substantial damageNTSB MIA03LA127Accident · Serious injuriesLimited investigationFinal reportEmbraer EMB-145LR · Taylor, FLThe in-flight encounter with turbulence during normal descent resulting in a serious injury to a passenger. A finding in the investigation was the seatbelt sign had been on for approximately 2 minutes at the time of the turbulence encounter.Jun 18, 2003 · N294SK · No damageNTSB MIA03CA074Accident · No injuriesData collectionFinal reportSchempp-Hirth DISCUS-2B · Clermont, FLAn in-flight encounter with wind gusts while making an approach to land in a field resulting in the aircraft landing early and colliding with a berm.Mar 10, 2003 · N828JN · Substantial damageNTSB MIA03FA071Accident · 2 fatalField investigationFinal reportPiper PA-28R-201T · Cedar Key, FLThe pilot's inadequate in-flight planning/decision by his continued VFR flight into instrument meteorological condition after receiving an in-flight weather advisory. Also causal was his failure to maintain aircraft control, which resulted in flight that…Mar 4, 2003 · N6369C · DestroyedNTSB MIA03FA068Accident · 1 fatalField investigationFinal reportBeech 36 · Captiva Island, FLThe pilot's VFR flight into instrument meteorological conditions and his ensuing failure to maintain altitude/clearance resulting in an in-flight collision with the ocean. A factor was the fog.Feb 28, 2003 · N41VK · DestroyedNTSB MIA03LA067Accident · Serious injuriesLimited investigationFinal reportBoeing 777-223 · Miami, FLThe flight crew's inadvertent encounter with turbulence while attempting to maneuver through an area of convective activity during descent.Feb 25, 2003 · N790AN · No damageNTSB MIA03LA061Accident · 4 fatalLimited investigationFinal reportPiper PA-23-250 · Miami, FLThe non instrument-rated pilot-in-command's improper inflight planning/decision, and continued VFR flight into instrument meteorological conditions, which resulted in a loss of control during descent, and impact with water.Feb 17, 2003 · N54835 · Destroyed