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 ANC92LA080Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Port Heiden, AKEngine power loss for undetermined causes. Contributing to the accident was the unsuitable terrain.NTSB MIA92LA126Accident · Minor injuriesLimited investigationFinal reportCessna T188C · Cross City, FLThe inadequate inspection for contamination of the aircraft fuel system after modification resulting in failure of the engine driven fuel pump due to contamination. Contributing to the accident was the improper modification of the fuel system which resulted…NTSB ATL92FA108Accident · 3 fatalField investigationFinal reportCessna 172B · Cherokee, NCThe failure of the pilot to maintain control of the aircraft as a result of spatial disorientation. The lack of total flight time, and rain in the accident area were factors in the accident.NTSB ANC92LA077Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-2-T · Alexander Creek, AKThe pilot's inadvertent deactivation of the engine's fuel supply by switching off the fuel shut off. Factor related to the accident was the soft mud in the forced landing area.NTSB LAX92LA216Accident · Minor injuriesLimited investigationFinal reportQuestair Venture · Ely, NVThe inadequate installation of the engine oil temperature/pressure transducer by the pilot/owner that resulted in a fatigue failure of the transducer mounting fitting in the engine oil system. The soft landing surface and the mountainous terrain in which the…NTSB ATL92LA105Accident · Minor injuriesLimited investigationFinal reportCessna 150E · N.Myrtle Beach, SCThe ostentatious display of the Piper cub's pilot caused the accident airplane's pilot to loose control and crash.NTSB ATL92FA107Accident · 1 fatalField investigationFinal reportMaule M-5-210C · Wetumpka, ALThe pilot's inadequate visual lookout, and his failure to maintain proper clearance from the transmission wires.NTSB ATL92FA106Accident · No injuriesField investigationFinal reportCessna 152 · Seale, ALA loss of engine power for undetermined reasons. A factor was the right seat pilot's selection of unsuitable terrain for the forced landing.NTSB LAX92LA214Accident · No injuriesLimited investigationFinal reportCobb Intl Exec 90 · Glendale, AZThe improper carburetor idle adjustment by company maintenance personnel. Contributing to this accident was the cfi's inability to attain adequate RPM and the soft dirt.NTSB FTW92LA139Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-CD · Van, TXFuel exhaustion engine power loss due to the pilot's failure to refuel. A factor was the lack of suitable terrain available for the forced landing.NTSB SEA92LA098Accident · No injuriesLimited investigationFinal reportSchweizer SGS-1-35C · Big Timber, MTAirspeed was not maintained. Factors to the accident were: no thermal lift and inadequate remedial action.NTSB FTW92FA133Accident · No injuriesField investigationFinal reportCessna 310K · Carswell Afb, TXLoss of power to both engines from fuel starvation and the improper selector positions of fuel tanks by the pilot. A factor was the pilot's failure to feather the propellers.NTSB SEA92LA102Accident · 1 fatalLimited investigationFinal reportBeech S35 · Davenport, WAPoor in flight planning/decision. Factors to the accident were: mountainous/hilly terrain and terrain clearance was not maintained.NTSB SEA92LA103Accident · No injuriesLimited investigationFinal reportE.E. Shilling Q-2 · Billings, MTAn undetermined loss of engine power.NTSB BFO92FA064Accident · 2 fatalField investigationFinal reportBeech 65 · Madison, VAThe pilot initiated VFR flight into known adverse weather conditions. Contributing to the accident was low ceiling, high terrain, and low altitude.NTSB ATL92LA103Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Manchester, GAThe inadequate in-flight planning by the pilot.NTSB FTW92LA142Accident · Serious injuriesLimited investigationFinal reportBoeing 737-200 · Palacios, TXThe flight's unexpected encounter with moderate turbulence.NTSB FTW92DRD01Accident · 1 fatalFinal reportAyres S2R · Hebert, LAThe pilot's failure to maintain adequate airspeed, resulting in an inadvertent stall and collision with terrain.NTSB BFO92LA061Accident · Serious injuriesLimited investigationFinal reportAerotek Pitts S-1S · Hopkinsville, KYThe failure of the number 2 oil ring in the number 4 engine cylinder resulting in oil leakage, loss of oil pressure, and engine power loss.NTSB NYC92GA092Accident · No injuriesFinal reportBeech BE-200 · Roanoke, VAA lightning strike which discharged through the right elevator.NTSB ATL92LA100Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Soccastee, SCThe pilot's mismanagement of his fuel in that he exhausted fuel in one tank, then failed to select the tank with fuel.NTSB CHI92LA148Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Olathe, KSThe in flight separation of the propeller tip. An associated factor is the rough and uneven terrain.NTSB SEA92LA095Accident · Minor injuriesLimited investigationFinal reportRyan ST-3KR · Anacortes, WALoss of engine power due to fatigue failure of the crankshaft counterweight cap screws and separation of the counterweight. A factor relating to the accident was the residential area and lack of suitable terrain for a forced landing.NTSB FTW92LA129Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Terrell, TXThe pilot's alcoholic impairment of efficiency and judgement which led to his inattention to the amount of fuel remaining in the left fuel tank, resulting in fuel starvation and a total loss of engine power. A factor in the accident was the existence of the…NTSB LAX92LA235Accident · No injuriesLimited investigationFinal reportMcquen Glassair III · Casa Grande, AZFuel starvation due to the pilot's misreading of a newly installed fuel selector panel with placards and a position pointer which were confusing. Factors in the accident were the confusing nature of the fuel panel and placard design and the school bus which…NTSB BFO92LA056Accident · No injuriesLimited investigationFinal reportCessna 150 · Warren, VTThe pilot's failure to select a safe altitude for flight in mountainous terrain. The downdraft was a factor.NTSB LAX92LA207Accident · 1 fatalLimited investigationFinal reportLawrence H. Macey Quicksilver GT500 · Perris, CAThe pilot's failure to maintain control of his airplane for undetermined reasons.NTSB CHI92DCG01Accident · Serious injuriesFinal reportCedric Lewellen Soneria II · Bolivar, MOThe pilot's improper preflight planning/preparation.NTSB ANC92FA069Accident · No injuriesField investigationFinal reportCessna 172 · Ruth Glacier, AKThe failure of the pilots of both airplanes to maintain an adequate visual lookout. Factors which contributed to the accident was the failure of the pilot of the CE-172 to become aware of and to use the listed frequency for inter aircraft communications, and…NTSB LAX92FA206Accident · 1 fatalField investigationFinal reportRobinson R-22B · Anaheim, CAThe total loss of engine power for undetermined reasons, and the pilot's failure to maintain adequate rotor RPM during the autorotation.NTSB CHI92LA146Accident · No injuriesLimited investigationFinal reportCessna 150F · Eldon, MOA binding exhaust valve resulting in a partial loss of engine power. Factors in the accident are rising terrain conditions, inadequate aircraft climb capability, and a ditch in the forced landing area.NTSB BFO92LA055Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Falmouth, KYThe pilot misjudged the airplane's altitude and distance in reference to the runway. Contributing to the accident was the fuel system leak.NTSB LAX92LA285Accident · No injuriesLimited investigationFinal reportSchweizer 1-36 · Hemet, CAThe pilot's inadvertent selection of unsuitable terrain for the precautionary landing. A factor in the accident was his failure to obtain a preflight weather briefing.NTSB LAX92LA203Accident · No injuriesLimited investigationFinal reportCessna 182K · Carefree, AZInadequate aircraft maintenance and the failure of the pilot to ensure that adequate engine oil was on board prior to departure.NTSB ATL92FA096Accident · 2 fatalField investigationFinal reportRobinson R-22 Beta · Mt. Pleasant, TNA divergence of the main rotor from its normal plane of rotation for an undetermined reason, which resulted in rotor contact to the cockpit area.NTSB NYC92FA090Accident · 1 fatalField investigationFinal reportBeech A36 · Southbury, CTThe failure of the pilot to monitor his fuel supply which resulted in a power loss due to fuel exhaustion and an inadvertent stall/spin as the pilot was maneuvering for a forced landing. Factors related to the accident was improper maintenance on the fuel…NTSB LAX92LA199Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Sun Valley, CA1) Fuel exhaustion due to improper preflight planning by the CFI and his failure to refuel the aircraft prior to departure on the accident flight, and 2) the cfi's misjudgement of the landing flare timing during the auto rotation.NTSB SEA92LA087Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Prineville, ORThe pilot in command delaying his decision to divert for fuel, overloading of the nose gear strut and the pilot in command's inability to maintain aircraft control subsequent to the nose wheel separation. Factors contributing to the accident were: the pilot…NTSB LAX92LA386Accident · 1 fatalLimited investigationFinal reportBeech A36 · Avalon, CAA loss of control due to pilot incapacitation for an undetermined reason(s).NTSB LAX92LA194Accident · Serious injuriesLimited investigationFinal reportPiper PA-31-325 · Independence, CAFuel starvation due to 1) the pilots inadequate preflight planning preparation, 2) the pilot's fuel system management, and 3) his operation of the aircraft with known deficiencies in the aircraft electrical system. Factors in the accident were: 1) the…NTSB CHI92LA139Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140D · Markham, ILThe result of an inadequate annual inspection by other maintenance personnel and, as a result, a total failure of the throttle linkage. A factor was the pilot overshot his intended emergency landing area, due to excessive speed.NTSB NYC92GA089Accident · No injuriesFinal reportMcdonnell Douglas 500E · Mount Zion, KYAn in-flight separation of the tail rotor assembly as the result of the loss of an abrasion strip from the leading edge of one of the tail rotor blades, which induced vibrational stresses high enough to initiate fatigue failure in the tail rotor gear box…NTSB CHI92LA137Accident · Serious injuriesLimited investigationFinal reportBell 47-G2A · Dousman, WIThe in-flight loss of the swash plate drive link bolt which allowed the swash plate drive assembly to disconnect.NTSB MIA92LA120Accident · No injuriesLimited investigationFinal reportBeech C35 · Scottsmoor, FLEncounter with clear air turbulence during cruise flight.NTSB DEN92LA047Accident · No injuriesLimited investigationFinal reportCessna 172RG · Elbert, COFailure of the crankshaft left accessory gear which resulted in a complete power loss. A factor was: lack of suitable terrain for a forced landing.NTSB LAX92LA192Accident · No injuriesLimited investigationFinal reportLaister Nugget · Bishop, CAThe pilot-in-command's improperly planned no-flap landing approach; failure to follow the checklist; and inadvertent gear retraction. Factors contributing to the accident were the buckling of the wing skin, cracking of the fuselage and the inoperative flaps.NTSB ATL92FA091Accident · 1 fatalField investigationFinal reportCessna 310R · Gatlinburg, TNThe pilot's continued VFR flight into IMC, and his failure to attain a proper altitude over high, mountainous terrain. Factors were the high terrain, and the fog, clouds, and obscuration at the accident site.NTSB ATL92FA090Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Burnsville, NCThe pilot's failure to adequately evaluate the weather information and his continued visual flight into instrument conditions, which resulted in a collision with high terrain. A factor was the dark night.NTSB ATL92LA089Accident · No injuriesLimited investigationFinal reportBeech 23A-19 · Orangeburg, SCThe deterioration of the exhaust muffler which resulted in an inflight fire.NTSB ATL92LA088Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Alto, GAThe pilot's mismangement of the fuel in that he delayed selection of a fuel tank with usable fuel, and the excessive final landing speed. Factors were the pilot's failure to extend the flaps and the rough/uneven terrain because of the railroad spur.