NTSB investigations, 2001, FL

8 cases where the first occurrence was “On ground/water collision with object”.

Cases per year

19822026
NTSB investigations, 2001, FL per year, 1982–2026: 139 cases
19826
19838
19849
19857
19863
19874
19886
198911
19903
19915
19924
19936
199410
19957
19964
19973
19987
19992
20008
20018
20025
20035
20043
20051
20063
20071

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\") = 2001
    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\" = 310)
  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 MIA02LA024Accident · No injuriesLimited investigationFinal reportCessna 172M · Crystal River, FLthe pilot's failure to keep a proper visual lookout and ensure proper clearance during taxi operations, which resulted in a collision with vehicles.Nov 20, 2001 · N1385U · Substantial damageNTSB MIA02LA012Accident · No injuriesLimited investigationFinal reportCessna 152 · Marco Island, FLthe pilot's failure to maintain directional control during the landing roll, which resulted in the airplane departing the runway, impacting with a windsock, and nosing over in soft terrain.Oct 25, 2001 · N93455 · Substantial damageNTSB ATL02LA007Accident · No injuriesLimited investigationFinal reportNorth American SNJ-6 · Kissimmee, FLSee narrative for ATL02LA007A.Oct 20, 2001 · N453WA · 2 aircraft · Minor damageNTSB MIA01LA228Accident · No injuriesLimited investigationFinal reportCessna 172R · Orlando, FLthe pilot's failure to keep a proper visual lookout and ensure proper clearance during taxi operations, which resulted in a collision with another parked aircraft.Sep 8, 2001 · N859CP · Substantial damageNTSB MIA01LA200Accident · No injuriesLimited investigationFinal reportCessna 182Q · Ocala, FLthe pilot's improper planning/decision and failure to properly judge takeoff distance, and his delayed decision to abort the takeoff, which resulted in the aircraft colliding with a fence at the end of the runway, and incurring substantial damage.Jul 28, 2001 · N78234 · Substantial damageNTSB MIA01LA195Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Orlando, FLthe pilot's improper visual lookout, which resulted in the aircraft colliding with a fence.Jul 26, 2001 · N47839 · Substantial damageNTSB MIA01LA176Accident · No injuriesLimited investigationFinal reportCessna 152 · Tampa, FLThe pilot's failure to maintain a visual look out while taxing an airplane for parking resulting in an on ground collision with a fixed object (Hangar/Building.)Jun 25, 2001 · N152LE · Substantial damageNTSB MIA01LA054Accident · No injuriesLimited investigationFinal reportBeech 200 · Naples, FLThe failure of the pilot to obtain assistance from the FBO in the form of a marshaller and failure of the pilot to maintain clearance resulting in the on-ground collision with the light pole.Jan 2, 2001 · N45CF · Substantial damage