Fatal NTSB investigations, AL

13 cases where the first occurrence was “In flight collision with terrain/water”.

Cases per year

19822026
Fatal NTSB investigations, AL per year, 1982–2026: 13 cases
19822
19832
19841
19891
19911
19922
19941
19992
20011

Latest 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.\"highestInjuryLevel\" = 'Fatal'
    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.

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.Mar 31, 2001 · N49LK · DestroyedNTSB 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.Dec 8, 1999 · N39696 · DestroyedNTSB 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.Jan 14, 1999 · N780BF · DestroyedNTSB 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.Oct 3, 1994 · N3499R · DestroyedNTSB 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…Nov 8, 1992 · N84EJ · DestroyedNTSB 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…Jun 8, 1992 · N118GP · DestroyedNTSB 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.Feb 7, 1991 · N27818 · DestroyedNTSB 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.Jul 8, 1989 · N7973A · DestroyedNTSB 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…Aug 31, 1984 · N55LP · DestroyedNTSB 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…Oct 29, 1983 · N731JJ · DestroyedNTSB 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…Mar 13, 1983 · N20KJ · DestroyedNTSB 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…Nov 19, 1982 · N7201Y · DestroyedNTSB 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…May 16, 1982 · N42799 · Destroyed