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 MIA89LA255Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Lexington, MSFatigue failure of the linear actuator lug. A related factor was: trees in the emergency landing area.NTSB ANC89LA171Accident · Minor injuriesLimited investigationFinal reportHelio H-250 · Near Iliamna, AKInadequate preflight planning/preparation by the pilot and his continued flight into instrument meteorological conditions (IMC). Factors related to the accident were: darkness and adverse weather conditions.NTSB NYC89LA219Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Montague, NJImproper planning/decision by the pilot which resulted in his inadvertent flight into instrument meteorological conditions (IMC). Factors related to the accident were: the adverse weather conditions and soft terrain in the emergency landing area.NTSB ANC89LA170Accident · No injuriesLimited investigationFinal reportCessna 185 · Mulchatna River, AKImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. Factors related to the accident were: loss of fuel that had siphoned (leaked) from the aircraft before takeoff and tree(s) overhanging the fast…NTSB LAX89FA319Accident · 2 fatalField investigationFinal reportCessna 310K · Ojai, CAThe pilot-in-command's intentional VFR flight into instrument meteorological weather conditions, and his failure to maintain adequate altitude to provide terrain clearance. Contributing factors were: the mountainous terrain, adverse weather conditions, and…NTSB FTW89LA169Accident · No injuriesLimited investigationFinal reportCessna 150 · Powell, TXThe pilot's improper use of carburetor heat resulting in a partial, non-mechanical power loss from carburetor icing conditions.NTSB CHI89LA191Accident · No injuriesLimited investigationFinal reportBell 206B-3 · Chicago, ILA hard landing caused by the pilot not being able to judge his altitude above or his closure rate to terrain because of high vegetation in the area available for a forced landing. An engine faulure caused by material failure of the compressor section is a…NTSB FTW89GA170Accident · 2 fatalFinal reportBeech A35 · Escondido, CASpatial disorientation of the pilot after he initiated flight into IMC conditions, and his exceeding the design stress limits of the airplane during the attempted recovery. Related factors were: the pilot's lack of total and recent instrument flight…NTSB DEN89LA221Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Neihart, MTVFR flight by the pilot into instrument meteorological conditions (IMC) and his failure to maintain sufficient altitude. Related factors were: the high terrain and adverse weather conditions.NTSB DEN89FA222Accident · 2 fatalField investigationFinal reportCessna 172N · Afton, WYThe non-instrument rated pilot's continued flight into instrument meteorological conditions (IMC) and his failure to maintain sufficient altitude to clear the terrain. Factors related to the accident were: darkness, adverse weather conditions, and…NTSB CHI89DEC08Accident · 1 fatalFinal reportWesley Striplin Ranger · Smith Creek, MIThe improper installation of the wingtip fuel tank which resulted in its inflight separation and the subsequent loss of control.NTSB FTW89LA167Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Brenham, TXImproper maintenance, improperly secured oil line to the propeller governor, failure of the propeller governor oil line, and subsequent loss of oil, which resulted in oil exhaustion. Factors related to the accident were: failure of maintenance personnel to…NTSB FTW89LA165Accident · No injuriesLimited investigationFinal reportCessna 172N · Waxahachie, TXFailure of the #3 exhaust valve due to exposure to overtemperature operating conditions.NTSB DEN89FA218Accident · 2 fatalField investigationFinal reportCessna 310I · Hesperia, CAThe non-instrument rated pilot continued VFR flight into instrument meteorological conditions (IMC) and misjudged his altitude above the terrain. Contributing factors were: the pilot's lack of instrument experience, pressure induced by his wife (the…NTSB BFO89LA080Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Haymarket, VAImproper use of the fuel selector, which resulted in fuel starvation & loss of engine power; and improper use of emergency procedures after loss of engine power. The presence of high obstructions (trees) in the approach path to the emergency landing area was…NTSB ATL89FA214Accident · 3 fatalField investigationFinal reportPiper PA-28R-180 · Gordon, ALThe improper installation of the fuel gascolator bowl by maintenance personnel, which resulted in fuel leakage and a loss of fuel pressure to the engine.NTSB MIA89LA251Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Yulee, FLImproper planning/decision by the student pilot. Factors related to the accident were: the adverse weather conditions and the tree and ditch in the emergency landing area.NTSB LAX89FA304Accident · 2 fatalField investigationFinal reportRockwell 112B · La Grange, CAContinued VFR flight into instrument meteorlogical conditions (IMC) by the pilot, which resulted in spatial disorientation and loss of aircraft control. Related factors were: flight into known adverse weather by the pilot, the adverse weather conditions, and…NTSB MKC89LA183Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Barnesville, MNThe pilot's failure to insure that the aircraft contained an adequate fuel supply to complete the flight.NTSB CHI89FA183Accident · Minor injuriesField investigationFinal reportMcDonnell Douglas MD-80 · Chicago, ILA loss of hydraulic system pressure due to the operator's failure to replace a system component that had a known history of failures, and the pilot's improper use powerplant controls resulting in a degradation of rudder effectiveness. A contributing factor…NTSB SEA89LA171Accident · Minor injuriesLimited investigationFinal reportYakovlev YAK 11 · Reno, NVThe right main landing gear did not fully extend for an undetermined reason. Factors that contributed to the accident were: an engine power loss for unknown reasons and the rough terrain.NTSB SEA89LA169Accident · No injuriesLimited investigationFinal reportCessna 152 · Ellensburg, WAThe pilot's failure to obtain current in-flight wind information in order to calculate that his remaining fuel supply was adequate to reach his final destination. Contributing was his inadequate preflight planning.NTSB SEA89LA167Accident · No injuriesLimited investigationFinal reportRobinson R22 · Kent, WAThe instructor pilot's failure to take timely corrective action to recover from a low rotor RPM condition, resulting in impact with the ground.NTSB DEN89FA209Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Lk Havasu City, CAPilot's attention diverted outside the airplane. This diversion resulted in the pilot failing to monitor his altitude while in a descending turn and inadvertently flying the airplane into the water.NTSB MKC89LA192Accident · Minor injuriesLimited investigationFinal reportPietenpol AIR Camper B4A · Horatio, ARImproper use of carburetor heat by the pilot, which resulted in carburetor ice. A factor related to the accident was: carburetor icing conditions.NTSB LAX89LA297Accident · No injuriesLimited investigationFinal reportBell 206B · Murrieta, CAA partial loss of engine power due to contaminates in the fuel control unit. The origin of the contaminates was not determined. Contributing factor(s) was: the helicopter was not equipped with floats.NTSB SEA89LA164Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Lester, WAThe pilot's loss of control of the aircraft due to his improper use of the aircraft flight controls. Contributing factors in the accident were the moderate turbulence and trace mixed icing in clouds.NTSB MKC89LA193Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chanhassen, MNEngine assembly dowell pin sheared causing total powerplant failure and inadequate visual lookout by the driver of the ground vehicle.NTSB CHI89IA179Incident · Minor injuriesIncident investigationFinal reportBoeing 767-231 · Knox, INThe radar controlller's failure to maintain radar separation. Factors contributing to the incident were: misunderstanding of an ATC instruction by the pilot of the incident airplane, and unclear phraseology used in the instructions issued by the radar…NTSB DEN89LA206Accident · No injuriesLimited investigationFinal reportCessna T210M · Rangely, COForced landing in unsuitable terrain as a result of an engine crankshaft failure.NTSB MIA89LA242Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Perry, FLFuel starvation due to wear and restricted movement of the carburetor float, which resulted in loss of engine power. Soft terrain in the emergency landing area contributed to overload failure of the nose gear.NTSB MIA89LA240Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Cayey, PRLoss of engine power for an unknown reason. A factor related to the accident was: the presence of trees in the emergency landing area.NTSB FTW89LA157Accident · No injuriesLimited investigationFinal reportCessna 150J · Dallas, TXPilot's failure to accurately calculate the necesary fuel for the flight and assure that the aircraft had been refueled to provide that quantity.NTSB NYC89LA207Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Sanbornton, NHVFR flight into instrument meteorological conditions (IMC) by the pilot, and his inadequate remedial action to correct the situation. The adverse weather conditions and darkness were related factors.NTSB NYC89FA206Accident · 4 fatalField investigationFinal reportCessna 172P · Northfield, NHThe pilot initiated flight into known adverse weather which resulted in a loss of control. Contributing factor(s) was: the pilot's overconfidence and the existing weather conditions.NTSB MIA89LA238Accident · No injuriesLimited investigationFinal reportCessna 177 · Woodville, MSImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. Factors related to the accident were: darkness and the ditch.NTSB LAX89DUQ05Accident · 2 fatalFinal reportRuppercht Varieze · California City, CAThe wing failed due to the pilot/owners overtorquing the wing bolts and the improper installation of the wing attach plates/cones.NTSB ATL89LA208Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Spruce Pine, NCA loss of power for undetermined reasons. The power loss may have been due to a sticking valve(s).NTSB ATL89LA206Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Hickory, NCPilot's failure to adequately monitor the engine fuel consumption in flight.NTSB ANC89FA155Accident · Minor injuriesField investigationFinal reportCessna 180 · Anchorage, AKOil leak in the oil cooler. Contributing factors were: oil film on the windshield, which obscured the pilot's vision (visual perception) and hampered his ability to attain proper runway alignment, an object (rock), and high vegetation beside the airstrip.NTSB NYC89LA209Accident · Serious injuriesLimited investigationFinal reportCessna 210 · No. Windham, VTThe pilot's failure to assure an adequate supply of fuel was available.NTSB LAX89LA298Accident · No injuriesLimited investigationFinal reportStinson 108 · Cool, CAFailure of the #2 piston. Failure of the mechanic to properly overhaul the engine was a related factor.NTSB NYC89LA205Accident · No injuriesLimited investigationFinal reportCessna 210N · Westerly, RIThe pilot-in-command's failure to properly ensure a sufficient quantity of fuel for the intended flight.NTSB LAX89LA292Accident · No injuriesLimited investigationFinal reportCessna 172 · Bullhead City, AZFailure of the pilot to adequately perform inflight fuel consumption calculations to ensure the adequacy of the fuel supply for the flight's completion. Contributing to the accident was the failure of the pilot to consider the impact of the stronger than…NTSB SEA89FA160Accident · 4 fatalField investigationFinal reportCessna 152 · Snohomish, WAThe pilot's failure to see and avoid N49231, a Cessna 172. Contributing factors were: a flight path directly into the setting sun, and the low light conditions of dusk on the ground below.NTSB MKC89FA191Accident · 2 fatalField investigationFinal reportPiper PA-20 · Moose Lake, MNSevere corrosion of the lower forward lift strut for the right wing, inadequate inspection of the lift strut by maintenance personnel, and subsequent failure of the lift strut, which resulted in an overload failure (folding back) of the wing. Related factors…NTSB FTW89GA156Accident · Minor injuriesFinal reportPiper PA-18-150 · Grand Chenier, LAOn August 30, 1989, at 1225 CDT, a Piper PA-18-150, N4423Z,being operated by and conducting an aerial survey forlouisiana wildlife and fisheries commission as a publicaircraft, flipped forward to the inverted position during aforced landing 15 miles…NTSB NYC89FA204Accident · 1 fatalField investigationFinal reportCessna U206F · West Point, NYContinued VFR flight by the pilot into an area of marginal visual meteorological conditions, and his failure to maintain sufficient altitude over mountainous/hilly terrain. Factors related to the accident were: dark night, high terrain, low clouds/ceiling,…NTSB FTW89FA155Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Pauls Valley, OKImproper planning/decision by the pilot, his lack of understanding of the procedures for operating the aircraft, his improper use of the fuel selector in managing his fuel supply, fuel starvation, and the pilot's failure to know and follow the emergency…NTSB DEN89FA202Accident · 4 fatalField investigationFinal reportAerospatiale AS-350D · Blanchard, IDOverheating and seizure of the swashplate bearing, which resulted in an inflight breakup of the helicopter and subsequent impact with the ground.