NTSB investigations
35,883 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.\"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."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 CEN24LA155Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32-301 · Sullivan, MOA bearing failure that resulted in fatigue failure of the crankshaft and a subsequent total loss of engine power.NTSB GAA24WA140Accident · No injuriesClass 3 · ForeignBell 407 · Chicureo, ChileNTSB DCA24WA153Incident · No injuriesClass 5 · ForeignBoeing 737 · Maiquetía, VenezuelaNTSB ERA24LA166Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Key Biscayne, FLA loss of engine power for reasons that could not be determined.NTSB WPR24LA121Accident · No injuriesClass 3 · LimitedFinal reportKitfox Series 5 · Yucca Grove, CAThe pilot’s improper repair of the oil sump, which resulted in a loss of oil pressure and collision with terrain during a precautionary landing.NTSB ERA24LA163Accident · Serious injuriesClass 3 · LimitedFinal reportEvektor-Aerotechnik A S Harmony LSA · Seffner, FLThe improper installation of the fuel line that connected the fuel pump to the four-way distributor, which resulted in fuel starvation when the line became disconnected.NTSB CEN24LA147Accident · Minor injuriesClass 3 · LimitedFinal reportBellanca 7KCAB · Bluff Dale, TXAn engine compartment fire for reasons that could not be determined due to extensive thermal damage.NTSB DCA24LA144Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 717-200 · Cecil, NCAn encounter with clear air turbulence.NTSB DCA24FA143Accident · Serious injuriesClass 3 · FieldFinal reportBoeing 737-7CT · Gulf of America (Gulf of Mexico)The pilot’s inadvertent encounter with convectively induced turbulence from a broken line of embedded thunderstorms moving across the region. Contributing to the accident was the failure of the air traffic controller to issue pertinent weather information…NTSB GAA24WA135Accident · No injuriesClass 5 · ForeignCessna 152 · Balneario Laguna de Gómez, ArgentinaNTSB CEN24LA146Accident · No injuriesClass 3 · LimitedFinal reportSchweizer G-164B · Kaplan, LAA partial loss of engine power for reasons that could not be determined.NTSB CEN24LA145Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M20E · Alpine, ARThe improper maintenance of the cabin air and exhaust system which resulted in a cracked exhaust pipe and damaged cabin air tubing, and the subsequent elevated carbon monoxide levels in the cockpit and a forced landing to unsuitable terrain after the pilot…NTSB DCA24WA140Accident · Serious injuriesClass 5 · ForeignBoeing 787 · Narita, JapanNTSB GAA24WA134Accident · 1 fatalClass 5 · ForeignReims Cessna FR172F · Tyrol, AustriaNTSB ERA24LA159Accident · Serious injuriesClass 3 · LimitedFinal reportDta Voyager II 912S · Clermont, FLLack of lubrication of the No. 4 connecting rod bearing, which resulted in a total loss of engine power.NTSB GAA24WA159Accident · 1 fatalClass 5 · ForeignCessna 152 · Tolima, ColombiaNTSB GAA24WA133Accident · 1 fatalClass 4 · ForeignCessna 172 · La Linea, ChileNTSB ERA24LA158Accident · Serious injuriesClass 3 · LimitedFinal reportJmmt Vans RV9A · Jasper, GAThe total loss of engine power due to fuel starvation for reasons that could not be determined due to impact-related damage.NTSB CEN24LA143Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 407 · Moran, KSAn in-flight collision with birds while in cruise flight.NTSB DCA24WA154IncidentClass 5 · ForeignBoeing 737 · Madrid, SpainNTSB DCA24LA135Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 757-232 · Lakeland, GAAn inadvertent encounter with convective turbulence that resulted in a serious injury to a flight attendant.NTSB DCA24WA332Incident · No injuriesClass 5 · ForeignBoeing 777 · Madinah, Saudi ArabiaNTSB CEN24LA141Accident · No injuriesClass 3 · LimitedFinal reportCozy Mark IV · Gonzales, TXMaintenance personnel’s failure to properly torque the crankshaft idler gear hardware according to the engine manufacturer’s service instructions, which resulted in separation of the crankshaft idler gear’s fasteners and disengagement of the camshaft,…NTSB CEN24LA140Accident · No injuriesClass 3 · LimitedFinal reportCessna T210 · San Saba, TXA total loss of engine power due to multiple connecting rod failures from oil starvation.NTSB DCA24WA162IncidentClass 5 · ForeignBoeing 777 · Mumbai, IndiaNTSB GAA24WA122Accident · 4 fatalClass 3 · ForeignBeech C90 · Santa Rosa de Osos, ColombiaNTSB DCA24WA145AccidentClass 5 · ForeignBoeing 787 · Tokyo, JapanNTSB GAA24WA146AccidentClass 5 · ForeignCessna 182 · Manuel Urbano, BrazilNTSB GAA24WA116Accident · No injuriesClass 5 · ForeignCessna U206 · Waramasen Indigenous Community, VenezuelaNTSB ERA24LA143Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Blackshear, GAA catastrophic engine failure due to oil starvation, which resulted in a total loss of engine power.NTSB WPR24LA114Accident · No injuriesClass 4 · LimitedFinal reportMooney M20K · Farmington, CAThe pilot’s improper preflight fuel planning that resulted in the loss of engine power due to fuel exhaustion.NTSB ERA24LA141Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Winokur, GAA total loss of engine power due to the unseating and subsequent failure of the No. 4 piston connection rod bushing.NTSB DCA24LA130Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-800 · Paris, TNAn encounter with convective turbulence.NTSB ERA24LA173Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Pembroke Pines, FLAn inflight collision with a bird while approaching the destination airport.NTSB ERA24LA144Accident · No injuriesClass 3 · LimitedFinal reportGlasair Sportsman 2+2 · Fort Meade, FLThe pilot’s inadequate inspection of the airplane following an inflight smoke event, which result in separation of the exhaust pipe and hot exhaust igniting the engine cowling, and a subsequent loss of engine power.NTSB WPR24LA109Accident · No injuriesClass 3 · LimitedFinal reportRaytheon B200 · Billings, MTThe pilot's improper engine start, resulting in the engine starters remaining engaged and the generators not being activated, which led to the discharge of the airplane’s battery and subsequent total electrical failure after takeoff. Contributing to the…NTSB ERA24LA139Accident · No injuriesClass 3 · LimitedFinal reportBeech K35 · Front Royal, VAA total loss of engine power due to fuel starvation as a result of the pilot’s mismanagement of the airplane’s fuel supply.NTSB DCA24WA125Accident · Serious injuriesClass 3 · ForeignBoeing 787 · Auckland, New ZealandNTSB WPR24FA105Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-32-260 · Madras, ORThe pilot’s continued visual flight rules flight into instrument meteorological conditions, which resulted in an encounter with turbulence and structural icing conditions, loss of control, and subsequent impact with terrain.NTSB ERA24LA134Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150 · Clay, KYThe pilot’s decision to attempt a VFR flight in instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s impairment due to alcohol consumption.NTSB DCA24LA124Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · Aylett, VAAn encounter with clear air turbulence during descent.NTSB GAA24WA105IncidentClass 5 · ForeignCessna 150 · Budaors, HungaryNTSB CEN24FA125Accident · 2 fatalClass 3 · FieldFinal reportGlobe GC-1B · Afton, MNThe pilot’s failure to maintain airplane control while maneuvering, which resulted in an aerodynamic stall and spin.NTSB GAA24WA107Accident · Minor injuriesClass 5 · ForeignCessna 150 · Warsaw, PolandNTSB GAA24WA106Accident · No injuriesClass 5 · ForeignBell 206 · Narsaq, GreenlandNTSB ANC24LA017Accident · Serious injuriesClass 3 · LimitedFinal reportMD Helicopter 369E/500E · Kekaha, HIMaintenance personnel’s noncompliance with maintenance manual procedures that required the removal of the overrunning clutch output bearing during the regreasing procedure, which resulted in inadequate regreasing of the bearing and the subsequent failure of…NTSB GAA24WA160AccidentClass 5 · ForeignRans S6 · Newtownards, United KingdomNTSB GAA24WA104IncidentClass 5 · ForeignCessna 152 · Hampshire, United KingdomNTSB ERA24LA122Accident · No injuriesClass 3 · LimitedFinal reportBellanca 17-30A · Cape Coral, FLA total loss of engine power due to fuel starvation as a result of the pilot’s failure to properly secure a fuel supply line.NTSB ERA24LA117Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Dunnellon, FLThe pilot’s inadequate preflight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.