NTSB investigations, AL
34 cases where the first occurrence was “In flight collision with terrain/water”.
Cases per year
| 1982 | 6 |
|---|---|
| 1983 | 3 |
| 1984 | 3 |
| 1985 | 1 |
| 1987 | 4 |
| 1988 | 1 |
| 1989 | 2 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 4 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1999 | 2 |
| 2001 | 1 |
| 2002 | 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\" = '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\" = 230)
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" = 230) 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 MIA07CA100Accident · Serious injuriesData collectionFinal reportHillery W. Grice Alley Cat 1 · Fairhope, ALThe failure of the pilot-in-command to maintain terrain clearance while completing a loop at an airshow, resulting in impact with the runway.NTSB MIA02LA070Accident · No injuriesLimited investigationFinal reportHughes 269C · Bessemer, ALThe failure of the flight instructor to adequately monitor the student's rotorcraft control, resulting in an abrupt cyclic input causing a tail rotor strike of the terrain while entering a hover, and the resulting rollover during an uncontrolled descent.NTSB MIA01LA113Accident · 1 fatalLimited investigationFinal reportLarry R. Kinsey Variez O-235 · Pinson, ALThe pilot's continued visual flight rules flight into instrument meteorological conditions resulting in the airplane colliding with mountainous terrain.NTSB MIA00FA043Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300T · Pelham, ALThe student pilot's decision to continue the visual flight rules flight into deteriorating visibility, and his failure to maintain altitude clearance with the terrain.NTSB ATL99FA044Accident · 2 fatalField investigationFinal reportBeech 300 · Cullman, ALThe pilot's failure to adhere to the missed approach procedure resulting in a collision with terrain. Contributing factors were fog and the rotorcraft rated pilot's lack of fixed wing certification/experience.NTSB ATL95LA077Accident · Minor injuriesLimited investigationFinal reportBeech B-19 · Jackson, ALThe pilot's continued operation of the airplane with a known deficiency in available power.NTSB ATL95FA003Accident · 2 fatalField investigationFinal reportCessna 182L · Ft. Mcclellan, ALThe pilot's continued VFR flight into IMC conditions, and his failure to maintain a proper altitude over mountainous terrain. Factors were the low ceiling, fog, and drizzle weather conditions, and the mountainous terrain at the accident site.NTSB ATL93LA081Accident · No injuriesLimited investigationFinal reportCessna 421B · Fort Payne, ALThe pilot's failure to compensate for winds during the initial takeoff that resulted in the airplane colliding with the runway, exceeding the design limits of the aircraft and upon landing at the destination airport, the collapse of the main landing gear.NTSB ATL93LA023Accident · 1 fatalLimited investigationFinal reportBede BD-5B · Guntersville, ALThe pilot's inadvertent stall of the airplane, during the base to final turn, at too low an altitude to effect recovery. Factors were the improper lift off, which resulted in the airplane re contacting the runway after lift off, and served to distract the…NTSB ATL92LA173Accident · No injuriesLimited investigationFinal reportCessna A188B · Centre, ALThe pilot's inadequate compensation for existing wind conditions, which resulted in his inability to maintain a proper altitude. Factors were the turbulence and wind shear present at the time of the accident.NTSB ATL92MA118Accident · 3 fatalClass 1 · MajorFinal reportBeech C99 · Anniston, ALThe failure of senior management of gp express to provide adequate training and operational support for the startup of the southern operation, which resulted in the assignment of an inadequately prepared captain with a relatively inexperienced first officer…NTSB ATL92LA083Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Moontown, ALThe pilot's excessive reference airspeed on landing, improper use of the wheel brakes, and his delay in executing an aborted landing. A factor was the wet runway surface.NTSB ATL91FA052Accident · 4 fatalField investigationFinal reportPiper PA-31-350 · Munford, ALThe pilot attempting visual flight in instrument meteorological conditions below the minimum safe altitude for terrain clearance. Contributing factors were the low ceiling and mountainous terrain.NTSB ATL90DKJ03Accident · Minor injuriesFinal reportJolly Bakeng Duce · Brownsboro, ALFailure of the pilot to maintain the reference speed on approach and establish a proper glidepath.NTSB ATL89DKJ10Accident · Serious injuriesFinal reportPiper PA-36-285 · Atmore, ALThe pilot's failure to maintain clearance from obstacles (the crop) during an agricultural spray run.NTSB ATL89FA175Accident · 2 fatalField investigationFinal reportBeech A45 · Troy, ALThe pilot's improper use of the airplane flight controls during a aerobatic maneuver at low altitude due to his lack of aerobatic experience. A contributing factor was the pilot's overconfidence in his ability to perform the maneuver.NTSB ATL88LA127Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Guntersville, ALThe seaplane collided with the water shortly after takeoff. The plt rptd that a large spider dropped in front of him and distracted him. The airplane was in a gradual right turn about 100 ft above the water at the time. He attempted to swat the spider with…NTSB ATL88FA056Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Anniston, ALThe VFR pilot continued the flight into deteriorating weather conditions and attempted to descend below the lowering clouds until the aircraft was too low to turn around safely and return to VFR flight conditions. The aircraft collided with trees and struck…NTSB ATL87LA222Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Huntsville, ALThe helicopter impacted the water during a low-altitude turn over a river. The plt made a low pass to the south over an island at about 30 ft AGL, to show the island to the policewoman/traffic observer onboard. As he was making a climbing right turn at about…NTSB ATL87LA204Accident · No injuriesLimited investigationFinal reportBell 47D1 · Huntsville, ALThe aerial application flight was dispensing insecticides on a cotton field. While maneuvering to avoid powerlines during the procedure turnaround following an upwind swath run, the pilot failed to maintain sufficient airspeed to ensure effective…NTSB ATL87LA182Accident · No injuriesLimited investigationFinal reportBeech B200 · Jasper, ALThe plt obtained a weather briefing for his proposed flt from birmingham, AL to Jasper, AL to allentown, PA. He did not file a flight plan for the 35 mile flt from birmingham to Jasper, however, he did file a flight plan for the proposed flt fm Jasper to…NTSB ATL85LA131Accident · No injuriesLimited investigationFinal reportMooney M20E · Gunthersville, ALThe plt reported that he failed to extend the landing gear in the traffic pattern. Subsequently, the acft was damaged during a gear up landing.NTSB ATL85FA071Accident · Serious injuriesField investigationFinal reportCessna 172N · Dothan, ALThe plt, who was also an ATC specialist assigned to a fss, crashed short of the rwy during an attempted ILS apch. Whe wx conditions were below apch minimums.NTSB ATL84FA274Accident · 2 fatalField investigationFinal reportCessna 402C · Albertville, ALPlt was executing an non-directional beacon approach to rwy 23. Instrument meteorological conditions prevailed at the time of the accident. Radar information obtained during the investigation revealed the plt did not stabilize the airspeed while executing the…NTSB ATL84LA228Accident · No injuriesLimited investigationFinal reportCessna 175 · Enterprise, ALA witness observed the airplane slipping on final apch. The aircraft lost too much altitude and hit the terrain short of the runway. The airplane damage indicated that the pilot failed to correct the slip condition in time to arrest the descent.NTSB ATL84FKJ02Accident · 1 fatalFinal reportCessna A188B · Hazel Green, ALThe acft collided with the ground while the plt was flying near his rural home. No preimpact, mechanical malfunction or failure was found. According to the medical examiner, the plt had severe & extensive coronary arterioscleroses; however, the relationship…NTSB ATL83LA349Accident · Serious injuriesLimited investigationFinal reportJohnston Long E-Z · Pell City, ALThe acft crashed while attempting a downwind takeoff in high winds and heavy rain. The pilot said he was trying to take off before the heavy rain so he picked a rwy pointing into clear weather but with a tailwind. The tailwind increased during the takeoff…NTSB ATL83FKJ03Accident · 1 fatalFinal reportEaa Biplane P-2 · Southside, ALThe pilot was performing aerobatics over the airport at 400-500 feet AGL. On the last pass, he had completed one roll and was inverted in what appeared to be a second roll when the aircraft dove at the ground in a near vertical position. The aircraft engine…NTSB ATL83FA036Accident · 1 fatalField investigationFinal reportMooney M20J · Sardis, ALThe aircraft was on an IFR flight from memphis, TN to selma, AL. During arrival, he was cleared for an NDB approach to the craig airport. At that time, the weather was reported as measured 400 ft overcast, visibility 1/2 mi with fog. The weather minimums for…NTSB ATL83LA030Accident · No injuriesLimited investigationFinal reportMooney M20F · Talladega, ALPilot forgot to extend landing gear.NTSB ATL82DA260Accident · Minor injuriesFinal reportCessna A188 · Hillsboro, ALThe pilot reported that while making a swath run to the west over uneven terrain, his right wing contacted the cotton crop that he was spraying. The aircraft crashed and began to burn after coming to rest inverted. The pilot escaped with minor injuries before…NTSB ATL82IA170Incident · No injuriesIncident investigationFinal reportMooney M20J · Dauphin Island, ALAfter a normal flight from birmingham, AL, the pilot executed a visual full circuit approach to runway 12 at Dauphin Island, AL. The pilot stated that he stabilized on final at 72 knots with full flaps and that he had a 5-10 knot crosswind from the south. The…NTSB ATL82FKJ12Accident · 1 fatalFinal reportPiper J3C-65 · Alabaster, ALDuring an air show, the aircraft was observed flying slowly over the runway on a southerly heading at about 200 to 250 ft AGL. Full left rudder was applied along with full up elevator and the plane entered a spin. After one turn, full opposite rudder was…NTSB ATL82DKJ10Accident · No injuriesFinal reportBeech V35B · Tuskegee, ALDuring landing, the pilot put the landing gear and flap handles in the down positions. He heard noises that sounded like both had extended and assumed everything was in place. The pilot was unaware that the landing gear was not down until after touchdown. An…