NTSB investigations, 1989, AL
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases per year
| 1962 | 1 |
|---|---|
| 1963 | 1 |
| 1964 | 61 |
| 1965 | 92 |
| 1966 | 70 |
| 1967 | 85 |
| 1968 | 68 |
| 1969 | 75 |
| 1970 | 89 |
| 1971 | 73 |
| 1972 | 76 |
| 1973 | 82 |
| 1974 | 67 |
| 1975 | 71 |
| 1976 | 77 |
| 1977 | 82 |
| 1978 | 72 |
| 1979 | 50 |
| 1980 | 50 |
| 1981 | 48 |
| 1982 | 61 |
| 1983 | 60 |
| 1984 | 41 |
| 1985 | 45 |
| 1986 | 48 |
| 1987 | 45 |
| 1988 | 36 |
| 1989 | 33 |
| 1990 | 32 |
| 1991 | 30 |
| 1992 | 40 |
| 1993 | 33 |
| 1994 | 27 |
| 1995 | 42 |
| 1996 | 32 |
| 1997 | 17 |
| 1998 | 27 |
| 1999 | 29 |
| 2000 | 17 |
| 2001 | 25 |
| 2002 | 27 |
| 2003 | 30 |
| 2004 | 27 |
| 2005 | 22 |
| 2006 | 24 |
| 2007 | 29 |
| 2008 | 28 |
| 2009 | 13 |
| 2010 | 8 |
| 2011 | 17 |
| 2012 | 25 |
| 2013 | 10 |
| 2014 | 24 |
| 2015 | 23 |
| 2016 | 12 |
| 2017 | 19 |
| 2018 | 20 |
| 2019 | 15 |
| 2020 | 17 |
| 2021 | 15 |
| 2022 | 21 |
| 2023 | 19 |
| 2024 | 11 |
| 2025 | 18 |
| 2026 | 17 |
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 year(c.\"eventDate\") = 1989
AND c.\"eventStateOrRegion\" = 'AL' AND c.\"eventCountry\" = 'USA'
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 year(c."eventDate") = 1989 AND c."eventStateOrRegion" = 'AL' AND c."eventCountry" = 'USA' 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 ATL90LA039Accident · No injuriesLimited investigationFinal reportBeech B19 · Muscle Shoals, ALThe premature flare initiated by the student pilot and the flight instructor's delay in taking remedial action, which led to an inadvertent stall and a hard landing.NTSB ATL90LA042Accident · No injuriesLimited investigationFinal reportBell TH-1 · Creola, ALThe loss of engine power due to a #21 bearing failure. The bearing failed as a result of inadequate maintenance. A factor in the accident was the pilot operating the helicopter within the avoid operating envelope.NTSB ATL90LA035Accident · Serious injuriesLimited investigationFinal reportWaco HRE · Alexander City, ALAn engine failure due to separation of the magneto as a result of a broken mounting stud. The mounting stud most likely failed due to vibrations induced by an inadequately balanced crankshaft.NTSB ATL90LA030Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B1 · Ewell, ALThe loss of engine power, for undetermined reasons, at low altitude during a practice autorotation. Contributing to the accident was the instructor's failure to properly plan the demonstrated autorotation so as to preclude an accident, in the event that power…NTSB ATL90FA024Accident · 4 fatalField investigationFinal reportBeech C90 · Gadsden, ALFailure of the pilots of both aircraft to maintain adequate visual lookout to see-and-avoid the other aircraft.NTSB ATL90DKJ02Accident · No injuriesFinal reportBell 47G2 · Wettumpka, ALThe pilot's failure to avoid obstacles during aerial application maneuvering.NTSB ATL90LA019Accident · No injuriesLimited investigationFinal reportCessna 177RG · Albertville, ALThe failure of maintenance personnel to properly inspect the magneto during a recent annual inspection.NTSB ATL90FA007Accident · 2 fatalField investigationFinal reportVultee BT-13 · Axis, ALThe aircraft inadvertently entered a stall, when the pilot/passenger had a heart attack. A factor related to the accident was: lack of altitude for the pilot-in-command to recover from the stall.NTSB ATL90DKJ01Accident · No injuriesFinal reportSteen Skybolt · Bessemer, ALThe improper use of the flight controls by the pilot in command during an aerobatic maneuver. While attempting a snap roll, the pilot failed to introduce sufficient elevator input to complete the maneuver.NTSB ATL89LA215Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Semmes, ALImproper replacement of the fuel cap gasket by the pilot, which resulted in a blocked fuel cap vent and fuel starvation. Trees in the emergency landing area contributed to aircraft damage.NTSB ATL89FA214Accident · 3 fatalField investigationFinal reportPiper PA-28R-180 · Gordon, ALThe improper installation of the fuel gascolator bowl by maintenance personnel, which resulted in fuel leakage and a loss of fuel pressure to the engine.NTSB ATL89LA210Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260 · Hanceville, ALImproper flare by the pilot/owner and his failure to obtain/maintain proper airspeed for the go-around; and inadequate supervision and remedial action by the instructor pilot (other crew member). The uneven surface of the private strip was a contributing…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 ATL89FA200Accident · No injuriesField investigationFinal reportBell 206B · Fruithurst, ALPilot's failure to maintain main rotor RPM while executing an autorotation which resulted in a hard landing. Contributing to the accident was the pilot's failure to follow autorotation procedures after the reported engine failure.NTSB ATL89DKJ09Accident · 1 fatalFinal reportCessna 188B · Prattville, ALFailure of the pilot to maintain clearance from obstructions (trees).NTSB ATL89DKJ08Accident · Serious injuriesFinal reportCessna A188B · Atmore, ALPilot's failure to maintain visual lookout for obstacles. Contributing to the accident was the low (dawn) position of the sun which interfered with the pilot's vision.NTSB ATL89LA184Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Alabaster, ALThe glider pilot's poor evaluation of area weather conditions during the flight, which necessitated an off-airport precautionary landing and led to a collision with rough terrain during the landing rollout. Factors contributing to the accident were the…NTSB ATL89DKJ07Accident · 1 fatalFinal reportCessna A188B · Town Creek, ALThe inadvertent stall at an altitude inadequate to effect a safe recovery.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 ATL89DKJ06Accident · Serious injuriesFinal reportPiper PA-25-235 · Goodway, ALThe in-flight separation of the left wing which failed because of a corrosion induced fatigue fracture.NTSB ATL89LA168Accident · No injuriesLimited investigationFinal reportCessna 172 · Centreville, ALThe student pilot's failure to remove all remaining water from the airplane fuel system during pre-flight inspection which led to a total loss of power.NTSB ATL89FA163Accident · 1 fatalField investigationFinal reportCessna 172F · Vernon, ALImproper maintenance of the spark plugs by the pilot/mechanic which resulted in a partial loss of engine power, and the pilot's failure to clear trees during an emergency landing in an open field resulting in an inadvertent stall.NTSB ATL89LA170Accident · No injuriesLimited investigationFinal reportCessna R172E · Birmingham, ALImproper flare by the pilot, which resulted in a hard landing. The fact that the pilot was asked twice to expedite the landing created pressure on the pilot and was considered to be a factor.NTSB ATL89DKJ05Accident · Minor injuriesFinal reportHadley Teenie TWO · Guntersville, ALUndetermined. Factors related to the accident were: lack of a suitable landing area, high obstructions, and a dirt bank.NTSB ATL89DKJ04Accident · 2 fatalFinal reportGlassair III · Auburn, ALThe pilot's premature lift-off which resulted in a stall into trees.NTSB ATL89DKJ03Accident · No injuriesFinal reportGrumman G-164A · Loxley, ALThe loss of engine power due to carburetor ice, and the pilot's improper use of carburetor heat.NTSB ATL89LA145Accident · No injuriesLimited investigationFinal reportHughes 269A · Ozark, ALThe pilot's excessive use of the cyclic control and the misjudged flare during a practice touchdown autorotation.NTSB ATL89FA113Accident · 1 fatalField investigationFinal reportBeech F33A · Ashland, ALThe pilot continued VFR flight into instrument meteorological conditions (IMC). Factors related to the accident were: high terrain, the adverse weather conditions, and trees.NTSB ATL89DKJ02Accident · No injuriesFinal reportAircraft Parts & Dev. A-9B · Athens, ALThe pilot's inadequate preflight preparation/planning to assure sufficient runway length for clearing obstructions.NTSB ATL89LA085Accident · No injuriesLimited investigationFinal reportCessna 177B · Oneonta, ALInadequate preflight by the pilot and fuel exhaustion. Trees contributed to the aircraft damage.NTSB ATL89FA078Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Bagley, ALInadequate maintenance by other maintenance personnel which allowed a foreign object to remain in the engine and damage/short the spark plugs in the #2 and #3 cylinders. Trees in the emergency landing area contributed to the accident. If shoulder harnesses…NTSB ATL89LA076Accident · No injuriesLimited investigationFinal reportBeech A90 · Montgomery, ALThe instructor pilot (CFI) inadvertently actuated the landing gear handle to the up position.NTSB ATL89LA067Accident · No injuriesLimited investigationFinal reportCessna 152 · Theodore, ALPilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall, and subsequent collision with the ground.