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 LAX91LA389Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Hesperia, CAA stuck exhaust valve due to the operator's non compliance with a manufacturers recommended service bulletin on the engine. Contributing to the accident was the lack of suitable terrain for a safe landing.NTSB DCA91MA052Accident · 14 fatalClass 1 · MajorFinal reportEmbraer 120 · Eagle Lake, TXThe failure of Continental express maintenance and inspection personnel to adhere to proper maintenance and quality assurance procedures for the airplane's horizontal stabilizer deice boots that led to the sudden in-flight loss of the partially secured left…NTSB CHI91FA291Accident · 2 fatalField investigationFinal reportBeech 95 · Killdeer, NDThe pilot's disregarding the weather forecast; his improper in-flight decision to continue a VFR flight into instrument meteorological conditions; and his failure to maintain adequate clearance from terrain. The mountainous hilly terrain and low ceiling were…NTSB ANC91LA146Accident · No injuriesLimited investigationFinal reportHughes 369D · Iliamna, AKWas fuel exhaustion due to the pilot-in-command's improper preflight planning. Contributing to the accident was the rough and uneven tundra landing site.NTSB LAX91FA386Accident · Serious injuriesField investigationFinal reportCessna 172K · Bullhead City, AZ1) A short circuit, 2) electrical overload which ignited the cabin interior, 3) inadequate electrical circuit protection, and 4) insufficient electrical system design standards.NTSB BFO91LA080Accident · No injuriesLimited investigationFinal reportCessna 152 · Croom, MDThe pilot's failure to assure an adequate fuel supply was on board to complete the flight which resulted in fuel exhaustion.NTSB LAX91LA385Accident · 1 fatalLimited investigationFinal reportCessna C-310B · San Pedro, CAAn inflight loss of control for undetermined reasons.NTSB CHI91LA290Accident · No injuriesLimited investigationFinal reportCessna 152 · Minneapolis, KSThe pilot's failure to assure an adequate fuel supply was on board the airplane which resulted in fuel exhaustion. A factor related to the accident was inaccurate preflight planning.NTSB SEA91FA235Accident · 1 fatalField investigationFinal reportPiper PA32RT-300T · Mayfield, UTPoor in flight planning/decision. Factors to the accident were: flight into known adverse weather, inadvertent VFR flight into IMC and inadequate clearance.NTSB NYC91LA229Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Somerville, NJAn off airport landing in unsuitable terrain following a power loss due to oil exhaustion. A factor related to the accident was the operators decision not to follow the recommendations of the Piper cherokee service manual.NTSB BFO91LA079Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Fallston, MDThe pilot's failure to accurately determine the fuel quantity before his flight and monitor the quantity during the flight, which resulted in fuel exhaustion due to an inadequate fuel supply.NTSB LAX91LA382Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Redwood City, CAThe fatigue failure of the number two connecting rod and rod cap due to an engine overspeed condition which the rods and rod caps were exposed at some undetermined historical point.NTSB LAX91LA381Accident · No injuriesLimited investigationFinal reportCessna C-210 · Calexico, CAA non-mechanical loss of engine power due to fuel starvation from the pilot's improper use of the fuel supply.NTSB CHI91LA282Accident · 1 fatalLimited investigationFinal reportPiper PA-22-150 · Emporia, KSThe pilot's VFR flight into instrument meteorological conditions (IMC), and his delay in taking remedial action. The weather (fog) was a related factor.NTSB BFO91FA078Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Sod, WVThe improper level off which resulted in a hard landing. Contributing was fuel starvation resulting in partial loss of engine power.NTSB MIA91GA211Accident · 1 fatalFinal reportRobinson R-22 Beta · Lake City, FLThe pilot's failure to maintain a visual lookout due to his diverted attention to observe and enter the location of an illegal marijuana patch into the on board loran unit.NTSB BFO91LA077Accident · No injuriesLimited investigationFinal reportCessna 150 · Atlantic Ocean (Atlantic Ocean)The pilot became lost over the Atlantic Ocean and flew until the fuel supply was exhausted.NTSB MIA91IA207Incident · Minor injuriesIncident investigationFinal reportAirbus Industrie A-300-600R · Atlantic Ocean (Atlantic Ocean)The in flight encounter with turbulence, and the failure of the passengers to comply with instructions to return to their seats and utilize their seatbelts.NTSB CHI91LA275Accident · Minor injuriesLimited investigationFinal reportBeech B23 · Jenison, MIFailure of the pilot to perform remedial action during fuel system carburetor icing.NTSB MIA91LA206Accident · Serious injuriesLimited investigationFinal reportFriling Amtr · Land O' Lakes, FLThe poor in flight decision of the pilot to fly near thunderstorms and their associated turbulence resulting in an uncontrolled descent and in flight collision with terrain.NTSB CHI91LA274Accident · No injuriesLimited investigationFinal reportCessna 150 · Camden, MIPartial power loss due to improper use of the carburetor heat control by the pilot. Factors related to the accident were inadequate visual lookout by the pilot and presence of static power lines.NTSB BFO91LA076Accident · No injuriesLimited investigationFinal reportCessna A188B · New Market, MDInadequate preflight by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor related to the accident was: the inoperative fuel quantity gages.NTSB LAX91LA371Accident · No injuriesLimited investigationFinal reportCessna 152 · Avalon, CAA loss of engine power for undetermined reasons and subsequent ditching while flying over the ocean.NTSB LAX91LA369Accident · No injuriesLimited investigationFinal reportHiller UH12D · Sparks, NVThe encounter with rough, unsuitable terrain during a precautionary landing. Contributing to the accident was the pilot's decision to make an autorotation after encountering an airframe vibration.NTSB FTW91FA158Accident · Serious injuriesField investigationFinal reportBeech K35 · Tulsa, OKTotal power loss due to failure of the crankshaft bearings and connecting rod cap bolts resulting from the maintenance facilities' failure to overhaul the engine. A factor was the lack of suitable terrain for the forced landing.NTSB SEA91LA221Accident · Minor injuriesLimited investigationFinal reportCessna C-210L · Cheyenne, WYMaintenance personnel did not perform a proper top overhaul. This resulted in engine failure due to the failure of a connecting rod bearing. Factors include the hard landing resulting from the premature landing flare by the pilot.NTSB NYC91LA219Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Meadville, PAEngine failure resulting from the fatigue failure of the number 2 cylinder exhaust valve and the subsequent forced landing at night. A factor related to the accident was the restricted visibility.NTSB CHI91LA270Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Watertown, SDAttempted formation flying with N4535E by the pilot of N16098. Factors associated with the collision were: nonperformance of preflight planning, and failure to follow procedures and directives by the pilot of N16098.NTSB SEA91FA220Accident · 3 fatalField investigationFinal reportBellanca 17-30A · Arlington, WYThe loss of engine power for an undetermined reason. Factors contriubting to the accident were trees and the pilot's failure to maintain adequate clearance above the trees.NTSB LAX91LA367Accident · No injuriesLimited investigationFinal reportCessna R182 · Fredonia, AZFailure of the carburetor mixture control, resulting in loss of engine power. A factor related to the accident was: lack of compliance with marvel-schebler service bulletin (sb) #A1-78.NTSB FTW91LA153Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Haskell, OKImproper installation of avionics equipment resulting in interference with flight control.NTSB SEA91IA219Incident · Minor injuriesIncident investigationFinal reportBoeing 747-151 · Seattle, WAA fire in the number 4 engine, resulting from a fuel leak at the main fuel control unit, due to improper maintenance by unknown/undetermined person. The L5 emergency exit failed to operatee due to a broken plastic pulley guard in the slide release mechanism.NTSB SEA91LA217Accident · Serious injuriesLimited investigationFinal reportBeech B24R · Shady Cove, ORImproper re-installation of an oil line by maintenance personnel, which resulted in an oil leak from a loose line and subsequent seizure of the engine. Uneven terrain in the emergency landing area was a related factor.NTSB FTW91LA151Accident · Minor injuriesLimited investigationFinal reportBeech A23-24 · Tomball, TXThe total loss of engine power for undetermined reasons. A factor in the accident was the unsuitable terrain at the pilot's disposal.NTSB SEA91FA216Accident · 4 fatalField investigationFinal reportPilatus Britten-Norman BN-2A-26 Islander · Ketchikan, AKThe pilot's attempting to operate VFR in instrument meteorological conditions. Factors contributing to the accident were upsloping terrain in the aircraft's flight path as well as weather conditions resulting in an obscuration of the terrain.NTSB SEA91LA212Accident · No injuriesLimited investigationFinal reportCessna U206F · Nimrod, ORThe fractured crankshaft resulting in engine seizure followed by a forced landing on rough and uneven terrain resulting in separation of the nose gear.NTSB LAX91LA361Accident · No injuriesLimited investigationFinal reportCessna 172G · Hilo, HIFuel exhaustion due to the installation of a non standard propeller for which no performance charts were available.NTSB SEA91LA210Accident · 1 fatalLimited investigationFinal reportWeyerts Rans S-10 · Stanwood, WAAn undetermined loss of engine power and the pilot's allowing the airspeed to decelerate below the stall speed during the subsequent forced landing.NTSB MIA91IA199Incident · Minor injuriesIncident investigationFinal reportBritish Aerospace BA-3100 · Fort Myers, FLThe physiological incapacitation of the captain and his loss of consciousness due to a syncopal pleural event.NTSB DEN91FA116Accident · 1 fatalField investigationFinal reportCessna 182N · Climax, COImproper in-flight planning/decision by the non-rated pilot and his failure to maintain adequate airspeed, which resulted in a stall. A factor related to the accident was: the pilot's lack of qualification.NTSB NYC91LA211Accident · No injuriesLimited investigationFinal reportCessna 150 · Sharon, OHThe improper use of carburetor heat by the pilot, which resulted in a loss of engine power and subsequent forced landing on rough terrain. A factor related to the accident was the lack of total flight experience of the student pilot.NTSB ATL91FA161Accident · 3 fatalField investigationFinal reportCessna 402B · Kathleen, GAThe pilot's failure to maintain aircraft control while descending at night. Factors related to the accident were: darkness, fog, the pilot's lack of qualification in multi-engine aircraft, his lack of experience in this type of aircraft, his overconfidence in…NTSB SEA91FA207Accident · 6 fatalField investigationFinal reportPiper PA-32 · Gustavus, AKVFR flight by the pilot into instrument meteorological conditions (IMC), and the pilot's failure to maintain sufficient altitude and/or clearance from mountainous terrain. Factors related to the accident were: the adverse weather and terrain conditions.NTSB LAX91LA358Accident · No injuriesLimited investigationFinal reportBeech J35 · San Jose, CAThe failure of the crankshaft counterweight retaining clip due to improper maintenance installation of the part.NTSB ATL91LA158Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Waxhaw, NCThe spatial disorientation experienced by the pilot in IMC, his failure to maintain aircraft control, and the exceeding of the design stress limits of the aircraft. Factor(s) in this accident were: the pilot's inadequate preflight planning, the VFR flight…NTSB FTW91FA147Accident · 3 fatalField investigationFinal reportBeech 35-C33 · Dalhart, TXThe pilot's flight into known adverse weather. Factors were the pilot's lack of instrument experience and existing weather conditions.NTSB CHI91LA230Accident · No injuriesLimited investigationFinal reportCessna 172 · Metropolis, ILMiscellaneous equipment not removed (foam rubber) and inadequate preflight by the pilot.NTSB NYC91LA207Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Bear Mountain, NYThe pilot's improper preflight and planning, which resulted in fuel exhaustion and a forced landing in water.NTSB CHI91MA260Accident · No injuriesMajor investigationFinal reportBritish Aerospace 3201 · St Louis, MOFailure of the pilot(s) to follow the correct emergency procedure. Factors related to this accident were: inadequate system design by the manufacturer, which allowed hydraulic line vibration, fatigue failure of the line, and loss of fluid from the normal…NTSB LAX91LA353Accident · No injuriesLimited investigationFinal reportCessna 172B · King City, CAThe total loss of engine power in cruise flight due to the failure of the number 3 cylinder exhaust valve, resulting in a forced landing, and subsequent nose over on landing roll out.