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 ANC97LA129Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Bethel, AKthe pilot's improper selection of a fuel tank that did not contain fuel, which resulted in subsequent fuel starvation and loss of engine power. A factor relating to the accident was: the inability to reach suitable terrain for a forced landing.NTSB MIA97FA239Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Brownsville, TNthe pilot's inadequate preflight, and his improper in-flight planning/decision, which led to fuel exhaustion and a forced landing at night on unprepared terrain. Factors relating to the accident were: darkness, and the lack of a suitable area for an emergency…NTSB FTW97LA324Accident · No injuriesLimited investigationFinal reportCessna 182A · Delta, COFailure by the pilot to properly plan for the flight in that the fuel aboard was insufficient for the planned flight. Factors were: inaccurate fuel gauges and terrain condition for the forced landing.NTSB CHI97LA267Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18A · Coopersville, MIthe pilot inadequate fuel system management which led to a fuel starvation.NTSB LAX97LA299Accident · Serious injuriesLimited investigationFinal reportCessna 210E · Oxnard, CAThe failure of maintenance personnel to properly secure a fuel supply line during a 100-hour inspection and the failure of inspection personnel to detect the loose fitting.NTSB NYC97LA168Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Blairsville, PAthe pilot's inaccurate fuel consumption calculations and improper in-flight planning/decision, which led to fuel exhaustion, loss of engine power, and a forced landing.NTSB MIA97IA237Incident · Minor injuriesIncident investigationFinal reportBoeing 737-300 · Tampa, FLin-flight collision with a bird.NTSB SEA97LA193Accident · No injuriesLimited investigationFinal reportCessna TU206G · Edwall, WAA fatigue failure of the engine crankshaft. Factors contributing to the accident were the rolling terrain, and the fence.NTSB FTW97LA316Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Caldwell, TXThe loss of engine power due to fuel exhaustion which resulted from a leaking fuel cap. Factors were the dark night conditions, and the lack of suitable terrain for the forced landing.NTSB NYC97LA166Accident · Minor injuriesLimited investigationFinal reportCessna 425 · Perkasie, PAthe pilot's inadequate preflight, by failing to verify the fuel supply, which led to subsequent fuel exhaustion and loss of engine power. A related factor was: the inaccurate fuel quantity gauge.NTSB LAX97FA291Accident · 1 fatalField investigationFinal reportHefner Pitts S1S · Van Nuys, CAthe operation of the propeller beyond the design rpm limitations and the resultant gyroscopic loads from aerobatics. Contributing to the accident was the lack of a required instrument panel rpm restriction for the propeller mandated by an airworthiness…NTSB CHI97LA260Accident · No injuriesLimited investigationFinal reportCessna 182 · Derby, KSthe Airworthiness Directive and propeller overhaul not being complied with. Factors to the accident were the propeller blade retention failure and rough/uneven terrain condition.NTSB MIA97LA234Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Siler City, NCFailure of the pilot to obtain a preflight weather briefing, inaccurate weather evaluation by the pilot, and his poor in-flight planning decision for descending too low to read a road sign.NTSB MIA97LA233Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Waynesboro, GAThe obscured vision of the pilot due to oil covering the windscreen. Contributing to the accident was the partial loss of engine power due to a cracked head of one of the cylinders and unsuitable terrain encountered during the forced landing.NTSB LAX97FA288Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Corcoran, CAThe pilot's failure to maintain separation from ground obstacles.NTSB ATL97LA116Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Milan, TNThe loss of partial engine power due to undetermined reasons. A factor was the favorable atmospheric conditions for carburetor icing.NTSB ATL97FA115Accident · 2 fatalField investigationFinal reportMooney M20F · Tallahassee, FLfatigue failure of the crankshaft for undetermined reasons. Related factors were: darkness, and obstructions (trees) in the emergency landing area.NTSB LAX97LA280Accident · Serious injuriesLimited investigationFinal reportNorth American Navion B · Las Vegas, NVThe separation of the number 3 cylinder due to improper overhaul procedures, and the failure to adequately torque the cylinder hold down nuts and through bolts to specification.NTSB IAD97LA107Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Slatington, PAThe pilot's inadequate preflight planning/ preparation which resulted in fuel exhaustion.NTSB CHI97FAMS3Accident · 1 fatalMissing aircraftFinal reportGrumman American AA-5 · Lower Brule, SDundetermined due to the accident airplane not being available for examination.NTSB ATL97LA120Accident · No injuriesLimited investigationFinal reportCessna 152 · Dunlap, TNa loss of engine power for undetermined reasons.NTSB LAX97LA278Accident · No injuriesLimited investigationFinal reportCessna 150G · Palos Verdes, CALoss of engine power due to fuel starvation and the pilot's mismanagement of the aircraft's fuel supply.NTSB LAX97LA275Accident · 2 fatalLimited investigationFinal reportGrumman American AA-5 · Monterey, CAthe pilot's failure to maintain adequate clearance from surrounding terrain.NTSB SEA97LA186Accident · No injuriesLimited investigationFinal reportCessna 172M · Langley, WAA failed exhaust valve. Factors were tailwind and excessive airspeed during the ensuing forced landing. .NTSB FTW97LA294Accident · No injuriesLimited investigationFinal reportBeech C24R · Pollock, LAThe loss of engine power due to fuel starvation and the pilot's improper use of the fuel selector. Factors were the pilot's failure to use the checklist and the lack of suitable terrain for the forced landing.NTSB CHI97FA245Accident · 2 fatalField investigationFinal reportPeck Osprey 2 · Poygen, WIA loss of control in flight for undetermined reasons.NTSB NYC97LA158Accident · No injuriesLimited investigationFinal reportCessna 172 RG · Quinton, VAThe pilot's failure to identify an unsafe landing gear condition. A factor in the accident was the loss of electrical power.NTSB FTW97LA298Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Castle Rock, COA partial loss of engine power due to a cylinder exhaust valve jammed in the open position from excessive carbon deposits. A factor was the lack of suitable terrain on which to make a forced landing.NTSB FTW97LA297Accident · Serious injuriesLimited investigationFinal reportBeech F33A · Creede, COThe pilot's intentional low altitude flight over mountainous terrain, inadequate altitude to clear surrounding obstacles, and his misjudging vertical clearance. A factor was the pilot's use of an inappropriate chart for navigation.NTSB CHI97LA251Accident · Serious injuriesLimited investigationFinal reportLarsen T-BIRD II · Oshkosh, WIthe pilot's failure to maintain flying speed and loss of control resulting in a stall. Factors were the tree and the fence.NTSB CHI97LA241Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Eagle, MIthe pilot's inaccurate fuel consumption calculations, his decision to switch fuel tanks too late, and fuel starvation.NTSB CHI97LA239Accident · 1 fatalLimited investigationFinal reportBriegleb BG-12A · Superior, WIthe separation of the wing from the glider for undetermined reasons.NTSB MIA97LA224Accident · No injuriesLimited investigationFinal reportCessna 152 · Cape Coral, FLLoss of engine power for undetermined reasons resulting in a forced landing to unsuitable terrain.NTSB LAX97LA266Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-180 · Buckeye, AZThe total oil exhaustion of the engine due to the inadequate maintenance installation of the oil cooler lines by the owner/mechanic.NTSB FTW97FA295Accident · 2 fatalField investigationFinal reportLancair 320 · Dillon, COthe pilot's inadequate preflight planning/preparation, VFR flight into instrument meteorological conditions (IMC) conditions, and failure to maintain sufficient altitude/clearance from terrain. Factors relating to the accident were: low ceiling, rain, and…NTSB CHI97LA240Accident · No injuriesLimited investigationFinal reportCessna A188B · Satanta, KSthe pilot's decision to perform a precautionary landing in a corn field due to an undetermined event in the cockpit. Factors relating to the accident were: the pilot's inadvertent actuation of the 'smoker' switch, his unfamiliarity with the 'smoke' equipment…NTSB MIA97LA222Accident · No injuriesLimited investigationFinal reportWaco YMF5 · Lake Buena Vist, FLfailure of maintenance personnel to follow installation procedures pertaining to the torque of the propeller retention nut, which resulted in a loose propeller retention nut, subsequent fatigue failure of the crankshaft, and loss of engine power. The lack of…NTSB FTW97FA292Accident · 2 fatalField investigationFinal reportBeech F35 · Richards, MOThe pilot's continued flight into adverse weather and the loss of aircraft control which resulted in the aircraft exceeding its design stress limits. Factors were the pilot's failure to obtain a weather briefing and the adverse weather.NTSB FTW97FA286Accident · 1 fatalField investigationFinal reportDurbin Glasair R · Chama, NMflight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude and/or clearance from mountainous terrain. Factors relating to the accident were: the low ceiling, rain, fog, and high/mountainous terrain.NTSB FTW97FA285Accident · 1 fatalField investigationFinal reportAyres S2R-T15 · Oakridge, LAThe pilot's failure to maintain clearance for undetermined reasons.NTSB LAX97LA261Accident · No injuriesLimited investigationFinal reportClassic Waco YMF · Sedona, AZA partial loss of engine power due to a loose rocker arm adjustment nut on the number 6 cylinder. The loose adjustment nut was due to inadequate maintenance adjustment performed by the engine manufacturer.NTSB FTW97LA284Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Pine Bluff, ARloss of engine power for undetermined reason(s). The lack of suitable terrain for a forced landing was a related factor.NTSB CHI97LA229Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Mapleton, IAthe loss of engine power for undetermined reasons. A factor was the cornfield in which the pilot was forced to land.NTSB CHI97LA226Accident · No injuriesLimited investigationFinal reportBeech D50A · Mitchell, NEthe pilot's improper fuel selector position and the fuel starvation. Factors contributing to the accident were: the pilot's inattentiveness of the refueling, inadequate aircraft preflight, and the rough terrain/ditch.NTSB ANC97LA112Accident · Serious injuriesLimited investigationFinal reportCessna 206 · Palmer, AKA fatigue failure of the engine crankshaft, and an inadequate engine cylinder replacement by maintenance personnel. A factor in the accident was unsuitable terrain for a forced landing.NTSB NYC97LA155Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-10-30 · Atlantic Ocean (Atlantic Ocean)Failure of the aft flight attendant to secure her seat belt. Related factors were turbulence in clouds, and the flight attendant not receiving the crew briefing.NTSB LAX97LA260Accident · Serious injuriesLimited investigationFinal reportRobinson R22 Beta · Chandler, AZThe CFI's failure to recognize and correct for a vortex ring state, and his improper use of the flight controls, which resulted in the loss of control and uncontrolled descent.NTSB MIA97LA215Accident · No injuriesLimited investigationFinal reportBeech 65 · Atlantic Ocean (Atlantic Ocean)Failure of the aircraft to maintain altitude for undetermined reasons following loss of power in one engine.NTSB NYC97LA151Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6-200 · Sussex, NJthe pilot's improper management of the fuel supply. A related factor was the inoperative low fuel quantity light for the rear tank.NTSB LAX97LA254Accident · No injuriesLimited investigationFinal reportBeech 77 · Lakeport, CAcarburetor ice, and the failure of both pilot's to use (or properly use) carburetor heat. Factors relating to the accident were: the weather (carburetor icing) conditions, and obstructions in the forced landing area (grape vineyard).