NTSB investigations, FL
220 cases where the first occurrence was “In flight collision with object”.
Cases per year
| 1982 | 12 |
|---|---|
| 1983 | 11 |
| 1984 | 8 |
| 1985 | 18 |
| 1986 | 11 |
| 1987 | 9 |
| 1988 | 12 |
| 1989 | 11 |
| 1990 | 8 |
| 1991 | 9 |
| 1992 | 5 |
| 1993 | 10 |
| 1994 | 5 |
| 1995 | 5 |
| 1996 | 5 |
| 1997 | 7 |
| 1998 | 8 |
| 1999 | 10 |
| 2000 | 15 |
| 2001 | 1 |
| 2002 | 11 |
| 2003 | 9 |
| 2004 | 3 |
| 2005 | 5 |
| 2006 | 4 |
| 2007 | 8 |
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\" = 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.
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" = 220) 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 NYC08CA055Accident · Minor injuriesData collectionFinal reportPiper PA-22-150 · Tallahassee, FLThe pilot's misjudged clearance over obstacles during final approach.NTSB MIA08CA025Accident · No injuriesData collectionFinal reportMessing Roy Sonex · New Smyrna Beac, FLThe pilot's failure to maintain altitude/clearance while on final approach for landing.NTSB NYC07CA184Accident · Minor injuriesData collectionFinal reportSchweizer 269C · Ormond Beach, FLThe certified flight instructor's delayed remedial action, which resulted in an in-flight collision with trees.NTSB ATL07LA089Accident · 1 fatalLimited investigationFinal reportGordon R Smith Sea Rey · Port St. Joe, FLThe pilot's failure to maintain a visual lookout and his improper decision to conduct a low altitude maneuver.NTSB MIA07FA083Accident · 3 fatalField investigationFinal reportCessna 182Q · Cudjoe Key, FLThe pilot's failure to maintain clearance from an active restricted area, which resulted in the airplane colliding with the tether of an aerostat.NTSB MIA07LA081Accident · 2 fatalLimited investigationFinal reportCessna U206G · Welaka, FLThe pilot's continued visual flight into instrument meteorological conditions and his failure to maintain clearance from utility poles. Contributing to the accident were the fog and haze.NTSB ANC07CA017Accident · No injuriesData collectionFinal reportPiper PA-46-500TP · Vero Beach, FLAn in-flight collision with a bird while maneuvering, which resulted in structural damage to the left wing of the airplane.NTSB MIA07CA045Accident · No injuriesData collectionFinal reportCessna 172S · Sanford, FLThe inadvertent inflight collision with a bird resulting in damage to the airplane and the pilot having limited control capability.NTSB MIA06CA134Accident · Minor injuriesData collectionFinal reportCessna 172N · Pensacola, FLThe student pilot's failure to raise the wing flaps for a go-around resulting in the airplane not climbing and an in-flight collision with trees.NTSB ANC06LA073Accident · Minor injuriesLimited investigationFinal reportMBB BK 117A-3 · Ponce de Leon, FLThe pilot's failure to maintain clearance from objects while hovering in ground effect, which resulted in an in-flight collision with a tree. Factors associated with the accident were loose, sand-covered terrain, and the operator's failure to ensure that the…NTSB MIA06CA045Accident · No injuriesData collectionFinal reportSchewizer 233 · Immokalee, FLThe pilot's failure to maintain clearance during the final approach to land, which resulted in an impact with trees, and a hard landing.NTSB MIA06FA039Accident · 3 fatalField investigationFinal reportRobinson R44 · Grand Ridge, FLThe pilot's continued flight into known adverse weather, and his impairment, which resulted in an in-flight collision with trees and terrain during cruise flight.NTSB MIA06CA009Accident · No injuriesData collectionFinal reportCessna 172N · Punta Gorda, FLThe in-flight collision with a bird resulting in substantial damage to the airplane.NTSB MIA05CA161Accident · Minor injuriesData collectionFinal reportVans RV-3 · Bell, FLThe pilot's failure to maintain visual lookout during a VFR approach toward the runway resulting in-flight collision with trees. Factors in this accident are no lights for the grass strip runway and attempting to land in low natural light visibility…NTSB ATL05FA145Accident · 1 fatalField investigationFinal reportCessna 310R · Apopka, FLThe pilot's failure to maintain adequate visual lookout and object clearance, which resulted in the in-flight collision with trees.NTSB MIA05CA133Accident · Minor injuriesData collectionFinal reportRobinson R44 · St. Cloud, FLThe failure of the pilot to maintain clearance with a palm tree resulting in the in-flight collision with it, and subsequent uncontrolled descent and in-flight collision with the ground.NTSB MIA05LA096Accident · 1 fatalLimited investigationFinal reportde Havilland DHC-6 · Deland, FLThe pilot's inadequate visual lookout.NTSB MIA05LA019Accident · No injuriesLimited investigationFinal reportScottish Bulldog 120/121 · Jacksonville, FLThe pilot's failure to maintain altitude/clearance with trees resulting in the in-flight collision with a tree, damage to the right main landing gear, and subsequent collapse of the right main landing gear during the emergency landing.NTSB ATL04LA177Accident · 2 fatalLimited investigationFinal reportPiper PA-23-250 · Lake Wales, FLThe pilot's inadequate preflight planning and preparation, and his inadequate visual lookout, which resulted in a collision with a television tower.NTSB MIA04CA095Accident · No injuriesData collectionFinal reportCessna 182H · La Belle, FLThe inadvertent deployment of the main parachute resulting in damage to the right horizontal stabilizer and elevator.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.NTSB 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…NTSB 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.NTSB 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.NTSB MIA03LA146Accident · 1 fatalLimited investigationFinal reportSonerai Sonerai IIB · Lakeland, FLThe pilot's decision to conduct low level flight and his failure to maintain obstacle clearance.NTSB MIA03LA115Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Brooksville, FLThe in-flight collision with a Black Vulture resulting in substantial damage.NTSB 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…NTSB 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.NTSB 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.NTSB MIA02LA164Accident · Minor injuriesLimited investigationFinal reportClarence F. Callahan Challenger II · Plymouth, FLThe pilot's failure to maintain the proper alignment which resulted in the airplane impacting trees on the south side of the approach end of the landing runway.NTSB MIA02FA161Accident · Serious injuriesField investigationFinal reportSikorsky S76A+ · Miami, FLThe flight crew's diverted attention, inadequate visual lookout, and failure to ensure adequate main rotor clearance. Factors in the accident were the continued operation, with known obstructions in the area, and the failure of the FAA to initially certify…NTSB DCA02MA054Accident · Serious injuriesClass 1 · MajorFinal reportBoeing 727-232 · Tallahassee, FLThe captain's and first officer's failure to establish and maintain a proper glidepath during the night visual approach to landing. Contributing to the accident was a combination of the captain's and first officer's fatigue, the captain's and first officer's…NTSB ATL02LA128Accident · Minor injuriesLimited investigationFinal reportBell 47G-2A · La Belle, FLThe pilot's failure to maintain visual lookout while maneuvering during an aerial application, which resulted in an in-flight collision with power lines and uncontrolled descent into terrain.NTSB MIA02LA105Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Ormond Beach, FLThe flight instructor's inadequate supervision of the dual student and failure to take prompt remedial action, resulting in a collision with a tree, a subsequent loss of control, and collision with the ground.NTSB MIA02FA106Accident · Minor injuriesField investigationFinal reportHelicopters & Exec 162F · Tampa, FLThe pilot's intentional operation of the helicopter while impaired by alcohol and a drug (zolpidem) resulting in the in-flight collision with a house.NTSB MIA02FA104Accident · 1 fatalField investigationFinal reportCessna 172S · Lutz, FLThe suicidal act by the pilot resulting in the in-flight collision with trees then the ground. A contributing factor in the accident was the pilot's depression. Findings in the investigation were the pilot's overdose of zolpidem and citalopram before the…NTSB ATL02LA094Accident · No injuriesLimited investigationFinal reportBell 47G-5A · La Belle, FLThe pilot's failure to maintain clearance of a tree while maneuvering, which resulted in an in-flight collision with the tree and subsequent uncontrolled descent and collision with terrain.NTSB MIA02LA085Accident · 1 fatalLimited investigationFinal reportGrote Cruiser TR-4 · Pembroke Pines, FLthe pilot-in-command delayed initiating a go-around and failed to obtain sufficient altitude to clear obstacles at the departure end of the airport which resulted in an in-flight collision with power lines.NTSB MIA02LA058Accident · 1 fatalLimited investigationFinal reportHarleman Tornado II · Molino, FLThe pilot's failure to maintain obstacle clearance, resulting in the in-flight collision with a static wire and an uncontrolled descent and collision with the ground. A factor in the accident was the pilot's impairment resulting from the use of unapproved…NTSB ATL02FA032Accident · 1 fatalField investigationFinal reportCessna 172R · Tampa, FLThe pilot's unauthorized use of an aircraft for the purpose of commiting suicide.NTSB ATL01LA087Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Lake City, FLThe pilots failure to maintain clearance during an approach to land, that resulted in an in-flight collision with trees.NTSB MIA01LA047Accident · No injuriesLimited investigationFinal reportLarry Groover Eagle · Auburndale, FLthe pilot's failure to maintain adequate clearance during takeoff, which resulted in an inflight collision with a fence and substantial damage to the aircraft.NTSB MIA01LA038Accident · No injuriesLimited investigationFinal reportGrob G102 · Clermont, FLThe pilot's premature extension of the speed brakes on landing resulting in the glider colliding with trees short of the runway.NTSB MIA01LA037Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Belle Glade, FLThe pilot's failure to maintain a visual lookout during a swath run resulting in an in-flight collision with known wires along the swath run, and a loss of directional control on landing roll due to flight control damage sustained during the in-flight…NTSB MIA01LA017Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Daytona Beach, FLan inadvertent inflight collision with a bird during cruise flight that resulted in substantial damage to the airplane.NTSB MIA00LA240Accident · Serious injuriesLimited investigationFinal reportLake LA-4 · Pensacola, FLThe pilot receiving instruction failure to achieve the proper touch down point during a water landing, and the CFI's improper supervision and failure to initiate a go-around in sufficient time to avoid and in-flight collision with trees, water, and subsequent…NTSB MIA00LA205Accident · No injuriesLimited investigationFinal reportBeech 65-A90 · Lake Wales, FLThe pilot's inadequate visual lookout while maneuvering to avoid a flock of birds shortly after takeoff, resulting in the aircraft colliding with a wire. A factor in the accident was the pilot's fatigue after having worked everyday for the previous 3 weeks.NTSB MIA00LA195Accident · No injuriesLimited investigationFinal reportCessna 402C · Naples, FLan inflight collision with a bird during descent that resulted in substantial damage to the airplane's vertical stabilizer spar.NTSB ATL00LA059Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Indiantown, FLThe student pilot's failure to maintain altitude clearance during initial climb following takeoff during the commission of a crime, resulting in an in-flight collision with a tree.NTSB ATL00FA048Accident · 3 fatalField investigationFinal reportEurocopter BK117-A3 · St. Petersburg, FLThe pilot's failure to maintain clearance that resulted in the in-flight collision with a tower.