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 ERA17LA098Accident · Minor injuriesLimited investigationFinal reportCessna P210 · Pottsville, PAA total loss of engine power for reasons that could not be determined because postaccident examinations of the engine and airframe did not reveal any preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN17LA089Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Butterfield, TXA malfunction of the fuel transfer system for reasons that could not be determined based on the available information, a stuck float in the header tank sight gauge that resulted in an inaccurate fuel quantity indication, and the pilot’s inadequate monitoring…NTSB CEN17IA094Incident · No injuriesClass 2 · IncidentFinal reportEurocopter Deutschland MBB BK 117 C-2 · Sioux Falls, SDThe gas generator rear bearing oil scavenge line blocked with coke, which resulted in a failed rear bearing due to an excess of oil lubrication. Contributing to the incident was the operator not completely performing the maintenance items and not utilizing an…NTSB WPR17LA058Accident · No injuriesLimited investigationFinal reportBeech E17L · Discovery Bay, WAA loss of engine power for reasons that could not be determined based on the available information.NTSB GAA17CA121Accident · No injuriesData collectionFinal reportCessna 150 · Denton, TXThe pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ENG17IA008Incident · No injuriesIncident investigationFinal reportBombardier CL 600 2B19 · Baltimore, MDA Bombardier CRJ200 No. 2 engine failure due to the separation of a fan blade airfoil at a low cycle fatigue crack that originated at the forward fan blade pin hole attachment. The separated fan blade had previously undergone a hot form repair and both…NTSB CEN17LA081Accident · No injuriesLimited investigationFinal reportBellanca 17 30 · Kidron, OHMaintenance personnel’s failure to properly secure the vacuum pump, which resulted in a loss of engine oil and the subsequent total loss of engine power due to oil starvation.NTSB ANC17TA015Accident · Serious injuriesFinal reportPiper PA-32 · Pilot Point, AKThe pilot's continued flight into known icing conditions, which resulted in structural icing and a forced landing on icy, snow-covered terrain.NTSB DCA17WA139Accident · No injuriesForeign investigationBoeing 737 · Manchester, United KingdomThe Air Accidents Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of an accident involving a Boeing 737-800, which occurred on January 14, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation…NTSB WPR17FA052Accident · 1 fatalField investigationFinal reportPiper PA 28-236 · Port Orford, ORThe pilot's loss of vision during cruise flight, which resulted in a loss of aircraft control. Contributing to the accident was the pilot's decision to fly with a known medical condition.NTSB WPR17FA055Accident · 1 fatalField investigationFinal reportMooney M20J · Lake Hughes, CAThe pilot's controlled flight into mountainous terrain while attempting to operate under visual flight rules in instrument meteorological conditions (IMC).NTSB CEN17LA076Accident · No injuriesLimited investigationFinal reportCessna 182T · Green Bay, WIThe airplane’s encounter with unforecast icing conditions, which led to structural icing that obscured the pilot’s vision, an aerodynamic stall, and a subsequent hard landing.NTSB DCA17WA094Accident · No injuriesForeign investigationCanadair CL604 · Arabian Sea, A1The German Federal Bureau of Aircraft Accident Investigation (BFU) has notified the NTSB of an accident involving a Canadair CL-604, which occurred on January 7, 2017. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of…NTSB CEN17LA073Accident · No injuriesLimited investigationFinal reportCirrus SR22 · Meeker, COA partial loss of engine power due to fuel contamination from an undetermined source.NTSB CEN17FA071Accident · 2 fatalField investigationFinal reportColumbia Aircraft Mfg LC41 550FG · Gurdon, ARThe loss of control in flight for reasons that could not be determined because of the severe impact and postcrash fire damage to the airplane and the lack of information about the airplane emergency that the pilot was experiencing.NTSB WPR17LA046Accident · Serious injuriesLimited investigationFinal reportSoftex Invest V-24L · Paradise, MTA partial loss of power during cruise flight for reasons that could not be determined because postaccident examination of the engines did not reveal evidence of any preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR17FA045Accident · 4 fatalField investigationFinal reportCessna T210K · Payson, AZThe non-instrument-rated pilot's improper decisions to begin and to continue a flight under visual flight rules into instrument meteorological conditions, which resulted in controlled flight into terrain.NTSB CEN17LA079Accident · No injuriesLimited investigationFinal reportQuicksilver GT-400 R503 · New Braunfels, TXThe partial loss of engine power due to a loose spark plug. Contributing to the accident was the pilot's improper preflight inspection of the airplane.NTSB CEN17LA066Accident · Serious injuriesLimited investigationFinal reportGosselin Charles Glastar · Lee's Summit, MOPartial failure of the electric system due to a battery short, which resulted in a total loss of engine power.NTSB CEN17FA064Accident · 4 fatalField investigationFinal reportPiper PA 28R-200 · Vienna, ILThe non-instrument rated pilot's decision to descend through an overcast layer of weather during dark night conditions, which resulted in the airplane impacting trees.NTSB WPR17FA044Accident · 4 fatalField investigationFinal reportCessna 182 · Dabob, WAThe non-instrument-rated pilot's decision to continue a night visual flight rules into instrument flight rules conditions, which resulted in spatial disorientation and a loss of airplane control. Contributing to the accident was the pilot's failure to obtain…NTSB WPR17LA050Accident · No injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 40 NG · Kingman, AZThe loss of engine oil pressure during cruise flight, which resulted in partial loss of engine power and necessitated a forced landing. The loss of oil pressure was the result of a failed engine piston, likely initiated by foreign object damage, which…NTSB DCA17WA086Incident · No injuriesForeign investigationBoeing 737 · Bucharest, RomaniaThe Romania Civil Aviation Safety Investigation and Analysis Center has notified the NTSB of an incident involving a Boeing 737, which occurred on December 29, 2016. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO…NTSB ERA17FA073Accident · 3 fatalField investigationFinal reportCessna 182 · Gatlinburg, TNThe non-instrument-rated pilot's intentional visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pilot's established anti-authority attitude.NTSB GAA17CA098Accident · Serious injuriesData collectionFinal reportCessna 182 · Apple Valley, CAThe pilot’s mismanagement of the available fuel, which resulted in a loss of engine power and a subsequent hard, off-airport landing and nose-over.NTSB ERA17LA071Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Palm Bay, FLUnknown maintenance personnel’s improper routing of electrical wires in the engine compartment, which resulted in chafing and a subsequent in-flight fire.NTSB CEN17LA058Accident · No injuriesLimited investigationFinal reportBellanca 17 30A · Blaine, MNA total loss of engine power due to a lack of crankshaft lubrication to the No. 4 connecting rod journal.NTSB OPS17IA010Incident · No injuriesIncident investigationFinal reportBoeing 777 · Mt. Wilson, CAThe incident was caused by the air traffic controller assigning the pilots a left turn instead of the required right turn after departure which placed the aircraft in an unsafe proximity with terrain and obstructions. Contributing to the incident was the air…NTSB ANC17FA012Accident · 2 fatalField investigationFinal reportPiper PA 11 · Aniak, AKThe pilot's intentional flight of the airplane into terrain in an act of suicide.NTSB DCA17CA042Accident · Serious injuriesData collectionFinal reportBoeing 737 824 · Denver, COAn inadvertent encounter with mountain wave turbulence.NTSB WPR17LA036Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T210M · Mecca, CAThe total loss of engine power due to fuel starvation during approach, which necessitated a gear-up landing on unsuitable terrain.NTSB ERA17LA069Accident · No injuriesLimited investigationFinal reportBeech A36 · Shoreham, NYA fatigue crack of the crankshaft at the No. 4 main bearing journal.NTSB CEN17WA222Accident · 2 fatalForeign investigationPiper PA38 · Ingenio La Cabana, El SalvadorOn December 11, 2016, a Piper PA-38, YS-332-PE, crashed near Ingenio La Cabana, El Salvador, a 0715 local time and was destroyed. The flight instructor and student pilot were fatally injured. The accident investigation is under the jurisdiction and control of…NTSB CEN17FA053Accident · 1 fatalField investigationFinal reportAircraft Mfg & Design CH601XL Slsa · Marengo, ILA loss of control in flight for reasons that could not be determined because no anomalies consistent with a preimpact failure or malfunction were identified during the investigation.NTSB ENG17RA010Accident · No injuriesForeign investigationATR ATR42 · Havelian, PakistanPakistan has notified the NTSB of an accident involving an ATR 42-500 that occurred on December 7, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the Pakistan Safety Investigation Board investigation under the provisions of ICAO Annex…NTSB ANC17FA010Accident · 4 fatalField investigationFinal reportPiper PA 28-180 · Port Alsworth, AKUndetermined due to a lack of physical evidence.NTSB WPR17LA031Accident · No injuriesLimited investigationFinal reportPiper PA 31T · Missoula, MTFailure of the left windshield due to moisture ingression into the windshield laminate, which deteriorated the strength of the windshield.NTSB CEN17LA136Accident · No injuriesLimited investigationFinal reportCessna 550 · Port Aransas, TXAn in-flight collision with multiple birds, which resulted in separation of the right engine's fan rotor and subsequent total loss of power of the right engine.NTSB DCA17WA035Accident · Serious injuriesForeign investigationBoeing 777 · Lajes Terceira Island, PortugalThe government of Portugal has notified the NTSB of an accident involving a BOEING 777 airplane that occurred on December 04, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Portugal's investigation under the…NTSB CEN17WA049Accident · 4 fatalForeign investigationBeech E 90 · Toledo, SpainNTSB CEN17LA048Accident · No injuriesLimited investigationFinal reportArion Lightning LS-1 · Goshen, INA partial loss of engine power due to carburetor icing and the subsequent forced landing on a rough/soft field.NTSB GAA17CA088Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA-20 · Payson, UTThe student pilot's improper in-flight fuel planning, which resulted in fuel exhaustion.NTSB DCA17WA219Incident · No injuriesForeign investigationBoeing 737 · Nagpur, IndiaThe Aircraft Accident Investigation Bureau (AAIB) of India has notified the NTSB of an incident involving a ATR-72 airplane that occurred on December 02, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of India's…NTSB CEN17FA046Accident · 1 fatalField investigationFinal reportGordon Pegazair P 100 · Mt Vernon, INThe pilot's failure to maintain airplane control, which resulted in a collision with terrain. Contributing to the accident was the pilot's impairment resulting from the combination of his progressive degenerative neurologic condition and his use of alcohol.NTSB ENG17IA006Incident · No injuriesIncident investigationFinal reportBombardier CL 600 2C10 · Kansas, ILThe probable cause of the uncontained No. 1 (left) engine failure was a separated high pressure turbine 2nd stage blade that failed due to a fatigue crack that originated below the blade platform from an area of corrosion.NTSB ANC17LA008Accident · No injuriesLimited investigationFinal reportAirborne Extreme SQ-12 · Palmer, AKThe fuel injector manufacturer's inappropriate guidance to use a 5-ampere circuit breaker in place of the required 10-ampere circuit breaker on the fuel injector circuit, which resulted in the circuit breaker opening, a loss of electrical power to the…NTSB WPR17LA038Accident · No injuriesLimited investigationFinal reportCessna 182A · Safford, AZThe total loss of engine power due to the failure of the No. 5 piston, piston pin, or connecting rod assembly for reasons that could not be determined due to the severity of the post fracture damage.NTSB ERA17WA055Accident · 1 fatalForeign investigationAyres S2R · Valparaiso, ChileOn November 23, 2016, about 1410 universal coordinated time, an Ayres S2-R, United States registration N5532G, was destroyed when it impacted mountainous terrain near Paso Internacional Los Libertadores, Chile. The pilot was fatally injured. The flight…NTSB WPR17FA025Accident · 1 fatalField investigationFinal reportPiper PA 28-181 · Upland, CAThe pilot's failure to maintain clearance from rising terrain in dark night conditions, which resulted in controlled flight into terrain.NTSB DCA17CA096Accident · Serious injuriesData collectionFinal reportBoeing 717 200 · Hopewell, VAthe flight attendant's inadvertent bump into a retractable galley tray.