NTSB investigations, 1991, AL
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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\") = 1991
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") = 1991 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 ATL92FA033Accident · 2 fatalField investigationFinal reportBeech C23 · Lineville, ALThe pilot continued VFR into IMC conditions where he collided with trees and terrain. Factors in this accident were: low clouds, obscured terrain, and the pilot's inadequate prelflight planning.NTSB ATL92LA018Accident · Serious injuriesLimited investigationFinal reportGlobe GC-1D · Brewton, ALA blockage of the fuel vent system which prevented the pilot from topping off the fuel system. A factor in this accident was the inadequate design by the manufacturer of the fuel vent system.NTSB ATL92FA013Accident · Serious injuriesField investigationFinal reportBeech 58 · Pelham, ALThe pilot's failure to correct the position of the fuel selector before takeoff, and her inattentiveness to fuel consumption during the flight, which resulted in fuel starvation. Factors were the non-performance of engine out emergency procedures and the…NTSB ATL92LA010Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Selma, ALThe fatigue failure of the engine crankshaft counterweight blade, which resulted from excessive wear of the counterweight pin bushings, due to corrosion from an unknown source.NTSB ATL92LA007Accident · No injuriesLimited investigationFinal reportKaman HH-43B/F · Mt. Vernon, ALA loss of engine power for undetermined reasons. A factor in the accident was the lack of a suitable landing site.NTSB ATL92LA006Accident · No injuriesLimited investigationFinal reportGrumman G164 · Bay Minette, ALThe rough/uneven runway condition caused by the sink hole.NTSB ATL92LA005Accident · No injuriesLimited investigationFinal reportCessna 182 · Pinson, ALThe failure of the pilot to visually detect and attain proper alignment with the runway.NTSB ATL92LA003Accident · Minor injuriesLimited investigationFinal reportCessna 320 · Gadsden, ALFuel starvation due to incorrect fuel line installations, an inoperative fuel boost pump, and incorrect pilot procedure. A factor in this accident was the pilot's intentional operation with a known fuel system deficiency.NTSB ATL91LA178Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Brewton, ALThe inflight separation of the left wing resulting from corrosion of the wing front spar fitting assembly. A factor was inadequate maintenance procedures.NTSB ATL91LA177Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Pleasant Grove, ALThe pilot's failure to refuel the airplane prior to the last takeoff resulting in an inadequate fuel supply for the flight.NTSB ATL91FA176Accident · 2 fatalField investigationFinal reportCessna C-172N · Alabaster, ALThe pilot's failure to maintain flying speed which resulted in an unintentional stall and collision with the ground. A factor was the pilot's use of unprescribed drugs.NTSB ATL91LA174Accident · No injuriesLimited investigationFinal reportCessna 150J · Wilsonville, ALThe pilot's inadequate preflight planning, and his improper use of flaps during the takeoff roll. Factors in the accident were: the high density altitude, the rising runway conditions, and the departure end obstructions at the airstrip.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 ATL91LA143Accident · No injuriesLimited investigationFinal reportHinton Kitfox · Killen, ALWeather conditions conducive to carburetor icing. A factor was the lack of a carburetor heat system on the engine.NTSB ATL91FA138Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Mobile, ALThe failure of the pilot to maintain airspeed and his subsequent inadvertent stall during his attempt to return to the departure runway. A factor was the loss of engine power for undetermined reasons.NTSB ATL91LA129Accident · Minor injuriesLimited investigationFinal reportCessna 210D · Hazel Green, ALThe inadvertent control interference caused when a parachute line became entangled in the right elevator trim tab, after the student jumper exited the airplane.NTSB DCA91MA042Accident · 13 fatalMajor investigationFinal reportBeech C99 · Birmingham, ALThe decision of the captain to initiate and continue an instrument approach into clearly identified thunderstorm activity, resulting in a loss of control of the airplane from which the flightcrew was unable to recover and subsequent collision with obstacles…NTSB ATL91LA119Accident · Serious injuriesLimited investigationFinal reportCessna 188 · Muscle Shoals, ALThe loss of engine power for undetermined reasons.NTSB ATL91LA118Accident · No injuriesLimited investigationFinal reportMaule MXT-180 · Mobile, ALThe pilot's failure to properly compensate for wind conditions. A factor to this accident was the gusting winds.NTSB ATL91LA114Accident · No injuriesLimited investigationFinal reportCessna 182R · Dothan, ALLack of supervision by the flight instructor who allowed a dual student to make a hard landing.NTSB ATL91LA100Accident · No injuriesLimited investigationFinal reportCessna 177B · Huntsville, ALThe pilot's failure to remove the control lock prior to attempting flight and his failure to follow the 'before takeoff' checklist. A factor in the accident was the pilot's diverted attention.NTSB ATL91LA097Accident · No injuriesLimited investigationFinal reportBeech 23 · Dothan, ALThe failure of the cylinder head because of previous overheated operations. Factors in the accident were the pilot's inaccurate approach which resulted in the loss of directional control and subsequent swerve into the fence.NTSB ATL91LA093Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Clanton, ALFailure of the pilot to maintain control of the aircraft during a go-around. The pilot's lack of experience was a related factor.NTSB ATL91LA086Accident · No injuriesLimited investigationFinal reportCessna 182B · Elberta, ALThe pilot's failure to apply carburetor heat. Factors were weather conditions for the formation of induction ice, and the soft terrain.NTSB ATL91LA085Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Bessemer, ALRupture of a high-time, rubber, oil cooler hose, which resulted in a loss of engine oil, oil exhaustion, and seizure of the engine.NTSB ATL91FA069Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Ashland, ALContinued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficience altitude/clearance above the wooded terrain. Factors related to the accident were: the adverse weather conditions, high terrain, and the…NTSB ATL91LA066Accident · 1 fatalLimited investigationFinal reportBenson B8M · Hartselle, ALThe improper installation of the main rotor bearing block by the owner/pilot which resulted in the separation of the main rotor system.NTSB ATL91LA058Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Union Springs, ALThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent ground swerve.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 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.