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 FTW91FA060Accident · 2 fatalField investigationFinal reportCessna 172M · Flippin, ARThe pilot's attempted VFR flight in instrument meteorological conditions and his failure to maintain altitude.NTSB CHI91DCG01Accident · 1 fatalFinal reportAkins Stinger · Blairstown, MOAn inflight breakup after the pilot encountered weather, lost control inflight, & exceeded the design limits of the airplane. A factor was the pilot's decision to fly into known adverse weather.NTSB ANC91LA047Accident · No injuriesLimited investigationFinal reportCessna 180F · Yukon River, AKA carburetor fuel leak due to inadequate annual inspection. Contributing to the accident was the snow covered terrain.NTSB MIA91LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Vero Beach, FLFailure of maintenance personnel to follow directions of a service bulletin during the major overhaul of the engine. This resulted in failure to detect a foreign object under the crankshaft gear. As a result the crankshaft gear became loose and quit turning…NTSB BFO91LA042Accident · No injuriesLimited investigationFinal reportBeech P35 · Gilbertsville, KYThe pilot's failue to ensure the gear was fully extended during a precautionary landing after the loss of electrical power for undetermined reasons.NTSB NYC91FA099Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Naples, NYFlight by the pilot into known icing conditions, which resulted in structural (wing) ice and subsequent loss of aircraft control. The weather condition was a related factor.NTSB LAX91LA172Accident · Minor injuriesLimited investigationFinal reportHughes 369C · Papua, Papua New GuineaThe loss of control of the helicopter due to a restriction of the cyclic control system.NTSB LAX91LA154Accident · 1 fatalLimited investigationFinal reportMooney M-20E · Lee Vining, CAThe failure of the pilot to maintain adequate altitude to clear mountainous terrain. Contributing to the accident was pilot fatigue due to a lengthy cross country flight.NTSB FTW91DPG03Accident · No injuriesFinal reportGrumman G-164A · Earle, ARA power loss for undetrmined reasons. A factor was the muddy/soft terrain in which the forced landing was performed.NTSB ATL91LA075Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Pollocksville, NCFailure of the pilot to maintain adequate airspeed, which resulted in a stall/spin.NTSB ANC91LA044Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Kotzebue, AKFuel contamination (water) in both fuel tanks and fuel lines.NTSB ANC91LA049Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Alexander Creek, AKThe engine failure resulting from fuel screen contamination . A factor was the lack of suitable terrain for the forced landing.NTSB NYC91LA096Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Bar Harbor, METhe engine lost power for an undetermined reason.NTSB LAX91LA150Accident · No injuriesLimited investigationFinal reportBeech A35 · Hilt, CAThe application of a sealant instead of a lubricant to the internal 'o' rings seals in the fuel selector by maintenance personnel. Factors contributing to the accident were the pilot's inability to select a fuel source and fuel starvation that resulted in an…NTSB LAX91LA148Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Jean, NVFuel starvation due to the improper fuel management (positioning of the fuel selector) by the pilot, and his improper emergency procedures. The pilot's lack of experience in this make and model of aircraft was a related factor.NTSB ATL91FA073Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Franklin, TNThe pilot's failure to select a proper fuel tank for flight, resulting in fuel starvation to the engine, and subsequent engine stoppage. Factors were the pilot's inadequate evaluation of the weather conditions along his route of flight, and his flight into…NTSB SEA91LA074Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Friday Harbor, WAThe pilot's failure to maintain a proper climb gradient and rate as a result of his inadequate compensation for wind conditions.NTSB SEA91FA076Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Chehalis, WAA loss of engine power due to an improper overhaul.NTSB LAX91LA149Accident · Minor injuriesLimited investigationFinal reportBeech V-35-A · Superior, AZVisual flight into instrument meteorological conditions.NTSB DEN91LA055Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Watkins, COLoss of engine power for an undetermined reason, and failure of the pilot to maintain airspeed during the forced landing, which resulted in a stall/mush.NTSB BFO91LA035Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Martinsburg, WVFuel exhaustion which resulted in the loss of engine power.NTSB ATL91LA072Accident · Serious injuriesLimited investigationFinal reportCessna 182D · Greer, SCThe pilot's improper planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB NYC91LA094Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Milleville, NJThe total loss of engine power caused by mechanical failure, which resulted in the pilot landing the airplane on unsuitable terrain.NTSB MIA91LA109Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Crystal River, FLThe loss of power because of oil pump failure due to contamination. Unknown maintenance personnel performed a component change without using appropriate publications and procedures and failed to clean contaminants from the engine.NTSB FTW91LA056Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Floresville, TXThe failure of the engine due to a jammed valve, incorrect maintenance procedures, and the pilot's improper compensation for the existing wind conditions. A factor was the tailwind.NTSB NYC91LA092Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Westbrook, MEImproper emergency procedures by the pilot. Factors related to the accident were: the pilot's lack of experience and flight time in type of airplane, the pilots decision to take an airplane with a known mechanical defect, a leaky accelerator pump seal on the…NTSB CHI91LA115Accident · Serious injuriesLimited investigationFinal reportBoeing 727-222 · Buffalo, NYA clear air turbulence encounter.NTSB LAX91FA173Accident · 4 fatalField investigationFinal reportCessna 182F · Young, AZThe pilot's inadequate in-flight decision to continue VFR flight into instrument meteorological conditions and the loss of control of the airplane resulting in an inflight collision with terrain.NTSB BFO91LA033Accident · No injuriesLimited investigationFinal reportCessna 172 · Hagerstown, MDWorn camshaft lobes which resulted in the loss of engine power.NTSB ATL91FA069Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Ashland, ALContinued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficience altitude/clearance above the wooded terrain. Factors related to the accident were: the adverse weather conditions, high terrain, and the…NTSB NYC91FA095Accident · 2 fatalField investigationFinal reportCessna 120 · Simsbury, CTThe pilot's intentional flight into terrain. Contributing to the accident were psychological conditions.NTSB LAX91FA138Accident · 2 fatalField investigationFinal reportPiper PA-28R-201T · Vacaville, CAThe pilot's continued VFR flight at night under low clouds, and his failure to maintain sufficient altitude over rising terrain. Factors related to the accident were: darkness, the adverse weather and terrain conditions, and the controller's inaccurate…NTSB LAX91LA135Accident · No injuriesLimited investigationFinal reportMooney M20D · Herlong, CAThe inadequate preparation of the propeller during overhaul. The installation of an improper pitched propeller and the fatigue failure of the propeller blade emanating from corrosion were factors in the accident.NTSB DEN91LA053Accident · Serious injuriesLimited investigationFinal reportRockwell 112B · Nederland, CODeteriorated ignition harness and ignition lead arcing. Factors were the high density altitude and lack of suitable terrain for the forced landing.NTSB ATL91FA067Accident · 2 fatalField investigationFinal reportPiper PA-28-201T · Hamilton, NCThe pilot's improper use of equipment which affected the operation of the standby vacuum pump, the pilot's loss of aircraft control after experiencing spatial disorientation, and his exceeding the design stress limits of the aircraft. Factors related to the…NTSB MIA91MA100Accident · 4 fatalMajor investigationFinal reportPiper PA-46-310P · Bronson, FLThe pilot's failure to activate the pitot heat before ascending above the freezing level in instrument meteorological conditions (IMC), followed by his improper response to erroneous airspeed indications that resulted from blockage of the pitot tube by…NTSB FTW91DRD03Accident · No injuriesFinal reportGrumman G-164A · Bonita, LAA power loss due to a cracked cylinder. A factor was the soft terrain in which the forced landing was performed.NTSB LAX91FA132Accident · 10 fatalField investigationFinal reportHawker Siddeley DH.125-1A/522 · San Diego, CAImproper planning/decision by the pilot, the pilot's failure to maintain proper altitude and clearance over mountainous terrain, and the copilot's failure to adequately monitor the progress of the flight. Factors related to the accident were: insufficient…NTSB ATL91LA066Accident · 1 fatalLimited investigationFinal reportBenson B8M · Hartselle, ALThe improper installation of the main rotor bearing block by the owner/pilot which resulted in the separation of the main rotor system.NTSB MIA91LA099Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Panama City, FLCarburetor icing due to improper use of carburetor heat by the pilot, resulting in a forced landing and ditching.NTSB ATL91FA064Accident · Serious injuriesField investigationFinal reportPiper PA-34-220T · Lawrenceville, GAThe poor inflight planning by the pilot which resulted in fuel exhaustion. Factors related to this accident were the unfavorable winds, the dark night, and the inoperable airport runway lights.NTSB LAX91FA133Accident · 3 fatalField investigationFinal reportCessna 320D · Gorman, CAVFR flight into instrument meteorological conditions (IMC) by the pilot, and his failure to maintain sufficient altitude/clearance from mountainous terrain. Factors related to the accident were: the terrain and weather conditions.NTSB SEA91LA066Accident · No injuriesLimited investigationFinal reportHughes 369D · Roseburg, ORA loss of engine power for undetermined reasons. A factor related to the accident was: the lack of a suitable area for an emergency landing.NTSB ANC91LA034Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Atigan Pass, AKThe pilot continued to fly VFR into IFR conditions. Related to the accident were: low ceilings, whiteout conditions, and the mountainous terrain.NTSB MIA91LA094Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Greenwood, MSFailure of the student pilot to abort the flight when one of the two fuel quantity indicators became inoperative during the first leg of the flight. Also, inaccurate fuel consumption calculations, poor preflight planning, and poor supervision by the CFI who…NTSB LAX91LA127Accident · No injuriesLimited investigationFinal reportBell 206B · Honolulu, HIInaccurate fuel consumption calculation by the pilot. A factor was the partial deflation of the emergency flotation equipment.NTSB LAX91FA124Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Palm Springs, CAIncapacitation of the pilot due to inadequate sleep.NTSB ANC91IA039Incident · No injuriesIncident investigationFinal reportCessna U206G · Sparrevohn Afs, AKThe loss of engine power due to the ice in the fuel strainer/gascalator. Contributing was: the inadequate preflight preparation by the pilot, and unsuitable terrain on which to make the forced landing.NTSB NYC91LA084Accident · Minor injuriesLimited investigationFinal reportCessna 210 · East Swanzey, NHThe pilot's lack of familiarity with this airplane and his inadequate preflight, which resulted in miscalculations of fuel consumption and subsequent fuel exhaustion. Factors related to this accident were: the leaking of fuel caps, the inaccurate fuel…NTSB SEA91FA061Accident · 3 fatalField investigationFinal reportCessna 172M · Bellingham, WAVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain proper altitude and/or cleareance from the mountainous terrain. Factors related to the accident were: darkness and the adverse weather and terrain conditions.