NTSB investigations, AL
92 cases where the first occurrence was “In flight collision with object”.
Cases per year
| 1982 | 4 |
|---|---|
| 1983 | 9 |
| 1984 | 3 |
| 1985 | 4 |
| 1986 | 7 |
| 1987 | 7 |
| 1988 | 2 |
| 1989 | 4 |
| 1990 | 2 |
| 1991 | 2 |
| 1992 | 8 |
| 1993 | 2 |
| 1995 | 4 |
| 1996 | 4 |
| 1997 | 2 |
| 1998 | 4 |
| 1999 | 1 |
| 2000 | 2 |
| 2001 | 4 |
| 2002 | 2 |
| 2003 | 3 |
| 2004 | 4 |
| 2005 | 2 |
| 2006 | 5 |
| 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\" = 'AL' 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" = 'AL' 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 NYC08LA050Accident · No injuriesLimited investigationFinal reportBell 206-L4 · Talladega, ALThe pilot's inadequate visual lookout, which resulted in an in-flight collision with a wire.NTSB ATL07CA011Accident · No injuriesData collectionFinal reportAir Tractor AT-802A · Linden, ALThe pilot's attempt to takeoff downwind resulting in the airplane not clearing trees at the end of the runway.NTSB ATL06CA088Accident · No injuriesData collectionFinal reportBellanca 7ECA · Gadsden, ALThe pilot's failure to maintain a visual lookout,while maneuvering at a low altitude resulting in an in-flight collision with a powerline.NTSB ATL06LA059Accident · Serious injuriesLimited investigationFinal reportBrantly Helicopter B2B · Cullman, ALThe pilot's failure to maintain a visual look out while maneuvering resulting in an in-flight collision with wires and the ground. A factor in the accident was the pilot's lack of recent experience in rotorcraft operations.NTSB ATL06CA043Accident · No injuriesData collectionFinal reportCessna 172P · Birmingham, ALAn in-flight collision with a deer during a go around, which resulted in damage to the left main landing gear and subsequent collapse of the left main landing gear.NTSB ATL06FA038Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Camden, ALThe pilots failure to maintain altitude and clearance during a visual descent which resulting in an in-flight collision with trees and the ground for undetermined reasons.NTSB ATL06CA026Accident · Serious injuriesData collectionFinal reportEurocopter France AS-350-B2 · Jasper, ALThe pilot's failure to maintain a visual look out, and proper altitude clearance during a low level flight, resulting in an in-flight collision with a power line.NTSB ATL05LA137Accident · 1 fatalLimited investigationFinal reportCessna T210 · Muscle Shoals, ALThe pilot's inadequate visual lookout, and failure to maintain clearance, which resulted in an in flight collision with a transmission wire.NTSB ATL05LA035Accident · No injuriesLimited investigationFinal reportBell UH-1H · Rockford, ALThe pilot's failure to maintain adequate obstacle clearance, which resulted in an in-flight collision with a tree.NTSB ATL04LA195Accident · 2 fatalLimited investigationFinal reportCessna 172L · Gadsden, ALThe flight instructors failure to maintain clearance and his inadequate visual lookout while flying low over a river resulting in an in-flight collision with a wire.NTSB ATL04CA146Accident · Minor injuriesData collectionFinal reportAir Tractor AT-402A · Hillsboro, ALThe pilot's inadequate visual lookout and failure to maintain adequate obstacle clearance, which resulted in collision with transmission wires.NTSB ATL04CA127Accident · Minor injuriesData collectionFinal reportCessna 150 · Decatur, ALThe pilot's failure to maintain obstacle clearance, which resulted in collision with utility wires.NTSB ATL04LA011Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Huntsville, ALThe pilot's failure to maintain obstacle clearance while hovering out of ground effect, which resulted in a collision with a tree and subsequent uncontrolled collision with the ground.NTSB ATL03LA086Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Montgomery, ALThe in-flight collision with birds that resulted in a partial loss of engine power, and subsequent in-flight collision with trees while maneuvering for an emergency landing.NTSB ATL03LA037Accident · 1 fatalLimited investigationFinal reportLong 2000 · Brewton, ALThe pilot's improper use of flight controls (cyclic and collective) and failure to maintain rotor RPM while maneuvering that resulted in the separation of the tailboom assembly.NTSB ATL02LA102Accident · No injuriesLimited investigationFinal reportBell 47G · Marion, ALThe pilot's failure to maintain visual lookout while conducting an aerial application maneuver. A factor was the transmission line.NTSB MIA02LA086Accident · Serious injuriesLimited investigationFinal reportLett R/Campbell K Aircam · Troy, ALthe pilot-in-commands decision to fly at a low altitude and his improper visual lookout resulting in an in-flight collision static with wires.NTSB MIA02FA037Accident · 2 fatalField investigationFinal reportCessna 208B · Bessemer, ALThe poor in-flight planning by the pilot-in-command for his initiation of the ILS approach to runway 05 with weather conditions below minimums for the approach contrary to the federal aviation regulations, and the failure of the pilot to maintain control of…NTSB MIA02FA026Accident · 2 fatalField investigationFinal reportEnstrom 280FX · Tallassee, ALThe failure of the pilot to maintain a safe altitude above terrain and maintain a visual lookout resulting in the helicopter colliding with power transmission lines and crashing into a river. A factor in the accident was the power transmission lines not being…NTSB ATL01LA057Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Pell City, ALThe pilot's selection of the wrong runway that resulted in an attempted takeoff with a tailwind.NTSB ATL01FA019Accident · 1 fatalField investigationFinal reportCessna 206H · Vandiver, ALThe pilot's inflight decision to continued visual flight into instrument meteorological conditions resulted in the inflight collision with trees. Low ceilings and trees were factorsNTSB ATL00LA060Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Foley, ALThe pilot exceeding the performance capability of the airplane during takeoff. A factor was the trees.NTSB MIA00FA166Accident · 1 fatalField investigationFinal reportBeech 95-A55 · Aliceville, ALThe in-flight collision with trees then terrain while descending for undetermined reasons.NTSB MIA99LA238Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Jackson, ALthe pilot's inadequate preflight planning and preparation, which resulted in taking off with the airplane's maximum gross weight exceeded, and subsequent impact with trees. Factors in this accident were high temperatures and an in-flight encounter with a…NTSB MIA99FA027Accident · 2 fatalField investigationFinal reportCessna C-182Q · Piedmont, ALThe pilot's decision to continue the flight under visual flight rules into deteriorating visibility, and his failure to maintain altitude clearance with the terrain.NTSB ATL99LA002Accident · Minor injuriesLimited investigationFinal reportCessna 188B · Tellasse, ALThe pilot's failure to maintain clearance from a utility line while conducting a swath run.NTSB MIA98LA216Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Tuskegee, ALThe pilot's failure to attain adequate airspeed, and his failure to abort the takeoff.NTSB MIA98LA197Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13H/M47A · Citronelle, ALThe pilot's failure to control the helicopter's altitude while overflying an area of rising terrain and trees.NTSB MIA97LA212Accident · Minor injuriesLimited investigationFinal reportContinental Copters MK5A · Sylacauga, ALThe failure of the pilot to maintain main rotor rpm resulting in the helicopter descending and colliding with trees.NTSB MIA97LA199Accident · No injuriesLimited investigationFinal reportSloan RV-6 · Muscle Shoals, ALthe pilot's failure to see-and-avoid the bales of hay duirng the takeoff roll, which resulted in an in-flight collision with a bale at liftoff and subsequent in-flight collision with terrain.NTSB ATL96LA121Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Tuscaloosa, ALThe pilot's failure to see and avoid an antenna during low altitude maneuvering.NTSB MIA96LA200Accident · 1 fatalLimited investigationFinal reportBell 206B III · Barton, ALfailure of the pilot to see-and/or-avoid the obstruction (unmarked power line), while en route between the area that was being treated and the refueling location. The power line and lack of visual cues at dusk were related factors.NTSB ATL96FA096Accident · 2 fatalField investigationFinal reportCessna 152 · Talladega, ALfailure of the pilot to see-and-avoid an antenna that was mounted on a Forest Service watch tower. The pilot's excessively low altitude flight was a related factor.NTSB MIA96LA125Accident · No injuriesLimited investigationFinal reportRans S6ES · Bayou La Batre, ALthe pilot's inadequate compensation for wind conditions. The gusty/crosswind condition was a related factor.NTSB MIA95LA204Accident · 1 fatalLimited investigationFinal reportCessna A188B · Muscle Shoals, ALFailure of the pilot to maintain adequate visual lookout to see-and-avoid electrical power lines, while approaching a field for aerial application.NTSB ATL95LA160Accident · No injuriesLimited investigationFinal reportBell UH-1H · Montgomery, ALthe pilot's failure to maintain clearance from the trees.NTSB ATL95LA111Accident · No injuriesLimited investigationFinal reportCessna 188D · Athens, ALThe pilot's inadequate lookout, and his failure to maintain clearance from the utility line.NTSB ATL95FA065Accident · 1 fatalField investigationFinal reportPiper J-3L-65 · Tallassee, ALThe student pilot's failure to see and avoid the utility line while performing unwarranted low altitude maneuvers.NTSB ATL93LA112Accident · Serious injuriesLimited investigationFinal reportCessna 172 · St. Elmo, ALThe pilot's failure to maintain adequate clearance from the trees located near the departure end of the runway. Factors were the pilot's failure to use the entire runway for the takeoff, and the trees located near the departure end of the runway.NTSB ATL93LA106Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Centre, ALThe pilot's failure to maintain clearance from trees during agricultural application maneuvering. Factors were the trees in the vicinity of the planned flight path.NTSB ATL93FA025Accident · 3 fatalField investigationFinal reportCessna 172 · Brownsboro, ALThe pilot failed to evaluate the wind conditions and took off with a tailwind which resulted in the collision with a tree on the departure end of the runway. Factors were dark night and tailwind.NTSB MIA92LA165Accident · Serious injuriesLimited investigationFinal reportCessna AT188B · Prattville, ALThe pilot-in-command's improper visual lookout and failure to maintain clearance from the wires.NTSB ATL92LA148Accident · No injuriesLimited investigationFinal reportCessna 188 · Town Creek, ALThe inadequate preflight planning/preparation by the pilot which resulted in reduced aircraft performance and the collision with trees during climbout. Factors were the soft and wet terrain.NTSB ATL92LA132Accident · 1 fatalLimited investigationFinal reportBell 206B · Bessemer, ALThe pilots failure to maintain clearance from wires.NTSB ATL92LA131Accident · No injuriesLimited investigationFinal reportBell 47D1 · Centre, ALThe pilot's inadequate visual lookout, resulting in a collision with a wire.NTSB ATL92LA130Accident · Minor injuriesLimited investigationFinal reportGrumman 164A · Abbeville, ALThe pilot's failure to see and avoid the top utility wire.NTSB ATL92FA107Accident · 1 fatalField investigationFinal reportMaule M-5-210C · Wetumpka, ALThe pilot's inadequate visual lookout, and his failure to maintain proper clearance from the transmission wires.NTSB ATL92LA104Accident · 1 fatalLimited investigationFinal reportCessna 188 · Elba, ALThe pilot's failure to maintain clearance from objects (trees), and his inadequate visual lookout. A factor was the trees located in the practice area.NTSB ATL91LA145Accident · No injuriesLimited investigationFinal reportCessna 188B · Monroeville, ALThe pilot's misjudgment of the clearance between the airplane and the electrical transmission wire. A factor was the hazy visibility.NTSB ATL91FA040Accident · 4 fatalField investigationFinal reportRockwell 114 · Bessemer, ALFailure of the pilot to follow instrument flight rules (IFR) and maintain the minimum descent altitude (mda) during the VOR approach. Factors related to the accident were: darkness and the adverse weather conditions.