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 MKC89LA172Accident · No injuriesLimited investigationFinal reportCessna 152 · Ft Smith, ARInadequate preflight by the pilot which resulted in fuel exhaustion due to an inadequate supply of fuel. A contributing factor was the road sign.NTSB BFO89FA065Accident · 4 fatalField investigationFinal reportPiper PA-28R-201T · College Park, MDFailure of the pilot to maintain aircraft control due to spatial disorientation, and his exceeding the design stress limits of the aircraft, which resulted in overload failure of the stabilators and wings. Factors related to the accident were: the pilot's…NTSB SEA89FA143Accident · 2 fatalField investigationFinal reportPiper PA-32-301 · Haines, AKImproper in-flight planning and decision by the pilot, which resulted in inadvertent flight into instrument meteorological conditions (IMC). The weather conditions and terrain were related factors.NTSB MKC89LA163Accident · No injuriesLimited investigationFinal reportBeech 58 · Cedar Rapids, IAThe failure of the pilot in command to maintain alignment with the runway and excessive aircraft control in close proximity to the ground. Contributing to the accident was the pilot's diverted attention which resulted from having to shut down the left engine.NTSB LAX89LA252Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Corona, CAContinued buildup of carburetor ice due to the pilot's improper use of carburetor heat, and his improper use of emergency procedures. Factors related to the accident were: carburetor icing conditions, the pilot's lack of recent flight experience, and trees in…NTSB CHI89LA152Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Watertown, WIImproper planning/decision by the pilot and his misjudgement of distance and speed during the landing, which resulted in failure to attain a proper touchdown point. Contributing factors were: the weather conditions, the pilot's continued flight into…NTSB CHI89FA150Accident · No injuriesField investigationFinal reportProspector FK-1 · Chilton, WIThe pilot's poor in flight planning in that he diverted his attention and continued the flight beyond the original period planned. Before takeoff the pilot was aware of his fuel endurance.NTSB CHI89DEP08Accident · No injuriesFinal reportJames Eggleston Varieze · Cottage Grove, WIThe pilot misjudged altitude and distance to the runway and failed to attain the proper touchdown point for a landing. Factors related to the accident were: adverse weather conditions and uneven terrain short of the runway.NTSB LAX89LA256Accident · No injuriesLimited investigationFinal reportCessna 172M · Marana, AZInadequate preflight by the student pilot, inadequate supervision by the flight instructor (CFI), and fuel exhaustion due to lack of fuel. Related factors were: inoperative left fuel quantity gage, the cfi's decision to make the flight with a known deficiency…NTSB CHI89DEP09Accident · No injuriesFinal reportCabrinha/Free Spirit 412 · Waukesha, WIThe plt became lost/disoriented and allowed fuel exhaustion to occur before accomplishing remedial action. Factors related to the accident were: the adverse environmental conditions and the road sign and vehicles in the emergency landing area.NTSB BFO89FA063Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · True, WVThe pilots failure to properly monitor the fuel supply which resulted in fuel starvation. The aircraft stalled as the pilot performed an evasive maneuver to avoid the mountain top.NTSB MIA89LA208Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Homestead, FLImproper repair of the fuel cap (seal) by the pilot, which resulted in a blocked fuel system (cap) vent and subsequent fuel starvation, and his failure to see-and-avoid the telephone line. The telephone (transmission) line was a contributing factor.NTSB LAX89LA257Accident · Minor injuriesLimited investigationFinal reportCessna 337H · Honolulu, HIAn unexpected and sudden encounter with severe turbulence while the aircraft was cruising over the pacific ocean in cumulus cloud conditions.NTSB CHI89DEE05Accident · No injuriesFinal reportCessna 152 · Romeoville, ILThe pilot's misjudgement of the fuel supply.NTSB NYC89IA176Incident · No injuriesIncident investigationFinal reportDouglas DC-9-30 · Newark, NJRupture of a flexible high pressure hydraulic line in the 'a' hydraulic system, due to chafing of the steel braid covering, which allowed the system pressure and quantity to be completely depleted.NTSB LAX89LA246Accident · Serious injuriesLimited investigationFinal reportHughes 269C · Kalapana, HIThe loss of engine power due to the failure of the engine exhaust valve in the no. 2 cylinder and the disregard of the Lycoming service bulletin by company maintenance personnel. Contributing to the accident was the high vegetation and trees located at the…NTSB NYC89LA175Accident · No injuriesLimited investigationFinal reportCessna 170B · Bricktown, NJUndetermined. The terrain was a related factor.NTSB BFO89FA062Accident · 1 fatalField investigationFinal reportBeech 77 · Cluster Springs, VAThe pilot's failure to perform an adequate preflight which resulted in an unlatched fuel filler cap. Contributing to the accident was the pilot's failure to monitor the fuel supply during the flight.NTSB CHI89LA141Accident · No injuriesLimited investigationFinal reportCessna R172K · Wisconsin Dells, WIFailure of the pilot to insure the oil filler cap was properly secured when he serviced the aircraft before takeoff, and subsequent loss of oil and oil exhaustion. The tree was considered to be a contributing factor.NTSB MIA89LA204Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13E/M74 · Greenwood, MSFailure of a main rotor blade pitch change horn and/or attaching bolt(s).NTSB ATL89FA190Accident · 4 fatalField investigationFinal reportMooney M20J · Suches, GAThe pilot elected to continue flight to the intended destination disregarding the recommendations of the in flight weather briefer. Contributing factor(s) was: the adverse weather conditions that existed at the time.NTSB SEA89LA137Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Meridian, IDThe pilot's failure to properly position the fuel selector, which resulted in fuel starvation, his failure to follow the emergency procedure, and his inadequate visual lookout (failure to see & avoid obstructions). The power line was a related factor.NTSB LAX89IA242Incident · Minor injuriesIncident investigationFinal reportAerospatiale AS350D · Long Beach, CAThe failure of the engine driven fuel pump.NTSB SEA89LA136Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Albion, WAThe pilot failed to see and avoid a wooden utility pole while cruising at a low level. A contributing factor was the dusk light conditions.NTSB DCA89MA063Accident · 111 fatalClass 1 · MajorFinal reportMcdonnell Douglas DC-10-10 · Sioux City, IAThe inadequate consideration given to human factors limitations in the inspection and quality control procedures used by united airlines' engine overhaul facility which resulted in the failure to detect a fatigue crack originating from a previously…NTSB ATL89LA181Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Somerset, OHThe pilot's failure to adequately perform an airplane pre-flight inspection and drain water present in the airplane fuel supply. The airplane engine subsequently lost power due to the water contamination.NTSB DEN89FA175Accident · 3 fatalField investigationFinal reportBell 206B · Duchesne, UTThe pilot failed to maintain clearance from the power line. Contributing factors were: lack of mission training provided by the company/operator, the pilot's lack of experience in this type of operation, his lack of familiarity with the geographic area, and…NTSB BFO89FA060Accident · 1 fatalField investigationFinal reportBeech V35TC · Charlottesville, VAImproper installation of the throttle and variable absolute controller assemblies by maintenance personnel which resulted in a total loss of engine power.NTSB SEA89LA133Accident · No injuriesLimited investigationFinal reportAeronca 7AC · American Falls, IDAn engine failure due to stripped and broken teeth on a magneto drive gear in the accessory gear box. A soft field caused the nose over during the forced landing.NTSB NYC89FA167Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Hartleton, PAThe pilot allowed the design stress limits of the aircraft to be exceeded after encountering adverse weather conditions. Weather was a related factor.NTSB MIA89LA200Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Luquillo, PRFailure of the left exhaust stack which resulted in an engine fire, loss of engine power, and subsequent ditching of the acft in ocean waters.NTSB BFO89FA058Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Libertytown, MDContinued VFR flight by the non-instrument rated pilot into instrument meteorological conditions (IMC), which resulted in the pilot's loss of aircraft control due to disorientation, and overload failure of the wings and stabilator due to the pilot exceeding…NTSB ATL89LA179Accident · No injuriesLimited investigationFinal reportCessna P210N · Jackson, SCThe pilot's mismanagement of the available fuel supply which resulted in a total loss of engine power. The fuel selector was not positioned to the tank which contained fuel. Contributing factor(s) was: the rough terrain encountered during the forced landing.NTSB ANC89LA124Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Quinhagak, AKPowerplant failure for an unknown reason, which resulted in an engine vibration, oil leak and a fire.NTSB FTW89LA141Accident · Minor injuriesLimited investigationFinal reportBeech 35-C33A · Fort Worth, TXFuel exhaustion due to pilot mismanagement.NTSB NYC89LA163Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Walpole, MEA loss of engine power for undetermined reasons. Contributing to the accident was the powerline which the airplane contacted.NTSB MIA89LA195Accident · Serious injuriesLimited investigationFinal reportCessna 210N · Atlantic Ocean (Atlantic Ocean)A gunshot wound, which resulted in a loss of the pilot's ability to effectively fly and navigate the aircraft, and a subsequent loss of engine power due to fuel exhaustion.NTSB ATL89LA178Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Columbus, OHThe improper installation of the propeller governor idler-gear shaft retaining set-screw, which led to an engine oil leak and resulted in a loss of engine power; and the reduction of the pilot's ability to see outside the airplane due to oil on the windshield.NTSB FTW89FA133Accident · 2 fatalField investigationFinal reportAerospatiale AS-350-D · Galveston, TXFailure of both pilots to see-and-avoid the other aircraft (inadequate visual lookout).NTSB CHI89LA131Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Logansport, INPoor judgement of the pilot due to physical impairment from consumption of alcohol, his inadvertent flight into known adverse weather, and his inadequate control of the aircraft during a precautionary landing. Contributing factors were: the weather conditions…NTSB ATL89FA177Accident · Serious injuriesField investigationFinal reportCessna 172 · Townsend, TNImproper in-flight planning/decision by the pilot and his delay in initiating remedial action, when he encountered low ceilings over mountainous terrain, which resulted in his inability to maintain sufficient altitude. Contributing factors were: the pilot's…NTSB ANC89FA119Accident · No injuriesField investigationFinal reportCessna 207 · 44 Nw Fairbanks, AKImproper planning/decision by the pilot, which resulted in fuel starvation. Factors related to the accident were: inaccurate fuel consumption calculations, inadequate fuel supply, turbulence, tailwind, terrain conditions, and trees (willows) in the emergency…NTSB MIA89LA190Accident · No injuriesLimited investigationFinal reportCessna 172M · Perry, FLFailure of the number three exhaust valve which necessitated a forced landing. The trees were considered to be a contributing factor.NTSB NYC89LA159Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Akron, NYImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. A factor related to the accident was: soft terrain in the emergency landing area.NTSB MIA89LA189Accident · No injuriesLimited investigationFinal reportCessna 152 · Vero Beach, FLInadequate preflight by the pilot which resulted in fuel starvation due to an inadequate supply of fuel. The soft terrain in the emergency landing area was considered to be a contributing factor.NTSB LAX89LA233Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Los Angeles, CAAn undertorqued oil line fitting, due to its improper installation by maintenance personnel, which resulted in a loose oil line fitting, an oil line leak, oil exhaustion, and subsequent failure of the engine.NTSB CHI89IA144Incident · No injuriesIncident investigationFinal reportDornier DO-228 · Chicago, ILPoor lookout by the crew of the Dornier and the baron.NTSB CHI89IA143Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-32 · Chicago, ILPoor lookout by the crew of the DC-9 and the Cessna pilot.NTSB DEN89LA161Accident · Minor injuriesLimited investigationFinal reportRaven RX-7 · Albuquerque, NMInadequate visual lookout by the pilot. Contributing to the accident were the power lines.NTSB DEN89LA160Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Holden, UTThe pilot's misjudgement of the effect of high density altitude on a heavily loaded aircraft.