NTSB investigations, 2002, FL

11 cases where the first occurrence was “In flight collision with object”.

Cases per year

19822026
NTSB investigations, 2002, FL per year, 1982–2026: 220 cases
198212
198311
19848
198518
198611
19879
198812
198911
19908
19919
19925
199310
19945
19955
19965
19977
19988
199910
200015
20011
200211
20039
20043
20055
20064
20078

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\" = 220)
  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 MIA02LA164Accident · Minor injuriesLimited investigationFinal reportClarence F. Callahan Challenger II · Plymouth, FLThe pilot's failure to maintain the proper alignment which resulted in the airplane impacting trees on the south side of the approach end of the landing runway.Sep 1, 2002 · N521CF · Substantial damageNTSB MIA02FA161Accident · Serious injuriesField investigationFinal reportSikorsky S76A+ · Miami, FLThe flight crew's diverted attention, inadequate visual lookout, and failure to ensure adequate main rotor clearance. Factors in the accident were the continued operation, with known obstructions in the area, and the failure of the FAA to initially certify…Aug 31, 2002 · N15460 · Substantial damageNTSB DCA02MA054Accident · Serious injuriesClass 1 · MajorFinal reportBoeing 727-232 · Tallahassee, FLThe captain's and first officer's failure to establish and maintain a proper glidepath during the night visual approach to landing. Contributing to the accident was a combination of the captain's and first officer's fatigue, the captain's and first officer's…Jul 26, 2002 · N497FE · DestroyedNTSB ATL02LA128Accident · Minor injuriesLimited investigationFinal reportBell 47G-2A · La Belle, FLThe pilot's failure to maintain visual lookout while maneuvering during an aerial application, which resulted in an in-flight collision with power lines and uncontrolled descent into terrain.Jun 24, 2002 · N8486E · Substantial damageNTSB MIA02LA105Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Ormond Beach, FLThe flight instructor's inadequate supervision of the dual student and failure to take prompt remedial action, resulting in a collision with a tree, a subsequent loss of control, and collision with the ground.Jun 4, 2002 · N63591 · Substantial damageNTSB MIA02FA106Accident · Minor injuriesField investigationFinal reportHelicopters & Exec 162F · Tampa, FLThe pilot's intentional operation of the helicopter while impaired by alcohol and a drug (zolpidem) resulting in the in-flight collision with a house.Jun 4, 2002 · N268MA · Substantial damageNTSB MIA02FA104Accident · 1 fatalField investigationFinal reportCessna 172S · Lutz, FLThe suicidal act by the pilot resulting in the in-flight collision with trees then the ground. A contributing factor in the accident was the pilot's depression. Findings in the investigation were the pilot's overdose of zolpidem and citalopram before the…Jun 4, 2002 · N942SP · DestroyedNTSB ATL02LA094Accident · No injuriesLimited investigationFinal reportBell 47G-5A · La Belle, FLThe pilot's failure to maintain clearance of a tree while maneuvering, which resulted in an in-flight collision with the tree and subsequent uncontrolled descent and collision with terrain.Apr 26, 2002 · N14838 · Substantial damageNTSB MIA02LA085Accident · 1 fatalLimited investigationFinal reportGrote Cruiser TR-4 · Pembroke Pines, FLthe pilot-in-command delayed initiating a go-around and failed to obtain sufficient altitude to clear obstacles at the departure end of the airport which resulted in an in-flight collision with power lines.Apr 18, 2002 · N98WG · DestroyedNTSB MIA02LA058Accident · 1 fatalLimited investigationFinal reportHarleman Tornado II · Molino, FLThe pilot's failure to maintain obstacle clearance, resulting in the in-flight collision with a static wire and an uncontrolled descent and collision with the ground. A factor in the accident was the pilot's impairment resulting from the use of unapproved…Feb 1, 2002 · N140V · Substantial damageNTSB ATL02FA032Accident · 1 fatalField investigationFinal reportCessna 172R · Tampa, FLThe pilot's unauthorized use of an aircraft for the purpose of commiting suicide.Jan 5, 2002 · N2371N · Destroyed