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 CHI99LA352Accident · No injuriesLimited investigationFinal reportCessna 150M · Lebanon, MOA loss of engine power due to a fractured shaft supporting the number three cylinder rocker arm. A factor relating to this accident was the trees.NTSB CHI99LA319Accident · No injuriesLimited investigationFinal reportVan Grouw White Lightning · Greenfield, INimproper installation of the oil quick drain plug which resulted in oil exhaustion to the engine. A factor was the corn crop encountered during the forced landing.NTSB ATL99LA125Accident · No injuriesLimited investigationFinal reportCessna 172P · Buchanan, GAThe loss of engine power for undetermined reasons. Factors were conditions favorable for the formation of carburetor ice during glide and cruise, and rough and uneven terrain.NTSB LAX99LA295Accident · No injuriesLimited investigationFinal reportCessna 150M · Menlo Park, CAThe fatigue failure of the left muffler rear wall, which resulted in hot exhaust gasses being ported onto, and shorting, the magneto p-lead wires. The failure of maintenance personnel to detect the impending failure of the muffler during the recent engine…NTSB DEN99LA174Accident · No injuriesLimited investigationFinal reportCessna P210N · Santa Fe, NMA non-mechanical total loss of engine power for reasons undetermined. Factors were maneuvering to avoid oncoming vehicles, and the rough and uneven terrain.NTSB CHI99LA320Accident · Serious injuriesLimited investigationFinal reportCessna 172D · South Wayne, WIthe pilot's improper selection of an emergency field and failure to maintain clearance from the trees. The cause of the loss of engine power was not determined.NTSB ATL99FA122Accident · 3 fatalField investigationFinal reportMooney M20J · Gainesville, GAThe pilot's failure to maintain flying speed which resulted in a stall and the subsequent collision with terrain.NTSB ANC99FA130Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Bettles, AKThe pilot's continued flight into known adverse weather conditions. Factors in the accident were low ceilings and snow.NTSB LAX99LA291Accident · Serious injuriesLimited investigationFinal reportBoeing 737-322 · Santa Barbara, CAThe flight's encounter with wake vortices from a preceding heavy aircraft.NTSB LAX99FA294Accident · 1 fatalField investigationFinal reportMooney M20D · Bear Valley, CAThe pilot's in-flight loss of control for undetermined reasons.NTSB ANC99LA126Accident · No injuriesLimited investigationFinal reportCessna A185E · Anchorage, AKThe total loss of engine power for an undetermined reason.NTSB SEA99FA152Accident · 3 fatalField investigationFinal reportCessna T210M · Marcola, ORThe pilot's failure to maintain clearance from the terrain while descending in an area of deteriorating weather. Factors include mountainous terrain, clouds, low ceilings, the pilot's inadequate preflight weather analysis, and his improper decision to attempt…NTSB SEA99FA150Accident · 4 fatalField investigationFinal reportCessna 182E · Ryegate, MTThe pilot's continued VFR flight into IMC conditions and his failure to maintain clearance from mountainous terrain. Factors include low ceilings and inadequate in-flight planning.NTSB MIA99LA243Accident · No injuriesLimited investigationFinal reportPowers Rotorway Exec 162 · Lutz, FLa loss of power due to undetermined reasons, resulting in a forced landing and subsequent impact with the ground. A factor in this accident was the pilot was not qualified or certified in helicopters.NTSB LAX99LA287Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Emigrant Gap, CAThe fatigue failure and separation of the number three cylinder due to the cylinder overhaul facility's improper inspection and quality control processes.NTSB ANC99LA127Accident · No injuriesLimited investigationFinal reportMaule M-7 · Kotzebue, AKAn in-flight collision with a bird.NTSB CHI99IA350Incident · No injuriesIncident investigationFinal reportBritish Aerospace Jetstream 3101 · South Bend, INthe right engine accessory section's splined gear spur gear failure during cruise flight.NTSB ATL99LA119Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Mountain City, TNA blocked fuel system vent that resulted in fuel starvation and the complete loss of engine power.NTSB NYC99LA212Accident · No injuriesLimited investigationFinal reportCessna 150 · Madison, OHThe pilot's delay in using carburetor heat which resulted in a partial loss of engine power, and a forced landing.NTSB NYC99FA214Accident · 4 fatalField investigationFinal reportCessna 172N · Dyke, VAThe pilot's inadvertent flight into instrument meteorological conditions, which resulted in his inability to see the rapidly rising terrain. A factor was the pilot's inaccurate evaluation of the weather.NTSB MIA99LA238Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Jackson, ALthe pilot's inadequate preflight planning and preparation, which resulted in taking off with the airplane's maximum gross weight exceeded, and subsequent impact with trees. Factors in this accident were high temperatures and an in-flight encounter with a…NTSB NYC99LA209Accident · Serious injuriesLimited investigationFinal reportMorrisey 2150A · Ellisburg, NYThe pilot's delay in applying carburetor heat which resulted in the loss of power, and his misjudgment of the flare during the forced landing.NTSB MIA99LA234Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Robbins, TNThe total loss of engine power due to failure of maintenance personnel to assure that the thru bolt nut at the Nos. 2 and 3 cylinders was adequately torqued following removal and replacement of the No. 3 cylinder approximately 328 hours earlier. Also, the…NTSB ANC99LA118Accident · No injuriesLimited investigationFinal reportCessna 206 · Anaktuvuk Pass, AKThe pilot's continued flight into adverse weather conditions after becoming lost/disoriented. Factors in the accident were rising terrain, a blind/box canyon, and weather conditions consisting of clouds, rain, and fog.NTSB NYC99LA208Accident · 2 fatalLimited investigationFinal reportKlotz Kolb Mark III · Scott, OHThe pilot's failure to maintain airspeed, which resulted in a stall, after he experienced a loss of lift due to an improperly installed gap seal.NTSB CHI99LA308Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Granite City, ILLoss of power for undetermined reason(s) and the rough/uneven.NTSB LAX99LA277Accident · No injuriesLimited investigationFinal reportCessna T210L · Byron, CAThe failure of the operator's maintenance personnel to properly torque the cylinder and engine case through bolts during the replacement of five cylinders, which led to the spinning of the No. 2 main bearing and the resultant oil starvation induced…NTSB DEN99LA164Accident · No injuriesLimited investigationFinal reportCessna 180 · Columbus, NMFuel exhaustion because the pilot issued instructions that the fuel tanks not be filled to capacity. A factor was the unsuitable terrain on which to make a forced landing.NTSB NYC99LA207Accident · No injuriesLimited investigationFinal reportCessna 152 · Rockville, VAFuel exhaustion as a result of the pilot's improper in-flight planning/decision.NTSB LAX99FA273Accident · Serious injuriesField investigationFinal reportBalloon Works Firefly 11 · Cave Creek, AZAn unforecast encounter with a low level microburst that resulted in a distortion of the balloon envelope, an excessive outflow of hot air (loss of lift), creating an excessive rate of descent that was beyond the performance capability of the balloon to…NTSB LAX99LA268Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Sacramento, CAFuel exhaustion due to the pilot's failure to ensure that sufficient fuel was on board to complete the flight, and, the flight instructor's inadequate supervision of the flight.NTSB LAX99FA270Accident · Serious injuriesField investigationFinal reportBeech J35 · Marysville, CAA loss of engine power due to improperly torque cylinder base nuts by maintenance personnel during a top overhaul.NTSB ANC99LA120Accident · No injuriesLimited investigationFinal reportCessna 182Q · Fairbanks, AKA loss of engine power for an undetermined reason. A factor was unsuitable terrain for a forced landing.NTSB NYC99LA202Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Prattsburg, NYPropeller blade separation, resulting from fatigue cracking initiated by intergranular corrosion. A factor was the lack of propeller blade corrosion inspection requirements.NTSB CHI99LA292Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Hudson, MIwas an inadequate preflight and misjudged flare to landing during the autorotation by the pilot. A factor in this accident was a totally blocked fuel tank vent system.NTSB CHI99FA293Accident · 2 fatalField investigationFinal reportHudson Avenger · Lansing, ILthe weight and balance exceeded by the owner/builder. The inadequate preflight planning/preparation by the owner/builder.NTSB NYC99FA199Accident · 3 fatalField investigationFinal reportCessna P210N · Worcester, VTThe pilot's inadequate in-flight planning/decision, his failure to follow the published instrument departure procedure for the particular runway, and his continued flight into known adverse weather. A factor was thunderstorms.NTSB LAX99LA269Accident · No injuriesLimited investigationFinal reportCessna 152 · Buckeye, AZfuel exhaustion due to the pilot's inaccurate fuel consumption calculations used in flight planning.NTSB ATL99LA116Accident · Minor injuriesLimited investigationFinal reportCessna R172-E · Chiefland, FLPremature fuel exhaustion due to a cracked fuel line. Contributing to the severity of the accident was the electrical service drop line, which crossed the roadway.NTSB NYC99LA200Accident · Minor injuriesLimited investigationFinal reportCessna 208 · Hillsborough, NHan inadequate auxiliary fuel tank installation which resulted in a leak of undetermined origin.NTSB CHI99FA290Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Paw Paw, MIthe pilot flew into known adverse weather, the pilot's lack of total instrument flight experience, and the pilot exceeded the design limits of the airplane. Factors included the pilot's total lack of experience in the type of operation and the pilot's…NTSB FTW99LA220Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Humphrey, ARFuel exhaustion as a result of the pilot's failure to refuel the airplane.NTSB SEA99FA138Accident · Serious injuriesField investigationFinal reportBeech H-35 · Swan Lake, MTDetonation/pre-ignition due to use of improper grade and type of fuel (automotive) and the pilot-in-command's failure to use proper fuel specified by manufacturer's directives.NTSB MIA99LA228Accident · No injuriesLimited investigationFinal reportWilliam John Schulz WJS Jaybird · Tangerine, FLthe pilot's improper torqueing of a rocker arm adjusting jam nut, that resulted in the adjuster loosening, and a partial loss of engine power. This resulted in the pilot making an off airport precautionary landing and subsequent nose over, during which the…NTSB SEA99LA136Accident · Minor injuriesLimited investigationFinal reportCessna 182G · Freeland, WAThe pilot-in-command's improper use of carburetor heat and overload of the nose gear assembly during the forced landing. Contributing factors were carburetor icing conditions, the ditch and fence.NTSB MIA99LA218Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Greeneville, TNThe pilot's failure to remain clear of clouds while operating under visual flight rules resulting in the aircraft colliding with trees on rising terrain as he flew in the clouds.NTSB FTW99LA250Accident · No injuriesLimited investigationFinal reportCessna 177 · Austin, TXFuel exhaustion as a result of the pilot's failure to refuel the airplane.NTSB DEN99LA140Accident · No injuriesLimited investigationFinal reportPzl-Mielec M-18A · Hasty, COThe pilot's failure to refuel his airplane, and the subsequent airborne fuel exhaustion. Factors were the lack of suitable terrain for a forced landing, and the high vegetation in the field.NTSB CHI99LA286Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Evansville, INfuel exhaustion due to the flight instructor's improper in-flight decision. A factor was the ditch.NTSB FTW99LA213Accident · No injuriesLimited investigationFinal reportCessna 172N · Hot Springs, ARthe pilot's failure to refuel the airplane which resulted in fuel exhaustion and a total loss of engine power. A factor was the lack of suitable terrain for a forced landing.