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 IAD04LA024Accident · No injuriesLimited investigationFinal reportCessna 172P · Passaic, NJA total loss of engine power for undetermined reasons. A factor was the evasive maneuver on the ground.NTSB MIA04CA095Accident · No injuriesData collectionFinal reportCessna 182H · La Belle, FLThe inadvertent deployment of the main parachute resulting in damage to the right horizontal stabilizer and elevator.NTSB DEN04FA087Accident · 2 fatalField investigationFinal reportRaytheon A36 · Gilcrest, COthe pilot's inadequate in-flight planning/decision by his failure to switch fuel tank selector position which resulted in fuel starvation. Also causal was the pilot's failure to maintain airspeed which resulted in a stall.NTSB CHI04CA143Accident · No injuriesData collectionFinal reportCessna 150F · Forest Lake, MNThe pilot's inaccurate fuel consumption calculations which resultied in fuel exhaustion and loss of engine power. Factors associated with the accident were the dark light conditions and the water on which the forced landing was made.NTSB SEA04LA100Accident · 1 fatalLimited investigationFinal reportGann Glasair II-S RG · Baker City, ORThe pilot's inadequate in-flight planning/decision and his failure to maintain an airspeed above stall speed (Vs) after encountering airframe icing during cruise flight. Factors include the pilot's intentional continuation of his flight along the planned…NTSB LAX04LA232Accident · No injuriesLimited investigationFinal reportBeech S35 · Flagstaff, AZoil exhaustion due to a leak from the bottom oil drain line gasket and o-ring for the turbo charger.NTSB CHI04CA138Accident · No injuriesData collectionFinal reportMerkel Acro Sport II · Beloit, WIInaccurate fuel consumption calculations which resulted in fuel exhaustion. Factors associated with the accident were the pilot's continued flight with an inoperable fuel quantity indicator and the wires which the airplane contacted during the forced landing.NTSB CHI04LA148Accident · Serious injuriesLimited investigationFinal reportBoeing 737-7H4 · Liberal, KSThe adverse weather encountered during cruise flight by the flight crew and the flight attendant not being restrained. A contributing factor was the convective activity.NTSB CHI04LA144Accident · No injuriesLimited investigationFinal reportBeech M35 · Strafford, MOThe improper installation of the cylinder during the engine overhaul which resulted in the fatigue failure of the cylinder studs and through-bolts and the subsequent separation of the cylinder. Factors associated with the accident were the fence and the guy…NTSB NYC04FA137Accident · 1 fatalField investigationFinal reportCessna 182C · Kutztown, PAThe towplane pilot's failure to maintain a climb while towing a glider for undetermined reasons, which resulted in the early release of the glider and the tow plane's subsequent impact with trees.NTSB CHI04LA129Accident · 3 fatalLimited investigationFinal reportHall Lancair IV-P · Vermontville, MIThe failure of Air Route Traffic Control Center controllers to provide adverse weather avoidance assistance as required by FAA directives, which led to the airplane's encounter with a thunderstorm and subsequent loss of control. Contributing to the accident…NTSB ATL04LA124Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · St. Marys, GAThe pilot failure to use carburetor heat when weather condition were favorable for the for the formation of carburetor ice. .NTSB LAX04LA229Accident · No injuriesLimited investigationFinal reportSimmons BD-5 · Goodyear, AZThe overheating and failure of the number 4 connecting rod, which resulted in a total loss of engine power during descent.NTSB MIA04CA090Accident · No injuriesData collectionFinal reportCaproni Vizzola Cos. Aero. A-21 · Starkville, MSThe pilot's inadequate preflight planning and preparation and his delayed decision to return to the airport leading to an off airport landing as a result of deteriorating weather conditions. A finding in the investigation was the windshield that fogged up.NTSB FTW04FA143Accident · Minor injuriesField investigationFinal reportEurocopter AS355N · League City, TX"This case was modified may 30, 2006." The pilot's misjudged flare during an autorotation, which resulted in a hard landing and subsequent rollover.NTSB CHI04GA130Accident · 1 fatalFinal reportCessna T206H · Homer Glen, ILThe seized turbocharger, the altitude/clearance not maintained/obtained during approach to a forced landing on an agricultural field, and the unsuitable landing area encountered by the pilot. Contributing factors were the inadequate emergency procedures by…NTSB FTW04LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Cleveland, TXThe in-flight fire that resulted from an electrical arc in the main battery cable near the main power bus. The cause of the arcing event could not be determined.NTSB CHI04LA127Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-82 (MD-82) · Near St. Louis, MOThe unexpected encounter with convective turbulence which resulted in a flight attendant being injured.NTSB CHI04CA142Accident · No injuriesData collectionFinal reportKauffman Bede IV · Acme, MIEngine oil starvation and inadequate maintenance by the pilot.NTSB SEA04LA090Accident · No injuriesLimited investigationFinal reportBell 206B · Auburn, WALoss of control for undetermined reasons.NTSB DEN04FA079Accident · 3 fatalField investigationFinal reportMooney M20K · Pinedale, WYThe pilot's inadvertent flight into adverse weather conditions, and his failure to maintain terrain clearance while maneuvering. Contributing factors were the downdraft, the snow shower weather and mountainous terrain.NTSB ANC04LA059Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Goodnews, AKThe pilot's inadequate weather evaluation which resulted in an in-flight encounter with severe turbulence, and his exceedence of the design stress limits resulting in overstress of the wings. A factor contributing to the accident was the presence of…NTSB SEA04LA095Accident · 1 fatalLimited investigationFinal reportWSK PZL Mielec PZL M-18B · Borah Peak, IDThe pilot's inadequate planning/decision, VFR into IMC, and his failure to maintain terrain clearance. Factors include mountainous terrain and instrument meteorological condition.NTSB DEN04LA077Accident · No injuriesLimited investigationFinal reportCessna 182E · Santa Teresa, NMthe pilot's inadequate in-flight planning and decision-making, which resulted in the loss of engine power due to fuel exhaustion. Contributing factors to the accident were the fuel exhaustion and the lack of suitable terrain for a forced landing.NTSB FTW04IA134Incident · No injuriesIncident investigationFinal reportBeech A23A · Kress, TXThe in-flight separation of the crankshaft for undetermined reasons.NTSB SEA04FA088Accident · 1 fatalField investigationFinal reportCessna A185F · Molalla, ORThe pilot's inadequate in-flight planning/decision which resulted in VFR flight into IMC, and his failure to maintain control. Factors include mountain obscuration, clouds and convective weather conditions.NTSB SEA04LA084Accident · No injuriesLimited investigationFinal reportPiper J4/E · Bigfork, MTA loss of engine power due to fuel exhaustion while in cruise flight as a result of inadequate preflight planning / preparation. Factors contributing to the accident were the short landing field and trees.NTSB ATL04IA119Incident · No injuriesIncident investigationFinal reportBeech 200 · Millington, TNThe pilots failure to follow the checklist for emergency landing gear extension resulting in the collapse of the main landing gear on touchdown.NTSB SEA04FA083Accident · 1 fatalField investigationFinal reportCessna 170B · Tenino, WAThe pilot's failure to maintain an adequate visual lookout during cruise flight, which resulted in a midair collision between the two airplanes.NTSB LAX04LA213Accident · 4 fatalLimited investigationFinal reportBachman Lancair IV-P · Supai, AZthe loss of aircraft control while in cruise flight for undetermined reasons.NTSB CHI04LA120Accident · Minor injuriesLimited investigationFinal reportCessna 188B · Pleasant Hill, MOFuel exhaustion due to the pilot's improper fuel calculations. Contributing factors to the accident included the inaccurate fuel gage and the trees.NTSB LAX04LA210Accident · Minor injuriesLimited investigationFinal reportDowner Bellanca 14-19-2 · Lancaster, CAThe pilot's fuel mismanagement by his failure to follow the recommended procedures for operation of the auxiliary fuel tank, which resulted in fuel starvation and loss of engine power during cruise flight.NTSB ATL04TA116Accident · 1 fatalFinal reportHughes 269A · Louisburg, NCFatigue failure of the tailboom saddle fitting which resulted in a loss of aircraft control. Also causal was inadequate maintenance due to non-compliance to an airworthiness directive requiring inspection of the saddle fitting. A contributing factor was the…NTSB ATL04LA117Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · New Bern, NCThe pilot's inadequate pre-flight planning which resulted in a loss of engine power due to fuel exhaustion.NTSB NYC04LA122Accident · No injuriesLimited investigationFinal reportGarlick Helicipters OH-58A · Columbia, MEA partial loss of engine power for undetermined reasons, which resulted in a forced landing during cruise flight.NTSB CHI04LA119Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Winsted, MNThe failure of the main rotor drive belts for an undetermined reason, and the pilot's misjudged flare during the autorotation.NTSB LAX04FA205Accident · 2 fatalField investigationFinal reportPiper PA-44-180 · Julian, CAThe incorrect use of an abbreviated callsign by the TRACON sector radar controller to issue a descent clearance to N434PA and the sector controllers failure to detect that the clearance had been read back with the full callsign by the pilot of N304PA. Also…NTSB ATL04IA138Incident · No injuriesIncident investigationFinal reportCessna 172RG · Chamblee, GAThe fatigue fracture of the nosewheel bungee assembly, which restricted the movement of the elevator control. A factor was the inadequate equipment from an unknown source/manufacturer.NTSB ANC04LA053Accident · No injuriesLimited investigationFinal reportAerospatiale AS-350B2 · Skagway, AKA loss of engine power during cruise flight for an undetermined reason, which resulted in a ditching and submersion of the helicopter when the emergency float system did not deploy. Factors contributing to the accident were improper rigging of the mechanical…NTSB MIA04IA088Incident · No injuriesIncident investigationFinal reportBeech A36 · Daytona Beach, FLImproper maintenance/installation by the propeller overhaul/repair facility, which resulted in stress related fatigue and the eventual separation of the propeller pitch change pin.NTSB SEA04LA080Accident · Minor injuriesLimited investigationFinal report2003 Nash Kitfox II · Broadview, MTFuel starvation during cruise flight for undetermined reasons. Unsuitable terrain for a forced landing was a factor.NTSB NYC04LA120Accident · No injuriesLimited investigationFinal reportCessna 170B · Shirley, NYThe pilot's inadequate pre-flight inspection, which resulted in his failure to remove the engine inlet covers and subsequent loss of engine power.NTSB IAD04LA020Accident · No injuriesLimited investigationFinal reportTaylorcraft BC · Cumberland, MDThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall into transmission lines.NTSB FTW04LA124Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Fort Stockton, TXThe pilot's improper leaning of the fuel/air mixture in-flight, which resulted in a loss of engine power. Factor were the wind gusts and the crosswind.NTSB NYC04LA118Accident · 1 fatalLimited investigationFinal reportCessna T-50 · Sharon, MAThe loss of power in one engine for undetermined reasons. Factors were the excessive weight, and degraded climb performance.NTSB LAX04LA204Accident · No injuriesLimited investigationFinal reportRocket Flyers LLC · Tipton, CAA loss of engine power due to fuel starvation as a result of air migrating into the fuel control unit. The ultimate reason for the air entry into the fuel control unit was not determined.NTSB DEN04LA070Accident · No injuriesLimited investigationFinal reportCrimmins Smyth Sidewinder · Natrona, WYfuel starvation due to contamination, resulting in the fuel selector valve becoming totally blocked. Contributing factors were the inadequate conditional inspection, and the lack of nsuitable terrain on which to make a forced landing.NTSB DEN04LA069Accident · Minor injuriesLimited investigationFinal reportBranham Vans RV-6 · Paragonah, UTThe pilot's inadequate preflight and in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power. The berm and the pilot not stopping to refuel the airplane were contributing factors.NTSB ATL04CA106Accident · Serious injuriesData collectionFinal reportBeech BE-65 (LF-23F) · Winder, GAThe pilot's mismanagement of the fuel supply resulted in fuel starvation and a loss of power in both engines.NTSB FTW04CA122Accident · No injuriesData collectionFinal reportCessna 150E · Goldthwaite, TXThe pilot's inadequate in-flight planning and decision not to refuel, which resulted in a loss of engine power due to fuel exhaustion. A contributing factor was the dark night conditions.