NTSB investigations, AL
538 cases where the phase of flight was Enroute.
Cases, newest first
Query with SQL
duckdb -csv -c "WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
current_codes AS (
SELECT e.case_mkey, TRY_CAST(e.\"tier1Number\" AS INTEGER) AS code,
row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e.\"isDefiningEvent\", false) DESC, e.position) AS n
FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
WHERE e.aircrafts_position = 1 AND e.\"tier1Number\" GLOB '[1-9][0-9]*'
AND (e.\"isDefiningEvent\" OR e.case_mkey IN (SELECT \"mKey\" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE \"isPre1982\"))
),
phases AS (
SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
FROM current_codes WHERE n = 1
UNION ALL
SELECT o.case_mkey, 'older', o.\"phaseOfFlightCode\", w.main
FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o.\"phaseOfFlightCode\"
WHERE o.aircrafts_position = 1 AND o.\"occurrenceNumber\" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
),
case_phases AS (
SELECT p.*, c.\"eventDate\", c.\"highestInjuryLevel\" = 'Fatal' AS fatal, a.aircraft_model_code
FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = p.case_mkey
LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
WHERE c.\"eventDate\" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
)
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.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 400)
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.
WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
current_codes AS (
SELECT e.case_mkey, TRY_CAST(e."tier1Number" AS INTEGER) AS code,
row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e."isDefiningEvent", false) DESC, e.position) AS n
FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
WHERE e.aircrafts_position = 1 AND e."tier1Number" GLOB '[1-9][0-9]*'
AND (e."isDefiningEvent" OR e.case_mkey IN (SELECT "mKey" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE "isPre1982"))
),
phases AS (
SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
FROM current_codes WHERE n = 1
UNION ALL
SELECT o.case_mkey, 'older', o."phaseOfFlightCode", w.main
FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o."phaseOfFlightCode"
WHERE o.aircrafts_position = 1 AND o."occurrenceNumber" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
),
case_phases AS (
SELECT p.*, c."eventDate", c."highestInjuryLevel" = 'Fatal' AS fatal, a.aircraft_model_code
FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = p.case_mkey
LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
WHERE c."eventDate" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
)
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."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 400)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 ATL04LA029Accident · No injuriesLimited investigationFinal reportYakovlev YAK55M · Troy, ALA loss of engine power due to a fractured connecting rod for undetermined reasons.NTSB ATL03FA114Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Scottsboro, ALThe pilot's improper fuel management which resulted in a loss of engine power due to fuel starvation and subsequent impact with trees.NTSB ATL03LA152Accident · 2 fatalLimited investigationFinal reportChinook Plus 2 A13-SWB · Elsanor, ALThe loss of engine power for undetermined reasons.NTSB ATL03LA103Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hamilton, ALThe pilot's inadequate preflight inspection by his failure to ensure adequate oil supply, which resulted in oil exhaustion and the failure of the connecting rod cap.NTSB ATL03LA102Accident · No injuriesLimited investigationFinal reportCollier Quickie · Alexander, ALThe loss engine of power due to undetermined reasons.NTSB ATL03LA086Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Montgomery, ALThe in-flight collision with birds that resulted in a partial loss of engine power, and subsequent in-flight collision with trees while maneuvering for an emergency landing.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 ATL03IA073Incident · No injuriesIncident investigationFinal reportCessna 182P · Eufaula, ALFatigue failure of end rib for the left canard flap.NTSB ATL03LA059Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Gordo, ALFatigue failure of the crankshaft.NTSB ATL03FA008Accident · 1 fatalField investigationFinal reportCessna 208B · Spanish Fort, ALthe pilot's spatial disorientation, which resulted in loss of airplane control. Contributing to the accident was the night instrument meteorological conditions with variable cloud layers.NTSB ATL02LA159Accident · Serious injuriesLimited investigationFinal reportSchweizer 300C · Haleyville, ALThe failure of maintenance personnel to perform an adequate inspection of loose intake components, which resulted in a total loss of engine power and subsequent emergency descent, forced landing, and collision with terrain in dark night conditions.NTSB ATL02FA143Accident · 2 fatalField investigationFinal reportCessna 150G · Duncanville, ALThe pilot's failure to maintain airspeed , which resulted in an inadvertent stall, and subsequent collision with the ground. A contributing factor was low level flight.NTSB ATL02LA134Accident · Serious injuriesLimited investigationFinal reportFay Velocity Elite · Theodore, ALThe pilot's inadequate inflight planning for required fuel resulted in fuel exhaustion and the subsequent loss of engine power. A factor was unsuitable terrain.NTSB MIA02LA092Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Headland, ALa loss of engine power for undetermined reason resulting in damage to the airplane during the subsequent forced landing.NTSB ATL02IA079Incident · No injuriesIncident investigationFinal reportRockwell International 500-S · Jackson, ALThe pilot's inadequate preflight planning and preparation, which resulted in fuel exhaustion, loss of engine power in both engines, and subsequent forced landing in a field.NTSB MIA01LA197Accident · No injuriesLimited investigationFinal reportCessna 182B · Headland, ALThe pilot's improper decision to perform a go-around while on short final to an available runway following loss of engine power for undetermined reasons when engine power was regained momentarily, which resulted in an impact with terrain while maneuvering at…NTSB ATL01LA057Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Pell City, ALThe pilot's selection of the wrong runway that resulted in an attempted takeoff with a tailwind.NTSB MIA01LA127Accident · No injuriesLimited investigationFinal reportChristen Industries Eagle II · Alexander City, ALA total loss of engine power during cruise flight due to an internal disconnection in the fuel injector control assembly as a result of a failure of the maintenance facility to follow proper installation procedures, resulting in a forced landing and collision…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.NTSB MIA01LA081Accident · No injuriesLimited investigationFinal reportCessna 182H · Weaver, ALDamage to the No. 4 cylinder intake valve push rod tube at an undetermined time which resulted in the push rod rubbing on the push rod tube and failing due to wear, resulting in loss of engine power and damage to the airplane during a forced landing in a…NTSB ATL01FA019Accident · 1 fatalField investigationFinal reportCessna 206H · Vandiver, ALThe pilot's inflight decision to continued visual flight into instrument meteorological conditions resulted in the inflight collision with trees. Low ceilings and trees were factorsNTSB MIA01LA058Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Pittsview, ALThe failure of the pilot to conduct proper preflight planning, resulting in loss of engine power while in cruise flight due to fuel exhaustion, and the subsequent emergency descent and landing to an open field.NTSB ATL01IA001Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas MD-80 · Birmingham, ALThe failure of maintenace personnel to follow fleet campaign directive on how to install a certificate holder.NTSB MIA00LA253Accident · Minor injuriesLimited investigationFinal reportAero Commander 100 · Chatom, ALthe pilot's improper preflight planning/decision and failure to ensure an adequate supply of fuel to safely complete the flight to his destination with adequate fuel reserves, which resulted in fuel exhaustion, subsequent engine failure, and a forced landing…NTSB MIA00LA196Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA5A · Selma, ALThe improper installation of the engine front crankshaft seal by maintenance personnel resulting in the seal separating, total loss of engine oil, failure of the engine due to oil starvation, and a collision with trees while making a forced landing on…NTSB MIA00FA166Accident · 1 fatalField investigationFinal reportBeech 95-A55 · Aliceville, ALThe in-flight collision with trees then terrain while descending for undetermined reasons.NTSB MIA00LA132Accident · Serious injuriesLimited investigationFinal reportHartline Glastar · Woodstock, ALa total engine failure for undetermined reason, resulting in a forced landing and subsequent impact with a tree.NTSB MIA00LA114Accident · No injuriesLimited investigationFinal reportMckinnis Steen Skybolt · Tuscaloosa, ALa loss of engine power during climb due to fuel starvation which was caused by a fuel leak in the gascolator as a result of improper maintenance by the operator that resulted in the pilot making a forced landing during which the airplane sustained substantial…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 MIA00LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Bayou La Batre, ALThe pilot's improper preflight fuel planning and the his improper en route fuel consumption calculations resulting in a total loss of engine power due to fuel exhaustion.NTSB MIA99LA238Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Jackson, ALthe pilot's inadequate preflight planning and preparation, which resulted in taking off with the airplane's maximum gross weight exceeded, and subsequent impact with trees. Factors in this accident were high temperatures and an in-flight encounter with a…NTSB MIA99LA170Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Auburn, ALThe pilot' failure to refuel the airplane prior to fuel exhaustion.NTSB MIA99LA137Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Courtland, ALThe failure of maintenance personnel from Signature Flight Support to assure that a cotter pin was installed at the air throttle assembly lever following installation of the overhauled fuel control valve onto the overhauled engine. This resulted in the…NTSB MIA99LA122Accident · Serious injuriesLimited investigationFinal reportHarris VARI-EZE · Eufaula, ALThe loss of engine power for undetermined reasons.NTSB ATL99LA059Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Florala, ALThe pilot's inadequate preflight inspection, which resulted in a loss of engine power due to fuel system contamination with water.NTSB ATL99LA035Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Hanceville, ALThe loss of engine power for undetermined reasons. Factors were a dark night and terrain condition.NTSB MIA99FA027Accident · 2 fatalField investigationFinal reportCessna C-182Q · Piedmont, ALThe pilot's decision to continue the flight under visual flight rules into deteriorating visibility, and his failure to maintain altitude clearance with the terrain.NTSB MIA99LA007Accident · No injuriesLimited investigationFinal reportAyres S2R · Frisco City, ALThe pilot's failure to maintain airspeed on climb out resulting in an inadvertent stall, and subsequent in-flight collision with terrain.NTSB MIA98FA229Accident · No injuriesField investigationFinal reportBell 47G-4A · Carrollton, ALThe pilots failure to follow written instructions in the flight manual for an engine failure, and the improper use of flight controls (cyclic/collective) during an autorotation resulting in a hard landing, and collision of the main rotor blades with the…NTSB MIA98LA197Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13H/M47A · Citronelle, ALThe pilot's failure to control the helicopter's altitude while overflying an area of rising terrain and trees.NTSB MIA98IA193Incident · No injuriesIncident investigationFinal reportBoeing 737-7H4 · Birmingham, ALThe improper electronic control unit software logic that permitted the electronic control unit to lock on a failed hydromechanical resolver, which failed due to damage to a wire that was incurred during the manufacturing process, resulting in an uncommanded…NTSB ATL98LA084Accident · No injuriesLimited investigationFinal reportBellanca 17-31A · Millry, ALThe fracture of the #2 cylinder connecting rod which resulted in partial loss of engine power and subsequent forced landing. A factor in the accident was the rough terrain.NTSB MIA98LA159Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Luvurne, ALThe loss of engine power due to a leaking engine oil seal, resulting in a forced landing, and subsequent impact with the ground. A factor in this accident was improper maintenance and checks after rebuilding and reinstalling the airplane's engine.NTSB ATL98LA070Accident · No injuriesLimited investigationFinal reportBellanca BL-17-30A · Brewton, ALImproper maintenance procedures used to overhaul the engine, which led to the crankshaft failure. Contributing to the severity of the accident was the fence.NTSB MIA98LA107Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Dauphin Island, ALFailure of the pilot-in-command (CFI) to maintain directional control of the airplane following an intentional low altitude maneuver by the student. Also, altitude inadequate for recovery from the in-flight loss of control.NTSB MIA98FA089Accident · No injuriesField investigationFinal reportFokker F28 MK 0100 · Birmingham, ALWere the 1) the inoperative alternate anti-skid control valve due to the disconnected electrical connector on the parking brake shut-off valve, the area was inspected 2 days earlier 2) the total loss of the hydraulic system resulting in the inability of the…NTSB MIA98FA060Accident · 1 fatalField investigationFinal reportFairchild 24G · Andalusia, ALA loss of engine power while in cruise flight caused by a contaminated fuel supply and the subsequent inflight collision with trees and unsuitable terrain during the emergency descent and landing.NTSB ATL98LA031Accident · No injuriesLimited investigationFinal reportChristopher Coats Challenger II · Evergreen, ALThe undetermined failure of the propeller bolts that resulted in the inflight separation of the propeller assembly. A factor was the overpass bridge.NTSB ATL98LA018Accident · 1 fatalLimited investigationFinal reportJohn T. Simpson Challenger II · Rainbow City, ALThe pilot's failure to maintain adequate airspeed which resulted in a stall and subsequent impact with the ground. A related factor was the pilot's lack of flying experience.NTSB ATL97LA066Accident · No injuriesLimited investigationFinal reportPiper PA-22-180 · Russellville, ALThe loss of engine power for undetermined reasons. A factor was conditions were favorable for the formation of carburetor ice.