Fatal NTSB investigations, AL
35 cases where the first occurrence was “In flight encounter with weather”.
Cases per year
| 1982 | 3 |
|---|---|
| 1984 | 3 |
| 1985 | 2 |
| 1986 | 4 |
| 1987 | 1 |
| 1989 | 1 |
| 1991 | 2 |
| 1992 | 1 |
| 1993 | 2 |
| 1994 | 5 |
| 1998 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2003 | 2 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 2 |
| 2007 | 2 |
Where
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\" = 240)
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."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" = 240) 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 NYC07FA226Accident · 1 fatalField investigationFinal reportPiper PA-32R-301 · Whitfield, ALThe pilot’s intentional flight into known thunderstorms.NTSB ATL07FA038Accident · 2 fatalField investigationFinal reportCessna 172K · Bessemer, ALThe non-instrument-rated pilot's continued visual flight rules flight into instrument meteorological conditions.NTSB ATL07FA005Accident · 1 fatalField investigationFinal reportBeech BE-19A · Gunthertown, ALThe pilot's continued flight from VMC into IMC conditions which resulted in an in-flight collision with rising terrain.NTSB ATL06FA076Accident · 2 fatalField investigationFinal reportPiper PA60-602P · Camp Hill, ALThe pilot's continued flight into known thunderstorms resulting in an in-flight break up. A factor in the accident was air traffic controller's failure to issue extreme weather radar echo intensity information displayed on the controller's radar to the pilot.NTSB ATL05FA044Accident · 2 fatalField investigationFinal reportCessna T206H · Huntsville, ALThe pilot's decision to attempt flight into known adverse weather, which resulted in an in-flight encounter with a thunderstorm.NTSB ATL04FA077Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Arlington, ALThe pilots inadequate in-flight planning/decision and his failure to maintain aircraft control, resulting in an in-flight encounter with a thunderstorm and exceeding the design limits of the aircraft.NTSB ATL04FA049Accident · 2 fatalField investigationFinal reportCessna 441 · Vestavia Hills, ALThe pilot's failure to maintain adequate airspeed during climb in icing conditions, which resulted in an inadvertent stall / spin of the airplane and subsequent uncontrolled descent and collision with terrain. A factor was the accumulation of airframe ice.NTSB ATL03FA075Accident · 2 fatalField investigationFinal reportCessna 180 · Oxford, ALThe pilot's continued VFR flight into IMC conditions and his failure to maintain obstacle clearance. A factor was low ceilings.NTSB ATL01FA036Accident · 5 fatalField investigationFinal reportCessna 421 · Munford, ALThe pilot continued visual flight into instrument weather conditions that resulted in the inflight collision with a river bank. Factors were reduced visibility and dark night.NTSB MIA00FA029Accident · 2 fatalField investigationFinal reportHughes 369HS · Helena, ALThe pilots continued visual flight rules flight into instrument meteorological conditions resulting in his becoming spatially disoriented and loosing control of the helicopter, which resulted in an uncontrolled descent and impact with the ground.NTSB MIA98LA160Accident · 2 fatalLimited investigationFinal reportM2 Sport 1000 · Semmes, ALThe pilot's failure to maintain control of the aircraft after an encounter with turbulence during initial climb out. A related factor was the turbulence.NTSB MIA95FA037Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Sylvan Springs, ALPoor in-flight planning/decision by the pilot-in-command for failure to deviate to an alternate airport after encountering icing conditions in an airplane not certificated for flight in icing conditions. Also, failure of the pilot to maintain altitude…NTSB ATL95LA059Accident · 1 fatalLimited investigationFinal reportHayes LONG-EZ · Collinsville, ALThe pilot continued visual flight into instrument weather conditions, and collided with the ground.NTSB ATL94FA131Accident · 2 fatalField investigationFinal reportBeech H-35 · Jackson, ALThe pilot's failure to avoid an area of thunderstorm activity, which resulted in a loss of control and the designed structural limits of the airframe being exceeded. The thunderstorms were a factor in the accident.NTSB ATL94FA082Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Opelika, ALLoss of aircraft control for an unknown reason. Factors related to the accident were: the weather conditions (clouds with low ceiling), continued VFR flight by the pilot into instrument meteorological conditions (IMC), the pilot's lack of instrument…NTSB ATL94FA056Accident · 4 fatalField investigationFinal reportCessna P210R · Bay Minette, ALThe pilot's failure to maintain control of the aircraft due to spatial disorientation, and exceeding the design stress limits of the aircraft. Factors related to the accident were: the pilot's flight into known adverse weather conditions, overconfidence in…NTSB ATL94FA023Accident · 1 fatalField investigationFinal reportCessna 172 · Gadsden, ALThe pilot's inadequate pre-flight preparation and his continued visual flight into instrument meteorological conditions. Factors were fog, low ceiling, and hilly terrain.NTSB MIA93FA058Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Brilliant, ALThe pilot-in-command's intentional flight into adverse weather which resulted in a loss of control. In addition, the pilot was overconfident in his ability. Factors which contributed to the accident were the weather conditions and the dark night.NTSB ATL92FA185Accident · 3 fatalField investigationFinal reportPiper PA-28-151 · Samantha, ALThe pilot's inadequate preflight planning and preparation, his lack of expereince, which resulted in an encounter with instrument weather conditions during an attempted visual flight, and his subsequent spatial disorientation. Factors were the dark night…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 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 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 ATL87FA132Accident · 2 fatalField investigationFinal reportAeronca 7BCM · Georgiana, ALThe plts & pax of 2 acft were returning from an annual pleasure trip. Neither acft had a good comm radio. Shortly after takeoff, they enctrd fog. They flew above the wx until they were near their 1st refueling stop (greenville, AL). Both plts dscndd beneath…NTSB ATL87FA042Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Pell City, ALThe aircraft departed albany Georgia for fenton Missouri without a flight plan. VFR not recommended had been given to the commercial, CFI, instrument rated pilot twice during the day. The wreckage was found two months later on the side of a mountain in…NTSB ATL86FA265Accident · 1 fatalField investigationFinal reportCessna A-37A · Yantley, ALThe plt had just purchased the acft which had an experimental airworthiness certificate. During a preflt wx briefing, he was advised of towering cumulus clouds along his route. After takeoff, he initiated a climb to FL 240 & leveled off aprx 10 min later.…NTSB ATL86FA063Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Anniston, ALThe acft was observed flying through the base of the low level cloud layer prior to its impact on the side of a mountain. The plt was not instrument rated, had not filed a flt plan nor obtained a wx briefing. The impact point was several hundred ft below the…NTSB ATL86FA058Accident · 4 fatalField investigationFinal reportCessna 310G · Ragland, ALThe acft with sputtering engs was heard circling overhead in low overcast skies. The horizontal tail surfaces separated in-flt and came to rest aprx 450 ft from the main wreckage in mountainous terrain. The student plt had no instrument experience. The acft…NTSB ATL86FA010Accident · 1 fatalField investigationFinal reportPiper PA-34-220T · Hamilton, ALAt 1450 CDT, while the plt was cruising at 11,000', ARTCC broadcast info concerning SIGMET 17C, warning plts of thunder-storms with tops to FL 450. At 1613, radar data showed the acft at 11,300'. When asked about his alt, the plt replied he was in a cell &…NTSB ATL85FA112Accident · 4 fatalField investigationFinal reportBell 206L · Dauphin Island, ALPlt departed for offshore oil rig 3 times. Two times reported returning due to fog. After third report, plt said he was IFR. No further radio communication. Wreckage indicative of high speed water impact. Dense fog and low ceiling reported offshore south of…NTSB ATL85FA060Accident · 1 fatalField investigationFinal reportCessna 172 · Hamilton, ALInitiated night flt into area of forecast and observed marginal VFR conditions. Expected to encounter 1200 ft ceiling. Plt stated to fss briefer he would go as FAR as he could. Encountered area of patchy grnd fog, reduced visibility, no horizon ahead. Elected…NTSB ATL84FA111Accident · 2 fatalField investigationFinal reportPiper PA-32RT-301T · Goodway, ALPlt received two weather briefings prior to departure. He was told of an approaching cold front but the fss briefer stated 'if you go now, it'll be fine.' The plt departed on the VFR flt to hickory, NC, and did not file a flt plan. Radar info obtained during…NTSB ATL84FA106Accident · 2 fatalField investigationFinal reportBeech A36 · Hamilton, ALThe acft collided with trees aprx 6 miles east of marion cty arpt and aprx 17 NM sw of the flt depat pt and also the plt's home arpt. The plt had earlier that day told the haleyville arpt mgr that he would return to haleyville the same day as dept. The acc…NTSB ATL82FA153Accident · 1 fatalField investigationFinal reportCessna 172M · Alabaster, ALAt 0755, the plt contacted birmingham approach control & reported 35 mi south at 2,000 ft. he was advised of the bhm wx & that it was IFR at the arpt. The pilot stated he would like to land at another arpt & was given his approximate position to three arpts.…NTSB ATL82FA057Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Hytop, ALThe pilot filed and departed VFR into forecast marginal flight conditions. While en route the destination went IFR and this information was passed on to the pilot. The pilot replied that he was going to continue on and get as close to chattanooga as possible.…NTSB ATL82FA037Accident · 4 fatalField investigationFinal reportCessna 210L · Madison County, ALThe aircraft departed destin, FL at 1554 CST on a flight to tullahoma, TN. The estimated time en route was listed on the flight plan as 2.5 hrs with 4.5 hours fuel on board. During arrival at tullahoma, the pilot initiated a vor/dme-b approach, but executed a…