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 LAX07LA114Accident · No injuriesLimited investigationFinal reportMooney M20B · St. George, UTOil contamination of the right magneto. Factors were the airplane owner's failure to comply with manufacturer's service bulletins and overhaul porcedures.NTSB ATL07LA054Accident · 1 fatalLimited investigationFinal reportJames Walter Hornet · Talbotton, GAThe failure of the right main fuel line, resulting in fuel starvation and a loss of engine power.NTSB LAX07CA111Accident · Serious injuriesData collectionFinal reportCessna 182 · Diamond Lake, ORFuel exhaustion due to the pilot's inadequate preflight inspection and failure to verify the fuel supply. A factor was the night lighting condition.NTSB ATL07LA052Accident · Minor injuriesLimited investigationFinal reportBell 47G2A · Huntsville, ALThe loss of engine power due to undetermined reasons.NTSB MIA07LA059Accident · No injuriesLimited investigationFinal reportRobinson R-44-II · Miami, FLThe pilot's failure to maintain sufficient rotor rpm during an autorotative landing, which resulted in a hard landing and separation of the tailboom.NTSB LAX07LA108Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Paris, IDa loss of power in the right engine for undetermined reasons.NTSB ATL07CA051Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Collinwood, TNThe pilots improper inflight planning which resulted in a loss of engine power due to fuel exhaustion.NTSB SEA07CA076Accident · No injuriesData collectionFinal reportCessna 182H · Phoenix, AZThe pilot's inadequate preflight inspection, resulting in fuel exhaustion and the loss of power. A factor was the sign.NTSB DEN07CA073Accident · No injuriesData collectionFinal reportAerospatiale SA315B · Norwood, COThe inflight collision with a bird(s).NTSB DEN07CA072Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Broomfield, COThe instructor's failure to maintain aircraft control. A contributing factor was the windshear.NTSB NYC07CA076Accident · Minor injuriesData collectionFinal reportBellanca 17-30A · Farmingdale, NJThe pilot's failure to verify the amount of fuel onboard before takeoff. Factors in the accident were the airplane being under fueled, the refueler's experience, the airplane's inoperative fuel gauges, unsuitable terrain for landing, and night lighting…NTSB CHI07MA083Accident · 1 fatalMajor investigationFinal reportMcDonnell Douglas 369FF · Haena, HIThe fatigue failure of the tail rotor blade root fitting due to a manufacturing defect which resulted in the separation of the tail rotor system and loss of tail rotor control. A contributing factor to the accident were the trees that the helicopter struck…NTSB LAX07FA103Accident · 3 fatalField investigationFinal reportPiper PA-28-235 · Tooele, UTThe pilot exceeded the design stress limits of the airplane, which resulted in the in-flight separation of the wings and horizontal stabilizers. Contributing to the accident were the night lighting conditions, clouds, turbulence and icing conditions.NTSB CHI07LA080Accident · 1 fatalLimited investigationFinal reportWood Quickie Q-2 · Edwardsville, ILThe loss of engine power during cruise due to loose cylinder head bolts/loose cylinders.NTSB LAX07LA099Accident · 1 fatalLimited investigationFinal reportMallian Rocket II · Arvin, CALoss of control during cruise for undetermined reasons.NTSB LAX07CA098Accident · No injuriesData collectionFinal reportMooney M20D · Visalia, CAThe pilot's inadequate in-flight fuel system management, which resulted in fuel starvation and a loss of engine power.NTSB MIA07LA055Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Miami, FLThe pilot-in-command's (CFI) continued operation of the airplane with known deficiencies (rough running engine). A factor in the accident was no suitable terrain for a forced landing.NTSB NYC07CA080Accident · No injuriesData collectionFinal reportMooney M20F · Landenberg, PAThe pilot's improper preflight planning, which resulted in a loss of engine power due to fuel exhaustion, and subsequent forced landing to a field.NTSB DFW07LA078Accident · Serious injuriesLimited investigationFinal reportCessna T182T · Athens, TXThe loss of engine power as result of the failure of a mechanic to properly check the torque on the input and output fuel lines to the fuel transducer during the manufacturing process. A contributing factor was the lack of suitable terrain for the forced…NTSB MIA07LA054Accident · Serious injuriesLimited investigationFinal reportMark Gibson BB Trike · Sarasota, FLThe total loss of engine power for undetermined reasons. A factor in the accident was the unsuitable terrain encountered by the pilot during the forced landing.NTSB CHI07LA078Accident · Serious injuriesLimited investigationFinal reportBoeing 777 · Chicago, ILAn in-flight encounter with turbulence during cruise flight.NTSB ATL07LA044Accident · Serious injuriesLimited investigationFinal reportPiper PA-31-350 · Phenix City, ALLoss of engine power due to fuel starvation, the pilot's inadequate preflight planning, and his misunderstanding of how the fuel system operates. Contributing to the accident was the manufacturers insufficiently defined procedures for low fuel operations,…NTSB MIA07LA050Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Fountain, FLA loss of engine power due to a cracked engine exhaust muffler. Contributing to the accident were the inadequate inspection procedures of the muffler system and the routing of the "P" leads wiring for the magnetos.NTSB LAX07IA093Incident · No injuriesIncident investigationFinal reportColumbia LC41-550FG · Banning, CAJammed aileron flight control during cruise flight due to the presence of foreign object debris, which resulted from the manufacturer's improper processes.NTSB CHI07LA071Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Pellston, MIThe fatigue failure of the engine cylinder which resulted in a complete loss of engine power, and the unsuitable terrain encountered by the pilot during the subsequent forced landing. Contributing to the accident were the night lighting condition, and trees.NTSB NYC07IA063Incident · No injuriesIncident investigationFinal reportAirbus A-320-232 · New York, NYThe in-flight fire which was caused by the catastrophic failure of a 9-volt battery from an unknown cause.NTSB DEN07CA070Accident · No injuriesData collectionFinal reportMooney M20K · Ingalls, KSThe pilot's inadequate in-flight planning and decision making, and failure to refuel while en route, resulting in loss of engine power during cruise due to fuel exhaustion. Contributing to the accident was the poor weather at the pilot's destination.NTSB ATL07LA041Accident · No injuriesLimited investigationFinal reportBeech A36 · Brunswick, GAThe pilot's failure to activate the electric fuel pump following a loss of engine power for undetermined reasons.NTSB ATL07FA040Accident · 4 fatalField investigationFinal reportBeech A36 · Hinesville, GAThe pilot's failure to maintain aircraft control resulting in the in-flight breakup of the airplane due to aerodynamic overload. Contributing to the accident were airframe icing and the pilot's impairment by illegal drugs.NTSB ANC07CA019Accident · No injuriesData collectionFinal reportAero Commander 100 · Manokotak, AKThe pilot's continued VFR cruise flight into instrument meteorological conditions, which resulted in an in-flight collision with terrain. Factors associated with the accident were fog, low ceilings, snow showers, and snow-covered terrain.NTSB SEA07FA051Accident · 3 fatalField investigationFinal reportBeech 200 · Belgrade, MTThe pilot's failure to maintain an adequate altitude and descent rate during a night visual approach. Dark night conditions and mountainous terrain are factors in the accident.NTSB SEA07LA060Accident · 1 fatalLimited investigationFinal reportBrown Pitts S-1 · Incline Vlg, NVThe airplane collided with a frozen lake for undetermined reasons. Contributing to the accident was the pilot's intentional operation of the airplane while impaired by alcohol and the FAA's failure to obtain additional information about the pilot's…NTSB DFW07CA065Accident · No injuriesData collectionFinal reportMcDonnell Douglas 600N · Vicksburg, MSThe loss of engine power due to fuel starvation as result of a fuel transfer check valve stuck in the closed position. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX07FA080Accident · 1 fatalField investigationFinal reportMooney M20J · Ranchita, CAThe pilot's failure to maintain terrain clearance during a cruise descent. Contributing to the accident were the dark night lighting conditions and the mountainous terrain.NTSB LAX07LA078Accident · No injuriesLimited investigationFinal reportRepublic RC-3 · Julian, CAThe failure of the propeller to crankshaft attachment bolts due to fatigue. A contributing factor was the improper installation of the propeller assembly by maintenance personnel.NTSB CHI07LA063Accident · No injuriesLimited investigationFinal reportRaytheon B200 · Cape Girardeau, MOThe company pilot's poor judgment before and during the flight, including turning the oxygen system ready switch to the OFF position after he conducted the preflight inspection and using an unapproved checklist, which did not provide guidance for a fractured…NTSB CHI07LA062Accident · 2 fatalLimited investigationFinal reportHallburg Amphibian S21D · Grinnell, IAThe inadequate preflight planning/preparation by the pilot in command and the fuel exhaustion during cruise flight. An additional cause was the inadequate forced landing procedure. A contributing factor was the tailwind.NTSB ATL07FA038Accident · 2 fatalField investigationFinal reportCessna 172K · Bessemer, ALThe non-instrument-rated pilot's continued visual flight rules flight into instrument meteorological conditions.NTSB LAX07CA077Accident · Serious injuriesData collectionFinal reportBombardier DHC-8-103 · Kaunakakai, HIan in-flight encounter with clear air turbulence, which resulted in a serious injury to a deadheading crewmember.NTSB SEA07LA055Accident · No injuriesLimited investigationFinal reportCessna 421 · Pocatello, IDThe separation of the bolt that attaches the elevator trim tab actuator rod to the elevator trim tab horn, resulting in violent flutter of the elevator, and eventually to the separation of the inboard half of the right elevator.NTSB NYC07CA060Accident · Serious injuriesData collectionFinal reportSchweizer SGS 2-32 · Bath, PAThe pilot's misjudged altitude/distance while on approach, which resulted in an in-flight collision with trees during an off airport landing. A factor in the accident was the loss of lift.NTSB ATL07FA036Accident · 1 fatalField investigationFinal reportCessna T210M · Haddock, GALoss of engine power for undetermined reasons.NTSB DFW07CA059Accident · No injuriesData collectionFinal reportPiper PA-46-310P · Madison, MSThe loss of engine power due to water contamination in the fuel system. A factor was the muddy terrain.NTSB MIA07CA045Accident · No injuriesData collectionFinal reportCessna 172S · Sanford, FLThe inadvertent inflight collision with a bird resulting in damage to the airplane and the pilot having limited control capability.NTSB DFW07LA061Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Fulshear, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX07LA075Accident · Minor injuriesLimited investigationFinal reportJihlavan KP-5 · Moorpark, CAa partial loss of power for undetermined reasons.NTSB DEN07IA055Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Cripple Creek, COA fatigue fracture, which resulted in the separation of the No.1 engine fan disk. Contributing factors in the accident were the operators' maintenance personnel lack of training to be able to detect arc-out damage on the fan disk, and the fan disk…NTSB SEA07LA052Accident · No injuriesLimited investigationFinal reportCessna 172D · Beaver Marsh, ORThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX07CA094Accident · No injuriesData collectionFinal reportGeneral Balloon AX-6 · San Martin, CAThe pilot's failure to maintain adequate altitude/clearance from power lines.NTSB DEN07FA054Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Centennial, WYthe pilot's inadvertent flight into adverse weather conditions resulting in a loss of aircraft control. Contributing factors include the pilot's improper preflight planning and decision making, the pilot's spatial disorientation, the pilot's lack of night…