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 DEN07LA024Accident · Serious injuriesLimited investigationFinal reportBell UH-1H · Melrose, NMthe in-flight failure and separation of both tail rotor blades. Contributing factors in this accident were the check pilot interferring with the controls and his failure to relinquish control to the pilot-in-command.NTSB DFW07LA024Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Pocasset, OKThe "abnormally high" oil temperature indication and smoke in the cabin for undetermined reasons. A contributing factor was the lack of suitable terrain for the precautionary landing.NTSB NYC07LA026Accident · 1 fatalLimited investigationFinal reportVogel Glastar 41 · Snow Shoe, PAThe builder's improper installation of an additional alternator. Contributing to the accident were the night lighting conditions.NTSB MIA07LA013Accident · Minor injuriesLimited investigationFinal reportWinter J.T/Johnson Kitfox III · Southwest Ranch, FLThe owner/builder's improper maintenance/installation of the propeller which resulted in a propeller blade coming loose and separating from the hub.NTSB ATL07CA018Accident · No injuriesData collectionFinal reportGrumman G-164B · Pine Hill, ALThe pilot's improper fuel management resulting in a total loss of engine power in cruise flight due to fuel exhaustion, subsequent forced landing to non suitable terrain, and an on-ground collision with tree stumps on the landing roll out.NTSB ATL07LA014Accident · 1 fatalLimited investigationFinal reportCarlson Lancair Propjet · Dalton, GAThe pilot's failure to maintain airspeed during a forced landing, resulting in an inadvertent stall. Contributing to the accident was the pilot's mismanagement of the fuel supply, which resulted in loss of engine due to fuel starvation.NTSB DFW07FA020Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Danville, ARFailure of the number 5 cylinder which resulted in oil starvation and the subsequent loss of engine power, and the pilot's inability to see the transmission line during the forced landing. Factors Contributing to the accident were the dark night and the…NTSB DFW07FA019Accident · 2 fatalField investigationFinal reportCessna 172S · Hominy, OKThe pilot's continued cruise flight into adverse weather conditions, and his failure to maintain clearance from terrain. Contributing factors were the dark night conditions, and the low ceilings.NTSB DEN07CA019Accident · No injuriesData collectionFinal reportLuscombe 8F · Wellsville, KSA loss of engine power due to the ingestion of the number 2 intake valve into its cylinder. Contributing factors included the pilot allowing the airspeed and altitude to drop, making a safe landing not possible.NTSB ANC07FA006Accident · 1 fatalField investigationFinal reportCessna 180E · Cordova, AKA loss of engine power for an undetermined reason during cruise flight, which resulted in a forced landing and collision with an embankment.NTSB LAX07FA026Accident · 2 fatalField investigationFinal reportAircraft Mfg & Dev. CH601XL Slsa · Yuba City, CAIn-flight structural failure of the horizontal stabilizer and wings for undetermined reasons.NTSB SEA07FA014Accident · No injuriesField investigationFinal reportBell 407 · Kalispell, MTOn-speed failure of the second stage turbine wheel as the result of engine oil starvation. The lack of maintenance oversight was a contributing factor.NTSB CHI07LA018Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Chester, ILThe fatigue failure of the turbocharger shroud which resulted in oil starvation to the engine. A factor was the muddy field.NTSB CHI07FA016Accident · 1 fatalField investigationFinal reportCessna 175 · Battle Creek, MIA loss of engine power while in cruise flight due to an oil leak from the nose seal of the reduction gear case. Contributing to the accident were the oil leak, the pilot's reduced visibility out the windscreen, and rising terrain.NTSB NYC07LA018Accident · Serious injuriesLimited investigationFinal reportBombardier CL-600-2B16 · Teterboro, NJThe pilot's excessive maneuver while in cruise flight in response to a traffic collision alert, and failure to follow company procedures.NTSB NYC07CA019Accident · No injuriesData collectionFinal reportCessna 172M · Wakefield, VAThe student pilot's failure to maintain control during the landing. A factor to the accident was the wind gusts.NTSB CHI07LA010Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Monroe City, INThe student pilot not maintaining clearance from the tree during climb. Factors were the tree and the student pilot's lack of total experience.NTSB CHI07LA013Accident · Serious injuriesLimited investigationFinal reportCessna 180B · Forest Lake, MNthe altitude/clearance with terrain not maintained by the pilot.NTSB DFW07LA016Accident · No injuriesLimited investigationFinal reportBeech F33 · Houston, TXThe loss of engine power due to fuel starvation as a result of the pilot's improper fuel management.NTSB SEA07FA012Accident · 1 fatalField investigationFinal reportCessna 172M · Escalante, UTThe pilot's failure to maintain aircraft control. Contributing factors were the pilot's lack of experience of flying on instruments on a dark night and in rainy weather.NTSB LAX07FA021Accident · 4 fatalField investigationFinal reportCirrus SR22 · Meadview, AZThe pilot's inadequate weather evaluation and continued flight into forecasted icing conditions. Contributing to the severity of the accident was the pilot's failure to follow proper operating procedures and deploy the CAPS when the airplane entered a spin.…NTSB CHI07IA017Incident · No injuriesIncident investigationFinal reportPiper PA-24-250 · Sherman, ILThe loose connecting rod bolt due to a loss of torque and subsequent failure of the connecting rod during cruise flight.NTSB LAX07LA017Accident · 2 fatalLimited investigationFinal reportWilson Quicksilver Sport 2S · Buckeye, AZFailure of the pilot to maintain adequate clearance from obstacles.NTSB LAX07LA016Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Prunedale, CATotal loss of engine power due to failure of connecting rod cap during cruise flight for undetermined reasons.NTSB DFW07FA007Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Dry Prong, LAThe loss of engine power during cruise flight due to oil starvation, resulting in an emergency off-airport forced landing. A factor associated with the accident was the instructor's improper in-flight decision in delaying to seek an emergency landing site…NTSB ATL07FA010Accident · 2 fatalField investigationFinal reportCessna 182T · Rocky Mount, NCThe pilot's failure to maintain aircraft control.NTSB MIA07LA009Accident · 2 fatalLimited investigationFinal reportMike Smilee CGS Hawk II Arrow · Crystal Springs, FLThe failure of the non-rated pilot to maintain airspeed. A finding in the accident was a malfunction of the ignition switch.NTSB DFW07LA009Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Wimberley, TXthe pilot's inadequate pre-flight planning which resulted in fuel starvation and the subsequent the loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX07LA015Accident · No injuriesLimited investigationFinal reportWilliams Bowers Fly Baby-1A · Oakdale, CAa loss of engine power due to the pilot's failure to use carburetor heat during conditions that were conducive to carburetor icing.NTSB LAX07IA014Incident · No injuriesIncident investigationFinal reportBoeing 737-790 · Los Angeles, CAA complete failure and depressurization of both hydraulic systems due to two separate events: 1) the failure of a engine driven pump on the 'A' system, and 2) the fatigue fracture and failure of a hydraulic line on the 'B' system.NTSB LAX07LA011Accident · Minor injuriesLimited investigationFinal reportMorrisey 2150A · Chandler, AZLoss of engine power during cruise flight due to a crack in the oil cooler and subsequent loss of engine oil.NTSB DEN07CA013Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Monticello, UTan airframe vibration for reasons undetermined, resulting in the pilot performing a precautionary landing, and obstacle clearance not possible.NTSB DFW07FA004Accident · 4 fatalField investigationFinal reportAero Commander 690A · Antlers, OKThe pilot's failure to reduce airspeed while operating in an area of moderate turbulence, resulting in an in-flight break up. Contributing factors were the pilot's decision to exceed the maximum takeoff weight, and the prevailing turbulence.NTSB SEA07CA008Accident · Minor injuriesData collectionFinal reportBeech E-55 · Ontario, ORThe dual loss of engine power due to fuel exhaustion as a result of the pilot's failure to adequately determine the amount of fuel aboard the airplane during his preflight preparation. A contributing factor was the pilot's misjudgment of distance/speed during…NTSB DEN07LA040Accident · No injuriesLimited investigationFinal reportBeech A-36 · Great Bend, KSThe pilot's spatial disorientation and subsequent loss of aircraft control while changing radio frequencies and abruptly applying control forces in excess of the design limits of the airframe.NTSB ATL07FA005Accident · 1 fatalField investigationFinal reportBeech BE-19A · Gunthertown, ALThe pilot's continued flight from VMC into IMC conditions which resulted in an in-flight collision with rising terrain.NTSB LAX07LA004Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Oakdale, CAA total loss of engine power resulting from lubrication deprivation for undetermined reasons.NTSB MIA07CA002Accident · Minor injuriesData collectionFinal reportCessna 172C · Jay, FLThe pilot's improper in-flight planning and decision resulting in a total loss of engine power due to fuel exhaustion.NTSB ANC06LA144Accident · No injuriesLimited investigationFinal reportCessna TU206A · Juneau, AKThe separation of the number 6 cylinder assembly from the engine during cruise flight, which resulted in a hard forced landing in rough ocean swells. A factor contributing to the accident was the rough ocean swells.NTSB NYC06LA231Accident · No injuriesLimited investigationFinal reportMooney M-18L · Lexington, KYThe failure of both magnetos which resulted in a loss of engine power during cruise flight.NTSB DFW06CA217Accident · No injuriesData collectionFinal reportBrantly Helicopter B-2B · Carrizo Springs, TXThe loss of engine power due to a malfunction of the electric fuel pump. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ATL06LA130Accident · Minor injuriesLimited investigationFinal reportBellanca 14-13-2 · Ellijay, GAA loss of engine power due to fuel contamination. Also causal was the mechanic's failure to ensure the aircraft's fuel system was free of contamination while performing an annual inspection.NTSB ANC06LA137Accident · No injuriesLimited investigationFinal reportAerospatiale SA319B · Port Alsworth, AKThe pilot's failure to adequately secure the external load rigging of an airplane that was suspended from the helicopter, which resulted in a load shift during cruise flight, producing an abrupt nose-down attitude, and the severing of the tailrotor drive…NTSB DFW06CA214Accident · No injuriesData collectionFinal reportAir Tractor 301 · Big Spring, TXA loss of engine power due to fuel exhaustion as result of the pilot's failure to refuel the airplane. A contributing factor was the lack of suitable terrain for a forced landing.NTSB DFW06CA212Accident · Minor injuriesData collectionFinal reportVans RV4 · Springtown, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA06LA185Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Delta, UTA loss of engine power for an undetermined reason during cruise flight.NTSB NYC06LA228Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Orient, METhe pilot's failure to maintain adequate airspeed during the initial climb which resulted in an inadvertent stall. A factor was his inadequate weight and balance calculations and the gusty wind conditions.NTSB CHI06LA268Accident · 1 fatalLimited investigationFinal reportWindler Tri Q2 · Branson, MOFatigue failure, originating in an area of surface corrosion, of the right elevator mid span hinge pin and the subsequent failure of the elevator torque tube. Additional causes are the separation of the elevator from the airframe due to the hinge pin and…NTSB CHI06FA264Accident · 1 fatalField investigationFinal reportBeech BE-95-B55 · N. Sioux City, SDThe pilot's failure to maintain control of the airplane during cruise flight, and subsequent inadvertent flat spin from which he could not recover. Contributing to the accident were clouds, turbulence, and rain showers.NTSB ATL06LA127Accident · No injuriesLimited investigationFinal reportStinson 108 · Holladay, TNA total loss of engine power in cruise flight due to the fatigue failure of the crankshaft gear resulting in a forced landing and subsequent nose over.