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 FTW01LA184Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Fabens, TXthe pilot's inadequate preflight resulting in loss of engine power due to fuel exhaustion. A contributing factor was the power line.NTSB MIA01LA217Accident · No injuriesLimited investigationFinal reportCessna 152 · Summerfield, FLThe poor in-flight planning decision by the student pilot for his failure to turn around to avoid low ceilings resulting in a precautionary landing in a field. A contributing factor in the accident was the pilot's lack of total experience. A finding in the…NTSB DEN01LA146Accident · Serious injuriesLimited investigationFinal reportCommander 114-B · Snowmass Villag, COThe pilot's failure to maintain altitude/clearance from the rising terrain for undetermined reasons. Contributing factors include high density altitude conditions, and trees.NTSB NYC01IA211Incident · No injuriesIncident investigationFinal reportCessna 210L · Bluefield, WVImproper maintenance which resulted in the installation of an unserviceable piston assembly, and the subsequent catastrophic engine failure. Factors in this accident were the improper inspection by the piston supplier and the softening of the piston.NTSB LAX01TA278Accident · Serious injuriesFinal reportDouglas DC-3C · Alturas, CAThe inadvertent encounter with terrain induced turbulence. A factor was the high terrain.NTSB ANC01FA106Accident · 1 fatalField investigationFinal reportMaule M-6-235 · Kotzebue, AKThe pilot's failure to maintain adequate clearance from an obstruction (antenna tower), and his continued flight into instrument meteorological conditions. Factors associated with the accident were low ceilings, and low visibility.NTSB SEA01LA154Accident · No injuriesLimited investigationFinal reportRepublic RC-3 · Chimacum, WAAn internal ground in the right magneto followed by an internal ground evidenced by arcing in the left ignition coil unit, which led to failure of both the right magneto and the left coil ignition system respectively during cruise. Contributing factors were a…NTSB DEN01LA145Accident · No injuriesLimited investigationFinal reportEurocopter AS350 B-2 · Cody, WYthe pilot's inadequate in-flight planning for an off site landing, which resulted in failure of the tail rotor drive shaft due to entanglement of his long-line in the drive shaft.NTSB CHI01LA274Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Union, ILThe total failure of the crankshaft as a result of fatigue and the unsuitable terrain encountered during the forced landing. Factors associated with the accident were the soft terrain on which the forced landing was made and the subsequent gear collapse.NTSB IAD01FA096Accident · 3 fatalField investigationFinal reportPiper PA-28RT-201 · Rohrersville, MDThe pilot's continued VFR flight into obscured, mountanous terrain. Factors included the rising terrain and weather obscuration.NTSB ANC01FA102Accident · 1 fatalField investigationFinal reportCessna 185 · Tyonek, AKA loss of engine power during cruise flight due to fuel system contamination with water, and the pilot's inadequate preflight procedures. A factor in the accident was unsuitable terrain for a forced landing.NTSB MIA01LA213Accident · Serious injuriesLimited investigationFinal reportAvid Mk-4 · Salisbury, NC, An aileron control system failure during climb due to an improper welded installation by the aircraft homebuilder, resulting in an inflight loss of lateral control, and an inflight collision with the terrain during an uncontrolled descent and landing.NTSB MIA01LA212Accident · 2 fatalLimited investigationFinal reportPiper PA-32-260 · Key West, FLThe inadvertent disabling of the throttle in the idle position during a cockpit disturbance created when an armed hijacker forcibly attempted to cause the aircraft to fly to Cuba, resulting in a loss of controllability of power for sustainable flight and an…NTSB LAX01LA275Accident · Serious injuriesLimited investigationFinal reportBoeing 737-500 · Klamath Falls, ORAn encounter with turbulence from a developing thunderstorm during cruise flight.NTSB NYC01LA205Accident · Serious injuriesLimited investigationFinal reportRans S-7 · Sydnorsville, VAA loss of engine power due to an engine over-temperature condition, which resulted in a forced landing and subsequent collision with trees.NTSB IAD01LA095Accident · No injuriesLimited investigationFinal reportHughes 269C · Lewiston, NYThe pilot's failure to maintain rotor rpm during the simulated forced landing. Also causal in the accident was the failure of both pilots to recognize the total loss of engine power and the CFI's inadequate remedial actions. A factor in the accident was the…NTSB LAX01FA271Accident · Serious injuriesField investigationFinal reportCessna 336 · Palmdale, CAThe pilot's inadequate preflight inspection of the primer controls, resulting in excessive fuel flow, spark plug fouling, and loss of engine power in the aft engine.NTSB CHI01LA267Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Racine, WIThe total loss of engine power during cruise flight due to the number 3 cylinder thru-studs fatigue fractures, and the thru-stud's low hardness as a result improper heat treatment of the thru-studs, and the unsuitable terrain encountered during the forced…NTSB ANC01FA100Accident · Serious injuriesField investigationFinal reportCessna 172S · Cooper Landing, AKThe pilot's inadequate remedial action to disconnect the autopilot during an uncommanded altitude deviation while in cruise flight. Factors in the accident were activation of the autopilot; the pilot's lack of familiarity with the airplane's autopilot system;…NTSB CHI01LA265Accident · No injuriesLimited investigationFinal reportCessna 172M · Milton, WIThe unsuitable terrain for landing encountered by the pilot. Factors were the high vegetation and the loss of engine power for undetermined reasons.NTSB CHI01LA259Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Blooming Prairi, MNThe reported loss of engine power for undetermined reasons during a the cruise portion of a CFR part 137 observation, and the pilot not following the height/velocity charts data.NTSB IAD01LA091Accident · Serious injuriesLimited investigationFinal reportDelbridge Rotorway Exec 162F · Carrollton, VApilot's inadequate fuel consumption calculations, which resulted in a loss of engine power due to fuel exhaustion.NTSB CHI01LA276Accident · Serious injuriesLimited investigationFinal reportEfaw Casutt Sport Racer · Shell Lake, WIThe pilot's inadequate preflight planning/preparation and the misjudged flare that resulted in a hard landing. A factor to the accident was the loss of engine power due to fuel exhaustion.NTSB ANC01LA099Accident · No injuriesLimited investigationFinal reportCessna 207 · Healy, AKThe pilot's continued flight into adverse weather conditions after becoming lost/disoriented. Factors in the accident were rising terrain, a blind/box canyon, low clouds, and rain.NTSB CHI01LA255Accident · No injuriesLimited investigationFinal reportBeech A36 · Sugar Grove, ILthe inadequate maintenance inspection and the unsuitable terrain encountered by the pilot mechanic. The fuel system leak was a contributing factor.NTSB ANC01FA095Accident · Serious injuriesField investigationFinal reportCessna 172 · Eagle River, AKThe fatigue induced fracture of a connecting rod wrist pin, resulting in a complete loss of engine power.NTSB NYC01LA194Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · New Milford, CTSeparation of the number two connecting rod for reasons undetermined.NTSB MIA01LA202Accident · 2 fatalLimited investigationFinal reportLancair 360 · St. Marys, GAThe flight instructor/pilot in command's continued flight into known adverse weather, which resulted in a loss of control, and uncontrolled descent, and the airplane crashing into the Atlantic Ocean.NTSB DEN01FA133Accident · 1 fatalField investigationFinal reportWilson Glastar · Henefer, UTthe pilot's failure to maintain aircraft control for an undetermined reason.NTSB ANC01FA093Accident · 6 fatalField investigationFinal reportPiper PA-32-300 · Haines, AKThe pilot's continued flight into known adverse weather conditions, and his poor in-flight decision making. Factors associated with the accident were clouds and mountainous terrain. A finding is the pilot's use of FAA prohibited drugs.NTSB MIA01LA197Accident · No injuriesLimited investigationFinal reportCessna 182B · Headland, ALThe pilot's improper decision to perform a go-around while on short final to an available runway following loss of engine power for undetermined reasons when engine power was regained momentarily, which resulted in an impact with terrain while maneuvering at…NTSB IAD01FA086Accident · 2 fatalField investigationFinal reportAeronca S-65-CA · Esperance, NYThe pilot's inadequate decision and his failure to maintain obstacle clearance. Contributing factors are a transmission wire and the pilot's intentional low pass.NTSB FTW01FA171Accident · 4 fatalField investigationFinal reportCessna 205 · De Queen, ARthe pilot's VFR flight into IMC, which resulted in spatial disorientation and a loss of aircraft control. A contributing factor to the accident was the pilot's lack of total instrument flight time.NTSB DEN01LA130Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Gunnison, COthe pilot's failure to attain the proper climb rate, and his improper inflight planning/decision to attempt to cross mountainous terrain at an inadequate altitude. Contributing factors were the downdraft and the pilot's total lack of experience in mountain…NTSB NYC01LA192Accident · Serious injuriesLimited investigationFinal reportMontgomery Teenie Two · Cambridge, OHthe pilot's improper maintenance which resulted in the engine retarding to idle, and subsequent forced landing. A factor was the tall grass in the field where the forced landing was performed.NTSB NYC01LA187Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Sandy Hook, NJA total loss of engine power for undetermined reasons.NTSB MIA01TA194Accident · Minor injuriesFinal reportBell 206B-III · Jacksonville, FLthe pilot's failure to recognize and correct for unanticipated right yaw/loss of tail rotor effectiveness (LTE) during an approach to hover at a low altitude, which resulted in a loss of control and the helicopter descending and colliding with a house and the…NTSB CHI01LA245Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-51 · Detroit, MIThe passenger (an off duty flight attendant) disregarded the flight crews warning regarding turbulence along with the seat belt sign which had been turned on.NTSB SEA01TA143Accident · No injuriesFinal reportBoeing Helicopters Div. H500D · Union Gap, WAThe complete loss of engine power at cruise for undetermined reasons. Factors include a landing area that was restricted/confined due to adjacent trees, and an intentional abrupt flare resulting in a hard landing.NTSB CHI01LA237Accident · 1 fatalLimited investigationFinal reportVeith Kolb Sling Shot · Goodview, MNThe loss of engine power due to fuel starvation caused by a blocked, unsecured, fuel vent line. Contributing to the accident was the pilot's failure to maintain adequate airspeed during the forced landing which resulted in an inadvertent stall at a low…NTSB ATL01LA092Accident · Serious injuriesLimited investigationFinal reportKolb Twin Star Mark III · Edgewater, FLThe loss of flight control in-flight for undetermined reasons, that resulted in the uncontrolled collision with the ground.NTSB ATL01LA091Accident · Serious injuriesLimited investigationFinal reportMitchell T-10 · Ashland City, TNThe restricted movement of the rudder cable, resulting in a loss of control and collision with trees.NTSB NYC01LA184Accident · No injuriesLimited investigationFinal reportPohl Lancair IV-P · Fryeburg, MEA partial blockage of the air intake system, due to the pilot's failure to ensure the engine compartment was clear of paper towels after a maintenance inspection.NTSB CHI01FA231Accident · 2 fatalField investigationFinal reportWorld Helicopters 47D1 · Ballard, MOThe pilot's improper preflight planning which resulted in fuel exhaustion, and the pilot's subsequent improper autorotation.NTSB SEA01LA138Accident · Serious injuriesLimited investigationFinal reportCessna 120 · Troutdale, ORthe pilot's inadvertent visual flight rules ( VFR) flight into instrument meteorological conditions (IMC) during cruise flight. Factors include his attention being diverted to the indications presented by his Global Positioning System (GPS), and low ceiling…NTSB MIA01FA193Accident · 1 fatalField investigationFinal reportPiper PA-46-350P · Black Mountain, NCThe pilot's continued VFR flight into IMC conditions resulting in the airplane colliding with mountainous terrain.NTSB LAX01LA254Accident · Minor injuriesLimited investigationFinal reportWatkins Velocity · Winslow, AZThe separation of the number three cylinder head from the barrel resulting in a loss of engine oil during flight. Factors were the lack of suitable terrain for the forced landing, and the rough uneven ground of the forced landing site.NTSB LAX01FA253Accident · 2 fatalField investigationFinal reportMcDougall Veri EZE · Palm Springs, CAthe failure of the builder to balance the elevators per the kit manufacturer's instructions resulting in flutter and in-flight separation of the right elevator.NTSB CHI01LA221Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Bowman, NDAltitude/clearance not obtained by the pilot during the initial climb. Factors relating to the accident were attaining the proper climb rate not being possible, the microburst, the dark night, and the tree.NTSB CHI01FA230Accident · 2 fatalField investigationFinal reportBeech K35 · Grafton, IAThe pilot's improper inflight decision to continue into known adverse weather. A factor was the thunderstorm.