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 FTW95LA276Accident · No injuriesLimited investigationFinal reportCessna 150F · Garfield, COThe pilot's delayed decision to deviate away from the deteriorating weather. Factors were his inadequate evaluation of the weather, high density altitude, and the resultant inadvertent operation of the airplane beyond the climb performance limitations of the…NTSB LAX95IA229Incident · No injuriesIncident investigationFinal reportBoeing 737-200 · Elko, NVin-flight separation of the aileron as a result of inadequate bonding.NTSB FTW95FA261Accident · 2 fatalField investigationFinal reportCessna 182Q · San Angelo, TXThe pilot's decision to attempt flight into known adverse weather conditions, and his loss of aircraft control due to spatial disorientation. Factors relating to the accident were: conditions of darkness, thunderstorm and lightning, and the pilot's lack…NTSB NYC95LA134Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Morehead, KYThe pilot's failure to assure that an inadequate oil supply was available fot the flight.NTSB MIA95LA165Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Lake Placid, FLTotal failure of the fuel vent system resulting in the total loss of engine power during cruise flight. Contributing to the accident was the inadequate inspection of the airplane during the last annual inspection for failure of the mechanic to identify that…NTSB MIA95LA163Accident · No injuriesLimited investigationFinal reportBeech A36 · Titusville, FLfailure of the No. 6 cylinder barrel due to corrosion fatigue, which resulted in a loss of power. A factor relating to the accident was: the lack of suitable terrain for an emergency landing.NTSB MIA95LA161Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Lauderdale, FLThe failure of the pilot-in-command [CFI] to use carburetor heat during reduced power descent.NTSB CHI95IA204Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas DC-10-10 · Green Bay, WIthe weather condition (turbulence in clouds). A factor was the flight crew's abrupt control of the airplane.NTSB MIA95TA159Accident · Serious injuriesFinal reportRobinson R22 · Windemere, FLThe inadequate preflight inspection by the pilot-in-command in that he failed to drain all the water from the fuel system, resulting in an total loss of power. Contributing to the accident was the unsuitable terrain encountered by the pilot during the…NTSB MIA95LA160Accident · No injuriesLimited investigationFinal reportPiper PA-28-200R · Rosewood, FLThe failure of the pilot-in-command to maintain speed and distance on final approach resulting in an overrun and collision with trees. A contributing factor was the failure of the pilot to obtain an adequate weather briefing prior to flight.NTSB LAX95FA225Accident · Serious injuriesField investigationFinal reportHughes 369D · Highland, CAthe pilot's failure to verify the security of his passenger's cargo/personal belongings which departed the aircraft striking the tailrotor.NTSB SEA95LA129Accident · Minor injuriesLimited investigationFinal reportSagerser Rotorway Executive · Enumclaw, WAA power surge for undetermined reasons, and the pilot's misjudgement of distance and altitude during the autorotation.NTSB MIA95IA157Incident · Minor injuriesIncident investigationFinal reportAirbus Industrie A-300-B4-103 · Atlantic Ocean (Atlantic Ocean)Failure of the passengers and flight attendants to comply with the flightcrew's instruction to fasten their seatbelts.NTSB ANC95LA082Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Anaktuvuk, AKThe pilot's inadvertent flight into instrument meteorological conditions. Factors relating to the accident were: the pilot's inadequate weather evaluation, and the weather and terrain conditions.NTSB MIA95LA156Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Atlantic Ocean (Atlantic Ocean)Loss of engine power for an undetermined reason(s).NTSB BFO95FA071Accident · 1 fatalField investigationFinal reportCessna 182P · Frederick, MDthe pilot's continued flight into known adverse weather during descent, which resulted in in-flight collision with terrain. Related factors were the pilot's disregard of a hazardous weather advisory, and the low ceilings, fog and drizzle.NTSB CHI95LA196Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Columbia, MOA loose (or missing) nut and clip for the bottom magneto stud, due to inadequate maintenance, and fatigue failure of the magneto housing flange, which restulted in an oil leak, engine compartment fire, and a forced landing. A factor relating to the accident…NTSB SEA95FA137Accident · 2 fatalField investigationFinal reportBeech A36 · Brinnon, WAThe pilot's continued VFR flight into instrument meteorological conditions, and his failure to maintain clearance from the terrain. Factors in the accident were the mountains and the clouds.NTSB FTW95LA255Accident · No injuriesLimited investigationFinal reportCessna 152 · Craig, COThe pilot became lost and disoriented, resulting in fuel exhaustion. Factors were the lack of suitable terrain for a forced landing and the operation of the aircraft with known deficiencies in equipment.NTSB ANC95FA078Accident · 5 fatalField investigationFinal reportde Havilland DHC-2 · Nondalton, AKThe failure of both pilots to maintain adequate visual lookout.NTSB CHI95LA188Accident · Serious injuriesLimited investigationFinal reportBoeing 767-222 · Champagne, ILan in-flight encounter with turbulence.NTSB ATL95LA115Accident · Serious injuriesLimited investigationFinal reportBell 47G3B1 · Livingston, ALThe loss of engine power for undetermined reasons.NTSB LAX95FA217Accident · 1 fatalField investigationFinal reportCessna 172N · Vidal Junction, CAThe pilot's failure to maintain an altitude adequate to avoid the mountainous/hilly terrain. Contributing to the accident was the glare from the setting sun.NTSB FTW95LA251Accident · Serious injuriesLimited investigationFinal reportStewart Pitts S-1S · Cleburne, TXThe pilot's misjudged flare and the ensuing hard landing. Factors were the pilot's improper fuel consumption calculations and the fuel exhaustion.NTSB CHI95LA187Accident · No injuriesLimited investigationFinal reportBell 47J2A · Elkhorn, WIloss of power as a result of an intake valve failure due to improper maintenance performed during the major engine overhaul, and pilot misjudgment of the flare during autorotation.NTSB LAX95LA215Accident · Serious injuriesLimited investigationFinal reportIssoire-Aviation PIK-30 · Dayton, NVthe pilot's delayed decision to extend and use the engine to maintain adequate terrain clearance after encountering downdrafts.NTSB LAX95LA212Accident · No injuriesLimited investigationFinal reportTupta-Smith Miniplane DSA-1 · Pacoima, CAfuel contamination.NTSB LAX95FA210Accident · 1 fatalField investigationFinal reportCessna P210N · Mammoth Lakes, CAthe pilot's continued flight into instrument meteorological conditions during dark nighttime over mountainous terrain; and his failure to maintain an adequate altitude to ensure terrain clearance. Thw weather and terrain were factors.NTSB FTW95LA249Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Fort Stockton, TXThe fuel exhaustion induced power loss due to the pilot becoming lost/disoriented. The lack of suitable terrain for the forced landing and the weather conditions were factors.NTSB CHI95LA185Accident · Serious injuriesLimited investigationFinal reportChristen Industries S-2B · Elgin, ILthe pilot's incapacitation due to alcohol and drugs which led to a loss of consciousness.NTSB BFO95FA064Accident · 3 fatalField investigationFinal reportPiper PA-31P-350 · Cedar Bluff, VAthe pilot's improper planning/decision, and his allowing the airplane to exceed its maximum design/stress limitation. Factors relating to the accident were: the adverse weather conditions, and the pilot's continued flight into adverse weather.NTSB FTW95LA242Accident · Minor injuriesLimited investigationFinal reportBellanca 14-19 · Fort Stockton, TXThe pilot's improper positioning of the fuel selector to a tank with unusable fuel. A factor was the lack of suitable terrain for the forced landing.NTSB ANC95LA075Accident · Minor injuriesLimited investigationFinal reportHughes 500D · Ketchikan, AKAn air leak at a 'b' nut fitting on a pneumatic pc tube to the power turbine governor. Company maintenance personnel did not detect a leak after performing maintenance on the governer and P2 air line.NTSB MIA95LA149Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Miami, FLTotal blockage of the air induction at the servo fuel injector by paper from an undetermined source and inadequate maintenance servicing by other maintenance personnel. Contributing to the accident was unsuitable terrain encountered by the pilot during the…NTSB LAX95LA207Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Fall River Mill, CAFatigue failure of the No. 2 lower connecting rod bolt as a result of improper torque during the last engine overhaul.NTSB LAX95LA206Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Lebec, CAFuel exhaustion due to the pilot's lack of familiarity with the airplane's fuel sysytem and his failure to maintain an adequate supply of fuel to complete the flight.NTSB CHI95LA198Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Hoxie, KSthe loss of engine power due to the loose nut on the adjustment screw and the jammed exhaust valve on the number three cylinder. A factor in the accident was the ditch.NTSB ANC95LA071Accident · No injuriesLimited investigationFinal reportGrumman G-44 · Dillingham, AKThe pilot's failure to refuel the airplane, and his improper remedial action(s) which lead to fuel starvation.NTSB LAX95LA204Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Helendale, CALoss of engine power for an undetermined reason(s). A factor in the accident was the pilot's selection of unsuitable terrain for the forced landing.NTSB FTW95LA245Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Devalls Bluff, ARThe pilot's delayed flare resulting in a hard landing. Factors were the loss of engine power due to fuel starvation as a result of fuel line blockage.NTSB BFO95LA059Accident · No injuriesLimited investigationFinal reportCessna 172E · Muncy Valley, PAthe non-instrument rated pilot's failure to maintain clearance from terrain after inadvertently entering instrument meteorological conditions. The weather conditions (haze and fog) were a factor in the accident.NTSB CHI95LA177Accident · Minor injuriesLimited investigationFinal reportCessna R172E · Plato Center, ILthe pilot's excessive pull-up during a downwind banner pick-up resulting in a stall. A factor related to the accident was the tailwind.NTSB CHI95LA193Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Rapid City, SDthe pilot's failure to feather the propeller on the left engine during the descent. A factor was the carburetor icing weather condition.NTSB ANC95LA066Accident · No injuriesLimited investigationFinal reportChampion 7GCB · Fairbanks, AKThe pilot's failure to refuel the airplane prior to fuel exhaustion. A factor associated with the accident is the lack of suitable terrain for a forced landing.NTSB BFO95LA055Accident · Minor injuriesLimited investigationFinal reportDevaughn Teenie II · Winchester, VAthe pilot's failure to properly judge the airplane fuel supply. The resultant loss of engine power occurred over unsuitable terrain, which was a contributing factor.NTSB CHI95LA186Accident · No injuriesLimited investigationFinal reportBeech A35 · Jacksonville, ILimproper maintenance and inspection of the airplane's ruddervators.NTSB ATL95LA103Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Moncks Corner, SCThe pilot's failure to properly calculate the fuel required and his fuel consumption for the flight.NTSB SEA95FA111Accident · 3 fatalField investigationFinal reportAero Commander 680 · North Bend, ORThe pilot initiating flight into weather conditions beyond what he was capable of handling. The pilot's overconfidence in his personal ability and the low ceiling were factors in the accident.NTSB NYC95FA129Accident · 2 fatalField investigationFinal reportCessna T210N · Monkton, VTfailure of the pilot to maintain sufficient altitude or clearance from mountainous terrain. Factors related to the accident were: loss of electrical power for undetermined reason(s), darkness, and the mountainous terrain.NTSB NYC95LA130Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Ashland, VAa loss of engine power due to a subsurface fatigue crack in the crankshaft which led to failure of the crankshaft.