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 NYC01IA046Incident · Minor injuriesIncident investigationFinal reportMooney M20C · Hazard, KYThe incorrect routing of the cabin air scat tubing by an unknown person, which resulted in a carbon monoxide leak into the cabin, and subsequent pilot incapacitation.NTSB LAX01LA047Accident · Serious injuriesLimited investigationFinal reportWsk Pzl Warzawa-Okecie PZL-104 Wilga 80 · Kaunakakai, HIThe pilot's improper assessment of in-flight weather conditions, his inadequate compensation for winds, and his failure to maintain sufficient altitude and clearance on the lee side of mountainous terrain.NTSB IAD01IA017Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-82 · Dulles, VAthe operator's inadequate maintenance procedure to disconnect the Omega navigational system, which resulted in coaxial cables being cut and not properly protected. A factor in the incident was the lightning strike.NTSB DCA01MA005Accident · Minor injuriesMajor investigationFinal reportDouglas DC-9 · Atlanta, GAthe leakage of lavatory fluid from the airplane's forward lavatory onto electrical connectors, which caused shorting that led to a fire. Contributing to the accident were the inadequate servicing of the lavatory and the failure of maintenance to ensure…NTSB NYC01LA044Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Zanesville, OHThe pilot's failure to follow the restart procedures published in the approved flight manual(AFM). Factors were his failure to follow the fuel management procedures published in the AFM, which resulted in fuel starvation.NTSB FTW01LA028Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Valley Spring, TXthe loss of engine power due to fuel exhaustion after the pilot became lost during cruise flight. A contributing factor was the dark night condition.NTSB FTW01LA026Accident · Minor injuriesLimited investigationFinal reportPiper PA-46-310P · Gainesville, TXthe loss of engine power due to improper splicing of the TIT thermocouple leads by unknown persons, which led to over temperature operation of the engine due to inaccurate TIT gauge readings. Contributing factors were the manufacturer's stamp on the top of…NTSB IAD01LA110Accident · Serious injuriesLimited investigationFinal reportBoeing 767 · Boston, MAThe airplane's inadvertent encounter with severe turbulence.NTSB FTW01FA025Accident · 1 fatalField investigationFinal reportCessna 172N · Katy, TXthe failure of both pilot's to maintain visual lookout during cruise flight. A contributory factor was the sun glare, which obscured the Cessna 150 pilot's visual lookout.NTSB IAD01IA019Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-11 · Newark, NJa short in the left inboard elevator parallel engage solenoid valve for undetermined reasons.NTSB IAD01LA016Accident · Serious injuriesLimited investigationFinal reportBellanca BL-17-30A · Union, CTpilot's mismanagement of the available fuel supply, which resulted in a loss of engine power due to fuel starvation.NTSB DEN01LA017Accident · 1 fatalLimited investigationFinal report2000 McCoy Genesis · Fort Collins, COFailure of an airframe stringer due to improper construction by the builder/pilot which rendered the aircraft uncontrollable. A factor was failure by the builder pilot to follow procedures and secure the engine prior to deploying the aircraft recovery…NTSB MIA01LA032Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Wewahitchka, FLa loss of engine power due to the number 5 cylinder connecting rod separating at the rod cap, resulting in a forced landing and subsequent impact with rough uneven terrain.NTSB MIA01LA031Accident · Serious injuriesLimited investigationFinal reportLake LA-4-200 · Iuka, MSa loss of engine power due to fuel contamination resulting in fuel starvation, a forced landing and the subsequent in-flight collision with a wire.NTSB MIA01LA030Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR-72-212 · Ashevelle, NCthe flight encountered forecasted turbulence, which resulted in serious injury to a flight attendant. Factors in this accident were; the captain's inadequate briefing to the cabin crew; and the insufficient information about the known turbulence that would be…NTSB MIA01FA029Accident · 1 fatalField investigationFinal reportAirbus Industrie A300B4-605R · Miami, FLThe failure of the flight crew to perform the cabin pressurization manual control abnormal checklist after experiencing a pressurization system malfunction and switching to manual pressurization control, and the failure of the flight crew to perform the…NTSB FTW01LA022Accident · No injuriesLimited investigationFinal reportCessna 172K · Belcher, LAthe total loss of engine power due to carburetor ice. Contributing factors were the weather conditions conducive to carburetor icing and the lack of suitable terrain available for the forced landing.NTSB LAX01LA045Accident · Serious injuriesLimited investigationFinal reportCollette Glassair III · Guistine, CAMaintenance personnel misrouted the crankcase breather hose so that it was pinched when the cowling was installed. This pressurized the crankcase displacing the oil seal and forcing oil out of the engine. A factor was the unsuitable terrain encountered during…NTSB DEN01LA016Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Wendover, UTa forced landing to unsuitable terrain due to a loss of engine power as a result of carburetor icing. Factors were insufficient weather information regarding carburetor icing in the pilot's operating handbook for the aircraft and delay by the pilot in…NTSB SEA01LA023Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Stevensville, MTFatigue of the right propeller blade resulting in an in-flight separation of the blade tip. A contributing factor was the improper maintenance procedure.NTSB SEA01FA021Accident · 1 fatalField investigationFinal reportPiper PA-22-135 · Ontario, OROverstress loading to the left wing lift strut resulting in the left wing folding upward during the initial climb.NTSB FTW01FA021Accident · 1 fatalField investigationFinal reportEurocopter AS350B2 · Houston, TXthe pilot's failure to maintain obstacle clearance while maneuvering, which resulted in an in-flight collision with objects. Contributing factors were the dark night and low ceilings.NTSB LAX01LA043Accident · No injuriesLimited investigationFinal reportCessna 210K · Oxnard, CAFailure of the internal cam gear in the remanufactured engine. A factor was the congested obstacles in the forced landing area.NTSB ANC01LA018Accident · Serious injuriesLimited investigationFinal reportBoeing 737-790 · Anchorage, AKAn in-flight encounter with clear air turbulence.NTSB LAX01LA040Accident · No injuriesLimited investigationFinal reportCessna 150E · Marana, AZThe partial loss of engine power during cruise flight due to an improper maintenance adjustment to the float valve retractor clip of the carburetor. Factors were the lack of suitable terrain for a forced landing and high vegetation.NTSB CHI01LA037Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Kankakee, ILThe unsuitable terrain encountered by the pilot during the emergency landing. Factors to the accident were the loss of engine power due to the failure of the crankshaft, the pilot misjudging the descent glide path, and the presence of the highway embankment…NTSB IAD01FA013Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Stuart, VAPilot's continued flight into known adverse weather conditions during cruise flight. Factors in the accident were the low ceiling, dark night, and the pilot's failure to obtain in-flight weather advisories.NTSB SEA01FA015Accident · 2 fatalField investigationFinal reportCessna 152 · Corvallis, ORThe pilot's failure to maintain clearance from the terrain. Factors include a dark night, densely forested, hilly terrain near the planned route of flight, and low ceilings in the area of the accident.NTSB SEA01LA014Accident · Serious injuriesLimited investigationFinal reportBoeing 767-332ER · Portland, ORAn inflight encounter with turbulence that occurred before flight attendants could finish stowing a beverage cart and return to their seats.NTSB NYC01LA026Accident · Serious injuriesLimited investigationFinal reportDever Firefly · Berlin, NJA loss of power for undetermined reasons.NTSB NYC01LA028Accident · No injuriesLimited investigationFinal reportBeech A-36 · Millersburg, OHThe pilot' failure to properly manage the available fuel onboard, which result in fuel starvation, and a loss of engine power.NTSB FTW01LA018Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Almyra, ARthe loss of engine power due to the crankshaft idler gear's loose lower retaining screw, which resulted in the fatigue failure of the crankshaft idler gear's upper retaining screw.NTSB CHI01LA030Accident · No injuriesLimited investigationFinal reportAviat Pitts S-2B · Worth, ILThe pilot's inadequate preflight of the airplane and his failure to verify the fuel supply on board, which resulted in fuel exhaustion. Factors associated with the accident were the low altitude at which the power loss occurred and the lack of suitable…NTSB MIA01FA021Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Zolfo Springs, FLThe loss of engine power for undetermined reasons, which resulted in the pilot executing a forced landing to an open field, and the aircraft subsequently impacting a tree during the landing rollout.NTSB SEA01LA010Accident · No injuriesLimited investigationFinal reportCessna 150C · Sunnyslope, WAThe pilot's decision not to deviate to an alternate airport for fuel after encountering strong headwinds, resulting in fuel exhaustion. Factors contributing to the accident were the unfavorable winds and the sign impacted during the forced landing rollout.NTSB FTW01FA017Accident · 1 fatalField investigationFinal reportAerospatiale AS-350BA · E. Cameron 200the loss of engine power due to an internal engine oil leak that started an internal engine fire and the pilot's inadequate autorotation which resulted in a hard landing. A contributing factor to the accident was the rough water condition.NTSB NYC01LA027Accident · No injuriesLimited investigationFinal reportO Loughlin WAG-A-BOND · Greenville, METotal loss of engine power for undetermined reasons.NTSB NYC01IA024Incident · No injuriesIncident investigationFinal reportBombardier CL-600 · Falmouth, KYThe wake turbulence of another heavy airplane.NTSB LAX01FA026Accident · 2 fatalField investigationFinal reportCessna 340A · Julian, CATotal blockage of the instrument static system due to ice.NTSB LAX01LA022Accident · Serious injuriesLimited investigationFinal reportBeech 35B33 · Bullhead City, AZThe pilot's inadequate in-flight planning that resulted in fuel starvation and a loss of engine power, and his failure to engage the fuel boost pump in accordance with the owner's manual. A factor was rough terrain in the forced landing area.NTSB LAX01FA023Accident · 2 fatalField investigationFinal reportMooney M-20J · Wheaton Springs, CAThe pilot's inadequate weather evaluation and attempted VFR flight into IMC, which resulted in the in-flight collision with mountainous terrain.NTSB IAD01IA009Incident · No injuriesIncident investigationFinal reportRaytheon 400A · Morristown, NJThe failure of several relays on the roll trim control printed circuit board, which caused an uncommanded aileron trim input.NTSB LAX01LA025Accident · Serious injuriesLimited investigationFinal reportAerospatiale AS350BA · Kamuela, HIA total loss of engine power due to the failure of the engine manufacturer's repair station personnel to install a circlip during engine overhaul, which resulted in the turbine assembly aft support bearing becoming dislodged and seized on the shaft. A factor…NTSB CHI01LA029Accident · Minor injuriesLimited investigationFinal reportFowler Varieze · Iowa City, IAthe inadequate preflight by the pilot which resulted in the fuel drain remaining partially open. Factors to the accident were the loss of engine power due to fuel starvation, the partially open fuel drain, the unsuitable terrain for landing encountered by the…NTSB NYC01FA021Accident · 3 fatalField investigationFinal reportBeech BE-23-24 · Kingston, OHThe pilot's failure to check both fuel tanks visually during the preflight inspection. A factor in the accident was the dark night.NTSB MIA01LA017Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Daytona Beach, FLan inadvertent inflight collision with a bird during cruise flight that resulted in substantial damage to the airplane.NTSB IAD01LA008Accident · Minor injuriesLimited investigationFinal reportConn Sonerai II · Manassas, VAFuel starvation of the engine, caused by the fracturing of the fuel pump switches during a turbulence encounter.NTSB IAD01LA007Accident · No injuriesLimited investigationFinal reportCessna 140 · Mcclure, PAThe loss of engine power over unsuitable terrain due to fuel starvation from a fuel strainer blocked with sealant particles.NTSB IAD01FA006Accident · No injuriesField investigationFinal reportBritish Aerospace Jetstream 3201 · Dulles, VAThe manufacturer's lack of dimensional inspection and repair requirements for the gearbox forward and aft diaphragm, which caused the bull gear to shift and resulted in an uncontained separation of the bull gear during flightNTSB FTW01LA016Accident · Serious injuriesLimited investigationFinal reportSteven R. Jackson Harmon Rocket 2 · Houston, TXThe collapsing of the inner liner of the induction air hose, resulting in a restriction of airflow to the engine and subsequent loss of engine power. A factor was the lack of suitable terrain for the forced landing.