NTSB investigations, 2003, FL

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

Cases per year

19822026
NTSB investigations, 2003, 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\") = 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\" = 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 ATL04FA046Accident · 1 fatalField investigationFinal reportAeronca 11AC · San Antonio, FLThe pilot's failure to maintain clearance above objects on approach, which resulted in an in-flight collision with trees and the subsequent collision with terrain.Dec 5, 2003 · N9085F · Substantial damageNTSB MIA04FA029Accident · 1 fatalField investigationFinal reportSwearingen SA-26-AT · Jacksonville, FLThe pilot's descent below decision height while performing an ILS approach with low ceilings and fog, resulting in an in-flight collision with trees and the ground. A factor associated with the accident was the pilot's decision to attempt the instrument…Nov 27, 2003 · N698X · Substantial damageNTSB MIA04CA010Accident · Minor injuriesData collectionFinal reportCessna 152 · Pierson, FLIn flight collision with a bird, resulting in airplane not being able to maintain altitude and nosing over during a forced landing on unsuitable terrain.Oct 22, 2003 · N94445 · Substantial damageNTSB MIA04FA008Accident · 2 fatalField investigationFinal reportBell 47G-2A-1 · Balm, FLThe pilot's intentional buzzing and his failure to maintain altitude/clearance which resulted in an in-flight collision with a building.Oct 21, 2003 · N73979 · DestroyedNTSB MIA03LA146Accident · 1 fatalLimited investigationFinal reportSonerai Sonerai IIB · Lakeland, FLThe pilot's decision to conduct low level flight and his failure to maintain obstacle clearance.Jul 20, 2003 · N224RB · DestroyedNTSB MIA03LA115Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Brooksville, FLThe in-flight collision with a Black Vulture resulting in substantial damage.May 11, 2003 · N7KH · Substantial damageNTSB MIA03LA094Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT- 401 · Fellsmere, FLThe poor in-flight planning by the pilot-in-command for his overhsooting the pull-up following a spray pass resulting in the in-flight collision with trees then terrain. Contributing to the accident was sunglare that the pilot encountered during the spray…Apr 8, 2003 · N4549N · DestroyedNTSB MIA03FA066Accident · 1 fatalField investigationFinal reportCessna 172P · Osteen, FLThe intentional suicidal act by the pilot-in-command resulting in the in-flight collision with trees then the ground.Feb 25, 2003 · N97890 · DestroyedNTSB MIA03LA045Accident · 1 fatalLimited investigationFinal reportBornhofen Twinjet 1500 · Melbourne, FLthe pilot-in-command failed to obtain sufficient altitude to clear obstacles at the approach end of the airport which resulted in an in-flight collision with trees.Jan 24, 2003 · N750TJ · Destroyed