NTSB investigations
35,885 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 DFW06LA040Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Columbus, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX06LA058Accident · 1 fatalLimited investigationFinal reportCessna 177RG · Dixon, CAthe pilot's intentional flight at low altitude and failure to maintain obstacle clearance with a high tension static line. The glare from the setting sun was a factor.NTSB DEN06FA023Accident · 1 fatalField investigationFinal reportCessna 172S · Pinon, NMthe pilot's failure to maintain control of the airplane for undetermined reasons.NTSB LAX06FA055Accident · 2 fatalField investigationFinal reportBeech A23 · Mammoth Lakes, CAa loss of engine power for undetermined reasons, and, the failure of the pilot to maintain an adequate airspeed while maneuvering following the loss of power, which resulted in a stall/spin.NTSB CHI06FA043Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Arco, MNThe pilot's inadvertent cruise flight into instrument meteorological conditions, and his failure to maintain control of the aircraft after experiencing spatial disorientation. Factors associated with the accident are the pilot's improper planning/decision…NTSB LAX06FA054Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Kingsburg, CAThe pilot's in-flight decision to continue VFR flight into instrument meteorological conditions during descent, which resulted in an in-flight collision with trees and terrain. Fog, low ceiling, and obscuration were factors.NTSB MIA06LA026Accident · No injuriesLimited investigationFinal reportCessna 152 · Key Largo, FLA loss of engine power for undetermined reasons that resulted in the airplane being ditched into the ocean. Contributing to the accident was the pilot's operation of an airplane with known deficiencies due to it having sat in flooded waters.NTSB LAX06CA081Accident · No injuriesData collectionFinal reportBurkhart Grob G 103 Twin II · Llano, CAThe flight's encounter with downdrafts. A contributing factor was the unsuitable vegetation-covered mountainous terrain.NTSB LAX06CA050Accident · Minor injuriesData collectionFinal reportMooney M20A · China Lake, CAfuel exhaustion due to the pilot's inadequate in-flight planning and fuel consumption calculations.NTSB DCA06IA007Incident · No injuriesIncident investigationFinal reportRaytheon Corporate Jets Beechjet 400 · Jacksonville, FLThe dual-engine flameout due to high-altitude ice crystals that had accreted onto the JT15D-5 engines' compressor vanes and were ingested into the engine when the pilots retarded the power levers, resulting in compressor surges and rapid reduction in fuel…NTSB CHI06FA037Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Atlanta, NEThe non-instrument rated private pilot not maintaining clearance from the marked tower and his continued flight into adverse weather during cruise flight. Factors were the marked tower and the low ceilings present at the accident.NTSB NYC06LA038Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-180 · Lincoln Park, NJThe improper installation of the helicoil by the non-certificated mechanic, and the inadequate inspection of the installation by the certificated mechanic.NTSB MIA06FA024Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Mims, FLThe loss of engine power due to improper installation of the #2 cylinder by maintenance personnel, which resulted in the separation of the cylinder as a result of fatigue cracking of the cylinder to crankcase fasteners. A contributing factor was the lack of…NTSB DFW06CA033Accident · No injuriesData collectionFinal reportPiper PA-23-250 · Bixby, OKThe loss of engine power due to water contamination and corrosion in both gascolators due to improper maintenance. A factor was the lack of suitable terrain for the forced landing.NTSB CHI06CA040Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Marshall, MOAn in-flight loss of engine power in descent due to fuel exhaustion, and the pilot's inaccurate preflight planning. Contributing to the accident was the unsuitable terrain the pilot encountered and the night conditions.NTSB LAX06LA044Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Tucson, AZthe separation of the mixture cable at the carburetor control arm, which resulted in a loss of power, and maintenance personnel's inadequate inspection of the airplane during the last annual inspection.NTSB LAX06FA043Accident · 4 fatalField investigationFinal reportCessna T210N · Dana Point, CAThe pilot's inability to maintain aircraft control, which resulted in a loss of airspeed and a stall/spin. The inability of the pilot to maintain control of the airplane was likely due to an incapacitating cardiac event.NTSB CHI06TA033Accident · No injuriesFinal reportSchweizer 269C · Manhattan, KSThe binding of the main rotor blade's tachometer cable during cruise flight resulting in an observed split tachometer indication/aural alarm and perceived mechanical emergency and the unsuitable terrain the pilot encountered during the emergency landing. A…NTSB MIA06LA019Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-180 · Heathrow, FLA partial loss of engine power due to undetermined reasons resulting in a forced landing in a residential area.NTSB DEN06LA014Accident · No injuriesLimited investigationFinal reportCessna 172L · Rock Springs, WYthe loss of engine power for reasons undetermined. Contributing to the accident was the dark night and lack of suitable terrain for a forced landing.NTSB CHI06LA036Accident · No injuriesLimited investigationFinal reportCessna T310R · Fergus Falls, MNThe presence of wing ice during landing. Contributing factors were the icing conditions and flight into known adverse weather by the pilot.NTSB ATL06CA015Accident · Minor injuriesData collectionFinal reportPiper PA-32-260 · Bryson City, NCThe loss of engine power due to carburetor icing, and the pilot's failure to use carburetor heat.NTSB LAX06CA033Accident · No injuriesData collectionFinal reportRotorway 162F · Chandler, AZa loss of engine power due to fuel contamination (rust, water) as a result of the pilot's inadequate preflight planning preparation.NTSB CHI06LA031Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Milwaukee, WIThe loss of engine power due to fuel starvation as a result of the pilot's fuel mismanagement. Factors to the accident included the pilot's impairment due to alcohol, the FAA's inadequate oversight when it issued the pilot a second class medical certificate,…NTSB LAX06CA035Accident · No injuriesData collectionFinal reportVans RV-4 · Apple Valley, CAa partial loss of engine power for undetermined reasons.NTSB LAX06LA030Accident · Serious injuriesLimited investigationFinal reportBell 47D1 · Rancho Murieta, CAa separation of the tail rotor assembly due to the reverse bending fatigue fracture of a tail rotor pitch change link bolt, resulting in a loss of control of the helicopter, and a hard landing during the uncontrolled descent.NTSB LAX06FA031Accident · 1 fatalField investigationFinal reportBeech F33A · Geyserville, CAthe pilot's failure to maintain an adequate terrain clearance altitude profile during the descent that resulted in controlled flight into terrain.NTSB CHI06FA030Accident · 1 fatalField investigationFinal reportPiper PA-23-160 · Bloomington, ILThe aircraft control not possible by the pilot during a visual approach to the runway due to the physical impairment of the pilot.NTSB NYC06FA027Accident · Serious injuriesField investigationFinal reportEmbraer 110P1 · Manchester, NHThe pilot’s misapplication of flight controls following an engine failure. Contributing to the accident was the failure of the sun gear, which resulted in the loss of engine power. Contributing to the sun gear failure were the engine manufacturer’s…NTSB DEN06FA013Accident · 1 fatalField investigationFinal reportBeech A36 · Datil, NMthe pilot's loss of control during flight as a result of incapacitation due to atherosclerotic cardiovascular disease.NTSB CHI06FA026Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Ankeny, IAThe pilot's failure to preflight the airplane, the pilot's improper in-flight decision not to land the airplane on the runway when he had the opportunity, and the inadvertent stall when the pilot allowed the airspeed to get too low. Factors that contributed…NTSB LAX06CA026Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Payson, AZa loss of engine power due to fuel exhaustion, which was caused by the pilot's inadequate preflight and in-flight planning, his inadequate fuel consumption calculations, and his failure to divert to an alternate airport before the fuel situation became…NTSB MIA06LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Opa-Locka, FLThe failure of the pilot-in-command/CFI to maintain control of the airplane and his inattentiveness to the altitude while troubleshooting the landing gear system resulting in the in-flight collision with terrain.NTSB DFW06CA022Accident · No injuriesData collectionFinal reportPiper PA38 · Decatur, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI06CA028Accident · No injuriesData collectionFinal reportCessna 182 · Butler, MOThe damage to the horizontal stabilizer was a result of the inadvertent deployment of the skydiver's reserve parachute.NTSB NYC06FA025Accident · 1 fatalField investigationFinal reportCessna 172A · Pohatcong, NJThe inadequate visual lookout of the pilots in both airplanes, which resulted in a midair collision during descent.NTSB SEA06CA018Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Tacoma, WAThe collapse of the landing gear due to the pilot's failure to use the emergency gear extension system after his aircraft experienced a complete loss of electrical power. Factors include the malfunction of the voltage regulating system, which lead to the…NTSB LAX06LA024Accident · Serious injuriesLimited investigationFinal reportSchleicher ASH 26 E · Sparks, NVThe pilot's inadvertent flight into instrument meteorological conditions which resulted in a subsequent loss of control and an in-flight breakup. A contributing factor was the spool up delay for the emergency turn and bank indicator.NTSB CHI06CA025Accident · Minor injuriesData collectionFinal reportPiper PA22-150 · Canton, ILThe fire for undetermined reasons.NTSB LAX06LA023Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lodi, CAa loss of engine power for undetermined reasons. A factor was the trees.NTSB CHI06LA021Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Portland, INThe pilot's decision to operate the helicopter with a known engine deficiency, the loss of engine power due to the connecting rod failure, and the pilot's failure to maintain directional control during landing. A factor to the accident was the corn crop and…NTSB NYC06FA015Accident · 1 fatalField investigationFinal reportCessna 411 · East Hampton, NYThe pilot's failure to maintain airspeed, while maneuvering with the left engine inoperative. Contributing to the accident were the failure of the left engine, and the pilot's lack of multiengine certification.NTSB DFW06CA013Accident · Serious injuriesData collectionFinal reportHiller UH-12E · Pasadena, TXThe pilot's inadequate fuel management, which resulted in fuel exhaustion and a loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN06FA010Accident · 2 fatalField investigationFinal reportLancair LC-40-550FG · Steamboat Spgns, COthe pilot's failure to maintain altitude/clearance from terrain. Contributing factors include the pilot's lack of recent experience, the pilot's improper in-flight planning and decision making, the dark night and the mountainous terrain.NTSB NYC06LA016Accident · Serious injuriesLimited investigationFinal reportBoeing 737-832 · Atlantic Ocean (Atlantic Ocean)An encounter with turbulence during cruise flight.NTSB NYC06CA017Accident · No injuriesData collectionFinal reportCessna 150L · Shelburne, VTThe pilot's inadequate preflight planning, which resulted in fuel exhaustion and a total loss of engine power.NTSB NYC06CA012Accident · No injuriesData collectionFinal reportWeber Glastar · Summersville, WVa loss of engine power due to a stuck carburetor float needle.NTSB MIA06FA008Accident · 1 fatalField investigationFinal reportCessna P337H · Port St. Lucie, FLThe pilot's continued flight into an area of known convective weather, resulting in a loss of aircraft control. Contributing factors were the failure of the FAA center controller to provide information on depicted severe weather to the pilot and the…NTSB LAX06LA015Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Avalon, CAthe pilot's failure to maintain an adequate visual lookout and obstacle clearance altitude, which resulted in a collision with power lines. Factors in the accident were the position of the sun relative to the helicopter's flight path, which lessoned the…NTSB DFW06LA010Accident · Minor injuriesLimited investigationFinal reportCessna 208 · Round Rock, TXThe loss of engine power due to the failure of the engine-driven fuel pump. A contributing factor was the inadequate inspection of the engine driven fuel pump.