NTSB investigations, FL
16 cases where the first occurrence was “Collision between aircraft (other than midair)”.
Cases per year
| 1995 | 1 |
|---|---|
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2000 | 2 |
| 2001 | 3 |
| 2002 | 1 |
| 2003 | 3 |
| 2004 | 1 |
| 2006 | 1 |
| 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\" = 271)
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" = 271) 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 MIA08LA014Accident · No injuriesLimited investigationFinal reportCessna C208B · Opa Locka, FLFailure of the local controller to coordinate with the ground controller and the failure of the pilots to see and avoid each other.NTSB MIA07LA026Accident · No injuriesLimited investigationFinal reportLingwall Rebich-Pitts · Naples, FLThe experimental airplane's pilot inadequate visual lookout while taxiing for takeoff, which resulted in an on-ground collision with a Piper airplane which was standing with its engine operating in the runup area.NTSB MIA05LA042Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Fort Pierce, FLThe failure of the pilot of the Piper 181 to apply his parking brake when stopped awaiting departure and his failure to maintain a visual lookout resulting in his airplane rolling forward and colliding with the Piper 201 which was awaiting departure.NTSB MIA03LA144Accident · No injuriesLimited investigationFinal reportCessna 172R · Daytona Beach, FLFailure of the student pilot of N864CP to judge the clearance between his airplane and the stationary N431ER while taxiing for takeoff which resulted in a ground collision.NTSB MIA03LA096Accident · No injuriesLimited investigationFinal reportCessna 172S · Melbourne, FLThe student pilot's improper throttle setting during the braking test, resulting in a collision with a parked airplane.NTSB MIA03LA088Accident · 1 fatalLimited investigationFinal reportAir Tractor 502B · Belle Glade, FLThe failure of both pilots to use on-board communication radios to advise takeoff and landing intentions, the reduction of visibility of the pilot-in-command of N6037H due to sun glare during takeoff, and the poor in-flight planning by the pilot-in-command of…NTSB MIA02IA167Incident · No injuriesIncident investigationFinal reportBoeing 737-823 · Miami, FLThe failure of the tug driver to maintain wingtip clearance with a parked airplane, and the inability of the tug driver to communicate with the brake rider during a tow operation following failure of the headset cord. Contributing factors in the incident were…NTSB MIA01LA201Accident · No injuriesLimited investigationFinal reportCessna 152 · Jacksonville, FLThe failure of the pilot of N89803 to insure his brakes were set and that the airplane was not rolling prior to diverting his attention to duties inside the cockpit, resulting in N89803 rolling forward and colliding with N8660Q which was parked in front of…NTSB ATL01LA073Accident · No injuriesLimited investigationFinal reportChristen Industries Eagle II · Belleview, FLThe pilot of the Christian Ealge II, N321JK, failure to maintain visual look out, prior to takeoff.NTSB MIA01FA074Accident · Minor injuriesField investigationFinal reportAmerican 8KCAB · Leesburg, FLThe failure of the pilot of N123WA and the failure of both pilots of N301NL to adequately insure visual separation between their aircraft and other aircraft in the landing pattern, resulting in a runway collision. Factors contributing to the accident were the…NTSB MIA01LA012Accident · No injuriesLimited investigationFinal reportCessna 150L · Leesburg, FLThe failure of the pilot of N331DM to maintain a proper visual lookout and ensure adequate clearance, which resulted in a collision with N11938. A factor in the accident was the failure of each pilot to communicate with the other.NTSB MIA00FA103Accident · 4 fatalField investigationFinal reportCessna 172K · Sarasota, FLThe failure of the supervisor/ground controller and the local controller to provide effective separation between the accident airplanes on the runway, resulting in a collision during takeoff. Contributing to the accident was the failure of the pilot and…NTSB MIA98LA111Accident · No injuriesLimited investigationFinal reportSteen Skybolt · Sanford, FLThe failure of the pilot of N101DT to maintain a visual lookout during the taxi phase of his flight and the failure of the ground controller to issue a traffic advisory to N101DT about the location of N6285M.NTSB ATL97LA085Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Daytona Beach, FLfailure of the pilot of N7617F to comply with an ATC instruction to hold short of a taxiway, and failure of the pilots in both airplanes to see-and-avoid each other's airplane.NTSB MIA96FA068Accident · No injuriesField investigationFinal reportMcDonnell Douglas MD-11 · Miami, FLThe local and ground controllers' failure to adequately coordinate the movement of the two airplanes, the tower cab supervisor's failure to provide adequate supervision to the controllers, the MD-11 flightcrew's misinterpretation of the local controller's…NTSB MIA95LA098Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Venice, FLFailure of the globe GC-1B (swift) pilot to see the Piper PA-23 in time to avoid a collision, and the Piper PA-23 pilot's delay in initiating remedial action to avoid the collision.