Final NTSB investigations
34,146 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.\"completionStatus\" = 'Completed'
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."completionStatus" = 'Completed'
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 CEN24LA372Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-46-310P · Eden Prairie, MNThe bird strike during cruise flight that resulted in substantial damage to the airplane.NTSB WPR24LA319Accident · No injuriesClass 3 · LimitedFinal reportBell 206L · Fern Prairie, WAAn aeroelastic interaction between the helicopter’s main rotor blades and nodal beam system, which resulted in oscillations that exceeded the design limits of the tailboom. Contributing to the accident was the failure of the main rotor blade manufacturer to…NTSB CEN24LA370Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-25-235 · Muskogee, OKThe pilot’s inattention to refueling during turn-around operations which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA24FA395Accident · 2 fatalClass 3 · FieldFinal reportEvolution Revo · Zephyrhills, FLThe flight instructor’s failure to ensure the haul back cable was securely connected to the “J” hook prior to departing on the accident flight, which resulted in the cable becoming disconnected and the wings folding up during flight.NTSB WPR24FA309Accident · 1 fatalClass 3 · FieldFinal reportNanchang China CJ-6A · Lancaster, CAThe CJ-6A pilot’s failure to maintain separation and the Yak pilot’s failure to monitor the other airplane during a detachment, which resulted in a midair collision.NTSB CEN24LA364Accident · No injuriesClass 4 · LimitedFinal reportGrumman G-164A · LaPlace, LATotal loss of engine power during the agricultural application flight for reasons that could not be determined.NTSB WPR24LA314Accident · Minor injuriesClass 3 · LimitedFinal reportCessna U206G · West Sacramento, CAFailure of the No. 4 cylinder fuel injection assembly tube and subsequent total loss of engine power.NTSB ERA24LA390Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172K · Fredericksburg, VAThe pilot’s inadequate fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.NTSB DCA24LA316Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 757-224 · Dunnigan, CAThe abrupt pitch control input by the flight crew in response to a TCAS resolution advisory resulted in two serious passenger injuries.NTSB CEN24LA362Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172N · Arboles, COA loss of engine power due to carburetor ice.NTSB ANC24LA097Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-3 · Lime Village, AKThe pilot's inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent forced landing in tree-covered terrain.NTSB ANC24LA093Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 180B · Anchorage, AKThe pilot’s encounter with wake turbulence, which resulted in substantial damage to the airplane.NTSB CEN24LA356Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-12 · Cumberland, WIThe total loss of engine power due to carburetor icing and the pilot’s delayed use carburetor heat in weather conditions conducive to carburetor icing.NTSB CEN24LA354Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 170A · Marshall, INThe fatigue fracture of the No. 6 piston connecting rod, which resulted in a loss of engine power.NTSB WPR24LA305Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20F · Cottonwood, AZThe pilot’s evasive maneuver to avoid birds while on final approach at a low altitude, which resulted in the airplane colliding with a tree.NTSB CEN24LA344Accident · Serious injuriesClass 3 · LimitedFinal reportBellanca 7GCAA · Rifle, COA total loss of engine power for undetermined reasons.NTSB CEN24LA345Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Grand Island, NEThe pilot’s inadequate preflight planning/preparation that resulted in fuel exhaustion during cruise flight, a total loss of engine power, and an impact with terrain during a forced landing.NTSB CEN24LA341Accident · No injuriesClass 3 · LimitedFinal reportTaylorcraft BC12-D · Trojan, SDThe partial loss of engine power due to a loose magneto and subsequent impact with terrain.NTSB ANC24FA089Accident · 1 fatalClass 3 · FieldFinal reportBell 206B · King Salmon, AKThe pilot’s decision to initiate the visual flight into instrument meteorological conditions, which resulted in his spatial disorientation, failure to maintain helicopter control and subsequent impact with water.NTSB WPR24LA302Accident · No injuriesClass 4 · LimitedFinal reportAmazon.Com Services MK30 · Pendleton, ORThe operator’s failure to maintain separation between two drones during dual simulated engine out recoveries, which resulted in a midair collision.NTSB CEN24LA339Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Borger, TXThe pilot’s inadequate fuel management which led to fuel exhaustion.NTSB CEN24LA333Accident · Minor injuriesClass 3 · LimitedFinal reportZenith Zodiac CH601 XL · Odessa, MOOverheating of the engine coolant for reasons that could not be determined, which resulted in a precautionary off-airport landing, during which the airplane sustained substantial damage.NTSB WPR24FA291Accident · 1 fatalClass 3 · FieldFinal reportAmerican Champion 8GCBC · Meeteetse, WYThe pilot’s decision to continue the flight over rising terrain at a low altitude in a high-elevation, high-density-altitude environment.NTSB ERA24LA367Accident · Serious injuriesClass 4 · LimitedFinal reportRedfield Thomas C RV-6A · Trinity, VAThe pilots’ improper in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR24LA300Accident · No injuriesClass 4 · LimitedFinal reportPacific Aerospace 750XL · Mulino, ORThe skydiver’s unintentional parachute deployment and subsequent entanglement with the airplane’s horizontal stabilizer.NTSB WPR24LA294Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8 · Bend, ORA failure of the left fuel valve, which resulted in fuel exhaustion and a total loss of engine power.NTSB ERA24LA359Accident · Minor injuriesClass 4 · LimitedFinal reportChampion 7ECA · Sussex, NJThe pilot’s failure to properly secure the left wing fuel cap, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN24FA327Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-140 · Wayne, NEThe non-instrument-rated pilot’s encounter with instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.NTSB CEN24FA326Accident · 1 fatalClass 3 · FieldFinal reportRans S19 · Crofton, NEThe non-instrument-rated pilot's decision to continue visual flight into an area of low cloud cover and precipitation which resulted in an inadvertent encounter with instrument meteorological conditions and a loss of control due to spatial disorientation.NTSB DCA24LA290Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · Highland Meadows, NMAn encounter with convectively induced turbulence during descent.NTSB DCA24LA293Accident · No injuriesClass 4 · LimitedFinal reportBoeing 747-4HQF · Istanbul, TürkiyeThe fatigue failure of multiple hinge ribs associated with the right outboard aileron, which resulted in abnormal aileron movement and airframe vibration. Contributing to the failure was the mis-rigged condition of the right outboard aileron, which increased…NTSB WPR24LA271Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Manhattan, MTA total loss of engine power due to carburetor icing.NTSB WPR24LA274Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G103 Twin Astir · Minden, NVThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight and a subsequent collision with an obstacle during an off-field landing.NTSB DCA24LA255Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A321-231 · Waycross, GAThe aircraft’s encounter with convectively induced turbulence.NTSB DCA24LA256Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · Severn, MDA passenger’s failure to comply with crew member instructions to remain seated with seatbelt fastened.NTSB DCA24LA254Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 777-223 · Linneus, MOAn inadvertent encounter with convectively induced turbulence during cruise.NTSB WPR24LA269Accident · No injuriesClass 3 · LimitedFinal reportProtech PT2 · Lodi, CAA reported loss of engine power for reasons that could not be determined.NTSB WPR24LA265Accident · Minor injuriesClass 3 · LimitedFinal reportBell 407 · Raft River, IDThe pilot’s misdiagnosis of an erroneous engine instrument indication and his subsequent decision to enter an autorotation, which resulted in a hard landing due to degraded visual cues and low ambient light conditions. Contributing to the accident were the…NTSB CEN24LA301Accident · Minor injuriesClass 3 · LimitedFinal reportTailwind W10 · West Livingston, TXA partial loss of engine power due to carburetor ice.NTSB ERA24LA333Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR20 · Egg Harbor City, NJA partial loss of engine power due to the fatigue failure of the alternate air valve, which separated and partially obstructed the engine’s induction system.NTSB CEN24FA295Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-180 · Irene, SDThe pilot’s poor decision to continue the flight into deteriorating weather conditions and his failure to maintain a safe altitude, which resulted in controlled flight into trees and terrain.NTSB CEN24LA286Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · Radisson, WIThe non-certificated mechanic’s failure to properly tighten and torque the fuel system pressure test port cap, which resulted in a total loss of engine power, and a subsequent forced landing.NTSB WPR24LA261Accident · No injuriesClass 3 · LimitedFinal reportAeronca 11AC · Winchester, CAA total loss of engine power due to a fatigue fracture of the crankshaft.NTSB ERA24LA328Accident · Minor injuriesClass 3 · LimitedFinal reportPiper J3C-65 · Groveland, FLThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN24LA291Accident · No injuriesClass 3 · LimitedFinal reportAyres S2R-G6 · Antioch, NEA total loss of engine power due to fuel contamination from an undetermined source.NTSB ERA24LA311Accident · Serious injuriesClass 3 · LimitedFinal reportChampion 7ECA · Beaufort, NCThe pilot’s inadequate fuel planning and preflight inspection, which resulted in fuel exhaustion, a total loss of engine power, and a forced landing.NTSB ERA24FA309Accident · 1 fatalClass 3 · FieldFinal reportCessna 208 · Youngstown, NYThe pilot’s loss of control in flight which resulted in the airplane impacting the ground at a high rate of speed and descent.NTSB ANC24LA069Accident · 3 fatalClass 3 · LimitedFinal reportBeech A35 · Gustavus, AKThe pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain.NTSB ERA24LA315Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Zephyrhills, FLThe loss of engine power due to the formation of carburetor ice as a result of the pilot’s delayed application of carburetor heat.NTSB WPR24LA248Accident · No injuriesClass 3 · LimitedFinal reportCessna 150M · Ritzville, WAMaintenance personnel’s improper installation of the No. 2 cylinder exhaust valve, which allowed the valve to drop into the cylinder and resulted in a total loss of engine power.