NTSB investigations, FL

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

Cases, newest first

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 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 MIA96LA025Accident · No injuriesLimited investigationFinal reportCessna 150L · Lantana, FLThe failure of the pilot-in-command to use the checklist and to set the parking brakes prior to engine start.Nov 19, 1995 · N18201 · Substantial damageNTSB MIA95LA218Accident · No injuriesLimited investigationFinal reportBoeing 737-4Q8 · Miami, FLImproper planning/decision by the company driver of the vehicle (paymover) and uncommanded movement of the paymover for undetermined reasons.Sep 6, 1995 · N405KW · Substantial damageNTSB ATL95LA163Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Kissimmee, FLThe inadequate visual lookout by the driver of the vehicle. A factor in the accident was the inoperative anti-collision lights of the aircraft.Aug 27, 1995 · N100TL · Substantial damageNTSB MIA95LA196Accident · No injuriesLimited investigationFinal reportBoeing 727-264 · Orlando, FLThe failure of the ground crew to follow procedures/directives requiring that the airplane brakes be set before disconnecting the tow bar from the airplane.Aug 6, 1995 · N764AT · Substantial damageNTSB MIA95LA137Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Homestead, FLBinding (mechanical) of the right elevator with the right horizontal stabilizer after collision with a dog at the right horizontal stabilizer during rotation. The deformation of the stabilizer reduced the pilot-in-commmand's ability to operate the elevator.May 27, 1995 · N6167Y · Substantial damageNTSB MIA95LA135Accident · No injuriesLimited investigationFinal reportBoeing 727-232 · West Palm Beach, FLThe failure of the ground pushback crew to follow delta airlines pushback procedures and place a signalman forward of the aircraft in view of the captain during pushback. This resulted in the captain not being aware that the tug tow bar had disconnected and…May 24, 1995 · N489DA · Substantial damageNTSB MIA95LA076Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Miami, FLThe failure of the truck driver to follow airport operations procedures and signs.Feb 11, 1995 · N8778Y · Substantial damageNTSB MIA95GA033Accident · No injuriesFinal reportSikorsky UH-60A · St. Petersburg, FLThe pilot-in-command's failure to maintain separation while ground taxiing between two hangers, resulting in the main rotor blades colliding with a hanger. Contributing to the accident was the lack of written procedures pertaining to ground marshalling of…Dec 3, 1994 · N23321 · Substantial damageNTSB MIA95LA035Accident · No injuriesLimited investigationFinal reportCessna 172M · Crystal River, FLThe pilot in command's failure to maintain visual outlook during taxiing.Nov 23, 1994 · N1385U · Substantial damageNTSB MIA95LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Indiantown, FLAn evasive maneuver to avoid collision with animals.Nov 22, 1994 · N67390 · Substantial damageNTSB MIA95LA026Accident · Serious injuriesLimited investigationFinal reportBoeing 727-100 · Miami, FLThe failure of the truck driver to maintain visual lookout while operating his truck on an unlit ramp near an aircraft.Nov 22, 1994 · HCBRF · Substantial damageNTSB MIA94LA202Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-12-D · Punta Gorda, FLThe failure of the pilot-in-command to tiedown the airplane prior to attempting an engine start by hand propping. Contributing to the accident was the pilot's complacency.Aug 30, 1994 · N39283 · Substantial damageNTSB MIA94LA184Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Naples, FLFailure of the pilot-in-command to maintain wingtip clearance while taxiing resulting in the on-ground collision with a light pole.Jul 25, 1994 · N9236L · Substantial damageNTSB MIA94LA166Accident · No injuriesLimited investigationFinal reportBritish Aerospace BAE 3201 · Orlando, FLInadvertent deactivation of the parking brake by the pilot-in-command. Contributing to the accident was the worn condition of the parking brake assembly.Jun 24, 1994 · N495UE · Substantial damageNTSB MIA94LA138Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Belleair, FLImproper maintenance inspection of the crankcase breather tube resulting in failure to detect blockage of the tube.May 13, 1994 · N114WW · Substantial damageNTSB MIA94LA068Accident · No injuriesLimited investigationFinal reportCessna 172RG · Orlando, FLThe failure of the student pilot to follow instuctions given by ground control and the failure of both pilots to maintain proper obstruction clearance between aircraft.Feb 6, 1994 · N9346D · 2 aircraft · Substantial damageNTSB MIA94LA065Accident · No injuriesLimited investigationFinal reportOconnell LAZER-200 · St. Petersburg, FLThe failure of the pilot of the conventional gear airplane to maintain a visual lookout for other aircraft.Feb 3, 1994 · N199J · 2 aircraft · Substantial damageNTSB MIA94LA023Accident · No injuriesLimited investigationFinal reportPiper PA-60 · Orlando, FLThe failure of the pilot-in-command of the other aircraft to maintain a visual lookout and clearance between aircraft.Nov 15, 1993 · N91WW · 2 aircraft · Substantial damageNTSB MIA93LA100Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Orlando, FLVisual lookout not maintained by the pilot-in-command while taxiing the airplane. Contributing to the accident was the failure of the driver of the vehicle to advise the ground controller that he had stopped the vehicle on the taxiway.Apr 12, 1993 · N65484 · Substantial damageNTSB MIA93LA091Accident · No injuriesLimited investigationFinal reportBeech V35B · Key Largo, FLThe pilot-in-command's complacency and decision to leave the aircraft controls unattended with the engine operating and without setting the parking brake.Mar 24, 1993 · N18368 · Substantial damageNTSB MIA93LA079Accident · No injuriesLimited investigationFinal reportAeronca KCA · Bunnell, FLImproper procedures by the other pilot for his failure to perform 's' turns while taxiing.Feb 28, 1993 · N1938K · 2 aircraft · Substantial damageNTSB MIA93LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Punta Gorda, FLThe pilot-in-command's failure to maintain a visual lookout while taxiing into the parking area, resulting in an on-ground collision with a light pole.Feb 20, 1993 · N5394M · Substantial damageNTSB MIA93LA053Accident · No injuriesLimited investigationFinal reportCessna 150M · Gainesville, FLPoor in-flight planning decision by the student pilot. Contributing to the accident was his apprehension and lack of total experience in the type of operation.Jan 23, 1993 · N714RG · Substantial damageNTSB MIA92LA168Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Oak Hill, FLFailure of the pilot-in-command to level off during the simulated forced landing.Aug 29, 1992 · N8410R · Substantial damageNTSB MIA92LA145Accident · 1 fatalLimited investigationFinal reportRaven S-60A · Dover, FLThe pilot in commands choice of landing area near electrical lines and his failure to exit the balloon and seek safety when it was determined the deflating bag was going to make contact with power lines resulting in his receiving electrocution injuries.Jul 4, 1992 · N4037Q · Minor damageNTSB MIA92IA077Incident · No injuriesIncident investigationFinal reportBoeing 767-323ER · Miami, FLThe failure of the FAA local controller to asure adequate clearance was established.Feb 9, 1992 · N354AA · 2 aircraft · Minor damageNTSB MIA92LA087Accident · No injuriesLimited investigationFinal reportCessna 152 · Perry, FLFailure of the pilot to maintain clearance while taxiing.Feb 8, 1992 · N46021 · Substantial damageNTSB MIA92LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Daytona Beach, FLThe failure of the pilot in command of N136AT to maintain clearance from N3110R while diverting her attention to close her door during taxi to takeoff.Oct 24, 1991 · N136AT · 2 aircraft · Substantial damageNTSB MIA91FA208Accident · Serious injuriesField investigationFinal reportPiper PA28-151 · Miami, FLThe failure of the airport agent to exercise caution while driving in reduced visibility due to rain resulting in the collision between the agent's truck and the aircraft she was searching for which had stopped on the taxiway to await assistance. Contributing…Aug 29, 1991 · N41306 · Substantial damageNTSB MIA91LA153Accident · No injuriesLimited investigationFinal reportCessna 210N · Fernandina Bch, FLFailure of the pilot to obtain proper assistance while taxiing the airplane near a parked airplane.May 26, 1991 · N6555Y · Substantial damageNTSB MIA91LA131Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Vero Beach, FLFailure of the PA-28 pilot to maintain proper brake pressure, while diverting his attention to his notepad.Apr 30, 1991 · N150ER · 2 aircraft · Minor damageNTSB MIA91LA067Accident · No injuriesLimited investigationFinal reportCessna 172N · New Smyrna Bch, FLFailure of the CFI to maintain clearance between the right wing tip and a telephone pole.Jan 16, 1991 · N215ER · Substantial damageNTSB MIA90LA161Accident · Minor injuriesLimited investigationFinal reportBeech 36 · Ellenton, FLThe improper takeoff procedure by the pilot.Jul 26, 1990 · N7546N · Substantial damageNTSB MIA90LA122Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Daytona Beach, FLThe failure of the pilot of the tailwheel equipped airplane to maintain a visual lookout while taxiing.May 15, 1990 · N50072 · 2 aircraft · Minor damageNTSB MIA90FA105Accident · No injuriesField investigationFinal reportEmbraer EMB-110 · Fort Lauderdale, FLThe pilot in command's failure to maintain an adequate visual look-out due to his self imposed pressure of taxiing, completing cockpit checklists and obtaining a clearance at the same time.Apr 16, 1990 · N64CZ · Substantial damageNTSB MIA90IA036Incident · No injuriesIncident investigationFinal reportWaco UPF-7 · Key West, FLThe failure of the pilot to adequately watch for parked aircraft after becoming distracted.Nov 26, 1989 · N32133 · No damageNTSB MIA90LA009Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Tampa, FLAn animal (cow) that had wandered onto the arpt.Oct 9, 1989 · N8149J · Substantial damageNTSB MIA89LA256Accident · Serious injuriesLimited investigationFinal reportCooley LONG-EZ · Green Cove Spgs, FLImproper planning/decision by the pilot, which resulted in his failure (or inability) to align the acft with the runway during the landing. The low ceiling, tailwind, and ditch were related factors.Sep 24, 1989 · N711KD · DestroyedNTSB MIA89LA246Accident · No injuriesLimited investigationFinal reportCessna 150G · Marathon, FLThe pilot's misjudgement of clearance between his aircraft and the parked aircraft. Factors related to the accident were: sunglare and the location of the parked aircraft.Sep 12, 1989 · N3220J · Substantial damageNTSB MIA89LA245Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Key West, FLInadequate visual lookout by the Waco pilot, which resulted in his misjudgement of clearance between his aircraft and the Cessna 172 and a subsequent collision.Sep 10, 1989 · N32133 · 2 aircraft · Minor damageNTSB MIA89LA234Accident · No injuriesLimited investigationFinal reportCessna 172N · Jacksonville, FLInadequate visual lookout by the pilot. Factors related to the accident were: dark night, light pole with an inoperative light, and the lack of visual perception concerning the pilot's ability to see the pole at night.Aug 26, 1989 · N738WM · Substantial damageNTSB MIA89LA211Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Apalachicola, FLFailure of the pilot to maintain proper altitude. A factor related to the accident was: the pilot's lack of visual perception concerning altitude above the water.Aug 3, 1989 · N64RF · DestroyedNTSB MIA89LA128Accident · No injuriesLimited investigationFinal reportCessna 172M · West Palm Beach, FLFailure of the pilot to insure adequate wingtip clearance while taxiing.Apr 9, 1989 · N80440 · Substantial damageNTSB MIA89LA198Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Fort Myers, FLThe pilot's failure to see and avoid obstructions as he taxied from the ramp area. Contributing to the accident was the dark light conditions which degraded the pilot's visual perception.Mar 9, 1989 · N1032U · Substantial damageNTSB MIA89LA073Accident · No injuriesLimited investigationFinal reportBeech A36 · Daytona Beach, FLFailure of the driver of the automobile to maintain an adequate visual lookout and to yield the right of way to the aircraft.Jan 27, 1989 · N2860W · Substantial damageNTSB MIA89LA070Accident · No injuriesLimited investigationFinal reportCessna 152 · Jacksonville, FLThe Cessna 152 pilot misjudged clearance between his aircraft and the parked Piper PA-28.Jan 19, 1989 · N89803 · 2 aircraft · Substantial damageNTSB MIA89LA010Accident · No injuriesLimited investigationFinal reportRaven S-60A · Tampa, FLDrg an apch to land, the plt saw some bushes & another balloon (which had already landed) in his intended landing area. He applied burner to soar over the obstacles, then pulled the envelope vent to quickly descend after the obstacles had been cleared. He…Oct 15, 1988 · N65523 · Substantial damageNTSB MIA88LA272Accident · No injuriesLimited investigationFinal reportCessna 172F · Lake Wales, FLThe plt aborted the takeoff from the 'thick, wet' grass strip because the acft was not accelerating 'adequately.' He applied the brakes but it went off the departure end of the rwy, collided with a fence, tree, and dirt mound before coming to rest. There was…Sep 23, 1988 · N8707U · Substantial damageNTSB MIA88LA264Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Orlando, FLThe plt had rented the fully fueled aircraft from an FBO at orl which has hard surfaced 4600 & 6000 ft rwys. He flew to a 130 ft MSL arpt with a 2430 ft grass rwy & picked up his wife for a xc flt. He stated that the acft performed normally during the 10 min…Sep 3, 1988 · N36190 · Substantial damageNTSB MIA88LA220Accident · No injuriesLimited investigationFinal reportClassic YMF-5 · Key West, FLWhile turning the acft around at the operator's establishment after completing a sightseeing flt, the lower left wing collided with a vehicle.Jul 13, 1988 · N99Y · Substantial damage