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 CHI05CA256Accident · No injuriesData collectionFinal reportBoeing A75N1 · Ellisville, ILThe loss of engine power due to the failure of the number four connecting rod. A factor to the accident was the soybean crop.NTSB IAD05LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Babylon, NYA broken piston and exhaust valve tappet which resulted in a total loss of engine power, and a forced landing to unsuitable terrain. A contributing factor was the failure of the operator to overhaul the engine at the manufacturer's recommended interval.NTSB DFW05MA230Accident · Serious injuriesMajor investigationFinal reportSikorsky S76 · Gulf of Mexico, TXThe pilots' delayed response to the No. 1 engine fire warning and the loss of power to both engines, which occurred for undetermined reasons. The pilots' delayed response was most likely due to stress and fatigue. Contributing to the delay of the initiation…NTSB ATL05CA158Accident · Minor injuriesData collectionFinal reportChristen Industries S-2B · Deeherd, TNThe pilots inadequate preflight of the fuel tank resulting in a total loss of engine power in cruise flight, forced landing, and nose over on landing roll out.NTSB LAX05CA297Accident · No injuriesData collectionFinal reportBeech C23 · Jiggs, NVthe pilot's encounter with a downdraft.NTSB SEA05LA187Accident · No injuriesLimited investigationFinal reportCessna 182E · Toutle, WAThe loss of engine power as a result of fuel exhaustion due to the pilot's failure to properly secure the fuel caps during his self-servicing and (improperly) preflighting the airplane. A contributing factor was the utility pole.NTSB IAD05LA147Accident · Minor injuriesLimited investigationFinal reportHanson VariEze · New Cumberland, PAThe owner/builder's inadequate fuel tank inspection during construction, which resulted in fuel contamination and subsequent fuel starvation to the engine.NTSB ATL05CA157Accident · Minor injuriesData collectionFinal reportCessna 172F · Haleyville, ALThe pilots inadequate preflight of the fuel tank resulting in a total loss of engine power in cruise flight due to fuel exhaustion, resulting in a forced landing, and nose over on landing roll out.NTSB CHI05CA267Accident · No injuriesData collectionFinal reportWest Revolution Mini 500 · Ida, MIThe pilot's abrupt (improper) control action which resulted in the main rotor contacting the tail boom. Contributing factors were the false indication provided by the engine tachometer, the pilot's decision to immediately initiate an autorotation instead of…NTSB IAD05LA130Accident · No injuriesLimited investigationFinal reportCessna 172S · Kutztown, PAThe pilot's failure to attain a proper touchdown point as a result of the airplane's excessive airspeed. A factor was the partial loss of engine power due to a seized exhaust valve.NTSB LAX05CA285Accident · No injuriesData collectionFinal reportBellanca 7ECA · Malibu, CAa partial loss of engine power for undetermined reasons.NTSB CHI05LA243Accident · 1 fatalLimited investigationFinal reportAllensworth Baby Belle · El Dara, ILThe manufacturer failed to specify a relief radius on the tail rotor spindle drawings, which resulted in the spindle being manufactured with an inadequate relief radius at the point of fatigue failure.NTSB ATL05LA154Accident · 2 fatalLimited investigationFinal reportSamson Seawind 3000 · Wrightsville Bh, NCThe pilot's improper preflight decision to attempt night VFR flight into IMC, which resulted in an inflight encounter with weather and the pilot's subsequent loss of control of the airplane due to spatial disorientation.NTSB ATL05CA155Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Destin, FLThe loss of engine power for undetermined reasons.NTSB NYC05LA139Accident · No injuriesLimited investigationFinal reportTerrio Pober Jr Ace · Oxford, CTA fractured oil pressure line, which resulted in the fracture of the number 3 cylinder connecting rod bearing, and subsequent loss of engine power.NTSB IAD05FA146Accident · 3 fatalField investigationFinal reportPiper PA-28RT-201 · Dunkirk, NYLoss of control for undetermined reasons.NTSB LAX05LA279Accident · Minor injuriesLimited investigationFinal reportBeech 35-A33 · Alturas, CAThe loss of engine power for undertermined reasons.NTSB NYC05LA137Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-D · Sandy Lake, PAA total failure of the engine driven fuel pump, and the pilot's failure to recognize a diminishing fuel supply in the fuselage (header) fuel tank, which resulted in a total loss of engine power during cruise flight and subsequent collision with trees during a…NTSB SEA05LA179Accident · No injuriesLimited investigationFinal reportAmerican Champion 7KCAB · Richland, WAThe oil pressure gauge line fitting coming loose from the engine, resulting in the loss of oil to the point where internal engine components were starved for oil, leading to extensive internal damage and seizing of the engine. Factors include a set of eight…NTSB ATL05CA151Accident · Minor injuriesData collectionFinal reportPiper PA-18-105 · N. Myrtle Beach, SCThe loss of engine power due to the pilot's failure to use carburetor heat, which resulted in the formation of carburetor ice.NTSB DFW05CA219Accident · No injuriesData collectionFinal reportCessna 172R · Springtown, TXThe pilot's improper decision to shut down the engine. Contributing factors were the failure of the oil pressure switch and the lack of a suitable landing area.NTSB CHI05CA236Accident · No injuriesData collectionFinal reportYamokoski Glastar · Marcellus, MIThe in-flight loss of engine power during cruise for undetermined reasons and the unsuitable terrain the pilot encountered during the forced landing. A factor was the tall corn he encountered.NTSB SEA05CA175Accident · No injuriesData collectionFinal reportCessna 150J · Roseburg, ORThe loss of engine power as a result of fuel exhaustion due to the pilot's inadequate in-flight planning and failure to refuel the airplane. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN05FA128Accident · Serious injuriesField investigationFinal reportPiper PA-32-300 · Vail, COthe pilot's improper in-flight planning and decision making and failure to maintain clearance from the terrain. Contributing factors include the pilot's attempt to takeoff from the highway, high density altitude, the downdrafts, and the sign.NTSB IAD05LA123Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Smoketown, PAA loss of engine power during the climb for undetermined reasons, resulting in a forced landing.NTSB DEN05LA127Accident · No injuriesLimited investigationFinal reportCessna 172N · Cedar City, UTthe loss of engine power for reasons undetermined. Contributing factors include the lack of suitable terrain for a forced landing, and the soft dirt.NTSB ATL05FA148Accident · 2 fatalField investigationFinal reportBeech A36 · Jamestown, TNThe pilot's decision to continue flight into an area of known thunderstorm activity, which resulted in loss of aircraft control and collision with trees and the ground during the result uncontrolled descent.NTSB ATL05CA147Accident · Minor injuriesData collectionFinal reportCessna 172G · Ridgeland, SCThe loss of engine power for undertermined reasons which resulted in a collision with objects.NTSB LAX05LA270Accident · Serious injuriesLimited investigationFinal reportPrescott Aeronautical Pusher · Redding, CAthe in-flight separation of the propeller for undetermined reasons.NTSB LAX05LA267Accident · No injuriesLimited investigationFinal reportBarnes Lancair Legacy · Groveland, CAThe inaccurate fuel quantity sensors and the pilot's failure to verify the fuel quantity on board prior to takeoff, which resulted in fuel exhaustion.NTSB ATL05CA143Accident · No injuriesData collectionFinal reportCessna 402B · Alabaster, ALThe loss of engine power for undetermined reasons.NTSB SEA05LA170Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Challis, IDThe installation of an improper oil gasket by maintenance personnel, which resulted in a loss of engine oil and subsequent loss of engine power during the emergency descent.NTSB MIA05LA149Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Fort Lauderdale, FLThe reported loss of engine power from the left engine, and the failure of the left propeller to feather for undetermined reasons, resulting in the inability to maintain altitude, and subsequent ditching.NTSB IAD05FA121Accident · 1 fatalField investigationFinal reportCessna 150M · Wht Sulfur Sprg, NYThe pilot's inadequate visual lookout during a precautionary landing, which resulted in collision with a wire and terrain. Factors in the accident were the pilot's inadequate in-flight planning which resulted in his becoming lost/disoriented, and a low fuel…NTSB LAX05LA266Accident · No injuriesLimited investigationFinal reportAgusta SF 260D · Redding, CAthe company maintenance personnel's failure to follow a prescribed canopy installation procedures.NTSB DFW05CA210Accident · No injuriesData collectionFinal reportMcCain RV-8 · Stephenville, TXThe loss of fuel pressure and subsequent loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI05CA222Accident · No injuriesData collectionFinal reportCessna 150L · Hillsboro, ILThe improper preflight planning/preparation by the pilot and fuel exhaustion during cruise flight.NTSB DEN05FA125Accident · 2 fatalField investigationFinal reportCessna 177B · Centennial, WYthe pilot's improper in-flight planning/decision, in that he failed to maintain a steady state climb rate to a safe altitude and continued flight towards visible weather that obstructed his chosen route of flight, and his failure to maintain terrain…NTSB CHI05LA217Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Mountain View, MOThe loss of engine power for undetermined reasons during climb after takeoff.NTSB ATL05FA142Accident · 1 fatalField investigationFinal reportBeech V35B · Ellijay, GAThe pilot's continued cruise flight under visual flight rules into known adverse weather, which resulted in his loss of control of the airplane due to spatial disorientation, and an uncontrolled descent and collision with terrain. A factor associated with the…NTSB NYC05LA130Accident · Minor injuriesLimited investigationFinal reportRaytheon A36 · Nashua, NHThe pilot's inadequate preflight planning, which resulted in a loss of engine power due to fuel exhaustion, and subsequent collision with trees during a forced landing.NTSB MIA05LA147Accident · No injuriesLimited investigationFinal reportCessna T210M · Kissimmee, FLA loss of engine power due to the pilot's inaccurate fuel consumption calculations and subsequent fuel exhaustion.NTSB CHI05LA220Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · New Boston, ILThe loss of engine power due to a cylinder failure and the unsuitable terrain encountered by the pilot during the forced landing.NTSB CHI05CA172Accident · No injuriesData collectionFinal reportWaco CTO · Shelbyville, ILThe loss of engine power during cruise due to carburetor ice. A factor was conditions conducive to carburetor icing.NTSB NYC05LA129Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Penn Yan, NYThe loss of engine power due to a fatigue fractured pushrod.NTSB SEA05LA161Accident · No injuriesLimited investigationFinal reportCessna A185F · Seattle, WALoss of engine power for undetermined reasons.NTSB ANC05FA121Accident · 2 fatalField investigationFinal reportBeech V35B · Denali Park, AKThe pilot's failure to maintain altitude/clearance from mountainous terrain while climbing, and his improper in-flight decision making by electing to fly at a low altitude toward rising terrain. A factor associated with the accident was mountainous terrain.NTSB SEA05LA163Accident · No injuriesLimited investigationFinal reportSteele Safari · Leavenworth, WAThe failure of the tail rotor drive shaft during cruise flight. Factors include soft, grassy terrain at the location where the pilot executed the autorotational landing.NTSB IAD05LA114Accident · 2 fatalLimited investigationFinal reportConvair BT-13A · Lyme, NHThe pilot's improper fuel management which resulted in an incorrect fuel selector position, fuel starvation, and subsequent loss of engine power. A factor in the accident was the pilot's failure to maintain adequate airspeed and inadvertent stall.NTSB LAX05LA253Accident · Serious injuriesLimited investigationFinal reportMalechek Q-200 · Delano, CAthe in-flight delamination and separation of a propeller blade for undetermined reasons.