NTSB investigations, FL
139 cases where the first occurrence was “On ground/water collision with object”.
Cases per year
| 1982 | 6 |
|---|---|
| 1983 | 8 |
| 1984 | 9 |
| 1985 | 7 |
| 1986 | 3 |
| 1987 | 4 |
| 1988 | 6 |
| 1989 | 11 |
| 1990 | 3 |
| 1991 | 5 |
| 1992 | 4 |
| 1993 | 6 |
| 1994 | 10 |
| 1995 | 7 |
| 1996 | 4 |
| 1997 | 3 |
| 1998 | 7 |
| 1999 | 2 |
| 2000 | 8 |
| 2001 | 8 |
| 2002 | 5 |
| 2003 | 5 |
| 2004 | 3 |
| 2005 | 1 |
| 2006 | 3 |
| 2007 | 1 |
Where
Open the mapLatest 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 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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB MIA08CA040Accident · No injuriesData collectionFinal reportAgusta A109 · ST. Augustine, FLThe pilot's failure to maintain a visual lookout while taxiing.NTSB MIA07IA031Incident · No injuriesIncident investigationFinal reportBoeing 747-436 · Miami, FLThe flightcrew's misinterpretation of available lighting, signage, and airfield marking cues during taxi.NTSB MIA06CA102Accident · No injuriesData collectionFinal reportPiper 38-112 · Apopka, FLThe pilot's failure to maintain clearance from an object while taxiing which resulted in the airplane impacting the object and incurring damage.NTSB MIA06CA129Accident · No injuriesData collectionFinal reportTharp S Richard Challenger II · Apopka, FLThe pilot's inadequate selection of a landing area which resulted in one of the seaplane's floats impacting a submerged stump.NTSB MIA05LA084Accident · No injuriesLimited investigationFinal reportSwearingen SA227-AC · Miami, FL"This case was modified may 30, 2006." The airplane's inadvertent impact with one of several deer that had entered the airport property and crossed the runway during the landing rollout.NTSB MIA05CA032Accident · Serious injuriesData collectionFinal reportCessna 172B · Zephyrhills, FLThe pilot's failure to set the parking brake and his improper starting procedure which resulted in an unattended aircraft running away after hand starting the engine and the airplane colliding with parked airplanes, incurring substantial damage.NTSB MIA05CA014Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Valkaria, FLThe inadvertent collision with a deer during takeoff which resulted in damage to the right brake system and the airplane being unable to stop prior to the end of the runway.NTSB ATL04TA142Accident · No injuriesFinal reportBell UH-1H · Childs, FLThe vehicle driver's inadequate visual lookout and his failure to maintain clearance. A factor was the lack of company standards and operation procedures.NTSB ATL04LA053Accident · No injuriesLimited investigationFinal reportCanadair CL-600-2B19 · Miami, FLThe tug operator's loss of control and his failure to maintain clearance from the aircraft during pushback operations.NTSB MIA04CA002Accident · No injuriesData collectionFinal reportPiper PA-24-260B · Archer, FLThe pilot's failure to maintain directional control during the takeoff roll/run, which resulted in the airplane veering off the centerline of the runway and impacting an object, incurring damage.NTSB MIA03LA100Accident · No injuriesLimited investigationFinal reportCessna 172P · Lantana, FLthe pilot's use of excessive airspeed and the improper touchdown point during the landing roll, which resulted in the airplane departing the runway, and impacting with trees.NTSB MIA03LA089Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Lakeland, FLThe inadequate visual lookout of the pilot and the ground marshaller resulting in the ground marshaller being struck by the wing of the taxiing airplane and receiving serious injury.NTSB MIA03LA038Accident · No injuriesLimited investigationFinal reportNorth American AT-6A · Melbourne, FLThe failure of the pilot of the North American AT6A, N57318 to maintain a proper visual lookout while taxiing, which resulted in him impacting the rear of the Cessna 172K, N522F.NTSB MIA03CA037Accident · No injuriesData collectionFinal reportPiper PA-30 · Tallahassee, FLthe pilot's improper start procedure which resulted in an unintentional engine start, and unoccupied aircraft collision with hangar structure.NTSB MIA03CA063Accident · No injuriesData collectionFinal reportConsolidated Aeronautics LA-4-200 · Blountstown, FLThe failure of the certified flight instructor (CFI) to maintain clearance between the wingtip and a water marker bouy resulting in contact with the wingtip.NTSB ATL02LA172Accident · No injuriesLimited investigationFinal reportCessna 172P · Lutz, FLThe pilot's failure to maintain visual lookout and clearance during taxi, which resulted in an on-ground collision with a building.NTSB ATL02LA152Accident · No injuriesLimited investigationFinal reportCessna 150 · Lakeland, FLThe pilot's failure to maintain a visual lookout while taxiing to parking resulting in an on-ground collision with a pole. A related factor was the diverted attention to the lineman.NTSB MIA02LA180Accident · No injuriesLimited investigationFinal reportCessna 172M · Kissimmee, FLThe pilot's failure to maintain the proper clearance while taxing the airplane which resulted in the left wing tip colliding with an object and damage to the airplane. A related factor was night conditions.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.NTSB 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.NTSB ATL02LA007Accident · No injuriesLimited investigationFinal reportNorth American SNJ-6 · Kissimmee, FLSee narrative for ATL02LA007A.NTSB 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.NTSB 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.NTSB MIA01LA195Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Orlando, FLthe pilot's improper visual lookout, which resulted in the aircraft colliding with a fence.NTSB 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.)NTSB 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.NTSB MIA01LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Melbourne, FLThe student pilot's failure to maintain a visual look out while transitioning from the active runway to a taxiway resulting in an on-ground collision with a taxiway sign.NTSB MIA01LA010Accident · No injuriesLimited investigationFinal reportJim Price Pitts Special S · Indiantown, FLThe failure of the pilot of N56JP, during landing rollout, to see and avoid N49713, who was turning off the runway after landing from the opposite direction, resulting in the 2 aircraft colliding on the runway.NTSB ATL00LA083Accident · No injuriesLimited investigationFinal reportDouglas DC-3 · Key West, FLFailure of the right brake expander tube which limited the pilots control of the aircraft.NTSB MIA00LA230Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · New Smyrna Bch., FLthe pilot's failure to maintain control of the airplane during the landing roll. Factors in this accident were; a crosswind, and the pilot lack of experience in this kind of aircraft.NTSB MIA00LA206Accident · No injuriesLimited investigationFinal reportBoeing 737-49R · Orlando, FLThe captain's failure to stop the aircraft when given a stop signal by the ground marshaller and his failure to turn the aircraft when given a turn signal by the ground marshaller as he taxied into the gate resulting in the aircraft's left wing colliding with…NTSB MIA00LA144Accident · No injuriesLimited investigationFinal reportCessna 152 · Sanford, FLthe dual student's improper visual lookout and the flight instructor's inadequate supervision that resulted in the airplane colliding with a fence post.NTSB MIA00LA124Accident · No injuriesLimited investigationFinal reportCessna 172P · St. Petersburg, FLThe failure of the pilot to maintain clearance between the left wingtip and a hangar door resulting in the on-ground collision.NTSB MIA00LA115Accident · Serious injuriesLimited investigationFinal reportBeech 1900 · Miami, FLInadequate visual lookout by the driver of the vehicle.NTSB MIA99FA168Accident · No injuriesField investigationFinal reportCessna 402C · Fort Lauderdale, FLThe pilot's decision takeoff with condensation on the cockpit windows which restricted visibility, his improper use of aileron control, improper compensation for winds during takeoff, and his failure to maintain directional control during takeoff, resulting…NTSB MIA99LA145Accident · No injuriesLimited investigationFinal reportBeech E33 · Orlando, FLthe pilot's failure to maintain control of the airplane during takeoff, resulting in the airplane departing the runway, and subsequently impacting with an airport sign.NTSB MIA99LA055Accident · No injuriesLimited investigationFinal reportCessna 150 · Pembroke Pines, FLThe pilot's decision to abort the takeoff with insufficient runway remaining.NTSB MIA99LA004Accident · No injuriesLimited investigationFinal reportMooney M20J · Orlando, FLThe failure of the pilot to maintain clearance while taxiing from landing resulting in the on-ground collision with the parked airplane. A factor in the accident was the intentional operation of the airplane by the pilot with known deficiencies in equipment…NTSB MIA98TA243Accident · No injuriesFinal reportBell BHT-47-G3B1 · Buckhead Ridge, FLThe failure of the pilot to adequately compensate for a tailwind condition on liftoff from the helipad.NTSB MIA98LA234Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Leesburg, FLThe pilot's decision to leave the engine running with no one at the controls as he exited the aircraft to check for wheel chocks in place. This resulted in the aircraft moving uncontrolled and eventually colliding with a fence.NTSB MIA98LA143Accident · Minor injuriesLimited investigationFinal reportOrlando Heli Air TR-2000 · Lakeland, FLThe pilot's failure to obtain the proper touch down point (landed left of runway) on landing.NTSB ATL98LA064Accident · No injuriesLimited investigationFinal reportDennis L. Long Pitts S-2A · Daytona Beach, FLThe pilot's failure to maintain directional control during an attempted takeoff. A factor was the reported crosswind condition.NTSB MIA98LA059Accident · No injuriesLimited investigationFinal reportValentin Tiafun 17E · Pensacola, FLthe pilot's improper in-flight planning/decision and failure to see-and-avoid an obstruction during a precautionary landing on a paved road. Factors relating to the accident were: the resultant low fuel condition, and an obstruction in the precautionary…NTSB ATL97LA046Accident · No injuriesLimited investigationFinal reportCessna 152 · Fernandina Bch, FLinadequate visual lookout by the student pilot, which resulted in a collision with a parked trailer, while his attention was diverted. The proximity of the trailer was a related factor.NTSB MIA97LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Tampa, FLthe pilot's excessive taxispeed.NTSB MIA97LA080Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Sarasota, FLthe pilot's failure to maintain clearance from obstacles.NTSB MIA96LA145Accident · No injuriesLimited investigationFinal reportCessna 172K · Englewood, FLFailure of the pilot-in-command to maintain visual lookout while taxiing to takeoff resulting in an on-ground collision with a tree.NTSB ATL96LA070Accident · No injuriesLimited investigationFinal reportO'Connell Christen Eagle · New Smyrna Bch, FLthe failure of the pilots of the Cessna 152, N757NP, to see and avoid the Christen Eagle, N13LD.NTSB MIA96LA102Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Lauderdale, FLthe pilot misjudged the clearance between the fuel trucks.NTSB ATL96LA038Accident · No injuriesLimited investigationFinal reportCessna 172 · Sanford, FLthe pilot-in-command's excessive taxi speed and his failure to maintain adequate clearance from obstacles.