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 GAA17CA361Accident · No injuriesData collectionFinal reportCessna 182 · Doniphan, MOThe pilot’s improper decision to take off with a known fuel leak, which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA17WA207Accident · No injuriesForeign investigationMD Helicopter 369 · Bultfontein, South AfricaOn June 14, 2017, about 1045 coordinated universal time, an MD Helicopter 369E, South African registration ZT-RAC, was substantially damaged during a forced landing near Bulfontein, South Africa. The pilot and two passengers were not injured. The personal…NTSB CEN17FA227Accident · 2 fatalField investigationFinal reportBeech E 90 · Ruidoso, NMThe pilot's failure to maintain clearance from terrain after takeoff during dark night conditions.NTSB ERA17LA203Accident · No injuriesLimited investigationFinal reportCessna 172 · Suffolk, NYA loss of preload to the crankshaft gear attachment bolt due to improper installation, which resulted in the fatigue failure of the crankshaft gear alignment dowel and led to the rotation of the crankshaft gear and a subsequent total loss of engine power.NTSB GAA17CA331Accident · Minor injuriesData collectionFinal reportPiper PA25 · Hood River, ORThe pilot's failure to visually check the fuel level prior to takeoff and subsequent mismanagement of the available fuel supply during numerous glider tow flights.NTSB WPR17LA124Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Carpinteria, CAThe noninstrument-rated pilot's improper decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain.NTSB WPR17FA125Accident · 1 fatalField investigationFinal reportBeech 95 C55 · Mountain Ranch, CAThe pilot's continued visual flight rules flight into instrument meteorological conditions and mountain obscuration that resulted in controlled flight into trees and terrain.NTSB CEN17LA226Accident · Minor injuriesLimited investigationFinal reportPiper PA 32R-301T · Dalhart, TXThe failure of the engine's front bearing seal due to maintenance personnel’s installation of an improperly sized crankshaft seal, which resulted in oil starvation and a forced landing.NTSB ENG17IA026Incident · No injuriesIncident investigationFinal reportBoeing 747 451 · Tokyo, JapanThe PW4056 engine lost power due to the fatigue fracture of a 5th stage compressor blade. The cause of the fatigue fracture could not be determined.NTSB ANC17LA028Accident · Minor injuriesClass 2 · LimitedFinal reportCessna 172 · Chugiak, AKThe pilot's improper in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN17LA239Accident · No injuriesLimited investigationFinal reportLevy Adam V Legacy 2000 · Georgetown, TXA total loss of engine power for reasons that could not be determined based on the available information.NTSB WPR17LA119Accident · No injuriesClass 3 · LimitedFinal reportPaul R Seipt Sonex · Garfield, WAThe pilot’s improper torque of screws that attached the flywheel mounting flange to the crankshaft during engine assembly, which resulted in heavy vibrations and the subsequent in-flight loss of the propeller.NTSB ENG17IA027Incident · No injuriesIncident investigationFinal reportBoeing 737 7H4 · Washington, DCThe failure the control alternator gearshaft, which disconnected the accessory gearbox from the rest of the engine and resulted in an uncommanded in-flight shutdown of the left engine and subsequent flight diversion. The control alternator gearshaft failed…NTSB ANC17WA027Accident · 4 fatalForeign investigationCessna 172 · Tateyama, JapanOn June 3, 2017, about 1450 Japan standard time (UTC +9), a Japanese registered Cessna 172P airplane, JA3989, operated by New Central Air Service, impacted snow-covered mountainous terrain near Tateyama, Toyama Prefecture, under unknown circumstances about 27…NTSB WPR17FA117Accident · 1 fatalField investigationFinal reportCessna 180 · Ventura, CAThe pilot's abrupt and substantial pullup maneuver while flying the airplane above the maneuvering speed, which resulted in an in-flight breakup. The reason for the pilot's maneuver could not be determined based on the available evidence.NTSB CEN17WA214Accident · 1 fatalForeign investigationPiper PA-28-140 · Sacatepequez, GuatemalaOn June 1, 2017, at 1824 coordinated universal time, a Piper PA-24-140, Guatemalan registration TG-GYV, owned by a private individual, was destroyed when it impacted mountainous terrain under unknown circumstances near Volcán de Agua, Departamento de…NTSB CEN17FA207Accident · 1 fatalField investigationFinal reportVarga 2150A · Bowling Green, OHThe pilot's loss of control due to impairment from carbon monoxide poisoning. Contributing to the accident was the corrosion of the heat exchanger and the failure of maintenance personnel to adequately inspect and repair or replace the exchanger during the…NTSB ERA17TA196Accident · No injuriesFinal reportErnest T Christley Zenith Zodiac 601XL · Sanford, NCThe pilot’s selection of a threaded metal rod of insufficient strength to connect the fuel tank selector handle to the fuel valve, which resulted in his inability to switch fuel tanks and a subsequent total loss of engine power due to fuel starvation.NTSB GAA17CA308Accident · Minor injuriesData collectionFinal reportRobert Hamblin Autogyro Gmbh Cavalo · Fort Worth, TXThe pilot’s failure to maintain clearance from terrain.NTSB DCA17WA126Incident · No injuriesForeign investigationBoeing 777 · Multan, PakistanThe government of Pakistan has notified the NTSB of an accident involving a BOEING 777 airplane that occurred on May 23, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Pakistan's investigation under the provisions of…NTSB ANC17LA025Accident · Minor injuriesClass 3 · LimitedFinal reportAirbus AS350 · Juneau, AKThe pilot's decision to depart into an area of degraded visual meteorological and flat light conditions, which resulted in a loss of visual references and subsequent controlled flight into terrain.NTSB GAA17CA311Accident · No injuriesData collectionFinal reportCessna 208 · Skagway, AKAn in-flight collision with a goose.NTSB DCA17CA123Accident · Serious injuriesClass 4 · Data collectionFinal reportAirbus A319 132 · South Toledo Bend, TXan encounter with convective turbulence.NTSB GAA17CA306Accident · Minor injuriesData collectionFinal reportCessna 150 · Zepp, VAA partial loss of engine power due to the formation of carburetor icing, which resulted from the student pilot’s failure to apply carburetor heat and the flight instructor’s delayed response in applying carburetor heat while operating in conditions conducive…NTSB ERA17LA185Accident · No injuriesLimited investigationFinal reportCessna 182 · West Chester, PAAn engine crankcase overpressurization and the subsequent loss of engine oil for reasons that could not be determined, which resulted in the failure of the No. 6 cylinder connecting rod due to a lack of lubrication.NTSB ERA17LA188Accident · Minor injuriesLimited investigationFinal reportMaule M7 · Colton, NYThe pilots' initiation of an uncoordinated right turn with the fuel selector positioned to the right main fuel tank, which had a low quantity of fuel in it and resulted in a total loss of engine power due to the unporting of the fuel and subsequent fuel…NTSB WPR17LA106Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182P · Anderson, CALoss of engine power for reasons that could not be determined based on the available information.NTSB ERA17WA191Accident · 2 fatalForeign investigationRobinson R44 · Heilbron, South AfricaThe South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Robinson R44 II helicopter that occurred on May 19, 2017. The NTSB has appointed a U.S. Accredited Representative to assist SACAA's investigation under the…NTSB ERA17WA206Incident · No injuriesForeign investigationCessna 182 · Poesoegroenoe, SurinameOn May 18, 2017, at 1840 coordinated universal time, a Cessna 182P, registered as PZ-VAC, experienced an uncontained engine failure, and sustained minor damage during a subsequent forced landing in Poespegroenoe, Suriname. The pilot and two passengers were…NTSB WPR17LA104Accident · Minor injuriesClass 3 · LimitedFinal reportEvolution Air Lancair Evolution · Firebaugh, CAA failure in the windshield, frame, or windshield-to-frame bond, which resulted in a rapid decompression during cruise flight.NTSB ERA17FA181Accident · 4 fatalField investigationFinal reportMitsubishi MU2B · Eleuthera, BahamasThe pilot's intentional flight into an area of known icing and convective thunderstorm activity, which resulted in a loss of control of the airplane.NTSB DCA17WA118Incident · No injuriesForeign investigationBoeing 737 · Munich, GermanyThe Germany Federal Bureau of Aircraft Accident Investigation (BFU) has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on May 14, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of…NTSB CEN17LA186Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-140 · Muskogee, OKThe pilot's improper in-flight fuel management, which resulted in a partial loss of engine power due to fuel starvation.NTSB CEN17WA256Accident · No injuriesForeign investigationLancair IV · Grenaa, DenmarkOn May 12, 2017, about 0635 coordinated universal time, a Lancair IV P airplane, Swiss registration SE-XRU, was substantially damaged when it impacted terrain near Grenaa, Denmark. The airplane was registered to and operated by a private individual as a…NTSB GAA17CA279Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Vevay, INThe pilot’s failure to see and avoid power lines during an agricultural application flight due to distraction when reading a map.NTSB ERA17WA183Accident · 1 fatalForeign investigationEnstrom Helicopter 480B · Fundres, ItalyOn May 10, 2017, about 1143 universal coordinated time,an Enstrom 480B, N480W, was destroyed during an infight break-up near Fundres, Italy. The flight departed from Bolzano, Italy, and was destined for Linz, Italy. The pilot was fatally injured. This…NTSB ERA17LA176Accident · No injuriesClass 3 · LimitedFinal reportCessna 150M · Homerville, GAA total loss of engine power due to inadequate maintenance and inspection of the engine, which resulted in a fatigue crack and subsequent failure of the No. 4 cylinder.NTSB CEN17WA195Accident · Serious injuriesForeign investigationCessna P210N · San Vicente Tancoayalab, MexicoOn May 9, 2017, about 1430 universal coordinated time, a Cessna P210N airplane, N116DC, impacted trees and terrain during an emergency descent near San Vicente Tancoayalab, Mexico, following lightning strikes during cruise. The pilot was seriously injured and…NTSB WPR17LA097Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 · Santa Barbara, CAA total loss of engine power during cruise flight due to the failure of an engine piston rod for reasons that could not be determined due to extensive damage.NTSB GAA17CA261Accident · No injuriesData collectionFinal reportQuicksilver Manufacturing SPORT2S R582 · Arecibo, PRThe pilot’s failure to see and avoid trees during low-altitude flight.NTSB ERA17WA173Accident · 3 fatalForeign investigationRobinson R44 · Beloretsk, RussiaOn May 4, 2017, about 1020 coordinated universal time, a Robinson R44 helicopter, Russian registration RA-04156, was substantially damaged when it impacted mountainous terrain during a fire monitoring mission after departing from Beloretsk, Bashkortostan,…NTSB ERA17FA172Accident · 1 fatalField investigationFinal reportPiper PA31 · Colton, NYThe pilot's incapacitation for unknown reasons, which resulted in an overflight of his destination, a subsequent loss of engine power due to fuel starvation, and collision with terrain.NTSB DCA17CA111Accident · Serious injuriesData collectionFinal reportAirbus A320 232 · Boston, MAan inadvertent encounter with convective turbulence.NTSB CEN17LA174Accident · No injuriesLimited investigationFinal reportBell 407 · Venice, LAAn in-flight separation of the tip block from the tail rotor blade due to an inadequate blade repair, which resulted in a rotor imbalance sufficient to crack the gearbox attachment studs and gearbox support assembly, and inadequate postrepair test procedures,…NTSB ANC17FA021Accident · 1 fatalField investigationFinal reportCessna 208B · Chignik Lake, AKThe pilot's continued visual flight rules flight into an area of mountainous terrain and instrument meteorological conditions, which resulted in controlled flight into terrain (CFIT). Contributing to the accident was the company's failure to provide the pilot…NTSB ERA17LA169Accident · No injuriesLimited investigationFinal reportPiper PA32RT · Coral Springs, FLThe in-flight disconnection of the fuel injection servo throttle linkage, which resulted in a loss of engine power.NTSB WPR17LA094Accident · Minor injuriesLimited investigationFinal reportYakovlev YAK 52 · Porterville, CAA partial loss of engine power due to contaminants in the fuel system that decreased the fuel flow, the source of which could not be determined.NTSB ENG17WA021Incident · No injuriesForeign investigationBoeing Boeing 787-9 · London, United KingdomThe United Kingdom's Air Accidents Investigation Branch (AAIB) has notified the NTSB of an incident involving a Boeing 787-9, which occurred on April 29, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the…NTSB WPR17LA093Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Coolidge, AZA partial loss of engine power due to separation of the throttle cable.NTSB WPR17FA091Accident · 1 fatalField investigationFinal reportNanchang CJ6A · Keene, CAThe pilot's failure to maintain airplane control following a descent into clouds.