NTSB investigations, 1990, 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\") = 1990
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") = 1990 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 ATL91TL#01Accident · No injuriesClass 3Final reportAero Commander 690A · Montgomery, ALNTSB MIA91FA014Accident · 1 fatalField investigationFinal reportDaniel S. Taylor Sonerai II LS · Prattville, ALThe pilot's failure to maintain airspeed. Factors were undetermined loss of engine power and lack of experience in type.NTSB ATL90LA184Accident · No injuriesLimited investigationFinal reportCessna 152 · Dothan, ALThe student pilot's selection of the wrong runway and the subsequent loss of directional control during takeoff. The pilot's improper usage of flight controls, presence of crosswind conditions, and his overall lack of experience were factors in the accident.NTSB ATL90LA182Accident · Serious injuriesLimited investigationFinal reportHelio HST-550A · Mobile, ALThe pilot's intentional attempted takeoff with a known tailwind component. Factors relating to the accident were the tailwind, trees and utility lines on the departure end of the takeoff area.NTSB ATL90LA175Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Midfield, ALThe pilot's inadequate assessment of deteriorating weather conditions and his resultant flight into areas of low clouds. The safety board believes that the pilot's overall lack of experience was a factor in the accident.NTSB ATL90LA173Accident · No injuriesLimited investigationFinal reportCessna A188B · Hertsboro, ALFatigue failure of the propeller blade which resulted from improper overhaul procedures, and the absence of oil in the propeller hub which would allow the detection of blade cracks.NTSB ATL90LA172Accident · No injuriesLimited investigationFinal reportCessna 172RG · Ozark, ALInadequate engine overhaul procedures which allowed the installation of the engine plug without safety wire to hold it in place, and which resulted in oil starvation of the engine.NTSB MIA90FA171Accident · 2 fatalField investigationFinal reportNeal Christen Eagle II · Akron, ALFailure of the pilot to maintain control of the aircraft and to recover from (or avoid) a subsequent (flat) spin. Factors related to the accident were: the pilot's failure to follow established procedures, his lack of familiarity with the aircraft, and the…NTSB ATL90LA155Accident · No injuriesLimited investigationFinal reportCessna 172L · Greensboro, ALThe pilot's failure to maintain proper airspeed and attain the proper touchdown point during the emergency landing.NTSB MIA90FA163Accident · 2 fatalField investigationFinal reportCessna 150J · Baker Hill, ALAn inadvertent stall/spin. Factors were airspeed not maintained, altitude inadequate for safe recovery, and attention diverted.NTSB ATL90DKJ07Accident · Serious injuriesFinal reportBell-Continental Copters 47G · Clayhatchee, ALFailure of the engine magneto(s). The lack of suitable terrain (trees) in the emergency landing area was a related factor.NTSB ATL90LA143Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Fort Payne, ALThe pilot's selection of a runway which afforded a tailwind, and his improper use of the elevator control during the landing roll.NTSB ATL90FA144Accident · 1 fatalField investigationFinal reportCessna 305A · Fruitdale, ALThe pilot exercised poor judgment by attempting to operate the airplane while impaired by alcohol.NTSB ATL90FA141Accident · 1 fatalField investigationFinal reportCessna 150G · Lanett, ALFailure of the pilot to maintain adequate airspeed, which resulted in a stall.NTSB ATL90FA139Accident · 4 fatalField investigationFinal reportPiper PA-38-112 · Florence, ALFailure of the pilot-in-command of N2409K to maintain safe separation from N2437K during unauthorized formation maneuvering. Overconfidence in personal ability and the execution of unauthorized formation flight on the part of both pilots-in-command were…NTSB ATL90DKJ06Accident · 1 fatalFinal reportBreezy MRU · Pell City, ALThe pilot's failure to maintain airspeed.NTSB ATL90LA125Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Montevallo, ALThe inattentiveness of the glider pilot to the aborted takeoff of the tow plane, which resulted in his delayed action in attempting to execute a forced landing. These actions resulted in an inadvertent stall and the aircraft collided with the terrain.NTSB ATL90TL#02Accident · 1 fatalClass 3Final reportHughes TH-55 · Brantley, ALNTSB ATL90FA120Accident · 1 fatalField investigationFinal reportHispano Aviacion HA-200 · Tuskegee, ALImproper in-flight planning/decision by the pilot, and his failure to maintain altitude and clearance above the terrain, while perfoming low altitude, inverted flight. Factors related to the accident were: the lack of visual perception to the pilot at dusk…NTSB ATL90DKJ04Accident · No injuriesFinal report67 Flying Dutchman D1/LFD-13 · Tuscaloosa, ALMaintenance personnel who performed an improper modification of the propeller blade.NTSB ATL90DKJ05Accident · Minor injuriesFinal reportHood Quickie · Altoona, ALThe pilot's inadequate preflight and a blocked fuel vent, which resulted in fuel starvation.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 ATL90FA095Accident · 2 fatalField investigationFinal reportEmbraer EMB-120 · Gadsden, ALInadequate visual lookout by the pilots of both aircraft, which resulted in their failure to see-and-avoid oncoming traffic. A factor related to the accident was: the sun's glare, which restricted the vision of the Cessna 172 pilot.NTSB ATL90LA083Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Gulf Shores, ALFailure of the pilot to obtain proper assistance or properly secure the aircraft when he left it unattended with the engine running.NTSB ATL90LA079Accident · No injuriesLimited investigationFinal reportCessna 182N · Tuscaloosa, ALPilot's failure to maintain an adequate fuel supply, which resulted in fuel exhaustion and engine stoppage.NTSB ATL90FA073Accident · No injuriesField investigationFinal reportMBB BO-105S · Benton, ALThe pilot-in-command's inadequate visual lookout. The incorrect wire survey given by the highway patrol personnel was a related factor.NTSB ATL90FA071Accident · Serious injuriesField investigationFinal reportPiper PA-28-151 · Creola, ALThe pilot's failure to assure that proper maintenance and inspection of the aircraft were completed before flight.NTSB ATL90LA062Accident · Serious injuriesLimited investigationFinal reportCessna 120 · Atmore, ALFuel starvation due to an inadequate preflight and improper positioning of the fuel selector. A factor related to the accident was: rough terrain in the emergency landing area.NTSB ATL90FA055Accident · 1 fatalField investigationFinal reportAmerican AA-1 · Cherokee, ALCarburetor ice due to the pilot's improper use of carburetor heat, and failure of the pilot to maintain control of the airplane after the engine lost power. The weather (carburetor icing) condition was a related factor.NTSB ATL90FA056Accident · Serious injuriesField investigationFinal reportCessna 150F · Weaver, ALThe pilot misjudged distance and altitude to the runway during a simulated engine-out approach, and failed to maintain clearance from trees. Factors related to the accident were: dusk light conditions, and the pilot's lack of recent experience in the make and…NTSB ATL90LA049Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Talladega, ALThe pilot's improper inflight decision to attempt to continue VFR flight IMC conditions with no instrument rating, clearance or experience.NTSB ATL90LA048Accident · No injuriesLimited investigationFinal reportCessna 172B · Killen, ALInadequate pre-flight planning by the pilot in command which resulted in fuel exhaustion during cruise flight.