NTSB investigations, 2002, FL

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

Cases per year

19822026
NTSB investigations, 2002, 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\") = 2002
    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 ATL03LA028Accident · No injuriesLimited investigationFinal reportCessna 172F · Stuart, FLThe pilot's inflight encounter with wind shear on final approach, which resulted in an inflight loss of control and subequent uncontrolled descent into trees.Dec 31, 2002 · N5338R · Substantial damageNTSB ATL03LA014Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-82 · Orlando, FLThe airplane's inflight encounter with turbulence that resulted in injuries to the number two flight attendant.Nov 6, 2002 · N479AA · No damageNTSB MIA02FA173Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Yeehaw Junction, FLthe pilot's continued flight into known severe weather, resulting in an in-flight separation of the right wing, vertical stabilizer and the stabilator. Factors in this accident were heavy thunderstorm, and failure of the FAA controllers to provide the pilot…Sep 24, 2002 · N106JG · DestroyedNTSB ATL02FA162Accident · 2 fatalField investigationFinal reportAmerican General AA-5B · Zephyrhills, FLThe pilots continued visual flight into instrument conditions (fog), and subsequent collision with a tree and a residence.Sep 1, 2002 · N81189 · DestroyedNTSB MIA02FA111Accident · 3 fatalField investigationFinal reportPiper PA-46-310P · Osteen, FLthe pilot's inadequate weather evaluation and his failure to maintain control of the airplane after entering an area of thunderstorms resulting in an in-flight separation of the right wing and right horizontal stabilizer and impact with the ground during an…Jun 15, 2002 · N9143B · DestroyedNTSB ATL02FA051Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Vero Beach, FLThe flight's encounter with isolated severe to extreme turbulence that resulted in an in-flight breakup of the airplane and subsequent impact with terrain.Feb 23, 2002 · N7345W · DestroyedNTSB MIA02LA061Accident · Serious injuriesLimited investigationFinal reportSmith, Ted Aerostar 601P · Belle Glade, FLthe pilot continued flight into known adverse weather resulting in a loss of control and subsequent impact with the ground.Feb 16, 2002 · N715RM · Substantial damageNTSB ATL02FA048Accident · 2 fatalField investigationFinal reportBell 206L-1 · New Smyrna Bch., FLThe pilot continued visual flight into instrument conditions that resulted in the in-flight collision with trees. Factor were the pilot's alcohol impaired condition, and low cloud conditions.Feb 16, 2002 · N23PJ · Destroyed